MES_Client/TGMES/Core.StlMes.Client.Lims.Data.PipeAndOutdec/数据管理/外委实验管理/FrmOutdecCheckConsign.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.CA03;
using CoreFS.CA04;
using CoreFS.CA06;
using System.Collections;
using Infragistics.Win.UltraWinGrid;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Tool;
using Infragistics.Win.UltraWinEditors;

//ultraGrid1点击刷新根据编辑区条件查询，默认查询出最近几天的数据方便增加委托的时候重复的东西不需要勾选;
//检验编号按照J年-月-流水号自动生成如J14-12-001,填写完成可打印试验委托单模板
//商检化学无ONH
namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec
{
    //暂时无ONH
    public partial class FrmOutdecCheckConsign : FrmBase
    {
        //private string chemItems = "";
        //private string chemONH = "";
        private string Departm = "";//部门

        //private DataTable m_dtSelectPhyMax;//已选择的大项

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

        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 FrmOutdecCheckConsign()
        {
            InitializeComponent();
        }

        private void FrmOutdecCheckConsign_Load(object sender, EventArgs e)
        {
            InitColumns();
            this.txtCONTROL_NO.Text = "ZXGJ-02-04";
            Departm = UserInfo.GetDepartment();
            if(!Departm.Equals("检测中心办公室"))
            {
                //ultraTabControl1.Visible = false;
                txtCHECK_PRICE.Visible = false;
                txtCHECK_PRICE_REAL.Visible = false;
                txtCONSIGN_DEPT.Visible = false;
                txtCHECK_DEPT.Visible =  false;
                txtCONSIGN_ADDRESS.Visible = false;
                txtPOSTCODE.Visible = false;
                txtPHONE.Visible = false;
                txtFAX.Visible = false;
                txtCHECK_ADDRESS.Visible = false;
                txtCONSIGN_NAME.Visible = false;
                txtJC_RECEIVE_NAME.Visible = false;
                ultraLabel121.Visible = false;
                ultraLabel120.Visible = false;
                ultraLabel117.Visible = false;
                ultraLabel132.Visible = false;
                ultraLabel131.Visible = false;
                ultraLabel119.Visible = false;
                ultraLabel118.Visible = false;
                ultraLabel116.Visible = false;
                ultraLabel130.Visible = false;
                ultraLabel142.Text = "检验(试验)任务单";
                
            }
            //RefreshAutoSize();    
        }

        void UltraGrid1_CellChange(object sender, CellEventArgs e)
        {
            //|| e.Cell.Column.Key.Equals("ONH")
            if (e.Cell.Column.Key.Equals("HX") && 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.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;
                    }
                }
            }
        }

        private void InitColumns()
        {
            publicUltraGridBase1.PublicUltraGridBaseActive += new EventHandler(outdecUltraGridBase1_PublicUltraGridBaseActive);//调用委托事件
            
            publicUltraGridDetail1.PublicUltraGridDetailActive += new EventHandler(publicUltraGridDetail1_PublicUltraGridDetailActive);
            publicUltraGridDetail1.UltraGrid1.CellChange += new CellEventHandler(UltraGrid1_CellChange);

            string[] arrColumnsBase = new string[] { "CHECK_NO", "CONTROL_NO", "SAMPLE_NAME", "STEEL_GRADE_NO", "TOTAL_LARGE_SAMPLE_SIZE", "LARGE_SAMPLE_COUNT", "HEAT_NO", "TOTAL_SAMPLE_NO", "OTHER_DESC", "LARGE_SAMPLE_STATE", "CHECK_TYPE", "CHECK_BASE", "SURPLUS", "SURPLUS_STATE", "PROMISE_FINISH_TIME", "CHECK_PRICE", "REPORT_TYPE", "GET_REPORT_WAY", "CONSIGN_DEPT", "CONSIGN_ADDRESS", "POSTCODE", "PHONE", "FAX", "CHECK_DEPT", "CHECK_ADDRESS", "CONSIGN_NAME", "CONSIGN_TIME", "JC_RECEIVE_NAME", "JC_RECEIVE_TIME", "REMARK", "IS_JG", "IS_JG_DESC", "IS_JZ", "IS_JZ_DESC", "CHECK_PRICE_REAL", "IS_CLEARING", "IS_CLEARING_DESC" };
            string[] arrCaptionBase = new string[] { "检验编号", "受控编号", "样品名称", "钢号/钢级", "规格", "数量(个数)", "炉号", "样品编号", "其他说明", "样品状态", "检验类别", "检验依据", "余样处理方式", "余样情况", "检验完成时间约定", "检验费用", "报告类型", "取报告方式", "委托方全称", "通信地址", "邮编", "电话", "传真", "主检单位", "地址", "委托方授权人签字", "委托时间", "检验单位接受人", "接受日期", "备注", "是否加工", "是否加工", "是否监制", "是否监制", "实收", "是否结算", "是否结算" };
            publicUltraGridBase1.InitColumns(arrColumnsBase, arrCaptionBase);
            publicUltraGridBase1.setColumnShowOrHidden(new string[] { "CHECK_NO" }, true);
            publicUltraGridBase1.setOtherColumnReadOnly(null);//可编辑列

            string[] arrColumns = new string[] { "SAMPLE_NO", "SAMPLE_SIZE", "HX" };//"FLAG",ONH
            string[] arrCaption = new string[] { "试样号", "规格", "化学" };//"试样状态",ONH

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

            PublicPipeAndOutdec.setColumnShowOrHidden(publicUltraGridChemDetail1.Ug, new string[] { "ANA_O", "ANA_N", "ANA_H" }, false);

            string[] arrColumnsBaseDetail = new string[] { "PHY_CODE_MAX", "PHY_NAME_MAX", "PHY_CODE", "PHY_NAME", "ITEM_CODE_F", "ITEM_NAME_F", "ITEM_CODE_W", "ITEM_NAME_W", "ITEM_CODE_S", "ITEM_NAME_S" };
            string[] arrCaptionBaseDetail = new string[] { "检验项代码", "检验项名称", "检验基础项代码", "检验基础项名称", "方向代码", "方向", "温度代码", "温度", "尺寸代码", "尺寸" };

            PublicPipeAndOutdec.InitColumns(arrColumnsBaseDetail, arrCaptionBaseDetail, dataTable1);
            PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid1, new string[] { "PHY_CODE_MAX", "PHY_CODE", "PHY_NAME", "ITEM_CODE_F", "ITEM_CODE_W", "ITEM_CODE_S" }, false);
            PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid1, null);
        }

        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;

            ultraGrid1.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
            ultraGrid1.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            string userName = this.UserInfo.GetUserName();
            if (userName != "霍超" && userName != "文海明" && userName != "龚宜勇")
            {
                txtCHECK_PRICE.Visible = false;
                txtCHECK_PRICE_REAL.Visible = false;
            }
        }

        void outdecUltraGridBase1_PublicUltraGridBaseActive(object sender, EventArgs e)
        {
            ShowBaseInfo(publicUltraGridBase1.Ur);//显示区赋值
            QueryCheckConsignDetail();

            QueryCheckConsignChemDetail();
            //赋值给全局变量

            QueryCheckConsignPhyDetail("outdec.FrmOutdecCheckConsign");//对于已经生成的委托单查询大项小项信息
        }

        //查询检验委托基本信息
        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;
            }
        }

        void publicUltraGridDetail1_PublicUltraGridDetailActive(object sender, EventArgs e)
        {
            if (publicUltraGridBase1.Ur != null && publicUltraGridDetail1.Ur != null)
            {
                QueryCheckConsignPhyDetail_Items();
            }
        }

        //查询检验委托项目明细信息
        /// <summary>
        /// 查询检验委托项目明细信息
        /// </summary>
        private void QueryCheckConsignPhyDetail_Items()
        {
            try
            {
                ArrayList al = new ArrayList();
                al.Add(publicUltraGridDetail1.Ur.Cells["SAMPLE_NO"].Text.Trim());
                al.Add(publicUltraGridDetail1.Ur.Cells["SAMPLE_NO"].Text.Trim());
                al.Add(publicUltraGridDetail1.Ur.Cells["SAMPLE_NO"].Text.Trim());
                al.Add(publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim());

                DataTable dt = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecCheckConsign.QueryCheckConsignPhyDetail_Items",
                            new Object[] { al }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable1.Rows.Clear();
                    ultraExpandableGroupBox2.Hide();
                    return;
                }
                ultraExpandableGroupBox2.Show();
                GridHelper.CopyDataToDatatable(dt, dataTable1, true);//把dt复制给dataTable4

                GridHelper.RefreshAndAutoSize(ultraGrid1);//刷新Grid
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
                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();
                    //AddCheckConsigns();
                    break;
                case "Update":

                    UpdateCheckConsign();

                    break;
                case "Delete":
                    if (publicUltraGridBase1.Ur == null)
                    {
                        MessageUtil.ShowWarning("请选择需要删除的数据！");
                        return;
                    }

                    DeleteCheckConsign();

                    break;
                case "Clear":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认清空？") == DialogResult.Yes)
                    {
                        ClearCheckConsign();
                        MessageUtil.ShowTips("清空成功！");
                    }
                    break;
                case "Send":
                    UpdateCheckConsignDetail();
                    break;
                case "PrintConsign":

                    RepLimsOutdecConsignCheckOrder();

                    break;
                case "PrintCheck":

                    RepLimsOutdecJGCheckTaskOrder();

                    break;
                case "Close":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
                    {
                        this.Close();
                    }
                    break;
            }
        }

        /// <summary>
        /// 查询检验委托基本信息
        /// </summary>
        private void QueryCheckConsignBase()
        {
            try
            {
                publicUltraGridBase1.QueryCheckConsignBase("outdec.PublicOutdecBase", outdecQueryBase1.GetQueryInfo("012"), this.ob);
                if (publicUltraGridBase1.Ug.Rows.Count == 0)
                {
                    ClearCheckConsign();
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        /// <summary>
        /// 增加检验委托
        /// </summary>
        private void AddCheckConsign()
        {
            try
            {
                if (txtCHECK_NO.Text.Trim() == "")
                {
                    MessageUtil.ShowWarning("检验编号不能为空！");
                    return;
                }
                if (txtCHECK_PRICE.Text.Trim() == "")
                {
                    MessageUtil.ShowWarning("试验费用不能为空！");
                    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 = txtCHECK_NO.Text.Trim();//检验委托编号

                    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.GetOutdecCheckChem();
                        bool isHaveChem = false;//判断是否有化学元素
                        int i = 0;
                        foreach (DataRow dr in publicUltraGridDetail1.DataTable.Rows)
                        {
                            isHaveChem = false;
                            string strSAMPLE_NO = dr["SAMPLE_NO"].ToString().Trim();
                            string strSAMPLE_SIZE = dr["SAMPLE_SIZE"].ToString().Trim();
                            if (strSAMPLE_NO != "")
                            {
                                foreach (DataColumn dc in publicUltraGridDetail1.DataTable.Columns)
                                {
                                    if (dc.ColumnName != "SAMPLE_NO" && dc.ColumnName != "SAMPLE_SIZE" && 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(strSAMPLE_SIZE);

                                        alDetailParams.Add(strPHY_CODE_MAX);
                                        if (strPHY_CODE_MAX == "HX")
                                        {
                                            alDetailParams.Add(al[i]);
                                            alDetailParams.Add("002001007010");
                                            isHaveChem = true;
                                        }
                                        //else if (strPHY_CODE_MAX == "ONH")
                                        //{
                                        //    alDetailParams.Add(((ArrayList)al[i])[1]);
                                        //     alDetailParams.Add("002001007010");
                                        //    isHaveChem = true;
                                        //}
                                        else
                                        {
                                            alDetailParams.Add(strPHY_NAME_MAX);
                                            if (m_dtSelectPhySampleCode != null && m_dtSelectPhySampleCode.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'").Length > 0)
                                            {
                                                alDetailParams.Add(m_dtSelectPhySampleCode.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'")[0]["DEPT_ID"].ToString());
                                            }
                                            else
                                            {
                                                alDetailParams.Add("");
                                            }
                                        }
                                        alDetailParams.Add(strSAMPLE_COUNT);
                                        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)
                                            {
                                                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(strPHY_CODE_MAX);//大项代码
                                                    alPhyDetailParams.Add(strPHY_NAME_MAX);//大项描述
                                                    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(strPHY_CODE_MAX);//大项代码
                                                        alPhyDetailParams.Add(strPHY_NAME_MAX);//大项描述
                                                        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].ToString() == "√")
                                {
                                    alChemDetailParams = new ArrayList();//增加化学明细表参数
                                    alChemDetailParams.Add(strCHECK_NO);
                                    alChemDetailParams.Add(dr["SAMPLE_NO"].ToString());
                                    alChemDetailParams.Add(strCHEM_NAME);
                                    alChemDetail.Add(alChemDetailParams);
                                }
                            }
                        }
                    }

                    alAll.Add(alBase);
                    //alAll.Add(alJg);
                    alAll.Add(alDetail);
                    alAll.Add(alPhyDetail);
                    alAll.Add(alChemDetail);
                    if (chkIS_JG.Checked)
                    {
                        ArrayList alDetailFlag = new ArrayList();//状态位
                        ArrayList alDetailFlagParams = new ArrayList();//状态位
                        alDetailFlagParams.Add("1");
                        alDetailFlagParams.Add(strCHECK_NO);
                        alDetailFlag.Add(alDetailFlagParams);
                        alAll.Add(alDetailFlag);
                    }
                    PublicServer.SetData("com.steering.lims.data.outdec.FrmOutdecCheckConsign.AddCheckConsign",
                            new Object[] { strCHECK_NO, alAll }, this.ob);

                    QueryCheckConsignBase();
                    PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase1.Ug, "CHECK_NO", strCHECK_NO);
                    MessageUtil.ShowTips("新增成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        /// <summary>
        /// 获取检验委托基本信息
        /// </summary>
        /// <param name="strSAMPLE_REMARK"></param>
        /// <returns></returns>
        private ArrayList GetCheckConsignBase(string strSAMPLE_REMARK)
        {
            ArrayList al = new ArrayList();
            string strSample_Size = "";
            string strSample_No = "";
            if (publicUltraGridDetail1.DataTable.Rows.Count > 0)
            {
                foreach (DataRow dr in publicUltraGridDetail1.DataTable.Rows)
                {
                    strSample_No += dr["SAMPLE_NO"].ToString().Trim() + " ";
                    strSample_Size += dr["SAMPLE_SIZE"].ToString().Trim() + " ";
                }
            }

            al.Add(txtCHECK_NO.Text);
            al.Add(txtCONTROL_NO.Text);
            al.Add(txtSAMPLE_NAME.Text);
            al.Add(txtSTEEL_GRADE_NO.Text);//钢号
            //al.Add(txtTOTAL_LARGE_SAMPLE_SIZE.Text);
            al.Add(strSample_Size);
            //al.Add(txtLARGE_SAMPLE_COUNT.Text);//样品数量
            al.Add(publicUltraGridDetail1.DataTable.Rows.Count);//样品数量
            al.Add(txtHEAT_NO.Text);

            //al.Add(txtTOTAL_SAMPLE_NO.Text);//样品编号
            al.Add(strSample_No);
            al.Add(txtOTHER_DESC.Text);
            al.Add(ultraLARGE_SAMPLE_STATE.Text);
            al.Add(ultraCHECK_TYPE.Text);
            al.Add(ultraCHECK_BASE.Text);

            al.Add(ultraSURPLUS.Text);//余样处理方式
            al.Add(txtSURPLUS_STATE.Text);//余样情况
            al.Add(txtPROMISE_FINISH_TIME.Text);
            al.Add(txtCHECK_PRICE.Text);//试验费用
            al.Add(ultraREPORT_TYPE.Text);//报告类型
            al.Add(ultraGET_REPORT_WAY.Text);//取报告方式

            al.Add(txtCONSIGN_DEPT.Text);
            al.Add(txtCONSIGN_ADDRESS.Text);//
            al.Add(txtPOSTCODE.Text);//
            al.Add(txtPHONE.Text);//电话
            al.Add(txtFAX.Text);
            al.Add(txtCHECK_DEPT.Text);//
            al.Add(txtCHECK_ADDRESS.Text);//
            al.Add(txtCONSIGN_NAME.Text);//委托人
            al.Add(txtJC_RECEIVE_NAME.Text.Trim() == "" ? UserInfo.GetUserName() : txtJC_RECEIVE_NAME.Text.Trim());//接收人
            al.Add(strSAMPLE_REMARK);
            al.Add(txtREMARK.Text.Trim());//备注
            al.Add(chkIS_JG.Checked ? "2" : "0");//是否不加工 0为不加工
            al.Add(chkIS_JG.Checked ? "0" : "1");//是否不加工 0为不加工
            al.Add(chkIS_JZ.Checked ? "0" : "1");//是否监制 0为不监制
            al.Add(txtCHECK_PRICE_REAL.Text);//实收（试验费用）
            al.Add(chkIS_CLEARING.Checked ? "0" : "1");//是否结算 0为已结算
            
            return al;
        }

        /// <summary>
        /// 点击Grid编辑区显示基本信息
        /// </summary>
        /// <param name="ur"></param>
        public void ShowBaseInfo(UltraGridRow ur)
        {
            if (ur != null)
            {
                foreach (UltraGridCell uc in ur.Cells)
                {
                    if (ultraExpandableGroupBoxPanel1.Controls.ContainsKey("txt" + uc.Column.Key) == true)//判定是否存在text
                    {
                        ((UltraTextEditor)ultraExpandableGroupBoxPanel1.Controls["txt" + uc.Column.Key]).Text = uc.Text.Trim();
                    }
                    else if (ultraExpandableGroupBoxPanel1.Controls.ContainsKey("ultra" + uc.Column.Key) == true)//判定是否存在text
                    {
                        ((UltraComboEditor)ultraExpandableGroupBoxPanel1.Controls["ultra" + uc.Column.Key]).Text = uc.Text.Trim();
                    }
                    else if (ultraExpandableGroupBoxPanel1.Controls.ContainsKey("chk" + uc.Column.Key) == true)//判定是否存在text
                    {
                        if (uc.Text.Trim() == "1")
                        {
                            ((UltraCheckEditor)ultraExpandableGroupBoxPanel1.Controls["chk" + uc.Column.Key]).Checked = false;
                        }
                        else
                        {
                            ((UltraCheckEditor)ultraExpandableGroupBoxPanel1.Controls["chk" + uc.Column.Key]).Checked = true;
                        }
                    }
                }
            }
        }

        /// <summary>
        /// 判断化学录入是否符合规则
        /// </summary>
        /// <returns></returns>
        private string isChem()
        {
            publicUltraGridDetail1.Ug.UpdateData();
            if (publicUltraGridDetail1.Ug.DisplayLayout.Bands[0].Columns.Exists("SAMPLE_NO"))
            {
                string strTemp = "";
                foreach (UltraGridRow ur in publicUltraGridDetail1.Ug.Rows)
                {
                    if (ur.Cells["SAMPLE_NO"].Text.Trim() == "")
                    {
                        return "试样号不能为空！";
                    }
                    else
                    {
                        if (strTemp == ur.Cells["SAMPLE_NO"].Text.Trim())
                        {
                            return "存在相同的试样号请重新输入！";
                        }
                        else
                        {
                            strTemp = ur.Cells["SAMPLE_NO"].Text.Trim();
                        }
                    }
                }
            }

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

        private void UpdateCheckConsign()
        {
            try
            {
                if (publicUltraGridBase1.Ur == null)
                {
                    MessageUtil.ShowWarning("请选择需要修改的数据！");
                    return;
                }

                if (publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim() != txtCHECK_NO.Text.Trim())
                {
                    MessageUtil.ShowWarning("检验编号不能修改！");
                    return;
                }

                if (txtCHECK_NO.Text.Trim() == "")
                {
                    MessageUtil.ShowWarning("检验编号不能为空！");
                    return;
                }

                string strAddChem = isChem();
                if (strAddChem != "")
                {
                    MessageUtil.ShowWarning(strAddChem);
                    return;
                }

                //PublicServer.GetDataTips("com.steering.lims.data.outdec.FrmOutdecCheckConsign.QueryCheckConsignBaseTips",
                //new Object[] { strCHECK_NO, new string[] { "1", "2" }, new String[] { "此检验任务已下发，不允许修改！", "此检验任务加工已确认，不允许修改！" } }, ob);

                //if (MessageUtil.ShowYesNoAndQuestion("是否确认修改？") == DialogResult.Yes)
                //{
                WinCancelSampleComfirm pc = new WinCancelSampleComfirm();
                pc.ShowDialog();
                if (pc.DialogResult != DialogResult.OK)
                {
                    return;
                }
                string strSample_Remark = pc.StrRemark;
                strSample_Remark = this.Text + "修改由于" + strSample_Remark + "(" + UserInfo.GetUserName() + " " + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + ")";

                //判断状态位
                string strCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim();

                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(strSample_Remark));//增加基础表参数

                if (publicUltraGridDetail1.DataTable.Rows.Count > 0)
                {
                    publicUltraGridDetail1.Ug.UpdateData();
                    ArrayList al = publicUltraGridChemDetail1.GetOutdecCheckChem();
                    bool isHaveChem = false;//判断是否有化学元素
                    int i = 0;
                    foreach (DataRow dr in publicUltraGridDetail1.DataTable.Rows)
                    {
                        isHaveChem = false;
                        string strSAMPLE_NO = dr["SAMPLE_NO"].ToString().Trim();
                        string strSAMPLE_SIZE = dr["SAMPLE_SIZE"].ToString().Trim();
                        if (strSAMPLE_NO != "")
                        {
                            foreach (DataColumn dc in publicUltraGridDetail1.DataTable.Columns)
                            {
                                if (dc.ColumnName != "SAMPLE_NO" && dc.ColumnName != "SAMPLE_SIZE" && 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(strSAMPLE_SIZE);

                                    alDetailParams.Add(strPHY_CODE_MAX);
                                    if (strPHY_CODE_MAX == "HX")
                                    {
                                        alDetailParams.Add(al[i]);
                                        alDetailParams.Add("002001007010");
                                        isHaveChem = true;
                                    }
                                    else
                                    {
                                        alDetailParams.Add(strPHY_NAME_MAX);
                                        if (m_dtSelectPhySampleCode != null && m_dtSelectPhySampleCode.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'").Length > 0)
                                        {
                                            alDetailParams.Add(m_dtSelectPhySampleCode.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'")[0]["DEPT_ID"].ToString());
                                        }
                                        else
                                        {
                                            alDetailParams.Add("");
                                        }
                                    }
                                    alDetailParams.Add(strSAMPLE_COUNT);
                                    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)
                                        {
                                            DataRow[] arrAddR = m_dtSelectPhyR.Select("PHY_CODE_MAX = '" + strPHY_CODE_MAX + "'");//筛选符合条件的方向温度尺寸' AND PHY_CODE = '" + drMin["PHY_CODE"].ToString() + "
                                            if (arrAddR.Length == 0)
                                            {
                                                alPhyDetailParams = new ArrayList();
                                                alPhyDetailParams.Add(strCHECK_NO);
                                                alPhyDetailParams.Add(strSAMPLE_NO);
                                                alPhyDetailParams.Add(strPHY_CODE_MAX);//大项代码
                                                alPhyDetailParams.Add(strPHY_NAME_MAX);//大项描述
                                                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(strPHY_CODE_MAX);//大项代码
                                                    alPhyDetailParams.Add(strPHY_NAME_MAX);//大项描述
                                                    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].ToString() == "√")
                            {
                                alChemDetailParams = new ArrayList();//增加化学明细表参数
                                alChemDetailParams.Add(strCHECK_NO);
                                alChemDetailParams.Add(dr["SAMPLE_NO"].ToString());
                                alChemDetailParams.Add(strCHEM_NAME);
                                alChemDetail.Add(alChemDetailParams);
                            }
                        }
                    }
                }

                alAll.Add(alBase);
                //alAll.Add(alJg);
                alAll.Add(alDetail);
                alAll.Add(alPhyDetail);
                alAll.Add(alChemDetail);
                ArrayList alDetailFlag = new ArrayList();//状态位
                ArrayList alDetailFlagParams = new ArrayList();//状态位
                if (chkIS_JG.Checked)
                {
                    alDetailFlagParams.Add("1");
                    alDetailFlagParams.Add(strCHECK_NO);
                    alDetailFlag.Add(alDetailFlagParams);
                    alAll.Add(alDetailFlag);
                }
                else
                {
                    alDetailFlagParams.Add("0");
                    alDetailFlagParams.Add(strCHECK_NO);
                    alDetailFlag.Add(alDetailFlagParams);
                    alAll.Add(alDetailFlag);
                }

                string oldCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim();
                PublicServer.SetData("com.steering.lims.data.outdec.FrmOutdecCheckConsign.UpdateCheckConsign",
                    new Object[] { publicUltraGridBase1.Ur.Cells["IS_JG"].Text.Trim(), strCHECK_NO, alAll, oldCHECK_NO }, this.ob);//chkIS_JG.Checked ? "0" : "1",

                QueryCheckConsignBase();

                PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase1.Ug, "CHECK_NO", strCHECK_NO);

                MessageUtil.ShowTips("修改成功！");

                //}
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

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

            publicUltraGridDetail1.DataTable.Clear();
            int dcNum = publicUltraGridDetail1.DataTable.Columns.Count;//清除列 从第几列开始清除
            if (dcNum > 3)
            {
                for (int i = 0; i < dcNum - 3; i++)
                {
                    publicUltraGridDetail1.DataTable.Columns.RemoveAt(3);
                }
            }

            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();
            }//清理内存表
        }

        /// <summary>
        /// 清空基础信息
        /// </summary>
        private void ClearCheckConsignBase()
        {
            txtCHECK_NO.Text = "";
            txtSAMPLE_NAME.Text = "";
            txtSTEEL_GRADE_NO.Text = "";

            txtTOTAL_LARGE_SAMPLE_SIZE.Text = "";
            txtLARGE_SAMPLE_COUNT.Text = "";//数量
            txtHEAT_NO.Text = "";//炉号

            txtTOTAL_SAMPLE_NO.Text = "";//样品编号

            txtOTHER_DESC.Text = "";

            ultraLARGE_SAMPLE_STATE.Text = "";//样品状态
            ultraCHECK_TYPE.Text = "";

            ultraCHECK_BASE.Text = "";//试验依据和其他技术要求及随机技术文件

            ultraSURPLUS.Text = "";
            txtSURPLUS_STATE.Text = "";//余样情况

            txtPROMISE_FINISH_TIME.Text = "";//试验完成时间约定
            txtCHECK_PRICE.Text = "";//试验费用

            ultraREPORT_TYPE.Text = "";//报告类型
            ultraGET_REPORT_WAY.Text = "";//取报告方式

            txtCONSIGN_DEPT.Text = "";
            txtCONSIGN_ADDRESS.Text = "";//委托地址
            txtPOSTCODE.Text = "";//邮编
            txtPHONE.Text = "";//电话
            txtFAX.Text = "";//传真

            txtCONSIGN_NAME.Text = "";//委托方签字
            txtJC_RECEIVE_NAME.Text = "";//试验单位接收人
        }


        //删除检验委托new 方法
        private void DeleteCheckConsign()
        {
            try
            {
                //string strCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim();
                //PublicServer.GetDataTips("com.steering.lims.data.outdec.FrmOutdecCheckConsign.QueryCheckConsignBaseTips",
                //new Object[] { strCHECK_NO, new string[] { "1", "2" }, new String[] { "此检验任务已下发，不允许删除！", "此检验任务加工已确认，不允许删除！" } }, ob);

                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.outdec.FrmOutdecCheckConsign.DeleteCheckConsign",
                            new Object[] { publicUltraGridBase1.Ur.Cells["IS_JG"].Text.Trim(), strCHECK_NO, al }, this.ob);

                    QueryCheckConsignBase();
                    MessageUtil.ShowTips("删除成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

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

                al.Add("");
                al.Add(txtCHECK_NO.Text.Trim());

                publicUltraGridDetail1.QueryCheckConsignDetail("outdec.PublicOutdecBase", al, this.ob, 3);

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

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

                al.Add("");
                al.Add(txtCHECK_NO.Text.Trim());

                publicUltraGridChemDetail1.QueryCheckConsignChemDetail("outdec.PublicOutdecBase", al, this.ob);

                //RefreshAutoSize();//自适应
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.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()
        {
            FrmBaseSelectItems _selectItems = new FrmBaseSelectItems(this.ob);//0810
            //_selectItems.DtSelectPhyMax = m_dtSelectPhyMax;
            _selectItems.DtSelectPhySampleCode = m_dtSelectPhySampleCode;
            _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(3, m_dtSelectPhySampleCode, publicUltraGridDetail1.DataTable);//把选中的大项增加到publicUltraGridDetail1.DataTable
        }

        private void btnAuto_Click(object sender, EventArgs e)
        {
            try
            {
                DataTable dt = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecCheckConsign.QueryMaxCheckNo",
                      new Object[] { }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    return;
                }
                txtCHECK_NO.Text = dt.Rows[0]["CHECK_NO"].ToString();
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
                return;
            }
        }

        private void UpdateCheckConsignDetail()
        {
            try
            {
                if (publicUltraGridBase1.Ur == null || publicUltraGridBase1.Ug == null || publicUltraGridBase1.Ug.Rows.Count == 0)
                {
                    return;
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否确认调整权限？") == DialogResult.Yes)
                {
                    WinLabItemsSend pc = new WinLabItemsSend();
                    pc.Ob = this.ob;
                    pc.StrCheck = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim();
                    pc.StrPath = "outdec.FrmOutdecCheckConsign";
                    pc.ShowDialog();
                    if (pc.DialogResult != DialogResult.OK)
                    {
                        return;
                    }
                    MessageUtil.ShowTips("调整权限成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        /// <summary>
        /// 检验委托单
        /// </summary>
        private void RepLimsOutdecConsignCheckOrder()
        {
            try
            {
                this.Cursor = Cursors.WaitCursor;
                UltraGridRow ugr = publicUltraGridBase1.Ur;
                if (ugr == null)
                {
                    MessageUtil.ShowWarning("请选择您要打印的检验编号！");
                    return;
                }
                string strCHECK_NO = ugr.Cells["CHECK_NO"].Text.Trim();
                string strurl = "";
                //if (ob.MainUrl.StartsWith("http://127.0.0.1"))
                //{
                //    strurl = "http://localhost:8075/webroot/decision/view/report?viewlet=RepLimsOutdecConsignCheckOrder.cpt&bypagesize=false" + "&CHECK_NO=" + strCHECK_NO;

                //}
                //else
                //{
                strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsOutdecConsignCheckOrder.cpt&bypagesize=false" + "&CHECK_NO=" + strCHECK_NO;
                //}
                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();
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }

        private void RepLimsOutdecJGCheckTaskOrder()
        {
            try
            {
                this.Cursor = Cursors.WaitCursor;
                UltraGridRow ugr = publicUltraGridBase1.Ur;
                if (ugr == null)
                {
                    MessageUtil.ShowWarning("请选择您要打印的检验任务单！");
                    return;
                }

                string strCHECK_NO = ugr.Cells["CHECK_NO"].Value.ToString();
                string strurl = "";
                //if (ob.MainUrl.StartsWith("http://127.0.0.1"))
                //{
                //    strurl = "http://localhost:8075/webroot/decision/view/report?viewlet=RepLimsOutdecJGCheckTaskOrder.cpt&bypagesize=false&CHECK_NO=" + strCHECK_NO;

                //}
                //else
                //{
                strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsOutdecJGCheckTaskOrder.cpt&bypagesize=false&CHECK_NO=" + strCHECK_NO;
                //}
                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();
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }

        /// <summary>
        /// 试验费用计算
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnPrice_Click(object sender, EventArgs e)
        {
            try
            {
                ArrayList al = new ArrayList();
                //al.Add("1");
                al.Add("");

                DataTable dt = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecCheckPrice.QueryCheckPriceInfo",
    new Object[] { al }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    txtCHECK_PRICE.Text = "0";
                    MessageUtil.ShowWarning("请维护试验费用基础数据！");
                    return;
                }
                double price = 0;

                DataRow[] arrDr;
                publicUltraGridDetail1.Ug.UpdateData();
                if (publicUltraGridDetail1.DataTable != null || publicUltraGridDetail1.DataTable.Rows.Count > 0)
                {
                    foreach (DataRow dr in publicUltraGridDetail1.DataTable.Rows)
                    {
                        foreach (DataColumn dc in publicUltraGridDetail1.DataTable.Columns)
                        {
                            if (dc.ColumnName != "SAMPLE_NO" && dc.ColumnName != "SAMPLE_SIZE" && dc.ColumnName != "HX" && dr[dc.ColumnName].ToString().Trim() != "")
                            {
                                arrDr = dt.Select("VALIDFLAG = '1' AND CHECK_PRICE_TYPE = '1' AND PHY_CODE_MAX = '" + dc.ColumnName + "'");
                                if (arrDr != null && arrDr.Length == 1)
                                {
                                    if (chkIS_JG.Checked == false)
                                    {
                                        price += Convert.ToDouble(arrDr[0]["CHECK_PRICE"].ToString() == "" ? "0" : arrDr[0]["CHECK_PRICE"].ToString()) + Convert.ToDouble(arrDr[0]["JG_PRICE"].ToString() == "" ? "0" : arrDr[0]["JG_PRICE"].ToString());
                                    }
                                    else
                                    {
                                        price += Convert.ToDouble(arrDr[0]["CHECK_PRICE"].ToString() == "" ? "0" : arrDr[0]["CHECK_PRICE"].ToString());//不经过加工 则不需要加工费
                                    }
                                }
                            }
                        }
                    }
                }

                if (publicUltraGridChemDetail1.DataTable != null || publicUltraGridChemDetail1.DataTable.Rows.Count > 0)
                {
                    publicUltraGridChemDetail1.Ug.UpdateData();
                    foreach (DataRow dr in publicUltraGridChemDetail1.DataTable.Rows)
                    {
                        foreach (DataColumn dc in publicUltraGridChemDetail1.DataTable.Columns)
                        {
                            if (dc.ColumnName != "SAMPLE_NO" && dr[dc.ColumnName].ToString().Trim() != "")
                            {
                                arrDr = dt.Select("VALIDFLAG = '1' AND CHECK_PRICE_TYPE = '0' AND PHY_CODE_MAX = '" + dc.Caption + "'");
                                if (arrDr != null && arrDr.Length == 1)
                                {
                                    if (chkIS_JG.Checked == false)
                                    {
                                        price += Convert.ToDouble(arrDr[0]["CHECK_PRICE"].ToString() == "" ? "0" : arrDr[0]["CHECK_PRICE"].ToString()) + Convert.ToDouble(arrDr[0]["JG_PRICE"].ToString() == "" ? "0" : arrDr[0]["JG_PRICE"].ToString());
                                    }
                                    else
                                    {
                                        price += Convert.ToDouble(arrDr[0]["CHECK_PRICE"].ToString() == "" ? "0" : arrDr[0]["CHECK_PRICE"].ToString());//不经过加工 则不需要加工费
                                    }
                                }
                            }
                        }
                    }
                }

                txtCHECK_PRICE.Text = price.ToString();
                txtCHECK_PRICE_REAL.Text = price.ToString();
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
                return;
            }
        }

        private void ultraREPORT_TYPE_ValueChanged(object sender, EventArgs e)
        {
            if (ultraREPORT_TYPE.Text.ToString().Equals("本征检测"))
            {
                txtCHECK_DEPT.Text = "天津本征检测科技有限公司             开户行：工商银行天津津东支行         账号：0302016009300043731           ";
            }
            else
            {
                txtCHECK_DEPT.Text = "天津钢管集团股份有限公司检测中心     开户行：工商银行天津津东支行         账号：0302016009300023121           ";
            }
        }

        /// <summary>
        /// 修改结算状态
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void chkIS_CLEARING_CheckedChanged(object sender, EventArgs e)
        {
            string strIS_CLEARING = "1";
            if (chkIS_CLEARING.Checked)
            {
                strIS_CLEARING = "0";
            }
            string strCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim();
            PublicServer.SetData("com.steering.lims.data.outdec.FrmOutdecCheckConsign.UpdateIsClearing",
                    new Object[] { strCHECK_NO, strIS_CLEARING }, this.ob);
            //MessageUtil.ShowTips("结算状态修改成功！");
            QueryCheckConsignBase();
            var redirectRow = publicUltraGridBase1.Ug.Rows.Where(a => a.GetValue("CHECK_NO") == strCHECK_NO).FirstOrDefault();
            if (redirectRow != null)
            {
                redirectRow.Activate();
            }
            
        }
    }
}