private void button1_Click(object sender, EventArgs e) { if (this.cb_rzfj.SelectedIndex == 0) { toolTip1.Show("请选择入住房间类型", this.cb_rzfj, 1000); cb_rzfj.Focus(); return; } if (string.IsNullOrEmpty(txt_lxdh.Text.Trim())) { toolTip1.Show("联系电话不能为空!", this.txt_lxdh, 1000); txt_lxdh.Focus(); return; } RoomRecord record = new RoomRecord(); record.lsh = LshCreate.GetLsh(); record.lxdh = this.txt_lxdh.Text.Trim(); record.fjbh = Bll_Room.GetFreeRoomIdWithFjlx(cb_rzfj.SelectedValue.ToString()).ToString(); record.rzzt = "4"; if (Bll_Guset.AddReserveRecord(record) > 0) { MessageBox.Show("预约成功!房间号:" + record.fjbh, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void button1_Click(object sender, EventArgs e) { SearchInfoVo searchInfoVo = new SearchInfoVo(); if (!string.IsNullOrEmpty(textBox1.Text.Trim())) { searchInfoVo.lsh = textBox1.Text.Trim(); } if (!string.IsNullOrEmpty(textBox2.Text.Trim())) { searchInfoVo.khxm = textBox2.Text.Trim(); } if (!string.IsNullOrEmpty(textBox3.Text.Trim())) { searchInfoVo.lxdh = textBox3.Text.Trim(); } if (!string.IsNullOrEmpty(textBox4.Text.Trim())) { searchInfoVo.fjbh = textBox4.Text.Trim(); } if (!string.IsNullOrEmpty(textBox5.Text.Trim())) { searchInfoVo.sfzhm = textBox5.Text.Trim(); } DataTable dataTable = Bll_Guset.GetRecordDataTable(searchInfoVo); dataGridView1.DataSource = dataTable; }
private void btn_ok_Click(object sender, EventArgs e) { if (listView1.Items.Count == 0) { toolTip1.Show("客户信息不能为空!", this.listView1, 1000); listView1.Focus(); return; } if (string.IsNullOrEmpty(txt_rzts.Text.Trim())) { toolTip1.Show("入住天数不能为空!", this.txt_rzts, 1000); txt_rzts.Focus(); return; } if (string.IsNullOrEmpty(txt_lxdh.Text.Trim())) { toolTip1.Show("联系电话不能为空!", this.txt_lxdh, 1000); txt_lxdh.Focus(); return; } if (this.cb_rzfj.SelectedIndex == 0) { toolTip1.Show("请选择入住房间类型", this.cb_rzfj, 1000); cb_rzfj.Focus(); return; } RoomRecord record = new RoomRecord(); record.lsh = LshCreate.GetLsh(); record.lxdh = txt_lxdh.Text.Trim(); record.rzyj = txt_rzyj.Text.Trim(); record.fjbh = Bll_Room.GetFreeRoomIdWithFjlx(cb_rzfj.SelectedValue.ToString()).ToString(); record.rzrq = this.dtp_rzsj.Value; record.rzts = this.txt_rzts.Text.Trim(); record.tfrq = record.rzrq.AddDays(Convert.ToInt32(record.rzts)); record.rzzt = "1"; record.khxx = TempGuest.guests; try { if (Bll_Guset.AddCheckinRecord(record) > 0) { MessageBox.Show("入住办理成功!房间号:" + record.fjbh, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (MySqlException ex) { MessageBox.Show("数据库异常:" + ex.Message); } catch (Exception ex) { MessageBox.Show("其它异常:" + ex.Message); } }
/// <summary> /// 通过手机号查询客户预约信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { string phone = textBox1.Text.Trim(); RoomRecord roomRecord = Bll_Guset.GetReserveRecordByPhone(phone); if (!string.IsNullOrEmpty(roomRecord.lsh)) { textBox5.Text = roomRecord.fjbh; textBox4.Text = roomRecord.lxdh; } else { MessageBox.Show("没有查询到对应的预约信息"); } }
/// <summary> /// 根据房间编号获取状态为1的入住记录 /// </summary> private void GetGuestInfoWifhFjbh() { try { guestrecord = Bll_Guset.GetRecordInfo(fjbh); lb_khxm.Text = guestrecord.khxm; lb_sfzmhm.Text = guestrecord.sfzmhm; lb_rzrq.Text = guestrecord.rzrq.ToString(); } catch (MySqlException ex) { MessageBox.Show("数据库异常:" + ex.Message); } catch (Exception ex) { MessageBox.Show("其它异常:" + ex.Message); } }
/// <summary> /// 退房 /// </summary> private void CheckOut() { int flag = 0; try { flag = Bll_Guset.RoomCheckOut(lb_fjbh.Text); } catch (MySqlException ex) { MessageBox.Show("数据库异常:" + ex.Message); } catch (Exception ex) { MessageBox.Show("其它异常:" + ex.Message); } if (flag > 0) { MessageBox.Show("退房成功!"); this.Close(); } }
/// <summary> /// 预约入住确认 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button2_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(textBox3.Text)) { toolTip1.Show("入住天数不能为空!", this.textBox3, 1000); textBox3.Focus(); return; } if (listView2.Items.Count == 0) { toolTip1.Show("客户信息不能为空!", this.listView2, 1000); listView2.Focus(); return; } RoomRecord roomRecord = Bll_Guset.GetReserveRecordByPhone(textBox4.Text.Trim()); roomRecord.rzyj = textBox2.Text.Trim(); roomRecord.rzrq = dateTimePicker1.Value; roomRecord.rzts = textBox3.Text.Trim(); roomRecord.tfrq = roomRecord.rzrq.AddDays(Convert.ToInt32(roomRecord.rzts)); roomRecord.rzzt = "1"; roomRecord.khxx = TempGuest.guests; try { if (Bll_Guset.UpdateReserveRecord(roomRecord) > 0) { MessageBox.Show("入住办理成功!房间号:" + roomRecord.fjbh, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (MySqlException ex) { MessageBox.Show("数据库异常:" + ex.Message); } catch (Exception ex) { MessageBox.Show("其它异常:" + ex.Message); } }
/// <summary> /// 取消预订 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void 取消预订ToolStripMenuItem_Click(object sender, EventArgs e) { if (lv_room.SelectedItems.Count == 1 && lv_room.SelectedItems[0].ImageIndex == 3) { string fjbh = lv_room.SelectedItems[0].Text; //根据房间编号获取对应房间的预约信息 RoomRecord roomRecord = Bll_Guset.GetReserveRecordByFjbh(fjbh); //取消对应流水号的预定信息 if (Bll_Guset.CancelReserveRecord(roomRecord) > 0) { FrmMain_Load(null, null); } else { MessageBox.Show("取消预约失败"); } } else { MessageBox.Show("不满足取消预约条件!"); } }
private void InitData() { DataTable dataTable = Bll_Guset.GetRecordDataTable(new SearchInfoVo()); dataGridView1.DataSource = dataTable; }
private void btn_ok_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txt_khxm.Text.Trim())) { toolTip1.Show("客户姓名不能为空!", this.txt_khxm, 1000); txt_khxm.Focus(); return; } if (string.IsNullOrEmpty(txt_sfzmhm.Text.Trim())) { toolTip1.Show("身份证号不能为空!", this.txt_sfzmhm, 1000); txt_sfzmhm.Focus(); return; } if (string.IsNullOrEmpty(txt_rzts.Text.Trim())) { toolTip1.Show("入住天数不能为空!", this.txt_rzts, 1000); txt_rzts.Focus(); return; } if (string.IsNullOrEmpty(txt_lxdh.Text.Trim())) { toolTip1.Show("联系电话不能为空!", this.txt_lxdh, 1000); txt_lxdh.Focus(); return; } if (this.cb_rzfj.SelectedIndex == 0) { toolTip1.Show("请选择入住房间类型", this.cb_rzfj, 1000); cb_rzfj.Focus(); return; } GuestRecord guest = new GuestRecord(); guest.lsh = lshCreate.GetLsh(); guest.khxm = this.txt_khxm.Text.Trim(); guest.sfzmhm = this.txt_sfzmhm.Text.Trim(); guest.lxdh = this.txt_lxdh.Text.Trim(); guest.xb = this.cb_khxb.Text; guest.rzyj = this.txt_rzyj.Text.Trim(); guest.fjbh = Bll_Room.GetFreeRoomIdWithFjlx(cb_rzfj.SelectedValue.ToString()).ToString(); guest.rzrq = this.dtp_rzsj.Value; guest.rzts = this.txt_rzts.Text.Trim(); guest.tfrq = guest.rzrq.AddDays(Convert.ToInt32(guest.rzts)); guest.rzzt = "1"; try { if (Bll_Guset.AddGuest(guest) > 0) { MessageBox.Show("入住办理成功!房间号:" + guest.fjbh, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (MySqlException ex) { MessageBox.Show("数据库异常:" + ex.Message); } catch (Exception ex) { MessageBox.Show("其它异常:" + ex.Message); } }