/// <summary>
/// 添加实体到数据库
/// </summary>
/// <param name="t"></param>
/// <returns></returns>
///
public T Create(T t)
{
T domain = Context.Set <T>().Add(t);
Context.SaveChanges();
return(domain);
}
///<summary>
///发布招聘信息
///<summary>
public int PublishRecruitment(Recruitment recruitment)
{
using (HotelDBEntities hdb = new HotelDBEntities())
{
hdb.Recruitment.Add(recruitment);
return(hdb.SaveChanges());
}
}
/// <summary>
/// 提交投诉
/// </summary>
public int AddSuggestion(Suggestion suggestion)
{
using (HotelDBEntities db = new HotelDBEntities())
{
db.Suggestion.Add(suggestion);
return(db.SaveChanges());
}
}
/// <summary>
/// 发布招聘信息
/// </summary>
/// <param name="recruitment"></param>
/// <returns></returns>
public int AddRecruitment(Recruitment recruitment)
{
using (HotelDBEntities db = new HotelDBEntities())
{
db.Recruitment.Add(recruitment);
return(db.SaveChanges());
}
}
//添加招聘信息
public int AddRecruitment(Recruitment rec)
{
using (HotelDBEntities db = new HotelDBEntities())
{
db.Entry <Recruitment>(rec).State = EntityState.Added;
return(db.SaveChanges());
}
}
/// <summary>
/// 发布菜品
/// </summary>
/// <param name="dishes"></param>
/// <returns></returns>
public int AddDishes(Dishes dishes)
{
using (HotelDBEntities db = new HotelDBEntities())
{
db.Dishes.Add(dishes);
return(db.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());
}
}
///<summary>
///修改招聘信息，默认修改该记录得所有信息
///<summary>
public int ModifyRecruitment(Recruitment recruitment)
{
using (HotelDBEntities hdb = new HotelDBEntities())
{
hdb.Entry <Recruitment>(recruitment).State = EntityState.Modified;
return(hdb.SaveChanges());
}
}
//添加新闻
public int AddNews(News news)
{
using (HotelDBEntities db = new HotelDBEntities())
{
db.Entry <News>(news).State = EntityState.Added;
return(db.SaveChanges());
}
}
//添加菜品返回菜品的ID
public int ReturuDishesId(Dishes dish)
{
using (HotelDBEntities db = new HotelDBEntities())
{
db.Dishes.Add(dish);
db.SaveChanges();
return(dish.DishesId);//返回标识列的值
}
}
/// <summary>
/// 客户提交订单
/// </summary>
/// <param name="dishesBook"></param>
/// <returns></returns>
public int Book(DishesBook dishesBook)
{
dishesBook.OrderStatus = 0;//数据库默认值不起作用，需要在这个地方设置
using (HotelDBEntities db = new HotelDBEntities())
{
db.DishesBook.Add(dishesBook);
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());
}
}
/// <summary>
/// 提交投诉
/// </summary>
/// <param name="suggestion"></param>
/// <returns></returns>
public int SubmitSuggestion(Suggestion suggestion)
{
suggestion.SuggestionTime = DateTime.Now;//数据库默认值不起作用
using (HotelDBEntities db = new HotelDBEntities())
{
db.Suggestion.Add(suggestion);
return(db.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());
}
}
/// <summary>
/// 受理投诉
/// </summary>
/// 把受理投诉改为已受理。极为修改StatusId值。0>>1
public int ReciveSuggestion(int suggestionid)
{
using (HotelDBEntities db = new HotelDBEntities())
{
Suggestion Suggestion = new Suggestion();
Suggestion.SuggestionId = suggestionid;
db.Suggestion.Attach(Suggestion);
Suggestion.StatusId = 1;
return(db.SaveChanges());
}
}
//取消订单（OrderStatus=1）/关闭订单（OrderStatus=-1）
public int UpdateDishesBook(DishesBook obj)
{
using (HotelDBEntities db = new HotelDBEntities())
{
DishesBook book = new DishesBook();
book.BookId = obj.BookId;
db.DishesBook.Attach(book);
book.OrderStatus = obj.OrderStatus;
return(db.SaveChanges());
}
}
/// <summary>
/// 删除菜品
/// </summary>
/// <param name="dishesId"></param>
/// <returns></returns>
public int DeleteDishes(int dishesId)
{
Dishes dishes = new Dishes();
dishes.DishesId = dishesId;
using (HotelDBEntities db = new HotelDBEntities())
{
db.Dishes.Attach(dishes);
db.Dishes.Remove(dishes);
return(db.SaveChanges());
}
}
///<summary>
///删除招聘信息
///<summary>
public int DeleteRecruitment(int postid)
{
Recruitment recruitment = new Recruitment();
recruitment.PostId = postid;
using (HotelDBEntities hdb = new HotelDBEntities())
{
hdb.Recruitment.Attach(recruitment);
hdb.Recruitment.Remove(recruitment);
return(hdb.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());
}
}
/// <summary>
/// 删除招聘信息
/// </summary>
/// <param name="postId"></param>
/// <returns></returns>
public int DeleteRecruiment(int postId)
{
using (HotelDBEntities db = new HotelDBEntities())
{
Recruitment recruitment = new Recruitment {
PostId = postId
};
db.Recruitment.Attach(recruitment);
db.Recruitment.Remove(recruitment);
return(db.SaveChanges());
}
}
/// <summary>
/// 受理投诉
/// </summary>
/// <param name="suggestionId"></param>
/// <returns></returns>
public int HandleSuggestion(int suggestionId)
{
using (HotelDBEntities db = new HotelDBEntities())
{
Suggestion suggestion = new Suggestion {
SuggestionId = suggestionId
};
db.Suggestion.Attach(suggestion);
suggestion.StatusId = 1;
return(db.SaveChanges());
}
}
public int DeleteDishesBook(int bookId)
{
DishesBook dishesbook = new DishesBook();
dishesbook.BookId = bookId;
using (HotelDBEntities db = new HotelDBEntities())
{
db.DishesBook.Attach(dishesbook);
db.DishesBook.Remove(dishesbook);
return(db.SaveChanges());
}
}
//修改新闻
public int ModifyNews(News news)
{
using (HotelDBEntities db = new HotelDBEntities())
{
News obj = new News();
obj.NewsId = news.NewsId;
db.News.Attach(obj);
obj.CategoryId = news.CategoryId;
obj.NewsTitle = news.NewsTitle;
obj.NewsContents = news.NewsContents;
return(db.SaveChanges());
}
}
//修改状态
public int UpdateStatusId(Suggestion sug)
{
using (HotelDBEntities db = new HotelDBEntities())
{
Suggestion s = new Suggestion()
{
SuggestionId = sug.SuggestionId
};
db.Suggestion.Attach(s);
s.StatusId = sug.StatusId;
return(db.SaveChanges());
}
}
/// <summary>
/// 根据预定ID修改订单状态(审核通过,撤销,关闭-1)
/// </summary>
/// <param name="bookId"></param>
/// <param name="orderStatus"></param>
/// <returns></returns>
public int ModifyBook(int bookId, string orderStatus)
{
//方式1:封装一个实体类,所有字段都写上(最麻烦)
//方式2:查询到要修改的实体,然后修改对应的值(有一个查询的过程)
//方法3:创建一个对象-->给主键赋值-->附加到上下文-->给要修改的字段赋值-->提交保存
using (HotelDBEntities db = new HotelDBEntities())
{
DishesBook dishesBook = new DishesBook();
dishesBook.BookId = bookId;
db.DishesBook.Attach(dishesBook);
//下面写出要修改的字段,并赋值
dishesBook.OrderStatus = Convert.ToInt32(orderStatus);
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>
/// 根据预定ID修改订单状态（审核通过、取消、关单-1）
/// </summary>
/// <param name="bookId"></param>
/// <param name="orderStatus"></param>
/// <returns></returns>
public int ModifyBook(int bookId, string orderStatus)
{
//方式1：封装一个实体，所有字段都写上（最麻烦）
//方式2：查询到要修改的实体，然后修改对应的值（有一个查询的过程）
//方法3：创建一个对象-->给主键赋值-->附加到上下文-->给要修改的字段赋值-->提交保存
using (HotelDBEntities db = new HotelDBEntities())
{
DishesBook dishesBook = new DishesBook();
dishesBook.BookId = bookId;
db.DishesBook.Attach(dishesBook);
//请在下面写出要修改的字段，并赋值
dishesBook.OrderStatus = Convert.ToInt32(orderStatus);
return(db.SaveChanges());
}
}
//修改菜品
public int ModifyDishes(Dishes dishes)
{
using (HotelDBEntities db = new HotelDBEntities())
{
Dishes objDish = new Dishes()
{
DishesId = dishes.DishesId
};
db.Dishes.Attach(objDish);
objDish.CategoryId = dishes.CategoryId;
objDish.DishesName = dishes.DishesName;
objDish.UnitPrice = dishes.UnitPrice;
return(db.SaveChanges());
}
}
