【正文】 畢 業(yè) 設(shè) 計(jì) (論 文 )某店 POS 積分管理系統(tǒng)——銷售情況,會(huì)員卡再發(fā)行數(shù)據(jù)生成論文作者姓名：申請(qǐng)學(xué)位專業(yè)：申請(qǐng)學(xué)位類別：指 導(dǎo) 教 師 姓 名 （職 稱 ）：論文提交日期：某店 POS 積分管理系統(tǒng)——銷售情況,會(huì)員卡再發(fā)行數(shù)據(jù)生成摘 要百貨店是我們生活中不可缺少的一部分，為了給客戶提供更方便的服務(wù)平臺(tái)，而設(shè)計(jì)了 POS 積分管理系統(tǒng)。積分卡廣泛流行于國(guó)內(nèi)外各大企業(yè)。有了積分卡，即可通過(guò)參加各種積分活動(dòng)獲得更多禮品或其它利益，也可以通過(guò)積分手段增加各個(gè)企業(yè)之間的競(jìng)爭(zhēng)力。利用先進(jìn)的科學(xué)技術(shù)和管理手段增加社會(huì)經(jīng)濟(jì)效益，從而提高人民的生活水平。百貨店通過(guò)點(diǎn)積分的管理獲得客戶更好的信譽(yù)，增加客戶流量，獲得更多的利益。其中對(duì) POS 機(jī)進(jìn)行數(shù)據(jù)操作以及會(huì)員卡再發(fā)行系統(tǒng)在 POS 積分管理這一系統(tǒng)中起著重要的作用。POS 機(jī)上的數(shù)據(jù)操作主要是將 POS 機(jī)上的數(shù)據(jù)轉(zhuǎn)存到數(shù)據(jù)庫(kù)或數(shù)據(jù)文件中,而會(huì)員卡再發(fā)行系統(tǒng)則可以通過(guò)將失效會(huì)員卡循環(huán)利用，從而保證成本控制。模塊是基于日文系統(tǒng) Windows 2022,需要采用 C.NET 開發(fā)語(yǔ)言，并使用 SQL server 2022 數(shù)據(jù)庫(kù)來(lái)實(shí)現(xiàn) POS 銷售信息轉(zhuǎn)存以及提取會(huì)員卡再發(fā)行相關(guān)信息。以此為目標(biāo)，在掌握了日文操作系統(tǒng)使用方法的基礎(chǔ)上，以C.NET 技術(shù)為工具完成了模塊。關(guān)鍵詞：計(jì)算機(jī)應(yīng)用；信息管理系統(tǒng)；銷售情況；會(huì)員卡再發(fā)行數(shù)據(jù)生成；C＃.NET；SQL SERVER 2022The Integral Management of POS System for a Store——Selling Statistics and Member Card ReissueAbstractDepartment store has bee 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 petition between different enterprises. It is the very way to raise people39。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 reissue 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 reemission system is used to recycle run out member card and reduce cost. The module adopts Japanesebased Windows 2022 and C NET as a developing language and use the SQL server 2022 as database to achieve the capabilities of saving and getting POS selling information, or extracting information related to member card reemission from it. In order to attain this goal, we pleted 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 Reissue；C. NET；SQL SERVER 2022目 錄論文總頁(yè)數(shù)：18 頁(yè)1．引言 ?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????12．系統(tǒng)概述 ?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????13．模塊需求分析 ?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????1 POS 銷售情況處理 ???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????2 會(huì)員卡再發(fā)行系統(tǒng)?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????24．可行性分析 ?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????2 經(jīng)濟(jì)可行性?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????2 技術(shù)可行性?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????35．?dāng)?shù)據(jù)庫(kù)設(shè)計(jì) ?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????3 POS 銷售情況處理 ???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????3 數(shù)據(jù)流程圖 .........................................................................................................................3 數(shù)據(jù)表結(jié)構(gòu)設(shè)計(jì) .................................................................................................................3 會(huì)員卡再發(fā)行系統(tǒng) ???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????4 數(shù)據(jù)流程圖 .........................................................................................................................4 數(shù)據(jù)表結(jié)構(gòu)設(shè)計(jì) .................................................................................................................56．環(huán)境搭建 ?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????57．模塊功能代碼實(shí)現(xiàn)過(guò)程 ?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????5 共通函數(shù)的使用 ???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????5 共通文件（INI 文件）取得 ..............................................................................................5 連接數(shù)據(jù)庫(kù) .........................................................................................................................6 數(shù)據(jù)庫(kù)操作 ???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????6 數(shù)據(jù)庫(kù)表的讀取 ...............................................................................................................6 數(shù)據(jù)庫(kù)表的添加、更新 ...................................................................................................7 數(shù)據(jù)庫(kù)表的刪除 ...............................................................................................................7 數(shù)據(jù)文件操作 ???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????8 數(shù)據(jù)文件的讀取 ...............................................................................................................8 數(shù)據(jù)文件的寫入 ..................................................