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 = "无";
}
}
}
}
}