MES_Client/TGMES/Core.StlMes.Client.PlnSaleOrd/工序排产/FrmPlnOrderRclSQuery.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.窗体;
using Core.StlMes.Client.PlnSaleOrd.炉计划.Tool;

namespace Core.StlMes.Client.PlnSaleOrd
{
    /// <summary>
    /// 热处理排产
    /// </summary>
    public partial class FrmPlnOrderRclSQuery : FrmBase
    {
        DataTable dtPlinGroup = null;
        Dictionary<string, UltraComboEditor> ucbDicton = null;
        /// <summary>
        ///产线权限
        /// </summary>
        private string[] plinePower = new string[] { "" };
        /// <summary>
        /// 产线
        /// </summary>
        private string _plineCode = "";
        /// <summary>
        /// 热处理订单编号
        /// </summary>
        private string _ProPlanId = "";
        /// <summary>
        /// 订单排产序号
        /// </summary>
        private string _GxPlanNo = "";
        /// <summary>
        /// 集合
        /// </summary>
        private ArrayList _entityList = null;
        /// <summary>
        /// 颜色
        /// </summary>
        private Color _color = new Color();
        private string proPlanId = "";
        private string gxPlanNo = "";
        public FrmPlnOrderRclSQuery()
        {
            this.IsLoadUserView = true;
            InitializeComponent();
           
        }
        private void FrmOrderRclS_Load(object sender, EventArgs e)
        {
            EntityHelper.ShowGridCaption<PlnOrderRclSOEntity>(ultraGridRcls.DisplayLayout.Bands[0]);
            BaseHelper.setUltraGridColumnMaxInput(ultraGridRcls, new string[] { "WeigthS" });
            BaseHelper.InitCellPosition(ultraGridRcls, new string[] { "GxPlanNo", "OrderSeq", "DeliveryNo", "Outdiameter", "Wallthick", "LengthmaxIn", "LengthminIn", "LengthIn", "Aimlength", "InWeightS", "InNumS", "WeigthS", 
                "NumS", "MatchWtIn", "MatchNumIn", "GxProSeq", "PlanUsetime", "BatchedWt", "BatchedNum", "Finishweight", "Finishnum", "AddWtIn", "AddNumIn", "ProcessingCost", "TotalCost"
            ,"FinishWgt","UnfinishWgt","UnfinishNum","OutputNum","ExpectWt","ExpectNum"});
            BaseHelper.GridColumnSum(ultraGridRcls, new string[] { "WeigthS" });
            BaseHelper.GridColumnCount(ultraGridRcls, new string[] { "NumS" });
            BaseHelper.InitCellPositionMiddle(ultraGridRcls, new string[] { "IsRepairPln", "IsPlanOk", "IfMonitorRcl", "Isendgx" });
            PlanHelper.InitRepairType(ultraGridRcls, this);
            PlanHelper.InitEditGroup("2005", ultraGridRcls, this, "GroupRcl");
            PlanHelper.InitDropGroup("2005", txtGroup, this.ob);
            PlanHelper.InitEditPline("F", _plineCode, ultraGridRcls, this);

            plinePower = PlanHelper.InitDropPlinePower("F", comJgPlne, this.ValidDataPurviewIds, this.ob);
                ucbDicton = PlanHelper.GetPlineUcb("2005", "F", this);
           
            InitColorStyle();
            InitTime();

            EntityHelper.ShowGridCaption<Core.StlMes.Client.PlnSaleOrd.炉计划.Entity.PlnZyRclReadyEntity>(ultraGrid1.DisplayLayout.Bands[0]);
            //炉计划
            BaseHelper.setOtherColumnReadOnly(ultraGrid1, new string[] { "CHC" });
            BaseHelper.setUltraGridColumnMaxInput(ultraGrid1, new string[] { "RealOutdoubleWt", "RealIndoubleWt", "PlanIndoubleWt" });
            BaseHelper.setUltraGridColumnBits(ultraGrid1, new string[] { "RealOutdoubleNum", "RealIndoubleNum", "PlanIndoubleNum" });
            BaseHelper.InitCellPosition(ultraGrid1, new string[] { "GxProSeq", "GxPlanNo","OrderSeq", "DeliveryNo", "PlnInsingleNum", "PlnInsingleWt",  "PlnIndoubleNum","PlnIndoubleWt","PlnOutsingleNum","PlnOutsingleW" ,"PlnOutdoubleNum","PlnOutdoubleW","OutdiameterIn","WallthickIn","LengthIn","LengthmaxIn",
                "LengthminIn","OutnumCut",  "Outdiameter","Wallthick","Lengthmin","Lengthmax","CraftSeq","RealOutdoubleWt", "RealIndoubleWt", "PlanIndoubleWt","RealOutdoubleNum", "RealIndoubleNum", "PlanIndoubleNum"});
            BaseHelper.GridColumnSum(ultraGrid1, new string[] { "RealOutdoubleWt", "RealIndoubleWt", "PlanIndoubleWt" });
            BaseHelper.GridColumnCount(ultraGrid1, new string[] { "RealOutdoubleNum", "RealIndoubleNum", "PlanIndoubleNum" });
            BaseHelper.ForbidSort(ultraGrid1);
            BaseHelper.SetGroupBySum(ultraGrid1, new string[] { "PlnInsingleWt", "PlnOutsingleW", "PlnIndoubleWt", "PlnOutdoubleW", "PlnInsingleNum", "PlnOutsingleNum", "PlnIndoubleNum", "PlnOutdoubleNum" }, "HeatPlanNo");
            _color = ultraGridRcls.DisplayLayout.Override.RowSelectorAppearance.BackColor;
        }


        /// <summary>
        /// 初始化列状态
        /// </summary>
        private void InitColorStyle()
        {
            ultraGridRcls.DisplayLayout.Bands[0].Columns["PlanTimeB"].Format = "yyyy-MM-dd HH:mm:ss";
            ultraGridRcls.DisplayLayout.Bands[0].Columns["PlanTimeB"].MaskInput = "yyyy-mm-dd hh:mm:ss";
            ultraGridRcls.DisplayLayout.Bands[0].Columns["PlanTimeB"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DateTime;
            ultraGridRcls.DisplayLayout.Bands[0].Columns["CraftFileLv2G"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton;
            ultraGridRcls.DisplayLayout.Bands[0].Columns["CraftFileLv2G"].CellAppearance.BackColor = Color.GreenYellow;
            ultraGridRcls.DisplayLayout.Bands[0].Columns["CraftFileNo"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton;
            ultraGridRcls.DisplayLayout.Bands[0].Columns["CraftFileNo"].CellAppearance.BackColor = Color.GreenYellow;
            ultraGridRcls.DisplayLayout.Bands[0].Columns["PreInfo"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton;
            ultraGridRcls.DisplayLayout.Bands[0].Columns["PreInfo"].CellAppearance.BackColor = Color.GreenYellow;
            ultraGridRcls.DisplayLayout.Bands[0].Columns["AfInfo"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton;
            ultraGridRcls.DisplayLayout.Bands[0].Columns["AfInfo"].CellAppearance.BackColor = Color.GreenYellow;
            ultraGridRcls.DisplayLayout.Bands[0].Columns["BefProLin"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton;
            ultraGridRcls.DisplayLayout.Bands[0].Columns["BefProLin"].CellAppearance.BackColor = Color.GreenYellow;
            ultraGridRcls.DisplayLayout.Bands[0].Columns["TimeDiffer"].CellAppearance.BackColor = Color.GreenYellow;
            ultraGridRcls.DisplayLayout.Bands[0].Columns["BefProNum"].CellAppearance.BackColor = Color.GreenYellow;
            ultraGridRcls.DisplayLayout.Bands[0].Columns["ZgStartTime"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton;
            ultraGridRcls.DisplayLayout.Bands[0].Columns["ZgStartTime"].CellAppearance.BackColor = Color.GreenYellow;
            UltraComboEditor uceAbc = new UltraComboEditor();
            ultraGridRcls.DisplayLayout.Bands[0].Columns["Decision"].EditorComponent = uceAbc;
            ultraGridRcls.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");
            ultraGridRcls.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;
        }



        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            base.ToolBar_Click(sender, ToolbarKey);
            switch (ToolbarKey)
            {
                case "Query"://查询
                    Query();
                    break;
             
                case "Export": //导出
                    GridHelper.ulGridToExcel(ultraGridRcls, "热处理排产信息");
                    break;
                case "Close"://关闭
                    this.Close();
                    break;
                default:
                    break;
            }
        }

       
        private void chc_CheckedChanged(object sender, EventArgs e)
        {
            if (chcOrderNo.Checked) { txtOrderNo.ReadOnly = false ; } else { txtOrderNo.ReadOnly = true ; }
            if (chcProPlanId.Checked) { txtProPlanId.ReadOnly = false; } else { txtProPlanId.ReadOnly = true; }
            if (chcGroup.Checked) { txtGroup.ReadOnly = false; } else { txtGroup.ReadOnly = true; }
        }


        /// <summary>
        /// 查询
        /// </summary>
        private void Query()
        {
            //产线
            string plineCode = "";
            if (chcJgPlne.Checked)
            {
                plineCode = comJgPlne.Value == null ? "" : comJgPlne.Value.ToString();
            }

            //如果是排产界面，则下拉框的产线不能为空，需要排序
            if (plineCode.Equals(""))
            {
                MessageUtil.ShowTips("请选择产线!");
                return;
            }
            WaitingForm2 wf3 = new WaitingForm2("正在刷新，请稍候....");
             try
            {
            this.Cursor = Cursors.WaitCursor;
            //string plineCode = "";
            //if (chcJgPlne.Checked) { plineCode = comJgPlne.Value == null ? "" : comJgPlne.Value.ToString(); }
            //if (comJgPlne.Text.Equals(""))
            //{
            //    MessageUtil.ShowTips("请选择产线!");
            //    return;
            //}
            //执行状态
            string[] statusArr = contorlPlanStatus1.statusArr;
            string orderNo = "";
            if (chcOrderNo.Checked) { orderNo = txtOrderNo.Text.Trim(); }
            string proPlanId = "";
            if (chcProPlanId.Checked) { proPlanId = txtProPlanId.Text.Trim(); }
            string group = "";
            if (chcGroup.Checked && txtGroup.Value != null) { group = txtGroup.Value.ToString(); }
            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<PlnOrderRclSOEntity> listSource = EntityHelper.GetData<PlnOrderRclSOEntity>
            ("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryPlanOrderF", 
            new object[] { plineCode, proPlanId, orderNo,group, statusArr, planTimeB1,planTimeB2,planTimeE1,planTimeE2}, this.ob);
            plnOrderRclSOEntityBindingSource.DataSource = listSource;
            dtPlinGroup = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryPlinCodeGroup", null, this.ob);
            //ProducHelper.copyLZData(ultraGridRcls,"F",this.ob);
            foreach (UltraGridRow ugr in ultraGridRcls.Rows)
            {
                string str = ugr.Cells["PreInfo"].Text.Trim();

                if (str != null && str != "")
                {
                    string[] sArray = str.Split(new char[3] { '天', ',', '条' });
                    ugr.Cells["TimeDiffer"].Value = sArray[0];
                    ugr.Cells["BefProLin"].Value = sArray[2];
                    ugr.Cells["BefProNum"].Value = sArray[3];
                }
                string strH = ugr.Cells["AfInfo"].Text.Trim();

                if (strH != null && strH != "")
                {
                    string[] sArray = strH.Split(new char[3] { '天', ',', '条' });
                    string plineCodeH = sArray[2];
                    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 ='" + plineCodeH + "'", "");
                        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 ((!_ProPlanId.Equals("") && !_GxPlanNo.Equals("")) || _entityList != null)
            {
                //foreach (UltraGridRow ugr in ultraGridRcls.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++)
                        {
                            PlnOrderRclSEntity entity = (PlnOrderRclSEntity)_entityList[i];
                            if (ugr.Cells["ProPlanId"].Text.Trim().Equals(entity.ProPlanId) && ugr.Cells["GxPlanNo"].Text.Trim().Equals(entity.GxPlanNo))
                            {
                                ugr.Appearance.BackColor = Color.Wheat;
                                ugr.Activate();
                            }
                        }
                    }
                }
                _ProPlanId = "";
                _GxPlanNo = "";
                _entityList = null;
                if (!CustomInfo.Equals("0"))
                {
                    _plineCode = comJgPlne.Value.ToString();
                }
 
            }
            }
             finally
             {
                 wf3.Close();
                 this.Cursor = Cursors.Default;
             }
        }

      




        private void ultraGridRcls_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow ugrAc = ultraGridRcls.ActiveRow;
            if (ugrAc == null)
            {
                return;
            }
           
            proPlanId = ugrAc.Cells["ProPlanId"].Text;
            gxPlanNo = ugrAc.Cells["GxPlanNo"].Text;
            if (CustomInfo == "0") return;
            QueryZyReadyF(proPlanId, gxPlanNo);
           
        }
        /// <summary>
        /// 查询镦拔扩虚拟炉计划
        /// </summary>
        /// <param name="proPlanId"></param>
        /// <param name="gxPlanNo"></param>
        private void QueryZyReadyF(string proPlanId, string gxPlanNo)
        {
            List<Core.StlMes.Client.PlnSaleOrd.炉计划.Entity.PlnZyRclReadyEntity> listSource = EntityHelper.GetData<Core.StlMes.Client.PlnSaleOrd.炉计划.Entity.PlnZyRclReadyEntity>
         ("com.steering.pss.plnsaleord.planStove.FrmPlanStoveF.queryPlanStovePlanId", new object[] { proPlanId, gxPlanNo }, this.ob);
            plnZyRclReadyEntityBindingSource.DataSource = listSource;
            foreach (UltraGridRow ugr in ultraGrid1.Rows)
            {
                //没有实际炉计划，主炉计划变颜色
                if (ugr.Cells["HeatPlanSqe"].Value.ToString().Equals(""))
                {
                    //ugr.RowSelectorAppearance.BackColor = Color.GreenYellow;
                    ugr.Appearance.BackColor = Color.Orange;
                }
            }
        }
      
        private void chcJgPlne_CheckedChanged(object sender, EventArgs e)
        {
            if (chcJgPlne.Checked) { comJgPlne.ReadOnly = false; } else { comJgPlne.ReadOnly = true; }
        }

        private void comJgPlne_ValueChanged(object sender, EventArgs e)
        {
            if (comJgPlne.Value == null)
            {
                return;
            }
            _plineCode = comJgPlne.Value.ToString();
            Query();
        }

      

        private void ultraGridRcls_ClickCellButton(object sender, CellEventArgs e)
        {
            UltraGridRow row = ultraGridRcls.ActiveRow;
            if (e.Cell.Column.Key.Equals("CraftFileNo"))
            {
                string filePath = row.GetValue("CraftPath");
                dlgOrderAskDown askDown = new dlgOrderAskDown(this.ob, filePath);
                // askDown.DeleteButton.Visible = false;
                askDown.Show();
            }
            else if (e.Cell.Column.Key.Equals("CraftFileLv2G"))
            {
                string craftFileLv2G = row.GetValue("CraftFileLv2G");
                dlgOrderAskDown askDown = new dlgOrderAskDown(this.ob, craftFileLv2G);
                // askDown.DeleteButton.Visible = false;
                askDown.Show();
                // FrmCraftFileLv2 frmCraftFileLv2 = new FrmCraftFileLv2(craftFileLv2G,this.ob);
                // frmCraftFileLv2.ShowDialog();
            }
            //else if (e.Cell.Column.Key.Equals("PreInfo"))
            //{
            //    string proPlanId = row.GetValue("ProPlanId");
            //    string preInfo = row.GetValue("PreInfo");
            //    if (preInfo == null || preInfo.Length == 0) { return; }
            //    FrmPreGxInfo frmPreGxInfo = new FrmPreGxInfo(proPlanId,"F","Pr",this.ob);
            //    frmPreGxInfo.ShowDialog();
            //}
            else if (e.Cell.Column.Key.Equals("BefProLin"))
            {
                string proPlanId = row.GetValue("ProPlanId");
                string preInfo = row.GetValue("PreInfo");
                if (preInfo == null || preInfo.Length == 0) { return; }
                FrmPreGxInfo frmPreGxInfo = new FrmPreGxInfo(proPlanId, "F", "Pr", this.ob);
                frmPreGxInfo.ShowDialog();
            }
            else if (e.Cell.Column.Key.Equals("AfInfo"))
            {
                string proPlanId = row.GetValue("ProPlanId");
                string afInfo = row.GetValue("AfInfo");
                if (afInfo == null || afInfo.Length == 0) { return; }
                FrmPreGxInfo frmPreGxInfo = new FrmPreGxInfo(proPlanId, "F", "Af",this.ob);
                frmPreGxInfo.ShowDialog();
            }
            else if (e.Cell.Column.Key.Equals("ZgStartTime"))
            {
                string plnPivideId = row.GetValue("PlnDivideId");
                string ordLnDlyPk = row.GetValue("OrdLnDlyPk");
                FrmZgSum frmPreGxInfo = new FrmZgSum(ordLnDlyPk, plnPivideId, this.ob);
                frmPreGxInfo.ShowDialog();
            }
        }
    

        private void chcPlanTimeB_CheckedChanged(object sender, EventArgs e)
        {
            if (chcPlanTimeB.Checked) { txtPlanTimeB1.ReadOnly = false; txtPlanTimeB2.ReadOnly = false; } else { txtPlanTimeB1.ReadOnly = true; txtPlanTimeB2.ReadOnly = true; }
        }

        private void chcPlanTimeE_CheckedChanged(object sender, EventArgs e)
        {
            if (chcPlanTimeE.Checked) { txtPlanTimeE1.ReadOnly = false; txtPlanTimeE2.ReadOnly = false; } else { txtPlanTimeE1.ReadOnly = true; txtPlanTimeE2.ReadOnly = true; }
        }


        #region 炉计划层操作
       
        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["StoveNo"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["StoveNo"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["PlnInsingleWt"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["PlnInsingleWt"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["PlnOutsingleW"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["PlnOutsingleW"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["PlnIndoubleWt"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["PlnIndoubleWt"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["PlnOutdoubleW"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["PlnOutdoubleW"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["PlnInsingleNum"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["PlnInsingleNum"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["PlnOutsingleNum"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["PlnOutsingleNum"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["PlnIndoubleNum"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["PlnIndoubleNum"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["PlnOutdoubleNum"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["PlnOutdoubleNum"].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["Planstatus"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["Planstatus"].MergedCellEvaluator = merge;
        }
        #endregion

    }
}