XinYu_LG2MES/ClientSolution/Core.LgMes.Client.LgJobMgt/连铸台下切割/FrmProductQuery.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Text;
using System.Windows.Forms;
using CoreFS.CA06;
using System.Collections;
using Infragistics.Win.UltraWinGrid;
namespace Core.LgMes.Client.LgJobMgt
{
    public partial class FrmProductQuery : 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 int intCcm = -1;

        public FrmProductQuery()
        {
            InitializeComponent();
        }
        private DataTable steelSchTable, cutSchTable;//调度、切割指示表
        private Hashtable routeHash = new Hashtable();//存放工艺路径
        public FrmCutBilletDetail FrmMain;
        //public Core.Mes.ClientFrameWork.RemotingHelp;
        private void FrmProductQuery_Load(object sender, EventArgs e)
        {
            dtpCutTime.Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") ;

            steelSchTable = new DataTable("steelSchTable");
            cutSchTable = new DataTable("cutSchTable");
            createTable();
            this.ultraGrid1.DataSource = steelSchTable;
            this.uGrdCutInfo.DataSource = cutSchTable;
            setGrid1View();

            InitComboBoxSource();
            this.combConNo.SelectedIndex = 0;

            //分铸机
            if (intCcm == -1)
            {
                this.ccmNumCobo.SelectedIndex = 0;
            }
            else
            {
                this.ccmNumCobo.SelectedIndex = intCcm;
                chkCcmNo.Checked = true;
                chkCcmNo.Enabled = false;
                comboBox3.SelectedIndex = intCcm;
                comboBox3.Enabled = false;
            }

            this.ccmNumCobo.Enabled = false;
            this.combConNo.Enabled = false;
            this.queryBtn_Click(null, new EventArgs());
        }

        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";

            this.cboFlowNo.DataSource = GetFlowData();
            this.cboFlowNo.DisplayMember = "name";
            this.cboFlowNo.ValueMember = "id";

        }
        private void createTable()//----创建对应表
        {
            try
            {
                //炼钢指示表
                DataColumn myDataColumn = new DataColumn();
                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "HEATNO";
                myDataColumn.Caption = "炉号";
                steelSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "AIM_GRADE_CODE";
                myDataColumn.Caption = "目标钢号";
                steelSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "CAST_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_NUM";
                myDataColumn.Caption = "炉数";
                steelSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "CAST_SEQ";
                myDataColumn.Caption = "顺序";
                steelSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "PLAN_ROUTE";
                myDataColumn.Caption = "工艺路径";
                steelSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "BILLETQTY";
                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 = "PLAN_IRON_QTY";
                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 = "PLAN_HMP_STR_TIME";
                myDataColumn.Caption = "计划脱硫开始时刻";
                steelSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "PLAN_HMP_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 = "PLAN_BOF_STR_TIME";
                myDataColumn.Caption = "计划吹炼开始时刻";
                steelSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "PLAN_BOF_END_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_QTY";
                myDataColumn.Caption = "目标出钢量";
                steelSchTable.Columns.Add(myDataColumn);

                //myDataColumn = new DataColumn();
                //myDataColumn.DataType = System.Type.GetType("System.String");
                //myDataColumn.ColumnName = "AIM_STEEL_QTY";
                //myDataColumn.Caption = "出钢目标温度";
                //steelSchTable.Columns.Add(myDataColumn);


                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "PLAN_AR_STR_TIME";
                myDataColumn.Caption = "计划AR开始时刻";
                steelSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "PLAN_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 = "PLAN_LF_STR_TIME";
                myDataColumn.Caption = "计划LF开始时刻";
                steelSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "PLAN_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 = "PLAN_RH_STR_TIME";
                myDataColumn.Caption = "计划RH开始时刻";
                steelSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "PLAN_RH_ENT_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 = "PLAN_CCM_STR_TIME";
                myDataColumn.Caption = "计划浇注开始时刻";
                steelSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "PLAN_CCM_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 = "HEAT_STATE";
                myDataColumn.Caption = "生产状态";
                steelSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "v_heat_ID";
                myDataColumn.Caption = "虚拟炉号";
                steelSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "STEELCODE";
                myDataColumn.Caption = "牌号编码";
                steelSchTable.Columns.Add(myDataColumn);


                //切割指示表
                myDataColumn = new DataColumn();

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "heatno";
                myDataColumn.Caption = "炉号";
                cutSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "BILLET_XN";
                myDataColumn.Caption = "计划坯号";
                cutSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "SLABLENGTH";
                myDataColumn.Caption = "目标长度";
                cutSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "DIRECTIONTYPE";
                myDataColumn.Caption = "计划去向";
                cutSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "CUTTASKCODE";
                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 = "SEQUENCENO";
                myDataColumn.Caption = "炉内顺序号";
                cutSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "SEQUENCEINCAST";
                myDataColumn.Caption = "浇次内炉序";
                cutSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "CUTSTARTTIME";
                myDataColumn.Caption = "计划切割时间";
                cutSchTable.Columns.Add(myDataColumn);


                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "SLABHEIGHT";
                myDataColumn.Caption = "目标厚度";
                cutSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "SLABWIDTH";
                myDataColumn.Caption = "目标宽度";
                cutSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "THEROYWEIGHT";
                myDataColumn.Caption = "坯料重量";
                cutSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "BILLETQTY";
                myDataColumn.Caption = "方坯数";
                cutSchTable.Columns.Add(myDataColumn); 

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "BILLETWEIGHT";
                myDataColumn.Caption = "坯料单重";
                cutSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "FURNACENO";
                myDataColumn.Caption = "虚拟炉号";
                cutSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "PRODORDERNO";
                myDataColumn.Caption = "生产订单号";
                cutSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "ORDERNO";
                myDataColumn.Caption = "订单行号";
                cutSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "BATCHPLANNO";
                myDataColumn.Caption = "批量计划号";
                cutSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "SEQUENCEINBATCH";
                myDataColumn.Caption = "批量计划内序号";
                cutSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "CUSTOMER_KEY";
                myDataColumn.Caption = "客户参数号";
                cutSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "SURPLUSFLAG";
                myDataColumn.Caption = "是否余材";
                cutSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "STANDARDSCODE";
                myDataColumn.Caption = "内控标准";
                cutSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "STANDARDREMAK";
                myDataColumn.Caption = "标准描述";
                cutSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "PDTSTYLE";
                myDataColumn.Caption = "产品类型";
                cutSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "SPECDESCRIPTION";
                myDataColumn.Caption = "成品规格描述";
                cutSchTable.Columns.Add(myDataColumn);

                myDataColumn = new DataColumn();
                myDataColumn.DataType = System.Type.GetType("System.String");
                myDataColumn.ColumnName = "FOREIGN_TRADE";
                myDataColumn.Caption = "是否出口";
                cutSchTable.Columns.Add(myDataColumn);

            }
            catch (Exception ex)
            {
                string msg = ex.Message;
            }
        }
        private void setGrid1View()//----设置grid外观
        {
            try
            {
                ultraGrid1.DisplayLayout.Appearance.BackColor = Color.FromArgb(245, 250, 254);
                ultraGrid1.DisplayLayout.Override.HeaderAppearance.BackColor = Color.FromArgb(158, 191, 231);// 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["HEAT_STATE"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["v_heat_ID"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["PLAN_RH_STR_TIME"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["PLAN_RH_ENT_TIME"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["PLAN_HMP_STR_TIME"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["PLAN_HMP_END_TIME"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["PLAN_IRON_QTY"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["HEAT_NUM"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["STEELCODE"].Hidden = true;

                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["HEATNO"].Width = 80;
                ultraGrid1.DisplayLayout.Bands[0].Columns["AIM_GRADE_CODE"].Width = 60;
                ultraGrid1.DisplayLayout.Bands[0].Columns["CAST_ID"].Width = 50;
                ultraGrid1.DisplayLayout.Bands[0].Columns["CAST_NO"].Width = 70;
                ultraGrid1.DisplayLayout.Bands[0].Columns["HEAT_NUM"].Width = 50;
                ultraGrid1.DisplayLayout.Bands[0].Columns["CAST_SEQ"].Width = 50;
                //ultraGrid1.DisplayLayout.Bands[0].Columns["AIM_S"].Width = 50;
                ultraGrid1.DisplayLayout.Bands[0].Columns["PLAN_ROUTE"].Width = 230;
                ultraGrid1.DisplayLayout.Bands[0].Columns["BILLETQTY"].Width = 38;
                ultraGrid1.DisplayLayout.Bands[0].Columns[8].Width = 60;
                ultraGrid1.DisplayLayout.Bands[0].Columns[10].Width = 130;
                ultraGrid1.DisplayLayout.Bands[0].Columns[11].Width = 130;
                ultraGrid1.DisplayLayout.Bands[0].Columns[12].Width = 130;
                ultraGrid1.DisplayLayout.Bands[0].Columns[13].Width = 60;
                ultraGrid1.DisplayLayout.Bands[0].Columns[14].Width = 130;
                ultraGrid1.DisplayLayout.Bands[0].Columns[15].Width = 130;
                ultraGrid1.DisplayLayout.Bands[0].Columns[16].Width = 130;
                ultraGrid1.DisplayLayout.Bands[0].Columns[17].Width = 130;
                // 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;

                uGrdCutInfo.DisplayLayout.Appearance.BackColor = Color.FromArgb(245, 250, 254);
                uGrdCutInfo.DisplayLayout.Override.HeaderAppearance.BackColor = Color.FromArgb(158, 191, 231);// System.Drawing.Color.FromArgb(205, 228, 225);
                uGrdCutInfo.DisplayLayout.Override.RowSelectorAppearance.BackColor = System.Drawing.Color.FromArgb(205, 228, 225);
                uGrdCutInfo.DisplayLayout.Override.RowAlternateAppearance.BackColor = Color.GhostWhite;

                uGrdCutInfo.DisplayLayout.Bands[0].Columns["FURNACENO"].Hidden = true;
               // ultraGrid2.DisplayLayout.Bands[0].Columns["STANDARDSCODE"].Hidden = true;

                uGrdCutInfo.DisplayLayout.Bands[0].Columns["HeatNo"].Width = 60;
                uGrdCutInfo.DisplayLayout.Bands[0].Columns["STANDARDREMAK"].Width = 90;
                uGrdCutInfo.DisplayLayout.Bands[0].Columns["BILLET_XN"].Width = 80;
                uGrdCutInfo.DisplayLayout.Bands[0].Columns["SLABLENGTH"].Width = 50;
                uGrdCutInfo.DisplayLayout.Bands[0].Columns["CUTTASKCODE"].Width = 50;
                uGrdCutInfo.DisplayLayout.Bands[0].Columns["CAST_NO"].Width = 50;
                uGrdCutInfo.DisplayLayout.Bands[0].Columns["SEQUENCEINCAST"].Width = 50;
                uGrdCutInfo.DisplayLayout.Bands[0].Columns["DIRECTIONTYPE"].Width = 70;
                uGrdCutInfo.DisplayLayout.Bands[0].Columns["BILLETQTY"].Width = 60;
                uGrdCutInfo.DisplayLayout.Bands[0].Columns["BILLETWEIGHT"].Width = 60;
                uGrdCutInfo.DisplayLayout.Bands[0].Columns[7].Width = 60;
                uGrdCutInfo.DisplayLayout.Bands[0].Columns[8].Width = 120;
                uGrdCutInfo.DisplayLayout.Bands[0].Columns[9].Width = 70;
                uGrdCutInfo.DisplayLayout.Bands[0].Columns[10].Width = 70;
                uGrdCutInfo.DisplayLayout.Bands[0].Columns[11].Width = 70;
                uGrdCutInfo.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[] { "0", "0#铸机" });
            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 DataTable GetFlowData()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("id", typeof(System.String));
            dt.Columns.Add("name", typeof(System.String));
            if (intCcm == 2 || intCcm == 3)
            {
                dt.Rows.Add(new object[] { "1", "0流" });
                dt.Rows.Add(new object[] { "2", "1流" });
                dt.Rows.Add(new object[] { "3", "2流" });
                dt.Rows.Add(new object[] { "4", "3流" });
                dt.Rows.Add(new object[] { "5", "4流" });
            }
            else
            {
                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.Rows.Add(new object[] { "5", "5流" });
            }

            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 PLAN_MAKING_TIME>=to_date('{0}','yyyy-MM-dd HH24:Mi:ss') AND PLAN_MAKING_TIME<=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 CAST_ID='{0}' ", this.ccmNumCobo.SelectedValue);
                }
                //以下是转炉查询
                if (this.chkConNo.Checked)
                {
                    //string conN0 = this.combConNo.SelectedValue.ToString();
                    strWhere += string.Format(" AND substr(heatno,3,1)='{0}'", this.combConNo.SelectedValue);
                }//转炉

                //strWhere += " order by AIM_CAST_STR_TIME desc "	;	
                strWhere += "  and heatno is not null ";//order by CAST_NO desc,to_number(CAST_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 = null;// (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("lgIntegrationQuery", "Core.LgMes.Server.lgIntegrationQuery.LgGeneralInfo", "GetAllJobPlan_Cut", 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 != "PLAN_ROUTE")
                                row[name] = ds.Tables[0].Rows[i][name].ToString();
                            else
                            {
                                routeHash.Add(ds.Tables[0].Rows[i]["HEATNO"].ToString(), ds.Tables[0].Rows[i]["PLAN_ROUTE"].ToString());
                                row[name] = analysPath(ds.Tables[0].Rows[i][name].ToString());
                            }
                        }
                        this.steelSchTable.Rows.Add(row);
                        string status = row["HEAT_STATE"].ToString();
                        if (status == "03")
                        {
                            foreach (UltraGridCell cell in ultraGrid1.Rows[i].Cells)
                                cell.Appearance.BackColor = Color.White;//计划状态
                        }
                        else if (status == "09")
                        {
                            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.LightGreen;//在生产用颜色区分
                        }
                    }
                    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.White;
            }
            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.White;
            }
            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 (!GetHeatState(textBox1.Text))
            {
                MessageBox.Show("炉号【" + textBox1.Text + "】没有上连铸机生产，不能生成坯料！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                return;
            }
            if (yncheck == "Y")
            {
                MessageBox.Show("请将本炉最后一块置成否后再增加支数");
                return;
            }

            if (this.ultraGrid1.ActiveRow == null || this.uGrdCutInfo.Rows.Count == 0)
            {
                return;
            }

            if (this.uGrdCutInfo.ActiveRow == null)
            {
                MessageBox.Show("没有选择切割计划，请选择!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                return;
            }

            if (this.cboFlowNo.Text.Trim().Length == 0)
            {
                MessageBox.Show("请输入铸流号!");
                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;
            UltraGridRow ugr2 = this.uGrdCutInfo.ActiveRow;
            try
            {
                ar.Add(ugr.Cells["HEATNO"].Value.ToString());
                ar.Add(this.comboBox3.Text);
                ar.Add(this.cboFlowNo.SelectedValue);
                ar.Add(Convert.ToInt32(this.textBox2.Text.Trim()));
                ar.Add(ugr.Cells["CAST_NO"].Value.ToString());
                ar.Add(ugr.Cells["CAST_SEQ"].Value.ToString());
                ar.Add(ugr.Cells["HEAT_NUM"].Value.ToString());

                ar.Add(tbxLength.Text);
                ar.Add(tbxWidth.Text);
                ar.Add(tbxThick.Text);
                ar.Add(tbxWeight.Text);
                ar.Add(Convert.ToDateTime(dtpCutTime.Value).ToString("yyyy-MM-dd HH:mm:ss"));
                ar.Add(Convert.ToInt32(this.textBox3.Text.Trim()));
                ar.Add(FrmMain.UserInfo.GetUserName());    //add on 2009-04-23 记录操作人员
                ar.Add(ugr2.Cells["FURNACENO"].Value.ToString());
                ar.Add(ugr2.Cells["BILLET_XN"].Value.ToString());
                ar.Add(txtOrderNO.Text);
                ar.Add(txtProdorderNO.Text);
                ar.Add((txtSurplusFlag.Text == "是" ? "1" : "0"));
                ar.Add(ugr.Cells["SteelCode"].Value.ToString());
                ar.Add((ugr2.Cells["DIRECTIONTYPE"].Value.ToString())=="弹扁"?"0":(ugr2.Cells["DIRECTIONTYPE"].Value.ToString())=="棒材"?"1":"2");
                ar.Add(ugr2.Cells["STANDARDSCODE"].Value.ToString());
                ar.Add(ugr2.Cells["STANDARDREMAK"].Value.ToString());
                ar.Add(ugr2.Cells["CUSTOMER_KEY"].Value.ToString());
                return ar;
            }
            catch
            {
                return null;
            }
        }

        private int FindCCMNoInPlan(string strSmeltID)
        {
            string err = "";
            DataSet ds = null;// (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
            {
                //hengxing
                //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 = null;// 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.uGrdCutInfo.Rows.Count < 1)
                    return;
                if (this.uGrdCutInfo.ActiveRow == null)
                    return;
                UltraGridRow ultraRow = this.uGrdCutInfo.ActiveRow;
                string strCastNo = ultraRow.Cells[0].Value.ToString();
                string strBlockNo = ultraRow.Cells[1].Value.ToString();

                FrmMain.strV_BilletID = ultraRow.Cells["BILLET_XN"].Value.ToString();
                FrmMain.strV_Heat_ID = ultraRow.Cells["FURNACENO"].Value.ToString();
                FrmMain.strOrderNO = ultraRow.Cells["ORDERNO"].Value.ToString();
                FrmMain.strProdOrderNO = ultraRow.Cells["PRODORDERNO"].Value.ToString();
                FrmMain.strSurplusFlag = (ultraRow.Cells["SURPLUSFLAG"].Value.ToString() == "是" ? "1" : "0");
                FrmMain.strProductline = (ultraRow.Cells["DIRECTIONTYPE"].Value.ToString()) == "弹扁" ? "0" : (ultraRow.Cells["DIRECTIONTYPE"].Value.ToString()) == "棒材" ? "1" : "2";
                FrmMain.strStandardsCode = ultraRow.Cells["STANDARDSCODE"].Value.ToString();
                FrmMain.strStandardRemak = ultraRow.Cells["STANDARDREMAK"].Value.ToString();
                FrmMain.strCustomer_Key = ultraRow.Cells["CUSTOMER_KEY"].Value.ToString();
                this.textBox1.Text = ultraRow.Cells["HeatNo"].Value.ToString();
                this.comboBox3.Text = ultraRow.Cells["CAST_No"].Value.ToString();
                this.textBox3.Text = ultraRow.Cells["BILLETQTY"].Value.ToString();
                this.tbxLength.Text = ultraRow.Cells["SLABLENGTH"].Value.ToString();
                this.tbxWidth.Text = ultraRow.Cells["SLABWIDTH"].Value.ToString();
                this.tbxThick.Text = ultraRow.Cells["SLABHEIGHT"].Value.ToString();
                this.txtProdorderNO.Text = ultraRow.Cells["ProdorderNo"].Value.ToString();
                txtOrderNO.Text = ultraRow.Cells["OrderNo"].Value.ToString();
                txtSurplusFlag.Text = ultraRow.Cells["SurplusFlag"].Value.ToString();
                float a = Convert.ToSingle(this.tbxLength.Text.Trim());
                float b = Convert.ToSingle(this.tbxWidth.Text.Trim());
                float c = Convert.ToSingle(this.tbxThick.Text.Trim());

                if (ultraRow.Cells["BILLETWEIGHT"].Value != null && ultraRow.Cells["BILLETWEIGHT"].Value.ToString().Length > 0)
                    tbxWeight.Text = ultraRow.Cells["BILLETWEIGHT"].Value.ToString();
                else
                {
                    if (ultraRow.Cells["BILLETQTY"].Value != null && !string.IsNullOrEmpty(ultraRow.Cells["BILLETQTY"].Value.ToString()) && Convert.ToDouble(ultraRow.Cells["BILLETQTY"].Value) > 0)
                        this.tbxWeight.Text = Convert.ToString(Convert.ToDouble(ultraRow.Cells["THEROYWEIGHT"].Value) / Convert.ToDouble(ultraRow.Cells["BILLETQTY"].Value));
                    else
                        tbxWeight.Text = Convert.ToString(Convert.ToDouble(ultraRow.Cells["THEROYWEIGHT"].Value) / Math.Round(a * b * c * 7.82 / 1000000000, 3));
                }

                //选择行进行了改变
                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["heatNo"].Value.ToString();
                string strV_HeatID = ultraRow.Cells["v_heat_ID"].Value.ToString();
                string strWhere = string.Format(" WHERE FURNACENO='{0}' ", strV_HeatID); // ORDER BY  decode(substr(BILLET_XN,1,1),'A','',to_number(substr(BILLET_XN, 3, 8))) asc,to_number(SEQUENCENO) asc
                FrmMain.strSteelCode = ultraRow.Cells["SteelCode"].Value.ToString();
                string err = "";
                DataSet ds = null;// (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 strMsg = "切割信息 块数:";
                    strMsg = strMsg + ds.Tables[0].Rows.Count.ToString();

                    this.groupBox1.Text = strMsg;
                    this.cutSchTable.Clear();
                    uGrdCutInfo.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)
                        {
                            if (column.ColumnName.ToUpper() == "DIRECTIONTYPE") //坯料去向
                                row[column.ColumnName] = (ds.Tables[0].Rows[i][column.ColumnName].ToString() == "0" ? "弹扁" : (ds.Tables[0].Rows[i][column.ColumnName].ToString() == "1" ? "棒材" : "高线"));
                            else if (column.ColumnName.ToUpper() == "SURPLUSFLAG") //是否余材
                                row[column.ColumnName] = (ds.Tables[0].Rows[i][column.ColumnName].ToString() == "1" ? "是" : "否");
                            else
                                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]["SLABLENGTH"].ToString() != ds.Tables[0].Rows[i - 1]["SLABLENGTH"].ToString())
                            {
                                color1 = (Color)uGrdCutInfo.Rows[i - 1].Cells["SLABLENGTH"].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)uGrdCutInfo.Rows[i - 1].Cells["SLABLENGTH"].Appearance.BackColor;

                            foreach (UltraGridCell cell in uGrdCutInfo.Rows[i].Cells)
                                cell.Appearance.BackColor = color2;//在生产用颜色区分
                        }
                    }
                }

                this.textBox1.Text = castNo;
                this.comboBox3.Text = ultraRow.Cells["CAST_ID"].Value.ToString();
                this.textBox3.Text = this.uGrdCutInfo.Rows.Count.ToString();
                this.tbxLength.Text = this.uGrdCutInfo.Rows[0].Cells["SLABLENGTH"].Value.ToString();
                this.tbxWidth.Text = this.uGrdCutInfo.Rows[0].Cells["SLABWIDTH"].Value.ToString();
                this.tbxThick.Text = this.uGrdCutInfo.Rows[0].Cells["SLABHEIGHT"].Value.ToString();

                float a = Convert.ToSingle(this.tbxLength.Text.Trim());
                float b = Convert.ToSingle(this.tbxWidth.Text.Trim());
                float c = Convert.ToSingle(this.tbxThick.Text.Trim());

               
                if (this.uGrdCutInfo.Rows[0].Cells["BILLETQTY"].Value != null && Convert.ToDouble(this.uGrdCutInfo.Rows[0].Cells["BILLETQTY"].Value) > 0)
                    this.tbxWeight.Text = Convert.ToString(Convert.ToDouble(this.uGrdCutInfo.Rows[0].Cells["THEROYWEIGHT"].Value) / Convert.ToDouble(this.uGrdCutInfo.Rows[0].Cells["BILLETQTY"].Value));
                else
                    tbxWeight.Text = Convert.ToString(Convert.ToDouble(this.uGrdCutInfo.Rows[0].Cells["THEROYWEIGHT"].Value) / Math.Round(a * b * c * 7.82 / 1000000000, 3));


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

        /// <summary>
        /// 获取指定炉号的生产状态
        /// </summary>
        /// <param name="strHeatNo"></param>
        /// <returns></returns>
        private bool GetHeatState(string strHeatNo)
        {
            string strErr = "";
            string strState = "";
            bool blState = false;
            DataSet ds = null;// (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("lgJobMgt",
                                //                                           "Core.LgMes.Server.lgJobMgt.classCutJob",
                                  //                                         "GetHeatState", new object[] { strHeatNo }, out strErr);
            if (strErr == "")
            {
                if (ds != null && ds.Tables[0].Rows.Count > 0)
                    strState = ds.Tables[0].Rows[0]["Heat_state"].ToString();
                if (strState == "08" || strState == "09")
                    blState = true;
            }

            return blState;

        }

        private void tbxLength_TextChanged(object sender, EventArgs e)
        {
            try
            {
                float a = Convert.ToSingle(this.tbxLength.Text.Trim());
                float b = Convert.ToSingle(this.tbxWidth.Text.Trim());
                float c = Convert.ToSingle(this.tbxThick.Text.Trim());

                this.tbxWeight.Text = Convert.ToString(Math.Round(a * b * c * 7.82 / 1000000000, 3));
            }
            catch { }
        }

        private void bntSend_Click(object sender, EventArgs e)
        {
            UltraGridRow ultraRow = this.ultraGrid1.ActiveRow;
            if (ultraRow == null)
                MessageBox.Show("请选择做金相试样的炉号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
            else
            {
                frmSendJXY frmJxy = new frmSendJXY();
                frmJxy.strHeatNO = ultraRow.Cells["HeatNo"].Value.ToString();
                frmJxy.strSteelCode = ultraRow.Cells["SteelCode"].Value.ToString();
                frmJxy.strSteel = ultraRow.Cells["AIM_GRADE_CODE"].Value.ToString();
                frmJxy.strStationCode = ultraRow.Cells["CAST_ID"].Value.ToString();
                frmJxy.strOptName = FrmMain.UserInfo.GetUserName();
                frmJxy.Location = CStaticMethod.GetChildWindowLocation(frmJxy.Size);
                frmJxy.ShowDialog();
            }
        }

    }
}