重钢股份公司生产计划系统的研究与实施

重庆大学硕士学位论文重钢股份公司生产计划系统的研究与实施姓名：胡增文申请学位级别：硕士专业：计算机技术指导教师：王铮;李强娇20060201IERPERPERPERPIIABSTRACTWiththecomingofknowledge-basedeconomyeraandthefasteningofglobaleconomicintegration,themarketcompetitionisbecomingfiercerandtheformermanagerialsystemisnotsuitabletothemarketdevelopmentanymore.Inordertoupgradethemanagementofenterpriseandstrengthenthecompetitivepower,itisnecessaryforenterprisestoinvesttheconstructionofinformationsystem.Theresearchsubjectofthearticleisthecompanymainproductionplansysteminthefirstsectionof“IntegrationofProductionandMarketingsystem”forChongqingIronandStellCo.,ITD.Theoverallplanofcompanymainproductiveprogramsystembasedontheenterpriseinformationsystemplanisputforward.ThroughtheresearchonmanagementandmainproductiveplantheoryandcombinedwiththecurrentsituationofChongqingIronandStellCo.,ITD,thesystematicstructureofmainproductiveplanbasedonERPisraised,includingfunctionalstructure,softwaresystematicstructureandsystematicnetstructure.Inthetermsofdevelopingstrategy,themodel-basedmainproductiondevelopingmethodischosenthroughthesoftwareprojectdatatechnologyandtheanalysisofpracticalsoftwaredevelopingtechnology.Basedontheanalysisofproductiveplansystemofourcompanyandcombinedwiththemodeldevelopingmethod,theprocessingmodelofsub-functionalsystemdatalogicalmodeldataconceptmodelanduserpageofproductiveplansystemareanalyzedanddesigned.Intheprocessofthepractice,steel-smeltingplanmodelisfocusedon.Withthemethodof“merge”forneedingplan,theprincipleof“merge”insteel-smeltingneedingplanissolvedanditalsoputintoeffectinthesoftware.Thepracticeoftheproductivesystemupgradesthemanagerialefficiencyofeveryunit,standardizesthemanagementofourcompany,fastenstheproductivecircleofproductsandcarriesoutthecontractperfectly.Theproductivemanagementofourcompanyisbecomingbetterandbetterandthecompetitivepowerofourcompanyhasstrengthened.Thepracticeoftheproductivesystemdoesgoodtoeconomicprofitofourcompany.Keywords:Chonggang,Thesystemofproductionandmarketing,Mainproductiveplan,Researchandpractice1160MRPMRPII/JITERPMRP7580951ERPEnterpriseResourcePlanning[1]ERP90ERP[1]1.1ERP1.1ERPFigure1.1DevelopoferpERPMRPMRPMRPIIERPERP[2](1)2060IBM·MRPMaterialRequirementPlanningMRPMRP12[2](2)MRP2070MRPMRPMRP[2](3)MRP.19779MRPIIManufacturingResourcePlanning[2](4)MRPIIMRPII[4]1)MRPII2)MRPIIMRPII3)MRPIIERPMRPIIERPERPERPAPICSERP[4]30%~50%50%1380%55%35%50%12%10%10%~15%1.2ERPERPERPERPProcessManufacturingDiscreteManufacturing[6]ERPERPERPERPJITERP,ERPERPERPERPCAD/CAPP/CAM,,ERP[4]ERP[4]14ERPERPEnterpriseResourcePlanningERPERP[4]1.3703%ERPIT[7]IBM390IT1534510[9]8010199661998320011020022003[10]L1L2L3MESL4ERP[12]ERP200091000ERPERP[8](1)ERP(2)ERPERPERP(3)16(4)ERP2722.1H52060%200511422025023580200362.2200362400ERPERP28500050030ERP10003000ERPERPERPERPEnterpriseResourcePlanning2.3ERPERPERPERP29“”2.4ERP210“”ERPERP31133.1——3.23123.2.13.2.23.2.33.2.43.2.53133.2.63.2.73143.3ERPmic,mic_line3.1Figure3.1Flowofmainproductionplan3153.475t=3.2Figure3.2Flowofmainliangangplan3163.53.3Figure3.3Flowofmainzhongbanplan4174IT[28]OracleRACLinuxC/SB/S4.14.14.1Figure4.1Frameofsystem418IBMX445IBMX445RS/6000CPU32OracleRACWindowsLinuxFastT600SANOracleRACSANIBMLTO3582LanFreeWINDOWS2003WindowsdDFS()L1L2L3MESL4ERPL3L3L4L4L3L41L32L43L3L4L3L4C/SOracledev2000419JAVAJ2EEEBAWebLogicIBMWebSphereOracleIASWindowsWBT(NC)NetPCJAVAWindowsWBTOracleRACOracleOPSLinux4(1)OracleOracleOracle(2)OracleRACFaileOverSwitchOverOracleRACLinuxOracleRAC(3)OracleRACOracleOracleRACOCFSOCFSRAW-Device()OracleRAC420S8505S6506Rospf4.2C/SC/S“————”4.24.2C/SFigure4.2Frameofc/ssystemLinuxOracle9iRACOracle9iAsFormsServerForms6I4.3421pcNetscreen500PDGA8200pcVPNCAPCIPWEBDNSFTP(1)(2)12(1)NIPSNIPS(2)(3)(4)422(5)CAkey52355.15.15.2Form5.1123451234512345612312345612345.1Figure5.1Moduleofmainproductionplansystem5245.1Table5.1Tablenameofmainproductionplansystem()Table(view)nameFormzs_xqjhbZs_xqqrzs_xqjhjszs_zbgpzyzs_lgxqbzs_zbgpzyzs_lgxqbzs_lgjhzbzs_lgjhbzs_lgjhxdzs_lgjhcbzs_lgjhbzs_lgjhxdzs_lgdyjhzs_lgdyjhcxzs_lgjhbzs_lgwczs_lgwccxzs_v_lgqgbzs_v_lgsccxzs_v_lgjkbzs_v_lgjkcxzs_zbzqjhzs_zbzqjhzs_zbzgjhzs_zbzgjhzs_qgjhzs_qgjhzs_qgjhwczs_zbzqjhzs_qgjhwczs_htdyzgzs_htdyzgcxzs_htsxzzZs_xqqrzs_xqjhjszs_lgxqbzs_v_zbylcxzs_v_zbylcxzs_v_zbzgcxzs_v_zbzgcxzs_v_zbrclcxzs_v_zbrclcxzs_v_zbrkcxzs_v_zbrkcx5.2.1zs_xqjhb=8+16+20+15+30+4++32+14+2415+25+2++++++++5+MIC-LINE-NO3+10+7+10+5+15+15+4+6++8+9++1+90+++45255.2.2zs_lgjhzb=9+9+7+11+10+(4)+33+7+1+1+++8++8+2+240+MIC-LINE-NO3+5+5+10+2+——1——2——3——9——XXXXXXXXXXXXXXXX1——2——3——5.2.3zs_lgjhcb=9+7+2+7+335265.2.4zs_lgwc=9+7+7++8++++11+63+4+3+1++25.2.5zs_zbzgjh=14++6++6+14+14+15+5+11+41+15+25+16+26+36+46+56+66+2+5+MIC-LINE-NO3+52+4+4+4+6+7+42+72+52+++++240++8+8++++XXXXXXXXXX-XXX————1——2——:3——9——5275.2.6zs_qgjh=14+11+20+4+4+14+24+34+44+54+64+74+84+94+104+7+2+240++8+2+1+2+8++6+1+XXXXXXXXX-XXX0005.2.7zs_gpcx=20+15+2+10+10++30+45285.2.8zs_qgjhwc=14+40+4+15+2+1+1+1+8++5.2.9zs_htjhdy=(16)+14+14+45295.2.10zs_htsxzz=()+(15)+(1)+(1)+(1)1‘1’‘null’2:‘1’‘null’3‘1’‘null’5.2.11zs_lggxzz=(9)+(9)+(7)+(11)+(10)+(7)+(4)+(63)+(7)+(63)+(2)+