MES_Client/TGMES/Core.StlMes.Client.PlnSaleOrd/JGGXPln/Control/ComPlnJgOrdToDd.cs

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.JGGXPln;
using Core.StlMes.Client.PlnSaleOrd.JGGXPln.Entity;
using Core.StlMes.Client.PlnSaleOrd.JGGXPln.model;
using CoreFS.CA06;
using Infragistics.Win.UltraWinGrid;
using System;
using System.Collections;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Windows.Forms;

namespace Core.StlMes.Client.PlnSaleOrd
{
    /// <summary>
    /// 接箍合同组订单
    /// date 2016.03.17
    /// author Tianhai-Yang
    /// </summary>
    public partial class ComPlnJgOrdToDd : UserControl
    {
        public OpeBase _ob = null;
        private int _splitterDistance1 = 0;
        private int _splitterDistance2 = 0;
        private int _splitterDistance3 = 0;
        private bool _groupBox1ExpandedChanged = false;
        private bool _groupBox2ExpandedChanged = false;
        private bool _groupBox3ExpandedChanged = false;
        private bool _groupBox4ExpandedChanged = false;

        public ComPlnJgOrdToDd()
        {
            InitializeComponent();
            Init();
        }

        /// <summary>
        /// 初始化
        /// </summary>
        public void Init()
        {
            EntityHelper.ShowGridCaption<FrmPlnGxJgMEntity>(ultraGridJgGxM.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<PlnGxJgPropEntity>(ultraGridJgGxProP.DisplayLayout.Bands[0]);

            PlanComm.setGridActivation(ultraGridJgOrd.DisplayLayout.Bands[0], "CHC");
            PlanComm.setGridActivation(ultraGridJgGxM.DisplayLayout.Bands[0], "CHC");
            PlanComm.setGridActivation(ultraGridJgGxProP.DisplayLayout.Bands[0]);
            PlanComm.setGridActivation(ultraGridJgGxOrd.DisplayLayout.Bands[0], "CHC");

            PlanComm.setGridDigitalCol(ultraGridJgGxOrd.DisplayLayout.Bands[0], 5, 0,
                "PRODUCED_NUM", "PLANNUM");
            PlanComm.setGridDigitalCol(ultraGridJgGxM.DisplayLayout.Bands[0], 5, 2,
                "Outdiameter", "Wallthick", "Aimlength", "Singleweight", "Diameter", "DiameterJg",
                "CheckJVal", "MinD", "MinH", "BlMinDOut", "BlMaxDIn", "AimlengthBl", "HeightJg",
                "DiameterPl", "HeightPl", "LengthMin", "LengthMax", "LengthJg", "WeightJg",
                "MinDCp", "MaxDCp", "LengthMin", "LengthMax", "MinHCp", "MaxHCp", "MinDJg", "MaxDJg");
            PlanComm.setGridDigitalCol(ultraGridJgGxM.DisplayLayout.Bands[0], 5, 3, "BlWeight");
            PlanComm.setGridDigitalCol(ultraGridJgGxM.DisplayLayout.Bands[0], 5, 0,
                "ProducedNum", "ZyplanNum", "BlNum", "PlanNum");
            PlanComm.setGridDigitalCol(ultraGridJgGxProP.DisplayLayout.Bands[0], 7, 3, "GroupBlWt");
            PlanComm.setGridDigitalCol(ultraGridJgGxProP.DisplayLayout.Bands[0], 5, 0,
                "GroupNum", "SingleCutNun", "GroupBlNum", "ProducedNum");
            PlanComm.setGridDigitalCol(ultraGridJgGxProP.DisplayLayout.Bands[0], 7, 2,
                "MinD", "MinH", "AimlengthBl", "AimCutLen", "LengthMin", "LengthMax");

            ultraGridJgGxM.DisplayLayout.Bands[0].Columns["Monitordemand"].EditorComponent = ultraTextEditorLook;
            ultraGridJgGxM.DisplayLayout.Bands[0].Columns["Monitordemand"].ButtonDisplayStyle
                = Infragistics.Win.UltraWinGrid.ButtonDisplayStyle.Always;
        }

        /// <summary>
        /// 刷新
        /// </summary>
        public void RefresDate()
        {
            DataTable dtjg = ServerHelper.GetData("com.steering.pss.plnsaleord.jggxpln.CorePlnJgOrdToDd.queryJgOrdNo",
                new object[] { }, _ob);
            if (dtjg != null && dtjg.Rows.Count > 0)
            {
                DataRow dr = dtjg.NewRow();
                dtjg.Rows.InsertAt(dr, 0);
            }
            ultraComboJgOrdNo.DataSource = dtjg;
            ultraComboJgOrdNo.DisplayMember = "JG_ORDERNO";
            ultraComboJgOrdNo.ValueMember = "JG_ORDERNO";

            DataTable dtDd = ServerHelper.GetData("com.steering.pss.plnsaleord.jggxpln.CorePlnJgOrdToDd.queryJgGxMNo",
                new object[] { }, _ob);
            if (dtDd != null && dtDd.Rows.Count > 0)
            {
                DataRow dr = dtDd.NewRow();
                dtDd.Rows.InsertAt(dr, 0);
            }
            ultraComboJgDdNo.DataSource = dtDd;
            ultraComboJgDdNo.DisplayMember = "PRO_PLAN_ID";
            ultraComboJgDdNo.ValueMember = "PRO_PLAN_ID";
        }

        /// <summary>
        /// 查询
        /// </summary>
        public void DoQuery()
        {
            string strJgOrdNo = "";
            string strJgDdNo = "";
            string strShowBlDeal = "0";
            if (checkBoxJgOrdNo.Checked)
            {
                strJgOrdNo = this.ultraComboJgOrdNo.Text;
            }
            if (checkBoxJgDdNo.Checked)
            {
                strJgDdNo = this.ultraComboJgDdNo.Text;
            }
            if(checkBoxShowBlDeal.Checked)
            {
                strShowBlDeal = "1";
            }

            bindingSourcePlnGxJgPropEntity.Clear();
            dataTableJgOrdE.Clear();
            DataTable dtjg = ServerHelper.GetData("com.steering.pss.plnsaleord.jggxpln.CorePlnJgOrdToDd.queryJgOrd",
                new object[] { strJgOrdNo }, _ob);
            GridHelper.CopyDataToDatatable(dtjg, dataTableJgOrd, true);

            bindingSourcePlnGxJgPropEntity.DataSource = new DataSourceList<PlnGxJgPropEntity>();
            dataTableGxJgOrd.Clear();
            bindingSourcePlnGxJgMEntity.DataSource = EntityHelper.GetData<FrmPlnGxJgMEntity>(
                "com.steering.pss.plnsaleord.jggxpln.CorePlnJgOrdToDd.queryJgGxM", new object[] { strJgDdNo, strShowBlDeal }, _ob);
        }

        /// <summary>
        /// 新建订单
        /// </summary>
        public void DoAdd()
        {
            ultraGridJgOrd.UpdateData();
            int jgGxNum = 0;
            int num = 0;
            string messageErr = "";
            IQueryable<UltraGridRow> checkedRows = ultraGridJgOrd.Rows.AsQueryable().Where(" CHC = 'True' ");
            if (checkedRows.Count() == 0)
            {
                MessageUtil.ShowTips("没有勾选任何行！");
                return;
            }
            #region 计算合并订单数
            PlanComm.WaitFromOpen(this.Cursor);
            var count1 = checkedRows.GroupBy(a => a.Cells["CODE_JG"].Value.ToString());
            foreach (var varGroup1 in count1)
            {
                IQueryable<UltraGridRow> codeRows = checkedRows.AsQueryable().Where(" CODE_JG = '" + varGroup1.Key + "' ");
                if (codeRows.Count() == 0)
                {
                    continue;
                }

                var count2 = codeRows.GroupBy(a => a.Cells["PRD_STATION_DEPT"].Value.ToString());
                foreach (var varGroup2 in count2)
                {
                    IQueryable<UltraGridRow> codeRows2 = codeRows.AsQueryable().Where(" PRD_STATION_DEPT = '" + varGroup2.Key + "' ");
                    if (codeRows2.Count() == 0)
                    {
                        continue;
                    }
                    var count3 = codeRows2.GroupBy(a => a.Cells["ALPHA_CODE"].Value.ToString());
                    foreach (var varGroup3 in count3)
                    {
                        IQueryable<UltraGridRow> codeRows3 = codeRows2.AsQueryable().Where(" ALPHA_CODE = '" + varGroup3.Key + "' ");
                        if (codeRows3.Count() == 0)
                        {
                            continue;
                        }
                        var count4 = codeRows3.GroupBy(a => a.Cells["CUST_ALPHA_NO"].Value.ToString());
                        num += count4.Count();
                    }
                }
            }
            PlanComm.WaitFromColse(this.Cursor);
            if (MessageUtil.ShowQuestion("将新建" + num + "条订单，确认这样的操作吗？") == DialogResult.No)
            {
                return;
            }
            #endregion

            #region 合并订单
            PlanComm.WaitFromOpen(this.Cursor);
            var query = checkedRows.GroupBy(a => a.Cells["CODE_JG"].Value.ToString());
            foreach (var codeGroup in query)
            {
                ///过滤出相同接箍码的条目
                IQueryable<UltraGridRow> codeRows = checkedRows.AsQueryable().Where(" CODE_JG = '" + codeGroup.Key + "' ");
                if (codeRows.Count() == 0)
                {
                    continue;
                }
                var queryAp = codeRows.GroupBy(a => a.Cells["ALPHA_CODE"].Value.ToString());
                foreach (var apGroup in queryAp)
                {
                    ///过滤出相同接箍码的条目
                    IQueryable<UltraGridRow> apRows = codeRows.AsQueryable().Where(" ALPHA_CODE = '" + apGroup.Key + "' ");
                    if (apRows.Count() == 0)
                    {
                        continue;
                    }

                    var querySpec = apRows.GroupBy(a => a.Cells["CUST_ALPHA_NO"].Value.ToString());
                    foreach (var sGroup in querySpec)
                    {
                        ///过滤出相同接箍码的条目
                        IQueryable<UltraGridRow> specRows = apRows.AsQueryable().Where(" CUST_ALPHA_NO = '" + sGroup.Key + "' ");
                        if (specRows.Count() == 0)
                        {
                            continue;
                        }

                        var queryPrdcr = specRows.GroupBy(a => a.Cells["PRD_STATION_DEPT"].Value.ToString());
                        foreach (var prdcrGroup in queryPrdcr)
                        {
                            ///过滤出相同接箍码，相同监制的条目
                            IQueryable<UltraGridRow> mRows = specRows.AsQueryable().Where(" PRD_STATION_DEPT = '" + prdcrGroup.Key + "' ");
                            if (mRows.Count() == 0)
                            {
                                continue;
                            }
                            ArrayList list = new ArrayList();
                            PlnGxJgMEntity gxJgM = new PlnGxJgMEntity();
                            foreach (UltraGridRow uRow in mRows)
                            {
                                list.Add(uRow.Cells["JG_ORDERNO"].Value.ToString());
                            }
                            gxJgM.CodeJg = codeGroup.Key;
                            gxJgM.CustAlphaNo = sGroup.Key;
                            gxJgM.OrderSpecialDesc = mRows.First().Cells["ORDER_SPECIAL_DESC"].Value.ToString();
                            gxJgM.AlphaCode = apGroup.Key;
                            gxJgM.AlphaName = mRows.First().Cells["ALPHA_NAME"].Value.ToString();
                            gxJgM.PrdcrNo = mRows.First().Cells["PRDCR_NO"].Value.ToString();
                            gxJgM.CreateName = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName();

                            CoreClientParam ccp = new CoreClientParam();
                            ccp.ServerName = "com.steering.pss.plnsaleord.jggxpln.CorePlnJgOrdToDd";
                            ccp.MethodName = "addJgGxM";
                            ccp.ServerParams = new object[] { list, JSONFormat.Format(gxJgM) };
                            ccp = _ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                            if (ccp == null)
                            {
                                PlanComm.WaitFromColse(this.Cursor);
                                MessageUtil.ShowTips("服务端处理失败！");
                                return;
                            }
                            if (ccp.ReturnCode < 0)
                            {
                                PlanComm.WaitFromColse(this.Cursor);
                                MessageUtil.ShowTips(ccp.ReturnInfo);
                                return;
                            }
                            if (ccp.ReturnObject != null &&
                                !ccp.ReturnObject.ToString().Equals(""))
                            {
                                messageErr = ccp.ReturnObject.ToString();
                                continue;
                            }
                            jgGxNum++;
                        }
                    }
                }
            }
            PlanComm.WaitFromColse(this.Cursor);
            #endregion
            if (jgGxNum != num)
            {
                MessageUtil.ShowTips(jgGxNum + "条订单新建成功，" + (num - jgGxNum)
                    + "条新建失败。\n" + messageErr);
            }
            else
            {
                MessageUtil.ShowTips(jgGxNum + "条订单新建成功。");
            }
            DoQuery();
        }

        /// <summary>
        /// 加入订单
        /// </summary>
        public void DoJoinJgM()
        {
            ultraGridJgOrd.UpdateData();
            ultraGridJgGxM.UpdateData();
            IQueryable<UltraGridRow> rows = ultraGridJgGxM.Rows.AsQueryable().Where(" CHC = 'True' ");
            if (rows.Count() != 1)
            {
                MessageUtil.ShowTips("请选择一条已有的接箍订单。");
                return;
            }
            ArrayList list = new ArrayList();
            string proPlanId = rows.First().Cells["ProPlanId"].Value.ToString();
            string prdcrNo = rows.First().Cells["PrdcrNo"].Value.ToString();
            string codeJg = rows.First().Cells["CodeJg"].Value.ToString();
            string alphaCode = rows.First().Cells["AlphaCode"].Value.ToString();
            string custAlphaNo = rows.First().Cells["CustAlphaNo"].Value.ToString();
            IQueryable<UltraGridRow> checkedRows = ultraGridJgOrd.Rows.AsQueryable().Where(" CHC = 'True' ");
            if (checkedRows.Count() == 0)
            {
                MessageUtil.ShowTips("请选择要加入订单中的接箍合同。");
                return;
            }
            #region 筛选是否符合合并条件
            IQueryable<UltraGridRow> wrongRows = checkedRows.AsQueryable().Where(" CODE_JG != '" + codeJg + "' ");
            if (wrongRows.Count() > 0)
            {
                MessageUtil.ShowTips("接箍合同：" + wrongRows.First().Cells["JG_ORDERNO"].Value.ToString()
                    + "不能合并到订单中（接箍码不同）。");
                return;
            }
            wrongRows = checkedRows.AsQueryable().Where(" CUST_ALPHA_NO != '" + custAlphaNo + "' ");
            if (wrongRows.Count() > 0)
            {
                MessageUtil.ShowTips("接箍合同：" + wrongRows.First().Cells["JG_ORDERNO"].Value.ToString()
                    + "不能合并到订单中（特殊要求不同）。");
                return;
            }
            wrongRows = checkedRows.AsQueryable().Where(" ALPHA_CODE != '" + alphaCode + "' ");
            if (wrongRows.Count() > 0)
            {
                MessageUtil.ShowTips("接箍合同：" + wrongRows.First().Cells["JG_ORDERNO"].Value.ToString()
                    + "不能合并到订单中（用途码不同）。");
                return;
            }
            #region 监制比较
            if (!prdcrNo.Trim().Equals(""))
            {
                var countPrdNo = checkedRows.GroupBy(a => a.Cells["PRDCR_NO"].Value.ToString());
                foreach (var varPrd in countPrdNo)
                {
                    if (!isSamePrdcr(prdcrNo, varPrd.Key, this._ob)
                        && !varPrd.Key.Equals(""))
                    {
                        wrongRows = checkedRows.AsQueryable().Where(" PRDCR_NO = '" + varPrd.Key + "' ");
                        if (wrongRows.Count() > 0)
                        {
                            MessageUtil.ShowTips("接箍合同：" + wrongRows.First().Cells["JG_ORDERNO"].Value.ToString()
                            + "不能合并到订单中（监制不同）。");
                            return;
                        }
                    }
                }
                if (MessageUtil.ShowQuestion("该订单需要监制,确认加入该订单吗？") == DialogResult.No)
                {
                    return;
                }
            }
            else
            {
                wrongRows = checkedRows.AsQueryable().Where(" PRDCR_NO != '' ");
                if (wrongRows.Count() > 0)
                {
                    var querys = wrongRows.GroupBy(a => a.Cells["PRD_STATION_DEPT"].Value.ToString());
                    if (querys.Count() == 1)
                    {
                        prdcrNo = querys.First().Key;
                        if (MessageUtil.ShowQuestion("所选的接箍合同有监制，确认加入该订单吗？") == DialogResult.No)
                        {
                            return;
                        }
                    }
                    else
                    {
                        MessageUtil.ShowTips("所选择的接箍合同中，监制有不同，不能合并。");
                        return;
                    }
                }
            }
            #endregion
            #endregion
            foreach (UltraGridRow uRow in checkedRows)
            {
                list.Add(uRow.Cells["JG_ORDERNO"].Value.ToString());
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.jggxpln.CorePlnJgOrdToDd";
            ccp.MethodName = "joinJgM";
            ccp.ServerParams = new object[] { list, proPlanId, prdcrNo,
                CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName() };
            ccp = _ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

            if (ccp == null)
            {
                MessageUtil.ShowError("服务端处理失败！");
                return;
            }
            if (ccp.ReturnCode < 0)
            {
                MessageUtil.ShowError(ccp.ReturnInfo);
                return;
            }
            if (ccp.ReturnObject != null)
            {
                MessageUtil.ShowTips(ccp.ReturnObject.ToString());
            }
            DoQuery();
        }

        /// <summary>
        /// 比较两个监制的接箍、接箍料监制工序点监制单位是否相同
        /// </summary>
        /// <param name="prdcrNo1"></param>
        /// <param name="prdcrNo2"></param>
        /// <param name="_opeBase"></param>
        /// <returns></returns>
        public bool isSamePrdcr(string prdcrNo1, string prdcrNo2, OpeBase _opeBase)
        {
            bool fl = false;
            DataTable dt1 = ServerHelper.GetData("com.steering.pss.plnsaleord.jggxpln.CorePlnJgOrdToDd.selectPrdStation",
                new object[] { prdcrNo1 }, _opeBase);
            DataTable dt2 = ServerHelper.GetData("com.steering.pss.plnsaleord.jggxpln.CorePlnJgOrdToDd.selectPrdStation",
                new object[] { prdcrNo2 }, _opeBase);
            if (dt1 != null && dt2 != null
                && dt1.Rows.Count == dt2.Rows.Count)
            {
                bool bl = true;
                for (int i = 0; i < dt1.Rows.Count; i++)
                {
                    if (!dt1.Rows[i]["STATION_CODE"].ToString().Equals(
                        dt2.Rows[i]["STATION_CODE"].ToString()))
                    {
                        bl = false;
                    }
                    if (!dt1.Rows[i]["PDEPT_NO"].ToString().Equals(
                        dt2.Rows[i]["PDEPT_NO"].ToString()))
                    {
                        bl = false;
                    }
                    if (!dt1.Rows[i]["PDEPT_NO2"].ToString().Equals(
                        dt2.Rows[i]["PDEPT_NO2"].ToString()))
                    {
                        bl = false;
                    }
                    if (!dt1.Rows[i]["PDEPT_NO3"].ToString().Equals(
                        dt2.Rows[i]["PDEPT_NO3"].ToString()))
                    {
                        bl = false;
                    }
                }
                if (bl)
                {
                    fl = true;
                }
            }
            return fl;
        }

        /// <summary>
        /// 删除订单
        /// </summary>
        public void DoDelete()
        {
            ultraGridJgGxM.UpdateData();
            ArrayList list = new ArrayList();
            IQueryable<UltraGridRow> rows = ultraGridJgGxM.Rows.AsQueryable().Where(" CHC = 'True' ");
            if (rows.Count() == 0)
            {
                MessageUtil.ShowTips("请选择要删除的接箍订单。");
                return;
            }
            foreach (UltraGridRow uRow in rows)
            {
                list.Add(uRow.Cells["ProPlanId"].Value.ToString());
            }
            if (MessageUtil.ShowQuestion("确认删除这" + list.Count + "条订单吗？") == DialogResult.No)
            {
                return;
            }

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.jggxpln.CorePlnJgOrdToDd";
            ccp.MethodName = "deleteGxJgM";
            ccp.ServerParams = new object[] { list };
            ccp = _ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

            if (ccp == null)
            {
                MessageUtil.ShowError("服务端处理失败！");
                return;
            }
            if (ccp.ReturnCode < 0)
            {
                //MessageUtil.ShowError(ccp.ReturnInfo);
                return;
            }
            //if (ccp.ReturnObject != null)
            //{
            //    MessageUtil.ShowTips(ccp.ReturnObject.ToString());
            //}
            DoQuery();
        }

        /// <summary>
        /// 从订单中移除
        /// </summary>
        public void DoDeleteOne()
        {
            ultraGridJgGxOrd.UpdateData();
            ArrayList list = new ArrayList();
            IQueryable<UltraGridRow> rows = ultraGridJgGxOrd.Rows.AsQueryable().Where(" CHC = 'True' ");
            if (rows.Count() == 0)
            {
                MessageUtil.ShowTips("请选择要从订单中移除的合同。");
                return;
            }
            var query = rows.GroupBy(UltraGridRow => UltraGridRow.Cells["PRO_PLAN_ID"].Value.ToString());
            if (query.Count() > 1)
            {
                MessageUtil.ShowTips("只能同时移除同一订单下的合同。");
                return;
            }
            foreach (UltraGridRow uRow in rows)
            {
                list.Add(uRow.Cells["JG_ORDERNO"].Value.ToString());
            }
            if (MessageUtil.ShowQuestion("确认删除这" + list.Count + "条订单明细吗？") == DialogResult.No)
            {
                return;
            }

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.jggxpln.CorePlnJgOrdToDd";
            ccp.MethodName = "deleteGxJgOrd";
            ccp.ServerParams = new object[] { list };
            ccp = _ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

            if (ccp == null)
            {
                MessageUtil.ShowError("服务端处理失败！");
                return;
            }
            if (ccp.ReturnCode < 0)
            {
                MessageUtil.ShowError(ccp.ReturnInfo);
                return;
            }
            if (ccp.ReturnObject != null)
            {
                MessageUtil.ShowTips(ccp.ReturnObject.ToString());
            }
            DoQuery();
        }

        /// <summary>
        /// 查询接箍库存
        /// </summary>
        /// <param name="codeJg"></param>
        /// <param name="custAlphaNo"></param>
        /// <param name="alphaCode"></param>
        public void DoQueryMatJg(string codeJg, string custAlphaNo, string alphaCode)
        {
            //DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.jggxpln.CorePlnJgOrdToDd.queryMatJg",
            //     new object[] { codeJg, custAlphaNo, alphaCode }, this._ob);
            // GridHelper.CopyDataToDatatable(dt, dataTableMatJg, true);
        }

        private void ultraGridJgGxM_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow ugr = ultraGridJgGxM.ActiveRow;
            if (ugr == null)
            {
                return;
            }
            DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.jggxpln.CorePlnJgOrdToDd.queryGxJgOrd",
                new object[] { ugr.Cells["ProPlanId"].Value.ToString() }, _ob);
            GridHelper.CopyDataToDatatable(dt, dataTableJgOrdE, true);

            bindingSourcePlnGxJgPropEntity.DataSource = EntityHelper.GetData<PlnGxJgPropEntity>(
                "com.steering.pss.plnsaleord.jggxpln.CorePlnJgOrdToDd.queryJgGxProp",
                new object[] { ugr.Cells["ProPlanId"].Value.ToString() }, _ob);
            DoQueryMatJg(ugr.Cells["CodeJg"].Value.ToString(), ugr.Cells["CustAlphaNo"].Value.ToString(),
                ugr.Cells["AlphaCode"].Value.ToString());
        }

        #region 事件
        private void splitContainer1_SplitterMoved(object sender, SplitterEventArgs e)
        {
            if (_groupBox1ExpandedChanged == false || _groupBox2ExpandedChanged == false)
            {
                _splitterDistance1 = splitContainer1.SplitterDistance;
                if (splitContainer1.SplitterDistance > 25)
                {
                    ultraExpandableJgOrd.Expanded = true;
                }
                else
                {
                    ultraExpandableJgOrd.Expanded = false;
                }

                if (splitContainer1.SplitterDistance < splitContainer1.Parent.Height - 77)
                {
                    ultraExpandableJgGxM.Expanded = true;
                }
                else
                {
                    ultraExpandableJgGxM.Expanded = false;
                }
            }
        }

        private void splitContainer2_SplitterMoved(object sender, SplitterEventArgs e)
        {
            if (_groupBox3ExpandedChanged == false)
            {
                _splitterDistance2 = splitContainer2.SplitterDistance;
                if (splitContainer2.SplitterDistance < splitContainer2.Parent.Height - 35)
                {
                    ultraExpandableJgGxOrd.Expanded = true;
                }
                else
                {
                    ultraExpandableJgGxOrd.Expanded = false;
                }
            }
        }

        private void splitContainer3_SplitterMoved(object sender, SplitterEventArgs e)
        {
            if (_groupBox4ExpandedChanged == false)
            {
                _splitterDistance3 = splitContainer3.SplitterDistance;
                if (splitContainer3.SplitterDistance < splitContainer3.Parent.Width - 35)
                {
                    ultraExpandableJgGxProP.Expanded = true;
                }
                else
                {
                    ultraExpandableJgGxProP.Expanded = false;
                }
            }
        }

        private void ultraExpandableJgOrd_ExpandedStateChanged(object sender, EventArgs e)
        {
            _groupBox1ExpandedChanged = true;
            if (ultraExpandableJgOrd.Expanded == false)
            {
                _groupBox2ExpandedChanged = true;
                ultraExpandableJgGxM.Expanded = true;
                splitContainer1.SplitterDistance = 0;
                _groupBox2ExpandedChanged = false;
            }
            else
            {
                splitContainer1.SplitterDistance = _splitterDistance1;
            }
            _groupBox1ExpandedChanged = false;
        }

        private void ultraExpandableJgGxM_ExpandedStateChanged(object sender, EventArgs e)
        {
            _groupBox2ExpandedChanged = true;
            if (ultraExpandableJgGxM.Expanded == false)
            {
                _groupBox1ExpandedChanged = true;
                ultraExpandableJgOrd.Expanded = true;
                splitContainer1.SplitterDistance = this.Height;
                _groupBox1ExpandedChanged = false;
            }
            else
            {
                splitContainer1.SplitterDistance = _splitterDistance1;
            }
            _groupBox2ExpandedChanged = false;
        }

        private void ultraExpandableJgGxOrd_ExpandedStateChanged(object sender, EventArgs e)
        {
            _groupBox3ExpandedChanged = true;
            if (ultraExpandableJgGxOrd.Expanded == false)
            {
                splitContainer2.SplitterDistance = this.Height;
            }
            else
            {
                splitContainer2.SplitterDistance = _splitterDistance2;
            }
            _groupBox3ExpandedChanged = false;
        }

        private void ultraExpandableJgGxProP_ExpandedStateChanged(object sender, EventArgs e)
        {
            _groupBox4ExpandedChanged = true;
            if (ultraExpandableJgGxProP.Expanded == false)
            {
                splitContainer3.SplitterDistance = this.Width;
            }
            else
            {
                splitContainer3.SplitterDistance = _splitterDistance3;
            }
            _groupBox4ExpandedChanged = false;
        }

        private void checkBoxJgDdNo_CheckedChanged(object sender, EventArgs e)
        {
            if (checkBoxJgDdNo.Checked)
            {
                ultraComboJgDdNo.Enabled = true;
            }
            else
            {
                ultraComboJgDdNo.Enabled = false;
            }
        }

        private void checkBoxJgOrdNo_CheckedChanged(object sender, EventArgs e)
        {
            if (checkBoxJgOrdNo.Checked)
            {
                ultraComboJgOrdNo.Enabled = true;
            }
            else
            {
                ultraComboJgOrdNo.Enabled = false;
            }
        }

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

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

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

        private void ultraGridJgGxProP_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow ugr = ultraGridJgGxProP.ActiveRow;
            if (ugr == null)
            {
                return;
            }
            foreach (UltraGridRow uRow in ultraGridJgGxOrd.Rows)
            {
                if (uRow.Cells["JG_GROUP_ID"].Value.ToString().Equals(
                    ugr.Cells["JgGroupId"].Value.ToString()))
                {
                    uRow.Appearance.BackColor = Color.FromArgb(255, 222, 173);
                }
                else
                {
                    if (uRow.Index % 2 == 0)
                    {
                        uRow.Appearance.BackColor = FrmBase.DefaultBackColor;
                    }
                    else 
                    {
                        uRow.Appearance.BackColor = Color.White;
                    }

                }
            }
        }
        #endregion

        private void ultraTextEditorLook_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            UltraGridRow ugr = ultraGridJgGxM.ActiveRow;
            if (ugr == null)
            {
                return;
            }

            string prdcrNo = ugr.Cells["PrdcrNo"].Value.ToString();
            string codeJg = ugr.Cells["CodeJg"].Value.ToString();
            FrmGxJgMPrdcrLst prdcr = new FrmGxJgMPrdcrLst(prdcrNo, codeJg, _ob);
            prdcr.Show();
        }
    }
}