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