初步分析了當(dāng)前業(yè)務(wù)公司管理方面存在的問題，聯(lián)系實(shí)際情況設(shè)計(jì)實(shí)現(xiàn)了一個(gè)以控制物流為主的管理軟件。該系統(tǒng)實(shí)現(xiàn)了部分ERP的功能，盡力做到降低實(shí)施成本，減少實(shí)施風(fēng)險(xiǎn) ，加快實(shí)施進(jìn)度 ，增加投資回報(bào)。
企業(yè)的物資供應(yīng)管理往往是很復(fù)雜，繁瑣的，由于掌握的物資種類眾多，訂貨，管理，發(fā)放的渠道各有差異，各個(gè)企業(yè)之間的管理體制不盡相同，各類統(tǒng)計(jì)計(jì)劃報(bào)表繁多，因此物資管理必須實(shí)現(xiàn)計(jì)算機(jī)化，而且必須根據(jù)企業(yè)的具體情況制定便提高工作效率。
根據(jù)當(dāng)前的企業(yè)管理體制，一般物資供應(yīng)管理系統(tǒng)，總是根據(jù)所掌握的物資類別，相應(yīng)分成幾個(gè)科室進(jìn)行物資的計(jì)劃，訂貨，核對(duì)入庫，根據(jù)企業(yè)各個(gè)部門的需要來發(fā)送物資設(shè)備，并隨時(shí)近期進(jìn)行庫存盤點(diǎn)，作臺(tái)帳，根據(jù)企業(yè)領(lǐng)導(dǎo)和自身管理的需要按月，季，年進(jìn)行統(tǒng)計(jì)分析，產(chǎn)生相應(yīng)報(bào)表，為了加強(qiáng)關(guān)鍵物資，設(shè)備的管理，要定期掌握其儲(chǔ)備消耗情況，根據(jù)計(jì)劃定額和實(shí)際消耗定額的比較，進(jìn)行定額管理。所以一個(gè)完整的企業(yè)物資供應(yīng)管理系統(tǒng)應(yīng)包括計(jì)劃管理，合同托收管理，倉庫管理，定額管理，統(tǒng)計(jì)管理，財(cái)務(wù)管理等到模塊。其中倉庫管理是整個(gè)物資供應(yīng)管理系統(tǒng)的核心。
使用Microsoft Visual Basic 6.0及Microsoft Office Access 2003作為開發(fā)工具，利用面向?qū)ο蟮慕Y(jié)構(gòu)和自上而下的程序設(shè)計(jì)方法，基本實(shí)現(xiàn)了倉庫的日常管理和進(jìn)貨出貨的查詢。

關(guān)鍵字：企業(yè)資源計(jì)劃，存貨，數(shù)據(jù)庫，面向?qū)ο?br>

Abstract
The first step analyzes the current business company to manage the problem of the aspect existence, contact actual circumstance the design carried out a take controling the logistics as lord of management software.That system carried out the function of parts of ERPs, making an effort to attain to lower the implement cost, reducing to carry out the risk, speeding implement degree of progress, increasing the investment repay.
The supplies supply management of the business enterprise is usually very complex, tedious, because the supplies category that control is numerous, order, manage, the outlet that issue is each to have the difference, the management system between each business enterprise does not fulfil same alike, each kind of covariance plan statement is numerous.
According to the current business enterprise management system, the general supplies supply management system, always according to the supplies category control, correspond to be divided into the plan that a few section rooms carry on the supplies, order, check to store in warehouse, according to the demand of the business enterprise each section to send out the supplies equipments, and at any time in the near future carry on the stock stocktaking, make the pedestal debt, according to the business enterprise leads to manage with oneself of demand is by the month, quarter, the year carry on statisticsing the analysis, the creation correspond the statement, for strengthenning the key supplies, the management of the equipments, want to periodically control it store the depletion circumstance, settling the sum according to the plan and consuming to settle the sum physically of comparison, carry on settling the sum to manage.So an integrity of the business enterprise supplies supply management the system should include the plan management, the contract collection management, warehouse management, settle sum management, statistics the management, finance management wait until the mold piece.Among them, the warehouse management is the core of the whole supplies supply management system.
Use the Microsoft Visual Basic 6.0 and the Microsoft Office Access 2003 conduct and actionses development tool, make use of the structure of face to the object and from top to bottom of program design method, basic carried out the usual management of the warehouse and enter the search of the goods shipment.

Keywords: ERP, Stock, Database, Face to the object

目 錄

摘 要 I
Abstract II
1 續(xù)言 1
2 系統(tǒng)分析
2.1 問題的提出 4
2.2 分析問題 4
2.3 系統(tǒng)設(shè)計(jì)目標(biāo) 5
2.3.1 系統(tǒng)設(shè)計(jì)的長遠(yuǎn)目標(biāo)：實(shí)現(xiàn)ERP系統(tǒng) 5
2.3.2 系統(tǒng)設(shè)計(jì)近期 6
3 系統(tǒng)總體設(shè)計(jì)
3.1 數(shù)據(jù)流圖 7
3.2 部分?jǐn)?shù)據(jù)字典 11
3.3 E-R圖 12
3.4 功能模塊 14
3.4.1 程序?qū)哟?14
3.4.2 模塊功能說明 15
3.4.3 系統(tǒng)數(shù)據(jù)表 15
4 系統(tǒng)詳細(xì)設(shè)計(jì) 17
5 編碼實(shí)現(xiàn)與測(cè)試
5.1 編碼摘要 21
5.2 程序界面 28
6 總結(jié)與展望
6.1 總結(jié) 34
6.2 心得體會(huì) 35
致 謝 37
參考文獻(xiàn) 38



1 續(xù)言
根據(jù)指導(dǎo)老師、公司和客戶的要求，本次畢業(yè)設(shè)計(jì)的題目是進(jìn)銷存管理系統(tǒng)，要求利用Visual Basic完成管理平臺(tái)設(shè)計(jì)，構(gòu)造所用的類庫；使用Access數(shù)據(jù)庫存儲(chǔ)數(shù)據(jù)，限單機(jī)使用。
企業(yè)的物資供應(yīng)管理往往是很復(fù)雜，繁瑣的，由于掌握的物資種類眾多，訂貨，管理，發(fā)放的渠道各有差異，各個(gè)企業(yè)之間的管理體制不盡相同，各類統(tǒng)計(jì)計(jì)劃報(bào)表繁多，因此物資管理必須實(shí)現(xiàn)計(jì)算機(jī)化，而且必須根據(jù)企業(yè)的具體情況制定便提高工作效率，
根據(jù)當(dāng)前的企業(yè)管理體制，一般物資供應(yīng)管理系統(tǒng)，總是根據(jù)所掌握的物資類別，相應(yīng)分成幾個(gè)科室進(jìn)行物資的計(jì)劃，訂貨，核對(duì)入庫，根據(jù)企業(yè)各個(gè)部門的需要來發(fā)送物資設(shè)備，并隨時(shí)近期進(jìn)行庫存盤點(diǎn)，作臺(tái)帳，根據(jù)企業(yè)領(lǐng)導(dǎo)和自身管理的需要按月，季，年進(jìn)行統(tǒng)計(jì)分析，產(chǎn)生相應(yīng)報(bào)表，為了加強(qiáng)關(guān)鍵物資，設(shè)備的管理，要定期掌握其儲(chǔ)備消耗情況，根據(jù)計(jì)劃定額和實(shí)際消耗定額的比較，進(jìn)行定額管理。
所以一個(gè)完整的企業(yè)物資供應(yīng)管理系統(tǒng)應(yīng)包括..