XinYu_LG2MES/ClientSolution/Core.LgMes.Client.lgIntegrationQuery/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;
using System.Data.OleDb;
using Core.Mes.Client.Common;
using Core.LgMes.Client.Comm;

namespace Core.LgMes.Client.LgIntegrationQuery
{
    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;
            cobbof.Enabled = false;
            ultracboState.Enabled = false;
            txtHeatNo.Enabled = false;
            uldtBeginTime.Value = System.DateTime.Now.AddHours(-6).ToString();
            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;
            cobbof.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>
        private void GetCastPlan()
        {
            int i = 0;

            string strStartTime = "";
            string strEndTime = "";
            string strstatus = "";
            string ccmID = "";

            if (Convert.ToDateTime(uldtBeginTime.Value) > Convert.ToDateTime(uldtEndTime.Value))
            {
                MessageBox.Show("时间条件的开始时间不能大于结束时间！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                return;
            }
            else
            {
                strStartTime = this.uldtBeginTime.DateTime.ToString("yyyy-MM-dd");
                strEndTime = this.uldtEndTime.DateTime.ToString("yyyy-MM-dd");
            }

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

            }
            else
                strstatus += " and status>='03'";

            //铸机号
            if (chkCcmID.Checked)
            {
                ccmID = Convert.ToString(cboCcmID.SelectedIndex+1);
            }

            ArrayList arry = new ArrayList();
            ArrayList sqlList = new ArrayList();
            arry.Add("GetCastPlan.select");
            arry.Add(strStartTime);
            arry.Add(strEndTime);
            sqlList.Add(strstatus);
            arry.Add(ccmID);
            arry.Add(ccmID);

            arry.Add(strStartTime);
            arry.Add(strEndTime);
            sqlList.Add(strstatus);
            arry.Add(ccmID);
            arry.Add(ccmID);

            CoreFS.CA06.FrmBase fr = new FrmBase();
            fr.ob = ob;
            CoreClientParam CCP_Query = new CoreClientParam();
            DataTable dt = new DataTable();
            CCP_Query.ServerName = "Core.LgMes.Server.Common.ComDBQuery";
            CCP_Query.MethodName = "doQuery";
            CCP_Query.ServerParams = new object[] { arry, sqlList };
            CCP_Query.SourceDataTable = dt;
            fr.ExecuteQueryToDataTable(CCP_Query, CoreInvokeType.Internal);

            DataSet ds = new DataSet(); 
            ds.Tables.Add(dt);
            ultraDataSource3.Rows.Clear();

            if (ds != null)
            {
                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;
                    }
                }
            }
            else
                MessageBox.Show("查询失败！！！", "提示");
        }

        /// <summary>
        /// 获取作业计划信息
        /// </summary>
        private void GetJobData(string strCast_No)
        {
            if (uldtEndTime.DateTime.Date.Subtract(uldtBeginTime.DateTime.Date).Days > 180)
            {
                MessageBox.Show("查询时间不可超过6个月。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            if (uldtBeginTime.DateTime > uldtEndTime.DateTime)
            {
                MessageBox.Show("查询起始时间不能大于结束时间！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            int i = 0;
            string strStartTime = "";
            string strEndTime = "";
            string strCastNo = "";
            string strHeatState = "";
            string strCAST_ID = "";
            string strHeatNo = "";
            string strGW = "";

            if (strCast_No.Trim().Length > 0)
                strCastNo = strCast_No;

            if (Convert.ToDateTime(uldtBeginTime.Value) > Convert.ToDateTime(uldtEndTime.Value))
            {
                MessageBox.Show("时间条件的开始时间不能大于结束时间！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                return;
            }
            else
            {
                strStartTime = this.uldtBeginTime.DateTime.ToString("yyyy-MM-dd");
                strEndTime = this.uldtEndTime.DateTime.ToString("yyyy-MM-dd");
            }

            //状态
            if (chkState.Checked)
            {
                if (ultracboState.Value.ToString() == "04")
                    strHeatState = " and heat_state >'03' and heat_state <'10' ";
                else if (ultracboState.Value.ToString() == "03" || ultracboState.Value.ToString() == "10")
                    strHeatState = " and heat_state ='" + ultracboState.Value.ToString() + "'";

            }

            //铸机
            if (chkCcmID.Checked)
            {
                strCAST_ID = Convert.ToString(cboCcmID.SelectedIndex+1);
            }

            // 炉号
            if (chkHeatNo.Checked)
            {
                strHeatNo = txtHeatNo.Text.Trim();
            }

            // 炉座
            if (chkbof.Checked)
            {
                strGW = Convert.ToString(cobbof.Value);
            }
            //}

            ArrayList arry = new ArrayList();
            ArrayList sqlList = new ArrayList();
            arry.Add("GetAllJobPlan.select");
            arry.Add(strCastNo);
            arry.Add(strCastNo);
            arry.Add(strStartTime);
            arry.Add(strEndTime);
            sqlList.Add(strHeatState);
            arry.Add(strCAST_ID);
            arry.Add(strCAST_ID);
            arry.Add(strHeatNo);
            arry.Add(strHeatNo);
            arry.Add(strGW);
            arry.Add(strGW);

            //调用服务端方法
            CoreClientParam CCP_LgEts = new CoreClientParam();
            DataTable dt = new DataTable();
            CCP_LgEts.ServerName = "Core.LgMes.Server.Common.ComDBQuery";
            CCP_LgEts.MethodName = "doQuery";
            CCP_LgEts.ServerParams = new object[] { arry, sqlList };
            CCP_LgEts.SourceDataTable = dt;
            this.ExecuteQueryToDataTable(CCP_LgEts, CoreInvokeType.Internal);

            DataSet ds = new DataSet();
            ds.Tables.Add(dt);
            ultraDataSource1.Rows.Clear();
            if (ds != null)
            {
                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_VD_STR_TIME"].ToString(),
                                                                dr["PLAN_VD_ENT_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(),
                                                                CStaticMethod.analysPath(dr["PLAN_ROUTE"].ToString()),
                                                                CStaticMethod.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(),
                                                                dr["TSYQ"].ToString()
                                                           });
                        //执行状态
                        string status = dr["HEAT_STATE"].ToString();
                        if (dr["TSYQ"].ToString() == "Y")
                            ultraGrid1.Rows[i].Cells["TSYQ"].Appearance.ForeColor = Color.Red;

                        if (status.Length >= 2 && string.Compare(status, "03") == 1 && string.Compare(status, "10") == -1)
                        {
                            foreach (UltraGridCell cell in ultraGrid1.Rows[i].Cells)
                                cell.Appearance.BackColor = Color.LightGreen;//在生产用颜色区分
                        }
                        else if (status.Length >= 2 && status == "10")
                        {
                            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;
                    }
                }
            }
            else
                MessageBox.Show("查询失败！！！", "提示");

        }

        /// <summary>
        /// 获取切割计划信息
        /// </summary>
        /// <param name="strCastNo">浇次号</param>
        /// <param name="strSequenceinCast">浇次顺序号</param>
        /// <param name="strFurnaceNo">熔炼号</param>
        private void GetCutingData(string strFurnaceNo)
        {
            string strErr = "";
            int iRow = 0;
            Color clrCurr = Color.MintCream, clrPre = Color.LightGreen;
            string strCurrAIM_LTH = "", strPreAIM_LTH = "";

            ArrayList arry = new ArrayList();
            arry.Add("GetCutingData.select");
            arry.Add(strFurnaceNo);
            arry.Add(strFurnaceNo);

            CommonClientToServer cctos = new CommonClientToServer();
            cctos.ob = this.ob;
            DataSet ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
                                        "doSimpleQuery", arry, out strErr);

            ultraDataSource2.Rows.Clear();

            if (ds != null)
            {
                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;
                }
            }
            else
                MessageBox.Show("查询失败！！！", "提示");
        }

        /// <summary>
        /// 作业计划标准查询
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid1_DoubleClickRow(object sender, DoubleClickRowEventArgs e)
        {
            string strIsNoY = ultraGrid1.ActiveRow.Cells["TSYQ"].Text.Trim();
            string szLH = ultraGrid1.Rows[e.Row.Index].Cells["HEATNO"].Value.ToString();
            string szPH = ultraGrid1.Rows[e.Row.Index].Cells["AIM_GRADE_CODE"].Value.ToString();

            if (strIsNoY == "Y")
            {
                frmLgEleDetail Azhupi = new frmLgEleDetail(szLH, frmLgEleDetail.strSteelCode, "ZYJH", ob);
                Azhupi.ultrgridRow = ultraGrid1.ActiveRow;
                Azhupi.ShowDialog(this);
            }
        }

        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(strFurnaceNo);
            }
            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 (!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 "Rollback":  //重置
                    {
                        if (this.ultraGrid1.ActiveRow == null) return;
                        UltraGridRow ugr = this.ultraGrid1.ActiveRow;

                        string status = ugr.Cells["HEAT_STATE"].Value.ToString();
                        if (status != "10")
                        {
                            MessageBox.Show("炉号："+ugr.Cells["HeatNo"].Value.ToString() + "没有生产完成不允许重置！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                            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();
                        string strDev = "";
                        string sqlstr = "";
                        string strDisposalTime = "";
                        string strPnewHeatId = "";
                        string strPoldHeatID = "";
                        int intCount = 0;
                        DataSet ds = null;
                        string strErr = "";

                        //wyb 20110328
                        strDev = (string)ar[0];
                        if (strDev == string.Empty)
                        {
                            MessageBox.Show("请选择重置去向", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                        }

                        if (strDev.Substring(0, 3) == "LFS")//精炼
                        {
                            ArrayList arry = new ArrayList();
                            arry.Add("getLFSJudgeData.select");
                            arry.Add(ar[0] + "_FRONT");
                            arry.Add(ar[0] + "_BACK");
                            arry.Add(ar[0] + "_DEVICE");

                            CommonClientToServer cctos = new CommonClientToServer();
                            cctos.ob = this.ob;
                            ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
                                                        "doSimpleQuery", arry, out strErr);

                            ArrayList arryCount = new ArrayList();
                            arryCount.Add("getLFSCountData.select");
                            arryCount.Add(ar[1]);
                            arryCount.Add(ar[1]);
                            arryCount.Add(ar[1]);
                            arryCount.Add(ar[1]);

                            CommonClientToServer cctos1 = new CommonClientToServer();
                            cctos1.ob = this.ob;
                            DataSet dsCount = cctos1.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
                                                        "doSimpleQuery", arryCount, out strErr);

                            if (dsCount != null && dsCount.Tables[0].Rows.Count > 0)
                            {
                                strDisposalTime = "0" + Convert.ToString(Convert.ToInt16(dsCount.Tables[0].Rows[0][0]) + 1);
                            }
                            strPnewHeatId = ar[1].ToString().Substring(0, 3) + strDisposalTime + CStaticMethod.getSmeltingID(ar[1].ToString());
                        }
                        else if (strDev.Substring(0, 3) == "CCM")//连铸机
                        {

                            ArrayList arry = new ArrayList();
                            arry.Add("getCCMJudgeData.select");
                            arry.Add(ar[0] + "_FRONT");
                            arry.Add(ar[0] + "_DEVICE");

                            CommonClientToServer cctos = new CommonClientToServer();
                            cctos.ob = this.ob;
                            ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
                                                        "doSimpleQuery", arry, out strErr);

                            ArrayList arryCount = new ArrayList();
                            arryCount.Add("getCCMCountData.select");
                            arryCount.Add(ar[1]);
                            arryCount.Add(ar[1]);
                            arryCount.Add(ar[1]);
                            arryCount.Add(ar[1]);

                            CommonClientToServer cctos2 = new CommonClientToServer();
                            cctos2.ob = this.ob;
                            DataSet dsCount = cctos2.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
                                                        "doSimpleQuery", arryCount, out strErr);

                            if (dsCount != null && dsCount.Tables[0].Rows.Count > 0)
                            {
                                intCount = Convert.ToInt16(dsCount.Tables[0].Rows[0][0]);
                            }
                            strDisposalTime = "01";
                            strPnewHeatId = ar[1].ToString();
                        }

                        strPoldHeatID = "C0" + strPnewHeatId.Substring(7, 1) + "01" + strPnewHeatId.Substring(5, 10);

                        if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
                        {
                            string strPos = ""; //重置位置
                            foreach (DataRow drPos in ds.Tables[0].Rows)
                            {
                                if (string.IsNullOrEmpty(drPos["OBJECTID"].ToString()))
                                {
                                    strPos = drPos["OBJECTPOS"].ToString();
                                    break;
                                }
                            }

                            if (strPos == "")
                            {
                                MessageBox.Show("重置目标位置已经存在炉号！");
                                return;
                            }
                            
                            ArrayList arry = new ArrayList();
                            arry.Add("UpdateOBJECTID.select");
                            arry.Add(strPnewHeatId);
                            arry.Add(ar[2]);
                            arry.Add(Convert.ToInt16(strDisposalTime));
                            arry.Add(strPos);

                            CommonClientToServer cctos = new CommonClientToServer();
                            cctos.ob = this.ob;
                            DataSet dsobject = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBSave",
                                            "doSimpleSave", arry, out strErr);

                            if (strErr == "")
                            {
                                //精炼有记录在处理次数加1
                                if (strDev.Substring(0, 3) == "LFS")
                                    CreateLfs_CCM_JobInfo(strPnewHeatId, strPoldHeatID);
                                //连铸机有记录不再生成记录
                                if (strDev.Substring(0, 3) == "CCM" && intCount == 0)
                                    CreateLfs_CCM_JobInfo(strPnewHeatId, strPoldHeatID);

                                string strHeatID =CStaticMethod.getSmeltingID(ar[1].ToString());        //add on 2009-04-23 加入日志
                                RecordLog(strRecorder, strHeatID, "01");                    //add on 2009-04-23 加入日志
                            }
                            //清除OVER位数据
                            if (strDev.Substring(0, 3) == "CCM")
                            {
                                ArrayList arryOver = new ArrayList();
                                arryOver.Add("UpdateOverData.select");
                                arryOver.Add(ar[0] + "_OVER");
                                arryOver.Add(ar[1]);
                              

                                CommonClientToServer cctos3 = new CommonClientToServer();
                                cctos3.ob = this.ob;
                                DataSet dsOb = cctos3.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBSave",
                                               "doSimpleSave", arryOver, out strErr);
                            }
                            if (strErr == "")
                            {
                                MessageBox.Show("炉号重置成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                                return;
                            }
                            else
                                MessageBox.Show("设置失败,请检查重置岗位处理位是否有炉号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                            break;

                        }
                        break;
                    }
                case "Exit":
                    this.Close();
                    break;
                case "ModifySpec": //修改规格
                    {
                        UltraGridRow ultraRow = this.ultraGrid3.ActiveRow;
                        if (ultraRow == null)
                            MessageBox.Show("请在切割计划详细网格中选取要修改规格的切割计划！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                        else
                        {

                        }
                        break;
                    }
                default:
                    break;
            }

        }

        private void RecordLog(string strRecorder, string strHeatNo, string strFlag)     //add on 2009-04-23 计划事件日志
        {
            string strErr = "";
            try
            {
                ArrayList arry = new ArrayList();
                arry.Add("TPM_MODIFYLOG_Save.select");
                arry.Add(strHeatNo);
                arry.Add("X00");
                arry.Add(strRecorder);
                arry.Add(strFlag);

                CommonClientToServer cctos = new CommonClientToServer();
                cctos.ob = this.ob;
                DataSet dsobject = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBSave",
                                "doSimpleSave", arry, out strErr);
            }
            catch { }
        }


        /// <summary>
        /// 计划重置时创建作业信息(精炼、连铸机)
        /// </summary>
        /// <param name="strPnewHeatId">重置之后的新加热处理号</param>
        /// <param name="strPoldHeatId">旧加热处理号（对应炉号的转炉加热处理号）</param>
        /// <returns></returns>
        public bool CreateLfs_CCM_JobInfo(string strPnewHeatId, string strPoldHeatId)
        {
            try
            {
                string strError = "";
                string strSqlID = "";
                if (strPnewHeatId.Substring(0, 1) == "E") strSqlID = "CreateLFSjob.Update";
                if (strPnewHeatId.Substring(0, 1) == "G") strSqlID = "CreateCcmjob.Update";

                Hashtable hashtb = new Hashtable();
                hashtb.Add("I1", strPnewHeatId);                          //重置新炉号
                hashtb.Add("I2", strPoldHeatId);                          //原始炉号
               

                CommonClientToServer ccTs = new CommonClientToServer();
                ccTs.ob = ob;

                string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
                                                "executeProcedure", strSqlID, hashtb, out strError);
                if (strError != "")
                {
                    return (true);
                }
                return false;
            }
            catch (Exception ex)
            { return true; }
        }

        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;
                txtHeatNo.BackColor = Color.WhiteSmoke;
            }
        }

        private void chkbof_CheckedChanged(object sender, EventArgs e)
        {
            if (chkbof.Checked)
                cobbof.Enabled = true;
            else
                cobbof.Enabled = false;
        }

    }
}