首页 > 代码库 > datagrid展示数据(带分页、排序)
datagrid展示数据(带分页、排序)
1.view 代码:
<div style="width:100%;height:100%;">
<table class="easyui-datagrid" style="width:100%;height:95%" data-options="singleSelect:true,url:‘@Url.Action("GetList")‘,method:‘get‘,toolbar:toolbar" pagination="true" sortname="Id" sortorder="asc">
<thead>
<tr>
<th style="width:10%" data-options="field:‘Id‘" sortable="true">编号</th>
<th style="width:15%" data-options="field:‘Name‘" sortable="true">登录名</th>
<th style="width:15%" data-options="field:‘RealName‘" sortable="true">姓名</th>
<th style="width:15%" data-options="field:‘Sex‘" sortable="true">性别</th>
<th style="width:15%" data-options="field:‘Email‘">邮箱</th>
<th style="width:15%" data-options="field:‘Phone‘">电话</th>
<th style="width:15%" data-options="field:‘Address‘">地址</th>
</tr>
</thead>
</table>
</div>
读取数据:GetList 的action
2.Control 代码:
[HttpGet]
public string GetList(int page,int rows, string sort,string order)
{
int total = userService.GetList(x => x.IsDeleted == false).ToList().Count(); //数据总数
var list = userService.GetQueryableList(x => x.IsDeleted == false);
var sortList = userService.Sorting(list, sort, order); //排序
var pageList = userService.Paging(sortList, page, rows); //分页
Dictionary<string, object> data = http://www.mamicode.com/new Dictionary
data.Add("total", total);
data.Add("rows", pageList);
var json = JsonConvert.SerializeObject(data);
return json;
}
datagrid展示数据(带分页、排序)