【正文】 摘要 本文主要介紹了面向商品批發(fā)、零售行業(yè)的商品庫存管理系統(tǒng)的設(shè)計(jì)與開發(fā)過程，通過實(shí)地調(diào)研和數(shù)據(jù)分析，完成了系統(tǒng)需求分析和系統(tǒng)的總體與詳細(xì)設(shè)計(jì)，并編碼實(shí)現(xiàn)。完成入庫，出庫業(yè)務(wù)，且允許一張單據(jù)涉及多種商品，跟蹤倉庫中每種商品的庫存數(shù)量，且可以對其進(jìn)行盤點(diǎn)，提供過期商品查詢，庫存數(shù)量報(bào)警，可以滿足多倉庫需要，支持聯(lián)想輸入技術(shù)。 系統(tǒng)使用的開發(fā)工具是 Microsoft Visual C++，后臺數(shù)據(jù)庫是本地 Sql Server 2020 通過 ADO 與前臺 Visual C++ 連接。采用基于客戶 /服務(wù)器（ Client/Server）的開發(fā)模式。本系統(tǒng)提供的功能模塊有：基礎(chǔ)信息管理模塊，其中包括供應(yīng)商信息管理、客戶信息管理、倉庫信息管理、商品信息管理、地域信息管理、計(jì)量單位管理、上述模塊都具備添加、修改、刪除、瀏覽功能，地域信息管理以樹形視圖形式顯示。日常業(yè)務(wù)管理模塊 ,它包括入庫管理、出庫管理、調(diào)貨管理、庫存盤點(diǎn)，各模塊允許一次對多種商品進(jìn)行操作，并可自動核算合計(jì)數(shù)量及合計(jì)金額。查詢統(tǒng)計(jì)管理中包括過期商品查詢，實(shí)現(xiàn)自動篩選過期商品并刪除之，還有庫存數(shù)量報(bào)警，實(shí)現(xiàn)商品數(shù)量的控制。系統(tǒng)管理模塊包括用戶信息管理等模 塊。系統(tǒng)基本可以實(shí)現(xiàn)對日常商品的管理。 關(guān)鍵詞 ： 商品信息管理系統(tǒng)， C++， Sql Server 2020 ABSTRACT This paper mainly introduces the goods for the wholesale, retail trade of goods, inventory management system design and development process, through field research and data analysis, pleted a system requirements analysis and system overall and detailed design and coding to achieve. Complete Into the warehouse and out of the warehouse, and to allow a document involving some range of goods, tracking warehouse inventory in the number of each type of goods, and inventory can be carried out to provide expired merchandise inquiries, the number of inventory alarm, to meet the needs of multiwarehouse, Support imagine importation of technology. System development tool is Microsoft Visual C + +, the background database is a local Sql Server 2020 through ADO connections with Visual C + +. Based on the Client and Server mode of development. The system function provided by modules are: the basis of information management modules, including providers of information management, customer information management, storage information management, product information management, geographical information management, management of measurement units, the modules have to add, modify, delete, browsing, geographical information management in order to form treelike view. Daytoday business management module, which includes storage management, a database management, and transfer cargo management, stock inventory, the module allows a wide range of goods to operate, and automatic accounting of the total number and total amount. Query statistics, including the management of expired goods, information, automatically filter and remove the expired goods, as well as the number of inventory report to the police, to achieve control of the number of goods. System Management Module, including user information management module. System can achieve the basic modities of daytoday management. Keywords: Commodities, Commodities management system, Visual C++ system development, Sql Server 2020 目錄 摘要 ........................................................................................................................................ I ABSTRACT .......................................................................................................................... II 目錄 ......................................................................................................................................III 第 1章 引言 ......................................................................................................................... 1 研究背景 ............................................................................................................... 1 研究內(nèi)容 ............................................................................................................... 2 第 2章 系統(tǒng)定義與開發(fā) 工具 ............................................................................................. 3 系統(tǒng)定義 ................................................................................................................ 3 系統(tǒng)開發(fā)工具 ....................................................................................................... 3 Visual C++ .............................................................................................. 3 SQL Server 2020 ......................................................................................... 4 ...................................................................................... 4 第 3章 系統(tǒng)分析與設(shè)計(jì) ..................................................................................................... 5 系統(tǒng)需求分析 ....................................................................................................... 5 用戶需求數(shù)據(jù)流分析 ........................................................................................... 6 系統(tǒng)功能結(jié)構(gòu)設(shè)計(jì) ............................................................................................... 9 第 4章 數(shù)據(jù)庫分析與設(shè)計(jì) ............................................................................................... 10 概念結(jié)構(gòu)設(shè)計(jì) ...................................................................................................... 10 邏輯結(jié)構(gòu)設(shè)計(jì) ...................................................................................................... 12 第 5章 商品信息管理系統(tǒng)詳細(xì)設(shè)計(jì)及實(shí)現(xiàn) ...............................................................