public async Task <JsonResult> GetAsync([FromQuery] VillagerQueryDto condition, int?pageIndex, int?pageSize)
{
if (pageIndex == null || pageSize == null)
{
if (condition.AnnualIncomeFrom != null || condition.AnnualIncomeTo != null || condition.BirthdayFrom != null ||
condition.BirthdayTo != null || condition.Education != null || condition.Gender != null || condition.HavingCriminalRecord != null ||
condition.HavingIllegalRecord != null || condition.HomeAddress != null || condition.MaritalStatus != null || condition.Name != 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 <Villager> Get(VillagerQueryDto queryDto)
{
IQueryable <Villager> query = _repository.Query();
if (queryDto.Name != null && queryDto.Name != "")
{
query = query.Where(villager => villager.Name.Contains(queryDto.Name));
}
if (queryDto.HomeAddress != null && queryDto.HomeAddress != "")
{
query = query.Where(villager => villager.HomeAddress.Contains(queryDto.HomeAddress));
}
if (queryDto.AnnualIncomeFrom != null)
{
query = query.Where(villager => villager.AnnualIncome >= queryDto.AnnualIncomeFrom);
}
if (queryDto.AnnualIncomeTo != null)
{
query = query.Where(villager => villager.AnnualIncome <= queryDto.AnnualIncomeTo);
}
if (queryDto.Education != null && queryDto.Education != "")
{
query = query.Where(villager => villager.Education == queryDto.Education);
}
if (queryDto.Gender != null && queryDto.Gender != "")
{
query = query.Where(villager => villager.Gender == queryDto.Gender);
}
if (queryDto.HavingCriminalRecord != null)
{
query = query.Where(villager => villager.HavingCriminalRecord == queryDto.HavingCriminalRecord);
}
if (queryDto.HavingIllegalRecord != null)
{
query = query.Where(villager => villager.HavingIllegalRecord
== queryDto.HavingIllegalRecord);
}
if (queryDto.MaritalStatus != null && queryDto.MaritalStatus != "")
{
query = query.Where(villager => villager.MaritalStatus == queryDto.MaritalStatus);
}
if (queryDto.BirthdayFrom != null)
{
query = query.Where(villager => villager.Birthday >= queryDto.BirthdayFrom);
}
if (queryDto.BirthdayTo != null)
{
query = query.Where(villager => villager.Birthday <= queryDto.BirthdayTo);
}
return(query.ToList());
}
public List <Villager> Search(VillagerQueryDto condition)
{
return(_domain.Get(condition));
}
