基于NET平台的ERP系统研究与实现

华中科技大学硕士学位论文基于.NET平台的ERP系统研究与实现姓名：李鑫洪申请学位级别：硕士专业：通信与信息系统指导教师：张士军20060429IWTO,,,,ERP(),ERP,ERP,ERP,ERPERPITERPERP.NETASP.NETMVCERPViewControlModel:IIAbstractWithourcountryenteringWTO,ourenterpriseshavetocompetewithmanyinternationalpowerfulrivals.Thisisnotonlyanopportunity,butalsoachallengetoourenterprises,especiallytothemedium&smallones.Inordertoenhancetheircompetitivepower,theyhavetoimprovetheirmanagementconditions.ERP(EnterpriseResourcesPlanning)standsforthemostadvancedmanagementtheoriesnowadaysallaroundtheworld,whichhavethevitalsignificancetoraisethelevelofbusinessmanagement.Basingonthebackgroundmentionedabove,thethesisstartswiththeintroductionoftheERPconcept,andelaboratestheERPdevelopmentcourse.AndthethesisintroducestheERPsoftwaredevelopmentandstudiesERPapplicationsatpresentsituationallovertheworld.ThenthethesisproposesthelogicalsystemstructureandthefunctionalanalysisoftheERPsystem,andintroducesdetailanalysisfromallaspectsoftheERPsystem.Afterbeingfamiliarwiththeenterpriseanddepartment'sprofessionalknowledge,understandingtherelatedmoderncontrolthought,moreoveralsoneedingtobefamiliarwiththeITtechnology,ThispaperintroducesfouressentialtechnologiestodevelopintheERPsystem:thebindingandstoragingofdata,themappingofdatabaseanddataobject,theunittestoftest-drivendevelopmentandbuildingcontrollerinbasicdatapage.Finally,thethesisstudiesadesignframebasedon.NETtheplatformandMVCmodeandASP.NETtechnologytocarryontheERPsystemwhichtheauthoronceparticipatedasamember,AndintroducesdetaillytherealizationprojectoftheERPsystemthroughModel-View-Controllayerbytheuseoftheframe.AndthethesisgetanexampleofCGDDmodeandintroducesdetaillytherealizationofthemode.ThroughtheimplementationinShangHaiFortuneTechgroupCo.,Ltd,itindicatesthatmayenhancethecompetitivepowerandthemanagementefficiencyoftheenterprise,reducethemanagementrisk.KeyWords:EnterpriseResourcePlanning;Model;View;Controller;Framework______111.1ERP(EnterpriseResourcesPlanning)[1][2][3]ERPERPCIMS(ComputerIntegratedManufacturingSystem)1.2ERPERP──EnterpriseResourcePlanning[4]ERPERPERPSCMBPR[5]ERP2ERPERPERPGarterGroupInc.MRPIIManufacturingResourcesPlanning,“”SupplyChain/[6]4GLERP1.3ERPInternetMIS(ManagementInformationSystem)[7]MRP(MaterialRequirePlanning)MRPMRPMRP(ManufactureResourcePlanning)37080MRPMRPII[8]MRPIIMRPIIMRPII[9]()MRPIIMRPIIERP(EnterpriseResourcePlanning)90MRPIIMRPIIMRPIIMRPIIJIT(Just-In-Time)()/EDIERPInternet[10]ERP41.4ERPERP[11]ERPERP1.4.1ERPERPERPERPMRP,MRPIIERPERPSAP,Oracle,J.D.Edwards,Peoplesoft,Baan,SS[12]2080MRPIIMRPIICIMS[13](MRPII)InfopowerMRPIICIMS1995((SME)(UNIDO)2090SSAForthshift,EMS,qad,OracleSAP,CA,JDE,Avalon,Baan,Symix,MAPICSScala,IFS[14-16]i2,PeopleSoft,SiebelMRPII()CAPMS5MRPIIMRPIIMRPIIMRPERPERP2001ERPERP(TipTopERP)(WorkfolwERP)(EasyflowERP)ERPERP[17]ERP1.4.2ERPERP50080%ERP303[18]1981MRPIIMRPII/ERP2080MRPIIERP10010%20%30%50%MRPII/ERPERP?ERP[19]6ERPERPERPERP[20]ERPERPERPERPERPERPERPERP2000ERPERPERPMRPIIERPERPERPERPERPERP863ERP10ERPERPERPERP71.5[21]WTOERP[22]”ERP”ERPERPERPERPERP.NETASP.NETMVCERP1.6ERP,ERP,ERP,ERP,ERPERPERP8MVCERPViewControlModelERPERPERPERP92ERPERPERPERP2.12.1ERP2.1ERPInternetWEBWEBERPInternet[23]//102.1ERPInternetITInternetInternet2.2ERPMRPMRPIIERPERPERP2.2,MPR/BOOM[24]112.2ERP[25]MRP[25]12[26]/[27]////BOOMBOMBOMBOM[27]132.3ERPERP2.4ERPERPERP(MPR/BOOM)143(EnterpriseResourcePlanning-ERP)ITERP3.1attributeAttributeAttributeAttribute:publicBindAttribute(stringControlID,ControlDomainControl,stringCaption,stringDataType,boolAllowNull,intMaxLength,intMinLength)IDAttributeID+OrderIDTextBoxIDtxtOrderID[BindAttribute(txtOrderID,ControlDomain.TextBox,OrderID,int,false,9,1)]AttributeIDAttributeID3.1AttributeAttribute153.13.2IbatisADOiBATISSQLSQLiBatisXMLIbatis[28]sqlsqlIbatisproviders.configsqlServer1.0sqlServer1.1OleDb1.1Odbc1.1oracle9.2ByteFxMySQLAB1BetaNpgsqlsqlmap.configprovidersSQLMapXMLXMLXMLprovidersSQLMapXML,XML.xmlMAPXMLMAPXMLIDID+resultSQLIDID+[29]SelectInsertUpdateDelete16SQLdynamicprepend=prepend=property=,compareValue=//dynamic3.3(Test-DrivenDevelopment,TDD)[30],.,;;,.NETASP.NETMVCERPXMLNunit,Nunit[31]TestFixtureTestFixtureTestCaseTestCaseShippersTest.csShippersUsingSystem;UsingNUnit.Framework;UsingERP.Test.NUnit;UsingIBatisNet.DataMapper;NamespaceERP.Test.NUnit.ModuleTests17{[TestFixture]//[TestFixture]NUnitPublicclassShippersTest:BaseTest//BaseTest{[SetUp]//[SetUp]PublicvoidInit(){InitSqlMap();//InitSqlMap()BaseTest}[TearDown]//[TearDown]PublicvoidDispose(){/*...*/}[Test]//PublicvoidTestInsertDeleteShippers(){ShippersShippers=newShippers();Shippers.ShipperID=100;Shippers.CompanyName=abc;//Mapper.Instance().Insert(InsertShippers,Shippers);Shippers=(Shippers)Mapper.Instance().QueryForObject(SelectShippers,Shippers);18Assert.AreEqual(abc,Shippers.CompanyName.Trim());//Mapper.Instance().Delete(DeleteShippers,Shippers);Assert.IsNull(Mapper.Instance().QueryForObject(SelectShippers,Shippers));}}}BaseTestInitDisposeNUnitERP.Test.dllrunNUnit[29]3.4Web[32],List(btnInsert)(btnDelete)(btnSelect)(btnSelectAll)(btnRest)(btnClose)ListDataGrid(b