物流配送课程设计

物流配送课程设计需求说明书姓名指导老师日期一引言11编写背景和目的当今世界经济发展呈现出全球化和市场化的两大趋势。经济发展、科技进步和信息革命，将世界带入前所未有的全球化的时代。集物流、信息流和资金流于一身的物流配送中心，在这全球化和市场化的时代里，又进一步促进了世界经济与贸易的发展。迈向21世纪的国际物流技术的特征是信息化、网络化、智能化、柔性化、标准化和社会化。物流配送是实现电子商务的重要环节。它是由物品供方和需方以外的物流企业提供物流服务的模式。它是以中小型零售企业为服务对象的社会化物流中心和配送中心。它实现了最少环节和最低费用和最高的效率等的服务。随着第一方和第二方物流的不断G4448G2904，出现了第G989方物流。物流这一G7044G1864G1147业在G6117国是方G1864未G14418，G5529将G17817G17907发展G17227G7481，G1306G7588G1135方G19766G17836G8821有和国际G5194G17724。为了G19489低G6116G7424和提高效G11422，G6183G11784G1268G13491的G6175G5049G5049G1328方式。G6117G1216G11752G12362小G13464G1927G4462G5332发物流配送G12661G10714G13007G13491。G7424G17731G1226G1039要G19036对用于G8821有G5223G4396的企业G12661G10714G1319G2058，是集配G17722G12661G10714，G5194G16772G5417有G1863信息的G17731G1226。它实现了G8503G11842的配G17745G17722G17754，G17147物G990G17722和G17331G17406的服务等等。12术语说明物流（LOGISTICS）G726物品G1186供G5224G3332向G6521G6922G3332的实G1319流G2172G17819G12255。G7693G6466实际需要，将G17828G17767，G1660G4396，G16025G2380，流G17902G2164G5049，配送，信息G3800G10714等G3534G7424G2163能实G7057有G7438G13479G2524。物流管理LOGISTICSMANAGEMENTG726为了以最低G5049的物流G6116G7424G17810G2052用G6155所G9397G5859的服务G8712G5191，对物流G8975G2172进G15904的G16757G2022，G13464G13467，G2339G16855与G6523G2058。物流中心LOGISTICSCENTERG726G1186G1119物流G8975G2172的场所G6122G13464G13467。第三方物流THIRDPARTLOGISTICSTPLG726由供方与需方以外的物流企业提供物流服务的业务模式。配送DISTRIBUTION在经济G2524G10714G2318G3507G14551G3272G1881，G7693G6466用G6155要G8726，对物品进G15904G6327G17885，G2164G5049，G2265G16025，G2010G2118，G13464配等G1328业，G5194G6365时送G17810G6363G4462G3332G9869的物流G8975G2172。计算机辅助订货系统（CONTINUOUSREPLENISHMENTPROGRAMCAO）G3534于G5223G4396和供G5224商需G8726信息，G2045用G16757G12651G7438进G15904G14270G2172G16758G17147G12661G10714的G13007G13491。二可行性分析1技术可行性A1A0A2A3A4A5A6A7A8A10A11A9A3A12A13VISUALBASICA15A14A16A17A18A19A21A22A20A23A24A15A25A26A27A29A28VISUALBASICA30A31A32A33A34A35A36A37A38SQLSERVER2000A39A40A41A36SQLA42A43A44A45A46A47A48A49A50A48A51A52A48A51A53A28A54A55A21A56A57A58A59A60A61A62A63A64A28A65A66A67A68A69A70A38A71A30A21A72A73A74A57A58A75A76A42A39A77A49A78A28A36A79A53A80A81A28A82A32A33A83A84A85A26A86A87A74A57A58A28A88A89A21A362经济可行性A90A91A92A93A94A95A96A97A98A99A100A101A102A102A103A104A105A96A90A91A106A107A96A108A107A94A95A101A109A93A110A111A112A113A94A95A108A105A114A115A116A117A118A116A96A119A120A121A122A123A124A125A126A127A108A128A129A130A131A132A133A134A135A136A127A131A137A138A99A139A135A140A141A142A143A96A144A122A145A128A146A147A131A97A98A99A100A148A149A150A123A151A152A90A91A153A154A155A156486A157A158A159A160A161A162A163A164A165A158A166A167A168A169A170A171A172A164A165A173A174A175A163A176A177A178A179A180A181A1823操作可行性A183A184A185A186A187A188A189A190A191A192A193A194A195A196A197A198A199A200A201A197A198A184A185A186A187A188A202A203A204A205A206A207A208A209A210A211A202A205A212A213A208A209A214A215A216A203A217A187A188A218A219A220A184A185A186A221A222A189A223A224A225A226A214A215A227A228A202A229A230A203A204A231A187A188A218A208A209A232A233A186A234A235A236A228A237A215A238A239A186A184A185A187A188A240A188A225A2164社会可行性A241A242A243A244A245A246A247A248A249A250A251A252A253A254A255A165A0A1A2A251A3A4A10A169A5A6A7A8A9A244A11A12A13A14A175A73A74A15A16A17A18A255A19A20A21A22A255A64A23A24A25A26A248A27A3A4A285项目概述本开发小组在开发此系统时采用了VISUALBASIC60作为开发平台，采用强大的SQLSERVER2000数据库来处理数据，两种软件相结合，具有较强的容错功能，界面友好，使用非常方便。在人，计算机和数据三者之间处理的非常好。本物流配送管理系统为本地操作系统，即单机版。它的数据实现和操作都简单化，适应性比较强。A181A182A29A30A31A32A33A34A35A186A92A36A37A38A39A40A41A42A43A44A45A182A29A40A46A47A48A49A103A50A195A51A52A53A54A55A56A57A58A59A56A60A61A62A63A65A66A67A41A68A69A57A70A33A71A72A47A48A53A34A35A49A92A75A76A77A34A35A78A79A47A48A192A80A60A160A81A60A212A82A70A33A60A213A83A182A29A32A33A44A43A53A47A48A49A214A33A84A85A86A87A60A88A89A44A45A90A91A42A43三需求分析1系统功能描述11供应商信息的输入，（供应商基本信息、开户编号）包括供应商的浏览、保存、修改、删除、查询。12车工信息的输入，（车工基本信息、开户编号、车辆的体积、载重、车源、车型）包括车工信息的浏览、保存、修改、删除、查询。13供应商帐目的输入和查询。14车工帐目的输入和查询。155配送中心帐目的查询统计。16接G17147G9177单的输入和查询。1G17G26配送中心的配送管理1G17G27G6183G2372，包括帐目G7138G13466G6265G15932的G6183G2372和配送中心配送G1998车单G6265G15932G6183G23721G17G28系统G13512G6264，包括数据的G3803G1233和G5686G3809。12性能要求121数据精确度A174A93A94A95A96A97A174A98A99A100A101A102A104A95A105A106A107A174A93A108A109A110A111A112A113A114A95A115A174A116A117A154A118122时间特性A119A120A121A122A123A124A125A126A127A125A12812A228A129A130A131A132A133A134A135A136A137A138A123A121A122A139A125A128A140A141A142A123A126A127A129A143A144A14513数据流程图14运行要求141用户界面A235A146A147A148A149A150A151A152A153A155A156A157A146A158A159A161A162A240A163A157A164A166A167A168A170A148A171A172A173A162142硬件接口A243A176A177A178486A179A180A183A184A185A187143软件接口A246A188A189WINDOWS98/2000/A190A191A193A194VISUALBASIC60SQLSERVER2000A187154故障处理G8503常使用时G993应G1998错，G14521G17828G15904时G17947G2052G993G2499G5686G3809的系统错G16835，G1075G5529G20047保G16789数据库G4448好G7092G6451。15静态数据A233A196A197A198INTA196A199A200A201DATETIMEA202A203FLOATA251A204A205A206A207A197A198FLOATA253A208CHARA254A209FLOATA210A211FLOATA215A216INTA217A218A219A220A221A222VARCHARA223A224TEXTA253A225A226A227CHARA229A230A231CHARA232A234A231CHARA253A225A236A237FLOAT16动态数据输入数据G726供应商基本信息数据，车工基本信息数据，接G17147信息数据。输G1998数据G726G1998车单信息和帐目G6265G15932，G1998车G17147单信息G6265G15932数据词典G1209G991G7171供应商信息G15932的数据G4395G18681开户编号1G6984数82G13864系人1G8733G439510|1G4395G8609203G11017G168171（G6984数）84G1856G2508G2529G122281G8733G439510|1G4395G8609205地G33481G8733G439510|1G4395G860920四总体设计1系统描述本系统采用G11013管理G2604G11343G5417，管理G2604G2499G1209G4557本系统G17839G15904G980G2011操作。具有浏览、G3698G2164、删除、修改，查询，配送，G13512G6264，G6183G2372G12573G1866G1194基本信息的G7447G19492。系统G17828G15904时，G20330G1820G19668G16213管理G2604G11343G5417。G3926G7536非管理G2604G11343G5417，G4570G12117G8502G17839G15904G980G2011操作。系统G17839入G2530G5389G1998系统G1039G12395体。它包括系统管理，G7097常操作，帐目信息管理，G17147流信息管理，G6183G2372，系统G13512G6264G12573G8181G3371。在G2520G1022G8181G3371中具有G4557应的功能操作。G1375G3926G17147流信息管理它包括接G17147信息和配送管理，G13792接G17147信息的基本操作G7171G16772G5417配送中心接G2052G17147单的基本信息（G17147G2529体积重G18339发G17147G7097G7411G17227G3999地目的地G12573信息）的G5785G1929G5194保存供G7097G2530查询。查询G2499G1209G6365接G17147编号，G7097G7411，供应商查询，G17836G2499G1209查询G7588G980G8437接G2052G17147物单处理G2530G7171G2554G4448G6116配送。配送管理G1039G16213G7171G7693据输入接G2052G17147单的基本信息G2530G14270G2172G4448G6116配送G16855G1998G980系G1375G2499G15904车载的G5785G1929。2系统功能模块21系统管理模块系统管理G1039G16213G7171G4557本系统G6492G7447G13485管理G2604G4557本系统G17839G15904G980G2011的操作。它有修改管理G2604的G4506G11733和为本系统G9167G2164管理G2604的使用G7447。本功能G7171为系统的G4445G1852性G13792G16786G13634的。G3926G7536非管理G2604，G18039G1052G4570G7092G8873G4557G16825系统G17839G15904操作。22日常操作模块G7097常操作G1039G16213G7171G4557供应商和车工车辆的基本信息G17839G15904操作（G9167G2164修改删除浏览查询），G16772G5417G8611G980G1313供应商和G8611G980G8437的车工车辆。存G1660在数据库G1881，供G5529G16213时G17839G15904G5567G17907查询。G1075为G2490的功能G8181G3371G6564供G5468方便的操作。G3926G16213在帐目功能G8181G3371中知道G7588G1022供应商式车工车辆的信息，只G19668输入供应商式车工车辆的G7588G980G16772G5417即G2499方便从数据库中查询G2052相应的信息。23帐目信息管理模块G726帐目信息管理G1039G16213G7171G4557第G980方或第二方和配送中心的G17828费统计。它G1039G16213有四G1022功能G726车工车辆帐目，供应商帐目，帐目查询，和G6116本核算。车工车辆和供应商帐目G7171G16772G5417G8611G980G8437所帐目的G5785G1929，比G3926G8611G980G8437的金额，实付，补缴久缴G12573G5785G1929，G17836G2499G1209汇总总帐目G5785G1929。帐目查询G7171G2499G1209G6365供应商或车工的G7588G980条件G17839G15904查询。从G13792得G1998帐目的基本信息。G6116本核算G1039G16213G7171G6365配送中心G7588G980G7097G7411的利润G5785G1929。24物流信息管理模块G726物流信息管理功能G7171G6984G1022系统中最重G16213的功能，它G16772G5417了G8611G980G8437接G17147G9177单的G5785G1929，然G2530经过配送又产生G1998车单，G2499G1209查询G8611G980G8437输入的接G17147G9177单，判断G8611G980G8437的接G17147G9177单G7171G2554G6365时G4448G6116，G3926G7536没有它G4570G16772G5417G991供G991G8437再配送，直G2052处理结束。25打印模块G726G1039G16213G7171G4557帐目和G1998车单G6265G15932G17839G15904G6183G2372。26系统维护模块G1039G16213G7171G4557数据库的G3803G1233和G5686G3809，G1209保G16789的数据的G8503确性，G1209防造G6116数据的丢失。27帮助模块G1039G16213G7171针G4557系统在G17828G15904时G1998现的错G16835G17839G15904修改。3系统功能模块图4接口设计G8181G3371功能单G980，上、G991层G8181G3371之间只存在G16855用和返回关系，同层G8181G3371之间没有G13864系。G8181G3371功能G1881聚，G8181G3371之间数据耦合。5维护设计A238A239A241A242A244A245A2476数据库设计61系统数据库名数据AA62数据库中表名及其功能621系统用户G15932USER_IDA248A249A250A252A255A22A0A1A2A3A4A14622A15A238A16A5A3A4A17A18KEHU_INFOA19A248A249A250A252A255A15A238A6A1A16A5A3A4A14623车工车辆基本信息G15932A7CHEGONG_INFOA8A175A160A13A9A129A10A21A11A12A20A23A24A25A26A27A28A29624车工帐目信息G15932A30VOUT_INFOA31A32A33A34A35A36A37A38A39A40A41A42A43A44A45A46A47A48A49A50A51A52A53A125A54A40A41A42A43A55A49A50A51A52A53A56625A251A57A58A59A60A61A62VIN_INFOA63A64A65A66A67A68A69A70A71A72A73A74A75A76A77A78A79A80A81A82A83A84A85A86A87A88A73A74A75A76A89A82A83A84A85A86A90A90626A233A91A92A93A94A95HUOHU_INFOA96A97A98A99A100A101A102A103A104A105A106A107A108A109A110A111627车G1929G15932A95CHE_INFOA96A97A98A99A100A101A102A106A112A113A114A112A113A184A115A109A110A11673、数据完整性及安全性考虑A117A118A119A120A121A122A123A124A126A127A128A130A131A132A133A134A135A139A136A117A118A137A138A140A141A142A143A144A145A153A146A147A148A149A150A142A134A151A152A135A154A155A156A157A119A117A118A158A159A161A162A163A219A142A164A165A166A167A168A169A117A118A134A143A144A170A171A172A173A135A123A124A174A145A176A173A137A177A161A178A135A161A178A166A167A128A179A180A134A168A169A181A182A134A183A185A135A186A187A165A166A167A188A189A190A191A146A161A192A193A194A134A183A185A164A195A173A123A124A196A156A157A161A192A117A118A197A198A170A117A118A199A200A135A201A202A166A167A185A177A140A141A134A143A144A170A117A118A203A152A204A147A148A151A152,A176A173A205A117A118A197A198A147A206A135A207A123A124A208A209A210A134A173A211A212A199A200A213A131A135A205A151A152A214A215A208A209A216A217A218A164五详细设计1数据库需求分析G726（物流配送管理系统结构流程图）数据库体现了用户的G19668求管理，体现在G2520种信息的G6564供，保存，更新，查询。签于本物流配送管理系统的G19668求，它的数据G16786计G3926G991G726供应商基本信息G726（开户编号开户G7097G7411G1856G2508G2529G12228G13864系人身G1233G16789号G11733G11017G16817地G3348）车工基本信息G726（车G1039编号车牌编号开户G7097G7411车G1039G11017G16817载重体积G17828费车源车型）车工帐目信息G726（车牌编号单据G7097G7411车G1039实付金额补缴G3803注操作G2604编号）供应商帐目信息G726（开户编号G17147G1039单据G7097G7411实付金额补缴G3803注操作G2604编号）接货单信息G726（接G17147编号G7097G7411费用供应商开户编号G17147G2529体积重G18339件数G7171G2554G4448G6116配送G3803注G17147物类型G17227G3999地目的地G17147物价值）车况出货单信息G726（车G1039编号体积重G18339目的地G17227G3999地剩余体积剩余重G18339发车时间接G17147单编号）系统管理员信息G726（管理G2604G2529G12228G4506G11733管理G2604描述）2数据结构逻辑结构设计（数据表）A220A221A222A223A224A225A226A227KEHU_INFOA228A229A230A231A232A234A235A236A237KH_NUMVARCHARA239A240A241A242KH_DATEDATETIMEA239A240A243A244KH_CORPVARCHARA245A246A247A248KH_NAMEVARCHARA249A250A252KH_TELVARCHARA253A254KH_ADDVARCHARA255A82A21A32A16A4A0A1A18CHEGONG_INFOA75A247A55A2A3A5A37A6CG_NVARCHARA21A53A241A242CG_NUMVARCHARA21A7A241A242CG_DATEDATETIMEA239A240A243A244CG_NAMEVARCHARA21A53CG_TELINTA253A254CG_UNITFLOATA35A8CG_AREAFLOATA254A9CG_PRICENUMERICA246A10CG_ADDVARCHARA21A11A95A12A13A0A1A18USER_INFOA19USER_IDVARCHARA95A12A13USER_PWDVARCHARA85A14USER_DESVARCHARA50A240A87A15A21A32A17A20A18VOUT_INFOA19A75A247A55A2A3A5A37A6VOUT_NUMCHARA21A7A241A242VOUT_DATEDATETIMEA71A2A243A244VOUT_NAMEVARCHARA21A53VOUT_VALUEMONEYA69A89VOUT_VALUEINMONEYA26A22VOUT_VALUEAMONEYA90A89VOUT_BCHARA64A23A241A242VOUT_MEMOMEMOA24A25A251A27A28A17A20A18VIN_INFOA19A75A194A55A2A3A5A37A6VIN_NUMCHARA239A240A241A242VIN_NAMEVARCHARA253A53VIN_DATEDATETIMEA71A2A243A244VIN_VALUEMONEYA69A89VIN_VALUEINMONEYA26A22VIN_VALUEAMONEYA90A29VIN_BVARCHARA64A23A241A242VIN_MEMOTEXTA24A25A233A30A33A71A0A1A95A12HUOHU_INFOA75A247A55A2A3A5A37A6IN_NINTA233A71A241A242IN_DATEDATETIMEA71A2A243A244IN_PRICEFLOATA10A50IN_NUMFLOATA251A27A28A239A240A241A242IN_NAMECHARA253A247IN_AREAFLOATA254A9IN_UNITFLOATA8A31IN_ACCOUNTINTA98A55IN_NOVARCHARA39A34A79A36A38A40IN_MEMOTEXTA24A25IN_KCHARA253A41A3A5IN_BEGINCHARA42A43A255IN_OUTCHARA20A44A255IN_PFLOATA253A41A45A46A21A47A48A21A71CHE_INFOC_ACHARA21A53A241A242C_BFLOATA254A9C_CDECIMALA35A8C_DCHARA20A44A255C_ECHARA42A43A255C_FFLOATA92A49A254A9C_GFLOATA92A49A35A8C_HDATETIMEA51A21A52A54C_JFLOATA233A253A71A241A242七程式编码G16825物流配送管理系统G7171用VB60开发的，G11013VB编写。源代码在附录八测试报告1前言A94A56A57A58A59A60A61A62A125A63A65A66A67A68A125A97A70A67A99A72A100A73A74A76A77A78A97A70A61A62A80A235A81A103A83A97A70A80A84A86A105A88A97A70A91A107A93A96A97A70A91A93A96A97A70A91A108A209A97A70A72A66A67A101A102A104A109A106A110A104A109A111A81A112A72A113A114A115A116A135A117A58A72A118A174A93A96A115A119A120A121A122A123A250A111A124A76A802。功能测试用例A126A127A128A129A130A131A132A133A134A139A136A129A130A131A137A138A140A141A142A143A144A145A134A146A147A148A149A150A151A152A153A154A155A140A137A138A154A155A143A144A145A134A156A157A158A137A138A159A160A129A130A131A161A162A163A164A165A166A167A168A169A170A160A171A172A173A175A176A177A178A179A180A134A181A182A162A183A184A185A186A187A183A188A167A162A183A189A148A149A129A130A190A249A191A192A193A190A195A196A197A198A129A130A190A199A200A197A198A129A130A190A230A201A190A148A149A202A203A190A204A205A206A160A173A175A207A148A149A129A130A208A166A167A210A211A162A183A189A212A213A141A142A190A214A215A154A155A190A216A166A206A173A207A212A213A141A142A208A160A148A149A151A152A137A138A217A141A142A218A219A220A141A142A160A139A136A217A141A142A218A219A220A141A142A143A181A221A148A149A150A222A152A151A152A134A207A137A138A140A141A142A143A144A145A223A156A157A158A137A138A208A160A173A207A214A215A154A155A208A139A136A137A138A140A158A154A155A224A218A225A226A227A228A140A129A130A131A140A224A229A231A181A221A232A134A148A149A151A152A207A234A154A155A224A236A237A238A223A156A157A158A137A138A208A160A173A207A216A166A208A232A134A239A216A166A234A148A149A160A173A207A249A191A192A193A208A166A167A219A211A162A183A189A240A182A241A242A243A197A198A129A130A218A244A245A242A243A197A198A129A130A206A160A240A182A241A242A243A197A198A129A130A231A240A182A241A197A198A140A247A248A190A252A237A190A212A213A190A255A54A190A218A35A0A206A70A137A138A140A231A1A42A2A232A8A3A166A167A181A182A140A151A152A160A17A139A70A252A237A232A4A137A138A140A249A5A143A128YYYYMMDDA153A44A160A148A149A3A154A110A151A152A207A155A137A138A140A153A44A128A42A2A134A156A157A158A137A138A223A208A160A244A245A140A192A193A218A240A182A241A181A32A160A173A207A195A196A197A198A129A130A208A166A167A156A211A162A183A189A244A245A190A15A155A190A35A0A190A161A243A157A128A206A24A211A162A183A181A182A140A58A133A195A196A6A7A160A68A9A35A0A10A11A171A172A14A244A245A218A15A155A238A12A231A1A189A179A249A5A190A158A211A244A245/A15A155A206A140A35A0A134A139A136A225A226A227A228A148A231A237A238A234A58A133A140A6A7A134A146A148A149A150A151A152A207A160A143A104A231A1A140A197A198A134A156A157A158A35A0A208A160A161A243A157A128A168A13A128A14A16A18A9A23A179A238A158A40A249A5A140A161A190A6A7A173A207A199A200A197A198A129A130A208A166A167A219A211A162A183A189A199A200A197A198A218A16A18A129A130A206A199A200A197A198A128A166A167A40A211A58A133A24A40A220A140A19A20A33A178A21A134A10A11A252A237A218A179A158A40A115A98A35A0A160A139A136A148A231A162A38A158A40A115A98A140A13A22A134A146A148A149A150A151A152A181A182A140A197A198A160A4A16A18A129A130A128A94A226A137A138A140A19A20A33A178A36A154A110A16A25A181A182A140A244A7A134A173A207A230A201A208A166A167A210A211A162A183A189A244A245A195A196A26A27A28A21A190A240A182A241A195A196A26A27A28A21A190A166A244A178A206九软件描述本系统操作界面简单G9177晰操作方便，功能G4448善，操作流程简单，只G16213简单介绍用户就会操作；然G13792本系统G1075存在G993足的地方。G11013于时间较为紧迫和技术的原因，暂时未有实现的功能在G1209G2530会尽力地实现G5194且会G993断地G4448善和扩展G2520种功能，使G16825系统能更好地被使用，发挥G1866应有的使用价值。本系统适合用于区域物流管理理系统。本系统最大的特点就G7171没有G16786G13634库存，从G13792减少大G18339的人力，物力和资金。它G7171G11013物品供方和G19668方外的物流企业G6564供物流服务的业务G8181式。能够满足G7097常的操作管理，比传统的手工效率高，管理G1075比较方便。它最的特点就G7171系统能够G7693据管理G2604输入订单信息G2530，为配送中心计算G1998G980系G1375的G2499G15904配车方案，让配送中心得G2052最大G19492度的利润。本系统G17836没具G3803配送途中数据传输及控制的功能，来跟踪商品G2172向、控制车辆用车上G16786G3803；在配送途中有意旬状G1929发生时，G17836没G17902过G17902信系统重新配送G8181式G5192G19668的G2454数，重新G2474得配送途G5464G5194G17902知配送人G2604，使配送能G20046利G4448G6116。在G3822G4198体的G10627G3671G991G17836G993能够实现G1209G16833G19911G6564G12046作为操作向G4560，G16825系统只能在本地G17828G15904，G1306G19555G11540计算机G13605G13488和信息化的G993断发展。G2164上物流G9921的G1926G9022G991G701业务的G993断扩大，G4560G14280G16825系统G993能及时的满足配送中心的G19668G16213，所G1209有G5465于改G17839为G13605G13488版。在G13605上订单，查询G12573G12573及时回应信息G13485第G980方和第二方。十设计总结A175信息系统的开发不仅仅是一个应用程序编写的过程，更重要的是在系统分析和设计阶段所做的工作。在开发过程中，充分利用VISUALBASIC在应用程序开发上灵活性和效率高的特点，再与强大的SQLSERVER2000数据库连接。完成了物流配送管理系统。这次通过开发物流配送管理系统，使我在边工发边学习的过程中掌握了更多的课外的知识，不仅充实了自己的专业技能，而且提高了自己的动手能力。更重要的是让我体会到了一个团队合作的精神。开发系统是一件既坚苦而又有意义的工作，在开发的每个阶段都要严格遵守软件开发方法。我们在开发软件过程中要充分了解用户的需求，再根据用户的需求导G1998系统G11468应的G2163能,G2494有这G7691G6177能使开发G1166G2604和用户的G5617G5831G15713G1038一体，G1955G4581分G4708。在数据库设计阶段，要G6226G1998系统的每个实体，G5194且要充分G16760识G2520实体G1055G19400的G13864系，通过分析G9177G7982实体与G13864系G6177能G5326G12447合理的数据库。G15932与G15932G1055G19400的G1863G13864是数据库设计的重点，G3252G8504我在这G18336用了G5468多G7114G19400G17839G15904分析。在编G11733阶段，有G7114会G1038了一个G4579G4579的G19181G16835而大G1272G14053G12575，G14469上G3921G1135G7114G19400。G3252G8504，每个开发阶段都要G13475过一G11070G1192G13466的G5617G13783和G10742G11964。在开发G7424系统G2530，使我G7138G11345到G256要与用户G15713G1038一体G257的开发G17959理。G2494有这G7691G6177能G17810到G1861G2528的理解。附录（源代码）G1856G1861G8181G3371G1207G11733G726PUBLICFMAINFORMASFRMMAINPUBLICUSERNAMEASSTRINGSUBMAINDIMFLOGINASNEWFRMLOGINFLOGINSHOWVBMODALIFNOTFLOGINOKTHENLOGINFAILEDSOEXITAPPENDENDIFUNLOADFLOGINSETFMAINFORMNEWFRMMAINFMAINFORMSHOWENDSUBPUBLICFUNCTIONCONNECTSTRING_ASSTRINGRETURNSADBCONNECTSTRINGCONNECTSTRING“FILEDSNAA_DATADSNUIDSAPWD1234“ENDFUNCTIONPUBLICFUNCTIONEXECUTESQLBYVALSQL_ASSTRING,MSGSTRINGASSTRING_ASADODBRECORDSETEXECUTESSQLANDRETURNSRECORDSETDIMCNNASADODBCONNECTIONDIMRSTASADODBRECORDSETDIMSTOKENSASSTRINGONERRORGOTOEXECUTESQL_ERRORSTOKENSSPLITSQLSETCNNNEWADODBCONNECTIONCNNOPENCONNECTSTRINGIFINSTR“INSERT,DELETE,UPDATE“,_UCASESTOKENS0THENCNNEXECUTESQLMSGSTRINGSTOKENS0_“QUERYSUCCESSFUL“ELSESETRSTNEWADODBRECORDSETRSTOPENTRIMSQL,CNN,_ADOPENKEYSET,_ADLOCKOPTIMISTICRSTMOVELASTGETRECORDCOUNTSETEXECUTESQLRSTMSGSTRING“RSTRECORDCOUNT_“ENDIFEXECUTESQL_EXITSETRSTNOTHINGSETCNNNOTHINGEXITFUNCTIONEXECUTESQL_ERRORMSGSTRING“_ERRDESCRIPTIONRESUMEEXECUTESQL_EXITENDFUNCTIONPUBLICFUNCTIONTESTTXTTXTASSTRINGASBOOLEANIFTRIMTXT“THENTESTTXTFALSEELSETESTTXTTRUEENDIFENDFUNCTION管理G2604G11343G5417系统G11343G5417G15932单（G159321FRMLOGIN）G1039G12395体G15932单（G159322FRMMAIN）管理G2604G6116功G11343G5417G2530G1998现G1039G12395体G726A164A29A30A31A34A37A39A171A41A43A174A45A29A46A47A48A45A34A49A180A50A182A30A46A183A51A41A52A52A39A29A186A183A171A37A29A30A53A55A182A30A46A189A171A30A56A39A186A183A48A45A5