Код: Выделить всё
private AppDbContext db = new AppDbContext();
private IQueryable Broders;
public ViewResult Index(int? page)
{
Broders = from s in db.Broders select s;
if (SearchColumn == "T1")
{
Borders = Broders.Where(s => s.TagT1.ToString().Contains(searchString));
}
else if (SearchColumn == "T2")
{
Borders = Broders.Where(s => s.TagT2.ToString().Contains(searchString));
}
switch (sortOrder)
{
case "status_desc":
Borders = Borders.OrderByDescending(s => s.Status);
break;
case "status_desc":
Borders = Borders.OrderByDescending(s => s.Status);
break;
default:
Borders = Borders.OrderByDescending(s => s.CreatedOn);
break;
}
int pageSize = 10;
int pageNumber = (page ?? 1);
return View(Borders.ToPagedList(pageNumber, pageSize));
}
Код: Выделить всё
private readonly AppDbContext _context;
private IQueryable
Borders;
public async Task Index(int? page)
{
var Borders = await _context.Borders.ToListAsync();
if (SearchColumn == "T1")
{
Borders = (List)Broders.Where(s => s.TagT1.ToString().Contains(searchString));
}
else if (SearchColumn == "T2")
{
Borders = (List)Broders.Where(s => s.TagT2.ToString().Contains(searchString));
}
switch (sortOrder)
{
case "status_desc":
Borders = (List)Borders.OrderByDescending(s => s.Status);
break;
case "status_desc":
Borders = (List)Borders.OrderByDescending(s => s.Status);
break;
default:
Borders = (List)Borders.OrderByDescending(s => s.CreatedOn);
break;
}
int pageSize = 10;
int pageNumber = (page ?? 1);
return View(Borders.ToPagedList(pageNumber, pageSize));
}
InvalidCastException: невозможно привести объект типа «System.Linq» .OrderedEnumerable
Код: Выделить всё
2[Map.Models.Border,System.String]' to type 'System.Collections.Generic.List
в строке
Код: Выделить всё
Borders = (List)Borders.OrderByDescending(s => s.CreatedOn);
Подробнее здесь: https://stackoverflow.com/questions/786 ... edenumerab