【正文】 畢 業(yè) 設(shè) 計 (論 文 )某店 POS 積分管理系統(tǒng)——銷售情況,會員卡再發(fā)行數(shù)據(jù)生成論文作者姓名：申請學(xué)位專業(yè)：申請學(xué)位類別：指 導(dǎo) 教 師 姓 名 （職 稱 ）：論文提交日期：某店 POS 積分管理系統(tǒng)——銷售情況,會員卡再發(fā)行數(shù)據(jù)生成摘 要百貨店是我們生活中不可缺少的一部分，為了給客戶提供更方便的服務(wù)平臺，而設(shè)計了 POS 積分管理系統(tǒng)。積分卡廣泛流行于國內(nèi)外各大企業(yè)。有了積分卡，即可通過參加各種積分活動獲得更多禮品或其它利益，也可以通過積分手段增加各個企業(yè)之間的競爭力。利用先進的科學(xué)技術(shù)和管理手段增加社會經(jīng)濟效益，從而提高人民的生活水平。百貨店通過點積分的管理獲得客戶更好的信譽，增加客戶流量，獲得更多的利益。其中對 POS 機進行數(shù)據(jù)操作以及會員卡再發(fā)行系統(tǒng)在 POS 積分管理這一系統(tǒng)中起著重要的作用。POS 機上的數(shù)據(jù)操作主要是將 POS 機上的數(shù)據(jù)轉(zhuǎn)存到數(shù)據(jù)庫或數(shù)據(jù)文件中,而會員卡再發(fā)行系統(tǒng)則可以通過將失效會員卡循環(huán)利用，從而保證成本控制。模塊是基于日文系統(tǒng) Windows 2022,需要采用 C.NET 開發(fā)語言，并使用 SQL server 2022 數(shù)據(jù)庫來實現(xiàn) POS 銷售信息轉(zhuǎn)存以及提取會員卡再發(fā)行相關(guān)信息。以此為目標，在掌握了日文操作系統(tǒng)使用方法的基礎(chǔ)上，以C.NET 技術(shù)為工具完成了模塊。關(guān)鍵詞：計算機應(yīng)用；信息管理系統(tǒng)；銷售情況；會員卡再發(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目 錄論文總頁數(shù)：18 頁1．引言 ?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????12．系統(tǒng)概述 ?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????13．模塊需求分析 ?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????1 POS 銷售情況處理 ???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????2 會員卡再發(fā)行系統(tǒng)?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????24．可行性分析 ?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????2 經(jīng)濟可行性?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????2 技術(shù)可行性?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????35．數(shù)據(jù)庫設(shè)計 ?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????3 POS 銷售情況處理 ???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????3 數(shù)據(jù)流程圖 .........................................................................................................................3 數(shù)據(jù)表結(jié)構(gòu)設(shè)計 .................................................................................................................3 會員卡再發(fā)行系統(tǒng) ???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????4 數(shù)據(jù)流程圖 .........................................................................................................................4 數(shù)據(jù)表結(jié)構(gòu)設(shè)計 .................................................................................................................56．環(huán)境搭建 ?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????57．模塊功能代碼實現(xiàn)過程 ?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????5 共通函數(shù)的使用 ???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????5 共通文件（INI 文件）取得 ..............................................................................................5 連接數(shù)據(jù)庫 .........................................................................................................................6 數(shù)據(jù)庫操作 ???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????6 數(shù)據(jù)庫表的讀取 ...............................................................................................................6 數(shù)據(jù)庫表的添加、更新 ...................................................................................................7 數(shù)據(jù)庫表的刪除 ...............................................................................................................7 數(shù)據(jù)文件操作 ???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????8 數(shù)據(jù)文件的讀取 ...............................................................................................................8 數(shù)據(jù)文件的寫入 ..................................................