/// <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> /// 预约入住确认 /// </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); } }