化工企业设备管理信息系统的开发与应用

上海交通大学硕士学位论文化工企业设备管理信息系统的开发与应用姓名：龚永伟申请学位级别：硕士专业：工业工程指导教师：蒋祖华;蒋敏海20041130V24,,,6DevelopmentandApplicationofEquipmentMaintenanceandManagementInformationSystemForChemicalEngineeingFactoryABSTRACTItisimportantforChemicalsInthechemicalplant,theequipment’sconditioniscloselyrelatedtotheproduction’sefficiency.Duetotheequipment’srunin24hours,theoriginalmanagementsystemwasfoundmanyfaultiness,it’snecessarytosetupachemicalequipmentmanagementsystemtosolvetheseproblems.Theenterprisemanagerhopetoknowthoseequipments’usageandmaintenanceconditionbyusingtheequipmentmanagementinformationsystem,arrangesomepreventivemaintenanceplantoavoidproductionlossduetoshutdownrepair.Ithasgreatmeaningforchemicalsenterprisetopromoteequipmentmanagementlevelandefficiencybyusingtheequipmentmanagementandmaintenancesoftware.Thispaperinvestigatedandresearcheddeeplytheenterpriseequipmentmanagementinformationandmaintenanceworkflow,anddevelopedequipmentmanagementandmaintenancesoftware.Thesystemincludefollowingsubsystems:systemmanagement,equipmentinformationmanagement,maintenanceresourcesmanagement,equipmentfailureinformationmanagement,maintenancejobhistoryrecord,sparepartsmanagementandshutdownmaintenanceprojectmanagement.Bytheimplementationofthissystem,wecanmakeagoodplantosparepartsmanagement,toreducethesparepartsinventorylevel;Tomakeaquerytoequipmentfailurehistory,improvethemanagementlevel;Touseprojectmanagementduringequipmentshutdownmaintenance,itcanspecifythemaintenancescope,cancontrolthetimeandcostwithinareasonablescope.Keywords:Equipmentmanagement,InformationSystem,ProjectManagementII20041227III200412272004122791.11.1.120,,19611967,,MAXIMOSAPMP2WOMS:„„„„„„„„„10„,,1-111Fig.1-1TheFigureofEquipmentIntegratedManagement[1]194050PMPreventiveMaintenance11TPMTotalPreventiveMaintenance,1):,,2):,3)4)5)6)7)8)90TPM910„„„IS014000„,,,1-2121-2Fig.1-2TheFigureofEquipmentManagementSystem90benchmark,OEE1111Table1-1TheEvaluationBenchmarkofEquipmentManagement/10-15%/3%/85%85-95%13015%10%/5%02-390%80hrs/yr/2000002/20%OEE80%/35%-64%1.1.2,[34]T14[5]NN[6][8][9]„„„„„TPM15„:1)2)3)4)5)6)7)12,31.2JADE161.2.1JADE2002000TPM1.2.2JADE1.2.2.1JADE„1-2„„„5S„17„„15-30„1.2.2.2JADE:„„,„„„181.2.3JADEER,,-19JADE2.1JADE,,,2.2JADE,1-202345JADE2.3ER2-1-21????ID????????????ID???????????ID???ID???????????ID????????????????????????????????????????????????????????????????????????????????????????ID????????????????????????????????????????????????????????????????????????????????????????????2-1ER.Fig.2-1Entity-RelationChartofEquipmentManagementInformationSystem2.4:2-2(1)(2)(3)(4)-22(5)(6)(7)2-2Fig.2-2SystemFunctionChart2.52-3-232-3Fig.2-3InformationConnectionChart2.62-4:2-4Fig.2-4FlowchartofEquipmentMaintenance,,,,-24,,,,,,,,2.72-52-5Fig.2-5FlowchartofSparePartManagement-252.8KBKB2-6Fig.2-6ShutdownMaintenanceFlowChart2.9-,,,2-7-262-7-Fig.2-7FlowchartofShutdownMaintenance—ProjectManagement,:1.2.3.4.5.1.2.3.4.5.-273.1DBMSDBMSDBMSDBMS:-283-1Table3-1BasetableforSparePartID//3-2Table3-2BasetableforEquipmentIDID3-3Table3-3BasetableforEquipmentSortIDID3-4Table3-4BasetableforSupplierIDID-293-5Table3-5BasetableforFailureInformationID3-6Table3-6BasetableforSystemPermissionIDID3-7Table3-7BasetableforStaffsIDID-303-8Table3-8BasetableforSparePartsOut/inWarehouseIDID//3-9Table4-4BasetableforshutdowntmaintenanceIDID3.23.2.131-3132END3-1Fig.3-1FlowchartofSparePartsEnteringWarehouse3-2Fig.3-2FlowchartofSparePartsOutWarehouse3.2.233-32KB3-3Fig.3-3WorkOrderOutputandAnalysisChart343-4Fig.3-4WorkOrderFlow3.2.3-33KBENDKB3-5Fig.3-5InformationQueryFlow3.2.43-6Fig.3-6GreatMaintenancePlanaddingFlowchart3.2.5-343-7:END3-7Fig.3-7TheFlowchartofYearlyandMonthlyReportMakeup-354.1()4.24.2.14-14-1Fig.4-1StructureofEquipmentManagementSystem4.2.242-364-2Fig.4-2SystemDefaultInterface4.2.34.2.3.1434-3Fig.4-3DatabaseBackupInterface4.2.3.2-37444-4Fig.4-4DatabaseRestoreInterfact4.2.44.2.4.145SP0-384-5Fig.4-5PopedomEnactmentInterface4.2.4.246,,JADE,JADEJADEJADE,JADEJADESP001,SP1111-394-6Fig.4-6PopedomEnactmentInterface4.2.5474-7Fig.4-7BasicInformationDistributionInterface48-404-8Fig.4-8BasicInformationInterface49P5501BCIWPumpSB80-200,CS1JADE-414-9Fig.4-9EquipmentInformationAppendInterface410CS3CSCS;3,CS34-10Fig.4-10EquipmentQueryInterface-424.2.64.2.6.14111200491114-11Fig.4-11SparePartsIn/outWarehouseOperationInterface-434.2.6.2412JADEJADE82004-8-12004-8-314-12Fig.4-12SparePartsIn/outWarehouseHistoryQueryInterface4.2.6.3JADE-444-13Fig.4-13SparePartsIn/outWarehouseReportingFormInterface414JADE200491P0104-5PO1O4-615504-14Fig.4-14ReportingFormPrintingPreviewInterface-454.2.7415JADE4-15Fig.4-15MaitenanceRecordOperationInterface4.2.8-464.2.8.1JADE200491I-INSPECTION4164-16Fig.4-16ShutdownMaitenancePlanInputInterface2004-9-1I-INSPECTIONR2001Reactor200491I-INSPECTION4174-17Fig.4-17ShutdownMaitenanceImplementInterface-474-18Fig.4-18ShutdownMaitenanceArrangementInterface4.2.8.2-,,419JADE8:-484-19Fig.4-19ShutdownMaitenanceQueryInterface,,,,-495.15.1.1JADEJADE5.1.2JADE,,5.2-505.2.1..CPM-PERTCPMPERT19572130%5.2.2,,[20]51:-51Fig.5-1ProjectM