MES_Client/TGMES/Core.StlMes.Client.Plan.Order/FrmPlnOrderJgDj.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 com.steering.pss.plan.order.model;

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

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

        public FrmPlnOrderJgDj(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 "ProcessJG"://接箍处理
                    doProcessJg();
                    break;
                case "CancelJg"://取消接箍合同
                    doCancelJg();
                    break;
                case "ProcessDJ"://短节处理
                    doProcessDj();
                    break;
                case "CancelDj"://取消短节合同
                    doCancelDj();
                    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 "RefresDate"://刷新加载数据
                    RefresDate();
                    break;
                case "Close":  //关闭
                    this.Close();
                    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(" CHC = 'True' ");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选保存的备料！");
                    return;
                }
                foreach (UltraGridRow uRow in checkRows)
                {
                    ///查询合同状态
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.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.CorePlnOrderJgDj.confirmBlZg",
                    new object[] { list }, this.ob);
                if (suceed > 0)
                {
                    MessageUtil.ShowTips("保存成功！");
                }
                else
                {
                    MessageUtil.ShowTips("保存失败！");
                }
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                }
                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(" CHC = 'True' ");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选要保存的备料！");
                    return;
                }
                foreach (UltraGridRow uRow in checkRows)
                {
                    ///查询合同状态
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.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.CorePlnOrderJgDj.confirmBlBj",
                    new object[] { list }, this.ob);
                if (suceed > 0)
                {
                    MessageUtil.ShowTips("保存成功！");
                }
                else
                {
                    MessageUtil.ShowTips("保存失败！");
                }
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                }
                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(" CHC = 'True' ");
                if (checkRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选要保存的备料！");
                    return;
                }
                foreach (UltraGridRow uRow in checkRows)
                {
                    ///查询合同状态
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.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.CorePlnOrderJgDj.confirmBlRcl",
                    new object[] { list }, this.ob);
                if (suceed > 0)
                {
                    MessageUtil.ShowTips("保存成功！");
                }
                else
                {
                    MessageUtil.ShowTips("保存失败！");
                }
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                }
                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>
        /// <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");
            RefresDate();
        }

        /// <summary>
        /// 刷新加载数据
        /// </summary>
        private void RefresDate()
        {
            DataTable tableBaseInfo = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.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.CorePlnOrderJgDj.queryBlZgPline",
                new object[] { }, this.ob);

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

            //热处理组
            ValueList vlistS1 = PlanComm.GeneralValuelist(ref tableBaseInfo, "BASECODE", "BASENAME");
            vlistS1.ValueListItems.Insert(0, "/", "/");
            ultraGrid3.DisplayLayout.Bands[0].Columns["GROUP_RCL"].ValueList = vlistS1;
            ValueList vlistS2 = PlanComm.GeneralValuelist(ref tableBaseInfo, "BASECODE", "BASENAME");
            vlistS2.ValueListItems.Insert(0, "/", "/");
            ultraGrid6.DisplayLayout.Bands[0].Columns["GROUP_RCL"].ValueList = vlistS2;

            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");

            doQuery(GetQueryCondition());
        }

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

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

            if (this.checkBoxHvDj.Checked)
            {
                haveDj = "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);
            return ary;
        }

        /// <summary>
        /// 根据信息栏查询
        /// </summary>
        /// <param name="ary">查询条件信息</param>
        private void doQuery(ArrayList ary)
        {
            try
            {
                if (ary == null)
                {
                    return;
                }

                DataTable dt1 = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.querySaleOrder",
                    new object[] { ary }, this.ob);
                GridHelper.CopyDataToDatatable(dt1, dataTable1, true);

                DataTable dt2 = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryJgOrder",
                    new object[] { ary }, this.ob);
                GridHelper.CopyDataToDatatable(dt2, dataTable2, true);

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

                ///设置ultraGrid1单元格不可编辑
                PlanComm.setGridActivation(ultraGrid1.DisplayLayout.Bands[0], "CHC");

                ///设置ultraGrid2单元格不可编辑
                PlanComm.setGridActivation(ultraGrid2.DisplayLayout.Bands[0], "CHC");

                #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[] { "CHC", "JGBL_REQ_WEIGHT", "MATCHWEIGHT",
                        "GRADECODE", "GROUP_RCL","DIMATER_YLG","HEIGHT_YLG", "BJ_TYPE", "GROUP_ROLL" };
                PlanComm.setGridActivation(ultraGrid3.DisplayLayout.Bands[0], strColum3);
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                }
                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
        }

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

                ///设置grid不可编辑
                PlanComm.setGridActivation(ultraGrid5.DisplayLayout.Bands[0], "CHC", "MATCHNUM", "BUYCHOOSE");

                DataTable dtEdit = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.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], "CHC", "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.CorePlnOrderJgDj.queryJgBlNeed",
                    new object[] { }, this.ob);
                GridHelper.CopyDataToDatatable(dtJgl, dataTable6, true);

                ///设置grid不可编辑
                string[] strColumn = new string[] { "CHC", "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)
                {
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }

        /// <summary>
        /// 备料导出
        /// </summary>
        private void doExportBl(string bjType)
        {
            string url = "";
            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(" CHC = '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.CorePlnOrderJgDj.UpdateDjblRcl",
                    new object[] { list }, this.ob);
                if (suceed > 0)
                {
                    MessageUtil.ShowTips("保存成功！");
                }
                else
                {
                    MessageUtil.ShowTips("保存失败！");
                }
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                }
                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["CHC"].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.CorePlnOrderJgDj.updateLkwgWeight", new object[] { list }, this.ob);
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                }
                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.CorePlnOrderJgDj.queryblPsc",
                                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.CorePlnOrderJgDj.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.CorePlnOrderJgDj.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.CorePlnOrderJgDj.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.CorePlnOrderJgDj.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.CorePlnOrderJgDj.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.CorePlnOrderJgDj.queryBlCodeByGp",
                    new object[] { param }, this.ob);
                return dt;
            }
            catch
            {
                return null;
            }
        }

        /// <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.CorePlnOrderJgDj.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>
        private void doProcessJg()
        {
            try
            {
                ultraGrid1.UpdateData();
                IQueryable<UltraGridRow> checkRows = ultraGrid1.Rows.AsQueryable().Where("CHC = '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.CorePlnOrderJgDj.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();
                            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();
                            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();
                            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 strJGorderno = 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;        //接箍合同量
                                PlnOrderJgEntity jgEntity = new PlnOrderJgEntity();
                                DataTable dtjgbase = QueryJgBase(strCodeJg);
                                if (dtjgbase == null || dtjgbase.Rows.Count <= 0)
                                {
                                    WaitFromColse();
                                    MessageUtil.ShowTips("未找到接箍码为："+strCodeJg
                                        + "的基础信息，请查看接箍码维护信息！");
                                    return;
                                }

                                single_weight = Convert.ToDouble(dtjgbase.Rows[0]["WEIGHT_JG"]) / 1000;
                                weightJg = Convert.ToInt32(dtStatus.Rows[0]["PLAN_NUM"]) * single_weight;
                                weightSale += weightJg;

                                jgEntity.JgOrderno = strJGorderno;
                                jgEntity.OrderNo = uRow.Cells["ORDER_NO"].Value.ToString();
                                jgEntity.OrderSeq = uRow.Cells["ORDER_SEQ"].Value.ToString();
                                jgEntity.DeliveryNo = uRow.Cells["DELIVERY_NO"].Value.ToString();
                                jgEntity.BuyerId = uRow.Cells["BUYER_ID"].Value.ToString();
                                jgEntity.BuyerName = uRow.Cells["BUYER_NAME"].Value.ToString();
                                jgEntity.DelvryEdate = uRow.Cells["DELVRY_EDATE"].Value.ToString();
                                jgEntity.Ordercontact = uRow.Cells["ORDERCONTACT"].Value.ToString();
                                jgEntity.PrdcrNo = uRow.Cells["PRDCR_NO"].Value.ToString();
                                jgEntity.IfMonitorJg = "0";
                                jgEntity.Psc = uRow.Cells["PSC"].Value.ToString();
                                jgEntity.Msc = uRow.Cells["MSC"].Value.ToString();
                                jgEntity.CodeJg = strCodeJg;
                                jgEntity.Steelcode = dtjgbase.Rows[0]["STEELCODE_JG"].ToString();
                                jgEntity.Steelname = dtjgbase.Rows[0]["STEELCODE_JG_DESC"].ToString();
                                jgEntity.Outdiameter = dtjgbase.Rows[0]["DIAMETER_JG"].ToString();
                                jgEntity.Wallthick = dtjgbase.Rows[0]["HEIGHT_JG"].ToString();
                                jgEntity.ModelCode = dtjgbase.Rows[0]["MODEL_CODE"].ToString();
                                jgEntity.ModelDesc = dtjgbase.Rows[0]["MODEL_DESC"].ToString();
                                jgEntity.Aimlength = dtjgbase.Rows[0]["LENGTH_JG"].ToString();
                                jgEntity.Singleweight = dtjgbase.Rows[0]["WEIGHT_JG"].ToString();
                                jgEntity.Orderweight = weightJg.ToString();
                                jgEntity.Ordernum = dtStatus.Rows[0]["PLAN_NUM"].ToString();
                                jgEntity.CreateName = CoreUserInfo.UserInfo.GetUserName();

                                DataTable dtPro = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.queryPrdcrLst",
                                    new object[] { jgEntity.PrdcrNo }, this.ob);
                                if (dtPro != null && dtPro.Rows.Count > 0)
                                {
                                    jgEntity.Monitordemand = dtPro.Rows[0]["PROCESS_DESC"].ToString();
                                    jgEntity.IfMonitorJg = "1";
                                }

                                list.Add(jgEntity);
                                #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)
                        {
                            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.CorePlnOrderJgDj.tranSactionJg",
                            new object[] { list, listupdate }, this.ob);
                WaitFromColse();
                if (succed > 0)
                {
                    MessageUtil.ShowTips("接箍处理成功！");
                }
                else
                {
                    MessageUtil.ShowTips("接箍处理失败！");
                }
            }
            catch (Exception ex)
            {
                WaitFromColse();
                if (ex is MESException)
                {
                }
                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("CHC = '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.CorePlnOrderJgDj.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.CorePlnOrderJgDj.doCancelJg",
                    new object[] { list }, this.ob);
                WaitFromColse();
                if (succed > 0)
                {
                    MessageUtil.ShowTips("撤消接箍合同成功！");
                }
                else
                {
                    MessageUtil.ShowTips("撤消接箍合同失败！");
                }
            }
            catch (Exception ex)
            {
                WaitFromColse();
                if (ex is MESException)
                {
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            doQuery(GetQueryCondition());
        }

        /// <summary>
        /// 短节处理
        /// </summary>
        private void doProcessDj()
        {
            try
            {
                ultraGrid1.UpdateData();
                IQueryable<UltraGridRow> checkRows = ultraGrid1.Rows.AsQueryable().Where(" CHC = '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.CorePlnOrderJgDj.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 (uRow.Cells["OUTDIAMETER"].Value.ToString().Equals(dtbllist.Rows[0]["MIN_D"].ToString())
                                        && uRow.Cells["WALLTHICK"].Value.ToString().Equals(dtbllist.Rows[0]["MIN_H"].ToString())
                                        && uRow.Cells["STEELCODE"].Value.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.CorePlnOrderJgDj.tranSactionDj",
                                new object[] { paramBL, paramUpdate }, this.ob);
                WaitFromColse();
                if (isSucceed > 0)
                {
                    MessageUtil.ShowTips("短节处理成功！");
                }
                else
                {
                    MessageUtil.ShowError("短节处理失败！");
                }
            }
            catch (Exception ex)
            {
                WaitFromColse();
                if (ex is MESException)
                {
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            doQuery(GetQueryCondition());
        }

        /// <summary>
        /// 撤消短节合同
        /// </summary>
        private void doCancelDj()
        { 
            try
            {
                ultraGrid1.UpdateData();
                IQueryable<UltraGridRow> checkRows = ultraGrid1.Rows.AsQueryable().Where(" CHC = '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.CorePlnOrderJgDj.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.CorePlnOrderJgDj.doCancelDj",
                    new object[] { list }, this.ob);
                WaitFromColse();
                if (succed > 0)
                {
                    MessageUtil.ShowTips("撤消短节合同成功！");
                }
                else
                {
                    MessageUtil.ShowTips("撤消短节合同失败！");
                }
            }
            catch (Exception ex)
            {
                WaitFromColse();
                if (ex is MESException)
                {
                }
                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["CHC"].Text))
                    {
                        if (uRow.Cells["JGBL_SUMLENTH"].Value.Equals("0") ||
                            uRow.Cells["JGBL_SUMLENTH"].Value.Equals(""))
                        {
                            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)
                {
                    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["CHC"].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(uRow.Cells["WEIGHT_JG"].Value.ToString());
                                parms_Rel.Add(uRow.Cells["NUM_JG"].Value.ToString());
                                parms_Rel.Add(uRow.Cells["SINGLE_ADDLEN"].Value.ToString());
                                parms_Rel.Add(CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName());
                                #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.ToString());//控制壁厚
                        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["CHC"].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.CorePlnOrderJgDj.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)
                {
                }
                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["CHC"].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["CHC"].Text))
                        {
                            isChecked = true;
                            if (code_jg_bl != uRow.Cells["CODE_JG_BL"].Value.ToString())
                            {
                                MessageUtil.ShowError("所选择的条目备料码"
                                    + "与要加入的备料需求的备料码有不同，请重新选择！");
                                return;
                            }
                        }
                    }

                    ///如果没有勾选待处理的条目，提示。
                    if (!isChecked)
                    {
                        MessageUtil.ShowTips("未选择要加入现有需求的信息！");
                        return;
                    }
                }
                else
                {
                    if (count == 0)
                    {
                        MessageUtil.ShowTips("请选择一条现有的接箍料需求！");
                        return;
                    }
                    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["CHC"].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.CorePlnOrderJgDj.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(uRow.Cells["WEIGHT_JG"].Value.ToString());
                                parms_Rel.Add(uRow.Cells["NUM_JG"].Value.ToString());
                                parms_Rel.Add(uRow.Cells["SINGLE_ADDLEN"].Value.ToString());
                                parms_Rel.Add(CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName());
                                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["CHC"].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.CorePlnOrderJgDj.updateJglNeed",
                    new object[] { list, listUpdateRel, list_Rel, listupdate }, this.ob);
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                }
                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["CHC"].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.CorePlnOrderJgDj.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.CorePlnOrderJgDj.deleteBlNeed",
                        new object[] { listRel, listJg, list }, this.ob);
                }
                else
                {
                    Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("请选择要删除的接箍料需求！");
                    return;
                }
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                }
                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["CHC"].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["CHC"].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.CorePlnOrderJgDj.deleteJglOne",
                            new object[] { list_Rel, list_Jgl, list }, this.ob);
                    }
                }
                else
                {
                    MessageUtil.ShowTips("请至少选择一条接箍料需求单量！");
                    return;
                }
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                }
                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.CorePlnOrderJgDj.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.CorePlnOrderJgDj.queryBlList", new object[] { 
                    strCodeJg }, this.ob);
                return dt;
            }
            catch
            {
                return null;
            }
        }

        /// <summary>
        /// 接箍合同下发
        /// </summary>
        private void OrderJgIssued()
        {
            try
            {
                bool isChecked = false;
                ArrayList list = new ArrayList();
                foreach (UltraGridRow uRow in ultraGrid2.Rows)
                {
                    if (Convert.ToBoolean(uRow.Cells["CHC"].Text))
                    {
                        ArrayList parms = new ArrayList();
                        DataTable dt = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.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.CorePlnOrderJgDj.issuedJgOrder",
                            new object[] { list }, this.ob);
                    if (Convert.ToBoolean(result))
                    {
                        MessageUtil.ShowTips("下发成功！");
                    }
                }
                else
                {
                    MessageUtil.ShowTips("请勾选您要下发的接箍合同！");
                    return;
                }
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                }
                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("CHC = '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.CorePlnOrderJgDj.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.CorePlnOrderJgDj.cancelJgIssued",
                    new object[] { list }, this.ob);
                if (succed > 0)
                {
                    MessageUtil.ShowTips("取消下发成功！");
                }
                else
                {
                    MessageUtil.ShowTips("取消下发失败！");
                }
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                }
                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("CHC = '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.CorePlnOrderJgDj.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.CorePlnOrderJgDj.cancelBlIssued",
                    new object[] { list }, this.ob);
                if (succed > 0)
                {
                    MessageUtil.ShowTips("取消下发成功！");
                }
                else 
                {
                    MessageUtil.ShowTips("取消下发失败！");
                }
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                }
                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("CHC = 'True'");
                if (checkedRows.Count() == 0)
                {
                    MessageUtil.ShowTips("未勾选要下发的备料！");
                    return;
                }
                foreach (UltraGridRow uRow in checkedRows)
                {
                    DataTable dtStatus = ServerHelper.GetData("com.steering.pss.plan.order.CorePlnOrderJgDj.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." +
                        "CorePlnOrderJgDj.issuedJglNeed", new object[] { list }, this.ob)))
                {
                    MessageUtil.ShowTips("下发失败！");
                    return;
                }
                MessageUtil.ShowTips("下发成功！");
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }

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

        /// <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["CHC"].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 == "CHC")
            {
                setJgleditNum(e.Cell.Row);
            }
        }

        /// <summary>
        /// 接箍料编辑表勾选时的操作
        /// </summary>
        /// <param name="uRow">勾选行</param>
        private void setJgleditNum(UltraGridRow cRow)
        {
            if (Convert.ToBoolean(cRow.Cells["CHC"].Text))
            {
                ultraGrid7.UpdateData();
                IQueryable<UltraGridRow> listRow = ultraGrid7.Rows.AsQueryable().Where(" CHC = '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["CHC"].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["CHC"].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)
        {
            setTab2Appearance(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);

                    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);
                    if (toolMenu.Toolbars[0].Tools.Exists("RefresDate"))
                    {
                        toolMenu.Toolbars[0].Tools["RefresDate"].InstanceProps.Visible = DefaultableBoolean.True;
                    }
                }
            }
        }

        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("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;
            }
            #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 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.CorePlnOrderJgDj.updateDjBlGroup", new object[] { parms }, this.ob);
                    }
                    catch (Exception ex)
                    {
                        if (ex is MESException)
                        {
                        }
                        else
                        {
                            MessageBox.Show(ex.Message);
                        }
                    }
                }

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

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

        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["CHC"].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["CHC"].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;
                }
            }
        }

        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["CHC"].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["CHC"].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.CorePlnOrderJgDj.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.CorePlnOrderJgDj.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["CHC"].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["CHC"].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["CHC"].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["CHC"].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;
        }

    }
}