兰州商学院陇桥学院 本科生毕业论文（设计）
论文（设计）题目：餐厅点餐系统的设计与实现 系 别：信息工程系
专业(方向)及班级：电子商务1101 学 生 姓 名： 指 导 教 师：
2015年 05 月 11 日
陇桥学院本科毕业论文（设计）原创性声明
本人郑重声明：所呈交的论文是本人在导师的指导下独立进行研究所取得的研究成果。除了文中特别加以标注引用的内容外，本论文不包含任何其他个人或集体已经发表或撰写的成果作品。本人完全意识到本声明的法律后果由本人承担。
作者签名：
年 月 日
餐厅点餐系统的设计与实现
摘要
近年来随着人民生活水平的不断提高，餐饮业的消费持续增长，竞争愈来愈激烈。传统餐饮行业的日常运作大部分是靠人工管理的，从客人开台到客人点单再到结账基本上由人工完成记录，这样做不仅耗费人力资源而且容易导致记录丢失或重复等错误，造成管理水平低下。这就迫切需要标准的高效的计算机管理方式引导其发展，通过计算机管理餐厅的日常运作。本系统以SQL Server2005 为后台数据库，以Visual studio 2010为前端开发工具，设计与实现了餐厅点餐系统的前台管理、桌台信息查询、开台信息、点菜、结账、桌台信息、消费查询、数据库备份还原及初始化等功能，以给管理者决策参考的模型，不断完善管理水平，提高工作效率。
[关键词] 点餐系统；管理；Visual studio 2010
ABSTRACT
In recent years, with the continuous improvement of living standards, the consumption growth industry, increasingly fierce competition. The traditional food and beverage industry, daily operation mostly rely on artificial management, from one point to the guests the guests get to the checkout basically done by manual record, do not expend human resources and easily lead to errors such as missing or duplicate records, resulting in low level of management. There is an urgent need for the standard effective computer management mode to guide its development, through the computer management of the daily operation of the restaurant, managers with reference to the model, in order to constantly improve the management level, improve work efficiency. This system uses SQL Server2005 as the background database, using Visual studio 2010 as front-end development tools, realized the front desk management, information query, founding information table, ordering, billing, table information, consumer inquiries and sales statistics, database backup and restore and initial functions.
[Key words] Restaurant meal; Administration; Visual studio 2010
目录
一、绪论 ........................................................................................................................................................ 1 （一）选题的背景和研究意义 ................................................................................................................. 1 （二）国内研究现状及分析..................................................................................................................... 2 二、系统分析 ................................................................................................................................................ 2 （一）功能分析 ........................................................................................................................................ 3
1.管理员对功能的需求 ..................................................................................................................... 3 2.普通用户对功能的需求 ................................................................................................................. 3 3.系统所具有的整体功能 ................................................................................................................. 3 4.性能需求 ........................................................................................................................................ 3 （二）可行性分析 .................................................................................................................................... 4 （三）系统配置要求 ................................................................................................................................ 5 三、系统总体设计 ........................................................................................................................................ 5 （一）系统功能结构设计......................................................................................................................... 5 （二）数据库设计 .................................................................................................................................... 6
1.命名规范 ........................................................................................................................................ 6 2.安全设计 ........................................................................................................................................ 6 3.数据表 ............................................................................................................................................ 7 （三）系统模块设计 ................................................................................................................................ 8 四、系统功能实现 ........................................................................................................................................ 9 （一）登录模块的实现............................................................................................................................. 9 （二）点餐结账模块的实现................................................................................................................... 12 （三）桌台管理模块的实现................................................................................................................... 17 （四）职工信息管理模块的实现 ........................................................................................................... 18 （五）系统管理模块实现....................................................................................................................... 19 五、系统测试 .............................................................................................................................................. 20 （一）测试目的 ...................................................................................................................................... 20 （二）测试方法 ...................................................................................................................................... 20 （三）测试环境 ...................................................................................................................................... 20 （四）测试结果 ...................................................................................................................................... 21 六、结论 ...................................................................................................................................................... 25 参考文献 ...................................................................................................................................................... 26