仓库管理系统的设计与实现论文

II摘要随着计算机技术的飞速发展，计算机在企业管理中应用的普及，利用计算机实现管理企业势在必行。而仓库管理系统是典型的信息管理系统，其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面。对前者要求建立起数据一致性和完整性强、数据安全性好的库。而对于后者则要求应用程序功能完备，易使用等特点。本文通过分析浏览器/服务器结构的特点并结合企业仓储管理的实际情况，提出了基于B/S结构中小型企业仓库管理系统的基本设计思想，简要介绍了系统各功能模块及数据库的设计，着重讨论了用ASP.NET技术和SQLServer2005开发企业仓库管理系统时的数据库访问技术和动态网页制作技术,并给出了部分实现代码。通过该系统，使学生可以方便地在企业内部网上进行仓储管理。该B/S结构的系统在WindowsXP系统和VS.NET平台下开发完成，使用C＃作为ASP.NET的开发语言，SQLServer2005作为后台数据库，该数据库系统在安全性、准确性、运行速度方面均有绝对的优势，并且能够对容量较大的数据库进行处理，效率高。系统有较高的安全性和较好的性能。其中连接数据库的字符串可以随时在Web.Config里修改，增加了灵活性和安全性。代码尽量减少数据库连接的打开时间等手段来提高性能。本文中除了有对程序的系统分析、总体设计、数据库设计、功能实现等主体部分外，在这之前还介绍了与企业仓库管理系统相关的信息、VS.NET与SQL的无缝链接技术等。关键词仓库管理；信息管理系统；B/S结构；数据库管理IIIIAbstractWithrapidadvancementofcomputertechnologyandwidelyappliedincorporationmanagement,itisimperativetoutilizeittorealizeEnterpriseadministration.WarehouseManagementSystemisoneoftypicalManagementInformationSystem,whoseexploitationsmainlyincludeestablishmentandmaintenanceofbackstagedatabaseaswellasfrontapplicationprogrammer.Fortheformer,itisrequiredtosetupunited,completeandhigh-secureddatabase,while,forthelatter,completefunctionsofapplicationprogrammerandsimpleoperation.ThisthesispointsoutbasictheoryofWarehouseManagementSystembasedonexplorerandserver/organizationinsmall-to-medium-sizedenterprises,analyzingcharacteristicsofB/SandrelatingtorealitiesofsituationofWarehouseManagementSystem.ItintroducesdesignofeveryfunctionalgroupanddatabasebrieflyandfocusesondiscussionconcerningtoexploitdatabaseaccesstechnologyanddynamicwebdesignneededforWarehouseManagementSysteminlightofASP.NETtechnologyandSQLServer2005.Italsopresentspartsofimplementationcodes,helpingstudentstooperateWarehouseManagementincorporationlocalsite.ThisB/SsystemwasexploitedontheplatformofWindowsXPandVS.NET,usingC#asASP.NETexploitationlanguage,SQLServer2005asbackstagedatabase,whichpossessesadvantagesinsecurity,precision,speed,etc.andcandealwithdatabaseswithhighcapacityefficiently.Thecharacterconnectingdatabasescanbealteredanytime,whichraisesflexibilityandsecurity,codesreducingthetimetoopendatabaseconnection.Inthisdissertation,besidessystemanalysis,overalldesign,databasedesign,functionalrealities,etc,informationrelatedtoWarehouseManagementSystem,seamlessconnectiontechnologyofVS.NETandSQLarealsointroduced.KeywordsWarehouseManagementManagementInformationSystemB/SStructureDatabaseManagementIIIIII目录目录摘要.........................................................IAbstract........................................................II第1章绪论..................................................11.1课题背景.......................................................................................................11.2课题目的和意义...........................................................................................11.3开发设计思想...............................................................................................21.4主要工作和论文结构...................................................................................2第2章系统开发工具与开发平台................................32.1开发平台和技术介绍....................................................................................32.1.1IIS简介...................................................................................................32.1.4ASP.NET开发环境.............................................................................42.2C#编程语言...................................................................................................42.3SQLServer2005数据库................................................................................52.4系统运行环境................................................................................................7第3章系统需求分析..........................................83.1可行性分析...................................................................................................83.1.1可行性研究............................................................................................83.1.2可行性分析............................................................................................83.1.3系统业务流程分析..............................................................................103.1.4系统数据流分析..................................................................................113.1.5数据字典分析......................................................................................123.2本章小结.....................................................................................................14第4章系统总体设计.........................................154.1系统模块总体设计.....................................................................................154.2数据库结构设计.........................................................................................15IVIV4.2.1数据库逻辑结构设计..........................................................................154.2.2数据库结构设计表..............................................................................16第5章系统详细设计.........................................195.1管理主界面实现.........................................................................................195.2退货模块设计.................................................