public async Task <JsonResult> GetAsync([FromQuery] MemberQueryDto condition, int?pageIndex, int?pageSize)
{
if (pageIndex == null || pageSize == null)
{
if (condition.BirthdayFrom != null ||
condition.BirthdayTo != null ||
condition.DepartmentCode != null ||
condition.Education != null ||
condition.EntryTimeFrom != null ||
condition.EntryTimeTo != null ||
condition.Gender != null ||
condition.HomeAddress != null ||
condition.LengthOfService != null ||
condition.MaritalStatus != null ||
condition.MemberCode != null ||
condition.Nationality != null ||
condition.PersonnelNature != null ||
condition.PoliticalStatus != null ||
condition.Position != null ||
condition.Status != null
)
{
var list = _service.Search(condition);
return(new JsonResult(new
{
code = 20000,
list
}));
}
var items = await _service.GetAll();
return(new JsonResult(new
{
code = 20000,
items
}));
}
else
{
var items = await _service.GetPaginationAsync(pageIndex.Value, pageSize.Value);
return(new JsonResult(new
{
code = 20000,
items
}));
}
}
public List <Member> Search(MemberQueryDto condition)
{
return(_domain.Get(condition));
}
public List <Member> Get(MemberQueryDto condition)
{
IQueryable <Member> query = _repository.Query();
if (condition.MemberName != null && condition.MemberName.Trim() != "")
{
query = query.Where(Member => Member.MemberName.Contains(condition.MemberName));
}
if (condition.MemberCode != null && condition.MemberCode.Trim() != "")
{
query = query.Where(Member => Member.MemberCode.Contains(condition.MemberCode));
}
if (condition.HomeAddress != null && condition.HomeAddress.Trim() != "")
{
query = query.Where(Member => Member.HomeAddress.Contains(condition.HomeAddress));
}
if (condition.IdCardNumber != null && condition.IdCardNumber.Trim() != "")
{
query = query.Where(Member => Member.IdCardNumber.Contains(condition.IdCardNumber));
}
if (condition.MaritalStatus != null && condition.MaritalStatus.Trim() != "")
{
query = query.Where(Member => Member.MaritalStatus.Contains(condition.MaritalStatus));
}
if (condition.Nationality != null && condition.Nationality.Trim() != "")
{
query = query.Where(Member => Member.Nationality.Contains(condition.Nationality));
}
if (condition.PoliticalStatus != null && condition.PoliticalStatus.Trim() != "")
{
query = query.Where(Member => Member.PoliticalStatus.Contains(condition.PoliticalStatus));
}
if (condition.Position != null && condition.Position.Trim() != "")
{
query = query.Where(Member => Member.Position.Contains(condition.Position));
}
if (condition.Status != null && condition.Status.Trim() != "")
{
query = query.Where(Member => Member.Status.Contains(condition.Status));
}
if (condition.PersonnelNature != null && condition.PersonnelNature.Trim() != "")
{
query = query.Where(Member => Member.PersonnelNature.Contains(condition.PersonnelNature));
}
if (condition.Gender != null && condition.Gender.Trim() != "")
{
query = query.Where(Member => Member.Gender.Contains(condition.Gender));
}
if (condition.LengthOfService != null && condition.LengthOfService.Trim() != "")
{
query = query.Where(Member => Member.LengthOfService.Contains(condition.LengthOfService));
}
if (condition.BirthdayFrom != null)
{
query = query.Where(Member => Member.Birthday >= condition.BirthdayFrom);
}
if (condition.BirthdayTo != null)
{
query = query.Where(Member => Member.Birthday <= condition.BirthdayTo);
}
if (condition.LeaveTimeFrom != null)
{
query = query.Where(Member => Member.LeaveTime >= condition.LeaveTimeFrom);
}
if (condition.LeaveTimeTo != null)
{
query = query.Where(Member => Member.LeaveTime <= condition.LeaveTimeFrom);
}
if (condition.EntryTimeFrom != null)
{
query = query.Where(Member => Member.EntryTime >= condition.EntryTimeFrom);
}
if (condition.EntryTimeTo != null)
{
query = query.Where(Member => Member.EntryTime <= condition.EntryTimeTo);
}
return(query.ToList());
}
