华铸ERP系统基本模块的研究与开发

华中科技大学硕士学位论文华铸ERP系统基本模块的研究与开发姓名：王红楼申请学位级别：硕士专业：材料加工工程指导教师：周建新;刘瑞祥20040420IIIERPERPERPSQLServer2000PowerBuilder9.0MicrosoftXML4.0ParserSDKERPERPIVAbstractEnterpriseResourcesPlanning(ERP)isanenterpriseresourcesmanagementsystem,whichcombineswithenterprisemanagementtheories,operationflow,basicdata,humanresources,materialresources,computerhardwareandsoftware.It’sanintegrationofmanagementideology,softwareandmanagementsystem.Asafoundryenterpriseresourcesmanagementsystem,InteERP,developedbyPowerBuilder9.0,SQLServer2000andMicrosoftXML4.0,coveredeachsideoffoundryenterprisemanagement,suchasstock,production,sales,finance,etc.WiththeaidofIntecaseERP,managerscananalyzeanddealthecomplexdataandinformationoftheenterpriserapidlyandaccurately.ThisarticledescribesthefulldevelopmentprocessofInteERP,whichincludesfeasibilityanalysis,requirementanalysis,framedesign,databasedesignanddetaileddesign.Inthedetaileddesign,auniformdesignmodeanddevelopmenttemplatesaresetupbyusingsomesoftwaredevelopmenttechnologiessuchasthetheoryofdatamanagement,thetheoryofObjectOrientedProgramming,inherit,userevents,modularization,etc.Undertheuniformdesignmodeanddevelopmenttemplates,severalbasicmodulesaredeveloped,includingproductionmanagement,materialsmanagement,humanresourcesmanagement,customerrelationshipmanagement,systemmaintenancemanagementandsoon.Praticeprovedthatthedevelopmenttemplatestechnolgoyisefficient,becauseitnotonlyunifiesthesoftwareinterfaceandoperation,butalsoreducestheworkloadofdevelopment.Becauseofthesimpleoprationandinterface,itisconvenientforuserstomastertheInteERPsystem.Thisarticlealsogivessomesolutionstodealwiththedifficultiesmetinthedevelopment.Someprogramtipsarealsoprovided.Mayit'susefulforthelaterdevelopmentofthissystem.KeyWords:foundryERPInteERPdevelopmenttemplates111.11.1.1ERPEnterpriseResourcesPlanningGartnerGroupInc.90[1][2]1)MRPIIManufacturingResourcesPlanning“”SupplyChain2)/4GLERP3)ERP1-11-1ERPERP[3]MRPERP[4]2[5]ERP[6][7]ERPERPERPERP1.1.2ERP[8][9][10]1-231-2ERP[11-12][13]ERP[14]1)ERPERP25%~30%[15]2)ERPERP10%4()3)5%10%25%40%ERP4)5)ERP/MRPII55%35%ERP1.2MRPII/ERP1995199727%199835%()4.21999ERPWTO992000ERPERP510%ERPERP[16]AMRResearchERP37%1998ERP1482002520[17]ERPMPRIIERPERPERPCAPMS/95ERPAEPCSSJ-ERPERPMRPIIERPMRPIIERPMRPERPERPERPMRPIIJW-MIS[18-19]ERP/MRP[20-21]20002002[2002]3121.361)ERPERP2)3)4)72ERPERP2.1ERP2.1.13)MRPBOMMRP[21]nteERP8[22]2-1ERP2.1.2[23]2.1.2.1[24]1)2)3)4)95)2.1.2.2[252.1.2.3ERP2-28[26-29]2-2101)42-3[30-33]2-32)4[34]2-42-4/113)2[35]2-52-54)3[36-37]2-62-6125)6[38-39]2-72-76)4[40]2-82-8137)2-98)[41]2-102.2ERP[42]2.2.114ERPERPERP2.2.2ERP2.2.32.2.4ERP2.3ERP2.3.115FoxProAccessORACLESQLServer2000SQLServer2000[43]1)webSQLServerXMLInternetSQLServerXMLXMLWebXMLXMLW3CSQLServerWebURLHTTPWebSQLServerWebOLAPWebWebCommerceServer2000WebDISTINCTCOUNTSQLServerSQLServer2)(LOB)SQLServer2000SQLServer(SMP)(LOB)SMPWindows2000ISVSQLServer200032CPU64GB163)SQLServerT-SQLT-SQLSQLServerMSMQFTPInternetOLEDBSQLServerWeb(OLAP)SQLServerWindows2000ActiveDirectory™SQLServerERPSQLServer2.3.2PowerBuilderSybaseInc.PowerSoft/(Client/Server)InternetPowerBuilderPowerBuilderPowerBuilder[44]1)PowerBuilderOracleFoxProPowerBuilder(RDBMS)OracleSybaseMicrosoftSQLServerIBMDB2ImformixXbaseFoxProParadoxPowerBuilder17ODBCPowerBuilderSybaseSQLAnywherePowerBuilder2-112-112)PowerBuilderPowerBuilderPowerBuilder(Crosstab)nested3)PowerBuilder//PowerBuilder18PowerBuilderRADERPPowerBuilder193ERPERP8[46-49]3.133-1n1nnnnnn11111111111n/13-1E-R3.1.151)CSiMnPS2)CSiMnPS3)(//)4)(///)5)203.1.241)2)3)4)3.1.361)/2)CSiMnPS3)CSiMnPS4)5)6)213.243-21n111n111n111n1n111111nn3-2E-R3.2.121)2)3.2.221)2)223.2.321)2)3.2.411)3.333-311n1n1nm11n11111nn1nn113-3E-R3.3.151)232)3)4)()()5)3.3.211)3.3.311)3.433-4n11n1n1111n1111nnnnm3-4E-R243.4.141)2)3)4)3.4.241)2)3)4)3.4.341)2)3)254)3.553-51nn111111111111n1n11nn11n11111n3-5E-R51)()2)()3)4)5)263.621)2)3.743-6/111n1nn11n1nn1111n111111n13-6E-R3.7.121)2)3.7.211)273.7.311)3.7.411)3.821)2)3.9AccountingDataEntryOperatorsAccountingDataEntryManagersGRANTREVOKEDENYDENYSQLServerSQLServerSQLServerdb_securityadmindb_ownerdb_datareaderdb_datareaderSELECTSELECT284ERP4.1ERPw_modelw_model(menu)(events)(functions)(w_print)(w_PopUpwindow)activeopenresizeclosequeryclosehelpue_sortwf_buttonwf_button_secwf_button_setwf_resize_itwf_resize_it_dwwf_savewf_help4.1.1MDIimf_w_frame4-14-1imf_w_frame1)ToolBarimf_w_frameToolBarunenabled2)XMLXMLUnicode(flexibility)(simplicity)(readability)XML29XML[50]4-2XML[51]4-2XML?xmlversion=1.0encoding=gb2312standalone=no?!DOCTYPEsolution[!ELEMENTsolution(menuitem+)!ATTLISTsolutionxmlnsCDATA#FIXEDURI://hust.edu.cn/Intecast/PowerversionCDATA#IMPLIEDnameID#REQUIREDtextCDATA#REQUIREDgroupstate(disabled|enabled)disableduserstate(disabled|enabled|none)noneoperation(yes|no)no!ELEMENTmenuitem(menuitem)*!ATTLISTmenuitemnameID#REQUIREDtextCDATA#REQUIREDgroupstate(disabled|enabled)disableduserstate(disabled|enabled|none)noneoperation(yes|no)no]solutionxmlns=URI://hust.edu.cn/Intecast/Powerversion=1name=s_Intecasttext=groupstate=disa