多条件查询分页以及排序方案汇总

 public class StudentService:IStudentService
    {


        /// <summary>
        /// 按条件搜索
        /// </summary>
        /// <param name="query">搜索条件</param>
        /// <param name="pageIndex">当前页数(索引从1开始)</param>
        /// <param name="pageSize">每页显示条数</param>
        /// <param name="total">总条数</param>
        /// <param name="orderBy">排序字段</param>
        /// <param name="ascending">是否升序</param>
        /// <returns></returns>
        public IList<Student> Search(QueryModel query, int pageIndex, int pageSize, out int total, string orderBy, bool ascending)
        {
            IList<Student> stulist = Builder<Student>.CreateListOfSize(321).TheFirst(44).With(x => x.StuName = "hy").And(x => x.Nullint = 1).And(x => x.LoveGril = "LILI").And(x => x.CreateTime = new DateTime(2012, 02, 03)).And(x => x.Birthday = new DateTime(2012, 09, 01)).And(x => x.Stuclass = new StuClass() { ClassId = "2", ClassName = "二班" }).TheNext(33).With(x => x.StuName = "wlf").And(x => x.Nullint = 2).And(x => x.LoveGril = "MM").And(x => x.CreateTime = new DateTime(2012, 06, 06)).And(x => x.Birthday = new DateTime(2012, 09, 010)).And(x => x.Stuclass = new StuClass() { ClassId = "1", ClassName = "一班" }).TheNext(244).And(x=>x
                .Stuclass=new StuClass(){ClassId = "3", ClassName = "三班"}).Build();

            var dbcontext = stulist.AsQueryable(); //模拟EF context 假设数据库里原数据为200条 

            dbcontext = dbcontext.Where(query);

            total = dbcontext.Count();//执行查询数量sql

            dbcontext = dbcontext.OrderBy(orderBy, ascending).Skip(pageSize * (pageIndex - 1)).Take(pageSize);

            return dbcontext.ToList();//执行分页排序查询sql
        }
    }

   public class Pager
    {
        public Pager(int currentPageIndex, int totalItemCount, int pagesize = 20)
        {

            this.TotalItemCount = totalItemCount;
            this.PageSize = pagesize;
            this.CurrentPageIndex = currentPageIndex > TotalPageCount ? 1 : currentPageIndex;
        }

        /// <summary>
        /// 当前第几页
        /// </summary>
        public int CurrentPageIndex { get; set; }
        /// <summary>
        /// 每页显示多少条
        /// </summary>
        public int PageSize { get; set; }
        /// <summary>
        /// 总共多少条记录
        /// </summary>
        public int TotalItemCount { get; set; }
        /// <summary>
        /// 总共多少页
        /// </summary>
        public int TotalPageCount
        {
            get
            {
                double pageCount = (double)TotalItemCount / (double)PageSize;
                pageCount = Math.Ceiling(pageCount);
                return (int)pageCount;
            }
        }
        /// <summary>
        /// 是否显示
        /// </summary>
        public bool IsShow
        {
            get
            {
                if (TotalPageCount > 0)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }
        }

        /// <summary>
        /// 是否显示上一页
        /// </summary>
        public bool HasPreviousPage
        {
            get
            {
                return (CurrentPageIndex > 1);
            }
        }

        /// <summary>
        /// 是否显示下一页
        /// </summary>
        public bool HasNextPage
        {
            get
            {
                return (CurrentPageIndex < TotalPageCount);
            }
        }

    }

dict["PageIndex"] = 1;//设置页码
@Html.RouteLink("首页", dict);

 routes.MapRoute("Page", "{controller}/{action}/page{PageIndex}", new { controller = "WLFQuery", action = "Index", PageIndex = 1 });

    <text>跳转至</text>
    <select id="pageselect" onchange="selectchange()">
        @for (int i = 1; i <[email protected]; i++)
            {
                var selected = "";
                if (i==Model.CurrentPageIndex)
                {
                    selected = "selected='selected'";
                }            
            <option value="@i" @selected>@i</option>
            }
    </select>
    
    {
        dict["PageIndex"] = "*pageindex*";
    }
    <a style="display:none" id="pagelink" href="@Url.RouteUrl(dict)" ></a>
    //  
    <script type="text/javascript">

            function selectchange() {
                var pageselect = document.getElementById("pageselect");
                var pageselectValue = pageselect.options[pageselect.selectedIndex].value;

                var linkdom= document.getElementById("pagelink");
                var href = linkdom.href;
                href = href.replace("*pageindex*", pageselectValue);

                window.location = href;
  
            }
    </script>
    
    <text>页</text>

 <form action="@Url.Action("index", new { PageIndex = 1 })" method="get">
 </form> 

 ID(like操作)： <input type="text" name="[Contains]StuId"  value="@Request.QueryString["[Contains]StuId"]" /><br />

   QueryModel query=ViewBag.Query as QueryModel;
      string StuId=query.Items.Where(x => x.Field == "StuId").Select(x=>x.Value).FirstOrDefault()!=null?query.Items.Where(x => x.Field == "StuId").Select(x=>x.Value).FirstOrDefault().ToString():"";

 string[] newarrlovewgril = (string[])arrlovegril;
          MMischeck= newarrlovewgril.Contains("MM") ? "checked='checked'" : "";
          LUCIischeck = newarrlovewgril.Contains("LILI") ? "checked='checked'" : "";
          GAGAischeck = newarrlovewgril.Contains("GAGA") ? "checked='checked'" : "";


 MM<input type="checkbox" name="lovegril" value="MM" @MMischeck />
        LILI<input type="checkbox" name="lovegril" value="LILI" @LUCIischeck />
        GAGA<input type="checkbox" name="lovegril"  value="GAGA" @GAGAischeck />