//根据条件查小区
#region 查询条件
private Expression <Func <ResidentialArea, bool> > SearchAreaWhere(AreaSearchViewModel areaSearchViewModel)
{
var predicate = WhereExtension.True <ResidentialArea>();//初始化where表达式
if (areaSearchViewModel.Id != null)
{
predicate = predicate.And(p => p.Id.Equals(areaSearchViewModel.Id));
}
if (areaSearchViewModel.Name != "")
{
predicate = predicate.And(p => p.Name.ToString().Contains(areaSearchViewModel.Name.ToString()));
}
if (areaSearchViewModel.Developers != "")
{
predicate = predicate.And(p => p.Developers.Contains(areaSearchViewModel.Developers));
}
if (areaSearchViewModel.ConstructionTimeStart != null)
{
predicate = predicate.And(p => p.ConstructionTime > (areaSearchViewModel.ConstructionTimeStart));
}
if (areaSearchViewModel.ConstructionTimeEnd != null)
{
predicate = predicate.And(p => p.ConstructionTime < (areaSearchViewModel.ConstructionTimeEnd));
}
predicate = predicate.And(p => p.Status == "1");
return(predicate);
}
public int AreaSerachByWhereCount(AreaSearchViewModel areaSearchViewModel)
{
var predicate = SearchAreaWhere(areaSearchViewModel);
var result = DbSet.Where(predicate).ToList().Count();
return(result);
}
/// <summary>
/// 查询小区信息
/// </summary>
/// <param name="areaSearchViewModel"></param>
/// <returns></returns>
public List <AreaSearchMiddle> Area_Search(AreaSearchViewModel areaSearchViewModel)
{
var AreaSearchResult = _residentialAreaRepository.AreaSerachByWhere(areaSearchViewModel);
var AreaSearchResultModel = _IMapper.Map <List <ResidentialArea>, List <AreaSearchMiddle> >(AreaSearchResult);
return(AreaSearchResultModel);
}
public List <ResidentialArea> AreaSerachByWhere(AreaSearchViewModel areaSearchViewModel)
{
int SkipNum = areaSearchViewModel.pageViewModel.CurrentPageNum * areaSearchViewModel.pageViewModel.PageSize;
//查询条件
var predicate = SearchAreaWhere(areaSearchViewModel);
var result = DbSet.Where(predicate).ToList()
.Skip(SkipNum)
.Take(areaSearchViewModel.pageViewModel.PageSize)
.OrderBy(a => a.AddTime).ToList();
return(result);
}
public ActionResult <AreaSearchResModel> Manage_OpinionInfo_Search(AreaSearchViewModel areaSearchViewModel)
{
var SearchResult = _residentialAreaService.Area_Search(areaSearchViewModel);
int total = _residentialAreaService.Area_SearchCount(areaSearchViewModel);
var Actionresult = _areaFactory.GetAreaSearchResponseViewModel();
Actionresult.baseViewModel.IsSuccess = true;
Actionresult.Data = SearchResult;
Actionresult.TotalCount = total;
Actionresult.baseViewModel.Message = "查询信息成功";
Actionresult.baseViewModel.ResponseCode = 200;
_ILogger.Information("查询信息成功");
return(Ok(Actionresult));
}
public int Area_SearchCount(AreaSearchViewModel areaSearchViewModel)
{
return(_residentialAreaRepository.AreaSerachByWhereCount(areaSearchViewModel));
}
