- 注册时间
- 2017-7-4
- 最后登录
- 1970-1-1
- 阅读权限
- 10
- 积分
- 107
- 精华
- 0
- 帖子
- 0

|
felt 发表于 2017-9-27 15:54 
你说的是合计行吧,可以在ondrawsummarycell事件里处理
grid.on("drawsummarycell",function(e){
if ... - function onDrawSummaryCell(e) {//累加求和
- var result = e.result;
- var rows = e.data;
- if (e.field == "Qty") {
- e.cellStyle = "text-align:left";
- var total = 0;
- var obj = {};
- var obj1 = null;//丢件
- var obj2 = null;//退件
- for (var i = 0, l = rows.length; i < l; i++) {
- var row = rows[i];
- if (!obj[row.CodeId]) {
- obj[row.CodeId] = {};
- obj[row.CodeId].sum = 0;
- obj[row.CodeId].pn = row.ProName;
- }
- var t = parseFloat(row.Qty);
- if (isNaN(t)) continue;
- obj[row.CodeId].sum += t;
- total += t;
- if (row['Type'] == "1") {
- obj1 = obj1 || {};
- if (!obj1[row.CodeId]) {
- obj1[row.CodeId] = {};
- obj1[row.CodeId].sum = 0;
- obj1[row.CodeId].pn = row.ProName;
- }
- obj1[row.CodeId].sum += t;
- }
- else if (row['Type'] == "2") {
- obj2 = obj2 || {};
- if (!obj2[row.CodeId]) {
- obj2[row.CodeId] = {};
- obj2[row.CodeId].sum = 0;
- obj2[row.CodeId].pn = row.ProName;
- }
- obj2[row.CodeId].sum += t;
- }
- }
- e.sender.sumObj = obj;
- e.sender.sumObjLose = obj1;
- e.sender.sumObjReturn = obj2;
- e.cellHtml = '';
- window.last = e.sender;
- if (obj1 !== null) {
- e.cellHtml += ' 丢件:';
- for (var pr in obj1) {
- e.cellHtml += ' ' + obj1[pr].pn + ":" + obj1[pr].sum;
- }
- }
- if (obj2 !== null) {
- e.cellHtml += ' 掉件:';
- for (var pr in obj2) {
- e.cellHtml += ' ' + obj2[pr].pn + ":" + obj2[pr].sum;
- }
- }
- if (obj2 != null || obj1 != null)
- e.cellHtml += ' 总计:';
- for (var pr in obj) {
- e.cellHtml += ' ' + obj[pr].pn + ":" + obj[pr].sum;
- }
- }
- }
复制代码 出来的效果还是这个样子的
|
|