/// <summary>
/// 根据条件查询计划,返回查询的实体列表
/// </summary>
/// <param name="mSearchMember">员工查询类对象</param>
/// <returns></returns>
public async Task <List <MemberAppraiseDto> > GetEntitiesAsync(MemberAppraiseSearch SearchCondition)
{
IQueryable <MemberAppraiseEntity> Items = _GhDbContext.dsMemberAppraise.AsNoTracking() as IQueryable <MemberAppraiseEntity>;
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));//对两个字符串进行byte级别的比较,性能好、速度快。
}
if (!string.IsNullOrWhiteSpace(SearchCondition.Year))
{
Items = Items.Where(e => SearchCondition.Year.Equals(e.Year, StringComparison.Ordinal));
}
if (!string.IsNullOrWhiteSpace(SearchCondition.Result))
{
Items = Items.Where(e => SearchCondition.Result.Contains(e.Result, StringComparison.Ordinal));
}
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 <MemberAppraiseDto> >(Entities));
}
return(new List <MemberAppraiseDto>());
}
public async System.Threading.Tasks.Task InitVMAsync(Lib.MemberInfoEntity PMember)
{
CurMember = PMember;
if (PMember != null)
{
MemberAppraiseSearch SearchCondition = new MemberAppraiseSearch()
{
MemberId = PMember.Id, UserId = AppSet.LoginUser.Id
};
IEnumerable <MemberAppraise> MemberPrizePunishss = await DataMemberAppraiseRepository.GetRecords(SearchCondition);
CurRecords.Clear();
MemberPrizePunishss?.ToList().ForEach(e =>
{
CurRecords.Add(e);
});
}
}
public async Task <ActionResult <List <MemberAppraiseDto> > > GetAsync([FromQuery] MemberAppraiseSearch SearchCondition)
{
return(await _DataRepository.GetEntitiesAsync(SearchCondition).ConfigureAwait(false));
}
public CurUcViewModel()
{
CurRecords = new ObservableCollection <MemberAppraise>();
SearchCondition = new MemberAppraiseSearch();
}
