MES_Client/TGMES/Core.StlMes.Client.PlnSaleOrd/FrmOrdFinishSet.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 CoreFS.CA06;
using Core.Mes.Client.Comm.Tool;
using com.steering.pss.plnsaleord.order.model;
using System.Collections;
using Infragistics.Win.UltraWinGrid;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm;
using Core.StlMes.Client.PlnSaleOrd.Control;
using Infragistics.Win;
using Core.StlMes.Client.PlnSaleOrd.PopupWindow;
using Core.StlMes.Client.PlnSaleOrd.工序排产;
using Core.Mes.Client.Comm.Control;

namespace Core.StlMes.Client.PlnSaleOrd
{
    public partial class FrmOrdFinishSet : FrmBase
    {
        public FrmOrdFinishSet()
        {
            this.IsLoadUserView = true;
            InitializeComponent();
            System.Threading.Thread t = new System.Threading.Thread(setGridColunmName);
            t.Start();
        }

        private void setGridColunmName()
        {
            System.Threading.Thread.Sleep(3000);
            if (!this.IsDisposed)
            {
                Init();
            }
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            base.ToolBar_Click(sender, ToolbarKey);
            switch (ToolbarKey)
            {
                case "Query":  //查询
                    DoQuery(GetQueryCondition());
                    break;
                case "FinishJk"://设置缴库完毕
                    DoFinishJk();
                    break;
                case "FinishSc"://设置生产完毕
                    DoFinishSc("0");
                    break;
                case "ApplyFill"://申请补量
                    DoApplyFill();
                    break;
                case "LookApplyFill"://查看补量
                    LookApplyFill();
                    break;
                case "ExportProc":
                    PlanComm.Export(ref ultraGridSaleOrder, "计划" + DateTime.Now.ToString("yyyyMMdd"));
                    break;
                case "QueryExp"://查询下发合同信息
                    comOrdExportCtrl1.DoQueryExp();
                    break;
                case "Export":  //导出
                    comOrdExportCtrl1.DoExport();
                    break;
                case "MandFinishSc"://强制生产完毕
                    DoFinishSc("1");
                    break;
                case "Close":  //关闭
                    this.Close();
                    break;
            }
        }
        private void FrmOrdFinishSet_Load(object sender, EventArgs e)
        {
            comOrdExportCtrl1.ComBLL(this.ob);
            comOrdExportCtrl1.UltraTextAcceptNo.Value = "X" + DateTime.Now.ToString("yyyyMM");
            comOrdExportCtrl1.CheckBoxAcpStatus.Checked = true;
            comOrdExportCtrl1.UltraComboEditAcpStatus.SelectedIndex = 3;
            comOrdExportCtrl1.UltraDateTimeDELVRY_EDATEFrom.DateTime = DateTime.Now.AddMonths(-1);
            comOrdExportCtrl1.UltraDateTimeDELVRY_EDATETo.DateTime = DateTime.Now;

            comQueryPanel1.checkBoxForReqPORDERSTATUS.Enabled = false;
            comQueryPanel1.ultraTextEditorAcceptNo.Value = "X" + DateTime.Now.ToString("yyyyMMdd");
            Init();
            if (this.CustomInfo.Equals("@JkFinish"))
            {
                this.comQueryPanel1.checkBoxisBl.Visible = true;
            }
            //DoQuery(GetQueryCondition());
        }

        private void Init()
        {
            EntityHelper.ShowGridCaption<PlnSaleOrderQueryEntity>(ultraGridSaleOrder.DisplayLayout.Bands[0]);
            PlanComm.setGridActivation(this.ultraGridSaleOrder.DisplayLayout.Bands[0], "CHC");
            //PlanComm.setGridDigitalCol(ultraGridSaleOrder.DisplayLayout.Bands[0], 5, 3,
            //            "OrderQty", "Orderweight", "Planweight", "Paydownweight", "Lengthmax", "Lengthmin",
            //            "ReqQtysum", "ConfirmWtSum", "PaydownWtMin", "PaydownWtMax");
            //PlanComm.setGridDigitalCol(ultraGridSaleOrder.DisplayLayout.Bands[0], 5, 2,
            //    "Totlength", "TotlengthM");
            //PlanComm.setGridDigitalCol(ultraGridSaleOrder.DisplayLayout.Bands[0], 5, 2,
            //    "Outdiameter", "Wallthick", "LenToendMin", "LenRollMin", "LenRollMax",
            //    "LenToendMax", "LengthJg", "HeightOrdMax", "HeightOrdMin");
            //PlanComm.setGridDigitalCol(ultraGridSaleOrder.DisplayLayout.Bands[0], 5, 0,
            //     "Ordernum", "PaydownNum");
            PlanComm.setGridDigitalCol(ultraGridSaleOrder.DisplayLayout.Bands[0], 5, 3,
                        "OrderQtyD", "PlanWtD", "FinishWt", "PlanWtBegin", "PlanPMain");
            PlanComm.setGridDigitalCol(ultraGridSaleOrder.DisplayLayout.Bands[0], 5, 2,
                "Outdiameter", "Wallthick", "Lengthmax", "Lengthmin", "TotLenOneP",
                "HeightNkMin", "HeightNkMax", "LenToendMin", "LenToendMax","DelvryRangeMin", "DelvryRangeMax",
                "LengthJg", "DimaterYlg", "HeightYlg", "HeightOrdMax", "HeightOrdMin",
                "AimWallthick", "RollLength", "ShrtLenRato", "LongLenRato", "LenRollMin", "LenRollMax");
            PlanComm.setGridDigitalCol(ultraGridSaleOrder.DisplayLayout.Bands[0], 5, 3,
                 "AimLenEnd", "AimLenRoll", "SiglLen", "EndlenSpecstd", "DifrncLenMax",
                 "AvgLenMin", "Longest", "Shortest", "ZOrderweight");
            PlanComm.setGridDigitalCol(ultraGridSaleOrder.DisplayLayout.Bands[0], 5, 0,
                 "PlanNumD", "PlanNumBegin", "CutNumP", "ZOrdernum");
            PlanComm.setGridDigitalCol(ultraGridSaleOrder.DisplayLayout.Bands[0], 3, 6,
                 "WeightPerM");
            PlanComm.setGridSummarySet(ultraGridSaleOrder, 0, "PlanNumD");
            PlanComm.setGridSummarySet(ultraGridSaleOrder, 3,
                "OrderQtyD", "PlanWtD", "FinishWt", "PlanWtBegin", "PlanPMain");
            switch (this.CustomInfo.ToString().Trim())
            {
                case "@ScFinish":
                    ultraTabControl1.Tabs[1].Visible = true;
                    comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Clear();
                    comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Add("1", "在产合同");
                    comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Add("0", "全部");
                    comQueryPanel1.ctrlForQueryPORDERSTATUS.SelectedIndex = 0;
                    break;
                case "@JkFinish":
                    comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Clear();
                    comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Add("2", "已下发");
                    comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Add("3", "生产中");
                    comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Add("4", "生产完成");
                    comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Add("5", "缴库完成");
                    comQueryPanel1.ctrlForQueryPORDERSTATUS.SelectedIndex = 0;
                    break;
                case "@PAYDOWN1":
                    comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Clear();
                    comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Add("4", "生产完成");
                    comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Add("5", "缴库完成");
                    comQueryPanel1.ctrlForQueryPORDERSTATUS.SelectedIndex = 0;
                    break;
                case "@PAYDOWN2":
                    comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Clear();
                    comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Add("4", "生产完成");
                    comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Add("5", "缴库完成");
                    comQueryPanel1.ctrlForQueryPORDERSTATUS.SelectedIndex = 0;
                    break;
                case "@PAYDOWN3":
                    comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Add("4", "生产完成");
                    comQueryPanel1.ctrlForQueryPORDERSTATUS.Items.Add("5", "缴库完成");
                    comQueryPanel1.ctrlForQueryPORDERSTATUS.SelectedIndex = 0;
                    break;
            }
        }

        /// <summary>
        /// 获取查询条件信息
        /// </summary>
        /// <returns>查询条件信息</returns>
        private ArrayList GetQueryCondition()
        {
            ArrayList ary = new ArrayList();
            string strRollmonth = "";
            string strAcceptNo = "";//接收批次号
            string strOrderNo = "";  //合同号
            string haveJg = "";     //是否有接箍
            string haveDj = "";     //是否有短节
            string isGpOrder = "";  //是否是管坯合同

            if (comQueryPanel1.checkBoxHvJg.Checked)
            {
                haveJg = "1";
            }

            if (comQueryPanel1.checkBoxHvDj.Checked)
            {
                haveDj = "1";
            }

            if (comQueryPanel1.checkBoxisGp.Checked)
            {
                isGpOrder = "1";
            }

            if (comQueryPanel1.checkBoxAcceptNo.Checked)
            {
                strAcceptNo = comQueryPanel1.ultraTextEditorAcceptNo.Text.Trim();
            }

            if (comQueryPanel1.checkBoxForReqORDER_NO.Checked)
            {
                strOrderNo = comQueryPanel1.ctrlForQueryORDER_NO.Text.Trim();
            }

            if (comQueryPanel1.checkBoxRollMonth.Checked)
            {
                strRollmonth = comQueryPanel1.ultraDateTimeRollMonth.DateTime.ToString("yyyy-MM");
            }

            ary.Add(strRollmonth);
            ary.Add(strAcceptNo);
            ary.Add(strOrderNo);
            ary.Add(haveJg);
            ary.Add(haveJg);
            ary.Add(haveDj);
            ary.Add(haveDj);
            ary.Add(isGpOrder);
            ary.Add(isGpOrder);
            return ary;
        }

        /// <summary>
        /// 查询
        /// </summary>
        private void DoQuery(ArrayList ary)
        {
            if (this.CustomInfo.ToString().Trim().Equals("@ScFinish"))
            {
                string strStatus = "";
                if (comQueryPanel1.checkBoxForReqPORDERSTATUS.Checked
                    && comQueryPanel1.ctrlForQueryPORDERSTATUS.SelectedIndex == 0)
                {
                    strStatus = "1";
                }
                this.slmPlnSaleordEntitybindingSource.DataSource = EntityHelper.GetData<PlnSaleOrderQueryEntity>(
                    "com.steering.pss.plnsaleord.order.CoreOrdFinishSet.querySaleOrderSc", new object[] { ary, strStatus }, this.ob);
               // ProducHelper.copyLZData(ultraGridSaleOrder,"S", this.ob);
            }
            else
            {
                string orderFrom = ""; //合同来源
                ary.Add(comQueryPanel1.ctrlForQueryPORDERSTATUS.Value.ToString());
                switch (this.CustomInfo.ToString().Trim())
                {
                    case "@PAYDOWN1":       //销售公司
                        orderFrom = "100101";
                        break;
                    case "@PAYDOWN2":       //国贸公司
                        orderFrom = "100102";
                        break;
                    case "@PAYDOWN3":       //钢贸公司
                        orderFrom = "100103";
                        break;
                }
                string orderSource = comQueryPanel1.checkBoxisBl.Checked ? "" : "备料需求"; //排产分类

                this.slmPlnSaleordEntitybindingSource.DataSource = EntityHelper.GetData<PlnSaleOrderQueryEntity>(
                    "com.steering.pss.plnsaleord.order.CoreOrdFinishSet.querySaleOrder", new object[] { ary, orderFrom, this.ValidDataPurviewIds, orderSource }, this.ob);
            }
            
        }

        /// <summary>
        /// 合同置为生产完成
        /// </summary>
        private void DoFinishSc(string falg)
        {
            try
            {
                int defailNum = 0;
                string messageErr = "";
                ultraGridSaleOrder.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkRows = ultraGridSaleOrder.Rows.AsQueryable().Where(" CHC = 'True' ");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选合同！");
                    return;
                }

             
                foreach (UltraGridRow uRow in checkRows)
                {
                    if ("生产完成".Equals(uRow.Cells["Planstatus"].Value.ToString()))
                    {
                        MessageUtil.ShowTips(uRow.Cells["OrderNoSeq"].Value.ToString() + "以生产完成");
                        return;
                    }
                    //查询合同状态
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CorePlnSaleOrder.querySaleStatus",
                        new object[] { uRow.Cells["OrdLnDlyPk"].Value.ToString() }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        defailNum++;
                        continue;
                    }
                    if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().CompareTo("1") > 0)
                    {
                        ArrayList param = new ArrayList();
                        param.Add("4");
                        param.Add(uRow.Cells["OrdLnDlyPk"].Value.ToString());
                        param.Add(uRow.Cells["OrdLnPk"].Value.ToString());
                        param.Add(uRow.Cells["OrderNoSeq"].Value.ToString());
                        param.Add(uRow.Cells["PlnDivideId"].Value.ToString());
                        //paramLine.Add("12020502");
                        //paramLine.Add(uRow.Cells["OrdLnDlyPk"].Value.ToString());
                        list.Add(param);
                    }
                    else
                    {
                        if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("4"))
                        {
                        messageErr = "交货行：" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                           + uRow.Cells["DeliveryNo"].Value.ToString() + "已经是" + dtStatus.Rows[0]["PORDERSTATUS1"].ToString() + "状态！";
                        }
                        else
                        {
                            messageErr = "交货行：" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                               + uRow.Cells["DeliveryNo"].Value.ToString() + "还未下发！";
                        }
                        defailNum++;
                        continue;
                    }
                }
                if (falg.Equals("1"))
                {
                    foreach (UltraGridRow ugr in ultraGrid1.Rows)
                    {
                        if (ugr.Cells["PROCESS_DESC"].Text.ToString().Equals("轧管"))
                        {
                            if (int.Parse(ugr.Cells["LJ_NUM"].Text.ToString()) - int.Parse(ugr.Cells["CK_NUM"].Text.ToString())!= 0)
                            {
                                MessageUtil.ShowTips("轧管排产计划有LJ支,未全部出库,请联系轧管相关人员删除炉计划！");
                                return;
                            }
                            if (!ugr.Cells["FURNA_NUM"].Text.ToString().Equals("0"))
                            {
                                MessageUtil.ShowTips("轧管排产计划已装炉,未全部出库,如需强制关闭,请联系轧管相关人员删除炉计划！");
                                return;
                            }
                        }
                    }
                }
                if (list.Count <= 0)
                {
                    MessageUtil.ShowTips("0条修改成功，" + defailNum + "条修改失败。\n" + messageErr);
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion(falg.Equals("0") ? "是否将这些合同置为生产完成?（共" + list.Count + "条）" : "是否强制将这些合同置为生产完成?（共" + list.Count + "条）") == DialogResult.No)
                {
                    return;
                }
                //if (MessageUtil.ShowQuestion("是否？").Equals(DialogResult.No))
                //{
                
                //    return;
                //}
                PlanComm.WaitFromOpen(this.Cursor);
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.pss.plnsaleord.order.CoreOrdFinishSet";
                ccp.MethodName = "setModifySale";
                ccp.ServerParams = new object[] { list, falg,this.UserInfo.GetUserName(),this.CustomInfo.ToString() };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                PlanComm.WaitFromColse(this.Cursor);
                if (ccp.ReturnCode != -1)
                {
                   
                    if (ccp.ReturnInfo.Equals("修改成功!"))
                    {
                        if (defailNum == 0)
                        {
                            MessageUtil.ShowTips("修改成功，共" + list.Count + "条。");
                        }
                        else
                        {
                            MessageUtil.ShowTips(list.Count + "条修改成功，" + defailNum + "条修改失败。\n" + messageErr);
                        }
                        DoQuery(GetQueryCondition());
                    }
                    else
                    {
                        MessageUtil.ShowTips(ccp.ReturnInfo);
                    }

                }
                else
                {
                    MessageUtil.ShowError("修改失败！\n" + ccp.ReturnInfo);
                }
            }
            catch (Exception ex)
            {
                PlanComm.WaitFromColse(this.Cursor);
                if (!(ex is MESException))
                {
                    MessageUtil.ShowError(ex.Message);
                }
            }
          
        }

        /// <summary>
        /// 合同置为缴库完成
        /// </summary>
        private void DoFinishJk()
        {
            try
            {
                int defailNum = 0;
                string messageErr = "";
                ultraGridSaleOrder.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkRows = ultraGridSaleOrder.Rows.AsQueryable().Where(" CHC = 'True' ");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选合同！");
                    return;
                }

                PlanComm.WaitFromOpen(this.Cursor);
                foreach (UltraGridRow uRow in checkRows)
                {
                    ///查询合同状态
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CorePlnSaleOrder.querySaleStatus",
                        new object[] { uRow.Cells["OrdLnDlyPk"].Value.ToString() }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        defailNum++;
                        continue;
                    }
                    if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("4") || dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("5")
                        || dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("2") || dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("3"))
                    {
                        ArrayList param = new ArrayList();
                        param.Add("5");
                        param.Add(uRow.Cells["OrdLnDlyPk"].Value.ToString());
                        param.Add(uRow.Cells["OrdLnPk"].Value.ToString());
                        param.Add(uRow.Cells["OrderNoSeq"].Value.ToString());
                        param.Add(uRow.Cells["PlnDivideId"].Value.ToString());
                        //paramLine.Add("12020602");
                        //paramLine.Add(uRow.Cells["OrdLnDlyPk"].Value.ToString());
                        list.Add(param);
                    }
                    else
                    {
                        messageErr = "只有已下发到生产完毕的合同才能置为缴库完毕！";
                        defailNum++;
                        continue;
                    }
                }

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

                if (MessageUtil.ShowQuestion("是否将这些合同置为缴库完成？（共" + list.Count + "条）").Equals(DialogResult.No))
                {
                    PlanComm.WaitFromColse(this.Cursor);
                    return;
                }

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.pss.plnsaleord.order.CoreOrdFinishSet";
                ccp.MethodName = "setModifySale";
                ccp.ServerParams = new object[] { list,"1",UserInfo.GetUserName() };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                PlanComm.WaitFromColse(this.Cursor);
                if (ccp.ReturnCode != -1)
                {
                    if (defailNum == 0)
                    {
                        MessageUtil.ShowTips("修改成功，共" + list.Count + "条。");
                    }
                    else
                    {
                        MessageUtil.ShowTips(list.Count + "条修改成功，" + defailNum + "条修改失败。\n" + messageErr);
                    }
                }
                else
                {
                    MessageUtil.ShowError("修改失败！" + ccp.ReturnInfo);
                }
            }
            catch (Exception ex)
            {
                PlanComm.WaitFromColse(this.Cursor);
                if (!(ex is MESException))
                {
                    MessageUtil.ShowError(ex.Message);
                }
            }
            DoQuery(GetQueryCondition());
        }

        /// <summary>
        /// 补量申请
        /// </summary>
        private void DoApplyFill()
        {
            UltraGridRow ugr = ultraGridSaleOrder.ActiveRow;
            if (ugr == null)
            {
                return;
            }

            if (ugr.Cells["OrderSeq"].Value.ToString().Length < 3)
            {
                MessageUtil.ShowTips("外部导入系统合同不允许补量！");
                return;
            }

            if (Double.Parse(ugr.Cells["PorderstatusTime"].Value.ToString()) > 7)
            {
                MessageUtil.ShowTips("生产完成7天内可以补量，超过7天就不能补量！");
                return;
            }

            ///查询合同状态
            DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CorePlnSaleOrder.querySaleStatus",
                new object[] { ugr.Cells["OrdLnDlyPk"].Value.ToString() }, this.ob);
            if (dtStatus == null || dtStatus.Rows.Count <= 0)
            {
                return;
            }
            if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("4"))
            {
                PlnSaleorderRNumEntity reqEntity = new PlnSaleorderRNumEntity();
                reqEntity.OrdLnDlyPk = ugr.Cells["OrdLnDlyPk"].Value.ToString();
                reqEntity.OrderNo = ugr.Cells["OrderNo"].Value.ToString();
                reqEntity.OrderSeq = ugr.Cells["OrderSeq"].Value.ToString();
                reqEntity.DeliveryNo = ugr.Cells["DeliveryNo"].Value.ToString();
                reqEntity.OrderUnit = dtStatus.Rows[0]["ORDER_UNIT"].ToString();
                FrmReqRequest reqRequest = new FrmReqRequest(this.ob, reqEntity,
                    Convert.ToDouble(dtStatus.Rows[0]["ORDER_QTY"]));
                reqRequest.ShowDialog();
            }
            else
            {
                MessageUtil.ShowTips("只有在生产完成的合同才允许补量！");
                return;
            }
        }

        /// <summary>
        /// 查看补量申请
        /// </summary>
        private void LookApplyFill()
        {
            UltraGridRow ugr = ultraGridSaleOrder.ActiveRow;
            if (ugr == null)
            {
                return;
            }

            if (ugr.Cells["OrderSeq"].Value.ToString().Length < 3)
            {
                MessageUtil.ShowTips("外部导入系统合同不允许补量！");
                return;
            }

            ///查询合同状态
            DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CorePlnSaleOrder.querySaleStatus",
                new object[] { ugr.Cells["OrdLnDlyPk"].Value.ToString() }, this.ob);
            if (dtStatus == null || dtStatus.Rows.Count <= 0)
            {
                return;
            }
            PlnSaleorderRNumEntity reqEntity = new PlnSaleorderRNumEntity();
            reqEntity.OrdLnDlyPk = ugr.Cells["OrdLnDlyPk"].Value.ToString();
            reqEntity.OrderNo = ugr.Cells["OrderNo"].Value.ToString();
            reqEntity.OrderSeq = ugr.Cells["OrderSeq"].Value.ToString();
            reqEntity.DeliveryNo = ugr.Cells["DeliveryNo"].Value.ToString();
            reqEntity.OrderUnit = dtStatus.Rows[0]["ORDER_UNIT"].ToString();
            FrmReqRequest reqRequest = new FrmReqRequest(this.ob, reqEntity,
                Convert.ToDouble(dtStatus.Rows[0]["ORDER_QTY"]));
            reqRequest.UltraToolbarsReq.Tools["doAdd"].SharedProps.Visible = false;
            reqRequest.UltraToolbarsReq.Tools["doModify"].SharedProps.Visible = false;
            reqRequest.ShowDialog();
        }

        private void ultraTabControl1_SelectedTabChanged(object sender,
            Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (toolMenu != null)
            {
                if (e.Tab.TabPage == ultraTabPageControlOrd)
                {
                    setTab1Appearance(DefaultableBoolean.True);
                    setTab2Appearance(DefaultableBoolean.False);
                }
                else if (e.Tab.TabPage == ultraTabPageControlExport)
                {
                    setTab1Appearance(DefaultableBoolean.False);
                    setTab2Appearance(DefaultableBoolean.True);
                }
            }
        }

        private void FrmOrdFinishSet_Shown(object sender, EventArgs e)
        {
            setTab1Appearance(DefaultableBoolean.True);
            setTab2Appearance(DefaultableBoolean.False);
        }

        private void setTab1Appearance(DefaultableBoolean appearance)
        {
            #region tab1显示或隐藏
            if (toolMenu.Toolbars[0].Tools.Exists("Query"))
            {
                toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("FinishJk"))
            {
                toolMenu.Toolbars[0].Tools["FinishJk"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("FinishSc"))
            {
                toolMenu.Toolbars[0].Tools["FinishSc"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("ExportProc"))
            {
                toolMenu.Toolbars[0].Tools["ExportProc"].InstanceProps.Visible = appearance;
            }
            #endregion
        }

        private void setTab2Appearance(DefaultableBoolean appearance)
        {
            #region tab1显示或隐藏
            if (toolMenu.Toolbars[0].Tools.Exists("QueryExp"))
            {
                toolMenu.Toolbars[0].Tools["QueryExp"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("Export"))
            {
                toolMenu.Toolbars[0].Tools["Export"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("Import"))
            {
                toolMenu.Toolbars[0].Tools["Import"].InstanceProps.Visible = appearance;
            }
            #endregion
        }

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

        private void ultraGridSaleOrder_AfterRowActivate(object sender, EventArgs e)
        {
           UltraGridRow row= ultraGridSaleOrder.ActiveRow;
           if (row == null)
           {
               return;
           }
           DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CoreOrdFinishSet.queryPlnExeStatus",
               new object[] { row.Cells["OrdLnDlyPk"].Value.ToString(), row.Cells["PlnDivideId"].Value.ToString() }, this.ob);
           GridHelper.CopyDataToDatatable(dt, dataTable1, true);

         
           //foreach (UltraGridRow ugr in ultraGrid1.Rows)
           //{
           //    if (ugr.Cells["PROCESS_DESC"].Text.ToString().Equals("轧管"))
           //    {
           //        DataTable dtlz = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryLZDataZg", new object[] { }, ob);
           //        if (dtlz.Rows.Count > 0)
           //        {
           //            DataRow[] drs = dtlz.Select("订单号 ='" + ugr.Cells["PRO_PLAN_ID"].Value.ToString() + "' AND 序号='" + ugr.Cells["GX_PLAN_NO"].Value.ToString() + "'");
           //            if (drs != null && drs.Length > 0)
           //            {
           //                if (!drs[0]["装炉支"].ToString().Equals(""))
           //                {
           //                    ugr.Cells["装炉支"].Value = drs[0]["装炉支"].ToString();
           //                    ugr.Cells["装炉吨"].Value = drs[0]["装炉吨"].ToString();
           //                }
           //                if (!drs[0]["LJ支"].ToString().Equals(""))
           //                {
           //                    ugr.Cells["LJ支"].Value = drs[0]["LJ支"].ToString();
           //                    ugr.Cells["LJ吨"].Value = drs[0]["LJ吨"].ToString();
           //                }
           //                if (!drs[0]["出库支"].ToString().Equals(""))
           //                {
           //                    ugr.Cells["出库支"].Value = drs[0]["出库支"].ToString();
           //                    ugr.Cells["出库吨"].Value = drs[0]["出库吨"].ToString();
           //                }
           //            }
           //        }
           //    }
           //}
        }
    }
}