在ASP.NET Core MVC中进行筛选和排序可以使用LINQ(语言集成查询)和实体框架核心(EF Core)。首先,在控制器的操作方法中定义一个查询,这将是整个过滤和排序过程的基础。其次,使用LINQ构建筛选或排序查询,并通过使用Query Helpers将它们附加到查询中。最后,向视图传递查询结果并在视图中呈现。
以下实现代码示例演示了如何使用ASP.NET Core MVC进行筛选和排序:
//在控制器的操作方法中定义查询 public IActionResult Index(string sortOrder, string searchString) { //默认排序方法 sortOrder = String.IsNullOrEmpty(sortOrder) ? "name_desc" : sortOrder; //默认搜索字符串 searchString = String.IsNullOrEmpty(searchString) ? "" : searchString;
//构建查询
var students = from s in _context.Students
select s;
//筛选查询
if (!String.IsNullOrEmpty(searchString))
{
students = students.Where(s => s.Name.Contains(searchString));
}
//排序查询
switch (sortOrder)
{
case "name_desc":
students = students.OrderByDescending(s => s.Name);
break;
case "Date":
students = students.OrderBy(s => s.EnrollmentDate);
break;
case "date_desc":
students = students.OrderByDescending(s => s.EnrollmentDate);
break;
default:
students = students.OrderBy(s => s.Name);
break;
}
//把查询结果传递给视图呈现
return View(students.ToList());
}
//在视图中使用HTML辅助程序呈现查询结果
@model IEnumerable
@using (Html.BeginForm()) {
搜索: @Html.TextBox("SearchString")
}@Html.ActionLink("姓名", "Index", new { sortOrder = ViewBag.NameSortParm }) |
相关内容
|
---|