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

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using CoreFS.CA06;
using Infragistics.Win.UltraWinGrid;
using Core.Mes.Client.Comm.Tool;
using System.Collections;
using Core.Mes.Client.Comm.Control;
using Infragistics.Win;

namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec
{
    public partial class FrmPipeResample : FrmBase
    {
        private string[] arrId;//数据权限
        public FrmPipeResample()
        {
            InitializeComponent();
        }

        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            publicUltraGridDetail1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
            publicUltraGridDetail2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            publicUltraGridDetail3.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
            publicUltraGridChemDetail3.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            publicUltraGridDetail4.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
            publicUltraGridChemDetail4.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

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

        private void FrmPipeResample_Load(object sender, EventArgs e)
        {
            arrId = this.ValidDataPurviewIds;//获取数据权限
            pipeQueryBase1.ShowControl();
            InitColumns();
        }

        private void InitColumns()
        {
            string[] arrColumns = new string[] { "CHK", "FLAG", "FLAG_DESC", "CHECK_NO", "SAMPLE_NO", "PHY_CODE_MAX", "PHY_NAME_MAX", "SAMPLE_COUNT", "IS_RESAMPLE_REST", "IS_RESAMPLE_REST_DESC", "JG_SEND_NAME", "JG_SEND_TIME", "LAB_RECEIVE_NAME", "LAB_RECEIVE_TIME", "HEAT_NO", "STEEL_GRADE", "STEEL_NO", "PRODUCT_STD", "CONTRACT_NO", "DIMATER", "HEIGHT", "CONSIGN_DEPT", "CONSIGN_NAME", "CONSIGN_TIME", "ISPRODUCER", "ISPRODUCER_DESC", "SPEC_REQ", "REMARK", "RESAMPLE_REST_REMARK" };
            string[] arrCaption = new string[] { "选择", "状态", "状态", "检验编号", "试样号", "检验项代码", "检验项", "试样数", "余料", "余料", "送样人", "送样时间", "收样人", "收样时间", "炉号", "钢级", "钢号", "技术标准", "合同号", "外径", "壁厚", "委托单位", "委托人", "委托时间", "是否监制", "是否监制", "特殊要求", "备注", "重取样流转备注" };

            publicUltraGridDetail1.InitColumns(arrColumns, arrCaption);
            publicUltraGridDetail1.setColumnShowOrHidden(new string[] { "FLAG", "FLAG_DESC", "PHY_CODE_MAX", "IS_RESAMPLE_REST", "IS_RESAMPLE_REST_DESC", "LAB_RECEIVE_NAME", "LAB_RECEIVE_TIME", "ISPRODUCER" }, false);//不需要显示的行
            publicUltraGridDetail1.setOtherColumnReadOnly(new string[] { "CHK" });//可编辑列
            //publicUltraGridDetail1.Ug.DisplayLayout.Bands[0].Override.AllowAddNew = AllowAddNew.No;

            publicUltraGridDetail2.InitColumns(arrColumns, arrCaption);
            publicUltraGridDetail2.setColumnShowOrHidden(new string[] { "FLAG", "PHY_CODE_MAX", "IS_RESAMPLE_REST", "ISPRODUCER" }, false);
            publicUltraGridDetail2.setOtherColumnReadOnly(new string[] { "CHK" });
            //publicUltraGridDetail2.Ug.DisplayLayout.Bands[0].Override.AllowAddNew = AllowAddNew.No;

            //重取样委托生成页
            publicUltraGridBase3.PublicUltraGridBaseActive += new EventHandler(outdecUltraGridBase3_PublicUltraGridBaseActive);//调用委托事件

            //string[] arrColumnsBase = new string[] { "CHECK_NO", "HEAT_NO", "STEEL_GRADE", "STEEL_NO", "PRODUCT_STD", "CONTRACT_NO", "DIMATER", "HEIGHT", "CONSIGN_DEPT", "CONSIGN_NAME", "CONSIGN_TIME", "ISPRODUCER", "SPEC_REQ", "FLAG", "FLAG_DESC", "REMARK " };
            //string[] arrCaptionBase = new string[] { "检验编号", "炉号", "钢级", "钢号", "技术标准", "合同号", "外径", "壁厚", "委托单位", "委托人", "委托时间", "是否监制", "特殊要求", "标志位", "标志位", "备注" };
            //publicUltraGridBase3.InitColumns(arrColumnsBase, arrCaptionBase);
            //publicUltraGridBase3.setColumnShowOrHidden(new string[] { "CHECK_NO" }, true);
            //publicUltraGridBase3.setOtherColumnReadOnly(null);//可编辑列
            publicUltraGridBase3.InitColumnsPipeBase(new string[] { "CHECK_NO" }, true, null);

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

            publicUltraGridDetail3.InitColumns(arrColumnsDetail, arrCaptionDetail);
            //publicUltraGridDetail1.setColumnShowOrHidden(new string[] { "FLAG" }, false);//不需要显示的行
            //publicUltraGridDetail3.setOtherColumnReadOnly(null);//可编辑列
            //publicUltraGridDetail3.Ug.DisplayLayout.Bands[0].Override.AllowAddNew = AllowAddNew.TemplateOnBottom;

            //publicUltraGridChemDetail3.setOtherColumnReadOnly(null);//可编辑列
            //PublicPipeAndOutdec.setOtherColumnReadOnly(publicUltraGridChemDetail3.Ug, null);

            publicUltraGridBase4.PublicUltraGridBaseActive += new EventHandler(outdecUltraGridBase4_PublicUltraGridBaseActive);//调用委托事件
            //publicUltraGridBase4.InitColumns(arrColumnsBase, arrCaptionBase);
            //publicUltraGridBase4.setColumnShowOrHidden(new string[] { "CHECK_NO" }, true);
            //publicUltraGridBase4.setOtherColumnReadOnly(null);//可编辑列
            publicUltraGridBase4.InitColumnsPipeBase(new string[] { "CHECK_NO" }, true, null);

            publicUltraGridDetail4.InitColumns(arrColumnsDetail, arrCaptionDetail);
            //publicUltraGridDetail1.setColumnShowOrHidden(new string[] { "FLAG" }, false);//不需要显示的行
            //publicUltraGridDetail4.setOtherColumnReadOnly(null);//可编辑列
            //publicUltraGridDetail4.Ug.DisplayLayout.Bands[0].Override.AllowAddNew = AllowAddNew.TemplateOnBottom;
        }

        /// <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)
                    {
                        QueryCheckConsignDetailInfo(publicUltraGridDetail1, "00");
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 1)
                    {
                        QueryCheckConsignDetailInfo(publicUltraGridDetail2, "10,11");
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 2)
                    {
                        QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase3, "10,11");
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 3)
                    {
                        QueryCheckConsignBase();
                    }
                    break;
                case "AddResample":
                    UpdateCheckConsignDetail_Resample();
                    break;
                case "AddResampleReturn":
                    ReturnUpdateCheckConsignDetail_Resample();
                    break;
                case "AddRest":
                    UpdateCheckConsignDetail_Rest();
                    break;
                case "AddRestReturn":
                    ReturnUpdateCheckConsignDetail_Rest();
                    break;
                case "AddConsign"://生成委托指示原检验编号后加-N，Base表标志位变为3
                    AddCheckConsign();
                    break;
                case "AddConsignReturn":
                    ReturnAddCheckConsign();
                    break;
                case "Cancel"://委托指示
                    if (ultraTabControl1.SelectedTab.Index == 1)
                    {
                        //取消重取样指示  一个取消余料指示  
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 1)
                    {
                        //取消余料指示
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 3)
                    {
                        //取消重取样指示
                    }
                    //CancelUpdateCheckConsignDetail();//都要有取消操作按钮 取消重取样指示
                    break;
                case "Close":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
                    {
                        this.Close();
                    }
                    break;
            }
        }

        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("AddResample"))
                {
                    toolMenu.Toolbars[0].Tools["AddResample"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AddRest"))
                {
                    this.toolMenu.Toolbars[0].Tools["AddRest"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AddConsign"))
                {
                    toolMenu.Toolbars[0].Tools["AddConsign"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AddResampleReturn"))
                {
                    toolMenu.Toolbars[0].Tools["AddResampleReturn"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AddRestReturn"))
                {
                    toolMenu.Toolbars[0].Tools["AddRestReturn"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AddConsignReturn"))
                {
                    toolMenu.Toolbars[0].Tools["AddConsignReturn"].InstanceProps.Visible = DefaultableBoolean.False;
                }
            }
            else if (ultraTabControl1.SelectedTab.Index == 1)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("AddResample"))
                {
                    toolMenu.Toolbars[0].Tools["AddResample"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AddRest"))
                {
                    this.toolMenu.Toolbars[0].Tools["AddRest"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AddConsign"))
                {
                    toolMenu.Toolbars[0].Tools["AddConsign"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AddResampleReturn"))
                {
                    toolMenu.Toolbars[0].Tools["AddResampleReturn"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AddRestReturn"))
                {
                    toolMenu.Toolbars[0].Tools["AddRestReturn"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AddConsignReturn"))
                {
                    toolMenu.Toolbars[0].Tools["AddConsignReturn"].InstanceProps.Visible = DefaultableBoolean.False;
                }
            }
            else if (ultraTabControl1.SelectedTab.Index == 2)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("AddResample"))
                {
                    toolMenu.Toolbars[0].Tools["AddResample"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AddRest"))
                {
                    this.toolMenu.Toolbars[0].Tools["AddRest"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AddConsign"))
                {
                    toolMenu.Toolbars[0].Tools["AddConsign"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AddResampleReturn"))
                {
                    toolMenu.Toolbars[0].Tools["AddResampleReturn"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AddRestReturn"))
                {
                    toolMenu.Toolbars[0].Tools["AddRestReturn"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AddConsignReturn"))
                {
                    toolMenu.Toolbars[0].Tools["AddConsignReturn"].InstanceProps.Visible = DefaultableBoolean.False;
                }
            }
            else if (ultraTabControl1.SelectedTab.Index == 3)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("AddResample"))
                {
                    toolMenu.Toolbars[0].Tools["AddResample"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AddRest"))
                {
                    this.toolMenu.Toolbars[0].Tools["AddRest"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AddConsign"))
                {
                    toolMenu.Toolbars[0].Tools["AddConsign"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AddResampleReturn"))
                {
                    toolMenu.Toolbars[0].Tools["AddResampleReturn"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AddRestReturn"))
                {
                    toolMenu.Toolbars[0].Tools["AddRestReturn"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AddConsignReturn"))
                {
                    toolMenu.Toolbars[0].Tools["AddConsignReturn"].InstanceProps.Visible = DefaultableBoolean.True;
                }
            }
        }

        //查询检验委托基本信息
        private void QueryCheckConsignDetailInfo(PublicUltraGridDetail publicUltraGridDetail, string strFlag)
        {
            try
            {
                publicUltraGridDetail.QueryCheckConsignBaseDetail("pipe.FrmPipeResample", pipeQueryBase1.GetQueryInfo(strFlag), this.ob, arrId);
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        //确认来样,更新检验委托加工信息2015-08-03修改为一个检验编号确认
        private void UpdateCheckConsignDetail_Resample()
        {
            try
            {
                if (publicUltraGridDetail1.Ug == null || publicUltraGridDetail1.Ug.Rows.Count == 0)
                {
                    return;
                }

                if (ultraTabControl1.SelectedTab.Index != 0)
                {
                    MessageUtil.ShowTips("只有选择了重取样指示页才能进行重取样指示操作！");
                    return;
                }

                publicUltraGridDetail1.Ug.UpdateData();
                DataRow[] arrBase = publicUltraGridDetail1.DataTable.Select("CHK = 'True'");
                if (arrBase == null || arrBase.Length == 0)
                {
                    MessageUtil.ShowTips("请勾选需要发送重取样指示的检验信息！");
                    return;
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否确认发送重取样指示？") == DialogResult.Yes)
                {
                    string user = UserInfo.GetUserName();
                    string strDate = DateTime.Now.ToString();
                    string strRemark = "重取样指示(" + user + " " + strDate + ")";

                    ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息
                    ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
                    foreach (DataRow row in arrBase)
                    {
                        alBaseParams = new ArrayList();//增加要更新的基础标志位信息
                        alBaseParams.Add("11");
                        alBaseParams.Add(strRemark);//收样人
                        alBaseParams.Add(strRemark);//收样时间
                        alBaseParams.Add("00");
                        alBaseParams.Add(row["PHY_CODE_MAX"].ToString());
                        alBaseParams.Add(row["SAMPLE_NO"].ToString());
                        alBaseParams.Add(row["CHECK_NO"].ToString());
                        alBase.Add(alBaseParams);
                    }

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

                    QueryCheckConsignDetailInfo(publicUltraGridDetail1, "00");
                    QueryCheckConsignDetailInfo(publicUltraGridDetail2, "11");

                    MessageUtil.ShowTips("重取样指示发送成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        private void ReturnUpdateCheckConsignDetail_Resample()
        {
            try
            {
                if (publicUltraGridDetail1.Ug == null || publicUltraGridDetail1.Ug.Rows.Count == 0)
                {
                    return;
                }

                if (ultraTabControl1.SelectedTab.Index != 0)
                {
                    MessageUtil.ShowTips("只有选择了重取样指示页才能进行重取样指示操作！");
                    return;
                }

                publicUltraGridDetail1.Ug.UpdateData();
                DataRow[] arrBase = publicUltraGridDetail1.DataTable.Select("CHK = 'True'");
                if (arrBase == null || arrBase.Length == 0)
                {
                    MessageUtil.ShowTips("请勾选需要发送重取样指示的检验信息！");
                    return;
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否确认发送重取样指示？") == DialogResult.Yes)
                {
                    string user = UserInfo.GetUserName();
                    string strDate = DateTime.Now.ToString();
                    ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息

                    ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
                    foreach (DataRow row in arrBase)
                    {
                        alBaseParams = new ArrayList();//增加要更新的基础标志位信息
                        alBaseParams.Add("11");
                        alBaseParams.Add(user);//收样人
                        alBaseParams.Add(strDate);//收样时间
                        alBaseParams.Add("00");
                        alBaseParams.Add(row["PHY_CODE_MAX"].ToString());
                        alBaseParams.Add(row["SAMPLE_NO"].ToString());
                        alBaseParams.Add(row["CHECK_NO"].ToString());
                        alBase.Add(alBaseParams);
                    }

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

                    QueryCheckConsignDetailInfo(publicUltraGridDetail1, "00");
                    QueryCheckConsignDetailInfo(publicUltraGridDetail2, "11");

                    MessageUtil.ShowTips("重取样指示发送成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        //确认来样,更新检验委托加工信息2015-08-03修改为一个检验编号确认
        private void UpdateCheckConsignDetail_Rest()
        {
            try
            {
                if (publicUltraGridDetail2.Ug == null || publicUltraGridDetail2.Ug.Rows.Count == 0)
                {
                    return;
                }

                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowTips("只有选择了余料指示页才能进行余料指示操作！");
                    return;
                }

                publicUltraGridDetail2.Ug.UpdateData();
                DataRow[] arrBase = publicUltraGridDetail2.DataTable.Select("CHK = 'True'");
                if (arrBase == null || arrBase.Length == 0)
                {
                    MessageUtil.ShowTips("请勾选需要发送余料指示的检验信息！");
                    return;
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否确认发送无余料指示？") == DialogResult.Yes)
                {
                    string user = UserInfo.GetUserName();
                    string strDate = DateTime.Now.ToString();
                    string strRemark = "无余料指示(" + user + " " + strDate + ")";

                    ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息
                    ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
                    foreach (DataRow row in arrBase)
                    {
                        alBaseParams = new ArrayList();//增加要更新的基础标志位信息
                        alBaseParams.Add("10");
                        alBaseParams.Add(strRemark);//收样人
                        alBaseParams.Add(strRemark);//收样时间
                        alBaseParams.Add("11");
                        alBaseParams.Add(row["PHY_CODE_MAX"].ToString());
                        alBaseParams.Add(row["SAMPLE_NO"].ToString());
                        alBaseParams.Add(row["CHECK_NO"].ToString());
                        alBase.Add(alBaseParams);
                    }

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

                    QueryCheckConsignDetailInfo(publicUltraGridDetail1, "00");
                    QueryCheckConsignDetailInfo(publicUltraGridDetail2, "10,11");

                    MessageUtil.ShowTips("无余料指示发送成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        private void ReturnUpdateCheckConsignDetail_Rest()
        {
            try
            {
                if (publicUltraGridDetail2.Ug == null || publicUltraGridDetail2.Ug.Rows.Count == 0)
                {
                    return;
                }

                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowTips("只有选择了余料指示页才能进行余料指示操作！");
                    return;
                }

                publicUltraGridDetail2.Ug.UpdateData();
                DataRow[] arrBase = publicUltraGridDetail2.DataTable.Select("CHK = 'True'");
                if (arrBase == null || arrBase.Length == 0)
                {
                    MessageUtil.ShowTips("请勾选需要发送余料指示的检验信息！");
                    return;
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否确认发送无余料指示？") == DialogResult.Yes)
                {
                    string user = UserInfo.GetUserName();
                    string strDate = DateTime.Now.ToString();
                    ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息

                    ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
                    foreach (DataRow row in arrBase)
                    {
                        alBaseParams = new ArrayList();//增加要更新的基础标志位信息
                        alBaseParams.Add("10");
                        //alBaseParams.Add(user);//收样人
                        //alBaseParams.Add(strDate);//收样时间
                        alBaseParams.Add("11");
                        alBaseParams.Add(row["PHY_CODE_MAX"].ToString());
                        alBaseParams.Add(row["SAMPLE_NO"].ToString());
                        alBaseParams.Add(row["CHECK_NO"].ToString());
                        alBase.Add(alBaseParams);
                    }

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

                    QueryCheckConsignDetailInfo(publicUltraGridDetail1, "00");
                    QueryCheckConsignDetailInfo(publicUltraGridDetail2, "10,11");

                    MessageUtil.ShowTips("无余料指示发送成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        private void CancelUpdateCheckConsignDetail()
        {
            try
            {
                if (publicUltraGridDetail2.Ug == null || publicUltraGridDetail2.Ug.Rows.Count == 0)
                {
                    return;
                }

                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowTips("只有选择了已确认页才能进行取消确认操作！");
                    return;
                }

                publicUltraGridDetail2.Ug.UpdateData();
                DataRow[] arrBase = publicUltraGridDetail2.DataTable.Select("CHK = 'True' AND FLAG = '2'");
                if (arrBase == null || arrBase.Length == 0)
                {
                    MessageUtil.ShowTips("请勾选状态为试验室已确认的检验信息！");
                    return;
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否取消确认？") == DialogResult.Yes)
                {

                    string user = UserInfo.GetUserName();
                    string strDate = DateTime.Now.ToString();
                    publicUltraGridDetail2.UpdateCheckConsignDetail("pipe.FrmLabSampleConfirm", this.ob, arrBase, "1", "", "", "2", "");

                    QueryCheckConsignDetailInfo(publicUltraGridDetail1, "00");
                    QueryCheckConsignDetailInfo(publicUltraGridDetail2, "11");
                    MessageUtil.ShowTips("取消确认成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        //#region 重取样委托
        void outdecUltraGridBase3_PublicUltraGridBaseActive(object sender, EventArgs e)
        {
            pipeShowBase3.ShowBaseInfo(publicUltraGridBase3.Ur);

            QueryCheckConsignDetail(publicUltraGridBase3, publicUltraGridDetail3, "10,11");

            QueryCheckConsignChemDetail(publicUltraGridBase3, publicUltraGridChemDetail3, "10,11");
        }

        //查询检验委托基本信息
        private void QueryCheckConsignBaseDetail_Distinct(PublicUltraGridBase publicUltraGridBase, string strFlag)
        {
            try
            {
                //各试验室各检验项目设置权限
                DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmPipeResample.QueryCheckConsignBaseDetail_Distinct", new Object[] { pipeQueryBase1.GetQueryInfo(strFlag) }, ob);
                if (dt == null || dt.Rows.Count == 0)
                {
                    publicUltraGridBase.DataTable.Rows.Clear();
                    publicUltraGridDetail3.DataTable.Rows.Clear();
                    publicUltraGridChemDetail3.DataTable.Rows.Clear();
                    return;
                }
                GridHelper.CopyDataToDatatable(dt, publicUltraGridBase.DataTable, true);
                //GridHelper.RefreshAndAutoSize(publicUltraGridBase.Ug);
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        //查询检验委托明细信息
        private void QueryCheckConsignDetail(PublicUltraGridBase publicUltraGridBase, PublicUltraGridDetail publicUltraGridDetail, string strFlag)
        {
            try
            {
                ArrayList al = new ArrayList();
                al.Add(strFlag);
                al.Add("");
                al.Add(publicUltraGridBase.Ur.Cells["CHECK_NO"].Text.Trim());

                publicUltraGridDetail.QueryCheckConsignDetail("pipe.FrmPipeResample", al, this.ob, 3);

                PublicPipeAndOutdec.HideNullColumn("HX,ONH", publicUltraGridDetail.Ug);

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

        //查询检验委托化学明细信息
        private void QueryCheckConsignChemDetail(PublicUltraGridBase publicUltraGridBase, PublicUltraGridChemDetail publicUltraGridChemDetail, string strFlag)
        {
            try
            {
                ArrayList al = new ArrayList();
                al.Add(strFlag);
                al.Add("");
                al.Add(publicUltraGridBase.Ur.Cells["CHECK_NO"].Text.Trim());

                publicUltraGridChemDetail.QueryCheckConsignChemDetail("pipe.FrmPipeResample", al, this.ob);

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

        //增加检验委托
        private void AddCheckConsign()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 2)
                {
                    MessageUtil.ShowWarning("只有在重取样委托生成页才能进行委托指示操作！");
                    return;
                }

                if (publicUltraGridBase3.Ug.ActiveRow == null || publicUltraGridBase3.Ug.ActiveRow.Activated == false)
                {
                    MessageUtil.ShowWarning("请选择需要重取样委托的检验信息！");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认新增重取样委托 ？") == DialogResult.Yes)
                {
                    string strTime = DateTime.Now.ToString();
                    string strRemark = "重取样委托指示(" + UserInfo.GetUserName() + " " + strTime + ")";

                    string strCHECK_NO = publicUltraGridBase3.Ur.Cells["CHECK_NO"].Text.Trim();//检验委托编号

                    ArrayList alBaseParams = new ArrayList();//整体list,插入几个表增加几个List
                    alBaseParams = new ArrayList();//增加要更新的基础标志位信息
                    alBaseParams.Add("12");//重取样委托后变12
                    alBaseParams.Add(strRemark);
                    alBaseParams.Add(strRemark);
                    alBaseParams.Add("10,11");
                    alBaseParams.Add(strCHECK_NO);

                    //ArrayList alAll = new ArrayList();//整体list,插入几个表增加几个List
                    //alAll.Add(strCHECK_NO + "-N");
                    //alAll.Add(strCHECK_NO);

                    PublicServer.SetData("com.steering.lims.data.pipe.FrmPipeResample.AddCheckConsign",
new Object[] { strCHECK_NO, alBaseParams }, this.ob);//alBase,

                    QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase3, "10,11");
                    QueryCheckConsignBase();

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

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

        //增加检验委托
        private void ReturnAddCheckConsign()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 3)
                {
                    MessageUtil.ShowWarning("只有在重取样委托查询页才能进行委托指示撤回操作！");
                    return;
                }

                if (publicUltraGridBase4.Ug.ActiveRow == null || publicUltraGridBase4.Ug.ActiveRow.Activated == false)
                {
                    MessageUtil.ShowWarning("请选择需要委托指示撤回的检验信息！");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认委托指示撤回？") == DialogResult.Yes)
                {
                    string strTime = DateTime.Now.ToString();
                    string strRemark = "委托指示撤回(" + UserInfo.GetUserName() + " " + strTime + ")";

                    string strCHECK_NO = publicUltraGridBase4.Ur.Cells["CHECK_NO"].Text.Trim();//检验委托编号

                    ArrayList alBaseParams = new ArrayList();//整体list,插入几个表增加几个List
                    alBaseParams = new ArrayList();//增加要更新的基础标志位信息
                    alBaseParams.Add("10");
                    alBaseParams.Add("12");
                    alBaseParams.Add(strRemark);
                    alBaseParams.Add(strRemark);
                    alBaseParams.Add(strCHECK_NO.Substring(0, strCHECK_NO.IndexOf('-')));

                    //ArrayList alAll = new ArrayList();//整体list,插入几个表增加几个List
                    //alAll.Add(strCHECK_NO + "-N");
                    //alAll.Add(strCHECK_NO);
                    PublicServer.SetData("com.steering.lims.data.pipe.FrmPipeResample.ReturnAddCheckConsign",
new Object[] { strCHECK_NO, alBaseParams }, this.ob);//alBase,

                    //QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase4, "12");
                    QueryCheckConsignBase();

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

                    MessageUtil.ShowTips("委托指示撤回成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        //查询检验委托基本信息
        private void QueryCheckConsignBase()
        {
            try
            {
                //各试验室各检验项目设置权限
                DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmPipeResample.QueryCheckConsignBase", new Object[] { pipeQueryBase1.GetQueryInfo() }, ob);
                if (dt == null || dt.Rows.Count == 0)
                {
                    publicUltraGridBase4.DataTable.Rows.Clear();
                    publicUltraGridDetail4.DataTable.Rows.Clear();
                    publicUltraGridChemDetail4.DataTable.Rows.Clear();
                    return;
                }
                GridHelper.CopyDataToDatatable(dt, publicUltraGridBase4.DataTable, true);
                GridHelper.RefreshAndAutoSize(publicUltraGridBase4.Ug);
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        void outdecUltraGridBase4_PublicUltraGridBaseActive(object sender, EventArgs e)
        {
            pipeShowBase4.ShowBaseInfo(publicUltraGridBase4.Ur);

            QueryCheckConsignDetail(publicUltraGridBase4, publicUltraGridDetail4, "00,10,11");

            //string strHide = "HX,ONH";

            QueryCheckConsignChemDetail(publicUltraGridBase4, publicUltraGridChemDetail4, "00,10,11");
        }

        private void FrmPipeResample_Shown(object sender, EventArgs e)
        {
            if (toolMenu == null) return;
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("AddResample"))
                {
                    toolMenu.Toolbars[0].Tools["AddResample"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AddRest"))
                {
                    this.toolMenu.Toolbars[0].Tools["AddRest"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AddConsign"))
                {
                    toolMenu.Toolbars[0].Tools["AddConsign"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AddResampleReturn"))
                {
                    toolMenu.Toolbars[0].Tools["AddResampleReturn"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AddRestReturn"))
                {
                    toolMenu.Toolbars[0].Tools["AddRestReturn"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AddConsignReturn"))
                {
                    toolMenu.Toolbars[0].Tools["AddConsignReturn"].InstanceProps.Visible = DefaultableBoolean.False;
                }
            }
        }
    }
}