MVC+EF実装ページングコード

5478 ワード

一、ページング表示のスタイルコード
    <style type ="text/css">
        .paginator {
            font:12px Arial,Helvetica,sans-serif;
            padding:10px 20px 10px 0;
            margin:0px;

        }
            .paginator a {
                border:solid 1px #ccc;
                color:#0063dc;
                cursor:pointer;
                text-decoration:none;
            }
                .paginator a:visited {
                    padding:1px 6px;
                    border:solid 1px #ddd;
                    background:#fff;
                    text-decoration:none;              
                }
            .paginator .cpb {   
                border:1px solid #F50;
                font-weight:700;
                color:#F50;
                background-color:#ffeee5;
            
            }
            .paginator a:hover {
                border:solid 1px #F50;
                color:#f60;
                text-decoration:none;
            }
            .paginator a, .paginator a:visited, .paginator .cpb, .paginator a:hover {
                float:left;
                height:16px;
                line-height:16px;
                min-width:10px;
                _width:10px;
                margin-right:5px;
                text-align:center;
                white-space:nowrap;
                font-size:12px;
                font-family:Arialm,SimSun;
                padding:0 3px;
            
            }
    </style>

二、ページングを実現するコアコード
        public static HtmlString ShowPageNavigate(this HtmlHelper htmlHelper, int currentPage, int pageSize, int totalCount)
        {
            var redirectTo = htmlHelper.ViewContext.RequestContext.HttpContext.Request.Url.AbsolutePath;
            pageSize = pageSize == 0 ? 3 : pageSize;
            var totalPages = Math.Max((totalCount + pageSize - 1) / pageSize, 1);// 
            var output = new StringBuilder();
            if (totalPages > 1)
            {
                //if (currentPage!=1)
                {// 
                    output.AppendFormat("<a class='pageLink' href='{0}?pageIndex=1&pageSize={1}'> </a>", redirectTo, pageSize);
                  
                }
                if (currentPage > 1)
                {// 
                    output.AppendFormat("<a class='pageLink' href='{0}?pageIndex=1&pageSize={1}&pageSize={2}'> </a>", redirectTo, currentPage - 1, pageSize);
                }
                else
                {
                    //output.Append("<span class='pageLink'> </span>");
                }
                output.Append(" ");
                int currint = 5;
                for (int i = 0; i < 10; i++)
                {// 10 , 5 5 
                    if ((currentPage + i -currint) >= 1 && (currentPage + i - currint)<=totalPages)
                    {
                        if (currint==i)
	                    {// 
                            output.AppendFormat("<a class='cpb' href='{0}?pageIndex={1} & pageSize={2}'>{3}</a>",redirectTo,currentPage,pageSize,currentPage);

		 
	                    }
                        else
                        {// 
                            output.AppendFormat("<a class='cpb' href='{0}?pageIndex={1} & pageSize={2}'>{3}</a>", redirectTo, currentPage + i - currint, pageSize, currentPage + i - currint);
                        }
                    }
                    output.Append(" ");
                }
                if (currentPage < totalPages)
                {// 
                    output.AppendFormat("<a class='pageLink' href='{0}?pageIndex={1} & pageSize={2}'> </a>", redirectTo, currentPage + 1, pageSize);
                }
                else
                {
 
                }
                output.Append(" ");
                if (currentPage!=totalPages)
                {
                     output.AppendFormat("<a class='pageLink' href='{0}?pageIndex={1} & pageSize={2}'> </a>", redirectTo, totalPages, pageSize);
                }
                output.Append(" ");
            }
            output.AppendFormat(" {0}  /  {1} ", currentPage, totalPages);// 
            return new HtmlString(output.ToString());
        }

三、View層コード
 
    <div  class ="paginator">
        <%:Html.ShowPageNavigate((int)ViewBag.CurrentPage,(int)ViewBag.PageSize,(int)ViewBag.Total) %>
    </div>

四、コントローラコード
        public ActionResult Index()
        {
            ViewData.Model = db.Province.AsEnumerable();

            int pageIndex=Request["pageIndex"] == null ? 1 : int.Parse(Request["pageIndex"]);
            ViewBag.CurrentPage =pageIndex;
            int pageSize=Request["pageSize"] == null ? 5: int.Parse(Request["pageSize"]);
            ViewBag.PageSize = pageSize;

            ViewBag.Total = db.Province.Count();

            ViewData.Model = db.Province.OrderBy(c => c.provinceID).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
            return View();
        }