MES_Client/TGMES/Core.StlMes.Client.PlnSaleOrd/PlanStove/Dlg/FrmMaterialChoose.cs

using Core.StlMes.Client.PlnSaleOrd.PlanStove.entity;
using CoreFS.CA06;
using Infragistics.Win.UltraWinGrid;
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 Core.StlMes.Client.PlnSaleOrd;
using Core.Mes.Client.Comm.Control;
using System.Text.RegularExpressions;
using Core.Mes.Client.Comm.Format;
using Core.Mes.Client.Comm.Tool;
using CoreFS.SA06;
using Core.Mes.Client.Comm.Server;

namespace Core.StlMes.Client.PlnSaleOrd.PlanStove.Dlg
{
    
    ///物料选择框
    public partial class FrmMaterialChoose : FrmBase
    {

        /// 接收从母窗体传过来的单元格事件，确定后会返还给母窗体
        /// </summary>
        public string m_InwlId="";
        private string m_ProPlanId="";
        private string m_GxPlanNo="";
        private string m_heatplanno="";
        private string m_loginusername="";
        private string m_StoveNo="";
        private string m_BatchNo="";
        private string m_BatchGroupNo="";
        private int m_OriginNum=0;//保存修改前作业计划量
        private bool Isupdate = false;
        private int m_OriginTotalnum = 0;//保存该组物料总量
        private double m_OriginTOtalWt = 0;
       
        private int m_MaxValidCount = 0;//保存能投入的最大量
        private string m_PlanStatus = "计划";


        private Dictionary<UltraGridRow, int> RowsCountsMapping = new Dictionary<UltraGridRow, int>();

        /// <summary>
        /// 物料确定的事件，可以将物料清单和母窗体的单元格事件发送给订阅者
        /// </summary>
        public event Action<List<Infragistics.Win.UltraWinGrid.UltraGridRow>> OnMaterialConfirm;
        public event Action OnDataChange;

        public FrmMaterialChoose(OpeBase ob, string InwlId, string ProPlanID, string GxPlanNo, string CustomerInfo, string StoveNo, string BatchNO,string BatchGroupNo, string HEAT_PLAN_NO, int outNum,string PlanStatus,string username)
        {
            InitializeComponent();
            this.ob = ob;
            this.CustomInfo = CustomerInfo;
            m_InwlId = InwlId;
            m_ProPlanId = ProPlanID;
            m_GxPlanNo = GxPlanNo;
            //this.OnMaterialConfirm += materialChoose_OnMaterialConfirm;
            Isupdate = true;
            m_StoveNo = StoveNo;
            m_BatchNo = BatchNO;
            m_BatchGroupNo = BatchGroupNo;
            m_OriginNum = outNum;
            m_heatplanno = HEAT_PLAN_NO;
            m_loginusername = username;
            m_PlanStatus = PlanStatus;
        }
      

        public FrmMaterialChoose(OpeBase ob,string InwlId,string ProPlanID,string GxPlanNo,string CustomerInfo,string username)
        {
            InitializeComponent();
            this.ob = ob;
            this.CustomInfo = CustomerInfo;
            m_InwlId = InwlId;
            m_loginusername = username;
            m_ProPlanId = ProPlanID;
            m_GxPlanNo = GxPlanNo;
            this.OnMaterialConfirm += materialChoose_OnMaterialConfirm;
        }

        /// <summary>
        /// 窗体的加载事件，初始化数据
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void FrmMaterialChoose_Load(object sender, EventArgs e)
        {
            Init_Comm();
            queryAll();
            
            if (CustomInfo == CustomInfoDef.DEFINE_CUSTOMER_ZG)
            {
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["BATCH_NO"].Hidden = true;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["BATCH_GROUD_NO"].Hidden = true;
            }

            if (Isupdate)
            {
                if (this.ultraGrid1.Rows.Count <= 0)
                {
                    MessageUtil.ShowTips("未找到对应的物料!");
                    this.Close();
                    return;
                }
                var row = this.ultraGrid1.Rows.First();
                try
                {
                    if (CustomInfo == CustomInfoDef.DEFINE_CUSTOMER_ZG)
                    {
                        var datasources = EntityHelper.GetData<PlnZyZgCEntity>(MethodDef.StoveBase.queryZyC, new Object[] { SqlIDDef.PlanLuZG.queryZYZGC, m_heatplanno }, this.ob);
                        foreach (PlnZyZgCEntity zyzgc in datasources)
                        {
                            var matchrow = this.ultraGrid1.Rows.FirstOrDefault(c => c.Cells["ACT_LEN"].Text.Trim().Equals(zyzgc.LengthGp.ToString().Trim()));
                            if (matchrow != null)
                            {
                                matchrow.Cells["USER_ACT_COUNT"].Value = zyzgc.InGpNum;
                                matchrow.Cells["Choose"].Value = true;
                                matchrow.Cells["USER_ACT_COUNT"].Appearance.BackColor = Color.Pink;
                            }
                        }
                        foreach (var matrow in this.ultraGrid1.Rows)
                        {
                            int count = 0;
                            try
                            {
                                count = Convert.ToInt32(matrow.Cells["USER_ACT_COUNT"].Value);
                            }
                            catch
                            {

                            }
                            RowsCountsMapping.Add(matrow, count);
                        }
                    }
                    else if(CustomInfo == CustomInfoDef.DEFINE_CUSTOMER_JG)
                    {

                    }
                    else
                    {
                        int num = Convert.ToInt32(row.Cells["ACT_COUNT"].Text);
                        double wt = Convert.ToDouble(row.Cells["ACT_WEIGHT"].Text);
                        double singlewt = wt / num;


                        m_OriginTotalnum = m_OriginNum + num;

                        m_OriginTOtalWt = CommHelper.GetSpecDecimalBit(singlewt * (m_OriginNum + num), 3);

                        SetTempData(m_OriginNum, CommHelper.GetSpecDecimalBit(singlewt * m_OriginNum, 3));
                    }
                    
                    
                }
                catch
                {

                }

            }

            this.ultraGrid2.DisplayLayout.Bands[0].Columns["GxProSeq"].Header.Caption = "生产顺序号";
            this.ultraGrid2.DisplayLayout.Bands[0].Columns["OrderSource"].Header.Caption = "主合同来源";
            this.ultraGrid2.DisplayLayout.Bands[0].Columns["ExeStatus"].Header.Caption = "执行状态";

            CommHelper.SetGridColNoEdit(this.ultraGrid1.DisplayLayout.Bands[0], new string[] { "Choose", "USER_ACT_COUNT" });
            CommHelper.SetColumnAutoFitSize1(this.ultraGrid1.DisplayLayout.Bands[0]);
            CommHelper.SetColumnAutoFitSize1(this.ultraGrid2.DisplayLayout.Bands[0]);


        }

        #region 控件事件
        /// <summary>
        /// toolbarmanager的tool单击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            switch (e.Tool.Key)
            {
                case "Confirm":
                    Confirm();
                    break;
                case "Cancel":
                    if (this.OnDataChange != null)
                    {
                        OnDataChange();
                    }

                    this.Close();
                    break;
            }
        }

        

        /// <summary>
        /// 物料选择确定事件的方法函数，第一个参数是弹出框中所选的作业计划的集合，第二个参数单击弹出弹出框时传入的本窗口grid1的单元格单击事件参数，只是为了定位最开始用的哪条订单记录
        /// </summary>
        /// <param name="obj"></param>
        /// <param name="e"></param>
        void materialChoose_OnMaterialConfirm(List<Infragistics.Win.UltraWinGrid.UltraGridRow> obj)
        {

            switch (CustomInfo)
            {
                case CustomInfoDef.DEFINE_CUSTOMER_DBK:

                    ZYResultProcessDBK(obj);
                    break;
                case CustomInfoDef.DEFINE_CUSTOMER_RCL:
                    ZYResultProcessRCL(obj);
                    break;
                case CustomInfoDef.DEFINE_CUSTOMER_JG:
                    ZYResultProcessJGX(obj);
                    break;
                case CustomInfoDef.DEFINE_CUSTOMER_ZG:
                    ZYResultProcessZG(obj);
                    break;
            }
            OnDataChange();
            //throw new NotImplementedException();
        }

        /// <summary>
        /// grid1的单元格单击的值改变的事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid1_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
        {
            this.ultraGrid1.UpdateData();
            if (e.Cell.Column.Key.Equals("USER_ACT_COUNT"))
            {
                if (!Regex.IsMatch(e.Cell.Value.ToString(), @"^-?[1-9]\d*$|^0$"))
                {
                    e.Cell.Value = 0;
                    return;
                }
            }
            if (e.Cell.Text != null)
            {
                if (e.Cell.Column.Key.Equals("USER_ACT_COUNT"))
                {

                    if (!e.Cell.Row.Cells["Choose"].Text.Equals("True"))
                    {
                        e.Cell.Value = e.Cell.OriginalValue;
                        return;
                    }
                    if (Convert.ToInt64(e.Cell.Value) != 0)
                    {
                        long user_act_count = Convert.ToInt64(e.Cell.Value);
                        long act_count = Convert.ToInt64(e.Cell.Row.Cells["ACT_COUNT"].Value);
                        long totalUserCount = 0;
                        foreach (var row in this.ultraGrid1.Rows.Where(c => c.Cells["Choose"].Text.Equals("True") && !c.Cells["USER_ACT_COUNT"].Text.Equals("0")))
                        {
                            int tmpUserActCount = 0;
                            try
                            {
                                tmpUserActCount = Convert.ToInt32(row.Cells["USER_ACT_COUNT"].Text);
                            }
                            catch
                            {

                            }
                            totalUserCount += tmpUserActCount;
                        }

                        if (user_act_count > act_count)
                        {
                            e.Cell.Value = e.Cell.OriginalValue;
                        }
                        else if (totalUserCount > m_MaxValidCount)
                        {
                            e.Cell.Value = e.Cell.OriginalValue;
                            MessageUtil.ShowWarning("本工序订单的投入量不能大于计划投入量与加投量的和，请检查输入！");
                        }
                        else
                        {
                            double act_weight = Convert.ToDouble(e.Cell.Row.Cells["ACT_WEIGHT"].Value);
                            double single_weight = act_weight / act_count;
                            e.Cell.Row.Cells["USER_ACT_WEIGHT"].Value = CommHelper.GetSpecDecimalBit(user_act_count * single_weight, 3);
                            e.Cell.Appearance.BackColor = System.Drawing.Color.Pink;
                            this.ultraGrid1.Refresh();
                        }
                    }
                    else
                    {
                        e.Cell.Row.Cells["USER_ACT_WEIGHT"].Value = 0;
                    }
                }
                else if (e.Cell.Column.Key.Equals("Choose"))
                {
                    if (e.Cell.Text.ToLower() == "true")
                    {
                        e.Cell.Row.Cells["USER_ACT_COUNT"].Activation = Activation.AllowEdit;
                        this.ultraGrid1.Refresh();
                        var rows = this.ultraGrid1.Rows.Where(c => c.Cells["Choose"].Text.ToLower() == "true");
                        foreach (UltraGridRow row in rows)
                        {
                            if (CustomInfo != CustomInfoDef.DEFINE_CUSTOMER_ZG)
                            {
                                if (row.Cells["JUDGE_STOVE_NO"].Value.ToString() != e.Cell.Row.Cells["JUDGE_STOVE_NO"].Value.ToString()
                                || row.Cells["BATCH_NO"].Text != e.Cell.Row.Cells["BATCH_NO"].Text
                                || row.Cells["BATCH_GROUD_NO"].Text != e.Cell.Row.Cells["BATCH_GROUD_NO"].Text)
                                {
                                    e.Cell.Value = false;
                                    Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("请选择炉号，组号，批号一致的物料");
                                    return;
                                }
                            }
                            else
                            {
                                if (row.Cells["JUDGE_STOVE_NO"].Value.ToString() != e.Cell.Row.Cells["JUDGE_STOVE_NO"].Value.ToString())
                                {
                                    e.Cell.Value = false;
                                    Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("请选择炉号一致的管坯");
                                    return;
                                }
                            }
                        }
                    }
                }
            }
        }

        #endregion

        #region 初始化
        private void Init_Comm()
        {
            switch(CustomInfo)
            {
                case CustomInfoDef.DEFINE_CUSTOMER_DBK: init_dbk(); break;
                case CustomInfoDef.DEFINE_CUSTOMER_JG: init_jgx(); break;
                case CustomInfoDef.DEFINE_CUSTOMER_RCL: init_rcl(); break;
                case CustomInfoDef.DEFINE_CUSTOMER_ZG: init_zg(); break;
            }
        }

        private void init_dbk()
        {
            this.ultraGrid2.DataSource = this.plnOrderDbkSEntityBindingSource;
            Core.Mes.Client.Comm.Tool.EntityHelper.ShowGridCaption<PlnOrderDbkSEntity>(this.ultraGrid2.DisplayLayout.Bands[0]);
            
            #region Excel2Code 2016/6/14 19:01:00
            setColumnPosition("PlineName", 0);
            setColumnPosition("GxProSeq", 1);
            setColumnPosition("ProPlanId", 3);
            setColumnPosition("GxPlanNo", 4);
            setColumnPosition("ExeStatus", 5);
            setColumnPosition("Mcount", 6);
            setColumnPosition("Mstatus", 7);
            setColumnPosition("IsRepairPln", 8);
            setColumnPosition("RepairType", 9);
            setColumnPosition("WeigthS", 10);
            setColumnPosition("NumS", 11);
            setColumnPosition("PlanTimeB", 12);
            setColumnPosition("PlanTimeE", 13);
            setColumnPosition("InwlDesc", 14);
            setColumnPosition("OutwlDesc", 15);
            setColumnPosition("OrderSource", 16);
            setColumnPosition("OrderNo", 17);
            setColumnPosition("OrderSeq", 18);
            setColumnPosition("DeliveryNo", 19);
            setColumnPosition("Outdiameter", 20);
            setColumnPosition("Wallthick", 21);
            setColumnPosition("OutdiameterIn", 22);
            setColumnPosition("WallthickIn", 23);
            setColumnPosition("Aimwallthick", 24);
            setColumnPosition("Aimoutdiameter", 25);
            setColumnPosition("Aimlength", 26);
            setColumnPosition("Lengthdisc", 27);
            setColumnPosition("LengthIn", 28);
            setColumnPosition("LengthmaxIn", 29);
            setColumnPosition("LengthminIn", 30);
            setColumnPosition("LenCuthead", 31);
            setColumnPosition("LenCutend", 32);
            setColumnPosition("InWeightS", 33);
            setColumnPosition("InNumS", 34);
            setColumnPosition("MatchWtIn", 35);
            setColumnPosition("MatchNumIn", 36);
            setColumnPosition("IfMonitorDbk", 37);
            setColumnPosition("MonitorPoint", 38);
            setColumnPosition("PrdcrNo", 39);
            setColumnPosition("ProMonth", 40);
            setColumnPosition("PreviousGx", 41);
            setColumnPosition("PrevGxplanId", 42);
            setColumnPosition("CraftFileNo", 43);
            setColumnPosition("CraftSeq", 44);
            setColumnPosition("CraftFileMan", 45);
            setColumnPosition("StationRoad", 46);
            setColumnPosition("BatchedWt", 47);
            setColumnPosition("BatchedNum", 48);
            setColumnPosition("PlanGroupId", 49);
            setColumnPosition("ProOrderNo", 50);
            setColumnPosition("PlnDivideId", 51);
            setColumnPosition("Finishweight", 52);
            setColumnPosition("Finishnum", 53);
            setColumnPosition("ReqBlId", 54);
            setColumnPosition("Isendgx", 55);
            setColumnPosition("IsPlanOk", 56);
            setColumnPosition("AddWtIn", 57);
            setColumnPosition("AddNumIn", 58);
            setColumnPosition("ZyBatchId", 59);
            setColumnPosition("Cic", 60);
            setColumnPosition("Pic", 61);
            setColumnPosition("Sic", 62);
            setColumnPosition("Dic", 63);
            setColumnPosition("Wic", 64);
            setColumnPosition("Gic", 65);
            #endregion
        }

        private void init_rcl()
        {
            this.ultraGrid2.DataSource = this.plnOrderRclSEntityBindingSource;
            Core.Mes.Client.Comm.Tool.EntityHelper.ShowGridCaption<PlnOrderRclSEntity>(this.ultraGrid2.DisplayLayout.Bands[0]);
            #region Excel2Code 2016/6/14 19:01:27
            setColumnPosition("PlineName", 0);
            setColumnPosition("GxProSeq", 1);
            setColumnPosition("ProPlanId", 3);
            setColumnPosition("GxPlanNo", 4);
            setColumnPosition("IsRepairPln", 5);
            setColumnPosition("Mcount", 6);
            setColumnPosition("Mstatus", 7);
            setColumnPosition("RepairType", 8);
            setColumnPosition("ExeStatus", 9);
            setColumnPosition("WeigthS", 10);
            setColumnPosition("NumS", 11);
            setColumnPosition("PlanUsetime", 12);
            setColumnPosition("PlanTimeB", 13);
            setColumnPosition("PlanTimeE", 14);
            setColumnPosition("InwlDesc", 15);
            setColumnPosition("OutwlDesc", 16);
            setColumnPosition("OrderSource", 17);
            setColumnPosition("OrderNo", 18);
            setColumnPosition("OrderSeq", 19);
            setColumnPosition("DeliveryNo", 20);
            setColumnPosition("Steelname", 21);
            setColumnPosition("Wallthick", 22);
            setColumnPosition("Outdiameter", 23);
            setColumnPosition("Aimlength", 24);
            setColumnPosition("Gradename", 25);
            setColumnPosition("LengthmaxIn", 26);
            setColumnPosition("LengthminIn", 27);
            setColumnPosition("IfMonitorRcl", 28);
            setColumnPosition("MonitorPoint", 29);
            setColumnPosition("PrdcrNo", 30);
            setColumnPosition("ProMonth", 31);
            setColumnPosition("PreviousGx", 32);
            setColumnPosition("PrevGxPlanId", 33);
            setColumnPosition("CraftFileNo", 34);
            setColumnPosition("CraftFileMan", 35);
            setColumnPosition("CraftSeq", 36);
            setColumnPosition("Lengthdisc", 37);
            setColumnPosition("ProOrderNo", 38);
            setColumnPosition("Finishweight", 39);
            setColumnPosition("LengthIn", 40);
            setColumnPosition("InWeightS", 41);
            setColumnPosition("InNumS", 42);
            setColumnPosition("PlanGroupId", 43);
            setColumnPosition("PlnDivideId", 44);
            setColumnPosition("MatchWtIn", 45);
            setColumnPosition("ReqBlId", 46);
            setColumnPosition("MatchNumIn", 47);
            setColumnPosition("StationRoad", 48);
            setColumnPosition("BatchedWt", 49);
            setColumnPosition("BatchedNum", 50);
            setColumnPosition("Finishnum", 51);
            setColumnPosition("ZyBatchId", 52);
            setColumnPosition("Cic", 53);
            setColumnPosition("Pic", 54);
            setColumnPosition("Sic", 55);
            setColumnPosition("Dic", 56);
            setColumnPosition("Wic", 57);
            setColumnPosition("Gic", 58);
            #endregion

        }

        private void init_jgx()
        {
            this.ultraGrid2.DataSource = this.plnOrderJgxSEntityBindingSource;
            #region Excel2Code 2016/6/14 19:01:47
            setColumnPosition("PlineName", 0);
            setColumnPosition("GxProSeq", 1);
            setColumnPosition("ProPlanId", 3);
            setColumnPosition("GxplanNo", 4);
            setColumnPosition("IsRepair", 5);
            setColumnPosition("Mcount", 6);
            setColumnPosition("Mstatus", 7);
            setColumnPosition("RepairType", 8);
            setColumnPosition("ExeStatus", 9);
            setColumnPosition("NumS", 10);
            setColumnPosition("PlanUsetime", 11);
            setColumnPosition("PlanTimeB", 12);
            setColumnPosition("PlanTimeE", 13);
            setColumnPosition("InwlDesc", 14);
            setColumnPosition("OutwlDesc", 15);
            setColumnPosition("OrderSource", 16);
            setColumnPosition("OrderNo", 17);
            setColumnPosition("OrderSeq", 18);
            setColumnPosition("DeliveryNo", 19);
            setColumnPosition("Steelname", 20);
            setColumnPosition("ModelDesc", 21);
            setColumnPosition("Outdiameter", 22);
            setColumnPosition("Wallthick", 23);
            setColumnPosition("Aimwallthick", 24);
            setColumnPosition("Lengthmax", 25);
            setColumnPosition("Lengthmin", 26);
            setColumnPosition("Aimlength", 27);
            setColumnPosition("Lengthdisc", 28);
            setColumnPosition("ShrtLenRato", 29);
            setColumnPosition("LongLenRato", 30);
            setColumnPosition("Shortest", 31);
            setColumnPosition("Longest", 32);
            setColumnPosition("ShrtStove", 33);
            setColumnPosition("SiglLen", 34);
            setColumnPosition("AvgLenMin", 35);
            setColumnPosition("DifrncLenMax", 36);
            setColumnPosition("EndlenSpecstd", 37);
            setColumnPosition("LengthmaxIn", 38);
            setColumnPosition("LengthminIn", 39);
            setColumnPosition("IfMonitorJgx", 40);
            setColumnPosition("MonitorPoint", 41);
            setColumnPosition("PrdcrNo", 42);
            setColumnPosition("ProMonth", 43);
            setColumnPosition("PreviousGx", 44);
            setColumnPosition("PrevGxplanId", 45);
            setColumnPosition("CraftFileNo", 46);
            setColumnPosition("CraftFileMan", 47);
            setColumnPosition("CraftSeq", 48);
            setColumnPosition("InWeghtS", 49);
            setColumnPosition("InNumS", 50);
            setColumnPosition("LengthIn", 51);
            setColumnPosition("StationRoad", 52);
            setColumnPosition("BatchedNum", 53);
            setColumnPosition("BatchedWt", 54);
            setColumnPosition("Finishweight", 55);
            setColumnPosition("Finishnum", 56);
            setColumnPosition("IsPlanOk", 57);
            setColumnPosition("ZyBatchId", 58);
            setColumnPosition("MatchWtIn", 59);
            setColumnPosition("PlanGroupId", 60);
            setColumnPosition("PlnDivideId", 61);
            setColumnPosition("ReqBlId", 62);
            setColumnPosition("MatchNumIn", 63);
            setColumnPosition("Cic", 64);
            setColumnPosition("Pic", 65);
            setColumnPosition("Sic", 66);
            setColumnPosition("Dic", 67);
            setColumnPosition("Wic", 68);
            setColumnPosition("Gic", 69);
            #endregion


            Core.Mes.Client.Comm.Tool.EntityHelper.ShowGridCaption<PlnOrderJgxSEntity>(this.ultraGrid2.DisplayLayout.Bands[0]);
        }

        private void init_zg()
        {
            this.ultraGrid2.DataSource = this.plnOrderZgSEntityBindingSource;
            #region Excel2Code 2016/6/14 19:02:19
            setColumnPosition("PlineName", 0);
            setColumnPosition("GxProSeq", 1);
            setColumnPosition("ProPlanId", 3);
            setColumnPosition("GxPlanNo", 4);
            setColumnPosition("RepairType", 5);
            setColumnPosition("Mcount", 6);
            setColumnPosition("Mstatus", 7);
            setColumnPosition("IsRepairPln", 8);
            setColumnPosition("ExeStatus", 9);
            setColumnPosition("NumS", 10);
            setColumnPosition("WeigthS", 11);
            setColumnPosition("PlanUsetime", 12);
            setColumnPosition("PlanTimeB", 13);
            setColumnPosition("PlanTimeE", 14);
            setColumnPosition("InwlDesc", 15);
            setColumnPosition("OutwlDesc", 16);
            setColumnPosition("OrderSource", 17);
            setColumnPosition("OrderNo", 18);
            setColumnPosition("OrderSeq", 19);
            setColumnPosition("DeliveryNo", 20);
            setColumnPosition("Steelname", 21);
            setColumnPosition("Gradename", 22);
            setColumnPosition("Outdiameter", 23);
            setColumnPosition("Wallthick", 24);
            setColumnPosition("Aimwallthick", 25);
            setColumnPosition("Aimlength", 26);
            setColumnPosition("RollLength", 27);
            setColumnPosition("DiameterMandrel", 28);
            setColumnPosition("DiameterGp", 29);
            setColumnPosition("Lengthdisc", 30);
            setColumnPosition("LenRollMax", 31);
            setColumnPosition("LenRollMin", 32);
            setColumnPosition("Aimoutdiameter", 33);
            setColumnPosition("LenGpSingle", 34);
            setColumnPosition("Isendgx", 35);
            setColumnPosition("IfMonitorZg", 36);
            setColumnPosition("LenCuthead", 37);
            setColumnPosition("LenCutend", 38);
            setColumnPosition("OutnumCut", 39);
            setColumnPosition("PrdcrNo", 40);
            setColumnPosition("CraftFileNo", 41);
            setColumnPosition("MonitorPoint", 42);
            setColumnPosition("CraftSeq", 43);
            setColumnPosition("PassName", 44);
            setColumnPosition("CraftFileMan", 45);
            setColumnPosition("ReqBlId", 46);
            setColumnPosition("InNumS", 47);
            setColumnPosition("InWeightS", 48);
            setColumnPosition("PlanGroupId", 49);
            setColumnPosition("ProMonth", 50);
            setColumnPosition("AddWtIn", 51);
            setColumnPosition("AddNumIn", 52);
            setColumnPosition("MatchWtIn", 53);
            setColumnPosition("StationRoad", 54);
            setColumnPosition("BatchedNum", 55);
            setColumnPosition("Finishweight", 56);
            setColumnPosition("Finishnum", 57);
            setColumnPosition("IsPlanOk", 58);
            setColumnPosition("GpreqIfOk", 59);
            setColumnPosition("GpreqId", 60);
            setColumnPosition("ZyBatchId", 61);
            setColumnPosition("PlnDivideId", 62);
            setColumnPosition("Cic", 63);
            setColumnPosition("Pic", 64);
            setColumnPosition("Sic", 65);
            setColumnPosition("Dic", 66);
            setColumnPosition("Wic", 67);
            setColumnPosition("Gic", 68);
            #endregion

            Core.Mes.Client.Comm.Tool.EntityHelper.ShowGridCaption<PlnOrderZgSEntity>(this.ultraGrid2.DisplayLayout.Bands[0]);
        }

        private void setColumnPosition(string key, int position)
        {
            CommHelper.SetColumnPosition(this.ultraGrid2.DisplayLayout.Bands[0], key, position);
        }

        private void SetTempData(int usercount, double userwt)
        {
            if (this.ultraGrid1.Rows.Count <= 0)
            {
                return;
            }
            UltraGridRow row = this.ultraGrid1.Rows.First();
            row.Cells["USER_ACT_COUNT"].Value = usercount;
            row.Cells["USER_ACT_WEIGHT"].Value = userwt;
            //             row.Cells["ACT_COUNT"].Value = totalcount;
            //             row.Cells["ACT_WEIGHT"].Value = totalwt;
            this.ultraGrid1.UpdateData();
        }

        #endregion

        #region 私有的算法
        /// <summary>
        /// 获取计划产出重量
        /// </summary>
        /// <param name="InNum"></param>
        /// <param name="WeigthS"></param>
        /// <param name="NumS"></param>
        /// <returns></returns>
        private static double GetOutWeight(Object InNum, Object WeigthS, Object NumS)
        {
            double result = 0;
            try
            {
                double SingleWeight = Convert.ToDouble(WeigthS) / Convert.ToDouble(NumS);
                result = Convert.ToDouble(InNum) * SingleWeight;
            }
            catch
            {
            }
            result = CommHelper.GetSpecDecimalBit(result, 3);
            return result;
        }

        #endregion

        #region 处理从MaterialChoose窗口事件返回的信息，并且整合订单时序表的信息和物料选择的信息形成作业计划表的记录

        private void ZYResultProcessDBK(List<Infragistics.Win.UltraWinGrid.UltraGridRow> obj)
        {
            int num = 0;
            double wt = 0;
            int matchnum = 0;
            double matchwt = 0;
            int LockFlag = -1;
            bool IsMatched = false;//原料是否利库
            var Row = this.ultraGrid2.Rows.First();
            PlnOrderDbkSEntity _orderdbk = (PlnOrderDbkSEntity)Row.ListObject;
            try
            {
                num = Convert.ToInt32(_orderdbk.BatchedNum);
                wt = Convert.ToDouble(_orderdbk.BatchedWt);
            }
            catch
            {
            }


            List<string> entitySqlidList = new List<string>();
            List<string> entityjsonStrings = new List<string>();
            List<string> entityClassNameList = new List<string>();
            List<string> normalSqlidList = new List<string>();
            List<List<Object>> normalParameterList = new List<List<Object>>();

            int nMaxProdIndex = DBComm.GetMaxProdIndex(CustomInfo, this.ob);
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow row in obj)
            {
                bool IsZyExist = false;
                DataSourceList<PlnZyDbkMEntity> zylist= null;
                zylist = EntityHelper.GetData<PlnZyDbkMEntity>(MethodDef.StoveBase.queryZy, new Object[] { SqlIDDef.PlanLuDBK.queryZYDBK, row.Cells["JUDGE_STOVE_NO"].Text, row.Cells["BATCH_NO"].Text, row.Cells["BATCH_GROUD_NO"].Text, _orderdbk.ProPlanId.ToString(), _orderdbk.GxPlanNo.ToString() }, this.ob);

                PlnZyDbkMEntity existZy = null;

                if (zylist.Count > 0)
                {
                    IsZyExist = true;
                    existZy = zylist.First();
                }


                try
                {
                    matchnum = Convert.ToInt32(_orderdbk.MatchNumIn);
                    matchwt = Convert.ToDouble(_orderdbk.MatchWtIn);
                }
                catch
                {

                }
                PlnZyDbkMEntity zydbk = new PlnZyDbkMEntity();
                zydbk.ZgBatchNo = row.Cells["BATCH_NO"].Value;
                zydbk.OrderSource = _orderdbk.OrderSource;
                zydbk.OrderNo = _orderdbk.OrderNo;
                zydbk.OrderSeq = _orderdbk.OrderSeq;
                zydbk.ReqBlId = _orderdbk.ReqBlId;
                zydbk.Gradename = row.Cells["GRADENAME"].Value;
                zydbk.Gradecode = row.Cells["GRADECODE"].Value;
                zydbk.Aimoutdiameter = _orderdbk.Aimoutdiameter;
                zydbk.Aimwallthick = _orderdbk.Aimwallthick;
                zydbk.Aimlength = _orderdbk.Aimlength;
                zydbk.OutdiameterIn = _orderdbk.OutdiameterIn;
                zydbk.WallthickIn = _orderdbk.WallthickIn;
                zydbk.LengthIn = _orderdbk.LengthIn;
                zydbk.LengthmaxIn = _orderdbk.LengthmaxIn;
                zydbk.LengthminIn = _orderdbk.LengthminIn;
                zydbk.LenCuthead = _orderdbk.LenCuthead;
                zydbk.LenCutend = _orderdbk.LenCutend;
                zydbk.InwlId = _orderdbk.InwlId;
                zydbk.InwlDesc = _orderdbk.InwlDesc;
                zydbk.InWt = row.Cells["USER_ACT_WEIGHT"].Value;
                zydbk.InNum = row.Cells["USER_ACT_COUNT"].Value;
                zydbk.IfWlMatched = 1;
                zydbk.OutwlId = _orderdbk.OutwlId;
                zydbk.OutwlDesc = _orderdbk.OutwlDesc;
                zydbk.OutWt = CommHelper.GetOutWeight(zydbk.InNum, _orderdbk.WeigthS, _orderdbk.NumS);
                zydbk.OutNum = zydbk.InNum;
                zydbk.IfMonitorDbk = _orderdbk.IfMonitorDbk;
                zydbk.PrdcrNo = _orderdbk.PrdcrNo;
                zydbk.MonitorPoint = _orderdbk.MonitorPoint;
                zydbk.CraftFileNo = _orderdbk.CraftFileNo;
                zydbk.CraftFileMan = _orderdbk.CraftFileMan;
                zydbk.CraftSeq = _orderdbk.CraftSeq;
                zydbk.StationRoad = _orderdbk.StationRoad;
                zydbk.Planstatus = 0;
                zydbk.InWtReal = "";
                zydbk.InNumReal = "";
                zydbk.OutWtReal = "";
                zydbk.OutNumReal = "";
                zydbk.CreateName = UserInfo.GetUserName();
                zydbk.CreateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm;ss");
                zydbk.UpdateName = "";
                zydbk.UpdateTime = "";
                zydbk.HeatPlanNo =DBComm.CreateHEAT_PLAN_NO(CustomInfo,this.ob);
                zydbk.ZyBatchId = _orderdbk.ZyBatchId;
                zydbk.ProdIndex = ++nMaxProdIndex;
                zydbk.ProPlanId = _orderdbk.ProPlanId;
                zydbk.GxPlanNo = _orderdbk.GxPlanNo;
                zydbk.PlineCode = _orderdbk.PlineCode;
                zydbk.PlineName = _orderdbk.PlineName;
                zydbk.ZgHeatPlanNo = row.Cells["HEAT_PLAN_NO"].Value;
                zydbk.HeatnoLast = row.Cells["JUDGE_STOVE_NO"].Value;
                zydbk.BatchGroudNo = row.Cells["BATCH_GROUD_NO"].Value;
                int outnum = 0;
                double outwt = 0;
                try
                {
                    outnum = Convert.ToInt32(zydbk.OutNum);
                    outwt = Convert.ToDouble(zydbk.OutWt);
                }
                catch
                {

                }
                if (!CommHelper.IsNullOrEmptry(row.Cells["PRO_ORDER_ID"].Text.Trim()))
                {
                    if (!_orderdbk.PrevGxplanId.ToString().Equals(row.Cells["PRO_ORDER_ID"].Text))//如果物料里的订单与本工序订单记录的前工序订单号不一致，需要先将物料脱单，然后判定状态改为利库
                    {
                        LockFlag = 1;
                        IsMatched = true;
                    }
                    else//如果物料里的订单与本工序订单的前工序订单号一致，则判定为普通匹配，只需要累加炉计划已排量
                    {
                        LockFlag = 0;
                    }
                }
                else //如果物料没有绑定订单，则判定为利库，需要累加投入利库量和炉计划已排量
                {
                    LockFlag = 1;
                    IsMatched = true;
                }
                if (LockFlag == 1)
                {
                    matchwt += outwt;
                    matchnum += outnum;
                    _orderdbk.MatchNumIn = matchnum;
                    _orderdbk.MatchWtIn = matchwt;
                }
                num += outnum;
                wt += outwt;

                if (IsZyExist)//如果已有作业计划，只需累加投入产出量，其余动作不变
                {
                    int oriOutNum = 0;
                    double oriOutWt = 0;
                    int oriInNum = 0;
                    double oriInWt = 0; 
                    try
                    {
                        oriOutNum = Convert.ToInt32(existZy.OutNum);
                        oriOutWt = Convert.ToDouble(existZy.OutWt);
                        oriInNum = Convert.ToInt32(existZy.InNum);
                        oriInWt = Convert.ToDouble(existZy.InWt);
                        oriOutNum +=outnum;
                        oriOutWt += outwt;
                        oriInNum += Convert.ToInt32(zydbk.InNum);
                        oriInWt += Convert.ToDouble(zydbk.InWt);
                        normalSqlidList.Add(SqlIDDef.PlanLuDBK.UpdateZYDBK_WT_NUM);
                        normalParameterList.Add(new List<Object>() { oriInWt,oriInNum,oriOutNum,oriOutWt,m_loginusername,existZy.HeatPlanNo});
                    }
                    catch
                    {

                    }
                }
                else
                {
                    entitySqlidList.Add(SqlIDDef.PlanLuDBK.insertZYDBK);
                    entityClassNameList.Add(ClassDef.PlnZyDbkMEntity);
                    entityjsonStrings.Add(JSONFormat.Format(zydbk));
                }
                //insertZYDBK(zydbk);

                normalSqlidList.Add(SqlIDDef.MaterialChoose.updateMaterial);
                normalParameterList.Add(new List<Object>() { zydbk.InwlId.ToString(), row.Cells["JUDGE_STOVE_NO"].Value, row.Cells["BATCH_NO"].Value, row.Cells["BATCH_GROUD_NO"].Value, "E", Convert.ToInt32(zydbk.InNum), "E", "镦拔扩", _orderdbk.ProPlanId.ToString(), _orderdbk.GxPlanNo.ToString(), LockFlag,m_loginusername });
                //UpdateMAT_ZC_M("E", "镦拔扩", zydbk.InwlId.ToString(), row.Cells["JUDGE_STOVE_NO"].Text, Convert.ToInt32(zydbk.InNum),_orderdbk.ProPlanId.ToString());

            }
            _orderdbk.BatchedNum = num;
            _orderdbk.BatchedWt = wt;

            normalSqlidList.Add(SqlIDDef.PlanLuDBK.UpdateOrderDBK_WT_NUM);
            normalParameterList.Add(new List<Object>() { wt, num, _orderdbk.ProPlanId, _orderdbk.GxPlanNo });
            if (IsMatched)
            {
                normalSqlidList.Add(SqlIDDef.PlanLuDBK.UpdateOrderDBK_MATCH_WT_NUM);
                normalParameterList.Add(new List<Object>() { _orderdbk.MatchWtIn, _orderdbk.MatchNumIn, _orderdbk.ProPlanId, _orderdbk.GxPlanNo });
            }

            //UpdateRows(_orderdbk);

            BaseEntityDAL.ExcuteTransaction(entitySqlidList, entityjsonStrings, entityClassNameList, normalSqlidList, normalParameterList, this.ob);
            queryAll();
        }

        private void ZYResultProcessRCL(List<Infragistics.Win.UltraWinGrid.UltraGridRow> obj)
        {
            int batchnum = 0;
            double batchwt = 0;
            int matchnum = 0;
            double matchwt = 0;
            int LockFlag = 0;
            bool isMatched = false;
            List<string> entitySqlidList = new List<string>();
            List<string> entityjsonStrings = new List<string>();
            List<string> entityClassNameList = new List<string>();
            List<string> normalSqlidList = new List<string>();
            List<List<Object>> normalParameterList = new List<List<Object>>();
            var Row = this.ultraGrid2.Rows.First();
            PlnOrderRclSEntity _orderrcl = (PlnOrderRclSEntity)Row.ListObject;
            try
            {
                batchnum = Convert.ToInt32(_orderrcl.BatchedNum);
                batchwt = Convert.ToDouble(_orderrcl.BatchedWt);
            }
            catch
            {
                batchnum = 0;
                batchwt = 0;
            }
            try
            {
                matchnum = Convert.ToInt32(_orderrcl.MatchNumIn);
                matchwt = Convert.ToDouble(_orderrcl.MatchWtIn);
            }
            catch
            {

            }
            int nMaxProdIndex = DBComm.GetMaxProdIndex(CustomInfo, this.ob);
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow row in obj)
            {
                bool IsZyExist = false;

                var zylist = EntityHelper.GetData<PlnZyDbkMEntity>(MethodDef.StoveBase.queryZy, new Object[] { SqlIDDef.PlanLuRCL.queryZyRCL, row.Cells["JUDGE_STOVE_NO"].Value, row.Cells["BATCH_NO"].Value, row.Cells["BATCH_GROUD_NO"].Value, _orderrcl.ProPlanId.ToString(), _orderrcl.GxPlanNo.ToString() }, this.ob);
                PlnZyDbkMEntity existZy = null;

                if (zylist.Count > 0)
                {
                    IsZyExist = true;
                    existZy = zylist.First();
                }
                PlnZyRclMEntity zyrcl = new PlnZyRclMEntity();
                zyrcl.HeatPlanNo = DBComm.CreateHEAT_PLAN_NO(CustomInfo, this.ob);
                zyrcl.ZyBatchId = _orderrcl.ZyBatchId;
                zyrcl.ProPlanId = _orderrcl.ProPlanId;
                zyrcl.GxPlanNo = _orderrcl.GxPlanNo;
                zyrcl.LastHeatPlanNo = _orderrcl.PreviousGx;
                zyrcl.HeatnoLast = row.Cells["JUDGE_STOVE_NO"].Value;
                zyrcl.LastBatchNo = row.Cells["BATCH_NO"].Value;
                zyrcl.BatchGroudNo = row.Cells["BATCH_GROUD_NO"].Value;
                zyrcl.PlineCode = _orderrcl.PlineCode;
                zyrcl.PlineName = _orderrcl.PlineName;
                zyrcl.OrderSource = _orderrcl.OrderSource;
                zyrcl.OrderNo = _orderrcl.OrderNo;
                zyrcl.OrderSeq = _orderrcl.OrderSeq;
                zyrcl.ReqBlId = _orderrcl.ReqBlId;
                zyrcl.Steelcode = _orderrcl.Steelcode;
                zyrcl.Steelname = _orderrcl.Steelname;
                zyrcl.Gradename = _orderrcl.Gradecode;
                zyrcl.Gradecode = _orderrcl.Gradename;
                zyrcl.Outdiameter = _orderrcl.Outdiameter;
                zyrcl.Wallthick = _orderrcl.Wallthick;
                zyrcl.Lengthdisc = _orderrcl.Lengthdisc;
                string maxlength = "";
                string minlength = "";
                DBComm.queryMaxMinLength(_orderrcl.OrdLnDlyPk.ToString(), ref maxlength, ref minlength,this.ob);
                zyrcl.CpLengthmax = maxlength;
                zyrcl.CpLengthmin = minlength;
                //                 zyrcl.CpLengthmin = row.Cells["ACT_LEN_MAX"].Text;
                //                 zyrcl.CpLengthmax = row.Cells["ACT_LEN_MIN"].Text;
                zyrcl.OutdiameterIn = row.Cells["ACT_DIMATER"].Value;
                zyrcl.WallthickIn = row.Cells["ACT_HEIGHT"].Value;
                zyrcl.LengthIn = row.Cells["ACT_LEN"].Value;
                zyrcl.LengthmaxIn = _orderrcl.LengthmaxIn;
                zyrcl.LengthminIn = _orderrcl.LengthminIn;
                zyrcl.LengthOut = _orderrcl.Aimlength;
                zyrcl.InwlId = _orderrcl.InwlId;
                zyrcl.InwlDesc = _orderrcl.InwlDesc;
                zyrcl.InNum = row.Cells["USER_ACT_COUNT"].Value;
                zyrcl.InWt = row.Cells["USER_ACT_WEIGHT"].Value;
                zyrcl.IfWlMatched = 1;
                zyrcl.ProdIndex =  ++nMaxProdIndex;
                zyrcl.OutwlId = _orderrcl.OutwlId;
                zyrcl.OutwlDesc = _orderrcl.OutwlDesc;
                zyrcl.OutWt = CommHelper.GetOutWeight(zyrcl.InNum, _orderrcl.WeigthS, _orderrcl.NumS);
                zyrcl.OutNum = zyrcl.InNum;
                zyrcl.IfMonitorRcl = _orderrcl.IfMonitorRcl;
                zyrcl.PrdcrNo = _orderrcl.PrdcrNo;
                zyrcl.MonitorPoint = _orderrcl.MonitorPoint;
                zyrcl.CraftFileNo = _orderrcl.CraftFileNo;
                zyrcl.CraftFileMan = _orderrcl.CraftFileMan;
                zyrcl.CraftSeq = _orderrcl.CraftSeq;
                zyrcl.StationRoad = _orderrcl.StationRoad;
                zyrcl.Planstatus = 0;
                zyrcl.CreateName = UserInfo.GetUserName();
                zyrcl.CreateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm;ss");
                zyrcl.UpdateName = "";
                zyrcl.UpdateTime = "";
                zyrcl.InWtReal = "";
                zyrcl.InNumReal = "";
                zyrcl.OutWtReal = "";
                zyrcl.OutNumReal = "";
                int outnum = 0;
                double outwt = 0;
                try
                {
                    outnum = Convert.ToInt32(zyrcl.OutNum);
                    outwt = Convert.ToDouble(zyrcl.OutWt);
                }
                catch
                {

                }
                if (!CommHelper.IsNullOrEmptry(row.Cells["PRO_ORDER_ID"].Text.Trim()))
                {
                    if (!_orderrcl.PrevGxplanId.ToString().Equals(row.Cells["PRO_ORDER_ID"].Text))
                    {
                        isMatched = true;
                    }
                }
                else
                {
                    isMatched = true;

                }

                batchnum += outnum;
                batchwt += outwt;

                if (isMatched)
                {
                    matchwt += outwt;
                    matchnum += outnum;
                }
                //
                /*                zyrcl.ProdIndex = GetMaxProdIndex() + 1;*/

                if (IsZyExist)//如果已有作业计划，只需累加投入产出量，其余动作不变
                {
                    int oriOutNum = 0;
                    double oriOutWt = 0;
                    int oriInNum = 0;
                    double oriInWt = 0;
                    try
                    {
                        oriOutNum = Convert.ToInt32(existZy.OutNum);
                        oriOutWt = Convert.ToDouble(existZy.OutWt);
                    }
                    catch
                    {

                    }
                    try
                    {
                        oriInNum = Convert.ToInt32(existZy.InNum);
                        oriInWt = Convert.ToDouble(existZy.InWt);
                    }
                    catch
                    {
                    }
                        
                    oriOutNum += outnum;
                    oriOutWt += outwt;

                    try
                    {
                        oriInNum += Convert.ToInt32(zyrcl.InNum);
                        oriInWt += Convert.ToDouble(zyrcl.InWt);
                    }
                    catch
                    {
                    }
                    normalSqlidList.Add(SqlIDDef.PlanLuRCL.UpdateZYRCL_WT_NUM);
                    normalParameterList.Add(new List<Object>() { oriInWt, oriInNum, oriOutNum, oriOutWt, m_loginusername, existZy.HeatPlanNo });

                }
                else
                {
                    entitySqlidList.Add(SqlIDDef.PlanLuRCL.AddNewRows);
                    entityjsonStrings.Add(JSONFormat.Format(zyrcl));
                    entityClassNameList.Add(ClassDef.PlnZyRclMEntity);
                }
                
                //InsertZYRCL(zyrcl);

                if (isMatched)
                {
                    LockFlag = 1;
                    

                }
                else
                {
                    LockFlag = 0;
                }

                normalSqlidList.Add(SqlIDDef.MaterialChoose.updateMaterial);
                normalParameterList.Add(new List<Object>() { zyrcl.InwlId.ToString(), row.Cells["JUDGE_STOVE_NO"].Value, row.Cells["BATCH_NO"].Value, row.Cells["BATCH_GROUD_NO"].Value, "F", Convert.ToInt32(zyrcl.InNum), "F", "热处理", _orderrcl.ProPlanId.ToString(), _orderrcl.GxPlanNo, LockFlag,m_loginusername });
                //UpdateMAT_ZC_M("F", "热处理", zyrcl.InwlId.ToString(), row.Cells["JUDGE_STOVE_NO"].Text,Convert.ToInt32(zyrcl.InNum),_orderrcl.ProPlanId.ToString());
            }

            if (isMatched)
            {
                normalSqlidList.Add(SqlIDDef.PlanLuRCL.UpdateOrderRCL_MATCH_WT_NUM);
                normalParameterList.Add(new List<Object>() { CommHelper.GetSpecDecimalBit(matchwt, 3), matchnum, _orderrcl.ProPlanId, _orderrcl.GxPlanNo });
            }
            

            normalSqlidList.Add(SqlIDDef.PlanLuRCL.UpdateRCLORDER_WT_NUM);
            normalParameterList.Add(new List<Object>() { CommHelper.GetSpecDecimalBit(batchwt, 3), batchnum, _orderrcl.ProPlanId, _orderrcl.GxPlanNo });

            BaseEntityDAL.ExcuteTransaction(entitySqlidList, entityjsonStrings, entityClassNameList, normalSqlidList, normalParameterList, this.ob);
            //UpdateOrderRCL_WT_NUM(_orderrcl);
            queryAll();

        }

        private void ZYResultProcessZG(List<Infragistics.Win.UltraWinGrid.UltraGridRow> obj)
        {
            int batchnum = 0;//炉计划已排支数
            double batchwt = 0;//炉计划已排重量

            int matchnum = 0;//投入利库支数
            double matchwt = 0;//投入利库重量

            bool isMatched = false;//判定是否利库（如果订单与物料管坯需求号不匹配，则判定为利库）

            int plnInNum = 0;//计划投入支数 = 每组的支数相加
            var Row = this.ultraGrid2.Rows.First();

            PlnOrderZgSEntity _orderzg = (PlnOrderZgSEntity)Row.ListObject;
            try
            {
                batchnum = Convert.ToInt32(_orderzg.BatchedNum);
                batchwt = Convert.ToDouble(_orderzg.BatchedWt);
            }
            catch
            {
            }
            try 
            {
                matchnum = Convert.ToInt32(_orderzg.MatchNumIn);
                matchwt = Convert.ToDouble(_orderzg.MatchWtIn);
            }
            catch
            {

            }
            int maxProdIndex = DBComm.GetMaxProdIndex(CustomInfo, this.ob);


            List<string> entitySqlidList = new List<string>();//执行插入的动作时，一般用entity
            List<string> entityjsonStrings = new List<string>();
            List<string> entityClassNameList = new List<string>();
            List<string> normalSqlidList = new List<string>();//执行更新或删除的动作时，一般用normal
            List<List<Object>> normalParameterList = new List<List<Object>>();

            PlnZyZgMEntity Mzyzg = new PlnZyZgMEntity();
            List<PlnZyZgCEntity> zyzgcList = new List<PlnZyZgCEntity>();

            #region 从工序订单表获取信息
            Mzyzg.HeatPlanNo = DBComm.CreateHEAT_PLAN_NO(CustomInfo, this.ob);
            Mzyzg.ZyBatchId = _orderzg.ZyBatchId;
            Mzyzg.ProdIndex =  ++ maxProdIndex;
            Mzyzg.ProPlanId = _orderzg.ProPlanId;
            Mzyzg.GxPlanNo = _orderzg.GxPlanNo;

            Mzyzg.GpreqId = _orderzg.GpreqId;
            Mzyzg.PlineCode = _orderzg.PlineCode;
            Mzyzg.PlineName = _orderzg.PlineName;
            Mzyzg.Isendgx = _orderzg.Isendgx;
            Mzyzg.OrderSource = _orderzg.OrderSource;
            Mzyzg.OrdLnDlyPk = _orderzg.OrdLnDlyPk;
            Mzyzg.OrderNo = _orderzg.OrderNo;
            Mzyzg.OrderSeq = _orderzg.OrderSeq;
            Mzyzg.DeliveryNo = _orderzg.DeliveryNo;
            Mzyzg.ReqBlId = _orderzg.ReqBlId;
            Mzyzg.Gradecode = _orderzg.Gradecode;
            Mzyzg.Gradename = _orderzg.Gradename;
            Mzyzg.LenRollMax = _orderzg.LenRollMax;
            Mzyzg.LenRollMin = _orderzg.LenRollMin;
            Mzyzg.Aimoutdiameter = _orderzg.Aimoutdiameter;
            Mzyzg.Aimwallthick = _orderzg.Aimwallthick;
            Mzyzg.Aimlength = _orderzg.Aimlength;
            Mzyzg.DiameterGp = _orderzg.DiameterGp;
            Mzyzg.LenGpSingle = _orderzg.LenGpSingle;
            Mzyzg.RollLength = _orderzg.RollLength;
            Mzyzg.LenCuthead = _orderzg.LenCuthead;
            Mzyzg.LenCutend = _orderzg.LenCutend;
            Mzyzg.OutnumCut = _orderzg.OutnumCut;
            Mzyzg.DiameterMandrel = _orderzg.DiameterMandrel;
            Mzyzg.PassCode = _orderzg.PassCode;
            Mzyzg.PassName = _orderzg.PassName;
            Mzyzg.InwlId = _orderzg.InwlId;
            Mzyzg.InwlDesc = _orderzg.InwlDesc;

            Mzyzg.IfWlMatched = 1;
            Mzyzg.OutwlId = _orderzg.OutwlId;
            Mzyzg.OutwlDesc = _orderzg.OutwlDesc;
            Mzyzg.IfMonitorZg = _orderzg.IfMonitorZg;
            Mzyzg.PrdcrNo = _orderzg.PrdcrNo;
            Mzyzg.MonitorPoint = _orderzg.MonitorPoint;
            Mzyzg.CraftFileNo = _orderzg.CraftFileNo;
            Mzyzg.CraftFileMan = _orderzg.CraftFileMan;
            Mzyzg.CraftSeq = _orderzg.CraftSeq;
            Mzyzg.StationRoad = _orderzg.StationRoad;
            Mzyzg.Planstatus = 0;
            Mzyzg.InWtReal = "";
            Mzyzg.InNumReal = "";
            Mzyzg.OutWtReal = "";
            Mzyzg.CreateName = UserInfo.GetUserName();
            Mzyzg.CreateTime = "";
            Mzyzg.UpdateName = "";
            Mzyzg.UpdateTime = "";

            #endregion

            #region 判断是否有同炉号同工序订单同排产序号的主表，如果有，则获取它的从表，缓存主从表
            UltraGridRow firstmatrow = null;
            if (obj.Count <= 0)
            {
                return;
            }
            else
            {
                firstmatrow = obj.First();
            }
            bool IsZyExist = false;
            var existzylist = EntityHelper.GetData<PlnZyZgMEntity>(MethodDef.StoveBase.queryZy, new Object[] { SqlIDDef.PlanLuZG.queryZYZGM, firstmatrow.Cells["JUDGE_STOVE_NO"].Text, "", "", _orderzg.ProPlanId.ToString(), _orderzg.GxPlanNo.ToString() }, this.ob);
            PlnZyZgMEntity existZy = null;
            DataSourceList<PlnZyZgCEntity> existzycList = null;
            if (existzylist.Count > 0)
            {
                IsZyExist = true;
                existZy = existzylist.First();
                existzycList = EntityHelper.GetData<PlnZyZgCEntity>(MethodDef.StoveBase.queryZyC, new Object[] { SqlIDDef.PlanLuZG.queryZYZGC, existZy.HeatPlanNo.ToString() }, this.ob);
            }
            #endregion

            #region 遍历物料编辑行，先假定每一行就是一行子表，加入List
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow row in obj)
            {
                
                int lockLiku = 0;
                Mzyzg.HeatnoLast = row.Cells["JUDGE_STOVE_NO"].Value;
                try
                {
                    plnInNum += Convert.ToInt32(row.Cells["USER_ACT_COUNT"].Value);
                }
                catch
                {
                }
                if (CommHelper.IsNullOrEmptry(row.Cells["PRO_ORDER_ID"].Text.Trim()))
                {
                    isMatched = true;
                    lockLiku = 1;
                }
                else
                {
                    if (!_orderzg.GpreqId.ToString().Equals(row.Cells["PRO_ORDER_ID"].Text.Trim()))
                    {
                        isMatched = true;
                        lockLiku = 1;
                    }
                    else
                    {
                        isMatched = false;
                        lockLiku = 0;
                    }
                }
                PlnZyZgCEntity Czyzg = new PlnZyZgCEntity();//先形成初步的
                Czyzg.InGpNumReal = "";
                Czyzg.InGpWtReal = "";
                Czyzg.SingleWtReal = "";
                Czyzg.SingleNumReal = "";
                Czyzg.CutzyStatus = 0;
                Czyzg.HeatPlanNo = Mzyzg.HeatPlanNo;
                Czyzg.ZyBatchId = Mzyzg.ZyBatchId;
                Czyzg.ProPlanId = _orderzg.ProPlanId;
                Czyzg.GxPlanNo = Mzyzg.GxPlanNo;
                Czyzg.PlineCode = Mzyzg.PlineCode;
                Czyzg.PlineName = Mzyzg.PlineName;
                Czyzg.GpreqId = Mzyzg.GpreqId;
                Czyzg.HeatnoLast = Mzyzg.HeatnoLast;
                Czyzg.LengthGp = row.Cells["ACT_LEN"].Value;
                Czyzg.LenGpSingle = Mzyzg.LenGpSingle;
                Czyzg.MultipleNum = CommHelper.GetMultipleNum(Czyzg.LengthGp, Czyzg.LenGpSingle);
                Czyzg.InGpNum = row.Cells["USER_ACT_COUNT"].Value;//计划投入支数由用户决定
                Czyzg.InGpWt = CommHelper.GetIN_GP_WT(row.Cells["ACT_WEIGHT"].Value, row.Cells["ACT_COUNT"].Value, Czyzg.InGpNum);//计划投入重量=计划投入支数*（物料总重量/物料总支数）
                Czyzg.CutSingleNum = Convert.ToInt32(Czyzg.InGpNum) * Convert.ToInt32(Czyzg.MultipleNum);//倍尺数*计划投入支数
                Czyzg.CutSingleWt = Convert.ToInt32(Czyzg.LenGpSingle) * PlanComm.GpweightOfmi(Convert.ToDouble(_orderzg.DiameterGp)) * Convert.ToInt32(Czyzg.CutSingleNum)*0.001;//单倍坯长*米单重*单倍坯支数
                zyzgcList.Add(Czyzg);
                normalSqlidList.Add(SqlIDDef.MaterialChoose.updateGP);
                normalParameterList.Add(new List<Object>() { Mzyzg.InwlId, Mzyzg.HeatnoLast, Czyzg.LengthGp, CommHelper.getProcessCode(CustomInfo), Czyzg.InGpNum, CommHelper.getProcessCode(CustomInfo), CommHelper.getProcessDesc(CustomInfo), _orderzg.ProPlanId, _orderzg.GxPlanNo, m_loginusername,lockLiku });
            }
            #endregion

            #region 根据管坯长度进行分组，每一组代表一行子表行，如果发现已经存在该炉，订单，排产序号的炉计划，并且该炉计划里已有该管坯长度的子表行，则执行累加
            var grouplst = zyzgcList.GroupBy(c => c.LengthGp);//根据管坯长度给所选的物料分组
            //var grouplst = from n in zyzgcList group n by n.MultipleNum into g select g;  
            int totalCutSingleNum = 0;
            double totalCutSingleWt = 0;
            int GpCutNo = 0;//滚皮锯切分组号
            if (IsZyExist)
            {
                GpCutNo = existzycList.Count;
            }
            foreach (var info in grouplst)//遍历组
            {
                PlnZyZgCEntity zyzgc = new PlnZyZgCEntity();
                int InGpNum = 0;//本组投入管坯总和
                double InGpWt = 0;
                int cutSingleNum = 0;//本组单倍坯支数总和，该组单倍坯支数 =  管坯投入支数*倍尺数
                double cutSingleWt = 0;
                
                foreach (var objzgc in info)//遍历组成员
                {
                    zyzgc.HeatPlanNo = objzgc.HeatPlanNo;
                    zyzgc.ZyBatchId = objzgc.ZyBatchId;
                    zyzgc.ProPlanId = objzgc.ProPlanId;
                    zyzgc.GxPlanNo = objzgc.GxPlanNo;
                    zyzgc.PlineCode = objzgc.PlineCode;
                    zyzgc.PlineName = objzgc.PlineName;
                    zyzgc.GpreqId = objzgc.GpreqId;
                    zyzgc.HeatnoLast = objzgc.HeatnoLast;
                    zyzgc.LengthGp = objzgc.LengthGp;
                    zyzgc.LenGpSingle = objzgc.LenGpSingle;
                    zyzgc.MultipleNum = objzgc.MultipleNum;
                    try
                    {
                        InGpNum += Convert.ToInt32(objzgc.InGpNum);
                        InGpWt +=Convert.ToDouble(objzgc.InGpWt);
                    }
                    catch
                    {
                    }
                    try
                    {
                        cutSingleNum += Convert.ToInt32(objzgc.CutSingleNum);
                        cutSingleWt += Convert.ToDouble(objzgc.CutSingleWt);
                    }
                    catch
                    {
                    }
                }
                
                zyzgc.InGpNumReal = "";
                zyzgc.InGpWtReal = "";
                zyzgc.SingleWtReal = "";
                zyzgc.SingleNumReal = "";
                zyzgc.CutzyStatus = 0;
                //逐组更新物料
                totalCutSingleNum += cutSingleNum;
                totalCutSingleWt += cutSingleWt;
                zyzgc.CutSingleWt =CommHelper.GetSpecDecimalBit(cutSingleWt,3);
                zyzgc.CutSingleNum = cutSingleNum;
                zyzgc.InGpNum = InGpNum;
                zyzgc.InGpWt = CommHelper.GetSpecDecimalBit(InGpWt,3);
                
                if (IsZyExist)
                {
                    var existzyc = existzycList.FirstOrDefault(c=>c.LengthGp.ToString().Equals(zyzgc.LengthGp.ToString()));
                    if (existzyc != null)
                    {
                        int oriCutSingleNum = 0;
                        double oriCutSingleWt = 0;
                        int oriInGpNum = 0;
                        double oriInGpWt = 0;
                        try
                        {
                            oriCutSingleNum = Convert.ToInt32(existzyc.CutSingleNum);
                            oriCutSingleWt = Convert.ToDouble(existzyc.CutSingleWt);
                        }
                        catch
                        {
                        }
                        try
                        {
                            oriInGpNum = Convert.ToInt32(existzyc.InGpNum);
                            oriInGpWt = Convert.ToDouble(existzyc.InGpWt);
                        }
                        catch
                        {
                        }
                        //累加子表行计划单倍坯量和计划投入量
                        existzyc.CutSingleNum = oriCutSingleNum + cutSingleNum;
                        existzyc.CutSingleWt =CommHelper.GetSpecDecimalBit(oriCutSingleWt+cutSingleWt,3);
                        existzyc.InGpNum =oriInGpNum + InGpNum;
                        existzyc.InGpWt =CommHelper.GetSpecDecimalBit(oriInGpWt + InGpWt,3);

                        //更新子表行计划单倍坯量和计划投入量
                        normalSqlidList.Add(SqlIDDef.PlanLuZG.UpdateZYZGC_GPWT_GPNUM);
                        normalParameterList.Add(new List<Object>() { existzyc.CutSingleNum,existzyc.CutSingleWt,existzyc.InGpNum,existzyc.InGpWt,existzyc.HeatPlanNo,existzyc.GpCutNo});
                    }
                    else//如果没有找到管坯长度一致的子表行，则新增子表行
                    {
                        ++GpCutNo;
                        zyzgc.GpCutNo = GpCutNo;
                        zyzgc.HeatPlanNo = existZy.HeatPlanNo;
                        entitySqlidList.Add(SqlIDDef.PlanLuZG.insertZYZGC);
                        entityClassNameList.Add(ClassDef.PlnZyZgCEntity);
                        entityjsonStrings.Add(JSONFormat.Format(zyzgc));
                    }
                }
                else//如果没有找到主表，则新增子表行
                {
                    ++GpCutNo;
                    zyzgc.GpCutNo = GpCutNo;
                    zyzgc.HeatPlanNo = Mzyzg.HeatPlanNo;
                    entitySqlidList.Add(SqlIDDef.PlanLuZG.insertZYZGC);
                    entityClassNameList.Add(ClassDef.PlnZyZgCEntity);
                    entityjsonStrings.Add(JSONFormat.Format(zyzgc));
                }
            }
            #endregion

            #region 累加所有所选物料的单倍坯量，产出量，以及投入管坯量，如果存在该炉，订单，排产序号的作业计划，则执行累加，否则新增作业计划
            Mzyzg.CutSingleNum = totalCutSingleNum;
            Mzyzg.CutSingleWt = CommHelper.GetSpecDecimalBit(totalCutSingleWt,3);//各组单倍坯重量总和
            Mzyzg.PlanGpNum = plnInNum;
            int totaloutNum = totalCutSingleNum * Convert.ToInt32(_orderzg.OutnumCut);
            Double totaloutWt = CommHelper.GetSpecDecimalBit( totaloutNum * PlanComm.WeightOfMi(Convert.ToDouble(_orderzg.Aimoutdiameter),Convert.ToDouble(_orderzg.Aimwallthick)) * Convert.ToDouble(_orderzg.Aimlength),3 );//计划产出重量= 计划产出支数*管米单重*工序目标长度
            Mzyzg.OutNum = totaloutNum;//单倍坯总和*分切数
            Mzyzg.OutWt = totaloutWt;
            if (IsZyExist)
            {
                int oriCutSingleNum =0;
                double oriCutSingleWt = 0;
                int oriOutNum = 0;
                double oriOutWt = 0;
                int oriInGpNum=0;
                try
                {
                    oriCutSingleNum = Convert.ToInt32(existZy.CutSingleNum);
                    oriCutSingleWt = Convert.ToDouble(existZy.CutSingleWt);
                }
                catch
                {
                }
                try
                {
                    oriOutNum = Convert.ToInt32(existZy.OutNum);
                    oriOutWt = Convert.ToDouble(existZy.OutWt);
                }
                catch
                {
                }
                try
                {
                    oriInGpNum =Convert.ToInt32(existZy.PlanGpNum);
                }
                catch
                {
                }
                //累加单倍坯量，计划产出量，以及计划投入管坯支数
                existZy.CutSingleNum = oriCutSingleNum + totalCutSingleNum;
                existZy.CutSingleWt = oriCutSingleWt + CommHelper.GetSpecDecimalBit(totalCutSingleWt, 3);
                existZy.OutNum =oriOutNum + totaloutNum;
                existZy.OutWt = oriOutWt + totaloutWt;
                existZy.PlanGpNum = oriInGpNum + plnInNum;

                //更新已经存在的主表行的单倍坯量，计划产出量，以及计划投入管坯支数
                normalSqlidList.Add(SqlIDDef.PlanLuZG.UpdateZYZG_WT_NUM);
                normalParameterList.Add(new List<Object>() { existZy.CutSingleNum, existZy.CutSingleWt, existZy.OutNum, existZy.OutWt, m_loginusername,existZy.PlanGpNum,existZy.HeatPlanNo });

            }
            else
            {
                entitySqlidList.Add(SqlIDDef.PlanLuZG.insertZYZGM);
                entityClassNameList.Add(ClassDef.PlnZyZgMEntity);
                entityjsonStrings.Add(JSONFormat.Format(Mzyzg));
            }
            #endregion


            #region 累加炉计划已排量和投入利库量
            int outnum = 0;
            double outwt = 0;
            try
            {
                outnum = Convert.ToInt32(Mzyzg.OutNum);
                outwt = Convert.ToDouble(Mzyzg.OutWt);
            }
            catch
            {
            }
            batchnum += outnum;
            batchwt += outwt;
            if (isMatched)
            {
                matchnum += outnum;
                matchwt += outwt;
                normalSqlidList.Add(SqlIDDef.PlanLuZG.UpdateOrderZG_MATCH_WT_NUM);
                normalParameterList.Add(new List<Object>() {matchwt,matchnum,_orderzg.ProPlanId,_orderzg.GxPlanNo });
            }
            else
            {
            }
            _orderzg.BatchedNum = batchnum;
            _orderzg.BatchedWt = batchwt;

            normalSqlidList.Add(SqlIDDef.PlanLuZG.UpdateOrderZG_WT_NUM);
            normalParameterList.Add(new List<Object>() { batchwt, batchnum, _orderzg.ProPlanId, _orderzg.GxPlanNo });

            BaseEntityDAL.ExcuteTransaction(entitySqlidList, entityjsonStrings, entityClassNameList, normalSqlidList, normalParameterList, this.ob);
            #endregion

            queryAll();
        }

        private void ZYResultProcessJGX(List<Infragistics.Win.UltraWinGrid.UltraGridRow> obj)
        {
            int batchnum = 0;
            double batchwt = 0;
            int lockLiku = -1;
            int matchnum = 0;
            double matchwt = 0;
            bool isMatched = false;
            List<string> entitySqlidList = new List<string>();
            List<string> entityjsonStrings = new List<string>();
            List<string> entityClassNameList = new List<string>();
            List<string> normalSqlidList = new List<string>();
            List<List<Object>> normalParameterList = new List<List<Object>>();
            var Row = this.ultraGrid2.Rows.First();
            PlnOrderJgxSEntity _orderjgx = (PlnOrderJgxSEntity)Row.ListObject;
            try
            {
                batchnum = Convert.ToInt32(_orderjgx.BatchedNum);
                batchwt = Convert.ToDouble(_orderjgx.BatchedWt);
            }
            catch
            {
                batchnum = 0;
                batchwt = 0;
            }

            try
            {
                matchnum = Convert.ToInt32(_orderjgx.MatchNumIn);
                matchwt = Convert.ToDouble(_orderjgx.MatchWtIn);
            }
            catch
            {}
            int nMaxProdIndex = DBComm.GetMaxProdIndex(CustomInfo, this.ob);
            bool IsZyExist = false;
            var firstmatrow = obj.First();
            var zylist = EntityHelper.GetData<PlnZyDbkMEntity>(MethodDef.StoveBase.queryZy, new Object[] { SqlIDDef.PlanLuJGX.queryZYJGXM, firstmatrow.Cells["JUDGE_STOVE_NO"].Value, firstmatrow.Cells["BATCH_NO"].Value, firstmatrow.Cells["BATCH_GROUD_NO"].Value, _orderjgx.ProPlanId.ToString(), _orderjgx.GxPlanNo.ToString() }, this.ob);
            PlnZyDbkMEntity existZy = null;

            if (zylist.Count > 0)
            {
                IsZyExist = true;
                existZy = zylist.First();
            }

            PlnZyJgxMEntity mzyjgx = new PlnZyJgxMEntity();
            mzyjgx.HeatPlanNo = DBComm.CreateHEAT_PLAN_NO(CustomInfo, this.ob);
            mzyjgx.ZyBatchId = _orderjgx.ZyBatchId;
            mzyjgx.ProdIndex = ++nMaxProdIndex;
            mzyjgx.ProPlanId = _orderjgx.ProPlanId;
            mzyjgx.GxPlanNo = _orderjgx.GxPlanNo;
            mzyjgx.GxNameLast = _orderjgx.PreviousGx;
            mzyjgx.LastHeatPlanNo = _orderjgx.PrevGxplanId;
            mzyjgx.HeatnoLast = firstmatrow.Cells["JUDGE_STOVE_NO"].Value;
            mzyjgx.LastBatchNo = firstmatrow.Cells["BATCH_NO"].Value;
            mzyjgx.BatchGroudNo = firstmatrow.Cells["BATCH_GROUD_NO"].Value;
            mzyjgx.PlineCode = _orderjgx.PlineCode;
            mzyjgx.PlineName = _orderjgx.PlineName;
            mzyjgx.OrderSource = _orderjgx.OrderSource;
            mzyjgx.OrdLnDlyPk = _orderjgx.OrdLnDlyPk;
            mzyjgx.OrderNo = _orderjgx.OrderNo;
            mzyjgx.OrderSeq = _orderjgx.OrderSeq;
            mzyjgx.DeliveryNo = _orderjgx.DeliveryNo;
            mzyjgx.ReqBlId = _orderjgx.ReqBlId;
            mzyjgx.Steelcode = _orderjgx.Steelcode;
            mzyjgx.Steelname = _orderjgx.Steelname;
            mzyjgx.Outdiameter = _orderjgx.Outdiameter;
            mzyjgx.Wallthick = _orderjgx.Wallthick;
            mzyjgx.Lengthmax = _orderjgx.Lengthmax;
            mzyjgx.Lengthmin = _orderjgx.Lengthmin;
            mzyjgx.Lengthdisc = _orderjgx.Lengthdisc;
            mzyjgx.Aimwallthick = _orderjgx.Aimwallthick;
            mzyjgx.Aimlength = _orderjgx.Aimlength;
            mzyjgx.ModelCode = _orderjgx.ModelCode;
            mzyjgx.ModelDesc = _orderjgx.ModelDesc;
            mzyjgx.LengthmaxIn = _orderjgx.LengthmaxIn;
            mzyjgx.LengthminIn = _orderjgx.LengthminIn;
            mzyjgx.InwlId = _orderjgx.InwlId;
            mzyjgx.InwlDesc = _orderjgx.InwlDesc;
            
            mzyjgx.IfWlMatched = 1;
            mzyjgx.OutwlId = _orderjgx.OutwlId;

            mzyjgx.IfMonitorJgx = _orderjgx.IfMonitorJgx;
            mzyjgx.PrdcrNo = _orderjgx.PrdcrNo;
            mzyjgx.MonitorPoint = _orderjgx.MonitorPoint;
            mzyjgx.CraftFileNo = _orderjgx.CraftFileNo;
            mzyjgx.CraftFileMan = _orderjgx.CraftFileMan;
            mzyjgx.CraftSeq = _orderjgx.CraftSeq;
            mzyjgx.StationRoad = _orderjgx.StationRoad;
            mzyjgx.Planstatus = 0;
            mzyjgx.InNumReal = "";
            mzyjgx.InWtReal = "";
            mzyjgx.OutNumReal = "";
            mzyjgx.OutWtReal = "";
            mzyjgx.CreateName = this.UserInfo.GetUserName();
            mzyjgx.CreateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            mzyjgx.UpdateName = "";
            mzyjgx.UpdateName = "";
            if (!CommHelper.IsNullOrEmptry(firstmatrow.Cells["PRO_ORDER_ID"].Text.Trim()))
            {
                if (!_orderjgx.PrevGxplanId.ToString().Equals(firstmatrow.Cells["PRO_ORDER_ID"].Text))//如果物料里的订单与本工序订单记录的前工序订单号不一致，需要先将物料脱单，然后判定状态改为利库
                {
                    lockLiku = 1;
                    isMatched = true;
                }
                else//如果物料里的订单与本工序订单的前工序订单号一致，则判定为普通匹配，只需要累加炉计划已排量
                {
                    lockLiku = 0;
                    isMatched = false;
                }
            }
            else
            {
                lockLiku = 1;
                isMatched = true;
            }
           
            
            double AIMLENGTH_CUT = 0;
            try
            {
                double CheckJVAL = Convert.ToDouble(BaseEntityDAL.GetCHECKJVAL(mzyjgx.OrdLnDlyPk.ToString(), this.ob));
                AIMLENGTH_CUT = Convert.ToDouble(mzyjgx.Aimlength) - CheckJVAL;
            }
            catch
            {
            }

            List<PlnZyJgxCEntity> tempJgxList = new List<PlnZyJgxCEntity>();//临时的子表行list

            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow row in obj)
            {
                int cutCount = 0;
                try
                {
                    cutCount = Convert.ToInt32(Math.Truncate(Convert.ToDouble(row.Cells["ACT_LEN"]) / AIMLENGTH_CUT));
                }
                catch
                {
                }
                PlnZyJgxCEntity czyjgx = new PlnZyJgxCEntity();
                czyjgx.HeatPlanNo = mzyjgx.HeatPlanNo;
                czyjgx.GxPlanNo = mzyjgx.GxPlanNo;
                czyjgx.PlineCode = mzyjgx.PlineCode;
                czyjgx.PlineName = mzyjgx.PlineName;
                czyjgx.HeatnoLast = mzyjgx.HeatnoLast;
                czyjgx.LengthIn = row.Cells["ACT_LEN"].Value;
                czyjgx.LastBatchNo = row.Cells["BATCH_NO"].Value;
                czyjgx.InWt = Convert.ToInt32(row.Cells["USER_ACT_WEIGHT"].Value);
                czyjgx.InNum = Convert.ToInt32(row.Cells["USER_ACT_COUNT"].Value);
                czyjgx.AimlengthCut = AIMLENGTH_CUT;
                czyjgx.OutnumCut = cutCount;
                try
                {
                    czyjgx.CutOutNum = Convert.ToDouble(czyjgx.InNum) * Convert.ToDouble(czyjgx.OutnumCut);
                    czyjgx.CutOutWt =CommHelper.GetSpecDecimalBit(PlanComm.WeightOfMi(Convert.ToDouble(mzyjgx.Outdiameter),Convert.ToDouble(mzyjgx.Aimwallthick))*Convert.ToDouble(czyjgx.AimlengthCut)*Convert.ToInt32(czyjgx.CutOutNum),3);
                }
                catch
                {
                }
                czyjgx.CutNumReal = "";
                czyjgx.CutWtReal = "";
                czyjgx.InNumReal = "";
                czyjgx.InWtReal = "";
                czyjgx.CutzyStatus = 0;
                czyjgx.ZyBatchId = mzyjgx.ZyBatchId;
                czyjgx.ProdIndex = mzyjgx.ProdIndex;
                czyjgx.ProPlanId = mzyjgx.ProPlanId;
                tempJgxList.Add(czyjgx);
            }
            int JgxCutNo = 0;
            int totalInNum = 0;
            double totalInWt = 0;
            int totalCutOutNum = 0;
            double totalCutOutWt = 0;
            var Lst_zygroup = tempJgxList.GroupBy(c=>c.LengthIn);
            foreach (var zygroup in Lst_zygroup)
            {
                PlnZyJgxCEntity ZyJgxC = new PlnZyJgxCEntity();
                
                int gp_CutOutNum = 0;
                double gp_CutOutWt = 0;
                int gp_InNum = 0;
                double gp_InWt = 0;
                foreach(PlnZyJgxCEntity member_zyjgxc in zygroup)
                {
                    ZyJgxC.AimlengthCut = member_zyjgxc.AimlengthCut;
                    ZyJgxC.CutNumReal = "";
                    gp_CutOutNum += Convert.ToInt32(member_zyjgxc.CutOutNum);
                    gp_CutOutWt += Convert.ToDouble(member_zyjgxc.CutOutWt);
                    ZyJgxC.CutWtReal = "";
                    ZyJgxC.CutzyStatus = 0;
                    ZyJgxC.GxPlanNo = member_zyjgxc.GxPlanNo;
                    ZyJgxC.HeatnoLast = member_zyjgxc.HeatnoLast;
                    ZyJgxC.HeatPlanNo = member_zyjgxc.HeatPlanNo;
                    gp_InNum += Convert.ToInt32(member_zyjgxc.InNum);
                    ZyJgxC.InNumReal = "";
                    gp_InWt += Convert.ToDouble(member_zyjgxc.InWt);
                    ZyJgxC.InWtReal = "";
                    ZyJgxC.LastBatchNo = member_zyjgxc.LastBatchNo;
                    ZyJgxC.LengthIn = member_zyjgxc.LengthIn;
                    ZyJgxC.OutnumCut = member_zyjgxc.OutnumCut;
                    ZyJgxC.PlineCode = member_zyjgxc.PlineCode;
                    ZyJgxC.PlineName = member_zyjgxc.PlineName;
                    ZyJgxC.ProdIndex = member_zyjgxc.ProdIndex;
                    ZyJgxC.ProPlanId = member_zyjgxc.ProPlanId;
                    ZyJgxC.ZyBatchId = member_zyjgxc.ZyBatchId;
                }

                totalCutOutNum += gp_CutOutNum;
                totalCutOutWt += gp_CutOutWt;
                totalInNum += gp_InNum;
                totalInWt += gp_InWt;
                ZyJgxC.CutOutNum = gp_CutOutNum;
                ZyJgxC.CutOutWt = gp_CutOutWt;
                ZyJgxC.InNum = gp_InNum;
                ZyJgxC.InWt = gp_InWt;
                bool IsZyCExist = false;
                PlnZyJgxCEntity existzyc=null;
                if (IsZyExist)
                {
                    existzyc= EntityHelper.GetData<PlnZyJgxCEntity>(MethodDef.StoveBase.queryZyC, new Object[] { SqlIDDef.PlanLuJGX.queryZYJGXC,existZy.HeatPlanNo },this.ob).FirstOrDefault(e=>e.LengthIn.ToString().Equals(ZyJgxC.LengthIn.ToString()));
                    if (existzyc != null)
                    {
                        IsZyCExist = true;
                    }
                }
                if (IsZyCExist)
                {
                    int oriCutOutNumC = Convert.ToInt32(existzyc.CutOutNum);
                    double oriCutOutWtC = Convert.ToDouble(existzyc.CutOutWt);
                    int oriInNum = Convert.ToInt32(existzyc.InNum);
                    double oriInWt = Convert.ToDouble(existzyc.InWt);

                    oriCutOutNumC += gp_CutOutNum;
                    oriCutOutWtC += gp_CutOutWt;
                    oriInNum += gp_InNum;
                    oriInWt += gp_InWt;

                    normalSqlidList.Add(SqlIDDef.PlanLuJGX.UpdateZYJGXC_WT_NUM);
                    normalParameterList.Add(new List<Object>() { oriCutOutNumC,oriCutOutWtC,oriInNum,oriInWt,existzyc.HeatPlanNo,existzyc.JgxCutNo});
                }
                else
                {
                    ZyJgxC.JgxCutNo = ++JgxCutNo;
                    entitySqlidList.Add(SqlIDDef.PlanLuJGX.insertZYJGXC);
                    entityjsonStrings.Add(JSONFormat.Format(ZyJgxC));
                    entityClassNameList.Add(ClassDef.PlnZyJgxCEntity);
                }
            }
            mzyjgx.InNum = totalInNum;
            mzyjgx.InWt = totalInWt;
            mzyjgx.OutNum = totalCutOutNum;
            mzyjgx.OutWt = totalCutOutWt;

            if (IsZyExist)//如果已有作业计划，只需累加投入产出量，其余动作不变
            {
                int oriOutNum = 0;
                double oriOutWt = 0;
                int oriInNum = 0;
                double oriInWt = 0;
                try
                {
                    oriOutNum = Convert.ToInt32(existZy.OutNum);
                    oriOutWt = Convert.ToDouble(existZy.OutWt);
                    oriInNum = Convert.ToInt32(existZy.InNum);
                    oriInWt = Convert.ToDouble(existZy.InWt);
                    oriOutNum += totalCutOutNum;
                    oriOutWt += totalCutOutWt;
                    oriInNum +=totalInNum;
                    oriInWt +=totalInWt;
                    normalSqlidList.Add(SqlIDDef.PlanLuJGX.UpdateZYJGX_WT_NUM);
                    normalParameterList.Add(new List<Object>() { oriInWt, oriInNum, oriOutNum, oriOutWt, m_loginusername, existZy.HeatPlanNo });
                }
                catch
                {
                }
            }
            else
            {
                entitySqlidList.Add(SqlIDDef.PlanLuJGX.insertZYJGXM);
                entityjsonStrings.Add(JSONFormat.Format(mzyjgx));
                entityClassNameList.Add(ClassDef.PlnZyJgxMEntity);
            }

            if (isMatched)
            {
                matchwt += totalCutOutWt;
                matchnum += totalCutOutNum;
                normalSqlidList.Add(SqlIDDef.PlanLuJGX.UpdateOrderJGX_MATCH_WT_NUM);
                normalParameterList.Add(new List<Object>() { _orderjgx.MatchWtIn, _orderjgx.MatchNumIn, _orderjgx.ProPlanId, _orderjgx.GxPlanNo });
            }
            batchnum += totalCutOutNum;
            batchwt += totalCutOutWt;

            normalSqlidList.Add(SqlIDDef.MaterialChoose.updateMaterial);
            normalParameterList.Add(new List<Object>() { mzyjgx.InwlId.ToString(), firstmatrow.Cells["JUDGE_STOVE_NO"].Value, firstmatrow.Cells["BATCH_NO"].Value, firstmatrow.Cells["BATCH_GROUD_NO"].Value, "G", Convert.ToInt32(mzyjgx.InNum), "G", "加工线", _orderjgx.ProPlanId.ToString(), _orderjgx.GxPlanNo, lockLiku, m_loginusername });

            normalSqlidList.Add(SqlIDDef.PlanLuJGX.UpdateOrderJGX_WT_NUM);
            normalParameterList.Add(new List<Object>() { batchwt, batchnum, _orderjgx.ProPlanId, _orderjgx.GxPlanNo });

            BaseEntityDAL.ExcuteTransaction(entitySqlidList, entityjsonStrings, entityClassNameList, normalSqlidList, normalParameterList, this.ob);

            //BaseEntityDAL.UpdateOrder_WT_NUM("PLN_ORDER_JGX_S",_orderjgx.BatchedWt.ToString(),_orderjgx.BatchedNum.ToString(),_orderjgx.ProPlanId.ToString(),_orderjgx.GxPlanNo.ToString(),this.ob);
            //UpdateOrderRCL_WT_NUM(_orderjgx);
            queryAll();
            //throw new NotImplementedException();
        }

        #endregion

        #region 数据库操作
        private void queryAll()
        {
            queryMat();
            queryOrder();
            
        }

        /// <summary>
        /// 物料确认动作的方法
        /// </summary>
        private void Confirm()
        {
            this.ultraGrid1.UpdateData();
            var editedrows = this.ultraGrid1.Rows.Where(c => c.Cells["Choose"].Text.Equals("True") && !string.IsNullOrEmpty(c.Cells["USER_ACT_COUNT"].Value.ToString()) && !c.Cells["USER_ACT_COUNT"].Value.ToString().Equals("0"));
            if (!Isupdate)
            {
                List<Infragistics.Win.UltraWinGrid.UltraGridRow> ListMATRows = new List<Infragistics.Win.UltraWinGrid.UltraGridRow>();
                foreach (Infragistics.Win.UltraWinGrid.UltraGridRow row in editedrows)
                {
                    ListMATRows.Add(row);
                }
                if (ListMATRows.Count > 0)
                {
                    OnMaterialConfirm(ListMATRows);
                }
            }
            else
            {
                if (editedrows.Count() > 0)
                {
                    var orderrow = this.ultraGrid2.Rows.First();
                    foreach (var row in editedrows)
                    {
                        if (CustomInfo == CustomInfoDef.DEFINE_CUSTOMER_ZG)
                        {
                            m_OriginNum = RowsCountsMapping[row];
                        }
                        
                        if (row.Cells["USER_ACT_COUNT"].Text.Trim().Equals("0"))
                        {
                            MessageUtil.ShowTips(string.Format("无法将投入量修改为0，如需删除作业计划请尝试回到{0}炉计划界面进行脱单或删除", CommHelper.getProcessDesc(CustomInfo)));
                            return;
                        }
                        int finalNum = 0;

                        finalNum = Convert.ToInt32(row.Cells["USER_ACT_COUNT"].Text.Trim());
                        double MAT_sinlewt = CommHelper.GetSpecDecimalBit(Convert.ToDouble(row.Cells["ACT_WEIGHT"].Text) / Convert.ToDouble(row.Cells["ACT_COUNT"].Text), 3);
                        double OUT_singlewt = CommHelper.GetSpecDecimalBit(Convert.ToDouble(orderrow.Cells["WeigthS"].Text) / Convert.ToDouble(orderrow.Cells["NumS"].Text), 3);
                        List<string> normalSqlidList = new List<string>();
                        List<List<Object>> normalParameterList = new List<List<Object>>();
                        string sqlID_UPDATEZY_WT_NUM = "";
                        string sqlID_UPDATEORDER_WT_NUM = "";
                        string sqlID_UPDATEOREER_MATCH_WT_NUM = "";
                        switch (CustomInfo)
                        {
                            case CustomInfoDef.DEFINE_CUSTOMER_DBK:
                                sqlID_UPDATEZY_WT_NUM = SqlIDDef.PlanLuDBK.UpdateZYDBK_WT_NUM;
                                sqlID_UPDATEORDER_WT_NUM = SqlIDDef.PlanLuDBK.UpdateOrderDBK_WT_NUM;
                                sqlID_UPDATEOREER_MATCH_WT_NUM = SqlIDDef.PlanLuDBK.UpdateOrderDBK_MATCH_WT_NUM;
                                break;
                            case CustomInfoDef.DEFINE_CUSTOMER_JG:
                                sqlID_UPDATEZY_WT_NUM = SqlIDDef.PlanLuJGX.UpdateZYJGX_WT_NUM;
                                sqlID_UPDATEORDER_WT_NUM = SqlIDDef.PlanLuJGX.UpdateOrderJGX_WT_NUM;
                                sqlID_UPDATEOREER_MATCH_WT_NUM = SqlIDDef.PlanLuJGX.UpdateOrderJGX_MATCH_WT_NUM;
                                break;
                            case CustomInfoDef.DEFINE_CUSTOMER_RCL:
                                sqlID_UPDATEZY_WT_NUM = SqlIDDef.PlanLuRCL.UpdateZYRCL_WT_NUM;
                                sqlID_UPDATEORDER_WT_NUM = SqlIDDef.PlanLuRCL.UpdateRCLORDER_WT_NUM;
                                sqlID_UPDATEOREER_MATCH_WT_NUM = SqlIDDef.PlanLuRCL.UpdateOrderRCL_MATCH_WT_NUM;
                                break;
                            case CustomInfoDef.DEFINE_CUSTOMER_ZG:
                                sqlID_UPDATEZY_WT_NUM = SqlIDDef.PlanLuZG.UpdateZYZG_WT_NUM;
                                sqlID_UPDATEORDER_WT_NUM = SqlIDDef.PlanLuZG.UpdateOrderZG_WT_NUM;
                                sqlID_UPDATEOREER_MATCH_WT_NUM = SqlIDDef.PlanLuZG.UpdateOrderZG_MATCH_WT_NUM;
                                break;
                        }
                        int nLockLiku = 0;
                        nLockLiku = DBComm.queryLockLiku(m_StoveNo, m_BatchNo, m_BatchGroupNo, m_ProPlanId, m_GxPlanNo, this.ob);
                        int actlen = 0;
                        try
                        {
                            actlen = Convert.ToInt32(row.Cells["ACT_LEN"].Value);
                        }
                        catch
                        {}
                        if (finalNum > m_OriginNum)//利库
                        {
                            int likuNum = finalNum - m_OriginNum;
                            #region 更新物料
                            if (CustomInfo == CustomInfoDef.DEFINE_CUSTOMER_ZG)
                            {
                                normalSqlidList.Add(SqlIDDef.MaterialChoose.updateGP);
                                normalParameterList.Add(new List<Object>() { m_InwlId, m_StoveNo,row.Cells["ACT_LEN"].Value, CommHelper.getProcessCode(CustomInfo), likuNum, CommHelper.getProcessCode(CustomInfo), CommHelper.getProcessDesc(CustomInfo), m_ProPlanId, m_GxPlanNo, m_loginusername,nLockLiku });
                            }
                            else
                            {
                                normalSqlidList.Add(SqlIDDef.MaterialChoose.updateMaterial);
                                normalParameterList.Add(new List<Object>() { m_InwlId, m_StoveNo, m_BatchNo, m_BatchGroupNo, CommHelper.getProcessCode(CustomInfo), likuNum, CommHelper.getProcessCode(CustomInfo), CommHelper.getProcessDesc(CustomInfo), m_ProPlanId, m_GxPlanNo, nLockLiku, m_loginusername });
                            }
                            #endregion

                            #region 更新作业计划量
                            //计划投入重量
                            double InWt = finalNum * MAT_sinlewt;
                            //计划投入支数
                            int InNum = finalNum;
                            //计划产出重量
                            double OutWt = finalNum * OUT_singlewt;
                            //计划产出支数
                            int OutNum = finalNum;
                            //   
                            int addCutSingleNum = 0;
                            double addCutSinleWt = 0;
                            if (CustomInfo == CustomInfoDef.DEFINE_CUSTOMER_ZG)
                            {
                                var zyzgcs = EntityHelper.GetData<PlnZyZgCEntity>(MethodDef.StoveBase.queryZyC, new Object[] { SqlIDDef.PlanLuZG.queryZYZGC, m_heatplanno }, this.ob);
                                PlnZyZgCEntity zyzgc = zyzgcs.Where(c => c.LengthGp.ToString().Trim().Equals(actlen.ToString())).First();
                                if (zyzgc == null)
                                {
                                    MessageUtil.ShowError(string.Format("数据出错，未能根据物料找到对应长度的从表记录 --ACT_LEN={0}", actlen));
                                    return;
                                }
                                int oriCutSingleNum = Convert.ToInt32(zyzgc.CutSingleNum);
                                double oriCutSingleWt = Convert.ToDouble(zyzgc.CutSingleWt);

                                //冲减从表作业计划量
                                addCutSingleNum = Convert.ToInt32(zyzgc.MultipleNum) * (finalNum - m_OriginNum);
                                addCutSinleWt = CommHelper.GetSpecDecimalBit(addCutSingleNum * PlanComm.GpweightOfmi(Convert.ToDouble(orderrow.Cells["Aimoutdiameter"].Value)) * Convert.ToInt16(zyzgc.LenGpSingle)*0.001, 3);

                                OutNum = addCutSingleNum * Convert.ToInt32(orderrow.Cells["OutnumCut"].Value);
                                OutWt =CommHelper.GetSpecDecimalBit( OutNum * PlanComm.WeightOfMi(Convert.ToDouble(orderrow.Cells["Aimoutdiameter"].Value), Convert.ToDouble(orderrow.Cells["Aimwallthick"].Value)) * Convert.ToDouble(orderrow.Cells["Aimlength"].Value),3);

                                oriCutSingleNum += addCutSingleNum;
                                oriCutSingleWt += addCutSinleWt;

                                int InGpNum = finalNum;
                                double InGpWt =CommHelper.GetSpecDecimalBit(finalNum * MAT_sinlewt,3);

                                normalSqlidList.Add(SqlIDDef.PlanLuZG.UpdateZYZGC_GPWT_GPNUM);
                                normalParameterList.Add(new List<Object>() {oriCutSingleNum,oriCutSingleWt,InGpNum,InGpWt,m_heatplanno,zyzgc.GpCutNo });

                                //冲减主表作业计划量
                                var zyzgms = EntityHelper.GetData<PlnZyZgMEntity>(MethodDef.StoveBase.queryZy,new Object[]{SqlIDDef.PlanLuZG.queryZYZGM,m_heatplanno},this.ob);
                                PlnZyZgMEntity zyzgm = zyzgms.First();

                                int MoriCutSingleNum = Convert.ToInt32(zyzgm.CutSingleNum);
                                double MoriCutSingleWt = Convert.ToDouble(zyzgm.CutSingleWt);

                                int MOriPlanGpNum = Convert.ToInt32(zyzgm.PlanGpNum);
                                int MOriOutNum = Convert.ToInt32(zyzgm.OutNum);
                                double MOriOutWt = Convert.ToDouble(zyzgm.OutWt);

                                MoriCutSingleNum += addCutSingleNum;
                                MoriCutSingleWt += addCutSinleWt;
                                MOriOutNum += OutNum;
                                MOriOutWt += OutWt;
                                MOriPlanGpNum += finalNum - m_OriginNum;

                                normalSqlidList.Add(SqlIDDef.PlanLuZG.UpdateZYZG_WT_NUM);
                                normalParameterList.Add(new List<Object>() { MoriCutSingleNum, MoriCutSingleWt, MOriOutNum, MOriOutWt, m_loginusername, MOriPlanGpNum, m_heatplanno });
                                    
                            }
                            else
                            {
                                normalSqlidList.Add(sqlID_UPDATEZY_WT_NUM);
                                normalParameterList.Add(new List<Object>() { InWt, InNum, OutNum, OutWt, m_loginusername, m_heatplanno });
                            }
                                
                            #endregion

                            #region 累加炉计划已排支数
                            //原始支数
                            int Ori_Batch_Num = Convert.ToInt32(orderrow.Cells["BatchedNum"].Text);
                            //原始重量
                            double Ori_Batch_Wt = Convert.ToDouble(orderrow.Cells["BatchedWt"].Text);
                                
                            if (CustomInfo == CustomInfoDef.DEFINE_CUSTOMER_ZG)
                            {
                                Ori_Batch_Num += OutNum;
                                Ori_Batch_Wt += OutWt;
                                    
                            }
                            else
                            {
                                //累加炉计划已排数量
                                Ori_Batch_Num += likuNum;
                                Ori_Batch_Wt += likuNum * OUT_singlewt;
                            }
                            normalSqlidList.Add(sqlID_UPDATEORDER_WT_NUM);
                            normalParameterList.Add(new List<Object>() { Ori_Batch_Wt, Ori_Batch_Num, m_ProPlanId, m_GxPlanNo });
                            #endregion

                            #region 更新利库量
                            if (nLockLiku == 1)//更新利库量
                            {
                                //原始投入利库支数
                                int Ori_Match_Num = Convert.ToInt32(orderrow.Cells["MatchNumIn"].Text);
                                //原始投入利库重量
                                double Ori_Match_Wt = Convert.ToDouble(orderrow.Cells["MatchWtIn"].Text);
                                //累加投入利库量
                                if (CustomInfo == CustomInfoDef.DEFINE_CUSTOMER_ZG)
                                {
                                    Ori_Match_Num += OutNum;
                                    Ori_Batch_Wt += OutWt;
                                }
                                else
                                {
                                    Ori_Match_Num += likuNum;
                                    Ori_Match_Wt += likuNum * OUT_singlewt;
                                }
                                    
                                normalSqlidList.Add(sqlID_UPDATEOREER_MATCH_WT_NUM);
                                normalParameterList.Add(new List<Object>() { Ori_Match_Wt, Ori_Match_Num, m_ProPlanId, m_GxPlanNo });
                            }
                            #endregion
                        }
                        else if (finalNum < m_OriginNum)//脱单
                        {

                            int sepNum = m_OriginNum - finalNum;

                            #region 退回物料
                            //
                            if (CustomInfo == CustomInfoDef.DEFINE_CUSTOMER_ZG)
                            {
                                if (!m_PlanStatus.Equals("计划"))
                                {
                                    MessageUtil.ShowWarning("轧管只允状态为计划的作业计划进行脱单");
                                    return;
                                }
                                normalSqlidList.Add(SqlIDDef.MaterialChoose.updateGPBack);
                                normalParameterList.Add(new List<Object>() { m_InwlId, m_StoveNo, m_ProPlanId, m_GxPlanNo,actlen, CommHelper.getProcessCode(CustomInfo), CommHelper.getProcessDesc(CustomInfo), CommHelper.getProcessCode(CustomInfo), sepNum, m_loginusername });
                            }
                            else
                            {
                                if (m_PlanStatus.Equals("生产完成"))
                                {
                                    normalSqlidList.Add(SqlIDDef.MaterialChoose.updateMaterialBackWhenFinish);
                                    normalParameterList.Add(new List<Object>() { m_InwlId, m_StoveNo, m_GxPlanNo, m_BatchNo, m_BatchGroupNo, CommHelper.getProcessCode(CustomInfo), CommHelper.getProcessDesc(CustomInfo), m_ProPlanId, CommHelper.getProcessCode(CustomInfo), sepNum, 0, m_loginusername });
                                }
                                else
                                {
                                    normalSqlidList.Add(SqlIDDef.MaterialChoose.updateMaterialBack);
                                    normalParameterList.Add(new List<Object>() { m_InwlId, m_StoveNo, m_GxPlanNo, m_BatchNo, m_BatchGroupNo, CommHelper.getProcessCode(CustomInfo), CommHelper.getProcessDesc(CustomInfo), m_ProPlanId, CommHelper.getProcessCode(CustomInfo), sepNum, 0, m_loginusername });
                                }

                            }
                            #endregion

                            #region 冲减作业计划量
                            double InWt = finalNum * MAT_sinlewt;//计划投入重量
                            int InNum = finalNum;//计划投入支数
                            double OutWt = finalNum * OUT_singlewt; //计划产出重量
                            int OutNum = finalNum;//计划产出支数

                            int sepCutSingleNum = 0;
                            double sepCutSingleWt = 0;


                            if (CustomInfo == CustomInfoDef.DEFINE_CUSTOMER_ZG)
                            {
                                //冲减作业计划从表
                                var zyzgcs = EntityHelper.GetData<PlnZyZgCEntity>(MethodDef.StoveBase.queryZyC, new Object[] { SqlIDDef.PlanLuZG.queryZYZGC, m_heatplanno }, this.ob);
                                PlnZyZgCEntity zyzgc = zyzgcs.Where(c => c.LengthGp.ToString().Trim().Equals(actlen.ToString())).First();

                                sepCutSingleNum = sepNum * Convert.ToInt32(zyzgc.MultipleNum);
                                sepCutSingleWt =  CommHelper.GetSpecDecimalBit(sepCutSingleNum * PlanComm.GpweightOfmi(Convert.ToDouble(orderrow.Cells["Aimoutdiameter"].Value)) * Convert.ToInt16(zyzgc.LenGpSingle)*0.001, 3);

                                OutNum = sepCutSingleNum * Convert.ToInt32(orderrow.Cells["OutnumCut"].Value);
                                OutWt = CommHelper.GetSpecDecimalBit(OutNum * PlanComm.WeightOfMi(Convert.ToDouble(orderrow.Cells["Aimoutdiameter"].Value), Convert.ToDouble(orderrow.Cells["Aimwallthick"].Value)) * Convert.ToDouble(orderrow.Cells["Aimlength"].Value), 3);

                                int CoriCutSingleNum = Convert.ToInt32(zyzgc.CutSingleNum);
                                double CoriCutSingleWt = Convert.ToDouble(zyzgc.CutSingleWt);

                                CoriCutSingleNum -= sepCutSingleNum;
                                CoriCutSingleWt -= sepCutSingleWt;

                                normalSqlidList.Add(SqlIDDef.PlanLuZG.UpdateZYZGC_GPWT_GPNUM);
                                normalParameterList.Add(new List<Object>() { CoriCutSingleNum,CoriCutSingleWt,finalNum,InWt,m_heatplanno,zyzgc.GpCutNo});

                                //冲减作业计划主表
                                var zyzgms = EntityHelper.GetData<PlnZyZgMEntity>(MethodDef.StoveBase.queryZy,new Object[]{SqlIDDef.PlanLuZG.queryZYZGM,m_heatplanno},this.ob);
                                PlnZyZgMEntity zyzgm = zyzgms.First();
                                int MoriCutSingleNum = Convert.ToInt32(zyzgm.CutSingleNum);
                                double MoriCutSingleWt = Convert.ToDouble(zyzgm.CutSingleWt);
                                int MoriOutNum = Convert.ToInt32(zyzgm.OutNum);
                                double MoriOutWt = Convert.ToDouble(zyzgm.OutWt);
                                int MoriPlanGpNum = Convert.ToInt32(zyzgm.PlanGpNum);

                                MoriCutSingleNum -= sepCutSingleNum;
                                MoriCutSingleWt -= sepCutSingleWt;
                                MoriOutNum -= OutNum;
                                MoriOutWt -= OutWt;
                                MoriPlanGpNum -= sepNum;

                                normalSqlidList.Add(SqlIDDef.PlanLuZG.UpdateZYZG_WT_NUM);
                                normalParameterList.Add(new List<Object>() {MoriCutSingleNum,MoriCutSingleWt,MoriOutNum,MoriOutWt,m_loginusername,MoriPlanGpNum,m_heatplanno });
                            }
                            else
                            {
                                normalSqlidList.Add(sqlID_UPDATEZY_WT_NUM);
                                normalParameterList.Add(new List<Object>() { InWt, InNum, OutNum, OutWt, m_loginusername, m_heatplanno });
                            }
                            
                            #endregion

                            #region 冲减炉计划已排量
                            //
                            normalSqlidList.Add(sqlID_UPDATEORDER_WT_NUM);
                            int Ori_Batch_Num = 0;
                            double Ori_Batch_Wt = 0;
                            //原始支数
                            try
                            {
                                Ori_Batch_Num = Convert.ToInt32(orderrow.Cells["BatchedNum"].Text);
                                //原始重量
                                Ori_Batch_Wt = Convert.ToDouble(orderrow.Cells["BatchedWt"].Text);
                            }
                            catch
                            {
                            }
                            //冲减炉计划已排量
                            if (CustomInfo == CustomInfoDef.DEFINE_CUSTOMER_ZG)
                            {
                                Ori_Batch_Num -= OutNum;
                                Ori_Batch_Wt -= OutWt;
                            }
                            else
                            {
                                Ori_Batch_Num -= sepNum;
                                Ori_Batch_Wt -= sepNum * OUT_singlewt;
                            }
                            
                            normalParameterList.Add(new List<Object>() { Ori_Batch_Wt, Ori_Batch_Num, m_ProPlanId, m_GxPlanNo });
                            #endregion

                            #region 冲减投入利库量
                            //
                            if (nLockLiku == 1)//更新利库量
                            {
                                //原始投入利库支数
                                int Ori_Match_Num = Convert.ToInt32(orderrow.Cells["MatchNumIn"].Text);
                                //原始投入利库重量
                                double Ori_Match_Wt = Convert.ToDouble(orderrow.Cells["MatchWtIn"].Text);
                                //累加投入利库量
                                if (CustomInfo == CustomInfoDef.DEFINE_CUSTOMER_ZG)
                                {
                                    Ori_Match_Num -= OutNum;
                                    Ori_Batch_Wt -= OutWt;
                                }
                                else
                                {
                                    Ori_Match_Num -= sepNum;
                                    Ori_Match_Wt -= sepNum * OUT_singlewt;
                                }
                                
                                normalSqlidList.Add(sqlID_UPDATEOREER_MATCH_WT_NUM);
                                normalParameterList.Add(new List<Object>() { Ori_Match_Wt, Ori_Match_Num, m_ProPlanId, m_GxPlanNo });
                            }
                            #endregion

                        }
                        if (normalSqlidList.Count > 0)
                        {
                            BaseEntityDAL.ExcuteTransaction(normalSqlidList, normalParameterList, this.ob);

                            
                            
                            double singlewt = CommHelper.GetSpecDecimalBit(m_OriginTOtalWt / m_OriginTotalnum, 3);
                            if (CustomInfo != CustomInfoDef.DEFINE_CUSTOMER_ZG)
                            {
                                m_OriginNum = finalNum;
                                SetTempData(m_OriginNum, singlewt * m_OriginNum);
                            }
                            else
                            {
                                
                                RowsCountsMapping[row] = finalNum;
                                
                            }
   
                            
                        }
                    }
                    if (CustomInfo == CustomInfoDef.DEFINE_CUSTOMER_ZG)
                    {
                        int count = 0;
                        foreach (var obj in RowsCountsMapping)
                        {
                            count += obj.Value;
                        }
                        m_OriginNum = count;
                    }
                    queryOrder();
                }
            }
        }

        private void queryOrder()
        {
            switch (CustomInfo)
            {
                case CustomInfoDef.DEFINE_CUSTOMER_DBK: this.plnOrderDbkSEntityBindingSource.DataSource = DBComm.queryOrderDBK("", "", m_ProPlanId, m_GxPlanNo, new string[] { "计划", "生产中", "生产完成", "关闭A" }, this.ob); break;
                case CustomInfoDef.DEFINE_CUSTOMER_JG: this.plnOrderJgxSEntityBindingSource.DataSource = DBComm.QueryOrderJG("", "", m_ProPlanId, m_GxPlanNo, new string[] { "计划", "生产中", "生产完成", "关闭A" }, this.ob); break;
                case CustomInfoDef.DEFINE_CUSTOMER_RCL: this.plnOrderRclSEntityBindingSource.DataSource = DBComm.QueryOrderRCL("", "", m_ProPlanId, m_GxPlanNo, new string[] { "计划", "生产中", "生产完成", "关闭A" }, this.ob); break;
                case CustomInfoDef.DEFINE_CUSTOMER_ZG: this.plnOrderZgSEntityBindingSource.DataSource = DBComm.QueryOrderZG("", "", m_ProPlanId, m_GxPlanNo, new string[] { "计划", "生产中", "生产完成", "关闭A" }, this.ob); break;
            }
            DataTable dt = ServerHelper.GetData(MethodDef.StoveBase.queryBatchMatch, new Object[] { CommHelper.GetOrdertableName(CustomInfo), m_ProPlanId, m_GxPlanNo }, this.ob);
            if (dt.Rows.Count > 0)
            {
                int InNumS = 0;
                int ADD_NUM_IN = 0;
                int BATCHED_NUM = 0;
                try
                {
                    InNumS = Convert.ToInt32(dt.Rows[0]["IN_NUM_S"].ToString());
                    ADD_NUM_IN = Convert.ToInt32(dt.Rows[0]["ADD_NUM_IN"].ToString());
                }
                catch
                {

                }
                try
                {
                    BATCHED_NUM = Convert.ToInt32(dt.Rows[0]["BATCHED_NUM"].ToString());
                    if (CustomInfo == CustomInfoDef.DEFINE_CUSTOMER_ZG)
                    {
                        DataTable dtInGpSum = ServerHelper.GetData(MethodDef.PlanLuZG.queryInNumInOrder, new Object[] { m_ProPlanId, m_GxPlanNo }, this.ob);
                        if (dtInGpSum.Rows.Count > 0)
                        {
                            BATCHED_NUM = Convert.ToInt32(dtInGpSum.Rows[0][0]);
                        }
                    }
                }
                catch
                {

                }
                if (Isupdate)
                {
                    m_MaxValidCount = InNumS + ADD_NUM_IN + m_OriginNum - BATCHED_NUM;
                }
                else
                {
                    m_MaxValidCount = InNumS + ADD_NUM_IN - BATCHED_NUM;
                }
            }
        }


        private void queryMat()
        {
            DataTable dt = new DataTable();
            if (Isupdate)
            {

                dt = DBComm.queryMaterialbyStv(m_InwlId,CustomInfo,m_StoveNo,m_BatchNo,m_BatchGroupNo,m_ProPlanId,m_GxPlanNo,this.ob);
            }
            else
            {
                dt = DBComm.queryMaterial(m_InwlId, CustomInfo, this.ob);
            }
            
            GridHelper.CopyDataToDatatable(dt,this.dataTable1,true);
        }


        /// <summary> 
        /// 根据物料编码更新MAT_GP_M表的前Usercount条数据的Process_Code和Process_DESC
        /// </summary>
        /// <param name="PROCESS_CDOE"></param>
        /// <param name="PROCESS_DESC"></param>
        /// <param name="MATERIAL_NO"></param>
        /// <param name="USERCOUNT"></param>
        /// <returns></returns>
        private int UpdateMAT_GP_M(String PROCESS_CDOE, String PROCESS_DESC, String MATERIAL_NO, String JUDGE_STOVE_NO, int USERCOUNT)
        {
            int nret = 0;
            nret = Core.Mes.Client.Comm.Server.ServerHelper.SetData(MethodDef.MaterialChoose.UpdateMAT_GP_M, new Object[] { PROCESS_CDOE, PROCESS_DESC, MATERIAL_NO, JUDGE_STOVE_NO, USERCOUNT }, this.ob);
            return nret;
        }
        #endregion

       
        

    }
}