using FlexJobApi.Core;
|
using Furion.DatabaseAccessor;
|
using Furion.FriendlyException;
|
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 DictionaryDatasQueryHandler(
|
IRepository<DictionaryData> rep
|
) : IRequestHandler<GetDictionaryDatasQuery, PagedListQueryResult<GetDictionaryDatasQueryResultItem>>,
|
IRequestHandler<GetDictionaryDataSelectQuery, List<SelectQueryResultOption<Guid, GetDictionaryDataSelectQueryResultOption>>>
|
{
|
private readonly IRepository<DictionaryData> rep = rep;
|
|
/// <summary>
|
/// 获取数据字典分页列表数据
|
/// </summary>
|
/// <param name="request"></param>
|
/// <param name="cancellationToken"></param>
|
/// <returns></returns>
|
public Task<PagedListQueryResult<GetDictionaryDatasQueryResultItem>> Handle(GetDictionaryDatasQuery request, CancellationToken cancellationToken)
|
{
|
return request.PageModel.GetPagedListAsync<DictionaryData, GetDictionaryDatasQueryResultItem>(
|
q =>
|
{
|
q = q.OrderBy(it => it.Sort).ThenBy(it => it.CreatedTime);
|
if (request.CategoryId.HasValue)
|
{
|
q = q.Where(it => it.CategoryId == request.CategoryId);
|
}
|
else if (request.CategoryCode.IsNotNull())
|
{
|
q = q.Where(it => it.Category.Code == request.CategoryCode);
|
}
|
else
|
{
|
throw Oops.Oh(EnumErrorCodeType.s400, "请填写类别Id或编号");
|
}
|
if (request.Keywords.IsNotNull())
|
{
|
q = q.Where(it =>
|
it.Code.Contains(request.Keywords)
|
|| it.Content.Contains(request.Keywords)
|
|| it.Field1.Contains(request.Keywords)
|
|| it.Field2.Contains(request.Keywords)
|
|| it.Field3.Contains(request.Keywords)
|
|| it.Field4.Contains(request.Keywords)
|
|| it.Field5.Contains(request.Keywords));
|
}
|
return q;
|
}, cancellationToken: cancellationToken);
|
}
|
|
/// <summary>
|
/// 查询数据字典选择器
|
/// </summary>
|
/// <param name="request"></param>
|
/// <param name="cancellationToken"></param>
|
/// <returns></returns>
|
public Task<List<SelectQueryResultOption<Guid, GetDictionaryDataSelectQueryResultOption>>> Handle(GetDictionaryDataSelectQuery request, CancellationToken cancellationToken)
|
{
|
return request.GetSelect<DictionaryData, Guid, GetDictionaryDataSelectQueryResultOption>(
|
it => it.Id,
|
it => it.Content,
|
q =>
|
{
|
q = q
|
.OrderBy(it => it.Sort).ThenBy(it => it.CreatedTime)
|
.Where(it =>
|
it.ParentId == request.ParentId
|
&& !it.IsDisabled);
|
if (request.CategoryId.HasValue)
|
{
|
q = q.Where(it => it.CategoryId == request.CategoryId);
|
}
|
else if (request.CategoryCode.IsNotNull())
|
{
|
q = q.Where(it => it.Category.Code == request.CategoryCode);
|
}
|
else
|
{
|
throw Oops.Oh(EnumErrorCodeType.s400, "请填写类别Id或编号");
|
}
|
return q;
|
},
|
cancellationToken);
|
}
|
}
|
}
|