摘 要
随着计算机技术的飞速发展，计算机在企业管理中应用的普及，利用计算机实现管理企业势在必行。而仓库管理系统是典型的信息管理系统，其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面。对前者要求建立起数据一致性和完整性强、数据安全性好的库。而对于后者则要求应用程序功能完备，易使用等特点。
本文通过分析浏览器/服务器结构的特点并结合企业仓储管理的实际情况，提出了基于B/S结构中小型企业仓库管理系统的基本设计思想，简要介绍了系统各功能模块及数据库的设计，着重讨论了用 ASP.NET技术和SQL Server 2005开发企业仓库管理系统时的数据库访问技术和动态网页制作技术,并给出了部分实现代码。通过该系统，使学生可以方便地在企业内部网上进行仓储管理。该B/S结构的系统在Windows XP系统和VS.NET平台下开发完成，使用C＃作为ASP.NET的开发语言，SQL Server 2005作为后台数据库，该数据库系统在安全性、准确性、运行速度方面均有绝对的优势，并且能够对容量较大的数据库进行处理，效率高。系统有较高的安全性和较好的性能。其中连接数据库的字符串可以随时在Web.Config里修改，增加了灵活性和安全性。代码尽量减少数据库连接的打开时间等手段来提高性能。
本文中除了有对程序的系统分析、总体设计、数据库设计、功能实现等主体部分外，在这之前还介绍了与企业仓库管理系统相关的信息、VS.NET与SQL的无缝链接技术等。
关键词 仓库管理；信息管理系统；B/S结构；数据库管理
I
Abstract
With rapid advancement of computer technology and widely applied in corporation management, it is imperative to utilize it to realize Enterprise administration. Warehouse Management System is one of typical Management Information System, whose exploitations mainly include establishment and maintenance of backstage database as well as front application programmer. For the former, it is required to set up united, complete and high-secured database, while, for the latter, complete functions of application programmer and simple operation.
This thesis points out basic theory of Warehouse Management System based on explorer and server/organization in small-to-medium-sized enterprises, analyzing characteristics of B/S and relating to realities of situation of Warehouse Management System. It introduces design of every functional group and database briefly and focuses on discussion concerning to exploit database access technology and dynamic web design needed for Warehouse Management System in light of ASP. NET technology and SQL Server 2005. It also presents parts of implementation codes, helping students to operate Warehouse Management in corporation local site. This B/S system was exploited on the platform of Windows XP and VS. NET, using C# as ASP. NET exploitation language, SQL Server 2005 as backstage database, which possesses advantages in security, precision, speed, etc. and can deal with databases with high capacity efficiently. The character connecting databases can be altered anytime, which raises flexibility and security, codes reducing the time to open database connection.
In this dissertation, besides system analysis, overall design, database design, functional realities, etc, information related to Warehouse Management System, seamless connection technology of VS. NET and SQL are also introduced.
Key words Warehouse Management Management Information System B/S
Structure Database Management
II
目 录
目录
摘 要 ......................................................... I Abstract ........................................................ II 第1章 绪论 .................................................. 1 1.1 课题背景 ....................................................................................................... 1 1.2 课题目的和意义 ........................................................................................... 1 1.3 开发设计思想 ............................................................................................... 2 1.4 主要工作和论文结构 ................................................................................... 2 第2章 系统开发工具与开发平台 ................................ 3 2.1 开发平台和技术介绍 .................................................................................... 3 2.1.1 IIS简介 ................................................................................................... 3 2.1.4 ASP.NET开发环境 ............................................................................. 4 2.2 C#编程语言 ................................................................................................... 4 2.3 SQL Server 2005数据库 ................................................................................ 5 2.4 系统运行环境 ................................................................................................ 7 第3章 系统需求分析 .......................................... 8 3.1 可行性分析 ................................................................................................... 8 3.1.1 可行性研究 ............................................................................................ 8 3.1.2 可行性分析 ............................................................................................ 8 3.1.3 系统业务流程分析 .............................................................................. 10 3.1.4 系统数据流分析 .................................................................................. 11 3.1.5 数据字典分析 ...................................................................................... 12 3.2 本章小结 ..................................................................................................... 14 第4章 系统总体设计 ......................................... 15 4.1 系统模块总体设计 ..................................................................................... 15 4.2 数据库结构设计 ......................................................................................... 15
III