摘 要
大型百货店作为日常生活中不可缺少的一部分，给人们的生活提供了很大的方便。而为这样一个庞大而复杂的购物平台，提供一套完备的管理系统支持是很必要的。在现代销售行业中，会员制、积分管理、代金消费的概念已经越来越普及。为了吸引更多消费者，加大销售企业的竞争力。就需要在商场管理系统的基础上建立一个积分管理的子系统，对百货店的会员管理、积分消费机制和POS机硬件系统提供软件支持。积分管理系统具有强大的信息搜集、处理、分析功能，将其引入商场管理系统中，通过积分的管理获得客户更好的信誉，增加客户流量，获得更多的利益。
某百货店POS积分管理系统中定期清除积分履历表并备份、定期清除积分更新日志表并备份的功能在系统中起着比较重要的作用。由于商店每天要处理的信息量很大，为了防止数据容量增长过大，考虑到系统安全及稳定的需要，要求定期对数据表做清除备份的工作。月购买额清除及处理的功能则主要实现消费者数据匹配的作用。
开发平台是基于日文系统Windows 2000,采用C＃.NET开发语言，并使用SQL SERVER 2000的数据库来实现的。
关键词：计算机应用技术；信息管理系统；积分；更新；C＃.NET
An Integral Management of the POS System for a Department Store
---Clearance of CV Table, Log Table and Monthly Expenditure
Abstract
As indispensable part of daily life，it is of great convenience to consume in large department stores. For such a large and complex platform, it is essential to provide a comprehensive support of management system. In modern sales, the concepts of membership system, integral management and monetary equivalent ticket have become increasingly popular. In order to attract more consumers and increase the competitiveness of sales, it needs to establish an integral management subsystem on the basis of the mall management system in a department store，and software support for the membership system, integral expense mechanism and POS hardware system is provided. There are powerful information gathering, processing and analyzing capabilities in the system. It will certainly obtain better clients’ credibility and better increase of customer flow to gain more benefits by introducing the integral management into the store management system
As an integral management of POS system for a department store, clearance of CV table, log table and its backup file play a more important role in the system. As a great number of information is to be handled every day, to prevent excessive growth of data capacity, take into account of the security and stability of the system, a regular data-backup-clearing is required. The clearance and dealing of the monthly expenditure are mainly to match with consumers’ data.
The Japanese system Windows 2000 is used as the development platform and C #. NET as the development language and the SQL Server 2000 for database.
Key words：Computer Applications; Management Information System; Integral; Update; C＃.NET
