某店POS積分管理系統——積分實績更新及銷售狀況統計

論文字數:14482,頁數:35

摘  要
目前流行的POS積分管理系統給百貨店客戶提供了方便的服務平臺。積分手段能夠帶給客戶更多的實惠和利益，也能大大增強百貨店在日益激烈的行業競爭中的競爭力。通過對積分的管理，百貨店可以獲得更好的信譽，增加客戶流量，從而獲得更多利益。
POS系統包括積分實績更新、各店鋪交易狀況統計、會員價銷售狀況數據做成和POS詳細積累處理功能等主要模塊。積分實績更新是按照由各店鋪得到的POS交易信息累計會員的消費積分；各店鋪交易狀況統計是按照會員的消費記錄統計各店鋪的交易情況；會員價銷售狀況數據做成是按照會員消費記錄統計會員價銷售狀況并做成統計數據文件；而POS詳細積累處理是從POS詳細交易信息文件讀入詳細交易信息再存入數據庫。這些模塊通過在日文Windows 2000系統上使用C#語言和SQL server 2000數據庫來實現，最終達成積分實績更新及銷售狀況統計的功能。

關鍵字: 積分；統計；POS

Points Accumulative Management of POS System for
A Store-Points updating and sale statistics
Abstract
The POS points accumulative management system of the department stores offers a convenient service platform for the customers of the stores. The point accumulation provides more boons and benefits to the customers and greatly improves the competence of the department store in the fierce market competitions. By managing the accumulative points, the department store can gain more credit, more customers and finally get higher profits.
The POS system includes the following functions: the updating of the accumulative points; the counting of the department stores’ trading conditions; the statistics of the sales conditions of member price trading and the POS detailed accumulation processing function. The first function updates the consumption scores of the members according to the POS trading information from the stores; the second function counts the trading records of the stores according to the consumption records of the members; the third function counts the trading records of the member price and makes the results a statistic file; and the fourth function loads information of the POS detailed trading data and saves it in the database. These functions are built on the Japanese Windows 2000 system by the C# language and the SQL server 2000 database. This system will finally perform the accumulative points update and the trading condition summarization functions.

Key words: Scoring;  Statistic;  POS

目      錄

1 引言 1
2 模塊需求分析 2
2.1 模塊功能需求 2
2.1.1 積分卡所包含的基本資料 2
2.1.2 處理功能需求 3
2.2 客戶對該模塊的期望 3
2.3 模塊其他需求 3
2.3.1 開發環境需求 3
2.3.2 人力資源需求 4
2.3.3 時間需求 4
3 可行性研究 4
3.1 技術可行性 4
3.1.1 C#技術的特點 4
3.1.2 Microsoft SQL Server 2000的可行性分析 5
3.2 經濟可行性 5
4 數據庫設計 6
4.1 數據流程圖 6
4.1.1 積分實績更新數據流程圖 6
4.1.2 各店鋪交易狀況統計數據流程圖 7
4.1.3 會員價銷售狀況數據作成數據流程圖 8
4.1.4 POS詳細積累處理數據流程圖 9
4.2 數據庫結構設計 9
4.2.1 表名定義 9
4.2.2 數據庫表設計 10
5 模塊功能代碼實現過程 15
5.1 共通函數的使用 15
5.1.1 共通文件（INI文件）取得 15
5.1.2 連接數據庫 16
5.2 數據庫操作 16
5.2.1 數據庫表的讀取和計數 16
5.2.2 數據庫表的添加、更新和刪除 17
5.3 數據文件操作 18
5.3.1 數據文件的讀取 18
5.3.2 數據文件的寫入 19
6 模塊測試結果 20
6.1 積分實績更新模塊測試結果 20
6.2 各店鋪交易狀況統計模塊測試結果 22
6.3 會員價銷售狀況數據作成模塊測試結果 24
6.4 POS詳細積累處理模塊測試結果 26
結    論 27
參考文獻 28
致    謝 29
聲    明 30