1摘要:随着计算机和信息技术的飞速发展,酒店客房的管理由传统的工作模式逐渐被信息化、网络化的现代工作模式所代替。以住宿为主的酒店假如再延用传统的管理模式,就会增加酒店管理成本和降低工作效率。在酒店客房管理中融入先进的计算机和软件技术,利用酒店客房管理系统进行管理就显得十分有意义。利用酒店客房管理系统进行管理能让管理者及时了解酒店整体情况,便于各种决策,同时也简化了管理的各种复杂操作,提高了酒店的管理效率。本文以茂名星期八商务酒店为例采用VisualBasic和ACCESS相结合,创建一个适合实际情况的酒店客房管理系统。关键词:酒店客房管理系统设计实现Abstract:Withtherapiddevelopmentofcomputerandinformationtechnology,themanagementofhotelroomsbythetraditionalworkingmodehasgraduallyreplacedbymoderninformationtechnology,thenetworkworkmode.Inordertostayatthemainhoteliftheextensionofthetraditionalmanagementmode,willincreasethecostandreducetheefficiencyofhotelmanagement.Withadvancedcomputersandsoftwaretechnologyinthehotelguestroommanagement,itisverymeaningfulandmanagedbythehotelguestroommanagementsystem.Managementcanmakemanagerstounderstandtheoverallsituationofthehotel,hotelroomsmanagementsystem,convenientforvariousdecision-making,butalsosimplifiesthemanagementofavarietyofcomplexoperation,improvethemanagementefficiencyofthehotelmanagement.Inthispaper,MaomingweekeightTradersHotelasanexampleusingVisualBasicandACCESScombination,tocreateasuitablefortheactualsituationofthehotelroommanagementsystem.Keywords:HotelroommanagementsystemDesignRealization目录第一章课题研究背景-------------------------------------------------------------------------------------------3(一)酒店客房管理现状--------------------------------------------------------------------------------3(二)课题研究的意义-----------------------------------------------------------------------------------3第二章需求分析-------------------------------------------------------------------------------------------------3(一)系统目标---------------------------------------------------------------------------------------------3(二)系统需求---------------------------------------------------------------------------------------------3(三)功能需求---------------------------------------------------------------------------------------------4(四)系统的性能需求-----------------------------------------------------------------------------------4(五)开发技术---------------------------------------------------------------------------------------------5第三章系统总体功能-------------------------------------------------------------------------------------------5(一)系统功能结构--------------------------------------------------------------------------------------5(二)系统流程图-----------------------------------------------------------------------------------------6第五章各功能模块代码---------------------------------------------------------------------------------------11(一)酒店客房管理系统Main模块-----------------------------------------------------------------11(二)初始化main_csh模块---------------------------------------------------------------------------16(四)操作员设置main_czysz模块------------------------------------------------------------------17(五)房态查询main_ftcx模块-----------------------------------------------------------------------19(六)挂账结款main_gzjk------------------------------------------------------------------------------20(七)客房查询main_kfcx-----------------------------------------------------------------------------23(八)住宿登记main_kfdj------------------------------------------------------------------------------23(九)客房设置main_kfgl------------------------------------------------------------------------------31(十)密码设置main_mmsz----------------------------------------------------------------------------34(十一)权限设置main_qxsz--------------------------------------------------------------------------36(十二)数据备份main_sjbf---------------------------------------------------------------------------38(十三)数据恢复main_sjhf---------------------------------------------------------------------------38(十四)退宿结账main_tf------------------------------------------------------------------------------39(十五)退宿查询main_tfcx---------------------------------------------------------------------------50(十六)调房登记main_tfdj----------------------------------------------------------------------------51(十七)宿费提醒main_xftx---------------------------------------------------------------------------55(十八)客房销售报表main_xsbb--------------------------------------------------------------------56(十九)客房销售统计main_xstj---------------------------------------------------------------------59(二十)登记预收报表main_ysbb--------------------------------------------------------------------60(二十一)追加押金main_zjyj------------------------------------------------------------------------61(二十二)住宿查询main_zscx-----------------------------------------------------------------------66(二十三)酒店客房管理系统main_Login---------------------------------------------------------67第六章调试与结果---------------------------------------------------------------------------------------------68(一)初始化系统登录调试----------------------------------------------------------------------------68(二)登记模块的功能调试----------------------------------------------------------------------------68(三)退房的功能调试----------------------------------------------------------------------------------69(四)住房查询的功能调试----------------------------------------------------------------------------69参考文献-------------------------------------