MES_Client/TGMES/Core.StlMes.Client.Lims.Data.PipeAndOutdec/数据管理/基础信息管理/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.Data.PipeAndOutdec
{
    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_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();//查询检验项补充项


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

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

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

        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            //ultraGrid1.DisplayLayout.Override.RowFilterMode = RowFilterMode.SiblingRowsOnly;
            //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;
            ultraGrid5.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            ultraGrid6.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            ultraGrid7.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" };
            string[] arrCaption = new string[] { "选择", "检验项代码", "检验项", "试验室", "试样组", "试样组", "检验基础项代码", "检验基础项", "单位", "试验方向代码", "试验方向", "试验温度代码", "试验温度", "试样尺寸代码", "试样尺寸" };
            //InitColumns(arrColumns, arrCaption, dataTable1, ultraGrid1, new string[] { "CHK", "PHY_NAME_MAX" }, true, new string[] { "CHK" });//ultraGrid1大项

            InitColumns(arrColumns, arrCaption, dataTable2, ultraGrid2, new string[] { "CHK", "PHY_NAME_MAX", "PHY_NAME_MIN" }, true, new string[] { "CHK" });//ultraGrid2试样组
            InitColumns(arrColumns, arrCaption, dataTable3, ultraGrid3, new string[] { "PHY_NAME_MAX", "PHY_NAME_MIN" }, true, null);//ultraGrid3试样组 "PHY_NAME_MAX",

            InitColumns(arrColumns, arrCaption, dataTable4, ultraGrid4, new string[] { "CHK", "PHY_NAME", "PHY_UNIT" }, true, new string[] { "CHK" });//ultraGrid4检验项目小项
            InitColumns(arrColumns, arrCaption, dataTable5, ultraGrid5, new string[] { "PHY_NAME", "PHY_UNIT" }, true, null);//ultraGrid5检验项目小项

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

        private void InitColumns(string[] arrColumns, string[] arrCaption, DataTable dataTable, UltraGrid ultraGrid, string[] show, bool isShow, string[] ope)
        {
            PublicPipeAndOutdec.InitColumns(arrColumns, arrCaption, dataTable);
            PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid, show, isShow);
            PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid, ope);
        }

        //查询理化项目大类信息
        //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);
        //    }
        //}

        //查询理化项目试样组
        /// <summary>
        /// 查询理化项目试样组
        /// </summary>
        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, dataTable2, true);

                if (m_dtSelectPhySampleCode != null && m_dtSelectPhySampleCode.Rows.Count > 0)
                {
                    foreach (DataRow dr in dataTable2.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, dataTable3, true);//已经选择试样组默认勾选0810
                }

                GridHelper.RefreshAndAutoSize(ultraGrid2);
                GridHelper.RefreshAndAutoSize(ultraGrid3);
            }
            catch //(Exception ex)
            {
                //MessageUtil.ShowError(ex.Message);
            }
        }


        //查询理化项目小类信息
        /// <summary>
        /// 查询理化项目小类信息
        /// </summary>
        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, dataTable5, true);//已经选择小项默认勾选0810
                }
            }
            catch //(Exception ex)
            {
                //MessageUtil.ShowError(ex.Message);
            }
        }

        //查询理化项目方向、温度、尺寸信息
        /// <summary>
        /// 查询理化项目方向、温度、尺寸信息
        /// </summary>
        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, dataTable7, true);//已经选择方向温度尺寸默认勾选0810
                }
                GridHelper.RefreshAndAutoSize(ultraGrid7);
            }
            catch //(Exception ex)
            {
                //MessageUtil.ShowError(ex.Message);
            }
        }

        //查询检验项补充项
        /// <summary>
        /// 查询检验项补充项
        /// </summary>
        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;
            }
        }

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

        //获取选择的项目0810
        private bool GetSelectItems()
        {
            //string sqlSelect = "CHK = 'True'";
            //m_dtSelectPhyMax = PublicPipeAndOutdec.GetSelectDt(dataTable2, sqlSelect);//筛选出符合条件的大项

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

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

            return true;
        }

        //依据选择的大项查询出小项0810
        //private void ultraGrid1_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
        //{
        //    if (e.Cell.Column.Key == "CHK")
        //    {
        //        ultraGrid1.UpdateData();

        //        bool isSelect = false;//判断是否有选中的项目

        //        foreach (DataRow dr in dataTable1.Rows)
        //        {
        //            if (dr["CHK"].ToString() == "True")
        //            {
        //                isSelect = true;
        //            }
        //        }

        //        if (isSelect == false)
        //        {
        //            dataTable2.Rows.Clear();
        //            dataTable3.Rows.Clear();
        //            dataTable4.Rows.Clear();
        //            dataTable5.Rows.Clear();
        //            dataTable6.Rows.Clear();
        //            dataTable7.Rows.Clear();
        //            return;
        //        }

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

        //            //20160520试样组
        //            foreach (DataRow drR in m_dtPhySampleCode.Rows)
        //            {
        //                drR["CHK"] = "False";
        //                foreach (DataRow dr in dataTable3.Rows)
        //                {
        //                    if (drR["PHY_CODE_MAX"].ToString() == dr["PHY_CODE_MAX"].ToString() && drR["PHY_CODE_MIN"].ToString() == dr["PHY_CODE_MIN"].ToString())
        //                    {
        //                        drR["CHK"] = "True";
        //                        break;
        //                    }
        //                }
        //            }
        //            GridHelper.CopyDataToDatatable(PublicPipeAndOutdec.GetSelectDt(m_dtPhySampleCode, phyMaxItems), dataTable2, true);//筛选出符合条件的小项
        //            GridHelper.RefreshAndAutoSize(ultraGrid2);
        //        }
        //        else
        //        {
        //            //dataTable4和dataTable5有此项目的需删除
        //            dataTable2.Rows.Clear();
        //            dataTable4.Rows.Clear();
        //            dataTable6.Rows.Clear();

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

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

        //            if (dataTable7.Rows.Count > 0)
        //            {
        //                for (int i = 0; i < dataTable7.Rows.Count; i++)
        //                {
        //                    if (e.Cell.Row.Cells["PHY_CODE_MAX"].Text.Trim() == dataTable7.Rows[i]["PHY_CODE_MAX"].ToString())
        //                    {
        //                        dataTable7.Rows.RemoveAt(i);
        //                        i--;
        //                    }
        //                }
        //            }
        //            GridHelper.RefreshAndAutoSize(ultraGrid3);
        //            GridHelper.RefreshAndAutoSize(ultraGrid5);
        //            GridHelper.RefreshAndAutoSize(ultraGrid7);
        //        }
        //    }
        //}

        //依据选择的试样组显示
        /// <summary>
        /// 依据选择的试样组显示
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid2_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
        {
            if (e.Cell.Column.Key == "CHK")
            {
                ultraGrid2.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 (dataTable2.Select(phyMaxItems) != null && dataTable2.Select(phyMaxItems).Length > 0)
                    {
                        dataTable3.ImportRow(dataTable2.Select(phyMaxItems)[0]);
                    }
                    GridHelper.RefreshAndAutoSize(ultraGrid3);

                    //本来已经勾选的项目需要勾选2015-07-30
                    foreach (DataRow drR in m_dtPhyMin.Rows)
                    {
                        drR["CHK"] = "False";
                        foreach (DataRow dr in dataTable5.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(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMin, phyMaxItems), dataTable4, true);//筛选出符合条件的小项
                    GridHelper.RefreshAndAutoSize(ultraGrid4);

                    //datatable6 根据试样组显示对应的方向温度尺寸
                    GridHelper.CopyDataToDatatable(PublicPipeAndOutdec.GetSelectDt(m_dtPhyR, phyMaxItems), dataTable6, true);//筛选出符合条件的小项
                    GridHelper.RefreshAndAutoSize(ultraGrid6);
                }
                else
                {
                    //dataTable4和dataTable5有此项目的需删除
                    dataTable4.Rows.Clear();
                    dataTable6.Rows.Clear();

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

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

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

            }
        }

        //依据选择的小查询出试验方向温度尺寸0810
        private void ultraGrid4_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
        {
            if (e.Cell.Column.Key == "CHK")
            {
                ultraGrid4.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 (dataTable4.Select(phyMinItems) != null && dataTable4.Select(phyMinItems).Length > 0)
                    {
                        dataTable5.ImportRow(dataTable4.Select(phyMinItems)[0]);
                    }
                    //GridHelper.RefreshAndAutoSize(ultraGrid5);

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

                    //GridHelper.CopyDataToDatatable(PublicPipeAndOutdec.GetSelectDt(m_dtPhyR, phyMinItems), dataTable6, true);//筛选出符合条件的小项
                    //GridHelper.RefreshAndAutoSize(ultraGrid6);


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

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

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

        private void ultraGrid6_CellChange(object sender, CellEventArgs e)
        {
            if (e.Cell.Column.Key == "CHK")
            {
                ultraGrid6.UpdateData();
                //选择了dataTable5增加此行
                if (e.Cell.Text == "True")
                {
                    DataRow dr = dataTable7.NewRow();
                    foreach (UltraGridColumn uc in ultraGrid6.DisplayLayout.Bands[0].Columns)
                    {
                        dr[uc.Key] = e.Cell.Row.Cells[uc.Key].Text.Trim();
                    }
                    dataTable7.Rows.Add(dr);
                    //dataTable5.ImportRow(dataTable3.Select(phyR)[0]);
                }
                else
                {
                    for (int i = 0; i < dataTable7.Rows.Count; i++)
                    {
                        if (e.Cell.Row.Cells["PHY_CODE_MAX"].Text.Trim() == dataTable7.Rows[i]["PHY_CODE_MAX"].ToString() && e.Cell.Row.Cells["ITEM_CODE_F"].Text.Trim() == dataTable7.Rows[i]["ITEM_CODE_F"].ToString().Trim() && e.Cell.Row.Cells["ITEM_CODE_W"].Text.Trim() == dataTable7.Rows[i]["ITEM_CODE_W"].ToString().Trim() && e.Cell.Row.Cells["ITEM_CODE_C"].Text.Trim() == dataTable7.Rows[i]["ITEM_CODE_C"].ToString().Trim())
                        {
                            dataTable7.Rows.RemoveAt(i);
                            i--;
                        }
                    }

                }
                GridHelper.RefreshAndAutoSize(ultraGrid7);
            }
        }

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

        //        //本来已经勾选的项目需要勾选2015-07-30
        //        foreach (DataRow drR in m_dtPhySampleCode.Rows)
        //        {
        //            drR["CHK"] = "False";
        //            foreach (DataRow dr in dataTable3.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["CHK"] = "True";
        //                    break;
        //                }
        //            }
        //        }
        //        GridHelper.CopyDataToDatatable(PublicPipeAndOutdec.GetSelectDt(m_dtPhySampleCode, phyMaxItems), dataTable2, true);//筛选出符合条件的小项
        //        GridHelper.RefreshAndAutoSize(ultraGrid2);
        //    }
        //    else
        //    {
        //        dataTable2.Rows.Clear();
        //        dataTable4.Rows.Clear();
        //        dataTable6.Rows.Clear();
        //    }
        //}

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

                //本来已经勾选的项目需要勾选2015-07-30
                foreach (DataRow drR in m_dtPhyMin.Rows)
                {
                    drR["CHK"] = "False";
                    foreach (DataRow dr in dataTable5.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(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMin, phyMaxItems), dataTable4, true);//筛选出符合条件的小项
                GridHelper.RefreshAndAutoSize(ultraGrid4);

                //datatable6 根据试样组显示对应的方向温度尺寸
                //    //本来已经勾选的项目需要勾选2015-07-30
                foreach (DataRow drR in m_dtPhyR.Rows)
                {
                    drR["CHK"] = "False";
                    foreach (DataRow dr in dataTable7.Rows)
                    {
                        //drR["CHK"] = "False";
                        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(PublicPipeAndOutdec.GetSelectDt(m_dtPhyR, phyMaxItems), dataTable6, true);//筛选出符合条件的小项
                GridHelper.RefreshAndAutoSize(ultraGrid6);
            }
            else
            {
                dataTable4.Rows.Clear();
                dataTable6.Rows.Clear();
            }
        }

        //小项选择事件
        private void ultraGrid4_AfterRowActivate(object sender, EventArgs e)
        {
            //if (ultraGrid4.ActiveRow.Cells["CHK"].Text.Trim() == "True")
            //{
            //    string phyR = "PHY_CODE_MAX = '" + ultraGrid4.ActiveRow.Cells["PHY_CODE_MAX"].Text.Trim() + "' AND PHY_CODE_MIN = '" + ultraGrid4.ActiveRow.Cells["PHY_CODE_MIN"].Text.Trim() + "' AND PHY_CODE = '" + ultraGrid4.ActiveRow.Cells["PHY_CODE"].Text.Trim() + "'";

            //    //本来已经勾选的项目需要勾选2015-07-30
            //    foreach (DataRow drR in m_dtPhyR.Rows)
            //    {
            //        drR["CHK"] = "False";
            //        foreach (DataRow dr in dataTable7.Rows)
            //        {
            //            //drR["CHK"] = "False";
            //            if (drR["PHY_CODE"].ToString() == dr["PHY_CODE"].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(PublicPipeAndOutdec.GetSelectDt(m_dtPhyR, phyR), dataTable6, true);//筛选出符合条件的小项
            //    GridHelper.RefreshAndAutoSize(ultraGrid6);
            //    GridHelper.RefreshAndAutoSize(ultraGrid7);
            //}
            //else
            //{
            //    dataTable6.Rows.Clear();
            //}
        }
    }
}