MVC分页详解（包括整个流程步骤,代码与注解）

1、首先写一个Model(分页模型)MvcPagerInfo.cs（可放入AppCode中）

using System;using System.Collections;using System.Collections.Generic;using System.Collections.Specialized;using System.Linq;using System.Web.Mvc;using System.Web;using System.Text;namespace community{    public class MvcPagerInfo    {        private int _pageIndex;        public int PageIndex { get { return _pageIndex; } set { _pageIndex = value; } }        private int _pageSize;        public int PageSize { get { return _pageSize; } set { _pageSize = value; } }        private int _recordCount;        public int RecordCount { get { return _recordCount; } set { _recordCount = value; } }        /// <summary>        /// 当前状态下，最小的页码        /// </summary>        private int _lowPageNum;        public int LowPageNum { get { return _lowPageNum; } }        /// <summary>        /// 当前状态下，最大的页码        /// </summary>        private int _highPageNum;        public int HighPageNum { get { return _highPageNum; } }        /// <summary>        /// 一次性能显示多少页数        /// </summary>        private int _maxPageNum;        public int MaxPageNum { get { return _maxPageNum; } set { _maxPageNum = value; } }        private bool _showPageInfo = true;        public bool ShowPageInfo { get { return _showPageInfo; } set { _showPageInfo = value; } }        /// <summary>        /// 页数        /// </summary>        private int _pageCount;        public int PageCount { get { return _pageCount; } }        /// <summary>        /// 当前路径        /// </summary>        private string path;        public string Path { get { return path; } set { path = value; } }        private NameValueCollection queries;        public MvcPagerInfo()        {        }        public void Compose()        {            path = HttpContext.Current.Request.Url.AbsolutePath;            queries = new NameValueCollection(StringComparer.OrdinalIgnoreCase);            foreach (string key in HttpContext.Current.Request.QueryString.AllKeys)            {                if (key == null)                    continue;                if (key.ToLower() != "page")                    queries.Add(key, HttpContext.Current.Request.QueryString[key]);            }            if (_recordCount == 0)                _pageCount = 1;            else                _pageCount = (_recordCount % _pageSize == 0) ? (_recordCount / _pageSize) : ((_recordCount / _pageSize) + 1);            if (_maxPageNum >= _pageCount)//如果页数小于等于最大页面显示            {                _lowPageNum = 1;                _highPageNum = _pageCount;            }            else            {                int lhalf, rhalf;                if (_maxPageNum % 2 == 0)                {                    lhalf = _maxPageNum / 2 - 1;                    rhalf = _maxPageNum / 2;                }                else                    lhalf = rhalf = _maxPageNum / 2;                _lowPageNum = (_pageIndex - lhalf > 0) ? (_pageIndex - lhalf) : 1;                _highPageNum = (_pageIndex + rhalf > _pageCount) ? _pageCount : (_pageIndex + rhalf < _maxPageNum ? _maxPageNum : _pageIndex + rhalf);                if (_lowPageNum > 1 && _highPageNum - _lowPageNum < _maxPageNum - 1)//校正                {                    _lowPageNum = _highPageNum - _maxPageNum + 1;                }            }        }        public string GetFirstUrl()        {            return GenerateUrl(1);        }        public string GetLastUrl()        {            return GenerateUrl(_pageCount);        }        public string GetNextUrl()        {            return GenerateUrl(_pageIndex + 1);        }        public string GetPrevUrl()        {            return GenerateUrl(_pageIndex - 1);        }        public string GetCurrentUrl()        {            return GenerateUrl(_pageIndex);        }        public string GetUrl(int page)        {            return GenerateUrl(page);        }        private string GenerateUrl(int pageIndex)        {            StringBuilder sb = new StringBuilder();            foreach (string key in queries.AllKeys)            {                sb.Append(key + "=" + System.Web.HttpContext.Current.Server.UrlEncode(queries[key]) + "&");            }            sb.Append("page=" + pageIndex);            return path + "?" + sb.ToString();        }        public string GetPageInfo()        {            if (_showPageInfo)            {                string info = "共{0}条 第{4}条-{5}条 第{1}页/共{2}页 每页{3}条";                int startCurrentCount = (_pageIndex - 1) * _pageSize + 1;                int endCurrentCount = _pageIndex * _pageSize;                if (startCurrentCount > _recordCount)                    startCurrentCount = _recordCount;                if (endCurrentCount > _recordCount)                    endCurrentCount = _recordCount;                info = string.Format(info, _recordCount.ToString(), _pageIndex.ToString(), _pageCount.ToString(), _pageSize.ToString(), startCurrentCount.ToString(), endCurrentCount.ToString());                return info;            }            else                return "";        }    }}

2、在控制器公用方法中添加分页方法BaseController.cs

       #region fs 分页        protected int GetPageSize()        {            if (string.IsNullOrEmpty(Request.QueryString["pagesize"]))                return 10;            else                return Convert.ToInt32(Request.QueryString["pagesize"]);        }        protected int GetPageIndex()        {            if (string.IsNullOrEmpty(Request.QueryString["page"]))            {                if (string.IsNullOrEmpty(Request.QueryString["pageindex"]))                    return 1;                else                    return Convert.ToInt32(Request.QueryString["pageindex"]);            }            else                return Convert.ToInt32(Request.QueryString["page"]);        }        protected void AddPager(int recordCount, int PageSize)        {            AddPager(recordCount, false, PageSize);        }        protected void AddPager(int recordCount)        {            AddPager(recordCount, false);        }        protected void AddPager(int recordCount, bool showpageInfo)        {            AddPager(recordCount, showpageInfo, GetPageSize());        }        protected void AddPager(int recordCount, bool showpageInfo, int pageSize)        {            MvcPagerInfo pageinfo = new MvcPagerInfo();            pageinfo.PageIndex = GetPageIndex();            pageinfo.PageSize = pageSize;            pageinfo.RecordCount = recordCount;            pageinfo.MaxPageNum = 10;            pageinfo.Compose();            pageinfo.ShowPageInfo = showpageInfo;            ViewData.Add("pager", pageinfo);        }        /// <summary>        /// 是否列表要获取所有数据        /// </summary>        /// <returns></returns>        protected bool IsGetTotalData()        {            string total = Request.QueryString["total"];            if (total == "1" || this.GetPageSize() <= 0)                return true;            else                return false;        }        /// <summary>        /// 保存访问地址        /// </summary>        /// <param name="pageName"></param>        protected void SaveCurrentUrl(string pageName)        {            Session[pageName] = Request.Url.ToString();        }        /// <summary>        /// 获取访问地址        /// </summary>        /// <param name="pageName"></param>        protected string GetLastSavedUrl(string pageName)        {            if (Session[pageName] != null)                return Session[pageName].ToString();            else                return pageName;        }        #endregion

3、写一个一般处理程序Pager.ascx

<%@ Control Language="C#" Inherits="System.Web.Mvc.ViewUserControl<MvcPagerInfo>" %><%@ Import Namespace="community" %><%    string firstPage;    string prevPage;    string nextPage;    string lastPage;   // string currentPage;    if (Model != null && Model.RecordCount != 0)    {        firstPage = "<a id='firstPage' href=\"" + Model.GetFirstUrl() + "\">首页</a>";        lastPage = "<a href=\"" + Model.GetLastUrl() + "\">末页</a>";        if (Model.PageIndex == 1 || Model.PageCount < Model.PageIndex)        {            prevPage = "<span>上一页</span>";        }        else        {            prevPage = "<a href=\"" + Model.GetPrevUrl() + "\">上一页</a>";        }        if (Model.PageCount <= Model.PageIndex)        {            nextPage = "<span>下一页</span>";        }        else        {            nextPage = "<a href=\"" + Model.GetNextUrl() + "\">下一页</a>";        }        Response.Write("<span>" + Model.GetPageInfo() + "</span>");        Response.Write(firstPage);        Response.Write(prevPage);        for (int i = Model.LowPageNum; i <= Model.HighPageNum; i++)        {            string css = "";            if (Model.PageIndex == i)                css = " class=\"currentPage\"";            Response.Write("<a href=\"" + Model.GetUrl(i) + "\"" + css + ">" + i + "</a>");        }        if (Model.HighPageNum < Model.PageCount)            Response.Write("<a href=\"" + Model.GetUrl(Model.HighPageNum + 1) + "\">...</a>");        Response.Write(nextPage);        Response.Write(lastPage);    }    %>

4、分页模板 _Pager.cshtml(View/Shared中)

<div id="pagelist" class="pagelist">    @{ Html.RenderPartial("Pager", ViewData["pager"]);}     <input type='text'  style='width:30px'  onkeyup='this.value=this.value.replace(/[^1-9]\d*$/,"")' value='@Request.QueryString["page"]' name='pageId' id='pageId'/>页      <!--     获取文本框的值作为跳转路径参数<a href="javascript:;" onclick="location ='?page='+document.getElementById('pageId').value;">跳 转</a>     -->    <a href="javascript:;" onclick="url()">跳 转</a></div><script type="text/javascript">    window.onload = function () {        if (!document.getElementById('firstPage')) {            document.getElementById("pagelist").style.display = "none";        }        if (document.getElementById('pageId').value == "") {            document.getElementById('pageId').value = 1;        }    }    function url() {        var str = document.getElementById("firstPage").getAttribute("href");        str=str.replace("page=1", "page=" + document.getElementById('pageId').value);        location.href = str;    }</script>

5、View(视图),以后分页调用这个模板就好了

 @{Html.RenderPartial("_Pager");}<!--将其放入需要分页的位置-->

6、CSS，分页在右下角显示

/*分页*/.pagelist { text-align:right; padding:5px; color:#000; cursor:default;height: 31px;}.pagelist a:link,.pagelist a:visited, .pagelist span{padding: 1px 3px 1px 3px;margin: 2px;text-decoration: none;min-width:12px;text-align:center;color:#2b5591;}.pagelist a:hover{ background-color:#dedede}.pagelist span{ color:#999}.pagelist .currentPage{ font-weight:bold; color:red;}.pagelist .txt{ width:25px}

7、Controller(控制器中)

        public ActionResult View()        {              int total = 0;              int pageIndex = GetPageIndex();//当前页码              int pageSize = GetPageSize();//使用默认,每页10条数据              var model = BlogService.LoadLastestBrieves(pageSize, pageIndex, out total);//调用的方法              int totalCount = BlogService.TotalBlogs();//获取分页时数据总条数              AddPager(totalCount, true, pageSize);//分页时每页显示10条数据，页面显示“info = "共{0}条 第{4}条-{5}条 第{1}页/共{2}页 每页{3}条""，false则隐藏              SaveCurrentUrl("~/Admin/View");//保存当前路径,在AdminController中View下              return View(model);        }

8、单纯SQL语句分页，当然你也可以用存储过程进行分页

select * from (select *,ROW_NUMBER() over(order by ID) as rn from UserInfo where ...) where rn between @PageSize*(@PageIndex-1)+1 and @PageSize*@PageIndex

9、结果（http://localhost:XXXX/Admin/View中）

默认结果：（AddPager(totalCount)）

详细结果：（AddPager(totalCount,true))

一个人的牛逼不如一群人的傻逼