using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using CoreFS.CA06; using System.Threading; using System.Diagnostics; using System.IO; using Infragistics.Win.UltraWinGrid; using System.Collections; using Core.Mes.Client.Common; namespace Core.LgMes.Client.LgResMgt { public partial class FrmScrapSteel : Core.Mes.Client.Common.frmStyleBase { private System.Threading.Thread myThread_FG; private string _strSendSucceededForBof1 = ""; private string _strSendSucceededForBof2 = ""; private string _strSendSucceededForBof3 = ""; public FrmScrapSteel() { InitializeComponent(); CheckForIllegalCrossThreadCalls = false; } private void checkBox2_CheckedChanged(object sender, EventArgs e) { if (this.checkBox2.Checked == true) { this.udte_StartTime.Enabled = true; this.udte_EndTime.Enabled = true; } else { this.udte_StartTime.Enabled = false; this.udte_EndTime.Enabled = false; } } private void checkBox1_CheckedChanged(object sender, EventArgs e) { if (this.checkBox1.Checked == true) { this.ute_DH.Enabled = true; } else { this.ute_DH.Enabled = false; } } private void FrmScrapSteel_Load(object sender, EventArgs e) { label1.BackColor = Color.LightGreen; label3.BackColor = Color.LightCyan; label18.BackColor = Color.White; this.udte_StartTime.Text = System.DateTime.Now.AddDays(-2).ToString("yyyy-MM-dd")+" 00:00:00"; this.udte_EndTime.Text = System.DateTime.Now.ToString("yyyy-MM-dd")+" 23:59:59"; GetRLMX_Data(); GetZL_SCJH(); GetZL_Thread(); this.utlcbdevNo.SelectedIndex = 3; cbb_FGZL.SelectedIndex = 0; } /// /// 获取转炉生产计划记录 /// private void GetZL_SCJH() { try { string szOut = "",strWhere = ""; int RowID_1 = 0, RowID_2 = 0, RowID_3 = 0; this.dataTable2.Rows.Clear(); this.dataTable3.Rows.Clear(); this.dataTable4.Rows.Clear(); if (this.checkBox2.Checked == true) { strWhere = " and PLAN_MAKING_TIME between to_date('" + this.udte_StartTime.Value + "','yyyy-MM-dd HH24:mi:ss') and to_date('" + this.udte_EndTime.Value + "','yyyy-MM-dd HH24:mi:ss') "; } else { //strWhere = " and a.aim_grade_code=b.steelcode and (heat_state='03' or heat_state='04') and PLAN_MAKING_TIME between to_date('" + this.udte_StartTime.Value + "','yyyy-MM-dd HH24:mi:ss') and to_date('" + this.udte_EndTime.Value + "','yyyy-MM-dd HH24:mi:ss') "; strWhere = " and PLAN_MAKING_TIME between to_date('" + System.DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00','yyyy-MM-dd HH24:mi:ss') and to_date('" + System.DateTime.Now.ToString("yyyy-MM-dd") + " 23:59:59','yyyy-MM-dd HH24:mi:ss')"; } ArrayList arry = new ArrayList(); ArrayList sqlList = new ArrayList(); arry.Add("GetZL_SCJH.query"); sqlList.Add(strWhere); CoreClientParam CCP_LgEts = new CoreClientParam(); DataTable dt = new DataTable(); CCP_LgEts.ServerName = "Core.LgMes.Server.Common.ComDBQuery"; CCP_LgEts.MethodName = "doQuery"; CCP_LgEts.ServerParams = new object[] { arry, sqlList }; CCP_LgEts.SourceDataTable = dt; this.ExecuteQueryToDataTable(CCP_LgEts, CoreInvokeType.Internal); DataSet ds = new DataSet(); ds.Tables.Add(dt); szOut = CCP_LgEts.ReturnInfo; //DataSet ds = null;// (DataSet)Core.Mes.ClientFrameWork.ClientCommon._RemotingHelp.ExecuteMethod("lgResMgt", "Core.LgMes.Server.LgResMgt.LfsCollect", "GetZYJH_Data", new object[] { strWhere }, out szOut); if (szOut == "") { if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ds.Tables[0].Rows[i]["routeline"].ToString().Substring(5, 1) == "1") { DataRow dr = this.dataTable2.NewRow(); for (int j = 0; j < this.dataTable2.Columns.Count; j++) { dr[this.dataTable2.Columns[j].ColumnName.ToString()] = ds.Tables[0].Rows[i][this.dataTable2.Columns[j].ColumnName.ToString()].ToString(); } this.dataTable2.Rows.Add(dr); if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "计划状态") //计划状态 { foreach (UltraGridCell cell in ultraGrid2.Rows[RowID_1].Cells) { cell.Appearance.BackColor = Color.White;//计划状态 } } else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产状态") { foreach (UltraGridCell cell in ultraGrid2.Rows[RowID_1].Cells) cell.Appearance.BackColor = Color.LightGreen;//生产状态 } else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产完成") { foreach (UltraGridCell cell in ultraGrid2.Rows[RowID_1].Cells) cell.Appearance.BackColor = Color.LightCyan;//生产完成 } RowID_1 += 1; } if (ds.Tables[0].Rows[i]["routeline"].ToString().Substring(5, 1) == "2") { DataRow dr = this.dataTable3.NewRow(); for (int j = 0; j < this.dataTable3.Columns.Count; j++) { dr[this.dataTable3.Columns[j].ColumnName.ToString()] = ds.Tables[0].Rows[i][this.dataTable3.Columns[j].ColumnName.ToString()].ToString(); } this.dataTable3.Rows.Add(dr); if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "计划状态") //计划状态 { foreach (UltraGridCell cell in ultraGrid3.Rows[RowID_2].Cells) { cell.Appearance.BackColor = Color.White;//计划状态 } } else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产状态") { foreach (UltraGridCell cell in ultraGrid3.Rows[RowID_2].Cells) cell.Appearance.BackColor = Color.LightGreen;//生产状态 } else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产完成") { foreach (UltraGridCell cell in ultraGrid3.Rows[RowID_2].Cells) cell.Appearance.BackColor = Color.LightCyan;//生产状态 } RowID_2 += 1; } if (ds.Tables[0].Rows[i]["routeline"].ToString().Substring(5, 1) == "3") { DataRow dr = this.dataTable4.NewRow(); for (int j = 0; j < this.dataTable4.Columns.Count; j++) { dr[this.dataTable4.Columns[j].ColumnName.ToString()] = ds.Tables[0].Rows[i][this.dataTable4.Columns[j].ColumnName.ToString()].ToString(); } this.dataTable4.Rows.Add(dr); if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "计划状态") //计划状态 { foreach (UltraGridCell cell in ultraGrid4.Rows[RowID_3].Cells) { cell.Appearance.BackColor = Color.White;//计划状态 } } else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产状态") { foreach (UltraGridCell cell in ultraGrid4.Rows[RowID_3].Cells) cell.Appearance.BackColor = Color.LightGreen;//计划状态 } else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产完成") { foreach (UltraGridCell cell in ultraGrid4.Rows[RowID_3].Cells) cell.Appearance.BackColor = Color.LightCyan;//生成完成 } RowID_3 += 1; } } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } /// /// 打开窗体时自动取入炉明细数据 /// private void GetRLMX_Data() { try { this.dataTable1.Rows.Clear(); string szOut = "", strWhere = ""; if (this.checkBox2.Checked == true) { strWhere = " where JOBDATE between to_date('" + this.udte_StartTime.Value + "','yyyy-MM-dd HH24:mi:ss') and to_date('" + this.udte_EndTime.Value + "','yyyy-MM-dd HH24:mi:ss') "; } else { strWhere = " where JOBDATE between to_date('" + System.DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00','yyyy-MM-dd HH24:mi:ss') and to_date('" + System.DateTime.Now.ToString("yyyy-MM-dd") + " 23:59:59','yyyy-MM-dd HH24:mi:ss')"; } if (this.checkBox1.Checked == true) { strWhere += " and CHARGENO = '" + ute_DH.Text.ToString().Trim() + "' "; } ArrayList arry = new ArrayList(); ArrayList sqlList = new ArrayList(); arry.Add("GetRLMX_Data.query"); sqlList.Add(strWhere); CoreClientParam CCP_LgEts = new CoreClientParam(); DataTable dt = new DataTable(); CCP_LgEts.ServerName = "Core.LgMes.Server.Common.ComDBQuery"; CCP_LgEts.MethodName = "doQuery"; CCP_LgEts.ServerParams = new object[] { arry, sqlList }; CCP_LgEts.SourceDataTable = dt; this.ExecuteQueryToDataTable(CCP_LgEts, CoreInvokeType.Internal); DataSet ds = new DataSet(); ds.Tables.Add(dt); szOut = CCP_LgEts.ReturnInfo; //DataSet ds = null;// (DataSet)Core.Mes.ClientFrameWork.ClientCommon._RemotingHelp.ExecuteMethod("lgResMgt", "Core.LgMes.Server.LgResMgt.LfsCollect", "GetRLMX_Data", new object[] { strWhere }, out szOut); if (szOut == "") { if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow dr = this.dataTable1.NewRow(); for (int j = 0; j < this.dataTable1.Columns.Count; j++) { if (dataTable1.Columns[j].ColumnName == "BC") { string v_BC = ""; if (ds.Tables[0].Rows[i]["BC"].ToString().Length > 1) v_BC = ds.Tables[0].Rows[i]["BC"].ToString().Trim().Substring(1, 1); if (v_BC == "1") dr[dataTable1.Columns[j].ColumnName] = "甲班"; if (v_BC == "2") dr[dataTable1.Columns[j].ColumnName] = "乙班"; if (v_BC == "3") dr[dataTable1.Columns[j].ColumnName] = "丙班"; if (v_BC == "4") dr[dataTable1.Columns[j].ColumnName] = "丁班"; } else if (dataTable1.Columns[j].ColumnName == "ZYSJ") { dr["ZYSJ"] = Convert.ToDateTime(ds.Tables[0].Rows[i]["ZYSJ"].ToString()).ToString("yyyy-MM-dd HH:mm:ss"); } else { if (ds.Tables[0].Columns.Contains(dataTable1.Columns[j].ColumnName) && !string.IsNullOrEmpty(ds.Tables[0].Rows[i][dataTable1.Columns[j].ColumnName].ToString())) dr[dataTable1.Columns[j].ColumnName] = ds.Tables[0].Rows[i][dataTable1.Columns[j].ColumnName].ToString(); } } this.dataTable1.Rows.Add(dr); } this.dataTable1.AcceptChanges(); SetSteelSum(); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } /// /// 统计废钢重量 /// private void SetSteelSum() { 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 = 7; i < 14; 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; } /// /// 菜单栏 /// /// /// public override void ToolBar_Click(object sender, string ToolbarKey) { base.ToolBar_Click(sender, ToolbarKey); switch (ToolbarKey) { case "Add"://新增 try { ute_RLSJ.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); } catch { return; } AddNewData(); GetRLMX_Data(); break; case "Update"://修改 if (!string.IsNullOrEmpty(ute_DH2.Text.Trim()) && !string.IsNullOrEmpty(ultNo.Text.Trim())) { DialogResult result; string mk = "确实要修改吗?"; result = MessageBox.Show(this, mk, "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { if (ultraGrid1.ActiveRow != null) { try { DateTime aa = Convert.ToDateTime(ute_RLSJ.Text.ToString()); string strXH = this.ultraGrid1.ActiveRow.Cells["ZYXH"].Value.ToString().Trim(); UpdateDataRow(strXH); GetRLMX_Data(); } catch { MessageBox.Show("入炉时间 不是合法的日期时间!\n\n请重新选择入炉时间!", "提示"); } } else { MessageBox.Show("请选择需要修改的记录!", "提示"); } } } else MessageBox.Show("请选择需要修改的记录!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); break; case "Delete"://删除 if (!string.IsNullOrEmpty(ute_DH2.Text.Trim()) && !string.IsNullOrEmpty(this.ultNo.Text.Trim())) { DialogResult result; string mk = "确实要删除吗?"; result = MessageBox.Show(this, mk, "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { string strXH = this.ultraGrid1.ActiveRow.Cells["ZYXH"].Value.ToString().Trim(); DeleteDataRow(strXH); GetRLMX_Data(); } } else { MessageBox.Show("请选择要删除的行!", "提示"); } break; case "Query":// 查询 GetRLMX_Data(); GetZL_SCJH(); break; case "Export"://导Excel try { if (ultraTabControl1.SelectedTab.Text.Trim() != "入炉明细") return; if (ultraGrid1.ActiveRow != null) { string StrfileName = string.Format(System.Windows.Forms.Application.StartupPath + "\\Report\\{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 "Exit": this.Close(); break; default: break; } } /// /// 新增记录 /// private void AddNewData() { try { if (ute_DH2.Text.Trim().Length == 0) { MessageBox.Show("溜槽号不能为空,请输入溜槽号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } if (ute_ZZ.Text.Trim().Length == 0) { MessageBox.Show("没有废钢信息,请输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } string strErr = ""; string m_szCurrClass = ""; ArrayList arry = new ArrayList(); arry.Add("GetClassCode.query"); CommonClientToServer ccs = new CommonClientToServer(); ccs.ob = this.ob; DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr); if (ds.Tables[0].Rows.Count > 0) { m_szCurrClass = ds.Tables[0].Rows[0]["mes"].ToString(); // +Convert.ToString(cbb_BC.SelectedIndex + 1); } string[] ArrayCZXX = new string[21] { "", "", "", "", "", "", "", "", "", "", "", "", "","","","","","","","",""}; //保存信息 ArrayCZXX[0] = ute_DH2.Text.Trim(); ArrayCZXX[1] = ute_STZL.Text.Trim(); ArrayCZXX[2] = ute_RLZL.Text.Trim(); ArrayCZXX[3] = ute_LH.Text.Trim(); ArrayCZXX[4] = ute_CLZ.Text.Trim(); ArrayCZXX[5] = ute_ZZ.Text.Trim(); int v_BC = this.cbb_BC.SelectedIndex + 1; //ArrayCZXX[6] = Core.LgMes.Client.LgResMgt.StaticFunction.GetClassCode() + Convert.ToString(v_BC); //班次 ArrayCZXX[6] = m_szCurrClass; //班次 ArrayCZXX[7] = ute_HGLZ.Text.Trim(); ArrayCZXX[8] = ute_DZ.Text.Trim(); ArrayCZXX[9] = cbb_FGZL.Text.Trim(); ArrayCZXX[10] = ute_ZGZL.Text.Trim(); ArrayCZXX[11] = Convert.ToDateTime(ute_RLSJ.Text.Trim().ToString()).ToString("yyyy-MM-dd HH:mm:ss"); ArrayCZXX[12] = ute_BZ.Text.Trim(); ArrayCZXX[13] = this.UserInfo.GetUserName(); if (this.utlcbdevNo.SelectedItem != null) ArrayCZXX[14] = this.utlcbdevNo.SelectedItem.DataValue.ToString(); else ArrayCZXX[14] = ""; ArrayCZXX[15] = ute_C.Text.Trim(); ArrayCZXX[16] = ute_Si.Text.Trim(); ArrayCZXX[17] = ute_Mn.Text.Trim(); ArrayCZXX[18] = ute_P.Text.Trim(); ArrayCZXX[19] = ute_S.Text.Trim(); ArrayCZXX[20] = ute_As.Text.Trim(); string strError = ""; string SQLid="AddNewData.Add"; //if (ute_LH.Text.Trim().Length > 0) //{ Cursor oldCursor = this.Cursor; this.Cursor = Cursors.WaitCursor;//等待光标 try { CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods"; ccp.MethodName = "procedure_A"; ccp.ServerParams = new object[] { "res_lg_lfsmanage.InsertFG ", ArrayCZXX }; ExecuteNonQuery(ccp, CoreInvokeType.Internal); strError = ccp.ReturnInfo; if (strError != "") { this.Cursor = oldCursor; MessageBox.Show("新增不成功,查看输入的熔炼号废钢是否已添加!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { MessageBox.Show(" 废钢新增成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); this.Cursor = oldCursor; } } catch (System.Exception exp) { this.Cursor = oldCursor; MessageBox.Show("新增不成功!\n" + exp.ToString(), "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } //} } catch(Exception ex) { MessageBox.Show(ex.Message); } } /// /// 删除记录 /// private void DeleteDataRow(string strXH) { try { string szOut = ""; string[] strParams = new string[1] { strXH }; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods"; ccp.MethodName = "procedure_A"; ccp.ServerParams = new object[] { "RES_LG_LFSMANAGE.DeleteFG", strParams }; ExecuteNonQuery(ccp, CoreInvokeType.Internal); szOut = ccp.ReturnInfo; if (szOut != "") { MessageBox.Show(szOut, "删除失败!"); } else { MessageBox.Show("废钢信息删除成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); ClearData();//清除控件内容 } } catch(Exception ex) { MessageBox.Show(ex.Message); } } /// /// 清除内容 /// private void ClearData() { ute_DH2.Text = ""; ute_STZL.Text = ""; ute_RLZL.Text = ""; ute_LH.Text = ""; ute_CLZ.Text = ""; ute_ZZ.Text = ""; cbb_BC.Text = ""; ute_HGLZ.Text = ""; ute_DZ.Text = ""; cbb_FGZL.Text = ""; ute_ZGZL.Text = ""; ute_RLSJ.Text = ""; ute_BZ.Text = ""; ute_C.Text = ""; ute_Si.Text = ""; ute_Mn.Text = ""; ute_P.Text = ""; ute_S.Text = ""; ute_As.Text = ""; } private void ultraGrid1_Click(object sender, EventArgs e) { if (this.ultraGrid1.ActiveRow != null) { #region 先清除控件内的信息 ClearData(); #endregion #region 选中ultragrid中一行时,自动将对应的值赋给下面的控件 ute_DH2.Text = this.ultraGrid1.ActiveRow.Cells["ZDDH"].Value.ToString(); ute_STZL.Text = this.ultraGrid1.ActiveRow.Cells["STZL"].Value.ToString(); ute_RLZL.Text = this.ultraGrid1.ActiveRow.Cells["RLZL"].Value.ToString(); ute_LH.Text = this.ultraGrid1.ActiveRow.Cells["LH"].Value.ToString(); ute_CLZ.Text = this.ultraGrid1.ActiveRow.Cells["CLZL"].Value.ToString(); ute_ZZ.Text = this.ultraGrid1.ActiveRow.Cells["ZZ"].Value.ToString(); cbb_BC.Text = this.ultraGrid1.ActiveRow.Cells["BC"].Value.ToString(); ute_HGLZ.Text = this.ultraGrid1.ActiveRow.Cells["HGZL"].Value.ToString(); ute_DZ.Text = this.ultraGrid1.ActiveRow.Cells["DZ"].Value.ToString(); cbb_FGZL.Text = this.ultraGrid1.ActiveRow.Cells["FGZL"].Value.ToString(); ute_ZGZL.Text = this.ultraGrid1.ActiveRow.Cells["ZGZL"].Value.ToString(); ute_RLSJ.Text = Convert.ToDateTime(this.ultraGrid1.ActiveRow.Cells["ZYSJ"].Value.ToString()).ToString("yyyy-MM-dd HH:mm:ss"); ute_BZ.Text = this.ultraGrid1.ActiveRow.Cells["BZ"].Value.ToString(); ultNo.Text = this.ultraGrid1.ActiveRow.Cells["ZYXH"].Value.ToString(); if (!string.IsNullOrEmpty(this.ultraGrid1.ActiveRow.Cells["GWBH"].Value.ToString())) utlcbdevNo.Text = this.ultraGrid1.ActiveRow.Cells["GWBH"].Value.ToString(); ute_C.Text = this.ultraGrid1.ActiveRow.Cells["C"].Value.ToString(); ute_Mn.Text = this.ultraGrid1.ActiveRow.Cells["Mn"].Value.ToString(); ute_P.Text = this.ultraGrid1.ActiveRow.Cells["P"].Value.ToString(); ute_S.Text = this.ultraGrid1.ActiveRow.Cells["S"].Value.ToString(); ute_As.Text = this.ultraGrid1.ActiveRow.Cells["Asn"].Value.ToString(); #endregion } } /// /// 修改废钢配斗记录 /// /// private void UpdateDataRow(string strXH) { try { string[] ArrayCZXX = new string[22] { "","", "", "", "", "", "", "", "", "", "", "", "", "", "" ,"","","","","","",""}; //保存信息 string strErr = ""; string m_szCurrClass = ""; ArrayList arry = new ArrayList(); arry.Add("GetClassCode.query"); CommonClientToServer ccs = new CommonClientToServer(); ccs.ob = this.ob; //arry.Add(""); DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr); if (ds.Tables[0].Rows.Count > 0) { m_szCurrClass = ds.Tables[0].Rows[0]["mes"].ToString(); } ArrayCZXX[0] = ute_DH2.Text.Trim(); ArrayCZXX[1] = ute_STZL.Text.Trim(); ArrayCZXX[2] = ute_RLZL.Text.Trim(); ArrayCZXX[3] = ute_LH.Text.Trim(); ArrayCZXX[4] = ute_CLZ.Text.Trim(); ArrayCZXX[5] = ute_ZZ.Text.Trim(); ArrayCZXX[6] = m_szCurrClass; ArrayCZXX[7] = ute_HGLZ.Text.Trim(); ArrayCZXX[8] = ute_DZ.Text.Trim(); ArrayCZXX[9] = cbb_FGZL.Text.Trim(); ArrayCZXX[10] = ute_ZGZL.Text.Trim(); ArrayCZXX[11] = ute_RLSJ.Text.Trim(); ArrayCZXX[12] = ute_BZ.Text.Trim(); ArrayCZXX[13] = this.UserInfo.GetUserName(); ArrayCZXX[14] = strXH.ToString().Trim(); if (this.utlcbdevNo.SelectedItem != null) ArrayCZXX[15] = this.utlcbdevNo.SelectedItem.DataValue.ToString(); else ArrayCZXX[15] = ""; ArrayCZXX[16] = ute_C.Text.Trim(); ArrayCZXX[17] = ute_Si.Text.Trim(); ArrayCZXX[18] = ute_Mn.Text.Trim(); ArrayCZXX[19] = ute_P.Text.Trim(); ArrayCZXX[20] = ute_S.Text.Trim(); ArrayCZXX[21] = ute_As.Text.Trim(); Cursor oldCursor = this.Cursor; this.Cursor = Cursors.WaitCursor;//等待光标 try { string strError = ""; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods"; ccp.MethodName = "procedure_A"; ccp.ServerParams = new object[] { "RES_LG_LFSMANAGE.UpdateFG", ArrayCZXX }; ExecuteNonQuery(ccp, CoreInvokeType.Internal); strError = ccp.ReturnInfo; if (strError != "") { this.Cursor = oldCursor; MessageBox.Show("保存不成功!\n" + strError, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { this.Cursor = oldCursor; } } catch (System.Exception exp) { this.Cursor = oldCursor; MessageBox.Show("保存不成功!\n" + exp.ToString(), "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } // //实时刷新当前转炉正在冶炼的熔炼号 // private void GetZL_Thread() { try { myThread_FG = new Thread(new ThreadStart(getZLCurrentLH)); myThread_FG.Priority = ThreadPriority.Normal; myThread_FG.Start(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } /// /// 取当前转炉正在冶炼熔炼号 CVT01_DEVICE /// private void getZLCurrentLH() { try { System.Windows.Forms.Control.CheckForIllegalCrossThreadCalls = false; while (true) { if (!this.On_Off_Thread) { System.Threading.Thread.Sleep(500); continue; } this.ute_ZL1.Text = ""; this.ute_ZL2.Text = ""; this.ute_ZL3.Text = ""; //初始化颜色 ute_ZL1.Appearance.BackColor = Color.White;//.Gainsboro; ute_ZL2.Appearance.BackColor = Color.White; ute_ZL3.Appearance.BackColor = Color.White; string strError = ""; ArrayList arry = new ArrayList(); arry.Clear(); arry.Add("getZLCurrentLH.query"); CommonClientToServer ccs = new CommonClientToServer(); ccs.ob = this.ob; DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strError); if (strError == "") { if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { //初始化颜色 ute_ZL1.Appearance.BackColor = Color.White; ute_ZL2.Appearance.BackColor = Color.White; ute_ZL3.Appearance.BackColor = Color.White; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string v_ZLH = ds.Tables[0].Rows[i]["objectpos"].ToString().Substring(3, 2); string v_LH = (ds.Tables[0].Rows[i]["objectid"].ToString().Substring(5, ds.Tables[0].Rows[i]["objectid"].ToString().Length - 5)); if (ds.Tables[0].Rows[i]["objectid"].ToString().Substring(0, 1) == "V") v_LH = "V" + v_LH; if (v_ZLH == "01") { this.ute_ZL1.Text = v_LH; if (_strSendSucceededForBof1 == "N") ute_ZL1.Appearance.BackColor = Color.White; if (_strSendSucceededForBof1 == "" || _strSendSucceededForBof1 == "N") HeatNo_HudwId_Exist(v_LH,"01"); if (_strSendSucceededForBof1 == "Y") ute_ZL1.Appearance.BackColor = Color.LightBlue; } if (v_ZLH == "02") { this.ute_ZL2.Text = v_LH; if (_strSendSucceededForBof2 == "N") ute_ZL2.Appearance.BackColor = Color.White; if (_strSendSucceededForBof2 == "" || _strSendSucceededForBof2 == "N") HeatNo_HudwId_Exist(v_LH,"02"); if (_strSendSucceededForBof2 == "Y") ute_ZL2.Appearance.BackColor = Color.LightBlue; } if (v_ZLH == "03") { this.ute_ZL3.Text = v_LH; if (_strSendSucceededForBof3 == "N") ute_ZL3.Appearance.BackColor = Color.White; if (_strSendSucceededForBof3 == "" || _strSendSucceededForBof3 == "N") HeatNo_HudwId_Exist(v_LH,"03"); if (_strSendSucceededForBof3 == "Y") ute_ZL3.Appearance.BackColor = Color.LightBlue; } } } if (ute_ZL1.Text.Trim().Length == 0) _strSendSucceededForBof1 = "N"; if (ute_ZL2.Text.Trim().Length == 0) _strSendSucceededForBof2 = "N"; if (ute_ZL3.Text.Trim().Length == 0) _strSendSucceededForBof3 = "N"; } Thread.Sleep(10000); } } catch { } } private void ute_RLSJ_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e) { FrmSetTime frm = new FrmSetTime(null); frm.Location = StaticFunction.GetChildWindowLocation(frm.Size); frm.AutoSize = true; if (frm.ShowDialog() == DialogResult.OK) { } if(Convert.ToString(frm._returnTime).Substring(0,8)!="2000-1-1") ute_RLSJ.Text = Convert.ToDateTime(frm._returnTime).ToString("yyyy-MM-dd HH:mm:ss"); } /// /// 发送废钢到1#转炉 /// /// /// private void button1_Click(object sender, EventArgs e) { try { this.ultraGrid1.DisplayLayout.Bands[0].Override.WrapHeaderText = Infragistics.Win.DefaultableBoolean.True; string v_LH = this.ute_ZL1.Text.Trim().ToString(); if (v_LH.Length == 0) { MessageBox.Show("1#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示",MessageBoxButtons.OK,MessageBoxIcon.Asterisk); return; } string v_FGZL = this.ute_RLZL.Text.Trim().ToString(); string v_STZL = this.ute_STZL.Text.Trim().ToString(); string v_ZLH = "01"; string szOut = ""; string v_XH = this.ultNo.Text.Trim(); string[] strParams = new string[7] { v_LH, v_FGZL, v_STZL, v_ZLH, v_XH,"",""}; if (!string.IsNullOrEmpty(v_XH) && !string.IsNullOrEmpty(v_FGZL.Trim()) && !string.IsNullOrEmpty(v_STZL.Trim()) && !string.IsNullOrEmpty(v_LH.Trim()) ) { CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods"; ccp.MethodName = "procedure_A"; ccp.ServerParams = new object[] { "res_lg_lfsmanage.SendFG_ZL ", strParams }; ExecuteNonQuery(ccp, CoreInvokeType.Internal); szOut = ccp.ReturnInfo; if (szOut != "") { MessageBox.Show(szOut); } else { GetRLMX_Data(); _strSendSucceededForBof1 = "Y"; MessageBox.Show("废钢发送成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } else MessageBox.Show("序号,废钢重量,生铁重量不能为空值!\n 选择的废钢实绩与目标熔炼号不一样!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } catch (Exception ex) { MessageBox.Show(ex.Message); } } /// /// 发送废钢到2#转炉 /// /// /// private void button2_Click(object sender, EventArgs e) { try { string v_LH = this.ute_ZL2.Text.Trim().ToString(); if (v_LH.Length == 0) { MessageBox.Show("2#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } string v_FGZL = this.ute_RLZL.Text.Trim().ToString(); string v_STZL = this.ute_STZL.Text.Trim().ToString(); string v_ZLH = "02"; string szOut = ""; string v_XH = this.ultNo.Text.Trim(); string[] strParams = new string[7] { v_LH, v_FGZL, v_STZL, v_ZLH, v_XH, "", "" }; if (!string.IsNullOrEmpty(v_XH) && !string.IsNullOrEmpty(v_FGZL.Trim()) && !string.IsNullOrEmpty(v_STZL.Trim()) && !string.IsNullOrEmpty(v_LH.Trim())) { CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods"; ccp.MethodName = "procedure_A"; ccp.ServerParams = new object[] { "res_lg_lfsmanage.SendFG_ZL ", strParams }; ExecuteNonQuery(ccp, CoreInvokeType.Internal); szOut = ccp.ReturnInfo; if (szOut != "") { MessageBox.Show(szOut); } else { GetRLMX_Data(); _strSendSucceededForBof2 = "Y"; MessageBox.Show("废钢发送成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } else MessageBox.Show("熔炼号,废钢重量,生铁重量不能为空值!\n 选择的废钢实绩与目标熔炼号不一样!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } catch (Exception ex) { MessageBox.Show(ex.Message); } } /// /// 发送废钢到3#转炉 /// /// /// private void button3_Click(object sender, EventArgs e) { try { string v_LH = this.ute_ZL3.Text.Trim().ToString(); if (v_LH.Length == 0) { MessageBox.Show("3#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } string v_FGZL = this.ute_RLZL.Text.Trim().ToString(); string v_STZL = this.ute_STZL.Text.Trim().ToString(); string v_ZLH = "3"; string szOut = ""; string v_XH = this.ultNo.Text.Trim(); if (!string.IsNullOrEmpty(v_XH) && !string.IsNullOrEmpty(v_FGZL.Trim()) && !string.IsNullOrEmpty(v_STZL.Trim()) && !string.IsNullOrEmpty(v_LH.Trim())) { //hengxing Core.Mes.ClientFrameWork.ClientCommon._RemotingHelp.ExecuteMethod("lgResMgt", "Core.LgMes.Server.LgResMgt.LfsCollect", "SendZL1_FG", new object[] { v_LH, v_FGZL, v_STZL, v_ZLH, v_XH }, out szOut); if (szOut != "") { MessageBox.Show(szOut); } else { GetRLMX_Data(); _strSendSucceededForBof3 = "Y"; MessageBox.Show("废钢发送成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } else MessageBox.Show("熔炼号,废钢重量,生铁重量不能为空值!\n 选择的废钢实绩与目标熔炼号不一样!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } catch (Exception ex) { MessageBox.Show(ex.Message); } } private void ute_CLZ_KeyPress(object sender, KeyPressEventArgs e) { if (!(Char.IsNumber(e.KeyChar) || e.KeyChar == '.' || e.KeyChar == '\b' || e.KeyChar == '-')) { e.Handled = true; } } private void ultraGrid2_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e) { } private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e) { if (e.Tab.Index == 1) GetZL_SCJH(); } private void ultraGrid3_Click(object sender, EventArgs e) { DialogResult dgr = new DialogResult(); if (ultraGrid3.ActiveRow != null) { ute_LH.Text = ultraGrid3.ActiveRow.Cells["StoveID"].Value.ToString(); utlcbdevNo.SelectedIndex = 1; string ShiftCode = "", str = ""; if (dgr != DialogResult.Cancel) { //ShiftCode = "";//hengxing ((string)ClientCommon._RemotingHelp.ExecuteMethod("lgResMgt", "Core.LgMes.Server.LgResMgt.Iron", "BanCiBanBie", null, out str)).Trim().ToString(); ArrayList arry = new ArrayList(); arry.Add("GetClassCode.query"); CommonClientToServer ccs = new CommonClientToServer(); ccs.ob = this.ob; //arry.Add(""); DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out str); if (ds.Tables[0].Rows.Count > 0) { ShiftCode = ds.Tables[0].Rows[0]["mes"].ToString(); // +Convert.ToString(cbb_BC.SelectedIndex + 1); } if (!string.IsNullOrEmpty(ShiftCode)) { cbb_BC.SelectedIndex = Convert.ToInt16(ShiftCode.Substring(1, 1)) - 1; } } } } private void ultraGrid2_Click(object sender, EventArgs e) { DialogResult dgr = new DialogResult(); if (ultraGrid2.ActiveRow != null) { ute_LH.Text = ultraGrid2.ActiveRow.Cells["StoveID"].Value.ToString(); utlcbdevNo.SelectedIndex = 0; string ShiftCode = "", str = ""; if (dgr != DialogResult.Cancel) { //ShiftCode = "";//hengxing ((string)ClientCommon._RemotingHelp.ExecuteMethod("lgResMgt", "Core.LgMes.Server.LgResMgt.Iron", "BanCiBanBie", null, out str)).Trim().ToString(); ArrayList arry = new ArrayList(); arry.Add("GetClassCode.query"); CommonClientToServer ccs = new CommonClientToServer(); ccs.ob = this.ob; //arry.Add(""); DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out str); if (ds.Tables[0].Rows.Count > 0) { ShiftCode = ds.Tables[0].Rows[0]["mes"].ToString(); // +Convert.ToString(cbb_BC.SelectedIndex + 1); } if (!string.IsNullOrEmpty(ShiftCode)) { cbb_BC.SelectedIndex = Convert.ToInt16(ShiftCode.Substring(1, 1)) - 1; } } } } private void ultraGrid4_Click(object sender, EventArgs e) { DialogResult dgr = new DialogResult(); if (ultraGrid4.ActiveRow != null) { ute_LH.Text = ultraGrid4.ActiveRow.Cells["StoveID"].Value.ToString(); utlcbdevNo.SelectedIndex = 2; string ShiftCode = "", str = ""; if (dgr != DialogResult.Cancel) { //ShiftCode = "";//hengxing ((string)ClientCommon._RemotingHelp.ExecuteMethod("lgResMgt", "Core.LgMes.Server.LgResMgt.Iron", "BanCiBanBie", null, out str)).Trim().ToString(); ArrayList arry = new ArrayList(); arry.Add("GetClassCode.query"); CommonClientToServer ccs = new CommonClientToServer(); ccs.ob = this.ob; //arry.Add(""); DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out str); if (ds.Tables[0].Rows.Count > 0) { ShiftCode = ds.Tables[0].Rows[0]["mes"].ToString(); // +Convert.ToString(cbb_BC.SelectedIndex + 1); } if (!string.IsNullOrEmpty(ShiftCode)) { cbb_BC.SelectedIndex = Convert.ToInt16(ShiftCode.Substring(1, 1)) - 1; } } } } private void ute_RLSJ_KeyPress(object sender, KeyPressEventArgs e) { if (!(Char.IsNumber(e.KeyChar) || e.KeyChar == '.' || e.KeyChar == '\b')) { e.Handled = true; } } private void ute_RLZL_ValueChanged(object sender, EventArgs e) { Double dRlzl = 0, dDz = 0, dStzl = 0, dZlz = 0, dHgzl = 0, dZgzl = 0; //入炉重量,斗重,生铁重量,重料重,合格料重,渣钢重量 try { //生铁重量 if (!string.IsNullOrEmpty(ute_STZL.Text.Trim())) dStzl = Convert.ToDouble(ute_STZL.Text.Trim()); //重料重 if (!string.IsNullOrEmpty(ute_CLZ.Text.Trim())) dZlz = Convert.ToDouble(ute_CLZ.Text.Trim()); //合格料重 if (!string.IsNullOrEmpty(ute_HGLZ.Text.Trim())) dHgzl = Convert.ToDouble(ute_HGLZ.Text.Trim()); //渣钢重量 if (!string.IsNullOrEmpty(ute_ZGZL.Text.Trim())) dZgzl = Convert.ToDouble(ute_ZGZL.Text.Trim()); //斗重 if (!string.IsNullOrEmpty(ute_DZ.Text.Trim())) dDz = Convert.ToDouble(ute_DZ.Text.Trim()); dRlzl = dStzl + dZlz + dHgzl + dZgzl;//入炉重量 ute_RLZL.Text = Convert.ToString(dRlzl); //入炉重量 ute_ZZ.Text = Convert.ToString(dRlzl + dDz);//总重量 } catch { } } /// /// 判断是否已经发送废钢 /// /// <熔炼号="strID"> /// <炉座号="strGw"> private void HeatNo_HudwId_Exist(string strID, string strGw) { string strErr = ""; try { ArrayList arry = new ArrayList(); arry.Add("HeatNo_HudwId_Exist.query"); CommonClientToServer ccs = new CommonClientToServer(); ccs.ob = this.ob; arry.Add(strID); arry.Add(strID); DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr); if (strErr == "") { switch (strGw) { case "01": _strSendSucceededForBof1 = ds.Tables[0].Rows[0]["intCount"].ToString(); break; case "02": _strSendSucceededForBof2 = ds.Tables[0].Rows[0]["intCount"].ToString(); break; case "03": _strSendSucceededForBof3 = ds.Tables[0].Rows[0]["intCount"].ToString(); break; default: break; } } } catch { } } } }