百货商店是与人们生活密切相关的重要部分，是人们购买日常生活用品最为方便，且日常用品最为丰富集中，日常消费也最为频繁的场所，随着现代社会的进步，生活节奏的加快，它的重要地位越来越显著。为了给客户提供更方便的服务平台，同时也为了能让百货店交易业务管理规范化而设计了POS积分管理系统。POS积分管理系统主要以积分点的形式，对顾客在该店的购物情况与以统计，积分点累计到一定程度，对顾客返回奖励的方式刺激消费，从而增加店铺的销售业绩，也给顾客带来了更多的实惠。

某店POS积分管理系统中积分添加和通票回收的功能在这一系统中起着重要的作用。积分添加是按照积分添加规则对每天的交易产生的积分点进行添加处理，更改相应的数据表信息。而通票回收主要是根据初期的参数数据对通票回收数据再度处理，生成新的通票回收数据文件。模块是基于日文系统Windows 2000,采用C#开发语言，并使用SQL server 2000的数据库来实现了积分点添加以及通票回收处理的功能。系统着重程序的运行异常处理，CSV文件的读写和数据库的基本操作处理。

 

关键词：计算机应用；管理信息系统；POS；SQL数据库;积分添加；通票回收

 The department store is playing an important role in our daily life, where we can purchase something conveniently. It is also a place that having a large numbers of goods and attracting so many customers to consuming in it. With the development of modern society and speeding up of the pace of the life, its importance is becoming more and more evident. In order to give consumers a more convenient service platform and standardize the business, a system of POS Integral adding is designed. This system is worked in the form of integral adding points, statistic the circumstance of shopping of the client in the shop. In order to increase the sale and bring more discounts to the clients, the store would return the consumers something when the point is accumulated to a certain degree,

The integral adding inserting and ticket recovering is playing an important role in store. Integral adding is dealing with the points which produced from every daily transaction and change the relating data table information. Ticket recovering is dealing with the recalling data again according to the primary parameter data and produces the new file of recalling data. This module is based on the Windows 2000 of Japan's system and the C# developing language SQL server 2000 database are adopted to realize the functions of integral adding inserting and ticket recovering. More attention is paid to the abnormal processing, the reading and writing of CSV file, and the base operating of database.

Key words:  Computer application; Management information system; POS; SQL database; integral adding; ticket recovering

论文总页数：28页

1   引 言... 1