某店P(guān)OS積分管理系統(tǒng)——銷售情況,會員卡再發(fā)行數(shù)據(jù)生成

論文字?jǐn)?shù):7898,頁數(shù):24

新宋體摘  要
百貨店是我們生活中不可缺少的一部分，為了給客戶提供更方便的服務(wù)平臺，而設(shè)計(jì)了POS積分管理系統(tǒng)。積分卡廣泛流行于國內(nèi)外各大企業(yè)。有了積分卡，即可通過參加各種積分活動獲得更多禮品或其它利益，也可以通過積分手段增加各個(gè)企業(yè)之間的競爭力。利用先進(jìn)的科學(xué)技術(shù)和管理手段增加社會經(jīng)濟(jì)效益，從而提高人民的生活水平。百貨店通過點(diǎn)積分的管理獲得客戶更好的信譽(yù)，增加客戶流量，獲得更多的利益。
其中對POS機(jī)進(jìn)行數(shù)據(jù)操作以及會員卡再發(fā)行系統(tǒng)在POS積分管理這一系統(tǒng)中起著重要的作用。POS機(jī)上的數(shù)據(jù)操作主要是將POS機(jī)上的數(shù)據(jù)轉(zhuǎn)存到數(shù)據(jù)庫或數(shù)據(jù)文件中,而會員卡再發(fā)行系統(tǒng)則可以通過將失效會員卡循環(huán)利用，從而保證成本控制。模塊是基于日文系統(tǒng)Windows 2000,需要采用C#.NET開發(fā)語言，并使用SQL server 2000數(shù)據(jù)庫來實(shí)現(xiàn)POS銷售信息轉(zhuǎn)存以及提取會員卡再發(fā)行相關(guān)信息。以此為目標(biāo)，在掌握了日文操作系統(tǒng)使用方法的基礎(chǔ)上，以C#.NET技術(shù)為工具完成了模塊。

關(guān)鍵詞：計(jì)算機(jī)應(yīng)用；信息管理系統(tǒng)；銷售情況；會員卡再發(fā)行數(shù)據(jù)生成；C＃.NET；SQL SERVER 2000
The Integral Management of POS System for a Store
——Selling Statistics and Member Card Re-issue
Abstract
Department store has become an essential part of our lives. The POS integral management system is designed to provide more convenient service platform to the customer in department store. Accumulating card is very popular in domestic and foreign enterprises. Owning to accumulating card, one can obtain more presents or other benefits by participating in variety of integral activities, which also can increase the competition between different enterprises. It is the very way to raise people's living standard by increasing social economy benefit with the more and more developed science and technology. Better prestige, larger customer current capacity and more benefits can be obtained with the operation of point integral management in the department store.
The data operation on POS and the member card re-issue system plays an import role in POS management system. The data operation on POS is to transfer data and save into data base or data files, while the member card re-emission system is used to recycle run out member card and reduce cost. The module adopts Japanese-based Windows 2000 and C# NET as a developing language and use the SQL server 2000 as database to achieve the capabilities of saving and getting POS selling information, or extracting information related to member card re-emission from it. In order to attain this goal, we completed this module by using C#.NET as a tool and basing on the application method of Japanese operating system.

Key words: Computer Application；Management Information System；Sell Condition；Member Card Re-issue；C#. NET；SQL SERVER 2000

目  錄

1．引言 1
2．系統(tǒng)概述 1
3．模塊需求分析 1
3.1  POS銷售情況處理 2
3.2 會員卡再發(fā)行系統(tǒng) 2
4．可行性分析 2
4.1 經(jīng)濟(jì)可行性 2
4.2 技術(shù)可行性 3
5．?dāng)?shù)據(jù)庫設(shè)計(jì) 3
5.1  POS銷售情況處理 3
5.1.1  數(shù)據(jù)流程圖 3
5.1.2  數(shù)據(jù)表結(jié)構(gòu)設(shè)計(jì) 3
5.2  會員卡再發(fā)行系統(tǒng) 4
5.2.1  數(shù)據(jù)流程圖 4
5.2.2  數(shù)據(jù)表結(jié)構(gòu)設(shè)計(jì) 5
6．環(huán)境搭建 5
7．模塊功能代碼實(shí)現(xiàn)過程 5
7.1  共通函數(shù)的使用 5
7.1.1  共通文件（INI文件）取得 5
7.1.2  連接數(shù)據(jù)庫 6
7.2  數(shù)據(jù)庫操作 6
7.2.1   數(shù)據(jù)庫表的讀取 6
7.2.2   數(shù)據(jù)庫表的添加、更新 7
7.2.3   數(shù)據(jù)庫表的刪除 7
7.3  數(shù)據(jù)文件操作 8
7.3.1   數(shù)據(jù)文件的讀取 8
7.3.2   數(shù)據(jù)文件的寫入 8
8. 模塊測試 9
8.1  POS銷售情況處理測試 9
8.2  會員卡再發(fā)行系統(tǒng)測試 12
9. 問題與解決方案 13
9.1  數(shù)據(jù)類型轉(zhuǎn)換 13
9.2  標(biāo)準(zhǔn)化代碼 14
結(jié)    論 15
參考文獻(xiàn) 16
致    謝 17
聲    明 18