軟件工程課程設(shè)計(jì)賓館信息管理系統(tǒng)

1、分類號(hào)編號(hào)華北水利水電大學(xué)North China University of Water Resources and Electric Power實(shí)驗(yàn)報(bào)告課 程： 軟件工程實(shí)驗(yàn)項(xiàng)目2:軟件編碼與測(cè)試題 目：賓館管理信息系統(tǒng)院系信息工程學(xué)院專業(yè)計(jì)算機(jī)科學(xué)與技術(shù)班級(jí)學(xué)號(hào)201415717姓名李衛(wèi)朋指導(dǎo)教師 莊晉林2017年5月29日華北水利水電大學(xué)軟件工程實(shí)驗(yàn)報(bào)告201620生學(xué)年 第 二 學(xué)期 2014 級(jí) 計(jì)算機(jī)科學(xué)與技術(shù)專業(yè)一、實(shí)驗(yàn)內(nèi)容：賓館管理信息系統(tǒng)任務(wù)：入住或預(yù)訂客房時(shí)，用戶要對(duì)客戶管理模塊或預(yù)訂管理模塊進(jìn)行核對(duì)審查, 并進(jìn)行登記；客戶換房時(shí)，要對(duì)換房信息進(jìn)行查詢和更新；客戶退房時(shí)，要

2、進(jìn)行結(jié)算， 并對(duì)更新客房信息。主要功能模塊：(1)登錄模塊：對(duì)用戶身份進(jìn)行驗(yàn)證，只有合法用戶才能進(jìn)入系統(tǒng)；(2)系統(tǒng)管理模塊：對(duì)系統(tǒng)用戶進(jìn)行管理，更改用戶名、密碼、權(quán)限等；(3)客房管理模塊：對(duì)客房信息的添加、修改和刪除等；(4)入住管理模塊：對(duì)客戶入住信息的登記、查詢等功能(5)訂房管理模塊：對(duì)客戶訂房信息的登記、查詢等。(6)換房管理模塊：對(duì)客戶換房信息的登記、查詢等(7)賓館結(jié)算模塊：對(duì)已入住賓館的顧客進(jìn)行結(jié)算及對(duì)訂房客戶已交的押金進(jìn)行 結(jié)算、查詢。二、程序源：Win7 64 位電腦，vs2012編輯環(huán)境，sql2005數(shù)據(jù)庫(kù)。程序源碼：1、登錄設(shè)計(jì)：namespace賓館管理信息系統(tǒng)p

3、ublic partial class loginl : Formpublic login1()InitializeComponent();private connection c = new connection。；private void button1_Click(object sender, EventArgs e)if (textBox1.Text.Trim().ToString()!= String.Empty && textBox2.Text.Trim().ToString() != String.Empty)精品資料string id = null, pw =

4、null, gd = null;var result = from info in c.linq.loginwhere info.id = textBox1.Text.ToString().Trim() select new ID = info.id,pw = info.password,Igd = info.grade,;if (result.Count() = 0)|MessageBox.Show("用戶名不存在！”)；else if (result.Count() = 1)foreach (var p in result)id = p.ID;pw = p.pw;gd = p.g

5、d;if (pw.Trim() = textBox2.Text.ToString().Trim() this.Hide();|manger lf = new manger(gd,textBox1.Text.Trim().ToString(); lf.Show();| elseMessageBox.Show("密碼錯(cuò)誤！");else I MessageBox.Show("不能為空！");private void button2_Click(object sender, EventArgs e) this.Close();|private void log

6、in1_FormClosed(object sender, FormClosedEventArgs e)System.Environment.Exit(0); 2、添加住戶設(shè)計(jì) namespace賓館管理信息系統(tǒng) public partial class addpeople : Form private connection c = new connection。； private string s;Ipublic addpeople(Form f,string s) this.Owner = f;IInitializeComponent();this.s = s;房問(wèn)號(hào)comboBox1.D

7、ropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;private void button1_Click(object sender, EventArgs e) if (textBox1.Text.Trim().ToString() != String.Empty && comboBox1.Text.Trim().ToString() != String.Empty && textBox3.Text.Trim().ToString() != String.Empty &&

8、textBox4.Text.Trim().ToString() != String.Empty)var result = from info in c.linq.roomwhere info.房間號(hào)碼 =s.Trim().ToString()select new| 房間號(hào)=info. 房間號(hào)碼， 房間類型=info.房間種類， 房間單價(jià)=info.房間單價(jià)， 房間是否使用=info.房間是否正在使用， ;foreach (var item in result)|if (item.房間單價(jià) <=int.Parse(textBox4.Text.Trim().ToString()try gue

9、st r = new guest(); r.住店人身份證號(hào)碼 =textBox1.Text.Trim().ToString();r.姓名=textBox2.Text.Trim().ToString();r.性另 ij = comboBox1.Text.Trim().ToString();精品資料r.所交押金=int.Parse(textBox4.Text.Trim().ToString();r.人數(shù)=textBox3.Text.Trim().ToString();r.房間號(hào)碼=s；r.入住天數(shù)=1;r.入住時(shí)間=System.DateTime.Now.Day.ToString(); var e

10、dit = c.linq.room.SingleOrDefault<room>(s1 => s1.房間號(hào)碼 =s.Trim().ToString();if (edit = null)| return; edit.房間是否正在使用="是"；c.linq.guest.InsertOnSubmit(r);Ic.linq.SubmitChanges();I/修改student的屬性；MessageBox.Show(textBox2.Text.Trim().ToString() + "入住成功");this.Close(); catch Mess

11、ageBox.Show("用戶已存在！"); elseI MessageBox.Show("所交押金不足！"); else MessageBox.Show("不能為空！"); private void addpeople_FormClosed(object sender, FormClosedEventArgs e) this.Owner.Owner.Show(); 3、添加房間設(shè)計(jì)： namespace賓館管理信息系統(tǒng) public partial class addroom : Form精品資料public addroom(For

12、m f) InitializeComponent();Ithis.Owner = f; comboBoxl.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; private connection c = new connection。； private void button1_Click(object sender, EventArgs e) if (textBox1.Text.Trim().ToString() != String.Empty && comboBox1.Text.Trim().T

13、oString() != String.Empty && textBox3.Text.Trim().ToString() != String.Empty)tryI room r = new room(); r.房間號(hào)碼=textBox1.Text.Trim().ToString();r.房間種類=comboBox1.Text.Trim().ToString();r.房間單價(jià)=double.Parse( textBox3.Text.Trim().ToString();r.房間是否正在使用="否"； c.linq.room.InsertOnSubmit(r);I

14、c.linq.SubmitChanges(); MessageBox.Show(textBox1.Text.Trim().ToString()+”號(hào)房間添加成功");this.textBox1.Text = null; this.textBox3.Text = null; boBox1.Text = null;|this.textBox1.Focus(); catchI MessageBox.Show("房間號(hào)已存在！"); else I MessageBox.Show("不能為空！"); private void addroom_FormCl

15、osed(object sender, FormClosedEventArgs e) this.Owner.Show();| private void button2_Click(object sender, EventArgs e)this.Close();4、查看所有房間信息設(shè)計(jì)：namespace賓館管理信息系統(tǒng) public partial class allroom : Formprivate connection c=new connection (); public allroom(Form f)IInitializeComponent();this.Owner = f;Ithi

16、s.listView1.Clear();|this.listView1.View = View.LargeIcon;this.listView1.LargeImageList = this.imageList1;Random rd = new Random();this.listView1.BeginUpdate();var result = from info in c.linq.room select newI 房間號(hào)=info.房間號(hào)碼，房間類型=info.房間種類， 房間單價(jià)=info.房間單價(jià)， 房間是否使用=info.房間是否正在使用;foreach (var item in re

17、sult)IListViewItem lvi = new ListViewItem(); if(item.房間是否使用.Trim()="否") lvi.ImageIndex =0;| else if (item.房間是否使用.Trim()="是") lvi.ImageIndex = 1; lvi.Text = item.房間號(hào).Trim().ToString();this.listView1.Items.Add(lvi);| this.listView1.EndUpdate();|精品資料private void listView1_ItemActiva

18、te(object sender, EventArgs e) var result = from info in c.linq.room where info.房間號(hào)碼=listView1.FocusedItem.Text.Trim().ToString()select newI 房間號(hào)=info. 房間號(hào)碼， 房間類型=info.房間種類， 房間單價(jià)=info.房間單價(jià)， 房間是否使用=info.房間是否正在使用， ; foreach (var item in result)I DialogResult dr = MessageBox.Show("房間號(hào)："+ listV

19、iew1.FocusedItem.Text.ToString() + "rn房間類型:item.房間類型+ "rn房間單價(jià)："+ item.房間單價(jià))； private void allroom_FormClosed(object sender, FormClosedEventArgs e) this.Owner.Show();I 5、預(yù)訂房間設(shè)計(jì)： namespace賓館管理信息系統(tǒng) public partial class bookroom : Form private connection c = new connection(); public bookr

20、oom(Form f) InitializeComponent();this.Owner = f;|this.listView1.Clear();Ithis.listView1.View = View.LargeIcon;this.listView1.LargeImageList = this.imageList1;IRandom rd = new Random();this.listView1.BeginUpdate();|var result = from info in c.linq.room where info.房間是否正在使用="否"select newI 房間

21、號(hào) =info. 房間號(hào)碼，房間類型=info.房間種類， 房間單價(jià)=info.房間單價(jià)， 房間是否使用=info.房間是否正在使用， ；foreach (var item in result) ListViewItem Ivi = new ListViewItem();Ivi.Imagelndex =0;Ilvi.Text = item.房間號(hào).Trim().ToString();this.listView1.Items.Add(lvi);| this.listView1.EndUpdate(); private void bookroom_FormClosed(object sender,

22、 FormClosedEventArgs e) this.Owner.Show(); private void listView1_ItemActivate(object sender, EventArgs e) var result = from info in c.linq.roomwhere info.房間號(hào)碼=listView1.FocusedItem.Text.Trim().ToString()select newI 房間號(hào)=info. 房間號(hào)碼， 房間類型=info.房間種類， 房間單價(jià)=info.房間單價(jià)， 房間是否使用=info.房間是否正在使用，; foreach (var

23、item in result)|DialogResultdr = MessageBox.Show("房間號(hào)："+ listView1.FocusedItem.Text.ToString() + "rn 房間類型："+item.房間類型+"rn房間單價(jià)："+item.房間單價(jià)+"rn 確認(rèn)使用么？","提示"，MessageBoxButtons.OKCancel);if (dr = DialogResult.OK) /用戶選擇確認(rèn)的操作addpeople a = new addpeople(thi

24、s, listView1.FocusedItem.Text.Trim().ToString();this.Hide();Ia.Show(); 6、查看所有用戶設(shè)計(jì): namespace賓館管理信息系統(tǒng)public partial class chakanyonghu : FormIprivate connection c = new connection。；public chakanyonghu(Form f) Ithis.Owner = f;IInitializeComponent();Ivar result = from info in c.linq.loginselect newI用戶名

25、=info.id, 用戶類型=info.grade,;dataGridView1.DataSource = result;7、修改房間的信息設(shè)計(jì)：namespace賓館管理信息系統(tǒng)public partial class changeroom : Formprivate connection c = new connection。；public changeroom(Form f) |InitializeComponent();Ithis.Owner = f;Ivar result = from info in c.linq.roomselect newI房間號(hào)=info. 房間號(hào)碼，房間類型

26、=info.房間種類，房間單價(jià)=info.房間單價(jià)，房間是否使用=info.房間是否正在使用，;dataGridView1.DataSource = result;private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)string s = Convert.ToString(dataGridView10, e.RowIndex.Value).Trim();changeroom2 d = new changeroom2(this, s);d.Show(); Ithis.Hide()

27、;Iprivate void button1_Click(object sender, EventArgs e)var result = from info in c.linq.roomselect newI房間號(hào)=info. 房間號(hào)碼，房間類型=info.房間種類，房間單價(jià)=info.房間單價(jià)，房間是否使用=info.房間是否正在使用，;dataGridView1.DataSource = result;namespace賓館管理信息系統(tǒng)public partial class changeroom2 : Formprivate connection c = new connection()

28、;private string s = null;Ipublic changeroom2(Form f,string s)InitializeComponent();comboBox1.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;comboBox2.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; this.Owner = f;this.s = s;Ivar result = from info in c.linq.roomwher

29、e info.房間號(hào)碼=sselect newI房間號(hào)=info. 房間號(hào)碼，房間類型=info.房間種類，房間單價(jià)=info.房間單價(jià)，房間是否使用=info.房間是否正在使用，;foreach (var item in result)|this.textBox2.Text = item.房間號(hào);this.textBox1.Text = item.房間單價(jià).ToString();boBox1.Text = item.房間類型;boBox2.Text = item.房間是否使用；private void button1_Click(object sender, EventArgs e)if (

30、textBox1.Text.Trim().ToString() != String.Empty && textBox2.Text.Trim().ToString() != String.Empty &&comboBox1.Text.Trim().ToString() != String.Empty && comboBox2.Text.Trim().ToString() != String.Empty)var edit = c.linq.room.SingleOrDefault<room>(s1=>s1.房間號(hào)碼=s);if (e

31、dit = null)return;/修改student的屬性edit.房間單價(jià)=double .Parse( textBox1.Text.Trim().ToString();edit.房間種類=comboBox1.Text.Trim().ToString();edit.房間是否正在使用 =comboBox2.Text.Trim().ToString();/執(zhí)行更新操作c.linq.SubmitChanges();IMessageBox.Show("房間信息彳改成功")；this.Close();| 8、刪除用戶信息設(shè)計(jì)： namespace賓館管理信息系統(tǒng) public

32、partial class delete : Form private string s;Iprivate connection c = new connection。； public delete(Form f)I InitializeComponent();Ithis.Owner = f;Ivar result = from info in c.linq.loginwhere info.grade="普通用戶"select new 用戶名=info.id, 用戶類型=info.grade,；dataGridViewl.DataSource = result; priva

33、te void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e) s = Convert.ToString(dataGridView10, e.RowIndex.Value).Trim();Idelete2 d = new delete2(s,this );d.Show(); I this.Hide(); private void button2_Click(object sender, EventArgs e) var result = from info in c.linq.loginIwhe

34、re info.grade ="普通用戶"select newI用戶名=info.id, | 用戶類型=info.grade,;dataGridView1.DataSource = result; namespace賓館管理信息系統(tǒng) public partial class delete2 : Form private string h; private connection c = new connection。； public delete2(string s,Form f) InitializeComponent();Ih = s; this.Owner = f;|v

35、ar result = from info in c.linq.login where info.id = s select newI 用戶名=info.id, 用戶類型=info.grade,;dataGridViewl.DataSource = result;private void button1_Click(object sender, EventArgs e)var result = from m in c.linq.loginIwhere m.id = hselect m;Ic.linq.login.DeleteAllOnSubmit(result);c.linq.SubmitCh

36、anges();MessageBox.Show("刪除成功");this.Close();9、刪除房間信息設(shè)計(jì)：namespace賓館管理信息系統(tǒng)public partial class deleteroom : Formprivate connection c = new connection。； public deleteroom(Form f)InitializeComponent();this.Owner = f;Ivar result = from info in c.linq.room select new|房間號(hào)=info. 房間號(hào)碼，房間類型=info.房間

37、種類，房間單價(jià)=info.房間單價(jià)，房間是否使用=info.房間是否正在使用 ;dataGridView1.DataSource = result;private void button2_Click(object sender, EventArgs e)var result = from info in c.linq.room select new 房間號(hào)=info. 房間號(hào)碼，房間類型=info.房間種類，房間單價(jià)=info.房間單價(jià)，房間是否使用=info.房間是否正在使用，；dataGridViewl.DataSource = result;private void dataGridV

38、iew1_CellDoubleClick(object sender, DataGridViewCellEventArgs e) string s = Convert.ToString(dataGridView10, e.RowIndex.Value).Trim();deleteroom2 d = new deleteroom2(this,s);d.Show(); Ithis.Hide();namespace賓館管理信息系統(tǒng)public partial class deleteroom2 : Formprivate connection c = new connection。；private

39、string h;Ipublic deleteroom2(Form f,string h)InitializeComponent();Ithis.Owner = f;this.h = h;Ivar result = from info in c.linq.roomwhere info.房間號(hào)碼=hselect new房間號(hào)=info.房間號(hào)碼，房間類型=info.房間種類，房間單價(jià)=info.房間單價(jià)，房間是否使用=info.房間是否正在使用，;dataGridView1.DataSource = result;private void button1_Click(object sender,

40、 EventArgs e)var result = from m in c.linq.roomwhere m.房間號(hào)碼 =hselect m;foreach (var item in result)|if (item.房間是否正在使用.Trim().ToString()=" 否")c.linq.room.DeleteAllOnSubmit(result);c.linq.SubmitChanges();MessageBox.Show("刪除成功")；this.Close(); else MessageBox.Show("該房間正在使用,請(qǐng)先退房！

41、")； 10、查看住戶信息： namespace賓館管理信息系統(tǒng) public partial class guestmessage : Form private connection c = new connection。； public guestmessage(Form f) this.Owner = f; InitializeComponent(); comboBox1.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; private void button1_Click(object sende

42、r, EventArgs e) if (comboBox1.Text.Trim().ToString() != string.Empty && textBox1.Text.Trim().ToString() != string.Empty) switch (comboBox1.Text.Trim().ToString() case "房間號(hào)"：var edit = c.linq.guest.SingleOrDefault<guest>(s1 => s1.房間號(hào)碼.Trim()=textBox1.Text.Trim().ToString();

43、 | if (edit != null)|MessageBox.Show("房間號(hào)："+ edit. 房間號(hào)碼 + "tn" + " 人數(shù)："+ edit. 人數(shù) + "tn" + " 入住天數(shù)："+ edit.入住天數(shù)+ "tn" + " 押金："+ edit.所交押金+ "tn" + " 姓名："+ edit. 姓名+ "tn" + "身份證號(hào)碼："+ edit.住店人身份

44、證號(hào)碼); else MessageBox.Show("房間為空！")；break;Icase "用戶姓名"：var editl = c.linq.guest.SingleOrDefault<guest>(s1 => s1.姓名.Trim()=textBox1.Text.Trim().ToString(); if (editl != null) MessageBox.Show("房間號(hào)："+ edit1. 房間號(hào)碼 + "tn" + " 人數(shù)："+ edit1. 人數(shù) + &q

45、uot;tn" + " 入住天數(shù)："+ edit1.入住天數(shù)+ "tn" + " 押金："+ edit1. 所交押金+ "tn" + " 姓名："+ edit1. 姓名+ "tn" + "身份證號(hào)碼："+edit1.住店人身份證號(hào)碼); elseIMessageBox.Show(textBox1.Text.Trim().ToString() + "不存在"); break; case "身份證號(hào)"：var

46、edit2 = c.linq.guest.SingleOrDefault<guest>(s1 => s1.住店人身份證號(hào)碼 .Trim()=textBox1.Text.Trim().ToString(); | if (edit2 != null) MessageBox.Show("房間號(hào)："+ edit2. 房間號(hào)碼 + "tn" + " 人數(shù)："+ edit2. 人數(shù) + "tn" + " 入住天數(shù)："+ edit2.入住天數(shù)+ "tn" + "

47、 押金："+ edit2. 所交押金+ "tn" + " 姓名："+ edit2. 姓名+ "tn" + "身份證號(hào)碼："+edit2.住店人身份證號(hào)碼); else不存在");MessageBox.Show(textBox1.Text.Trim().ToString() + break;I else MessageBox.Show("不能為空！"); 11、新用戶注冊(cè)namespace賓館管理信息系統(tǒng) public partial class login2 : Form p

48、rivate connection c = new connection。；public login2() I InitializeComponent();IcomboBoxl.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; public login2(Form f)IInitializeComponent();Ithis.Owner = f; comboBox1.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; private vo

49、id button1_Click(object sender, EventArgs e) 一if (textBox1.Text.Trim().ToString() != String.Empty && textBox2.Text.Trim().ToString() != String.Empty && textBox3.Text.Trim().ToString() != String.Empty && comboBox1.Text.Trim().ToString() != String.Empty) if (comboBox1.Text.Trim

50、().ToString()="管理員"| comboBox1.Text.Trim().ToString()="普通用戶")if (this.textBox2.Text.Trim().ToString() = textBox3.Text.Trim().ToString() tryI login l = new login();Il.id = textBox1.Text.Trim().ToString();|l.password = textBox2.Text.Trim().ToString();l.grade = comboBox1.Text.Trim()

51、.ToString(); c.linq.login.InsertOnSubmit(l);c.linq.SubmitChanges();MessageBox.Show("注冊(cè)成功"); catchI MessageBox.Show("用戶名已存在！"); elseI MessageBox.Show("請(qǐng)?jiān)俅屋斎氪_定密碼！")；elseIMessageBox.Show("請(qǐng)選擇正確的用戶類型！");boBox1.Focus(); else MessageBox.Show("不能為空！")；12、主界

52、面設(shè)計(jì)：namespace賓館管理信息系統(tǒng)public partial class manger : Form private string i,j;/ public manger() I InitializeComponent();Ipublic manger(string i,string j)InitializeComponent();this.i = i;|this.j = j;private void button1_Click(object sender, EventArgs e)this.Hide();|login2 l = new login2(this);l.Show();

53、| private void manger_Load(object sender, EventArgs e) if (i.Trim().Equals("管理員")this.panel1.Visible = true;this.panel2.Visible = true ;else if (i.Trim().Equals("普通用戶") this.panel2.Visible = true; this.panell.Visible = false;Iprivate void button3_Click(object sender, EventArgs e)

54、 this.Hide();|delete l = new delete(this);Il.Show();private void manger_FormClosed(object sender, FormClosedEventArgs e) System.Environment.Exit(0);I private void button4_Click(object sender, EventArgs e) this.Hide();|chakanyonghu l = new chakanyonghu(this);Il.Show(); |private void button5_Click(obj

55、ect sender, EventArgs e) this.Hide();|xiugaimima l = new xiugaimima(this, j); l.Show(); Iprivate void button6_Click(object sender, EventArgs e) this.Hide();|addroom l = new addroom(this);Il.Show();private void button7_Click(object sender, EventArgs e) this.Hide();Ideleteroom l = new deleteroom(this)

56、; l.Show(); |private void button8_Click(object sender, EventArgs e)this.Hide();|changeroom l = new changeroom(this);l.Show(); private void button2_Click(object sender, EventArgs e) this.Hide();Ibookroom l = new bookroom(this); l.Show(); Iprivate void button9_Click(object sender, EventArgs e) this.Hide();|unsubscribe l = new unsubscribe(this);Il.Show(); private void button10_Click(object sender, EventArgs e) this.Hide();Iallroom l = new allroom(this); l.Show(); |private connection c = new connection。； priva