動(dòng)態(tài)多條件查詢分頁以及排序(一)--MVC與Entity Framework版url分頁版

 public class StudentService:IStudentService
    {


        /// <summary>
        /// 按條件搜索
        /// </summary>
        /// <param name="query">搜索條件</param>
        /// <param name="pageIndex">當(dāng)前頁數(shù)(索引從1開始)</param>
        /// <param name="pageSize">每頁顯示條數(shù)</param>
        /// <param name="total">總條數(shù)</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 假設(shè)數(shù)據(jù)庫里原數(shù)據(jù)為200條 

            dbcontext = dbcontext.Where(query);

            total = dbcontext.Count();//執(zhí)行查詢數(shù)量sql

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

            return dbcontext.ToList();//執(zhí)行分頁排序查詢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>
        /// 當(dāng)前第幾頁
        /// </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;//設(shè)置頁碼
@Html.RouteLink("首頁", dict);

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

    <text>跳轉(zhuǎn)至</text>
    <select id="pageselect" onchange="selectchange()">
        @for (int i = 1; i <=@Model.TotalPageCount; 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 />