进销存管理系统

摘要

在当今市场贸易复杂烦琐的供销系统中，进销存管理是一项非常重要的工作。使用人工方式管理各项材料信息不仅效率低下，而且容易出错，安全性很差。导致了管理费用增加，服务质量难以得到保证，从而影响企业的竞争力。致使现有决大部分的大中型企业都迫切的需求一种效率高，误差小，安全保密的进销存管理系统代替人工管理，从而为企业带来更大效益。

该课题结合商品库存管理的要求，对Visual Basic数据库管理系统、Basic语言的学习和应用，主要完成商品进销存管理系统的需求分析，系统的数据库设计和实现，系统的表单设计，主控程序设计，并由此设计了数据库结构和应用程序。系统运行结果证明，此商品进销存管理系统可以满足管理者完成日常的管理工作，包括材料的进货，销售以及库存材料信息的管理维护等。该课题与其他商品管理系统不同之处在于它简单易学，管理、查询等各方面都可让用户直接明了的应用查询，另外该系统功能齐全，包含了进货、销售、库存管理等全方位的管理体系。该系统的核心部分是数据库的生成，利用Visual Basic完成管理平台设计，构造所用的类库；使用Access数据库存储数据；系统能在网络条件下运行。可实现材料信息管理和出进货记录的快速高校检索，使操作简单安全，提供工作效率和质量。可完成用户基本资料一次性建立，便于规范控制，物料控制半自动化，加强了各个部门之间的联系，提高库存管理的服务水平，最大限度地降低库存量，包括中间库存和在制品的库存，以减少在库存上的资金积压，最大限度的保证订货任务的按期完成，提高计划的可能性，实现均衡生产，集成管理职能，提高管理效率。

该课题能成功的运用到企业中去会为企业带来信息准确、数据安全、节约人力、提高工作效率和质量、提高管理效率、降低错误发生几率等全方位的经济效益。

关键词：管理系统；模块设计；数据库；系统实现

Abstract

Enter to sell to save a management in nowadays the complicated trivial supply and marketing system of the market trade is a count for much work. The method of use the artificial manages various material information not only the efficiency be lowly, and easily come amiss, safety badly. Caused the administrative expense increase, the service quality was hard to get assurance and influence the competition ability of business enterprise thus. Cause the existing definitely greatly part of big and medium-sized business enterprises' all urgent need be a kind of high efficiency, the error margin is small, the safety keep secret of enter to sell to save management system to replace an artificial management, bring a larger performance for the business enterprise thus.

The topic combines the request of management of the merchandise stock and manage system to the database of Visual Basic, Basic language of study and application, main completion merchandise enter sell to save management system of need analysis, the database of the system design and realization, the form and list of the system design, the lord controls program design, and designed database structure from here and applied procedure. The subject circulates a result a certificate, this merchandise enter sell to save management system can satisfy governor to complete a daily management work, include material of enter goods, sale and stock material information of management maintenance etc. That system with other merchandise management the system be different to be placed in brief easy to learn in it, management, search etc. everyone's noodles can let customer directly clear of applied search, another system's function is well-found and included into the goods, sell, stock management all-directions management system etc. The core part of that system is a database of born, make use of the completion management of the Visual Basic terrace a design, construct the type use a database and the saving data of the Access database. The system can circulate under the network condition, carry out management and of the material information enter goods to record of quickly high school index, make operation in brief safe, provide work efficiency and quality, and can complete customer's basic data a time of establishment, easy to norm control, material control half automation, strengthened the contact of the of each section, raise stock a management of service level, with maximum limit decline amount of low inventory, include in the center stock with at