//菜品预订
public ActionResult DishesBook(DishesBook dishes)
{
dishes.BookTime = DateTime.Now;
int res = book.DishesBook(dishes);
return(Content(res.ToString()));
}
public ActionResult DeleteDishesBook(int BookId)
{
DishesBook dishesbook = new DishesBook();
dishesbook = DishesBookBLL.Get(o => o.BookId == BookId);
DishesBookBLL.Delete(dishesbook);
return(RedirectToAction("DishesBook"));
}
//添加订单（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 ActionResult ModifyBook(int OrderStatus, int BookId)
{
DishesBook dishesbook = new DishesBook();
dishesbook = DishesBookBLL.Get(o => o.BookId == BookId);
dishesbook.OrderStatus = OrderStatus;
DishesBookBLL.Update(dishesbook);
return(RedirectToAction("DishesBook"));
}
/// <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=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());
}
}
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 ActionResult Book(DishesBook dishesBook)
{
dishesBook.BookTime = DateTime.Now;
int result = new DishesBookManager().Book(dishesBook);
if (result > 0)
{
return(Content("success"));
}
else
{
return(Content("error"));
}
}
/// <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());
}
}
/// <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());
}
}
/// <summary>
/// 修改预订状态
/// 0 待审核状态 1 审核通过 -1订单关闭状态
/// </summary>
/// <param name="bookId"></param>
/// <param name="status"></param>
/// <returns></returns>
public int ModifyBook(int bookId, string status)
{
/*
* 1.封装一个实体，所有属性都写上
* 2.查询到实体，修改某些属性
* 3.创建一个对象--》给主键赋值--》附加到上下文对象--》给修改的字段赋值--》提交保存
*
*/
using (HotelDBEntities db = new HotelDBEntities())
{
DishesBook dishesBook = new DishesBook();
dishesBook.BookId = bookId;
db.DishesBook.Attach(dishesBook);
dishesBook.OrderStatus = Convert.ToInt32(status);
return(db.SaveChanges());
}
}
//添加预定
public ActionResult SubmitDishesBook()
{
DishesBook dishesbook = new DishesBook();
//获取用户请求信息
dishesbook.HotelName = Request["HotelName"];
dishesbook.ConsumeTime = Convert.ToDateTime(Request["ConsumeTime"]);
dishesbook.ConsumePersons = Convert.ToInt32(Request["ConsumePersons"]);
dishesbook.RoomType = Request["RoomType"];
dishesbook.CustomerName = Request["CustomerName"];
dishesbook.CustomerPhone = Request["CustomerPhone"];
dishesbook.CustomerEmail = Request["CustomerEmail"];
dishesbook.Comments = Request["Comments"];
dishesbook.BookTime = DateTime.Now;
dishesbook.OrderStatus = 0;
//反馈消息
string message = string.Empty;
if (string.IsNullOrEmpty(dishesbook.HotelName))
{
message = "消费内容不能为空";
}
else if (string.IsNullOrEmpty(dishesbook.CustomerName))
{
message = "投诉内容不能为空";
}
else if (string.IsNullOrEmpty(dishesbook.CustomerPhone))
{
message = "投诉内容不能为空";
}
else
{
message = "ok";
}
if (message != "ok")
{
TempData["LoginMsg"] = message;
return(RedirectToAction("DishesBook", "Company"));
}
dishesbookb.Book(dishesbook);
return(RedirectToAction("Index", "Company"));
}
// GET: DishesBook
public ActionResult DishesBook()
{
IList <DishesBook> list = DishesBookBLL.GetAll();
List <DishesBook> dishesbooklist = new List <DishesBook>();
foreach (var temp in list)
{
DishesBook dishesbook = new DishesBook();
dishesbook.BookId = temp.BookId;
dishesbook.HotelName = temp.HotelName;
dishesbook.ConsumeTime = temp.ConsumeTime;
dishesbook.ConsumePersons = temp.ConsumePersons;
dishesbook.RoomType = temp.RoomType;
dishesbook.CustomerName = temp.CustomerName;
dishesbook.CustomerPhone = temp.CustomerPhone;
dishesbook.CustomerEmail = temp.CustomerEmail;
dishesbook.Comments = temp.Comments;
dishesbook.BookTime = temp.BookTime;
dishesbook.OrderStatus = temp.OrderStatus;
dishesbooklist.Add(dishesbook);
}
return(View(dishesbooklist));
}
public ActionResult OrderStatus(DishesBook book)
{
int res = manager.UpdateDishesBook(book);
return(Content(res.ToString()));
}
//菜品预订
public int DishesBook(DishesBook dishes)
{
return(book.AddDishesBook(dishes));
}
//更新订单状态
public int UpdateDishesBook(DishesBook obj)
{
return(book.UpdateDishesBook(obj));
}
/// <summary>
/// 包房预订(添加预定)
/// </summary>
/// <param name="dishesBook"></param>
/// <returns></returns>
public int Book(DishesBook dishesBook)
{
return(dishesbook.Book(dishesBook));
}
/// <summary>
/// 客户预定
/// </summary>
/// <param name="objDishBook"></param>
/// <returns></returns>
public int Book(DishesBook dishBook)
{
return(dishBookService.Book(dishBook));
}
