且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

Jtable分页和排序不会到来

更新时间:2023-12-04 18:42:22

' #PersonTableContainer')。jtable({
title :' 人员表
分页: true
pageSize: 5
排序: true
defaultSorting:' 名称ASC',
操作:{
listAction:' / Account / AdminList';,

updateAction:' /帐户/ UpdateAdmin'
('#PersonTableContainer').jtable({ title: 'Table of people', paging: true, pageSize: 5, sorting: true, defaultSorting: 'Name ASC', actions: { listAction: '/Account/AdminList';, updateAction: '/Account/UpdateAdmin',





这样的控制器代码



#region jTable

[HttpPost]

public JsonResult AdminList(int jtStartIndex = 0,int jtPageSize = 0,string jtSorting = null)

{

尝试

{

//从数据库获取数据

int count = new GETEvaluationPortalEntities( ).Users.Count();

IList用户> admins = new GETEvaluationPortalEntities()。Users.ToList();



//将结果返回给jTable

返回Json(new {Result = OK,Records = admins,TotalRecordCount = count});

}

catch(Exception ex)

{

返回Json(new {Result =ERROR,Message = ex.Message});

}

}



Controller code like that

#region jTable
[HttpPost]
public JsonResult AdminList(int jtStartIndex = 0,int jtPageSize = 0, string jtSorting = null)
{
try
{
//Get data from database
int count = new GETEvaluationPortalEntities().Users.Count();
IList User> admins = new GETEvaluationPortalEntities().Users.ToList();

//Return result to jTable
return Json(new { Result = "OK", Records = admins, TotalRecordCount = count });
}
catch (Exception ex)
{
return Json(new { Result = "ERROR", Message = ex.Message });
}
}