【摘 要】倉庫庫存管理系統(tǒng)是一個企業(yè)不可缺少的部分,它的內(nèi)容對于企業(yè)的決策者和管理者來說都至關(guān)重要,所以倉庫庫存管理系統(tǒng)應(yīng)該能夠為用戶提供充足的信息和快捷的查詢手段。但一直以來人們使用傳統(tǒng)人工的方式管理倉庫中的各種物資設(shè)備，這種管理方式存在著許多缺點,如:效率低、另外時間一長,將產(chǎn)生大量的文件和數(shù)據(jù),這對于查找、更新和維護都帶來了不少的困難。
隨著科學(xué)技術(shù)的不斷提高,計算機科學(xué)日漸成熟,其強大的功能已為人們深刻認(rèn)識,它已進(jìn)入人類社會的各個領(lǐng)域并發(fā)揮著越來越重要的作用。
作為計算機應(yīng)用的一部分,使用計算機對物資信息進(jìn)行管理,具有著手工管理所無法比擬的優(yōu)點.例如:檢索迅速、查找方便、可靠性高、存儲量大、保密性好、壽命長、成本低等。這些優(yōu)點能夠極大地提高人事勞資管理的效率,也是企業(yè)的科學(xué)化、正規(guī)化管理,與世界接軌的重要條件。
因此，開發(fā)這樣一套庫存管理軟件成為很有必要的事情。

【關(guān)鍵詞】 倉庫管理 信息管理 數(shù)據(jù)庫 VC++ 產(chǎn)品管理















Storage Management System Design and Realization
【Abstract】The warehouse stock management system is an enterprise essential part, its content regards enterprise's policy-maker and the superintendent is all very important, therefore the warehouse stock management system should be able to provide the sufficient information and the quick inquiry method for the user. But people have since always used the traditional artificial way to manage in the warehouse each kind of commodity equipment, this management way has many shortcomings, for example: Low efficiency, besides taking long time, will produce the massive documents and the data, as to the search, the renewal and the maintenance has all brought much trouble.
Along with the science and technology unceasing enhancement, the computer science is mature day after day, its formidable function has known profoundly for people, which entered the each domain human society and is playing the more and more vital role.
As a computer application part, using the computer to carry on the management for the commodity information is having the merit which the manual administration center is unable to compare. For example: Retrieves, the rapidly convenient search, the high reliability, the big reserves, the good secrecy, the long life, the low cost status. These merits can enhance the human labor affairs management enormous the efficiency, also the enterprise's scientific style, the standardized management, with world trail important connection condition.
Therefore, developing such the management software of this set of stock becomes having a profound necessary affair very much.

【Keywords】Storage Management System Information Management Database VC++ Production Management


目 錄
引 言 1
第一章 課題背景 2
1.1 管理信息系統(tǒng)的概述 2
1.2 倉庫管理系統(tǒng)開發(fā)的目的 2
1.3 倉庫管理系統(tǒng)發(fā)展現(xiàn)狀 3
第二章 系統(tǒng)開發(fā)工具簡介 4
2.1 VISUAL C++簡介 4
2.2 SQL語言基礎(chǔ) 5
2.3 數(shù)據(jù)庫技術(shù)簡介 7
第三章 倉庫管理系統(tǒng)需求分析及總體設(shè)計 10
3.1 功能需求 10
3.2 開發(fā)背景 10
3.3系統(tǒng)功能描述 11
3.4 系統(tǒng)功能模型 13
3.5 系統(tǒng)的E-R圖 14
3.6系統(tǒng)流程 15
3.7 系統(tǒng)用例圖 15
3.8系統(tǒng)總界面設(shè)計....................................................16
第四章 產(chǎn)品信息管理模塊的設(shè)計與實現(xiàn) 18
4.1 產(chǎn)品信息管理模塊結(jié)構(gòu) 18
4.2 相關(guān)數(shù)據(jù)庫表的設(shè)計 18
4.3 產(chǎn)品類別管理的實現(xiàn) 19
4.4 產(chǎn)品信息管理的實現(xiàn) 20
第五章 庫存操作管理模塊的設(shè)計與實現(xiàn) 23
5.1 庫存操作管理模塊結(jié)構(gòu) 23
5.2 相關(guān)數(shù)據(jù)庫表的設(shè)計 23
5.3入庫操作管理的實現(xiàn) 25
5.4 出庫操作管理的實現(xiàn) 27
5.5 庫存盤點管理的實現(xiàn) 29
結(jié) 論 31
致 謝 32
參考文獻(xiàn) 33
附錄Ⅰ：數(shù)據(jù)庫表結(jié)構(gòu)以及建表語句 34
附錄Ⅱ：倉庫管理系統(tǒng)部分程序代碼 42