MES_Client/TGMES/Core.StlMes.Client.SaleOrder/Dialog/PopupCraftReview.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using Core.StlMes.Client.Qcm.Control;
using Core.StlMes.Client.Qcm.model;
using Core.StlMes.Client.SaleOrder.BLL;
using Core.StlMes.Client.SaleOrder.Control;
using CoreFS.CA06;
using Infragistics.Win.UltraWinGrid;
using Infragistics.Win.UltraWinTree;

namespace Core.StlMes.Client.SaleOrder.Dialog
{
    public partial class PopupCraftReview : FrmBase
    {
        private string _designKey = "";
        private CraftOrdDesignMscBLL _designMscBLL;
        private CraftOrdDesignMscPlBLL _designMscPlBLL;
        private CraftOrdDesignMscCftBLL _designMscCftBLL;
        private CraftOrdDesignMscPlGzBLL _designMscPlGzBLL;
        private CraftOrdDesignMscPlPrcBLL _designMscPlPrcBLL;
        private CraftOrdDesignStdCicBLL _designStdCicBLL;
        private CraftOrdDesignStdPicBLL _designStdPicBLL;
        private CraftOrdDesignStdDicBLL _designStdDicBLL;
        private CraftOrdDesignStdSicBLL _designStdSicBLL;
        private CraftOrdDesignStdWicBLL _designStdWicBLL;
        private CraftOrdDesignStdGicBLL _designStdGicBLL;
        private CraftOrdDesignMscJgBLL _designMscJgBLL;
        private CraftOrdDesignMscJgBlBLL _desginMscJgBlBLL;
        private CraftOrdDesignMscBlBLL _designMscBlBLL;
        private CraftOrdDesignMscJgPlBLL _designMscJgPlBLL;
        private CraftOrdDesignMscJgPlStiBLL _designMscJgPlStiBLL;
        private CraftOrdDesignMscPlStiBLL _designMscPlStiBLL;

        private CraftOrdDesignMscCtrl _designMscCtrl;
        private CraftOrdDesignMscPlCtrl _designMscPlCtrl;
        private CraftOrdDesignMscJgCtrl _designMscJgCtrl;
        private CraftOrdDesignBlCtrl _designBlCtrl;
        private CraftOrdDesignMscCftCtrl _designMscCftCtrl;
        private CraftOrdDesignMscPlGzCtrl _designMscPlGzCtrl;
        private CraftOrdDesignMscPlPrcCtrl _designMscPlPrcCtrl;
        private ComBaseGradeCtrl _baseGradeCtrl;
        private CraftOrdDesignMscJgPlStiCtrl _designMscJgPlStiCtrl;
        private CraftOrdDesignStdCicCtrl _designStdCicCtrl;
        private CraftOrdDesignStdPicCtrl _designStdPicCtrl;
        private CraftOrdDesignStdDicCtrl _designStdDicCtrl;
        private CraftOrdDesignStdSicCtrl _designStdSicCtrl;
        private CraftOrdDesignStdWicCtrl _designStdWicCtrl;
        private CraftOrdDesignStdGicCtrl _designStdGicCtrl;
        private CraftOrdDesignMscPlStiCtrl _designMscPlStiCtrl;

        private const int CELL_HEIGHT = 21;
        private const int HEAD_HEIGHT = 140;

        public PopupCraftReview(string designKey, OpeBase ob)
        {
            InitializeComponent();
            _designKey = designKey;
            _designMscBLL = new CraftOrdDesignMscBLL(ob);
            _designMscPlBLL = new CraftOrdDesignMscPlBLL(ob);
            _designMscCftBLL = new CraftOrdDesignMscCftBLL(ob);
            _designMscPlGzBLL = new CraftOrdDesignMscPlGzBLL(ob);
            _designMscPlPrcBLL = new CraftOrdDesignMscPlPrcBLL(ob);
            _designStdCicBLL = new CraftOrdDesignStdCicBLL(ob);
            _designStdPicBLL = new CraftOrdDesignStdPicBLL(ob);
            _designStdDicBLL = new CraftOrdDesignStdDicBLL(ob);
            _designStdSicBLL = new CraftOrdDesignStdSicBLL(ob);
            _designStdWicBLL = new CraftOrdDesignStdWicBLL(ob);
            _designStdGicBLL = new CraftOrdDesignStdGicBLL(ob);
            _designMscJgBLL = new CraftOrdDesignMscJgBLL(ob);
            _desginMscJgBlBLL = new CraftOrdDesignMscJgBlBLL(ob);
            _designMscBlBLL = new CraftOrdDesignMscBlBLL(ob);
            _designMscJgPlBLL = new CraftOrdDesignMscJgPlBLL(ob);
            _designMscJgPlStiBLL = new CraftOrdDesignMscJgPlStiBLL(ob);
            _designMscPlStiBLL = new CraftOrdDesignMscPlStiBLL(ob);

            _designMscCtrl = new CraftOrdDesignMscCtrl(this.panel1, ob);
            _designMscPlCtrl = new CraftOrdDesignMscPlCtrl(this.panel1, ob);
            _designMscJgCtrl = new CraftOrdDesignMscJgCtrl(this.panel1, ob);
            _designBlCtrl = new CraftOrdDesignBlCtrl(this.panel1, ob);
            _designMscCftCtrl = new CraftOrdDesignMscCftCtrl(this.panel1, ob);
            _designMscPlGzCtrl = new CraftOrdDesignMscPlGzCtrl(this.panel1, ob);
            _designMscPlPrcCtrl = new CraftOrdDesignMscPlPrcCtrl(this.panel1, ob);
            _baseGradeCtrl = new ComBaseGradeCtrl(this.panel1, ob);
            _designMscJgPlStiCtrl = new CraftOrdDesignMscJgPlStiCtrl(this.panel1, ob);
            _designStdCicCtrl = new CraftOrdDesignStdCicCtrl(this.panel1, ob);
            _designStdPicCtrl = new CraftOrdDesignStdPicCtrl(this.panel1, ob);
            _designStdDicCtrl = new CraftOrdDesignStdDicCtrl(this.panel1, ob);
            _designStdSicCtrl = new CraftOrdDesignStdSicCtrl(this.panel1, ob);
            _designStdWicCtrl = new CraftOrdDesignStdWicCtrl(this.panel1, ob);
            _designStdGicCtrl = new CraftOrdDesignStdGicCtrl(this.panel1, ob);
            _designMscPlStiCtrl = new CraftOrdDesignMscPlStiCtrl(this.panel1, ob);

            InitTree();
            ultraTree1.ExpandAll();
        }

        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            this.panel1.Controls.Clear();
        }

        private void InitTree()
        {
            ultraTree1.Nodes.Clear();
            //MSC
            List<CraftOrdDesignMscEntity> designMscEntityList = _designMscBLL.QueryMscByDesignKey(
                new CraftOrdDesignMscEntity() { DesginKey = _designKey });
            foreach (CraftOrdDesignMscEntity designMscEntity in designMscEntityList)
            {
                UltraTreeNode mscNode = CreateNode(designMscEntity.Msc, designMscEntity);
                ultraTree1.Nodes.Add(mscNode);
                InitMscPlineDown(mscNode, _designKey);

                //接箍
                List<CraftOrdDesignMscJgEntity> designMscJgEntityList = _designMscJgBLL.QueryCodeJgByDesignKey(
                    new CraftOrdDesignMscJgEntity() { DesginKey = _designKey });
                foreach (CraftOrdDesignMscJgEntity designMscJgEntity in designMscJgEntityList)
                {
                    UltraTreeNode mscJgNode = CreateNode(designMscJgEntity.CodeJg, designMscJgEntity);
                    mscNode.Nodes.Add(mscJgNode);
                    InitMscPlineDownJg(mscJgNode, _designKey);
                    List<CraftOrdDesignMscJgBlEntity> designMscJgBlEntityList = _desginMscJgBlBLL.Query(
                        new CraftOrdDesignMscJgBlEntity() { DesginKey = _designKey });
                    foreach (CraftOrdDesignMscJgBlEntity designMscJgBlEntity in designMscJgBlEntityList)
                    {
                        UltraTreeNode mscJgBlNode = CreateNode(designMscJgBlEntity.PscBl, designMscJgBlEntity);
                        mscJgNode.Nodes.Add(mscJgBlNode);
                        List<CraftOrdDesignMscEntity> designMscEntityList2 = _designMscBLL.QueryMscByDesignKey(
                            new CraftOrdDesignMscEntity() { DesginKey = designMscJgBlEntity.DesginKeyBl });
                        foreach (CraftOrdDesignMscEntity designMscEntity2 in designMscEntityList2)
                        {
                            UltraTreeNode mscNode2 = CreateNode(designMscEntity2.Msc, designMscEntity2);
                            mscJgBlNode.Nodes.Add(mscNode2);
                            InitMscPlineDown(mscNode2, designMscEntity2.DesginKey);
                        }
                    }
                }

                //备料
                List<CraftOrdDesignMscBlEntity> designMscBlEntityList = _designMscBlBLL.Query(
                    new CraftOrdDesignMscBlEntity() { DesginKey = _designKey });
                foreach (CraftOrdDesignMscBlEntity designMscBlEntity in designMscBlEntityList)
                {
                    UltraTreeNode mscBlNode = CreateNode(designMscBlEntity.PscBl, designMscBlEntity);
                    mscNode.Nodes.Add(mscBlNode);
                    List<CraftOrdDesignMscEntity> designMscEntityList2 = _designMscBLL.QueryMscByDesignKey(
                            new CraftOrdDesignMscEntity() { DesginKey = designMscBlEntity.DesginKeyBl});
                    foreach (CraftOrdDesignMscEntity designMscEntity2 in designMscEntityList2)
                    {
                        UltraTreeNode mscNode2 = CreateNode(designMscEntity2.Msc, designMscEntity2);
                        mscBlNode.Nodes.Add(mscNode2);
                        InitMscPlineDown(mscNode2, designMscEntity2.DesginKey);
                    }
                }
            }
        }

        /// <summary>
        /// 初始化接箍向下的数据
        /// </summary>
        /// <param name="node"></param>
        /// <param name="designKey"></param>
        private void InitMscPlineDownJg(UltraTreeNode node, string designKey)
        {
            List<CraftOrdDesignMscJgPlEntity> designMscJgPlEntityList = _designMscJgPlBLL.Query(
                    new CraftOrdDesignMscJgPlEntity() { DesginKey = designKey });
            foreach (CraftOrdDesignMscJgPlEntity designMscJgPlEntity in designMscJgPlEntityList)
            {
                UltraTreeNode mscPlineNode = CreateNode(designMscJgPlEntity.MscPline, designMscJgPlEntity);
                node.Nodes.Add(mscPlineNode);

                //钢种
                List<CraftOrdDesignMscPlGzEntity> designMscPlGzEntityList = _designMscPlGzBLL.QueryGradeByDesignKey(
                    new CraftOrdDesignMscPlGzEntity() { DesginKey = designKey, MscPline = designMscJgPlEntity.MscPline });
                foreach (CraftOrdDesignMscPlGzEntity designMscPlGzEntity in designMscPlGzEntityList)
                {
                    UltraTreeNode mscGradeNode = CreateNode(designMscPlGzEntity.Gradename, designMscPlGzEntity);
                    mscPlineNode.Nodes.Add(mscGradeNode);
                }

                //工艺
                List<CraftOrdDesignMscCftEntity> designMscCftEntityList = _designMscCftBLL.QueryCraftByDesignKey(
                    new CraftOrdDesignMscCftEntity() { DesginKey = designKey, MscPline = designMscJgPlEntity.MscPline });
                foreach (CraftOrdDesignMscCftEntity designMscCftEntity in designMscCftEntityList)
                {
                    UltraTreeNode mscCftNode = CreateNode(designMscCftEntity.CraftitemDesc, designMscCftEntity);
                    mscPlineNode.Nodes.Add(mscCftNode);
                }

                //工序
                List<CraftOrdDesignMscJgPlStiEntity> designMscJgPlStiEntityList = _designMscJgPlStiBLL.Query(
                    new CraftOrdDesignMscJgPlStiEntity()
                    {
                        DesginKey = designKey,
                        MscPline = designMscJgPlEntity.MscPline,
                        CodeJg = designMscJgPlEntity.CodeJg
                    });

                foreach (CraftOrdDesignMscJgPlStiEntity designMscJgPlStiEntity in designMscJgPlStiEntityList)
                {
                    UltraTreeNode mscProcessNode = CreateNode(designMscJgPlStiEntity.ProcessDesc, designMscJgPlStiEntity);
                    mscPlineNode.Nodes.Add(mscProcessNode);
                }
            }
        }

        /// <summary>
        /// 初始化制程向下的数据
        /// </summary>
        /// <param name="node"></param>
        /// <param name="designKey"></param>
        private void InitMscPlineDown(UltraTreeNode node, string designKey)
        {
            List<CraftOrdDesignMscPlEntity> designMscPlEntityList = _designMscPlBLL.QueryMscPlineByDesignKey(
                    new CraftOrdDesignMscPlEntity() { DesginKey = designKey });
            foreach (CraftOrdDesignMscPlEntity designMscPlEntity in designMscPlEntityList)
            {
                UltraTreeNode mscPlineNode = CreateNode(designMscPlEntity.MscPline, designMscPlEntity);
                node.Nodes.Add(mscPlineNode);

                //钢种
                List<CraftOrdDesignMscPlGzEntity> designMscPlGzEntityList = _designMscPlGzBLL.QueryGradeByDesignKey(
                    new CraftOrdDesignMscPlGzEntity() { DesginKey = designKey, MscPline = designMscPlEntity.MscPline });
                foreach (CraftOrdDesignMscPlGzEntity designMscPlGzEntity in designMscPlGzEntityList)
                {
                    UltraTreeNode mscGradeNode = CreateNode(designMscPlGzEntity.Gradename, designMscPlGzEntity);
                    mscPlineNode.Nodes.Add(mscGradeNode);
                }

                //工艺
                List<CraftOrdDesignMscCftEntity> designMscCftEntityList = _designMscCftBLL.QueryCraftByDesignKey(
                    new CraftOrdDesignMscCftEntity() { DesginKey = designKey, MscPline = designMscPlEntity.MscPline });
                foreach (CraftOrdDesignMscCftEntity designMscCftEntity in designMscCftEntityList)
                {
                    UltraTreeNode mscCftNode = CreateNode(designMscCftEntity.CraftitemDesc, designMscCftEntity);
                    mscPlineNode.Nodes.Add(mscCftNode);
                }

                //工序
                List<CraftOrdDesignMscPlPrcEntity> designMscPlPrcEntityList = _designMscPlPrcBLL.QueryProcessByDesignKey(
                    new CraftOrdDesignMscPlPrcEntity() { DesginKey = designKey, MscPline = designMscPlEntity.MscPline });
                foreach (CraftOrdDesignMscPlPrcEntity designMscPlPrcEntity in designMscPlPrcEntityList)
                {
                    UltraTreeNode mscProcessNode = CreateNode(designMscPlPrcEntity.ProcessDesc, designMscPlPrcEntity);
                    mscPlineNode.Nodes.Add(mscProcessNode);

                    List<CraftOrdDesignMscPlStiEntity> designMscPlStiEntityList = _designMscPlStiBLL.Query(
                         new CraftOrdDesignMscPlStiEntity()
                         {
                             DesginKey = designKey,
                             MscPline = designMscPlPrcEntity.MscPline,
                             ProcessCode = designMscPlPrcEntity.ProcessCode
                         });
                    foreach (CraftOrdDesignMscPlStiEntity designMscPlStiEntity in designMscPlStiEntityList)
                    {
                        UltraTreeNode mscStationNode = CreateNode(designMscPlStiEntity.StationDesc.ToString(), designMscPlStiEntity);
                        mscProcessNode.Nodes.Add(mscStationNode);
                    }

                    //成分
                    List<CraftOrdDesignStdCicEntity> designStdCicEntityList = _designStdCicBLL.QueryCicByDesignKey(
                        new CraftOrdDesignStdCicEntity() { DesginKey = designKey, Cic = designMscPlPrcEntity.Cic });
                    foreach (CraftOrdDesignStdCicEntity designStdCicEntity in designStdCicEntityList)
                    {
                        UltraTreeNode stdCicNode = CreateNode(designStdCicEntity.Cic, designStdCicEntity);
                        mscProcessNode.Nodes.Add(stdCicNode);
                    }

                    //理化
                    List<CraftOrdDesignStdPicEntity> designStdPicEntityList = _designStdPicBLL.QueryPicByDesignKey(
                        new CraftOrdDesignStdPicEntity() { DesginKey = designKey, Pic = designMscPlPrcEntity.Pic });
                    foreach (CraftOrdDesignStdPicEntity designStdPicEntity in designStdPicEntityList)
                    {
                        UltraTreeNode stdPicNode = CreateNode(designStdPicEntity.Pic, designStdPicEntity);
                        mscProcessNode.Nodes.Add(stdPicNode);
                    }

                    //探伤
                    List<CraftOrdDesignStdDicEntity> designStdDicEntityList = _designStdDicBLL.QueryDicByDesignKey(
                        new CraftOrdDesignStdDicEntity() { DesginKey = designKey, Dic = designMscPlPrcEntity.Dic });
                    foreach (CraftOrdDesignStdDicEntity designStdDicEntity in designStdDicEntityList)
                    {
                        UltraTreeNode stdDicNode = CreateNode(designStdDicEntity.Dic, designStdDicEntity);
                        mscProcessNode.Nodes.Add(stdDicNode);
                    }

                    //公差
                    List<CraftOrdDesignStdSicEntity> designStdSicEntityList = _designStdSicBLL.QuerySicByDesignKey(
                        new CraftOrdDesignStdSicEntity() { DesginKey = designKey, Sic = designMscPlPrcEntity.Sic });
                    foreach (CraftOrdDesignStdSicEntity designStdSicEntity in designStdSicEntityList)
                    {
                        UltraTreeNode stdSicNode = CreateNode(designStdSicEntity.Sic, designStdSicEntity);
                        mscProcessNode.Nodes.Add(stdSicNode);
                    }

                    //水压
                    List<CraftOrdDesignStdWicEntity> designStdWicEntityList = _designStdWicBLL.QueryWicByDesignKey(
                        new CraftOrdDesignStdWicEntity() { DesginKey = designKey, Wic = designMscPlPrcEntity.Wic });
                    foreach (CraftOrdDesignStdWicEntity designStdWicEntity in designStdWicEntityList)
                    {
                        UltraTreeNode stdWicNode = CreateNode(designStdWicEntity.Wic, designStdWicEntity);
                        mscProcessNode.Nodes.Add(stdWicNode);
                    }

                    //加工
                    List<CraftOrdDesignStdGicEntity> designStdGicEntityList = _designStdGicBLL.QueryGicByDesignKey(
                        new CraftOrdDesignStdGicEntity() { DesginKey = designKey, Gic = designMscPlPrcEntity.Gic });
                    foreach (CraftOrdDesignStdGicEntity designStdGicEntity in designStdGicEntityList)
                    {
                        UltraTreeNode stdGicNode = CreateNode(designStdGicEntity.Gic, designStdGicEntity);
                        mscProcessNode.Nodes.Add(stdGicNode);
                    }
                }
            }
        }

        private UltraTreeNode CreateNode(string text, object tag)
        {
            UltraTreeNode node = new UltraTreeNode(Guid.NewGuid().ToString(), text);
            node.Tag = tag;
            return node;
        }

        private void ultraTree1_AfterActivate(object sender, NodeEventArgs e)
        {
            try
            {
                this.Cursor = Cursors.WaitCursor;
                this.panel1.Controls.Clear();
                if (e.TreeNode.Tag is CraftOrdDesignMscEntity)
                {
                    CraftOrdDesignMscEntity designMscEntity = (CraftOrdDesignMscEntity)e.TreeNode.Tag;

                    if (e.TreeNode.Parent == null)//说明是备料的MSC
                    {
                        _designBlCtrl.Dock = DockStyle.Top;
                        this.panel1.Controls.Add(_designBlCtrl);
                        _designBlCtrl.Query(new CraftOrdDesignBlEntity() { DesginKey = designMscEntity.DesginKey });
                        _designMscJgCtrl.Dock = DockStyle.Top;
                        this.panel1.Controls.Add(_designMscJgCtrl);
                        _designMscJgCtrl.Query(new CraftOrdDesignMscJgEntity() { DesginKey = designMscEntity.DesginKey });
                    }
                    
                    _designMscPlCtrl.Dock = DockStyle.Top;
                    this.panel1.Controls.Add(_designMscPlCtrl);
                    _designMscCtrl.Dock = DockStyle.Top;
                    this.panel1.Controls.Add(_designMscCtrl);
                    
                    _designMscCtrl.Query(new CraftOrdDesignMscEntity() { DesginKey = designMscEntity.DesginKey });
                    _designMscPlCtrl.Query(new CraftOrdDesignMscPlEntity() { DesginKey = designMscEntity.DesginKey });
                }
                else if (e.TreeNode.Tag is CraftOrdDesignMscPlEntity)
                {
                    CraftOrdDesignMscPlEntity designMscPlEntity = (CraftOrdDesignMscPlEntity)e.TreeNode.Tag;
                    _designMscPlPrcCtrl.Dock = DockStyle.Top;
                    this.panel1.Controls.Add(_designMscPlPrcCtrl);
                    _baseGradeCtrl.Dock = DockStyle.Top;
                    this.panel1.Controls.Add(_baseGradeCtrl);
                    _designMscCftCtrl.Dock = DockStyle.Top;
                    this.panel1.Controls.Add(_designMscCftCtrl);
                    _designMscPlCtrl.Dock = DockStyle.Top;
                    this.panel1.Controls.Add(_designMscPlCtrl);
                    
                    _designMscPlCtrl.Query(new CraftOrdDesignMscPlEntity()
                    {
                        DesginKey = designMscPlEntity.DesginKey,
                        MscPline = designMscPlEntity.MscPline
                    });
                    List<CraftOrdDesignMscPlGzEntity> designMscPlGzEntityList = _designMscPlGzBLL.QueryGradeByDesignKey(
                        new CraftOrdDesignMscPlGzEntity()
                        {
                            DesginKey = designMscPlEntity.DesginKey,
                            MscPline = designMscPlEntity.MscPline
                        });
                    string gradeCodes = "";
                    foreach (CraftOrdDesignMscPlGzEntity designMscPlGzEntity in designMscPlGzEntityList)
                    {
                        gradeCodes += designMscPlGzEntity.Gradecode + ",";
                    }
                    _baseGradeCtrl.Query(new ComBaseGradeEntity() { Gradecode = gradeCodes });
                    _designMscCftCtrl.Query(new CraftOrdDesignMscCftEntity()
                    {
                        DesginKey = designMscPlEntity.DesginKey,
                        MscPline = designMscPlEntity.MscPline
                    });
                    _designMscPlPrcCtrl.Query(new CraftOrdDesignMscPlPrcEntity()
                    {
                        DesginKey = designMscPlEntity.DesginKey,
                        MscPline = designMscPlEntity.MscPline
                    });


                }
                else if (e.TreeNode.Tag is CraftOrdDesignMscPlGzEntity)
                {
                    CraftOrdDesignMscPlGzEntity designMscPlGzEntity = (CraftOrdDesignMscPlGzEntity)e.TreeNode.Tag;
                    _baseGradeCtrl.Dock = DockStyle.Fill;
                    this.panel1.Controls.Add(_baseGradeCtrl);
                    _baseGradeCtrl.Query(new ComBaseGradeEntity() { Gradecode = designMscPlGzEntity.Gradecode });
                }
                else if (e.TreeNode.Tag is CraftOrdDesignMscCftEntity)
                {
                    CraftOrdDesignMscCftEntity designMscCftEntity = (CraftOrdDesignMscCftEntity)e.TreeNode.Tag;
                    _designMscCftCtrl.Dock = DockStyle.Fill;
                    this.panel1.Controls.Add(_designMscCftCtrl);
                    _designMscCftCtrl.Query(new CraftOrdDesignMscCftEntity()
                    {
                        DesginKey = designMscCftEntity.DesginKey,
                        MscPline = designMscCftEntity.MscPline,
                        CraftitemCdoe = designMscCftEntity.CraftitemCdoe
                    });
                }
                else if (e.TreeNode.Tag is CraftOrdDesignMscPlPrcEntity)
                {
                    CraftOrdDesignMscPlPrcEntity designMscPlPrcEntity = (CraftOrdDesignMscPlPrcEntity)e.TreeNode.Tag;
                    _designStdGicCtrl.Dock = DockStyle.Top;
                    this.panel1.Controls.Add(_designStdGicCtrl);
                    _designStdWicCtrl.Dock = DockStyle.Top;
                    this.panel1.Controls.Add(_designStdWicCtrl);
                    _designStdSicCtrl.Dock = DockStyle.Top;
                    this.panel1.Controls.Add(_designStdSicCtrl);
                    _designStdDicCtrl.Dock = DockStyle.Top;
                    this.panel1.Controls.Add(_designStdDicCtrl);
                    _designStdPicCtrl.Dock = DockStyle.Top;
                    this.panel1.Controls.Add(_designStdPicCtrl);
                    _designStdCicCtrl.Dock = DockStyle.Top;
                    this.panel1.Controls.Add(_designStdCicCtrl);
                    _designMscPlStiCtrl.Dock = DockStyle.Top;
                    this.panel1.Controls.Add(_designMscPlStiCtrl);
                    _designMscPlPrcCtrl.Dock = DockStyle.Top;
                    this.panel1.Controls.Add(_designMscPlPrcCtrl);

                    _designMscPlPrcCtrl.Query(new CraftOrdDesignMscPlPrcEntity()
                    {
                        DesginKey = designMscPlPrcEntity.DesginKey,
                        MscPline = designMscPlPrcEntity.MscPline,
                        ProcessCode = designMscPlPrcEntity.ProcessCode
                    });
                    _designStdGicCtrl.Query(new CraftOrdDesignStdGicEntity() 
                    {
                        DesginKey = designMscPlPrcEntity.DesginKey, Gic = designMscPlPrcEntity.Gic 
                    });
                    _designStdWicCtrl.Query(new CraftOrdDesignStdWicEntity()
                    {
                        DesginKey = designMscPlPrcEntity.DesginKey,
                        Wic = designMscPlPrcEntity.Wic
                    });
                    _designStdSicCtrl.Query(new CraftOrdDesignStdSicEntity()
                    {
                        DesginKey = designMscPlPrcEntity.DesginKey,
                        Sic = designMscPlPrcEntity.Sic
                    });
                    _designStdDicCtrl.Query(new CraftOrdDesignStdDicEntity()
                    {
                        DesginKey = designMscPlPrcEntity.DesginKey,
                        Dic = designMscPlPrcEntity.Dic
                    });
                    _designStdPicCtrl.Query(new CraftOrdDesignStdPicEntity()
                    {
                        DesginKey = designMscPlPrcEntity.DesginKey,
                        Pic = designMscPlPrcEntity.Pic
                    });
                    _designStdCicCtrl.Query(new CraftOrdDesignStdCicEntity()
                    {
                        DesginKey = designMscPlPrcEntity.DesginKey,
                        Cic = designMscPlPrcEntity.Cic
                    });
                    _designMscPlStiCtrl.Query(new CraftOrdDesignMscPlStiEntity()
                    {
                        DesginKey = designMscPlPrcEntity.DesginKey,
                        MscPline = designMscPlPrcEntity.MscPline,
                        ProcessCode = designMscPlPrcEntity.ProcessCode
                    });
                }
                else if (e.TreeNode.Tag is CraftOrdDesignMscPlStiEntity)
                {
                    CraftOrdDesignMscPlStiEntity designMscPlStiEntity = (CraftOrdDesignMscPlStiEntity)e.TreeNode.Tag;
                    _designMscPlStiCtrl.Dock = DockStyle.Fill;
                    this.panel1.Controls.Add(_designMscPlStiCtrl);
                    _designMscPlStiCtrl.Query(new CraftOrdDesignMscPlStiEntity()
                    {
                        DesginKey = designMscPlStiEntity.DesginKey,
                        MscPline = designMscPlStiEntity.MscPline,
                        ProcessCode = designMscPlStiEntity.ProcessCode,
                        StationCode = designMscPlStiEntity.StationCode
                    });
                }
                else if (e.TreeNode.Tag is CraftOrdDesignMscJgEntity)
                {
                    CraftOrdDesignMscJgEntity designMscJgEntity = (CraftOrdDesignMscJgEntity)e.TreeNode.Tag;
                    _designBlCtrl.Dock = DockStyle.Top;
                    this.panel1.Controls.Add(_designBlCtrl);
                    _designMscPlCtrl.Dock = DockStyle.Top;
                    this.panel1.Controls.Add(_designMscPlCtrl);
                    _designMscJgCtrl.Dock = DockStyle.Top;
                    this.panel1.Controls.Add(_designMscJgCtrl);

                    _designMscJgCtrl.Query(new CraftOrdDesignMscJgEntity()
                    {
                        DesginKey = designMscJgEntity.DesginKey,
                        CodeJg = designMscJgEntity.CodeJg
                    });
                    _designMscPlCtrl.Query(new CraftOrdDesignMscPlEntity()
                    {
                        DesginKey = designMscJgEntity.DesginKey
                    });

                    List<CraftOrdDesignMscJgBlEntity> designMscJgBlEntityList = _desginMscJgBlBLL.Query(new CraftOrdDesignMscJgBlEntity()
                    {
                        DesginKey = designMscJgEntity.DesginKey,
                        CodeJg = designMscJgEntity.CodeJg
                    });
                    string designKeys = "'1'";
                    foreach (CraftOrdDesignMscJgBlEntity designMscJgBlEntity2 in designMscJgBlEntityList)
                    {
                        designKeys += ", '" + designMscJgBlEntity2.DesginKeyBl + "'";
                    }
                    designKeys = designKeys.Substring(1, designKeys.Length - 1);
                    designKeys = designKeys.Substring(0, designKeys.Length - 1);
                    _designBlCtrl.QueryByDesignKeys(designKeys);
                }
                else if (e.TreeNode.Tag is CraftOrdDesignMscJgPlEntity)
                {
                    CraftOrdDesignMscJgPlEntity designMscJgPlEntity = (CraftOrdDesignMscJgPlEntity)e.TreeNode.Tag;

                    _designMscJgPlStiCtrl.Dock = DockStyle.Top;
                    this.panel1.Controls.Add(_designMscJgPlStiCtrl);

                    _designMscJgPlStiCtrl.Query(new CraftOrdDesignMscJgPlStiEntity()
                    {
                        DesginKey = designMscJgPlEntity.DesginKey,
                        CodeJg = designMscJgPlEntity.CodeJg,
                        MscPline = designMscJgPlEntity.MscPline
                    });

                    _designMscPlCtrl.Dock = DockStyle.Top;
                    this.panel1.Controls.Add(_designMscPlCtrl);
                    _designMscPlCtrl.Query(new CraftOrdDesignMscJgPlEntity()
                    {
                        DesginKey = designMscJgPlEntity.DesginKey,
                        MscPline = designMscJgPlEntity.MscPline
                    });
                }
                else if (e.TreeNode.Tag is CraftOrdDesignMscJgBlEntity)
                {
                    CraftOrdDesignMscJgBlEntity designMscJgBlEntity = (CraftOrdDesignMscJgBlEntity)e.TreeNode.Tag;
                    _designBlCtrl.Dock = DockStyle.Top;
                    this.panel1.Controls.Add(_designBlCtrl);
                    _designMscCtrl.Dock = DockStyle.Top;
                    this.panel1.Controls.Add(_designMscCtrl);

                    _designBlCtrl.Query(new CraftOrdDesignBlEntity() { DesginKey = designMscJgBlEntity.DesginKeyBl });

                    _designMscCtrl.Query(new CraftOrdDesignMscEntity() { DesginKey = designMscJgBlEntity.DesginKey });

                }
                else if (e.TreeNode.Tag is CraftOrdDesignMscBlEntity)
                {
                    CraftOrdDesignMscBlEntity designMscBlEntity = (CraftOrdDesignMscBlEntity)e.TreeNode.Tag;
                    _designBlCtrl.Dock = DockStyle.Top;
                    this.panel1.Controls.Add(_designBlCtrl);
                    _designMscCtrl.Dock = DockStyle.Top;
                    this.panel1.Controls.Add(_designMscCtrl);
                    _designMscCtrl.BringToFront();

                    _designBlCtrl.Query(new CraftOrdDesignBlEntity() { DesginKey = designMscBlEntity.DesginKeyBl });
                    _designMscCtrl.Query(new CraftOrdDesignMscEntity() { DesginKey = designMscBlEntity.DesginKey });
                }
                else if (e.TreeNode.Tag is CraftOrdDesignMscJgPlStiEntity)
                {
                    CraftOrdDesignMscJgPlStiEntity designMscJgPlStiEntity = (CraftOrdDesignMscJgPlStiEntity)e.TreeNode.Tag;
                    _designMscJgPlStiCtrl.Dock = DockStyle.Fill;
                    this.panel1.Controls.Add(_designMscJgPlStiCtrl);

                    _designMscJgPlStiCtrl.Query(new CraftOrdDesignMscJgPlStiEntity()
                    {
                        DesginKey = designMscJgPlStiEntity.DesginKey,
                        CodeJg = designMscJgPlStiEntity.CodeJg,
                        MscPline = designMscJgPlStiEntity.MscPline,
                        ProcessCode = designMscJgPlStiEntity.ProcessCode
                    });
                }
                else if (e.TreeNode.Tag is CraftOrdDesignStdCicEntity)
                {
                    CraftOrdDesignStdCicEntity designStdCicEntity = (CraftOrdDesignStdCicEntity)e.TreeNode.Tag;
                    _designStdCicCtrl.Dock = DockStyle.Fill;
                    this.panel1.Controls.Add(_designStdCicCtrl);
                    _designStdCicCtrl.Query(new CraftOrdDesignStdCicEntity()
                    {
                        DesginKey = designStdCicEntity.DesginKey,
                        Cic = designStdCicEntity.Cic
                    });
                }
                else if (e.TreeNode.Tag is CraftOrdDesignStdPicEntity)
                {
                    CraftOrdDesignStdPicEntity designStdPicEntity = (CraftOrdDesignStdPicEntity)e.TreeNode.Tag;
                    _designStdPicCtrl.Dock = DockStyle.Fill;
                    this.panel1.Controls.Add(_designStdPicCtrl);
                    _designStdPicCtrl.Query(new CraftOrdDesignStdPicEntity()
                    {
                        DesginKey = designStdPicEntity.DesginKey,
                        Pic = designStdPicEntity.Pic
                    });
                }
                else if (e.TreeNode.Tag is CraftOrdDesignStdDicEntity)
                {
                    CraftOrdDesignStdDicEntity designStdDicEntity = (CraftOrdDesignStdDicEntity)e.TreeNode.Tag;
                    _designStdDicCtrl.Dock = DockStyle.Fill;
                    this.panel1.Controls.Add(_designStdDicCtrl);
                    _designStdDicCtrl.Query(new CraftOrdDesignStdDicEntity()
                    {
                        DesginKey = designStdDicEntity.DesginKey,
                        Dic = designStdDicEntity.Dic
                    });
                }
                else if (e.TreeNode.Tag is CraftOrdDesignStdSicEntity)
                {
                    CraftOrdDesignStdSicEntity designStdSicEntity = (CraftOrdDesignStdSicEntity)e.TreeNode.Tag;
                    _designStdSicCtrl.Dock = DockStyle.Fill;
                    this.panel1.Controls.Add(_designStdSicCtrl);
                    _designStdSicCtrl.Query(new CraftOrdDesignStdSicEntity()
                    {
                        DesginKey = designStdSicEntity.DesginKey,
                        Sic = designStdSicEntity.Sic
                    });
                }
                else if (e.TreeNode.Tag is CraftOrdDesignStdWicEntity)
                {
                    CraftOrdDesignStdWicEntity designStdWicEntity = (CraftOrdDesignStdWicEntity)e.TreeNode.Tag;
                    _designStdWicCtrl.Dock = DockStyle.Fill;
                    this.panel1.Controls.Add(_designStdWicCtrl);
                    _designStdWicCtrl.Query(new CraftOrdDesignStdWicEntity()
                    {
                        DesginKey = designStdWicEntity.DesginKey,
                        Wic = designStdWicEntity.Wic
                    });
                }
                else if (e.TreeNode.Tag is CraftOrdDesignStdGicEntity)
                {
                    CraftOrdDesignStdGicEntity designStdGicEntity = (CraftOrdDesignStdGicEntity)e.TreeNode.Tag;
                    _designStdGicCtrl.Dock = DockStyle.Fill;
                    this.panel1.Controls.Add(_designStdGicCtrl);
                    _designStdGicCtrl.Query(new CraftOrdDesignStdGicEntity()
                    {
                        DesginKey = designStdGicEntity.DesginKey,
                        Gic = designStdGicEntity.Gic
                    });
                }

                _designMscCtrl.Height = GetGridHeight(_designMscCtrl.UltraGrid1);
                _designMscPlCtrl.Height = GetGridHeight(_designMscPlCtrl.UltraGrid1);
                _designMscJgCtrl.Height = GetGridHeight(_designBlCtrl.UltraGrid1);
                _designBlCtrl.Height = GetGridHeight(_designBlCtrl.UltraGrid1);
                _designMscCftCtrl.Height = GetGridHeight(_designMscCftCtrl.UltraGrid1);
                _designMscPlGzCtrl.Height = GetGridHeight(_designMscPlGzCtrl.UltraGrid1);
                _designMscPlPrcCtrl.Height = GetGridHeight(_designMscPlPrcCtrl.UltraGrid1);
                _designStdCicCtrl.Height = GetGridHeight(_designStdCicCtrl.EntityGrid1);
                _designStdPicCtrl.Height = GetGridHeight(_designStdPicCtrl.EntityGrid1);
                _designStdDicCtrl.Height = GetGridHeight(_designStdDicCtrl.EntityGrid1);
                _designStdSicCtrl.Height = GetGridHeight(_designStdSicCtrl.EntityGrid1);
                _designStdWicCtrl.Height = GetGridHeight(_designStdWicCtrl.EntityGrid1);
                _designStdGicCtrl.Height = GetGridHeight(_designStdGicCtrl.EntityGrid1);
                _designMscJgPlStiCtrl.Height = GetGridHeight(_designMscJgPlStiCtrl.UltraGrid1);
                _baseGradeCtrl.Height = GetGridHeight(_baseGradeCtrl.UltraGrid1);
                _designMscPlStiCtrl.Height = GetGridHeight(_designMscPlStiCtrl.UltraGrid1);
                
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }

        private int GetGridHeight(UltraGrid grid)
        {
            if (grid.Rows.Count > 5)
            {
                return grid.Rows.Count * CELL_HEIGHT + HEAD_HEIGHT;
            }
            else
            {
                return grid.Rows.Count * CELL_HEIGHT + HEAD_HEIGHT; //滚动条也会占用高度。
            }
        }

        private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            try
            {
                this.Cursor = Cursors.WaitCursor;
                InitTree();
                ultraTree1.ExpandAll();
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }
    }
}