MES_Client/TGMES/Core.StlMes.Client.Lims.Data.PipeAndOutdec/数据管理/钢管实验管理/FrmLabEngDataCJAudit.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using CoreFS.CA06;
using System.Collections;
using Core.Mes.Client.Comm.Tool;
using Infragistics.Win.UltraWinGrid;
using Core.Mes.Client.Comm.Control;
using Infragistics.Win;
using System.Net;
using Core.Mes.Client.Comm.Server;
using Core.StlMes.Client.Lims.Data.PipeAndOutdec.数据管理.外委实验管理;

namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec
{
    //工程力学录入界面 各检验大项分Tab页展示
    public partial class FrmLabEngDataCJAudit : FrmBase
    {
        private string[] arrId;//数据权限
        private string[] plineCodes = { };

        private DataTable m_dtPhyMax;//存放所有要检验的项目
        private DataTable m_dtPhyItems;//存放所有要检验的项目试验方法

        private DataTable m_dtPhyMaxAdd;//存放所有已检验的项目
        private DataTable m_dtPhyItemsAdd;//存放所有已检验的项目试验方法

        private DataTable m_dtPhyMaxAudit;
        private DataTable m_dtPhyItemsAudit;

        private DataTable m_dtPhyMaxAuditAdd;
        private DataTable m_dtPhyItemsAuditAdd;

        private string CHECK_NO = "";
        private string SAMPLE_NO = "";
        private string PHY_CODE_MAX = "";
        private string arrIdStr = "002001007014,002023003004";

        private int tabIndex = 0;//保存当前的tab页
        public FrmLabEngDataCJAudit()
        {
            InitializeComponent();
        }

        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            //publicUltraGridBase1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
            //publicUltraGridBase2.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头

            publicUltraGridBase1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
            publicUltraGridBase2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框

            publicUltraGridDataCJBase1_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
            publicUltraGridDataCJBase1_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
            publicUltraGridDataCJBase1_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//

            publicUltraGridDataCJBase2_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
            publicUltraGridDataCJBase2_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
            publicUltraGridDataCJBase2_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框

            publicUltraGridDataCJBase3_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
            publicUltraGridDataCJBase3_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
            publicUltraGridDataCJBase3_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            publicUltraGridDataCJBase4_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
            publicUltraGridDataCJBase4_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            publicUltraGridDataCJBase4_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            //publicUltraGridDataCJBase5_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
            //publicUltraGridDataCJBase5_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            //publicUltraGridDataCJBase5_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            //publicUltraGridDataCJBase6_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
            //publicUltraGridDataCJBase6_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            //publicUltraGridDataCJBase6_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            publicUltraGridDataCJBase7_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
            publicUltraGridDataCJBase7_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
            publicUltraGridDataCJBase7_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//

            publicUltraGridDataCJBase8_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
            publicUltraGridDataCJBase8_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
            publicUltraGridDataCJBase8_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框

            publicUltraGridDataCJBase9_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
            publicUltraGridDataCJBase9_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
            publicUltraGridDataCJBase9_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            publicUltraGridDataCJBase10_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
            publicUltraGridDataCJBase10_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            publicUltraGridDataCJBase10_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            //publicUltraGridDataCJBase11_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
            //publicUltraGridDataCJBase11_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            //publicUltraGridDataCJBase11_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            //publicUltraGridDataCJBase12_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
            //publicUltraGridDataCJBase12_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            //publicUltraGridDataCJBase12_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            publicUltraGridDataCJBase13_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
            publicUltraGridDataCJBase13_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
            publicUltraGridDataCJBase13_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//

            publicUltraGridDataCJBase14_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
            publicUltraGridDataCJBase14_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
            publicUltraGridDataCJBase14_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框

            publicUltraGridDataCJBase15_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
            publicUltraGridDataCJBase15_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
            publicUltraGridDataCJBase15_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            publicUltraGridDataCJBase16_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
            publicUltraGridDataCJBase16_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            publicUltraGridDataCJBase16_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            //publicUltraGridDataCJBase17_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
            //publicUltraGridDataCJBase17_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            //publicUltraGridDataCJBase17_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            //publicUltraGridDataCJBase18_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
            //publicUltraGridDataCJBase18_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            //publicUltraGridDataCJBase18_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            ultraGrid1.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            publicUltraGridDataCJBase19_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
            publicUltraGridDataCJBase19_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
            publicUltraGridDataCJBase19_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//

            publicUltraGridDataCJBase20_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
            publicUltraGridDataCJBase20_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
            publicUltraGridDataCJBase20_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框

            publicUltraGridDataCJBase21_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
            publicUltraGridDataCJBase21_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
            publicUltraGridDataCJBase21_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            publicUltraGridDataCJBase22_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
            publicUltraGridDataCJBase22_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            publicUltraGridDataCJBase22_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            //publicUltraGridDataCJBase23_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
            //publicUltraGridDataCJBase23_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            //publicUltraGridDataCJBase23_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            //publicUltraGridDataCJBase24_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
            //publicUltraGridDataCJBase24_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            //publicUltraGridDataCJBase24_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            //ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            //ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            //pipeQueryBase1.ShowPrintControl();
        }

        private void FrmDataCJBase_Load(object sender, EventArgs e)
        {
            //arrId = this.ValidDataPurviewIds;//获取数据权限
            arrId = new string[] { "002001007014", "002023003004" };//工程力学项目
            plineCodes = comm.GetPlineCode(ValidDataPurviewIds, ob);
            InitColumns();
            
            publicDataCJBase1.checkNameEnable();
            publicDataCJBase2.checkNameEnable();
            publicDataCJBase3.checkNameEnable();
            publicDataCJBase4.checkNameEnable();

            
        }

        private void InitColumns()
        {
            pipeShowBase1.ChangeLabel();
            pipeShowBase2.ChangeLabel();

            //未录入
            publicUltraGridBase1.PublicUltraGridBaseActive += new EventHandler(pipeUltraGridBase1_PublicUltraGridBaseActive);//调用委托事件

            publicUltraGridBase1.InitColumnsPipeBase(new string[] { "CHECK_NO", "SAMPLE_NO" }, true, null);
            //string[] arrColumnsBase = new string[] { "CHECK_NO", "SAMPLE_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" };
            //string[] arrCaptionBase = new string[] { "检验编号", "样管号", "炉号", "钢级", "钢号", "技术标准", "合同号", "外径", "壁厚", "委托单位", "委托人", "委托时间", "是否监制", "特殊要求", "标志位", "标志位", "备注" };

            //publicUltraGridBase1.InitColumns(arrColumnsBase, arrCaptionBase);
            //publicUltraGridBase1.setColumnShowOrHidden(new string[] { "CHECK_NO", "SAMPLE_NO", }, true);//显示列
            //publicUltraGridBase1.setOtherColumnReadOnly(null);//可编辑列

            publicUltraGridDataCJBase1_1.InitColumnsPhyConfigItems();
            publicUltraGridDataCJBase1_2.InitColumnsPhyDetail();

            publicUltraGridDataCJBase2_1.InitColumnsPhyConfigItems();
            publicUltraGridDataCJBase2_2.InitColumnsPhyDetail();

            publicUltraGridDataCJBase3_1.InitColumnsPhyConfigItems();
            publicUltraGridDataCJBase3_2.InitColumnsPhyDetail();

            publicUltraGridDataCJBase4_1.InitColumnsPhyConfigItems();
            publicUltraGridDataCJBase4_2.InitColumnsPhyDetail();

            //publicUltraGridDataCJBase5_1.InitColumnsPhyConfigItems();
            //publicUltraGridDataCJBase5_2.InitColumnsPhyDetail();

            //publicUltraGridDataCJBase6_1.InitColumnsPhyConfigItems();
            //publicUltraGridDataCJBase6_2.InitColumnsPhyDetail();

            //已录入
            publicUltraGridBase2.PublicUltraGridBaseActive += new EventHandler(pipeUltraGridBase2_PublicUltraGridBaseActive);//调用委托事件
            publicUltraGridBase2.InitColumnsPipeBase(new string[] { "CHECK_NO", "SAMPLE_NO" }, true, null);

            //publicUltraGridBase2.InitColumns(arrColumnsBase, arrCaptionBase);
            //publicUltraGridBase2.setColumnShowOrHidden(new string[] { "CHECK_NO", "SAMPLE_NO", }, true);//显示列
            //publicUltraGridBase2.setOtherColumnReadOnly(new string[] { null });//可编辑列

            publicUltraGridDataCJBase7_1.InitColumnsPhyConfigItems();
            publicUltraGridDataCJBase7_2.InitColumnsPhyDetail();

            publicUltraGridDataCJBase8_1.InitColumnsPhyConfigItems();
            publicUltraGridDataCJBase8_2.InitColumnsPhyDetail();

            publicUltraGridDataCJBase9_1.InitColumnsPhyConfigItems();
            publicUltraGridDataCJBase9_2.InitColumnsPhyDetail();

            publicUltraGridDataCJBase10_1.InitColumnsPhyConfigItems();
            publicUltraGridDataCJBase10_2.InitColumnsPhyDetail();

            //publicUltraGridDataCJBase11_1.InitColumnsPhyConfigItems();
            //publicUltraGridDataCJBase11_2.InitColumnsPhyDetail();

            //publicUltraGridDataCJBase12_1.InitColumnsPhyConfigItems();
            //publicUltraGridDataCJBase12_2.InitColumnsPhyDetail();

            PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid1, new string[] { "CHK", "CHECK_NO" }, true);
            PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid1, new string[] { "CHK", "SAMPLE_NO" }, true, 1);//显示列
            PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid1, new string[] { "CHK" });//可编辑列
            PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid1, new string[] { "CHK" }, 1);

            publicUltraGridDataCJBase13_1.InitColumnsPhyConfigItems(null);
            publicUltraGridDataCJBase13_1.setOtherColumnReadOnly(null);
            publicUltraGridDataCJBase13_2.InitColumnsPhyDetail(null);
            publicUltraGridDataCJBase13_2.setOtherColumnReadOnly(null);

            publicUltraGridDataCJBase14_1.InitColumnsPhyConfigItems(null);
            publicUltraGridDataCJBase14_1.setOtherColumnReadOnly(null);
            publicUltraGridDataCJBase14_2.InitColumnsPhyDetail(null);
            publicUltraGridDataCJBase14_2.setOtherColumnReadOnly(null);

            publicUltraGridDataCJBase15_1.InitColumnsPhyConfigItems(null);
            publicUltraGridDataCJBase15_1.setOtherColumnReadOnly(null);
            publicUltraGridDataCJBase15_2.InitColumnsPhyDetail(null);
            publicUltraGridDataCJBase15_2.setOtherColumnReadOnly(null);

            publicUltraGridDataCJBase16_1.InitColumnsPhyConfigItems(null);
            publicUltraGridDataCJBase16_2.InitColumnsPhyDetail(null);

            //publicUltraGridDataCJBase17_1.InitColumnsPhyConfigItems(null);
            //publicUltraGridDataCJBase17_2.InitColumnsPhyDetail(null);

            //publicUltraGridDataCJBase18_1.InitColumnsPhyConfigItems(null);
            //publicUltraGridDataCJBase18_2.InitColumnsPhyDetail(null);

            PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid2, new string[] { "CHK", "CHECK_NO" }, true);
            PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid2, new string[] { "CHK", "SAMPLE_NO" }, true, 1);//显示列
            PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid2, new string[] { "CHK" });//可编辑列
            PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid2, new string[] { "CHK" }, 1);

            publicUltraGridDataCJBase19_1.InitColumnsPhyConfigItems(null);
            publicUltraGridDataCJBase19_2.InitColumnsPhyDetail(null);

            publicUltraGridDataCJBase20_1.InitColumnsPhyConfigItems(null);
            publicUltraGridDataCJBase20_2.InitColumnsPhyDetail(null);

            publicUltraGridDataCJBase21_1.InitColumnsPhyConfigItems(null);
            publicUltraGridDataCJBase21_2.InitColumnsPhyDetail(null);

            publicUltraGridDataCJBase22_1.InitColumnsPhyConfigItems(null);
            publicUltraGridDataCJBase22_2.InitColumnsPhyDetail(null);

            //publicUltraGridDataCJBase23_1.InitColumnsPhyConfigItems(null);
            //publicUltraGridDataCJBase23_2.InitColumnsPhyDetail(null);

            //publicUltraGridDataCJBase24_1.InitColumnsPhyConfigItems(null);
            //publicUltraGridDataCJBase24_2.InitColumnsPhyDetail(null);
        }

        /// <summary>
        /// 重写基类方法
        /// </summary>
        /// <param name="sender"></param> 
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            //查询、确认、退出
            switch (ToolbarKey)
            {
                case "Query":
                    if (ultraTabControl1.SelectedTab.Index == 0)
                    {
                        QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "2");
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 1)
                    {
                        QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "3456");
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 2)
                    {
                        QueryCheckConsignBaseDetail_Distinct(ultraGrid1, "3");
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 3)
                    {
                        QueryCheckConsignBaseDetail_Distinct(ultraGrid2, "456");
                    }
                    break;
                case "Add":
                    if (ultraTabControl2.SelectedTab.Index == 0)
                    {
                        AddCheckConsignProcessResult(publicUltraGridDataCJBase1_2, publicUltraGridDataCJBase1_1);
                    }
                    else if (ultraTabControl2.SelectedTab.Index == 1)
                    {
                        AddCheckConsignProcessResult(publicUltraGridDataCJBase2_2, publicUltraGridDataCJBase2_1);
                    }
                    else if (ultraTabControl2.SelectedTab.Index == 2)
                    {
                        AddCheckConsignProcessResult(publicUltraGridDataCJBase3_2, publicUltraGridDataCJBase3_1);
                    }
                    else if (ultraTabControl2.SelectedTab.Index == 3)
                    {
                        AddCheckConsignProcessResult(publicUltraGridDataCJBase4_2, publicUltraGridDataCJBase4_1);
                    }
                    //else if (ultraTabControl2.SelectedTab.Index == 4)
                    //{
                    //    AddCheckConsignProcessResult(publicUltraGridDataCJBase5_2, publicUltraGridDataCJBase5_1);
                    //}
                    //else if (ultraTabControl2.SelectedTab.Index == 5)
                    //{
                    //    AddCheckConsignProcessResult(publicUltraGridDataCJBase6_2, publicUltraGridDataCJBase6_1);
                    //}
                    break;
                case "Update":
                    if (ultraTabControl3.SelectedTab.Index == 0)
                    {
                        UpdateCheckConsignProcessResult(publicUltraGridDataCJBase7_2, publicUltraGridDataCJBase7_1);
                    }
                    else if (ultraTabControl3.SelectedTab.Index == 1)
                    {
                        UpdateCheckConsignProcessResult(publicUltraGridDataCJBase8_2, publicUltraGridDataCJBase8_1);
                    }
                    else if (ultraTabControl3.SelectedTab.Index == 2)
                    {
                        UpdateCheckConsignProcessResult(publicUltraGridDataCJBase9_2, publicUltraGridDataCJBase9_1);
                    }
                    else if (ultraTabControl3.SelectedTab.Index == 3)
                    {
                        UpdateCheckConsignProcessResult(publicUltraGridDataCJBase10_2, publicUltraGridDataCJBase10_1);
                    }
                    //else if (ultraTabControl3.SelectedTab.Index == 4)
                    //{
                    //    UpdateCheckConsignProcessResult(publicUltraGridDataCJBase11_2, publicUltraGridDataCJBase11_1);
                    //}
                    //else if (ultraTabControl3.SelectedTab.Index == 5)
                    //{
                    //    UpdateCheckConsignProcessResult(publicUltraGridDataCJBase12_2, publicUltraGridDataCJBase12_1);
                    //}
                    //UpdateCheckConsignProcessResult();
                    break;
                case "Delete":
                    if (ultraTabControl3.SelectedTab.Index == 0)
                    {
                        DeleteCheckConsignProcessResult(publicUltraGridDataCJBase7_2, publicUltraGridDataCJBase7_1);
                    }
                    else if (ultraTabControl3.SelectedTab.Index == 1)
                    {
                        DeleteCheckConsignProcessResult(publicUltraGridDataCJBase8_2, publicUltraGridDataCJBase8_1);
                    }
                    else if (ultraTabControl3.SelectedTab.Index == 2)
                    {
                        DeleteCheckConsignProcessResult(publicUltraGridDataCJBase9_2, publicUltraGridDataCJBase9_1);
                    }
                    else if (ultraTabControl3.SelectedTab.Index == 3)
                    {
                        DeleteCheckConsignProcessResult(publicUltraGridDataCJBase10_2, publicUltraGridDataCJBase10_1);
                    }
                    //else if (ultraTabControl3.SelectedTab.Index == 4)
                    //{
                    //    DeleteCheckConsignProcessResult(publicUltraGridDataCJBase11_2, publicUltraGridDataCJBase11_1);
                    //}
                    //else if (ultraTabControl3.SelectedTab.Index == 5)
                    //{
                    //    DeleteCheckConsignProcessResult(publicUltraGridDataCJBase12_2, publicUltraGridDataCJBase12_1);
                    //}
                    //DeleteCheckConsignProcessResult();
                    break;
                case "Audit":
                    AuditCheckConsignDetail();//SingleAuditCheckConsignDetail()
                    break;
                case "CancelAudit":
                    CancelAuditCheckConsignDetail();//SingleAuditCheckConsignDetail()
                    break;
                case "SingleAudit":
                    if (ultraTabControl4.SelectedTab.Index == 0)
                    {
                        SingleAuditCheckConsignDetail(publicUltraGridDataCJBase13_2);
                    }
                    else if (ultraTabControl4.SelectedTab.Index == 1)
                    {
                        SingleAuditCheckConsignDetail(publicUltraGridDataCJBase14_2);
                    }
                    else if (ultraTabControl4.SelectedTab.Index == 2)
                    {
                        SingleAuditCheckConsignDetail(publicUltraGridDataCJBase15_2);
                    }
                    else if (ultraTabControl4.SelectedTab.Index == 3)
                    {
                        SingleAuditCheckConsignDetail(publicUltraGridDataCJBase16_2);
                    }
                    //else if (ultraTabControl4.SelectedTab.Index == 4)
                    //{
                    //    SingleAuditCheckConsignDetail(publicUltraGridDataCJBase17_2);
                    //}
                    //else if (ultraTabControl4.SelectedTab.Index == 5)
                    //{
                    //    SingleAuditCheckConsignDetail(publicUltraGridDataCJBase18_2);
                    //}
                    break;
                case "CancelSingleAudit":
                    if (ultraTabControl5.SelectedTab.Index == 0)
                    {
                        CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase19_2);
                    }
                    else if (ultraTabControl5.SelectedTab.Index == 1)
                    {
                        CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase20_2);
                    }
                    else if (ultraTabControl5.SelectedTab.Index == 2)
                    {
                        CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase21_2);
                    }
                    else if (ultraTabControl5.SelectedTab.Index == 3)
                    {
                        CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase22_2);
                    }
                    //else if (ultraTabControl5.SelectedTab.Index == 4)
                    //{
                    //    CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase23_2);
                    //}
                    //else if (ultraTabControl5.SelectedTab.Index == 5)
                    //{
                    //    CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase24_2);
                    //}
                    break;
                case "SaveParm":
                    SaveParm();
                    break;
                case "DoPrint":
                    doPrint();
                    break;
                case "UpFile":
                    UpFile();
                    break;
                case "Close":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
                    {
                        this.Close();
                    }
                    break;
            }
        }

        #region 公共方法

        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        private UltraGridRow getugr()
        {
            UltraGridRow ugr = null;
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                if (ultraTabControl2.SelectedTab.Index == 0)
                {
                    ugr = publicUltraGridDataCJBase1_2.Ug.ActiveRow;
                }
                else if (ultraTabControl2.SelectedTab.Index == 1)
                {
                    ugr = publicUltraGridDataCJBase2_2.Ug.ActiveRow;
                }
                else if (ultraTabControl2.SelectedTab.Index == 2)
                {
                    ugr = publicUltraGridDataCJBase3_2.Ug.ActiveRow;
                }
                else if (ultraTabControl2.SelectedTab.Index == 3)
                {
                    ugr = publicUltraGridDataCJBase4_2.Ug.ActiveRow;
                }
                //else if (ultraTabControl2.SelectedTab.Index == 4)
                //{
                //    ugr = publicUltraGridDataCJBase5_2.Ug.ActiveRow;
                //}
                //ugr = publicUltraGridDetail1.Ug.ActiveRow;
            }
            else if (ultraTabControl1.SelectedTab.Index == 1)
            {
                //ugr = publicUltraGridDetail2.Ug.ActiveRow;
                if (ultraTabControl3.SelectedTab.Index == 0)
                {
                    ugr = publicUltraGridDataCJBase7_2.Ug.ActiveRow;
                }
                else if (ultraTabControl3.SelectedTab.Index == 1)
                {
                    ugr = publicUltraGridDataCJBase8_2.Ug.ActiveRow;
                }
                else if (ultraTabControl3.SelectedTab.Index == 2)
                {
                    ugr = publicUltraGridDataCJBase9_2.Ug.ActiveRow;
                }
                else if (ultraTabControl3.SelectedTab.Index == 3)
                {
                    ugr = publicUltraGridDataCJBase10_2.Ug.ActiveRow;
                }
                //else if (ultraTabControl2.SelectedTab.Index == 4)
                //{
                //    ugr = publicUltraGridDataCJBase11_2.Ug.ActiveRow;
                //}
            }
            else if (ultraTabControl1.SelectedTab.Index == 2)
            {
                //ugr = publicUltraGridDetail3.Ug.ActiveRow;
                if (ultraTabControl4.SelectedTab.Index == 0)
                {
                    ugr = publicUltraGridDataCJBase13_2.Ug.ActiveRow;
                }
                else if (ultraTabControl4.SelectedTab.Index == 1)
                {
                    ugr = publicUltraGridDataCJBase14_2.Ug.ActiveRow;
                }
                else if (ultraTabControl4.SelectedTab.Index == 2)
                {
                    ugr = publicUltraGridDataCJBase15_2.Ug.ActiveRow;
                }
                else if (ultraTabControl4.SelectedTab.Index == 3)
                {
                    ugr = publicUltraGridDataCJBase16_2.Ug.ActiveRow;
                }
                //else if (ultraTabControl2.SelectedTab.Index == 4)
                //{
                //    ugr = publicUltraGridDataCJBase17_2.Ug.ActiveRow;
                //}
            }
            else if (ultraTabControl1.SelectedTab.Index == 3)
            {
                //ugr = publicUltraGridDetail4.Ug.ActiveRow;
                if (ultraTabControl5.SelectedTab.Index == 0)
                {
                    ugr = publicUltraGridDataCJBase19_2.Ug.ActiveRow;
                }
                else if (ultraTabControl5.SelectedTab.Index == 1)
                {
                    ugr = publicUltraGridDataCJBase20_2.Ug.ActiveRow;
                }
                else if (ultraTabControl5.SelectedTab.Index == 2)
                {
                    ugr = publicUltraGridDataCJBase21_2.Ug.ActiveRow;
                }
                else if (ultraTabControl5.SelectedTab.Index == 3)
                {
                    ugr = publicUltraGridDataCJBase22_2.Ug.ActiveRow;
                }
                //else if (ultraTabControl2.SelectedTab.Index == 4)
                //{
                //    ugr = publicUltraGridDataCJBase23_2.Ug.ActiveRow;
                //}
            }

            if (ugr != null)
            {
                CHECK_NO = ugr.Cells["CHECK_NO"].Value.ToString();
                SAMPLE_NO = ugr.Cells["SAMPLE_NO"].Value.ToString();
                PHY_CODE_MAX = ugr.Cells["PHY_CODE_MAX"].Value.ToString();
            }
            else
            {
                CHECK_NO = "";
                SAMPLE_NO = "";
                PHY_CODE_MAX = "";
            }

            publicDataCJBase1.initCheckEqiupment(arrId, PHY_CODE_MAX, this.ob);
            publicDataCJBase2.initCheckEqiupment(arrId, PHY_CODE_MAX, this.ob);
            publicDataCJBase3.initCheckEqiupment(arrId, PHY_CODE_MAX, this.ob);
            publicDataCJBase4.initCheckEqiupment(arrId, PHY_CODE_MAX, this.ob);

            return ugr;
        }
        /// <summary>
        /// 试验条件
        /// </summary>
        private void SaveParm()
        {
            getugr();
            FrmLabEngDataParm labDateParm = new FrmLabEngDataParm(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX, this.ob);
            labDateParm.ShowDialog();

            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "2");
            }
            else if (ultraTabControl1.SelectedTab.Index == 1)
            {
                QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "3456");
            }
            else if (ultraTabControl1.SelectedTab.Index == 2)
            {
                QueryCheckConsignBaseDetail_Distinct(ultraGrid1, "3");
            }
            else if (ultraTabControl1.SelectedTab.Index == 3)
            {
                QueryCheckConsignBaseDetail_Distinct(ultraGrid2, "456");
            }
        }

        //设备信息赋值给实体类
        /// <summary>
        /// 设备信息赋值给实体类
        /// </summary>
        /// <param name="sampleNo"></param>
        /// <param name="checkNo"></param>
        /// <param name="phyCodeMax"></param>
        /// <returns></returns>
        private PipeCheckconsignDetailEntity getCheckDetal(string checkNo, string sampleNo, string phyCodeMax)
        {
            //设备信息
            ArrayList listDetail = new ArrayList();
            listDetail.Add(sampleNo);
            listDetail.Add(checkNo);
            listDetail.Add(phyCodeMax);
            DataTable dtDetail = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryChemCheckConsignDetail",
new Object[] { listDetail }, ob);
            PipeCheckconsignDetailEntity checkDetal = new PipeCheckconsignDetailEntity();
            if (dtDetail.Rows.Count > 0)
            {
                checkDetal.CheckName = dtDetail.Rows[0]["CHECK_NAME"].ToString();
                checkDetal.CheckTime = dtDetail.Rows[0]["CHECK_TIME"].ToString();
                checkDetal.CheckShift = dtDetail.Rows[0]["CHECK_SHIFT"].ToString();
                checkDetal.CheckClass = dtDetail.Rows[0]["CHECK_CLASS"].ToString();
                checkDetal.DeviceNo = dtDetail.Rows[0]["DEVICE_NO"].ToString();
                checkDetal.DeviceName = dtDetail.Rows[0]["DEVICE_NAME"].ToString();
                checkDetal.CheckTemp = dtDetail.Rows[0]["CHECK_TEMP"].ToString();
                checkDetal.Remark = dtDetail.Rows[0]["REMARK"].ToString();
                checkDetal.AuditName = dtDetail.Rows[0]["AUDIT_NAME"].ToString();
                checkDetal.AuditTime = dtDetail.Rows[0]["AUDIT_TIME"].ToString();
                checkDetal.FormualNo = dtDetail.Rows[0]["FORMUAL_NO"].ToString();
                checkDetal.FormualName = dtDetail.Rows[0]["FORMUAL_NAME"].ToString();
            }

            return checkDetal;
        }


        //打印
        /// <summary>
        /// 打印
        /// </summary>
        private void doPrint()
        {
            getugr();
            string strurl = "";

            if (PHY_CODE_MAX.Equals("C0018") || PHY_CODE_MAX.Equals("C0035") || PHY_CODE_MAX.Equals("C0065")) //压溃试验、滑脱试验、爆破试验
            {
                strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepPipeGCBurst.cpt&op=view&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
            }
            else if (PHY_CODE_MAX.Equals("C0064")) //上、卸扣试验
            {
                strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepPipeGCAntigalling.cpt&op=view&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
            }
            else if (PHY_CODE_MAX.Equals("C0036") || PHY_CODE_MAX.Equals("C0037") || PHY_CODE_MAX.Equals("C0066")) //抗内压强度、复合力试验
            {
                strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepPipeGCCombinedStress.cpt&op=view&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
            }

            

            FrmExcel fre = new FrmExcel(this.ob, strurl);

            fre.AutoSize = true;
            fre.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
            fre.WindowState = FormWindowState.Maximized;
            fre.Show();
        }

        //查询上传的PDF文件
        /// <summary>
        /// 查询上传的PDF文件
        /// </summary>
        private void SelectFile(string filePathNew)
        {
            dlgOrderAskDown down = new dlgOrderAskDown(this.ob, filePathNew);
            down.DeleteButton.Visible = false;
            down.ShowDialog();
        }

        //上传
        /// <summary>
        /// 上传
        /// </summary>
        private void UpFile()
        {
            getugr();
            WebClient webClient = new WebClient();
            List<FileBean> listPdf = new List<FileBean>();
            string date = DateTime.Now.ToString("yyyyMMdd");

            DataTable ds = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.doQueryIsAudit", new object[] { CHECK_NO, arrId }, ob);
            if (int.Parse(ds.Rows[0][0].ToString()) > 0)
            {
                MessageUtil.ShowTips("还有未审核试样组,不允许上传报告!");
                return;
            }

            string url = "";
            string filePathNew = ""; //报告目录
            string reportNo = ""; //报告编号

            if (PHY_CODE_MAX.Equals("C0018") || PHY_CODE_MAX.Equals("C0035") || PHY_CODE_MAX.Equals("C0065")) //压溃试验、滑脱试验、爆破试验
            {
                url = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepPipeGCBurst.cpt&format=pdf&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
                reportNo = CHECK_NO + SAMPLE_NO + "Burst";
            }
            else if (PHY_CODE_MAX.Equals("C0064")) //上、卸扣试验
            {
                url = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepPipeGCAntigalling.cpt&format=pdf&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
                reportNo = CHECK_NO + SAMPLE_NO + "Antigalling";
            }
            else if (PHY_CODE_MAX.Equals("C0036") || PHY_CODE_MAX.Equals("C0037") || PHY_CODE_MAX.Equals("C0066")) //抗内压强度、复合力试验
            {
                url = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepPipeGCCombinedStress.cpt&format=pdf&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
                reportNo = CHECK_NO + SAMPLE_NO + "CombinedStress";
            }

            filePathNew = "Lims/pipe/gongcheng/" + CHECK_NO + "/";
           
            byte[] pdf = webClient.DownloadData(url);
            FileBean fileBean = new FileBean();

            fileBean.setFile(pdf);
            fileBean.setFileName(reportNo + ".pdf");
            fileBean.setPathName(filePathNew);
            listPdf.Add(fileBean);
            webClient.Dispose();
            bool a = FileHelper.Upload(listPdf);

            if (a)
            {
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.lims.data.pipe.FrmLabDateParm";
                ccp.MethodName = "updatePipeReport";
                ccp.ServerParams = new object[] { CHECK_NO, SAMPLE_NO, PHY_CODE_MAX, "GONGCHENG_PATH", filePathNew };
                ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode != -1)
                {
                    if (ccp.ReturnInfo.Equals("上传成功!"))
                    {
                        MessageUtil.ShowTips(ccp.ReturnInfo);
                        SelectFile(filePathNew);
                    }
                    else
                    {
                        MessageUtil.ShowTips(ccp.ReturnInfo);
                    }
                }
            }
            else
            {
                MessageUtil.ShowError("系统生成PDF失败，请稍后再试！");
                return;
            }
        }

        /// <summary>
        /// 自动上传
        /// </summary>
        private void UpFileAuto()
        {
            getugr();
            WebClient webClient = new WebClient();
            List<FileBean> listPdf = new List<FileBean>();
            string date = DateTime.Now.ToString("yyyyMMdd");

            string url = "";
            string filePathNew = ""; //报告目录
            string reportNo = ""; //报告编号

            if (PHY_CODE_MAX.Equals("C0018") || PHY_CODE_MAX.Equals("C0035") || PHY_CODE_MAX.Equals("C0065")) //压溃试验、滑脱试验、爆破试验
            {
                url = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepPipeGCBurst.cpt&format=pdf&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
                reportNo = CHECK_NO + SAMPLE_NO + "Burst";
            }
            else if (PHY_CODE_MAX.Equals("C0064")) //上、卸扣试验
            {
                url = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepPipeGCAntigalling.cpt&format=pdf&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
                reportNo = CHECK_NO + SAMPLE_NO + "Antigalling";
            }
            else if (PHY_CODE_MAX.Equals("C0036") || PHY_CODE_MAX.Equals("C0037") || PHY_CODE_MAX.Equals("C0066")) //抗内压强度、复合力试验
            {
                url = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepPipeGCCombinedStress.cpt&format=pdf&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
                reportNo = CHECK_NO + SAMPLE_NO + "CombinedStress";
            }

            filePathNew = "Lims/pipe/gongcheng/" + CHECK_NO + "/";

            byte[] pdf = webClient.DownloadData(url);
            FileBean fileBean = new FileBean();

            fileBean.setFile(pdf);
            fileBean.setFileName(reportNo + ".pdf");
            fileBean.setPathName(filePathNew);
            listPdf.Add(fileBean);
            webClient.Dispose();
            bool a = FileHelper.Upload(listPdf);

            if (a)
            {
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.lims.data.pipe.FrmLabDateParm";
                ccp.MethodName = "updatePipeReport";
                ccp.ServerParams = new object[] { CHECK_NO, SAMPLE_NO, PHY_CODE_MAX, "GONGCHENG_PATH", filePathNew };
                ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode != -1)
                {
                    if (ccp.ReturnInfo.Equals("上传成功!"))
                    {
                        
                    }
                    else
                    {
                        MessageUtil.ShowTips(ccp.ReturnInfo);
                    }
                }
            }
            else
            {
                MessageUtil.ShowError("系统自动上传报告失败，请全部审核后手动上传报告！");
                return;
            }
        }


        //颜色改变
        /// <summary>
        /// 颜色改变
        /// </summary>
        /// <param name="dtPhyMax"></param>
        /// <param name="ultraTabControl"></param>
        private void ChangeColor(DataTable dtPhyMax, Infragistics.Win.UltraWinTabControl.UltraTabControl ultraTabControl)
        {
            if (dtPhyMax == null || dtPhyMax.Rows.Count == 0) return;
            int i = -1;
            if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')").Rows.Count > 0)
            {
                i = i == -1 ? i = 0 : i;
                ultraTabControl.Tabs[0].Appearance.BackColor = Color.GreenYellow;
            }
            if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0020', 'R0048')") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0020', 'R0048')").Rows.Count > 0)
            {
                i = i == -1 ? i = 1 : i;
                ultraTabControl.Tabs[1].Appearance.BackColor = Color.GreenYellow;
            }
            if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN = 'R0046'") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN = 'R0046'").Rows.Count > 0)
            {
                i = i == -1 ? i = 2 : i;
                ultraTabControl.Tabs[2].Appearance.BackColor = Color.GreenYellow;//
            }
            if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')").Rows.Count > 0)
            {
                i = i == -1 ? i = 3 : i;
                ultraTabControl.Tabs[3].Appearance.BackColor = Color.GreenYellow;//其他
            }
            //if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0010')") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0010')").Rows.Count > 0)
            //{
            //    i = i == -1 ? i = 4 : i;
            //    ultraTabControl.Tabs[4].Appearance.BackColor = Color.GreenYellow;//工艺
            //}
            //if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')").Rows.Count > 0)
            //{
            //    i = i == -1 ? i = 5 : i;
            //    ultraTabControl.Tabs[5].Appearance.BackColor = Color.GreenYellow;//其他
            //}
            ultraTabControl.SelectedTab = i == -1 ? ultraTabControl.Tabs[0] : ultraTabControl.Tabs[i];
        }

        //赋值
        /// <summary>
        /// 赋值
        /// </summary>
        /// <param name="ultraTabControl"></param>
        private void ClearPhyDetailItems(Infragistics.Win.UltraWinTabControl.UltraTabControl ultraTabControl)
        {
            //ultraTabControl.SelectedTab = ultraTabControl.Tabs[0];
            ultraTabControl.Tabs[0].Appearance.BackColor = Control.DefaultBackColor;
            ultraTabControl.Tabs[1].Appearance.BackColor = Control.DefaultBackColor;
            ultraTabControl.Tabs[2].Appearance.BackColor = Control.DefaultBackColor;
            ultraTabControl.Tabs[3].Appearance.BackColor = Control.DefaultBackColor;
            //ultraTabControl.Tabs[4].Appearance.BackColor = Control.DefaultBackColor;
            //ultraTabControl.Tabs[5].Appearance.BackColor = Control.DefaultBackColor;

            if (ultraTabControl == ultraTabControl2)
            {
                publicUltraGridDataCJBase1_1.DataTable.Rows.Clear();
                publicUltraGridDataCJBase2_1.DataTable.Rows.Clear();
                publicUltraGridDataCJBase3_1.DataTable.Rows.Clear();
                publicUltraGridDataCJBase4_1.DataTable.Rows.Clear();
                //publicUltraGridDataCJBase5_1.DataTable.Rows.Clear();
                //publicUltraGridDataCJBase6_1.DataTable.Rows.Clear();

                publicUltraGridDataCJBase1_2.DataTable.Rows.Clear();
                publicUltraGridDataCJBase2_2.DataTable.Rows.Clear();
                publicUltraGridDataCJBase3_2.DataTable.Rows.Clear();
                publicUltraGridDataCJBase4_2.DataTable.Rows.Clear();
                //publicUltraGridDataCJBase5_2.DataTable.Rows.Clear();
                //publicUltraGridDataCJBase6_2.DataTable.Rows.Clear();

                splitContainer1.Panel1Collapsed = true;
                splitContainer2.Panel1Collapsed = true;
                splitContainer3.Panel1Collapsed = true;
                splitContainer4.Panel1Collapsed = true;
                //splitContainer5.Panel1Collapsed = true;
                //splitContainer6.Panel1Collapsed = true;
            }
            else if (ultraTabControl == ultraTabControl3)
            {
                publicUltraGridDataCJBase7_1.DataTable.Rows.Clear();
                publicUltraGridDataCJBase8_1.DataTable.Rows.Clear();
                publicUltraGridDataCJBase9_1.DataTable.Rows.Clear();
                publicUltraGridDataCJBase10_1.DataTable.Rows.Clear();
                //publicUltraGridDataCJBase11_1.DataTable.Rows.Clear();
                //publicUltraGridDataCJBase12_1.DataTable.Rows.Clear();

                publicUltraGridDataCJBase7_2.DataTable.Rows.Clear();
                publicUltraGridDataCJBase8_2.DataTable.Rows.Clear();
                publicUltraGridDataCJBase9_2.DataTable.Rows.Clear();
                publicUltraGridDataCJBase10_2.DataTable.Rows.Clear();
                //publicUltraGridDataCJBase11_2.DataTable.Rows.Clear();
                //publicUltraGridDataCJBase12_2.DataTable.Rows.Clear();

                splitContainer7.Panel1Collapsed = true;
                splitContainer8.Panel1Collapsed = true;
                splitContainer9.Panel1Collapsed = true;
                splitContainer10.Panel1Collapsed = true;
                //splitContainer11.Panel1Collapsed = true;
                //splitContainer12.Panel1Collapsed = true;
            }
            else if (ultraTabControl == ultraTabControl4)
            {
                publicUltraGridDataCJBase13_1.DataTable.Rows.Clear();
                publicUltraGridDataCJBase14_1.DataTable.Rows.Clear();
                publicUltraGridDataCJBase15_1.DataTable.Rows.Clear();
                publicUltraGridDataCJBase16_1.DataTable.Rows.Clear();
                //publicUltraGridDataCJBase17_1.DataTable.Rows.Clear();
                //publicUltraGridDataCJBase18_1.DataTable.Rows.Clear();

                publicUltraGridDataCJBase13_2.DataTable.Rows.Clear();
                publicUltraGridDataCJBase14_2.DataTable.Rows.Clear();
                publicUltraGridDataCJBase15_2.DataTable.Rows.Clear();
                publicUltraGridDataCJBase16_2.DataTable.Rows.Clear();
                //publicUltraGridDataCJBase17_2.DataTable.Rows.Clear();
                //publicUltraGridDataCJBase18_2.DataTable.Rows.Clear();

                splitContainer13.Panel1Collapsed = true;
                splitContainer14.Panel1Collapsed = true;
                splitContainer15.Panel1Collapsed = true;
                splitContainer16.Panel1Collapsed = true;
                //splitContainer17.Panel1Collapsed = true;
                //splitContainer18.Panel1Collapsed = true;
            }
            else if (ultraTabControl == ultraTabControl5)
            {
                publicUltraGridDataCJBase19_1.DataTable.Rows.Clear();
                publicUltraGridDataCJBase20_1.DataTable.Rows.Clear();
                publicUltraGridDataCJBase21_1.DataTable.Rows.Clear();
                publicUltraGridDataCJBase22_1.DataTable.Rows.Clear();
                //publicUltraGridDataCJBase23_1.DataTable.Rows.Clear();
                //publicUltraGridDataCJBase24_1.DataTable.Rows.Clear();

                publicUltraGridDataCJBase19_2.DataTable.Rows.Clear();
                publicUltraGridDataCJBase20_2.DataTable.Rows.Clear();
                publicUltraGridDataCJBase21_2.DataTable.Rows.Clear();
                publicUltraGridDataCJBase22_2.DataTable.Rows.Clear();
                //publicUltraGridDataCJBase23_2.DataTable.Rows.Clear();
                //publicUltraGridDataCJBase24_2.DataTable.Rows.Clear();

                splitContainer19.Panel1Collapsed = true;
                splitContainer20.Panel1Collapsed = true;
                splitContainer21.Panel1Collapsed = true;
                splitContainer22.Panel1Collapsed = true;
                //splitContainer23.Panel1Collapsed = true;
                //splitContainer24.Panel1Collapsed = true;
            }
        }

        #endregion

        #region 录入区域

        //查询检验委托基本信息
        /// <summary>
        /// 查询检验委托基本信息
        /// </summary>
        /// <param name="publicUltraGridBase"></param>
        /// <param name="strFlag"></param>
        private void QueryCheckConsignBaseDetail_Distinct(PublicUltraGridBase publicUltraGridBase, string strFlag)
        {
            try
            {

                //各试验室各检验项目设置权限
                publicUltraGridBase.QueryCheckConsignBaseDetail_Distinct("pipe.PublicPipeBase", pipeQueryBase1.GetQueryInfo(strFlag), this.ob, arrId, plineCodes);
                if (publicUltraGridBase.Ug.Rows.Count == 0)
                {
                    if (publicUltraGridBase == publicUltraGridBase1)
                    {
                        ClearPhyDetailItems(ultraTabControl2);
                    }
                    else if (publicUltraGridBase == publicUltraGridBase2)
                    {
                        ClearPhyDetailItems(ultraTabControl3);
                    }
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        //查询试验方法项目信息
        /// <summary>
        /// 查询试验方法项目信息
        /// </summary>
        /// <param name="publicUltraGridDataCJBase"></param>
        /// <param name="dtHide"></param>
        /// <param name="splitContainer"></param>
        /// <param name="dt"></param>
        private void QueryCheckMethodPhyConfigItems(PublicUltraGridDataCJBase publicUltraGridDataCJBase, DataTable dtHide, SplitContainer splitContainer, DataTable dt)
        {
            try
            {
                PublicPipeAndOutdec.ChangeSplit(splitContainer, dt);

                publicUltraGridDataCJBase.HideNullColumn(dtHide, publicUltraGridDataCJBase.Ug);

                publicUltraGridDataCJBase.QueryCheckMethodPhyConfigItems(dt);

                //PublicPipeAndOutdec.RefreshAndAutoSizeColumns(publicUltraGridDataCJBase.Ug, new string[] { "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15" }, false);//刷新Grid
            }
            catch (Exception e)
            {
                MessageUtil.ShowError(e.Message);
            }
        }

        #endregion

        #region 未录入

        void pipeUltraGridBase1_PublicUltraGridBaseActive(object sender, EventArgs e)
        {
            try
            {
                pipeShowBase1.ShowBaseInfo(publicUltraGridBase1.Ur);
                //赋值给全局变量
                UltraGridRow ur = publicUltraGridBase1.Ur;
                ArrayList arrayList = new ArrayList();
                arrayList.Add("2");
                arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
                arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
                arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
                arrayList.Add(ur.Cells["CHECK_NO"].Text.Trim());

                if (arrId != null && arrId.Length > 0)
                {
                    ClearPhyDetailItems(ultraTabControl2);
                    //查询检验项目明细
                    DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckConsignDetailPhyDetail", new Object[] { arrayList, arrId }, ob);
                    if (dt == null || dt.Rows.Count == 0)
                    {
                        m_dtPhyMax = null;
                        m_dtPhyItems = null;
                        return;
                    }
                    m_dtPhyMax = dt.Copy();

                    DataTable dtItems = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckMethodPhyConfigItems",
                        new Object[] { arrayList, arrId }, ob);
                    if (dtItems == null || dtItems.Rows.Count == 0)
                    {
                        m_dtPhyItems = null;
                        //return;
                    }
                    else
                    {
                        m_dtPhyItems = dtItems.Copy();
                    }

                    ChangeColor(m_dtPhyMax, ultraTabControl2);
                    AddPhyDetailItems();

                    //设备信息
                    getugr();
                    publicDataCJBase1.ClearAll();
                    if (CHECK_NO != "")
                    { publicDataCJBase1.UpdateDateForPramaPipe(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
                }

            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
            }
        }

        private void ultraTabControl2_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            //if (m_dtPhyMax == null || m_dtPhyMax.Rows.Count == 0) return;
            if (toolMenu == null) return;
            AddPhyDetailItems();

            //设备信息
            getugr();
            publicDataCJBase1.ClearAll();
            if (CHECK_NO != "")
            { publicDataCJBase1.UpdateDateForPramaPipe(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
        }

        //赋值
        /// <summary>
        /// 赋值
        /// </summary>
        private void AddPhyDetailItems()
        {

            if (m_dtPhyMax == null || m_dtPhyMax.Rows.Count == 0) return;
            //R0019 抗挤毁强度,R0020 抗内压强度，R0021 连接强度,R0046 上卸扣试验,R0047 爆破，R0048 复合力试验,R0049 摩擦磨损试验
            if (ultraTabControl2.SelectedTab.Index == 0)//压溃(抗挤毁强度),爆破,整管拉伸、滑脱（连接强度）
            {
                publicUltraGridDataCJBase1_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"));
                publicUltraGridDataCJBase1_2.DataTable.AcceptChanges();

                QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase1_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"), splitContainer1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"));
            }
            else if (ultraTabControl2.SelectedTab.Index == 1)//复合力，密封、静水压（抗内压强度）
            {
                publicUltraGridDataCJBase2_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0020', 'R0048')"));
                publicUltraGridDataCJBase2_2.DataTable.AcceptChanges();

                QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase2_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0020', 'R0048')"), splitContainer2, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN IN ('R0020', 'R0048')"));
            }
            else if (ultraTabControl2.SelectedTab.Index == 2)//上卸扣试验 R0046
            {
                publicUltraGridDataCJBase3_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN = 'R0046'"));
                publicUltraGridDataCJBase3_2.DataTable.AcceptChanges();

                QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase3_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN = 'R0046'"), splitContainer3, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN = 'R0046'"));
            }
            else if (ultraTabControl2.SelectedTab.Index == 3)//其他
            {
                publicUltraGridDataCJBase4_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"));
                publicUltraGridDataCJBase4_2.DataTable.AcceptChanges();

                QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase4_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"), splitContainer4, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"));
            }
            //else if (ultraTabControl2.SelectedTab.Index == 4)//
            //{
            //    publicUltraGridDataCJBase5_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0010')"));//
            //    publicUltraGridDataCJBase5_2.DataTable.AcceptChanges();

            //    QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase5_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0010')"), splitContainer5, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN IN ('R0010')"));
            //}
            //else if (ultraTabControl2.SelectedTab.Index == 5)//其他
            //{
            //    publicUltraGridDataCJBase6_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
            //    publicUltraGridDataCJBase6_2.DataTable.AcceptChanges();

            //    QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase6_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"), splitContainer6, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
            //}

            tabIndex = ultraTabControl2.SelectedTab.Index;
        }

        //新增检验委托过程结果JHYGG_PHYLX_PROCESS_RESULT，新增之前先删除表里数据
        /// <summary>
        /// 新增检验委托过程结果JHYGG_PHYLX_PROCESS_RESULT，新增之前先删除表里数据
        /// </summary>
        /// <param name="publicUltraGridDataCJBase"></param>
        /// <param name="publicUltraGridDataCJBaseItems"></param>
        private void AddCheckConsignProcessResult(PublicUltraGridDataCJBase publicUltraGridDataCJBase, PublicUltraGridDataCJBase publicUltraGridDataCJBaseItems)
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 0)
                {
                    MessageUtil.ShowWarning("只有在未录入数据页才能进行新增操作！");
                    return;
                }

                if (publicUltraGridBase1.Ur == null || publicUltraGridBase1.Ur.Activated == false)
                {
                    MessageUtil.ShowWarning("请选择需要新增的试样信息！");
                    return;
                }

                if (publicUltraGridDataCJBase.DataTable == null || publicUltraGridDataCJBase.DataTable.Rows.Count == 0)
                {
                    return;
                }

                //bool isNullValue = true;

                publicUltraGridDataCJBase.Ug.UpdateData();
                foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
                {
                    if (dr["VALUE1"].ToString() == "" && dr["VALUE2"].ToString() == "" && dr["VALUE3"].ToString() == "" && dr["VALUE4"].ToString() == "" && dr["VALUE5"].ToString() == "" && dr["VALUE6"].ToString() == "" && dr["VALUE7"].ToString() == "" && dr["VALUE8"].ToString() == "" && dr["VALUE9"].ToString() == "")
                    {
                        MessageUtil.ShowWarning(dr["PHY_NAME"] + "没有录入任何数据不允许新增！");
                        return;
                    }
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否确认新增？") == DialogResult.Yes)
                {
                    string strCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim();
                    string strSAMPLE_NO = publicUltraGridBase1.Ur.Cells["SAMPLE_NO"].Text.Trim();//定位

                    ArrayList alAll = new ArrayList();

                    ArrayList alPhyItems = new ArrayList();//删除信息详细表list
                    ArrayList alDetail = new ArrayList();//检验信息详细表list
                    ArrayList alProcessResult = new ArrayList();//化学信息list

                    ArrayList alPhyItemsParams = new ArrayList();
                    ArrayList alDetailParams = new ArrayList();//检验信息详细表参数list
                    ArrayList alProcessResultParams = new ArrayList();//化学信息参数list

                    string strTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");

                    //获取修改明细表参数JHYGG_CHECKCONSIGN_DETAIL
                    string row = "";
                    foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
                    {
                        if (row.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
                        {
                            row += dr["PHY_CODE_MAX"].ToString() + " ";

                            alDetailParams = new ArrayList();
                            alDetailParams.Add(publicDataCJBase1.StrTemp);//温度
                            alDetailParams.Add(publicDataCJBase1.StrDevice_No);//设备编码
                            alDetailParams.Add(publicDataCJBase1.StrDevice_Name);//设备名称
                            alDetailParams.Add(publicDataCJBase1.StrRemark);//备注

                            alDetailParams.Add(publicDataCJBase1.StrFORMUAL_NO);//实验方法
                            alDetailParams.Add(publicDataCJBase1.StrFORMUAL_NAME);//方法名称

                            //alDetailParams.Add("");
                            //alDetailParams.Add("");
                            //alDetailParams.Add("");
                            //alDetailParams.Add("");
                            alDetailParams.Add(UserInfo.GetUserOrderText());//班次
                            alDetailParams.Add(UserInfo.GetUserGroupText());//班组
                            alDetailParams.Add(UserInfo.GetUserName());//录入人
                            alDetailParams.Add(strTime);//录入时间
                            alDetailParams.Add("3");//录入标志位

                            alDetailParams.Add("2");
                            alDetailParams.Add(dr["PHY_CODE_MAX"].ToString());
                            alDetailParams.Add(strSAMPLE_NO);
                            alDetailParams.Add(strCHECK_NO);

                            alDetail.Add(alDetailParams);
                        }
                    }

                    publicUltraGridDataCJBase.Ug.UpdateData();
                    foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
                    {
                        alProcessResultParams = new ArrayList();

                        alProcessResultParams.Add(dr["VALUE1"].ToString());
                        alProcessResultParams.Add(dr["VALUE2"].ToString());
                        alProcessResultParams.Add(dr["VALUE3"].ToString());
                        alProcessResultParams.Add(dr["VALUE4"].ToString());
                        alProcessResultParams.Add(dr["VALUE5"].ToString());
                        alProcessResultParams.Add(dr["VALUE6"].ToString());
                        alProcessResultParams.Add(dr["VALUE7"].ToString());
                        alProcessResultParams.Add(dr["VALUE8"].ToString());
                        alProcessResultParams.Add(dr["VALUE9"].ToString());
                        alProcessResultParams.Add(dr["VALUE10"].ToString());
                        alProcessResultParams.Add(dr["VALUE11"].ToString());
                        alProcessResultParams.Add(dr["VALUE12"].ToString());
                        alProcessResultParams.Add(dr["VALUE13"].ToString());
                        alProcessResultParams.Add(dr["VALUE14"].ToString());
                        alProcessResultParams.Add(dr["VALUE15"].ToString());
                        alProcessResultParams.Add(dr["REMARK"].ToString());
                        alProcessResultParams.Add(dr["PHYDETAIL_ID"].ToString());

                        alProcessResult.Add(alProcessResultParams);

                        //alDeleteParams = new ArrayList();
                        //alDeleteParams.Add(dr["PHYDETAIL_ID"].ToString());
                        //alDelete.Add(alDeleteParams);
                    }

                    if (publicUltraGridDataCJBaseItems.DataTable != null)
                    {
                        publicUltraGridDataCJBaseItems.Ug.UpdateData();
                        foreach (DataRow dr in publicUltraGridDataCJBaseItems.DataTable.Rows)
                        {
                            alPhyItemsParams = new ArrayList();

                            alPhyItemsParams.Add(strCHECK_NO);
                            alPhyItemsParams.Add(strSAMPLE_NO);
                            alPhyItemsParams.Add(dr["CHECK_METHOD_NO"].ToString());
                            alPhyItemsParams.Add(dr["CHECK_METHOD_NAME"].ToString());
                            alPhyItemsParams.Add(dr["CHECK_METHOD_ITEMNAME"].ToString());

                            alPhyItemsParams.Add(dr["VALUE1"].ToString());
                            alPhyItemsParams.Add(dr["VALUE2"].ToString());
                            alPhyItemsParams.Add(dr["VALUE3"].ToString());
                            alPhyItemsParams.Add(dr["VALUE4"].ToString());
                            alPhyItemsParams.Add(dr["VALUE5"].ToString());
                            alPhyItemsParams.Add(dr["VALUE6"].ToString());
                            alPhyItemsParams.Add(dr["VALUE7"].ToString());
                            alPhyItemsParams.Add(dr["VALUE8"].ToString());
                            alPhyItemsParams.Add(dr["VALUE9"].ToString());
                            alPhyItemsParams.Add(dr["VALUE10"].ToString());
                            alPhyItemsParams.Add(dr["VALUE11"].ToString());
                            alPhyItemsParams.Add(dr["VALUE12"].ToString());
                            alPhyItemsParams.Add(dr["VALUE13"].ToString());
                            alPhyItemsParams.Add(dr["VALUE14"].ToString());
                            alPhyItemsParams.Add(dr["VALUE15"].ToString());
                            alPhyItemsParams.Add("");

                            alPhyItems.Add(alPhyItemsParams);
                        }
                    }


                    alAll.Add(alDetail);
                    alAll.Add(alProcessResult);
                    if (alPhyItems.Count > 0)
                    {
                        alAll.Add(alPhyItems);
                    }

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

                    QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "2");

                    QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "3456");

                    PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase1.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });
                    PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase2.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });

                    MessageUtil.ShowTips("新增成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        private void ultraTabControl2_SelectedTabChanging(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangingEventArgs e)
        {
            int cnt = 0;
            if (tabIndex == 0)
            {
                publicUltraGridDataCJBase1_2.Ug.UpdateData();
                cnt = publicUltraGridDataCJBase1_2.DataTable.Rows.Cast<DataRow>().Where(
                    a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();

            }
            else if (tabIndex == 1)
            {
                publicUltraGridDataCJBase2_2.Ug.UpdateData();
                cnt = publicUltraGridDataCJBase2_2.DataTable.Rows.Cast<DataRow>().Where(
                    a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
            }
            else if (tabIndex == 2)
            {
                publicUltraGridDataCJBase3_2.Ug.UpdateData();
                cnt = publicUltraGridDataCJBase3_2.DataTable.Rows.Cast<DataRow>().Where(
                    a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
            }
            else if (tabIndex == 3)
            {
                publicUltraGridDataCJBase4_2.Ug.UpdateData();
                cnt = publicUltraGridDataCJBase4_2.DataTable.Rows.Cast<DataRow>().Where(
                    a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
            }
            //else if (tabIndex == 4)
            //{
            //    publicUltraGridDataCJBase5_2.Ug.UpdateData();
            //    cnt = publicUltraGridDataCJBase5_2.DataTable.Rows.Cast<DataRow>().Where(
            //        a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
            //}
            //else if (tabIndex == 5)
            //{
            //    publicUltraGridDataCJBase6_2.Ug.UpdateData();
            //    cnt = publicUltraGridDataCJBase6_2.DataTable.Rows.Cast<DataRow>().Where(
            //        a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
            //}
            if (cnt > 0)
            {
                if (MessageUtil.ShowYesNoAndQuestion("数据有变更您确定要放弃吗？") == System.Windows.Forms.DialogResult.No)
                {
                    e.Cancel = true;
                }
            }
        }

        #endregion

        #region 已录入

        private void ultraTabControl3_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            //if (m_dtPhyMax == null || m_dtPhyMax.Rows.Count == 0) return;
            if (toolMenu == null) return;
            AddPhyDetailItems_Log();

            //设备信息
            getugr();
            publicDataCJBase2.ClearAll();
            if (CHECK_NO != "")
            { publicDataCJBase2.UpdateDateForPramaPipe(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
        }

        void pipeUltraGridBase2_PublicUltraGridBaseActive(object sender, EventArgs e)
        {
            try
            {
                pipeShowBase2.ShowBaseInfo(publicUltraGridBase2.Ur);
                //赋值给全局变量
                UltraGridRow ur = publicUltraGridBase2.Ur;
                ArrayList arrayList = new ArrayList();
                arrayList.Add("345");
                arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
                arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
                arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
                arrayList.Add(ur.Cells["CHECK_NO"].Text.Trim());

                if (arrId != null && arrId.Length > 0)
                {
                    ClearPhyDetailItems(ultraTabControl3);
                    //查询检验项目明细
                    DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckConsignDetailPhyDetail", new Object[] { arrayList, arrId }, ob);
                    if (dt == null || dt.Rows.Count == 0)
                    {
                        m_dtPhyMaxAdd = null;
                        m_dtPhyItemsAdd = null;
                        return;
                    }
                    m_dtPhyMaxAdd = dt.Copy();

                    DataTable dtItems = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckMethodResult",
                        new Object[] { arrayList, arrId }, ob);
                    if (dtItems == null || dtItems.Rows.Count == 0)
                    {
                        m_dtPhyItemsAdd = null;
                        //return;
                    }
                    else
                    {
                        m_dtPhyItemsAdd = dtItems.Copy();
                    }

                    ChangeColor(m_dtPhyMaxAdd, ultraTabControl3);
                    AddPhyDetailItems_Log();

                    //设备信息
                    getugr();
                    publicDataCJBase1.ClearAll();
                    if (CHECK_NO != "")
                    { publicDataCJBase1.UpdateDateForPramaPipe(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
                }

            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
            }
        }

        //赋值
        /// <summary>
        /// 赋值
        /// </summary>
        private void AddPhyDetailItems_Log()
        {
            if (m_dtPhyMaxAdd == null || m_dtPhyMaxAdd.Rows.Count == 0) return;
            //R0019 抗挤毁强度，R0047 爆破，复合力R0048
            if (ultraTabControl3.SelectedTab.Index == 0)
            {
                publicUltraGridDataCJBase7_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"));
                publicUltraGridDataCJBase7_2.DataTable.AcceptChanges();

                QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase7_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"), splitContainer7, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"));
            }
            else if (ultraTabControl3.SelectedTab.Index == 1)
            {
                publicUltraGridDataCJBase8_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0020', 'R0048')"));//
                publicUltraGridDataCJBase8_2.DataTable.AcceptChanges();

                QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase8_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0020', 'R0048')"), splitContainer8, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN IN ('R0020', 'R0048')"));
            }
            else if (ultraTabControl3.SelectedTab.Index == 2)
            {
                publicUltraGridDataCJBase9_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN = 'R0046'"));//
                publicUltraGridDataCJBase9_2.DataTable.AcceptChanges();

                QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase9_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN = 'R0046'"), splitContainer9, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN = 'R0046'"));
            }
            else if (ultraTabControl3.SelectedTab.Index == 3)//其他
            {
                publicUltraGridDataCJBase10_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"));//
                publicUltraGridDataCJBase10_2.DataTable.AcceptChanges();

                QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase10_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"), splitContainer10, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"));
            }
            //else if (ultraTabControl3.SelectedTab.Index == 4)//
            //{
            //    publicUltraGridDataCJBase11_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0010')"));//工艺
            //    publicUltraGridDataCJBase11_2.DataTable.AcceptChanges();

            //    QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase11_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0010')"), splitContainer11, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN IN ('R0010')"));
            //}
            //else if (ultraTabControl3.SelectedTab.Index == 5)//其他
            //{
            //    publicUltraGridDataCJBase12_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
            //    publicUltraGridDataCJBase12_2.DataTable.AcceptChanges();

            //    QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase12_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"), splitContainer12, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
            //}
            tabIndex = ultraTabControl3.SelectedTab.Index;
        }

        //修改检验委托过程结果JHYGG_PHYLX_PROCESS_RESULT
        /// <summary>
        /// 修改检验委托过程结果JHYGG_PHYLX_PROCESS_RESULT
        /// </summary>
        /// <param name="publicUltraGridDataCJBase"></param>
        /// <param name="publicUltraGridDataCJBaseItems"></param>
        private void UpdateCheckConsignProcessResult(PublicUltraGridDataCJBase publicUltraGridDataCJBase, PublicUltraGridDataCJBase publicUltraGridDataCJBaseItems)
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowTips("只有在已录入数据页才能进行修改操作！");
                    return;
                }

                if (publicUltraGridBase2.Ur == null || publicUltraGridBase2.Ur.Activated == false)
                {

                    MessageUtil.ShowWarning("请选择需要修改的试样信息！");
                    return;
                }

                if (publicUltraGridDataCJBase.OldDt == null || publicUltraGridDataCJBase.OldDt.Rows.Count == 0 || publicUltraGridDataCJBase.DataTable == null || publicUltraGridDataCJBase.DataTable.Rows.Count == 0)
                {
                    return;
                }

                //if (publicUltraGridBase2.Ur.Cells["FLAG"].Text == "已审核")
                //{
                //    MessageUtil.ShowTips("已审核的数据不允许修改！");
                //    return;
                //}
                if (MessageUtil.ShowYesNoAndQuestion("是否确认修改？") == DialogResult.Yes)
                {
                    string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim();
                    string strSAMPLE_NO = publicUltraGridBase2.Ur.Cells["SAMPLE_NO"].Text.Trim();//定位

                    ArrayList alAll = new ArrayList();

                    ArrayList alProcessResult = new ArrayList();//过程信息list新值
                    ArrayList alProcessResultLog = new ArrayList();//过程信息list原值
                    ArrayList alDeletePhyItems = new ArrayList();
                    ArrayList alPhyItems = new ArrayList();

                    ArrayList alProcessResultParams = new ArrayList();//过程信息参数list新值
                    ArrayList alProcessResultParamsLog = new ArrayList();//过程信息参数list原值
                    ArrayList alDeletePhyItemsParams = new ArrayList();
                    ArrayList alPhyItemsParams = new ArrayList();

                    string strTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
                    //用m_OldDt获取原值
                    foreach (DataRow dr in publicUltraGridDataCJBase.OldDt.Rows)
                    {
                        alProcessResultParamsLog = new ArrayList();

                        alProcessResultParamsLog.Add(dr["PHYDETAIL_ID"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE1"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE2"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE3"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE4"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE5"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE6"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE7"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE8"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE9"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE10"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE11"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE12"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE13"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE14"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE15"].ToString());
                        alProcessResultParamsLog.Add(UserInfo.GetUserName());//操作人
                        alProcessResultParamsLog.Add(strTime);//操作时间
                        alProcessResultParamsLog.Add("0");
                        //alProcessResultParamsLog.Add(txtOPERATE_REMARK.Text.Trim());//操作备注修改

                        alProcessResultLog.Add(alProcessResultParamsLog);//插入到JHYGG_PHYRESULT_LOG数据(过程原值)
                    }

                    string row = "";
                    publicUltraGridDataCJBase.Ug.UpdateData();
                    foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
                    {
                        if (row.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
                        {
                            row += ",'" + dr["PHY_CODE_MAX"].ToString() + "'";
                        }

                        alProcessResultParams = new ArrayList();

                        alProcessResultParams.Add(dr["VALUE1"].ToString());
                        alProcessResultParams.Add(dr["VALUE2"].ToString());
                        alProcessResultParams.Add(dr["VALUE3"].ToString());
                        alProcessResultParams.Add(dr["VALUE4"].ToString());
                        alProcessResultParams.Add(dr["VALUE5"].ToString());
                        alProcessResultParams.Add(dr["VALUE6"].ToString());
                        alProcessResultParams.Add(dr["VALUE7"].ToString());
                        alProcessResultParams.Add(dr["VALUE8"].ToString());
                        alProcessResultParams.Add(dr["VALUE9"].ToString());
                        alProcessResultParams.Add(dr["VALUE10"].ToString());
                        alProcessResultParams.Add(dr["VALUE11"].ToString());
                        alProcessResultParams.Add(dr["VALUE12"].ToString());
                        alProcessResultParams.Add(dr["VALUE13"].ToString());
                        alProcessResultParams.Add(dr["VALUE14"].ToString());
                        alProcessResultParams.Add(dr["VALUE15"].ToString());
                        alProcessResultParams.Add(dr["REMARK"].ToString());
                        //alProcessResultParams.Add(txtREMARK_LOG.Text.Trim());//试验备注
                        alProcessResultParams.Add(dr["PHYDETAIL_ID"].ToString());

                        alProcessResult.Add(alProcessResultParams);//新值
                    }

                    if (publicUltraGridDataCJBaseItems.DataTable != null)
                    {
                        string strMethod = "";
                        publicUltraGridDataCJBaseItems.Ug.UpdateData();
                        foreach (DataRow dr in publicUltraGridDataCJBaseItems.DataTable.Rows)
                        {
                            if (strMethod.IndexOf(dr["CHECK_METHOD_NO"].ToString()) < 0)
                            {
                                strMethod += dr["CHECK_METHOD_NO"].ToString() + " ";
                                alDeletePhyItemsParams = new ArrayList();

                                alDeletePhyItemsParams.Add(dr["CHECK_METHOD_NO"].ToString());
                                alDeletePhyItemsParams.Add(strSAMPLE_NO);
                                alDeletePhyItemsParams.Add(strCHECK_NO);

                                alDeletePhyItems.Add(alDeletePhyItemsParams);
                            }

                            alPhyItemsParams = new ArrayList();

                            alPhyItemsParams.Add(strCHECK_NO);
                            alPhyItemsParams.Add(strSAMPLE_NO);
                            alPhyItemsParams.Add(dr["CHECK_METHOD_NO"].ToString());
                            alPhyItemsParams.Add(dr["CHECK_METHOD_NAME"].ToString());
                            alPhyItemsParams.Add(dr["CHECK_METHOD_ITEMNAME"].ToString());

                            alPhyItemsParams.Add(dr["VALUE1"].ToString());
                            alPhyItemsParams.Add(dr["VALUE2"].ToString());
                            alPhyItemsParams.Add(dr["VALUE3"].ToString());
                            alPhyItemsParams.Add(dr["VALUE4"].ToString());
                            alPhyItemsParams.Add(dr["VALUE5"].ToString());
                            alPhyItemsParams.Add(dr["VALUE6"].ToString());
                            alPhyItemsParams.Add(dr["VALUE7"].ToString());
                            alPhyItemsParams.Add(dr["VALUE8"].ToString());
                            alPhyItemsParams.Add(dr["VALUE9"].ToString());
                            alPhyItemsParams.Add(dr["VALUE10"].ToString());
                            alPhyItemsParams.Add(dr["VALUE11"].ToString());
                            alPhyItemsParams.Add(dr["VALUE12"].ToString());
                            alPhyItemsParams.Add(dr["VALUE13"].ToString());
                            alPhyItemsParams.Add(dr["VALUE14"].ToString());
                            alPhyItemsParams.Add(dr["VALUE15"].ToString());
                            alPhyItemsParams.Add("");

                            alPhyItems.Add(alPhyItemsParams);
                        }
                    }

                    alAll.Add(alProcessResultLog);//原值
                    alAll.Add(alProcessResult);//新值
                    if (alDeletePhyItems.Count > 0)
                    {
                        alAll.Add(alDeletePhyItems);
                    }
                    if (alPhyItems.Count > 0)
                    {
                        alAll.Add(alPhyItems);
                    }

                    row = row.Remove(0, 1);
                    ArrayList al = new ArrayList();
                    al.Add(strCHECK_NO);
                    al.Add(strSAMPLE_NO);
                    al.Add(row);

                    PublicServer.SetData("com.steering.lims.data.pipe.FrmDataCJBase.UpdateCheckConsignProcessResult",
    new Object[] { al, alAll }, this.ob);

                    QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "3456");
                    //QueryCheckConsignBaseDetail_Distinct("2");

                    PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase2.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });

                    MessageUtil.ShowTips("修改成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        //删除检验委托过程结果JHYGG_PHYLX_PROCESS_RESULT
        /// <summary>
        /// 删除检验委托过程结果JHYGG_PHYLX_PROCESS_RESULT
        /// </summary>
        /// <param name="publicUltraGridDataCJBase"></param>
        /// <param name="publicUltraGridDataCJBaseItems"></param>
        private void DeleteCheckConsignProcessResult(PublicUltraGridDataCJBase publicUltraGridDataCJBase, PublicUltraGridDataCJBase publicUltraGridDataCJBaseItems)
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowTips("只有在已录入数据页才能进行删除操作！");
                    return;
                }

                if (publicUltraGridBase2.Ur == null || publicUltraGridBase2.Ur.Activated == false)
                {

                    MessageUtil.ShowWarning("请选择需要删除的试样信息！");
                    return;
                }

                if (publicUltraGridDataCJBase.OldDt == null || publicUltraGridDataCJBase.OldDt.Rows.Count == 0 || publicUltraGridDataCJBase.DataTable == null || publicUltraGridDataCJBase.DataTable.Rows.Count == 0)
                {
                    return;
                }

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

                    ArrayList alAll = new ArrayList();

                    ArrayList alDetail = new ArrayList();
                    ArrayList alProcessResult = new ArrayList();//过程信息list新值
                    ArrayList alProcessResultLog = new ArrayList();//过程信息list原值
                    ArrayList alPhyItems = new ArrayList();

                    ArrayList alDetailParams = new ArrayList();
                    ArrayList alProcessResultParams = new ArrayList();//过程信息参数list新值
                    ArrayList alProcessResultParamsLog = new ArrayList();//过程信息参数list原值
                    ArrayList alPhyItemsParams = new ArrayList();

                    string strTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
                    foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
                    {
                        alDetailParams = new ArrayList();
                        alDetailParams.Add("");
                        alDetailParams.Add("");
                        alDetailParams.Add("");
                        alDetailParams.Add("");
                        alDetailParams.Add("");
                        alDetailParams.Add("");

                        alDetailParams.Add("");//班次
                        alDetailParams.Add("");//班组
                        alDetailParams.Add("");//录入人
                        alDetailParams.Add("");//录入时间
                        alDetailParams.Add("2");//删除之后回到待录入状态

                        alDetailParams.Add("3");
                        alDetailParams.Add(dr["PHY_CODE_MAX"].ToString());
                        alDetailParams.Add(strSAMPLE_NO);
                        alDetailParams.Add(strCHECK_NO);

                        alDetail.Add(alDetailParams);
                    }

                    //用m_OldDt获取原值
                    foreach (DataRow dr in publicUltraGridDataCJBase.OldDt.Rows)
                    {
                        alProcessResultParamsLog = new ArrayList();

                        
                        alProcessResultParamsLog.Add(dr["VALUE1"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE2"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE3"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE4"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE5"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE6"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE7"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE8"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE9"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE10"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE11"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE12"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE13"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE14"].ToString());
                        alProcessResultParamsLog.Add(dr["VALUE15"].ToString());
                        alProcessResultParamsLog.Add(UserInfo.GetUserName());//操作人
                        alProcessResultParamsLog.Add(strTime);//操作时间
                        alProcessResultParamsLog.Add("1");
                        alProcessResultParamsLog.Add(dr["PHYDETAIL_ID"].ToString());
                        //alProcessResultParamsLog.Add(txtOPERATE_REMARK.Text.Trim());//操作备注修改

                        alProcessResultLog.Add(alProcessResultParamsLog);//插入到JHYGG_PHYRESULT_LOG数据(过程原值)
                    }

                    string row = "";
                    publicUltraGridDataCJBase.Ug.UpdateData();//修改原值
                    foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
                    {
                        if (row.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
                        {
                            row += ",'" + dr["PHY_CODE_MAX"].ToString() + "'";
                        }

                        alProcessResultParams = new ArrayList();

                        alProcessResultParams.Add("");
                        alProcessResultParams.Add("");
                        alProcessResultParams.Add("");
                        alProcessResultParams.Add("");
                        alProcessResultParams.Add("");
                        alProcessResultParams.Add("");
                        alProcessResultParams.Add("");
                        alProcessResultParams.Add("");
                        alProcessResultParams.Add("");
                        alProcessResultParams.Add("");
                        alProcessResultParams.Add("");
                        alProcessResultParams.Add("");
                        alProcessResultParams.Add("");
                        alProcessResultParams.Add("");
                        alProcessResultParams.Add("");
                        alProcessResultParams.Add("");
                        //alProcessResultParams.Add(txtREMARK_LOG.Text.Trim());//试验备注
                        alProcessResultParams.Add(dr["PHYDETAIL_ID"].ToString());

                        alProcessResult.Add(alProcessResultParams);//新值
                    }

                    if (publicUltraGridDataCJBaseItems.DataTable != null)
                    {
                        string strMethod = "";
                        publicUltraGridDataCJBaseItems.Ug.UpdateData();
                        foreach (DataRow dr in publicUltraGridDataCJBaseItems.DataTable.Rows)
                        {
                            if (strMethod.IndexOf(dr["CHECK_METHOD_NO"].ToString()) < 0)
                            {
                                strMethod += dr["CHECK_METHOD_NO"].ToString() + " ";
                                alPhyItemsParams = new ArrayList();

                                alPhyItemsParams.Add(dr["CHECK_METHOD_NO"].ToString());
                                alPhyItemsParams.Add(strSAMPLE_NO);
                                alPhyItemsParams.Add(strCHECK_NO);

                                alPhyItems.Add(alPhyItemsParams);
                            }
                        }
                    }

                    alAll.Add(alDetail);
                    alAll.Add(alProcessResultLog);//原值
                    alAll.Add(alProcessResult);
                    if (alPhyItems.Count > 0)
                    {
                        alAll.Add(alPhyItems);
                    }
                    row = row.Remove(0, 1);
                    ArrayList al = new ArrayList();
                    al.Add(strCHECK_NO);
                    al.Add(strSAMPLE_NO);
                    al.Add(row);

                    PublicServer.SetData("com.steering.lims.data.pipe.FrmDataCJBase.DeleteCheckConsignProcessResult",
new Object[] { al, alAll }, this.ob);

                    QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "3456");
                    QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "2");

                    PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase2.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });
                    PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase1.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });

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

        private void ultraTabControl3_SelectedTabChanging(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangingEventArgs e)
        {
            int cnt = 0;
            if (tabIndex == 0)
            {
                publicUltraGridDataCJBase7_2.Ug.UpdateData();
                cnt = publicUltraGridDataCJBase7_2.DataTable.Rows.Cast<DataRow>().Where(
                    a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();

            }
            else if (tabIndex == 1)
            {
                publicUltraGridDataCJBase8_2.Ug.UpdateData();
                cnt = publicUltraGridDataCJBase8_2.DataTable.Rows.Cast<DataRow>().Where(
                    a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
            }
            else if (tabIndex == 2)
            {
                publicUltraGridDataCJBase9_2.Ug.UpdateData();
                cnt = publicUltraGridDataCJBase9_2.DataTable.Rows.Cast<DataRow>().Where(
                    a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
            }
            else if (tabIndex == 3)
            {
                publicUltraGridDataCJBase10_2.Ug.UpdateData();
                cnt = publicUltraGridDataCJBase10_2.DataTable.Rows.Cast<DataRow>().Where(
                    a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
            }
            //else if (tabIndex == 4)
            //{
            //    publicUltraGridDataCJBase11_2.Ug.UpdateData();
            //    cnt = publicUltraGridDataCJBase11_2.DataTable.Rows.Cast<DataRow>().Where(
            //        a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
            //}
            //else if (tabIndex == 5)
            //{
            //    publicUltraGridDataCJBase12_2.Ug.UpdateData();
            //    cnt = publicUltraGridDataCJBase12_2.DataTable.Rows.Cast<DataRow>().Where(
            //        a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
            //}
            if (cnt > 0)
            {
                if (MessageUtil.ShowYesNoAndQuestion("数据有变更您确定要放弃吗？") == System.Windows.Forms.DialogResult.No)
                {
                    e.Cancel = true;
                }
            }
        }

        #endregion

        #region 审核区域
        //查询检验委托基本信息
        /// <summary>
        /// 查询检验委托基本信息
        /// </summary>
        /// <param name="ultraGrid"></param>
        /// <param name="strFlag"></param>
        private void QueryCheckConsignBaseDetail_Distinct(UltraGrid ultraGrid, string strFlag)
        {
            try
            {
                if (ultraGrid == ultraGrid1)
                {
                    dataTable2.Rows.Clear();
                    dataTable1.Rows.Clear();
                }
                else
                {
                    dataTable4.Rows.Clear();
                    dataTable3.Rows.Clear();
                }
                //各试验室各检验项目设置权限
                DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckConsignBase_Distinct",
            arrId == null ? new Object[] { pipeQueryBase1.GetQueryInfo(strFlag) } : new Object[] { pipeQueryBase1.GetQueryInfo(strFlag), arrId, plineCodes }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    ClearPhyDetailItems(ultraGrid == ultraGrid1 ? ultraTabControl4 : ultraTabControl5);
                    return;
                }
                GridHelper.CopyDataToDatatable(dt, ultraGrid == ultraGrid1 ? dataTable1 : dataTable3, true);

                DataTable dtSample = PublicServer.GetData("com.steering.lims.data.pipe.PublicPipeBase.QueryCheckConsignBaseDetail_Distinct",
arrId == null ? new Object[] { pipeQueryBase1.GetQueryInfo(strFlag) } : new Object[] { pipeQueryBase1.GetQueryInfo(strFlag), arrId, plineCodes }, ob);

                if (dtSample == null || dtSample.Rows.Count == 0)
                {
                    return;
                }
                else
                {
                    GridHelper.CopyDataToDatatable(dtSample, ultraGrid == ultraGrid1 ? dataTable2 : dataTable4, true);
                }

                GridHelper.RefreshAndAutoSize(ultraGrid);

            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }
        #endregion

        #region 未审核

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            try
            {

                //if (ultraGrid1.ActiveRow.HasChild())
                //{
                //    try
                //    {
                //        ultraGrid1.ActiveRow.GetChild(Infragistics.Win.UltraWinGrid.ChildRow.First).Activate();
                //    }
                //    catch (Exception ex)
                //    {

                //    }
                //}

                if (ultraGrid1.ActiveRow.HasParent())
                {

                    pipeShowBase3.ShowBaseInfo(ultraGrid1.ActiveRow.ParentRow);
                    //赋值给全局变量
                    UltraGridRow ur = ultraGrid1.ActiveRow;
                    ArrayList arrayList = new ArrayList();
                    arrayList.Add("3");
                    arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
                    arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
                    arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
                    arrayList.Add(ur.Cells["CHECK_NO"].Text.Trim());

                    if (arrId != null && arrId.Length > 0)
                    {
                        ClearPhyDetailItems(ultraTabControl4);
                        //查询检验项目明细
                        DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckConsignDetailPhyDetail", new Object[] { arrayList, arrId }, ob);
                        if (dt == null || dt.Rows.Count == 0)
                        {
                            m_dtPhyMaxAudit = null;
                            m_dtPhyItemsAudit = null;
                            return;
                        }
                        m_dtPhyMaxAudit = dt.Copy();

                        DataTable dtItems = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckMethodPhyConfigItems",
                            new Object[] { arrayList, arrId }, ob);
                        if (dtItems == null || dtItems.Rows.Count == 0)
                        {
                            m_dtPhyItemsAudit = null;
                            //return;
                        }
                        else
                        {
                            m_dtPhyItemsAudit = dtItems.Copy();
                        }

                        ChangeColor(m_dtPhyMaxAudit, ultraTabControl4);
                        AddPhyDetailItemsAudit();

                        //设备信息
                        getugr();
                        publicDataCJBase3.ClearAll();
                        if (CHECK_NO != "")
                        { publicDataCJBase3.UpdateDateForPramaPipe(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }

                    }
                }
                else
                {
                    ultraGrid1.ActiveRow.Expanded = true;
                    //ultraGrid1.ActiveRow.ChildBands[0].Rows[0].Activated = true;
                }
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
            }
        }

        private void AddPhyDetailItemsAudit()
        {

            if (m_dtPhyMaxAudit == null || m_dtPhyMaxAudit.Rows.Count == 0) return;
            //R0019 抗挤毁强度，R0047 爆破，复合力R0048
            if (ultraTabControl4.SelectedTab.Index == 0)//压溃
            {
                publicUltraGridDataCJBase13_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"));//
                //publicUltraGridDataCJBase13_2.DataTable.AcceptChanges();

                QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase13_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"), splitContainer13, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"));
            }
            else if (ultraTabControl4.SelectedTab.Index == 1)
            {
                publicUltraGridDataCJBase14_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0020', 'R0048')"));//
                //publicUltraGridDataCJBase14_2.DataTable.AcceptChanges();

                QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase14_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0020', 'R0048')"), splitContainer14, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN IN ('R0020', 'R0048')"));
            }
            else if (ultraTabControl4.SelectedTab.Index == 2)
            {
                publicUltraGridDataCJBase15_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN = 'R0046'"));//
                //publicUltraGridDataCJBase15_2.DataTable.AcceptChanges();

                QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase15_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN = 'R0046'"), splitContainer15, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN = 'R0046'"));
            }
            else if (ultraTabControl4.SelectedTab.Index == 3)//
            {
                publicUltraGridDataCJBase16_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"));//
                //publicUltraGridDataCJBase16_2.DataTable.AcceptChanges();

                QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase16_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"), splitContainer16, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"));
            }
            //else if (ultraTabControl4.SelectedTab.Index == 4)//
            //{
            //    publicUltraGridDataCJBase17_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0010')"));//工艺
            //    //publicUltraGridDataCJBase17_2.DataTable.AcceptChanges();

            //    QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase17_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0010')"), splitContainer17, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN IN ('R0010')"));
            //}
            //else if (ultraTabControl4.SelectedTab.Index == 5)//
            //{
            //    publicUltraGridDataCJBase18_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
            //    //publicUltraGridDataCJBase18_2.DataTable.AcceptChanges();

            //    QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase18_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"), splitContainer18, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
            //}

            //tabIndex = ultraTabControl4.SelectedTab.Index;
        }

        private void ultraTabControl4_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            //if (m_dtPhyMax == null || m_dtPhyMax.Rows.Count == 0) return;
            if (toolMenu == null) return;
            AddPhyDetailItemsAudit();

            //设备信息
            getugr();
            publicDataCJBase3.ClearAll();
            if (CHECK_NO != "")
            { publicDataCJBase3.UpdateDateForPramaPipe(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
        }

        private void AuditCheckConsignDetail()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 2)
                {
                    MessageUtil.ShowWarning("只有在未审核数据页才能进行审核操作！");
                    return;
                }

                if (ultraGrid1.ActiveRow == null || ultraGrid1.ActiveRow.Activated == false)
                {
                    MessageUtil.ShowWarning("请选择需要审核的检验信息！");
                    return;
                }

                if (dataTable1 == null || dataTable1.Rows.Count == 0)
                {
                    return;
                }

                ultraGrid1.UpdateData();
                DataRow[] arrBase = dataTable2.Select("CHK = 'True'");
                if (arrBase == null || arrBase.Length == 0)
                {
                    MessageUtil.ShowTips("请勾选至少一条检验信息！");
                    return;
                }
                string user = UserInfo.GetUserName();
                string strDate = DateTime.Now.ToString();
                DataTable dy = ServerHelper.GetData("com.steering.lims.data.pipe.FrmLabDateParm.getAuditName", new object[] { CHECK_NO, SAMPLE_NO, PHY_CODE_MAX }, ob);
                if (dy.Rows.Count > 0 && dy != null)
                {
                    if (user.Equals(dy.Rows[0]["CHECK_NAME"].ToString()))
                    {
                        MessageUtil.ShowTips("试验人与审核人是同一人，不能审核!");
                        return;
                    }
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否确认审核？") == DialogResult.Yes)
                {
                    ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息

                    ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息


                    
                    foreach (DataRow row in arrBase)
                    {
                        

                        alBaseParams = new ArrayList();//增加要更新的基础标志位信息
                        alBaseParams.Add("4");
                        alBaseParams.Add(user);//审核人
                        alBaseParams.Add(strDate);//审核时间
                        alBaseParams.Add("");
                        alBaseParams.Add("");//样品备注row["SAMPLE_REMARK"].ToString()
                        alBaseParams.Add("3");
                        alBaseParams.Add("");//PHY_CODE_MAX
                        alBaseParams.Add("");
                        alBaseParams.Add("");
                        alBaseParams.Add(row["SAMPLE_NO"].ToString());
                        alBaseParams.Add(row["CHECK_NO"].ToString());
                        alBaseParams.Add(arrIdStr);
                        alBase.Add(alBaseParams);
                    }

                    PublicServer.SetData("com.steering.lims.data.pipe.FrmDataCJBase.AuditCheckConsignDetail",
                new Object[] { alBase }, this.ob);
                    UpFileAuto();

                    QueryCheckConsignBaseDetail_Distinct(ultraGrid1, "3");

                    //QueryCheckConsignBaseDetail_Distinct(ultraGrid2, "4");

                    //PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
                    //PublicPipeAndOutdec.ActiveOperateRow(ultraGrid2, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
                    
                    MessageUtil.ShowTips("审核成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        private void SingleAuditCheckConsignDetail(PublicUltraGridDataCJBase publicUltraGridDataCJBase)
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 2)
                {
                    MessageUtil.ShowWarning("只有在未审核数据页才能进行单项审核操作！");
                    return;
                }

                if (ultraGrid1.ActiveRow == null || ultraGrid1.ActiveRow.Activated == false)
                {
                    MessageUtil.ShowWarning("请选择需要单项审核的检验信息！");
                    return;
                }

                if (dataTable1 == null || dataTable1.Rows.Count == 0)
                {
                    return;
                }

                ultraGrid1.UpdateData();
                DataRow[] arrBase = dataTable2.Select("CHK = 'True'");
                if (arrBase == null || arrBase.Length == 0)
                {
                    MessageUtil.ShowTips("请勾选至少一条检验信息！");
                    return;
                }

                //                string row = "";
                //foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
                //{
                //    if (row.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
                //    {
                //        row += dr["PHY_CODE_MAX"].ToString() + " ";

                if (MessageUtil.ShowYesNoAndQuestion("是否确认单项审核？") == DialogResult.Yes)
                {
                    ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息

                    ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息

                    string user = UserInfo.GetUserName();
                    string strDate = DateTime.Now.ToString();
                    string rowSample = "";
                    foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
                    {
                        if (rowSample.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
                        {
                            rowSample += dr["PHY_CODE_MAX"].ToString() + " ";
                        }
                    }

                    DataTable dy = ServerHelper.GetData("com.steering.lims.data.pipe.FrmLabDateParm.getAuditName", new object[] { CHECK_NO, SAMPLE_NO, PHY_CODE_MAX }, ob);
                    if (dy.Rows.Count > 0 && dy != null)
                    {
                        if (user.Equals(dy.Rows[0]["CHECK_NAME"].ToString()))
                        {
                            MessageUtil.ShowTips("试验人与审核人是同一人，不能审核!");
                            return;
                        }
                    }

                    foreach (DataRow row in arrBase)
                    {
                        foreach (string strPHY_CODE_MAX in rowSample.Trim().Split(' '))
                        {

                            alBaseParams = new ArrayList();//增加要更新的基础标志位信息
                            alBaseParams.Add("4");
                            alBaseParams.Add(user);//审核人
                            alBaseParams.Add(strDate);//审核时间
                            alBaseParams.Add("");
                            alBaseParams.Add("");//样品备注row["SAMPLE_REMARK"].ToString()
                            alBaseParams.Add("3");
                            alBaseParams.Add(strPHY_CODE_MAX);//PHY_CODE_MAX
                            alBaseParams.Add(strPHY_CODE_MAX);
                            alBaseParams.Add(strPHY_CODE_MAX);
                            alBaseParams.Add(row["SAMPLE_NO"].ToString());
                            alBaseParams.Add(row["CHECK_NO"].ToString());
                            alBaseParams.Add(arrIdStr);
                            alBase.Add(alBaseParams);
                        }
                    }

                    PublicServer.SetData("com.steering.lims.data.pipe.FrmDataCJBase.AuditCheckConsignDetail",
                new Object[] { alBase }, this.ob);
                    UpFileAuto();
                    QueryCheckConsignBaseDetail_Distinct(ultraGrid1, "3");

                    //QueryCheckConsignBaseDetail_Distinct(ultraGrid2, "4");

                    //PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
                    //PublicPipeAndOutdec.ActiveOperateRow(ultraGrid2, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
                    
                    MessageUtil.ShowTips("单项审核成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        private void ultraGrid1_CellChange(object sender, CellEventArgs e)
        {
            if (e.Cell.Row.HasChild() && e.Cell.Column.Key == "CHK")
            {
                ultraGrid1.UpdateData();
                if (e.Cell.Value.ToString() == "True")
                {
                    foreach (UltraGridRow dr in e.Cell.Row.ChildBands[0].Rows)
                    {
                        dr.Cells["CHK"].Value = "True";
                    }
                }
                else
                {
                    foreach (UltraGridRow dr in e.Cell.Row.ChildBands[0].Rows)
                    {
                        dr.Cells["CHK"].Value = "False";
                    }
                }
            }
        }

        #endregion


        #region 已审核

        private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
        {
            try
            {
                if (ultraGrid2.ActiveRow.HasParent())
                {

                    pipeShowBase4.ShowBaseInfo(ultraGrid2.ActiveRow.ParentRow);
                    //赋值给全局变量
                    UltraGridRow ur = ultraGrid2.ActiveRow;
                    ArrayList arrayList = new ArrayList();
                    arrayList.Add("45");
                    arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
                    arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
                    arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
                    arrayList.Add(ur.Cells["CHECK_NO"].Text.Trim());

                    if (arrId != null && arrId.Length > 0)
                    {
                        ClearPhyDetailItems(ultraTabControl5);
                        //查询检验项目明细
                        DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckConsignDetailPhyDetail", new Object[] { arrayList, arrId }, ob);
                        if (dt == null || dt.Rows.Count == 0)
                        {
                            m_dtPhyMaxAuditAdd = null;
                            m_dtPhyItemsAuditAdd = null;
                            return;
                        }
                        m_dtPhyMaxAuditAdd = dt.Copy();

                        DataTable dtItems = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckMethodPhyConfigItems",
                            new Object[] { arrayList, arrId }, ob);
                        if (dtItems == null || dtItems.Rows.Count == 0)
                        {
                            m_dtPhyItemsAuditAdd = null;
                            //return;
                        }
                        else
                        {
                            m_dtPhyItemsAuditAdd = dtItems.Copy();
                        }

                        ChangeColor(m_dtPhyMaxAuditAdd, ultraTabControl5);
                        AddPhyDetailItemsAudit_Log();

                        //设备信息
                        getugr();
                        publicDataCJBase4.ClearAll();
                        if (CHECK_NO != "")
                        { publicDataCJBase4.UpdateDateForPramaPipe(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }

                    }
                }
                else
                {
                    ultraGrid2.ActiveRow.Expanded = true;
                    //ultraGrid2.ActiveRow.ChildBands[0].Rows[0].Activated = true;
                }
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
            }
        }

        private void AddPhyDetailItemsAudit_Log()
        {
            if (m_dtPhyMaxAuditAdd == null || m_dtPhyMaxAuditAdd.Rows.Count == 0) return;
            if (ultraTabControl5.SelectedTab.Index == 0)
            {
                publicUltraGridDataCJBase19_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"));//
                //publicUltraGridDataCJBase19_2.DataTable.AcceptChanges();

                QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase19_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"), splitContainer19, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"));
            }
            else if (ultraTabControl5.SelectedTab.Index == 1)
            {
                publicUltraGridDataCJBase20_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0020', 'R0048')"));//
                //publicUltraGridDataCJBase20_2.DataTable.AcceptChanges();

                QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase20_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0020', 'R0048')"), splitContainer20, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN IN ('R0020', 'R0048')"));
            }
            else if (ultraTabControl5.SelectedTab.Index == 2)
            {
                publicUltraGridDataCJBase21_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN = 'R0046'"));//
                //publicUltraGridDataCJBase21_2.DataTable.AcceptChanges();

                QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase21_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN = 'R0046'"), splitContainer21, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN = 'R0046'"));
            }
            else if (ultraTabControl5.SelectedTab.Index == 3)//
            {
                publicUltraGridDataCJBase22_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"));//
                //publicUltraGridDataCJBase22_2.DataTable.AcceptChanges();

                QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase22_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"), splitContainer22, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"));
            }
            //else if (ultraTabControl5.SelectedTab.Index == 4)//
            //{
            //    publicUltraGridDataCJBase23_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0010')"));//工艺
            //    //publicUltraGridDataCJBase23_2.DataTable.AcceptChanges();

            //    QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase23_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0010')"), splitContainer23, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN IN ('R0010')"));
            //}
            //else if (ultraTabControl5.SelectedTab.Index == 5)//
            //{
            //    publicUltraGridDataCJBase24_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
            //    //publicUltraGridDataCJBase24_2.DataTable.AcceptChanges();

            //    QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase24_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"), splitContainer24, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
            //}
        }

        private void ultraTabControl5_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            //if (m_dtPhyMax == null || m_dtPhyMax.Rows.Count == 0) return;
            if (toolMenu == null) return;
            AddPhyDetailItemsAudit_Log();

            //设备信息
            getugr();
            publicDataCJBase4.ClearAll();
            if (CHECK_NO != "")
            { publicDataCJBase4.UpdateDateForPramaPipe(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }

        }

        private void CancelAuditCheckConsignDetail()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 3)
                {
                    MessageUtil.ShowWarning("只有在已审核数据页才能进行取消审核操作！");
                    return;
                }

                if (ultraGrid2.ActiveRow == null || ultraGrid2.ActiveRow.Activated == false)
                {
                    MessageUtil.ShowWarning("请选择需要取消审核的检验信息！");
                    return;
                }

                if (dataTable3 == null || dataTable3.Rows.Count == 0)
                {
                    return;
                }

                ultraGrid2.UpdateData();
                DataRow[] arrBase = dataTable4.Select("CHK = 'True'");
                if (arrBase == null || arrBase.Length == 0)
                {
                    MessageUtil.ShowTips("请勾选至少一条检验信息！");
                    return;
                }

                //if (MessageUtil.ShowYesNoAndQuestion("是否确认取消审核？") == DialogResult.Yes)
                //{
                WinCancelSampleComfirm pc = new WinCancelSampleComfirm();
                pc.ShowDialog();
                if (pc.DialogResult != DialogResult.OK)
                {
                    return;
                }
                string strRemark = pc.StrRemark;

                string user = UserInfo.GetUserName();
                string strDate = DateTime.Now.ToString();

                strRemark = "取消审核由于" + strRemark + "(" + user + " " + strDate + ")";

                string strCHECK_NO = "";

                ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息

                ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息

                foreach (DataRow row in arrBase)
                {
                    DataTable ds = ServerHelper.GetData("com.steering.lims.data.pipe.FrmDataCJBase.doQueryDetailFlag", new object[] { row["CHECK_NO"].ToString(), row["SAMPLE_NO"].ToString(),  "" }, ob);
                    if (int.Parse(ds.Rows[0][0].ToString()) == 5)
                    {
                        MessageUtil.ShowTips("数据已接收，请联系判定站删除!");
                        return;
                    }

                    alBaseParams = new ArrayList();//增加要更新的基础标志位信息
                    alBaseParams.Add("3");
                    alBaseParams.Add(user);//审核人
                    alBaseParams.Add(strDate);//审核时间
                    alBaseParams.Add(strRemark);
                    alBaseParams.Add(strRemark);//样品备注row["SAMPLE_REMARK"].ToString()
                    alBaseParams.Add("4");
                    alBaseParams.Add("");//PHY_CODE_MAX
                    alBaseParams.Add("");
                    alBaseParams.Add("");
                    alBaseParams.Add(row["SAMPLE_NO"].ToString());
                    alBaseParams.Add(row["CHECK_NO"].ToString());
                    alBaseParams.Add(arrIdStr);
                    if (strCHECK_NO == "")
                    {
                        strCHECK_NO = row["CHECK_NO"].ToString();
                    }
                    alBase.Add(alBaseParams);
                }

                PublicServer.SetData("com.steering.lims.data.pipe.FrmDataCJBase.AuditCheckConsignDetail",
            new Object[] { alBase }, this.ob);

                QueryCheckConsignBaseDetail_Distinct(ultraGrid2, "456");

                QueryCheckConsignBaseDetail_Distinct(ultraGrid1, "3");

                PublicPipeAndOutdec.ActiveOperateRow(ultraGrid2, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
                PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });

                MessageUtil.ShowTips("取消审核成功！");

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

        private void CancelSingleAuditCheckConsignDetail(PublicUltraGridDataCJBase publicUltraGridDataCJBase)
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 3)
                {
                    MessageUtil.ShowWarning("只有在已审核数据页才能进行取消单项审核操作！");
                    return;
                }

                if (ultraGrid2.ActiveRow == null || ultraGrid2.ActiveRow.Activated == false)
                {
                    MessageUtil.ShowWarning("请选择需要取消单项审核的检验信息！");
                    return;
                }

                if (dataTable3 == null || dataTable3.Rows.Count == 0)
                {
                    return;
                }

                ultraGrid2.UpdateData();
                DataRow[] arrBase = dataTable4.Select("CHK = 'True'");
                if (arrBase == null || arrBase.Length == 0)
                {
                    MessageUtil.ShowTips("请勾选至少一条检验信息！");
                    return;
                }

                //if (MessageUtil.ShowYesNoAndQuestion("是否确认单项审核？") == DialogResult.Yes)
                //{
                WinCancelSampleComfirm pc = new WinCancelSampleComfirm();
                pc.ShowDialog();
                if (pc.DialogResult != DialogResult.OK)
                {
                    return;
                }
                string strRemark = pc.StrRemark;

                string user = UserInfo.GetUserName();
                string strDate = DateTime.Now.ToString();

                strRemark = "取消单项审核由于" + strRemark + "(" + user + " " + strDate + ")";

                ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息

                ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息

                string strCHECK_NO = "";
                string rowSample = "";
                foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
                {
                    if (rowSample.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
                    {
                        rowSample += dr["PHY_CODE_MAX"].ToString() + " ";
                    }
                }
                foreach (DataRow row in arrBase)
                {
                    foreach (string strPHY_CODE_MAX in rowSample.Trim().Split(' '))
                    {
                        DataTable ds = ServerHelper.GetData("com.steering.lims.data.pipe.FrmDataCJBase.doQueryDetailFlag", new object[] { row["CHECK_NO"].ToString(), row["SAMPLE_NO"].ToString(),  strPHY_CODE_MAX }, ob);
                        if (int.Parse(ds.Rows[0][0].ToString()) == 5)
                        {
                            MessageUtil.ShowTips("数据已接收，请联系判定站删除!");
                            return;
                        }

                        alBaseParams = new ArrayList();//增加要更新的基础标志位信息
                        alBaseParams.Add("3");
                        alBaseParams.Add(user);//审核人
                        alBaseParams.Add(strDate);//审核时间
                        alBaseParams.Add(strRemark);
                        alBaseParams.Add(strRemark);//样品备注row["SAMPLE_REMARK"].ToString()
                        alBaseParams.Add("4");
                        alBaseParams.Add(strPHY_CODE_MAX);//PHY_CODE_MAX
                        alBaseParams.Add(strPHY_CODE_MAX);
                        alBaseParams.Add(strPHY_CODE_MAX);
                        alBaseParams.Add(row["SAMPLE_NO"].ToString());
                        alBaseParams.Add(row["CHECK_NO"].ToString());
                        alBaseParams.Add(arrIdStr);
                        if (strCHECK_NO == "")
                        {
                            strCHECK_NO = row["CHECK_NO"].ToString();
                        }
                        alBase.Add(alBaseParams);
                    }
                }

                PublicServer.SetData("com.steering.lims.data.pipe.FrmDataCJBase.AuditCheckConsignDetail",
            new Object[] { alBase }, this.ob);

                QueryCheckConsignBaseDetail_Distinct(ultraGrid2, "4");

                QueryCheckConsignBaseDetail_Distinct(ultraGrid1, "3");

                PublicPipeAndOutdec.ActiveOperateRow(ultraGrid2, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });

                PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });

                MessageUtil.ShowTips("取消单项审核成功！");
                //}
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        private void ultraGrid2_CellChange(object sender, CellEventArgs e)
        {
            if (e.Cell.Row.HasChild() && e.Cell.Column.Key == "CHK")
            {
                ultraGrid2.UpdateData();
                if (e.Cell.Value.ToString() == "True")
                {
                    foreach (UltraGridRow dr in e.Cell.Row.ChildBands[0].Rows)
                    {
                        dr.Cells["CHK"].Value = "True";
                    }
                }
                else
                {
                    foreach (UltraGridRow dr in e.Cell.Row.ChildBands[0].Rows)
                    {
                        dr.Cells["CHK"].Value = "False";
                    }
                }
            }
        }

        #endregion

        private void FrmLabEngDataCJAudit_Shown(object sender, EventArgs e)
        {
            if (toolMenu == null) return;

            if (toolMenu.Toolbars[0].Tools.Exists("Query"))
            {
                toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("Add"))
            {
                this.toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("Update"))
            {
                toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
            {
                toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
            {
                toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
            {
                toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
            {
                toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
            {
                toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
            }
        }

        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (toolMenu == null) return;
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Query"))
                {
                    toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                {
                    this.toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Update"))
                {
                    toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
                {
                    toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
                {
                    toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
                {
                    toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
                {
                    toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
                {
                    toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
                }

            }
            else if (ultraTabControl1.SelectedTab.Index == 1)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Query"))
                {
                    toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                {
                    this.toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Update"))
                {
                    toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
                {
                    toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
                {
                    toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
                {
                    toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
                {
                    toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
                {
                    toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
                }
            }
            else if (ultraTabControl1.SelectedTab.Index == 2)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Query"))
                {
                    toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                {
                    this.toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Update"))
                {
                    toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
                {
                    toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
                {
                    toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
                {
                    toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
                {
                    toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
                {
                    toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
                }
            }
            else if (ultraTabControl1.SelectedTab.Index == 3)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Query"))
                {
                    toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                {
                    this.toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Update"))
                {
                    toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
                {
                    toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
                {
                    toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
                {
                    toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
                {
                    toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
                {
                    toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.True;
                }
            }
        }
    }
}