public List <Family> Get(FamilyQueryDto condition)
{
IQueryable <Family> query = _repository.Query();
if (condition.FamilyCode != null && condition.FamilyCode.Trim() != "")
{
query = query.Where(Family => Family.FamilyCode.Contains(condition.FamilyCode));
}
if (condition.HousingArea != null)
{
query = query.Where(Family => Family.HousingArea == condition.HousingArea);
}
if (condition.Householder != null && condition.Householder.Trim() != "")
{
query = query.Where(Family => Family.Householder.Contains(condition.Householder));
}
if (condition.VillageName != null && condition.VillageName.Trim() != "")
{
query = query.Where(Family => Family.VillageName.Contains(condition.VillageName));
}
if (condition.VillageGroupCode != null && condition.VillageGroupCode.Trim() != "")
{
query = query.Where(Family => Family.VillageGroupCode.Contains(condition.VillageGroupCode));
}
if (condition.AccountCharacter != null && condition.AccountCharacter.Trim() != "")
{
query = query.Where(Family => Family.AccountCharacter.Contains(condition.AccountCharacter));
}
if (condition.PeopleNumber != null)
{
query = query.Where(Family => Family.PeopleNumber == condition.PeopleNumber);
}
if (condition.IsLowIncome != null)
{
query = query.Where(Family => Family.IsLowIncome == condition.IsLowIncome);
}
if (condition.IsPoor != null)
{
query = query.Where(Family => Family.IsPoor == condition.IsPoor);
}
if (condition.AverageHousingArea != null)
{
query = query.Where(Family => Family.AverageHousingArea == condition.AverageHousingArea);
}
if (condition.AverageAnnualIncome != null)
{
query = query.Where(Family => Family.AverageAnnualIncome == condition.AverageAnnualIncome);
}
return(query.ToList());
}
public async Task <JsonResult> GetAsync([FromQuery] FamilyQueryDto condition, int?pageIndex, int?pageSize)
{
if (pageIndex == null || pageSize == null)
{
if (condition.AccountCharacter != null ||
condition.PeopleNumber != null ||
condition.AverageAnnualIncome != null ||
condition.AverageHousingArea != null ||
condition.FamilyCode != null ||
condition.Householder != null ||
condition.HousingArea != null ||
condition.IsLowIncome != null ||
condition.IsPoor != null ||
condition.VillageGroupCode != null ||
condition.VillageName != 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 <Family> Search(FamilyQueryDto condition)
{
return(_domain.Get(condition));
}
