using System; using System.Data; using System.Drawing; using System.Windows.Forms; using System.Threading; using System.Collections; using CoreFS.CA06; using Core.Mes.Client.Common; using Core.LgMes.Client.Comm; using System.Diagnostics; using System.IO; namespace Core.LgMes.Client.LgJobMgt { public partial class frmBfIron : frmStyleBase { private Thread _getDataThread; // 取数据线程 private bool _bIfGetData = true; // 控制取数据线程循环的标志 private string[] ArrayIronRow = new string[20] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "" }; //保存铁运进铁数据 private string[] ArrayIronRow2 = new string[20] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "" }; //保存混铁炉进铁数据 private string[] ArrayIronRow3 = new string[25] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "" }; //保存混铁炉出铁数据 private string[] ArrayIronRow4 = new string[25] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "" }; //保存发送到转炉铁水数据 private string _strSendSucceededForBof1 = ""; private string _strSendSucceededForBof2 = ""; private string _strSendSucceededForBof3 = ""; private string _strSendSucceededForHmp1 = ""; private string _strSendSucceededForHmp2 = ""; private string _strHmp1No = ""; private string _strHmp2No = ""; private bool blModify = false; #region formload public frmBfIron() { InitializeComponent(); CheckForIllegalCrossThreadCalls = false; } private void frmBfIron_Load(object sender, EventArgs e) { try { this.dtpBegin.Text = System.DateTime.Today.ToString("yyyy-MM-dd") + " 00:00"; this.dtpEnd.Text = System.DateTime.Today.ToString("yyyy-MM-dd") + " 23:59"; dtpBegin.Enabled = false; dtpEnd.Enabled = false; cboShift.Enabled = false; ultratxtBfNo.Enabled = false; CStaticMethod.SetUltraGridStyle(ultragridInIronEdit, 1); //设置样式 ultragridInIron.DisplayLayout.CaptionVisible = Infragistics.Win.DefaultableBoolean.True; User = this.UserInfo.GetUserName();//操作人; SetUserControlDelegate(); ultraDataSource6.Rows.Add(new object[] { "", "", "", null, "", "", "", "", "", "", "", "", "" }); timer1_Tick(null, new EventArgs()); this.timer1.Start(); GetInIronData(); StartUpThread(); setbutton("1"); setucInIron("1"); SetColumnModeShift(ultragridInIronEdit); SetColumnModeGroup(ultragridInIronEdit); //SetColumnModequxiang(); SetColumnModeShift(ultragridInIron); SetColumnModeGroup(ultragridInIron); //ultragridBfIron.Rows[0].Cells["FOLDPOTWGT"].Hidden = true; //GetElementData(); } catch { } } #endregion #region Thread Handle /// /// 启动线程主程序 /// private void StartUpThread() { ThreadStart ts = new ThreadStart(GetDataThread); _getDataThread = new Thread(ts); _getDataThread.Name = "GetDataThread "; _getDataThread.Start(); } private string User = ""; /// /// 取数据线程程序 /// private void GetDataThread() { while (_bIfGetData) { if (!this.On_Off_Thread)//this.On_Off_Thread { System.Threading.Thread.Sleep(5000); continue; } try { //GetInIronData(); // GetRealData(); //GetCVTHeatno(); Thread.Sleep(10000); } catch { } } } #endregion #region dataevent /// /// 铁运进铁数据 ultraGrid2 /// private void GetInIronData() { string strErr = ""; string strBeginTime = ""; string strEndTime = ""; string strShiftCode = ""; string strBfNo = ""; try { //进铁时间 if (chkInIronDate.Checked) { if (Convert.ToDateTime(dtpEnd.Value).Date.Subtract(Convert.ToDateTime(dtpBegin.Value).Date).Days > 180) { MessageBox.Show("查询时间不可超过6个月。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (Convert.ToDateTime(dtpBegin.Value).Date > Convert.ToDateTime(dtpEnd.Value).Date) { MessageBox.Show("查询开始日期不能大于结束日期！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } strBeginTime = Convert.ToDateTime(dtpBegin.Value).ToString("yyyy-MM-dd HH:mm:ss"); strEndTime = Convert.ToDateTime(dtpEnd.Value).ToString("yyyy-MM-dd HH:mm:ss"); } else { strBeginTime = (DateTime.Now.AddHours(-6)).ToString("yyyy-MM-dd HH:mm:ss"); strEndTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); } //班次 if (chkShift.Checked) strShiftCode = cboShift.Value.ToString(); else strShiftCode = "0"; if (chkBfNo.Checked && !string.IsNullOrEmpty(ultratxtBfNo.Text.Trim())) strBfNo = ultratxtBfNo.Text.Trim(); else strBfNo = ""; ArrayList arry = new ArrayList(); arry.Add("GetInIronData.Select");//此ID为XML文件ID arry.Add(strBeginTime); arry.Add(strEndTime); arry.Add(strShiftCode); arry.Add(strShiftCode); arry.Add(strBfNo); arry.Add(strBfNo); arry.Add(strBfNo); CommonClientToServer ccTos = new CommonClientToServer(); ccTos.ob = this.ob; //查询高炉铁水信息 DataSet ds = ccTos.ExecuteQueryFunctions("Core.LgMes.Server.LgJobMgt.ClassHmpJob", "GetInIronData", arry, out strErr); if (strErr == "" && ds != null) { ultraDataSource2.Rows.Clear(); if (ds.Tables.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { ultraDataSource2.Rows.Add(new object[] { dr["MISID"].ToString(), dr["STOVEID"].ToString(), dr["STOVETIME"].ToString(), dr["TAPHOLENO"].ToString(), dr["TFPOTID"].ToString(), dr["TFPOTTAREWGT"].ToString(), dr["TFPOTGROSSWGT"].ToString(), dr["TFPOTWGT"].ToString(), dr["IRONTEMPERATURE"].ToString(), dr["CHECKNO"].ToString(), dr["C"].ToString(), dr["MN"].ToString(), dr["S"].ToString(), dr["P"].ToString(), dr["SI"].ToString(), dr["Sn"].ToString(), dr["As"].ToString(), dr["Cu"].ToString(), dr["Cr"].ToString(), dr["HSTAPHOLETIME"].ToString(), dr["ARRIVETIME"].ToString(), dr["shiftcode"].ToString().Substring(1,1), dr["shiftcode"].ToString().Substring(0,1), dr["OPTPERSONNEL"].ToString(), dr["OPERATIONDATE"].ToString(), dr["MEMO"].ToString(), dr["molirnsource"].ToString(), dr["C_P"].ToString(), dr["MN_P"].ToString(), dr["S_P"].ToString(), dr["P_P"].ToString(), dr["SI_P"].ToString(), dr["Sn_P"].ToString(), dr["As_P"].ToString(), dr["Cu_P"].ToString(), dr["Cr_P"].ToString(), dr["RSWGT"].ToString(), dr["BFIRONTEMTURE"].ToString(), dr["IRONTEMPERATURE2"].ToString() }); } } } else MessageBox.Show("铁运进铁详细信息查询失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } catch { } } private void RefreshHighheatNo() { int nFurnaceNo = 0; try { string strErr = ""; if (this.rdoFNo1.Checked) nFurnaceNo = 9; if (this.rdoFNo2.Checked) nFurnaceNo = 10; if (this.radioButton1.Checked) nFurnaceNo = 0; ArrayList arry = new ArrayList(); arry.Add("GetBfIronInfo.Select");//此ID为XML文件ID arry.Add(nFurnaceNo); arry.Add(nFurnaceNo); CommonClientToServer ccTos = new CommonClientToServer(); ccTos.ob = this.ob; //查询高炉铁水信息 DataSet ds = ccTos.ExecuteQueryFunctions("Core.LgMes.Server.LgJobMgt.ClassHmpJob", "GetBfIronInfo", arry, out strErr); int intIndex = 0; if (strErr == "" && ds != null) { ultradsBfIron.Rows.Clear(); if (ds.Tables.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { ultradsBfIron.Rows.Add(new object[] { dr["ID_"].ToString(), dr["STOVEID"].ToString(), dr["STOVETIME"].ToString(), dr["TAPHOLENO"].ToString(), dr["TFPOTID"].ToString(), dr["TFPOTTAREWGT"].ToString(), dr["TFPOTGROSSWGT"].ToString(), dr["TFPOTWGT"].ToString(), dr["TFIRONTEMP"].ToString(), dr["C"].ToString(), dr["MN"].ToString(), dr["S"].ToString(), dr["P"].ToString(), dr["SI"].ToString(), dr["Sn"].ToString(), dr["As"].ToString(), dr["Cu"].ToString(), dr["Cr"].ToString(), dr["Ti"].ToString(), dr["STATUS"].ToString().Trim()=="0"?"未确认":(dr["STATUS"].ToString().Trim()=="3"?"已确认":"异常"), dr["HSTAPHOLETIME"].ToString(), dr["ASSAYDATE"].ToString(), dr["HEATNO"].ToString(), dr["CHECKNO"].ToString(), }); if (ultragridBfIron.Rows[intIndex].Cells["STATUS"].Value.ToString() == "已确认") ultragridBfIron.Rows[intIndex].Cells["STATUS"].Appearance.BackColor = Color.LawnGreen; intIndex++; } } } } catch { return; } } private void InsertBFIronData() { string strSqlID = ""; //sqlId string strErr = ""; //错误信息 if (string.IsNullOrEmpty(ultragridInIronEdit.Rows[0].Cells["HighNo"].Text)) { MessageBox.Show("高炉号不可为空,请输入高炉号!"); return; } if (ultragridInIronEdit.Rows[0].Cells["InIronNo"].Text == "自动") { strSqlID = "InsertBFIronData.Insert"; //SQLID Hashtable ht = new Hashtable(); ht.Add("I1", ultragridInIronEdit.Rows[0].Cells["HighNo"].Text); //高炉炉号 ht.Add("I2", ultragridInIronEdit.Rows[0].Cells["stovetime"].Text); //高炉炉次 ht.Add("I3", ultragridInIronEdit.Rows[0].Cells["tapholeno"].Text); //出铁口 ht.Add("I4", ultragridInIronEdit.Rows[0].Cells["GuanNo"].Text); //铁罐罐号 ht.Add("I5", ultragridInIronEdit.Rows[0].Cells["LDKongWeight"].Text); //铁罐皮重 ht.Add("I6", ultragridInIronEdit.Rows[0].Cells["LDMaoWeight"].Text); //铁罐毛重 ht.Add("I7", ultragridInIronEdit.Rows[0].Cells["IronWeight"].Text); //铁水重量 ht.Add("I8", ultragridInIronEdit.Rows[0].Cells["Temptrue"].Text); //铁水温度 ht.Add("I9", ultragridInIronEdit.Rows[0].Cells["checkno"].Text); //铁水成分检验号 ht.Add("I10", ultragridInIronEdit.Rows[0].Cells["C"].Text); //C ht.Add("I11", ultragridInIronEdit.Rows[0].Cells["Mn"].Text); //MN ht.Add("I12", ultragridInIronEdit.Rows[0].Cells["S"].Text); //S ht.Add("I13", ultragridInIronEdit.Rows[0].Cells["P"].Text); //P ht.Add("I14", ultragridInIronEdit.Rows[0].Cells["Si"].Text); //SI ht.Add("I15", ultragridInIronEdit.Rows[0].Cells["hstapholetime"].Text); //高炉出铁时间 ht.Add("I16", ultragridInIronEdit.Rows[0].Cells["InIronTime"].Text); //入厂时间 ht.Add("I17", ConvertShift("3", ultragridInIronEdit.Rows[0].Cells["Group"].Text) + ConvertShift("4", ultragridInIronEdit.Rows[0].Cells["shift"].Text)); //班次班别 ht.Add("I18", ultragridInIronEdit.Rows[0].Cells["MEMO"].Text); //备注 ht.Add("I19", User); //操作人员 ht.Add("I20", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); //操作时间 ht.Add("I21", ultragridInIronEdit.Rows[0].Cells["RsWgt"].Text); //回炉钢水 改为铁包废钢 ht.Add("I22", ultragridInIronEdit.Rows[0].Cells["BFIRONTEMTURE"].Text); //高炉铁水温度 ht.Add("I23", ultragridInIronEdit.Rows[0].Cells["Temptrue"].Tag); //高炉铁水温度序号 ht.Add("I24", ultragridInIronEdit.Rows[0].Cells["Sn"].Text); //Sn ht.Add("I25", ultragridInIronEdit.Rows[0].Cells["As"].Text); //As ht.Add("I26", ultragridInIronEdit.Rows[0].Cells["Cu"].Text); //Cu ht.Add("I27", ultragridInIronEdit.Rows[0].Cells["Cr"].Text); //Cr ht.Add("I28", ultragridInIronEdit.Rows[0].Cells["IRONTEMPERATURE2"].Text); //平台温度2 ht.Add("O1", ""); ht.Add("O2", ""); CommonClientToServer ccTs = new CommonClientToServer(); ccTs.ob = ob; CoreClientParam ccp = ccTs.ExecuteProcedureFunctionsCCP("Core.LgMes.Server.LgJobMgt.ClassHmpJob", "InsertBFIronData", strSqlID, ht, out strErr); ArrayList alReturn = ccp.ReturnObject as ArrayList; if (strErr == "" && alReturn[3] == null) MessageBox.Show("高炉铁水信息确认成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); else MessageBox.Show("高炉铁水信息确认失败！" + alReturn[3], "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { strSqlID = "UpdateBFIronData.Update"; //SQLID Hashtable ht = new Hashtable(); ht.Add("I1", ultragridInIronEdit.Rows[0].Cells["HighNo"].Text); //高炉炉号 ht.Add("I2", ultragridInIronEdit.Rows[0].Cells["stovetime"].Text); //高炉炉次 ht.Add("I3", ultragridInIronEdit.Rows[0].Cells["tapholeno"].Text); //出铁口 ht.Add("I4", ultragridInIronEdit.Rows[0].Cells["GuanNo"].Text); //铁罐罐号 ht.Add("I5", ultragridInIronEdit.Rows[0].Cells["LDKongWeight"].Text); //铁罐皮重 ht.Add("I6", ultragridInIronEdit.Rows[0].Cells["LDMaoWeight"].Text); //铁罐毛重 ht.Add("I7", ultragridInIronEdit.Rows[0].Cells["IronWeight"].Text); //铁水重量 ht.Add("I8", ultragridInIronEdit.Rows[0].Cells["Temptrue"].Text); //铁水温度 ht.Add("I9", ultragridInIronEdit.Rows[0].Cells["checkno"].Text); //铁水成分检验号 ht.Add("I10", ultragridInIronEdit.Rows[0].Cells["C"].Text); //C ht.Add("I11", ultragridInIronEdit.Rows[0].Cells["Mn"].Text); //MN ht.Add("I12", ultragridInIronEdit.Rows[0].Cells["S"].Text); //S ht.Add("I13", ultragridInIronEdit.Rows[0].Cells["P"].Text); //P ht.Add("I14", ultragridInIronEdit.Rows[0].Cells["Si"].Text); //SI ht.Add("I15", ultragridInIronEdit.Rows[0].Cells["hstapholetime"].Text); //高炉出铁时间 ht.Add("I16", ultragridInIronEdit.Rows[0].Cells["InIronTime"].Text); //入厂时间 ht.Add("I17", ConvertShift("3", ultragridInIronEdit.Rows[0].Cells["Group"].Text) + ConvertShift("4", ultragridInIronEdit.Rows[0].Cells["shift"].Text)); //班次班别 ht.Add("I18", ultragridInIronEdit.Rows[0].Cells["MEMO"].Text); //备注 ht.Add("I19", User); //操作人员 ht.Add("I20", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); //操作时间 ht.Add("I21", ultragridInIronEdit.Rows[0].Cells["InIronNo"].Text); //进铁序号 ht.Add("I22", ultragridInIronEdit.Rows[0].Cells["RsWgt"].Text); //回炉钢水 改为铁包废钢 ht.Add("I23", ultragridInIronEdit.Rows[0].Cells["BFIRONTEMTURE"].Text); //高炉铁水温度 ht.Add("I24", ultragridInIronEdit.Rows[0].Cells["Temptrue"].Tag); //高炉铁水温度序号 ht.Add("I25", ultragridInIronEdit.Rows[0].Cells["Sn"].Text); //Sn ht.Add("I26", ultragridInIronEdit.Rows[0].Cells["As"].Text); //As ht.Add("I27", ultragridInIronEdit.Rows[0].Cells["Cu"].Text); //Cu ht.Add("I28", ultragridInIronEdit.Rows[0].Cells["Cr"].Text); //Cr ht.Add("I29", ultragridInIronEdit.Rows[0].Cells["IRONTEMPERATURE2"].Text); //平台温度2 ht.Add("O1", ""); ht.Add("O2", ""); CommonClientToServer ccTs = new CommonClientToServer(); ccTs.ob = ob; string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.LgJobMgt.ClassHmpJob", "UpdateBFIronData", strSqlID, ht, out strErr); if (strErr == "") MessageBox.Show("高炉铁水信息修改成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); else MessageBox.Show("高炉铁水信息修改失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } } #endregion #region gridevent private void ultraGrid1_DoubleClickRow(object sender, Infragistics.Win.UltraWinGrid.DoubleClickRowEventArgs e) { if (e.Row != null) { if (e.Row.Cells["STATUS"].Value.ToString() == "已确认") { MessageBox.Show("铁水已经确认，不能重复确认！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } } if (blModify == false) { setbutton("2"); setucInIron("2"); string shiftgroup = CStaticMethod.GetCurrentClass(this.ob); Infragistics.Win.UltraWinGrid.UltraGridRow aRow = e.Row; try { SetMisnoNoEdite(); ultragridInIronEdit.Rows[0].Cells["InIronNo"].Value = "自动"; ultragridInIronEdit.Rows[0].Cells["InIronTime"].Value = DateTime.Now; ultragridInIronEdit.Rows[0].Cells["Group"].Value = ConvertShift("1", shiftgroup); ultragridInIronEdit.Rows[0].Cells["Shift"].Value = ConvertShift("2", shiftgroup); ultragridInIronEdit.Rows[0].Cells["HighNo"].Value = e.Row.Cells["STOVEID"].Text.ToString(); ultragridInIronEdit.Rows[0].Cells["tapholeno"].Value = e.Row.Cells["tapholeno"].Text.ToString(); ultragridInIronEdit.Rows[0].Cells["stovetime"].Value = e.Row.Cells["stovetime"].Text.ToString(); ultragridInIronEdit.Rows[0].Cells["BFIRONTEMTURE"].Value = e.Row.Cells["tfirontemp"].Text.ToString(); ultragridInIronEdit.Rows[0].Cells["Temptrue"].Value = ""; //ultragridInIronEdit.Rows[0].Cells["C"].Value = e.Row.Cells["C"].Value != System.DBNull.Value ? e.Row.Cells["C"].Text : "0"; //ultragridInIronEdit.Rows[0].Cells["Si"].Value = e.Row.Cells["SI"].Value != System.DBNull.Value ? e.Row.Cells["SI"].Text : "0"; //ultragridInIronEdit.Rows[0].Cells["Mn"].Value = e.Row.Cells["MN"].Value != System.DBNull.Value ? e.Row.Cells["MN"].Text : "0"; //ultragridInIronEdit.Rows[0].Cells["P"].Value = e.Row.Cells["P"].Value != System.DBNull.Value ? e.Row.Cells["P"].Text : "0"; //ultragridInIronEdit.Rows[0].Cells["S"].Value = e.Row.Cells["S"].Value != System.DBNull.Value ? e.Row.Cells["S"].Text : "0"; //ultragridInIronEdit.Rows[0].Cells["Sn"].Value = e.Row.Cells["Sn"].Value != System.DBNull.Value ? e.Row.Cells["Sn"].Text : "0"; //ultragridInIronEdit.Rows[0].Cells["As"].Value = e.Row.Cells["As"].Value != System.DBNull.Value ? e.Row.Cells["As"].Text : "0"; //ultragridInIronEdit.Rows[0].Cells["Cu"].Value = e.Row.Cells["Cu"].Value != System.DBNull.Value ? e.Row.Cells["Cu"].Text : "0"; //ultragridInIronEdit.Rows[0].Cells["Cr"].Value = e.Row.Cells["Cr"].Value != System.DBNull.Value ? e.Row.Cells["Cr"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["C"].Value = e.Row.Cells["C"].Value.ToString().Length > 0 ? e.Row.Cells["C"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["Si"].Value = e.Row.Cells["SI"].Value.ToString().Length > 0 ? e.Row.Cells["SI"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["Mn"].Value = e.Row.Cells["MN"].Value.ToString().Length > 0 ? e.Row.Cells["MN"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["P"].Value = e.Row.Cells["P"].Value.ToString().Length > 0 ? e.Row.Cells["P"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["S"].Value = e.Row.Cells["S"].Value.ToString().Length > 0 ? e.Row.Cells["S"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["Sn"].Value = e.Row.Cells["Sn"].Value.ToString().Length > 0 ? e.Row.Cells["Sn"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["As"].Value = e.Row.Cells["As"].Value.ToString().Length > 0 ? e.Row.Cells["As"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["Cu"].Value = e.Row.Cells["Cu"].Value.ToString().Length > 0 ? e.Row.Cells["Cu"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["Cr"].Value = e.Row.Cells["Cr"].Value.ToString().Length > 0 ? e.Row.Cells["Cr"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["GuanNo"].Value = e.Row.Cells["TFPOTID"].Value != System.DBNull.Value ? e.Row.Cells["TFPOTID"].Text : ""; ultragridInIronEdit.Rows[0].Cells["LdMaoWeight"].Value = e.Row.Cells["tfpottarewgt"].Value != System.DBNull.Value ? e.Row.Cells["tfpottarewgt"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["LdKongWeight"].Value = e.Row.Cells["tfpotgrosswgt"].Value != System.DBNull.Value ? e.Row.Cells["tfpotgrosswgt"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["IronWeight"].Value = e.Row.Cells["tfpotwgt"].Value != System.DBNull.Value ? e.Row.Cells["tfpotwgt"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["checkno"].Value = e.Row.Cells["checkno"].Text.ToString(); ultragridInIronEdit.Rows[0].Cells["hstapholetime"].Value = e.Row.Cells["hstapholetime"].Text.ToString(); ultragridInIronEdit.Rows[0].Cells["RsWgt"].Value = "0"; } catch { } } else { ultragridInIronEdit.Rows[0].Cells["HighNo"].Value = e.Row.Cells["STOVEID"].Text.Substring(0, 1); ultragridInIronEdit.Rows[0].Cells["C"].Value = e.Row.Cells["C"].Value != System.DBNull.Value ? e.Row.Cells["C"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["Si"].Value = e.Row.Cells["SI"].Value != System.DBNull.Value ? e.Row.Cells["SI"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["Mn"].Value = e.Row.Cells["MN"].Value != System.DBNull.Value ? e.Row.Cells["MN"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["P"].Value = e.Row.Cells["P"].Value != System.DBNull.Value ? e.Row.Cells["P"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["S"].Value = e.Row.Cells["S"].Value != System.DBNull.Value ? e.Row.Cells["S"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["Sn"].Value = e.Row.Cells["Sn"].Value != System.DBNull.Value ? e.Row.Cells["Sn"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["As"].Value = e.Row.Cells["As"].Value != System.DBNull.Value ? e.Row.Cells["As"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["Cu"].Value = e.Row.Cells["S"].Value != System.DBNull.Value ? e.Row.Cells["Cu"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["Cr"].Value = e.Row.Cells["S"].Value != System.DBNull.Value ? e.Row.Cells["Cr"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["GuanNo"].Value = e.Row.Cells["TFPOTID"].Value != System.DBNull.Value ? e.Row.Cells["TFPOTID"].Text : ""; ultragridInIronEdit.Rows[0].Cells["LdMaoWeight"].Value = e.Row.Cells["tfpottarewgt"].Value != System.DBNull.Value ? e.Row.Cells["tfpottarewgt"].Text : ""; ultragridInIronEdit.Rows[0].Cells["LdKongWeight"].Value = e.Row.Cells["tfpotgrosswgt"].Value != System.DBNull.Value ? e.Row.Cells["tfpotgrosswgt"].Text : ""; ultragridInIronEdit.Rows[0].Cells["IronWeight"].Value = e.Row.Cells["tfpotwgt"].Value != System.DBNull.Value ? e.Row.Cells["tfpotwgt"].Text : ""; ultragridInIronEdit.Rows[0].Cells["RsWgt"].Value = "0"; } } /// /// 取相关数据到编辑区 铁运进铁数据 /// /// /// private void ultraGrid2_AfterRowActivate(object sender, EventArgs e) { Infragistics.Win.UltraWinGrid.UltraGridRow aRow = ultragridInIron.ActiveRow; if (aRow == null) return; if (ultragridInIronEdit.Rows[0].Cells["InIronNo"].Text == "自动") return; try { ultragridInIronEdit.Rows[0].Cells["InIronNo"].Value = aRow.Cells["MISID"].Text; ultragridInIronEdit.Rows[0].Cells["HighNo"].Value = aRow.Cells["STOVEID"].Text; ultragridInIronEdit.Rows[0].Cells["STOVETIME"].Value = aRow.Cells["STOVETIME"].Text; ultragridInIronEdit.Rows[0].Cells["TAPHOLENO"].Value = aRow.Cells["TAPHOLENO"].Text; ultragridInIronEdit.Rows[0].Cells["BFIRONTEMTURE"].Value = aRow.Cells["BFIRONTEMTURE"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["BFIRONTEMTURE"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["Temptrue"].Value = aRow.Cells["IRONTEMPERATURE"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["IRONTEMPERATURE"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["LDKongWeight"].Value = aRow.Cells["TFPOTGROSSWGT"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["TFPOTGROSSWGT"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["LDMaoWeight"].Value = aRow.Cells["TFPOTTAREWGT"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["TFPOTTAREWGT"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["IronWeight"].Value = aRow.Cells["TFPOTWGT"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["TFPOTWGT"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["GuanNo"].Value = aRow.Cells["TFPOTID"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["TFPOTID"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["InIronTime"].Value = aRow.Cells["ARRIVETIME"].Text; ultragridInIronEdit.Rows[0].Cells["Group"].Value = aRow.Cells["group"].Text; ultragridInIronEdit.Rows[0].Cells["Shift"].Value = aRow.Cells["Shift"].Text; ultragridInIronEdit.Rows[0].Cells["IronQuxiang"].Value = aRow.Cells["molirnsource"].Text; ultragridInIronEdit.Rows[0].Cells["checkno"].Value = aRow.Cells["checkno"].Text.ToString(); ultragridInIronEdit.Rows[0].Cells["hstapholetime"].Value = aRow.Cells["hstapholetime"].Text.ToString(); ultragridInIronEdit.Rows[0].Cells["RSWGT"].Value = aRow.Cells["RSWGT"].Text.ToString(); ultragridInIronEdit.Rows[0].Cells["IRONTEMPERATURE2"].Value = aRow.Cells["IRONTEMPERATURE2"].Text.ToString(); ultragridInIronEdit.Rows[0].Cells["C"].Value = aRow.Cells["C"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["C"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["Si"].Value = aRow.Cells["SI"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["SI"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["Mn"].Value = aRow.Cells["MN"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["MN"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["P"].Value = aRow.Cells["P"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["P"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["S"].Value = aRow.Cells["S"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["S"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["Sn"].Value = aRow.Cells["Sn"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["Sn"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["As"].Value = aRow.Cells["As"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["As"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["Cu"].Value = aRow.Cells["Cu"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["Cu"].Text : "0"; ultragridInIronEdit.Rows[0].Cells["Cr"].Value = aRow.Cells["Cr"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["Cr"].Text : "0"; } catch { } } /// /// 铁运进铁设置初始数据 /// private void SetGridNewIronData() { ultragridInIronEdit.Rows[0].Cells["InIronNo"].Value = "自动"; ultragridInIronEdit.Rows[0].Cells["HighNo"].Value = ""; ultragridInIronEdit.Rows[0].Cells["InIronTime"].Value = DateTime.Now; ultragridInIronEdit.Rows[0].Cells["Group"].Value = ConvertShift("1", CStaticMethod.GetCurrentClass(this.ob)); ultragridInIronEdit.Rows[0].Cells["Shift"].Value = ConvertShift("2", CStaticMethod.GetCurrentClass(this.ob)); ultragridInIronEdit.Rows[0].Cells["GuanNo"].Value = ""; ultragridInIronEdit.Rows[0].Cells["LdKongWeight"].Value = "0"; ultragridInIronEdit.Rows[0].Cells["LdMaoWeight"].Value = "0"; ultragridInIronEdit.Rows[0].Cells["IronWeight"].Value = "0"; ultragridInIronEdit.Rows[0].Cells["C"].Value = "0"; ultragridInIronEdit.Rows[0].Cells["Si"].Value = "0"; ultragridInIronEdit.Rows[0].Cells["Mn"].Value = "0"; ultragridInIronEdit.Rows[0].Cells["P"].Value = "0"; ultragridInIronEdit.Rows[0].Cells["S"].Value = "0"; ultragridInIronEdit.Rows[0].Cells["As"].Value = "0"; ultragridInIronEdit.Rows[0].Cells["Sn"].Value = "0"; ultragridInIronEdit.Rows[0].Cells["Cu"].Value = "0"; ultragridInIronEdit.Rows[0].Cells["Cr"].Value = "0"; ultragridInIronEdit.Rows[0].Cells["IronQuxiang"].Value = this.Text.Substring(0, 1); ultragridInIronEdit.Rows[0].Cells["RSWGT"].Value = "0"; } private void ucInIron1_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e) { float flPZ = Convert.ToSingle(ultragridBfIron.Rows[0].Cells["LdKongWeight"].Text != System.DBNull.Value.ToString() ? ultragridBfIron.Rows[0].Cells["LdKongWeight"].Text : "0"); float flMZ = Convert.ToSingle(ultragridBfIron.Rows[0].Cells["LdMaoWeight"].Text != System.DBNull.Value.ToString() ? ultragridBfIron.Rows[0].Cells["LdMaoWeight"].Text : "0"); float flJZ = Convert.ToSingle(ultragridBfIron.Rows[0].Cells["IronWeight"].Text != System.DBNull.Value.ToString() ? ultragridBfIron.Rows[0].Cells["IronWeight"].Text : "0"); switch (e.Cell.Column.Key) { case "LdMaoWeight": { try { if (flPZ > 0) ultragridBfIron.Rows[0].Cells["IronWeight"].Value = Convert.ToString(flMZ - flPZ); else if (flJZ > 0) ultragridBfIron.Rows[0].Cells["LdKongWeight"].Value = Convert.ToString(flMZ - flJZ); else if (flPZ > 0 && flJZ > 0) ultragridBfIron.Rows[0].Cells["IronWeight"].Value = Convert.ToString(flMZ - flPZ); } catch { } break; } case "LdKongWeight": { try { if (flMZ > 0) ultragridBfIron.Rows[0].Cells["IronWeight"].Value = Convert.ToString(flMZ - flPZ); else if (flJZ > 0) ultragridBfIron.Rows[0].Cells["LdMaoWeight"].Value = Convert.ToString(flPZ + flJZ); else if (flMZ > 0 && flJZ > 0) ultragridBfIron.Rows[0].Cells["IronWeight"].Value = Convert.ToString(flMZ - flPZ); } catch { } break; } case "IronWeight": { try { if (flPZ > 0) ultragridBfIron.Rows[0].Cells["LdMaoWeight"].Value = Convert.ToString(flJZ + flPZ); else if (flMZ > 0) ultragridBfIron.Rows[0].Cells["LdKongWeight"].Value = Convert.ToString(flMZ - flJZ); else if (flMZ > 0 && flPZ > 0) ultragridBfIron.Rows[0].Cells["LdMaoWeight"].Value = Convert.ToString(flJZ + flPZ); } catch { } break; } } } /// /// editbutton事件的委托 /// private void SetUserControlDelegate() { ultragridBfIron.CellChange += new Infragistics.Win.UltraWinGrid.CellEventHandler(ucInIron1_CellChange); } #endregion #region function private string ConvertShift(string flag, string shift) { string StrReturn = ""; if (flag == "1" & shift != "" & shift != null) { switch (shift.Substring(0, 1)) { case "1": StrReturn = "白"; break; case "2": StrReturn = "中"; break; case "3": StrReturn = "夜"; break; } } else if (flag == "2" & shift.Length > 1) { 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 SetColumnModeGroup(Infragistics.Win.UltraWinGrid.UltraGridBase Grid) { DataTable dt = new DataTable(); dt.TableName = "JIALIAO"; DataColumn dc = new DataColumn("BCBM", Type.GetType("System.String")); dt.Columns.Add(dc); dc = new DataColumn("BCNA", Type.GetType("System.String")); dt.Columns.Add(dc); DataRow dr = dt.NewRow(); dr["BCBM"] = "1"; dr["BCNA"] = "白"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["BCBM"] = "2"; dr["BCNA"] = "中"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["BCBM"] = "3"; dr["BCNA"] = "夜"; dt.Rows.Add(dr); JJBStaticFunction.SetGridDropDownListCell("Group", 0, "班次", 60, Grid, dt, "BCBM", "BCNA"); } /// /// 设置班组下拉框 /// /// private void SetColumnModeShift(Infragistics.Win.UltraWinGrid.UltraGridBase Grid) { DataTable dt = new DataTable(); dt.TableName = "JIALIAO"; DataColumn dc = new DataColumn("BCBM", Type.GetType("System.String")); dt.Columns.Add(dc); dc = new DataColumn("BCNA", Type.GetType("System.String")); dt.Columns.Add(dc); DataRow dr = dt.NewRow(); dr["BCBM"] = "1"; dr["BCNA"] = "甲"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["BCBM"] = "2"; dr["BCNA"] = "乙"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["BCBM"] = "3"; dr["BCNA"] = "丙"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["BCBM"] = "4"; dr["BCNA"] = "丁"; dt.Rows.Add(dr); JJBStaticFunction.SetGridDropDownListCell("Shift", 0, "班组", 60, Grid, dt, "BCBM", "BCNA"); } /// /// 设置去向 /// private void SetColumnModequxiang() { DataTable dt = new DataTable(); dt.TableName = "JIALIAO"; DataColumn dc = new DataColumn("BCBM", Type.GetType("System.String")); dt.Columns.Add(dc); dc = new DataColumn("BCNA", Type.GetType("System.String")); dt.Columns.Add(dc); DataRow dr = dt.NewRow(); dr["BCBM"] = "1"; dr["BCNA"] = "1#混铁炉"; dt.Rows.Add(dr); //dr = dt.NewRow(); //dr["BCBM"] = "2"; //dr["BCNA"] = "2#混铁炉"; //dt.Rows.Add(dr); //Core.LgMes.Client.LgIntegrationQuery.JJBStaticFunction.SetGridDropDownListCell("IronQuxiang", 0, "铁水去向", 135, ucInIron1.ultraGrid1, dt, "BCBM", "BCNA"); } /// /// 设置去向 /// private void SetColumnModeOutquxiang() { DataTable dt = new DataTable(); dt.TableName = "JIALIAO"; DataColumn dc = new DataColumn("BCBM", Type.GetType("System.String")); dt.Columns.Add(dc); dc = new DataColumn("BCNA", Type.GetType("System.String")); dt.Columns.Add(dc); DataRow dr = dt.NewRow(); dr["BCBM"] = "1"; dr["BCNA"] = "1#转炉"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["BCBM"] = "2"; dr["BCNA"] = "2#转炉"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["BCBM"] = "3"; dr["BCNA"] = "3#转炉"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["BCBM"] = "4"; dr["BCNA"] = "1#预处理"; dt.Rows.Add(dr); //dr = dt.NewRow(); //dr["BCBM"] = "5"; // dr["BCNA"] = "2#预处理"; // dt.Rows.Add(dr); //Core.LgMes.Client.LgIntegrationQuery.JJBStaticFunction.SetGridDropDownListCellEdit("IronQuxiang", 0, "铁水去向", 100, ucHtOutIron1.ultraGrid1, dt, "BCBM", "BCNA"); } /// /// 序号栏锁定 /// private void SetMisnoNoEdite() { ultragridInIronEdit.DisplayLayout.Bands[0].Columns[0].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[0].CellAppearance.BackColor = Color.LightBlue; } /// /// 序号栏锁定 /// private void SetMisnoNoEdite2() { ultragridBfIron.DisplayLayout.Bands[0].Columns[0].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridBfIron.DisplayLayout.Bands[0].Columns[0].CellAppearance.BackColor = System.Drawing.SystemColors.ActiveBorder; } private void timer1_Tick(object sender, EventArgs e) { RefreshHighheatNo(); // GetCVTHeatno(); } /// /// 设置铁运进铁 按钮状态 /// /// /// private void setbutton(string flag) { switch (flag) { case "1": this.ToolBarItemEnable(this, "Query", true); this.ToolBarItemEnable(this, "Add", true); this.ToolBarItemEnable(this, "Update", true); this.ToolBarItemEnable(this, "Del", true); this.ToolBarItemEnable(this, "Save", false); this.ToolBarItemEnable(this, "Cancel", false); this.ToolBarItemEnable(this, "Exit", true); break; case "2": this.ToolBarItemEnable(this, "Query", true); this.ToolBarItemEnable(this, "Add", false); this.ToolBarItemEnable(this, "Update", false); this.ToolBarItemEnable(this, "Del", false); this.ToolBarItemEnable(this, "Save", true); this.ToolBarItemEnable(this, "Cancel", true); this.ToolBarItemEnable(this, "Exit", true); break; } } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": GetInIronData(); break; case "Add": setbutton("2"); setucInIron("2"); SetMisnoNoEdite(); SetGridNewIronData(); break; case "Update": blModify = true; setbutton("2"); setucInIron("2"); ultragridInIronEdit.DisplayLayout.Bands[0].Columns[0].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[0].CellAppearance.BackColor = Color.LightBlue; //ultragridInIronEdit.DisplayLayout.Bands[0].Columns[17].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; //ultragridInIronEdit.DisplayLayout.Bands[0].Columns[17].CellAppearance.BackColor = Color.LightBlue; //ultragridInIronEdit.DisplayLayout.Bands[0].Columns[20].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; //ultragridInIronEdit.DisplayLayout.Bands[0].Columns[20].CellAppearance.BackColor = Color.LightBlue; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[22].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[22].CellAppearance.BackColor = Color.LightBlue; //.DisplayLayout.Bands[0].Columns["Temptrue"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; //ultragridInIronEdit.DisplayLayout.Bands[0].Columns["Temptrue"].CellAppearance.BackColor = Color.LightBlue; break; case "Del": DelBfIronInData(); break; case "Save": if (CheckData() == false) { MessageBox.Show(this, "输入的数据不完整或错误，请检查！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } InsertBFIronData(); GetInIronData(); break; case "Cancel": setbutton("1"); setucInIron("1"); ultragridInIronEdit.Rows[0].Cells["InIronNo"].Value = ""; ultraGrid2_AfterRowActivate(null, null); blModify = false; break; case "Send": frmSendIron frmSIron = new frmSendIron(); frmSIron.ob = this.ob; frmSIron.StartPosition = FormStartPosition.CenterParent; frmSIron.ShowDialog(); break; case "Exit": this.Close(); break; case "Export": ExportDataWithSaveDialog(ref this.ultragridInIron, "铁运进铁"); break; default: break; } } /// /// 设置 ucInIron Grid的读写状态 /// 1:NoEDIT 2:ALLOWEDIT /// /// private void setucInIron(string flag) { switch (flag) { case "1": ultragridInIronEdit.DisplayLayout.Bands[0].Columns[0].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[0].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[1].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[2].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[3].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[4].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[5].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[6].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[7].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[8].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[9].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[10].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[11].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[12].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[13].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[14].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[15].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[16].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[17].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[18].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[19].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[27].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[28].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[29].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Override.CellAppearance.BackColor = Color.LightBlue; break; case "2": ultragridInIronEdit.DisplayLayout.Bands[0].Columns[0].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[1].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[2].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[3].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[4].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[5].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[6].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[7].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[8].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[9].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[10].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[11].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[12].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[13].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[14].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[15].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[16].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[17].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[18].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[19].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[27].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[28].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[29].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit; ultragridInIronEdit.DisplayLayout.Override.CellAppearance.BackColor = Color.White; break; } } private static bool IsDouble(string AValue) { try { Convert.ToDouble(AValue); return true; } catch { return false; } } /// /// 数据CHECK /// /// private bool CheckData() { if (ultragridInIronEdit.Rows[0].Cells["LDKongWeight"].Text.Trim().Length == 0) ultragridInIronEdit.Rows[0].Cells["LDKongWeight"].Value = "0"; if (ultragridInIronEdit.Rows[0].Cells["LDMaoWeight"].Text.Trim().Length == 0) ultragridInIronEdit.Rows[0].Cells["LDMaoWeight"].Value = "0"; if (ultragridInIronEdit.Rows[0].Cells["IronWeight"].Text.Trim().Length == 0) ultragridInIronEdit.Rows[0].Cells["IronWeight"].Value = "0"; if (ultragridInIronEdit.Rows[0].Cells["Temptrue"].Text.Trim().Length == 0) ultragridInIronEdit.Rows[0].Cells["Temptrue"].Value = ""; if (ultragridInIronEdit.Rows[0].Cells["C"].Text.Trim().Length == 0) ultragridInIronEdit.Rows[0].Cells["C"].Value = ""; if (ultragridInIronEdit.Rows[0].Cells["Si"].Text.Trim().Length == 0) ultragridInIronEdit.Rows[0].Cells["Si"].Value = ""; if (ultragridInIronEdit.Rows[0].Cells["Mn"].Text.Trim().Length == 0) ultragridInIronEdit.Rows[0].Cells["Mn"].Value = ""; if (ultragridInIronEdit.Rows[0].Cells["P"].Text.Trim().Length == 0) ultragridInIronEdit.Rows[0].Cells["P"].Value = ""; if (ultragridInIronEdit.Rows[0].Cells["S"].Text.Trim().Length == 0) ultragridInIronEdit.Rows[0].Cells["S"].Value = ""; if (ultragridInIronEdit.Rows[0].Cells["Sn"].Text.Trim().Length == 0) ultragridInIronEdit.Rows[0].Cells["Sn"].Value = ""; if (ultragridInIronEdit.Rows[0].Cells["As"].Text.Trim().Length == 0) ultragridInIronEdit.Rows[0].Cells["As"].Value = ""; if (ultragridInIronEdit.Rows[0].Cells["Cu"].Text.Trim().Length == 0) ultragridInIronEdit.Rows[0].Cells["Cu"].Value = ""; if (ultragridInIronEdit.Rows[0].Cells["Cr"].Text.Trim().Length == 0) ultragridInIronEdit.Rows[0].Cells["Cr"].Value = ""; //if (!IsDouble(ucInIron1.ultraGrid1.Rows[0].Cells["Temptrue"].Text)) //{ // return false; //} if (!IsDouble(ultragridInIronEdit.Rows[0].Cells["C"].Text)) { return false; } if (!IsDouble(ultragridInIronEdit.Rows[0].Cells["Si"].Text)) { return false; } if (!IsDouble(ultragridInIronEdit.Rows[0].Cells["Mn"].Text)) { return false; } if (!IsDouble(ultragridInIronEdit.Rows[0].Cells["P"].Text)) { return false; } if (!IsDouble(ultragridInIronEdit.Rows[0].Cells["S"].Text)) { return false; } if (!IsDouble(ultragridInIronEdit.Rows[0].Cells["Sn"].Text)) { return false; } if (!IsDouble(ultragridInIronEdit.Rows[0].Cells["As"].Text)) { return false; } if (!IsDouble(ultragridInIronEdit.Rows[0].Cells["Cu"].Text)) { return false; } if (!IsDouble(ultragridInIronEdit.Rows[0].Cells["Cr"].Text)) { return false; } if (!IsDouble(ultragridInIronEdit.Rows[0].Cells["LDKongWeight"].Text)) { return false; } if (!IsDouble(ultragridInIronEdit.Rows[0].Cells["LDMaoWeight"].Text)) { return false; } if (!IsDouble(ultragridInIronEdit.Rows[0].Cells["IronWeight"].Text)) { return false; } if (!IsDouble(ultragridInIronEdit.Rows[0].Cells["RSWGT"].Text)) { return false; } return true; } /// /// 取铁运进铁的数据 到数组 /// private void GetGridData() { try { ArrayIronRow[0] = ultragridInIronEdit.Rows[0].Cells["InIronNo"].Text; ArrayIronRow[1] = ultragridInIronEdit.Rows[0].Cells["HighNo"].Text; ArrayIronRow[2] = ConvertShift("3", ultragridInIronEdit.Rows[0].Cells["Group"].Text) + ConvertShift("4", ultragridInIronEdit.Rows[0].Cells["shift"].Text); ArrayIronRow[3] = ultragridInIronEdit.Rows[0].Cells["InIronTime"].Text; ArrayIronRow[4] = ultragridInIronEdit.Rows[0].Cells["Temptrue"].Text; ArrayIronRow[5] = ultragridInIronEdit.Rows[0].Cells["GuanNo"].Text; ArrayIronRow[6] = ultragridInIronEdit.Rows[0].Cells["LDKongWeight"].Text; ArrayIronRow[7] = ultragridInIronEdit.Rows[0].Cells["LDMaoWeight"].Text; ArrayIronRow[8] = ultragridInIronEdit.Rows[0].Cells["IronWeight"].Text; ArrayIronRow[9] = ultragridInIronEdit.Rows[0].Cells["HighNo"].Text; ArrayIronRow[10] = ultragridInIronEdit.Rows[0].Cells["C"].Text; ArrayIronRow[11] = ultragridInIronEdit.Rows[0].Cells["Si"].Text; ArrayIronRow[12] = ultragridInIronEdit.Rows[0].Cells["Mn"].Text; ArrayIronRow[13] = ultragridInIronEdit.Rows[0].Cells["P"].Text; ArrayIronRow[14] = ultragridInIronEdit.Rows[0].Cells["S"].Text; ArrayIronRow[15] = ultragridInIronEdit.Rows[0].Cells["As"].Text; ArrayIronRow[16] = ultragridInIronEdit.Rows[0].Cells["IronQuxiang"].Text; ArrayIronRow[17] = User; ArrayIronRow[18] = ultragridInIronEdit.Rows[0].Cells["RSWGT"].Text; ArrayIronRow[19] = ultragridInIronEdit.Rows[0].Cells["Sn"].Text; ArrayIronRow[20] = ultragridInIronEdit.Rows[0].Cells["Cu"].Text; ArrayIronRow[21] = ultragridInIronEdit.Rows[0].Cells["Cr"].Text; } catch { } } #endregion #region buttonevent private void ulbtnAdd_Click(object sender, EventArgs e) { setbutton("2"); setucInIron("2"); SetMisnoNoEdite(); SetGridNewIronData(); } private void ulbtnEdit_Click(object sender, EventArgs e) { blModify = true; setbutton("2"); setucInIron("2"); ultragridInIronEdit.DisplayLayout.Bands[0].Columns[0].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[0].CellAppearance.BackColor = Color.LightBlue; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[17].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[17].CellAppearance.BackColor = Color.LightBlue; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[20].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[20].CellAppearance.BackColor = Color.LightBlue; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[22].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultragridInIronEdit.DisplayLayout.Bands[0].Columns[22].CellAppearance.BackColor = Color.LightBlue; } private void DelBfIronInData() { if (ultragridInIronEdit.ActiveRow == null || ultragridInIronEdit.Rows[0].Cells["InIronNo"].Text == "自动") return; if (MessageBox.Show(this, "您确定要删除【" + ultragridInIronEdit.Rows[0].Cells["InIronNo"].Text + "】铁运进铁信息？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) return; try { string strErr = ""; string strSqlID = "DeleteBFIronData.Delete"; //SQLID Hashtable ht = new Hashtable(); ht.Add("I1", ultragridInIronEdit.Rows[0].Cells["InIronNo"].Text); //进铁序号 ht.Add("O1", ""); ht.Add("O2", ""); CommonClientToServer ccTs = new CommonClientToServer(); ccTs.ob = ob; string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.LgJobMgt.ClassHmpJob", "DeleteBFIronData", strSqlID, ht, out strErr); if (strErr == "") MessageBox.Show("高炉铁水【" + ultragridInIronEdit.Rows[0].Cells["InIronNo"].Text + "】信息删除成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); else MessageBox.Show("高炉铁水【" + ultragridInIronEdit.Rows[0].Cells["InIronNo"].Text + "】信息删除失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ee) { string s = ee.Message; } GetInIronData(); } private void ulbtnSave_Click(object sender, EventArgs e) { if (CheckData() == false) { MessageBox.Show(this, "输入的数据不完整或错误，请检查！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } InsertBFIronData(); GetInIronData(); } private void ulbtnCancel_Click(object sender, EventArgs e) { setbutton("1"); setucInIron("1"); ultragridInIronEdit.Rows[0].Cells["InIronNo"].Value = ""; ultraGrid2_AfterRowActivate(null, null); blModify = false; } private void ulbtnRef_Click(object sender, EventArgs e) { GetInIronData(); } #endregion /// /// 获取铁包包龄 /// /// /// private int GetIronwrapAge(string strIronwrapID, out string strStatus) { string strErr = ""; int intIronAge = 0; string _strStatus = ""; object obj = null;// ClientCommon._RemotingHelp.ExecuteMethod("lgJobMgt", // "Core.LgMes.Server.lgJobMgt.classIronJob", // "GetIronwrapAge", new object[] { "res_mis_taphole", strIronwrapID }, out strErr); if (strErr == "") { DataSet ds = (DataSet)obj; if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { intIronAge = Convert.ToInt32(ds.Tables[0].Rows[0][0]); _strStatus = ds.Tables[0].Rows[0]["STATUS"].ToString(); } } } strStatus = _strStatus; return intIronAge; } private void ultraGrid4_KeyDown(object sender, KeyEventArgs e) { //if (e.KeyCode != Keys.Enter) // return; //ultraGrid4.UpdateData(); //string keyStr = ultraGrid4.ActiveCell.Column.Key; //double valueStr = 0; //string strFindName = ""; //string strErr = ""; //if (keyStr == "AllInrion" || keyStr == "OutIronAll" || keyStr == "ZhiDuiAll") //{ // if (keyStr == "AllInrion") strFindName = "IMPORTIRONTOTAL"; // if (keyStr == "OutIronAll") strFindName = "EXPORTIRONTOTAL"; // if (keyStr == "ZhiDuiAll") strFindName = "SKIPIRONTOTAL"; // try // { // if (ultraGrid4.ActiveCell.Value.ToString() != "") // { // valueStr = Convert.ToDouble(ultraGrid4.ActiveCell.Value); // object obj = null;// ClientCommon._RemotingHelp.ExecuteMethod("lgJobMgt", // // "Core.LgMes.Server.lgJobMgt.classIronJob", // // "StatIronWeight", new object[] { this.Text.Substring(0, 1), strFindName, 0, valueStr, 2 }, out strErr); // if (strErr == "") // ultraGrid4.ActiveCell.Value = valueStr; // else // MessageBox.Show("修改数据失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); // } // } // catch (Exception ex) // { // string Msg = ex.Message; // MessageBox.Show("输入数据格式错误，请改正！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); // } //} } private void HeatNo_HudwId_Exist(string strID) { string strErr = ""; string strGw = ""; if (strID.Substring(0, 1) == "H") strGw = strID.Substring(0, 2); else strGw = strID.Substring(2, 1); string obj = "";// (string)ClientCommon._RemotingHelp.ExecuteMethod("lgJobMgt", // "Core.LgMes.Server.lgJobMgt.classIronJob", // "HeatNo_HudwId_Exist", new object[] { strID }, out strErr); if (strErr == "") { switch (strGw) { case "H1": _strSendSucceededForHmp1 = obj; break; case "H2": _strSendSucceededForHmp2 = obj; break; case "1": _strSendSucceededForBof1 = obj; break; case "2": _strSendSucceededForBof2 = obj; break; case "3": _strSendSucceededForBof3 = obj; break; default: break; } } } private void ultrabtHRef_Click(object sender, EventArgs e) { RefreshHighheatNo(); //手动刷新高炉铁水信息 } private void chkInIronDate_CheckedChanged(object sender, EventArgs e) { CheckBox chkMain = (CheckBox)sender; if (chkMain.Name == "chkShift") { cboShift.Enabled = chkMain.Checked; cboShift.Value = 0; } else if (chkMain.Name == "chkInIronDate") { dtpBegin.Enabled = chkMain.Checked; dtpEnd.Enabled = chkMain.Checked; } else if (chkMain.Name == "chkBfNo") ultratxtBfNo.Enabled = chkMain.Checked; } private void ultratxtBfNo_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e) { ultratxtBfNo.Text = ""; } private void ultragridInIron_DoubleClickRow(object sender, Infragistics.Win.UltraWinGrid.DoubleClickRowEventArgs e) { if (ultragridInIron.ActiveRow != null) { frmSendIron frmSIron = new frmSendIron(); frmSIron.ob = this.ob; frmSIron.strKR_Charge_NO = ultragridInIron.ActiveRow.Cells["MISID"].Value.ToString(); frmSIron.StartPosition = FormStartPosition.CenterParent; frmSIron.ShowDialog(); } } /// /// 通过穿入的sql返回数据集 /// /// /// private DataSet returnCommonDataSet(string sqlStr) { DataSet ds = new DataSet(); DataTable dt = new DataTable(); CoreClientParam CCP_Query = new CoreClientParam(); CCP_Query.ServerName = "Core.LgMes.Server.Common.ComDBExecute"; CCP_Query.MethodName = "doSimpleQuery"; CCP_Query.ServerParams = new object[] { sqlStr }; CCP_Query.SourceDataTable = dt; try { this.ExecuteQueryToDataTable(CCP_Query, CoreInvokeType.Internal); ds.Tables.Add(dt); } catch { } return ds; } private void ultragridInIronEdit_ClickCellButton(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e) { if (e.Cell.Column.Key == "Temptrue") // 温度 { frmBfIronTemp frm = new frmBfIronTemp(); frm.Location = CStaticMethod.GetChildWindowLocation(frm.Size); frm.ob = this.ob; frm.ShowDialog(); if (frm._strHeatProcessNo != "") { ultragridInIronEdit.Rows[0].Cells["Temptrue"].Value = frm._strPTIronTemp; ultragridInIronEdit.Rows[0].Cells["Temptrue"].Tag = frm._strHeatProcessNo; } } } /// /// 导出excel /// /// /// public void ExportDataWithSaveDialog(ref Infragistics.Win.UltraWinGrid.UltraGrid ultGrid, string strFileName) { try { if (ultGrid.Rows.Count == 0) return; if (strFileName.Length == 0) strFileName = "未命名"; SaveFileDialog dlg = new SaveFileDialog(); dlg.Title = "保存"; dlg.OverwritePrompt = true; dlg.Filter = "Excel文件(*.xls)|*.xls"; dlg.AddExtension = true; dlg.FileName = strFileName; if (dlg.ShowDialog() == DialogResult.OK) { strFileName = dlg.FileName; this.ultraGridExcelExporter1.Export(ultGrid, strFileName); //2012-04-10何晓晴修改导出功能 if (MessageBox.Show("数据导出成功！\r\n需要打开所导出文件吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { ultraGridExcelExporter1.Export(ultGrid, strFileName); ProcessStartInfo p = new ProcessStartInfo(strFileName); p.WorkingDirectory = Path.GetDirectoryName(strFileName); Process.Start(p); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }