//菜品预订 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)); }