《HHL酒店管理系统》课程设计报告书V1.0 - 图文

点击“退房”后

- 29 -

退房后，108房会自动变为空房

6.5营业查询功能的实现

代码如下：

string str = @\; string str1 = @\; string str2 = @\;

private void FrmHotelExpense_Load(object sender, EventArgs e) {

using (SqlConnection con = myCon.getCon()) {

con.Open();

StringBuilder sql = new StringBuilder();

sql.Append(\房号,R_money as 房价,R_type as 房间类型,R_status as 房间状态,R_intime as 入住时间,R_daoqitime as 退房时间,R_notes as 备注from Room\);

- 30 -

SqlDataAdapter dapt = new SqlDataAdapter(sql.ToString(), con); ds = new DataSet(); dapt.Fill(ds, \);

}

dataGridView1.DataSource = ds.Tables[0];

}

private void butri_Click(object sender, EventArgs e) {

if (textBox1.Text == \) {

MessageBox.Show(\日期不能为空\); }

//日报表查询

else if (Regex.IsMatch(textBox1.Text.Trim(), str)) {

DataSet ds = new DataSet();

using (SqlConnection con = myCon.getCon()) {

con.Open();

DataSet dst = new DataSet();

string sql = string.Format(\R_ID as 房号,R_money as 房价,R_type as 房间类型,R_status as 房间状态,R_intime as 入住时间,R_daoqitime as 退房时间,R_notes as 备注from Room where R_daoqitime='{0}'\, this.textBox1.Text); 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();

- 31 -

} }

//月报表查询

else if (Regex.IsMatch(textBox1.Text.Trim(), str1)) {

DataSet ds = new DataSet();

using (SqlConnection con = myCon.getCon()) {

con.Open();

DataSet dst = new DataSet();

string time = this.textBox1.Text.Trim(); string year = time.Substring(0, 4); string month = time.Substring(5, 2);

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 + \ + month + \;

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 if (Regex.IsMatch(textBox1.Text.Trim(), str2)) {

ds = new DataSet();

using (SqlConnection con = myCon.getCon()) {

con.Open();

DataSet dst = new DataSet();

- 32 -