MES_Client/TGMES/Core.StlMes.Client.Lims.Data.PipeAndOutdec/数据管理/钢管实验管理/FrmLabSampleConfirm.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 Infragistics.Win;
using System.Collections;
using Core.Mes.Client.Comm.Server;

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

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

        private void InitColumns()
        {
            //是否小样热处理
            string[] arrColumns = new string[] { "CHK", "ISRCL", "ISRCL_DESC", "FLAG", "FLAG_DESC", "CHECK_NO", "SAMPLE_NO", "SAMPLE_NO_MIN", "PHY_CODE_MAX", "PHY_NAME_MAX", "ITEM_NAME_S", "INSERT_FLAG", "LAB_PRINT_COUNT", "SAMPLE_COUNT", "IS_RUSH", "ISPRODUCER", "ISPRODUCER_DESC", "CRAFT_SOURCE", "IS_NOTICE_PRODUCER", "IS_NOTICE_PRODUCER_DESC", "JG_SEND_NAME", "JG_SEND_TIME", "LAB_RECEIVE_NAME", "LAB_RECEIVE_TIME", "HEAT_NO", "STEEL_GRADE", "STEEL_NO", "PRODUCT_STD", "CONTRACT_NO", "CRAFT_PATH", "DIMATER", "HEIGHT", "CONSIGN_DEPT", "CONSIGN_NAME", "CONSIGN_TIME", "SPEC_REQ", "REMARK", "SAMPLE_REMARK", "AUDIT_TIME", "DEPT_ID" };//"ISPRODUCER",
            string[] arrCaption = new string[] { "选择", "热处理状态", "热处理状态", "状态", "状态", "检验编号", "试样号", "钢印号", "检验项代码", "检验项", "试样尺寸", "加入试验项目", "打印次数", "试样数", "是否加急", "是否监制", "是否监制", "委托类型", "通知监制", "通知监制", "送样人", "送样时间", "收样人", "收样时间", "炉号", "钢级", "钢号", "技术标准", "合同号", "工艺文件路径", "外径", "壁厚", "委托单位", "委托人", "委托时间", "特殊要求", "备注", "来样操作备注", "审核时间", "所属实验室" };//"是否监制",
            
            publicUltraGridDetail1.InitColumnsLab(arrColumns, arrCaption);
            publicUltraGridDetail1.setColumnShowOrHidden(new string[] { "ISRCL", "FLAG", "FLAG_DESC", "PHY_CODE_MAX", "ISPRODUCER", "IS_NOTICE_PRODUCER", "IS_NOTICE_PRODUCER_DESC", "LAB_RECEIVE_NAME", "LAB_RECEIVE_TIME", "AUDIT_TIME", "INSERT_FLAG", "DEPT_ID" }, false);//不需要显示的行
            publicUltraGridDetail1.setOtherColumnReadOnly(new string[] { "CHK" });//可编辑列
            //publicUltraGridDetail1.Ug.DisplayLayout.Bands[0].Override.AllowAddNew = AllowAddNew.No;

            publicUltraGridDetail2.InitColumnsLab(arrColumns, arrCaption);
            publicUltraGridDetail2.setColumnShowOrHidden(new string[] { "ISRCL", "ISRCL_DESC", "FLAG", "PHY_CODE_MAX", "ISPRODUCER", "IS_NOTICE_PRODUCER", "IS_NOTICE_PRODUCER_DESC", "AUDIT_TIME", "DEPT_ID" }, false);
            if (!arrId.Contains("002001007009"))
            {
                publicUltraGridDetail2.setColumnShowOrHidden(new string[] { "ISRCL", "ISRCL_DESC", "FLAG", "PHY_CODE_MAX", "ISPRODUCER", "IS_NOTICE_PRODUCER", "IS_NOTICE_PRODUCER_DESC", "AUDIT_TIME", "INSERT_FLAG", "DEPT_ID" }, false);
            }
            publicUltraGridDetail2.setOtherColumnReadOnly(new string[] { "CHK" });
            //publicUltraGridDetail2.Ug.DisplayLayout.Bands[0].Override.AllowAddNew = AllowAddNew.No;
            publicUltraGridDetail3.InitColumnsLab(arrColumns, arrCaption);
            publicUltraGridDetail3.setColumnShowOrHidden(new string[] { "ISRCL", "ISRCL_DESC", "FLAG", "PHY_CODE_MAX", "ISPRODUCER", "IS_NOTICE_PRODUCER", "IS_NOTICE_PRODUCER_DESC", "AUDIT_TIME", "INSERT_FLAG", "DEPT_ID" }, false);
            publicUltraGridDetail3.setOtherColumnReadOnly(new string[] { "CHK" });

            publicUltraGridDetail4.InitColumnsLab(arrColumns, arrCaption);
            publicUltraGridDetail4.setColumnShowOrHidden(new string[] { "ISRCL", "ISRCL_DESC", "FLAG", "PHY_CODE_MAX", "ISPRODUCER", "IS_NOTICE_PRODUCER", "IS_NOTICE_PRODUCER_DESC", "INSERT_FLAG", "DEPT_ID" }, false);
            publicUltraGridDetail4.setOtherColumnReadOnly(new string[] { "CHK" });

            pipeQueryBaseLab1.UpdateControl("加工下发时间");
            pipeQueryBaseLab1.BindComboxNew(this.UserInfo.GetDeptid(), this.ob);
        }

        /// <summary>
        /// 重写基类方法
        /// </summary>
        /// <param name="sender"></param> 
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            //查询、确认、退出
            switch (ToolbarKey)
            {
                case "Query":
                    if (ultraTabControl1.SelectedTab.Index == 0)
                    {
                        QueryCheckConsignDetailInfo(publicUltraGridDetail1, "1");
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 1)
                    {
                        QueryCheckConsignDetailInfo(publicUltraGridDetail2, "23");
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 2)
                    {
                        QueryCheckConsignDetailInfo(publicUltraGridDetail3, "9");
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 3)
                    {
                        QueryCheckConsignDetailInfo(publicUltraGridDetail4, "45");
                    }
                    break;
                case "Confirm":
                    UpdateCheckConsignDetail();
                    break;
                case "Cancel":
                    CancelUpdateCheckConsignDetail();
                    break;
                case "Resample":
                    ResampleRest();
                    break;
                case "ResampleBack":
                    ResampleRestBack();
                    break;
                case "Add":
                    Add();
                    break;
                case "CancelAdd":
                    CancelAdd();
                    break;
                case "Print":
                    if (ultraTabControl1.SelectedTab.Index == 0)
                    {
                        RepLimsPipeLabSampleConfirm(publicUltraGridDetail1);
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 1)
                    {
                        RepLimsPipeLabSampleConfirm(publicUltraGridDetail2);
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 3)
                    {
                        RepLimsPipeLabSampleConfirm(publicUltraGridDetail4);
                    }
                    break;
                case "PrintHX":
                    printHX();
                    break;
                case "Export":
                    ExportData();
                    break;
                case "Close":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
                    {
                        this.Close();
                    }
                    break;
            }
        }

        /// <summary>
        /// 导出
        /// </summary>
        private void ExportData()
        {
            if (this.ultraTabControl1.Tabs[0].Active)
            {
                GridHelper.ulGridToExcel(publicUltraGridDetail1.Ug, "未确认数据");
            }
            else if (this.ultraTabControl1.Tabs[1].Active)
            {
                GridHelper.ulGridToExcel(publicUltraGridDetail2.Ug, "已确认数据");
            }
            else if (this.ultraTabControl1.Tabs[2].Active)
            {
                GridHelper.ulGridToExcel(publicUltraGridDetail3.Ug, "重取样数据");
            }
            else if (this.ultraTabControl1.Tabs[3].Active)
            {
                GridHelper.ulGridToExcel(publicUltraGridDetail4.Ug, "已确认完成检验项");
            }
            
            
        }

        //查询检验委托基本信息
        /// <summary>
        /// 查询检验委托基本信息
        /// </summary>
        /// <param name="publicUltraGridDetail"></param>
        /// <param name="strFlag"></param>
        private void QueryCheckConsignDetailInfo(PublicUltraGridDetail publicUltraGridDetail, string strFlag)
        {
            try
            {
                if (strFlag.Equals("1")) //未确认
                {
                    ArrayList alist = new ArrayList();
                    alist = pipeQueryBaseLab1.GetQueryInfo(strFlag);

                    publicUltraGridDetail.QueryCheckConsignBaseDetailReceiveTime("pipe.PublicPipeBase", alist, this.ob, arrId, plineCodes, "1", this.CustomInfo.ToString());
                }
                else if (strFlag.Equals("23"))//已确认未完成
                {
                    if (!pipeQueryBaseLab1.chkINSERT_FLAG.Checked && pipeQueryBaseLab1.ultraINSERT_FLAG.Value == null)
                    {
                        pipeQueryBaseLab1.chkINSERT_FLAG.Checked = true;
                        pipeQueryBaseLab1.ultraINSERT_FLAG.SelectedIndex = pipeQueryBaseLab1.ultraINSERT_FLAG.FindStringExact("否");
                    }
                    ArrayList alist = new ArrayList();
                    alist = pipeQueryBaseLab1.GetQueryInfo(strFlag);

                    publicUltraGridDetail.QueryCheckConsignBaseDetailReceiveTime("pipe.PublicPipeBase", alist, this.ob, arrId, plineCodes, "2", this.CustomInfo.ToString());
                }
                else if (strFlag.Equals("45"))//已确认已完成
                {
                    ArrayList alist = new ArrayList();
                    alist = pipeQueryBaseLab1.GetQueryInfo(strFlag);

                    publicUltraGridDetail.QueryCheckConsignBaseDetailReceiveTime("pipe.PublicPipeBase", alist, this.ob, arrId, plineCodes, "2", this.CustomInfo.ToString());
                }
                else if (strFlag.Equals("9")) //查询重取样
                {
                    ArrayList alist = new ArrayList();
                    alist = pipeQueryBaseLab1.GetQueryInfo(strFlag);

                    publicUltraGridDetail.QueryResample("pipe.PublicPipeBase", alist, this.ob, arrId, plineCodes, this.CustomInfo.ToString());
                }
                PublicPipeAndOutdec.RefreshAndAutoSizeColumns(publicUltraGridDetail.Ug, new string[] { "PHY_NAME_MAX", "PRODUCT_STD", "SAMPLE_REMARK" }, false);
                //加急置顶，红色
                foreach (UltraGridRow uRow in publicUltraGridDetail.Ug.Rows)
                {
                    if (uRow.Cells["IS_RUSH"].Value.ToString().Equals("是"))
                    { uRow.Cells["IS_RUSH"].Appearance.BackColor = Color.Red; }
                }
                        
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        #region 未确认

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

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

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

                foreach (DataRow row in arrBase)
                {
                    if ("1234".Contains(row["ISRCL"].ToString()))
                    {
                        MessageUtil.ShowTips("选择试样包含小样热处理没有做完的试样号，实验室不能确认！");
                        return;
                    }
                }

                
                
                if (MessageUtil.ShowYesNoAndQuestion("是否来样确认？") == DialogResult.Yes)
                {
                    DateTime SeverTime = comm.GetSeverTime(this.ob);
                    string Time = SeverTime.ToLongTimeString();
                    string strDate2 = "";
                    Time = Time.Replace(":", "");
                    string user = UserInfo.GetUserName();
                    string strDate = DateTime.Now.ToString();
                    int a= 0,b= 0;
                    ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
                    //力学、化学实验来样确认前要有当天的交接记录，设备运行记录
                    if ("002001007009".Equals(UserInfo.GetDeptid()) || "002001007010".Equals(UserInfo.GetDeptid()))
                    {
                        if (int.Parse(Time) < 70000)
                        {
                            strDate2 = SeverTime.AddDays(-1).ToString("yyyy-MM-dd");
                        }
                        else
                        {
                            strDate2 = SeverTime.ToString("yyyy-MM-dd");
                        }
                        DataTable ds = ServerHelper.GetData("com.steering.lims.data.pipe.PublicPipeBase.doQueryClassRecord", new object[] { UserInfo.GetDeptid(), UserInfo.GetUserOrderText(), strDate2 }, ob);
                        DataTable dd = ServerHelper.GetData("com.steering.lims.data.pipe.PublicPipeBase.doQueryRunRecord", new object[] { UserInfo.GetDeptid(), UserInfo.GetUserOrderText(), strDate2 }, ob);
                        if (ds.Rows.Count > 0)
                        {
                            a = int.Parse( ds.Rows[0]["ACOUNT"].ToString());
                        }
                        if (dd.Rows.Count > 0)
                        {
                            b = int.Parse(dd.Rows[0]["ACOUNT"].ToString());
                        }
                        if (a == 0 )
                        {
                            MessageUtil.ShowTips("没有今天的交接班记录，不能确认!");
                            return;
                        }
                        if ( b == 0)
                        {
                            MessageUtil.ShowTips("没有今天的设备使用运行记录，不能确认!");
                            return;
                        }
                    }

                    if ("002001007010".Equals(UserInfo.GetDeptid()) || "002023003001".Equals(UserInfo.GetDeptid()))
                    {
                        foreach (DataRow row in arrBase)
                        {
                            if ("HX".Equals(row["PHY_CODE_MAX"].ToString()))
                            {
                                publicUltraGridDetail1.UpdateCheckConsignDetailHX("pipe.FrmLabSampleConfirm", this.ob, arrBase, "2", user, strDate, "1", "");
                            }
                            else 
                            {
                                publicUltraGridDetail1.UpdateCheckConsignDetail("pipe.FrmLabSampleConfirm", this.ob, arrBase, "2", user, strDate, "1", "");
                            }
                        }
                        
                    }
                    else
                    {
                        foreach (DataRow row in arrBase)
                        {
                            if("HX".Equals(row["PHY_CODE_MAX"]. ToString()) || row["PHY_CODE_MAX"].ToString() == "ONH" )
                            {
                                MessageUtil.ShowTips("不是化学实验室人员请不要确认化学数据！");
                                return;
                            }
                        }
                        if ("002023003002".Equals(UserInfo.GetDeptid()))
                        {
                            publicUltraGridDetail1.UpdateCheckConsignDetailTH("pipe.FrmLabSampleConfirm", this.ob, arrBase, "2", user, strDate, "1", "");
                        }
                        else 
                        {
                            publicUltraGridDetail1.UpdateCheckConsignDetail("pipe.FrmLabSampleConfirm", this.ob, arrBase, "2", user, strDate, "1", "");
                        }
                        
                    }
                    
                    

                    QueryCheckConsignDetailInfo(publicUltraGridDetail1, "1");
                    QueryCheckConsignDetailInfo(publicUltraGridDetail2, "23");
                    QueryCheckConsignDetailInfo(publicUltraGridDetail3, "9");
                    QueryCheckConsignDetailInfo(publicUltraGridDetail4, "45");

                    MessageUtil.ShowTips("来样确认成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }
        #endregion

        #region 已确认
        /// <summary>
        /// 取消确认
        /// </summary>
        private void CancelUpdateCheckConsignDetail()
        {
            try
            {
                if (publicUltraGridDetail2.Ug == null || publicUltraGridDetail2.Ug.Rows.Count == 0)
                {
                    return;
                }

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

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

                //if (MessageUtil.ShowYesNoAndQuestion("是否取消确认？") == DialogResult.Yes)
                //{
                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 + ")";
                publicUltraGridDetail2.UpdateCheckConsignDetail("pipe.FrmLabSampleConfirm", this.ob, arrBase, "1", "", "", "2", strRemark);

                QueryCheckConsignDetailInfo(publicUltraGridDetail2, "23");
                QueryCheckConsignDetailInfo(publicUltraGridDetail1, "1");
                QueryCheckConsignDetailInfo(publicUltraGridDetail3, "9");
                QueryCheckConsignDetailInfo(publicUltraGridDetail4, "45");

                MessageUtil.ShowTips("取消确认成功！");
                //}
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        /// <summary>
        /// 加入试验项目(仅力学试验有要求)
        /// </summary>
        private void Add()
        {
            try
            {
                if (publicUltraGridDetail2.Ug == null || publicUltraGridDetail2.Ug.Rows.Count == 0)
                {
                    return;
                }

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

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

                string user = UserInfo.GetUserName();
                string strDate = DateTime.Now.ToString();
                if ("002023021004".Equals(UserInfo.GetDeptid()))
                {
                    publicUltraGridDetail2.UpdateCheckConsignDetailLX("pipe.FrmLabSampleConfirm", this.ob, arrBase, "1", "", "", "", strRemark);
                }

                QueryCheckConsignDetailInfo(publicUltraGridDetail2, "23");
                QueryCheckConsignDetailInfo(publicUltraGridDetail1, "1");
                QueryCheckConsignDetailInfo(publicUltraGridDetail3, "9");
                QueryCheckConsignDetailInfo(publicUltraGridDetail4, "45");

                MessageUtil.ShowTips("加入试验项目成功！");
                //}
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        /// <summary>
        /// 取消加入
        /// </summary>
        private void CancelAdd()
        {
            try
            {
                if (publicUltraGridDetail2.Ug == null || publicUltraGridDetail2.Ug.Rows.Count == 0)
                {
                    return;
                }

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

                publicUltraGridDetail2.Ug.UpdateData();
                DataRow[] arrBase = publicUltraGridDetail2.DataTable.Select("CHK = 'True' AND FLAG = '2'");
                if (arrBase == null || arrBase.Length == 0)
                {
                    MessageUtil.ShowTips("请勾选状态为试验室已确认的检验信息！");
                    return;
                }
                //foreach (DataRow row in arrBase)
                //{
                //    DataTable dtFlag = PublicServer.GetData("com.steering.lims.data.pipe.FrmLabSampleConfirm.GetFlag", new object[] { row["CHECK_NO"].ToString(), row["SAMPLE_NO"].ToString(), row["PHY_CODE_MAX"].ToString() }, this.ob);
                //    if (dtFlag.Rows.Count > 0)
                //    {
                //        if (!dtFlag.Rows[0]["FLAG"].ToString().Equals("2"))
                //        {
                //            MessageBox.Show("不是试验室确认状态，不能取消加入！");
                //            return;
                //        }
                //    }
                //}

                string strRemark = "";

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

                publicUltraGridDetail2.UpdateCheckConsignDetailLX("pipe.FrmLabSampleConfirm", this.ob, arrBase, "2", "", "", "", strRemark);

                QueryCheckConsignDetailInfo(publicUltraGridDetail2, "23");
                QueryCheckConsignDetailInfo(publicUltraGridDetail1, "1");
                QueryCheckConsignDetailInfo(publicUltraGridDetail3, "9");
                QueryCheckConsignDetailInfo(publicUltraGridDetail4, "45");

                MessageUtil.ShowTips("取消加入成功！");
                //}
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        /// <summary>
        /// 重取样
        /// </summary>
        private void ResampleRest()
        {
            try
            {
                if (publicUltraGridDetail2.Ug == null || publicUltraGridDetail2.Ug.Rows.Count == 0)
                {
                    return;
                }

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

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

                ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息
                ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
                foreach (DataRow row in arrBase)
                {
                    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.FrmLabSampleConfirm.ResampleRest",
                        new Object[] { alBase }, ob);

                QueryCheckConsignDetailInfo(publicUltraGridDetail2, "23");
                QueryCheckConsignDetailInfo(publicUltraGridDetail1, "1");
                QueryCheckConsignDetailInfo(publicUltraGridDetail3, "9");
                QueryCheckConsignDetailInfo(publicUltraGridDetail4, "45");

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

        /// <summary>
        /// 取消重取样
        /// </summary>
        private void ResampleRestBack()
        {
            try
            {
                if (publicUltraGridDetail3.Ug == null || publicUltraGridDetail3.Ug.Rows.Count == 0)
                {
                    return;
                }

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

                publicUltraGridDetail3.Ug.UpdateData();
                DataRow[] arrBase = publicUltraGridDetail3.DataTable.Select("CHK = 'True' ");
                
                ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息
                ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
                foreach (DataRow row in arrBase)
                {
                    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.FrmLabSampleConfirm.ResampleRestBack",
                        new Object[] { alBase }, ob);

                QueryCheckConsignDetailInfo(publicUltraGridDetail2, "23");
                QueryCheckConsignDetailInfo(publicUltraGridDetail1, "1");
                QueryCheckConsignDetailInfo(publicUltraGridDetail3, "9");
                QueryCheckConsignDetailInfo(publicUltraGridDetail4, "45");

                MessageUtil.ShowTips("取消重取样成功！");
                //}
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        /// <summary>
        /// 打印化学小标签
        /// </summary>
        private void printHX()
        {
            try
            {
                DataRow[] arrBase = null;
                if (ultraTabControl1.SelectedTab.Index == 0)
                {
                    publicUltraGridDetail1.Ug.UpdateData();
                    arrBase = publicUltraGridDetail1.DataTable.Select("CHK = 'True'");
                }
                else if (ultraTabControl1.SelectedTab.Index == 1)
                {
                    publicUltraGridDetail2.Ug.UpdateData();
                    arrBase = publicUltraGridDetail2.DataTable.Select("CHK = 'True'");
                }
                else if (ultraTabControl1.SelectedTab.Index == 3)
                {
                    publicUltraGridDetail4.Ug.UpdateData();
                    arrBase = publicUltraGridDetail4.DataTable.Select("CHK = 'True'");
                }
                this.Cursor = Cursors.WaitCursor;

                if (arrBase == null || arrBase.Length == 0)
                {
                    MessageUtil.ShowWarning("请选择您要打印的化学小标签！");
                    return;
                }

                string strCHECK_NO = "";

                foreach (DataRow row in arrBase)
                {
                    strCHECK_NO += "'" + row["CHECK_NO"].ToString() + row["SAMPLE_NO"].ToString()  + "',";
                }

                strCHECK_NO = strCHECK_NO.Remove(0, 1);
                strCHECK_NO = strCHECK_NO.Remove(strCHECK_NO.Length - 2);
                string strurl = "";
                if (UserInfo.GetDeptid().Equals("002001007010") || UserInfo.GetDeptid().Equals("002023003001")) //化学实验室
                {
                    strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsPipeTabHX.cpt&bypagesize=false" + "&CHECK_NO=" + strCHECK_NO;
                }
                else
                {
                    MessageUtil.ShowWarning("该实验室暂无小标签打印功能！");
                        return;
                }
                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();
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="publicUltraGridDetail"></param>
        private void RepLimsPipeLabSampleConfirm(PublicUltraGridDetail publicUltraGridDetail)
        {
            try
            {
                string a = UserInfo.GetDepartment();
                string b = UserInfo.GetDeptid();
                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 = "";
                string strCHECK_NOHX = "";
                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() + "',";
                    if (!strCHECK_NOHX.Contains(row["CHECK_NO"].ToString()))
                    {
                        strCHECK_NOHX += "'" + row["CHECK_NO"].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.FrmLabSampleConfirm.UpdatePipeLabPrintCount",
                new Object[] { alBase }, ob);

                strCHECK_NO = strCHECK_NO.Remove(0, 1);
                strCHECK_NO = strCHECK_NO.Remove(strCHECK_NO.Length - 2);

                strCHECK_NOHX = strCHECK_NOHX.Remove(0, 1);
                strCHECK_NOHX = strCHECK_NOHX.Remove(strCHECK_NOHX.Length - 2);
                string strurl = "";
                if (UserInfo.GetDeptid().Equals("002001007010") || UserInfo.GetDeptid().Equals("002023003001")) //化学实验室
                {
                    strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsPipeLabSampleConfirmHX.cpt&op=view" + "&CHECK_NO=" + strCHECK_NOHX;
                }
                else if (UserInfo.GetDeptid().Equals("002001007009") || UserInfo.GetDeptid().Equals("002023003002")) //材料力学试验室
                {
                    strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsPipeLabSampleConfirmLX.cpt" + "&CHECK_NO=" + strCHECK_NOHX;
                }
                else if (UserInfo.GetDeptid().Equals("002001007013")) //腐蚀试验室
                {
                    strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsPipeLabSampleConfirmFS.cpt&op=view" + "&CHECK_NO=" + strCHECK_NO;
                }
                else
                {
                    strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsPipeLabSampleConfirm.cpt&op=view" + "&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();
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }

        #endregion

        private void FrmLabSampleConfirm_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("Confirm"))
            {
                toolMenu.Toolbars[0].Tools["Confirm"].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("Add"))
            {
                toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("CancelAdd"))
            {
                toolMenu.Toolbars[0].Tools["CancelAdd"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("Resample"))
            {
                toolMenu.Toolbars[0].Tools["Resample"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("ResampleBack"))
            {
                toolMenu.Toolbars[0].Tools["ResampleBack"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            //if (toolMenu.Toolbars[0].Tools.Exists("Print"))
            //{
            //    toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False;
            //}
        }

        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (toolMenu == null) return;
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                pipeQueryBaseLab1.UpdateControl("加工下发时间");

                if (toolMenu.Toolbars[0].Tools.Exists("Query"))
                {
                    toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Confirm"))
                {
                    toolMenu.Toolbars[0].Tools["Confirm"].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("Resample"))
                {
                    toolMenu.Toolbars[0].Tools["Resample"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("ResampleBack"))
                {
                    toolMenu.Toolbars[0].Tools["ResampleBack"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("PrintHX"))
                {
                    toolMenu.Toolbars[0].Tools["PrintHX"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                {
                    toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelAdd"))
                {
                    toolMenu.Toolbars[0].Tools["CancelAdd"].InstanceProps.Visible = DefaultableBoolean.False;
                }

            }
            else if (ultraTabControl1.SelectedTab.Index == 1)
            {
                pipeQueryBaseLab1.UpdateControl("收样时间");

                if (toolMenu.Toolbars[0].Tools.Exists("Query"))
                {
                    toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Confirm"))
                {
                    toolMenu.Toolbars[0].Tools["Confirm"].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("Resample"))
                {
                    toolMenu.Toolbars[0].Tools["Resample"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("ResampleBack"))
                {
                    toolMenu.Toolbars[0].Tools["ResampleBack"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("PrintHX"))
                {
                    toolMenu.Toolbars[0].Tools["PrintHX"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                {
                    toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelAdd"))
                {
                    toolMenu.Toolbars[0].Tools["CancelAdd"].InstanceProps.Visible = DefaultableBoolean.True;
                }
            }
            else if (ultraTabControl1.SelectedTab.Index == 2)
            {
                pipeQueryBaseLab1.UpdateControl("收样时间");
                if (toolMenu.Toolbars[0].Tools.Exists("Query"))
                {
                    toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Confirm"))
                {
                    toolMenu.Toolbars[0].Tools["Confirm"].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("Resample"))
                {
                    toolMenu.Toolbars[0].Tools["Resample"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("ResampleBack"))
                {
                    toolMenu.Toolbars[0].Tools["ResampleBack"].InstanceProps.Visible = DefaultableBoolean.True;
                } 
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("PrintHX"))
                {
                    toolMenu.Toolbars[0].Tools["PrintHX"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                {
                    toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelAdd"))
                {
                    toolMenu.Toolbars[0].Tools["CancelAdd"].InstanceProps.Visible = DefaultableBoolean.False;
                }
            }
            else if (ultraTabControl1.SelectedTab.Index == 3)
            {
                pipeQueryBaseLab1.UpdateControl("收样时间");

                if (toolMenu.Toolbars[0].Tools.Exists("Query"))
                {
                    toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Confirm"))
                {
                    toolMenu.Toolbars[0].Tools["Confirm"].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("Resample"))
                {
                    toolMenu.Toolbars[0].Tools["Resample"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("ResampleBack"))
                {
                    toolMenu.Toolbars[0].Tools["ResampleBack"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("PrintHX"))
                {
                    toolMenu.Toolbars[0].Tools["PrintHX"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                {
                    toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelAdd"))
                {
                    toolMenu.Toolbars[0].Tools["CancelAdd"].InstanceProps.Visible = DefaultableBoolean.False;
                }
            }
        }
    }
}