物资采购管理系统的设计与实施

2012年度专业硕士学位论文学号：511500185监狱物资采购管理系统的设计与实施院系：软件学院类别：工程硕士姓名：巫立忠班级：11春学号：4600005001852011年3月完成I摘要一直以来，监狱中各种日常用品的采购都是采用人工记录统计，即使是使用计算机管理，也只是使用简单的EXCEL报表进行最基本的入库，出库记录，为此花费大量的人力、物力。随着计算机应用的发展，信息系统的管理已不再靠人工进行处理，人工数据处理只能提供定期的报表，已经难以根据需要，提供各种综合分析的数据，使得监狱日常用品等采购的管理常常只能根据经验做出决定，带有一定的盲目性，这种管理方式是一种低水平的运作，会造成大量的浪费。而如果通过计算机系统将数据组织起来，就可以随时提供所需的数据，保证决策的更加正确、及时；再者通过计算机可以规划监狱日常用品的采购管理,为数据处理提供明确的尺度，使之标准化、规范化；此外还最大限度地可以节省人力，提高工作效率。本文介绍了一个解决当今监狱采购活动的低效益的软件，即监狱物资采购管理系统。与一般采购系统相比，拥有以用户为开发中心，易于操作和理解等特点。该系统有查询物资、生成采购单、管理库存、数据统计等功能。本文将详细该系统的需求分析系统结构，功能模块划分以及数据库模式分析等，以及对应用程序的实际开发实现作了介绍。该软件达到了数据的一致性和安全性，且应用程序功能完备，符合了当今监狱物资采购管理的需求。关键字：监狱物资采购，管理系统，设计，实现IIAbstractEversince,PrisonProcurementisorganizedbyhandinChina.Thereissomeexceptionthat,mighthandledoncomputerbasis.However,mostofthemarestillwithMicrosoftexcelformat.It’sobviouslabor-wasted¬effective.Alongwiththedevelopmentofcomputerapplication,thereisnoneedtomanageofinformationsystembyreallaborontheirown.Informationdatawhichismanagedbyhuman-inputcanonlyofferreportsperiodically.It’shardtoofferdiversifiedanalyticaldatawhichisinneed.Itcomestoresultthat,decisiontobemadewithpersonalneedpurposeonprisonprocurementbyprisonadministration.Dogoodspurchasedcouldreallyfulfillprisonrequired?Isiteffective?Fromlongtermofpastdecades,it’sprovedthatpreviousprocurementmethodofprisonmanagementishigh-wastedprocedure,usingmodernizedandmotivatemethodisanacquiredneed.So,weshouldorganizeprocurementdatathroughcomputersystemwhichcananalyzedataandrealrequirement&solutionweneedmomentarily,correctlyandtimely.Withthestandardizedcomputersystem,wecanmanageofdailyprocurementofprisoneasilyandtrendy;What’smore,itcansavemanpowerandimproveworkingefficiency.ThisarticleintroducesaadministrativesystemwhichcansolvetheproblemofdailypurchasinginChineseprisonwithgreatefficiency.Comparewithausualpurchasingsystem,thePrisonMaterialPurchasingManagementSystemhasitsowncharacter.Suchasitisdevelopedcenteroncustomer,itiseasyforcustomertocontrolandunderstand.Andthecustsomercouldserchgoods,createastockorder,managestorage,Statisticaldatathroughthesystem.Thearticlemainlyrepresentonseveralperspectives,e.g.systemstructureofrequirementanalysis,partitioningoffunctionmodule,analysisofdata-basedmodule,andsoon.Itfulfillsneedstosolveactualexploitationofapplicationprocedure.Theadvantageofapplyingthissystemis,easilykeepingdatacontingencyaccordinglyandsafely.IIIKeyword:Prisonmaterialpurchasing,MangementSystem,Disign,ImplementIV目录第1章绪论....................................................................................................................................11.1前言...................................................................................................................................11.2国内外研究现状...............................................................................................................11.3研究的意义.......................................................................................................................21.4本文结构...........................................................................................................................4第2章理论基础.............................................................................................................................52.1SQL语言介绍......................................................................................................................52.2VB编程语言介绍................................................................................................................62.3数据库理论介绍...............................................................................................................92.4Access2000简述..........................................................................................................10第3章监狱采购系统需求分析...................................................................................................123.1总体要求..........................................................................................................................123.2业务流程图......................................................................................................................123.3各模块的需求分析..........................................................................................................133.4环境需求分析..................................................................................................................163.5技术需求分析..................................................................................................................163.6可用性需求分析..............................................................................................................16第4章监狱物资采购系统设计...................................................................................................174.1功能结构..........................................................................................................................174.2各模块功能介绍与设计..................................................................................................194.2.1资料管理模块......................................................