public PageViewModel() { SearchCondition = new MemberScoreSearch() { UserId = AppSet.LoginUser.Id, OccurYear = DateTime.Now.Year }; CanOperation = false; CurMember = null; MemberScores = new ObservableCollection <Lib.MemberScore>(); }
/// <summary> /// 根据条件查询计划,返回查询的实体列表 /// </summary> /// <param name="mSearchMember">员工查询类对象</param> /// <returns></returns> public async Task <List <MemberScoreEntity> > GetEntitiesAsync(MemberScoreSearch SearchCondition) { List <MemberScoreEntity> RecordList = new List <MemberScoreEntity>(); IQueryable <MemberScoreEntity> Items = _GhDbContext.dsMemberScores.AsNoTracking() as IQueryable <MemberScoreEntity>; 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 (!string.IsNullOrWhiteSpace(SearchCondition.MemberId)) { Items = Items.Where(e => e.MemberId.Equals(SearchCondition.MemberId, StringComparison.Ordinal)); } if (!string.IsNullOrWhiteSpace(SearchCondition.ScoreType)) { Items = Items.Where(e => e.ScoreType.Equals(SearchCondition.ScoreType, StringComparison.Ordinal)); } if (!string.IsNullOrWhiteSpace(SearchCondition.ScoreUnitName)) { Items = Items.Where(e => e.ScoreUnitName.Equals(SearchCondition.ScoreUnitName, StringComparison.Ordinal)); } if (SearchCondition.OccurYear != 0) { Items = Items.Where(e => e.OccurDate.Year.Equals(SearchCondition.OccurYear)); } if (SearchCondition.OccurMonth != 0) { Items = Items.Where(e => e.OccurDate.Month.Equals(SearchCondition.OccurMonth)); } RecordList = await Items.OrderByDescending(x => x.UpDateTime).ToListAsync().ConfigureAwait(false); } return(RecordList); }
public async Task <List <MemberScoreEntity> > GetRecordsAsync([FromQuery] MemberScoreSearch SearchCondition) { return(await _DataRepository.GetEntitiesAsync(SearchCondition).ConfigureAwait(false)); }