//根据条件查询菜单评价信息
private Expression <Func <User_Relate_Food, bool> > SearchFoodCPWhere(FoodByUserSearchCpViewModel foodByUserSearchCpViewModel)
{
var predicate = WhereExtension.True <User_Relate_Food>();//初始化where表达式
if (foodByUserSearchCpViewModel.User_InfoId != null)
{
predicate = predicate.And(p => p.User_InfoId == foodByUserSearchCpViewModel.User_InfoId.Value);
}
if (foodByUserSearchCpViewModel.Food_InfoId != null)
{
predicate = predicate.And(p => p.Food_InfoId == foodByUserSearchCpViewModel.Food_InfoId.Value);
}
predicate = predicate.And(p => p.status == foodByUserSearchCpViewModel.status);
predicate = predicate.And(p => p.User_Info.status == "0");
predicate = predicate.And(p => p.Food_Info.isDelete == "0");
if (foodByUserSearchCpViewModel.WeekNumber != "")
{
predicate = predicate.And(p => p.Food_Info.WeekNumber == foodByUserSearchCpViewModel.WeekNumber);
}
predicate = predicate.And(p => p.Food_Info.Year.Contains(foodByUserSearchCpViewModel.Year));
predicate = predicate.And(p => p.Food_Info.Remark.Contains(foodByUserSearchCpViewModel.Remark));
return(predicate);
}
/// <summary>
/// 根据用户和菜单查询差评信息
/// </summary>
/// <param name="foodByUserSearchCpViewModel"></param>
/// <returns></returns>
public List <FoodCpMiddlecs> Food_Relate_User_Search_CP(FoodByUserSearchCpViewModel foodByUserSearchCpViewModel)
{
List <User_Relate_Food> user_Relate_Foods = _IRelate_Food_UserRepository.SearchFoodInfoByWhere(foodByUserSearchCpViewModel);
var Cp_Info = _IMapper.Map <List <User_Relate_Food>, List <FoodCpMiddlecs> >(user_Relate_Foods);
return(Cp_Info);
}
/// <summary>
/// 根据用户id和菜id 去关系表查差评
/// </summary>
/// <param name="foodByUserSearchViewModel"></param>
/// <returns></returns>
public List <User_Relate_Food> SearchFoodInfoByWhere(FoodByUserSearchCpViewModel foodByUserSearchCpViewModel)
{
var preciate = SearchFoodCPWhere(foodByUserSearchCpViewModel);
var temp = DbSet.Where(preciate).Include(a => a.User_Info).ThenInclude(c => c.User_Depart)
.Include(b => b.Food_Info)
.ToList();
return(temp);
}
public ActionResult <FoodByUserSearchCpResModel> Manage_FoodToUser_Search_Cp(FoodByUserSearchCpViewModel foodByUserSearchCpViewModel)
{
FoodByUserSearchCpResModel foodByUserSearchCpResModel = new FoodByUserSearchCpResModel();
foodByUserSearchCpResModel.CpInfo = _foodService.Food_Relate_User_Search_CP(foodByUserSearchCpViewModel);
var TotalNum = _foodService.FoodCp_Get_ALLNum(foodByUserSearchCpViewModel);
foodByUserSearchCpResModel.IsSuccess = true;
foodByUserSearchCpResModel.TotalNum = TotalNum;
foodByUserSearchCpResModel.baseViewModel.Message = "查询用户发表的差评成功";
foodByUserSearchCpResModel.baseViewModel.ResponseCode = 200;
_ILogger.Information("查询用户发表的差评成功");
return(Ok(foodByUserSearchCpResModel));
}
//根据条件查询菜单评价信息
private Expression <Func <User_Relate_Food, bool> > SearchFoodCPWhere(FoodByUserSearchCpViewModel foodByUserSearchCpViewModel)
{
var predicate = WhereExtension.True <User_Relate_Food>();//初始化where表达式
if (foodByUserSearchCpViewModel.User_InfoId != null)
{
predicate = predicate.And(p => p.User_InfoId == foodByUserSearchCpViewModel.User_InfoId.Value);
}
if (foodByUserSearchCpViewModel.Food_InfoId != null)
{
predicate = predicate.And(p => p.Food_InfoId == foodByUserSearchCpViewModel.Food_InfoId.Value);
}
predicate = predicate.And(p => p.status == foodByUserSearchCpViewModel.status);
predicate = predicate.And(p => p.User_Info.status == "0");
return(predicate);
}
/// <summary>
/// 食物差评数量
/// </summary>
/// <param name="foodByUserSearchCpViewModel"></param>
/// <returns></returns>
public int FoodCp_Get_ALLNum(FoodByUserSearchCpViewModel foodByUserSearchCpViewModel)
{
return(_IRelate_Food_UserRepository.SearchFoodInfoByWhere(foodByUserSearchCpViewModel).Count());
}
