题目：
毕业论文（设计）
企业销售管理系统的设计与实现
Sales Management System
(2011 届)
学生姓名 学 号
院 别 计算机学院 专 业 计算机科学与技术(师范) 指导教师 2011 年 5 月 20 日
中文摘要
销售管理系统是一个企业单位不可缺少的部分,它对于管理者来说都至关重要,一个好的销售管理系统能准确反映企业的进货和销售情况,及时准确地掌握企业运行状态，并动态反映企业进货销售的增减变动，为企业制定销售策略提供基础数据。
本系统是在 Visual Studio平台上运用ASP.NET技术,并连接SQL Server 2005数据库来实现的。针对企业的实际需求，结合管理信息系统开发的概念、结构及系统开发的基本原理和方法，采用Ｂ/Ｓ结构，通过Internet实现对企业进货和销售进行管理，特别是对基本信息、货物采购、销售订单等进行完整的管理而开发出来的。从查询和信息的管理需求出发，针对性强，功能齐备，旨在帮助企业实现销售管理的信息化、网络化，以提高企业运行和管理的效率。
销售管理系统主要包括基本信息、进货管理、销售管理、查询统计、往来管理、系统设置模块等。它通过计算机对企业销售运作的全过程进行全面、有效的管理。有效解决了企业经营过程中，进货和销售信息混乱，查询统计困难等现状，大大减少了管理者的工作量，大大提高了企业的工作效率和经济效益，满足了信息时代企业销售的管理和发展的需求，成为销售企业适应时代发展必不可少的管理工具。
关键词：进货管理，销售管理，库存查询，结账，数据库
I
Abstract
The sales management system is an essential unit of enterprises, which is also very important for managers. A good sales management system could accurately reflect the purchase and sale situation of enterprises, timely and accurate control the running state of enterprises, and reflect the dynamic changes of purchase and sale at the same time, so it could provide the basic data for making further sales plan of enterprises.
This system utilizes the ASP.NET technology in visual in the studio, and connects the SQL 2005 databases to realize. The actual demand for the company, combined with the concept of management information system development, structure and system development of basic principles and methods, using B / S structure, through the Internet to manage the purchase and sale of business, especially building for basic information, goods procurement, sales order. Inquiries and information from the control demand, targeted, fully functional, designed to help companies manage the purchase and sale by networking, to improve the efficiency of enterprise management.
The sales management system mainly includes the basic information, the purchase control, the sales management, the inquiry statistics, the intercourse management, the system establishment module and so on. It sells the operation through the computer to the enterprise the entire process to carry on, the effective management comprehensively. The effective addressing enterprise has managed in the process, the inventory and the sales message are chaotic, present situations and so on inquiry statistics difficulty, reduced superintendent's work load greatly, raised enterprise's working efficiency and the economic efficiency greatly, has satisfied the management which and the development demand the information age enterprise sells, becomes the sales enterprise to adapt the time to develop the essential management tool.
Keywords: Inventory Management，Sales Management，Inventory Enquiry，Checkout，Database
II
目 录
中文摘要........................................................................................................................ I Abstract........................................................................................................................ II 第1章 销售管理系统概述 ....................................................................................... 1
1.1 开发的背景 ..................................................................................................... 1 1.2 系统开发的意义 ............................................................................................. 1 1.3 销售管理的内容 ............................................................................................. 2 1.4 销售管理系统的优势 ..................................................................................... 2 1.5 论文所做的工作 ............................................................................................. 3 1.6 论文结构安排 ................................................................................................. 3 第2章 开发环境和开发工具 ..................................................................................... 4
2.1 ASP.NET........................................................................................................... 4 2.2 SQL Server 2005 .............................................................................................. 5 2.3 C# ..................................................................................................................... 6 2.4 ASP.NET开发和运行平台.............................................................................. 7 第3章 系统分析 ....................................................................................................... 8
3.1 系统必要性分析 ............................................................................................. 8 3.2 系统可行性分析 ............................................................................................. 8
3.2.1 技术可行性 ............................................................................................... 8 3.2.2 经济可行性 ............................................................................................... 8 3.2.3 操作可行性 ............................................................................................... 8
3.3 系统需求分析 ................................................................................................. 9
3.3.1 环境设备需求 ............................................................................................ 9 3.3.2 系统功能需求 ............................................................................................ 9 3.3.3 性能需求 ................................................................................................. 10
3.4 数据需求 ....................................................................................................... 10
3.4.1 数据流图 ................................................................................................. 10 3.4.2 数据库概念结构设计 ............................................................................... 13
第4章 系统总体设计 ............................................................................................. 17
4.1 总体设计论述 ............................................................................................... 17 4.2 系统设计思想 ............................................................................................... 18 4.3 设计目标 ....................................................................................................... 18 4.4 系统的设计结构 ........................................................................................... 18
4.4.1 系统作业结构 .......................................................................................... 18
III
4.2.2 系统架构 ................................................................................................. 19
4.5 系统结构模型 ............................................................................................... 20 4.6 数据库设计 ................................................................................................... 22
4.6.1 数据库概要说明 ...................................................................................... 22 4.6.2 数据库表结构设计 ................................................................................... 22
第5章 系统详细设计 ............................................................................................... 25
5.1 详细设计概述 ............................................................................................... 25 5.2 配置系统Web.config文件........................................................................... 25 5.3 数据库连接组件 ........................................................................................... 26 5.4 用户识别与权限验证组件 ........................................................................... 26 5.5 系统主要模块设计 ....................................................................................... 26
5.5.1 商品信息管理模块 ................................................................................... 26 5.5.2 库存查询模块 .......................................................................................... 27 5.5.3 添加进货信息模块 ................................................................................... 29 5.5.4系统登录模块........................................................................................... 30 5.5.5 销售查询模块 .......................................................................................... 33 5.5.6 商品往来管理模块 ................................................................................... 34 5.5.7 用户管理模块 .......................................................................................... 35
第6章 系统测试 ..................................................................................................... 38
6.1 系统测试的原则 ........................................................................................... 38 6.2测试方法说明 ................................................................................................ 38 6.3 系统测试的用例及结果 ............................................................................... 38 6.4 测试总结 ....................................................................................................... 39 第7章 总结.............................................................................................................. 40
7.1 系统总结 ....................................................................................................... 40 7.2 系统亮点 ....................................................................................................... 40 7.3 系统不足之处 ............................................................................................... 40 7.4 系统展望 ....................................................................................................... 40 参考文献...................................................................................................................... 42 致谢.............................................................................................................................. 43
IV