ASP.NETMVC4分页组合查询解决方法

public static class PredicateBuilder{public static Expressionbool>> True() { return f &＃61;> true; }public static Expressionbool>> False() { return f &＃61;> false; }public static Expression Compose(this Expression first, Expression second, Func merge){// build parameter map (from parameters of second to parameters of first)var map &＃61; first.Parameters.Select((f, i) &＃61;> new { f, s &＃61; second.Parameters[i] }).ToDictionary(p &＃61;> p.s, p &＃61;> p.f);// replace parameters in the second lambda expression with parameters from the firstvar secondBody &＃61; ParameterRebinder.ReplaceParameters(map, second.Body);// apply composition of lambda expression bodies to parameters from the first expression return Expression.Lambda(merge(first.Body, secondBody), first.Parameters);}public static Expressionbool>> And(this Expressionbool>> first, Expressionbool>> second){return first.Compose(second, Expression.And);}public static Expressionbool>> Or(this Expressionbool>> first, Expressionbool>> second){return first.Compose(second, Expression.Or);}}public class ParameterRebinder : ExpressionVisitor{private readonly Dictionary map;public ParameterRebinder(Dictionary map){this.map &＃61; map ?? new Dictionary();}public static Expression ReplaceParameters(Dictionary map, Expression exp){return new ParameterRebinder(map).Visit(exp);}protected override Expression VisitParameter(ParameterExpression p){ParameterExpression replacement;if (map.TryGetValue(p, out replacement)){p &＃61; replacement;}return base.VisitParameter(p);}}

//获取页容量int pageSize &＃61; FytRequest.GetFormInt("rows", 10);//获取请求的页码int pageIndex &＃61; FytRequest.GetFormInt("page", 1);var key &＃61; FytRequest.GetFormStringEncode("key");int statu &＃61; FytRequest.GetFormInt("statu");var begintime &＃61; FytRequest.GetFormString("begintime");var endtime &＃61; FytRequest.GetFormString("endtime");var where &＃61; PredicateBuilder.True();#region 组合查询if (key!&＃61;""){where &＃61; where.And(m &＃61;> m.loginName.Contains(key));where &＃61; where.Or(m&＃61;>m.title.Contains(key));}if (statu!&＃61;-1){where &＃61; where.And(m&＃61;>m.logType&＃61;&＃61;statu);}if (begintime !&＃61; "" && endtime !&＃61; ""){var bt &＃61; Convert.ToDateTime(begintime);var et &＃61; Convert.ToDateTime(endtime);where &＃61; where.And(m &＃61;> m.addDate >&＃61; bt && m.addDate <&＃61; et);}#endregionvar dataList &＃61; OperateContext.BLLSession.Itb_SystemLogBLL.GetPagedList(pageIndex, pageSize, where, p &＃61;> p.ID);int rowCount &＃61; OperateContext.BLLSession.Itb_SystemLogBLL.GetListBy(where).Count();var jsonM &＃61; new JsonHelper.JsonAjaxModel(){Data &＃61; dataList,PageTotal &＃61; 0,Status &＃61; "ok"};

#region 6.0 分页查询 &＃43; List GetPagedList///