XinYu_LG2MES/ClientSolution/Core.LgMes.Client.LgJobMgt/连铸台下切割查询/FrmProductQueryQuery.cs

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());
        }


  
      
    }
}