按订单生产离散型制造业中小企业ERP系统设计与开发

湖南大学硕士学位论文按订单生产离散型制造业中小企业ERP系统设计与开发姓名：苏合申请学位级别：硕士专业：软件工程指导教师：李超;王海清20070419I(ERP)ERPERPERPERPVisualC++6.0WindowsSQLServer2000ADOERPERPNM-ERPV1.0C/SB/SERPERPERPB/SERPERPERPIIABSTRACTAsamainbodyofsociety,smallandmedium-sizedenterpriseactsasaveryimportantroleinnationaleconomy.Itsdigitalizationlevelinfluencesthedigitalizationlevelofthewholecountryseverely.Thoughsmallandmedium-sizedenterpriseinourcountryhasmadesomeachievements,therearealsovariousproblemsinaspectofdigitalization.Forexample,thereisalackofEnterpriseResourcePlanning(ERP)softwareadaptivetocharacteristicofsmallandmedium-sizedenterprise.Therefore,itisimportanttodevelopanERPsystemforoursmallandmedium-sizedenterprisetofittheirneedaccordingtotheirowncharacteristics.ResearchandapplicationofERPsystemwillbesignificanttoboostourcountry'smodernizationandnationaleconomydevelopment.ThroughstudingoftheERPtechnologydevelopmentandapplicationsituationandtheprimaryprinciplesofERP,consideringthecharacteristicsofMaketoOrderBasedSmallandMedium-sizedDiscreteManufacturingEnterprise(MOSMDME),thispaperpointsouttheproblemsneedtobesolvedinactualizingERP.OnthebasisofrequirementsanalysisaboutsomeMOSMDME,theauthorindividuallydevelopedanERPsystem,NM-ERPV1.0.ThesystemisdevelopedinWindowsoperatingsystembyusingVisualC++6.0aslanguagetoolandSQLServerasdatabasesystem.ThispaperalsointroducesthemodulestructureandthedesignanddevelopmentprocessofNM-ERPsystem.Thesystemincludessomesubsystems.Theyarepurchasingmanagement,marketingmanagement,stockmanagement,planningandmanufacturingmanagement,financemanagement,equipmentmanagement,logisticsmanagement,humanresourcemanagement,qualitymanagementandsystemmaintenancemanagementsubsystem.Inthepartofsystem'srealization,asystemarchitecturecombinedC/SandB/Sisadopted.Itmakessystemhavebetterexpansibilityandreliability.Object-orienteddevelopmentmethodisused,whichimprovesreusabilityandmaintenanceofcode.IIIAimattheproblemsneedtobesolvedinactualizingERPandtheproblemsmeetingintheprocessofNM-ERPsystemdevelopment,thispaperputsforwardsomecorrespondingsolutions.TheseresearchworksmainlyfocusontheinformationsecurityandthesystemarchitectureofERPsystem.ThispaperbringsforwardanameliorativeB/SarchitecturemodelandadigitalsignatureapplicationsolutioninERP.Forsomeotherproblems,theproblemaboutlowdisplayspeedonlargedata,theproblemonusingoriginalenterpriseresourceetc.,thispaperhasalsosummarizedacorrespondingsolution.KeyWordsERP;SmallandMedium-sizedEnterprise;SystemDevelopment;DigitalSignature1______211ERP1.1ERP1.1.1AlfredP.Sloan[1]WTOITInternet/IntranetTQCSETimeQualityCostServiceEnvironment[2]20033602790GDP55.6%62.3%46.2%75%9076.7%ERP2ERP(EnterpriseResourcePlanning)[3][4]ERP[5]1.1.2ERPERPITGartnerGroupInc.2090[6]GartnerGroupIncERPERP[7][8]ERP[9]ERP(1)ERP(2)ERPERP(3)ERP(4)ERP(5)ERP(6)3(7)ERPERP(8)ERPERP1.2WTOERPERP1994ERP4ERPERPERPERPERPERP30001.3GarterGroupInc.2090[10]ERPDavenport1993[11]ERPDeloitte[11]ERPJeffreyKeithStratman2001ERPERP[12]ERP5[13]ERPJITBPRERP[14]1ERP[15]80ESRPITCIMCIM-OSA[16]GRAI/LAPCIMGIM-GRAI[17]SaarlandA.W.ScheerARIS[18]Williame[19]PERAPurdueEnterpriseReferenceArchitecture[15]IDEFICAMUML[20]2(DynamicEnterpreiseModellingDEM)ERPBAANERP[22]ERPERPERP[23]ERPERP63ERP[24]ERP,UML[25][26]4[27]ERPERPERPERP[28]1.4ERPERPERPERPERPERPB/S7ERPERPERPERPERPERP1.51ERP2ERPERPERPERPERPERP3ERPERP4ERPERPERPERP82ERPERPERPERP2.1ERPERPERPERPERPERPERP2.1.1ERPERPEnterpriseResourcePlanning[29]ERPGartnerGroupInc.MRPManufacturingResourcesPlanningSupplyChainGartnerGroupERP[10])ERP/4GLERPERPERP2.12.1.2ERPERP[6]:MRP9MRPMRPERPERPIT:20402.1ERP205060IBMMaterialRequirementsPlanningMRP[30]MRPBOMBillofMaterials[31]1960MRPERPMRPERP10MRP2080MRPMRPMRPMRPMRP19779OliverWightManufacturingResourcesPlanning[32]MRPMRPMRPMRP[33]209080MRP90ERP[34]1990GartnerGroupInc.ERP[10]ERP2000GarterGroupInc.ERPERP[35]ERP2.2[34][36]2.1.3ERPERPMasterProductionScheduleMPS[9]MRPBOMCapacityRequirementsPlanningCRP[6]11ERP60907080123121212MRPMRPMRPERP12BOM31231231232.2ERPERP[37][38][39]ERPERP12ERPLPLeanProduction[40]AgileManufacturing[40]SEERPERPTransaction[41]2.1.4ERP1981MRPERP2023ERPMRPMRP13MRP19901996ERP863CIMSMRP200CMISERP20%10%50%600MRP(1)MRP(2)(3)(4)1997ERPMRPSAPORACLEBAANERPERPERP2000ERP2002ERPERPERP144730002.1.5ERPERP21ERPERPERPERP[42][43]InternetWeb[44][45]1ERPERP[46][47]ERPCAD/CAM/CAPPERPERPDRPMESAMS2ERPERPCRM153ERP21ERPERP4ERP5InternetWeb,InternetIntranetERPERPInternet/Extranet[42]2.2ERPERPERP[48]ERPERPERP2.2.11(1)MakeToStockMTSERP16[49].:T(2)MakeToOrderMTO[49](3)AssembleToOrderATOFinalAssemblyScheduleFAS[6](4)EngineeringToOrderETO[50]217[51](1)(2)ERP2.2.2ERP[52]ERP(1)[53](2)ERP18ERP4.2(3)ITERPERPERPERP4.12.3ERPERPERPERPERPERPERP193ERPERPERP3.1[54]3.1.1199415040120033001004002003.13.1.22Win2000Server530ERP20ERPADSLERP3.13.1.3ERPERPInternetEDIERP21ERP3.1.43.23.2ERP1ERP223.33.3(1)(2)(3)(4)(5)BOM23(6)(7)(8)23.43.53.4(1)ERP24(2)(3)(4)(5)(6)(7)3.52533.63.6(1)(2)4(1)(2)ERP26(3)(4)5(1)(2)(3)(4)67(1)(2)(3)(4)83.2ERPERP()27(1)(2)(3)(4)(5)ERP4.1(1)BugERPBOMLowLevelCode3.7BOMERPERPERPERPERPERP283.7(2)29(3)ERP(4)(5)3.3ERP:•ERP30••