论文标准WORD格式排版 共41页
摘 要
在计算机普及以前,小区主要用手工记账的方法管理电费财务,这种方式不仅浪费大量的人力、物力、财力,而且不适合管理和保存。随着计算机的广泛应用,大多数小区开始利用相关计算机系统来管理小区的电费财务,使得小区的电费管理更加高效,用户对电费的查询更加便捷。
在开发本系统时采用Visual Basic和Access 2000数据库软件作为程序主要开发工具,运用Visual Basic完成了程序的界面设计及主要功能的具体实现,运用Access 2000完成了数据库系统的具体设计。
该系统采用Visual Basic和ADO,实现用户用电信息的快捷录入;方便小区物业公司根据用户的实际用电情况进行登记,然后自动计算各用户的电费总额;欠费统计,以及现金交付情况,实现电费的批量收款,实现对用户用电情况、款项使用情况登记操作;并且提供给小区用户查询个人用电信息、打印有关电费报表等服务。
本文简要介绍了小区电费管理系统的设计思想,并概括地说明了该系统的功能及特点。该系统功能完善、界面友好、操作简单,具有综合查询和报表打印等功能,腀@浞致悴煌愦斡没枨蟆1鞠低车纳杓瓶煞治拘畔⒐芾怼⒔环压芾怼⑶贩压芾怼⑾低呈菸ぁ⒋蛴”ū硪约跋低彻芾淼?个模块。
本文介绍了小区电费管理系统的设计与开发的过程。从系统分析、系统总体设计、系统详细设计以及问题和前景等几个方面详细论述了整个系统的开发过程,遵循软件工程的方法。
关键词:Visual Basic 6.0,Access数据库,某小区电费管理系统,电费查询。
Abstract
Small areas manage finance in the way of hand-written record before computers become popular. It not only waste large amount of manpower, material resources and financial resources, but also doesn’t adapt to the management and storage. When computers become wide application, most of Small area began to apply computers to management electricity charges finance in small areas , feasible small area electric charge is managed especially high-effect, the consumer inquiry to electric charge is especially convenient and rapid
Management system is use the stand-alone version electric charge management system.To develop this system, the author use Visual Basic and Access2000 data bases software as the main development tools of this program. Visual Basic is used to realize the interface design and the specific realization of the main functions and Access2000 is used to accomplish the detail design of database system.
This system uses Visual Basic and ADO, realizing consumer uses electricity the situation information to input quickly; The convenient plot consumer management company according to the consumer the reality to use electricity the situation to carry on the registration, and then calculating voluntarily every consumer's electric charge; Manages various consumer to save the gold in advance, as well as the cash turnover situation, the realization electrical bill batch collection and the single pen charge, realizes to the consumer uses electricity the situation, the fund service condition registers the operation; Provides for the plot property convenience inquiry, the printing related electrical bill management report form.
This article briefly introduced “small area electrical bill management information system" design thought, and broadly showed this system function and the characteristic. This system function consummates, the contact surface friendly, the operation is simple, has the synthesis inquiry and the auxiliary decision power, can satisfy the different arrangement of ideas consumer need sufficiently.
KEY WORDS: Visual Basic,Access DataBase ,some plot electrical bill management system management system,electrical bill inquiry
目 录
前 言1
第1章 系统分析3
1.1需求分析3
1.1.1 系统目标3
1.1.2 数据流图3
1.1.3 系统流程图和功能分析4
1.2 系统可行性分析4
1.2.1 社会环境可行性4
1.2.2 技术可行性5
1.3 开发平台的选择5
1.3.1 编程环境的选择5
1.3.2 数据库的选择5
第2章 系统总体设计7
2.1 系统模块设计7
2.2 系统模块之间的关系8
2.3 数据库设计8
2.4本章小结11
第3章 系统详细设计12
3.1 登录模块及主界面设计12
3.2基本信息管理模块及界面设计13
3.2.1业主管理窗体设计13
3.2.2走表管理窗体设计14
3.3交费管理模块及界面设计15
3.3.1交费窗体设计15
3.3.2费用调整窗体设计18
3.3.3电费查询窗体的设计20
3.4欠费管理模块及界面设置22
3.4.1追缴电费窗体设计22
3.4.2欠费统计窗体的设计24
3.5系统数据维护25
3.5.1数据维护窗体的设计25
3.5.2初始化数据窗体的设计25
3.6系统管理模块及界面设计27
3.6.1 添加用户窗体的设计27
3.6.2 用户密码修改窗体的设计28
3.6.3 删除用户窗体的设计29
3.7本章小结29
第4章 问题与前景30
4.1所遇问题30
4.2系统中存在的问题31
4.3前景展望31
结 论33
谢 辞34
参考文献35
....