/// <summary> /// 修改房间金额 /// </summary> /// <param name="Id">房间编号</param> /// <param name="UnitPrice">金额</param> /// <returns></returns> public bool EditAmount(int Id, decimal UnitPrice) { try { using (HotelManageDBEntities db = new HotelManageDBEntities()) { Room_Amount room_Amount = new Room_Amount(); room_Amount.EstablishDate = DateTime.Now; room_Amount.IsDelete = false; room_Amount.UnitPrice = UnitPrice; db.Room_Amount.Add(room_Amount); db.SaveChanges(); Room room = db.Room.Where(s => s.Id == Id).FirstOrDefault(); Room_Amount ra = db.Room_Amount.Where(s => s.Id == room.Room_AmountId).FirstOrDefault(); ra.IsDelete = true; ra.DeleteDate = DateTime.Now; ra.RoomId = room.Id; db.Entry(ra).State = EntityState.Modified; room.Room_AmountId = room_Amount.Id; db.Entry(room).State = EntityState.Modified; db.SaveChanges(); return(true); } } catch (Exception) { //throw; } return(false); }
/// <summary> /// 修改折扣 /// </summary> /// <param name="Id">房间编号</param> /// <param name="DiscountNum">折扣数</param> /// <returns></returns> public bool EditDiscount(int Id, int DiscountNum) { try { using (HotelManageDBEntities db = new HotelManageDBEntities()) { Room_Discount room_Discount = new Room_Discount(); room_Discount.EstablishDate = DateTime.Now; room_Discount.IsDelete = false; room_Discount.DiscountNum = DiscountNum; db.Room_Discount.Add(room_Discount); db.SaveChanges(); Room room = db.Room.Where(s => s.Id == Id).FirstOrDefault(); Room_Discount rd = db.Room_Discount.Where(s => s.Id == room.Room_DiscountId).FirstOrDefault(); rd.IsDelete = true; rd.DeleteDate = DateTime.Now; rd.RoomId = Id; db.Entry(rd).State = EntityState.Modified; room.Room_DiscountId = room_Discount.Id; db.Entry(room).State = EntityState.Modified; db.SaveChanges(); return(true); } } catch (Exception) { //throw; } return(false); }
/// <summary> /// 修改状态 /// </summary> /// <param name="id">房间编号</param> /// <param name="dentityId">身份编号</param> /// <returns></returns> public bool ModifyState(int id, int dentityId) { try { using (HotelManageDBEntities db = new HotelManageDBEntities()) { Room room = db.Room.Where(s => s.Id == id).FirstOrDefault(); Room_State room_State = new Room_State(); room_State.EstablishDate = DateTime.Now; room_State.IsDelete = false; room_State.RoomId = id; bool flag = true; if (dentityId == 5) //清洁部门 状态 待清洁 { if (room.Room_StateId == 7) { room.Room_StateId = 4; room_State.StateTxt = "在清洁"; flag = false; } else if (room.Room_StateId == 4) { room.Room_StateId = 1; room_State.StateTxt = "可使用"; flag = false; } } if (dentityId == 6) //维修部门 状态 待清洁 { if (room.Room_StateId == 7 || room.Room_StateId == 1) { room.Room_StateId = 5; room_State.StateTxt = "维修中"; flag = false; } else if (room.Room_StateId == 5) { room.Room_StateId = 7; room_State.StateTxt = "待清洁"; flag = false; } } if (flag) { return(false); } db.Entry(room).State = EntityState.Modified; db.Room_State.Add(room_State); db.SaveChanges(); return(true); } } catch (Exception) { //throw; } return(false); }
/// <summary> /// 修改员工信息 /// </summary> /// <param name="id">员工编号</param> /// <param name="staff">修改后的员工信息</param> /// <returns></returns> public bool EditStaff(int id, Staff staff) { try { using (HotelManageDBEntities db = new HotelManageDBEntities()) { Staff st = db.Staff.Where(s => s.Id == id).FirstOrDefault(); st.Name = staff.Name; st.Sex = staff.Sex; st.Age = staff.Age; st.Nation = staff.Nation; st.Phone = staff.Phone; st.Email = staff.Email; st.DeptId = staff.DeptId; st.Staff_StateId = staff.Staff_StateId; db.Entry(st).State = EntityState.Modified; db.SaveChanges(); return(true); } } catch (Exception) { // throw; } return(false); }
/// <summary> /// 增加订单 /// </summary> /// <param name="order">所有订单信息</param> /// <returns></returns> public bool AddOrder(Order order) { try { using (HotelManageDBEntities db = new HotelManageDBEntities()) { db.Order.Add(order); Room data = db.Room.Where(s => s.Id == order.RoomId).FirstOrDefault(); data.Room_StateId = 3; db.Entry(data).State = EntityState.Modified; Room_State room_State = new Room_State(); room_State.EstablishDate = DateTime.Now; room_State.IsDelete = false; room_State.RoomId = order.RoomId; room_State.StateTxt = "使用中"; db.Room_State.Add(room_State); db.SaveChanges(); return(true); } } catch (Exception) { //throw; } return(false); }
/// <summary> /// 退房 /// </summary> /// <param name="Id">房间编号</param> /// <param name="Amount">退还金额</param> /// <returns></returns> public bool AddSignOut(int Id, decimal Amount) { try { using (HotelManageDBEntities db = new HotelManageDBEntities()) { //写入退房表 CheckOut checkOut = new CheckOut(); checkOut.EstablishDate = DateTime.Now; checkOut.IsDelete = false; checkOut.OrderId = Id; checkOut.CheckOutDate = DateTime.Now; checkOut.refundAmount = Amount; db.CheckOut.Add(checkOut); //订单表标记完成 Order order = db.Order.Where(s => s.Id == Id).FirstOrDefault(); order.IsDelete = true; order.DeleteDate = DateTime.Now; db.Entry(order).State = EntityState.Modified; //房间状态设置成待清洁 int? roomID = order.RoomId; Room room = db.Room.Where(s => s.Id == roomID).FirstOrDefault(); room.Room_StateId = 7; // 7 待清洁 db.Entry(room).State = EntityState.Modified; Room_State room_State = new Room_State(); room_State.EstablishDate = DateTime.Now; room_State.IsDelete = false; room_State.RoomId = roomID; room_State.StateTxt = "待清洁"; db.Room_State.Add(room_State); db.SaveChanges(); return(true); } } catch (Exception) { //throw; } return(false); }
/// <summary> /// 添加房间商品分配 /// </summary> /// <param name="Id">房间编号</param> /// <param name="name">商品编号</param> /// <param name="commodityNum">添加数量</param> /// <returns></returns> public bool IncreaseCommodityC(int Id, int name, int commodityNum) { try { using (HotelManageDBEntities db = new HotelManageDBEntities()) { Room_Commodity rc = db.Room_Commodity.Where(s => s.RoomId == Id && s.CommodityId == name).FirstOrDefault(); rc.CommodityNum = rc.CommodityNum + commodityNum; db.Entry(rc).State = EntityState.Modified; Commodity c = db.Commodity.Where(s => s.Id == name).FirstOrDefault(); c.SeparableNum = c.SeparableNum - commodityNum; db.Entry(c).State = EntityState.Modified; db.SaveChanges(); return(true); } } catch (Exception) { // throw; } return(false); }
/// <summary> /// 减少库存 /// </summary> /// <param name="id">商品编号</param> /// <param name="num">减少数量</param> /// <returns></returns> public bool ReduceCommodity(int id, int num) { try { using (HotelManageDBEntities db = new HotelManageDBEntities()) { Commodity c = db.Commodity.Where(s => s.Id == id).FirstOrDefault(); c.Stock = c.Stock - num; db.Entry(c).State = EntityState.Modified; db.SaveChanges(); return(true); } } catch (Exception) { // throw; } return(false); }
/// <summary> /// 删除员工 /// </summary> /// <param name="id">员工编号</param> /// <returns></returns> public bool DestroyStaff(int id) { try { using (HotelManageDBEntities db = new HotelManageDBEntities()) { Staff staff = db.Staff.Where(s => s.Id == id).FirstOrDefault(); staff.IsDelete = true; staff.DeleteDate = DateTime.Now; db.Entry(staff).State = EntityState.Modified; db.SaveChanges(); return(true); } } catch (Exception) { //throw; } return(false); }
/// <summary> /// 删除通知 /// </summary> /// <param name="id">通知编号</param> /// <returns></returns> public bool DestroyRegulations(int id) { try { using (HotelManageDBEntities db = new HotelManageDBEntities()) { Regulations date = db.Regulations.Where(s => s.Id == id).FirstOrDefault(); date.IsDelete = true; date.DeleteDate = DateTime.Now; db.Entry(date).State = EntityState.Modified; db.SaveChanges(); return(true); } } catch (Exception) { //throw; } return(false); }
/// <summary> /// 修改用户的信息 /// </summary> /// <param name="nation">民族</param> /// <param name="email">邮箱</param> /// <param name="sex">性别</param> /// <param name="name">当前用户名字</param> /// <returns></returns> public bool EditUserIn(string nation, string email, bool sex, string name) { try { using (HotelManageDBEntities db = new HotelManageDBEntities()) { Staff st = db.Staff.Where(s => s.Name == name).FirstOrDefault(); st.Nation = nation; st.Email = email; st.Sex = sex; db.Entry(st).State = EntityState.Modified; db.SaveChanges(); return(true); } } catch (Exception) { // throw; } return(false); }
/// <summary> /// 添加房间有商品表 /// </summary> /// <param name="rc">房间有商品表对象</param> /// <returns></returns> public bool IncreaseCommodityCW(Room_Commodity rc) { try { using (HotelManageDBEntities db = new HotelManageDBEntities()) { db.Room_Commodity.Add(rc); Commodity c = db.Commodity.Where(s => s.Id == rc.CommodityId).FirstOrDefault(); c.SeparableNum = c.SeparableNum - rc.CommodityNum; db.Entry(c).State = EntityState.Modified; db.SaveChanges(); return(true); } } catch (Exception) { // throw; } return(false); }
/// <summary> /// 续住 /// </summary> /// <param name="id">订单编号</param> /// <param name="time">续住时间</param> /// <returns></returns> public bool AddContinue(int id, DateTime time) { try { using (HotelManageDBEntities db = new HotelManageDBEntities()) { Order order = db.Order.Where(s => s.Id == id).FirstOrDefault(); order.EstimatedTime = time; order.LiveDays = (order.EstimatedTime - order.EstablishDate).Days + 1; order.ActualMoney = GetActualMoneyByRommId(order.RoomId) * (order.LiveDays ?? 0); db.Entry(order).State = EntityState.Modified; db.SaveChanges(); return(true); } } catch (Exception) { //throw; } return(false); }
/// <summary> /// 添加进货 /// </summary> /// <param name="cp">进货信息对象</param> /// <returns></returns> public bool AddCommodityP(Commodity_Purchase cp) { try { using (HotelManageDBEntities db = new HotelManageDBEntities()) { db.Commodity_Purchase.Add(cp); Commodity commodity = db.Commodity.Where(s => s.Id == cp.CommodityId).FirstOrDefault(); commodity.Stock = commodity.Stock + cp.CommodityNum; commodity.SeparableNum = commodity.SeparableNum + cp.CommodityNum; db.Entry(commodity).State = EntityState.Modified; db.SaveChanges(); return(true); } } catch (Exception) { //throw; } return(false); }