MES_Client/TGMES/Core.StlMes.Client.Plan.Order/FrmSaleOrderOP.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 System.Collections;
using System.IO;
using System.Diagnostics;
using Infragistics.Win.UltraWinGrid;
using Infragistics.Win;
using Infragistics.Win.UltraWinGrid.ExcelExport;
using Infragistics.Excel;
using CoreFS.CA06;
using CoreFS.SA06;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm;
using Core.Mes.Client.Comm.Tool;
using com.steering.pss.plan.order;
using Core.StlMes.Client.Plan.Order.BaseMethod;
using Core.StlMes.Client.Plan.Order.PopupWindow;
using com.steering.pss.plan.order.model;

namespace Core.StlMes.Client.Plan.Order
{
    /// <summary>
    /// 销售合同处理
    /// @author：杨天海
    /// @version：v1.1
    /// @date:2015.04.11 
    /// </summary>
    public partial class FrmSaleOrderOP : FrmBase
    {
        //用于计算可分离容器的大小。
        private int _splitterDistance = 0;
        private bool _groupBox2ExpandedChanged = false;

        public FrmSaleOrderOP()
        {
            this.IsLoadUserView = true;
            InitializeComponent();
        }

        public FrmSaleOrderOP(OpeBase ob)
        {
            this.ob = ob;
            InitializeComponent();
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            base.ToolBar_Click(sender, ToolbarKey);
            switch (ToolbarKey)
            {
                case "Query":  //查询
                    doQuery(GetQueryCondition());
                    break;
                case "Pretreat"://合同预处理
                    Pretreat();
                    break;
                case "CancelPre"://取消合同预处理
                    CancelPre();
                    break;
                case "ProcessJG"://接箍处理
                    doProcessJg();
                    break;
                case "CancelJg"://取消接箍合同
                    doCancelJg();
                    break;
                case "ProcessDJ"://短节处理
                    doProcessDj();
                    break;
                case "CancelDj"://取消短节合同
                    doCancelDj();
                    break;
                case "ConfirmGrade"://钢种坯料确认
                    doConfirmGrade();
                    break;
                case "ConfirmZg"://轧管确认
                    doConfirmZg();
                    break;
                case "ModifyBom":
                    setOrderBom();
                    break;
                case "ConfirmBj"://镦拔扩确认
                    doConfirmBj();
                    break;
                case "ConfirmRcl"://热处理确认
                    doConfirmRcl();
                    break;
                case "ConfirmGjg"://管加工确认
                    doConfirmGjg();
                    break;
                case "OrderSaleIssued"://销售合同下发
                    OrderSaleIssued();
                    break;
                case "CancelSaleIssued"://取消销售合同下发
                    CancelSaleIssued();
                    break;
                case "QueryJgl":  //接箍料编制查询
                    QueryJGl();
                    break;
                case "SaveJg":  //保存接箍合同
                    UpdateJgOrder();
                    break;
                case "Plait":    //接箍料需求保存
                    doPlait();
                    break;
                case "AddPlait":    //加入现有接箍料需求
                    doAddPlait();
                    break;
                case "Delete":   //删除接箍需求
                    Delete();
                    break;
                case "DeleteOne":   //删除接箍需求单量
                    DeleteOne();
                    break;
                case "QueryIssued"://查询下发合同信息
                    QueryIssued();
                    break;
                case "ExportSale":  //导出
                    ExportSale();
                    break;
                case "Import":  //导入工艺
                    DoImport();
                    break;
                case "TechOrderLine":  //
                    TechOrderLine();
                    break;
                case "TechOrderLineSqe":  //
                    TechOrderLineSqe();
                    break;
                case "RefresDate"://刷新加载数据
                    RefresDate();
                    doQuery(GetQueryCondition());
                    break;
                case "Close":  //关闭
                    this.Close();
                    break;
                case "FinishJk"://缴库完成
                    doFinishJk();
                    break;
                case "FinishSc"://生产完成
                    doFinishSc();
                    break;
                case "RepRequest"://补量申请
                    DoRepRequest();
                    break;
                case "RepExport"://补量申请导出
                    PlanComm.Export(ref ultraGrid1, "销售合同");
                    break;
            }
        }

        private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            switch (e.Tool.Key)
            {
                case "Save"://更新短节备料信息
                    UpdateDjBl(ultraGrid3);
                    break;
                case "ConfirmZg"://轧管确认
                    ConfirmBlZg(ultraGrid3);
                    break;
                case "ConfirmBj"://镦拔扩确认
                    ConfirmBlBj(ultraGrid3);
                    break;
                case "ConfirmRcl"://热处理确认
                    ConfirmBlRcl(ultraGrid3);
                    break;
                case "Iussed"://短节需求下发
                    IssuedBlNeed(ultraGrid3);
                    break;
                case "CancelIssued"://取消下发
                    CancelBlIssued(ultraGrid3);
                    break;
                case "Export":
                    doExportBl("DJBL");
                    break;
            }
        }

        /// <summary>
        /// 备料轧管确认
        /// </summary>
        private void ConfirmBlZg(UltraGrid ugrid)
        {
            try
            {
                ugrid.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkRows = ugrid.Rows.AsQueryable().Where(" CHECK = 'True' ");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选保存的备料！");
                    return;
                }
                foreach (UltraGridRow uRow in checkRows)
                {
                    ///查询合同状态
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryBLbyReqBlId",
                        new object[] { uRow.Cells["REQ_BL_ID"].Value.ToString() }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        break;
                    }
                    if (dtStatus.Rows[0]["PLANSTATUS"].ToString().Equals("0"))
                    {
                        ArrayList param = new ArrayList();
                        param.Add("1");
                        param.Add(uRow.Cells["GROUP_ROLL"].Value.ToString());
                        param.Add(uRow.Cells["DIMATER_YLG"].Value.ToString());
                        param.Add(uRow.Cells["HEIGHT_YLG"].Value.ToString());
                        param.Add(uRow.Cells["REQ_BL_ID"].Value.ToString());
                        list.Add(param);
                    }
                }
                if (list.Count == 0)
                {
                    return;
                }
                int suceed = ServerHelper.SetData("com.steering.pss.plan.order.CoreSaleOrderOP.confirmBlZg",
                    new object[] { list }, this.ob);
                if (suceed > 0)
                {
                    MessageUtil.ShowTips("保存成功！");
                }
                else
                {
                    MessageUtil.ShowTips("保存失败！");
                }
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            if (ugrid != ultraGrid3)
            {
                QueryJGl();
            }
            else
            {
                doQuery(GetQueryCondition());
            }
        }

        /// <summary>
        /// 镦拔扩确认
        /// </summary>
        private void ConfirmBlBj(UltraGrid ugrid)
        {
            try
            {
                ugrid.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkRows = ugrid.Rows.AsQueryable().Where(" CHECK = 'True' ");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选要保存的备料！");
                    return;
                }
                foreach (UltraGridRow uRow in checkRows)
                {
                    ///查询合同状态
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryBLbyReqBlId",
                        new object[] { uRow.Cells["REQ_BL_ID"].Value.ToString() }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        break;
                    }
                    if (dtStatus.Rows[0]["PLANSTATUS"].ToString().Equals("0"))
                    {
                        ArrayList param = new ArrayList();
                        if (uRow.Cells["BJ_TYPE"].Value.ToString().Equals("")
                            || uRow.Cells["BJ_TYPE"].Value.ToString().Equals("/"))
                        {
                            param.Add("2");
                        }
                        else
                        {
                            param.Add("1");
                        }
                        param.Add(uRow.Cells["E_IN_MATERIAL_NO"].Value.ToString());
                        param.Add(uRow.Cells["E_IN_MATERIAL_NO"].Text.Trim());
                        param.Add(uRow.Cells["DIMATER_YLG"].Value.ToString());
                        param.Add(uRow.Cells["HEIGHT_YLG"].Value.ToString());
                        param.Add(uRow.Cells["BJ_TYPE"].Value.ToString());
                        param.Add(uRow.Cells["REQ_BL_ID"].Value.ToString());
                        list.Add(param);
                    }
                }
                if (list.Count == 0)
                {
                    return;
                }
                int suceed = ServerHelper.SetData("com.steering.pss.plan.order.CoreSaleOrderOP.confirmBlBj",
                    new object[] { list }, this.ob);
                if (suceed > 0)
                {
                    MessageUtil.ShowTips("保存成功！");
                }
                else
                {
                    MessageUtil.ShowTips("保存失败！");
                }
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            if (ugrid != ultraGrid3)
            {
                QueryJGl();
            }
            else
            {
                doQuery(GetQueryCondition());
            }
        }

        /// <summary>
        /// 热处理确认
        /// </summary>
        private void ConfirmBlRcl(UltraGrid ugrid)
        {
            try
            {
                ugrid.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkRows = ugrid.Rows.AsQueryable().Where(" CHECK = 'True' ");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选要保存的备料！");
                    return;
                }
                foreach (UltraGridRow uRow in checkRows)
                {
                    ///查询合同状态
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryBLbyReqBlId",
                        new object[] { uRow.Cells["REQ_BL_ID"].Value.ToString() }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        break;
                    }
                    if (dtStatus.Rows[0]["PLANSTATUS"].ToString().Equals("0"))
                    {
                        ArrayList param = new ArrayList();
                        if (uRow.Cells["GROUP_RCL"].Value.ToString().Equals("")
                            || uRow.Cells["GROUP_RCL"].Value.ToString().Equals("/"))
                        {
                            param.Add("2");
                        }
                        else
                        {
                            param.Add("1");
                        }
                        param.Add(uRow.Cells["GROUP_RCL"].Value.ToString());
                        param.Add(uRow.Cells["REQ_BL_ID"].Value.ToString());
                        list.Add(param);
                    }
                }
                if (list.Count == 0)
                {
                    return;
                }
                int suceed = ServerHelper.SetData("com.steering.pss.plan.order.CoreSaleOrderOP.confirmBlRcl",
                    new object[] { list }, this.ob);
                if (suceed > 0)
                {
                    MessageUtil.ShowTips("保存成功！");
                }
                else
                {
                    MessageUtil.ShowTips("保存失败！");
                }
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            if (ugrid != ultraGrid3)
            {
                QueryJGl();
            }
            else
            {
                doQuery(GetQueryCondition());
            }
        }

        private void ultraToolbarsManager2_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            switch (e.Tool.Key)
            {
                case "Save"://保存接箍料信息
                    UpdateDjBl(ultraGrid6);
                    break;
                case "ConfirmZg"://轧管确认
                    ConfirmBlZg(ultraGrid6);
                    break;
                case "ConfirmBj"://镦拔扩确认
                    ConfirmBlBj(ultraGrid6);
                    break;
                case "ConfirmRcl"://热处理确认
                    ConfirmBlRcl(ultraGrid6);
                    break;
                case "Iussed":  //接箍料需求下发
                    IssuedBlNeed(ultraGrid6);
                    break;
                case "CancelIssued"://取消下发
                    CancelBlIssued(ultraGrid6);
                    break;
                case "Export":
                    doExportBl("JGL");
                    break;
            }
        }

        private void ultraToolbarsManager3_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            switch (e.Tool.Key)
            {
                case "Iussed"://合同下发
                    OrderJgIssued();
                    break;
                case "CancelIssued"://取消下发
                    CancelJgIssued();
                    break;
            }
        }

        /// <summary>
        /// 质量设计制程
        /// </summary>
        private DataTable tableIndex = null;

        /// <summary>
        /// 页面加载
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void FrmSaleOrderOP_Load(object sender, EventArgs e)
        {
            ctrlForQueryPORDERSTATUS.SelectedIndex = 0;
            this.ultraTextEditorAcceptNo.Value = DateTime.Now.ToString("yyMM") + "X" + DateTime.Now.ToString("MMdd");

            ultraComboGroupType.SelectedIndex = 0;
            ultraDateTimeDELVRY_EDATEFrom.Value = DateTime.Now;
            ultraDateTimeDELVRY_EDATETo.Value = DateTime.Now;
            ultraTextAcceptNo.Value = DateTime.Now.ToString("yyMM") + "X";

            RefresDate();
            Init();
        }

        /// <summary>
        /// 界面权限分配
        /// </summary>
        private void Init()
        {
            switch (this.CustomInfo.ToString().Trim())
            {
                case "@BJ":
                    #region 
                    ultraGrid1.DisplayLayout.Bands[0].Columns["CODE_JG"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["BL_GROUP_NUM"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["ROLL_MONTH"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP_JGX"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP_RCL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["OUTS_BILLET_FL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["OUTS_STL_PIPE_FL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["JGORD_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["JGL_REQ_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["DJBL_REQ_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["IF_ALLOW_ISSUE"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["D_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["G_IS_OK"].Hidden = true;
                    ultraTabControl1.Tabs[1].Visible = false;
                    ultraTabControl1.Tabs[2].Visible = false;
                    splitContainer2.Panel2Collapsed = true;
                    ctrlForQueryPORDERSTATUS.SelectedIndex = 1;
                    ctrlForQueryPORDERSTATUS.Items.Remove(4);
                    ctrlForQueryPORDERSTATUS.Items.Remove(3);
                    ctrlForQueryPORDERSTATUS.Items.Remove(2);
                    ctrlForQueryPORDERSTATUS.Items.Remove(0);
                    #endregion
                    doQuery(GetQueryCondition());
                    break;
                case "@GRADE":
                    #region
                    ultraGrid1.DisplayLayout.Bands[0].Columns["CODE_JG"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["BL_GROUP_NUM"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["ROLL_MONTH"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["BJ_TYPE"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["OUTS_BILLET_FL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["OUTS_STL_PIPE_FL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP_ROLL_ALL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP_ROLL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["JGORD_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["JGL_REQ_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["DJBL_REQ_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["D_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["E_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["G_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["IF_ALLOW_ISSUE"].Hidden = true;
                    ultraTabControl1.Tabs[1].Visible = false;
                    ultraTabControl1.Tabs[2].Visible = false;
                    splitContainer2.Panel2Collapsed = true;
                    ctrlForQueryPORDERSTATUS.SelectedIndex = 1;
                    checkBoxAcceptNo.Checked = true;
                    ctrlForQueryPORDERSTATUS.Items.Remove(4);
                    ctrlForQueryPORDERSTATUS.Items.Remove(3);
                    ctrlForQueryPORDERSTATUS.Items.Remove(2);
                    ctrlForQueryPORDERSTATUS.Items.Remove(0);
                    #endregion
                    doQuery(GetQueryCondition());
                    break;
                case "@JGANDDJ":
                    #region
                    ultraGrid1.DisplayLayout.Bands[0].Columns["ROLL_MONTH"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP_JGX"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP_RCL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["BJ_TYPE"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["OUTS_BILLET_FL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["OUTS_STL_PIPE_FL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP_ROLL_ALL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP_ROLL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GRADECODE_ALL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GRADECODE"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["IF_ALLOW_ISSUE"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["D_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["E_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["G_IS_OK"].Hidden = true;
                    ultraTabControl1.Tabs[2].Visible = false;
                    ctrlForQueryPORDERSTATUS.SelectedIndex = 1;
                    ctrlForQueryPORDERSTATUS.Items.Remove(4);
                    ctrlForQueryPORDERSTATUS.Items.Remove(3);
                    ctrlForQueryPORDERSTATUS.Items.Remove(2);
                    ctrlForQueryPORDERSTATUS.Items.Remove(0);
                    checkBoxisGp.Visible = false;
                    #endregion
                    doQuery(GetQueryCondition());
                    break;
                case "@RCL":
                    #region
                    ultraGrid1.DisplayLayout.Bands[0].Columns["CODE_JG"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["BL_GROUP_NUM"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["ROLL_MONTH"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["BJ_TYPE"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["OUTS_BILLET_FL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["OUTS_STL_PIPE_FL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GRADECODE_ALL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GRADECODE"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP_ROLL_ALL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP_ROLL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["JGORD_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["JGL_REQ_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["DJBL_REQ_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["D_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["E_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["G_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["IF_ALLOW_ISSUE"].Hidden = true;
                    ultraTabControl1.Tabs[1].Visible = false;
                    ultraTabControl1.Tabs[2].Visible = false;
                    splitContainer2.Panel2Collapsed = true;
                    ctrlForQueryPORDERSTATUS.SelectedIndex = 1;
                    ctrlForQueryPORDERSTATUS.Items.Remove(4);
                    ctrlForQueryPORDERSTATUS.Items.Remove(3);
                    ctrlForQueryPORDERSTATUS.Items.Remove(2);
                    ctrlForQueryPORDERSTATUS.Items.Remove(0);
                    #endregion
                    doQuery(GetQueryCondition());
                    break;
                case "@JGX":
                    #region
                    ultraGrid1.DisplayLayout.Bands[0].Columns["CODE_JG"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["BL_GROUP_NUM"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["ROLL_MONTH"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["BJ_TYPE"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["OUTS_BILLET_FL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["OUTS_STL_PIPE_FL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GRADECODE_ALL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GRADECODE"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP_ROLL_ALL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP_ROLL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["JGORD_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["JGL_REQ_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["DJBL_REQ_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["D_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["E_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["F_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["IF_ALLOW_ISSUE"].Hidden = true;
                    ultraTabControl1.Tabs[1].Visible = false;
                    ultraTabControl1.Tabs[2].Visible = false;
                    splitContainer2.Panel2Collapsed = true;
                    ctrlForQueryPORDERSTATUS.SelectedIndex = 1;
                    ctrlForQueryPORDERSTATUS.Items.Remove(4);
                    ctrlForQueryPORDERSTATUS.Items.Remove(3);
                    ctrlForQueryPORDERSTATUS.Items.Remove(2);
                    ctrlForQueryPORDERSTATUS.Items.Remove(0);
                    #endregion
                    doQuery(GetQueryCondition());
                    break;
                case "@ACCEPT":
                    #region
                    ultraGrid1.DisplayLayout.Bands[0].Columns["CODE_JG"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["BL_GROUP_NUM"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["E_IN_MATERIAL_DESC"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["BJ_TYPE"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP_JGX"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP_RCL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["JGORD_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["JGL_REQ_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["DJBL_REQ_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["D_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["E_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["F_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["G_IS_OK"].Hidden = true;
                    ultraTabControl1.Tabs[1].Visible = false;
                    splitContainer2.Panel2Collapsed = true;
                    ctrlForQueryPORDERSTATUS.Items.Remove(4);
                    ctrlForQueryPORDERSTATUS.Items.Remove(3);
                    #endregion
                    doQuery(GetQueryCondition());
                    break;
                case "@CRAFTFILE":
                    #region
                    ultraGrid1.DisplayLayout.Bands[0].Columns["CODE_JG"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["BL_GROUP_NUM"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["ROLL_MONTH"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["BJ_TYPE"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["E_IN_MATERIAL_DESC"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP_JGX"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GRADECODE_ALL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GRADECODE"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP_RCL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP_ROLL_ALL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP_ROLL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["OUTS_BILLET_FL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["OUTS_STL_PIPE_FL"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["JGORD_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["JGL_REQ_IS_OK"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Columns["DJBL_REQ_IS_OK"].Hidden = true;
                    ultraTabControl1.SelectedTab = ultraTabControl1.Tabs[2];
                    splitContainer2.Panel2Collapsed = true;
                    ctrlForQueryPORDERSTATUS.SelectedIndex = 1;
                    checkBoxAcceptNo.Checked = true;
                    checkBoxNotCraft.Checked = true;
                    checkBoxAcceptNoexport.Checked = false;
                    checkBoxForReqPORDERSTATUS.Enabled = false;
                    ctrlForQueryPORDERSTATUS.Enabled = false;
                    ultraTabControl1.Tabs[1].Visible = false;
                    #endregion
                    break;
                case "@PAYDOWN":
                    setPaydown();
                    break;
                case "@PAYDOWN1":
                    setPaydown();
                    break;
                case "@PAYDOWN2":
                    setPaydown();
                    break;
                case "@PAYDOWN3":
                    setPaydown();
                    break;
                case "@FinishSc":
                    ultraButtonRcl.Visible = false;
                    ctrlForQueryPORDERSTATUS.SelectedIndex = 1;
                    ctrlForQueryPORDERSTATUS.Items.Remove(5);
                    ctrlForQueryPORDERSTATUS.Items.Remove(0);
                    checkBoxForReqPORDERSTATUS.Enabled = true;
                    ultraTabControl1.Tabs[1].Visible = false;
                    checkBoxAcpStatus.Checked = true;
                    ultraComboEditAcpStatus.SelectedIndex = 3;
                    checkBoxAcceptNoexport.Checked = false;
                    splitContainer2.Panel2Collapsed = true;
                    break;
                default:
                    doQuery(GetQueryCondition());
                    break;

            }

        }

        /// <summary>
        /// 设置缴库完成确认界面
        /// </summary>
        private void setPaydown()
        {
            ultraGrid1.DisplayLayout.Bands[0].Columns["CODE_JG"].Hidden = true;
            ultraGrid1.DisplayLayout.Bands[0].Columns["BL_GROUP_NUM"].Hidden = true;
            ultraGrid1.DisplayLayout.Bands[0].Columns["E_IN_MATERIAL_DESC"].Hidden = true;
            ultraGrid1.DisplayLayout.Bands[0].Columns["BJ_TYPE"].Hidden = true;
            ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP_JGX"].Hidden = true;
            ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP_RCL"].Hidden = true;
            ultraGrid1.DisplayLayout.Bands[0].Columns["JGORD_IS_OK"].Hidden = true;
            ultraGrid1.DisplayLayout.Bands[0].Columns["JGL_REQ_IS_OK"].Hidden = true;
            ultraGrid1.DisplayLayout.Bands[0].Columns["DJBL_REQ_IS_OK"].Hidden = true;
            ultraGrid1.DisplayLayout.Bands[0].Columns["D_IS_OK"].Hidden = true;
            ultraGrid1.DisplayLayout.Bands[0].Columns["E_IS_OK"].Hidden = true;
            ultraGrid1.DisplayLayout.Bands[0].Columns["F_IS_OK"].Hidden = true;
            ultraGrid1.DisplayLayout.Bands[0].Columns["G_IS_OK"].Hidden = true;
            ultraTextEditorAcceptNo.Value = DateTime.Now.ToString("yyMM") + "X";
            ultraTabControl1.Tabs[1].Visible = false;
            ultraTabControl1.Tabs[2].Visible = false;
            splitContainer2.Panel2Collapsed = true;
            checkBoxForReqPORDERSTATUS.Enabled = false;
            ctrlForQueryPORDERSTATUS.SelectedIndex = 4;
            ctrlForQueryPORDERSTATUS.Items.Remove(3);
            ctrlForQueryPORDERSTATUS.Items.Remove(2);
            ctrlForQueryPORDERSTATUS.Items.Remove(1);
            ctrlForQueryPORDERSTATUS.Items.Remove(0);
        }

        /// <summary>
        /// 刷新加载数据
        /// </summary>
        private void RefresDate()
        {
            tableIndex = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryDesginIndex",
                new object[] { }, this.ob);
            DataTable tableBaseInfo = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryBaseinfoAll",
                new object[] { }, this.ob);

            DataTable tableBlbjtype = ServerHelper.GetData("com.steering.pss.plan.order.CoreOrderCraftInfo.getBjProcessC",
                new object[] { }, this.ob);
            DataTable tableBlPline = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryBlZgPline",
                new object[] { }, this.ob);

            DataTable tableGrade = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryBaseGrade",
                new object[] { }, this.ob);

            ValueList vlistSteel1 = PlanComm.GeneralValuelist(ref tableBlbjtype, "PROCESS_DESC_C", "PROCESS_DESC_C");
            vlistSteel1.ValueListItems.Insert(0, "/", "/");
            ultraGrid3.DisplayLayout.Bands[0].Columns["BJ_TYPE"].ValueList = vlistSteel1;
            ValueList vlistSteel2 = PlanComm.GeneralValuelist(ref tableBlbjtype, "PROCESS_DESC_C", "PROCESS_DESC_C");
            vlistSteel2.ValueListItems.Insert(0, "/", "/");
            ultraGrid6.DisplayLayout.Bands[0].Columns["BJ_TYPE"].ValueList = vlistSteel2;

            ultraGrid3.DisplayLayout.Bands[0].Columns["GROUP_ROLL"].ValueList
                = PlanComm.GeneralValuelist(ref tableBlPline, "PLINE_CODE", "PLINE_NAME");
            ultraGrid6.DisplayLayout.Bands[0].Columns["GROUP_ROLL"].ValueList 
                = PlanComm.GeneralValuelist(ref tableBlPline, "PLINE_CODE", "PLINE_NAME");
            ultraGrid3.DisplayLayout.Bands[0].Columns["GRADECODE"].ValueList
                = PlanComm.GeneralValuelist(ref tableGrade, "GRADECODE", "GRADENAME");
            ultraGrid6.DisplayLayout.Bands[0].Columns["GRADECODE"].ValueList
                = PlanComm.GeneralValuelist(ref tableGrade, "GRADECODE", "GRADENAME");

            ultraGrid1.DisplayLayout.Bands[0].Columns["GRADECODE"].ValueList
                = PlanComm.GeneralValuelist(ref tableGrade, "GRADECODE", "GRADENAME");

            if (tableBaseInfo != null)
            {
                //热处理组
                tableBaseInfo.DefaultView.RowFilter = "SORTCODE='2005'";
                DataTable dtGroupRCL = tableBaseInfo.DefaultView.ToTable();
                if (dtGroupRCL != null && dtGroupRCL.Rows.Count > 0)
                {
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP_RCL"].ValueList
                        = PlanComm.GeneralValuelist(ref dtGroupRCL, "BASECODE", "BASENAME");
                    ValueList vlistS1 = PlanComm.GeneralValuelist(ref dtGroupRCL, "BASECODE", "BASENAME");
                    vlistS1.ValueListItems.Insert(0, "/", "/");
                    ultraGrid3.DisplayLayout.Bands[0].Columns["GROUP_RCL"].ValueList = vlistS1;
                    ValueList vlistS2 = PlanComm.GeneralValuelist(ref dtGroupRCL, "BASECODE", "BASENAME");
                    vlistS2.ValueListItems.Insert(0, "/", "/");
                    ultraGrid6.DisplayLayout.Bands[0].Columns["GROUP_RCL"].ValueList = vlistS2;
                }

                //加工组
                tableBaseInfo.DefaultView.RowFilter = "SORTCODE='2004'";
                DataTable dtGroupJGX = tableBaseInfo.DefaultView.ToTable();
                if (dtGroupJGX != null && dtGroupJGX.Rows.Count > 0)
                {
                    ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP_JGX"].ValueList
                        = PlanComm.GeneralValuelist(ref dtGroupJGX, "BASECODE", "BASENAME");
                }

                ///外购坯
                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");
                    ultraGrid1.DisplayLayout.Bands[0].Columns["OUTS_BILLET_FL"].ValueList = vlistSteel;
                }

                ///监制要求
                tableBaseInfo.DefaultView.RowFilter = "SORTCODE='1222'";
                DataTable dtPrdcr = tableBaseInfo.DefaultView.ToTable();
                if (dtPrdcr != null && dtPrdcr.Rows.Count > 0)
                {
                    ValueList vlistSteel = PlanComm.GeneralValuelist(ref dtPrdcr, "BASECODE", "BASENAME");
                    ultraGrid1.DisplayLayout.Bands[0].Columns["MONITORDEMAND"].ValueList = vlistSteel;
                }
                
                ///合同紧急度
                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");
                    ultraGrid1.DisplayLayout.Bands[0].Columns["PRIORITY"].ValueList = vlistSteel;
                }
            }

            if (tableBlPline != null)
            {
                //轧管机组
                ultraGrid1.DisplayLayout.Bands[0].Columns["GROUP_ROLL"].ValueList
                    = PlanComm.GeneralValuelist(ref tableBlPline, "PLINE_CODE", "PLINE_NAME");
            }
        }

        /// <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 dPrc = "";       //查询经过轧管工序
            string ePrc = "";       //查询经过镦拔扩工序
            string fPrc = "";       //查询经过热处理工序
            string gPrc = "";       //查询经过加工工序
            string jgOrdj = "";     //查询接箍短节
            string orderFrom = ""; //合同来源

            switch (this.CustomInfo.ToString().Trim())
            {
                case "@BJ":
                    ePrc = "1";
                    break;
                case "@JGANDDJ":
                    jgOrdj = "1";
                    break;
                case "@ZG":
                    dPrc = "1";
                    break;
                case "@RCL":
                    fPrc = "1";
                    break;
                case "@JGX":
                    gPrc = "1";
                    break;
                case "@PAYDOWN1":       //销售公司
                    orderFrom = "100101";
                    break;
                case "@PAYDOWN2":       //国贸公司
                    orderFrom = "100102";
                    break;
                case "@PAYDOWN3":       //钢贸公司
                    orderFrom = "100103";
                    break;
            }

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

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

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

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

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

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

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

            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(dPrc);
            ary.Add(dPrc);
            ary.Add(ePrc);
            ary.Add(ePrc);
            ary.Add(fPrc);
            ary.Add(fPrc);
            ary.Add(gPrc);
            ary.Add(gPrc);
            ary.Add(jgOrdj);
            ary.Add(jgOrdj);
            ary.Add(jgOrdj);
            ary.Add(jgOrdj);
            ary.Add(orderFrom);
            ary.Add(orderFrom);
            return ary;
        }

        /// <summary>
        /// 根据信息栏查询
        /// </summary>
        /// <param name="ary">查询条件信息</param>
        private void doQuery(ArrayList ary)
        {
            if (ary != null)
            {
                try
                {
                    DataTable dt1 = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.querySaleOrder",
                        new object[] { ary }, this.ob);
                    GridHelper.CopyDataToDatatable(dt1, dataTable1, true);

                    if (this.CustomInfo.ToString().Trim().Equals("")
                        || this.CustomInfo.ToString().Trim().Equals("@JGANDDJ"))
                    {
                        DataTable dt2 = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryJgOrder",
                            new object[] { ary }, this.ob);
                        GridHelper.CopyDataToDatatable(dt2, dataTable2, true);

                        DataTable dt3 = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryDjBlNeed",
                            new object[] { ary }, this.ob);
                        GridHelper.CopyDataToDatatable(dt3, dataTable3, true);
                    }

                    #region ultraGrid1表格查询
                    foreach (UltraGridRow uRow in ultraGrid1.Rows)
                    {
                        string desgin_key =uRow.Cells["DESGIN_KEY"].Value.ToString();
                        //查询可选制程。
                        if (tableIndex != null && tableIndex.Rows.Count > 0)
                        {
                            tableIndex.DefaultView.RowFilter = "DESGIN_KEY='" + desgin_key + "'";
                            DataTable dtIndex = tableIndex.DefaultView.ToTable();
                            if (dtIndex != null && dtIndex.Rows.Count > 0)
                            {
                                ValueList vlistSteel = PlanComm.GeneralValuelist(ref dtIndex, "MSC_PLINE", "WHOLE_BACKLOG_DESC");
                                uRow.Cells["INDEX_SEQ"].ValueList = vlistSteel;
                            }
                        }

                        if (!uRow.Cells["PORDERSTATUS"].Value.ToString().Equals("已接收"))
                        {
                            #region 已下发合同设置不可编辑
                            uRow.Cells["INDEX_SEQ"].Activation = Activation.ActivateOnly;
                            uRow.Cells["OUTS_BILLET_FL"].Activation = Activation.ActivateOnly;
                            uRow.Cells["GRADECODE"].Activation = Activation.ActivateOnly;
                            uRow.Cells["GROUP_ROLL"].Activation = Activation.ActivateOnly;
                            uRow.Cells["GROUP_JGX"].Activation = Activation.ActivateOnly;
                            uRow.Cells["GROUP_RCL"].Activation = Activation.ActivateOnly;
                            #endregion
                        }
                        if (uRow.Cells["GROUP_JGX"].Value.ToString().Equals("/"))
                        {
                            uRow.Cells["GROUP_JGX"].Activation = Activation.ActivateOnly;
                        }
                        if (uRow.Cells["GROUP_RCL"].Value.ToString().Equals("/"))
                        {
                            uRow.Cells["GROUP_RCL"].Activation = Activation.ActivateOnly;
                        }
                    }
                    #endregion

                    ///设置ultraGrid1单元格不可编辑
                    string[] strColum1 = new string[] { "CHECK", "OUTS_BILLET_FL", "ROLL_MONTH","PRIORITY","PRIORITY_MEMO",
                        "GROUP_ROLL", "INDEX_SEQ", "GROUP_JGX", "GROUP_RCL", "MEMO" };
                    PlanComm.setGridActivation(ultraGrid1.DisplayLayout.Bands[0], strColum1);
                    if (!this.CustomInfo.ToString().Trim().Equals("")
                        && !this.CustomInfo.ToString().Trim().Equals("@CRAFTFILE"))
                    {
                        ultraGrid1.DisplayLayout.Bands[0].Columns["INDEX_SEQ"].CellActivation = Activation.ActivateOnly;
                    }

                    PlanComm.setGridDigitalCol(ultraGrid1.DisplayLayout.Bands[0], 7, 3,
                        "ORDER_QTY", "ORDERWEIGHT", "PLANWEIGHT", "PAYDOWNWEIGHT",
                        "PLAN_QTY", "EXTRA_LEN_TOT_WT", "REQ_QTYSUM", "CONFIRM_WT_SUM");
                    PlanComm.setGridDigitalCol(ultraGrid1.DisplayLayout.Bands[0], 7, 2,
                        "TOTLENGTH", "TOTLENGTH_M");
                    PlanComm.setGridDigitalCol(ultraGrid1.DisplayLayout.Bands[0], 5, 2,
                        "OUTDIAMETER", "WALLTHICK", "LENGTHMAX", "LENGTHMIN", "AIMLENGTH",
                        "AIMWALLTHICK_ZG", "HEIGHT_NK_MIN", "HEIGHT_NK_MAX", "LEN_TOEND_MIN",
                        "LEN_TOEND_MAX", "LENGTH_JG");
                    PlanComm.setGridDigitalCol(ultraGrid1.DisplayLayout.Bands[0], 5, 0,
                         "PLAN_NUM", "PAYDOWN_NUM");

                    ///设置ultraGrid2单元格不可编辑
                    PlanComm.setGridActivation(ultraGrid2.DisplayLayout.Bands[0], "CHECK");
                    PlanComm.setGridDigitalColMaxInput(ultraGrid2.DisplayLayout.Bands[0], 5, 2,
                         "SINGLEWEIGHT", "OUTDIAMETER", "WALLTHICK", "AIMWALLTHICK", "AIMLENGTH");
                    PlanComm.setGridDigitalColMaxInput(ultraGrid2.DisplayLayout.Bands[0], 5, 3,
                         "ORDERWEIGHT", "MATCHWEIGHT", "BUYPLANWEIGHT");
                    PlanComm.setGridDigitalColMaxInput(ultraGrid2.DisplayLayout.Bands[0], 5, 0,
                         "ORDERNUM", "MATCHNUM", "BUYPLANNUM", "JGWT_BLREQ");

                    #region ultraGrid3表格查询
                    foreach (UltraGridRow uRow in ultraGrid3.Rows)
                    {
                        if (!uRow.Cells["PLANSTATUS"].Value.ToString().Equals("待处理"))
                        {
                            uRow.Cells["JGBL_REQ_WEIGHT"].Activation = Activation.ActivateOnly;
                            uRow.Cells["MATCHWEIGHT"].Activation = Activation.ActivateOnly;
                            uRow.Cells["INDEX_SEQ"].Activation = Activation.ActivateOnly;
                        }
                    }
                    #endregion

                    ///设置ultraGrid3单元格不可编辑
                    string[] strColum3 = new string[] { "CHECK", "JGBL_REQ_WEIGHT", "MATCHWEIGHT",
                        "GRADECODE", "GROUP_RCL","DIMATER_YLG","HEIGHT_YLG", "BJ_TYPE", "GROUP_ROLL" };
                    PlanComm.setGridActivation(ultraGrid3.DisplayLayout.Bands[0], strColum3);
                    PlanComm.setGridDigitalColMaxInput(ultraGrid3.DisplayLayout.Bands[0], 5, 2,
                         "OUTDIAMETER", "WALLTHICK", "AIMWALLTHICK", "LENGTHMAX", "LENGTHMIN", "AIMLENGTH");
                    PlanComm.setGridDigitalColMaxInput(ultraGrid3.DisplayLayout.Bands[0], 5, 3,
                         "SINGLEWEIGHT", "JGBL_REQ_WEIGHT", "MATCHWEIGHT");
                    PlanComm.setGridDigitalColMaxInput(ultraGrid3.DisplayLayout.Bands[0], 5, 0,
                         "JGBL_REQ_NUM", "MATCHNUM");
                }
                catch (Exception ex)
                {
                    if (ex is MESException)
                    {
                        MessageBox.Show(((MESException)ex).ExceptionInfo);
                    }
                    else
                    {
                        MessageBox.Show(ex.Message);
                    }
                }
            }
        }

        /// <summary>
        /// 查询销售合同对应接箍和备料合同
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid1_BeforeRowActivate(object sender, RowEventArgs e)
        {
            #region 查询接箍短节
            string orderNo = e.Row.Cells["ORDER_NO"].Value.ToString();
            string orderSeq = e.Row.Cells["ORDER_SEQ"].Value.ToString();
            string deliveryNo = e.Row.Cells["DELIVERY_NO"].Value.ToString();

            foreach (UltraGridRow uRow in ultraGrid2.Rows)
            {
                if (uRow.Cells["ORDER_NO"].Value.ToString().Equals(orderNo)
                    && uRow.Cells["ORDER_SEQ"].Value.ToString().Equals(orderSeq)
                    && uRow.Cells["DELIVERY_NO"].Value.ToString().Equals(deliveryNo))
                {
                    ultraGrid2.ActiveRow = uRow;
                    uRow.Appearance.ForeColor = System.Drawing.Color.DarkBlue;
                }
                else
                {
                    uRow.Appearance.ForeColor = System.Drawing.Color.Black;
                }
            }

            foreach (UltraGridRow uRow in ultraGrid3.Rows)
            {
                if (uRow.Cells["ORDER_NO"].Value.ToString().Equals(orderNo)
                    && uRow.Cells["ORDER_SEQ"].Value.ToString().Equals(orderSeq)
                    && uRow.Cells["DELIVERY_NO"].Value.ToString().Equals(deliveryNo))
                {
                    ultraGrid3.ActiveRow = uRow;
                    uRow.Appearance.ForeColor = System.Drawing.Color.DarkBlue;
                }
                else
                {
                    uRow.Appearance.ForeColor = System.Drawing.Color.Black;
                }
            }
            #endregion

            if (e.Row.Cells["PORDERSTATUS"].Value.ToString().Equals("已接收"))
            {
                setOrderBominf(e.Row);
            }
        }

        /// <summary>
        /// 接箍料编制查询
        /// </summary>
        private void QueryJGl()
        {
            try
            {
                DataTable dtJg = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryJgDeal", new object[] { }, this.ob);
                GridHelper.CopyDataToDatatable(dtJg, dataTable5, true);

                ///设置grid不可编辑
                PlanComm.setGridActivation(ultraGrid5.DisplayLayout.Bands[0], "CHECK", "MATCHNUM", "BUYCHOOSE");
                PlanComm.setGridDigitalColMaxInput(ultraGrid5.DisplayLayout.Bands[0], 5, 2,
                     "OUTDIAMETER", "WALLTHICK", "AIMWALLTHICK", "AIMLENGTH");
                PlanComm.setGridDigitalColMaxInput(ultraGrid5.DisplayLayout.Bands[0], 5, 3,
                     "SINGLEWEIGHT", "ORDERWEIGHT", "MATCHWEIGHT");
                PlanComm.setGridDigitalColMaxInput(ultraGrid5.DisplayLayout.Bands[0], 5, 0,
                     "ORDERNUM", "MATCHNUM", "JGWT_BLREQ");

                DataTable dtEdit = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryJgDealedit",
                    new object[] { }, this.ob);
                GridHelper.CopyDataToDatatable(dtEdit, dataTable7, true);
                foreach (UltraGridRow uRow in ultraGrid7.Rows)
                {
                    uRow.Cells["SINGLE_ADDLEN"].Value = 10;
                }

                ///设置grid不可编辑
                PlanComm.setGridActivation(ultraGrid7.DisplayLayout.Bands[0], "CHECK", "NUM_JG", "SINGLE_ADDLEN");
                foreach (UltraGridRow uRow in ultraGrid7.Rows)
                {
                    uRow.Cells["NUM_JG"].Activation = Activation.ActivateOnly;
                }

                DataTable dtJgl = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryJgBlNeed",
                    new object[] { }, this.ob);
                GridHelper.CopyDataToDatatable(dtJgl, dataTable6, true);

                ///设置grid不可编辑
                string[] strColumn = new string[] { "CHECK", "MATCHWEIGHT", "GRADECODE", "GROUP_RCL",
                    "DIMATER_YLG","HEIGHT_YLG", "BJ_TYPE", "GROUP_ROLL", "INDEX_SEQ" };
                PlanComm.setGridActivation(ultraGrid6.DisplayLayout.Bands[0], strColumn);
                PlanComm.setGridDigitalColMaxInput(ultraGrid6.DisplayLayout.Bands[0], 5, 2,
                     "OUTDIAMETER", "WALLTHICK", "AIMWALLTHICK", "LENGTHMAX", "LENGTHMIN", "AIMLENGTH");
                PlanComm.setGridDigitalColMaxInput(ultraGrid6.DisplayLayout.Bands[0], 5, 3,
                     "SINGLEWEIGHT", "JGBL_REQ_WEIGHT", "MATCHWEIGHT");
                PlanComm.setGridDigitalColMaxInput(ultraGrid6.DisplayLayout.Bands[0], 5, 0,
                     "JGBL_REQ_NUM", "MATCHNUM");

                dataTable4.Clear();
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }

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

                WaitFromOpen();
                foreach (UltraGridRow uRow in checkRows)
                {
                    ///查询合同状态
                    ArrayList status = new ArrayList();
                    status.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.querySaleStatus",
                        new object[] { status }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        break;
                    }
                    if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().CompareTo("0") > 0)
                    {
                        ArrayList param = new ArrayList();
                        ArrayList paramLine = new ArrayList();
                        param.Add("5");
                        param.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());

                        paramLine.Add("12020602");
                        paramLine.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());

                        list.Add(param);
                        listLine.Add(paramLine);
                    }
                }

                if (list.Count <= 0)
                {
                    WaitFromColse();
                    return;
                }

                int succed = ServerHelper.SetData("com.steering.pss.plan.order.CoreOrderDesignBom.setModifySale",
                    new object[] { list, listLine }, this.ob);
                WaitFromColse();
                if (succed > 0)
                {
                    MessageUtil.ShowTips("修改成功！");
                }
                else
                {
                    MessageUtil.ShowTips("修改失败！");
                }
            }
            catch (Exception ex)
            {
                WaitFromColse();
                MessageBox.Show(ex.Message);
            }
            doQuery(GetQueryCondition());
        }

        /// <summary>
        /// 补量申请
        /// </summary>
        private void DoRepRequest()
        {
            double weightM = 0;
            UltraGridRow ugr = ultraGrid1.ActiveRow;
            if (ugr == null)
            {
                return;
            }

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

            ///查询合同状态
            ArrayList status = new ArrayList();
            status.Add(ugr.Cells["ORD_LN_DLY_PK"].Value.ToString());
            DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.querySaleStatus",
                new object[] { status }, this.ob);
            if (dtStatus == null || dtStatus.Rows.Count <= 0)
            {
                return;
            }
            if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("4"))
            {
                PlnSaleorderRNumEntity reqEntity = new PlnSaleorderRNumEntity();
                reqEntity.OrdLnDlyPk = ugr.Cells["ORD_LN_DLY_PK"].Value.ToString();
                reqEntity.OrderNo = ugr.Cells["ORDER_NO"].Value.ToString();
                reqEntity.OrderSeq = ugr.Cells["ORDER_SEQ"].Value.ToString();
                reqEntity.DeliveryNo = ugr.Cells["DELIVERY_NO"].Value.ToString();
                reqEntity.Produccode = ugr.Cells["PRODUCCODE"].Value.ToString();
                reqEntity.Producname = ugr.Cells["PRODUCNAME"].Value.ToString();
                reqEntity.StdCode = ugr.Cells["STD_CODE"].Value.ToString();
                reqEntity.StdName = ugr.Cells["STD_NAME"].Value.ToString();
                reqEntity.Steelcode = ugr.Cells["STEELCODE"].Value.ToString();
                reqEntity.Steelname = ugr.Cells["STEELNAME"].Value.ToString();
                reqEntity.SpecCode = ugr.Cells["SPEC_CODE"].Value.ToString();
                reqEntity.SpecName = ugr.Cells["SPEC_NAME"].Value.ToString();
                reqEntity.ModelCode = ugr.Cells["MODEL_CODE"].Value.ToString();
                reqEntity.ModelDesc = ugr.Cells["MODEL_DESC"].Value.ToString();
                reqEntity.Outdiameter = ugr.Cells["OUTDIAMETER"].Value.ToString();
                reqEntity.Wallthick = ugr.Cells["WALLTHICK"].Value.ToString();
                reqEntity.Lengthdisc = ugr.Cells["LENGTHDISC"].Value.ToString();
                reqEntity.OrderUnit = ugr.Cells["ORDER_UNIT"].Value.ToString();

                double.TryParse(ugr.Cells["WEIGHT_PER_M"].Value.ToString(), out weightM);
                FrmReqRequest reqRequest = new FrmReqRequest(this.ob, reqEntity,
                    Convert.ToDouble(ugr.Cells["ORDER_QTY"].Value), weightM);
                reqRequest.ShowDialog();
            }
            else
            {
                MessageUtil.ShowTips("只有在生产完成的合同才允许补量！");
                return;
            }
        }

        /// <summary>
        /// 合同置为生产完成
        /// </summary>
        private void doFinishSc()
        {
            try
            {
                ultraGrid1.UpdateData();
                ArrayList list = new ArrayList();
                ArrayList listLine = new ArrayList();
                IQueryable<UltraGridRow> checkRows = ultraGrid1.Rows.AsQueryable().Where(" CHECK = 'True' ");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选合同！");
                    return;
                }

                WaitFromOpen();
                foreach (UltraGridRow uRow in checkRows)
                {
                    ///查询合同状态
                    ArrayList status = new ArrayList();
                    status.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.querySaleStatus",
                        new object[] { status }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        break;
                    }
                    if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().CompareTo("0") > 0
                        && dtStatus.Rows[0]["PORDERSTATUS"].ToString().CompareTo("5") < 0)
                    {
                        ArrayList param = new ArrayList();
                        ArrayList paramLine = new ArrayList();
                        param.Add("4");
                        param.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());

                        paramLine.Add("12020502");
                        paramLine.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                        list.Add(param);
                        listLine.Add(paramLine);
                    }
                }

                if (list.Count <= 0)
                {
                    WaitFromColse();
                    return;
                }

                int succed = ServerHelper.SetData("com.steering.pss.plan.order.CoreOrderDesignBom.setModifySale",
                    new object[] { list, listLine }, this.ob);
                WaitFromColse();
                if (succed > 0)
                {
                    MessageUtil.ShowTips("修改成功！");
                }
                else
                {
                    MessageUtil.ShowTips("修改失败！");
                }
            }
            catch(Exception ex)
            {
                WaitFromColse();
                MessageBox.Show(ex.Message);
            }
            doQuery(GetQueryCondition());
        }

        /// <summary>
        /// 导入
        /// </summary>
        private void DoImport()
        {
            try
            {
                OpenFileDialog dialog = new OpenFileDialog();
                if (dialog.ShowDialog() == DialogResult.OK)
                {
                    FrmOrderCraftImport import = new FrmOrderCraftImport(this.ob);
                    import.ModelPatch = dialog.FileName;
                    import.ShowDialog();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            QueryIssued();
        }

        /// <summary>
        /// 查询导出界面信息
        /// </summary>
        private void QueryIssued()
        {
            try
            {
                ArrayList param = new ArrayList();
                string status = "";
                String notCraft;
                string strAcceptNo = "";//接收批次号
                string strOrderNo = "";  //合同号
                string strGroupType = "";  //品种类型（管,非管）
                string strDateForm = "1000/01/01";  //交货结束日期从，默认最小日期
                string strDateTo = "9999/12/31";   //交货结束日期到，默认最大日期
                if (this.checkBoxAcceptNoexport.Checked)
                {
                    //接收批次号
                    strAcceptNo = this.ultraTextAcceptNo.Text.Trim();
                }
                if (this.checkBoxORDER_NOexpor.Checked)
                {
                    //合同号
                    strOrderNo = this.ultraTextORDER_NO.Text.Trim();
                }
                if (this.checkBoxGroupTypeexpor.Checked)
                {
                    //品种类型（管,非管）
                    strGroupType = this.ultraComboGroupType.SelectedIndex.ToString();
                }
                if (this.checkBoxDELVRY_EDATEexport.Checked)
                {
                    //接收日期
                    strDateForm = this.ultraDateTimeDELVRY_EDATEFrom.DateTime.ToString("yyyy/MM/dd");
                    strDateTo = this.ultraDateTimeDELVRY_EDATETo.DateTime.ToString("yyyy/MM/dd");
                }

                if (this.checkBoxImport.Checked)
                {
                    //查询外部导入系统的合同
                    strGroupType = "-1";
                }

                if (checkBoxAcpStatus.Checked)
                {
                    status = ultraComboEditAcpStatus.Value.ToString();
                }
                if (checkBoxNotCraft.Checked)
                {
                    notCraft = "1";
                }
                else
                {
                    notCraft = "";
                }

                param.Add(strGroupType);
                param.Add(strAcceptNo);
                param.Add(strOrderNo);
                param.Add(strDateForm);
                param.Add(strDateTo);
                param.Add(status);

                DataTable dt1 = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryExportSaleOrder",
                        new object[] { param, notCraft }, this.ob);
                GridHelper.CopyDataToDatatable(dt1, dataTable11, true);

                ///设置grid不可编辑
                PlanComm.setGridActivation(ultraGrid8.DisplayLayout.Bands[0]);
                PlanComm.setGridDigitalCol(ultraGrid8.DisplayLayout.Bands[0], 7, 3,
                    "ORDER_QTY", "ORDERWEIGHT", "CONFIRM_WT_SUM");
                PlanComm.setGridDigitalCol(ultraGrid8.DisplayLayout.Bands[0], 7, 2,
                    "TOTLENGTH");
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }

        /// <summary>
        /// 导出excl
        /// </summary>
        private void ExportSale()
        {
            try
            {
                int rowCount = this.ultraGrid8.Rows.Count;
                int colCount = this.ultraGrid8.DisplayLayout.Bands[0].Columns.Count - 6;
                object[,] arr = new object[rowCount, colCount];
                
                for (int j = 0; j < rowCount; j++)
                {
                    for (int i = 0; i < colCount; i++)
                    {
                        string output = ultraGrid8.Rows[j].Cells[i].Value.ToString();

                        if (ultraGrid8.DisplayLayout.Bands[0].Columns[i].Key.Equals("GROUP_ROLL"))
                        {
                            //产线
                            int plineCode = 0;
                            output = output.Replace("机组", "");
                            if (int.TryParse(output, out plineCode))
                            {
                                output = "'" + plineCode.ToString();
                            }
                        }

                        if (ultraGrid8.DisplayLayout.Bands[0].Columns[i].Key.Equals("STEELNAME"))
                        {
                            //钢级
                            double grade = 0;
                            if (double.TryParse(output, out grade))
                            {
                                output = "'" + output;
                            }
                        }

                        if (ultraGrid8.DisplayLayout.Bands[0].Columns[i].Key.Equals("ROLL_MONTH"))
                        {
                            //轧制月份
                            DateTime dt = new DateTime();
                            if (DateTime.TryParse(output, out dt)) 
                            {
                                output = "'" + dt.ToString("yyyyMM");
                            }
                        }
                        arr[j, i] = output;
                    }
                }

                string path = System.Windows.Forms.Application.StartupPath + "\\model";
                string tempExcel = path + "\\FrmSaleOrdermodel.xls";
                string outPutExcl = "销售合同" + DateTime.Now.ToString("yyyyMMdd");
                if (!System.IO.File.Exists(tempExcel))//检察模板是否存在
                {
                    MessageBox.Show(this, "未找到报表模板！");
                    return;
                }

                if (ultraGrid8.Rows.Count == 0) return;
                if (outPutExcl.Length == 0) outPutExcl = "未命名";
                SaveFileDialog dlg = new SaveFileDialog();
                dlg.Title = "保存";
                dlg.OverwritePrompt = true;
                dlg.Filter = "Excel文件(*.xls)|*.xls";
                dlg.AddExtension = true;
                dlg.FileName = outPutExcl;
                if (dlg.ShowDialog() == DialogResult.OK)
                {
                    outPutExcl = dlg.FileName;
                    WaitFromOpen();
                    ExcelHelper excelport = new ExcelHelper(tempExcel, outPutExcl);
                    if (excelport.ArrayToExcel(arr, 2, 1, "Sheet"))
                    {
                        WaitFromColse();
                        if (MessageBox.Show("数据导出成功！\n需要打开所导出文件吗？", "提示",
                        MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                        {
                            ProcessStartInfo p = new ProcessStartInfo(outPutExcl);
                            p.WorkingDirectory = Path.GetDirectoryName(outPutExcl);
                            Process.Start(p);
                        }
                    }
                    else
                    {
                        WaitFromColse();
                        MessageBox.Show("数据导出失败!");
                        return;
                    }
                }
            }
            catch (Exception ex)
            {
                WaitFromColse();
                MessageBox.Show(ex.Message);
            }
        }

        /// <summary>
        /// 备料导出
        /// </summary>
        private void doExportBl(string bjType)
        {
            string url = "";
            //string url = "http://172.16.2.130:8085/WebReport/ReportServer?reportlet=RepPlnSaleOrder.cpt";
            if (bjType.Equals("JGL"))
            {
                url = "http://localhost:8075/WebReport/ReportServer?reportlet=ReqPlnBlJgOrder.cpt";
            }
            else
            {
                url = "http://localhost:8075/WebReport/ReportServer?reportlet=ReqPlnBlDjOrder.cpt";
            }
            FrmOutExcel outPut = new FrmOutExcel(url);
            outPut.ShowDialog();
        }

        /// <summary>
        /// 更新短节备料信息
        /// </summary>
        private void UpdateDjBl(UltraGrid ugrid)
        {
            try
            {
                ugrid.UpdateData();
                IQueryable<UltraGridRow> checkRows = ugrid.Rows.AsQueryable().Where(" CHECK = 'True'");
                ArrayList list = new ArrayList();
                ///如果没有勾选待处理的条目，提示。
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选要保存的备料！");
                    return;
                }
                foreach (UltraGridRow uRow in checkRows)
                {
                    ArrayList parms = new ArrayList();
                    parms.Add(uRow.Cells["JGBL_REQ_WEIGHT"].Value.ToString());
                    parms.Add(uRow.Cells["JGBL_REQ_NUM"].Value.ToString());
                    parms.Add(uRow.Cells["MATCHWEIGHT"].Value.ToString());
                    parms.Add(uRow.Cells["MATCHNUM"].Value.ToString());
                    parms.Add(uRow.Cells["GRADECODE"].Value.ToString());
                    parms.Add(uRow.Cells["REQ_BL_ID"].Value.ToString());
                    list.Add(parms);
                }

                int suceed = ServerHelper.SetData("com.steering.pss.plan.order.CoreSaleOrderOP.updateDjblRcl",
                    new object[] { list }, this.ob);
                if (suceed > 0)
                {
                    MessageUtil.ShowTips("保存成功！");
                }
                else
                {
                    MessageUtil.ShowTips("保存失败！");
                }
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            if (ugrid != ultraGrid3)
            {
                QueryJGl();
            }
            else
            {
                doQuery(GetQueryCondition());
            }
        }

        /// <summary>
        /// 保存接箍合同利库量和外购量信息
        /// </summary>
        private void UpdateJgOrder()
        {
            try
            {
                ArrayList list = new ArrayList();
                bool isChecked = false;
                foreach (UltraGridRow uRow in ultraGrid5.Rows)
                {
                    if (Convert.ToBoolean(uRow.Cells["CHECK"].Text))
                    {
                        ArrayList parms = new ArrayList();
                        isChecked = true;
                        parms.Add(uRow.Cells["MATCHWEIGHT"].Value.ToString());
                        parms.Add(uRow.Cells["MATCHNUM"].Value.ToString());
                        if (Convert.ToBoolean(uRow.Cells["BUYCHOOSE"].Text))
                        {
                            int buyplannum = Convert.ToInt32(uRow.Cells["ORDERNUM"].Value) -
                                Convert.ToInt32(uRow.Cells["MATCHNUM"].Value) -
                                Convert.ToInt32(uRow.Cells["JGWT_BLREQ"].Value);
                            double buyplanweight = buyplannum * Convert.ToDouble(uRow.Cells["SINGLEWEIGHT"].Value) / 1000;
                            parms.Add("1");//有无外购计划(1-有，0-无)
                            parms.Add(buyplanweight.ToString());
                            parms.Add(buyplannum);
                        }
                        else
                        {
                            parms.Add("0");
                            parms.Add("0");
                            parms.Add("0");
                        }
                        parms.Add(uRow.Cells["JG_ORDERNO"].Value.ToString());
                        list.Add(parms);
                    }
                }

                ///如果没有勾选待处理的条目，提示。接箍合同
                if (!isChecked)
                {
                    MessageUtil.ShowTips("未勾选待要保存的接箍合同！");
                    return;
                }
                ServerHelper.SetData("com.steering.pss.plan.order.CoreSaleOrderOP.updateLkwgWeight", new object[] { list }, this.ob);
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            QueryJGl();
        }

        /// <summary>
        /// 查询产品码
        /// </summary>
        /// <param name="parms">备料品名、标准、钢级、标准类别</param>
        /// <returns>产品码</returns>
        public string QueryPsc(string producCode, string stdCode, string steelCode, string stdStyle)
        {
            try
            {
                ArrayList param = new ArrayList();
                param.Add(producCode);
                param.Add(stdCode);
                param.Add(steelCode);
                param.Add(stdStyle);
                param.Add(stdStyle);
                param.Add(stdStyle);
                DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryPsc",
                                new object[] { param }, this.ob);
                if (dt != null && dt.Rows.Count > 0)
                {
                    return dt.Rows[0]["PSC"].ToString();
                }
                else
                {
                    return "";
                }
            }
            catch
            {
                return "";
            }
        }

        /// <summary>
        /// 查询产品码与冶金规范对应关系\
        /// </summary>
        /// <param name="strPsc">产品码</param>
        /// <returns>冶金规范码</returns>
        public string QueryPscForMsc(string strPsc)
        {
            try
            {
                DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryPscForMsc",
                    new object[] { strPsc }, this.ob);
                if (dt != null && dt.Rows.Count > 0)
                {
                    return dt.Rows[0]["MSC"].ToString();
                }
                else
                {
                    return "";
                }
            }
            catch
            {
                return "";
            }
        }

        /// <summary>
        /// 根据备料冶金规范查找制程索引
        /// </summary>
        /// <param name="strMsc">冶金规范码</param>
        /// <returns>制程索引号集合</returns>
        private DataTable QueryBlIndex(string strMsc)
        {
            try
            {
                ArrayList parms = new ArrayList();
                parms.Add(strMsc);
                DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryMscIndex",
                    new object[] { parms }, this.ob);
                return dt;
            }
            catch
            {
                return null;
            }
        }

        /// <summary>
        /// 查询备料工序
        /// </summary>
        /// <param name="strMsc">冶金规范</param>
        /// <param name="msc_pline">全程产线</param>
        /// <returns>工序列表</returns>
        private DataTable QueryBlProcess(string strMsc, string msc_pline)
        {
            try
            {
                ArrayList parms = new ArrayList();
                parms.Add(strMsc);
                parms.Add(msc_pline);
                DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryBlProcess",
                    new object[] { parms }, this.ob);
                return dt;
            }
            catch
            {
                return null;
            }
        }

        /// <summary>
        /// 查询接箍码
        /// </summary>
        /// <param name="strDesgin_key">Design_Key</param>
        /// <returns>接箍码表</returns>
        private DataTable QueryJgCode(string strDesgin_key)
        {
            try
            {
                DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryJgCode",
                    new object[] { strDesgin_key }, this.ob);
                return dt;
            }
            catch
            {
                return null;
            }
        }

        /// <summary>
        /// 查询短节备料码
        /// </summary>
        /// <param name="strDesgin_key">desgin_key</param>
        /// <returns>短节备料码集合</returns>
        public DataTable QueryBlCode(string strDesgin_key)
        {
            try
            {
                DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryBlCode",
                    new object[] { strDesgin_key }, this.ob);
                return dt;
            }
            catch
            {
                return null;
            }
        }

        /// <summary>
        /// 查询一组短节备料码
        /// </summary>
        /// <param name="designKey">质量设计主键</param>
        /// <param name="gourpNum">备料组号</param>
        /// <returns></returns>
        private DataTable queryBlCodeByGp(string designKey, string gourpNum)
        {
            try
            {
                ArrayList param = new ArrayList();
                param.Add(designKey);
                param.Add(gourpNum);
                DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryBlCodeByGp",
                    new object[] { param }, this.ob);
                return dt;
            }
            catch
            {
                return null;
            }
        }

        /// <summay>
        /// 返回组合类型
        /// </summay>
        /// <param name="processSeq">desgin_key</param>
        /// <returns>组合类型编号</returns>
        private int MergeType(string strDesgin_key, string processSeq)
        {
            if (processSeq != "")
            {
                string endcode = processSeq.Substring(processSeq.Length - 1, 1);
                if (endcode.CompareTo("D") < 0)
                {
                    return 3;
                }
            }

            DataTable dtjg = QueryJgCode(strDesgin_key);
            DataTable dtBl = QueryBlCode(strDesgin_key);

            if (dtjg.Rows.Count > 0 && dtjg != null)
            {
                if (dtBl.Rows.Count > 0 && dtBl != null)
                {
                    return 2;
                }
                else
                {
                    return 1;
                }
            }
            return 0;
        }

        /// <summary>
        /// 查询品名基础表
        /// </summary>
        /// <param name="producode">品名代码</param>
        /// <returns></returns>
        private DataTable queryProducType(string producode)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryProducType", 
                new object[] { producode }, this.ob);
            return dt;
        }

        /// <summary>
        /// 查询合同附加要求
        /// </summary>
        /// <param name="askNo">附加要求码</param>
        private string queryAddAsk(string askNo,out string askStatus)
        {
            string addaskDesc = "";
            string strStatus = "";
            DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryAddAsk",
                new object[] { askNo }, this.ob);
            if (dt != null && dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    if (dt.Rows[i]["ADD_ASK_TYPE"].ToString().Equals("0"))
                    {
                        strStatus = strStatus + "√;";
                    }
                    else
                    {
                        strStatus = strStatus + "×;";
                    }
                    addaskDesc = addaskDesc + dt.Rows[i]["ASKDESC"].ToString() + "\n";
                }
                addaskDesc = addaskDesc.Remove(addaskDesc.LastIndexOf("\n"));
                strStatus = strStatus.Remove(strStatus.LastIndexOf(';'));
            }
            askStatus = strStatus;
            return addaskDesc;
        }

        /// <summary>
        /// 钢种坯料属性
        /// </summary>
        private void doConfirmGrade()
        {
            try
            {
                ultraGrid1.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkRows = ultraGrid1.Rows.AsQueryable().Where(" CHECK = 'True' ");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选合同！");
                    return;
                }

                WaitFromOpen();
                foreach (UltraGridRow uRow in checkRows)
                {
                    ///查询合同状态
                    ArrayList status = new ArrayList();
                    status.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.querySaleStatus",
                        new object[] { status }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        break;
                    }
                    if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("1"))
                    {
                        ArrayList param = new ArrayList();
                        param.Add(uRow.Cells["GRADECODE"].Value.ToString());
                        param.Add(uRow.Cells["STUFF_PROPERTY"].Value.ToString());
                        param.Add("1");         //确认
                        param.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                        list.Add(param);
                    }
                    else
                    {
                        WaitFromColse();
                        if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().CompareTo("1") > 0)
                        {
                            MessageUtil.ShowTips("合同：" + uRow.Cells["ORDER_NO"].Value.ToString() + "/"
                                    + uRow.Cells["ORDER_SEQ"].Value.ToString() + "已下发，不能修改！");
                        }
                        else
                        {
                            MessageUtil.ShowTips("合同：" + uRow.Cells["ORDER_NO"].Value.ToString() + "/"
                                    + uRow.Cells["ORDER_SEQ"].Value.ToString() + "未接收！");
                        }
                        return;
                    }
                }

                int succeed = ServerHelper.SetData("com.steering.pss.plan.order.CoreSaleOrderOP.saveSaleOrderGrade",
                    new object[] { list }, this.ob);
                WaitFromColse();
                if (succeed > 0)
                {
                    MessageUtil.ShowTips("保存成功！");
                }
                else
                {
                    MessageUtil.ShowError("保存失败！");
                }
            }
            catch (Exception ex)
            {
                WaitFromColse();
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            doQuery(GetQueryCondition());
        }

        /// <summary>
        /// 镦拔扩确认
        /// </summary>
        private void doConfirmBj()
        {
            try
            {
                ultraGrid1.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkRows = ultraGrid1.Rows.AsQueryable().Where(" CHECK = 'True' ");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选合同！");
                    return;
                }

                WaitFromOpen();
                foreach (UltraGridRow uRow in checkRows)
                {
                    ///查询合同状态
                    ArrayList status = new ArrayList();
                    status.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.querySaleStatus",
                        new object[] { status }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        break;
                    }
                    if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("1"))
                    {
                        ArrayList param = new ArrayList();
                        param.Add(uRow.Cells["E_IN_MATERIAL_NO"].Value.ToString());
                        param.Add(uRow.Cells["E_IN_MATERIAL_DESC"].Value.ToString());
                        param.Add(uRow.Cells["DIMATER_YLG"].Value.ToString());
                        param.Add(uRow.Cells["HEIGHT_YLG"].Value.ToString());
                        if (!uRow.Cells["PROCESS_SEQ"].Value.ToString().Contains("E"))
                        {
                            param.Add("2");
                        }
                        else
                        {
                            param.Add("1");         //确认
                        }
                        param.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                        list.Add(param);
                    }
                    else
                    {
                        WaitFromColse();
                        if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().CompareTo("1") > 0)
                        {
                            MessageUtil.ShowTips("合同：" + uRow.Cells["ORDER_NO"].Value.ToString() + "/"
                                    + uRow.Cells["ORDER_SEQ"].Value.ToString() + "已下发，不能修改！");
                        }
                        else
                        {
                            MessageUtil.ShowTips("合同：" + uRow.Cells["ORDER_NO"].Value.ToString() + "/"
                                    + uRow.Cells["ORDER_SEQ"].Value.ToString() + "未接收！");
                        }
                        return;
                    }
                }

                int succeed = ServerHelper.SetData("com.steering.pss.plan.order.CoreSaleOrderOP.saveSaleOrderBj",
                    new object[] { list }, this.ob);
                WaitFromColse();
                if (succeed > 0)
                {
                    MessageUtil.ShowTips("保存成功！");
                }
                else
                {
                    MessageUtil.ShowError("保存失败！");
                }
            }
            catch (Exception ex)
            {
                WaitFromColse();
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            doQuery(GetQueryCondition());
        }

        /// <summary>
        /// 轧管确认
        /// </summary>
        private void doConfirmZg()
        {
            try
            {
                ultraGrid1.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkRows = ultraGrid1.Rows.AsQueryable().Where(" CHECK = 'True' ");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选合同！");
                    return;
                }

                WaitFromOpen();
                foreach (UltraGridRow uRow in checkRows)
                {
                    ///查询合同状态
                    ArrayList status = new ArrayList();
                    status.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.querySaleStatus",
                        new object[] { status }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        break;
                    }
                    if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().CompareTo("5") < 0)
                    {
                        ArrayList param = new ArrayList();
                        DateTime date = new DateTime();
                        //排产量 = 合同量*投料原则
                        double planWeight = Convert.ToDouble(dtStatus.Rows[0]["PLANWEIGHT"]);
                        double extraLenTotWt = 0; //排产加长总重量

                        double lenTotWt = 0;//原排产加长重量
                        double planWt = 0;//原排产量
                        double.TryParse(dtStatus.Rows[0]["EXTRA_LEN_TOT_WT"].ToString(), out lenTotWt);
                        double.TryParse(dtStatus.Rows[0]["PLANWEIGHT"].ToString(), out planWt);

                        //计算轧制长度上下限
                        RollLenCal lencal = new RollLenCal();
                        lencal.Lengthmax = Convert.ToDouble(dtStatus.Rows[0]["LENGTHMAX"]);
                        lencal.Lengthmin = Convert.ToDouble(dtStatus.Rows[0]["LENGTHMIN"]);
                        lencal.ModelDesc = dtStatus.Rows[0]["MODEL_DESC"].ToString();
                        lencal.Pline = uRow.Cells["GROUP_ROLL"].Value.ToString();
                        lencal.ProducName = dtStatus.Rows[0]["PRODUCNAME"].ToString();
                        DataTable dtCraft = ServerHelper.GetData("com.steering.pss.plan.order.CoreOrderCraftInfo.getOrdCraftStd",
                            new object[] { uRow.Cells["CRAFT_FILE_NO"].Value.ToString(), 
                                uRow.Cells["ORDER_NO"].Value.ToString(), 
                                uRow.Cells["ORDER_SEQ"].Value.ToString() }, this.ob);
                        if (dtCraft != null && dtCraft.Rows.Count > 0)
                        {
                            lencal.StdGjgNo = dtCraft.Rows[0]["STD_GJG_NO"].ToString();
                        }
                        lencal.calToendMax();

                        param.Add(uRow.Cells["OUTS_BILLET_FL"].Value.ToString());
                        param.Add(uRow.Cells["GROUP_ROLL"].Value.ToString());
                        if (DateTime.TryParse(uRow.Cells["ROLL_MONTH"].Value.ToString(), out date))
                        {
                            param.Add(date.ToString("yyyy-MM"));
                            #region 计算排产量 计划量
                            if (!dtStatus.Rows[0]["ORDER_UNIT"].ToString().Equals("个")
                                && !dtStatus.Rows[0]["ORDER_UNIT"].ToString().Equals("支"))
                            {
                                double rate = 0;
                                double orderQty = Convert.ToDouble(dtStatus.Rows[0]["ORDER_QTY"]);
                                double delvryRangeMax = Convert.ToDouble(dtStatus.Rows[0]["DELVRY_RANGE_MAX"]);
                                double delvryRangeMin = Convert.ToDouble(dtStatus.Rows[0]["DELVRY_RANGE_MIN"]);
                                //排产量=估算量*（1+(（交货量差上限-下限）*投料原则-下限））
                                if (dtStatus.Rows[0]["DELVRY_RANGE_TPE"].ToString().Trim().Equals("绝对值"))
                                {
                                    delvryRangeMax = (delvryRangeMax / orderQty) * 100;
                                    delvryRangeMin = (delvryRangeMin / orderQty) * 100;
                                }

                                rate = ((delvryRangeMax + delvryRangeMin) * queryPutRate(
                                    date.Year, date.Month) - delvryRangeMin) / 100;
                                planWeight = Convert.ToDouble(dtStatus.Rows[0]["ORDERWEIGHT"]) * (1 + rate);
                            }
                            #endregion
                        }
                        else
                        {
                            param.Add("");
                        }

                        if (!uRow.Cells["PROCESS_SEQ"].Value.ToString().Contains("D"))
                        {
                            param.Add("2");
                            param.Add("");
                            param.Add("");
                        }
                        else
                        {
                            double weightPerM = 0;
                            int planNum = 0;
                            //计算排产加长总重量
                            if (double.TryParse(dtStatus.Rows[0]["WEIGHT_PER_M"].ToString(), out weightPerM)
                                && int.TryParse(dtStatus.Rows[0]["PLAN_NUM"].ToString(), out planNum))
                            {
                                extraLenTotWt = Math.Round((lencal.ExtraLenTot * weightPerM * planNum), 3);
                            }

                            param.Add("1");         //确认;
                            param.Add(lencal.LenToendMax);
                            param.Add(lencal.LenToendMin);
                        }
                        param.Add(extraLenTotWt.ToString());
                        param.Add(planWeight.ToString());

                        ///计划量变化量
                        double addWt = (planWeight - planWt) + (extraLenTotWt - lenTotWt);
                        param.Add(addWt.ToString());

                        //合同紧急度
                        param.Add(uRow.Cells["PRIORITY"].Value.ToString());
                        param.Add(uRow.Cells["PRIORITY_MEMO"].Value.ToString());

                        param.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                        list.Add(param);
                    }
                    else
                    {
                        WaitFromColse();
                        if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().CompareTo("4") > 0)
                        {
                            MessageUtil.ShowTips("合同：" + uRow.Cells["ORDER_NO"].Value.ToString() + "/"
                                    + uRow.Cells["ORDER_SEQ"].Value.ToString() + "已缴库，不能修改！");
                        }
                        else if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().CompareTo("1") < 0)
                        {
                            MessageUtil.ShowTips("合同：" + uRow.Cells["ORDER_NO"].Value.ToString() + "/"
                                    + uRow.Cells["ORDER_SEQ"].Value.ToString() + "未接收！");
                        }
                        return;
                    }
                }

                int succeed = ServerHelper.SetData("com.steering.pss.plan.order.CoreSaleOrderOP.saveSaleOrderZg",
                    new object[] { list }, this.ob);
                WaitFromColse();
                if (succeed > 0)
                {
                    MessageUtil.ShowTips("保存成功！");
                }
                else
                {
                    MessageUtil.ShowError("保存失败！");
                }
            }
            catch (Exception ex)
            {
                WaitFromColse();
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            doQuery(GetQueryCondition());
        }

        /// <summary>
        /// 热处理确认
        /// </summary>
        private void doConfirmRcl()
        {
            try
            {
                ultraGrid1.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkRows = ultraGrid1.Rows.AsQueryable().Where(" CHECK = 'True' ");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选合同！");
                    return;
                }

                WaitFromOpen();
                foreach (UltraGridRow uRow in checkRows)
                {
                    ///查询合同状态
                    ArrayList status = new ArrayList();
                    status.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.querySaleStatus",
                        new object[] { status }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        break;
                    }
                    if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("1"))
                    {
                        ArrayList param = new ArrayList();
                        param.Add(uRow.Cells["GROUP_RCL"].Value.ToString());
                        if (!uRow.Cells["PROCESS_SEQ"].Value.ToString().Contains("F"))
                        {
                            param.Add("2");
                        }
                        else
                        {
                            param.Add("1");         //确认
                        }
                        param.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                        list.Add(param);
                    }
                    else
                    {
                        WaitFromColse();
                        if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().CompareTo("1") > 0)
                        {
                            MessageUtil.ShowTips("合同：" + uRow.Cells["ORDER_NO"].Value.ToString() + "/"
                                    + uRow.Cells["ORDER_SEQ"].Value.ToString() + "已下发，不能修改！");
                        }
                        else
                        {
                            MessageUtil.ShowTips("合同：" + uRow.Cells["ORDER_NO"].Value.ToString() + "/"
                                    + uRow.Cells["ORDER_SEQ"].Value.ToString() + "未接收！");
                        }
                        return;
                    }
                }

                int succeed = ServerHelper.SetData("com.steering.pss.plan.order.CoreSaleOrderOP.saveSaleOrderRcl",
                    new object[] { list }, this.ob);
                WaitFromColse();
                if (succeed > 0)
                {
                    MessageUtil.ShowTips("保存成功！");
                }
                else
                {
                    MessageUtil.ShowError("保存失败！");
                }
            }
            catch (Exception ex)
            {
                WaitFromColse();
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            doQuery(GetQueryCondition());
        }

        /// <summary>
        /// 管加工确认
        /// </summary>
        private void doConfirmGjg()
        {
            try
            {
                ultraGrid1.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkRows = ultraGrid1.Rows.AsQueryable().Where(" CHECK = 'True' ");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选合同！");
                    return;
                }

                WaitFromOpen();
                foreach (UltraGridRow uRow in checkRows)
                {
                    ///查询合同状态
                    ArrayList status = new ArrayList();
                    status.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.querySaleStatus",
                        new object[] { status }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        break;
                    }
                    if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("1"))
                    {
                        ArrayList param = new ArrayList();
                        param.Add(uRow.Cells["GROUP_JGX"].Value.ToString());
                        if (!uRow.Cells["PROCESS_SEQ"].Value.ToString().Contains("G"))
                        {
                            param.Add("2");
                        }
                        else
                        {
                            param.Add("1");         //确认
                        }
                        param.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                        list.Add(param);
                    }
                    else
                    {
                        WaitFromColse();
                        if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().CompareTo("1") > 0)
                        {
                            MessageUtil.ShowTips("合同：" + uRow.Cells["ORDER_NO"].Value.ToString() + "/"
                                    + uRow.Cells["ORDER_SEQ"].Value.ToString() + "已下发，不能修改！");
                        }
                        else
                        {
                            MessageUtil.ShowTips("合同：" + uRow.Cells["ORDER_NO"].Value.ToString() + "/"
                                    + uRow.Cells["ORDER_SEQ"].Value.ToString() + "未接收！");
                        }
                        return;
                    }
                }

                int succeed = ServerHelper.SetData("com.steering.pss.plan.order.CoreSaleOrderOP.saveSaleOrderGjg",
                    new object[] { list }, this.ob);
                WaitFromColse();
                if (succeed > 0)
                {
                    MessageUtil.ShowTips("保存成功！");
                }
                else
                {
                    MessageUtil.ShowError("保存失败！");
                }
            }
            catch (Exception ex)
            {
                WaitFromColse();
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            doQuery(GetQueryCondition());
        }

        /// <summary>
        /// 合同接收
        /// </summary>
        private void Pretreat()
        {
            try
            {
                ultraGrid1.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkRows = ultraGrid1.Rows.AsQueryable().Where(" CHECK = 'True' ");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选合同！");
                    return;
                }
                WaitFromOpen();
                foreach (UltraGridRow uRow in checkRows)
                {
                    ///查询合同状态
                    ArrayList status = new ArrayList();
                    ArrayList orderNo = new ArrayList();
                    orderNo.Add(uRow.Cells["ORDER_NO"].Value.ToString());
                    orderNo.Add(uRow.Cells["ORDER_SEQ"].Value.ToString());
                    orderNo.Add(uRow.Cells["DELIVERY_NO"].Value.ToString());
                    DataTable dtOrderNo = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.querySaleByPrimary",
                        new object[] { orderNo }, this.ob);
                    if (dtOrderNo == null || dtOrderNo.Rows.Count <= 0)
                    {
                        break;
                    }
                    else if (dtOrderNo.Rows.Count > 1)
                    {
                        WaitFromColse();
                        MessageUtil.ShowError("合同行：" + uRow.Cells["ORDER_NO"].Value.ToString() + "/"
                                    + uRow.Cells["ORDER_SEQ"].Value.ToString() + "存在多条，请联系合同提报人！");
                        return;
                    }

                    status.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.querySaleStatus",
                        new object[] { status }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        break;
                    }
                    if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("0"))
                    {
                        ArrayList parms = new ArrayList();
                        string desgin_key = uRow.Cells["DESGIN_KEY"].Value.ToString();  //质量设计主键
                                                                                        //
                        double outdiameter = 0;///外径
                        double.TryParse(dtStatus.Rows[0]["OUTDIAMETER"].ToString(), out outdiameter);

                        double wallthick = 0;    //壁厚
                        double.TryParse(dtStatus.Rows[0]["WALLTHICK"].ToString(), out wallthick);
                        
                        double aimlength = 0;              //目标长度
                        double weight_per_m = 0;           //米单重
                        double orderweight = 0;             //合同量
                        int plan_num = 0;               ///计划合同支数

                        string order_unit = dtStatus.Rows[0]["ORDER_UNIT"].ToString();  //订货计量单位
                        string totlength = dtStatus.Rows[0]["TOTLENGTH"].ToString();    //订货长度(保总长) 
                        string totlength_m = dtStatus.Rows[0]["TOTLENGTH"].ToString();  //保米长
                        string length_jg = "";              ///接箍长度
                        string strCodeJg = "";              ///接箍码
                        string prd_cls = "";                ///销售分类
                        string produc_type = "";            ///品名类型

                        string len_desc = dtStatus.Rows[0]["LENGTHDISC"].ToString();    ///长度描述
                        string lenthunit = dtStatus.Rows[0]["LEN_UNIT"].ToString();   ///长度单位
                        string totlengthunit = lenthunit;

                        string lengthmax = dtStatus.Rows[0]["LENGTHMAX"].ToString();///最大长度
                        string lengthmin = dtStatus.Rows[0]["LENGTHMIN"].ToString(); ///最小长度
                        string shrtlenRate = dtStatus.Rows[0]["SHRT_LEN_RATO"].ToString();///短尺率
                        string shortest = dtStatus.Rows[0]["SHORTEST"].ToString();      ///短尺最短
                        string longlenRato = dtStatus.Rows[0]["LONG_LEN_RATO"].ToString();  ///长尺率(%)
                        string longest = dtStatus.Rows[0]["LONGEST"].ToString();        ///长尺最长
                        string avg_len_min = dtStatus.Rows[0]["AVG_LEN_MIN"].ToString();///平均长度大于
                        string difrnc_len_max = dtStatus.Rows[0]["DIFRNC_LEN_MAX"].ToString();///最长最短差小于
                        string sigl_len = dtStatus.Rows[0]["SIGL_LEN"].ToString();    ///单倍尺长
                        string endlen_specstd = dtStatus.Rows[0]["ENDLEN_SPECSTD"].ToString();///成品长度公差（单倍尺长专用）

                        string weigh_type = "";         //计重方式
                        string transiType = "";         //运输方式
                        string station_no = "";         //到站编码
                        string station_nm = "";         //到站名称
                        string mertype = "";        //组合类型
                        string askNo = dtStatus.Rows[0]["ADD_ASK_NO"].ToString();//附加要求编码
                        string askAddDesc = dtStatus.Rows[0]["ORDER_ADD_DESC"].ToString();//附加要求描述
                        string askStatus = "";//附加要求分类状态
                        string craftFileNo = "";
                        string craftFileMan = "";

                        ArrayList paramTrans = new ArrayList();

                        if (lenthunit.ToString().Equals("英尺"))
                        {
                            #region 长度单位为英尺、所有长度字段单位转换为米。
                            if (!lengthmax.Equals(""))
                            {
                                ///最大长度
                                lengthmax = PlanComm.FootoMi(Convert.ToDouble(lengthmax)).ToString();
                                uRow.Cells["LENGTHMAX"].Value = lengthmax;
                            }
                            if (!lengthmin.Equals(""))
                            {
                                ///最小长度
                                lengthmin = PlanComm.FootoMi(Convert.ToDouble(lengthmin)).ToString();
                                uRow.Cells["LENGTHMIN"].Value = lengthmin;
                            }
                            if (!shortest.Equals(""))
                            {
                                ///短尺最短
                                shortest = PlanComm.FootoMi(Convert.ToDouble(shortest)).ToString();
                            }
                            if (!totlength.Equals(""))
                            {
                                ///订货长度(保总长)、保米长
                                totlength_m = PlanComm.FootoMi(Convert.ToDouble(totlength)).ToString();
                            }
                            if (!longest.Equals(""))
                            {
                                ///长尺最长
                                longest = PlanComm.FootoMi(Convert.ToDouble(longest)).ToString();
                            }
                            if (!avg_len_min.Equals(""))
                            {
                                ///平均长度大于
                                avg_len_min = PlanComm.FootoMi(Convert.ToDouble(avg_len_min)).ToString();
                            }
                            if (!difrnc_len_max.Equals(""))
                            {
                                ///最长最短差小于
                                difrnc_len_max = PlanComm.FootoMi(Convert.ToDouble(difrnc_len_max)).ToString();
                            }
                            if (!sigl_len.Equals(""))
                            {
                                ///单倍尺长
                                sigl_len = PlanComm.FootoMi(Convert.ToDouble(sigl_len)).ToString();
                            }
                            if (!endlen_specstd.Equals(""))
                            {
                                ///成品长度公差
                                endlen_specstd = PlanComm.FootoMi(Convert.ToDouble(endlen_specstd)).ToString();
                            }
                            #endregion
                        }
                        if (uRow.Cells["BOM"].Value.ToString().Trim().Equals(""))
                        {
                            WaitFromColse();
                            MessageUtil.ShowError("交货行：" + uRow.Cells["ORDER_NO"].Value.ToString() + "/"
                                        + uRow.Cells["ORDER_SEQ"].Value.ToString() + "/"
                                        + uRow.Cells["DELIVERY_NO"].Value.ToString() + "未找到BOM！");
                            return;
                        }

                        setOrderBominf(uRow);
                        SaleIndexTo(uRow);

                        ///组合类型
                        mertype = MergeType(desgin_key, uRow.Cells["PROCESS_SEQ"].Value.ToString()).ToString();

                        //查询附加要求分类状态和附加要求描述
                        //askAddDesc = queryAddAsk(askNo, out askStatus);

                        ///计重方式-理重、实重
                        DataTable dtAddAsk = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryWeighType",
                            new object[] { dtStatus.Rows[0]["ADD_ASK_NO"].ToString() }, this.ob);
                        if (dtAddAsk != null && dtAddAsk.Rows.Count > 0)
                        {
                            weigh_type = dtAddAsk.Rows[0]["ASK_SUB_ITME_VAL_DESC"].ToString();
                        }

                        ///合同行交货运输方案
                        paramTrans.Add(dtStatus.Rows[0]["ORD_LN_DLY_PK"].ToString());
                        DataTable dtTransit = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryTransit",
                            new object[] { paramTrans }, this.ob);
                        if (dtTransit != null && dtTransit.Rows.Count > 0)
                        {
                            station_no = dtTransit.Rows[0]["STATION_NO"].ToString();
                            station_nm = dtTransit.Rows[0]["STATION_NM"].ToString();
                        }

                        DataTable dtTranType = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryTranType",
                            new object[] { paramTrans }, this.ob);
                        if (dtTranType != null && dtTranType.Rows.Count > 0)
                        {
                            transiType = dtTranType.Rows[0]["TRANSIT_TYP"].ToString();
                        }

                        //工艺匹配
                        DataTable dtCraft = ServerHelper.GetData("com.steering.pss.plan.order.CoreOrderCraftInfo.getCraftByOrderno",
                            new object[] { uRow.Cells["ORDER_NO"].Value.ToString(), uRow.Cells["ORDER_SEQ"].Value.ToString() }, this.ob);
                        if (dtCraft != null && dtCraft.Rows.Count > 0)
                        {
                            craftFileMan = dtCraft.Rows[0]["CRAFT_FILE_MAN"].ToString();
                            craftFileNo = dtCraft.Rows[0]["CRAFT_FILE_NO"].ToString();
                        }

                        ///查询销售分类和品名类型
                        DataTable dtProduce = queryProducType(dtStatus.Rows[0]["PRODUCCODE"].ToString());
                        if (dtProduce != null && dtProduce.Rows.Count > 0)
                        {
                            prd_cls = dtProduce.Rows[0]["PRODUC_STYLE"].ToString();
                            produc_type = dtProduce.Rows[0]["PRODUC_TYPE"].ToString();
                        }

                        OrderStdSic std = new OrderStdSic(this.ob);
                        std.DesginKey = desgin_key;
                        std.BiasCode = "404002";
                        std.Outdiameter = outdiameter;
                        std.Wallthick = wallthick;
                        std.getStdTolerance();

                        ///交货单位“个”或“支”，有合同支数
                        if (order_unit.Equals("个") || order_unit.Equals("支"))
                        {
                            //接箍附件类型合同
                            plan_num = Convert.ToInt32(dtStatus.Rows[0]["ORDER_QTY"]);
                        }
                        else if (mertype.Equals("3"))
                        {
                            #region 管坯合同
                            if (outdiameter != 0)
                            {
                                ///米单重
                                double weightMI = PlanComm.GpweightOfmi(outdiameter);
                                //合同交货量
                                double orderQty = Convert.ToDouble(dtStatus.Rows[0]["ORDER_QTY"]);

                                if (order_unit.Equals("米"))
                                {
                                    orderweight = Math.Round((orderQty * weightMI), 3);
                                }
                                else if (order_unit.Equals("英尺"))
                                {
                                    double lengqty = PlanComm.FootoMi(orderQty);
                                    orderweight = Math.Round((lengqty * weightMI), 3);
                                }
                                else
                                {
                                    orderweight = orderQty;
                                }

                                //目标长度，取长度上下限中间值,计算计划支数
                                if (!lengthmax.Equals("") && !lengthmin.Equals(""))
                                {
                                    aimlength = (Convert.ToDouble(lengthmax) +
                                        Convert.ToDouble(lengthmin)) / 2;
                                    if ((orderweight % (aimlength * weightMI)) == 0)
                                    {
                                        plan_num = (int)(orderweight / (aimlength * weightMI));
                                    }
                                    else
                                    {
                                        plan_num = (int)(orderweight / (aimlength * weightMI)) + 1;
                                    }
                                }
                                weight_per_m = Math.Round(weightMI, 5);
                            }
                            #endregion
                        }
                        else if (outdiameter != 0 && wallthick != 0)
                        {
                            #region 管体类合同
                            //米单重
                            double weightMI = PlanComm.WeightOfMi(outdiameter, std.AimWallthick);
                            //合同交货量
                            double orderQty = Convert.ToDouble(dtStatus.Rows[0]["ORDER_QTY"]);

                            if (order_unit.Equals("米"))
                            {
                                orderweight = Math.Round((orderQty * weightMI), 3);
                            }
                            else if (order_unit.Equals("英尺"))
                            {
                                double lengqty = PlanComm.FootoMi(orderQty);
                                orderweight = Math.Round((lengqty * weightMI), 3);
                            }
                            else
                            {
                                orderweight = orderQty;
                            }

                            //目标长度，取长度上下限中间值,计算计划支数
                            if (!lengthmax.Equals("") && !lengthmin.Equals(""))
                            {
                                aimlength = (Convert.ToDouble(lengthmax) +
                                    Convert.ToDouble(lengthmin)) / 2;
                                if ((orderweight % (aimlength * weightMI)) == 0)
                                {
                                    plan_num = (int)(orderweight / (aimlength * weightMI));
                                }
                                else
                                {
                                    plan_num = (int)(orderweight / (aimlength * weightMI)) + 1;
                                }
                            }
                            weight_per_m = Math.Round(weightMI, 5);
                            #endregion
                        }

                        #region 接箍信息
                        if (produc_type.Equals("D"))
                        {
                            # region 如果品名类型是接箍
                            DataTable dtjg = QueryJgCode(desgin_key);
                            if (dtjg != null && dtjg.Rows.Count > 0)
                            {
                                strCodeJg = dtjg.Rows[0]["CODE_JG"].ToString();//接箍码
                                DataTable dtjgbase = QueryJgBase(strCodeJg);
                                if (dtjgbase != null && dtjgbase.Rows.Count > 0)
                                {
                                    length_jg = dtjgbase.Rows[0]["LENGTH_JG"].ToString();     //接箍长度
                                    aimlength = Convert.ToDouble(length_jg) / 1000;

                                    ///交货单位“个”或“支”，有合同支数
                                    if (!(order_unit.Equals("个") || order_unit.Equals("支")))
                                    {
                                        WaitFromColse();
                                        MessageUtil.ShowError("成品接箍合同：" + uRow.Cells["ORDER_NO"].Value.ToString()
                                            + "/" + uRow.Cells["ORDER_SEQ"].Value.ToString()
                                            + "交货单位不是“支”，请检查合同！");
                                        return;
                                    }
                                }
                            }
                            #endregion
                        }
                        else if (produc_type.Equals("B"))
                        {
                            ///如果是钢管+接箍
                            DataTable dtjg = QueryJgCode(desgin_key);
                            if (dtjg != null && dtjg.Rows.Count > 0)
                            {
                                strCodeJg = dtjg.Rows[0]["CODE_JG"].ToString();//接箍码
                            }
                        }
                        else if (produc_type.Equals("C"))
                        {
                            //附件中，如果有接箍，写入接箍码
                            DataTable dtjg = QueryJgCode(desgin_key);
                            if (dtjg != null && dtjg.Rows.Count > 0)
                            {
                                strCodeJg = dtjg.Rows[0]["CODE_JG"].ToString();//接箍码
                                //foreach (DataRow dr in dtjg.Rows)
                                //{
                                //    //接箍码
                                //    strCodeJg = strCodeJg + dr["CODE_JG"].ToString() + ",";
                                //}
                                //strCodeJg = strCodeJg.Substring(0, strCodeJg.LastIndexOf(','));
                            }
                        }
                        #endregion

                        #region 保存预处理信息
                        parms.Add(prd_cls);
                        parms.Add(strCodeJg);

                        parms.Add(weigh_type);
                        parms.Add(transiType);
                        parms.Add(station_no);
                        parms.Add(station_nm);

                        parms.Add(aimlength.ToString());
                        parms.Add(uRow.Cells["AIMWALLTHICK_ZG"].Value.ToString());
                        parms.Add(uRow.Cells["HEIGHT_NK_MIN"].Value.ToString());
                        parms.Add(uRow.Cells["HEIGHT_NK_MAX"].Value.ToString());
                        parms.Add(std.StdMax.ToString());
                        parms.Add(std.StdMin.ToString());
                        parms.Add(weight_per_m.ToString());
                        parms.Add(orderweight.ToString());
                        parms.Add(orderweight.ToString());
                        parms.Add(plan_num.ToString());

                        ///如果短尺率大于0，则短尺随炉，否则不短尺随炉。
                        if (!dtStatus.Rows[0]["SHRT_LEN_RATO"].ToString().Equals(""))
                        {
                            if (Convert.ToInt32(dtStatus.Rows[0]["SHRT_LEN_RATO"]) > 0)
                            {
                                parms.Add("短尺随炉");
                            }
                            else
                            {
                                parms.Add("");
                            }
                        }
                        else
                        {
                            parms.Add("");
                        }

                        ///长度信息
                        parms.Add(totlengthunit);
                        parms.Add(len_desc);
                        parms.Add("米");
                        parms.Add(lengthmax);
                        parms.Add(lengthmin);
                        parms.Add(totlength);

                        parms.Add(shrtlenRate);
                        parms.Add(shortest);
                        parms.Add(longlenRato);
                        parms.Add(longest);

                        parms.Add(avg_len_min);
                        parms.Add(difrnc_len_max);
                        parms.Add(sigl_len);
                        parms.Add(endlen_specstd);
                        parms.Add(totlength_m);
                        parms.Add(length_jg);

                        ///制程变化信息
                        parms.Add(uRow.Cells["INDEX_SEQ"].Value.ToString());
                        parms.Add(uRow.Cells["BOM"].Value.ToString());
                        parms.Add(uRow.Cells["GROUP_JGX"].Value.ToString());
                        parms.Add(uRow.Cells["GROUP_RCL"].Value.ToString());
                        parms.Add(uRow.Cells["BJ_TYPE"].Value.ToString());
                        parms.Add(uRow.Cells["ENDGXNAME"].Value.ToString());
                        parms.Add(uRow.Cells["PROCESS_SEQ"].Value.ToString());

                        parms.Add(uRow.Cells["PRODUCE_SORT"].Value.ToString());
                        parms.Add(uRow.Cells["E_IN_MATERIAL_NO"].Value.ToString());
                        parms.Add(uRow.Cells["E_IN_MATERIAL_DESC"].Value.ToString());
                        parms.Add(uRow.Cells["DIMATER_YLG"].Value.ToString());
                        parms.Add(uRow.Cells["HEIGHT_YLG"].Value.ToString());

                        parms.Add(uRow.Cells["GROUP_ROLL_ALL"].Value.ToString());
                        parms.Add(uRow.Cells["GROUP_ROLL"].Value.ToString());
                        parms.Add(uRow.Cells["GRADECODE_ALL"].Value.ToString());
                        parms.Add(uRow.Cells["GRADECODE"].Value.ToString());

                        parms.Add(uRow.Cells["STUFF_PROPERTY"].Value.ToString());
                        parms.Add(pipeProperty(dtStatus.Rows[0]["MATERIAL_NO"].ToString()));

                        parms.Add("1");             //合同状态
                        parms.Add(mertype);         //组合类型
                        parms.Add(uRow.Cells["MONITORDEMAND"].Value.ToString());   //监制要求

                        parms.Add(uRow.Cells["BL_GROUP_NUM"].Value.ToString());//短节备料组
                        parms.Add(uRow.Cells["SPECSTANDARD"].Value.ToString());//公差标准
                        parms.Add(CoreUserInfo.UserInfo.GetUserName());
                        parms.Add(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));

                        #region 判断有没有接箍、短节
                        if (mertype.Equals("1") || mertype.Equals("2"))
                        {
                            parms.Add("0"); //接箍合同是否形成
                            parms.Add("0"); //接箍料需求是否制订
                        }
                        else
                        {
                            parms.Add("2"); //无接箍
                            parms.Add("2"); //无接箍
                        }

                        //判断有没有短节
                        if (mertype.Equals("0"))
                        {
                            DataTable dtGroupBl = QueryBlCode(desgin_key);
                            if (dtGroupBl != null && dtGroupBl.Rows.Count > 0)
                            {
                                parms.Add("0"); //短节备料是否形成
                            }
                            else
                            {
                                parms.Add("2"); //无短节备料
                            }
                        }
                        else if (mertype.Equals("2"))
                        {
                            parms.Add("0"); //短节备料是否形成
                        }
                        else
                        {
                            parms.Add("2"); //无短节备料
                        }
                        #endregion

                        #region 各工序信息确认
                        if (uRow.Cells["PROCESS_SEQ"].Value.ToString().Contains("D"))
                        {
                            //判断是否经过轧管工序
                            parms.Add("0");
                        }
                        else
                        {
                            parms.Add("2");
                        }

                        if (uRow.Cells["PROCESS_SEQ"].Value.ToString().Contains("E"))
                        {
                            //判断是否经过镦拔扩工序
                            parms.Add("0");
                        }
                        else
                        {
                            parms.Add("2");
                        }

                        if (uRow.Cells["PROCESS_SEQ"].Value.ToString().Contains("F"))
                        {
                            //判断是否经过热处理工序
                            parms.Add("0");
                        }
                        else
                        {
                            parms.Add("2");
                        }

                        if (uRow.Cells["PROCESS_SEQ"].Value.ToString().Contains("G"))
                        {
                            //判断是否经过管加工工序
                            parms.Add("0");
                        }
                        else
                        {
                            parms.Add("2");
                        }
                        #endregion
                        parms.Add(uRow.Cells["PRIORITY"].Value.ToString());
                        parms.Add(uRow.Cells["PRIORITY_MEMO"].Value.ToString());
                        parms.Add(craftFileNo);
                        parms.Add(craftFileMan);

                        parms.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                        list.Add(parms);
                        #endregion
                    }
                    else
                    {
                        WaitFromColse();
                        MessageUtil.ShowTips("合同：" + uRow.Cells["ORDER_NO"].Value.ToString() + "/"
                                + uRow.Cells["ORDER_SEQ"].Value.ToString() + "已经接收过了！");
                        return;
                    }
                }

                int succeed = ServerHelper.SetData("com.steering.pss.plan.order.CoreSaleOrderOP.updatePretreat",
                                new object[] { list }, this.ob);
                WaitFromColse();
                if (succeed > 0)
                {
                    MessageUtil.ShowTips("接收成功！");
                }
                else
                {
                    MessageUtil.ShowError("接收失败！");
                }
            }
            catch (Exception ex)
            {
                WaitFromColse();
                MessageBox.Show(ex.Message);
            }
            doQuery(GetQueryCondition());
        }

        /// <summary>
        /// 查询投料率
        /// </summary>
        /// <returns></returns>
        private double queryPutRate(int year,int month)
        {
            double putRate = 1;
            ArrayList param = new ArrayList();
            param.Add(year);
            param.Add(month);
            DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryPutRate",
                new object[] { param }, this.ob);
            if (dt != null && dt.Rows.Count > 0)
            {
                double.TryParse(dt.Rows[0]["PUT_RATE"].ToString(), out putRate);
            }
            return putRate;
        }

        /// <summary>
        /// 查询接箍系数
        /// </summary>
        /// <returns></returns>
        private double queryCoeffiJg(int year, int month)
        {
            double coeffiJg = 1;
            ArrayList param = new ArrayList();
            param.Add(year);
            param.Add(month);
            DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryPutRate",
                new object[] { param }, this.ob);
            if (dt != null && dt.Rows.Count > 0)
            {
                double.TryParse(dt.Rows[0]["COEFFI_JG"].ToString(), out coeffiJg);
            }
            return coeffiJg;
        }

        /// <summary>
        /// 查询监制基础信息
        /// </summary>
        /// <param name="prdcrNo">监制编号</param>
        /// <returns></returns>
        private DataTable queryLinePrdcr(string prdcrNo,string mscPline)
        {
            ArrayList param = new ArrayList();
            param.Add(prdcrNo);
            param.Add(mscPline);
            DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryLinePrdcr",
                new object[] { param }, this.ob);
            return dt;
        }

        /// <summary>
        /// 取消接收
        /// </summary>
        private void CancelPre()
        {
            try
            {
                ArrayList list = new ArrayList();
                ArrayList listLog = new ArrayList();
                ultraGrid1.UpdateData();
                IQueryable<UltraGridRow> checkRows = ultraGrid1.Rows.AsQueryable().Where("CHECK = 'True'");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选合同！");
                    return;
                }

                bool isChecked = false;
                string reason = "";
                foreach (UltraGridRow uRow in checkRows)
                {
                    ArrayList status = new ArrayList();
                    status.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.querySaleStatus",
                        new object[] { status }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        break;
                    }
                    if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("1"))
                    {
                        if (dtStatus.Rows[0]["JGORD_IS_OK"].ToString().Equals("1"))
                        {
                            MessageUtil.ShowTips("请先撤消" + uRow.Cells["ORDER_NO"].Value.ToString()
                                + "/" + uRow.Cells["ORDER_SEQ"].Value.ToString() + "的接箍合同！");
                            return;
                        }
                        if (dtStatus.Rows[0]["DJBL_REQ_IS_OK"].ToString().Equals("1"))
                        {
                            MessageUtil.ShowTips("请先撤消" + uRow.Cells["ORDER_NO"].Value.ToString()
                                + "/" + uRow.Cells["ORDER_SEQ"].Value.ToString() + "的短节合同！");
                            return;
                        }

                        ArrayList paramLog = new ArrayList();
                        ArrayList param = new ArrayList();
                        if (!isChecked)
                        {
                            bool isConfirm = false;
                            FrmCancelPretreat CancelPre = new FrmCancelPretreat();
                            CancelPre.ShowDialog();
                            isConfirm = CancelPre.getIsConfirm();
                            if (!isConfirm)
                            {
                                return;
                            }
                            reason = CancelPre.getConcelReason();
                        }
                        isChecked = true;
                        #region 记录回退日志
                        paramLog.Add(uRow.Cells["ORD_PK"].Value.ToString());
                        paramLog.Add(uRow.Cells["ORD_LN_PK"].Value.ToString());
                        paramLog.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                        paramLog.Add(uRow.Cells["ORDER_NO"].Value.ToString());
                        paramLog.Add(uRow.Cells["ORDER_SEQ"].Value.ToString());
                        paramLog.Add(uRow.Cells["DELIVERY_NO"].Value.ToString());
                        paramLog.Add(uRow.Cells["PRODUCNAME"].Value.ToString());
                        paramLog.Add(uRow.Cells["SPEC_NAME"].Value.ToString());
                        paramLog.Add(uRow.Cells["ORDER_UNIT"].Value.ToString());
                        paramLog.Add(uRow.Cells["ORDER_QTY"].Value.ToString());
                        paramLog.Add(uRow.Cells["BUYER_NAME"].Value.ToString());
                        paramLog.Add(uRow.Cells["FINAL_USER_DESC"].Value.ToString());
                        paramLog.Add(uRow.Cells["DELVRY_EDATE"].Value.ToString());

                        ///轧制月份
                        DateTime Date = new DateTime();
                        if (DateTime.TryParse(uRow.Cells["ROLL_MONTH"].Value.ToString(), out Date))
                        {
                            paramLog.Add(Date.ToString("yyyy-MM"));
                        }
                        else
                        {
                            paramLog.Add("");
                        }

                        paramLog.Add(reason);
                        paramLog.Add(CoreUserInfo.UserInfo.GetUserName());
                        paramLog.Add(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));
                        listLog.Add(paramLog);
                        #endregion

                        param.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                        list.Add(param);
                    }
                    else
                    {
                        if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().CompareTo("1") < 0)
                        {
                            MessageUtil.ShowTips("合同" + uRow.Cells["ORDER_NO"].Value.ToString()
                                + "/" + uRow.Cells["ORDER_SEQ"].Value.ToString() + "未接收！");
                            return;
                        }
                        else 
                        {
                            MessageUtil.ShowTips("合同" + uRow.Cells["ORDER_NO"].Value.ToString()
                                + "/" + uRow.Cells["ORDER_SEQ"].Value.ToString() + "已经下发！");
                            return;
                        }
                    }
                }

                int succed = ServerHelper.SetData("com.steering.pss.plan.order.CoreSaleOrderOP.CancelPre",
                            new object[] { listLog, list }, this.ob);

                if (succed > 0)
                {
                    MessageUtil.ShowTips("撤消接收合同成功！");
                }
                else
                {
                    MessageUtil.ShowTips("撤消接收合同失败！");
                    return;
                }
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            doQuery(GetQueryCondition());
        }

        /// <summary>
        /// 接箍处理
        /// </summary>
        private void doProcessJg()
        {
            try
            {
                ultraGrid1.UpdateData();
                IQueryable<UltraGridRow> checkRows = ultraGrid1.Rows.AsQueryable().Where("CHECK = 'True'");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选合同！");
                    return;
                }

                WaitFromOpen();
                ArrayList listupdate = new ArrayList();
                ArrayList list = new ArrayList();
                foreach (UltraGridRow uRow in checkRows)
                {
                    ArrayList status = new ArrayList();
                    status.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.querySaleStatus",
                        new object[] { status }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        break;
                    }
                    if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("1"))
                    {
                        if (dtStatus.Rows[0]["JGORD_IS_OK"].ToString().Equals("1"))
                        {
                            WaitFromColse();
                            Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("合同"
                                + uRow.Cells["ORDER_NO"].Value.ToString() + "/"
                                    + uRow.Cells["ORDER_SEQ"].Value.ToString()
                                + "已处理接箍！");
                            return;
                        }

                        if (dtStatus.Rows[0]["JGORD_IS_OK"].ToString().Equals("2"))
                        {
                            WaitFromColse();
                            Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("合同"
                                + uRow.Cells["ORDER_NO"].Value.ToString() + "/"
                                    + uRow.Cells["ORDER_SEQ"].Value.ToString()
                                + "没有接箍！");
                            return;
                        }

                        if (dtStatus.Rows[0]["PLAN_NUM"].ToString().Equals("") ||
                            dtStatus.Rows[0]["PLAN_NUM"].ToString().Equals("0"))
                        {
                            WaitFromColse();
                            Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("合同"
                                + uRow.Cells["ORDER_NO"].Value.ToString() + "/"
                                    + uRow.Cells["ORDER_SEQ"].Value.ToString()
                                + "合同计划支数未知，请检查合同信息！");
                            return;
                        }

                        string strDesgin_key = uRow.Cells["DESGIN_KEY"].Value.ToString();
                        DataTable dtjg = QueryJgCode(strDesgin_key);
                        ArrayList param = new ArrayList();
                        double weightSale = 0;

                        if (dtjg.Rows.Count > 0 && dtjg != null)
                        {
                            int JGnum = 0;
                            foreach (DataRow dr in dtjg.Rows)
                            {
                                #region 接箍需求信息处理
                                JGnum++;
                                string strCodeJg = dr["CODE_JG"].ToString();//接箍码
                                ArrayList parms = new ArrayList();
                                //接箍合同号（合同号_合同行号_交货编码_G01）
                                string strJG_orderno = uRow.Cells["ORDER_NO"].Value.ToString() +
                                    uRow.Cells["ORDER_SEQ"].Value.ToString() + uRow.Cells["DELIVERY_NO"].Value.ToString()
                                    + "_G" + JGnum.ToString().PadLeft(2, '0');
                                double single_weight = 0;   //接箍个单量
                                double weightJg = 0;        //接箍合同量
                                DataTable dtjgbase = QueryJgBase(strCodeJg);

                                parms.Add(strJG_orderno);
                                parms.Add(uRow.Cells["ORDER_NO"].Value.ToString());
                                parms.Add(uRow.Cells["ORDER_SEQ"].Value.ToString());
                                parms.Add(uRow.Cells["DELIVERY_NO"].Value.ToString());
                                parms.Add(uRow.Cells["BUYER_ID"].Value.ToString());
                                parms.Add(uRow.Cells["BUYER_NAME"].Value.ToString());
                                parms.Add(uRow.Cells["DELVRY_BDATE"].Value.ToString());
                                parms.Add(uRow.Cells["DELVRY_EDATE"].Value.ToString());
                                parms.Add(uRow.Cells["ORDERCONTACT"].Value.ToString());
                                parms.Add(uRow.Cells["MONITORDEMAND"].Value.ToString());
                                parms.Add(uRow.Cells["PSC"].Value.ToString());
                                parms.Add(uRow.Cells["MSC"].Value.ToString());
                                parms.Add("");//接箍制程索引
                                parms.Add(strCodeJg);
                                #region 接箍基础信息
                                if (dtjgbase != null && dtjgbase.Rows.Count > 0)
                                {
                                    single_weight = Convert.ToDouble(dtjgbase.Rows[0]["WEIGHT_JG"]) / 1000;
                                    weightJg = Convert.ToInt32(dtStatus.Rows[0]["PLAN_NUM"]) * single_weight;
                                    weightSale += weightJg;

                                    parms.Add(dtjgbase.Rows[0]["STEELCODE_JG"].ToString());
                                    parms.Add(dtjgbase.Rows[0]["STEELCODE_JG_DESC"].ToString());
                                    parms.Add(dtjgbase.Rows[0]["DIAMETER_JG"].ToString());
                                    parms.Add(dtjgbase.Rows[0]["HEIGHT_JG"].ToString());            //壁厚
                                    parms.Add(dtjgbase.Rows[0]["HEIGHT_JG"].ToString());            //控制壁厚
                                    parms.Add(dtjgbase.Rows[0]["MODEL_CODE"].ToString());
                                    parms.Add(dtjgbase.Rows[0]["LENGTH_JG"].ToString());
                                    parms.Add(dtjgbase.Rows[0]["WEIGHT_JG"].ToString());
                                }
                                else
                                {
                                    parms.Add("");
                                    parms.Add("");
                                    parms.Add("");
                                    parms.Add("");
                                    parms.Add("");
                                    parms.Add("");
                                    parms.Add("");
                                    parms.Add("");
                                }
                                #endregion
                                parms.Add(weightJg.ToString());
                                parms.Add(dtStatus.Rows[0]["PLAN_NUM"].ToString());
                                parms.Add(uRow.Cells["LATEST_PROD_DATE"].Value.ToString());
                                parms.Add("0");
                                parms.Add(CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName());
                                parms.Add(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));
                                parms.Add("0");//利库充当量
                                parms.Add("0");//利库支数
                                parms.Add("0");//有无外购计划(1-有，0-无)
                                parms.Add("0");//外购计划量
                                parms.Add("0");//外购计划个数
                                parms.Add("0");//已做备料需求接箍量
                                list.Add(parms);
                                #endregion
                            }
                        }

                        #region 更新销售合同
                        //完成接箍
                        weightSale = weightSale * queryCoeffiJg(DateTime.Now.Year, DateTime.Now.Month);
                        param.Add("1");
                        param.Add("0");
                        param.Add(weightSale.ToString());//更新销售合同排产量=计划量-接箍量*系数
                        param.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                        listupdate.Add(param);
                        #endregion
                    }
                    else
                    {
                        WaitFromColse();
                        if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().CompareTo("1") > 0)
                        {
                            Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("合同："
                                + uRow.Cells["ORDER_NO"].Value.ToString() + "/"
                                    + uRow.Cells["ORDER_SEQ"].Value.ToString()
                                    + "已下发，不能修改！");
                        }
                        else
                        {
                            MessageUtil.ShowTips("合同：" + uRow.Cells["ORDER_NO"].Value.ToString() + "/"
                                    + uRow.Cells["ORDER_SEQ"].Value.ToString()
                                    + "未接收！");
                        }
                        return;
                    }
                }

                int succed = ServerHelper.SetData("com.steering.pss.plan.order.CoreSaleOrderOP.tranSactionJg",
                            new object[] { list, listupdate }, this.ob);
                WaitFromColse();
                if (succed > 0)
                {
                    MessageUtil.ShowTips("接箍处理成功！");
                }
                else
                {
                    MessageUtil.ShowTips("接箍处理失败！");
                }
            }
            catch (Exception ex)
            {
                WaitFromColse();
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            doQuery(GetQueryCondition());
        }

        /// <summary>
        /// 撤消接箍处理
        /// </summary>
        private void doCancelJg()
        {
            try
            {
                ArrayList list = new ArrayList();
                ultraGrid1.UpdateData();
                IQueryable<UltraGridRow> checkRows = ultraGrid1.Rows.AsQueryable().Where("CHECK = 'True'");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选合同！");
                    return;
                }
                WaitFromOpen();
                foreach (UltraGridRow uRow in checkRows)
                {
                    ArrayList status = new ArrayList();
                    status.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.querySaleStatus",
                        new object[] { status }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        break;
                    }
                    if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("1"))
                    {
                        if (!dtStatus.Rows[0]["JGORD_IS_OK"].ToString().Equals("1"))
                        {
                            WaitFromColse();
                            Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("合同"
                                    + uRow.Cells["ORDER_NO"].Value.ToString() + "/" 
                                        +uRow.Cells["ORDER_SEQ"].Value.ToString()
                                + "没有接箍合同！");
                            return;
                        }
                        ArrayList param = new ArrayList();
                        param.Add(CoreUserInfo.UserInfo.GetUserName());
                        param.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                        list.Add(param);
                    }
                    else if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().CompareTo("1") > 0)
                    {
                        WaitFromColse();
                        Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("合同"
                                    + uRow.Cells["ORDER_NO"].Value.ToString() + "/" 
                                        +uRow.Cells["ORDER_SEQ"].Value.ToString()
                            + "已下发，不能撤销！");
                        return;
                    }
                    else if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().CompareTo("1") < 0)
                    {
                        WaitFromColse();
                        Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("合同"
                                    + uRow.Cells["ORDER_NO"].Value.ToString() + "/"
                                        + uRow.Cells["ORDER_SEQ"].Value.ToString()
                            + "还未接收！");
                        return;
                    }
                }
                int succed = ServerHelper.SetData("com.steering.pss.plan.order.CoreSaleOrderOP.doCancelJg",
                    new object[] { list }, this.ob);
                WaitFromColse();
                if (succed > 0)
                {
                    MessageUtil.ShowTips("撤消接箍合同成功！");
                }
                else
                {
                    MessageUtil.ShowTips("撤消接箍合同失败！");
                }
            }
            catch (Exception ex)
            {
                WaitFromColse();
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            doQuery(GetQueryCondition());
        }

        /// <summary>
        /// 短节处理
        /// </summary>
        private void doProcessDj()
        {
            try
            {
                ultraGrid1.UpdateData();
                IQueryable<UltraGridRow> checkRows = ultraGrid1.Rows.AsQueryable().Where(" CHECK = 'True'");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选合同！");
                    return;
                }
                ArrayList paramBL = new ArrayList();
                ArrayList paramUpdate = new ArrayList();
                WaitFromOpen();
                foreach (UltraGridRow uRow in checkRows)
                {
                    ArrayList status = new ArrayList();
                    status.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.querySaleStatus",
                        new object[] { status }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        break;
                    }
                    if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("1"))
                    {
                        if (dtStatus.Rows[0]["DJBL_REQ_IS_OK"].ToString().Equals("2"))
                        {
                            WaitFromColse();
                            MessageUtil.ShowTips("合同" + uRow.Cells["ORDER_NO"].Value.ToString() + "/"
                                        + uRow.Cells["ORDER_SEQ"].Value.ToString() + "没有短节！");
                            return;
                        }

                        if (dtStatus.Rows[0]["DJBL_REQ_IS_OK"].ToString().Equals("1"))
                        {
                            WaitFromColse();
                            MessageUtil.ShowTips("合同" + uRow.Cells["ORDER_NO"].Value.ToString() + "/"
                                        + uRow.Cells["ORDER_SEQ"].Value.ToString() + "已处理短节！");
                            return;
                        }

                        string strDesgin_key = uRow.Cells["DESGIN_KEY"].Value.ToString();
                        DataTable dtBl = queryBlCodeByGp(strDesgin_key, uRow.Cells["BL_GROUP_NUM"].Value.ToString());
                        ArrayList listupdate = new ArrayList();

                        if (dtBl.Rows.Count > 0 && dtBl != null)
                        {
                            foreach (DataRow dr in dtBl.Rows)
                            {
                                string strCodeBl = dr["PSC_BL"].ToString();//备料码
                                DataTable dtbllist = QueryBlList(strCodeBl);
                                if (dtbllist != null && dtbllist.Rows.Count > 0)
                                {
                                    ArrayList parms = new ArrayList();
                                    double planNum = Convert.ToInt32(uRow.Cells["PLAN_NUM"].Value);

                                    #region 备料清单信息
                                    double min_d = Convert.ToDouble(dtbllist.Rows[0]["MIN_D"]);
                                    double min_h = Convert.ToDouble(dtbllist.Rows[0]["MIN_H"]);
                                    double Weight_One = PlanComm.WeightOfMi(min_d, min_h);//米单重(吨/米)
                                    string strPSC = "";//产品码
                                    double aimlength = (Convert.ToDouble(dtbllist.Rows[0]["MAX_L"])
                                        + Convert.ToDouble(dtbllist.Rows[0]["MIN_L"])) / 2;
                                    double singleweight = aimlength * Weight_One;//单重
                                    double eatchBlnum = aimlength /          //每只备料管可切短节支数。
                                        Convert.ToDouble(uRow.Cells["LENGTHMAX"].Value);
                                    string specSameSale = "0";

                                    if (dtStatus.Rows[0]["OUTDIAMETER"].ToString().Equals(dtbllist.Rows[0]["MIN_D"].ToString())
                                        && dtStatus.Rows[0]["WALLTHICK"].ToString().Equals(dtbllist.Rows[0]["MIN_H"].ToString())
                                        && dtStatus.Rows[0]["STEELCODE"].ToString().Equals(dtbllist.Rows[0]["STEELCODE"].ToString()))
                                    {
                                        specSameSale = "1";
                                    }

                                    parms.Add("短节备料");
                                    parms.Add(uRow.Cells["ORDER_NO"].Value.ToString());
                                    parms.Add(uRow.Cells["ORDER_SEQ"].Value.ToString());
                                    parms.Add(uRow.Cells["DELIVERY_NO"].Value.ToString());
                                    parms.Add(strCodeBl);
                                    parms.Add("0"); //计划状态
                                    parms.Add(CoreUserInfo.UserInfo.GetUserName());
                                    parms.Add(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));

                                    parms.Add(dtbllist.Rows[0]["STEELCODE"].ToString());
                                    parms.Add(dtbllist.Rows[0]["STEELNAME"].ToString());
                                    parms.Add("");//钢种代码
                                    parms.Add(dtbllist.Rows[0]["MIN_D"].ToString());//外径
                                    parms.Add(dtbllist.Rows[0]["MIN_H"].ToString());//壁厚
                                    parms.Add("");//控制壁厚
                                    parms.Add(dtbllist.Rows[0]["MAX_L"].ToString());
                                    parms.Add(dtbllist.Rows[0]["MIN_L"].ToString());
                                    parms.Add(aimlength.ToString());//控制长度
                                    parms.Add(dtbllist.Rows[0]["STD_CODE"].ToString());
                                    parms.Add(dtbllist.Rows[0]["STD_NAME"].ToString());

                                    strPSC = QueryPsc(dtbllist.Rows[0]["PRODUCCODE"].ToString(),
                                        dtbllist.Rows[0]["STD_CODE"].ToString(),
                                        dtbllist.Rows[0]["STEELCODE"].ToString(),
                                        dtbllist.Rows[0]["STD_STYLE"].ToString());
                                    parms.Add(QueryPscForMsc(strPSC));
                                    parms.Add(singleweight.ToString()); //单重
                                    #endregion
                                    if (planNum % eatchBlnum == 0)
                                    {
                                        parms.Add((int)(planNum / eatchBlnum) * singleweight);//备料需求量
                                        parms.Add((int)(planNum / eatchBlnum));//备料需求支数
                                    }
                                    else
                                    {
                                        parms.Add(((int)(planNum / eatchBlnum) + 1) * singleweight);
                                        parms.Add((int)(planNum / eatchBlnum) + 1);
                                    }
                                    parms.Add(specSameSale);
                                    paramBL.Add(parms);
                                }
                                else
                                {
                                    WaitFromColse();
                                    MessageUtil.ShowError("备料码：" + strCodeBl + "未找到基础信息，请查看备料码是否已作废。");
                                    return;
                                }
                            }
                        }

                        //完成短节
                        listupdate.Add("1");
                        listupdate.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                        paramUpdate.Add(listupdate);
                    }
                    else if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().CompareTo("1") < 0)
                    {
                        WaitFromColse();
                        MessageUtil.ShowTips("合同" + uRow.Cells["ORDER_NO"].Value.ToString()
                            + "/" + uRow.Cells["ORDER_SEQ"].Value.ToString() + "还未接收！");
                        return;
                    }
                    else
                    {
                        WaitFromColse();
                        MessageUtil.ShowTips("合同" + uRow.Cells["ORDER_NO"].Value.ToString() + "/" +
                                uRow.Cells["ORDER_SEQ"].Value.ToString() + "已下发！");
                        return;
                    }
                }
                int isSucceed = ServerHelper.SetData("com.steering.pss.plan.order.CoreSaleOrderOP.tranSactionDj",
                                new object[] { paramBL, paramUpdate }, this.ob);
                WaitFromColse();
                if (isSucceed > 0)
                {
                    Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("短节处理成功！");
                }
                else
                {
                    Core.Mes.Client.Comm.Tool.MessageUtil.ShowError("短节处理失败！");
                }
            }
            catch (Exception ex)
            {
                WaitFromColse();
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            doQuery(GetQueryCondition());
        }

        /// <summary>
        /// 撤消短节合同
        /// </summary>
        private void doCancelDj()
        { 
            try
            {
                ultraGrid1.UpdateData();
                IQueryable<UltraGridRow> checkRows = ultraGrid1.Rows.AsQueryable().Where(" CHECK = 'True'");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选合同！");
                    return;
                }
                ArrayList list = new ArrayList();
                WaitFromOpen();
                foreach (UltraGridRow uRow in checkRows)
                {
                    ArrayList status = new ArrayList();
                    status.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.querySaleStatus",
                        new object[] { status }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        break;
                    }
                    if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("1"))
                    {
                        ArrayList param = new ArrayList();
                        if (!dtStatus.Rows[0]["DJBL_REQ_IS_OK"].ToString().Equals("1"))
                        {
                            WaitFromColse();
                            Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("合同"
                                    + uRow.Cells["ORDER_NO"].Value.ToString() + "/"
                                        + uRow.Cells["ORDER_SEQ"].Value.ToString()
                                + "没有短节合同！");
                            return;
                        }
                        param.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                        list.Add(param);
                    }
                    else if(dtStatus.Rows[0]["PORDERSTATUS"].ToString().CompareTo("1") < 0)
                    {
                        WaitFromColse();
                        MessageUtil.ShowTips("合同" + uRow.Cells["ORDER_NO"].Value.ToString()
                            + "/" + uRow.Cells["ORDER_SEQ"].Value.ToString() + "还未接收！");
                        return;
                    }
                }
                if (list.Count == 0)
                {
                    WaitFromColse();
                    return;
                }
                int succed = ServerHelper.SetData("com.steering.pss.plan.order.CoreSaleOrderOP.doCancelDj",
                    new object[] { list }, this.ob);
                WaitFromColse();
                if (succed > 0)
                {
                    MessageUtil.ShowTips("撤消短节合同成功！");
                }
                else
                {
                    MessageUtil.ShowTips("撤消短节合同失败！");
                }
            }
            catch (Exception ex)
            {
                WaitFromColse();
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            doQuery(GetQueryCondition());
        }

        /// <summary>
        /// 根据备料信息中备料码找冶金规范码
        /// </summary>
        /// <param name="blcode">备料码</param>
        /// <returns>冶金规范码</returns>
        private string BlForMsc(string blcode)
        {
            DataTable dtbllist = QueryBlList(blcode);
            if (dtbllist != null && dtbllist.Rows.Count > 0)
            {
                string strPSC = "";
                strPSC = QueryPsc(dtbllist.Rows[0]["PRODUCCODE"].ToString(),
                    dtbllist.Rows[0]["STD_CODE"].ToString(),
                    dtbllist.Rows[0]["STEELCODE"].ToString(),
                    dtbllist.Rows[0]["STD_STYLE"].ToString());
                if (strPSC != "")
                {
                    return QueryPscForMsc(strPSC);
                }
                else
                {
                    return "";
                }
            }
            return "";
        }

        /// <summary>
        /// 新建接箍料需求信息
        /// </summary>
        private void doPlait()
        {
            try
            {
                ArrayList list_Rel = new ArrayList();
                ArrayList list_Jgl = new ArrayList();
                ArrayList list = new ArrayList();
                ArrayList ary = new ArrayList();
                #region 筛选、记录备料码种类
                foreach (UltraGridRow uRow in ultraGrid7.Rows)
                {
                    if (Convert.ToBoolean(uRow.Cells["CHECK"].Text))
                    {
                        if (uRow.Cells["JGBL_SUMLENTH"].Value.Equals("0") ||
                            uRow.Cells["JGBL_SUMLENTH"].Value.Equals(""))
                        {
                            Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("合同：" + uRow.Cells["JG_ORDERNO"].Value.ToString()
                                + ",备料：" + uRow.Cells["CODE_JG_BL"].Value.ToString() + "的项未知备料需求量！");
                            return;
                        }
                        if (!ary.Contains(uRow.Cells["CODE_JG_BL"].Value.ToString()))
                        {
                            ary.Add(uRow.Cells["CODE_JG_BL"].Value.ToString());
                        }
                    }
                }
                if (ary.Count == 0)
                {
                    Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("未指定要新建的接箍料信息！");
                    return;
                }
                #endregion
                #region 保存信息接箍料需求信息和接箍与备料关系
                for (int i = 0; i < ary.Count; i++)
                {
                    string JglCode = ary[i].ToString(); //接箍备料码
                    DataTable dtbllist = QueryBlList(JglCode);
                    if (dtbllist != null && dtbllist.Rows.Count > 0)
                    {
                        ArrayList parms_Jgl = new ArrayList();
                        double min_d = Convert.ToDouble(dtbllist.Rows[0]["MIN_D"]); //外径
                        double min_h = Convert.ToDouble(dtbllist.Rows[0]["MIN_H"]); //壁厚
                        double Weight_One = PlanComm.WeightOfMi(min_d, min_h);  //接箍料米单重

                        string gradecode = "";//钢种代码
                        string steelcode = dtbllist.Rows[0]["STEELCODE"].ToString();//钢级代码
                        string steelname = dtbllist.Rows[0]["STEELNAME"].ToString();//钢级名称
                        double outdiameter = Convert.ToDouble(dtbllist.Rows[0]["MIN_D"]);//外径
                        double wallthick = Convert.ToDouble(dtbllist.Rows[0]["MIN_H"]);//壁厚
                        double aimwallthick = 0;//控制壁厚
                        double lengthmax = Convert.ToDouble(dtbllist.Rows[0]["MAX_L"]);//最大长度
                        double lengthmin = Convert.ToDouble(dtbllist.Rows[0]["MIN_L"]);//最小长度
                        double aimlength = (lengthmax + lengthmin) / 2;//控制长度
                        double singleweight = (aimlength * Weight_One);//备料单重
                        string std_code = dtbllist.Rows[0]["STD_CODE"].ToString();//标准代码
                        string std_name = dtbllist.Rows[0]["STD_NAME"].ToString();//标准名称
                        int jgbl_req_num = 0;//备料支数
                        double jgbl_req_weight = 0;//备料需求量
                        double jgbl_sumlenth = 0;//备料总长度

                        foreach (UltraGridRow uRow in ultraGrid7.Rows)
                        {
                            if (Convert.ToBoolean(uRow.Cells["CHECK"].Text) &&
                                uRow.Cells["CODE_JG_BL"].Value.ToString().Equals(JglCode))
                            {
                                ArrayList parms_Rel = new ArrayList();
                                int Num_Jgl = 0; //单个合同接箍料需求支数
                                double Len_Jgl = Convert.ToDouble(uRow.Cells["JGBL_SUMLENTH"].Value);//单个合同接箍料长度
                                double Weihgt_Jgl = Len_Jgl * Weight_One;//单个合同接箍料需求量
                                if ((Len_Jgl % aimlength) == 0)
                                {
                                    Num_Jgl = (int)(Len_Jgl / aimlength);
                                }
                                else
                                {
                                    Num_Jgl = (int)(Len_Jgl / aimlength) + 1;
                                }
                                jgbl_sumlenth += Len_Jgl;

                                #region 接箍及接箍料关系
                                parms_Rel.Add(uRow.Cells["JG_ORDERNO"].Value.ToString());
                                parms_Rel.Add(i.ToString());
                                parms_Rel.Add(uRow.Cells["CODE_JG"].Value.ToString());
                                parms_Rel.Add(uRow.Cells["OUTDIAMETER"].Value.ToString());
                                parms_Rel.Add(uRow.Cells["AIMLENGTH"].Value.ToString());
                                parms_Rel.Add(uRow.Cells["WALLTHICK"].Value.ToString());
                                parms_Rel.Add(steelcode);
                                parms_Rel.Add(steelname);
                                parms_Rel.Add(uRow.Cells["SINGLEWEIGHT_JG"].Value.ToString());
                                parms_Rel.Add(JglCode);
                                parms_Rel.Add(aimlength.ToString());
                                parms_Rel.Add(singleweight.ToString());
                                parms_Rel.Add(Weihgt_Jgl.ToString());
                                parms_Rel.Add(Num_Jgl.ToString());
                                parms_Rel.Add("1");
                                parms_Rel.Add(uRow.Cells["WEIGHT_JG"].Value.ToString());
                                parms_Rel.Add(uRow.Cells["NUM_JG"].Value.ToString());
                                parms_Rel.Add("");//接箍计划已排量
                                parms_Rel.Add("0");
                                parms_Rel.Add(CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName());
                                parms_Rel.Add(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));
                                #endregion
                                list_Rel.Add(parms_Rel);
                            }
                        }

                        if ((jgbl_sumlenth % aimlength) == 0)
                        {
                            jgbl_req_num = (int)(jgbl_sumlenth / aimlength);
                        }
                        else
                        {
                            jgbl_req_num = (int)(jgbl_sumlenth / aimlength) + 1;
                        }
                        jgbl_req_weight = jgbl_sumlenth * Weight_One;

                        #region 接箍料需求信息
                        parms_Jgl.Add(i.ToString());
                        parms_Jgl.Add("接箍料");
                        parms_Jgl.Add(steelcode);
                        parms_Jgl.Add(steelname);
                        parms_Jgl.Add(gradecode);//钢种代码
                        parms_Jgl.Add(outdiameter.ToString());
                        parms_Jgl.Add(wallthick.ToString());
                        parms_Jgl.Add(aimwallthick);//控制壁厚
                        parms_Jgl.Add(lengthmax.ToString());
                        parms_Jgl.Add(lengthmin.ToString());
                        parms_Jgl.Add(aimlength.ToString());//控制长度
                        parms_Jgl.Add(JglCode);
                        parms_Jgl.Add(singleweight.ToString());
                        parms_Jgl.Add(jgbl_req_weight.ToString());
                        parms_Jgl.Add(jgbl_req_num.ToString());
                        parms_Jgl.Add("0");
                        parms_Jgl.Add(CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName());
                        parms_Jgl.Add(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));
                        parms_Jgl.Add(std_code);
                        parms_Jgl.Add(std_name);
                        parms_Jgl.Add(BlForMsc(JglCode));
                        #endregion
                        list_Jgl.Add(parms_Jgl);
                    }
                    else
                    {
                        MessageUtil.ShowError("备料码：" + JglCode + "未找到基础信息，请查看备料码是否已作废。");
                        return;
                    }
                }
                #endregion
                
                ///更新接箍合同已做备料需求个数
                foreach (UltraGridRow uRow in ultraGrid7.Rows)
                {
                    if (Convert.ToBoolean(uRow.Cells["CHECK"].Text))
                    {
                        ArrayList parms = new ArrayList();
                        int jgwt_blreq = Convert.ToInt32(uRow.Cells["NUM_JG"].Value);
                        parms.Add(jgwt_blreq.ToString());
                        parms.Add(uRow.Cells["JG_ORDERNO"].Value.ToString());
                        list.Add(parms);
                    }
                }

                int succed = ServerHelper.SetData("com.steering.pss.plan.order.CoreSaleOrderOP.saveJglNeed",
                    new object[] { list_Jgl, list_Rel, list }, this.ob);
                if (succed > 0)
                {
                    MessageUtil.ShowTips("新建需求成功！");
                }
                else
                {
                    MessageUtil.ShowTips("新建需求失败！");
                    return;
                }
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            QueryJGl();
        }

        /// <summary>
        /// 加入现有接箍料需求
        /// </summary>
        private void doAddPlait()
        {
            try
            {
                string code_jg_bl = "";//备料码
                string req_bl_id = "";//备料需求编号
                double jgbl_req_weight = 0;//备料需求量
                int jgbl_req_num = 0;//备料需求支数
                ArrayList listUpdateRel = new ArrayList();
                ArrayList list_Rel = new ArrayList();
                ArrayList listupdate = new ArrayList();
                ArrayList list = new ArrayList();
                int count = 0;
                #region 筛选加入条件
                foreach (UltraGridRow uRow in ultraGrid6.Rows)
                {
                    if (Convert.ToBoolean(uRow.Cells["CHECK"].Text))
                    {
                        count++;
                        code_jg_bl = uRow.Cells["CODE_JG_BL"].Value.ToString();
                        req_bl_id = uRow.Cells["REQ_BL_ID"].Value.ToString();
                    }
                }
                if (count == 1)
                {
                    bool isChecked = false;
                    foreach (UltraGridRow uRow in ultraGrid7.Rows)
                    {
                        if (Convert.ToBoolean(uRow.Cells["CHECK"].Text))
                        {
                            isChecked = true;
                            if (code_jg_bl != uRow.Cells["CODE_JG_BL"].Value.ToString())
                            {
                                Core.Mes.Client.Comm.Tool.MessageUtil.ShowError("所选择的条目备料码"
                                    + "与要加入的备料需求的备料码有不同，请重新选择！");
                                return;
                            }
                        }
                    }

                    ///如果没有勾选待处理的条目，提示。
                    if (!isChecked)
                    {
                        Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("未选择要加入现有需求的信息！");
                        return;
                    }
                }
                else
                {
                    if (count == 0)
                    {
                        Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("请选择一条现有的接箍料需求！");
                        return;
                    }
                    Core.Mes.Client.Comm.Tool.MessageUtil.ShowError("您选择了多条接箍料需求，"
                        + "无法确定您需要将需求加入那条现有需求中！");
                    return;
                }
                #endregion
                #region 接箍备料对应关系信息
                DataTable dtbllist = QueryBlList(code_jg_bl);
                if (dtbllist != null && dtbllist.Rows.Count > 0)
                {
                    double outdiameter = Convert.ToDouble(dtbllist.Rows[0]["MIN_D"]);//外径
                    double wallthick = Convert.ToDouble(dtbllist.Rows[0]["MIN_H"]);//壁厚

                    double Weight_One = PlanComm.WeightOfMi(outdiameter, wallthick);  //接箍料米单重
                    string steelcode = dtbllist.Rows[0]["STEELCODE"].ToString();//钢级代码
                    string steelname = dtbllist.Rows[0]["STEELNAME"].ToString();//钢级名称
                    double lengthmax = Convert.ToDouble(dtbllist.Rows[0]["MAX_L"]);//最大长度
                    double lengthmin = Convert.ToDouble(dtbllist.Rows[0]["MIN_L"]);//最小长度
                    double aimlength = (lengthmax + lengthmin) / 2;//控制长度
                    double singleweight = (aimlength * Weight_One);//备料单重
                    string std_code = dtbllist.Rows[0]["STD_CODE"].ToString();//标准代码
                    string std_name = dtbllist.Rows[0]["STD_NAME"].ToString();//标准名称
                    double jgbl_sumlenth = 0;//备料总长度

                    foreach (UltraGridRow uRow in ultraGrid7.Rows)
                    {
                        if (Convert.ToBoolean(uRow.Cells["CHECK"].Text))
                        {
                            if (uRow.Cells["JGBL_SUMLENTH"].Value.Equals("0") ||
                                uRow.Cells["JGBL_SUMLENTH"].Value.Equals(""))
                            {
                                Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("合同："
                                    + uRow.Cells["JG_ORDERNO"].Value.ToString() + ",备料："
                                    + uRow.Cells["CODE_JG_BL"].Value.ToString() + "的项未知备料需求量！");
                                return;
                            }
                            bool bl = false;
                            int Num_Jgl = 0; //单个合同接箍料需求支数
                            double Len_Jgl = Convert.ToDouble(uRow.Cells["JGBL_SUMLENTH"].Value);//单个合同接箍料长度
                            double Weihgt_Jgl = Len_Jgl * Weight_One;//单个合同接箍料需求量
                            if ((Len_Jgl % aimlength) == 0)
                            {
                                Num_Jgl = (int)(Len_Jgl / aimlength);
                            }
                            else
                            {
                                Num_Jgl = (int)(Len_Jgl / aimlength) + 1;
                            }
                            jgbl_sumlenth += Len_Jgl;

                            DataTable dtRel = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryRelation",
                                new object[] { req_bl_id }, this.ob);
                            foreach (DataRow dr in dtRel.Rows)
                            {
                                if (uRow.Cells["JG_ORDERNO"].Value.ToString().Equals(
                                    dr["JG_ORDERNO"].ToString()))
                                {
                                    #region 有相同对应关系的情况，更新对应关系的需求量
                                    bl = true;
                                    ArrayList parms = new ArrayList();
                                    parms.Add(Weihgt_Jgl.ToString());
                                    parms.Add(Num_Jgl.ToString());
                                    parms.Add(CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName());
                                    parms.Add(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));
                                    parms.Add(req_bl_id);
                                    parms.Add(uRow.Cells["JG_ORDERNO"].Value.ToString());
                                    listUpdateRel.Add(parms);
                                    #endregion
                                }
                            }

                            if (bl == false)
                            {
                                #region 没有相同对应关系的情况，新增一条对应关系
                                ArrayList parms_Rel = new ArrayList();
                                parms_Rel.Add(uRow.Cells["JG_ORDERNO"].Value.ToString());
                                parms_Rel.Add(req_bl_id);
                                parms_Rel.Add(uRow.Cells["CODE_JG"].Value.ToString());
                                parms_Rel.Add(uRow.Cells["OUTDIAMETER"].Value.ToString());
                                parms_Rel.Add(uRow.Cells["AIMLENGTH"].Value.ToString());
                                parms_Rel.Add(uRow.Cells["WALLTHICK"].Value.ToString());
                                parms_Rel.Add(steelcode);
                                parms_Rel.Add(steelname);
                                parms_Rel.Add(uRow.Cells["SINGLEWEIGHT_JG"].Value.ToString());
                                parms_Rel.Add(code_jg_bl);
                                parms_Rel.Add(aimlength.ToString());
                                parms_Rel.Add(singleweight.ToString());
                                parms_Rel.Add(Weihgt_Jgl.ToString());
                                parms_Rel.Add(Num_Jgl.ToString());
                                parms_Rel.Add("1");
                                parms_Rel.Add(uRow.Cells["WEIGHT_JG"].Value.ToString());
                                parms_Rel.Add(uRow.Cells["NUM_JG"].Value.ToString());
                                parms_Rel.Add("");//接箍计划已排量
                                parms_Rel.Add("0");
                                parms_Rel.Add(CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName());
                                parms_Rel.Add(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));
                                list_Rel.Add(parms_Rel);
                                #endregion
                            }
                        }
                    }

                    //计算备料总量
                    if ((jgbl_sumlenth % aimlength) == 0)
                    {
                        jgbl_req_num = (int)(jgbl_sumlenth / aimlength);
                    }
                    else
                    {
                        jgbl_req_num = (int)(jgbl_sumlenth / aimlength) + 1;
                    }
                    jgbl_req_weight = jgbl_sumlenth * Weight_One;
                }
                else
                {
                    MessageUtil.ShowError("备料码：" + code_jg_bl + "未找到基础信息，请查看备料码是否已作废。");
                    return;
                }
                #endregion
                list.Add(jgbl_req_weight.ToString());
                list.Add(jgbl_req_num.ToString());
                list.Add(CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName());
                list.Add(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));
                list.Add(req_bl_id);

                ///更新接箍合同已做备料需求量
                foreach (UltraGridRow uRow in ultraGrid7.Rows)
                {
                    if (Convert.ToBoolean(uRow.Cells["CHECK"].Text))
                    {
                        ArrayList parms = new ArrayList();
                        int jgwt_blreq = Convert.ToInt32(uRow.Cells["NUM_JG"].Value);
                        parms.Add(jgwt_blreq);
                        parms.Add(uRow.Cells["JG_ORDERNO"].Value.ToString());
                        listupdate.Add(parms);
                    }
                }
                ServerHelper.SetData("com.steering.pss.plan.order.CoreSaleOrderOP.updateJglNeed",
                    new object[] { list, listUpdateRel, list_Rel, listupdate }, this.ob);
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            QueryJGl();
        }

        /// <summary>
        /// 删除接箍料需求
        /// </summary>
        private void Delete()
        {
            try
            {
                ArrayList listJg = new ArrayList();
                ArrayList listRel = new ArrayList();
                ArrayList list = new ArrayList();
                bool bl = false;
                foreach (UltraGridRow uRow in ultraGrid6.Rows)
                {
                    if (Convert.ToBoolean(uRow.Cells["CHECK"].Text) && uRow.Cells["BLTYPE"].Value.ToString() == "接箍料")
                    {
                        ArrayList parms = new ArrayList();
                        bl = true;
                        parms.Add(uRow.Cells["REQ_BL_ID"].Value.ToString());
                        listJg.Add(parms);

                        DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryRelation",
                            new object[] { uRow.Cells["REQ_BL_ID"].Value.ToString() }, this.ob);
                        foreach (DataRow dr in dt.Rows)
                        {
                            ArrayList paramrel = new ArrayList();
                            ArrayList parmUpadte = new ArrayList();
                            paramrel.Add(dr["JG_ORDERNO"].ToString());
                            paramrel.Add(dr["REQ_BL_ID"].ToString());
                            listRel.Add(paramrel);

                            ///更新接箍合同已做备料需求个数
                            parmUpadte.Add("-" + dr["NUM_JG"].ToString());
                            parmUpadte.Add(dr["JG_ORDERNO"].ToString());
                            list.Add(parmUpadte);
                        }
                    }
                }
                if (bl)
                {
                    if (MessageBox.Show("是否要删除该备料需求？", "警告", MessageBoxButtons.OKCancel) != DialogResult.OK)
                    {
                        return;
                    }

                    ServerHelper.SetData("com.steering.pss.plan.order.CoreSaleOrderOP.deleteBlNeed",
                        new object[] { listRel, listJg, list }, this.ob);
                }
                else
                {
                    Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("请选择要删除的接箍料需求！");
                    return;
                }
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            QueryJGl();
        }

        /// <summary>
        /// 删除接箍料需求单量
        /// </summary>
        private void DeleteOne()
        {
            try
            {
                ArrayList list_Rel = new ArrayList();
                ArrayList list_Jgl = new ArrayList();
                ArrayList list = new ArrayList();
                ArrayList ary = new ArrayList();
                foreach (UltraGridRow uRow in ultraGrid4.Rows)
                {
                    if (Convert.ToBoolean(uRow.Cells["CHECK"].Text) &&
                        !ary.Contains(uRow.Cells["REQ_BL_ID"].Value.ToString()))
                    {
                        ary.Add(uRow.Cells["REQ_BL_ID"].Value.ToString());
                    }
                }
                if (ary.Count > 0)
                {
                    #region 删除接箍料与接箍对应关系信息，和接箍料需求量减少信息
                    for (int i = 0; i < ary.Count; i++)
                    {
                        double jgbl_req_weight = 0;
                        int jgbl_req_num = 0;
                        ArrayList parms_Jgl = new ArrayList();
                        foreach (UltraGridRow uRow in ultraGrid4.Rows)
                        {
                            if (Convert.ToBoolean(uRow.Cells["CHECK"].Text) &&
                                uRow.Cells["REQ_BL_ID"].Value.ToString().Equals(ary[i].ToString()))
                            {
                                ArrayList parms_Rel = new ArrayList();
                                ArrayList parmUpadte = new ArrayList();
                                jgbl_req_weight += Convert.ToDouble(uRow.Cells["JGBL_REQ_WEIGHT"].Value);
                                jgbl_req_num += Convert.ToInt32(uRow.Cells["JGBL_REQ_NUM"].Value);
                                parms_Rel.Add(uRow.Cells["JG_ORDERNO"].Value.ToString());
                                parms_Rel.Add(uRow.Cells["REQ_BL_ID"].Value.ToString());
                                list_Rel.Add(parms_Rel);

                                ///更新接箍合同已做备料需求个数
                                parmUpadte.Add("-" + uRow.Cells["NUM_JG"].Value.ToString());
                                parmUpadte.Add(uRow.Cells["JG_ORDERNO"].Value.ToString());
                                list.Add(parmUpadte);
                            }
                        }
                        foreach (UltraGridRow uRow in ultraGrid6.Rows)
                        {
                            if (uRow.Cells["REQ_BL_ID"].Value.ToString().Equals(ary[i].ToString()))
                            {
                                jgbl_req_weight = - jgbl_req_weight;
                                jgbl_req_num = - jgbl_req_num;
                            }
                        }
                        parms_Jgl.Add(jgbl_req_weight);
                        parms_Jgl.Add(jgbl_req_num);
                        parms_Jgl.Add(CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName());
                        parms_Jgl.Add(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));
                        parms_Jgl.Add(ary[i].ToString());
                        list_Jgl.Add(parms_Jgl);
                    }
                    #endregion
                    if (MessageBox.Show("是否要删除这些备料需求量？", "警告",
                        MessageBoxButtons.OKCancel) == DialogResult.OK)
                    {
                        ServerHelper.SetData("com.steering.pss.plan.order.CoreSaleOrderOP.deleteJglOne",
                            new object[] { list_Rel, list_Jgl, list }, this.ob);
                    }
                }
                else
                {
                    Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("请至少选择一条接箍料需求单量！");
                    return;
                }
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            QueryJGl();
        }

        /// <summary>
        /// 查询接箍基础表
        /// </summary>
        /// <param name="strCodeJg">接箍码</param>
        private DataTable QueryJgBase(string strCodeJg)
        {
            try
            {
                DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryJgBase", new object[] { 
                    strCodeJg }, this.ob);
                return dt;
            }
            catch
            {
                return null;
            }
        }

        /// <summary>
        /// 查询备料清单表
        /// </summary>
        /// <param name="strCodeJg">备料码</param>
        public DataTable QueryBlList(string strCodeJg)
        {
            try
            {
                DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryBlList", new object[] { 
                    strCodeJg }, this.ob);
                return dt;
            }
            catch
            {
                return null;
            }
        }

        /// <summary>
        /// 销售合同下发
        /// </summary>
        private void OrderSaleIssued()
        {
            try
            {
                ArrayList list = new ArrayList();
                ArrayList listPrc = new ArrayList();
                ArrayList listPss = new ArrayList();
                ultraGrid1.UpdateData();
                IQueryable<UltraGridRow> checkRows = ultraGrid1.Rows.AsQueryable().Where("CHECK = 'True'");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选合同！");
                    return;
                }
                WaitFromOpen();
                foreach (UltraGridRow uRow in checkRows)
                {
                    ArrayList status = new ArrayList();
                    status.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.querySaleStatus",
                        new object[] { status }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        break;
                    }
                    if (!dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("1"))
                    {
                        WaitFromColse();
                        if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().CompareTo("1") > 0)
                        {
                            MessageUtil.ShowTips("合同"+ uRow.Cells["ORDER_NO"].Value.ToString() + "/" +
                            uRow.Cells["ORDER_SEQ"].Value.ToString() + "已经是下发状态！");
                        }
                        else
                        {
                            MessageUtil.ShowTips("合同"+ uRow.Cells["ORDER_NO"].Value.ToString() + "/" +
                            uRow.Cells["ORDER_SEQ"].Value.ToString() + "还不能下发！");
                        }
                        return;
                    }
                    if (dtStatus.Rows[0]["IF_ALLOW_ISSUE"].ToString().Equals("1"))
                    {
                        DataTable dtCraft = ServerHelper.GetData("com.steering.pss.plan.order.CoreOrderCraftInfo.getCraftByOrderno",
                            new object[] { uRow.Cells["ORDER_NO"].Value.ToString(),
                                uRow.Cells["ORDER_SEQ"].Value.ToString() }, this.ob);
                        if (dtCraft == null || dtCraft.Rows.Count <= 0)
                        {
                            WaitFromColse();
                            MessageUtil.ShowTips("合同" + uRow.Cells["ORDER_NO"].Value.ToString() + "/" +
                            uRow.Cells["ORDER_SEQ"].Value.ToString() + "无工艺！");
                            return;
                        }
                        if (dtStatus.Rows[0]["GRADECODE"].ToString().Equals(""))
                        {
                            WaitFromColse();
                            MessageUtil.ShowTips("钢种不能为空！");
                            return;
                        }

                        if (dtStatus.Rows[0]["OUTS_BILLET_FL"].ToString().Equals(""))
                        {
                            WaitFromColse();
                            MessageUtil.ShowTips("是否外购不能为空！");
                            return;
                        }

                        ArrayList parms = new ArrayList();
                        ArrayList param = new ArrayList();
                        ArrayList paramPss = new ArrayList();
                        param.Add(uRow.Cells["DESGIN_KEY"].Value.ToString());
                        param.Add(CoreUserInfo.UserInfo.GetUserName());
                        param.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                        listPrc.Add(param);

                        //更新合同
                        //parms.Add(CoreUserInfo.UserInfo.GetUserName());
                        parms.Add(uRow.Cells["MEMO"].Value.ToString());
                        parms.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                        list.Add(parms);

                        paramPss.Add(dtStatus.Rows[0]["PLAN_NUM"].ToString());
                        paramPss.Add(dtStatus.Rows[0]["PLANWEIGHT"].ToString());
                        paramPss.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                        listPss.Add(paramPss);
                    }
                    else
                    {
                        WaitFromColse();
                        MessageUtil.ShowTips("合同" + uRow.Cells["ORDER_NO"].Value.ToString() + "/" +
                            uRow.Cells["ORDER_SEQ"].Value.ToString() + "还不能下发！");
                        return;
                    }
                }
                bool blsale = Convert.ToBoolean(ServerHelper.SetData("com.steering.pss.plan." +
                    "order.CoreSaleOrderOP.issuedSaleOrder", new object[] { list, listPrc, listPss }, this.ob));
                WaitFromColse();
                if (!blsale)
                {
                    MessageUtil.ShowError("下发失败！");
                    return;
                }
                MessageUtil.ShowTips("下发成功！");
            }
            catch (Exception ex)
            {
                WaitFromColse();
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            doQuery(GetQueryCondition());
        }

        /// <summary>
        /// 取消销售合同下发
        /// </summary>
        private void CancelSaleIssued()
        {
            try
            {
                ultraGrid1.UpdateData();
                ArrayList list = new ArrayList();
                ArrayList listOrder = new ArrayList();
                ArrayList listPss = new ArrayList();
                IQueryable<UltraGridRow> listRow = ultraGrid1.Rows.AsQueryable().Where(" CHECK = 'True'");
                if (listRow.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选合同！");
                    return;
                }
                WaitFromOpen();
                foreach(UltraGridRow uRow in listRow)
                {
                    ArrayList status = new ArrayList();
                    status.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.querySaleStatus",
                        new object[] { status }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        break;
                    }
                    if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("2")
                        || dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("3"))
                    {
                        ArrayList param = new ArrayList();
                        ArrayList paramOrder = new ArrayList();
                        ArrayList paramPss = new ArrayList();
                        param.Add(dtStatus.Rows[0]["MEMO"].ToString());
                        param.Add(dtStatus.Rows[0]["ORD_LN_DLY_PK"].ToString());
                        list.Add(param);

                        paramOrder.Add(dtStatus.Rows[0]["ORDER_NO"].ToString());
                        paramOrder.Add(dtStatus.Rows[0]["ORDER_SEQ"].ToString());
                        paramOrder.Add(dtStatus.Rows[0]["DELIVERY_NO"].ToString());
                        listOrder.Add(paramOrder);

                        //更新进程表
                        paramPss.Add("-" + dtStatus.Rows[0]["PLAN_NUM"].ToString());
                        paramPss.Add("-" + dtStatus.Rows[0]["PLANWEIGHT"].ToString());
                        paramPss.Add(uRow.Cells["ORD_LN_DLY_PK"].Value.ToString());
                        listPss.Add(paramPss);
                    }
                    else if (dtStatus.Rows[0]["PORDERSTATUS"].ToString().CompareTo("2") < 0)
                    {
                        WaitFromColse();
                        MessageUtil.ShowTips("合同" + uRow.Cells["ORDER_NO"].Value.ToString()
                            + "/" + uRow.Cells["ORDER_SEQ"].Value.ToString() + "还未下发！");
                        return;
                    }
                    else
                    {
                        WaitFromColse();
                        MessageUtil.ShowTips("合同" + uRow.Cells["ORDER_NO"].Value.ToString() + "/" +
                                uRow.Cells["ORDER_SEQ"].Value.ToString() + "已完成生产，无法撤消下发！");
                        return;
                    }
                }

                int succed = ServerHelper.SetData("com.steering.pss.plan.order.CoreSaleOrderOP.cancelSaleIssued",
                    new object[] { list, listOrder, listPss }, this.ob);
                WaitFromColse();
                if (succed < 0)
                {
                    MessageUtil.ShowTips("取消下发失败！");
                    return;
                }
                else
                {
                    MessageUtil.ShowTips("取消下发成功！");
                }
            }
            catch (Exception ex)
            {
                WaitFromColse();
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            doQuery(GetQueryCondition());
        }

        /// <summary>
        /// 接箍合同下发
        /// </summary>
        private void OrderJgIssued()
        {
            try
            {
                bool isChecked = false;
                ArrayList list = new ArrayList();
                foreach (UltraGridRow uRow in ultraGrid2.Rows)
                {
                    if (Convert.ToBoolean(uRow.Cells["CHECK"].Text))
                    {
                        ArrayList parms = new ArrayList();
                        DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryJgbyOrderno",
                            new object[] { uRow.Cells["JG_ORDERNO"].Value.ToString() }, this.ob);
                        if (dt == null && dt.Rows.Count <= 0)
                        {
                            break;
                        }
                        isChecked = true;
                        if (dt.Rows[0]["JGORDERSTATUS"].ToString().Equals("1"))
                        {
                            parms.Add("2");
                            parms.Add(DateTime.Now.ToString("yyyy/MM/dd"));
                            parms.Add(uRow.Cells["JG_ORDERNO"].Value.ToString());
                            list.Add(parms);
                        }
                        else if (dt.Rows[0]["JGORDERSTATUS"].ToString().CompareTo("1") < 0)
                        {
                            MessageUtil.ShowTips("接箍合同" + uRow.Cells["JG_ORDERNO"].Value.ToString()
                                + "未完成配料！");
                            return;
                        }
                        else 
                        {
                            MessageUtil.ShowTips("接箍合同" + uRow.Cells["JG_ORDERNO"].Value.ToString()
                                + "已经下发过了！");
                            return;
                        }
                    }
                }
                if (isChecked)
                {
                    int result = ServerHelper.SetData("com.steering.pss.plan.order.CoreSaleOrderOP.issuedJgOrder",
                            new object[] { list }, this.ob);
                    if (Convert.ToBoolean(result))
                    {
                        Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("下发成功！");
                    }
                }
                else
                {
                    Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("请勾选您要下发的接箍合同！");
                    return;
                }
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            doQuery(GetQueryCondition());
        }

        /// <summary>
        /// 接箍合同取消下发
        /// </summary>
        private void CancelJgIssued() 
        {
            try
            {
                ultraGrid2.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkedRows = ultraGrid2.Rows.AsQueryable().Where("CHECK = 'True'");
                if (checkedRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选要取消下发的接箍合同！");
                    return;
                }
                foreach (UltraGridRow uRow in checkedRows)
                {
                    ArrayList param = new ArrayList();
                    DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryJgbyOrderno",
                            new object[] { uRow.Cells["JG_ORDERNO"].Value.ToString() }, this.ob);
                    if (dt == null && dt.Rows.Count <= 0)
                    {
                        break;
                    }
                    if (dt.Rows[0]["JGORDERSTATUS"].ToString().CompareTo("2") < 0)
                    {
                        MessageUtil.ShowTips("接箍合同" + uRow.Cells["JG_ORDERNO"].Value.ToString()
                                + "还未下发！");
                        return;
                    }
                    param.Add(uRow.Cells["JG_ORDERNO"].Value.ToString());
                    list.Add(param);
                }
                int succed = ServerHelper.SetData("com.steering.pss.plan.order.CoreSaleOrderOP.cancelJgIssued",
                    new object[] { list }, this.ob);
                if (succed > 0)
                {
                    MessageUtil.ShowTips("取消下发成功！");
                }
                else
                {
                    MessageUtil.ShowTips("取消下发失败！");
                }
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            doQuery(GetQueryCondition());
        }

        /// <summary>
        /// 备料取消下发
        /// </summary>
        private void CancelBlIssued(UltraGrid ugrid)
        {
            try
            {
                ugrid.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkedRows = ugrid.Rows.AsQueryable().Where("CHECK = 'True'");
                if (checkedRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选要取消下发的备料！");
                    return;
                }
                foreach (UltraGridRow uRow in checkedRows)
                {
                    ArrayList param = new ArrayList();
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryBLbyReqBlId",
                                new object[] { uRow.Cells["REQ_BL_ID"].Value.ToString() }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        break;
                    }
                    if (dtStatus.Rows[0]["PLANSTATUS"].ToString().CompareTo("1") < 0)
                    {
                        MessageUtil.ShowTips("备料" + uRow.Cells["REQ_BL_ID"].Value.ToString()
                            + "未下发，不能取消下发！");
                        return;
                    }
                    param.Add(uRow.Cells["REQ_BL_ID"].Value.ToString());
                    list.Add(param);
                }
                int succed = ServerHelper.SetData("com.steering.pss.plan.order.CoreSaleOrderOP.cancelBlIssued",
                    new object[] { list }, this.ob);
                if (succed > 0)
                {
                    MessageUtil.ShowTips("取消下发成功！");
                }
                else 
                {
                    MessageUtil.ShowTips("取消下发失败！");
                }
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            if (ugrid != ultraGrid3)
            {
                QueryJGl();
            }
            else
            {
                doQuery(GetQueryCondition());
            }
        }

        /// <summary>
        /// 备料需求下发
        /// </summary>
        private void IssuedBlNeed(UltraGrid ugrid)
        {
            try
            {
                ugrid.UpdateData();
                ArrayList list = new ArrayList();
                IQueryable<UltraGridRow> checkedRows = ugrid.Rows.AsQueryable().Where("CHECK = 'True'");
                if (checkedRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选要下发的备料！");
                    return;
                }
                foreach (UltraGridRow uRow in checkedRows)
                {
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryBLbyReqBlId",
                        new object[] { uRow.Cells["REQ_BL_ID"].Value.ToString() }, this.ob);
                    if (dtStatus == null || dtStatus.Rows.Count <= 0)
                    {
                        break;
                    }
                    if (dtStatus.Rows[0]["PLANSTATUS"].ToString().CompareTo("0") > 0)
                    {
                        MessageUtil.ShowTips("备料" + uRow.Cells["REQ_BL_ID"].Value.ToString()
                            + "已经下发过了！");
                        return;
                    }
                    #region 判断是否可以下发
                    if (uRow.Cells["JGBL_REQ_WEIGHT"].Value.ToString().Equals("0"))
                    {
                        Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("短节备料"
                            + uRow.Cells["REQ_BL_ID"].Value.ToString() + "需求量未知！");
                        return;
                    }
                    if (!dtStatus.Rows[0]["IF_ALLOW_ISSUE"].ToString().Equals("1"))
                    {
                        MessageUtil.ShowTips("需求" + uRow.Cells["REQ_BL_ID"].Value.ToString()
                            + "还不可以下发！");
                        return;
                    }
                    #endregion
                    ArrayList parms = new ArrayList();
                    parms.Add(uRow.Cells["REQ_BL_ID"].Value.ToString());
                    list.Add(parms);
                }
                if (!Convert.ToBoolean(ServerHelper.SetData("com.steering.pss.plan.order." +
                        "CoreSaleOrderOP.issuedJglNeed", new object[] { list }, this.ob)))
                {
                    MessageUtil.ShowTips("下发失败！");
                    return;
                }
                MessageUtil.ShowTips("下发成功！");
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }

            if (ugrid != ultraGrid3)
            {
                QueryJGl();
            }
            else
            {
                doQuery(GetQueryCondition());
            }
        }

        /// <summary>
        /// 通过合同行查询销售合同
        /// </summary>
        /// <param name="order_no">合同号</param>
        /// <param name="order_seq">合同行</param>
        /// <param name="delivery_no">交货编码</param>
        /// <returns>销售合同</returns>
        private DataTable QuerySaleByPrimary(string order_no, string order_seq, string delivery_no)
        {
            try
            {
                ArrayList parms = new ArrayList();
                parms.Add(order_no);
                parms.Add(order_seq);
                parms.Add(delivery_no);
                DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.querySaleByPrimary",
                                new object[] { parms }, this.ob);
                return dt;
            }
            catch
            {
                return null;
            }
        }

        /// <summary>
        /// 查询BOM信息
        /// </summary>
        /// <param name="ugr"></param>
        private void setOrderBominf(UltraGridRow ugr)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreOrderDesignBom.getDesignBomInf",
                new object[] { ugr.Cells["BOM"].Value.ToString() }, this.ob);
            if (dt != null && dt.Rows.Count > 0)
            {
                ugr.Cells["GROUP_ROLL_ALL"].Value = dt.Rows[0]["D_PLINE"].ToString();
                ugr.Cells["GRADECODE"].Value = dt.Rows[0]["GRADECODE"].ToString();

                ugr.Cells["E_IN_MATERIAL_DESC"].Value = dt.Rows[0]["E_IN_MATERIAL_DESC"].ToString();
                ugr.Cells["E_IN_MATERIAL_NO"].Value = dt.Rows[0]["E_IN_MATERIAL_NO"].ToString();
                ugr.Cells["DIMATER_YLG"].Value = dt.Rows[0]["DIMATER"].ToString();
                ugr.Cells["HEIGHT_YLG"].Value = dt.Rows[0]["HEIGHT"].ToString();

                //查询控制壁厚
                double dimater = 0;
                double height = 0;
                if (double.TryParse(dt.Rows[0]["DIMATER"].ToString(), out dimater)
                    && double.TryParse(dt.Rows[0]["HEIGHT"].ToString(), out height))
                {
                    ToleranceNk tolerance = new ToleranceNk(this.ob);
                    tolerance.Outdiameter = dimater;
                    tolerance.Wallthick = height;
                    tolerance.Lengthmin = Convert.ToDouble(ugr.Cells["LENGTHMIN"].Value);
                    tolerance.Lengthmax = Convert.ToDouble(ugr.Cells["LENGTHMAX"].Value);
                    tolerance.Sic = "";
                    tolerance.BaseCode = "404002";
                    if (!tolerance.Sic.Equals(""))
                    {
                        tolerance.getToleranceOfNk();
                    }

                    ugr.Cells["HEIGHT_NK_MIN"].Value = tolerance.Lower.ToString();
                    ugr.Cells["HEIGHT_NK_MAX"].Value = tolerance.Upper.ToString();
                    ugr.Cells["AIMWALLTHICK_ZG"].Value = ((tolerance.Wallthick + (
                        tolerance.Upper - tolerance.Lower) / 2).ToString());
                }
                                    

                #region 判断坯料的属性
                string dinMaterial = "";
                ///轧管投入物料(炼钢末工序产出物料)
                if (!dt.Rows[0]["D_IN_MATERIAL_NO"].ToString().Equals(""))
                {
                    dinMaterial = dt.Rows[0]["D_IN_MATERIAL_NO"].ToString();
                }
                else if (!dt.Rows[0]["C_OUT_MATERIAL_NO"].ToString().Equals(""))
                {
                    dinMaterial = dt.Rows[0]["C_OUT_MATERIAL_NO"].ToString();
                }
                else if (!dt.Rows[0]["B_OUT_MATERIAL_NO"].ToString().Equals(""))
                {
                    dinMaterial = dt.Rows[0]["B_OUT_MATERIAL_NO"].ToString();
                }
                else
                {
                    dinMaterial = dt.Rows[0]["A_OUT_MATERIAL_NO"].ToString();
                }
                ugr.Cells["STUFF_PROPERTY"].Value = stuffProperty(dinMaterial);
                #endregion

                #region 过滤轧管产线
                ArrayList paramPline = new ArrayList();
                paramPline.Add(ugr.Cells["FINAL_USER"].Value.ToString());
                paramPline.Add(ugr.Cells["PRODUCCODE"].Value.ToString());
                paramPline.Add(dt.Rows[0]["D_IN_MATERIAL_NO"].ToString());
                paramPline.Add(dt.Rows[0]["D_OUT_MATERIAL_NO"].ToString());
                paramPline.Add(ugr.Cells["DESGIN_KEY"].Value.ToString());
                paramPline.Add(ugr.Cells["INDEX_SEQ"].Value.ToString());
                DataTable dtDpl = ServerHelper.GetData("com.steering.pss.plan.order.CoreOrderDesignBom.getBomMaterialDpl",
                    new object[] { paramPline }, this.ob);
                if (dtDpl != null)
                {
                    ValueList valueList = PlanComm.GeneralValuelist(ref dtDpl, "PLINE_CODE", "PLINE_NAME");
                    ugr.Cells["GROUP_ROLL"].ValueList = valueList;
                    if (dtDpl.Rows.Count > 0 && !PlanComm.isInDataTable(dtDpl, "PLINE_CODE",
                        ugr.Cells["GROUP_ROLL"].Value.ToString()))
                    {
                        //如果存在ASSEL机组,优选ASSEL机组
                        //string orderHead = ugr.Cells["ORDER_NO"].Value.ToString().Substring(0, 1);
                        if (PlanComm.isInDataTable(dtDpl, "PLINE_CODE", "C012")
                            && queryAsselFl(ugr.Cells["ORD_LN_PK"].Value.ToString(), this.ob))
                        {
                            ugr.Cells["GROUP_ROLL"].Value = "C012";
                        }
                        else
                        {
                            ugr.Cells["GROUP_ROLL"].Value = dtDpl.Rows[0]["PLINE_CODE"].ToString();
                        }
                    }
                }
                #endregion
            }
        }

        /// <summary>
        /// 查询是否Assel机组
        /// </summary>
        /// <param name="ordLnPk"></param>
        /// <returns></returns>
        public static bool queryAsselFl(string ordLnPk, OpeBase _ob)
        {
            bool isAssel = false;
            DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryAsselFl",
                new object[] { ordLnPk }, _ob);
            if (dt != null && dt.Rows.Count > 0)
            {
                if (dt.Rows[0]["ASSEL_FL"].ToString().Trim().Equals("1"))
                {
                    isAssel = true;
                }
            }
            return isAssel;
        }

        /// <summary>
        /// 更改制程
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid1_CellChange(object sender, CellEventArgs e)
        {
            if (e.Cell.Column.Key.Equals("INDEX_SEQ") && e.Cell.Row.Cells["INDEX_SEQ"].DataChanged)
            {
                e.Cell.Row.Update();
                ArrayList status = new ArrayList();
                status.Add(e.Cell.Row.Cells["ORD_LN_DLY_PK"].Value.ToString());
                DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.querySaleStatus",
                    new object[] { status }, this.ob);
                if (dtStatus == null || dtStatus.Rows.Count <= 0)
                {
                    return;
                }
                if (!dtStatus.Rows[0]["INDEX_SEQ"].ToString().Equals(
                    e.Cell.Row.Cells["INDEX_SEQ"].Value.ToString())
                    && dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("1"))
                {
                    ArrayList param = new ArrayList();
                    if (MessageUtil.ShowYesNoAndWarning("是否修改合同制程？") == DialogResult.No)
                    {
                        e.Cell.Row.Cells["INDEX_SEQ"].Value = dtStatus.Rows[0]["INDEX_SEQ"].ToString();
                        return;
                    }
                    SaleIndexTo(e.Cell.Row);

                    //BOM更新
                    param.Add(e.Cell.Row.Cells["INDEX_SEQ"].Value.ToString());
                    param.Add(e.Cell.Row.Cells["MSC"].Value.ToString());
                    param.Add(e.Cell.Row.Cells["MATERIAL_NO"].Value.ToString());
                    DataTable dtBom = ServerHelper.GetData("com.steering.pss.plan.order.CoreOrderDesignBom.getOrdMscBom",
                        new object[] { param }, this.ob);
                    if (dtBom != null && dtBom.Rows.Count > 0)
                    {
                        string dinMaterial = "";
                        #region 可选钢种
                        string gradeAll = "";
                        ArrayList arr = new ArrayList();
                        foreach (DataRow dr in dtBom.Rows)
                        {
                            if (!arr.Contains(dr["GRADENAME"].ToString()))
                            {
                                arr.Add(dr["GRADENAME"].ToString());
                                gradeAll += dr["GRADENAME"].ToString() + ",";
                            }
                        }
                        if (!gradeAll.Equals("") && gradeAll.Length > 1)
                        {
                            gradeAll = gradeAll.Substring(0, gradeAll.Length - 1);
                        }
                        #endregion

                        e.Cell.Row.Cells["BOM"].Value = dtBom.Rows[0]["BOM"].ToString();
                        e.Cell.Row.Cells["GROUP_ROLL_ALL"].Value = dtBom.Rows[0]["D_PLINE"].ToString();
                        e.Cell.Row.Cells["GRADECODE"].Value = dtBom.Rows[0]["GRADECODE"].ToString();
                        e.Cell.Row.Cells["GRADECODE_ALL"].Value = gradeAll;

                        e.Cell.Row.Cells["E_IN_MATERIAL_DESC"].Value = dtBom.Rows[0]["E_IN_MATERIAL_DESC"].ToString();
                        e.Cell.Row.Cells["E_IN_MATERIAL_NO"].Value = dtBom.Rows[0]["E_IN_MATERIAL_NO"].ToString();
                        e.Cell.Row.Cells["DIMATER_YLG"].Value = dtBom.Rows[0]["DIMATER"].ToString();
                        e.Cell.Row.Cells["HEIGHT_YLG"].Value = dtBom.Rows[0]["HEIGHT"].ToString();

                        //查询控制壁厚
                        double dimater = 0;
                        double height = 0;
                        if (double.TryParse(dtBom.Rows[0]["DIMATER"].ToString(), out dimater)
                            && double.TryParse(dtBom.Rows[0]["HEIGHT"].ToString(), out height))
                        {
                            ToleranceNk tolerance = new ToleranceNk(this.ob);
                            tolerance.Outdiameter = dimater;
                            tolerance.Wallthick = height;
                            tolerance.Lengthmin = Convert.ToDouble(e.Cell.Row.Cells["LENGTHMIN"].Value);
                            tolerance.Lengthmax = Convert.ToDouble(e.Cell.Row.Cells["LENGTHMAX"].Value);
                            tolerance.Sic = "";
                            tolerance.BaseCode = "404002";
                            if (!tolerance.Sic.Equals(""))
                            {
                                tolerance.getToleranceOfNk();
                            }

                            e.Cell.Row.Cells["HEIGHT_NK_MIN"].Value = tolerance.Lower.ToString();
                            e.Cell.Row.Cells["HEIGHT_NK_MAX"].Value = tolerance.Upper.ToString();
                            e.Cell.Row.Cells["AIMWALLTHICK_ZG"].Value = ((tolerance.Wallthick + (
                                tolerance.Upper - tolerance.Lower) / 2).ToString());
                        }

                        #region 判断坯料的属性
                        ///轧管投入物料(炼钢末工序产出物料)
                        if (!dtBom.Rows[0]["D_IN_MATERIAL_NO"].ToString().Equals(""))
                        {
                            dinMaterial = dtBom.Rows[0]["D_IN_MATERIAL_NO"].ToString();
                        }
                        else if (!dtBom.Rows[0]["C_OUT_MATERIAL_NO"].ToString().Equals(""))
                        {
                            dinMaterial = dtBom.Rows[0]["C_OUT_MATERIAL_NO"].ToString();
                        }
                        else if (!dtBom.Rows[0]["B_OUT_MATERIAL_NO"].ToString().Equals(""))
                        {
                            dinMaterial = dtBom.Rows[0]["B_OUT_MATERIAL_NO"].ToString();
                        }
                        else
                        {
                            dinMaterial = dtBom.Rows[0]["A_OUT_MATERIAL_NO"].ToString();
                        }
                        e.Cell.Row.Cells["STUFF_PROPERTY"].Value = stuffProperty(dinMaterial);
                        #endregion

                        #region 过滤轧管产线
                        ArrayList paramPline = new ArrayList();
                        paramPline.Add(e.Cell.Row.Cells["FINAL_USER"].Value.ToString());
                        paramPline.Add(e.Cell.Row.Cells["PRODUCCODE"].Value.ToString());
                        paramPline.Add(dtBom.Rows[0]["D_IN_MATERIAL_NO"].ToString());
                        paramPline.Add(dtBom.Rows[0]["D_OUT_MATERIAL_NO"].ToString());
                        paramPline.Add(e.Cell.Row.Cells["DESGIN_KEY"].Value.ToString());
                        paramPline.Add(e.Cell.Row.Cells["INDEX_SEQ"].Value.ToString());
                        DataTable dtDpl = ServerHelper.GetData("com.steering.pss.plan.order.CoreOrderDesignBom.getBomMaterialDpl",
                            new object[] { paramPline }, this.ob);
                        if (dtDpl != null)
                        {
                            ValueList valueList = PlanComm.GeneralValuelist(ref dtDpl, "PLINE_CODE", "PLINE_NAME");
                            e.Cell.Row.Cells["GROUP_ROLL"].ValueList = valueList;

                            if (dtDpl.Rows.Count > 0 && !PlanComm.isInDataTable(dtDpl, "PLINE_CODE",
                            e.Cell.Row.Cells["GROUP_ROLL"].Value.ToString()))
                            {
                                //如果存在ASSEL机组,优选ASSEL机组
                                //string orderHead = e.Cell.Row.Cells["ORDER_NO"].Value.ToString().Substring(0, 1);
                                if (PlanComm.isInDataTable(dtDpl, "PLINE_CODE", "C012")
                                    && queryAsselFl(e.Cell.Row.Cells["ORD_LN_PK"].Value.ToString(), this.ob))
                                {
                                    e.Cell.Row.Cells["GROUP_ROLL"].Value = "C012";
                                }
                                else
                                {
                                    e.Cell.Row.Cells["GROUP_ROLL"].Value = dtDpl.Rows[0]["PLINE_CODE"].ToString();
                                }
                            }
                        }
                        #endregion
                    }
                    //保存更新
                    saveIndexChange(e.Cell.Row);
                }
            }
        }

        /// <summary>
        /// 随制程变化信息
        /// </summary>
        /// <param name="uRow">销售合同行</param>
        private void SaleIndexTo(UltraGridRow uRow)
        {
            bool blJGX = false;
            bool blRCL = false;
            bool blBJ = false;
            string desgin_key = uRow.Cells["DESGIN_KEY"].Value.ToString();
            string processSeq = "";     //全程途径码

            #region 根据制程查询全程途经工序
            ArrayList param= new ArrayList();
            param.Add(desgin_key);
            param.Add(uRow.Cells["INDEX_SEQ"].Value.ToString());
            DataTable dtProcess = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryMscplPrc",
            new object[] { param }, this.ob);
            if (dtProcess != null && dtProcess.Rows.Count > 0)
            {
                string endgxCode = "";      ///末工序代码
                string gprocessC = "";      //加工二级工序
                string fprocessC = "";      //热处理二级工序
                foreach (DataRow dr in dtProcess.Rows)
                {
                    if (dr["PROCESS_CODE"].ToString().Equals("G"))
                    {
                        ///经过加工工序
                        blJGX = true;
                        gprocessC = dr["PROCESS_CODE_C"].ToString();
                        if (uRow.Cells["GROUP_JGX"].Value.ToString().Equals("/"))
                        {
                            uRow.Cells["GROUP_JGX"].Value = "";
                        }

                        ////加工组
                        FrmDefGroup gourpJgx = new FrmDefGroup(this.ob);
                        gourpJgx.Outdiameter = Convert.ToDouble(uRow.Cells["OUTDIAMETER"].Value);
                        gourpJgx.ModelCode = uRow.Cells["MODEL_CODE"].Value.ToString();
                        gourpJgx.defgourpJgc();
                        uRow.Cells["GROUP_JGX"].Value = gourpJgx.GroupJgx;
                    }
                    if (dr["PROCESS_CODE"].ToString().Equals("F"))
                    {
                        ///经过热处理工序
                        blRCL = true;
                        fprocessC = dr["PROCESS_CODE_C"].ToString();
                        if (uRow.Cells["GROUP_RCL"].Value.ToString().Equals("/"))
                        {
                            uRow.Cells["GROUP_RCL"].Value = "";
                        }

                        ////热处理组
                        FrmDefGroup gourRcl = new FrmDefGroup(this.ob);
                        gourRcl.Outdiameter = Convert.ToDouble(uRow.Cells["OUTDIAMETER"].Value);
                        gourRcl.Wallthick = Convert.ToDouble(uRow.Cells["WALLTHICK"].Value);
                        gourRcl.Lengthmax = Convert.ToDouble(uRow.Cells["LENGTHMAX"].Value);
                        gourRcl.ModelCode = uRow.Cells["MODEL_CODE"].Value.ToString();
                        gourRcl.ProcessC = dr["PROCESS_CODE_C"].ToString();
                        gourRcl.defgourpRcl();
                        uRow.Cells["GROUP_RCL"].Value = gourRcl.GroupRcl;
                    }
                    if (dr["PROCESS_CODE"].ToString().Equals("E"))
                    {
                        ///经过镦拔扩工序
                        blBJ = true;
                        uRow.Cells["BJ_TYPE"].Value = dr["PROCESS_DESC_C"].ToString();
                    }
                }

                ///成品工序号
                string wholeDesc = dtProcess.Rows[0]["WHOLE_BACKLOG_DESC"].ToString();
                processSeq = dtProcess.Rows[0]["WHOLE_BACKLOG"].ToString();
                endgxCode = processSeq.Substring(processSeq.Length - 1);
                uRow.Cells["ENDGXNAME"].Value = wholeDesc.Substring(wholeDesc.LastIndexOf('-') + 1,
                    wholeDesc.Length - wholeDesc.LastIndexOf('-') - 1);

                ///生产分类
                uRow.Cells["PRODUCE_SORT"].Value = produceSort(endgxCode,
                    uRow.Cells["PRD_CLS"].Value.ToString(), gprocessC, fprocessC);
            }
            if (!blJGX)
            {
                uRow.Cells["GROUP_JGX"].Value = "/";
            }
            if (!blRCL)
            {
                uRow.Cells["GROUP_RCL"].Value = "/";
            }
            if (!blBJ)
            {
                uRow.Cells["BJ_TYPE"].Value = "/";
            }
            #endregion

            //查询监制要求
            DataTable dtLinePrdcr = queryLinePrdcr(uRow.Cells["PRDCR_NO"].Value.ToString(),
                uRow.Cells["INDEX_SEQ"].Value.ToString());
            if (dtLinePrdcr != null && dtLinePrdcr.Rows.Count > 0)
            {
                uRow.Cells["MONITORDEMAND"].Value = dtLinePrdcr.Rows[0]["PRDCR_DESC"].ToString();
            }
            uRow.Cells["PROCESS_SEQ"].Value = processSeq;
        }

        /// <summary>
        /// bom选择
        /// </summary>
        private void setOrderBom()
        {
            UltraGridRow ugr = ultraGrid1.ActiveRow;
            if (ugr == null)
            {
                return;
            }
            
            ///查询合同状态
            ArrayList status = new ArrayList();
            status.Add(ugr.Cells["ORD_LN_DLY_PK"].Value.ToString());
            DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.querySaleStatus",
                new object[] { status }, this.ob);
            if (dtStatus == null || dtStatus.Rows.Count <= 0)
            {
                return;
            }
            if (!dtStatus.Rows[0]["PORDERSTATUS"].ToString().Equals("1"))
            {
                return;
            }

            FrmDesginBom bom = new FrmDesginBom(this.ob, dtStatus.Rows[0]["BOM"].ToString());
            bom.MscPline = dtStatus.Rows[0]["INDEX_SEQ"].ToString();
            bom.Msc = dtStatus.Rows[0]["MSC"].ToString();
            bom.MaterialNo = dtStatus.Rows[0]["MATERIAL_NO"].ToString();

            bom.DesignKey = ugr.Cells["DESGIN_KEY"].Value.ToString();
            bom.WholeBacklog = dtStatus.Rows[0]["PROCESS_SEQ"].ToString();
            bom.Outdiameter = dtStatus.Rows[0]["OUTDIAMETER"].ToString();
            bom.Wallthick = dtStatus.Rows[0]["WALLTHICK"].ToString();
            bom.SpecCode = dtStatus.Rows[0]["SPEC_CODE"].ToString();
            bom.SpecName = dtStatus.Rows[0]["SPEC_NAME"].ToString();

            if (dtStatus.Rows[0]["E_IS_OK"].ToString().Equals("1"))
            {
                if (!this.CustomInfo.ToString().Trim().Equals("")
                        && !this.CustomInfo.ToString().Trim().Equals("@BJ"))
                {
                    //镦拔扩投入规格确定，过滤可选bom
                    bom.EInMaterial = dtStatus.Rows[0]["E_IN_MATERIAL_NO"].ToString();
                }
            }

            if (dtStatus.Rows[0]["GRADECODE_IS_OK"].ToString().Equals("1"))
            {
                if (!this.CustomInfo.ToString().Trim().Equals("")
                        && !this.CustomInfo.ToString().Trim().Equals("@GRADE"))
                {
                    //钢种坯料确定后，bom确定
                    bom.StrBom = dtStatus.Rows[0]["BOM"].ToString();
                }
            }

            if (this.CustomInfo.Equals("@BJ") || this.CustomInfo.Equals(""))
            {
                bom.setButtonAddZgSepcShow(true);
            }
            bom.ShowDialog();
            if (bom.Ugr != null)
            {
                ArrayList param = new ArrayList();
                ugr.Cells["BOM"].Value = bom.Ugr.Cells["Bom"].Value.ToString();
                ugr.Cells["GROUP_ROLL_ALL"].Value = bom.Ugr.Cells["DPline"].Value.ToString();
                ugr.Cells["GRADECODE_ALL"].Value = bom.GradeAll;
                ugr.Cells["GRADECODE"].Value = bom.Ugr.Cells["Gradecode"].Value.ToString();

                ugr.Cells["E_IN_MATERIAL_DESC"].Value = bom.Ugr.Cells["EInMaterialDesc"].Value.ToString();
                ugr.Cells["E_IN_MATERIAL_NO"].Value = bom.Ugr.Cells["EInMaterialNo"].Value.ToString();
                ugr.Cells["DIMATER_YLG"].Value = bom.Ugr.Cells["Dimater"].Value.ToString();
                ugr.Cells["HEIGHT_YLG"].Value = bom.Ugr.Cells["Height"].Value.ToString();

                //查询控制壁厚
                double dimater = 0;
                double height = 0;
                if (double.TryParse(bom.Ugr.Cells["Dimater"].Value.ToString(), out dimater)
                    && double.TryParse(bom.Ugr.Cells["Height"].Value.ToString(), out height))
                {
                    ToleranceNk tolerance = new ToleranceNk(this.ob);
                    tolerance.Outdiameter = dimater;
                    tolerance.Wallthick = height;
                    tolerance.Lengthmin = Convert.ToDouble(ugr.Cells["LENGTHMIN"].Value);
                    tolerance.Lengthmax = Convert.ToDouble(ugr.Cells["LENGTHMAX"].Value);
                    tolerance.Sic = "";
                    tolerance.BaseCode = "404002";
                    if (!tolerance.Sic.Equals(""))
                    {
                        tolerance.getToleranceOfNk();
                    }

                    ugr.Cells["HEIGHT_NK_MIN"].Value = tolerance.Lower.ToString();
                    ugr.Cells["HEIGHT_NK_MAX"].Value = tolerance.Upper.ToString();
                    ugr.Cells["AIMWALLTHICK_ZG"].Value = ((tolerance.Wallthick + (
                        tolerance.Upper - tolerance.Lower) / 2).ToString());
                }

                #region 判断坯料的属性
                string dinMaterial = "";
                ///轧管投入物料(炼钢末工序产出物料)
                if (!bom.Ugr.Cells["dInMaterialNo"].Value.ToString().Equals(""))
                {
                    dinMaterial = bom.Ugr.Cells["dInMaterialNo"].Value.ToString();
                }
                else if (!bom.Ugr.Cells["COutMaterialNo"].Value.ToString().Equals(""))
                {
                    dinMaterial = bom.Ugr.Cells["COutMaterialNo"].Value.ToString();
                }
                else if (!bom.Ugr.Cells["BOutMaterialNo"].Value.ToString().Equals(""))
                {
                    dinMaterial = bom.Ugr.Cells["BOutMaterialNo"].Value.ToString();
                }
                else
                {
                    dinMaterial = bom.Ugr.Cells["AOutMaterialNo"].Value.ToString();
                }
                ugr.Cells["STUFF_PROPERTY"].Value = stuffProperty(dinMaterial);
                #endregion

                #region 过滤轧管产线
                ArrayList paramPline = new ArrayList();
                paramPline.Add(ugr.Cells["FINAL_USER"].Value.ToString());
                paramPline.Add(ugr.Cells["PRODUCCODE"].Value.ToString());
                paramPline.Add(bom.Ugr.Cells["DInMaterialNo"].Value.ToString());
                paramPline.Add(bom.Ugr.Cells["DOutMaterialNo"].Value.ToString());
                paramPline.Add(ugr.Cells["DESGIN_KEY"].Value.ToString());
                paramPline.Add(ugr.Cells["INDEX_SEQ"].Value.ToString());
                DataTable dtDpl = ServerHelper.GetData("com.steering.pss.plan.order.CoreOrderDesignBom.getBomMaterialDpl",
                    new object[] { paramPline }, this.ob);
                if (dtDpl != null)
                {
                    ValueList valueList = PlanComm.GeneralValuelist(ref dtDpl, "PLINE_CODE", "PLINE_NAME");
                    ugr.Cells["GROUP_ROLL"].ValueList = valueList;

                    if (dtDpl.Rows.Count > 0 && !PlanComm.isInDataTable(dtDpl, "PLINE_CODE",
                    ugr.Cells["GROUP_ROLL"].Value.ToString()))
                    {
                        //如果存在ASSEL机组,优选ASSEL机组
                        //string orderHead = ugr.Cells["ORDER_NO"].Value.ToString().Substring(0, 1);
                        if (PlanComm.isInDataTable(dtDpl, "PLINE_CODE", "C012")
                           && queryAsselFl(ugr.Cells["ORD_LN_PK"].Value.ToString(), this.ob))
                        {
                            ugr.Cells["GROUP_ROLL"].Value = "C012";
                        }
                        else
                        {
                            ugr.Cells["GROUP_ROLL"].Value = dtDpl.Rows[0]["PLINE_CODE"].ToString();
                        }
                    }
                }
                #endregion

                param.Add(bom.Ugr.Cells["Bom"].Value.ToString());
                param.Add(bom.Ugr.Cells["EInMaterialNo"].Value.ToString());
                param.Add(bom.Ugr.Cells["EInMaterialDesc"].Value.ToString());
                param.Add(bom.Ugr.Cells["Dimater"].Value.ToString());
                param.Add(bom.Ugr.Cells["Height"].Value.ToString());
                param.Add(ugr.Cells["HEIGHT_NK_MIN"].Value.ToString());
                param.Add(ugr.Cells["HEIGHT_NK_MAX"].Value.ToString());
                param.Add(ugr.Cells["AIMWALLTHICK_ZG"].Value.ToString());

                param.Add(bom.Ugr.Cells["DPline"].Value.ToString());
                param.Add(ugr.Cells["GROUP_ROLL"].Value.ToString());
                param.Add(bom.GradeAll);
                param.Add(bom.Ugr.Cells["Gradecode"].Value.ToString());
                param.Add(ugr.Cells["STUFF_PROPERTY"].Value.ToString());

                param.Add(ugr.Cells["ORD_LN_DLY_PK"].Value.ToString());
                ServerHelper.SetData("com.steering.pss.plan.order.CoreOrderDesignBom.setSaleOrderBom",
                    new object[] { param }, this.ob);
            }
        }

        /// <summary>
        /// 制程更改后的信息
        /// </summary>
        private void saveIndexChange(UltraGridRow ugr)
        {
            ArrayList param = new ArrayList();
            param.Add(ugr.Cells["INDEX_SEQ"].Value.ToString());
            param.Add(ugr.Cells["BOM"].Value.ToString());
            param.Add(ugr.Cells["GROUP_JGX"].Value.ToString());
            param.Add(ugr.Cells["GROUP_RCL"].Value.ToString());
            param.Add(ugr.Cells["BJ_TYPE"].Value.ToString());
            param.Add(ugr.Cells["ENDGXNAME"].Value.ToString());
            param.Add(ugr.Cells["PROCESS_SEQ"].Value.ToString());
            param.Add(ugr.Cells["PRODUCE_SORT"].Value.ToString());

            param.Add(ugr.Cells["E_IN_MATERIAL_NO"].Value.ToString());
            param.Add(ugr.Cells["E_IN_MATERIAL_DESC"].Value.ToString());
            param.Add(ugr.Cells["DIMATER_YLG"].Value.ToString());
            param.Add(ugr.Cells["HEIGHT_YLG"].Value.ToString());
            param.Add(ugr.Cells["HEIGHT_NK_MIN"].Value.ToString());
            param.Add(ugr.Cells["HEIGHT_NK_MAX"].Value.ToString());
            param.Add(ugr.Cells["AIMWALLTHICK_ZG"].Value.ToString());

            param.Add(ugr.Cells["GROUP_ROLL_ALL"].Value.ToString());
            param.Add(ugr.Cells["GROUP_ROLL"].Value.ToString());
            param.Add(ugr.Cells["GRADECODE_ALL"].Value.ToString());
            param.Add(ugr.Cells["GRADECODE"].Value.ToString());

            param.Add(ugr.Cells["STUFF_PROPERTY"].Value.ToString());
            param.Add(ugr.Cells["MONITORDEMAND"].Value.ToString());   //监制要求

            #region 各工序信息确认
            if (ugr.Cells["PROCESS_SEQ"].Value.ToString().Contains("D"))
            {
                //判断是否经过轧管工序
                param.Add("0");
                ugr.Cells["D_IS_OK"].Value = "否";
            }
            else
            {
                param.Add("2");
                ugr.Cells["D_IS_OK"].Value = "/";
            }

            if (ugr.Cells["PROCESS_SEQ"].Value.ToString().Contains("E"))
            {
                //判断是否经过镦拔扩工序
                param.Add("0");
                ugr.Cells["E_IS_OK"].Value = "否";
            }
            else
            {
                param.Add("2");
                ugr.Cells["E_IS_OK"].Value = "/";
            }

            if (ugr.Cells["PROCESS_SEQ"].Value.ToString().Contains("F"))
            {
                //判断是否经过热处理工序
                param.Add("0");
                ugr.Cells["F_IS_OK"].Value = "否";
            }
            else
            {
                param.Add("2");
                ugr.Cells["F_IS_OK"].Value = "/";
            }

            if (ugr.Cells["PROCESS_SEQ"].Value.ToString().Contains("G"))
            {
                //判断是否经过管加工工序
                param.Add("0");
                ugr.Cells["G_IS_OK"].Value = "否";
            }
            else
            {
                param.Add("2");
                ugr.Cells["G_IS_OK"].Value = "/";
            }
            ugr.Cells["GRADECODE_IS_OK"].Value = "否";
            #endregion

            param.Add(ugr.Cells["ORD_LN_DLY_PK"].Value.ToString());

            ServerHelper.SetData("com.steering.pss.plan.order.CoreOrderDesignBom.setBomChanged",
                new object[] { param }, this.ob);
        }

        /// <summary>
        /// 生产分类
        /// </summary>
        /// <param name="endCode">末工序代码</param>
        /// <param name="prdcls">销售分类</param>
        /// <param name="gprocessC">加工二级工序</param>
        /// <returns></returns>
        private string produceSort(string endCode, string prdcls, string gprocessC,string fprocessC)
        {
            string produceSort = "";
            if (endCode.CompareTo("D") < 0)
            {
                produceSort = "商品坯";
            }
            else if (prdcls.Equals("405004") || prdcls.Equals("接箍短节"))
            {
                produceSort = "接箍短节";
            }
            else if (gprocessC.Equals("B020"))
            {
                produceSort = "加工油套管";
            }
            else if (endCode.Equals("D"))
            {
                produceSort = "热轧成品";
            }
            else if (endCode.Equals("F") && fprocessC.Equals("B024"))
            {
                produceSort = "热轧成品";
            }
            else
            {
                produceSort = "加工光管";
            }
            return produceSort;
        }

        /// <summary>
        /// 判断坯料属性
        /// </summary>
        /// <param name="DinMaterialno">轧管投入物料码</param>
        /// <returns>坯料属性</returns>
        private string stuffProperty(string DinMaterialno)
        {
            string stuffpro = "";
            if (!DinMaterialno.Equals("") && DinMaterialno.Length > 2)
            {
                switch (DinMaterialno.Substring(0, 2))
                {
                    case "PA":
                        stuffpro = "连铸坯";
                        break;
                    case "PB":
                        stuffpro = "锻坯";
                        break;
                    case "PC":
                        stuffpro = "轧坯";
                        break;
                }
            }
            return stuffpro;
        }

        /// <summary>
        /// 判断管属性
        /// </summary>
        /// <param name="DinMaterialno">成品物料码</param>
        /// <returns>管属性</returns>
        private string pipeProperty(string materialno)
        {
            string property = "";
            if (materialno != "" && materialno.Length > 2)
            {
                switch (materialno.Substring(0, 2))
                {
                    case "AW":
                        property = "热轧无缝成品管";
                        break;
                    case "AR":
                        property = "热扩无缝成品管";
                        break;
                    case "AL":
                        property = "冷拔无缝成品管";
                        break;
                    case "AH":
                        property = "焊缝成品管";
                        break;
                    case "AE":
                        property = "接箍/短接/附件";
                        break;
                    case "AP":
                        property = "商品坯";
                        break;
                }
            }
            return property;
        }

        /// <summary>
        /// 备料列数据变化时变化
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid3_AfterCellUpdate(object sender, CellEventArgs e)
        {
            #region 短节备料需求量、利库量填写时计算
            if (e.Cell.Column.Key == "JGBL_REQ_WEIGHT" && e.Cell.Row.Cells["JGBL_REQ_WEIGHT"].DataChanged)
            {
                double jgbl_req_weight = 0;
                int jgbl_req_num = 0;
                e.Cell.Row.Update();
                if (double.TryParse(e.Cell.Row.Cells["JGBL_REQ_WEIGHT"].Value.ToString(), out jgbl_req_weight))
                {
                    double singleweight = Convert.ToDouble(e.Cell.Row.Cells["SINGLEWEIGHT"].Value);
                    if ((jgbl_req_weight % singleweight) == 0)
                    {
                        jgbl_req_num = (int)(jgbl_req_weight / singleweight);
                    }
                    else
                    {
                        jgbl_req_num = (int)(jgbl_req_weight / singleweight) + 1;
                    }
                }
                else
                {
                    e.Cell.Row.Cells["JGBL_REQ_WEIGHT"].Value = "0";
                }
                e.Cell.Row.Cells["JGBL_REQ_NUM"].Value = jgbl_req_num.ToString();
                e.Cell.Row.Update();
            }
            if (e.Cell.Column.Key == "MATCHWEIGHT" && e.Cell.Row.Cells["MATCHWEIGHT"].DataChanged)
            {
                double jgbl_req_weight = 0;
                int jgbl_req_num = 0;
                e.Cell.Row.Update();
                if (double.TryParse(e.Cell.Row.Cells["MATCHWEIGHT"].Value.ToString(), out jgbl_req_weight))
                {
                    double singleweight = Convert.ToDouble(e.Cell.Row.Cells["SINGLEWEIGHT"].Value);
                    if ((jgbl_req_weight % singleweight) == 0)
                    {
                        jgbl_req_num = (int)(jgbl_req_weight / singleweight);
                    }
                    else
                    {
                        jgbl_req_num = (int)(jgbl_req_weight / singleweight) + 1;
                    }
                }
                else
                {
                    e.Cell.Row.Cells["MATCHWEIGHT"].Value = "0";
                }
                e.Cell.Row.Cells["MATCHNUM"].Value = jgbl_req_num.ToString();
                e.Cell.Row.Update();
            }
            #endregion
        }

        /// <summary>
        /// 接箍合同填写利库量
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid5_AfterCellUpdate(object sender, CellEventArgs e)
        {
            if (e.Cell.Column.Key == "MATCHNUM" && e.Cell.Row.Cells["MATCHNUM"].DataChanged)
            {
                int matchnum = 0;
                double singleweight = Convert.ToDouble(e.Cell.Row.Cells["SINGLEWEIGHT"].Value);//箍单重(kg)
                if (int.TryParse(e.Cell.Row.Cells["MATCHNUM"].Value.ToString(), out matchnum))
                {
                    e.Cell.Row.Cells["MATCHWEIGHT"].Value = (matchnum * singleweight / 1000).ToString();
                }
                else
                {
                    e.Cell.Row.Cells["MATCHNUM"].Value = "0";
                }
                e.Cell.Row.Update();
            }
        }

        /// <summary>
        /// 输入要做备料需求的接箍个数
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid7_AfterCellUpdate(object sender, CellEventArgs e)
        {
            if (e.Cell.Column.Key == "NUM_JG")
            {
                if (e.Cell.Row.Cells["NUM_JG"].DataChanged &&
                    Convert.ToBoolean(e.Cell.Row.Cells["CHECK"].Text))
                {
                    computJglLen(e.Cell.Row);
                    e.Cell.Row.Update();
                }
            }

            if (e.Cell.Column.Key.Equals("SINGLE_ADDLEN"))
            {
                double addlen = 0;
                if (!double.TryParse(e.Cell.Row.Cells["SINGLE_ADDLEN"].Value.ToString(),out addlen))
                {
                    e.Cell.Row.Cells["SINGLE_ADDLEN"].Value=0;
                }
            }
        }

        /// <summary>
        /// 根据接箍个数，算接箍料长度，重量
        /// </summary>
        /// <param name="uRow"></param>
        private void computJglLen(UltraGridRow uRow)
        {
            int Num_Jg = 0;
            if (int.TryParse(uRow.Cells["NUM_JG"].Value.ToString(), out Num_Jg))
            {
                //接箍料长度=接箍个数*（接箍长度+单个接箍切损长度）
                double jgbl_sumlenth = Num_Jg * (Convert.ToDouble(uRow.Cells["AIMLENGTH"].Value)
                    + Convert.ToDouble(uRow.Cells["SINGLE_ADDLEN"].Value)) / 1000;

                double singleweight_jg = Convert.ToDouble(uRow.Cells["SINGLEWEIGHT_JG"].Value);//接箍单重(kg)

                //接箍料目标长度取长度上下限中间值
                double JglAimlenth = (Convert.ToDouble(uRow.Cells["MIN_L"].Value)
                   + Convert.ToDouble(uRow.Cells["MAX_L"].Value)) / 2;
                int numJgl = 0; //接箍料支数

                double weight_jg = singleweight_jg * Num_Jg / 1000;//接箍重量

                double min_d = Convert.ToDouble(uRow.Cells["MIN_D"].Value); //备料外径
                double min_h = Convert.ToDouble(uRow.Cells["MIN_H"].Value); //备料壁厚
                double Weight_One = PlanComm.WeightOfMi(min_d, min_h);  //接箍料米单重

                if ((jgbl_sumlenth % JglAimlenth) == 0)
                {
                    numJgl = (int)(jgbl_sumlenth / JglAimlenth);
                }
                else
                {
                    numJgl = (int)(jgbl_sumlenth / JglAimlenth) + 1;
                }

                uRow.Cells["NUM_JGBL"].Value = numJgl;
                uRow.Cells["JGBL_SUMLENTH"].Value = Math.Round(jgbl_sumlenth,2);
                uRow.Cells["WEIGHT_JG"].Value = Math.Round(weight_jg,3);
                uRow.Cells["JGBL_REQ_WEIGHT"].Value = Math.Round(Weight_One * jgbl_sumlenth,3);
            }
            else
            {
                uRow.Cells["NUM_JG"].Value = 0;
            }
        }

        /// <summary>
        /// 选择接箍合同备料
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid7_CellChange(object sender, CellEventArgs e)
        {
            if (e.Cell.Column.Key == "CHECK")
            {
                setJgleditNum(e.Cell.Row);
            }
        }

        /// <summary>
        /// 接箍料编辑表勾选时的操作
        /// </summary>
        /// <param name="uRow">勾选行</param>
        private void setJgleditNum(UltraGridRow cRow)
        {
            if (Convert.ToBoolean(cRow.Cells["CHECK"].Text))
            {
                ultraGrid7.UpdateData();
                IQueryable<UltraGridRow> listRow = ultraGrid7.Rows.AsQueryable().Where(" CHECK = 'True'");
                listRow = listRow.Where(" JG_ORDERNO = '" 
                    + cRow.Cells["JG_ORDERNO"].Value.ToString() + "'");
                listRow = listRow.Where(" CODE_JG_BL != '"
                    + cRow.Cells["CODE_JG_BL"].Value.ToString() + "'");
                foreach (UltraGridRow uRow in listRow.ToArray())
                {
                    uRow.Cells["CHECK"].Value = false;
                    uRow.Cells["NUM_JG"].Activation = Activation.ActivateOnly;
                    uRow.Cells["NUM_JG"].Value = "";
                    uRow.Cells["WEIGHT_JG"].Value = "";
                    uRow.Cells["NUM_JGBL"].Value = "";
                    uRow.Cells["JGBL_SUMLENTH"].Value = "";
                    uRow.Cells["JGBL_REQ_WEIGHT"].Value = "";
                }

                ultraGrid5.UpdateData();
                listRow = ultraGrid5.Rows.AsQueryable().Where(" JG_ORDERNO = '" + cRow.Cells["JG_ORDERNO"].Value.ToString() + "'");
                foreach (UltraGridRow uRow in listRow.ToArray())
                {
                    int num_jg = Convert.ToInt32(uRow.Cells["ORDERNUM"].Value) -
                        Convert.ToInt32(uRow.Cells["MATCHNUM"].Value) -
                        Convert.ToInt32(uRow.Cells["JGWT_BLREQ"].Value);
                    cRow.Cells["NUM_JG"].Value = num_jg;
                    break;
                }
                cRow.Cells["NUM_JG"].Activation = Activation.AllowEdit;
                cRow.Update();
            }
            if (!Convert.ToBoolean(cRow.Cells["CHECK"].Text))
            {
                cRow.Cells["NUM_JG"].Activation = Activation.ActivateOnly;
                cRow.Cells["NUM_JG"].Value = "";
                cRow.Cells["WEIGHT_JG"].Value = "";
                cRow.Cells["NUM_JGBL"].Value = "";
                cRow.Cells["JGBL_SUMLENTH"].Value = "";
                cRow.Cells["JGBL_REQ_WEIGHT"].Value = "";
                cRow.Update();
            }
            ultraGrid7.UpdateData();
            ultraGrid5.UpdateData();
        }

        private void FrmSaleOrderOP_Shown(object sender, EventArgs e)
        {
            if (this.CustomInfo.ToString().Trim().Equals("@CRAFTFILE"))
            {
                setTab2Appearance(DefaultableBoolean.False);
                setTab1Appearance(DefaultableBoolean.False);
                if (toolMenu.Toolbars[0].Tools.Exists("RefresDate"))
                {
                    toolMenu.Toolbars[0].Tools["RefresDate"].InstanceProps.Visible = DefaultableBoolean.False;
                }
            }
            else
            {
                setTab2Appearance(DefaultableBoolean.False);
                setTab3Appearance(DefaultableBoolean.False);
            }
        }

        private void ultraGrid7_BeforeRowActivate(object sender, RowEventArgs e)
        {
            foreach (UltraGridRow uRow in ultraGrid7.Rows)
            {
                uRow.Appearance.BackColor = System.Drawing.Color.White;
            }
            foreach (UltraGridRow uRow in ultraGrid7.Rows)
            {
                if (uRow.Cells["CODE_JG_BL"].Value.Equals(e.Row.Cells["CODE_JG_BL"].Value))
                {
                    uRow.Appearance.BackColor = System.Drawing.Color.PaleGreen;
                }
            }
        }

        /// <summary>
        /// 选择tab页面时，菜单变化
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraTabControl1_SelectedTabChanged(object sender, 
            Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (toolMenu != null)
            {
                if (e.Tab.TabPage == ultraTabPageOrder)
                {
                    setTab1Appearance(DefaultableBoolean.True);
                    setTab2Appearance(DefaultableBoolean.False);
                    setTab3Appearance(DefaultableBoolean.False);

                    if (toolMenu.Toolbars[0].Tools.Exists("RefresDate"))
                    {
                        toolMenu.Toolbars[0].Tools["RefresDate"].InstanceProps.Visible = DefaultableBoolean.True;
                    }
                }
                if (e.Tab.TabPage == ultraTabPageJgdeal)
                {
                    setTab1Appearance(DefaultableBoolean.False);
                    setTab2Appearance(DefaultableBoolean.True);
                    setTab3Appearance(DefaultableBoolean.False);
                    if (toolMenu.Toolbars[0].Tools.Exists("RefresDate"))
                    {
                        toolMenu.Toolbars[0].Tools["RefresDate"].InstanceProps.Visible = DefaultableBoolean.True;
                    }
                }
                if (e.Tab.TabPage == ultraTabPageIssued)
                {
                    setTab1Appearance(DefaultableBoolean.False);
                    setTab2Appearance(DefaultableBoolean.False);
                    setTab3Appearance(DefaultableBoolean.True);

                    if (toolMenu.Toolbars[0].Tools.Exists("RefresDate"))
                    {
                        toolMenu.Toolbars[0].Tools["RefresDate"].InstanceProps.Visible = 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("Pretreat"))
            {
                toolMenu.Toolbars[0].Tools["Pretreat"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("CancelPre"))
            {
                toolMenu.Toolbars[0].Tools["CancelPre"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("ProcessJG"))
            {
                toolMenu.Toolbars[0].Tools["ProcessJG"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("CancelJg"))
            {
                toolMenu.Toolbars[0].Tools["CancelJg"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("ProcessDj"))
            {
                toolMenu.Toolbars[0].Tools["ProcessDj"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("CancelDj"))
            {
                toolMenu.Toolbars[0].Tools["CancelDj"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("OrderSaleIssued"))
            {
                toolMenu.Toolbars[0].Tools["OrderSaleIssued"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("CancelSaleIssued"))
            {
                toolMenu.Toolbars[0].Tools["CancelSaleIssued"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("ConfirmZg"))
            {
                toolMenu.Toolbars[0].Tools["ConfirmZg"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("ConfirmBj"))
            {
                toolMenu.Toolbars[0].Tools["ConfirmBj"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("ConfirmRcl"))
            {
                toolMenu.Toolbars[0].Tools["ConfirmRcl"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("ConfirmGjg"))
            {
                toolMenu.Toolbars[0].Tools["ConfirmGjg"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("ModifyBom"))
            {
                toolMenu.Toolbars[0].Tools["ModifyBom"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("ConfirmGrade"))
            {
                toolMenu.Toolbars[0].Tools["ConfirmGrade"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("FinishJk"))
            {
                toolMenu.Toolbars[0].Tools["FinishJk"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("FinishSc"))
            {
                toolMenu.Toolbars[0].Tools["FinishSc"].InstanceProps.Visible = appearance;
            }
            #endregion
        }

        private void setTab2Appearance(DefaultableBoolean appearance)
        {
            #region tab2显示或隐藏
            if (toolMenu.Toolbars[0].Tools.Exists("QueryJgl"))
            {
                toolMenu.Toolbars[0].Tools["QueryJgl"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("SaveJg"))
            {
                toolMenu.Toolbars[0].Tools["SaveJg"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("Plait"))
            {
                toolMenu.Toolbars[0].Tools["Plait"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("AddPlait"))
            {
                toolMenu.Toolbars[0].Tools["AddPlait"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
            {
                toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("DeleteOne"))
            {
                toolMenu.Toolbars[0].Tools["DeleteOne"].InstanceProps.Visible = appearance;
            }
            #endregion
        }

        private void setTab3Appearance(DefaultableBoolean appearance)
        {
            #region tab3显示或隐藏
            if (toolMenu.Toolbars[0].Tools.Exists("QueryIssued"))
            {
                toolMenu.Toolbars[0].Tools["QueryIssued"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("ExportSale"))
            {
                toolMenu.Toolbars[0].Tools["ExportSale"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("Import"))
            {
                toolMenu.Toolbars[0].Tools["Import"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("TechOrderLineSqe"))
            {
                toolMenu.Toolbars[0].Tools["TechOrderLineSqe"].InstanceProps.Visible = appearance;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("TechOrderLine"))
            {
                toolMenu.Toolbars[0].Tools["TechOrderLine"].InstanceProps.Visible = appearance;
            }
            #endregion
        }

        private void checkBoxForReqORDER_NO_CheckedChanged(object sender, EventArgs e)
        {
            if (checkBoxForReqORDER_NO.Checked)
            {
                ctrlForQueryORDER_NO.Enabled = true;
            }
            else
            {
                ctrlForQueryORDER_NO.Enabled = false;
            }
        }

        private void checkBoxForReqPORDERSTATUS_CheckedChanged(object sender, EventArgs e)
        {
            if (checkBoxForReqPORDERSTATUS.Checked)
            {
                ctrlForQueryPORDERSTATUS.Enabled = true;
            }
            else
            {
                ctrlForQueryPORDERSTATUS.Enabled = false;
            }
        }

        /// <summary>
        /// 选择备料组
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid1_ClickCellButton(object sender, CellEventArgs e)
        {
            if (e.Cell.Column.Key.Equals("BL_GROUP_NUM")
                && (e.Cell.Row.Cells["PORDERSTATUS"].Value.ToString().Equals("待接收")
                || e.Cell.Row.Cells["PORDERSTATUS"].Value.ToString().Equals("已接收")))
            {
                //选择短节备料组
                FrmGroupofDjBl ChooseGroup = new FrmGroupofDjBl(this.ob);
                int orderNum = 0;
                int.TryParse(e.Cell.Row.Cells["PLAN_NUM"].Value.ToString(), out orderNum);

                ChooseGroup.Desgin_key = e.Cell.Row.Cells["DESGIN_KEY"].Value.ToString();
                ChooseGroup.Group_num = e.Cell.Row.Cells["BL_GROUP_NUM"].Value.ToString();
                ChooseGroup.Plan_num = e.Cell.Row.Cells["PLAN_NUM"].Value.ToString();
                ChooseGroup.Order_no = e.Cell.Row.Cells["ORDER_NO"].Value.ToString();
                ChooseGroup.Order_seq = e.Cell.Row.Cells["ORDER_SEQ"].Value.ToString();
                ChooseGroup.Delivery_no = e.Cell.Row.Cells["DELIVERY_NO"].Value.ToString();
                ChooseGroup.Lengthdisc = e.Cell.Row.Cells["LENGTHDISC"].Value.ToString();
                ChooseGroup.LengthMax = Convert.ToDouble(e.Cell.Row.Cells["LENGTHMAX"].Value);
                ChooseGroup.OrderNum = orderNum;
                ChooseGroup.Outdiameter = e.Cell.Row.Cells["OUTDIAMETER"].Value.ToString();
                ChooseGroup.Wallthick = e.Cell.Row.Cells["WALLTHICK"].Value.ToString();
                ChooseGroup.Steelcode = e.Cell.Row.Cells["STEELCODE"].Value.ToString();
                ChooseGroup.Steelname = e.Cell.Row.Cells["STEELNAME"].Value.ToString();
                ChooseGroup.ShowDialog();

                //判断是否需要更新合同备料组
                if (!e.Cell.Row.Cells["BL_GROUP_NUM"].Value.ToString().Equals(ChooseGroup.Group_num))
                {
                    try
                    {
                        ArrayList parms = new ArrayList();
                        e.Cell.Row.Cells["BL_GROUP_NUM"].Value = ChooseGroup.Group_num;
                        parms.Add(e.Cell.Row.Cells["BL_GROUP_NUM"].Value.ToString());
                        parms.Add(e.Cell.Row.Cells["ORD_PK"].Value.ToString());
                        parms.Add(e.Cell.Row.Cells["ORD_LN_PK"].Value.ToString());
                        parms.Add(e.Cell.Row.Cells["ORD_LN_DLY_PK"].Value.ToString());
                        ServerHelper.SetData("com.steering.pss.plan.order.CoreSaleOrderOP.updateDjBlGroup", new object[] { parms }, this.ob);
                    }
                    catch (Exception ex)
                    {
                        if (ex is MESException)
                        {
                            MessageBox.Show(((MESException)ex).ExceptionInfo);
                        }
                        else
                        {
                            MessageBox.Show(ex.Message);
                        }
                    }
                }

                if (ChooseGroup.IsCreatOk)
                {
                    doQuery(GetQueryCondition());
                }
            }

            //查看合同附加要求描述图片
            if (e.Cell.Column.Key.Equals("ORDER_ADD_DESC"))
            {
                try
                {
                    ArrayList listPIC = new ArrayList();
                    DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryAddAsk",
                        new object[] { e.Cell.Row.Cells["ADD_ASK_NO"].Value.ToString() }, 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.ShowDialog();
                }
                catch (Exception ex)
                {
                    if (ex is MESException)
                    {
                        MessageBox.Show(((MESException)ex).ExceptionInfo);
                    }
                    else
                    {
                        MessageBox.Show(ex.Message);
                    }
                }
            }
        }

        private void checkBoxAcceptNo_CheckedChanged(object sender, EventArgs e)
        {
            if (checkBoxAcceptNo.Checked)
            {
                ultraTextEditorAcceptNo.Enabled = true;
            }
            else
            {
                ultraTextEditorAcceptNo.Enabled = false;
            }
        }

        private void checkBoxDELVRY_EDATEexport_CheckedChanged(object sender, EventArgs e)
        {
            if (checkBoxDELVRY_EDATEexport.Checked)
            {
                ultraDateTimeDELVRY_EDATEFrom.Enabled = true;
                ultraDateTimeDELVRY_EDATETo.Enabled = true;
            }
            else
            {
                ultraDateTimeDELVRY_EDATEFrom.Enabled = false;
                ultraDateTimeDELVRY_EDATETo.Enabled = false;
            }
        }

        private void checkBoxORDER_NOexpor_CheckedChanged(object sender, EventArgs e)
        {
            if (checkBoxORDER_NOexpor.Checked)
            {
                ultraTextORDER_NO.Enabled = true;
            }
            else
            {
                ultraTextORDER_NO.Enabled = false;
            }
        }

        private void checkBoxGroupTypeexpor_CheckedChanged(object sender, EventArgs e)
        {
            if (checkBoxGroupTypeexpor.Checked)
            {
                ultraComboGroupType.Enabled = true;
            }
            else
            {
                ultraComboGroupType.Enabled = false;
            }
        }

        private void checkBoxAcceptNoexport_CheckedChanged(object sender, EventArgs e)
        {
            if (checkBoxAcceptNoexport.Checked)
            {
                ultraTextAcceptNo.Enabled = true;
            }
            else
            {
                ultraTextAcceptNo.Enabled = false;
            }
        }

        private void ultraDateTimeDELVRY_EDATEFrom_ValueChanged(object sender, EventArgs e)
        {
            ultraDateTimeDELVRY_EDATETo.MinDate = ultraDateTimeDELVRY_EDATEFrom.DateTime.Date;
        }

        private void ultraDateTimeDELVRY_EDATETo_ValueChanged(object sender, EventArgs e)
        {
            ultraDateTimeDELVRY_EDATEFrom.MaxDate = ultraDateTimeDELVRY_EDATETo.DateTime.AddDays(1).Date.AddSeconds(-1);
        }

        private void ultraGrid7_DoubleClickRow(object sender, DoubleClickRowEventArgs e)
        {
            ultraGrid5.UpdateData();
            ultraGrid7.UpdateData();
            IQueryable<UltraGridRow> listRow = ultraGrid7.Rows.AsQueryable().Where(" CODE_JG_BL = '"
                + e.Row.Cells["CODE_JG_BL"].Value.ToString() + "'");
            foreach (UltraGridRow uRow in listRow.ToArray())
            {
                uRow.Cells["CHECK"].Value = true;
                IQueryable<UltraGridRow> rows = ultraGrid5.Rows.AsQueryable().Where(" JG_ORDERNO = '"
                    + uRow.Cells["JG_ORDERNO"].Value.ToString() + "'");
                uRow.Cells["NUM_JG"].Activation = Activation.AllowEdit;
                foreach (UltraGridRow cRow in rows)
                {
                    int num_jg = Convert.ToInt32(cRow.Cells["ORDERNUM"].Value) -
                        Convert.ToInt32(cRow.Cells["MATCHNUM"].Value) -
                        Convert.ToInt32(cRow.Cells["JGWT_BLREQ"].Value);
                    uRow.Cells["NUM_JG"].Value = num_jg;
                    break;
                }
            }
            listRow = ultraGrid7.Rows.AsQueryable().Where(" CODE_JG_BL != '"
                + e.Row.Cells["CODE_JG_BL"].Value.ToString() + "'");
            foreach (UltraGridRow uRow in listRow.ToArray())
            {
                uRow.Cells["CHECK"].Value = false;
                uRow.Cells["NUM_JG"].Activation = Activation.ActivateOnly;
                uRow.Cells["NUM_JG"].Value = "";
                uRow.Cells["WEIGHT_JG"].Value = "";
                uRow.Cells["NUM_JGBL"].Value = "";
                uRow.Cells["JGBL_SUMLENTH"].Value = "";
                uRow.Cells["JGBL_REQ_WEIGHT"].Value = "";
            }
            ultraGrid5.UpdateData();
            ultraGrid7.UpdateData();
        }

        private void splitContainer1_SplitterMoved(object sender, SplitterEventArgs e)
        {
            if (_groupBox2ExpandedChanged == false)
            {
                _splitterDistance = splitContainer1.SplitterDistance;
                if (splitContainer1.SplitterDistance >= 1)
                {
                    ultraExpandableGroupBox2.Expanded = true;
                }
            }

            if (splitContainer1.Panel2Collapsed)
            {
                ultraExpandableGroupBox2.Visible = false;
            }
        }

        private void ultraExpandableGroupBox2_ExpandedStateChanged(object sender, EventArgs e)
        {
            _groupBox2ExpandedChanged = true;
            if (ultraExpandableGroupBox2.Expanded == false)
            {
                splitContainer1.SplitterDistance = this.Width;
            }
            else
            {
                splitContainer1.SplitterDistance = _splitterDistance;
            }
            _groupBox2ExpandedChanged = false;
        }

        private void ultraGrid1_CellDataError(object sender, CellDataErrorEventArgs e)
        {
            e.RaiseErrorEvent = false;
        }

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

            foreach (UltraGridRow uRow in ultraGrid7.Rows)
            {
                if (uRow.Cells["JG_ORDERNO"].Value.ToString().Equals(
                    ugr.Cells["JG_ORDERNO"].Value.ToString()))
                {
                    ultraGrid7.ActiveRow = uRow;
                    uRow.Appearance.ForeColor = System.Drawing.Color.DarkBlue;
                }
                else
                {
                    uRow.Appearance.ForeColor = System.Drawing.Color.Black;
                }
            }
        }

        /// <summary>
        /// 生产分类月排产查询
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraButtonRcl_Click(object sender, EventArgs e)
        {
            FrmReqRollMonth outPut = new FrmReqRollMonth();
            outPut.ShowDialog();
        }

        private void ultraGrid1_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
        {
            try
            {
                for (int i = 0; i < ultraGrid1.Selected.Rows.Count; i++)
                {
                    if (ultraGrid1.Selected.Rows[i].GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
                    {
                        ultraGrid1.Selected.Rows[i].Cells["CHECK"].Value = true;
                    }

                }

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "出错");
            }
        }

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

        private void ultraGrid6_CellChange(object sender, CellEventArgs e)
        {
            if (e.Cell.Column.Key.Equals("BJ_TYPE"))
            {
                if (e.Cell.Row.Cells["BJ_TYPE"].Value.ToString().Equals("")
                    || e.Cell.Row.Cells["BJ_TYPE"].Value.ToString().Equals("/"))
                {
                    e.Cell.Row.Cells["DIMATER_YLG"].Value = "";
                    e.Cell.Row.Cells["DIMATER_YLG"].ValueList = null;
                    e.Cell.Row.Cells["HEIGHT_YLG"].Value = "";
                    e.Cell.Row.Cells["HEIGHT_YLG"].ValueList = null;
                }
                else
                {
                    ArrayList param = new ArrayList();
                    param.Add(e.Cell.Row.Cells["BJ_TYPE"].Value.ToString());
                    param.Add(e.Cell.Row.Cells["OUTDIAMETER"].Value.ToString());
                    param.Add(e.Cell.Row.Cells["WALLTHICK"].Value.ToString());
                    DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryRollRupset",
                        new object[] { param }, this.ob);
                    e.Cell.Row.Cells["DIMATER_YLG"].ValueList = PlanComm.GeneralValuelist(ref dt, "MIN_D", "MIN_D");
                    e.Cell.Row.Cells["HEIGHT_YLG"].ValueList = PlanComm.GeneralValuelist(ref dt, "MIN_H", "MIN_H");
                    if (dt != null && dt.Rows.Count > 0)
                    {
                        if (e.Cell.Row.Cells["DIMATER_YLG"].Value.ToString().Equals(""))
                        {
                            e.Cell.Row.Cells["DIMATER_YLG"].Value = dt.Rows[0]["MIN_D"].ToString();
                        }
                        if (e.Cell.Row.Cells["HEIGHT_YLG"].Value.ToString().Equals(""))
                        {
                            e.Cell.Row.Cells["HEIGHT_YLG"].Value = dt.Rows[0]["MIN_H"].ToString();
                        }
                    }
                }
            }
        }

        private void ultraGrid6_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow ugr = ultraGrid6.ActiveRow;
            if (ugr == null)
            {
                return;
            }
            DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CoreSaleOrderOP.queryRelation",
                new object[] { ugr.Cells["REQ_BL_ID"].Value.ToString() }, this.ob);
            GridHelper.CopyDataToDatatable(dt, dataTable4, true);
        }

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

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

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

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

        private void checkBoxRollMonth_CheckedChanged(object sender, EventArgs e)
        {
            if (checkBoxRollMonth.Checked == false)
            {
                ultraDateTimeRollMonth.Enabled = false;
            }
            else
            {
                ultraDateTimeRollMonth.Enabled = true;
            }
        }

        /// <summary>
        /// 等待窗口
        /// </summary>
        private void WaitFromOpen()
        {
            this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
            if (Constant.WaitingForm == null)
            {
                Constant.WaitingForm = new WaitingForm();
            }
            Constant.WaitingForm.ShowToUser = true;
            Constant.WaitingForm.Show();
            Constant.WaitingForm.Update();
        }

        /// <summary>
        /// 关闭等待
        /// </summary>
        private void WaitFromColse()
        {
            this.Cursor = Cursors.Default;
            Constant.WaitingForm.ShowToUser = false;
            Constant.WaitingForm.Close();
            Constant.WaitingForm = null;
        }

        private void TechOrderLineSqe()
        {
            UltraGridRow ugr = ultraGrid8.ActiveRow;
            if (ugr == null)
            {
                return;
            }

            string url = "http://172.16.2.130:8085/WebReport/ReportServer?reportlet=RepTechOrderLineSqe.cpt&op=view"
                + "&lnpk=" + ugr.Cells["ORD_LN_DLY_PK"].Value.ToString();
            FrmOutExcel outPut = new FrmOutExcel(url);
            outPut.ShowDialog();
        }

        private void TechOrderLine()
        {
            UltraGridRow ugr = ultraGrid8.ActiveRow;
            if (ugr == null)
            {
                return;
            }

            string url = "http://172.16.2.130:8085/WebReport/ReportServer?reportlet=RepTechOrderLine.cpt&op=view" 
                + "&lnpk=" + ugr.Cells["ORD_LN_PK"].Value.ToString();
            FrmOutExcel outPut = new FrmOutExcel(url);
            outPut.ShowDialog();
        }

        private void ultraGrid1_KeyUp(object sender, KeyEventArgs e)
        {
            PlanComm.setGridCopyActColumn(ultraGrid1, e, "PRIORITY",
                "OUTS_BILLET_FL", "ROLL_MONTH", "GROUP_RCL", "GROUP_JGX");
        }

        private void checkBoxAcpStatus_CheckedChanged(object sender, EventArgs e)
        {
            if (checkBoxAcpStatus.Checked)
            {
                this.ultraComboEditAcpStatus.Enabled = true;
            }
            else
            {
                this.ultraComboEditAcpStatus.Enabled = false;
            }
        }

    }
}