自动化立体仓库计算机仓储管理系统开发-论文

2012届工业工程专业（工科）毕业设计（论文）I自动化立体仓库计算机仓储管理系统开发摘要自动化立体仓库系统是现代物流自动化系统的重要组成部分，随着企业信息化的的发展，要求自动化立体仓库能够实时接受任务信息，在高效率执行任务的同时实时反馈任务完成信息，这就要求企业的管理层、监控层以及控制层能够协调高效地工作，仓库管理系统对于企业来说尤为重要。本文基于现代物流技术的应用和发展要求，进行自动化立体仓库的计算机仓储管理系统的开发。首先，本文对自动化立体仓库的构成做了简单的介绍；然后，在研究现有的自动化立体仓库的基础之上，结合实际情况，规划了3巷道风动机械零部件立体仓库的仓储管理系统的功能，并研究了系统所涉及到相关实体间的关系，建立了实体—关系图；最后，进行了表与字段的分析和数据库的创建。并利用VB编程语言和Access数据库，经过系统分析、数据库设计、界面设计和系统功能设计等具体完成程序的编制。在管理系统中，实现了入库管理，出库管理，报废管理，查询管理，货物统计，数据维护，用户管理以及系统管理等功能。关键词：自动化立体仓库，VB语言，Access数据库，管理系统，功能模块设计2012届工业工程专业（工科）毕业设计（论文）IIDevelopmentofComputerStoragemanagementSystemforAutomatedWarehouseABSTRACTTheautomatedwarehousesystemisanimportantpartofthemodernlogisticsautomationsystems.Withthedevelopmentofenterpriseinformationtechnology,theautomatedwarehouseisrequiredtobeabletoacceptthetaskinformationinrealtime,whichrequiresmonitoringlayerandcontrollayertocoordinateworkefficiently.Thuswarehousemanagementsystemforenterprisesisparticularlyimportant.Basedontherequirementsoftheapplicationanddevelopmentofmodernlogisticstechnology,thispaperfocusesonthedevelopmentoftheautomatedwarehousecomputerwarehousemanagementsystem.Firstly,thecompositionoftheautomatedwarehouse,abriefintroduction;Then,basedonthestudyofexistingautomatedwarehouse,combinedwiththeactualsituation,planningathreetunnelwindmechanicalpartswarehousewithwarehousemanagementsystemfunction;next,investigationoftherelationshipbetweentherelatedentitiesinvolvedinthesystem,theestablishmentoftheentity-relationshipdiagram;Finally,analysisoftables&fieldsanddatabasecreation.UsingVBprogramminglanguageandtheAccessdatabase,theprogramforthemanagementsystemispreparedaftersystemanalysis,databasedesign,interfacedesignandsystemfunctiondesign,inwhich,thefunctionsofstoragemanagement,databasemanagement,scrapmanagement,querymanagement,cargostatistics,datamaintenance,usermanagementandsystemmanagementhavebeenimplemented.KEYWORDS:AutomatedWarehouseSystem,VisualBasic,Accessdatabase,ManagementSystem,Functionmoduledesign.2012届工业工程专业（工科）毕业设计（论文）III目录第1章绪论.........................................................................................................11.1自动化立体仓库管理信息系统的研究背景及意义................................11.2自动化立体仓库管理系统的基本内容....................................................11.2.1自动化立体仓库概要.....................................................................21.2.2管理信息系统基本概念.................................................................41.3自动化立体仓库的研究状态....................................................................71.3.1国内情况.........................................................................................71.3.2国外情况.........................................................................................81.4自动化立体仓库的未来趋势....................................................................81.5本课题的研究内容....................................................................................9第2章系统总体设计...........................................................................................112.1系统功能需求分析..................................................................................112.2系统功能模块设计..................................................................................112.3仓库管理信息系统开发环境简介..........................................................152.3.1中文VisualBasic6.0简介...........................................................152.3.2Access2000简介.........................................................................162.4系统目标及思想设计..............................................................................162.5系统可行性分析......................................................................................172.6本章小结..................................................................................................19第3章数据库设计...............................................................................................203.1数据库需求分析......................................................................................213.2数据库概念结构设计..............................................................................213.3数据库逻辑结构设计..............................................................................253.4数据库的实现..........................................................................................263.5本章小结..................................................................................................29第4章系统界面设计...........................................................................................304.1创建工程项目—仓库管理系统..............................................................302012届工业工程专业（工科）毕业设计（论文）IV4.2系统运行流程..........................................................................................304.3系统登陆界面设计..................................................................................314.4系统主窗体设计......................................................................................324.5系统功能模块窗体设计..........................................................................374.5.1系统维护模块窗体设计...............................................................374.5.2日常业务模块窗体设计.............................