private void InitDGX()
{
DGX.OptionsBehavior.AutoPopulateColumns = false;
GridViewHelper.AddColumn(DGX, "MoCode", "生产订单号", 100);
GridViewHelper.AddColumn(DGX, "SortSeq", "行号", 50);
GridViewHelper.AddColumn(DGX, "CardNo", "流转卡号", 90);
GridViewHelper.AddColumn(DGX, "WOCode", "指令单号", 90);
GridViewHelper.AddColumn(DGX, "OpSeq", "工序行号", 70);
GridViewHelper.AddColumn(DGX, "OpName", "工序名称", 90);
GridViewHelper.AddColumn(DGX, "cEQName", "设备名称", 80);
GridViewHelper.AddColumn(DGX, "cInvCode", "存货编码", 90);
GridViewHelper.AddColumn(DGX, "cInvName", "存货名称", 90);
GridViewHelper.AddColumn(DGX, "cInvStd", "规格型号", 90);
GridViewHelper.AddColumn(DGX, "cComUnitName", "单位", 40);
var col = GridViewHelper.AddColumn(DGX, "hgQty", "合格数量", 80);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n2}";
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].DisplayFormat = "{0:n2}";
col = GridViewHelper.AddColumn(DGX, "bhgQty", "不合格数量", 80);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n2}";
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].DisplayFormat = "{0:n2}";
GridViewHelper.AddColumn(DGX, "cWorker", "操作员", 70);
GridViewHelper.AddColumn(DGX, "dRepDate", "报工日期", 90);
GridViewHelper.AddColumn(DGX, "cMemo", "备注", 100);
}
private void InitDGX()
{
DGX.OptionsBehavior.AutoPopulateColumns = false;
GridViewHelper.AddColumn(DGX, "cTVCode", "调拨单号", 100);
GridViewHelper.AddColumn(DGX, "dTVDate", "调拨日期", 80);
GridViewHelper.AddColumn(DGX, "cOWhName", "转出仓库", 90);
GridViewHelper.AddColumn(DGX, "cIWhName", "转入仓库", 90);
GridViewHelper.AddColumn(DGX, "cSource", "源单类型", 90);
GridViewHelper.AddColumn(DGX, "cSourceCode", "源单号", 120);
GridViewHelper.AddColumn(DGX, "cInvCode", "存货编码", 90);
GridViewHelper.AddColumn(DGX, "cInvName", "存货名称", 90);
GridViewHelper.AddColumn(DGX, "cInvStd", "规格型号", 90);
GridViewHelper.AddColumn(DGX, "cComUnitName", "单位", 40);
var col = GridViewHelper.AddColumn(DGX, "iTVQuantity", "调拨数量", 90);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n2}";
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].DisplayFormat = "{0:n2}";
GridViewHelper.AddColumn(DGX, "U8VouchType", "U8单据", 90);
GridViewHelper.AddColumn(DGX, "U8VouchId", "U8单据ID", 90);
GridViewHelper.AddColumn(DGX, "cAuditPsn", "审核人", 70);
GridViewHelper.AddColumn(DGX, "cMaker", "制单人", 70);
GridViewHelper.AddColumn(DGX, "cMemo", "备注", 100);
}
private void InitDGX()
{
DGX.OptionsBehavior.AutoPopulateColumns = false;
GridViewHelper.AddColumn(DGX, "cardNo", "流转卡号", 100);
GridViewHelper.AddColumn(DGX, "OpSeq", "行号", 40);
GridViewHelper.AddColumn(DGX, "bChild", "子件", 40);
GridViewHelper.AddColumn(DGX, "pCardNo", "母件卡号", 90);
GridViewHelper.AddColumn(DGX, "cInvCode", "成品编码", 100);
GridViewHelper.AddColumn(DGX, "cInvName", "成品名称", 100);
GridViewHelper.AddColumn(DGX, "cInvStd", "规格型号", 100);
var col = GridViewHelper.AddColumn(DGX, "iQuantity", "报检数量", 80);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n2}";
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].DisplayFormat = "{0:n2}";
GridViewHelper.AddColumn(DGX, "cComUnitName", "单位", 40);
GridViewHelper.AddColumn(DGX, "cMemo", "备注", 100);
GridViewHelper.AddColumn(DGX, "dRepDate", "报检日期", 80);
GridViewHelper.AddColumn(DGX, "MoCode", "生产订单号", 90);
DGX.OptionsView.ColumnAutoWidth = true;
}
private void InitGridSummary(GridView grid)
{
grid.KeyDown += GridViewHelper.KeyDownCellCopy;
grid.OptionsBehavior.AutoPopulateColumns = false;
var col = GridViewHelper.AddColumn(grid, "cInvCode", "材料编码", 120, readOnly: true);
col.Summary.Add(DevExpress.Data.SummaryItemType.Count);
col.Summary[0].FieldName = "cInvCode";
col.Summary[0].DisplayFormat = "记录数:{0}";
GridViewHelper.AddColumn(grid, "cInvName", "材料名称", 100, readOnly: true);
GridViewHelper.AddColumn(grid, "cInvStd", "规格型号", 100, readOnly: true);
GridViewHelper.AddColumn(grid, "OpName", "工序名称", 80, readOnly: true);
col = GridViewHelper.AddColumn(grid, "iQuantitySum", "汇总数量", 80, readOnly: true);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n3}";
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].FieldName = "iQuantitySum";
col.Summary[0].DisplayFormat = "{0:n3}";
col = GridViewHelper.AddColumn(grid, "iQuantityMerge", "合并数量", 80);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n3}";
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].FieldName = "iQuantityMerge";
col.Summary[0].DisplayFormat = "{0:n3}";
GridViewHelper.AddColumn(grid, "cComUnitName", "单位", 40, readOnly: true);
}
protected virtual void InitGrid()
{
gridView1.OptionsBehavior.AutoPopulateColumns = false;
gridView1.OptionsBehavior.Editable = false;
gridView1.OptionsView.ColumnAutoWidth = false;
gridView1.OptionsView.ShowFooter = true;
gridView1.OptionsSelection.MultiSelect = true;
gridView1.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect;
gridView1.OptionsSelection.CheckBoxSelectorColumnWidth = 50;
var col = GridViewHelper.AddColumn(gridView1, "WOCode", "工单", 120);
col.Summary.Add(DevExpress.Data.SummaryItemType.Count);
col.Summary[0].FieldName = "WOCode";
col.Summary[0].DisplayFormat = "{记录: 0}";
GridViewHelper.AddColumn(gridView1, "cInvCode", "存货编码", 120);
GridViewHelper.AddColumn(gridView1, "cInvName", "存货名称", 120);
GridViewHelper.AddColumn(gridView1, "cInvStd", "规格型号", 120);
GridViewHelper.AddColumn(gridView1, "OpSeq", "工序序号");
GridViewHelper.AddColumn(gridView1, "OpCode", "工序编码");
GridViewHelper.AddColumn(gridView1, "OpName", "工序名称");
GridViewHelper.AddColumn(gridView1, "iQuantity", "数量");
GridViewHelper.AddColumn(gridView1, "cComUnitName", "单位");
GridViewHelper.AddColumn(gridView1, "RepQty", "已报工数量");
GridViewHelper.AddColumn(gridView1, "MoCode", "生产订单号");
GridViewHelper.AddColumn(gridView1, "SortSeq", "订单行号");
}
private void InitDGX()
{
DGX.OptionsBehavior.AutoPopulateColumns = false;
GridViewHelper.AddColumn(DGX, "MCCode", "单据号", 100);
GridViewHelper.AddColumn(DGX, "dDate", "日期", 80);
GridViewHelper.AddColumn(DGX, "cInvCode", "存货编码", 90);
GridViewHelper.AddColumn(DGX, "cInvName", "存货名称", 90);
GridViewHelper.AddColumn(DGX, "cInvStd", "规格型号", 90);
var col = GridViewHelper.AddColumn(DGX, "iQuantity", "汇总数量", 70);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n2}";
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].DisplayFormat = "{0:n2}";
GridViewHelper.AddColumn(DGX, "cComUnitName", "单位", 40);
GridViewHelper.AddColumn(DGX, "cardNo", "流转卡号", 90);
GridViewHelper.AddColumn(DGX, "OpName", "工序名称", 80);
col = GridViewHelper.AddColumn(DGX, "MergeQuantity", "合并", 70);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n2}";
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].DisplayFormat = "{0:n2}";
GridViewHelper.AddColumn(DGX, "cAuditPsn", "审核人", 70);
GridViewHelper.AddColumn(DGX, "cMaker", "制单人", 70);
GridViewHelper.AddColumn(DGX, "cMemo", "备注", 100);
}
private void InitGridCard(GridView grid)
{
grid.KeyDown += GridViewHelper.KeyDownCellCopy;
grid.OptionsBehavior.AutoPopulateColumns = false;
var col = GridViewHelper.AddColumn(grid, "CardNo", "流转卡号", 100, readOnly: true);
col.Summary.Add(DevExpress.Data.SummaryItemType.Count);
col.Summary[0].FieldName = "cInvCode";
col.Summary[0].DisplayFormat = "卡数:{0}";
GridViewHelper.AddColumn(grid, "MoCode", "生产订单号", 90, readOnly: true);
GridViewHelper.AddColumn(grid, "cInvCode", "存货编码", 120, readOnly: true);
GridViewHelper.AddColumn(grid, "cInvName", "存货名称", 120, readOnly: true);
GridViewHelper.AddColumn(grid, "cInvStd", "规格型号", 90, readOnly: true);
GridViewHelper.AddColumn(grid, "curOpSeq", "工序序号", 60, readOnly: true);
GridViewHelper.AddColumn(grid, "curOpName", "工序名称", 80, readOnly: true);
col = GridViewHelper.AddColumn(grid, "iQuantity", "生产数量", 70);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n3}";
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].FieldName = "iQuantity";
col.Summary[0].DisplayFormat = "{0:n3}";
GridViewHelper.AddColumn(grid, "cMemo", "备注", 100, readOnly: true);
}
private void InitGrid(GridView view)
{
view.OptionsBehavior.AutoPopulateColumns = false;
view.OptionsView.ColumnAutoWidth = true;
var col = GridViewHelper.AddColumn(view, "CardNo", "流转卡号", 110);
col.Summary.Add(DevExpress.Data.SummaryItemType.Count);
col.Summary[0].FieldName = "CardNo";
col.Summary[0].DisplayFormat = "记录:{0}";
GridViewHelper.AddColumn(view, "MoCode", "生产订单号", 90);
GridViewHelper.AddColumn(view, "IsMerge", "是否合并", 80);
GridViewHelper.AddColumn(view, "cInvCode", "存货编码", 120);
GridViewHelper.AddColumn(view, "cInvName", "存货名称", 120);
GridViewHelper.AddColumn(view, "cInvStd", "规格型号", 90);
GridViewHelper.AddColumn(view, "OpName", "工序名称", 80);
col = GridViewHelper.AddColumn(view, "iQuantity", "材料数量", 70);
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].FieldName = "iQuantity";
col.Summary[0].DisplayFormat = "{0:n4}";
col = GridViewHelper.AddColumn(view, "iReqQuantity", "合并前数量", 80);
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].FieldName = "iReqQuantity";
col.Summary[0].DisplayFormat = "{0:n4}";
GridViewHelper.AddColumn(view, "cComUnitName", "单位", 40);
}
private void InitGridD(GridView view)
{
view.OptionsBehavior.AutoPopulateColumns = false;
view.OptionsView.ColumnAutoWidth = true;
view.OptionsSelection.MultiSelectMode = GridMultiSelectMode.RowSelect;
var col = GridViewHelper.AddColumn(view, "CardNo", "流转卡号", 120);
col.Summary.Add(DevExpress.Data.SummaryItemType.Count);
col.Summary[0].FieldName = "CardNo";
col.Summary[0].DisplayFormat = "记录:{0}";
GridViewHelper.AddColumn(view, "cInvCode", "存货编码", 120);
GridViewHelper.AddColumn(view, "cInvName", "存货名称", 120);
GridViewHelper.AddColumn(view, "cInvStd", "规格型号", 120);
GridViewHelper.AddColumn(view, "OpName", "工序名称", 80);
col = GridViewHelper.AddColumn(view, "iQuantity", "材料数量", 80);
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].FieldName = "iQuantity";
col.Summary[0].DisplayFormat = "{0:n2}";
GridViewHelper.AddColumn(view, "cComUnitName", "单位", 40);
}
private void InitGridrouter()
{
#region 初始化列
this.GridRouter.OptionsView.AllowCellMerge = false;
GridViewHelper.AddColumn(this.GridRouter, "CardNo", "流转卡号", 110);
GridViewHelper.AddColumn(this.GridRouter, "OpSeq", "行号", 40);
GridViewHelper.AddColumn(this.GridRouter, "OpName", "工序名称", 90);
GridViewHelper.AddColumn(this.GridRouter, "cMemo", "备注", 90);
var col = GridViewHelper.AddColumn(this.GridRouter, "dStartDate", "开工日期", 140);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
col.DisplayFormat.FormatString = "yyyy-MM-dd HH:mm:ss";
GridViewHelper.AddColumn(this.GridRouter, "hgQty", "合格数量", 70);
GridViewHelper.AddColumn(this.GridRouter, "bhgQty", "不合格数量", 80);
GridViewHelper.AddColumn(this.GridRouter, "cWorker", "操作工", 60);
col = GridViewHelper.AddColumn(this.GridRouter, "dRepDate", "报工日期", 140);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
col.DisplayFormat.FormatString = "yyyy-MM-dd HH:mm:ss";
col = GridViewHelper.AddColumn(this.GridRouter, "timeUsed", "工序用时", 60);
col.FieldName = null;
col.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
col.UnboundExpression = "[dRepDate] - [dStartDate]";
GridViewHelper.AddColumn(this.GridRouter, "cRepPsn", "报工人", 60);
#endregion
}
private void InitGrid()
{
#region 初始化列
GridColumn col = GridViewHelper.AddColumn(this.gridView1, "MoCode", "生产订单号", 90);
col.Fixed = FixedStyle.Left;
col.Summary.Add(DevExpress.Data.SummaryItemType.Count);
col.Summary[0].FieldName = "MoCode";
col.Summary[0].DisplayFormat = "记录数:{0}";
GridViewHelper.AddColumn(this.gridView1, "MoTypeName", "生产类别", 90);
GridViewHelper.AddColumn(this.gridView1, "CreateDate", "日期", 90);
GridViewHelper.AddColumn(this.gridView1, "BomType", "类型", 50);
GridViewHelper.AddColumn(this.gridView1, "SortSeq", "行号", 40);
GridViewHelper.AddColumn(this.gridView1, "cInvCode", "存货编码", 150);
GridViewHelper.AddColumn(this.gridView1, "cInvName", "存货名称", 120);
GridViewHelper.AddColumn(this.gridView1, "cInvStd", "规格型号", 120);
GridViewHelper.AddColumn(this.gridView1, "cComUnitName", "单位", 40);
//GridViewHelper.AddColumn(this.gridView1, "Free1", "头标", 80);
col = GridViewHelper.AddColumn(this.gridView1, "Qty", "数量", 90);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.AppearanceCell.ForeColor = Color.Red;
col.DisplayFormat.FormatString = "n3";
var sitem = col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
sitem.FieldName = "Qty";
sitem.DisplayFormat = "{0:n2}";
GridViewHelper.AddColumn(this.gridView1, "SoCode", "订单号", 90);
GridViewHelper.AddColumn(this.gridView1, "Remark", "备注", 150);
#endregion
}
private void InitDGX()
{
DGX.OptionsBehavior.AutoPopulateColumns = false;
GridViewHelper.AddColumn(DGX, "cWhName", "仓库", 100);
GridViewHelper.AddColumn(DGX, "cPosName", "货位", 90);
GridViewHelper.AddColumn(DGX, "cCode", "检验单号", 90);
GridViewHelper.AddColumn(DGX, "dDate", "日期", 80);
GridViewHelper.AddColumn(DGX, "cVenName", "供应商名称", 120);
GridViewHelper.AddColumn(DGX, "cSource", "单据来源", 80);
GridViewHelper.AddColumn(DGX, "cPOID", "采购订单号", 90);
GridViewHelper.AddColumn(DGX, "ivouchrowno", "行号", 40);
GridViewHelper.AddColumn(DGX, "cInvCode", "存货编码", 90);
GridViewHelper.AddColumn(DGX, "cInvName", "存货名称", 90);
GridViewHelper.AddColumn(DGX, "cInvStd", "规格型号", 90);
GridViewHelper.AddColumn(DGX, "cComUnitName", "单位", 40);
var col = GridViewHelper.AddColumn(DGX, "arrQty", "到货数量", 90);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n2}";
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].DisplayFormat = "{0:n2}";
col = GridViewHelper.AddColumn(DGX, "iQuantity", "入库数量", 90);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n2}";
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].DisplayFormat = "{0:n2}";
GridViewHelper.AddColumn(DGX, "cAuditPsn", "审核人", 70);
GridViewHelper.AddColumn(DGX, "cMaker", "制单人", 70);
GridViewHelper.AddColumn(DGX, "cMemo", "备注", 100);
}
private void InitColumns()
{
Grid.OptionsBehavior.AutoPopulateColumns = false;
GridViewHelper.AddColumn(Grid, "bClassDesc", "设备类别", 90);
GridViewHelper.AddColumn(Grid, "cEQCode", "编码", 100);
GridViewHelper.AddColumn(Grid, "cEQName", "名称", 100);
GridViewHelper.AddColumn(Grid, "cEQCName", "设备分类", 100);
GridViewHelper.AddColumn(Grid, "iOrder", "优先级", 60);
Grid.OptionsView.ColumnAutoWidth = true;
}
private void InitGrid()
{
#region 初始化列
//this.GirdCard.OptionsView.AllowCellMerge = true;
var col = GridViewHelper.AddColumn(this.GirdCard, "CardNo", "流转卡号", 120);
col.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
col.Fixed = FixedStyle.Left;
col.Summary.Add(DevExpress.Data.SummaryItemType.Count);
col.Summary[0].FieldName = "CardNo";
col.Summary[0].DisplayFormat = "记录:{0}";
//GridViewHelper.AddColumn(this.GirdCard, "bChild", "子卡", 40);
//GridViewHelper.AddColumn(this.GirdCard, "pCardNo", "母件卡号", 100);
GridViewHelper.AddColumn(this.GirdCard, "bClosedDesc", "关闭", 60, true);
GridViewHelper.AddColumn(this.GirdCard, "bPauseDesc", "暂停", 60, true);
//GridViewHelper.AddColumn(this.GirdCard, "bPause", "暂停", 60, true);
GridViewHelper.AddColumn(this.GirdCard, "WOCode", "指令单号", 120);
GridViewHelper.AddColumn(this.GirdCard, "MoCode", "生产订单号", 100);
GridViewHelper.AddColumn(this.GirdCard, "SortSeq", "行号", 40);
GridViewHelper.AddColumn(this.GirdCard, "cInvCode", "存货编码", 150);
GridViewHelper.AddColumn(this.GirdCard, "cInvName", "存货名称", 120);
GridViewHelper.AddColumn(this.GirdCard, "cInvStd", "规格型号", 120);
col = GridViewHelper.AddColumn(this.GirdCard, "iQuantity", "数量", 80);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n2}";
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].FieldName = "iQuantity";
GridViewHelper.AddColumn(this.GirdCard, "cComUnitName", "单位", 50);
col = GridViewHelper.AddColumn(this.GirdCard, "curOpSeq", "当前工序", 70);
col.AppearanceCell.ForeColor = Color.Blue;
col = GridViewHelper.AddColumn(this.GirdCard, "curOpName", "当前工序名称", 90);
col.AppearanceCell.ForeColor = Color.Blue;
col = GridViewHelper.AddColumn(this.GirdCard, "CompleteDesc", "状态", 70);
col.AppearanceCell.ForeColor = Color.Blue;
GridViewHelper.AddColumn(this.GirdCard, "dCreateDate", "制卡日期", 80);
GridViewHelper.AddColumn(this.GirdCard, "cMaker", "制单人", 80);
GridViewHelper.AddColumn(this.GirdCard, "cCode", "U8入库单号", 90);
GridViewHelper.AddColumn(this.GirdCard, "bMemo", "备注", 60);
#endregion
}
private void InitGrid()
{
#region 初始化列
this.gridView1.OptionsView.AllowCellMerge = false;
GridColumn col = GridViewHelper.AddColumn(this.gridView1, "cInvCode", "存货编码", 180);
col.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
col.Summary.Add(DevExpress.Data.SummaryItemType.Count);
col.Summary[0].FieldName = "cInvCode";
col.Summary[0].DisplayFormat = "记录:{0}";
col = GridViewHelper.AddColumn(this.gridView1, "cInvName", "存货名称", 130);
col.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
col = GridViewHelper.AddColumn(this.gridView1, "cInvStd", "规格型号", 150);
col.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
col = GridViewHelper.AddColumn(this.gridView1, "Free1", "头标", 80);
col.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
col = GridViewHelper.AddColumn(this.gridView1, "dubie", "镀别", 80);
col.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
col = GridViewHelper.AddColumn(this.gridView1, "Description", "工序", 80);
col.AppearanceCell.ForeColor = Color.Blue;
col = GridViewHelper.AddColumn(this.gridView1, "iQuantity", "千件", 100);
col.AppearanceCell.ForeColor = Color.Red;
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "#,##0.000";
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].FieldName = "iQuantity";
col.Summary[0].DisplayFormat = "{0:n3}";
col = GridViewHelper.AddColumn(this.gridView1, "iWeight", "重量", 90);
col.AppearanceCell.ForeColor = Color.Red;
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "#,##0.00";
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].FieldName = "iWeight";
col.Summary[0].DisplayFormat = "{0:n2}";
//GridViewHelper.AddColumn(this.gridView1, "yachang", "牙长", 80);
//GridViewHelper.AddColumn(this.gridView1, "caizhi", "材质", 80);
//GridViewHelper.AddColumn(this.gridView1, "CreateDate", "日期", 80);
//GridViewHelper.AddColumn(this.gridView1, "CreatePsn", "制单人", 80);
//GridViewHelper.AddColumn(this.gridView1, "Remark", "备注", 150);
#endregion
}
private void InitGridView(DevExpress.XtraGrid.Views.Grid.GridView grid)
{
#region 初始化列
grid.OptionsView.AllowCellMerge = false;
var col = GridViewHelper.AddColumn(grid, "WOCode", "指令单号", 100);
col.Fixed = FixedStyle.Left;
col.Summary.Add(DevExpress.Data.SummaryItemType.Count);
col.Summary[0].FieldName = "WOCode";
col.Summary[0].DisplayFormat = "记录数: {0}";
col.OptionsColumn.ReadOnly = false;
GridViewHelper.AddColumn(grid, "MoCode", "生产订单号", 90);
GridViewHelper.AddColumn(grid, "SortSeq", "行号", 40).OptionsColumn.ReadOnly = false;
GridViewHelper.AddColumn(grid, "cInvCode", "存货编码", 120).OptionsColumn.ReadOnly = false;
GridViewHelper.AddColumn(grid, "cInvName", "存货名称", 120).OptionsColumn.ReadOnly = false;
GridViewHelper.AddColumn(grid, "cInvStd", "规格型号", 120).OptionsColumn.ReadOnly = false;
col = GridViewHelper.AddColumn(grid, "iQuantity", "数量", 80);
col.OptionsColumn.ReadOnly = false;
col.AppearanceCell.ForeColor = Color.Blue;
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n2}";
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].FieldName = "iQuantity";
col.Summary[0].DisplayFormat = "{0:n2}";
GridViewHelper.AddColumn(grid, "cComUnitName", "单位", 50).OptionsColumn.ReadOnly = false;;
GridViewHelper.AddColumn(grid, "WGQuantity", "完工数量", 80).OptionsColumn.ReadOnly = false;;
col = GridViewHelper.AddColumn(grid, "NWGQuantity", "未完工数量", 80);
col.OptionsColumn.ReadOnly = false;
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n2}";
col = GridViewHelper.AddColumn(grid, "NPCQty", "未排产数量", 80);
col.OptionsColumn.ReadOnly = false;
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n2}";
GridViewHelper.AddColumn(grid, "MID", "模具ID", 80);
col = GridViewHelper.AddColumn(grid, "cMName", "模具", 80);
col.ColumnEdit = RowButtonEdit1;
GridViewHelper.AddColumn(grid, "StartDate", "开工日期", 80).OptionsColumn.ReadOnly = false;;
GridViewHelper.AddColumn(grid, "DueDate", "完工日期", 80).OptionsColumn.ReadOnly = false;;
grid.OptionsView.ColumnAutoWidth = true;
#endregion
}
private void InitDGX()
{
//DGX.GroupPanelText = "将需要汇总的列拖动到此处";
DGX.Columns.Clear();
DGX.OptionsBehavior.AutoPopulateColumns = false;
DGX.OptionsView.AllowCellMerge = true;
var column = GridViewHelper.AddColumn(DGX, "MoCode", "生产订单", 80);
column.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
column.Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Left;
column = GridViewHelper.AddColumn(DGX, "SortSeq", "行号", 40);
column.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
column.Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Left;
GridViewHelper.AddColumn(DGX, "cInvCode", "存货编码", 100);
GridViewHelper.AddColumn(DGX, "cInvName", "存货名称", 100);
GridViewHelper.AddColumn(DGX, "cInvStd", "规格型号", 100);
column = GridViewHelper.AddColumn(DGX, "Qty", "订单数量", 80);
column.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
column.DisplayFormat.FormatString = "{0:n2}";
column.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
column.Summary[0].DisplayFormat = "{0:n2}";
column.Summary[0].FieldName = "Qty";
GridViewHelper.AddColumn(DGX, "cComUnitName", "单位", 40);
if (dtM == null)
{
return;
}
foreach (DataColumn col in dtM.Columns)
{
if (DGX.Columns.ColumnByFieldName(col.ColumnName) == null)
{
var newcol = GridViewHelper.AddColumn(DGX, col.ColumnName, col.ColumnName, 80);
newcol.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
newcol.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
newcol.DisplayFormat.FormatString = "{0:n2}";
newcol.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
newcol.Summary[0].DisplayFormat = "{0}";
newcol.Summary[0].FieldName = col.ColumnName;
}
}
}
private void InitGrid()
{
GridViewHelper.AddColumn(GridCard, "cardNo", "流转卡号", 100, readOnly: true);
//GridViewHelper.AddColumn(GridCard, "opSeq", "工序序号", 70);
GridViewHelper.AddColumn(GridCard, "OpName", "工序名称", 80, readOnly: true);
GridViewHelper.AddColumn(GridCard, "cInvCode", "存货编码", 120, readOnly: true);
GridViewHelper.AddColumn(GridCard, "cInvName", "存货名称", 100, readOnly: true);
GridViewHelper.AddColumn(GridCard, "cInvStd", "规格型号", 100, readOnly: true);
var col = GridViewHelper.AddColumn(GridCard, "MergeQuantity", "数量", 70);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n2}";
GridViewHelper.AddColumn(GridCard, "cComUnitName", "单位", 50, readOnly: true);
}
private void InitGrid()
{
#region 初始化列
this.gridView1.OptionsView.AllowCellMerge = true;
GridColumn col = GridViewHelper.AddColumn(this.gridView1, "cCode", "单据号", 100);
col.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
col = GridViewHelper.AddColumn(this.gridView1, "dDate", "日期", 80);
col.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
col = GridViewHelper.AddColumn(this.gridView1, "cVenName", "供应商", 120);
col.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
col = GridViewHelper.AddColumn(this.gridView1, "cDepName", "部门", 90);
col.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
col = GridViewHelper.AddColumn(this.gridView1, "cardNo", "流转卡号", 90);
col = GridViewHelper.AddColumn(this.gridView1, "opName", "工序", 80);
col = GridViewHelper.AddColumn(this.gridView1, "cInvCode", "存货编码", 150);
col = GridViewHelper.AddColumn(this.gridView1, "cInvName", "存货名称", 120);
col = GridViewHelper.AddColumn(this.gridView1, "cInvStd", "规格型号", 120);
col = GridViewHelper.AddColumn(this.gridView1, "cFree1", "头标", 80);
col = GridViewHelper.AddColumn(this.gridView1, "dubie", "镀别", 80);
col = GridViewHelper.AddColumn(this.gridView1, "iWeight", "重量", 80);
col.AppearanceCell.ForeColor = Color.Red;
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "#,##0.00";
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].FieldName = "iWeight";
col.Summary[0].DisplayFormat = "{0:n2}";
col = GridViewHelper.AddColumn(this.gridView1, "iQuantity", "千件", 80);
col.AppearanceCell.ForeColor = Color.Red;
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "#,##0.00";
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].FieldName = "iQuantity";
col.Summary[0].DisplayFormat = "{0:n2}";
GridViewHelper.AddColumn(this.gridView1, "cMaker", "制单人", 80);
//GridViewHelper.AddColumn(this.gridView1, "Remark", "备注", 150);
#endregion
}
private void InitDGX()
{
DGX.OptionsBehavior.AutoPopulateColumns = false;
GridViewHelper.AddColumn(DGX, "cPOID", "采购订单号", 90);
GridViewHelper.AddColumn(DGX, "ivouchrowno", "行号", 40);
GridViewHelper.AddColumn(DGX, "dPODate", "日期", 80);
GridViewHelper.AddColumn(DGX, "cVenName", "供应商名称", 120);
GridViewHelper.AddColumn(DGX, "cAuditDate", "审核日期", 80);
GridViewHelper.AddColumn(DGX, "cInvCode", "存货编码", 90);
GridViewHelper.AddColumn(DGX, "cInvName", "存货名称", 90);
GridViewHelper.AddColumn(DGX, "cInvStd", "规格型号", 90);
var col = GridViewHelper.AddColumn(DGX, "iQuantity", "数量", 90);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n2}";
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].DisplayFormat = "{0:n2}";
GridViewHelper.AddColumn(DGX, "cComUnitName", "单位", 40);
col = GridViewHelper.AddColumn(DGX, "iTaxPrice", "单价", 80);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n2}";
col = GridViewHelper.AddColumn(DGX, "iSum", "价税合计", 90);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n2}";
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].DisplayFormat = "{0:n2}";
col = GridViewHelper.AddColumn(DGX, "arrQty", "到货数量", 90);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n2}";
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].DisplayFormat = "{0:n2}";
col = GridViewHelper.AddColumn(DGX, "iReceivedQTY", "U8累计入库", 90);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n2}";
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].DisplayFormat = "{0:n2}";
GridViewHelper.AddColumn(DGX, "cMaker", "制单人", 70);
}
private void InitGrid(GridView Grid)
{
Grid.OptionsBehavior.AutoPopulateColumns = false;
Grid.OptionsSelection.MultiSelectMode = GridMultiSelectMode.RowSelect;
GridViewHelper.AddColumn(Grid, "FileName", "文件名称", readOnly: true);
GridViewHelper.AddColumn(Grid, "FileExt", "类型", readOnly: true);
var col = GridViewHelper.AddColumn(Grid, "FileSize", "文件大小", readOnly: true);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n2} KB";
col = GridViewHelper.AddColumn(Grid, "FileMdyDate", "修改日期", readOnly: true);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
col.DisplayFormat.FormatString = "yyyy-MM-dd hh:mm:ss";
}
//===========================================================
private void InitGridView()
{
gridView1.OptionsBehavior.AutoPopulateColumns = false;
var column = GridViewHelper.AddColumn(this.gridView1, "CardNo", "流转卡号");
column.Summary.Add(DevExpress.Data.SummaryItemType.Count);
column.Summary[0].FieldName = "CardNo";
column.Summary[0].DisplayFormat = "{卡数:0}";
GridViewHelper.AddColumn(this.gridView1, "cInvCode", "存货编码", 120);
GridViewHelper.AddColumn(this.gridView1, "cInvName", "存货名称", 100);
GridViewHelper.AddColumn(this.gridView1, "cInvStd", "规格型号", 100);
GridViewHelper.AddColumn(this.gridView1, "OpName", "工序名称");
GridViewHelper.AddColumn(this.gridView1, "iQuantity", "数量", 70);
GridViewHelper.AddColumn(this.gridView1, "cComUnitName", "单位", 50);
GridViewHelper.AddColumn(this.gridView1, "remark", "备注", 100);
}
private void InitGridRouter()
{
#region 初始化工艺列
var col = GridViewHelper.AddColumn(this.gridRouter, "cInvCode", "存货编码", 130);
col.Summary.Add(DevExpress.Data.SummaryItemType.Count);
col.Summary[0].FieldName = "cInvCode";
col.Summary[0].DisplayFormat = "记录:{0}";
GridViewHelper.AddColumn(this.gridRouter, "OpSeq", "序号", 60);
GridViewHelper.AddColumn(this.gridRouter, "OpName", "工序名称", 80);
GridViewHelper.AddColumn(this.gridRouter, "cEQName", "设备名称", 90);
GridViewHelper.AddColumn(this.gridRouter, "CycleTime", "节拍", 80);
GridViewHelper.AddColumn(this.gridRouter, "bQuality", "是否质检", 70);
GridViewHelper.AddColumn(this.gridRouter, "cMemo", "备注", 80);
gridRouter.OptionsView.ColumnAutoWidth = true;
#endregion
}
private void InitGridDetail()
{
#region 初始化列
this.GridDetail.OptionsView.AllowCellMerge = false;
//autoid = GridViewHelper.AddColumn(this.GridDetail, "CardNo", "流转卡号", 110);
GridViewHelper.AddColumn(this.GridDetail, "OpName", "工序名称", 90);
GridViewHelper.AddColumn(this.GridDetail, "cInvCode", "材料编码", 100);
GridViewHelper.AddColumn(this.GridDetail, "cInvName", "名称", 100);
GridViewHelper.AddColumn(this.GridDetail, "cInvStd", "规格", 100);
var col = GridViewHelper.AddColumn(this.GridDetail, "iQuantity", "数量", 70);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n3}";
GridViewHelper.AddColumn(this.GridDetail, "cComUnitName", "单位", 40);
#endregion
}
private void InitDGX()
{
DGX.OptionsBehavior.AutoPopulateColumns = false;
DGX.OptionsBehavior.ReadOnly = true;
DGX.OptionsBehavior.Editable = false;
GridViewHelper.AddColumn(DGX, "MPCode", "拣货单号", 100);
GridViewHelper.AddColumn(DGX, "dDate", "日期", 80);
GridViewHelper.AddColumn(DGX, "cWhName", "仓库", 90);
GridViewHelper.AddColumn(DGX, "MoCode", "生产订单号", 100);
GridViewHelper.AddColumn(DGX, "SortSeq", "订单行号", 60);
GridViewHelper.AddColumn(DGX, "cardNo", "流转卡号", 110);
GridViewHelper.AddColumn(DGX, "pInvCode", "母件编码", 100);
GridViewHelper.AddColumn(DGX, "pInvName", "母件名称", 120);
var col = GridViewHelper.AddColumn(DGX, "cardQty", "数量", 70);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n2}";
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].DisplayFormat = "{0:n2}";
GridViewHelper.AddColumn(DGX, "OpSeq", "工序号", 60);
GridViewHelper.AddColumn(DGX, "OpName", "工序名称", 80);
GridViewHelper.AddColumn(DGX, "cInvCode", "材料编码", 90);
GridViewHelper.AddColumn(DGX, "cInvName", "材料名称", 120);
GridViewHelper.AddColumn(DGX, "cInvStd", "材料规格", 70);
col = GridViewHelper.AddColumn(DGX, "iQuantity", "材料数量", 90);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n4}";
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].DisplayFormat = "{0:n4}";
GridViewHelper.AddColumn(DGX, "cComUnitName", "单位", 40);
GridViewHelper.AddColumn(DGX, "cAuditPsn", "审核人", 70);
GridViewHelper.AddColumn(DGX, "cMaker", "制单人", 70);
GridViewHelper.AddColumn(DGX, "cMemo", "备注", 100);
GridViewHelper.AddColumn(DGX, "U8RdCode", "U8单据号", 90);
}
private void InitDGX()
{
DGX.OptionsBehavior.AutoPopulateColumns = false;
GridViewHelper.AddColumn(DGX, "QMCode", "报检单号", 100);
GridViewHelper.AddColumn(DGX, "bQualify", "是否检验", 60);
GridViewHelper.AddColumn(DGX, "dDate", "日期", 80);
GridViewHelper.AddColumn(DGX, "cVenName", "供应商名称", 120);
GridViewHelper.AddColumn(DGX, "cPOID", "采购订单号", 90);
GridViewHelper.AddColumn(DGX, "ivouchrowno", "行号", 40);
GridViewHelper.AddColumn(DGX, "cPosCode", "货位编码", 70);
GridViewHelper.AddColumn(DGX, "cPosName", "货位名称", 90);
GridViewHelper.AddColumn(DGX, "cInvCode", "存货编码", 90);
GridViewHelper.AddColumn(DGX, "cInvName", "存货名称", 90);
GridViewHelper.AddColumn(DGX, "cInvStd", "规格型号", 90);
GridViewHelper.AddColumn(DGX, "cComUnitName", "单位", 40);
var col = GridViewHelper.AddColumn(DGX, "iQuantity", "订单数量", 90);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n2}";
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].DisplayFormat = "{0:n2}";
col = GridViewHelper.AddColumn(DGX, "arrQty", "到货数量", 90);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n2}";
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].DisplayFormat = "{0:n2}";
col = GridViewHelper.AddColumn(DGX, "qmQty", "报检数量", 80);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n2}";
col.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
col.Summary[0].DisplayFormat = "{0:n2}";
GridViewHelper.AddColumn(DGX, "U8RDCode", "U8入库单号", 80);
GridViewHelper.AddColumn(DGX, "cMaker", "制单人", 70);
GridViewHelper.AddColumn(DGX, "cMemo", "备注", 100);
}
private void InitDGX()
{
//DGX.GroupPanelText = "将需要汇总的列拖动到此处";
DGX.Columns.Clear();
DGX.OptionsBehavior.AutoPopulateColumns = false;
DGX.OptionsView.AllowCellMerge = true;
var column = GridViewHelper.AddColumn(DGX, "cEQCode", "设备编码", 80);
column.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
column.Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Left;
column = GridViewHelper.AddColumn(DGX, "cEQName", "设备名称", 90);
column.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
column.Fixed = DevExpress.XtraGrid.Columns.FixedStyle.Left;
GridViewHelper.AddColumn(DGX, "EQId", "EQId", 40).Visible = false;
if (dtM == null)
{
return;
}
foreach (DataColumn col in dtM.Columns)
{
if (DGX.Columns.ColumnByFieldName(col.ColumnName) == null)
{
var newcol = GridViewHelper.AddColumn(DGX, col.ColumnName, col.ColumnName, 80);
newcol.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
newcol.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
newcol.DisplayFormat.FormatString = "{0:n0}";
//newcol.Summary.Add(DevExpress.Data.SummaryItemType.Sum);
//newcol.Summary[0].DisplayFormat = "{0}";
//newcol.Summary[0].FieldName = col.ColumnName;
}
}
}
private void InitGridView()
{
gridView1.Columns.Clear();
gridView1.OptionsBehavior.AutoPopulateColumns = false;
var column = GridViewHelper.AddColumn(this.gridView1, "cPosCode", "货位编码", 70);
column.Summary.Add(DevExpress.Data.SummaryItemType.Count);
column.Summary[0].FieldName = "cPosCode";
column.Summary[0].DisplayFormat = "{记录:0}";
GridViewHelper.AddColumn(this.gridView1, "cPosName", "货位名称", 80, readOnly: true);
GridViewHelper.AddColumn(this.gridView1, "cardNo", "流转卡号", readOnly: true);
GridViewHelper.AddColumn(this.gridView1, "OpSeq", "工序序号", 70, readOnly: true);
GridViewHelper.AddColumn(this.gridView1, "OpName", "工序名称", 80, readOnly: true);
GridViewHelper.AddColumn(this.gridView1, "cInvCode", "存货编码", 120, readOnly: true);
GridViewHelper.AddColumn(this.gridView1, "cInvName", "存货名称", 100, readOnly: true);
GridViewHelper.AddColumn(this.gridView1, "cInvStd", "规格型号", 100, readOnly: true);
GridViewHelper.AddColumn(this.gridView1, "iQuantity", "数量", 80);
GridViewHelper.AddColumn(this.gridView1, "cComUnitName", "单位", 50, readOnly: true);
}
private void InitGrid(GridView grid)
{
grid.KeyDown += GridViewHelper.KeyDownCellCopy;
grid.OptionsBehavior.AutoPopulateColumns = false;
//GridViewHelper.AddColumn(grid, "MergeGuid", "MergeGuid", 120, readOnly: true);
GridViewHelper.AddColumn(grid, "OpSeq", "工序号", 60, readOnly: true);
GridViewHelper.AddColumn(grid, "OpName", "工序名称", 80, readOnly: true);
var col = GridViewHelper.AddColumn(grid, "hgQty", "合格数量", 80, readOnly: true);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n3}";
col = GridViewHelper.AddColumn(grid, "bhgQty", "不合格数量", 80, readOnly: true);
col.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
col.DisplayFormat.FormatString = "{0:n3}";
GridViewHelper.AddColumn(grid, "cWorker", "操作工", 60, readOnly: true);
GridViewHelper.AddColumn(grid, "dRepDate", "报工日期", 80, readOnly: true);
GridViewHelper.AddColumn(grid, "dRepPsn", "报工人", 60, readOnly: true);
}
private void InitGridView()
{
gridView1.Columns.Clear();
gridView1.KeyDown += GridViewHelper.KeyDownCellCopy;
gridView1.OptionsBehavior.AutoPopulateColumns = false;
//var column = GridViewHelper.AddColumn(this.gridView1, "cWhCode", "仓库名称", 70);
//column.Summary.Add(DevExpress.Data.SummaryItemType.Count);
//column.Summary[0].FieldName = "cWhCode";
//column.Summary[0].DisplayFormat = "{记录:0}";
//column.ColumnEdit = this.cWhItemButtonEdit;
//GridViewHelper.AddColumn(this.gridView1, "cWhName", "仓库名称", 90, readOnly: true);
var column = GridViewHelper.AddColumn(this.gridView1, "cPosCode", "货位编码", 70);
column.ColumnEdit = this.cPositionButtonEdit;
column.Summary.Add(DevExpress.Data.SummaryItemType.Count);
column.Summary[0].FieldName = "cPosCode";
column.Summary[0].DisplayFormat = "记录:{0}";
GridViewHelper.AddColumn(this.gridView1, "cPosName", "货位名称", 80, readOnly: true);
GridViewHelper.AddColumn(this.gridView1, "cardNo", "流转卡号", readOnly: true);
GridViewHelper.AddColumn(this.gridView1, "OpSeq", "工序序号", 70, readOnly: true);
GridViewHelper.AddColumn(this.gridView1, "OpName", "工序名称", 80, readOnly: true);
GridViewHelper.AddColumn(this.gridView1, "cInvCode", "存货编码", 120, readOnly: true);
GridViewHelper.AddColumn(this.gridView1, "cInvName", "存货名称", 100, readOnly: true);
GridViewHelper.AddColumn(this.gridView1, "cInvStd", "规格型号", 100, readOnly: true);
GridViewHelper.AddColumn(this.gridView1, "iQuantity", "数量", 80);
GridViewHelper.AddColumn(this.gridView1, "cComUnitName", "单位", 50, readOnly: true);
GridViewHelper.AddColumn(this.gridView1, "AuditPsn", "审核人", 60, readOnly: true);
GridViewHelper.AddColumn(this.gridView1, "AuditDate", "审核日期", 80, readOnly: true);
GridViewHelper.AddColumn(this.gridView1, "cCode", "U8出库单号", 90, readOnly: true);
}
