A construction quality inspection and evaluation system construction method and system based on dynamic form

Abstract

The present invention provides a construction method and system for a construction quality inspection and evaluation system based on dynamic forms, including: based on Windows Form and GDI+ technology, realizing desktop dynamic form components to support form definition; integrating CEF browser engine to extend desktop dynamic form components to support form calculation; based on Asp.net framework, using structured database and unstructured database to realize server-side module to support data access and multi-terminal transmission; based on Windows Form framework, realizing dynamic form definition module to complete the definition of quality verification form; based on Windows Form framework, realizing desktop data display and entry module; based on Cordova framework, realizing mobile terminal data display and entry module. The present invention can significantly improve the efficiency of construction quality inspection and evaluation supervision work, reduce manual errors, enhance form flexibility, and realize multi-terminal collaboration.

Description

Technical Field

[0001] The present invention relates to the field of information technology, and in particular to a method and system for constructing a construction quality inspection and evaluation system based on a dynamic form. Background Art

[0002] In the engineering field, such as the water conservancy and hydropower industry, construction quality inspection and supervision is the key to ensuring the quality and safety of water conservancy and hydropower projects, and construction quality inspection and supervision is the core link of this supervision system.

[0003] The traditional inspection and evaluation methods for the construction quality of water conservancy and hydropower projects have many drawbacks:

[0004] (1) Inefficiency: Currently, many projects under construction still rely on paper-based inspection and evaluation documents. From data collection, recording to data entry, the entire process requires manual operation. A single water conservancy and hydropower project generates a large number of inspection and evaluation forms, and manual data entry consumes a lot of time, making it difficult for supervisors to obtain complete and accurate data in a timely manner, and unable to detect quality problems in a timely manner, which in turn seriously affects the overall supervision progress of the project.

[0005] (2) Poor data accuracy: Paper forms rely on manual filling, which can easily lead to data distortion due to human error. Once quality problems occur in water conservancy and hydropower projects, it is difficult to trace the data. Supervisors find it difficult to quickly and accurately trace the relevant data, making it extremely difficult to determine the root cause of the problem and the responsible party, which greatly weakens the accuracy and authority of supervision.

[0006] (3) Difficulty in multi-terminal coordination: Data transmission delays are common at water conservancy and hydropower construction sites. There is a lack of effective coordination between the various supervisory terminals (such as the mobile terminals of on-site supervisors, the desktop terminals of office supervisors, and the server terminals of higher-level supervisory departments), and data cannot be synchronized in a timely manner. This leads to differences in the data obtained by different supervisory terminals, seriously affecting the timeliness and accuracy of supervisory decisions, making it difficult to form an efficient and unified supervisory force.

[0007] (4) Insufficient form flexibility: Existing water conservancy and hydropower project acceptance forms have many rigid indicators, making it difficult to meet the specific process requirements of different water conservancy and hydropower projects. The contradiction between standardized templates and personalized needs is becoming increasingly prominent. The existing system lacks a flexible adjustment mechanism and cannot meet the diverse form requirements. This makes it difficult for the supervision process to comprehensively and accurately cover various quality inspection points, reducing the effectiveness of supervision.

[0008] At the same time, the continuous development of computer technology, mobile internet technology, and cloud computing technology has provided technical support for the digital transformation of construction quality inspection and assessment systems. However, some current construction quality inspection and assessment supervision systems still have functional deficiencies. For example, the ability to customize dynamic forms is limited, making it difficult to adapt to complex and changing quality supervision scenarios; cross-platform data synchronization suffers from delays or data inconsistencies; and mobile terminals have weak functionality and unfriendly user interfaces, failing to meet the needs of construction workers and supervisors for convenient and efficient operation on the construction site. These factors have limited the widespread application of supervision systems in practical work.

[0009] Therefore, under the wave of digital transformation in the water conservancy and hydropower industry, there is an urgent need to develop a new water conservancy and hydropower project construction quality inspection and supervision system that can not only break through the efficiency and accuracy bottlenecks of traditional water conservancy and hydropower project inspection and evaluation methods, but also address the functional defects of existing digital systems. The construction of this system needs to have highly flexible dynamic form customization capabilities that can quickly adapt to the special process requirements of different projects; at the same time, it must achieve real-time and accurate synchronization of cross-platform data and optimize the mobile terminal operation experience to meet the high-frequency and efficient operation needs of construction sites. Reshaping the construction quality inspection and evaluation process through technological innovation will become a key breakthrough in improving the quality control level of the construction industry and promoting high-quality development of the industry. Summary of the Invention

[0010] The present invention provides a method and system for constructing a construction quality inspection and evaluation system based on dynamic forms, which is used to solve the defects of low efficiency, easy error, poor form flexibility and difficulty in multi-terminal collaboration in the traditional construction quality inspection and evaluation supervision methods in the prior art, so as to meet the strict requirements for construction quality inspection and evaluation supervision in modern large-scale and complex business scenarios, and provide efficient quality supervision tools for supervision departments and related enterprises.

[0011] In a first aspect, the present invention provides a method for constructing a construction quality inspection and evaluation system based on a dynamic form, comprising:

[0012] Building a desktop dynamic form component based on the Windows Form framework and GDI+ technology. The desktop dynamic form component supports form definition.

[0013] Integrate the CEF browser engine and extend the desktop dynamic form component, which supports form calculation;

[0014] Based on the Asp.net framework, a server module is constructed using structured and unstructured databases. The server module supports data storage and multi-terminal transmission.

[0015] Based on the Windows Form framework, a dynamic form definition module is constructed, wherein the dynamic form definition module includes a quality verification form definition;

[0016] Based on the Windows Form framework, a desktop data display and entry module is constructed, which supports providing data processing functions to users;

[0017] Based on the Cordova framework, a mobile terminal data display and entry module is constructed, which supports providing data operation functions to users.

[0018] According to a method for constructing a construction quality inspection and evaluation system based on a dynamic form provided by the present invention, a desktop dynamic form component is constructed based on the Windows Form framework and GDI+ technology. The desktop dynamic form component supports form definition and includes:

[0019] Determine the table template data structure and construct cells, rows, columns and tables through classes in the C# language;

[0020] Use NewtonJson to convert the table template instance data into a JSON string, convert the JSON string into a byte array in UTF8 format, use GZip to compress the byte array, use the AES encryption algorithm to encrypt the compressed byte data, and store the encrypted result as table template data;

[0021] Load and read the table template data, store the read content in a byte array, decrypt the read content using the AES encryption algorithm, decompress the byte array using GZip, convert the byte array into a JSON string, and use NewtonJson to convert the JSON string into table template instance data;

[0022] Define the cell renderer interface and implement multiple cell rendering methods through specific cell renderers;

[0023] Implement the cell renderer interface using multiple types of cell renderers;

[0024] Add the PrintAreas property and define the public voidReCalSizeAndPageInfo() method in the ReportData class, add the print controller class ReportPrintController, and the table display component ReportPreviewer;

[0025] Define the cell editor interface and implement multiple cell editing methods through specific cell editors;

[0026] Implement the cell editor interface using multiple types of cell editors;

[0027] In the table display component ReportPreviewer, respond to the mouse double-click event and parse it into a cell double-click event. According to the cell properties, select the corresponding cell editor, initialize the corresponding cell editor, call the StartEdit method of the cell editor, enter the cell editing, respond to the editor exit event, call the EndEdit method of the cell editor, end the cell editing, and write the editor's editing results back to the cell properties. Add methods in ReportPreviewer to perform various preset operations on the table template data, add the WinfForm window FormDesign, embed the ReportPreviewer component, and implement the call of table operations through the menu bar and toolbar on the window.

[0028] According to the present invention, a construction quality inspection and evaluation system construction method based on dynamic forms is provided, which integrates the CEF browser engine and extends the desktop dynamic form component. The desktop dynamic form component supports form calculations and includes:

[0029] Download the corresponding DLL file from the CefSharp official website, introduce the DLL file into the code project, create the ChromiumWebBrowser component in CefSharp and initialize it;

[0030] Construct table instance data structure by defining row data, table data and data space;

[0031] Define the public class CalContext, which encapsulates an instance of the DataSpaceData class and defines methods for obtaining data from a single table and row data.

[0032] Define methods for storing cell-related data and obtaining cell data in CalContext;

[0033] Use CEF browser engine to access table data through JavaScript;

[0034] Implement general computing algorithms based on JavaScript scripts;

[0035] Expand the table template data structure to support quality inspection and assessment related attributes, including assessment item level and assessment item type, define the assessment item setting type, and add quality inspection and assessment related attributes to the cell properties;

[0036] Realize preset quality inspection and evaluation calculation indicators, including automatic evaluation according to the settings of the acquisition cell, acquisition of technical indicator parameter values, relevant industries not dividing process unit engineering or process evaluation, relevant industries dividing process unit engineering evaluation and finding process evaluation results.

[0037] According to the present invention, a construction quality inspection and evaluation system construction method based on dynamic forms is provided. Based on the ASP.NET framework, a structured database and an unstructured database are used to construct a server module. The server module supports data storage and multi-terminal transmission, including:

[0038] Construct the table structure of the core data table in the structured database;

[0039] Implement user management, login and logout interfaces;

[0040] Implement project management related interfaces;

[0041] Implement the form definition access interface, store the basic data of the form definition in the structured database, and store the form definition metadata in the unstructured database;

[0042] Implement business information management related interfaces;

[0043] Implement business data access interface, store basic business data in structured database, and store business form data in unstructured database;

[0044] Implement the notification interface when business form data changes.

[0045] According to a method for constructing a construction quality inspection and evaluation system based on a dynamic form provided by the present invention, a dynamic form definition module is constructed based on a Windows Form framework. The dynamic form definition module includes a quality verification form definition, including:

[0046] Implement the list query function, add function, edit function and delete function of basic data defined in the form;

[0047] Introducing dynamic form definition components to implement editing and publishing functions of form templates;

[0048] Complete the template editing of the process inspection record form, process evaluation form, and unit project evaluation form required by the system, and publish the template.

[0049] According to a method for constructing a construction quality inspection and evaluation system based on a dynamic form provided by the present invention, a desktop data display and entry module is constructed based on a Windows Form framework. The desktop data display and entry module supports providing data processing functions to users, including:

[0050] Implement the list query, add, edit and delete functions for basic business data;

[0051] Introducing dynamic form definition components to implement the editing and saving functions of business form data;

[0052] Subscribe to the notification interface when the business form data on the server changes, and achieve automatic synchronization when the business form data changes.

[0053] According to a method for constructing a construction quality inspection and evaluation system based on a dynamic form provided by the present invention, a mobile terminal data display and entry module is constructed based on the Cordova framework. The mobile terminal data display and entry module supports providing data operation functions to users, including:

[0054] Create a mobile project based on the Cordova framework;

[0055] In the mobile project, the table template definition is read from the server through the Axios network component;

[0056] Convert table definition data into JavaScript objects and parse table template definitions;

[0057] Parse the quality assessment items in the JavaScript object one by one, render them according to their properties, and generate different types of input frames, other information items, and the result rendering display of the entire form;

[0058] On the mobile side, the Axios network component is used to call the form business data acquisition interface to obtain business data, parse the business data and convert it into an object format, traverse all fields in the business data object, bind the corresponding values ​​and display them to the input component of the quality inspection and evaluation project, re-call the calculation of the quality inspection and evaluation project and update the calculation results, and re-call the calculation of the form and update the calculation results;

[0059] Enter data in the input component of the quality inspection project, click the Save button on the mobile terminal to save the data to the local cache of the mobile terminal, click the Submit button on the mobile terminal, call the business data saving interface through the Axios network component, and save the data to the server;

[0060] Add a switching function on the mobile terminal to store data offline and automatically upload offline data;

[0061] Subscribe to the notification interface when the business form data on the server changes, and achieve automatic synchronization when the business form data changes.

[0062] In a second aspect, the present invention further provides a construction quality inspection and evaluation system construction system based on a dynamic form, comprising:

[0063] A first processing module is used to build a desktop dynamic form component based on the Windows Form framework and GDI+ technology, wherein the desktop dynamic form component supports form definition;

[0064] The second processing module is used to integrate the CEF browser engine and expand the desktop dynamic form component, wherein the desktop dynamic form component supports form calculation;

[0065] The third processing module is used to build a server module based on the Asp.net framework using a structured database and an unstructured database, and the server module supports data storage and multi-terminal transmission;

[0066] a fourth processing module, configured to construct a dynamic form definition module based on a Windows Form framework, wherein the dynamic form definition module includes a quality verification form definition;

[0067] A fifth processing module is used to build a desktop data display and input module based on the Windows Form framework, wherein the desktop data display and input module supports providing data processing functions to users;

[0068] The sixth processing module is used to build a mobile terminal data display and entry module based on the Cordova framework, and the mobile terminal data display and entry module supports providing data operation functions to users.

[0069] In a third aspect, the present invention also provides an electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the program, the method for constructing a construction quality inspection and evaluation system based on a dynamic form as described in any one of the above is implemented.

[0070] In a fourth aspect, the present invention further provides a non-transitory computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements a method for constructing a construction quality inspection and evaluation system based on a dynamic form as described in any one of the above.

[0071] The method and system for constructing a construction quality inspection and evaluation system based on dynamic forms provided by the present invention effectively overcome the defects of the existing technology such as limited expansion capability, inconsistent data, and weak mobile terminal functions. It has the advantages of high supervision efficiency, high data accuracy, low usage threshold, and support for multi-terminal collaboration. In addition, the form is flexible, convenient, reusable, reliable, and scalable, which significantly improves the level of construction quality inspection and evaluation supervision of water conservancy and hydropower projects. BRIEF DESCRIPTION OF THE DRAWINGS

[0072] In order to more clearly illustrate the technical solutions in the present invention or the prior art, the following briefly introduces the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings described below are some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0073] Figure 1 This is a flow chart of a method for constructing a construction quality inspection and evaluation system based on a dynamic form provided by the present invention;

[0074] Figure 2 It is a structural diagram of a construction quality inspection and evaluation system based on a dynamic form provided by the present invention;

[0075] Figure 3 It is a structural schematic diagram of the electronic device provided by the present invention. DETAILED DESCRIPTION

[0076] To make the objectives, technical solutions, and advantages of the present invention more clear, the technical solutions of the present invention will be clearly and completely described below in conjunction with the accompanying drawings. Obviously, the embodiments described are only some embodiments of the present invention, not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative efforts shall fall within the scope of protection of the present invention.

[0077] Figure 1 This is a flow chart of a construction quality inspection and evaluation system construction method based on a dynamic form provided by an embodiment of the present invention. Figure 1 As shown, including:

[0078] Step 100: Building a desktop dynamic form component based on the Windows Form framework and GDI+ technology, wherein the desktop dynamic form component supports form definition;

[0079] Step 200: Integrate the CEF browser engine and extend the desktop-side dynamic form component, wherein the desktop-side dynamic form component supports form calculation;

[0080] Step 300: Based on the Asp.net framework, a server module is constructed using a structured database and an unstructured database. The server module supports data storage and multi-terminal transmission.

[0081] Step 400: Building a dynamic form definition module based on the Windows Form framework, wherein the dynamic form definition module includes a quality verification form definition;

[0082] Step 500: Building a desktop data display and input module based on the Windows Form framework, wherein the desktop data display and input module supports providing data processing functions to users;

[0083] Step 600: Based on the Cordova framework, a mobile terminal data display and entry module is constructed, wherein the mobile terminal data display and entry module supports providing data operation functions to users.

[0084] It should be noted that the embodiment of the present invention still takes the water conservancy and hydropower industry as an example. For the sake of ease of implementation, the embodiment of the present invention preferably recommends building a construction quality inspection and evaluation system based on a dynamic form. The system includes the following core parts:

[0085] Dynamic form definition component: provides a customized Excel-like table component on the desktop, builds a form structure system based on the JSON metadata definition method, draws on Excel operation logic, and facilitates water conservancy and hydropower project supervisors to perform table definition work such as cell editing, row and column operations; based on the Windows Form system, it supports the definition and editing of 28 basic data types and composite data; the interface rendering layer adopts GDI+ technology, and adopts double buffering for drawing for big data; integrates the property grid component in the Windows Form framework, provides editing support for various form properties such as printing properties, cell properties, etc., which is convenient, fast and highly scalable; integrates the CEF browser engine, builds an interactive bridge with JavaScript, supports built-in calculation methods for common water conservancy and hydropower project inspection item results and user-defined calculations, and is highly flexible to meet the computing needs of different water conservancy and hydropower project supervision scenarios.

[0086] Server module: Based on the Asp.net framework, using structured database and unstructured database, the server module is implemented to support the storage and access of water conservancy and hydropower project table definition data, business data, table data, and multi-terminal data transmission, providing reliable data storage and transmission guarantees for water conservancy and hydropower project supervision work.

[0087] Dynamic form definition module: Based on the dynamic form definition component and server-side module, a what-you-see-is-what-you-get operating environment is provided on the desktop. Water conservancy and hydropower project supervisors can easily define the structure of the water conservancy and hydropower project construction quality inspection and evaluation form according to the supervision needs of water conservancy and hydropower projects, add process construction record forms, process evaluation forms, unit project evaluation forms and other form types, define inspection items and detection items in the form, support visual configuration interface, and realize zero-code or low-code form customization, which greatly reduces the usage threshold for supervisors and improves the customization efficiency of supervision forms.

[0088] Desktop Data Display and Entry Module: Based on the Windows Forms framework, this module implements desktop data display and entry. It displays business data based on project characteristics. Dynamic form definition components and predefined quality inspection and evaluation form templates enable form display, data entry, and calculations. This facilitates water conservancy and hydropower project supervisors to conduct detailed entry, in-depth analysis, and rigorous review of construction quality data within their office environment, providing strong data support for supervisory decision-making.

[0089] Mobile Data Display and Entry Module: Developed based on the Cordova framework and built with HTML5, CSS3, and JavaScript, it dynamically parses structured tables defined on the desktop and automatically generates a concise, easy-to-use data display and entry interface tailored to mobile screens. Data calculation logic is consistent with the desktop version. It supports offline data entry. Even without an internet connection, users can enter construction data normally. This data is temporarily stored in a local cache and automatically synchronized with the PC-based spreadsheet when the network is restored. This meets the needs of water conservancy and hydropower project supervisors for data collection and entry anytime, anywhere on the construction site.

[0090] Automatic multi-terminal data synchronization: Leveraging bidirectional timestamp synchronization technology, data consistency is maintained across PC desktop terminals, Android and iOS mobile terminals, and the server. The server system supports high data throughput, captures data changes through data monitoring technology, tags data with millisecond-level timestamps, and resolves data conflicts by combining user and time priorities. It supports complete data traceability and encrypts transmitted data using the nationally classified SM4 encryption algorithm. This ensures real-time, accurate, and reliable data synchronization across all water conservancy and hydropower project supervisory terminals, enabling supervisory departments to fully understand the dynamics of project construction quality and achieve efficient oversight.

[0091] Based on the above embodiment, step 100 includes:

[0092] Step 101: Define the table template data structure:

[0093] The table template data structure consists of cells, rows, columns, and tables, and is defined through classes in the C# language;

[0094] The cell definition ReportCell contains properties such as data, style, background color, foreground color, font, margin, renderer type, editor type, etc.

[0095] The row definition ReportRow includes properties such as title, row height, style, background color, foreground color, alignment, font, visibility, editability, and paging.

[0096] The column definition ReportCol includes properties such as title, column width, alignment, visibility, editability, and paging.

[0097] The table definition ReportData contains properties such as the number of rows, columns, merge information, page settings, header settings, and footer settings. The number of rows and columns determines the data of the cells in the template, and the merge information determines the merge status of the cells.

[0098] Step 102: Storing table template data:

[0099] Use NewtonJson to convert the table template instance data into a json string;

[0100] Convert the json string to a byte array in UTF8 format;

[0101] Use GZip to compress the byte array;

[0102] Use AES encryption algorithm to encrypt the compressed byte data;

[0103] Write the encryption result to a file.

[0104] Step 103: Load table template data:

[0105] Read table template data from the file and store it in a byte array;

[0106] Use the AES encryption algorithm to decrypt the read content;

[0107] Use GZip to decompress the byte array;

[0108] Convert the byte array to a json string;

[0109] Use NewtonJson to convert the json string into table template instance data.

[0110] Step 104: Define the cell renderer interface:

[0111] Define the cell renderer interface public interface ICellRender, which contains methods for cell rendering and is implemented by specific cell renderers;

[0112] Define the interface method void DrawBackground(Graphics g, float scale, ReportDatareportData, ReportCell cell, RectangleF rect, ReportCellStyle style, boolforPrinter) to draw the cell background;

[0113] Define the interface method void DrawCellBorder(Graphics g, float scale, ReportDatareportData, PrintArea area, ReportCell cell, RectangleF rect, ReportCellStylestyle, bool forPrinter) to draw the cell border;

[0114] Define the interface method RectangleF DrawContent(Graphics g, float scale, ReportData reportData, ReportCell cell, RectangleF rect, ReportCellStylestyle, PrintArea area, bool draw, bool forPrinter) to draw cell content;

[0115] Define the interface method SizeF CalCellNeedSize(int orgWidth, int orgHeight,ReportCellStyle style, ReportCell cell, PrintArea area) to calculate the required size of the cell;

[0116] Define the interface method void AdjustCellSize(int orgWidth, int orgHeight, SizeFneedSize, ReportCellStyle style, ReportCell cell, CellRange range, ReportDatareportData, bool prepareNarrow, PrintArea area) to adjust the cell size.

[0117] Step 105: Implement the cell renderer:

[0118] Contains normal text cell renderer, image cell renderer, QR code cell renderer, oblique delimiter cell renderer, and rich text cell renderer, which respectively implement the ICellRender interface defined in the previous step.

[0119] Step 106: Implement table rendering:

[0120] Add the PrintAreas property in the ReportData class to store paging information;

[0121] Define the method public void ReCalSizeAndPageInfo() in the ReportData class to calculate the paging information based on row height, column width, page settings and other data and store it in the PrintAreas property;

[0122] Added a new print controller class ReportPrintController, which calls the cell renderer method to implement table rendering logic and supports output to printers and GDI+ canvas;

[0123] A new table display component, ReportPreviewer, is added. It constructs a GDI+ canvas in the Windows window and then calls methods of the ReportPrintController class to implement table rendering.

[0124] Step 107: Define the cell editor interface:

[0125] Define the public interface IEditor for the cell editor, which contains methods for cell editing and is implemented by specific cell editors.

[0126] Define the interface method void Init(int pageIndex, ReportCell cell, RectangleFrect, ReportPreviewerControl parent, bool causeByMouse, bool canEditNext) to initialize the cell editor;

[0127] Define the interface method void StartEdit() to start editing a cell;

[0128] Define the interface method void EndEdit(bool submitValue) to end editing the cell.

[0129] Step 108: Implementing the Cell Editor:

[0130] It includes a normal text cell editor, a numeric cell renderer, a date and time cell renderer, an image cell renderer, a rich text cell editor, etc., which respectively implement the IEditor interface defined in the previous step.

[0131] Step 109: Implementing the table designer:

[0132] In the table display component ReportPreviewer, respond to the mouse double-click event and interpret it as a cell double-click event;

[0133] Select the corresponding cell editor according to the cell properties;

[0134] Initialize the corresponding cell editor;

[0135] Call the StartEdit method of the cell editor to enter cell editing;

[0136] In response to the editor exit event, call the EndEdit method of the cell editor to end cell editing;

[0137] Write the editor's editing results back to the cell properties;

[0138] Add methods in ReportPreviewer to perform various operations on table template data, such as public voidInsertRow to add rows, public void DeleteRow to delete rows, public void InsertCol to add columns, public void DeleteCol to delete columns, public void CopyCells to copy cells, public voidPasteCells to paste cells, public void Merge to qualify cells, public void UnMerge to cancel a merge, etc.

[0139] Add WinfForm window FormDesign, embed ReportPreviewer component, and implement call of form operations through menu bar, toolbar, etc. on the window.

[0140] Based on the above embodiment, step 200 includes:

[0141] Step 201: Integrate CEF engine:

[0142] Download the corresponding DLL file from the CefSharp official website;

[0143] Introduce CefSharp's DLL file into the code project;

[0144] Create the ChromiumWebBrowser component in CefSharp and initialize it.

[0145] Step 202: Define the table instance data structure:

[0146] Define row data public class TableRow : Dictionary<string, object> {}, stores row data in the form of key-value pairs;

[0147] Define table data public class TableData : Dictionary<int, TableRow> {}, stores the data of a single table in the form of key-value pairs;

[0148] Define the data space public class DataSpaceData : Dictionary<string, TableData> {}, stores data from multiple tables in the form of key-value pairs.

[0149] Step 203: Associating the cell with the instance data:

[0150] Define the public class CalContext, which is a computing environment class and encapsulates an instance of the DataSpaceData class.

[0151] Define the method public static TableData getTableData(DataSpaceDatadataSpaceData, string tableKey) to get the data of a single table;

[0152] Define the method public static TableRow getTableRow(TableData tableData, introwIndex) to get row data;

[0153] Step 204: Access data:

[0154] Define the method public static void setValue(TableRow rowData, string field, object value) in CalContext to store the data associated with the cell;

[0155] Define the method public static object getValue(TableRow rowData, string field) in CalContext to get cell data;

[0156] Use the CEF engine to access table data through JavaScript. The specific method is to call the setValue and getValue methods in CalContext through the CEF engine in JavaScript.

[0157] Step 205: Implement the general calculation formula based on JavaScript script:

[0158] Implement a large number of general calculation formulas, including but not limited to:

[0159] Rounding off decimal places: function roundValue(value, xs);

[0160] Get the value: function getf(inputId, rowIndex, dataSpaceKey, tableKey);

[0161] Get an integer: function getint(inputId, rowIndex, dataSpaceKey, tableKey);

[0162] Sum: function getSum();

[0163] Find the difference: function getSub(value1, value2);

[0164] Find the absolute value: function getAbs(value);

[0165] Calculate the average value: function getAvg().

[0166] Step 206: Expand the table template data structure to support quality assessment related attributes:

[0167] Definition of rating item level:

[0168] public enum EvaluateItemLevel

[0169] {

[0170] None = 0,

[0171] Input item = 1,

[0172] General items = 10,

[0173] Master Project = 20

[0174] }

[0175] Definition of rating item type:

[0176] public enum EvaluateItemType

[0177] {

[0178] None = 0,

[0179] Check items = 10,

[0180] Detection items = 20,

[0181] Process Items = 30

[0182] }

[0183] Define the evaluation item setting type public class EvaluateItemSetting, which includes properties such as group, name, evaluation item level, evaluation item type, and value field;

[0184] Add the quality evaluation related property public EvaluateItemSettingEvaluateItemSetting in the cell properties.

[0185] Step 207: Implement common quality inspection and evaluation calculation formulas:

[0186] Find the cell and automatically evaluate it based on its settings: function autoExcutePd(field, rowIndex, tableKey, tplKey);

[0187] Get technical indicator parameter values: function getJszbArgValue(arg, rvs, cvs);

[0188] The water conservancy and hydropower industry does not divide process unit projects or process assessments: function excutePd_slsd_type1;

[0189] Water conservancy and hydropower industry process unit engineering assessment: function excutePd_slsd_type7();

[0190] Find process evaluation results: function excutePd_findGxResults(cells, level,bzResultLevel).

[0191] Based on the above embodiment, step 300 includes:

[0192] Step 301: In the MySQL database, design the table structure of core data tables such as user information table, project information table, form definition table, business information table, and business data table;

[0193] Step 302: Implement user management, login, logout and other interfaces;

[0194] Step 303: Implement project management related interfaces;

[0195] Step 304: Implement the form definition access interface, where the form definition basic data is stored in the MySQL database and the form definition metadata is stored in the MongoDB database;

[0196] Step 305: Implement business information management related interfaces;

[0197] Step 306: Implement the business data access interface, where the business basic data is stored in the MySQL database and the business form data is stored in the MongoDB database;

[0198] Step 306: Implement a notification interface when business form data changes.

[0199] Based on the above embodiment, step 400 includes:

[0200] Step 401: Implementing a list query function for basic data defined in a form;

[0201] Step 402: Implement new functions for defining basic data in the form;

[0202] Step 403: Implementing the editing function of the basic data of the form definition;

[0203] Step 404: Implement the deletion function of the basic data defined in the form;

[0204] Step 405: Introduce the dynamic form definition component to implement the editing function of the form template;

[0205] Step 406: Implement the form template publishing function;

[0206] Step 407: Complete the template editing of the process inspection record sheet, process evaluation sheet, and unit project evaluation sheet required by this system, and publish them.

[0207] Based on the above embodiment, step 500 includes:

[0208] Step 501: Implementing a list query function for basic business data;

[0209] Step 502: Implement new functions for basic business data;

[0210] Step 503: Implementing the editing function of business basic data;

[0211] Step 504: Implement the deletion function of the basic business data;

[0212] Step 505: Introduce the dynamic form definition component to implement the editing function of the business form data;

[0213] Step 506: Implement the function of saving the business form data;

[0214] Step 507: Subscribe to the notification interface for changes in the service form data on the server side, and automatically synchronize when changes occur in the service form data.

[0215] Based on the above embodiment, step 600 includes:

[0216] Step 601: Create a mobile project based on the Cordova framework:

[0217] Execute the following commands in order:

[0218] Install Cordova: npm install -g cordova;

[0219] Create a new Cordova project: cordova create myApp com.example.myApp MyApp;

[0220] Enter the project directory: cd myApp;

[0221] Add platform: cordova platform add android, cordova platform add ios.

[0222] Step 602: Read the table template definition from the server:

[0223] In the mobile project, reference the Axios network component;

[0224] Use the Axios network component to request the server interface through http to obtain the table definition data.

[0225] Step 603: Parse the table template definition:

[0226] Convert table definition data (json format string) into JavaScript object;

[0227] Check whether the attributes of the quality inspection items in the object are correct. If there are any problems, assign them to the default initial values.

[0228] Step 604: Rendering the table:

[0229] Analyze the quality inspection items in the object one by one;

[0230] Render according to the attributes of the quality inspection and assessment items, and generate different types of input frames, such as text input, afternoon selection input, test value input, etc.

[0231] Generate other information items of quality inspection and evaluation items, such as calculation results, pass rate, etc.;

[0232] Generates the result rendering display of the entire form.

[0233] Step 605: Read the table data and display:

[0234] On the mobile side, call the form business data acquisition interface through Axios to obtain data;

[0235] Parse business data and convert it into object format;

[0236] Traverse all fields in the business data object, bind the values ​​and display them to the input components of the quality assessment project;

[0237] Recall the calculation of quality inspection and evaluation items and update the calculation results;

[0238] Recall the calculation of the form and update the calculation results.

[0239] Step 606: Edit table data:

[0240] Users can enter data in the input component of the quality inspection project.

[0241] Step 607: Save data:

[0242] Click the Save button on the mobile terminal to save the data to the local cache of the mobile terminal.

[0243] Step 608: Submit data to the server:

[0244] Click the Submit button on the mobile terminal, call the business data saving interface through Axios, and save the data to the server.

[0245] Step 609: Data offline storage:

[0246] Add functions on the mobile terminal to actively switch between online and offline modes;

[0247] When switching from offline mode to online mode, a network check is required first, and the switch is allowed only after the check passes;

[0248] When the mobile app is in offline mode, data is stored in the local database via localforage.

[0249] Step 610: Automatically upload offline data:

[0250] When the mobile application switches from offline mode to online mode, it checks the local database for uncommitted data and automatically submits any uncommitted data.

[0251] Step 611: Subscribe to the notification interface for changes in the service form data on the server side, and automatically synchronize when changes occur in the service form data.

[0252] In order to more clearly illustrate the advantages of the construction quality inspection and supervision system based on dynamic forms described in the present invention compared with several existing methods, the embodiments of the present invention compare these technical solutions.

[0253] Several methods are numbered as follows:

[0254] Method 1: Use paper inspection and evaluation documents.

[0255] Method 2: Use the traditional construction quality inspection and supervision system.

[0256] The comparison results are shown in Table 1 below:

[0257] Table 1 Comparison results

[0258]

[0259] It can be seen from the above table that the construction quality inspection and supervision system based on dynamic forms described in the present invention has high work efficiency, high data accuracy, low usage threshold, supports multi-terminal collaboration, and has the advantages of flexible forms, high convenience, high reusability, high reliability, and strong scalability compared with existing technologies such as using paper inspection and evaluation documents and quality inspection and evaluation systems based on non-dynamic forms.

[0260] The following describes the construction quality inspection and evaluation system construction system based on dynamic forms provided by the present invention. The construction quality inspection and evaluation system construction system based on dynamic forms described below and the construction quality inspection and evaluation system construction method based on dynamic forms described above can refer to each other.

[0261] Figure 2 This is a structural diagram of a construction quality inspection and evaluation system based on a dynamic form provided by an embodiment of the present invention. Figure 2As shown, it includes: a first processing module 21, a second processing module 22, a third processing module 23, a fourth processing module 24, a fifth processing module 25 and a sixth processing module 26, wherein:

[0262] The first processing module 21 is used to build a desktop dynamic form component based on the Windows Form framework and GDI+ technology, and the desktop dynamic form component supports form definition; the second processing module 22 is used to integrate the CEF browser engine and extend the desktop dynamic form component, and the desktop dynamic form component supports form calculation; the third processing module 23 is used to build a server module based on the Asp.net framework, using structured databases and unstructured databases, and the server module supports data storage and multi-terminal transmission; the fourth processing module 24 is used to build a dynamic form definition module based on the Windows Form framework, and the dynamic form definition module includes quality verification form definition; the fifth processing module 25 is used to build a desktop data display and entry module based on the Windows Form framework, and the desktop data display and entry module supports providing data processing functions to users; the sixth processing module 26 is used to build a mobile data display and entry module based on the Cordova framework, and the mobile data display and entry module supports providing data operation functions to users.

[0263] Figure 3 An example of a physical structure diagram of an electronic device is shown below. Figure 3As shown, the electronic device may include: a processor (processor) 310, a communication interface (Communications Interface) 320, a memory (memory) 330 and a communication bus 340, wherein the processor 310, the communication interface 320, and the memory 330 communicate with each other through the communication bus 340. The processor 310 can call the logic instructions in the memory 330 to execute a method for constructing a construction quality inspection and evaluation system based on dynamic forms, which method includes: constructing a desktop dynamic form component based on the Windows Form framework and GDI+ technology, and the desktop dynamic form component supports form definition; integrating the CEF browser engine to extend the desktop dynamic form component, and the desktop dynamic form component supports form calculation; based on the Asp.net framework, using structured databases and unstructured databases, to construct a server-side module, and the server-side module supports data storage and multi-terminal transmission; based on the Windows Form framework, constructing a dynamic form definition module, and the dynamic form definition module includes a quality verification form definition; based on the WindowsForm framework, constructing a desktop data display and entry module, and the desktop data display and entry module supports providing data processing functions to users; based on the Cordova framework, constructing a mobile-side data display and entry module, and the mobile-side data display and entry module supports providing data operation functions to users.

[0264] Furthermore, the logic instructions in the aforementioned memory 330 can be implemented as software functional units and, when sold or used as independent products, can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, or the portion that contributes to the prior art, or a portion of the technical solution, can be embodied in the form of a software product. This computer software product, stored in a storage medium, includes several instructions for enabling a computer device (which can be a personal computer, server, or network device, etc.) to execute all or part of the steps of the methods described in various embodiments of the present invention. The aforementioned storage medium includes various media capable of storing program code, such as a USB flash drive, a mobile hard drive, a read-only memory (ROM), a random access memory (RAM), a magnetic disk, or an optical disk.

[0265] On the other hand, the present invention also provides a non-transitory computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements a construction quality inspection and evaluation system construction method based on a dynamic form provided by the above-mentioned methods, the method comprising: constructing a desktop dynamic form component based on the Windows Form framework and GDI+ technology, wherein the desktop dynamic form component supports form definition; integrating a CEF browser engine to extend the desktop dynamic form component, wherein the desktop dynamic form component supports form calculation; constructing a server-side module based on the Asp.net framework using a structured database and an unstructured database, wherein the server-side module supports data storage and multi-terminal transmission; constructing a dynamic form definition module based on the Windows Form framework, wherein the dynamic form definition module includes a quality verification form definition; constructing a desktop data display and entry module based on the Windows Form framework, wherein the desktop data display and entry module supports providing data processing functions to users; constructing a mobile-side data display and entry module based on the Cordova framework, wherein the mobile-side data display and entry module supports providing data operation functions to users.

[0266] The device embodiments described above are merely illustrative. The units described as separate components may or may not be physically separate, and the components shown as units may or may not be physical units, i.e., they may be located in one location or distributed across multiple network units. Some or all of the modules may be selected based on actual needs to achieve the objectives of the present embodiment. Persons of ordinary skill in the art will be able to understand and implement the present invention without inventive effort.

[0267] Through the above description of the embodiments, those skilled in the art will clearly understand that each embodiment can be implemented using software plus a necessary general-purpose hardware platform, or of course, hardware. Based on this understanding, the essence of the above technical solution, or the portion that contributes to the prior art, can be embodied in the form of a software product. This computer software product can be stored in a computer-readable storage medium, such as ROM / RAM, a magnetic disk, or an optical disk, and includes a number of instructions for causing a computer device (such as a personal computer, server, or network device) to execute the methods described in each embodiment or certain portions of the embodiments.

[0268] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the various embodiments of the present invention.

Claims

1. A method for constructing a construction quality inspection and evaluation system based on a dynamic form, characterized in that: include: Building a desktop dynamic form component based on the Windows Form framework and GDI+ technology. The desktop dynamic form component supports form definition. Integrate the CEF browser engine and extend the desktop dynamic form component, which supports form calculation; Based on the Asp.net framework, a server module is constructed using structured and unstructured databases. The server module supports data storage and multi-terminal transmission. Based on the Windows Form framework, a dynamic form definition module is constructed, wherein the dynamic form definition module includes a quality verification form definition; Based on the Windows Form framework, a desktop data display and entry module is constructed, which supports providing data processing functions to users; Based on the Cordova framework, a mobile terminal data display and entry module is constructed, which supports providing data operation functions to users; Based on the Windows Form framework and GDI+ technology, a desktop dynamic form component is built. The desktop dynamic form component supports form definition, including: Determine the table template data structure and construct cells, rows, columns and tables through classes in the C# language; Use NewtonJson to convert the table template instance data into a JSON string, convert the JSON string into a byte array in UTF8 format, use GZip to compress the byte array, use the AES encryption algorithm to encrypt the compressed byte data, and store the encrypted result as table template data; Load and read the table template data, store the read content in a byte array, decrypt the read content using the AES encryption algorithm, decompress the byte array using GZip, convert the byte array into a JSON string, and use NewtonJson to convert the JSON string into table template instance data; Define the cell renderer interface and implement multiple cell rendering methods through specific cell renderers; Implement the cell renderer interface using multiple types of cell renderers; Add the PrintAreas property and define the public voidReCalSizeAndPageInfo() method in the ReportData class, add the print controller class ReportPrintController, and the table display component ReportPreviewer; Define the cell editor interface and implement multiple cell editing methods through specific cell editors; Implement the cell editor interface using multiple types of cell editors; In the table display component ReportPreviewer, respond to the mouse double-click event and parse it into a cell double-click event. According to the cell properties, select the corresponding cell editor, initialize the corresponding cell editor, call the StartEdit method of the cell editor, enter the cell editing, respond to the editor exit event, call the EndEdit method of the cell editor, end the cell editing, and write the editor's editing results back to the cell properties. Add methods in ReportPreviewer to perform various preset operations on the table template data, add the WinfForm window FormDesign, embed the ReportPreviewer component, and implement the call of table operations through the menu bar and toolbar on the window.

2. The construction quality inspection and evaluation system construction method based on dynamic forms according to claim 1 is characterized in that: Integrate the CEF browser engine and extend the desktop dynamic form component. The desktop dynamic form component supports form calculations, including: Download the corresponding DLL file from the CefSharp official website, introduce the DLL file into the code project, create the ChromiumWebBrowser component in CefSharp and initialize it; Construct table instance data structure by defining row data, table data and data space; Define the public class CalContext, which encapsulates an instance of the DataSpaceData class and defines methods for obtaining data from a single table and row data. Define methods for storing cell-related data and obtaining cell data in CalContext; Use CEF browser engine to access table data through JavaScript; Implement general computing algorithms based on JavaScript scripts; Expand the table template data structure to support quality inspection and assessment related attributes, including assessment item level and assessment item type, define the assessment item setting type, and add quality inspection and assessment related attributes to the cell properties; Realize preset quality inspection and evaluation calculation indicators, including automatic evaluation according to the settings of the acquisition cell, acquisition of technical indicator parameter values, relevant industries not dividing process unit engineering or process evaluation, relevant industries dividing process unit engineering evaluation and finding process evaluation results.

3. The construction quality inspection and evaluation system construction method based on dynamic forms according to claim 1 is characterized in that: Based on the Asp.net framework, we use structured and unstructured databases to build a server-side module that supports data storage and multi-terminal transmission, including: Construct the table structure of the core data table in the structured database; Implement user management, login and logout interfaces; Implement project management related interfaces; Implement the form definition access interface, store the basic data of the form definition in the structured database, and store the form definition metadata in the unstructured database; Implement business information management related interfaces; Implement business data access interface, store basic business data in structured database, and store business form data in unstructured database; Implement the notification interface when business form data changes.

4. The method for constructing a construction quality inspection and evaluation system based on a dynamic form according to claim 1, characterized in that: Based on the Windows Form framework, a dynamic form definition module is constructed. The dynamic form definition module includes a quality verification form definition, including: Implement the list query function, add function, edit function and delete function of basic data defined in the form; Introducing dynamic form definition components to implement editing and publishing functions of form templates; Complete the template editing of the process inspection record form, process evaluation form, and unit project evaluation form required by the system, and publish the template.

5. The method for constructing a construction quality inspection and evaluation system based on a dynamic form according to claim 1, characterized in that: Based on the Windows Form framework, a desktop data display and entry module is built. The desktop data display and entry module supports providing data processing functions to users, including: Implement the list query, add, edit and delete functions for basic business data; Introducing dynamic form definition components to implement the editing and saving functions of business form data; Subscribe to the notification interface when the business form data on the server changes, and achieve automatic synchronization when the business form data changes.

6. The construction quality inspection and evaluation system construction method based on dynamic forms according to claim 1 is characterized in that: Based on the Cordova framework, a mobile terminal data display and entry module is built. The mobile terminal data display and entry module supports providing data operation functions to users, including: Create a mobile project based on the Cordova framework; In the mobile project, the table template definition is read from the server through the Axios network component; Convert table definition data into JavaScript objects and parse table template definitions; Parse the quality assessment items in the JavaScript object one by one, render them according to their properties, and generate different types of input frames, other information items, and the result rendering display of the entire form; On the mobile side, the Axios network component is used to call the form business data acquisition interface to obtain business data, parse the business data and convert it into an object format, traverse all fields in the business data object, bind the corresponding values ​​and display them to the input component of the quality inspection and evaluation project, re-call the calculation of the quality inspection and evaluation project and update the calculation results, and re-call the calculation of the form and update the calculation results; Enter data in the input component of the quality inspection project, click the Save button on the mobile terminal to save the data to the local cache of the mobile terminal, click the Submit button on the mobile terminal, call the business data saving interface through the Axios network component, and save the data to the server; Add a switching function on the mobile terminal to store data offline and automatically upload offline data; Subscribe to the notification interface when the business form data on the server changes, and achieve automatic synchronization when the business form data changes.

7. A construction quality inspection and evaluation system based on dynamic forms, characterized in that: include: A first processing module is used to build a desktop dynamic form component based on the Windows Form framework and GDI+ technology, wherein the desktop dynamic form component supports form definition; The second processing module is used to integrate the CEF browser engine and expand the desktop dynamic form component, wherein the desktop dynamic form component supports form calculation; The third processing module is used to build a server module based on the Asp.net framework using a structured database and an unstructured database, and the server module supports data storage and multi-terminal transmission; a fourth processing module, configured to construct a dynamic form definition module based on a Windows Form framework, wherein the dynamic form definition module includes a quality verification form definition; A fifth processing module is used to build a desktop data display and input module based on the Windows Form framework, wherein the desktop data display and input module supports providing data processing functions to users; A sixth processing module is used to build a mobile terminal data display and input module based on the Cordova framework, wherein the mobile terminal data display and input module supports providing data operation functions to users; The first processing module is specifically configured to: Determine the table template data structure and construct cells, rows, columns and tables through classes in the C# language; Use NewtonJson to convert the table template instance data into a JSON string, convert the JSON string into a byte array in UTF8 format, use GZip to compress the byte array, use the AES encryption algorithm to encrypt the compressed byte data, and store the encrypted result as table template data; Load and read the table template data, store the read content in a byte array, decrypt the read content using the AES encryption algorithm, decompress the byte array using GZip, convert the byte array into a JSON string, and use NewtonJson to convert the JSON string into table template instance data; Define the cell renderer interface and implement multiple cell rendering methods through specific cell renderers; Implement the cell renderer interface using multiple types of cell renderers; Add the PrintAreas property and define the public voidReCalSizeAndPageInfo() method in the ReportData class, add the print controller class ReportPrintController, and the table display component ReportPreviewer; Define the cell editor interface and implement multiple cell editing methods through specific cell editors; Implement the cell editor interface using multiple types of cell editors; In the table display component ReportPreviewer, respond to the mouse double-click event and parse it into a cell double-click event. According to the cell properties, select the corresponding cell editor, initialize the corresponding cell editor, call the StartEdit method of the cell editor, enter the cell editing, respond to the editor exit event, call the EndEdit method of the cell editor, end the cell editing, and write the editor's editing results back to the cell properties. Add methods in ReportPreviewer to perform various preset operations on the table template data, add the WinfForm window FormDesign, embed the ReportPreviewer component, and implement the call of table operations through the menu bar and toolbar on the window.

8. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein: When the processor executes the program, it implements the method for constructing a construction quality inspection and evaluation system based on a dynamic form as described in any one of claims 1 to 6.

9. A non-transitory computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the method for constructing a construction quality inspection and evaluation system based on a dynamic form as described in any one of claims 1 to 6 is implemented.

Images