摘   要

在最近的十几年中，超市的发展越来越迅速，规模越来越大。而随着超市商品的大量丰富，其管理难度也越来越大，如何优化超市的管理成为一个亟于解决的问题。这样将计算机这一信息处理利器应用于超市的日常管理成为一种必然的趋势，通用超市销售管理系统就是在这种趋势下产生的。

    本系统选用C++ Builder集成开发环境，使用了SQL Server 2000数据库。

在系统实现的过程中，为了界面的美观，使用了Windows编程技术和MDI结构。为了减少系统资源的消耗和提高程序的运行效率，大多数窗体采用了动态创建的方法。为了系统的安全性，在验证用户密码和保存用户密码时使用了MD5加密算法。为了保存数据库服务器配置信息和快捷键设置信息，使用了TIniFile和INI文件。

本系统由前台销售和后台管理两个功能块组成。最终实现前台销售系统，包括顾客购买记录、当日销售的情况的统计、密码验证和修改。实现后台管理系统，包括进货登记、根据给定时间的销售统计、标价签和报表打印、数据备份和还原及员工和供应商信息的管理。实现了多种窗体查询功能和统计功能。

本系统界面简洁，实用性强，安全性高，各模块功能清晰，易于维护和使用，为销售人员和管理人员提供了人性化服务,中、小型超市进行销售管理工作的好帮手。

关键词：销售管理；C++ builder；数据库；MD5加密

Abstract

In recent years, the development of supermarkets is rapider and rapider; the scale of supermarkets is larger and larger. However with large numbers of increasing goods in supermarkets, the supermarket management is more and more difficult. How to optimize the supermarket management becomes a question that is anxious to solve. So it is an inevitable trend that computers, the powerful information process devices, are applied to daily supermarkets management. The Universal Supermarket Sell Management System ( USSMS ) is developed following such a trend.

The system is designed with C++ Builder, using SQL Server 2000 database system. 

When implementing the system, the Windows programming technology and MDI structure are introduced for beautiful interfaces. In order to reduce memory consumption and increase running efficiency, most forms are established by means of dynamic technique. The MD5 encryption algorithm is used to guarantee system security when validating users’ passwords and saving users’ passwords. TIniFile and INI file are also used to save the database configure and shortcut key setting information.

The system composes of two function modules as follows: foreground sells and background management. At last, foreground sells function modules including: customers’ sale records, today sale statistics, passwords validation and modification have been achieved. Background management function modules including: entry records, given time sale statistics, price labels and reports print, database restoration and backup, employees and suppliers information management have been achieved correspondingly. Several kinds of form query and statistics functions are also included with the system.

Additionally, the system has friendly interfaces, high practicability and security, clear function modules, easy maintenance and use, humanized services for salesmen and managers as well. Therefore the system is a good assistant for salesmen and managers’ sell management in medium-sized or pint-sized supermarkets.

Key words:  sell management; C++ Builder; database; MD5

目    录

引言. 1

1  绪论. 1

1.1 课题背景... 1

1.2 课题发展现状... 2

1.3 课题意义... 2

1.4 课题完成情况... 2

1.5 本文所做工作... 2

2  系统前期分析. 2

2.1 系统语言的选用... 3

2.2 开发环境的选用... 3

2.3 数据库的选用... 4

2.3.1 关于数据库的知识. 4

2.3.2 关于SQL的相关知识. 4

2.3.3 SQL Server2000介绍. 5

2.4 DLL技术... 6

2.4.1 DLL模块创建. 6

2.4.2 DLL模块调用. 6

2.4.3 DLL模块作用. 7

2.5 MD5加密算法... 7

2.6 Windows应用程序接口(API). 7

3  系统分析. 8

3.1 系统数据流图描述... 8

3.2  系统流程描述... 11

3.2.1 系统总流程分析. 11

3.2.2 商品销售模块流程分析. 12

3.2.3 进货登记模块流程分析. 13

3.3 数据库结构分析... 13

4  系统设计. 15

4.1 程序主窗体设计... 15

4.2 数据库配置模块的设计... 16

4.3 登陆模块的设计... 16

4.4 商品销售模块的设计... 17

4.5 商品搜索模块的设计... 19

4.6 销售统计模块的设计... 20

4.7 进货登记模块的设计... 21

4.8 基本信息管理模块的设计... 22

4.9 数据库操作模块的设计... 22

4.10 数据库结构设计... 23

5  系统采用的主要技术. 26

5.1 动态产生窗体对象... 26

5.2 多文档（MDI）结构... 27

5.3 MD5加密算法... 27

5.4 TIniFile和INI文件... 27

6  调试和测试. 27

6.1 调试方法... 27

6.1.1使用try和catch的处理方法. 27

6.1.2 使用宏定义调试方法. 28

6.1.3 使用控件显示方法测试. 28

6.1.4 使用CodeGuard 29

(需要该计算机毕业设计论文的,请联系我们在线客服QQ:599057179或联系我们客服电话:13723761910)