摘 要本文首先简单给出了超市管理系统的设计背景和意义，并介绍了系统开发所用到的开发工具和语言，然后在进行了需求分析的基础上，说明了系统功能模块的划分及各模块之间的相互关系，然后着重论述了系统功能的一些重要的技术实现过程。本系统的每一个功能模块都包含了多个功能。整个系统主要完成对超市商品的日常管理，包括进货管理，销售管理，库存管理，员工管理和供应商管理等方面。在功能上系统可以完成对相关信息的浏览、查询、添加、删除、修改等功能。本课题的核心之一是销售管理、库存管理和进货管理三者之间的联系，同时系统有完整的用户管理及权限管理功能。本系统采用C#语言和SQL Server 2005作为开发工具。这种系统优势在于系统比较简单，但功能强大，扩展性能也比较好，完全能够处理一般超市的日常任务。

关键词：C/S架构；数据库；超市管理AbstractFirstly, 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 for the system. On the basis of systematic demand analysis , Then the article made a functional analysis for the resource reservation system, the thesis demonstrated structures of the system function and the relations of each module .Finally, the article paid much efforts in explaining how to apply the advanced technologies into the whole system．System functional modules each contain a number of features. The system was completed for the daily management of supermarket goods, including the purchase management, sales management, inventory management, staff management, supplier management and so 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 of the system such a system was relatively simple, but powerful, the expansion of better performance, fully was able to handle day-to-day tasks of the general store.

Keywords: C/S structure; Database; Supermarket management

目　录引 言11 基础知识31.1 背景与意义31.2 开发方法31.2.1 C#语言介绍41.2.2 SQL Server 2005数据库优点41.2.3 运行环境的选择52 系统需求分析62.1 系统功能概述62.1.1 系统功能需求62.1.2 用例分析82.1.3 类图分析82.2 系统性能要求92.2.1 系统时间特性要求92.2.2 系统灵活性92.2.3 数据管理能力要求102.3 可行性分析102.3.1 技术可行性102.3.2 经济可行性102.3.3 操作可行性103 系统概要设计113.1 系统总体设计方案113.2 系统数据流图123.3 系统活动图143.4 系统数据库设计153.4.1 数据库需求分析153.4.2 数据库概念设计(E-R图)153.4.3 数据库逻辑设计184 系统的详细设计234.1 系统主要功能模块设计234.1.1 登录模块流程234.1.2 进货管理流程244.1.3 销售管理流程244.1.4 库存管理流程254.2 系统主要功能模块实现264.2.1 登录模块实现264.2.2 进货管理模块实现274.2.3 销售管理模块实现284.2.4 库存管理模块实现294.2.5 权限管理模块实现305 系统测试325.1 系统测试步骤325.1.1 单元测试325.1.2 集成测试325.1.3 确认测试335.2 系统测试345.2.1 界面测试345.2.2 功能测试34结 论36致 谢37参考文献38附录 附录清单A39附录 附录清单B46