using System; using System.Collections.Generic; using System.ComponentModel; using System.Drawing; using System.Data; using System.Text; using System.Windows.Forms; using Core.Mes.ClientFrameWork; using Core.Mes.ServerFrameWork; using System.Collections; using Core.Mes.IBaseInterface; using Infragistics.Win.UltraWinGrid; namespace Core.LgMes.Client.LgJobMgt { public partial class FrmProductQueryQuery : UserControl { public delegate void ReportSelect(string strCastNo, string strBlockNo); public ReportSelect reportSelect; public delegate void ReportHandSet(string strHeatID, int nBegin, int nEnd); public ReportHandSet reportHandSet; public FrmProductQueryQuery() { InitializeComponent(); } private DataTable steelSchTable, cutSchTable;//调度、切割指示表 private Hashtable routeHash = new Hashtable();//存放工艺路径 public FrmCutBilletDetailQuery FrmMain; //public Core.Mes.ClientFrameWork.RemotingHelp; private void InitComboBoxSource() { this.ccmNumCobo.DataSource = GetCcmData(); this.ccmNumCobo.DisplayMember = "name"; this.ccmNumCobo.ValueMember = "id"; this.combConNo.DataSource = GetConData(); this.combConNo.DisplayMember = "name"; this.combConNo.ValueMember = "id"; } private void createTable()//----创建对应表 { try { //炼钢指示表 DataColumn myDataColumn = new DataColumn(); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "HEAT_ID"; myDataColumn.Caption = "炉号"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_STL_GRD"; myDataColumn.Caption = "目标钢号"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "CCM_ID"; myDataColumn.Caption = "铸机"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "CAST_NO"; myDataColumn.Caption = "浇次号"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "HEAT_CNT"; myDataColumn.Caption = "炉数"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "HEAT_SEQ"; myDataColumn.Caption = "顺序"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "PLN_ROUTE"; myDataColumn.Caption = "工艺路径"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_SB_BT_CNT"; myDataColumn.Caption = "板(方)坯数"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_S"; myDataColumn.Caption = "目标含硫量"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_IRON_NET_WGT"; myDataColumn.Caption = "计划铁水量"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_MIF_STR_TIME"; myDataColumn.Caption = "计划出铁开始时刻"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_MIF_END_TIME"; myDataColumn.Caption = "计划出铁结束时刻"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_KR_STR_TIME"; myDataColumn.Caption = "计划预处理开始时刻"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_KR_END_TIME"; myDataColumn.Caption = "计划预处理结束时刻"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_HM_STR_TIME"; myDataColumn.Caption = "计划装料开始时刻"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_BLOW_STR_TIME"; myDataColumn.Caption = "计划吹炼开始时刻"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_TAP_STR_TIME"; myDataColumn.Caption = "计划出钢开始时刻"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_TAP_END_TIME"; myDataColumn.Caption = "计划出钢结束时刻"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_STEEL_NET_WGT"; myDataColumn.Caption = "目标出钢量"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_TAP_TEMP"; myDataColumn.Caption = "出钢目标温度"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_AR_STR_TIME"; myDataColumn.Caption = "计划AR开始时刻"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_AR_END_TIME"; myDataColumn.Caption = "计划AR结束时刻"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_AR_TEMP"; myDataColumn.Caption = "AR目标温度"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_LF_STR_TIME"; myDataColumn.Caption = "计划LF开始时刻"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_LF_END_TIME"; myDataColumn.Caption = "计划LF结束时刻"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_LF_TEMP"; myDataColumn.Caption = "LF目标温度"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_VD_STR_TIME"; myDataColumn.Caption = "计划RH开始时刻"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_VD_END_TIME"; myDataColumn.Caption = "计划RH结束时刻"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_VD_TEMP"; myDataColumn.Caption = "RH目标温度"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_CAST_STR_TIME"; myDataColumn.Caption = "计划浇注开始时刻"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_CAST_END_TIME"; myDataColumn.Caption = "计划浇注结束时刻"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_TD_TEMP"; myDataColumn.Caption = "浇注温度"; steelSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "HEATSTATUS"; myDataColumn.Caption = "生产状态"; steelSchTable.Columns.Add(myDataColumn); //切割指示表 myDataColumn = new DataColumn(); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "HEAT_ID"; myDataColumn.Caption = "炉号"; cutSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "SB_BT_ID"; myDataColumn.Caption = "计划板坯号"; cutSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_LTH"; myDataColumn.Caption = "目标长度"; cutSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_DISP"; myDataColumn.Caption = "计划去向"; cutSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "CCM_ID"; myDataColumn.Caption = "铸机号"; cutSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "CAST_NO"; myDataColumn.Caption = "浇次号"; cutSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "HEAT_CNT"; myDataColumn.Caption = "浇次内炉数"; cutSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "HEAT_SEQ"; myDataColumn.Caption = "浇次内炉序"; cutSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "CUT_PLN_DATE"; myDataColumn.Caption = "计划切割时间"; cutSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_THK"; myDataColumn.Caption = "目标厚度"; cutSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "AIM_WTH"; myDataColumn.Caption = "目标宽度"; cutSchTable.Columns.Add(myDataColumn); myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "SL_BT_WGT"; myDataColumn.Caption = "坯料重量"; cutSchTable.Columns.Add(myDataColumn); } catch (Exception ex) { string msg = ex.Message; } } private void setGrid1View()//----设置grid外观 { try { ultraGrid1.DisplayLayout.Override.HeaderAppearance.BackColor = System.Drawing.Color.FromArgb(205, 228, 225); ultraGrid1.DisplayLayout.Override.RowSelectorAppearance.BackColor = System.Drawing.Color.FromArgb(205, 228, 225); ultraGrid1.DisplayLayout.Override.RowAlternateAppearance.BackColor = Color.GhostWhite; ultraGrid1.DisplayLayout.Bands[0].Columns["HEATSTATUS"].Hidden = false; ultraGrid1.DisplayLayout.Bands[0].Columns[0].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultraGrid1.DisplayLayout.Bands[0].Columns[1].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultraGrid1.DisplayLayout.Bands[0].Columns[2].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultraGrid1.DisplayLayout.Bands[0].Columns[3].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultraGrid1.DisplayLayout.Bands[0].Columns[4].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultraGrid1.DisplayLayout.Bands[0].Columns[5].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultraGrid1.DisplayLayout.Bands[0].Columns[6].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultraGrid1.DisplayLayout.Bands[0].Columns[7].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultraGrid1.DisplayLayout.Bands[0].Columns[8].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultraGrid1.DisplayLayout.Bands[0].Columns[9].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultraGrid1.DisplayLayout.Bands[0].Columns[10].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultraGrid1.DisplayLayout.Bands[0].Columns[11].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultraGrid1.DisplayLayout.Bands[0].Columns[12].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultraGrid1.DisplayLayout.Bands[0].Columns[13].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultraGrid1.DisplayLayout.Bands[0].Columns[14].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultraGrid1.DisplayLayout.Bands[0].Columns[15].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultraGrid1.DisplayLayout.Bands[0].Columns[16].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultraGrid1.DisplayLayout.Bands[0].Columns[17].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultraGrid1.DisplayLayout.Bands[0].Columns[18].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultraGrid1.DisplayLayout.Bands[0].Columns[19].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultraGrid1.DisplayLayout.Bands[0].Columns[20].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit; ultraGrid1.DisplayLayout.Bands[0].Columns[15].Format = "yy-MM-dd HH:mm"; ultraGrid1.DisplayLayout.Bands[0].Columns[16].Format = "yy-MM-dd HH:mm"; ultraGrid1.DisplayLayout.Bands[0].Columns[17].Format = "yy-MM-dd HH:mm"; ultraGrid1.DisplayLayout.Bands[0].Columns[18].Format = "yy-MM-dd HH:mm"; ultraGrid1.DisplayLayout.Bands[0].Columns[19].Format = "yy-MM-dd HH:mm"; ultraGrid1.DisplayLayout.Bands[0].Columns[20].Format = "yy-MM-dd HH:mm"; ultraGrid1.DisplayLayout.Bands[0].Columns[21].Format = "yy-MM-dd HH:mm"; ultraGrid1.DisplayLayout.Bands[0].Columns["heat_id"].Width = 80; ultraGrid1.DisplayLayout.Bands[0].Columns["AIM_STL_GRD"].Width = 60; ultraGrid1.DisplayLayout.Bands[0].Columns["CCM_ID"].Width = 40; ultraGrid1.DisplayLayout.Bands[0].Columns["CAST_NO"].Width = 38; ultraGrid1.DisplayLayout.Bands[0].Columns["HEAT_CNT"].Width = 50; ultraGrid1.DisplayLayout.Bands[0].Columns["HEAT_SEQ"].Width = 38; ultraGrid1.DisplayLayout.Bands[0].Columns["AIM_S"].Width = 50; ultraGrid1.DisplayLayout.Bands[0].Columns["PLN_ROUTE"].Width = 230; ultraGrid1.DisplayLayout.Bands[0].Columns["AIM_SB_BT_CNT"].Width = 38; ultraGrid1.DisplayLayout.Bands[0].Columns[10].Width = 70; ultraGrid1.DisplayLayout.Bands[0].Columns[11].Width = 70; ultraGrid1.DisplayLayout.Bands[0].Columns[12].Width = 70; ultraGrid1.DisplayLayout.Bands[0].Columns[13].Width = 70; ultraGrid1.DisplayLayout.Bands[0].Columns[14].Width = 70; ultraGrid1.DisplayLayout.Bands[0].Columns[15].Width = 70; ultraGrid1.DisplayLayout.Bands[0].Columns[16].Width = 70; ultraGrid1.DisplayLayout.Bands[0].Columns[17].Width = 70; ultraGrid1.DisplayLayout.Bands[0].Columns["AIM_TD_TEMP"].Width = 50; ultraGrid1.DisplayLayout.Bands[0].Columns[1].CellAppearance.BackColor = Color.GhostWhite; ultraGrid1.DisplayLayout.Bands[0].Columns[2].CellAppearance.BackColor = Color.GhostWhite; ultraGrid1.DisplayLayout.Bands[0].Columns[3].CellAppearance.BackColor = Color.GhostWhite; ultraGrid1.DisplayLayout.Bands[0].Columns[4].CellAppearance.BackColor = Color.GhostWhite; ultraGrid1.DisplayLayout.Bands[0].Columns[5].CellAppearance.BackColor = Color.GhostWhite; ultraGrid1.DisplayLayout.Bands[0].Columns[6].CellAppearance.BackColor = Color.GhostWhite; ultraGrid1.DisplayLayout.Bands[0].Columns[7].CellAppearance.BackColor = Color.GhostWhite; ultraGrid1.DisplayLayout.Bands[0].Columns[8].CellAppearance.BackColor = Color.GhostWhite; ultraGrid1.DisplayLayout.Bands[0].Columns[9].CellAppearance.BackColor = Color.GhostWhite; ultraGrid1.DisplayLayout.Bands[0].Columns[10].CellAppearance.BackColor = Color.GhostWhite; ultraGrid1.DisplayLayout.Bands[0].Columns[11].CellAppearance.BackColor = Color.GhostWhite; ultraGrid1.DisplayLayout.Bands[0].Columns[12].CellAppearance.BackColor = Color.GhostWhite; ultraGrid1.DisplayLayout.Bands[0].Columns[13].CellAppearance.BackColor = Color.GhostWhite; ultraGrid1.DisplayLayout.Bands[0].Columns[14].CellAppearance.BackColor = Color.GhostWhite; ultraGrid1.DisplayLayout.Bands[0].Columns[15].CellAppearance.BackColor = Color.GhostWhite; ultraGrid1.DisplayLayout.Bands[0].Columns[16].CellAppearance.BackColor = Color.GhostWhite; ultraGrid1.DisplayLayout.Bands[0].Columns[17].CellAppearance.BackColor = Color.GhostWhite; ultraGrid1.DisplayLayout.Bands[0].Columns[18].CellAppearance.BackColor = Color.GhostWhite; ultraGrid1.DisplayLayout.Bands[0].Columns[19].CellAppearance.BackColor = Color.LightGoldenrodYellow; ultraGrid1.DisplayLayout.Bands[0].Columns[20].CellAppearance.BackColor = Color.LightGoldenrodYellow; ultraGrid1.DisplayLayout.Bands[0].Columns[21].CellAppearance.BackColor = Color.LightGoldenrodYellow; ultraGrid1.DisplayLayout.Bands[0].Columns[22].CellAppearance.BackColor = Color.LightPink; ultraGrid1.DisplayLayout.Bands[0].Columns[23].CellAppearance.BackColor = Color.LightPink; ultraGrid1.DisplayLayout.Bands[0].Columns[24].CellAppearance.BackColor = Color.LightPink; ultraGrid1.DisplayLayout.Bands[0].Columns[25].CellAppearance.BackColor = Color.LightPink; ultraGrid1.DisplayLayout.Bands[0].Columns[26].CellAppearance.BackColor = Color.LightPink; ultraGrid1.DisplayLayout.Bands[0].Columns[27].CellAppearance.BackColor = Color.LightPink; ultraGrid1.DisplayLayout.Bands[0].Columns[28].CellAppearance.BackColor = Color.LightSalmon; ultraGrid1.DisplayLayout.Bands[0].Columns[29].CellAppearance.BackColor = Color.LightSalmon; ultraGrid1.DisplayLayout.Bands[0].Columns[30].CellAppearance.BackColor = Color.LightSalmon; ultraGrid1.DisplayLayout.Bands[0].Columns[31].CellAppearance.BackColor = Color.LightSkyBlue; ultraGrid1.DisplayLayout.Bands[0].Columns[32].CellAppearance.BackColor = Color.LightSkyBlue; //ultraGrid1.DisplayLayout.Bands[0].Columns[33].CellAppearance.BackColor = Color.LightSkyBlue; //ultraGrid1.DisplayLayout.Bands[0].Columns[34].CellAppearance.BackColor = Color.LightYellow; //ultraGrid1.DisplayLayout.Bands[0].Columns[35].CellAppearance.BackColor = Color.LightYellow; //ultraGrid1.DisplayLayout.Bands[0].Columns[36].CellAppearance.BackColor = Color.LightYellow; //ultraGrid1.DisplayLayout.Bands[0].Columns[37].CellAppearance.BackColor = Color.LightSteelBlue; //ultraGrid1.DisplayLayout.Bands[0].Columns[38].CellAppearance.BackColor = Color.LightSteelBlue; //ultraGrid1.DisplayLayout.Bands[0].Columns[39].CellAppearance.BackColor = Color.LightSteelBlue; //ultraGrid1.DisplayLayout.Bands[0].Columns[40].CellAppearance.BackColor = Color.LightSteelBlue; //ultraGrid1.DisplayLayout.Bands[0].Columns[41].CellAppearance.BackColor = Color.LightSteelBlue; ultraGrid2.DisplayLayout.Override.HeaderAppearance.BackColor = System.Drawing.Color.FromArgb(205, 228, 225); ultraGrid2.DisplayLayout.Override.RowSelectorAppearance.BackColor = System.Drawing.Color.FromArgb(205, 228, 225); ultraGrid2.DisplayLayout.Override.RowAlternateAppearance.BackColor = Color.GhostWhite; // ultraGrid2.DisplayLayout.Bands[0].Columns[0].Hidden = true; ultraGrid2.DisplayLayout.Bands[0].Columns["heat_id"].Width = 80; ultraGrid2.DisplayLayout.Bands[0].Columns["SB_BT_ID"].Width = 100; ultraGrid2.DisplayLayout.Bands[0].Columns["AIM_LTH"].Width = 50; ultraGrid2.DisplayLayout.Bands[0].Columns["CCM_ID"].Width = 50; ultraGrid2.DisplayLayout.Bands[0].Columns["CAST_NO"].Width =50; ultraGrid2.DisplayLayout.Bands[0].Columns["HEAT_CNT"].Width = 50; ultraGrid2.DisplayLayout.Bands[0].Columns["AIM_DISP"].Width = 70; ultraGrid2.DisplayLayout.Bands[0].Columns[7].Width = 60; ultraGrid2.DisplayLayout.Bands[0].Columns[8].Width = 120; ultraGrid2.DisplayLayout.Bands[0].Columns[9].Width = 70; ultraGrid2.DisplayLayout.Bands[0].Columns[10].Width = 70; ultraGrid2.DisplayLayout.Bands[0].Columns[11].Width = 70; ultraGrid2.DisplayLayout.Bands[0].Columns[12].Width = 70; } catch (Exception ex) { string msg = ex.Message; } } private string analysPath(string craftPath)//----路径解析 { string path = ""; try { if (craftPath.Length > 14) { string str = "", route = ""; if (craftPath.Length >= 2) { str = craftPath.Substring(0, 2); switch (str) { case "A0": route = ""; break; case "A1": route = "1#混铁炉"; break; case "A2": route = "2#混铁炉"; break; } path = path + route; } else return path; if (craftPath.Length >= 4) { str = craftPath.Substring(2, 2); switch (str) { case "B0": route = ""; break; case "B1": route = "->1#铁水预处理"; break; case "B2": route = "->2#铁水预处理"; break; } path = path + route; } else return path; if (craftPath.Length >= 6) { str = craftPath.Substring(4, 2); switch (str) { case "C0": route = ""; break; case "C1": route = "->1#转炉"; break; case "C2": route = "->2#转炉"; break; case "C3": route = "->3#转炉"; break; } path = path + route; } else return path; if (craftPath.Length >= 8) { str = craftPath.Substring(6, 2); switch (str) { case "D0": route = ""; break; case "D1": route = "->1#吹氩站"; break; case "D2": route = "->2#吹氩站"; break; case "D3": route = "->3#吹氩站"; break; } path = path + route; } else return path; ///2008-02-28 刘现 if (craftPath.Length >= 10) { str = craftPath.Substring(8, 2); switch (str) { case "F0": route = ""; break; case "F1": route = "->1#RH炉"; break; } path = path + route; } else return path; if (craftPath.Length >= 12) { str = craftPath.Substring(10, 2); switch (str) { case "E0": route = ""; break; case "E1": route = "->1#精练"; break; case "E2": route = "->2#精练"; break; } path = path + route; } else return path; if (craftPath.Length >= 14) { str = craftPath.Substring(12, 2); switch (str) { case "F0": route = ""; break; case "F1": route = "->1#RH炉"; break; } path = path + route; } else return path; if (craftPath.Length >= 14) { str = craftPath.Substring(14, 2); switch (str) { case "G0": route = ""; break; case "G1": route = "->1#连铸机"; break; case "G2": route = "->2#连铸机"; break; case "G3": route = "->3#连铸机"; break; case "G4": route = "->0#连铸机"; break; } path = path + route; } else return path; if (path.Length < 2) return ""; if (path.IndexOf("->", 0) == 0) { int len = path.Length; path = path.Substring(2, len - 2); } } else { string str = "", route = ""; if (craftPath.Length >= 2) { str = craftPath.Substring(0, 2); switch (str) { case "A0": route = ""; break; case "A1": route = "1#混铁炉"; break; case "A2": route = "2#混铁炉"; break; } path = path + route; } else return path; if (craftPath.Length >= 4) { str = craftPath.Substring(2, 2); switch (str) { case "B0": route = ""; break; case "B1": route = "->1#铁水预处理"; break; case "B2": route = "->2#铁水预处理"; break; } path = path + route; } else return path; if (craftPath.Length >= 6) { str = craftPath.Substring(4, 2); switch (str) { case "C0": route = ""; break; case "C1": route = "->1#转炉"; break; case "C2": route = "->2#转炉"; break; case "C3": route = "->3#转炉"; break; } path = path + route; } else return path; if (craftPath.Length >= 8) { str = craftPath.Substring(6, 2); switch (str) { case "D0": route = ""; break; case "D1": route = "->1#吹氩站"; break; case "D2": route = "->2#吹氩站"; break; case "D3": route = "->3#吹氩站"; break; } path = path + route; } else return path; if (craftPath.Length >= 10) { str = craftPath.Substring(8, 2); switch (str) { case "E0": route = ""; break; case "E1": route = "->1#精练"; break; case "E2": route = "->2#精练"; break; } path = path + route; } else return path; if (craftPath.Length >= 12) { str = craftPath.Substring(10, 2); switch (str) { case "F0": route = ""; break; case "F1": route = "->1#RH炉"; break; case "F2": route = "->2#RH炉"; break; } path = path + route; } else return path; if (craftPath.Length >= 14) { str = craftPath.Substring(12, 2); switch (str) { case "G0": route = ""; break; case "G1": route = "->1#连铸机"; break; case "G2": route = "->2#连铸机"; break; case "G3": route = "->3#连铸机"; break; case "G4": route = "->0#连铸机"; break; } path = path + route; } else return path; if (path.Length < 2) return ""; if (path.IndexOf("->", 0) == 0) { int len = path.Length; path = path.Substring(2, len - 2); } } return path; } catch (Exception ex) { string msg = ex.Message; return path; } } private DataTable GetCcmData() { DataTable dt = new DataTable(); dt.Columns.Add("id", typeof(System.String)); dt.Columns.Add("name", typeof(System.String)); dt.Rows.Add(new object[] { "1", "1#铸机" }); dt.Rows.Add(new object[] { "2", "2#铸机" }); dt.Rows.Add(new object[] { "3", "3#铸机" }); dt.Rows.Add(new object[] { "4", "4#铸机" }); dt.AcceptChanges(); return dt; } private DataTable GetConData() { DataTable dt = new DataTable(); dt.Columns.Add("id", typeof(System.String)); dt.Columns.Add("name", typeof(System.String)); dt.Rows.Add(new object[] { "1", "1#转炉" }); dt.Rows.Add(new object[] { "2", "2#转炉" }); dt.Rows.Add(new object[] { "3", "3#转炉" }); dt.AcceptChanges(); return dt; } private void queryBtn_Click(object sender, EventArgs e) { try { string startTime = FrmMain.dateTimePicker3.Value.ToString(); string endTime = FrmMain.dateTimePicker4.Value.ToString(); string strWhere = string.Format(" WHERE OCCR_DATE>=to_date('{0}','yyyy-MM-dd HH24:Mi:ss') AND OCCR_DATE<=to_date('{1}','yyyy-MM-dd HH24:Mi:ss') ", startTime, endTime); if (this.chkCcmNo.Checked) { // this.combCcmNo.SelectedItem // string ccmN0 = this.combCcmNo.SelectedValue.ToString(); strWhere += string.Format(" AND CCM_ID='{0}' ", this.ccmNumCobo.SelectedValue); } //以下是转炉查询 if (this.chkConNo.Checked) { //string conN0 = this.combConNo.SelectedValue.ToString(); strWhere += string.Format(" AND CON_ID='{0}'", this.combConNo.SelectedValue); }//转炉 //strWhere += " order by AIM_CAST_STR_TIME desc " ; strWhere += " order by CAST_NO desc,HEAT_SEQ desc "; string err = ""; this.steelSchTable.Clear(); routeHash.Clear(); // DataSet ds = (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("DataHandle", "Core.Sglg.DataHandle", "Core.Sglg.DataHandle.BSA_ISTLSCH", "SelectToDataSet", new object[] { strWhere }, out err); DataSet ds = (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("lgIntegrationQuery", "Core.LgMes.Server.lgIntegrationQuery.LgGeneralInfo", "GetAllJobPlan", new object[] { strWhere }, out err); if (err != "" && ds.Tables[0].Rows.Count <= 0) { //MessageBox.Show("炼钢数据查询错误："+err,"提示"); return; } //this.steelSchTable = ds.Tables[0]; if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { this.ultraGrid1.BeginUpdate(); this.cutSchTable.Clear(); int rowCount = ds.Tables[0].Rows.Count; DataRow row; string name = ""; for (int i = 0; i < rowCount; i++) { row = this.steelSchTable.NewRow(); foreach (DataColumn column in steelSchTable.Columns) { name = column.ColumnName; if (name != "PLN_ROUTE") row[name] = ds.Tables[0].Rows[i][name].ToString(); else { routeHash.Add(ds.Tables[0].Rows[i]["HEAT_ID"].ToString(), ds.Tables[0].Rows[i]["PLN_ROUTE"].ToString()); row[name] = analysPath(ds.Tables[0].Rows[i][name].ToString()); } } this.steelSchTable.Rows.Add(row); string status = row["HEATSTATUS"].ToString(); if (status.Length >= 4 && status.Substring(2, 2) == "02") { foreach (UltraGridCell cell in ultraGrid1.Rows[i].Cells) cell.Appearance.BackColor = Color.LightGreen;//在生产用颜色区分 } else if (status.Length >= 4 && status.Substring(2, 2) == "03" && status.Substring(0, 1).ToUpper() == "G") { foreach (UltraGridCell cell in ultraGrid1.Rows[i].Cells) cell.Appearance.BackColor = Color.LightCyan; //Color.MintCream;//连铸结束 } else { foreach (UltraGridCell cell in ultraGrid1.Rows[i].Cells) cell.Appearance.BackColor = Color.White;//计划状态 } } this.ultraGrid1.EndUpdate(); } } catch { } } private void combCcmNo_ValueMemberChanged(object sender, EventArgs e) { FrmMain.CCMN0 = ccmNumCobo.Text; } private void chkCcmNo_CheckedChanged(object sender, EventArgs e) { if (this.chkCcmNo.Checked) { this.ccmNumCobo.Enabled = true; this.ccmNumCobo.BackColor = Color.LightCyan; } else { this.ccmNumCobo.Enabled = false; this.ccmNumCobo.BackColor = Color.Gainsboro; } } private void chkConNo_CheckedChanged(object sender, EventArgs e) { if (this.chkConNo.Checked) { this.combConNo.Enabled = true; this.combConNo.BackColor = Color.LightCyan; } else { this.combConNo.Enabled = false; this.combConNo.BackColor = Color.Gainsboro; } } private void button3_Click(object sender, EventArgs e) { string yncheck = ""; yncheck = this.FrmMain.yncheck(); if (yncheck == "Y") { MessageBox.Show("请将本炉最后一块置成否后再增加支数"); return; } if (this.ultraGrid1.ActiveRow == null || this.ultraGrid2.Rows.Count == 0) { return; } if (this.textBox2.Text.Trim().Length == 0) this.textBox2.Text = "1"; int intIndex = 1; try { intIndex = Convert.ToInt32(this.textBox2.Text.Trim()); } catch { MessageBox.Show("起始序号请输入数字!"); return; } //检查一下数量 string strInputSmeltID = textBox1.Text; //通过计划查找其铸机号 int nCCMNo = FindCCMNoInPlan(strInputSmeltID); if (nCCMNo == -1) { MessageBox.Show("不存在指定的计划，或者数据查询错误，请重试!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Stop); return; } //对比现在选择的铸机 //int nSelectCCMNo = Convert.ToInt32(comboBox3.SelectedItem) ; int nSelectCCMNo = Convert.ToInt32(comboBox3.SelectedItem.ToString()); if (nCCMNo != nSelectCCMNo) { if (DialogResult.No == MessageBox.Show("您选择的铸机号和计划要去的连铸机号不同。确实要继续吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning)) return; } InsertAllData(GetCurrValue()); //提示用户修改班次信息 MessageBox.Show("该炉号所有坯子重量不能大于140,请修改手动生成记录的班次信息！", "插入记录成功！", MessageBoxButtons.OK, MessageBoxIcon.Warning); this.FrmMain.Query(); } private ArrayList GetCurrValue() { ArrayList ar = new ArrayList(); UltraGridRow ugr = this.ultraGrid1.ActiveRow; try { ar.Add(ugr.Cells["HEAT_ID"].Value.ToString()); ar.Add(this.comboBox3.Text); ar.Add("1"); ar.Add(Convert.ToInt32(this.textBox2.Text.Trim())); ar.Add(ugr.Cells["CAST_NO"].Value.ToString()); ar.Add(ugr.Cells["HEAT_SEQ"].Value.ToString()); ar.Add(ugr.Cells["HEAT_CNT"].Value.ToString()); ar.Add(tbxLength.Text); ar.Add(tbxWidth.Text); ar.Add(tbxThick.Text); ar.Add(tbxWeight.Text); ar.Add(""); ar.Add(Convert.ToInt32(this.textBox3.Text.Trim())); return ar; } catch { return null; } } private int FindCCMNoInPlan(string strSmeltID) { string err = ""; DataSet ds = (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("lgJobMgt", "Core.LgMes.Server.lgJobMgt.classCutJob", "SelectQueryCCMNo", new object[] { strSmeltID }, out err); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { return Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString()); } return -1; } private void InsertAllData(ArrayList ar) { try { CallingMessage par = new CallingMessage(); par.ServerName = "lgJobMgt"; par.AssemblyName = "Core.LgMes.Server.lgJobMgt"; par.ClassName = "Core.LgMes.Server.lgJobMgt.classCutJob"; par.MethodName = "InsetCutBilletPlan"; par.args = new object[] { ar, this.ultraGrid2.DataSource as DataTable }; string strOut = ""; object obj = ClientCommon._RemotingHelp.ExecuteMethod(par, out strOut); if (Convert.ToInt32(obj) < 1) { MessageBox.Show("数据提交失败！\n" + strOut); } } catch (Exception ex) { Console.WriteLine(ex.Message); } } private void ultraGrid2_AfterRowActivate(object sender, EventArgs e) { try { if (this.ultraGrid2.Rows.Count < 1) return; if (this.ultraGrid2.ActiveRow == null) return; UltraGridRow ultraRow = this.ultraGrid2.ActiveRow; string strCastNo = ultraRow.Cells[0].Value.ToString(); string strBlockNo = ultraRow.Cells[1].Value.ToString(); //选择行进行了改变 if (reportSelect != null) reportSelect(strCastNo, strBlockNo); } catch (Exception ex) { string msg = ex.Message; } } private void ultraGrid1_AfterRowActivate(object sender, EventArgs e) { try { if (this.ultraGrid1.Rows.Count < 1) return; if (this.ultraGrid1.ActiveRow == null) return; UltraGridRow ultraRow = this.ultraGrid1.ActiveRow; string castNo = ultraRow.Cells["HEAT_ID"].Value.ToString(); string strWhere = string.Format(" WHERE HEAT_ID='{0}' ORDER BY to_number( substr(SB_BT_ID,3,8) ) asc", castNo); string err = ""; DataSet ds = (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("lgIntegrationQuery", "Core.LgMes.Server.lgIntegrationQuery.LgGeneralInfo", "GetCutingData", new object[] { strWhere }, out err); if (err != "" && ds.Tables[0].Rows.Count <= 0) { //MessageBox.Show("切割数据查询错误："+err,"提示"); this.groupBox1.Text = "切割信息"; return; } //if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count == 0) //{ // //实际表中不存在记录则在历史记录表中查找 // string strTableName = "BSA_ICUTSCH"; // int nYear = DateTime.Now.Year - 2000; // nYear = nYear % 10; // strTableName = strTableName + nYear.ToString("00"); // ds.Dispose(); // ds = null; // ds = (DataSet)this.RemotingHelp.ExecuteMethod("DataHandle", "Core.Sglg.DataHandle", "Core.Sglg.DataHandle.BSA_ISTLSCH", "SelectCutDataEx", new object[] { strTableName, strWhere }, out err); //} if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { string strMsg = "切割信息 块数:"; strMsg = strMsg + ds.Tables[0].Rows.Count.ToString(); this.groupBox1.Text = strMsg; this.cutSchTable.Clear(); ultraGrid2.UpdateData(); int rowCount = ds.Tables[0].Rows.Count; DataRow row; for (int i = 0; i < rowCount; i++) { row = this.cutSchTable.NewRow(); foreach (DataColumn column in cutSchTable.Columns) { row[column.ColumnName] = ds.Tables[0].Rows[i][column.ColumnName].ToString(); } this.cutSchTable.Rows.Add(row); if (i > 0) { Color color1; Color color2; if (ds.Tables[0].Rows[i]["AIM_LTH"].ToString() != ds.Tables[0].Rows[i - 1]["AIM_LTH"].ToString()) { color1 = (Color)ultraGrid2.Rows[i - 1].Cells["AIM_LTH"].Appearance.BackColor; if (color1 == Color.LightGreen)//Color.FromArgb(205, 228, 225)) color2 = Color.MintCream;// Color.FromArgb(0, 0, 0, 0); else color2 = Color.LightGreen;//Color.FromArgb(205, 228, 225); } else color2 = (Color)ultraGrid2.Rows[i - 1].Cells["AIM_LTH"].Appearance.BackColor; foreach (UltraGridCell cell in ultraGrid2.Rows[i].Cells) cell.Appearance.BackColor = color2;//在生产用颜色区分 } } } this.textBox1.Text = castNo; this.comboBox3.Text = ultraRow.Cells["CCM_ID"].Value.ToString(); this.textBox3.Text = this.ultraGrid2.Rows.Count.ToString(); this.tbxLength.Text = this.ultraGrid2.Rows[1].Cells["AIM_LTH"].Value.ToString(); this.tbxWidth.Text = this.ultraGrid2.Rows[1].Cells["AIM_WTH"].Value.ToString(); this.tbxThick.Text = this.ultraGrid2.Rows[1].Cells["AIM_THK"].Value.ToString(); this.tbxWeight.Text = this.ultraGrid2.Rows[1].Cells["SL_BT_WGT"].Value.ToString(); } catch (Exception ex) { string msg = ex.Message; } } private void comboBox3_ValueMemberChanged(object sender, EventArgs e) { FrmMain.CCMN0 = comboBox3.Text; } private void comboBox3_TextChanged(object sender, EventArgs e) { //改变选定的铸机号 FrmMain.CCMN0 = comboBox3.Text; } private void FrmProductQueryQuery_Load(object sender, EventArgs e) { steelSchTable = new DataTable("steelSchTable"); cutSchTable = new DataTable("cutSchTable"); createTable(); this.ultraGrid1.DataSource = steelSchTable; this.ultraGrid2.DataSource = cutSchTable; setGrid1View(); InitComboBoxSource(); this.ccmNumCobo.SelectedIndex = 0; this.combConNo.SelectedIndex = 0; this.ccmNumCobo.Enabled = false; this.combConNo.Enabled = false; this.queryBtn_Click(null, new EventArgs()); } } }