MES_Client/TGMES/Core.StlMes.Client.PlnSaleOrd/FrmPlnModifyOrdDPine.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.Server;
using System.Collections;
using com.steering.pss.plnsaleord.order.model;
using Core.Mes.Client.Comm.Tool;
using Infragistics.Win;
using Infragistics.Win.UltraWinGrid;
using Core.Mes.Client.Comm;
using Infragistics.Win.UltraWinEditors;
using com.steering.pss.plnsaleord.ordAmCal.model;
using Core.StlMes.Client.PlnSaleOrd.BaseMethod;
using Core.StlMes.Client.PlnSaleOrd.PopupWindow;
using Core.Mes.Client.Comm.Format;

namespace Core.StlMes.Client.PlnSaleOrd
{
    public partial class FrmPlnModifyOrdDPine : FrmBase
    {
        public FrmPlnModifyOrdDPine()
        {
            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();
            }
        }

        /// <summary>
        /// 平台菜单
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            base.ToolBar_Click(sender, ToolbarKey);
            switch (ToolbarKey)
            {
                case "Query":  //查询
                    DoQuery(GetQueryCondition());
                    break;
                case "ModifyMonth"://轧制月份修改
                    DoModifyMonth();
                    break;
                case "ConfirmOutPl"://外购坯料修改
                    DoConfirmOutPl();
                    break;
                case "ModifyDPline"://修改轧管机组
                    DoModifyDPline();
                    break;
                case "Locked"://锁定
                    DoLocked();
                    break;
                case "LookBomDPline":
                    DoLookBomDPline();
                    break;
                case "CancelLocked"://解除锁定
                    DoCancelLocked();
                    break;
                case "MonthStatist"://统计报表
                    DoMonthStatist();
                    break;
                case "ConfirmPlan"://确认
                    DoConfirmPlan();
                    break;
                case "Export":
                    PlanComm.Export(ref ultraGridSaleOrderProc, "计划" + DateTime.Now.ToString("yyyyMMdd"));
                    break;
                case "RefresDate"://刷新加载数据
                    RefresDate();
                    DoQuery(GetQueryCondition());
                    break;
                case "Close":  //关闭
                    this.Close();
                    break;
            }
        }

        private void FrmPlnModifyOrdDPine_Load(object sender, EventArgs e)
        {
            comQueryPanelSource1.ctrlForQueryPORDERSTATUS.Items.Add("1", "已接收");
            comQueryPanelSource1.ctrlForQueryPORDERSTATUS.Items.Add("2", "已下发");
            comQueryPanelSource1.ctrlForQueryPORDERSTATUS.Items.Add("3", "生产中");
            comQueryPanelSource1.ctrlForQueryPORDERSTATUS.Items.Add("4", "生产完成");
            comQueryPanelSource1.ctrlForQueryPORDERSTATUS.Items.Add("5", "缴库完毕");
            comQueryPanelSource1.ctrlForQueryPORDERSTATUS.SelectedIndex = 0;
            if (DateTime.Now.Day >= 25)
            {
                DateTime date = DateTime.Now;
                date = date.AddDays(1 - date.Day);
                comQueryPanelSource1.ultraDateTimeRollMonth.Value = date.AddMonths(1);
            }
            else
            {
                DateTime date = DateTime.Now;
                date = date.AddDays(1 - date.Day);
                comQueryPanelSource1.ultraDateTimeRollMonth.Value = date;
            }
            comQueryPanelSource1.ultraDateTimeRollMonth.Value = DateTime.Now;
            comQueryPanelSource1.ultraTextEditorAcceptNo.Value = "X" + DateTime.Now.ToString("yyyyMMdd");
            comQueryPanelSource1.checkBoxAcceptNo.Checked = true;
            comQueryPanelSource1.checkBoxIsConfirm.Visible = true;
            comQueryPanelSource1.checkBoxIsConfirm.Checked = false;
            comQueryPanelSource1.checkBoxIsConfirm.Text = "未确认";
            Init();
            RefresDate();
            DoQuery(GetQueryCondition());
        }

        private void Init()
        {
            EntityHelper.ShowGridCaption<PlnSaleOrderQueryEntity>(ultraGridSaleOrderProc.DisplayLayout.Bands[0]);
            ultraGridSaleOrderProc.DisplayLayout.Bands[0].Columns["GroupRoll"].Style
                = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            ultraGridSaleOrderProc.DisplayLayout.Bands[0].Columns["OrderAddDesc"].EditorComponent = ultraFileLook;
            ultraGridSaleOrderProc.DisplayLayout.Bands[0].Columns["OrderAddDesc"].ButtonDisplayStyle
                = Infragistics.Win.UltraWinGrid.ButtonDisplayStyle.Always;
            PlanComm.setGridActivation(this.ultraGridSaleOrderProc.DisplayLayout.Bands[0],
                "CHC", "RollMonth", "OutsBilletFl", "GroupRoll");
            PlanComm.setGridDigitalCol(ultraGridSaleOrderProc.DisplayLayout.Bands[0], 7, 3,
                        "OrderQtyD", "PlanWtD", "FinishWt", "planWtBegin", "PlanPMain", "Lengthmax", "Lengthmin", "PlanPMainMin", "AimWtEnd", "WeightJg");
            PlanComm.setGridDigitalCol(ultraGridSaleOrderProc.DisplayLayout.Bands[0], 5, 2,
                "Outdiameter", "Wallthick", "TotLenOneP", "LenRollMin", "LenRollMax",
                "HeightNkMin", "HeightNkMax", "LenToendMin", "LenToendMax",
                "LengthJg", "DimaterYlg", "HeightYlg", "HeightOrdMax", "HeightOrdMin",
                "AimWallthick", "RollLength", "ShrtLenRato", "LongLenRato", "AimOutdiameter", "FeedRate", "Coefficient", "CoefficientMin", "CheckJVal");
            PlanComm.setGridDigitalCol(ultraGridSaleOrderProc.DisplayLayout.Bands[0], 5, 3,
                 "AimLenEnd", "AimLenRoll", "SiglLen", "EndlenSpecstd", "DifrncLenMax",
                 "AvgLenMin", "Longest", "Shortest", "ZOrderweight");
            PlanComm.setGridDigitalCol(ultraGridSaleOrderProc.DisplayLayout.Bands[0], 5, 0,
                 "PlanNumD", "planNumBegin", "CutNumP", "ZOrdernum");
            PlanComm.setGridDigitalCol(ultraGridSaleOrderProc.DisplayLayout.Bands[0], 3, 6,
                 "WeightPerM", "WeightKzM");
            PlanComm.setGridSummarySet(ultraGridSaleOrderProc, 0, "PlanNumD");
            PlanComm.setGridSummarySet(ultraGridSaleOrderProc, 3,
                "OrderQtyD", "PlanWtD", "FinishWt", "planWtBegin", "PlanPMain");
        }

        /// <summary>
        /// 刷新
        /// </summary>
        private void RefresDate()
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CorePlnModifyOrdDPine.queryBaseDPline",
                new object[] { }, this.ob);
            if (dt != null && dt.Rows.Count > 0)
            {
                ValueList vlistSteel = PlanComm.GeneralValuelist(ref dt, "PLINE_CODE", "PLINE_NAME");
                vlistSteel.ValueListItems.Insert(0, "", "");
                ultraGridSaleOrderProc.DisplayLayout.Bands[0].Columns["GroupRoll"].ValueList = vlistSteel;
            }

            #region BaseInfo 维护数据
            DataTable tableBaseInfo = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CorePlnSaleOrder.queryBaseinfoAll",
                new object[] { }, this.ob);
            if (tableBaseInfo != null)
            {
                //热处理组
                tableBaseInfo.DefaultView.RowFilter = "SORTCODE='2005'";
                DataTable dtGroupRCL = tableBaseInfo.DefaultView.ToTable();
                if (dtGroupRCL != null && dtGroupRCL.Rows.Count > 0)
                {
                    ultraGridSaleOrderProc.DisplayLayout.Bands[0].Columns["GroupRcl"].ValueList
                        = PlanComm.GeneralValuelist(ref dtGroupRCL, "BASECODE", "BASENAME");
                    ultraGridSaleOrderProc.DisplayLayout.Bands[0].Columns["GroupRcl"].Style =
                        Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                }

                //加工组
                tableBaseInfo.DefaultView.RowFilter = "SORTCODE='2004'";
                DataTable dtGroupJGX = tableBaseInfo.DefaultView.ToTable();
                if (dtGroupJGX != null && dtGroupJGX.Rows.Count > 0)
                {
                    ultraGridSaleOrderProc.DisplayLayout.Bands[0].Columns["GroupJgx"].ValueList
                        = PlanComm.GeneralValuelist(ref dtGroupJGX, "BASECODE", "BASENAME");
                    ultraGridSaleOrderProc.DisplayLayout.Bands[0].Columns["GroupJgx"].Style =
                        Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                }
                //外购坯
                tableBaseInfo.DefaultView.RowFilter = "SORTCODE='1218'";
                DataTable dtOutBillet = tableBaseInfo.DefaultView.ToTable();
                if (dtOutBillet != null && dtOutBillet.Rows.Count > 0)
                {
                    ValueList vlistSteel = PlanComm.GeneralValuelist(ref dtOutBillet, "BASECODE", "BASENAME");
                    vlistSteel.ValueListItems.Insert(0, "", "");
                    ultraGridSaleOrderProc.DisplayLayout.Bands[0].Columns["OutsBilletFl"].ValueList = vlistSteel;
                    ultraGridSaleOrderProc.DisplayLayout.Bands[0].Columns["OutsBilletFl"].Style =
                        Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                }

                //合同紧急度
                tableBaseInfo.DefaultView.RowFilter = "SORTCODE='2006'";
                DataTable dtPrior = tableBaseInfo.DefaultView.ToTable();
                if (dtPrior != null && dtPrior.Rows.Count > 0)
                {
                    ValueList vlistSteel = PlanComm.GeneralValuelist(ref dtPrior, "BASECODE", "BASENAME");
                    ultraGridSaleOrderProc.DisplayLayout.Bands[0].Columns["Priority"].ValueList = vlistSteel;
                    ultraGridSaleOrderProc.DisplayLayout.Bands[0].Columns["Priority"].Style =
                        Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                }
            }
            #endregion
        }

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

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

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

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

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

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

            if (comQueryPanelSource1.checkBoxForReqPORDERSTATUS.Checked)
            {
                strOrderStatus = comQueryPanelSource1.ctrlForQueryPORDERSTATUS.Value.ToString();
            }

            if (comQueryPanelSource1.checkBoxRollMonth.Checked)
            {
                strRollmonth = comQueryPanelSource1.ultraDateTimeRollMonth.DateTime.ToString("yyyy-MM");
            }
            if (comQueryPanelSource1.checkBoxOrdSource.Checked)
            {
                ordSource = comQueryPanelSource1.ultraComboOrdSource.Value.ToString();
            }

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

        /// <summary>
        /// 查询
        /// </summary>
        private void DoQuery(ArrayList ary)
        {
            bool isConfirm = comQueryPanelSource1.checkBoxIsConfirm.Checked;
            string strFinish = "";
            if (this.comQueryPanelSource1.checkBoxFinish.Checked)
            {
                strFinish = comQueryPanelSource1.ultraComboFinishEditor.Value.ToString();
            }
            slmSaleOrderEntitybindingSource.DataSource = EntityHelper.GetData<PlnSaleOrderQueryEntity>(
                "com.steering.pss.plnsaleord.order.CorePlnModifyOrdDPine.querySaleOrder",
                new object[] { ary, strFinish, isConfirm,this.CustomInfo.ToString2().Contains("120504")?"120504":"" }, this.ob);
        }

        /// <summary>
        /// 外购坯料修改
        /// </summary>
        private void DoConfirmOutPl()
        {
            try
            {
                int defailNum = 0;
                string messageErr = "";
                ultraGridSaleOrderProc.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkRows = ultraGridSaleOrderProc.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.CorePlnModifyOrdDPine.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("0") > 0)
                    {
                        ArrayList param = new ArrayList();
                        string outsBilletFl = dtStatus.Rows[0]["OUTS_BILLET_FL"].ToString();
                        string outsStlPipeFl = dtStatus.Rows[0]["OUTS_STL_PIPE_FL"].ToString();
                        
                        if ((outsStlPipeFl.Trim().Equals("121902")
                            || outsStlPipeFl.Trim().Equals("121903"))
                            && (uRow.Cells["OutsBilletFl"].Value.ToString().Trim().Equals("121801")
                            || uRow.Cells["OutsBilletFl"].Value.ToString().Trim().Equals("121802")))
                        {
                            defailNum++;
                            uRow.Cells["OutsBilletFl"].Value = "";
                            messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                                + uRow.Cells["DeliveryNo"].Value.ToString() + "是外购管(或原料管)！";
                            continue;
                        }

                        if (outsBilletFl.Trim().Equals("121802")
                            && uRow.Cells["OutsBilletFl"].Value.ToString().Trim().Equals("121801"))
                        {
                            defailNum++;
                            uRow.Cells["OutsBilletFl"].Value = "121802";
                            messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                                + uRow.Cells["DeliveryNo"].Value.ToString() + "坯料不能由自练改成外购！";
                            continue;
                        }
                        param.Add(uRow.Cells["OutsBilletFl"].Value.ToString());
                        param.Add(uRow.Cells["OrdLnDlyPk"].Value.ToString());
                        list.Add(param);
                    }
                    else
                    {
                        defailNum++;
                        //if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().CompareTo("1") > 0)
                        //{
                        //    messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                        //        + uRow.Cells["DeliveryNo"].Value.ToString() + "已下发，不能修改！";
                        //}
                        //else
                        //{
                        messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                            + uRow.Cells["DeliveryNo"].Value.ToString() + "未接收！";
                        //}
                        continue;
                    }
                }

                if (list.Count == 0)
                {
                    PlanComm.WaitFromColse(this.Cursor);
                    MessageUtil.ShowTips("0条坯料来源保存成功，" + defailNum + "条保存失败。\n" + messageErr);
                    return;
                }

                int succeed = ServerHelper.SetData("com.steering.pss.plnsaleord.order.CorePlnModifyOrdDPine.saveOutsBilletFl",
                    new object[] { list }, this.ob);
                PlanComm.WaitFromColse(this.Cursor);
                if (succeed > 0)
                {
                    if (defailNum == 0)
                    {
                        MessageUtil.ShowTips("坯料来源保存成功，共" + list.Count + "条。");
                    }
                    else
                    {
                        MessageUtil.ShowTips(list.Count + "条坯料来源保存成功，" + defailNum + "条保存失败。\n" + messageErr);
                    }
                }
            }
            catch (Exception ex)
            {
                PlanComm.WaitFromColse(this.Cursor);
                if (!(ex is MESException))
                {
                    MessageUtil.ShowError(ex.Message);
                }
            }
            DoQuery(GetQueryCondition());
        }

        /// <summary>
        /// 轧制月份调整
        /// </summary>
        private void DoModifyMonth()
        {
            try
            {
                int defailNum = 0;
                string messageErr = "";
                ultraGridSaleOrderProc.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkRows = ultraGridSaleOrderProc.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.CorePlnModifyOrdDPine.queryProcOrdStatus",
                        new object[] { uRow.Cells["OrdLnDlyPk"].Value.ToString(), uRow.Cells["PlnDivideId"].Value.ToString() }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        defailNum++;
                        continue;
                    }
                    if (dtStatus.Rows[0]["PLANSTATUS"].ToString().CompareTo("4") < 0)
                    {
                        DateTime date = new DateTime();
                        PlnSaleordProcEntity orderEntity = new PlnSaleordProcEntity();

                        if (!DateTime.TryParse(uRow.Cells["RollMonth"].Value.ToString(), out date))
                        {
                            messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                                + uRow.Cells["DeliveryNo"].Value.ToString() + "轧制月份有误！";
                            defailNum++;
                            continue;
                        }

                        if (date.Year < DateTime.Now.Year || (date.Year == DateTime.Now.Year && date.Month < DateTime.Now.Month))
                        {
                            messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                                + uRow.Cells["DeliveryNo"].Value.ToString() + "轧制月份不能小于当前月！";
                            defailNum++;
                            continue;
                        }

                        orderEntity.RollMonth = date.ToString("yyyy-MM");
                        orderEntity.OrdLnDlyPk = uRow.Cells["OrdLnDlyPk"].Value.ToString();
                        orderEntity.PlnDivideId = uRow.Cells["PlnDivideId"].Value.ToString();
                        list.Add(orderEntity);
                    }
                    else
                    {
                        //if (dtStatus.Rows[0]["PLANSTATUS"].ToString().CompareTo("1") > 0)
                        //{
                        //    messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                        //        + uRow.Cells["DeliveryNo"].Value.ToString() + "已下发，不能修改！";
                        //}
                        //else
                        //{
                            messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                                + uRow.Cells["DeliveryNo"].Value.ToString()
                                + uRow.Cells["PlnDivideId"].Value.ToString() + "已经生产完成了！";
                        //}
                        defailNum++;
                        continue;
                    }
                }

                if (list.Count <= 0)
                {
                    PlanComm.WaitFromColse(this.Cursor);
                    MessageUtil.ShowTips("0条轧制月份保存成功，" + defailNum + "条保存失败。\n" + messageErr);
                    return;
                }
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.pss.plnsaleord.order.CorePlnModifyOrdDPine";
                ccp.MethodName = "saveSaleOrderRollMonth";
                ccp.ServerParams = new object[] { list };
                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.ShowTips("保存失败，共" + list.Count + "条。");
                }
            }
            catch (Exception ex)
            {
                PlanComm.WaitFromColse(this.Cursor);
                if (!(ex is MESException))
                {
                    MessageUtil.ShowError(ex.Message);
                }
            }
            DoQuery(GetQueryCondition());
        }

        /// <summary>
        /// 轧管机组修改
        /// </summary>
        private void DoModifyDPline()
        {
            try
            {
                int defailNum = 0;
                string messageErr = "";
                ArrayList list = new ArrayList();
                ultraGridSaleOrderProc.UpdateData();
                IQueryable<UltraGridRow> checkRows = ultraGridSaleOrderProc.Rows.AsQueryable().Where(" CHC = 'True' ");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选合同！");
                    return;
                }

                PlanComm.WaitFromOpen(this.Cursor);
                foreach (UltraGridRow uRow in checkRows)
                {
                    PlnSaleordProcEntity orderPrcEntity = new PlnSaleordProcEntity();
                    string dPine = uRow.Cells["GroupRoll"].Value.ToString();
                    string outsStlPipeFl = "";
                    orderPrcEntity.OrdLnDlyPk = uRow.Cells["OrdLnDlyPk"].Value.ToString();
                    orderPrcEntity.PlnDivideId = uRow.Cells["PlnDivideId"].Value.ToString();
                    orderPrcEntity.DIsOk = "1";
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CorePlnModifyOrdDPine.queryProcOrdStatus",
                        new object[] { uRow.Cells["OrdLnDlyPk"].Value.ToString(), uRow.Cells["PlnDivideId"].Value.ToString() }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        defailNum++;
                        continue;
                    }
                    outsStlPipeFl = dtStatus.Rows[0]["OUTS_STL_PIPE_FL"].ToString();
                    if (!dtStatus.Rows[0]["PLANSTATUS"].ToString().Equals("1"))
                    {
                        messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                            + uRow.Cells["DeliveryNo"].Value.ToString() + "/"
                            + uRow.Cells["PlnDivideId"].Value.ToString() + "已下发，不能修改！";
                        defailNum++;
                        continue;
                    }
                    if (!dtStatus.Rows[0]["PROCESS_SEQ"].ToString().Contains('D'))
                    {
                        messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                            + uRow.Cells["DeliveryNo"].Value.ToString() + "/"
                            + uRow.Cells["PlnDivideId"].Value.ToString() + "不经过轧管工序！";
                        defailNum++;
                        continue;
                    }
                    if (dtStatus.Rows[0]["GROUP_ROLL"].ToString().Equals(dPine))
                    {
                        list.Add(orderPrcEntity);
                    }
                    else
                    {
                        ArrayList paramD = new ArrayList();
                        string bom = dtStatus.Rows[0]["BOM"].ToString();
                        OutOrdParamEntity outOrdParam = new OutOrdParamEntity();
                        InOrdParamEntity inOrdParam = new InOrdParamEntity();
                        PlnGetOrdAmount ordAmountCal = new PlnGetOrdAmount(this.ob);
                        DateTime date = new DateTime();
                        string errMessage = "";
                        double putRate = 1;
                        if (DateTime.TryParse(dtStatus.Rows[0]["ROLL_MONTH"].ToString(), out date))
                        {
                            //投料率
                            putRate = FrmPlnSaleOrder.queryPutRate(date.Year, date.Month, this.ob);
                        }
                        orderPrcEntity.GradecodeIsOk = dtStatus.Rows[0]["GRADECODE_IS_OK"].ToString();

                        paramD.Add(dtStatus.Rows[0]["D_IN_MATERIAL_NO"].ToString());
                        paramD.Add(dtStatus.Rows[0]["D_OUT_MATERIAL_NO"].ToString());
                        paramD.Add(dtStatus.Rows[0]["DESGIN_KEY"].ToString());
                        paramD.Add(dtStatus.Rows[0]["INDEX_SEQ"].ToString());
                        paramD.Add(uRow.Cells["FinalUser"].Value.ToString());
                        paramD.Add(uRow.Cells["Produccode"].Value.ToString());
                        DataTable dtD = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CoreOrderDesignBom.getBomMaterialDpl",
                            new object[] { paramD }, this.ob);
                        if (!PlanComm.isInDataTable(dtD, "PLINE_CODE", dPine))
                        {
                            #region 原来的BOM中不存在该产线，换BOM
                            ArrayList param = new ArrayList();
                            orderPrcEntity.GradecodeIsOk = "0";

                            //param.Add(dtStatus.Rows[0]["INDEX_SEQ"].ToString());
                            //param.Add(uRow.Cells["Msc"].Value.ToString());
                            //param.Add(uRow.Cells["MaterialNo"].Value.ToString());
                            //param.Add(dtStatus.Rows[0]["PROCESS_SEQ"].ToString());

                            //string outsBilletFl = "0";
                            //if (uRow.Cells["OutsBilletFl"].Value.ToString().Equals("121801"))
                            //{
                            //    outsBilletFl = "1";
                            //}
                            DataTable dtBom = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CoreOrderDesignBom.getOrdLineMscBom",
                                new object[] { dtStatus.Rows[0]["DESGIN_KEY"].ToString(), dtStatus.Rows[0]["MSC"].ToString(), dtStatus.Rows[0]["INDEX_SEQ"].ToString()}, this.ob);
                            if (dtBom != null && dtBom.Rows.Count > 0)
                            {
                                bool isAvailBom = false;//是否存在可用BOM
                                string errReason = "";//不可用原因
                                foreach (DataRow dr in dtBom.Rows)
                                {
                                    #region 判断坯料的属性
                                    string dinMaterial = "";
                                    ///轧管投入物料(炼钢末工序产出物料)
                                    if (!dr["D_IN_MATERIAL_NO"].ToString().Equals(""))
                                    {
                                        dinMaterial = dr["D_IN_MATERIAL_NO"].ToString();
                                    }
                                    else if (!dr["C_OUT_MATERIAL_NO"].ToString().Equals(""))
                                    {
                                        dinMaterial = dr["C_OUT_MATERIAL_NO"].ToString();
                                    }
                                    else if (!dr["B_OUT_MATERIAL_NO"].ToString().Equals(""))
                                    {
                                        dinMaterial = dr["B_OUT_MATERIAL_NO"].ToString();
                                    }
                                    else
                                    {
                                        dinMaterial = dr["A_OUT_MATERIAL_NO"].ToString();
                                    }
                                    orderPrcEntity.StuffProperty = PlnSaleOrderBase.stuffProperty(dinMaterial);
                                    #endregion

                                    // 轧管去向
                                    orderPrcEntity.Abc = PlnSaleOrderBase.getPlnOrdZgAbc(dr["WHOLE_BACKLOG"].ToString(), dr["WHOLE_BACKLOG_DESC"].ToString());

                                    orderPrcEntity.Bom = dr["BOM"].ToString();
                                    orderPrcEntity.GroupRollAll = dr["D_PLINE"].ToString();
                                    orderPrcEntity.Gradecode = dr["GRADECODE"].ToString();

                                    orderPrcEntity.EInMaterialDesc = dr["E_IN_MATERIAL_DESC"].ToString();
                                    orderPrcEntity.EInMaterialNo = dr["E_IN_MATERIAL_NO"].ToString();
                                    orderPrcEntity.DimaterYlg = dr["DIMATER"].ToString();
                                    orderPrcEntity.HeightYlg = dr["HEIGHT"].ToString();

                                    orderPrcEntity.GroupJgx = FrmDefGroup.DefJgxGourp(dtStatus.Rows[0]["DESGIN_KEY"].ToString(),
                                        dtStatus.Rows[0]["INDEX_SEQ"].ToString(), dr["BOM"].ToString(), this.ob);
                                    orderPrcEntity.GroupRcl = FrmDefGroup.DefRclGourp(dtStatus.Rows[0]["DESGIN_KEY"].ToString(),
                                        dtStatus.Rows[0]["INDEX_SEQ"].ToString(), dr["BOM"].ToString(), this.ob);

                                    if (dr["E_IN_MATERIAL_NO"].ToString().Equals(""))
                                    {
                                        orderPrcEntity.EIsOk = "2";
                                    }
                                    else if (!dr["E_IN_MATERIAL_NO"].ToString().Equals(
                                        dtStatus.Rows[0]["E_IN_MATERIAL_NO"].ToString()))
                                    {
                                        orderPrcEntity.EIsOk = "0";
                                    }
                                    else
                                    {
                                        orderPrcEntity.EIsOk = dtStatus.Rows[0]["E_IS_OK"].ToString();
                                    }

                                    #region 默认轧管产线
                                    ArrayList paramPline = new ArrayList();
                                    paramPline.Add(dr["D_IN_MATERIAL_NO"].ToString());
                                    paramPline.Add(dr["D_OUT_MATERIAL_NO"].ToString());
                                    paramPline.Add(dtStatus.Rows[0]["DESGIN_KEY"].ToString());
                                    paramPline.Add(dtStatus.Rows[0]["INDEX_SEQ"].ToString());
                                    paramPline.Add(uRow.Cells["FinalUser"].Value.ToString());
                                    paramPline.Add(uRow.Cells["Produccode"].Value.ToString());
                                    DataTable dtDpl = ServerHelper.GetData("com.steering.pss.plnsaleord.order"
                                        + ".CoreOrderDesignBom.getBomMaterialDpl",
                                        new object[] { paramPline }, this.ob);
                                    if (dtDpl != null && dtDpl.Rows.Count > 0)
                                    {
                                        if (!PlanComm.isInDataTable(dtDpl, "PLINE_CODE", dPine))
                                        {
                                            errReason = "可用轧管机组中不存在" + uRow.Cells["GroupRoll"].Text + "机组。";
                                            continue;
                                        }
                                        else if (!outsStlPipeFl.Equals("121903")
                                            && !outsStlPipeFl.Equals("121902")
                                            && !dPine.Trim().Equals("C072"))
                                        {
                                            bom = dr["BOM"].ToString();
                                            inOrdParam = ordAmountCal.getInOrdPlnParam(dtStatus.Rows[0]["DESGIN_KEY"].ToString(),
                                                dtStatus.Rows[0]["INDEX_SEQ"].ToString(), uRow.Cells["OrdLnDlyPk"].Value.ToString(),
                                                uRow.Cells["PlnDivideId"].Value.ToString(),
                                                dPine, bom, dtStatus.Rows[0]["CODE_JG"].ToString(), putRate);

                                            if (!ordAmountCal.isRightParam(inOrdParam, dtStatus.Rows[0]["DESGIN_KEY"].ToString(),
                                                dtStatus.Rows[0]["CODE_JG"].ToString(), bom, dPine, out errMessage))
                                            {
                                                errReason = errMessage;
                                                continue;
                                            }
                                            ordAmountCal.InEnity = inOrdParam;
                                            outOrdParam = ordAmountCal.getOrdAmount();
                                            if (outOrdParam.ErrCode == -1)
                                            {
                                                errReason = "合同量转换出错（" + outOrdParam.ErrMessage + "）。";
                                                continue;
                                            }
                                        }
                                        isAvailBom = true;
                                    }
                                    else 
                                    {
                                        errReason = "找不到可用轧管机组。";
                                        continue;
                                    }
                                    #endregion
                                }
                                if (!isAvailBom)
                                {
                                    messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString()
                                        + "/" + uRow.Cells["DeliveryNo"].Value.ToString() + "/"
                                        + uRow.Cells["PlnDivideId"].Value.ToString() + errReason;
                                    defailNum++;
                                    continue;
                                }
                            }
                            #endregion
                        }
                        if (!outsStlPipeFl.Equals("121903") 
                            && !outsStlPipeFl.Equals("121902")
                            && !dPine.Trim().Equals("C072"))
                        {
                            #region 重算合同量
                            inOrdParam = ordAmountCal.getInOrdPlnParam(dtStatus.Rows[0]["DESGIN_KEY"].ToString(),
                                dtStatus.Rows[0]["INDEX_SEQ"].ToString(), uRow.Cells["OrdLnDlyPk"].Value.ToString(),
                                uRow.Cells["PlnDivideId"].Value.ToString(),
                                dPine, bom, dtStatus.Rows[0]["CODE_JG"].ToString(), putRate);

                            if (!ordAmountCal.isRightParam(inOrdParam, dtStatus.Rows[0]["DESGIN_KEY"].ToString(),
                                dtStatus.Rows[0]["CODE_JG"].ToString(), bom, dPine, out errMessage))
                            {
                                messageErr = errMessage;
                                defailNum++;
                                continue;
                            }
                            ordAmountCal.InEnity = inOrdParam;
                            outOrdParam = ordAmountCal.getOrdAmount();
                            if (outOrdParam.ErrCode == -1)
                            {
                                messageErr = "合同量转换出错（" + outOrdParam.ErrMessage + "）。";
                                defailNum++;
                                continue;
                            }
                            orderPrcEntity.WeightPerM = outOrdParam.WeightMi.ToString();
                            orderPrcEntity.PlanWtD = outOrdParam.WeightInA.ToString();
                            orderPrcEntity.PlanNumD = outOrdParam.PlanNum.ToString();
                            orderPrcEntity.AimLenRoll = outOrdParam.AimlengthZg.ToString();
                            orderPrcEntity.AimLenEnd = outOrdParam.AimLength.ToString();
                            orderPrcEntity.PlanPMain = outOrdParam.WeightPc.ToString();
                            orderPrcEntity.PlanTotLenD = (outOrdParam.PlanNum * outOrdParam.AimLength).ToString();
                            orderPrcEntity.TotLenOneP = outOrdParam.TotLenOneP.ToString();
                            orderPrcEntity.CutNumP = outOrdParam.CutNumP.ToString();
                            orderPrcEntity.RollLength = outOrdParam.RollLength.ToString();
                            orderPrcEntity.AimWallthick = outOrdParam.AimWallthick.ToString();
                            orderPrcEntity.LenRollMax = outOrdParam.LenRollMax.ToString();
                            orderPrcEntity.LenRollMin = outOrdParam.LenRollMin.ToString();
                            orderPrcEntity.AimOutdiameter = outOrdParam.AimOutdiameter.ToString();
                            orderPrcEntity.FeedRate = putRate.ToString();
                            orderPrcEntity.Coefficient = outOrdParam.Coefficient.ToString();
                            orderPrcEntity.CoefficientMin = outOrdParam.CoefficientMin.ToString();
                            orderPrcEntity.PlanPMainMin = outOrdParam.PlanPMainMin.ToString();
                            orderPrcEntity.AimWtEnd = outOrdParam.AimWtEnd.ToString();
                            orderPrcEntity.WeightKzM = outOrdParam.WeightKzM.ToString();
                            #endregion
                        }
                        orderPrcEntity.GroupRoll = dPine;
                        list.Add(orderPrcEntity);
                    }
                }

                if (list.Count == 0)
                {
                    PlanComm.WaitFromColse(this.Cursor);
                    MessageUtil.ShowTips("0条保存成功，" + defailNum + "条保存失败。\n" + messageErr);
                    return;
                }
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.pss.plnsaleord.order.CorePlnModifyOrdDPine";
                ccp.MethodName = "updateConfirmDPline";
                ccp.ServerParams = new object[] { list };
                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.ShowTips("保存失败，共" + list.Count + "条。");
                }
            }
            catch (Exception ex)
            {
                PlanComm.WaitFromColse(this.Cursor);
                if (!(ex is MESException))
                {
                    MessageUtil.ShowError(ex.Message);
                }
            }
            DoQuery(GetQueryCondition());
        }

        /// <summary>
        /// 计划确认
        /// </summary>
        private void DoConfirmPlan()
        {
            try
            {
                int defailNum = 0;
                string messageErr = "";
                ultraGridSaleOrderProc.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkRows = ultraGridSaleOrderProc.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.CorePlnModifyOrdDPine.queryProcOrdStatus",
                        new object[] { uRow.Cells["OrdLnDlyPk"].Value.ToString(), uRow.Cells["PlnDivideId"].Value.ToString() }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        defailNum++;
                        continue;
                    }
                    if (dtStatus.Rows[0]["PLANSTATUS"].ToString().Equals("1"))
                    {
                        PlnSaleordProcEntity orderPrcEntity = new PlnSaleordProcEntity();
                        orderPrcEntity.PlnDivideId = uRow.Cells["PlnDivideId"].Value.ToString();
                        orderPrcEntity.OrdLnDlyPk = uRow.Cells["OrdLnDlyPk"].Value.ToString();
                        list.Add(orderPrcEntity);
                    }
                    else
                    {
                        if (dtStatus.Rows[0]["PLANSTATUS"].ToString().CompareTo("1") > 0)
                        {
                            messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                                + uRow.Cells["DeliveryNo"].Value.ToString() + "已下发，无需再确认！";
                        }
                        else
                        {
                            messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                            + uRow.Cells["DeliveryNo"].Value.ToString() + "未接收！";
                        }
                        defailNum++;
                        continue;
                    }
                }

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

                int succeed = ServerHelper.SetData("com.steering.pss.plnsaleord.order.CorePlnModifyOrdDPine.updatePlanConfirm",
                    new object[] { list }, this.ob);
                PlanComm.WaitFromColse(this.Cursor);
                if (succeed > 0)
                {
                    if (defailNum == 0)
                    {
                        MessageUtil.ShowTips("确认成功，共" + list.Count + "条。");
                    }
                    else
                    {
                        MessageUtil.ShowTips(list.Count + "条确认成功，" + defailNum + "条确认失败。\n" + messageErr);
                    }
                }
            }
            catch (Exception ex)
            {
                PlanComm.WaitFromColse(this.Cursor);
                if (!(ex is MESException))
                {
                    MessageUtil.ShowError(ex.Message);
                }
            }
            DoQuery(GetQueryCondition());
        }

        /// <summary>
        /// 合同行行锁定
        /// </summary>
        private void DoLocked()
        {
            try
            {
                int defailNum = 0;
                string messageErr = "";
                ultraGridSaleOrderProc.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkRows = ultraGridSaleOrderProc.Rows.AsQueryable().Where(" CHC = 'True' ");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选合同！");
                    return;
                }

                PlanComm.WaitFromOpen(this.Cursor);
                foreach (UltraGridRow uRow in checkRows)
                {
                    bool isLocked = true;
                    bool isIussed = false;
                    PlnSaleordEntity orderEntity = new PlnSaleordEntity();
                    DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CorePlnModifyOrdDPine.queryOrdLineStatus",
                        new object[] { uRow.Cells["OrdLnPk"].Value.ToString() }, this.ob);
                    if (dt == null || dt.Rows.Count <= 0)
                    {
                        defailNum++;
                        continue;
                    }

                    foreach (DataRow dr in dt.Rows)
                    {
                        if (dr["PORDERSTATUS"].ToString().CompareTo("3") > 0)
                        {
                            isIussed = true;
                            break;
                        }
                        if (!dr["IF_SALE_FREEZE"].ToString().Equals("1"))
                        {
                            isLocked = false;
                        }
                    }

                    if (isIussed)
                    {
                        defailNum++;
                        messageErr = "合同行：" + uRow.Cells["OrderNoSeq"].Value.ToString()
                            + "向下交货行中有已经生产完成的，不能锁定！";
                        continue;
                    }

                    if (isLocked)
                    {
                        defailNum++;
                        messageErr = "合同行：" + uRow.Cells["OrderNoSeq"].Value.ToString()
                            + "已经处于锁定状态了！";
                        continue;
                    }
                    ArrayList list1 = new ArrayList();
                    //orderEntity.IfSaleFreeze = "1";
                    //orderEntity.OrdLnPk = uRow.Cells["OrdLnPk"].Value.ToString();
                    list1.Add("1");
                    list1.Add(uRow.Cells["OrdLnPk"].Value.ToString());
                    list.Add(list1);        
                }

                if (list.Count <= 0)
                {
                    PlanComm.WaitFromColse(this.Cursor);
                    MessageUtil.ShowTips("锁定失败。\n" + messageErr);
                    return;
                }
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.pss.plnsaleord.order.CorePlnModifyOrdDPine";
                ccp.MethodName = "updateIfSaleFreeze";
                ccp.ServerParams = new object[] { list };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode != -1)
                {
                    if (ccp.ReturnObject != null)
                    {
                        MessageUtil.ShowTips(ccp.ReturnObject.ToString());
                    }
                }
                //int succeed = ServerHelper.SetData("com.steering.pss.plnsaleord.order.CorePlnModifyOrdDPine.updateIfSaleFreeze",
                //    new object[] { list }, this.ob);
                PlanComm.WaitFromColse(this.Cursor);
                //if (succeed > 0)
                //{
                    if (defailNum == 0)
                    {
                        MessageUtil.ShowTips("锁定成功。");
                    }
                    else
                    {
                        MessageUtil.ShowTips(list.Count + "条锁定成功，" + defailNum + "条锁定失败。\n" + messageErr);
                    }
                //}
            }
            catch (Exception ex)
            {
                PlanComm.WaitFromColse(this.Cursor);
                if (!(ex is MESException))
                {
                    MessageUtil.ShowError(ex.Message);
                }
            }
            DoQuery(GetQueryCondition());
        }

        /// <summary>
        /// 合同行解除锁定
        /// </summary>
        private void DoCancelLocked()
        {
            try
            {
                int defailNum = 0;
                string messageErr = "";
                ultraGridSaleOrderProc.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkRows = ultraGridSaleOrderProc.Rows.AsQueryable().Where(" CHC = 'True' ");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选合同！");
                    return;
                }

                PlanComm.WaitFromOpen(this.Cursor);
                foreach (UltraGridRow uRow in checkRows)
                {
                    bool isLocked = false;
                    bool isLockLine = false;
                    //查询合同状态
                    DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CorePlnModifyOrdDPine.queryOrdLineStatus",
                        new object[] { uRow.Cells["OrdLnPk"].Value.ToString() }, this.ob);
                    if (dt == null || dt.Rows.Count <= 0)
                    {
                        defailNum++;
                        continue;
                    }

                    foreach (DataRow dr in dt.Rows)
                    {
                        if (dr["ISLOCK"].ToString().Equals("1"))
                        {
                            isLockLine = true;
                            break;
                        }
                        if (dr["IF_SALE_FREEZE"].ToString().Equals("1"))
                        {
                            isLocked = true;
                        }
                    }
                    if (isLockLine)
                    {
                        defailNum++;
                        messageErr = "销售合同行：" + uRow.Cells["OrderNoSeq"].Value.ToString()
                            + "锁定中！";
                        defailNum++;
                        continue;
                    }
                    if (!isLocked)
                    {
                        defailNum++;
                        messageErr = "合同行：" + uRow.Cells["OrderNoSeq"].Value.ToString()
                            + "已经处于解锁状态了！";
                        continue;
                    }
                    //PlnSaleordEntity orderEntity = new PlnSaleordEntity();
                    //orderEntity.IfSaleFreeze = "0";
                    //orderEntity.OrdLnPk = uRow.Cells["OrdLnPk"].Value.ToString();
                    //list.Add(JSONFormat.Format(orderEntity));
                    ArrayList list1 = new ArrayList();
                    list1.Add("0");
                    list1.Add(uRow.Cells["OrdLnPk"].Value.ToString());
                    list.Add(list1);     
                }

                if (list.Count <= 0)
                {
                    PlanComm.WaitFromColse(this.Cursor);
                    MessageUtil.ShowTips("解锁失败。\n" + messageErr);
                    return;
                }
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.pss.plnsaleord.order.CorePlnModifyOrdDPine";
                ccp.MethodName = "updateIfSaleFreeze";
                ccp.ServerParams = new object[] { list };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode != -1)
                {
                    if (ccp.ReturnObject != null)
                    {
                        MessageUtil.ShowTips(ccp.ReturnObject.ToString());
                    }
                }

                //int succeed = ServerHelper.SetData("com.steering.pss.plnsaleord.order.CorePlnModifyOrdDPine.updateIfSaleFreeze",
                //    new object[] { list }, this.ob);
                PlanComm.WaitFromColse(this.Cursor);
                //if (succeed > 0)
                //{
                    if (defailNum == 0)
                    {
                        MessageUtil.ShowTips("解锁成功。");
                    }
                    else
                    {
                        MessageUtil.ShowTips(list.Count + "条解锁成功，" + defailNum + "条解锁失败。\n" + messageErr);
                    }
                //}
            }
            catch (Exception ex)
            {
                PlanComm.WaitFromColse(this.Cursor);
                if (!(ex is MESException))
                {
                    MessageUtil.ShowError(ex.Message);
                }
            }
            DoQuery(GetQueryCondition());
        }

        /// <summary>
        /// 排产月统计查询
        /// </summary>
        private void DoMonthStatist()
        {
            FrmReqRollMonth outPut = new FrmReqRollMonth();
            outPut.Show();
        }

        /// <summary>
        /// 查询物料产线
        /// </summary>
        private void DoLookBomDPline()
        {
            UltraGridRow ugr = ultraGridSaleOrderProc.ActiveRow;
            if (ugr == null)
            {
                return;
            }
            DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CoreSaleOrderReceive.querySaleProcStatus",
                        new object[] { ugr.Cells["OrdLnDlyPk"].Value.ToString(), ugr.Cells["PlnDivideId"].Value.ToString() }, this.ob);
            if (dtStatus != null && dtStatus.Rows.Count > 0)
            {
                if (dtStatus.Rows[0]["PLANSTATUS"].ToString().CompareTo("1") > 0)
                {
                    MessageUtil.ShowTips("合同：" + ugr.Cells["OrderNoSeq"].Value.ToString() + "/"
                        + ugr.Cells["DeliveryNo"].Value.ToString() + "已经下发。");
                    return;
                }
                FrmChangeBomDp changeBomDp = new FrmChangeBomDp(ugr.Cells["OrdLnDlyPk"].Value.ToString(),
                    ugr.Cells["PlnDivideId"].Value.ToString(), this.ob);

                switch (this.CustomInfo.ToString().Trim())
                {
                    case "@Dbk":
                    case "@Dbk-120504":
                        changeBomDp.Custom = "Dbk";
                        break;
                    case "@Zg":
                    case "@Zg-120504":
                        changeBomDp.Custom = "Zg";
                        break;
                    case "@Grade":
                    case "@Grade-120504":
                        changeBomDp.Custom = "Grade";
                        break;
                }
                changeBomDp.ShowDialog();
                DoQueryID(ugr.Cells["OrdLnDlyPk"].Value.ToString());
                this.ultraGridSaleOrderProc.ActiveRow = ugr;
            }
        }

        /// <summary>
        /// 刷新单条数据
        /// </summary>
        /// <param name="ordLnDlyPk"></param>
        private void DoQueryID(string ordLnDlyPk)
        {
            bool isConfirm = comQueryPanelSource1.checkBoxIsConfirm.Checked;
            string strFinish = "";
            if (this.comQueryPanelSource1.checkBoxFinish.Checked)
            {
                strFinish = comQueryPanelSource1.ultraComboFinishEditor.Value.ToString();
            }
            List<PlnSaleOrderQueryEntity> listSource = EntityHelper.GetData<PlnSaleOrderQueryEntity>(
                "com.steering.pss.plnsaleord.order.CorePlnModifyOrdDPine.querySaleOrder",
                new object[] { ordLnDlyPk, GetQueryCondition(), strFinish, isConfirm }, this.ob);
            List<PlnSaleOrderQueryEntity> listSource2 = (List<PlnSaleOrderQueryEntity>)slmSaleOrderEntitybindingSource.DataSource;
            PlnSaleOrderQueryEntity[] querayable = listSource2.AsQueryable().Where(a => a.OrdLnDlyPk == ordLnDlyPk).ToArray();
            if (querayable.Length > 0)
            {
                int number = listSource2.IndexOf(querayable[0]);
                for (int i = 0; i < querayable.Length; i++)
                {
                    listSource2.Remove(querayable[i]);
                }
                foreach (PlnSaleOrderQueryEntity source in listSource)
                {
                    slmSaleOrderEntitybindingSource.Insert(number, source);
                }
            }
            this.ultraGridSaleOrderProc.Refresh();
        }

        /// <summary>
        /// 查看附加要求贴图
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraFileLook_EditorButtonClick(object sender, 
            Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            try
            {
                UltraGridRow ugr = ultraGridSaleOrderProc.ActiveRow;
                if (ugr == null)
                {
                    return;
                }
                string askNo = ugr.Cells["AddAskNo"].Value.ToString();
                ArrayList listPIC = new ArrayList();
                DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CorePlnSaleOrder.queryAddAsk",
                    new object[] { askNo }, this.ob);
                if (dt != null && dt.Rows.Count > 0)
                {
                    foreach (DataRow dr in dt.Rows)
                    {
                        listPIC.Add(dr["PIC"].ToString());
                    }
                }
                dlgOrderAskLook orderAsk = new dlgOrderAskLook(this.ob, listPIC);
                orderAsk.Show();
            }
            catch (Exception ex)
            {
                if (!(ex is MESException))
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }

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

        private void ultraGridSaleOrderProc_KeyUp(object sender, KeyEventArgs e)
        {
            PlanComm.setGridCopyActColumn(this.ultraGridSaleOrderProc, "CHC", e,
                "OutsBilletFl", "RollMonth");
        }

        private void ultraGridSaleOrderProc_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow ugr = ultraGridSaleOrderProc.ActiveRow;
            if (ugr == null)
            {
                return;
            }

            ArrayList param = new ArrayList();
            DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CorePlnModifyOrdDPine.queryProcOrdStatus",
                new object[] { ugr.Cells["OrdLnDlyPk"].Value.ToString(), ugr.Cells["PlnDivideId"].Value.ToString() }, this.ob);
            if (dtStatus == null || dtStatus.Rows.Count <= 0)
            {
                return;
            }
            //param.Add(dtStatus.Rows[0]["DESGIN_KEY"].ToString());
            //param.Add(dtStatus.Rows[0]["INDEX_SEQ"].ToString());
            //param.Add(ugr.Cells["FinalUser"].Value.ToString());
            //param.Add(ugr.Cells["Produccode"].Value.ToString());
            //param.Add(dtStatus.Rows[0]["INDEX_SEQ"].ToString());
            //param.Add(ugr.Cells["Msc"].Value.ToString());
            //param.Add(ugr.Cells["MaterialNo"].Value.ToString());
            //param.Add(dtStatus.Rows[0]["PROCESS_SEQ"].ToString());
            //DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CorePlnModifyOrdDPine.queryProcOrdDPline",
            //    new object[] { param }, this.ob);
            string desginKey = dtStatus.Rows[0]["DESGIN_KEY"].ToString();
            string mscPline = dtStatus.Rows[0]["INDEX_SEQ"].ToString();
            string finalUser = ugr.Cells["FinalUser"].Value.ToString();
            string produccode = ugr.Cells["Produccode"].Value.ToString();
            DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CorePlnModifyOrdDPine.queryProcOrdDPline",
                new object[] { desginKey, mscPline, finalUser, produccode }, this.ob);
            if (dt != null && dt.Rows.Count > 0)
            {
                ValueList vlistSteel = PlanComm.GeneralValuelist(ref dt, "PLINE_CODE", "PLINE_NAME");
                //vlistSteel.ValueListItems.Insert(0, "", "");
                ugr.Cells["GroupRoll"].ValueList = vlistSteel;
            }
        }
    }
}