MES_Client/TGMES/Core.StlMes.Client.Lims.Data.Mat/数据管理/原材料实验管理/FrmMatZbsDataCJ.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 FrmMatZbsDataCJ : FrmBase
    {
        public FrmMatZbsDataCJ()
        {
            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;
        }

        private void FrmMatZbsDataCJ_Load(object sender, EventArgs e)
        {
            InitColumns();
        }

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

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

            string[] arrColumns = new string[] { "MAT_CODE", "MAT_NAME", "ZBS_VALUE", "STDMIN_SIGN", "STDMIN", "STDMAX_SIGN", "STDMAX", "CHECK_CYCLE", "JUDGE_TYPE_CODE", "JUDGE_TYPE", "CHECK_CONDITION", "REMARK" };//"FLAG","CHK",
            string[] arrCaption = new string[] { "检验项", "检验项", "质保结果", "下限符号", "下限", "上限符号", "上限", "检验周期", "验收方式", "验收方式", "试验要求", "备注" };//"试样状态","选择",

            publicUltraGridDetail1.InitColumns(arrColumns, arrCaption);
            publicUltraGridDetail1.setColumnShowOrHidden(new string[] { "MAT_CODE" }, false);
            publicUltraGridDetail1.setOtherColumnReadOnly(new string[] { "ZBS_VALUE" });//可编辑列

            publicUltraGridDetail2.InitColumns(arrColumns, arrCaption);
            publicUltraGridDetail2.setColumnShowOrHidden(new string[] { "MAT_CODE" }, false);
            publicUltraGridDetail2.setOtherColumnReadOnly(new string[] { "ZBS_VALUE" });//可编辑列
        }

        void publicUltraGridBase1_PublicUltraGridBaseActive(object sender, EventArgs e)
        {
            matShowBase1.ShowBaseInfo(publicUltraGridBase1.Ur);
            QueryCheckConsignDetail_Dept(publicUltraGridBase1, publicUltraGridDetail1);
        }

        void publicUltraGridBase2_PublicUltraGridBaseActive(object sender, EventArgs e)
        {
            matShowBase2.ShowBaseInfo(publicUltraGridBase2.Ur);
            //matJudgeResultCJ2.ShowBaseInfo(publicUltraGridBase2.Ur);

            QueryCheckConsignDetail_Dept(publicUltraGridBase2, publicUltraGridDetail2);
        }

        /// <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)
                    {
                        QueryZbsCheckConsignDetail(publicUltraGridBase1, "0");
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 1)
                    {
                        QueryZbsCheckConsignDetail(publicUltraGridBase2, "12");
                    }
                    break;
                case "Add":
                    AddZbsCheckConsignDetail();
                    break;
                case "Update":
                    UpdateZbsCheckConsignDetail();
                    break;
                case "Delete":
                    DeleteZbsCheckConsignDetail();
                    break;
                case "View":
                    //RepLimsMatCheckResultJudgeBook();
                    break;
                case "Close":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
                    {
                        this.Close();
                    }
                    break;
            }
        }

        //查询检验委托基本信息
        private void QueryZbsCheckConsignDetail(PublicUltraGridBase publicUltraGridBase, string strFlag)
        {
            try
            {
                ArrayList al = matQueryBase1.GetQueryInfo(strFlag);
                publicUltraGridBase.QueryCheckConsignBaseDetail_Distinct("mat.FrmMatZbsDataCJ", al, this.ob, null);
                if (publicUltraGridBase.Ug.Rows.Count == 0)
                {
                    if (publicUltraGridBase == publicUltraGridBase1)
                    {
                        matShowBase1.ClearCheckConsign();
                        publicUltraGridDetail1.DataTable.Rows.Clear();
                    }
                    else
                    {
                        matShowBase2.ClearCheckConsign();
                        publicUltraGridDetail2.DataTable.Rows.Clear();
                    }
                    //ClearCheckConsign();
                }

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

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

                publicUltraGridDetail.QueryCheckConsignDetail_Dept("mat.FrmMatZbsDataCJ", arrayList, this.ob, -1, null);

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

        private void AddZbsCheckConsignDetail()
        {
            try
            {

                if (ultraTabControl1.SelectedTab.Index != 0)
                {
                    MessageUtil.ShowTips("只有选择了未录入数据页才能进行新增操作！");
                    return;
                }

                if (publicUltraGridBase1.Ur == null)
                {
                    MessageUtil.ShowWarning("请选择需要新增的数据！");
                    return;
                }

                if (publicUltraGridDetail1.DataTable == null || publicUltraGridDetail1.DataTable.Columns.Count < 1 || publicUltraGridDetail1.DataTable.Rows.Count < 1)
                {
                    MessageUtil.ShowWarning("查不到检验明细数据请刷新重试！");
                    return;
                }

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

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

                    ArrayList all = new ArrayList();

                    ArrayList alBase = new ArrayList();
                    ArrayList alBaseDetail = new ArrayList();//改变主表IS_JUDGE标志位
                    alBaseDetail.Add(UserInfo.GetUserName());
                    alBaseDetail.Add(DateTime.Now.ToString());
                    alBaseDetail.Add("");
                    alBaseDetail.Add("");
                    alBaseDetail.Add("1");
                    alBaseDetail.Add("0");
                    alBaseDetail.Add(strCHECK_NO);
                    alBase.Add(alBaseDetail);

                    ArrayList alResult = new ArrayList();
                    ArrayList alResultDetail = new ArrayList();
                    foreach (DataRow dr in publicUltraGridDetail1.DataTable.Rows)
                    {
                        alResultDetail = new ArrayList();

                        if (dr["JUDGE_TYPE_CODE"].ToString().Trim() == "409002" || dr["JUDGE_TYPE"].ToString().Trim() == "检验")
                        {
                            alResultDetail.Add("");//如果为验证则质保书结果写入实际结果列
                            alResultDetail.Add("");//如果为验证则质保书结果写入实际结果列
                        }
                        else
                        {
                            alResultDetail.Add(dr["ZBS_VALUE"].ToString());
                            alResultDetail.Add(dr["ZBS_VALUE"].ToString());
                        }
                        alResultDetail.Add(dr["ZBS_VALUE"].ToString());
                        //alResultDetail.Add(dr["MAT_NAME"].ToString());
                        alResultDetail.Add(dr["MAT_CODE"].ToString());
                        alResultDetail.Add(strCHECK_NO);
                        alResult.Add(alResultDetail);
                    }

                    all.Add(alBase);
                    all.Add(alResult);

                    PublicServer.SetData("com.steering.lims.data.mat.FrmMatZbsDataCJ.AddZbsCheckConsignDetail",
    new Object[] { strCHECK_NO, all }, this.ob);

                    QueryZbsCheckConsignDetail(publicUltraGridBase1, "0");

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

        private void UpdateZbsCheckConsignDetail()
        {
            try
            {

                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowTips("只有选择了已录入数据页才能进行修改操作！");
                    return;
                }

                if (publicUltraGridBase2.Ur == null)
                {
                    MessageUtil.ShowWarning("请选择需要修改的数据！");
                    return;
                }

                if (publicUltraGridDetail2.DataTable == null || publicUltraGridDetail2.DataTable.Columns.Count < 1 || publicUltraGridDetail2.DataTable.Rows.Count < 1)
                {
                    MessageUtil.ShowWarning("查不到检验明细数据请刷新重试！");
                    return;
                }

                //if (MessageUtil.ShowYesNoAndQuestion("是否确认修改？") == DialogResult.Yes)
                //{
                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() + ")";

                publicUltraGridDetail2.Ug.UpdateData();

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

                ArrayList all = new ArrayList();

                ArrayList alBase = new ArrayList();
                ArrayList alBaseDetail = new ArrayList();
                alBaseDetail.Add(UserInfo.GetUserName());
                alBaseDetail.Add(DateTime.Now.ToString());
                alBaseDetail.Add(strSample_Remark);
                alBaseDetail.Add(strSample_Remark);
                alBaseDetail.Add("1");
                alBaseDetail.Add("1");
                alBaseDetail.Add(strCHECK_NO);
                alBase.Add(alBaseDetail);

                ArrayList alResult = new ArrayList();
                ArrayList alResultDetail = new ArrayList();
                foreach (DataRow dr in publicUltraGridDetail2.DataTable.Rows)
                {
                    alResultDetail = new ArrayList();
                    alResultDetail.Add(dr["ZBS_VALUE"].ToString());
                    alResultDetail.Add(dr["MAT_NAME"].ToString());
                    alResultDetail.Add(dr["MAT_CODE"].ToString());
                    alResultDetail.Add(strCHECK_NO);
                    alResult.Add(alResultDetail);
                }

                all.Add(alBase);
                all.Add(alResult);

                PublicServer.SetData("com.steering.lims.data.mat.FrmMatZbsDataCJ.UpdateZbsCheckConsignDetail",
new Object[] { strCHECK_NO, all }, this.ob);

                QueryZbsCheckConsignDetail(publicUltraGridBase2, "12");

                MessageUtil.ShowTips("修改成功！");

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

        private void DeleteZbsCheckConsignDetail()
        {
            try
            {

                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowTips("只有选择了已录入数据页才能进行删除操作！");
                    return;
                }

                if (publicUltraGridBase2.Ur == null)
                {
                    MessageUtil.ShowWarning("请选择需要删除的数据！");
                    return;
                }

                if (publicUltraGridDetail2.DataTable == null || publicUltraGridDetail2.DataTable.Columns.Count < 1 || publicUltraGridDetail2.DataTable.Rows.Count < 1)
                {
                    MessageUtil.ShowWarning("查不到检验明细数据请刷新重试！");
                    return;
                }

                //if (MessageUtil.ShowYesNoAndQuestion("是否确认修改？") == DialogResult.Yes)
                //{
                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() + ")";

                publicUltraGridDetail2.Ug.UpdateData();

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

                ArrayList all = new ArrayList();

                ArrayList alBase = new ArrayList();
                ArrayList alBaseDetail = new ArrayList();
                alBaseDetail.Add("");
                alBaseDetail.Add("");
                alBaseDetail.Add(strSample_Remark);
                alBaseDetail.Add(strSample_Remark);
                alBaseDetail.Add("0");
                alBaseDetail.Add("1");
                alBaseDetail.Add(strCHECK_NO);
                alBase.Add(alBaseDetail);

                ArrayList alResult = new ArrayList();
                ArrayList alResultDetail = new ArrayList();
                foreach (DataRow dr in publicUltraGridDetail2.DataTable.Rows)
                {
                    alResultDetail = new ArrayList();
                    alResultDetail.Add("");
                    alResultDetail.Add(dr["MAT_NAME"].ToString());
                    alResultDetail.Add(dr["MAT_CODE"].ToString());
                    alResultDetail.Add(strCHECK_NO);
                    alResult.Add(alResultDetail);
                }

                all.Add(alBase);
                all.Add(alResult);

                PublicServer.SetData("com.steering.lims.data.mat.FrmMatZbsDataCJ.DeleteZbsCheckConsignDetail",
new Object[] { strCHECK_NO, all }, this.ob);

                QueryZbsCheckConsignDetail(publicUltraGridBase2, "12");

                MessageUtil.ShowTips("删除成功！");

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