/// <summary> /// 查询建议增加的菜 /// </summary> /// <param name="suggestFoodSearchViewModel"></param> /// <returns></returns> public List <SuggestFoodSearchMiddleModel> SuggestFood_Search(SuggestFoodSearchViewModel suggestFoodSearchViewModel) { List <Suggest_Food> suggestFood = _IFoodInfoRepository.SearchSuggestFoodInfoByWhere(suggestFoodSearchViewModel); var suggestFood_Info = _IMapper.Map <List <Suggest_Food>, List <SuggestFoodSearchMiddleModel> >(suggestFood); return(suggestFood_Info); }
public List <Suggest_Food> SearchSuggestFoodInfoByWhereNum(SuggestFoodSearchViewModel suggestFoodSearchViewModel) { //查询条件 var predicate = SearchSuggestFoodWhere(suggestFoodSearchViewModel); var result = DbSet3.Where(predicate).OrderByDescending(a => a.AddDate).ToList(); return(result); }
public ActionResult <SuggestFoodSearchResModel> Manage_Suggest_Search_Food(SuggestFoodSearchViewModel suggestFoodSearchViewModel) { SuggestFoodSearchResModel suggestFoodSearchResModel = new SuggestFoodSearchResModel(); var BusSearchResult = _foodService.SuggestFood_Search(suggestFoodSearchViewModel); var TotalNum = _foodService.SuggesttFood_Get_ALLNum(suggestFoodSearchViewModel); suggestFoodSearchResModel.suggest_Foods = BusSearchResult; suggestFoodSearchResModel.IsSuccess = true; suggestFoodSearchResModel.baseViewModel.Message = "查询成功"; suggestFoodSearchResModel.baseViewModel.ResponseCode = 200; suggestFoodSearchResModel.TotalNum = TotalNum; _ILogger.Information("查询意见箱表单信息成功"); return(Ok(suggestFoodSearchResModel)); }
public List <Suggest_Food> SearchSuggestFoodInfoByWhere(SuggestFoodSearchViewModel suggestFoodSearchViewModel) { //查询条件 int SkipNum = suggestFoodSearchViewModel.pageViewModel.CurrentPageNum * suggestFoodSearchViewModel.pageViewModel.PageSize; //查询条件 var predicate = SearchSuggestFoodWhere(suggestFoodSearchViewModel); var result = DbSet3.Where(predicate).OrderByDescending(a => a.AddDate) .Skip(SkipNum) .Take(suggestFoodSearchViewModel.pageViewModel.PageSize) .ToList(); return(result); }
//根据条件查询建议添加的菜 private Expression <Func <Suggest_Food, bool> > SearchSuggestFoodWhere(SuggestFoodSearchViewModel suggestFoodSearchViewModel) { var predicate = WhereExtension.True <Suggest_Food>();//初始化where表达式 predicate = predicate.And(p => p.User_Info.UserName.Contains(suggestFoodSearchViewModel.userName)); if (suggestFoodSearchViewModel.User_DepartId != null) { predicate = predicate.And(p => p.User_Info.User_DepartId == suggestFoodSearchViewModel.User_DepartId); } if (suggestFoodSearchViewModel.strDate != null && suggestFoodSearchViewModel.endDate != null) { predicate = predicate.And(p => p.AddDate >= suggestFoodSearchViewModel.strDate && p.AddDate <= suggestFoodSearchViewModel.endDate); } predicate = predicate.And(p => p.isDelete == "0"); return(predicate); }
/// <summary> /// 查询建议增加的菜数量 /// </summary> /// <param name="suggestFoodSearchViewModel"></param> /// <returns></returns> public int SuggesttFood_Get_ALLNum(SuggestFoodSearchViewModel suggestFoodSearchViewModel) { return(_IFoodInfoRepository.SearchSuggestFoodInfoByWhereNum(suggestFoodSearchViewModel).Count()); }