Intelligent management method and system for standing book of substation equipment

Abstract

The invention provides a transformer substation equipment ledger intelligent management method, which comprises the following steps that: a client displays a graphical user interface and a plurality of function options correspondingly deployed, and responds to the selection operation of a user on a certain function option to generate a corresponding instruction and send the instruction to a server; wherein the function options comprise machine account information query, machine account information import and export and operation ticket verification, and a query instruction, an import instruction, an export instruction and a verification instruction are correspondingly generated respectively; and the server extracts corresponding data from a preset database according to a corresponding instruction sent by the client, checks the data, and further feeds back the checked data to the client. By implementing the machine account information management method and device, more convenient and efficient working experience is provided for workers through an intelligent management mode, and the safety risk caused by poor machine account information management is reduced.

Description

Technical Field

[0001] The present invention relates to the technical field of power systems, and in particular to a method and system for intelligent management of substation equipment ledgers. Background Art

[0002] In the power industry, substations are key nodes for power conversion and distribution, and their operational safety and stability have a vital impact on the reliability of the entire power grid. However, the current substation equipment ledger information is mainly stored in cloud disks, and this management method has many disadvantages. First, when filling out operation tickets and work tickets, staff need to frequently query the cloud disk for verification, which is cumbersome and inefficient. Secondly, due to the untimely maintenance and management of the ledger information in the cloud disk, data updates often lag, which increases the risk of errors in operation tickets and work tickets, which may threaten the safe operation of the substation.

[0003] In order to solve these problems and improve the efficiency and accuracy of ledger information management, it is necessary to provide an intelligent management method for substation equipment ledgers, aiming to provide staff with a more convenient and efficient work experience through intelligent management methods, and reduce the safety risks caused by poor ledger information management. Summary of the invention

[0004] The technical problem to be solved by the embodiments of the present invention is to provide a method and system for intelligent management of substation equipment ledgers, aiming to provide staff with a more convenient and efficient work experience through intelligent management methods, and reduce the safety risks caused by poor management of ledger information.

[0005] In order to solve the above technical problems, an embodiment of the present invention provides a method for intelligent management of substation equipment ledgers, the method comprising the following steps:

[0006] The client displays a graphical user interface and multiple function options corresponding to the graphical user interface, and responds to the user's selection of a function option to generate a corresponding instruction and send it to the server; wherein the function options include ledger information query, ledger information import, ledger information export and operation ticket verification; if the function option is ledger information query, the generated instruction is a query instruction; if the function option is ledger information import, the generated instruction is an import instruction; if the function option is ledger information export, the generated instruction is an export instruction; if the function option is operation ticket verification, the generated instruction is a verification instruction;

[0007] The server extracts and verifies the corresponding data from a preset database according to the corresponding instruction sent by the client, and further feeds back the verified data to the client.

[0008] The server extracts and verifies the corresponding data from a preset database according to the corresponding instruction sent by the client, and further feeds back the verified data to the client in the following steps:

[0009] If the instruction received from the client is a query instruction, a hierarchically stored equipment ledger information table is extracted from a preset database, and corresponding key information is extracted from the equipment ledger information table; wherein the equipment ledger information table includes a patrol center table, a substation table, a panel cabinet table, and a secondary pressure plate & circuit breaker table arranged in a hierarchical order from high to low; the key information includes the equipment name, equipment code, the operation and maintenance department, substation and panel cabinet to which the equipment belongs, and the secondary pressure plate and circuit breaker on the equipment;

[0010] The extracted key information is checked, and after the check is correct, the checked data is fed back to the client.

[0011] The server extracts and verifies the corresponding data from a preset database according to the corresponding instruction sent by the client, and further feeds back the verified data to the client, which specifically includes:

[0012] If the instruction received from the client is an import instruction, extract the corresponding data to be updated from the preset database and back it up;

[0013] The extracted data to be updated is checked, and after the check is correct, notification information is generated to feed back the checked data to the client.

[0014] The server extracts and verifies the corresponding data from a preset database according to the corresponding instruction sent by the client, and further feeds back the verified data to the client, which specifically includes:

[0015] If the instruction received from the client is an export instruction, extracting corresponding data to be exported from a preset database;

[0016] The extracted data to be exported is checked, and after the check is correct, the checked data is fed back to the client.

[0017] The server extracts and verifies the corresponding data from a preset database according to the corresponding instruction sent by the client, and further feeds back the verified data to the client, which specifically includes:

[0018] If the instruction received from the client is a verification instruction, extracting corresponding operation ticket data from a preset database;

[0019] The extracted operation ticket data is automatically checked, and after the check is correct, the checked data is fed back to the client.

[0020] Wherein, the graphical user interface is constructed using Python's Tkinter library.

[0021] The embodiment of the present invention also provides a substation equipment ledger intelligent management system, including a client and a server; wherein:

[0022] The client is used to display a graphical user interface and multiple function options corresponding to the graphical user interface, and respond to the user's selection operation of a certain function option to generate a corresponding instruction and send it to the server; wherein the function options include ledger information query, ledger information import, ledger information export and operation ticket verification; if the function option is ledger information query, the generated instruction is a query instruction; if the function option is ledger information import, the generated instruction is an import instruction; if the function option is ledger information export, the generated instruction is an export instruction; if the function option is operation ticket verification, the generated instruction is a verification instruction;

[0023] The server is used to extract and verify the corresponding data from a preset database according to the corresponding instructions sent by the client, and further feed back the verified data to the client.

[0024] Wherein, the graphical user interface is constructed using Python's Tkinter library.

[0025] Wherein, the server includes:

[0026] The ledger query feedback module is used to extract the hierarchically stored equipment ledger information table from a preset database and extract the corresponding key information from the equipment ledger information table if the instruction received from the client is a query instruction; and to verify the extracted key information, and after the verification is correct, feed back the verified data to the client; wherein the equipment ledger information table includes a patrol and maintenance center table, a substation table, a panel table, and a secondary pressure plate & circuit breaker table arranged in a hierarchical manner from high to low; the key information includes the equipment name, equipment code, the operation and maintenance department, substation and panel cabinet to which the equipment belongs, and the secondary pressure plate and circuit breaker on the equipment;

[0027] The ledger import feedback module is used to extract and back up the corresponding data to be updated from a preset database if the instruction sent by the client is an import instruction; and to check the extracted data to be updated, and after the check is correct, generate a notification message to feed back the checked data to the client;

[0028] The ledger export feedback module is used to extract the corresponding data to be exported from the preset database if the instruction sent by the client is an export instruction; and to check the extracted data to be exported, and after the verification is correct, feed back the verified data to the client;

[0029] The operation ticket verification feedback module is used to extract the corresponding operation ticket data from a preset database if the instruction received from the client is a verification instruction; and automatically verify the extracted operation ticket data, and after the verification is correct, feed back the verified data to the client.

[0030] Implementing the embodiments of the present invention has the following beneficial effects:

[0031] The present invention displays a graphical user interface and its corresponding multiple functional options through a client, and responds to user selection operations to generate corresponding instructions and send them to a server, so that the server extracts corresponding data from a database and verifies and feeds back to the client, thereby providing staff with a more convenient and efficient work experience through an intelligent management method, and reducing security risks caused by poor management of ledger information. BRIEF DESCRIPTION OF THE DRAWINGS

[0032] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, without paying creative labor, other drawings obtained based on these drawings still belong to the scope of the present invention.

[0033] Figure 1 A flowchart of a method for intelligent management of substation equipment ledgers provided by an embodiment of the present invention;

[0034] Figure 2 A schematic diagram of the structure of a substation equipment inventory intelligent management system provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0035] In order to make the objectives, technical solutions and advantages of the present invention more clear, the present invention will be further described in detail below with reference to the accompanying drawings.

[0036] like Figure 1 As shown in the figure, a method for intelligent management of substation equipment ledgers is proposed in an embodiment of the present invention, and the method comprises the following steps:

[0037] Step S1, the client displays a graphical user interface and a plurality of function options corresponding to the graphical user interface, and responds to the user's selection operation of a certain function option to generate a corresponding instruction and send it to the server; wherein the function options include ledger information query, ledger information import, ledger information export and operation ticket verification; if the function option is ledger information query, the generated instruction is a query instruction; if the function option is ledger information import, the generated instruction is an import instruction; if the function option is ledger information export, the generated instruction is an export instruction; if the function option is operation ticket verification, the generated instruction is a verification instruction;

[0038] Step S2: the server extracts and verifies the corresponding data from a preset database according to the corresponding instruction sent by the client, and further feeds back the verified data to the client.

[0039] The specific process is as follows: in step S1, first, a graphical user interface is constructed on the client using Python's Tkinter library to achieve user-friendly front-end interaction. Among them, the graphical user interface will display multiple functional options that have been deployed, including but not limited to ledger information query, ledger information import, ledger information export, and operation ticket verification. For example, it also includes permission management (such as adding, deleting, and modifying, etc.), ledger information update, ledger information storage, etc.

[0040] Secondly, when the user selects any of the function options, a corresponding instruction will be generated in response and sent to the server. If the function option is ledger information query, the generated instruction is a query instruction; if the function option is ledger information import, the generated instruction is an import instruction; if the function option is ledger information export, the generated instruction is an export instruction; if the function option is operation ticket verification, the generated instruction is a verification instruction.

[0041] In step S2, the server selects MySQL database as the data storage and management core to ensure data persistence, security and fast response.

[0042] At this time, the server will feedback different data to the client based on different instructions, as follows:

[0043] (1) If the command received from the client is a query command: first, extract the hierarchically stored equipment ledger information table from the preset database, and extract the corresponding key information from the equipment ledger information table; the equipment ledger information table includes a patrol center table, a substation table, a panel table, and a secondary pressure plate & circuit breaker table arranged in a hierarchical order from high to low; the key information includes the equipment name, equipment code, the operation and maintenance department, substation and panel cabinet to which the equipment belongs, and the secondary pressure plate and circuit breaker on the equipment;

[0044] Secondly, the extracted key information is checked, and after the check is confirmed to be correct, the checked data is fed back to the client.

[0045] It is understandable that the equipment inventory information table is stored in a hierarchical manner, allowing users to quickly query through a hierarchical search method.

[0046] (2) If the instruction received from the client is an import instruction: first, the corresponding data to be updated is extracted from the preset database and backed up; second, the extracted data to be updated is checked, and after the check is correct, a notification message is generated to feed back the checked data to the client, so as to facilitate the import and backup of data.

[0047] (3) If the instruction received from the client is an export instruction: first, the corresponding data to be exported is extracted from the preset database; second, the extracted data to be exported is checked, and after the check is correct, the checked data is fed back to the client, which facilitates the export of data.

[0048] (4) If the instruction received from the client is a verification instruction: first, the corresponding operation ticket data is extracted from the preset database; second, the extracted operation ticket data is automatically checked, and after the verification is correct, the checked data is fed back to the client, thus ensuring the accuracy and logic of the operation ticket.

[0049] It should be noted that the automatic verification of operation ticket data is to automatically verify the ledger information through a preset operation ticket verification algorithm to improve the accuracy of the operation ticket and work efficiency.

[0050] like Figure 2 As shown in the figure, an intelligent management system for substation equipment records is provided in an embodiment of the present invention, including a client 1 and a server 2; wherein,

[0051] The client 1 is used to display a graphical user interface and multiple functional options corresponding to the graphical user interface, and respond to the user's selection operation of a certain functional option to generate a corresponding instruction and send it to the server 2; wherein the functional options include ledger information query, ledger information import, ledger information export and operation ticket verification; if the functional option is ledger information query, the generated instruction is a query instruction; if the functional option is ledger information import, the generated instruction is an import instruction; if the functional option is ledger information export, the generated instruction is an export instruction; if the functional option is operation ticket verification, the generated instruction is a verification instruction;

[0052] The server 2 is used to extract and verify the corresponding data from a preset database according to the corresponding instructions sent by the client 1, and further feed back the verified data to the client.

[0053] Wherein, the graphical user interface is constructed using Python's Tkinter library.

[0054] Wherein, the server 2 includes:

[0055] The ledger query feedback module is used to extract the hierarchically stored equipment ledger information table from a preset database and extract the corresponding key information from the equipment ledger information table if the instruction received from the client is a query instruction; and to verify the extracted key information, and after the verification is correct, feed back the verified data to the client; wherein the equipment ledger information table includes a patrol and maintenance center table, a substation table, a panel table, and a secondary pressure plate & circuit breaker table arranged in a hierarchical manner from high to low; the key information includes the equipment name, equipment code, the operation and maintenance department, substation and panel cabinet to which the equipment belongs, and the secondary pressure plate and circuit breaker on the equipment;

[0056] The ledger import feedback module is used to extract and back up the corresponding data to be updated from a preset database if the instruction sent by the client is an import instruction; and to check the extracted data to be updated, and after the check is correct, generate a notification message to feed back the checked data to the client;

[0057] The ledger export feedback module is used to extract the corresponding data to be exported from the preset database if the instruction sent by the client is an export instruction; and to check the extracted data to be exported, and after the verification is correct, feed back the verified data to the client;

[0058] The operation ticket verification feedback module is used to extract the corresponding operation ticket data from a preset database if the instruction received from the client is a verification instruction; and automatically verify the extracted operation ticket data, and after the verification is correct, feed back the verified data to the client.

[0059] Implementing the embodiments of the present invention has the following beneficial effects:

[0060] The present invention displays a graphical user interface and its corresponding multiple functional options through a client, and responds to user selection operations to generate corresponding instructions and send them to a server, so that the server extracts corresponding data from a database and verifies and feeds back to the client, thereby providing staff with a more convenient and efficient work experience through an intelligent management method, and reducing security risks caused by poor management of ledger information.

[0061] It is worth noting that in the above system embodiment, the various system modules included are only divided according to functional logic, but are not limited to the above division, as long as the corresponding functions can be achieved; in addition, the specific names of the various functional modules are only for the convenience of distinguishing each other, and are not used to limit the scope of protection of the present invention.

[0062] A person skilled in the art can understand that all or part of the steps in the above-mentioned embodiment method can be completed by instructing related hardware through a program, and the program can be stored in a computer-readable storage medium, such as ROM / RAM, disk, CD-ROM, etc.

[0063] The above disclosure is only the preferred embodiment of the present invention, which certainly cannot be used to limit the scope of the present invention. Therefore, equivalent changes made according to the claims of the present invention are still within the scope of the present invention.

Claims

1. A method for intelligent management of substation equipment records, characterized in that: The method comprises the following steps: The client displays a graphical user interface and multiple function options corresponding to the graphical user interface, and responds to the user's selection of a function option to generate a corresponding instruction and send it to the server; wherein the function options include ledger information query, ledger information import, ledger information export and operation ticket verification; if the function option is ledger information query, the generated instruction is a query instruction; if the function option is ledger information import, the generated instruction is an import instruction; if the function option is ledger information export, the generated instruction is an export instruction; if the function option is operation ticket verification, the generated instruction is a verification instruction; The server extracts and verifies the corresponding data from a preset database according to the corresponding instruction sent by the client, and further feeds back the verified data to the client.

2. The intelligent management method for substation equipment accounts according to claim 1, characterized in that: The server extracts and verifies corresponding data from a preset database according to the corresponding instruction sent by the client, and further feeds back the verified data to the client, specifically comprising: If the instruction received from the client is a query instruction, a hierarchically stored equipment ledger information table is extracted from a preset database, and corresponding key information is extracted from the equipment ledger information table; wherein the equipment ledger information table includes a patrol center table, a substation table, a panel cabinet table, and a secondary pressure plate & circuit breaker table arranged in a hierarchical order from high to low; the key information includes the equipment name, equipment code, the operation and maintenance department, substation and panel cabinet to which the equipment belongs, and the secondary pressure plate and circuit breaker on the equipment; The extracted key information is checked, and after the check is correct, the checked data is fed back to the client.

3. The intelligent management method for substation equipment accounts according to claim 1, characterized in that: The server extracts and verifies corresponding data from a preset database according to the corresponding instruction sent by the client, and further feeds back the verified data to the client, which specifically includes: If the instruction received from the client is an import instruction, extract the corresponding data to be updated from the preset database and back it up; The extracted data to be updated is checked, and after the check is correct, notification information is generated to feed back the checked data to the client.

4. The intelligent management method for substation equipment accounts according to claim 1, characterized in that: The server extracts and verifies corresponding data from a preset database according to the corresponding instruction sent by the client, and further feeds back the verified data to the client, which specifically includes: If the instruction received from the client is an export instruction, extracting corresponding data to be exported from a preset database; The extracted data to be exported is checked, and after the check is correct, the checked data is fed back to the client.

5. The intelligent management method for substation equipment records according to claim 1, characterized in that: The server extracts and verifies corresponding data from a preset database according to the corresponding instruction sent by the client, and further feeds back the verified data to the client, which specifically includes: If the instruction received from the client is a verification instruction, extracting corresponding operation ticket data from a preset database; The extracted operation ticket data is automatically checked, and after the check is correct, the checked data is fed back to the client.

6. The intelligent management method for substation equipment accounts according to claim 1, characterized in that: The graphical user interface is constructed using Python's Tkinter library.

7. An intelligent management system for substation equipment records, characterized in that: Includes client and server; among them, The client is used to display a graphical user interface and multiple function options corresponding to the graphical user interface, and respond to the user's selection operation of a certain function option to generate a corresponding instruction and send it to the server; wherein the function options include ledger information query, ledger information import, ledger information export and operation ticket verification; if the function option is ledger information query, the generated instruction is a query instruction; if the function option is ledger information import, the generated instruction is an import instruction; if the function option is ledger information export, the generated instruction is an export instruction; if the function option is operation ticket verification, the generated instruction is a verification instruction; The server is used to extract and verify the corresponding data from a preset database according to the corresponding instructions sent by the client, and further feed back the verified data to the client.

8. The intelligent management system for substation equipment records according to claim 7, characterized in that: The graphical user interface is constructed using Python's Tkinter library.

9. The intelligent management system for substation equipment records according to claim 7, characterized in that: The server comprises: The ledger query feedback module is used to extract the hierarchically stored equipment ledger information table from a preset database and extract the corresponding key information from the equipment ledger information table if the instruction received from the client is a query instruction; and to verify the extracted key information, and after the verification is correct, feed back the verified data to the client; wherein the equipment ledger information table includes a patrol and maintenance center table, a substation table, a panel table, and a secondary pressure plate & circuit breaker table arranged in a hierarchical manner from high to low; the key information includes the equipment name, equipment code, the operation and maintenance department, substation and panel cabinet to which the equipment belongs, and the secondary pressure plate and circuit breaker on the equipment; The ledger import feedback module is used to extract and back up the corresponding data to be updated from a preset database if the instruction sent by the client is an import instruction; and to check the extracted data to be updated, and after the check is correct, generate a notification message to feed back the checked data to the client; The ledger export feedback module is used to extract the corresponding data to be exported from the preset database if the instruction sent by the client is an export instruction; and to check the extracted data to be exported, and after the verification is correct, feed back the verified data to the client; The operation ticket verification feedback module is used to extract the corresponding operation ticket data from a preset database if the instruction received from the client is a verification instruction; and automatically verify the extracted operation ticket data, and after the verification is correct, feed back the verified data to the client.

Images