某店POS积分管理系统——积分实绩更新及销售状况统计

论文字数:14482,页数:35

摘  要
目前流行的POS积分管理系统给百货店客户提供了方便的服务平台。积分手段能够带给客户更多的实惠和利益，也能大大增强百货店在日益激烈的行业竞争中的竞争力。通过对积分的管理，百货店可以获得更好的信誉，增加客户流量，从而获得更多利益。
POS系统包括积分实绩更新、各店铺交易状况统计、会员价销售状况数据做成和POS详细积累处理功能等主要模块。积分实绩更新是按照由各店铺得到的POS交易信息累计会员的消费积分；各店铺交易状况统计是按照会员的消费记录统计各店铺的交易情况；会员价销售状况数据做成是按照会员消费记录统计会员价销售状况并做成统计数据文件；而POS详细积累处理是从POS详细交易信息文件读入详细交易信息再存入数据库。这些模块通过在日文Windows 2000系统上使用C#语言和SQL server 2000数据库来实现，最终达成积分实绩更新及销售状况统计的功能。

关键字: 积分；统计；POS

Points Accumulative Management of POS System for
A Store-Points updating and sale statistics
Abstract
The POS points accumulative management system of the department stores offers a convenient service platform for the customers of the stores. The point accumulation provides more boons and benefits to the customers and greatly improves the competence of the department store in the fierce market competitions. By managing the accumulative points, the department store can gain more credit, more customers and finally get higher profits.
The POS system includes the following functions: the updating of the accumulative points; the counting of the department stores’ trading conditions; the statistics of the sales conditions of member price trading and the POS detailed accumulation processing function. The first function updates the consumption scores of the members according to the POS trading information from the stores; the second function counts the trading records of the stores according to the consumption records of the members; the third function counts the trading records of the member price and makes the results a statistic file; and the fourth function loads information of the POS detailed trading data and saves it in the database. These functions are built on the Japanese Windows 2000 system by the C# language and the SQL server 2000 database. This system will finally perform the accumulative points update and the trading condition summarization functions.

Key words: Scoring;  Statistic;  POS

目      录

1 引言 1
2 模块需求分析 2
2.1 模块功能需求 2
2.1.1 积分卡所包含的基本资料 2
2.1.2 处理功能需求 3
2.2 客户对该模块的期望 3
2.3 模块其他需求 3
2.3.1 开发环境需求 3
2.3.2 人力资源需求 4
2.3.3 时间需求 4
3 可行性研究 4
3.1 技术可行性 4
3.1.1 C#技术的特点 4
3.1.2 Microsoft SQL Server 2000的可行性分析 5
3.2 经济可行性 5
4 数据库设计 6
4.1 数据流程图 6
4.1.1 积分实绩更新数据流程图 6
4.1.2 各店铺交易状况统计数据流程图 7
4.1.3 会员价销售状况数据作成数据流程图 8
4.1.4 POS详细积累处理数据流程图 9
4.2 数据库结构设计 9
4.2.1 表名定义 9
4.2.2 数据库表设计 10
5 模块功能代码实现过程 15
5.1 共通函数的使用 15
5.1.1 共通文件（INI文件）取得 15
5.1.2 连接数据库 16
5.2 数据库操作 16
5.2.1 数据库表的读取和计数 16
5.2.2 数据库表的添加、更新和删除 17
5.3 数据文件操作 18
5.3.1 数据文件的读取 18
5.3.2 数据文件的写入 19
6 模块测试结果 20
6.1 积分实绩更新模块测试结果 20
6.2 各店铺交易状况统计模块测试结果 22
6.3 会员价销售状况数据作成模块测试结果 24
6.4 POS详细积累处理模块测试结果 26
结    论 27
参考文献 28
致    谢 29
声    明 30