CN110083621B - Tap changer data processing method - Google Patents
Tap changer data processing method Download PDFInfo
- Publication number
- CN110083621B CN110083621B CN201910357362.9A CN201910357362A CN110083621B CN 110083621 B CN110083621 B CN 110083621B CN 201910357362 A CN201910357362 A CN 201910357362A CN 110083621 B CN110083621 B CN 110083621B
- Authority
- CN
- China
- Prior art keywords
- data
- tap changer
- deleting
- interface
- sub
- 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.)
- Active
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 10
- 238000013523 data management Methods 0.000 claims abstract description 90
- 238000007726 management method Methods 0.000 claims abstract description 19
- 230000000007 visual effect Effects 0.000 claims abstract description 8
- 238000002474 experimental method Methods 0.000 claims description 42
- 238000005070 sampling Methods 0.000 claims description 26
- 238000010079 rubber tapping Methods 0.000 claims description 12
- 238000000034 method Methods 0.000 claims description 5
- 230000001960 triggered effect Effects 0.000 claims description 5
- 238000012545 processing Methods 0.000 claims description 4
- 238000012217 deletion Methods 0.000 abstract description 13
- 230000037430 deletion Effects 0.000 abstract description 13
- 238000012986 modification Methods 0.000 abstract description 4
- 230000004048 modification Effects 0.000 abstract description 4
- 238000012360 testing method Methods 0.000 abstract description 3
- 238000007792 addition Methods 0.000 abstract description 2
- 238000013461 design Methods 0.000 description 8
- 238000010586 diagram Methods 0.000 description 5
- 230000009286 beneficial effect Effects 0.000 description 1
- 239000008358 core component Substances 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 230000000087 stabilizing effect Effects 0.000 description 1
- 230000033772 system development Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/06—Electricity, gas or water supply
Abstract
The invention discloses a data processing method of a tap changer, which comprises the following steps: 1) creating a 'tap changer data management' database based on SQL Server2008, and creating a corresponding table in the database according to project requirements; 2) and creating an application program for tap changer data management based on Visual Studio 2010 software, and realizing various operations on tap changer data, including addition, modification, deletion and the like. 3) And testing the established application program to check whether the designed function is realized. The application program enables a manager to manage the data of the tap changer very conveniently, and reduces the workload in management.
Description
Technical Field
The invention belongs to the technical field of data management systems, and particularly relates to a tap changer data processing method.
Background
The transformer tap changer is one of core components of the transformer, and plays important roles of stabilizing the central voltage of a load, adjusting reactive power flow, increasing the dispatching flexibility of a power grid and the like in a power system. It is very important to monitor the mechanical operation state of the tap changer through various signals (such as vibration signal, driving current and rotation angle). The management of various signal data for monitoring is also an original manual management mode. With the increase in tap changer applications, the amount of information data increases dramatically. Due to the diversification of tap changer types, contact positions and the different signals collected, the data management of tap changers becomes more and more cumbersome and complex. In the face of huge information quantity, the traditional manual management can hardly be realized, in this case, the management by a database becomes necessary, and the advantages of a computer can be utilized to improve the efficiency of tap changer data management. Through the system, standardized management, scientific statistics and quick query of information can be realized, so that the workload and human errors in the aspect of management are reduced.
The tap changer data management system is developed by solving the problems of the increase of the number of tap changers and the increase of the information quantity, realizing the modernization of management, gradually getting rid of the manual management mode of the current tap changer data management and improving the data management efficiency. The invention can realize a series of functions such as tap changer data storage, various signal inquiry and the like.
Disclosure of Invention
In order to overcome the defects in the prior art, the invention provides a tap changer data management system development technology, which improves the efficiency of tap changer data management and reduces the workload and human errors in management.
In order to achieve the above object, the present invention adopts the following technical solutions.
A data processing method of a tapping switch is characterized in that: the method comprises the following steps:
1) creating a 'tap changer data management' database based on SQL Server2008, and creating a corresponding table in the database; the tap switch data comprises a vibration signal, a driving current signal and a rotation angle signal of the tap switch;
2) implementing various operations on the tap changer data based on the Visual Studio 2010, including adding, modifying and deleting;
3) it is checked whether the tap changer data processing function is implemented.
The present invention further includes the following preferred embodiments.
In step 1), a "tap changer data management" database is created based on SQL Server2008, and a corresponding table in the database is created according to project requirements, which specifically includes the following steps:
1.1 creating a corresponding table in the database, comprising: the system comprises an experiment information meter, a normal vibration signal meter, a contact falling vibration signal meter, a contact loosening vibration signal meter, a normal driving ammeter, a fault driving ammeter, a normal rotation angle meter and a fault rotation angle meter;
1.2, the collected tap changer data is imported into a corresponding table of a tap changer data management database created by SQL Server2008 in a statement or guide mode.
The content of the experiment information table comprises experiment time, tap switch types, tap switch states and sampling frequency;
the content of the normal vibration signal meter comprises the state of a tap changer, sampling time and the position of a tap changer contact;
the content of the contact falling vibration signal meter comprises a tap switch state, sampling time and a tap switch contact position;
the contents of the contact looseness vibration signal meter comprise a tap switch state, sampling time and a tap switch contact position;
the content of the normal driving ammeter comprises a tap changer state, sampling time and a tap changer contact position;
the content of the fault driving ammeter comprises a tap switch state, sampling time and a tap switch contact position;
the content of the normal rotation angle meter comprises a tap changer state, sampling time and a tap changer contact position;
the content of the fault rotation angle meter comprises a tap changer state, sampling time and a tap changer contact position;
the tapping switch state comprises a normal state, a contact fall, a contact looseness and a clamping state; the tap switch contact position refers to the tap switch gear shift change condition, and is represented by the tap switch contact position X-Y when the tap switch is switched from the X gear to the Y gear.
In step 2), various operations on tap changer data are specifically realized by:
NET technology is used for connecting Visual Studio 2010 with a tap changer data management database, namely, a SqlConnection object is used for connecting with an SQL database;
2.2, 4 main interfaces are established to access tap changer data stored in tap changer data management; the 4 main interfaces are respectively a vibration signal data management interface, a current signal data management interface, a rotation angle data management interface and an experiment information data management interface;
the vibration signal data management interface is used for checking and deleting normal vibration signal data of the tap switch and exporting the data; checking and deleting data of the contact falling vibration signal and exporting the data; checking and deleting data of the contact loosening vibration signal and exporting the data;
the current signal data management interface is used for checking and deleting normal driving current data and exporting the data; checking and deleting fault driving current data and exporting the data;
the rotation angle data management interface is used for realizing the checking and deleting of the normal rotation angle data and the exporting of the data; checking and deleting fault rotation angle data and exporting the data;
the experiment information data management interface is used for viewing, adding, modifying and deleting experiment information;
2.3 designing a corresponding sub-interface corresponding to each main interface, wherein the sub-interfaces are triggered by the main interface to which the sub-interfaces belong, and managers can realize the operations of adding, modifying and deleting tap changer data by inputting and deleting data information of the sub-interfaces;
the vibration signal data management interface corresponds to 3 sub-interfaces and is respectively used for deleting the normal vibration data, the contact falling vibration data and the contact loosening vibration data of the tapping switch according to the position of the contact, namely deleting the normal vibration data sub-interface, the contact falling data sub-interface and the contact loosening data sub-interface of the tapping switch;
the current signal data management interface corresponds to 2 sub-interfaces and is respectively used for deleting the normal driving current data and the fault driving current data of the tapping switch according to the position of the contact, namely deleting the normal driving current data sub-interface and deleting the fault driving current data sub-interface;
the rotation angle data management interface corresponds to 2 sub-interfaces and is respectively used for deleting the normal rotation angle data and the fault rotation angle data of the tap changer according to the position of the contact, namely deleting the normal rotation angle data sub-interface and deleting the fault rotation angle data sub-interface;
the experiment information data management interface corresponds to 3 sub-interfaces and is used for modifying, deleting and adding experiment information data according to the contact position, namely modifying the experiment information sub-interface, deleting the experiment information sub-interface and adding the experiment information sub-interface.
In step 3), the following contents are specifically included:
corresponding operation is realized on the data in the database by logging in each main interface; then, whether the corresponding data in the tap changer database in SQL Server2008 changes or not is observed, and if the corresponding data in the tap changer database in SQL Server2008 changes, it indicates that the tap changer data processing function is implemented.
The invention achieves the following beneficial effects:
1. compared with the traditional tap changer data management, the tap changer data management method can achieve standardized management, scientific statistics and quick query of information, and therefore workload and human errors in the management aspect are reduced.
2. The invention manages the data of the tap changer more intuitively and reliably.
3. The manual management mode of the data management of the current tap changer is gradually eliminated, and the data management efficiency is improved.
Drawings
Fig. 1 is a logical block diagram of a tap changer data management system;
fig. 2 is a vibration signal data management main interface of the tap changer data management system; fig. 3 is a drive current data management main interface of the tap changer data management system;
fig. 4 is a rotational angle data management main interface of the tap changer data management system;
fig. 5 is an experimental information data management main interface of the tap changer data management system.
Fig. 6 is a login interface for a tap changer data management system.
Detailed Description
The invention is further described below with reference to the accompanying drawings. The following examples are only for illustrating the technical solutions of the present invention more clearly, and the protection scope of the present invention is not limited thereby.
Fig. 1 is a logical structure diagram of a tap changer data management system established based on the tap changer data processing method of the present invention, and the tap changer data management system has 4 main interfaces, that is, an experimental information management main interface, a vibration signal management main interface, a current signal management main interface, and a rotation angle signal management main interface. Because each main interface is used for realizing functions such as adding, modifying, deleting and the like, 10 sub-interfaces are needed, namely adding experiments, modifying experiments, deleting normal contacts, deleting burning loss of the contacts, deleting loose contacts, deleting normal currents, deleting fault currents, deleting normal rotation angles and deleting fault rotation angle sub-interfaces.
And programming the button events in the main interface and the sub-interface to realize the corresponding functions.
The corresponding sub-interface can be triggered by clicking a button in the main interface, so that corresponding operation on data stored in the tap changer database is realized.
The tap changer data management system of the application develops the functions shown in fig. 1, so as to provide a tap changer data processing method, which comprises the following steps:
(1) creating a 'tap changer data management' database based on SQL Server2008, and creating a corresponding table in the database according to project requirements;
the method comprises the following specific steps:
1) according to project requirements, the database needs 8 tables in total. Namely: experiment information table, normal vibration signal table, contact vibration signal table that drops, contact vibration signal table that becomes flexible, normal drive ampere meter, trouble drive ampere meter, normal rotation angle table and trouble rotation angle table.
The experimental information table comprises test time, tap switch types (indicating experimental objects), tap switch states (normal state, contact falling, contact loosening, jamming and the like) and sampling frequency.
The normal vibration signal meter comprises a tap switch state and time (sampling time), and the tap switch contact position contact falling vibration signal meter comprises a tap switch state, time (sampling time) and a tap switch contact position; the contact looseness vibration signal meter comprises a tap switch state, time (sampling time) and a tap switch contact position; the normal current signal table comprises a tap switch state and time (sampling time), and the tap switch contact position fault current signal table comprises a tap switch state, time (sampling time) and a tap switch contact position;
the normal rotation angle meter comprises a tap changer state, time (sampling time) and a tap changer contact position; the fault rotation angle table includes tap switch state, time (sampling time), tap switch contact position.
The tap switch contact position refers to the tap switch gear shift change condition, and is represented by the tap switch contact position X-Y when the tap switch is switched from the X gear to the Y gear.
2) And importing the collected tap changer data into a corresponding table of an SQL Server2008 tap changer database in a statement or guide mode.
(2) Creating an application program for tap changer data management based on Visual Studio 2010 software, and realizing various operations on tap changer data, including addition, modification, deletion and the like;
NET technology is used to connect Visual Studio 2010 with SQL database, so that administrator can manage data through interface, that is, SqlConnection object is used to connect with SQL database.
2.2 the invention realizes data management of three signals of the tap changer, namely a vibration signal, a driving current signal and a rotation angle signal, wherein each signal is divided into a normal state and a fault state. In addition, the experimental information data is added, so that the application program of the invention comprises 4 main interfaces, namely a vibration signal data management interface, a current signal data management interface, a rotation angle data management interface and an experimental information data management interface.
The 4 main interfaces can realize the operations of accessing and checking the data stored in the tap changer database in the SQL Server2008, and the like.
The vibration signal data management interface mainly realizes 1) checking and deleting of normal vibration signal data of the tap switch and data exporting; 2) checking and deleting data of the contact falling vibration signal and exporting the data; 3) and checking and deleting data of the contact loosening vibration signal and exporting the data.
The current signal data management interface mainly realizes 1) checking and deleting of normal driving current data and data exporting; 2) and checking and deleting the fault driving current data and exporting the data.
The rotation angle data management interface mainly realizes 1) checking and deleting of normal rotation angle data and exporting of the data; 2) and checking and deleting fault rotation angle data and exporting the data.
The experiment information data management interface mainly realizes the checking, adding, modifying and deleting of experiment information. As shown in detail in fig. 2, 3, 4 and 5.
And 2.3 designing a corresponding sub-interface corresponding to each main interface, wherein the sub-interfaces are triggered by the main interface to which the sub-interfaces belong, and managers realize the operations and functions of adding, modifying and deleting tap changer data by inputting and deleting data information of the sub-interfaces.
The vibration signal data management interface corresponds to 3 sub-interfaces and is respectively used for deleting the normal vibration data, the contact falling vibration data and the contact loosening vibration data of the tapping switch according to the position of the contact, namely deleting the normal vibration data sub-interface, the contact falling data sub-interface and the contact loosening data sub-interface of the tapping switch.
The current signal data management interface corresponds to 2 sub-interfaces and is used for deleting the normal driving current data and the fault driving current data of the tap changer according to the position of the contact, namely deleting the normal driving current data sub-interface and deleting the fault driving current data sub-interface.
The rotation angle data management interface corresponds to 2 sub-interfaces and is respectively used for deleting the normal rotation angle data and the fault rotation angle data of the tap changer according to the position of the contact, namely deleting the normal rotation angle data sub-interface and deleting the fault rotation angle data sub-interface.
The experiment information data management interface corresponds to 3 sub-interfaces and is used for modifying, deleting and adding experiment information data according to the contact position, namely modifying the experiment information sub-interface, deleting the experiment information sub-interface and adding the experiment information sub-interface.
Designing a corresponding sub-interface on the main page comprises the following steps:
fig. 2 is a vibration signal data management main interface diagram of a tap changer data management system, and the specific design is as follows: the method comprises the steps that 6 button controls are added to a newly built vibration signal interface, 3 button controls used for displaying signals are named as 'normal signals', 'contact fall-off' and 'contact looseness', and 3 button trigger controls used for deleting signals are named as 'normal signals', 'contact fall-off' and 'contact looseness'. And a datagrid control is added for displaying the vibration data of the tap changer in a normal state, the vibration data of the contact falling and the vibration data of the contact loosening. And 3 button controls for deletion are used to trigger the controls for triggering 3 sub-interfaces of the vibration signal data management interface.
The design for deleting the normal vibration data sub-interface of the tap changer is as follows: adding a 'textBox' control for inputting the deleted corresponding contact position information, and then adding a 'button' control for triggering deletion of corresponding contact normal data in a tap switch vibration signal data table according to the input contact normal position;
the design of the sub-interface for deleting the contact drop data is as follows: adding a 'textBox' control for inputting the deleted corresponding contact position information, and then adding a 'button' control for triggering deletion of corresponding contact falling data in a tap switch vibration signal data table according to the input contact falling position;
the design of the data sub-interface for deleting the loose contact is as follows: adding a 'textBox' control for inputting the deleted corresponding contact position information, and then adding a 'button' control for triggering deletion of corresponding contact loosening data in a tap switch vibration signal data table according to the input contact loosening position;
as can be seen from the figure, by displaying the information button, it is possible to display the normal vibration signal, the contact fall, the loose contact, and the signals when the tap changer is at different positions (Location12, which indicates that the tap changer contact is changed from 1 st gear to 2 nd gear, and the following meaning is the same as above). The vibration signal data in the tap changer database can also be deleted through a delete button.
Fig. 3 is a main interface diagram of current signal data management of a tap changer data management system, which is specifically designed as follows: 4 button controls are added to a newly-built current signal interface, 2 button controls used for displaying signals are named as a normal signal and a fault signal respectively, and 2 button trigger controls used for deleting signals are named as a normal signal and a fault signal respectively. And a datagrid control is added for displaying normal driving current data and fault driving current data. And 2 "button" controls for deletion are used to trigger 2 sub-interfaces of the current signal data management interface.
The design for deleting the normal drive current data sub-interface is as follows: adding a 'textBox' control for inputting the deleted corresponding contact position information, and then adding a 'button' control for triggering deletion of corresponding contact position current data in a tap switch current signal data table according to the input contact position;
the design for deleting the fault drive current data sub-interface is as follows: adding a 'textBox' control for inputting the deleted corresponding contact position information, and then adding a 'button' control for triggering deletion of corresponding contact position current data in a tap switch current signal data table according to the input contact position;
as can be seen from the figure, by displaying the information button, the normal current signal, the fault current signal and the signals when the tap changer is in different positions can be displayed. The current signal data in the tap changer database may also be deleted by a delete button.
Fig. 4 is a view of a main interface for managing rotation angle data of a tap changer data management system, which is specifically designed to: adding 4 button controls on a newly-built rotation angle signal interface, wherein 2 button controls used for displaying signals are respectively named as a normal signal and a fault signal, and 2 button trigger controls used for deleting signals are respectively named as a normal signal and a fault signal. And a datagrid control is added for displaying the normal rotation angle data and the fault rotation angle data. And 3 button controls for deletion are used to trigger 2 sub-interfaces of the rotation angle signal data management interface.
The design for deleting the normal signal sub-interface is as follows: adding a 'textBox' control for inputting the deleted corresponding contact position information, and then adding a 'button' control for triggering deletion of corresponding contact position rotation angle data in the tap changer rotation angle signal data set according to the input contact position;
the design for deleting the fault signal sub-interface is as follows: and adding a 'textBox' control for inputting the deleted corresponding contact position information, and adding a 'button' control for triggering deletion of the corresponding contact position rotation angle data in the tap changer rotation angle signal data set according to the input contact position.
As can be seen from the figure, by displaying the information button, the normal rotation angle, the fault rotation angle and the signals when the tap changer is in different positions can be displayed. The rotation angle data in the tap changer database can also be deleted through a delete button.
Fig. 5 is a main interface diagram of experimental information data management of a tap changer data management system, which is specifically designed as follows: and 5 button controls are added and named as a display signal, an adding information, a deleting information, a modifying information and an exiting respectively, wherein an adding information button is used for triggering an adding experiment information sub-interface, a deleting information button is used for triggering a deleting experiment information sub-interface, and a modifying information button is used for triggering a modifying experiment information sub-interface. The "exit" button is used to exit the current interface. And a datagrid control is added for displaying the data content of the experimental information.
Add experimental information sub-interface: 4 "textBox" controls are added for entering the added experimental information, i.e. contact type, tap changer type, experimental time and sampling frequency. A button control is added for triggering to update the tap changer experiment information data set according to the input experiment information;
add experimental information sub-interface: 4 "textBox" controls are added for entering the added experimental information, i.e. contact type, tap changer type, experimental time and sampling frequency. A button control is added for triggering to update the tap changer experiment information data table according to the input experiment information;
delete experiment information sub-interface: and adding 1 'textBox' control for inputting the deleted corresponding contact position information. A button control is added for triggering deletion of corresponding experimental information data of the tap switch experimental information data table according to the input contact position information;
modify experiment information sub-interface: add 1 "textBox" control for entering the modified corresponding contact position information. And a button control is added for triggering the modification of the corresponding experimental information data of the tap changer experimental information data table according to the input contact position information. As can be seen from the figure, the experimental information in the database can be displayed, modified, added and deleted.
After the main interface is designed, a corresponding sub-interface is also required to be designed so as to realize corresponding operation. And after a corresponding button of the main interface is clicked, the sub-interface is triggered, and the manager realizes a corresponding function through inputting data information of the sub-interface.
In order to ensure the confidentiality and the security of data, a login interface is also required, as shown in fig. 6, and only after the user name and the password are correct, the access and the corresponding operation to the data of the tap changer can be carried out.
(3) The tap changer data management system of claim 1, wherein: testing the established application program, and checking whether the designed function is realized, wherein the specific steps are as follows:
and entering various main interfaces through the login interface, and after clicking a corresponding button, realizing corresponding operation on data in the database. And then observing whether corresponding data in the tap changer database in the SQL Server2008 changes or not, if the corresponding data in the tap changer database in the SQL Server2008 changes correspondingly, indicating that the application program can be successful, otherwise, entering an interface corresponding to the Visual Studio 2010 to debug the program until achieving the function.
Finally, it should be noted that: the above embodiments are only for illustrating the technical solutions of the present invention and not for limiting the same, and although the present invention is described in detail with reference to the above embodiments, those of ordinary skill in the art should understand that: modifications and equivalents may be made to the embodiments of the invention without departing from the spirit and scope of the invention, which is to be covered by the claims.
Claims (3)
1. A data processing method of a tapping switch is characterized in that: the method comprises the following steps:
1) creating a 'tap changer data management' database based on SQL Server2008, and creating a corresponding table in the database; the tap switch data comprises a vibration signal, a driving current signal and a rotation angle signal of the tap switch;
1.1 creating a corresponding table in the database, comprising: the system comprises an experiment information meter, a normal vibration signal meter, a contact falling vibration signal meter, a contact loosening vibration signal meter, a normal driving ammeter, a fault driving ammeter, a normal rotation angle meter and a fault rotation angle meter;
1.2, importing the collected tap changer data into a corresponding table of a tap changer data management database created by SQL Server2008 in a statement or guide mode;
2) implementing various operations on the tap changer data based on the Visual Studio 2010, including adding, modifying and deleting; connecting the SqlConnection object with an SQL database, and setting a vibration signal data management interface, a current signal data management interface, a rotation angle data management interface and an experiment information data management interface; accessing data stored in a tap changer database in SQL Server2008 and checking operation are realized through each management interface;
3) checking whether a tap changer data processing function is realized, and entering each management interface through login to realize corresponding operation on data in a database; then, whether the corresponding data in the tap changer database in SQL Server2008 changes or not is observed, and if the corresponding data in the tap changer database in SQL Server2008 changes, it indicates that the tap changer data processing function is implemented.
2. Tap changer data processing method according to claim 1, characterized in that:
the content of the experiment information table comprises experiment time, tap switch types, tap switch states and sampling frequency;
the content of the normal vibration signal meter comprises the state of a tap changer, sampling time and the position of a tap changer contact;
the content of the contact falling vibration signal meter comprises a tap switch state, sampling time and a tap switch contact position;
the contents of the contact looseness vibration signal meter comprise a tap switch state, sampling time and a tap switch contact position;
the content of the normal driving ammeter comprises a tap changer state, sampling time and a tap changer contact position;
the content of the fault driving ammeter comprises a tap switch state, sampling time and a tap switch contact position;
the content of the normal rotation angle meter comprises a tap changer state, sampling time and a tap changer contact position;
the content of the fault rotation angle meter comprises a tap changer state, sampling time and a tap changer contact position;
the tapping switch state comprises a normal state, a contact fall, a contact looseness and a clamping state; the tap switch contact position refers to the tap switch gear shift change condition, and is represented by the tap switch contact position X-Y when the tap switch is switched from the X gear to the Y gear.
3. Tap changer data processing method according to claim 1, characterized in that:
in step 2), various operations on tap changer data are specifically realized by:
NET technology is used for connecting Visual Studio 2010 with a tap changer data management database, namely, a SqlConnection object is used for connecting with an SQL database;
2.2, 4 main interfaces are established to access tap changer data stored in tap changer data management; the 4 main interfaces are respectively a vibration signal data management interface, a current signal data management interface, a rotation angle data management interface and an experiment information data management interface;
the vibration signal data management interface is used for checking and deleting normal vibration signal data of the tap switch and exporting the data; checking and deleting data of the contact falling vibration signal and exporting the data; checking and deleting data of the contact loosening vibration signal and exporting the data;
the current signal data management interface is used for checking and deleting normal driving current data and exporting the data; checking and deleting fault driving current data and exporting the data;
the rotation angle data management interface is used for realizing the checking and deleting of the normal rotation angle data and the exporting of the data; checking and deleting fault rotation angle data and exporting the data;
the experiment information data management interface is used for viewing, adding, modifying and deleting experiment information;
2.3 designing a corresponding sub-interface corresponding to each main interface, wherein the sub-interfaces are triggered by the main interface to which the sub-interfaces belong, and managers can realize the operations of adding, modifying and deleting tap changer data by inputting and deleting data information of the sub-interfaces;
the vibration signal data management interface corresponds to 3 sub-interfaces and is respectively used for deleting the normal vibration data, the contact falling vibration data and the contact loosening vibration data of the tapping switch according to the position of the contact, namely deleting the normal vibration data sub-interface, the contact falling data sub-interface and the contact loosening data sub-interface of the tapping switch;
the current signal data management interface corresponds to 2 sub-interfaces and is respectively used for deleting the normal driving current data and the fault driving current data of the tapping switch according to the position of the contact, namely deleting the normal driving current data sub-interface and deleting the fault driving current data sub-interface;
the rotation angle data management interface corresponds to 2 sub-interfaces and is respectively used for deleting the normal rotation angle data and the fault rotation angle data of the tap changer according to the position of the contact, namely deleting the normal rotation angle data sub-interface and deleting the fault rotation angle data sub-interface;
the experiment information data management interface corresponds to 3 sub-interfaces and is used for modifying, deleting and adding experiment information data according to the contact position, namely modifying the experiment information sub-interface, deleting the experiment information sub-interface and adding the experiment information sub-interface.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910357362.9A CN110083621B (en) | 2019-04-29 | 2019-04-29 | Tap changer data processing method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910357362.9A CN110083621B (en) | 2019-04-29 | 2019-04-29 | Tap changer data processing method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110083621A CN110083621A (en) | 2019-08-02 |
| CN110083621B true CN110083621B (en) | 2021-07-16 |
Family
ID=67417806
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910357362.9A Active CN110083621B (en) | 2019-04-29 | 2019-04-29 | Tap changer data processing method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110083621B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2013090067A1 (en) * | 2011-12-15 | 2013-06-20 | Microsoft Corporation | Intelligently recommending schemas based on user input |
| CN104124757A (en) * | 2014-06-30 | 2014-10-29 | 国网青海省电力公司电力科学研究院 | Background operation monitoring system for power grid fault simulation detection device of high-altitude photovoltaic power station |
| CN106646210A (en) * | 2016-11-17 | 2017-05-10 | 国网电力科学院武汉南瑞有限责任公司 | On-load tap-changer state online monitoring system |
| CN108536736A (en) * | 2018-03-06 | 2018-09-14 | 航天东方红卫星有限公司 | A kind of moonlet integrated test system real-time data base building method and system |
-
2019
- 2019-04-29 CN CN201910357362.9A patent/CN110083621B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2013090067A1 (en) * | 2011-12-15 | 2013-06-20 | Microsoft Corporation | Intelligently recommending schemas based on user input |
| CN104124757A (en) * | 2014-06-30 | 2014-10-29 | 国网青海省电力公司电力科学研究院 | Background operation monitoring system for power grid fault simulation detection device of high-altitude photovoltaic power station |
| CN106646210A (en) * | 2016-11-17 | 2017-05-10 | 国网电力科学院武汉南瑞有限责任公司 | On-load tap-changer state online monitoring system |
| CN108536736A (en) * | 2018-03-06 | 2018-09-14 | 航天东方红卫星有限公司 | A kind of moonlet integrated test system real-time data base building method and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110083621A (en) | 2019-08-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6380949B2 (en) | Man-machine interface for a virtual annunciator panel display | |
| US8589886B2 (en) | System and method for automatic hardware and software sequencing of computer-aided design (CAD) functionality testing | |
| EP2778929B1 (en) | Test script generation system | |
| CN111078482B (en) | Communication navigation equipment test system, method, equipment and readable storage medium | |
| US20120304058A1 (en) | Database monitor replay | |
| CA2739231A1 (en) | System and method for analytic process design | |
| CN115309566B (en) | Dynamic management method and system for service interface | |
| CN114518584B (en) | Automatic testing system for batch production satellite performance | |
| CN110597721A (en) | Automatic interface pressure testing method based on pressure testing script | |
| CN110471787A (en) | Problem catching method, system, device, electronic equipment and storage medium on line | |
| US20040158804A1 (en) | Parameter oriented graphical representation of hardware timing and triggering capabilities with contextual information | |
| CN109816349A (en) | A kind of test verification management platform | |
| CN110083621B (en) | Tap changer data processing method | |
| US20090070743A1 (en) | System and method for analyzing software applications | |
| CN209446697U (en) | The ageing tester of module product | |
| US20030085925A1 (en) | In-context creation and editing of masks and waveforms | |
| JP5022520B2 (en) | Plan creation support program and plan creation support system | |
| Van der Beken et al. | CODAS: The JET control and data acquisition system | |
| CN116559624A (en) | Chip testing method, system, device and storage medium | |
| US7472355B2 (en) | Computer-implemented method for managing commands for a terminal session | |
| CN107423419A (en) | The batch introduction method and system of a kind of Parameter File | |
| CN103678974B (en) | Remote access client terminal of chemico-mechanical polishing control system | |
| CN112965910A (en) | Automatic regression testing method and device, electronic equipment and storage medium | |
| US20190311034A1 (en) | Multiple network device type support using variable mapping | |
| CN110083358B (en) | Tool for modifying switch number of traction automatic switching device based on scripting language |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |