西苑小区电费管理系统设计.doc
约41页DOC格式手机打开展开
西苑小区电费管理系统设计,ÂÛÎıê×¼word¸ñʽÅÅ°æ ¹²41Ò³Õª Òª ÔÚ¼ÆËã»úÆÕ¼°ÒÔÇ°£¬Ð¡ÇøÖ÷ÒªÓÃÊÖ¹¤¼ÇÕ˵ķ½·¨¹ÜÀíµç·Ñ²ÆÎñ£¬ÕâÖÖ·½Ê½²»½öÀË·Ñ´óÁ¿µÄÈËÁ¦¡¢ÎïÁ¦¡¢²ÆÁ¦£¬¶øÇÒ²»ÊʺϹÜÀíºÍ±£´æ¡£Ëæ׿ÆËã»...
内容介绍
此文档由会员 莎士比亚 发布
ÂÛÎıê×¼WORD¸ñʽÅÅ°æ ¹²41Ò³
Õª Òª
ÔÚ¼ÆËã»úÆÕ¼°ÒÔÇ°£¬Ð¡ÇøÖ÷ÒªÓÃÊÖ¹¤¼ÇÕ˵ķ½·¨¹ÜÀíµç·Ñ²ÆÎñ£¬ÕâÖÖ·½Ê½²»½öÀË·Ñ´óÁ¿µÄÈËÁ¦¡¢ÎïÁ¦¡¢²ÆÁ¦£¬¶øÇÒ²»ÊʺϹÜÀíºÍ±£´æ¡£Ëæ׿ÆËã»úµÄ¹ã·ºÓ¦Ó㬴ó¶àÊýСÇø¿ªÊ¼ÀûÓÃÏà¹Ø¼ÆËã»úϵͳÀ´¹ÜÀíСÇøµÄµç·Ñ²ÆÎñ£¬Ê¹µÃСÇøµÄµç·Ñ¹ÜÀí¸ü¼Ó¸ßЧ£¬Óû§¶Ôµç·ÑµÄ²éѯ¸ü¼Ó±ã½Ý¡£
ÔÚ¿ª·¢±¾ÏµÍ³Ê±²ÉÓÃVisual BasicºÍAccess 2000Êý¾Ý¿âÈí¼þ×÷Ϊ³ÌÐòÖ÷Òª¿ª·¢¹¤¾ß£¬ÔËÓÃVisual BasicÍê³ÉÁ˳ÌÐòµÄ½çÃæÉè¼Æ¼°Ö÷Òª¹¦ÄܵľßÌåʵÏÖ,ÔËÓÃAccess 2000Íê³ÉÁËÊý¾Ý¿âϵͳµÄ¾ßÌåÉè¼Æ¡£
¸Ãϵͳ²ÉÓÃVisual BasicºÍADO£¬ÊµÏÖÓû§ÓõçÐÅÏ¢µÄ¿ì½Ý¼È룻·½±ãСÇøÎïÒµ¹«Ë¾¸ù¾ÝÓû§µÄʵ¼ÊÓõçÇé¿ö½øÐеǼǣ¬È»ºó×Ô¶¯¼ÆËã¸÷Óû§µÄµç·Ñ×ܶǷ·Ñͳ¼Æ£¬ÒÔ¼°Ïֽ𽻸¶Çé¿ö£¬ÊµÏÖµç·ÑµÄÅúÁ¿ÊտʵÏÖ¶ÔÓû§ÓõçÇé¿ö¡¢¿îÏîʹÓÃÇé¿öµÇ¼Ç²Ù×÷£»²¢ÇÒÌṩ¸øСÇøÓû§²éѯ¸öÈËÓõçÐÅÏ¢¡¢´òÓ¡Óйصç·Ñ±¨±íµÈ·þÎñ¡£
±¾ÎļòÒª½éÉÜÁËСÇøµç·Ñ¹ÜÀíϵͳµÄÉè¼Æ˼Ï룬²¢¸ÅÀ¨µØ˵Ã÷Á˸ÃϵͳµÄ¹¦Äܼ°Ìص㡣¸Ãϵͳ¹¦ÄÜÍêÉÆ¡¢½çÃæÓѺᢲÙ×÷¼òµ¥£¬¾ßÓÐ×ۺϲéѯºÍ±¨±í´òÓ¡µÈ¹¦ÄÜ£¬Ä@@ä·ÖÂú×㲻ͬ²ã´ÎÓû§ÐèÇó¡£±¾ÏµÍ³µÄÉè¼Æ¿É·ÖΪ»ù±¾ÐÅÏ¢¹ÜÀí¡¢½»·Ñ¹ÜÀí¡¢Ç··Ñ¹ÜÀí¡¢ÏµÍ³Êý¾Ýά»¤¡¢´òÓ¡±¨±íÒÔ¼°ÏµÍ³¹ÜÀíµÈ6¸öÄ£¿é¡£
±¾ÎĽéÉÜÁËСÇøµç·Ñ¹ÜÀíϵͳµÄÉè¼ÆÓ뿪·¢µÄ¹ý³Ì¡£´Óϵͳ·ÖÎö¡¢ÏµÍ³×ÜÌåÉè¼Æ¡¢ÏµÍ³ÏêϸÉè¼ÆÒÔ¼°ÎÊÌâºÍÇ°¾°µÈ¼¸¸ö·½ÃæÏêϸÂÛÊöÁËÕû¸öϵͳµÄ¿ª·¢¹ý³Ì£¬×ñÑÈí¼þ¹¤³ÌµÄ·½·¨¡£
¹Ø¼ü´Ê£º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
....
Õª Òª
ÔÚ¼ÆËã»úÆÕ¼°ÒÔÇ°£¬Ð¡ÇøÖ÷ÒªÓÃÊÖ¹¤¼ÇÕ˵ķ½·¨¹ÜÀíµç·Ñ²ÆÎñ£¬ÕâÖÖ·½Ê½²»½öÀË·Ñ´óÁ¿µÄÈËÁ¦¡¢ÎïÁ¦¡¢²ÆÁ¦£¬¶øÇÒ²»ÊʺϹÜÀíºÍ±£´æ¡£Ëæ׿ÆËã»úµÄ¹ã·ºÓ¦Ó㬴ó¶àÊýСÇø¿ªÊ¼ÀûÓÃÏà¹Ø¼ÆËã»úϵͳÀ´¹ÜÀíСÇøµÄµç·Ñ²ÆÎñ£¬Ê¹µÃСÇøµÄµç·Ñ¹ÜÀí¸ü¼Ó¸ßЧ£¬Óû§¶Ôµç·ÑµÄ²éѯ¸ü¼Ó±ã½Ý¡£
ÔÚ¿ª·¢±¾ÏµÍ³Ê±²ÉÓÃVisual BasicºÍAccess 2000Êý¾Ý¿âÈí¼þ×÷Ϊ³ÌÐòÖ÷Òª¿ª·¢¹¤¾ß£¬ÔËÓÃVisual BasicÍê³ÉÁ˳ÌÐòµÄ½çÃæÉè¼Æ¼°Ö÷Òª¹¦ÄܵľßÌåʵÏÖ,ÔËÓÃAccess 2000Íê³ÉÁËÊý¾Ý¿âϵͳµÄ¾ßÌåÉè¼Æ¡£
¸Ãϵͳ²ÉÓÃVisual BasicºÍADO£¬ÊµÏÖÓû§ÓõçÐÅÏ¢µÄ¿ì½Ý¼È룻·½±ãСÇøÎïÒµ¹«Ë¾¸ù¾ÝÓû§µÄʵ¼ÊÓõçÇé¿ö½øÐеǼǣ¬È»ºó×Ô¶¯¼ÆËã¸÷Óû§µÄµç·Ñ×ܶǷ·Ñͳ¼Æ£¬ÒÔ¼°Ïֽ𽻸¶Çé¿ö£¬ÊµÏÖµç·ÑµÄÅúÁ¿ÊտʵÏÖ¶ÔÓû§ÓõçÇé¿ö¡¢¿îÏîʹÓÃÇé¿öµÇ¼Ç²Ù×÷£»²¢ÇÒÌṩ¸øСÇøÓû§²éѯ¸öÈËÓõçÐÅÏ¢¡¢´òÓ¡Óйصç·Ñ±¨±íµÈ·þÎñ¡£
±¾ÎļòÒª½éÉÜÁËСÇøµç·Ñ¹ÜÀíϵͳµÄÉè¼Æ˼Ï룬²¢¸ÅÀ¨µØ˵Ã÷Á˸ÃϵͳµÄ¹¦Äܼ°Ìص㡣¸Ãϵͳ¹¦ÄÜÍêÉÆ¡¢½çÃæÓѺᢲÙ×÷¼òµ¥£¬¾ßÓÐ×ۺϲéѯºÍ±¨±í´òÓ¡µÈ¹¦ÄÜ£¬Ä@@ä·ÖÂú×㲻ͬ²ã´ÎÓû§ÐèÇó¡£±¾ÏµÍ³µÄÉè¼Æ¿É·ÖΪ»ù±¾ÐÅÏ¢¹ÜÀí¡¢½»·Ñ¹ÜÀí¡¢Ç··Ñ¹ÜÀí¡¢ÏµÍ³Êý¾Ýά»¤¡¢´òÓ¡±¨±íÒÔ¼°ÏµÍ³¹ÜÀíµÈ6¸öÄ£¿é¡£
±¾ÎĽéÉÜÁËСÇøµç·Ñ¹ÜÀíϵͳµÄÉè¼ÆÓ뿪·¢µÄ¹ý³Ì¡£´Óϵͳ·ÖÎö¡¢ÏµÍ³×ÜÌåÉè¼Æ¡¢ÏµÍ³ÏêϸÉè¼ÆÒÔ¼°ÎÊÌâºÍÇ°¾°µÈ¼¸¸ö·½ÃæÏêϸÂÛÊöÁËÕû¸öϵͳµÄ¿ª·¢¹ý³Ì£¬×ñÑÈí¼þ¹¤³ÌµÄ·½·¨¡£
¹Ø¼ü´Ê£º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
....
