.NET MVC 查询分页排序综合类 - 基类

using System;
using System.Collections.Generic;
using System.Linq;
using System.Linq.Dynamic;
using System.Text;
using System.Web.Routing;


namespace lktec.am7.Entity
{
/// <summary>
/// 分页控件
/// </summary>
/// <typeparam name="TSource"></typeparam>
public class Pager<TSource> where TSource : class
{
#region Variables
protected IQueryable<TSource> source;
private int pagesize = 50;
private int currentpageindex = 0;
private bool ischanged = true;
private int itemcount = 0;
private string orderby;
private bool pageenabled = true;
#endregion


#region Properties
/// <summary>
/// 地址参数信息
/// </summary>
protected virtual RouteValueDictionary routeData
{
get
{
var dict = new RouteValueDictionary();
if (currentpageindex != 0) dict.Add("CurrentPageIndex", currentpageindex);
if (pagesize != 50) dict.Add("PageSize", pagesize);
if (!string.IsNullOrWhiteSpace(orderby)) dict.Add("OrderBy", orderby);
return dict;
}
}


/// <summary>
/// 排序参数信息
/// </summary>
protected virtual IDictionary<string, string> orderbyDict
{
get
{
var dict = new Dictionary<string, string>();
if (string.IsNullOrWhiteSpace(orderby)) return dict;
foreach (var rv in orderby.Split(','))
{
var r_v = rv.Split(' ');
if (!dict.ContainsKey(r_v[0])) dict.Add(r_v[0], r_v.Length == 2 ? r_v[1].ToUpper() : "ASC");
else dict[r_v[0]] = r_v.Length == 2 ? r_v[1].ToUpper() : "ASC";
}
return dict;
}
}


/// <summary>
/// 目标对象
/// </summary>
public IEnumerable<TSource> Items
{
get
{
Update();
if (pageenabled) return source.OrderBy(OrderBy).Skip(currentpageindex * pagesize).Take(pagesize).ToList();
return source.OrderBy(OrderBy).ToList();
}
}


/// <summary>
/// 是否分页
/// </summary>
public bool PageEnabled
{
set { pageenabled = value; }
get { return pageenabled; }
}


/// <summary>
/// 每一页数量
/// </summary>
public int PageSize
{
set { pagesize = value; }
get { return pagesize; }
}


/// <summary>
/// 当前页(从0开始)
/// </summary>
public int CurrentPageIndex
{
set { currentpageindex = value; }
get { return currentpageindex; }
}


/// <summary>
/// 排序字符串
/// </summary>
public string OrderBy
{
set { orderby = value; }
get
{
if (string.IsNullOrWhiteSpace(orderby)) return "ID";
return orderby;
}
}


/// <summary>
/// 记录的行数
/// </summary>
public int Count
{
get
{
if (ischanged)
{
itemcount = source.Count();
ischanged = false;
}
return itemcount;
}
}


/// <summary>
/// 总页数
/// </summary>
public int PageCount
{
get
{
var cnt = Count / PageSize;
if (Count % PageSize != 0) cnt++;
return cnt;
}
}
#endregion


#region Events
/// <summary>
/// 地址参数路由
/// </summary>
/// <param name="exceptRouteKey"></param>
/// <returns></returns>
public RouteValueDictionary RouteData(string key, object value)
{
RouteValueDictionary dict = routeData;
if (dict.ContainsKey(key)) dict[key] = value;
else dict.Add(key, value);
return dict;
}


/// <summary>
/// 返回对应键的排序方式
/// </summary>
/// <param name="key">排序键</param>
/// <returns>NA:没有排序,ASC:顺序,DESC:倒序</returns>
public string OrderByStatus(string key)
{
var ob = orderbyDict;
if (ob.ContainsKey(key)) return ob[key];
return "NA";
}


/// <summary>
/// 获取下一个排序状态
/// 如果该键还没有排序,系统会生成一个排序键
/// </summary>
/// <param name="key">排序键</param>
/// <param name="value">强制排序键值(默认为NULL,系统自动改变),value为""时系统删除该键的排序</param>
/// <returns></returns>
public string NextOrderBy(string key, string value = null)
{
string res = "";
var ob = orderbyDict;
if (ob.ContainsKey(key))
{
if (value != null)
{
if ("ASC" == value || "DESC" == value) ob[key] = value;
else ob.Remove(key);
}
else if (ob[key].Equals("ASC")) ob[key] = "DESC";
else if (ob[key].Equals("DESC")) ob.Remove(key);
}
else ob.Add(key, string.IsNullOrWhiteSpace(value) ? "ASC" : value);
foreach (var r_v in ob) res += "," + r_v.Key + " " + r_v.Value;
if (res.Length > 0) res = res.Substring(1);
return res;
}


/// <summary>
/// 更新查询数据
/// </summary>
protected virtual void Update()
{
ischanged = true;
}
#endregion
}
}