13101401_陈聪聪_基于物联网的仓库管理系统的设计与实现

摘要摘要在21世纪的今天，时间就是生产力，提高效率就会为企业节约大量的成本。在信息化社会的大背景下，似乎没有什么能够比用计算机实现信息自动化管理更方便快捷的了。如今随着仓库规模的日益壮大，管理者所需要处理的数据量也越来越大，仅仅依靠传统的操作方式已经不能满足客户对于效率的需求。同时由于假冒伪劣产品的大量出现以及食品安全等问题的加剧，采用传统的一些方法很难对市场上的商品进行甄别，而RFID技术却可以利用追踪溯源的方法很有效的解决上述问题，本系统正是结合了RFID技术与仓库管理系统二者的优点，使得本系统能够得到较为广泛的应用。基于物联网的仓库管理系统以MicrosoftSqlServer2008作为后台数据库，采用C#程序设计语言和WinForm平台进行开发。同时充分借用了VisualStudio2010开发工具的强大功能。系统的主要功能包括：生产、BOM管理、原料入库、产品出库、库存查询、商品信息、数据字典、业务报表等功能。关键字：仓库管理RFIDC#WinForm摘要ABSTRACTABSTRACTInthe21stcentury,thetimeisproductivity,improveefficiencywillbesignificantcostsavingsforbusinesses.Inthecontextoftheinformationsociety,itseemsthatnothingcouldbemoreconvenientthanusingacomputertoachieveautomatedmanagementinformation.Nowwiththegrowingsizeofthewarehouse,managersneedtohandletheamountofdataisalsogrowing,relyingsolelyonthetraditionalmodeofoperationhasbeenunabletomeetcustomerdemandforefficiency.Atthesametimeduetothelargeincreaseoccursandfoodsafetyissuessuchasfakeandshoddyproducts,theuseofsometraditionalmethodsaredifficulttobescreenedonthecommoditymarkets,buttheycanuseRFIDtechnologytotracktraceablemethodisveryeffectivetosolvetheaboveproblems,thepresentsystemItcombinestheadvantagesofRFIDtechnologyandwarehousemanagementsystemsofthetwo,makingthesystemcanbemorewidelyused.ThingsbasedwarehousemanagementsystemtoMicrosoftSqlServer2008asback-enddatabase,usingtheC#programminglanguageandWinFormplatformfordevelopment.WhilefullyborrowedtheVisualStudio2010developmenttoolsandpowerful.Themainfeaturesofthesysteminclude:thefunctionofproduction,BOMmanagement,rawmaterialstorage,productwarehousing,inventoryinquiries,productinformation,datadictionary,businessreportsandsoon.Keywords:warehousemanagementRFIDC#WinFormABSTRACT目录i目录第一章绪论...................................................................................................................11.1课题背景.............................................................................................................11.2课题目的和意义.................................................................................................11.3主要工作和论文结构.........................................................................................2第二章相关理论与工具.................................................................................................52.1RFID技术............................................................................................................52.2.NETFramework..................................................................................................62.3C#编程语言.........................................................................................................72.4SQLServer2008数据库....................................................................................72.5系统运行环境.....................................................................................................92.6本章小结.............................................................................................................9第三章系统需求分析...................................................................................................113.1可行性分析.......................................................................................................113.1.1可行性研究.............................................................................................113.1.2可行性分析.............................................................................................123.2需求分析...........................................................................................................123.2.1系统业务流程分析.................................................................................133.2.2系统数据流分析.....................................................................................143.2.3数据字典分析.........................................................................................153.3本章小结...........................................................................................................18第四章系统概要设计...................................................................................................194.1系统总体设计...................................................................................................194.2数据库结构设计...............................................................................................214.2.1数据库逻辑结构设计.............................................................................214.2.2数据库结构设计表.................................................................................214.3本章小结...........................................................................................................24第五章系统详细设计与实现.......................................................................................25ii目录5.1模块列表...........................................................................................................255.2Winform开发框架架构视图............................................................................265.3界面设计...........................................................................................................285.3.1经典模式界面设计....................................