/// <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);
        }
Beispiel #2
0
        /// <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);
        }
Beispiel #3
0
        //根据条件查询部门
        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));
        }
Beispiel #5
0
        /// <summary>
        /// 差评数量
        /// </summary>
        /// <param name="praiseNumSearchMiddlecs"></param>
        /// <returns></returns>
        public List <FoodPraiseNumMiddlecs> CpNumByFoodId(PraiseNumSearchMiddlecs praiseNumSearchMiddlecs)
        {
            List <FoodPraiseNumMiddlecs> fp = _IRelate_Food_UserRepository.RelateFoodToFoodIdCpSearch(praiseNumSearchMiddlecs);

            return(fp);
        }