目 录
摘 要 I
第一章 绪论 1
1.1 选题的背景和意义 1
1.2 研究内容 1
1.2.1 服务端 1
1.2.2 客户端 1
1.3 系统开发技术 2
1.3.1 VB.NET 2
1.3.2 Access 2003数据库 2
第二章 系统设计 3
2.1 系统需求分析 3
2.1.1 系统需求分析 3
2.1.2 传统网吧管理 3
2.1.3 系统优点 3
2.1.4 功能需求 3
2.2 系统的设计原则 3
2.3 系统设计的思想 4
2.4 系统功能描述 4
2.4.1 操作员管理功能模块 5
2.4.2 用户管理功能模块 6
2.4.3 计算机管理功能模块 7
2.5 系统设计的类结构 8
第三章 数据库设计 10
3.1 数据库的需求分析 10
第四章 通信过程与VB.NET中的通信类 14
4.1 通信过程 14
4.2 VB.NET 中的通信类 15
4.2.1 TcpListener类 16
4.2.2 TcpClient类 16
4.2.3 NetworkStream类 17
4.2.4 StreamReader类 17
4.2.5 StreamWriter类 18
第五章 系统的实现 19
5.1 公共模块 19
5.2 服务器端的实现 19
5.2.1 服务器端登录 19
5.2.2 添加操作员 21
5.2.3 编辑操作员 23
5.2.4 删除操作员 24
5.2.5 修改密码 25
5.2.6 设置上机费率 26
5.2.7 锁定屏幕 27
5.2.8 用户充值 28
5.2.9 查询费用 29
5.2.10 添加用户信息 30
5.2.11 修改用户信息、删除用户信息 31
5.2.12 添加计算机信息 33
5.2.13 修改/删除计算机信息 33
5.3 客户端登录 35
5.3.1 登录 35
5.3.2 下机 36
5.3.3 设置 37
5.3.4 退出 37
第六章：总结 38
6.1 网吧计费系统的开发技术特点 38
6.2 系统的不足与前景 38
参考文献 39
致 谢 40
机 房 计 费 系 统 软 件
摘 要
本课题研究的网吧计费系统是一款基于C/S结构，采用Access 2003 数据库，利用Visual Basic.net设计开发的网吧计费系统。文中主要介绍了系统的基本功能和系统结构组成情况，内容包括系统需求分析、系统设计原则、系统设计思想、系统功能模块描述、数据库设计、系统通信过程、通信协议等，同时还对开发环境Visual Basic.net、Access 2003数据库、Visual Basic.net技术的使用进行简单介绍，并列出了一些程序代码以说明该系统应用程序设计的实现过程。
关键字 C/S 结构 Access 2003 Visual Basic.net 通信协议
ACCOUNTING SYSTEM SOFTWARE ON COMPUTER LAB
Abstract
This thesis focus the study on computer lab accounting system which is based on C/S structure, designed and developed by Access 2003 databases and Visual Basic.net. In the article, author mainly analyzes some basic functions and composition of this system, which including system demanding analysis, system design principle, system design idea, description of functional module, Database design, processes of system communication and agreements of communication. In addition, this thesis introduces briefly on use of Visual Basic.net, Access 2003 database, and Visual Basic.Net, meanwhile, lists some programming codes to explain the realization process of this system applying the programs.
Key words C/S structure, Access 2003, Visual Basic.net, communication agreement
第一章 绪论
1.1 选题的背景和意义
随着计算机技术的日月更新，越来越多的人们注重加强对计算机知识的学习，为了满足学校学生或者社会学员的需求，许多网吧都纷纷对外开放，实行计时收费。但随着上机人数的增多，网吧的管理成了一个非常困难的问题。首先，人工计时收费是非常繁琐的一项工作，耗费人力物力，而且极容易出错；最后的统计工作更是一项费时费力的苦差事，甚至不能统计。其次，上机过程中，每个网吧都需要值班人员值班，耗费了管理人员的很多时间。随着计算机各种外围设备技术的发展，以上工作通过计算机就可以很方便地实现。
为了适应当前网吧管理无人化的需求，本人试图利用自己大学所学专业知识并结合教学管理中的实际情况和其它类似计费软件的优点，开发了一套网吧收费系统软件。本系统可以解决网吧管理中存在的几个实际问题：
(1). 减少值班人员、维护人员，降低管理人员费用，甚至可以做到网吧无需人员值 守管理。
(2). 增加网吧的开放时间，提高设备的利用率。
(3). 解决目前网吧管理中的人情免费上机、脱逃费问题。
1.2 研究内容
利用VB.NET、Access2003 等开发工具开发一套基于c/s框架结构的网吧计费系统软件, 该系统要求由服务端、客户端2个模块组成。各模块主要实现以下功能：
1.2.1 服务端
(1). 操作员管理
主要包括：操作用户管理、操作员登录、修改密码、设置上机费用 。这其中大部分是标准数据的维护，包括新增、修改、删除、查询等；
(2). 用户信息管理
主要包括：用户充值、查询用户费用、删除用户信息、添加用户信息、修改用户信息。这里区分不同的用户类型，按照不同用户类型设置上机费用等；
(3). 计算机信息管理
主要包括团体添加计算机信息、修改计算机信息、删除计算机信息3个模块。这里要记录计算机本身的配置信息以及使用情况。
(4). 上机计费
主要负责接收客户端程序发送来的上、下机信息，进行上、下机的处理，在处理上机登录时要进行用户的合法性检测。检测通过后产生一条用户上机记录，记录下计算机代码、卡号、登录开始时间等信息。处理下机信息时，要记录下此用户下机的详细时间。
计费时要将当前使用费用记录在上机记录中，并在用户的档案记录的余额字段中扣减，还要判断用户的余额情况，如果余额不足，要及时发送一个网络消息给用户。
1.2.2 客户端
首先要求将客户端的桌面、任务管理器、系统状态栏等系统功能锁定，桌面上只有客户登录程序界面，要求用户输入用户代码和密码进行登录。登录信息要求以网络数据包的形式发送到“服务器端”，由“服务器端”来判断其合法性，并反馈一个信息给客户端，如果一切合法的话，再将桌面、任务管理器等功能解锁，让用户正常使用。客户端程序要求正常停靠在系统托盘中，用户下机时要求点击此图标进行下机，客户端将下机信息发送到“服务器端”，然后重新弹出登录界面，等待下一个用户登录。
..
第六章：总结
本文体现了一个系统的编程规范，文章内容涵盖了系统的需求、数据库的需求分析、系统设计、界面设计与及系统的最终实现。
6.1 网吧计费系统的开发技术特点
整个网吧计费系统的开发有以下几个特点
1. 属于典型的三层系统代码结构；
2. 基于C/S（客户端/服务器）的通信结构；
3. 服务器端与客户端进行简单的通信协议；
4. 网路通信技术与数据库存技术综合开发。
6.2 系统的不足与前景
本系统虽是C/S型网络结构，但因为数据库Access只能承受少量客户端，系统的访问量相对比较小，只能局限于网吧、图书馆等局域网中，这应有相应的解决方案，使其不断得到改进。在开发过程中，切身体会了利用VB.NET结合Socket对象模型开发数据库系统的高效和快捷，因此对将本系成功能更新更高效、通用性更强有了新的期待。
参考文献
周绪，管丽娜, 白海波 编著.SQL Server 2000 中文版[M]. 北京：清华大学出版社，2001.5
杭国英 主编. Visual Basic 程序设计[M]. 北京：北京机械工业出版社，2003.8
岂兴明,矫津毅, 银华强编著.Visual Basic.NET 项目开发宝典[M].北京：电子工业出版社，2007.1
陈语林 编著.Visual Basic.NET程序设计教程[M].北京:中国水利水电出版社,2005.9
郝佳波等主编. Visual Basic.NET实用教程[M].陕西：西安电子科技大学出版社，2006.1
潘英，陈君等译.Visual Basic.NET专业项目实例开发[M].北京：中国水利水电出版社，2003.1
王栋 主编 . Visual Basic 课程设计 [M]. 北京:清华大学出版社，2004.4
萨师煊 王珊 编著. 数据库系统概论 [M]. 北京：高等教育出版社，2002.2
王千祥 等译 .实用软件体系结构 [M] .北京:电子工业出版社 ，2004.9
史济民，顾春华，李昌武 苑荣 编著 .软件工程 原理、方法与应用 [M]. 北京：高等教育出版社，2002.12
致 谢
本课题在选题及研究过程中得到老师的悉心指导。每个星期都与我学术交流，并为我指点迷津，在我开拓研究思路。他一丝不苟的治学作风，严谨探究的态度，不仅教会我在学习上如何探讨研究，还让我明白了做人处世的诚诚恳恳。在此我对老师表示衷心感谢。同时也感谢班主任，谢谢她几年来对我学习、生活上的照顾。
Directory
Summary I
Chapter 1 Introduction
1.1 Background and significance of topics of a
1.2 Research on the content of a
1.2.1 server-side 1
1.2.2 Client 1
1.3 System Development Technology 2
1.3.1 VB.NET 2
1.3.2 Access 2003 database, 2
Chapter 3 System Design
2.1 System Requirements Analysis 3
2.1.1 System Requirements Analysis 3
2.1.2 Traditional cafes Management 3
2.1.3 System Benefits 3
2.1.4 Functional Requirement 3
2.2 System Design Principles 3
2.3 System Design thinking 4
2.4 System Functional Description 4
2.4.1 Operator management function module 5
2.4.2 User Management function module 6
2.4.3 computer management function module 7
2.5 System Design class structure 8
Chapter III Database Design 10
3.1 Database Requirements Analysis 10
The fourth chapter in the communication process and communication VB.NET class 14
4.1 The communication process 14
4.2 VB.NET in the communications class 15
4.2.1 TcpListener Class 16
4.2.2 TcpClient Class 16
4.2.3 NetworkStream Class 17
4.2.4 StreamReader Class 17
4.2.5 StreamWriter Class 18
Chapter V System 19
5.1 Public Module 19
5.2 server-side implementation of 19
5.2.1 server-side log 19
5.2.2 Adding Operators 21
5.2.3 Editing Operator 23
5.2.4 Remove Operator 24
5.2.5 Change Password 25
5.2.6 Set-on rates for 26
5.2.7 Locking the screen 27
5.2.8 User Result 28
5.2.9 inquiry fee 29
5.2.10 Add the user information 30
5.2.11 modify user information, delete the user information 31
5.2.12 Add Computer Information 33
5.2.13 Modify / Delete Computer Information 33
5.3 The client logs 35
5.3.1 Log 35
5.3.2 the plane 36
5.3.3 Set 37
5.3.4 Exit 37
Chapter VI: Summary 38
Internet Cafe Billing System 6.1 technical features of 38
6.2 System deficiencies and prospects 38
References 39
Thanks 40
Room billing system software
Abstract
Internet cafes in this research project is a billing system based on C / S structure, using Access 2003 database using Visual Basic.net design and development of the Internet cafe billing system. This paper introduces the basic functions of the system composition and system architecture, including system requirements analysis, system design principles, system design ideas, the system function modules description, database design, system communication process, communication protocols and so on, but also to the development environment, Visual Basic.net, Access 2003 database, Visual Basic.net the use of technology for a brief introduction, and lists some of the program code to illustrate the application of the system design of the implementation process.
Keywords C / S structure, Access 2003 Visual Basic.net communication protocol
ACCOUNTING SYSTEM SOFTWARE ON COMPUTER LAB
Abstract
This thesis focus the study on computer lab accounting system which is based on C / S structure, designed and developed by Access 2003 databases and Visual Basic.net. In the article, author mainly analyzes some basic functions and composition of this system, which including system demanding analysis, system design principle, system design idea, description of functional module, Database design, processes of system communication and agreements of communication. In addition, this thesis introduces briefly on use of Visual Basic.net, Access 2003 database, and Visual Basic.Net, meanwhile, lists some programming codes to explain the realization process of this system applying the programs.
Key words C / S structure, Access 2003, Visual Basic.net, communication agreement
Chapter I Introduction
1.1 Background and significance of topics of
With the sun and the moon update computer technology, more and more people are focused on strengthening the learning of computer knowledge, in order to meet the schools or social needs of students, many Internet cafes have opened and implement time-fee. But as the number on the machine increases, the management of Internet cafes has become a very difficult problem. First, the artificial time a charge is a very tedious work, consuming human and material resources, but also highly error-prone; the final statistical work is a laborious and time-consuming drudgery, not even statistics. Secondly, the machine process, each Internet cafe needs to shift staff on duty, spent a lot of time management staff. With a variety of computer peripherals and technological development, more than one job through the computer can be easily achieved.
In order to meet the current demand for Internet cafe management of unmanned, I tried to use their university studies combined with professional knowledge of the actual situation of teaching management and other similar billing software, the advantages to develop a set of Internet cafes charging system software. This system can solve the existing Internet cafe management of several practical problems:
(1). To reduce duty personnel, maintenance personnel, reduce management costs, and even Internet cafes can be done without staff on duty management.
(2). Increase the cafe''s opening hours, improve equipment utilization.
(3). To resolve the current Internet cafe management in favor for free on the machine, escape charges.
1.2 The study
The use of VB.NET, Access2003 and other development tools to develop a based on c / s frame structure of the Internet cafe billing system software, the system required by the service side, the client 2 module. The modules to achieve the following key features:
1.2.1 server
(1). Operator Management
Mainly include: operation of user administration, operator login, change password, set-on fees. Most of this is the standard of data maintenance, including new, modify, delete, query, etc.;
(2). User Information Management
Mainly include: user refill, check user fees, delete user information, add the user information, modify user information. Here to distinguish between different user types, according to different type of user settings on the machine, etc.;
(3). Computer Information Management
Include groups of computer information to add, modify the computer information, delete the three modules of computer information. Here we must record the configuration of the computer itself, information and usage.
(4).-On billing
Mainly responsible for receiving client to send to the upper and lower machine information, to the upper and lower machine processing, in dealing with log-on to the user when the legality of testing. Detection by the user on the machine generated from a record, record the computer code, card number, login information such as start time. To the next machine information, to record the details of the plane this time of the user.
When charging user fees to the current recorded in the aircraft records, and records the balance of the user''s field of deduction, but also to determine the user''s balance, and if insufficient balance, we must promptly send a network message to the user.
1.2.2 Client
First asked the client''s desktop, task manager, system status bar lock system functions such as the desktop client log-in procedure only interface, requires the user to enter a user code and password. Login information requirements in the form of network packets sent to the "server side", from "server-side" to determine its legitimacy, and an information feedback to the client, if everything illegal, then Desktop, Task Manager and other functions Xie lock, allowing users to normal use. Client-side procedures require a normal stop in the system tray, the user requests the next machine Click the icon to the next machine, the client send information to the next machine "server side", and then re-login screen pops up, waiting for the next user.
.. .. .. ..
Chapter VI: Summary
This reflects a system programming specifications, the article covers the system requirements, database requirements analysis, system design, interface and system design and the ultimate realization.
Internet Cafe Billing System 6.1 Technical Features
Internet cafe billing system development as a whole has the following characteristics
1. Is a typical three-tier system code structure;
2. Based on C / S (client / server) communication structure;
3. Server-side and client a simple communication protocol;
4. Internet communications technology and data inventory Technology Development.
6.2 System deficiencies and prospects
Although this system is C / S-type network structure, but because the database can only afford a small amount of Access client, the system of visits is relatively small, only limited to Internet cafes, libraries and other local area network, this should be the appropriate solution, it has steadily improved. In the development process, the personal experience of using VB.NET with Socket object model database system developed efficient and fast, so it will be able to update the success of this department more efficient and more versatile with the new expectations.
References
ZHOU Xu, Guan Lina, Hai-Bo Bai compiled. SQL Server 2000 English Version [M]. Beijing: Tsinghua University Press, 2001.5
Hang Guo-Ying editor. Visual Basic program design [M]. Beijing: Beijing Machinery Industry Press, 2003.8
Qi Xing Ming, Jiao Jin-yi, silver Huaqiang ed. Visual Basic.NET Project Development Collection [M]. Beijing: Electronic Industry Press, 2007.1
Chen Yu Lin eds. Visual Basic.NET Programming Tutorial [M]. Beijing: China Water Conservancy and Hydropower Press, 2005.9
Jia Hao wave and editor in chief. Visual Basic.NET and practical tutorial [M]. Shaanxi: Xi''an University of Electronic Science and Technology Press, 2006.1
PAN Ying, Chen et al Trans. Visual Basic.NET examples of professional project development [M]. Beijing: China Water Conservancy and Hydropower Press, 2003.1
Wang Dong editor. Visual Basic Course Design [M]. Beijing: Tsinghua University Press, 2004.4
Shi-Xuan Wang Shan Sa compiled. Introduction to Database System [M]. Beijing: Higher Education Press, 2002.2
Wang Qianxiang so translated. Utility software architecture [M]. Beijing: Electronic Industry Press, 2004.9
Shi Ji-min, Chun-Hua Gu, Yuan-Rong Li Changwu compiled. Software engineering principles, methods and applications [M]. Beijing: Higher Education Press, 2002.12
Thanks
And research topics of this subject in the process to get the teacher''s careful guidance. Each week academic exchange with me, and I Zhidianmijin, in my research ideas to develop. His style of meticulous scholarship, rigorous exploration of attitude not only taught me in learning how to explore and study, so I see a man themselves in society sincerely. Here, I express my sincere gratitude to teachers. At the same time also like to thank the class teacher to thank her for the past few years to my study and life care.
