MES_Client/TGMES/Core.StlMes.Client.PlnSaleOrd/工序排产/FrmPlnOrderZgSQuery.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 FrmPlnOrderZgSQuery : FrmBase
    {
        private string departm = "";//获取部门ID
        private string[] plineCode = new string[] { "" };//获取产线代码
        /// <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 FrmPlnOrderZgSQuery()
        {  
            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 "Export"://导出
                    GridHelper.ulGridToExcel(ultraGridZgS, "轧管排产信息");
                    break;
                case "Close":
                    this.Close();
                       break;
                default:
                    break;
            }
        }

        private void FrmPlnOrderZgS_Load(object sender, EventArgs e)
        {
            if (CustomInfo == null) { CustomInfo = ""; }
            //设置列头名称
            EntityHelper.ShowGridCaption<PlnOrderZgSOEntity>(ultraGridZgS.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<PlnZyZgMCEntity>(ultraGrid1.DisplayLayout.Bands[0]);
            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" });
            PlanHelper.InitDropPline("D", "", comPline, this.ob);
            PlanHelper.InitRepairType(ultraGridZgS, this);
            PlanHelper.InitEditPline("D", "", ultraGridZgS, this);
            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.InitCellPositionMiddle(ultraGridZgS, new string[] { "IsRepairPln", "IsPlanOk", "IfMonitorZg", "GpreqIfOk", "Isendgx" });
            BaseHelper.setUltraGridColumnColor(ultraGridZgS, new string[] { "CraftFileNo", "CraftFileLv2G", "Gradename", "DiameterGp" }, Color.GreenYellow);
            //PlanHelper.InitEditGroup("1218", ultraGridZgS, this, "OutsBilletFl");
            PlanHelper.InitEditGroup("1219", ultraGridZgS, this, "OutsStlPipeFl");
            _backColor = ultraGridZgS.DisplayLayout.Override.RowSelectorAppearance.BackColor;
            InitTime();
            InitColorStyle();

            BaseHelper.setUltraGridColumnMaxInput(ultraGrid1, new string[] { "WtGpSingle", "PlnInsingleWt", "PlnOutsingleW", "ActuaWt", "TotWeightM", "CutWeight", "ReducedWt", "RealIndoubleWt" });
            BaseHelper.setUltraGridColumnBits(ultraGrid1, new string[] { "PlnInsingleNum", "PlnOutsingleNum", "ActuaNum", "TotMumM" });
            BaseHelper.InitCellPosition(ultraGrid1, new string[] { "GxProSeq", "GxPlanNo","OrderSeq", "DeliveryNo", "LenRollMax", "LenRollMin",  "Aimoutdiameter","Aimwallthick","CcmGxPlanNo","Aimlength" ,"Diameter","LenGpSingle","WtGpSingle","PlnInsingleNum","PlnInsingleWt","PlnOutsingleNum",
                "PlnOutsingleW","Outdiameter",      "Wallthick","OutdiameterZg","WallthickZg","RollLength","OutnumCut","LenCutend","LenCuthead","DiameterMandrel","CraftSeq","LenGpSingleD","LengthM","CutNumGp","ActuaWt","ActuaNum","TotMumM","TotWeightM","CutWeight","CutLength", "ReducedWt","RealIndoubleNum","RealIndoubleWt","ActCount"});
            //BaseHelper.InitCellPositionC(ultraGridZyD, new string[] { "Diameter", "LenGpSingle", "WtGpSingle", "CutNumGp", "LengthM", "WeightM", "PlanIndoubleNum", "PlanIndoubleWt", "RealIndoubleNum", "RealIndoubleWt", "GxPlanNo" });
            BaseHelper.GridColumnSum(ultraGrid1, new string[] { "ActuaWt", "CutWeight", "RealIndoubleWt" });
            BaseHelper.GridColumnCount(ultraGrid1, new string[] { "ActuaNum", "RealIndoubleNum" });
            StoveHelper.ForbidSort(ultraGrid1);

            BaseHelper.SetGroupBySum(ultraGrid1, new string[] { "PlnOutsingleNum", "PlnOutsingleW", "ReducedWt" }, "HeatPlanNo");
            ultraToolbarsManager1.Visible = false;
        }

        /// <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;
            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];

            UltraComboEditor uceAbc = new UltraComboEditor();
            ultraGridZgS.DisplayLayout.Bands[0].Columns["Decision"].EditorComponent = uceAbc;
            ultraGridZgS.DisplayLayout.Bands[0].Columns["Decision"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            ValueList vlistSteel = new ValueList(); ;
            vlistSteel.ValueListItems.Insert(0, "A", "A");
            vlistSteel.ValueListItems.Insert(1, "B", "B");
            vlistSteel.ValueListItems.Insert(2, "C", "C");
            ultraGridZgS.DisplayLayout.Bands[0].Columns["Decision"].ValueList = vlistSteel;
        }
        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;
        }
     

        private void chcPline_CheckedChanged(object sender, EventArgs e)
        {
            if (chcPline.Checked) { comPline.ReadOnly = false; } else { comPline.ReadOnly = true; }
            if (chcOrderNo.Checked) { txtOrderNo.ReadOnly = false; } else { txtOrderNo.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()
        {
            //产线
            string comPlineCode = "";
            if (chcPline.Checked)
            {
                comPlineCode = comPline.Value == null ? "" : comPline.Value.ToString();
            }
         
                //如果是排产界面，则下拉框的产线不能为空，需要排序
            if (!CustomInfo.Equals("0") && comPlineCode.Equals(""))
                {
                    MessageUtil.ShowTips("请选择产线!");
                    return;
                }
            
            WaitingForm2 wf3 = new WaitingForm2("正在刷新，请稍候....");
            try
            {
                this.Cursor = Cursors.WaitCursor;
                //执行状态
                string[] statusArr = contorlPlanStatus1.statusArr;
                //合同号
                string orderNo = "";
                if (chcOrderNo.Checked) { orderNo = txtOrderNo.Text.Trim(); }
                string proPlanId = "";
                if (chcProPlanId.Checked) { proPlanId = txtProPlanId.Text.Trim(); }
                string planTimeB1 = "";
                string planTimeB2 = "";
                if (chcPlanTimeB.Checked && txtPlanTimeB2.Value != null && txtPlanTimeB1.Value != null)
                {
                    planTimeB1 = DateTime.Parse(txtPlanTimeB1.Value.ToString()).ToString("yyyy-MM-dd HH:mm:ss");
                    planTimeB2 = DateTime.Parse(txtPlanTimeB2.Value.ToString()).ToString("yyyy-MM-dd HH:mm:ss");
                }
                string planTimeE1 = "";
                string planTimeE2 = "";
                if (chcPlanTimeE.Checked && txtPlanTimeE2.Value != null && txtPlanTimeE1.Value != null)
                {
                    planTimeE1 = DateTime.Parse(txtPlanTimeE1.Value.ToString()).ToString("yyyy-MM-dd HH:mm:ss");
                    planTimeE2 = DateTime.Parse(txtPlanTimeE2.Value.ToString()).ToString("yyyy-MM-dd HH:mm:ss");
                }
                List<PlnOrderZgSOEntity> listSource = EntityHelper.GetData<PlnOrderZgSOEntity>
                ("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryPlanOrderD", new object[] { plineCode, proPlanId, orderNo, statusArr, planTimeB1, planTimeB2, planTimeE1, planTimeE2, comPlineCode,"","" }, this.ob);
                plnOrderZgSOEntityBindingSource.DataSource = listSource;
                dtPlinGroup = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryPlinCodeGroup", null, this.ob);
                foreach (UltraGridRow ugr in ultraGridZgS.Rows)
                {                    
                    string str = ugr.Cells["AfInfo"].Text.Trim();

                    if (str != null && str != "")
                    {
                        string[] sArray = str.Split(new char[3] { '天', ',', '条' });
                        ugr.Cells["TimeDiffer"].Value = String.Format("{0:N2} ", sArray[0]);
                        ugr.Cells["AfProLin"].Value = sArray[2];
                        ugr.Cells["AfProNum"].Value = sArray[3];
                        if (dtPlinGroup.Rows.Count > 0)
                        {
                            //for (int i = 0; i < dtPlinGroup.Rows.Count; i++)
                            //{
                            string plinGroup = dtPlinGroup.Rows[0]["PLINE_NAME_M"].ToString() + "/" + dtPlinGroup.Rows[0]["PLINE_NAME_C"].ToString();
                            DataRow[] dr = dtPlinGroup.Select("PLINE_NAME_M='" + ugr.Cells["PlineCode"].Text.ToString() + "' AND PLINE_NAME_C ='" + ugr.Cells["AfProLin"].Value.ToString() + "'", "");
                            if (dr == null || dr.Length == 0) { }
                            else
                            {
                                //DataTable tmp = dr.Table.Clone();  // 复制DataRow的表结构

                                //if (tmp.Rows.Count > 0)
                                //{
                                    ugr.Cells["StockGroupName"].Value = dr[0]["STOCK_GROUP_NAME"].ToString();
                                //}
                            }
                        }
                    }
                    if (ugr.Cells["WeigthSMin"].Text.ToString().Equals("") || ugr.Cells["WeigthSMin"].Value.ToString().Equals("0"))
                    {
                        ugr.Cells["AmountDifference"].Value = (double.Parse(ugr.Cells["ExpectWt"].Value.ToString()) - double.Parse(ugr.Cells["WeigthS"].Value.ToString())).ToString();
                    }
                    else
                    {
                        ugr.Cells["AmountDifference"].Value = (double.Parse(ugr.Cells["ExpectWt"].Value.ToString()) - double.Parse(ugr.Cells["WeigthSMin"].Value.ToString())).ToString();
                    }
                }
                //激活操作行代码
                //if ((!_ProPlanId.Equals("") && !_GxPlanNo.Equals("")) || _entityList != null)
                    foreach (UltraGridRow ugr in ultraGridZgS.Rows)
                    {
                        if (!_ProPlanId.Equals("") && !_GxPlanNo.Equals(""))
                        {
                            if (ugr.Cells["ProPlanId"].Text.Trim().Equals(_ProPlanId) && ugr.Cells["GxPlanNo"].Text.Trim().Equals(_GxPlanNo))
                            {
                                ugr.Activate();
                                break;
                            }
                        }
                        if (_entityList != null)
                        {
                            for (int i = 0; i < _entityList.Count; i++)
                            {
                                PlnOrderZgSEntity jgxsEntity = (PlnOrderZgSEntity)_entityList[i];
                                if (ugr.Cells["ProPlanId"].Text.Trim().Equals(jgxsEntity.ProPlanId) && ugr.Cells["GxPlanNo"].Text.Trim().Equals(jgxsEntity.GxPlanNo))
                                {
                                    ugr.Appearance.BackColor = Color.Wheat;
                                    ugr.Activate();
                                }
                                //if (!ugr.Cells["GxProSeq"].Text.Trim().Equals(jgxsEntity.GxProSeq))
                                //{
                                //    ugr.Cells["GxProSeq"].Appearance.BackColor = Color.Wheat;
                                //    ugr.Activate();
                                //}
                            }
                        }               
                    }

                _entityList = null;
                _ProPlanId = "";
                _ProPlanId = "";

              
            }
            finally
            {
                wf3.Close();
                this.Cursor = Cursors.Default;
            }
        }
      

        private void ultraGridZgS_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow ugrAc = ultraGridZgS.ActiveRow;
            if (ugrAc == null)
            {
                return;
            }
             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 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.Appearance.BackColor = Color.Orange;
                }
            }


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

        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("CraftFileLv2G");
                dlgOrderAskDown askDown = new dlgOrderAskDown(this.ob, craftFileLv2G);
                askDown.Show();
            }
            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();
            }
        }
        

     
        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_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;
        }
       
    }
}