基于 sql server 2003 数据库的单机版酒店业务管理系统
1
酒店管理系统（单机版的实现）
摘要
随着时代的发展工作效率的提高，人们对信息的处理要求，促进了管理
系统（Mis）的发展，其以专门针对性应用，快捷、方便、高效的特点，很快受
到了大众用户的喜爱。
本系统的开发是针对中小型酒店的日常管理业务开发而成的，其针对性
极强，主要体现在对酒店客户消费清单的打印、特色推荐、方便的业务数据的统
计分析、友好的图表数据显示、报表生成、方便的辅助工具使用和多重安全性解
决方案设计，通过以上功能的实现来提供相对比较完善的酒店管理机制的建立。
本系统是采用 sql server 2003 作为后台数据库，vb.net 工具来设计程序，
利用 ado.net 技术来把应用程序与后台数据库相连接。
关键字 : 酒店管理、访问、数据库.
基于 sql server 2003 数据库的单机版酒店业务管理系统
2
Grogshop management program (stand-alone)
Summary
With the times develop and the efficiency creating of works .the
needs of human with the information processing speed the develop of
MIS . Quickly it gets the good payment by common with it’s identity
of special on applying 、 shortcut 、 convenience and high
Efficiency .
The purpose of develop The program is apply to the JR. Grogshop
for manage it’s daily operation .the high pertinency that mainly in
the person of printing the customer’s tab 、recommend particular、
easy stat. the data of operation、friendly picture showing 、report
forms creating 、using assistant tools and designing the multresolvent
and so on .creating the rather perfect system get thread the top of
coming true the functions.
This program’s database is sql server 2003 and using visual
basic.net 2003 to design the programmer and using the ADO.NET
technology to build connection between database and program .
Primary key: Grogshop management、access、database.
基于 sql server 2003 数据库的单机版酒店业务管理系统
3
目录
摘要.........................................................................................................................................3
Summary .................................................................................................................................4
1 绪 论...................................................................................................................................7
1.1 项目背景....................................................................................................................7
1.2 发展状况......................................................................................................................7
1.3 项目开发特色...............................................................................................................8
1.4 工作难度....................................................................................................................8
2 项目分析设计.....................................................................................................................9
2.1 系统架构....................................................................................................................9
2.2 逻辑模型..................................................................................................................10
2.3 功能实现思路及设计结构图..................................................................................10
2.3.1 业务流程分析图：..............................................................................................10
2.3.2 结构设计流程思路规划图：..............................................................................11
2.3.3 概念结构设计图：..............................................................................................12
2.3.4 逻辑结构设计：..................................................................................................13
2.4 权限设计..................................................................................................................18
2.4.1. 管理员权限........................................................................................................18
2.4.2. 录入员权限........................................................................................................18
2.4.3. 部门经理权限....................................................................................................18
3 技术介绍.......................................................................................................................19
3.1 主要开发技术.............................................................................................................19
3.1.1 数据绑定技术.....................................................................................................19
3.1.2 ADO.NET 动态数据库连接技术 ....................................................................19
3.1.3 系统托盘技术.....................................................................................................19
3.1.4 系统 API 函数的使用 ........................................................................................19
3.1.5 结构化数据处理技术.........................................................................................19
基于 sql server 2003 数据库的单机版酒店业务管理系统
4
3.1.6 外部程序的调用.................................................................................................20
3.1.7 外部组件调用.....................................................................................................20
3.2 开发工具及相关技术优点介绍................................................................................21
3.2.1 visual studio.net 开发平台的介绍...................................................................21
3.2.2 使用 visual basic.net 开发的技术优点 ............................................................21
4 项目实现...........................................................................................................................25
4.1 数据库设计结果........................................................................................................25
4.2 应用程序设计..........................................................................................................29
4.2.1 登陆界面设计:....................................................................................................29
4.2.2 用户登陆后的主界面设计.................................................................................30
4.2.2.1 第一部分 菜单项 ................................................................................30
4.2.2.2 第二部分 工具栏 ..............................................................................31
4.2.2.3 第三部分 窗体的主体 ......................................................................31
4.2.2.4 第四部分 窗体的状态栏 ....................................................................32
4.2.3 详细设计思路及涉及相关技术说明.................................................................32
4.2.3.1 客人信息设置窗体 ......................................................................................32
4.2.3.2 房台信息设置窗体 ......................................................................................35
4.2.3.3 酒菜信息设置窗体 ......................................................................................35
4.2.3.4 优惠活动信息设置窗体 ..............................................................................38
4.2.3.5 点菜菜单窗体 ..............................................................................................38
4.2.3.6 房台使用情况查询窗体 ..............................................................................39
4.2.3.7 入住客人信息查询窗体 ..............................................................................39
4.2.3.8 打印窗体 ......................................................................................................40
4.2.3.8 数据统计窗体 ...............................................................................................41
4.2.3.9 工具辅助功能实现 ......................................................................................41
4.2.3.10 帮助的实现 ................................................................................................42
4.3 开发信息系统中遇到的难题以及获取解决的途径................................................42
4.3.1 开发过程遇到的难题.......................................................................................42
4.3.2 最终获取解决的途径.......................................................................................42
基于 sql server 2003 数据库的单机版酒店业务管理系统
5
4.4 项目总结....................................................................................................................43
结束语...................................................................................................................................44
致 谢.....................................................................................................................................45
参考文献...............................................................................................................................46
附 录...................................................................................................................................48
