MES_Client/TGMES/Core.StlMes.Client.Lims.Data.PipeAndOutdec/数据管理/钢管实验管理/FrmJGSampleConfirmTH.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 FrmJGSampleConfirmTH : FrmBase
    {
        private string[] plineCodes = { };

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

        private void FrmJGSampleConfirmTH_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_TH", "CONFIRM_NAME", "CONFIRM_TIME", "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", "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 "Cancel":
                    CancelConfirmCheckConsignDetail();
                    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;
            }
        }

        /// <summary>
        /// 取消确认
        /// </summary>
        private void CancelConfirmCheckConsignDetail()
        {
            try
            {
               
                if (publicUltraGridDetail2.Ur == null)
                {
                    MessageUtil.ShowWarning("请点击选择需要取消确认的样管！");
                    return;
                }
                
                //if (MessageUtil.ShowYesNoAndQuestion("是否确认取消？") == DialogResult.Yes)
                //{
                //WinCancelSampleComfirm pc = new WinCancelSampleComfirm();
                //pc.ShowDialog();
                //if (pc.DialogResult != DialogResult.OK)
                //{
                //    return;
                //}
               
                ArrayList all = new ArrayList();

                UltraGridRow ugr = publicUltraGridBase2.Ug.ActiveRow;
                string user = UserInfo.GetUserName();
                string strDate = DateTime.Now.ToString();
                string checkNo = ugr.Cells["CHECK_NO"].Value.ToString();

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

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.lims.data.pipe.PublicPipeBase";
                ccp.MethodName = "cancelConfirmBaseInfoTH";
                ccp.ServerParams = new object[] { 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);
                    }
                }

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

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

        //查询检验委托基本信息
        /// <summary>
        /// 查询检验委托基本信息
        /// </summary>
        private void QueryCheckConsignBase()
        {
            try
            {
                PublicUltraGridBase publicUltraGridBase = publicUltraGridBase2;
                string strFlag = "1";
                // if (ultraTabControl1.SelectedTab.Index == 1)
                //{
                    publicUltraGridBase = publicUltraGridBase2;
                    strFlag = "2345";
                    ArrayList arrayList = pipeQueryBase1.GetQueryInfo(strFlag);
                    arrayList.Add(plineCodes);
                    publicUltraGridBase.QueryCheckConsignBaseTH("pipe.PublicPipeBase", arrayList, this.ob);
                //}
                // else if (ultraTabControl1.SelectedTab.Index == 0)
                // {
                //     ArrayList arrayList = pipeQueryBase1.GetQueryInfo(strFlag);
                //     arrayList.Add(plineCodes);
                //     publicUltraGridBase.QueryCheckConsignBaseTH("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
                ChangeColor(publicUltraGridBase2.Ug);
            }
            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_TH"))
            {
                foreach (UltraGridRow dr in ultraGrid.Rows)
                {
                    if (dr.Cells["FLAG_TH"].Text.Trim() == "已确认")
                    {
                        dr.Appearance.BackColor = Color.LightGreen;//LightGray灰色
                    }
                    else if (dr.Cells["FLAG_TH"].Text.Trim() == "未确认")
                    {
                        dr.Appearance.BackColor = Color.White;//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;
            }
        }

        //确认来样
        // <summary>
        // 确认来样
        // </summary>
        private void UpdateCheckConsign()
        {
            try
            {
                if (publicUltraGridBase2.Ug == null || publicUltraGridBase2.Ug.Rows.Count == 0)
                {
                    return;
                }

                publicUltraGridBase2.Ug.UpdateData();

                
                //if (MessageUtil.ShowYesNoAndQuestion("是否来样确认？") == DialogResult.Yes)
                //{
                UltraGridRow ugr = publicUltraGridBase2.Ug.ActiveRow;
                    string user = UserInfo.GetUserName();
                    string strDate = DateTime.Now.ToString();
                    string checkNo = ugr.Cells["CHECK_NO"].Value.ToString();
                    
                    ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息
                    alBase.Add(checkNo);
                    alBase.Add(user);
        
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "com.steering.lims.data.pipe.PublicPipeBase";
                    ccp.MethodName = "confirmBaseInfoTH";
                    ccp.ServerParams = new object[] {  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;
        }
    }
       
}