/// <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)); }