MES_Client/TGMES/Core.StlMes.Client.Lims.Port/数据管理/轧管/AddPhyItems.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 Core.Mes.Client.Comm.Tool;
using Infragistics.Win.UltraWinEditors;
using Core.Mes.Client.Comm.Server;
using Infragistics.Win.UltraWinGrid;
using Infragistics.Win;
using Core.Mes.Client.Comm.Control;

namespace Core.StlMes.Client.Lims.Port
{
    public partial class AddPhyItems : FrmBase
    {
        private OpeBase _ob;

        public OpeBase Ob
        {
            get { return _ob; }
            set { _ob = value; }
        }

        private DataTable dtSampleReq;//人工选的取样要求

        public DataTable DtSampleReq
        {
            get { return dtSampleReq; }
            set { dtSampleReq = value; }
        }

        private DataTable dtPhyDetail;//人工选的检验项目明细

        public DataTable DtPhyDetail
        {
            get { return dtPhyDetail; }
            set { dtPhyDetail = value; }
        }

        private DataTable m_dtSelectPhySampleCode;//工艺里面的取样码

        public DataTable DtSelectPhySampleCode
        {
            get { return m_dtSelectPhySampleCode; }
            set { m_dtSelectPhySampleCode = value; }
        }

        private DataTable m_dtSelectPhyDetail;//工艺里面的检验明细

        public DataTable DtSelectPhyDetail
        {
            get { return m_dtSelectPhyDetail; }
            set { m_dtSelectPhyDetail = value; }
        }

        public AddPhyItems()
        {
            InitializeComponent();
        }

        public AddPhyItems(OpeBase ob)
        {
            InitializeComponent();
            this._ob = ob;
        }

        private DataTable m_dtPhyMax;//大项
        private DataTable m_dtPhySampleCode;//下拉框取样码
        private DataTable m_dtPhyMin;//下拉框小项

        private DataTable m_dtPhyR;//下拉框方向温度尺寸

        //private DataTable m_dtSampleStyle;//样片类型
        //private DataTable m_dtLength;//长度
        //private DataTable m_dtRate;//频率
        //private DataTable m_dtPosition;//取样位置

        private void AddPhyItems_Load(object sender, EventArgs e)
        {
            InitColumnsDataTable();
            InitCombo();
            QueryPhyRItems();
            QuerySelectPhyItems();//已经选择的项目赋值

            //GridHelper.RefreshAndAutoSize(ultraGrid1);
            //GridHelper.RefreshAndAutoSize(ultraGrid2);
        }

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

        private void InitColumnsDataTable()
        {
            //检验项目明细"DEPT_ID","所属部门",
            //string[] arrColumnsDetail = new string[] { "CHK", "PHY_CODE_MAX", "PHY_NAME_MAX", "PHY_CODE_MIN", "PHY_NAME_MIN", "PHY_CODE", "PHY_NAME", "ITEM_CODE_F", "ITEM_NAME_F", "ITEM_CODE_W", "ITEM_NAME_W", "ITEM_CODE_S", "ITEM_NAME_S" };
            //string[] arrCaptionDetail = new string[] { "选择", "检验项", "检验项", "取样码", "取样码描述", "检验基础项", "检验基础项", "试验方向代码", "试验方向", "试验温度代码", "试验温度", "试样尺寸代码", "试样尺寸" };
            //PublicPort.InitColumns(arrColumnsDetail, arrCaptionDetail, dataTable1);
            //PublicPort.setColumnShowOrHidden(ultraGrid1, new string[] { "PHY_NAME_MAX", "DEPT_ID", "PHY_NAME_MIN", "PHY_NAME", "ITEM_CODE_F", "ITEM_CODE_W", "ITEM_CODE_S" }, false);//不需要显示的行
            //PublicPort.setOtherColumnReadOnly(ultraGrid1, new string[] { "CHK", "PHY_CODE_MAX", "PHY_NAME_MAX", "DEPT_ID", "PHY_CODE_MIN", "PHY_NAME_MIN", "PHY_CODE", "PHY_NAME" });
            //PublicPort.setOtherColumnReadOnly(ultraGrid1, new string[] { "CHK" });

            //取样要求队列
            string[] arrColumnsSampleReq = new string[] { "CHK", "DATA_TYPE", "DATA_TYPE_DESC", "PHY_CODE_MAX", "PHY_NAME_MAX", "PHY_CODE_MIN", "PHY_NAME_MIN", "SAMPLE_STYLE", "DESC_SAMPLE_STYLE", "STD_CODE", "STD_NAME", "LENGTH", "DESC_LENGTH", "WIDTH", "RATE", "DESC_RATE", "BATCH_UNIT", "BATCH_CNT", "POSITION", "DESC_POSITION", "DESC_COUNT", "SAMPLE_COUNT" };
            string[] arrCaptionSampleReq = new string[] { "选择", "样品类型", "样品类型", "检验项", "检验项", "取样码", "取样码", "样片类型", "样片类型", "标准代码", "标准名称", "取样长度", "取样长度", "取样宽度", "取样频率", "取样频率", "分批单位", "分批数量", "取样位置", "取样位置", "取样数量", "样条数" };
            PublicPort.InitColumns(arrColumnsSampleReq, arrCaptionSampleReq, dataTable2);
            PublicPort.setColumnShowOrHidden(ultraGrid2, new string[] { "DATA_TYPE_DESC", "PHY_NAME_MAX", "PHY_NAME_MIN", "DESC_SAMPLE_STYLE", "STD_CODE", "STD_NAME", "DESC_LENGTH", "DESC_RATE", "DESC_POSITION" }, false);//不需要显示的行
            PublicPort.setOtherColumnReadOnly(ultraGrid2, new string[] { "SAMPLE_STYLE", "DESC_SAMPLE_STYLE", "STD_CODE", "STD_NAME", "LENGTH", "DESC_LENGTH", "WIDTH", "RATE", "DESC_RATE", "BATCH_UNIT", "BATCH_CNT", "POSITION", "DESC_POSITION", "DESC_COUNT", "SAMPLE_COUNT" });
        }

        private void InitCombo()
        {
            try
            {
                ultraGrid1.DisplayLayout.Bands[0].Columns["DATA_TYPE"].EditorComponent = ultDATA_TYPE;//样品类型
                ultraGrid1.DisplayLayout.Bands[0].Columns["DATA_TYPE"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                ultraGrid2.DisplayLayout.Bands[0].Columns["DATA_TYPE"].EditorComponent = ultDATA_TYPE;//样品类型
                ultraGrid2.DisplayLayout.Bands[0].Columns["DATA_TYPE"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

                ultraGrid1.DisplayLayout.Bands[0].Columns["JUDGE_BASIS"].EditorComponent = ultraComJudgeBasis;//判定依据
                ultraGrid1.DisplayLayout.Bands[0].Columns["JUDGE_BASIS"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                ultraGrid1.DisplayLayout.Bands[0].Columns["ADDCONDITION"].EditorComponent = ultraADDCONDITION;//条件项
                ultraGrid1.DisplayLayout.Bands[0].Columns["ADDCONDITION"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

                ultraGrid1.DisplayLayout.Bands[0].Columns["STDMIN_SIGN"].EditorComponent = ultraComSignMin;//下限标准范围默认
                ultraGrid1.DisplayLayout.Bands[0].Columns["STDMIN_SIGN"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                ultraGrid1.DisplayLayout.Bands[0].Columns["STDMIN_SIGN2"].EditorComponent = ultraComSignMin;//下限标准范围二
                ultraGrid1.DisplayLayout.Bands[0].Columns["STDMIN_SIGN2"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                ultraGrid1.DisplayLayout.Bands[0].Columns["SIZE_MIN_SIGN"].EditorComponent = ultraComSignMin;//下限限制规格一
                ultraGrid1.DisplayLayout.Bands[0].Columns["SIZE_MIN_SIGN"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                ultraGrid1.DisplayLayout.Bands[0].Columns["SIZE_MIN_SIGN2"].EditorComponent = ultraComSignMin;//下限限制规格二
                ultraGrid1.DisplayLayout.Bands[0].Columns["SIZE_MIN_SIGN2"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                ultraGrid1.DisplayLayout.Bands[0].Columns["ADDSTD_MIN_SIGN"].EditorComponent = ultraComSignMin;//下限附加标准范围
                ultraGrid1.DisplayLayout.Bands[0].Columns["ADDSTD_MIN_SIGN"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

                ultraGrid1.DisplayLayout.Bands[0].Columns["STDMAX_SIGN"].EditorComponent = ultraComSignMax;//上限标准范围默认
                ultraGrid1.DisplayLayout.Bands[0].Columns["STDMAX_SIGN"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                ultraGrid1.DisplayLayout.Bands[0].Columns["STDMAX_SIGN2"].EditorComponent = ultraComSignMax;//上限标准范围二
                ultraGrid1.DisplayLayout.Bands[0].Columns["STDMAX_SIGN2"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                ultraGrid1.DisplayLayout.Bands[0].Columns["SIZE_MAX_SIGN"].EditorComponent = ultraComSignMax;//上限限制规格一
                ultraGrid1.DisplayLayout.Bands[0].Columns["SIZE_MAX_SIGN"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                ultraGrid1.DisplayLayout.Bands[0].Columns["SIZE_MAX_SIGN2"].EditorComponent = ultraComSignMax;//上限限制规格二
                ultraGrid1.DisplayLayout.Bands[0].Columns["SIZE_MAX_SIGN2"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                ultraGrid1.DisplayLayout.Bands[0].Columns["ADDSTD_MAX_SIGN"].EditorComponent = ultraComSignMax;//上限附加标准范围
                ultraGrid1.DisplayLayout.Bands[0].Columns["ADDSTD_MAX_SIGN"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

                //附加标准项4070
                initJGDropDown(ultraADDSTDCON_CODE, "com.steering.mes.port.mil.FrmMilConfirmItems.GetBaseData", "4070", "BASENAME", "BASECODE");
                ultraGrid1.DisplayLayout.Bands[0].Columns["ADDSTDCON_CODE"].EditorComponent = ultraADDSTDCON_CODE;
                ultraGrid1.DisplayLayout.Bands[0].Columns["ADDSTDCON_CODE"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

                //取大小值4071
                initJGDropDown(ultraSTD_CHOOSE, "com.steering.mes.port.mil.FrmMilConfirmItems.GetBaseData", "4071", "BASENAME", "BASECODE");
                ultraGrid1.DisplayLayout.Bands[0].Columns["STD_CHOOSE"].EditorComponent = ultraSTD_CHOOSE;
                ultraGrid1.DisplayLayout.Bands[0].Columns["STD_CHOOSE"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

                //限制规格描述// 4003
                initJGDropDown(ultraSIZE_CODE, "com.steering.mes.port.mil.FrmMilConfirmItems.GetBaseData", "4003", "BASENAME", "BASECODE");
                ultraGrid1.DisplayLayout.Bands[0].Columns["SIZE_CODE"].EditorComponent = ultraSIZE_CODE;
                ultraGrid1.DisplayLayout.Bands[0].Columns["SIZE_CODE"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                ultraGrid1.DisplayLayout.Bands[0].Columns["SIZE_CODE2"].EditorComponent = ultraSIZE_CODE;
                ultraGrid1.DisplayLayout.Bands[0].Columns["SIZE_CODE2"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

                //接箍规格描述
                //initJGDropDown(ultraSPEC_JG, "com.steering.mes.port.mil.FrmMilConfirmItems.GetBaseData", "4003", "BASENAME", "BASECODE");
                //ultraGrid1.DisplayLayout.Bands[0].Columns["SPEC_JG"].EditorComponent = ultraSPEC_JG;
                //ultraGrid1.DisplayLayout.Bands[0].Columns["SPEC_JG"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

                //检验大项
                initJGDropDown(ultPHY_NAME_MAX, "com.steering.mes.port.mil.FrmMilConfirmItems.QueryPhyMaxItems", null, "PHY_NAME_MAX", "PHY_CODE_MAX");
                ultraGrid1.DisplayLayout.Bands[0].Columns["PHY_CODE_MAX"].EditorComponent = ultPHY_NAME_MAX;
                ultraGrid1.DisplayLayout.Bands[0].Columns["PHY_CODE_MAX"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                ultraGrid2.DisplayLayout.Bands[0].Columns["PHY_CODE_MAX"].EditorComponent = ultPHY_NAME_MAX;
                ultraGrid2.DisplayLayout.Bands[0].Columns["PHY_CODE_MAX"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

                //取样码
                initJGDropDown(ultPHY_NAME_MIN, "com.steering.mes.port.mil.FrmMilConfirmItems.QueryPhySampleCode", null, "PHY_NAME_MIN", "PHY_CODE_MIN");
                ultraGrid1.DisplayLayout.Bands[0].Columns["PHY_CODE_MIN"].EditorComponent = ultPHY_NAME_MIN;
                ultraGrid1.DisplayLayout.Bands[0].Columns["PHY_CODE_MIN"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                //initJGDropDown(ultPHY_NAME_MIN_, "com.steering.mes.port.mil.FrmMilConfirmItems.QueryPhySampleCode", "PHY_NAME_MIN", "PHY_CODE_MIN");
                ultraGrid2.DisplayLayout.Bands[0].Columns["PHY_CODE_MIN"].EditorComponent = ultPHY_NAME_MIN;
                ultraGrid2.DisplayLayout.Bands[0].Columns["PHY_CODE_MIN"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

                //检验基础项
                initJGDropDown(ultPHY_NAME, "com.steering.mes.port.mil.FrmMilConfirmItems.QueryPhyMinItems", null, "PHY_NAME", "PHY_CODE");
                ultraGrid1.DisplayLayout.Bands[0].Columns["PHY_CODE"].EditorComponent = ultPHY_NAME;
                ultraGrid1.DisplayLayout.Bands[0].Columns["PHY_CODE"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

                //长度4010
                initJGDropDown(ultDESC_LENGTH, "com.steering.mes.port.mil.FrmMilConfirmItems.GetBaseData", "4010", "BASENAME", "BASECODE");
                ultraGrid2.DisplayLayout.Bands[0].Columns["LENGTH"].EditorComponent = ultDESC_LENGTH;
                ultraGrid2.DisplayLayout.Bands[0].Columns["LENGTH"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDown;

                //频率4011
                initJGDropDown(ultDESC_RATE, "com.steering.mes.port.mil.FrmMilConfirmItems.GetBaseData", "4086", "BASENAME", "BASECODE");
                ultraGrid2.DisplayLayout.Bands[0].Columns["RATE"].EditorComponent = ultDESC_RATE;
                ultraGrid2.DisplayLayout.Bands[0].Columns["RATE"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

                //分批单位
                ultraGrid2.DisplayLayout.Bands[0].Columns["BATCH_UNIT"].EditorComponent = ultBATCH_UNIT;
                ultraGrid2.DisplayLayout.Bands[0].Columns["BATCH_UNIT"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

                //位置4012
                initJGDropDown(ultDESC_POSITION, "com.steering.mes.port.mil.FrmMilConfirmItems.GetBaseData", "4012", "BASENAME", "BASECODE");
                ultraGrid2.DisplayLayout.Bands[0].Columns["POSITION"].EditorComponent = ultDESC_POSITION;
                ultraGrid2.DisplayLayout.Bands[0].Columns["POSITION"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

                //样片类型
                initJGDropDown(ultDESC_SAMPLE_STYLE, "com.steering.mes.port.mil.FrmMilConfirmItems.GetBaseData", "4081", "BASENAME", "BASECODE");
                ultraGrid2.DisplayLayout.Bands[0].Columns["SAMPLE_STYLE"].EditorComponent = ultDESC_SAMPLE_STYLE;
                ultraGrid2.DisplayLayout.Bands[0].Columns["SAMPLE_STYLE"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        private void initJGDropDown(UltraComboEditor uce, string MethodId, string strId, string memberDis, string memberValue)
        {
            //初始化编辑区域下拉框
            DataTable dt = PublicServer.GetData(MethodId, strId == null ? null : new Object[] { strId }, this._ob);
            if (dt != null && dt.Rows.Count > 0)
            {
                if (uce == ultPHY_NAME_MAX)
                {
                    m_dtPhyMax = dt.Copy();
                }
                else if (uce == ultPHY_NAME_MIN)
                {
                    m_dtPhySampleCode = dt.Copy();
                    //ValueList vl = PublicPort.GeneralValuelist(ref dt, "PHY_NAME_MIN", "PHY_NAME_MIN");
                    //ultraGrid1.DisplayLayout.Bands[0].Columns["PHY_NAME_MIN"].ValueList = ultPHY_NAME_MIN;                    
                }
                else if (uce == ultPHY_NAME)
                {
                    m_dtPhyMin = dt.Copy();
                }
                else if (uce == ultDESC_SAMPLE_STYLE)
                {
                    //m_dtSampleStyle = dt.Copy();
                }
                else if (uce == ultDESC_LENGTH)
                {
                    //m_dtLength = dt.Copy();
                }
                else if (uce == ultDESC_RATE)
                {
                    //m_dtRate = dt.Copy();
                }
                else if (uce == ultDESC_POSITION)
                {
                    //m_dtPosition = dt.Copy();
                }
                DataRow newDr = dt.NewRow();
                newDr[0] = "";
                dt.Rows.Add(newDr);
                uce.DataSource = dt;
                uce.DisplayMember = memberDis;
                uce.ValueMember = memberValue;
            }
        }

        //查询理化项目方向、温度、尺寸信息
        private void QueryPhyRItems()
        {
            try
            {

                DataTable dt = PublicServer.GetData("com.steering.mes.port.mil.FrmMilConfirmItems.QueryPhyRItems_All",
                        new Object[] { }, this._ob);

                if (dt != null && dt.Rows.Count > 0)
                {
                    m_dtPhyR = dt.Copy();
                }
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
            }
        }

        //已经选择的项目赋值
        private void QuerySelectPhyItems()
        {
            try
            {
                if (dtPhyDetail != null && dtPhyDetail.Rows.Count > 0)
                {
                    GridHelper.CopyDataToDatatable(dtPhyDetail, dataTable1, true);//把dt复制给dataTable1
                }
                if (dtSampleReq != null && dtSampleReq.Rows.Count > 0)
                {
                    GridHelper.CopyDataToDatatable(dtSampleReq, dataTable2, true);//把dt复制给dataTable1
                }
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
            }
        }

        private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            if (e.Tool.Key == "btnOK")   //保存
            {
                //doSave();
                this.DialogResult = DialogResult.OK;
                ultraGrid1.UpdateData();
                ultraGrid2.UpdateData();

                foreach (UltraGridRow ur in ultraGrid1.Rows)
                {
                    ur.Cells["DATA_TYPE_DESC"].Value = ur.Cells["DATA_TYPE"].Text;//样品类型
                    ur.Cells["PHY_NAME_MAX"].Value = ur.Cells["PHY_CODE_MAX"].Text;
                    ur.Cells["PHY_NAME_MIN"].Value = ur.Cells["PHY_CODE_MIN"].Text;
                    ur.Cells["PHY_NAME"].Value = ur.Cells["PHY_CODE"].Text;
                }
                ultraGrid1.UpdateData();
                dtPhyDetail = dataTable1.Copy();

                foreach (UltraGridRow ur in ultraGrid2.Rows)
                {
                    ur.Cells["DATA_TYPE_DESC"].Value = ur.Cells["DATA_TYPE"].Text;//样品类型
                    ur.Cells["DESC_SAMPLE_STYLE"].Value = ur.Cells["SAMPLE_STYLE"].Text;//样片类型
                    ur.Cells["DESC_LENGTH"].Value = ur.Cells["LENGTH"].Text;//长度
                    ur.Cells["DESC_RATE"].Value = ur.Cells["RATE"].Text;
                    ur.Cells["BATCH_UNIT"].Value = ur.Cells["BATCH_UNIT"].Text;
                    ur.Cells["DESC_POSITION"].Value = ur.Cells["POSITION"].Text;
                }
                ultraGrid2.UpdateData();
                dtSampleReq = dataTable2.Copy();
            }
            else if (e.Tool.Key == "btnClose")   //刷新
            {
                if (MessageBox.Show("确认关闭本窗口？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
                    this.Close();
            }
        }

        private void ultraGrid1_CellChange(object sender, CellEventArgs e)
        {
            ultraGrid1.UpdateData();
            if (e.Cell.Column.Key == "CHK")
            {
                if (e.Cell.Row.Cells["CHK"].Value.ToString() == "True")
                {
                    for (int i = 0; i < e.Cell.Row.Cells.Count; i++)
                    {
                        e.Cell.Row.Cells[i].Activation = Activation.AllowEdit;
                    }
                }
                else
                {
                    for (int i = 0; i < e.Cell.Row.Cells.Count; i++)
                    {
                        if (e.Cell.Row.Cells[i].Column.Key == "CHK")
                        {
                            continue;
                        }
                        e.Cell.Row.Cells[i].Activation = Activation.ActivateOnly;
                    }
                }
            }
            else
            {
                if (e.Cell.Row.Cells["CHK"].Value.ToString() == "True")
                {
                    if (e.Cell.Column.Key == "PHY_CODE_MAX")
                    {
                        if (m_dtSelectPhyDetail != null)
                        {
                            foreach (DataRow dr in m_dtSelectPhyDetail.Rows)
                            {
                                if (e.Cell.Row.Cells["DATA_TYPE"].Value.ToString() == "0" && dr["PHY_CODE_MAX"].ToString() == e.Cell.Row.Cells["PHY_CODE_MAX"].Value.ToString())
                                {
                                    MessageUtil.ShowTips("工艺中已有此检验大项！");
                                    e.Cell.Row.Cells["PHY_CODE_MAX"].Value = "";
                                    return;
                                }
                            }
                        }
                        e.Cell.Row.Cells["PHY_CODE_MIN"].Value = "";//清空取样码
                        DataTable dtSampleCode = PublicPort.GetSelectDt(m_dtPhySampleCode, "PHY_CODE_MAX = '" + e.Cell.Value.ToString() + "'");

                        ValueList vl = PublicPort.GeneralValuelist(ref dtSampleCode, "PHY_CODE_MIN", "PHY_NAME_MIN");
                        vl.ValueListItems.Add("");
                        e.Cell.Row.Cells["PHY_CODE_MIN"].ValueList = vl;

                        e.Cell.Row.Cells["PHY_CODE"].Value = "";//清空小项
                        DataTable dtPhyMin = PublicPort.GetSelectDt(m_dtPhyMin, "PHY_CODE_MAX = '" + e.Cell.Value.ToString() + "'");

                        ValueList vlMin = PublicPort.GeneralValuelist(ref dtPhyMin, "PHY_CODE", "PHY_NAME");
                        e.Cell.Row.Cells["PHY_CODE"].ValueList = vlMin;

                        //e.Cell.Row.Cells["PHY_CODE_MAX"].Value = e.Cell.Row.Cells["PHY_NAME_MAX"].Value;
                        //e.Cell.Row.Cells["PHY_NAME_MAX"].Value = e.Cell.Row.Cells["PHY_NAME_MAX"].Text;//大项name赋值
                    }
                    else if (e.Cell.Row.Cells["PHY_CODE_MAX"].Value.ToString() != "" && e.Cell.Column.Key == "PHY_CODE_MIN")
                    {
                        //同一种样品类型同一个大项不允许存在两种不同的取样码
                        foreach (UltraGridRow ur in ultraGrid1.Rows)
                        {
                            if (ur != e.Cell.Row)
                            {
                                if (ur.Cells["DATA_TYPE"].Value.ToString() == e.Cell.Row.Cells["DATA_TYPE"].Value.ToString() && ur.Cells["PHY_CODE_MAX"].Value.ToString() == e.Cell.Row.Cells["PHY_CODE_MAX"].Value.ToString() && ur.Cells["PHY_CODE_MIN"].Value.ToString() != e.Cell.Row.Cells["PHY_CODE_MIN"].Value.ToString())
                                {
                                    MessageUtil.ShowTips("同一样品类型同一大项不允许存在不同的取样码！");
                                    e.Cell.Row.Cells["PHY_CODE_MIN"].Value = "";
                                    return;
                                }
                            }
                        }
                        foreach (UltraGridRow ur in ultraGrid2.Rows)
                        {
                            if (ur.Cells["DATA_TYPE"].Value.ToString() == e.Cell.Row.Cells["DATA_TYPE"].Value.ToString() && ur.Cells["PHY_CODE_MAX"].Value.ToString() == e.Cell.Row.Cells["PHY_CODE_MAX"].Value.ToString() && ur.Cells["PHY_CODE_MIN"].Value.ToString() == e.Cell.Row.Cells["PHY_CODE_MIN"].Value.ToString())
                            {
                                return;
                            }
                        }
                        DataRow newDr = dataTable2.NewRow();
                        newDr["CHK"] = "True";
                        newDr["DATA_TYPE"] = e.Cell.Row.Cells["DATA_TYPE"].Value;
                        newDr["PHY_CODE_MAX"] = e.Cell.Row.Cells["PHY_CODE_MAX"].Value;
                        newDr["PHY_NAME_MAX"] = e.Cell.Row.Cells["PHY_CODE_MAX"].Text;
                        newDr["PHY_CODE_MIN"] = e.Cell.Row.Cells["PHY_CODE_MIN"].Value;
                        newDr["PHY_NAME_MIN"] = e.Cell.Row.Cells["PHY_CODE_MIN"].Text;
                        dataTable2.Rows.Add(newDr);

                        //e.Cell.Row.Cells["PHY_CODE_MIN"].Value = e.Cell.Row.Cells["PHY_NAME_MIN"].Value; //取样码        
                        //e.Cell.Row.Cells["PHY_NAME_MIN"].Value = e.Cell.Row.Cells["PHY_NAME_MIN"].Text;
                    }
                    else if (e.Cell.Row.Cells["PHY_CODE_MAX"].Value.ToString() != "" && e.Cell.Column.Key == "PHY_CODE")
                    {
                        //查询到有方向温度尺寸才弹出来
                        DataTable dtPhyR = PublicPort.GetSelectDt(m_dtPhyR, "PHY_CODE_MAX = '" + e.Cell.Row.Cells["PHY_CODE_MAX"].Value.ToString() + "' AND PHY_CODE = '" + e.Cell.Value.ToString() + "'");
                        if (dtPhyR != null && dtPhyR.Rows.Count > 0)
                        {
                            AddPhyRItems addR = new AddPhyRItems(this._ob, e.Cell.Row.Cells["PHY_CODE_MAX"].Value.ToString(), e.Cell.Value.ToString());
                            addR.ShowDialog();
                            if (addR.DialogResult != DialogResult.OK)
                            {
                                return;
                            }
                            UltraGridRow ur = addR.UgRow;

                            e.Cell.Row.Cells["ITEM_CODE_F"].Value = ur.Cells["ITEM_CODE_F"].Text.Trim();
                            e.Cell.Row.Cells["ITEM_NAME_F"].Value = ur.Cells["ITEM_NAME_F"].Text.Trim();
                            e.Cell.Row.Cells["ITEM_CODE_W"].Value = ur.Cells["ITEM_CODE_W"].Text.Trim();
                            e.Cell.Row.Cells["ITEM_NAME_W"].Value = ur.Cells["ITEM_NAME_W"].Text.Trim();
                            e.Cell.Row.Cells["ITEM_CODE_S"].Value = ur.Cells["ITEM_CODE_C"].Text.Trim();
                            e.Cell.Row.Cells["ITEM_NAME_S"].Value = ur.Cells["ITEM_NAME_C"].Text.Trim();
                        }
                        //e.Cell.Row.Cells["PHY_CODE"].Value = e.Cell.Row.Cells["PHY_NAME"].Value;
                        //e.Cell.Row.Cells["PHY_NAME"].Value = e.Cell.Row.Cells["PHY_NAME"].Text;
                    }
                }
                else
                {
                    if (e.Cell.Column.DataType == typeof(bool))
                    {
                        e.Cell.Value = false;
                    }
                    else
                    {
                        e.Cell.Value = "";
                    }
                }
            }
        }

        private void ultraGrid2_CellChange(object sender, CellEventArgs e)
        {
            //ultraGrid2.UpdateData();
            //if (e.Cell.Row.Cells["CHK"].Value.ToString() == "True" && m_dtSelectPhySampleCode != null)
            //{
            //    if (e.Cell.Column.Key == "PHY_NAME_MAX")
            //    {
            //        foreach (DataRow dr in m_dtSelectPhySampleCode.Rows)
            //        {
            //            if (dr["PHY_CODE_MAX"].ToString() == e.Cell.Row.Cells["PHY_NAME_MAX"].Value.ToString())
            //            {
            //                MessageUtil.ShowTips("工艺取样码中已有此大类！");
            //                e.Cell.Row.Cells["PHY_NAME_MAX"].Value = "";
            //                return;
            //            }
            //        }

            //        DataTable dtSampleCode = PublicPort.GetSelectDt(m_dtPhySampleCode, "PHY_CODE_MAX = '" + e.Cell.Value.ToString() + "'");
            //        ValueList vl = PublicPort.GeneralValuelist(ref dtSampleCode, "PHY_CODE_MIN", "PHY_NAME_MIN");
            //        e.Cell.Row.Cells["PHY_NAME_MIN"].ValueList = vl;
            //    }

            //}
            //else
            //{
            //    if (e.Cell.Column.Key != "CHK")
            //    {
            //        e.Cell.Value = "";
            //    }
            //}
        }
    }

}