dataGridView1.DataSource = ds.Tables[0]; } else {
MessageBox.Show(\该房间不能续房！！！\); } }
catch (Exception ex) {
MessageBox.Show(ex.Message, \操作数据库出错！\, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); }
finally {
con.Close(); } } 运行结果：
108房原定的退房时间是2012-6-22，现在想把退房时间再推后两天，即是2012-6-24号。
- 25 -
6.4结账退房功能的实现
代码如下：
if (txtfindID.Text == \) {
MessageBox.Show(\没有输入查询数据\); } else {
//退房前需要对房间的费用进行结算 SqlConnection con = myCon.getCon(); SqlCommand command = null;
string sql = \ + txtfindID.Text.Trim(); try {
command = new SqlCommand(sql, con); con.Open();
sql = \where R_ID=\ + txtfindID.Text.Trim();
command = new SqlCommand(sql, con); int num = (int)command.ExecuteScalar();
sql = \ + txtfindID.Text.Trim();
- 26 -
command = new SqlCommand(sql, con);
double Money = Convert.ToDouble(command.ExecuteScalar()); double sum = 0; sum = Money * num;
string str = Convert.ToString(sum);
MessageBox.Show(\需要支付的总金额为：\ + str);
}
catch (Exception ex) {
MessageBox.Show(ex.Message, \操作数据库出错！\, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); }
finally {
con.Close(); }
if (txtfindID.Text == \) {
MessageBox.Show(\没有输入查询数据\); } else {
bool id =
BLL.CustomerBLL.BllUpdate(int.Parse(this.txtfindID.Text)); if (id) {
listView1.Items.Clear(); SqlDataReader dr =
BLL.CustomerBLL.BllSelectID(int.Parse(this.txtfindID.Text)); while (dr.Read()) {
ListViewItem lv = this.listView2.Items.Add(dr[0].ToString());
lv.SubItems.Add(dr[1].ToString()); lv.SubItems.Add(dr[2].ToString()); lv.SubItems.Add(dr[3].ToString()); lv.SubItems.Add(dr[4].ToString()); lv.SubItems.Add(dr[5].ToString()); lv.SubItems.Add(dr[6].ToString()); }
MessageBox.Show(\退房成功\); }
- 27 -
else {
MessageBox.Show(\退房失败\); } } } 运行结果：
查询要退房的信息，例如房号为108
- 28 -