public ActionResult ListOnPage()
{
//return Json("", JsonRequestBehavior.AllowGet);
var result = new DataTableJsonResult();
//取参数值
int draw, pageIndex, pageSize, totalCount;
string sortColumn;
bool isDesc;
Request.GetDatatableParameters(out draw, out pageIndex, out pageSize, out sortColumn, out isDesc);
result.draw = draw;
//取查询条件
var name = Request.Get("extra_search[Name]");
var checkName = string.IsNullOrWhiteSpace(name);
Expression <Func <Models.ShippingArea, bool> > expression =
l => ((checkName || l.Name.Equals(name)) &&
(int)l.Status > (int)ShippingAreaStatus.Delete);
Expression <Func <Models.ShippingArea, object> > orderByExpression;
//设置排序
switch (sortColumn)
{
default:
orderByExpression = act => new { act.CreateTime };
break;
}
//分页查询
var list = _shippingAreaService.GetListPaged(pageIndex, pageSize, expression, orderByExpression,
isDesc, out totalCount);
result.data = list;
result.recordsTotal = totalCount;
result.recordsFiltered = totalCount;
return(Json(result, JsonRequestBehavior.AllowGet));
}
