XinYu_LG2MES/ClientSolution/Core.LgMes.Client.LgJobMgt/炼钢公共类/frmSchedulingQuery.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Threading;
using Infragistics.Win.UltraWinGrid;
using System.Collections;
using CoreFS.CA06;

namespace Core.LgMes.Client.LgJobMgt
{
    public partial class frmSchedulingQuery : Core.Mes.Client.Common.frmStyleBase
    {
        string strHeatNo = "";  //炉号
        public frmSchedulingQuery()
        {
            InitializeComponent();
        }

        private void frmSchedulingQuery_Load(object sender, EventArgs e)
        {
            string[] strKey = this.Key.Split('@');
            if (strKey.Length > 1)
            {
                if (strKey[1] == "DD") ultraToolbarsManager1.Tools["ModifySpec"].SharedProps.Visible = true;
            }
            cboCcmID.Enabled = false;
            ultracboState.Enabled = false;
            txtHeatNo.Enabled = false;
            uldtBeginTime.Value = System.DateTime.Today.AddDays(-1).ToString("yyyy-MM-dd") + " 00:00";
            uldtEndTime.Value = System.DateTime.Today.AddDays(1).ToString("yyyy-MM-dd") + " 23:59";
            chkCcmID.Checked = false;
            chkState.Checked = false;
            chkHeatNo.Checked = false;
            //setGrid1View();
            cboCcmID.SelectedIndex = 0;
            StartGetDataThread();
            label3.BackColor = Color.White;
            label4.BackColor = Color.LightGreen;
            label5.BackColor = Color.FromArgb(192, 255, 255);
            chkAutoRefresh.Checked = true;
            ultracboState.SelectedIndex = 0;

        }

        private void chkCcmID_CheckedChanged(object sender, EventArgs e)
        {
            if (chkCcmID.Checked)
                cboCcmID.Enabled = true;
            else
                cboCcmID.Enabled = false;
        }

        /// <summary>
        /// 解析作业路径
        /// </summary>
        /// <param name="craftPath">路径</param>
        /// <returns>返回解析后文字路径</returns>       
        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;
            }
        }

        /// <summary>
        /// 获取浇次计划信息
        /// </summary>
        private void GetCastPlan()
        {
            int i = 0;
            string strBeginTime = uldtBeginTime.Value.ToString();
            string strEndTime = uldtEndTime.Value.ToString();

            string strWhere = string.Format(" and str_time>=to_date('{0}','yyyy-MM-dd HH24:Mi:ss') AND str_time<=to_date('{1}','yyyy-MM-dd HH24:Mi:ss') ", strBeginTime, strEndTime);

            //状态
            if (chkState.Checked)
            {
                if (ultracboState.Value.ToString() == "03")
                    strWhere += " and status<='03'";
                else if (ultracboState.Value.ToString() == "04" || ultracboState.Value.ToString() == "09")
                    strWhere += " and status='" + ultracboState.Value.ToString() + "'";
               
            }

            //铸机号
            if (chkCcmID.Checked)
            {
                //string ccmID = Convert.ToString(cboCcmID.SelectedIndex + 1);
                string ccmID = Convert.ToString(cboCcmID.SelectedIndex);
                strWhere += string.Format(" AND CAST_ID='{0}' ", ccmID); ;
            }

            //strWhere += " order by MAKETIME ";

            string err = "";
            DataSet ds = null;// (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("lgIntegrationQuery", "Core.LgMes.Server.lgIntegrationQuery.LgGeneralInfo", "GetCastPlan", new object[] { strWhere }, out err);
            ultraDataSource3.Rows.Clear();
            if (ds.Tables.Count > 0)
            {
                foreach (DataRow dr in ds.Tables[0].Rows)
                {
                    ultraDataSource3.Rows.Add(new object[] {dr["V_CAST_NO"].ToString(),
                                                            dr["CAST_NO"].ToString(),
                                                            dr["CAST_ID"].ToString(),
                                                            dr["HEAT_NUM"].ToString(),
                                                            dr["STATUS"].ToString(),
                                                            dr["WEIGHT"].ToString(),
                                                            dr["STR_TIME"].ToString(),
                                                            dr["END_TIME"].ToString(),
                                                            dr["MAKETIME"].ToString(),
                                                            dr["BATCHPLANNO"].ToString(),
                                                            dr["MEMO"].ToString(),
                                                            dr["REMARK"].ToString()
                                                       });
                    //执行状态
                    string status = dr["STATUS"].ToString();

                    if (status == "生产")
                    {
                        foreach (UltraGridCell cell in ultraGrid4.Rows[i].Cells)
                            cell.Appearance.BackColor = Color.LightGreen;//在生产用颜色区分
                    }
                    else if ( status == "完成")
                    {
                        foreach (UltraGridCell cell in ultraGrid4.Rows[i].Cells)
                            cell.Appearance.BackColor = Color.LightCyan;//连铸结束
                    }
                    else if ( status == "计划")
                    {
                        foreach (UltraGridCell cell in ultraGrid4.Rows[i].Cells)
                            cell.Appearance.BackColor = Color.White;//计划状态
                    }
                    else if (status == "取消")
                    {
                        foreach (UltraGridCell cell in ultraGrid4.Rows[i].Cells)
                            cell.Appearance.BackColor = Color.LightGray;//取消状态
                    }

                    i = i + 1;
                }
            }
        }

        /// <summary>
        /// 获取作业计划信息
        /// </summary>
        private void GetJobData(string strCast_No)
        {

            int i = 0;
            string strBeginTime = uldtBeginTime.Value.ToString();
            string strEndTime = uldtEndTime.Value.ToString();
            string strWhere = "";
            if (strCast_No.Trim().Length > 0)
                strWhere = "Where CAST_NO='" + strCast_No + "'";
            else
            {
                strWhere = string.Format(" WHERE  plan_bof_str_time>=to_date('{0}','yyyy-MM-dd HH24:Mi:ss') AND plan_bof_str_time<=to_date('{1}','yyyy-MM-dd HH24:Mi:ss') ", strBeginTime, strEndTime);
                
                //状态
                if (chkState.Checked)
                {
                    if (ultracboState.Value.ToString() == "04")
                        strWhere += " and heat_state >'03' and heat_state <'09' ";
                    else if (ultracboState.Value.ToString() == "03" || ultracboState.Value.ToString() == "09")
                        strWhere += " and heat_state ='" + ultracboState.Value.ToString() + "'";

                }

                //铸机
                if (chkCcmID.Checked)
                {
                    string ccmID = Convert.ToString(cboCcmID.SelectedIndex);
                    strWhere += string.Format(" AND CAST_ID='{0}' ", ccmID);
                }

                // 炉号
                if (chkHeatNo.Checked)
                {
                    string strHeatNo = txtHeatNo.Text.Trim();
                    strWhere += string.Format(" and HeatNo like '%{0}'", strHeatNo);
                }
            }

            //strWhere += " order by CAST_ID, CAST_NO, length(CAST_SEQ), CAST_SEQ ";

            string err = "";
            DataSet ds = null;// (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("lgIntegrationQuery", "Core.LgMes.Server.lgIntegrationQuery.LgGeneralInfo", "GetAllJobPlan", new object[] { strWhere }, out err);
            ultraDataSource1.Rows.Clear();
            if (ds.Tables.Count > 0)
            {
                foreach (DataRow dr in ds.Tables[0].Rows)
                {
                    ultraDataSource1.Rows.Add(new object[] {dr["V_HEAT_ID"].ToString(),
                                                            dr["CAST_SEQ"].ToString(),
                                                            dr["HEAT_NUM"].ToString(),
                                                            CStaticMethod.analysPlan_Lines(dr["PLAN_LINES"].ToString()),
                                                            dr["PLAN_IRON_QTY"].ToString(),
                                                            dr["AIM_STEEL_QTY"].ToString(),
                                                            dr["AIM_GRADE_CODE"].ToString(),
                                                            dr["PLAN_HMP_STR_TIME"].ToString(),
                                                            dr["PLAN_HMP_END_TIME"].ToString(),
                                                            dr["PLAN_VDM_STR_TIME"].ToString(),
                                                            dr["PLAN_VDM_END_TIME"].ToString(),
                                                            dr["PLAN_BOF_STR_TIME"].ToString(),
                                                            dr["PLAN_BOF_END_TIME"].ToString(),
                                                            dr["PLAN_AR_STR_TIME"].ToString(),
                                                            dr["PLAN_AR_END_TIME"].ToString(),
                                                            dr["PLAN_LF_STR_TIME"].ToString(),
                                                            dr["PLAN_LF_END_TIME"].ToString(),
                                                            dr["PLAN_RH_STR_TIME"].ToString(),
                                                            dr["PLAN_RH_ENT_TIME"].ToString(),
                                                            dr["PLAN_CCM_STR_TIME"].ToString(),
                                                            dr["PLAN_CCM_END_TIME"].ToString(),
                                                            dr["BILLETQTY"].ToString(),
                                                            dr["STD_CODE"].ToString(),
                                                            (dr["HOT_ROLL_FLAG"].ToString()=="0"?"下线":"热送"),
                                                            dr["CAST_ID"].ToString(),
                                                            dr["PLAN_MAKING_TIME"].ToString(),
                                                            dr["PLAN_MAKER"].ToString(),
                                                            (dr["SURPLUS_FLAG"].ToString()=="0"?"否":"是"),
                                                            dr["HEATNO"].ToString(),
                                                            analysPath(dr["PLAN_ROUTE"].ToString()),
                                                            analysPath(dr["FACT_ROUTE"].ToString()),
                                                            dr["CAST_NO"].ToString(),
                                                            dr["ORD_GON_ID"].ToString(),
                                                            dr["CUSTOMER_KEY"].ToString(),
                                                            dr["BATCHPLANNO"].ToString(),
                                                            dr["LEN"].ToString(),
                                                            dr["WIDTH"].ToString(),
                                                            dr["THICK"].ToString(),
                                                            dr["HEAT_STATE"].ToString(),
                                                            dr["STD_NAME"].ToString(),
                                                            dr["CHANGEFLAG"].ToString(),
                                                            dr["VANFLAG"].ToString(),
                                                            dr["HEAT_SEQ"].ToString(),
                                                            dr["VANHEATNO"].ToString(),
                                                            dr["SEND_CCM_FLG"].ToString() ,
                                                            dr["REMARK"].ToString()
                                                       });
                    //执行状态
                    string status = dr["HEAT_STATE"].ToString();

                    if (status.Length >= 2 && string.Compare(status, "03") == 1 && string.Compare(status, "09") == -1)
                    {
                        foreach (UltraGridCell cell in ultraGrid1.Rows[i].Cells)
                            cell.Appearance.BackColor = Color.LightGreen;//在生产用颜色区分
                    }
                    else if (status.Length >= 2 && status == "09")
                    {
                        foreach (UltraGridCell cell in ultraGrid1.Rows[i].Cells)
                            cell.Appearance.BackColor = Color.LightCyan;//连铸结束
                    }
                    else if (status.Length >= 2 && status == "03")
                    {
                        foreach (UltraGridCell cell in ultraGrid1.Rows[i].Cells)
                            cell.Appearance.BackColor = Color.White;//计划状态
                    }

                    i = i + 1;
                }
            }

        }

        /// <summary>
        /// 获取切割计划信息
        /// </summary>
        /// <param name="strCastNo">浇次号</param>
        /// <param name="strSequenceinCast">浇次顺序号</param>
        /// <param name="strFurnaceNo">熔炼号</param>
        private void GetCutingData(string strFurnaceNo)
        {
            int iRow = 0;
            Color clrCurr = Color.MintCream, clrPre = Color.LightGreen;
            string strCurrAIM_LTH = "", strPreAIM_LTH = "";
            string err = "";
            DataSet ds = null;// (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("lgIntegrationQuery", "Core.LgMes.Server.lgIntegrationQuery.LgGeneralInfo", "GetCutingData", new object[] { strFurnaceNo }, out err);
            ultraDataSource2.Rows.Clear();
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                ultraDataSource2.Rows.Add(new object[] {dr["BILLET_XN"].ToString(),  //坯料号
                                                        dr["CAST_NO"].ToString(),  //浇次号
                                                        dr["SEQUENCEINCAST"].ToString(),  //浇次顺序号
                                                        dr["SEQUENCENO"].ToString(),  //炉内顺序号
                                                        dr["FURNACENO"].ToString(),  //炉号
                                                        dr["CUTTASKCODE"].ToString(),  //铸机号
                                                        dr["SC"].ToString(),  //流号
                                                        dr["SLABHEIGHT"].ToString(),  //坯料厚度
                                                        dr["SLABWIDTH"].ToString(),  //坯料宽度
                                                        dr["SLABLENGTH"].ToString(),  //坯料长度
                                                        dr["CUTSEQUENCE"].ToString(),  //计划切割顺序号
                                                        (dr["DIRECTIONTYPE"].ToString()=="0"?"弹扁":(dr["DIRECTIONTYPE"].ToString()=="1"?"棒材":"高线")),  //去向类型
                                                        dr["ROLLPLANCODE"].ToString(),  //热送轧制计划号
                                                        (dr["CUTFINISHFLAG"].ToString()=="0"?"否":"是"),  //切割是否完成
                                                        dr["THEROYWEIGHT"].ToString(),  //理论重量
                                                        dr["PLANMAKETIME"].ToString(),  //计划制定时间
                                                        dr["LSTEELCODE"].ToString(),  //冶炼牌号(大牌号)
                                                        dr["STEELCODE"].ToString(),  //牌号
                                                        dr["HARDNESS"].ToString(),  //硬度
                                                        (dr["SURPLUSFLAG"].ToString()=="0"?"否":"是"),  //是否余材
                                                        dr["PRODORDERNO"].ToString(),  //生产订单号
                                                        dr["ORDERNO"].ToString(),  //订单行号
                                                        dr["BATCHPLANNO"].ToString(),  //批量计划序号
                                                        dr["INDEXINLOTNO"].ToString(),  //批量内序号
                                                        dr["CRAFTCODE_LG"].ToString(),  //炼钢工艺码
                                                        dr["CUSTOMER_KEY"].ToString(),  //客户参数号
                                                        dr["SEQUENCEINBATCH"].ToString(),  //单元内顺序号
                                                        dr["CUTSTARTTIME"].ToString(),  //切割开始时间
                                                        dr["CUTENDTIME"].ToString(),  //切割结束时间
                                                        dr["MAKEMAN"].ToString(),  //制定人
                                                        dr["STANDARDSCODE"].ToString(),
                                                        dr["STANDARDREMAK"].ToString(),
                                                        dr["BILLETWEIGHT"].ToString(),
                                                        dr["PDTSTYLE"].ToString(),
                                                        dr["SPECDESCRIPTION"].ToString(),
                                                        dr["FOREIGN_TRADE"].ToString()
                                                      });

                strCurrAIM_LTH = Convert.ToString(dr["SLABLENGTH"]);
                if (strCurrAIM_LTH != strPreAIM_LTH)
                {
                    if (clrPre == Color.MintCream)
                        clrCurr = Color.LightGreen;
                    else if (clrPre == Color.LightGreen)
                        clrCurr = Color.MintCream;

                    clrPre = clrCurr;
                    strPreAIM_LTH = strCurrAIM_LTH;
                }
                this.ultraGrid3.Rows[iRow].CellAppearance.BackColor = clrCurr;
                iRow += 1;
            }
        }

        private void ultraGrid1_Click(object sender, EventArgs e)
        {

            try
            {
                strHeatNo = "";

                if (this.ultraGrid1.Rows.Count < 1)
                    return;
                if (this.ultraGrid1.ActiveCell == null)
                    return;
                UltraGridRow ultraRow = this.ultraGrid1.ActiveCell.Row;

                string status = ultraRow.Cells["HEAT_STATE"].Value.ToString();
                if ( status == "09")
                    ultraToolbarsManager1.Tools["Reset"].SharedProps.Enabled = true;
                //this.btnReset.Visible = true;
                else
                    ultraToolbarsManager1.Tools["Reset"].SharedProps.Enabled = false;
                strHeatNo = ultraRow.Cells["HeatNo"].Value.ToString();
                string strFurnaceNo = ultraRow.Cells["V_HEAT_ID"].Value.ToString();
                string strWhere = string.Format(" WHERE FURNACENO = '{0}'", strFurnaceNo);
                GetCutingData(strWhere);
            }
            catch (Exception ex)
            {
                string msg = ex.Message;
            }
        }

        #region "	Auto Refresh	"
        private Thread _getDataThread;
        private bool On_Off_GetDataThread = false;
        private delegate void getDataFromAllDelegate(string str);

        private void StartGetDataThread()
        {
            ThreadStart ts = new ThreadStart(GetDataThread);
            _getDataThread = new Thread(ts);
            _getDataThread.Name = "GetDataThread_SH ";

            _getDataThread.Start();
        }
        private void GetDataThread()
        {
        ReStartGetDataThread:
            while (true)
            {
                if (!this.On_Off_Thread || !On_Off_GetDataThread)//this.On_Off_Thread
                {
                    System.Threading.Thread.Sleep(500);
                    continue;
                }
                try
                {
                    this.Invoke(new getDataFromAllDelegate(GetJobData), "");
                    //GetData();

                    System.Threading.Thread.Sleep(10000);
                }
                catch (Exception ex)
                {
                    string msg = ex.Message;
                }

                goto ReStartGetDataThread;
            }
        }

        #endregion


        private void chkAutoRefresh_CheckedChanged(object sender, EventArgs e)
        {
            On_Off_GetDataThread = this.chkAutoRefresh.Checked;
            if (chkAutoRefresh.Checked)
            {
                ultraGroupBox3.Visible = false;
                splitContainer1.Panel1Collapsed = true;
            }
            else
            {
                ultraGroupBox3.Visible = true;
                splitContainer1.Panel1Collapsed = false;
            }
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {            
            switch (ToolbarKey)
            {
                case "Query":  //查询
                    {
                        GetCastPlan();
                        GetJobData("");
                        break;
                    }
                case "Reset":  //重置
                    {
                        if (this.ultraGrid1.ActiveRow == null) return;
                        UltraGridRow ugr = this.ultraGrid1.ActiveRow;

                        string status = ugr.Cells["HEAT_STATE"].Value.ToString();
                        if (status == "03")
                            return;

                        string strSme = ugr.Cells["HEATNO"].Value.ToString();
                        string strPath = ugr.Cells["Fact_route"].Value.ToString();

                        FrmCcmResetStatus frm = new FrmCcmResetStatus();
                        frm.Location = GetChildWindowLocation(frm.Size);
                        frm.ShowDialog();
                        string strSet = frm._strSet;
                        string strSta = frm._strSta;
                        if (strSet == "") return;
                        ArrayList ar = new ArrayList();

                        if (strSet == "LFS01") strSme = "E0101" + strSme;
                        else if (strSet == "LFS02") strSme = "E0201" + strSme;
                        else if (strSet == "CCM01") strSme = "G0101" + strSme;
                        else if (strSet == "CCM02") strSme = "G0201" + strSme;
                        else if (strSet == "CCM03") strSme = "G0301" + strSme;
                        else if (strSet == "CCM04") strSme = "G0401" + strSme;

                        ar.Add(strSet);	//objectpos
                        ar.Add(strSme);	//objectid
                        ar.Add(strSta);	//devicestates
                        string strRecorder = this.UserInfo.GetUserName(); //add on 2009-04-23

                        try
                        {
                            string err = "";
                            int i = 0;// Convert.ToInt32(ClientCommon._RemotingHelp.ExecuteMethod("lgIntegrationQuery", "Core.LgMes.Server.lgIntegrationQuery.LgGeneralInfo", "UpdateTrackObjectInfo", new object[] { ar, strRecorder }, out err));

                            if (i > 0)
                            {
                                MessageBox.Show("炉号重置成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                                return;
                            }
                        }
                        catch (Exception ex)
                        {
                            Console.WriteLine(ex.Message);
                        }
                        MessageBox.Show("设置失败,请检查重置岗位处理位是否有炉号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        break;
                    }
                case "Exit": //查询
                    {
                        this.Close();
                        break;
                    }
                case "ModifySpec": //修改规格
                    {
                        UltraGridRow ultraRow = this.ultraGrid3.ActiveRow;
                        if (ultraRow == null)
                            MessageBox.Show("请在切割计划详细网格中选取要修改规格的切割计划！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                        else
                        {
                            frmModifySpec frmMs = new frmModifySpec();
                            frmMs.strHeatNO = strHeatNo;
                            frmMs.strBilletNo = ultraRow.Cells["BILLET_XN"].Value.ToString();
                            frmMs.strSteel = ultraRow.Cells["LSTEELCODE"].Value.ToString();
                            frmMs.strOld_Height = ultraRow.Cells["SLABHEIGHT"].Value.ToString();
                            frmMs.strOld_Width = ultraRow.Cells["SLABWIDTH"].Value.ToString();
                            frmMs.strOld_Length = ultraRow.Cells["SLABLENGTH"].Value.ToString();
                            frmMs.strTheroyWeight = ultraRow.Cells["TheroyWeight"].Value.ToString();
                            frmMs.WindowState = FormWindowState.Normal;
                            frmMs.StartPosition = FormStartPosition.CenterParent;
                            frmMs.ShowDialog();
                        }
                        break;
                    }
                default:
                    break;
            }
            
        }

        private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            //switch (e.Tool.Key.ToString())
            //{
            //    case "Query":  //查询
            //        {
            //            GetCastPlan();
            //            GetJobData("");
            //            break;
            //        }
            //    case "Reset":  //重置
            //        {
            //            if (this.ultraGrid1.ActiveRow == null) return;
            //            UltraGridRow ugr = this.ultraGrid1.ActiveRow;

            //            string status = ugr.Cells["HEAT_STATE"].Value.ToString();
            //            if (status == "03")
            //                return;

            //            string strSme = ugr.Cells["HEATNO"].Value.ToString();
            //            string strPath = ugr.Cells["Fact_route"].Value.ToString();

            //            FrmCcmResetStatus frm = new FrmCcmResetStatus();
            //            frm.Location = GetChildWindowLocation(frm.Size);
            //            frm.ShowDialog();
            //            string strSet = frm._strSet;
            //            string strSta = frm._strSta;
            //            if (strSet == "") return;
            //            ArrayList ar = new ArrayList();

            //            if (strSet == "LFS01") strSme = "E0101" + strSme;
            //            else if (strSet == "LFS02") strSme = "E0201" + strSme;
            //            else if (strSet == "CCM01") strSme = "G0101" + strSme;
            //            else if (strSet == "CCM02") strSme = "G0201" + strSme;
            //            else if (strSet == "CCM03") strSme = "G0301" + strSme;
            //            else if (strSet == "CCM04") strSme = "G0401" + strSme;

            //            ar.Add(strSet);	//objectpos
            //            ar.Add(strSme);	//objectid
            //            ar.Add(strSta);	//devicestates
            //            string strRecorder = this.UserInfo.GetUserName(); //add on 2009-04-23

            //            try
            //            {
            //                string err = "";
            //                int i = 0;// Convert.ToInt32(ClientCommon._RemotingHelp.ExecuteMethod("lgIntegrationQuery", "Core.LgMes.Server.lgIntegrationQuery.LgGeneralInfo", "UpdateTrackObjectInfo", new object[] { ar, strRecorder }, out err));

            //                if (i > 0)
            //                {
            //                    MessageBox.Show("炉号重置成功！","提示",MessageBoxButtons.OK,MessageBoxIcon.Asterisk);
            //                    return;
            //                }
            //            }
            //            catch (Exception ex)
            //            {
            //                Console.WriteLine(ex.Message);
            //            }
            //            MessageBox.Show("设置失败,请检查重置岗位处理位是否有炉号！","提示",MessageBoxButtons.OK,MessageBoxIcon.Error);
            //            break;
            //        }            
            //    case "Close": //查询
            //        {
            //            this.Close();
            //            break;
            //        }
            //    case "ModifySpec": //修改规格
            //        {
            //            UltraGridRow ultraRow = this.ultraGrid3.ActiveRow;
            //            if (ultraRow == null)
            //                MessageBox.Show("请在切割计划详细网格中选取要修改规格的切割计划！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
            //            else
            //            {
            //                frmModifySpec frmMs = new frmModifySpec();
            //                frmMs.strHeatNO = strHeatNo;
            //                frmMs.strBilletNo = ultraRow.Cells["BILLET_XN"].Value.ToString();
            //                frmMs.strSteel = ultraRow.Cells["LSTEELCODE"].Value.ToString();
            //                frmMs.strOld_Height = ultraRow.Cells["SLABHEIGHT"].Value.ToString();
            //                frmMs.strOld_Width = ultraRow.Cells["SLABWIDTH"].Value.ToString();
            //                frmMs.strOld_Length = ultraRow.Cells["SLABLENGTH"].Value.ToString();
            //                frmMs.strTheroyWeight = ultraRow.Cells["TheroyWeight"].Value.ToString();
            //                frmMs.WindowState = FormWindowState.Normal;
            //                frmMs.StartPosition = FormStartPosition.CenterParent;
            //                frmMs.ShowDialog();
            //            }
            //            break;
            //        }
            //    default:
            //        break;
            //}
        }

        private void ultraGrid4_Click(object sender, EventArgs e)
        {
            try
            {
                if (this.ultraGrid4.Rows.Count < 1)
                    return;
                if (this.ultraGrid4.ActiveCell == null)
                    return;
                UltraGridRow ultraRow = this.ultraGrid4.ActiveCell.Row;

                string strCastNo = ultraRow.Cells["CAST_NO"].Value.ToString();
                GetJobData(strCastNo);
            }
            catch (Exception ex)
            {
                string msg = ex.Message;
            }
        }

        private void chkState_CheckedChanged(object sender, EventArgs e)
        {
            if (chkState.Checked)
                ultracboState.Enabled = true;
            else
                ultracboState.Enabled = false;
   
        }

        private void chkHeatNo_CheckedChanged(object sender, EventArgs e)
        {
            if (chkHeatNo.Checked)
                txtHeatNo.Enabled = true;
            else
                txtHeatNo.Enabled = false;
        }
        
    }
}