商品庫存管理系統(tǒng)的設(shè)計

1萬字
自己原創(chuàng)的畢業(yè)設(shè)計，今年最新的，僅在本站獨(dú)家提交，大家放心使用

摘要 傳統(tǒng)的人工管理方式工作效率低，自動化程度差，由于管理人員的工作疏忽以及管理質(zhì)量問題所造成的各種錯誤常常發(fā)生。所以為了實(shí)現(xiàn)商品管理的系統(tǒng)化、規(guī)范化和自動化，提高企業(yè)管理效率而建立一個商品庫存管理系統(tǒng)是十分有必要的。
本文采用面向?qū)ο蟪绦蛟O(shè)計方法和軟件工程的設(shè)計原則，來分析、設(shè)計并實(shí)現(xiàn)一個簡單的商品庫存管理系統(tǒng)。首先，研究了課題所需的技術(shù)和開發(fā)工具，包括Basic語言和Visual Basic集成開發(fā)環(huán)境，以及數(shù)據(jù)庫技術(shù)和ACCESS2000數(shù)據(jù)庫系統(tǒng)。然后，對該商品庫存管理系統(tǒng)進(jìn)行需求分析并進(jìn)行總體設(shè)計，將整個系統(tǒng)分為基本資料模塊、倉庫管理模塊、倉庫查詢模塊和系統(tǒng)設(shè)置模塊這四個子模塊，并對這四個模塊分別進(jìn)行了詳細(xì)的設(shè)計，給出了模塊的功能流程圖，并建立完整的數(shù)據(jù)庫表。接著，依據(jù)上述設(shè)計分別實(shí)現(xiàn)了用戶登錄、采購入庫、采購出庫和用戶管理功能的代碼。本系統(tǒng)的設(shè)計核心是采購入庫，采購出庫和庫存三者的聯(lián)系。當(dāng)采購出庫或入庫時，倉庫庫存會隨時更新庫存量。
最后，對所實(shí)現(xiàn)的商品庫存管理系統(tǒng)進(jìn)行完整的運(yùn)行與驗(yàn)證，運(yùn)行結(jié)果表明系統(tǒng)能正確運(yùn)行，且可靠地實(shí)現(xiàn)了預(yù)期的功能。本課題所設(shè)計的商品庫存管理系統(tǒng)可以為小型企業(yè)提供界面簡潔、易于維護(hù)且高效的商品庫存管理。

關(guān)鍵字 ：庫存 信息管理系統(tǒng) Visual Basic Access 2000

Design of a Products Storage Management System

Abstract Traditional way of artificial management work efficiency is low, automation degree is poor, and all kinds of errors often occur because of managers job oversight and management quality problem.So in order to achieve the commodity management systematization, standardization and automation, improve the efficiency of enterprise management and establish a commodity inventory management system is very necessary.
This paper adopts the object-oriented program design method and the design principles of software engineering, to the analysis, design and implement a simple commodity inventory management system. First of all, to study the subject needed technology and development tools, including the Basic language and the Visual Basic integrated development environment, and database technology and ACCESS2000 database system. Then, for the goods inventory management system requirements analysis and general design, the system can be divided into basic information module, the warehouse management module, query module and system Settings module the four modules, and the four modules separately carried on the detailed design, shows the flow chart of the function of the module, and to establish a complete database tables. Then, on the basis of the above design respectively to realize the user login, purchase inventory, purchasing dispatch and user management functions of the code. The design of the core of the system are purchasing warehousing, purchasing and inventory of the three links. When purchasing outbound or inbound warehouse will update the inventory.
Finally,to run the complete and validation the implementation of inventory management system , operation results show that the system can run correctly, and reliably realize the expected function. This topic designed by commodity inventory management system can provide small businesses with interface is simple and easy to implement, maintain and efficient inventory management.

Key word: inventory Information management system Visual Basic Access 2000

目 錄
第一章 概述 1
1.1課題背景 1
1.2 現(xiàn)有研究現(xiàn)狀 1
1.3論文內(nèi)容與組織 2
第二章 商品庫存管理系統(tǒng)開發(fā)相關(guān)技術(shù) 3
2.1Basic語言的基本特點(diǎn) 3
2.2 Visual Basic程序的特點(diǎn) 3
2.3數(shù)據(jù)庫技術(shù)簡介 4
2.4 Access 數(shù)據(jù)庫的特點(diǎn) 4
第三章 商品庫存管理系統(tǒng)的分析與設(shè)計 6
3.1功能需求分析 6
3.2系統(tǒng)總體設(shè)計 6
3.3基本資料模塊設(shè)計 7
3.4倉庫管理模塊設(shè)計 8
3.5倉庫查詢模塊設(shè)計 11
3.6系統(tǒng)設(shè)置模塊設(shè)計 11
3.7數(shù)據(jù)庫設(shè)計 12
第四章 商品庫存管理系統(tǒng)的實(shí)現(xiàn) 15
4.1登陸子模塊的實(shí)現(xiàn) 15
4.2采購入庫模塊的實(shí)現(xiàn) 16
4.3采購?fù)藥炷K的實(shí)現(xiàn) 17
4.4倉庫查詢模塊的實(shí)現(xiàn) 18
4.5系統(tǒng)設(shè)置子模塊的實(shí)現(xiàn) 20
第五章 商品庫存管理系統(tǒng)的運(yùn)行 24
5.1用戶登錄模塊測試 24
5.2基礎(chǔ)資料模塊測試 25
5.3倉庫管理模塊測試 25
5.4倉庫查詢模塊測試 26
5.5系統(tǒng)設(shè)置模塊測試 26
第六章 總結(jié)與展望 28
6.1 總結(jié) 28
6.2 展望 29
致 謝 30
參考文獻(xiàn) 31