MES_Client/TGMES/Core.StlMes.Client.Lims.Data.Mat/数据管理/原材料实验管理/FrmMatDataCJ.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 Infragistics.Win.UltraWinGrid;
using Core.Mes.Client.Comm.Tool;
using System.Collections;
using Core.Mes.Client.Comm.Control;
using Infragistics.Win;

namespace Core.StlMes.Client.Lims.Data.Mat
{
    public partial class FrmMatDataCJ : FrmBase
    {
        private string arrIdStr;//数据权限

        private string[] arrId;//数据权限

        public FrmMatDataCJ()
        {
            InitializeComponent();
        }

        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            publicUltraGridBase1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
            publicUltraGridDetail1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            publicUltraGridBase2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
            publicUltraGridDetail2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            publicUltraGridBase3.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
            publicUltraGridDetail3.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            publicUltraGridBase4.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
            publicUltraGridDetail4.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
        }

        private void FrmMatDataCJ_Load(object sender, EventArgs e)
        {
            arrId = UserInfo.GetUserName() == "admin" ? PublicMat.ValidData() : this.ValidDataPurviewIds;

            arrIdStr = PublicMat.ValidDataString(arrId);

            InitColumns();
        }

        private void InitColumns()
        {
            publicUltraGridBase1.PublicUltraGridBaseActive += new EventHandler(publicUltraGridBase1_PublicUltraGridBaseActive);//调用委托事件
            publicUltraGridBase1.InitColumnsBase(new string[] { "CHECK_NO" }, true, null);

            string[] arrColumns = new string[] { "SAMPLE_NO" };//"FLAG","CHK",
            string[] arrCaption = new string[] { "试样号" };//"试样状态","选择",

            publicUltraGridDetail1.InitColumns(arrColumns, arrCaption);
            publicUltraGridDetail1.setOtherColumnReadOnly(null);//可编辑列

            publicUltraGridBase2.PublicUltraGridBaseActive += new EventHandler(publicUltraGridBase2_PublicUltraGridBaseActive);//调用委托事件
            publicUltraGridBase2.InitColumnsBase(new string[] { "CHECK_NO" }, true, null);

            publicUltraGridDetail2.InitColumns(arrColumns, arrCaption);
            publicUltraGridDetail2.setOtherColumnReadOnly(null);//可编辑列

            publicUltraGridBase3.PublicUltraGridBaseActive += new EventHandler(publicUltraGridBase3_PublicUltraGridBaseActive);//调用委托事件
            publicUltraGridBase3.InitColumnsBase(new string[] { "CHK", "CHECK_NO" }, true, new string[] { "CHK" });

            publicUltraGridDetail3.InitColumns(arrColumns, arrCaption);
            publicUltraGridDetail3.setOtherColumnReadOnly(null);//可编辑列

            publicUltraGridBase4.PublicUltraGridBaseActive += new EventHandler(publicUltraGridBase4_PublicUltraGridBaseActive);//调用委托事件
            publicUltraGridBase4.InitColumnsBase(new string[] { "CHK", "CHECK_NO" }, true, new string[] { "CHK" });

            publicUltraGridDetail4.InitColumns(arrColumns, arrCaption);
            publicUltraGridDetail4.setOtherColumnReadOnly(null);//可编辑列
        }

        /// <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)
                    {
                        QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "1");
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 1)
                    {
                        QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "2345");
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 2)
                    {
                        QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase3, "2");
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 3)
                    {
                        QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase4, "3456");
                    }
                    break;
                case "Add":
                    AddCheckConsignDetail();
                    break;
                case "Update":
                    UpdateCheckConsignDetail();
                    break;
                case "Delete":
                    DeleteCheckConsignDetail();
                    break;
                case "Audit":
                    AuditCheckConsignDetail();
                    break;
                case "CancelAudit":
                    CancelAuditCheckConsignDetail();
                    break;
                case "Print":
                    RepLimsMatCheckResultQuote();
                    break;
                case "Close":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
                    {
                        this.Close();
                    }
                    break;
            }
        }

        //查询检验委托基本信息
        private void QueryCheckConsignBaseDetail_Distinct(PublicUltraGridBase publicUltraGridBase, string strFlag)
        {
            try
            {
                publicUltraGridBase.QueryCheckConsignBaseDetail_Distinct("mat.PublicMatBase", matQueryBase1.GetQueryInfo(strFlag), this.ob, arrId == null ? new string[] { UserInfo.GetDeptid() } : arrId);
                if (publicUltraGridBase.Ug.Rows.Count == 0)
                {
                    if (publicUltraGridBase == publicUltraGridBase1)
                    {
                        matShowBase1.ClearCheckConsign();
                        matDataCJBase1.ClearAll();
                        publicUltraGridDetail1.DataTable.Rows.Clear();
                    }
                    else if (publicUltraGridBase == publicUltraGridBase2)
                    {
                        matShowBase2.ClearCheckConsign();
                        matDataCJBase2.ClearAll();
                        publicUltraGridDetail2.DataTable.Rows.Clear();
                    }
                    else if (publicUltraGridBase == publicUltraGridBase3)
                    {
                        matShowBase3.ClearCheckConsign();
                        matDataCJBase3.ClearAll();
                        publicUltraGridDetail3.DataTable.Rows.Clear();
                    }
                    else if (publicUltraGridBase == publicUltraGridBase4)
                    {
                        matShowBase4.ClearCheckConsign();
                        matDataCJBase4.ClearAll();
                        publicUltraGridDetail4.DataTable.Rows.Clear();
                    }
                    //ClearCheckConsign();
                }
                else if (publicUltraGridBase == publicUltraGridBase3 || publicUltraGridBase == publicUltraGridBase4)
                {
                    GridHelper.RefreshAndAutoSize(publicUltraGridBase.Ug);
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        //查询检验委托明细信息
        private void QueryCheckConsignDetail_Dept(PublicUltraGridBase publicUltraGridBase, PublicUltraGridDetail publicUltraGridDetail)
        {
            try
            {
                ArrayList arrayList = new ArrayList();
                arrayList.Add("");
                arrayList.Add("");
                arrayList.Add("");
                arrayList.Add(publicUltraGridBase.Ur.Cells["CHECK_NO"].Text.Trim());

                publicUltraGridDetail.QueryCheckConsignDetail_Dept("mat.PublicMatBase", arrayList, this.ob, 1, arrId == null ? new string[] { UserInfo.GetDeptid() } : arrId);

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

        #region 未录入

        void publicUltraGridBase1_PublicUltraGridBaseActive(object sender, EventArgs e)
        {
            matShowBase1.ShowBaseInfo(publicUltraGridBase1.Ur, new string[] { "SUPP_NAME" });
            matDataCJBase1.ClearAll();
            QueryCheckConsignDetail_Dept(publicUltraGridBase1, publicUltraGridDetail1);
        }

        //增加检验委托结果数据
        private void AddCheckConsignDetail()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 0)
                {
                    MessageUtil.ShowTips("只有选择了未录入数据页才能进行新增操作！");
                    return;
                }

                if (publicUltraGridDetail1.DataTable == null || publicUltraGridDetail1.DataTable.Columns.Count < 2 || publicUltraGridDetail1.DataTable.Rows.Count < 2)
                {
                    MessageUtil.ShowWarning("查不到检验明细数据请刷新重试！");
                    return;
                }
                if (publicUltraGridBase1.Ur == null)
                {
                    MessageUtil.ShowWarning("请选择需要新增的数据！");
                    return;
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否确认新增？") == DialogResult.Yes)
                {
                    publicUltraGridDetail1.Ug.UpdateData();

                    string strCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim();//检验委托编号

                    string strName = matDataCJBase1.StrName == "" ? UserInfo.GetUserName() : matDataCJBase1.StrName;
                    string strTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
                    string strShift = matDataCJBase1.StrShift == "" ? UserInfo.GetUserOrderText() : matDataCJBase1.StrShift;//班次
                    string strClass = matDataCJBase1.StrClass == "" ? UserInfo.GetUserGroupText() : matDataCJBase1.StrClass;//班组
                    string strDevice_No = matDataCJBase1.StrDevice_No;
                    string strDevice_Name = matDataCJBase1.StrDevice_Name;
                    string strTemp = matDataCJBase1.StrTemp;
                    string strSample_Remark = "";
                    string strRemark = matDataCJBase1.StrRemark;

                    ArrayList alDetail = new ArrayList();//检验信息详细表list
                    ArrayList alDetailParams = new ArrayList();//检验信息详细表参数list

                    for (int i = 1; i < publicUltraGridDetail1.DataTable.Rows.Count; i++)
                    {
                        foreach (DataColumn dc in publicUltraGridDetail1.DataTable.Columns)
                        {
                            if (dc.ColumnName != "SAMPLE_NO")
                            {
                                alDetailParams = new ArrayList();
                                alDetailParams.Add("2");

                                alDetailParams.Add(strName);//试验人
                                alDetailParams.Add(strTime);
                                alDetailParams.Add(strShift);
                                alDetailParams.Add(strClass);
                                alDetailParams.Add(strDevice_No);//设备编号strTemp
                                alDetailParams.Add(strDevice_Name);
                                alDetailParams.Add(strTemp);
                                alDetailParams.Add(strSample_Remark);
                                alDetailParams.Add(strSample_Remark);
                                alDetailParams.Add(strRemark);

                                alDetailParams.Add(publicUltraGridDetail1.DataTable.Rows[i][dc.ColumnName].ToString().Trim());//值

                                alDetailParams.Add("1");
                                alDetailParams.Add(dc.ColumnName);//mat_code
                                alDetailParams.Add(publicUltraGridDetail1.DataTable.Rows[i]["SAMPLE_NO"].ToString().Trim());//检验试样号
                                alDetailParams.Add(strCHECK_NO);//检验编号

                                alDetail.Add(alDetailParams);
                            }
                        }
                    }

                    PublicServer.SetData("com.steering.lims.data.mat.FrmMatDataCJ.AddCheckConsignDetail",
new Object[] { alDetail }, this.ob);

                    QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "1");
                    QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "2345");

                    PublicMat.ActiveOperateRow(publicUltraGridBase2.Ug, "CHECK_NO", strCHECK_NO);

                    MessageUtil.ShowTips("新增成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        #endregion

        #region 已录入
        void publicUltraGridBase2_PublicUltraGridBaseActive(object sender, EventArgs e)
        {
            matShowBase2.ShowBaseInfo(publicUltraGridBase2.Ur, new string[] { "SUPP_NAME" });
            matDataCJBase2.ClearAll();
            QueryCheckConsignDetail_Dept(publicUltraGridBase2, publicUltraGridDetail2);

            //查询实验备注基本信息
            QueryCheckConsignDetail_DataCJBase_Distinct(matDataCJBase2, publicUltraGridBase2);
        }

        //查询检验委托明细信息
        private void QueryCheckConsignDetail_DataCJBase_Distinct(MatDataCJBase matDataCJBase, PublicUltraGridBase publicUltraGridBase)
        {
            try
            {
                ArrayList arrayList = new ArrayList();
                arrayList.Add("");
                arrayList.Add("");
                arrayList.Add("");
                arrayList.Add(publicUltraGridBase.Ur.Cells["CHECK_NO"].Text.Trim());

                DataTable dt = PublicServer.GetData("com.steering.lims.data.mat.FrmMatDataCJ.QueryCheckConsignDetail_DataCJBase_Distinct",
                            new Object[] { arrayList, arrId }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    return;
                }
                matDataCJBase.StrName = dt.Rows[0]["CHECK_NAME"].ToString().Trim();
                matDataCJBase.StrTime = dt.Rows[0]["CHECK_TIME"].ToString().Trim();
                matDataCJBase.StrShift = dt.Rows[0]["CHECK_SHIFT"].ToString().Trim();
                matDataCJBase.StrClass = dt.Rows[0]["CHECK_CLASS"].ToString().Trim();
                matDataCJBase.StrDevice_No = dt.Rows[0]["DEVICE_NO"].ToString().Trim();
                matDataCJBase.StrDevice_Name = dt.Rows[0]["DEVICE_NAME"].ToString().Trim();
                matDataCJBase.StrTemp = dt.Rows[0]["CHECK_TEMP"].ToString().Trim();
                matDataCJBase.StrRemark = dt.Rows[0]["REMARK"].ToString().Trim();
                matDataCJBase.StrAuditName = dt.Rows[0]["AUDIT_NAME"].ToString().Trim();
                matDataCJBase.StrAuditTime = dt.Rows[0]["AUDIT_TIME"].ToString().Trim();
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
                return;
            }
        }

        //修改检验委托结果数据
        private void UpdateCheckConsignDetail()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowTips("只有选择了已录入数据页才能进行修改操作！");
                    return;
                }
                if (publicUltraGridDetail2.DataTable == null || publicUltraGridDetail2.DataTable.Columns.Count < 2 || publicUltraGridDetail2.DataTable.Rows.Count < 2)
                {
                    MessageUtil.ShowWarning("查不到检验明细数据请刷新重试！");
                    return;
                }
                if (publicUltraGridBase2.Ur == null)
                {
                    MessageUtil.ShowWarning("请选择需要修改的数据！");
                    return;
                }
                //if (MessageUtil.ShowYesNoAndQuestion("是否确认修改？") == DialogResult.Yes)
                //{
                publicUltraGridDetail2.Ug.UpdateData();

                string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim();//检验委托编号

                string strName = matDataCJBase2.StrName == "" ? UserInfo.GetUserName() : matDataCJBase2.StrName;
                string strTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
                string strShift = matDataCJBase2.StrShift == "" ? UserInfo.GetUserOrderText() : matDataCJBase2.StrShift;//班次
                string strClass = matDataCJBase2.StrClass == "" ? UserInfo.GetUserGroupText() : matDataCJBase2.StrClass;//班组
                string strDevice_No = matDataCJBase2.StrDevice_No;
                string strDevice_Name = matDataCJBase2.StrDevice_Name;
                string strTemp = matDataCJBase2.StrTemp;

                WinCancelReason pc = new WinCancelReason();
                pc.ShowDialog();
                if (pc.DialogResult != DialogResult.OK)
                {
                    return;
                }
                string strSample_Remark = pc.StrRemark;
                strSample_Remark = this.Text + "修改由于" + strSample_Remark + "(" + strName + " " + strTime + ")";

                string strRemark = matDataCJBase2.StrRemark;

                ArrayList alDetail = new ArrayList();//检验信息详细表list
                ArrayList alDetailParams = new ArrayList();//检验信息详细表参数list

                for (int i = 1; i < publicUltraGridDetail2.DataTable.Rows.Count; i++)
                {
                    foreach (DataColumn dc in publicUltraGridDetail2.DataTable.Columns)
                    {
                        if (dc.ColumnName != "SAMPLE_NO")
                        {
                            alDetailParams = new ArrayList();
                            alDetailParams.Add("2");

                            alDetailParams.Add(strName);//试验人
                            alDetailParams.Add(strTime);
                            alDetailParams.Add(strShift);
                            alDetailParams.Add(strClass);
                            alDetailParams.Add(strDevice_No);//设备编号strTemp
                            alDetailParams.Add(strDevice_Name);
                            alDetailParams.Add(strTemp);
                            alDetailParams.Add(strSample_Remark);
                            alDetailParams.Add(strSample_Remark);
                            alDetailParams.Add(strRemark);

                            alDetailParams.Add(publicUltraGridDetail2.DataTable.Rows[i][dc.ColumnName].ToString().Trim());//值

                            alDetailParams.Add("2");
                            alDetailParams.Add(dc.ColumnName);//mat_code
                            alDetailParams.Add(publicUltraGridDetail2.DataTable.Rows[i]["SAMPLE_NO"].ToString().Trim());//检验试样号
                            alDetailParams.Add(strCHECK_NO);//检验编号

                            alDetail.Add(alDetailParams);
                        }
                    }
                }

                PublicServer.SetData("com.steering.lims.data.mat.FrmMatDataCJ.UpdateCheckConsignDetail",
new Object[] { strCHECK_NO, arrId, alDetail }, this.ob);

                //QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "1");
                QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "2345");

                PublicMat.ActiveOperateRow(publicUltraGridBase2.Ug, "CHECK_NO", strCHECK_NO);

                MessageUtil.ShowTips("修改成功！");
                //}
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        //删除检验委托结果数据
        private void DeleteCheckConsignDetail()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowTips("只有选择了已录入数据页才能进行删除操作！");
                    return;
                }

                //if (publicUltraGridDetail2.DataTable == null || publicUltraGridDetail2.DataTable.Columns.Count < 2 || publicUltraGridDetail2.DataTable.Rows.Count < 2)
                //{
                //    MessageUtil.ShowWarning("查不到检验明细数据请刷新重试！");
                //    return;
                //}
                if (publicUltraGridBase2.Ur == null)
                {
                    MessageUtil.ShowWarning("请选择需要删除的数据！");
                    return;
                }

                publicUltraGridDetail2.Ug.UpdateData();

                string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim();//检验委托编号

                string strName = "";
                string strTime = "";
                string strShift = "";//班次
                string strClass = "";//班组
                string strDevice_No = "";
                string strDevice_Name = "";
                string strTemp = "";

                WinCancelReason pc = new WinCancelReason();
                pc.ShowDialog();
                if (pc.DialogResult != DialogResult.OK)
                {
                    return;
                }
                string strSample_Remark = pc.StrRemark;
                strSample_Remark = this.Text + "删除由于" + strSample_Remark + "(" + UserInfo.GetUserName() + " " + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + ")";

                string strRemark = "";

                ArrayList alDetail = new ArrayList();//检验信息详细表list
                ArrayList alDetailParams = new ArrayList();//检验信息详细表参数list

                for (int i = 1; i < publicUltraGridDetail2.DataTable.Rows.Count; i++)
                {
                    foreach (DataColumn dc in publicUltraGridDetail2.DataTable.Columns)
                    {
                        if (dc.ColumnName != "SAMPLE_NO")
                        {
                            alDetailParams = new ArrayList();
                            alDetailParams.Add("1");

                            alDetailParams.Add(strName);//试验人
                            alDetailParams.Add(strTime);
                            alDetailParams.Add(strShift);
                            alDetailParams.Add(strClass);
                            alDetailParams.Add(strDevice_No);//设备编号strTemp
                            alDetailParams.Add(strDevice_Name);
                            alDetailParams.Add(strTemp);
                            alDetailParams.Add(strSample_Remark);
                            alDetailParams.Add(strSample_Remark);
                            alDetailParams.Add(strRemark);

                            alDetailParams.Add("");//值

                            alDetailParams.Add("2");
                            alDetailParams.Add(dc.ColumnName);//mat_code
                            alDetailParams.Add(publicUltraGridDetail2.DataTable.Rows[i]["SAMPLE_NO"].ToString().Trim());//检验试样号
                            alDetailParams.Add(strCHECK_NO);//检验编号

                            alDetail.Add(alDetailParams);
                        }
                    }
                }

                PublicServer.SetData("com.steering.lims.data.mat.FrmMatDataCJ.DeleteCheckConsignDetail",
new Object[] { strCHECK_NO, arrId, alDetail }, this.ob);

                QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "2345");
                QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "1");

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

                MessageUtil.ShowTips("删除成功！");
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void RepLimsMatCheckResultQuote()
        {
            try
            {
                //if (ultraTabControl1.SelectedTab.Index != 1)
                //{
                //    MessageUtil.ShowTips("只有选择了已录入数据页才能进行打印操作！");
                //    return;
                //}
                if (ultraTabControl1.SelectedTab.Index != 3)
                {
                    MessageUtil.ShowTips("只有选择了已审核数据页才能进行打印操作！");
                    return;
                }
                this.Cursor = Cursors.WaitCursor;
                UltraGridRow ugr = publicUltraGridBase4.Ur;//publicUltraGridBase2.Ur;
                if (ugr == null)
                {
                    MessageUtil.ShowWarning("请选择您要打印的检验任务单！");
                    return;
                }
                string strCHECK_NO = ugr.Cells["CHECK_NO"].Value.ToString();
                string strurl = "";
                //if (ob.MainUrl.StartsWith("http://127.0.0.1"))
                //{
                //    strurl = "http://localhost:8075/WebReport/ReportServer?reportlet=RepLimsMatCheckResultQuote.cpt&bypagesize=false" + "&CHECK_NO=" + strCHECK_NO+ "&DEPT_ID=" + arrIdStr;

                //}
                //else
                //{
                strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsMatCheckResultQuote.cpt&bypagesize=false" + "&CHECK_NO=" + strCHECK_NO + "&DEPT_ID=" + arrIdStr;
                //}
                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

        #region 未审核
        void publicUltraGridBase3_PublicUltraGridBaseActive(object sender, EventArgs e)
        {
            matShowBase3.ShowBaseInfo(publicUltraGridBase3.Ur);
            matDataCJBase3.ClearAll();
            QueryCheckConsignDetail_Dept(publicUltraGridBase3, publicUltraGridDetail3);

            QueryCheckConsignDetail_DataCJBase_Distinct(matDataCJBase3, publicUltraGridBase3);
        }

        private void AuditCheckConsignDetail()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 2)
                {
                    MessageUtil.ShowTips("只有选择了未审核数据页才能进行审核操作！");
                    return;
                }
                publicUltraGridBase3.Ug.UpdateData();
                DataRow[] arrDr = publicUltraGridBase3.DataTable.Select("CHK = 'True'");
                if (arrDr.Length == 0)
                {
                    MessageUtil.ShowTips("请勾选至少一条需要审核的信息！");
                    return;
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否确认审核？") == DialogResult.Yes)
                {
                    string strName = UserInfo.GetUserName();
                    string strTime = DateTime.Now.ToString();
                    string strDept_Id = arrIdStr == null ? UserInfo.GetDeptid() : arrIdStr;

                    ArrayList arrBase = new ArrayList();

                    ArrayList arrBaseParams = new ArrayList();
                    foreach (DataRow dr in arrDr)
                    {
                        arrBaseParams = new ArrayList();
                        arrBaseParams.Add("3");
                        arrBaseParams.Add(strName);
                        arrBaseParams.Add(strTime);
                        arrBaseParams.Add("");
                        arrBaseParams.Add("");
                        arrBaseParams.Add("2");
                        arrBaseParams.Add(strDept_Id);
                        arrBaseParams.Add(dr["CHECK_NO"].ToString());
                        arrBase.Add(arrBaseParams);
                    }

                    PublicServer.SetData("com.steering.lims.data.mat.FrmMatDataCJ.AuditCheckConsignDetail",
    new Object[] { arrBase }, this.ob);

                    QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase3, "2");

                    MessageUtil.ShowTips("审核成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        #endregion

        #region 已审核
        void publicUltraGridBase4_PublicUltraGridBaseActive(object sender, EventArgs e)
        {
            matShowBase4.ShowBaseInfo(publicUltraGridBase4.Ur);
            matDataCJBase4.ClearAll();
            QueryCheckConsignDetail_Dept(publicUltraGridBase4, publicUltraGridDetail4);

            QueryCheckConsignDetail_DataCJBase_Distinct(matDataCJBase4, publicUltraGridBase4);
        }

        private void CancelAuditCheckConsignDetail()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 3)
                {
                    MessageUtil.ShowTips("只有选择了已审核数据页才能进行取消审核操作！");
                    return;
                }
                publicUltraGridBase4.Ug.UpdateData();
                DataRow[] arrDr = publicUltraGridBase4.DataTable.Select("CHK = 'True'");
                if (arrDr.Length != 1)
                {
                    MessageUtil.ShowTips("请勾选一条需要取消审核的信息！");
                    return;
                }

                WinCancelReason pc = new WinCancelReason();
                pc.ShowDialog();
                if (pc.DialogResult != DialogResult.OK)
                {
                    return;
                }

                string strName = UserInfo.GetUserName();
                string strTime = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");

                string strSample_Remark = pc.StrRemark;
                strSample_Remark = this.Text + "取消审核由于" + strSample_Remark + "(" + strName + " " + strTime + ")";

                string strCHECK_NO = arrDr[0]["CHECK_NO"].ToString();
                string strDept_Id = arrIdStr == null ? UserInfo.GetDeptid() : arrIdStr;

                ArrayList arrBaseParams = new ArrayList();
                foreach (DataRow dr in arrDr)
                {
                    arrBaseParams = new ArrayList();
                    arrBaseParams.Add("2");
                    arrBaseParams.Add("");
                    arrBaseParams.Add("");
                    arrBaseParams.Add(strSample_Remark);
                    arrBaseParams.Add(strSample_Remark);
                    arrBaseParams.Add("3");
                    arrBaseParams.Add(strDept_Id);
                    arrBaseParams.Add(dr["CHECK_NO"].ToString());
                }

                PublicServer.SetData("com.steering.lims.data.mat.FrmMatDataCJ.CancelAuditCheckConsignDetail",
new Object[] { strCHECK_NO, arrId, arrBaseParams }, this.ob);

                QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase4, "3456");

                MessageUtil.ShowTips("取消审核成功！");
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        #endregion

        private void View_Click(object sender, EventArgs e)
        {
            UltraGridRow ur = publicUltraGridBase2.Ur;

            if (ur == null)
            {
                MessageUtil.ShowWarning("请选择一条需要查看上传文件的记录！");
                return;
            }
            string strTableName = "MAT_CHECKCONSIGN_BASEINFO";
            string strCHECK_NO = ur.Cells["CHECK_NO"].Text.Trim();
            string path = "Lims/data/mat/" + this.Name + "/" + strCHECK_NO + "/";
            if (PublicMat.ViewFilePosition(this.ob, path) == false)
            {
                PublicMat.UpdateFilePosition(strTableName, "FILE_POSITION_RESULT", path, "CHECK_NO", strCHECK_NO, this.ob);//更改数据库存储路径
                QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "2345");
                PublicMat.ActiveOperateRow(publicUltraGridBase2.Ug, "CHECK_NO", strCHECK_NO);//定位保存的行
            }
        }

        private void Upload_Click(object sender, EventArgs e)
        {
            UltraGridRow ur = publicUltraGridBase2.Ur;

            if (ur == null)
            {
                MessageUtil.ShowWarning("请选择一条需要上传文件的记录！");
                return;
            }

            //if (ur.Cells["FILE_POSITION_RESULT"].Text.Trim() != "")
            //{
            //    MessageUtil.ShowWarning("该记录已存在一份文件，请删除后再重新上传！");
            //    return;
            //}

            string strTableName = "MAT_CHECKCONSIGN_BASEINFO";
            string strCHECK_NO = ur.Cells["CHECK_NO"].Text.Trim();
            string path = "Lims/data/mat/" + this.Name + "/" + strCHECK_NO + "/";
            if (PublicMat.UploadFilePosition(this.ob, path))
            {
                PublicMat.UpdateFilePosition(strTableName, "FILE_POSITION_RESULT", path, "CHECK_NO", strCHECK_NO, this.ob);//更改数据库存储路径

                QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "2345");
                PublicMat.ActiveOperateRow(publicUltraGridBase2.Ug, "CHECK_NO", strCHECK_NO);
            }
        }

        private void FrmMatDataCJ_Shown(object sender, EventArgs e)
        {
            if (toolMenu == null) return;
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                {
                    toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Update"))
                {
                    this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
                {
                    toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
                {
                    this.toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
                {
                    toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False;
                }
            }
            else if (ultraTabControl1.SelectedTab.Index == 1)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                {
                    toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Update"))
                {
                    this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
                {
                    toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
                {
                    this.toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
                {
                    toolMenu.Toolbars[0].Tools["CancelAudit"].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 == 2)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                {
                    toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Update"))
                {
                    this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
                {
                    toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
                {
                    this.toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
                {
                    toolMenu.Toolbars[0].Tools["CancelAudit"].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 == 3)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                {
                    toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Update"))
                {
                    this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
                {
                    toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
                {
                    this.toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
                {
                    toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.True;
                }
            }
        }

        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("Add"))
                {
                    toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Update"))
                {
                    this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
                {
                    toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
                {
                    this.toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
                {
                    toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False;
                }
            }
            else if (ultraTabControl1.SelectedTab.Index == 1)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                {
                    toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Update"))
                {
                    this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
                {
                    toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
                {
                    this.toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
                {
                    toolMenu.Toolbars[0].Tools["CancelAudit"].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 == 2)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                {
                    toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Update"))
                {
                    this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
                {
                    toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
                {
                    this.toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
                {
                    toolMenu.Toolbars[0].Tools["CancelAudit"].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 == 3)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                {
                    toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Update"))
                {
                    this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
                {
                    toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
                {
                    this.toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
                {
                    toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.True;
                }
            }
        }
    }
}