摘要:设计仓库管理系统的目的是实现企业物品管理的系统化、规范化和自动化,从而提高企业管理的效率。它取代了之前只用人工管理仓库的工作方式,避免了由于管理人员的工作疏忽以及管理质量问题所造成的各种失误而造成的损失,为准确、高效地完成仓库的管理工作提供了强有力的工具和手段。仓库管理系统是一个中小型数据库管理系统,它界面友好、操作简单,基本满足仓库管理的要求。整个系统由物品信息管理、订单管理、采购单管理、库存管理、人员管理等模块组成。本系统是是以Microsoft SQL Server 2005作为后台数据库,以Visual C#为编程语言来开发的。仓库管理系统在运行阶段,效果不错,数据准确性高,提高了工作效率,同时也实现了仓库管理的计算机化。20844
关键词:仓库管理;信息系统;仓库;SQL Server数据库;
Development of Company Management System-Warehouse System
Abstract: The purpose of designing a warehouse management system is to realize the systematization, the automation, and the standardization of the items management, so that we can raise the efficiency of the company management. It takes place of the way of work that only use artificial management, and avoid the loss because of the mistake made by the employees. It also provide a powerful tool and method to finish the work of warehouse management more precisely and efficiently. Warehouse management system is a system base on a medium database. It has a friendly interface, and it’s easy to be used. The System can basically to meet the requirements of the warehouse management. The whole system is made of items information management, orders management, purchase orders management, stock management, personnel management and so on. This system is based on Microsoft SQL Server 2005 as the background database, using Visual C# as programming language. The system is in the operational phase, the effect is good, high data accuracy, improve work efficiency, but also realize the warehouse management computerized.
Keywords: warehouse management; information system; warehouse; SQL Server database;
目录
摘要 ii
Abstract ii
目录 iii
1 绪论 1
1.1 仓库管理系统开发背景 1
1.2 开发目的和意义 1
1.3 国内外发展现状 2
2 系统需求分析 4
2.1 系统目标 4
2.2 系统功能模块描述 4
2.3 系统功能模块图 4
2.4 用例模型 5
3 数据库设计 6
3.1 系统数据流图 6
3.2 概念模型设计 6
3.3 逻辑结构设计 7
3.4 存储过程的建立 10
4 系统详细设计 14
4.1 主界面与登录模块: 14
4.2 仓库管理模块 16
4.3 物品管理模块 19
4.4 订单模块 23
4.5 采购单模块 27
5 系统测试 31
5.1 物品模块 31
5.2 仓库管理模块 32
5.3 订单模块 34
5.4 采购单模块 35