摘要
本文主要介绍了面向商品批发、零售行业的商品库存管理系统的设计与开发过程，通过实地调研和数据分析，完成了系统需求分析和系统的总体与详细设计，并编码实现。完成入库，出库业务，且允许一张单据涉及多种商品，跟踪仓库中每种商品的库存数量，且可以对其进行盘点，提供过期商品查询，库存数量报警，可以满足多仓库需要，支持联想输入技术。
系统使用的开发工具是Microsoft Visual C++6.0，后台数据库是本地Sql Server 2000通过ADO与前台Visual C++6.0连接。采用基于客户/服务器（Client/Server）的开发模式。本系统提供的功能模块有：基础信息管理模块，其中包括供应商信息管理、客户信息管理、仓库信息管理、商品信息管理、地域信息管理、计量单位管理、上述模块都具备添加、修改、删除、浏览功能，地域信息管理以树形视图形式显示。日常业务管理模块,它包括入库管理、出库管理、调货管理、库存盘点，各模块允许一次对多种商品进行操作，并可自动核算合计数量及合计金额。查询统计管理中包括过期商品查询，实现自动筛选过期商品并删除之，还有库存数量报警，实现商品数量的控制。系统管理模块包括用户信息管理等模块。系统基本可以实现对日常商品的管理。
关键词：商品信息管理系统，C++，Sql Server 2000
ABSTRACT
This paper mainly introduces the goods for the wholesale, retail trade of goods, inventory management system design and development process, through field research and data analysis, completed a system requirements analysis and system overall and detailed design and coding to achieve. Complete Into the warehouse and out of the warehouse, and to allow a document involving some range of goods, tracking warehouse inventory in the number of each type of goods, and inventory can be carried out to provide expired merchandise inquiries, the number of inventory alarm, to meet the needs of multi-warehouse, Support imagine importation of technology. System development tool is Microsoft Visual C + +6.0, the background database is a local Sql Server 2000 through ADO connections with Visual C + +6.0. Based on the Client and Server mode of development. The system function provided by modules are: the basis of information management modules, including providers of information management, customer information management, storage information management, product information management, geographical information management, management of measurement units, the modules have to add, modify, delete, browsing, geographical information management in order to form tree-like view. Day-to-day business management module, which includes storage management, a database management, and transfer cargo management, stock inventory, the module allows a wide range of goods to operate, and automatic accounting of the total number and total amount. Query statistics, including the management of expired goods, information, automatically filter and remove the expired goods, as well as the number of inventory report to the police, to achieve control of the number of goods. System Management Module, including user information management module. System can achieve the basic commodities of day-to-day management.
