/// <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);
}
