欢迎使用普元产品知识库，本知识库包含普元应用开发平台EOSPlatform，流程平台BPS，企业服务总线ESB，微服务平台Microservice，运维管理平台Devops，数据集成平台DI
欢迎使用普元文档库
【问题描述】
采用datagrid进行表格数据展示时，想针对某一列进行数据统计，如图所示：
【解决方案】
参考代码如下
<div id="datagrid1" class="nui-datagrid" style="width:800px;height:280px;"
idField="id" allowCellEdit="true" allowCellSelect="true" showFooter="false"
url="../data/grid2.txt"
ondrawcell="onDrawCell" oncellcommitedit="onCellCommitEdit"
showSummaryRow="true" ondrawsummarycell="onDrawSummaryCell"
>
function onDrawSummaryCell(e) {
var result = e.result;
var grid = e.sender;
var rows = e.data;
if (e.field == "total") {
var total = 0;
for (var i = 0, l = rows.length; i < l; i++) {
var row = rows[i];
var t = row.price * row.quantity;
if (isNaN(t)) continue;
total += t;
}
e.cellHtml = "总计: " + total;
}
}
var result = e.result;
var grid = e.sender;
var rows = e.data;
if (e.field == "total") {
var total = 0;
for (var i = 0, l = rows.length; i < l; i++) {
var row = rows[i];
var t = row.price * row.quantity;
if (isNaN(t)) continue;
total += t;
}
e.cellHtml = "总计: " + total;
}
}
概览
内容工具