这是我的查询:
var results = tcs.Skip(searchModel.PageSize * (searchModel.Page - 1))
.Take(searchModel.PageSize)
.AsEnumerable()
.Select(x => new
{
trackId = x.TrackId,
trackName = x.TrackName,
category = _weCategoryService.FindAll().Where(y => y.WorkExperience_Track.TrackId == x.TrackId)
.Select(y => new {
categoryId = y.CategoryId,
categoryName = y.CategoryName,
skill = _skillsService.FindAll().Where(z => z.CategoryId == y.CategoryId)
.Select(z => new {
skillId = z.SkillId,
skillName = z.SkillName
}).OrderBy(z => z.skillName).ToList()
}).OrderBy(y => y.categoryName).ToList()
}).OrderBy(x => x.trackName).ToList();
我有一个模型,其中包含布尔值SortTrack
、SortCategory
和SortSkills
。
如果布尔值为true,则按升序排序;如果为false,则按降序排序。
如何实现?