sql server 酒店客房管理系统设计说明书 数据库大作业课程设计说明书 (含源文件)

values(@name,@num,@roomId,@inDate,@outDate)\, conn);

SqlCommand insertCmd1 = new SqlCommand(\客人(姓名,性别,证件类型,证件号码,联系电话)

values(@name,@sex,@cerType,@cerNum,@phone)\, conn);

insertCmd.Parameters.Add(\, SqlDbType.VarChar, 15); insertCmd.Parameters.Add(\, SqlDbType.VarChar, 20); insertCmd.Parameters.Add(\, SqlDbType.VarChar, 20); insertCmd.Parameters.Add(\, SqlDbType.VarChar, 20); insertCmd.Parameters.Add(\, SqlDbType.VarChar, 20);

insertCmd.Parameters[\].Value = txtName.Text; insertCmd.Parameters[\].Value = txtCerNum.Text; insertCmd.Parameters[\].Value = txtRoomId.Text; insertCmd.Parameters[\].Value = txtInDate.Text; insertCmd.Parameters[\].Value = txtOutDate.Text;

insertCmd1.Parameters.Add(\, SqlDbType.VarChar, 15); insertCmd1.Parameters.Add(\, SqlDbType.VarChar, 6);

insertCmd1.Parameters.Add(\, SqlDbType.VarChar, 20); insertCmd1.Parameters.Add(\, SqlDbType.VarChar, 20); insertCmd1.Parameters.Add(\, SqlDbType.VarChar, 20);

insertCmd1.Parameters[\].Value = txtName.Text; insertCmd1.Parameters[\].Value = txtSex.Text;

insertCmd1.Parameters[\].Value = txtCerType.Text; insertCmd1.Parameters[\].Value = txtCerNum.Text; insertCmd1.Parameters[\].Value = txtPhone.Text;

conn.Open();

int flag = insertCmd.ExecuteNonQuery(); insertCmd1.ExecuteNonQuery(); if (flag > 0) {

Label1.Text = \成功提交客人信息！\; } else {

Label1.Text = \提交客人信息失败，查看输入是否正确！\; }

conn.Close();

upDate(); }

private void upDate()

{

string roomId = txtRoomId.Text.Trim(); string selectStr = \; string updateStr = \;

selectStr = \* from 房间 where 房号 = '\ + roomId + \; updateStr = \房间 set 房间状态 = '已住' where 房号 ='\ + roomId + \;

SqlConnection conn = new

SqlConnection(ConfigurationManager.ConnectionStrings[\酒店客房管理系统ConnectionString\].ConnectionString);

SqlCommand selectCmd = new SqlCommand(selectStr, conn); conn.Open();

SqlDataReader sdr = selectCmd.ExecuteReader(); if (sdr.Read()) {

sdr.Close();

SqlCommand updateCmd = new SqlCommand(updateStr, conn); updateCmd.ExecuteNonQuery(); }

conn.Close(); }

protected void Button2_Click1(object sender, EventArgs e) {

Response.Redirect(\); } }

退房结账界面的截图及代码：

图10、退房结账界面截图

public partial class tuifang : System.Web.UI.Page {

protected void Page_Load(object sender, EventArgs e) { }

protected void Button2_Click(object sender, EventArgs e) {

string roomId = TextBox1.Text;

string selectStr = \客人姓名,证件号码,房号,入住日期,预

计离开日期,结账离开日期,应付金额 from 住店 where 房号 = '\ + roomId + \and 状态 is null\;

SqlConnection conn = new

SqlConnection(ConfigurationManager.ConnectionStrings[\酒店客房管理系统ConnectionString\].ConnectionString);

SqlCommand cmd = new SqlCommand(selectStr,conn); conn.Open();

SqlDataReader dr = cmd.ExecuteReader(); if ( dr.Read() ) {

dr.Close();

GridView1.Visible = true; Button1.Visible = true; Button3.Visible = true; } else {

Label1.Text = \此人已经退过房了！\; }

dr.Close(); conn.Close(); }

protected void Button1_Click(object sender, EventArgs e) {

string roomId = TextBox1.Text.Trim(); string selectStr = \; string updateStr = \;

selectStr = \* from 房间 where 房号 = '\ + roomId + \; updateStr = \房间 set 房间状态 = '空' where 房号 ='\ + roomId + \;

SqlConnection conn = new

SqlConnection(ConfigurationManager.ConnectionStrings[\酒店客房管理系统ConnectionString\].ConnectionString);

SqlCommand selectCmd = new SqlCommand(selectStr, conn); conn.Open();

SqlDataReader sdr = selectCmd.ExecuteReader(); if (sdr.Read()) {

sdr.Close();

SqlCommand updateCmd = new SqlCommand(updateStr, conn); updateCmd.ExecuteNonQuery(); }

Label1.Text = \成功退房！\; conn.Close(); upDate1(); update(); }

private void update() {

string roomId = TextBox1.Text.Trim(); string selectStr = \; string updateStr = \;

selectStr = \* from 住店 where 房号 = '\ + roomId + \; updateStr = \住店 set 状态 = '已退房' where 房号 ='\ + roomId + \;

SqlConnection conn = new

SqlConnection(ConfigurationManager.ConnectionStrings[\酒店客房管理系统ConnectionString\].ConnectionString);

SqlCommand selectCmd = new SqlCommand(selectStr, conn); conn.Open();

SqlDataReader sdr = selectCmd.ExecuteReader(); if (sdr.Read()) {

sdr.Close();

SqlCommand updateCmd = new SqlCommand(updateStr, conn); updateCmd.ExecuteNonQuery(); }

conn.Close(); }

private void upDate1() {

string roomId = TextBox1.Text.Trim(); SqlConnection conn = new

SqlConnection(ConfigurationManager.ConnectionStrings[\酒店客房管理系统ConnectionString\].ConnectionString);

SqlCommand cmd = conn.CreateCommand(); string money; string date; conn.Open(); int i;

for (i = 0; i < GridView1.Rows.Count; i++) {

date =

((TextBox)GridView1.Rows[i].FindControl(\)).Text.Trim(); money =

((TextBox)GridView1.Rows[i].FindControl(\)).Text.Trim();