using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Threading; using System.Collections; using System.Reflection; using CoreFS.CA06; using System.Diagnostics; using System.IO; using Infragistics.Win.UltraWinGrid; namespace Core.LgMes.Client.LgIntegrationQuery { public partial class frmIronElementsInfo : Core.Mes.Client.Common.frmStyleBase { public frmIronElementsInfo() { InitializeComponent(); } private void frmIronElementsInfo_Load(object sender, EventArgs e) { this.dateTimePicker1.Text = System.DateTime.Now.AddHours(-8).ToString("yyyy-MM-dd HH:mm") ; this.dateTimePicker2.Text = System.DateTime.Now.AddHours(1).ToString("yyyy-MM-dd HH:mm"); this.cbbMis.SelectedIndex = 2; RefreshGridIronIn(); } private string BuildSqlString() { string strBegTime = Convert.ToDateTime(this.dateTimePicker1.Value).ToString("yyyy-MM-dd HH:mm"); string strEndTime = Convert.ToDateTime(this.dateTimePicker2.Value).ToString("yyyy-MM-dd HH:mm"); 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 to_char(TAPHOLESTARTTIME,'yyyy-MM-dd HH24:mi')>= '{0}' and " + " to_char(TAPHOLESTARTTIME,'yyyy-MM-dd HH24:mi')<='{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}' ", (this.cbogroup.SelectedIndex + 1)); else strWhere = string.Format(" where substr(SHIFTCODE, length(SHIFTCODE),1) = '{0}' ", (this.cbogroup.SelectedIndex + 1)); } else { 　//strWhere += string.Format(" order by MISID desc"); } return strWhere; } private void RefreshGridIronIn() { string htWhere = BuildSqlString(); string strWsID = ""; if (this.cbbMis.Value.ToString() == "1") strWsID =" and WsID ='H1'"; else if (this.cbbMis.Value.ToString() == "2") strWsID = " and WsID ='Z1'"; try { //hengxing //CallingMessage par = new CallingMessage(); //par.ServerName = "lgIntegrationQuery"; //par.AssemblyName = "Core.LgMes.Server.LgIntegrationQuery"; //par.ClassName = "Core.LgMes.Server.lgIntegrationQuery.LgGeneralInfo"; //par.MethodName = "GetIronElementsInfo"; //par.args = new object[] { htWhere, strWsID }; DataSet ds = null;//hengxing (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["MOLIRNLEAVE"].ToString(), dr["IRONWRAPID"].ToString(), dr["IRONPOTGROSSWGT"].ToString(), dr["IRONPOTWGT"].ToString(), dr["IRONPOTTAREWGT"].ToString(), dr["IRONTEMPERATURE"].ToString(), dr["TAPHOLESTARTTIME"].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(), dr["IRONWRAPAGE"].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 = 3; i < 5; 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; } } } }