更新时间: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 });
}
}