武钢成品库仓储管理信息系统的开发与应用

华中科技大学硕士学位论文武钢成品库仓储管理信息系统的开发与应用姓名：许璐文申请学位级别：硕士专业：系统工程指导教师：王永骥20060430IMIS/C/SWindows2000AdvancedServerSQLServer2000PowerBuilder9.0C/S,MISPowerBuilder9.0SQLServer2000IIAbstractManagementinformationsystemforthefinalproducthousewareofNo.2Hot-rollplantofWuhanIronandSteelCorporation(WISCO)isdesignedandestablishedinaccordancewithpracticalsituation,combiningwithdevelopmentofMISandtechnologyofnetworkdatabase,onthebasisofscientificmanagementtheory.ThissystemusesClient/Server(C/S)mode,takesWindows2000AdvancedServerandSQLServer2000databaseasitsplatform.ByusingthedevelopmenttoolofPowerBuilder9.0,thestoragemanagementwasdeveloped.Thesystemdesign,developmentmethodanddevelopmentprocessunderC/Smodewasintroduced.Furthermorethestoragecontrolmethodwasanalysedintheory.Sowedesignedthedatabaseofthissystem.Whenthedevelopmentwasbeendoing,thedesigneranalysedtheorganizationstructure,theoperationflowanddemandofmanagementcarefully.Finally,amanagementinformationsystemwhichmeetsmanagers’andoperators’demandwasfinished.Allsystemcomprisesfivemodules,namely,operationcenter,managementcenter,financecenter,dadacenterandsystemcenter.InthisthesisIstressedthedevelopmentofoperationcenterwhichincludesstores’outmanagement,stores’inmanagement,storagemanagement,purchasemanagementandrejectionmanagement.ByanalyzingtheoperationflowandoptimaizingreorganizationthebisinessprocesstheMIScanrunwithhighlevelefficiency.ByusingthisMISthewarehouseisbeenmanagedwell.Futhermore,thematerialandthecapitalcanbeusedmoreefficient.Thesystemcanalsoprovidetheelaborateanalysisreportforthedecisionmakersandmakeitpossibletoraisethelevelofdecision-making.KeywordsMISStoragemanagementPowerBuilder9.0SQLServer2000_____111.135000353540%4010000150001000041.221.2.1[1][2]ManagementInformationSystemMIS1.2.2[3][4]123451.2.3[1]3123451.2.4[5][6]1234451.3209021InternetCRM()ERPERPERPB2BERPB2BERPInternetWebInternet[8][9]1.Internet[8][9]51080052176[39][40]Internet[33]620011.2%68.2%18.3%21.6%1.240002.[7][8]8020%7(1)(2)(3)DoWhileDoCaseIf-then(Object)()()[20][31]199550[11](UnifiedModelingLanguageUML)(1)JamesRumbanghOMT()8(2)GradyBoochBooch()(3)IrarJacobosonOOSE()UML1.11997(OMG)70085%1999UML2.0UMLUML(1)(2)(3)(4)(5)(6)UML(RationalRoseProsa)UML(C++VisualC++VisualBasicCORBAJava)UML93.20[23](1)(2)(3)(4)[23]10112MISMISMISMISMISMISMIS2.1MISMIS[24][25][31]MISMISMISMIS12[29]1MIS523OOObjectOriented132.2/C/S/B/S2.2.1/(C/S)8090////B/SC/S[26][29][33]B/SC/SB/SC/SC/S2.12.1C/S142.2.2/B/SInternet/B/SB/S//WebB/SWebWebWebSQLWebWebWebWebB/SWebCGIAPIASPB/SWebB/S2.22.2B/SWeb2.315(1)(2)(3)DBMS(4)2.3.1[2]802.12.1950042195950562095950091995………………16lRelationlTuplelAttributelKeylDomain01200120ll123…n2.3.2E-R[2]1Entity23EntityRelationApproachE-RE-RP.P.S.Chen1976E-R17E-R2.3.3[1][2]11NF22NF33NF3NF2.43500012GB400MHzUltraWideSCSI120GSCSI2Cisco2600routerERP183ACCTONfastSwitch8sACCTONCheetahSwitchWorkgroup3024C100Mbps100Mbps4FUDENUPSUPS56P41.7GHz256M80G72.34U2U2U2UUPS2U2UERP2.3…...…...192.52.5.1Windows2000ServerWindowsXPWindowsProfessional2000TCP/IPUNIXNetwareWindowsNTUNIXNetware/WindowsNTWindowsWindows//1993WindowsNTwindowsNTNOVELLNetwareNTLANWindows2000WindowsNTPCWindows2000TCP/IPWindowsWindowsWidows2.5.2MicrosoftSQLServer2000MicrosoftSQLServer/Transact-SQLSQLServerSQLServerSQLSQLServerSQL20SQLServerSQLServer[12][14]SQLServerDelphiPowerBuilderVBVC1SQLServerSQL2SQLServerSQLSQL3SQLServerSQL4SQLServer5Client/ServerSQLServer/SQLServer6SQLServer7SQLServer2000XMLBigintSql_VariantTableSQLServer212.5.3SybasePowerBuilder9.0[4]1/PowerBuilder9.0/2PowerBuilder9.0PowerBuilder3PowerBuilder9.0OracleSybaseMicrosoftSQLServerIBMDB2ImformixXbaseFoxproParadoxPowerBuilder9.0ODBCPowerBuilder9.0SybaseSQLAnywhere4PowerBuilder9.011PowerBuilder9.05PowerBuilder9.0DBMSDBMS226PowerBuilder9.0PowerBuilder9.0PBDEBUGPowerBuilder9.0SQL7PowerBuilder9.0PowerBuilderPowerBuilder9.0XMLJSP.NETWebServices2.62333.1GSP3.13.1243.235000100001500010000433.23.2.12512312345673.2.2ABC[34][39]ABCABCA510%6070%2630%AB2030%20%C6070%6070%3.13.1ABCABCA[14][15][35]1P525252D?i,ni(i=1,2,…,m),?inii?i2mm27kii1,2,…mD?nnn1mi=∑ki×ni(3-1)(3)nf*(?)=a0*f0*a1*f1*…+ad*fd*(3-2)d{f0,f1,…fd}={1,?,…,?d}111102111111211111,,...,,,...,............,,...,ppppdiiiiiiippppdiiiiiiiiinppppddddiiiiiiiiiwwnaa========+====⎡⎤⎡⎤⎢⎥⎢⎥⎢⎥⎢⎥⎡⎤⎢⎥⎢⎥⎢⎥×⎢⎥⎢⎥⎢⎥=⎢⎥⎢⎥⎢⎥⎢⎥⎢⎥⎢⎥⎢⎥⎢⎥⎣⎦⎢⎥⎢⎥×⎢⎥⎢⎥⎣⎦⎣⎦∑∑∑∑∑∑∑∑∑∑∑∑(3-3)f(?)*Aa0,a1,…,adde2121pipind==∑∑2121(f()n)pipinw==-∑∑(3-4)ed1≤d≤p4kl328l=1()piinfwik=-∑(3-5)fwiwiwkD=()fwihl(3-6)hA[14][15][17]11D23C1Cs4EconomicOrderQuantity,EOQQ0Q0112DCdCsCq+(3-7)DCdCqCQ292Csmin{}Cs=C3+K(S-I)+()rSSr≤-∑C1P(r)+rS∑C2(r-S)P0(3-8)IKC3C1C2rP(r)SSSCS≤C(S+1)(3-9)CS≤C(S-1)(3-10)(3-8)(3-9)3-102()12irSCKPrCC≤-=+∑,(3-11)212CKCC-+N(3-12)()irSPr≤∑≥NSiS0Q0S0I(3-13)3.3130234563.43.4.1131234563.4.2SQLServerTransact-SQL323.4.3[19]1PowerBuilder2PowerBuilderMSSMicrosoftSQLServer3Newprofile4Connection5okMSSMicrosoftSQLServer6Connect3.33.3333.5MIS3.43.43444.1E-R4.1354.2/4.24.21.123364562.4.34.33.374.44.44.1235.1)4.5384.524.64.6396.4.74.77.14.8404.824.91.2.4.94138.4.104.104.31.2.124233.124.41.2.3.4.4.51.ØØØØ43ØØØ