XinYu_LZMES_Client/Core.LZMes.Client.UIE/UIE043/UIE043010.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using CoreFS.CA06;
using System.Collections;

namespace Core.LZMes.Client.UIE
{
    public partial class UIE043010 : FrmBase
    {
        Infragistics.Win.UltraWinGrid.UltraGridCell ordCell1;
        Infragistics.Win.UltraWinGrid.UltraGridCell ordCell2;
        Infragistics.Win.UltraWinGrid.UltraGridCell ordCell3;
        Infragistics.Win.UltraWinGrid.UltraGridCell primaryCell;
        string ordNO1;
        string ordNO2;
        string ordNO3;
        string primaryOrdNO;
        string ordSeq1;
        string ordSeq2;
        string ordSeq3;
        string primaryOrdSeq;
        string ordRemWgt1;
        string ordRemWgt2;
        string ordRemWgt3;

        public UIE043010()
        {
            InitializeComponent();
        }

        #region "ToolBar Event"
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    this.DoQuery();
                    this.find();
                    break;
                case "Confirm":
                    this.find();
                    break;
                case "Save":
                    this.Save();
                    break;
            }
        }

        private void DoQuery()
        {
            try
            {
                ordNO1 = "";
                ordNO2 = "";
                ordNO3 = "";
                primaryOrdNO = "";
                ordSeq1 = "";
                ordSeq2 = "";
                ordSeq3 = "";
                primaryOrdSeq = "";
                ordRemWgt1 = "";
                ordRemWgt2 = "";
                ordRemWgt3 = "";

                ordCell1 = null;
                ordCell2 = null;
                ordCell3 = null;
                primaryCell = null;

                string ordNO = Convert.ToString(Common.FixDBManager.CheckNullStr(this.textOrdNO.Text));
                string ordSeq = Convert.ToString(Common.FixDBManager.CheckNullStr(this.CombOrdSeq.Value));
                string stlGrd = Convert.ToString(Common.FixDBManager.CheckNullStr(this.CombStlGrd.Value));
                string prodType = Convert.ToString(Common.FixDBManager.CheckNullStr(this.CombProdType.Value));
                string custCD = Convert.ToString(Common.FixDBManager.CheckNullStr(this.CombCustID.Value));
                string ordUseCD = Convert.ToString(Common.FixDBManager.CheckNullStr(this.CombUseCD.Value));
                string ordType = Convert.ToString(Common.FixDBManager.CheckNullStr(this.CombOrdType.Value));
                string abbsym = Convert.ToString(Common.FixDBManager.CheckNullStr(this.CombSpecAbbsym.Value));
                string shapeGrd = Convert.ToString(Common.FixDBManager.CheckNullStr(this.CombShapGrd.Value));
                string delToDateFrom = Convert.ToString(Common.FixDBManager.CheckNullStr(this.DelToDateFrom.DateTime.ToString("yyyyMMdd")));
                string delToDataTo = Convert.ToString(Common.FixDBManager.CheckNullStr(this.DelToDateTo.DateTime.ToString("yyyyMMdd")));
                string ordThkFrom = Convert.ToString(Common.FixDBManager.CheckNullStr(this.TextOrdThkFrom.Text));
                string ordThkTo = Convert.ToString(Common.FixDBManager.CheckNullStr(this.TextOrdThkTo.Text));
                string ordWgtFrom = Convert.ToString(Common.FixDBManager.CheckNullStr(this.TextOrdWgtFrom.Text));
                string ordWgtTo = Convert.ToString(Common.FixDBManager.CheckNullStr(this.TextOrdWgtTo.Text));
                string ordWthFrom = Convert.ToString(Common.FixDBManager.CheckNullStr(this.TextOrdWthFrom.Text));
                string ordWthTo = Convert.ToString(Common.FixDBManager.CheckNullStr(this.TextOrdWthTo.Text));


                this.dataSet1.Tables[0].Clear();

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.COM.ComDBQuery";
                ccp.MethodName = "doSimpleQuery";
                ArrayList paramArray = new ArrayList();
                paramArray.Add("UIE043010_ORD.select");
                paramArray.Add(prodType);
                paramArray.Add(custCD);
                paramArray.Add(stlGrd);
                paramArray.Add(ordNO);
                paramArray.Add(ordSeq);
                paramArray.Add(ordType);
                paramArray.Add(delToDateFrom);
                paramArray.Add(delToDataTo);
                paramArray.Add(ordUseCD);
                paramArray.Add(abbsym);
                paramArray.Add(ordThkFrom);
                paramArray.Add(ordThkTo);
                paramArray.Add(ordWthFrom);
                paramArray.Add(ordWthTo);
                paramArray.Add(ordWgtFrom);
                paramArray.Add(ordWgtTo);

                ccp.ServerParams = new object[] { paramArray };
                ccp.SourceDataTable = this.dataSet1.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                System.Diagnostics.Debug.WriteLine(this.dataSet1.Tables[0].ToString());
            }
            catch (Exception EX)
            {
                MessageBox.Show(EX.ToString());
            }
        }

        public void find()
        {
            try
            {

                string ORD_THK_MIN = Convert.ToString(Common.FixDBManager.CheckNullStr(this.TextOrdThkMin.Text));
                string ORD_THK_MAX = Convert.ToString(Common.FixDBManager.CheckNullStr(this.TextOrdThkMax.Text));
                string matType = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ComboMatType.Value));

                this.dataSet2.Tables[0].Clear();

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.COM.ComDBQuery";
                ccp.MethodName = "doSimpleQuery";
                ArrayList paramArray = new ArrayList();
                if (matType.Equals("PLTCM01"))
                {
                    paramArray.Add("UIE043010.HOTCoilComm.Select");
                    paramArray.Add(primaryOrdNO);
                    paramArray.Add(primaryOrdSeq);
                    paramArray.Add(ORD_THK_MIN);
                    paramArray.Add(ORD_THK_MAX);

                    //判定
                    paramArray.Add(checkDgrd.Checked.ToString());
                    //牌号
                    paramArray.Add(checkStlGrd.Checked.ToString());
                    //尺寸
                   // paramArray.Add(checkSize.Checked.ToString());
                    paramArray.Add(checkThk.Checked.ToString());
                    paramArray.Add(checkWth.Checked.ToString());
                    //成分
                    paramArray.Add(checkIngr.Checked.ToString());
                    //材质
                    paramArray.Add(checkMaterial.Checked.ToString());
                    //订单单重
                    paramArray.Add(checkUnitWgt.Checked.ToString());
                    //同内径
                    paramArray.Add(checkIn.Checked.ToString());
                    //同包装
                    paramArray.Add(checkPack.Checked.ToString());
                }
                else if (matType.Equals("PLTCM02"))
                {
                    paramArray.Add("UIE043010.COLDCoilComm.Select");
                    paramArray.Add(primaryOrdNO);
                    paramArray.Add(primaryOrdSeq);
                    //判定
                    paramArray.Add(checkDgrd.Checked.ToString());
                    //牌号
                    paramArray.Add(checkStlGrd.Checked.ToString());
                    //尺寸
                   // paramArray.Add(checkSize.Checked.ToString());
                    paramArray.Add(checkThk.Checked.ToString());
                    paramArray.Add(checkWth.Checked.ToString());
                    //成分
                    paramArray.Add(checkIngr.Checked.ToString());
                    //材质
                    paramArray.Add(checkMaterial.Checked.ToString());
                    //表面
                    paramArray.Add(checkShapFace.Checked.ToString());
                    //订单单重
                    paramArray.Add(checkUnitWgt.Checked.ToString());
                    //同内径
                    paramArray.Add(checkIn.Checked.ToString());
                    //同包装
                    paramArray.Add(checkPack.Checked.ToString());
                }
                else if (matType.Equals("PLTCM03"))//酸洗成品
                {
                    paramArray.Add("UIE043010.SuanxiCoilComm.Select");
                    paramArray.Add(primaryOrdNO);
                    paramArray.Add(primaryOrdSeq);
                    //判定
                    paramArray.Add(checkDgrd.Checked.ToString());
                    //牌号
                    paramArray.Add(checkStlGrd.Checked.ToString());
                    //尺寸
                    // paramArray.Add(checkSize.Checked.ToString());
                    paramArray.Add(checkThk.Checked.ToString());
                    paramArray.Add(checkWth.Checked.ToString());
                    //成分
                    paramArray.Add(checkIngr.Checked.ToString());
                    //材质
                    paramArray.Add(checkMaterial.Checked.ToString());
                    //表面
                    paramArray.Add(checkShapFace.Checked.ToString());
                    //订单单重
                    paramArray.Add(checkUnitWgt.Checked.ToString());
                    //同内径
                    paramArray.Add(checkIn.Checked.ToString());
                    //同包装
                    paramArray.Add(checkPack.Checked.ToString());
                }
                else if (matType.Equals("PLTCM04"))//酸洗原料
                 {
                    paramArray.Add("UIE043010.SXHOTCoilComm.Select");
                    paramArray.Add(primaryOrdNO);
                    paramArray.Add(primaryOrdSeq);
                    paramArray.Add(ORD_THK_MIN);
                    paramArray.Add(ORD_THK_MAX);

                    //判定
                    paramArray.Add(checkDgrd.Checked.ToString());
                    //牌号
                    paramArray.Add(checkStlGrd.Checked.ToString());
                    //尺寸
                   // paramArray.Add(checkSize.Checked.ToString());
                    paramArray.Add(checkThk.Checked.ToString());
                    paramArray.Add(checkWth.Checked.ToString());
                    //成分
                    paramArray.Add(checkIngr.Checked.ToString());
                    //材质
                    paramArray.Add(checkMaterial.Checked.ToString());
                    //订单单重
                    paramArray.Add(checkUnitWgt.Checked.ToString());
                    //同内径
                    paramArray.Add(checkIn.Checked.ToString());
                    //同包装
                    paramArray.Add(checkPack.Checked.ToString());
                }
                else if (matType.Equals("CAL01"))
                {
                    paramArray.Add("UIE043010.CALCoilComm.Select");
                    paramArray.Add(primaryOrdNO);
                    paramArray.Add(primaryOrdSeq);
                    //判定
                    paramArray.Add(checkDgrd.Checked.ToString());
                    //牌号
                    paramArray.Add(checkStlGrd.Checked.ToString());
                    //尺寸
                  //  paramArray.Add(checkSize.Checked.ToString());
                    paramArray.Add(checkThk.Checked.ToString());
                    paramArray.Add(checkWth.Checked.ToString());
                    //成分
                    paramArray.Add(checkIngr.Checked.ToString());
                    //材质
                    paramArray.Add(checkMaterial.Checked.ToString());
                    //表面
                    paramArray.Add(checkShapFace.Checked.ToString());
                    //订单单重
                    paramArray.Add(checkUnitWgt.Checked.ToString());
                    //同内径
                    paramArray.Add(checkIn.Checked.ToString());
                    //同包装
                    paramArray.Add(checkPack.Checked.ToString());


                }
                else
                {
                    return;
                }

                if (primaryOrdNO == null || "".Equals(primaryOrdNO) || primaryOrdSeq == null || "".Equals(primaryOrdSeq))
                {
                    return;
                }
                ccp.ServerParams = new object[] { paramArray };
                ccp.SourceDataTable = this.dataSet2.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                Console.WriteLine(this.dataSet2.Tables[0].ToString());

            }
            catch (Exception EX)
            {
                MessageBox.Show(EX.ToString());
            }
        }

        public void Save()
        {
            Hashtable paramHsmp = new Hashtable();
            StringBuilder strBf = new StringBuilder();

            this.ultraGrid2.UpdateData();
            DataRow[] selectedRows = dataSet2.Tables[0].Select("CHK ='True'");
            //this.ultraGrid2.ActiveRow.Cells["CHK"].Text == "True"
            string msg = "";
            string retCD = "";

            string repStyle = Common.FixDBManager.CheckNullStr(Convert.ToString(this.ComboOrdCnt.Value));
            string repOrdCnt = Common.FixDBManager.CheckNullStr(Convert.ToString(this.repOrdCnt.Text));
            string repKind = Common.FixDBManager.CheckNullStr(Convert.ToString(this.ComboMatType.Value));
            try
            {
                for (int i = 0; i < selectedRows.Length; i++)
                {
                    if (repKind.Equals("CAL01") && this.checkMaterial.Checked != true)
                    {
                        //直接在C#中调用后台Java方法，返回订单、钢卷对应的材质项目
                        CoreClientParam ccp2 = new CoreClientParam();
                        ccp2.ServerName = "UIE.UIE03.UIE043010";
                        ccp2.MethodName = "compareOrdCoilQlty";
                        ccp2.ServerParams = new Object[] { selectedRows[i]["MAT_NO"], primaryOrdNO, primaryOrdSeq };
                        this.ExecuteNonQuery(ccp2, CoreInvokeType.Internal);
                        //状态返回
                        if (null != ccp2.ReturnInfo && "" != ccp2.ReturnInfo && ccp2.ReturnCode == 1)
                        {
                            if (MessageBox.Show(ccp2.ReturnInfo + "\n所选钢卷材质与订单要求材质项目不一致！！可先去充当改判界面改判后再充当，若继续强制充当则可能导致质保书上缺失材质信息！！确定要继续充当吗？", "确认提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
                            {
                                strBf.Append(selectedRows[i]["MAT_NO"]).Append("|");
                            }
                        }
                        else if (null != ccp2.ReturnInfo && "GP".Equals(ccp2.ReturnInfo))
                        {
                            MessageBox.Show("钢卷：" + selectedRows[i]["MAT_NO"] + " 正在改判中，不能充当！", "提示");
                        }
                        else
                            strBf.Append(selectedRows[i]["MAT_NO"]).Append("|");

                       //System.Collections.ArrayList err = obj.ReturnObject as System.Collections.ArrayList;
                       //if (err != null && err.Count > 0 && err[0] != null)
                       //{
                       //    string retInfo = err[0].ToString().Trim();
                       //    //表示钢卷材质项目与订单匹配
                       //    if (retInfo == "YY" || retInfo == "NO")
                       //    { }
                       //}

                    } else
                        strBf.Append(selectedRows[i]["MAT_NO"]).Append("|");
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }

            StringBuilder reptp = new StringBuilder();

            //成分
            if (this.checkIngr.Checked == true) { reptp.Append("CF").Append("|"); }
            //材质
            if (this.checkMaterial.Checked == true) { reptp.Append("CZ").Append("|"); }
            //尺寸
            //if (this.checkSize.Checked == true) { reptp.Append("CC").Append("|"); }
            //尺寸替换为厚度宽度  20181121--wl
            if (this.checkThk.Checked == true) { reptp.Append("HD").Append("|"); }
            if (this.checkWth.Checked == true) { reptp.Append("KD").Append("|"); }
            //牌号
            if (this.checkStlGrd.Checked == true) { reptp.Append("PH").Append("|"); }
            //表面
            if (this.checkShapFace.Checked == true) { reptp.Append("BM").Append("|"); }
            //判定
            //if (this.checkDgrd.Checked == true) { reptp.Append("PD").Append("|"); }
            //订单单重
            if (this.checkUnitWgt.Checked == true) { reptp.Append("DZ").Append("|"); }
            
            if (repStyle.Equals(""))
            {
                this.ComboOrdCnt.Value = "A";
                repStyle = "A";
            }

            if (!(repStyle.Equals("A") || repStyle.Equals("B") || repStyle.Equals("C")))
            {
                System.Windows.Forms.MessageBox.Show(" 充当类型选择错误！ ");
                return;
            }

            if (repStyle.Equals("B"))
            {
                if ((ordNO2 != null || ordNO3 != null) && (!ordNO2.Equals("") || !ordNO3.Equals("")))
                {
                    System.Windows.Forms.MessageBox.Show(" 充当类型选择错误！ ");
                    return;
                }

                if (Convert.ToInt32(repOrdCnt) < 1)
                {
                    System.Windows.Forms.MessageBox.Show(" 分卷数错误！ ");
                    return;
                }
            }

            
            //操作人
            paramHsmp.Add("i1", this.UserInfo.GetUserID());
            //操作程序
            paramHsmp.Add("i2", "UIE043010");
            paramHsmp.Add("i3", ordNO1);
            paramHsmp.Add("i4", ordNO2);
            paramHsmp.Add("i5", ordNO3);
            paramHsmp.Add("i6", ordSeq1);
            paramHsmp.Add("i7", ordSeq2);
            paramHsmp.Add("i8", ordSeq3);
            paramHsmp.Add("i9", primaryOrdNO);
            paramHsmp.Add("i10", primaryOrdSeq);
            paramHsmp.Add("i11", strBf.ToString());
            paramHsmp.Add("i12", reptp.ToString());
            paramHsmp.Add("i13", repStyle);
            paramHsmp.Add("i14", repOrdCnt);
            paramHsmp.Add("i15", repKind);
            paramHsmp.Add("o16", retCD);
            paramHsmp.Add("o17", msg);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "UIB.COM.ComDBProcedure";
            ccp.MethodName = "doXmlProcedure";
            ccp.ServerParams = new Object[] { "UIE043010_ORD_REP.call", paramHsmp };
            this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            this.find();
            //System.Diagnostics.Debug.WriteLine(this.dataSet1.Tables[0]);
        }

        #endregion

        #region "init"

        public void init()
        {
            string tt = System.DateTime.Today.Year.ToString() + "-" + System.DateTime.Today.Month.ToString() + "-" + "01 00:00:00";
            string tb = System.DateTime.Today.Year.ToString() + "-" + System.DateTime.Today.Month.ToString() + "-" + "28 00:00:00";
            System.DateTime firstDate = Convert.ToDateTime(tt);
            System.DateTime lastDate = Convert.ToDateTime(tb);
            this.DelToDateFrom.Value = firstDate;
            this.DelToDateTo.Value = lastDate;

            string commCodeCd = "A01007,A01004,A01001,B01016,E01014,E01016";
            DataTable dt = new DataTable();
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "UIB.COM.ComDBQuery";
            ccp.MethodName = "doSimpleQuery";
            ArrayList paramArray = new ArrayList();
            paramArray.Add("UIECOMM00_SELECT.COMM_CODE");
            paramArray.Add(commCodeCd);
            ccp.ServerParams = new object[] { paramArray };
            ccp.SourceDataTable = dt;
            this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
            Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.CombUseCD, ref dt, "A01007");
            Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.CombProdType, ref dt, "A01004");
            Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.CombOrdType, ref dt, "A01001");
            Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.CombShapGrd, ref dt, "B01016");
            Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.ComboMatType, ref dt, "E01014");
            Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.ComboOrdCnt, ref dt, "E01016");
            ComboMatType.Value = "PLTCM01";

            dt = new DataTable();
            ccp = new CoreClientParam();
            ccp.ServerName = "UIB.COM.ComDBQuery";
            ccp.MethodName = "doSimpleQuery";
            paramArray = new ArrayList();
            paramArray.Add("UIECOMM00_SELECT.C_STL_GRD");
            ccp.ServerParams = new object[] { paramArray };
            ccp.SourceDataTable = dt;
            this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
            Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.CombStlGrd, ref dt, "C_STL_GRD");
        }

        private void UIE043010_Load(object sender, EventArgs e)
        {
            init();
        }

        #endregion

        #region "Event"

        private void cellChangeEvent(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
        {
            if (this.ultraGrid1.ActiveCell == ultraGrid1.ActiveRow.Cells["CHK"])
            {
                if (e.Cell.Text.ToString() == "False")
                {
                    if (ordCell1 == e.Cell)
                    {
                        ordNO1 = null;
                        ordSeq1 = null;
                        this.TextRemWgt1.Text = null;
                        ordCell1 = null;

                    }
                    else if (ordCell2 == e.Cell)
                    {
                        ordNO2 = null;
                        ordSeq2 = null;
                        this.TextRemWgt2.Text = null;
                        ordCell2 = null;
                    }
                    else if (ordCell3 == e.Cell)
                    {
                        ordNO3 = null;
                        ordSeq3 = null;
                        this.TextRemWgt3.Text = null;
                        ordCell3 = null;
                    }
                }
                else
                {

                    if (ordCell3 != null && ordCell2 != null && ordCell1 != null)
                    {
                        System.Windows.Forms.MessageBox.Show("错误：最多只能选择三个订单！");
                        e.Cell.Value = "false";
                        return;
                    }

                    if (ordCell1 == null)
                    {
                        ordCell1 = e.Cell;
                        ordNO1 = Convert.ToString(ultraGrid1.ActiveRow.Cells["ORD_NO"].Value);
                        ordSeq1 = Convert.ToString(ultraGrid1.ActiveRow.Cells["ORD_SEQ"].Value);
                        this.TextRemWgt1.Text = Convert.ToString(ultraGrid1.ActiveRow.Cells["ORD_REM_WGT"].Value);

                    }
                    else if (ordCell2 == null)
                    {
                        ordCell2 = e.Cell;
                        ordNO2 = Convert.ToString(ultraGrid1.ActiveRow.Cells["ORD_NO"].Value);
                        ordSeq2 = Convert.ToString(ultraGrid1.ActiveRow.Cells["ORD_SEQ"].Value);
                        this.TextRemWgt2.Text = Convert.ToString(ultraGrid1.ActiveRow.Cells["ORD_REM_WGT"].Value);
                    }
                    else if (ordCell3 == null)
                    {
                        ordCell3 = e.Cell;
                        ordNO3 = Convert.ToString(ultraGrid1.ActiveRow.Cells["ORD_NO"].Value);
                        ordSeq3 = Convert.ToString(ultraGrid1.ActiveRow.Cells["ORD_SEQ"].Value);
                        this.TextRemWgt3.Text = Convert.ToString(ultraGrid1.ActiveRow.Cells["ORD_REM_WGT"].Value);
                    }
                }
            }
            if (this.ultraGrid1.ActiveCell == ultraGrid1.ActiveRow.Cells["PRIMARY_ORD_CHK"])
            {
                if (e.Cell.Text.ToString() == "False")
                {
                    primaryOrdNO = null;
                    primaryOrdSeq = null;
                    primaryCell = null;
                }
                else
                {
                    if (primaryCell != null)
                    {
                        System.Windows.Forms.MessageBox.Show("错误：最多只能选择一个判定标准订单！");
                        e.Cell.Value = "false";
                        return;
                    }

                    primaryCell = e.Cell;
                    primaryOrdNO = Convert.ToString(ultraGrid1.ActiveRow.Cells["ORD_NO"].Value);
                    primaryOrdSeq = Convert.ToString(ultraGrid1.ActiveRow.Cells["ORD_SEQ"].Value);

                    DataTable dttb = new DataTable();
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "UIB.COM.ComDBQuery";
                    ccp.MethodName = "doSimpleQuery";
                    ArrayList paramArray = new ArrayList();
                    paramArray.Add("UIE043010_ORD_THK.select");
                    paramArray.Add(primaryOrdNO);
                    paramArray.Add(primaryOrdSeq);
                    ccp.ServerParams = new object[] { paramArray };
                    ccp.SourceDataTable = dttb;
                    this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                    if (dttb.Rows.Count == 0)
                    {
                        System.Windows.Forms.MessageBox.Show("缺少热轧规格标准");
                        return;
                    }
                    string ORD_THK_MIN = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["DEL_TOL_THK_MIN"]));
                    string ORD_THK_MAX = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["DEL_TOL_THK_MAX"]));
                    string ORD_THK = Convert.ToString(Common.FixDBManager.CheckNullStr(dttb.Rows[0]["ORD_THK"]));

                    this.TextOrdThk.Text = ORD_THK;
                    this.TextOrdThkMin.Text = ORD_THK_MIN;
                    this.TextOrdThkMax.Text = ORD_THK_MAX;
                }
            }
            
            
        }

        private void checkBox1_CheckedChanged(object sender, EventArgs e)
        {
            try
            {
                foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in this.ultraGrid2.Rows)
                {
                    ugr.Cells["CHK"].Value = this.checkBox1.Checked;
                    ugr.Update();
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }

        private void ultraGrid1_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
        {
            cellChangeEvent(sender, e);
        }

        private void ComboMatType_ValueChanged(object sender, EventArgs e)
        {
            if (this.ComboMatType.Value.Equals("PLTCM01") || this.ComboMatType.Value.Equals("PLTCM04"))
            {
                this.checkShapFace.Visible = false ;

                this.checkIngr.Checked = true;//成分
                this.checkMaterial.Checked = true;//材质
                this.checkSize.Checked = true;//尺寸
                this.checkStlGrd.Checked = true;//牌号
                this.checkShapFace.Checked = false;//表面
                this.checkDgrd.Checked = true;//判定
                this.checkUnitWgt.Checked = true;//订单单重

                this.checkIngr.Enabled = true;//成分
                this.checkMaterial.Enabled = true;//材质
                this.checkSize.Enabled = true;//尺寸
                this.checkStlGrd.Enabled = true;//牌号
                this.checkShapFace.Enabled = false;//表面
                this.checkDgrd.Enabled = true;//判定
                this.checkUnitWgt.Enabled = true;//订单单重
            }
            else if (this.ComboMatType.Value.Equals("PLTCM02"))
            {
                this.checkShapFace.Visible = true;

                this.checkIngr.Checked = true;//成分
                this.checkMaterial.Checked = true;//材质
                this.checkSize.Checked = true;//尺寸
                this.checkStlGrd.Checked = true;//牌号
                this.checkShapFace.Checked = true;//表面
                this.checkDgrd.Checked = true;//判定
                this.checkUnitWgt.Checked = true;//订单单重

                this.checkIngr.Enabled = true;//成分
                this.checkMaterial.Enabled = true;//材质
                this.checkSize.Enabled = true;//尺寸
                this.checkStlGrd.Enabled = true;//牌号
                this.checkShapFace.Enabled = true;//表面
                this.checkDgrd.Enabled = true;//判定
                this.checkUnitWgt.Enabled = true;//订单单重
            }
            else if (this.ComboMatType.Value.Equals("PLTCM03"))
            {
                this.checkShapFace.Visible = true;

                this.checkIngr.Checked = true;//成分
                this.checkMaterial.Checked = true;//材质
                this.checkSize.Checked = true;//尺寸
                this.checkStlGrd.Checked = true;//牌号
                this.checkShapFace.Checked = true;//表面
                this.checkDgrd.Checked = true;//判定
                this.checkUnitWgt.Checked = true;//订单单重

                this.checkIngr.Enabled = true;//成分
                this.checkMaterial.Enabled = true;//材质
                this.checkSize.Enabled = true;//尺寸
                this.checkStlGrd.Enabled = true;//牌号
                this.checkShapFace.Enabled = true;//表面
                this.checkDgrd.Enabled = true;//判定
                this.checkUnitWgt.Enabled = true;//订单单重
            }
            else if (this.ComboMatType.Value.Equals("CAL01"))
            {
                this.checkShapFace.Visible = true;

                this.checkIngr.Checked = true;//成分
                this.checkMaterial.Checked = true;//材质
                this.checkSize.Checked = true;//尺寸
                this.checkStlGrd.Checked = true;//牌号
                this.checkShapFace.Checked = true;//表面
                this.checkDgrd.Checked = true;//判定
                this.checkUnitWgt.Checked = true;//订单单重

                this.checkIngr.Enabled = true;//成分
                this.checkMaterial.Enabled = true;//材质
                this.checkSize.Enabled = true;//尺寸
                this.checkStlGrd.Enabled = true;//牌号
                this.checkShapFace.Enabled = true;//表面
                this.checkDgrd.Enabled = true;//判定
                this.checkUnitWgt.Enabled = true;//订单单重
            }
            this.find();

        }

        #endregion
    }
}