库存管理信息系统规划与应用

上海交通大学硕士学位论文库存管理信息系统规划与应用姓名：曹军申请学位级别：硕士专业：工业工程指导教师：蒋祖华;叶志强20081201I1.B/SB/S2.Web3.4.BOM5.6.WebGeneXusB/SABSTRACTIITHEPROGRAMMINGANDAPPLICATIONOFTHEINVENTORYINFORMATIONMANAGEMENTSYSTEMABSTRACTTheinventoryinformationmanagementsystemisanimportantpartofenterpriseinformation.Effectivemanagementcanimprovethespaceutilizationratioandraiseproductivity,reduceoperatingcostsandtheoccupationoffunds.Theresearchtaskinthispaperistheinventorymanagementsubsystems.Itcomesfromthelogisticssystemofshanghaiheavymachineplant.Themainresearchworkisasfollows:1.ThispaperproposestheBrowser/Servermodeastheframeofthesystem.2.Analyzetherequirementsofthetargetsystem.Programthefunctionstructure,Webdatabasemanagementsystem,softwareandhardwaretheplatform.Selectthedevelopmenttoolsandmethod.3.Reformwarehousetomatchinformationrequirements,andrealizelocationmanagement.4.Programthefunctionthatgenerateandfillinstandardmaterialsprocurementplanformautomatically.5.Realizeintelligentinventorymanagement.6.Theoperationofthesystemisdesignedaccordingtostandardworkprocess,anditmakesalloperationmeetthestandard.Inventorymanagementsubsystemhasbeenusedinthematerialsdepartment.Itincreasesthemanagementlevelgreatlyandprovidesthetechnologybasestothesubsequentdevelopment.KEYWORDSInventoryManagement,IncrementalDevelopment,WebService,GeneXus,B/Smode11.1IT1.1.1203030CLI[1]21.1.21.1.3VenderManagedInventoryVMI,,,VMI[2,3]3[4]JITJITJITTOCJITTOCJIT[5]JITPowersim[6]JITVA-JITTA-JITJIT[7]ABCABC[8]ABCABCABC2007ABC[9]MatlabExcel[10][11]IDEF04IT[12]VBODBCSQLServer[13]Intranet[14]C/S[15]SYBASESQLSERVER1SCOUNIXC/S[16].NETOSCARC/SB/S[17]ERP.NETSQLSevrer2000B/SWebRFIDITMRPJITC/SB/S1.21.2.1200151.2.2,62.1[18]ParetoABCDABCD2.27DBMS————2.2.112348StructureAnalysisSASASA11SAFigure1thesystemsketchofSAanalysismethod2-12.2.22.2.32.2.4912342.2.510113.119341958180019621993SEC200422Figure2thediagramoftheMaterialsdepartmentorganization123.23.2.11231311110050200021005010050310050609045ABQG/SHWZ18C6733Figure3theflowchartofpurchaseplanandcontractmaking1489QG/SHZL4344Figure4theflowchartofpurchaseoftheMaterialsdepartment3.2.2151AB55Figure5theflowchartofinspectionandkeepingofthewarehouse2316466Figure6theflowchartofconsigningofthewarehouse5BC63.311723BOMCAPP43.4BOM12345678BOM3.4.1118GBJBBOMCAPP23BOMBOMBOMBOM3.4.212BOMBOM341953.4.33.4.477Figure7theoperationflowchartofthewarehouse122033.4.512BOMCAPPBOMCAPP33.4.612IntranetBOMCAPP213InternetInternet3.4.71BOMCAPP233.4.8123224.14.1.1WorldWideWebInternetCERNWebWebHTMLWeb//Client/Server/Browser/Server/MISB/S[16]8B/SFigure8thediagramofthesystembaseonB/SmodeB/SMIS:1MISB/SMISIntranetWebIntranet223B/STCP/IPIntranetTCP/IPTCP/IPIntranetMIS3MISB/S4MISB/SB/S5MISB/SMISB/SMISB/SMIS(Windows2000UnixLinux)6WebservicesB/S7B/SB/SMIS89B/SMISB/SMISMISWebJavaB/SC/SB/SB/SB/S244.1.299Figure9systemfunctionstructure1BOM2BOM3BOM456254.1.3WebWebWebWebWeb1010WebFigure10therunningmodeoftheWebandDBHTTP[18]MySQLSQLServerOracleMySQLSQLServerOracle22MySQLLinuxSQLServerNTOracleLinuxNTSolaris26MySQLLinuxSQLServerNTOracleSolaris33MySQLSQLServerOracleMySQLPHPCSQLServerASPVBPBOracleJSPJavaJavaJavaJavaJavaWebBOMCAPP11SolarisOracleJava11Figure11thediagramofinformationdevelopmentlayoutofSHMP274.1.41BOMIBMsystemP570IBM20075Power6POWER6MPU2CMP340CPUMPUMPUSASIBMSystemp5704IBM4+4816IBMPOWER6IBMSystemp57025481216SPECint2006SPECfp2006SPECjob2005JavaTPC-CIBMSystemp570IBMPOWER6POWERUNIXIBMPOWER6IBM2HPPCIntelP42.83.2GHz512MB1GBDDR40GB80GBWindows2000ProfessionalMicrosoftOfficePC284.1.511212Figure12thetopologysketchoftheMaterialsdepartmentnetworklayoutWZCWZC123456100M2Intranet1000MPCSJYGYC13Intranet13Figure13thetopologysketchoftheintranet293InternetPC4.24.2.1ARTechGeneXusGeneXusGeneXusGeneXusGeneXusGeneXusGeneXusGeneXusGeneXusGeneXusGeneXusGeneXusGeneXus[19,20]304.2.2GeneXusGeneXusGeneXusGeneXus[21]1GeneXusGeneXusTransactionTransactionTransactionGeneXusGeneXusTransactionGeneXusTransaction2ProcedureTransactionTransactionProcedureTransactionProcedureProcedureProcedureGeneXusGeneXusProcedure3GeneXusGeneXus12()GeneXusProcedureGeneXusGeneXus4Java31ProcedureGeneXus4441GeneXus2GeneXusGeneXus344.34.3.1144MT000000081665MnGB/T93-1987MT000000092065MnGB/T93-1987MT0000006616Q235AGB/T853-1988MT0000006720Q235AGB/T853-1988BOMBOMCAPP2BOMBOM3BOMBOM324.3.2ABCDABCD1AA80mmAAAAAA2BB80mmBB105BB5B3CC80mmCCC33QsQpQmaxCQs4DD4.3.3ABC4.3.4JIT341414Figure14thelogininterfaceforusers35IE1515IEFigure15automaticupdatesystemvianetworkandIE5.15.1.11BOMBOMBOM11608-41-933616BOMFigure16automaticbuildpurchaseplanfromBOM1625-3Windows5.1.2BOMBOMBOM1718BOM3717BOMFigure17thecomparisoninterfaceoftwoversionoftheBOM18BOMFigure18thecompareresultinterfaceoftwoversionoftheBOM5.1.3381919Figure19thequeryinginterfaceofthedetaillistofthepurchaseplan5.1.420213920Figure20thequotedpricemanageinterface21Figure21theprintinterfaceofthequotation405.1.512222Figure22theenteringinterfaceoftheorderform2323Figure23theprintpreviewinterfaceofthequotation4122424Figure24themakinginterfaceoftheconsignbill5.