ASP.Net MVC+Data Table实现分页+排序功能的方法

本文实例讲述了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 {
  
}

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相关内容感兴趣的读者可查看本站专题：《asp.net优化技巧总结》、《asp.net字符串操作技巧汇总》、《asp.net操作XML技巧总结》、《asp.net文件操作技巧汇总》、《asp.net ajax技巧总结专题》及《asp.net缓存操作技巧总结》。

希望本文所述对大家asp.net程序设计有所帮助。