論文字?jǐn)?shù):14482,頁(yè)數(shù):35

摘  要
目前流行的POS積分管理系統(tǒng)給百貨店客戶(hù)提供了方便的服務(wù)平臺(tái)。積分手段能夠帶給客戶(hù)更多的實(shí)惠和利益，也能大大增強(qiáng)百貨店在日益激烈的行業(yè)競(jìng)爭(zhēng)中的競(jìng)爭(zhēng)力。通過(guò)對(duì)積分的管理，百貨店可以獲得更好的信譽(yù)，增加客戶(hù)流量，從而獲得更多利益。
POS系統(tǒng)包括積分實(shí)績(jī)更新、各店鋪交易狀況統(tǒng)計(jì)、會(huì)員價(jià)銷(xiāo)售狀況數(shù)據(jù)做成和POS詳細(xì)積累處理功能等主要模塊。積分實(shí)績(jī)更新是按照由各店鋪得到的POS交易信息累計(jì)會(huì)員的消費(fèi)積分；各店鋪交易狀況統(tǒng)計(jì)是按照會(huì)員的消費(fèi)記錄統(tǒng)計(jì)各店鋪的交易情況；會(huì)員價(jià)銷(xiāo)售狀況數(shù)據(jù)做成是按照會(huì)員消費(fèi)記錄統(tǒng)計(jì)會(huì)員價(jià)銷(xiāo)售狀況并做成統(tǒng)計(jì)數(shù)據(jù)文件；而POS詳細(xì)積累處理是從POS詳細(xì)交易信息文件讀入詳細(xì)交易信息再存入數(shù)據(jù)庫(kù)。這些模塊通過(guò)在日文Windows 2000系統(tǒng)上使用C#語(yǔ)言和SQL server 2000數(shù)據(jù)庫(kù)來(lái)實(shí)現(xiàn)，最終達(dá)成積分實(shí)績(jī)更新及銷(xiāo)售狀況統(tǒng)計(jì)的功能。

關(guān)鍵字: 積分；統(tǒng)計(jì)；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 客戶(hù)對(duì)該模塊的期望 3
2.3 模塊其他需求 3
2.3.1 開(kāi)發(fā)環(huán)境需求 3
2.3.2 人力資源需求 4
2.3.3 時(shí)間需求 4
3 可行性研究 4
3.1 技術(shù)可行性 4
3.1.1 C#技術(shù)的特點(diǎn) 4
3.1.2 Microsoft SQL Server 2000的可行性分析 5
3.2 經(jīng)濟(jì)可行性 5
4 數(shù)據(jù)庫(kù)設(shè)計(jì) 6
4.1 數(shù)據(jù)流程圖 6
4.1.1 積分實(shí)績(jī)更新數(shù)據(jù)流程圖 6
4.1.2 各店鋪交易狀況統(tǒng)計(jì)數(shù)據(jù)流程圖 7
4.1.3 會(huì)員價(jià)銷(xiāo)售狀況數(shù)據(jù)作成數(shù)據(jù)流程圖 8
4.1.4 POS詳細(xì)積累處理數(shù)據(jù)流程圖 9
4.2 數(shù)據(jù)庫(kù)結(jié)構(gòu)設(shè)計(jì) 9
4.2.1 表名定義 9
4.2.2 數(shù)據(jù)庫(kù)表設(shè)計(jì) 10
5 模塊功能代碼實(shí)現(xiàn)過(guò)程 15
5.1 共通函數(shù)的使用 15
5.1.1 共通文件（INI文件）取得 15
5.1.2 連接數(shù)據(jù)庫(kù) 16
5.2 數(shù)據(jù)庫(kù)操作 16
5.2.1 數(shù)據(jù)庫(kù)表的讀取和計(jì)數(shù) 16
5.2.2 數(shù)據(jù)庫(kù)表的添加、更新和刪除 17
5.3 數(shù)據(jù)文件操作 18
5.3.1 數(shù)據(jù)文件的讀取 18
5.3.2 數(shù)據(jù)文件的寫(xiě)入 19
6 模塊測(cè)試結(jié)果 20
6.1 積分實(shí)績(jī)更新模塊測(cè)試結(jié)果 20
6.2 各店鋪交易狀況統(tǒng)計(jì)模塊測(cè)試結(jié)果 22
6.3 會(huì)員價(jià)銷(xiāo)售狀況數(shù)據(jù)作成模塊測(cè)試結(jié)果 24
6.4 POS詳細(xì)積累處理模塊測(cè)試結(jié)果 26
結(jié)    論 27
參考文獻(xiàn) 28
致    謝 29
聲    明 30