* 反射真香,虽然我不会,但是我会拷贝
IPagedList可以实现快速分页,开发后台用非常棒,页面直接写后台代码
@if (this.Model.Count() > 0)
{
@Html.PagedListPager((IPagedList)Model, page => Url.Action("ActionName","ControllerName", new { page = page, 参数1= ViewBag.参数1,参数2= ViewBag.参数2 }), new PagedListRenderOptions()
{
DisplayLinkToFirstPage = PagedList.Mvc.PagedListDisplayMode.Always,
LinkToFirstPageFormat = "首页",
LinkToNextPageFormat = "下一页",
LinkToPreviousPageFormat = "上一页",
DisplayLinkToLastPage = PagedList.Mvc.PagedListDisplayMode.Always,
LinkToLastPageFormat = "末页",
MaximumPageNumbersToDisplay = 10
})
}
后台直接取数据【这个插件本身是准备配合EF直接获取数据库中数据的。让EF返回IQueryable类型数据,然后这个插件再帮你分页。】
后台代码大概思路是
var query = db.表名.AsQueryable();
if(!string.IsNullOrEmpty(参数1))
{
query = query.Where(a=>字段1==参数1).AsQueryable();
}
if (!string.IsNullOrEmpty(参数2))
{
query = query.Where(a => 字段2 == 参数2).AsQueryable();
}
return query.ToPagedList(page,pageSize);
这样就ojbk了。
但是如果后台没有用EF取数据还能用IPagedList分页么?
能的。放心。最简单的办法是取出所有数据到DataTable,再转成List,最后调用ToPagedList方法就行了。
如果不想取出所有数据也可以。
首先取出需要的那页数据。并且取出符合条件的数据总数。
Param p = new Param() { page = page, pageSize = pCount, total = 0, 参数1 = 值1, 参数2 = 值2 };
DataTable dt = _BLL.GetDataTablePaging(p);
然后dt再调用ToPagedList方法
var data = dt.ToPagedList<待返回表类型>(page, pCount, p.total);
return View(data);
辅助方法
public static class PageListHelper
{
public static List<T> ToDataList<T>(this DataTable dt)
{
var list = new List<T>();
var plist = new List<PropertyInfo>(typeof(T).GetProperties());
foreach (DataRow item in dt.Rows)
{
T s = Activator.CreateInstance<T>();
for (int i = 0; i < dt.Columns.Count; i++)
{
PropertyInfo info = plist.Find(p => p.Name == dt.Columns[i].ColumnName);
if (info != null)
{
try
{
if (!Convert.IsDBNull(item[i]))
{
object v = null;
if (info.PropertyType.ToString().Contains("System.Nullable"))
{
v = Convert.ChangeType(item[i], Nullable.GetUnderlyingType(info.PropertyType));
}
else
{
v = Convert.ChangeType(item[i], info.PropertyType);
}
info.SetValue(s, v, null);
}
}
catch (Exception ex)
{
throw new Exception("字段[" + info.Name + "]转换出错," + ex.Message);
}
}
}
list.Add(s);
}
return list;
}
/// <summary>
/// DataTable转IPagedList
/// </summary>
/// <typeparam name="T">需要将数据转换成哪个类的List</typeparam>
/// <param name="page">当前页</param>
/// <param name="pCount">页面容量</param>
/// <param name="totalCount">符合查需条件的数据总计多少条</param>
/// <returns></returns>
public static IPagedList<T> ToPagedList<T>(this DataTable dt ,int page ,int pCount,int totalCount)
{
List<T> list = dt.ToDataList<T>();
var data = list.ToPagedList(1, pCount);
int PageCount = (totalCount / pCount) + 1;
if (pCount * (PageCount-1) == totalCount)
PageCount--;
bool HasPreviousPage = (page > 1 ? true : false);
bool HasNextPage = (page < PageCount ? true : false);
bool IsFirstPage = (page == 1 ? true : false);
bool IsLastPage = (page == PageCount ? true : false);
int FirstItemOnPage = (page - 1) * pCount + 1;
int LastItemOnPage = page * pCount;
if (IsLastPage)
{
LastItemOnPage = totalCount ;
}
typeof(PagedList.PagedListMetaData).GetField("<PageCount>k__BackingField", BindingFlags.Instance | BindingFlags.NonPublic).SetValue(data, PageCount);
typeof(PagedList.PagedListMetaData).GetField("<TotalItemCount>k__BackingField", BindingFlags.Instance | BindingFlags.NonPublic).SetValue(data, totalCount);
typeof(PagedList.PagedListMetaData).GetField("<PageNumber>k__BackingField", BindingFlags.Instance | BindingFlags.NonPublic).SetValue(data, page);
typeof(PagedList.PagedListMetaData).GetField("<PageSize>k__BackingField", BindingFlags.Instance | BindingFlags.NonPublic).SetValue(data, pCount);
typeof(PagedList.PagedListMetaData).GetField("<HasPreviousPage>k__BackingField", BindingFlags.Instance | BindingFlags.NonPublic).SetValue(data, HasPreviousPage);
typeof(PagedList.PagedListMetaData).GetField("<HasNextPage>k__BackingField", BindingFlags.Instance | BindingFlags.NonPublic).SetValue(data, HasNextPage);
typeof(PagedList.PagedListMetaData).GetField("<IsFirstPage>k__BackingField", BindingFlags.Instance | BindingFlags.NonPublic).SetValue(data, IsFirstPage);
typeof(PagedList.PagedListMetaData).GetField("<IsLastPage>k__BackingField", BindingFlags.Instance | BindingFlags.NonPublic).SetValue(data, IsLastPage);
typeof(PagedList.PagedListMetaData).GetField("<FirstItemOnPage>k__BackingField", BindingFlags.Instance | BindingFlags.NonPublic).SetValue(data, FirstItemOnPage);
typeof(PagedList.PagedListMetaData).GetField("<LastItemOnPage>k__BackingField", BindingFlags.Instance | BindingFlags.NonPublic).SetValue(data, LastItemOnPage);
return data;
}
}
参考文章
C#DataTable转List互转 - 潇潇与偕 - 博客园 (cnblogs.com)https://www.cnblogs.com/zjbky/p/9242140.htmlsqlserver的四种分页方式 - 专于技术的菜鸟 - 博客园 (cnblogs.com)
https://www.cnblogs.com/fengxiaojiu/p/7994124.htmlC#中字段、属性、只读、构造函数赋值、反射赋值的相关 - GetPower - 博客园 (cnblogs.com)
https://www.cnblogs.com/gdpw/p/9463145.html