/// <summary> /// 查询点赞数量 /// </summary> /// <param name="foodByFoodIdSearchViewModel"></param> /// <returns></returns> public List <FoodPraiseNumMiddlecs> RelateFoodToFoodIdSearch(PraiseNumSearchMiddlecs praiseNumSearchMiddlecs) { string foodtype = praiseNumSearchMiddlecs.FoodType; string foodName = praiseNumSearchMiddlecs.FoodName; string remark = praiseNumSearchMiddlecs.Remark; string WeekNumber = praiseNumSearchMiddlecs.WeekNumber; string year = praiseNumSearchMiddlecs.Year; List <FoodPraiseNumMiddlecs> fpnm = new List <FoodPraiseNumMiddlecs>(); var p = SearchFoodHPWhere(foodtype, foodName, remark, WeekNumber, year, "1"); var food = DbSet.Include(a => a.Food_Info) .Where(p) .GroupBy(m => new { m.Food_InfoId, m.Food_Info.FoodName, m.Food_Info.FoodType, m.Food_Info.Remark, m.Food_Info.Year, m.Food_Info.WeekNumber }) .Select(k => new { ft = k.Key.FoodType, //地点类型 rm = k.Key.Remark, //星期 fn = k.Key.FoodName, //菜名 FoodId = k.Key.Food_InfoId, //主键Id Year = k.Key.Year, //年份 WeekNumber = k.Key.WeekNumber, //周数 PraiseNum = k.Count() }).OrderByDescending(m => m.PraiseNum).ToList(); foreach (var temp in food) { fpnm.Add(new FoodPraiseNumMiddlecs() { Food_InfoId = temp.FoodId, FoodName = temp.fn, FoodType = temp.ft, Remark = temp.rm, Year = temp.Year, WeekNumber = temp.WeekNumber, PraiseNum = temp.PraiseNum }); } return(fpnm); }
/// <summary> /// 查询点赞数量 /// </summary> /// <param name="foodByFoodIdSearchViewModel"></param> /// <returns></returns> public List <FoodPraiseNumMiddlecs> RelateFoodToFoodIdSearch(PraiseNumSearchMiddlecs praiseNumSearchMiddlecs) { string foodtype = praiseNumSearchMiddlecs.FoodType; string foodName = praiseNumSearchMiddlecs.FoodName; string remark = praiseNumSearchMiddlecs.Remark; List <FoodPraiseNumMiddlecs> fpnm = new List <FoodPraiseNumMiddlecs>(); //var p = SearchFoodWhere(praiseNumSearchMiddlecs); var food = DbSet.Include(a => a.Food_Info) .Where(b => b.Food_Info.FoodType.Contains(foodtype) && b.Food_Info.FoodName.Contains(foodName) && b.Food_Info.Remark.Contains(remark) && b.status == null && b.User_Info.status == "0") .GroupBy(m => new { m.Food_InfoId, m.Food_Info.FoodName, m.Food_Info.FoodType, m.Food_Info.Remark }) .Select(k => new { ft = k.Key.FoodType, //地点类型 rm = k.Key.Remark, //星期 fn = k.Key.FoodName, //菜名 FoodId = k.Key.Food_InfoId, //主键Id PraiseNum = k.Count() }).OrderByDescending(m => m.PraiseNum).ToList(); foreach (var temp in food) { fpnm.Add(new FoodPraiseNumMiddlecs() { Food_InfoId = temp.FoodId, FoodName = temp.fn, FoodType = temp.ft, Remark = temp.rm, PraiseNum = temp.PraiseNum }); } return(fpnm); }
//根据条件查询部门 private Expression <Func <Food_Info, bool> > SearchFoodWhere(PraiseNumSearchMiddlecs praiseNumSearchMiddlecs) { var predicate = WhereExtension.True <Food_Info>();//初始化where表达式 predicate = predicate.And(p => p.FoodType == praiseNumSearchMiddlecs.FoodType); predicate = predicate.And(p => p.FoodName == praiseNumSearchMiddlecs.FoodName); predicate = predicate.And(p => p.Remark == praiseNumSearchMiddlecs.Remark); return(predicate); }
public ActionResult <FoodByFoodIdSearchResModel> Manage_CpNum_Search(PraiseNumSearchMiddlecs praiseNumSearchMiddlecs) { FoodByFoodIdSearchResModel foodIdSearchResModel = new FoodByFoodIdSearchResModel(); var BusSearchResult = _foodService.CpNumByFoodId(praiseNumSearchMiddlecs); foodIdSearchResModel.PraiseInfo = BusSearchResult; foodIdSearchResModel.IsSuccess = true; foodIdSearchResModel.baseViewModel.Message = "查询菜单差评数量成功"; foodIdSearchResModel.baseViewModel.ResponseCode = 200; foodIdSearchResModel.TotalNum = BusSearchResult.Count; _ILogger.Information(" 查询菜单差评数量,查询成功"); return(Ok(foodIdSearchResModel)); }
/// <summary> /// 差评数量 /// </summary> /// <param name="praiseNumSearchMiddlecs"></param> /// <returns></returns> public List <FoodPraiseNumMiddlecs> CpNumByFoodId(PraiseNumSearchMiddlecs praiseNumSearchMiddlecs) { List <FoodPraiseNumMiddlecs> fp = _IRelate_Food_UserRepository.RelateFoodToFoodIdCpSearch(praiseNumSearchMiddlecs); return(fp); }