using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using Core.LgMes.Client.LgResMgt; using System.Threading; using Core.LgMes.Client.lgClassModel; using System.Collections; using System.Reflection; using CoreFS.CA06; using System.Diagnostics; using System.IO; using Infragistics.Win.UltraWinGrid; namespace Core.LgMes.Client.lgJobMgt { public partial class frmRequryZDInIron : Core.Mes.Client.Common.frmStyleBase { public frmRequryZDInIron() { InitializeComponent(); } private void frmRequryZDInIron_Load(object sender, EventArgs e) { this.dateTimePicker1.Text = System.DateTime.Today.ToString("yyyy-MM-dd") + " 00:00"; this.dateTimePicker2.Text = System.DateTime.Today.ToString("yyyy-MM-dd") + " 23:59"; RefreshGridIronIn(); } private string BuildSqlString() { string strBegTime = Convert.ToDateTime(this.dateTimePicker1.Value).ToString("yyyy-MM-dd"); string strEndTime = Convert.ToDateTime(this.dateTimePicker2.Value).ToString("yyyy-MM-dd"); string strWhere = ""; if (this.rdocheck.Checked) { if (Convert.ToDateTime(this.dateTimePicker1.Value) > Convert.ToDateTime(this.dateTimePicker2.Value)) { MessageBox.Show("开始时间不能大于结束时间！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return ""; } strWhere = string.Format(" where ARRIVETIME between " + "to_date('{0}', 'yyyy-MM-dd') and " + "to_date('{1}', 'yyyy-MM-dd')+1 ", strBegTime, strEndTime); } if (this.cbogroup.SelectedIndex != 4 && this.cbogroup.SelectedIndex != -1) { if (strWhere.IndexOf("where", 0) >= 0) strWhere += string.Format(" and substr(SHIFTCODE, length(SHIFTCODE),1) = '{0}' order by MISID desc", (this.cbogroup.SelectedIndex + 1)); else strWhere = string.Format(" where substr(SHIFTCODE, length(SHIFTCODE),1) = '{0}' order by MISID desc", (this.cbogroup.SelectedIndex + 1)); } else { strWhere += string.Format(" order by MISID desc"); } return strWhere; } private void RefreshGridIronIn() { string err = ""; string htWhere = BuildSqlString(); try { //hengxing //CallingMessage par = new CallingMessage(); //par.ServerName = "lgJobMgt"; //par.AssemblyName = "Core.LgMes.Server.lgJobMgt"; //par.ClassName = "Core.LgMes.Server.lgJobMgt.classIronJob"; //par.MethodName = "SelectzdInIronhistoryData"; //par.args = new object[] { htWhere }; DataSet ds = null;// (DataSet)ClientCommon._RemotingHelp.ExecuteMethod(par, out err); ultraDataSource1.Rows.Clear(); if (ds.Tables.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { ultraDataSource1.Rows.Add(new object[] { dr["MISID"].ToString(), dr["MOLIRNSOURCE"].ToString(), dr["STOVEID"].ToString(), dr["TFPOTID"].ToString(), dr["TFPOTGROSSWGT"].ToString(), dr["TFPOTTAREWGT"].ToString(), dr["TFPOTWGT"].ToString(), dr["IRONTEMPERATURE"].ToString(), dr["ARRIVETIME"].ToString(), dr["C"].ToString(), dr["SI"].ToString(), dr["MN"].ToString(), dr["P"].ToString(), dr["S"].ToString(), dr["ASN"].ToString(), ConvertShift("1",dr["SHIFTCODE"].ToString())+ ConvertShift("2",dr["SHIFTCODE"].ToString()), dr["OPTPERSONNEL"].ToString(), }); } if (ultraDataSource1.Rows.Count > 0) SetIronSum(); } } catch (Exception ex) { Console.WriteLine(ex.Message); } } private void ulbtnRef_Click(object sender, EventArgs e) { RefreshGridIronIn(); } private string ConvertShift(string flag, string shift) { string StrReturn = ""; if (flag == "1" & shift != "") { switch (shift.Substring(0, 1)) { case "1": StrReturn = "白"; break; case "2": StrReturn = "中"; break; case "3": StrReturn = "夜"; break; } } else if (flag == "2" & shift != "") { switch (shift.Substring(1, 1)) { case "1": StrReturn = "甲"; break; case "2": StrReturn = "乙"; break; case "3": StrReturn = "丙"; break; case "4": StrReturn = "丁"; break; } } else if (flag == "3" & shift != "") { switch (shift.Trim()) { case "白": StrReturn = "1"; break; case "中": StrReturn = "2"; break; case "夜": StrReturn = "3"; break; } } else if (flag == "4" & shift != "") { switch (shift.Trim()) { case "甲": StrReturn = "1"; break; case "乙": StrReturn = "2"; break; case "丙": StrReturn = "3"; break; case "丁": StrReturn = "4"; break; } } return StrReturn; } private void ultraButton1_Click(object sender, EventArgs e) { try { if (ultraGrid1.Rows.Count > 0) { string StrfileName = string.Format(System.Windows.Forms.Application.StartupPath + "\\{0}.xls", "铁运进铁记录"); this.ultraGridExcelExporter1.Export(this.ultraGrid1, StrfileName); ProcessStartInfo p = new ProcessStartInfo(StrfileName); p.WorkingDirectory = Path.GetDirectoryName(StrfileName); Process.Start(p); } else { MessageBox.Show("没有数据可导出！"); return; } } catch (Exception ex) { MessageBox.Show(ex.Message); } } /// /// 统计铁水重量 /// private void SetIronSum() { UltraGridBand band = this.ultraGrid1.DisplayLayout.Bands[0]; band.Summaries.Clear(); SummarySettings summary = band.Summaries.Add(SummaryType.Count, band.Columns[1]); summary.SummaryPosition = SummaryPosition.UseSummaryPositionColumn; summary.DisplayFormat = "合计："; for (int i = 5; i < 7; i++) { summary = band.Summaries.Add(SummaryType.Sum, band.Columns[i]); summary.SummaryPosition = SummaryPosition.UseSummaryPositionColumn; summary.DisplayFormat = " {0:#####.00}"; summary.Appearance.TextHAlign = Infragistics.Win.HAlign.Center; summary.Appearance.ForeColor = Color.DarkBlue; summary.Appearance.BackColor = Color.White; } band.Override.SummaryFooterCaptionVisible = Infragistics.Win.DefaultableBoolean.False; } private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e) { switch (e.Tool.Key) { case "Query": RefreshGridIronIn(); break; case "Output": try { if (ultraGrid1.Rows.Count > 0) { string StrfileName = string.Format(System.Windows.Forms.Application.StartupPath + "\\{0}.xls", "混铁炉进铁记录"); this.ultraGridExcelExporter1.Export(this.ultraGrid1, StrfileName); ProcessStartInfo p = new ProcessStartInfo(StrfileName); p.WorkingDirectory = Path.GetDirectoryName(StrfileName); Process.Start(p); } else { MessageBox.Show("没有数据可导出！"); return; } } catch (Exception ex) { MessageBox.Show(ex.Message); } break; case "Close": this.Close(); break; default: break; } } } }