【正文】 摘要 I 摘 要 隨著科學技術的迅猛發(fā)展，整個社會已進入了信息社會，計算機的應用在社會中的地位越來越重要。傳統(tǒng)的以書本記錄的方式已不能滿足要求，數(shù)據(jù)庫技術正緩解了這一問題。 為 使 商業(yè)企業(yè) 的 進銷存信息管理自動化、標準化和科學化， 需 研制 具有大規(guī)模、高效率的超市信息管理系統(tǒng)，即 會員制超市管理系統(tǒng) 。本系統(tǒng)采用 C.NET 和 SQL Server2021 數(shù)據(jù)庫等開發(fā)工具 ， 使用 技術 ， 實現(xiàn)了對數(shù)據(jù)庫的直接訪問和操作 ， 使得數(shù)據(jù)庫和應用程序緊密結合在一起。 該超市管理系統(tǒng)要解決的問題 是：如何實現(xiàn)會員制連鎖超市的科學、高效 的管理，包括商品基本信息管理、會員信息管理、進貨信息的管理、銷售信息的管理、庫存信息的管理、員工信息的管理。 其最終目的是通過此軟件來實現(xiàn)超市各個環(huán)節(jié)的管理。 本文首先介紹了軟件的開發(fā)環(huán)境，其次介紹了本軟件的設計過程 ，最后介紹了各模塊的設計 與 實現(xiàn) 。 關鍵詞： 會員制 ， 超市， 進貨，庫存 ， 管理信息系統(tǒng) 摘要 II Abstract With the development of science and technology, the society has been stepped into Information society. The tradition way in keeping the information has already not fit in the world, and data base alleviate this question by technology, which exactly meet the application. In order to made the InputSellingStoring Information System bee more scientific and effective, the system is that the Management System of Membership Supermarket. This system uses the C.NET and SQL Server as the developing tool. With the technology of active data object (ADO), I can make it reality not only data can be visited directly and controlled, but also data and program are connected tightly. In order to made management of supermarket bee more scientific and effective, we developed this system including the basic management information goods, the management information of membership, the management information of stock, the management information of distribution, the management information of storage, the management information of workers. The key to this system is how to management of supermarket’s different departments. This paper first introduces the development environment of this software, then, introduces the design process, and finally introduces the Design and Implementation of the modules. Keywords: membership, supermarket, purchase, stock, management information system 目錄 i 目 錄 摘 要 ................................................................................................................................. I Abstract .............................................................................................................................II 1 緒論 ................................................................................................................................. 1 超市進銷存管理系統(tǒng)簡介 .................................................................................. 1 會員制超市管理系統(tǒng)模式 .................................................................................. 2 本系統(tǒng)的技術概況 .............................................................................................. 3 數(shù)據(jù)庫管理系統(tǒng) ....................................................................................... 3 采用 SQL Server2021 數(shù)據(jù)庫 .................................................................. 3 采用 C.Net 作為前端開發(fā)工具 .............................................................. 4 采用 ADO 編程模型 ................................................................................. 4 系統(tǒng)的運行環(huán)境 .................................................................................................. 5 2 系統(tǒng) 分析與 設計 ............................................................................................................. 6 需求分析 .............................................................................................................. 6 問題定義 ................................................................................................... 6 系統(tǒng)的主要功能 ....................................................................................... 6 設計功能注意事項 ................................................................................... 7 系統(tǒng)總體設計 ...................................................................................................... 7 系統(tǒng) ER 圖 ............................................................................................... 7 系統(tǒng)功能模塊設計 ................................................................................... 9 系統(tǒng)流程圖 ............................................................................................. 12 數(shù)據(jù)庫的設計 ......................................................................................... 13 3 系統(tǒng)實現(xiàn) ....................................................................................................................... 18 用戶登錄模塊 ................................................................................................... 18 系統(tǒng)的主界面 .................................................................................................... 19 商品管理模塊 .................................................................................................... 24 進貨管理模塊 .................................................................................................... 25 員工管理模塊 .................................................................................................... 28 銷售管理模塊 .................................................................................................... 29 會員管理模塊 .................................................................................................... 33 目錄 ii 退貨管理模塊 .................................................................................................... 34 4系統(tǒng)的測試與運行 ....................................................................................................... 35 結論 .................................................................................................................................. 37 致謝 .................................................................................................................................. 38 參考文獻 .......................................................................................................................... 39 附錄 ......................................................................................................