某店POS积分管理系统——创建会员信息文件

包括论文,设计,论文字数:11408,页数:34

摘  要
随着社会不断进步和发展，生活节奏不断加快，百货店已经成为我们生活中不可缺少的一部分。为了方便对会员信息的管理，提供更加简单，方便的操作平台，而设计了POS积分管理系统。积分卡在国内外各大企业都是很流行的。有了积分卡，可以通过参加各种积分活动，增加顾客和商家的互动，使顾客获得更多礼品或其它利益，也可以通过积分手段增加各个企业之间的竞争力。百货店通过点积分的管理和销售物美价廉的商品，达到更好的宣传自己的目的，从而获得客户更好的信誉，增加客户流量，获得更多的利益。
某百货店POS积分管理系统中创建会员信息文件模块在这一系统中起着重要的作用。创建会员信息文件是对顾客的购买经历的总结，如果是顾客以前有过购买经历，把顾客信息记录到会员信息文件，否则，把会员信息记录到会员地位级别数据库表和会员信息文件。本模块是基于日文系统Windows 2000,采用C#开发语言，并使用SQL server 2000来实现创建会员信息文件的功能。目前已经实现了模块的创建会员信息文件的功能，并且成功运用到某店POS积分管理系统中。

关键词: 计算机应用技术；信息管理系统；POS；数据库；统计；C#

The Integral Management of the POS System for a Department Store
－The Generation of Members’ Information Files
Abstract
With the rapid development and progress of the society, accelerating the pace of life, Shop around has become an indispensable part of our daily life. In order to facilitate the management of members’ information, provide a more simple and convenient platform, design the IMPS（Integration Management of POS System）. The scorecards are very popular in large department stores in domestic and abroad. With scorecards, through participation in various integral activities to increase customer interaction and businesses, customers may get more gifts or other benefits, and also the enterprise can increase competitiveness in the commercial competition among various enterprises by the integration. Department Stores can promote itself, get better credibility and more other benefits through the management of scores and selling inexpensive goods.
The Creation Of Member File module in IMPS（Integration Management of POS System）plays an important role, summed up the customers'' experiences of purchase. If customers have had previous sales experience, and record customer’ information to member information document, else, put member information record into database called STATUS and Member’s File. This module is developed by use of C# language and SQL server 2000 databases on the platform of Japanese system Windows 2000. The grade point average renewal production as well as the through ticket recycling processing function is realized. And at present, corresponding functions related the module have been realized and successfully applied to the IMPS （Integration Management of POS System）.

Key words: Applied Computer Technology; MIS；Database; POS; Statistical; C#

目  录

1 引言 1
1.1 课题背景 1
1.2 国内外研究现状 1
1.3 课题研究意义 1
1.4 课题研究方法 1
2 需求分析 2
2.1 模块功能需求 2
2.2 其他需求 3
3 可行性研究 3
3.1 技术可行性 3
3.2 经济可行性 4
4 功能框架设计 4
4.1 流程实现 4
4.2 设计思想 5
5 环境搭建 6
6 数据库设计 6
6.1 表名定义 6
6.2 数据库表设计 6
7 功能实现关键代码 10
7.1 使用共通函数 10
7.2 操作数据库表 11
7.3 操作文件 12
8 模块测试结果 14
8.1 INI检查 14
8.2 目录检查 16
8.3 目录下存在文件数检查 17
8.4 数据编辑检查 24
8.5 正常结束 25
结    论 28
参考文献 28
致    谢 29
声    明 30