某百貨店POS積分管理系統——積分添加和通票回收

論文字數:11626,頁數:32

摘  要
百貨商店是與人們生活密切相關的重要部分，是人們購買日常生活用品最為方便，且日常用品最為豐富集中，日常消費也最為頻繁的場所，隨著現代社會的進步，生活節奏的加快，它的重要地位越來越顯著。為了給客戶提供更方便的服務平臺，同時也為了能讓百貨店交易業務管理規范化而設計了POS積分管理系統。POS積分管理系統主要以積分點的形式，對顧客在該店的購物情況與以統計，積分點累計到一定程度，對顧客返回獎勵的方式刺激消費，從而增加店鋪的銷售業績，也給顧客帶來了更多的實惠。
某店POS積分管理系統中積分添加和通票回收的功能在這一系統中起著重要的作用。積分添加是按照積分添加規則對每天的交易產生的積分點進行添加處理，更改相應的數據表信息。而通票回收主要是根據初期的參數數據對通票回收數據再度處理，生成新的通票回收數據文件。模塊是基于日文系統Windows 2000,采用C#開發語言，并使用SQL server 2000的數據庫來實現了積分點添加以及通票回收處理的功能。系統著重程序的運行異常處理，CSV文件的讀寫和數據庫的基本操作處理。

關鍵詞：計算機應用；管理信息系統；POS；SQL數據庫;積分添加；通票回收
The Integral Management of POS System for a Department Store
        ——The Integral adding and Ticket Recovering
Abstract
 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

目  錄

1   引 言 1
2   模塊需求分析 1
2.1   模塊功能需求 1
2.2   客戶對模塊性能要求 1
2.3   模塊開發需求 2
3   系統開發設計分析 2
3.1   系統設計模式 2
3.2   模塊功能分析 3
3.2.1   積分添加模塊的功能分析 3
3.2.2   通票回收模塊的功能分析 4
3.3   程序流程及分析 4
3.3.1   積分添加模塊的流程圖 3
3.3.2   通票回收模塊的流程圖 5
3.4   模塊的詳細設計 5
3.4.1   模塊主要對象的定義 5
3.4.2   數據庫結構設計 6
4   模塊的實現過程分析 10
4.1   積分添加類具體實現 10
4.2   通票回收類具體實現 19
5   系統運行結果 23
5.1   積分添加類測試結果 23
5.2   通票回收類測試結果 25
結論 26
參考文獻 26
致謝 27
聲明 28