MES_Client/TGMES/Core.StlMes.Client.Lims.Data.PipeAndOutdec/数据管理/钢管实验管理/FrmCheckConsignAdd.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 Infragistics.Win.UltraWinGrid;
using System.Collections;
using Core.Mes.Client.Comm.Tool;

namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec
{
    public partial class FrmCheckConsignAdd : FrmBase
    {
        //private DataTable m_dtSelectPhyMax;//已选择的大项

        //public DataTable DtSelectPhyMax
        //{
        //    get { return m_dtSelectPhyMax; }
        //    set { m_dtSelectPhyMax = value; }
        //}

        private string letter = "";
        private string[] plineCodes = { };
        //private string checkNo = "";
        private DataTable m_dtSelectPhySampleCode;//选择的取样码

        public DataTable DtSelectPhySampleCode
        {
            get { return m_dtSelectPhySampleCode; }
            set { m_dtSelectPhySampleCode = value; }
        }

        private DataTable m_dtSelectPhyMin;//已选择的小项

        public DataTable DtSelectPhyMin
        {
            get { return m_dtSelectPhyMin; }
            set { m_dtSelectPhyMin = value; }
        }

        private DataTable m_dtSelectPhyR;//已选择的方向温度尺寸

        public DataTable DtSelectPhyR
        {
            get { return m_dtSelectPhyR; }
            set { m_dtSelectPhyR = value; }
        }

        public FrmCheckConsignAdd()
        {
            InitializeComponent();
        }

        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            publicUltraGridDetail1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
            publicUltraGridChemDetail1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            plineCodes = comm.GetPlineCode(ValidDataPurviewIds, ob);
        }

        private void FrmCheckConsignAdd_Load(object sender, EventArgs e)
        {
            InitColumns();
            InitBase();
        }
        //加载基础信息
        private void InitBase()
        {
            PublicPipeAndOutdec.InitComboEditor(ultraSTEEL_NO, "com.steering.lims.data.pipe.FrmCheckConsignAdd.queryGrade", "GRADECODE", this.ob, false);//钢种
            PublicPipeAndOutdec.InitComboEditor(ultraSTEEL_GRADE, "com.steering.lims.data.pipe.FrmCheckConsignAdd.querySteel", "STEELCODE", this.ob, false);//钢级
            PublicPipeAndOutdec.InitComboEditor(ultraPRODUCT_STD, "com.steering.lims.data.pipe.FrmCheckConsignAdd.queryStd", "STD_CODE", this.ob, false);//产品标准
            PublicPipeAndOutdec.InitComboEditor(ultraDIMATER, "com.steering.lims.data.pipe.FrmCheckConsignAdd.queryDimater", "SPEC_CODE", this.ob, false);//外径
            PublicPipeAndOutdec.InitComboEditor(ultraHEIGHT, "com.steering.lims.data.pipe.FrmCheckConsignAdd.queryHeight", "SPEC_CODE", this.ob, false);//壁厚
        }

        private void InitColumns()
        {
            publicUltraGridBase1.PublicUltraGridBaseActive += new EventHandler(outdecUltraGridBase1_PublicUltraGridBaseActive);//调用委托事件

            publicUltraGridDetail1.UltraGrid1.CellChange += new CellEventHandler(UltraGrid1_CellChange);

            string[] arrColumnsBase = new string[] { "CHECK_NO", "HEAT_NO", "STEEL_GRADE", "STEEL_NO", "PRODUCT_STD", "CONTRACT_NO", "DIMATER", "HEIGHT", "CONSIGN_DEPT", "CONSIGN_NAME", "CONSIGN_TIME", "ISPRODUCER", "SPEC_REQ", "FLAG", "FLAG_DESC", "REMARK", "PLINE_CODE", "CRAFT_SOURCE", "LOT_NO", "CRAFT_PATH", "CRAFT_FILE_NO" };
            string[] arrCaptionBase = new string[] { "检验编号", "炉号", "钢级", "钢号", "技术标准", "合同号", "外径", "壁厚", "委托单位", "委托人", "委托时间", "是否监制", "特殊要求", "标志位", "标志位", "备注", "产线", "委托类型", "生产批号", "工艺文件路径", "工艺文件号" };
            publicUltraGridBase1.InitColumns(arrColumnsBase, arrCaptionBase);
            publicUltraGridBase1.setColumnShowOrHidden(new string[] { "CHECK_NO" }, true);
            publicUltraGridBase1.setOtherColumnReadOnly(null);//可编辑列

            string[] arrColumns = new string[] { "CHK", "SAMPLE_NO", "HX", "ONH" };//"FLAG",
            string[] arrCaption = new string[] { "选择", "样管号", "化学", "ONH" };//"试样状态",

            publicUltraGridDetail1.InitColumns(arrColumns, arrCaption);
            //publicUltraGridDetail1.setColumnShowOrHidden(new string[] { "FLAG" }, false);//不需要显示的行
            publicUltraGridDetail1.Ug.DisplayLayout.Bands[0].Override.AllowAddNew = AllowAddNew.TemplateOnBottom;

            //加载产线
            DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.queryPlineCode", new object[] { plineCodes }, ob);
            if (dt != null && dt.Rows.Count > 0)
            {
                PPLINE_CODE.DataSource = dt;
                PPLINE_CODE.ValueMember = "PLINE_CODE";
                PPLINE_CODE.DisplayMember = "PLINE_NAME";
            }
            
        }

        void UltraGrid1_CellChange(object sender, CellEventArgs e)
        {
            if ((e.Cell.Column.Key.Equals("HX") || e.Cell.Column.Key.Equals("ONH")) && e.Cell.Text.Trim() != "" && publicUltraGridChemDetail1.DataTable.Select("SAMPLE_NO = '" + e.Cell.Row.Cells["SAMPLE_NO"].Text.Trim() + "'").Length == 0)
            {
                DataRow dr = publicUltraGridChemDetail1.DataTable.NewRow();
                dr["SAMPLE_NO"] = e.Cell.Row.Cells["SAMPLE_NO"].Text.Trim();
                publicUltraGridChemDetail1.DataTable.Rows.Add(dr);
            }
            else if ((e.Cell.Column.Key.Equals("HX") || e.Cell.Column.Key.Equals("ONH")) && e.Cell.Text.Trim() == "")
            {
                foreach (DataRow dr in publicUltraGridChemDetail1.DataTable.Rows)
                {
                    if (dr["SAMPLE_NO"].ToString() == e.Cell.Row.Cells["SAMPLE_NO"].Text.Trim())
                    {
                        publicUltraGridChemDetail1.DataTable.Rows.Remove(dr);
                        return;
                    }
                }
            }
        }

        /// <summary>
        /// 重写基类方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            //新增、修改修约值、审核、删除、退出
            switch (ToolbarKey)
            {
                case "Query":
                    QueryCheckConsignBase();
                    break;
                case "Add":
                    AddCheckConsign();
                    break;
                case "Update":
                    UpdateCheckConsign();
                    break;
                case "Clear":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认清空？") == DialogResult.Yes)
                    {
                        ClearCheckConsign();
                        MessageUtil.ShowTips("清空成功！");
                    }
                    break;
                case "Delete":
                    DeleteCheckConsign();
                    break;
                case "Print":
                    printTrust();
                    break;
                case "PrintLable":
                    printLable();
                    break;
                case "Close":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
                    {
                        this.Close();
                    }
                    break;
            }
        }

        //查询检验委托基本信息
        /// <summary>
        /// 查询检验委托基本信息
        /// </summary>
        private void QueryCheckConsignBase()
        {
            try
            {
                //PublicPipeBase
                ArrayList arrayList = new ArrayList();
                arrayList = pipeQueryBase1.GetQueryInfo("012");
                arrayList.Add(plineCodes);
                publicUltraGridBase1.QueryCheckConsignBase("pipe.FrmCheckConsignAdd", arrayList, this.ob);
                if (publicUltraGridBase1.Ug.Rows.Count == 0)
                {
                    ClearCheckConsign();
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        void outdecUltraGridBase1_PublicUltraGridBaseActive(object sender, EventArgs e)
        {
            try
            {
                this.Cursor = Cursors.WaitCursor;
                ClearCheckConsign();
                ultraCRAFT_PATH.DataSource = null;
                PublicPipeAndOutdec.ShowBaseInfo(publicUltraGridBase1.Ur, panel4);
                QueryCheckConsignDetail();

                QueryCheckConsignChemDetail();

                //赋值给全局变量
                QueryCheckConsignPhyDetail("pipe.FrmCheckConsignAdd");//对于已经生成的委托单查询大项小项信息
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }

        //查询检验委托明细信息
        /// <summary>
        /// 查询检验委托明细信息
        /// </summary>
        private void QueryCheckConsignDetail()
        {
            try
            {
                ArrayList al = new ArrayList();

                al.Add("");
                al.Add(publicUltraGridBase1.Ug.ActiveRow.Cells["CHECK_NO"].Value.ToString());
                
                //al.Add(checkNo);
                publicUltraGridDetail1.QueryCheckConsignDetail("pipe.PublicPipeBase", al, this.ob, 4);

                //RefreshAutoSize();//自适应

                //if (publicUltraGridDetail1.DataTable != null)
                //{
                //    txtCheckNo.Text = publicUltraGridDetail1.DataTable.Rows.Count.ToString();
                //}
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
                return;
            }
        }

        //查询检验委托化学明细信息
        private void QueryCheckConsignChemDetail()
        {
            try
            {
                ArrayList al = new ArrayList();

                al.Add("");
                al.Add(publicUltraGridBase1.Ug.ActiveRow.Cells["CHECK_NO"].Value.ToString());
                //al.Add(checkNo);
                publicUltraGridChemDetail1.QueryCheckConsignChemDetail("pipe.PublicPipeBase", al, this.ob);

                //RefreshAutoSize();//自适应
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
                return;
            }
        }

        //查询检验委托基本信息
        /// <summary>
        /// 查询检验委托基本信息
        /// </summary>
        /// <param name="path"></param>
        private void QueryCheckConsignPhyDetail(string path)
        {
            try
            {
                ArrayList arrayList = new ArrayList();
                arrayList.Add(publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text);

                //DataTable dtMax = PublicServer.GetData("com.steering.lims.data." + path + ".QueryCheckConsignDetail",
                //           new Object[] { arrayList }, ob);

                //if (dtMax != null)
                //{
                //    m_dtSelectPhyMax = dtMax.Copy();
                //}

                DataTable dtSampleCode = PublicServer.GetData("com.steering.lims.data." + path + ".QueryCheckConsignPhyDetail_SampleCode",
new Object[] { arrayList }, ob);

                if (dtSampleCode != null)
                {
                    m_dtSelectPhySampleCode = dtSampleCode.Copy();
                }

                DataTable dtMin = PublicServer.GetData("com.steering.lims.data." + path + ".QueryCheckConsignPhyDetail",
           new Object[] { arrayList }, ob);

                if (dtMin != null)
                {
                    m_dtSelectPhyMin = dtMin.Copy();
                }

                DataTable dtR = PublicServer.GetData("com.steering.lims.data." + path + ".QueryCheckConsignPhyDetail_R",
new Object[] { arrayList }, ob);

                if (dtR != null)
                {
                    m_dtSelectPhyR = dtR.Copy();
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            switch (e.Tool.Key.ToString())
            {
                case "AddPhy":
                    AddPhyItems();
                    break;
            }
        }

        //增加理化检验项目
        /// <summary>
        /// 增加理化检验项目
        /// </summary>
        private void AddPhyItems()
        {
            //20160704
            FrmBaseSelectItems _selectItems = new FrmBaseSelectItems(this.ob);//0810
            //_selectItems.DtSelectPhyMax = m_dtSelectPhyMax;
            _selectItems.DtSelectPhySampleCode = m_dtSelectPhySampleCode;//20160522
            _selectItems.DtSelectPhyMin = m_dtSelectPhyMin;
            _selectItems.DtSelectPhyR = m_dtSelectPhyR;

            _selectItems.ShowDialog();

            //m_dtSelectPhyMax = _selectItems.DtSelectPhyMax;//接受FrmSelectItems参数
            m_dtSelectPhySampleCode = _selectItems.DtSelectPhySampleCode;
            m_dtSelectPhyMin = _selectItems.DtSelectPhyMin;
            m_dtSelectPhyR = _selectItems.DtSelectPhyR;

            publicUltraGridDetail1.AddColumns(4, m_dtSelectPhySampleCode, publicUltraGridDetail1.DataTable);//把选中的大项增加到publicUltraGridDetail1.DataTable
        }

        //增加检验委托
        /// <summary>
        /// 增加检验委托
        /// </summary>
        private void AddCheckConsign()
        {
            try
            {
                if (txtCHECK_NO.Text.Trim() == "")
                {
                    MessageUtil.ShowWarning("检验编号不能为空！");
                    return;
                }
                if (ultraCRAFT_SOURCE.Value.ToString() == "7")
                {
                    if (txtHEAT_NO.Text.ToString().Trim() == "")
                    {
                        MessageUtil.ShowTips("炉号不能为空！");
                        return;
                    }
                    if (txtBATCH_NO.Text.ToString().Trim() == "")
                    {
                        MessageUtil.ShowTips("性能批号不能为空！");
                        return;
                    }
                    if (ultraCRAFT_FILE_NO.Text.ToString().Trim() == "")
                    {
                        MessageUtil.ShowTips("工艺文件不能为空！");
                        return;
                    }
                    if (ultraCRAFT_PATH.Text.ToString().Trim() == "")
                    {
                        MessageUtil.ShowTips("工艺文件路径不能为空！");
                        return;
                    }

                }

                if (ultraCRAFT_SOURCE.Value.ToString() == "6")
                {
                    AddCheckConsignHTT();
                }
                else 
                {
                    if (PPLINE_CODE.Text.Trim() == "")
                    {
                        MessageUtil.ShowTips("产线不能为空!");
                        return;
                    }
                    string strAddChem = isChem();
                    if (strAddChem != "")
                    {
                        MessageUtil.ShowWarning(strAddChem);
                        return;
                    }
                    //if (m_dtSelectPhyMax == null || m_dtSelectPhyMin == null || m_dtSelectPhyR == null)
                    //{
                    //    MessageUtil.ShowWarning("请选择合适的检验项目！");
                    //    return;
                    //}
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认新增？") == DialogResult.Yes)
                    {
                        //string strCHECK_NO = checkNo;
                        string strCHECK_NO = txtCHECK_NO.Text.Trim();//检验委托编号
                        string strBATCH_NO = txtBATCH_NO.Text.Trim();//性能批号

                        string SUPPLY_UNIT_CODE = "";
                        string SUPPLY_UNIT = "";
                        DataTable dts = PublicServer.GetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.queryPlineCode3", new Object[] { PPLINE_CODE.Value.ToString().Substring(0, 4) }, ob);
                        if (dts.Rows.Count > 0)
                        {
                            SUPPLY_UNIT_CODE = dts.Rows[0]["SUPPLY_UNIT_CODE"].ToString();
                            SUPPLY_UNIT = dts.Rows[0]["SUPPLY_UNIT"].ToString();
                        }

                        ArrayList alAll = new ArrayList();//整体list,插入几个表增加几个List

                        ArrayList alBase = new ArrayList();//基础表list
                        ArrayList alDetail = new ArrayList();//检验信息详细表list
                        ArrayList alPhyDetail = new ArrayList();//理化信息list
                        ArrayList alChemDetail = new ArrayList();//化学信息list

                        ArrayList alBaseParams = new ArrayList();//基础表参数list
                        ArrayList alDetailParams = new ArrayList();//检验信息详细表参数list
                        ArrayList alPhyDetailParams = new ArrayList();//理化信息参数list
                        ArrayList alChemDetailParams = new ArrayList();//化学信息参数list

                        alBase.Add(GetCheckConsignBase());//增加基础表参数

                        if (publicUltraGridDetail1.DataTable.Rows.Count > 0)
                        {
                            publicUltraGridDetail1.Ug.UpdateData();
                            ArrayList al = publicUltraGridChemDetail1.GetCheckChem();
                            bool isHaveChem = false;//判断是否有化学元素
                            int i = 0;
                            foreach (DataRow dr in publicUltraGridDetail1.DataTable.Rows)
                            {
                                isHaveChem = false;
                                string strSAMPLE_NO = dr["SAMPLE_NO"].ToString().Trim();
                                DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.querySampleNo", new Object[] { strSAMPLE_NO }, ob);
                                if (dt.Rows.Count > 0)
                                {
                                    if (!dt.Rows[0][0].Equals("0"))
                                    {
                                        MessageUtil.ShowTips("试样号：" + strSAMPLE_NO + "已存在，请换一个试样号!");
                                        return;
                                    }
                                }

                                if (dr["CHK"].ToString() == "True" && strSAMPLE_NO != "")
                                {
                                    foreach (DataColumn dc in publicUltraGridDetail1.DataTable.Columns)
                                    {
                                        if (dc.ColumnName != "CHK" && dc.ColumnName != "SAMPLE_NO" && dr[dc.ColumnName].ToString().Trim() != "")//列不为SAMPLE_NO才增加
                                        {
                                            string strPHY_CODE_MAX = dc.ColumnName;
                                            string strPHY_NAME_MAX = dc.Caption.Trim();
                                            string strSAMPLE_COUNT = dr[strPHY_CODE_MAX].ToString().Trim();

                                            alDetailParams = new ArrayList();//增加明细表参数
                                            alDetailParams.Add(strCHECK_NO);
                                            alDetailParams.Add(strSAMPLE_NO);
                                            alDetailParams.Add(strBATCH_NO);

                                            alDetailParams.Add(strPHY_CODE_MAX);
                                            if (strPHY_CODE_MAX == "HX")
                                            {
                                                alDetailParams.Add(((ArrayList)al[i])[0]);
                                                if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司")) 
                                                {
                                                    alDetailParams.Add(getDeptID("002001007010"));
                                                }
                                                else 
                                                {
                                                    alDetailParams.Add("002001007010");
                                                }
                                                isHaveChem = true;
                                            }
                                            else if (strPHY_CODE_MAX == "ONH")
                                            {
                                                alDetailParams.Add(((ArrayList)al[i])[1]);
                                                if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司"))
                                                {
                                                    alDetailParams.Add(getDeptID("002001007010"));
                                                }
                                                else
                                                {
                                                    alDetailParams.Add("002001007010");
                                                }
                                                isHaveChem = true;
                                            }
                                            else if (" C0011C0115,C0104C0012,C0013C0015C0050C0108C0109".IndexOf(strPHY_CODE_MAX) > 0)//非金属夹杂物、晶粒度、组织都归物理实验室
                                            {
                                                alDetailParams.Add(strPHY_NAME_MAX);
                                                if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司"))
                                                {
                                                    alDetailParams.Add(getDeptID("002001007015"));
                                                }
                                                else
                                                {
                                                    alDetailParams.Add("002001007015");
                                                }
                                            }
                                            else
                                            {
                                                alDetailParams.Add(strPHY_NAME_MAX);
                                                if (m_dtSelectPhySampleCode != null && m_dtSelectPhySampleCode.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'").Length > 0)
                                                {
                                                    
                                                    if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司"))
                                                    {
                                                        alDetailParams.Add(getDeptID(m_dtSelectPhySampleCode.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'")[0]["DEPT_ID"].ToString())); 
                                                    }
                                                    else
                                                    {
                                                        alDetailParams.Add(m_dtSelectPhySampleCode.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'")[0]["DEPT_ID"].ToString());
                                                    }
                                                    
                                                }
                                                else
                                                {
                                                    alDetailParams.Add("");
                                                }
                                            }
                                            alDetailParams.Add(strSAMPLE_COUNT);
                                            DataRow[] arrAddRDetail = new DataRow[] { };
                                            if (m_dtSelectPhyR != null)
                                            {
                                                arrAddRDetail = m_dtSelectPhyR.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'");//筛选符合条件的方向温度尺寸
                                            }

                                            if (arrAddRDetail.Length > 0)
                                            {
                                                alDetailParams.Add(arrAddRDetail[0]["ITEM_NAME_F"].ToString());//方向描述
                                                alDetailParams.Add(arrAddRDetail[0]["ITEM_NAME_C"].ToString());//尺寸描述

                                            }
                                            else
                                            {
                                                alDetailParams.Add("");
                                                alDetailParams.Add("");
                                            }
                                            alDetail.Add(alDetailParams);//增加明细表参数List

                                            //201508.05HC 修改
                                            //增加理化明细信息参数list 没选择则不新增
                                            if (m_dtSelectPhySampleCode != null && m_dtSelectPhyMin != null && m_dtSelectPhyR != null)
                                            {
                                                DataRow[] arrAddMin = m_dtSelectPhyMin.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'");//筛选符合条件的小项

                                                foreach (DataRow drMin in arrAddMin)
                                                {
                                                    //' AND PHY_CODE = '" + drMin["PHY_CODE"].ToString() + "'
                                                    DataRow[] arrAddR = m_dtSelectPhyR.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'");//筛选符合条件的方向温度尺寸
                                                    if (arrAddR.Length == 0)
                                                    {
                                                        alPhyDetailParams = new ArrayList();
                                                        alPhyDetailParams.Add(strCHECK_NO);
                                                        alPhyDetailParams.Add(strSAMPLE_NO);
                                                        alPhyDetailParams.Add(strBATCH_NO);
                                                        alPhyDetailParams.Add(strPHY_CODE_MAX);//大项代码
                                                        alPhyDetailParams.Add(strPHY_NAME_MAX);//大项描述
                                                        if (" C0011C0115,C0104C0012,C0013C0015C0050C0108C0109".IndexOf(strPHY_CODE_MAX) > 0)
                                                        {
                                                            if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司"))
                                                            {
                                                                alPhyDetailParams.Add(getDeptID("002001007015"));
                                                            }
                                                            else
                                                            {
                                                                alPhyDetailParams.Add("002001007015");
                                                            }
                                                            //alPhyDetailParams.Add("002001007015");//部门
                                                        }
                                                        else
                                                        {
                                                            if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司"))
                                                            {
                                                                alPhyDetailParams.Add(getDeptID(drMin["DEPT_ID"].ToString()));//部门
                                                            }
                                                            else
                                                            {
                                                                alPhyDetailParams.Add(drMin["DEPT_ID"].ToString());//部门
                                                            }
                                                            
                                                        }
                                                        alPhyDetailParams.Add(drMin["PHY_CODE_MIN"].ToString());//试样组
                                                        alPhyDetailParams.Add(drMin["PHY_NAME_MIN"].ToString());//试样组
                                                        alPhyDetailParams.Add(drMin["PHY_CODE"].ToString());//检验项代码
                                                        alPhyDetailParams.Add(drMin["PHY_NAME"].ToString());//检验项描述
                                                        alPhyDetailParams.Add(drMin["PHY_UNIT"].ToString());//值单位
                                                        alPhyDetailParams.Add("");//方向代码
                                                        alPhyDetailParams.Add("");//方向描述
                                                        alPhyDetailParams.Add("");//温度代码
                                                        alPhyDetailParams.Add("");//温度描述
                                                        alPhyDetailParams.Add("");//尺寸代码
                                                        alPhyDetailParams.Add("");//尺寸描述
                                                        alPhyDetail.Add(alPhyDetailParams);
                                                    }
                                                    else
                                                    {
                                                        foreach (DataRow drR in arrAddR)
                                                        {
                                                            alPhyDetailParams = new ArrayList();
                                                            alPhyDetailParams.Add(strCHECK_NO);
                                                            alPhyDetailParams.Add(strSAMPLE_NO);
                                                            alPhyDetailParams.Add(strBATCH_NO);
                                                            alPhyDetailParams.Add(strPHY_CODE_MAX);//大项代码
                                                            alPhyDetailParams.Add(strPHY_NAME_MAX);//大项描述
                                                            if (" C0011C0115,C0104C0012,C0013C0015C0050C0108C0109".IndexOf(strPHY_CODE_MAX) > 0)
                                                            {
                                                                if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司"))
                                                                {
                                                                    alPhyDetailParams.Add(getDeptID("002001007015"));
                                                                }
                                                                else
                                                                {
                                                                    alPhyDetailParams.Add("002001007015");
                                                                }
                                                                //alPhyDetailParams.Add("002001007015");//部门
                                                            }
                                                            else
                                                            {
                                                                if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司"))
                                                                {
                                                                    alPhyDetailParams.Add(getDeptID(drMin["DEPT_ID"].ToString()));//部门
                                                                }
                                                                else
                                                                {
                                                                    alPhyDetailParams.Add(drMin["DEPT_ID"].ToString());//部门
                                                                }
                                                                //alPhyDetailParams.Add(drMin["DEPT_ID"].ToString());//部门
                                                            }
                                                            alPhyDetailParams.Add(drMin["PHY_CODE_MIN"].ToString());//试样组
                                                            alPhyDetailParams.Add(drMin["PHY_NAME_MIN"].ToString());//试样组
                                                            alPhyDetailParams.Add(drMin["PHY_CODE"].ToString());//检验项代码
                                                            alPhyDetailParams.Add(drMin["PHY_NAME"].ToString());//检验项描述
                                                            alPhyDetailParams.Add(drMin["PHY_UNIT"].ToString());//值单位
                                                            alPhyDetailParams.Add(drR["ITEM_CODE_F"].ToString());//方向代码
                                                            alPhyDetailParams.Add(drR["ITEM_NAME_F"].ToString());//方向描述
                                                            alPhyDetailParams.Add(drR["ITEM_CODE_W"].ToString());//温度代码
                                                            alPhyDetailParams.Add(drR["ITEM_NAME_W"].ToString());//温度描述
                                                            alPhyDetailParams.Add(drR["ITEM_CODE_C"].ToString());//尺寸代码
                                                            alPhyDetailParams.Add(drR["ITEM_NAME_C"].ToString());//尺寸描述
                                                            alPhyDetail.Add(alPhyDetailParams);
                                                        }
                                                    }
                                                }
                                            }
                                        }
                                    }
                                }
                                if (isHaveChem)
                                {
                                    i++;
                                }
                            }
                        }
                        if (publicUltraGridChemDetail1.Ug.Rows.Count > 0)
                        {
                            publicUltraGridChemDetail1.Ug.UpdateData();
                            foreach (DataRow dr in publicUltraGridChemDetail1.DataTable.Rows)
                            {
                                foreach (DataColumn dc in publicUltraGridChemDetail1.DataTable.Columns)
                                {
                                    string strCHEM_NAME = dc.Caption;
                                    DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.querySampleNoHX", new Object[] { dr["SAMPLE_NO"].ToString() }, ob);
                                    if (dt.Rows.Count > 0)
                                    {
                                        if (!dt.Rows[0][0].Equals("0"))
                                        {
                                            MessageUtil.ShowTips("试样号：" + dr["SAMPLE_NO"].ToString() + "已存在，请换一个试样号!");
                                            return;
                                        }
                                    }

                                    if (strCHEM_NAME != "样管号" && dr["ANA_" + strCHEM_NAME.ToUpper()].ToString() == "√")
                                    {
                                        alChemDetailParams = new ArrayList();//增加化学明细表参数
                                        alChemDetailParams.Add(strCHECK_NO);
                                        alChemDetailParams.Add(dr["SAMPLE_NO"].ToString());
                                        alChemDetailParams.Add(strBATCH_NO);
                                        alChemDetailParams.Add(strCHEM_NAME);
                                        alChemDetailParams.Add(strCHEM_NAME);
                                        alChemDetail.Add(alChemDetailParams);
                                    }
                                }
                            }
                        }

                        alAll.Add(alBase);
                        //alAll.Add(alJg);
                        alAll.Add(alDetail);
                        alAll.Add(alPhyDetail);
                        alAll.Add(alChemDetail);

                        PublicServer.SetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.AddCheckConsign",
                                new Object[] { strCHECK_NO, alAll }, this.ob);

                        //生产补样
                        if (ultraCRAFT_SOURCE.Value.ToString() == "7")
                        {
                            //ultraCRAFT_FILE_NO.Text
                            AddCheckConsignBY(alDetail);
                        }
                        else 
                        {
                            MessageUtil.ShowTips("新增成功！");
                        }
                    }
                }
                QueryCheckConsignBase();
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        //判断化学录入是否符合规则
        /// <summary>
        /// 判断化学录入是否符合规则
        /// </summary>
        /// <returns></returns>
        private string isChem()
        {
            publicUltraGridDetail1.Ug.UpdateData();
            if (publicUltraGridDetail1.Ug.DisplayLayout.Bands[0].Columns.Exists("SAMPLE_NO") && publicUltraGridDetail1.Ug.DisplayLayout.Bands[0].Columns.Exists("CHK"))
            {
                bool isHaveItems = false;
                string strTemp = "";
                foreach (UltraGridRow ur in publicUltraGridDetail1.Ug.Rows)
                {
                    if (ur.Cells["CHK"].Text.Trim() == "True")
                    {
                        isHaveItems = false;
                        if (ur.Cells["SAMPLE_NO"].Text.Trim() == "")
                        {
                            return "试样号不能为空！";
                        }
                        else
                        {
                            foreach (UltraGridColumn uc in publicUltraGridDetail1.Ug.DisplayLayout.Bands[0].Columns)
                            {
                                if (uc.Key != "CHK" && uc.Key != "SAMPLE_NO")
                                {
                                    if (ur.Cells[uc.Key].Text.Trim() != "")
                                    {
                                        isHaveItems = true;
                                    }
                                }
                            }
                            if (isHaveItems == false)
                            {
                                return "试样号" + ur.Cells["SAMPLE_NO"].Text.Trim() + "没有选择检验项目！";
                            }
                            if (strTemp == ur.Cells["SAMPLE_NO"].Text.Trim())
                            {
                                return "存在相同的试样号请重新输入！";
                            }
                            else
                            {
                                strTemp = ur.Cells["SAMPLE_NO"].Text.Trim();
                            }
                        }
                    }
                }
                if (isHaveItems == false)
                {
                    return "请勾选至少一条试样号信息！";
                }
            }

            string strFlag = "";//存放有化学元素的样管号
            string strType = "";//存放化学元素类型标示
            //publicUltraGridDetail1.Ug.UpdateData();
            foreach (DataRow dr in publicUltraGridDetail1.DataTable.Rows)
            {
                bool IsHaveChemCol = false;
                bool IsHaveONHCol = false;

                //bool IsNull = false;
                foreach (DataColumn dc in publicUltraGridDetail1.DataTable.Columns)
                {
                    if (dc.ColumnName == "HX" && dr["HX"].ToString() != "")
                    {
                        IsHaveChemCol = true;
                    }
                    if (dc.ColumnName == "ONH" && dr["ONH"].ToString() != "")
                    {
                        IsHaveONHCol = true;
                    }
                }
                if (IsHaveChemCol == true && IsHaveONHCol == true)
                {
                    strFlag += dr["SAMPLE_NO"].ToString() + " ";
                    strType += "ALL" + " ";
                }
                else if (IsHaveChemCol == true && IsHaveONHCol == false)
                {
                    strFlag += dr["SAMPLE_NO"].ToString() + " ";
                    strType += "HX" + " ";
                }
                else if (IsHaveChemCol == false && IsHaveONHCol == true)
                {
                    strFlag += dr["SAMPLE_NO"].ToString() + " ";
                    strType += "ONH" + " ";
                }
            }
            if (strFlag == "")
            {
                return "";
            }
            else
            {
                string[] arrFlag = strFlag.Trim().Split(' ');
                string[] arrType = strType.Trim().Split(' ');

                bool isHaveChem;
                bool isHaveONH;

                publicUltraGridChemDetail1.Ug.UpdateData();
                foreach (DataRow dr in publicUltraGridChemDetail1.DataTable.Rows)
                {
                    isHaveChem = false;
                    isHaveONH = false;
                    string strSAMPLE_NO = dr["SAMPLE_NO"].ToString();
                    if (strFlag.IndexOf(strSAMPLE_NO) < 0)
                    {
                        return "化学元素选择输入了不正确的样管号！";
                    }
                    for (int i = 0; i < arrFlag.Length; i++)
                    {
                        if (arrFlag[i] == strSAMPLE_NO)
                        {
                            if (dr["ANA_O"].ToString() == "√" || dr["ANA_N"].ToString() == "√" || dr["ANA_H"].ToString() == "√")
                            {
                                isHaveONH = true;
                            }

                            foreach (string strChem in PublicPipeAndOutdec.chemMin.Split(' '))
                            {
                                if ("ONH".IndexOf(strChem) < 0 && dr["ANA_" + strChem.ToUpper()].ToString() == "√")
                                {
                                    isHaveChem = true;
                                }
                            }

                            if (arrType[i] == "HX")
                            {
                                if (isHaveONH == true)
                                {
                                    return "样管号" + strSAMPLE_NO + "输入了ONH！";
                                }
                                if (isHaveChem == false)
                                {
                                    return "样管号" + strSAMPLE_NO + "请选择化学元素！";
                                }
                            }
                            else if (arrType[i] == "ONH")
                            {
                                if (isHaveChem == true)
                                {
                                    return "样管号" + strSAMPLE_NO + "选择了化学元素请填写试样数！";
                                }
                                if (isHaveONH == false)
                                {
                                    return "样管号" + strSAMPLE_NO + "请选择ONH！";
                                }
                            }
                            else if (arrType[i] == "ALL")
                            {
                                if (isHaveChem == false && isHaveONH == false)
                                {
                                    return "样管号" + strSAMPLE_NO + "请选择化学元素和ONH！";
                                }
                                else if (isHaveChem == false)
                                {
                                    return "样管号" + strSAMPLE_NO + "请选择化学元素！";
                                }
                                else if (isHaveONH == false)
                                {
                                    return "样管号" + strSAMPLE_NO + "请选择ONH！";
                                }
                            }

                        }
                    }
                }
            }
            return "";
        }

        //获取检验委托基本信息
        /// <summary>
        /// 获取检验委托基本信息
        /// </summary>
        /// <returns></returns>
        private ArrayList GetCheckConsignBase()
        {
            string SUPPLY_UNIT_CODE = "";
            string SUPPLY_UNIT = "";
            DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.queryPlineCode3", new Object[] { PPLINE_CODE.Value.ToString().Substring(0, 4) }, ob);
            if (dt.Rows.Count > 0)
            {
                SUPPLY_UNIT_CODE = dt.Rows[0]["SUPPLY_UNIT_CODE"].ToString();
                SUPPLY_UNIT = dt.Rows[0]["SUPPLY_UNIT"].ToString();
            }
            
            ArrayList al = new ArrayList();
            al.Add(txtCHECK_NO.Text);
            //al.Add(checkNo);
            al.Add(txtHEAT_NO.Text);
            al.Add(ultraSTEEL_GRADE.Text);
            al.Add(ultraSTEEL_NO.Text);//钢号
            //al.Add(txtLARGE_SAMPLE_COUNT.Text);//样管数
            al.Add(txtLOT_NO.Text);//生产批号
            if (ultraCRAFT_PATH.Value == null)
            {
                al.Add(""); //工艺文件路径
            }
            else 
            {
                al.Add(ultraCRAFT_PATH.Value.ToString()); //工艺文件路径
            }
            al.Add(ultraCRAFT_FILE_NO.Text);//工艺文件名称
            

            al.Add(ultraPRODUCT_STD.Text);
            al.Add(txtCONTRACT_NO.Text);
            al.Add(ultraDIMATER.Text);
            al.Add(ultraHEIGHT.Text);
            al.Add(ultraCONSIGN_DEPT.Text == "" ? this.UserInfo.GetDepartment() : ultraCONSIGN_DEPT.Text);//委托单位

            al.Add(ultraCONSIGN_NAME.Text == "" ? UserInfo.GetUserName() : ultraCONSIGN_NAME.Text);
            al.Add(ultraISPRODUCER.Text == "" ? "0" : ultraISPRODUCER.Value);
            al.Add(txtSPEC_REQ.Text);//特殊要求
            al.Add("1");//默认委托单位已送样
            al.Add(txtREMARK.Text);//备注

            al.Add("1");//数据类型 1 人工委托
            al.Add(PPLINE_CODE.Value.ToString().Substring(0, 4));//产线代码
            al.Add(PPLINE_CODE.Value.ToString().Substring(4,1));//工序代码
            al.Add(ultraCRAFT_SOURCE.Value.ToString2());//试样类型
            al.Add(txtBATCH_NO.Text);//性能批号
            al.Add(SUPPLY_UNIT_CODE);//制造商
            al.Add(SUPPLY_UNIT);//制造商
            return al;
        }

        //清空检验委托
        /// <summary>
        /// 清空检验委托
        /// </summary>
        private void ClearCheckConsign()
        {
            ClearCheckConsignBase();

            publicUltraGridDetail1.DataTable.Rows.Clear();
            PublicPipeAndOutdec.ReMoveColumns(publicUltraGridDetail1.DataTable, 4);//清除列

            publicUltraGridChemDetail1.DataTable.Rows.Clear();

            //if (m_dtSelectPhyMax != null)
            //{
            //    m_dtSelectPhyMax.Rows.Clear();
            //}
            if (m_dtSelectPhySampleCode != null)
            {
                m_dtSelectPhySampleCode.Rows.Clear();
            }
            if (m_dtSelectPhyMin != null)
            {
                m_dtSelectPhyMin.Rows.Clear();
            }
            if (m_dtSelectPhyR != null)
            {
                m_dtSelectPhyR.Rows.Clear();
            }//清理内存表
        }

        private void ClearCheckConsignBase()
        {
            //txtCHECK_NO.Text = "";
            txtCHECK_NO.Text = "";
            txtHEAT_NO.Text = "";
            ultraSTEEL_GRADE.Text = "";
            ultraSTEEL_NO.Text = "";//钢号

            ultraPRODUCT_STD.Text = "";
            txtCONTRACT_NO.Text = "";
            ultraDIMATER.Text = "";
            ultraHEIGHT.Text = "";
            ultraCONSIGN_DEPT.Text = "";//委托单位

            ultraCONSIGN_NAME.Text = "";
            txtCONSIGN_TIME.Text = "";
            ultraISPRODUCER.Text = "否";
            txtSPEC_REQ.Text = "";//特殊要求

            txtREMARK.Text = "";//备注

            txtLOT_NO.Text = "";
            ultraCRAFT_PATH.Text = "";
            ultraCRAFT_FILE_NO.Text = "";
        }

        //修改检验委托
        /// <summary>
        /// 修改检验委托
        /// </summary>
        private void UpdateCheckConsign()
        {
            try
            {
                if (publicUltraGridBase1.Ur == null)
                {
                    MessageUtil.ShowWarning("请选择需要修改的数据！");
                    return;
                }
                if (ultraCRAFT_SOURCE.Value.ToString() == "7")
                {
                    if (txtHEAT_NO.Text.ToString().Trim() == "")
                    {
                        MessageUtil.ShowTips("炉号不能为空！");
                        return;
                    }
                    if (txtBATCH_NO.Text.ToString().Trim() == "")
                    {
                        MessageUtil.ShowTips("性能批号不能为空！");
                        return;
                    }
                }
                if (ultraCRAFT_SOURCE.Value.ToString() == "6")
                {
                    AddCheckConsignHTT();
                }
                else
                {
                    if (PPLINE_CODE.Text.Trim() == "")
                    {
                        MessageUtil.ShowTips("产线不能为空!");
                        return;
                    }
                    string strAddChem = isChem();
                    if (strAddChem != "")
                    {
                        MessageUtil.ShowWarning(strAddChem);
                        return;
                    }

                    if (MessageUtil.ShowYesNoAndQuestion("是否确认修改？") == DialogResult.Yes)
                    {
                        //判断状态位
                        string strCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim();
                        string strBATCH_NO = txtBATCH_NO.Text.Trim();//性能批号
                        string SUPPLY_UNIT_CODE = "";
                        string SUPPLY_UNIT = "";
                        DataTable dts = PublicServer.GetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.queryPlineCode3", new Object[] { PPLINE_CODE.Value.ToString().Substring(0, 4) }, ob);
                        if (dts.Rows.Count > 0)
                        {
                            SUPPLY_UNIT_CODE = dts.Rows[0]["SUPPLY_UNIT_CODE"].ToString();
                            SUPPLY_UNIT = dts.Rows[0]["SUPPLY_UNIT"].ToString();
                        }

                        ArrayList alAll = new ArrayList();//整体list,插入几个表增加几个List

                        ArrayList alBase = new ArrayList();//基础表list
                        ArrayList alDetail = new ArrayList();//检验信息详细表list
                        ArrayList alPhyDetail = new ArrayList();//理化信息list
                        ArrayList alChemDetail = new ArrayList();//化学信息list

                        ArrayList alBaseParams = new ArrayList();//基础表参数list
                        ArrayList alDetailParams = new ArrayList();//检验信息详细表参数list
                        ArrayList alPhyDetailParams = new ArrayList();//理化信息参数list
                        ArrayList alChemDetailParams = new ArrayList();//化学信息参数list

                        alBase.Add(GetCheckConsignBase());//增加基础表参数

                        if (publicUltraGridDetail1.DataTable.Rows.Count > 0)
                        {
                            publicUltraGridDetail1.Ug.UpdateData();
                            ArrayList al = publicUltraGridChemDetail1.GetCheckChem();
                            bool isHaveChem = false;//判断是否有化学元素
                            int i = 0;
                            foreach (DataRow dr in publicUltraGridDetail1.DataTable.Rows)
                            {
                                isHaveChem = false;
                                string strSAMPLE_NO = dr["SAMPLE_NO"].ToString().Trim();

                                if (strSAMPLE_NO != "")
                                {
                                    foreach (DataColumn dc in publicUltraGridDetail1.DataTable.Columns)
                                    {
                                        if (dc.ColumnName != "CHK" && dc.ColumnName != "SAMPLE_NO" && dr[dc.ColumnName].ToString().Trim() != "")//列不为SAMPLE_NO才增加
                                        {
                                            string strPHY_CODE_MAX = dc.ColumnName;
                                            string strPHY_NAME_MAX = dc.Caption.Trim();
                                            string strSAMPLE_COUNT = dr[strPHY_CODE_MAX].ToString().Trim();

                                            alDetailParams = new ArrayList();//增加明细表参数
                                            alDetailParams.Add(strCHECK_NO);
                                            alDetailParams.Add(strSAMPLE_NO);
                                            alDetailParams.Add(strBATCH_NO);
                                            //alDetailParams.Add(strSAMPLE_SIZE);

                                            alDetailParams.Add(strPHY_CODE_MAX);
                                            if (strPHY_CODE_MAX == "HX")
                                            {
                                                alDetailParams.Add(((ArrayList)al[i])[0]);
                                                if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司"))
                                                {
                                                    alDetailParams.Add(getDeptID("002001007010"));
                                                }
                                                else
                                                {
                                                    alDetailParams.Add("002001007010");
                                                }
                                                isHaveChem = true;
                                            }
                                            else if (strPHY_CODE_MAX == "ONH")
                                            {
                                                alDetailParams.Add(((ArrayList)al[i])[1]);
                                                if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司"))
                                                {
                                                    alDetailParams.Add(getDeptID("002001007010"));
                                                }
                                                else
                                                {
                                                    alDetailParams.Add("002001007010");
                                                }
                                                isHaveChem = true;
                                            }
                                            else if (" C0011C0115,C0104C0012,C0013C0015C0050C0108C0109".IndexOf(strPHY_CODE_MAX) > 0)//非金属夹杂物、晶粒度、组织都归物理实验室
                                            {
                                                alDetailParams.Add(strPHY_NAME_MAX);
                                                if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司"))
                                                {
                                                    alDetailParams.Add(getDeptID("002001007015"));
                                                }
                                                else
                                                {
                                                    alDetailParams.Add("002001007015");
                                                }
                                            }
                                            else
                                            {
                                                alDetailParams.Add(strPHY_NAME_MAX);
                                                if (m_dtSelectPhySampleCode != null && m_dtSelectPhySampleCode.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'").Length > 0)
                                                {
                                                    if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司"))
                                                    {
                                                        alDetailParams.Add(getDeptID(m_dtSelectPhySampleCode.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'")[0]["DEPT_ID"].ToString())); 
                                                    }
                                                    else
                                                    {
                                                        alDetailParams.Add(m_dtSelectPhySampleCode.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'")[0]["DEPT_ID"].ToString());
                                                    }
                                                    
                                                }
                                                else
                                                {
                                                    alDetailParams.Add("");
                                                }
                                            }
                                            alDetailParams.Add(strSAMPLE_COUNT);
                                            DataRow[] arrAddRDetail = m_dtSelectPhyR.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'");//筛选符合条件的方向温度尺寸
                                            if (arrAddRDetail.Length > 0)
                                            {
                                                alDetailParams.Add(arrAddRDetail[0]["ITEM_NAME_F"].ToString());//方向描述
                                                alDetailParams.Add(arrAddRDetail[0]["ITEM_NAME_C"].ToString());//尺寸描述

                                            }
                                            else
                                            {
                                                alDetailParams.Add("");
                                                alDetailParams.Add("");
                                            }
                                            alDetail.Add(alDetailParams);//增加明细表参数List

                                            //201508.05HC 修改
                                            //增加理化明细信息参数list 没选择则不新增
                                            if (m_dtSelectPhySampleCode != null && m_dtSelectPhyMin != null && m_dtSelectPhyR != null)
                                            {
                                                DataRow[] arrAddMin = m_dtSelectPhyMin.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'");//筛选符合条件的小项

                                                foreach (DataRow drMin in arrAddMin)
                                                {
                                                    // AND PHY_CODE = '" + drMin["PHY_CODE"].ToString() + "'
                                                    DataRow[] arrAddR = m_dtSelectPhyR.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'");//筛选符合条件的方向温度尺寸
                                                    if (arrAddR.Length == 0)
                                                    {
                                                        alPhyDetailParams = new ArrayList();
                                                        alPhyDetailParams.Add(strCHECK_NO);
                                                        alPhyDetailParams.Add(strSAMPLE_NO);
                                                        alPhyDetailParams.Add(strBATCH_NO);
                                                        alPhyDetailParams.Add(strPHY_CODE_MAX);//大项代码
                                                        alPhyDetailParams.Add(strPHY_NAME_MAX);//大项描述
                                                        if (" C0011C0115,C0104C0012,C0013C0015C0050C0108C0109".IndexOf(strPHY_CODE_MAX) > 0)
                                                        {
                                                            if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司"))
                                                            {
                                                                alPhyDetailParams.Add(getDeptID("002001007015"));
                                                            }
                                                            else
                                                            {
                                                                alPhyDetailParams.Add("002001007015");
                                                            }//部门
                                                        }
                                                        else
                                                        {
                                                            if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司"))
                                                            {
                                                                alPhyDetailParams.Add(getDeptID(drMin["DEPT_ID"].ToString()));
                                                            }
                                                            else
                                                            {
                                                                alPhyDetailParams.Add(drMin["DEPT_ID"].ToString());//部门
                                                            }
                                                        }
                                                        alPhyDetailParams.Add(drMin["PHY_CODE_MIN"].ToString());//试样组
                                                        alPhyDetailParams.Add(drMin["PHY_NAME_MIN"].ToString());//试样组
                                                        alPhyDetailParams.Add(drMin["PHY_CODE"].ToString());//检验项代码
                                                        alPhyDetailParams.Add(drMin["PHY_NAME"].ToString());//检验项描述
                                                        alPhyDetailParams.Add(drMin["PHY_UNIT"].ToString());//值单位
                                                        alPhyDetailParams.Add("");//方向代码
                                                        alPhyDetailParams.Add("");//方向描述
                                                        alPhyDetailParams.Add("");//温度代码
                                                        alPhyDetailParams.Add("");//温度描述
                                                        alPhyDetailParams.Add("");//尺寸代码
                                                        alPhyDetailParams.Add("");//尺寸描述
                                                        alPhyDetail.Add(alPhyDetailParams);
                                                    }
                                                    else
                                                    {
                                                        foreach (DataRow drR in arrAddR)
                                                        {
                                                            alPhyDetailParams = new ArrayList();
                                                            alPhyDetailParams.Add(strCHECK_NO);
                                                            alPhyDetailParams.Add(strSAMPLE_NO);
                                                            alPhyDetailParams.Add(strBATCH_NO);
                                                            alPhyDetailParams.Add(strPHY_CODE_MAX);//大项代码
                                                            alPhyDetailParams.Add(strPHY_NAME_MAX);//大项描述
                                                            if (" C0011C0115,C0104C0012,C0013C0015C0050C0108C0109".IndexOf(strPHY_CODE_MAX) > 0)
                                                            {
                                                                if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司"))
                                                                {
                                                                    alPhyDetailParams.Add(getDeptID("002001007015"));
                                                                }
                                                                else
                                                                {
                                                                    alPhyDetailParams.Add("002001007015");
                                                                }
                                                                //alPhyDetailParams.Add("002001007015");//部门
                                                            }
                                                            else
                                                            {
                                                                if (SUPPLY_UNIT.Equals("江苏天淮钢管有限公司"))
                                                                {
                                                                    alPhyDetailParams.Add(getDeptID(drMin["DEPT_ID"].ToString()));
                                                                }
                                                                else
                                                                {
                                                                    alPhyDetailParams.Add(drMin["DEPT_ID"].ToString());//部门
                                                                }
                                                                //alPhyDetailParams.Add(drMin["DEPT_ID"].ToString());//部门
                                                            }
                                                            alPhyDetailParams.Add(drMin["PHY_CODE_MIN"].ToString());//试样组
                                                            alPhyDetailParams.Add(drMin["PHY_NAME_MIN"].ToString());//试样组
                                                            alPhyDetailParams.Add(drMin["PHY_CODE"].ToString());//检验项代码
                                                            alPhyDetailParams.Add(drMin["PHY_NAME"].ToString());//检验项描述
                                                            alPhyDetailParams.Add(drMin["PHY_UNIT"].ToString());//值单位
                                                            alPhyDetailParams.Add(drR["ITEM_CODE_F"].ToString());//方向代码
                                                            alPhyDetailParams.Add(drR["ITEM_NAME_F"].ToString());//方向描述
                                                            alPhyDetailParams.Add(drR["ITEM_CODE_W"].ToString());//温度代码
                                                            alPhyDetailParams.Add(drR["ITEM_NAME_W"].ToString());//温度描述
                                                            alPhyDetailParams.Add(drR["ITEM_CODE_C"].ToString());//尺寸代码
                                                            alPhyDetailParams.Add(drR["ITEM_NAME_C"].ToString());//尺寸描述
                                                            alPhyDetail.Add(alPhyDetailParams);
                                                        }
                                                    }
                                                }
                                            }
                                        }
                                    }
                                }
                                if (isHaveChem)
                                {
                                    i++;
                                }
                            }
                        }
                        if (publicUltraGridChemDetail1.Ug.Rows.Count > 0)
                        {
                            publicUltraGridChemDetail1.Ug.UpdateData();
                            foreach (DataRow dr in publicUltraGridChemDetail1.DataTable.Rows)
                            {
                                foreach (DataColumn dc in publicUltraGridChemDetail1.DataTable.Columns)
                                {
                                    string strCHEM_NAME = dc.Caption;

                                    if (strCHEM_NAME != "样管号" && dr["ANA_" + strCHEM_NAME.ToUpper()].ToString() == "√")
                                    {
                                        alChemDetailParams = new ArrayList();//增加化学明细表参数
                                        alChemDetailParams.Add(strCHECK_NO);
                                        alChemDetailParams.Add(dr["SAMPLE_NO"].ToString());
                                        alChemDetailParams.Add(strBATCH_NO);
                                        alChemDetailParams.Add(strCHEM_NAME);
                                        alChemDetailParams.Add(strCHEM_NAME);
                                        alChemDetail.Add(alChemDetailParams);
                                    }
                                }
                            }
                        }

                        alAll.Add(alBase);
                        //alAll.Add(alJg);
                        alAll.Add(alDetail);
                        alAll.Add(alPhyDetail);
                        alAll.Add(alChemDetail);

                            PublicServer.SetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.UpdateCheckConsign",
            new Object[] { strCHECK_NO, alAll }, this.ob);

                            if (ultraCRAFT_SOURCE.Value.ToString() == "7")
                            {
                                AddCheckConsignBY(alDetail);
                            }
                            //QueryCheckConsignBase();
                            //PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase1.Ug, "CHECK_NO", strCHECK_NO);
                        MessageUtil.ShowTips("修改成功！");
                    }
                }
                QueryCheckConsignBase();
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        /// <summary>
        /// 委外热处理样
        /// </summary>
        private void AddCheckConsignHTT()
        {
            if (txtCONTRACT_NO.Text.ToString().Trim() == "")
            {
                MessageUtil.ShowTips("合同号不能为空！");
                return;
            }
            if (txtHEAT_NO.Text.ToString().Trim() == "")
            {
                MessageUtil.ShowTips("炉号不能为空！");
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.lims.data.pipe.FrmCheckConsignAdd";
            ccp.MethodName = "AddCheckConsignHTT";
            ccp.ServerParams = new object[] { txtCHECK_NO.Text, txtHEAT_NO.Text, txtCONTRACT_NO.Text};
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnInfo == "委外热处理样！")
            {
                MessageUtil.ShowTips("新增成功!");
            }
            else
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
            }
        }

        /// <summary>
        /// 生产补样
        /// </summary>
        private void AddCheckConsignBY(ArrayList alDetailParams)
        {
            if (txtCONTRACT_NO.Text.ToString().Trim() == "")
            {
                MessageUtil.ShowTips("合同号不能为空！");
                return;
            }
            if (txtHEAT_NO.Text.ToString().Trim() == "")
            {
                MessageUtil.ShowTips("炉号不能为空！");
                return;
            }
            if (txtBATCH_NO.Text.ToString().Trim() == "")
            {
                MessageUtil.ShowTips("性能批号不能为空！");
                return;
            }
            ArrayList list = new ArrayList();
            list.Add(txtCHECK_NO.Text);
            list.Add(txtHEAT_NO.Text);
            list.Add(txtBATCH_NO.Text);
            list.Add(txtCONTRACT_NO.Text);
            list.Add(PPLINE_CODE.Value.ToString().Substring(0, 4));
            list.Add(ultraCRAFT_FILE_NO.Text);
            

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.lims.data.pipe.FrmCheckConsignAdd";
            ccp.MethodName = "AddCheckConsignBY";
            ccp.ServerParams = new object[] { list, alDetailParams };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnInfo == "生产补样！")
            {
                MessageUtil.ShowTips("新增成功！");
            }
            else
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                string strCHECK_NO = txtCHECK_NO.Text.Trim();
                ArrayList al = new ArrayList();
                al.Add(strCHECK_NO);
                int i = PublicServer.SetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.DeleteCheckConsign",
                        new Object[] { strCHECK_NO, al }, this.ob);
                QueryCheckConsignBase();
            }
        }
        //删除检验委托new 方法
        /// <summary>
        /// 删除检验委托new 方法
        /// </summary>
        private void DeleteCheckConsign()
        {
            try
            {
                if (publicUltraGridBase1.Ur == null)
                {
                    MessageUtil.ShowWarning("请选择需要删除的数据！");
                    return;
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否确认删除？") == DialogResult.Yes)
                {
                    string strCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim();

                    ArrayList al = new ArrayList();

                    al.Add(strCHECK_NO);

                    int i = PublicServer.SetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.DeleteCheckConsign",
                            new Object[] { strCHECK_NO, al }, this.ob);
                    
                    if (ultraCRAFT_SOURCE.Value.ToString() == "6" || ultraCRAFT_SOURCE.Value.ToString() == "7")
                    {
                        CoreClientParam ccp = new CoreClientParam();
                        ccp.ServerName = "com.steering.lims.data.pipe.FrmCheckConsignAdd";
                        ccp.MethodName = "DeleteCheckConsignHTT";
                        ccp.ServerParams = new object[] { txtCHECK_NO.Text, txtHEAT_NO.Text };
                        ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                        if (ccp.ReturnInfo == "委外热处理样！")
                        {
                        }
                        else
                        {
                            MessageUtil.ShowTips(ccp.ReturnInfo);
                        }
                    }
                    QueryCheckConsignBase();
                    MessageUtil.ShowTips("删除成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }



        //private void ultraComType_ValueChanged(object sender, EventArgs e)
        //{
        //    if (ultraCRAFT_SOURCE.Value.ToString2().Equals("2"))
        //    {
        //        letter = "K";
        //    }
        //    else if (ultraCRAFT_SOURCE.Value.ToString2().Equals("3"))
        //    {
        //        letter = "Y";
        //    }
        //    else if (ultraCRAFT_SOURCE.Value.ToString2().Equals("4"))
        //    {
        //        letter = "W";
        //    }
        //    else if (ultraCRAFT_SOURCE.Value.ToString2().Equals("5"))
        //    {
        //        letter = "N";
        //    }
        //    DataTable ds = PublicServer.GetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.getCheckNo", new object[] { letter, ultraCRAFT_SOURCE.Value.ToString2() }, ob);
        //    txtCHECK_NO.Text = ds.Rows[0][0].ToString();
        //    //checkNo = ds.Rows[0][0].ToString();
        //}

        private void ultraButton1_Click(object sender, EventArgs e)
        {
            if (ultraCRAFT_SOURCE.Value.ToString2().Equals("2"))
            {
                letter = "K";
            }
            else if (ultraCRAFT_SOURCE.Value.ToString2().Equals("3"))
            {
                letter = "Y";
            }
            else if (ultraCRAFT_SOURCE.Value.ToString2().Equals("4"))
            {
                letter = "W";
            }
            else if (ultraCRAFT_SOURCE.Value.ToString2().Equals("5"))
            {
                letter = "N";
            }
            else if (ultraCRAFT_SOURCE.Value.ToString2().Equals("6"))
            {
                letter = "M";
            }
            else if (ultraCRAFT_SOURCE.Value.ToString2().Equals("7"))
            {
                letter = "O";
            }
            DataTable ds = PublicServer.GetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.getCheckNo", new object[] { letter, ultraCRAFT_SOURCE.Value.ToString2() }, ob);
            txtCHECK_NO.Text = ds.Rows[0][0].ToString();
            //checkNo = ds.Rows[0][0].ToString();
        }

        /// <summary>
        /// 打印
        /// </summary>
        private void printTrust()
        {
            this.publicUltraGridBase1.Ug.UpdateData();
            UltraGridRow uRow = this.publicUltraGridBase1.Ug.ActiveRow;
            if (uRow == null) return;
            string checkNo = uRow.Cells["CHECK_NO"].Text.Trim();
            string strurl = "";

            strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsPortCheckConsignOrder.cpt" + "&CHECK_NO=" + checkNo;
            FrmRepExcel fBug = new FrmRepExcel(ob, strurl);
            fBug.AutoSize = true;
            fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
            fBug.WindowState = FormWindowState.Maximized;
            fBug.Text = "检验委托单";
            fBug.Show();
        }


        /// <summary>
        /// 打印标签
        /// </summary>
        private void printLable()
        {
            this.publicUltraGridBase1.Ug.UpdateData();
            UltraGridRow uRow = this.publicUltraGridBase1.Ug.ActiveRow;
            if (uRow == null) return;
            string checkNo = uRow.Cells["CHECK_NO"].Text.Trim();
            string strurl = "";

            strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepEntrustLabelSD.cpt" + "&CHECK_NO=" + checkNo;
            FrmRepExcel fBug = new FrmRepExcel(ob, strurl);
            fBug.AutoSize = true;
            fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
            fBug.WindowState = FormWindowState.Maximized;
            fBug.Text = "样管号标签";
            fBug.Show();
        }

        private void PPLINE_CODE_ValueChanged(object sender, EventArgs e)
        {
            if (!"".Equals(PPLINE_CODE.Value.ToString()))
            {
                DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.queryPlineCode", new object[] { PPLINE_CODE.Value.ToString() }, ob);
                if (dt != null && dt.Rows.Count > 0)
                {
                    PPLINE_CODE.Value = dt.Rows[0]["PLINE_CODE"].ToString();
                    PPLINE_CODE.Text = dt.Rows[0]["PLINE_NAME"].ToString();
                }
            }
            
        }

        private void txtCONTRACT_NO_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyValue == 13)
            {
                //工艺文件
                DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.initCraftPath", new object[] { txtCONTRACT_NO.Text }, ob);
                if (dt != null && dt.Rows.Count > 0)
                {
                    ultraCRAFT_PATH.DataSource = dt;
                    ultraCRAFT_PATH.ValueMember = "CRAFT_PATH";
                    ultraCRAFT_PATH.DisplayMember = "CRAFT_PATH";
                }
            }
        }

        /// <summary>
        /// 更新天淮实验室
        /// </summary>
        /// <param name="DeptID"></param>
        /// <returns></returns>
        public  string  getDeptID(string DeptID)
        {
            string newDeptID = "";
            DataTable dts = PublicServer.GetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.getDeptIdTH", new Object[] { DeptID }, ob);
            if (dts.Rows.Count > 0)
            {
                newDeptID = dts.Rows[0]["newDeptID"].ToString();
            }
            return newDeptID;
        }
       
    }
}