js
function getLogByWhere() {
$('#example').DataTable({
"ajax": "LogMana.ashx?Method=getLogByWhere",
"processing": true,
"serverSide": true,
columns: [
{ title: "序号" },
{ title: "用户名" },
{ title: "操作描述" },
{ title: "操作类型" },
{ title: "操作时间" }
]
});
}
后台
StringBuilder dthtm = new StringBuilder();
DataTable dt = new DataTable();
int pageindex = Request["draw"].ConvertToInt();
int pagestart = Request["start"].ConvertToInt();
int pagecount = Request["length"].ConvertToInt();
int lotCount = aulog.getLogCount();
string where = Request["search[value]"].ConvertToString();
dt = aulog.getLogByWhere(where, pagestart, pagecount);
dthtm.Append("{\"draw\": " + pageindex + ",\"recordsTotal\": " + lotCount + ",\"recordsFiltered\": " + lotCount + ",");
dthtm.Append("\"data\": [");
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
dthtm.Append("[\"" + dt.Rows[i][0] + "\",\"" + dt.Rows[i][1] + "\",\"" + dt.Rows[i][2] + "\",\"" + dt.Rows[i][3] + "\",\"" + dt.Rows[i][4] + "\"],");
}
dthtm.Remove(dthtm.Length - 1, 1);
}
dthtm.Append("]}");
Response.Write(dthtm);
}