using FlexJobApi.Core;
|
using Furion.DatabaseAccessor;
|
using Mapster;
|
using MediatR;
|
using Microsoft.EntityFrameworkCore;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace FlexJobApi.Application
|
{
|
/// <summary>
|
/// 查询字典类别分页列表数据
|
/// </summary>
|
public class GetDictionaryCategoriesQueryHandler(
|
IRepository<DictionaryCategory> rep
|
) : IRequestHandler<GetDictionaryCategoriesQuery, PagedListQueryResult<GetDictionaryCategoriesQueryResultItem>>
|
{
|
private readonly IRepository<DictionaryCategory> rep = rep;
|
|
public async Task<PagedListQueryResult<GetDictionaryCategoriesQueryResultItem>> Handle(GetDictionaryCategoriesQuery request, CancellationToken cancellationToken)
|
{
|
var q = rep.AsQueryable().AsNoTracking()
|
.OrderBy(it => it.Sort).ThenBy(it => it.CreatedTime)
|
.AsQueryable();
|
if (request.Keywords.IsNotNull())
|
{
|
q = q.Where(it =>
|
it.Code.Contains(request.Keywords) ||
|
it.Name.Contains(request.Keywords) ||
|
it.Remark.Contains(request.Keywords));
|
}
|
var result = await q
|
.ProjectToType<GetDictionaryCategoriesQueryResultItem>()
|
.ToPagedListAsync(request.PageModel, cancellationToken);
|
return result;
|
}
|
}
|
}
|