首页 > 解决方案 > 在 asp.net core 中将分页添加到剃刀视图

问题描述

我一直在关注我在 microsoft 找到的一篇关于如何在 c# 中向项目添加分页的简单文章。这是文章:https ://docs.microsoft.com/en-us/aspnet/core/data/ef-mvc/sort-filter-page?view=aspnetcore-2.1

现在,在阅读这篇文章时,当我想将数据传递给视图时,最后遇到了一个问题。让我分享一些我的代码,以便你们更好地理解它:

我从 microsft 获得的分页列表:

    public class PaginatedList<T> : List<T>
    {
        public int PageIndex { get; private set; }
        public int TotalPages { get; private set; }

        public PaginatedList(List<T> items, int count, int pageIndex, int pageSize)
        {
            PageIndex = pageIndex;
            TotalPages = (int)Math.Ceiling(count / (double)pageSize);

            this.AddRange(items);
        }

        public bool HasPreviousPage
        {
            get
            {
                return (PageIndex > 1);
            }
        }

        public bool HasNextPage
        {
            get
            {
                return (PageIndex < TotalPages);
            }
        }

        public static async Task<PaginatedList<T>> CreateAsync(IQueryable<T> source, int pageIndex, int pageSize)
        {
            var count = await source.CountAsync();
            var items = await source.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToListAsync();
            return new PaginatedList<T>(items, count, pageIndex, pageSize);
        }
    }

我使用的控制器上的方法:

    [HttpGet("search/{option?}/{search}")]
    public  IActionResult GetSearchData(string option, string search, int? page, string currentFilter)
    {
        if (search != null)
        {
            page = 1;
        }
        else
        {
            search = currentFilter;
        }
        SearchViewModel data = new SearchViewModel();

        var searchArticle = Mapper.Map<IEnumerable<SearchDataItemViewModel>>(_unitOfWork.Articles.GetByString(search));
        data.SearchArticle = searchArticle;

        var searchArticle2 = Mapper.Map<IEnumerable<SearchDataItemViewModel>>(_unitOfWork.Articles2.GetByString(search));
        data.SearchArticle2 = searchArticle2;

        var searchArticle3 = Mapper.Map<IEnumerable<SearchDataItemViewModel>>(_unitOfWork.Articles3.GetByString(search));
        data.SearchArticle3 = searchArticle3;

        var searchArticle4 = Mapper.Map<IEnumerable<SearchDataItemViewModel>>(_unitOfWork.Articles4.GetByString(search));
        data.SearchArticle4 = searchArticle4;

        int pageSize = 10;
        //return View("Search", Helpers.PaginatedList<SearchDataItemViewModel>.CreateAsync(data, page ?? 1, pageSize));
        //this is where I got an error
    }

我得到的错误是:

参数 1:无法从 'Website.ViewModels.SearchViewModel' 转换为 System.Linq.IQueryable< Website.ViewModels.SearchDataItemViewModel >

这也是我的一个查询的示例:

    public IEnumerable<Article2> GetByString(string word)
    {
        IEnumerable<Article2> article2 = _appContext.Article2
            .Include(t => t.ParentPage)
            .Where(t => t.Status == RecordStatus.Enabled && (t.Name.Contains(word) || t.Description.Contains(word)));
        return article2;
    } 

我实际上理解这意味着什么,但是如何在视图上传递“数据”变量以便我可以使用它?
我有点卡在这里,所以任何帮助的人都会受到高度赞赏。至少给我指出正确的方向或其他东西。

谢谢你的时间!!!

标签: c#entity-frameworkasp.net-corelinq-to-entitiesentity-framework-core

解决方案


在您的 Linq 语句中,您缺少指定如何选择以便它返回一个 Linq 对象;而不是 Article2 对象;应该是这样的:

  public IEnumerable<Article2> GetByString(string word)
{
    IEnumerable<Article2> article2 = _appContext.Article2
        .Include(t => t.ParentPage)
        .Where(t => t.Status == RecordStatus.Enabled && (t.Name.Contains(word) || t.Description.Contains(word))).ToList();
    return article2;
} 

添加ToList()


推荐阅读