这篇文章将为大家详细讲解有关ASP.Net MVC+Data Table怎么实现分页+排序功能，小编觉得挺实用的，因此分享给大家做个参考，希望大家阅读完这篇文章后可以有所收获。
成都创新互联公司服务项目包括杂多网站建设、
杂多网站制作、杂多网页制作以及杂多网络营销策划等。多年来，我们专注于互联网行业，利用自身积累的技术优势、行业经验、深度合作伙伴关系等，向广大中小型企业、政府机构等提供互联网行业的解决方案，
杂多网站推广取得了明显的社会效益与经济效益。目前，我们服务的客户以成都为中心已经辐射到杂多省份的部分城市，未来相信会继续扩大服务区域并继续获得客户的支持与信任！
具体如下：
实现思路：
使用datatable内置的分页，排序
使用attribute+反射来控制需要排序和显示的字段以及顺序
分离排序和显示逻辑
若要添加搜索逻辑只需要传递搜索的字段到后端即可(js初始化时把"searching": false拿掉)。
View :
@using BCMS.BusinessLogic
@using BCMS.BusinessLogic.Models
@model List
@Html.DisplayNameFor(model => model.First().PersNo)
@Html.DisplayNameFor(model => model.First().Personnel_Name)
@Html.DisplayNameFor(model => model.First().Position)
@Html.DisplayNameFor(model => model.First().Interchange)
Action
@section scripts {
@{
var columns = DataTableHelper.DisplayColumns();
}
$(document).ready(function () {
$('#tblData').dataTable({
"processing": true,
"serverSide": true,
"searching": false,
"stateSave": true,
"oLanguage": { "sInfoFiltered": "" },
"ajax": {
"url": @Url.Action("GetJsonData"),
"type": "GET"
},
"columns": [
{ "data": "@columns[0]" },
{ "data": "@columns[1]" },
{ "data": "@columns[2]" },
{ "data": "@columns[3]" },
{
"data": "@columns[0]",
"orderable": false,
"searchable": false,
"render": function (data, type, full, meta) {
if (type === 'display') {
return GetDetailButton("/BusCaptain/Detail?bcId=", data) + GetInfoButton("/Telematics?bcId=", data, "Performance");
} else { return data; }
}
}
],
"order": [[0, "asc"]]
});
});
}
Controller :
public ActionResult GetJsonData(int draw, int start, int length)
{
string search = Request.QueryString[DataTableQueryString.Searching];
string sortColumn = "";
string sortDirection = "asc";
if (Request.QueryString[DataTableQueryString.OrderingColumn] != null)
{
sortColumn = GetSortColumn(Request.QueryString[DataTableQueryString.OrderingColumn]);
}
if (Request.QueryString[DataTableQueryString.OrderingDir] != null)
{
sortDirection = Request.QueryString[DataTableQueryString.OrderingDir];
}
DataTableData dataTableData = new DataTableData();
dataTableData.draw = draw;
int recordsFiltered = 0;
dataTableData.data = BusCaptainService.Instance.SearchMyBuscaptains(User.Identity.Name, out recordsFiltered, start, length, sortColumn, sortDirection, search).Data;
dataTableData.recordsFiltered = recordsFiltered;
return Json(dataTableData, JsonRequestBehavior.AllowGet);
}
public string GetSortColumn(string sortColumnNo)
{
var name = DataTableHelper.SoringColumnName(sortColumnNo);
return name;
}
public class DataTableData
{
public int draw { get; set; }
public int recordsFiltered { get; set; }
public List data { get; set; }
}Model :
class XXX{
...
[DisplayColumn(0)]
[SortingColumn(0)]
public int? A { get; set; }
[DisplayColumn(1)]
[SortingColumn(1)]
public string B { get; set; }
...
}Helper class :
public class SortingColumnAttribute : Attribute
{
public int Index { get; }
public SortingColumnAttribute(int index)
{
Index = index;
}
}
public class DisplayColumnAttribute : Attribute
{
public int Index { get; }
public DisplayColumnAttribute(int index)
{
Index = index;
}
}
public static class DataTableQueryString
{
public static string OrderingColumn = "order[0][column]";
public static string OrderingDir = "order[0][dir]";
public static string Searching = "search[value]";
}
public static class DataTableHelper
{
public static IList DisplayColumns()
{
var result = new Dictionary();
var props = typeof(T).GetProperties();
foreach (var propertyInfo in props)
{
var propAttr =
propertyInfo
.GetCustomAttributes(false)
.OfType()
.FirstOrDefault();
if (propAttr != null)
{
result.Add(propAttr.Index,propertyInfo.Name);
}
}
return result.OrderBy(x => x.Key).Select(x => x.Value).ToList();
}
public static string SoringColumnName(string columnIndex)
{
int index;
if (!int.TryParse(columnIndex, out index))
{
throw new ArgumentOutOfRangeException();
}
return SoringColumnName(index);
}
public static string SoringColumnName(int index)
{
var props = typeof(T).GetProperties();
foreach (var propertyInfo in props)
{
var propAttr =
propertyInfo
.GetCustomAttributes(false)
.OfType()
.FirstOrDefault();
if (propAttr != null && propAttr.Index == index)
{
return propertyInfo.Name;
}
}
return "";
}
}Query：
...
var query = context.BusCaptains
.Where(x => ...)
.OrderByEx(sortDirection, sortField)
.Skip(start)
.Take(pageSize);
...
LINQ Helper :
...
public static IQueryable OrderByEx(this IQueryable q, string direction, string fieldName)
{
try
{
var customProperty = typeof(T).GetCustomAttributes(false).OfType().FirstOrDefault();
if (customProperty != null)
{
fieldName = customProperty.Name;
}
var param = Expression.Parameter(typeof(T), "p");
var prop = Expression.Property(param, fieldName);
var exp = Expression.Lambda(prop, param);
string method = direction.ToLower() == "asc" ? "OrderBy" : "OrderByDescending";
Type[] types = new Type[] {q.ElementType, exp.Body.Type};
var mce = Expression.Call(typeof(Queryable), method, types, q.Expression, exp);
return q.Provider.CreateQuery(mce);
}
catch (Exception ex)
{
_log.ErrorFormat("error form OrderByEx.");
_log.Error(ex);
throw ;
}
}
...
关于“ASP.Net MVC+Data Table怎么实现分页+排序功能”这篇文章就分享到这里了，希望以上内容可以对大家有一定的帮助，使各位可以学到更多知识，如果觉得文章不错，请把它分享出去让更多的人看到。
当前标题：ASP.NetMVC+DataTable怎么实现分页+排序功能-创新互联
浏览地址：
http://cdkjz.cn/article/dcscid.html
