a的spnet超市管理系统.doc

摘要 现代高速发展的信息时代，超市管理系统已是一个超市管理者与决策者不可缺少的管理工具，因此超市管理系统应该能够为用户提供充足的信息，便捷的操作，快速的查询手段。 本程序是一个典型的信息管理程序，其开发主要包括后台数据库的建立以及前端应用程序的开发两个方面。对于前者建立数据一致性完整性、安全性好的库而对于后者则主要完成对超市的管理，包括进货管理，销售管理，库存管理员工管理个方面。系统可以完成对信息的浏览、查询、添加、删除、修改等功能。 的核心是销售、库存和进货管理三者之间的联系系统有完整的用户Abstract The development of modern high-speed information age, the supermarket management system is a supermarket managers and decision makers an indispensable management tool, the supermarket management system should be able to provide sufficient information for users, easy operation, fast query tool. This procedure is a typical information management program, its development process, including background of the establishment of the database and front-end application development aspects. The former uses Microsoft SQL Server 2005 to build a set of data consistency, integrity, security, good database, but the latter is written using Microsoft Visual Studio 2005 is easy to use, to meet the needs of running the program. The entire project was completed for the daily management of supermarket goods, including the purchase management, sales management, inventory management, staff management and management of five members. Functionally complete information system can browse, search, add, delete, modify and so on. The core of this issue is one of sales management, inventory management and purchase management links between the three, while the system has a complete user management and permissions management. Keywords: database, control, authority 目录 一.引言……………………………………………………………………………………4 1.1课题研究意义与发展前景…………………………………………………………4 1.2程序设计的目的与功能特点………………………………………………………4 二.超市管理系统程序设计总体分析………………………………………………… 5 2.1程序总体需求分析与功能需求分析……………………………………………… 5 2.2程序设计可行性分析……………………………………………………………… 6 2.3程序设计开发环境与开发工具…………………………………………………… 7 三.程序总体结构设计………………………………………………………………… 10 3.1程序结构设计……………………………………………………………………… 10 3.2数据库设计………………………………………………………………………… 13 四.程序详细设计……………………………………………………………………… 22 4.1数据库配置………………………………………………………………………… 22 4.2功能模块实现………………………………