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

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

namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec
{
    public partial class FrmJGSampleSend : FrmBase
    {
        private string[] arrId;//数据权限
        private string[] plineCodes = { };
        public FrmJGSampleSend()
        {
            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;

            pipeQueryBaseJGSend1.EnterHandler += QueryCheckConsignBaseDetail;
        }

        private void FrmJGSampleSend_Load(object sender, EventArgs e)
        {
            arrId = this.ValidDataPurviewIds;//获取数据权限
            plineCodes = comm.GetPlineCode(ValidDataPurviewIds, ob);
            pipeQueryBaseJGSend1.ShowControl();
            pipeQueryBaseJGSend1.UpdateControl("加工确认时间");
            InitColumns();
        }

        private void InitColumns()
        {
            publicUltraGridDetail1.InitColumnsPipeDetail(new string[] { "FLAG", "FLAG_DESC", "PHY_CODE_MAX", "ISPRODUCER", "IS_NOTICE_PRODUCER", "IS_NOTICE_PRODUCER_DESC", "ISRCL", "MERG_TIME", "JG_PRINT_COUNT", "JG_SEND_NAME", "JG_SEND_TIME", "LAB_RECEIVE_NAME", "LAB_RECEIVE_TIME", "FILE_PATH1", "FILE_PATH2", "FILE_PATH3", "FILE_PATH4", "TECHNICAL_STANDARD", "DEGREASING_METHOD", "NACE_PH", "NACE_PH_S", "NACE_PH_F", "NACE_SOLUTION_S", "NACE_SOLUTION_F", "TEST_TEMP", "SPECIMEN_SIZE1", "SPECIMEN_SIZE2", "SPECIMEN_SIZE3", "TEST_DURATION1", "TEST_DURATION2", "TEST_DURATION3", "PSEUDO_STRESS", "PROOF_RING_NO1", "PROOF_RING_NO2", "PROOF_RING_NO3", "YSMIN1", "YSMIN2", "YSMIN3", "ACTUAL_LOAD1", "ACTUAL_LOAD2", "ACTUAL_LOAD3", "ACTUAL_S_YSMIN1", "ACTUAL_S_YSMIN2", "ACTUAL_S_YSMIN3", "ARM_DISPLACEMENT1", "ARM_DISPLACEMENT2", "ARM_DISPLACEMENT3", "CRACK_LENGTH1", "CRACK_LENGTH2", "CRACK_LENGTH3", "NOTE", "STEP", "LOAD", "PRESSURE_MEDIUM", "INTERNAL_PRESSURE", "DOGLEG_DEGREE", "HOLD_TIME", "PIN", "BOX", "COMPOUND_TYPE", "COMPOUND_WEIGHT", "MAKE_UP_TORQUE", "TOTAL_TORQUE", "BREAK_OUT_TORQUE", "OBSERVED_RESULT" }, new string[] { "CHK", "TS_SAMPLE_REMARK", "TS_REMARK" }, false);

            publicUltraGridDetail2.InitColumnsPipeDetail(new string[] { "FLAG", "PHY_CODE_MAX", "ISPRODUCER", "IS_NOTICE_PRODUCER", "IS_NOTICE_PRODUCER_DESC", "ISRCL", "MERG_TIME", "FILE_PATH1", "FILE_PATH2", "FILE_PATH3", "FILE_PATH4", "TECHNICAL_STANDARD", "DEGREASING_METHOD", "NACE_PH", "NACE_PH_S", "NACE_PH_F", "NACE_SOLUTION_S", "NACE_SOLUTION_F", "TEST_TEMP", "SPECIMEN_SIZE1", "SPECIMEN_SIZE2", "SPECIMEN_SIZE3", "TEST_DURATION1", "TEST_DURATION2", "TEST_DURATION3", "PSEUDO_STRESS", "PROOF_RING_NO1", "PROOF_RING_NO2", "PROOF_RING_NO3", "YSMIN1", "YSMIN2", "YSMIN3", "ACTUAL_LOAD1", "ACTUAL_LOAD2", "ACTUAL_LOAD3", "ACTUAL_S_YSMIN1", "ACTUAL_S_YSMIN2", "ACTUAL_S_YSMIN3", "ARM_DISPLACEMENT1", "ARM_DISPLACEMENT2", "ARM_DISPLACEMENT3", "CRACK_LENGTH1", "CRACK_LENGTH2", "CRACK_LENGTH3", "NOTE", "STEP", "LOAD", "PRESSURE_MEDIUM", "INTERNAL_PRESSURE", "DOGLEG_DEGREE", "HOLD_TIME", "PIN", "BOX", "COMPOUND_TYPE", "COMPOUND_WEIGHT", "MAKE_UP_TORQUE", "TOTAL_TORQUE", "BREAK_OUT_TORQUE", "OBSERVED_RESULT" }, new string[] { "CHK", "TS_SAMPLE_REMARK", "TS_REMARK" }, false);

            publicUltraGridDetail3.InitColumnsPipeDetail(new string[] { "FLAG", "FLAG_DESC", "PHY_CODE_MAX", "ISPRODUCER", "IS_NOTICE_PRODUCER", "IS_NOTICE_PRODUCER_DESC", "ISRCL", "MERG_TIME", "JG_PRINT_COUNT", "JG_SEND_NAME", "JG_SEND_TIME", "LAB_RECEIVE_NAME", "LAB_RECEIVE_TIME", "FILE_PATH1", "FILE_PATH2", "FILE_PATH3", "FILE_PATH4", "TECHNICAL_STANDARD", "DEGREASING_METHOD", "NACE_PH", "NACE_PH_S", "NACE_PH_F", "NACE_SOLUTION_S", "NACE_SOLUTION_F", "TEST_TEMP", "SPECIMEN_SIZE1", "SPECIMEN_SIZE2", "SPECIMEN_SIZE3", "TEST_DURATION1", "TEST_DURATION2", "TEST_DURATION3", "PSEUDO_STRESS", "PROOF_RING_NO1", "PROOF_RING_NO2", "PROOF_RING_NO3", "YSMIN1", "YSMIN2", "YSMIN3", "ACTUAL_LOAD1", "ACTUAL_LOAD2", "ACTUAL_LOAD3", "ACTUAL_S_YSMIN1", "ACTUAL_S_YSMIN2", "ACTUAL_S_YSMIN3", "ARM_DISPLACEMENT1", "ARM_DISPLACEMENT2", "ARM_DISPLACEMENT3", "CRACK_LENGTH1", "CRACK_LENGTH2", "CRACK_LENGTH3", "NOTE", "STEP", "LOAD", "PRESSURE_MEDIUM", "INTERNAL_PRESSURE", "DOGLEG_DEGREE", "HOLD_TIME", "PIN", "BOX", "COMPOUND_TYPE", "COMPOUND_WEIGHT", "MAKE_UP_TORQUE", "TOTAL_TORQUE", "BREAK_OUT_TORQUE", "OBSERVED_RESULT" }, new string[] { "CHK", "TS_SAMPLE_REMARK", "TS_REMARK" }, false);
            publicUltraGridDetail4.InitColumnsPipeDetail(new string[] { "FLAG", "FLAG_DESC", "PHY_CODE_MAX", "ISPRODUCER", "IS_NOTICE_PRODUCER", "IS_NOTICE_PRODUCER_DESC", "ISRCL", "JG_PRINT_COUNT", "JG_SEND_NAME", "JG_SEND_TIME", "LAB_RECEIVE_NAME", "LAB_RECEIVE_TIME", "FILE_PATH1", "FILE_PATH2", "FILE_PATH3", "FILE_PATH4", "TECHNICAL_STANDARD", "DEGREASING_METHOD", "NACE_PH", "NACE_PH_S", "NACE_PH_F", "NACE_SOLUTION_S", "NACE_SOLUTION_F", "TEST_TEMP", "SPECIMEN_SIZE1", "SPECIMEN_SIZE2", "SPECIMEN_SIZE3", "TEST_DURATION1", "TEST_DURATION2", "TEST_DURATION3", "PSEUDO_STRESS", "PROOF_RING_NO1", "PROOF_RING_NO2", "PROOF_RING_NO3", "YSMIN1", "YSMIN2", "YSMIN3", "ACTUAL_LOAD1", "ACTUAL_LOAD2", "ACTUAL_LOAD3", "ACTUAL_S_YSMIN1", "ACTUAL_S_YSMIN2", "ACTUAL_S_YSMIN3", "ARM_DISPLACEMENT1", "ARM_DISPLACEMENT2", "ARM_DISPLACEMENT3", "CRACK_LENGTH1", "CRACK_LENGTH2", "CRACK_LENGTH3", "NOTE", "STEP", "LOAD", "PRESSURE_MEDIUM", "INTERNAL_PRESSURE", "DOGLEG_DEGREE", "HOLD_TIME", "PIN", "BOX", "COMPOUND_TYPE", "COMPOUND_WEIGHT", "MAKE_UP_TORQUE", "TOTAL_TORQUE", "BREAK_OUT_TORQUE", "OBSERVED_RESULT" }, new string[] { "CHK", "TS_SAMPLE_REMARK", "TS_REMARK" }, false);
            publicUltraGridDetail5.InitColumnsPipeDetail(new string[] { "FLAG", "FLAG_DESC", "PHY_CODE_MAX", "ISPRODUCER", "IS_NOTICE_PRODUCER", "IS_NOTICE_PRODUCER_DESC", "ISRCL", "JG_PRINT_COUNT", "JG_SEND_NAME", "JG_SEND_TIME", "LAB_RECEIVE_NAME", "LAB_RECEIVE_TIME", "FILE_PATH1", "FILE_PATH2", "FILE_PATH3", "FILE_PATH4", "TECHNICAL_STANDARD", "DEGREASING_METHOD", "NACE_PH", "NACE_PH_S", "NACE_PH_F", "NACE_SOLUTION_S", "NACE_SOLUTION_F", "TEST_TEMP", "SPECIMEN_SIZE1", "SPECIMEN_SIZE2", "SPECIMEN_SIZE3", "TEST_DURATION1", "TEST_DURATION2", "TEST_DURATION3", "PSEUDO_STRESS", "PROOF_RING_NO1", "PROOF_RING_NO2", "PROOF_RING_NO3", "YSMIN1", "YSMIN2", "YSMIN3", "ACTUAL_LOAD1", "ACTUAL_LOAD2", "ACTUAL_LOAD3", "ACTUAL_S_YSMIN1", "ACTUAL_S_YSMIN2", "ACTUAL_S_YSMIN3", "ARM_DISPLACEMENT1", "ARM_DISPLACEMENT2", "ARM_DISPLACEMENT3", "CRACK_LENGTH1", "CRACK_LENGTH2", "CRACK_LENGTH3", "NOTE", "STEP", "LOAD", "PRESSURE_MEDIUM", "INTERNAL_PRESSURE", "DOGLEG_DEGREE", "HOLD_TIME", "PIN", "BOX", "COMPOUND_TYPE", "COMPOUND_WEIGHT", "MAKE_UP_TORQUE", "TOTAL_TORQUE", "BREAK_OUT_TORQUE", "OBSERVED_RESULT" }, new string[] { "CHK", "TS_SAMPLE_REMARK", "TS_REMARK" }, false);

            //string[] arrColumns = new string[] { "CHK", "FLAG", "FLAG_DESC", "CHECK_NO", "SAMPLE_NO", "PHY_CODE_MAX", "PHY_NAME_MAX", "SAMPLE_COUNT", "IS_NOTICE_PRODUCER", "IS_NOTICE_PRODUCER_DESC", "ISRCL", "ISRCL_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", "SPEC_REQ", "REMARK", "SAMPLE_REMARK" };//"ISPRODUCER",
            //string[] arrCaption = new string[] { "选择", "状态", "状态", "检验编号", "样管号", "检验项代码", "检验项", "试样数", "是否监制", "是否监制", "热处理", "热处理", "送样人", "送样时间", "收样人", "收样时间", "炉号", "钢级", "钢号", "技术标准", "合同号", "外径", "壁厚", "委托单位", "委托人", "委托时间", "特殊要求", "备注", "来样操作备注" };//"是否监制",

            //publicUltraGridDetail1.InitColumns(arrColumns, arrCaption);
            //publicUltraGridDetail1.setColumnShowOrHidden(new string[] { "FLAG", "FLAG_DESC", "PHY_CODE_MAX", "IS_NOTICE_PRODUCER", "ISRCL", "JG_SEND_NAME", "JG_SEND_TIME", "LAB_RECEIVE_NAME", "LAB_RECEIVE_TIME" }, 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_NOTICE_PRODUCER", "ISRCL" }, false);
            //publicUltraGridDetail2.setOtherColumnReadOnly(new string[] { "CHK" });
            //publicUltraGridDetail2.Ug.DisplayLayout.Bands[0].Override.AllowAddNew = AllowAddNew.No;
        }

        /// <summary>
        /// 重写基类方法
        /// </summary>
        /// <param name="sender"></param> 
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            //查询、确认、退出
            switch (ToolbarKey)
            {
                case "Query":
                    QueryCheckConsignBaseDetail();
                    break;
                case "Send":
                    UpdateCheckConsignDetail();
                    break;
                case "SendSsc":
                    SendSsc("ssc","1");
                    break;
                case "SendHic":
                    SendSsc("hic","1");
                    break;
                case "SendSscGhy":
                    SendSsc("ssc", "2");
                    break;
                case "SendHicGhy":
                    SendSsc("hic", "2");
                    break;
                case "Save":
                    SaveCheckConsignDetail();
                    break;
                case "Cancel":
                    CancelUpdateCheckConsignDetail();
                    break;
                case "Print":
                    RepLimsPipeJGSampleSendPrint();
                    break;
                case "Export":
                    Export();
                    break;
                case "Close":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
                    {
                        this.Close();
                    }
                    break;
            }
        }

        private void Export()
        {
            string title = "管材加工试样下发" + ultraTabControl1.SelectedTab.Text;
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                publicUltraGridDetail1.Export(title);
            }else if (ultraTabControl1.SelectedTab.Index == 1)
            {
                publicUltraGridDetail2.Export(title);
            }
            else if (ultraTabControl1.SelectedTab.Index == 2)
            {
                publicUltraGridDetail3.Export(title);
            }
            else if (ultraTabControl1.SelectedTab.Index == 3)
            {
                publicUltraGridDetail4.Export(title);
            }
            else if (ultraTabControl1.SelectedTab.Index == 4)
            {
                publicUltraGridDetail5.Export(title);
            }
        }

        

        //查询检验委托基本信息
        /// <summary>
        /// 查询检验委托基本信息
        /// </summary>
        private void QueryCheckConsignBaseDetail()
        {
            try
            {
                PublicUltraGridDetail publicUltraGridDetail = publicUltraGridDetail1;
                string strFlag = "9";
                if (ultraTabControl1.SelectedTab.Index == 1)
                {
                    publicUltraGridDetail = publicUltraGridDetail2;
                    strFlag = "12345";

                }
                else if (ultraTabControl1.SelectedTab.Index == 2)
                {
                    publicUltraGridDetail = publicUltraGridDetail3;
                    strFlag = "9";
                }
                else if (ultraTabControl1.SelectedTab.Index == 3)
                {
                    publicUltraGridDetail = publicUltraGridDetail4;
                    strFlag = "9";
                }
                else if (ultraTabControl1.SelectedTab.Index == 4)
                {
                    publicUltraGridDetail = publicUltraGridDetail5;
                    strFlag = "12345";
                }
                ArrayList al = pipeQueryBaseJGSend1.GetQueryInfo(strFlag);
                al.Add(publicUltraDept_ID.UltDept_ID);
                al.Add(publicUltraDept_ID.UltDept_ID);
                al.Add(publicUltraDept_ID.UltDept_ID);
                al.Add(plineCodes);
                al.Add(this.CustomInfo.ToString());
                if (ultraTabControl1.SelectedTab.Index == 0 || ultraTabControl1.SelectedTab.Index == 1)
                {
                    publicUltraGridDetail.QueryCheckConsignBaseDetail("pipe.FrmJGSampleSend", al, this.ob, null);
                }
                else if (ultraTabControl1.SelectedTab.Index == 2)
                {
                    publicUltraGridDetail.QueryCheckConsignBaseDetailResample("pipe.FrmJGSampleSend", al, this.ob, null);
                }
                else if (ultraTabControl1.SelectedTab.Index == 3 || ultraTabControl1.SelectedTab.Index == 4)
                {
                    publicUltraGridDetail.QueryCheckConsignBaseDetailSSC("pipe.FrmJGSampleSend", al, this.ob, null);
                }
                

                PublicPipeAndOutdec.RefreshAndAutoSizeColumns(publicUltraGridDetail.Ug, new string[] { "PHY_NAME_MAX", "PRODUCT_STD", "SAMPLE_REMARK" }, false);//刷新Grid
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        #region 未确认

        /// <summary>
        /// 保存备注
        /// </summary>
        private void SaveCheckConsignDetail()
        {
            try
            {
                PublicUltraGridDetail publicUltraGridDetail = null;
                if (ultraTabControl1.SelectedTab.Index == 0)
                {
                    publicUltraGridDetail = publicUltraGridDetail1;
                }
                else if (ultraTabControl1.SelectedTab.Index == 1)
                {
                    publicUltraGridDetail = publicUltraGridDetail2;
                }
                else if (ultraTabControl1.SelectedTab.Index == 2)
                {
                    publicUltraGridDetail = publicUltraGridDetail3;
                }
                else if (ultraTabControl1.SelectedTab.Index == 3)
                {
                    publicUltraGridDetail = publicUltraGridDetail4;
                }
                else if (ultraTabControl1.SelectedTab.Index == 4)
                {
                    publicUltraGridDetail = publicUltraGridDetail5;
                }
                if (publicUltraGridDetail.Ug == null || publicUltraGridDetail.Ug.Rows.Count == 0)
                {
                    return;
                }

                publicUltraGridDetail.Ug.UpdateData();
                DataRow[] arrBase = publicUltraGridDetail.DataTable.Select("CHK = 'True' ");
                if (arrBase == null || arrBase.Length == 0)
                {
                    MessageUtil.ShowTips("请勾选要保存的备注信息！");
                    return;
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否保存备注？") == DialogResult.Yes)
                {
                    ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息
                    ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
                    foreach (DataRow row in arrBase)
                    {
                        alBaseParams = new ArrayList();//增加要更新的基础标志位信息
                        alBaseParams.Add(row["TS_SAMPLE_REMARK"].ToString());//工艺特殊要求备注
                        alBaseParams.Add(row["TS_REMARK"].ToString()); //试样特殊要求备注
                        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.FrmJGSampleSend.SaveCheckConsignDetail",
                    new Object[] { alBase }, ob);
                    QueryCheckConsignBaseDetail();

                    MessageUtil.ShowTips("保存成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }
        private void SendSsc(string jyType,string sendType)
        {
            try
            {
                PublicUltraGridDetail publicUltraGridDetail = null;
                 if (ultraTabControl1.SelectedTab.Index == 3)
                {
                    publicUltraGridDetail = publicUltraGridDetail4;
                }
                if (ultraTabControl1.SelectedTab.Index == 4)
                {
                    publicUltraGridDetail = publicUltraGridDetail5;
                }
                if (ultraTabControl1.SelectedTab.Index == 0)
                {
                    publicUltraGridDetail = publicUltraGridDetail1;
                }
                if (ultraTabControl1.SelectedTab.Index == 1)
                {
                    publicUltraGridDetail = publicUltraGridDetail2;

                }
                 if (publicUltraGridDetail.Ug == null || publicUltraGridDetail.Ug.Rows.Count == 0)
                 {
                     return;
                 }
                //publicUltraGridDetail.Ug.UpdateData();
                //ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息
                //ArrayList alBaseParams = new ArrayList();
                //alBaseParams.Add("91A250106081");
                //alBase.Add(alBaseParams);
                //PublicServer.SetData("com.steering.mes.port.mil.FrmMilBatchSampleNew.PipeCheckconsignAdd",
                //   new Object[] { alBase }, ob);
                //MessageUtil.ShowTips("试样下发成功！");

                 DataRow[] arrBase = publicUltraGridDetail.DataTable.Select("CHK = 'True'");
                 if (arrBase == null || arrBase.Length == 0)
                 {
                     MessageUtil.ShowTips("请勾选状态为未下发的检验信息！");
                     return;
                 }
                 if (MessageUtil.ShowYesNoAndQuestion("是否发送到产销？") == DialogResult.Yes)
                 {
                     ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息
                     ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
                     foreach (DataRow row in arrBase)
                     {
                         alBaseParams = new ArrayList();//增加要更新的基础标志位信息
                         alBaseParams.Add(row["CHECK_NO"].ToString());

                         alBase.Add(alBaseParams);

                     }
                     CoreClientParam ccp = new CoreClientParam();
                     ccp.ServerName = "com.steering.mes.port.mil.FrmMilBatchSampleNew";
                     ccp.MethodName = "PipeCheckconsignAdd";
                     ccp.ServerParams = new object[] { alBase, jyType, sendType };
                     ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                     if (ccp.ReturnCode != -1)
                     {
                         if (ccp.ReturnInfo.Equals("SSC下发成功！!"))
                         {
                             QueryCheckConsignBaseDetail();
                             MessageUtil.ShowTips(ccp.ReturnInfo);
                         }
                         else
                         {
                             MessageUtil.ShowTips(ccp.ReturnInfo);
                         }
                     }
                 }


            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }
        //确认来样,更新检验委托加工信息2015-08-03修改为一个检验编号确认
        /// <summary>
        /// 试样下发
        /// </summary>
        private void UpdateCheckConsignDetail()
        {
            try
            {
                PublicUltraGridDetail publicUltraGridDetail = null;
                if (ultraTabControl1.SelectedTab.Index == 0)
                {
                    publicUltraGridDetail = publicUltraGridDetail1;
                }
                else if (ultraTabControl1.SelectedTab.Index == 2)
                {
                    publicUltraGridDetail = publicUltraGridDetail3;
                }
                else if (ultraTabControl1.SelectedTab.Index == 3)
                {
                    publicUltraGridDetail = publicUltraGridDetail4;
                }
                if (publicUltraGridDetail.Ug == null || publicUltraGridDetail.Ug.Rows.Count == 0)
                {
                    return;
                }

                //if (ultraTabControl1.SelectedTab.Index != 0)
                //{
                //    MessageUtil.ShowTips("只有选择了未下发页才能进行试样下发操作！");
                //    return;
                //}

                publicUltraGridDetail.Ug.UpdateData();
                DataRow[] arrBase = publicUltraGridDetail.DataTable.Select("CHK = 'True' AND FLAG = '9'");
                if (arrBase == null || arrBase.Length == 0)
                {
                    MessageUtil.ShowTips("请勾选状态为未下发的检验信息！");
                    return;
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否试样下发？") == DialogResult.Yes)
                {

                    string user = UserInfo.GetUserName();
                    string strDate = DateTime.Now.ToString();
                    string shift = UserInfo.GetUserOrder();
                    string group = UserInfo.GetUserGroup();
                    ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息
                    ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
                    foreach (DataRow row in arrBase)
                    {
                        alBaseParams = new ArrayList();//增加要更新的基础标志位信息
                        alBaseParams.Add("1");
                        alBaseParams.Add(user);//下发人
                        alBaseParams.Add(strDate);//下发时间
                        alBaseParams.Add(shift);//下发人班次
                        alBaseParams.Add(group);//下发人班组
                        alBaseParams.Add("");
                        alBaseParams.Add("");//样品备注row["SAMPLE_REMARK"].ToString()
                        alBaseParams.Add("9");
                        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.FrmJGSampleSend.UpdatePipeCheckConsignDetail",
                    new Object[] { alBase }, ob);
                    //publicUltraGridDetail1.UpdateCheckConsignDetail("pipe.FrmJGSampleSend", this.ob, arrBase, "1", user, strDate, "9", "");

                    
                    QueryCheckConsignBaseDetail();

                    MessageUtil.ShowTips("试样下发成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }
        #endregion

        #region 已确认
        private void CancelUpdateCheckConsignDetail()
        {
            try
            {
                PublicUltraGridDetail publicUltraGridDetail = publicUltraGridDetail1;
                if (ultraTabControl1.SelectedTab.Index == 1)
                {
                    publicUltraGridDetail = publicUltraGridDetail2;
                }
                else if (ultraTabControl1.SelectedTab.Index == 4)
                {
                    publicUltraGridDetail = publicUltraGridDetail5;
                }
                if (publicUltraGridDetail.Ug == null || publicUltraGridDetail.Ug.Rows.Count == 0)
                {
                    return;
                }

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

                publicUltraGridDetail.Ug.UpdateData();
                DataRow[] arrBase = publicUltraGridDetail.DataTable.Select("CHK = 'True' AND FLAG = '1'");
                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 + ")";
                ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息
                ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
                foreach (DataRow row in arrBase)
                {
                    alBaseParams = new ArrayList();//增加要更新的基础标志位信息
                    alBaseParams.Add("9");
                    alBaseParams.Add("");//下发人
                    alBaseParams.Add("");//下发时间
                    alBaseParams.Add("");//下发人班次
                    alBaseParams.Add("");//下发人班组
                    alBaseParams.Add(strRemark);
                    alBaseParams.Add(strRemark);//样品备注row["SAMPLE_REMARK"].ToString()
                    alBaseParams.Add("1");
                    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.FrmJGSampleSend.UpdatePipeCheckConsignDetail",
                new Object[] { alBase }, ob);
                //publicUltraGridDetail2.UpdateCheckConsignDetail("pipe.FrmJGSampleSend", this.ob, arrBase, "9", "", "", "1", strRemark);

                QueryCheckConsignBaseDetail();

                MessageUtil.ShowTips("取消下发成功！");
                //}
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }
        #endregion

        /// <summary>
        ///打印
        /// </summary>
        /// <param name="publicUltraGridDetail"></param>
        private void RepLimsPipeJGSampleSendPrint()
        {
            try
            {
                PublicUltraGridDetail publicUltraGridDetail = null;
                if (ultraTabControl1.SelectedTab.Index == 0)
                {
                    publicUltraGridDetail = publicUltraGridDetail1;
                }
                else if (ultraTabControl1.SelectedTab.Index == 1)
                {
                    publicUltraGridDetail = publicUltraGridDetail2;
                }
                else if (ultraTabControl1.SelectedTab.Index == 2)
                {
                    publicUltraGridDetail = publicUltraGridDetail3;
                }
                else if (ultraTabControl1.SelectedTab.Index == 3)
                {
                    publicUltraGridDetail = publicUltraGridDetail4;
                }
                else if (ultraTabControl1.SelectedTab.Index == 4)
                {
                    publicUltraGridDetail = publicUltraGridDetail5;
                }

                this.Cursor = Cursors.WaitCursor;

                publicUltraGridDetail.Ug.UpdateData();
                DataRow[] arrBase = publicUltraGridDetail.DataTable.Select("CHK = 'True'");

                if (arrBase == null || arrBase.Length == 0)
                {
                    MessageUtil.ShowWarning("请选择您要打印的样品下发明细单！");
                    return;
                }
                string strCHECK_NO = "";

                ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息
                ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
                foreach (DataRow row in arrBase)
                {
                    strCHECK_NO += "'" + row["CHECK_NO"].ToString() + row["SAMPLE_NO"].ToString() + row["PHY_CODE_MAX"].ToString() + "',";

                    alBaseParams = new ArrayList();//增加要更新的基础标志位信息
                    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.FrmJGSampleSend.UpdatePipeJGPrintCount",
                new Object[] { alBase }, ob);
                
                
                strCHECK_NO = strCHECK_NO.Remove(0, 1);
                strCHECK_NO = strCHECK_NO.Remove(strCHECK_NO.Length - 2);

                string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsPipeJGSampleSend.cpt&bypagesize=false" + "&CHECK_NO=" + strCHECK_NO;

                FrmRepExcel fBug = new FrmRepExcel(ob, strurl);
                fBug.AutoSize = true;
                fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
                fBug.WindowState = FormWindowState.Maximized;
                fBug.Text = "加工样品下发明细单";
                fBug.Show();

                QueryCheckConsignBaseDetail();
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }

        private void FrmJGSampleSend_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("Send"))
            {
                toolMenu.Toolbars[0].Tools["Send"].InstanceProps.Visible = DefaultableBoolean.True;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("Cancel"))
            {
                toolMenu.Toolbars[0].Tools["Cancel"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("Print"))
            {
                toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("SendSsc"))
            {
                toolMenu.Toolbars[0].Tools["SendSsc"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("SendSscGhy"))
            {
                toolMenu.Toolbars[0].Tools["SendSscGhy"].InstanceProps.Visible = DefaultableBoolean.False;
            }
        }

        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (toolMenu == null) return;
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Query"))
                {
                    toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Send"))
                {
                    toolMenu.Toolbars[0].Tools["Send"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SendSsc"))
                {
                    toolMenu.Toolbars[0].Tools["SendSsc"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SendHic"))
                {
                    toolMenu.Toolbars[0].Tools["SendHic"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SendSscGhy"))
                {
                    toolMenu.Toolbars[0].Tools["SendSscGhy"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SendHicGhy"))
                {
                    toolMenu.Toolbars[0].Tools["SendHicGhy"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Cancel"))
                {
                    toolMenu.Toolbars[0].Tools["Cancel"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    toolMenu.Toolbars[0].Tools["Print"].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("Send"))
                {
                    toolMenu.Toolbars[0].Tools["Send"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SendSsc"))
                {
                    toolMenu.Toolbars[0].Tools["SendSsc"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SendHic"))
                {
                    toolMenu.Toolbars[0].Tools["SendHic"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SendSscGhy"))
                {
                    toolMenu.Toolbars[0].Tools["SendSscGhy"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SendHicGhy"))
                {
                    toolMenu.Toolbars[0].Tools["SendHicGhy"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Cancel"))
                {
                    toolMenu.Toolbars[0].Tools["Cancel"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.True;
                }
            }
            else if (ultraTabControl1.SelectedTab.Index == 2)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Query"))
                {
                    toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Send"))
                {
                    toolMenu.Toolbars[0].Tools["Send"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SendSsc"))
                {
                    toolMenu.Toolbars[0].Tools["SendSsc"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SendHic"))
                {
                    toolMenu.Toolbars[0].Tools["SendHic"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SendSscGhy"))
                {
                    toolMenu.Toolbars[0].Tools["SendSscGhy"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SendHicGhy"))
                {
                    toolMenu.Toolbars[0].Tools["SendHicGhy"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Cancel"))
                {
                    toolMenu.Toolbars[0].Tools["Cancel"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.True;
                }
            }
            else if (ultraTabControl1.SelectedTab.Index == 3)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Query"))
                {
                    toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Send"))
                {
                    toolMenu.Toolbars[0].Tools["Send"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SendSsc"))
                {
                    toolMenu.Toolbars[0].Tools["SendSsc"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SendHic"))
                {
                    toolMenu.Toolbars[0].Tools["SendHic"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SendSscGhy"))
                {
                    toolMenu.Toolbars[0].Tools["SendSscGhy"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SendHicGhy"))
                {
                    toolMenu.Toolbars[0].Tools["SendHicGhy"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Cancel"))
                {
                    toolMenu.Toolbars[0].Tools["Cancel"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.True;
                }
            }
            else if (ultraTabControl1.SelectedTab.Index == 4)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Query"))
                {
                    toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Send"))
                {
                    toolMenu.Toolbars[0].Tools["Send"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SendSsc"))
                {
                    toolMenu.Toolbars[0].Tools["SendSsc"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SendHic"))
                {
                    toolMenu.Toolbars[0].Tools["SendHic"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SendSscGhy"))
                {
                    toolMenu.Toolbars[0].Tools["SendSscGhy"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SendHicGhy"))
                {
                    toolMenu.Toolbars[0].Tools["SendHicGhy"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Cancel"))
                {
                    toolMenu.Toolbars[0].Tools["Cancel"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.True;
                }
            }
            QueryCheckConsignBaseDetail();
        }

        private void chkDEPT_ID_CheckedChanged(object sender, EventArgs e)
        {
            this.publicUltraDept_ID.Enabled = this.chkDEPT_ID.Checked;
        }
    }
}