/// <summary>
/// 根据条件查询计划,返回查询的实体列表
/// </summary>
/// <param name="mSearchMember">员工查询类对象</param>
/// <returns></returns>
public async Task <List <MemberPayItemDto> > GetEntitiesAsync(MemberPayItemSearch SearchCondition)
{
IQueryable <MemberPayItemEntity> Items = _GhDbContext.dsMemberPayItem.AsNoTracking() as IQueryable <MemberPayItemEntity>;
if (SearchCondition != null && !string.IsNullOrWhiteSpace(SearchCondition.UserId))
{
if (!string.IsNullOrWhiteSpace(SearchCondition.Name))
{
Items = Items.Where(e => e.Name.Equals(SearchCondition.Name, StringComparison.Ordinal));//对两个字符串进行byte级别的比较,性能好、速度快。
}
if (!string.IsNullOrWhiteSpace(SearchCondition.PayUnitName))
{
Items = Items.Where(e => e.UnitName.Equals(SearchCondition.PayUnitName, StringComparison.Ordinal));//对两个字符串进行byte级别的比较,性能好、速度快。
}
if (!string.IsNullOrWhiteSpace(SearchCondition.InTableType))
{
Items = Items.Where(e => e.InTableType.Equals(SearchCondition.InTableType, StringComparison.Ordinal));//对两个字符串进行byte级别的比较,性能好、速度快。
}
if (!string.IsNullOrWhiteSpace(SearchCondition.InCardinality))
{
Items = Items.Where(e => e.InCardinality.Equals(SearchCondition.InCardinality, StringComparison.Ordinal));//对两个字符串进行byte级别的比较,性能好、速度快。
}
if (!string.IsNullOrWhiteSpace(SearchCondition.Name))
{
Items = Items.Where(e => e.Name.Equals(SearchCondition.Name, StringComparison.Ordinal));//对两个字符串进行byte级别的比较,性能好、速度快。
}
if (!string.IsNullOrWhiteSpace(SearchCondition.Remark))
{
Items = Items.Where(e => e.Remark.Contains(SearchCondition.Remark, StringComparison.Ordinal));//对两个字符串进行byte级别的比较,性能好、速度快。
}
var Entities = await Items.ToListAsync().ConfigureAwait(false);
return(_Mapper.Map <List <MemberPayItemDto> >(Entities));
}
return(new List <MemberPayItemDto>());
}
public async Task <ActionResult <List <MemberPayItemDto> > > GetAsync([FromQuery] MemberPayItemSearch SearchCondition)
{
return(await _PayRepository.GetEntitiesAsync(SearchCondition).ConfigureAwait(false));
}
