ASP.NET MVC5网站开发之用户添加和浏览2(七)_实用技巧_

//排序 switch(order) { case 0://ID升序 _users.Items = Repository.FindPageList((int)pageSize, (int)pageIndex, out _users.TotalNumber, _where, u => u.UserID, true).ToList(); break; case 1://ID降序 _users.Items = Repository.FindPageList((int)pageSize, (int)pageIndex, out _users.TotalNumber, _where, u => u.UserID, false).ToList(); break; case 2://注册时间降序 _users.Items = Repository.FindPageList((int)pageSize, (int)pageIndex, out _users.TotalNumber, _where, u => u.RegTime, true).ToList(); break; case 3://注册时间升序 _users.Items = Repository.FindPageList((int)pageSize, (int)pageIndex, out _users.TotalNumber, _where, u => u.RegTime, false).ToList(); break; case 4://最后登录时间升序 _users.Items = Repository.FindPageList((int)pageSize, (int)pageIndex, out _users.TotalNumber, _where, u => u.LastLoginTime, true).ToList(); break; case 5://最后登录时间降序 _users.Items = Repository.FindPageList((int)pageSize, (int)pageIndex, out _users.TotalNumber, _where, u => u.LastLoginTime, false).ToList(); break; default://ID降序 _users.Items = Repository.FindPageList((int)pageSize, (int)pageIndex, out _users.TotalNumber, _where, u => u.UserID, false).ToList(); break; }

namespace Ninesky.DataLibrary { /// 
 /// 排序参数 /// 
 public class OrderParam { /// 
 /// 属性名 /// 
 public string PropertyName { get; set; } /// 
 /// 排序方式 /// 
 public OrderMethod Method { get; set; } } /// 
 /// 排序方式 /// 
 public enum OrderMethod { /// 
 /// 正序 /// 
 ASC, /// 
 /// 倒序 /// 
 DESC } } 

/// 
 /// 查找分页列表 /// 
 /// 每页记录数。必须大于1 /// 页码。首页从1开始，页码必须大于1 /// 总记录数 /// 查询表达式 /// 排序【null-不设置】 public IQueryable FindPageList(int pageSize, int pageIndex, out int totalNumber, Expression> where, OrderParam[] orderParams) { if (pageIndex < 1) pageIndex = 1; if (pageSize < 1) pageSize = 10; IQueryable _list = DbContext.Set().Where(where); var _orderParames = Expression.Parameter(typeof(T), "o"); if (orderParams != null && orderParams.Length > 0) { for (int i = 0; i < orderParams.Length; i++) { //根据属性名获取属性 var _property = typeof(T).GetProperty(orderParams[i].PropertyName); //创建一个访问属性的表达式 var _propertyAccess = Expression.MakeMemberAccess(_orderParames, _property); var _orderByExp = Expression.Lambda(_propertyAccess, _orderParames); string _orderName = orderParams[i].Method == OrderMethod.ASC ? "OrderBy" : "OrderByDescending"; MethodCallExpression resultExp = Expression.Call(typeof(Queryable), _orderName, new Type[] { typeof(T), _property.PropertyType }, _list.Expression, Expression.Quote(_orderByExp)); _list = _list.Provider.CreateQuery(resultExp); } } totalNumber = _list.Count(); return _list.Skip((pageIndex - 1) * pageIndex).Take(pageSize); }

 //查找实体分页列表 #region FindPageList /// 
 /// 查找分页列表 /// 
 /// 每页记录数。必须大于1 /// 页码。首页从1开始，页码必须大于1 /// 总记录数 ///  public IQueryable FindPageList(int pageSize, int pageIndex, out int totalNumber) { OrderParam _orderParam = null; return FindPageList(pageSize, pageIndex, out totalNumber, _orderParam); } /// 
 /// 查找分页列表 /// 
 /// 每页记录数。必须大于1 /// 页码。首页从1开始，页码必须大于1 /// 总记录数 /// 排序键 /// 是否正序 ///  public IQueryable FindPageList(int pageSize, int pageIndex, out int totalNumber, OrderParam orderParam) { return FindPageList(pageSize, pageIndex, out totalNumber, (T)=> true, orderParam); } /// 
 /// 查找分页列表 /// 
 /// 每页记录数。必须大于1 /// 页码。首页从1开始，页码必须大于1 /// 总记录数 /// 查询表达式 public IQueryable FindPageList(int pageSize, int pageIndex, out int totalNumber, Expression> where) { OrderParam _param = null; return FindPageList(pageSize, pageIndex, out totalNumber, where, _param); } /// 
 /// 查找分页列表 /// 
 /// 每页记录数。 /// 页码。首页从1开始 /// 总记录数 /// 查询表达式 /// 排序【null-不设置】 ///  public IQueryable FindPageList(int pageSize, int pageIndex, out int totalNumber, Expression> where, OrderParam orderParam) { OrderParam[] _orderParams = null; if (orderParam != null) _orderParams = new OrderParam[] { orderParam }; return FindPageList(pageSize, pageIndex, out totalNumber, where, _orderParams); } /// 
 /// 查找分页列表 /// 
 /// 每页记录数。 /// 页码。首页从1开始 /// 总记录数 /// 查询表达式 /// 排序【null-不设置】 public IQueryable FindPageList(int pageSize, int pageIndex, out int totalNumber, Expression> where, OrderParam[] orderParams) { if (pageIndex < 1) pageIndex = 1; if (pageSize < 1) pageSize = 10; IQueryable _list = DbContext.Set().Where(where); var _orderParames = Expression.Parameter(typeof(T), "o"); if (orderParams != null && orderParams.Length > 0) { for (int i = 0; i < orderParams.Length; i++) { //根据属性名获取属性 var _property = typeof(T).GetProperty(orderParams[i].PropertyName); //创建一个访问属性的表达式 var _propertyAccess = Expression.MakeMemberAccess(_orderParames, _property); var _orderByExp = Expression.Lambda(_propertyAccess, _orderParames); string _orderName = orderParams[i].Method == OrderMethod.ASC ? "OrderBy" : "OrderByDescending"; MethodCallExpression resultExp = Expression.Call(typeof(Queryable), _orderName, new Type[] { typeof(T), _property.PropertyType }, _list.Expression, Expression.Quote(_orderByExp)); _list = _list.Provider.CreateQuery(resultExp); } } totalNumber = _list.Count(); return _list.Skip((pageIndex - 1) * pageIndex).Take(pageSize); } #endregion 

 //查找实体列表 #region FindList /// 
 /// 查找实体列表 /// 
 ///  public IQueryable FindList() { return DbContext.Set(); } /// 
 /// 查找实体列表 /// 
 /// 查询Lambda表达式 ///  public IQueryable FindList(Expression> where) { return DbContext.Set().Where(where); } /// 
 /// 查找实体列表 /// 
 /// 查询Lambda表达式 /// 获取的记录数量 ///  public IQueryable FindList(Expression> where, int number) { return DbContext.Set().Where(where).Take(number); } /// 
 /// 查找实体列表 /// 
 /// 查询Lambda表达式 /// 排序参数 ///  public IQueryable FindList(Expression> where, OrderParam orderParam) { return FindList(where, orderParam, 0); } /// 
 /// 查找实体列表 /// 
 /// 查询Lambda表达式 /// 排序参数 /// 获取的记录数量【0-不启用】 public IQueryable FindList(Expression> where, OrderParam orderParam, int number) { OrderParam[] _orderParams = null; if (orderParam != null) _orderParams = new OrderParam[] { orderParam }; return FindList(where, _orderParams, number); } /// 
 /// 查找实体列表 /// 
 /// 查询Lambda表达式 /// 排序参数 /// 获取的记录数量【0-不启用】 ///  public IQueryable FindList(Expression> where, OrderParam[] orderParams, int number) { var _list = DbContext.Set().Where(where); var _orderParames = Expression.Parameter(typeof(T), "o"); if (orderParams != null && orderParams.Length > 0) { for (int i = 0; i < orderParams.Length; i++) { //根据属性名获取属性 var _property = typeof(T).GetProperty(orderParams[i].PropertyName); //创建一个访问属性的表达式 var _propertyAccess = Expression.MakeMemberAccess(_orderParames, _property); var _orderByExp = Expression.Lambda(_propertyAccess, _orderParames); string _orderName = orderParams[i].Method == OrderMethod.ASC ? "OrderBy" : "OrderByDescending"; MethodCallExpression resultExp = Expression.Call(typeof(Queryable), _orderName, new Type[] { typeof(T), _property.PropertyType }, _list.Expression, Expression.Quote(_orderByExp)); _list = _list.Provider.CreateQuery(resultExp); } } if (number > 0) _list = _list.Take(number); return _list; 
                
提示：
                    本文由神整理自网络，如有侵权请联系本站删除！
                    

                    本站声明： 

                    1、本站所有资源均来源于互联网，不保证100%完整、不提供任何技术支持； 

                    2、本站所发布的文章以及附件仅限用于学习和研究目的;不得将用于商业或者非法用途；否则由此产生的法律后果，本站概不负责！
                
                

                

                                            
上一篇：ASP.NET MVC5网站开发之用户角色的后台管理1(七)_实用技巧_
                                                                
下一篇：ASP.NET MVC5网站开发之用户资料的修改和删除3（七）_实用技巧_