.net core 快速高性能分页

1年前 4,500 1

利用EF的skip和take实现性能分页，随着数据增多，比如50万，使用x.pagelist插件分页太慢。

代码示例：

var q = _dbcontext.Company.AsQueryable();

page = page ?? 1;

pageSize = pageSize ?? 10;

int count = q.Count();

ViewBag.Page = page;

ViewBag.PageSize = pageSize;

ViewBag.TotalCount = count;

ViewBag.TotalPage = (int)Math.Ceiling(count / (double)pageSize);

q = q.OrderByDescending(o => o.Id).Skip(((int)page - 1) * (int)pageSize).Take((int)pageSize);

return View(q);

前台view

var pageIndex = (int)ViewBag.Page;

var pageSize = (int)ViewBag.PageSize;

var totalPage = (int)ViewBag.TotalPage;

var totalCount = (int)ViewBag.TotalCount;

var homeDisabled = pageIndex > 1 ? "" : "disabled";

var prevDisabled = pageIndex > 1 ? "" : "disabled";

var nextDisabled = pageIndex >= totalPage ? "disabled" : "";

var lastDisabled = pageIndex >= totalPage ? "disabled" : "";

var allRoutes = new Dictionary<string, string>();

allRoutes.Add("Keywords", ViewBag.Keywords);

allRoutes.Add("Industry", ViewBag.Industry);

allRoutes.Add("CompanyType", ViewBag.CompanyType);

allRoutes.Add("BusinessScope", ViewBag.BusinessScope);

allRoutes.Add("LegalRepresentative", ViewBag.LegalRepresentative);

allRoutes.Add("BusinessStatus", ViewBag.BusinessStatus);

}

<span class="float-left" style="font-size:14px;padding:6px 10px 6px 0px;">共 @ViewBag.TotalCount 条</span>

<a asp-action="Index" asp-all-route-data="@allRoutes" asp-route-page="1"

asp-route-pageSize=@ViewBag.PageSize class="btn btn-default @homeDisabled">

首页

</a>

<a asp-action="Index" asp-all-route-data="@allRoutes" asp-route-page="@(pageIndex - 1)"

asp-route-pageSize=@ViewBag.PageSize class="btn btn-default @prevDisabled">

</a>

<a asp-action="Index" asp-all-route-data="@allRoutes" asp-route-page="@(pageIndex + 1)"

asp-route-pageSize=@ViewBag.PageSize

class="btn btn-default @nextDisabled">

</a>

<a asp-action="Index" asp-all-route-data="@allRoutes" asp-route-page="@totalPage"

asp-route-pageSize=@ViewBag.PageSize class="btn btn-default @lastDisabled">

末页

</a>

</div>

<span class="btn btn-info ml-5">第 @pageIndex / @totalPage 页</span>

</div>

具体根据情况修改代码

声明：本站内容来源于原创和互联网，尊重作者版权，转载请注明来源网址，欢迎收藏，谢谢！

.net core 快速高性能分页

1 条评论

发表评论取消回复

相关文章

1 条评论

发表评论 取消回复

发表评论取消回复