public int Food_Relate_User_Del(FoodByUserPraiseViewModel foodByUserSearchViewModelt) { int DelNum = _IRelate_Food_UserRepository .RelateFoodToUserDel(foodByUserSearchViewModelt); return(DelNum); }
//根据条件查询点赞 private Expression <Func <User_Relate_Food, bool> > SearchDelRelateWhere(FoodByUserPraiseViewModel foodByUserSearchViewModel) { var predicate = WhereExtension.True <User_Relate_Food>();//初始化where表达式 predicate = predicate.And(p => p.Food_InfoId == foodByUserSearchViewModel.Food_InfoId); predicate = predicate.And(p => p.User_InfoId == foodByUserSearchViewModel.User_InfoId); predicate = predicate.And(p => p.status == null); return(predicate); }
/// <summary> /// 根据用户id和菜id删 点赞 /// </summary> /// <param name="list"></param> /// <returns></returns> public int RelateFoodToUserDel(FoodByUserPraiseViewModel foodByUserSearchViewModel) { var preciate = SearchDelRelateWhere(foodByUserSearchViewModel); var temp = DbSet.Single(preciate); DbSet.Remove(temp); return(SaveChanges()); }
/// <summary> /// 根据用户id和菜id 去关系表查好评 /// </summary> /// <param name="foodByUserSearchViewModel"></param> /// <returns></returns> public int SearchFoodInfoByWhere(FoodByUserPraiseViewModel foodByUserSearchViewModel) { int userid = foodByUserSearchViewModel.User_InfoId; int foodid = foodByUserSearchViewModel.Food_InfoId; var queryResult = DbSet.Where(k => k.User_InfoId == userid && k.Food_InfoId == foodid && k.status == null && k.User_Info.status == "0").ToList(); return(queryResult.Count); }
/// <summary> /// 根据用户和菜单点赞 /// </summary> /// <param name="foodByUserSearchViewMode"></param> /// <returns></returns> public int Food_Relate_User(FoodByUserPraiseViewModel foodByUserSearchViewMode) { int count = _IRelate_Food_UserRepository.SearchFoodInfoByWhere(foodByUserSearchViewMode); if (count > 0) { int DelNum = _IRelate_Food_UserRepository .RelateFoodToUserDel(foodByUserSearchViewMode); return(0); } else { var node_Info = _IMapper.Map <FoodByUserPraiseViewModel, User_Relate_Food>(foodByUserSearchViewMode); _IRelate_Food_UserRepository.Add(node_Info); _IRelate_Food_UserRepository.SaveChanges(); return(1); } }
public ActionResult <FoodByUserSearchResModel> Manage_FoodToUser_Del(FoodByUserPraiseViewModel foodByUserPraiseViewModel) { FoodByUserSearchResModel foodByUserSearchResModel = new FoodByUserSearchResModel(); int SearchRowNum = _foodService.Food_Relate_User(foodByUserPraiseViewModel); 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)); } }