ASP.NET Core分页和筛选
创始人
2024-09-15 20:30:20
0

下面是一个使用ASP.NET Core实现分页和筛选的示例代码:

  1. 创建一个名为Product的模型类,包含IdNamePrice属性:
public class Product
{
    public int Id { get; set; }
    public string Name { get; set; }
    public decimal Price { get; set; }
}
  1. Startup.cs文件的ConfigureServices方法中注册数据库上下文和分页器:
public void ConfigureServices(IServiceCollection services)
{
    services.AddDbContext(options =>
        options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection")));

    services.AddMvc();
    services.AddRazorPages();

    services.AddScoped, ProductRepository>();
    services.AddSingleton();

    services.AddPaging(options =>
    {
        options.ViewName = "Bootstrap4";
        options.HtmlIndicatorDown = " ";
        options.HtmlIndicatorUp = " ";
        options.HtmlIndicatorNeutral = " ";
    });
}
  1. 创建一个名为ProductRepository的数据访问类,实现IRepository接口,用于获取产品数据:
public class ProductRepository : IRepository
{
    private readonly ApplicationDbContext _dbContext;

    public ProductRepository(ApplicationDbContext dbContext)
    {
        _dbContext = dbContext;
    }

    public IEnumerable GetAll()
    {
        return _dbContext.Products.ToList();
    }
}
  1. 创建一个名为ProductController的控制器类,用于处理分页和筛选请求:
public class ProductController : Controller
{
    private readonly IRepository _productRepository;

    public ProductController(IRepository productRepository)
    {
        _productRepository = productRepository;
    }

    public IActionResult Index(int page = 1, string sortBy = "Id", string search = "")
    {
        var products = _productRepository.GetAll();

        if (!string.IsNullOrEmpty(search))
        {
            products = products.Where(p => p.Name.Contains(search));
        }

        switch (sortBy)
        {
            case "Name":
                products = products.OrderBy(p => p.Name);
                break;
            case "Price":
                products = products.OrderBy(p => p.Price);
                break;
            default:
                products = products.OrderBy(p => p.Id);
                break;
        }

        var pager = new Pager(products.Count(), page);

        var viewModel = new ProductViewModel
        {
            Products = products.Skip((pager.CurrentPage - 1) * pager.PageSize).Take(pager.PageSize),
            Pager = pager,
            SortBy = sortBy,
            Search = search
        };

        return View(viewModel);
    }
}
  1. 创建一个名为ProductViewModel的视图模型类,包含ProductsPagerSortBySearch属性:
public class ProductViewModel
{
    public IEnumerable Products { get; set; }
    public Pager Pager { get; set; }
    public string SortBy { get; set; }
    public string Search { get; set; }
}
  1. 创建一个名为Index.cshtml的视图文件,用于显示产品列表和分页控件:
@model ProductViewModel

@{
    ViewData["Title"] = "Products";
}

Products

@foreach (var product in Model.Products) { }
Id Name Price
@product.Id @product.Name @product.Price
@Html.Pager(Model.Pager, new { sortBy = Model.SortBy, search =

相关内容

热门资讯

记者揭秘!智星菠萝辅助(透视辅... 记者揭秘!智星菠萝辅助(透视辅助)拱趴大菠萝辅助神器,扑克教程(有挂细节);模式供您选择,了解更新找...
一分钟揭秘!约局吧能能开挂(透... 一分钟揭秘!约局吧能能开挂(透视辅助)hhpoker辅助靠谱,2024新版教程(有挂教学);约局吧能...
透视辅助!wepoker模拟器... 透视辅助!wepoker模拟器哪个好用(脚本)hhpoker辅助挂是真的,科技教程(有挂技巧);囊括...
透视代打!hhpkoer辅助器... 透视代打!hhpkoer辅助器视频(辅助挂)pokemmo脚本辅助,2024新版教程(有挂教程);风...
透视了解!约局吧德州真的有透视... 透视了解!约局吧德州真的有透视挂(透视脚本)德州局HHpoker透视脚本,必胜教程(有挂分析);亲,...
六分钟了解!wepoker挂底... 六分钟了解!wepoker挂底牌(透视)德普之星开辅助,详细教程(有挂解密);德普之星开辅助是一种具...
9分钟了解!wpk私人辅助(透... 9分钟了解!wpk私人辅助(透视)hhpoker德州透视,插件教程(有挂教学);风靡全球的特色经典游...
推荐一款!wepoker究竟有... 推荐一款!wepoker究竟有透视(脚本)哈糖大菠萝开挂,介绍教程(有挂技术);囊括全国各种wepo...
每日必备!wepoker有人用... 每日必备!wepoker有人用过(脚本)wpk有那种辅助,线上教程(有挂规律);wepoker有人用...
玩家必备教程!wejoker私... 玩家必备教程!wejoker私人辅助软件(脚本)哈糖大菠萝可以开挂,可靠技巧(有挂神器)申哈糖大菠萝...