基于WIFI的自助式点菜系统设计与实现
|
摘要
统计数据表明,我国的餐饮业正处于高速发展时期,与此同时,消费者对餐饮业的服务要求也越来越高,餐饮行业也面临着物价上涨和人力资源成本快速增加的压力。如何提高效率,减少成本,方便顾客就餐是每个餐饮管理人员都应该关心的问题。本文设计了一种客人自助式点菜方式,提供简洁快速的点菜过程,从而减少非必要的服务人员和简化传统的繁杂点菜的过程。如今餐饮并不仅仅是吃的问题,而是一种文化。本系统与被动接受的传统就餐方式不同,客人自助点菜关键在于客人的主动参与,从而提高了客人在就餐过程中的愉悦感。
本客人自助式点菜系统采用C/S架构,通过无线点菜终端、无线厨房终端配合PC服务器,组成一个无线点菜系统,实现点菜自助、菜单传递自动化,最终实现点菜过程变得简单。自助点菜终端完成点菜、加菜、退菜、评论、打分和现场视频观看、数据库更新、客户端设置等功能,厨房客户端主要完成厨师对菜单的获取和烹饪菜品的确认。服务器端主要完成视频的采集、保存、传送和图片的捕捉、菜品信息管理、员工信息的管理、以及账单打印、系统数据库的备份等功能。
本系统客户端硬件采用国内使用最为广泛的mini2440开发板,配备触摸屏,通过无线网络与PC服务器交互。客户端软件采用嵌入式linux操作系统,构建QT图形库开发UI (User Interface),配合使用嵌入式数据库SQLITE保存菜单信息和菜品信息。服务器端使用MYSQL数据库和CapturePro3.0视频捕捉插件完成相应的视频功能。
On the base of the statistics, that catering industry is in a period of rapid development in China. But, consumers require more on the catering industry's service at the same time, and catering industry has to face the press of increasing human resources cost and raw material prices. How to improve efficiency, reduce costs and provide convenience for our customers is the most important thing that restaurant managers should be concerned about. This paper presents a customer self-service system, providing simple and fast order process, then, reducing non-essential staff and simplifying the process of the complicated traditional order process. Today, dinning is not just food, but a culture. The guest self-service process of taking dinner is different from the passive acceptance traditional way--the important one is that the customers' active participation, improving the customers' sense of pleasure.
The guest self-service system uses the C/S architecture, composing by a wireless customer self-help client, kitchen wireless client and PC server, all of them form a wireless order system, in order to provide a self-help and menu delivery automatic order process, making the order process simple and convenient. Self-help client has ordering food, adding dishes, canceling the dishes, giving comments, giving score, and watching live video, database update, client setting function ect. The kitchen client can get the ordered dishes from the PC server and the chef can confirm the cooking dishes. The PC server has the fuction of video capture, storing, transport, and capture frames, food information management, staff information management, and bill printing, database back up etc.
The client communicates with the PC server through wireless network, it mades up of the most widely used development board named mini2440 in China, with a touch screen. The client uses embedded linux Operating System, QT graphics library developing UI, and embedded database SQlite storing menu information and ordered dishes. The PC server uses MySql database saving information and the CapturePro3.0 video capture plug-in to provide video capture and video server.
本客人自助式点菜系统采用C/S架构,通过无线点菜终端、无线厨房终端配合PC服务器,组成一个无线点菜系统,实现点菜自助、菜单传递自动化,最终实现点菜过程变得简单。自助点菜终端完成点菜、加菜、退菜、评论、打分和现场视频观看、数据库更新、客户端设置等功能,厨房客户端主要完成厨师对菜单的获取和烹饪菜品的确认。服务器端主要完成视频的采集、保存、传送和图片的捕捉、菜品信息管理、员工信息的管理、以及账单打印、系统数据库的备份等功能。
本系统客户端硬件采用国内使用最为广泛的mini2440开发板,配备触摸屏,通过无线网络与PC服务器交互。客户端软件采用嵌入式linux操作系统,构建QT图形库开发UI (User Interface),配合使用嵌入式数据库SQLITE保存菜单信息和菜品信息。服务器端使用MYSQL数据库和CapturePro3.0视频捕捉插件完成相应的视频功能。
On the base of the statistics, that catering industry is in a period of rapid development in China. But, consumers require more on the catering industry's service at the same time, and catering industry has to face the press of increasing human resources cost and raw material prices. How to improve efficiency, reduce costs and provide convenience for our customers is the most important thing that restaurant managers should be concerned about. This paper presents a customer self-service system, providing simple and fast order process, then, reducing non-essential staff and simplifying the process of the complicated traditional order process. Today, dinning is not just food, but a culture. The guest self-service process of taking dinner is different from the passive acceptance traditional way--the important one is that the customers' active participation, improving the customers' sense of pleasure.
The guest self-service system uses the C/S architecture, composing by a wireless customer self-help client, kitchen wireless client and PC server, all of them form a wireless order system, in order to provide a self-help and menu delivery automatic order process, making the order process simple and convenient. Self-help client has ordering food, adding dishes, canceling the dishes, giving comments, giving score, and watching live video, database update, client setting function ect. The kitchen client can get the ordered dishes from the PC server and the chef can confirm the cooking dishes. The PC server has the fuction of video capture, storing, transport, and capture frames, food information management, staff information management, and bill printing, database back up etc.
The client communicates with the PC server through wireless network, it mades up of the most widely used development board named mini2440 in China, with a touch screen. The client uses embedded linux Operating System, QT graphics library developing UI, and embedded database SQlite storing menu information and ordered dishes. The PC server uses MySql database saving information and the CapturePro3.0 video capture plug-in to provide video capture and video server.
引文
[1]中华人民共和国国家统计局.2010年国民经济和社会发展统计公报[EB/OL].http://www.stats.gov.cn/tjgb/ndtjgb/qgndtjgb/t20110228_402705692.htm.2011-2
[2]杨柳.中国餐饮产业发展报告[C].社会科学文献出版社,2009-6
[3]杨柳.积极探索餐饮业转型升级之路大力推动城市科学发展[J].《中国商贸》,2010-11
[4]2009年中国餐饮行业利润率再创新低[EB/OL]. http://www.canyincn.cn/show.asp?id =784,2010
[5]yaffs2文件系统[EB/OL]. http://www.yaffs.net/node/38
[6]QT官方网站[EB/OL]. http://qt.nokia.com/,2011
[7]QT/embedded[EB/OL]. http://qt.nokia.com/products/platform/qt-for-embedded-linux/ 2008-2011
[8]Mysql官方网站[EB/OL]. www.mysql.com/,2011
[9]Sqlite官方网站[EB/OL]. http://www.sqlite.org/,2011
[10]广州友善之臂有限公司.MINI2440用户手册[p].2010-6
[11]samgsum corporation. S3C2440A MICROPROCESSOR USER'S MANUAL[Z]. 2004-7
[12]Silicon Storage Technology, Inc.16 Mbit Multi-Purpose Flash Plus SST39VF1601[Z]. 2003-11
[13]samgsum coporation. KF1G08UOB flash memory datasheet[Z].2006-5
[14]davicom semiconductor Inc. DM9000-DS-F03 datasheet[Z].2004-7
[15]802.11g 标准. http://en.wikipedia.org/wiki/IEEE_802.11g-2003[S].2003
[16]韦东山.嵌入式linux应用开发完全手册[M].人民邮电出版社,2009-2
[17]A.Barbalacel, A. Luchetta etc. Performance Comparison of VxWorks, Linux, RTAI and Xenomai in a Hard Real-time Application[J]. IEEE Transactions on Nuclear Science, v 55,2008-2
[18]TROLL TECH. Qt/Embedded Whitepaper[EB/OL]. http://www. trolltech.com/index. html,2006-03
[19]嵌入式数据库定义[EB/OL]. http://en.wikipedia.org/wiki/Embedded_database,2011
[20]杨晓云,王建桥,杨涛译MySQL 5权威指南[M].人民邮电出版社,2006-12
[21]祝定泽,张海,黄健昌.MySQL核心内幕[M].清华大学出版社,2010-1
[22]岳阳,王杰,孙红梅译.MySQL5管理员标准指南及语言参考[M].电子工业出版社,2007-01
[23]李红军,李冬梅.MySQL核心技术手册[M].机械工业出版社,2009-10
[24]MySQL 5.5 Reference Manual [EB/OL]. http://dev.mysql.com/doc/refman/5.5/en /index.html,2011
[25]韩磊,戴飞.Beginning c# objects from concepts to Code中文版[M].电子工业出版社,2007-6
[26]刘烨,季石磊等.c#编程及应用程序开发教程[M].清华大学出版,2006-12
[27]姜玲玲,冯飞译.C＃数据库入门经典[M].清华大学出版社,2008-6
[28]ODBC方式的数据库连接[EB/OL]. http://www.hudong.com/wiki/ODBC
[29]熊伟译PHP&MySQL范例精解[M].清华大学出版社,2009-4
[30]车立红,郭燕等译.Learning php & mysql中文版[M].中国电力出版社,2007-6
[31]祝定泽,张海等.MySQL核心内幕[M].清华大学出版社,2010-1
[32]Pegasus Imaging Corporation. Capturepro3.0[EM/OL]. http://www.pegasusimaging .com
[33]陈艳华.基于ARM的嵌入式系统开发与实例[M].人民邮电出版社,2008-2
[34]吴学智.基于ARM的嵌入式系统设计与开发[M].人民邮电出版社,2007-9
[35]张绮文等.嵌入式常用模块与综合系统设计实例精讲[M].电子工业出版社,2008-12
[36]马洪兵,谷源涛译.嵌入式系统硬件与软件架构[M].人民邮电出版社,2008-2
[37]罗苑棠.嵌入式linux驱动程序和系统开发[M].电子工业出版社,2009-1
[38]张晓林.嵌入式系统技术[M].高等教育出版社,2008-10
[39]冯伟,王博.嵌入式linux案例开发指南[M].中国电力出版社,2008-11
[40]倪继利.Qt及Linux操作系统窗口设计[M].电子工业出版社,2006-4
[41]赵克坤.基于ARM和嵌入式Linux的图形编程[M].清华大学出版社,2009-9
[42]丁林松黄丽琴.Qt4图形设计与嵌入式开发[M].人民邮电出版社,2009-4
[43]李仁见战晓明译.C++设计模式：基于Qt4开源跨平台开发框架[M].清华大学出版社,2007-8
[44]吴迪.零基础学Qt编程[M].北京航空航天大学出版社,2010-7
[45]闫锋欣,曾泉人等译.C++ GUI Qt4编程[M].电子工业出版社,2009-1
[46]成洁,卢紫毅.窗口程序设计：Qt4精彩实例分析[M].清华大学出版社,2008-11
[47]蔡志明,卢传富等.精通Qt4编程[M].电子工业出版社,2008-1
[48]mysql驱动头文件[EB/OL]. http://dev.mysql.com/downloads/
[49]赵延涛,刘冰等.Linux下的mysql数据库编程[M].清华大学出版社,2010-6
[50]陈明.Ubuntu Linux应用技术教程[M].清华大学出版社,2009-4
[51]杨明军译,Ubuntu Linux指南[M].人民邮电出版社,2009-6
[2]杨柳.中国餐饮产业发展报告[C].社会科学文献出版社,2009-6
[3]杨柳.积极探索餐饮业转型升级之路大力推动城市科学发展[J].《中国商贸》,2010-11
[4]2009年中国餐饮行业利润率再创新低[EB/OL]. http://www.canyincn.cn/show.asp?id =784,2010
[5]yaffs2文件系统[EB/OL]. http://www.yaffs.net/node/38
[6]QT官方网站[EB/OL]. http://qt.nokia.com/,2011
[7]QT/embedded[EB/OL]. http://qt.nokia.com/products/platform/qt-for-embedded-linux/ 2008-2011
[8]Mysql官方网站[EB/OL]. www.mysql.com/,2011
[9]Sqlite官方网站[EB/OL]. http://www.sqlite.org/,2011
[10]广州友善之臂有限公司.MINI2440用户手册[p].2010-6
[11]samgsum corporation. S3C2440A MICROPROCESSOR USER'S MANUAL[Z]. 2004-7
[12]Silicon Storage Technology, Inc.16 Mbit Multi-Purpose Flash Plus SST39VF1601[Z]. 2003-11
[13]samgsum coporation. KF1G08UOB flash memory datasheet[Z].2006-5
[14]davicom semiconductor Inc. DM9000-DS-F03 datasheet[Z].2004-7
[15]802.11g 标准. http://en.wikipedia.org/wiki/IEEE_802.11g-2003[S].2003
[16]韦东山.嵌入式linux应用开发完全手册[M].人民邮电出版社,2009-2
[17]A.Barbalacel, A. Luchetta etc. Performance Comparison of VxWorks, Linux, RTAI and Xenomai in a Hard Real-time Application[J]. IEEE Transactions on Nuclear Science, v 55,2008-2
[18]TROLL TECH. Qt/Embedded Whitepaper[EB/OL]. http://www. trolltech.com/index. html,2006-03
[19]嵌入式数据库定义[EB/OL]. http://en.wikipedia.org/wiki/Embedded_database,2011
[20]杨晓云,王建桥,杨涛译MySQL 5权威指南[M].人民邮电出版社,2006-12
[21]祝定泽,张海,黄健昌.MySQL核心内幕[M].清华大学出版社,2010-1
[22]岳阳,王杰,孙红梅译.MySQL5管理员标准指南及语言参考[M].电子工业出版社,2007-01
[23]李红军,李冬梅.MySQL核心技术手册[M].机械工业出版社,2009-10
[24]MySQL 5.5 Reference Manual [EB/OL]. http://dev.mysql.com/doc/refman/5.5/en /index.html,2011
[25]韩磊,戴飞.Beginning c# objects from concepts to Code中文版[M].电子工业出版社,2007-6
[26]刘烨,季石磊等.c#编程及应用程序开发教程[M].清华大学出版,2006-12
[27]姜玲玲,冯飞译.C＃数据库入门经典[M].清华大学出版社,2008-6
[28]ODBC方式的数据库连接[EB/OL]. http://www.hudong.com/wiki/ODBC
[29]熊伟译PHP&MySQL范例精解[M].清华大学出版社,2009-4
[30]车立红,郭燕等译.Learning php & mysql中文版[M].中国电力出版社,2007-6
[31]祝定泽,张海等.MySQL核心内幕[M].清华大学出版社,2010-1
[32]Pegasus Imaging Corporation. Capturepro3.0[EM/OL]. http://www.pegasusimaging .com
[33]陈艳华.基于ARM的嵌入式系统开发与实例[M].人民邮电出版社,2008-2
[34]吴学智.基于ARM的嵌入式系统设计与开发[M].人民邮电出版社,2007-9
[35]张绮文等.嵌入式常用模块与综合系统设计实例精讲[M].电子工业出版社,2008-12
[36]马洪兵,谷源涛译.嵌入式系统硬件与软件架构[M].人民邮电出版社,2008-2
[37]罗苑棠.嵌入式linux驱动程序和系统开发[M].电子工业出版社,2009-1
[38]张晓林.嵌入式系统技术[M].高等教育出版社,2008-10
[39]冯伟,王博.嵌入式linux案例开发指南[M].中国电力出版社,2008-11
[40]倪继利.Qt及Linux操作系统窗口设计[M].电子工业出版社,2006-4
[41]赵克坤.基于ARM和嵌入式Linux的图形编程[M].清华大学出版社,2009-9
[42]丁林松黄丽琴.Qt4图形设计与嵌入式开发[M].人民邮电出版社,2009-4
[43]李仁见战晓明译.C++设计模式：基于Qt4开源跨平台开发框架[M].清华大学出版社,2007-8
[44]吴迪.零基础学Qt编程[M].北京航空航天大学出版社,2010-7
[45]闫锋欣,曾泉人等译.C++ GUI Qt4编程[M].电子工业出版社,2009-1
[46]成洁,卢紫毅.窗口程序设计：Qt4精彩实例分析[M].清华大学出版社,2008-11
[47]蔡志明,卢传富等.精通Qt4编程[M].电子工业出版社,2008-1
[48]mysql驱动头文件[EB/OL]. http://dev.mysql.com/downloads/
[49]赵延涛,刘冰等.Linux下的mysql数据库编程[M].清华大学出版社,2010-6
[50]陈明.Ubuntu Linux应用技术教程[M].清华大学出版社,2009-4
[51]杨明军译,Ubuntu Linux指南[M].人民邮电出版社,2009-6