摘 要
大型百貨店作為日常生活中不可缺少的一部分，給人們的生活提供了很大的方便。而為這樣一個龐大而復雜的購物平臺，提供一套完備的管理系統支持是很必要的。在現代銷售行業中，會員制、積分管理、代金消費的概念已經越來越普及。為了吸引更多消費者，加大銷售企業的競爭力。就需要在商場管理系統的基礎上建立一個積分管理的子系統，對百貨店的會員管理、積分消費機制和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
