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

namespace Core.StlMes.Client.PlnSaleOrd
{
    public partial class FrmConfirmCraft : FrmBase
    {
        public FrmConfirmCraft()
        {
         
            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 "ConfirmCraft":// 替换工艺
                    DoConfirmCraft();
                    break;
                case "RefresCraft":// 刷新工艺
                    DoRefresCraft();
                    break;
                case "Iussed"://下发
                    DoIussed();
                    break;
                case "ConcelIussed":// 取消下发
                    DoConcelIussed();
                    break;
                case "LookCraftFile"://查看工艺文件
                    if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[0])
                    {
                        DoLookCraftFile();
                    }
                    else
                    {
                        comOrdExportCtrl1.DoLookCraftFile(this.ob);
                    }
                    break;
                case "TechOrderLine":  //
                    if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[0])
                    {
                        TechOrderLine();
                    }
                    else
                    {
                        comOrdExportCtrl1.TechOrderLine();
                    }
                    break;
                case "ExportProc":
                    PlanComm.Export(ref ultraGridSaleOrderProc, "计划" + DateTime.Now.ToString("yyyyMMdd"));
                    break;
                case "QueryExp"://查询下发合同信息
                    comOrdExportCtrl1.DoQueryExp();
                    break;
                case "Export":  //导出
                    comOrdExportCtrl1.DoExport();
                    break;
                case "GridExport":  //按Grid导出
                    comOrdExportCtrl1.DoGridExport();
                    break;
                case "RefresDate"://刷新加载数据
                    RefresDate();
                    DoQuery(GetQueryCondition());
                    break;
                case "ModifyBaseMlPl":
                    DoModifyBaseMlPl();
                    break;
                case "UpdateMonth"://修改排产月份
                    UpdateMonth();
                    break;
                case "BreakUp"://拆分
                    doBreakUp();
                    break;
                case "Merge"://合并
                    doMerge();
                    break;
                case "Close":  //关闭
                    this.Close();
                    break;
            }
        }

        private void FrmConfirmCraft_Load(object sender, EventArgs e)
        {
            comOrdExportCtrl1.ComBLL(this.ob);
            comOrdExportCtrl1.UltraTextAcceptNo.Value = "X" + DateTime.Now.ToString("yyyyMM");
            comOrdExportCtrl1.CheckBoxAcceptNoexport.Checked = true;
            comOrdExportCtrl1.UltraDateTimeDELVRY_EDATEFrom.DateTime = DateTime.Now.AddMonths(-1);
            comOrdExportCtrl1.UltraDateTimeDELVRY_EDATETo.DateTime = DateTime.Now;

            comQueryPanelSource1.checkBoxIsConfirm.Visible = true;
            comQueryPanelSource1.checkBoxIsConfirm.Checked = false;
            comQueryPanelSource1.checkBoxIsConfirm.Text = "待变更工艺";
            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;
            comQueryPanelSource1.ultraTextEditorAcceptNo.Value = "X" + DateTime.Now.ToString("yyyyMMdd");
            Init();
            this.IsLoadUserView = true;
        }
        
        /// <summary>
        /// 刷新
        /// </summary>
        private void RefresDate()
        {
        }

        private void Init()
        {
            comOrdExportCtrl1.ultraGridExport.DisplayLayout.Bands[0].Columns["MONITORDEMAND"].EditorComponent
                = comOrdExportCtrl1.ultraFileLook;
            comOrdExportCtrl1.ultraGridExport.DisplayLayout.Bands[0].Columns["MONITORDEMAND"].ButtonDisplayStyle
                = Infragistics.Win.UltraWinGrid.ButtonDisplayStyle.Always;
            PlanComm.setGridDigitalCol(comOrdExportCtrl1.ultraGridExport.DisplayLayout.Bands[0],
                5, 2, "RANGE_MIN", "RANGE_MAX", "OUTDIAMETER", "WALLTHICK");
            EntityHelper.ShowGridCaption<PlnSaleOrderQueryEntity>(ultraGridSaleOrderProc.DisplayLayout.Bands[0]);
            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");
            PlanComm.setGridDigitalCol(ultraGridSaleOrderProc.DisplayLayout.Bands[0], 5, 3,
                        "OrderQtyD", "PlanWtD", "FinishWt", "planWtBegin", "PlanPMain", "Lengthmax", "Lengthmin", "PlanPMainMin", "AimWtEnd", "WeightJg");
            PlanComm.setGridDigitalCol(ultraGridSaleOrderProc.DisplayLayout.Bands[0], 5, 2,
                "Outdiameter", "Wallthick", "TotLenOneP", "HeightNkMin", "HeightNkMax",
                "LenToendMin", "LenToendMax", "LengthJg", "DimaterYlg", "HeightYlg", "LenRollMin", "LenRollMax",
                "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", "PlanPMainMin");
        }

        /// <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.CoreConfirmCraft.querySaleOrder",
                new object[] { ary, strFinish, isConfirm,this.CustomInfo.ToString2() }, this.ob);

            foreach (UltraGridRow uRow in this.ultraGridSaleOrderProc.Rows)
            {
                if (uRow.Cells["CraftRenewSt"].Value.ToString().Trim().Equals("待替换"))
                {
                    uRow.Appearance.BackColor = Color.FromArgb(255, 220, 190);
                }
            }
        }

        /// <summary>
        /// 确认替换新工艺
        /// </summary>
        private void DoConfirmCraft()
        {
            try
            {
                int defailNum = 0;
                string messageErr = "";
                ultraGridSaleOrderProc.UpdateData();
                ArrayList list = new ArrayList(); 
                ArrayList listLog = new ArrayList();
                IQueryable<UltraGridRow> checkRows = this.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.CoreConfirmCraft.querySaleProcStatus",
                        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)
                    {
                        double outdiameter = 0;///外径
                        double wallthick = 0;    //壁厚
                        double.TryParse(uRow.Cells["Wallthick"].Value.ToString(), out wallthick);
                        string outsStlPipeFl = dtStatus.Rows[0]["OUTS_STL_PIPE_FL"].ToString();
                        if (!double.TryParse(uRow.Cells["Outdiameter"].Value.ToString(), out outdiameter))
                        {
                            if (messageErr.Equals(""))
                            {
                                messageErr = "交货行：" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                                    + uRow.Cells["DeliveryNo"].Value.ToString() + "外径有误，请核对合同信息！";
                            }
                            defailNum++;
                            continue;
                        }
                        PlnSaleordProcEntity ordProcEntity = new PlnSaleordProcEntity();
                        PlnSaleordCrfEditLogEntity crfEditLog = new PlnSaleordCrfEditLogEntity();
                        ordProcEntity.OrdLnDlyPk = uRow.Cells["OrdLnDlyPk"].Value.ToString();
                        ordProcEntity.PlnDivideId = uRow.Cells["PlnDivideId"].Value.ToString();
                        ordProcEntity.CraftSeq = dtStatus.Rows[0]["CRAFT_SEQ_NEW"].ToString();
                        if (dtStatus.Rows[0]["CRAFT_SEQ"].ToString().Equals(
                            dtStatus.Rows[0]["CRAFT_SEQ_NEW"].ToString()))
                        {
                            messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                                + uRow.Cells["DeliveryNo"].Value.ToString() + "没有新的工艺！";
                            defailNum++;
                            continue;
                        }

                        DataTable dtCraft = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CoreConfirmCraft.queryCraftDesign",
                                new object[] { uRow.Cells["OrdLnPk"].Value.ToString(), 
                                    dtStatus.Rows[0]["CRAFT_SEQ_NEW"].ToString() }, this.ob);
                        if (dtCraft == null || dtCraft.Rows.Count <= 0)
                        {
                            messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                                + uRow.Cells["DeliveryNo"].Value.ToString() + "没有找到新工艺的信息！";
                            defailNum++;
                            continue;
                        }

                        string desginKey = dtCraft.Rows[0]["DESGIN_KEY"].ToString();//新的质量设计
                        if (desginKey.Equals(""))
                        {
                            messageErr = "合同行：" + uRow.Cells["OrderNoSeq"].Value.ToString() 
                                + "新的工艺没有经过工艺制定！";
                            defailNum++;
                            continue;
                        }

                        string mscPline = dtStatus.Rows[0]["INDEX_SEQ"].ToString();//旧的制程
                        string bom = dtStatus.Rows[0]["BOM"].ToString();//旧的BOM
                        string dPline = dtStatus.Rows[0]["GROUP_ROLL"].ToString();//旧的产线
                        ordProcEntity.DIsOk = dtStatus.Rows[0]["D_IS_OK"].ToString();
                        ordProcEntity.EIsOk = dtStatus.Rows[0]["E_IS_OK"].ToString();
                        ordProcEntity.GradecodeIsOk = dtStatus.Rows[0]["GRADECODE_IS_OK"].ToString();

                        crfEditLog.CraftSeqNew = dtStatus.Rows[0]["CRAFT_SEQ_NEW"].ToString();
                        crfEditLog.CraftSeqOld = dtStatus.Rows[0]["CRAFT_SEQ"].ToString();
                        crfEditLog.CreateName = UserInfo.GetUserName();
                        crfEditLog.OrdLnDlyPk = uRow.Cells["OrdLnDlyPk"].Value.ToString();
                        crfEditLog.PlnDivideId = uRow.Cells["PlnDivideId"].Value.ToString();
                        listLog.Add(crfEditLog);

                        if (dtStatus.Rows[0]["DESGIN_KEY"].ToString().Equals(desginKey)
                            || !dtStatus.Rows[0]["PLANSTATUS"].ToString().Equals("1"))
                        {
                            list.Add(ordProcEntity);
                        }
                        else
                        {
                            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);
                            }

                            #region 新的质量设计下的制程
                            DataTable dtDegnPl = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CorePlnSaleOrder.queryDesginPl",
                                new object[] { desginKey }, this.ob);
                            if (dtDegnPl != null && dtDegnPl.Rows.Count > 0)
                            {
                                if (!PlanComm.isInDataTable(dtDegnPl, "MSC_PLINE", mscPline))
                                {
                                    //新的制程号
                                    mscPline = dtDegnPl.Rows[0]["MSC_PLINE"].ToString();
                                    ordProcEntity.IndexSeq = dtDegnPl.Rows[0]["MSC_PLINE"].ToString();
                                    ordProcEntity.ProcessSeq = dtDegnPl.Rows[0]["WHOLE_BACKLOG"].ToString();
                                    ordProcEntity.GradecodeAll = dtDegnPl.Rows[0]["GRADENAME"].ToString();
                                }
                                else
                                {
                                    //沿用旧的制程号
                                    dtDegnPl.DefaultView.RowFilter = "MSC_PLINE='" + mscPline + "'";
                                    DataTable dt = dtDegnPl.DefaultView.ToTable();
                                    if (dt != null && dt.Rows.Count > 0)
                                    {
                                        mscPline = dt.Rows[0]["MSC_PLINE"].ToString();
                                        ordProcEntity.IndexSeq = dt.Rows[0]["MSC_PLINE"].ToString();
                                        ordProcEntity.ProcessSeq = dt.Rows[0]["WHOLE_BACKLOG"].ToString();
                                        ordProcEntity.GradecodeAll = dt.Rows[0]["GRADENAME"].ToString();
                                    }
                                }
                            }
                            else
                            {
                                messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString()
                                    + "/" + uRow.Cells["DeliveryNo"].Value.ToString()
                                    + "未找到工艺向下的制程。";
                                defailNum++;
                                continue;
                            }
                            #endregion

                            #region 根据制程查询全程途经工序
                            ArrayList param = new ArrayList();
                            param.Add(desginKey);
                            param.Add(mscPline);
                            DataTable dtProcess = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CorePlnSaleOrder.queryMscplPrc",
                                new object[] { param }, this.ob);
                            if (dtProcess != null && dtProcess.Rows.Count > 0)
                            {
                                string endgxCode = ordProcEntity.ProcessSeq.Substring(ordProcEntity.ProcessSeq.Length - 1);
                                string gprocessC = "";      //加工二级工序
                                string fprocessC = "";      //热处理二级工序
                                ordProcEntity.GroupJgx = "/";
                                ordProcEntity.GroupRcl = "/";
                                ordProcEntity.BjType = "/";

                                foreach (DataRow dr in dtProcess.Rows)
                                {
                                    if (dr["PROCESS_CODE"].ToString().Trim().Equals("H"))
                                    {
                                        ordProcEntity.GroupJgx = "200401";
                                    }
                                    if (dr["PROCESS_CODE"].ToString().Trim().Equals("G"))
                                    {
                                        //经过加工工序
                                        gprocessC = dr["PROCESS_CODE_C"].ToString();

                                        //加工组
                                        //string modelCode = uRow.Cells["ModelCode"].Value.ToString();
                                        //string[] planGroups = FrmDefGroup.planGroups(desginKey,
                                        //    mscPline, "G", this.ob);
                                        //if (planGroups != null)
                                        //{
                                        //    ordProcEntity.GroupJgx = FrmDefGroup.defgourpJgc(planGroups, outdiameter, modelCode, this.ob);
                                        //}
                                        //else
                                        //{
                                        //    ordProcEntity.GroupJgx = FrmDefGroup.defgourpJgc(outdiameter, modelCode, this.ob);
                                        //}
                                    }
                                    if (dr["PROCESS_CODE"].ToString().Trim().Equals("F"))
                                    {
                                        //经过热处理工序
                                        fprocessC = dr["PROCESS_CODE_C"].ToString();
                                        ordProcEntity.ProcDescCRcl = dr["PROCESS_DESC_C"].ToString();
                                        //热处理组
                                        //double lengthmax = Convert.ToDouble(uRow.Cells["Lengthmax"].Value);
                                        //string modelCode = uRow.Cells["ModelCode"].Value.ToString();
                                        //string[] planGroups = FrmDefGroup.planGroups(desginKey,
                                        //    mscPline, "F", this.ob);
                                        //if (planGroups != null)
                                        //{
                                        //    ordProcEntity.GroupRcl = FrmDefGroup.defgourpRcl(planGroups, outdiameter, wallthick,
                                        //        lengthmax, dr["PROCESS_CODE_C"].ToString(), modelCode, this.ob);
                                        //}
                                        //else
                                        //{
                                        //    ordProcEntity.GroupRcl = FrmDefGroup.defgourpRcl(outdiameter, wallthick,
                                        //        lengthmax, dr["PROCESS_CODE_C"].ToString(), modelCode, this.ob);
                                        //}
                                    }
                                    if (dr["PROCESS_CODE"].ToString().Trim().Equals("E"))
                                    {
                                        //经过镦拔扩工序
                                        ordProcEntity.BjType = dr["PROCESS_DESC_C"].ToString();
                                    }
                                }
                            }
                            else
                            {
                                if (messageErr.Equals(""))
                                {
                                    messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString()
                                    + "/" + uRow.Cells["DeliveryNo"].Value.ToString()
                                    + "未找到制程途径工序，请联系管理员。";
                                }
                                defailNum++;
                                continue;
                            }
                            #endregion

                            #region BOM物料数据
                            //查询物料信息
                            //param.Clear();
                            //param.Add(mscPline);
                            //param.Add(uRow.Cells["Msc"].Value.ToString());
                            //param.Add(uRow.Cells["MaterialNo"].Value.ToString());
                            //param.Add(ordProcEntity.ProcessSeq);
                            DataTable dtBom = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CoreOrderDesignBom.getOrdLineMscBom",
                                new object[] { desginKey, uRow.Cells["Msc"].Value.ToString(), mscPline }, this.ob);
                            if (dtBom != null && dtBom.Rows.Count > 0)
                            {
                                if (!PlanComm.isInDataTable(dtBom, "BOM", bom))
                                {
                                    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();
                                        }
                                        ordProcEntity.StuffProperty = PlnSaleOrderBase.stuffProperty(dinMaterial);
                                        #endregion

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

                                        bom = dr["BOM"].ToString();
                                        ordProcEntity.Bom = dr["BOM"].ToString();
                                        ordProcEntity.Gradecode = dr["GRADECODE"].ToString();

                                        if (ordProcEntity.ProcessSeq.Contains("E"))
                                        {
                                            ordProcEntity.EIsOk = "0";
                                        }
                                        else
                                        {
                                            ordProcEntity.EIsOk = "2";
                                        }
                                        ordProcEntity.GradecodeIsOk = "0";
                                        ordProcEntity.EInMaterialDesc = dr["E_IN_MATERIAL_DESC"].ToString();
                                        ordProcEntity.EInMaterialNo = dr["E_IN_MATERIAL_NO"].ToString();
                                        ordProcEntity.DimaterYlg = dr["DIMATER"].ToString();
                                        ordProcEntity.HeightYlg = dr["HEIGHT"].ToString();

                                        ordProcEntity.GroupJgx = FrmDefGroup.DefJgxGourp(desginKey,
                                            mscPline, dr["BOM"].ToString(), this.ob);
                                        ordProcEntity.GroupRcl = FrmDefGroup.DefRclGourp(desginKey,
                                            mscPline, dr["BOM"].ToString(), this.ob);

                                        #region 默认轧管产线
                                        ArrayList paramPline = new ArrayList();
                                        paramPline.Add(dr["D_IN_MATERIAL_NO"].ToString());
                                        paramPline.Add(dr["D_OUT_MATERIAL_NO"].ToString());
                                        paramPline.Add(desginKey);
                                        paramPline.Add(mscPline);
                                        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", dPline))
                                            {
                                                ordProcEntity.DIsOk = "0";
                                                //如果存在ASSEL机组,优选ASSEL机组
                                                if (PlanComm.isInDataTable(dtDpl, "PLINE_CODE", "C012"))
                                                {
                                                    if (FrmPlnSaleOrder.queryAsselFl(uRow.Cells["OrdLnPk"].Value.ToString(), this.ob))
                                                    {
                                                        ordProcEntity.GroupRoll = "C012";
                                                    }
                                                    else
                                                    {
                                                        bool isPline = false;
                                                        foreach (DataRow drPine in dtDpl.Rows)
                                                        {
                                                            if (!drPine["PLINE_CODE"].ToString().Equals("C012"))
                                                            {
                                                                isPline = true;
                                                                ordProcEntity.GroupRoll = drPine["PLINE_CODE"].ToString();
                                                                break;
                                                            }
                                                        }
                                                        if (!isPline)
                                                        {
                                                            ordProcEntity.GroupRoll = dtDpl.Rows[0]["PLINE_CODE"].ToString();
                                                        }
                                                    }
                                                }
                                                else
                                                {
                                                    ordProcEntity.GroupRoll = dtDpl.Rows[0]["PLINE_CODE"].ToString();
                                                }
                                                dPline = ordProcEntity.GroupRoll;
                                            }
                                        }
                                        else if (ordProcEntity.ProcessSeq.Contains("D"))
                                        {
                                            errReason = "未找到可用轧管机组（BOM：" + dr["BOM"].ToString() + "）。";
                                            continue;
                                        }
                                        #endregion

                                        if (ordProcEntity.ProcessSeq.Contains("D")
                                            && !dPline.Trim().Equals("C072")
                                            && !outsStlPipeFl.Equals("121903")
                                            && !outsStlPipeFl.Equals("121902"))
                                        {
                                            #region 合同量转换
                                            inOrdParam = ordAmountCal.getInOrdPlnParam(desginKey, mscPline,
                                                uRow.Cells["OrdLnDlyPk"].Value.ToString(), uRow.Cells["PlnDivideId"].Value.ToString(),
                                                dPline, bom, dtStatus.Rows[0]["CODE_JG"].ToString(), putRate);

                                            if (!ordAmountCal.isRightParam(inOrdParam, desginKey,
                                                dtStatus.Rows[0]["CODE_JG"].ToString(), bom, dPline, out errMessage))
                                            {
                                                errReason = errMessage;
                                                continue;
                                            }
                                            ordAmountCal.InEnity = inOrdParam;
                                            outOrdParam = ordAmountCal.getOrdAmount();
                                            if (outOrdParam.ErrCode == -1)
                                            {
                                                errReason = "合同量转换出错（" + outOrdParam.ErrMessage + "）。";
                                                continue;
                                            }
                                            #endregion
                                        }
                                        isAvailBom = true;
                                        break;
                                    }
                                    if (!isAvailBom)
                                    {
                                        messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString()
                                                + "/" + uRow.Cells["DeliveryNo"].Value.ToString() + errReason;
                                        defailNum++;
                                        continue;
                                    }
                                }
                            }
                            else
                            {
                                if (messageErr.Equals(""))
                                {
                                    messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString()
                                    + "/" + uRow.Cells["DeliveryNo"].Value.ToString()
                                    + "未找到物料信息，请查看工艺制定。";
                                }
                                defailNum++;
                                continue;
                            }
                            #endregion

                            #region 重算合同量
                            if (ordProcEntity.ProcessSeq.Contains("D")
                                && !dPline.Trim().Equals("C072")
                                && !outsStlPipeFl.Equals("121903")
                                && !outsStlPipeFl.Equals("121902"))
                            {
                                inOrdParam = ordAmountCal.getInOrdPlnParam(desginKey,
                                    mscPline, uRow.Cells["OrdLnDlyPk"].Value.ToString(), uRow.Cells["PlnDivideId"].Value.ToString(),
                                    dPline, bom, dtStatus.Rows[0]["CODE_JG"].ToString(), putRate);

                                if (!ordAmountCal.isRightParam(inOrdParam, desginKey,
                                    dtStatus.Rows[0]["CODE_JG"].ToString(), bom, dPline, out errMessage))
                                {
                                    messageErr = errMessage;
                                    defailNum++;
                                    continue;
                                }
                                ordAmountCal.InEnity = inOrdParam;
                                outOrdParam = ordAmountCal.getOrdAmount();
                                if (outOrdParam.ErrCode == -1)
                                {
                                    messageErr = "合同量转换出错（" + outOrdParam.ErrMessage + "）。";
                                    defailNum++;
                                    continue;
                                }
                                ordProcEntity.WeightPerM = outOrdParam.WeightMi.ToString();
                                ordProcEntity.PlanWtD = outOrdParam.WeightInA.ToString();
                                ordProcEntity.PlanNumD = outOrdParam.PlanNum.ToString();
                                ordProcEntity.AimLenRoll = outOrdParam.AimlengthZg.ToString();
                                ordProcEntity.AimLenEnd = outOrdParam.AimLength.ToString();
                                ordProcEntity.PlanPMain = outOrdParam.WeightPc.ToString();
                                ordProcEntity.PlanTotLenD = (outOrdParam.PlanNum * outOrdParam.AimLength).ToString();
                                ordProcEntity.TotLenOneP = outOrdParam.TotLenOneP.ToString();
                                ordProcEntity.CutNumP = outOrdParam.CutNumP.ToString();
                                ordProcEntity.RollLength = outOrdParam.RollLength.ToString();
                                ordProcEntity.AimWallthick = outOrdParam.AimWallthick.ToString();
                                ordProcEntity.LenRollMax = outOrdParam.LenRollMax.ToString();
                                ordProcEntity.LenRollMin = outOrdParam.LenRollMin.ToString();
                            }
                            #endregion
                            list.Add(ordProcEntity);
                        }
                    }
                    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;
                }

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.pss.plnsaleord.order.CoreConfirmCraft";
                ccp.MethodName = "updateCraftVersion";
                ccp.ServerParams = new object[] { list, listLog };
                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 DoIussed()
        {
            try
            {
                int defailNum = 0;
                string messageErr = "";
                ultraGridSaleOrderProc.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkRows = this.ultraGridSaleOrderProc.Rows.AsQueryable().Where(" CHC = 'True' ");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选合同！");
                    return;
                }
                PlanComm.WaitFromOpen(this.Cursor);
               
                foreach (UltraGridRow uRow in checkRows)
                {
                    //if (IsLockCraft(uRow.Cells["OrdLnPk"].Value.ToString()))
                    //{
                    //    messageErr = "合同行：" + uRow.Cells["OrderNoSeq"].Value.ToString()
                    //        + "有工艺文件处于锁定状态，不能下发！";
                    //    defailNum++;
                    //    continue;
                    //}
                   
                    if (uRow.Cells["OrderSource"].Text.Equals("销售合同"))
                    {
                       
                        if (uRow.Cells["OrderNoSeq"].Value != null)
                        {
                            int count = 0;
                            foreach (UltraGridRow uRows in checkRows)
                            {
                                if (uRows.Cells["OrderNoSeq"].Value != null)
                                {
                                    if (uRow.Cells["OrderNoSeq"].Value.ToString().Equals(uRows.Cells["OrderNoSeq"].Value.ToString()))
                                    {
                                        count++;
                                    }         
                                }
                            }
                            if (count > 1)
                            {
                                PlanComm.WaitFromColse(this.Cursor);
                                MessageUtil.ShowTips("排产分类为【销售合同】的合同行：" + uRow.Cells["OrderNoSeq"].Value.ToString()
                         + "有重复，不能同时下发！");
                                return;
                            }
                        }
                     
                    }
                   
                    //查询合同状态
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CoreSaleOrderReceive.querySaleProcStatus",
                        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"))
                    {
                        DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CoreSaleOrderReceive.queryLineLocked",
                            new object[] { uRow.Cells["OrdLnPk"].Value.ToString(), }, this.ob);
                        if (dt == null || dt.Rows.Count <= 0)
                        {
                            defailNum++;
                            continue;
                        }

                        if (!dt.Rows[0][0].ToString().Trim().Equals("0"))
                        {
                            messageErr = "合同行：" + uRow.Cells["OrderNoSeq"].Value.ToString()
                                + "处于销售变更冻结中！";
                            defailNum++;
                            continue;
                        }

                        if (dtStatus.Rows[0]["PLAN_IS_OK"].ToString().Equals("0"))
                        {
                            messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                                + uRow.Cells["DeliveryNo"].Value.ToString() + "计划未确认！";
                            defailNum++;
                            continue;
                        }

                        if (dtStatus.Rows[0]["CRAFT_SEQ"].ToString().Equals(""))
                        {
                            messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                                + uRow.Cells["DeliveryNo"].Value.ToString()
                                + uRow.Cells["PlnDivideId"].Value.ToString() + "无工艺！";
                            defailNum++;
                            continue;
                        }

                        if (!dtStatus.Rows[0]["VALIDFLAG"].ToString().Trim().Equals("1"))
                        {
                            messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                                + uRow.Cells["DeliveryNo"].Value.ToString()
                                + uRow.Cells["PlnDivideId"].Value.ToString() + "使用的不是有效工艺或工艺文件未上传！";
                            defailNum++;
                            continue;
                        }
                        if (dtStatus.Rows[0]["E_IS_OK"].ToString().Equals("0") &&
                            !dtStatus.Rows[0]["BJ_TYPE"].ToString().Equals("镦粗"))
                        {
                            messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                                + uRow.Cells["DeliveryNo"].Value.ToString() + "镦拔扩未确认！";
                            defailNum++;
                            continue;
                        }

                        if (dtStatus.Rows[0]["INDEX_SEQ"].ToString().Equals(""))
                        {
                            messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                                + uRow.Cells["DeliveryNo"].Value.ToString()
                                + uRow.Cells["PlnDivideId"].Value.ToString() + "无制程！";
                            defailNum++;
                            continue;
                        }
                        if (dtStatus.Rows[0]["BOM"].ToString().Equals(""))
                        {
                            messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                                + uRow.Cells["DeliveryNo"].Value.ToString()
                                + uRow.Cells["PlnDivideId"].Value.ToString() + "无BOM！";
                            defailNum++;
                            continue;
                        }
                        if (dtStatus.Rows[0]["DESGIN_KEY"].ToString().Equals(""))
                        {
                            messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                                + uRow.Cells["DeliveryNo"].Value.ToString() + "未找到工艺制定数据,请制定工艺！";
                            defailNum++;
                            continue;
                        }
                        ArrayList param = new ArrayList();
                        param.Add(UserInfo.GetUserName());
                        param.Add(uRow.Cells["OrdLnDlyPk"].Value.ToString());
                        param.Add(uRow.Cells["PlnDivideId"].Value.ToString());
                        param.Add(dtStatus.Rows[0]["ORDER_UNIT"].ToString());
                        param.Add(dtStatus.Rows[0]["PLAN_WT_D"].ToString());
                        param.Add(dtStatus.Rows[0]["PLAN_NUM_D"].ToString());
                        param.Add(uRow.Cells["OrderNoSeq"].Value.ToString());
                        param.Add(uRow.Cells["OrderSource"].Value.ToString());
                        list.Add(param);
                    }
                    else
                    {
                        if (dtStatus.Rows[0]["PLANSTATUS"].ToString().CompareTo("1") > 0)
                        {
                            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;
                }
                string flag = "0";
                if (comQueryPanelSource1.checkBox1.Checked)
                {
                    flag = "1";
                }
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.pss.plnsaleord.order.CoreConfirmCraft";
                ccp.MethodName = "iussedOrder";
                ccp.ServerParams = new object[] { list, flag };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                PlanComm.WaitFromColse(this.Cursor);
                int suceedNum = list.Count;
                if (ccp.ReturnCode != -1)
                {
                 
                    if (ccp.ReturnObject != null &&
                        ccp.ReturnObject.GetType().FullName.Trim().Equals("System.Object[]"))
                    {
                        object[] message = (object[])ccp.ReturnObject;
                        defailNum += (int)message[0];
                        suceedNum = suceedNum - (int)message[0];
                        messageErr = message[1].ToString();
                    }
                    MessageUtil.ShowTips(suceedNum + "条下发成功，" + defailNum + "条下发失败。\n" + messageErr);
                }
                if (suceedNum > 0)
                {
                    DoQuery(GetQueryCondition());
                }
            }
            catch (Exception ex)
            {
                PlanComm.WaitFromColse(this.Cursor);
                if (!(ex is MESException))
                {
                    MessageUtil.ShowError(ex.Message);
                }
            }
            
          
        }

        /// <summary>
        /// 刷新工艺
        /// </summary>
        private void DoRefresCraft()
        {
            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)
            {
                //查询合同状态
                DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CoreConfirmCraft.selectPlnOrderStatus",
                    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"))
                {
                    ArrayList param = new ArrayList();
                    PlnSaleordProcEntity orderPrcEntity = new PlnSaleordProcEntity();
                    string ordLnPk = uRow.Cells["OrdLnPk"].Value.ToString();
                    string desginKey = "";
                    string dinMaterialNo = dtStatus.Rows[0]["D_IN_MATERIAL_NO"].ToString();
                    string doutMaterialNo = dtStatus.Rows[0]["D_OUT_MATERIAL_NO"].ToString();
                    orderPrcEntity.CraftSeq = dtStatus.Rows[0]["CRAFT_SEQ"].ToString();
                    orderPrcEntity.IndexSeq = dtStatus.Rows[0]["INDEX_SEQ"].ToString();
                    orderPrcEntity.ProcessSeq = dtStatus.Rows[0]["PROCESS_SEQ"].ToString();
                    orderPrcEntity.FIsOk = dtStatus.Rows[0]["F_IS_OK"].ToString();
                    orderPrcEntity.GroupRcl = dtStatus.Rows[0]["GROUP_RCL"].ToString();
                    orderPrcEntity.Bom = dtStatus.Rows[0]["BOM"].ToString();
                    orderPrcEntity.GroupRoll = dtStatus.Rows[0]["GROUP_ROLL"].ToString();
                    orderPrcEntity.Gradecode = dtStatus.Rows[0]["GRADECODE"].ToString();
                    orderPrcEntity.OrdLnDlyPk = uRow.Cells["OrdLnDlyPk"].Value.ToString();
                    orderPrcEntity.PlnDivideId = uRow.Cells["PlnDivideId"].Value.ToString();
                    #region 对比制程有无变化
                    DataTable dtDegnPl = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CoreConfirmCraft.selectCraftDesgin",
                    new object[] { ordLnPk, orderPrcEntity.CraftSeq }, this.ob);
                    if (dtDegnPl != null && dtDegnPl.Rows.Count > 0)
                    {
                        DataRow dr = null;
                        if (!PlanComm.isInDataTable(dtDegnPl, "MSC_PLINE", orderPrcEntity.IndexSeq))
                        {
                            dr = dtDegnPl.Rows[0];
                        }
                        else
                        {
                            dtDegnPl.DefaultView.RowFilter = "MSC_PLINE = '" + orderPrcEntity.IndexSeq + "'";
                            dr = dtDegnPl.DefaultView.ToTable().Rows[0];
                        }
                        desginKey = dr["DESGIN_KEY"].ToString();
                        orderPrcEntity.IndexSeq = dr["MSC_PLINE"].ToString();
                        if (!dr["WHOLE_BACKLOG"].ToString().Equals(orderPrcEntity.ProcessSeq))
                        {
                            orderPrcEntity.ProcessSeq = dr["WHOLE_BACKLOG"].ToString();
                            if (dr["WHOLE_BACKLOG"].ToString().Contains('F'))
                            {
                                if (orderPrcEntity.FIsOk.Equals("2"))
                                {
                                    orderPrcEntity.FIsOk = "0";
                                    orderPrcEntity.GroupRcl = "";
                                }
                            }
                            else
                            {
                                orderPrcEntity.FIsOk = "2";
                                orderPrcEntity.GroupRcl = "/";
                            }
                        }
                        orderPrcEntity.GradecodeAll = dtDegnPl.Rows[0]["GRADENAME"].ToString();
                        if (orderPrcEntity.ProcessSeq.Equals(""))
                        {
                            messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString()
                                    + "/" + uRow.Cells["DeliveryNo"].Value.ToString()
                                    + "未找到制程经过的工序。";
                            defailNum++;
                            continue;
                        }    
                    }
                    else
                    {
                        messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString()
                        + "/" + uRow.Cells["DeliveryNo"].Value.ToString()
                        + "未找到工艺下的制程信息，请联系工艺人员。";
                        defailNum++;
                        continue;
                    }
                    #endregion

                    #region 对比BOM物料有无变化
                    //param.Clear();
                    //param.Add(orderPrcEntity.IndexSeq);
                    //param.Add(uRow.Cells["Msc"].Value.ToString());
                    //param.Add(uRow.Cells["MaterialNo"].Value.ToString());
                    //param.Add(orderPrcEntity.ProcessSeq);
                    DataTable dtBom = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CoreOrderDesignBom.getOrdLineMscBom",
                        new object[] { desginKey, uRow.Cells["Msc"].Value.ToString(), orderPrcEntity.IndexSeq }, this.ob);
                    if (dtBom != null && dtBom.Rows.Count > 0)
                    {
                        DataRow dr = null;
                        if (!PlanComm.isInDataTable(dtBom, "BOM", orderPrcEntity.Bom))
                        {
                            dtBom.DefaultView.RowFilter = "D_IN_MATERIAL_NO = '" + dinMaterialNo + "'";
                            DataTable dt1 = dtBom.DefaultView.ToTable();
                            if (dt1.Rows.Count > 0) 
                            {
                                //有相同轧管规格的BOM
                                dt1.DefaultView.RowFilter = "GRADECODE = '" + orderPrcEntity.Gradecode + "'";
                                if (dt1.DefaultView.ToTable().Rows.Count > 0)
                                {
                                    //有相同钢种的BOM
                                    dr = dt1.DefaultView.ToTable().Rows[0];
                                }
                                else
                                {
                                    dr = dt1.Rows[0];
                                }
                            }
                            else
                            {
                                dtBom.DefaultView.RowFilter = "GRADECODE = '" + orderPrcEntity.Gradecode + "'";
                                if (dtBom.DefaultView.ToTable().Rows.Count > 0)
                                {
                                    dr = dtBom.DefaultView.ToTable().Rows[0];
                                }
                                else
                                {
                                    dr = dtBom.Rows[0];
                                }
                            }
                        }
                        else
                        {
                            dtBom.DefaultView.RowFilter = "BOM = '" + orderPrcEntity.Bom + "'";
                            dr = dtBom.DefaultView.ToTable().Rows[0];
                        }

                        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(desginKey,
                            orderPrcEntity.IndexSeq, dr["BOM"].ToString(), this.ob);
                        orderPrcEntity.GroupRcl = FrmDefGroup.DefRclGourp(desginKey,
                            orderPrcEntity.IndexSeq, dr["BOM"].ToString(), this.ob);
                    }
                    else
                    {
                        messageErr = "合同：" + uRow.Cells["OrderNoSeq"].Value.ToString()
                            + "/" + uRow.Cells["DeliveryNo"].Value.ToString()
                            + "未找到制程" + orderPrcEntity.IndexSeq + "向下的物料信息。";
                        defailNum++;
                        continue;
                    }
                    #endregion
                    list.Add(orderPrcEntity);
                }
                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;
            }
            
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.order.CoreConfirmCraft";
            ccp.MethodName = "updateRefresCraft";
            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);
                }
            }

        }

        /// <summary>
        /// 取消下发
        /// </summary>
        private void DoConcelIussed()
        {
            try
            {
                ArrayList messageErr = new ArrayList();
                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.CoreSaleOrderReceive.querySaleProcStatus",
                        new object[] { uRow.Cells["OrdLnDlyPk"].Value.ToString(), uRow.Cells["PlnDivideId"].Value.ToString() }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        messageErr.Add("");
                        continue;
                    }
                    if (dtStatus.Rows[0]["PLANSTATUS"].ToString().Equals("2"))
                    {
                        ArrayList param = new ArrayList();
                        param.Add(UserInfo.GetUserName());
                        param.Add(uRow.Cells["OrdLnDlyPk"].Value.ToString());
                        param.Add(uRow.Cells["PlnDivideId"].Value.ToString());
                        param.Add(dtStatus.Rows[0]["ORDER_UNIT"].ToString());
                        param.Add(dtStatus.Rows[0]["PLAN_WT_D"].ToString());
                        param.Add(dtStatus.Rows[0]["PLAN_NUM_D"].ToString());
                        list.Add(param);
                    }
                    else
                    {
                        if (dtStatus.Rows[0]["PLANSTATUS"].ToString().CompareTo("2") > 0)
                        {
                            messageErr.Add("合同：" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                                + uRow.Cells["DeliveryNo"].Value.ToString() + "已经生产了！");
                        }
                        else
                        {
                            messageErr.Add("合同：" + uRow.Cells["OrderNoSeq"].Value.ToString() + "/"
                                + uRow.Cells["DeliveryNo"].Value.ToString() + "还未下发！");
                        }
                        continue;
                    }
                }
                if (list.Count == 0)
                {
                    PlanComm.WaitFromColse(this.Cursor);
                    MessageUtil.ShowTips("0条撤消成功，" + messageErr.Count + "条撤消失败。\n" + messageErr[0]);
                    return;
                }

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

                PlanComm.WaitFromColse(this.Cursor);
                if (ccp.ReturnCode != -1)
                {
                    int suceed = list.Count;
                    if (ccp.ReturnObject != null)
                    {
                        List<string> message = (List<string>)JsonConvert.DeserializeObject(
                            ccp.ReturnObject.ToString(), typeof(List<string>));
                        foreach (string reason in message)
                        {
                            messageErr.Add(reason);
                            suceed--;
                        }
                    }
                    if (messageErr.Count > 0)
                    {
                        MessageUtil.ShowTips(suceed + "条撤消成功，"
                            + messageErr.Count + "条撤消失败。\n" + messageErr[0]);
                    }
                    else
                    {
                        MessageUtil.ShowTips(suceed + "条撤消成功，0条撤消失败。");
                    }
                }
            }
            catch (Exception ex)
            {
                PlanComm.WaitFromColse(this.Cursor);
                if (!(ex is MESException))
                {
                    MessageUtil.ShowError(ex.Message);
                }
            }
            DoQuery(GetQueryCondition());
        }
        /// <summary>
        ///排产合同拆分
        /// </summary>
        private void doBreakUp()
        {
            ultraGridSaleOrderProc.UpdateData();
            IQueryable<UltraGridRow> checkRows = this.ultraGridSaleOrderProc.Rows.AsQueryable().Where(" CHC = 'True' ");
            if (checkRows.Count() == 0)
            {
                MessageUtil.ShowTips("未勾选排产合同！");
                return;
            }
            if (checkRows.Count() > 1)
            {
                MessageUtil.ShowWarning("不能一次性拆分多条合同!");
                return;
            }
            int num = 0;
            double wgt = 0;
            double ratio = 0;
            ArrayList jsonList = new ArrayList();
            foreach (UltraGridRow uRow in checkRows)
            {
                ArrayList list = new ArrayList();
                if (!uRow.Cells["Planstatus"].Text.Trim().Equals("已接收"))
                {
                    MessageUtil.ShowTips("选中的合同不是已接收状态,不能拆分!");
                    return;
                }
                if (!uRow.Cells["PlanWtD"].Text.Trim().Equals(""))
                {
                    num = int.Parse(uRow.Cells["PlanNumD"].Value.ToString());
                    wgt = double.Parse(uRow.Cells["PlanWtD"].Value.ToString());
                }
                //重量与支数比例
                ratio = wgt / num;
                list.Add(uRow.Cells["OrdLnDlyPk"].Value.ToString());
                list.Add(uRow.Cells["PlnDivideId"].Value.ToString());
                list.Add(ratio.ToString());
                jsonList.Add(list);
            }
            FrmSpitWgtSProc frmSpitWgt = new FrmSpitWgtSProc(wgt, num, ratio, ob);
            frmSpitWgt.ShowDialog();
            double spitWgt = frmSpitWgt.AlreadySpitWgt;
            int spitNum = frmSpitWgt.AlreadySpitNum;
            if (spitWgt <= 0) { return; }
            if (MessageUtil.ShowYesNoAndQuestion("是否拆分?") == DialogResult.No)
            {
                return;
            }
            PlanComm.WaitFromOpen(this.Cursor);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.order.CoreConfirmCraft";
            ccp.MethodName = "doBreakUp";
            ccp.ServerParams = new object[] { jsonList, spitWgt.ToString(), spitNum.ToString(), this.UserInfo.GetUserName() };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

            PlanComm.WaitFromColse(this.Cursor);
            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("拆分成功!"))
            {
                DoQuery(GetQueryCondition());
            }
        }
        /// <summary>
        /// 合并
        /// </summary>
        private void doMerge()
        {
            ultraGridSaleOrderProc.UpdateData();
            IQueryable<UltraGridRow> checkRows = this.ultraGridSaleOrderProc.Rows.AsQueryable().Where(" CHC = 'True' ");
            if (checkRows.Count() == 0 || checkRows.Count() == 1)
            {
                MessageUtil.ShowTips("请选择多个排产合同！");
                return;
            }
            //if (checkRows.Count() > 1)
            //{
            //    MessageUtil.ShowWarning("不能一次性拆分多条合同!");
            //    return;
            //}
            int num = 0;
            double wgt = 0;
            double ratio = 0;
            ArrayList jsonList = new ArrayList();
            string ordLnDlyPk = "";
            string orderSource = "";
            foreach (UltraGridRow uRow in checkRows)
            {
                ArrayList list = new ArrayList();
                if (!uRow.Cells["Planstatus"].Text.Trim().Equals("已接收"))
                {
                    MessageUtil.ShowTips("选中的合同不是已接收状态,不能拆分!");
                    return;
                }
                if (ordLnDlyPk.Equals("")) { ordLnDlyPk = uRow.Cells["OrdLnDlyPk"].Value.ToString(); }
                if (orderSource.Equals("")) { orderSource = uRow.Cells["OrderSource"].Value.ToString(); }
                if (!uRow.Cells["OrdLnDlyPk"].Value.ToString().Equals(ordLnDlyPk) || !uRow.Cells["OrderSource"].Value.ToString().Equals(orderSource))
                {
                    MessageUtil.ShowTips("相同合同并且合同来源也相同才能合并!");
                    return;
                }
                list.Add(uRow.Cells["OrdLnDlyPk"].Value.ToString());
                list.Add(uRow.Cells["PlnDivideId"].Value.ToString());
                jsonList.Add(list);
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否合并?") == DialogResult.No)
            {
                return;
            }
            PlanComm.WaitFromOpen(this.Cursor);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.order.CoreConfirmCraft";
            ccp.MethodName = "doMerge";
            ccp.ServerParams = new object[] { jsonList };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

            PlanComm.WaitFromColse(this.Cursor);
            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("合并成功!"))
            {
                DoQuery(GetQueryCondition());
            }
        }


        /// <summary>
        /// 查看上传工艺文件
        /// </summary>
        private void DoLookCraftFile()
        {
            UltraGridRow ugr = this.ultraGridSaleOrderProc.ActiveRow;
            if (ugr == null)
            {
                return;
            }
            DataTable dtPath = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CoreSaleOrderReceive.queryCraftFilePath",
                       new object[] { ugr.Cells["OrdLnDlyPk"].Value.ToString(), ugr.Cells["PlnDivideId"].Value.ToString() }, this.ob);
            if (dtPath != null && dtPath.Rows.Count > 0)
            {
                ArrayList listPIC = new ArrayList();
                foreach (DataRow dr in dtPath.Rows)
                {
                    listPIC.Add(dr["CRAFT_PATH"].ToString());
                }
                dlgOrderAskLook orderAsk = new dlgOrderAskLook(this.ob, listPIC);
                orderAsk.Text = "查看上传工艺文件";
                orderAsk.Show();
            }
        }

        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 FrmConfirmCraft_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("ConfirmCraft"))
            {
                toolMenu.Toolbars[0].Tools["ConfirmCraft"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("RefresCraft"))
            {
                toolMenu.Toolbars[0].Tools["RefresCraft"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("Iussed"))
            {
                toolMenu.Toolbars[0].Tools["Iussed"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("ConcelIussed"))
            {
                toolMenu.Toolbars[0].Tools["ConcelIussed"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("RefresDate"))
            {
                toolMenu.Toolbars[0].Tools["RefresDate"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("ModifyBaseMlPl"))
            {
                toolMenu.Toolbars[0].Tools["ModifyBaseMlPl"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("ExportProc"))
            {
                toolMenu.Toolbars[0].Tools["ExportProc"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("UpdateMonth"))
            {
                toolMenu.Toolbars[0].Tools["UpdateMonth"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("BreakUp"))
            {
                toolMenu.Toolbars[0].Tools["BreakUp"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("Merge"))
            {
                toolMenu.Toolbars[0].Tools["Merge"].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("GridExport"))
            {
                toolMenu.Toolbars[0].Tools["GridExport"].InstanceProps.Visible = appearance;
            }
            #endregion
        }

        /// <summary>
        /// 验证合同行工艺文件有没有锁定的(true- 锁定，false - 无锁定)
        /// </summary>
        /// <param name="ordLnPk">合同行pk</param>
        /// <returns></returns>
        private bool IsLockCraft(string ordLnPk)
        {
            bool isLocked = false;
            DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CoreSaleOrderReceive.queryCraftLockFlag",
                new object[] { ordLnPk }, this.ob);
            if (dt != null && dt.Rows.Count > 0)
            {
                if (!dt.Rows[0][0].ToString().Trim().Equals("0"))
                {
                    isLocked = true;
                }
            }
            return isLocked;
        }

        /// <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;
                }
            }
        }

        /// <summary>
        /// 小时能力维护
        /// </summary>
        private void DoModifyBaseMlPl()
        {
            UltraGridRow ugr = ultraGridSaleOrderProc.ActiveRow;
            if (ugr == null)
            {
                return;
            }
            string ordLnDlyPk = ugr.Cells["OrdLnDlyPk"].Value.ToString();
            string plnDivideId = ugr.Cells["PlnDivideId"].Value.ToString();
            FrmOrdProcessBasePl processBasePl = new FrmOrdProcessBasePl(ordLnDlyPk, plnDivideId, this.ob);
            processBasePl.ShowDialog();
        }

        /// <summary>
        /// 合同行工艺文件
        /// </summary>
        private void TechOrderLine()
        {
            UltraGridRow ugr = ultraGridSaleOrderProc.ActiveRow;
            if (ugr == null)
            {
                return;
            }
            string ordLnPk = ugr.Cells["OrdLnPk"].Value.ToString();
            string designKey = ugr.Cells["DesginKey"].Value.ToString();
            string url = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepTechOrderLineCraft.cpt&__bypagesize__=false&format=pdf&__embed__=true"
                + "&desgin_key=" + designKey + "&lnpk=" + ordLnPk;
            FrmOutExcel outPut = new FrmOutExcel(url);
            outPut.Show();
        }
        /// <summary>
        /// 修改排产月份
        /// </summary>
        private void UpdateMonth()
        {
            try
            {
                ArrayList messageErr = new ArrayList();
                ultraGridSaleOrderProc.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkRows = ultraGridSaleOrderProc.Rows.AsQueryable().Where(" CHC = 'True' ");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选合同！");
                    return;
                }
                foreach (UltraGridRow uRow in checkRows)
                {
                    if (uRow.Cells["RollMonth"].Value.ToString().Equals(""))
                    {
                        MessageUtil.ShowTips("排产月份不能为空！");
                        return;
                    }                   
                    ArrayList param = new ArrayList();
                    param.Add(uRow.Cells["OrdLnDlyPk"].Value.ToString());
                    param.Add(uRow.Cells["PlnDivideId"].Value.ToString());
                    param.Add(uRow.Cells["RollMonth"].Text.ToString().Trim());
                    list.Add(param);
                }
                if (list.Count == 0)
                {
                    PlanComm.WaitFromColse(this.Cursor);
                    MessageUtil.ShowTips("0条撤消成功，" + messageErr.Count + "条撤消失败。\n" + messageErr[0]);
                    return;
                }

                PlanComm.WaitFromOpen(this.Cursor);
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.pss.plnsaleord.order.CoreConfirmCraft";
                ccp.MethodName = "updateMonth";
                ccp.ServerParams = new object[] { list, UserInfo.GetUserName() };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                PlanComm.WaitFromColse(this.Cursor);
                  if (ccp.ReturnCode == -1) return;
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("排产月份调整成功!"))
                {
                   DoQuery(GetQueryCondition());
                }
            }
            catch (Exception ex)
            {
                MessageUtil.ShowError("请输入正确的时间格式!");
                //if (!(ex is MESException))
                //{
                //    MessageUtil.ShowError(ex.Message);
                //}
            }
          
        }

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