/// 根据用户id和菜id 去关系表查差评 /// </summary> /// <param name="foodByUserSearchViewModel"></param> /// <returns></returns> public int SearchFoodCpInfoByWhere(FoodByUserAddCpViewModel foodByUserAddCpViewModel) { int userid = foodByUserAddCpViewModel.User_InfoId; int foodid = foodByUserAddCpViewModel.Food_InfoId; var queryResult = DbSet.Where(k => k.User_InfoId == userid && k.Food_InfoId == foodid && k.status == "2" && k.User_Info.status == "0").ToList(); return(queryResult.Count); }
/// <summary> /// 根据用户和菜单增加评价信息 /// </summary> /// <param name="foodByUserSearchViewMode"></param> /// <returns></returns> public int Food_Relate_User_ADD_Pj(FoodByUserAddCpViewModel foodByUserAddCpViewModel) { int count = _IRelate_Food_UserRepository.SearchFoodInfoByWhere(foodByUserAddCpViewModel); if (count > 0) { return(-1); } else { var node_Info = _IMapper.Map <FoodByUserAddCpViewModel, User_Relate_Food>(foodByUserAddCpViewModel); _IRelate_Food_UserRepository.Add(node_Info); _IRelate_Food_UserRepository.SaveChanges(); return(1); } }
public ActionResult <FoodByUserSearchResModel> Manage_FoodToUser_AddCp(FoodByUserAddCpViewModel foodByUserAddCpViewModel) { FoodByUserSearchResModel foodByUserSearchResModel = new FoodByUserSearchResModel(); int SearchRowNum = _foodService.Food_Relate_User_ADD_Pj(foodByUserAddCpViewModel); if (SearchRowNum > 0) { foodByUserSearchResModel.IsSuccess = true; foodByUserSearchResModel.TotalNum = SearchRowNum; foodByUserSearchResModel.baseViewModel.Message = "用户发表差评成功"; foodByUserSearchResModel.baseViewModel.ResponseCode = 200; _ILogger.Information("根据用户id和菜单id,用户发表差评成功"); return(Ok(foodByUserSearchResModel)); } else { foodByUserSearchResModel.IsSuccess = false; foodByUserSearchResModel.TotalNum = 0; foodByUserSearchResModel.baseViewModel.Message = "该用户对该菜发表过评价,因此用户发表差评失败"; foodByUserSearchResModel.baseViewModel.ResponseCode = 200; _ILogger.Information("根据用户id和菜单id,该用户对该菜发表过评价,因此用户发表差评失败"); return(Ok(foodByUserSearchResModel)); } }