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 Core.LgMes.Client.lgClassModel; using System.Collections; using System.Reflection; using CoreFS.CA06; namespace Core.LgMes.Client.lgJobMgt.弹出窗体 { public partial class frmZDInIron : Form { public double AllWeight = 0; public string Laiyuan = ""; public string stoveNo = ""; public ArrayList alZDInIron = new ArrayList(); public string str_C = "", str_Si = "", str_Mn = "", str_P = "", str_S = "", str_Asn = "", str_Cu = "", str_Sn = "", str_Sb = ""; public frmZDInIron() { InitializeComponent(); } private void frmZDInIron_Load_1(object sender, EventArgs e) { getInIronNoDate(); } private void getInIronNoDate() { string strOut = "", strWhere = ""; //string potid = this.Text.Substring(0, 1) + "#混铁炉"; strWhere = "where FOLDPOTWGT > 0 and to_char(ARRIVETIME, 'YYYYMMDDHH24MISS') BETWEEN " + " to_char((sysdate - 1 / 3), 'YYYYMMDDHH24MISS') and to_char(sysdate, 'YYYYMMDDHH24MISS') " + " and (substr(MolirnSource,1,1)<>'Z' and substr(MolirnSource,1,1)<>'N' or MolirnSource is null) "; try { //hengxing //CallingMessage par = new CallingMessage(); //par.ServerName = "lgJobMgt"; //par.AssemblyName = "Core.LgMes.Server.lgJobMgt"; //par.ClassName = "Core.LgMes.Server.lgJobMgt.classIronJob"; //par.MethodName = "GetZDInIronNoDate"; //par.args = new object[] { strWhere }; DataSet ds = null;// (DataSet)ClientCommon._RemotingHelp.ExecuteMethod(par, out strOut); ultraDataSource1.Rows.Clear(); if (ds.Tables.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { ultraDataSource1.Rows.Add(new object[] { Convert.ToBoolean(dr["flag"]), dr["MISID"].ToString(), dr["FOLDPOTWGT"].ToString(), dr["ZDWeight"].ToString(), "0", dr["STOVEID"].ToString(), dr["TFPOTID"].ToString(), dr["ARRIVETIME"].ToString(), dr["C"].ToString(), dr["Si"].ToString(), dr["Mn"].ToString(), dr["P"].ToString(), dr["S"].ToString(), dr["Asn"].ToString(), dr["Cu"].ToString(), dr["Sn"].ToString(), dr["Sb"].ToString()}); //dr["FOLDPOTWGT"].ToString() } } } catch { } } private void ulbtnCancel_Click(object sender, EventArgs e) { this.Close(); } private void ultraGrid1_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e) { switch (e.Cell.Column.Key) { case "OutWeight": { try { float a = Convert.ToSingle(ultraGrid1.ActiveRow.Cells["AllWeight"].Text != System.DBNull.Value.ToString() ? ultraGrid1.ActiveRow.Cells["AllWeight"].Text : "0"); float b = Convert.ToSingle(ultraGrid1.ActiveRow.Cells["OutWeight"].Text != System.DBNull.Value.ToString() ? ultraGrid1.ActiveRow.Cells["OutWeight"].Text : "0"); ultraGrid1.ActiveRow.Cells["ShengyuWeight"].Value = Convert.ToString(a - b); } catch { } break; } } } private void ulbtnOK_Click(object sender, EventArgs e) { AllWeight = 0; Laiyuan = ""; stoveNo = ""; string strError = ""; double dblIronSumWgt = 0; double dbl_C = 0, dbl_Si = 0, dbl_Mn = 0, dbl_P = 0, dbl_S = 0, dbl_Asn = 0, dbl_Cu = 0, dbl_Sn = 0, dbl_Sb = 0; try { foreach (Infragistics.Win.UltraWinGrid.UltraGridRow r in ultraGrid1.Rows) { if (r.Cells["Check"].Value.ToString().ToUpper() == "TRUE") { AllWeight = AllWeight+Convert.ToDouble(r.Cells["OutWeight"].Value) ; Laiyuan = r.Cells["InIronNo"].Value.ToString() + " " + Laiyuan; stoveNo = r.Cells["stoveno"].Value.ToString() + " " + stoveNo; dblIronSumWgt = AllWeight; //总共兑铁重量 dbl_C += Convert.ToDouble(r.Cells["OutWeight"].Value) * Convert.ToDouble(r.Cells["C"].Value); dbl_Si += Convert.ToDouble(r.Cells["OutWeight"].Value) * Convert.ToDouble(r.Cells["Si"].Value); dbl_Mn += Convert.ToDouble(r.Cells["OutWeight"].Value) * Convert.ToDouble(r.Cells["Mn"].Value); dbl_P += Convert.ToDouble(r.Cells["OutWeight"].Value) * Convert.ToDouble(r.Cells["P"].Value); dbl_S += Convert.ToDouble(r.Cells["OutWeight"].Value) * Convert.ToDouble(r.Cells["S"].Value); dbl_Asn += Convert.ToDouble(r.Cells["OutWeight"].Value) * Convert.ToDouble(r.Cells["Asn"].Value); string[] ArrayIronRow = new string[20] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "" }; //成分 ArrayIronRow[0] = r.Cells["InIronNo"].Value.ToString(); ArrayIronRow[1] = r.Cells["StoveNo"].Value.ToString(); ArrayIronRow[2] = r.Cells["GuanNo"].Value.ToString(); ArrayIronRow[3] = r.Cells["InIronTime"].Value.ToString(); ArrayIronRow[4] = r.Cells["AllWeight"].Value.ToString(); ArrayIronRow[5] = r.Cells["OutWeight"].Value.ToString(); ArrayIronRow[6] = r.Cells["ShengyuWeight"].Value.ToString(); alZDInIron.Add(ArrayIronRow); } } if (dblIronSumWgt > 0) { str_C = Convert.ToDouble(dbl_C / dblIronSumWgt).ToString("F3"); str_Si = Convert.ToDouble(dbl_Si / dblIronSumWgt).ToString("F3"); str_Mn = Convert.ToDouble(dbl_Mn / dblIronSumWgt).ToString("F3"); str_P = Convert.ToDouble(dbl_P / dblIronSumWgt).ToString("F3"); str_S= Convert.ToDouble(dbl_S / dblIronSumWgt).ToString("F3"); str_Asn = Convert.ToDouble(dbl_Asn / dblIronSumWgt).ToString("F3"); } if (strError != "") MessageBox.Show("修改记录失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch { } this.DialogResult = DialogResult.OK; } private void ultsaveHBdata_Click(object sender, EventArgs e) { string strError = ""; try { foreach (Infragistics.Win.UltraWinGrid.UltraGridRow r in ultraGrid1.Rows) { string[] ArrayIronRow = new string[20] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "" }; //记录混包数据 if (r.Cells["Check"].Value.ToString().ToUpper() == "TRUE") { ArrayIronRow[0] = r.Cells["InIronNo"].Value.ToString(); ArrayIronRow[1] = r.Cells["StoveNo"].Value.ToString(); ArrayIronRow[2] = r.Cells["GuanNo"].Value.ToString(); ArrayIronRow[3] = r.Cells["IronTime"].Value.ToString(); ArrayIronRow[4] = r.Cells["AllWeight"].Value.ToString(); ArrayIronRow[5] = r.Cells["OutWeight"].Value.ToString(); ArrayIronRow[6] = r.Cells["ShengyuWeight"].Value.ToString(); //Core.Mes.ClientFrameWork.ClientCommon._RemotingHelp.ExecuteMethod("lgJobMgt", "Core.LgMes.Server.lgJobMgt.classIronJob", "InsertZDHBData", new object[] { ArrayIronRow }, out strError); } } if (strError != "") MessageBox.Show("插入记录失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch { } } } }