基于GSM的水、电、气无线远程抄表系统
摘要
社区物业管理中的水、电、气收费是一项费时、费力、繁琐而单调的工作,又是一项运算量大,运算准确度要求高,容易产生纠纷的工作。为了能够实现物业管理部门对小区住户的水、电、气用量的自动远程无线抄收,本文针对常见的物业管理小区设计了一种基于GSM(Global system for mobile communications)公众网的水、电、气远程无线抄表系统。该系统的设计主要包括两个组成部分,即远程抄表硬件系统的设计和远程抄表管理信息系统的设计。
本文的主要工作和创新点如下:
1、本文给出了一种基于GSM技术的物业小区远程无线抄表系统的硬件设计,并对其无线通信设备TC35T(GSM通信模块)在该系统中的设计使用作了详细论述。通过这样的一种硬件设计,远程抄表数据以短信息的方式通过串口传送至计算机中。并用VC++6.0进行了串行通信编程设计。
2、在常见的物业小区抄表管理模式的基础上,本文给出了基于GSM的小区远程抄表管理信息系统的设计过程,包括系统的功能模块设计和数据库的设计等。在功能模块设计方面,它遵循典型物业小区的现状,设计了四个主要的功能模块,分别是“基本档案管理子系统”、“抄表管理子系统”、“统计分析子系统”和“系统管理”;系统数据库设计严格遵循概念设计、逻辑设计和物理设计几个重要阶段,在数据库的设计中还介绍了视图和存储过程的使用,它们的使用提高了系统性能和开发系统的效率。经过这样的一个设计过程,使得开发出的水、电、气远程抄表管理信息系统具有实用性、通用性、先进性、安全性和可扩展性的特点。
3、本文所设计的抄表管理信息系统的开发工具选择了微软最新推出的.NET技术,在ASP.NET框架下,用C#语言编写开发;数据访问技术采用ADO.NET;数据库管理系统则采用SQL SERVER2000;构建了一个B/S结构的管理信息系统。不仅如此,文章还对使用ASP.NET所设计的抄表管理信息系统的安全控制作了详细的论述,它包括基于表单的验证和基于角色的授权,同时给出了登陆页面的设计。另外,在ADO.NET数据访问技术的基础上,文章还设计了一个通用的数据访问类,使用该类,数据访问方面的编程变得更加方便快捷。
系统设计采用了先进的网络技术和通讯手段,系统的稳定性、可靠性、安全性都十分良好,得到用户的好评,并且带来可观的经济效益。
Water, electricity and gas's consumption charging of community's estate management is a time-consuming, strenuous, tedious and dull work. It is also a work of operation amount great and operation accuracy expected much, which influences society and benefits the dispute. In order to realize the wireless remote meter reading system for water, electricity and gas's consumption of every household in the estate management district and accept it automatically, this thesis designs a wireless remote meter reading system based on GSM public network. The design of this system includes two components mainly, one is the hardware and the other is the management information system..
The main work and innovation of this thesis are introduced as follows:
1. The thesis provides a hardware design for remote meter reading system of the common estate management district based on GSM technology. It also provides the way of how to design and use the wireless communication equipment TC35T (GSM communication module) in detail. In this hardware design, the data of all meters are conveyed to the computer through the serial communication by way of short message. And the program of the serial communication is developed in VC++6.0.
2. Based on the common management mode of estate districts, the thesis provides the design process of the remote meter reading management information system, including the design of systematic function module and database. In respect of the function module design, it follows the current situation of the common estate district, and designs four pieces of main function modules including " basic file administration subsystem " , " meter reading and management subsystem " , " statistical analysis subsystem " and " system management "; In design of the database, several important stages ,namely Concept design phase , Logic design phase and Physics design phase, are followed strictly. Meanwhile the use of the view and storing process is also introduced to improve systematic function and the efficiency of developing the system. Through such a design process, the management information system has been made to be practical, common, advanced, secure and expansible.
3. The meter reading management information system presented this thesis is developed with the .NET technology and ASP.NET frame and coded in C# language which were put out newly by Microsoft. And the data access technology is adopted in ADO.NET, the DBMS is adopted in SQL SERVER2000. In this way, a management information system with B/S structure is achieved. Moreover, the thesis presents the security of the management information system which is designed with ASP.NET, including the verification based on form and mandate based on roles. The logon page design is also presented. In addition, the thesis designs a general data access class, which makes the programming of data access more convenient and more swift. In a word, as a trial development with .NET developing platform, the development of this management information system can be a good reference to the development of other similar systems.
Because advanced network technology and communications method are employed, the system is stable, reliable and secure. Favorable comments have been given by users and considerable economic returns have been obtained.
本文的主要工作和创新点如下:
1、本文给出了一种基于GSM技术的物业小区远程无线抄表系统的硬件设计,并对其无线通信设备TC35T(GSM通信模块)在该系统中的设计使用作了详细论述。通过这样的一种硬件设计,远程抄表数据以短信息的方式通过串口传送至计算机中。并用VC++6.0进行了串行通信编程设计。
2、在常见的物业小区抄表管理模式的基础上,本文给出了基于GSM的小区远程抄表管理信息系统的设计过程,包括系统的功能模块设计和数据库的设计等。在功能模块设计方面,它遵循典型物业小区的现状,设计了四个主要的功能模块,分别是“基本档案管理子系统”、“抄表管理子系统”、“统计分析子系统”和“系统管理”;系统数据库设计严格遵循概念设计、逻辑设计和物理设计几个重要阶段,在数据库的设计中还介绍了视图和存储过程的使用,它们的使用提高了系统性能和开发系统的效率。经过这样的一个设计过程,使得开发出的水、电、气远程抄表管理信息系统具有实用性、通用性、先进性、安全性和可扩展性的特点。
3、本文所设计的抄表管理信息系统的开发工具选择了微软最新推出的.NET技术,在ASP.NET框架下,用C#语言编写开发;数据访问技术采用ADO.NET;数据库管理系统则采用SQL SERVER2000;构建了一个B/S结构的管理信息系统。不仅如此,文章还对使用ASP.NET所设计的抄表管理信息系统的安全控制作了详细的论述,它包括基于表单的验证和基于角色的授权,同时给出了登陆页面的设计。另外,在ADO.NET数据访问技术的基础上,文章还设计了一个通用的数据访问类,使用该类,数据访问方面的编程变得更加方便快捷。
系统设计采用了先进的网络技术和通讯手段,系统的稳定性、可靠性、安全性都十分良好,得到用户的好评,并且带来可观的经济效益。
Water, electricity and gas's consumption charging of community's estate management is a time-consuming, strenuous, tedious and dull work. It is also a work of operation amount great and operation accuracy expected much, which influences society and benefits the dispute. In order to realize the wireless remote meter reading system for water, electricity and gas's consumption of every household in the estate management district and accept it automatically, this thesis designs a wireless remote meter reading system based on GSM public network. The design of this system includes two components mainly, one is the hardware and the other is the management information system..
The main work and innovation of this thesis are introduced as follows:
1. The thesis provides a hardware design for remote meter reading system of the common estate management district based on GSM technology. It also provides the way of how to design and use the wireless communication equipment TC35T (GSM communication module) in detail. In this hardware design, the data of all meters are conveyed to the computer through the serial communication by way of short message. And the program of the serial communication is developed in VC++6.0.
2. Based on the common management mode of estate districts, the thesis provides the design process of the remote meter reading management information system, including the design of systematic function module and database. In respect of the function module design, it follows the current situation of the common estate district, and designs four pieces of main function modules including " basic file administration subsystem " , " meter reading and management subsystem " , " statistical analysis subsystem " and " system management "; In design of the database, several important stages ,namely Concept design phase , Logic design phase and Physics design phase, are followed strictly. Meanwhile the use of the view and storing process is also introduced to improve systematic function and the efficiency of developing the system. Through such a design process, the management information system has been made to be practical, common, advanced, secure and expansible.
3. The meter reading management information system presented this thesis is developed with the .NET technology and ASP.NET frame and coded in C# language which were put out newly by Microsoft. And the data access technology is adopted in ADO.NET, the DBMS is adopted in SQL SERVER2000. In this way, a management information system with B/S structure is achieved. Moreover, the thesis presents the security of the management information system which is designed with ASP.NET, including the verification based on form and mandate based on roles. The logon page design is also presented. In addition, the thesis designs a general data access class, which makes the programming of data access more convenient and more swift. In a word, as a trial development with .NET developing platform, the development of this management information system can be a good reference to the development of other similar systems.
Because advanced network technology and communications method are employed, the system is stable, reliable and secure. Favorable comments have been given by users and considerable economic returns have been obtained.
引文
[1]王月志,刘伯刚.自动抄表系统[J].电测与仪表,2004,41(9):48—51
[2]崔静安,赵峰,王艳伟.GSM远程抄表系统[J].电力需求侧管理,2002,4(4):43—44
[3]孙龙杰,刘利康,张麟兮.移动通信与终端设备[M].北京,电子工业出版社,2003
[4]朱光喜,张耀华.如何解析GSM短消息[J].通信技术,2003,(3):54—56
[5]徐伟.管理信息系统战略规划[J].中国财经政法大学学报,2004,(1):125—128
[6]艾迪明..NET框架体系结构[J].计算机工程与应用,2003,(2):174—176
[7]何伟,杨愚非,訾虎..NET和J2EE的崛起与抗衡[J].中国金融电脑,2004,(4):68—71
[8]孙俊,李正明,杨继昌.ASP技术与ASP.NET技术的比较[J].微型机与应用,2003,(1):6—7
[9]林伟军.浅谈ASP.NET应用程序的三层结构及安全性[J].现代计算机,2004,(11):21—24
[10]梅中辉,经亚枝..NET中的数据访问技术—ADO.NET[J].微计算机信息,2003,19(1):70
[11]王宝祥.基于ADO.NET的数据访问技术研究[J].计算机应用与软件,2004,21(2):120—122
[12]樊建.ASP.NET+ADO.NET项目开发实例[M].北京,清华大学出版社,2004
[13]刘烨,吴中元.C#编程及应用程序开发教程[M].北京,清华大学出版社,2003
[14]章立民.SQL SERVER 2000中文版完整实战[M].北京,中国铁道出版社,2001
[15]童恒庆,梅清.基于.NET平台的B/S系统开发框架的研究[J].微机发展,2004,14(8):61—66
[16]王伟.用ODBC技术实现串口数据实时处理[J].农机化研究,2003,(4):216—217
[17]路英娟.TCP/IP协议小议[J].科技情报开发与经济,2004,14(6):220—221
[18]戴湘.简述企业管理信息系统的数据库设计[J].电脑知识与认证考试,2004,(11):76—77
[19]马耿,张军,贾丙帅.测控系统的RS485总线研究[J].济南大学学报,2004,18(4):328—331
[20]Saravanan,N.,Sreenivasulu,N.,Jayaram,D.,Chockalingam,A..Design and Performance Evaluation of an Inter-System Handover Algorithm in UMTS/GSM Networks.TENCON 2005 2005 IEEE Region 10.2005:1 - 6.
[21]Jan Axeleson著;精英科技译.串行端口大全[M].北京,中国电力出版社,2004
[22]TC35/TC37 Hardware Interface Description http://www.siemens.com
[23]Siemens TC35 Terminal User Guide http://www.siemens.com/wm
[24]AT-Commands for GSM-Engine TC35 http://www.siemens.de
[25]余臻.基于AT指令集的远程通信的实现[J].厦门大学学报,2004,43(2):166—169
[26]Nousbaum,F.,Brouet,J..Performance of a self-organizing GSM based system with distributed coverage for high density indoor applications.Vehicular Technology Conference,1999.VTC 1999- Fall.IEEE VTS 50th Volume 2,1999:1258- 1262.
[27]宣彩平,王皓,邹国良.利用GSM无线模块发送短消息[J].计算机应用,2004,24(5):148—150
[28]Liting Cao,Jingwen Tian,Dahang Zhang.Networked remote meter-reading system based on wireless communication technology;information acquisition,2006 IEEE International Conference on.2006:172-176.
[20]张云,熊承燕.基于GSM的短消息业务协议分析[J].无线通信技术,2001,(3):38—41
[30]李现勇.VC++串口通信技术与工程实践[M].北京,人民邮电出版社,2002
[31]Yanmin Song,Guoqing Tang,Zhenglin Yang,Jun Hu.The Technical implementation of the electricity market operation system.Transmission and Distribution Conference and Exhibition:Asia and Pacific,2005 IEEE/PES.2005:1-6.
[32]韩中合,丁常富,齐凤慧.用Active X控件实现串口通信编程[J].山东电力技术,2003,(2):15-17
[33]袁航,周瑛,周太勋.用中断方式实现串口通讯技术[J].起重运输机械,2003,(10):17-18
[34]施伯乐,丁宝康,汪卫.数据库系统教程[M].北京,高等教育出版社,2003
[35]Meyer,U.,Wetzel,S..On the impact of GSM encryption and man-in-the-middle attacks on the security of interoperating GSM/UMTS networks.Personal,Indoor and Mobile Radio Communications.PIMRC.15th IEEE International Symposium,2004:2876-2883.
[36]张世庆.关系数据库设计中关系范式的使用[J].丹东纺专学报,2004,11(2):9-10
[37]Paul Nielsen著;刘瑞,陈微,闫继忠,刘文译.Microsoft SQL SERVER 2000宝典[M].北京,中国铁道出版社,2004
[38]郭再新.数据库完整性设计[J].南京广播大学学报,2000,(2):68-72
[39]Masoud,F.A.,Halabi,D.H..ASP.NET and JSP Frameworks in model view controller Iimplementation.Information and Communication Technologies. ICTTA '06.2nd.2006:3593-3598.
[40]Zhenguo Qian,Pancheng Wang,Liqiang Zhang,Chongjun Yang.OpenGIS WMS implementation and its integrated application using ASP.NET.Geoscience and Remote Sensing Symposium,2004.IGARSS '04.Proceedings.IEEE International,2004:2953-2956.
[41]桑德里克著;陈浩奎,谢俊,石朝江译.SQL SERVER 2000存储过程与XML编程[M].北京,清华大学出版社,2004
[42]Stephen Walther著;杨涛译.ASRNET揭秘[M].北京,中国电力出版社,2004
[43]Navarro,J.;Martinez,J.;Romero,J.Signaling capacity in GSM &(E)GPRS networks.Vehicular Technology Conference,2002.VTC Spring 2002.IEEE 55th.2002:1970-1974.
[44]桂学勤,余英宏.ASP.NET安全性工作方案和窗体身份验证的实现[J].微计算机应用,2005,26(1):49-52
[45]章立民.用实例学ASP.NET[M].北京,电子工业出版社,2004
[46]刘发明,黄良英.加密口令在ASP.NET中的实现[J].赣南师范学院学报,2004,(3):50-51
[47]Li Zhang;Chongquan Zhong;Chao Sun;Li,D.Development of Intelligent Design System for Small Transformer Based on B/S Mode.Intelligent Control and Automation,2006.WCICA 2006.The Sixth World Congress on Volume 2,21-23 June 2006 Page(s):7523-7526
[48]孟繁兴,李继宏.浅谈ADO.NET中的数据访问方式[J].洛阳大学学报,2004,19(4):57-60
[49]张海潘.软件工程导论[M].北京,清华大学出版社,2003
[50]Bregni,S.;Barbieri,L.Experimental evaluation of the impact of network frequency synchronization on GSM quality of service during handover.Global Telecommunications Conference.GLOBECOM '03.IEEE,2003:3457-3461.
[51]吴洁明,袁山龙.软件工程应用实践教程[M].北京,清华大学出版社, 2003
[52]阮俊杰.软件开发方法与管理教程[M].北京,海洋出版社,2003
[53]Jesse Liberty;康博创作室译.21天学通C++[M].北京,人民邮电出版社,2002
[54]李明刚,肖建.ASP.NET WEB站点高级编程范例[M].北京,清华大学出版社,2003
[2]崔静安,赵峰,王艳伟.GSM远程抄表系统[J].电力需求侧管理,2002,4(4):43—44
[3]孙龙杰,刘利康,张麟兮.移动通信与终端设备[M].北京,电子工业出版社,2003
[4]朱光喜,张耀华.如何解析GSM短消息[J].通信技术,2003,(3):54—56
[5]徐伟.管理信息系统战略规划[J].中国财经政法大学学报,2004,(1):125—128
[6]艾迪明..NET框架体系结构[J].计算机工程与应用,2003,(2):174—176
[7]何伟,杨愚非,訾虎..NET和J2EE的崛起与抗衡[J].中国金融电脑,2004,(4):68—71
[8]孙俊,李正明,杨继昌.ASP技术与ASP.NET技术的比较[J].微型机与应用,2003,(1):6—7
[9]林伟军.浅谈ASP.NET应用程序的三层结构及安全性[J].现代计算机,2004,(11):21—24
[10]梅中辉,经亚枝..NET中的数据访问技术—ADO.NET[J].微计算机信息,2003,19(1):70
[11]王宝祥.基于ADO.NET的数据访问技术研究[J].计算机应用与软件,2004,21(2):120—122
[12]樊建.ASP.NET+ADO.NET项目开发实例[M].北京,清华大学出版社,2004
[13]刘烨,吴中元.C#编程及应用程序开发教程[M].北京,清华大学出版社,2003
[14]章立民.SQL SERVER 2000中文版完整实战[M].北京,中国铁道出版社,2001
[15]童恒庆,梅清.基于.NET平台的B/S系统开发框架的研究[J].微机发展,2004,14(8):61—66
[16]王伟.用ODBC技术实现串口数据实时处理[J].农机化研究,2003,(4):216—217
[17]路英娟.TCP/IP协议小议[J].科技情报开发与经济,2004,14(6):220—221
[18]戴湘.简述企业管理信息系统的数据库设计[J].电脑知识与认证考试,2004,(11):76—77
[19]马耿,张军,贾丙帅.测控系统的RS485总线研究[J].济南大学学报,2004,18(4):328—331
[20]Saravanan,N.,Sreenivasulu,N.,Jayaram,D.,Chockalingam,A..Design and Performance Evaluation of an Inter-System Handover Algorithm in UMTS/GSM Networks.TENCON 2005 2005 IEEE Region 10.2005:1 - 6.
[21]Jan Axeleson著;精英科技译.串行端口大全[M].北京,中国电力出版社,2004
[22]TC35/TC37 Hardware Interface Description http://www.siemens.com
[23]Siemens TC35 Terminal User Guide http://www.siemens.com/wm
[24]AT-Commands for GSM-Engine TC35 http://www.siemens.de
[25]余臻.基于AT指令集的远程通信的实现[J].厦门大学学报,2004,43(2):166—169
[26]Nousbaum,F.,Brouet,J..Performance of a self-organizing GSM based system with distributed coverage for high density indoor applications.Vehicular Technology Conference,1999.VTC 1999- Fall.IEEE VTS 50th Volume 2,1999:1258- 1262.
[27]宣彩平,王皓,邹国良.利用GSM无线模块发送短消息[J].计算机应用,2004,24(5):148—150
[28]Liting Cao,Jingwen Tian,Dahang Zhang.Networked remote meter-reading system based on wireless communication technology;information acquisition,2006 IEEE International Conference on.2006:172-176.
[20]张云,熊承燕.基于GSM的短消息业务协议分析[J].无线通信技术,2001,(3):38—41
[30]李现勇.VC++串口通信技术与工程实践[M].北京,人民邮电出版社,2002
[31]Yanmin Song,Guoqing Tang,Zhenglin Yang,Jun Hu.The Technical implementation of the electricity market operation system.Transmission and Distribution Conference and Exhibition:Asia and Pacific,2005 IEEE/PES.2005:1-6.
[32]韩中合,丁常富,齐凤慧.用Active X控件实现串口通信编程[J].山东电力技术,2003,(2):15-17
[33]袁航,周瑛,周太勋.用中断方式实现串口通讯技术[J].起重运输机械,2003,(10):17-18
[34]施伯乐,丁宝康,汪卫.数据库系统教程[M].北京,高等教育出版社,2003
[35]Meyer,U.,Wetzel,S..On the impact of GSM encryption and man-in-the-middle attacks on the security of interoperating GSM/UMTS networks.Personal,Indoor and Mobile Radio Communications.PIMRC.15th IEEE International Symposium,2004:2876-2883.
[36]张世庆.关系数据库设计中关系范式的使用[J].丹东纺专学报,2004,11(2):9-10
[37]Paul Nielsen著;刘瑞,陈微,闫继忠,刘文译.Microsoft SQL SERVER 2000宝典[M].北京,中国铁道出版社,2004
[38]郭再新.数据库完整性设计[J].南京广播大学学报,2000,(2):68-72
[39]Masoud,F.A.,Halabi,D.H..ASP.NET and JSP Frameworks in model view controller Iimplementation.Information and Communication Technologies. ICTTA '06.2nd.2006:3593-3598.
[40]Zhenguo Qian,Pancheng Wang,Liqiang Zhang,Chongjun Yang.OpenGIS WMS implementation and its integrated application using ASP.NET.Geoscience and Remote Sensing Symposium,2004.IGARSS '04.Proceedings.IEEE International,2004:2953-2956.
[41]桑德里克著;陈浩奎,谢俊,石朝江译.SQL SERVER 2000存储过程与XML编程[M].北京,清华大学出版社,2004
[42]Stephen Walther著;杨涛译.ASRNET揭秘[M].北京,中国电力出版社,2004
[43]Navarro,J.;Martinez,J.;Romero,J.Signaling capacity in GSM &(E)GPRS networks.Vehicular Technology Conference,2002.VTC Spring 2002.IEEE 55th.2002:1970-1974.
[44]桂学勤,余英宏.ASP.NET安全性工作方案和窗体身份验证的实现[J].微计算机应用,2005,26(1):49-52
[45]章立民.用实例学ASP.NET[M].北京,电子工业出版社,2004
[46]刘发明,黄良英.加密口令在ASP.NET中的实现[J].赣南师范学院学报,2004,(3):50-51
[47]Li Zhang;Chongquan Zhong;Chao Sun;Li,D.Development of Intelligent Design System for Small Transformer Based on B/S Mode.Intelligent Control and Automation,2006.WCICA 2006.The Sixth World Congress on Volume 2,21-23 June 2006 Page(s):7523-7526
[48]孟繁兴,李继宏.浅谈ADO.NET中的数据访问方式[J].洛阳大学学报,2004,19(4):57-60
[49]张海潘.软件工程导论[M].北京,清华大学出版社,2003
[50]Bregni,S.;Barbieri,L.Experimental evaluation of the impact of network frequency synchronization on GSM quality of service during handover.Global Telecommunications Conference.GLOBECOM '03.IEEE,2003:3457-3461.
[51]吴洁明,袁山龙.软件工程应用实践教程[M].北京,清华大学出版社, 2003
[52]阮俊杰.软件开发方法与管理教程[M].北京,海洋出版社,2003
[53]Jesse Liberty;康博创作室译.21天学通C++[M].北京,人民邮电出版社,2002
[54]李明刚,肖建.ASP.NET WEB站点高级编程范例[M].北京,清华大学出版社,2003