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

namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec
{
    public partial class FrmJGSampleConfirm : FrmBase
    {
        private string[] plineCodes = { };

        public FrmJGSampleConfirm()
        {
            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;

            publicUltraGridBase2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            //ultraGrid3.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
            ultraGrid3.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            ultraGrid6.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            

            pipeQueryBase1.EnterHandler += EnterCheckNo;
            publicUltraGridBase2.Ug.DisplayLayout.Override.HeaderClickAction = HeaderClickAction.Select;

            plineCodes = comm.GetPlineCode(ValidDataPurviewIds, ob);
            pipeQueryBase1.chkSAMPLE_NO.Text = "合同号";
            pipeQueryBase1.chkSAMPLE_NO.Visible = true;
            pipeQueryBase1.txtSAMPLE_NO.Visible = true;
        }

        private void FrmJGSampleConfirm_Load(object sender, EventArgs e)
        {
            EntityHelper.ShowGridCaption<PipeCheckconsignSplinecodeEntity>(this.ultraGrid1.DisplayLayout.Bands[0]);
            InitColumns();

        }

        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("Confirm"))
                {
                    toolMenu.Toolbars[0].Tools["Confirm"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelConfirm"))
                {
                    this.toolMenu.Toolbars[0].Tools["CancelConfirm"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Cancel"))
                {
                    toolMenu.Toolbars[0].Tools["Cancel"].InstanceProps.Visible = DefaultableBoolean.False;
                }
            }
            else if (ultraTabControl1.SelectedTab.Index == 1)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Confirm"))
                {
                    toolMenu.Toolbars[0].Tools["Confirm"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelConfirm"))
                {
                    this.toolMenu.Toolbars[0].Tools["CancelConfirm"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Cancel"))
                {
                    toolMenu.Toolbars[0].Tools["Cancel"].InstanceProps.Visible = DefaultableBoolean.True;
                }
            }
        }

        private void InitColumns()
        {
            string[] arrColumnsBase = new string[] { "CHK", "FLAG", "FLAG_DESC", "CHECK_NO", "JG_PRINT_COUNT", "JG_PRINT_NAME", "JG_PRINT_TIME", "HEAT_NO", "STEEL_GRADE", "STEEL_NO", "PRODUCT_STD", "CONTRACT_NO", "DIMATER", "HEIGHT", "CONSIGN_DEPT", "CONSIGN_NAME", "CONSIGN_TIME", "XSS", "CRAFT_SOURCE", "ISPRODUCER", "SPEC_REQ", "REMARK", "CONSIGNDEPT_SEND_NAME", "CONSIGNDEPT_SEND_TIME", "JG_RECEIVE_NAME", "JG_RECEIVE_TIME", "SAMPLE_REMARK" };
            string[] arrCaptionBase = new string[] { "选择", "状态", "状态", "检验编号", "打印次数", "打印人", "打印时间", "炉号", "钢级", "钢号", "技术标准", "合同号", "外径", "壁厚", "委托单位", "委托人", "委托时间", "小时数", "委托类型", "是否监制", "特殊要求", "备注", "送样人", "送样时间", "收样人", "收样时间", "来样操作备注" };

            publicUltraGridBase1.PublicUltraGridBaseActive += new EventHandler(outdecUltraGridBase1_PublicUltraGridBaseActive);//调用委托事件
            publicUltraGridBase1.InitColumns(arrColumnsBase, arrCaptionBase);
            publicUltraGridBase1.setColumnShowOrHidden(new string[] { "CHK", "FLAG", "FLAG_DESC", "JG_PRINT_COUNT", "JG_PRINT_NAME", "JG_PRINT_TIME", "JG_RECEIVE_NAME", "JG_RECEIVE_TIME" }, false);//隐藏列
            publicUltraGridBase1.setOtherColumnReadOnly(new string[] { "CHK" });//可编辑列

            string[] arrColumns = new string[] { "CHK", "FLAG", "BATCH_NO", "HEAD_MAT_NO", "SAMPLE_NO", "SAMPLE_BARCODE", "HX", "ONH" };
            string[] arrCaption = new string[] { "选择", "状态", "批号", "样管编号", "试样号", "条形码", "化学", "ONH" };

            publicUltraGridDetail1.InitColumns(arrColumns, arrCaption);
            publicUltraGridDetail1.setColumnShowOrHidden(new string[] { "FLAG", "SAMPLE_BARCODE",  "BATCH_NO" }, false);
            //publicUltraGridDetail1.setOtherColumnReadOnly(null);//可编辑列
            //publicUltraGridDetail1.Ug.DisplayLayout.Bands[0].Override.AllowAddNew = AllowAddNew.No;
            //publicUltraGridDetail1.Ug.DisplayLayout.Bands[0].Columns["SAMPLE_NO"].EditorComponent = ultraOK;
            //publicUltraGridDetail1.Ug.DisplayLayout.Bands[0].Columns["SAMPLE_NO"].ButtonDisplayStyle = Infragistics.Win.UltraWinGrid.ButtonDisplayStyle.Always;
            publicUltraGridDetail1.setOtherColumnReadOnly(new string[] { "CHK" });//可编辑列     
            publicUltraGridBase2.PublicUltraGridBaseActive += new EventHandler(outdecUltraGridBase2_PublicUltraGridBaseActive);
            publicUltraGridBase2.InitColumns(arrColumnsBase, arrCaptionBase);
            publicUltraGridBase2.setColumnShowOrHidden(new string[] { "CHK", "FLAG" }, false);
            publicUltraGridBase2.setOtherColumnReadOnly(new string[] { "CHK" });//可编辑列           

            publicUltraGridDetail2.InitColumns(arrColumns, arrCaption);
            //publicUltraGridDetail2.setOtherColumnReadOnly(null);//可编辑列
            publicUltraGridDetail2.setColumnShowOrHidden(new string[] { "FLAG", "SAMPLE_BARCODE", "BATCH_NO" }, false);
            //publicUltraGridDetail2.Ug.DisplayLayout.Bands[0].Override.AllowAddNew = AllowAddNew.No;
            //publicUltraGridDetail2.Ug.DisplayLayout.Bands[0].Columns["SAMPLE_NO"].EditorComponent = ultraCancel;
            //publicUltraGridDetail2.Ug.DisplayLayout.Bands[0].Columns["SAMPLE_NO"].ButtonDisplayStyle = Infragistics.Win.UltraWinGrid.ButtonDisplayStyle.Always;

            string[] arrColumnsBaseDetail = new string[] { "PHY_CODE_MAX", "PHY_NAME_MAX", "PHY_DIR", "SIZE_DESC", "ISRCL", "TS_REMARK" };
            string[] arrCaptionBaseDetail = new string[] { "试样组代码", "试样组", "方向", "名义规格", "是否小样热处理", "试样特殊要求备注" };

            PublicPipeAndOutdec.InitColumns(arrColumnsBaseDetail, arrCaptionBaseDetail, dataTable3);
            PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid3, new string[] { "PHY_CODE_MAX" }, false);
            //PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid3, null);

            PublicPipeAndOutdec.InitColumns(arrColumnsBaseDetail, arrCaptionBaseDetail, dataTable6);
            PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid6, new string[] { "PHY_CODE_MAX" }, false);
            //PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid6, null);
        }

        private void EnterCheckNo()
        {
            QueryCheckConsignBase();
            publicUltraGridBase1.MakeAllDataCheck();
            UpdateCheckConsign();
        }

        /// <summary>
        /// 重写基类方法
        /// </summary>
        /// <param name="sender"></param> 
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            //查询、确认、退出
            switch (ToolbarKey)
            {
                case "Query":
                    QueryCheckConsignBase();
                    break;
                case "Confirm":
                    UpdateCheckConsign();
                    break;
                case "CancelConfirm":
                    CancelConfirmCheckConsignDetail();
                    break;
                case "Cancel":
                    CancelUpdateCheckConsignNew();
                    break;
                case "Export":
                    Export();
                    break;
                case "Print":
                    if (ultraTabControl1.SelectedTab.Index == 0)
                    {
                        RepLimsPipeJGSampleConfirm(publicUltraGridBase1);
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 1)
                    {
                        RepLimsPipeJGSampleConfirm(publicUltraGridBase2);
                    }
                    break;
                case "Close":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
                    {
                        this.Close();
                    }
                    break;
            }
        }

        private void Export()
        {
            string title = "管材加工试样确认" + ultraTabControl1.SelectedTab.Text;
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                publicUltraGridBase1.Export(title);
            }else if (ultraTabControl1.SelectedTab.Index == 1)
            {
                publicUltraGridBase2.Export(title);
            }
        }

        /// <summary>
        /// 取消单支样管确认
        /// </summary>
        private void CancelConfirmCheckConsignDetail()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 0)
                {
                    MessageUtil.ShowWarning("只有在未确认任务单页才能进行取消单只样管确认操作！");
                    return;
                }
                if (publicUltraGridDetail1.Ur == null)
                {
                    MessageUtil.ShowWarning("请点击选择需要取消确认的样管！");
                    return;
                }
                if (publicUltraGridDetail1.Ur.Cells["FLAG"].Text.Trim() != "9")
                {
                    MessageUtil.ShowWarning("请点击选择一条状态为已确认的样管！");
                    return;
                }
                //if (MessageUtil.ShowYesNoAndQuestion("是否确认取消？") == DialogResult.Yes)
                //{
                WinCancelSampleComfirm pc = new WinCancelSampleComfirm();
                pc.ShowDialog();
                if (pc.DialogResult != DialogResult.OK)
                {
                    return;
                }
                string strRemark = pc.StrRemark;//UserInfo.GetUserName() ,DateTime.Now.ToString()
                strRemark = this.Text + "取消单根样管确认由于" + strRemark + "(" + UserInfo.GetUserName() + " " + DateTime.Now.ToString() + ")";

                ArrayList all = new ArrayList();

                string strCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim();
                ArrayList alBase = new ArrayList();//第三组参数
                alBase.Add("1");
                alBase.Add("");
                alBase.Add("");
                alBase.Add(strRemark);
                alBase.Add(strRemark);
                alBase.Add("1");
                alBase.Add(strCHECK_NO);

                string strSAMPLE_NO = publicUltraGridDetail1.Ur.Cells["SAMPLE_NO"].Text.Trim();
                ArrayList alConfrim = new ArrayList();//第一组参数
                //alConfrim.Add("");
                alConfrim.Add("0");
                alConfrim.Add("9");
                alConfrim.Add(strSAMPLE_NO);
                alConfrim.Add(strCHECK_NO);

                ArrayList strCheck = new ArrayList();
                strCheck.Add(strCHECK_NO);

                all.Add(alBase);
                all.Add(alConfrim);
                //all.Add(strCheck);

                PublicServer.SetData("com.steering.lims.data.pipe.FrmJGSampleConfirm.CancelConfirmCheckConsignDetail",
    new Object[] { all }, ob);

               // QueryCheckConsignDetail(publicUltraGridDetail1, publicUltraGridBase1.Ur, 5);
                ChangeColor(publicUltraGridDetail1.Ug);

                PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridDetail1.Ug, "SAMPLE_NO", strSAMPLE_NO);
                //}
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        //查询检验委托基本信息
        /// <summary>
        /// 查询检验委托基本信息
        /// </summary>
        private void QueryCheckConsignBase()
        {
            try
            {
                PublicUltraGridBase publicUltraGridBase = publicUltraGridBase1;
                string strFlag = "1";
                 if (ultraTabControl1.SelectedTab.Index == 1)
                {
                    publicUltraGridBase = publicUltraGridBase2;
                    strFlag = "2345";
                    ArrayList arrayList = pipeQueryBase1.GetQueryInfo(strFlag);
                    arrayList.Add(plineCodes);
                    arrayList.Add(this.CustomInfo.ToString());
                    publicUltraGridBase.QueryCheckConsignBaseJgReceiveTime("pipe.PublicPipeBase", arrayList, this.ob);
                    //超24小时红色
                    //foreach (UltraGridRow uRow in publicUltraGridBase2.Ug.Rows)
                    //{
                    //    if (int.Parse(uRow.Cells["XSS"].Value.ToString3())> 25)
                    //    { uRow.Appearance.BackColor = Color.Red; }
                    //}
                }
                 else if (ultraTabControl1.SelectedTab.Index == 0)
                 {
                     ArrayList arrayList = pipeQueryBase1.GetQueryInfo(strFlag);
                     arrayList.Add(plineCodes);
                     arrayList.Add(this.CustomInfo.ToString());
                     publicUltraGridBase.QueryCheckConsignBase("pipe.PublicPipeBase", arrayList, this.ob);

                 }
                
                if (publicUltraGridBase.DataTable == null || publicUltraGridBase.DataTable.Rows.Count == 0)
                {
                    if (publicUltraGridBase == publicUltraGridBase1)
                    {
                        publicUltraGridDetail1.DataTable.Rows.Clear();
                        dataTable3.Rows.Clear();
                    }
                    else if (publicUltraGridBase == publicUltraGridBase2)
                    {
                        publicUltraGridDetail2.DataTable.Rows.Clear();
                        dataTable6.Rows.Clear();
                    }
                }
                PublicPipeAndOutdec.RefreshAndAutoSizeColumns(publicUltraGridBase.Ug, new string[] { "PRODUCT_STD", "SAMPLE_REMARK" }, false);//刷新Grid
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        //查询检验委托加工信息
        /// <summary>
        /// 查询检验委托加工信息
        /// </summary>
        /// <param name="publicUltraGridDetail"></param>
        /// <param name="ur"></param>
        /// <param name="strNum"></param>
        private void QueryCheckConsignDetail(PublicUltraGridDetail publicUltraGridDetail, UltraGridRow ur, int strNum,string flag)
        {
            try
            {
                ArrayList al = new ArrayList();

                al.Add("JG");
                al.Add(flag);
                al.Add(ur.Cells["CHECK_NO"].Text.Trim());
                publicUltraGridDetail.QueryCheckConsignDetail("pipe.PublicPipeBase", al, this.ob, strNum);

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

                //publicUltraGridDetail.setOtherColumnReadOnly(null);//可编辑列
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
                return;
            }
        }

        #region 待确认任务单
        void outdecUltraGridBase1_PublicUltraGridBaseActive(object sender, EventArgs e)
        {

            QueryCheckConsignDetail(publicUltraGridDetail1, publicUltraGridBase1.Ur, 6,"0");

            ChangeColor(publicUltraGridDetail1.Ug);
            QueryCheckConsignPhyDetail(publicUltraGridBase1, dataTable3, ultraGrid3);
        }

        private void ChangeColor(UltraGrid ultraGrid)
        {
            if (ultraGrid.DisplayLayout.Bands[0].Columns.Exists("FLAG"))
            {
                foreach (UltraGridRow dr in ultraGrid.Rows)
                {
                    if (dr.Cells["FLAG"].Text.Trim() == "9")
                    {
                        dr.Cells["SAMPLE_NO"].Appearance.BackColor = Color.LightGray;//LightGray灰色
                    }
                }
            }
        }

        //查询检验委托项目明细信息
        /// <summary>
        /// 查询检验委托项目明细信息
        /// </summary>
        /// <param name="publicUltraGridBase"></param>
        /// <param name="dataTable"></param>
        /// <param name="ultraGrid"></param>
        private void QueryCheckConsignPhyDetail(PublicUltraGridBase publicUltraGridBase, DataTable dataTable, UltraGrid ultraGrid)
        {
            try
            {
                //ArrayList al = new ArrayList();

                //al.Add(publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim());

                DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmCheckConsignQuery.QueryCheckConsignDetailS",
                            new Object[] { publicUltraGridBase.Ur.Cells["CHECK_NO"].Text.Trim() }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable.Rows.Clear();
                    return;
                }

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

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

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

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

                publicUltraGridBase1.Ug.UpdateData();
                publicUltraGridDetail1.Ug.UpdateData();
                DataRow[] arrBase = publicUltraGridDetail1.DataTable.Select("CHK = 'True' ");
                if (arrBase == null || arrBase.Length == 0)
                {
                    MessageUtil.ShowTips("请勾选需要加工确认的检验信息！");
                    return;
                }
                //右边全选则flag =2，否则flag =1
                string flag = "1";
                if (publicUltraGridDetail1.DataTable.Rows.Count == arrBase.Length)
                {
                    flag = "2";
                }
                //if (MessageUtil.ShowYesNoAndQuestion("是否来样确认？") == DialogResult.Yes)
                //{
                UltraGridRow ugr = publicUltraGridBase1.Ug.ActiveRow;
                    string user = UserInfo.GetUserName();
                    string strDate = DateTime.Now.ToString();
                    string checkNo = ugr.Cells["CHECK_NO"].Value.ToString();
                    
                    ArrayList all = new ArrayList();

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

                   // ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
                    ArrayList alDetailParams = new ArrayList();//存放明细表样管参数信息
                    foreach (DataRow row in arrBase)
                    {
                        //ArrayList alBaseParams = new ArrayList();//增加要更新的基础标志位信息;
                        //alBaseParams.Add(checkNo);
                        //alBaseParams.Add(row["SAMPLE_NO"].ToString());
                        PipeCheckconsignDetailEntity pipe = new PipeCheckconsignDetailEntity();
                        pipe.CheckNo = checkNo;
                        pipe.SampleNo = row["SAMPLE_NO"].ToString();
                        string pipeStr = JSONFormat.Format(pipe);
                        all.Add(pipeStr);
                    }
                    
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "com.steering.lims.data.pipe.FrmJGSampleConfirm";
                    ccp.MethodName = "confirmBaseInfoNew";
                    ccp.ServerParams = new object[] { all, alBase };
                    ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                    if (ccp.ReturnCode != -1)
                    {
                        if (ccp.ReturnInfo.Equals("来样确认成功!"))
                        {
                            QueryCheckConsignBase();
                            MessageUtil.ShowTips(ccp.ReturnInfo);
                        }
                        else
                        {
                            MessageUtil.ShowTips(ccp.ReturnInfo);
                        }
                    }
                //}
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        #endregion

        #region 已确认任务单
        void outdecUltraGridBase2_PublicUltraGridBaseActive(object sender, EventArgs e)
        {
            QueryCheckConsignDetail(publicUltraGridDetail2, publicUltraGridBase2.Ur, 5,"123459");

            //赋值给全局变量
            QueryCheckConsignPhyDetail(publicUltraGridBase2, dataTable6, ultraGrid6);
        }

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

                if (publicUltraGridBase2.Ug == null || publicUltraGridBase2.Ug.Rows.Count == 0)
                {
                    return;
                }

                publicUltraGridBase2.Ug.UpdateData();
                //DataRow[] arrBase = publicUltraGridBase2.DataTable.Select("CHK = 'True' AND FLAG = '2'");
                DataRow[] arrBase = publicUltraGridBase2.DataTable.Select("CHK = 'True'");
                if (arrBase == null || arrBase.Length != 1)
                {
                    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();
                //需要判断下一个状态位                    
                //CancelUpdateCheckConsignBase("pipe.FrmJGSampleConfirm", this.ob, arrBase, "1", "", "", "2");

                strRemark = this.Text + "取消确认由于" + strRemark + "(" + user + " " + strDate + ")";

                ArrayList all = new ArrayList();
                ArrayList alIs = new ArrayList();
                ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
                ArrayList alDetailParams = new ArrayList();//存放明细表样管参数信息

                alIs.Add(arrBase[0]["CHECK_NO"].ToString());
                all.Add(alIs);

                alBaseParams.Add("1");
                alBaseParams.Add(user);//收样人
                alBaseParams.Add(strDate);//收样时间
                alBaseParams.Add(strRemark);
                alBaseParams.Add(strRemark);//样品备注row["SAMPLE_REMARK"].ToString()
                alBaseParams.Add("2");
                alBaseParams.Add(arrBase[0]["CHECK_NO"].ToString());
                all.Add(alBaseParams);

                alDetailParams.Add("0");
                //alDetailParams.Add("");//样品备注
                alDetailParams.Add("9");
                alDetailParams.Add("");
                alDetailParams.Add(arrBase[0]["CHECK_NO"].ToString());
                all.Add(alDetailParams);

                PublicServer.SetData("com.steering.lims.data.pipe.FrmJGSampleConfirm.CancelUpdateCheckConsignBase",
                        new Object[] { all }, ob);

                //QueryCheckConsignBase(publicUltraGridBase2, "2");
                //QueryCheckConsignBase(publicUltraGridBase1, "1");
                QueryCheckConsignBase();

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

        /// <summary>
        /// 取消确认(新)
        /// </summary>
        private void CancelUpdateCheckConsignNew()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowTips("只有选择了已确认页才能进行取消确认操作！");
                    return;
                }

                if (publicUltraGridBase2.Ug == null || publicUltraGridBase2.Ug.Rows.Count == 0)
                {
                    return;
                }

                publicUltraGridBase2.Ug.UpdateData();
                publicUltraGridDetail2.Ug.UpdateData();
                DataRow[] arrBase = publicUltraGridDetail2.DataTable.Select("CHK = 'True'");
                //if (arrBase == null || arrBase.Length != 1)
                //{
                //    MessageUtil.ShowTips("请勾选一条检验信息！");
                //    return;
                //}

                WinCancelSampleComfirm pc = new WinCancelSampleComfirm();
                pc.ShowDialog();
                if (pc.DialogResult != DialogResult.OK)
                {
                    return;
                }
                string strRemark = pc.StrRemark;
                UltraGridRow ugr = publicUltraGridBase2.Ug.ActiveRow;
                string user = UserInfo.GetUserName();
                string strDate = DateTime.Now.ToString();
                string checkNo = ugr.Cells["CHECK_NO"].Value.ToString();

                strRemark = this.Text + "取消确认由于" + strRemark + "(" + user + " " + strDate + ")";

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

                foreach (DataRow row in arrBase)
                {
                    ArrayList alBaseParams = new ArrayList();//增加要更新的基础标志位信息;
                    alBaseParams.Add(checkNo);
                    alBaseParams.Add(row["SAMPLE_NO"].ToString());
                    all.Add(alBaseParams);
                }

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

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

        #endregion

        private void ultraOK_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            try
            {
                if (publicUltraGridBase1.Ur == null || publicUltraGridBase1.Ur.Activated == false || publicUltraGridDetail1.Ur == null || publicUltraGridDetail1.Ur.Activated == false)
                {
                    return;
                }
                return;
                if (MessageUtil.ShowYesNoAndQuestion("是否确认单只样管？") == DialogResult.Yes)
                {
                    string strCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim();
                    ArrayList all = new ArrayList();

                    ArrayList alIs = new ArrayList();//第一组参数
                    alIs.Add(publicUltraGridDetail1.Ur.Cells["SAMPLE_NO"].Text.Trim());
                    alIs.Add(strCHECK_NO);

                    ArrayList alConfrim = new ArrayList();//第一组参数
                    alConfrim.Add("9");
                    //alConfrim.Add("");
                    alConfrim.Add("0");
                    alConfrim.Add(publicUltraGridDetail1.Ur.Cells["SAMPLE_NO"].Text.Trim());
                    alConfrim.Add(strCHECK_NO);

                    ArrayList alBase = new ArrayList();//第三组参数
                    alBase.Add("2");
                    alBase.Add(UserInfo.GetUserName());
                    alBase.Add(DateTime.Now.ToString());
                    alBase.Add("");
                    alBase.Add("");
                    alBase.Add("1");
                    alBase.Add(strCHECK_NO);

                    all.Add(alIs);
                    all.Add(alConfrim);
                    all.Add(alBase);
                    PublicServer.SetData("com.steering.lims.data.pipe.FrmJGSampleConfirm.UpdateCheckConsignDetailConfrim",
                new Object[] { all }, ob);

                    //QueryCheckConsignBase(publicUltraGridBase1, "1");
                    QueryCheckConsignBase();

                    PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase1.Ug, "CHECK_NO", strCHECK_NO);
                }
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
            }
        }

        private void ultraCancel_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            try
            {
                if (publicUltraGridBase2.Ur == null || publicUltraGridBase2.Ur.Activated == false || publicUltraGridDetail2.Ur == null || publicUltraGridDetail2.Ur.Activated == false)
                {
                    return;
                }
                return;
                WinCancelSampleComfirm pc = new WinCancelSampleComfirm();
                pc.ShowDialog();
                if (pc.DialogResult != DialogResult.OK)
                {
                    return;
                }
                string strRemark = pc.StrRemark;
                strRemark = this.Text + "取消单根样管确认由于" + strRemark + "(" + UserInfo.GetUserName() + " " + DateTime.Now.ToString() + ")";

                string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim();
                ArrayList all = new ArrayList();

                ArrayList alIs = new ArrayList();//第一组参数
                //alIs.Add(publicUltraGridDetail2.Ur.Cells["SAMPLE_NO"].Text.Trim());
                alIs.Add(strCHECK_NO);

                ArrayList alConfrim = new ArrayList();//第二组参数
                alConfrim.Add("0");
                //alConfrim.Add("");
                alConfrim.Add("9");
                alConfrim.Add(publicUltraGridDetail2.Ur.Cells["SAMPLE_NO"].Text.Trim());
                alConfrim.Add(strCHECK_NO);

                ArrayList alBase = new ArrayList();//第三组参数
                alBase.Add("1");
                alBase.Add("");
                alBase.Add("");
                alBase.Add(strRemark);
                alBase.Add(strRemark);
                alBase.Add("2");
                alBase.Add(strCHECK_NO);

                all.Add(alIs);
                all.Add(alConfrim);
                all.Add(alBase);

                PublicServer.SetData("com.steering.lims.data.pipe.FrmJGSampleConfirm.CancelUpdateCheckConsignDetailConfrim",
new Object[] { all }, ob);

                //QueryCheckConsignBase(publicUltraGridBase2, "2");
                //QueryCheckConsignBase(publicUltraGridBase1, "1");
                QueryCheckConsignBase();

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

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

        /// <summary>
        /// 打印
        /// </summary>
        /// <param name="publicUltraGridBase"></param>
        private void RepLimsPipeJGSampleConfirm(PublicUltraGridBase publicUltraGridBase)
        {
            try
            {
                //if (ultraTabControl1.SelectedTab.Index != 0)
                //{
                //    MessageUtil.ShowWarning("只有在未确认任务单页才能进行打印来样确认单操作！");
                //    return;
                //}

                this.Cursor = Cursors.WaitCursor;

                publicUltraGridBase.Ug.UpdateData();
                UltraGridRow ugr = publicUltraGridBase.Ug.ActiveRow;
                DataRow[] arrBase = publicUltraGridBase.DataTable.Select("CHK = 'True'");

                //if (arrBase == null || arrBase.Length == 0)
                //{
                //    MessageUtil.ShowWarning("请选择您要打印的加工来样任务单！");
                //    return;
                //}
                //if (arrBase.Length >1)
                //{
                //    MessageUtil.ShowWarning("请选择一张加工来样任务单打印！");
                //    return;
                //}
                string strCHECK_NO = ugr.Cells["CHECK_NO"].Value.ToString();

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

                    alBaseParams = new ArrayList();//增加要更新的基础标志位信息
                    alBaseParams.Add(UserInfo.GetUserName());
                    alBaseParams.Add(strCHECK_NO);
                    alBase.Add(alBaseParams);
                //}
                PublicServer.SetData("com.steering.lims.data.pipe.FrmJGSampleConfirm.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=RepLimsPipeJGSampleConfirm.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();
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }

        private void ultraTabControl1_SelectedTabChanged_1(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (toolMenu == null) return;
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                pipeQueryBase1.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("CancelConfirm"))
                {
                    toolMenu.Toolbars[0].Tools["CancelConfirm"].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.False;
                }


            }
            else if (ultraTabControl1.SelectedTab.Index == 1)
            {
                pipeQueryBase1.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("CancelConfirm"))
                {
                    toolMenu.Toolbars[0].Tools["CancelConfirm"].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;
                }
            }
            QueryCheckConsignBase();
        }

        private void FrmJGSampleConfirm_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("CancelConfirm"))
            {
                toolMenu.Toolbars[0].Tools["CancelConfirm"].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.False;
            }
        }
        private void publicUltraGridDetail2_PublicUltraGridDetailActive(object sender, EventArgs e)
        {
            UltraGridRow uRow = this.publicUltraGridDetail2.Ur;
            UltraGridRow row = this.publicUltraGridBase2.Ur;
            if (uRow == null || row == null) return;
            List<PipeCheckconsignSplinecodeEntity> listSource = EntityHelper.GetData<PipeCheckconsignSplinecodeEntity>(
          "com.steering.lims.data.pipe.FrmJGSampleConfirm.doQuerySplineCode", new object[] { row.Cells["CHECK_NO"].Text, uRow.Cells["SAMPLE_NO"].Text }, this.ob);
            pipeCheckconsignSplinecodeEntityBindingSource1.DataSource = listSource;
        }
    }
       
}