/// <summary> /// 修改实体,先查询出实体后修改 /// </summary> /// <param name="t"></param> /// <returns></returns> public int Update(T t) { T domain = Context.Set <T>().Attach(t); Context.Entry <T>(t).State = EntityState.Modified; return(Context.SaveChanges()); }
/// <summary> /// 修改菜单 默认是修改全部 /// </summary> /// <param name="dishes"></param> /// <returns></returns> public int ModityDishes(Dishes dishes) { using (HotelDBEntities db = new HotelDBEntities()) { db.Entry <Dishes>(dishes).State = EntityState.Modified; return(db.SaveChanges()); } }
//添加招聘信息 public int AddRecruitment(Recruitment rec) { using (HotelDBEntities db = new HotelDBEntities()) { db.Entry <Recruitment>(rec).State = EntityState.Added; return(db.SaveChanges()); } }
//添加新闻 public int AddNews(News news) { using (HotelDBEntities db = new HotelDBEntities()) { db.Entry <News>(news).State = EntityState.Added; return(db.SaveChanges()); } }
///<summary> ///修改招聘信息,默认修改该记录得所有信息 ///<summary> public int ModifyRecruitment(Recruitment recruitment) { using (HotelDBEntities hdb = new HotelDBEntities()) { hdb.Entry <Recruitment>(recruitment).State = EntityState.Modified; return(hdb.SaveChanges()); } }
/// <summary> /// 修改招聘信息 /// </summary> /// <param name="recruitment"></param> /// <returns></returns> public int ModifyRecruiment(Recruitment recruitment) { using (HotelDBEntities db = new HotelDBEntities()) { db.Recruitment.Attach(recruitment); db.Entry <Recruitment>(recruitment).State = EntityState.Modified; return(db.SaveChanges()); } }
//添加订单(OrderStatus=0) public int AddDishesBook(DishesBook dishesBook) { dishesBook.OrderStatus = 0; using (HotelDBEntities db = new HotelDBEntities()) { db.Entry <DishesBook>(dishesBook).State = EntityState.Added; return(db.SaveChanges()); } }
//单个删除 public int DeleteDisheById(int disheId) { using (HotelDBEntities db = new HotelDBEntities()) { Dishes obj = new Dishes() { DishesId = disheId }; db.Entry <Dishes>(obj).State = EntityState.Deleted; return(db.SaveChanges()); } }
//批量删除招聘信息 public int DeleteRecruitment(int[] postId) { using (HotelDBEntities db = new HotelDBEntities()) { for (int i = 0; i < postId.Length; i++) { Recruitment rec = new Recruitment() { PostId = postId[i] }; db.Entry <Recruitment>(rec).State = EntityState.Deleted; } return(db.SaveChanges()); } }
//批量删除新闻 public int DeleteNews(int[] newId) { using (HotelDBEntities db = new HotelDBEntities()) { for (int i = 0; i < newId.Length; i++) { News news = new News() { NewsId = newId [i] }; db.Entry <News>(news).State = EntityState.Deleted; } return(db.SaveChanges()); } }
//批量删除菜品 public int DeleteDishes(int[] num) { using (HotelDBEntities db = new HotelDBEntities()) { for (int i = 0; i < num.Length; i++) { Dishes obj = new Dishes() { DishesId = i }; db.Entry <Dishes>(obj).State = EntityState.Deleted; } return(db.SaveChanges()); } }
/// <summary> /// 受理投诉 /// </summary> /// <param name="suggestionId"></param> /// <returns></returns> public int HandleSuggestion(int suggestionId) { //下面的方法,执行后,会出现错误:其他信息: 对一个或多个实体的验证失败。有关详细信息,请参阅“EntityValidationErrors”属性。 //using (HotelDBEntities db = new HotelDBEntities()) //{ // Suggestion suggestion = new Suggestion { SuggestionId = suggestionId }; // db.Suggestion.Attach(suggestion); // suggestion.StatusId =1;//处理投诉就是将投诉的这条数据状态改成1,这部分也可以在业务逻辑里面写 // return db.SaveChanges(); //} //错误原因:因为当时我们测试后台的时候,没有给Suggestion实体类添加MVC验证,而当我们添加后,如果更新实体必须给这些字段赋值 //也就是不允许直接更新部分字段(请学员可以先测试上面的方法,然后对比下面的解决办法) //解决方法:修改前,先查询对象,保证其他字段有数据,这样才能让模型验证通过 using (HotelDBEntities db = new HotelDBEntities()) { Suggestion suggestion = (from s in db.Suggestion where s.SuggestionId == suggestionId select s).FirstOrDefault(); db.Entry <Suggestion>(suggestion).State = EntityState.Modified; suggestion.StatusId = 1;//处理投诉就是将投诉的这条数据状态改成1 return(db.SaveChanges()); } }