论 文
库存管理系统的设计与实现
论 文 作 者 姓 名 ：
申 请 学 位 专 业 ：
申 请 学 位 类 别 ：
指导教师姓名（职称）：
论 文 提 交 日 期 ：
库存管理系统的设计与实现
摘 要
库存管理是企业管理的重要组成部分。在企业生产经营活动中，库存管理既
必须保证生产车间对原材料、零部件需求，又直接影响采购、销售部门的购、销
活动。本文主要从系统需求分析、系统结构，功能模块划分，系统设计方面进行
说明。系统基于 B/S 模式，采用 ASP 和 SQL Server2000 数据库系统来实现物品
信息管理，库存警示，信息查询，留言版等功能。本系统完全符合信息管理系统
的要求，并且系统从需求分析、概要设计、详细设计到具体代码实现和后期的功
能测试都严格遵循了软件工程的思想。
关键词：库存管理；数据库；信息管理；B/S 模式；ASP
Abstract
Stock management is an important component of the enterprises management. In
enterprise production and business activities, stock management must ensure the
production workshops demand spare parts of the raw materials, and directly affect the
activities of the purchasing and sales departments. This paper has analyzed the stock
management system basic functions and composition of the system, including
requirements analysis, system structure, function modules, and system design
explanation. The system bases on B/S model and uses ASP and SQL Server 2000
database system to achieve articles information management, stock warning, statistic
and inquiry, message boards and other functions. The system fully complies with the
information management system. And requirements from the system analysis, the
outline design, detailed design, implementation of the functional test, the development
process strictly adhered to the ideas of software engineering.
Key words: Stock Management; Database; Information Management; B/S
Model; ASP
目 录
论文总页数：23 页
1 引言............................................................................................................................................1
2 库存管理系统分析....................................................................................................................1
2.1 系统需求分析....................................................................................................................1
2.2 创建本系统的构思及工作流程图....................................................................................2
2.3 系统的目标与任务............................................................................................................5
2.4 系统运行环境....................................................................................................................6
2.4.1 硬件环境 .....................................................................................................................6
2.4.2 软件环境 .....................................................................................................................6
2.4.3 SQL Server 2000 简介 ................................................................................................6
2.5 管理信息系统的概述........................................................................................................6
2.6 MVC 介绍..........................................................................................................................6
3 库存管理系统总体设计............................................................................................................7
3.1 系统功能分析....................................................................................................................7
3.2 界面设计............................................................................................................................8
3.2.1 系统色彩规划 .............................................................................................................8
3.2.2 系统框架设计 .............................................................................................................9
3.3 系统功能模块设置............................................................................................................7
3.4 数据库的设计与实现........................................................................................................9
3.4.1 数据库的需求分析 .....................................................................................................9
3.4.2 数据库的设计与实现 ...............................................................................................10
4 系统功能的实现及相应代码..................................................................................................12
4.1 用户查询模块以及相应代码..........................................................................................12
4.2 网络管理模块及相应代码..............................................................................................13
4.3 留言版模块及相应代码..................................................................................................14
5 系统测试..................................................................................................................................15
5.1 测试范围..........................................................................................................................15
5.2 测试方法..........................................................................................................................15
5.3 测试结果..........................................................................................................................16
结 论..........................................................................................................................................16
参考文献..........................................................................................................................................17
附 录..........................................................................................................................................18
