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) { } //初始化明细数据列 /// /// 初始化明细数据列 /// 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);//可编辑列 } //查询检验委托基本信息 /// /// 查询检验委托基本信息 /// /// /// /// /// 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 } //初始化明细数据列 /// /// 初始化明细数据列 /// 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" });//可编辑列 } //初始化明细数据列 /// /// 初始化明细数据列 /// 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; } //初始化明细数据列 /// /// 初始化明细数据列 /// 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; } //初始化明细数据列 /// /// 初始化明细数据列 /// 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; } /// /// 初始化明细数据列商检(HIC) /// 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" });//可编辑列 } /// /// 初始化明细数据列管材(HIC) /// 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" });//可编辑列 } /// /// 初始化明细数据列(力学硬度) /// 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" });//可编辑列 } /// /// 初始化明细数据列(3个值) /// 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 } /// /// 隐藏列、刷新Grid数据并根据数据调整Grid列宽 /// /// 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 } /// /// 不隐藏列、刷新Grid数据并根据数据调整Grid列宽 /// /// 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 } //初始化明细数据列 /// /// 初始化明细数据列 /// 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" });//可编辑列 } //初始化明细数据列 /// /// 初始化明细数据列 /// /// 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);//可编辑列 } //查询检验委托基本信息 /// /// 查询检验委托基本信息 /// /// /// 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 } //查询检验委托基本信息 /// /// 查询检验委托基本信息 /// /// 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 } //查询检验委托理化项目明细信息 /// /// 查询检验委托理化项目明细信息 /// /// /// /// /// 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); } } //查询删除修改操作记录 /// /// 查询删除修改操作记录 /// /// /// /// /// 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); } //设置列是否隐藏 /// /// 设置列是否隐藏 /// /// /// public void setColumnShowOrHidden(string[] keys, bool isShow) { PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid1, keys, isShow); } //可编辑列 /// /// 可编辑列 /// /// public void setOtherColumnReadOnly(string[] keys) { PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid1, keys); } //隐藏列 /// /// 隐藏列 /// /// 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); } //隐藏列 /// /// 隐藏列 /// /// /// 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 = "无"; } } } } }