using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Collections; using CoreFS.CA06; using Infragistics.Win.UltraWinGrid; using System.Threading; using System.Diagnostics; using System.IO; using Core.StlMes.Client.LgCommon; using Infragistics.Win.UltraWinEditors; using Infragistics.Win.Misc; namespace Core.StlMes.Client.LgResMgt { public partial class frmScrapSteel : frmStyleBase { private System.Threading.Thread myThread_FG; private ArrayList MaterCode; //物料编码 private ArrayList MaterName; //物料名称 private ArrayList MaterValue; //物料重量 private ArrayList EditorNameList; private ArrayList EditorValueList; private string _strSendSucceededForBof1 = ""; private string _strSendSucceededForBof2 = ""; private string _strSendSucceededForBof3 = ""; private string _strSendSucceededForBof4 = ""; private string _strSendSucceededForBof5 = ""; private bool ok_flag = false; public string workshopNo = ""; public frmScrapSteel() { InitializeComponent(); CheckForIllegalCrossThreadCalls = false; MaterCode = new ArrayList(); MaterName = new ArrayList(); MaterValue = new ArrayList(); EditorNameList = new ArrayList(); EditorValueList = new ArrayList(); } private void checkBox1_CheckedChanged(object sender, EventArgs e) { this.ute_DH.Enabled = checkBox1.Checked; } private void frmScrapSteel_Load(object sender, EventArgs e) { workshopNo = this.CustomInfo; 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"; ultraTabControl1.Tabs[0].Selected = true; chkSend.Checked = true; InitFrm(); GetZL_Thread(); cbb_BC.SelectedIndex = 0; GetZL_SCJH(); GetConfigMater(); setMaterEnable(); } // 根据体系显示控件 /// /// 根据体系显示控件 /// private void InitFrm() { EditorNameList.Add(materName1); EditorNameList.Add(materName2); EditorNameList.Add(materName3); EditorNameList.Add(materName4); EditorNameList.Add(materName5); EditorNameList.Add(materName6); EditorValueList.Add(materValue1); EditorValueList.Add(materValue2); EditorValueList.Add(materValue3); EditorValueList.Add(materValue4); EditorValueList.Add(materValue5); EditorValueList.Add(materValue6); if (workshopNo == "1") { ultraGroupBox2.Text = "1#转炉"; ultraGroupBox3.Text = "2#转炉"; ultraGroupBox4.Visible = false; splitter2.Visible = false; label15.Text = "1#转炉"; label16.Text = "2#转炉"; label17.Visible = false; ute_ZL3.Visible = false; button3.Visible = false; utlcbdevNo.Items.Clear(); utlcbdevNo.Items.Add("01","1#转炉"); utlcbdevNo.Items.Add("02","2#转炉"); } else { ultraGroupBox2.Text = "3#转炉"; ultraGroupBox3.Text = "4#转炉"; ultraGroupBox4.Text = "5#转炉"; ultraGroupBox4.Visible = true; splitter2.Visible = true; label15.Text = "3#转炉"; label16.Text = "4#转炉"; label17.Text = "5#转炉"; utlcbdevNo.Items.Clear(); utlcbdevNo.Items.Add("03","3#转炉"); utlcbdevNo.Items.Add("04","4#转炉"); utlcbdevNo.Items.Add("05","5#转炉"); } } // 获取转炉生产计划记录 /// /// 获取转炉生产计划记录 /// private void GetZL_SCJH() { try { string szOut = "", strWhere = ""; int RowID_1 = 0, RowID_2 = 0, RowID_3 = 0; string strStartTime = ""; string strEndTime = ""; this.dataTable2.Rows.Clear(); this.dataTable3.Rows.Clear(); this.dataTable4.Rows.Clear(); if (Convert.ToDateTime(udte_StartTime.Value) > Convert.ToDateTime(udte_EndTime.Value)) { MessageBox.Show("时间条件的开始时间不能大于结束时间!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); udte_EndTime.Focus(); return; } else { strStartTime = this.udte_StartTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss"); strEndTime = this.udte_EndTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss"); } strWhere = " and PLAN_MAKING_TIME between to_date('" + strStartTime + "','yyyy-MM-dd HH24:mi:ss') and to_date('" + strEndTime + "','yyyy-MM-dd HH24:mi:ss') "; //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.ExecuteSortResultByQueryToDataTable(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 (workshopNo == "1") //1体系 1,2转炉 { 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; } } else //2体系 3,4,5转炉 { if (ds.Tables[0].Rows[i]["routeline"].ToString().Substring(5, 1) == "3") { 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) == "4") { 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) == "5") { 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; } } } } } PublicMethod.RefreshAndAutoSize(ultraGrid2); PublicMethod.RefreshAndAutoSize(ultraGrid3); PublicMethod.RefreshAndAutoSize(ultraGrid4); } catch (Exception ex) { MessageBox.Show(ex.Message); } } // 获得已经配置的物料 /// /// 获得已经配置的物料 /// public void GetConfigMater() { try { string strErr = ""; ArrayList arry = new ArrayList(); arry.Add("ScrapSteel.Config"); arry.Add(workshopNo); CommonClientToServer ccs = new CommonClientToServer(); ccs.ob = this.ob; DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr); if (ds != null && ds.Tables[0].Rows.Count > 0) { string matercode = ""; string matername = ""; int m = 0; int count=ds.Tables[0].Rows.Count; for (int i = 0; i < count; i++) { matercode = ds.Tables[0].Rows[i]["SCRAPSTEELCODE"].ToString(); matername = ds.Tables[0].Rows[i]["SCRAPSTEELNAME"].ToString(); try { ((UltraLabel)EditorNameList[i]).Tag = matercode; ((UltraLabel)EditorNameList[i]).Text = matername; m++; } catch { } } for (int j = m; j < EditorNameList.Count; j++) { ((UltraLabel)EditorNameList[j]).Text = ""; } for (int n = 0; n < EditorValueList.Count; n++) { ((UltraTextEditor)EditorValueList[n]).Text = ""; } } setMaterEnable(); } catch { } } // 取入炉明细数据主表 /// /// 取入炉明细数据主表 /// private void GetRLMX_Data() { try { this.ultraDataSource1.Rows.Clear(); this.dataTable1.Rows.Clear(); DataSet SetMain = new DataSet(); string szOut = "", strWhere = ""; string strStartTime = ""; string strEndTime = ""; if (Convert.ToDateTime(udte_StartTime.Value) > Convert.ToDateTime(udte_EndTime.Value)) { MessageBox.Show("时间条件的开始时间不能大于结束时间!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); udte_EndTime.Focus(); return; } else { strStartTime = this.udte_StartTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss"); strEndTime = this.udte_EndTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss"); } strWhere = " where JOBDATE between to_date('" + strStartTime + "','yyyy-MM-dd HH24:mi:ss') and to_date('" + strEndTime + "','yyyy-MM-dd HH24:mi:ss') and WORKSHOPNO='" + workshopNo + "' "; // 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) { strWhere += " and CHARGENO = '" + ute_DH.Text.ToString().Trim() + "' "; } if (this.chkSend.Checked) { strWhere += " and (heatno is null or stationcode is null) "; } //获取主表信息 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.ExecuteSortResultByQueryToDataTable(CCP_LgEts, CoreInvokeType.Internal); SetMain.Tables.Clear(); SetMain.Tables.Add(dt.Copy()); SetMain.Tables[0].TableName = "Main"; DataSet ds = new DataSet(); ds.Tables.Add(dt.Copy()); szOut = CCP_LgEts.ReturnInfo; if (szOut != "" || ds.Tables[0].Rows.Count == 0) { ultraGrid1.DataSource = this.ultraDataSource1; return; } //获取从表信息 strWhere = " where FEEDINGTIME between to_date('" + strStartTime + "','yyyy-MM-dd HH24:mi:ss') and to_date('" + strEndTime + "','yyyy-MM-dd HH24:mi:ss') and WORKSHOPNO='" + workshopNo + "' "; if (this.chkSend.Checked) { strWhere += " and ISSEND ='0'"; } ArrayList arry1 = new ArrayList(); ArrayList sqlList1 = new ArrayList(); arry1.Add("ScrapSteelMaterAdd.Query"); sqlList1.Add(strWhere); CoreClientParam ccp = new CoreClientParam(); DataTable dt1 = new DataTable(); ccp.ServerName = "Core.LgMes.Server.Common.ComDBQuery"; ccp.MethodName = "doQuery"; ccp.ServerParams = new object[] { arry1, sqlList1 }; ccp.SourceDataTable = dt1; this.ExecuteSortResultByQueryToDataTable(ccp, CoreInvokeType.Internal); DataSet ds1 = new DataSet(); dt1.TableName = "Child"; ds1.Tables.Add(dt1.Copy()); szOut = CCP_LgEts.ReturnInfo; if (szOut != "" || ds1.Tables[0].Rows.Count == 0) { ultraGrid1.DataSource = this.ultraDataSource1; return; } SetMain.Tables.Add(ds1.Tables[0].Copy()); SetMain.Relations.Clear(); SetMain.Relations.Add("Band 1", SetMain.Tables["Main"].Columns["JOBID"], SetMain.Tables["Child"].Columns["JOBID"]); this.ultraGrid1.DataSource = SetMain; foreach (UltraGridRow row in ultraGrid1.Rows) { if (row.Cells["HEATNO"].Value.ToString().Trim() == "" && row.Cells["STATIONCODE"].Value.ToString().Trim() == "") { row.Appearance.BackColor = Color.LightCyan;//未发送状态 } else if (row.Cells["HEATNO"].Value.ToString().Trim() != "" && row.Cells["STATIONCODE"].Value.ToString().Trim() != "") { row.Appearance.BackColor = Color.LightGreen;//发送状态 } else { row.Appearance.BackColor = Color.White;//未知状态 } } SetSteelSum(); PublicMethod.RefreshAndAutoSize(ultraGrid1); } 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[5]); summary.SummaryPosition = SummaryPosition.UseSummaryPositionColumn; summary.DisplayFormat = "合计:"; for (int i = 6; i < 10; 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 AddNewData() { try { if (ute_DH2.Text.Trim().Length == 0) { MessageBox.Show("料斗号不能为空,请输入料斗号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); ute_DH2.Focus(); return; } if (ute_ZZ.Text.Trim().Length == 0) { MessageBox.Show("废钢总量不能为空,请输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } if (ute_ZZ.Text.Trim() == "0") { MessageBox.Show("废钢总量不能为零,请输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } //查询当前班次 string strErr = ""; string m_szCurrClass = ""; ArrayList arry = new ArrayList(); arry.Add("GetClassCode.query"); // 位于 QueryLgIntegration.xml 中 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(); } GetAllMater(); if (MaterCode.Count==0) { MessageBox.Show("没有物料信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } strErr = ""; string strSqlID = "frmScrapMater.Add"; object[] sArgs = new object[12]; sArgs[0] = MaterCode; //物料编码 sArgs[1] = MaterName; //物料名称 sArgs[2] = MaterValue; //物料重量 sArgs[3] = ute_DH2.Text.Trim(); //料斗号 sArgs[4] = (ute_RLSJ.Text.ToString() == ""?DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"): (Convert.ToDateTime(ute_RLSJ.Text.Trim())).ToString("yyyy-MM-dd HH:mm:ss")); //入炉时间 sArgs[5] = ute_RLZL.Text.Trim() == "" ? "0" : ute_RLZL.Text.Trim(); //入炉重量 sArgs[6] = ute_DZ.Text.Trim() == "" ? "0" : ute_DZ.Text.Trim(); // 料斗重 sArgs[7] = ute_ZZ.Text.Trim() == "" ? "0" : ute_ZZ.Text.Trim(); //总重 sArgs[8] = this.UserInfo.GetUserName(); //操作人 sArgs[9] = m_szCurrClass.Substring(0,1) + cbb_BC.Value.ToString().Trim(); //班次班组 sArgs[10] = ute_BZ.Text.Trim(); //备注 sArgs[11] = workshopNo; try { CommonClientToServer ccTs = new CommonClientToServer(); ccTs.ob = ob; string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure", "ExecProcWithCollParam", strSqlID, sArgs, out strErr); if (strErr != "") { ok_flag = false; MessageBox.Show("新增失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { ok_flag = true; MessageBox.Show(" 废钢新增成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } catch { } } catch { } } // 获取物料值 /// /// 获取物料值 /// private void GetAllMater() { try { MaterCode.Clear(); MaterName.Clear(); MaterValue.Clear(); GetAllMaterFun(materName1, materValue1); GetAllMaterFun(materName2, materValue2); GetAllMaterFun(materName3, materValue3); GetAllMaterFun(materName4, materValue4); GetAllMaterFun(materName5, materValue5); GetAllMaterFun(materName6, materValue6); } catch { } } private void GetAllMaterFun(UltraLabel editor1,UltraTextEditor editor2) { try { if (editor1.Text.Trim() != "") { MaterCode.Add(editor1.Tag.ToString()); MaterName.Add(editor1.Text.Trim()); MaterValue.Add(editor2.Text.Trim() == "" ? "0" : editor2.Text.Trim()); } } catch { } } // 删除记录 /// /// 删除记录 /// private void DeleteDataRow() { try { if (ultraGrid1.Rows.Count == 0 || ultraGrid1.ActiveRow == null) { MessageBox.Show("没有有效的废钢信息可删除!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } if (ultraGrid1.ActiveRow.Appearance.BackColor == Color.LightGreen || ute_LH.Text.Trim() != "") { MessageBox.Show("选取的废钢信息已发送不能删除!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } string strXH = ultNo.Text.Trim(); if (strXH == "") return; DialogResult dr = MessageBox.Show("是否确认删除废钢信息?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dr == DialogResult.No) return; string strErr = ""; string strSqlID = "frmScrapMater.Delete"; object[] sArgs = new object[1]; sArgs[0] = strXH; //序号 try { CommonClientToServer ccTs = new CommonClientToServer(); ccTs.ob = ob; string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure", "ExecProcWithCollParam", strSqlID, sArgs, out strErr); if (strErr != "") { MessageBox.Show("删除失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else { MessageBox.Show("删除成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); GetRLMX_Data(); } } catch { } } catch { } } // 清除编辑区内容 /// /// 清除编辑区内容 /// private void ClearData() { ute_DH2.Text = ""; materValue1.Text = ""; materValue2.Text = ""; materValue3.Text = ""; materValue4.Text = ""; materValue5.Text = ""; materValue6.Text = ""; utlcbdevNo.SelectedIndex = -1; ute_RLZL.Text = ""; ute_LH.Text = ""; ute_ZZ.Text = ""; cbb_BC.SelectedIndex=0; ute_DZ.Text = ""; ute_RLSJ.Text = ""; ute_BZ.Text = ""; } // 清除编辑区内容 /// /// 清除编辑区内容 /// private void ClearData1() { ute_DH2.Text = ""; materValue1.Text = ""; materValue2.Text = ""; materValue3.Text = ""; materValue4.Text = ""; materValue5.Text = ""; materValue6.Text = ""; ute_RLZL.Text = ""; ute_LH.Text = ""; ute_ZZ.Text = ""; cbb_BC.SelectedIndex = 0; ute_DZ.Text = ""; ute_RLSJ.Text = ""; ute_BZ.Text = ""; } // 修改记录 /// /// 修改记录 /// /// private void UpdateDataRow(string strXH) { try { if (ute_DH2.Text.Trim().Length == 0) { MessageBox.Show("料斗号不能为空,请输入料斗号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); ute_DH2.Focus(); return; } if (ute_ZZ.Text.Trim().Length == 0) { MessageBox.Show("废钢总量不能为空,请输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } if (ute_ZZ.Text.Trim() == "0") { MessageBox.Show("废钢总量不能为零,请输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } //查询当前班次 string strErr = ""; string m_szCurrClass = ""; ArrayList arry = new ArrayList(); arry.Add("GetClassCode.query"); // 位于 QueryLgIntegration.xml 中 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(); } GetAllMater(); if (MaterCode.Count == 0) { MessageBox.Show("没有物料信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } strErr = ""; string strSqlID = "frmScrapMater.Update"; object[] sArgs = new object[13]; sArgs[0] = MaterCode; //物料编码 sArgs[1] = MaterName; //物料名称 sArgs[2] = MaterValue; //物料重量 sArgs[3] = ultNo.Text.Trim(); //序号 sArgs[4] = ute_DH2.Text.Trim(); //料斗号 sArgs[5] = (ute_RLSJ.Text.ToString() == "" ? DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") : (Convert.ToDateTime(ute_RLSJ.Text.Trim())).ToString("yyyy-MM-dd HH:mm:ss")); //入炉时间 sArgs[6] = ute_RLZL.Text.Trim() == "" ? "0" : ute_RLZL.Text.Trim(); //入炉重量 sArgs[7] = ute_DZ.Text.Trim() == "" ? "0" : ute_DZ.Text.Trim(); // 料斗重 sArgs[8] = ute_ZZ.Text.Trim() == "" ? "0" : ute_ZZ.Text.Trim(); //总重 sArgs[9] = this.UserInfo.GetUserName(); //操作人 sArgs[10] = m_szCurrClass.Substring(0, 1) + cbb_BC.Value.ToString().Trim(); //班次班组 sArgs[11] = ute_BZ.Text.Trim(); //备注 sArgs[12] = workshopNo; try { CommonClientToServer ccTs = new CommonClientToServer(); ccTs.ob = ob; string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure", "ExecProcWithCollParam", strSqlID, sArgs, out strErr); if (strErr != "") { ok_flag = false; MessageBox.Show("修改失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { ok_flag = true; MessageBox.Show(" 修改成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } catch { } } catch { } } // 取消发送 /// /// 取消发送 /// private void CancelSend() { try { string strXH = ultNo.Text.Trim(); string strLH = ute_LH.Text.Trim(); string strStation = "01"; try { strStation = "0" + utlcbdevNo.Text.Trim().Substring(0, 1); } catch { } if (strLH == "") { MessageBox.Show("你选择的废钢信息还未发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } if (strLH != ute_ZL1.Text.Trim() && strLH != ute_ZL2.Text.Trim() && strLH != ute_ZL3.Text.Trim()) { MessageBox.Show("该炉次号不在转炉工序,不能取消!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } DialogResult dr = MessageBox.Show("确定取消已经发送的废钢信息?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dr == DialogResult.No) return; String strErr = ""; string strSqlID = "frmScrapMater.Cancel"; object[] sArgs = new object[2]; sArgs[0] = strLH; //炉号 sArgs[1] = strXH; //序号 CommonClientToServer ccTs = new CommonClientToServer(); ccTs.ob = ob; string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure", "ExecProcWithCollParam", strSqlID, sArgs, out strErr); if (strErr != "") { MessageBox.Show("废钢信息取消发送失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else { MessageBox.Show("废钢信息取消发送成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); GetRLMX_Data(); HeatNo_HudwId_Exist(strLH, strStation); } } catch { } } //实时刷新当前转炉正在冶炼的熔炼号 /// ///实时刷新当前转炉正在冶炼的熔炼号 /// 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); } } // 取当前转炉正在冶炼熔炼号 C##01_DEVICE /// /// 取当前转炉正在冶炼熔炼号 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 (workshopNo == "1") { if (v_ZLH == "01") { this.ute_ZL1.Text = v_LH; HeatNo_HudwId_Exist(v_LH, "01"); } if (v_ZLH == "02") { this.ute_ZL2.Text = v_LH; HeatNo_HudwId_Exist(v_LH, "02"); } } else { if (v_ZLH == "03") { this.ute_ZL1.Text = v_LH; HeatNo_HudwId_Exist(v_LH, "03"); } if (v_ZLH == "04") { this.ute_ZL2.Text = v_LH; HeatNo_HudwId_Exist(v_LH, "04"); } if (v_ZLH == "05") { this.ute_ZL3.Text = v_LH; HeatNo_HudwId_Exist(v_LH, "05"); } } } } } Thread.Sleep(10000); } } 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()=="0"?"N":"Y"; if (_strSendSucceededForBof1 == "N") ute_ZL1.Appearance.BackColor = Color.White; if (_strSendSucceededForBof1 == "Y") ute_ZL1.Appearance.BackColor = Color.LightBlue; break; case "02": _strSendSucceededForBof2 = ds.Tables[0].Rows[0]["intCount"].ToString() == "0" ? "N" : "Y"; if (_strSendSucceededForBof2 == "N") ute_ZL2.Appearance.BackColor = Color.White; if (_strSendSucceededForBof2 == "Y") ute_ZL2.Appearance.BackColor = Color.LightBlue; break; case "03": _strSendSucceededForBof3 = ds.Tables[0].Rows[0]["intCount"].ToString() == "0" ? "N" : "Y"; if (_strSendSucceededForBof3 == "N") ute_ZL1.Appearance.BackColor = Color.White; if (_strSendSucceededForBof3 == "Y") ute_ZL1.Appearance.BackColor = Color.LightBlue; break; case "04": _strSendSucceededForBof4 = ds.Tables[0].Rows[0]["intCount"].ToString() == "0" ? "N" : "Y"; if (_strSendSucceededForBof4 == "N") ute_ZL2.Appearance.BackColor = Color.White; if (_strSendSucceededForBof4 == "Y") ute_ZL2.Appearance.BackColor = Color.LightBlue; break; case "05": _strSendSucceededForBof5 = ds.Tables[0].Rows[0]["intCount"].ToString() == "0" ? "N" : "Y"; if (_strSendSucceededForBof5 == "N") ute_ZL3.Appearance.BackColor = Color.White; if (_strSendSucceededForBof5 == "Y") ute_ZL3.Appearance.BackColor = Color.LightBlue; break; default: break; } } } catch { } } // 点击修改或删除时显示确认和取消按钮 /// /// 点击修改或删除时显示确认和取消按钮 /// /// private void SetDetailToolBarEnable(bool bEnable,string flag) { int count = this.ultraToolbarsManager1.Tools.Count; for (int i = 0; i < count; i++) { this.ultraToolbarsManager1.Tools[i].SharedProps.Enabled = !bEnable; } if (bEnable == true && flag == "add") { this.ultraToolbarsManager1.Tools["Custom"].SharedProps.Visible = true; this.ultraToolbarsManager1.Tools["Custom"].SharedProps.Enabled = true; } else { this.ultraToolbarsManager1.Tools["Custom"].SharedProps.Visible = false; this.ultraToolbarsManager1.Tools["Custom"].SharedProps.Enabled = false; } this.ultraToolbarsManager1.Tools["ok"].SharedProps.Enabled = bEnable; this.ultraToolbarsManager1.Tools["cancel"].SharedProps.Enabled = bEnable; this.ultraToolbarsManager1.Tools["ok"].SharedProps.Visible = bEnable; this.ultraToolbarsManager1.Tools["cancel"].SharedProps.Visible = bEnable; } // 设置物料区域是否可编辑 /// /// 设置物料区域是否可编辑 /// /// private void setMaterEnable() { try { setMaterEnableFun(materName1, materValue1); setMaterEnableFun(materName2, materValue2); setMaterEnableFun(materName3, materValue3); setMaterEnableFun(materName4, materValue4); setMaterEnableFun(materName5, materValue5); setMaterEnableFun(materName6, materValue6); } catch { } } private void setMaterEnableFun(UltraLabel editro1, UltraTextEditor editro2) { try { if (editro1.Text.Trim() == "") { editro1.Enabled = false; editro2.Enabled = false; } else { editro1.Enabled = true; editro2.Enabled = true; } } catch { } } // 设置编辑区域是否可编辑 /// /// 设置编辑区域是否可编辑 /// /// private void setToolEnable(bool t_Enable) { try { ute_DH2.ReadOnly = t_Enable; materValue1.ReadOnly = t_Enable; materValue2.ReadOnly = t_Enable; materValue3.ReadOnly = t_Enable; materValue4.ReadOnly = t_Enable; materValue5.ReadOnly = t_Enable; materValue6.ReadOnly = t_Enable; ute_RLZL.ReadOnly = t_Enable; cbb_BC.ReadOnly = t_Enable; ute_DZ.ReadOnly = t_Enable; ute_RLSJ.ReadOnly = t_Enable; ute_BZ.ReadOnly = t_Enable; } catch { } } // 系统菜单栏 /// /// 系统菜单栏 /// /// /// 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(); GetRLMX_Data(); } } else { MessageBox.Show("请选择要删除的行!", "提示"); } break; case "Query":// 查询 if (ultraTabControl1.SelectedTab.Key == "Plan") { GetZL_SCJH(); } else { GetRLMX_Data(); } break; case "Config": try { frmSteelConfiger config = new frmSteelConfiger(ob); config.Tag = this; config.WorkShopNo = workshopNo; config.ShowDialog(); } catch (Exception ex) { MessageBox.Show(ex.Message); } break; case "Export"://导出Excel try { Core.Mes.Client.Comm.Globals.ulGridToExcel(ultraGrid1, Text); } catch (Exception ex) { MessageBox.Show(ex.Message); } break; case "Cancel"://取消发送 try { CancelSend(); } catch (Exception ex) { MessageBox.Show(ex.Message); } break; case "Exit": this.Close(); break; default: break; } } private void ultraGrid1_AfterRowActivate(object sender, EventArgs e) { try { if (this.ultraGrid1.Rows.Count == 0 || this.ultraGrid1.ActiveRow == null) { return; } UltraGridRow row = null; if (ultraGrid1.ActiveRow.HasParent()) { row = ultraGrid1.ActiveRow.ParentRow; } else { row = ultraGrid1.ActiveRow; } SetDetailToolBarEnable(false,""); setToolEnable(true); ClearData(); ultNo.Text = row.Cells["JOBID"].Value.ToString(); ute_LH.Text = row.Cells["HEATNO"].Value.ToString(); utlcbdevNo.Text = row.Cells["STATIONCODE"].Value.ToString(); ute_DH2.Text = row.Cells["CHARGENO"].Value.ToString(); ute_RLSJ.Text = row.Cells["JOBDATE"].Value.ToString(); ute_RLZL.Text = row.Cells["JOINSTOVEWGT"].Value.ToString(); ute_DZ.Text = row.Cells["CHUTEWGT"].Value.ToString(); ute_ZZ.Text = row.Cells["TOTALWGT"].Value.ToString(); ute_BZ.Text = row.Cells["MEMO"].Value.ToString(); cbb_BC.Text = row.Cells["SHIFTCODE"].Value.ToString(); if (row.HasChild()) { string matercode = ""; string matername = ""; string matervalue = ""; int m=0; for (int i = 0; i < row.ChildBands["Band 1"].Rows.Count; i++) { matercode = row.ChildBands["Band 1"].Rows[i].Cells["SCRAPSTEELCODE"].Value.ToString(); matername = row.ChildBands["Band 1"].Rows[i].Cells["SCRAPSTEELNAME"].Value.ToString(); matervalue = row.ChildBands["Band 1"].Rows[i].Cells["JMWGT"].Value.ToString(); try { ((UltraLabel)EditorNameList[i]).Tag = matercode; ((UltraLabel)EditorNameList[i]).Text = matername; ((UltraTextEditor)EditorValueList[i]).Text = matervalue; m++; } catch { } } for (int j = m; j < EditorNameList.Count; j++) { ((UltraLabel)EditorNameList[j]).Text=""; } setMaterEnable(); } } catch { } } private void ute_RLSJ_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e) { try { frmSetTime frm = new frmSetTime(e.Context); //frm.Location = ClsControlPack.GetChildWindowLocation(frm.Size); frm.Location = new Point(556,376);//ClsControlPack.GetChildWindowLocation(frm.Size); frm.AutoSize = true; if (frm.ShowDialog() == DialogResult.OK) { ute_RLSJ.Text = (Convert.ToDateTime(frm.SelectDate.ToString())).ToString("yyyy-MM-dd HH:mm:ss"); ute_RLSJ.Update(); } } catch{} } // 发送废钢到1#或3#转炉 /// /// 发送废钢到1#或3#转炉 /// /// /// private void button1_Click(object sender, EventArgs e) { try { string v_LH = this.ute_ZL1.Text.Trim().ToString(); if (v_LH.Length == 0) { if (workshopNo == "1") { MessageBox.Show("1#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else { MessageBox.Show("3#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } return; } if (ultraGrid1.Rows.Count == 0 || ultraGrid1.ActiveRow == null) { MessageBox.Show("没有有效的废钢信息可发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } if (ultraGrid1.ActiveRow.Appearance.BackColor == Color.LightGreen) { MessageBox.Show("选取的废钢信息已发送,不能重复发送\n如需重新发送,请先取消发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } if (ute_ZL1.Appearance.BackColor == Color.LightBlue) { DialogResult dr = MessageBox.Show("当前炉号已发送过废钢信息,是否替换原来已经发送的废钢信息?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dr == DialogResult.No) return; } this.ultraGrid1.DisplayLayout.Bands[0].Override.WrapHeaderText = Infragistics.Win.DefaultableBoolean.True; string v_XH = this.ultNo.Text.Trim(); string v_RLZL = ute_RLZL.Text.Trim(); string v_ZLH = ""; if (workshopNo == "1") { v_ZLH = "01"; } else { v_ZLH = "03"; } if (v_RLZL == "0" || v_RLZL == "") { MessageBox.Show("废钢总重为零,发送无意义!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } if (v_XH == "") { MessageBox.Show("序号不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } string strErr = ""; string strSqlID = "frmScrapMater.Send"; object[] sArgs = new object[3]; sArgs[0] = v_LH; //炉号 sArgs[1] = v_ZLH; //炉座号 sArgs[2] = v_XH; //序号 CommonClientToServer ccTs = new CommonClientToServer(); ccTs.ob = ob; string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure", "ExecProcWithCollParam", strSqlID, sArgs, out strErr); if (strErr != "") { MessageBox.Show("废钢发送失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } else { GetRLMX_Data(); if (workshopNo == "1") { _strSendSucceededForBof1 = "Y"; HeatNo_HudwId_Exist(v_LH, "01"); } else { _strSendSucceededForBof3 = "Y"; HeatNo_HudwId_Exist(v_LH, "03"); } MessageBox.Show("废钢发送成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } catch { } } // 发送废钢到2#或4#转炉 /// /// 发送废钢到2#或4#转炉 /// /// /// private void button2_Click(object sender, EventArgs e) { try { string v_LH = this.ute_ZL2.Text.Trim().ToString(); if (v_LH.Length == 0) { if (workshopNo == "1") { MessageBox.Show("2#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else { MessageBox.Show("4#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } return; } if (ultraGrid1.Rows.Count == 0 || ultraGrid1.ActiveRow == null) { MessageBox.Show("没有有效的废钢信息可发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } if (ultraGrid1.ActiveRow.Appearance.BackColor == Color.LightGreen) { MessageBox.Show("选取的废钢信息已发送,不能重复发送\n如需重新发送,请先取消发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } if (ute_ZL2.Appearance.BackColor == Color.LightBlue) { DialogResult dr = MessageBox.Show("当前炉号已发送过废钢信息,是否替换原来已经发送的废钢信息?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dr == DialogResult.No) return; } string v_XH = this.ultNo.Text.Trim(); string v_RLZL = ute_RLZL.Text.Trim(); string v_ZLH = ""; if (workshopNo == "1") { v_ZLH = "02"; } else { v_ZLH = "04"; } if (v_RLZL == "0" || v_RLZL == "") { MessageBox.Show("废钢总重为零,发送无意义!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } if (v_XH == "") { MessageBox.Show("序号不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } string strErr = ""; string strSqlID = "frmScrapMater.Send"; object[] sArgs = new object[3]; sArgs[0] = v_LH; //炉号 sArgs[1] = v_ZLH; //炉座号 sArgs[2] = v_XH; //序号 CommonClientToServer ccTs = new CommonClientToServer(); ccTs.ob = ob; string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure", "ExecProcWithCollParam", strSqlID, sArgs, out strErr); if (strErr != "") { MessageBox.Show("废钢发送失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } else { GetRLMX_Data(); if (workshopNo == "1") { _strSendSucceededForBof2 = "Y"; HeatNo_HudwId_Exist(v_LH, "02"); } else { _strSendSucceededForBof4 = "Y"; HeatNo_HudwId_Exist(v_LH, "04"); } MessageBox.Show("废钢发送成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } catch { } } // 发送废钢到5#转炉 /// /// 发送废钢到5#转炉 /// /// /// 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("5#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } if (ultraGrid1.Rows.Count == 0 || ultraGrid1.ActiveRow == null) { MessageBox.Show("没有有效的废钢信息可发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } if (ultraGrid1.ActiveRow.Appearance.BackColor == Color.LightGreen) { MessageBox.Show("选取的废钢信息已发送,不能重复发送\n如需重新发送,请先取消发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } if (ute_ZL3.Appearance.BackColor == Color.LightBlue) { DialogResult dr = MessageBox.Show("当前炉号已发送过废钢信息,是否替换原来已经发送的废钢信息?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dr == DialogResult.No) return; } string v_XH = this.ultNo.Text.Trim(); string v_RLZL = ute_RLZL.Text.Trim(); string v_ZLH = "05"; if (v_RLZL == "0" || v_RLZL == "") { MessageBox.Show("废钢总重为零,发送无意义!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } if (v_XH == "") { MessageBox.Show("序号不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } string strErr = ""; string strSqlID = "frmScrapMater.Send"; object[] sArgs = new object[3]; sArgs[0] = v_LH; //炉号 sArgs[1] = v_ZLH; //炉座号 sArgs[2] = v_XH; //序号 CommonClientToServer ccTs = new CommonClientToServer(); ccTs.ob = ob; string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure", "ExecProcWithCollParam", strSqlID, sArgs, out strErr); if (strErr != "") { MessageBox.Show("废钢发送失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } else { GetRLMX_Data(); _strSendSucceededForBof5 = "Y"; HeatNo_HudwId_Exist(v_LH, "05"); MessageBox.Show("废钢发送成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } catch { } } // 选择生产计划隐藏相应功能 /// /// 选择生产计划隐藏相应功能 /// /// /// private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e) { if (e.Tab.Index == 1) GetZL_SCJH(); if (ultraTabControl1.SelectedTab.Key == "Plan") { ultraToolbarsManager1.Enabled = false; this.ToolBarItemEnable(this, "Cancel", false); this.ToolBarItemEnable(this, "Export", false); label28.Text = "计划开始时间"; label2.Text = "计划结束时间"; groupBox6.Size=new System.Drawing.Size(228, 40); label1.Text = "生产状态"; label1.BackColor = Color.LightGreen; label18.Text = "计划状态"; label18.BackColor = Color.White; label3.Text = "结束状态"; label3.Visible = true; checkBox1.Enabled = false; chkSend.Enabled = false; udte_EndTime.Location = new Point(317, 11); if (Convert.ToDateTime(udte_StartTime.Value) > Convert.ToDateTime(udte_EndTime.Value)) { //MessageBox.Show("时间条件的开始时间不能大于结束时间!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); udte_EndTime.Focus(); return; } GetZL_SCJH(); } else { ultraToolbarsManager1.Enabled = true; this.ToolBarItemEnable(this, "Cancel", true); this.ToolBarItemEnable(this, "Export", true); label28.Text = "入炉时间 从"; label2.Text = "到"; groupBox6.Size = new System.Drawing.Size(163, 40); label18.Text = "已发送"; label18.BackColor = Color.LightGreen; label1.Text = "未发送"; label1.BackColor = Color.LightCyan; label3.Visible = false; chkSend.Enabled = true; checkBox1.Enabled = true; udte_EndTime.Location = new Point(265, 11); if (Convert.ToDateTime(udte_StartTime.Value) > Convert.ToDateTime(udte_EndTime.Value)) { // MessageBox.Show("时间条件的开始时间不能大于结束时间!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); udte_EndTime.Focus(); return; } GetRLMX_Data(); } } private void ultraGrid3_Click(object sender, EventArgs e) { } 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_ZZ_ValueChanged(object sender, EventArgs e) { Double dRlzl = 0, dDz = 0, dFg = 0; //入炉重量,斗重, 废钢重量 try { //废钢重量 if (!string.IsNullOrEmpty(materValue1.Text.Trim())) { dFg += Convert.ToDouble(materValue1.Text.Trim()); } if (!string.IsNullOrEmpty(materValue2.Text.Trim())) { dFg += Convert.ToDouble(materValue2.Text.Trim()); } if (!string.IsNullOrEmpty(materValue3.Text.Trim())) { dFg += Convert.ToDouble(materValue3.Text.Trim()); } if (!string.IsNullOrEmpty(materValue4.Text.Trim())) { dFg += Convert.ToDouble(materValue4.Text.Trim()); } if (!string.IsNullOrEmpty(materValue5.Text.Trim())) { dFg += Convert.ToDouble(materValue5.Text.Trim()); } if (!string.IsNullOrEmpty(materValue6.Text.Trim())) { dFg += Convert.ToDouble(materValue6.Text.Trim()); } if (!string.IsNullOrEmpty(ute_DZ.Text.Trim())) { dDz += Convert.ToDouble(ute_DZ.Text.Trim()); } dRlzl = dFg;//入炉重量 if (dRlzl == 0) { if (!string.IsNullOrEmpty(ute_RLZL.Text.Trim())) { dRlzl = Convert.ToDouble(ute_RLZL.Text.Trim()); } } ute_RLZL.Text = Convert.ToString(dRlzl); //入炉重量 ute_ZZ.Text = Convert.ToString(dRlzl + dDz);//总重量 } catch { } } private void ute_RLZL_ValueChanged(object sender, EventArgs e) { try { string strRlzl = ute_RLZL.Text.Trim(); if (ute_RLZL.Focused) { for (int i = 0; i < EditorValueList.Count; i++) { ((Infragistics.Win.UltraWinEditors.UltraTextEditor)EditorValueList[i]).Text = "0"; } Double dRlzl = 0, dDz = 0; if (!string.IsNullOrEmpty(strRlzl)) { dDz += Convert.ToDouble(strRlzl); } if (!string.IsNullOrEmpty(ute_DZ.Text.Trim())) { dDz += Convert.ToDouble(ute_DZ.Text.Trim()); } ute_ZZ.Text = Convert.ToString(dRlzl + dDz);//总重量 } } catch { } } private void NumberInput_KeyPress(object sender, KeyPressEventArgs e) { if (!(Char.IsNumber(e.KeyChar) || e.KeyChar == '\b' || e.KeyChar == '.')) { e.Handled = true; } char[] arrary = ((UltraTextEditor)sender).Text.ToCharArray(); if (e.KeyChar == '.') { if (arrary.Length == 0) { ((UltraTextEditor)sender).Text = "0."; ((UltraTextEditor)sender).SelectionStart = ((UltraTextEditor)sender).Text.Trim().Length; e.Handled = true; } else { for (int i = 0; i < arrary.Length; i++) { if (arrary[i] == '.') e.Handled = true; } } } if (arrary.Length == 1) { if (e.KeyChar == '0') { if (arrary[0] == '0') e.Handled = true; } if (arrary[0] == '0' && e.KeyChar != '.' && e.KeyChar != '\b' && e.KeyChar != '0'&&!(Char.IsNumber(e.KeyChar))) { ((UltraTextEditor)sender).Text = e.KeyChar.ToString(); ((UltraTextEditor)sender).SelectionStart = ((UltraTextEditor)sender).Text.Trim().Length; e.Handled = true; } } } private void HeatNoInput_KeyPress(object sender, KeyPressEventArgs e) { if (!(Char.IsNumber(e.KeyChar) || e.KeyChar == '\b')) { e.Handled = true; } } private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e) { string Job_ID = ultNo.Text.Trim(); switch (e.Tool.Key) { case "add": // ClearData1(); SetDetailToolBarEnable(true,"add"); setToolEnable(false); this.uTbMTool.Tools["ok"].Tag = "add"; ultNo.Clear(); ute_LH.Clear(); utlcbdevNo.SelectedIndex = -1; ute_RLSJ.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); for (int i = 0; i < EditorValueList.Count; i++) { ((Infragistics.Win.UltraWinEditors.UltraTextEditor)EditorValueList[i]).Text = "0"; } ute_RLZL.Text = "0"; ute_DZ.Text = "0"; ute_ZZ.Text = "0"; break; case "edit": if (ultraGrid1.Rows.Count==0) { MessageBox.Show("无有效信息可以修改", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } if (ultraGrid1.ActiveRow.Appearance.BackColor == Color.LightGreen || ute_LH.Text.Trim() != "") { MessageBox.Show("选取的废钢信息已发送不能修改!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); return; } SetDetailToolBarEnable(true,"edit"); setToolEnable(false); this.uTbMTool.Tools["ok"].Tag = "edit"; break; case "del": if (Job_ID.Length == 0) { MessageBox.Show("无有效的数据可删除!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } DeleteDataRow(); break; case "ok": string flag = this.uTbMTool.Tools["ok"].Tag.ToString(); if (flag == "edit") { if (Job_ID.Length == 0) { MessageBox.Show("无有效的数据可操作!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } if (flag == "add") { AddNewData(); } if (flag == "edit") { UpdateDataRow(Job_ID); } if (!ok_flag) return; SetDetailToolBarEnable(false,""); setToolEnable(true); GetRLMX_Data(); break; case "cancel": SetDetailToolBarEnable(false,""); setToolEnable(true); ultraGrid1_AfterRowActivate(null,null); break; case "left": if (ultraGrid1.Rows.Count == 0) return; //将位置移动到前一条记录 try { if (ultraGrid1.ActiveRow == null) { ultraGrid1.Rows[0].Activate(); } else { int nIndex = ultraGrid1.ActiveRow.Index; nIndex = nIndex - 1; if (nIndex < 0) nIndex = ultraGrid1.Rows.Count-1; ultraGrid1.Rows[nIndex].Activate(); } } catch { } break; case "right": if (ultraGrid1.Rows.Count == 0) return; //将位置移动到后一条记录 try { if (ultraGrid1.ActiveRow == null) { ultraGrid1.Rows[0].Activate(); } else { int nIndex = ultraGrid1.ActiveRow.Index; nIndex = nIndex + 1; if (nIndex >= ultraGrid1.Rows.Count) nIndex = 0; ultraGrid1.Rows[nIndex].Activate(); } } catch { } break; case "Custom": //初始化物料 try { GetConfigMater(); materValue1.Text = ""; materValue2.Text = ""; materValue3.Text = ""; materValue4.Text = ""; materValue5.Text = ""; materValue6.Text = ""; } catch { } break; } } private void chkSend_CheckedChanged(object sender, EventArgs e) { GetRLMX_Data(); } } }