【正文】 2020 屆工業(yè)工程專(zhuān)業(yè)（工科）畢業(yè)設(shè)計(jì)（論文） I 自動(dòng)化立體倉(cāng)庫(kù)計(jì)算機(jī)倉(cāng)儲(chǔ)管理系統(tǒng)開(kāi)發(fā) 摘 要 自動(dòng)化立體倉(cāng)庫(kù)系統(tǒng)是現(xiàn)代物流自動(dòng)化系統(tǒng)的重要組成部分，隨著 企業(yè)信息化的 的發(fā)展，要求自動(dòng)化立體倉(cāng)庫(kù)能夠?qū)崟r(shí)接受任務(wù)信息，在高效率執(zhí)行任務(wù)的同時(shí)實(shí)時(shí)反饋任務(wù)完成信息，這就要求 企業(yè) 的管理層、監(jiān)控層以及控制層能夠協(xié)調(diào)高效地工作， 倉(cāng)庫(kù)管理系統(tǒng)對(duì)于企業(yè)來(lái)說(shuō)尤為重要 。 本文基于現(xiàn)代物流技術(shù)的應(yīng)用和發(fā)展要求，進(jìn)行自動(dòng)化立體倉(cāng)庫(kù)的計(jì)算機(jī)倉(cāng)儲(chǔ)管理系統(tǒng)的開(kāi)發(fā)。 首先，本文對(duì)自動(dòng)化立體倉(cāng)庫(kù)的構(gòu)成做了簡(jiǎn)單的介紹；然后，在研究現(xiàn)有的自動(dòng)化立體倉(cāng)庫(kù)的基礎(chǔ)之上，結(jié)合實(shí)際情況，規(guī)劃了 3 巷道風(fēng)動(dòng) 機(jī)械零部件立體倉(cāng)庫(kù)的倉(cāng)儲(chǔ)管理系統(tǒng)的功能，并研究了系統(tǒng)所涉及到相關(guān)實(shí)體間的關(guān)系，建立了實(shí)體 — 關(guān)系圖；最后，進(jìn)行了表與字段的分析和數(shù)據(jù)庫(kù)的創(chuàng)建 。并 利用 VB 編程語(yǔ)言和 Access 數(shù)據(jù)庫(kù)，經(jīng)過(guò)系統(tǒng)分析、數(shù)據(jù)庫(kù)設(shè)計(jì)、界面設(shè)計(jì)和系統(tǒng)功能設(shè)計(jì)等具體完成程序的編制。在管理系統(tǒng)中，實(shí)現(xiàn)了入庫(kù)管理，出庫(kù)管理，報(bào)廢管理，查詢管理，貨物統(tǒng)計(jì)，數(shù)據(jù)維護(hù)，用戶管理以及系統(tǒng)管理等功能 。 關(guān)鍵詞 ：自動(dòng)化立體倉(cāng)庫(kù)， VB 語(yǔ)言， Access 數(shù)據(jù)庫(kù)，管理系統(tǒng)，功能模塊設(shè)計(jì) 2020 屆工業(yè)工程專(zhuān)業(yè)（工科）畢業(yè)設(shè)計(jì)（論文） II Development of Computer Storage management System for Automated Warehouse ABSTRACT The automated warehouse system is an important part of the modern logistics automation systems. With the development of enterprise information technology, the automated warehouse is required to be able to accept the task information in real time, which requires monitoring layer and control layer to coordinate work efficiently. Thus warehouse management system for enterprises is particularly important. Based on the requirements of the application and development of modern logistics technology, this paper focuses on the development of the automated warehouse puter warehouse management system. Firstly, the position of the automated warehouse, a brief introduction。 Then, based on the study of existing automated warehouse, bined with the actual situation, planning a three tunnel wind mechanical parts warehouse with warehouse management system function。 next, investigation of the relationship between the related entities involved in the system, the establishment of the entity relationship diagram。 Finally, analysis of tables amp。 fields and database creation. Using VB programming language and the Access database, the program for the management system is prepared after system analysis, database design, interface design and system function design, in which, the functions of storage management, database management, scrap management, query management, cargo statistics, data maintenance, user management and system management have been implemented. KEY WORDS: Automated Warehouse System, Visual Basic, Access database, Management System, Function module design. 2020 屆工業(yè)工程專(zhuān)業(yè)（工科）畢業(yè)設(shè)計(jì)（論文） III 目 錄 第 1 章 緒論 ......................................................................................................... 1 自動(dòng)化立體倉(cāng)庫(kù)管理信息系統(tǒng)的研究背 景及意義 ................................ 1 自動(dòng)化立體倉(cāng)庫(kù)管理系統(tǒng)的基本內(nèi)容 .................................................... 1 自動(dòng)化立體倉(cāng)庫(kù)概要 ..................................................................... 2 管理信息系統(tǒng)基本概念 ................................................................. 4 自動(dòng)化立體倉(cāng)庫(kù)的研究狀態(tài) .................................................................... 7 國(guó)內(nèi)情況 ......................................................................................... 7 國(guó)外情況 ......................................................................................... 8 自動(dòng)化立體倉(cāng)庫(kù)的未來(lái)趨勢(shì) .................................................................... 8 本課題的研究?jī)?nèi)容 .................................................................................... 9 第 2 章 系統(tǒng)總體設(shè)計(jì) ............................................................................................11 系統(tǒng)功能需求分析 ...................................................................................11 系統(tǒng)功能模塊設(shè)計(jì) ...................................................................................11 倉(cāng)庫(kù)管理信息系統(tǒng)開(kāi)發(fā)環(huán)境簡(jiǎn)介 .......................................................... 15 中文 Visual Basic 簡(jiǎn)介 ........................................................... 15 Access2020 簡(jiǎn)介 ......................................................................... 16 系統(tǒng)目標(biāo)及思想設(shè) 計(jì) .............................................................................. 16 系統(tǒng)可行性分析 ...................................................................................... 17 本章小結(jié) .................................................................................................. 19 第 3 章 數(shù)據(jù)庫(kù)設(shè)計(jì) ............................................................................................... 20 數(shù)據(jù)庫(kù)需求分析 ...................................................................................... 21 數(shù)據(jù)庫(kù)概念結(jié)構(gòu)設(shè)計(jì) .............................................................................. 21 數(shù)據(jù)庫(kù)邏輯結(jié)構(gòu)設(shè)計(jì) .............................................................................. 25 數(shù)據(jù)庫(kù)的實(shí)現(xiàn) .......................................................................................... 26 本章小結(jié) .................................................................................................. 29 第 4 章 系統(tǒng)界面設(shè)計(jì) ........................................................................................... 30 創(chuàng)建工程項(xiàng)目 — 倉(cāng)庫(kù)管理系統(tǒng) .............................................................. 30 2020 屆工業(yè)工程專(zhuān)業(yè)（工科）畢業(yè)設(shè)計(jì)（論文） IV 系統(tǒng)運(yùn)行流程 .......................................................................................... 30 系統(tǒng)登陸界面設(shè)計(jì) .................................................................................. 31 系統(tǒng)主窗體設(shè)計(jì) ...................................................................................... 32 系統(tǒng)功能模塊窗體設(shè)計(jì) .......................................................................... 37 系統(tǒng)維護(hù)模塊窗體設(shè)計(jì) ............................................................... 37 日常業(yè)務(wù)模塊窗體設(shè)計(jì) ............................................................... 38 貨物統(tǒng)計(jì)模塊窗體設(shè)計(jì) ............................................................... 40 貨物查詢模塊窗體設(shè)計(jì) ............................................................... 41 數(shù)據(jù)維護(hù)模塊窗體設(shè)計(jì) ............................................................... 43 本章小結(jié) ..................................