Summary of the invention
In view of this, in order to address the above problem, the present invention proposes a kind ofly to reduce labor intensity, quick and safe electrical network electric quantity data detection system and method.
One of purpose of the present invention is to propose a kind of electric quantity data voice inquiry system; Two of purpose of the present invention is to propose a kind of electric quantity data voice inquiry method.
One of purpose of the present invention is achieved through the following technical solutions:
Electric quantity data voice inquiry system provided by the invention, comprise electric quantity data acquisition system, load managing electric quantity system, transmission channel, speech polling work station, described electric quantity data acquisition system is used to obtain the ammeter electric quantity data of transformer station, power plant, described load managing electric quantity system is used to handle electric quantity data, and described speech polling work station is connected with load managing electric quantity system by transmission channel.
Further, described electric quantity data acquisition system comprises interior network server, forward spacer assembly, ELS switch and at least one work station of checking meter, the described work station of checking meter is used to gather the table code data on transformer station's electric weight terminal, network server, forward spacer assembly, the work station of checking meter are connected with the ELS switch by bus in described, and described forward spacer assembly is connected in the bus of internal network server;
Further, described load managing electric quantity system comprises outer network server, data processing server, contact manager, Modem pond and MIS switch, described outer network server, data processing server, contact manager, Modem pond are connected with the MIS switch by bus, and the data on the described interior network server are transferred to outer network server by the forward spacer assembly;
Further, described speech polling work station comprises speech processor, inquiry controller, telephone set, described speech processor is connected with the inquiry controller, described speech processor is used for monitoring and maintenance personnel's data query instruction and replys Query Result, the data in described inquiry controller obtains according to query statement on the network server;
Further, one or more in the telecommunication telephone passage are rented by described transmission channel employing dialing passage, electric power system telephone for special use passage, transformer station;
Further, described speech processor comprises data query module, security module and database module,
Described data query module comprises the overall network loss module of inquiry, inquiry global power amount and month to date module, year accumulative total electric weight module, inquiry responsible consumer electric weight module, the important equilibrium criterion module of inquiry, the inquiry transformer station progress module of checking meter; Described data query module also is provided with OnTapiStatus state-event change counter, and described OnTapiStatus state-event change counter is used to write down the operating state of OnTapiStatus state-event and controls playing control;
Described security module is provided with user password control model and subscriber directory number control model, described user password control model is according to the password password management of user's input, and described subscriber directory number control model manages according to the number of user's registration phone;
Described database module is provided with database link block and enquiry module.
Two of purpose of the present invention is achieved through the following technical solutions:
Electric quantity data voice inquiry method provided by the invention may further comprise the steps:
Step 1: speech processor initialization, option date, data type;
Step 2: judged whether user's incoming call, if the no user incoming call, then system is in the wait query State;
Step 3: if user's incoming call is arranged, then connected system enters query State;
Step 4: data query, according to the data on the network server in attendant's the key command inquiry;
Step 5: whether judgment data has unusually, if having unusually, then should go to the machine room inspection to handle immediately;
Step 6:, then continue inquiry, up to end if no abnormal.
Further, system connects the judgement that comprises data query initial setting up and secure password in the described step 3, be provided with OnTapiStatus state-event change counter in the described data query initial set-up procedure, the operating state that described OnTapiStatus state-event change counter is used for writing down the OnTapiStatus state-event and controls the speech processor play control;
Be provided with user password control model and subscriber directory number control model in the deterministic process of described secure password, described user password control model is according to the password password management of user's input, and described subscriber directory number control model manages according to the number of user's registration phone;
Further, also comprise judging whether user inquiring is in done state, gets final product on-hook if user inquiring finishes in the described step 6, do not select if at least three users of program prompts still, then automatic hand-up.
The invention has the advantages that: adopt the speech polling work station to come the remote collection detection of grid electric quantity data data that can in time note abnormalities, alleviated work of maintenance personnel intensity simultaneously, resource that time and manpower is saved, at speech polling is that search access right control also is set, guaranteed the fail safe of system, inquiry work both can be at interior network operation, and also network operation has outside improved the operational effect of the load managing electric quantity ELS of system.Adopting simultaneously when recording played control state counter being set judging user inquiring in speech processor is to be in on-hook, still is in the broken string state, and having avoided inquiry is the phenomenon that the program of operation is suspended.This system also can promote the use of electricity consumption and electricity charge inquiry, telephone number query, introduction to business etc., and other need the field of telephone voice query.
Other advantage of the present invention, target and feature will be set forth to a certain extent in the following description, and to a certain extent, based on being conspicuous to those skilled in the art, perhaps can obtain instruction from the practice of the present invention to investigating hereinafter.The objectives and other advantages of the present invention can be passed through following specification, claims, and the specifically noted structure realizes and obtains in the accompanying drawing.
Embodiment
Below with reference to accompanying drawing, the preferred embodiments of the present invention are described in detail; Should be appreciated that preferred embodiment only for the present invention is described, rather than in order to limit protection scope of the present invention.
Fig. 1 is the ELS in the embodiment of the invention and the structure chart of local area network (LAN); Fig. 2 is ELS in the embodiment of the invention and the structure chart of MIS; As shown in the figure: electric quantity data voice inquiry system provided by the invention, comprise electric quantity data acquisition system, load managing electric quantity system, transmission channel, speech polling work station, described electric quantity data acquisition system is used to obtain the switch ammeter electric quantity data of transformer station, power plant, described load managing electric quantity system is used to handle electric quantity data, and described speech polling work station is connected with load managing electric quantity system by transmission channel.
Further improvement as the foregoing description, network server 1, forward spacer assembly 2, ELS switch 3 and at least one work station 4 of checking meter in described electric quantity data acquisition system comprises, the described work station 4 of checking meter is used to gather the table code data on transformer station's electric weight terminal, network server, forward spacer assembly, the work station of checking meter are connected with the ELS switch by bus in described, and described forward spacer assembly is connected in the bus of internal network server.
Further improvement as the foregoing description, described load managing electric quantity system comprises outer network server 5, data processing server 6, contact manager, Modem pond and MIS switch 7, described outer network server, data processing server, contact manager, Modem pond are connected with the MIS switch by bus, and the data on the described interior network server are transferred to outer network server by the forward spacer assembly.
The load managing electric quantity ELS of system comprises equipment such as interior host, outer server, the work station of checking meter, interface work station, outer network server; According to secondary security protection area principle, the outer network server of ELS is in the IV district, and the miscellaneous equipment of ELS is in the II district, and MIS also is in the IV district.The ELS system links to each other with MIS by the forward spacer assembly, and the data on the interior network server are transferred to outer network server by the forward spacer assembly, the computer of the MIS network segment can be directly data query on the network server outside.
Further improvement as the foregoing description, described speech polling work station comprises speech processor, inquiry controller, telephone set, described speech processor is connected with the inquiry controller, described speech processor is used for monitoring and maintenance personnel's data query instruction and replys Query Result, the data in described inquiry controller obtains according to query statement on the network server.
As the further improvement of the foregoing description, one or more in the telecommunication telephone passage are rented by described transmission channel employing dialing passage, electric power system telephone for special use passage, transformer station.
As the further improvement of the foregoing description, described speech processor comprises data query module, security module and database module,
Described data query module comprises the overall network loss module of inquiry, inquiry global power amount and month to date module, year accumulative total electric weight module, inquiry responsible consumer electric weight module, the important equilibrium criterion module of inquiry, the inquiry transformer station progress module of checking meter; Described data query module also is provided with OnTapiStatus state-event change counter, and described OnTapiStatus state-event change counter is used to write down the operating state of OnTapiStatus state-event and controls playing control;
Described security module is provided with user password control model and subscriber directory number control model, described user password control model is according to the password password management of user's input, and described subscriber directory number control model manages according to the number of user's registration phone;
The electric quantity data voice inquiry system has identity recognition function, selects the electric quantity data kind according to telephone key-press; Realize the speech polling function of data such as network loss rate, bus balance, line loss, day electric weight; Automatically operation need not manual intervention; Only carry out the query manipulation of data, do not carry out insertion, modification, the deletion action of data, guarantee the safe and stable operation of ELS.
Described database module is provided with database link block and enquiry module.
Fig. 3 is the TMR of electric quantity metering system of a power supply administration data structure; As shown in the figure, in electric quantity metering system of power supply administration, computational process is as follows: 1. gather the original table sign indicating number of stoichiometric point, 2. calculate the electric weight of stoichiometric point, 3. the calculating object electric weight 4. calculates line loss rate.Wherein, the object electric weight is two or more stoichiometric points (or object electric weight), to forward, oppositely electric weight carries out the electric quantity data that obtains of plus and minus calculation, as infeed electric weight, feed out electric weight, the loss electric weight; Line loss rate is meant the loss electric weight and the ratio that infeeds electric weight of a certain equipment (as bus, main transformer, circuit etc.), a certain zone and full electric network.The line loss rate computing formula is: line loss rate=(infeed electric weight-feed out electric weight)/infeed electric weight.Object electric weight and balanced ratio are that TMR is carried out the result that deep processing is handled to the original table code data, and following stoichiometric point original table sign indicating number, stoichiometric point electric weight is top object electric weight, the basis of line loss rate.The line loss rate of the whole network is the important economic and technical norms of full electric network, is commonly referred to as the network loss rate.Generally speaking, progress original table sign indicating number normal, each stoichiometric point is correct as long as the electric quantity acquisition terminal is checked meter, and stoichiometric point electric weight, object electric weight, line loss rate just can be correct, and the network loss rate just can be correct; As long as the network loss rate is correct, other data such as stoichiometric point original table sign indicating number, stoichiometric point electric weight, object electric weight, line loss rate also should be correct conversely speaking.So,, just can judge whether the TMR system data is correct as network loss rate, important substation bus bar balanced ratio, the aggregate scheduling etc. of checking meter by the several important index among the speech polling TMR.Do you but how to judge whether these indexs correct? because indexs such as network loss rate, bus balanced ratio are generally all relatively stable, excursion very little (generally between 0.8-1.1%, the bus balanced ratio is generally between ± 2% for the network loss rate); The aggregate scheduling of checking meter is represented the current progress of checking meter of all transformer stations, should be the point on the same day 0 of inquiry, if the progress of checking meter of electric quantity acquisition terminal that has a transformer station at least illustrates that also in the previous day the original table sign indicating number of stoichiometric point is also imperfect.So,, just can judge whether the TMR data are normal by information such as inquiry network loss rate, important substation bus bar balanced ratio, the aggregate schedulings of checking meter.
Fig. 4 is the speech polling menu schematic diagram in the embodiment of the invention; Fig. 5 is the database connection diagram in the embodiment of the invention; As shown in the figure, be the electric quantity data voice inquiry method that the embodiment of the invention provides below, may further comprise the steps:
Step 1: speech processor initialization, option date, data type;
Step 2: judged whether user's incoming call, if the no user incoming call, then system is in the wait query State;
Step 3: if user's incoming call is arranged, then connected system enters query State;
Step 4: data query, according to the data on the network server in attendant's the key command inquiry;
Step 5: whether judgment data has unusually, if having unusually, then should go to the machine room inspection to handle immediately;
Step 6:, then continue inquiry, up to end if no abnormal.
Further improvement as the foregoing description, system connects the judgement that comprises data query initial setting up and secure password in the described step 3, be provided with OnTapiStatus state-event change counter in the described data query initial set-up procedure, the operating state that described OnTapiStatus state-event change counter is used for writing down the OnTapiStatus state-event and controls the speech processor play control;
Be provided with user password control model and subscriber directory number control model in the deterministic process of described secure password, described user password control model is according to the password password management of user's input, and described subscriber directory number control model manages according to the number of user's registration phone.
As the further improvement of the foregoing description, also comprise judging whether user inquiring is in done state, gets final product on-hook if user inquiring finishes in the described step 6, if still, at least three users of program prompts do not select, then automatic hand-up.
Exploitation electric quantity data speech polling software, the configuration necessary hardware just can be inquired about electric quantity datas such as network loss rate, the electric weight of load managing electric quantity system (ELS), the progress of checking meter, equilibrium criterion by phone.
The embodiment of the invention adopts among the Delphi 7 and makes up Database Systems, connects, the mechanism of database access mainly contains BDE, ADO and dbexpress.BDE is database engine (the Borland Database Engine of Borland company exploitation, be called for short BDE), it has realized developing and managing and being connected of various databases by calling mechanism, visit long-range Microsoft SQL Server 7.0, use more convenient, so in this program, adopt the BED mode.
Microsoft SQL Server 7.0 is adopted in the ELS electric quantity data storehouse of the embodiment of the invention, and database name is dacase2000.Odbc data source dacase points to electric quantity data storehouse dacase2000, and the another name dacase that sets up by BDE links to each other with odbc data source dacase, thereby realizes that BDE links to each other with dacase2000, has realized that also application program links to each other with database.
The TApdTapiDevice control is the apro assembly about the Modem dialing, replys and service function such as configuration that it has encapsulated TAPI function and some multimedia functions, can solve telephonograph and broadcast, and button detects.
OnTapiConnect incident, OnTapiDTMF incident that detects telephone key-press that connects and the PlayWaveFile method of playing voice in this program, have mainly been used.
The defective of apro assembly maximum is to judge the whether problem of on-hook or broken string of user in speech pattern, in the speech polling process, speech data does not also finish, if the user hangs up the telephone or unexpected broken string, still use the PlayWaveFile method to play speech data to modem, control will report an error, and program is suspended, need manual confirmation to reset, this is unallowed.
In order to address this problem, revised the part control handler, utilized the OnTapiStatus incident, this incident is set out when state variation, adopts a counter, and the every variation of state once adds one, successfully will experience the conversion of 6 next states from the standby to the link setup.When playing voice, play control PlayWaveFile judges whether state counter equals 6 earlier, equaling 6 explanations also is in the normal link setup process, otherwise interrupt playing, stop to play speech data, carry out the reset initialization operation, enter holding state to modem, thereby prepare for insert phone next time, thereby successfully solved this problem.
Search access right mainly contains dual mode and controls, and a kind of mode is that another kind is to control according to subscriber phone caller identification number according to user's control of entering password, if registration phone is dialled in, allows to carry out data query, otherwise hangs up the telephone automatically.The phone that this mode need insert modem has incoming call display function.Handling caller identification in the TApdTapiDevice control is the OnTapiCallerID incident.
The unify safety of database of department of computer science is very important, and it is also nonsensical to have lost all work of fail safe.In electric weight speech polling software, be connected with extraneous by phone, only carry out predefined data query, do not make any operation of insertion, deletion, modification database, and the data query amount is very little, guarantees the safe, practical property and the convenience, stable high of database.Safe, may operate at Intranet, also may operate at outer net, the incoming call restriction, the direct incoming call of franchise telephone number, other telephone number is according to the password incoming call.Has extensibility, the convenient expansion of the function of program.Through revising other field that promptly can be applicable to a little.
Hardware device in the embodiment of the invention comprises one of common computer, and with ELS networking (Intranet, outer net all can), 1 of sound card, one one of special telephone line, select for use east to advance the D081A PCI of company sound card in the embodiment of the invention.
The above is the preferred embodiments of the present invention only, is not limited to the present invention, and obviously, those skilled in the art can carry out various changes and modification and not break away from the spirit and scope of the present invention the present invention.Like this, if of the present invention these are revised and modification belongs within the scope of claim of the present invention and equivalent technologies thereof, then the present invention also is intended to comprise these changes and modification interior.