CN204809986U - Transmission line patrols and examines management system based on GPRS wireless transmission - Google Patents

Transmission line patrols and examines management system based on GPRS wireless transmission Download PDF

Info

Publication number
CN204809986U
CN204809986U CN201520395570.5U CN201520395570U CN204809986U CN 204809986 U CN204809986 U CN 204809986U CN 201520395570 U CN201520395570 U CN 201520395570U CN 204809986 U CN204809986 U CN 204809986U
Authority
CN
China
Prior art keywords
pin
connects
msp430f149
ground connection
serial
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Withdrawn - After Issue
Application number
CN201520395570.5U
Other languages
Chinese (zh)
Inventor
徐大伟
张洪峰
赵建伟
程煜萌
刘安迪
肖凡
王�锋
商建鑫
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
State Grid Corp of China SGCC
Jinan Power Supply Co of State Grid Shandong Electric Power Co Ltd
Original Assignee
State Grid Corp of China SGCC
Jinan Power Supply Co of State Grid Shandong Electric Power Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by State Grid Corp of China SGCC, Jinan Power Supply Co of State Grid Shandong Electric Power Co Ltd filed Critical State Grid Corp of China SGCC
Priority to CN201520395570.5U priority Critical patent/CN204809986U/en
Application granted granted Critical
Publication of CN204809986U publication Critical patent/CN204809986U/en
Withdrawn - After Issue legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02BCLIMATE CHANGE MITIGATION TECHNOLOGIES RELATED TO BUILDINGS, e.g. HOUSING, HOUSE APPLIANCES OR RELATED END-USER APPLICATIONS
    • Y02B90/00Enabling technologies or technologies with a potential or indirect contribution to GHG emissions mitigation
    • Y02B90/20Smart grids as enabling technology in buildings sector
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y04INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
    • Y04SSYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
    • Y04S40/00Systems for electrical power generation, transmission, distribution or end-user application management characterised by the use of communication or information technologies, or communication or information technology specific aspects supporting them
    • Y04S40/12Systems for electrical power generation, transmission, distribution or end-user application management characterised by the use of communication or information technologies, or communication or information technology specific aspects supporting them characterised by data transport means between the monitoring, controlling or managing units and monitored, controlled or operated electrical equipment
    • Y04S40/126Systems for electrical power generation, transmission, distribution or end-user application management characterised by the use of communication or information technologies, or communication or information technology specific aspects supporting them characterised by data transport means between the monitoring, controlling or managing units and monitored, controlled or operated electrical equipment using wireless data transmission
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y04INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
    • Y04SSYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
    • Y04S40/00Systems for electrical power generation, transmission, distribution or end-user application management characterised by the use of communication or information technologies, or communication or information technology specific aspects supporting them
    • Y04S40/12Systems for electrical power generation, transmission, distribution or end-user application management characterised by the use of communication or information technologies, or communication or information technology specific aspects supporting them characterised by data transport means between the monitoring, controlling or managing units and monitored, controlled or operated electrical equipment
    • Y04S40/128Systems for electrical power generation, transmission, distribution or end-user application management characterised by the use of communication or information technologies, or communication or information technology specific aspects supporting them characterised by data transport means between the monitoring, controlling or managing units and monitored, controlled or operated electrical equipment involving the use of Internet protocol

Abstract

The utility model provides a transmission line patrols and examines management system based on GPRS wireless transmission, is including patrolling and examining the appearance, it loops through GPRS communications network and electric power system local lan connection service ware to patrol and examine the appearance, the server passes through electric power system local lan and connects the customer end, it includes the casing to patrol and examine the appearance, be equipped with antenna, power indicator, GPS pilot lamp, GPRS pilot lamp and contace sending button on the casing, inside singlechip, singlechip peripheral circuit, GPS module and the GPRS communication module of being equipped with of casing, GPS module and GPRS serial communication module are connected to the singlechip, the singlechip peripheral circuit includes the mains operated circuit, sends the receive instructions circuit, crystal oscillator circuit and download the circuit. Its greatly reduced patrol and examine the appearance the cost guaranteed simultaneously the transfer in time of data to have improved work efficiency.

Description

A kind of polling transmission line management system based on GPRS wireless transmission
Technical field
The utility model relates to circuit and patrols and examines field, particularly relates to a kind of polling transmission line management system based on GPRS wireless transmission.
Background technology
Patrolling and examining of transmission line is the important process guaranteeing line facility safe operation, by the walkaround inspection be in time, grasp the change of circuit operation conditions and surrounding environment, discovering device defect is also eliminated with the hidden danger jeopardizing line security, in time to guarantee the safe and reliable operation of circuit.Require that when patrolling and examining patrol officer must put in place to every base shaft tower, but now basic by the execution of patrol officer's voluntary observance, so cannot effectively control in personnel put in place.
Due to quality and the administrative reason of employee, polling transmission line work often occurs leaking the phenomenon such as hilllock, false entry.For above-mentioned situation, be badly in need of a set of convenience of development, reliably patrolling and checking management system.
The PDA that line data-logging uses is the most close with this programme, it is located by GPS and records this geographical location information, after patrol officer has maked an inspection tour circuit at every turn, all PDA to be taken back work area, by USB data line, tour record is transferred in computer, checks the situation that puts in place to hilllock of patrol officer for administrative staff.
The poor in timeliness of shortcoming: PDA, after patrol officer has maked an inspection tour circuit, all will take back work area by PDA at every turn, be transferred in computer by USB data line by tour record, can not grasp the situation that puts in place to hilllock of patrol officer immediately; Use the routine inspection mode of PDA, lack oneself corresponding management platform; PDA is expensive, and every platform wants about 5000 yuan.And though PDA function is many, selectivity is not strong, and the cultural quality of a lot of line inspection personnel reduces, and operates and comparatively bothers.
Utility model content
In order to solve the problems of the technologies described above, the utility model proposes a kind of polling transmission line management system based on GPRS wireless transmission, the cost greatly reducing logging ensure that simultaneously and the real-time transmission of data improves operating efficiency.
To achieve these goals, the technical scheme that the utility model adopts is:
A kind of polling transmission line management system based on GPRS wireless transmission, comprise logging, described logging is successively by GPRS communication network and electric power system LAN connection server, described server connects client by electric power system LAN, described logging comprises housing, described housing is provided with antenna, power supply indicator, GPS indicator light, GPRS indicator light and switch send button, described enclosure interior is provided with single-chip microcomputer, SCM peripheral circuit, GPS module and GPRS communication module, described single-chip microcomputer connects GPS module and GPRS serial communication modular, described SCM peripheral circuit comprises power-supplying circuit, transmission and reception indicating circuit, crystal oscillating circuit and download circuit.
Described single-chip microcomputer is MSP430F149, 1st pin of described MSP430F149 is by electric capacity C8 ground connection, 1st pin of described MSP430F149 connects the output of power-supplying circuit, 58th pin of described MSP430F149 is by electric capacity C1 ground connection, 58th pin of described MSP430F149 is by K switch 2 ground connection, 58th pin of described MSP430F149 connects the output of power-supplying circuit by resistance R1, 62nd pin of described MSP430F149 is by magnetic bead FB1 ground connection, the 63rd pin ground connection of described MSP430F149, 64 pins of described MSP430F149 are by electric capacity C6 ground connection, 64th pin of described MSP430F149 connects the output of power-supplying circuit by magnetic bead FB2.
Described download circuit comprises chip JTAG, 1st pin of described chip JTAG connects the 54th pin of MSP430F149, 2nd pin of described chip JTAG connects the output of power-supplying circuit, 3rd pin of described chip JTAG connects the 55th pin of MSP430F149, 5th pin of described chip JTAG connects the 56th pin of MSP430F149, 6th pin of described chip JTAG connects the 9th pin of MSP430F149, 7th pin of described chip JTAG connects the 57th pin of MSP430F149, 11st pin of described chip JTAG connects the 58th pin of MSP430F149, the 9th pin ground connection of described chip JTAG.
Described transmission and reception indicating circuit comprises the resistance R3, resistance R4, resistance R5 and the resistance R6 that are connected with power-supplying circuit output respectively, described resistance R3 connects the 32nd pin of MSP430F149 by light-emitting diode DS2, described resistance R4 connects the 33rd pin of MSP430F149 by light-emitting diode DS3, described resistance R5 connects the 34th pin of MSP430F149 by light-emitting diode DS4, and described resistance R6 connects the 35th pin of MSP430F149 by light-emitting diode DS5.
Describedly comprise crystal oscillator X1 and crystal oscillator X2, described crystal oscillator X1 is connected between the 8th pin of MSP430F149 and the 9th pin, 8th pin of described MSP430F149 is by electric capacity C12 ground connection, 9th pin of described MSP430F149 is by electric capacity C13 ground connection, described crystal oscillator X2 is connected between the 52nd pin of MSP430F149 and the 53rd pin, 52nd pin of described MSP430F149 is by electric capacity C15 ground connection, and the 53rd pin of described MSP430F149 is by electric capacity C14 ground connection.
Described GPRS serial communication modular contains serial communication circuit, described serial communication circuit comprises chip MAX232CPE, 1st pin of described chip MAX232CPE connects the 3rd pin by electric capacity C9, 2nd pin of described chip MAX232CPE meets voltage source V CC by electric capacity C7, 4th pin of described chip MAX232CPE connects the 5th pin by electric capacity C10, 6th pin of described chip MAX232CPE is by electric capacity C11 ground connection, 7th pin of described chip MAX232CPE connects the 3rd pin of second serial J2, 8th pin of described chip MAX232CPE connects the 2nd pin of second serial J2, 9th pin of described chip MAX232CPE connects the 35th pin of MSP430F149, 10th pin of described chip MAX232CPE connects the 34th pin of MSP430F149, 11st pin of described chip MAX232CPE connects the 32nd pin of MSP430F149, 12nd pin of described chip MAX232CPE connects the 33rd pin of MSP430F149, 13rd pin of described chip MAX232CPE connects the 2nd pin of first serial J1, 14th pin of described chip MAX232CPE connects the 3rd pin of first serial J1, the 15th pin ground connection of described chip MAX232CPE, 16th pin of described chip MAX232CPE connects voltage source V CC, 4th pin of described first serial J1 connects the 6th pin, 7th pin of described first serial J1 connects the 7th pin, 5th pin of described first serial J1, 10th pin and the equal ground connection of the 11st pin, 4th pin of described second serial J1 connects the 6th pin, 7th pin of described second serial J1 connects the 7th pin, 5th pin of described second serial J1, 10th pin and the equal ground connection of the 11st pin.
The frame format of described logging and server communications protocol is the fixed length frame in units of 8 bits.
The beneficial effects of the utility model are:
1, the hander cost of system only needs 400 yuan, cost comparatively PDA save 92%! Only need during operation to press the button on logging shell, information just can be sent to server by logging automatically, reduces the requirement professional to operating personnel, thus reduces labour cost.
2, magnetic bead FB is exclusively used in and suppresses the high-frequency noise on holding wire, power line and spike to disturb, and also has the ability absorbing electrostatic pulse.
3, download circuit is that single-chip microcomputer provides download path, and making between single-chip microcomputer and computer can free communication, receives and sends indicating circuit by resistance current-limiting protection indicator light, play warning function simultaneously; Crystal oscillator in crystal oscillating circuit and electric capacity form crystal oscillator loop, and electric capacity can effectively decoupling, ensure that the stability of crystal oscillating circuit.
4, serial communication circuit have employed double-serial port, and wherein first serial J1 connects GPS module, and second serial J2 connects GPRS communication module, and adopt electric capacity C11 decoupling, electric capacity C9 and electric capacity C10 filtering, make whole telecommunication circuit stability very high simultaneously.MAX232CPE completes 232 level and Transistor-Transistor Logic level is changed, and provides a local interface, for debugging and maintenance are provided convenience.
Accompanying drawing explanation
Fig. 1 the utility model structural representation;
Fig. 2 Single-chip Controlling figure;
Fig. 3 download circuit;
Fig. 4 transmission and reception indicating circuit;
Fig. 5 crystal oscillating circuit;
Fig. 6 power-supplying circuit;
Fig. 7 serial communication circuit.
Wherein, 1 housing; 2 power supply indicators; 3GPS indicator light; 4GPRS indicator light; 5 switches send button; 6 antennas.
Embodiment
In order to better understand the technical solution of the utility model, below in conjunction with accompanying drawing, the utility model is described in further detail.
As shown in Figure 1, a kind of polling transmission line management system based on GPRS wireless transmission, comprise logging, described logging is successively by GPRS communication network and electric power system LAN connection server, described server connects client by electric power system LAN, described logging comprises housing 1, described housing is provided with antenna 6, power supply indicator 2, GPS indicator light 3, GPRS indicator light 4 and switch send button 5, described enclosure interior is provided with single-chip microcomputer, SCM peripheral circuit, GPS module and GPRS communication module, described single-chip microcomputer connects GPS module and GPRS serial communication modular, described SCM peripheral circuit comprises power-supplying circuit, transmission and reception indicating circuit, crystal oscillating circuit and download circuit.
GPS module is for locating the latitude and longitude information residing for logging, and GPRS serial communication modular is for realizing the communication between single-chip microcomputer and GPS.Client, staff and keeper can pass through client-access server.By GPRS, data are passed to electric power system local area network (LAN) and namely ensure that data can transmit the safety that in turn ensure that in data transmission procedure in real time.Electric power system local area network (LAN) only works for electric power system internal staff, has very high coefficient of safety, and client is conducted interviews by electric power system local area network (LAN) and effectively ensure that the safety of data, reduces access risk.
As shown in Figure 2, described single-chip microcomputer is MSP430F149, 1st pin of described MSP430F149 is by electric capacity C8 ground connection, 1st pin of described MSP430F149 connects the output of power-supplying circuit, 58th pin of described MSP430F149 is by electric capacity C1 ground connection, 58th pin of described MSP430F149 is by K switch 2 ground connection, 58th pin of described MSP430F149 connects the output of power-supplying circuit by resistance R1, 62nd pin of described MSP430F149 is by magnetic bead FB1 ground connection, the 63rd pin ground connection of described MSP430F149, 64 pins of described MSP430F149 are by electric capacity C6 ground connection, 64th pin of described MSP430F149 connects the output of power-supplying circuit by magnetic bead FB2.K2 is the transmission button on logging shell.
The utility model selects serial ports GPS module.Module parameter is as follows:
Interface features: Transistor-Transistor Logic level, compatible 3.3V/5V system
Receiving feature: 50 passages, GPSL1 (1575.42Mhz) C/A code, SBAS:WAAS/EGNOS/MSAS
Positioning precision: 2.5mCEP (SBAS:2.0mCEP)
Renewal rate: maximum 5Hz (acquiescence 1HZ)
Capture time: cold start-up: 27S (the fastest)
Warm start: 1S
Follow the trail of sensitivity :-161dBm
Acquisition sensitivity (cold start-up) :-147dBm
Communication protocol: NMEA (acquiescence)/UBXBinary
Serial communication baud rate: 4800,9600 (acquiescences), 19200,38400,57600,115200,230400
Speed limits: 500m/s
Limitation in height: 50000m
Working temperature :-40 degrees Celsius ~ 85 degrees Celsius
Operating voltage: 2.7V-5.0V (input of VCC pin)
Operating current: 45mA
TXD/RXD impedance: 510 Europe
After GPS module starts, initiatively send the information such as geographical coordinate by serial ports, the acquiescence transmission cycle is 1s.The character of every line start of GPS output frame is all ' $ ', is then information type, after be data, open with CSV.Wherein GPGGA is the most frequently used a kind of data format. the data that a line is complete are as follows:
$GPGGA,090123.000,3958.2848,N,11616.6462,E,1,9,0.85,67.8,M,-6.7,M,,*72
Wherein " 3958.2848, N, 11616.6462, E " shows longitude and latitude.Latitude ddmm.mmmm (degree point) form (above 0 also will be transmitted), latitude hemisphere N (Northern Hemisphere) or S (Southern Hemisphere); Longitude dddmm.mmmm (degree point) form (above 0 also will be transmitted), longitude hemisphere E (east longitude) or W (west longitude).In this example, gps coordinate is: north latitude 39 ° 58.2848 ', east longitude 116 ° 166462 '.MSP430 resolves the GPS information in serial ports buffer memory, by identifying " $ GPGGA " character field, parses latitude and longitude information.
Serial ports GPRS transparent transmission module can realize the two-way transparent transmission of serial ports and GPRS network.This module work is simple, and after arranging the IP domain name of server end, any data being sent to its serial ports end, all can be sent to server end in TCP mode.In logging, the Information Organizations such as device id, longitude, latitude get up to be sent to server end by the interface protocol of specifying by instrument.
MSP430 single-chip microcomputer workflow is as shown below.System works comprises main flow and interrupt service routine two program flows.Because GPS module has the start-up time of about 23s, after system electrification, first main flow waits for that GPS starts, and after waiting GPS to start, just enters major cycle.Major cycle has two functions: if GPS buffer memory is not for empty, resolves and upgrade latitude and longitude coordinates; If press transmission button, send up-to-date latitude and longitude coordinates to server by serial ports GPRS transparent transmission module.Major cycle can repeat judge and perform this two functions, until system cut-off.The receiving mode of the serial ports that Operation system setting GPS connects is interrupting receive pattern, once this serial ports receives data, single-chip microcomputer, after saving scene, jumps into interrupt service routine, interrupt service routine is only responsible for the data supplementing received in GPS buffer memory, resolves coordinate for major cycle.
As shown in Figure 3, described download circuit comprises socket JTAG, 1st pin of described socket JTAG connects the 54th pin of MSP430F149, 2nd pin of described socket JTAG connects the output of power-supplying circuit, 3rd pin of described socket JTAG connects the 55th pin of MSP430F149, 5th pin of described socket JTAG connects the 56th pin of MSP430F149, 6th pin of described socket JTAG connects the 9th pin of MSP430F149, 7th pin of described socket JTAG connects the 57th pin of MSP430F149, 11st pin of described socket JTAG connects the 58th pin of MSP430F149, the 9th pin ground connection of described socket JTAG.
As shown in Figure 4, described transmission and reception indicating circuit comprises the resistance R3, resistance R4, resistance R5 and the resistance R6 that are connected with power-supplying circuit output respectively, described resistance R3 connects the 32nd pin of MSP430F149 by light-emitting diode DS2, described resistance R4 connects the 33rd pin of MSP430F149 by light-emitting diode DS3, described resistance R5 connects the 34th pin of MSP430F149 by light-emitting diode DS4, and described resistance R6 connects the 35th pin of MSP430F149 by light-emitting diode DS5.
As shown in Figure 5, describedly comprise crystal oscillator X1 and crystal oscillator X2, described crystal oscillator X1 is connected between the 8th pin of MSP430F149 and the 9th pin, 8th pin of described MSP430F149 is by electric capacity C12 ground connection, 9th pin of described MSP430F149 is by electric capacity C13 ground connection, described crystal oscillator X2 is connected between the 52nd pin of MSP430F149 and the 53rd pin, and the 52nd pin of described MSP430F149 is by electric capacity C15 ground connection, and the 53rd pin of described MSP430F149 is by electric capacity C14 ground connection.
As shown in Figure 6, power-supplying circuit is the whole direct voltage providing 3.3V.Wherein, JP is the abbreviation of powerjack, refers to adapter jack.
As shown in Figure 7, described GPRS serial communication modular contains serial communication circuit, described serial communication circuit comprises chip MAX232CPE, 1st pin of described chip MAX232CPE connects the 3rd pin by electric capacity C9, 2nd pin of described chip MAX232CPE meets voltage source V CC by electric capacity C7, 4th pin of described chip MAX232CPE connects the 5th pin by electric capacity C10, 6th pin of described chip MAX232CPE is by electric capacity C11 ground connection, 7th pin of described chip MAX232CPE connects the 3rd pin of second serial J2, 8th pin of described chip MAX232CPE connects the 2nd pin of second serial J2, 9th pin of described chip MAX232CPE connects the 35th pin of MSP430F149, 10th pin of described chip MAX232CPE connects the 34th pin of MSP430F149, 11st pin of described chip MAX232CPE connects the 32nd pin of MSP430F149, 12nd pin of described chip MAX232CPE connects the 33rd pin of MSP430F149, 13rd pin of described chip MAX232CPE connects the 2nd pin of first serial J1, 14th pin of described chip MAX232CPE connects the 3rd pin of first serial J1, the 15th pin ground connection of described chip MAX232CPE, 16th pin of described chip MAX232CPE connects voltage source V CC, 4th pin of described first serial J1 connects the 6th pin, 7th pin of described first serial J1 connects the 7th pin, 5th pin of described first serial J1, 10th pin and the equal ground connection of the 11st pin, 4th pin of described second serial J1 connects the 6th pin, 7th pin of described second serial J1 connects the 7th pin, 5th pin of described second serial J1, 10th pin and the equal ground connection of the 11st pin.
The frame format of described logging and server communications protocol is the fixed length frame in units of 8 bits.In frame format, each byte is defined as follows:
Beginning flag SOF:0xF5
Device id: 2Bytes device id.
Longitude Lontitude:2Bytes longitude coordinate
Longitude Latitude:2Bytes latitude coordinate
The CRC-16/XMODEM verification of check word CCW:2Bytes.Check code is
(x16+x12+x5+1), check digit is the CRC check result except start bit and stop bits in packet, that is: DID, LON and LAT field.
Frame end mark EOF:0xAA
For ensureing SOF and EOF coding uniqueness in the data transmission, adopt escape character (ESC) (ESC, 0x7D) fill, SOT (0xFD) and EOT (0xAD) is converted to SOF and EOF occurred in frame format (DID, LON, LAT, CCW), and an ESC is inserted when there is ESC, scheme signal as follows.
Described server comprises data processing module, data memory module, Data access module and statistical conversion module;
The information that described data processing module sends for the treatment of logging, the latitude and longitude information that extraction equipment ID and GPS locates, and data are stored to memory module;
Described memory module is for storing data;
Described Data access module is used for staff's access services device, and keeper checks the condition of going on duty of all inspectors;
Described statistical conversion module, for generating Microsoft Excel, provides reliable data message to operation maintenance management person.
The database that described server uses is SQLServer database, and described SQLServer database contains logging registration form and makes an inspection tour record sheet, and described logging registration form comprises two row: device id and corresponding use employee name; Described tour record sheet comprises six row: mark ID, device id, equipment time, longitude, latitude, line bar label.
After server receives logging information, the gps coordinate that the line bar gps coordinate recorded by format comparison and logging are uploaded, as longitude and latitude gap is no more than 0.02 point (about 37m), then mark this and be recorded as corresponding line bar number, and the information such as the device id of record, corresponding use employee name, line bar number, time are stored in the tour record sheet of database, call for Web server.
Server selects ASP.Net as development environment, selects IIS as Web container.Operation management personnel call browser and check tour record.Web interface comprises two parts: the date is selected control and makes an inspection tour record sheet.On the operation management personnel selection specific date, all tour recorded informations on the same day all can show, operation management personnel by examination record, just can grasp in real time patrol officer to hilllock situation.After browser input particular web site, browser sends request to server, after server receives request, connection data storehouse, and inquire about the scheduled date tour record on (the acquiescence same day), database root is according to logging registration form, tour record sheet two forms and search request, return the tour record (comprising the information such as device id, inspector's name, time, line bar number) of scheduled date, server will return results to be organized in the form of a web page and returns browser, examines for keeper.Keeper is when needs derived data, and can click " record is derived " button derives the data inquired with the form of excel form.After clicking " record is derived " button, the data in " making an inspection tour record " control are sent to this locality with the form of HTML by webpage, and indicate that file type is excel.
The simple HTML segment derived for one, the html format of derivation is as follows:
<tableborder="1">
<tr><thGreatT.Gr eaT.GT name </th><thGreatT.G reaT.GT sex </th></trGreatT. GreaT.GT
<tr><thGreatT.Gr eaT.GT Zhang San </th><thGreatT.G reaT.GT man </th></trGreatT. GreaT.GT
<tr><thGreatT.Gr eaT.GT Li Si </th><thGreatT.G reaT.GT man </th></trGreatT. GreaT.GT
<tr><thGreatT.Gr eaT.GT spring flower </th><thGreatT.G reaT.GT female </th></trGreatT. GreaT.GT
</table>
The file of this content is saved as xls form, and opens with excel.
By reference to the accompanying drawings embodiment of the present utility model is described although above-mentioned; but the restriction not to the utility model protection range; one of ordinary skill in the art should be understood that; on the basis of the technical solution of the utility model, those skilled in the art do not need to pay various amendment or distortion that creative work can make still within protection range of the present utility model.

Claims (7)

1. the polling transmission line management system based on GPRS wireless transmission, it is characterized in that, comprise logging, described logging is successively by GPRS communication network and electric power system LAN connection server, described server connects client by electric power system LAN, described logging comprises housing, described housing is provided with antenna, power supply indicator, GPS indicator light, GPRS indicator light and switch send button, described enclosure interior is provided with single-chip microcomputer, SCM peripheral circuit, GPS module and GPRS communication module, described single-chip microcomputer connects GPS module and GPRS serial communication modular, described SCM peripheral circuit comprises power-supplying circuit, transmission and reception indicating circuit, crystal oscillating circuit and download circuit.
2. a kind of polling transmission line management system based on GPRS wireless transmission according to claim 1, it is characterized in that, described single-chip microcomputer is MSP430F149, 1st pin of described MSP430F149 is by electric capacity C8 ground connection, 1st pin of described MSP430F149 connects the output of power-supplying circuit, 58th pin of described MSP430F149 is by electric capacity C1 ground connection, 58th pin of described MSP430F149 is by K switch 2 ground connection, 58th pin of described MSP430F149 connects the output of power-supplying circuit by resistance R1, 62nd pin of described MSP430F149 is by magnetic bead FB1 ground connection, the 63rd pin ground connection of described MSP430F149, 64 pins of described MSP430F149 are by electric capacity C6 ground connection, 64th pin of described MSP430F149 connects the output of power-supplying circuit by magnetic bead FB2.
3. a kind of polling transmission line management system based on GPRS wireless transmission according to claim 2, it is characterized in that, described download circuit comprises socket JTAG, 1st pin of described socket JTAG connects the 54th pin of MSP430F149, 2nd pin of described socket JTAG connects the output of power-supplying circuit, 3rd pin of described socket JTAG connects the 55th pin of MSP430F149, 5th pin of described socket JTAG connects the 56th pin of MSP430F149, 6th pin of described socket JTAG connects the 9th pin of MSP430F149, 7th pin of described socket JTAG connects the 57th pin of MSP430F149, 11st pin of described socket JTAG connects the 58th pin of MSP430F149, the 9th pin ground connection of described socket JTAG.
4. a kind of polling transmission line management system based on GPRS wireless transmission according to claim 2, it is characterized in that, described transmission and reception indicating circuit comprises the resistance R3 be connected with power-supplying circuit output respectively, resistance R4, resistance R5 and resistance R6, described resistance R3 connects the 32nd pin of MSP430F149 by light-emitting diode DS2, described resistance R4 connects the 33rd pin of MSP430F149 by light-emitting diode DS3, described resistance R5 connects the 34th pin of MSP430F149 by light-emitting diode DS4, described resistance R6 connects the 35th pin of MSP430F149 by light-emitting diode DS5.
5. a kind of polling transmission line management system based on GPRS wireless transmission according to claim 2, it is characterized in that, describedly comprise crystal oscillator X1 and crystal oscillator X2, described crystal oscillator X1 is connected between the 8th pin of MSP430F149 and the 9th pin, 8th pin of described MSP430F149 is by electric capacity C12 ground connection, 9th pin of described MSP430F149 is by electric capacity C13 ground connection, described crystal oscillator X2 is connected between the 52nd pin of MSP430F149 and the 53rd pin, 52nd pin of described MSP430F149 is by electric capacity C15 ground connection, 53rd pin of described MSP430F149 is by electric capacity C14 ground connection.
6. a kind of polling transmission line management system based on GPRS wireless transmission according to claim 2, it is characterized in that, described GPRS serial communication modular contains serial communication circuit, described serial communication circuit comprises chip MAX232CPE, 1st pin of described chip MAX232CPE connects the 3rd pin by electric capacity C9, 2nd pin of described chip MAX232CPE meets voltage source V CC by electric capacity C7, 4th pin of described chip MAX232CPE connects the 5th pin by electric capacity C10, 6th pin of described chip MAX232CPE is by electric capacity C11 ground connection, 7th pin of described chip MAX232CPE connects the 3rd pin of second serial J2, 8th pin of described chip MAX232CPE connects the 2nd pin of second serial J2, 9th pin of described chip MAX232CPE connects the 35th pin of MSP430F149, 10th pin of described chip MAX232CPE connects the 34th pin of MSP430F149, 11st pin of described chip MAX232CPE connects the 32nd pin of MSP430F149, 12nd pin of described chip MAX232CPE connects the 33rd pin of MSP430F149, 13rd pin of described chip MAX232CPE connects the 2nd pin of first serial J1, 14th pin of described chip MAX232CPE connects the 3rd pin of first serial J1, the 15th pin ground connection of described chip MAX232CPE, 16th pin of described chip MAX232CPE connects voltage source V CC, 4th pin of described first serial J1 connects the 6th pin, 7th pin of described first serial J1 connects the 7th pin, 5th pin of described first serial J1, 10th pin and the equal ground connection of the 11st pin, 4th pin of described second serial J1 connects the 6th pin, 7th pin of described second serial J1 connects the 7th pin, 5th pin of described second serial J1, 10th pin and the equal ground connection of the 11st pin.
7., according to the arbitrary described a kind of polling transmission line management system based on GPRS wireless transmission of claim 1-6, it is characterized in that, the frame format of described logging and server communications protocol is the fixed length frame in units of 8 bits.
CN201520395570.5U 2015-06-10 2015-06-10 Transmission line patrols and examines management system based on GPRS wireless transmission Withdrawn - After Issue CN204809986U (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201520395570.5U CN204809986U (en) 2015-06-10 2015-06-10 Transmission line patrols and examines management system based on GPRS wireless transmission

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201520395570.5U CN204809986U (en) 2015-06-10 2015-06-10 Transmission line patrols and examines management system based on GPRS wireless transmission

Publications (1)

Publication Number Publication Date
CN204809986U true CN204809986U (en) 2015-11-25

Family

ID=54594747

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201520395570.5U Withdrawn - After Issue CN204809986U (en) 2015-06-10 2015-06-10 Transmission line patrols and examines management system based on GPRS wireless transmission

Country Status (1)

Country Link
CN (1) CN204809986U (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104868600A (en) * 2015-06-10 2015-08-26 国网山东济南市历城区供电公司 Power transmission line inspection tours and management system based on GPRS wireless transmission
CN108712267A (en) * 2018-08-17 2018-10-26 上海市共进通信技术有限公司 CATV photoreceivers communicate the power supply circuit construction that electrostatic resistance function is realized in integrated system with PON
CN112398048A (en) * 2020-11-04 2021-02-23 国网山东省电力公司德州供电公司 Power transmission line inspection instrument and power transmission line inspection in-place monitoring system

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104868600A (en) * 2015-06-10 2015-08-26 国网山东济南市历城区供电公司 Power transmission line inspection tours and management system based on GPRS wireless transmission
CN108712267A (en) * 2018-08-17 2018-10-26 上海市共进通信技术有限公司 CATV photoreceivers communicate the power supply circuit construction that electrostatic resistance function is realized in integrated system with PON
CN112398048A (en) * 2020-11-04 2021-02-23 国网山东省电力公司德州供电公司 Power transmission line inspection instrument and power transmission line inspection in-place monitoring system

Similar Documents

Publication Publication Date Title
CN204117170U (en) Adopt the electric power fire fighting equipment RFID patrolling and checking management system of ZigBee equipment
CN107328437A (en) Towards the wearable device of electric power safety inspection operation
CN204809986U (en) Transmission line patrols and examines management system based on GPRS wireless transmission
CN209297373U (en) Online patrol system based on Cloud Server and bluetooth inspection point device
CN204117211U (en) Electric power fire fighting equipment RFID patrolling and checking management system
CN109377585A (en) Factory&#39;s public affairs match facility intelligent operation cruising inspection system and its method for inspecting
CN104868600A (en) Power transmission line inspection tours and management system based on GPRS wireless transmission
Qiuchan et al. The water quality online monitoring system based on wireless sensor network
CN105300025A (en) Refrigerator monitoring system
CN207718443U (en) A kind of attendance checking system based on WIFI sniff technologies
CN104616476A (en) Electric energy acquisition terminal based on Beidou short message communication
CN205038790U (en) Portable machine of checking meter
CN204668829U (en) A kind of patrolling and checking management system of circuit
CN204423620U (en) A kind of electric energy acquisition terminal based on the communication of Big Dipper short message
CN106781352A (en) Using the water meter of Internet of Things propagated sensation module
CN103021040B (en) Device and method of network polling and personnel management based on multi-system-type RFID (radio frequency identification device) read-write terminal
CN206906807U (en) Big dipper master clock
CN110796213A (en) Mobile interconnection type safety patrol management system
CN106644175A (en) Calorimeter using IOT sensing module with information processing
CN106657275A (en) Internet of Things sensing module with information processing based on narrow-band communication
CN106408773A (en) Electricity meter using Internet of Things sensing module with information processing
CN106600926A (en) Calorimeter using internet-of-things sensing module
CN209028803U (en) A kind of novel electric power data concentrator
CN107197014A (en) A kind of mobile phone positioning and monitoring system
CN205121395U (en) Fridge wireless monitoring system

Legal Events

Date Code Title Description
C14 Grant of patent or utility model
GR01 Patent grant
AV01 Patent right actively abandoned

Granted publication date: 20151125

Effective date of abandoning: 20160914

C25 Abandonment of patent right or utility model to avoid double patenting