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