예제 #1
0
        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);
        }
예제 #2
0
        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);
        }
예제 #3
0
        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;
        }
예제 #4
0
        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);
        }
예제 #5
0
        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", "订单行号");
        }
예제 #6
0
        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);
        }
예제 #7
0
        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);
        }
예제 #8
0
        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);
        }
예제 #9
0
        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);
        }
예제 #10
0
        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
        }
예제 #11
0
        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
        }
예제 #12
0
        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);
        }
예제 #13
0
        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;
        }
예제 #14
0
        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
        }
예제 #15
0
        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
        }
예제 #16
0
        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
        }
예제 #17
0
        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;
                }
            }
        }
예제 #18
0
        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);
        }
예제 #19
0
        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
        }
예제 #20
0
        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);
        }
예제 #21
0
        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";
        }
예제 #22
0
        //===========================================================

        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);
        }
예제 #23
0
        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
        }
예제 #24
0
        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
        }
예제 #25
0
        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);
        }
예제 #26
0
        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);
        }
예제 #27
0
        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;
                }
            }
        }
예제 #28
0
        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);
        }
예제 #29
0
        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);
        }
예제 #30
0
        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);
        }