Exemple #1
0
        /// <summary>
        /// 查询楼宇信息
        /// </summary>
        /// <param name="buildingSearchViewModel"></param>
        /// <returns></returns>
        public List <BuildingSearchMiddleViewModel> Building_Search(BuildingSearchViewModel buildingSearchViewModel)
        {
            var BuildingSearchResult      = _buildingRepository.BuildingSerachByWhere(buildingSearchViewModel).ToList();
            var BuildingSearchResultModel = _IMapper.Map <List <Building>, List <BuildingSearchMiddleViewModel> >(BuildingSearchResult);

            return(BuildingSearchResultModel);
        }
Exemple #2
0
        public int BuildingSerachByWhereCount(BuildingSearchViewModel buildingSearchViewModel)
        {
            var predicate = SearchBuildingWhere(buildingSearchViewModel);
            var result    = DbSet.Where(predicate).ToList().Count();

            return(result);
        }
Exemple #3
0
        //根据检索条件  统计有多少栋楼
        public int BuildingSerachByWhereBuildingNoCount(BuildingSearchViewModel buildingSearchViewModel)
        {
            var predicate = SearchBuildingWhere(buildingSearchViewModel);
            var result    = DbSet.Where(predicate).ToList()
                            .GroupBy(a => a.BuildingNo).Select(a => a.First()).ToList()
                            .Count();

            return(result);
        }
Exemple #4
0
        /// <summary>
        /// 查询住户数
        /// </summary>
        /// <param name="buildingSearchViewModel"></param>
        /// <returns></returns>
        public int HouseCountByWhere(BuildingSearchViewModel buildingSearchViewModel)
        {
            //查询条件
            var predicate = SearchHouseCountWhere(buildingSearchViewModel);
            var result    = DbSet
                            .Where(predicate).ToList().Count();

            return(result);
        }
        public IActionResult SearchResults(BuildingSearchViewModel model)
        {
            foreach (var modelState in ViewData.ModelState.Values)
            {
                foreach (ModelError error in modelState.Errors)
                {
                    var x = error;
                }
            }



            var filters = new List <Tuple <string, object> >();

            foreach (var property in model.GetType().GetProperties())
            {
                var value = property.GetValue(model);
                if (value == null)
                {
                    continue;
                }

                if (property.PropertyType == typeof(decimal?))
                {
                    if (property.Name.EndsWith("Low"))
                    {
                        filters.Add(new Tuple <string, object>($"{property.Name.Substring(0, property.Name.Length - 3)} > {{0}}", $"{(decimal)value}"));
                    }
                    else
                    {
                        filters.Add(new Tuple <string, object>($"{property.Name.Substring(0, property.Name.Length - 4)} < {{0}}", $"{(decimal)value}"));
                    }
                }

                if (property.PropertyType == typeof(DateTime?))
                {
                    if (property.Name.EndsWith("Start"))
                    {
                        filters.Add(new Tuple <string, object>($"{property.Name.Substring(0, property.Name.Length - 5)} > {{0}}", $"{(DateTime)value}"));
                    }
                    else
                    {
                        filters.Add(new Tuple <string, object>($"{property.Name.Substring(0, property.Name.Length - 3)} < {{0}}", $"{(DateTime)value}"));
                    }
                }

                if (property.PropertyType == typeof(string) && !string.IsNullOrEmpty(value.ToString().Trim()))
                {
                    filters.Add(new Tuple <string, object>($"{property.Name} LIKE {{0}}", $"%{value.ToString()}%"));
                }
            }

            var buildings = _buildingRepository.GetBuildings(filters);

            return(View("Index", buildings));
        }
Exemple #6
0
        public List <Building> BuildingSerachByWhere(BuildingSearchViewModel buildingSearchViewModel)
        {
            int SkipNum = buildingSearchViewModel.pageViewModel.CurrentPageNum * buildingSearchViewModel.pageViewModel.PageSize;
            //查询条件
            var predicate = SearchBuildingWhere(buildingSearchViewModel);
            var result    = DbSet.Where(predicate).ToList()
                            .Skip(SkipNum)
                            .Take(buildingSearchViewModel.pageViewModel.PageSize)
                            .OrderBy(a => a.AddTime).ToList();

            return(result);
        }
Exemple #7
0
        private Expression <Func <HouseInfo, bool> > SearchHouseCountWhere(BuildingSearchViewModel buildingSearchViewModel)
        {
            var predicate = WhereExtension.True <HouseInfo>();//初始化where表达式

            if (buildingSearchViewModel.Name != "")
            {
                predicate = predicate.And(p => p.Area.Equals(buildingSearchViewModel.Name));
            }


            return(predicate);
        }
 public IActionResult GetBuildingSearch([FromQuery] BuildingSearchViewModel building)
 {
     try
     {
         return(Ok(manager.GetBuildingSearch(building)));
     }
     catch (Exception ex)
     {
         Exception innerException = ex;
         while (innerException != null)
         {
             Log.Error(innerException.Message);
             Log.Error(innerException.StackTrace);
             innerException = ex.InnerException;
         }
         return(BadRequest(ex.Message));
     }
 }
Exemple #9
0
        //根据条件查询部门
        private Expression <Func <Building, bool> > SearchBuildingWhere(BuildingSearchViewModel buildingSearchViewModel)
        {
            var predicate = WhereExtension.True <Building>();//初始化where表达式

            //predicate = predicate.And(p => p.Name.ToString().Contains(buildingSearchViewModel.Name.ToString()));
            if (buildingSearchViewModel.Name != "")
            {
                predicate = predicate.And(p => p.Name.Contains(buildingSearchViewModel.Name));
            }
            if (buildingSearchViewModel.Id != null)
            {
                predicate = predicate.And(p => p.Id.Equals(buildingSearchViewModel.Id));
            }

            predicate = predicate.And(p => p.Status == "1");

            return(predicate);
        }
        public IEnumerable <BuildingOverviewItemViewModel> GetBuildingSearch(BuildingSearchViewModel buildingSearch)
        {
            using CampFinderDbContext context = dbContextFactory.CreateDbContext();
            IQueryable <Building> buildings = context.Buildings
                                              .Include(t => t.Reviews)
                                              .Include(t => t.Place);

            if (buildingSearch != null)
            {
                buildings = GetSearch(buildings, buildingSearch);
                if (buildingSearch.Beds)
                {
                    buildings = buildings.Where(b => b.Beds);
                }
                if (buildingSearch.KitchenGear)
                {
                    buildings = buildings.Where(b => b.KitchenGear);
                }
            }
            return(buildings.Select(b => mapper.Map <BuildingOverviewItemViewModel>(b)).ToList());
        }
        public ActionResult <BuildingSearchResViewModel> Manage_OpinionInfo_Search(BuildingSearchViewModel buildingSearchViewModel)
        {
            var SearchResult    = _buildingService.Building_Search(buildingSearchViewModel);
            int total           = _buildingService.Building_SearchCount(buildingSearchViewModel);
            int buildingNoCount = _buildingService.Building_SearchBuildingNoCount(buildingSearchViewModel);
            int unitNoCount     = _buildingService.Building_SearchUnitNoCount(buildingSearchViewModel);
            int houseNoCount    = _houseInfoService.HouseCountSearch(buildingSearchViewModel);

            var Actionresult = _buildingFactory.GetBuildingSearchResViewModel();

            Actionresult.baseViewModel.IsSuccess = true;
            Actionresult.Data                       = SearchResult;
            Actionresult.TotalCount                 = total;
            Actionresult.BuildingNoCount            = buildingNoCount;
            Actionresult.UnitNoCount                = unitNoCount;
            Actionresult.HouseNoCount               = houseNoCount;
            Actionresult.baseViewModel.Message      = "查询信息成功";
            Actionresult.baseViewModel.ResponseCode = 200;
            _ILogger.Information("查询信息成功");

            return(Ok(Actionresult));
        }
Exemple #12
0
 /// <summary>
 /// 根据小区名查 住户数量
 /// </summary>
 /// <param name="buildingSearchViewModel"></param>
 /// <returns></returns>
 public int HouseCountSearch(BuildingSearchViewModel buildingSearchViewModel)
 {
     return(_houseInfoRepository.HouseCountByWhere(buildingSearchViewModel));
 }
Exemple #13
0
 //单元数
 public int Building_SearchUnitNoCount(BuildingSearchViewModel buildingSearchViewModel)
 {
     return(_buildingRepository.BuildingSerachByWhereUnitNoCount(buildingSearchViewModel));
 }