某物资存储管理系统设计与实现

摘    要
随着市场经济的高速发展，物资存储管理越来越重要，如何降低成本，提高工作效率是物资存储管理者需要解决的一个实际问题，本系统从实际出发，在分析目前物资管理中存在的问题基础上，结合管理信息系统开发的概念，结构及系统开发的基本原理和方法开发的。系统是用Delphi7.0作为前台开发工具、用SQL Server 2000作为后台数据库开发的物资存储管理系统，支持多形式客户的数据共享、提高作业效率、监控整个物资进库、出库流程、提供完整的物资出库、入库信息，并且特别关注对各环节业务的监控及例外情况的监控。系统主要完成对物资仓库的库存管理，包括物资入库、出库、库存，员工信息，供应商信息以及密码管理等。系统可以完成对各类信息的浏览、查询、添加、删除、修改等功能。
关键词： 物资  物资入库  物资出库

 
Design and Implementation of A Commodity Storage Management System
Abstract
Along with the market economy high speed development, the commodity storage management is becoming more and more important. How to reduce the cost and enhance the working efficiency is a critical problem which the superintendent needs to solve. This commodity storage management system is developed according to the principle of software system development and is based on analyzing the problems existing in current commodity management systems. This system, which uses Delphi7.0 to develop the forestage application and uses SQL Server 2000 as the backstage database, supports various kinds of customer data sharing to enhance the work efficiency. It monitors the entire commodity flow entering and leaving the storage in order to provide detail information of how and when the commodity leaves or enters the storage to the customers. The system has implemented the basic functions for commodity storage management, including storing and retrieving goods, checking the state of goods and the information of suppliers, as well as the password management and so on.
Key words:  Commodity; In-Stock; Out-Stock

系统功能分析
物资管理系统是一个典型的数据库应用程序，由启动窗体模块、登录模块、系统主界面模块、基础信息模块、物资管理模块、信息查询模块、红字冲销模块、系统管理模块等组成，特规划功能如下：
(1) 物资管理模块主要功能是对物资的入库、出库、入库退货进行管理。
(2) 物资管理模块主要功能是对物资的入库、出库、入库退货进行管理。
(3) 信息查询模块主要功能是对物资入库、物资出库、物资退货、和供应商结款进行高效的查询。
(4) 红字冲销模块主要是对入库票号、出库票号、入库退货票号、和供应商结款票号进行冲销。
(5) 系统管理模块主要功能是系统登录、口令修改和系统退出。