MES_Client/TGMES/Core.StlMes.Client.Mcp.VRP/Vrp/FrmVrpColdDrawn.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using CoreFS.CA06;

using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Control;
using Infragistics.Win.UltraWinGrid;
using System.Collections;
using com.steering.mes.mcp.entity;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.Mcp.Control;
using Core.StlMes.Client.Mcp.VRP.Vrp;


namespace Core.StlMes.Client.Htt
{
    public partial class FrmVrpColdDrawn : FrmBase
    {
        private string SlGx
        {
            get
            {
                if (plineCode == "C014")
                {
                    return "650504";
                }
                else if (plineCode == "C013" || plineCode == "C080")
                {
                    return "650604";
                }
                return "650504";
            }
        }
        private string departm = "";
        private string plineCode = "";
        private string[] plineCodes;
        private string cold = "";
        //private string name = "";
        private string storageNo = "";//仓库代码
        string craftPath = "";//工艺文件路径
        private string dingwei = "";//新增功能后定位到当前行
        public FrmVrpColdDrawn()
        {
            InitializeComponent();
            this.IsLoadUserView = true;
        }

        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            this.planExpanLGColdDrawn1.Grid.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            this.planExpanLBColdDrawn1.Grid.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            this.planExpanLDColdDrawn1.Grid.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            initControl();
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            //base.ToolBar_Click(sender, ToolbarKey);
            switch (ToolbarKey)
            {
                case "DoQuery":
                    QuerySinglePlan();
                    break;
                case "DoLoading":
                    DoSave();
                    break;
                case "DoReturn":
                    DoReturn();
                    break;
                case "DoUpdate":
                   DoUpdate();
                   break;
                case "DoBeside":
                    DoBeside();
                    break;
                case "CelBeside":
                    DoCelBeside();
                    break;
                case "DoClose":
                    this.Close();
                    break;
            }
        }
        private void DoCelBeside()
        {
            UltraGridRow row = ultraGrid1.ActiveRow;
            if (row == null) return;
            string num = row.Cells["PRO_NUM"].Text.ToString();
            ArrayList list = new ArrayList();
            list.Add(row.Cells["HEAT_PLAN_NO"].Value.ToString());
            list.Add(row.Cells["PLINE_CODE"].Value.ToString());
            list.Add(SlGx);
            if (MessageUtil.ShowYesNoAndQuestion("是否撤销结炉?") == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmVrpColding";
            ccp.MethodName = "undoBeside";
            ccp.ServerParams = new Object[] { list,num };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("撤销结炉成功!"))
                {
                    QuerySinglePlan();
                    initControl();
                    
                }
            }
        }
        /// <summary>
        /// 工序结炉
        /// </summary>
        private void DoBeside()
        {
            UltraGridRow row = ultraGrid1.ActiveRow;
            if (row == null)
            {
                MessageUtil.ShowTips("无工单信息，不允许此操作！");
                return;
            }
            string num = row.Cells["IN_NUM"].Text.ToString();
            UltraGridRow row1 = ultraGrid4.ActiveRow;
            if (row1 == null) return;
            string heatNo = row1.Cells["HEAT_PLAN_NO"].Value.ToString();
            //查询冷轧冷拔实绩
            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpColding.getLoadResult", new object[] { heatNo }, this.ob);
            if (dt.Rows[0]["STATION_STATUS"].ToString().Equals("生产完成"))
            {
                MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作！");
                return;
            }
            ArrayList list = new ArrayList();
            list.Add(row.Cells["HEAT_PLAN_NO"].Value.ToString());
            list.Add(row.Cells["PLINE_CODE"].Value.ToString());
            list.Add(SlGx);
            if (MessageUtil.ShowYesNoAndQuestion("是否结炉?") == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmVrpColding";
            ccp.MethodName = "updateDoBeside";
            ccp.ServerParams = new Object[] { list,num };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("结炉成功！"))
                {
                    QuerySinglePlan();
                    initControl();
                    
                }
            }
        }

        /// <summary>
        /// 简单查询
        /// </summary>
        private void QuerySinglePlan()
        {
            string plnNo = "";
            string judgeStoveNo = "";
            #region  条件       
            if (chkPlnNo.Checked)
            {
                if (string.IsNullOrEmpty(txtRollBatchId.Text.Trim()))
                {
                    MessageUtil.ShowTips("请输入炉次计划号！");
                    return;
                }
                else
                {
                    plnNo = txtRollBatchId.Text.ToString().Trim();
                }
            }
            
            if (chkJuNo.Checked )
            {
                if (string.IsNullOrEmpty(txtZyBatchId.Text.Trim()))
                {
                    MessageUtil.ShowTips("请输入炉号！");
                    return;
                }
                else
                {
                    judgeStoveNo = txtZyBatchId.Text.ToString().Trim();
                }
            }
            
            #endregion
            PlnZyDbkMEntity plan = new PlnZyDbkMEntity();
            plan.JudgeStoveNo = judgeStoveNo;//生产批次号
            plan.HeatPlanNo = plnNo;//组料炉批号
            string dobeside = "";
            string index = "";
            if (ultraOptionSet1.CheckedIndex.ToString() == "0")
            {
                index = "0";
                dobeside = ultraOptionSet1.CheckedItem.DataValue.ToString();
            }
            else if (ultraOptionSet1.CheckedIndex.ToString() == "1")
            {
                index = "1";
                dobeside = ultraOptionSet1.CheckedItem.DataValue.ToString();
            }
            else
            {
                index = "2";
            }
            string[] start = contorlPlanStatus1.statusArr;
            //查询镦拔扩计划
            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getDbkPlan", new object[] { plan, plineCodes, dobeside,index,start }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt, ref dataTable2, true);
            foreach (UltraGridRow urg in ultraGrid1.Rows)
            {
                if (urg.Cells["PLANSTATUS"].Text.Equals("生产中"))
                {
                    urg.Cells["PLANSTATUS"].Appearance.BackColor = Color.LightGreen;
                }
                if (urg.Cells["PLANSTATUS"].Text.Equals("生产完成"))
                {
                    urg.Cells["PLANSTATUS"].Appearance.BackColor = Color.Red;
                }
                if (urg.Cells["PLANSTATUS"].Text.Equals("关闭"))
                {
                    urg.Cells["PLANSTATUS"].Appearance.BackColor = Color.Red;
                }
                if (urg.Cells["BESIDE_STATUS"].Text.Equals("表检结炉"))
                {
                    urg.Cells["BESIDE_STATUS"].Appearance.BackColor = Color.LightGray;
                }
            }
            if (dt.Rows.Count > 0)
            {
                for (int i = 0; i < ultraGrid1.Rows.Count; i++)
                {
                    if (ultraGrid1.Rows[i].Cells["HEAT_PLAN_SQE"].Value.ToString() == dingwei)
                    {
                        UltraGridRow row = ultraGrid1.Rows[i];
                        row.Activate();
                    }
                }
            }
            initControl();
        }

        /// <summary>
        /// 上料计划详情
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            this.getUltraGrid1AfterRowActivate();
            ultraGrid1.UpdateData();
            UltraGridRow uRow = this.ultraGrid1.ActiveRow;
            if (uRow != null)
            {
                dingwei = uRow.Cells["HEAT_PLAN_SQE"].Value.ToString();
                plineCode = uRow.Cells["PLINE_CODE"].Value.ToString();
                string heat = uRow.Cells["HEAT_PLAN_NO"].Value.ToString();
                //查询管号队列合格的支、吨
                DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryDbkPortVrp1", new object[] { heat }, ob);
                string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
                VrpColdDrawnResultEntity result = new VrpColdDrawnResultEntity();
                result.LoadShift = UserInfo.GetUserOrder();
                result.LoadGroup = UserInfo.GetUserGroup();
                result.LoadUser = UserInfo.GetUserName();
                result.LoadTime = time;
                result.ProducerTime = time;
                result.ProNum = dt2.Rows[0]["ACT_COUNT"].ToString();
                result.ProWt = dt2.Rows[0]["ACT_WEIGHT"].ToString();
                result.AccNum = dt2.Rows[0]["ACT_COUNT"].ToString();
                result.AccWt = dt2.Rows[0]["ACT_WEIGHT"].ToString();
                this.planExpanLGColdDrawn1.Value = result;
                this.planExpanLBColdDrawn1.Value = result;
                this.planExpanLDColdDrawn1.Value = result; 
                 if (ultraTabControl1.SelectedTab.Key.Equals("0")) //LG
                 {
                     //查询冷轧冷拔实绩合格支数的和LG
                     DataTable dtLG = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpColding.getLoadResult1", new object[] { uRow.Cells["HEAT_PLAN_NO"].Value.ToString() }, this.ob);
                     string pronum = "";
                     if (dtLG.Rows.Count > 0)
                     {
                         pronum = dtLG.Rows[0]["ACC_NUM"].ToString();
                     }
                     else
                     {
                         pronum = "0";
                     }
                     uRow.Cells["snum"].Value = Convert.ToString(int.Parse(dt2.Rows[0]["ACT_COUNT"].ToString()) - int.Parse(pronum));
                 }else if (ultraTabControl1.SelectedTab.Key.Equals("1"))//LB
                 {
                     //查询冷轧冷拔合格支数的和LB
                     DataTable dtLB = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpColding.getLoadResult2", new object[] { uRow.Cells["HEAT_PLAN_NO"].Value.ToString() }, this.ob);
                     string pronum = "";
                     if (dtLB.Rows.Count > 0)
                     {
                         pronum = dtLB.Rows[0]["ACC_NUM"].ToString();
                     }
                     else
                     {
                         pronum = "0";
                     }
                     uRow.Cells["snum"].Value = Convert.ToString(int.Parse(dt2.Rows[0]["ACT_COUNT"].ToString()) - int.Parse(pronum));
                 }else if (ultraTabControl1.SelectedTab.Key.Equals("2"))//LD
                 {
                     //查询冷轧冷拔合格支数的和LD
                     DataTable dtLD = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpColding.getLoadResult3", new object[] { uRow.Cells["HEAT_PLAN_NO"].Value.ToString() }, this.ob);
                     string pronum = "";
                     if (dtLD.Rows.Count > 0)
                     {
                         pronum = dtLD.Rows[0]["ACC_NUM"].ToString();
                     }
                     else
                     {
                         pronum = "0";
                     }
                     uRow.Cells["snum"].Value = Convert.ToString(int.Parse(dt2.Rows[0]["ACT_COUNT"].ToString()) - int.Parse(pronum));
                 }
                //管号队列查询
                DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryDbkPortVrp", new object[] { heat }, ob);
                GridHelper.CopyDataToDatatable(ref dt1, ref dataTable3, true);
            }
            foreach (UltraGridRow urg in ultraGrid3.Rows)
            {

                if (urg.Cells["MAT_STATUS"].Text.Equals("剔除"))
                {
                    urg.Cells["MAT_STATUS"].Appearance.ForeColor = Color.Red;
                }
            }
        }

        private void getUltraGrid1AfterRowActivate()
        {
            UltraGridRow row = ultraGrid1.ActiveRow;
            if (row != null)
            {
                string heatNo = row.Cells["HEAT_PLAN_NO"].Value.ToString();
                this.GetLoadResult(heatNo);
                craftPath = YdmBaseClass.getQueryCraftNo(row.Cells["CRAFT_FILE_NO"].Value.ToString(), row.Cells["CRAFT_SEQ"].Text.ToString(), this.ob);
            }
        }

        private void chkStarts_CheckedChanged(object sender, EventArgs e)
        {
            if (chkPlnNo.Checked) { txtRollBatchId.Enabled = true; } else { txtRollBatchId.Enabled = false; }
            if (chkJuNo.Checked) { txtZyBatchId.Enabled = true; } else { txtZyBatchId.Enabled = false; }
        }
        /// <summary>
        /// 根据计划号查询冷拔实绩
        /// </summary>
        /// <param name="planNo"></param>
        private void GetLoadResult(string heatNo)
        {
            //查询冷轧冷拔实绩
            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpColding.getLoadResult", new object[] { heatNo }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt, ref dtLoadRecord, true);//查询主表的内容要写下面的内容
            if (dt.Rows.Count <= 0)
            {
                //DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpColding.getColdResult", new object[] { "" }, this.ob);
                //GridHelper.CopyDataToDatatable(ref dt1, ref dtPipes, true);
                GetColdResult("");//如果是空就刷新
                VrpColdDrawnResultEntity result = new VrpColdDrawnResultEntity();
                result.LoadShift = UserInfo.GetUserOrder();
                result.LoadGroup = UserInfo.GetUserGroup();
                result.LoadUser = UserInfo.GetUserName();
                this.planExpanLGColdDrawn1.Value = result;
                this.planExpanLDColdDrawn1.Value = result;
                this.planExpanLBColdDrawn1.Value = result;
            }
        }

        /// <summary>
        /// 初始化控件
        /// </summary>
        private void initControl()
        {
            UltraGridRow uRow = this.ultraGrid1.ActiveRow;
            if (uRow != null)
            {
                string heat = uRow.Cells["HEAT_PLAN_NO"].Value.ToString();
                //查询管号队列合格的支、吨
                DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryDbkPortVrp1", new object[] { heat }, ob);
                string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
                VrpColdDrawnResultEntity result = new VrpColdDrawnResultEntity();
                result.LoadShift = UserInfo.GetUserOrder();
                result.LoadGroup = UserInfo.GetUserGroup();
                result.LoadUser = UserInfo.GetUserName();
                result.LoadTime = time;
                result.ProducerTime = time;
                result.FailNum = "";
                result.FailWt = "";
                result.ProNum = dt2.Rows[0]["ACT_COUNT"].ToString();
                result.ProWt = dt2.Rows[0]["ACT_WEIGHT"].ToString();
                result.AccNum = dt2.Rows[0]["ACT_COUNT"].ToString();
                result.AccWt = dt2.Rows[0]["ACT_WEIGHT"].ToString();
                this.planExpanLGColdDrawn1.Value = result;
                this.planExpanLBColdDrawn1.Value = result;
                this.planExpanLDColdDrawn1.Value = result;
            }
        }

       ///  <summary>
        ///  冷拔实绩保存
        /// </summary>
        private void DoSave()
        {
            int count = 0;
            ultraGrid2.UpdateData();
            UltraGridRow row = ultraGrid1.ActiveRow;
            if (row == null) return;
            string heatNo = row.Cells["HEAT_PLAN_NO"].Value.ToString();
            string groupNo = row.Cells["BATCH_GROUD_NO"].Value.ToString();
            //查询冷轧冷拔实绩
            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpColding.getLoadResult", new object[] { heatNo }, this.ob);
            if (dt.Rows.Count > 0)
            {
                if (dt.Rows[0]["STATION_STATUS"].ToString().Equals("生产完成"))
                {
                    MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作！");
                    return;
                }
            }
            if (ultraTabControl1.SelectedTab.Key.Equals("0")) //LG
            {
                if (this.planExpanLGColdDrawn1.ValidInput1())
                {
                    this.planExpanLGColdDrawn1.UpdateData();
                    VrpColdDrawnResultEntity result = this.planExpanLGColdDrawn1.Value;
                    result.HeatPlanNo = row.Cells["HEAT_PLAN_NO"].Value.ToString();
                    result.RollFacNo = "LG";
                    //if (result.ProNum.Equals("")||result.ProNum.Equals("0"))
                    //{
                    //    MessageUtil.ShowTips("字段不能为空或零");
                    //    return;
                    //}
                    if (result.FailNum == null || result.FailNum == "")
                    {
                        result.FailNum = "0";
                    }
                    if (result.FailWt == null || result.FailWt == "")
                    {
                        result.FailWt = "0";
                    }
                    if (result.AccNum == null || result.AccNum == "")
                    {
                        result.AccNum = "0";
                    }
                    //管号队列合格支，重量
                    int count1 = 0;
                    double weghit = 0;
                    DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpExpandResult.queryPortVrpResult", new Object[] { row.Cells["HEAT_PLAN_NO"].Value.ToString() }, ob);
                    if (dt1.Rows.Count > 0)
                    {
                        count1 = int.Parse(dt1.Rows[0]["ACT_COUNT"].ToString());
                        weghit = Double.Parse(dt1.Rows[0]["ACT_WEIGHT"].ToString());
                    }
                    if (int.Parse(result.AccNum) > count1)
                    {
                        MessageUtil.ShowTips("合格支数不能超过作业支数！");
                        return;
                    }
                    
                    ArrayList list = new ArrayList();
                    for (int i = 0; i < ultraGrid2.Rows.Count; i++)
                    {
                        UltraGridRow checkrow = ultraGrid2.Rows[i];
                        if (Convert.ToBoolean(checkrow.Cells["CHECK"].Text) == true)
                        {
                            count += 1;
                            VrpColdingDResult resultD = getRowData(checkrow);
                            list.Add(resultD);
                        }
                    }
                    if (count == 0)
                    {
                        /*if (MessageUtil.ShowYesNoAndQuestion("是否选择表检从表？") == DialogResult.Yes) return;*/
                       
                    }
                    if (result.ProNum.Equals("0"))
                    {
                        MessageUtil.ShowTips("作业支数是零，无法新增!！");
                        return;
                    }
                    //查询冷轧冷拔实绩合格支数的和LG
                    DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpColding.getLoadResult1", new object[] { row.Cells["HEAT_PLAN_NO"].Value.ToString() }, this.ob);
                    string pronum = "";
                    if (dt2.Rows.Count > 0)
                    {
                        pronum = dt2.Rows[0]["ACC_NUM"].ToString();
                    }
                    else
                    {
                        pronum = "0";
                    }
                    if (int.Parse(pronum) + int.Parse(result.ProNum) > count1)
                    {
                        MessageUtil.ShowTips("实绩合格支数和作业实绩支数的和超过管号对列合格支数，无法新增!！");
                        return;
                    }
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmVrpColding";
                    ccp.MethodName = "saveColdingResult";
                    ccp.ServerParams = new Object[] { result, list, SlGx, row.Cells["PLINE_CODE"].Value.ToString(),groupNo };
                    ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                    if (ccp.ReturnCode != -1)
                    {
                        MessageUtil.ShowTips(ccp.ReturnInfo);
                        if (ccp.ReturnInfo.Equals("新增成功！"))
                        {
                            QuerySinglePlan();
                            initControl();
                            
                        }
                    }
                }
            }
            else if (ultraTabControl1.SelectedTab.Key.Equals("1"))//LB
            {
                if (this.planExpanLBColdDrawn1.ValidInput1())
                {
                    this.planExpanLBColdDrawn1.UpdateData();
                    VrpColdDrawnResultEntity result = this.planExpanLBColdDrawn1.Value;
                    result.HeatPlanNo = row.Cells["HEAT_PLAN_NO"].Value.ToString();
                    result.RollFacNo = "LB";
                    //result.ProNum = Convert.ToDecimal(row.Cells["PRONUM"].Value);
                    //if (result.ProNum.Equals("")||result.ProNum.Equals("0"))
                    //{
                    //    MessageUtil.ShowTips("字段不能为空或零");
                    //    return;
                    //}
                    if (result.FailNum == null || result.FailNum == "")
                    {
                        result.FailNum = "0";
                    }
                    if (result.FailWt == null || result.FailWt == "")
                    {
                        result.FailWt = "0";
                    }
                    //管号队列合格支，重量
                    int count1 = 0;
                    double weghit = 0;
                    DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpExpandResult.queryPortVrpResult", new Object[] { row.Cells["HEAT_PLAN_NO"].Value.ToString() }, ob);
                    if (dt1.Rows.Count > 0)
                    {
                        count1 = int.Parse(dt1.Rows[0]["ACT_COUNT"].ToString());
                        weghit = Double.Parse(dt1.Rows[0]["ACT_WEIGHT"].ToString());
                    }
                    if (int.Parse(result.AccNum) > count1)
                    {
                        MessageUtil.ShowTips("合格支数不能超过作业支数！");
                        return;
                    }
                    ArrayList list = new ArrayList();
                    for (int i = 0; i < ultraGrid2.Rows.Count; i++)
                    {
                        UltraGridRow checkrow = ultraGrid2.Rows[i];
                        if (Convert.ToBoolean(checkrow.Cells["CHECK"].Value))
                        {
                            count += 1;
                            VrpColdingDResult resultD = getRowData(checkrow);
                            resultD.MResultNo = row.Cells["HEAT_PLAN_NO"].Value.ToString();
                            list.Add(resultD);
                        }
                    }
                    if (count == 0)
                    {
                      /*  if (MessageUtil.ShowYesNoAndQuestion("是否选择表检从表？") == DialogResult.Yes) return;*/
                    }
                    if (result.ProNum.Equals("0"))
                    {
                        MessageUtil.ShowTips("作业支数是零，无法新增!！");
                        return;
                    }
                    //查询冷轧冷拔合格支数的和LB
                    DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpColding.getLoadResult2", new object[] { row.Cells["HEAT_PLAN_NO"].Value.ToString() }, this.ob);
                    string pronum = "";
                    if (dt2.Rows.Count > 0)
                    {
                        pronum = dt2.Rows[0]["ACC_NUM"].ToString();
                    }
                    else
                    {
                        pronum = "0";
                    }
                    if (int.Parse(pronum) + int.Parse(result.ProNum) > count1)
                    {
                        MessageUtil.ShowTips("实绩合格支数和作业实绩支数的和超过管号对列合格支数，无法新增!！");
                        return;
                    }
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmVrpColding";
                    ccp.MethodName = "saveColdingResult";
                    ccp.ServerParams = new Object[] { result, list, SlGx, row.Cells["PLINE_CODE"].Value.ToString(),groupNo };
                    ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                    if (ccp.ReturnCode != -1)
                    {
                        MessageUtil.ShowTips(ccp.ReturnInfo);
                        if (ccp.ReturnInfo.Equals("新增成功！"))
                        {
                            QuerySinglePlan();
                            initControl();
                            
                        }
                    }
                }
            }
            else if (ultraTabControl1.SelectedTab.Key.Equals("2"))//LD
            {
                if (this.planExpanLDColdDrawn1.ValidInput1())
                {
                    this.planExpanLDColdDrawn1.UpdateData();
                    VrpColdDrawnResultEntity result = this.planExpanLDColdDrawn1.Value;
                    result.HeatPlanNo = row.Cells["HEAT_PLAN_NO"].Value.ToString();
                    result.RollFacNo = "LD";
                    //result.ProNum = Convert.ToDecimal(row.Cells["PRONUM"].Value);
                    //if (result.ProNum.Equals("")||result.ProNum.Equals("0"))
                    //{
                    //    MessageUtil.ShowTips("字段不能为空或零");
                    //    return;
                    //}
                    if (result.FailNum == null || result.FailNum == "")
                    {
                        result.FailNum = "0";
                    }
                    if (result.FailWt == null || result.FailWt == "")
                    {
                        result.FailWt = "0";
                    }
                    //管号队列合格支，重量
                    int count1 = 0;
                    double weghit = 0;
                    DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpExpandResult.queryPortVrpResult", new Object[] { row.Cells["HEAT_PLAN_NO"].Value.ToString() }, ob);
                    if (dt1.Rows.Count > 0)
                    {
                        count1 = int.Parse(dt1.Rows[0]["ACT_COUNT"].ToString());
                        weghit = Double.Parse(dt1.Rows[0]["ACT_WEIGHT"].ToString());
                    }
                    if (int.Parse(result.AccNum) > count1)
                    {
                        MessageUtil.ShowTips("合格支数不能超过作业支数！");
                        return;
                    }
                    ArrayList list = new ArrayList();
                    for (int i = 0; i < ultraGrid2.Rows.Count; i++)
                    {
                        UltraGridRow checkrow = ultraGrid2.Rows[i];
                        if (Convert.ToBoolean(checkrow.Cells["CHECK"].Value))
                        {
                            count += 1;
                            VrpColdingDResult resultD = getRowData(checkrow);
                            resultD.MResultNo = row.Cells["HEAT_PLAN_NO"].Value.ToString();
                            list.Add(resultD);
                        }
                    }
                    if (count == 0)
                    {
                       /* if (MessageUtil.ShowYesNoAndQuestion("是否选择表检从表？") == DialogResult.Yes) return;*/
                    }
                    if (result.ProNum.Equals("0"))
                    {
                        MessageUtil.ShowTips("作业支数是零，无法新增!！");
                        return;
                    }
                    //查询冷轧冷拔合格支数的和LD
                    DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpColding.getLoadResult3", new object[] { row.Cells["HEAT_PLAN_NO"].Value.ToString() }, this.ob);
                    string pronum = "";
                    if (dt2.Rows.Count > 0)
                    {
                        pronum = dt2.Rows[0]["ACC_NUM"].ToString();
                    }
                    else
                    {
                        pronum = "0";
                    }
                    if (int.Parse(pronum) + int.Parse(result.ProNum) > count1)
                    {
                        MessageUtil.ShowTips("实绩合格支数和作业实绩支数的和超过管号对列合格支数，无法新增!！");
                        return;
                    }
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmVrpColding";
                    ccp.MethodName = "saveColdingResult";
                    ccp.ServerParams = new Object[] { result, list, SlGx, row.Cells["PLINE_CODE"].Value.ToString(),groupNo };
                    ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                    if (ccp.ReturnCode != -1)
                    {
                        MessageUtil.ShowTips(ccp.ReturnInfo);
                        if (ccp.ReturnInfo.Equals("新增成功！"))
                        {
                            QuerySinglePlan();
                            initControl();
                            
                        }
                    }
                }
            }
            }
        
        
        public VrpColdingDResult getRowData(UltraGridRow checkrow)
        {
            VrpColdingDResult resultD = new VrpColdingDResult();
            resultD.ResultNo = checkrow.Cells["RESULT_NO"].Value.ToString().Trim();
            resultD.MResultNo = checkrow.Cells["M_RESULT_NO"].Value.ToString().Trim();
            resultD.TubeD1 = checkrow.Cells["TUBE_D1"].Value.ToString().Trim();
            resultD.TubeD2 = checkrow.Cells["TUBE_D2"].Value.ToString().Trim();
            resultD.TubeS1 = checkrow.Cells["TUBE_S1"].Value.ToString().Trim();
            resultD.TubeS2 = checkrow.Cells["TUBE_S2"].Value.ToString().Trim();
            resultD.TubeS3 = checkrow.Cells["TUBE_S3"].Value.ToString().Trim();
            resultD.TubeS4 = checkrow.Cells["TUBE_S4"].Value.ToString().Trim();
            resultD.EndD1 = checkrow.Cells["END_D1"].Value.ToString().Trim();
            resultD.EndD2 = checkrow.Cells["END_D2"].Value.ToString().Trim();
            resultD.EndS1 = checkrow.Cells["END_S1"].Value.ToString().Trim();
            resultD.EndS2 = checkrow.Cells["END_S2"].Value.ToString().Trim();
            resultD.EndS3 = checkrow.Cells["END_S3"].Value.ToString().Trim();
            resultD.EndS4 = checkrow.Cells["END_S4"].Value.ToString().Trim();
            resultD.ChkL = checkrow.Cells["CHK_L"].Value.ToString().Trim();
            resultD.CreateTime = checkrow.Cells["CREATE_TIME"].Value.ToString().Trim();
            resultD.CreateName = checkrow.Cells["CREATE_NAME"].Value.ToString().Trim();
            resultD.UpdateTime = checkrow.Cells["UPDATE_TIME"].Value.ToString().Trim();
            resultD.UpdateName = checkrow.Cells["UPDATE_NAME"].Value.ToString().Trim();
            return resultD;
        }

        //删除
        private void DoReturn()
        {
            UltraGridRow row = ultraGrid1.ActiveRow;
            UltraGridRow Rows = ultraGrid4.ActiveRow;           
            if (Rows == null) return;
            if (row == null) return;
            string heatNo = Rows.Cells["HEAT_PLAN_NO"].Value.ToString();
            int detCount = int.Parse(Rows.Cells["FAIL_NUM"].Value.ToString());
            //查询冷轧冷拔的实绩
            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpColding.getLoadResult", new object[] { heatNo }, this.ob);
            if (dt.Rows[0]["STATION_STATUS"].ToString().Equals("生产完成"))
            {
                MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作！");
                return;
            }
            string flag = "";
            int delCount = 0;
            //ArrayList list = new ArrayList();
            ArrayList list2 = new ArrayList();            
                    delCount += 1;
                    flag = "0";
                    ArrayList list1 = new ArrayList();
                    list1.Add(Rows.Cells["RESULT_NO"].Value.ToString());
                   // list.Add(list1);          
            //选择外观检测实绩
            if (delCount == 0)
            {
                foreach (UltraGridRow ugr1 in ultraGrid2.Rows)
                {
                    if (Convert.ToBoolean(ugr1.Cells["CHECK"].Text) == true)
                    {
                        flag = "1";
                        ArrayList list3 = new ArrayList();
                        list3.Add(ugr1.Cells["RESULT_NO"].Value.ToString());
                        list3.Add(ugr1.Cells["M_RESULT_NO"].Value.ToString());
                        list2.Add(list3);
                    }
                }
            }
            if (flag == "")
            {
                MessageUtil.ShowTips("请选择要删除的信息！");
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmVrpColding";
            ccp.MethodName = "returnColdingResult";
            ccp.ServerParams = new Object[] {list1,list2, row.Cells["HEAT_PLAN_NO"].Value.ToString(), row.Cells["PLINE_CODE"].Value.ToString(), SlGx, flag, detCount };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("删除成功！"))
                {
                    QuerySinglePlan();
                    initControl();
                }
            }
        }
       //修改
         //</summary>
        private void DoUpdate()
        {
            UltraGridRow row = ultraGrid1.ActiveRow;
            UltraGridRow urg = ultraGrid4.ActiveRow;
            if (urg == null) return;
            if (row == null) return;
            int count = 0;
            if (ultraTabControl1.SelectedTab.Key.Equals("0")) //LG
            {
                if (this.planExpanLGColdDrawn1.ValidInput1())
                {
                    this.planExpanLGColdDrawn1.UpdateData();
                    string heatNo = urg.Cells["HEAT_PLAN_NO"].Value.ToString();
                    //查询冷轧冷拔实绩
                    DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpColding.getLoadResult", new object[] { heatNo }, this.ob);
                    if (dt.Rows[0]["STATION_STATUS"].ToString().Equals("生产完成"))
                    {
                        MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作！");
                        return;
                    }



                    VrpColdDrawnResultEntity result = this.planExpanLGColdDrawn1.Value;
                    result.ResultNo = urg.Cells["RESULT_NO"].Value.ToString();
                    result.HeatPlanNo = row.Cells["HEAT_PLAN_NO"].Value.ToString();
                    result.PlineCode = row.Cells["PLINE_CODE"].Value.ToString();
                    result.RollFacNo = "LG";

                    if (result.FailNum == null || result.FailNum == "")
                    {
                        result.FailNum = "0";
                    }
                    if (result.FailWt == null || result.FailWt == "")
                    {
                        result.FailWt = "0";
                    }
                    //管号队列合格支，重量
                    int count1 = 0;
                    double weghit = 0;
                    DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpExpandResult.queryPortVrpResult", new Object[] { row.Cells["HEAT_PLAN_NO"].Value.ToString() }, ob);
                    if (dt1.Rows.Count > 0)
                    {
                        count1 = int.Parse(dt1.Rows[0]["ACT_COUNT"].ToString());
                    }
                    if (int.Parse(result.AccNum) > count1)
                    {
                        MessageUtil.ShowTips("合格支数不能超过作业支数！");
                        return;
                    }
                   
                    if (count == 0)
                    {
                        /* if (MessageUtil.ShowYesNoAndQuestion("是否选择表检从表？") == DialogResult.Yes) return;*/
                    }
                    if (result.ProNum.Equals("0"))
                    {
                        MessageUtil.ShowTips("作业支数是零，无法修改!！");
                        return;
                    }
                    //查询冷轧冷拔合格支数的和LD
                    DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpColding.getLoadResult3", new object[] { row.Cells["HEAT_PLAN_NO"].Value.ToString() }, this.ob);
                    string pronum = "";
                    if (dt2.Rows.Count > 0)
                    {
                        pronum = dt2.Rows[0]["ACC_NUM"].ToString();
                    }
                    else
                    {
                        pronum = "0";
                    }
                    if (int.Parse(pronum) + int.Parse(result.ProNum) - int.Parse(urg.Cells["PRO_NUM"].Value.ToString()) > count1)
                    {
                        MessageUtil.ShowTips("实绩合格支数和作业实绩支数的和超过管号对列合格支数，无法修改!！");
                        return;
                    }


                    ArrayList list = new ArrayList();
                    for (int i = 0; i < ultraGrid2.Rows.Count; i++)
                    {
                        UltraGridRow checkrow = ultraGrid2.Rows[i];
                        if (Convert.ToBoolean(checkrow.Cells["CHECK"].Text) == true)
                        {
                            count += 1;
                            VrpColdingDResult resultD = getRowData(checkrow);
                            resultD.ResultNo = checkrow.Cells["RESULT_NO"].Value.ToString();
                            resultD.MResultNo = checkrow.Cells["M_RESULT_NO"].Value.ToString();
                            list.Add(resultD);
                        }
                    }
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmVrpColding";
                    ccp.MethodName = "updateLGColdingResult";
                    ccp.ServerParams = new Object[] { result, list, urg.Cells["RESULT_NO"].Value.ToString(), row.Cells["HEAT_PLAN_NO"].Value.ToString(), SlGx };
                    ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                    if (ccp.ReturnCode != -1)
                    {
                        MessageUtil.ShowTips(ccp.ReturnInfo);
                        if (ccp.ReturnInfo.Equals("修改成功！")) {
                            QuerySinglePlan();
                            initControl();
                            
                        }
                    }
                }
            }
            else if (ultraTabControl1.SelectedTab.Key.Equals("1"))//LB
            {
                if (this.planExpanLBColdDrawn1.ValidInput1())
                {
                    this.planExpanLBColdDrawn1.UpdateData();
                    string heatNo = urg.Cells["HEAT_PLAN_NO"].Value.ToString();
                    //查询冷轧冷拔实绩
                    DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpColding.getLoadResult", new object[] { heatNo }, this.ob);
                    if (dt.Rows[0]["STATION_STATUS"].ToString().Equals("生产完成"))
                    {
                        MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作！");
                        return;
                    }
                    VrpColdDrawnResultEntity result = this.planExpanLBColdDrawn1.Value;
                    result.ResultNo = urg.Cells["RESULT_NO"].Value.ToString();
                    result.HeatPlanNo = row.Cells["HEAT_PLAN_NO"].Value.ToString();
                    result.PlineCode = row.Cells["PLINE_CODE"].Value.ToString();
                    result.RollFacNo = "LB";
                    ArrayList list = new ArrayList();
                    for (int i = 0; i < ultraGrid2.Rows.Count; i++)
                    {
                        UltraGridRow checkrow = ultraGrid2.Rows[i];
                        if (Convert.ToBoolean(checkrow.Cells["CHECK"].Text) == true)
                        {
                            count += 1;
                            VrpColdingDResult resultD = getRowData(checkrow);
                            resultD.ResultNo = checkrow.Cells["RESULT_NO"].Value.ToString();
                            resultD.MResultNo = checkrow.Cells["M_RESULT_NO"].Value.ToString();
                            list.Add(resultD);
                        }
                    }

                    if (result.FailNum == null || result.FailNum == "")
                    {
                        result.FailNum = "0";
                    }
                    if (result.FailWt == null || result.FailWt == "")
                    {
                        result.FailWt = "0";
                    }
                    //管号队列合格支，重量
                    int count1 = 0;
                    double weghit = 0;
                    DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpExpandResult.queryPortVrpResult", new Object[] { row.Cells["HEAT_PLAN_NO"].Value.ToString() }, ob);
                    if (dt1.Rows.Count > 0)
                    {
                        count1 = int.Parse(dt1.Rows[0]["ACT_COUNT"].ToString());
                        weghit = Double.Parse(dt1.Rows[0]["ACT_WEIGHT"].ToString());
                    }
                    if (int.Parse(result.AccNum) > count1)
                    {
                        MessageUtil.ShowTips("合格支数不能超过作业支数！");
                        return;
                    }
                  
                    if (count == 0)
                    {
                        /*  if (MessageUtil.ShowYesNoAndQuestion("是否选择表检从表？") == DialogResult.Yes) return;*/
                    }
                    if (result.ProNum.Equals("0"))
                    {
                        MessageUtil.ShowTips("作业支数是零，无法修改!！");
                        return;
                    }
                    //查询冷轧冷拔合格支数的和LB
                    DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpColding.getLoadResult2", new object[] { row.Cells["HEAT_PLAN_NO"].Value.ToString() }, this.ob);
                    string pronum = "";
                    if (dt2.Rows.Count > 0)
                    {
                        pronum = dt2.Rows[0]["ACC_NUM"].ToString();
                    }
                    else
                    {
                        pronum = "0";
                    }
                    if (int.Parse(pronum) + int.Parse(result.ProNum) - int.Parse(urg.Cells["PRO_NUM"].Value.ToString()) > count1)
                    {
                        MessageUtil.ShowTips("实绩合格支数和作业实绩支数的和超过管号对列合格支数，无法修改!！");
                        return;
                    }

                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmVrpColding";
                    ccp.MethodName = "updateLBColdingResult";
                    ccp.ServerParams = new Object[] { result, list, urg.Cells["RESULT_NO"].Value.ToString(), row.Cells["HEAT_PLAN_NO"].Value.ToString(), SlGx };
                    ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                    if (ccp.ReturnCode != -1)
                    {
                        MessageUtil.ShowTips(ccp.ReturnInfo);
                        if (ccp.ReturnInfo.Equals("修改成功！")) {
                            QuerySinglePlan();
                            initControl();
                            
                        }
                    }
                }
            }
            else if (ultraTabControl1.SelectedTab.Key.Equals("2"))
            {
                if (this.planExpanLDColdDrawn1.ValidInput1())
                {
                    this.planExpanLDColdDrawn1.UpdateData();
                    string heatNo = urg.Cells["HEAT_PLAN_NO"].Value.ToString();
                    //查询冷轧冷拔实绩
                    DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpColding.getLoadResult", new object[] { heatNo }, this.ob);
                    if (dt.Rows[0]["STATION_STATUS"].ToString().Equals("生产完成"))
                    {
                        MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作！");
                        return;
                    }
                    VrpColdDrawnResultEntity result = this.planExpanLDColdDrawn1.Value;
                    result.ResultNo = urg.Cells["RESULT_NO"].Value.ToString();
                    result.HeatPlanNo = row.Cells["HEAT_PLAN_NO"].Value.ToString();
                    result.PlineCode = row.Cells["PLINE_CODE"].Value.ToString();
                    result.RollFacNo = "LD";
                    ArrayList list = new ArrayList();
                    for (int i = 0; i < ultraGrid2.Rows.Count; i++)
                    {
                        UltraGridRow checkrow = ultraGrid2.Rows[i];

                        if (Convert.ToBoolean(checkrow.Cells["CHECK"].Text) == true)
                        {
                            count += 1;
                            VrpColdingDResult resultD = getRowData(checkrow);
                            resultD.ResultNo = checkrow.Cells["RESULT_NO"].Value.ToString();
                            resultD.MResultNo = checkrow.Cells["M_RESULT_NO"].Value.ToString();
                            list.Add(resultD);
                        }
                    }

                    if (result.FailNum == null || result.FailNum == "")
                    {
                        result.FailNum = "0";
                    }
                    if (result.FailWt == null || result.FailWt == "")
                    {
                        result.FailWt = "0";
                    }
                    //管号队列合格支，重量
                    int count1 = 0;
                    double weghit = 0;
                    DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpExpandResult.queryPortVrpResult", new Object[] { row.Cells["HEAT_PLAN_NO"].Value.ToString() }, ob);
                    if (dt1.Rows.Count > 0)
                    {
                        count1 = int.Parse(dt1.Rows[0]["ACT_COUNT"].ToString());
                        weghit = Double.Parse(dt1.Rows[0]["ACT_WEIGHT"].ToString());
                    }
                    if (int.Parse(result.AccNum) > count1)
                    {
                        MessageUtil.ShowTips("合格支数不能超过作业支数！");
                        return;
                    }
                 
                    if (count == 0)
                    {
                        /* if (MessageUtil.ShowYesNoAndQuestion("是否选择表检从表？") == DialogResult.Yes) return;*/
                    }
                    if (result.ProNum.Equals("0"))
                    {
                        MessageUtil.ShowTips("作业支数是零，无法修改!！");
                        return;
                    }
                    //查询冷轧冷拔合格支数的和LD
                    DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpColding.getLoadResult3", new object[] { row.Cells["HEAT_PLAN_NO"].Value.ToString() }, this.ob);
                    string pronum = "";
                    if (dt2.Rows.Count > 0)
                    {
                        pronum = dt2.Rows[0]["ACC_NUM"].ToString();
                    }
                    else
                    {
                        pronum = "0";
                    }
                    if (int.Parse(pronum) + int.Parse(result.ProNum) - int.Parse(urg.Cells["PRO_NUM"].Value.ToString()) > count1)
                    {
                        MessageUtil.ShowTips("实绩合格支数和作业实绩支数的和超过管号对列合格支数，无法修改！");
                        return;
                    }

                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmVrpColding";
                    ccp.MethodName = "updateLDColdingResult";
                    ccp.ServerParams = new Object[] { result, list, urg.Cells["RESULT_NO"].Value.ToString(), row.Cells["HEAT_PLAN_NO"].Value.ToString(), SlGx };
                    ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                    if (ccp.ReturnCode != -1)
                    {
                        MessageUtil.ShowTips(ccp.ReturnInfo);
                        if (ccp.ReturnInfo.Equals("修改成功！")) {
                            QuerySinglePlan();
                            initControl();
                            
                        }
                    }
                }
            }
        }
        private void FrmVrpLoading_Load(object sender, EventArgs e)
        {
            string code = "";
            //cmbDate.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 00:00:00"));
            //cmbEndDate.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 23:59:59"));
           // departm = UserInfo.GetDepartment();
           // plineCode = YdmBaseClass.GetPCode(departm, this.ob);//获取 用户 对应的产线
           
            //获取工序
           /* DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryGX", new object[] { code }, this.ob);
            if (dt2.Rows.Count > 0)
            {
                SlGx = dt2.Rows[0]["BASECODE"].ToString();
                name = dt2.Rows[0]["BASENAME"].ToString();
            }*/
            departm = UserInfo.GetDepartment();


            plineCodes = comm.GetPlineCode(this.ValidDataPurviewIds, "E", ob);
            if (ultraTabControl1.SelectedTab.Key.Equals("0"))
            {//选择LG实绩
                cold = "LG";
            }
            else
                if (ultraTabControl1.SelectedTab.Key.Equals("1"))
                {//选择LB实绩
                    cold = "LB";
                }
                else
                {//选择LD实绩
                    cold = "LD";
                }
            //在库号定义表里查询仓库代码
            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getStorageDep", new object[] { this.UserInfo.GetDeptid(), Core.Mes.Client.Comm.Server.ClsBaseInfo.GetDepartIdBySectionId(this.UserInfo.GetDeptid(), this.ob), "800202", "800304" }, this.ob);
            if (dt.Rows.Count > 0)
            {
                storageNo = dt.Rows[0]["STORAGE_NO"].ToString();
            }
            QuerySinglePlan();
        }

        private void ultraGrid4_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow urg = ultraGrid4.ActiveRow;
            if (urg == null) return;
            VrpColdDrawnResultEntity result = new VrpColdDrawnResultEntity();
            result.LoadShift = urg.Cells["LOAD_SHIFT"].Value.ToString();
            result.LoadGroup = urg.Cells["LOAD_GROUP"].Value.ToString();
            result.LoadUser = urg.Cells["UPDATE_NAME"].Value.ToString() == "" ? this.UserInfo.GetUserName() : urg.Cells["UPDATE_NAME"].Value.ToString();
            result.ProNum = urg.Cells["PRO_NUM"].Value.ToString();
            result.ProWt = urg.Cells["PRO_WT"].Value.ToString();
            result.LoadTime = urg.Cells["LOAD_TIME"].Value.ToString();
            result.Producer = urg.Cells["PRODUCER"].Value.ToString();
            result.ProducerTime = urg.Cells["PRODUCER_TIME"].Value.ToString();
            result.SizDimater = urg.Cells["SIZ_DIMATER"].Value.ToString();
            result.SizHeight = urg.Cells["SIZ_HEIGHT"].Value.ToString();
            result.ResultNo = urg.Cells["RESULT_NO"].Value.ToString();
            result.HeatPlanNo = urg.Cells["HEAT_PLAN_NO"].Value.ToString();
            result.ProPlanId = urg.Cells["PRO_PLAN_ID"].Value.ToString();
            result.GxPlanNo = urg.Cells["GX_PLAN_NO"].Value.ToString();
            result.PlineCode = urg.Cells["PLINE_CODE"].Value.ToString();
            result.PlineName = urg.Cells["PLINE_NAME"].Value.ToString();
            result.RollFacNo = urg.Cells["ROLL_FAC_NO"].Value.ToString();
            result.Dimater = urg.Cells["DIMATER"].Value.ToString();
            result.Height = urg.Cells["HEIGHT"].Value.ToString();
            result.TecTim = urg.Cells["TEC_TIM"].Value.ToString();
            result.WDimater = urg.Cells["W_DIMATER"].Value.ToString();
            result.WHeight = urg.Cells["W_HEIGHT"].Value.ToString();
            result.NDimater = urg.Cells["N_DIMATER"].Value.ToString();
            result.NHeight = urg.Cells["N_HEIGHT"].Value.ToString();
            result.RollSpeed = urg.Cells["ROLL_SPEED"].Value.ToString();
            result.ActLen = urg.Cells["ACT_LEN"].Value.ToString();
            result.SpeMandrel = urg.Cells["SPE_MANDREL"].Value.ToString();
            result.SpeRoll = urg.Cells["SPE_ROLL"].Value.ToString();
            result.RollGap = urg.Cells["ROLL_GAP"].Value.ToString();
            result.SendNum = urg.Cells["SEND_NUM"].Value.ToString();
            result.TrimNum = urg.Cells["TRIM_NUM"].Value.ToString();
            result.UpPole = urg.Cells["UP_POLE"].Value.ToString();
            result.PPole = urg.Cells["P_POLE"].Value.ToString();
            result.AccNum = urg.Cells["ACC_NUM"].Value.ToString();
            result.AccWt = urg.Cells["ACC_WT"].Value.ToString();
            result.AccLen = urg.Cells["ACC_LEN"].Value.ToString();
            result.FailNum = urg.Cells["FAIL_NUM"].Value.ToString();
            result.FailWt = urg.Cells["FAIL_WT"].Value.ToString();
            result.FailReason = urg.Cells["FAIL_REASON"].Value.ToString();
            result.OfflineNum = urg.Cells["OFFLINE_NUM"].Value.ToString();
            result.OfflineWt = urg.Cells["OFFLINE_WT"].Value.ToString();
            result.ReNum = urg.Cells["RE_NUM"].Value.ToString();
            result.ReWt = urg.Cells["RE_WT"].Value.ToString();
            result.Monitordemand = urg.Cells["MONITORDEMAND"].Value.ToString();
            result.IfMonitorDbk = urg.Cells["IF_MONITOR_DBK"].Value.ToString();
            result.PrdcrNo = urg.Cells["PRDCR_NO"].Value.ToString();
            result.LoadUser = urg.Cells["LOAD_USER"].Value.ToString();
            result.ColMode = urg.Cells["COL_MODE"].Value.ToString();
            result.CreateTime = urg.Cells["CREATE_TIME"].Value.ToString();
            result.UpdateTime = urg.Cells["UPDATE_TIME"].Value.ToString();
            if (urg.Cells["ROLL_FAC_NO"].Value.ToString().Equals("LG"))//显示LG上数据
            {
                this.ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[0];//选中LG跳转到LG界面
                this.planExpanLGColdDrawn1.Value = result;
            } 
            else if (urg.Cells["ROLL_FAC_NO"].Value.ToString().Equals("LB"))
            {
                this.ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[1];
                this.planExpanLBColdDrawn1.Value = result;
            }
            else if (urg.Cells["ROLL_FAC_NO"].Value.ToString().Equals("LD"))
            {
                this.ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[2];
                this.planExpanLDColdDrawn1.Value = result;
            }
            this.getUltraGrid4AfterRowActivate();
        }
        private void getUltraGrid4AfterRowActivate()
        {
            UltraGridRow row = ultraGrid4.ActiveRow;
            if (row != null)
            {
                string heatNo = row.Cells["RESULT_NO"].Value.ToString();
                this.GetColdResult(heatNo);
           }
        }
        private void GetColdResult(string heatNo)
        {
            //查询冷轧冷拔抽检实绩表
            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpColding.getColdResult", new object[] { heatNo }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt, ref dtPipes, true);//从表的数据不需要写下面的东西
            //if (dt.Rows.Count <= 0)
            //{
            //    DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpColding.getColdResult", new object[] { "" }, this.ob);
            //    GridHelper.CopyDataToDatatable(ref dt1, ref dataTable2, true);
            //    VrpColdDrawnResultEntity result = new VrpColdDrawnResultEntity();
            //    result.LoadShift = UserInfo.GetUserOrder();
            //    result.LoadGroup = UserInfo.GetUserGroup();
            //    result.LoadUser = UserInfo.GetUserName();
            //    this.planExpanLGColdDrawn1.Value = result;
            //    this.planExpanLBColdDrawn1.Value = result;
            //    this.planExpanLDColdDrawn1.Value = result;
            //}
        }

        private void BtOffline_Click(object sender, EventArgs e)
        {
            UltraGridRow row = ultraGrid1.ActiveRow;
            if (row == null) return;
            UltraGridRow row3 = ultraGrid3.ActiveRow;
            if (row3 == null) return;
          /*  UltraGridRow row2 = ultraGrid4.ActiveRow;
            if (row2 == null) return;*/
            string groupNo = row.Cells["BATCH_GROUD_NO"].Value.ToString();
            if (OfflineNum.Value.ToString().Equals("0"))
            {
                MessageUtil.ShowTips("请输入离线支数！");
                return;
            }
            if (txtReasion.Text.Trim().ToString().Equals(""))
            {
                MessageUtil.ShowTips("请输入离线原因！");
                return;
            }
            VrpColdDrawnResultEntity result = this.planExpanLDColdDrawn1.Value;
            string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            ArrayList list = new ArrayList();
            list.Add(row.Cells["HEAT_PLAN_NO"].Value.ToString());
            list.Add(SlGx);
            list.Add("");
            list.Add(this.UserInfo.GetUserName());
            list.Add(time);
            list.Add(this.UserInfo.GetUserOrder());
            list.Add(this.UserInfo.GetUserGroup());
            list.Add(OfflineNum.Value.ToString());
            list.Add(row3.Cells["JUDGE_STOVE_NO"].Value.ToString());
            list.Add(row3.Cells["BATCH_NO"].Value.ToString());
            list.Add(txtReasion.Text.ToString());
           // list.Add(row2.Cells["RESULT_NO"].Value.ToString());
            if (MessageUtil.ShowYesNoAndQuestion("是否离线？") == DialogResult.No) return;
            CoreClientParam ccp = new CoreClientParam();
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();

                ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmVrpColding";
                ccp.MethodName = "offLineExpandResult";
                ccp.ServerParams = new Object[] { result,list, row.Cells["PLINE_CODE"].Value.ToString(), storageNo,groupNo };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("离线成功！"))
                {
                    QuerySinglePlan();
                    txtReasion.Clear();
                }
            }
        }

        private void craftImg_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            UltraGridRow row = ultraGrid1.ActiveRow;
            string craftPath = YdmBaseClass.getQueryCraftNoDBK(row.Cells["CRAFT_FILE_NO"].Text.ToString(), row.Cells["CRAFT_SEQ"].Text.ToString(), ob);
            if (e.Button.Key.ToLower().Equals("select"))
            {
                FormFileDown down = new FormFileDown(ob, craftPath);
                down.CtrlFileDown1.Button3.Visible = false;
                down.ShowDialog();
            }
        }

        private void btnChangeLen_Click(object sender, EventArgs e)
        {
            UltraGridRow urg = ultraGrid1.ActiveRow;
            if (urg == null) return;
            FrmChangeLength FrmChangeLength = new FrmChangeLength(urg.Cells["HEAT_PLAN_NO"].Value.ToString(), ob);
            FrmChangeLength.ShowDialog();
            QuerySinglePlan();
        }
 }
}