在Action中,对数据进行统计后,传入datatalbe:
JsonResult jrReturn = Json(new
{
sEcho = param.sEcho,
iDisplayStart = param.iDisplayStart,
iTotalRecords = recordCount,
iTotalDisplayRecords = recordCount,
aaData = result,
iOrderCount = orderCount,
iUserCount = userCount,
sTotalMoney = String.Format("{0:C0}", totalMoney)
}, JsonRequestBehavior.AllowGet);
其中:iOrderCount, iUserCount, sTotalMoney为自定义json对象;
在前端,触发 datatable 的xhr.dt 事件, 即可在前端显示统计字段的值。
// Note no return - manipulate the data directly in the JSON object.
$(".tab1").on('xhr.dt', function (e, settings, json) {$("#spnOrderCnt").text(json.iOrderCount);
$("#spnUserCnt").text(json.iUserCount);
$("#spntotal").text(json.sTotalMoney);
});