摘 要
伴隨著企業(yè)規(guī)模的不斷擴(kuò)大，原始和手工的進(jìn)行管理工作已經(jīng)不能適應(yīng)工業(yè)企業(yè)發(fā)展的現(xiàn)狀，更無(wú)法滿足企業(yè)對(duì)管理工作的快速、準(zhǔn)確的要求。而計(jì)算機(jī)信息管理技術(shù)的迅速發(fā)展恰恰解決了這個(gè)問(wèn)題，它使計(jì)算機(jī)技術(shù)與現(xiàn)代的管理技術(shù)相互配合，更加準(zhǔn)確、高速的完成工業(yè)企業(yè)日常的倉(cāng)庫(kù)管理工作。使企業(yè)能夠以最少的人員來(lái)完成更多的工作。
本倉(cāng)庫(kù)管理系統(tǒng)實(shí)現(xiàn)倉(cāng)庫(kù)管理的自動(dòng)化，是針對(duì)企業(yè)倉(cāng)庫(kù)材料的出入庫(kù)登記和查詢統(tǒng)計(jì)等方面工作而開(kāi)發(fā)的管理軟件，是一個(gè)實(shí)用的管理信息系統(tǒng)，針對(duì)企業(yè)的實(shí)際需要，分析了企業(yè)倉(cāng)庫(kù)管理系統(tǒng)的功能，并以入庫(kù)管理和出庫(kù)管理為重點(diǎn)，描述了模塊結(jié)構(gòu)設(shè)計(jì)及實(shí)施過(guò)程中的技術(shù)要點(diǎn)，實(shí)現(xiàn)倉(cāng)庫(kù)的材料管理、出入庫(kù)管理、查詢管理及用戶管理等功能。用戶可以通過(guò)相應(yīng)的模塊，對(duì)倉(cāng)庫(kù)里的材料的基本情況進(jìn)行更新、刪除和查詢，對(duì)產(chǎn)品的出庫(kù)和入庫(kù)進(jìn)行管理，對(duì)出入庫(kù)明細(xì)進(jìn)行查詢，對(duì)使用該系統(tǒng)的用戶進(jìn)行更新、刪除和查詢，對(duì)庫(kù)存數(shù)量進(jìn)行查詢，還有操作員管理、權(quán)限設(shè)置、密碼修改、數(shù)據(jù)備份與系統(tǒng)恢復(fù)等其他系統(tǒng)管理功能。系統(tǒng)采用Microsoft Office中的Access 2000來(lái)設(shè)計(jì)數(shù)據(jù)庫(kù)，并使用當(dāng)前優(yōu)秀的開(kāi)發(fā)工具—Delphi。
本系統(tǒng)的特點(diǎn)是功能齊全，包括入庫(kù)、出庫(kù)、調(diào)庫(kù)、借出、歸還等信息管理，操作員、供貨商和客戶檔案信息詳細(xì)，適合一般企業(yè)的倉(cāng)庫(kù)信息管理。

關(guān)鍵詞：倉(cāng)庫(kù)管理系統(tǒng)；Delphi；數(shù)據(jù)庫(kù)；庫(kù)存

Abstract
Accompanied by continued expansion of the scale enterprises, the original, hand in the management of industrial enterprises have been unable development status, but can not meet the enterprise management of rapid and accurate request. And the rapid development of computer information management technology is solving the problem, and it makes computer technology and modern management techniques complementary to more accurate and rapid completion of routine industrial enterprises warehouse management. At least to enable enterprises to more personnel to complete the work.
The warehouse management system to achieve storage management automation, is aimed at enterprise storage material put in storage for registration and referral statistics of the work of the management software is a practical management information system, in response to the actual needs of the enterprise, business analysis warehouse management system functionality, and to put in storage management and a focus on the management, describes the design and implementation of modular structure of the technical elements of warehouse materials management, out put in storage management, information management and user management functions.Users can adopt the corresponding module for the warehouses of the basic materials of updating, deleting and enquiries on materials from the management and put in storage, put in storage for a detailed inquiries, and on the use of the system for users to update, delete and enquiries, a number of stock enquiries, and operator management, the establishment of competence, password changes, data backup and recovery systems, and other system management functions. System using Microsoft Office Access 2000 to design the database and development tool using the current outstanding Delphi.
This system characteristic is the function complete, including goes into storage, the storehouse, the accent storehouse, loans, returns and so on the information management, the operator, supplies goods business and the customer file information is detailed, suits the common enterprise the warehouse information management

Key words：Warehouse management system; delphi ;database; stock
目 錄
第1章 緒 論 1
1.1 開(kāi)發(fā)背景介紹 1
1.2 開(kāi)發(fā)環(huán)境介紹 2
第2章 可行性分析 6
2.1 技術(shù)可行性 6
2.2 經(jīng)濟(jì)可行性 6
2.3 操作可行性 7
第3章 需求分析 8
3.1 功能需求 8
3.2 性能需求 8
3.3 數(shù)據(jù)需求 9
3.4 數(shù)據(jù)流圖 9
3.5 數(shù)據(jù)字典 11
第4章 系統(tǒng)總體設(shè)計(jì) 14
4.1 模塊設(shè)計(jì) 14
4.2 數(shù)據(jù)庫(kù)設(shè)計(jì) 17
4.2.1 概念結(jié)構(gòu)設(shè)計(jì) 18
4.2.2 邏輯結(jié)構(gòu)設(shè)計(jì) 22
4.2.3 物理結(jié)構(gòu)設(shè)計(jì) 25
第5章 系統(tǒng)詳細(xì)設(shè)計(jì) 26
5.1 函數(shù)設(shè)計(jì) 26
5.1.1 GetAllUser函數(shù) 26
5.1.2 DBConnection函數(shù) 26
5.1.3 GetPWDConnect函數(shù) 26
5.1.4 GetAllRecord函數(shù) 27
5.1.5 GetChangePwd函數(shù) 27
5.1.6 UpdateKc函數(shù) 27
5.1.7 Sjbf函數(shù) 27
5.1.8 Sjhf函數(shù) 27
5.1.9 UpdateLog函數(shù) 28
5.2 字符串資源設(shè)計(jì) 28
5.3 界面設(shè)計(jì) 29
5.3.1 登錄界面 29
5.3.2 修改密碼界面 32
5.3.3 操作員檔案管理界面 33
5.3.4 供貨商檔案管理界面 33
5.3.5 計(jì)量單位設(shè)置界面 34
5.3.6 倉(cāng)庫(kù)類別設(shè)置界面 35
5.3.7 入庫(kù)管理界面 35
5.3.8 借出管理界面 36
5.3.9 庫(kù)存查詢界面 37
5.3.10 萬(wàn)能查詢界面 38
5.3.11 庫(kù)存初始設(shè)置界面 40
5.3.12 系統(tǒng)日志界面 40
5.3.13 重新登錄界面 42
第6章 系統(tǒng)測(cè)試 44
6.1 軟件測(cè)試概述 44
6.2 系統(tǒng)的具體測(cè)試 45
第7章 結(jié) 論 47
參考文獻(xiàn) 48
致 謝 49
附 錄 50

參考文獻(xiàn)
[1] 張累.Delphi應(yīng)用與開(kāi)發(fā)按理教程.北京:清華大學(xué)出版社,2005
[2] 劉毅.Delphi程序設(shè)計(jì)教程.北京:科學(xué)出版社,2004
[3] 劉斌，李文革.Delphi 7數(shù)據(jù)庫(kù)高級(jí)教程.北京:清華大學(xué)出版社,2004
[4] 彭文明.Delphi管理信息系統(tǒng)項(xiàng)目開(kāi)發(fā)實(shí)踐.北京:北京科學(xué)出版社,2005
[5] 求是科技.Delphi數(shù)據(jù)庫(kù)開(kāi)發(fā)技術(shù)與工程實(shí)踐.北京:人民郵電出版社,2004
[6] 何光明.Delphi實(shí)用培訓(xùn)教程.北京:人民郵電出版社,2003
[7] 鄭阿齊.Delphi..