Disclosure of Invention
The invention aims to provide a power transmission and transformation project quality data management and control method and a power transmission and transformation project quality data management and control system aiming at the problems in the prior art, which assist a construction unit to quickly acquire design information on the basis of improving the informatization management level of the project construction and strictly follow the design information to execute construction; and the on-site construction quality information can be fed back in real time, the supervision of construction quality by a construction and management unit and a supervision unit is enhanced, and the engineering standardization and high-quality construction is effectively promoted.
In order to achieve the purpose of the invention, the invention is realized by the following technical scheme:
the invention also discloses a quality data management and control method for the power transmission and transformation project, which utilizes a network server end of a B/S framework, a webpage end comprising a webpage end display unit and a webpage end input unit, a mobile end comprising a mobile end display unit and a mobile end input unit, and a data storage unit, and comprises the following steps:
step 1, importing attribute information, design parameters and engineering data information of material numbers of all projects of a converter station, a transformer substation and a line of a power transmission and transformation project in batches from a webpage end or a mobile end to a network server end, and storing the engineering data information in a data storage unit;
step 2, respectively establishing an engineering attribute table, a design information table and a material information table of each engineering according to the attribute information, the design parameters and the engineering data information of the material number of each engineering;
step 3, setting engineering project identification codes in an engineering attribute table, a design information table and a material information table of the same engineering, and establishing an incidence relation among the engineering attribute table, the design information table and the material information table about the engineering project identification codes;
and 4, associating the material inspection qualified report and the engineering construction information of each engineering according to the engineering project identification code, and respectively generating an evaluation form of an engineering attribute table, a design information table and a material information table, wherein the evaluation form further comprises at least three levels of check items approved by users, and the check items are used for the users to input the measured value and the quality evaluation value of field inspection through the webpage end input unit or the mobile end input unit.
Further, step 1 further comprises storing the engineering data information offline at the webpage end and the mobile end. Step 1 also comprises a networking detection judgment step: and when the networking operation of the PC terminal or the mobile terminal is detected, uploading off-line stored engineering data information to a network server terminal.
Further, the building of the project attribute table, the design information table and the material information table of each project in step 2 is to adopt an attribute information application layer, a design information application layer and a material information application layer of a web page end and a mobile end, so that a user can respectively call corresponding application layers to realize the classified input of data and build a collection table of corresponding data.
Further, the at least three levels of users at least comprise construction units, supervision units and construction management units.
Furthermore, the method of the invention also comprises the step of displaying the project attribute information, the design parameter information, the material number information and the evaluation form information through the webpage end display unit and the mobile end display unit.
The invention also discloses a quality data management and control system for the power transmission and transformation project, which comprises: the system comprises a network server end with a B/S framework, a PC webpage end with a webpage end display unit and a webpage end input unit, a mobile end with a mobile end display unit and a mobile end input unit, and a data storage unit, and further comprises:
the engineering data input unit is used for inputting the attribute information, the design parameters and the engineering data information of the material number of each engineering to the network server side at the PC webpage side or the mobile side and storing the engineering data information in the data storage unit;
the engineering data statistics and collection unit is used for establishing an engineering attribute table, a design information table and a material information table of each engineering according to the attribute information, the design parameters and the engineering data information of the material numbers of each engineering of the power transmission and transformation engineering converter station and the line;
the data set matching unit is used for setting the project identification codes in the project attribute table, the design information table and the material information table of the same project and establishing the incidence relation among the project attribute table, the design information table and the material information table about the project identification codes;
the system comprises a project inspection and evaluation unit, a web page end input unit and a mobile end input unit, wherein the project inspection and evaluation unit is used for associating material inspection qualified reports and project construction information of each project according to project identification codes and respectively generating an inspection and evaluation form of a project attribute table, a design information table and a material information table, the inspection and evaluation form further comprises at least three layers of check items approved by users, and the check items are used for the users to input measured values and quality evaluation values of field inspection through the web page end input unit or the mobile end input unit.
Compared with the prior art, the invention has the beneficial effects that:
(1) the quality control information sharing of the power transmission and transformation project is enhanced, and the information comprises project design information, material management, quality evaluation and the like; the butt joint and the correlation of the quality control information of each engineering construction unit are enhanced, and the depth and the transparency of engineering construction quality management are improved.
(2) The construction quality assessment site management of the power transmission and transformation project is enhanced, the information acquisition efficiency and the project quality analysis level are improved, and the standardized management of quality assessment is promoted.
(3) The quality management working mode of the power transmission and transformation project is innovated, and the convenience, the efficiency and the accuracy of the quality management work of the construction site are improved by using informatization and intelligentized means.
(4) The data management level of various construction processes such as engineering design, construction, materials and the like is improved, and the electronic management of engineering quality is powerfully promoted.
Detailed Description
The technical solutions in the embodiments of the present invention are clearly and completely described below with reference to the drawings and the embodiments, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments.
The invention relates to a quality data management and control method and a system for power transmission and transformation projects, which are used for tracking material information based on design parameters in the process of project construction, filling construction measured values and inspection conclusions into a quality test and evaluation form, and taking the construction measured values and the inspection conclusions as important evidences and achievements for project quality management. The quality data management and control method and system for the power transmission and transformation project are built in a mode that a server of a B/S framework is combined with a mobile terminal, and an application server, a data server and a management terminal are configured in a central machine room. The central machine room is communicated with the Internet through a gateway. The PC can access the server via the Internet. A user may deploy a mobile-end system with a smartphone.
Referring to fig. 1, which is a step diagram of an embodiment of the present invention, a method for managing and controlling quality data of a power transmission and transformation project is disclosed, wherein steps 1 to 4 are specifically as follows:
step 1, inputting attribute information, design parameters and engineering data information of material numbers of each project of a converter station, a transformer substation and a line of a power transmission and transformation project into a network server side at a PC webpage side or a mobile side, and storing the information in a data storage unit;
step 2, respectively establishing an engineering attribute table, a design information table and a material information table of each engineering according to the attribute information, the design parameters and the engineering data information of the material number of each engineering;
step 3, setting engineering project identification codes in an engineering attribute table, a design information table and a material information table of the same engineering, and establishing an incidence relation among the engineering attribute table, the design information table and the material information table about the engineering project identification codes;
and 4, associating the material inspection qualified report and the engineering construction information of each engineering according to the engineering project identification code, and respectively generating an evaluation form of an engineering attribute table, a design information table and a material information table, wherein the evaluation form further comprises at least three levels of check items approved by users, and the check items are used for the users to input the measured value and the quality evaluation value of field inspection through the webpage end input unit or the mobile end input unit.
The engineering attribute data of the converter station and the transformer substation mainly comprises civil engineering key quality control and electrical engineering key quality control:
the civil engineering key quality management and control comprises: the unit (sub-unit) engineering mainly comprises a main control building, an alternating current relay protection room, a distribution room, a comprehensive building, a valve hall, a firewall, a converter transformer, a square area, an alternating current filter, an alternating current power distribution device field and the like; the subdivision (sub-subdivision) engineering is mainly divided by taking the unit (sub-unit) engineering as a main project, and the division principle is determined according to professional properties and building parts; the project of the project is divided mainly aiming at the project of the subsection (sub-subsection), and the division principle is determined according to the main work types, materials, construction processes, equipment categories and the like; each project is composed of one or a plurality of inspection batches;
the electrical engineering key quality management and control comprises: the unit (sub-unit) engineering mainly comprises AC power distribution equipment, AC filter field power distribution equipment installation, main transformer system equipment installation, converter valve system equipment installation, AC filter equipment installation, station power system equipment installation, secondary equipment installation and the like; the branch (sub-branch) engineering is divided by taking the main needle as the installation part of the unit (sub-unit) engineering; the project division project is mainly divided according to the project installation content of the sub-divisions;
the line engineering key quality management and control process mainly comprises the following steps: earthwork engineering, foundation engineering, pole tower engineering, stringing engineering, grounding engineering, protection engineering and the like. The earthwork project comprises path retest, common foundation pit division and excavation, rock, foundation pit division and excavation, construction base surface and electrical excavation; the foundation engineering comprises cast-in-place, digging iron tower foundations, rock iron tower foundations, cast-in-place pile foundations and digging pile foundations; the tower project comprises a self-supporting iron tower assembly; the stringing project comprises the steps of unfolding a ground wire (including OPGW), connecting the ground wire, tightening the ground wire (including the OPGW) and installing accessories (including the OPGW); the grounding project comprises a deep-buried grounding device and a surface grounding device; the protection project comprises a line protection facility.
The design parameter data, which takes line engineering as an example, includes basic design information, line iron tower basic root opening parameters, grounding type design information, stringing design information, jumper sag design information, cross-domain design information, channel cleaning design information, and protection facility design information.
The material numbering data is exemplified by material numbering data of line engineering, and comprises basic material information, grounding material information, iron tower material information and overhead line material information.
The quality data management and control system for the power transmission and transformation project, provided by the embodiment of the invention, manages and controls the data of each project, wherein the project data information of each project of a converter station, a transformer substation and a line of the power transmission and transformation project is input into a network server end at a webpage end or a mobile end, the project data of each project is divided into attribute information, design parameters and material numbers, and an attribute information application layer, a design information application layer and a material information application layer are respectively arranged at the webpage end and the mobile end, so that a user can respectively call the corresponding application layers to realize the classified input of the data and establish a collection table of the corresponding data.
The quality data management and control method for the power transmission and transformation project aims at managing and controlling data of all projects, engineering data information 31 of all projects of a converter station, a transformer substation and a line of the power transmission and transformation project is input into a network server end 23 at a webpage end or a mobile end, the engineering data of all projects are divided into attribute information, design parameters and material numbers, and in step 1, an engineering attribute management module, a design parameter management module and a material number management module which are shown in fig. 4 are called at application layers on a webpage end 21 and a mobile end 22 for users to input in a classified mode and establish a collection table of corresponding data.
The tower engineering of the line engineering is taken as an example for explanation as follows:
in the line engineering, inputting tower information into an engineering attribute management module, and establishing a tower attribute table, wherein the tower attribute table comprises tower type information of towers; a tower parameter attribute table is input into a design parameter management module, and an engineering project identification code of tower type information of a tower is set in the tower parameter attribute table, so that the association between the tower parameter attribute table and the tower attribute table is realized; the material numbering management module is used for inputting a material information table required by each tower type, an engineering project identification code of tower type information is arranged in the material information table, therefore, the material information table is associated with the tower attribute table and the tower parameter attribute table, in addition, the material information table can automatically associate information such as inspection qualified reports of materials and the like, thus, the incidence relation between the tower and the material is established, the factory information of the tower and whether the material is qualified or not are checked, the incidence relation between the attribute information table, the design information table and the material information table of the project is finally established, referring to the project data A, the project data B to the project data N in figure 2, the data tables of different types are associated in the corresponding project, the evaluation form 32 automatically obtains the engineering data values of the engineering information, the design parameters and the material numbers, and managers of construction, supervision and owners can quickly compare and analyze whether the construction quality on site can meet the standard requirements or not by checking the measured values on site.
As another embodiment, step 1 further includes storing the engineering data information offline at the web page side and the mobile side. Step 1 also comprises a networking detection judgment step: when the web page terminal, such as a browser on a PC or the networking operation of a mobile terminal, is detected, off-line stored engineering data information is uploaded to a network server terminal. Combining the regional network characteristics of the transmission line project, the mobile terminal supports online and offline application, and under the offline condition, data filled by the mobile terminal is temporarily stored in a mobile phone; when a Wi-Fi/3G/4G network exists, automatic synchronization of data with a server is achieved.
As a specific embodiment, at least three levels of approved users are arranged on the evaluation form, the approved users at least comprise a construction unit, a supervision unit and a construction management unit, and the approval process is as follows: the construction unit fills in the assessment form and submits approval → manages and rechecks the construction quality information → the owner reviews the construction quality.
As another embodiment, the method further includes displaying the engineering attribute information, the design parameter information, the material number information and the evaluation form information through the webpage end display unit and the mobile end display unit.
Referring to fig. 3 to 5, which are a block diagram and a hierarchical structure diagram of a power transmission and transformation project quality data management and control system according to the present invention, referring to fig. 3, the system of the present invention includes: the B/S architecture includes a web server 23, a web 21 having a web display unit (not shown) and a web input unit (not shown), a mobile 22 having a mobile display unit (not shown) and a mobile input unit (not shown), and a data storage unit (not shown), and further includes:
the engineering data input unit 11 is used for inputting the attribute information, the design parameters and the engineering data information of the material number of each engineering into the network server 23 at the webpage end 21 or the mobile end 22 and storing the engineering data information in the data storage unit of the network server 23;
the engineering data statistics and collection unit 12 is used for establishing an engineering attribute table 311, a design information table 312 and a material information table of each project according to the attribute information, the design parameters and the engineering data 31 of the material numbers of each project of the power transmission and transformation engineering converter station and the line;
the data set matching unit 13 is used for setting the project identification codes in the project attribute table 311, the design information table 312 and the material information table 313 of the same project and establishing the incidence relation among the project attribute table 311, the design information table 312 and the material information table 313 related to the project identification codes;
the engineering examination and evaluation unit 14 is configured to associate the material examination qualification report and the engineering construction information of each engineering according to the engineering project identification code, and generate an examination and evaluation form 32 of an engineering attribute table 311, a design information table 312, and a material information table 313, respectively, where the examination and evaluation form 32 further includes at least three levels of check items approved by the user, and the check items are used for the user to enter an actual measurement value and a quality evaluation value of a field examination through the web page side input unit or the mobile side input unit. As a specific embodiment, at least three levels of approved users are arranged on the evaluation form, the approved users at least comprise a construction unit, a supervision unit and a construction management unit, and the approval process is as follows: the construction unit fills in the assessment form and submits approval → manages and rechecks the construction quality information → the owner reviews the construction quality.
The engineering attribute data of the converter station and the transformer substation mainly comprises civil engineering key quality control and electrical engineering key quality control:
the civil engineering key quality management and control comprises: the unit (sub-unit) engineering mainly comprises a main control building, an alternating current relay protection room, a distribution room, a comprehensive building, a valve hall, a firewall, a converter transformer, a square area, an alternating current filter, an alternating current power distribution device field and the like; the subdivision (sub-subdivision) engineering is mainly divided by taking the unit (sub-unit) engineering as a main project, and the division principle is determined according to professional properties and building parts; the project of the project is divided mainly aiming at the project of the subsection (sub-subsection), and the division principle is determined according to the main work types, materials, construction processes, equipment categories and the like; each project is composed of one or a plurality of inspection batches;
the electrical engineering key quality management and control comprises: the unit (sub-unit) engineering mainly comprises AC power distribution equipment, AC filter field power distribution equipment installation, main transformer system equipment installation, converter valve system equipment installation, AC filter equipment installation, station power system equipment installation, secondary equipment installation and the like; the branch (sub-branch) engineering is divided by taking the main needle as the installation part of the unit (sub-unit) engineering; the project division project is mainly divided according to the project installation content of the sub-divisions;
the line engineering key quality management and control process mainly comprises the following steps: earthwork engineering, foundation engineering, pole tower engineering, stringing engineering, grounding engineering, protection engineering and the like. The earthwork project comprises path retest, common foundation pit division and excavation, rock, foundation pit division and excavation, construction base surface and electrical excavation; the foundation engineering comprises cast-in-place, digging iron tower foundations, rock iron tower foundations, cast-in-place pile foundations and digging pile foundations; the tower project comprises a self-supporting iron tower assembly; the stringing project comprises the steps of unfolding a ground wire (including OPGW), connecting the ground wire, tightening the ground wire (including the OPGW) and installing accessories (including the OPGW); the grounding project comprises a deep-buried grounding device and a surface grounding device; the protection project comprises a line protection facility.
The design information data, taking line engineering as an example, includes basic design information, line iron tower foundation root opening parameters, grounding type design information, stringing design information, jumper sag design information, cross-domain design information, channel cleaning design information, and protection facility design information.
The material numbering data is exemplified by material numbering data of line engineering, and comprises basic material information, grounding material information, iron tower material information and overhead line material information.
The quality data management and control system for the power transmission and transformation project, provided by the embodiment of the invention, manages and controls data of each project, wherein project data information 31 of each project of a converter station, a transformer substation and a line of the power transmission and transformation project is input into a network server end 23 at a webpage end or a mobile end, the project data of each project is divided into attribute information, design parameters and material numbers, referring to fig. 4, a project input unit 11 is positioned at an application layer on the webpage end 21 and the mobile end 22, and the project input unit 11 comprises a project attribute management module, a design parameter management module and a material number management module, so that a user can respectively call the corresponding management modules to realize classified input of the data and establish a collection table of the corresponding data.
The tower engineering of the line engineering is taken as an example for explanation as follows:
in the line engineering, inputting tower information into an engineering attribute management module, and establishing a tower attribute table, wherein the tower attribute table comprises selected tower type information; various tower type parameter attribute tables are recorded in a design parameter management module, and engineering project identification codes of tower type information are set in the tower type parameter attribute tables to realize the association between the tower type parameter attribute tables and the tower attribute tables; the material numbering management module is used for inputting a material information table required by each tower type, an engineering project identification code of tower type information is arranged in the material information table, therefore, the material information table is associated with the tower attribute table and the tower parameter attribute table, in addition, the material information table can automatically associate information such as inspection qualified reports of materials and the like, thus, the incidence relation between the tower and the material is established, the factory information of the tower and whether the material is qualified or not are checked, the incidence relation between the attribute information table, the design information table and the material information table of the project is finally established, referring to the project data A, the project data B to the project data N in figure 2, the data tables of different types are associated in the corresponding project, the evaluation form 32 automatically obtains the engineering data values of the engineering information, the design parameters and the material numbers, and managers of construction, supervision and owners can quickly compare and analyze whether the construction quality on site can meet the standard requirements or not by checking the measured values on site.
Referring to fig. 4, it is an overall technical architecture diagram of the transmission and transformation engineering quality data management and control system according to the embodiment of the present invention, and the lowest layer of the architecture is an equipment layer, which is a hardware basis for system construction: the main equipment comprises an application server, a database server, a server management terminal, a PC operation terminal and a mobile terminal. The application server deploys a webpage version system and a data synchronization interface, and the database server is used for deploying a server-side database. The PC operation terminal is used for browsing the website released by the server. The mobile terminal is used for deploying the mobile APP and achieving information collection and browsing.
The data storage layer integrates data through ETL (extraction, conversion and loading) on the basis of a data source to form a data set used by upper-layer calculation or business. The system stores data in a relational database and a file mode, and the used databases are MySQL (server side) and SQLite (mobile side).
Through the integration of the data storage layer, a data layer is formed for the application of upper layer functions. The integrated data set comprises an engineering information data set, a design information data set, a material information data set, an evaluation form data set and a system data set.
Based on the data layer, the system constructs a corresponding application module, thereby forming an application layer. The functional modules of the application layer comprise: engineering information management, design parameter management, material numbering management, examination and evaluation form filling, data statistics and collection, mobile terminal display and system management.
The user layer exposes the objects of the system services. The system provides services in a portal website type and a mobile terminal APP type, and users of the services comprise a construction management unit, a supervision unit and a construction unit.
The engineering data input unit also comprises an offline storage unit which is used for storing engineering data information offline at the PC webpage end and the mobile end.
The engineering data input unit also comprises a networking detection unit for detecting whether the PC end or the mobile end has networking operation or not, and if so, uploading the off-line stored engineering data information to the network server end.
The quality data management and control system for the power transmission and transformation project further comprises: the system management unit is used for managing user information and configuring a background network server; and the engineering data display unit is used for displaying the engineering attribute information, the design parameter information, the material number information and the evaluation form information through the webpage end display unit and the mobile end display unit. After the information is input, the service condition and procedure qualification condition of materials in each process of the project can be conveniently known through the project data display unit.
Referring to fig. 5, the power transmission and transformation project quality data management and control system according to the embodiment of the present invention is composed of a web server system and a mobile terminal system.
The webpage end functions comprise: engineering information management, design information management, quality evaluation information management and system management.
(1) Engineering information management: the functions of inputting, inquiring and browsing the transmission and transformation project converter station/transformer station, the project attribute information of the line, the marking segment division information and the tower attribute information are realized.
(2) Design information management: the management of the design information related to the quality evaluation of the power transmission and transformation project converter station/transformer substation and line construction in each process stage is realized. For example, the line engineering design information comprises basic design information, line iron tower basic root opening parameters, grounding type design information, stringing design information, jumper sag design information, cross-domain design information, channel cleaning design information and protection facility design information, and when an evaluation form is filled in after the information is input, the platform automatically acquires design information parameters, so that the design information parameters are conveniently compared and analyzed with the actual engineering information.
(3) Material information management: the management of material information related to quality evaluation of each process stage of the power transmission and transformation project converter station/transformer substation and line construction is realized. For example, the line engineering material information comprises basic material information, grounding material information, iron tower material information and overhead line material information input, and after the information input is completed, the use condition and procedure qualification condition of materials in each process of the engineering can be conveniently known.
(4) Quality evaluation information management: the functions of inputting, approving, inquiring and counting the forms of the converter station/transformer substation and the line inspection and evaluation of the power transmission and transformation project are realized. Wherein, the examination and approval of the quality examination and evaluation form supports multi-level examination and approval: the construction unit fills in the assessment form and submits approval → manages and rechecks the construction quality information → the owner reviews the construction quality.
(5) And (3) system management: including user unit management, user management, background configuration, etc.
The mobile terminal functions include: engineering information browsing, design information browsing, quality inspection and evaluation information filling, system configuration and the like.
(1) Browsing engineering information: and the query and browsing of the engineering information input by the webpage end are realized.
(2) Design information browsing: and the query and browsing of the design information are realized.
(3) Browsing material information: and the inquiry and browsing of the material information are realized.
(4) Filling quality test information: and the input and query of the information of the examination and evaluation form can be supported at any time and any place.
(5) System configuration: management of user information, offline data management, and the like.
The above embodiments are only used to illustrate the present invention and not to limit the technical solutions described in the present invention; thus, while the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those skilled in the art that various changes may be made and equivalents may be substituted; all such modifications and variations are intended to be included herein within the scope of this disclosure and the present invention and protected by the following claims.