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