vb论文设计 水费收费管理系统

1源代码联系本人一、设计目的随着科学技术的不断提高，计算机科学日渐成熟，计算机在各个领域发挥着越来越重要的作用。作为计算机应用的一部分，使用计算机对水资源用户及水费缴纳情况进行管理，具有着手工管理所无法比拟的优点，如检索迅速、查找方便、可靠性高、存储量大、保密性好、寿命长、成本低等。这些优点能够极大地提高水资源用户及水费缴纳情况管理的效率，也是水资源管理机构帐收费的科学化、正规化管理，与先进科学技术接轨的重要条件。现在我国的水资源用户及水费缴纳情况管理水平绝大部分还停留在纸介质的基G11796G990，这G7691的机G2058G5062G13475不能G17878应G7114G1207的发G4649，G3252为G4439G9022费G1114G16780G3822G1166G2159G2656G10301G2159，在G1461G5699G7114G1207这G12193G1268G13491的管理方法G5529G9994G15999计算机为基G11796的G1461G5699管理所G2474G1207。本G16850G12255G16786计的G11458的是G5326G12447水费收费管理G1461G5699G13007G13491，G18331用计算机对水费G1461G5699进行管理，进一G8505提高水费收费机构及用户对G1461G5699的查G16822检索的便G6475G2163能，G4466现G1866现G1207化水平。G5122G13464工作G1166G2604提高工作效率，G4466现水费G1461G5699管理工作G8981G12255的G13007G13491化，规G14551化G2656G14270G2172化。二、设计任务G457G6980G6466G5223G13007G13491G458G16850G12255G16786计是计算机科学与技术G999G1006G19610G1025G4466G17353性G10627G14422G1055一，是学G1076G4448G457G6980G6466G5223G13007G13491G458G16850G12255G2530进行的一G8437G1852G19766的G13520G2524G13463G1076，G9053及的G9157G5242G5203些G5194G7368G2164接G17829G4466用，要G8726我G1216G2045用所学G11705G16794分G7524、G16786计G5194G4466现一个有一G4462G3809G7446性的G6980G6466G5223G13007G13491。G17902G17819G16850G12255G16786计，使我G1216G13520G2524使用所学G17819的G6980G6466G5223G11705G16794，G6496G6581G6980G6466G5223G5332发G13007G13491的基本G5617G17347G2656方法，G2045用所学的基本G11705G16794G2656技能，发挥G14270学能G2159G2656查找资G7021的能G2159，G17902G17819一个G4466G1375，G17828用G6980G6466G5223G5332发G1025各个G10627G14422，G2164G9157对所学G11705G16794的理G16311与G6496G6581，G3698G5390学G10995G2045用G14270G5061所学G11705G16794G16311G1927G4466G19481G19394G20076的能G2159，为G2530G13505各G19388计算机G16850G12255的学G1076G6183G991G3374G4466基G11796。具G1319本G13007G13491的G1231G2165有G726G20G17G17902G17819本G16850G12255G16786计的G4466G17353及G1866G2081G2530的G1946G3803与G5647G13479，G3809G1076、领G1262、G5053G3278G2656G17828用软件工G12255G16850堂G990所学的G6980G6466G5223G11705G167942G17使学G10995G17902G17819参G2164小G13464团队的G5332发G4466G17353，G1114G16311项G11458管理、团队G2524作、文档编写、口头与书G19766表达的重要性。23使每个学G10995G1114G16311软件工具与G10627境对于项G11458G5332发的重要性，G5194且重点G9157入G6496G6581好一、两G12193较新或较G8981行的G5332发工具或计算机应用技术、技能（比如，网页G16786计技术与常见工具；基于JAVAASP、PHP等技术的WEB编G12255；软件G5332发文档编G2058工具OFFICE、VISIO、ROSE等；商用G6980G6466G5223ACCESS或SQLSERVER、ORACLE、MYSQL等G16786计与G4466现；客户机/服G2165器G13479构）。对于水费收费等行G1006，快速有效地G6980G6466整理是吸引用户、提高G13475济效益的关键G3252素。越来越G3822的水费收费机构用水费管理G13007G13491来管理日常工作，G2524理配置资源，提升管理水平，从而在市场竞争G1025G2474得优势。名称G726水费收费管理G1461G5699G13007G13491G2163能G726用户G1461G5699的添G2164、修改、删除G2656查G16822。水费类型G1461G5699的修改、删除G2656查G16822。水费价格G1461G5699的删除G2656查G16822。新入用户G1461G5699的添G2164、修改、G2474消预G4462G2656查看详细G1461G5699。登记G1461G5699G2656修改登记G1461G5699。保存G13479算G1461G5699。G6183印G4466收水费G1461G5699。三、设计内容（一）可行性分G75241管理G990的可行性在G1268G13491的水费收费管理G1025，管理G1166G2604不得不花费大量的G7114间来处理水费G1461G5699，G1375如错误查G16822、烦琐的登记G2656G13479帐手G13505、费用计算错误、水费资G7021不能及G7114提供等，从而工作效率。G3252此水费的管理G1166G2604迫切的需要一套水费收费管理G1461G5699G13007G13491对日常G1461G5699进行处理G2656维护。历史G13475验的积累使水费现有的管理G2058G5242G2656管理方法比较科学，规章G2058G5242比较G21796G1852，G2419G3999G6980G6466比较正G11842。这些为G13007G13491的G5326G16786提供G1114有效的G2058G5242保G195682技术G990的可行性本管理G1461G5699G13007G13491G4570G18331用技术成熟的VB60G1582为G2081G2500G5332发工具。G2530G2500G6980G6466G5223G18331用G5506软G1856G2508的ACCESSG6980G6466G5223，G4439的G9801G8975性，G4445G1852性，G2656G7143用性为G6980G6466G5223编G12255提供G1114G14403好的条件。G3252此，G13007G13491的软件G5332发平G2500G5062成熟可行。G11840件方G19766，科技的G20146速发G4649使G11840件的G7368新速G5242越来越快，G4493量越来越大，可靠性越来越高，价格越来越低，G1866G11840件平G2500G4448G1852能G9397G17287此G13007G13491的需要。3效益G990的可行性本G13007G13491的使用能大大提高G2604工工作效率，G2164速资G18341G2620G17728、G19489低各项成本及改G2904服G2165质量。能够G2474得G14403好的G13475济效益。水费收费G13007G13491除提供G13485管理G1166G2604的G13007G13491管理G2163能G3818，还能对用户G5332G6930，G4466现用户的查G16822G1461G5699G2163能，G6329有G4448G2904的G7447G19492G16786置G2163能。（G1120）需G8726分G7524本G13007G13491G1039要有G1209G991G2163能需G8726G7261用户登G5417G8181G3371，G1039要用于用户的登G5417。用户G7447G19492分为管理G2604G2656G7234G17902用户。G5415用户G17767入用户名G2656密G11733G2530G13475G17819G11842G16760，G6177能进入G4498G20314客G6163管理G1461G5699G13007G13491，G5194G6329有G11468应的G7447G19492。如G7536不是用户，G6310绝进入。32水费管理G8181G3371，G16825G8181G3371是本G13007G13491的G7692G5527所在。G1039要用于对水费G1461G5699的管理，G1866G1025G2265G6336G726水费收费G8181G3371管理，G1039要G2265G6336G1461G5699的查G16822及缴费等基本G6817作。水费查G16822管理G8181G3371，G1039要用于管理G2604及用户对水费查G16822管理等G6817作。水费管理G8181G3371，G1039要用于用户水费G1461G5699的查看，修改，删除等基本G6817作。G6183印管理G8181G3371，G1039要G2265G6336对水费G1461G5699缴费的情况G6183印的基本G6817作。3用户管理G8181G3371，G16825G8181G3371G1039要用于对用户的基本G1461G5699登记，G1209及G8995G16284G1461G5699等G6817作。4G17146户管理G8181G3371，G16825G8181G3371用于对密G11733，G7447G19492等基本G1461G5699的修改添G2164等G6817作。G7693G6466需G8726分G7524G5647G13479的用户需G8726G16786计G13007G13491的G1319G13007G2163能G8181G3371G3282如G991G726可G1209看G2052，本G13007G13491G2022分为G3247个G2163能G8181G3371，基本G1461G5699管理G8181G3371用于对用户及G1866水费情况进行管理，用户编G17765管理G8181G3371G1039要用于用户G10378G5589的查看G2656用户G1461G5699的编G17765。消费管理G8181G3371G1039要用于对用户消费进行入帐管理。G6265表管理G8181G3371提供G13485用户用来查看缴费基本情况的G1461G5699，G13007G13491G1461G5699G8181G3371用来对G13007G13491用户进行管理。（G989）G1006G2165G6563G17860G7261本G13007G13491用户分为G13007G13491用户G2656G7234G17902用户2用水G17146户分为用户名、户G2507、G1315G3348等基本G1461G5699G726A1A0A2A3A4A5A1A0A6A7A4A5A1A0A8A9A4A5A10A11A12A11A13A14A15A16A17A18A19A20A15A16A13A14A17A18A21A22A13A14A10A11A12A11A13A14A23A24A25A26A4A5A27A24A28A29A2A3A1A0A30A31A4A5A15A16A32A33A13A14A4A5A34A2A3A4A5A35A36A37A38A4A5A39A27A23A24A4A5A23A24A40A24A41A42A43A27A23A24A4A5A44A45A46A47A48A49A5043用水G17146户一G7388G1147G10995一G8437水费G1461G5699G726水G2165G1856G2508G6365G10043G7388为G2345G1313对用水户进行用水G1461G5699G13491计、收费4用水G1461G5699G2265G6336G726本G7388用水G1461G5699及应缴费G6980G20081。管理G2604对用水户G1262进行每G7388一G8437的G1461G5699收G19610，G9994G2530进行用户用水水价等G1461G5699计算G1998G7388水费G9994G2530进行收费5用水G17146户存在水价G16855整的情况6对于每一G7388水费G1461G5699需要进行G8731G5647处理，G2265G6336用水G5647量G8731G5647、水费G5647G20081G8731G5647、缴费G8731G5647、应收G17146G8466G8731G5647G726水G2165G1856G2508G1262对每一个G7388的用水G11468关G6980G6466进行整G1319性G6238G6581，需要对用水G7388的所有用（G2656管G17770G13464为G2345G1313）水量G1209及G17146G8466收G2474情况、应收G17146G8466情况进行G5647G20081G13491计。7G6365G10043用水管理G13464G6183印G1852部用户基本G1461G5699G726G3252G1006G2165需要，需要G6365用户缴费情况G6183印用户基本G6980G6466G1461G5699；8G2345个用水户G17146户停表/G15929G1144G8436费G5686G3809用水G2163能；对于用水户G7693G6466G1006G2165需要应能G2345G10432提供G1866用水户的基本G1461G5699，G1209及G1866G5460G7388的用水记G5417；9各G12193G6980G6466G1881G4493查G16822；G11013G990G17860G13007G13491G6563G17860G1147G10995本G13007G13491的G1006G2165G8981G12255G3282G726G17902G17819对G13007G13491G8981G12255G3282分G7524G1147G10995如G991G6980G6466G4395G1868G726A51A52A53A54A55A56A57A58A59A60A61A62A633A64A65A66A67A53A54A68A69A62A63A70A71A72A73A74A75A76A77A78A79A80A81A82A74A75A76A77A83A84A85A79A80A78A79A80A81A82A84A85A79A80A74A75A86A87A88A89A90A91A92A93A79A80A74A75A94A95A74A75A96A95A74A75A97A98A74A75A99A100A101A94A95A102A99A101A103A104A101A105A106A94A95A107A108A109A110A111A112A81A82A78A113A114A115A116A117A101A94A95A94A95A107A108A94A95A118A119A120A121A101A122A123A124A79A80A81A82A99A100A101A79A80A80A125A102A99A101A79A80A97A125A103A104A101A126A127A105A106A128A80A74A75A81A82A78A127A129A130A116A115A116A117A101A79A80A80A1258A131A1008A120A121A101A79A80A81A82A124A122A123A124A74A75A81A82A99A100A101A122A123A102A99A101A103A104A101A79A132A79A80A133A95A134A135A136A78A94A95A137A138A116A117A101A122A123A79A80A80A99A79A80A80A125缴费G7388G1233用水量G5415G2081水价缴费G6980G20081缴费日A99A100A101A74A75A86A102A99A101A103A104A101A139A140A141A142A143A74A75A116A117A101A74A75A86A74A75A86A144A99A74A75A86A145A146A74A75A86A147A1485（G3247）G5647G1319G16786计1G19036对水费收费管理G1461G5699G13007G13491的需G8726，G17902G17819对水费管理工作G17819G12255的G1881G4493G2656G6980G6466G8981G12255分G7524，G16786计如G991所G12046的G6980G6466项G2656G6980G6466G13479构G726G103水费基本G1461G5699，G2265G6336的G6980G6466项有G726水费类型，水费G10378G5589，G2345价等。G103新添用户基本G1461G5699，G2265G6336的G6980G6466项有G726用户户G2507，用户G4007名，地G3348，G6817作G2604G1461G5699等。G103G5062有用户基本G1461G5699，G2265G6336用户户G2507，用户G4007名，地G3348，基本水费G1461G5699，G6817作G2604等。G103G13479算G1461G5699，G2265G6336的G6980G6466项有G726用户户名，用户户G2507，地G3348，缴费G7388G1233，用水量，G5415G2081水价，缴费G6980G20081，缴费日G7411等。G103G13007G13491用户G1461G5699，G2265G6336的G6980G6466项有G726用户名，用户密G11733，用户G7447G19492。有G1114G990G19766的G6980G6466G13479构，G6980G6466项G2656G6980G6466G8981G12255，我G1216G4613能对G13007G13491进行G6980G6466G5223G16786计。2G13007G13491ERG3282如G991所G12046G726A74A75A86A79A80A149A80A150A15111A79A80A145A146A144A99A152A153A154A155A80A125A79A94A156A133A95A157A158A133A95A159A160A133A95A161A162A79A80A80A125A94A107A76A163A94A164A165A166A791NA164A165A99A167A152A153A154A155A79A80A147A148A79A80A99A74A75A74A75A74A751NNMMN63G17G7693G6466G40G16RG3282G17728G6454成关G13007G8181G5347如G991G726G14270来水G1856G2508（G1856G2508名称，G11017G16817，地G3348）管理G2604（用户名，用户密G11733，用户G7447G19492）用户（户G2507，G4007名，G11017G16817，地G3348）G17146户（用户户G2507，缴费日G7411，缴费G7388G1233，缴费G18341G20081，水价，用水量）G13868用（G14270来水G1856G2508，管理G2604）管理（G14270来水G1856G2508，G17146户）管理（管理G2604，G17146户）G23G6980G6466G5223G13479构G16786计G6980G6466G5223G2265G2559G1209G991表G726水费管理表、用户管理表、用户表、G5415G2081水价表G20）用户表G2265G2559管理G2604（G17241G13435用户或G7234G17902用户）的G4007名CHAR50、G11468应密G11733CHAR40及对应的G7447G19492CHAR40。用户表如（表一）G726A168A169A170A171A168A172A173A174A175A176A177A178A179A180A181A182A1831USERCHAR50A79A80A78A184A185A99A186A187A188A100A1892PASSWORDCHAR40A145A146A186A187A188A100A1893QXCHAR40A79A80A78A147A148A186A187A188A100A1892）用户管理表G2265G6336用户缴费的G5647户G2507INTA1904A191、用户G4007名VARCHARA19020A191、用户G4633G1315地VARCHARA19050A191G1209及用户G5415G7388所G1147G10995的费用CHAR40。用户管理表如（表G1120）G726A168A192A170A171A193A194A168A172A173A174A175A176A177A178A179A180A181A182A1831A195A80A125INTA1904A191A79A80A97A1252A80A99VARCHARA19020A191A79A80A144A993A154A155VARCHARA19050A191A79A80A196A197A198A1544A195A95A79CHAR40A79A80A94A95A195A159A1603）水费管理表是本G13007G13491的关键，用于水费缴费及G1866查G16822。G1866G2265G2559用户缴费的G5647户G2507INT4、用户G4007名VARCHAR20、用户G4633G1315地VARCHAR50等缴费G1461G5699的基本G1461G5699，G1209及用户G5415G7388所用的用水量INT4及G1147G10995的G5647费用CHAR40。如（表G989）所G12046G726A168A199A200A201A193A194A168A172A173A174A175A176A177A178A179A180A181A182A1831A195A80A125INT4A79A80A97A12572A80A99VARCHAR20A79A80A144A993A154A155VARCHAR50A79A80A196A197A198A1544A79A94A156INT4A79A80A202A161A196A79A78A94A1565A202A203A138A107CHAR40A202A161A94A95A107A1086A202A203A94A95CHAR40A79A80A204A133A95A131A1607A204A133A161A162DATEA133A95A161A1628A133A95A157A158DATEA133A95A157A158G23）G5415G2081水价表是对G5415G2081水费的G16786置。水价表G2265G6336G16786置的水费价格G1461G5699G1209及应缴费的G7388G1233记G5417。如G991（表G3247）所G12046G726A168A205A206A207A200A208A168A172A173A174A175A176A177A178A179A180A181A182A1831A107A108CHAR40A202A161A94A95A107A1082A204A133A161A162DATEA204A133A95A161A162四、测试与评价G13007G13491G4466现如G991G726G20）登G5417G12395G1319G41ORG80G20G20，如G3282所G12046G7262）G1039G11040G19766如G3282G12046G72683）G17146户管理G16786置页G19766G726G23）缴纳水费G4466现页G19766G726G24）查G16822缴费情况G7269G25）编G17765用户G11040G19766如G3282G12046G726G26）用户G8995G16284查G16822G11040G19766G72610G27）水费G16786置页G19766G28）G6265表G6183印页G19766如G3282所G12046G726五、结论G13475G17819一个G3822G7388的G16786计G2656G5332发，这个水费收费管理G1461G5699G13007G13491基本G4448成。G15441G9994有些G2163能还有些G19394G20076G8821有G16855试好，G11040G19766也G16786计得不是很美观，G1866G1025在水费缴费记G5417查G16822G1025对G5062缴用户，未缴用户，G1209及用户历史缴费记G5417G2163能不是很G4448G2904，对这些记G5417的G6183印清G2345不是很方便，在这方G19766还有待改进。在用户用水量的查G16822，用水量的G10995成方G19766G16786置的也不够G4448G2904。但在这G7411间借阅G1114大量有关G13007G13491G16786计的书籍，有G2345G10432G4570各个G8181G3371G16786计的，也有直接讲G13007G13491从早G7411G13007G13491分G7524G16786计G2052G4448成的，还看G1114G999G19388讲VB的书。G17902G17819参阅G1866G4439G13007G13491，从G1025找G2052与G14270G5061G13007G13491G11468关的进行拼凑，还有对各个控件的G16786置、熟悉，在连接G17819G12255G1025走G1114很G3822弯G17347，但是在一G17347的G8181仿G17819G12255G1025G14270G5061也逐渐懂得G1114如何进11行G11468关G6817作，不再像刚G5332G3999一头雾水，什么都不懂，也大概G11705道G1114如何G5332发一个G13007G13491，G14270G5061要G1582的是在今G2530的学G1076G17819G12255G1025进行G4448G2904，G7368G9157入地学G1076。在本G8437的G16850G12255G16786计G1025，为搞清控件的使用方法、编G12255的各个难点、G6496G6581G19766向对象的编G12255G5617想等很G3822方G19766的G19394G20076，G6177发现G4466G17353的重要性，尤G1866是要G14270G5061G10432G14270G4466G17353。六、致谢G17902G17819与指导老师的G1144G8981、G17902G17819G3282书G20314查看G11468关资G7021，我基本熟悉G1114整个G13007G13491的G1006G2165G8981G12255，这对G2530G7411的G5332发工作至关重要，在这里感谢我的指导老师彭G989城老师，是他教G1262G1114我整个G16786计G17819G12255的方法。G13475G17819整个G16850G12255G16786计G7411间的努G2159，我基本G990G4448成G1114我的G16850G20076，在此感谢学校G13485我G1216提供G1114舒G17878的工作、学G1076G10627境，G1209及彭老师G13485予的悉G5527关怀与指导。此G3818，同学G1216在我这G8437G16850G12255G16786计G1025也G13485G1114我很大的G5122助，我非常感谢。彭老师G16760真负责的工作G5589G5242、严谨的治学风格G1209及平G7143G17829G1166的为G1166，让我受益匪浅；G5332发的同G7114，G2656同学G1216G1055间的G11468互探讨也使我的G11705G16794G990G1114一个G2500阶。在这段G7114间里，我除G1114G444812成G1114G16850G12255G16786计，G7368重要的是学G2052G1114兢兢G1006G1006，奋发向G990的精神，这G12193精神是我今G2530G1166G10995G2081进道G17347G990的一G12193G2159量。再G8437感谢彭老师G1209及G13485G17819我G5122助的同学。附录源G1207G11733清G2345缴纳水费G8181G3371的G4466现G20G17G17828行G11040G19766G726132G17双击G11468应的控件，在控件的G11468应G17819G12255G1025编写G1207G11733G726G12395G1319的LOAD事件为G726PRIVATESUBG41ORG80_LOADG41ORG802G20G17WIDTHG263G240G41ORG802G20G17HEIGHTG263G28G24G41ORG802G20G17MOVEMDIG41ORG80G20G17WIDTHG16G41ORG802G20G17WIDTH/2,MDIG41ORG80G20G17HEIGHTG16G41ORG802G20G17HEIGHT/G23LABELG24G17CAPTIONDATEG40NDSUB作用G726使G12395G1319G4633G1025显G12046。的G1207G11733如G991G726PRIVATESUBCOG80G80AND2_CLICKSQL“SELECTFROG80用户管理WHEREG5647户G2507“TRIG80TEXTG200G17TEXT“14DATA3G17RECORDSOURCESQLDATA3G17REFRESHIFDATA3G17RECORDSETG17G40OG41THENMSGBOX“G8821有此G5647户G2507请重新G17767入G5647户G2507“,“提G12046“TEXTG200G17TEXT“TEXTG200G17SETG41OCUSG40LSEG41ORIG20TOG28LABELG20IG17VISIBLETRUENEXTIG41ORIG20TOG25TEXTG20IG17VISIBLETRUENEXTITEXTG27G17VISIBLETRUEDATAG20G17RECORDSETG17ADDNEWTEXTG20G26TEXTG25TEXTG20G20TEXT3TEXTG202TEXTG23TEXTG20G23TEXT2TEXTG20G25G17TEXTDATETEXTG203G17SETG41OCUSTEXTG27TEXTG26G40NDIFG40NDSUB作用G726先判断用户表G1025有G8821有此