賓館管理系統(tǒng)C-數(shù)據(jù)庫(kù)課程設(shè)計(jì)

第一章緒論發(fā)展。勢(shì)。理快速，并能在第一時(shí)間得知房間的狀態(tài)信息。術(shù)改變酒店業(yè)務(wù)模式，實(shí)現(xiàn)酒店業(yè)務(wù)管理的自動(dòng)化已經(jīng)成為一種必然。國(guó)內(nèi)的賓館計(jì)算機(jī)管理系統(tǒng)于上世紀(jì)80年代初起步，到了80年代中后期，國(guó)內(nèi)實(shí)際的情況下逐步發(fā)展成熟，到90年代初期形成了幾個(gè)較成熟的軟件系統(tǒng)，同時(shí)產(chǎn)生了許多專(zhuān)職從事賓館計(jì)算機(jī)管理系統(tǒng)的公司。到了90年代中期，隨著不斷涌現(xiàn)。能發(fā)展有如下幾大趨勢(shì)：(1).軟件產(chǎn)品集成化(2).操作界面人性化(3).注重客戶關(guān)系管理(4).從數(shù)據(jù)處理型向決策型發(fā)展(5).系統(tǒng)開(kāi)放化操作(6).增值產(chǎn)品/服務(wù)功能增加操作(7).支持電子商務(wù)(8).賓館集團(tuán)型管理軟件的虛擬競(jìng)爭(zhēng)空間。和社會(huì)信譽(yù)必定有著積極的意義。第二章需求分析求分析描述如下入住2.2數(shù)據(jù)流需求分析：息 息 數(shù)據(jù)庫(kù)用戶登登錄數(shù)據(jù)庫(kù)需求分析——數(shù)據(jù)流圖客戶類(lèi)型管理客房管理客戶查詢(xún)客戶入住客戶結(jié)算用戶管理系統(tǒng)幫助退出系統(tǒng)客戶類(lèi)型管理客房管理客戶查詢(xún)客戶入住客戶結(jié)算用戶管理系統(tǒng)幫助退出系統(tǒng)ameNativePlace第三章概要設(shè)計(jì)系統(tǒng)功能概述圖3.2Client信息E-R圖：3.3ClientBookIn信息E-R圖InDateeymarkserPasswordserSortInDateeymarkserPasswordserSortmIDkInte3.4管理員用戶E-R圖serIDUsermark3.5客房信息E-R圖markmIDPostionmpleNumeaceNumnepleNumionmarkmIDPostionmpleNumeaceNumnepleNumionTypeNameNumtPeopleNum3.6客房類(lèi)型信息E-R圖TypeName RoomType rCondition第四章數(shù)據(jù)庫(kù)的表的建立與實(shí)現(xiàn)Client表的建立：ClientBookIn表的建立：Room表的建立：RoomType表的建立：User表的建立：第五章詳細(xì)設(shè)計(jì)能建立一個(gè)窗口，從公共控件中添加label，button控件到窗口，編輯按鈕程序，User理員輸入的信息進(jìn)行驗(yàn)證，判斷是否可以通過(guò)；調(diào)用getNumber()函數(shù)隨機(jī)生成驗(yàn)證碼，保證安全性。關(guān)于驗(yàn)證碼，每次調(diào)要比較時(shí)再拿出來(lái)，注意驗(yàn)證碼不分大小寫(xiě)。相關(guān)運(yùn)行截圖如下：陸界面5-1-2登錄驗(yàn)證陸出錯(cuò)陸成功型管理功能建立一個(gè)窗口，從公共控件中添加label，button，textbox，GirdView等控件到窗口，編輯按鈕程序，插入圖片；GirdView需要配置數(shù)據(jù)源，對(duì)數(shù)據(jù)庫(kù)中的對(duì)客房類(lèi)型的的信息進(jìn)行編輯，包括類(lèi)型(普通，貧民，豪華)客房面積 (30,60,90)額定床數(shù)(1,2,3,4)額定人數(shù)(1,2,3,4)價(jià)錢(qián)(50,500)電視 (有，無(wú))電話(有，無(wú))空調(diào)(有，無(wú))衛(wèi)生間(有，無(wú))這些屬性，對(duì)客房類(lèi)型進(jìn)行增刪改查功能操作。wRowCancelingEdit在一個(gè)處于編輯模式的行的Cancel按鈕被單擊，但是在該行退出編輯模式之前發(fā)生。RowCommand單擊一個(gè)按鈕時(shí)發(fā)生。RowCreated創(chuàng)建一行時(shí)發(fā)生。RowDataBound一個(gè)數(shù)據(jù)行綁定到數(shù)據(jù)時(shí)發(fā)生。RowDeleting,RowDeleted行的Delete按鈕被單擊時(shí)發(fā)生。它們分別在該網(wǎng)格控件刪除該行之前和之后激發(fā)。RowEditing當(dāng)一行的Edit按鈕被單擊時(shí)，是在一行的Update按鈕被單擊時(shí)發(fā)生。它們分別在該網(wǎng)格控件更新該行之前和之后激發(fā)。SelectedIndexChanging,SelectedIndexChanged這兩個(gè)事件都是在一行ect它們分別在網(wǎng)格控件處理排序操作之前和之后激發(fā)相關(guān)運(yùn)行截圖如下：房類(lèi)型管理界面房類(lèi)型管理添加功能界面管理功能口，編輯按鈕程序，插入圖片；GirdView需要配置數(shù)據(jù)源，對(duì)數(shù)據(jù)庫(kù)中的內(nèi)容對(duì)客房的的信息進(jìn)行編輯，包括房間號(hào)碼 (1,2,3,4)房間樓層(一樓，二樓，三樓)增刪改查等功能操作?？头棵娣e(30,60,90)額定人數(shù)額定床數(shù)這些屬性，對(duì)客房進(jìn)行首先來(lái)說(shuō)控件的屬性，msitems果(3)SelectioModes:獲取或設(shè)置在ListBox中選擇項(xiàng)所用的方法。一共有四個(gè)e擇；當(dāng)屬性MultiExtended時(shí)，按下Shift鍵的同時(shí)單擊鼠標(biāo)或者同時(shí)Shift鍵和箭頭鍵之一(向上鍵、向下鍵、向左鍵和向右鍵)，會(huì)將選定內(nèi)容從前一選定項(xiàng)擴(kuò)展到當(dāng)前項(xiàng)。按Ctrl鍵的同時(shí)單擊鼠標(biāo)將選擇或撤消選擇列表中的某項(xiàng)；的某項(xiàng)。綁數(shù)據(jù)綁定還有一點(diǎn)區(qū)別，ASP.NET中綁定數(shù)據(jù)后還要調(diào)用一個(gè)DataBind方法，而在c#中就不需要。而DisplayMember獲取或設(shè)置要顯示的屬性。截圖如下房類(lèi)型管理添加功能界面戶入住功能等控件到窗口，編輯按鈕程序，插入圖片；GirdView需要配置數(shù)據(jù)源，對(duì)數(shù)據(jù)庫(kù)中的內(nèi)容進(jìn)行顯示輸入查詢(xún)條件，包括的屬性有房間號(hào)碼房間類(lèi)型房間樓底額定床數(shù)額定人數(shù)實(shí)際人數(shù)其他條件，與數(shù)據(jù)庫(kù)的數(shù)據(jù)進(jìn)行比對(duì)，查找該客住，則進(jìn)行登記，跳轉(zhuǎn)到客戶入住界面。記錄。將客戶的基本信息包括身份賬號(hào)，姓名，性別，籍貫，以及入住的時(shí)間，要添加一個(gè)日歷的控件是一個(gè)傳統(tǒng)的單月份日歷，用戶可以使用該日歷查看和選擇日期。Calendar控件提供的功能：截圖如下客房查詢(xún)界面客戶入住界面客戶結(jié)算功能等控件到窗口，編輯按鈕程序，插入圖片；GirdView需要配置數(shù)據(jù)源，輸入身，輸入應(yīng)收金額，確認(rèn)是否對(duì)住戶打折，這里面包括VIP等節(jié)假日的因素不便多說(shuō)，已經(jīng)結(jié)賬的客戶界面賬截圖如下客戶查詢(xún)界面要結(jié)賬的用戶界面客戶結(jié)算界面已結(jié)算客戶界面功能等控件到窗口，編輯按鈕程序，插入圖片；GirdView需要配置數(shù)據(jù)源，編輯新使用新用戶進(jìn)行登錄截圖如下戶管理功能界面小結(jié)過(guò)，去的東西我們根本不知道。同時(shí)也發(fā)現(xiàn)有很多已經(jīng)學(xué)過(guò)的東西我們沒(méi)有理解到位，種文檔一開(kāi)始話，我，去圖分析現(xiàn)有情況及問(wèn)題，由于忘記了一些C#語(yǔ)言的規(guī)范使得在調(diào)試過(guò)程中一些錯(cuò)習(xí)并應(yīng)用了SQL語(yǔ)言，對(duì)數(shù)據(jù)庫(kù)的創(chuàng)建、修改、刪除方法有了一定的了解，通過(guò)導(dǎo)入情不是想象中的那么簡(jiǎn)單的，它涉及到的各種實(shí)體、屬性、數(shù)據(jù)流程、數(shù)據(jù)處理等等。塊和安全性、完整性不覺(jué)就會(huì)在物理結(jié)構(gòu)設(shè)計(jì)中添加一些安全設(shè)置：主鍵約束、check鍵上建立索引，這樣可以明顯加快檢索的速度，最后別忘記重要的安全性設(shè)置，么，我會(huì)用哪種編譯工具，后來(lái)選擇了MicrosoftVisualStudio,在編寫(xiě)程序時(shí)，編寫(xiě)程序一步步實(shí)現(xiàn)了，通過(guò)這次課程設(shè)計(jì)使我收獲了好多，熟悉了C#的運(yùn)用，還復(fù)習(xí)了數(shù)據(jù)庫(kù)相關(guān)語(yǔ)句的編寫(xiě)。自事，難點(diǎn)在于數(shù)據(jù)庫(kù)的連接和編程語(yǔ)言的選擇。C#的功能很強(qiáng)大，這也是我以步一步實(shí)現(xiàn)其功能！的不足，并希望以后能更加用心地運(yùn)用所學(xué)知識(shí)和學(xué)習(xí)新的知識(shí)。[2].施平安清華大學(xué)出版社,2005[4]數(shù)據(jù)庫(kù)系統(tǒng)概論高等教育出版社2006附錄C#語(yǔ)言代碼如下：namespace_2010_HotelManage{publicpartialclasslogin:Form{MainFormmfnewMainForm();authcodeauthcodenewauthcode;conndataconnewconndata;publiclogin(){itializeComponent}privatevoidlogin_Load(objectsender,EventArgse){thcodeCodeImagepictureBox}privatevoidbtn_exit_Click(objectsender,EventArgse){thisClose);}privatevoidbtn_enter_Click(objectsender,EventArgse){stringcheckconcheckthistextBoxTextTrim(),this.textBox2.Text.Trim());if(this.textBox1.Text.Trim()==""||this.textBox2.Text.Trim()==""||thistextBox.Text.Trim()==""){thcodeCodeImagepictureBox}elseifcheckuser"){textBoxText="";textBoxFocus();}elseifcheck"password"){}elseiftextBoxTextTrim.ToLower()!=authcode.ww.ToLower()){thcodeCodeImagepictureBox}elseifcheckpast"){thcodeCodeImagepictureBoxmfpower=con.u_sort.Trim();mfShow();thisHide);}elseifcheckerror"){}{}}}}2.客戶入?。簄amespace_2010_HotelManage{publicpartialclassclient_live:Form{authcodemnewauthcode;livepaylivenewlive_pay();publicstringroom_id;publicclient_live(){itializeComponent}privatevoidbtm_exit_Click(objectsender,EventArgse){thisClose);}privatevoidclient_live_Load(objectsender,EventArgse){}ifroom_id!=null){roomidText=room_id.Trim();}thisbookdateText=DateTime.Now.ToString();}privatevoidbtn_clear_Click(objectsender,EventArgse){arall}privatevoidbtn_ok_Click(objectsender,EventArgse){if(this.roomid.Text==""||this.userid.Text==""||thisusernameText==""||this.sex.Text==""||thisNativePlaceText==""||this.bookdate.Text==""){return;}inglivemessageliveliveuseridText.Trim(),roomidTextTrim(),bookdate.Text.Trim(),remarkTextTrim(),usernameText.Trim(),xtTrimNativePlace.Text.Trim()iflivemessage"error"){thisroomidText="";}elseiflivemessage"ok"){arall}publicvoidclear_all(){thisroomidText="";thisuseridText="";thisusernameText="";thissexText="";thisNativePlaceText="";thisbookdateText="";thisremarkText="";}}}結(jié)算namespace_2010_HotelManage{publicpartialclassclient_pay:Form{publicstringpay_userid;publicstringpay_username;publicstringpay_roomnum;publicstringpay_date;livepaylivepaynewlive_pay();authcodemnewauthcode;publicclient_pay(){itializeComponent}privatevoidbtn_exit_Click(objectsender,EventArgse){thisClose);}privatevoidclient_pay_Load(objectsender,EventArgse){ifroomnumTextTrim==""&&username.Text.Trim()==""&&userid.Text.Trim()=={thisroomnumText=pay_roomnum;thisuseridText=pay_userid;thisusernameText=pay_username;}}privatevoidbtn_clear_Click(objectsender,EventArgse){thisroomnumText="";thisuseridText="";thisusernameText="";}privatevoidbtn_find_Click(objectsender,EventArgse){ifroomnumText""&&userid.Text!=""){stringstrlivepayfindroomnumTextTrim,userid.Text.Trim());ifstr"no"){}{username.Text=str;}}essageboxY}privatevoidsum_Click(objectsender,EventArgse){ifuseridText""&&username.Text!=""&&roomnum.Text!=""){mnyText=livepay.sum(roomnum.Text.Trim(),userid.Text.Trim());ctmnyTextmnyText}elsemmessagebox");}}privatevoidbtn_pay_Click(objectsender,EventArgse){ifuseridText""&&username.Text!=""&&factmny.Text!=""){stringoverlivepaypayuseridTextTrim,roomnum.Text.Trim(),ctmnyTextTrimifoverTrim=="ok"){thisroomnumText="";thisuseridText="";thisusernameText="";thismnyText="";thisfactmnyText="";thisdiscountText="";}{}}elsemmessagebox}privatevoiddiscount_TextChanged(objectsender,EventArgse){factmnyTextConvertToInt(mny.Text)*Convert.ToInt32(discount.Text)/}}}namespace_2010_HotelManage{publicpartialclassclient_search:Form{DelchildDelchild=newDel_child();authcodemnewauthcode;clientsearchclientsearchnewclientsearch;publicclient_search(){itializeComponent}privatevoidclient_search_Load(objectsender,EventArgse){gsqlselectRoomIDClientBookInClientIDClientName,Sex,BookInDate,CheckDate,TotalMoney,NativePlace,RemarkfromClientBookInClientwhereClientBookInClientIDClientClientID";lientsearchBindDatasqldataGridView}privatevoidbtn_clear_Click(objectsender,EventArgse){thisusernameText="";thisuseridText="";}privatevoidbtn_find_Click(objectsender,EventArgse){clientsearchfinduseridTextTrimusername.Text.Trim(),dataGridView1);}privatevoidbtn_living_Click(objectsender,EventArgse){gsqlselectRoomIDClientBookInClientIDClientName,Sex,BookInDate,CheckDate,TotalMoney,NativePlace,RemarkfromClientBookIn,ClientwhereClientBookIn.ClientID=Client.ClientIDandCheckDateisnull";clientsearchBindDatasqldataGridView}privatevoidbtn_pay_Click(objectsender,EventArgse){clientpaypaynewclientpay();/stringms=dataGridView1.SelectedRows[0].Cells[5].Value.ToString();ifdataGridViewSelectedRows].Cells[5].Value.ToString()==""){pay.pay_roomnum=dataGridView1.SelectedRows[0].Cells[0].Value.ToString();pay.pay_userid=dataGridView1.SelectedRows[0].Cells[1].Value.ToString();pay.pay_username=dataGridView1.SelectedRows[0].Cells[2].Value.ToString();Del_child.del_child(pay);}{}}privatevoidbtn_exit_Click(objectsender,EventArgse){thisClose);}}}namespace_2010_HotelManage{publicpartialclasshelp:Form{publichelp(){itializeComponent}}}namespace_2010_HotelManage{publicpartialclassroom_edit:Form{roomeditroomedit=newroomedit();publicroom_edit(){itializeComponent}privatevoidroom_edit_Load(objectsender,EventArgse){stringsqlselectRoomIDRoomTypeNameRoomPositionBedNum,PeopleNum,RemarkoomroomeditBindDatasql,dataGridView1);}privatevoidbtn_add_Click(objectsender,EventArgse){roomedit.add(roomnumTextTrim(),roomtypeTextTrim(),roompostionTextTrim(),bednum.Text.Trim(),peoplenum.Text.Trim(),remarkTextTrim()}privatevoidbtn_alter_Click(objectsender,EventArgse){roomeditalter(roomnumTextTrim(),roomtypeTextTrim(),roompostionTextTrim(),bednum.Text.Trim(),peoplenum.Text.Trim(),remarkTextTrim()}privatevoidbtn_del_Click(objectsender,EventArgse){roomeditdelroomnum.Text.Trim());}privatevoidbtn_find_Click(objectsender,EventArgse){roomedit.find(roomnumTextTrim(),roomtypeTextTrim(),roompostionTextTrim(),bednum.Text.Trim(),peoplenum.Text.Trim(),remarkTextTrim(),idView}privatevoidbtn_save_Click(objectsender,EventArgse){roomeditsave);}privatevoidbtn_cancel_Click(objectsender,EventArgse){roomeditcancel();}privatevoidbtn_exit_Click(objectsender,EventArgse){thisClose);}}privatevoiddataGridView1_CellClick(objectsender,DataGridViewCellEventArgse){ifeRowIndex>=0){roomnumText=dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();roomtype.Text=dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();roompostion.Text=dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();bednum.Text=dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();peoplenum.Text=dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString();remark.Text=dataGridView1.Rows[e.RowIndex].Cells[5].Value.ToString();}}}}namespace_2010_HotelManage{publicpartialclassroom_search:Form{DelchildDelchild=newDel_child();roomsearchroomsearch=newroomsearch();publicroom_search(){itializeComponent}privatevoidbtn_exit_Click(objectsender,EventArgse){thisClose);}privatevoidroom_edit_Load(objectsender,EventArgse){stringsqlselectfromRoom;roomsearchBindDatasql,dataGridView1);privatevoidbtn_clear_Click(objectsender,EventArgse){thisroomidText="";thisroomtypeText="";thisroompostionText="";thisbednumText="";thispeoplenumText="";thisfactpeoplenumText="";thisremarkText="";}privatevoidbtn_find_Click(objectsender,EventArgse){roomsearchfindroomidTextTrim(),roomtypeTextTrim(),roompostionTextTrim(),bednum.Text.Trim(),peoplenum.Text.Trim(),tpeoplenumTextTrimremarkTextTrim(),idView}privatevoidbtn_roomempty_Click(objectsender,EventArgse){roomsearchroomemptydataGridView1);}privatevoidbtn_nofull_Click(objectsender,EventArgse){roomsearchnofulldataGridView1);}privatevoidbtn_live_Click(objectsender,EventArgse){clientlivelivenewclientlive();liveroomidthisdataGridView1.SelectedRows[0].Cells[0].Value.ToString();Delchilddelchildlive);}privatevoiddataGridView1_CellClick(objectsender,DataGridViewCellEventArgse){//client_livemessage_sender=newclient_live();/message_sender.room_id=dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();//message_sender.room_type=dataGridViewRowseRowIndexCells1].Value.ToString();/message_sender.Show();}}}namespace_2010_HotelManage{publicpartialclassroom_type_edit:Form{roomtypeeditroomtypeedit=newroomtypeedit();publicroom_type_edit(){itializeComponent}privatevoidroom_type_edit_Load(objectsender,EventArgse){stringsqlselectfromRoomType;roomtypeeditBindDatasql,dataGridView1);}privatevoidbtn_add_Click(objectsender,EventArgse){roomtypeedit.add(roomtypeTextTrim(),eaTextTrimbednum.Text.Trim(),peoplenum.Text.Trim(),price.Text.Trim(),VTextTrimtelTextTrim(),rcTextTrimtoiletTextTrim()}privatevoidbtn_save_Click(objectsender,EventArgse){roomtypeeditsave);}privatevoidbtn_alter_Click(objectsender,EventArgse){roomtypeeditalterroomtypeTextTrim(),eaTextTrimbednum.Text.Trim(),peoplenum.Text.Trim(),price.Text.Trim(),VTextTrimtelTextTrim(),rcTextTrimtoiletTextTrim()}privatevoidbtn_del_Click(objectsender,EventArgse){roomtypeeditdelroomtype.Text.Trim());}privatevoidbtn_find_Click(objectsender,EventArgse){roomtypeedit.find(roomtypeTextTrim(),eaTextTrimbednum.Text.Trim(),peoplenum.Text.Trim(),}}price.Text.Trim(),VTextTrimtelTextTrim(),rcTextTrimtoiletTextTrim(),idView}privatevoidbtn_cancel_Click(objectsender,EventArgse){roomtypeeditcancel);}derEventArgse{thisClose);}privatevoiddataGridView1_CellClick(objectsender,DataGridViewCellEventArgse){ifeRowIndex>=0){//this.dataGridView1.SelectedRows[0].Cells[0].Value.ToString();thisroomtypeText=this.dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();thisareaText=this.dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();thisbednumText=this.dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();this.peoplenum.Text=thisdataGridView.Rows[e.RowIndex].Cells[3].Value.ToString();thispriceText=this.dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString();thisTVText=this.dataGridView1.Rows[e.RowIndex].Cells[5].Value.ToString();thistelText=this.dataGridView1.Rows[e.RowIndex].Cells[6].Value.ToString();thisaircText=this.dataGridView1.Rows[e.RowIndex].Cells[7].Value.ToString();thisto