前台点击排序,向后台发送,排序的字段,排序类型,
怎么用EF动态查询
这是原来的,要加上动态排序
list = list.OrderBy(a=>a.ID).Skip((Convert.ToInt32(page) - 1) * Convert.ToInt32(rows)).Take(Convert.ToInt32(rows)).ToList();
public JsonResult GetSelect(int? page, int? rows, string sort, string order)
{
page = page == null ? 1 : page;
rows = rows == null ? 1 : rows;
sort = sort == null ? "ID" : sort;
order = order == null ? "asc" : order;
List<Tbl_A> list=db.Tbl_A.select(a=>a).ToList();
int listCount = list.Count();
list = list.OrderBy(a=>a.ID).Skip((Convert.ToInt32(page) - 1) * Convert.ToInt32(rows)).Take(Convert.ToInt32(rows)).ToList();
var json = new
{
total = listCount,
rows = list.Select(a => a)
};
return Json(json, JsonRequestBehavior.AllowGet);
}