6.2换房功能的实现
代码如下：
SqlConnection con = myCon.getCon();
if (textBox1.Text.Trim() == \ || textBox2.Text.Trim() == \) {
MessageBox.Show(\请输入客户名和房间号！\); } else {
con.Open();
string consql = \ + textBox1.Text.Trim() + \;
SqlCommand command = new SqlCommand(consql, con); int num = Convert.ToInt32(command.ExecuteScalar()); string Num = Convert.ToString(num); //MessageBox.Show(Num);
consql = \ + Num + \;
command = new SqlCommand(consql, con);
string state = (string)command.ExecuteScalar(); if (state != \已入住\) {
MessageBox.Show(\该客户已经退房，不能进行换房操作！\); } else {
consql = \ + textBox2.Text.Trim();
command = new SqlCommand(consql, con); state = (string)command.ExecuteScalar(); if (state != \空房\) {
MessageBox.Show(\该房间不能换！\); } else {
consql = \ + Num; command = new SqlCommand(consql, con);
string str = (string)command.ExecuteScalar(); ////MessageBox.Show(str);
consql = \ + str; command = new SqlCommand(consql, con); DateTime s1 =
- 21 -
Convert.ToDateTime(command.ExecuteScalar());
consql = \R_daoqitime from Room where R_ID=\ + str; command = new SqlCommand(consql, con); DateTime s2 =
Convert.ToDateTime(command.ExecuteScalar());
consql = \空房' where R_ID=\+str ;
command = new SqlCommand(consql, con); command.ExecuteNonQuery();
consql = \已入住', R_intime='\ + s1 + \ + s2 + \ + textBox2.Text.Trim(); command = new SqlCommand(consql, con); command.ExecuteNonQuery();
consql = \Customer set R_ID=\ + textBox2.Text.Trim() + \ + Num;
command = new SqlCommand(consql, con); command.ExecuteNonQuery();
StringBuilder sql = new StringBuilder();
sql.Append(\客户号 , C_name AS 客户名称, C_sex AS 性别, R_ID AS 房号, C_AllMoney AS 总费用, C_money AS 费用, C_Phone AS 联系电话, C_Cardid AS 身份证号, C_time AS 入住时间, C_daoqitime AS 退房时间, C_notes AS 备注 from Customer\);
SqlDataAdapter dapt = new SqlDataAdapter(sql.ToString(), con);
ds = new DataSet();
dapt.Fill(ds, \);
MessageBox.Show(\换房成功！\);
dataGridView1.DataSource = ds.Tables[0]; con.Close(); } }
- 22 -
运行结果： 换房前信息
由原来的202房换为108房
- 23 -
6.3续房功能的实现
代码如下：
SqlConnection con = myCon.getCon(); con.Open();
if (textBox1.Text.Trim() == \ || textBox2.Text.Trim() == \) {
MessageBox.Show(\请输入房间号和续房天数！\); } else {
string sql = \ + textBox1.Text.Trim(); try {
command = new SqlCommand(sql, con); //con.Open();
string state = (string)command.ExecuteScalar(); if (state == \已入住\) {
sql = \ + textBox1.Text.Trim();
command = new SqlCommand(sql, con); int day = (int)command.ExecuteScalar();
day = Convert.ToInt32(textBox2.Text.Trim()); //if(day>)
string d = Convert.ToString(day);
sql = \ + d + \ + textBox1.Text.Trim();
command = new SqlCommand(sql, con); command.ExecuteNonQuery(); MessageBox.Show(\续房成功！\);
sql = \房号,R_floor as 楼层,R_money as 房价,R_type as 房间类型,R_status as 房间状态,R_intime as 入住时间,R_daoqitime as 退房时间,R_notes as 备注 from Room\;
SqlDataAdapter dapt = new SqlDataAdapter(sql.ToString(), con);
ds = new DataSet(); dapt.Fill(ds, \);
- 24 -