Infragistics4框架UGrid控件，数据列增加汇总功能

Infragistics4框架UGrid汇总

程序人生lwp

832人浏览 · 2024-01-03 16:18:13

程序人生lwp · 2024-01-03 16:18:13 发布

1.实现效果
在这里插入图片描述
2.现实方法，在初始化Ugrid列头的加下如下代码

GridHeaders heads = new GridHeaders();
        heads.AddGridColumn("CHECK", "", 30, Infragistics.Win.HAlign.Left, false);
        heads.AddGridColumn("ROWNUM", "行号", 40, Infragistics.Win.HAlign.Left, true, CellClickAction.CellSelect);
        heads.AddGridColumn("OPERATE1", "操作", 60, Infragistics.Win.HAlign.Left, true, CellClickAction.CellSelect);
        heads.AddGridColumn("VCMINVCODE", "机种", 80, Infragistics.Win.HAlign.Left, true, CellClickAction.CellSelect);
        heads.AddGridColumn("VCBATNO", "流水号", 100, Infragistics.Win.HAlign.Left, true, CellClickAction.CellSelect);
        heads.AddGridColumn("VCINVCODE", "物料代码", 60, Infragistics.Win.HAlign.Left, true, CellClickAction.CellSelect);
        heads.AddGridColumn("NVINVNAME", "物料名称", 80, Infragistics.Win.HAlign.Left, true, CellClickAction.CellSelect);
        heads.AddGridColumn("CREATEDBY", "创建人", 60, Infragistics.Win.HAlign.Left, true, CellClickAction.CellSelect);
        heads.AddGridColumn("CREATED", "创建时间", 130, Infragistics.Win.HAlign.Left, true, CellClickAction.CellSelect);
        heads.AddGridColumn("NVOPERATOR", "审核人", 60, Infragistics.Win.HAlign.Left, true, CellClickAction.CellSelect);
        heads.AddGridColumn("DTOPERATEDATE", "审核时间", 130, Infragistics.Win.HAlign.Left, true, CellClickAction.CellSelect);
        heads.AddGridColumn("CHFLAG", "单据状态", 70, Infragistics.Win.HAlign.Left, true, CellClickAction.CellSelect);
        heads.AddGridColumn("VCPROCESSID", "不良发出工序ID", 60, Infragistics.Win.HAlign.Left, true, CellClickAction.CellSelect);
        heads.AddGridColumn("NVPROCESSNAME", "不良发出工序", 80, Infragistics.Win.HAlign.Left, true, CellClickAction.CellSelect);
        heads.AddGridColumn("VCAPROCESSID", "接收工序ID", 60, Infragistics.Win.HAlign.Left, true, CellClickAction.CellSelect);
        heads.AddGridColumn("NVAPROCESSNAME", "接收工序", 80, Infragistics.Win.HAlign.Left, true, CellClickAction.CellSelect);
        heads.AddGridColumn("DCTQTY", "不良发出数", 50, Infragistics.Win.HAlign.Left, true, CellClickAction.CellSelect);
        heads.AddGridColumn("DCSQTY", "转良品数", 50, Infragistics.Win.HAlign.Left, true, CellClickAction.CellSelect);
        heads.AddGridColumn("NVFROMVOUCHERID", "工单号", 100, Infragistics.Win.HAlign.Left, true, CellClickAction.CellSelect);
        heads.AddGridColumn("NVVOUCHERID", "单据编号", 100, Infragistics.Win.HAlign.Left, true, CellClickAction.CellSelect);
        heads.AddGridColumn("NVOPERATETYPE", "操作类型", 80, Infragistics.Win.HAlign.Left, true, CellClickAction.CellSelect);
        heads.AddGridColumn("NVREMARK", "备注", 120, Infragistics.Win.HAlign.Left, true, CellClickAction.CellSelect);
        grdLot.SetColumns(heads);
        grdLot.DisplayLayout.Bands[0].Summaries.Add(SummaryType.Sum, null, grdLot.DisplayLayout.Bands[0].Columns["DCTQTY"], SummaryPosition.UseSummaryPositionColumn, grdLot.DisplayLayout.Bands[0].Columns["DCTQTY"]).DisplayFormat = "{0}";//汇总不良发出数
        grdLot.DisplayLayout.Bands[0].Summaries.Add(SummaryType.Sum, null, grdLot.DisplayLayout.Bands[0].Columns["DCSQTY"], SummaryPosition.UseSummaryPositionColumn, grdLot.DisplayLayout.Bands[0].Columns["DCSQTY"]).DisplayFormat = "{0}";//汇总转良数

AI Agent技术社区

Agent 垂直技术社区，欢迎活跃、内容共建。

更多推荐

（已解决）安装openclaw龙虾[特殊字符]npm权限问题EACCES

先安装升级完成node和homebrew后。安装就很快了。但是遇到EACCESS问题！！！发现报错了。问题错误：核心问题是sharp解决（90%人遇到的）安装 macOS 编译工具很多人缺少，导致sharp无法编译。运行：xcode-select --install安装完成后重新执行：sharp编译需要 C++ 编译器和 node-gyp，这些都来自 Xcode CLI。