asp. net MVC Paging Code Sharing
- 2021-08-16 23:34:48
- OfStack
This article example shares the MVC paging code for your reference, the specific content is as follows
using System.Collections.Generic;
using System.Collections.Specialized;
using System.Linq;
using System.Web;
using System.Text;
using System.Web.Mvc;
using System.Web.Routing;
using System.Data.Objects.DataClasses;
namespace System.Web.Mvc
{
public static class PagerHelper
{
/// <summary>
/// Paging
/// </summary>
/// <param name="helper"></param>
/// <param name="id"> Paging id</param>
/// <param name="currentPageIndex"> Current page </param>
/// <param name="pageSize"> Page size </param>
/// <param name="recordCount"> Total number of records </param>
/// <param name="htmlAttributes"> Page header label attributes </param>
/// <param name="className"> Paging style </param>
/// <param name="mode"> Paging mode </param>
/// <returns></returns>
public static string Pager(this HtmlHelper helper, string id, int currentPageIndex, int pageSize, int recordCount, object htmlAttributes, string className, PageMode mode)
{
TagBuilder builder = new TagBuilder("table");
builder.IdAttributeDotReplacement = "_";
builder.GenerateId(id);
builder.AddCssClass(className);
builder.MergeAttributes(new RouteValueDictionary(htmlAttributes));
builder.InnerHtml = GetNormalPage(currentPageIndex, pageSize, recordCount, mode);
return builder.ToString();
}
/// <summary>
/// Paging
/// </summary>
/// <param name="helper"></param>
/// <param name="id"> Paging id</param>
/// <param name="currentPageIndex"> Current page </param>
/// <param name="pageSize"> Page size </param>
/// <param name="recordCount"> Total number of records </param>
/// <param name="className"> Paging style </param>
/// <returns></returns>
public static string Pager(this HtmlHelper helper, string id, int currentPageIndex, int pageSize, int recordCount, string className)
{
return Pager(helper, id, currentPageIndex, pageSize, recordCount, null, className, PageMode.Normal);
}
/// <summary>
/// Paging
/// </summary>
/// <param name="helper"></param>
/// <param name="id"> Paging id</param>
/// <param name="currentPageIndex"> Current page </param>
/// <param name="pageSize"> Page size </param>
/// <param name="recordCount"> Total number of records </param>
/// <returns></returns>
public static string Pager(this HtmlHelper helper, string id, int currentPageIndex, int pageSize, int recordCount)
{
return Pager(helper, id, currentPageIndex, pageSize, recordCount, null);
}
/// <summary>
/// Paging
/// </summary>
/// <param name="helper"></param>
/// <param name="id"> Paging id</param>
/// <param name="currentPageIndex"> Current page </param>
/// <param name="pageSize"> Page size </param>
/// <param name="recordCount"> Total number of records </param>
/// <param name="mode"> Paging mode </param>
/// <returns></returns>
public static string Pager(this HtmlHelper helper, string id, int currentPageIndex, int pageSize, int recordCount, PageMode mode)
{
return Pager(helper, id, currentPageIndex, pageSize, recordCount, null, mode);
}
/// <summary>
/// Paging
/// </summary>
/// <param name="helper"></param>
/// <param name="id"> Paging id</param>
/// <param name="currentPageIndex"> Current page </param>
/// <param name="pageSize"> Page size </param>
/// <param name="recordCount"> Total number of records </param>
/// <param name="className"> Paging style </param>
/// <param name="mode"> Paging mode </param>
/// <returns></returns>
public static string Pager(this HtmlHelper helper, string id, int currentPageIndex, int pageSize, int recordCount, string className, PageMode mode)
{
return Pager(helper, id, currentPageIndex, pageSize, recordCount, null, className, mode);
}
/// <summary>
/// Get normal paging
/// </summary>
/// <param name="currentPageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="recordCount"></param>
/// <returns></returns>
private static string GetNormalPage(int currentPageIndex, int pageSize, int recordCount, PageMode mode)
{
int pageCount = (recordCount % pageSize == 0 ? recordCount / pageSize : recordCount / pageSize + 1);
StringBuilder url = new StringBuilder();
url.Append(HttpContext.Current.Request.Url.AbsolutePath + "?page={0}");
NameValueCollection collection = HttpContext.Current.Request.QueryString;
string[] keys = collection.AllKeys;
for (int i = 0; i < keys.Length; i++)
{
if (keys[i].ToLower() != "page")
url.AppendFormat("&{0}={1}", keys[i], collection[keys[i]]);
}
StringBuilder sb = new StringBuilder();
sb.Append("<tr><td>");
sb.AppendFormat(" Total {0} A record , Altogether {1} Page , Current {2} Page ", recordCount, pageCount, currentPageIndex);
if (currentPageIndex == 1)
sb.Append("<span> Home page </span> ");
else
{
string url1 = string.Format(url.ToString(), 1);
sb.AppendFormat("<span><a href={0}> Home page </a></span> ", url1);
}
if (currentPageIndex > 1)
{
string url1 = string.Format(url.ToString(), currentPageIndex - 1);
sb.AppendFormat("<span><a href={0}> Upper 1 Page </a></span> ", url1);
}
else
sb.Append("<span> Upper 1 Page </span> ");
if (mode == PageMode.Numeric)
sb.Append(GetNumericPage(currentPageIndex, pageSize, recordCount, pageCount, url.ToString()));
if (currentPageIndex < pageCount)
{
string url1 = string.Format(url.ToString(), currentPageIndex + 1);
sb.AppendFormat("<span><a href={0}> Under 1 Page </a></span> ", url1);
}
else
sb.Append("<span> Under 1 Page </span> ");
if (currentPageIndex == pageCount)
sb.Append("<span> Last page </span> ");
else
{
string url1 = string.Format(url.ToString(), pageCount);
sb.AppendFormat("<span><a href={0}> Last page </a></span> ", url1);
}
return sb.ToString();
}
/// <summary>
/// Get numeric paging
/// </summary>
/// <param name="currentPageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="recordCount"></param>
/// <param name="pageCount"></param>
/// <param name="url"></param>
/// <returns></returns>
private static string GetNumericPage(int currentPageIndex, int pageSize, int recordCount, int pageCount, string url)
{
int k = currentPageIndex / 10;
int m = currentPageIndex % 10;
StringBuilder sb = new StringBuilder();
if (currentPageIndex / 10 == pageCount / 10)
{
if (m == 0)
{
k--;
m = 10;
}
else
m = pageCount % 10;
}
else
m = 10;
for (int i = k * 10 + 1; i <= k * 10 + m; i++)
{
if (i == currentPageIndex)
sb.AppendFormat("<span><font color=red><b>{0}</b></font></span> ", i);
else
{
string url1 = string.Format(url.ToString(), i);
sb.AppendFormat("<span><a href={0}>{1}</a></span> ", url1, i);
}
}
return sb.ToString();
}
}
/// <summary>
/// Paging mode
/// </summary>
public enum PageMode
{
/// <summary>
/// Normal paging mode
/// </summary>
Normal,
/// <summary>
/// Ordinary paging plus digital paging
/// </summary>
Numeric
}
}
html code
<div id="pageNav" class="pageinator">
@Html.ShowPageNavigate((int)ViewData["pageindex"], (int)ViewBag.pageSize, (int)ViewBag.totalCount);
</div>
Controller
shopEntities shop = new shopEntities();
public ActionResult Index()
{
//IQueryable<tbl_order> order = (from a in shop.tbl_order select a).OrderBy(a=>a.id).Skip(10).Take(10);
//ViewData["order"] = order;
//return View();
int pageIndex = Request["pageIndex"] == null ? 1 : int.Parse(Request["pageIndex"]);
int pageSize = Request["pageSize"] == null ? 10 : int.Parse(Request["pageSize"]);
int totalCount = 0;
// Deliver to the foreground Paged parameter data
ViewData["pageIndex"] = pageIndex;
//ViewData["pageSize"] = pageSize;
ViewBag.pageSize = pageSize;
// Total number of articles
totalCount = shop.tbl_order.Count();
ViewBag.totalCount = totalCount;
// Send the current page data to the foreground.
//ViewData.Model = db.UserInfo.ToList();
//List<tbl_order> pp = shop.tbl_order
// .OrderBy(u => u.id)
// .Skip((pageIndex - 1) * pageSize)
// .Take(pageSize).ToList();
IQueryable<tbl_order> pp = shop.tbl_order
.OrderBy(u => u.id)
.Skip((pageIndex - 1) * pageSize)
.Take(pageSize);
return View(pp);
}