MES_Client/TGMES/Core.StlMes.Client.PlnSaleOrd/工序排产/FrmPlnOrderZgSMES.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.UltraWinEditors;
using Infragistics.Win.UltraWinGrid;
using Core.StlMes.Client.PlnSaleOrd.OrderManage.froms;
using Newtonsoft.Json;
using Core.StlMes.Client.PlnSaleOrd.窗体;
using Core.Mes.Client.Comm;
using Core.StlMes.Client.PlnSaleOrd.PopupWindow;
using Core.StlMes.Client.PlnSaleOrd.炉计划.Entity;
using Core.StlMes.Client.PlnSaleOrd.炉计划.Tool;

namespace Core.StlMes.Client.PlnSaleOrd
{
    ///custominfo==0　表示轧管排产查询界面
    /// <summary>
    /// 坯料测算
    /// </summary>
    public partial class FrmPlnOrderZgSMES : FrmBase
    {
        private string departm = "";//获取部门ID
        private string[] plineCode = null;//获取产线代码
        /// <summary>
        /// 订单编号
        /// </summary>
        private string _ProPlanId = "";
        DataTable dtPlinGroup = null;
        /// <summary>
        /// 排产序号
        /// </summary>
        private string _GxPlanNo = "";
        UltraComboEditor uceDimaM = new UltraComboEditor();//芯棒直径
        /// <summary>
        /// 行首背景色
        /// </summary>
        private Color _backColor = new Color();
        string proPlanId = "";
        string gxPlanNo = "";
        /// <summary>
        /// 调整行集合
        /// </summary>
        private ArrayList _entityList = null;
        public FrmPlnOrderZgSMES()
        {  
            InitializeComponent();
            this.IsLoadUserView = true;
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            base.ToolBar_Click(sender, ToolbarKey);
            switch (ToolbarKey)
            {
                case "Query"://查询
                    Query();
                    break;
                //case "Capacity"://产线能力维护
                //    Capacity();
                //    break;
                //case "AddRepairPlan"://检修计划
                //    AddRepairPlan();
                //    break;
                //case "DeleteRepairPlan"://删除检修计划
                //    DeleteRepairPlan();
                //    break;
                //case "PlineChange"://产线调整
                //    PlineChange();
                //    break;
                //case "TimeChange"://时间调整
                //    TimeChange();
                //    break;
                //case "StatusChange"://状态调整
                //    StatusChange();
                //    break;
                //case "InitData"://耗时初始化
                //    InitData();
                //    break;
                //case "Spit"://拆分订单
                //    Spit();
                //    break;
                //case "Merge"://合并订单
                //    Merge();
                //    break;
                //case "Issued"://确认下发
                //    Issued("0");
                //    break;
                //case "CancelIssued"://取消下发
                //    Issued("1");
                //    break;
                //case "SetPlanFinish"://设置合同完成
                //    SetPlanFinish();
                //    break;
                case "ModifyGpAimWall"://重算
                    ModifyGpAimWall();
                    break;
                //case "UpdateCrop"://修改切头尾
                //    UpdateCrop();
                //    break;
                //case "UpdateDiameM"://修改芯棒直径
                //    UpdateDiameM();
                //    break;
                //case "ModifyThicknesWall"://修改控制壁厚
                //    ModifyThicknesWall();
                //    break;
                case "Recalculate"://保存
                    Recalculate();
                    break;
                case "Recalculate2"://上传
                    Recalculate2();
                    break;
                case "Export": //导出
                    GridHelper.ulGridToExcel(ultraGridZgS, "轧管排产信息");
                    break;
                //case "UpdateMonth"://修改排产月份
                //    UpdateMonth();
                //    break;
                //case "ApplyApproval"://申请审批
                //    ApplyApproval();
                //    break;
                //case "ModifyBatter"://修改坯子
                //    ModifyBatter();
                //    break;
                //case "UpdateGroupGp"://修改索引码
                //    UpdateGroupGp();
                //    break;
                //case "Confirm"://炉计划下发
                //    Issued("2");
                //    break;
                //case "UinConfirm"://取消炉计划下发
                //    Issued("3");
                //    break;
                //case "UpdateBatch"://修改轧批号
                //    UpdateBatch();
                //    break;
                //case "Decision"://修改判定字头
                //    DoDecision();
                //    break;
                //case "ProMemo"://工艺备注修改
                //    DoProMemo("0");
                //    break;
                //case "UpdateMemo"://计划备注修改
                //    DoProMemo("1");
                //    break;
                //case "Import"://导入
                //    DoImport();
                //    break;
                //case "UpdatePase"://主被动修改
                //    DoUpdatePase();
                //    break;
                //case "ModifyProcess"://手动获取工艺
                //    DoModifyProcess();
                //    break;
                //case "AgainProcess"://重新获取工艺
                //    doAgainProcess();
                //    break;
                //case "SortOrderZg":
                //    sortOrderZg();
                //    break;
                   case"Print":
                    printData();
                    break;
                //case"Notice":
                //    tabNotice();
                //    break;
                //case "UpdateOrderTeam"://修改是否协同
                //    UpdateOrderTeam();
                //    break;
                case "Close": //关闭
                    this.Close();
                    break;
                default:
                    break;
            }
        }

        private void UpdateOrderTeam()
        {
            this.ultraGridZgS.UpdateData();
            IQueryable<UltraGridRow> checkMagRows = this.ultraGridZgS.Rows.AsQueryable().Where(" CHC = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请选择需要操作的数据信息!");
                return;
            }
            ArrayList parmList = new ArrayList();
            foreach (UltraGridRow row in checkMagRows)
            {
                PlnOrderZgSOEntity plnOrderZgsTity = (PlnOrderZgSOEntity)row.ListObject;
                string plnOrderZgsEntity = JSONFormat.Format(plnOrderZgsTity);
                parmList.Add(plnOrderZgsEntity);
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.processOrder.base.ProducHelper";
            ccp.MethodName = "UpdateOrderTeam";
            ccp.ServerParams = new object[] { parmList, "D" };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("修改成功!"))
                {
                    Query();
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
        }
        /// <summary>
        /// 标识监制信息
        /// </summary>
        private void tabNotice()
        {
            this.ultraGridZgS.UpdateData();
            IQueryable<UltraGridRow> checkMagRows = this.ultraGridZgS.Rows.AsQueryable().Where(" CHC = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请选择需要操作的监制信息!");
                return;
            }
            ArrayList parmList = new ArrayList();
            foreach (UltraGridRow row in checkMagRows)
            {
                PlnOrderZgSOEntity plnOrderZgsTity = (PlnOrderZgSOEntity)row.ListObject;
                string plnOrderZgsEntity = JSONFormat.Format(plnOrderZgsTity);
                parmList.Add(plnOrderZgsEntity);
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.processOrder.base.ProducHelper";
            ccp.MethodName = "tabNotice";
            ccp.ServerParams = new object[] { parmList, UserInfo.GetUserName(),"D" };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("标识监制成功!"))
                {
                    Query();
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
        }

        /// <summary>
        /// 重新排序订单
        /// </summary>
        private void sortOrderZg()
        {
            //string plineCode = "";
            //plineCode = comPline.Value == null ? "" : comPline.Value.ToString();
            //if (plineCode.Equals(""))
            //{
            //    MessageUtil.ShowTips("请选择产线!");
            //    return;
            //}
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.planStove.StoveHelper";
            ccp.MethodName = "sortOrderZg";
            ccp.ServerParams = new object[] { plineCode };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("重新排序成功!"))
                {
                    Query();
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
        }
        /// <summary>
        /// 打印检验要点
        /// </summary>
        private void printData()
        {
           // string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilTestKey2.cpt&PROCESS_CODE=D";
              string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepEntrustLabel.cpt&CHECK_NO=72A340800091&JUDGE_STOVE_NO=A34080009&PROCESS_CODE=D";
            FrmRepExcel fBug = new FrmRepExcel(ob, strurl);
           // fBug.AutoSize = true;
           // fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
            fBug.Text = "检验要点打印";
            fBug.ShowDialog();
        }



        private void FrmPlnOrderZgS_Load(object sender, EventArgs e)
        {
            if (CustomInfo == null) { CustomInfo = ""; }
            //设置列头名称
            EntityHelper.ShowGridCaption<TPoDemandPlanEntity>(ultraGridZgS.DisplayLayout.Bands[0]);

            if (CustomInfo == "0")
            {
                PlanComm.setGridActivation(this.ultraGridZgS.DisplayLayout.Bands[0], "CHC");//, "OutsBilletFl"
            }
            else
            {
                BaseHelper.setOtherColumnReadOnly(ultraGridZgS, new string[] { "CHC", "Mgcd", "DiameterMandrel", "Zzcd", "Ggfqs", "Cpcd", "Qt", "Qw", "Bcs", "Dbcplcd", "Gpzj", "WgH", "WgD", "QuantityPurchased", "RulerLength", "Ssl", "Jhlc" });
                //tzh 后续改颜色
                BaseHelper.setColumnBackColor(ultraGridZgS, new string[] { "Pass", "Mgcd", "DiameterMandrel", "Zzcd", "Ggfqs", "Cpcd", "Qt", "Qw", "Bcs", "Dbcplcd", "Gpzj", "WgH", "WgD", "HtcgzlMax", "HtcgzlMin", "QuantityPurchased", "RulerLength", "Dbcplzl", "Ssl", "Mz", "Jhlc", "Zzzl", "Zzcd", "Dbcplcd", "QuantityPurchased" });
                //BaseHelper.setColumnBackColor2(ultraGridZgS, new string[] { "Mgbh", "Mgwj" });
               // EntityHelper.setColumnShowOrHidden(ultraGridZgS, new string[] { "OrderTeam" }, false);
            }
          //  BaseHelper.InitCellPosition(ultraGridZgS, new string[] { "GxPlanNo", "OrderSeq", "DeliveryNo", "Outdiameter", "Wallthick", 
          //      "LenRollMax", "LenRollMin", "Aimoutdiameter", "Aimwallthick", "Aimlength", "DiameterGp", "LenGpSingle", "RollLength",
          //      "LenCuthead", "LenCutend", "OutnumCut", "DiameterMandrel", "InWeightS", "InNumS", "WeigthS", "NumS", "AddWtIn", 
          //      "AddNumIn", "MatchWtIn", "MatchNumIn", "GxProSeq", "PlanUsetime", "BatchedWt", "BatchedNum", "Finishweight", 
          //      "Finishnum", "ProcessingCost", "TotalCost" ,"FinishWgt","UnfinishWgt","UnfinishNum","OutdiameterZg","WallthickZg","GpreqNum","GpreqWeight","TubeEndRatio","WeigthSMin","PlansNum","TimeDiffer","AfProNum","AmountDifference","LjNum","LjWeight","FurnaNum","FurnaWeight","CkNum","CkWeight","HrCapcty","ExpectWt","ExpectNum","PendNum","PendWeight","ReducedWt","LjWeightB","LjNumB" });
          //  BaseHelper.setUltraGridColumnMaxInput(ultraGridZgS, new string[] { "WeigthS", "WeigthSMin", "GpreqWeight", "InWeightS", "AddWtIn", "MatchWtIn", "BatchedWt", "AmountDifference", "UnfinishWgt", "LjWeight", "FurnaWeight", "CkWeight", "ExpectWt", "PendWeight", "ReducedWt", "LjWeightB" });
          ////  plineCode = PlanHelper.InitDropPlinePower("D", comPline, this.ValidDataPurviewIds, this.ob);
            //PlanHelper.InitRepairType(ultraGridZgS, this);
            //PlanHelper.InitEditPline("D", "", ultraGridZgS, this);
          ///  comPline.SelectedIndex = 0;
            if (CustomInfo != "0") { BaseHelper.ForbidSort(ultraGridZgS); }
          //  BaseHelper.GridColumnSum(ultraGridZgS, new string[] { "WeigthS", "WeigthSMin", "GpreqWeight", "PendWeight", "ReducedWt", "LjWeight", "ExpectWt", "FurnaWeight", "CkWeight", "LjWeightB" });
           // BaseHelper.GridColumnCount(ultraGridZgS, new string[] { "NumS", "GpreqNum", "PlansNum", "PendNum", "LjNumB", "LjNum", "FurnaNum", "CkNum", });

          //  BaseHelper.setUltraGridColumnColor(ultraGridZgS, new string[] { "CraftFileNo", "CraftFileLv2G", "Gradename", "DiameterGp" }, Color.GreenYellow);

          //  PlanHelper.InitEditGroup("1219", ultraGridZgS, this, "OutsStlPipeFl");
            _backColor = ultraGridZgS.DisplayLayout.Override.RowSelectorAppearance.BackColor;
            //InitTime();
            InitColorStyle();

         
        }

        /// <summary>
        /// 初始化列状态
        /// </summary>
        private void InitColorStyle()
        {
            //ultraGridZgS.DisplayLayout.Bands[0].Columns["PlanTimeB"].Format = "yyyy-MM-dd HH:mm:ss";
            //ultraGridZgS.DisplayLayout.Bands[0].Columns["PlanTimeB"].MaskInput = "yyyy-mm-dd hh:mm:ss";
            //ultraGridZgS.DisplayLayout.Bands[0].Columns["PlanTimeB"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DateTime;
            //ultraGridZgS.DisplayLayout.Bands[0].Columns["CraftFileLv2G"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton;
            //ultraGridZgS.DisplayLayout.Bands[0].Columns["CraftFileNo"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton;
            //ultraGridZgS.DisplayLayout.Bands[0].Columns["Gradename"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton;
            //ultraGridZgS.DisplayLayout.Bands[0].Columns["DiameterGp"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton;
            //ultraGridZgS.DisplayLayout.Bands[0].Columns["AfInfo"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton;
            //ultraGridZgS.DisplayLayout.Bands[0].Columns["AfInfo"].CellAppearance.BackColor = Color.GreenYellow;
            //ultraGridZgS.DisplayLayout.Bands[0].Columns["DiameterMandrel"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton;
            //ultraGridZgS.DisplayLayout.Bands[0].Columns["AfProLin"].CellAppearance.BackColor = Color.GreenYellow;
            //ultraGridZgS.DisplayLayout.Bands[0].Columns["TimeDiffer"].CellAppearance.BackColor = Color.GreenYellow;
            //ultraGridZgS.DisplayLayout.Bands[0].Columns["AfProNum"].CellAppearance.BackColor = Color.GreenYellow;
            //ultraGridZgS.DisplayLayout.Bands[0].Columns["AfProLin"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton;
            //ultraGridZgS.DisplayLayout.Bands[0].Columns["ProdGradename"].CellAppearance.BackColor = Color.Wheat;
            UltraNumericEditor[] uneArr = new UltraNumericEditor[3];
            for (int i = 0; i < uneArr.Length; i++)
            {
                uneArr [i]= new UltraNumericEditor();
                uneArr[i].NumericType =NumericType.Double;
                if (i == 1)
                {
                    uneArr[i].MaskInput = "nnnnn";
                }
                else
                {
                    uneArr[i].MaskInput = "nnnnn.nn";
                }
               
                uneArr[i].SpinButtonDisplayStyle = Infragistics.Win.ButtonDisplayStyle.Always;
                this.Controls.Add(uneArr[i]);
                uneArr[i].Visible = false;
            }

            //uneArr[0].SpinIncrement = 0.01;
            //uneArr[1].SpinIncrement = 50;
            //uneArr[2].SpinIncrement =10;
            //ultraGridZgS.DisplayLayout.Bands[0].Columns["Outdiameter"].EditorComponent = uneArr[0];
            //ultraGridZgS.DisplayLayout.Bands[0].Columns["Wallthick"].EditorComponent = uneArr[0];
            //ultraGridZgS.DisplayLayout.Bands[0].Columns["OutdiameterZg"].EditorComponent = uneArr[0];
            //ultraGridZgS.DisplayLayout.Bands[0].Columns["WallthickZg"].EditorComponent = uneArr[0];
            ////ultraGridZgS.DisplayLayout.Bands[0].Columns["PipeLengthMin"].EditorComponent = uneArr[0];
            ////ultraGridZgS.DisplayLayout.Bands[0].Columns["PipeLengthMax"].EditorComponent = uneArr[0];
            //ultraGridZgS.DisplayLayout.Bands[0].Columns["Aimoutdiameter"].EditorComponent = uneArr[0];
            //ultraGridZgS.DisplayLayout.Bands[0].Columns["Aimwallthick"].EditorComponent = uneArr[0];
            //ultraGridZgS.DisplayLayout.Bands[0].Columns["Aimlength"].EditorComponent = uneArr[0];
            //ultraGridZgS.DisplayLayout.Bands[0].Columns["RollLength"].EditorComponent = uneArr[0];
            //ultraGridZgS.DisplayLayout.Bands[0].Columns["LenGpSingle"].EditorComponent = uneArr[2];
            //ultraGridZgS.DisplayLayout.Bands[0].Columns["LenCuthead"].EditorComponent = uneArr[1];
            //ultraGridZgS.DisplayLayout.Bands[0].Columns["LenCutend"].EditorComponent = uneArr[1];

            decisionFlsg(false);
            
        }

        private void decisionFlsg( Boolean b) {

            if (b)
            {
                UltraComboEditor uceAbc = new UltraComboEditor();
                ultraGridZgS.DisplayLayout.Bands[0].Columns["Pass"].EditorComponent = uceAbc;
                ultraGridZgS.DisplayLayout.Bands[0].Columns["Pass"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

                ultraGridZgS.DisplayLayout.Bands[0].Columns["DiameterMandrel"].EditorComponent = uceAbc;
                ultraGridZgS.DisplayLayout.Bands[0].Columns["DiameterMandrel"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
               
                ValueList vlistSteel1 = new ValueList(); ;
                vlistSteel1.ValueListItems.Insert(0, "1", "1");
                vlistSteel1.ValueListItems.Insert(1, "2", "2");
                vlistSteel1.ValueListItems.Insert(2, "3", "3");
                vlistSteel1.ValueListItems.Insert(3, "4", "4");
                vlistSteel1.ValueListItems.Insert(4, "5", "5");
                vlistSteel1.ValueListItems.Insert(5, "6", "6");
                ultraGridZgS.DisplayLayout.Bands[0].Columns["Ggfqs"].ValueList = vlistSteel1;
                ultraGridZgS.DisplayLayout.Bands[0].Columns["Ggfqs"].CellActivation = Activation.AllowEdit;
                ultraGridZgS.DisplayLayout.Bands[0].Columns["Bcs"].ValueList = vlistSteel1;
                ultraGridZgS.DisplayLayout.Bands[0].Columns["Bcs"].CellActivation = Activation.AllowEdit;



                DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryMandrelSpec",
             new object[] { "1" }, this.ob);
                if (dt != null && dt.Rows.Count > 0)
                {
                    ValueList vlistSteel = PlanComm.GeneralValuelist(ref dt, "XX", "XX");
                    //vlistSteel.ValueListItems.Insert(0, "", "");
                    ultraGridZgS.DisplayLayout.Bands[0].Columns["DiameterMandrel"].ValueList = vlistSteel;
                    ultraGridZgS.DisplayLayout.Bands[0].Columns["DiameterMandrel"].CellActivation = Activation.AllowEdit;
                }

                DataTable dt1 = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryMandrelSpec",
               new object[] { "2" }, this.ob);
                if (dt1 != null && dt1.Rows.Count > 0)
                {
                    ValueList vlistSteel = PlanComm.GeneralValuelist(ref dt1, "XX", "XX");
                    //vlistSteel.ValueListItems.Insert(0, "", "");
                    ultraGridZgS.DisplayLayout.Bands[0].Columns["Pass"].ValueList = vlistSteel;
                    ultraGridZgS.DisplayLayout.Bands[0].Columns["Pass"].CellActivation = Activation.AllowEdit;
                }

                DataTable dt2 = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryMandrelSpec",
                new object[] { "3" }, this.ob);
                if (dt2 != null && dt2.Rows.Count > 0)
                {
                    ValueList vlistSteel = PlanComm.GeneralValuelist(ref dt2, "XX", "XX");
                    //vlistSteel.ValueListItems.Insert(0, "", "");
                    ultraGridZgS.DisplayLayout.Bands[0].Columns["Mgwj"].ValueList = vlistSteel;
                    ultraGridZgS.DisplayLayout.Bands[0].Columns["Mgwj"].CellActivation = Activation.AllowEdit;
                }

                DataTable dt3 = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryMandrelSpec",
                new object[] { "4" }, this.ob);
                if (dt3 != null && dt3.Rows.Count > 0)
                {
                    ValueList vlistSteel = PlanComm.GeneralValuelist(ref dt3, "XX", "XX");
                    //vlistSteel.ValueListItems.Insert(0, "", "");
                    ultraGridZgS.DisplayLayout.Bands[0].Columns["Mgbh"].ValueList = vlistSteel;
                    ultraGridZgS.DisplayLayout.Bands[0].Columns["Mgbh"].CellActivation = Activation.AllowEdit;
                }
                
            }
            //else {
            //    ultraGridZgS.DisplayLayout.Bands[0].Columns["Pass"].EditorComponent = null;
            //    ultraGridZgS.DisplayLayout.Bands[0].Columns["Pass"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.Default;
            //    ultraGridZgS.DisplayLayout.Bands[0].Columns["Pass"].CellActivation = Activation.ActivateOnly;

            //    ultraGridZgS.DisplayLayout.Bands[0].Columns["Xbzj"].EditorComponent = null;
            //    ultraGridZgS.DisplayLayout.Bands[0].Columns["Xbzj"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.Default;
            //    ultraGridZgS.DisplayLayout.Bands[0].Columns["Xbzj"].CellActivation = Activation.ActivateOnly;

            //    ultraGridZgS.DisplayLayout.Bands[0].Columns["Mgwj"].EditorComponent = null;
            //    ultraGridZgS.DisplayLayout.Bands[0].Columns["Mgwj"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.Default;
            //    ultraGridZgS.DisplayLayout.Bands[0].Columns["Mgwj"].CellActivation = Activation.ActivateOnly;

            //    ultraGridZgS.DisplayLayout.Bands[0].Columns["Mgbh"].EditorComponent = null;
            //    ultraGridZgS.DisplayLayout.Bands[0].Columns["Mgbh"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.Default;
            //    ultraGridZgS.DisplayLayout.Bands[0].Columns["Mgbh"].CellActivation = Activation.ActivateOnly;
            //}
        }
        private void InitTime()
        {
            DateTime now = DateTime.Now;
            DateTime d1 = new DateTime(now.Year, now.Month, 1);
            DateTime d2 = d1.AddMonths(1).AddSeconds(-1);
            //txtPlanTimeB1.Value = d1;
            //txtPlanTimeB2.Value = d2;
            //txtPlanTimeE1.Value = d1;
            //txtPlanTimeE2.Value = d2;
        }
       
        /// <summary>
        /// 初始化芯棒直径
        /// </summary>
        /// <param name="plineCode">产线</param>
        /// <param name="PassCode">孔型编码</param>
        /// <param name="aimoutdiameter">控制外径</param>
        /// <param name="aimwallthick">控制壁厚</param>
        //private void InitDimaM(string plineCode, string passCode, string aimoutdiameter, string aimwallthick)
        //{

        //    DataTable dt1 = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CorePlnProcessOrd.queryPlnMandrelId", new object[] { plineCode, passCode, aimoutdiameter,aimwallthick }, this.ob);
        //    UltraComboEditor uce = new UltraComboEditor();
        //    ultraGridZgS.Controls.Add(uce);
        //    uce.Visible = false;
        //    uce.DropDownListWidth = -1;
        //    uce.DropDownStyle = DropDownStyle.DropDownList;
        //    uce.DataSource = dt1;
        //    uce.DisplayMember = "DIAMETER_MANDREL";
        //    uce.ValueMember = "MANDREL_ID";
        //    ultraGridZgS.DisplayLayout.Bands[0].Columns["DiameterMandrel"].EditorComponent = uce;
        //    ultraGridZgS.DisplayLayout.Bands[0].Columns["DiameterMandrel"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
        //}

        private void chcPline_CheckedChanged(object sender, EventArgs e)
        {
            //if (chcPline.Checked) { comPline.ReadOnly = false; } else { comPline.ReadOnly = true; }
            if (chcOrderNo.Checked) { txtPlanNo.ReadOnly = false; } else { txtPlanNo.ReadOnly = true; }
            //if (chcProPlanId.Checked) { txtProPlanId.ReadOnly = false; } else { txtProPlanId.ReadOnly = true; }
            //if (chcPlanTimeB.Checked) { txtPlanTimeB1.ReadOnly = false; txtPlanTimeB2.ReadOnly = false; } else { txtPlanTimeB1.ReadOnly = true; txtPlanTimeB2.ReadOnly = true; }
            //if (chcPlanTimeE.Checked) { txtPlanTimeE1.ReadOnly = false; txtPlanTimeE2.ReadOnly = false; } else { txtPlanTimeE1.ReadOnly = true; txtPlanTimeE2.ReadOnly = true; }
        }

        private void ultraGridZgS_InitializeRow(object sender, InitializeRowEventArgs e)
        {
            PlanHelper.ControlCellEdit(e.Row);
        }

        /// <summary>
        /// 查询
        /// </summary>
        private void Query()
        {
            
              
            
            WaitingForm2 wf3 = new WaitingForm2("正在刷新，请稍候....");
            try
            {
                this.Cursor = Cursors.WaitCursor;
                //执行状态
              //  string[] statusArr = contorlPlanStatus1.statusArr;
                //合同号
                string orderNo = "";
                if (chcOrderNo.Checked) { orderNo = txtPlanNo.Text.Trim(); }
               

                List<TPoDemandPlanEntity> listSource = EntityHelper.GetData<TPoDemandPlanEntity>
                ("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryPlanOrderCxMes", new object[] { orderNo }, this.ob);
                TPoDemandPlanBindingSource.DataSource = listSource;
               
              //  dtPlinGroup = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryPlinCodeGroup", null, this.ob);
              
                
                _entityList = null;
                _ProPlanId = "";
                _ProPlanId = "";

              
            }
            finally
            {
                wf3.Close();
                this.Cursor = Cursors.Default;
            }
        }
        /// <summary>
        /// 修改切头尾数据
        /// </summary>
        private void UpdateCrop()
        {


            try
            {
                ArrayList messageErr = new ArrayList();
                ultraGridZgS.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkRows = ultraGridZgS.Rows.AsQueryable().Where("CHC = 'True'");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowWarning("请选择订单!");
                    return;
                }
                PlanComm.WaitFromOpen(this.Cursor);
                foreach (UltraGridRow uRow in checkRows)
                {
                    ArrayList param = new ArrayList();
                    param.Add(UserInfo.GetUserName());
                    param.Add(uRow.Cells["ProPlanId"].Value.ToString());
                    param.Add(uRow.Cells["GxPlanNo"].Value.ToString());
                    param.Add(uRow.Cells["InwlId"].Text);
                    param.Add(uRow.Cells["OutwlId"].Text);
                    param.Add(uRow.Cells["PlineCode"].Value.ToString());
                    list.Add(param);

                }
                if (list.Count == 0)
                {
                    PlanComm.WaitFromColse(this.Cursor);
                    MessageUtil.ShowTips("0条修改成功，" + messageErr.Count + "条修改失败。\n" + messageErr[0]);
                    return;
                }

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.pss.plnsaleord.processOrder.base.ProducHelper";
                ccp.MethodName = "updateCrop";
                ccp.ServerParams = new object[] { list, UserInfo.GetUserName() };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                PlanComm.WaitFromColse(this.Cursor);
                if (ccp.ReturnCode == -1) return;
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("批量获取切头尾成功！"))
                {
                    Query();
                }
            }
            catch (Exception ex)
            {
                PlanComm.WaitFromColse(this.Cursor);
                if (!(ex is MESException))
                {
                    MessageUtil.ShowError(ex.Message);
                }
            }
        }

      

        /// <summary>
        /// 初始化
        /// </summary>
        private void InitData()
        {
            ArrayList list = ProducHelper.GetChcRows<PlnOrderZgSEntity>(ultraGridZgS);
            bool flag = ProducHelper.InitData(list, "D", this.ob);
            if (flag)
            {
                _ProPlanId = ((PlnOrderZgSEntity)list[0]).ProPlanId;
                _GxPlanNo = ((PlnOrderZgSEntity)list[0]).GxPlanNo;
                Query();
            }
        }

    

        private void ultraGridZgS_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow ugrAc = ultraGridZgS.ActiveRow;
            if (ugrAc == null)
            {
                return;
            }
            //foreach (UltraGridRow ugr in ultraGridZgS.Rows)
            //{
            //    if (ugr.Cells["ProPlanId"].Text.Equals(ugrAc.Cells["ProPlanId"].Text))
            //    {
            //        ugr.RowSelectorAppearance.BackColor = Color.LightGreen;
            //    }
            //    else
            //    {
            //        ugr.RowSelectorAppearance.BackColor = _backColor;
            //    }
            //    if (ugr.Cells["PlanUsetime"].Value == null || ugr.Cells["PlanUsetime"].Value.ToString().Equals("") || Convert.ToDouble(ugr.Cells["PlanUsetime"].Value.ToString()) <= 0)
            //    {
            //        ugr.Cells["PlanUsetime"].Appearance.BackColor = Color.MistyRose;
            //    }
            //    if (ugr.Cells["ExeStatus"].Value.ToString().Equals("生产中"))
            //    {
            //        ugr.Cells["PlanTimeB"].Appearance.BackColor = System.Drawing.Color.FromArgb(255, 255, 128);
            //    }
            //    if (ugr.Cells["IsRepairPln"].Text.Equals("是"))
            //    {
            //        ugr.Cells["PlanUsetime"].Appearance.BackColor = System.Drawing.Color.FromArgb(255, 255, 128);
            //        ugr.Cells["RepairType"].Appearance.BackColor = System.Drawing.Color.FromArgb(255, 255, 128);
            //    }
            //}

            //proPlanId = ugrAc.Cells["ProPlanId"].Text.ToString();
            //gxPlanNo = ugrAc.Cells["GxPlanNo"].Text.ToString();
           // doQueryActual(proPlanId, gxPlanNo);
        }

        /// <summary>
        /// 虚拟炉计划
        /// </summary>
        /// <param name="proPlanId"></param>
        /// <param name="gxPlanNo"></param>
        private void doQueryVirtual(string proPlanId, string gxPlanNo)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.doQueryVirtual",
              new object[] { proPlanId, gxPlanNo }, this.ob);
     //       GridHelper.CopyDataToDatatable(dt, dataTable1, true);
        }
        /// <summary>
        /// 实际炉计划
        /// </summary>
        /// <param name="proPlanId"></param>
        /// <param name="gxPlanNo"></param>
        private void doQueryActual(string proPlanId, string gxPlanNo)
        {
         //   List<PlnZyZgMCEntity> listSourceM = EntityHelper.GetData<PlnZyZgMCEntity>
         //("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.doQueryActual", new object[] { proPlanId, gxPlanNo }, ob);
         //   plnZyZgMCEntityBindingSource.DataSource = listSourceM;
         //   foreach (UltraGridRow ugr in ultraGrid1.Rows)
         //   {
         //       ugr.Cells["DELETE"].Value = "删除炉计划";
         //       //没有实际炉计划，主炉计划变颜色
         //       if (ugr.Cells["ActuaWt"].Value.ToString().Equals(""))
         //       {
         //           //ugr.RowSelectorAppearance.BackColor = Color.GreenYellow;
         //           ugr.Appearance.BackColor = Color.Orange;
         //       }
         //       if (!string.IsNullOrEmpty(ugr.Cells["ApplyDesc"].Value.ToString2()))
         //       {
         //           ugr.Appearance.BackColor = Color.Red;
         //       }
         //       //if (!ugr.Cells["Planstatus"].Value.ToString().Equals("计划") && ugr.Cells["Planstatus"].Value.ToString().Equals("下发"))
         //       //{
         //       //    if (int.Parse(ugr.Cells["ActCount"].Value.ToString()) > 0)
         //       //    {
         //       //        ugr.Cells["ActCount"].Column.CellAppearance.BackColor = Color.;
         //       //    }
         //       //}
         //   }


        }
        private void ultraGridZgS_CellChange(object sender, CellEventArgs e)
        {

            try
            {
                ultraGridZgS.UpdateData();
                if (e.Cell.Column.Key.Equals("CHC"))
                {
                    IQueryable<UltraGridRow> chcRows = ultraGridZgS.Rows.AsQueryable().Where(a => a.GetValue("CHC") == "True");
                    if (chcRows != null && chcRows.Count() > 0)
                    {
                        decisionFlsg(true);
                    }
                    else
                    {
                        decisionFlsg(false);
                    }
                }

                //TZH 2024.8.16 add 自动计算
                foreach (var ultraGridRow in ultraGridZgS.Rows)
                {

                    if ((bool)ultraGridRow.Cells["CHC"].Value)
                    {

                        decimal Ggfqs = 0;
                        if (ultraGridRow.Cells["Ggfqs"].Value.ToString() != "")
                        {
                            Ggfqs = decimal.Parse((ultraGridRow.Cells["Ggfqs"].Value.ToString()));//钢管分切数
                        }
                        decimal Cpcd = 0;
                        if (ultraGridRow.Cells["Cpcd"].Value.ToString() != "")
                        {
                           Cpcd = decimal.Parse(ultraGridRow.Cells["Cpcd"].Value.ToString());//成品长度
                        }
                        decimal Qt = 0;
                        if (ultraGridRow.Cells["Qt"].Value.ToString() != "")
                        {
                            Qt = decimal.Parse(ultraGridRow.Cells["Qt"].Value.ToString());//切头
                        }
                        decimal Qw = 0;
                        if (ultraGridRow.Cells["Qw"].Value.ToString()!="")
                        { 
                            Qw = decimal.Parse(ultraGridRow.Cells["Qw"].Value.ToString()); //切尾
                        }
                        decimal ContractedQuantity=0;
                        if (ultraGridRow.Cells["ContractedQuantity"].Value.ToString()!="")
                        {
                            ContractedQuantity = decimal.Parse(ultraGridRow.Cells["ContractedQuantity"].Value.ToString()); //合同量
                        }
                        decimal Jhlc = 0;
                        if (ultraGridRow.Cells["Jhlc"].Value.ToString() != "")
                        {
                            Jhlc = decimal.Parse(ultraGridRow.Cells["Jhlc"].Value.ToString()); //交货量差
                        }
                        decimal OuterDiam = 0;
                        if (ultraGridRow.Cells["OuterDiam"].Value.ToString()!="")
                        {
                              OuterDiam = decimal.Parse(ultraGridRow.Cells["OuterDiam"].Value.ToString()); //外径
                        }
                        decimal ControlsThickness = 0;
                        if (ultraGridRow.Cells["ControlsThickness"].Value.ToString() != "")
                        {
                             ControlsThickness = decimal.Parse(ultraGridRow.Cells["ControlsThickness"].Value.ToString()); //控制壁厚 
                        }
                        decimal Dbcplzl = 0;
                        if(ultraGridRow.Cells["Dbcplzl"].Value.ToString()!="")
                        {
                            Dbcplzl = decimal.Parse(ultraGridRow.Cells["Dbcplzl"].Value.ToString()); //单倍尺坯料重量  
                        }
                       decimal Zzcd = 0;
                        if(ultraGridRow.Cells["Zzcd"].Value.ToString()!="")
                        {
                            Zzcd = decimal.Parse(ultraGridRow.Cells["Zzcd"].Value.ToString()); //轧制长度  
                        }
                        decimal Zzzl = 0;
                        if(ultraGridRow.Cells["Zzzl"].Value.ToString()!="")
                        {
                            Zzzl = decimal.Parse(ultraGridRow.Cells["Zzzl"].Value.ToString()); //轧制重量
                        }
                        decimal Mz = 0;
                        if(ultraGridRow.Cells["Mz"].Value.ToString()!="")
                        {
                             Mz = decimal.Parse(ultraGridRow.Cells["Mz"].Value.ToString()); //米重
                        }
                        decimal Dbcplcd = 0;
                        if(ultraGridRow.Cells["Dbcplcd"].Value.ToString()!="")
                        {
                            Dbcplcd = decimal.Parse(ultraGridRow.Cells["Dbcplcd"].Value.ToString()); //单倍尺坯料长度
                        }
                        decimal Ssl = 0;
                        if (ultraGridRow.Cells["Ssl"].Value.ToString()!="")
                        {
                            Ssl = decimal.Parse(ultraGridRow.Cells["Ssl"].Value.ToString()); //烧损率
                        }
                         decimal Gpzj = 0;
                        if (ultraGridRow.Cells["Gpzj"].Value.ToString()!="")
                        {
                            Gpzj = decimal.Parse(ultraGridRow.Cells["Gpzj"].Value.ToString()); //管坯直径
                        }
                           decimal WgD = 0;
                        if (ultraGridRow.Cells["WgD"].Value.ToString()!="")
                        {
                            WgD = decimal.Parse(ultraGridRow.Cells["WgD"].Value.ToString()); //毛管外径
                        }
                            decimal WgH = 0;
                        if (ultraGridRow.Cells["WgH"].Value.ToString()!="")
                        {
                            WgH = decimal.Parse(ultraGridRow.Cells["WgH"].Value.ToString()); //毛管壁厚
                        }
                        UltraComboEditor uceAbc = new UltraComboEditor();
                        ultraGridZgS.DisplayLayout.Bands[0].Columns["Gpzj"].EditorComponent = uceAbc;
                        ultraGridZgS.DisplayLayout.Bands[0].Columns["Gpzj"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                        ValueList vlistSteel = new ValueList(); ;
                        vlistSteel.ValueListItems.Insert(0, "380", "380");
                        vlistSteel.ValueListItems.Insert(1, "390", "390");
                        vlistSteel.ValueListItems.Insert(2, "400", "400");
                        vlistSteel.ValueListItems.Insert(3, "450", "450");
                        vlistSteel.ValueListItems.Insert(4, "460", "460");
                        vlistSteel.ValueListItems.Insert(5, "500", "500");
                        ultraGridZgS.DisplayLayout.Bands[0].Columns["Gpzj"].ValueList = vlistSteel;
                        ultraGridZgS.DisplayLayout.Bands[0].Columns["Gpzj"].CellActivation = Activation.AllowEdit;

                        if (ultraGridRow.Cells["Gpzj"].Value.ToString() != "")
                        {
                            if (ultraGridRow.Cells["Gpzj"].Value.Equals("380"))
                            {
                                ultraGridRow.Cells["Mz"].Value = "0.885";
                                Mz = decimal.Parse("0.885");
                            }
                            if (ultraGridRow.Cells["Gpzj"].Value.Equals("390"))
                            {
                                ultraGridRow.Cells["Mz"].Value = "0.94";
                                Mz = decimal.Parse("0.94");
                            }
                            if (ultraGridRow.Cells["Gpzj"].Value.Equals("400"))
                            {
                                ultraGridRow.Cells["Mz"].Value = "0.995";
                                Mz = decimal.Parse("0.995");
                            }
                            if (ultraGridRow.Cells["Gpzj"].Value.Equals("450"))
                            {
                                ultraGridRow.Cells["Mz"].Value = "1.24";
                                Mz = decimal.Parse("1.24");
                            }
                            if (ultraGridRow.Cells["Gpzj"].Value.Equals("460"))
                            {
                                ultraGridRow.Cells["Mz"].Value = "1.3";
                                Mz = decimal.Parse("1.3");
                            }
                            if (ultraGridRow.Cells["Gpzj"].Value.Equals("500"))
                            {
                                ultraGridRow.Cells["Mz"].Value = "1.532";
                                Mz = decimal.Parse("1.532 ");
                            }
                        }

                        //tzh 9.16 
                        ultraGridRow.Cells["Ssl"].Value = "0.975";
                        

                        //暂时不用 tzh
                       if (ultraGridRow.Cells["Pass"].Value.ToString() != "" && ultraGridRow.Cells["DiameterMandrel"].Value.ToString() != "")
                       {
                           DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryMandrelSpec",
                                new object[] { ultraGridRow.Cells["Pass"].Value.ToString(), ultraGridRow.Cells["DiameterMandrel"].Value.ToString() }, this.ob);
                           if (dt != null && dt.Rows.Count > 0)
                           {
                               //ValueList vlistSteel = PlanComm.GeneralValuelist(ref dt, "XX", "XX");
                               ultraGridRow.Cells["WgD"].Value = dt.Rows[0][0];
                               ultraGridRow.Cells["WgH"].Value = dt.Rows[0][1];


                           }


                           //ultraGridRow.Cells["Mgwj"].Value = "";
                           //ultraGridRow.Cells["Mgbh"].Value = "";
                       }




                         if (ultraGridRow.Cells["Ggfqs"].Value.ToString() != "" && ultraGridRow.Cells["Cpcd"].Value.ToString() != "" && ultraGridRow.Cells["Qt"].Value.ToString() != ""&& ultraGridRow.Cells["Qw"].Value.ToString() != "")

                        {

                            ultraGridRow.Cells["Zzcd"].Value = Ggfqs * Cpcd + Qt / 1000 + Qw / 1000;

                            Zzcd = Ggfqs * Cpcd + Qt/1000  + Qw/1000 ;


                        }

                     
                         if (ultraGridRow.Cells["OuterDiam"].Value.ToString() != "" && ultraGridRow.Cells["ControlsThickness"].Value.ToString() != "" && Zzcd != 0)
                         {
                             //轧制重量公式：(外径-控制壁厚)*控制壁厚*轧制长度/1000

                             ultraGridRow.Cells["Zzzl"].Value = (OuterDiam - ControlsThickness) * ControlsThickness * Zzcd * decimal.Parse("0.02466 ") / 1000;
                             Zzzl = (OuterDiam - ControlsThickness) * ControlsThickness * Zzcd * decimal.Parse("0.02466 ") / 1000;
                         }

                         if (ultraGridRow.Cells["Zzzl"].Value.ToString() != "" && ultraGridRow.Cells["Ssl"].Value.ToString() != "" && Zzzl != 0)
                         {
                             //单倍尺坯料长度公式：轧制重量/1.532*1000/烧损率Ssl默认写成0.975 按照要求数据取整而且十位取整
                             ultraGridRow.Cells["Dbcplcd"].Value = Math.Floor((Zzzl / decimal.Parse("1.532") * 1000 / decimal.Parse("0.975")) / 10) *10;
                             Dbcplcd = Zzzl / decimal.Parse("1.532") * 1000 / decimal.Parse("0.975");
                         }

                         if (ultraGridRow.Cells["Mz"].Value.ToString() != "" &&  Dbcplcd != 0)
                         { 
                             //单倍尺坯料重量公式：米重*单倍尺坯料长度
                             ultraGridRow.Cells["Dbcplzl"].Value = Mz * Dbcplcd / 1000;
                             Dbcplzl = Mz * Dbcplcd / 1000;
                         }

                         if (ultraGridRow.Cells["ContractedQuantity"].Value.ToString() != "" && ultraGridRow.Cells["Jhlc"].Value.ToString() != "" && 
                             ultraGridRow.Cells["OuterDiam"].Value.ToString() != "" && ultraGridRow.Cells["ControlsThickness"].Value.ToString() != ""
                             && ultraGridRow.Cells["Cpcd"].Value.ToString() != "" && ultraGridRow.Cells["Ggfqs"].Value.ToString() != "" && Dbcplzl != 0)
                         {
                             //采购量Max公式：（(合同量+（合同量*交货量差))/((外径-控制壁厚)*控制壁厚*成品长度*0.02466/1000)/钢管分切数*单倍尺坯料重量
                             ultraGridRow.Cells["HtcgzlMax"].Value = ((ContractedQuantity + (ContractedQuantity * Jhlc)) / ((OuterDiam - ControlsThickness) * ControlsThickness * Cpcd * decimal.Parse("0.02466") / 1000) / Ggfqs * Dbcplzl);
                            
                             //采购量Min公式：（合同量/((外径-控制壁厚)*控制壁厚*成品长度*0.02466/1000)/钢管分切数*单倍尺坯料重量
                             ultraGridRow.Cells["HtcgzlMin"].Value = ((ContractedQuantity) / ((OuterDiam - ControlsThickness) * ControlsThickness * Cpcd * decimal.Parse("0.02466") / 1000) / Ggfqs * Dbcplzl);
                          

                             //ultraGridRow.Cells["QuantityPurchased"].Value = ((ContractedQuantity + (ContractedQuantity * Jhlc)) / ((OuterDiam - ControlsThickness) * ControlsThickness * Cpcd * decimal.Parse("0.02466") / 1000) / Ggfqs * Dbcplzl);
                           
                         }

                             if (ultraGridRow.Cells["Gpzj"].Value.ToString() != "" && ultraGridRow.Cells["WgD"].Value.ToString() != "" && ultraGridRow.Cells["WgH"].Value.ToString() != "" && Dbcplcd != 0)
                             {
                                   //毛管长度公式：((管坯直径/2)*(管坯直径/2))*单倍尺坯料长度/(((毛管外径/2)*(毛管外径/2))-(((毛管外径/2)-毛管壁厚)*((毛管外径/2)-毛管壁厚)))/1000
                                 ultraGridRow.Cells["Mgcd"].Value = ((Gpzj / 2) * (Gpzj / 2)) * Dbcplcd / (((WgD / 2) * (WgD / 2)) - (((WgD / 2) - WgH) * ((WgD / 2) - WgH))) / 1000;                                                                    
                             }
                         


                    }
                }
            }
            catch (Exception)
            {

            }
        
        }


        /// <summary>
        /// 删除检修计划
        /// </summary>
        public void DeleteRepairPlan()
        {
            ArrayList list = ProducHelper.GetChcRows<PlnOrderZgSEntity>(ultraGridZgS);
            bool flag = ProducHelper.DeleteRepairPlan(list, "D", this.ob);
            if (flag)
            {
                _ProPlanId = ((PlnOrderZgSEntity)list[0]).ProPlanId;
                _GxPlanNo = ((PlnOrderZgSEntity)list[0]).GxPlanNo;
                Query();
            }
        }

        private void comPline_ValueChanged(object sender, EventArgs e)
        {
            //if (comPline == null)
            //{ return; }
            //else
            //{ if (!CustomInfo.Equals("0")) { } }
        }

        /// <summary>
        /// 下发(取消)
        /// </summary>
        private void Issued(string isFlag)
        {
            IQueryable<UltraGridRow> checkRows = ultraGridZgS.Rows.AsQueryable().Where("CHC = 'True'");

            if (checkRows.Count() == 0)
            {
                MessageUtil.ShowWarning("请选择订单!");
                return;
            }
            if (isFlag.Equals("0"))
            {int count=0;
                foreach (UltraGridRow row in checkRows)
                {
                    
                    if (row.Cells["LenCuthead"].Text.Trim().Equals(""))
                    {
                        MessageUtil.ShowTips("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",切头无数据，不允许确认！");
                        return;
                    }
                    if (row.Cells["LenCutend"].Text.Trim().Equals(""))
                    {
                        MessageUtil.ShowTips("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",切尾无数据，不允许确认！");
                        return;
                    }

                    if (!row.Cells["Verify1"].Text.Trim().Equals(""))
                    {

                        string str = row.Cells["Verify1"].Text.Trim();
                        string[] strArray = str.Split(new char[2] { '：', 'm' });
                        double len = double.Parse(strArray[1].ToString());
                        if (len - 4 > 0)
                        {
                            if (MessageUtil.ShowYesNoAndQuestion("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",管余长大于4m,是否确认！") == DialogResult.No) return;
                        }
                        if (len < 0)
                        {
                            if (MessageUtil.ShowYesNoAndQuestion("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",管余长小于0,是否确认！") == DialogResult.No) return;
                        }
                    }
                    if (double.Parse(row.Cells["Aimlength"].Value.ToString()) >= 13.5 && row.Cells["WholeBacklogDesc"].Text.Trim().Contains("热处理"))
                    {
                        if (MessageUtil.ShowYesNoAndQuestion("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",目标长度可能超限,需热处理确认长度,是否确认！") == DialogResult.No) return;
                        
                    }
                    //if (!row.Cells["Verify2"].Text.Trim().Equals(""))
                    //{
                    //    MessageUtil.ShowTips("长度超出范围！");
                    //    return;
                    //}
                    int numS = 0;//排产支
                    int plansNum = 0;//计划产出支
                    if (!row.Cells["NumS"].Text.ToString().Trim().Equals(""))
                    {
                        numS = int.Parse(row.Cells["NumS"].Value.ToString());
                    }
                    if (!row.Cells["PlansNum"].Text.ToString().Trim().Equals(""))
                    {
                        plansNum = int.Parse(row.Cells["PlansNum"].Value.ToString());
                    }
                    if (numS <= 0)
                    {
                        MessageUtil.ShowTips("排产支数小于等于0！");
                        return;
                    }
                    int num = plansNum / numS;
                    if (!row.Cells["Verify3"].Text.Trim().Equals("") || num > 2)
                    {
                     count++;
                     //if (MessageUtil.ShowYesNoAndQuestion("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",连轧后长度小于托管机最短,脱不出或计划产出支除以排产支大于2,是否继续？") == DialogResult.No) return;
                    }
                    //if (row.Cells["CicGp"].Text.Trim().Equals(""))
                    //{
                    //    MessageUtil.ShowTips("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",钢种索引码为空！");
                    //    return;
                    //}
                    if (!row.Cells["LengthdiscN"].Text.Trim().Equals("") && row.Cells["ApplyStatus"].Text.Trim().Equals(""))
                    {
                        MessageUtil.ShowTips("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",推荐合同长度未申请！");
                        return;

                    }
                    if (row.Cells["ApplyStatus"].Text.Trim().Equals("申请"))
                    {
                        MessageUtil.ShowTips("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",推荐合同长度未审核！");
                        return;

                    }
                }
                if (count>0)
                {
                    if (MessageUtil.ShowYesNoAndQuestion("其中有" + count + "条,连轧后长度小于托管机最短,脱不出或计划产出支除以排产支大于2,是否继续？") == DialogResult.No) return;
               }
            }
            else if (isFlag.Equals("2"))
            {
                string porderstatus = "";//合同状态
                foreach (UltraGridRow row in checkRows)
                {
                    DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.doQueryPorderstatus", new object[] { row.Cells["OrdLnDlyPk"].Text.Trim() }, ob);
                    if (dt.Rows.Count > 0)
                    {
                        porderstatus = dt.Rows[0]["PORDERSTATUS"].ToString();
                    }
                    if (porderstatus.Equals("4") || porderstatus.Equals("5"))
                    {
                        MessageUtil.ShowTips("该合同已生产完成或关闭，请联系销售！");
                        return;
                    }
                    //if (row.Cells["IsPlanOk"].Text.Trim().Equals("是"))
                    //{
                    //    MessageUtil.ShowTips("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",未确认,不允许炉计划下发！");
                    //    return;
                    //}
                    //if (row.Cells["ZyBatchId"].Text.Equals(""))
                    //{
                    //    MessageUtil.ShowWarning("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",轧批号不能为空!");
                    //    return;
                    //}
                }
            }
            //else if (isFlag.Equals("3"))
            //{//取消炉计划下发
            //    foreach (UltraGridRow row in checkRows)
            //    {
            //        int numz = 0;
            //        double wtz = 0;
            //        if (!row.Cells["FurnaNum"].Text.ToString().Equals(""))
            //        {
            //            numz = int.Parse(row.Cells["FurnaNum"].Value.ToString());
            //            wtz = double.Parse(row.Cells["FurnaWeight"].Value.ToString());
            //        }
            //        int numLj = 0;
            //        double wtLj = 0;
            //        if (!row.Cells["LjNum"].Text.ToString().Equals(""))
            //        {
            //            numLj = int.Parse(row.Cells["LjNum"].Value.ToString());
            //            wtLj = double.Parse(row.Cells["LjWeight"].Value.ToString());
            //        }
            //        int batNum = 0;
            //        double batWt = 0;
            //        if (!row.Cells["CkNum"].Text.ToString().Equals(""))
            //        {
            //            batNum = int.Parse(row.Cells["CkNum"].Value.ToString());
            //            batWt = double.Parse(row.Cells["CkWeight"].Value.ToString());
            //        }
            //        //int num = numz + numLj + batNum;
            //        if (numz > 0)
            //        {
            //            MessageUtil.ShowWarning("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",已装炉,不能撤销下发!");
            //        return;
            //        }
            //        if (numLj > 0)
            //        {
            //            MessageUtil.ShowWarning("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",已LJ,不能撤销下发!");
            //            return;
            //        }
            //        if (batNum > 0)
            //        {
            //            MessageUtil.ShowWarning("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",已出库,不能撤销下发!");
            //            return;
            //        }
            //    }
            //}
            //else if (isFlag.Equals("1"))
            //{
            //    foreach (UltraGridRow row in checkRows)
            //    {
            //        if (row.Cells["IfStoveIssued"].Text.Trim().Equals("是"))
            //        {
            //            MessageUtil.ShowTips("轧管订单:" + row.Cells["ProPlanId"].Text + "/" + row.Cells["GxPlanNo"].Text + ",已炉计划下发！");
            //            return;
            //        }
            //    }
            //}
            ArrayList list = ProducHelper.GetChcRows<PlnOrderZgSEntity>(ultraGridZgS);
            bool flag = ProducHelper.issuedPlanOrder(list, UserInfo.GetUserName(), isFlag, "D", this.ob);
            if (flag)
            {
                _ProPlanId = ((PlnOrderZgSEntity)list[0]).ProPlanId;
                _GxPlanNo = ((PlnOrderZgSEntity)list[0]).GxPlanNo;
                Query();
            }
        }

        private void ultraGridZgS_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
        {
            foreach (UltraGridRow uRow in ultraGridZgS.Selected.Rows)
            {
                if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
                {
                    uRow.Cells["CHC"].Value = true;
                }
            }
        }

        private void ultraGridZgS_ClickCellButton(object sender, CellEventArgs e)
        {
            UltraGridRow row = ultraGridZgS.ActiveRow;
            if (e.Cell.Column.Key.Equals("CraftFileNo"))
            {
                string filePath = row.GetValue("CraftPath");
                dlgOrderAskDown askDown = new dlgOrderAskDown(this.ob, filePath);
                askDown.Show();
            }
            else if (e.Cell.Column.Key.Equals("CraftFileLv2G"))
            {
                string craftFileLv2G = row.GetValue("CraftFileLv2GPath");
                dlgOrderAskDown askDown = new dlgOrderAskDown(this.ob, craftFileLv2G);
                askDown.Show();
            }
            else if (e.Cell.Column.Key.Equals("DiameterGp"))
            {

                string exeStatus = row.GetValue("ExeStatus");
                if (!exeStatus.Equals("计划") && !exeStatus.Equals("生产中"))
                {
                    return;
                }
                string ordLnDlyPk = row.GetValue("OrdLnDlyPk");
                string proPlanId = row.GetValue("ProPlanId");
                string gxPlanNo = row.GetValue("GxPlanNo");
                string gradeCode = row.GetValue("GradeCode");
                if (gradeCode.Equals(""))
                {
                    return;
                }
                 string[] groupCic = null;
                if (!row.GetValue("GradeCode").Equals(""))
                {
                    groupCic = row.Cells["CicGroupGp"].Text.ToString().Split(',');
                }
                string cicGp = row.GetValue("CicGp");
                //int numz = 0;
                //double wtz = 0;
                //if (!row.Cells["FurnaNum"].Text.ToString().Equals(""))
                //{
                //    numz = int.Parse(row.Cells["FurnaNum"].Value.ToString());
                //    wtz = double.Parse(row.Cells["FurnaWeight"].Value.ToString());
                //}
                int numLj = 0;
                double wtLj = 0;
                //if (!row.Cells["LjNum"].Value.ToString().Equals("0"))
                //{
                    numLj = int.Parse(row.Cells["LjNum"].Value.ToString());
                    wtLj = double.Parse(row.Cells["LjWeight"].Value.ToString());
                //}
                //else
                //{
                //    numLj = int.Parse(row.Cells["MatchNumIn"].Value.ToString());
                //    wtLj = double.Parse(row.Cells["MatchWtIn"].Value.ToString());
                //}
                //int batNum = 0;
                //double batWt = 0;
                //if (!row.Cells["CkNum"].Text.ToString().Equals(""))
                //{
                //    batNum = int.Parse(row.Cells["CkNum"].Value.ToString());
                //    batWt = double.Parse(row.Cells["CkWeight"].Value.ToString());
                //}
                //int num = numz + numLj + batNum;
                int num = numLj;
                FrmBomConfirm frmBomConfirm = new FrmBomConfirm(ordLnDlyPk, proPlanId, gxPlanNo, this.ob, groupCic, cicGp,num);
                frmBomConfirm.ShowDialog();
                bool flag = frmBomConfirm.Flag;
                if (flag) { Query(); }//如果有修改数据，则刷新页面

            }
            else if (e.Cell.Column.Key.Equals("Gradename"))
            {

                string exeStatus = row.GetValue("ExeStatus");
                if (!exeStatus.Equals("计划") && !exeStatus.Equals("生产中"))
                {
                    return;
                }
                string ordLnDlyPk = row.GetValue("OrdLnDlyPk");
                string proPlanId = row.GetValue("ProPlanId");
                string gxPlanNo = row.GetValue("GxPlanNo");
                string gradeCode = row.GetValue("GradeCode");

                if (gradeCode.Equals(""))
                {
                    return;
                }
                string[] groupCic = null;
                if (!row.GetValue("GradeCode").Equals(""))
                {
                    groupCic = row.Cells["CicGroupGp"].Text.ToString().Split(',');
                }
                string cicGp = row.GetValue("CicGp");
                int numz = 0;
                double wtz = 0;
                //if (!row.Cells["FurnaNum"].Text.ToString().Equals(""))
                //{
                //    numz = int.Parse(row.Cells["FurnaNum"].Value.ToString());
                //    wtz = double.Parse(row.Cells["FurnaWeight"].Value.ToString());
                //}
                int numLj = 0;
                double wtLj = 0;
                //if (!row.Cells["LjNum"].Text.ToString().Equals(""))
                //{
                    numLj = int.Parse(row.Cells["LjNum"].Value.ToString());
                    wtLj = double.Parse(row.Cells["LjWeight"].Value.ToString());
                //}
                //int batNum = 0;
                //double batWt = 0;
                //if (!row.Cells["CkNum"].Text.ToString().Equals(""))
                //{
                //    batNum = int.Parse(row.Cells["CkNum"].Value.ToString());
                //    batWt = double.Parse(row.Cells["CkWeight"].Value.ToString());
                //}
                int num = numLj ;
                FrmBomConfirm frmBomConfirm = new FrmBomConfirm(ordLnDlyPk, proPlanId, gxPlanNo, this.ob, groupCic, cicGp,num);
                frmBomConfirm.ShowDialog();
                bool flag = frmBomConfirm.Flag;
                if (flag) { Query(); }//如果有修改数据，则刷新页面
            }
            else if (e.Cell.Column.Key.Equals("AfProLin"))
            {
                string proPlanId = row.GetValue("ProPlanId");
                string afInfo = row.GetValue("AfInfo");
                if (afInfo == null || afInfo.Length == 0) { return; }
                FrmPreGxInfo frmPreGxInfo = new FrmPreGxInfo(proPlanId, "D", "Af", this.ob);
                frmPreGxInfo.ShowDialog();
            }
            else if (e.Cell.Column.Key.Equals("DiameterMandrel"))
            {
                 //InitDimaM(ugr.Cells["PlineCode"].Text.ToString().Trim(), ugr.Cells["PassCode"].Text.ToString().Trim(), ugr.Cells["Aimoutdiameter"].Text.ToString().Trim(), ugr.Cells["Aimwallthick"].Text.ToString().Trim());
                FrmDiameterMandrel frmDm = new FrmDiameterMandrel(row.GetValue("PlineCode"), row.GetValue("PassCode"), row.GetValue("Aimoutdiameter"), row.GetValue("Aimwallthick"), this.ob);
                frmDm.AutoSize = true;
                //frmDm.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
                frmDm.Text = "芯棒直径";
                frmDm.ShowDialog();
                if (frmDm.DialogResult == System.Windows.Forms.DialogResult.OK)
                {
                    //获取弹出窗体的属性值
                    row.Cells["DiameterMandrel"].Value = frmDm.DiameterMandrel;
                    if (!frmDm.LenSingerBill.Equals("0") && double.Parse(frmDm.LenSingerBill) < double.Parse(row.Cells["LenGpSingle"].Value.ToString()))
                    {
                        row.Cells["LenGpSingle"].Value = frmDm.LenSingerBill;
                    }
                }

            }
            else if (e.Cell.Column.Key.Equals("ApplyNo"))
            {
                UndoApply();
            }
            else if (e.Cell.Column.Key.Equals("LengthdiscN"))
            {
                if (row.GetValue("OrdLnDlyPk").Contains("ZZBY-"))
                {
                    MessageUtil.ShowTips("该合同是备料需求合同,不允许修改推荐长度描述！");
                    return;
                }
                if (row.GetValue("ApplyStatus") == "审批通过" || row.GetValue("ApplyStatus") == "审批不通过")
                {
                    MessageUtil.ShowTips("该合同:" + row.GetValue("OrderNo") + ",已" + row.GetValue("ApplyStatus") + ",不允许修改推荐长度描述！");
                    return;
                }
                string len = row.GetValue("LenNo");//合同长度编码          
                string LenNoN = row.GetValue("LenNoN");//推荐长度编码

                frmOrderLenPln lenPln = new frmOrderLenPln(ob, len, LenNoN);
                lenPln.ShowDialog();
                if (lenPln.DialogResult == System.Windows.Forms.DialogResult.OK)
                {
                    //获取弹出窗体的属性值
                    row.Cells["LenNoN"].Value = lenPln.LenNo;
                    row.Cells["LengthdiscN"].Value = lenPln.LengthdiscN;

                }
            }
        }
        

        /// <summary>
        /// 设置完成
        /// </summary>
        private void SetPlanFinish()
        {
            ArrayList list = ProducHelper.GetChcRows<PlnOrderZgSEntity>(ultraGridZgS);
            bool flag = ProducHelper.SetPlanFinish(list, UserInfo.GetUserName(), "D", this.ob);
            if (flag)
            {
                _ProPlanId = ((PlnOrderZgSEntity)list[0]).ProPlanId;
                _GxPlanNo = ((PlnOrderZgSEntity)list[0]).GxPlanNo;
                Query();
            }
        }


        /// <summary>
        /// 调整单倍坯长
        /// </summary>
        private void ModifyGpAimWall()
        {
            this.ultraGridZgS.UpdateData();
            ArrayList list = ProducHelper.GetChcRows<TPoDemandPlanEntity>(ultraGridZgS);
            if (list == null || list.Count == 0)
            {
                MessageUtil.ShowTips("请选择订单！");
                return;
            }
            ArrayList jsonList = new ArrayList();
            foreach (TPoDemandPlanEntity entity in list)
            {
                if (entity.QuantityPurchased == null)
                {
                    MessageUtil.ShowTips("请输入采购量!");
                    return;
                }

                jsonList.Add(JSONFormat.Format(entity));
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否报错?") == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.GpOptimize.CorePlnZgMStoGp";
            ccp.MethodName = "modifyGpAimWall";
            ccp.ServerParams = new object[] { jsonList, "0" };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips("修改成功!");
                if (ccp.ReturnObject != null)
                {
                    List<string> message = (List<string>)JsonConvert.DeserializeObject(
                        ccp.ReturnObject.ToString(), typeof(List<string>));
                    if (message.Count == 0)
                    {
                        MessageUtil.ShowTips(list.Count - message.Count + "条修改成功，"
                        + message.Count + "条修改失败。");
                    }
                    else
                    {
                        MessageUtil.ShowTips(list.Count - message.Count + "条修改成功，"
                        + message.Count + "条修改失败。\n" + message[0]);
                    }
                    if (list.Count - message.Count>0)
                    {
                           Query();
                    }
                }
            }
         
        }
        /// <summary>
        /// 调整控制壁厚
        /// </summary>
        private void ModifyThicknesWall()
        {
            this.ultraGridZgS.UpdateData();
            ArrayList list = ProducHelper.GetChcRows<PlnOrderZgSEntity>(ultraGridZgS);
            if (list == null || list.Count == 0)
            {
                MessageUtil.ShowTips("请选择订单！");
                return;
            }
            ArrayList jsonList = new ArrayList();
            foreach (PlnOrderZgSEntity entity in list)
            {
                if (entity.IsRepairPln.Equals("是"))
                {
                    MessageUtil.ShowTips("检修计划不能调整控制壁厚!");
                    return;
                }
                jsonList.Add(JSONFormat.Format(entity));
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否修改控制壁厚?") == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.GpOptimize.CorePlnZgMStoGp";
            ccp.MethodName = "modifyThicknesWall";
            ccp.ServerParams = new object[] { jsonList,this.UserInfo.GetUserName() };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("调整控制壁厚成功!"))
            {
                Query();
            }      
        }
        /// <summary>
        /// 修改芯棒直接
        /// </summary>
        private void UpdateDiameM()
        {
            try
            {
                ArrayList messageErr = new ArrayList();
                ultraGridZgS.UpdateData();
                ArrayList list = new ArrayList();
                //IQueryable<UltraGridRow> checkRows = ultraGridZgS.Rows.AsQueryable().Where("CHC = 'True'");
                ArrayList list1 = ProducHelper.GetChcRows<PlnOrderZgSEntity>(ultraGridZgS);
                if (list1 == null || list1.Count == 0)
                {
                    MessageUtil.ShowTips("请选择订单！");
                    return;
                }
               
                foreach (PlnOrderZgSEntity entity in list1)
                {
                    if (entity.IsRepairPln.Equals("是"))
                    {
                        MessageUtil.ShowTips("检修计划不能调整芯棒!");
                        return;
                    }
                    if (entity.DiameterMandrel==null||entity.DiameterMandrel.Equals(""))
                    {
                        PlanComm.WaitFromColse(this.Cursor);
                        MessageUtil.ShowWarning("芯棒不能为空,请选择芯棒!");        
                        return;

                    }
                    ArrayList param = new ArrayList();
                    param.Add(entity.ProPlanId);
                    param.Add(entity.GxPlanNo);
                    param.Add(entity.DiameterMandrel.ToString());
                    list.Add(param);

                }
                if (list.Count == 0)
                {
                    PlanComm.WaitFromColse(this.Cursor);
                    MessageUtil.ShowTips("0条修改成功，" + messageErr.Count + "条修改失败。\n" + messageErr[0]);
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否调整芯棒直径?") == DialogResult.No)
                {
                    return;
                }
                PlanComm.WaitFromOpen(this.Cursor);
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.pss.plnsaleord.processOrder.base.ProducHelper";
                ccp.MethodName = "updateDimaM";
                ccp.ServerParams = new object[] { list };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                PlanComm.WaitFromColse(this.Cursor);
                if (ccp.ReturnCode == -1) return;
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("芯棒直径调整成功！"))
                {
                    Query();
                }
            }
            catch (Exception ex)
            {
                PlanComm.WaitFromColse(this.Cursor);
                if (!(ex is MESException))
                {
                    MessageUtil.ShowError(ex.Message);
                }
            }
        }

        /// <summary>
        /// 保存
        /// </summary>
        private void Recalculate()
        {
            try
            {
                ArrayList messageErr = new ArrayList();
                ultraGridZgS.UpdateData();
                ArrayList list = ProducHelper.GetChcRows<TPoDemandPlanEntity>(ultraGridZgS);
                if (list == null || list.Count == 0)
                {
                    MessageUtil.ShowTips("请选择订单！");
                    return;
                }
                
                ArrayList jsonList = new ArrayList();
                foreach (TPoDemandPlanEntity entity in list)
                {
                    if (entity.QuantityPurchased == null)
                    {
                        MessageUtil.ShowTips("请输入采购量!");
                        return;
                    }
                   
                    jsonList.Add(JSONFormat.Format(entity));
                }
                
                if (MessageUtil.ShowYesNoAndQuestion("是否保存结果?") == DialogResult.No)
                {
                    return;
                }
                PlanComm.WaitFromOpen(this.Cursor);
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.pss.plnsaleord.GpOptimize.CorePlnZgMStoGp";
                ccp.MethodName = "recalculate3";
                ccp.ServerParams = new object[] { jsonList };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                PlanComm.WaitFromColse(this.Cursor);
                if (ccp.ReturnCode == -1) return;
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("保存完成!"))
                {
                    Query();
                }
            }
            catch (Exception ex)
            {
                PlanComm.WaitFromColse(this.Cursor);
                if (!(ex is MESException))
                {
                    MessageUtil.ShowError(ex.Message);
                }
            }
        }

        /// <summary>
        /// 上传
        /// </summary>
        private void Recalculate2()
        {
            try
            {
                ArrayList messageErr = new ArrayList();
                ultraGridZgS.UpdateData();
                ArrayList list = ProducHelper.GetChcRows<TPoDemandPlanEntity>(ultraGridZgS);
                if (list == null || list.Count == 0)
                {
                    MessageUtil.ShowTips("请选择订单！");
                    return;
                }

                ArrayList jsonList = new ArrayList();
                foreach (TPoDemandPlanEntity entity in list)
                {
                    if (entity.QuantityPurchased == null)
                    {
                        MessageUtil.ShowTips("请输入采购量!");
                        return;
                    }

                    if (entity.QuantityPurchased == '0')
                    {
                        MessageUtil.ShowTips("采购量不能为0!");
                        return;
                    }

                    jsonList.Add(JSONFormat.Format(entity));
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否上传结果?") == DialogResult.No)
                {
                    return;
                }
                PlanComm.WaitFromOpen(this.Cursor);
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.pss.plnsaleord.GpOptimize.CorePlnZgMStoGp";
                ccp.MethodName = "recalculate4";
                ccp.ServerParams = new object[] { jsonList };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                PlanComm.WaitFromColse(this.Cursor);
                if (ccp.ReturnCode == -1) return;
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("上传完成!"))
                {
                    Query();
                }
            }
            catch (Exception ex)
            {
                PlanComm.WaitFromColse(this.Cursor);
                if (!(ex is MESException))
                {
                    MessageUtil.ShowError(ex.Message);
                }
            }
        }

        /// <summary>
        ///修改排产月份
        /// </summary>
        private void UpdateMonth()
        {
            try
            {
                ArrayList messageErr = new ArrayList();
                ultraGridZgS.UpdateData();
                ArrayList list = ProducHelper.GetChcRows<PlnOrderZgSEntity>(ultraGridZgS);
                if (list == null || list.Count == 0)
                {
                    MessageUtil.ShowTips("请选择订单！");
                    return;
                }
                ArrayList jsonList = new ArrayList();
                foreach (PlnOrderZgSEntity entity in list)
                {
                    entity.ProMonth = DateTime.Parse(entity.ProMonth.ToString()).ToString("yyyy-MM");
                    jsonList.Add(JSONFormat.Format(entity));
                } 
                if (MessageUtil.ShowYesNoAndQuestion("是否调整生产年月?") == DialogResult.No)
                {
                    return;
                }
                PlanComm.WaitFromOpen(this.Cursor);
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.pss.plnsaleord.GpOptimize.CorePlnZgMStoGp";
                ccp.MethodName = "updateMonth";
                ccp.ServerParams = new object[] { jsonList };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                PlanComm.WaitFromColse(this.Cursor);
                if (ccp.ReturnCode == -1) return;
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("调整成功!"))
                {
                    //ArrayList list1 = ProducHelper.GetChcRows<PlnOrderZgSEntity>(ultraGridZgS);
                    //bool flag =InitDataMonth(list1, "D", this.ob);
                    //if (flag)
                    //{
                    //    _ProPlanId = ((PlnOrderZgSEntity)list[0]).ProPlanId;
                    //    _GxPlanNo = ((PlnOrderZgSEntity)list[0]).GxPlanNo;
                    Query();
                    //}
                }
            }
            catch (Exception ex)
            {
                MessageUtil.ShowTips("请输入正确的时间格式!");
            }
        }
        public static bool InitDataMonth(ArrayList entityList, string processCode, OpeBase ob)
        {
            if (entityList == null)
            {
                MessageUtil.ShowWarning("请选择订单!");
                return false;
            }
            ArrayList jsonlist = new ArrayList();
            foreach (Object obj in entityList)
            {
                ProducEntity entity = ProducHelper.GenerationProEntity(obj, processCode);
                if (entity.IfStoveIssued.Equals("是"))
                {
                    MessageUtil.ShowWarning("订单编号(" + entity.ProPlanId + ") 炉计划下发!");
                    return false;
                }
                if (entity.PlanUseTime == null || entity.PlanUseTime.Equals(""))
                {
                    MessageUtil.ShowWarning("计划耗时不能为空!");
                    return false;
                }

                jsonlist.Add(entity.JsonStr);
            }
            string[] param = PlanHelper.SetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.initData", new object[] { jsonlist, processCode }, ob);
            if (param == null) { MessageUtil.ShowTips("服务端处理失败!"); return false; }
            else
            {
                //MessageUtil.ShowTips(param[1]);
                if ((bool.Parse(param[0]))) { return true; } else { return false; }
            }
        }

        /// <summary>
        /// 申请审批
        /// </summary>
        private void ApplyApproval()
        {
            ArrayList messageErr = new ArrayList();
            ultraGridZgS.UpdateData();
            ArrayList list = ProducHelper.GetChcRows<PlnOrderZgSEntity>(ultraGridZgS);
            if (list == null || list.Count == 0)
            {
                MessageUtil.ShowTips("请选择订单！");
                return;
            }
            ArrayList jsonList = new ArrayList();
            foreach (PlnOrderZgSEntity entity in list)
            {
                if (entity.LenNoN == null)
                {
                    MessageUtil.ShowTips("无推荐长度,不允许申请！");
                    return;
                }
                jsonList.Add(JSONFormat.Format(entity));
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否申请?") == DialogResult.No)
            {
                return;
            }
            PlanComm.WaitFromOpen(this.Cursor);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.GpOptimize.CorePlnZgMStoGp";
            ccp.MethodName = "applyApproval";
            ccp.ServerParams = new object[] { jsonList, this.UserInfo.GetUserName() };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

            PlanComm.WaitFromColse(this.Cursor);
            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("申请成功!"))
            {
                Query();
            }
        }
        /// <summary>
        /// 撤销申请单
        /// </summary>
        private void UndoApply()
        {
            ultraGridZgS.UpdateData();
            UltraGridRow ugrM = ultraGridZgS.ActiveRow;
            if (ugrM == null)
            {
                return;
            }
            if (ugrM.Cells["ApplyNo"].Text.ToString().Equals(""))
            {
                MessageUtil.ShowTips("合同号：" + ugrM.Cells["OrderNo"].Value.ToString() + "未申请,不允许此操作！");
                return;

            }
            ArrayList jsonList = new ArrayList();
            jsonList.Add(ugrM.Cells["ApplyNo"].Value.ToString());
            jsonList.Add(ugrM.Cells["OrdLnDlyPk"].Value.ToString());
            jsonList.Add(ugrM.Cells["ProPlanId"].Value.ToString());
            jsonList.Add(ugrM.Cells["GxPlanNo"].Value.ToString());
            jsonList.Add(ugrM.Cells["LenNoN"].Value.ToString());
            if (MessageUtil.ShowYesNoAndQuestion("是否撤销申请?") == DialogResult.No)
            {
                return;
            }
            PlanComm.WaitFromOpen(this.Cursor);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.GpOptimize.CorePlnZgMStoGp";
            ccp.MethodName = "undoApplyApproval";
            ccp.ServerParams = new object[] { jsonList };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

            PlanComm.WaitFromColse(this.Cursor);
            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("撤销申请成功!"))
            {
                Query();
            }
        }

        /// <summary>
        /// 修改坯子
        /// </summary>
        private void ModifyBatter()
        {
            ArrayList messageErr = new ArrayList();
            ultraGridZgS.UpdateData();
            ArrayList list = ProducHelper.GetChcRows<PlnOrderZgSEntity>(ultraGridZgS);
            if (list == null || list.Count == 0)
            {
                MessageUtil.ShowTips("请选择订单！");
                return;
            }
            ArrayList jsonList = new ArrayList();
            foreach (PlnOrderZgSEntity entity in list)
            {
                entity.OutsBilletFl.ToString();
                jsonList.Add(JSONFormat.Format(entity));
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否修改?") == DialogResult.No)
            {
                return;
            }
            PlanComm.WaitFromOpen(this.Cursor);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.GpOptimize.CorePlnZgMStoGp";
            ccp.MethodName = "modifyBatter";
            ccp.ServerParams = new object[] { jsonList, this.UserInfo.GetUserName() };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

            PlanComm.WaitFromColse(this.Cursor);
            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("修改成功!"))
            {
                Query();
            }
        }

        private void ultraGridZgS_KeyUp(object sender, KeyEventArgs e)
        {
            PlanComm.setGridCopyActColumn(this.ultraGridZgS, "CHC", e,
              "OutsBilletFl", "ProMonth");
        }

        /// <summary>
        /// 修改索引码
        /// </summary>
        private void UpdateGroupGp()
        {
            ArrayList messageErr = new ArrayList();
            ultraGridZgS.UpdateData();
            ArrayList list = ProducHelper.GetChcRows<PlnOrderZgSEntity>(ultraGridZgS);
            if (list == null || list.Count == 0)
            {
                MessageUtil.ShowTips("请选择订单！");
                return;
            }
            ArrayList jsonList = new ArrayList();
            foreach (PlnOrderZgSEntity entity in list)
            {
                entity.OutsBilletFl.ToString();
                jsonList.Add(JSONFormat.Format(entity));
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否修改?") == DialogResult.No)
            {
                return;
            }
            PlanComm.WaitFromOpen(this.Cursor);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.GpOptimize.CorePlnZgMStoGp";
            ccp.MethodName = "updateGroupGp";
            ccp.ServerParams = new object[] { jsonList };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

            PlanComm.WaitFromColse(this.Cursor);
            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("修改成功!"))
            {
                Query();
            }
        }
        /// <summary>
        /// 修改轧批号
        /// </summary>
        private void UpdateBatch()
        {
            ArrayList messageErr = new ArrayList();
            ultraGridZgS.UpdateData();
            ArrayList list = ProducHelper.GetChcRows<PlnOrderZgSEntity>(ultraGridZgS);
            if (list == null || list.Count == 0)
            {
                MessageUtil.ShowTips("请选择订单！");
                return;
            }
            ArrayList jsonList = new ArrayList();
            foreach (PlnOrderZgSEntity entity in list)
            {
                entity.ZyBatchId.ToString();
                jsonList.Add(JSONFormat.Format(entity));
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否轧批号修改?") == DialogResult.No)
            {
                return;
            }
            PlanComm.WaitFromOpen(this.Cursor);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.GpOptimize.CorePlnZgMStoGp";
            ccp.MethodName = "updateBatch";
            ccp.ServerParams = new object[] { jsonList };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

            PlanComm.WaitFromColse(this.Cursor);
            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("修改成功!"))
            {
                Query();
            }
        }
        /// <summary>
        /// 修改判定字头
        /// </summary>
        private void DoDecision()
        {
            ArrayList messageErr = new ArrayList();
            ultraGridZgS.UpdateData();
            ArrayList list = ProducHelper.GetChcRows<PlnOrderZgSEntity>(ultraGridZgS);
            if (list == null || list.Count == 0)
            {
                MessageUtil.ShowTips("请选择订单！");
                return;
            }
            ArrayList jsonList = new ArrayList();
            foreach (PlnOrderZgSEntity entity in list)
            {
                entity.Decision.ToString();
                jsonList.Add(JSONFormat.Format(entity));
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否判定字头修改?") == DialogResult.No)
            {
                return;
            }
            PlanComm.WaitFromOpen(this.Cursor);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.GpOptimize.CorePlnZgMStoGp";
            ccp.MethodName = "doDecision";
            ccp.ServerParams = new object[] { jsonList };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

            PlanComm.WaitFromColse(this.Cursor);
            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("修改成功!"))
            {
                Query();
            }
        }
        /// <summary>
        /// 导入
        /// </summary>
        private void DoImport()
        {
            try
            {
                OpenFileDialog dialog = new OpenFileDialog();
                if (dialog.ShowDialog() == DialogResult.OK)
                {
                    FrmImportSetPlnZg import = new FrmImportSetPlnZg(this.ob);
                    import.ModelPatch = dialog.FileName;
                    import.ShowDialog();
                   
                }
                Query();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
          
        }
        /// <summary>
        /// 修改工艺备注
        /// </summary>
        private void DoProMemo(string falsg)
        {
            ArrayList messageErr = new ArrayList();
            ultraGridZgS.UpdateData();
            ArrayList list = ProducHelper.GetChcRows<PlnOrderZgSEntity>(ultraGridZgS);
            if (list == null || list.Count == 0)
            {
                MessageUtil.ShowTips("请选择订单！");
                return;
            }
            ArrayList jsonList = new ArrayList();
            foreach (PlnOrderZgSEntity entity in list)
            {
                entity.Memo.ToString();
                jsonList.Add(JSONFormat.Format(entity));
            }
            if (MessageUtil.ShowYesNoAndQuestion(falsg.Equals("0") ? "是否工艺备注修改?" : "是否计划备注修改?") == DialogResult.No)
            {
                return;
            }
            PlanComm.WaitFromOpen(this.Cursor);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.GpOptimize.CorePlnZgMStoGp";
            ccp.MethodName = "doProMemo";
            ccp.ServerParams = new object[] { jsonList, falsg };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

            PlanComm.WaitFromColse(this.Cursor);
            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("修改成功!"))
            {
                Query();
            }
        }
        /// <summary>
        /// 主被动修改
        /// </summary>
        private void DoUpdatePase()
        {
            ArrayList messageErr = new ArrayList();
            ultraGridZgS.UpdateData();
            ArrayList list = ProducHelper.GetChcRows<PlnOrderZgSEntity>(ultraGridZgS);
            if (list == null || list.Count == 0)
            {
                MessageUtil.ShowTips("请选择订单！");
                return;
            }
            ArrayList jsonList = new ArrayList();
            foreach (PlnOrderZgSEntity entity in list)
            {
                entity.Passive.ToString();
                jsonList.Add(JSONFormat.Format(entity));
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认修改主被动?") == DialogResult.No)
            {
                return;
            }
            PlanComm.WaitFromOpen(this.Cursor);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.GpOptimize.CorePlnZgMStoGp";
            ccp.MethodName = "doUpdatePase";
            ccp.ServerParams = new object[] { jsonList };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

            PlanComm.WaitFromColse(this.Cursor);
            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("修改成功!"))
            {
                Query();
            }
        }
        private int splitterDistance = 0;
        private void ultraExpandableGroupBox1_ExpandedStateChanged(object sender, EventArgs e)
        {
            //if (ultraExpandableGroupBox1.Expanded == false)
            //{
            //    this.splitContainer1.SplitterDistance = splitContainer1.Size.Height - 26;
            //}
            //else
            //{
            //    this.splitContainer1.SplitterDistance = splitterDistance == 0 ? splitContainer1.Size.Height / 2 : splitterDistance;
            //}
        }

        private void ultraGrid1_ClickCellButton(object sender, CellEventArgs e)
        {
            //if (e.Cell.Column.Key.Equals("DELETE"))
            //{
            //    //UltraGridRow row = ultraGrid1.ActiveRow;       
            //    int countChc = 0;
            //    if (!row.Cells["Planstatus"].Text.ToString().Trim().Equals("计划"))
            //    {
            //        MessageUtil.ShowTips("您选择轧管炉计划已不是计划状态,不能删除炉计划!");
            //        return;
            //    }
            //    if (MessageUtil.ShowYesNoAndQuestion("是否确认删除炉计划?") ==DialogResult.No)
            //        return;
            //    PlanComm.WaitFromOpen(this.Cursor);
            //    CoreClientParam ccp = new CoreClientParam();
            //    ccp.ServerName = "com.steering.pss.plnsaleord.planStove.FrmRollTubeLibraryZg";
            //    ccp.MethodName = "doDeleteZGC";
            //    ccp.ServerParams = new object[] { row.Cells["HeatPlanNo"].Text.ToString().Trim(), row.Cells["HeatPlanSqe"].Text.ToString().Trim(), this.UserInfo.GetUserName() };
            //    ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            //    PlanComm.WaitFromColse(this.Cursor);
            //    if (ccp.ReturnCode == -1) return;
            //    MessageUtil.ShowTips(ccp.ReturnInfo);
            //    if (ccp.ReturnInfo.Equals("删除成功!"))
            //    {
            //        doQueryActual(proPlanId, gxPlanNo);
            //    }
            //}
        }

        private void ultraGrid1_InitializeLayout(object sender, InitializeLayoutEventArgs e)
        {
            StoveHelper.CustomMergedCellEvaluator merge = new StoveHelper.CustomMergedCellEvaluator("HeatPlanNo");
            e.Layout.Bands[0].Columns["HeatPlanNo"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["HeatPlanNo"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["JudgeStoveNo"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["JudgeStoveNo"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["FlagStoveNo"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["FlagStoveNo"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["Memo"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["Memo"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["StoveNo"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["StoveNo"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["PlnInsingleNum"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["PlnInsingleNum"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["PlnInsingleWt"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["PlnInsingleWt"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["ZyBatchId"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["ZyBatchId"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["GxProSeq"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["GxProSeq"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["TotMumM"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["TotMumM"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["totWeightM"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["totWeightM"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["FeedHeatNo"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["FeedHeatNo"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["LenGpSingle"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["LenGpSingle"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["Planstatus"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["Planstatus"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["PlnOutsingleNum"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["PlnOutsingleNum"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["PlnOutsingleW"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["PlnOutsingleW"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["ReducedWt"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["ReducedWt"].MergedCellEvaluator = merge;
        }

        /// <summary>
        /// 订单层重新获取工艺
        /// </summary>
        private void DoModifyProcess()
        {
            ArrayList messageErr = new ArrayList();
            ultraGridZgS.UpdateData();
            ArrayList list = ProducHelper.GetChcRows<PlnOrderZgSEntity>(ultraGridZgS);
            if (list == null || list.Count == 0)
            {
                MessageUtil.ShowTips("请选择订单！");
                return;
            }
            ArrayList jsonList = new ArrayList();
            foreach (PlnOrderZgSEntity entity in list)
            {
                entity.Passive.ToString();
                jsonList.Add(JSONFormat.Format(entity));
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否手动获取工艺?") == DialogResult.No)
            {
                return;
            }
            PlanComm.WaitFromOpen(this.Cursor);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.planStove.StoveHelper";
            ccp.MethodName = "DoModifyProcess";
            ccp.ServerParams = new object[] { jsonList, "D" };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

            PlanComm.WaitFromColse(this.Cursor);
            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("获取成功!"))
            {
                Query();
            }
        }

        /// <summary>
        /// 订单终止
        /// </summary>
        private void doTermination()
        {
            ArrayList messageErr = new ArrayList();
            ultraGridZgS.UpdateData();
            ArrayList list = ProducHelper.GetChcRows<PlnOrderZgSEntity>(ultraGridZgS);
            if (list == null || list.Count == 0)
            {
                MessageUtil.ShowTips("请选择订单！");
                return;
            }
            ArrayList jsonList = new ArrayList();
            foreach (PlnOrderZgSEntity entity in list)
            {
                entity.Passive.ToString();
                if (!entity.ExeStatus.Equals("计划"))
                {
                    MessageUtil.ShowTips("订单不是计划状态不能关闭!");
                    return;
                }
                jsonList.Add(JSONFormat.Format(entity));
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否终止订单?") == DialogResult.No)
            {
                return;
            }
            PlanComm.WaitFromOpen(this.Cursor);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.planStove.StoveHelper";
            ccp.MethodName = "doTermination";
            ccp.ServerParams = new object[] { jsonList, "D" };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

            PlanComm.WaitFromColse(this.Cursor);
            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("终止成功!"))
            {
                Query();
            }
        }
        #region 炉计划层操作
        /// <summary>
        /// 炉计划按钮点击事件
        /// </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 "DeleteStatr"://删除剩余炉计划
                    doDeleteStatr();
                    break;
                case "AgainProcess"://重新获取工艺
                    doAgainProcess();
                    break;
                case "LuClose"://手动关闭炉计划
                    doLuClose();
                    break;
                default:
                    break;
            }
        }
        /// <summary>
        /// 删除剩余炉计划
        /// </summary>
        private void doDeleteStatr()
        {
            //UltraGridRow row = ultraGrid1.ActiveRow;
            //if (row == null) return;

            //int countM = 0;
            //int countC = 0;
            //ArrayList list = new ArrayList();
            //foreach (UltraGridRow item in ultraGrid1.Rows)
            //{
            //    if (Convert.ToBoolean(item.Cells["CHC"].Text) == true)
            //    {
            //        countM++;
            //        ArrayList list1 = new ArrayList();

            //        if (item.Cells["Planstatus"].Text.ToString().Equals("计划") || item.Cells["Planstatus"].Text.ToString().Equals("下发"))
            //        {
            //            MessageUtil.ShowTips("选中该炉计划是计划/下发状态,不能删除!");
            //            return;
            //        }

            //        list1.Add(item.Cells["HeatPlanNo"].Text.ToString().Trim());
            //        list1.Add(item.Cells["HeatPlanSqe"].Text.ToString().Trim());
            //        list.Add(list1);
            //    }
            //}
            //if (countM == 0)
            //{
            //    MessageUtil.ShowTips("请勾选炉计划信息!");
            //    return;
            //}
            //if (MessageUtil.ShowYesNoAndQuestion("是删除剩余炉计划?") == DialogResult.No) return;
            //PlanComm.WaitFromOpen(this.Cursor);
            //CoreClientParam ccp = new CoreClientParam();
            //ccp.ServerName = "com.steering.pss.plnsaleord.planStove.FrmPlanStoveD";
            //ccp.MethodName = "doDeleteStatr";
            //ccp.ServerParams = new object[] { list, this.UserInfo.GetUserName() };
            //ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            //PlanComm.WaitFromColse(this.Cursor);
            //if (ccp.ReturnCode == -1) return ;
            //MessageUtil.ShowTips(ccp.ReturnInfo);
            //if (ccp.ReturnInfo.Equals("删除成功!"))
            //{
            //    doQueryActual(proPlanId, gxPlanNo);
            //}
        }
        /// <summary>
        /// 重新获取工艺
        /// </summary>
        private void doAgainProcess()
        {
            //UltraGridRow row = ultraGrid1.ActiveRow;
            //if (row == null) return;

            //int countM = 0;
            //ArrayList list = new ArrayList();
            //foreach (UltraGridRow item in ultraGrid1.Rows)
            //{
            //    if (Convert.ToBoolean(item.Cells["CHC"].Text) == true)
            //    {
            //        countM++;
            //        ArrayList list1 = new ArrayList();
            //        list1.Add(item.Cells["HeatPlanNo"].Text.ToString().Trim());
            //        list1.Add(item.Cells["HeatPlanSqe"].Text.ToString().Trim());
            //        list.Add(list1);
            //    }
            //}
            //if (countM == 0)
            //{
            //    MessageUtil.ShowTips("请勾选炉计划信息!");
            //    return;
            //}
            //if (MessageUtil.ShowYesNoAndQuestion("是否获取工艺?") == DialogResult.No) return;
            //PlanComm.WaitFromOpen(this.Cursor);
            //CoreClientParam ccp = new CoreClientParam();
            //ccp.ServerName = "com.steering.pss.plnsaleord.planStove.StoveHelper";
            //ccp.MethodName = "doAgainProcess";
            //ccp.ServerParams = new object[] { list, proPlanId, gxPlanNo, "D" };
            //ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            //PlanComm.WaitFromColse(this.Cursor);
            //if (ccp.ReturnCode == -1) return;
            //MessageUtil.ShowTips(ccp.ReturnInfo);
            //if (ccp.ReturnInfo.Equals("获取成功!"))
            //{
            //    doQueryActual(proPlanId, gxPlanNo);
            //}
        }

        /// <summary>
        /// 手动关闭炉计划
        /// </summary>
        private void doLuClose()
        {
            //UltraGridRow row = ultraGrid1.ActiveRow;
            //if (row == null) return;

            //int countM = 0;
            //ArrayList list = new ArrayList();
            //string heatPlanNo = "";
            //foreach (UltraGridRow item in ultraGrid1.Rows)
            //{
            //    if (Convert.ToBoolean(item.Cells["CHC"].Text) == true)
            //    {
            //        countM++;
            //        ArrayList list1 = new ArrayList();

            //        if (item.Cells["Planstatus"].Text.ToString().Equals("关闭"))
            //        {
            //            MessageUtil.ShowTips("选中该炉计划是关闭状态,不能重复关闭!");
            //            return;
            //        }
            //        if (!heatPlanNo.Equals(item.Cells["HeatPlanNo"].Text.ToString()))
            //        {
            //            heatPlanNo = item.Cells["HeatPlanNo"].Text.ToString().Trim();
            //            list1.Add(item.Cells["HeatPlanNo"].Text.ToString().Trim());
            //            list.Add(list1);
            //        }
            //    }
            //}
            //if (countM == 0)
            //{
            //    MessageUtil.ShowTips("请勾选炉计划信息!");
            //    return;
            //}

            //if (MessageUtil.ShowYesNoAndQuestion("是否关闭炉计划?") == DialogResult.No) return;
            //PlanComm.WaitFromOpen(this.Cursor);
            //CoreClientParam ccp = new CoreClientParam();
            //ccp.ServerName = "com.steering.pss.plnsaleord.planStove.FrmPlanStoveD";
            //ccp.MethodName = "doLuClose";
            //ccp.ServerParams = new object[] { list, this.UserInfo.GetUserName() };
            //ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            //PlanComm.WaitFromColse(this.Cursor);
            //if (ccp.ReturnCode == -1) return;
            //MessageUtil.ShowTips(ccp.ReturnInfo);
            //if (ccp.ReturnInfo.Equals("关闭成功!"))
            //{
            //    doQueryActual(proPlanId, gxPlanNo);
            //}
        }

        #endregion

        private void chkLotNo_CheckedChanged(object sender, EventArgs e)
        {
            //lotNoStart.Enabled = lotNoEnd.Enabled = chkLotNo.Checked;
        }

        private void cmbPro_EditorButtonClick(object sender, EditorButtonEventArgs e)
        {
            this.ultraGridZgS.UpdateData();
            UltraGridRow row = this.ultraGridZgS.ActiveRow;
            if (row == null)
            {
                return;
            }
            FrmProInformation fp = new FrmProInformation(ob, row.Cells["PrdcrNo"].Text, row.Cells["IndexSeq"].Text, "D");
            fp.ShowDialog();
        }

        private void ultraGridZgS_DoubleClickHeader(object sender, DoubleClickHeaderEventArgs e)
        {

        }




    }
}