MES_Client/TGMES/Core.StlMes.Client.PlnSaleOrd/炼钢计划/FrmSteelHandOver.cs

using System;
using System.Collections;
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.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Format;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.PlnSaleOrd.BaseMethod;
using Core.StlMes.Client.PlnSaleOrd.工序排产;
using Core.StlMes.Client.PlnSaleOrd.炼钢计划.entity;
using CoreFS.CA06;
using Infragistics.Win;
using Infragistics.Win.UltraWinGrid;
using Microsoft.Office.Interop.Excel;
using DataTable = System.Data.DataTable;

namespace Core.StlMes.Client.PlnSaleOrd.炼钢计划
{
    public partial class FrmSteelHandOver : FrmBase
    {

        public PlnSteelforfurnaceNewEntity PlnSteelforfurnaceNewEntity { get; private set; }

        private DataTable targerTable;


        private DataRow CurrentChem
        {
            get { return ucChemicalComposition.CurrentChem; }
        }

        public List<String> ShowEfPline
        {
            get
            {
                if (PlnSteelforfurnaceNewEntity == null) return new List<string>() { "" }; ;

                switch (PlnSteelforfurnaceNewEntity.EfPlineCode)
                {
                    case "C001":

                        return new List<string>(){"C001"};
                    case "C003":
                    case "C006":
                        return new List<string>() { "C003", "C006" };
                    default:
                        return new List<string>() { PlnSteelforfurnaceNewEntity.EfPlineCode };
                }
            }
        }

        public FrmSteelHandOver(PlnSteelforfurnaceNewEntity plnSteelforfurnaceNewEntity, OpeBase Ob)
        {
            PlnSteelforfurnaceNewEntity = plnSteelforfurnaceNewEntity;
            InitializeComponent();
            ob = Ob;
        }

        private void FrmSteelHandOver_Load(object sender, EventArgs e)
        {
            EntityHelper.ShowGridCaption<PlnSteelforfurnaceNewEntityPlus>(ugStove.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<CraftLg2CicEntity>(ugStove.DisplayLayout.Bands[1]);
            

            BaseHelper.setOtherColumnReadOnly(ugStove, new[] { "Check" });


            //绑定Valuelist 根据实体类值显示
            var list = SteelManagementHelper.GetValuelistLogic();
            SteelManagementHelper.SetGridValuelist(ref ugStove, "IfMonitorLg", ref list);
            list = SteelManagementHelper.GetValuelistLogic();
            SteelManagementHelper.SetGridValuelist(ref ugStove, "Status", ref list);

            list = SteelManagementHelper.GetBofType();
            SteelManagementHelper.SetGridValuelist(ref ugStove, "BofType", ref list);



            EntityHelper.ShowGridCaption<PlnSteelforOrdNewEntity>(ugOrder.DisplayLayout.Bands[0]);
            BaseHelper.setOtherColumnReadOnly(ugOrder, new[] { "Check" });



            list = SteelManagementHelper.GetValuelistLogic();
            SteelManagementHelper.SetGridValuelist(ref ugOrder, "IfSurplusAlloted", ref list);
            list = SteelManagementHelper.GetStatus();
            SteelManagementHelper.SetGridValuelist(ref ugOrder, "Status", ref list);


            list = SteelManagementHelper.GetValuelistLogic();
            SteelManagementHelper.SetGridValuelist(ref ugOrder, "Surplusflag", ref list);
            list = SteelManagementHelper.GetSurplusType();
            SteelManagementHelper.SetGridValuelist(ref ugOrder, "SurplusType", ref list);
            list = SteelManagementHelper.GetCastingtype();
            SteelManagementHelper.SetGridValuelist(ref ugOrder, "Castingtype", ref list);
            list = SteelManagementHelper.GetSurplusflag();
            SteelManagementHelper.SetGridValuelist(ref ugOrder, "GetSurplusflag", ref list);

            BaseHelper.MergedCell(ugOrder, new[] { "CastNo", "CastSeq", "Furnaceno", "FurnacenoSeq" });


            EntityHelper.ShowGridCaption<PlnSteelforOrdNewEntity>(ugOrder1.DisplayLayout.Bands[0]);
            BaseHelper.setOtherColumnReadOnly(ugOrder1, new[] { "Check", "ChangeNum", "ChangeWeight" });



            list = SteelManagementHelper.GetValuelistLogic();
            SteelManagementHelper.SetGridValuelist(ref ugOrder1, "IfSurplusAlloted", ref list);
            list = SteelManagementHelper.GetStatus();
            SteelManagementHelper.SetGridValuelist(ref ugOrder1, "Status", ref list);


            list = SteelManagementHelper.GetValuelistLogic();
            SteelManagementHelper.SetGridValuelist(ref ugOrder1, "Surplusflag", ref list);
            list = SteelManagementHelper.GetSurplusType();
            SteelManagementHelper.SetGridValuelist(ref ugOrder1, "SurplusType", ref list);
            list = SteelManagementHelper.GetCastingtype();
            SteelManagementHelper.SetGridValuelist(ref ugOrder1, "Castingtype", ref list);
            list = SteelManagementHelper.GetSurplusflag();
            SteelManagementHelper.SetGridValuelist(ref ugOrder1, "GetSurplusflag", ref list);

            BaseHelper.MergedCell(ugOrder1, new[] { "CastNo", "CastSeq", "Furnaceno", "FurnacenoSeq" });



            PlanComm.setGridActivation(ultraGridZgMs.DisplayLayout.Bands[0], "CHC", "NumberRule");
            PlanComm.setGridDigitalCol(ultraGridZgMs.DisplayLayout.Bands[0], 5, 2,
              "DIAMETER_GP", "LENGTH_GP", "ROLL_LENGTH", "DIAMETER_MANDREL", "AIMOUTDIAMETER", "AIMWALLTHICK",
              "LEN_GP_SINGLE", "AIMLENGTH", "OUTDIAMETER_ZG", "WALLTHICK_ZG");
            PlanComm.setGridDigitalCol(ultraGridZgMs.DisplayLayout.Bands[0], 5, 3,
                "WEIGTH_S", "WEIGTH_S_MIN", "GPREQ_WEIGHT", "MATCH_WT_IN", "ALLOWANCE", "FurnNum", "LjNum", "OUT_NUM", "Reall_NUM");
            PlanComm.setGridDigitalCol(ultraGridZgMs.DisplayLayout.Bands[0], 5, 0,
                "NUM_S", "OUTNUM_CUT", "MULTIPLE_NUM", "PLAN_USETIME", "GPREQ_NUM", "PLANS_NUM", "MATCH_NUM_IN", "FurnWt", "LjWeight", "OUT_WT", "Reall_WT");
            BaseHelper.GridColumnCount(ultraGridZgMs, new string[] { "MATCH_NUM_IN", "GPREQ_NUM", "Reall_NUM" });
            BaseHelper.GridColumnSum(ultraGridZgMs, new string[] { "MATCH_WT_IN", "GPREQ_WEIGHT", "Reall_WT" });

            PlanComm.setGridActivation(ultraGrid1.DisplayLayout.Bands[0], "CHC", "NumberRule");
            PlanComm.setGridDigitalCol(ultraGrid1.DisplayLayout.Bands[0], 5, 2,
              "DIAMETER_GP", "LENGTH_GP", "ROLL_LENGTH", "DIAMETER_MANDREL", "AIMOUTDIAMETER", "AIMWALLTHICK",
              "LEN_GP_SINGLE", "AIMLENGTH", "OUTDIAMETER_ZG", "WALLTHICK_ZG");
            PlanComm.setGridDigitalCol(ultraGrid1.DisplayLayout.Bands[0], 5, 3,
                "WEIGTH_S", "WEIGTH_S_MIN", "GPREQ_WEIGHT", "MATCH_WT_IN", "ALLOWANCE", "FurnNum", "LjNum", "OUT_NUM", "Reall_NUM");
            PlanComm.setGridDigitalCol(ultraGrid1.DisplayLayout.Bands[0], 5, 0,
                "NUM_S", "OUTNUM_CUT", "MULTIPLE_NUM", "PLAN_USETIME", "GPREQ_NUM", "PLANS_NUM", "MATCH_NUM_IN", "FurnWt", "LjWeight", "OUT_WT", "Reall_WT");
            BaseHelper.GridColumnCount(ultraGrid1, new string[] { "MATCH_NUM_IN", "GPREQ_NUM", "Reall_NUM" });
            BaseHelper.GridColumnSum(ultraGrid1, new string[] { "MATCH_WT_IN", "GPREQ_WEIGHT", "Reall_WT" });

            //设置列头名称
            EntityHelper.ShowGridCaption<PlnOrderCastSEntity>(ultraGridCast.DisplayLayout.Bands[0]);
            BaseHelper.setOtherColumnReadOnly(ultraGridCast, new string[] { "CHC", "CanNum", "PlineCode", "PlineCodeA", "PlanTimeB", "PlanUsetime", "RepairType", "Memo", "ProgyMemo", "ManualNum", "CraftNo", "CutNumGp" });
            BaseHelper.InitCellPosition(ultraGridCast, new string[] { "GxPlanNo", "OrderSeq", "DeliveryNo", "PlanWtS", "PlanNumS", "PlanUsetime", "GxProSeq", "PlnDivideId", "DiameterLz", "LenGpSingle", "CutNumGp", "CutLoseLen", "LengthLz", "WtCastOne", "CastNumCalc", "FurnaceNumCalc", "FurnaceWt", "PlanedWt", "PlanedNum", "Finishweight", "FinishNum", "CastNum", "FurnaceNum", "AddWtBegin", "AddWtEnd", "AddWtAhead", "AddWtNext", "CanWgt", "CanNum", "GradeSort", "ProcessingCostA", "TotalCostA", "ProcessingCostB", "TotalCostB", "ManualNum" });
            BaseHelper.GridColumnSum(ultraGridCast, new string[] { "PlanWtS", "CanWgt" });
            BaseHelper.GridColumnCount(ultraGridCast, new string[] { "PlanNumS", "CanNum" });
            BaseHelper.setUltraGridColumnMaxInput(ultraGridCast, new string[] { "PlanWtS", "CanWgt", "PlanedWt" });
            BaseHelper.setUltraGridColumnBits(ultraGridCast, new string[] { "PlanNumS", "CanNum", "PlanedNum", "ManualNum" });
            PlanHelper.InitRepairType(ultraGridCast, this);
            BaseHelper.ForbidSort(ultraGridCast);


            Refresh();
        }

        private void utmMain_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            switch (e.Tool.Key)
            {
                case "Close":    // ButtonTool
                    // Place code here
                    this.DialogResult = DialogResult.Cancel;
                    break;

                case "HandOver":    // ButtonTool
                    // Place code here

                /*    if (TabData.TabIndex == 2)
                    {*/

                        if (ugStove.ActiveRow == null)
                        {
                            MessageUtil.ShowWarning("请选择转交的炉计划!");
                            return;
                        }

                        PlnSteelforfurnaceNewEntityPlus ActivePlnSteelforfurnaceNewEntity =
                            ugStove.ActiveRow.ListObject as PlnSteelforfurnaceNewEntityPlus;
                        if (ActivePlnSteelforfurnaceNewEntity == null)
                        {
                            MessageUtil.ShowWarning("请选择转交的炉计划!");
                            return;
                        }

                        if (MessageUtil.ShowYesNoAndQuestion("是否转交给当前炉计划！") ==
                            DialogResult.No)
                            return;

                        if (!ActivePlnSteelforfurnaceNewEntity.OK)
                        {
                            if (MessageUtil.ShowYesNoAndQuestion("当前炉号的成分信息不满足当前选中炉计划的内控成分范围,请再次确认是否转交！") ==
                                DialogResult.No)
                                return;
                        }


                        var param =
                            SteelHelper.SetData(
                                "com.steering.pss.plnsaleord.steelMarkingPlan.FrmSteelManagement.HandOver",
                                new object[]
                                {
                                    PlnSteelforfurnaceNewEntity.Furnaceno, ActivePlnSteelforfurnaceNewEntity.Furnaceno,
                                    UserInfo.GetUserName()
                                }, ob);
                        if (param != null)
                            DialogResult = DialogResult.OK;
                  /*  }
                    else if (TabData.TabIndex == 3)
                    {
                      var Data=   ultraGridCast.Rows.Where(p =>
                        {
                            int temp = 0;
                            return p.Cells["ChangeNum"].Value != null &&
                                   int.TryParse(p.Cells["ChangeNum"].Value.ToString(), out temp);
                        }).Select(p =>
                      {
                          PlnOrderCastSEntity PlnOrderCastSEntity = p.ListObject as PlnOrderCastSEntity;
                          PlnOrderCastSEntity.PlanNumS = p.Cells["ChangeNum"].Value as decimal?;
                          return PlnOrderCastSEntity;
                      }).ToList();

                        if (!Data.Any())
                        {
                            MessageUtil.ShowWarning("请输入转交的铸造订单转入支数或重量!");
                            return;
                        }

                        var Orders = ugOrder1.Rows.Select(p =>
                        {
                            PlnSteelforOrdNewEntity PlnSteelforOrdNewEntity = (p.ListObject as PlnSteelforOrdNewEntity).Clone() as PlnSteelforOrdNewEntity;
                            PlnSteelforOrdNewEntity.TotMumM = p.Cells["ChangeNum"].Value as long?;
                            return PlnSteelforOrdNewEntity;
                        }).ToList();

                        if (MessageUtil.ShowYesNoAndQuestion("是否将铸造订单替换当前炉计划铸造计划！") ==
                           DialogResult.No)
                            return;

                        var param =
                           SteelHelper.SetData(
                               "com.steering.pss.plnsaleord.steelMarkingPlan.FrmSteelManagement.ChangeOrderPlan",
                               new object[]
                                {
                                    PlnSteelforfurnaceNewEntity.Furnaceno,
                                    UserInfo.GetUserName(),
                                     Orders.Select(JSONFormat.Format).ToList(),
                                       Data.Select(JSONFormat.Format).ToList()

                                }, ob);
                        if (param != null)
                            DialogResult = DialogResult.OK;

                    }*/
                    break;

                case "Refresh":    // ButtonTool
                    // Place code here
                    Refresh();
                    break;

            }

        }

        private void Refresh()
        {
            ucChemicalComposition.RefreshCurrentChemical(ob, PlnSteelforfurnaceNewEntity.CraftNo, PlnSteelforfurnaceNewEntity.StoveNo);
            RefreshOrderPlan();
            RefreshOtherFurnacePlan();
            //QueryZgS();
            //RefrshCastS();


        }

        private void RefrshCastS()
        {
            List<PlnOrderCastSEntity> listSource2 = EntityHelper.GetData<PlnOrderCastSEntity>
            ("com.steering.pss.plnsaleord.steelMarkingPlan.ControlOrderPlan.getOrderBInfoByContion",
                new object[]
                {
                    new string[] {}, new string[] {"C001", "C003", "C006"}, PlnSteelforfurnaceNewEntity.Gradecode,
                    "", "1", "1", new string[] {"0", "1", "", ""}, new string[] {PlnSteelforfurnaceNewEntity.PlineCode}, "0"
                }, ob);
            plnOrderCastSEntityBindingSource.DataSource =
                listSource2.Where(
                    p =>
                        (PlnSteelforfurnaceNewEntity.Diameter == "" ||
                         p.DiameterLz == PlnSteelforfurnaceNewEntity.Diameter) && p.CanWgt > 0).ToList();
            GridHelper.RefreshAndAutoSize(ultraGridCast);
        }

        private void RefreshOrderPlan()
        {
            List<PlnSteelforOrdNewEntity> listSource = EntityHelper.GetData<PlnSteelforOrdNewEntity>
            ("com.steering.pss.plnsaleord.steelMarkingPlan.FrmSteelManagement.SelectPlnSteelforOrdEntityByfurnaceno",
                new object[]
                {
                    PlnSteelforfurnaceNewEntity.Furnaceno
                },
                ob);
            plnSteelforOrdNewEntityBindingSource.DataSource = listSource;
            GridHelper.RefreshAndAutoSize(ugOrder);
            GridHelper.RefreshAndAutoSize(ugOrder1);

            string[] ProPlanId = listSource.SelectMany(p => p.ProPlanId.Split(',')).Where(p => !string.IsNullOrEmpty(p)).ToArray();

            if (ProPlanId.Length <= 0)
            {
               return;
            }

            DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.steelMarkingPlan.StlChemical.GetChemicalStd",
       new object[] { ProPlanId }, ob);
            ugStd.DataSource = dt;

            ugStd.DisplayLayout.Bands[0].Columns[0].MergedCellStyle = MergedCellStyle.Always;
            ugStd.DisplayLayout.Bands[0].Columns[1].MergedCellStyle = MergedCellStyle.Always;
        }

        private void RefreshOtherFurnacePlan()
        {
            List<PlnSteelforfurnaceNewEntityPlus> listSource = EntityHelper.GetData<PlnSteelforfurnaceNewEntityPlus>
            ("com.steering.pss.plnsaleord.steelMarkingPlan.FrmSteelManagement.SelectPlnSteelforfurnaceEntity",
                new object[]
                {
                    ShowEfPline, PlnSteelforfurnaceNewEntity.Gradecode,
                    new List<String>() {PlnSteelforfurnaceNewEntity.Furnaceno}, new List<string>() {"10"},
                    PlnSteelforfurnaceNewEntity.Furnaceno
                },
                ob);


            List<CraftLg2CicEntity> listSource1 = EntityHelper.GetData<CraftLg2CicEntity>
       ("com.steering.pss.plnsaleord.steelMarkingPlan.StlChemical.GetStlChemicalStd",
           new object[]
                {
                   listSource.Select(p=>p.CicGid).Where(p=>!string.IsNullOrEmpty(p)).Distinct().ToArray()
                },
           ob);

            foreach (PlnSteelforfurnaceNewEntityPlus data in listSource)
            {
                data.CraftLg2CicEntity = listSource1.Where(p => p.CicGid == data.CicGid).ToList();
            }


            plnSteelforfurnaceNewEntityPlusBindingSource.DataSource = listSource;
            GridHelper.RefreshAndAutoSize(ugStove);
        }

        private void QueryZgS()
        {
          //  dtlz = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryLZDataZg", new object[] { }, ob);
            Query(); 
           
                QueryGp();
         
                QueryOrder();
        }


        DataTable dtlz = new DataTable();

        private DataTable _data1;

        private void Query()
        {
            DataTable dtZg = ServerHelper.GetData("com.steering.pss.plnsaleord.steelMarkingPlan.FrmSteelPlnZg.selectPlnOrderZgS", new object[] { "", PlnSteelforfurnaceNewEntity.PlanRoute, PlnSteelforfurnaceNewEntity.Gradecode, PlnSteelforfurnaceNewEntity.Diameter, "0" }, ob);
            GridHelper.CopyDataToDatatable(dtZg, dataTable1, true);
            //GridHelper.RefreshAndAutoSize(ultraGridZgMs);

            #region 赋值LJ，装炉，出库
            foreach (UltraGridRow ugr in ultraGridZgMs.Rows)
            {
                int numz = 0;
                double wtz = 0;
                int numLj = 0;
                double wtLj = 0;
                int batNum = 0;
                double batWt = 0;
                if (dtlz.Rows.Count > 0)
                {
                    DataRow[] drs = dtlz.Select("订单号 ='" + ugr.Cells["PRO_PLAN_ID"].Value.ToString() + "' AND 序号='" + ugr.Cells["GX_PLAN_NO"].Value.ToString() + "'");
                    if (drs != null && drs.Length > 0)
                    {
                        if (!drs[0]["装炉支"].ToString().Equals(""))
                        {
                            ugr.Cells["FurnNum"].Value = drs[0]["装炉支"].ToString();
                            ugr.Cells["FurnWt"].Value = drs[0]["装炉吨"].ToString();
                            numz = int.Parse(ugr.Cells["FurnNum"].Value.ToString());
                            wtz = double.Parse(ugr.Cells["FurnWt"].Value.ToString());
                        }
                        else
                        {
                            numz = 0;
                            wtz = 0;
                        }
                        if (!drs[0]["LJ支"].ToString().Equals(""))
                        {
                            ugr.Cells["LjNum"].Value = drs[0]["LJ支"].ToString();
                            ugr.Cells["LjWeight"].Value = drs[0]["LJ吨"].ToString();
                            numLj = int.Parse(ugr.Cells["LjNum"].Value.ToString());
                            wtLj = double.Parse(ugr.Cells["LjWeight"].Value.ToString());
                        }
                        else
                        {
                            numLj = 0;
                            wtLj = 0;
                        }
                        if (!drs[0]["出库支"].ToString().Equals(""))
                        {
                            ugr.Cells["OUT_NUM"].Value = drs[0]["出库支"].ToString();
                            ugr.Cells["OUT_WT"].Value = drs[0]["出库吨"].ToString();
                            batNum = int.Parse(ugr.Cells["OUT_NUM"].Value.ToString());
                            batWt = double.Parse(ugr.Cells["OUT_WT"].Value.ToString());
                        }
                        else
                        {
                            batNum = 0;
                            batWt = 0;
                        }
                    }
                }

                //if (ugr.Cells["BATCHED_NUM"].Text.Equals(""))
                //{
                //    batNum = 0;
                //    batWt = 0;
                //}
                //else
                //{
                //    batNum = int.Parse(ugr.Cells["OUT_WT"].Value.ToString());
                //    batWt = double.Parse(ugr.Cells["OUT_WT"].Value.ToString());
                //}
                int gpNum = 0;
                double gpWt = 0;
                double gpWtMin = 0;
                if (ugr.Cells["GPREQ_NUM"].Text.Equals(""))
                {
                    gpNum = 0;
                    gpWt = 0;
                    gpWtMin = 0;
                }
                else
                {
                    gpNum = int.Parse(ugr.Cells["GPREQ_NUM"].Value.ToString());
                    gpWt = double.Parse(ugr.Cells["GPREQ_WEIGHT"].Value.ToString());
                    //gpWtMin = double.Parse(ugr.Cells["GPREQ_WEIGHT_MIN"].Value.ToString());
                }
                double matcInWt = double.Parse(ugr.Cells["MATCH_WT_IN"].Value.ToString());
                int matcInNum = int.Parse(ugr.Cells["MATCH_NUM_IN"].Value.ToString());
                if (gpNum - batNum - numz - numLj - matcInNum < 0)
                {
                    ugr.Cells["Reall_NUM"].Value = "0";
                    ugr.Cells["Reall_WT"].Value = "0";
                    //ugr.Cells["Reall_WT_MIN"].Value = 0;
                }
                else
                {
                    ugr.Cells["Reall_NUM"].Value = (gpNum - batNum - numz - numLj - matcInNum).ToString();
                    ugr.Cells["Reall_WT"].Value = (gpWt - batWt - wtz - wtLj - matcInWt).ToString();
                    //ugr.Cells["Reall_WT_MIN"].Value = (gpWtMin - batWt - wtz - wtLj - matcInWt).ToString();
                }
            }
            #endregion
            //}
            ultraGridZgMs.UpdateData();
                dataTable1.DefaultView.RowFilter = "Reall_NUM >0 ";
                DataTable dt = dataTable1.DefaultView.ToTable();
                _data1 = dataTable1.Copy();
                GridHelper.CopyDataToDatatable(dt, dataTable1, true);
            

        }
        /// <summary>
        /// 查询有管坯需求轧管订单
        /// </summary>
        private void QueryGp()
        {
            DataTable dtZg = ServerHelper.GetData("com.steering.pss.plnsaleord.steelMarkingPlan.FrmSteelPlnZg.selectPlnOrderZgS", new object[] { "", PlnSteelforfurnaceNewEntity.PlanRoute, PlnSteelforfurnaceNewEntity.Gradecode, PlnSteelforfurnaceNewEntity.Diameter, "1" }, ob);
            GridHelper.CopyDataToDatatable(dtZg, dataTable2, true);
            //GridHelper.RefreshAndAutoSize(ultraGridZgMs);

            #region 赋值LJ，装炉，出库
            foreach (UltraGridRow ugr in ultraGrid1.Rows)
            {
                int numz = 0;
                double wtz = 0;
                int numLj = 0;
                double wtLj = 0;
                int batNum = 0;
                double batWt = 0;
                if (dtlz.Rows.Count > 0)
                {
                    DataRow[] drs = dtlz.Select("订单号 ='" + ugr.Cells["PRO_PLAN_ID"].Value.ToString() + "' AND 序号='" + ugr.Cells["GX_PLAN_NO"].Value.ToString() + "'");
                    if (drs != null && drs.Length > 0)
                    {
                        if (!drs[0]["装炉支"].ToString().Equals(""))
                        {
                            ugr.Cells["FurnNum"].Value = drs[0]["装炉支"].ToString();
                            ugr.Cells["FurnWt"].Value = drs[0]["装炉吨"].ToString();
                            numz = int.Parse(ugr.Cells["FurnNum"].Value.ToString());
                            wtz = double.Parse(ugr.Cells["FurnWt"].Value.ToString());
                        }
                        else
                        {
                            numz = 0;
                            wtz = 0;
                        }
                        if (!drs[0]["LJ支"].ToString().Equals(""))
                        {
                            ugr.Cells["LjNum"].Value = drs[0]["LJ支"].ToString();
                            ugr.Cells["LjWeight"].Value = drs[0]["LJ吨"].ToString();
                            numLj = int.Parse(ugr.Cells["LjNum"].Value.ToString());
                            wtLj = double.Parse(ugr.Cells["LjWeight"].Value.ToString());
                        }
                        else
                        {
                            numLj = 0;
                            wtLj = 0;
                        }
                        if (!drs[0]["出库支"].ToString().Equals(""))
                        {
                            ugr.Cells["OUT_NUM"].Value = drs[0]["出库支"].ToString();
                            ugr.Cells["OUT_WT"].Value = drs[0]["出库吨"].ToString();
                            batNum = int.Parse(ugr.Cells["OUT_NUM"].Value.ToString());
                            batWt = double.Parse(ugr.Cells["OUT_WT"].Value.ToString());
                        }
                        else
                        {
                            batNum = 0;
                            batWt = 0;
                        }
                    }
                }

                //if (ugr.Cells["BATCHED_NUM"].Text.Equals(""))
                //{
                //    batNum = 0;
                //    batWt = 0;
                //}
                //else
                //{
                //    batNum = int.Parse(ugr.Cells["OUT_WT"].Value.ToString());
                //    batWt = double.Parse(ugr.Cells["OUT_WT"].Value.ToString());
                //}
                int gpNum = 0;
                double gpWt = 0;
                double gpWtMin = 0;
                if (ugr.Cells["GPREQ_NUM"].Text.Equals(""))
                {
                    gpNum = 0;
                    gpWt = 0;
                    gpWtMin = 0;
                }
                else
                {
                    gpNum = int.Parse(ugr.Cells["GPREQ_NUM"].Value.ToString());
                    gpWt = double.Parse(ugr.Cells["GPREQ_WEIGHT"].Value.ToString());
                    //gpWtMin = double.Parse(ugr.Cells["GPREQ_WEIGHT_MIN"].Value.ToString());
                }
                double matcInWt = double.Parse(ugr.Cells["MATCH_WT_IN"].Value.ToString());
                int matcInNum = int.Parse(ugr.Cells["MATCH_NUM_IN"].Value.ToString());
                if (gpNum - batNum - numz - numLj - matcInNum < 0)
                {
                    ugr.Cells["Reall_NUM"].Value = "0";
                    ugr.Cells["Reall_WT"].Value = "0";
                    //ugr.Cells["Reall_WT_MIN"].Value = 0;
                }
                else
                {
                    ugr.Cells["Reall_NUM"].Value = (gpNum - batNum - numz - numLj - matcInNum).ToString();
                    ugr.Cells["Reall_WT"].Value = (gpWt - batWt - wtz - wtLj - matcInWt).ToString();
                    //ugr.Cells["Reall_WT_MIN"].Value = (gpWtMin - batWt - wtz - wtLj - matcInWt).ToString();
                }
            }
            #endregion
            //}
            ultraGrid1.UpdateData();
            //if (radioButton1.Checked)
            //{
            dataTable2.DefaultView.RowFilter = "Reall_NUM >0 ";
            DataTable dt = dataTable2.DefaultView.ToTable();
            //_data2 = dataTable2.Copy();
            GridHelper.CopyDataToDatatable(dt, dataTable2, true);
            //}

        }
        private void QueryOrder()
        {
            List<PlnOrderCastSEntity> listSourceCast = EntityHelper.GetData<PlnOrderCastSEntity>
      ("com.steering.pss.plnsaleord.steelMarkingPlan.FrmSteelPlnZg.getOrderBInfoByContion", new object[] { "", PlnSteelforfurnaceNewEntity.PlanRoute, PlnSteelforfurnaceNewEntity.Gradecode, PlnSteelforfurnaceNewEntity.Diameter, PlnSteelforfurnaceNewEntity.PlineCode }, ob);
            plnOrderCastSEntityBindingSource.DataSource = listSourceCast;
        }

   
        private void ugStd_InitializeRow(object sender, InitializeRowEventArgs e)
        {
            try
            {
                if (CurrentChem == null) return;

                string ChemName = e.Row.Cells["化学元素"].Value.ToString();
                string CurrentValue = CurrentChem[ChemName].ToString();

                if (SteelManagementHelper.CompareChem(CurrentValue, e.Row.Cells["上限"].Value, null) != 0)
                    e.Row.Cells["上限"].Appearance.BackColor = Color.Red;
                else
                    e.Row.Cells["上限"].Appearance.BackColor = Color.LightGreen;

                if (SteelManagementHelper.CompareChem(CurrentValue, null, e.Row.Cells["下限"].Value) != 0)
                    e.Row.Cells["下限"].Appearance.BackColor = Color.Yellow;
                else
                    e.Row.Cells["下限"].Appearance.BackColor = Color.LightGreen;
            }
            catch (Exception)
            {
                
            }
    
        }

        private void ugStove_InitializeRow(object sender, InitializeRowEventArgs e)
        {
            if(!e.Row.HasChild()) return;

            if (CurrentChem == null) return;



            var PlnSteelforfurnaceNewEntityPlus = e.Row.ListObject as PlnSteelforfurnaceNewEntityPlus;
            if (PlnSteelforfurnaceNewEntityPlus==null) return;
            PlnSteelforfurnaceNewEntityPlus.OK = true;

            foreach (UltraGridRow row in  e.Row.ChildBands[0].Rows)
            {
                try
                {
                    var CraftLg2CicEntity = row.ListObject as CraftLg2CicEntity;
                    if (CraftLg2CicEntity==null) continue;


                    string CurrentValue = CurrentChem[CraftLg2CicEntity.ChemName].ToString();
                    if (
                        SteelManagementHelper.CompareChem(CurrentValue, CraftLg2CicEntity.StdmaxSign + CraftLg2CicEntity.Stdmax,
                            null
                        ) !=0)
                    {
                        row.Cells["Stdmax"].Appearance.BackColor = Color.Red;
                        PlnSteelforfurnaceNewEntityPlus.OK = false;
                    }
                    else
                    {
                        row.Cells["Stdmax"].Appearance.BackColor = Color.LightGreen;
                    }

                    if (
                       SteelManagementHelper.CompareChem(CurrentValue, null,
                            CraftLg2CicEntity.StdminSign + CraftLg2CicEntity.Stdmin)!=0)
                    {
                        row.Cells["Stdmin"].Appearance.BackColor = Color.Yellow;
                        PlnSteelforfurnaceNewEntityPlus.OK = false;
                    }
                    else
                        row.Cells["Stdmin"].Appearance.BackColor = Color.LightGreen;
                }
                catch (Exception)
                {
                    
                }

            }

            if (!PlnSteelforfurnaceNewEntityPlus.OK) e.Row.Cells["OK"].Appearance.BackColor = Color.Red;

        }

        private void ugOrder1_CellChange(object sender, CellEventArgs e)
        {
            try
            {
                ugOrder1.UpdateData();
                if (e.Cell.Column.Key.Equals("ChangeNum"))
                {
                    if (e.Cell.Value == e.Cell.Row.Cells["TotMumM"])
                    {
                        e.Cell.Row.Cells["ChangeWeight"].Value = e.Cell.Row.Cells["TotWeightM"].Value;
                    }
                    else
                    {
                        if (e.Cell.Value == null || e.Cell.Value.ToString() == "")
                        {
                            e.Cell.Row.Cells["ChangeWeight"].Value = null;
                        }
                        else
                        {



                            e.Cell.Row.Cells["ChangeWeight"].Value = double.Parse(e.Cell.Value.ToString())*
                                                                     double.Parse(
                                                                         e.Cell.Row.Cells["WeightM"].Value.ToString());
                        }
                    }
                }

                if (e.Cell.Column.Key.Equals("ChangeWeight"))
                {
                    if (e.Cell.Value == e.Cell.Row.Cells["TotWeightM"])
                    {
                        e.Cell.Row.Cells["ChangeNum"].Value = e.Cell.Row.Cells["TotMumM"].Value;
                    }
                    else
                    {
                        if (e.Cell.Value == null || e.Cell.Value.ToString() == "")
                        {
                            e.Cell.Row.Cells["ChangeNum"].Value = null;
                        }
                        else
                        {
                            e.Cell.Row.Cells["ChangeNum"].Value = Math.Ceiling(double.Parse(e.Cell.Value.ToString())/
                                                                               double.Parse(
                                                                                   e.Cell.Row.Cells["WeightM"].Value
                                                                                       .ToString()));
                        }
                    }
                }
            }
            catch (Exception)
            {
               

            }
        }

        private void ultraGridCast_CellChange(object sender, CellEventArgs e)
        {
            try
            {
                ultraGridCast.UpdateData();
                if (e.Cell.Column.Key.Equals("ChangeNum"))
                {
                    if (e.Cell.Value == e.Cell.Row.Cells["CanNum"])
                    {
                        e.Cell.Row.Cells["ChangeWeight"].Value = e.Cell.Row.Cells["CanWgt"].Value;
                    }
                    else
                    {
                        e.Cell.Row.Cells["ChangeWeight"].Value = double.Parse(e.Cell.Value.ToString()) *
                                                                 double.Parse(e.Cell.Row.Cells["WtCastOne"].Value.ToString());
                    }
                }

                if (e.Cell.Column.Key.Equals("ChangeWeight"))
                {
                    if (e.Cell.Value == e.Cell.Row.Cells["CanWgt"])
                    {
                        e.Cell.Row.Cells["ChangeNum"].Value = e.Cell.Row.Cells["CanNum"].Value;
                    }
                    else
                    {
                        e.Cell.Row.Cells["ChangeNum"].Value = Math.Ceiling(double.Parse(e.Cell.Value.ToString()) /
                                                                           double.Parse(e.Cell.Row.Cells["WtCastOne"].Value.ToString()));
                    }
                }
            }
            catch (Exception)
            {

            }
        }




    }
}