$("#dd").datagrid({
rownumbers:false,
singleSelect:true,
loadMsg : '数据装载中......',
autoRowHeight:false,
pagination:true,
fitColumns:true,
striped:true,
checkOnSelect:false,
showFooter: true,
selectOnCheck:false,
collapsible:true,
toolbar:'#td',
columns : [ [
{
field : 'field1',
title : '运单号',
width:150
},
{
field : 'field2',
title : '站点名称',
width:150
},
{
field : 'field3',
title : '派件员',
width:150
},{
field : 'field4',
title : '合计1',
width:150
},{
field : 'field5',
title : '合计2',
width:150
}]],
onLoadSuccess : function(data) {
$(this).datagrid('resize');
$('#dd').datagrid('reloadFooter',[{field1: '合计',field4:compute("field4"),field5:compute("field4"),field5:compute("field5")}]);
}
})
showFooter一定要设置为 true compute 为计算方法
function compute(colName){
var rows = $('#dd').datagrid('getRows');
var total = 0;
for (var i = 0; i < rows.length; i++) {
if(rows[i][colName]!=null&&rows[i][colName]!=""){
total += parseFloat(rows[i][colName]);
}
}
return total;
}