MES_Client/TGMES/Core.StlMes.Client.Lims.Data.PipeAndOutdec/数据管理/钢管实验管理/FrmPipeProducerNotice.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 Core.Mes.Client.Comm.Control;
using Infragistics.Win.UltraWinGrid;
using Infragistics.Win;
using Core.StlMes.Client.Lims.Data.PipeAndOutdec.封装类.实体类;
using Core.Mes.Client.Comm.Format;

namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec
{
    //1.各试验室收样完成状态为2，能根据各试验室整体收样情况通知监制
    //2.根据各试验室情况可整体取消监制，不取消监制如果监制到了可根据情况只监制那些项
    //3.监制完成之后试验室反馈完成信息
    public partial class FrmPipeProducerNotice : FrmBase
    {
        private string[] plineCodes = { };
        public FrmPipeProducerNotice()
        {
            InitializeComponent();
        }

        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            ultraGrid1.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            ultraGrid4.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            ultraGrid5.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;


            pipeQueryBase1.EnterHandler += QueryCheckConsignBase;

            plineCodes = comm.GetPlineCode(ValidDataPurviewIds, ob);
        }

        private void FrmPipeProducerNotice_Load(object sender, EventArgs e)
        {
            InitColumns();
            EntityHelper.ShowGridCaption<SlmOrderLinePrdcrLstEntity>(ultraGrid2.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<SlmOrderLinePrdcrLstEntity>(ultraGrid5.DisplayLayout.Bands[0]);

            EntityHelper.ShowGridCaption<PipeCheckconsignDetailEntity>(ultraGrid3.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<PipeCheckconsignDetailEntity>(ultraGrid6.DisplayLayout.Bands[0]);

            pipeQueryBase1.UpdateControl("确认时间");
        }

        private void InitColumns()
        {
            //未通知TAB页放已接样未通知的信息，已通知TAB放已通知信息
            string[] arrColumns = new string[] { "CHK", "FLAG", "PRDCR_FLAG", "FLAG_DESC", "CHECK_NO", "CONTRACT_NO", "PIPE_SIZE", "CRAFT_SOURCE", "HEAT_NO", "STEEL_GRADE", "STEEL_NO", "PRODUCT_STD", "DIMATER", "HEIGHT", "CRAFT_FILE_NO", "PRODUCT_NAME", "BUCKLE_TYPE", "PROCESS_STATUS", "CONSIGN_DEPT", "CONSIGN_NAME", "CONSIGN_TIME", "ISPRODUCER", "ISPRODUCER_DESC", "SPEC_REQ", "REMARK", "PRDCR_NO" };
            string[] arrCaption = new string[] { "选择", "状态", "监制是否到场", "状态", "检验编号", "合同号", "规格", "委托类型", "炉号", "钢级", "钢号", "技术标准", "外径", "壁厚", "工艺文件号", "品名", "扣型", "工艺状态", "委托单位", "委托人", "委托时间", "是否监制", "是否监制", "特殊要求", "备注", "监制编号" };

            PublicPipeAndOutdec.InitColumns(arrColumns, arrCaption, dataTable1, ultraGrid1, new string[] { "FLAG", "FLAG_DESC", "ISPRODUCER", "ISPRODUCER_DESC" }, false, new string[] { "CHK" });

            //PublicPipeAndOutdec.InitColumns(arrColumns, arrCaption, dataTable1);
            //PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid1, new string[] { "CHK" });

            PublicPipeAndOutdec.InitColumns(arrColumns, arrCaption, dataTable4);
            PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid4, new string[] { "FLAG", "FLAG_DESC", "ISPRODUCER", "ISPRODUCER_DESC" }, false);
            PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid4, new string[] { "CHK" });

            //未通知TAB页放已接样未通知的信息，已通知TAB放已通知信息"CHK","选择",
            string[] arrColumnsDept = new string[] { "CHK", "FLAG", "DEPT_ID", "DEPT_ID_DESC", "NOTICE_PRODUCER_REMARK" };//"FLAG_DESC","状态",
            string[] arrCaptionDept = new string[] { "选择", "状态", "试验室", "试验室", "监制流转备注" };
            PublicPipeAndOutdec.InitColumns(arrColumnsDept, arrCaptionDept, dataTable2, ultraGrid2, new string[] { "DEPT_ID" }, false, new string[] { "CHK" });
            PublicPipeAndOutdec.InitColumns(arrColumnsDept, arrCaptionDept, dataTable5, ultraGrid5, new string[] { "DEPT_ID" }, false, new string[] { "CHK" });

            //未通知TAB页放已接样未通知的信息，已通知TAB放已通知信息"CHK","选择",
            string[] arrColumnsDetail = new string[] { "IS_NOTICE_PRODUCER", "IS_NOTICE_PRODUCER_DESC", "FLAG", "FLAG_DESC", "CHECK_NO", "SAMPLE_NO", "DEPT_ID", "DEPT_ID_DESC", "PHY_CODE_MAX", "PHY_NAME_MAX", "SAMPLE_COUNT", "CHECK_NAME", "CHECK_TIME", "AUDIT_NAME", "AUDIT_TIME" };
            string[] arrCaptionDetail = new string[] { "通知监制", "通知监制", "状态", "状态", "检验编号", "样管号", "试验室", "试验室", "检验项代码", "检验项", "试样数", "试验人", "试验时间", "审核人", "审核时间" };

            PublicPipeAndOutdec.InitColumns(arrColumnsDetail, arrCaptionDetail, dataTable3);//"NOTICE_NAME", "NOTICE_TIME","通知人", "通知时间",
            PublicPipeAndOutdec.InitColumns(arrColumnsDetail, arrCaptionDetail, dataTable6);


            //点击通知监制要判断检验项是否为全部收样确认状态全部完成即可
            //监制完成则等待反馈，监制已到 或者监制取消，反馈完毕试验室反馈监制情况，监制全程跟踪即可完成
            //未通知完毕界面可勾选检验编号 可多选
        }

        /// <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)
                    {
                        QueryCheckConsignBase();
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 1)
                    {
                        QueryCheckConsignBase_Log();
                    }
                    break;
                case "Notice":
                    UpdateNotice();
                    break;
                case "NoticeReturn":
                    UpdateNoticeReturn();
                    break;
                case "NoticeDept":
                    UpdateNoticeDept();
                    break;
                case "NoticeDeptReturn":
                    UpdateNoticeDeptReturn();
                    break;
                case "Come":
                    UpdateCome();
                    break;
                case "ComeReturn":
                    UpdateComeReturn();
                    break;
                case "CancelPro":
                    CancelProUpdateCheckConsignDetail();
                    break;
                case "CancelProReturn":
                    CancelCancelProUpdateCheckConsignDetail();
                    break;
                //case "ComeOn":
                //    ComeOnUpdateCheckConsignDetail();
                //    break;
                case "End":
                    EndUpdateCheckConsignDetail();
                    break;
                case "EndReturn":
                    CancelEndUpdateCheckConsignDetail();
                    break;
                //case "Cancel":
                //    CancelUpdateCheckConsignDetail();
                //    break;
                case "Print"://打印
                    //;
                    break;
                case "Close":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
                    {
                        this.Close();
                    }
                    break;
            }
        }

        #region 未通知
        //查询检验委托基本信息
        private void QueryCheckConsignBase()
        {
            try
            {
                ArrayList arrayList = pipeQueryBase1.GetQueryInfo("0");
                arrayList.Add(plineCodes);
                arrayList.Add("0");
                DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmPipeProducerNotice.QueryCheckConsignBase",
                        new Object[] { arrayList }, this.ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable1.Rows.Clear();
                    dataTable2.Rows.Clear();
                    dataTable3.Rows.Clear();
                    //MessageUtil.ShowTips("查询条件不符合找不到数据！");
                    return;
                }

                GridHelper.CopyDataToDatatable(dt, dataTable1, true);//把dt复制给dataTable1

                GridHelper.RefreshAndAutoSize(ultraGrid1);
                ChangeColor(ultraGrid1);
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
            }
        }

        //查询检验委托基本信息
        /// <summary>
        /// 查询检验委托基本信息
        /// </summary>
        /// <param name="arrayList"></param>
        private void QueryCheckConsignJGDetail(string PRDCR_NO)
        {
            try
            {
                List<SlmOrderLinePrdcrLstEntity> listSource = EntityHelper.GetData<SlmOrderLinePrdcrLstEntity>(
            "com.steering.lims.data.pipe.FrmPipeProducerNotice.QueryPrdcrNo", new object[] { PRDCR_NO }, this.ob);
                bindingSource1.DataSource = listSource;

                ////监制已到操作已去掉 只回报监制反馈信息，然后试验室反馈监制完成情况
                //DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmPipeProducerNotice.QueryPrdcrNo",
                //        new Object[] { arrayList }, this.ob);

                //if (dt == null || dt.Rows.Count == 0)
                //{
                //    dataTable2.Rows.Clear();
                //    //MessageUtil.ShowTips("查询条件不符合找不到数据！");
                //    return;
                //}

                //GridHelper.CopyDataToDatatable(dt, dataTable2, true);//把dt复制给dataTable1

                //PublicPipeAndOutdec.RefreshAndAutoSizeColumns(ultraGrid2, new string[] { "NOTICE_PRODUCER_REMARK" }, false);//刷新Grid

                //GridHelper.RefreshAndAutoSize(ultraGrid2);
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
            }
        }

        /// <summary>
        /// 查询委托明细信息
        /// </summary>
        /// <param name="PRDCR_NO"></param>
        private void QueryCheckConsignDetail(string checkNo,string flag)
        {
            try
            {
                List<PipeCheckconsignDetailEntity> listSource = EntityHelper.GetData<PipeCheckconsignDetailEntity>(
            "com.steering.lims.data.pipe.FrmPipeProducerNotice.QueryCheckConsignDetail", new object[] { checkNo }, this.ob);
                if (flag.Equals("1"))
                {
                    bindingSource3.DataSource = listSource;
                }
                else if(flag.Equals("2"))
                {
                    bindingSource4.DataSource = listSource;
                }
                
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
            }
        }

        

        //查询检验委托基本信息
        private void QueryCheckConsignDetail(ArrayList arrayList)
        {
            try
            {
                DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmPipeProducerNotice.QueryCheckConsignDetail",
                        new Object[] { arrayList }, this.ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable3.Rows.Clear();
                    //MessageUtil.ShowTips("查询条件不符合找不到数据！");
                    return;
                }

                GridHelper.CopyDataToDatatable(dt, dataTable3, true);//把dt复制给dataTable1


                //GridHelper.RefreshAndAutoSize(ultraGrid2);
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
            }
        }

        //确认通知
        /// <summary>
        /// 确认通知
        /// </summary>
        private void UpdateCheckConsignDetail()
        {
            try
            {
                if (dataTable2 == null || dataTable2.Rows.Count == 0)
                {
                    return;
                }

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

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

                ultraGrid2.UpdateData();
                DataRow[] arrBase = dataTable2.Select("CHK = 'True'");
                if (arrBase == null || arrBase.Length == 0)
                {
                    MessageUtil.ShowTips("请至少勾选一条需要通知的检验信息！");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认通知监制？") == DialogResult.Yes)
                {
                    //试验室已收样才可通知监制,要判断试验室全部收样才能通知
                    string strCHECK_NO = ultraGrid1.ActiveRow.Cells["CHECK_NO"].Text.Trim();
                    string strTime = DateTime.Now.ToString();

                    string strRemark = "通知监制(" + UserInfo.GetUserName() + " " + strTime + ")";
                    foreach (DataRow row in arrBase)
                    {
                        if (row["FLAG"].ToString() == "不可通知监制")
                        {
                            MessageUtil.ShowTips("实验室还未收样，不具备通知监制条件!");
                            return;
                        }
                        alBaseParams = new ArrayList();//增加要更新的基础标志位信息
                        alBaseParams.Add("1");
                        alBaseParams.Add(strRemark);//通知人
                        alBaseParams.Add(strRemark);//收样时间
                        alBaseParams.Add("0");
                        //alBaseParams.Add("");
                        alBaseParams.Add(row["DEPT_ID"].ToString());
                        alBaseParams.Add(strCHECK_NO);
                        alBase.Add(alBaseParams);
                    }

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

                    QueryCheckConsignBase();
                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, "CHECK_NO", strCHECK_NO);
                    QueryCheckConsignBase_Log();
                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid4, "CHECK_NO", strCHECK_NO);

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

        /// <summary>
        /// 通知完毕
        /// </summary>
        private void UpdateNotice()
        {
            try
            {
                ultraGrid2.UpdateData();
                IQueryable<UltraGridRow> checkMagRows = this.ultraGrid2.Rows.AsQueryable().Where(" CHK = 'True'");

                if (checkMagRows == null || checkMagRows.Count() == 0)
                {
                    MessageUtil.ShowTips("请至少勾选一条需要通知的检验信息！");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认通知监制？") == DialogResult.Yes)
                {
                    //试验室已收样才可通知监制,要判断试验室全部收样才能通知
                    string strCHECK_NO = ultraGrid1.ActiveRow.Cells["CHECK_NO"].Text.Trim();
                    string strFlag = "1";
                    string user = UserInfo.GetUserName();

                    ArrayList parm = new ArrayList();
                        foreach (UltraGridRow uRow in checkMagRows)
                    {

                        SlmOrderLinePrdcrLstEntity matZcEntity = (SlmOrderLinePrdcrLstEntity)uRow.ListObject;
                        string matZcTity = JSONFormat.Format(matZcEntity);
                        parm.Add(matZcTity);

                    }
                        CoreClientParam ccp = new CoreClientParam();
                        ccp.ServerName = "com.steering.lims.data.pipe.FrmPipeProducerNotice";
                        ccp.MethodName = "UpdateCheckConsignDetailNew";
                        ccp.ServerParams = new object[] { parm, strCHECK_NO, strFlag, user };
                        ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                        if (ccp.ReturnInfo == "通知成功！")
                        {
                            MessageUtil.ShowTips("通知成功！");
                        }
                        else
                        {
                            MessageUtil.ShowTips(ccp.ReturnInfo);
                        }


                    QueryCheckConsignBase();
                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, "CHECK_NO", strCHECK_NO);
                    QueryCheckConsignBase_Log();
                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid4, "CHECK_NO", strCHECK_NO);

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

        /// <summary>
        /// 通知
        /// </summary>
        private void UpdateNoticeDept()
        {
            try
            {
                ultraGrid3.UpdateData();
                IQueryable<UltraGridRow> checkMagRows = this.ultraGrid3.Rows.AsQueryable().Where(" CHK = 'True'");

                if (checkMagRows == null || checkMagRows.Count() == 0)
                {
                    MessageUtil.ShowTips("请至少勾选一条需要通知的检验信息！");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认通知监制？") == DialogResult.Yes)
                {
                    //试验室已收样才可通知监制,要判断试验室全部收样才能通知
                    string strCHECK_NO = ultraGrid1.ActiveRow.Cells["CHECK_NO"].Text.Trim();
                    string strFlag = "2";
                    string user = UserInfo.GetUserName();

                    ArrayList parm = new ArrayList();
                    foreach (UltraGridRow uRow in checkMagRows)
                    {
                        PipeCheckconsignDetailEntity matZcEntity = (PipeCheckconsignDetailEntity)uRow.ListObject;
                        string matZcTity = JSONFormat.Format(matZcEntity);
                        parm.Add(matZcTity);
                    }
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "com.steering.lims.data.pipe.FrmPipeProducerNotice";
                    ccp.MethodName = "UpdateNoticeDept";
                    ccp.ServerParams = new object[] { parm, strCHECK_NO, strFlag, user };
                    ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                    if (ccp.ReturnInfo == "通知成功！")
                    {
                        MessageUtil.ShowTips("通知成功！");
                    }
                    else
                    {
                        MessageUtil.ShowTips(ccp.ReturnInfo);
                    }


                    QueryCheckConsignBase();
                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, "CHECK_NO", strCHECK_NO);
                    QueryCheckConsignBase_Log();
                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid4, "CHECK_NO", strCHECK_NO);

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

        /// <summary>
        /// 通知撤回
        /// </summary>
        private void UpdateNoticeDeptReturn()
        {
            try
            {
                ultraGrid3.UpdateData();
                IQueryable<UltraGridRow> checkMagRows = this.ultraGrid3.Rows.AsQueryable().Where(" CHK = 'True'");

                if (checkMagRows == null || checkMagRows.Count() == 0)
                {
                    MessageUtil.ShowTips("请至少勾选一条需要通知的检验信息！");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认通知监制撤回？") == DialogResult.Yes)
                {
                    //试验室已收样才可通知监制,要判断试验室全部收样才能通知
                    string strCHECK_NO = ultraGrid1.ActiveRow.Cells["CHECK_NO"].Text.Trim();
                    string strFlag = "1";
                    string user = UserInfo.GetUserName();

                    ArrayList parm = new ArrayList();
                    foreach (UltraGridRow uRow in checkMagRows)
                    {
                        PipeCheckconsignDetailEntity matZcEntity = (PipeCheckconsignDetailEntity)uRow.ListObject;
                        string matZcTity = JSONFormat.Format(matZcEntity);
                        parm.Add(matZcTity);
                    }
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "com.steering.lims.data.pipe.FrmPipeProducerNotice";
                    ccp.MethodName = "UpdateNoticeDept";
                    ccp.ServerParams = new object[] { parm, strCHECK_NO, strFlag, user };
                    ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                    if (ccp.ReturnInfo == "监制通知撤回成功！")
                    {
                        MessageUtil.ShowTips("监制通知撤回成功！");
                    }
                    else
                    {
                        MessageUtil.ShowTips(ccp.ReturnInfo);
                    }


                    QueryCheckConsignBase();
                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, "CHECK_NO", strCHECK_NO);
                    QueryCheckConsignBase_Log();
                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid4, "CHECK_NO", strCHECK_NO);

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

        /// <summary>
        /// 监制到场
        /// </summary>
        private void UpdateCome()
        {
            try
            {
                ultraGrid2.UpdateData();
                ultraGrid5.UpdateData();
                UltraGrid ultraGrid = new UltraGrid();
                UltraGrid ultraGrids = new UltraGrid();
                if (this.ultraTabControl1.Tabs[0].Active)
                {
                    ultraGrids = ultraGrid1;
                    ultraGrid = ultraGrid2;
                }
                else if (this.ultraTabControl1.Tabs[1].Active)
                {
                    ultraGrids = ultraGrid4;
                    ultraGrid = ultraGrid5;
                }
                IQueryable<UltraGridRow> checkMagRows = ultraGrid.Rows.AsQueryable().Where(" CHK = 'True'");

                if (checkMagRows == null || checkMagRows.Count() == 0)
                {
                    MessageUtil.ShowTips("请至少勾选一条需要通知的检验信息！");
                    return;
                }

                    //试验室已收样才可通知监制,要判断试验室全部收样才能通知
                string strCHECK_NO = ultraGrids.ActiveRow.Cells["CHECK_NO"].Text.Trim();
                    string strFlag = "1";
                    string user = UserInfo.GetUserName();

                    ArrayList parm = new ArrayList();
                    foreach (UltraGridRow uRow in checkMagRows)
                    {

                        SlmOrderLinePrdcrLstEntity matZcEntity = (SlmOrderLinePrdcrLstEntity)uRow.ListObject;
                        string matZcTity = JSONFormat.Format(matZcEntity);
                        parm.Add(matZcTity);

                    }
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "com.steering.lims.data.pipe.FrmPipeProducerNotice";
                    ccp.MethodName = "UpdateCome";
                    ccp.ServerParams = new object[] { parm, strCHECK_NO, strFlag };
                    ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                    if (ccp.ReturnInfo == "监制到场！")
                    {
                        MessageUtil.ShowTips("监制到场！");
                    }
                    else
                    {
                        MessageUtil.ShowTips(ccp.ReturnInfo);
                    }


                    QueryCheckConsignBase();
                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, "CHECK_NO", strCHECK_NO);
                    QueryCheckConsignBase_Log();
                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid4, "CHECK_NO", strCHECK_NO);

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

        /// <summary>
        /// 撤销监制到场
        /// </summary>
        private void UpdateComeReturn()
        {
            try
            {
                ultraGrid2.UpdateData();
                ultraGrid5.UpdateData();
                UltraGrid ultraGrid = new UltraGrid();
                UltraGrid ultraGrids = new UltraGrid();
                if (this.ultraTabControl1.Tabs[0].Active)
                {
                    ultraGrids = ultraGrid1;
                    ultraGrid = ultraGrid2;
                }
                else if (this.ultraTabControl1.Tabs[1].Active)
                {
                    ultraGrids = ultraGrid4;
                    ultraGrid = ultraGrid5;
                }
                IQueryable<UltraGridRow> checkMagRows = ultraGrid.Rows.AsQueryable().Where(" CHK = 'True'");

                if (checkMagRows == null || checkMagRows.Count() == 0)
                {
                    MessageUtil.ShowTips("请至少勾选一条需要通知的检验信息！");
                    return;
                }

                //试验室已收样才可通知监制,要判断试验室全部收样才能通知
                string strCHECK_NO = ultraGrids.ActiveRow.Cells["CHECK_NO"].Text.Trim();
                string strFlag = "0";
                string user = UserInfo.GetUserName();

                ArrayList parm = new ArrayList();
                foreach (UltraGridRow uRow in checkMagRows)
                {

                    SlmOrderLinePrdcrLstEntity matZcEntity = (SlmOrderLinePrdcrLstEntity)uRow.ListObject;
                    string matZcTity = JSONFormat.Format(matZcEntity);
                    parm.Add(matZcTity);

                }
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.lims.data.pipe.FrmPipeProducerNotice";
                ccp.MethodName = "UpdateCome";
                ccp.ServerParams = new object[] { parm, strCHECK_NO, strFlag };
                ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnInfo == "撤销监制到场！")
                {
                    MessageUtil.ShowTips("撤销监制到场！");
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }


                QueryCheckConsignBase();
                PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, "CHECK_NO", strCHECK_NO);
                QueryCheckConsignBase_Log();
                PublicPipeAndOutdec.ActiveOperateRow(ultraGrid4, "CHECK_NO", strCHECK_NO);


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

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            ArrayList arrayList = new ArrayList();
            arrayList.Add(ultraGrid1.ActiveRow.Cells["PRDCR_NO"].Text.Trim());
            string PRDCR_NO = ultraGrid1.ActiveRow.Cells["PRDCR_NO"].Text.Trim();
            string checkNo = ultraGrid1.ActiveRow.Cells["CHECK_NO"].Text.Trim();

            QueryCheckConsignJGDetail(PRDCR_NO);
            QueryCheckConsignDetail(checkNo,"1");

            foreach (UltraGridRow ugr in this.ultraGrid2.Rows)
            {
                ugr.Cells["CHK"].Value = true;
            }
        }

        

        #endregion

        #region 已通知
        //查询检验委托基本信息
        /// <summary>
        /// 查询检验委托基本信息
        /// </summary>
        private void QueryCheckConsignBase_Log()
        {
            try
            {
                ArrayList arrayList = pipeQueryBase1.GetQueryInfo("1234");
                arrayList.Add(plineCodes);
                arrayList.Add("1");
                DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmPipeProducerNotice.QueryCheckConsignBase",
                        new Object[] { arrayList }, this.ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable4.Rows.Clear();
                    dataTable5.Rows.Clear();
                    dataTable6.Rows.Clear();
                    //MessageUtil.ShowTips("查询条件不符合找不到数据！");
                    return;
                }

                GridHelper.CopyDataToDatatable(dt, dataTable4, true);//把dt复制给dataTable1
               
                GridHelper.RefreshAndAutoSize(ultraGrid4);
                ChangeColor(ultraGrid4);
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
            }
        }

        //查询检验委托基本信息
        /// <summary>
        /// 查询检验委托基本信息
        /// </summary>
        /// <param name="arrayList"></param>
        private void QueryCheckConsignJGDetail_Log(string PRDCR_NO)
        {
            try
            {

                List<SlmOrderLinePrdcrLstEntity> listSource = EntityHelper.GetData<SlmOrderLinePrdcrLstEntity>(
            "com.steering.lims.data.pipe.FrmPipeProducerNotice.QueryPrdcrNo", new object[] { PRDCR_NO }, this.ob);
                bindingSource2.DataSource = listSource;

                //DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmPipeProducerNotice.QueryPrdcrNo",
                //        new Object[] { arrayList }, this.ob);

                //if (dt == null || dt.Rows.Count == 0)
                //{
                //    dataTable5.Rows.Clear();
                //    //MessageUtil.ShowTips("查询条件不符合找不到数据！");
                //    return;
                //}

                //GridHelper.CopyDataToDatatable(dt, dataTable5, true);//把dt复制给dataTable5

                //PublicPipeAndOutdec.RefreshAndAutoSizeColumns(ultraGrid5, new string[] { "NOTICE_PRODUCER_REMARK" }, false);//刷新Grid

                //GridHelper.RefreshAndAutoSize(ultraGrid5);
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
            }
        }

        //查询检验委托基本信息
        /// <summary>
        /// 查询检验委托基本信息
        /// </summary>
        /// <param name="arrayList"></param>
        private void QueryCheckConsignDetail_Log(ArrayList arrayList)
        {
            try
            {
                DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmPipeProducerNotice.QueryCheckConsignDetail",
                        new Object[] { arrayList }, this.ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable6.Rows.Clear();
                    //MessageUtil.ShowTips("查询条件不符合找不到数据！");
                    return;
                }

                GridHelper.CopyDataToDatatable(dt, dataTable6, true);//把dt复制给dataTable1


                //GridHelper.RefreshAndAutoSize(ultraGrid4);
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
            }
        }

        private void ultraGrid4_AfterRowActivate(object sender, EventArgs e)
        {
            ArrayList arrayList = new ArrayList();
            arrayList.Add(ultraGrid4.ActiveRow.Cells["PRDCR_NO"].Text.Trim());
            string PRDCR_NO = ultraGrid4.ActiveRow.Cells["PRDCR_NO"].Text.Trim();
            string checkNo = ultraGrid4.ActiveRow.Cells["CHECK_NO"].Text.Trim();

            QueryCheckConsignJGDetail_Log(PRDCR_NO);
            QueryCheckConsignDetail(checkNo,"2");

            foreach (UltraGridRow ugr in this.ultraGrid5.Rows)
            {
                ugr.Cells["CHK"].Value = true;
            }
        }

        //监制人员放弃监制
        /// <summary>
        /// 监制人员放弃监制
        /// </summary>
        private void CancelProUpdateCheckConsignDetail()
        {
            try
            {
                if (dataTable4 == null || dataTable4.Rows.Count == 0 || dataTable5 == null || dataTable5.Rows.Count == 0)
                {
                    return;
                }

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

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

                ultraGrid5.UpdateData();
                DataRow[] arrBase = dataTable5.Select("CHK = 'True' AND FLAG = '已通知监制'");
                if (arrBase == null || arrBase.Length == 0)
                {
                    MessageUtil.ShowTips("请至少勾选一条状态为已通知监制的检验信息！");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否监制取消？") == DialogResult.Yes)
                {
                    string strCHECK_NO = ultraGrid4.ActiveRow.Cells["CHECK_NO"].Text.Trim();
                    string strTime = DateTime.Now.ToString();
                    string strRemark = "监制取消(" + UserInfo.GetUserName() + " " + strTime + ")";
                    foreach (DataRow row in arrBase)
                    {
                        alBaseParams = new ArrayList();//增加要更新的基础标志位信息
                        alBaseParams.Add("2");
                        alBaseParams.Add(strRemark);//通知人
                        alBaseParams.Add(strRemark);//收样时间
                        alBaseParams.Add("1");//状态位还是1
                        //alBaseParams.Add(row["PHY_CODE_MAX"].ToString());
                        alBaseParams.Add(row["DEPT_ID"].ToString());
                        alBaseParams.Add(strCHECK_NO);
                        alBase.Add(alBaseParams);
                    }

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

                    QueryCheckConsignBase();
                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, "CHECK_NO", strCHECK_NO);
                    QueryCheckConsignBase_Log();
                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid4, "CHECK_NO", strCHECK_NO);

                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid4, "CHECK_NO", strCHECK_NO);

                    MessageUtil.ShowTips("监制取消成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        //监制已到
        /// <summary>
        /// 监制已到
        /// </summary>
        private void ComeOnUpdateCheckConsignDetail()
        {
            try
            {
                if (dataTable4 == null || dataTable4.Rows.Count == 0 || dataTable5 == null || dataTable5.Rows.Count == 0)
                {
                    return;
                }

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

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

                ultraGrid4.UpdateData();
                ultraGrid5.UpdateData();
                DataRow[] arrBase = dataTable5.Select("CHK = 'True'");
                if (arrBase == null || arrBase.Length == 0)
                {
                    MessageUtil.ShowTips("请至少勾选一条需要通知的检验信息！");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认监制已到？") == DialogResult.Yes)
                {
                    string strCHECK_NO = ultraGrid4.ActiveRow.Cells["CHECK_NO"].Text.Trim();
                    string strTime = DateTime.Now.ToString();
                    foreach (DataRow row in arrBase)
                    {
                        alBaseParams = new ArrayList();//增加要更新的基础标志位信息
                        alBaseParams.Add("3");
                        alBaseParams.Add(UserInfo.GetUserName());//通知人
                        alBaseParams.Add(strTime);//收样时间
                        alBaseParams.Add("1");
                        //alBaseParams.Add(row["PHY_CODE_MAX"].ToString());
                        alBaseParams.Add(row["DEPT_ID"].ToString());
                        alBaseParams.Add(strCHECK_NO);
                        alBase.Add(alBaseParams);
                    }

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

                    //QueryCheckConsignBase();
                    QueryCheckConsignBase_Log();

                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid4, "CHECK_NO", strCHECK_NO);

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

        //监制完成
        /// <summary>
        /// 监制完成
        /// </summary>
        private void EndUpdateCheckConsignDetail()
        {
            try
            {
                if (dataTable4 == null || dataTable4.Rows.Count == 0 || dataTable5 == null || dataTable5.Rows.Count == 0)
                {
                    return;
                }

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

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

                ultraGrid5.UpdateData();
                DataRow[] arrBase = dataTable5.Select("CHK = 'True' AND FLAG = '已通知监制'");
                if (arrBase == null || arrBase.Length == 0)
                {
                    MessageUtil.ShowTips("请至少勾选一条状态为已通知监制的检验信息！");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认监制完成？") == DialogResult.Yes)
                {
                    string strCHECK_NO = ultraGrid4.ActiveRow.Cells["CHECK_NO"].Text.Trim();
                    string strTime = DateTime.Now.ToString();

                    string strRemark = "监制完成(" + UserInfo.GetUserName() + " " + strTime + ")";
                    foreach (DataRow row in arrBase)
                    {
                        alBaseParams = new ArrayList();//增加要更新的基础标志位信息
                        alBaseParams.Add("3");
                        alBaseParams.Add(strRemark);//通知人
                        alBaseParams.Add(strRemark);//收样时间
                        alBaseParams.Add("1");
                        //alBaseParams.Add(row["PHY_CODE_MAX"].ToString());
                        alBaseParams.Add(row["DEPT_ID"].ToString());
                        alBaseParams.Add(strCHECK_NO);
                        alBase.Add(alBaseParams);
                    }

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

                    //QueryCheckConsignBase();
                    QueryCheckConsignBase_Log();

                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid4, "CHECK_NO", strCHECK_NO);
                    //视图展示 显而易见的看出通知状态
                    MessageUtil.ShowTips("操作成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        /// <summary>
        /// 监制通知撤回
        /// </summary>
        private void CancelUpdateCheckConsignDetail()
        {
            try
            {
                if (dataTable4 == null || dataTable4.Rows.Count == 0 || dataTable5 == null || dataTable5.Rows.Count == 0)
                {
                    return;
                }

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

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

                ultraGrid5.UpdateData();
                DataRow[] arrBase = dataTable5.Select("CHK = 'True' AND FLAG = '已通知监制'");
                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 = this.Text + "监制通知撤回由于" + strRemark + "(" + user + " " + strDate + ")";

                string strCHECK_NO = ultraGrid4.ActiveRow.Cells["CHECK_NO"].Text.Trim();
                //string strTime = DateTime.Now.ToString();
                foreach (DataRow row in arrBase)
                {
                    alBaseParams = new ArrayList();//增加要更新的基础标志位信息
                    alBaseParams.Add("0");
                    alBaseParams.Add(strRemark);//通知人
                    alBaseParams.Add(strRemark);//收样时间
                    alBaseParams.Add("1");
                    //alBaseParams.Add(row["PHY_CODE_MAX"].ToString());
                    alBaseParams.Add(row["DEPT_ID"].ToString());
                    alBaseParams.Add(strCHECK_NO);
                    alBase.Add(alBaseParams);
                }

                //操作状态可变更，取消操作的时候灵活运用此方法
                PublicServer.SetData("com.steering.lims.data.pipe.FrmPipeProducerNotice.UpdateCheckConsignDetail",
                        new Object[] { alBase }, this.ob);

                QueryCheckConsignBase_Log();
                //QueryCheckConsignBase();
                PublicPipeAndOutdec.ActiveOperateRow(ultraGrid4, "CHECK_NO", strCHECK_NO);

                MessageUtil.ShowTips("监制通知撤回成功！");
                //监制信息需要打印，对于需要监制的项目打印出来

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

        /// <summary>
        /// 监制通知完毕撤回
        /// </summary>
        private void UpdateNoticeReturn()
        {
            try
            {
                ultraGrid5.UpdateData();
                IQueryable<UltraGridRow> checkMagRows = this.ultraGrid5.Rows.AsQueryable().Where(" CHK = 'True'");

                if (checkMagRows == null || checkMagRows.Count() == 0)
                {
                    MessageUtil.ShowTips("请至少勾选一条需要通知的检验信息！");
                    return;
                }

                string user = UserInfo.GetUserName();

                string strCHECK_NO = ultraGrid4.ActiveRow.Cells["CHECK_NO"].Text.Trim();
                string strFlag = "0";

                ArrayList parm = new ArrayList();
                foreach (UltraGridRow uRow in checkMagRows)
                {
                    SlmOrderLinePrdcrLstEntity matZcEntity = (SlmOrderLinePrdcrLstEntity)uRow.ListObject;
                    string matZcTity = JSONFormat.Format(matZcEntity);
                    parm.Add(matZcTity);

                }

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.lims.data.pipe.FrmPipeProducerNotice";
                ccp.MethodName = "UpdateCheckConsignDetailNew";
                ccp.ServerParams = new object[] { parm, strCHECK_NO, strFlag, user };
                ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnInfo == "监制通知撤回成功！")
                {
                    MessageUtil.ShowTips("监制通知撤回成功！");
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            

                QueryCheckConsignBase_Log();

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

       

        //监制取消撤回操作
        /// <summary>
        /// 监制取消撤回操作
        /// </summary>
        private void CancelCancelProUpdateCheckConsignDetail()
        {
            try
            {
                if (dataTable4 == null || dataTable4.Rows.Count == 0 || dataTable5 == null || dataTable5.Rows.Count == 0)
                {
                    return;
                }

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

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

                ultraGrid5.UpdateData();
                DataRow[] arrBase = dataTable5.Select("CHK = 'True' AND FLAG = '监制取消'");
                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 = this.Text + "监制取消撤回由于" + strRemark + "(" + user + " " + strDate + ")";

                string strCHECK_NO = ultraGrid4.ActiveRow.Cells["CHECK_NO"].Text.Trim();

                foreach (DataRow row in arrBase)
                {
                    alBaseParams = new ArrayList();//增加要更新的基础标志位信息
                    alBaseParams.Add("1");
                    alBaseParams.Add(strRemark);//通知人
                    alBaseParams.Add(strRemark);//收样时间
                    alBaseParams.Add("2");
                    //alBaseParams.Add(row["PHY_CODE_MAX"].ToString());
                    alBaseParams.Add(row["DEPT_ID"].ToString());
                    alBaseParams.Add(strCHECK_NO);
                    alBase.Add(alBaseParams);
                }

                //操作状态可变更，取消操作的时候灵活运用此方法
                PublicServer.SetData("com.steering.lims.data.pipe.FrmPipeProducerNotice.UpdateCheckConsignDetail",
                        new Object[] { alBase }, this.ob);

                QueryCheckConsignBase_Log();
                //QueryCheckConsignBase();

                PublicPipeAndOutdec.ActiveOperateRow(ultraGrid4, "CHECK_NO", strCHECK_NO);

                MessageUtil.ShowTips("监制取消撤回成功！");
                //监制信息需要打印，对于需要监制的项目打印出来
                //}
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        //取消监制来
        /// <summary>
        /// 取消监制来
        /// </summary>
        private void CancelComeOnUpdateCheckConsignDetail()
        {
            try
            {
                if (dataTable4 == null || dataTable4.Rows.Count == 0 || dataTable5 == null || dataTable5.Rows.Count == 0)
                {
                    return;
                }

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

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

                ultraGrid5.UpdateData();
                DataRow[] arrBase = dataTable5.Select("CHK = 'True'");
                if (arrBase == null || arrBase.Length == 0)
                {
                    MessageUtil.ShowTips("请至少勾选一条需要取消的信息！");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认取消？") == DialogResult.Yes)
                {
                    string strCHECK_NO = ultraGrid4.ActiveRow.Cells["CHECK_NO"].Text.Trim();
                    string strTime = DateTime.Now.ToString();
                    foreach (DataRow row in arrBase)
                    {
                        alBaseParams = new ArrayList();//增加要更新的基础标志位信息
                        alBaseParams.Add("0");
                        alBaseParams.Add(UserInfo.GetUserName());//通知人
                        alBaseParams.Add(strTime);//收样时间
                        alBaseParams.Add("1");
                        //alBaseParams.Add(row["PHY_CODE_MAX"].ToString());
                        alBaseParams.Add(row["DEPT_ID"].ToString());
                        alBaseParams.Add(strCHECK_NO);
                        alBase.Add(alBaseParams);
                    }

                    //操作状态可变更，取消操作的时候灵活运用此方法
                    PublicServer.SetData("com.steering.lims.data.pipe.FrmPipeProducerNotice.UpdateCheckConsignDetail",
                            new Object[] { alBase }, this.ob);

                    QueryCheckConsignBase_Log();
                    //QueryCheckConsignBase();

                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid4, "CHECK_NO", strCHECK_NO);

                    MessageUtil.ShowTips("取消成功！");
                    //监制信息需要打印，对于需要监制的项目打印出来
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        //监制完成撤回操作
        /// <summary>
        /// 监制完成撤回操作
        /// </summary>
        private void CancelEndUpdateCheckConsignDetail()
        {
            try
            {
                if (dataTable4 == null || dataTable4.Rows.Count == 0 || dataTable5 == null || dataTable5.Rows.Count == 0)
                {
                    return;
                }

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

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

                ultraGrid5.UpdateData();
                DataRow[] arrBase = dataTable5.Select("CHK = 'True' AND FLAG = '监制完成'");
                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 = this.Text + "监制取消撤回由于" + strRemark + "(" + user + " " + strDate + ")";

                    string strCHECK_NO = ultraGrid4.ActiveRow.Cells["CHECK_NO"].Text.Trim();
                    //string strTime = DateTime.Now.ToString();
                    foreach (DataRow row in arrBase)
                    {
                        alBaseParams = new ArrayList();//增加要更新的基础标志位信息
                        alBaseParams.Add("1");
                        alBaseParams.Add(strRemark);//通知人
                        alBaseParams.Add(strRemark);//收样时间
                        alBaseParams.Add("3");
                        //alBaseParams.Add(row["PHY_CODE_MAX"].ToString());
                        alBaseParams.Add(row["DEPT_ID"].ToString());
                        alBaseParams.Add(strCHECK_NO);
                        alBase.Add(alBaseParams);
                    }

                    //操作状态可变更，取消操作的时候灵活运用此方法
                    PublicServer.SetData("com.steering.lims.data.pipe.FrmPipeProducerNotice.UpdateCheckConsignDetail",
                            new Object[] { alBase }, this.ob);

                    QueryCheckConsignBase_Log();
                    //QueryCheckConsignBase();

                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid4, "CHECK_NO", strCHECK_NO);

                    MessageUtil.ShowTips("监制完成撤回成功！");
                    //监制信息需要打印，对于需要监制的项目打印出来
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

       /// <summary>
       /// 颜色
       /// </summary>
       /// <param name="ultraGrid"></param>
        private void ChangeColor(UltraGrid ultraGrid)
        {
            if (ultraGrid.DisplayLayout.Bands[0].Columns.Exists("PRDCR_FLAG"))
            {
                foreach (UltraGridRow dr in ultraGrid.Rows)
                {
                    if (dr.Cells["PRDCR_FLAG"].Text.Trim() == "监制到场")
                    {
                        dr.Appearance.BackColor = Color.LightGreen;//LightGray灰色
                    }
                    else if (dr.Cells["PRDCR_FLAG"].Text.Trim() == "")
                    {
                        dr.Appearance.BackColor = Color.White;//LightGray白色
                    }
                }
            }
        }

       

        #endregion

        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("NoticeDept"))
                {
                    this.toolMenu.Toolbars[0].Tools["NoticeDept"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("NoticeDeptReturn"))
                {
                    this.toolMenu.Toolbars[0].Tools["NoticeDeptReturn"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Notice"))
                {
                    this.toolMenu.Toolbars[0].Tools["Notice"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("NoticeReturn"))
                {
                    this.toolMenu.Toolbars[0].Tools["NoticeReturn"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelPro"))
                {
                    this.toolMenu.Toolbars[0].Tools["CancelPro"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelProReturn"))
                {
                    this.toolMenu.Toolbars[0].Tools["CancelProReturn"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("End"))
                {
                    this.toolMenu.Toolbars[0].Tools["End"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("EndReturn"))
                {
                    this.toolMenu.Toolbars[0].Tools["EndReturn"].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("NoticeDept"))
                {
                    this.toolMenu.Toolbars[0].Tools["NoticeDept"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("NoticeDeptReturn"))
                {
                    this.toolMenu.Toolbars[0].Tools["NoticeDeptReturn"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Notice"))
                {
                    this.toolMenu.Toolbars[0].Tools["Notice"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("NoticeReturn"))
                {
                    this.toolMenu.Toolbars[0].Tools["NoticeReturn"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelPro"))
                {
                    this.toolMenu.Toolbars[0].Tools["CancelPro"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelProReturn"))
                {
                    this.toolMenu.Toolbars[0].Tools["CancelProReturn"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("End"))
                {
                    this.toolMenu.Toolbars[0].Tools["End"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("EndReturn"))
                {
                    this.toolMenu.Toolbars[0].Tools["EndReturn"].InstanceProps.Visible = DefaultableBoolean.True;
                }
            }
        }

        private void FrmPipeProducerNotice_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("NoticeDept"))
            {
                this.toolMenu.Toolbars[0].Tools["NoticeDept"].InstanceProps.Visible = DefaultableBoolean.True;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("NoticeDeptReturn"))
            {
                this.toolMenu.Toolbars[0].Tools["NoticeDeptReturn"].InstanceProps.Visible = DefaultableBoolean.True;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("Notice"))
            {
                this.toolMenu.Toolbars[0].Tools["Notice"].InstanceProps.Visible = DefaultableBoolean.True;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("NoticeReturn"))
            {
                this.toolMenu.Toolbars[0].Tools["NoticeReturn"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("CancelPro"))
            {
                this.toolMenu.Toolbars[0].Tools["CancelPro"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("CancelProReturn"))
            {
                this.toolMenu.Toolbars[0].Tools["CancelProReturn"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("End"))
            {
                this.toolMenu.Toolbars[0].Tools["End"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("EndReturn"))
            {
                this.toolMenu.Toolbars[0].Tools["EndReturn"].InstanceProps.Visible = DefaultableBoolean.False;
            }
        }
    }
}