.NET 分页

85 阅读1分钟

环境搭建

DeveloperSharp

image.png

测试

把数据库中存放的相关数据,全部读入代码/内存,再由代码对其进行分页操作

using DeveloperSharp.Extension;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;

namespace Page.Controllers
{
    [Route("api/[controller]/[action]")]
    [ApiController]
    public class PageDemo : ControllerBase
    {
        [HttpGet]
        public object returnPage()
        {

            List<User> userList = new List<User>();

            for (int i = 0; i < 100; i++)
            {
                User user = new User
                {
                    Name = "User " + (i + 1),
                    Age = i
                };

                userList.Add(user);
            }
            var Page1 = userList.PagePartition(10, 2);
            return Page1;

        }
    }
}

userList.PagePartition(10, 2):表示从第2页开始展示,每页展示10条数据

image.png

{
  "dataList": [
    {
      "name": "User 11",
      "age": 10
    },
    {
      "name": "User 12",
      "age": 11
    },
    {
      "name": "User 13",
      "age": 12
    },
    {
      "name": "User 14",
      "age": 13
    },
    {
      "name": "User 15",
      "age": 14
    },
    {
      "name": "User 16",
      "age": 15
    },
    {
      "name": "User 17",
      "age": 16
    },
    {
      "name": "User 18",
      "age": 17
    },
    {
      "name": "User 19",
      "age": 18
    },
    {
      "name": "User 20",
      "age": 19
    }
  ],
  "currentEndIndex": 20,
  "currentPageIndex": 2,
  "currentPageSize": 10,
  "currentStartIndex": 11,
  "pageSize": 10,
  "totalPageNumber": 10,
  "totalRecordNumber": 100
}