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

namespace Core.StlMes.Client.Lims.Port
{
    public partial class FrmBaseSelectItems : FrmBase
    {
        //private DataTable m_dtSelectPhyMax;//选择的大项

        //public DataTable DtSelectPhyMax
        //{
        //    get { return m_dtSelectPhyMax; }
        //    set { m_dtSelectPhyMax = value; }
        //}

        private DataTable m_dtSelectPhySampleCode;//选择的取样码

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

        private DataTable m_dtSelectPhyMin;//选择的小项

        public DataTable DtSelectPhyMin
        {
            get { return m_dtSelectPhyMin; }
            set { m_dtSelectPhyMin = value; }
        }

        private DataTable m_dtSelectPhyR;//选择的方向温度尺寸

        public DataTable DtSelectPhyR
        {
            get { return m_dtSelectPhyR; }
            set { m_dtSelectPhyR = value; }
        }

        private DataTable m_dtSelectSampleKey;//选择的试样组+方向温度尺寸

        public DataTable DtSelectSampleKey
        {
            get { return m_dtSelectSampleKey; }
            set { m_dtSelectSampleKey = value; }
        }

        private DataTable m_dtPhySampleCode;//试样组
        private DataTable m_dtPhyMin;//材质小类DataTable
        private DataTable m_dtPhyR;//材质方向温度尺寸DataTable

        public FrmBaseSelectItems()
        {
            InitializeComponent();
        }

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

        private void FrmBaseSelectItems_Load(object sender, EventArgs e)
        {
            Init();
            //QueryPhyMaxItems();
            QueryPhySampleCode();
            QueryPhyMinItems();
            QueryPhyRItems();
            QueryPhyItems();//查询检验项补充项

            ultraGrid2_1.DisplayLayout.Bands[0].Columns["ITEM_NAME_F"].EditorComponent = ultraF;
            ultraGrid2_1.DisplayLayout.Bands[0].Columns["ITEM_NAME_F"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            ultraGrid2_2.DisplayLayout.Bands[0].Columns["ITEM_NAME_F"].EditorComponent = ultraF;
            ultraGrid2_2.DisplayLayout.Bands[0].Columns["ITEM_NAME_F"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

            ultraGrid2_1.DisplayLayout.Bands[0].Columns["ITEM_NAME_W"].EditorComponent = ultraW;
            ultraGrid2_1.DisplayLayout.Bands[0].Columns["ITEM_NAME_W"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            ultraGrid2_2.DisplayLayout.Bands[0].Columns["ITEM_NAME_W"].EditorComponent = ultraW;
            ultraGrid2_2.DisplayLayout.Bands[0].Columns["ITEM_NAME_W"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

            ultraGrid2_1.DisplayLayout.Bands[0].Columns["ITEM_NAME_C"].EditorComponent = ultraC;
            ultraGrid2_1.DisplayLayout.Bands[0].Columns["ITEM_NAME_C"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            ultraGrid2_2.DisplayLayout.Bands[0].Columns["ITEM_NAME_C"].EditorComponent = ultraC;
            ultraGrid2_2.DisplayLayout.Bands[0].Columns["ITEM_NAME_C"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
        }

        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            //ultraGrid1_1.DisplayLayout.Override.RowFilterMode = RowFilterMode.SiblingRowsOnly;
            //ultraGrid1_1.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            ultraGrid1_1.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            ultraGrid1_2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            ultraGrid2_1.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            ultraGrid2_2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            ultraGrid3_1.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            ultraGrid3_2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
        }

        //初始化
        private void Init()
        {
            //小项和大项反了
            string[] arrColumns = new string[] { "CHK", "PHY_CODE_MIN", "PHY_NAME_MIN", "DEPT_ID", "PHY_CODE_MAX", "PHY_NAME_MAX", "PHY_CODE", "PHY_NAME", "PHY_UNIT", "ITEM_CODE_F", "ITEM_NAME_F", "ITEM_CODE_W", "ITEM_NAME_W", "ITEM_CODE_C", "ITEM_NAME_C", "SAMPLE_KEY", "SAMPLE_KEY_DESC" };
            string[] arrCaption = new string[] { "选择", "检验项代码", "检验项", "试验室", "试样组", "试样组", "检验基础项代码", "检验基础项", "单位", "试验方向代码", "试验方向", "试验温度代码", "试验温度", "试样尺寸代码", "试样尺寸", "试样代码", "试样描述" };
            //InitColumns(arrColumns, arrCaption, dataTable1_1, ultraGrid1_1, new string[] { "CHK", "PHY_NAME_MAX" }, true, new string[] { "CHK" });//ultraGrid1大项

            PublicPort.InitColumns(arrColumns, arrCaption, dataTable1_1, ultraGrid1_1, new string[] { "CHK", "PHY_NAME_MAX", "PHY_NAME_MIN" }, true, new string[] { "CHK" });//ultraGrid2试样组
            PublicPort.InitColumns(arrColumns, arrCaption, dataTable1_2, ultraGrid1_2, new string[] { "PHY_NAME_MAX", "PHY_NAME_MIN" }, true, null);//ultraGrid3试样组 "PHY_NAME_MAX",

            PublicPort.InitColumns(arrColumns, arrCaption, dataTable2_1, ultraGrid2_1, new string[] { "CHK", "ITEM_NAME_F", "ITEM_NAME_W", "ITEM_NAME_C" }, true, new string[] { "CHK" });//ultraGrid6检验项目方向温度尺寸
            PublicPort.InitColumns(arrColumns, arrCaption, dataTable2_2, ultraGrid2_2, new string[] { "PHY_NAME_MAX", "ITEM_NAME_F", "ITEM_NAME_W", "ITEM_NAME_C" }, true, null);//ultraGrid7检验项目小项方向温度尺寸 试样组加方向温度尺寸

            PublicPort.InitColumns(arrColumns, arrCaption, dataTable3_1, ultraGrid3_1, new string[] { "CHK", "PHY_NAME", "PHY_UNIT" }, true, new string[] { "CHK" });//ultraGrid3_1检验项目小项
            PublicPort.InitColumns(arrColumns, arrCaption, dataTable3_2, ultraGrid3_2, new string[] { "PHY_NAME_MAX", "PHY_NAME", "PHY_UNIT" }, true, null);//ultraGrid3_2检验项目小项
        }

        //查询理化项目大类信息
        //private void QueryPhyMaxItems()
        //{
        //    try
        //    {
        //        DataTable dt = ServerHelper.GetData("com.steering.lims.data.base.FrmBaseSelectItems.QueryPhyMaxItems",
        //                new Object[] { }, this.ob);

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

        //        GridHelper.CopyDataToDatatable(dt, dataTable1, true);
        //        if (m_dtSelectPhyMax != null && m_dtSelectPhyMax.Rows.Count > 0)
        //        {
        //            foreach (DataRow dr in dataTable1.Rows)//已经选择大项默认勾选
        //            {
        //                if (m_dtSelectPhyMax.Select("PHY_CODE_MAX = '" + dr["PHY_CODE_MAX"].ToString().Trim() + "'").Length > 0)
        //                {
        //                    dr["CHK"] = true;
        //                }
        //            }
        //        }
        //        //GridHelper.RefreshAndAutoSize(ultraGrid1);
        //    }
        //    catch
        //    {
        //        //MessageUtil.ShowError(ex.Message);
        //    }
        //}

        //查询理化项目试样组
        private void QueryPhySampleCode()
        {
            try
            {
                DataTable dt = ServerHelper.GetData("com.steering.lims.data.base.FrmBaseSelectItems.QueryPhySampleCode",
                        new Object[] { }, this.ob);

                if (dt.Rows.Count == 0)
                {
                    return;
                }

                GridHelper.CopyDataToDatatable(dt, dataTable1_1, true);

                if (m_dtSelectPhySampleCode != null && m_dtSelectPhySampleCode.Rows.Count > 0)
                {
                    foreach (DataRow dr in dataTable1_1.Rows)//已经选择大项默认勾选
                    {
                        if (m_dtSelectPhySampleCode.Select("PHY_CODE_MAX = '" + dr["PHY_CODE_MAX"].ToString().Trim() + "'").Length > 0)
                        {
                            dr["CHK"] = true;
                        }
                    }
                }

                m_dtPhySampleCode = dt.Copy();
                if (m_dtSelectPhySampleCode != null)
                {
                    GridHelper.CopyDataToDatatable(m_dtSelectPhySampleCode, dataTable1_2, true);//已经选择试样组默认勾选0810
                }

                GridHelper.RefreshAndAutoSize(ultraGrid1_1);
                GridHelper.RefreshAndAutoSize(ultraGrid1_2);
            }
            catch //(Exception ex)
            {
                //MessageUtil.ShowError(ex.Message);
            }
        }


        //查询理化项目小类信息
        private void QueryPhyMinItems()
        {
            try
            {
                //FrmBaseCheckMethod 界面也有此方法
                DataTable dt = ServerHelper.GetData("com.steering.lims.data.base.FrmBaseSelectItems.QueryPhyMinItems",
                        new Object[] { }, this.ob);

                if (dt.Rows.Count == 0)
                {
                    return;
                }

                m_dtPhyMin = dt.Copy();

                if (m_dtSelectPhyMin != null)
                {
                    GridHelper.CopyDataToDatatable(m_dtSelectPhyMin, dataTable3_2, true);//已经选择小项默认勾选0810
                }
            }
            catch //(Exception ex)
            {
                //MessageUtil.ShowError(ex.Message);
            }
        }

        //查询理化项目方向、温度、尺寸信息
        private void QueryPhyRItems()
        {
            try
            {
                //暂时用_Log
                m_dtPhyR = null;
                DataTable dt = ServerHelper.GetData("com.steering.lims.data.base.FrmBaseSelectItems.QueryPhyRItems",
                        new Object[] { }, this.ob);

                if (dt.Rows.Count == 0)
                {
                    return;
                }

                m_dtPhyR = dt.Copy();
                if (m_dtSelectPhyR != null)
                {
                    GridHelper.CopyDataToDatatable(m_dtSelectPhyR, dataTable2_2, true);//已经选择方向温度尺寸默认勾选0810
                }
                GridHelper.RefreshAndAutoSize(ultraGrid2_2);
            }
            catch //(Exception ex)
            {
                //MessageUtil.ShowError(ex.Message);
            }
        }

        //查询检验项补充项
        private void QueryPhyItems()
        {
            QueryPhyItems_sub("A", ultraF);
            QueryPhyItems_sub("B", ultraW);
            QueryPhyItems_sub("C", ultraC);
        }

        private void QueryPhyItems_sub(string itemStyle, UltraComboEditor cmb)
        {
            try
            {
                ArrayList list = new ArrayList();
                list.Add(itemStyle);
                DataTable dt = ServerHelper.GetData("com.steering.lims.data.base.FrmBaseSelectItems.QueryPhyItems",
                                        new object[] { list }, ob);
                cmb.DataSource = dt;
                cmb.DisplayMember = "ITEM_NAME";
                cmb.ValueMember = "ITEM_CODE";
                ClsBaseInfo.SetComboItemHeight(cmb);
            }
            catch //(Exception ex)
            {
                //MessageUtil.ShowError(ex.Message);
            }
        }

        //确定按钮事件
        private void btnConfirm_Click(object sender, EventArgs e)
        {
            if (GetSelectItems() == false)
            {
                MessageUtil.ShowWarning("有选择的理化项目大类没有选择检验项，请选择！");
            }
            else
            {
                this.DialogResult = DialogResult.OK;
                //点击确认 保存SAMPLE_KEY
                DataRow[] arrDr;
                m_dtSelectSampleKey = dataTable2_2.Clone();
                foreach (DataRow dr in dataTable1_2.Rows)
                {
                    arrDr = dataTable2_2.Select("PHY_CODE_MAX = '" + dr["PHY_CODE_MAX"].ToString() + "'");
                    if (arrDr != null && arrDr.Length > 0)
                    {
                        foreach (DataRow drs in arrDr)
                        {
                            m_dtSelectSampleKey.ImportRow(drs);
                        }
                    }
                    else
                    {
                        dr["SAMPLE_KEY"] = dr["PHY_CODE_MAX"].ToString();
                        dr["SAMPLE_KEY_DESC"] = dr["PHY_NAME_MAX"].ToString();
                        m_dtSelectSampleKey.ImportRow(dr);
                    }
                }
            }
        }

        private void btnCancel_Click(object sender, EventArgs e)
        {
            if (MessageUtil.ShowYesNoAndQuestion("确定退出页面吗？") == DialogResult.Yes)
            {
                this.Close();
            }
        }

        //获取选择的项目0810
        private bool GetSelectItems()
        {

            m_dtSelectPhySampleCode = dataTable1_2.Copy();
            m_dtSelectPhyMin = dataTable3_2.Copy();//筛选出符合条件的小项
            if (m_dtSelectPhySampleCode.Rows.Count > 0)//判断是否有选择了大项没有选择小项的情况
            {
                foreach (DataRow dr in m_dtSelectPhySampleCode.Rows)
                {
                    if (PublicPort.GetSelectDt(m_dtSelectPhyMin, "PHY_CODE_MAX = '" + dr["PHY_CODE_MAX"].ToString() + "'").Rows.Count == 0)
                    {
                        return false;
                    }
                }
            }

            m_dtSelectPhyR = dataTable2_2.Copy();//筛选出符合条件的方向温度尺寸

            return true;
        }

        private void ultraGrid1_1_AfterRowActivate(object sender, EventArgs e)
        {
            //20160520根据试样组联动
            if (ultraGrid1_1.ActiveRow.Cells["CHK"].Text.Trim() == "True")
            {
                string phyMaxItems = "PHY_CODE_MAX = '" + ultraGrid1_1.ActiveRow.Cells["PHY_CODE_MAX"].Text.Trim() + "' AND PHY_CODE_MIN = '" + ultraGrid1_1.ActiveRow.Cells["PHY_CODE_MIN"].Text.Trim() + "'";

                //本来已经勾选的项目需要勾选2015-07-30
                foreach (DataRow drR in m_dtPhyMin.Rows)
                {
                    drR["CHK"] = "False";
                    foreach (DataRow dr in dataTable3_2.Rows)
                    {
                        //drR["CHK"] = "False";
                        if (drR["PHY_CODE_MAX"].ToString() == dr["PHY_CODE_MAX"].ToString() && drR["PHY_CODE_MIN"].ToString() == dr["PHY_CODE_MIN"].ToString() && drR["PHY_CODE"].ToString() == dr["PHY_CODE"].ToString())
                        {
                            drR["CHK"] = "True";
                            break;
                        }
                    }
                }
                GridHelper.CopyDataToDatatable(PublicPort.GetSelectDt(m_dtPhyMin, phyMaxItems), dataTable3_1, true);//筛选出符合条件的小项
                GridHelper.RefreshAndAutoSize(ultraGrid3_1);

                //datatable6 根据试样组显示对应的方向温度尺寸
                //    //本来已经勾选的项目需要勾选2015-07-30
                foreach (DataRow drR in m_dtPhyR.Rows)
                {
                    drR["CHK"] = "False";
                    foreach (DataRow dr in dataTable2_2.Rows)
                    {
                        if (drR["PHY_CODE_MAX"].ToString() == dr["PHY_CODE_MAX"].ToString() && drR["ITEM_CODE_F"].ToString() == dr["ITEM_CODE_F"].ToString() && drR["ITEM_CODE_W"].ToString() == dr["ITEM_CODE_W"].ToString() && drR["ITEM_CODE_C"].ToString() == dr["ITEM_CODE_C"].ToString())
                        {
                            drR["CHK"] = "True";
                            break;
                        }
                    }
                }
                GridHelper.CopyDataToDatatable(PublicPort.GetSelectDt(m_dtPhyR, phyMaxItems), dataTable2_1, true);//筛选出符合条件的小项
                GridHelper.RefreshAndAutoSize(ultraGrid2_1);
            }
            else
            {
                dataTable3_1.Rows.Clear();
                dataTable2_1.Rows.Clear();
            }
        }

        private void ultraGrid1_1_CellChange(object sender, CellEventArgs e)
        {
            if (e.Cell.Column.Key == "CHK")
            {
                ultraGrid1_1.UpdateData();

                if (e.Cell.Text == "True")
                {
                    string phyMaxItems = "PHY_CODE_MAX = '" + e.Cell.Row.Cells["PHY_CODE_MAX"].Text.Trim() + "' AND PHY_CODE_MIN = '" + e.Cell.Row.Cells["PHY_CODE_MIN"].Text.Trim() + "'";

                    //勾选了记录已经勾选的项目
                    if (dataTable1_1.Select(phyMaxItems) != null && dataTable1_1.Select(phyMaxItems).Length > 0)
                    {
                        dataTable1_2.ImportRow(dataTable1_1.Select(phyMaxItems)[0]);
                    }
                    GridHelper.RefreshAndAutoSize(ultraGrid1_2);

                    //本来已经勾选的项目需要勾选2015-07-30
                    foreach (DataRow drR in m_dtPhyMin.Rows)
                    {
                        drR["CHK"] = "False";
                        foreach (DataRow dr in dataTable3_2.Rows)
                        {
                            if (drR["PHY_CODE_MAX"].ToString() == dr["PHY_CODE_MAX"].ToString() && drR["PHY_CODE_MIN"].ToString() == dr["PHY_CODE_MIN"].ToString() && drR["PHY_CODE"].ToString() == dr["PHY_CODE"].ToString())
                            {
                                drR["CHK"] = "True";
                                break;
                            }
                        }
                    }

                    //datatable根据试样组显示对应的方向温度尺寸
                    GridHelper.CopyDataToDatatable(PublicPort.GetSelectDt(m_dtPhyR, phyMaxItems), dataTable2_1, true);//筛选出符合条件的小项
                    GridHelper.RefreshAndAutoSize(ultraGrid2_1);

                    GridHelper.CopyDataToDatatable(PublicPort.GetSelectDt(m_dtPhyMin, phyMaxItems), dataTable3_1, true);//筛选出符合条件的小项
                    GridHelper.RefreshAndAutoSize(ultraGrid3_1);

                }
                else
                {
                    //dataTable2_1和dataTable3_1有此项目的需删除
                    dataTable2_1.Rows.Clear();
                    dataTable3_1.Rows.Clear();

                    if (dataTable1_2.Rows.Count > 0)
                    {
                        for (int i = 0; i < dataTable1_2.Rows.Count; i++)
                        {
                            if (e.Cell.Row.Cells["PHY_CODE_MAX"].Text.Trim() == dataTable1_2.Rows[i]["PHY_CODE_MAX"].ToString() && e.Cell.Row.Cells["PHY_CODE_MIN"].Text.Trim() == dataTable1_2.Rows[i]["PHY_CODE_MIN"].ToString())
                            {
                                dataTable1_2.Rows.RemoveAt(i);
                                i--;
                            }
                        }
                    }

                    if (dataTable2_2.Rows.Count > 0)
                    {
                        for (int i = 0; i < dataTable2_2.Rows.Count; i++)
                        {
                            if (e.Cell.Row.Cells["PHY_CODE_MAX"].Text.Trim() == dataTable2_2.Rows[i]["PHY_CODE_MAX"].ToString() && e.Cell.Row.Cells["PHY_CODE_MIN"].Text.Trim() == dataTable2_2.Rows[i]["PHY_CODE_MIN"].ToString())
                            {
                                dataTable2_2.Rows.RemoveAt(i);
                                i--;
                            }
                        }
                    }

                    if (dataTable3_2.Rows.Count > 0)
                    {
                        for (int i = 0; i < dataTable3_2.Rows.Count; i++)
                        {
                            if (e.Cell.Row.Cells["PHY_CODE_MAX"].Text.Trim() == dataTable3_2.Rows[i]["PHY_CODE_MAX"].ToString() && e.Cell.Row.Cells["PHY_CODE_MIN"].Text.Trim() == dataTable3_2.Rows[i]["PHY_CODE_MIN"].ToString())
                            {
                                dataTable3_2.Rows.RemoveAt(i);
                                i--;
                            }
                        }
                    }

                    GridHelper.RefreshAndAutoSize(ultraGrid1_2);
                    GridHelper.RefreshAndAutoSize(ultraGrid2_2);
                    GridHelper.RefreshAndAutoSize(ultraGrid3_2);
                }
            }
        }

        private void ultraGrid2_1_AfterRowActivate(object sender, EventArgs e)
        {

        }

        private void ultraGrid2_1_CellChange(object sender, CellEventArgs e)
        {
            if (e.Cell.Column.Key == "CHK")
            {
                ultraGrid2_1.UpdateData();
                if (e.Cell.Text == "True")
                {
                    DataRow dr = dataTable2_2.NewRow();
                    foreach (UltraGridColumn uc in ultraGrid2_1.DisplayLayout.Bands[0].Columns)
                    {
                        dr[uc.Key] = e.Cell.Row.Cells[uc.Key].Text.Trim();
                    }
                    //SAMPLE_KEY 
                    string strSample_key = e.Cell.Row.Cells["PHY_CODE_MAX"].Text.Trim() + "_" + e.Cell.Row.Cells["ITEM_CODE_F"].Text.Trim() + "_" + e.Cell.Row.Cells["ITEM_CODE_W"].Text.Trim() + "_" + e.Cell.Row.Cells["ITEM_CODE_C"].Text.Trim() + "_";
                    dr["SAMPLE_KEY"] = strSample_key.Substring(0, strSample_key.Length - 1);

                    string strSAMPLE_KEY_DESC = e.Cell.Row.Cells["PHY_NAME_MAX"].Text.Trim() + "_" + e.Cell.Row.Cells["ITEM_NAME_F"].Text.Trim() + "_" + e.Cell.Row.Cells["ITEM_NAME_W"].Text.Trim() + "_" + e.Cell.Row.Cells["ITEM_NAME_C"].Text.Trim() + "_";
                    dr["SAMPLE_KEY_DESC"] = strSAMPLE_KEY_DESC.Substring(0, strSAMPLE_KEY_DESC.Length - 1);
                    //if (e.Cell.Row.Cells["ITEM_CODE_F"].Text.Trim() != "" || e.Cell.Row.Cells["ITEM_CODE_W"].Text.Trim() != "" || e.Cell.Row.Cells["ITEM_CODE_C"].Text.Trim() != "")
                    //{
                    //    strSAMPLE_KEY_DESC += "(";
                    //    strSAMPLE_KEY_DESC += (e.Cell.Row.Cells["ITEM_NAME_F"].Text.Trim() + " " + e.Cell.Row.Cells["ITEM_NAME_W"].Text.Trim() + " " + e.Cell.Row.Cells["ITEM_NAME_C"].Text.Trim()).Trim() + ")";
                    //}
                    dataTable2_2.Rows.Add(dr);
                }
                else
                {
                    for (int i = 0; i < dataTable2_2.Rows.Count; i++)
                    {
                        if (e.Cell.Row.Cells["PHY_CODE_MAX"].Text.Trim() == dataTable2_2.Rows[i]["PHY_CODE_MAX"].ToString() && e.Cell.Row.Cells["ITEM_CODE_F"].Text.Trim() == dataTable2_2.Rows[i]["ITEM_CODE_F"].ToString().Trim() && e.Cell.Row.Cells["ITEM_CODE_W"].Text.Trim() == dataTable2_2.Rows[i]["ITEM_CODE_W"].ToString().Trim() && e.Cell.Row.Cells["ITEM_CODE_C"].Text.Trim() == dataTable2_2.Rows[i]["ITEM_CODE_C"].ToString().Trim())
                        {
                            dataTable2_2.Rows.RemoveAt(i);
                            i--;
                        }
                    }

                }
                GridHelper.RefreshAndAutoSize(ultraGrid2_2);
            }
        }

        private void ultraGrid3_1_CellChange(object sender, CellEventArgs e)
        {
            if (e.Cell.Column.Key == "CHK")
            {
                ultraGrid3_1.UpdateData();

                if (e.Cell.Text == "True")
                {
                    string phyMinItems = "PHY_CODE_MAX = '" + e.Cell.Row.Cells["PHY_CODE_MAX"].Text.Trim() + "' AND PHY_CODE_MIN = '" + e.Cell.Row.Cells["PHY_CODE_MIN"].Text.Trim() + "' AND PHY_CODE = '" + e.Cell.Row.Cells["PHY_CODE"].Text.Trim() + "'";

                    if (dataTable3_1.Select(phyMinItems) != null && dataTable3_1.Select(phyMinItems).Length > 0)
                    {
                        dataTable3_2.ImportRow(dataTable3_1.Select(phyMinItems)[0]);
                    }
                    //GridHelper.RefreshAndAutoSize(ultraGrid5);

                    //检验项变动对方向温度尺寸没影响
                    //本来已经勾选的项目需要勾选2015-07-30
                    //foreach (DataRow drR in m_dtPhyR.Rows)
                    //{
                    //    drR["CHK"] = "False";
                    //    foreach (DataRow dr in dataTable2_2.Rows)
                    //    {
                    //        //drR["CHK"] = "False";
                    //        if (drR["PHY_CODE"].ToString() == dr["PHY_CODE"].ToString())
                    //        {
                    //            drR["CHK"] = "True";
                    //            break;
                    //        }
                    //    }
                    //}

                    //GridHelper.CopyDataToDatatable(PublicPort.GetSelectDt(m_dtPhyR, phyMinItems), dataTable2_1, true);//筛选出符合条件的小项
                    //GridHelper.RefreshAndAutoSize(ultraGrid2_1);


                }
                else
                {
                    //dataTable4和dataTable5有此项目的需删除

                    for (int i = 0; i < dataTable3_2.Rows.Count; i++)
                    {
                        if (e.Cell.Row.Cells["PHY_CODE"].Text.Trim() == dataTable3_2.Rows[i]["PHY_CODE"].ToString())
                        {
                            dataTable3_2.Rows.RemoveAt(i);
                            i--;
                        }
                    }

                    //小项跟方向温度尺寸无关
                    //dataTable6.Rows.Clear();
                    //for (int i = 0; i < dataTable2_2.Rows.Count; i++)
                    //{
                    //    if (e.Cell.Row.Cells["PHY_CODE"].Text.Trim() == dataTable2_2.Rows[i]["PHY_CODE"].ToString())
                    //    {
                    //        dataTable2_2.Rows.RemoveAt(i);
                    //        i--;
                    //    }
                    //}
                }
                GridHelper.RefreshAndAutoSize(ultraGrid3_2);
                //GridHelper.RefreshAndAutoSize(ultraGrid2_2);
            }
        }


    }
}