string time = this.textBox1.Text.Trim(); string year = time.Substring(0, 4);
string sql = \R_ID as 房号,R_money as 房价,R_type as 房间类型,R_status as 房间状态,R_intime as 入住时间,R_daoqitime as 退房时间,R_notes as 备注from Room where year(R_daoqitime)='\ + year + \;
SqlDataAdapter dapt = new SqlDataAdapter(sql, con); dapt.Fill(dst, \);
dataGridView1.DataSource = dst.Tables[0];
float sun = 0;
for (int i = 0; i < dataGridView1.RowCount; i++) {
if (!dataGridView1.Rows[i].IsNewRow)
sun = sun + float.Parse(dataGridView1[1, i].Value.ToString()); }
label1.Text = \按年报表查询，总额为：\ + sun.ToString() + \元\;
con.Close(); } }
else {
MessageBox.Show(\格式不正确，请输入xxxx-xx-xx或输入xxxx-xx或输入xxxx\);
} }
- 33 -
运行结果：
查询2012-6-24的一天的营业额
6.6住宿记录查询功能的实现
代码如下：
SqlConnection con = myCon.getCon();
con.Open();
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, \);
dataGridView1.DataSource = ds.Tables[0];
con.Close();
- 34 -
运行结果：
6.7房间类型管理功能的实现
代码如下：
if (comboBox1.Text == \) {
MessageBox.Show(\请选择需要更改的房间类型！\); } else {
SqlConnection cnn = myCon.getCon(); cnn.Open();
string sql = \ +
comboBox1.SelectedItem.ToString() + \ + this.comboBox2.Text + \; SqlCommand cmd = new SqlCommand(sql, cnn); cmd.ExecuteNonQuery();
MessageBox.Show(\更新成功！\); }
- 35 -
运行结果： 更改前
更新后
6.8房间信息管理功能的实现
代码如下：
private void button1_Click(object sender, EventArgs e) {
SqlConnection cnn = myCon.getCon();
string sql = \R_ID from Room where R_ID='\ + this.textBox1.Text + \;
cnn.Open();
SqlCommand cmd = new SqlCommand(sql, cnn); string rt = (string)cmd.ExecuteScalar(); if (textBox1.Text == rt)
MessageBox.Show(\已存在房间号！\);
- 36 -