//表格合计
function GridSum(grid) {
var suma = 0;
var sumb = 0;
var sumc = 0;
var sumd = 0;
var sume = 0;
var mula = 0;
var mulb = 0;
var mulc = 0;
var muld = 0;
var qz = 1;
for (var i = 0; i < 20; i++) {
var record = store2.getAt(i);
suma = Number(record.data.kbsla);
sumb = Number(record.data.kbslb);
sumc = Number(record.data.kbslc);
sumd = Number(record.data.qz);
sume = Number(record.data.gjdx);
mula += suma * sumd;
mulb += sumb * sumd;
mulc += sumc * sumd;
muld += sume * sumd;
}
var n = grid.getStore().getCount();// 获得总行数
var p = new Ext.data.Record({
item: '综合',
kbsla: Ext.util.Format.number(parseFloat(mula), '00.00'),
kbslb: Ext.util.Format.number(parseFloat(mulb), '00.00'),
kbslc: Ext.util.Format.number(parseFloat(mulc), '00.00'),
gjdx: Ext.util.Format.number(parseFloat(muld), '00.00'),
qz: qz
});
if (n > 20) {
var record = store2.getAt(20);
store2.remove(record);
grid2.store.insert(20, p);
} else {
grid.store.insert(20, p);
}
}
EXTJS 表格合计栏(包括可编辑表格的自动更新)
最新推荐文章于 2017-11-15 19:29:00 发布