摘 要
超市需要处理大量的库存信息，还要时刻更新产品的销售信息，不断添加商品信息。面对不同种类的信息，需要合理的数据库结构来保存数据信息，需要有效的程序结构支持各种数据操作的执行。为了使顾客在超市中能购买到其所需的商品，并且还要既保证商品质量还要享受优质，方便的服务;提高工作人员办事效率,降低其工作量等方面的要求,超市进销存系统的产生是非常有意义的.
本系统前台是面向对象的可视化编程工具vb，后台是 SQL Server 2000数据库。文中介绍了VB和SQL的功能、特点，还着重说明了该系统的特色，例如：在交易过程中，程序的编写尽可能的方便员工进行交易，比如：进货登记时，如果商品编号相同，则自动添加该商品的其它属性；销货登记时，用户只要输入商品编号，该商品的其它属性即可自动出现。退货登记时，只要输入正确的销货编号，其进销存信息也将自动列出，尽量的方便了用户的操作，同时对于登陆的员工编号程序也自动的将其列在进货登记、销货登记中，已防止员工进行非正常的交易。
本文系统的分析了软件开发的背景以过程；首先介绍了软件的方法和主要工具，其次介绍了本软件的详细设计过程：数据库的设计、各个模块的设计和实现，以及具体界面的设计和功能。
关键词：VB，SQL Server 2000，管理信息系统，流程图
Design and Implementation of the supply and marketing System on supermarket
Abstract
The supermarket needs to process the massive stock information, but also wants the time renewal product the sales message, increases the commodity information unceasingly. Facing the different type's information, needs the reasonable database structure to preserve the data message, needs the effective program structure to support each kind of data manipulation the execution. In order to cause the customer the commodity which can purchase in the supermarket its nees, and must already guarantee that the commercial quality also needs to enjoy high quality, facilitates service; Raises the staff working efficiency, reduces aspect and so on its work load requests, the supermarket enters sells saves system's production has the significance.
This system onstage is object-oriented visualization programming tool vb, the backstage is SQL the Server 2000 databases. In the article introduced VB and the SQL function, the characteristic, but also has emphasized this system's characteristic, for example: In the transaction process, procedure compilation convenient staff as far as possible carries on the transaction, for instance: When inventory registration, if the commodity serial number is the same, then increases this commodity automatically other attributes; When sells goods the registration, so long as the user the input commodity serial number, this commodity's other attributes then automatically appear. When returned goods registration, so long as inputs correctly sells goods the serial number, it will enter sells saves the information also automatically to list, the convenience user's operation as far as possible, simultaneously has numbered regarding the debarkation staff the procedure also automatically its row, in the inventory registration, will sell goods in the registration, has prevented the staff to carry on the unusual transaction.
This article system analysis software has developed background by process; first introduced software's method and the main vehicle, next introduced this software detailed design process: Database design, each module design and realization, as well as concrete contact surface design and function.
Key words:VB, SQL Server 2000,Management Information System,Flow chart
目 录
毕业设计（论文）任务书 I
摘 要 II
Abstract III
第1章 绪 论 1
1.1社会背景 1
1.2应用范围 1
第2章 主要工具介绍 2
2.1 Visual Basic 2
2．1．1 VB概念 2
2．1．2 VB特点 2
2.2 SQL Server 2000 2
2．2．1 SQL概念 2
2．2．2 SQL数据库数据体系结构 2
2．2．3 SQL语言的组成 2
第3章 系统规划 4
3.1系统需求分析 4
3.1.1 用户工作流程 4
3.1.2 用户业务需求 4
第4章 系统概要设计 5
4.1 设计思想 5
4.2 业务流程分析 5
4.2.1新系统主要业务分析 6
4.3 系统数据流分析 7
(毕业设计)
4.4 数据字典 10
4.5 运行需求 12
第5章 系统详细设计 13
5.1 功能需求 13
5.2 系统功能结构图 13
5.3 系统功能设计 14
5.4 系统数据库设计 15
5.5 代码设计 18
5.6 输入输出设计 19
5.7连接界面设计 19
第6章 系统实施 21
6.1用户登陆界 21
6.2查询界面 21
6.3添加界面 22
6.4删除界面 23
6.5查询界面 24
第7章 系统测试运行 26
7.1 模块测试 26
7.2 整体测试 26
第8章 总结 28
第9章 参考文献 29
第10章 致谢辞 30