/// <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);
}
