A method and device for querying and downloading a power grid enterprise technical specification book

Abstract

This invention provides a method and apparatus for querying and downloading technical specifications for power grid enterprises. The method includes: logging into the power grid enterprise system, automatically inputting preset query range parameters, exporting multiple technical specifications and their corresponding relationship data; matching the corresponding relationship data with the full material information in the power grid enterprise's material master database to obtain a processing result; uploading the processing result to a first database table of a digital capability open platform; encrypting and storing the technical specifications on a file server, and storing the file information of the technical specifications in a second database table of the digital capability open platform; responding to a user's query request for technical specifications, returning a list of files that meet the query request based on the first database table; and downloading the target technical specification from the file server using the second database table based on the user's selection information of the target technical specification entered in conjunction with the file list.

Description

Technical Field

[0001] This invention relates to the field of information technology for power grid enterprises, and in particular to a method and apparatus for querying and downloading technical specifications for power grid enterprises. Background Technology

[0002] Currently, the technical specifications of power grid companies are mainly stored in systems that support, but are not limited to, ECP2.0, and their access relies entirely on manual operation. Administrators must manually log into the system, set search criteria, select and download the required documents page by page, and then distribute them to relevant users via email or other means.

[0003] The existing method has significant drawbacks: First, it is extremely inefficient, with repetitive manual operations being time-consuming and labor-intensive, becoming a bottleneck for business operations. Second, it suffers from severe information barriers, as many users cannot directly access files due to the lack of ECP system accounts, making information retrieval difficult and time-consuming. Finally, it lacks operational reliability and convenience, as manual operations are prone to errors, and the scattered files hinder unified management and rapid retrieval.

[0004] Therefore, existing technologies are insufficient to meet the urgent needs of power grid companies for efficient, convenient, and accurate acquisition and distribution of technical specifications. An innovative automated solution is urgently needed to break down information silos and effectively improve business efficiency. Summary of the Invention

[0005] To address the aforementioned technical problems, embodiments of the present invention provide a method for querying and downloading technical specifications for power grid enterprises, including: Log in to the power grid enterprise system, automatically input the preset query range parameters to trigger the query, export multiple technical specifications, and the corresponding relationship data of each technical specification, wherein the corresponding relationship data is the correspondence data between material code and technical specification ID; The corresponding relationship data is matched with the full material information in the power grid enterprise's material master database to obtain a processing result that includes the corresponding relationship data and the matched material categories. The processing result is uploaded to the first database table of the digital capability open platform; The technical specification is encrypted and stored on a file server, and the file information of the technical specification is stored in the second database table of the digital capability open platform. The file information includes material code and technical specification ID. In response to a user's query request for technical specifications, a list of files that satisfy the query request is returned based on the first database table; Based on the user's selection information of the target technical specification entered in conjunction with the file list, the target technical specification is downloaded from the file server using the second database table.

[0006] In one embodiment, logging into the power grid enterprise system and automatically inputting preset query range parameters to trigger a query includes: Control the RPA robot to log in to the power grid enterprise system, and locate the interface elements of the power grid enterprise system through image recognition or DOM parsing; The query is triggered based on the location of the interface element and the preset query range parameters.

[0007] In one embodiment, the preset query range parameter includes the publication time of the technical specification, wherein the start time of the publication time is determined based on the first day of the current month, and the end time is the current date; Export multiple technical specifications and their corresponding relationship data, including: The paginated query results are selected page by page in a loop to export multiple technical specifications and their corresponding relationship data.

[0008] In one embodiment, the step of matching the corresponding relationship data with the full material information in the power grid enterprise's material master database to obtain a processing result containing the corresponding relationship data and the matched material categories includes: The corresponding relationship data is matched with the full material information in the power grid enterprise's material master database to determine the material categories involved in the corresponding relationship data; An enhanced relational data table is generated by combining the material categories and their corresponding relationships.

[0009] In one embodiment, the method further includes: Based on the material categories in the enhanced relational data table, a material classification tree view is dynamically generated on the digital capability open platform. The material classification tree view includes a material major category layer, a material intermediate category layer, and a material minor category layer. The material classification tree view is mapped to the front-end interface through the IoT management platform.

[0010] In one embodiment, generating an enhanced relational data table by combining the material categories and corresponding relationship data includes: Using the material code as the key field, a LEFTJOIN operation is performed on the corresponding relationship data and the full material information, and the VLOOKUP function is used to match the material sub-category, material medium-category and material major-category information to generate the enhanced relational data table; Uploading the processing result to the first database table of the digital capability open platform includes: A combined field is generated using the material code, technical specification ID, and status identifier, wherein the status identifier is used to characterize the validity of the combined field; Using the combined field as the primary key, the enhanced related data table is uploaded to the first database table in the form of data insertion or update.

[0011] In one embodiment, encrypting and storing the technical specification in a file server includes: Perform a hash calculation on the aforementioned technical specifications to generate a checksum; Based on the verification code, the technical specification is stored in the file server of the digital capability open platform. In one embodiment, the response to a user-initiated query request for a technical specification document, returning a list of documents that satisfy the query request based on the first database table, includes: In response to a user's query request for a technical specification, the query request is sent asynchronously via AJAX, causing the digital capability open platform to respond to the query request and match candidate file information in the first database table based on the query request, with each candidate file information corresponding to a technical specification. Generate a JSON-formatted file list based on the candidate file information; Output the list of files.

[0012] In one embodiment, the method further includes: Based on the input information, the query request is generated by combining one or more of the nodes, material codes, and technical specification IDs of the material classification tree view.

[0013] Another embodiment of the present invention also provides a device for querying and downloading technical specifications of power grid enterprises, comprising: The login module is used to log in to the power grid enterprise system, automatically input preset query range parameters to trigger the query, export multiple technical specifications, and the corresponding relationship data of each technical specification. The corresponding relationship data is the correspondence data between material codes and technical specification IDs. The processing module is used to match the corresponding relationship data with the full material information in the power grid enterprise's material master database to obtain a processing result containing the corresponding relationship data and the matched material categories. The transmission module is used to upload the processing result to the first database table of the digital capability open platform; The storage module is used to encrypt and store the technical specification on a file server, and to store the file information of the technical specification in a second database table of the digital capability open platform. The file information includes material code and technical specification ID. The query module is used to respond to a user's query request for technical specifications and return a list of files that meet the query request based on the first database table. The download module is used to download the target technical specification from the file server using the second database table, based on the selection information of the target technical specification entered by the user in conjunction with the file list.

[0014] Based on the above-disclosed embodiments, it is clear that the original platform for storing technical specifications is cumbersome to log in to, has limited access, is difficult to apply for accounts, and has strict requirements for information retrieval, thus making it difficult for users to query and download technical specifications. This application proposes a solution that uses an RPA robot to completely replace manual operations such as logging into the system, querying, paginating, and exporting files, achieving automated data collection 24 / 7. Simultaneously, by downloading the corresponding relationship data of each technical specification and storing the technical specifications based on this data, along with the generation of a first mapping relationship table and a second mapping relationship table, users can accurately query and download matching technical specifications by inputting material information (i.e., not specific technical specification information) into the digital capability open platform, without needing to authorize login to the original platform for storing technical specifications, thus providing convenience for users.

[0015] Other features and advantages of this application will be set forth in the following description. The objectives and other advantages of this application can be realized and obtained through the structures specifically pointed out in the written description and drawings.

[0016] The technical solution of this application will be further described in detail below with reference to the accompanying drawings and embodiments. Attached Figure Description

[0017] To more clearly illustrate the specific embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the specific embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of the present invention. For those skilled in the art, other drawings can be obtained from these drawings without creative effort.

[0018] Figure 1 This is a flowchart illustrating the method for querying and downloading technical specifications of power grid enterprises in an embodiment of the present invention.

[0019] Figure 2 This is a flowchart illustrating a method for querying and downloading technical specifications for power grid companies, as described in another embodiment of the present invention.

[0020] Figure 3This is a flowchart illustrating a method for querying and downloading technical specifications for power grid companies, as shown in another embodiment of the present invention.

[0021] Figure 4 This is a structural block diagram of the device for querying and downloading technical specifications of power grid enterprises in an embodiment of the present invention. Detailed Implementation

[0022] The specific embodiments of the present invention will now be described in detail with reference to the accompanying drawings, but these are not intended to limit the scope of the invention.

[0023] It should be understood that various modifications can be made to the embodiments disclosed herein. Therefore, the following description should not be considered as limiting, but merely as an example of embodiments. Other modifications within the scope of this disclosure will be apparent to those skilled in the art.

[0024] The accompanying drawings, which are included in and form part of this specification, illustrate embodiments of the present disclosure and, together with the general description of the disclosure given above and the detailed description of the embodiments given below, serve to explain the principles of the disclosure.

[0025] These and other features of the invention will become apparent from the following description of preferred forms of embodiments given as non-limiting examples, with reference to the accompanying drawings.

[0026] It should also be understood that although the invention has been described with reference to some specific examples, those skilled in the art can certainly implement many other equivalent forms of the invention.

[0027] The above and other aspects, features and advantages of this disclosure will become more apparent when taken in conjunction with the accompanying drawings and in view of the following detailed description.

[0028] Specific embodiments of the present disclosure are described thereafter with reference to the accompanying drawings; however, it should be understood that the disclosed embodiments are merely examples of the present disclosure and can be implemented in various ways. Well-known and / or repeated functions and structures are not described in detail to avoid unnecessary or redundant details that could obscure the present disclosure. Therefore, the specific structural and functional details disclosed herein are not intended to be limiting, but are merely representative of the present disclosure and are intended to teach those skilled in the art to use the present disclosure in a variety of substantially any suitable detailed structures.

[0029] This specification may use the phrases “in one embodiment,” “in another embodiment,” “in yet another embodiment,” or “in still another embodiment,” all of which may refer to one or more of the same or different embodiments according to this disclosure.

[0030] The embodiments of the present invention will now be described in detail with reference to the accompanying drawings.

[0031] like Figure 1As shown in the figure, this embodiment of the invention provides a method for querying and downloading technical specifications for power grid enterprises, including: S1: Log in to the power grid enterprise system, automatically input the preset query range parameters to trigger the query, export multiple technical specifications, and the corresponding relationship data of each technical specification, wherein the corresponding relationship data is the correspondence data between material code and technical specification ID; S2: Match the corresponding relationship data with the full material information in the power grid enterprise's material master database to obtain a processing result containing the corresponding relationship data and the matched material categories; S3: Upload the processing result to the first database table of the digital capability open platform; S4: The technical specification is encrypted and stored on a file server, and the file information of the technical specification is stored in the second database table of the digital capability open platform. The file information includes material code and technical specification ID. S5: In response to a user's query request for technical specifications, return a list of files that satisfy the query request based on the first database table; S6: Based on the target technical specification selection information entered by the user in conjunction with the file list, download the target technical specification from the file server using the second database table.

[0032] The power grid enterprise system in this embodiment may be, but is not limited to, the power grid enterprise ECP2.0 system. When the execution system in this embodiment processes logging into the power grid enterprise system and automatically inputting preset query range parameters to trigger a query, it includes: S101: Control the RPA robot to log in to the power grid enterprise system and locate the interface elements of the power grid enterprise system through image recognition or DOM parsing; S102: The query is triggered based on the location of the interface element and the preset query range parameters.

[0033] The preset query range parameter includes the publication time of the technical specification, wherein the start time of the publication time is determined based on the first day of the current month, and the end time is the current date; Export multiple technical specifications and their corresponding relationship data, including: S103: Select each page of the paginated query results in a loop, and export multiple technical specifications and their corresponding relationship data.

[0034] The above steps involve the execution system (hereinafter referred to as the system) automatically retrieving the latest technical specifications and related data from the source system (the power grid enterprise ECP2.0 system) by controlling an RPA robot to replace manual intervention. This technical specification includes multiple documents, which may, but are not limited to, involve different projects or materials. For example, after successful login, the RPA robot simulates a user clicking the "Technical Specification Inquiry" submenu under "Procurement Standard Management". The predefined query range parameter is the publication time of the technical specification. The RPA's built-in business rule engine automatically calculates the time range: the start time is set to the 1st of the current month, and the end time is set to the current system date. The robot automatically inputs these dynamically generated date parameters into the corresponding form fields of the query interface and automatically triggers the "Query" operation. After the system returns the query results, the RPA robot performs two export operations: Export Relationship Table: Triggers the "Export Correspondence" function. Through automated file dialog interaction, the generated Excel file is named and saved to a specified local directory, such as the computer desktop, according to a predefined rule, such as "Material and Technical Specification ID Correspondence Table YYYYMMDD to YYYYMMDD.xlsx".

[0035] The exported technical specification file: To handle potential pagination in the query results, RPA uses a looping logic to select all data items page by page and click the "Export Technical Specification" button. The system generates a compressed file. RPA monitors the download process and names the file according to predefined rules, such as "Technical Specification YYYYMMDD to YYYYMMDD.zip," before saving the file.

[0036] In one embodiment, the step of matching the corresponding relationship data with the full material information in the power grid enterprise's material master database to obtain a processing result containing the corresponding relationship data and the matched material categories includes: S201: Match the corresponding relationship data with the full material information in the power grid enterprise's material master database to determine the material categories involved in the corresponding relationship data; S202: Generate an enhanced relational data table by combining the material categories and corresponding relationship data.

[0037] Furthermore, such as Figure 2 As shown, the method further includes: S7: Based on the material categories in the enhanced relational data table, dynamically generate a material classification tree view on the digital capability open platform. The material classification tree view includes a material major category layer, a material intermediate category layer, and a material minor category layer. S8: Map the material classification tree view to the front-end interface through the IoT management platform.

[0038] The step of generating an enhanced relational data table by combining the material categories and corresponding relationship data includes: S203: Using the material code as the key field, perform a LEFT JOIN operation on the corresponding relationship data and the full material information, and use the VLOOKUP function to match the material sub-category, material medium-category and material major-category information to generate the enhanced association data table; Uploading the processing result to the first database table of the digital capability open platform includes: S204: Generate a combined field using the material code, technical specification ID, and status identifier, wherein the status identifier is used to characterize the validity of the combined field; S205: Using the combined field as the primary key, upload the enhanced related data table to the first database table in the form of data insertion or update.

[0039] For example, firstly, the system performs data association processing to generate an enhanced association data table. Then, using a locally running Python script or Power Query tool, it reads the "Material and Technical Specification ID Correspondence Table" exported by RPA. The association processing is performed as follows: First, data from multiple tabs such as "Primary Equipment and Secondary Equipment" and "Equipment Materials" in the power grid company's material master database are merged to generate a complete "Full Material Information Table." Second, using "Material Code" as the unique key field, a left join (LEFT JOIN) database operation is performed between the "Correspondence Table" and the "Full Material Information Table." In an optional embodiment, the VLOOKUP function can also be used in spreadsheet software to match and obtain the "Material Category Code," "Material Category Name," "Material Sub-Category Code," "Material Sub-Category Name," "Material Minor Category Code," and "Material Minor Category Name" corresponding to each "Material Code," and this information is then filled into a new column of the "Correspondence Table." At this point, the table is processed into the aforementioned enhanced association data table.

[0040] Specifically, when applying the VLOOKUP function, the process involves using a related data table as the main table and performing a left join (LEFT JOIN) with the full material information table via material codes. Simultaneously, six columns (material category information) are pre-inserted into the related data table and named "Material Category Code, Material Category Name, Material Sub-Category Code, Material Sub-Category Name, Material Minor Category Code, and Material Minor Category Name." During data retrieval, to ensure the VLOOKUP function accurately identifies the first column, this embodiment proposes using material codes starting with 5 or 3 and having a 9-digit length to locate the first column of the main table. Then, a horizontal lookup matching function is used, with the material code as the key value, to map the material category information using equi-joins. This matches "Material Category Code, Material Category Name, Material Sub-Category Code, Material Sub-Category Name, Material Minor Category Code, and Material Minor Category Name" one by one and fills the material category information.

[0041] Next, the system uploads the enhanced relational data table. Specifically, this is done by calling the API interface provided by the digital capability open platform, logging into the platform, and uploading the generated enhanced relational data table to the first database table specified by the platform. In an optional embodiment, this first database is JX_WZJSGFS_MATERIAL_RELATION. During the upload, the combined field of "material code + technical specification ID + status" can be used as the primary key to perform database insert or update operations, ensuring the uniqueness and up-to-dateness of the data.

[0042] Finally, a material classification tree view is generated. Specifically, this involves dynamically generating a material classification tree view based on the material classification information in the first database table. The hierarchical structure of this tree view includes: the root node is "All Materials," its child nodes are material major categories, each material major category contains several material subcategories, and each material subcategory contains several material minor categories. This view is mapped to the front-end query interface through the IoT management platform, providing users with graphical query conditions. In other words, by obtaining the material classification information from the enhanced relational data table, duplicates are first removed using the "All" field as the unique key value to obtain the material classification information view. The display interface of this view generates a material classification tree view with the material major category name as the first level, the material subcategory name as the second level, and the material minor category name as the third level.

[0043] At the same time, such as Figure 3 As shown, the system also needs to securely store various technical specifications. The step of encrypting and storing the technical specifications on a file server includes: S401: Perform hash calculation on the technical specification to generate a check code; S402: Combine the verification code and store the technical specification in the file server of the digital capability open platform.

[0044] For example, the "Technical Specification.zip" compressed file downloaded by the RPA robot is processed, including performing an MD5 hash calculation on the file to generate a unique corresponding checksum (MD5 value). The compressed file itself is then uploaded to the file server of the digital capability open platform for storage. Simultaneously, the file's metadata, such as material code, technical specification ID, original filename, and its corresponding MD5 checksum, is stored in the platform's second database table. In an optional embodiment, the second database table is the database table in JX_WZJSGFS_TECHNOLOGY_FILE, and the calculated checksum is used for file integrity verification during subsequent downloads.

[0045] In one embodiment, the response to a user-initiated query request for a technical specification document, returning a list of documents that satisfy the query request based on the first database table, includes: S501: In response to a user's query request for a technical specification, the query request is sent asynchronously via AJAX, causing the digital capability open platform to respond to the query request and match candidate file information in the first database table based on the query request, with each candidate file information corresponding to a technical specification. S502: Generate a file list in JSON format based on the candidate file information; S503: Output the list of files.

[0046] The method further includes: S504: Based on the input information, generate the query request by combining one or more of the nodes, material codes, and technical specification IDs of the material classification tree view.

[0047] For example, in this embodiment, the above steps are geared towards end users, such as bidding and review experts, providing them with fast and reliable query and download services. For instance, the system first performs unified identity authentication for the user. The user accesses the digital capability open platform through a browser. When attempting to access the "Materials Technical Specifications Query" module, the platform redirects the user to the unified authentication center. After the user enters their account and password, the authentication process is completed by calling a standardized interface (such as the ISC interface) that conforms to the "Unified Permission Platform Interface Specification". After successful verification, the user is authorized to access and redirected back to the query module. At this point, the system is in a state where it can respond to user query requests. In application, users can initiate queries through the following two main methods: The first method: Material category tree query. Users expand the pre-generated material category tree view on the front-end interface and click through the levels to select the desired sub-category node. The front-end will immediately send an AJAX asynchronous request to the back-end.

[0048] The second method is keyword search. Users can directly enter the material code or technical specification ID in the input box on the front end and click the search button. The front end will also initiate an asynchronous AJAX request.

[0049] After receiving these requests, the system's backend service parses the query parameters, performs a search in the first database table, and finally returns the query results to the frontend in JSON format. The frontend parses the JSON data and dynamically updates the result list, achieving page updates without page refresh.

[0050] Finally, the user selects one or more target files from the query results list and clicks the "Export Technical Specification" button to trigger the download operation. Specifically, the front end sends the "Technical Specification ID" and "Material Code" corresponding to the selected file to the back end. The back end first queries the corresponding MD5 checksum from the second database table based on this information. Subsequently, the back end uses this checksum to perform integrity verification, i.e., locates the corresponding ZIP compressed file on the file server.

[0051] In a preferred embodiment, the user-selected file can be retrieved via a RESTful API (such as get / file-service / {md5_code}). The backend returns the file stream to the frontend browser in a streaming manner, triggering a download dialog box in the browser. After the user saves the file, they can compare the MD5 value of the local file with the MD5 value stored on the platform to confirm that the file was not damaged during transmission, thereby ensuring the integrity and reliability of the file.

[0052] Based on the solutions disclosed in the above embodiments, it can be seen that the method and apparatus for querying and downloading power grid enterprise technical specifications in this application have the following beneficial effects: 1. By using RPA robots, a series of repetitive manual operations such as logging into the system, querying, paginating, and exporting files have been completely replaced, achieving 24 / 7 automated data collection. This frees up managers from tedious transactional tasks, allowing them to focus on the higher-value tender document review business itself, thus improving work efficiency. 2. By using the digital capability open platform as a unified information portal, the processed structured data is made available to a wider range of authorized users. Administrators can quickly query, browse and download the required technical specifications through this platform without needing an ECP2.0 account. 3. Managers can quickly obtain technical specifications through the procurement plan list, improving the efficiency and effectiveness of bid review.

[0053] like Figure 4 As shown, another embodiment of the present invention also provides a device for querying and downloading technical specifications of power grid enterprises, including: The login module is used to log in to the power grid enterprise system, automatically input preset query range parameters to trigger the query, export multiple technical specifications, and the corresponding relationship data of each technical specification. The corresponding relationship data is the correspondence data between material codes and technical specification IDs. The processing module is used to match the corresponding relationship data with the full material information in the power grid enterprise's material master database to obtain a processing result containing the corresponding relationship data and the matched material categories. The transmission module is used to upload the processing result to the first database table of the digital capability open platform; The storage module is used to encrypt and store the technical specification on a file server, and to store the file information of the technical specification in a second database table of the digital capability open platform. The file information includes material code and technical specification ID. The query module is used to respond to a user's query request for technical specifications and return a list of files that meet the query request based on the first database table. The download module is used to download the target technical specification from the file server using the second database table, based on the selection information of the target technical specification entered by the user in conjunction with the file list.

[0054] In one embodiment, logging into the power grid enterprise system and automatically inputting preset query range parameters to trigger a query includes: Control the RPA robot to log in to the power grid enterprise system, and locate the interface elements of the power grid enterprise system through image recognition or DOM parsing; The query is triggered based on the location of the interface element and the preset query range parameters.

[0055] In one embodiment, the preset query range parameter includes the publication time of the technical specification, wherein the start time of the publication time is determined based on the first day of the current month, and the end time is the current date; Export multiple technical specifications and their corresponding relationship data, including: The paginated query results are selected page by page in a loop to export multiple technical specifications and their corresponding relationship data.

[0056] In one embodiment, the step of matching the corresponding relationship data with the full material information in the power grid enterprise's material master database to obtain a processing result containing the corresponding relationship data and the matched material categories includes: The corresponding relationship data is matched with the full material information in the power grid enterprise's material master database to determine the material categories involved in the corresponding relationship data; An enhanced relational data table is generated by combining the material categories and their corresponding relationships.

[0057] In one embodiment, the device further includes: The first generation module is used to dynamically generate a material classification tree view on the digital capability open platform based on the material categories in the enhanced association data table. The material classification tree view includes a material major category layer, a material intermediate category layer, and a material minor category layer. The mapping module is used to map the material classification tree view to the front-end interface through the IoT management platform.

[0058] In one embodiment, generating an enhanced relational data table by combining the material categories and corresponding relationship data includes: Using the material code as the key field, a LEFTJOIN operation is performed on the corresponding relationship data and the full material information, and the VLOOKUP function is used to match the material sub-category, material medium-category and material major-category information to generate the enhanced relational data table; Uploading the processing result to the first database table of the digital capability open platform includes: A combined field is generated using the material code, technical specification ID, and status identifier, wherein the status identifier is used to characterize the validity of the combined field; Using the combined field as the primary key, the enhanced related data table is uploaded to the first database table in the form of data insertion or update.

[0059] In one embodiment, encrypting and storing the technical specification in a file server includes: Perform a hash calculation on the aforementioned technical specifications to generate a checksum; Based on the verification code, the technical specification is stored in the file server of the digital capability open platform. In one embodiment, the response to a user-initiated query request for a technical specification document, returning a list of documents that satisfy the query request based on the first database table, includes: In response to a user's query request for a technical specification, the query request is sent asynchronously via AJAX, causing the digital capability open platform to respond to the query request and match candidate file information in the first database table based on the query request, with each candidate file information corresponding to a technical specification. Generate a JSON-formatted file list based on the candidate file information; Output the list of files.

[0060] In one embodiment, the device further includes: The second generation module is used to generate the query request based on the input information, combined with one or more of the nodes, material codes, and technical specification IDs of the material classification tree view.

[0061] Another embodiment of the present invention also provides an electronic device, comprising: One or more processors; Memory, configured to store one or more programs; When the one or more programs are executed by the one or more processors, the one or more processors implement the method for querying and downloading the power grid enterprise technical specifications as described in any of the above descriptions.

[0062] Furthermore, one embodiment of the present invention also provides a storage medium storing a computer program, which, when executed by a processor, implements the method for querying and downloading technical specifications of power grid enterprises as described above. It should be understood that the various solutions in this embodiment have the corresponding technical effects in the above-described method embodiments, and will not be repeated here.

[0063] Furthermore, embodiments of the present invention also provide a computer program product, which is tangibly stored on a computer-readable medium and includes computer-readable instructions, which, when executed, cause at least one processor to perform a method for querying and downloading technical specifications of power grid enterprises as described in the embodiments above.

[0064] It should be noted that the computer storage medium of the present invention can be a computer-readable signal medium or a computer-readable storage medium, or any combination thereof. A computer-readable medium can be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, system, or device, or any combination thereof. More specific examples of a computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer disk, a hard disk, a random access storage medium (RAM), a read-only storage medium (ROM), an erasable programmable read-only storage medium (EPROM or flash memory), an optical fiber, a portable compact disk read-only storage medium (CD-ROM), an optical storage medium, a magnetic storage medium, or any suitable combination thereof. In the present invention, a computer-readable storage medium can be any tangible medium containing or storing a program that can be used by or in conjunction with an instruction execution system, system, or device. In the present invention, a computer-readable signal medium can include a data signal propagated in baseband or as part of a carrier wave, carrying computer-readable program code. Such propagated data signals can take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. Computer-readable signal media can also be any computer-readable medium other than computer-readable storage media, which can send, propagate, or transmit a program configured for use by or in connection with an instruction execution system, system, or device. The program code contained on the computer-readable medium can be transmitted using any suitable medium, including but not limited to: wireless, antenna, optical fiber, RF, etc., or any suitable combination thereof.

[0065] Furthermore, those skilled in the art will understand that embodiments of the present invention can be provided as methods, systems, or computer program products. Therefore, the present invention can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Moreover, the present invention can take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage and optical storage) containing computer-usable program code.

[0066] This invention is described with reference to flowchart illustrations and / or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, generate instructions for implementing the flowchart illustrations and / or block diagrams. Figure 1One or more processes and / or boxes Figure 1 A system that specifies functions in one or more boxes.

[0067] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including an instruction set implemented in a process. Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.

[0068] Those skilled in the art should understand that the discussion of any of the above embodiments is merely exemplary and is not intended to imply that the scope of protection of this application is limited to these examples; within the framework of this application, the technical features of the above embodiments or different embodiments can also be combined, the steps can be implemented in any order, and there are many other variations of different aspects of one or more embodiments of this application as described above, which are not provided in detail for the sake of brevity.

Claims

1. A method for querying and downloading technical specifications of power grid enterprises, characterized in that, include: Log in to the power grid enterprise system, automatically input the preset query range parameters to trigger the query, export multiple technical specifications, and the corresponding relationship data of each technical specification, wherein the corresponding relationship data is the correspondence data between material code and technical specification ID; The corresponding relationship data is matched with the full material information in the power grid enterprise's material master database to obtain a processing result that includes the corresponding relationship data and the matched material categories. The processing result is uploaded to the first database table of the digital capability open platform; The technical specification is encrypted and stored on a file server, and the file information of the technical specification is stored in the second database table of the digital capability open platform. The file information includes material code and technical specification ID. In response to a user's query request for technical specifications, a list of files that satisfy the query request is returned based on the first database table; Based on the user's selection information of the target technical specification entered in conjunction with the file list, the target technical specification is downloaded from the file server using the second database table.

2. The method for querying and downloading technical specifications of power grid enterprises according to claim 1, characterized in that, Log in to the power grid enterprise system and automatically input the preset query range parameters to trigger the query, including: Control the RPA robot to log in to the power grid enterprise system, and locate the interface elements of the power grid enterprise system through image recognition or DOM parsing; The query is triggered based on the location of the interface element and the preset query range parameters.

3. The method for querying and downloading technical specifications for power grid enterprises according to claim 2, characterized in that, The preset query range parameters include the publication time of the technical specification, wherein the start time of the publication time is determined based on the first day of the current month, and the end time is the current date; Export multiple technical specifications and their corresponding relationship data, including: The paginated query results are selected page by page in a loop to export multiple technical specifications and their corresponding relationship data.

4. The method for querying and downloading technical specifications for power grid enterprises according to claim 1, characterized in that, The process of matching the corresponding relationship data with the full material information in the power grid enterprise's material master database to obtain a processing result containing the corresponding relationship data and the matched material categories includes: The corresponding relationship data is matched with the full material information in the power grid enterprise's material master database to determine the material categories involved in the corresponding relationship data; An enhanced relational data table is generated by combining the material categories and their corresponding relationships.

5. The method for querying and downloading technical specifications for power grid enterprises according to claim 4, characterized in that, The method further includes: Based on the material categories in the enhanced relational data table, a material classification tree view is dynamically generated on the digital capability open platform. The material classification tree view includes a material major category layer, a material intermediate category layer, and a material minor category layer. The material classification tree view is mapped to the front-end interface through the IoT management platform.

6. The method for querying and downloading technical specifications for power grid enterprises according to claim 4, characterized in that, The process of generating an enhanced relational data table by combining the material categories and corresponding relationship data includes: Using the material code as the key field, a LEFT JOIN operation is performed on the corresponding relationship data and the full material information, and the VLOOKUP function is used to match the material sub-category, material medium-category and material major-category information to generate the enhanced relational data table; Uploading the processing result to the first database table of the digital capability open platform includes: A combined field is generated using the material code, technical specification ID, and status identifier, wherein the status identifier is used to characterize the validity of the combined field; Using the combined field as the primary key, the enhanced related data table is uploaded to the first database table in the form of data insertion or update.

7. The method for querying and downloading technical specifications for power grid enterprises according to claim 1, characterized in that, The step of encrypting and storing the technical specification in a file server includes: Perform a hash calculation on the aforementioned technical specifications to generate a checksum; Based on the verification code, the technical specification is stored in the file server of the digital capability open platform.

8. The method for querying and downloading technical specifications of power grid enterprises according to claim 1, characterized in that, In response to a user's query request for technical specifications, the system returns a list of documents that satisfy the query request based on the first database table, including: In response to a user's query request for a technical specification, the query request is sent asynchronously via AJAX, causing the digital capability open platform to respond to the query request and match candidate file information in the first database table based on the query request, with each candidate file information corresponding to a technical specification. Generate a JSON-formatted file list based on the candidate file information; Output the list of files.

9. The method for querying and downloading technical specifications for power grid enterprises according to claim 5, characterized in that, The method further includes: Based on the input information, the query request is generated by combining one or more of the nodes, material codes, and technical specification IDs of the material classification tree view.

10. A device for querying and downloading technical specifications for power grid enterprises, characterized in that, include: The login module is used to log in to the power grid enterprise system, automatically input preset query range parameters to trigger the query, export multiple technical specifications, and the corresponding relationship data of each technical specification. The corresponding relationship data is the correspondence data between material codes and technical specification IDs. The processing module is used to match the corresponding relationship data with the full material information in the power grid enterprise's material master database to obtain a processing result containing the corresponding relationship data and the matched material categories. The transmission module is used to upload the processing result to the first database table of the digital capability open platform; The storage module is used to encrypt and store the technical specification on a file server, and to store the file information of the technical specification in a second database table of the digital capability open platform. The file information includes material code and technical specification ID. The query module is used to respond to a user's query request for technical specifications and return a list of files that meet the query request based on the first database table. The download module is used to download the target technical specification from the file server using the second database table, based on the selection information of the target technical specification entered by the user in conjunction with the file list.

Images