阅读说明：本技术 电网设备状态评价报告生成的方法与系统 (Method and system for generating state evaluation report of power grid equipment ) 是由 张伟平 谢建容 廖肇毅 薛峰 张新忠 黄伟光 王花蕊 刘丽荣 李通 刘成浩 邓琨 于 2019-06-19 设计创作，主要内容包括：本发明公开了一种电网设备状态评价报告生成的方法与系统,方法包括：服务端将输入的数据源与预先建立的数据模型进行模型映射以得到具体的模型数据；客户端启动文档模板并加载VSTO插件,在插件提供的界面上创建、删除或编辑模板,对模板中的元素进行编辑,所述元素包括静态元素和与数据模型对应的模型元素；将模板中的模型元素翻译成对应的数据模型；根据翻译好的数据模型从服务端获取对应的模型数据；将文档中的各个元素的模型数据进行渲染；保存或导出所述模板以生成所述状态评价报告,如此,本发明可有效提高电网设备状态评价报告的编制效率和准确性,避免人为错误编制。(The invention discloses a method and a system for generating a state evaluation report of power grid equipment, wherein the method comprises the following steps: the server side carries out model mapping on the input data source and a pre-established data model to obtain specific model data; the method comprises the steps that a client starts a document template and loads a VSTO plug-in, the template is created, deleted or edited on an interface provided by the plug-in, and elements in the template are edited, wherein the elements comprise static elements and model elements corresponding to a data model; translating the model elements in the template into corresponding data models; acquiring corresponding model data from the server according to the translated data model; rendering the model data of each element in the document; the template is saved or exported to generate the state evaluation report, so that the method and the device can effectively improve the compiling efficiency and accuracy of the state evaluation report of the power grid equipment and avoid artificial wrong compiling.)

1. A method for generating a power grid equipment state evaluation report is characterized by comprising the following steps:

the server side carries out model mapping on the input data source and a pre-established data model to obtain specific model data;

the method comprises the steps that a client starts a document template and loads a VSTO plug-in, the template is created, deleted or edited on an interface provided by the plug-in, and elements in the template are edited, wherein the elements comprise static elements and model elements corresponding to a data model;

translating the model elements in the template into corresponding data models;

acquiring corresponding model data from the server according to the translated data model;

rendering the model data of each element in the document;

saving or exporting the template to generate the status assessment report.

2. The method of claim 1, wherein the pre-established data model comprises a base data model and a content data model, and wherein the model data comprises: basic data obtained by mapping the basic data model, and content data obtained by mapping the content data model.

3. The method of claim 2, wherein the basic data model comprises year of evaluation, date of evaluation, grid company, report name, type of evaluation device; the content data model comprises a report purpose description model, a report evaluation overview model, a report statistic model and a report control model.

4. The method of claim 2, wherein the model elements comprise:

a basic object element whose attribute corresponds to the basic data model;

and the content object element corresponds to the content data model in attribute.

5. The method of claim 4, wherein editing the elements in the template comprises: editing and modifying the specific information of the static elements; and setting rendering attributes of the basic object element and the content object element.

6. The method of claim 4, wherein translating model elements in the template into corresponding data models: static elements are not translated, basic object elements are translated into basic data models, and content object elements are translated into content data models.

7. The method according to claim 6, wherein the obtaining corresponding model data from the server according to the translated data model comprises: calling basic data service of the server to acquire basic data of the server aiming at the translated basic data model; and calling the content data service of the server to acquire the content data of the server aiming at the translated content data model.

8. The method of claim 1, wherein rendering model data for each element in the document comprises:

static elements are not changed when rendered;

and when the basic object elements and the content object elements are rendered, rendering and displaying the corresponding basic data and content data into the template according to the rendering attributes of the elements.

9. A system for generating a state evaluation report of power grid equipment is characterized by comprising a server and a client;

the server side comprises: the data model generation device comprises a modeling module for pre-establishing a data model and a model mapping module for performing model mapping on an input data source and the pre-established data model to obtain specific model data;

the client comprises:

the template editing module is used for starting a document template, loading a VSTO plug-in, creating, deleting or editing the template on an interface provided by the plug-in, and editing elements in the template, wherein the elements comprise static elements and model elements corresponding to the data model;

the element translation module is used for translating the model elements in the template into corresponding data models;

the data acquisition module is used for acquiring corresponding model data from the server side according to the translated data model;

the rendering module is used for rendering the model data of each element in the document;

a generating module for saving or exporting the template to generate the state evaluation report.

10. A system for generating a power grid equipment state evaluation report based on the method of claim 1 is characterized by comprising the server and the client.

Technical Field

The invention relates to the field of power grids, in particular to a method and a system for generating a state evaluation report of power grid equipment.

Background

The state evaluation of the power grid equipment can be divided into the following stages, and state evaluation planning is compiled; performing state evaluation and obtaining a result; and compiling a state evaluation report. At the stage of generating the report, report compiling personnel need to perform summary processing according to a large number of equipment state evaluation results and compile the report into a Word report form. The existing method carries out manual compilation and matching aiming at the result of equipment state evaluation, which consumes manpower, has complex data and is easy to make mistakes, and the report compilation is complex, long in time consumption and low in efficiency.

Disclosure of Invention

The technical problem to be solved by the present invention is to provide a method and a system for generating a power grid device status evaluation report, aiming at the above-mentioned defects in the prior art.

The technical scheme adopted by the invention for solving the technical problems is as follows: a method for generating a power grid equipment state evaluation report is constructed, and the method comprises the following steps:

the server side carries out model mapping on the input data source and a pre-established data model to obtain specific model data;

the method comprises the steps that a client starts a document template and loads a VSTO plug-in, the template is created, deleted or edited on an interface provided by the plug-in, and elements in the template are edited, wherein the elements comprise static elements and model elements corresponding to a data model;

translating the model elements in the template into corresponding data models;

acquiring corresponding model data from the server according to the translated data model;

rendering the model data of each element in the document;

saving or exporting the template to generate the status assessment report.

Preferably, the pre-established data model comprises a basic data model and a content data model, and the model data comprises: basic data obtained by mapping the basic data model, and content data obtained by mapping the content data model.

Preferably, the basic data model comprises evaluation year, evaluation date, power grid company, report name and evaluation equipment type; the content data model comprises a report purpose description model, a report evaluation overview model, a report statistic model and a report control model.

Preferably, the model elements include:

a basic object element whose attribute corresponds to the basic data model;

and the content object element corresponds to the content data model in attribute.

Preferably, the editing the elements in the template includes: editing and modifying the specific information of the static elements; and setting rendering attributes of the basic object element and the content object element.

Preferably, the model elements in the template are translated into corresponding data models: static elements are not translated, basic object elements are translated into basic data models, and content object elements are translated into content data models.

Preferably, the obtaining of the corresponding model data from the server according to the translated data model includes: calling basic data service of the server to acquire basic data of the server aiming at the translated basic data model; and calling the content data service of the server to acquire the content data of the server aiming at the translated content data model.

Preferably, the rendering the model data of each element in the document includes:

static elements are not changed when rendered;

and when the basic object elements and the content object elements are rendered, rendering and displaying the corresponding basic data and content data into the template according to the rendering attributes of the elements.

The invention also claims a system for generating the power grid equipment state evaluation report, which comprises a server and a client;

the server side comprises: the data model generation device comprises a modeling module for pre-establishing a data model and a model mapping module for performing model mapping on an input data source and the pre-established data model to obtain specific model data;

the client comprises:

the template editing module is used for starting a document template, loading a VSTO plug-in, creating, deleting or editing the template on an interface provided by the plug-in, and editing elements in the template, wherein the elements comprise static elements and model elements corresponding to the data model;

the element translation module is used for translating the model elements in the template into corresponding data models;

the data acquisition module is used for acquiring corresponding model data from the server side according to the translated data model;

the rendering module is used for rendering the model data of each element in the document;

a generating module for saving or exporting the template to generate the state evaluation report.

The invention also claims a system for generating the power grid equipment state evaluation report based on the method, wherein the system comprises the server and the client.

The method and the system for generating the power grid equipment state evaluation report have the following beneficial effects: according to the method, the server side carries out model mapping on an input data source and a pre-established data model to obtain specific model data, when a client side needs to make a report, only a document template needs to be started, a VSTO plug-in is loaded after the document module is started, the template is created, deleted or edited on an interface provided by the plug-in, elements in the template are edited, translated, obtained and rendered, and finally the template is stored or exported to generate the report.

Drawings

In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the provided drawings without creative efforts:

FIG. 1 is a flow chart of a method of grid device status evaluation report generation of the present invention;

FIG. 2 is a comparison graph of two graphs after data rendering for evaluating a statistical model;

fig. 3 is a system for generating a power grid equipment state evaluation report according to the present invention.

Detailed Description

To facilitate an understanding of the invention, the invention will now be described more fully with reference to the accompanying drawings. Exemplary embodiments of the invention are shown in the drawings. This invention may, however, be embodied in many different forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete. It should be understood that the embodiments and specific features in the embodiments of the present invention are described in detail in the present application, but not limited to the present application, and the features in the embodiments and specific features in the embodiments of the present invention may be combined with each other without conflict.

It will be understood that when an element is referred to as being "secured to" another element, it can be directly on the other element or intervening elements may also be present. When an element is referred to as being "connected" to another element, it can be directly connected to the other element or intervening elements may also be present. The terms "vertical," "horizontal," "left," "right," and the like as used herein are for illustrative purposes only.

Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. The terminology used in the description of the invention herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention.

Referring to fig. 1, the present embodiment provides a method for generating a power grid device status evaluation report, where the method includes:

s101, the server side carries out model mapping on the input data source and a pre-established data model to obtain specific model data.

The pre-established data model comprises a basic data model and a content data model. Accordingly, the model data includes: basic data obtained by mapping the basic data model, and content data obtained by mapping the content data model.

Specifically, the basic data model includes key information required for generating a report, for example: year of evaluation, date of evaluation, grid company, report name, type of equipment evaluated, etc.

Specifically, the content data model comprises a report purpose description model, a report evaluation overview model, a report statistics model and a report management and control model, and covers all contents required by the state evaluation report of the power grid equipment, wherein:

report purpose description model: the method mainly comprises the steps of object description, reference standard, equipment class number, evaluation type, grammar rule, rendering support type and the like.

Report summary model: the method mainly comprises the steps of evaluating time range, evaluating year, evaluating voltage grade, evaluating substation number and the like.

The report statistical model is as follows: the method mainly comprises the steps of equipment type, evaluation unit, evaluation quantity, normal state ratio, attention state quantity ratio, abnormal state quantity, abnormal state ratio, serious state quantity, serious state ratio and the like.

A report management and control model: the method mainly comprises the steps of equipment type, equipment state, state number, deduction items, management and control measures and the like.

In this embodiment, the source data mainly includes device basic information, device status evaluation criteria, and detailed information of a device status evaluation result. During mapping, after data in the input data source is extracted, a specific basic data model and a specific content data model are instantiated, and corresponding basic data and content data can be obtained. For example, during mapping, A, B, C types of data are required in the model, and the three types of data are respectively stored in three predetermined positions in the data source only by extracting the data at the three predetermined positions and storing the data according to the model format.

After the model mapping is finished, the server side can provide a data acquisition way to the outside in a service mode. For example, the basic data service of the server is used to achieve the acquisition of basic data, and the content data service is used to achieve the acquisition of content data.

S102, a client starts a document template and loads a VSTO plug-in, creates, deletes or edits the template on an interface provided by the plug-in, and edits elements in the template;

wherein the elements include:

static elements, which are mainly fixed information in the report that is not data-dependent.

Model elements, which correspond to data models, mainly include the following two broad categories: a basic object element whose attribute corresponds to the basic data model; and the content object element corresponds to the content data model in attribute. In general, each particular model has attributes corresponding to a particular data model.

Wherein, editing the elements in the template comprises: editing and modifying the specific information of the static elements; and setting rendering attributes of the basic object element and the content object element.

S103, translating the model elements in the template into corresponding data models.

Specifically, the static elements are not translated, the base object elements are translated to the base data model, and the content object elements are translated to the content data model.

And S104, acquiring corresponding model data from the server according to the translated data model.

Specifically, aiming at the translated basic data model, calling the basic data service of the server to acquire the basic data of the server; and calling the content data service of the server to acquire the content data of the server aiming at the translated content data model.

And S105, rendering the model data of each element in the document. In particular, static elements are not changed when rendered. And when the basic object elements and the content object elements are rendered, rendering and displaying the corresponding basic data and content data into the template according to the rendering attributes of the elements.

Preferably, different types of data of the content model support different report rendering modes. The user can edit the content elements and flexibly and custom display the report content. The details are as follows:

1) the report purpose description model can be converted into a text block, and the example of the converted text block is as follows:

for (XXX purpose), the status of (XXX company) on the transport (XXX class XXX equipment) was evaluated according to (XXX standard), and the report was compiled.

In addition, it should be noted that the brackets are only used for showing and distinguishing the static elements from the elements being rendered, and are not actual contents, and the following examples are the same.

2) The report summary model can be converted into a table, a text block, a histogram and a pie chart:

the equipment state evaluation time is (XXX time) annual evaluation, (17 of 500kV transformer substations and 125 of 220kV transformer substations are evaluated in total, … …

3) The statistical model is evaluated and can be converted into a table, a text block, a graphic rendering, etc., referring to table 1 below, a text block, and fig. 2.

TABLE 1 XX-year XXX Equipment State evaluation details Table

Of the devices evaluated this time, (XXX status totals 300, of which XXX device 126 is 9.20%, XXX device 68 is 4.96%, electric XXX device 15 is 1.09%; … …) is shown in FIG. 2.

4) And evaluating the data of the management and control model, and converting the data into tables and text blocks as follows:

(Note the state 47), mainly expressed as (apparent dirt accumulation on the outer surface of the porcelain sleeve, XXXXX) and the like. Specific management and control measures (XXXXX).

S106, saving or exporting the template to generate the state evaluation report.

Referring to fig. 3, based on the same inventive concept, the present invention further constructs a system for generating a status evaluation report of a power grid device, where the system includes a server and a client;

the server side comprises: a modeling module 201, a model mapping module 202, and a data service 203.

The modeling module 201 is used for establishing a data model in advance. The pre-established data model includes a base data model and a content data model. Accordingly, the model data includes: basic data obtained by mapping the basic data model, and content data obtained by mapping the content data model.

Specifically, the basic data model includes key information required for generating a report, for example: year of evaluation, date of evaluation, grid company, report name, type of equipment evaluated, etc.

Specifically, the content data model comprises a report purpose description model, a report evaluation overview model, a report statistics model and a report management and control model, and covers all contents required by the state evaluation report of the power grid equipment, wherein:

report purpose description model: the method mainly comprises the steps of object description, reference standard, equipment class number, evaluation type, grammar rule, rendering support type and the like.

Report summary model: the method mainly comprises the steps of evaluating time range, evaluating year, evaluating voltage grade, evaluating substation number and the like.

The report statistical model is as follows: the method mainly comprises the steps of equipment type, evaluation unit, evaluation quantity, normal state ratio, attention state quantity ratio, abnormal state quantity, abnormal state ratio, serious state quantity, serious state ratio and the like.

The model mapping module 202 is configured to perform model mapping on the input data source and a pre-established data model to obtain specific model data.

In this embodiment, the source data mainly includes device basic information, device status evaluation criteria, and detailed information of a device status evaluation result. During mapping, after data in the input data source is extracted, a specific basic data model and a specific content data model are instantiated, and corresponding basic data and content data can be obtained. For example, during mapping, A, B, C types of data are required in the model, and the three types of data are respectively stored in three predetermined positions in the data source only by extracting the data at the three predetermined positions and storing the data according to the model format.

After the model mapping is finished, the server side can provide a data acquisition way to the outside in a service mode. For example, the data service 203 includes a basic data service for acquiring basic data and a content data service for acquiring content data.

Wherein the client comprises: a template editing module 301, an element translation module 302, a data acquisition module 303, a rendering module 304, and a generation module 305.

The template editing module 301 is configured to start a document template, load a VSTO plug-in, create, delete, or edit the template on an interface provided by the plug-in, and edit elements in the template.

Wherein the elements include:

static elements, which are mainly fixed information in the report that is not data-dependent.

Model elements, which correspond to data models, mainly include the following two broad categories: a basic object element whose attribute corresponds to the basic data model; and the content object element corresponds to the content data model in attribute. In general, each particular model has attributes corresponding to a particular data model.

Wherein, editing the elements in the template comprises: editing and modifying the specific information of the static elements; and setting rendering attributes of the basic object element and the content object element.

And the element translation module 302 is used for translating the model elements in the template into the corresponding data model. Specifically, the static elements are not translated, the base object elements are translated to the base data model, and the content object elements are translated to the content data model.

And a data obtaining module 303, configured to call the data service interface according to the translated data model to obtain corresponding model data. Specifically, aiming at the translated basic data model, calling the basic data service of the server to acquire the basic data of the server; and calling the content data service of the server to acquire the content data of the server aiming at the translated content data model.

And the rendering module 304 is used for rendering the model data of each element in the document. In particular, static elements are not changed when rendered. And when the basic object elements and the content object elements are rendered, rendering and displaying the corresponding basic data and content data into the template according to the rendering attributes of the elements.

Preferably, different types of content models support different report rendering modes. The user can edit the content elements and flexibly and custom display the report content.

A generation module 305 for saving or exporting the template to generate the status evaluation report.

The functions of the functional modules of the apparatus according to the embodiment of the present invention may be specifically implemented according to the method in the foregoing method embodiment, and the specific implementation process may refer to the description related to the foregoing method embodiment, which is not described herein again.

Based on the same inventive concept, the invention also constructs a system for realizing the generation of the state evaluation report of the power grid equipment based on the method, and the system comprises the server and the client.

It should be noted that the above description of the various modules is divided into these modules for clarity of illustration. However, in actual implementation, the boundaries of the various modules may be fuzzy. For example, any or all of the functional modules herein may share various hardware and/or software elements. Also for example, any and/or all of the functional modules herein may be implemented in whole or in part by a common processor executing software instructions. Additionally, various software sub-modules executed by one or more processors may be shared among the various software modules. Accordingly, the scope of the present invention is not limited by the mandatory boundaries between the various hardware and/or software elements, unless explicitly claimed otherwise.

In summary, the method and system for generating the power grid equipment state evaluation report of the present invention have the following beneficial effects: according to the method, the server side carries out model mapping on an input data source and a pre-established data model to obtain specific model data, when a client side needs to make a report, only a document template needs to be started, a VSTO plug-in is loaded after the document module is started, the template is created, deleted or edited on an interface provided by the plug-in, elements in the template are edited, translated, obtained and rendered, and finally the template is stored or exported to generate the report.

While the present invention has been described with reference to the embodiments shown in the drawings, the present invention is not limited to the embodiments, which are illustrative and not restrictive, and it will be apparent to those skilled in the art that various changes and modifications can be made therein without departing from the spirit and scope of the invention as defined in the appended claims.