基于ERP系统的考勤模块二次开发设计与实现

上海交通大学硕士学位论文基于ERP系统的考勤模块二次开发设计与实现姓名：董一松申请学位级别：硕士专业：软件工程指导教师：蔡鸿明20081201ERP1ERPERP(EnterpriseResourcePlan)OracleERPERPERPERP2THEDEVELOPMENTOFCHECKING-ATTENDANCEPARTBASEDONORACLEERPSYSTEMAbstractERPsystemistheperfectenterprisemanagementsystem.ItmanagedenterprisesinvariousdepartmentssuchasManufacturingsector,sellingsector,purchasingsector.TotheERPsystemofOracle,ithasexcellentfunctiononthemanagementofsellingandmanufacturinganditcanalsomanagethehumanresourcesincludingemployee’sinformation,pay,informationofrecruitmentandsoon.Butit’s‘allroundfunction’causedsomedefectsinsomemodulesuchastheattendancemodule.Becauseofthecomplexityofoperation,singlefunctionandthedifferenceofeverycorporation,itcan’tmeettheneedofthecompanies.Thereforemanycorporationswillchoosesomeindependentattendancesoftwarewithfullfunction,lowpriceandpersonalization.Buttheattendancemoduleisalsoapartoftheenterprisemanagement,ithasclosetiewithothermodules.DeliverydatabetweentwosystemswhichisnotinevitablewillnotonlycausetheproblemsofSynchronization,butalsoaffecttheefficientofthesystem.ThispapermainlystudiestheattendancesystembasedontheERPsystemwhichcanmeettheneedsofenterprise.Afterneedsanalysisandfunctiondesign,Idesignthearchitectureofattendancesystem.Meanwhileclearthesourceofthekeydata.Tosolvetheproblemofthebulktransmissionoftheattendancedata,thesystemuseinterfacetojudgethedataandchoosetheeffectivedatatotransferintotheERPsystem.Exceptthat,thepaperalsodescribesthemanagementofemployee’sinformation,workschedulesandholidaycalendar.Andtheninordertosolvethekeyproblemofdatamatchinthissystem,anewalgorithm—throwingshadowmatchalgorithmwasproposedandimplementedforsimulationtest.Finallydesignthreeimportantreports(rotationschedule,resultsofclockingandsummaryofattendanceresults)withthedataofmatchingtoshowtheresults.Intheend,allthemethodandthealgorithmwereimplementedontheprojectofPanasonic,afterthat,wesummarizedERP3theconclusionsandfoundsomeshortagesinthismethod.Meanwhilegaveanewoutlookforthefutureprojectandsystemimprovement.KeyWords:dataload,check-attendancematchmaking,ProjectionalgorithmStatisticsstatementsERP32009225ERP420092252009225ERP111.1ERPERP1.21.2.1ERP90ITGartnerGroupIncITERPEnterpriseResourcesPlanningGartnerGroupERP[23]1MRPII234//GUI(CASE),ERP2SQLEDIERPMRPIIERPMRPIIMRPIIERPERPERP(SCM)BPRERPERPERPERP[21]ERPERPERP;ERPERP:/(C/S)internetERP/InternetBS/ERPERP:ERPERPERPERPinternetERP3ERPERP(CollaborativeProductCommerce)REPERP(OLAP);ERPERPERPERP1.2.22060[18]20702090/Internet/IntranetERP4HRMSHumanResourceManagementSystem()[19]1.2.3ERPERPERPERPERPERP;ERPERP:1ERP2ERP[22]1)2)3)ERP54)5)3IBM75100SAPERP200420055.13%5.89%Ciscoe-learning24004ERP1.2.ERP-HR///3.1.2.4IC[8][15]ICERP61.2.3.4.5.6.7.8.9.10.11.12.ERP7VB[7]asp.net[1],[4]ASPsqlserver2000[16]MicrosoftSQLServer2000,SQLC/S,()():,,,,,,,,,,,UML1.31.3.1OracleERPOracleERP1.3.2ERP822.12.21ERP23ERP9452.31)IT2)oracleEBS3)4)ERP102.42-1Fig2-1BasicArchitectureofAttendanceSystem3-1ERP11ERPERP1233.1ORACLEERPOracleERPEBSOracleApplication11iINTERNETJAVAOracleApplication11iORACLEORACLEORACLEORACLEDELPHIVBPL/SQLORACLEERPORACLE3-1OracleERPTab3-1ComparisonofDevelopToolsofApplicationWindowsBasedonOracleERPSystemFormBuilderFormERPJdeveloper9i/10gWebOracleapplicationserverOAForaclepl/sqlpackageprocedurewebWebOraclewebJdeveloperERP133-1DelphiVBJbuilderWindowsapplicationserverODBCJDBCORACLE3-1ORACLEERPORACLEOracleERPOracleForms&Reports6iForm3.2PL/SQLPL/SQLOraclePL/SQLOracleOracleSQLSQLSQLPL/SQLSQLPL/SQLSQLOracleSQL//SQLSQLERP14PL/SQLSQLPL/SQLFORMPL/SQLFORMSQLPL/SQL3.33.3.1XXXXXXXYYYYMMDDHHMMSSXXXX00010002ERP153-1Fig3-1ProcessofDataImport3-12323ERP16TIMESTORETIMESTORE0TIMESTORE1TIMESTORETIMESTORE1TIMESTORETIMESTORETIMESTORETIMESTORETIMESTORE3.3.23-2Tab3-2FrameofabnormaldataimportreportEMPLOYEENUMNUM20CARDDATEDATE20CARDTIMEDATE20CARDSITEVARCHAR220CARDTYPEVARCHAR220ERRORMESSAGEVARCHAR21003.4ERP173.4.11)2)1)2)3)1)2)3.4.21234RotationPlanCalendar5FlexibleFlagYesNoERP183.4.31)//2)/3)/////4)//3-2(a)-Fig3-2(a)Sketchmapofresultsofattendance-late//3-2(b)-Fig3-2(b)Sketchmapofresultsofattendance-late////ERP193-2(c)-Fig3-2(c)Sketchmapofresultsofattendance-late///3-2(d)-Fig3-2(d)Sketchmapofresultsofattendance-late5)//3-3(a)-Fig3-3(a)Sketchmapofresultsofattendance-early//3-3(b)-Fig3-3(b)Sketchmapofresultsofattendance-early////ERP203-3(c)-Fig3-3(c)Sketchmapofresultsofattendance-early///3-3(d)-Fig3-3(d)Sketchmapofresultsofattendance-early6)//Break1Start/3-4(a)-Fig3-4(a)Sketchmapofresultsofattendance-middleabsent/Break1Start/Break1Start3-4(b)-Fig3-4(b)Sketchmapofresultsofattendance-middleabsentERP21/Break1Start/Break1Start3-4(c)-Fig3-4(c)Sketchmapofresultsofattendance-middleabsent/Break1Start3-4(d)-Fig3-4(d)Sketchmapofresultsofattendance-middleabsent/Break1Start/3-4(e)-Fig3-4(e)Sketchmapofresultsofattendance-middleabsent/Break1StartERP223-4(f)-Fig3-4(f)Sketchmapofresultsofattendance-middleabsent/Break1Start/3-4(g)-Fig3-4(g)Sketchmapofresultsofattendance-middleabsent//3-4(h)-Fig3-4(h)Sketchmapofresultsofattendance-middleabsent7)//8)ERP233-5(a)-Fig3-5(a)Sketchmap