//办理入住
public void DealCheckIn(string idcard, DateTime CheckOutDate)
{
string roomname = _dgv.CurrentRow.Cells["ROOMNAME"].Value.ToString();
HotelManagementDAL.Roomer objRoomer = new HotelManagementDAL.Roomer(idcard);
HotelManagementDAL.Room objRoom = new HotelManagementDAL.Room(roomname);
HotelManagementDAL.CheckIn objCheckIn = new HotelManagementDAL.CheckIn(idcard);
if (!objRoomer.GetDataReaderByID())
{
MessageBox.Show("该身份证号未登记，请先进行登记：" + idcard + "，请重新输入！", "身份证号未登记", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (objCheckIn.GetDataReaderByCheckIn())
{
MessageBox.Show("该身份证号已经登记入住请先退房！", "已经登记入", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else//报表的房间名 安全
{
objCheckIn.IDCard = idcard;
objCheckIn.RoomName = roomname;
objCheckIn.IsPay = "未付款";
objCheckIn.State = "正在入住";
objCheckIn.InTime = System.DateTime.Now;
objCheckIn.OutTime = CheckOutDate;
if (objCheckIn.DealCheckIn() > 0 && objRoomer.CheckIn() > 0 && objRoom.CheckIn() > 0)
{
MessageBox.Show("成功办理入住！", "操作成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("办理入住失败！", "操作失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public void DealCheckOut(string idcard, string roomname, bool useID)
{
HotelManagementDAL.Roomer objRoomer = new HotelManagementDAL.Roomer(idcard);
HotelManagementDAL.CheckIn objCheckIn = new HotelManagementDAL.CheckIn(idcard);
HotelManagementDAL.Room objRoom = new HotelManagementDAL.Room(roomname);
if (useID)//身份证信息匹配
{
if (!objCheckIn.GetDataReaderByCheckIn())
{
MessageBox.Show("该身份证号未登记入住！", "身份证号未登记入住", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MySqlDataReader rd = objCheckIn.GetRoomNameByIDCard();
if (rd.Read())
{
objRoom.RoomName = rd["ROOM_NAME"].ToString();
}
if (objRoomer.CheckOut() > 0 && objRoom.CheckOut() > 0 && objCheckIn.DealCheckOutByIDCard() > 0)
{
MessageBox.Show("成功办理退房！", "操作成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("办理退房失败！", "操作失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
objCheckIn.RoomName = roomname;
if (!objCheckIn.IsCheckInByRoomName())
{
MessageBox.Show("该房间未登记入住！", "该房间未登记入住", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MySqlDataReader rd = objCheckIn.GetIDCardByRoomName();
if (rd.Read())
{
objCheckIn.IDCard = rd["ID_CARD"].ToString();
objRoomer.IDCard = objCheckIn.IDCard;
}
if (objRoomer.CheckOut() > 0 && objRoom.CheckOut() > 0 && objCheckIn.DealCheckOutByIDCard() > 0)
{
MessageBox.Show("成功办理退房！", "操作成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("办理退房失败！", "操作失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
//删除房间
public void Delete()
{
string roomName = this._dgv.CurrentRow.Cells["roomName"].Value.ToString();
if (DialogResult.Yes == MessageBox.Show("确认删除房间：' " + roomName + " '吗?\n删除房间，将同时删除与该房间有相关的所有房间信息，要继续吗？", "删除确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
HotelManagementDAL.Room objRoom = new HotelManagementDAL.Room(roomName);
if (objRoom.Delete() > 0)
{
UpdateDataGrid();
MessageBox.Show("成功删除房间" + roomName + " '!", "操作成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("删除操作失败 " + roomName + " '!", "操作失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
//修改房间信息
public void Update(int id, string name, decimal price, string kind, string state, string remark)
{
HotelManagementDAL.Room objRoom = new HotelManagementDAL.Room(name);
objRoom.RoomID = id;
objRoom.RoomName = name;
objRoom.RoomPrice = price;
objRoom.RoomKind = kind;
objRoom.RoomState = state;
objRoom.Remark = remark;
if (objRoom.Update() > 0)
{
UpdateDataGrid();
MessageBox.Show("修改房间信息成功！", "操作成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("更新操作失败！", "操作失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//添加房间
public void Add(string name, decimal price, string kind, string remark)
{
HotelManagementDAL.Room obj = new HotelManagementDAL.Room();
if (obj.GetDataReaderByName(name))
{
MessageBox.Show("该房间名已经存在" + name + "，请重新输入！", "房间已存在", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (HotelManagementDAL.Room.Add(name, price, kind, remark) > 0)
{
UpdateDataGrid();
MessageBox.Show("成功添加房间信息！", "操作成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("添加房间信息失败！", "操作失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
