Intelligent management system for water conservancy project construction plans and construction organization design method

Abstract

The present invention discloses an intelligent management system for water conservancy project construction plans, including a client installed in a local computer Windows system and a server installed in a server, wherein the client includes a desktop and a WEB client; a VSTO plug-in is used to embed the desktop client into Word or WPS; the desktop client has the functions of creating, opening, editing and saving new construction group documents; the server has a database and a template library, and the template library is used to store construction group template documents pre-made by users. The present invention also discloses a corresponding construction organization design method. The present invention can effectively reuse the content of historical construction group documents, and the results of one compilation work can be conveniently reused in subsequent projects, thereby improving the efficiency and consistency of compiling construction organization design documents, and solving problems such as inconsistent content formats, large compilation workload, confusing node levels, inconsistent expressions of repeated content, inconsistent node dates and difficulty in modification, and time-consuming and labor-intensive formula input.

Description

Technical Field

[0001] The present invention relates to the field of engineering technology, and in particular to an intelligent management system and method for water conservancy project construction plans. Background Art

[0002] The preparation of a construction organization design is a highly technical and comprehensive task. Manual preparation is time-consuming and labor-intensive, with a high degree of repetitive work, resulting in low efficiency. The calculations are prone to errors after repeated revisions, and previously prepared construction organization designs cannot be effectively reused.

[0003] The preparation of construction organization design is usually time-sensitive and requires overtime work. The quality of the construction organization documents prepared in this way is difficult to guarantee, which brings hidden dangers to the subsequent actual construction. The management of company and project technical data is chaotic, and the compilation content basically adopts traditional technology. It takes a long time to incorporate new technologies and new processes, which is difficult to meet the time requirements. It is also easy to have chaotic and inconsistent node levels (layers), inconsistent expression of essentially repeated content when it appears repeatedly in various places in the construction group documents, and it is impossible to quickly locate the parts of the construction group documents that need to be modified; node dates are inconsistent and difficult to modify (for example, the project has a certain node date such as the scheduled completion date, and the node date appears in many places in the construction group documents. When the node date needs to be modified, manual modification often has omissions, resulting in inconsistent node dates), inaccurate time span calculations (and inconsistent expression formats), time-consuming and labor-intensive formula input, errors caused by manual input and repeated modifications of the statistical calculation part of the construction group documents, and cumbersome external file operation processes and low automation processing capabilities. These problems have resulted in the current preparation of construction organization designs failing to spread advanced technologies (incorporating advanced technologies consumes too much time and manpower), reduce human resource consumption, and greatly limit their guiding role in actual construction. Summary of the Invention

[0004] The purpose of the present invention is to address the problems in the prior art and provide an intelligent management system for water conservancy project construction plans to solve the problems of repeated content, repeated Word and WPS software operations, cumbersome calculations, lack of reference materials, difficulty in unifying content formats, large differences in preparation quality, low efficiency and waste of human resources in the process of construction organization design preparation, so as to improve the efficiency and standardization of preparation of construction organization design documents (i.e., construction group documents).

[0005] To achieve the above objectives, the present invention provides an intelligent management system for water conservancy project construction plans, in which the construction organization is referred to as the construction group; the system includes a client installed in the local computer Windows system and a server installed in the server.

[0006] The client includes a desktop client and a web client running in a browser. Both the desktop client and the web client are connected to the server through the HTTP protocol.

[0007] The desktop client is embedded into Word or WPS using VSTO plug-in; the desktop client has the functions of creating, opening, editing and saving new implementation group documents;

[0008] The server has a database and a template library. The template library is used to store user-prepared application template documents.

[0009] Databases include SqlServer database and ElasticSearch database;

[0010] SqlServer database includes SZBasic database and SZData database;

[0011] The ElasticSearch database includes the moduledata database;

[0012] The SZBasic database is used to store basic tables related to system operation, including user data, role data, department data, data permission data, operation permission data, dictionary, and process data related to the general management system;

[0013] The SZData database is used to store business data related to the implementation group data, including implementation group classification data, implementation group directory data, implementation group module data, and document template data. The implementation group module data is a document fragment created by the user for later use.

[0014] The moduledata database is used to store module data documents related to the application group data, which contains text extracted from historical application group documents;

[0015] The desktop client stores module data selected by the user for generating the application group document. The desktop client includes an application group parameterization module, a parameterization parsing module, and a document generation module.

[0016] The service program modules on the server side include file data receiving and structure checking module, duplication rate checking module, database storage module and big data search module;

[0017] The construction group parameterization module is used to perform parameterization conversion on the document content of the existing construction group documents, and to replace the relevant information of a specific project with parameters to produce more universal construction group module data;

[0018] The file data receiving and structure checking module is used to receive the file data generated by the parameterization module of the application group and perform structure checking on the received file data;

[0019] The duplication rate check module is used to check the duplication rate between the current document data and the historical document data;

[0020] The database storage module is used to store the data with qualified repetition rate into the corresponding database according to the data type;

[0021] The big data search module is used to respond to search requests from desktop clients or web clients and find the module data of the search request in the database;

[0022] The parameterized parsing module is used to respond to the command of the desktop client user to generate the application group document, generate corresponding content according to the parameterized attributes of the parameterized content control contained in the text node in the current document structure, and insert the generated content into the location of the parameterized content control in the current document, so that the generated content becomes an integral part of the application group document;

[0023] The document generation module is used to generate the final construction organization design document.

[0024] The parameterized module of the application group includes a filling text parameterized submodule, a calculation number parameterized submodule, a date parameterized submodule, an arithmetic operation parameterized submodule, a date operation parameterized submodule, a function operation parameterized submodule, an aggregation operation parameterized submodule and a JS script operation parameterized submodule;

[0025] The fill text parameterization submodule is used to generate a fill text parameter content control in the application group document node;

[0026] The calculation number parameterization submodule is used to generate the calculation number parameter content control in the application group document node;

[0027] The date parameterization submodule is used to generate date parameter content controls in the application group document node;

[0028] The arithmetic operation parameterization submodule is used to generate arithmetic operation parameter content controls in the application group document node;

[0029] The date operation parameterization submodule is used to generate the date operation parameter content control in the application group document node;

[0030] The function operation parameterization submodule is used to generate function operation parameter content controls in the application group document node;

[0031] The aggregation operation parameterization submodule is used to generate the aggregation operation parameter content control in the application group document node;

[0032] The JS script operation parameterization submodule is used to generate the JS script operation parameter content control in the application group document node;

[0033] The parameterized parsing module includes a filling text parameter parsing submodule, a calculation number parameter parsing submodule, a date parameter parsing submodule, an arithmetic operation parameter parsing submodule, a date operation parameter parsing submodule, a function operation parameter parsing submodule, an aggregation operation parameter parsing submodule and a JS script operation parameter parsing submodule;

[0034] (1) Filling text parameter parsing submodule:

[0035] The fill text parameter parsing submodule is used to process the fill text parameter content control in the application group document and fill in the text at the application group document location where the fill text parameter content control is located;

[0036] In the fill text parameter parsing submodule, fill text parameters include two types: system defined and user defined;

[0037] System-defined parameters include marker placeholder parameters and text content parameters that appear repeatedly in construction organization documents;

[0038] Marking a placeholder parameter is used to instruct the user to fill in the content of this part and provide a quick location function in the system's parameter list. The user can jump to the parameter location by marking the placeholder parameter to fill in or modify the content.

[0039] Fill-in text parameters other than the marked placeholder parameters are repetitive content parameters. The text content parameters in the system-defined parameters are used to reduce the number of user-defined fill-in text parameters, thereby improving the uniformity of the content of the application group document. When the system-defined parameters cannot meet the needs, users can use user-defined fill-in text parameters to eliminate the need for repeated manual filling of the corresponding repetitive fill-in text content. User-defined fill-in text parameters are only counted once in the parameter list. After the user fills in the content once in the parameter list, the content of the parameter is uniformly applied during the parameter parsing process.

[0040] (2) Calculation number parameter parsing submodule:

[0041] The calculation number parameter parsing submodule is used to process the calculation number parameter content control in the application group document. It fills in the number according to the document module structure at the application group document location where the calculation number parameter content control is located, and avoids human errors caused by manual input and repeated modifications, thereby realizing automatic calculation of module data.

[0042] The calculation number parameter parsing submodule automatically adopts the corresponding calculation rules and generates the number parameters according to the number level of the position of the number parameterized content control determined by the parent node and the increase level during the parsing process;

[0043] (3) Date parameter parsing submodule:

[0044] The date parameter parsing submodule is used to process the date parameter content control in the application group document, fill in the date in the application group document where the date parameter content control is located, and avoid human errors caused by manual input and repeated modifications, so as to realize automatic calculation of module data; date parameter content controls with the same date have the same unique value; date parameter parsing is performed before applying the application group template document format;

[0045] (IV) Arithmetic operation parameter parsing submodule:

[0046] The function of the arithmetic operation parameter parsing submodule is to process the arithmetic operation parameter content control in the application group document, fill in the corresponding formula and calculation result in the application group document where the arithmetic operation parameter content control is located, and avoid human errors caused by manual input and repeated modification, and automatically realize module data calculation;

[0047] The attributes of an arithmetic operation parameter contain members and results;

[0048] The arithmetic operation parameters of the same formula have the same unique value, and the arithmetic operator is saved in the arithmetic operation parameter whose attribute is the result;

[0049] When parsing arithmetic operation parameters, the arithmetic operation parameter parsing submodule first searches for the arithmetic operation parameter content control in the content of the group document node, and groups the arithmetic operation parameter content controls according to the unique values ​​of the arithmetic operation parameter content control attributes, and groups the arithmetic operation parameter content controls with the same unique values ​​into one group;

[0050] Before applying the template document format, the result of the arithmetic operation contains a format string, which outputs the result generated by the user's operation into a specified text format according to the predetermined output precision.

[0051] (V) Date operation parameter parsing submodule:

[0052] The function of the date operation parameter parsing submodule is to process the date operation parameter content control in the application group document, calculate the time span, avoid errors caused by manual calculation, and fill in the calculation results at the location of the date operation parameter content control in the application group document;

[0053] The date operation parameters include date operand 1, date operand 2, and the result; the result is the number of days between the date represented by date operand 1 and the date represented by date operand 2;

[0054] The date operands corresponding to the same date are identified by the same unique value;

[0055] Date operation parameters are displayed in one row in the parameter list for the same operation;

[0056] The parameter list allows you to quickly locate the location of the parameter control in the application group document. The date operation parameters are parsed before the application group template document format is applied.

[0057] (6) Function operation parameter parsing submodule:

[0058] The function operation parameter parsing submodule is used to process the function operation parameter content control in the application group document and fill in the corresponding formula at the application group document location where the function operation parameter content control is located;

[0059] The parameterized properties of a function operation include the function's parameters. The user enters the corresponding value for each function operation parameter. During the parsing process, the document processing program first starts a process in the background to output the formula content to the application group document, then replaces the parameters to complete the calculation, and saves the resulting temporary file and inserts it into the location of the function operation parameter content control as part of the application group document. The parsing of the function operation parameters occurs before applying the application group template document format.

[0060] (VII) Aggregation operation parameter parsing submodule:

[0061] The function of the aggregation operation parameter parsing submodule is to process the aggregation operation parameter content control in the application group document and fill in the corresponding parsing result at the application group document location where the aggregation operation parameter content control is located;

[0062] Aggregate operation parameters include operand parameters and result parameters;

[0063] The operand parameters of the aggregation operation parameters include multiple operand parameter controls; the operation rules of the aggregation operation are pre-stored in the result parameter content control; the aggregation operation parameter parsing submodule finds all relevant operand parameters according to the unique value attribute of the result parameter during the process of parsing and generating the application group document and applies the calculation rules pre-stored in the result parameter content control to generate the final operation result; the parameterized parsing of the aggregation operation is performed before applying the application group template document format;

[0064] (8) JS script operation parameter parsing submodule:

[0065] The function of the JS script operation parameter parsing submodule is to process the JS script operation parameter content control in the application group document and fill in the corresponding parsing results at the application group document location where the JS script operation parameter content control is located;

[0066] The JS script operation parameter parsing submodule executes the JavaScript script in the parameter attribute through the NodeJS module included with the VSTO plug-in; the VSTO plug-in is pre-installed with a script for importing external files, which automatically imports external file data and executes processing through the script;

[0067] The JS script operation parameter parsing submodule outputs the result of the script execution processing as text or image, and inserts it into the location of the JS script operation parameter content control in the current application group document as a component of the application group document content;

[0068] The parsing of Js script operation parameters occurs before the style template is applied to the document.

[0069] The numbering parameter generated by the calculation numbering parameter parsing submodule has an indentation attribute, which is used to determine the number of spaces at the beginning of the paragraph where the number is located;

[0070] The result of date operations provides date formatting options, which are used to format the date into the display format specified by the user.

[0071] In the parameter list, only one date parameter with the same unique value is listed, and date parameters with different unique values ​​are listed separately. By filling in the date in the date parameter list, the date parameter values ​​in all date parameter content controls in the application group document can be quickly replaced.

[0072] The present invention also discloses a construction organization design method using the above-mentioned intelligent management system for water conservancy project construction plans, which is characterized by being carried out in the following steps:

[0073] The first step is to create a template document for the implementation group;

[0074] The second step is to create a new implementation group document node and parameterize it;

[0075] The third step is to use the module data in the intelligent management system of water conservancy project construction plan to supplement and improve the construction group documents;

[0076] The fourth step is to generate the final construction organization document.

[0077] The first step is specifically: the user creates a template document for the application group in Word to standardize the application group document style; the user uploads the template document for the application group to the template library of the server for applying the template format in the fourth step;

[0078] The implementation group template documents include the bidding implementation group template documents and the implementation implementation group template documents;

[0079] The function of the construction group template document is to provide a structural template for combining nodes into a semi-finished construction group document of the construction organization design, thus reducing the workload of users to manually add content.

[0080] The data types of the application group template document node are divided into three types: plain text, Word document and module data ID;

[0081] The second step is to create a new document node with four attributes: no attribute, variable attribute, fixed attribute and fill attribute.

[0082] The node content with fixed attributes is independent of the general content of a type of construction organization design and does not require user supplementation;

[0083] The node content with variable attributes contains some common content that is independent of a type of construction organization design and does not need to be improved by the user. The user can improve the node content with variable attributes according to the specific conditions of the current project.

[0084] The node content of the filling attribute does not contain general content independent of a type of construction organization design. Users fill in the node content of the filling attribute according to the specific situation of the current project.

[0085] When a user creates a new application group document through the desktop client, the desktop client parses the nodes in the application group template document to generate text nodes;

[0086] The specific steps of parameterizing the application group document node are as follows: generating a fill text parameter content control in the application group document node by using the fill text parameterization submodule;

[0087] Generate a calculation number parameter content control in the application group document node using the calculation number parameterization submodule;

[0088] Use the date parameterization submodule to generate a date parameter content control in the application group document node;

[0089] The arithmetic operation parameterization submodule is used to generate an arithmetic operation parameter content control in the application group document node;

[0090] Use the date operation parameterization submodule to generate the date operation parameter content control in the application group document node;

[0091] Generate function operation parameter content control in the application group document node by using function operation parameterization submodule;

[0092] Generate aggregate operation parameter content control in the application group document node using aggregate operation parameterization submodule;

[0093] Generate JS script operation parameter content control in the application group document node by using JS script operation parameterization submodule;

[0094] The third step is specifically: after the second step is completed, the user uses the editing command to supplement the content of the application group document node;

[0095] (1) Checking the structure of the current document data through the file data receiving and structure checking module, and the user performing a duplication rate check on the current document that passes the inspection;

[0096] (2) Check the repetition rate of the current document data and the historical group documents through the repetition rate check module; the user stores the current document with qualified repetition rate into the database, specifically, the original document is stored in the SZData database and the extracted plain text is stored in the moduledata database;

[0097] More specifically, for documents that pass verification, all text is extracted from the document and compared against the plain text of existing documents in the database. For documents with a repetition rate exceeding a threshold, the user is prompted that a document with similar content already exists in the database and asked whether to insert the document. After the user chooses to insert the document, the document and the user-submitted form are first stored in the module data request process data table in the SZBasic database. After administrator approval, the document is stored in the module data table in the SZData database. At the same time, Aspose.Words is used to extract the full plain text from the document. Combined with the user-submitted form, a JSONDoc is generated and stored in the moduledata database of ElasticSearch.

[0098] (3) The user creates a new implementation group document through the desktop client and calls the completed data of each implementation group document node to complete the document;

[0099] (4) The user generates corresponding content through the parameterized parsing module based on the parameterized attributes of the parameterized content control contained in the text node in the current document structure, and inserts the generated content into the location of the parameterized content control in the current document, so that the generated content becomes a component of the document; the parameterized attributes are stored in the parameterized content control;

[0100] Specifically, it includes: using the fill text parameter parsing submodule to fill in the text parameters of the system-defined type and the user-defined text parameters in the group document position where the fill text parameter content control is located;

[0101] Use the calculation number parameter parsing submodule to fill in the number according to the document module structure at the location of the calculation number parameter content control;

[0102] Use the date parameter parsing submodule to fill in the date in the document where the date parameter content control is located;

[0103] Use the arithmetic operation parameter parsing submodule to fill in the corresponding formula and calculation results in the group document location where the arithmetic operation parameter content control is located;

[0104] Use the date operation parameter parsing submodule to fill in the calculated time span result at the location of the date operation parameter content control in the application group document;

[0105] Use the function operation parameter parsing submodule to fill in the corresponding formula in the document where the function operation parameter content control is located;

[0106] Use the aggregation operation parameter parsing submodule to fill in the corresponding parsing results in the location of the aggregation operation parameter content control in the application group document;

[0107] Use the JS script operation parameter parsing submodule to fill in the corresponding parsing results in the document location where the JS script operation parameter content control is located;

[0108] The fourth step is specifically: after the third step is completed, the user operates the desktop client to issue an apply style command to apply the style of the applied construction group template document to the current construction group document; the user generates the final construction organization design document through the document generation module.

[0109] The present invention has the following advantages:

[0110] To address the issue of confusing and inconsistent node levels (hierarchies), we can eliminate this by parameterizing the calculated numbers and providing user prompts during parameter parsing when the levels of the parent node and the child node are discontinuous.

[0111] The problem of inconsistent expression of repeated content is solved by parameterizing the filler text.

[0112] It is not possible to quickly locate the part of the implementation group document that needs to be modified. This problem can be solved by marking the placeholder parameters.

[0113] The problem of inconsistent node dates and difficulty in modifying them is solved by date parameterization. With date parameters, users can quickly select dates and uniformly replace dates that need to appear repeatedly in the module.

[0114] The problem of inaccurate time span calculation is solved by using date operation parameters to replace manual calculation with machine calculation.

[0115] The time-consuming and labor-intensive problem of formula input was solved by parameterizing function operations. Errors caused by manual input and repeated revisions in the statistical operations of the application group's documents were resolved by parameterizing aggregation operations.

[0116] The advantage of user-defined parameters is that after filling them out once, the same content can be reused in different parts of the implementation group document during the parameter parsing process, thereby improving the compilation speed and content uniformity of the implementation group document.

[0117] Although user-defined parameters also have the advantage of being easy to use and call repeatedly, for the same objective object, the parameters defined by different users are usually different, which results in differences in the content of the application group documents generated by different users; the text content parameters in the system-defined parameters can reduce user-defined parameters and improve the content uniformity of the application group documents generated by different users.

[0118] The present invention can effectively reuse the contents of historical construction organization documents, and the results of one compilation work can be conveniently reused in subsequent projects, thereby improving the efficiency and consistency of compiling construction organization design documents. BRIEF DESCRIPTION OF THE DRAWINGS

[0119] Figure 1 It is a structural diagram of the parameterized module of the application group;

[0120] Figure 2 It is a schematic diagram of the principle of the intelligent management system for water conservancy project construction plans;

[0121] Figure 3 It is a flow chart of the construction organization design method;

[0122] Figure 4 It is the system architecture diagram of the intelligent management system for water conservancy project construction plans. DETAILED DESCRIPTION

[0123] like Figures 1 to 4 As shown, the present invention discloses an intelligent management system for water conservancy project construction plans, in which the construction organization is referred to as the construction group. The system includes a client installed in the local computer's Windows system and a server installed in the server (both the client and the server are programs). The client includes a desktop client (computing power is provided by the local computer) and a web client running in a browser. Both the desktop client and the web client are connected to the server via the HTTP protocol and service. The desktop client is embedded in Word (i.e., Microsoft Word program) or WPS (i.e., Kingsoft WPS program) using a VSTO plug-in. The web client is developed using Vue3 technology. The desktop client has the functions of creating, opening, editing, and saving construction group documents.

[0124] The server has a database and a template library. The template library is used to store user-prepared application group template documents (application group template documents are used to standardize document styles and are used for formatting when generating application group documents).

[0125] Databases include SqlServer database and ElasticSearch database;

[0126] SqlServer database includes SZBasic database and SZData database;

[0127] The ElasticSearch database includes the moduledata database;

[0128] The SZBasic database is used to store basic tables related to system operation, including user data, role data, department data, data permission data, operation permission data, dictionary, and process data related to the general management system;

[0129] The SZData database is used to store business data related to the implementation group data, including implementation group classification data, implementation group directory data, implementation group module data, and document template data. The implementation group module data is a document fragment created by the user for later use.

[0130] The moduledata database is used to store module data documents related to the application group data, which contains text extracted from historical application group documents;

[0131] The desktop client stores module data selected by the user for generating the application group document. The desktop client includes an application group parameterization module, a parameterization parsing module, and a document generation module.

[0132] The service program modules on the server side include file data receiving and structure checking module, duplication rate checking module, database storage module and big data search module;

[0133] The construction group parameterization module is used to perform parameterization conversion on the document content of the existing construction group documents, and to replace the relevant information of a specific project with parameters to produce more universal construction group module data;

[0134] The file data receiving and structure checking module is used to receive the file data generated by the parameterization module of the application group and perform structure checking on the received file data;

[0135] The duplication rate check module is used to check the duplication rate between the current document data and the historical document data;

[0136] The database storage module is used to store the data with qualified repetition rate into the corresponding database according to the data type;

[0137] The big data search module is used to respond to search requests from desktop clients or web clients and find the module data requested by the search (i.e., the module data required by the user) in the database;

[0138] The parameterized parsing module is used to respond to the command of the desktop client user to generate the application group document, generate corresponding content according to the parameterized attributes of the parameterized content control contained in the text node in the current document structure, and insert the generated content into the location of the parameterized content control in the current document, so that the generated content becomes an integral part of the application group document;

[0139] The document generation module is used to generate the final construction organization design document (i.e. construction group document).

[0140] The parameterized module of the application group includes a filling text parameterized submodule, a calculation number parameterized submodule, a date parameterized submodule, an arithmetic operation parameterized submodule, a date operation parameterized submodule, a function operation parameterized submodule, an aggregation operation parameterized submodule and a JS script operation parameterized submodule;

[0141] The fill text parameterization submodule is used to generate a fill text parameter content control in the application group document node;

[0142] The calculation number parameterization submodule is used to generate the calculation number parameter content control in the application group document node;

[0143] The date parameterization submodule is used to generate date parameter content controls in the application group document node;

[0144] The arithmetic operation parameterization submodule is used to generate arithmetic operation parameter content controls in the application group document node;

[0145] The date operation parameterization submodule is used to generate the date operation parameter content control in the application group document node;

[0146] The function operation parameterization submodule is used to generate function operation parameter content controls in the application group document node;

[0147] The aggregation operation parameterization submodule is used to generate the aggregation operation parameter content control in the application group document node;

[0148] The JS script operation parameterization submodule is used to generate the JS script operation parameter content control in the application group document node;

[0149] The parameterized parsing module includes a filling text parameter parsing submodule, a calculation number parameter parsing submodule, a date parameter parsing submodule, an arithmetic operation parameter parsing submodule, a date operation parameter parsing submodule, a function operation parameter parsing submodule, an aggregation operation parameter parsing submodule and a JS script operation parameter parsing submodule;

[0150] (1) Filling text parameter parsing submodule:

[0151] The fill text parameter parsing submodule is used to process the fill text parameter content control in the application group document and fill in the text at the application group document location where the fill text parameter content control is located;

[0152] In the fill text parameter parsing submodule, fill text parameters include two types: system defined and user defined;

[0153] System-defined parameters include marker placeholder parameters and text content parameters that appear repeatedly in construction organization documents (i.e., construction group documents);

[0154] Marked placeholder parameters usually appear multiple times in the document module structure list, and the content is usually not repetitive. Marked placeholder parameters are used to instruct users to fill in the content of this part and provide a quick positioning function in the system's parameter list (i.e., quickly locate the corresponding part of the application group document based on the marked placeholder parameter, and fill in the content of this part by the end user). Users can jump to the parameter location by marking the placeholder parameter to fill in or modify the content;

[0155] The fill-in text parameters other than the mark placeholder parameters are repetitive content parameters. The text content parameters in the system-defined parameters are used to reduce user-defined fill-in text parameters to improve the uniformity of the content of the implementation group documents; (although user-defined parameters also have the advantage of being easy to use and call repeatedly, for the same objective object, the parameters defined by different users are usually different, which results in differences in the content of the implementation group documents generated by different users; the text content parameters in the system-defined parameters can reduce user-defined parameters and improve the content uniformity of the implementation group documents generated by different users) When the system-defined parameters cannot meet the needs, the user uses user-defined fill-in text parameters to make the corresponding repetitive fill-in text content do not need to be repeatedly filled in manually; user-defined fill-in text parameters are only counted once in the parameter list, and after the user fills in the content once in the parameter list, the content of the parameter is uniformly applied during the parameter parsing process; (the advantage of user-defined parameters is that after filling in once, the same content can be reused in different parts of the implementation group document during the parameter parsing process, thereby improving the compilation speed and content uniformity of the implementation group document)

[0156] (2) Calculation number parameter parsing submodule:

[0157] The calculation number parameter parsing submodule is used to process the calculation number parameter content control in the application group document. It fills in the number according to the document module structure at the application group document location where the calculation number parameter content control is located, and avoids human errors caused by manual input and repeated modifications, thereby realizing automatic calculation of module data.

[0158] The most commonly used number is the number before the paragraph. The text node, as a child node of the title node, needs to determine its own number based on the number of the parent node.

[0159] The increase level attribute of the document node is used to determine the level increased from the parent node. If the level of the parent node and the level of the child node are not continuous, the user needs to be prompted during the parameter parsing process. For example, a highlighted text can be generated after the numbered parameter content control to prompt the user.

[0160] The numbering rules used in a complete construction organization document (i.e., construction group document) are unified. The numbering calculation rules for the numbering parameters are determined according to the rules defined in the construction group document outline numbering window. They can be pre-defined in the template file or system database, or customized by the user.

[0161] The calculation number parameter parsing submodule automatically adopts the corresponding calculation rules and generates the number parameters according to the number level of the position of the number parameterized content control determined by the parent node and the increase level during the parsing process;

[0162] Specifically, the numbering parameter generates the document number according to the calculation number content control combined with the numbering rules; the input parameters of the calculation number parameter parsing submodule are the parent node ID and the level to be increased in the numbering parameter; during parsing, the calculation number parameter parsing submodule first calculates the CascadeId of all title-only nodes in the document structure of the application group (the composition of the CascadeId is that the root node is numbered ".0." starting from 0, and the subsequent levels are numbered starting from 1, such as the level 1 title is numbered ".0.1.", and so on). The parsing module finds the CascadeId of the parent node based on the numbering parameter Id, and then finds the matching regular expression of the rule corresponding to this level in the application group document numbering rule, calculates the matching result and appends the increased level as the CascadeId of the current numbering parameter. If the increased level is greater than 1, the CascadeId of the numbering parameter in the previous level content control needs to be used as the starting CascadeId for calculation. The final CascadeId segment to be used as the number is determined by calling the replacement expression in the numbering rule. The parsing module then applies different conversion rules to the segment to generate a number, and uses the generated number as the output result. Finally, the output result is used to replace the Range text where the content control is located as the number.

[0163] (3) Date parameter parsing submodule:

[0164] The date parameter parsing submodule is used to process the date parameter content control in the application group document, fill in the date in the application group document where the date parameter content control is located, and avoid human errors caused by manual input and repeated modifications, so as to realize automatic calculation of module data; date parameter content controls with the same date have the same unique value; date parameter parsing is performed before applying the application group template document format;

[0165] Through the date parameter, users can quickly select dates and uniformly replace dates that need to appear repeatedly in the module;

[0166] (IV) Arithmetic operation parameter parsing submodule:

[0167] The function of the arithmetic operation parameter parsing submodule is to process the arithmetic operation parameter content control in the application group document, fill in the corresponding formula and calculation result in the application group document where the arithmetic operation parameter content control is located, and avoid human errors caused by manual input and repeated modification, and automatically realize module data calculation;

[0168] The attributes of an arithmetic operation parameter contain members and results;

[0169] Supported operators include conventional operators such as addition, subtraction, multiplication, and division. Arithmetic operation parameters of the same formula have the same unique value, and the arithmetic operator is stored in the arithmetic operation parameter whose attribute is the result.

[0170] When parsing arithmetic operation parameters, the arithmetic operation parameter parsing submodule first searches for the arithmetic operation parameter content control in the content of the group document node, and groups the arithmetic operation parameter content controls according to the unique values ​​of the arithmetic operation parameter content control attributes, and groups the arithmetic operation parameter content controls with the same unique values ​​into one group;

[0171] Before applying the template document format, the result of the arithmetic operation contains a format string, which outputs the result generated by the user's operation into a specified text format according to the predetermined output precision.

[0172] When the user searches for a result parameter, the arithmetic operation parameter parsing submodule searches for the corresponding arithmetic member parameter based on the unique value of the result parameter, calculates the corresponding result based on the value entered by the user in the member parameter control, and automatically fills it in the document control of the result parameter.

[0173] The arithmetic operation parameter parsing submodule generates a settlement result according to the calculation rules defined by the user in the result control; the input parameter of the arithmetic operation parameter parsing submodule during parsing is a group of arithmetic parameter content controls;

[0174] The detailed parsing process is as follows: the arithmetic parameter parsing submodule first divides the group of content controls into different groups based on the unique values ​​of the arithmetic parameters, with each group serving as a calculation unit; distinguishes the result parameters and member parameters from the group based on the arithmetic parameter attribute enumeration value; traverses the values ​​of the "variable name" attribute field in the member parameters and uses "," to split and combine them into a string; this string serves as the formal parameter of the JavaScript function; then, using the same method, the values ​​entered in the parameter content controls are combined into a string as the actual parameter for calling the JavaScript function; to prevent implicit conversion of parameter types during script execution from causing calculation errors, the function is packaged in a parameterless function, and the parameterized function is called from within the parameterless function and the execution result of the internal function is returned. Use Microsoft.ClearScript to generate a dynamic script function and execute it; the result of the function execution is used as the Range text of the result parameter control.

[0175] (V) Date operation parameter parsing submodule:

[0176] The function of the date operation parameter parsing submodule is to process the date operation parameter content control in the application group document, calculate the time span, avoid errors caused by manual calculation, and fill in the calculation results at the location of the date operation parameter content control in the application group document;

[0177] The date operation parameters include date operand 1, date operand 2, and the result; the result is the number of days between the date represented by date operand 1 and the date represented by date operand 2;

[0178] The date operands corresponding to the same date are identified by the same unique value;

[0179] The result content control of a date operation contains operation operators for time span operations. Date operation parameters are displayed in a row in the parameter list for the same operation.

[0180] The parameter list allows you to quickly locate the location of the parameter control in the application group document. The date operation parameters are parsed before the application group template document format is applied.

[0181] (6) Function operation parameter parsing submodule:

[0182] The function operation parameter parsing submodule is used to process the function operation parameter content control in the application group document and fill in the corresponding formula at the application group document location where the function operation parameter content control is located;

[0183] The properties of a parameterized function operation include the function's parameters. The user enters the corresponding value for each function operation parameter. During the function parameter parsing process, the document processing program (such as Microsoft Word or WPS) first starts a process in the background to output the formula content to the application group document, then replaces the parameters to complete the calculation, and saves the resulting temporary file and inserts it into the location of the function operation parameter content control as part of the application group document. The function operation parameters are parsed before the application group template document format is applied.

[0184] (VII) Aggregation operation parameter parsing submodule:

[0185] The function of the aggregation operation parameter parsing submodule is to process the aggregation operation parameter content control in the application group document and fill in the corresponding parsing result at the application group document location where the aggregation operation parameter content control is located;

[0186] Aggregate operation parameterization is used to generate statistical operations in group documents, reducing errors that may occur due to manual input and multiple modifications.

[0187] Aggregate operation parameters include operand parameters and result parameters;

[0188] The operand parameters of the aggregation operation parameters include multiple operand parameter controls; the calculation rules of the aggregation operation are pre-stored in the result parameter content control; the result parameter content control provides a variety of existing and commonly used aggregation operation rules. During the process of parsing and generating the application group document, the aggregation operation parameter parsing submodule finds all relevant operand parameters based on the unique value attribute of the result parameter and applies the calculation rules pre-stored in the result parameter content control to generate the final operation result; the parameterized parsing of the aggregation operation is performed before applying the application group template document format;

[0189] In this embodiment, the aggregation operation parameter parsing submodule calculates and completes the filling of the table statistical values ​​based on the values ​​of multiple content controls in the aggregation operation parameter group. The function operation parameter parsing submodule has built-in a series of formulas commonly used in construction organization design, such as the calculation formula for concrete mix ratio. The input parameters of the aggregation operation parameter parsing submodule parameter parsing are the values ​​of the relevant parameters in the formula and the formula selected by the user; the result calculated by the aggregation operation parameter parsing submodule is output as a temporary Word document, and finally the VSTO plug-in inserts the content of the temporary document into the position of the aggregation operation parameter content control as part of the overall construction group document.

[0190] (8) JS script operation parameter parsing submodule:

[0191] The JS script operation parameter parsing submodule is used to process the JS script operation parameter content control in the application group document and fill in the corresponding parsing result (the calculation result is text and / or image) at the application group document location where the JS script operation parameter content control is located;

[0192] The purpose of parameterizing JS script operations is to improve the document automation processing capabilities of the application group, simplify the tedious external file operation process, and expand the functions of the VSTO plug-in;

[0193] The JS script operation parameter parsing submodule executes the JavaScript script in the parameter attribute through the NodeJS module included with the VSTO plug-in; the VSTO plug-in is pre-installed with a script for importing external files, which automatically imports external file data and executes processing through the script;

[0194] The JS script operation parameter parsing submodule outputs the result of the script execution processing as text or image, and inserts it into the location of the JS script operation parameter content control in the current application group document as a component of the application group document content;

[0195] The parsing of Js script operation parameters occurs before the style template is applied to the document.

[0196] Users can choose to execute the scripts preset in the VSTO plug-in, or write their own script content to be executed. The content in the JS script operation parameter content control is inserted into the document of the application group. Users can choose to insert it as plain text, as a text paragraph, or as an image. During the process of parsing the parameters of the application group document, the VSTO plug-in will execute the script code in the Js script operation parameter and output the result of the script operation as text or image. Finally, it will merge the content to the location of the Js script operation parameter control. After parsing, the current script parameter control will be deleted from the document. The Js script operation parameter can be quickly located by double-clicking the mouse in the parameter list.

[0197] Specifically, in this embodiment, JS script operation parameters are executed by NodeJS to call external file operations to complete the call of xlsx, cad, and other files. The data generated by the call is inserted into the application group document as text or images as the result of the operation. The input parameters of the JS script operation parameter parsing submodule are the JS script to be executed, the location of the file to be operated, and the area of ​​the Excel file content. The output content of the JS script operation parameter parsing submodule is a text or image file. Ultimately, the VSTO plug-in inserts the generated content into the application group document as part of the application group document.

[0198] The numbering parameter generated by the calculation numbering parameter parsing submodule has an indentation attribute, which is used to determine the number of spaces at the beginning of the paragraph where the number is located;

[0199] The implementation of the numbering indent property requires applying the style template to the document. The indent value calculated using the numbering parameter must be called to set the paragraph indent. Therefore, the numbering parameterized content control cannot be deleted after parsing is complete. The implementation of the paragraph indentation calculated using the numbering parameter should be implemented after the style template is applied to the entire document. Only then can the numbering parameterized content control be deleted from the document.

[0200] The result of date operations provides date formatting options, which are used to format the date into a user-specified display format (such as year-month-day or day-month-year, Chinese characters or Arabic numerals).

[0201] In the parameter list, only one date parameter with the same unique value (date parameter in the date parameter parsing submodule) is listed, and date parameters with different unique values ​​are listed separately. By filling in the date in the date parameter list, the date parameter values ​​in all date parameter content controls in the application group document can be quickly replaced.

[0202] Specifically, the filling text parameter and date parameter generate a piece of text according to the value and format of the parameter management module; the input parameter of the parameter parsing is the parameterized content control to be parsed currently, and the parsing process is to find the value entered by the user in the filling option window, apply the formatting string rules attached to the parameterized control to generate the string as the output result, and finally use the output result as the Range text of the current content control.

[0203] The present invention also discloses a construction organization design method using the above-mentioned intelligent management system for water conservancy project construction plans, which is carried out in the following steps:

[0204] The first step is to create a template document for the implementation group;

[0205] The second step is to create a new implementation group document node and parameterize it;

[0206] The third step is to use the module data in the intelligent management system of water conservancy project construction plan to supplement and improve the construction group documents;

[0207] The fourth step is to generate the final construction organization document (construction group document).

[0208] The first step is specifically: the user creates a template document for the application group in Word to standardize the application group document style; the user uploads the template document for the application group to the template library of the server for applying the template format in the fourth step;

[0209] The implementation group template documents include the bidding implementation group template documents and the implementation implementation group template documents;

[0210] The function of the construction group template document is to provide a structural template for combining nodes into a semi-finished construction group document of the construction organization design, thus reducing the workload of users to manually add content.

[0211] Administrators can create multiple templates for group template documents. The node data types are divided into three types: plain text, Word document, and module data ID.

[0212] The second step is to create a new document node with four attributes: no attribute, variable attribute, fixed attribute and fill attribute.

[0213] The node content with fixed attributes is independent of the general content of a type of construction organization design and does not require user supplementation;

[0214] The content of nodes with variable attributes contains some common content that is independent of a type of construction organization design and does not require user completion. Users can complete the content of nodes with variable attributes based on the specific circumstances of the current project. The flexibility of node content with variable attributes is greater than that of node content with fixed attributes and less than that of node content with filler attributes.

[0215] The node content of the filling attribute does not contain general content independent of a type of construction organization design. Users fill in the node content of the filling attribute according to the specific situation of the current project.

[0216] When a user creates a new application group document through the desktop client, the desktop client parses the nodes in the application group template document to generate text nodes;

[0217] The specific steps of parameterizing the application group document node are as follows: generating a fill text parameter content control in the application group document node by using the fill text parameterization submodule;

[0218] Generate a calculation number parameter content control in the application group document node using the calculation number parameterization submodule;

[0219] Use the date parameterization submodule to generate a date parameter content control in the application group document node;

[0220] The arithmetic operation parameterization submodule is used to generate an arithmetic operation parameter content control in the application group document node;

[0221] Use the date operation parameterization submodule to generate the date operation parameter content control in the application group document node;

[0222] Generate function operation parameter content control in the application group document node by using function operation parameterization submodule;

[0223] Generate aggregate operation parameter content control in the application group document node using aggregate operation parameterization submodule;

[0224] Generate JS script operation parameter content control in the application group document node by using JS script operation parameterization submodule;

[0225] like Figure 2 As shown, the intelligent management system for water conservancy project construction plans of the present invention includes a parameterized construction group module. After creating a corresponding parameter content control in a document by creating a parameter panel, the corresponding parameter composition details are adjusted using parameter attributes. Finally, the prepared part is separated from the original document as a separate file by separating the selected block. The data that does not contain the outline and text structure is treated as text data, and the file containing outline nodes and text can be treated as tree nodes.

[0226] The third step is specifically: after the second step is completed, the user uses the editing command to supplement the content of the application group document node;

[0227] (1) Checking the structure of the current document data through the file data receiving and structure checking module, and the user performing a duplication rate check on the current document that passes the inspection;

[0228] After uploading the separated module files to the server through the web client, the document structure is verified. Word documents include doc and docx formats. Since the document formats supported by Word and WPS are different, WPS documents saved by WPS cannot be opened using Word. Therefore, the server converts the documents uploaded by users into a format compatible with both office software. This step uses Aspose.Words (Aspose.Words is an advanced class library that can perform various document processing tasks in various applications and supports formats such as DOC. It does not require the Word program to open it) to convert the documents into a docx format that is compatible with both office software, Word and WPS. Aspose.Words extracts the document's outline node hierarchy level to verify whether it meets the node continuity requirements.

[0229] (2) Check the repetition rate of the current document data and the historical group documents through the repetition rate check module; the user stores the current document with qualified repetition rate into the database, specifically, the original document is stored in the SZData database and the extracted plain text is stored in the moduledata database;

[0230] More specifically, for documents that pass verification, all text is extracted from the document and compared against the plain text of existing documents in the database. For documents with a repetition rate exceeding a threshold, the user is prompted that a document with similar content already exists in the database and asked whether to insert the document. After the user chooses to insert the document, the document and the user-submitted form are first stored in the module data request process data table in the SZBasic database. After administrator approval, the document is stored in the module data table in the SZData database. At the same time, Aspose.Words is used to extract the full plain text from the document. Combined with the user-submitted form, a JSONDoc is generated and stored in the moduledata database of ElasticSearch.

[0231] like Figure 2 As shown, the intelligent management system for water conservancy project construction plans of the present invention includes a database storage module. When a document is executed to store in the database, the module data is first saved in the SqlServer database in order to be able to quickly retrieve the module data later.

[0232] A Json document is constructed based on the module data GUID (globally unique identifier) ​​returned by the database and the file name, keywords, user name, file plain text, category, and directory in the module data information. The document is then transferred to the ElasticSearch database through the NestJs framework. The relevant text Json document field content is segmented using IKMaxword using IK Analyzer (a Chinese word segmentation toolkit developed based on JAVA) and saved in the index library corresponding to the module data.

[0233] The original document data also needs to be stored in the database. Saving the file directly as vbinary data in the SQL Server database would cause the table size to be too large. Therefore, it is recommended to store the file as binary data in a separate table. This table uses the same GUID as the module data information table. This way, when the original file data needs to be retrieved, the GUID can be used to quickly locate the original module data and return it to the requester (desktop client or web client).

[0234] (3) The user creates a new implementation group document through the desktop client and calls the completed implementation group document node data to complete the document; during the completion process, the user finds the module data the user needs through the big data search module;

[0235] like Figure 2As shown, the intelligent management system for water conservancy project construction plans of the present invention includes a big data search module. The purpose of the big data search module is to quickly find the module data required by the user through the client or web client, in order to find the data that meets the needs faster and more accurately.

[0236] First, the data should be classified according to public categories and professional public categories. In this embodiment, public categories and categories such as construction engineering, municipal engineering, water conservancy engineering and highway engineering are provided, and the use of more categories in specific professional engineering categories is not excluded.

[0237] Categories provide the functions of adding, deleting, modifying and searching, and users can perform various management functions on categories. A corresponding tree-shaped directory index is set under each category.

[0238] After a user enters a keyword through a desktop or web client, the server performs a search by segmenting the keyword. The user's request also includes the module catalog requested. The server uses ElasticSearch full-text search to first determine the search scope based on the module catalog, then performs a segmentation search to find the corresponding results. The server then highlights the found fields before returning the results to the requesting client.

[0239] When the user requests to insert the found module data into the document structure list, for text-type data, the desktop client directly parses the module data into a text-type node and inserts it under the title node selected by the user. For tree nodes, the client needs to parse the module data into a collection of title nodes and text nodes, and then insert all of them under the title node selected by the user. The client divides the module data into several RangeScopes based on the document location of the outline node. For RangeScopes that serve as outline nodes, they are parsed into title nodes. For RangeScopes that are not outline nodes, they are parsed into text nodes. Then, through a recursive loop, all nodes are inserted under the title node selected by the user as child nodes of the current node.

[0240] (4) The user generates corresponding content through the parameterized parsing module based on the parameterized attributes of the parameterized content control contained in the text node in the current document structure, and inserts the generated content into the location of the parameterized content control in the current document, so that the generated content becomes a component of the document; the parameterized attributes are stored in the parameterized content control;

[0241] When the user issues a generate command, the client generates corresponding content by calling the parameterized parsing module and combining the properties in the parameterized content control, and inserts the content into the location of the content control to become a part of the document.

[0242] For a single content control parameter, the client only needs to process the property data stored in the current content control to generate the content. For multiple content control parameters, the client first needs to group the parameterized controls according to their unique value properties, and then read and parse the data stored in multiple content controls to generate the document content.

[0243] Among them, the identification of various parameters and related information is to serialize the parameter class into a Json string and save it in the Tag property of the content control, and identify the internal information through serialization and deserialization.

[0244] Specifically, it includes: using the fill text parameter parsing submodule to fill in the text parameters of the system-defined type and the user-defined text parameters in the group document position where the fill text parameter content control is located;

[0245] Use the calculation number parameter parsing submodule to fill in the number according to the document module structure at the location of the calculation number parameter content control;

[0246] Use the date parameter parsing submodule to fill in the date in the document where the date parameter content control is located;

[0247] Use the arithmetic operation parameter parsing submodule to fill in the corresponding formula and calculation results in the group document location where the arithmetic operation parameter content control is located;

[0248] Use the date operation parameter parsing submodule to fill in the calculated time span result (in days) at the location of the date operation parameter content control in the application group document;

[0249] Use the function operation parameter parsing submodule to fill in the corresponding formula in the document where the function operation parameter content control is located;

[0250] Use the aggregation operation parameter parsing submodule to fill in the corresponding parsing results in the location of the aggregation operation parameter content control in the application group document;

[0251] Use the JS script operation parameter parsing submodule to fill in the corresponding parsing results (the calculation results are text and / or pictures) in the application group document location where the JS script operation parameter content control is located;

[0252] The fourth step is specifically: after the third step is completed, the user operates the desktop client to issue an apply style command to apply the style of the applied construction group template document to the current construction group document; the user generates the final construction organization design document (i.e., construction group document) through the document generation module.

[0253] like Figure 2As shown, the intelligent management system for water conservancy project construction plans of the present invention includes a document generation module. Document generation operations include generating selected nodes and subnodes, as well as generating all nodes. The purpose of generating selected nodes and subnodes is to reduce the length of generated content and help users check for possible errors in the current document. Generating selected nodes also parses parameterized items in the document.

[0254] If the generated content during parsing doesn't meet your expectations, you can edit the text node and save the edited content to the text node. Text and title nodes have a series of controllable properties that influence content generation. Generate All generates a complete Word document from the entire document node tree. Users can then perform various operations on the generated document to further improve its content.

[0255] Among them, the list of application group template documents is composed of template categories, and the node list stored in the application group template document is parsed into DevExpress TreeList; the nodes in the application group template document are parsed into corresponding title nodes and text nodes, and the server's detailed template definition TemplateDefine contains specific application group template document data;

[0256] The three forms of module data, plain text, Word document and module data ID, are parsed and unified into the format of the application group template document;

[0257] Each text node stores a Word document in docx format; the plain text module data is parsed into a Word document. Since using Word to integrate plain text into a Word document is inefficient and slow, in order to achieve faster conversion, the present invention uses the OpenXML method to split the plain text into text paragraphs and then insert them into a temporary document as paragraphs. Finally, the temporary document is saved to the memory and read into the ByteData field of the text node in the form of bytes, thereby greatly improving the speed of transfer and integration. The Word document and module data ID form is obtained by connecting to the server to obtain data online and save it to the text node.

[0258] The document node data of the Shi Group in the desktop client is saved to the local disk (hard disk) so that the user can open the document again at any time. The document saving function uses SqlSugar to save the node data in the structure list in the form of a table to the Sqlite database. The file also contains the Shi Group document node data table, document number table, document style table and user-filled text parameter table. The document number table stores the numbering method enumeration used for document numbering and the regular expression for number calculation. The document style table stores the document style template selected by the user, and the user-filled text parameter table contains the information entered by the user in the text parameter and the user-defined script code in the Js script parameter.

[0259] The desktop client includes a parameter creation feature. The Create Parameters list displays eight parameters supported by the VSTO add-in. Users can select a parameter and modify its configuration properties as needed. When the user issues an OK command, the client creates a ContentControl in the current Word document. The Tag property of the ContentControl contains a JSON (JSON, a data exchange format) string defining the various module parameters.

[0260] The desktop client includes parameter properties, implemented using an ActionPanel. The parameter properties panel is used to adjust the configurable properties of the application group parameters. Modified properties are directly replaced and saved to the content control selected by the user.

[0261] The desktop client includes a predefined item feature, where construction group text parameters are available in both system-configured and user-defined formats. User-defined text parameters are managed through predefined items. Users can add or remove text parameters based on specific construction project needs, defining the parameter category name, format, and parameter display method. The parameter display method refers to whether the same text parameter is displayed multiple times in the parameter fill options. Predefined items also include the ability to define JavaScript script parameters. Users can modify and manage the script content based on specific construction project needs and save it to the plugin's user configuration file.

[0262] The desktop client includes a fill option function. The fill option panel counts the parameterized items of all group document nodes and lists them by category. When the user selects a specified category, the fill panel lists in detail the nodes where the parameterized items are located and the configurable properties. When the user double-clicks the name, they can quickly jump to the location of the specified content control.

[0263] like Figure 4As shown, the intelligent management system for water conservancy project construction plans of the present invention comprises a server developed using .NetCore WebAPI and using Nginx to distribute user requests to designated servers. The presentation layer of the server accepts Axios requests from clients, performs preliminary processing, and then passes them to the business logic layer. The business logic layer, in conjunction with the data connection layer, executes the request code and returns the final request result to the requesting client (desktop client or web client) in JSON format.

[0264] The databases connected to the data connection layer include relational databases and non-relational databases.

[0265] The relational database uses the SqlServer database. The basic tables related to system operation are stored in the SZBasic database, the data related to the application group is stored in the SZData, and the module data documents related to the application group data in the non-relational database are stored in the ElasticSearch database.

[0266] The parametric module described in the present invention is not limited to application in the process of compiling construction organization design documents, but is also applicable to the compilation of design calculation documents, special plans, etc.

[0267] The above embodiments are only used to illustrate rather than limit the technical solutions of the present invention. Although the present invention has been described in detail with reference to the above embodiments, those skilled in the art should understand that the present invention can still be modified or replaced by equivalents. Any modification or partial replacement that does not depart from the spirit and scope of the present invention should be included in the scope of the claims of the present invention.

Claims

1. Intelligent management system for water conservancy project construction plan, abbreviating the construction organization as construction group; including the client installed in the local computer Windows system and the server installed in the server, The client includes a desktop client and a web client running in a browser. Both the desktop client and the web client are connected to the server via the HTTP protocol. The features are: The desktop client is embedded into Word or WPS using VSTO plug-in; the desktop client has the functions of creating, opening, editing and saving new implementation group documents; The server has a database and a template library. The template library is used to store user-prepared application template documents. Databases include SqlServer database and ElasticSearch database; SqlServer database includes SZBasic database and SZData database; The ElasticSearch database includes the moduledata database; The SZBasic database is used to store basic tables related to system operation, including user data, role data, department data, data permission data, operation permission data, dictionary, and process data related to the general management system; The SZData database is used to store business data related to the implementation group data; It includes application group classification data, application group directory data, application group module data and document template data; application group module data is a document fragment created by the user for later use; The moduledata database is used to store module data documents related to the application group data, which contains text extracted from historical application group documents; The desktop client stores module data selected by the user for generating the application group document. The desktop client includes an application group parameterization module, a parameterization parsing module, and a document generation module. The service program modules on the server side include file data receiving and structure checking module, duplication rate checking module, database storage module and big data search module; The construction group parameterization module is used to perform parameterization conversion on the document content of the existing construction group documents, and to replace the relevant information of a specific project with parameters to produce more universal construction group module data; The file data receiving and structure checking module is used to receive the file data generated by the parameterization module of the application group and perform structure checking on the received file data; The duplication rate check module is used to check the duplication rate between the current document data and the historical document data; The database storage module is used to store the data with qualified repetition rate into the corresponding database according to the data type; The big data search module is used to respond to search requests from desktop clients or web clients and find the module data of the search request in the database; The parameterized parsing module is used to respond to the command of the desktop client user to generate the application group document, generate corresponding content according to the parameterized attributes of the parameterized content control contained in the text node in the current document structure, and insert the generated content into the location of the parameterized content control in the current document, so that the generated content becomes an integral part of the application group document; The document generation module is used to generate the final construction organization design document; The parameterized module of the application group includes a filling text parameterized submodule, a calculation number parameterized submodule, a date parameterized submodule, an arithmetic operation parameterized submodule, a date operation parameterized submodule, a function operation parameterized submodule, an aggregation operation parameterized submodule and a JS script operation parameterized submodule; The fill text parameterization submodule is used to generate a fill text parameter content control in the application group document node; The calculation number parameterization submodule is used to generate the calculation number parameter content control in the application group document node; The date parameterization submodule is used to generate date parameter content controls in the application group document node; The arithmetic operation parameterization submodule is used to generate arithmetic operation parameter content controls in the application group document node; The date operation parameterization submodule is used to generate the date operation parameter content control in the application group document node; The function operation parameterization submodule is used to generate function operation parameter content controls in the application group document node; The aggregation operation parameterization submodule is used to generate the aggregation operation parameter content control in the application group document node; The JS script operation parameterization submodule is used to generate the JS script operation parameter content control in the application group document node; The parameterized parsing module includes a filling text parameter parsing submodule, a calculation number parameter parsing submodule, a date parameter parsing submodule, an arithmetic operation parameter parsing submodule, a date operation parameter parsing submodule, a function operation parameter parsing submodule, an aggregation operation parameter parsing submodule and a JS script operation parameter parsing submodule; Submodule 1, fill text parameter parsing submodule: The fill text parameter parsing submodule is used to process the fill text parameter content control in the application group document and fill in the text at the application group document location where the fill text parameter content control is located; In the fill text parameter parsing submodule, fill text parameters include two types: system defined and user defined; System-defined parameters include marker placeholder parameters and text content parameters that appear repeatedly in construction organization documents; Marking a placeholder parameter is used to instruct the user to fill in the content of this part and provide a quick location function in the system's parameter list. The user can jump to the parameter location by marking the placeholder parameter to fill in or modify the content. Fill-in text parameters other than the marked placeholder parameters are repetitive content parameters. The text content parameters in the system-defined parameters are used to reduce the number of user-defined fill-in text parameters, thereby improving the uniformity of the content of the application group document. When the system-defined parameters cannot meet the needs, users can use user-defined fill-in text parameters to eliminate the need for repeated manual filling of the corresponding repetitive fill-in text content. User-defined fill-in text parameters are only counted once in the parameter list. After the user fills in the content once in the parameter list, the content of the parameter is uniformly applied during the parameter parsing process. Submodule 2, calculation number parameter analysis submodule: The calculation number parameter parsing submodule is used to process the calculation number parameter content control in the application group document. It fills in the number according to the document module structure at the application group document location where the calculation number parameter content control is located, and avoids human errors caused by manual input and repeated modifications, thereby realizing automatic calculation of module data. The calculation number parameter parsing submodule automatically adopts the corresponding calculation rules and generates the number parameters according to the number level of the position of the number parameterized content control determined by the parent node and the increase level during the parsing process; Submodule 3, date parameter parsing submodule: The date parameter parsing submodule is used to process the date parameter content control in the application group document, fill in the date in the application group document where the date parameter content control is located, and avoid human errors caused by manual input and repeated modifications, so as to realize automatic calculation of module data; date parameter content controls with the same date have the same unique value; date parameter parsing is performed before applying the application group template document format; Submodule 4, arithmetic operation parameter parsing submodule: The function of the arithmetic operation parameter parsing submodule is to process the arithmetic operation parameter content control in the application group document, fill in the corresponding formula and calculation result in the application group document where the arithmetic operation parameter content control is located, and avoid human errors caused by manual input and repeated modification, and automatically realize module data calculation; The attributes of an arithmetic operation parameter contain members and results; The arithmetic operation parameters of the same formula have the same unique value, and the arithmetic operator is saved in the arithmetic operation parameter whose attribute is the result; When parsing arithmetic operation parameters, the arithmetic operation parameter parsing submodule first searches for the arithmetic operation parameter content control in the content of the group document node, and groups the arithmetic operation parameter content controls according to the unique values ​​of the arithmetic operation parameter content control attributes, and groups the arithmetic operation parameter content controls with the same unique values ​​into one group; Before applying the template document format, the result of the arithmetic operation contains a format string, which outputs the result generated by the user's operation into a specified text format according to the predetermined output precision. Submodule 5, date calculation parameter parsing submodule: The function of the date operation parameter parsing submodule is to process the date operation parameter content control in the application group document, calculate the time span, avoid errors caused by manual calculation, and fill in the calculation results at the location of the date operation parameter content control in the application group document; The date operation parameters include date operand 1, date operand 2, and the result; the result is the number of days between the date represented by date operand 1 and the date represented by date operand 2; The date operands corresponding to the same date are identified by the same unique value; Date operation parameters are displayed in one row in the parameter list for the same operation; Quickly locate the application group document location where the parameter control is located through the parameter list; the date operation parameters are parsed before applying the application group template document format; Submodule 6, function operation parameter parsing submodule: The function operation parameter parsing submodule is used to process the function operation parameter content control in the application group document and fill in the corresponding formula at the application group document location where the function operation parameter content control is located; The parameterized properties of a function operation include the function's parameters. The user enters the corresponding value for each function operation parameter. During the parsing process, the document processing program first starts a process in the background to output the formula content to the application group document, then replaces the parameters to complete the calculation, and saves the resulting temporary file and inserts it into the location of the function operation parameter content control as part of the application group document. The parsing of the function operation parameters occurs before applying the application group template document format. Submodule 7: Aggregation operation parameter analysis submodule: The function of the aggregation operation parameter parsing submodule is to process the aggregation operation parameter content control in the application group document and fill in the corresponding parsing result at the application group document location where the aggregation operation parameter content control is located; Aggregate operation parameters include operand parameters and result parameters; The operand parameters of the aggregation operation parameters include multiple operand parameter controls; the operation rules of the aggregation operation are pre-stored in the result parameter content control; the aggregation operation parameter parsing submodule finds all relevant operand parameters according to the unique value attribute of the result parameter during the process of parsing and generating the application group document and applies the calculation rules pre-stored in the result parameter content control to generate the final operation result; the parameterized parsing of the aggregation operation is performed before applying the application group template document format; Sub-module 8, JS script operation parameter parsing sub-module: The function of the JS script operation parameter parsing submodule is to process the JS script operation parameter content control in the application group document and fill in the corresponding parsing results at the application group document location where the JS script operation parameter content control is located; The JS script operation parameter parsing submodule executes the JavaScript script in the parameter attribute through the NodeJS module included with the VSTO plug-in; The VSTO plug-in is pre-installed with a script for importing external files, which automatically imports external file data and performs processing through the script; The JS script operation parameter parsing submodule outputs the result of the script execution processing as text or image, and inserts it into the location of the JS script operation parameter content control in the current application group document as a component of the application group document content; The parsing of Js script operation parameters occurs before the style template is applied to the document.

2. The intelligent management system for water conservancy project construction plans according to claim 1 is characterized by: The numbering parameter generated by the calculation numbering parameter parsing submodule has an indentation attribute, which is used to determine the number of spaces at the beginning of the paragraph where the number is located; The result of date operations provides date formatting options, which are used to format the date into the display format specified by the user.

3. The intelligent management system for water conservancy project construction plans according to claim 1 or 2, characterized in that: In the parameter list, only one date parameter with the same unique value is listed, and date parameters with different unique values ​​are listed separately. By filling in the date in the date parameter list, the date parameter values ​​in all date parameter content controls in the application group document can be quickly replaced.

4. A construction organization design method using the intelligent management system for water conservancy project construction plans as claimed in claim 3, characterized in that Follow these steps: The first step is to create a template document for the implementation group; The second step is to create a new implementation group document node and parameterize it; The third step is to use the module data in the intelligent management system of water conservancy project construction plan to supplement and improve the construction group documents; The fourth step is to generate the final construction organization document.

5. The construction organization design method according to claim 4, characterized in that: The first step is specifically: the user creates a template document for the application group in Word to standardize the application group document style; the user uploads the template document for the application group to the template library of the server for applying the template format in the fourth step; The implementation group template documents include the bidding implementation group template documents and the implementation implementation group template documents; The function of the construction group template document is to provide a structural template for combining nodes into a semi-finished construction group document of the construction organization design, thus reducing the workload of users to manually add content. The data types of the application group template document node are divided into three types: plain text, Word document and module data ID; The second step is to create a new document node with four attributes: no attribute, variable attribute, fixed attribute and fill attribute. The node content with fixed attributes is independent of the general content of a type of construction organization design and does not require user supplementation; The node content with variable attributes contains some common content that is independent of a type of construction organization design and does not need to be improved by the user. The user can improve the node content with variable attributes according to the specific conditions of the current project. The node content of the filling attribute does not contain general content independent of a type of construction organization design. Users fill in the node content of the filling attribute according to the specific situation of the current project. When a user creates a new application group document through the desktop client, the desktop client parses the nodes in the application group template document to generate text nodes; The specific steps of parameterizing the application group document node are as follows: generating a fill text parameter content control in the application group document node by using the fill text parameterization submodule; Generate a calculation number parameter content control in the application group document node using the calculation number parameterization submodule; Use the date parameterization submodule to generate a date parameter content control in the application group document node; The arithmetic operation parameterization submodule is used to generate an arithmetic operation parameter content control in the application group document node; Use the date operation parameterization submodule to generate the date operation parameter content control in the application group document node; Generate function operation parameter content control in the application group document node by using function operation parameterization submodule; Generate aggregate operation parameter content control in the application group document node using aggregate operation parameterization submodule; Generate JS script operation parameter content control in the application group document node by using JS script operation parameterization submodule; The third step is specifically: after the second step is completed, the user uses the editing command to supplement the content of the application group document node; 1. Check the structure of the current document data through the file data receiving and structure checking module, and the user performs a duplication rate check on the current document that passes the inspection; Second, the repetition rate of the current document data and the historical group documents is checked through the repetition rate check module; the user stores the current document with qualified repetition rate into the database, specifically, the original document is stored in the SZData database and the extracted plain text is stored in the moduledata database; More specifically, for documents that have passed verification, all text in the document is extracted, and the repetition rate between the document and the plain text of existing documents in the library is calculated by comparing the text; For documents with a duplication rate exceeding the threshold, the user will be prompted that there are already documents with similar content in the library, and asked whether the user wants to continue inserting the document. After the user chooses to insert the document, the document and the user-submitted form are first stored in the module data request process data table in the SZBasic database. After the process is approved by the administrator, the document is stored in the module data table in the SZData database. At the same time, Aspose.Words is used to extract the full text from the document, and combined with the user-submitted form, jsondoc is generated and stored in the moduledata database of ElasticSearch.

3. The user creates a new implementation group document through the desktop client and calls the completed implementation group document node data to complete the document; Fourth, the user generates corresponding content through the parameterized parsing module based on the parameterized attributes of the parameterized content control contained in the text node in the current document structure, and inserts the generated content into the location of the parameterized content control in the current document, so that the generated content becomes a component of the document; the parameterized attributes are stored in the parameterized content control; Specifically, it includes: using the fill text parameter parsing submodule to fill in the text parameters of the system-defined type and the user-defined text parameters in the group document position where the fill text parameter content control is located; Use the calculation number parameter parsing submodule to fill in the number according to the document module structure at the location of the calculation number parameter content control; Use the date parameter parsing submodule to fill in the date in the document where the date parameter content control is located; Use the arithmetic operation parameter parsing submodule to fill in the corresponding formula and calculation results in the group document location where the arithmetic operation parameter content control is located; Use the date operation parameter parsing submodule to fill in the calculated time span result at the location of the date operation parameter content control in the application group document; Use the function operation parameter parsing submodule to fill in the corresponding formula in the document where the function operation parameter content control is located; Use the aggregation operation parameter parsing submodule to fill in the corresponding parsing results in the location of the aggregation operation parameter content control in the application group document; Use the JS script operation parameter parsing submodule to fill in the corresponding parsing results in the document location where the JS script operation parameter content control is located; The fourth step is specifically: after the third step is completed, the user operates the desktop client to issue an apply style command to apply the style of the applied construction group template document to the current construction group document; the user generates the final construction organization design document through the document generation module.

Images