MES_Client/TGMES/Core.StlMes.Client.Lims.Data.Mat/数据管理/基础信息管理/FrmBaseMatStdDetail.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;

namespace Core.StlMes.Client.Lims.Data.Mat
{
    public partial class FrmBaseMatStdDetail : FrmBase
    {
        public FrmBaseMatStdDetail()
        {
            InitializeComponent();
        }

        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            ultraGrid1.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
            ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            ultraGrid3.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            ultraGrid4.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
        }

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

        private void InitColumns()
        {
            //各表记入备注
            string[] arrColumnsCheck = new string[] { "STANDARDS_ID", "STANDARDS_NO", "STANDARDS_CODE" };
            string[] arrCaptionCheck = new string[] { "检验标准", "检验标准组号", "检验标准" };
            PublicMat.InitColumns(arrColumnsCheck, arrCaptionCheck, dataTable1, ultraGrid1, new string[] { "STANDARDS_CODE" }, true, null);

            string[] arrColumns = new string[] { "CHK", "PRODUCT_STD_ID", "PRODUCT_STD_NO", "PRODUCT_STD", "ITEM_CODE", "ITEM_NAME", "GRADE", "STANDARDS_ID", "STANDARDS_CODE", "VALIDFLAG", "REMARK" };
            string[] arrCaption = new string[] { "选择", "检验标准", "检验标准组号", "检验标准", "物料名称", "物料名称", "牌号", "产品标准", "产品标准", "是否有效", "备注" };
            PublicMat.InitColumns(arrColumns, arrCaption, dataTable2, ultraGrid2, new string[] { "CHK", "ITEM_CODE", "STANDARDS_CODE", "REMARK" }, true, new string[] { "CHK", "ITEM_CODE", "STANDARDS_CODE", "REMARK" });

            string[] arrColumnsBase = new string[] { "CHK", "MIC", "MIC_DESC", "PRODUCT_STD_ID", "PRODUCT_STD", "ITEM_CODE", "ITEM_NAME", "GRADE", "STANDARDS_ID", "STANDARDS_CODE", "GROUP_LEVEL_CODE", "GROUP_LEVEL", "JUDGE_LEVEL_CODE", "JUDGE_LEVEL", "ITEM_ATTR_ID", "ITEM_ATTR", "JUDGE_TYPE_CODE", "JUDGE_TYPE", "CHECK_CYCLE", "GET_SAMPLE_STD_NO", "GET_SAMPLE_STD", "GET_SAMPLE_STD_RATE", "BATCH_COUNT", "GET_SAMPLE_STD_RATE_UNIT", "GET_SAMPLE_STD_DESC", "REMARK", "CREATE_NAME", "CREATE_TIME", "UPDATE_NAME", "UPDATE_TIME", "VALIDFLAG" };
            string[] arrCaptionBase = new string[] { "选择", "MIC", "规范描述", "检验标准", "检验标准", "物料名称", "物料名称", "牌号", "产品标准", "产品标准", "组别", "组别", "级别", "级别", "等级属性", "等级属性", "验收方式", "验收方式", "检验/验证周期", "取样标准", "取样标准", "取样频次", "批次量", "批单位", "取样标准描述", "备注", "创建人", "创建时间", "修改人", "修改时间", "是否有效" };
            PublicMat.InitColumns(arrColumnsBase, arrCaptionBase, dataTable3, ultraGrid3, new string[] { "MIC_DESC", "PRODUCT_STD_ID", "PRODUCT_STD", "PRODUCT_STD", "ITEM_CODE", "GRADE", "STANDARDS_ID", "GROUP_LEVEL_CODE", "JUDGE_LEVEL_CODE", "JUDGE_LEVEL", "ITEM_ATTR_ID", "JUDGE_TYPE", "CHECK_CYCLE", "CREATE_NAME", "GET_SAMPLE_STD", "CREATE_TIME", "UPDATE_NAME", "UPDATE_TIME", "VALIDFLAG" }, false, new string[] { "CHK", "ITEM_NAME", "STANDARDS_CODE", "GROUP_LEVEL", "JUDGE_LEVEL_CODE", "ITEM_ATTR", "JUDGE_TYPE_CODE", "CHECK_CYCLE", "GET_SAMPLE_STD_NO", "GET_SAMPLE_STD_RATE", "BATCH_COUNT", "GET_SAMPLE_STD_RATE_UNIT", "GET_SAMPLE_STD_DESC", "REMARK" });

            string[] arrColumnsDetail = new string[] { "CHK", "MIC", "MAT_CODE", "MAT_NAME", "ADD_CONDITION", "COMPLEX_TYPE", "MAT_FORMULA", "STDMIN_SIGN", "STDMIN", "STDMAX_SIGN", "STDMAX", "JUDGE_TYPE_CODE", "JUDGE_TYPE", "CHECK_CYCLE", "CHECK_CYCLE_NUM", "CHECK_CYCLE_UNIT", "CHECK_CONDITION", "REMARK", "STD_TYPE", "VALIDFLAG", "MAT_UNIT" };
            string[] arrCaptionDetail = new string[] { "选择", "MIC", "检验项目", "检验项目", "条件", "是否复合检验项", "公式", "下限符号", "下限", "上限符号", "上限", "验收方式", "验收方式", "检验/验证周期", "周期数量", "周期单位", "试验要求", "备注", "类型", "是否有效", "单位" };
            PublicMat.InitColumns(arrColumnsDetail, arrCaptionDetail, dataTable4, ultraGrid4, new string[] { "MIC", "MAT_NAME", "COMPLEX_TYPE", "MAT_FORMULA", "JUDGE_TYPE", "CHECK_CYCLE", "STD_TYPE", "VALIDFLAG" }, false, arrColumnsDetail);
        }

        //查询原材料取样标准
        public void QueryMatGetSampleStd()
        {
            try
            {
                ArrayList arrayList = new ArrayList();

                arrayList.Add("1");
                arrayList.Add("1");
                arrayList.Add("1");

                arrayList.Add("409203");
                arrayList.Add("409203");

                arrayList.Add("");
                arrayList.Add("");
                arrayList.Add("");


                DataTable dt = PublicServer.GetData("com.steering.lims.data.base.FrmBaseMatStdDetail.QueryMatStdManageBase",
                            new Object[] { arrayList }, ob);//FrmBaseMatStdManage

                ultraGET_SAMPLE_STD.DataSource = dt;
                ultraGET_SAMPLE_STD.ValueMember = "STANDARDS_NO";//存取NO
                ultraGET_SAMPLE_STD.DisplayMember = "STANDARDS_CODE";

                DataRow dr = dt.NewRow();
                dr[0] = "";
                dr[1] = "";
                dt.Rows.Add(dr);
            }
            catch (Exception ex)
            {
                MessageUtil.ShowError(ex.Message);
            }
        }

        private void BindComboxData()
        {
            QueryMatGetSampleStd();
            UltraITEM_NAME.QueryMatItemsName(this.ob);
            UltraSTANDARDS_CODE.QueryStd_Code(this.ob);
            //ultraPRODUCT_STD.QueryProduct_Std(this.ob);
            ultraGROUP_LEVEL.QueryGroup_Level(this.ob);
            //ultraJUDGE_LEVEL.QueryJudge_Level(this.ob);//等级
            UltraJUDGE_TYPE.QueryJudge_Type(this.ob);
            ultraMAT_NAME.QueryMatName(this.ob);

            //下拉框赋值

            ultraGrid2.DisplayLayout.Bands[0].Columns["ITEM_CODE"].EditorComponent = UltraITEM_NAME.Ult;
            //ultraGrid2.DisplayLayout.Bands[0].Columns["ITEM_CODE"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

            ultraGrid2.DisplayLayout.Bands[0].Columns["STANDARDS_CODE"].EditorComponent = ultraSTANDARDS_ID;
            ultraGrid2.DisplayLayout.Bands[0].Columns["STANDARDS_CODE"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

            //ultraGrid3.DisplayLayout.Bands[0].Columns["STANDARDS_ID"].EditorComponent = ultraSTANDARDS;//UltraSTANDARDS_CODE.Ult
            //ultraGrid3.DisplayLayout.Bands[0].Columns["STANDARDS_ID"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            ultraGrid3.DisplayLayout.Bands[0].Columns["STANDARDS_CODE"].EditorComponent = ultraSTANDARDS;//UltraSTANDARDS_CODE.Ult
            ultraGrid3.DisplayLayout.Bands[0].Columns["STANDARDS_CODE"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

            ultraGrid3.DisplayLayout.Bands[0].Columns["GROUP_LEVEL"].EditorComponent = ultraGroup;//组别
            ultraGrid3.DisplayLayout.Bands[0].Columns["GROUP_LEVEL"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

            //ultraGrid3.DisplayLayout.Bands[0].Columns["JUDGE_LEVEL_CODE"].EditorComponent = ultraJUDGE_LEVEL.Ult;//级别
            //ultraGrid3.DisplayLayout.Bands[0].Columns["JUDGE_LEVEL_CODE"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

            ultraGrid3.DisplayLayout.Bands[0].Columns["ITEM_ATTR"].EditorComponent = ultraITEM_ATTR;//属性
            ultraGrid3.DisplayLayout.Bands[0].Columns["ITEM_ATTR"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

            ultraGrid3.DisplayLayout.Bands[0].Columns["JUDGE_TYPE_CODE"].EditorComponent = UltraJUDGE_TYPE.Ult;//验收方式
            ultraGrid3.DisplayLayout.Bands[0].Columns["JUDGE_TYPE_CODE"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

            ultraGrid3.DisplayLayout.Bands[0].Columns["GET_SAMPLE_STD_NO"].EditorComponent = ultraGET_SAMPLE_STD;//取样标准
            ultraGrid3.DisplayLayout.Bands[0].Columns["GET_SAMPLE_STD_NO"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            ultraGrid3.DisplayLayout.Bands[0].Columns["GET_SAMPLE_STD_RATE_UNIT"].EditorComponent = ultraGET_SAMPLE_STD_RATE_UNIT;//取样频次单位

            ultraGrid4.DisplayLayout.Bands[0].Columns["MAT_CODE"].EditorComponent = ultraMAT_NAME.Ult;//检验项目
            //ultraGrid4.DisplayLayout.Bands[0].Columns["MAT_CODE"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

            ultraGrid4.DisplayLayout.Bands[0].Columns["STDMIN_SIGN"].EditorComponent = ultraComSignMin;//下限符号
            ultraGrid4.DisplayLayout.Bands[0].Columns["STDMIN_SIGN"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            ultraGrid4.DisplayLayout.Bands[0].Columns["STDMAX_SIGN"].EditorComponent = ultraComSignMax;//上限符号
            ultraGrid4.DisplayLayout.Bands[0].Columns["STDMAX_SIGN"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

            ultraGrid4.DisplayLayout.Bands[0].Columns["JUDGE_TYPE_CODE"].EditorComponent = UltJUDGE_TYPE;//验收方式
            ultraGrid4.DisplayLayout.Bands[0].Columns["JUDGE_TYPE_CODE"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            //ultraGrid4.DisplayLayout.Bands[0].Columns["STD_TYPE"].EditorComponent = ultraSTD_TYPE;//验收方式
            //ultraGrid4.DisplayLayout.Bands[0].Columns["STD_TYPE"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

            ultraGrid4.DisplayLayout.Bands[0].Columns["CHECK_CYCLE_UNIT"].EditorComponent = ultraCHECK_CYCLE_UNIT;//检验周期单位

            ultraGrid2.DisplayLayout.Bands[0].Columns["REMARK"].EditorComponent = txtREMARK_UltraGrid2;//备注编辑
            ultraGrid3.DisplayLayout.Bands[0].Columns["GET_SAMPLE_STD_DESC"].EditorComponent = txtREMARK_UltraGrid3;
            ultraGrid3.DisplayLayout.Bands[0].Columns["REMARK"].EditorComponent = txtREMARK_UltraGrid3;//备注编辑

            ultraGrid4.DisplayLayout.Bands[0].Columns["CHECK_CONDITION"].EditorComponent = txtREMARK_UltraGrid4;//试验要求
            ultraGrid4.DisplayLayout.Bands[0].Columns["REMARK"].EditorComponent = txtREMARK_UltraGrid4;
        }

        /// <summary>
        /// 重写基类方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    QueryMatCheckStd();
                    break;
                case "AddMatch":
                    AddMatStdMatchUp();//新增对应关系
                    break;
                case "DeleteMatch":
                    DeleteMatStdMatchUp();//删除对应关系
                    break;
                case "UpdateMatch":
                    UpdateMatStdMatchUp();//修改对应关系
                    break;
                case "Add":
                    AddMatStdDetail();
                    break;
                case "Update":
                    UpdateMatStdDetail();
                    break;
                case "Delete":
                    DeleteMatStdDetail();
                    break;
                case "Refresh":
                    RefreshComboxData();
                    break;
                case "CopyStd":
                    CopyMatStdDetail();
                    break;
                case "CopyDetail":
                    CopyMatStdDetail_();
                    break;
                case "Close":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
                    {
                        this.Close();
                    }
                    break;
            }
        }

        //刷新下拉框绑定值
        private void RefreshComboxData()
        {
            UltraITEM_NAME.QueryMatItemsName(this.ob);
            UltraSTANDARDS_CODE.QueryStd_Code(this.ob);
            //ultraPRODUCT_STD.QueryProduct_Std(this.ob);
            ultraGROUP_LEVEL.QueryGroup_Level(this.ob);
            ultraJUDGE_LEVEL.QueryJudge_Level(this.ob);
            //UltraJUDGE_TYPE.QueryJudge_Type(this.ob);
            ultraMAT_NAME.QueryMatName(this.ob);
        }

        private string IsValid(DataRow dr)
        {
            if (dr["ITEM_CODE"].ToString() == "")
            {
                return "物料不能为空!";
            }
            //else if (dr["STANDARDS_CODE"].ToString() == "")
            //{
            //    return "产品标准不能为空!";
            //}
            //else if (dr["JUDGE_LEVEL_CODE"].ToString() == "")
            //{
            //    return "标准级别不能为空!";
            //}
            else if (dr["JUDGE_TYPE_CODE"].ToString() == "")
            {
                return "验收方式不能为空!";
            }
            foreach (UltraGridRow ur in ultraGrid4.Rows)
            {
                if (ur.Cells["CHK"].Text.Trim().ToUpper() == "TRUE")
                {
                    if (ur.Cells["MAT_CODE"].Value == null || ur.Cells["MAT_CODE"].Value.ToString() == "")
                    {
                        return "请选择有效的检验项目！";
                    }
                    else if (dr["JUDGE_TYPE_CODE"].ToString() == "409003" && ur.Cells["JUDGE_TYPE_CODE"].Text.Trim() == "")
                    {
                        return "检验项" + ur.Cells["MAT_CODE"].Text.Trim() + "验收方式不能为空!";
                    }
                    else if (ur.Cells["ADD_CONDITION"].Text.Trim() == "")
                    {
                        if (dataTable4.Select("MAT_CODE = '" + ur.Cells["MAT_CODE"].Value.ToString() + "' AND STD_TYPE = '" + ur.Cells["STD_TYPE"].Text.Trim() + "'").Length > 1)
                        {
                            return ur.Cells["MAT_CODE"].Text.Trim() + "已存在！";
                        }
                    }
                    else if (ur.Cells["ADD_CONDITION"].Text.Trim() != "")
                    {
                        if (dataTable4.Select("MAT_CODE = '" + ur.Cells["MAT_CODE"].Value.ToString() + "' AND ADD_CONDITION = '" + ur.Cells["ADD_CONDITION"].Text.Trim() + "' AND STD_TYPE = '" + ur.Cells["STD_TYPE"].Text.Trim() + "'").Length > 1)
                        {
                            return ur.Cells["MAT_CODE"].Text.Trim() + "已存在！";
                        }
                    }
                }
            }

            return "";
        }

        //查询检验标准
        private void QueryMatCheckStd()
        {
            try
            {
                ArrayList arrayList = new ArrayList();

                arrayList.Add("1");
                arrayList.Add("1");
                arrayList.Add("1");
                if (UserInfo.ParentDepartment == "供应部")
                {
                    //供应部只维护临时协议标准
                    arrayList.Add("409205");//临时协议标准
                    arrayList.Add("409205");//临时协议标准
                }
                else if (UserInfo.GetDeptid() == "002001001004")
                {
                    arrayList.Add("409202");//厂内检验标准
                    arrayList.Add("409202");//厂内检验标准
                }
                else
                {
                    arrayList.Add("409202");//厂内检验标准
                    arrayList.Add("409205");//临时协议标准
                }
                arrayList.Add("");
                arrayList.Add("");
                arrayList.Add("");

                DataTable dt = PublicServer.GetData("com.steering.lims.data.base.FrmBaseMatStdDetail.QueryMatStdManageBase",
                            new Object[] { arrayList }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable1.Rows.Clear();
                    dataTable2.Rows.Clear();
                    dataTable3.Rows.Clear();
                    dataTable4.Rows.Clear();
                    MessageUtil.ShowTips("没有维护标准基础数据！");
                    return;
                }

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

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

        private void AddMatStdMatchUp()
        {
            try
            {
                if (ultraGrid1.ActiveRow == null || ultraGrid1.ActiveRow.Activated == false)
                {
                    MessageUtil.ShowTips("请点击选择一条检验标准！");
                    return;

                }
                ultraGrid2.Update();
                ultraGrid2.UpdateData();

                DataRow[] arrDr = dataTable2.Select("CHK = 'True' AND VALIDFLAG IS NULL");
                if (arrDr.Length == 0)
                {
                    MessageUtil.ShowTips("请至少勾选一条需要新增的对应关系！");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认新增？") == DialogResult.Yes)
                {
                    string strNo = ultraGrid1.ActiveRow.Cells["STANDARDS_NO"].Text.Trim();
                    ArrayList all = new ArrayList();

                    ArrayList allDetail = new ArrayList();
                    foreach (DataRow dr in arrDr)
                    {
                        if (dataTable2.Select("ITEM_CODE = '" + dr["ITEM_CODE"].ToString() + "'").Length > 1)
                        {
                            MessageUtil.ShowWarning(dr["ITEM_NAME"].ToString() + "此物料已存在！");
                            return;
                        }
                        allDetail = new ArrayList();
                        allDetail.Add(strNo);
                        allDetail.Add(dr["ITEM_CODE"].ToString());
                        allDetail.Add(dr["ITEM_NAME"].ToString());
                        allDetail.Add(dr["STANDARDS_ID"].ToString());
                        allDetail.Add(dr["STANDARDS_CODE"].ToString());
                        allDetail.Add(dr["REMARK"].ToString());//备注
                        allDetail.Add(UserInfo.GetUserName());
                        all.Add(allDetail);
                    }

                    PublicServer.SetData("com.steering.lims.data.base.FrmBaseMatStdDetail.AddMatStdMatchUp",
new Object[] { all }, this.ob);

                    QueryMatCheckStd();

                    PublicMat.ActiveOperateRow(ultraGrid1, "STANDARDS_NO", strNo);

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

        private void DeleteMatStdMatchUp()
        {
            try
            {
                if (ultraGrid1.ActiveRow == null || ultraGrid1.ActiveRow.Activated == false)
                {
                    MessageUtil.ShowTips("请点击选择一条检验标准！");
                    return;
                }

                if (ultraGrid2.ActiveRow == null || ultraGrid2.ActiveRow.Activated == false)
                {
                    MessageUtil.ShowTips("请点击选择一条对应关系！");
                    return;
                }

                ultraGrid2.Update();
                ultraGrid2.UpdateData();

                DataRow[] arrDr = dataTable2.Select("CHK = 'True' AND VALIDFLAG = '1'");
                if (arrDr == null || arrDr.Length != 1)
                {
                    MessageUtil.ShowTips("请勾选一条需要删除的对应关系！");
                    return;
                }

                string strITEM_CODE = ultraGrid2.ActiveRow.Cells["ITEM_CODE"].Value.ToString();

                if (arrDr[0]["ITEM_CODE"].ToString() != strITEM_CODE)
                {
                    MessageUtil.ShowTips("勾选点击的对应关系请保持一致！");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认删除对应关系？") == DialogResult.Yes)
                {
                    string strNo = ultraGrid1.ActiveRow.Cells["STANDARDS_NO"].Text.Trim();

                    ArrayList all = new ArrayList();

                    ArrayList allBase = new ArrayList();
                    ArrayList allBaseParams = new ArrayList();

                    ArrayList allStd = new ArrayList();
                    ArrayList allStdParams = new ArrayList();

                    allBaseParams.Add(strITEM_CODE);
                    allBase.Add(allBaseParams);

                    foreach (DataRow dr in dataTable3.Rows)
                    {
                        allStdParams = new ArrayList();
                        allStdParams.Add(dr["MIC"].ToString());
                        allStd.Add(allStdParams);
                    }

                    all.Add(allBase);
                    all.Add(allStd);

                    PublicServer.SetData("com.steering.lims.data.base.FrmBaseMatStdDetail.DeleteMatStdMatchUp",
new Object[] { all }, this.ob);

                    QueryMatCheckStd();

                    PublicMat.ActiveOperateRow(ultraGrid1, "STANDARDS_NO", strNo);

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

        private void UpdateMatStdMatchUp()
        {
            try
            {
                if (ultraGrid1.ActiveRow == null || ultraGrid1.ActiveRow.Activated == false)
                {
                    MessageUtil.ShowTips("请点击选择一条检验标准！");
                    return;

                }
                ultraGrid2.Update();
                ultraGrid2.UpdateData();

                DataRow[] arrDr = dataTable2.Select("CHK = 'True' AND VALIDFLAG = '1'");
                if (arrDr == null || arrDr.Length != 1)
                {
                    MessageUtil.ShowTips("请勾选一条需要修改的对应关系！");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认修改？") == DialogResult.Yes)
                {
                    string strNo = ultraGrid1.ActiveRow.Cells["STANDARDS_NO"].Text.Trim();
                    string strITEM_CODE = ultraGrid2.ActiveRow.Cells["ITEM_CODE"].Value.ToString();
                    ArrayList all = new ArrayList();

                    ArrayList allDetail = new ArrayList();
                    foreach (DataRow dr in arrDr)
                    {
                        allDetail = new ArrayList();
                        allDetail.Add(dr["STANDARDS_ID"].ToString());
                        allDetail.Add(dr["STANDARDS_CODE"].ToString());
                        allDetail.Add(dr["REMARK"].ToString());//备注
                        allDetail.Add(UserInfo.GetUserName());
                        allDetail.Add(dr["ITEM_CODE"].ToString());
                        all.Add(allDetail);
                    }

                    PublicServer.SetData("com.steering.lims.data.base.FrmBaseMatStdDetail.UpdateMatStdMatchUp",
new Object[] { all }, this.ob);

                    QueryMatCheckStd();

                    PublicMat.ActiveOperateRow(ultraGrid1, "STANDARDS_NO", strNo);

                    PublicMat.ActiveOperateRow(ultraGrid2, "ITEM_CODE", strITEM_CODE);

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

        private void AddMatStdDetail()
        {
            try
            {
                if (ultraGrid2.ActiveRow == null)
                {
                    MessageUtil.ShowWarning("请选择需要新增的数据！");
                    return;
                }
                if (ultraGrid2.ActiveRow.Cells["VALIDFLAG"].Text.Trim() != "1")
                {
                    MessageUtil.ShowWarning("请选择一条已经保存对应关系的物料！");
                    return;
                }
                ultraGrid3.Update();
                ultraGrid3.UpdateData();
                ultraGrid4.Update();
                ultraGrid4.UpdateData();
                DataRow[] arrDr = dataTable3.Select("CHK = 'True'");
                if (arrDr.Length == 0 || arrDr.Length > 1)
                {
                    MessageUtil.ShowTips("请勾选一条需要新增的标准！");
                    return;
                }
                string result = IsValid(arrDr[0]);
                if (result != "")
                {
                    MessageUtil.ShowWarning(result);
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认新增？") == DialogResult.Yes)
                {
                    string strStd_No = ultraGrid1.ActiveRow.Cells["STANDARDS_ID"].Text.Trim();

                    string strItem_Code = ultraGrid2.ActiveRow.Cells["ITEM_CODE"].Value.ToString();

                    string sql = "SELECT COUNT(1) FLAG FROM BASE_MAT_STD_BASEINFO WHERE ";
                    ArrayList all = new ArrayList();

                    ArrayList alBase = new ArrayList();
                    ArrayList alBasePara = new ArrayList();
                    foreach (UltraGridRow ur in ultraGrid3.Rows)
                    {
                        if (ur.Cells["CHK"].Text == "True")
                        {
                            alBasePara = new ArrayList();
                            alBasePara.Add(ur.Cells["ITEM_CODE"].Text.Trim() + ";" + ur.Cells["STANDARDS_CODE"].Text.Trim() + (ur.Cells["GROUP_LEVEL"].Text.Trim() == "" ? "" : ";" + ur.Cells["GROUP_LEVEL"].Text.Trim()) + ";" + ur.Cells["JUDGE_LEVEL"].Text.Trim());//MIC描述
                            //alBasePara.Add("");//MIC描述
                            //alBasePara.Add(ur.Cells["PRODUCT_STD_ID"].Value.ToString());
                            //alBasePara.Add(ur.Cells["PRODUCT_STD_ID"].Text.Trim());
                            alBasePara.Add(ur.Cells["ITEM_CODE"].Text.Trim());
                            alBasePara.Add(ur.Cells["ITEM_NAME"].Text.Trim());
                            alBasePara.Add(ur.Cells["GRADE"].Text.Trim());//牌号
                            //alBasePara.Add(ur.Cells["STANDARDS_ID"].Value.ToString());
                            //alBasePara.Add(ur.Cells["STANDARDS_ID"].Text.Trim());
                            alBasePara.Add(ur.Cells["STANDARDS_ID"].Text.Trim());
                            alBasePara.Add(ur.Cells["STANDARDS_CODE"].Text.Trim());
                            alBasePara.Add(ur.Cells["GROUP_LEVEL_CODE"].Text.Trim());
                            alBasePara.Add(ur.Cells["GROUP_LEVEL"].Text.Trim());
                            alBasePara.Add(ur.Cells["JUDGE_LEVEL_CODE"].Text.Trim());
                            alBasePara.Add(ur.Cells["JUDGE_LEVEL"].Text.Trim());
                            alBasePara.Add(ur.Cells["ITEM_ATTR_ID"].Text.Trim());
                            alBasePara.Add(ur.Cells["ITEM_ATTR"].Text.Trim());
                            alBasePara.Add(ur.Cells["JUDGE_TYPE_CODE"].Value.ToString());
                            alBasePara.Add(ur.Cells["JUDGE_TYPE_CODE"].Text.Trim());
                            alBasePara.Add(ur.Cells["CHECK_CYCLE"].Text.Trim());//检验/验证周期
                            alBasePara.Add(ur.Cells["GET_SAMPLE_STD_NO"].Value.ToString());
                            alBasePara.Add(ur.Cells["GET_SAMPLE_STD_NO"].Text.Trim());
                            alBasePara.Add(ur.Cells["GET_SAMPLE_STD_DESC"].Text.Trim());
                            alBasePara.Add(ur.Cells["GET_SAMPLE_STD_RATE"].Text.Trim());
                            alBasePara.Add(ur.Cells["BATCH_COUNT"].Text.Trim());
                            alBasePara.Add(ur.Cells["GET_SAMPLE_STD_RATE_UNIT"].Text.Trim());
                            alBasePara.Add(ur.Cells["REMARK"].Text.Trim());
                            alBasePara.Add(UserInfo.GetUserName());
                            alBase.Add(alBasePara);

                            //等级改为用名称去判断是否一样
                            sql += "ITEM_CODE = '" + ur.Cells["ITEM_CODE"].Value.ToString() + "' ";
                            sql += (ur.Cells["STANDARDS_CODE"].Text.Trim() == "" ? "AND STANDARDS_CODE IS NULL " : ("AND STANDARDS_CODE = '" + ur.Cells["STANDARDS_CODE"].Text.Trim() + "' "));//+ "AND STANDARDS_ID = '" + ur.Cells["STANDARDS_ID"].Value.ToString() + "' "
                            sql += (ur.Cells["GRADE"].Text.Trim() == "" ? "AND GRADE IS NULL " : ("AND GRADE = '" + ur.Cells["GRADE"].Text.Trim() + "' "));
                            sql += (ur.Cells["GROUP_LEVEL_CODE"].Text.Trim() == "" ? "AND GROUP_LEVEL_CODE IS NULL " : ("AND GROUP_LEVEL_CODE = '" + ur.Cells["GROUP_LEVEL_CODE"].Text.Trim() + "' "));
                            sql += (ur.Cells["ITEM_ATTR"].Text.Trim() == "" ? "AND ITEM_ATTR IS NULL " : ("AND ITEM_ATTR = '" + ur.Cells["ITEM_ATTR"].Text.Trim() + "' "));
                            sql += (ur.Cells["JUDGE_LEVEL_CODE"].Text.Trim() == "" ? "AND JUDGE_LEVEL_CODE IS NULL" : ("AND JUDGE_LEVEL_CODE = '" + ur.Cells["JUDGE_LEVEL_CODE"].Text.Trim() + "'"));
                            break;
                        }
                    }

                    ArrayList alDetail = new ArrayList();
                    ArrayList alDetailPara = new ArrayList();
                    foreach (UltraGridRow ur in ultraGrid4.Rows)
                    {
                        if (ur.Cells["CHK"].Text.Trim() == "True" && ur.Cells["MAT_CODE"].Value.ToString() != "" && ur.Cells["MAT_CODE"].Text.Trim() != "")
                        {
                            alDetailPara = new ArrayList();
                            alDetailPara.Add(ur.Cells["MAT_CODE"].Value.ToString());
                            alDetailPara.Add(ur.Cells["MAT_CODE"].Text.Trim());
                            alDetailPara.Add(ur.Cells["MAT_UNIT"].Text.Trim());//单位
                            alDetailPara.Add(ur.Cells["ADD_CONDITION"].Text.Trim());
                            alDetailPara.Add("0");
                            alDetailPara.Add("");
                            alDetailPara.Add(ur.Cells["STDMIN_SIGN"].Text.Trim());
                            alDetailPara.Add(ur.Cells["STDMIN"].Text.Trim());
                            alDetailPara.Add(ur.Cells["STDMAX_SIGN"].Text.Trim());//STDMAX
                            alDetailPara.Add(ur.Cells["STDMAX"].Text.Trim());
                            alDetailPara.Add(ur.Cells["CHECK_CYCLE"].Text.Trim());
                            alDetailPara.Add(ur.Cells["CHECK_CYCLE_NUM"].Text.Trim());
                            alDetailPara.Add(ur.Cells["CHECK_CYCLE_UNIT"].Text.Trim());
                            if (ultraGrid3.Rows[0].Cells["JUDGE_TYPE_CODE"].Value.ToString() == "409003")
                            {
                                alDetailPara.Add(ur.Cells["JUDGE_TYPE_CODE"].Value.ToString());
                                alDetailPara.Add(ur.Cells["JUDGE_TYPE_CODE"].Text.Trim());
                            }
                            else
                            {
                                alDetailPara.Add(ultraGrid3.Rows[0].Cells["JUDGE_TYPE_CODE"].Value.ToString());
                                alDetailPara.Add(ultraGrid3.Rows[0].Cells["JUDGE_TYPE_CODE"].Text.Trim());
                            }
                            alDetailPara.Add(ur.Cells["CHECK_CONDITION"].Text.Trim());
                            alDetailPara.Add(ur.Cells["REMARK"].Text.Trim());
                            alDetailPara.Add("1");//ur.Cells["STD_TYPE"].Value.ToString()
                            alDetail.Add(alDetailPara);
                        }
                    }
                    all.Add(alBase);
                    all.Add(alDetail);

                    PublicServer.SetData("com.steering.lims.data.base.FrmBaseMatStdDetail.AddStdDetail",
        new Object[] { sql, all }, this.ob);

                    QueryMatCheckStd();

                    PublicMat.ActiveOperateRow(ultraGrid1, "STANDARDS_ID", strStd_No);
                    PublicMat.ActiveOperateRow(ultraGrid2, "ITEM_CODE", strItem_Code);
                    //PublicMat.ActiveOperateRow(ultraGrid3, "MIC", strMic);

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

        private void UpdateMatStdDetail()
        {
            try
            {
                if (ultraGrid2.ActiveRow == null)
                {
                    MessageUtil.ShowWarning("请选择需要修改的数据！");
                    return;
                }
                ultraGrid3.Update();
                ultraGrid3.UpdateData();
                ultraGrid4.Update();
                ultraGrid4.UpdateData();

                DataRow[] arrDr = dataTable3.Select("CHK = 'True' AND VALIDFLAG = '1'");
                if (arrDr.Length == 0 || arrDr.Length > 1)
                {
                    MessageUtil.ShowTips("请勾选一条需要修改的标准！");
                    return;
                }

                string result = IsValid(arrDr[0]);
                if (result != "")
                {
                    MessageUtil.ShowWarning(result);
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认修改？") == DialogResult.Yes)
                {

                    string strStd_No = ultraGrid1.ActiveRow.Cells["STANDARDS_ID"].Text.Trim();

                    string strItem_Code = ultraGrid2.ActiveRow.Cells["ITEM_CODE"].Value.ToString();

                    string strMic = ultraGrid3.ActiveRow.Cells["MIC"].Text.Trim();
                    string sql = "SELECT COUNT(1) FLAG FROM BASE_MAT_STD_BASEINFO WHERE MIC != '" + strMic + "'";
                    ArrayList all = new ArrayList();

                    ArrayList alDelete = new ArrayList();
                    ArrayList alDeletePara = new ArrayList();
                    alDeletePara.Add(strMic);
                    alDelete.Add(alDeletePara);

                    ArrayList alBase = new ArrayList();
                    ArrayList alBasePara = new ArrayList();
                    foreach (UltraGridRow ur in ultraGrid3.Rows)
                    {
                        if (ur.Cells["CHK"].Text == "True")
                        {
                            alBasePara = new ArrayList();
                            alBasePara.Add(strMic);
                            alBasePara.Add(ur.Cells["ITEM_CODE"].Text.Trim() + ";" + ur.Cells["STANDARDS_CODE"].Text.Trim() + (ur.Cells["GROUP_LEVEL"].Text.Trim() == "" ? "" : ";" + ur.Cells["GROUP_LEVEL"].Text.Trim()) + ";" + ur.Cells["JUDGE_LEVEL"].Text.Trim());//MIC描述
                            //alBasePara.Add("");//MIC描述
                            //alBasePara.Add(ur.Cells["PRODUCT_STD_ID"].Value.ToString());
                            //alBasePara.Add(ur.Cells["PRODUCT_STD_ID"].Text.Trim());
                            alBasePara.Add(ur.Cells["ITEM_CODE"].Text.Trim());
                            alBasePara.Add(ur.Cells["ITEM_NAME"].Text.Trim());
                            alBasePara.Add(ur.Cells["GRADE"].Text.Trim());//牌号
                            //alBasePara.Add(ur.Cells["STANDARDS_ID"].Value.ToString());
                            //alBasePara.Add(ur.Cells["STANDARDS_ID"].Text.Trim());
                            alBasePara.Add(ur.Cells["STANDARDS_ID"].Text.Trim());
                            alBasePara.Add(ur.Cells["STANDARDS_CODE"].Text.Trim());
                            alBasePara.Add(ur.Cells["GROUP_LEVEL_CODE"].Text.Trim());
                            alBasePara.Add(ur.Cells["GROUP_LEVEL"].Text.Trim());
                            alBasePara.Add(ur.Cells["JUDGE_LEVEL_CODE"].Text.Trim());
                            alBasePara.Add(ur.Cells["JUDGE_LEVEL"].Text.Trim());
                            alBasePara.Add(ur.Cells["ITEM_ATTR_ID"].Text.Trim());
                            alBasePara.Add(ur.Cells["ITEM_ATTR"].Text.Trim());
                            alBasePara.Add(ur.Cells["JUDGE_TYPE_CODE"].Value.ToString());
                            alBasePara.Add(ur.Cells["JUDGE_TYPE_CODE"].Text.Trim());
                            alBasePara.Add(ur.Cells["CHECK_CYCLE"].Text.Trim());//检验/验证周期
                            alBasePara.Add(ur.Cells["GET_SAMPLE_STD_NO"].Value.ToString());
                            alBasePara.Add(ur.Cells["GET_SAMPLE_STD_NO"].Text.Trim());
                            alBasePara.Add(ur.Cells["GET_SAMPLE_STD_DESC"].Text.Trim());
                            alBasePara.Add(ur.Cells["GET_SAMPLE_STD_RATE"].Text.Trim());
                            alBasePara.Add(ur.Cells["BATCH_COUNT"].Text.Trim());
                            alBasePara.Add(ur.Cells["GET_SAMPLE_STD_RATE_UNIT"].Text.Trim());
                            alBasePara.Add(ur.Cells["REMARK"].Text.Trim());
                            alBasePara.Add(UserInfo.GetUserName());
                            alBase.Add(alBasePara);

                            //等级改为用名称去判断是否一样
                            sql += " AND ITEM_CODE = '" + ur.Cells["ITEM_CODE"].Value.ToString() + "' ";
                            sql += (ur.Cells["STANDARDS_CODE"].Text.Trim() == "" ? "AND STANDARDS_CODE IS NULL " : ("AND STANDARDS_CODE = '" + ur.Cells["STANDARDS_CODE"].Text.Trim() + "' "));//+ "AND STANDARDS_ID = '" + ur.Cells["STANDARDS_ID"].Value.ToString() + "' "
                            sql += (ur.Cells["GRADE"].Text.Trim() == "" ? "AND GRADE IS NULL " : ("AND GRADE = '" + ur.Cells["GRADE"].Text.Trim() + "' "));
                            sql += (ur.Cells["GROUP_LEVEL_CODE"].Text.Trim() == "" ? "AND GROUP_LEVEL_CODE IS NULL " : ("AND GROUP_LEVEL_CODE = '" + ur.Cells["GROUP_LEVEL_CODE"].Text.Trim() + "' "));
                            sql += (ur.Cells["ITEM_ATTR"].Text.Trim() == "" ? "AND ITEM_ATTR IS NULL " : ("AND ITEM_ATTR = '" + ur.Cells["ITEM_ATTR"].Text.Trim() + "' "));
                            sql += (ur.Cells["JUDGE_LEVEL_CODE"].Text.Trim() == "" ? "AND JUDGE_LEVEL_CODE IS NULL" : ("AND JUDGE_LEVEL_CODE = '" + ur.Cells["JUDGE_LEVEL_CODE"].Text.Trim() + "'"));

                            break;
                        }
                    }

                    ArrayList alDetail = new ArrayList();
                    ArrayList alDetailPara = new ArrayList();
                    foreach (UltraGridRow ur in ultraGrid4.Rows)
                    {
                        if (ur.Cells["CHK"].Text.Trim() == "True" && ur.Cells["MAT_CODE"].Text.Trim() != "")
                        {
                            alDetailPara = new ArrayList();
                            alDetailPara.Add(strMic);
                            alDetailPara.Add(ur.Cells["MAT_CODE"].Value.ToString());
                            alDetailPara.Add(ur.Cells["MAT_CODE"].Text.Trim());
                            alDetailPara.Add(ur.Cells["MAT_UNIT"].Text.Trim());//单位
                            alDetailPara.Add(ur.Cells["ADD_CONDITION"].Text.Trim());
                            alDetailPara.Add("0");
                            alDetailPara.Add("");
                            alDetailPara.Add(ur.Cells["STDMIN_SIGN"].Text.Trim());
                            alDetailPara.Add(ur.Cells["STDMIN"].Text.Trim());
                            alDetailPara.Add(ur.Cells["STDMAX_SIGN"].Text.Trim());//STDMAX
                            alDetailPara.Add(ur.Cells["STDMAX"].Text.Trim());
                            alDetailPara.Add(ur.Cells["CHECK_CYCLE"].Text.Trim());
                            alDetailPara.Add(ur.Cells["CHECK_CYCLE_NUM"].Text.Trim());
                            alDetailPara.Add(ur.Cells["CHECK_CYCLE_UNIT"].Text.Trim());
                            alDetailPara.Add(ur.Cells["JUDGE_TYPE_CODE"].Value.ToString());
                            alDetailPara.Add(ur.Cells["JUDGE_TYPE_CODE"].Text.Trim());
                            alDetailPara.Add(ur.Cells["CHECK_CONDITION"].Text.Trim());
                            alDetailPara.Add(ur.Cells["REMARK"].Text.Trim());
                            alDetailPara.Add("1");//默认1 ur.Cells["STD_TYPE"].Value.ToString()
                            alDetail.Add(alDetailPara);
                        }
                    }
                    all.Add(alDelete);
                    all.Add(alBase);
                    all.Add(alDetail);

                    PublicServer.SetData("com.steering.lims.data.base.FrmBaseMatStdDetail.UpdateStdDetail",
        new Object[] { sql, all }, this.ob);

                    QueryMatCheckStd();

                    PublicMat.ActiveOperateRow(ultraGrid1, "STANDARDS_ID", strStd_No);
                    PublicMat.ActiveOperateRow(ultraGrid2, "ITEM_CODE", strItem_Code);
                    PublicMat.ActiveOperateRow(ultraGrid3, "MIC", strMic);

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

        private void DeleteMatStdDetail()
        {
            try
            {
                if (ultraGrid2.ActiveRow == null)
                {
                    MessageUtil.ShowWarning("请选择需要删除的数据！");
                    return;
                }

                DataRow[] arrDr = dataTable3.Select("CHK = 'True' AND VALIDFLAG = '1'");
                if (arrDr.Length == 0 || arrDr.Length > 1)
                {
                    MessageUtil.ShowTips("请勾选一条需要删除的标准！");
                    return;
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否确认删除？") == DialogResult.Yes)
                {
                    string strStd_No = ultraGrid1.ActiveRow.Cells["STANDARDS_ID"].Text.Trim();

                    string strItem_Code = ultraGrid2.ActiveRow.Cells["ITEM_CODE"].Value.ToString();

                    ArrayList al = new ArrayList();
                    al.Add(ultraGrid3.ActiveRow.Cells["MIC"].Text.Trim());

                    PublicServer.SetData("com.steering.lims.data.base.FrmBaseMatStdDetail.DeleteStdDetail",
                            new Object[] { al }, this.ob);

                    QueryMatCheckStd();

                    PublicMat.ActiveOperateRow(ultraGrid1, "STANDARDS_ID", strStd_No);
                    PublicMat.ActiveOperateRow(ultraGrid2, "ITEM_CODE", strItem_Code);
                    //PublicMat.ActiveOperateRow(ultraGrid3, "MIC", strMic);

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

        private void CopyMatStdDetail()
        {
            try
            {
                if (ultraGrid2.ActiveRow == null)
                {
                    MessageUtil.ShowWarning("请点击一条需要复制的数据！");
                    return;
                }

                ultraGrid2.Update();
                ultraGrid2.UpdateData();
                ultraGrid3.Update();
                ultraGrid3.UpdateData();
                ultraGrid4.Update();
                ultraGrid4.UpdateData();
                DataRow[] arrDr = dataTable2.Select("CHK = 'True' AND VALIDFLAG = '1'");
                if (arrDr.Length == 0 || arrDr.Length > 1)
                {
                    MessageUtil.ShowTips("请勾选一条需要复制标准的对应关系！");
                    return;
                }

                if (arrDr[0]["STANDARDS_ID"].ToString().Split(',').Length > 1)
                {
                    MessageUtil.ShowWarning("多标准的物料不允许复制！");
                    return;
                }

                if (dataTable3.Select("CHK = 'True'").Length == 0 || dataTable3.Select("CHK = 'True'").Length > 1)
                {
                    MessageUtil.ShowTips("请勾选一条需要新增的标准！");
                    return;
                }

                string result = IsValid(dataTable3.Select("CHK = 'True' AND VALIDFLAG = '1'")[0]);
                if (result != "")
                {
                    MessageUtil.ShowWarning(result);
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认复制？") == DialogResult.Yes)
                {
                    string strStd_No = ultraGrid1.ActiveRow.Cells["STANDARDS_ID"].Text.Trim();

                    string strItem_Code = arrDr[0]["ITEM_CODE"].ToString();//

                    string sql = "SELECT COUNT(1) FLAG FROM BASE_MAT_STD_BASEINFO WHERE ";
                    ArrayList all = new ArrayList();

                    ArrayList alBase = new ArrayList();
                    ArrayList alBasePara = new ArrayList();
                    foreach (UltraGridRow ur in ultraGrid3.Rows)
                    {
                        if (ur.Cells["CHK"].Text == "True")
                        {
                            alBasePara = new ArrayList();
                            alBasePara.Add(arrDr[0]["ITEM_CODE"].ToString() + ";" + arrDr[0]["STANDARDS_CODE"].ToString() + (ur.Cells["GROUP_LEVEL"].Text.Trim() == "" ? "" : ";" + ur.Cells["GROUP_LEVEL"].Text.Trim()) + ";" + ur.Cells["JUDGE_LEVEL"].Text.Trim());//MIC描述
                            //alBasePara.Add("");//MIC描述
                            //alBasePara.Add(ur.Cells["PRODUCT_STD_ID"].Value.ToString());
                            //alBasePara.Add(ur.Cells["PRODUCT_STD_ID"].Text.Trim());
                            alBasePara.Add(arrDr[0]["ITEM_CODE"].ToString());
                            alBasePara.Add(arrDr[0]["ITEM_NAME"].ToString());
                            alBasePara.Add(ur.Cells["GRADE"].Text.Trim());//牌号
                            alBasePara.Add(arrDr[0]["STANDARDS_ID"].ToString());
                            alBasePara.Add(arrDr[0]["STANDARDS_CODE"].ToString());
                            alBasePara.Add(ur.Cells["GROUP_LEVEL_CODE"].Text.Trim());
                            alBasePara.Add(ur.Cells["GROUP_LEVEL"].Text.Trim());
                            alBasePara.Add(ur.Cells["JUDGE_LEVEL_CODE"].Text.Trim());
                            alBasePara.Add(ur.Cells["JUDGE_LEVEL"].Text.Trim());
                            alBasePara.Add(ur.Cells["ITEM_ATTR_ID"].Text.Trim());
                            alBasePara.Add(ur.Cells["ITEM_ATTR"].Text.Trim());
                            alBasePara.Add(ur.Cells["JUDGE_TYPE_CODE"].Value.ToString());
                            alBasePara.Add(ur.Cells["JUDGE_TYPE_CODE"].Text.Trim());
                            alBasePara.Add(ur.Cells["CHECK_CYCLE"].Text.Trim());//检验/验证周期
                            alBasePara.Add(ur.Cells["GET_SAMPLE_STD_NO"].Value.ToString());
                            alBasePara.Add(ur.Cells["GET_SAMPLE_STD_NO"].Text.Trim());
                            alBasePara.Add(ur.Cells["GET_SAMPLE_STD_DESC"].Text.Trim());
                            alBasePara.Add(ur.Cells["GET_SAMPLE_STD_RATE"].Text.Trim());
                            alBasePara.Add(ur.Cells["BATCH_COUNT"].Text.Trim());
                            alBasePara.Add(ur.Cells["GET_SAMPLE_STD_RATE_UNIT"].Text.Trim());
                            alBasePara.Add(ur.Cells["REMARK"].Text.Trim());
                            alBasePara.Add(UserInfo.GetUserName());
                            alBase.Add(alBasePara);

                            sql += "ITEM_CODE = '" + arrDr[0]["ITEM_CODE"].ToString() + "' ";
                            sql += (arrDr[0]["STANDARDS_CODE"].ToString() == "" ? "AND STANDARDS_CODE IS NULL " : ("AND STANDARDS_CODE = '" + arrDr[0]["STANDARDS_CODE"].ToString() + "' "));//+ "AND STANDARDS_ID = '" + ur.Cells["STANDARDS_ID"].Value.ToString() + "' "
                            sql += (ur.Cells["GRADE"].Text.Trim() == "" ? "AND GRADE IS NULL " : ("AND GRADE = '" + ur.Cells["GRADE"].Text.Trim() + "' "));
                            sql += (ur.Cells["GROUP_LEVEL_CODE"].Text.Trim() == "" ? "AND GROUP_LEVEL_CODE IS NULL " : ("AND GROUP_LEVEL_CODE = '" + ur.Cells["GROUP_LEVEL_CODE"].Text.Trim() + "' "));
                            sql += (ur.Cells["JUDGE_LEVEL_CODE"].Text.Trim() == "" ? "AND JUDGE_LEVEL_CODE IS NULL" : ("AND JUDGE_LEVEL_CODE = '" + ur.Cells["JUDGE_LEVEL_CODE"].Text.Trim() + "'"));
                            break;
                        }
                    }

                    ArrayList alDetail = new ArrayList();
                    ArrayList alDetailPara = new ArrayList();
                    foreach (UltraGridRow ur in ultraGrid4.Rows)
                    {
                        if (ur.Cells["CHK"].Text.Trim() == "True" && ur.Cells["MAT_CODE"].Value.ToString() != "" && ur.Cells["MAT_CODE"].Text.Trim() != "")
                        {
                            alDetailPara = new ArrayList();
                            alDetailPara.Add(ur.Cells["MAT_CODE"].Value.ToString());
                            alDetailPara.Add(ur.Cells["MAT_CODE"].Text.Trim());
                            alDetailPara.Add(ur.Cells["MAT_UNIT"].Text.Trim());//单位
                            alDetailPara.Add(ur.Cells["ADD_CONDITION"].Text.Trim());
                            alDetailPara.Add("0");
                            alDetailPara.Add("");
                            alDetailPara.Add(ur.Cells["STDMIN_SIGN"].Text.Trim());
                            alDetailPara.Add(ur.Cells["STDMIN"].Text.Trim());
                            alDetailPara.Add(ur.Cells["STDMAX_SIGN"].Text.Trim());//STDMAX
                            alDetailPara.Add(ur.Cells["STDMAX"].Text.Trim());
                            alDetailPara.Add(ur.Cells["CHECK_CYCLE"].Text.Trim());
                            alDetailPara.Add(ur.Cells["CHECK_CYCLE_NUM"].Text.Trim());
                            alDetailPara.Add(ur.Cells["CHECK_CYCLE_UNIT"].Text.Trim());
                            if (ultraGrid3.Rows[0].Cells["JUDGE_TYPE_CODE"].Value.ToString() == "409003")
                            {
                                alDetailPara.Add(ur.Cells["JUDGE_TYPE_CODE"].Value.ToString());
                                alDetailPara.Add(ur.Cells["JUDGE_TYPE_CODE"].Text.Trim());
                            }
                            else
                            {
                                alDetailPara.Add(ultraGrid3.Rows[0].Cells["JUDGE_TYPE_CODE"].Value.ToString());
                                alDetailPara.Add(ultraGrid3.Rows[0].Cells["JUDGE_TYPE_CODE"].Text.Trim());
                            }
                            alDetailPara.Add(ur.Cells["CHECK_CONDITION"].Text.Trim());
                            alDetailPara.Add(ur.Cells["REMARK"].Text.Trim());
                            alDetailPara.Add("1");//ur.Cells["STD_TYPE"].Value.ToString()
                            alDetail.Add(alDetailPara);
                        }
                    }
                    all.Add(alBase);
                    all.Add(alDetail);

                    PublicServer.SetData("com.steering.lims.data.base.FrmBaseMatStdDetail.AddStdDetail",
        new Object[] { sql, all }, this.ob);

                    QueryMatCheckStd();

                    PublicMat.ActiveOperateRow(ultraGrid1, "STANDARDS_ID", strStd_No);
                    PublicMat.ActiveOperateRow(ultraGrid2, "ITEM_CODE", strItem_Code);
                    //PublicMat.ActiveOperateRow(ultraGrid3, "MIC", strMic);

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

        private void CopyMatStdDetail_()
        {
            try
            {
                if (ultraGrid3.ActiveRow == null || dataTable4.Rows.Count == 0)
                {
                    MessageUtil.ShowWarning("请点击一条需要复制的数据！");
                    return;
                }

                ultraGrid3.Update();
                ultraGrid3.UpdateData();
                ultraGrid4.Update();
                ultraGrid4.UpdateData();
                DataRow[] arrDr = dataTable3.Select("CHK = 'True' AND VALIDFLAG = '1'");
                if (arrDr.Length == 0 || arrDr.Length > 1)
                {
                    MessageUtil.ShowTips("请勾选一条需要复制的标准！");
                    return;
                }

                string result = IsValid(arrDr[0]);
                if (result != "")
                {
                    MessageUtil.ShowWarning(result);
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认复制？") == DialogResult.Yes)
                {
                    string strStd_No = ultraGrid1.ActiveRow.Cells["STANDARDS_ID"].Text.Trim();

                    string strItem_Code = ultraGrid2.ActiveRow.Cells["ITEM_CODE"].Value.ToString();

                    string strMic = arrDr[0]["MIC"].ToString();
                    string sql = "SELECT COUNT(1) FLAG FROM BASE_MAT_STD_BASEINFO WHERE MIC != '" + strMic + "'";
                    ArrayList all = new ArrayList();

                    ArrayList alDelete = new ArrayList();
                    ArrayList alDeletePara = new ArrayList();
                    alDeletePara.Add(strMic);
                    alDelete.Add(alDeletePara);

                    ArrayList alBase = new ArrayList();
                    ArrayList alBasePara = new ArrayList();
                    foreach (UltraGridRow ur in ultraGrid3.Rows)
                    {
                        if (ur.Cells["CHK"].Text == "True")
                        {
                            alBasePara = new ArrayList();
                            alBasePara.Add(strMic);
                            alBasePara.Add(ur.Cells["ITEM_CODE"].Text.Trim() + ";" + ur.Cells["STANDARDS_CODE"].Text.Trim() + (ur.Cells["GROUP_LEVEL"].Text.Trim() == "" ? "" : ";" + ur.Cells["GROUP_LEVEL"].Text.Trim()) + ";" + ur.Cells["JUDGE_LEVEL"].Text.Trim());//MIC描述
                            //alBasePara.Add("");//MIC描述
                            //alBasePara.Add(ur.Cells["PRODUCT_STD_ID"].Value.ToString());
                            //alBasePara.Add(ur.Cells["PRODUCT_STD_ID"].Text.Trim());
                            alBasePara.Add(ur.Cells["ITEM_CODE"].Text.Trim());
                            alBasePara.Add(ur.Cells["ITEM_NAME"].Text.Trim());
                            alBasePara.Add(ur.Cells["GRADE"].Text.Trim());//牌号
                            //alBasePara.Add(ur.Cells["STANDARDS_ID"].Value.ToString());
                            //alBasePara.Add(ur.Cells["STANDARDS_ID"].Text.Trim());
                            alBasePara.Add(ur.Cells["STANDARDS_ID"].Text.Trim());
                            alBasePara.Add(ur.Cells["STANDARDS_CODE"].Text.Trim());
                            alBasePara.Add(ur.Cells["GROUP_LEVEL_CODE"].Text.Trim());
                            alBasePara.Add(ur.Cells["GROUP_LEVEL"].Text.Trim());
                            alBasePara.Add(ur.Cells["JUDGE_LEVEL_CODE"].Text.Trim());
                            alBasePara.Add(ur.Cells["JUDGE_LEVEL"].Text.Trim());
                            alBasePara.Add(ur.Cells["ITEM_ATTR_ID"].Text.Trim());
                            alBasePara.Add(ur.Cells["ITEM_ATTR"].Text.Trim());
                            alBasePara.Add(ur.Cells["JUDGE_TYPE_CODE"].Value.ToString());
                            alBasePara.Add(ur.Cells["JUDGE_TYPE_CODE"].Text.Trim());
                            alBasePara.Add(ur.Cells["CHECK_CYCLE"].Text.Trim());//检验/验证周期
                            alBasePara.Add(ur.Cells["GET_SAMPLE_STD_NO"].Value.ToString());
                            alBasePara.Add(ur.Cells["GET_SAMPLE_STD_NO"].Text.Trim());
                            alBasePara.Add(ur.Cells["GET_SAMPLE_STD_DESC"].Text.Trim());
                            alBasePara.Add(ur.Cells["GET_SAMPLE_STD_RATE"].Text.Trim());
                            alBasePara.Add(ur.Cells["BATCH_COUNT"].Text.Trim());
                            alBasePara.Add(ur.Cells["GET_SAMPLE_STD_RATE_UNIT"].Text.Trim());
                            alBasePara.Add(ur.Cells["REMARK"].Text.Trim());
                            alBasePara.Add(UserInfo.GetUserName());
                            alBase.Add(alBasePara);

                            //等级改为用名称去判断是否一样
                            sql += " AND ITEM_CODE = '" + ur.Cells["ITEM_CODE"].Value.ToString() + "' ";
                            sql += (ur.Cells["STANDARDS_CODE"].Text.Trim() == "" ? "AND STANDARDS_CODE IS NULL " : ("AND STANDARDS_CODE = '" + ur.Cells["STANDARDS_CODE"].Text.Trim() + "' "));//+ "AND STANDARDS_ID = '" + ur.Cells["STANDARDS_ID"].Value.ToString() + "' "
                            sql += (ur.Cells["GRADE"].Text.Trim() == "" ? "AND GRADE IS NULL " : ("AND GRADE = '" + ur.Cells["GRADE"].Text.Trim() + "' "));
                            sql += (ur.Cells["GROUP_LEVEL_CODE"].Text.Trim() == "" ? "AND GROUP_LEVEL_CODE IS NULL " : ("AND GROUP_LEVEL_CODE = '" + ur.Cells["GROUP_LEVEL_CODE"].Text.Trim() + "' "));
                            sql += (ur.Cells["ITEM_ATTR"].Text.Trim() == "" ? "AND ITEM_ATTR IS NULL " : ("AND ITEM_ATTR = '" + ur.Cells["ITEM_ATTR"].Text.Trim() + "' "));
                            sql += (ur.Cells["JUDGE_LEVEL_CODE"].Text.Trim() == "" ? "AND JUDGE_LEVEL_CODE IS NULL" : ("AND JUDGE_LEVEL_CODE = '" + ur.Cells["JUDGE_LEVEL_CODE"].Text.Trim() + "'"));

                            break;
                        }
                    }

                    ArrayList alDetail = new ArrayList();
                    ArrayList alDetailPara = new ArrayList();
                    foreach (UltraGridRow ur in ultraGrid4.Rows)
                    {
                        if (ur.Cells["CHK"].Text.Trim() == "True" && ur.Cells["MAT_CODE"].Text.Trim() != "")
                        {
                            alDetailPara = new ArrayList();
                            alDetailPara.Add(strMic);
                            alDetailPara.Add(ur.Cells["MAT_CODE"].Value.ToString());
                            alDetailPara.Add(ur.Cells["MAT_CODE"].Text.Trim());
                            alDetailPara.Add(ur.Cells["MAT_UNIT"].Text.Trim());//单位
                            alDetailPara.Add(ur.Cells["ADD_CONDITION"].Text.Trim());
                            alDetailPara.Add("0");
                            alDetailPara.Add("");
                            alDetailPara.Add(ur.Cells["STDMIN_SIGN"].Text.Trim());
                            alDetailPara.Add(ur.Cells["STDMIN"].Text.Trim());
                            alDetailPara.Add(ur.Cells["STDMAX_SIGN"].Text.Trim());//STDMAX
                            alDetailPara.Add(ur.Cells["STDMAX"].Text.Trim());
                            alDetailPara.Add(ur.Cells["CHECK_CYCLE"].Text.Trim());
                            alDetailPara.Add(ur.Cells["CHECK_CYCLE_NUM"].Text.Trim());
                            alDetailPara.Add(ur.Cells["CHECK_CYCLE_UNIT"].Text.Trim());
                            alDetailPara.Add(ur.Cells["JUDGE_TYPE_CODE"].Value.ToString());
                            alDetailPara.Add(ur.Cells["JUDGE_TYPE_CODE"].Text.Trim());
                            alDetailPara.Add(ur.Cells["CHECK_CONDITION"].Text.Trim());
                            alDetailPara.Add(ur.Cells["REMARK"].Text.Trim());
                            alDetailPara.Add("1");//默认1 ur.Cells["STD_TYPE"].Value.ToString()
                            alDetail.Add(alDetailPara);
                        }
                    }
                    all.Add(alDelete);
                    all.Add(alBase);
                    all.Add(alDetail);

                    PublicServer.SetData("com.steering.lims.data.base.FrmBaseMatStdDetail.UpdateStdDetail",
        new Object[] { sql, all }, this.ob);

                    QueryMatCheckStd();

                    PublicMat.ActiveOperateRow(ultraGrid1, "STANDARDS_ID", strStd_No);
                    PublicMat.ActiveOperateRow(ultraGrid2, "ITEM_CODE", strItem_Code);
                    PublicMat.ActiveOperateRow(ultraGrid3, "MIC", strMic);

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

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            QueryMatStdMatchUp();
        }

        //查询检验标准对应关系
        private void QueryMatStdMatchUp()
        {
            try
            {
                ArrayList arrayList = new ArrayList();
                arrayList.Add(ultraGrid1.ActiveRow.Cells["STANDARDS_NO"].Text.Trim());
                DataTable dt = PublicServer.GetData("com.steering.lims.data.base.FrmBaseMatStdDetail.QueryMatStdMatchUp",
new Object[] { arrayList }, ob);

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

                GridHelper.CopyDataToDatatable(dt, dataTable2, true);//把dt复制给dataTable1

                //GridHelper.RefreshAndAutoSize(ultraGrid2);//刷新Grid 

                PublicMat.RefreshAndAutoSizeColumns(ultraGrid2, new string[] { "REMARK" }, false);

                ultraGrid2.ActiveRow = ultraGrid2.Rows[ultraGrid2.Rows.Count - 1];//0新增默认激活最后一行                
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
        {
            PublicMat.GridEdite(ultraGrid2.ActiveRow);
            Infragistics.Win.ValueList valueList = new Infragistics.Win.ValueList();
            string[] arrStrId = ultraGrid2.ActiveRow.Cells["STANDARDS_ID"].Text.Trim().Split(',');
            string[] arrStrCode = ultraGrid2.ActiveRow.Cells["STANDARDS_CODE"].Text.Trim().Split(',');
            for (int i = 0; i < arrStrId.Length; i++)
            {
                valueList.ValueListItems.Add(arrStrId[i], arrStrCode[i]);
            }
            ultraSTANDARDS.ValueList = valueList;

            QueryMatStdBaseInfo();
        }

        private void QueryMatStdBaseInfo()
        {
            try
            {
                string strItem_Code = ultraGrid2.ActiveRow.Cells["ITEM_CODE"].Value.ToString();
                if (strItem_Code == "")
                {
                    return;
                }
                ArrayList arrayList = new ArrayList();
                arrayList.Add(strItem_Code);
                arrayList.Add(strItem_Code);
                arrayList.Add(strItem_Code);
                DataTable dt = PublicServer.GetData("com.steering.lims.data.base.FrmBaseMatStdDetail.QueryMatStdBaseInfo",
    new Object[] { arrayList }, ob);

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

                GridHelper.CopyDataToDatatable(dt, dataTable3, true);//把dt复制给dataTable1

                //GridHelper.RefreshAndAutoSize(ultraGrid3);//刷新Grid 
                PublicMat.RefreshAndAutoSizeColumns(ultraGrid3, new string[] { "GROUP_LEVEL", "JUDGE_TYPE_CODE", "GET_SAMPLE_STD", "GET_SAMPLE_STD_DESC", "REMARK" }, false);

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

        private void ultraGrid3_AfterRowActivate(object sender, EventArgs e)
        {
            PublicMat.GridEdite(ultraGrid3.ActiveRow);
            QueryMatStdDetail();
        }

        private void QueryMatStdDetail()
        {
            try
            {
                if (ultraGrid3.ActiveRow.Cells["MIC"].Text.Trim() != "" && ultraGrid3.ActiveRow.Cells["VALIDFLAG"].Text.Trim() == "1")
                {
                    ArrayList arrayList = new ArrayList();
                    arrayList.Add(ultraGrid3.ActiveRow.Cells["MIC"].Text.Trim());

                    DataTable dt = PublicServer.GetData("com.steering.lims.data.base.FrmBaseMatStdDetail.QueryMatStdDetail",
        new Object[] { arrayList }, ob);

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

                    GridHelper.CopyDataToDatatable(dt, dataTable4, true);

                    //GridHelper.RefreshAndAutoSize(ultraGrid4);//刷新Grid

                    PublicMat.RefreshAndAutoSizeColumns(ultraGrid4, new string[] { "STDMIN_SIGN", "STDMAX_SIGN", "JUDGE_TYPE_CODE", "CHECK_CYCLE_NUM", "CHECK_CYCLE_UNIT", "STD_TYPE" }, true);
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void ultraGroup_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            WinMatGroupSelect addR = new WinMatGroupSelect(this.ob);
            addR.ShowDialog();
            if (addR.DialogResult != DialogResult.OK)
            {
                return;
            }

            //ultraGrid3.Rows[0].Cells["GROUP_LEVEL_CODE"].Value = addR.StrGroupCode;
            //ultraGrid3.Rows[0].Cells["GROUP_LEVEL"].Value = addR.StrGroupName;

            ultraGrid3.ActiveRow.Cells["GROUP_LEVEL_CODE"].Value = addR.StrGroupCode;
            ultraGrid3.ActiveRow.Cells["GROUP_LEVEL"].Value = addR.StrGroupName;
        }

        private void ultraGrid2_CellChange(object sender, CellEventArgs e)
        {
            ultraGrid2.Update();
            ultraGrid2.UpdateData();
            if (e.Cell.Column.Key == "ITEM_CODE")
            {
                if (e.Cell.Value.ToString() != "")
                {
                    //if (dataTable2.Select("ITEM_CODE = '" + e.Cell.Value.ToString() + "'").Length > 1)
                    //{
                    //    e.Cell.Value = "";
                    //    e.Cell.Row.Cells["ITEM_NAME"].Value = "";
                    //    MessageUtil.ShowWarning("此物料已存在！");
                    //    return;
                    //}
                    //else
                    //{
                    e.Cell.Row.Cells["ITEM_NAME"].Value = e.Cell.Text.Trim();
                    //}
                }
                else
                {
                    e.Cell.Row.Cells["STANDARDS_ID"].Value = "";
                    e.Cell.Row.Cells["STANDARDS_CODE"].Value = "";
                }
            }

            //ultraGrid2.Update();
            //ultraGrid2.UpdateData();
            //if (e.Cell.Column.Key == "ITEM_CODE")
            //{
            //    if (e.Cell.Value.ToString() != "")
            //    {
            //        if (dataTable2.Select("ITEM_CODE = '" + e.Cell.Value.ToString() + "'").Length > 1)
            //        {
            //            e.Cell.Value = "";
            //            e.Cell.Row.Cells["ITEM_NAME"].Value = "";
            //            MessageUtil.ShowWarning("此检验项已存在！");
            //            return;
            //        }

            //        try
            //        {
            //            e.Cell.Row.Cells["ITEM_NAME"].Value = e.Cell.Text.Trim();
            //            ArrayList arrayList = new ArrayList();
            //            arrayList.Add(e.Cell.Value.ToString());

            //            DataTable dt = PublicServer.GetData("com.steering.lims.data.base.FrmBaseMatStdDetail.QueryMatItemStd",
            //new Object[] { arrayList }, ob);

            //            if (dt == null || dt.Rows.Count == 0)
            //            {
            //                return;
            //            }
            //            string stdId = "";
            //            string stdCode = "";
            //            foreach (DataRow dr in dt.Rows)
            //            {
            //                stdId += "," + dr["STANDARDS_ID"].ToString();
            //                stdCode += "," + dr["STANDARDS_CODE"].ToString();
            //            }
            //            stdId = stdId.Remove(0, 1);
            //            stdCode = stdCode.Remove(0, 1);
            //            e.Cell.Row.Cells["STANDARDS_ID"].Value = stdId;
            //            e.Cell.Row.Cells["STANDARDS_CODE"].Value = stdCode;
            //        }
            //        catch (Exception ex)
            //        {
            //            MessageUtil.ShowWarning(ex.Message);
            //            return;
            //        }
            //    }
            //    else
            //    {
            //        e.Cell.Row.Cells["STANDARDS_ID"].Value = "";
            //        e.Cell.Row.Cells["STANDARDS_CODE"].Value = "";
            //    }
            //}
            PublicMat.GridEdite(ultraGrid2.ActiveRow);
        }

        private void ultraGrid3_CellChange(object sender, CellEventArgs e)
        {
            ultraGrid3.UpdateData();
            if (e.Cell.Column.Key == "CHK")
            {
                if (e.Cell.Text == "True")
                {
                    if (e.Cell.Row.Cells["VALIDFLAG"].Text.Trim() != "1")
                    {
                        if (ultraGrid2.ActiveRow == null)
                        {
                            e.Cell.Row.Cells["ITEM_CODE"].Value = "";
                            e.Cell.Row.Cells["ITEM_NAME"].Value = "";
                            e.Cell.Value = "False";
                        }
                        else
                        {
                            Infragistics.Win.ValueList valueList = new Infragistics.Win.ValueList();
                            string[] arrStrId = ultraGrid2.ActiveRow.Cells["STANDARDS_ID"].Text.Trim().Split(',');
                            string[] arrStrCode = ultraGrid2.ActiveRow.Cells["STANDARDS_CODE"].Text.Trim().Split(',');
                            for (int i = 0; i < arrStrId.Length; i++)
                            {
                                valueList.ValueListItems.Add(arrStrId[i], arrStrCode[i]);
                            }
                            ultraSTANDARDS.ValueList = valueList;

                            e.Cell.Row.Cells["ITEM_CODE"].Value = ultraGrid2.ActiveRow.Cells["ITEM_CODE"].Value.ToString() == "" ? ultraGrid2.ActiveRow.Cells["ITEM_CODE"].Text.Trim() : ultraGrid2.ActiveRow.Cells["ITEM_CODE"].Value.ToString();
                            e.Cell.Row.Cells["ITEM_NAME"].Value = ultraGrid2.ActiveRow.Cells["ITEM_NAME"].Text.Trim();

                            ultraSTANDARDS.SelectedIndex = 0;
                            e.Cell.Row.Cells["STANDARDS_ID"].Value = ultraSTANDARDS.SelectedItem.DataValue.ToString();
                            e.Cell.Row.Cells["STANDARDS_CODE"].Value = ultraSTANDARDS.SelectedItem.DisplayText;//DataValue.ToString()

                            UltraJUDGE_TYPE.Ult.SelectedIndex = 2;
                            e.Cell.Row.Cells["JUDGE_TYPE_CODE"].Value = UltraJUDGE_TYPE.Ult.SelectedItem.DataValue.ToString();
                        }
                    }
                }
            }
            PublicMat.GridEdite(ultraGrid3.ActiveRow);
        }

        private void ultraITEM_ATTR_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            if (ultraGrid3.ActiveRow == null)
            {
                return;
            }
            WinMatAttrSelect addR = new WinMatAttrSelect(this.ob);
            string strCode = ultraGrid3.ActiveRow.Cells["ITEM_CODE"].Text.Trim();
            if (strCode == "")
            {
                return;
            }
            addR.StrItem_Code = strCode;
            addR.ShowDialog();
            if (addR.DialogResult != DialogResult.OK)
            {
                return;
            }
            ultraGrid3.ActiveRow.Cells["JUDGE_LEVEL_CODE"].Value = addR.StrStdId;
            ultraGrid3.ActiveRow.Cells["JUDGE_LEVEL"].Value = addR.StrStdCode;
            ultraGrid3.ActiveRow.Cells["ITEM_ATTR_ID"].Value = addR.StrStdId;
            ultraGrid3.ActiveRow.Cells["ITEM_ATTR"].Value = addR.StrStdCode;

            //ultraGrid3.Rows[0].Cells["JUDGE_LEVEL_CODE"].Value = addR.StrStdId;
            //ultraGrid3.Rows[0].Cells["JUDGE_LEVEL"].Value = addR.StrStdCode;
            //ultraGrid3.Rows[0].Cells["ITEM_ATTR_ID"].Value = addR.StrStdId;
            //ultraGrid3.Rows[0].Cells["ITEM_ATTR"].Value = addR.StrStdCode;
        }

        private void ultraGrid4_CellChange(object sender, CellEventArgs e)
        {
            ultraGrid4.UpdateData();
            PublicMat.GridEdite(ultraGrid4.ActiveRow);
            if (e.Cell.Value.ToString() != "")
            {
                if (e.Cell.Column.Key == "CHK" && e.Cell.Value.ToString() == "True")
                {
                    UltJUDGE_TYPE.SelectedIndex = 0;
                    e.Cell.Row.Cells["JUDGE_TYPE_CODE"].Value = UltJUDGE_TYPE.SelectedItem.DataValue.ToString();

                    e.Cell.Row.Cells["CHECK_CYCLE_NUM"].Value = "1";

                    ultraSTD_TYPE.SelectedIndex = 1;
                    e.Cell.Row.Cells["STD_TYPE"].Value = ultraSTD_TYPE.SelectedItem.DataValue.ToString();
                }
                if (e.Cell.Column.Key == "MAT_CODE")
                {
                    //检验项+条件+标准类别不能相同
                    if (dataTable4.Select("MAT_CODE = '" + e.Cell.Value.ToString() + "' AND ADD_CONDITION = '" + e.Cell.Row.Cells["ADD_CONDITION"].Value.ToString() + "' AND STD_TYPE = '" + e.Cell.Row.Cells["STD_TYPE"].Value.ToString() + "'").Length > 1)
                    {
                        e.Cell.Value = "";
                        MessageUtil.ShowWarning("此类型检验项已存在！");
                        return;
                    }
                }
                else if (e.Cell.Column.Key == "STD_TYPE")
                {
                    //"MAT_CODE = '" + e.Cell.Row.Cells["MAT_CODE"].Value.ToString() + "' AND STD_TYPE = '" + e.Cell.Value.ToString() + "'"
                    if (dataTable4.Select("MAT_CODE = '" + e.Cell.Row.Cells["MAT_CODE"].Value.ToString() + "' AND ADD_CONDITION = '" + e.Cell.Row.Cells["ADD_CONDITION"].Value.ToString() + "' AND STD_TYPE = '" + e.Cell.Value.ToString() + "'").Length > 1)
                    {
                        e.Cell.Value = "";
                        MessageUtil.ShowWarning("此类型检验项已存在！");

                        return;
                    }
                }
            }

        }

        private void ultraGrid4_AfterRowActivate(object sender, EventArgs e)
        {
            PublicMat.GridEdite(ultraGrid4.ActiveRow);
        }

        private void ultraSTANDARDS_ID_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            WinMatStdSelect addR = new WinMatStdSelect(this.ob);
            addR.ShowDialog();
            if (addR.DialogResult != DialogResult.OK)
            {
                return;
            }
            ultraGrid2.ActiveRow.Cells["STANDARDS_ID"].Value = addR.StrStdId;
            ultraGrid2.ActiveRow.Cells["STANDARDS_CODE"].Value = addR.StrStdCode;
        }

        private void txtREMARK_UltraGrid2_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            if (ultraGrid2.ActiveCell != null)
            {
                PopupTextBox ptb = new PopupTextBox(ultraGrid2.ActiveCell.Text, 400);
                ptb.ShowDialog();
                if (ptb.DialogResult == DialogResult.OK)
                {
                    ultraGrid2.ActiveCell.Value = ptb.TextInfo;
                }
            }
        }

        private void txtREMARK_UltraGrid3_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            if (ultraGrid3.ActiveCell != null)
            {
                PopupTextBox ptb = new PopupTextBox(ultraGrid3.ActiveCell.Text, 400);
                ptb.ShowDialog();
                if (ptb.DialogResult == DialogResult.OK)
                {
                    ultraGrid3.ActiveCell.Value = ptb.TextInfo;
                }
            }
        }

        private void txtREMARK_UltraGrid4_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            if (ultraGrid4.ActiveCell != null)
            {
                PopupTextBox ptb = new PopupTextBox(ultraGrid4.ActiveCell.Text, 400);
                ptb.ShowDialog();
                if (ptb.DialogResult == DialogResult.OK)
                {
                    ultraGrid4.ActiveCell.Value = ptb.TextInfo;
                }
            }
        }
    }
}