基于CS架構(gòu)的商品庫(kù)存管理系統(tǒng)設(shè)計(jì)與開發(fā)

論文字?jǐn)?shù):12453,頁(yè)數(shù):36

摘要
 本文主要介紹了面向商品批發(fā)、零售行業(yè)的商品庫(kù)存管理系統(tǒng)的設(shè)計(jì)與開發(fā)過程，通過實(shí)地調(diào)研和數(shù)據(jù)分析，完成了系統(tǒng)需求分析和系統(tǒng)的總體與詳細(xì)設(shè)計(jì)，并編碼實(shí)現(xiàn)。完成入庫(kù)，出庫(kù)業(yè)務(wù)，且允許一張單據(jù)涉及多種商品，跟蹤倉(cāng)庫(kù)中每種商品的庫(kù)存數(shù)量，且可以對(duì)其進(jìn)行盤點(diǎn)，提供過期商品查詢，庫(kù)存數(shù)量報(bào)警，可以滿足多倉(cāng)庫(kù)需要，支持聯(lián)想輸入技術(shù)。
 系統(tǒng)使用的開發(fā)工具是Microsoft Visual C++6.0，后臺(tái)數(shù)據(jù)庫(kù)是本地Sql Server 2000通過ADO與前臺(tái)Visual C++6.0連接。采用基于客戶/服務(wù)器（Client/Server）的開發(fā)模式。本系統(tǒng)提供的功能模塊有：基礎(chǔ)信息管理模塊，其中包括供應(yīng)商信息管理、客戶信息管理、倉(cāng)庫(kù)信息管理、商品信息管理、地域信息管理、計(jì)量單位管理、上述模塊都具備添加、修改、刪除、瀏覽功能，地域信息管理以樹形視圖形式顯示。日常業(yè)務(wù)管理模塊,它包括入庫(kù)管理、出庫(kù)管理、調(diào)貨管理、庫(kù)存盤點(diǎn)，各模塊允許一次對(duì)多種商品進(jìn)行操作，并可自動(dòng)核算合計(jì)數(shù)量及合計(jì)金額。查詢統(tǒng)計(jì)管理中包括過期商品查詢，實(shí)現(xiàn)自動(dòng)篩選過期商品并刪除之，還有庫(kù)存數(shù)量報(bào)警，實(shí)現(xiàn)商品數(shù)量的控制。系統(tǒng)管理模塊包括用戶信息管理等模塊。系統(tǒng)基本可以實(shí)現(xiàn)對(duì)日常商品的管理。
 
關(guān)鍵詞：商品信息管理系統(tǒng)，C++，Sql Server 2000

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, completed 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 multi-warehouse, Support imagine importation of technology.     System development tool is Microsoft Visual C + +6.0, the background database is a local Sql Server 2000 through ADO connections with Visual C + +6.0. 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 tree-like view. Day-to-day 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 commodities of day-to-day management.
 
Keywords: Commodities, Commodities management system, Visual C++6.0 system development, Sql Server 2000
目錄
摘要 II
ABSTRACT II
目錄 III
第1章 引言 1
1.1 研究背景 1
1.2 研究?jī)?nèi)容 2
第2章 系統(tǒng)定義與開發(fā)工具 3
2.1系統(tǒng)定義 3
2.2 系統(tǒng)開發(fā)工具 3
 2.2.1 Visual C++6.0 3
 2.2.2 SQL Server 2000 4
 2.2.3 PowerDesigner12.5 4
第3章 系統(tǒng)分析與設(shè)計(jì) 5
3.1 系統(tǒng)需求分析 5
3.2 用戶需求數(shù)據(jù)流分析 6
3.3 系統(tǒng)功能結(jié)構(gòu)設(shè)計(jì) 9
第4章 數(shù)據(jù)庫(kù)分析與設(shè)計(jì) 10
4.1概念結(jié)構(gòu)設(shè)計(jì) 10
4.2邏輯結(jié)構(gòu)設(shè)計(jì) 12
第5章 商品信息管理系統(tǒng)詳細(xì)設(shè)計(jì)及實(shí)現(xiàn) 16
5.1 系統(tǒng)登錄及主界面設(shè)計(jì) 16
5.2各模塊詳細(xì)設(shè)計(jì)及實(shí)現(xiàn) 17
 5.2.1商品信息管理模塊 17
 5.2.2商品信息查詢模塊 20
 5.2.3商品信息管理模塊功能 22
 5.2.4商品入庫(kù)模塊 24
5.3系統(tǒng)維護(hù) 29
第6章 結(jié)束語(yǔ) 30
致謝 31
參考文獻(xiàn) 32