目次
第一章 总论 ------------------------------------------------1
1.1 Delphi6.0简介----------------------------------------1
第二章 系统设计---------------------------------------------6
2.1 系统功能分析-------------------------------------------6
2.2系统功能模块设计----------------------------------------7
2.3数据流程图----------------------------------------------9
第三章 数据库设计--------------------------------------------13
3.1数据库需求分析-----------------------------------------13
3.2数据库概念结构设计-------------------------------------14
3.3数据库结构实现-----------------------------------------16
第四章 详细设计---------------------------------------------19
4.1登录界面 ----------------------------------------------19
4.2主界面 ------------------------------------------------19
4.3入库子系统---------------------------------------------20
4.4销售子系统---------------------------------------------21
4.5商品信息管理子系统-------------------------------------21
4.6查询子系统---------------------------------------------22
4.7口令更改子系统-----------------------------------------23
4.8员工信息维护子系统…-----------------------------------23
4.9帮助子系统 --------------------------------------------23
第五章 各功能模块的部分源代码------------------------------------------------24
第六章 设计中遇到的问题和解决办法---------------------------33
第七章 自我评价---------------------------------------------34
7.1 系统的特点-------------------------------------------34
结论--------------------------------------------------------35
致谢--------------------------------------------------------37
参考文献----------------------------------------------------38
第二章 系统设计
2．1 系统功能分析
超市销售系统目前国内外做得较多，比较成熟，这个系统是毕业生毕业前的最后一次模拟，对毕业生的软件开发能力有很大帮助。本系统主要由以下几个功能组成：
·商品入库，用于将进来的商品录入到库里。
·商品销售，用于售货员销售商品。
·商品信息管理，现有库存、库存警报、商品报表三部分。
·查询，管理员根据自己的需要进行查询，可按商品代号和商品名称查询。
·口令更改，用于员工更改自己的口令。
·员工信息维护，用于管理员修改员工的信息。
4．5商品信息管理子系统
商品信息管理子系统包括三个小的基本功能，即：
1．现有库存，本功能是统计现在库存中所有的商品的信息，包括商品的代号，商品名，进价，售价，还有库存量等，主要是要库存量，因为后面的库存警报和进货报表都要建立在现在库存量的基础上。同样，点击“打印”按钮便可打印现有商品的库存信息了。
2．库存警报，本功能是根据现有商品的库存量来判断哪种商品的库存量少于最小库存量，这就能提示管理员哪些商品需要进货。一开始打开窗口时，数据窗口内也是显示所有的库存商品信息，通过点击“安存不足”按钮便可查询库存量过少的商品信息了。
3．进货报表，本功能是显示要进货的商品的信息，它是建立在库存警报窗口中的过少的商品的信息上的。点击“打印安存不足”便可打印出进货报表，供进货员去进货。
结 论
为期半个学期的设计生活很快就要过去，回忆这一段时间，我的感触很深，由于是第一次开发一个很实用的管理系统，而且是用一种以前我们不太了解的语言，虽然以前学过，但涉及不多。所以开发起来有一定的难度，我们都感到肩上的压力很大。随着开发的进程，一个个问题都被克服了，这使我深深的体会到了学习的乐趣和运用的艰辛。
首先，这次设计我觉得最大的收获是软件设计概念思想的建立。以前我们做一些小软件的开发或课程设计时，常常是没有明确的思路，就开始编写代码，当遇到问题是才发现是由于刚开始考虑的不够周到所致。通过这次设计我发现，软件设计前工作准备的重要性。
在做开题报告的过程中，我们通过主动的系统调查、系统分析，完成系统的结构设计，数据库规划等工作，这对我们将要开发的系统有了更深的了解，为下一步系统开发做好了准备。这使我们建立了软件设计的正确概念，为今后继续开发系统奠定了基础。
这次我做的课题是《超市销售系统》，我采用Delphi 6.0开发工具来实现。由于以前我对它并不太了解，所以为了更好的开发这项系统，我又重新拿起教材，从最基本的学起。由于有了前面的准备工作，这次我对系统的开发有了明确的思路。可是设计的过程并没有原来想象的那么轻松。有时候要实现一个小的功能，我就要调试好长时间甚至几天。最典型的就是在设计本管理系统的数据库之前没有经过详细的考虑，所以一开始建立的数据库做到后来时就觉得有很多有合适，于是只能重新设计数据库，然后与之相关联的数据窗口也要改变，浪费了很多宝贵的时间。后来指导老师给我们提供了好多宝贵的建议，再加上同学的帮助和我自身的努力下，终于把数据库设计好了。这使我们感受到了程序调试成功后的成就感和无比的喜悦感。
Chapter I General remarks ---------------------------------------------- - 1
About 1.1 Delphi6.0 ---------------------------------------- 1
1.1.1 Professional client / server development tool ---------------------------- 2
1.1.2 Object-oriented programming --------------------------------------- 2
1.1.3 Delphi and Object Pascal ------------------------------- 2
1.1.4 Delphi, and SQL ----------------------------------------- 3
1.1.5 Delphi''s database features and functions of the Introduction ------------------------- 3
1.1.6 Delphi on a variety of database management system ------------------------- 4
1.1.7 Exception handling and debugging ------------------------------------ 5
Chapter II system design --------------------------------------------- 6
2.1 System Functional Analysis ------------------------------------------- 6
2.2 The system features modular design ---------------------------------------- 7
2.3 Data Flow Diagram ---------------------------------------------- 9
Chapter III of the database design -------------------------------------------- 13
3.1 Database Requirements Analysis ----------------------------------------- 13
3.2 Database structure design concept ------------------------------------- 14
3.3 The database structure to achieve ----------------------------------------- 16
Chapter IV detailed design of the --------------------------------------------- 19
4.1 login screen ---------------------------------------------- 19
4.2 The main interface ----------------------------------------------- -19
4.3 storage subsystem --------------------------------------------- 20
4.4 Sale Subsystem --------------------------------------------- 21
4.5 Product Information Management Subsystem ------------------------------------- 21
4.6 Query Subsystem --------------------------------------------- 22
4.7 Password Change Subsystem ----------------------------------------- 23
4.8 Employee Information Maintenance Subsystem ----------------------------------- 23
Help Subsystem 4.9 -------------------------------------------- 23
Chapter V of each functional module part of the source code ---------------------------------------- -------- 24
Chapter VI design problems encountered and solutions --------------------------- 33
Chapter VII of the self-evaluation --------------------------------------------- 34
7.1 The system is characterized by ------------------------------------------- 34
7.1.1 Benefits ---------------------------------------------- --- 34
7.1.2 shortcomings ---------------------------------------------- --- 34
Conclusion ------------------------------------------------- ------- 35
Thanks ------------------------------------------------- ------- 37
References ------------------------------------------------ ---- 38
Chapter II System Design
2.1 System Functional Analysis
Supermarket sales system at home and abroad to do more, more mature, graduates of this system is the last before the simulation, the graduates of software development capabilities of much help. This system is mainly composed by the following features:
* Storage of goods, entry of goods used to come to the library.
* Sale of goods, sales of goods for sales.
* Product information management, the existing stocks, stock alerts, commodity reports of three parts.
* Query, the administrator needs according to their inquiries, according to commodity code and trade name queries.
* Password changes for the staff to change their own password.
* Maintenance of employee information for the administrator to modify the employee information.
4.5 Product Information Management Subsystem
Product information management system consists of three small, basic functions, namely:
1. Existing inventory, this function is all statistics are in storage of goods, including commodity code, commodity name, purchase price, prices, as well as inventory and so on, mainly to inventory levels, since the latter inventory alerts and purchase statements should be established on the basis of present inventory. Similarly, click on "Print" button to print the current product inventory information of the.
2. Stock alerts, this feature is based on existing stocks of goods to determine what kind of inventory of goods less than the minimum inventory levels, which could prompt the administrator which items to purchase. One starts to open the window, the data window also displays all of the stock commodity information by clicking on the "lack of security deposit" button to check stock levels can be too little information on the goods.
3. Purchase reports, this feature is to show the information to purchase goods, which is based on stock alert window too little information on the goods. Click the "Print Security deposit enough" purchase statements can be printed out for purchasing staff to purchase.
Conclusion
The design life of a period of half a semester will soon be past, the memories of this period, my strong feelings, because it was the first time developed a very practical management system, but also with a past, we did not understand the language, although the previously studied, but did not say much. So, being developed with a certain degree of difficulty, we all feel a lot of pressure on the shoulders. As the development process, a lot of questions have been overcome, and this made me feel deeply the joy of learning and use of the hardships.
First of all, this design I think the biggest achievement is the concept of software design ideas was established. Before we do some small software development or curriculum design, it is often no clear idea, they begin to write code, when a problem is found is due to start due to thoughtful enough to consider. I have found through this design, software design the importance of pre-prepared.
Doing the process of opening report, we have a system through active investigation, systems analysis, complete system architecture design, database planning and so on, which we will have to develop a deeper understanding of the system for further system development do a good job preparations. This gives us the right to establish a software design concept for the future laid the foundation for continued development of the system.
This time I did the subject of "supermarket sales system", I use Delphi 6.0 development tools to achieve. As before, I do not quite understand it, so in order to better develop this system, I again pick up the materials, starting from the most basic science. As a result of the previous preparatory work for the development of the system this time I gained a clearer idea. However, the design process and was originally thought to be so relaxed. Sometimes to achieve a small feature, I''ll debug a long time or even days. The most typical is in the design of the database management system has not been fully considered before, so a later start building a database to do that when there are many suitable, so they can only re-design of the database, and then the data associated with the window have changed, wasting a lot of valuable time. Later, the instructor provided us with a lot of valuable suggestions, together with the help of fellow students and my own efforts, finally good database design. This gives us a sense of accomplishment after a successful program debugging, and incomparable sense of joy.
