生产管理系统

辽宁科技大学毕业设计（论文）第I页生产管理系统摘要生产部门如果没有专业化管理的工具，都会受到如周期、库存、人力、发货、废品、引入新产品和满足客户要求等问题的困扰。如果没有一个有效的计划，生产部门对以上这些问题以及其他一些类似的问题是很难回答的。由于缺乏公认的专业工具和知识体系以及其有效系统，也很难准确的衡量生产部门的工作业绩。由此可见，生产管理系统的引入迫在眉睫。在应用生产管理系统的环境下，在制定销售与运作规划时先要通过资源计划来估算为生产一定数量的某类产品所需的资源，以保证销售与运作规划的合理性。生产信息管理系统是一套集生产物料、订单、生产领料、产品入库、质量检验于一体的完整信息系统框架。根据实际情况前台程序开发采用VISUALBASIC6.0完成，后台数据库建设本系统采用SQLSERVER2000完成。系统实现了生产一系列基本信息的设置、生产计划单的管理、生产物料与生产领料的入库、生产完工产品的入库和常用工具的快速打开，并且能够根据实际需要进行查询和打印功能。当用户以不同的权限登录时具有不同的操作，操作员可以随时修改自己的口令，管理员可以设置操作员的权限。关键词管理系统；生产；数据库辽宁科技大学毕业设计（论文）第II页AbstractIftheproductiondepartmentdoesnothavethespecializedtoolformanagement,itwillpuzzledbyquestionsuchascycle,stock,manpower,shipping,wasteproduct,introductionofthenewproductandsatisfactionofcustomerrequestandsoon.Ifitdoesnothaveaneffectiveplan,theproductiondepartmentisverydifficulttoreplytoallabovethesequestionsandallthatsomesimilarquestions.Forthelackofauthorizedspecialtyinstrumentandknowledgehierarchiesaswellaseffectivesystem,itisalsoverydifficulttoweighttheworkachievementofproductiondepartmentaccurately.Fromhereweseethattheproductionmanagementsystem’sintroductionisimminent.Intheapplicationofproductionmanagementsystem,atthetimeofestablishsalesandoperationalplanning,weshouldestimaterequiredresourceforproducinganykindofcertainlyproductaccordingtoresourceplanningtoensurerationalityofestablishsalesandoperationalplanning.Theproductioninformationmanagementsystemisacompleteinformationsystemframe,whichisasetofmanufacturingsupplies,orderform,gettingthematerialinproduction;theproductgoesintostorage,thequalityinspection.Accordingtotheactualsituation,usesVISUALBASIC6.0tocompletethedevelopmentofonstageprocedure,theconstructionofbackstagedatabasesystemuseSQLSERVER2000tocomplete.Theproductionsystemtoachieveaseriesofbasicinformationsettings,themanagement-productionplanning,productionofmaterialsandproductionmaterialsfromthestorage,productionandstorageofthecompletedproductscommonlyusedtoolfortherapidopen,accordingtoactualneedsandcanqueryandprintFunction.Whenusersloginwithadifferentauthorityatadifferentoperation,operatorscanmodifytheirownpasswords,theadministratorcansetupthecompetenceoftheoperators.KeywordsManagementsystem；Production；Database辽宁科技大学毕业设计（论文）第III页目录摘要........................................................................................................................................IAbstract.................................................................................................................................II第1章绪论.........................................................................................................................11.1应用背景..................................................................................................................21.2开发工具简介..........................................................................................................31.3相关技术支持..........................................................................................................31.4管理信息系统的发展历史......................................................................................41.5管理信息系统的特点..............................................................................................51.6系统的开发过程......................................................................................................5第2章系统分析.................................................................................................................62.1需求分析..................................................................................................................62.2设计目标..................................................................................................................82.3开发及运行环境......................................................................................................82.4数据流图..................................................................................................................82.4.1系统数据流图顶层图........................................................................................92.4.2系统数据流图一层图........................................................................................92.4.3系统数据流图二层图......................................................................................102.5数据字典................................................................................................................11第3章系统的总体设计...................................................................................................143.1系统功能架构图....................................................................................................143.2系统数据库结构设计............................................................................................153.2.1数据表概要说明.............................................................................................163.2.2数据表.............................................................................................................16第4章系统的详细设计...................................................................................................214.1文件架构图......................