/// <summary>
/// 根据条件查询计划,返回查询的实体列表
/// </summary>
/// <param name="mSearchMember">员工查询类对象</param>
/// <returns></returns>
public async Task <IEnumerable <MemberHolidayEntity> > GetEntitiesAsync(MemberHolidaySearch SearchCondition)
{
IQueryable <MemberHolidayEntity> Items = _GhDbContext.dsMemberHoliday.AsNoTracking() as IQueryable <MemberHolidayEntity>;
if (SearchCondition != null && !string.IsNullOrWhiteSpace(SearchCondition.UserId))
{
if (!string.IsNullOrWhiteSpace(SearchCondition.Id))
{
Items = Items.Where(e => e.Id.Equals(SearchCondition.Id, StringComparison.Ordinal));//对两个字符串进行byte级别的比较,性能好、速度快。
}
if (SearchCondition.OccurYear != 0)
{
Items = Items.Where(e => e.BeginDate.Year.Equals(SearchCondition.OccurYear));//对两个字符串进行byte级别的比较,性能好、速度快。
}
if (!string.IsNullOrWhiteSpace(SearchCondition.MemberId))
{
Items = Items.Where(e => e.MemberId.Equals(SearchCondition.MemberId, StringComparison.Ordinal));//对两个字符串进行byte级别的比较,性能好、速度快。
}
if (!string.IsNullOrWhiteSpace(SearchCondition.Remark))
{
Items = Items.Where(e => e.Remark.Contains(SearchCondition.Remark, StringComparison.Ordinal));//对两个字符串进行byte级别的比较,性能好、速度快。
}
return(await Items.ToListAsync().ConfigureAwait(false));
}
return(new List <MemberHolidayEntity>());
}
public PageViewModel()
{
SearchCondition = new MemberHolidaySearch()
{
UserId = AppSet.LoginUser.Id,
OccurYear = DateTime.Now.Year
};
CanOperation = false;
CurMember = null;
MemberHolidays = new ObservableCollection <Lib.MemberHoliday>();
}
public async Task <IEnumerable <MemberHolidayEntity> > GetAsync([FromQuery] MemberHolidaySearch SearchCondition)
{
return(await _DataRepository.GetEntitiesAsync(SearchCondition).ConfigureAwait(false));
}
