MES_Client/TGMES/Core.StlMes.Client.Lims.Data.PipeAndOutdec/封装类/控件/PublicUltraGridDataCJBase.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using Infragistics.Win.UltraWinGrid;
using System.Collections;
using Core.Mes.Client.Comm;
using Core.Mes.Client.Comm.Tool;
using Core.Mes.Client.Comm.Server;
using CoreFS.CA06;
using Core.Mes.Client.Comm.Control;

//基本信息显示Grid
namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec
{
    public partial class PublicUltraGridDataCJBase : UserControl
    {
        public event EventHandler PublicUltraGridDataCJBaseActive;

        private DataTable m_OldDt;

        public DataTable OldDt
        {
            get { return m_OldDt; }
            set { m_OldDt = value; }
        }

        //private DataTable dataTable;

        public DataTable DataTable
        {
            get { return dataTable1; }
            set { dataTable1 = value; }
        }

        //private UltraGrid ug;

        public UltraGrid Ug
        {
            get { return ultraGrid1; }
            set { ultraGrid1 = value; }
        }

        private UltraGridRow ur;

        public UltraGridRow Ur
        {
            get { return ur; }
            set { ur = value; }
        }

        public PublicUltraGridDataCJBase()
        {
            InitializeComponent();
        }

        private void PublicUltraGridDataCJBase_Load(object sender, EventArgs e)
        {

        }

        //初始化明细数据列
        /// <summary>
        /// 初始化明细数据列
        /// </summary>
        public void InitColumnsDetail()
        {
            string[] arrColumns = new string[] { "FLAG", "FLAG_DESC", "CHECK_NO", "BATCH_NO", "SAMPLE_NO", "PHY_CODE_MAX", "PHY_NAME_MAX", "CHECK_STD", "SAMPLE_COUNT", "CHECK_NAME", "CHECK_TIME", "CHECK_TEMP", "DEVICE_NO", "DEVICE_NAME", "REMARK" };
            string[] arrCaption = new string[] { "状态", "状态", "检验编号", "性能批号", "样管号", "检验项代码", "检验项", "实验标准", "样条数", "试验人", "试验时间", "环境温度", "设备名称", "设备编码", "实验备注" };
            InitColumns(arrColumns, arrCaption);

            setColumnShowOrHidden(new string[] { "FLAG_DESC", "PHY_NAME_MAX", "CHECK_STD", "SAMPLE_COUNT" }, true);
            setOtherColumnReadOnly(null);//可编辑列
        }

        //查询检验委托基本信息
        /// <summary>
        /// 查询检验委托基本信息
        /// </summary>
        /// <param name="path"></param>
        /// <param name="arrayList"></param>
        /// <param name="ob"></param>
        /// <param name="arrId"></param>
        public void QueryCheckConsignDetail(string path, ArrayList arrayList, OpeBase ob, string[] arrId)
        {
            DataTable dt = PublicServer.GetData("com.steering.lims.data." + path + ".QueryCheckConsignDetail",
                        new Object[] { arrayList, arrId }, ob);

            if (dt == null || dt.Rows.Count == 0)
            {
                dataTable1.Rows.Clear();
                return;
            }
            GridHelper.CopyDataToDatatable(dt, dataTable1, true);//把dt复制给dataTable1

            GridHelper.RefreshAndAutoSize(ultraGrid1);//刷新Grid  
        }

        //初始化明细数据列
        /// <summary>
        /// 初始化明细数据列
        /// </summary>
        public void InitColumnsPhyDetail()
        {
            string[] arrColumns = new string[] { "PHYDETAIL_ID", "CHECK_NO", "BATCH_NO", "SAMPLE_NO", "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", "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15", "PHY_UNIT", "STDMIN_SIGN", "STDMIN", "STDMAX_SIGN", "STDMAX", "JUDGE_BASIS", "REMARK" };
            string[] arrCaption = new string[] { "试验项目明细编号", "检验编号", "性能批号", "样管号", "检验项代码", "检验项", "取样码", "取样码描述", "检验基础项代码", "检验基础项", "试验方向代码", "试验方向", "试验温度代码", "试验温度", "试样尺寸代码", "试样尺寸", "值1", "值2", "值3", "值4", "值5", "值6", "值7", "值8", "值9", "值10", "值11", "值12", "值13", "值14", "值15", "单位", "下限符号", "下限", "上限符号", "上限", "判定依据", "备注" };
            InitColumns(arrColumns, arrCaption);

            setColumnShowOrHidden(new string[] { "PHY_NAME_MAX", "PHY_NAME", "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15", "PHY_UNIT", "STDMIN_SIGN", "STDMIN", "STDMAX_SIGN", "STDMAX", "JUDGE_BASIS", "REMARK" }, true);
            setOtherColumnReadOnly(new string[] { "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15", "REMARK" });//可编辑列
        }

        //初始化明细数据列
        /// <summary>
        /// 初始化明细数据列
        /// </summary>
        public void InitColumnsOutdecPhyDetail()
        {
            string[] arrColumns = new string[] { "PHYDETAIL_ID", "CHECK_NO", "BATCH_NO", "SAMPLE_NO", "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", "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15", "AVERAGE", "AVERAGE_VALUE", "PHY_UNIT", "STDMIN_SIGN", "STDMIN", "STDMAX_SIGN", "STDMAX", "JUDGE_BASIS" };
            string[] arrCaption = new string[] { "试验项目明细编号", "检验编号", "性能批号", "样管号", "检验项代码", "检验项", "取样码", "取样码描述", "检验基础项代码", "检验基础项", "试验方向代码", "试验方向", "试验温度代码", "试验温度", "试样尺寸代码", "试样尺寸", "值1", "值2", "值3", "值4", "值5", "值6", "值7", "值8", "值9", "值10", "值11", "值12", "值13", "值14", "值15", "平均值", "平均值", "单位", "下限符号", "下限", "上限符号", "上限", "判定依据" };
            InitColumns(arrColumns, arrCaption);

            setColumnShowOrHidden(new string[] { "PHY_NAME_MAX", "PHY_NAME", "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15", "PHY_UNIT" }, true);
            setOtherColumnReadOnly(new string[] { "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15" });//可编辑列

            //this.ultraGrid1.DisplayLayout.Bands[0].Columns["aa"].EditorComponent = ultraTextEditor1;
            //this.ultraGrid1.DisplayLayout.Bands[0].Columns["aa"].CellActivation = Activation.ActivateOnly;
            //this.ultraGrid1.DisplayLayout.Bands[0].Columns["aa"].ButtonDisplayStyle = ButtonDisplayStyle.Always;
        }

        //初始化明细数据列
        /// <summary>
        /// 初始化明细数据列
        /// </summary>
        public void InitColumnsPipePhyDetail()
        {
            string[] arrColumns = new string[] { "PHYDETAIL_ID", "CHECK_NO", "BATCH_NO", "SAMPLE_NO", "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", "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15", "AVERAGE_VALUE", "PHY_UNIT", "STDMIN_SIGN", "STDMIN", "STDMAX_SIGN", "STDMAX", "JUDGE_BASIS" };
            string[] arrCaption = new string[] { "试验项目明细编号", "检验编号", "性能批号", "样管号", "检验项代码", "检验项", "取样码", "取样码描述", "检验基础项代码", "检验基础项", "试验方向代码", "试验方向", "试验温度代码", "试验温度", "试样尺寸代码", "试样尺寸", "值1", "值2", "值3", "值4", "值5", "值6", "值7", "值8", "值9", "值10", "值11", "值12", "值13", "值14", "值15", "平均值", "单位", "下限符号", "下限", "上限符号", "上限", "判定依据" };
            InitColumns(arrColumns, arrCaption);

            setColumnShowOrHidden(new string[] { "PHY_NAME_MAX", "PHY_NAME", "VALUE1", "VALUE2", "VALUE3", "PHY_UNIT" }, true);
            setOtherColumnReadOnly(new string[] { "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15" });//可编辑列

            //this.ultraGrid1.DisplayLayout.Bands[0].Columns["aa"].EditorComponent = ultraTextEditor1;
            //this.ultraGrid1.DisplayLayout.Bands[0].Columns["aa"].CellActivation = Activation.ActivateOnly;
            //this.ultraGrid1.DisplayLayout.Bands[0].Columns["aa"].ButtonDisplayStyle = ButtonDisplayStyle.Always;
        }

        //初始化明细数据列
        /// <summary>
        /// 初始化明细数据列
        /// </summary>
        public void InitColumnsOutdecPhyDetail2()
        {
            string[] arrColumns = new string[] { "PHYDETAIL_ID", "CHECK_NO", "BATCH_NO", "SAMPLE_NO", "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", "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15", "AVERAGE", "PHY_UNIT", "STDMIN_SIGN", "STDMIN", "STDMAX_SIGN", "STDMAX", "JUDGE_BASIS" };
            string[] arrCaption = new string[] { "试验项目明细编号", "检验编号", "性能批号", "样管号", "检验项代码", "检验项", "取样码", "取样码描述", "检验基础项代码", "检验基础项", "试验方向代码", "试验方向", "试验温度代码", "试验温度", "试样尺寸代码", "试样尺寸", "值1", "值2", "值3", "值4", "值5", "值6", "值7", "值8", "值9", "值10", "值11", "值12", "值13", "值14", "值15", "平均值", "单位", "下限符号", "下限", "上限符号", "上限", "判定依据" };
            InitColumns(arrColumns, arrCaption);

            setColumnShowOrHidden(new string[] { "PHY_NAME_MAX", "PHY_NAME", "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15", "AVERAGE", "PHY_UNIT" }, true);
            setOtherColumnReadOnly(new string[] { "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15", "AVERAGE" });//可编辑列

            //this.ultraGrid1.DisplayLayout.Bands[0].Columns["aa"].EditorComponent = ultraTextEditor1;
            //this.ultraGrid1.DisplayLayout.Bands[0].Columns["aa"].CellActivation = Activation.ActivateOnly;
            //this.ultraGrid1.DisplayLayout.Bands[0].Columns["aa"].ButtonDisplayStyle = ButtonDisplayStyle.Always;
        }

        /// <summary>
        /// 初始化明细数据列商检(HIC)
        /// </summary>
        public void InitColumnsOutdecPhyDetailHIC()
        {
            string[] arrColumns = new string[] { "PHYDETAIL_ID", "CHECK_NO", "BATCH_NO", "SAMPLE_NO", "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", "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15", "AVERAGE", "PHY_UNIT", "STDMIN_SIGN", "STDMIN", "STDMAX_SIGN", "STDMAX", "JUDGE_BASIS" };
            string[] arrCaption = new string[] { "试验项目明细编号", "检验编号", "性能批号", "样管号", "检验项代码", "检验项", "取样码", "取样码描述", "检验基础项代码", "检验基础项", "试验方向代码", "试验方向", "试验温度代码", "试验温度", "试样尺寸代码", "试样尺寸", "1-1-1", "1-1-2", "1-1-3", "1-1平均值", "1-2-1", "1-2-2", "1-2-3", "1-2平均值", "1-3-1", "1-3-2", "1-3-3", "1-3平均值", "值13", "值14", "值15", "总平均值", "单位", "下限符号", "下限", "上限符号", "上限", "判定依据" };
            InitColumns(arrColumns, arrCaption);

            setColumnShowOrHidden(new string[] { "PHY_NAME_MAX", "PHY_NAME", "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "AVERAGE", "PHY_UNIT" }, true);
            setOtherColumnReadOnly(new string[] { "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "AVERAGE" });//可编辑列
        }

        /// <summary>
        /// 初始化明细数据列管材(HIC)
        /// </summary>
        public void InitColumnsPipePhyDetailHIC()
        {
            string[] arrColumns = new string[] { "PHYDETAIL_ID", "CHECK_NO", "BATCH_NO", "SAMPLE_NO", "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", "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15", "AVERAGE_VALUE", "PHY_UNIT", "STDMIN_SIGN", "STDMIN", "STDMAX_SIGN", "STDMAX", "JUDGE_BASIS" };
            string[] arrCaption = new string[] { "试验项目明细编号", "检验编号", "性能批号", "样管号", "检验项代码", "检验项", "取样码", "取样码描述", "检验基础项代码", "检验基础项", "试验方向代码", "试验方向", "试验温度代码", "试验温度", "试样尺寸代码", "试样尺寸", "1-1-1", "1-1-2", "1-1-3", "1-1平均值", "1-2-1", "1-2-2", "1-2-3", "1-2平均值", "1-3-1", "1-3-2", "1-3-3", "1-3平均值", "值13", "值14", "值15", "总平均值", "单位", "下限符号", "下限", "上限符号", "上限", "判定依据" };
            InitColumns(arrColumns, arrCaption);

            setColumnShowOrHidden(new string[] { "PHY_NAME_MAX", "PHY_NAME", "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "AVERAGE_VALUE", "PHY_UNIT" }, true);
            setOtherColumnReadOnly(new string[] { "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "AVERAGE_VALUE" });//可编辑列
        }

        /// <summary>
        /// 初始化明细数据列(力学硬度)
        /// </summary>
        public void InitColumnsOutdecPhyDetailYD()
        {
            string[] arrColumns = new string[] { "PHYDETAIL_ID", "CHECK_NO", "BATCH_NO", "SAMPLE_NO", "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", "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15", "AVERAGE", "PHY_UNIT", "STDMIN_SIGN", "STDMIN", "STDMAX_SIGN", "STDMAX", "JUDGE_BASIS" };
            string[] arrCaption = new string[] { "试验项目明细编号", "检验编号", "性能批号", "样管号", "检验项代码", "检验项", "取样码", "取样码描述", "检验基础项代码", "检验基础项", "试验方向代码", "试验方向", "试验温度代码", "试验温度", "试样尺寸代码", "试样尺寸", "值1", "值2", "值3", "值4", "值5", "值6", "值7", "值8", "值9", "值10", "值11", "值12", "值13", "值14", "值15", "平均值", "单位", "下限符号", "下限", "上限符号", "上限", "判定依据" };
            InitColumns(arrColumns, arrCaption);

            setColumnShowOrHidden(new string[] { "PHY_NAME_MAX", "PHY_NAME", "VALUE1", "VALUE2", "VALUE3", "VALUE4", "AVERAGE", "PHY_UNIT" }, true);
            setOtherColumnReadOnly(new string[] { "VALUE1", "VALUE2", "VALUE3", "VALUE4", "AVERAGE" });//可编辑列
        }

        /// <summary>
        /// 初始化明细数据列(3个值)
        /// </summary>
        public void InitColumnsOutdecPhyDetailYD3()
        {
            string[] arrColumns = new string[] { "PHYDETAIL_ID", "CHECK_NO", "BATCH_NO", "SAMPLE_NO", "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", "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15", "AVERAGE", "PHY_UNIT", "STDMIN_SIGN", "STDMIN", "STDMAX_SIGN", "STDMAX", "JUDGE_BASIS" };
            string[] arrCaption = new string[] { "试验项目明细编号", "检验编号", "性能批号", "样管号", "检验项代码", "检验项", "取样码", "取样码描述", "检验基础项代码", "检验基础项", "试验方向代码", "试验方向", "试验温度代码", "试验温度", "试样尺寸代码", "试样尺寸", "值1", "值2", "值3", "值4", "值5", "值6", "值7", "值8", "值9", "值10", "值11", "值12", "值13", "值14", "值15", "平均值", "单位", "下限符号", "下限", "上限符号", "上限", "判定依据" };
            InitColumns(arrColumns, arrCaption);

            setColumnShowOrHidden(new string[] { "PHY_NAME_MAX", "PHY_NAME", "VALUE1", "VALUE2", "VALUE3", "AVERAGE", "PHY_UNIT" }, true);
            setOtherColumnReadOnly(new string[] { "VALUE1", "VALUE2", "VALUE3", "VALUE4", "AVERAGE" });//可编辑列
        }

        public void InitColumnsPhyDetail(string[] arrStr)
        {
            string[] arrColumns = new string[] { "PHYDETAIL_ID", "CHECK_NO", "BATCH_NO", "SAMPLE_NO", "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", "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15", "PHY_UNIT", "STDMIN_SIGN", "STDMIN", "STDMAX_SIGN", "STDMAX", "JUDGE_BASIS", "REMARK" };
            string[] arrCaption = new string[] { "试验项目明细编号", "检验编号", "性能批号", "样管号", "检验项代码", "检验项", "取样码", "取样码描述", "检验基础项代码", "检验基础项", "试验方向代码", "试验方向", "试验温度代码", "试验温度", "试样尺寸代码", "试样尺寸", "值1", "值2", "值3", "值4", "值5", "值6", "值7", "值8", "值9", "值10", "值11", "值12", "值13", "值14", "值15", "单位", "下限符号", "下限", "上限符号", "上限", "判定依据", "备注" };
            InitColumns(arrColumns, arrCaption);

            setColumnShowOrHidden(new string[] { "PHY_NAME", "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15", "PHY_UNIT", "STDMIN_SIGN", "STDMIN", "STDMAX_SIGN", "STDMAX", "JUDGE_BASIS", "REMARK" }, true);//显示列
            setOtherColumnReadOnly(arrStr);//可编辑列
        }

        public void InitColumnsOutdecPhyDetail(string[] arrStr)
        {
            string[] arrColumns = new string[] { "PHYDETAIL_ID", "CHECK_NO", "BATCH_NO", "SAMPLE_NO", "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", "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15", "PHY_UNIT", "STDMIN_SIGN", "STDMIN", "STDMAX_SIGN", "STDMAX", "JUDGE_BASIS" };
            string[] arrCaption = new string[] { "试验项目明细编号", "检验编号", "性能批号", "样管号", "检验项代码", "检验项", "取样码", "取样码描述", "检验基础项代码", "检验基础项", "试验方向代码", "试验方向", "试验温度代码", "试验温度", "试样尺寸代码", "试样尺寸", "值1", "值2", "值3", "值4", "值5", "值6", "值7", "值8", "值9", "值10", "值11", "值12", "值13", "值14", "值15", "单位", "下限符号", "下限", "上限符号", "上限", "判定依据" };
            InitColumns(arrColumns, arrCaption);

            setColumnShowOrHidden(new string[] { "PHY_NAME", "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15", "PHY_UNIT" }, true);//显示列
            setOtherColumnReadOnly(arrStr);//可编辑列
        }

        //查询检验委托理化项目信息
        //public void QueryCheckConsignPhyDetail(string path, ArrayList arrayList, OpeBase ob)
        //{
        //    DataTable dt = PublicServer.GetData("com.steering.lims.data." + path + ".QueryCheckConsignDetailPhyDetail", new Object[] { arrayList } , ob);

        //    if (dt == null || dt.Rows.Count == 0)
        //    {
        //        dataTable1.Rows.Clear();
        //        return;
        //    }
        //    GridHelper.CopyDataToDatatable(dt, dataTable1, true);//把dt复制给dataTable1

        //    HideNullColumn();

        //    UltraGridColumn[] cols1 = new UltraGridColumn[] { ultraGrid1.DisplayLayout.Bands[0].Columns["VALUE1"], ultraGrid1.DisplayLayout.Bands[0].Columns["VALUE2"], ultraGrid1.DisplayLayout.Bands[0].Columns["VALUE3"], ultraGrid1.DisplayLayout.Bands[0].Columns["VALUE4"], ultraGrid1.DisplayLayout.Bands[0].Columns["VALUE5"], ultraGrid1.DisplayLayout.Bands[0].Columns["VALUE6"], ultraGrid1.DisplayLayout.Bands[0].Columns["VALUE7"], ultraGrid1.DisplayLayout.Bands[0].Columns["VALUE8"], ultraGrid1.DisplayLayout.Bands[0].Columns["VALUE9"] };
        //    GridHelper.RefreshAndAutoSizeExceptColumns(ultraGrid1, cols1);

        //    //GridHelper.RefreshAndAutoSize(ultraGrid1);//刷新Grid  
        //}

        public void QueryCheckConsignPhyDetail(string path, ArrayList arrayList, OpeBase ob, string[] arrId)
        {
            DataTable dt = PublicServer.GetData("com.steering.lims.data." + path + ".QueryCheckConsignDetailPhyDetail",
                arrId == null ? new Object[] { arrayList } : new Object[] { arrayList, arrId }, ob);

            if (dt == null || dt.Rows.Count == 0)
            {
                dataTable1.Rows.Clear();
                return;
            }
            GridHelper.CopyDataToDatatable(dt, dataTable1, true);//把dt复制给dataTable1

            HideNullColumn(dt);

            PublicPipeAndOutdec.RefreshAndAutoSizeColumns(ultraGrid1, new string[] { "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15" }, false);//刷新Grid
        }

        /// <summary>
        /// 隐藏列、刷新Grid数据并根据数据调整Grid列宽
        /// </summary>
        /// <param name="dt"></param>
        public void QueryCheckConsignPhyDetail(DataTable dt)
        {
            if (dt == null || dt.Rows.Count == 0)
            {
                dataTable1.Rows.Clear();
                return;
            }
            GridHelper.CopyDataToDatatable(dt, dataTable1, true);//把dt复制给dataTable1
            m_OldDt = dataTable1.Copy();

            HideNullColumn(dt);

            PublicPipeAndOutdec.RefreshAndAutoSizeColumns(ultraGrid1, new string[] { "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15" }, false);//刷新Grid
        }

        /// <summary>
        /// 不隐藏列、刷新Grid数据并根据数据调整Grid列宽
        /// </summary>
        /// <param name="dt"></param>
        public void QueryCheckConsignPhyDetailHIC(DataTable dt)
        {
            if (dt == null || dt.Rows.Count == 0)
            {
                dataTable1.Rows.Clear();
                return;
            }
            GridHelper.CopyDataToDatatable(dt, dataTable1, true);//把dt复制给dataTable1
            m_OldDt = dataTable1.Copy();

            //HideNullColumn(dt);
            string strHide = "ITEM_NAME_F,ITEM_NAME_W,ITEM_NAME_S";
            PublicPipeAndOutdec.HideNullColumn(strHide, ultraGrid1);

            PublicPipeAndOutdec.RefreshAndAutoSizeColumns(ultraGrid1, new string[] { "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15" }, false);//刷新Grid
        }

        //初始化明细数据列
        /// <summary>
        /// 初始化明细数据列
        /// </summary>
        public void InitColumnsPhyConfigItems()
        {
            string[] arrColumns = new string[] { "CHECK_METHOD_NO", "CHECK_METHOD_NAME", "SHOW_SEQ", "PHY_CODE_MAX", "PHY_NAME_MAX", "CHECK_METHOD_ITEMNAME", "ISDOWN", "DEFAULT_VALUES", "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15" };
            string[] arrCaption = new string[] { "试验方法编号", "试验方法名称", "序号", "检验项代码", "检验项", "项目名称", "下拉", "默认值", "值1", "值2", "值3", "值4", "值5", "值6", "值7", "值8", "值9", "值10", "值11", "值12", "值13", "值14", "值15" };
            InitColumns(arrColumns, arrCaption);

            setColumnShowOrHidden(new string[] { "CHECK_METHOD_NO", "CHECK_METHOD_NAME", "PHY_CODE_MAX", "PHY_NAME_MAX", "ISDOWN", "DEFAULT_VALUES" }, false);
            setOtherColumnReadOnly(new string[] { "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15" });//可编辑列
        }

        //初始化明细数据列
        /// <summary>
        /// 初始化明细数据列
        /// </summary>
        /// <param name="arrStr"></param>
        public void InitColumnsPhyConfigItems(string[] arrStr)
        {
            string[] arrColumns = new string[] { "CHECK_METHOD_NO", "CHECK_METHOD_NAME", "SHOW_SEQ", "PHY_CODE_MAX", "PHY_NAME_MAX", "CHECK_METHOD_ITEMNAME", "ISDOWN", "DEFAULT_VALUES", "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15" };
            string[] arrCaption = new string[] { "试验方法编号", "试验方法名称", "序号", "检验项代码", "检验项", "项目名称", "下拉", "默认值", "值1", "值2", "值3", "值4", "值5", "值6", "值7", "值8", "值9", "值10", "值11", "值12", "值13", "值14", "值15" };
            InitColumns(arrColumns, arrCaption);

            setColumnShowOrHidden(new string[] { "CHECK_METHOD_NO", "CHECK_METHOD_NAME", "PHY_CODE_MAX", "PHY_NAME_MAX", "ISDOWN", "DEFAULT_VALUES" }, false);
            setOtherColumnReadOnly(arrStr);//可编辑列
        }

        //查询检验委托基本信息
        /// <summary>
        /// 查询检验委托基本信息
        /// </summary>
        /// <param name="strCode"></param>
        /// <param name="ob"></param>
        public void QueryCheckMethodPhyConfigItems(ArrayList strCode, OpeBase ob)
        {

            DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckMethodPhyConfigItems",
                        new Object[] { strCode }, ob);

            if (dt == null || dt.Rows.Count == 0)
            {
                dataTable1.Rows.Clear();
                return;
            }
            GridHelper.CopyDataToDatatable(dt, dataTable1, true);//把dt复制给dataTable1

            //HideNullColumn(dt);

            PublicPipeAndOutdec.RefreshAndAutoSizeColumns(ultraGrid1, new string[] { "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15" }, false);//刷新Grid
        }


        //查询检验委托基本信息
        /// <summary>
        /// 查询检验委托基本信息
        /// </summary>
        /// <param name="dt"></param>
        public void QueryCheckMethodPhyConfigItems(DataTable dt)
        {
            dataTable1.Rows.Clear();
            if (dt == null || dt.Rows.Count == 0)
            {
                return;
            }
            GridHelper.CopyDataToDatatable(dt, dataTable1, true);
            //DataRow dr;
            //foreach (DataRow dRow in dt.Rows)
            //{
            //    dr = dataTable1.NewRow();
            //    dr["CHECK_METHOD_NO"] = dRow["CHECK_METHOD_NO"];
            //    dr["CHECK_METHOD_NAME"] = dRow["CHECK_METHOD_NAME"];
            //    dr["PHY_CODE_MAX"] = dRow["PHY_CODE_MAX"];
            //    dr["PHY_NAME_MAX"] = dRow["PHY_NAME_MAX"];
            //    dr["CHECK_METHOD_ITEMNAME"] = dRow["CHECK_METHOD_ITEMNAME"];
            //    dr["SHOW_SEQ"] = dRow["SHOW_SEQ"];
            //    dr["ISDOWN"] = dRow["ISDOWN"];
            //    dr["DEFAULT_VALUES"] = dRow["DEFAULT_VALUES"];

            //    dataTable1.Rows.Add(dr);
            //}
            foreach (UltraGridRow ur in ultraGrid1.Rows)
            {
                if (ur.Cells["ISDOWN"].Text == "1")
                {
                    Infragistics.Win.ValueList vl = new Infragistics.Win.ValueList();
                    vl.ValueListItems.Add("");
                    string[] arr = ur.Cells["DEFAULT_VALUES"].Text.Trim().Split(',');
                    foreach (string str in arr)
                    {
                        vl.ValueListItems.Add(str);
                    }
                    foreach (UltraGridColumn uc in ultraGrid1.DisplayLayout.Bands[0].Columns)
                    {
                        if (uc.Key.IndexOf("VALUE") == 0 && uc.Hidden == false)
                        {
                            ur.Cells[uc.Key].ValueList = vl;
                        }
                    }
                }
            }
            //GridHelper.CopyDataToDatatable(dt, dataTable1, true);//把dt复制给dataTable1

            //HideNullColumn(dt);

            PublicPipeAndOutdec.RefreshAndAutoSizeColumns(ultraGrid1, new string[] { "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15" }, false);//刷新Grid
        }

        //查询检验委托理化项目明细信息
        /// <summary>
        /// 查询检验委托理化项目明细信息
        /// </summary>
        /// <param name="path"></param>
        /// <param name="strFlag"></param>
        /// <param name="arrayList"></param>
        /// <param name="ob"></param>
        public void QueryCheckConsignPhyDetailResult(string path, string strFlag, ArrayList arrayList, OpeBase ob)
        {
            try
            {
                DataTable dt = PublicServer.GetData("com.steering.lims.data." + path + ".QueryCheckConsignPhyDetailResult",
                        new Object[] { strFlag, arrayList }, ob);

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

                //设置一个全局变量存放原值
                GridHelper.CopyDataToDatatable(dt, dataTable1, true);//把dt复制给dataTable
                if (strFlag == "已录入")
                {
                    m_OldDt = dataTable1.Copy();
                }

                HideNullColumn(dt);

                UltraGridColumn[] cols1 = new UltraGridColumn[] { ultraGrid1.DisplayLayout.Bands[0].Columns["VALUE1"], ultraGrid1.DisplayLayout.Bands[0].Columns["VALUE2"], ultraGrid1.DisplayLayout.Bands[0].Columns["VALUE3"], ultraGrid1.DisplayLayout.Bands[0].Columns["VALUE4"], ultraGrid1.DisplayLayout.Bands[0].Columns["VALUE5"], ultraGrid1.DisplayLayout.Bands[0].Columns["VALUE6"], ultraGrid1.DisplayLayout.Bands[0].Columns["VALUE7"], ultraGrid1.DisplayLayout.Bands[0].Columns["VALUE8"], ultraGrid1.DisplayLayout.Bands[0].Columns["VALUE9"] };
                GridHelper.RefreshAndAutoSizeExceptColumns(ultraGrid1, cols1);

                //GridHelper.RefreshAndAutoSize(ultraGrid1);
            }
            catch (Exception e)
            {
                MessageUtil.ShowError(e.Message);
            }
        }

        //查询删除修改操作记录
        /// <summary>
        /// 查询删除修改操作记录
        /// </summary>
        /// <param name="path"></param>
        /// <param name="arrayList"></param>
        /// <param name="ob"></param>
        /// <param name="arrId"></param>
        public void QueryCheckConsignOperateRecord(string path, ArrayList arrayList, OpeBase ob, string[] arrId)
        {
            try
            {
                DataTable dt = PublicServer.GetData("com.steering.lims.data." + path + ".QueryCheckConsignOperateRecord",
                        new Object[] { arrayList, arrId }, ob);

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

                //设置一个全局变量存放原值
                GridHelper.CopyDataToDatatable(dt, dataTable1, true);//把dt复制给dataTable

                //GridHelper.RefreshAndAutoSize(ultraGrid1);
            }
            catch (Exception e)
            {
                MessageUtil.ShowError(e.Message);
            }
        }

        public void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            if (PublicUltraGridDataCJBaseActive != null)
            {
                ur = ultraGrid1.ActiveRow;
                PublicUltraGridDataCJBaseActive(sender, e);//调用委托事件
            }
        }

        //初始化列
        public void InitColumns(string[] arrColumns, string[] arrCaption)
        {
            PublicPipeAndOutdec.InitColumns(arrColumns, arrCaption, this.dataTable1);
        }

        //设置列是否隐藏
        /// <summary>
        /// 设置列是否隐藏
        /// </summary>
        /// <param name="keys"></param>
        /// <param name="isShow"></param>
        public void setColumnShowOrHidden(string[] keys, bool isShow)
        {
            PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid1, keys, isShow);
        }

        //可编辑列
        /// <summary>
        /// 可编辑列
        /// </summary>
        /// <param name="keys"></param>
        public void setOtherColumnReadOnly(string[] keys)
        {
            PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid1, keys);
        }

        //隐藏列
        /// <summary>
        /// 隐藏列
        /// </summary>
        /// <param name="dt"></param>
        public void HideNullColumn(DataTable dt)
        {
            if (dt.Columns.Contains("SAMPLE_COUNT") && dt.Columns.Contains("RESULT_COUNT"))
            {
                //根据SAMPLE_COUNT和RESULT_COUNT算出最多需要录入多少值
                int numMax = 1;
                foreach (DataRow dr in dt.Rows)
                {
                    int intSAMPLE_COUNT = dr["SAMPLE_COUNT"].ToString() == "" ? 0 : (dr["SAMPLE_COUNT"].ToString().TryParseInt() ? Convert.ToInt16(dr["SAMPLE_COUNT"].ToString()) : 0);
                    int intRESULT_COUNT = dr["RESULT_COUNT"].ToString() == "" ? 0 : (dr["RESULT_COUNT"].ToString().TryParseInt() ? Convert.ToInt16(dr["RESULT_COUNT"].ToString()) : 0);
                    int temp = intSAMPLE_COUNT >= intRESULT_COUNT ? intSAMPLE_COUNT : intRESULT_COUNT;
                    numMax = numMax >= temp ? numMax : temp;
                }
                //四象限夹杂
                if (dt.Rows[0]["PHY_CODE_MAX"].ToString().Equals("C0115"))
                {
                    numMax = 4;
                }
                string[] strValue = new string[] { "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15" };
                for (int i = 0; i < strValue.Length; i++)
                {
                    if (i < numMax)
                    {
                        ultraGrid1.DisplayLayout.Bands[0].Columns[strValue[i]].Hidden = false;
                    }
                    else
                    {
                        ultraGrid1.DisplayLayout.Bands[0].Columns[strValue[i]].Hidden = true;
                    }
                }
                //string strHide = "ITEM_NAME_F,ITEM_NAME_W,ITEM_NAME_S";
                //PublicPipeAndOutdec.HideNullColumn(strHide, ultraGrid1);
            }
            else if (dt.Columns.Contains("SAMPLE_COUNT"))
            {
                //根据SAMPLE_COUNT和RESULT_COUNT算出最多需要录入多少值
                int numMax = 1;
                foreach (DataRow dr in dt.Rows)
                {
                    int intSAMPLE_COUNT = dr["SAMPLE_COUNT"].ToString() == "" ? 0 : (dr["SAMPLE_COUNT"].ToString().TryParseInt() ? Convert.ToInt16(dr["SAMPLE_COUNT"].ToString()) : 0);
                    numMax = numMax >= intSAMPLE_COUNT ? numMax : intSAMPLE_COUNT;
                }
                string[] strValue = new string[] { "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15" };
                for (int i = 0; i < strValue.Length; i++)
                {
                    if (i < numMax)
                    {
                        ultraGrid1.DisplayLayout.Bands[0].Columns[strValue[i]].Hidden = false;
                    }
                    else
                    {
                        ultraGrid1.DisplayLayout.Bands[0].Columns[strValue[i]].Hidden = true;
                    }
                }

                //strHide = "ITEM_NAME_F,ITEM_NAME_W,ITEM_NAME_S,VALUE1,VALUE2,VALUE3,VALUE4,VALUE5,VALUE6,VALUE7,VALUE8,VALUE9,VALUE10,VALUE11,VALUE12,VALUE13,VALUE14,VALUE15";
                //PublicPipeAndOutdec.HideNullColumn(strHide, ultraGrid1);
            }
            string strHide = "ITEM_NAME_F,ITEM_NAME_W,ITEM_NAME_S";
            PublicPipeAndOutdec.HideNullColumn(strHide, ultraGrid1);
        }

        //隐藏列
        /// <summary>
        /// 隐藏列
        /// </summary>
        /// <param name="dt"></param>
        /// <param name="ultraGrid"></param>
        public void HideNullColumn(DataTable dt, UltraGrid ultraGrid)
        {
            if (dt.Columns.Contains("SAMPLE_COUNT") && dt.Columns.Contains("RESULT_COUNT"))
            {
                //根据SAMPLE_COUNT和RESULT_COUNT算出最多需要录入多少值
                int numMax = 1;
                foreach (DataRow dr in dt.Rows)
                {
                    int intSAMPLE_COUNT = dr["SAMPLE_COUNT"].ToString() == "" ? 0 : (dr["SAMPLE_COUNT"].ToString().TryParseInt() ? Convert.ToInt16(dr["SAMPLE_COUNT"].ToString()) : 0);
                    int intRESULT_COUNT = dr["RESULT_COUNT"].ToString() == "" ? 0 : (dr["RESULT_COUNT"].ToString().TryParseInt() ? Convert.ToInt16(dr["RESULT_COUNT"].ToString()) : 0);
                    int temp = intSAMPLE_COUNT >= intRESULT_COUNT ? intSAMPLE_COUNT : intRESULT_COUNT;
                    numMax = numMax >= temp ? numMax : temp;
                }
                string[] strValue = new string[] { "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15" };
                for (int i = 0; i < strValue.Length; i++)
                {
                    if (i < numMax)
                    {
                        ultraGrid.DisplayLayout.Bands[0].Columns[strValue[i]].Hidden = false;
                    }
                    else
                    {
                        ultraGrid.DisplayLayout.Bands[0].Columns[strValue[i]].Hidden = true;
                    }
                }
                //string strHide = "";
                //PublicPipeAndOutdec.HideNullColumn(strHide, ultraGrid);
            }
            else if (dt.Columns.Contains("SAMPLE_COUNT"))
            {
                //根据SAMPLE_COUNT和RESULT_COUNT算出最多需要录入多少值
                int numMax = 1;
                foreach (DataRow dr in dt.Rows)
                {
                    int intSAMPLE_COUNT = dr["SAMPLE_COUNT"].ToString() == "" ? 0 : (dr["SAMPLE_COUNT"].ToString().TryParseInt() ? Convert.ToInt16(dr["SAMPLE_COUNT"].ToString()) : 0);
                    numMax = numMax >= intSAMPLE_COUNT ? numMax : intSAMPLE_COUNT;
                }
                string[] strValue = new string[] { "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15" };
                for (int i = 0; i < strValue.Length; i++)
                {
                    if (i < numMax)
                    {
                        ultraGrid1.DisplayLayout.Bands[0].Columns[strValue[i]].Hidden = false;
                    }
                    else
                    {
                        ultraGrid1.DisplayLayout.Bands[0].Columns[strValue[i]].Hidden = true;
                    }
                }
            }
            //else
            //{
            //    string strHide = "VALUE1,VALUE2,VALUE3,VALUE4,VALUE5,VALUE6,VALUE7,VALUE8,VALUE9,VALUE10,VALUE11,VALUE12,VALUE13,VALUE14,VALUE15";
            //    PublicPipeAndOutdec.HideNullColumn(strHide, ultraGrid);
            //}
        }

        private void ultraGrid1_DoubleClickCell(object sender, DoubleClickCellEventArgs e)
        {
            if (e.Cell.Column.Key == "VALUE1")
            {
                if (e.Cell.Text == "无")
                {
                    e.Cell.Value = "有";
                }
                else if (e.Cell.Text == "有")
                {
                    e.Cell.Value = "无";
                }
            }
        }

        
    }
}