//办理入住 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 Update(string ID, string name, string phone, string address, string remark) { HotelManagementDAL.Roomer obj = new HotelManagementDAL.Roomer(ID); obj.IDCard = ID;/// 登记 信息 obj.Name = name; obj.Phone = phone; obj.Address = address; obj.Remark = remark; if (obj.Update() > 0) { UpdateDataGrid(); MessageBox.Show("修改住客信息成功!", "操作成功", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("更新操作失败!", "操作失败", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void Delete() { string IDCard = this._dgv.CurrentRow.Cells["ID_Card"].Value.ToString(); string name = this._dgv.CurrentRow.Cells["Name_"].Value.ToString(); if (DialogResult.Yes == MessageBox.Show("确认删除住客信息:' " + name + " '吗?\n删除住客,将同时删除与该住客有相关的所有入住信息,要继续吗?", "删除确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question)) { HotelManagementDAL.Roomer objRoom = new HotelManagementDAL.Roomer(IDCard); if (objRoom.Delete() > 0) { UpdateDataGrid(); MessageBox.Show("成功删除住客" + name + " '!", "操作成功", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("删除操作失败 " + name + " '!", "操作失败", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
//添加住客 public void Add(string ID, string name, Int64 phone, string address, string state, string remark) { HotelManagementDAL.Roomer obj = new HotelManagementDAL.Roomer(); if (obj.GetDataReaderByID(ID)) { MessageBox.Show("该身份证号名已经存在" + ID + ",请重新输入!", "身份证号名已存在", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { if (HotelManagementDAL.Roomer.Add(ID, name, phone, address, state, remark) > 0) { UpdateDataGrid(); MessageBox.Show("成功添加住客信息!", "操作成功", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("添加住客信息失败!", "操作失败", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }