MES_Client/TGMES/Core.StlMes.Client.Lims.Data.PipeAndOutdec/数据管理/设备采集管理/FrmChemCSDataCollect.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 Core.Mes.Client.Comm.Tool;
using Core.Mes.Client.Comm.Control;
using Infragistics.Win.UltraWinGrid;
using Infragistics.Win;
using System.Collections;

namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec
{
    public partial class FrmChemCSDataCollect : FrmBase
    {
        public FrmChemCSDataCollect()
        {
            InitializeComponent();
        }

        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            publicUltraGridBase1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
            publicUltraGridBase2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            publicUltraGridBase3.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            publicUltraGridBase4.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
        }

        private void FrmChemCSDataCollect_Load(object sender, EventArgs e)
        {
            dateBegin.Value = dateEnd.DateTime.AddDays(-6);
            InitColumns();
        }

        private void InitColumns()
        {
            publicUltraGridBase1.PublicUltraGridBaseActive += new EventHandler(publicUltraGridBase1_PublicUltraGridBaseActive);//调用委托事件
            publicUltraGridBase1.InitColumnsPipeBase(new string[] { "CHECK_NO", "SAMPLE_NO" }, true, null);

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

            publicUltraGridBase3.PublicUltraGridBaseActive += new EventHandler(publicUltraGridBase3_PublicUltraGridBaseActive);//调用委托事件
            publicUltraGridBase3.InitColumnsOutdecBase(new string[] { "CHECK_NO", "SAMPLE_NO" }, true, null);

            publicUltraGridBase4.PublicUltraGridBaseActive += new EventHandler(publicUltraGridBase4_PublicUltraGridBaseActive);//调用委托事件
            publicUltraGridBase4.InitColumnsOutdecBase(new string[] { "CHECK_NO", "SAMPLE_NO" }, true, null);
        }

        void publicUltraGridBase1_PublicUltraGridBaseActive(object sender, EventArgs e)
        {
            try
            {
                UltraGridRow ur = publicUltraGridBase1.Ur;

                pipeShowBase1.ShowBaseInfo(ur);

                ArrayList arrayList = new ArrayList();
                arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());//20160523
                arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
                arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
                arrayList.Add(ur.Cells["CHECK_NO"].Text.Trim());

                QueryCheckConsignChemDetail(arrayList, "pipe");
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
            }
        }

        void publicUltraGridBase2_PublicUltraGridBaseActive(object sender, EventArgs e)
        {
            try
            {
                UltraGridRow ur = publicUltraGridBase2.Ur;

                pipeShowBase1.ShowBaseInfo(ur);

                ArrayList arrayList = new ArrayList();
                arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());//20160523
                arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
                arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
                arrayList.Add(ur.Cells["CHECK_NO"].Text.Trim());

                QueryCheckConsignChemDetail(arrayList, "pipe");
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
            }
        }

        void publicUltraGridBase3_PublicUltraGridBaseActive(object sender, EventArgs e)
        {
            try
            {
                UltraGridRow ur = publicUltraGridBase3.Ur;

                outdecShowBase1.ShowBaseInfo(ur);

                ArrayList arrayList = new ArrayList();
                arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());//20160523
                arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
                arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
                arrayList.Add(ur.Cells["CHECK_NO"].Text.Trim());

                QueryCheckConsignChemDetail(arrayList, "outdec");
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
            }
        }

        void publicUltraGridBase4_PublicUltraGridBaseActive(object sender, EventArgs e)
        {
            try
            {
                UltraGridRow ur = publicUltraGridBase4.Ur;

                outdecShowBase1.ShowBaseInfo(ur);

                ArrayList arrayList = new ArrayList();
                arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());//20160523
                arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
                arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
                arrayList.Add(ur.Cells["CHECK_NO"].Text.Trim());

                QueryCheckConsignChemDetail(arrayList, "outdec");
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
            }
        }
        /// <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)
                    {
                        //化学分析室收样状态2，
                        if (ultraTabControl2.SelectedTab.Index == 0)
                        {
                            QueryCheckConsignChemDetail_Cs(publicUltraGridBase1, "pipe", "2", "0");
                        }
                        else if (ultraTabControl2.SelectedTab.Index == 1)
                        {
                            QueryCheckConsignChemDetail_Cs(publicUltraGridBase2, "pipe", "23456", "1");
                        }
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 1)
                    {
                        //化学分析室收样状态2，
                        if (ultraTabControl3.SelectedTab.Index == 0)
                        {
                            QueryCheckConsignChemDetail_Cs(publicUltraGridBase3, "outdec", "2", "0");
                        }
                        else if (ultraTabControl3.SelectedTab.Index == 1)
                        {
                            QueryCheckConsignChemDetail_Cs(publicUltraGridBase4, "outdec", "23456", "1");
                        }
                    }
                    break;
                case "Add":
                    if (ultraTabControl1.SelectedTab.Index == 0)
                    {
                        if (ultraTabControl2.SelectedTab.Index == 0)
                        {
                            AddCheckConsignChemDetail_Cs(publicUltraGridBase1, "pipe");
                        }
                    }
                    else
                    {
                        if (ultraTabControl3.SelectedTab.Index == 0)
                        {
                            AddCheckConsignChemDetail_Cs(publicUltraGridBase3, "outdec");
                        }
                    }
                    break;
                case "Update":
                    if (ultraTabControl1.SelectedTab.Index == 0)
                    {
                        if (ultraTabControl2.SelectedTab.Index == 1)
                        {
                            UpdateCheckConsignChemDetail_Cs(publicUltraGridBase2, "pipe");
                        }
                    }
                    else
                    {
                        if (ultraTabControl3.SelectedTab.Index == 1)
                        {
                            UpdateCheckConsignChemDetail_Cs(publicUltraGridBase4, "outdec");
                        }
                    }
                    break;
                case "Delete":
                    if (ultraTabControl1.SelectedTab.Index == 0)
                    {
                        if (ultraTabControl2.SelectedTab.Index == 1)
                        {
                            DeleteCheckConsignChemDetail_Cs(publicUltraGridBase2, "pipe");
                        }
                    }
                    else
                    {
                        if (ultraTabControl3.SelectedTab.Index == 1)
                        {
                            DeleteCheckConsignChemDetail_Cs(publicUltraGridBase4, "outdec");
                        }
                    }
                    break;
                case "Close":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
                    {
                        this.Close();
                    }
                    break;
            }
        }

        private void QueryCheckConsignChemDetail_Cs(PublicUltraGridBase publicUltraGridBase, string path, string strFlag, string strIS_CJ)
        {
            try
            {
                ArrayList arrayList = GetQueryInfo();
                arrayList.Insert(0, strFlag);
                arrayList.Insert(1, strIS_CJ);
                DataTable dt = PublicServer.GetData("com.steering.lims.data.device.FrmChemCSDataCollect.QueryCheckConsignBaseDetail_Distinct", new Object[] { arrayList, path }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    publicUltraGridBase.DataTable.Rows.Clear();
                    publicDataCJBase1.ClearAll();
                    txtANA_C.Text = "";
                    txtANA_S.Text = "";
                    return;
                }

                GridHelper.CopyDataToDatatable(dt, publicUltraGridBase.DataTable, true);//把dt复制给dataTable4

                GridHelper.RefreshAndAutoSize(publicUltraGridBase.Ug);//刷新Grid
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
            }
        }

        private void QueryCheckConsignChemDetail(ArrayList arrayList, string path)
        {
            try
            {
                publicDataCJBase1.ClearAll();
                txtANA_C.ReadOnly = true;
                txtANA_S.ReadOnly = true;
                DataTable dt = PublicServer.GetData("com.steering.lims.data.device.FrmChemCSDataCollect.QueryCheckConsignChemDetail", new Object[] { arrayList, path }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    txtANA_C.Text = "";
                    txtANA_S.Text = "";
                    return;
                }
                //publicDataCJBase1.StrName = dt.Rows[0]["CHECK_NAME"].ToString();
                //publicDataCJBase1.StrTime = dt.Rows[0]["CHECK_TIME"].ToString();
                //publicDataCJBase1.StrShift = dt.Rows[0]["CHECK_SHIFT"].ToString();
                publicDataCJBase1.StrClass = dt.Rows[0]["CHECK_CLASS"].ToString();
                publicDataCJBase1.StrTemp = dt.Rows[0]["CHECK_TEMP"].ToString();
                publicDataCJBase1.StrDevice_No = dt.Rows[0]["DEVICE_NO"].ToString();
                publicDataCJBase1.StrDevice_Name = dt.Rows[0]["DEVICE_NAME"].ToString();
                publicDataCJBase1.StrAuditName = dt.Rows[0]["AUDIT_NAME"].ToString();
                publicDataCJBase1.StrAuditTime = dt.Rows[0]["AUDIT_TIME"].ToString();
                publicDataCJBase1.StrRemark = dt.Rows[0]["REMARK"].ToString();

                foreach (DataRow dr in dt.Rows)
                {
                    if (dr["CHEM_NAME"].ToString() == "C")
                    {
                        txtANA_C.ReadOnly = false;
                        txtANA_C.Text = dr["AUDIT_VALUE"].ToString();
                    }
                    else if (dr["CHEM_NAME"].ToString() == "S")
                    {
                        txtANA_S.ReadOnly = false;
                        txtANA_S.Text = dr["AUDIT_VALUE"].ToString();
                    }
                }
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
            }
        }

        private void AddCheckConsignChemDetail_Cs(PublicUltraGridBase publicUltraGridBase, string path)
        {
            try
            {
                if (publicUltraGridBase.Ur == null || publicUltraGridBase.Ur.Activated == false)
                {
                    MessageUtil.ShowWarning("请选择需要新增的试样信息！");
                    return;
                }

                if (txtANA_C.ReadOnly == false && txtANA_C.Text.Trim() == "")
                {
                    MessageUtil.ShowWarning("元素C没有录入值！");
                    return;
                }
                if (txtANA_S.ReadOnly == false && txtANA_S.Text.Trim() == "")
                {
                    MessageUtil.ShowWarning("元素S没有录入值！");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认新增？") == DialogResult.Yes)
                {
                    string strCHECK_NO = publicUltraGridBase.Ur.Cells["CHECK_NO"].Text.Trim();
                    string strSAMPLE_NO = publicUltraGridBase.Ur.Cells["SAMPLE_NO"].Text.Trim();//定位

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

                    ArrayList alDetail = new ArrayList();//检验信息详细表list

                    ArrayList alDetailParams = new ArrayList();
                    alDetailParams.Add(publicDataCJBase1.StrTemp);//温度
                    alDetailParams.Add(publicDataCJBase1.StrDevice_No);//设备编码
                    alDetailParams.Add(publicDataCJBase1.StrDevice_Name);//设备名称
                    alDetailParams.Add(publicDataCJBase1.StrRemark);//备注
                    alDetailParams.Add(publicDataCJBase1.StrShift == "" ? UserInfo.GetUserOrderText() : publicDataCJBase1.StrShift);
                    alDetailParams.Add(publicDataCJBase1.StrClass == "" ? UserInfo.GetUserGroupText() : publicDataCJBase1.StrClass);//班组
                    alDetailParams.Add(publicDataCJBase1.StrName == "" ? UserInfo.GetUserName() : publicDataCJBase1.StrName);//录入人
                    alDetailParams.Add(strTime);//录入时间
                    alDetailParams.Add(txtANA_C.Text.Trim());
                    alDetailParams.Add(txtANA_C.Text.Trim());
                    alDetailParams.Add("1");
                    alDetailParams.Add("0");
                    alDetailParams.Add("C");
                    alDetailParams.Add(strSAMPLE_NO);
                    alDetailParams.Add(strCHECK_NO);
                    alDetail.Add(alDetailParams);

                    alDetailParams = new ArrayList();
                    alDetailParams.Add(publicDataCJBase1.StrTemp);//温度
                    alDetailParams.Add(publicDataCJBase1.StrDevice_No);//设备编码
                    alDetailParams.Add(publicDataCJBase1.StrDevice_Name);//设备名称
                    alDetailParams.Add(publicDataCJBase1.StrRemark);//备注
                    alDetailParams.Add(publicDataCJBase1.StrShift == "" ? UserInfo.GetUserOrderText() : publicDataCJBase1.StrShift);
                    alDetailParams.Add(publicDataCJBase1.StrClass == "" ? UserInfo.GetUserGroupText() : publicDataCJBase1.StrClass);//班组
                    alDetailParams.Add(publicDataCJBase1.StrName == "" ? UserInfo.GetUserName() : publicDataCJBase1.StrName);//录入人
                    alDetailParams.Add(strTime);//录入时间
                    alDetailParams.Add(txtANA_S.Text.Trim());
                    alDetailParams.Add(txtANA_S.Text.Trim());
                    alDetailParams.Add("1");
                    alDetailParams.Add("0");
                    alDetailParams.Add("S");
                    alDetailParams.Add(strSAMPLE_NO);
                    alDetailParams.Add(strCHECK_NO);
                    alDetail.Add(alDetailParams);

                    PublicServer.SetData("com.steering.lims.data.device.FrmChemCSDataCollect.AddCheckConsignChemDetail_Cs",
new Object[] { alDetail, path }, this.ob);

                    QueryCheckConsignChemDetail_Cs(publicUltraGridBase, path, "2", "0");

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

        private void UpdateCheckConsignChemDetail_Cs(PublicUltraGridBase publicUltraGridBase, string path)
        {

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

                if (txtANA_C.ReadOnly == false && txtANA_C.Text.Trim() == "")
                {
                    MessageUtil.ShowWarning("元素C没有录入值！");
                    return;
                }
                if (txtANA_S.ReadOnly == false && txtANA_S.Text.Trim() == "")
                {
                    MessageUtil.ShowWarning("元素S没有录入值！");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认修改？") == DialogResult.Yes)
                {
                    string strCHECK_NO = publicUltraGridBase.Ur.Cells["CHECK_NO"].Text.Trim();
                    string strSAMPLE_NO = publicUltraGridBase.Ur.Cells["SAMPLE_NO"].Text.Trim();//定位

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

                    ArrayList alDetail = new ArrayList();//检验信息详细表list

                    ArrayList alDetailParams = new ArrayList();
                    alDetailParams.Add(publicDataCJBase1.StrTemp);//温度
                    alDetailParams.Add(publicDataCJBase1.StrDevice_No);//设备编码
                    alDetailParams.Add(publicDataCJBase1.StrDevice_Name);//设备名称
                    alDetailParams.Add(publicDataCJBase1.StrRemark);//备注
                    alDetailParams.Add(publicDataCJBase1.StrShift == "" ? UserInfo.GetUserOrderText() : publicDataCJBase1.StrShift);
                    alDetailParams.Add(publicDataCJBase1.StrClass == "" ? UserInfo.GetUserGroupText() : publicDataCJBase1.StrClass);//班组
                    alDetailParams.Add(publicDataCJBase1.StrName == "" ? UserInfo.GetUserName() : publicDataCJBase1.StrName);//录入人
                    alDetailParams.Add(strTime);//录入时间
                    alDetailParams.Add(txtANA_C.Text.Trim());
                    alDetailParams.Add(txtANA_C.Text.Trim());
                    alDetailParams.Add("1");
                    alDetailParams.Add("1");
                    alDetailParams.Add("C");
                    alDetailParams.Add(strSAMPLE_NO);
                    alDetailParams.Add(strCHECK_NO);
                    alDetail.Add(alDetailParams);

                    alDetailParams = new ArrayList();
                    alDetailParams.Add(publicDataCJBase1.StrTemp);//温度
                    alDetailParams.Add(publicDataCJBase1.StrDevice_No);//设备编码
                    alDetailParams.Add(publicDataCJBase1.StrDevice_Name);//设备名称
                    alDetailParams.Add(publicDataCJBase1.StrRemark);//备注
                    alDetailParams.Add(publicDataCJBase1.StrShift == "" ? UserInfo.GetUserOrderText() : publicDataCJBase1.StrShift);
                    alDetailParams.Add(publicDataCJBase1.StrClass == "" ? UserInfo.GetUserGroupText() : publicDataCJBase1.StrClass);//班组
                    alDetailParams.Add(publicDataCJBase1.StrName == "" ? UserInfo.GetUserName() : publicDataCJBase1.StrName);//录入人
                    alDetailParams.Add(strTime);//录入时间
                    alDetailParams.Add(txtANA_S.Text.Trim());
                    alDetailParams.Add(txtANA_S.Text.Trim());
                    alDetailParams.Add("1");
                    alDetailParams.Add("1");
                    alDetailParams.Add("S");
                    alDetailParams.Add(strSAMPLE_NO);
                    alDetailParams.Add(strCHECK_NO);
                    alDetail.Add(alDetailParams);

                    PublicServer.SetData("com.steering.lims.data.device.FrmChemCSDataCollect.UpdateCheckConsignChemDetail_Cs",
new Object[] { strCHECK_NO, strSAMPLE_NO, alDetail, path }, this.ob);

                    QueryCheckConsignChemDetail_Cs(publicUltraGridBase, path, "23456", "1");

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

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

        private void DeleteCheckConsignChemDetail_Cs(PublicUltraGridBase publicUltraGridBase, string path)
        {
            try
            {
                if (publicUltraGridBase.Ur == null || publicUltraGridBase.Ur.Activated == false)
                {
                    MessageUtil.ShowWarning("请选择需要删除的试样信息！");
                    return;
                }

                //if (txtANA_C.ReadOnly == false && txtANA_C.Text.Trim() == "")
                //{
                //    MessageUtil.ShowWarning("元素C没有录入值！");
                //    return;
                //}
                //if (txtANA_S.ReadOnly == false && txtANA_S.Text.Trim() == "")
                //{
                //    MessageUtil.ShowWarning("元素S没有录入值！");
                //    return;
                //}
                if (MessageUtil.ShowYesNoAndQuestion("是否确认删除？") == DialogResult.Yes)
                {
                    string strCHECK_NO = publicUltraGridBase.Ur.Cells["CHECK_NO"].Text.Trim();
                    string strSAMPLE_NO = publicUltraGridBase.Ur.Cells["SAMPLE_NO"].Text.Trim();//定位

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

                    ArrayList alDetail = new ArrayList();//检验信息详细表list

                    ArrayList 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("0");
                    alDetailParams.Add("1");
                    alDetailParams.Add("C");
                    alDetailParams.Add(strSAMPLE_NO);
                    alDetailParams.Add(strCHECK_NO);
                    alDetail.Add(alDetailParams);

                    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("0");
                    alDetailParams.Add("1");
                    alDetailParams.Add("S");
                    alDetailParams.Add(strSAMPLE_NO);
                    alDetailParams.Add(strCHECK_NO);
                    alDetail.Add(alDetailParams);

                    PublicServer.SetData("com.steering.lims.data.device.FrmChemCSDataCollect.DeleteCheckConsignChemDetail_Cs",
new Object[] { strCHECK_NO, strSAMPLE_NO, alDetail, path }, this.ob);

                    QueryCheckConsignChemDetail_Cs(publicUltraGridBase, path, "23456", "1");

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

                    MessageUtil.ShowTips("删除成功！");
                }

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

        //获取查询条件
        public ArrayList GetQueryInfo()
        {
            ArrayList arrayList = new ArrayList();

            if (chkCONSIGN_TIME.Checked)
            {
                arrayList.Add(dateBegin.DateTime.ToShortDateString() + " 00:00:00");
                arrayList.Add(dateEnd.DateTime.ToShortDateString() + " 23:59:59");
            }
            else
            {
                arrayList.Add("0001/01/01 00:00:00");
                arrayList.Add("9999/12/31 23:59:59");
            }
            if (chkCHECK_NO.Checked)
            {
                arrayList.Add(txtQueryCHECK_NO.Text.Trim());
            }
            else
            {
                arrayList.Add("");
            }

            return arrayList;
        }


        private void chkCONSIGN_TIME_CheckedChanged(object sender, EventArgs e)
        {
            this.dateBegin.Enabled = chkCONSIGN_TIME.Checked;
            this.dateEnd.Enabled = chkCONSIGN_TIME.Checked;
        }

        private void chkCHECK_NO_CheckedChanged(object sender, EventArgs e)
        {
            txtQueryCHECK_NO.Enabled = chkCHECK_NO.Checked;
        }

        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            UltraGridRow ur = null;
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                splitContainer1.Panel1Collapsed = false;

                splitContainer1.Panel2Collapsed = true;

                if (ultraTabControl2.SelectedTab.Index == 0)
                {
                    ur = publicUltraGridBase1.Ur;
                }
                else if (ultraTabControl2.SelectedTab.Index == 1)
                {
                    ur = publicUltraGridBase2.Ur;
                }

                pipeShowBase1.ShowBaseInfo(ur);
            }
            else if (ultraTabControl1.SelectedTab.Index == 1)
            {
                splitContainer1.Panel1Collapsed = true;

                splitContainer1.Panel2Collapsed = false;

                if (ultraTabControl3.SelectedTab.Index == 0)
                {
                    ur = publicUltraGridBase3.Ur;
                }
                else if (ultraTabControl3.SelectedTab.Index == 1)
                {
                    ur = publicUltraGridBase4.Ur;
                }

                outdecShowBase1.ShowBaseInfo(ur);
            }

            if (ur != null)
            {
                ArrayList arrayList = new ArrayList();
                arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());//20160523
                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 (ultraTabControl1.SelectedTab.Index == 0)
                {
                    QueryCheckConsignChemDetail(arrayList, "pipe");
                }
                else if (ultraTabControl1.SelectedTab.Index == 1)
                {
                    QueryCheckConsignChemDetail(arrayList, "outdec");
                }
            }
        }

        private void ultraTabControl2_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            UltraGridRow ur = null;
            if (ultraTabControl2.SelectedTab.Index == 0)
            {
                ur = publicUltraGridBase1.Ur;
            }
            else if (ultraTabControl2.SelectedTab.Index == 1)
            {
                ur = publicUltraGridBase2.Ur;
            }

            pipeShowBase1.ShowBaseInfo(ur);

            if (ur != null)
            {
                ArrayList arrayList = new ArrayList();
                arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());//20160523
                arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
                arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
                arrayList.Add(ur.Cells["CHECK_NO"].Text.Trim());

                QueryCheckConsignChemDetail(arrayList, "pipe");
            }
        }

        private void ultraTabControl3_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            UltraGridRow ur = null;
            if (ultraTabControl3.SelectedTab.Index == 0)
            {
                ur = publicUltraGridBase3.Ur;
            }
            else if (ultraTabControl3.SelectedTab.Index == 1)
            {
                ur = publicUltraGridBase4.Ur;
            }

            outdecShowBase1.ShowBaseInfo(ur);

            if (ur != null)
            {
                ArrayList arrayList = new ArrayList();
                arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());//20160523
                arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
                arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
                arrayList.Add(ur.Cells["CHECK_NO"].Text.Trim());

                QueryCheckConsignChemDetail(arrayList, "outdec");
            }
        }
    }
}