如何使用实体框架核心在角度上进行服务器端分页

debugcn 发表于 Dev

用户名

我跳过并获取Controller类中的数据，如何对角进行分页

我的控制器班

public IEnumerable<ScrapeTime> scrapeTime(int? page, int pagesize=10)
  {
var countDetails = _context.ScrapeTime.Count();
 return _context.ScrapeTime.Skip((page ?? 0) * pagesize).Take(pagesize).ToList();
}

我的component.ts文件

constructor(http: HttpClient,  @Inject('BASE_URL') baseUrl: string) {

      http.get<scrapeTime[]>(baseUrl + 'api/ScrapeTime/ScrapeTime').subscribe(result => {

        this.Time = result;

      }, error => console.error(error));
  }

输出将仅在一侧显示10个数据，我需要对所有数据进行分页。

爱德华

请按照以下步骤实现您的要求：

定义一个模型，该模型将返回项目数和项目详细信息：

public class PageResult<T>
{
    public int Count { get; set; }
    public int PageIndex { get; set; }
    public int PageSize { get; set; }
    public List<T> Items { get; set; }
}

控制器动作

public PageResult<ScrapeTime> scrapeTime(int? page, int pagesize = 10)
{
    var countDetails = _context.ScrapeTime.Count();
    var result = new PageResult<ScrapeTime> {
        Count = countDetails,
        PageIndex = page ?? 1,
        PageSize = 10,
        Items = _context.ScrapeTime.Skip((page - 1 ?? 0) * pagesize).Take(pagesize).ToList()
    };
    return result;
}

角度模型

class PageResult<T>
{
    count: number;
    pageIndex: number;
    pageSize: number;
    items: T[];
}

角动作

export class FetchDataComponent {
private http: HttpClient;
private baseUrl: string;
public Time: scrapeTime[];
public pageNumber: number = 1;
public Count: number;
constructor(http: HttpClient, @Inject('BASE_URL') baseUrl: string) {
    this.http = http;
    this.baseUrl = baseUrl;

    http.get<PageResult<scrapeTime>>(baseUrl + 'api/ScrapeTime/ScrapeTime').subscribe(result => {
    this.Time = result.items;
    this.pageNumber = result.pageIndex;
    this.Count = result.count;
    }, error => console.error(error));
}

public onPageChange = (pageNumber) => {
    this.http.get<PageResult<scrapeTime>>(this.baseUrl + 'api/ScrapeTime/ScrapeTime?page=' + pageNumber).subscribe(result => {
    this.Time = result.items;
    this.pageNumber = result.pageIndex;
    this.Count = result.count;
    }, error => console.error(error));
}
}

视图

<table>
    <tr *ngFor="let item of Time | paginate: { itemsPerPage: 10, currentPage: pageNumber, totalItems:Count }">
        <!-- content here -->
        <td>{{ item.id }}</td>
        <td>{{ item.name }}</td>
    </tr>
    <pagination-controls (pageChange)="onPageChange($event)"></pagination-controls>
</table>

如果您对角度分页有任何疑问，请遵循ngx-pagination

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。