private void FrmRoomManager_Load_1(object sender, EventArgs e)
{
// TODO: 这行代码将数据加载到表“hotelmanagerDataSet.roomtype”中。您可以根据需要移动或删除它。
this.roomtypeTableAdapter.Fill(this.hotelmanagerDataSet.roomtype);
CmpSetDgv();
cboReserWay.SelectedIndex = 0;
cboRoomType.SelectedIndex = 0;
dgvBou.DataSource = ReserDao.SelectReserAll();
}
private void picSearch_Click(object sender, EventArgs e)
{
if (txtCustoTel.Text == "")
{
dgvBou.DataSource = ReserDao.SelectReserAll();
}
else
{
string tel = txtCustoTel.Text;
dgvBou.DataSource = ReserDao.SelectReserInfoByConn(tel);
}
}
private void picUpdate_Click(object sender, EventArgs e)
{
if (txtReserNo.Text == "")
{
MessageBox.Show("还没选择预约客户信息，无法进行修改！");
}
else
{
int n = 0;
string sql = "update reser set CustoName='" + txtCustoName.Text + "',CustoTel='" + txtCustoTel.Text + "',ReserWay='" + cboReserWay.Text + "',ReserRoom='" + cboRoomType.Text + "',ReserCash='" + ReserCash.Text + "',ReserDate='" + dtpBouDate.Value.ToShortDateString() + "',ReserPerson='" + txtReserNum.Text + "' where ReserId='" + txtReserNo.Text + "'";
MySqlConnection con = DBHelper.GetConnection();
n = DBHelper.ExecuteNonQuery(sql);
MessageBox.Show("修改预约信息成功");
dgvBou.DataSource = ReserDao.SelectReserAll();
}
}
private void picDeleteReser_Click(object sender, EventArgs e)
{
if (txtReserNo.Text != "")
{
string sql = "delete from reser where ReserId='" + txtReserNo.Text + "'";
MySqlConnection con = DBHelper.GetConnection();
int n = DBHelper.ExecuteNonQuery(sql);
if (n > 0)
{
MessageBox.Show("删除预约信息成功", "删除提示");
txtReserNo.Text = "";
dgvBou.DataSource = ReserDao.SelectReserAll();
}
else
{
MessageBox.Show("删除预约信息失败", "错误提示");
}
}
else
{
MessageBox.Show("请输入要删除的预约编号！", "提醒");
}
}
private void picAddReserInfo_Click(object sender, EventArgs e)
{
if (txtReserNo.Text == "")
{
MessageBox.Show("未输入预约编号，无法进行添加！");
}
else
{
int n = 0;
string sql = "insert into reser values('" + txtReserNo.Text + "','" + txtCustoName.Text + "','" + txtCustoTel.Text + "','" + cboReserWay.Text + "','" + cboRoomType.Text + "','" + ReserCash.Text + "','" + dtpBouDate.Value + "','" + txtReserNum.Text + "')";
MySqlConnection con = DBHelper.GetConnection();
n = DBHelper.ExecuteNonQuery(sql);
MessageBox.Show("添加预约信息成功");
dgvBou.DataSource = ReserDao.SelectReserAll();
txtReserNo.Text = "";
txtCustoName.Text = "";
txtCustoTel.Text = "";
cboReserWay.Text = "";
cboRoomType.Text = "";
ReserCash.Text = "";
dtpBouDate.Text = "";
txtReserNum.Text = "";
}
}
