II
摘 要
本文首先简单给出了超市管理系统的设计背景和意义，并介绍了系统开发所用到的
开发工具和语言，然后在进行了需求分析的基础上，说明了系统功能模块的划分及各模
块之间的相互关系，然后着重论述了系统功能的一些重要的技术实现过程。
本系统的每一个功能模块都包含了多个功能。整个系统主要完成对超市商品的日常
管理，包括进货管理，销售管理，库存管理，员工管理和供应商管理等方面。在功能上
系统可以完成对相关信息的浏览、查询、添加、删除、修改等功能。本课题的核心之一
是销售管理、库存管理和进货管理三者之间的联系，同时系统有完整的用户管理及权限
管理功能。
本系统采用C#语言和SQL Server 2005作为开发工具。这种系统优势在于系统比较简
单，但功能强大，扩展性能也比较好，完全能够处理一般超市的日常任务。
关键词：C/S架构；数据库；超市管理
I
Abstract
Firstly, this article gave out the supermarket management system of the background and
the meaning，and then it briefly introduced the developing instruments and languages used
f o r t h e s y s t e m . O n t h e b a s i s o f s y s t e m a t i c d e m a n d a n a l y s i s , T h e n t h e a r t i c l e m ad e a
f u n c t i o n a l a n a l y s i s f o r t h e r e s o u r c e r e s e r v a t i o n s y s t e m , t h e t h e s i s
d e m o n s t r a t ed s t r u c t u r e s o f t h e s yst e m f u n c t i o n a n d t h e r e l a t i o n s o f e a c h
m o d u l e .F i n a l l y , t h e a r t i c l e p ai d m u c h e f f o r t s i n e x p l a i n i n g h o w t o a p p ly t h e a d v a n c e d
technologies into the whole system．
System functional modules each contain a number of features. The system was completed
f o r t h e d a i l y m a n a g e m e n t o f s u p e r m a r k e t g o o d s , i n c l u d i n g t h e p u r c h a s e m a n a g e m e n t ,
s a l es m a n a g e m e n t , i n v e n t o r y m a n a g em e n t , s t a f f m a n a g em e n t , su p p l i e r m a n a g e m e n t a n d s o
on. Functionally completed information system can browse, search, add, delete, modify and so
on. The core of this issue was one of sales management, inventory management and purchase
management links between the three, while the system had a complete user management and
permissions management.
The system used the C# language and SQL Server 2005 as a development tool. Advantage
o f t h e s y s t e m s u c h a s y s t e m w a s r e l a t i v e l y s i m p l e , b u t p o w e r f u l , t h e e x p a n s i o n o f b e t t e r
performance, fully was able to handle day-to-day tasks of the general store.
Keywords: C/S structure; Database; Supermarket management
II
目 录
摘 要...........................................................................................................................................I
Abstract....................................................................................................................................II
引 言...........................................................................................................................................1
1 基础知识.................................................................................................................................2
1.1 背景与意义...................................................................................................................2
1.2 开发方法.......................................................................................................................2
1.2.1 C#语言介绍........................................................................................................2
1.2.2 SQL Server 2005数据库优点.............................................................................3
1.2.3 运行环境的选择.................................................................................................3
2 系统需求分析.........................................................................................................................5
2.1 系统功能概述...............................................................................................................5
2.1.1 系统功能需求.....................................................................................................5
2.1.2 用例分析.............................................................................................................6
2.1.3 类图分析.............................................................................................................7
2.2 系统性能要求...............................................................................................................7
2.2.1 系统时间特性要求.............................................................................................8
2.2.2 系统灵活性.........................................................................................................8
2.2.3 数据管理能力要求.............................................................................................8
2.3 可行性分析...................................................................................................................8
2.3.1 技术可行性.........................................................................................................8
2.3.2 经济可行性.........................................................................................................8
2.3.3 操作可行性.........................................................................................................8
3 系统概要设计.........................................................................................................................9
3.1 系统总体设计方案.......................................................................................................9
3.2 系统数据流图.............................................................................................................10
3.3 系统活动图.................................................................................................................12
3.4 系统数据库设计.........................................................................................................13
3.4.1 数据库需求分析...............................................................................................13
3.4.2 数据库概念设计(E-R图)..................................................................................13
3.4.3 数据库逻辑设计...............................................................................................15
4 系统的详细设计...................................................................................................................20
4.1 系统主要功能模块设计.............................................................................................20
4.1.1 登录模块流程...................................................................................................20
4.1.2 进货管理流程...................................................................................................20
4.1.3 销售管理流程...................................................................................................21
4.1.4 库存管理流程...................................................................................................22
4.2 系统主要功能模块实现.............................................................................................23
4.2.1 登录模块实现...................................................................................................23
4.2.2 进货管理模块实现...........................................................................................24
III
- 1
- 2
前往页