/// <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="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> /// <returns></returns> public List <SexViewModel> GetStateTxt() { using (HotelManageDBEntities db = new HotelManageDBEntities()) { var data = from r in db.Room_State where r.RoomId == null select new { r.Id, r.StateTxt }; List <SexViewModel> list = new List <SexViewModel>(); SexViewModel sex = new SexViewModel(); sex.Id = 0; sex.Sex = "全部类型"; list.Add(sex); foreach (var item in data) { SexViewModel s = new SexViewModel(); s.Id = item.Id; s.Sex = item.StateTxt; list.Add(s); } return(list); } }
/// <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="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="flag">是否加入 全部状态选择</param> /// <returns></returns> public List <Staff_DeptViewModel> GetALLStaffTxt(bool flag) { using (HotelManageDBEntities db = new HotelManageDBEntities()) { var data = from s in db.Staff_State where s.IsDelete == false select new { s.Id, s.StateTxt }; List <Staff_DeptViewModel> list = new List <Staff_DeptViewModel>(); if (flag) { Staff_DeptViewModel s = new Staff_DeptViewModel(); s.Id = 0; s.StateTxt = "全部状态"; list.Add(s); } foreach (var item in data) { Staff_DeptViewModel s = new Staff_DeptViewModel(); s.Id = item.Id; s.StateTxt = item.StateTxt; list.Add(s); } return(list); } }
/// <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="typeName">房间类型文本</param> /// <returns></returns> public int GetTypeIdByName(string typeName) { using (HotelManageDBEntities db = new HotelManageDBEntities()) { return(db.Room_Type.Where(s => s.TypeTxt == typeName).FirstOrDefault().Id); } }
/// <summary> /// 根据名字获取部门ID /// </summary> /// <param name="name"></param> /// <returns></returns> public int GetDeptIdByName(string name) { using (HotelManageDBEntities db = new HotelManageDBEntities()) { return(db.Staff.Where(s => s.Name == name).FirstOrDefault().DeptId); } }
/// <summary> /// 获取通知数据 /// </summary> /// <param name="name">发布人</param> /// <param name="title">标题</param> /// <param name="page">第几页</param> /// <param name="rows">行</param> /// <param name="total">总数</param> /// <param name="deptId">部门ID</param> /// <returns></returns> public List <RegulationsViewModel> GetAllRegulations(string name, string title, int page, int rows, out int total, int deptId) { if (page.Equals(0)) { total = 0; return(null); } using (HotelManageDBEntities db = new HotelManageDBEntities()) { var data = db.Regulations.Where(s => s.DeptIdList.Contains(deptId.ToString()) && s.IsDelete == false); if (!string.IsNullOrWhiteSpace(name)) { data = data.Where(s => s.StaffName.Contains(name)); } if (!string.IsNullOrWhiteSpace(title)) { data = data.Where(s => s.Title.Contains(title)); } total = data.Count(); data = data.OrderByDescending(s => s.EstablishDate).Skip((page - 1) * rows).Take(rows); List <RegulationsViewModel> listV = new List <RegulationsViewModel>(); foreach (Regulations item in data.ToList()) { RegulationsViewModel r = new RegulationsViewModel(); r.Id = item.Id; r.StaffName = item.StaffName; r.Title = item.Title; r.RegulationsContent = item.RegulationsContent.Count() > 5 ? item.RegulationsContent.Substring(0, 5) + "......" : item.RegulationsContent; r.EstablishDate = item.EstablishDate.ToString("D"); listV.Add(r); } return(listV); } }
/// <summary> /// 根据房间状态文本获取房间状态编号 /// </summary> /// <param name="stateName">房间状态文本</param> /// <returns></returns> public int GetStateIdByName(string stateName) { using (HotelManageDBEntities db = new HotelManageDBEntities()) { return(db.Room_State.Where(s => s.StateTxt == stateName).FirstOrDefault().Id); } }
/// <summary> /// 根据手机号获取帐号信息 /// </summary> /// <param name="loginId"></param> /// <returns></returns> public Staff StaffLogin(string loginId) { using (HotelManageDBEntities db = new HotelManageDBEntities()) { return(db.Staff.Where(s => s.Phone == loginId).FirstOrDefault()); } }
/// <summary> /// 获取所有订单 /// </summary> /// <param name="completeNum">房间完整编号</param> /// <param name="name">客户名字</param> /// <param name="total">记录总数</param> /// <param name="page">第几页</param> /// <param name="rows">一页多少条</param> /// <param name="flag">是否是读取历史</param> /// <returns></returns> public List <OrderViewModel> GetAllRoom(string completeNum, string name, out int total, int page, int rows, bool flag) { if (page.Equals(0)) { total = 0; return(null); } using (HotelManageDBEntities db = new HotelManageDBEntities()) { var data = (from o in db.Order join r in db.Room on o.RoomId equals r.Id where o.IsDelete == flag select new { o.Id, r.CompleteNum, o.purchaseDate, o.Name, o.Sex, o.Phone, o.DeleteDate, o.EstimatedTime, o.LiveDays, o.ActualMoney, o.Deposit }); if (!string.IsNullOrWhiteSpace(completeNum)) { data = data.Where(s => s.CompleteNum.Contains(completeNum)); } if (!string.IsNullOrWhiteSpace(name)) { data = data.Where(s => s.Name.Contains(name)); } total = data.Count(); data = data.OrderByDescending(s => s.purchaseDate).Skip((page - 1) * rows).Take(rows); List <OrderViewModel> list = new List <OrderViewModel>(); foreach (var item in data) { OrderViewModel orderViewModel = new OrderViewModel(); orderViewModel.Id = item.Id; orderViewModel.CompleteNum = item.CompleteNum; orderViewModel.PurchaseDate = item.purchaseDate.ToString("F"); orderViewModel.Name = item.Name; orderViewModel.Sex = item.Sex ? "男" : "女"; orderViewModel.Phone = item.Phone; orderViewModel.DeleteDate = item.DeleteDate.ToString("F"); orderViewModel.EstimatedTime = item.EstimatedTime.ToString("D"); orderViewModel.LiveDays = item.LiveDays.ToString(); orderViewModel.ActualMoney = item.ActualMoney.ToString(); orderViewModel.Deposit = item.Deposit.ToString(); list.Add(orderViewModel); } return(list); } }
/// <summary> /// 获取 Id 根据 名字 /// </summary> /// <param name="name"></param> /// <returns></returns> public List <StaffId> GetIdByName(string name) { using (HotelManageDBEntities db = new HotelManageDBEntities()) { List <StaffId> list = db.Staff.Where(k => k.Name.Contains(name)).Select(s => new StaffId { Id = s.Id }).ToList(); return(list); } }
/// <summary> /// 判断手机号是还使用过 /// </summary> /// <param name="phone">要使用的手机号</param> /// <returns></returns> public bool IsNullStaffByPhone(string phone) { using (HotelManageDBEntities db = new HotelManageDBEntities()) { var data = db.Staff.Where(s => s.Phone == phone); if (data.Count() != 0) { return(true); } } return(false); }
/// <summary> /// 根据商品编号获取商品可分配数量 /// </summary> /// <param name="id">商品编号</param> /// <returns></returns> public int GetNumById(int id) { try { using (HotelManageDBEntities db = new HotelManageDBEntities()) { return(db.Commodity.Where(s => s.Id == id).FirstOrDefault().SeparableNum ?? -1); } } catch (Exception) { // throw; } return(-1); }
/// <summary> /// 根据部门文本获取部门编号 /// </summary> /// <param name="deptName">部门文本</param> /// <returns></returns> public int GetDeptIdByDeptName(string deptName) { try { using (HotelManageDBEntities db = new HotelManageDBEntities()) { return(db.Staff_Dept.Where(s => s.DeptTxt.Contains(deptName)).FirstOrDefault().Id); } } catch (Exception) { // throw; } return(1); }
/// <summary> /// 根据房间编号和商品编号获取房间有商品贪睡 /// </summary> /// <param name="roomId">房间编号</param> /// <param name="comId">商品编号</param> /// <returns></returns> public Room_Commodity GetRoomCommodityIdByRoomIdAndCommodityId(int roomId, int comId) { try { using (HotelManageDBEntities db = new HotelManageDBEntities()) { return(db.Room_Commodity.Where(s => s.RoomId == roomId && s.CommodityId == comId).FirstOrDefault()); } } catch (Exception) { // throw; } return(null); }
/// <summary> /// 根据订单编号获取房间编号 /// </summary> /// <param name="orderId"></param> /// <returns></returns> public int GetRoomIdByOrderId(int orderId) { try { using (HotelManageDBEntities db = new HotelManageDBEntities()) { return(db.Order.Where(s => s.Id == orderId).FirstOrDefault().Id); } } catch (Exception) { //throw; } return(0); }
/// <summary> /// 根据状态文本获取状态编号 /// </summary> /// <param name="stateTxt"></param> /// <returns></returns> public int GetStateIdByStateTxt(string stateTxt) { try { using (HotelManageDBEntities db = new HotelManageDBEntities()) { return(db.Staff_State.Where(s => s.StateTxt.Contains(stateTxt)).FirstOrDefault().Id); } } catch (Exception) { // throw; } return(1); }
/// <summary> /// 获取用户密码 根据当前用户名字 /// </summary> /// <param name="name"></param> /// <returns></returns> public string GetPwdByName(string name) { try { using (HotelManageDBEntities db = new HotelManageDBEntities()) { var data = db.Staff.Where(s => s.Name == name).FirstOrDefault(); return(data.Password); } } catch (Exception) { //throw; } return(null); }
/// <summary> /// 根据通知编号获取通知对象 /// </summary> /// <param name="id"></param> /// <returns></returns> public RegulationsViewModel GetRegulationsById(int id) { using (HotelManageDBEntities db = new HotelManageDBEntities()) { var data = db.Regulations.Where(s => s.Id == id); RegulationsViewModel r = new RegulationsViewModel(); foreach (var item in data) { r.Title = item.Title; r.RegulationsContent = item.RegulationsContent; r.StaffName = item.StaffName; r.EstablishDate = item.EstablishDate.ToString("F"); } return(r); } }
/// <summary> /// 根据房间编号获取房费 /// </summary> /// <param name="roomId"></param> /// <returns></returns> public decimal GetActualMoneyByRommId(int roomId) { using (HotelManageDBEntities db = new HotelManageDBEntities()) { var data = (from r in db.Room join ra in db.Room_Amount on r.Room_AmountId equals ra.Id join rd in db.Room_Discount on r.Room_DiscountId equals rd.Id select new { ra.UnitPrice, rd.DiscountNum }).FirstOrDefault(); return(data.UnitPrice * data.DiscountNum * 0.01M); } }
/// <summary> /// 添加通知 /// </summary> /// <param name="regulations">要添加的所有数据</param> /// <returns></returns> public bool AddRegulations(Regulations regulations) { try { using (HotelManageDBEntities db = new HotelManageDBEntities()) { db.Regulations.Add(regulations); db.SaveChanges(); return(true); } } catch (Exception) { //throw; } return(false); }
/// <summary> /// 添加商品种类 /// </summary> /// <param name="commodity">商品对象</param> /// <returns></returns> public bool AddCommodity(Commodity commodity) { try { using (HotelManageDBEntities db = new HotelManageDBEntities()) { db.Commodity.Add(commodity); db.SaveChanges(); return(true); } } catch (Exception) { //throw; } return(false); }
/// <summary> /// 获取所有消耗记录 /// </summary> /// <param name="name">商品名称</param> /// <param name="completeNum">房间编号</param> /// <param name="total">总数</param> /// <param name="page">第几页</param> /// <param name="rows">一行多少条</param> /// <returns></returns> public List <Commodity_ConsumeViewModel> GetAllConsumeCommodity(string name, string completeNum, out int total, int page, int rows) { if (page.Equals(0)) { total = 0; return(null); } using (HotelManageDBEntities db = new HotelManageDBEntities()) { var data = from cc in db.Commodity_Consume join o in db.Order on cc.OrderId equals o.Id join r in db.Room on o.RoomId equals r.Id join c in db.Commodity on cc.CommodityId equals c.Id select new { cc.Id, r.CompleteNum, c.Name, cc.CommodityNum, cc.EstablishDate }; if (!string.IsNullOrWhiteSpace(name)) { data = data.Where(s => s.Name.Contains(name)); } if (!string.IsNullOrWhiteSpace(completeNum)) { data = data.Where(s => s.CompleteNum.Contains(completeNum)); } total = data.Count(); data = data.OrderBy(s => s.Id).Skip((page - 1) * rows).Take(rows); List <Commodity_ConsumeViewModel> listV = new List <Commodity_ConsumeViewModel>(); foreach (var item in data) { Commodity_ConsumeViewModel cc = new Commodity_ConsumeViewModel(); cc.Id = item.Id; cc.CompleteNum = item.CompleteNum; cc.Name = item.Name; cc.CommodityNum = item.CommodityNum.ToString(); cc.EstablishDate = item.EstablishDate.ToString("F"); listV.Add(cc); } return(listV); } }
/// <summary> /// 添加员工 /// </summary> /// <param name="staff">员工信息对象</param> /// <returns></returns> public bool AddStaff(Staff staff) { try { using (HotelManageDBEntities db = new HotelManageDBEntities()) { db.Staff.Add(staff); 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="roomId">房间的编号</param> /// <returns></returns> public List <CommodityViewModel> GetCommodityByroomId(int roomId) { using (HotelManageDBEntities db = new HotelManageDBEntities()) { var data = from r in db.Room_Commodity join c in db.Commodity on r.CommodityId equals c.Id where r.RoomId == roomId select new CommodityViewModel { Id = r.Id, Name = c.Name, CommodityNum = r.CommodityNum ?? 0, UnitPrice = c.UnitPrice ?? 0 }; int a = data.Count(); return(data.ToList()); } }
/// <summary> /// 修改用户密码 /// </summary> /// <param name="pwdx">要修改的密码</param> /// <param name="name">当前用户</param> /// <returns></returns> public bool EditUserPwd(string pwdx, string name) { try { using (HotelManageDBEntities db = new HotelManageDBEntities()) { var data = db.Staff.Where(s => s.Name == name).FirstOrDefault(); data.Password = pwdx; db.SaveChanges(); return(true); } } catch (Exception) { //throw; } return(false); }