1
计算机科学与技术专业(本科)
毕业设计
论文题目 超市进销存信息管理系统
所在班级 ____________
姓 名 ________
学 号 __________
指导教师 _______
完成日期 __________________
2
摘 要
随着科学技术的进步，计算机行业的迅速发展，大大提高人们的工作效率。
计算机信息处理系统的引进已彻底改变了许多公司的经营管理 。甚至附近的
一个小店主也可能正在用计算机来控制销售、记账以及其他活动。在一些大公司
里，电子信息处理系统监测全部工作设备的操作与运行。
销售管理系统是企业管理机制中的重要组成部分，通过对超市销售管理系统
的销售管理机制进行调查研究，开发了超市销售管理系统。本系统中解决了超市
管理事务中的进货、销售、退货等情况的问题以及相关统计工作。本系统中包含
六个功能模块：商品信息管理,员工管理，进货管理,销售管理,库存管理和系统设
置。
本系统使有 Microsoft 公司推出的 ASP.net 进行前端开发，它采用了当今软
件设计的最新技术，具有开发效率高、设计灵活、生成的软件界面友好美观等特
点。本系统中通过 ADO.net 和数据库进行无缝连接，后端的开发工具是 Microsoft
Sqlserver 2000，整个数据库都是相互关联的，使数据库具有较高的完整性，一
致性和安全性。
关键词：销售管理，交易管理，数据库管理系统，asp.net。
3
Abstract
With the progress of science and technology,the rapid development of the
computer industry, improve people's working efficiency greatly.
The introduction of computerized information systems has sharply changed
management control in many companies. Even a neighborhood shopkeeper may now
use computers to control sales, billing, and other activitise . In large companies,
electronic data processing systems monitro entire projects and sets of operations.
The management of Sales is the important part of the administration of a
supermarket. Investigations through the mechanism of management to the
supermarket sell management system. This system contains seven modules, namely
goods enter management, employee information management,this management of buy
info from supplier ,sell management, stock management, and system set.
This system use Microsoft carry on front develop, ASP.net. It adopt new
technologies most who software design nowadays, it has to be high to develop
efficency, designflexible, beautiful friendship interface software that produce,
etc.characteristic.At the ADO .net of ASP.net and data base go on and have and sew
and ioin shis system, use to accuse of one and touch off the incident Asp.net at a
large amount of .The developing instrument of the back end is Sqlserver 2000 of
Microsoft , the whole data base is related each other, makes the data base have
relatively high integrality , Consistency and security.
Key words: the management of Sales, the management of trade , DBMS, Asp.net.
4
目 录
前言 .....................................................................................................................................................1
第一章 系统概述 ...............................................................................................................................2
1.1 国内外研究现状及发展趋势
[5]
.........................................................................................2
1.2 研究目的、意义和范围 .....................................................................................................2
1.3 系统技术概述 .....................................................................................................................3
1.3.1 .NET Framework 概述
[9][11]
........................................................................................3
1.3.2 ASP.NET、ADO.NET 和 C#语言简介
[5][13]
.............................................................4
第二章 系统需求分析 .......................................................................................................................6
2.1 需求分析的目的 ..................................................................................................................6
2.2 项目背景 ..............................................................................................................................6
2.3 需求分析 ..............................................................................................................................6
2.3.1 问题定义 ...................................................................................................................6
2.3.2 可行性研究 ...............................................................................................................6
2.3.3 销售管理系统具体任务要求和运行过程 ...............................................................7
2.4 对现有系统的分析 ..............................................................................................................7
2.5 技术方面可行性分析 ..........................................................................................................8
2.5.1 软件分析 ...................................................................................................................8
2.5.2 硬件分析 ...................................................................................................................8
2.5.3 人员分析 ...................................................................................................................8
2.6 经济方面可行性分析 ..........................................................................................................8
2.7 结论 ......................................................................................................................................9
第三章 系统总体设计 .....................................................................................................................10
3.1 数据流程分析 ....................................................................................................................10
3.2 系统总体软件结构 ............................................................................................................12
3.3 数据库设计 ........................................................................................................................13
3.3.1 数据项和数据结构 .................................................................................................13
3.3.2 数据库概念设计 .....................................................................................................13
3.3.3 数据库物理设计 .....................................................................................................16
第四章 系统主要功能实现 .............................................................................................................19
4.1 Web.config 文件配置 ......................................................................................................19
4.2 页面的风格设计 ...............................................................................................................19
4.3 系统登陆模块的实现 .......................................................................................................20
4.4 商品管理模块的实现 .......................................................................................................22
4.4.1 添加商品类别信息功能的实现 .............................................................................22
4.4.2 添加商品信息功能的实现 .....................................................................................24
4.4.3 商品查询维护功能的实现 ......................................................................................27
4.5 员工管理模块的实现 .......................................................................................................28
4.5.1 添加员工信息功能的实现 .....................................................................................29
4.5.2 员工查询维护功能的实现 .....................................................................................31
4.6 进货管理模块的实现 .......................................................................................................32
4.6.1 添加进货信息功能的实现 .....................................................................................32
4.6.2 进货信息查询功能的实现 .....................................................................................34
4.6.3 添加进货退货信息功能的实现 .............................................................................35
5
4.6.4 进货退货信息查询功能的实现 .............................................................................39
4.7 销售管理模块的实现 .......................................................................................................41
4.7.1 员工销售商品功能的实现 .....................................................................................41
4.7.2 员工销售业绩排名功能的实现 .............................................................................46
4.7.3 顾客办理退货功能的实现 .....................................................................................48
4.8 库存管理模块的实现 .......................................................................................................51
4.8.1 库存查询功能的实现 .............................................................................................51
4.8.2 库存盘点功能的实现 .............................................................................................52
4.8.3 库存报警功能的实现 .............................................................................................54
第五章 系统的发布 .........................................................................................................................55
结 论 .................................................................................................................................................56
参考文献 ...........................................................................................................................................56
致 谢 .................................................................................................................................................57
