宾馆管理系统C-数据库课程设计

第一章绪论发展。势。理快速，并能在第一时间得知房间的状态信息。术改变酒店业务模式，实现酒店业务管理的自动化已经成为一种必然。国内的宾馆计算机管理系统于上世纪80年代初起步，到了80年代中后期，国内实际的情况下逐步发展成熟，到90年代初期形成了几个较成熟的软件系统，同时产生了许多专职从事宾馆计算机管理系统的公司。到了90年代中期，随着不断涌现。能发展有如下几大趋势：(1).软件产品集成化(2).操作界面人性化(3).注重客户关系管理(4).从数据处理型向决策型发展(5).系统开放化操作(6).增值产品/服务功能增加操作(7).支持电子商务(8).宾馆集团型管理软件的虚拟竞争空间。和社会信誉必定有着积极的意义。第二章需求分析求分析描述如下入住2.2数据流需求分析：息 息 数据库用户登登录数据库需求分析——数据流图客户类型管理客房管理客户查询客户入住客户结算用户管理系统帮助退出系统客户类型管理客房管理客户查询客户入住客户结算用户管理系统帮助退出系统ameNativePlace第三章概要设计系统功能概述图3.2Client信息E-R图：3.3ClientBookIn信息E-R图InDateeymarkserPasswordserSortInDateeymarkserPasswordserSortmIDkInte3.4管理员用户E-R图serIDUsermark3.5客房信息E-R图markmIDPostionmpleNumeaceNumnepleNumionmarkmIDPostionmpleNumeaceNumnepleNumionTypeNameNumtPeopleNum3.6客房类型信息E-R图TypeName RoomType rCondition第四章数据库的表的建立与实现Client表的建立：ClientBookIn表的建立：Room表的建立：RoomType表的建立：User表的建立：第五章详细设计能建立一个窗口，从公共控件中添加label，button控件到窗口，编辑按钮程序，User理员输入的信息进行验证，判断是否可以通过；调用getNumber()函数随机生成验证码，保证安全性。关于验证码，每次调要比较时再拿出来，注意验证码不分大小写。相关运行截图如下：陆界面5-1-2登录验证陆出错陆成功型管理功能建立一个窗口，从公共控件中添加label，button，textbox，GirdView等控件到窗口，编辑按钮程序，插入图片；GirdView需要配置数据源，对数据库中的对客房类型的的信息进行编辑，包括类型(普通，贫民，豪华)客房面积 (30,60,90)额定床数(1,2,3,4)额定人数(1,2,3,4)价钱(50,500)电视 (有，无)电话(有，无)空调(有，无)卫生间(有，无)这些属性，对客房类型进行增删改查功能操作。wRowCancelingEdit在一个处于编辑模式的行的Cancel按钮被单击，但是在该行退出编辑模式之前发生。RowCommand单击一个按钮时发生。RowCreated创建一行时发生。RowDataBound一个数据行绑定到数据时发生。RowDeleting,RowDeleted行的Delete按钮被单击时发生。它们分别在该网格控件删除该行之前和之后激发。RowEditing当一行的Edit按钮被单击时，是在一行的Update按钮被单击时发生。它们分别在该网格控件更新该行之前和之后激发。SelectedIndexChanging,SelectedIndexChanged这两个事件都是在一行ect它们分别在网格控件处理排序操作之前和之后激发相关运行截图如下：房类型管理界面房类型管理添加功能界面管理功能口，编辑按钮程序，插入图片；GirdView需要配置数据源，对数据库中的内容对客房的的信息进行编辑，包括房间号码 (1,2,3,4)房间楼层(一楼，二楼，三楼)增删改查等功能操作。客房面积(30,60,90)额定人数额定床数这些属性，对客房进行首先来说控件的属性，msitems果(3)SelectioModes:获取或设置在ListBox中选择项所用的方法。一共有四个e择；当属性MultiExtended时，按下Shift键的同时单击鼠标或者同时Shift键和箭头键之一(向上键、向下键、向左键和向右键)，会将选定内容从前一选定项扩展到当前项。按Ctrl键的同时单击鼠标将选择或撤消选择列表中的某项；的某项。绑数据绑定还有一点区别，ASP.NET中绑定数据后还要调用一个DataBind方法，而在c#中就不需要。而DisplayMember获取或设置要显示的属性。截图如下房类型管理添加功能界面户入住功能等控件到窗口，编辑按钮程序，插入图片；GirdView需要配置数据源，对数据库中的内容进行显示输入查询条件，包括的属性有房间号码房间类型房间楼底额定床数额定人数实际人数其他条件，与数据库的数据进行比对，查找该客住，则进行登记，跳转到客户入住界面。记录。将客户的基本信息包括身份账号，姓名，性别，籍贯，以及入住的时间，要添加一个日历的控件是一个传统的单月份日历，用户可以使用该日历查看和选择日期。Calendar控件提供的功能：截图如下客房查询界面客户入住界面客户结算功能等控件到窗口，编辑按钮程序，插入图片；GirdView需要配置数据源，输入身，输入应收金额，确认是否对住户打折，这里面包括VIP等节假日的因素不便多说，已经结账的客户界面账截图如下客户查询界面要结账的用户界面客户结算界面已结算客户界面功能等控件到窗口，编辑按钮程序，插入图片；GirdView需要配置数据源，编辑新使用新用户进行登录截图如下户管理功能界面小结过，去的东西我们根本不知道。同时也发现有很多已经学过的东西我们没有理解到位，种文档一开始话，我，去图分析现有情况及问题，由于忘记了一些C#语言的规范使得在调试过程中一些错习并应用了SQL语言，对数据库的创建、修改、删除方法有了一定的了解，通过导入情不是想象中的那么简单的，它涉及到的各种实体、属性、数据流程、数据处理等等。块和安全性、完整性不觉就会在物理结构设计中添加一些安全设置：主键约束、check键上建立索引，这样可以明显加快检索的速度，最后别忘记重要的安全性设置，么，我会用哪种编译工具，后来选择了MicrosoftVisualStudio,在编写程序时，编写程序一步步实现了，通过这次课程设计使我收获了好多，熟悉了C#的运用，还复习了数据库相关语句的编写。自事，难点在于数据库的连接和编程语言的选择。C#的功能很强大，这也是我以步一步实现其功能！的不足，并希望以后能更加用心地运用所学知识和学习新的知识。[2].施平安清华大学出版社,2005[4]数据库系统概论高等教育出版社2006附录C#语言代码如下：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.客户入住：namespace_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="";}}}结算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