[go: up one dir, main page]

CN116562819A - Intelligent management system for hydraulic engineering construction scheme and construction organization design method - Google Patents

Intelligent management system for hydraulic engineering construction scheme and construction organization design method Download PDF

Info

Publication number
CN116562819A
CN116562819A CN202310549961.7A CN202310549961A CN116562819A CN 116562819 A CN116562819 A CN 116562819A CN 202310549961 A CN202310549961 A CN 202310549961A CN 116562819 A CN116562819 A CN 116562819A
Authority
CN
China
Prior art keywords
document
module
parameter
group
date
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN202310549961.7A
Other languages
Chinese (zh)
Other versions
CN116562819B (en
Inventor
黄志伟
典旭明
马志华
王金鹏
袁天华
畅会军
畅丽丽
李岩
李东晓
胡腾飞
董吉慧
王龙
张磊
马帅
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Henan Yuhong Industrial Co ltd
Henan First Water Conservancy Engineering Bureau Group Co ltd
Original Assignee
Henan Yuhong Industrial Co ltd
Henan First Water Conservancy Engineering Bureau Group Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Henan Yuhong Industrial Co ltd, Henan First Water Conservancy Engineering Bureau Group Co ltd filed Critical Henan Yuhong Industrial Co ltd
Priority to CN202310549961.7A priority Critical patent/CN116562819B/en
Publication of CN116562819A publication Critical patent/CN116562819A/en
Application granted granted Critical
Publication of CN116562819B publication Critical patent/CN116562819B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/10Office automation; Time management
    • G06Q10/103Workflow collaboration or project management
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/103Formatting, i.e. changing of presentation of documents
    • G06F40/109Font handling; Temporal or kinetic typography
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/12Use of codes for handling textual entities
    • G06F40/151Transformation
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/186Templates
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q50/00Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/08Construction
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02ATECHNOLOGIES FOR ADAPTATION TO CLIMATE CHANGE
    • Y02A10/00TECHNOLOGIES FOR ADAPTATION TO CLIMATE CHANGE at coastal zones; at river basins
    • Y02A10/40Controlling or monitoring, e.g. of flood or hurricane; Forecasting, e.g. risk assessment or mapping

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Business, Economics & Management (AREA)
  • Physics & Mathematics (AREA)
  • Health & Medical Sciences (AREA)
  • General Health & Medical Sciences (AREA)
  • Human Resources & Organizations (AREA)
  • Strategic Management (AREA)
  • Computational Linguistics (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • General Engineering & Computer Science (AREA)
  • Artificial Intelligence (AREA)
  • Tourism & Hospitality (AREA)
  • Marketing (AREA)
  • Economics (AREA)
  • General Business, Economics & Management (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Primary Health Care (AREA)
  • Data Mining & Analysis (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • Document Processing Apparatus (AREA)

Abstract

本发明公开了一种水利工程施工方案智能化管理系统,包括安装在本地计算机windows系统中的客户端和安装在服务器中的服务端,客户端包括桌面和WEB客户端;采用VSTO插件将桌面客户端嵌入到Word或WPS中;桌面客户端具有新建、打开、编辑和保存新建施组文档的功能;服务端具有数据库以及模板库,模板库用于存储用户预制的施组模板文档。本发明还公开了相应的施工组织设计方法。本发明能够有效重复利用历史施组文档内容,一次编制工作中的成果可以在后续工程中方便地重复调用,提高编制施工组织设计文档的效率以及一致性,解决内容格式不统一,编制工作量大、节点级别混乱、重复内容表述不一致、节点日期不统一且难修改和公式输入耗时耗力等等问题。

The invention discloses an intelligent management system for water conservancy project construction plan, which includes a client installed in a windows system of a local computer and a server installed in a server. The client includes a desktop and a WEB client; The client is embedded in Word or WPS; the desktop client has the functions of creating, opening, editing and saving new construction documents; the server has a database and a template library, and the template library is used to store user-prefabricated construction template documents. The invention also discloses a corresponding construction organization design method. The present invention can effectively reuse the content of historical construction documents, and the results of one compilation work can be conveniently called repeatedly in subsequent projects, improving the efficiency and consistency of compiling construction organization design documents, and solving the problem of inconsistent content format and large compilation workload , Node level confusion, inconsistent expression of repeated content, inconsistent node dates and difficult modification, and time-consuming and labor-intensive formula input, etc.

Description

水利工程施工方案智能化管理系统及施工组织设计方法Intelligent management system and construction organization design method of water conservancy project construction plan

技术领域technical field

本发明涉及工程技术领域,尤其涉及一种水利工程施工方案智能化管理系统及方法。The invention relates to the field of engineering technology, in particular to an intelligent management system and method for construction schemes of water conservancy projects.

背景技术Background technique

施工组织设计的编制是一项技术性强,综合性强的工作。采用人工编制方法费时费力,并存在大量重复性工作,编制工作效率低,计算内容经过多次反复修改容易出错,曾经编制好的施工组织设计不能得到有效重复利用。The preparation of construction organization design is a highly technical and comprehensive work. The manual compilation method is time-consuming and laborious, and there is a lot of repetitive work. The compilation work efficiency is low. The calculation content is prone to errors after repeated revisions. The construction organization design that has been compiled cannot be effectively reused.

施工组织设计的编制工作通常时间要求紧迫,加班加点,这样编制出来的施组文档其质量难以保证,给后续真正的施工带来隐患。公司和项目技术资料管理混乱,编制内容基本采用的都是传统技术,将新技术和新工艺编制进去又需要花费较长时间,难以满足时间上的要求,还容易出现节点级别(层级)混乱不统一、实质重复的内容在施组文档各处重复出现时表述不一致、不能快速定位到施组文档需要修改之处、节点日期不统一且难修改(如工程具有某种节点日期如预定的完工日,节点日期在施组文档中多处出现,当节点日期需要修改时,人工修改往往会有遗漏,造成节点日期不统一)、时间跨度计算不准确(且表达格式不统一)、公式输入耗时耗力、施组文档统计运算部分手动输入和反复修改造成的错误、以及外部文件操作过程繁琐和自动化处理能力较低等等问题,这些问题使得目前的施工组织设计的编制工作没有起到传播先进技术(将先进技术编制进去耗费的工时和人力过大),减少人力资源消耗的作用,对实际施工的指导作用受到很大限制。The preparation of the construction organization design is usually time-consuming and requires overtime, so the quality of the construction organization documents prepared in this way is difficult to guarantee, which brings hidden dangers to the subsequent real construction. The management of company and project technical data is chaotic, and traditional technologies are basically used for compiling content. It takes a long time to compile new technologies and new processes, it is difficult to meet the time requirements, and it is prone to confusion at the node level (level). Unified and substantially repeated content is inconsistent in expression when repeated in the construction group document, cannot quickly locate the place that needs to be modified in the construction group document, and the node date is not uniform and difficult to modify (for example, the project has a certain node date such as the scheduled completion date , the node date appears in many places in the Shi group document. When the node date needs to be modified, manual modification will often miss it, resulting in inconsistent node dates), inaccurate calculation of time span (and inconsistent expression format), time-consuming formula input Problems such as energy consumption, errors caused by manual input and repeated modification of the statistical calculation part of construction documents, cumbersome external file operation process and low automatic processing ability, etc., these problems make the current construction organization design preparation work not effective in disseminating advanced Technology (it takes too much man-hours and manpower to compile advanced technology), the role of reducing human resource consumption, and its guiding role in actual construction are greatly limited.

发明内容Contents of the invention

本发明的目的在于针对现有技术中的问题,提供一种水利工程施工方案智能化管理系统,解决施工组织设计编制过程中内容重复,Word、WPS软件操作重复,计算繁琐,缺少资料参考、内容格式难以统一,编制质量差异大、效率低以及人力资源浪费的问题,提高编制施工组织设计文档(即施组文档)的效率和规范性。The purpose of the present invention is to address the problems in the prior art, to provide a water conservancy project construction plan intelligent management system, to solve the content duplication in the construction organization design compilation process, Word, WPS software operation duplication, cumbersome calculation, lack of data reference, content Difficult to unify the format, large differences in preparation quality, low efficiency and waste of human resources, improve the efficiency and standardization of the preparation of construction organization design documents (i.e. construction group documents).

为实现上述目的,本发明提供了一种水利工程施工方案智能化管理系统,将施工组织简称为施组;包括安装在本地计算机windows系统中的客户端和安装在服务器中的服务端,In order to achieve the above object, the present invention provides an intelligent management system for water conservancy project construction plan, and the construction organization is referred to as the construction group; it includes a client installed in the windows system of a local computer and a server installed in the server,

客户端包括桌面客户端和运行在浏览器中的WEB客户端,桌面客户端和WEB客户端均通过HTTP协议与服务端相连接;Clients include desktop clients and WEB clients running in browsers, both desktop clients and WEB clients are connected to the server through HTTP protocol;

采用VSTO插件将桌面客户端嵌入到Word或WPS中;桌面客户端具有新建施组文档、打开新建施组文档、编辑新建施组文档和保存新建施组文档的功能;Use the VSTO plug-in to embed the desktop client into Word or WPS; the desktop client has the functions of creating a file, opening a file, editing a file and saving a file;

服务端具有数据库以及模板库,模板库用于存储用户预制的施组模板文档,The server has a database and a template library. The template library is used to store user-prefabricated group template documents.

数据库包括SqlServer数据库和ElasticSearch数据库;Databases include SqlServer database and ElasticSearch database;

SqlServer数据库包括SZBasic数据库和SZData数据库;SqlServer database includes SZBasic database and SZData database;

ElasticSearch数据库包括moduledata数据库;The ElasticSearch database includes the moduledata database;

SZBasic数据库用于存储与系统运行相关的基本表,包括与通用管理系统相关的用户数据、角色数据、部门数据、数据权限数据、操作权限数据、字典和流程数据;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, dictionaries and process data related to the general management system;

SZData数据库用于存储与施组数据相关的业务数据;包括施组分类数据、施组目录数据、施组模块数据和文档模板数据;施组模块数据是由用户制作的用于后期调用的文档片段;The SZData database is used to store business data related to group data; including group classification data, group directory data, group module data and document template data; group module data is document fragments made by users for later calls ;

moduledata数据库用于存储与施组数据相关的模块数据文档,其中包含由历史施组文档提取的文本;The moduledata database is used to store module data documents related to group data, which contains text extracted from historical group files;

桌面客户端中存储有由用户挑选的,用于生成施组文档的模块数据,桌面客户端具有施组参数化模块、参数化解析模块和文档生成模块;The desktop client stores module data selected by the user for generating group documents, and the desktop client has a group parameterization module, a parameterization analysis module and a document generation module;

服务端的业务程序模块包括文件数据接收及结构检查模块、重复率检查模块、存入数据库模块和大数据搜索模块;The business program modules on the server side include file data receiving and structure checking modules, repetition rate checking modules, storing in database modules and big data search modules;

施组参数化模块用于对现存的施组文档的文档内容进行参数化转换,将特定工程项目的相关信息通过参数替换制作成通用性更强的施组模块数据;The group parameterization module is used to parametrically transform the document content of the existing group documents, and make the relevant information of a specific project into more versatile group module data through parameter replacement;

文件数据接收及结构检查模块用于接收施组参数化模块生成的文件数据并对接收到的文件数据进行结构检查;The file data receiving and structure checking module is used to receive the file data generated by the group parameterization module and check the structure of the received file data;

重复率检查模块用于检查当前文档数据与历史施组文档的重复率;The repetition rate checking module is used to check the repetition rate between the current document data and the historical group documents;

存入数据库模块用于将重复率合格的数据根据数据类型存入相应的数据库中;The store in database module is used to store the data with qualified repetition rate into the corresponding database according to the data type;

大数据搜索模块用于响应来自桌面客户端或WEB客户端的搜索请求,在数据库中找到搜索请求的模块数据;The big data search module is used to respond to the search request from the desktop client or WEB client, and find the module data of the search request in the database;

参数化解析模块用于响应桌面客户端用户生成施组文档的命令,根据当前文档结构中的文本节点中包含的参数化内容控件中的参数化属性,生成相应的内容并将生成的内容插入到当前文档中所述参数化内容控件所在位置,使生成的内容成为施组文档的组成部分;The parameterized parsing module is used to respond to the desktop client user's command to generate a group document, according to the parameterized attribute in the parameterized content control contained in the text node in the current document structure, generate the corresponding content and insert the generated content into The position of the parameterized content control described in the current document, so that the generated content becomes an integral part of the document;

文档生成模块用于生成最终的施工组织设计文档。The document generation module is used to generate the final construction organization design document.

施组参数化模块包括填充文本参数化子模块、计算编号参数化子模块、日期参数化子模块、算术运算参数化子模块、日期运算参数化子模块、函数运算参数化子模块、聚合运算参数化子模块和JS脚本运算参数化子模块;The group parameterization module includes the filling text parameterization submodule, the calculation number parameterization submodule, the date parameterization submodule, the arithmetic operation parameterization submodule, the date operation parameterization submodule, the function operation parameterization submodule, and the aggregation operation parameter Parameterized sub-modules and JS script operation parameterized sub-modules;

填充文本参数化子模块用于在施组文档节点中生成填充文本参数内容控件;Fill text parameterization sub-module is used to generate fill text parameter content control in group document node;

计算编号参数化子模块用于在施组文档节点中生成计算编号参数内容控件;The calculation number parameterization sub-module is used to generate the calculation number parameter content control in the group document node;

日期参数化子模块用于在施组文档节点中生成日期参数内容控件;The date parameterization sub-module is used to generate date parameter content controls in the group document node;

算术运算参数化子模块用于在施组文档节点中生成算术运算参数内容控件;Arithmetic operation parameterization sub-module is used to generate arithmetic operation parameter content control in group document node;

日期运算参数化子模块用于在施组文档节点中生成日期运算参数内容控件;The date operation parameterization sub-module is used to generate the date operation parameter content control in the group document node;

函数运算参数化子模块用于在施组文档节点中生成函数运算参数内容控件;The function operation parameterization sub-module is used to generate the function operation parameter content control in the group document node;

聚合运算参数化子模块用于在施组文档节点中生成聚合运算参数内容控件;The aggregation operation parameterization sub-module is used to generate the aggregation operation parameter content control in the group document node;

JS脚本运算参数化子模块用于在施组文档节点中生成JS脚本运算参数内容控件;The JS script operation parameterization sub-module is used to generate the JS script operation parameter content control in the group document node;

参数化解析模块包括填充文本参数解析子模块、计算编号参数解析子模块、日期参数解析子模块、算术运算参数解析子模块、日期运算参数解析子模块、函数运算参数解析子模块、聚合运算参数解析子模块和JS脚本运算参数解析子模块;The parameterized parsing module includes filling text parameter parsing sub-module, calculation number parameter parsing sub-module, date parameter parsing sub-module, arithmetic operation parameter parsing sub-module, date computing parameter parsing sub-module, function computing parameter parsing sub-module, aggregate computing parameter parsing sub-module Submodule and JS script operation parameter parsing submodule;

(一)填充文本参数解析子模块:(1) Fill in the text parameter parsing submodule:

填充文本参数解析子模块用于处理施组文档中的填充文本参数内容控件,在填充文本参数内容控件所在施组文档位置填写文本;The filling text parameter parsing sub-module is used to process the filling text parameter content control in the group document, and fill in the text at the position of the group document where the filling text parameter content control is located;

填充文本参数解析子模块中,填充文本参数包括系统定义和用户自定义两种类型;In the filling text parameter parsing sub-module, filling text parameters include two types: system definition and user-defined;

系统定义参数包括标记占位参数和施工组织文档中重复出现的文本内容参数;System-defined parameters include mark occupancy parameters and text content parameters that appear repeatedly in construction organization documents;

标记占位参数用于指示用户填充该部分的内容,并在系统的参数列表中提供快速定位的功能,用户通过标记占位参数跳转到参数所在位置进行内容填写或修改;The mark placeholder parameter is used to instruct the user to fill in the content of this part, and provides a quick positioning function in the parameter list of the system. The user jumps to the position of the parameter through the mark placeholder parameter to fill in or modify the content;

标记占位参数以外的填充文本参数为重复性内容参数,系统定义参数中的文本内容参数用于减少用户定义的填充文本参数从而提高施组文档内容的统一性;系统定义参数不能满足需求的情况下,用户通过用户自定义的填充文本参数,使相应的重复性填充文本内容不需要反复人工填充;用户自定义的填充文本参数在参数列表中只统计一次,用户在参数列表中填写一次内容后在参数解析过程中统一应用该参数的内容;Filling text parameters other than mark placeholder parameters are repetitive content parameters, and text content parameters in system-defined parameters are used to reduce user-defined filling text parameters to improve the uniformity of document content; system-defined parameters cannot meet the requirements In this case, the user uses the user-defined filling text parameters, so that the corresponding repetitive filling text content does not need to be manually filled repeatedly; the user-defined filling 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;

(二)计算编号参数解析子模块:(2) Calculation number parameter parsing sub-module:

计算编号参数解析子模块用于处理施组文档中的计算编号参数内容控件,在计算编号参数内容控件所在施组文档位置根据文档模块结构组成填写编号,并避免手动输入和反复修改造成的人为错误,实现模块数据自动计算;The calculation number parameter parsing sub-module is used to process the calculation number parameter content control in the application group document, fill in the number according to the structure of the document module in the location of the calculation number parameter content control in the application group document, and avoid human errors caused by manual input and repeated modification , to realize automatic calculation of module data;

计算编号参数解析子模块在解析的过程中根据父节点和增加级别所确定得到的编号参数化内容控件所在位置的编号级别,根据级别自动采用相应的计算规则并生成编号参数;In the parsing process, the calculation numbering parameter parsing sub-module will automatically adopt corresponding calculation rules and generate numbering parameters according to the numbering level of the location of the numbering parameterized content control determined by the parent node and the added level;

(三)日期参数解析子模块:(3) Date parameter parsing sub-module:

日期参数解析子模块用于处理施组文档中的日期参数内容控件,在日期参数内容控件所在施组文档位置填写日期,并避免手动输入和反复修改造成的人为错误,实现模块数据自动计算;日期相同的日期参数内容控件具有相同的唯一值;日期参数的解析在套用施组模板文档格式之前进行;The date parameter parsing sub-module is used to process the date parameter content control in the group document, fill in the date in the position of the group document where the date parameter content control is located, and avoid human errors caused by manual input and repeated modification, and realize automatic calculation of module data; date The same date parameter content controls have the same unique value; the parsing of the date parameter is performed before applying the template document format;

(四)算术运算参数解析子模块:(4) Arithmetic operation parameter parsing sub-module:

算术运算参数解析子模块的作用是处理施组文档中的算术运算参数内容控件,在算术运算参数内容控件所在施组文档位置填写相应公式及计算结果,并避免手动输入和反复修改造成的人为错误,自动实现模块数据计算;The function of the arithmetic operation parameter parsing sub-module is to process the content control of the arithmetic operation parameter in the group document, fill in the corresponding formula and calculation results in the position of the group document where the content control of the arithmetic operation parameter is located, and avoid human errors caused by manual input and repeated modification , automatically realize module data calculation;

算术运算参数的属性包含成员和结果;The properties of arithmetic operation parameters include members and results;

同一个算式的算术运算参数具有相同的唯一值,算术运算符保存在属性为结果的算术运算参数中;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;

算术运算参数解析子模块在解析算术运算参数时,首先寻找施组文档节点内容中的算术运算参数内容控件,并根据算术运算参数内容控件属性的唯一值将算术运算参数内容控件分组,唯一值相同的分为一组;When parsing the arithmetic operation parameters, the arithmetic operation parameter parsing sub-module first looks for the arithmetic operation parameter content controls in the group document node content, and groups the arithmetic operation parameter content controls according to the unique value of the arithmetic operation parameter content control attribute, and the unique values are the same grouped into groups;

算术运算参数的解析在套用施组模板文档格式之前,算术运算的结果包含格式化字符串,将用户由运算产生的结果,按照预定的输出精度输出成指定的文本格式;Arithmetic operation parameter analysis Before applying the group template document format, the result of the arithmetic operation contains a formatted string, and the result generated by the user's operation is output into the specified text format according to the predetermined output precision;

(五)日期运算参数解析子模块:(5) Date operation parameter parsing sub-module:

日期运算参数解析子模块的作用是处理施组文档中的日期运算参数内容控件,进行时间跨度的计算,避免手动计算产生的错误,并在施组文档中的日期运算参数内容控件所在位置填写计算结果;The function of the date operation parameter parsing sub-module is to process the date operation parameter content control in the group document, calculate the time span, avoid errors caused by manual calculation, and fill in the calculation at the location of the date operation parameter content control in the group document result;

日期运算参数包括日期操作数1、日期操作数2和结果;结果为日期操作数1代表的日期与日期操作数2代表的日期之间的天数;Date operation parameters include date operand 1, date operand 2 and result; the result is the number of days between the date represented by date operand 1 and the date represented by date operand 2;

同一个日期对应的日期操作数使用相同的唯一值标识;Date operands corresponding to the same date are identified by the same unique value;

日期运算参数对于同一个运算在参数列表中以一行的形式显示;Date operation parameters are displayed in a row in the parameter list for the same operation;

通过参数列表可以快速定位到参数控件的所在的施组文档位置;日期运算参数的解析在套用施组模板文档格式之前;Through the parameter list, you can quickly locate the group document location where the parameter control is located; the date operation parameters are parsed before applying the group template document format;

(六)函数运算参数解析子模块:(6) Function operation parameter parsing sub-module:

函数运算参数解析子模块的作用是处理施组文档中的函数运算参数内容控件,在函数运算参数内容控件所在施组文档位置填写相应公式;The function of the function operation parameter parsing sub-module is to process the function operation parameter content control in the application group document, and fill in the corresponding formula in the location of the application group document where the function operation parameter content control is located;

函数运算参数化的属性包含函数的参数组成,用户为各函数运算参数输入对应的值,函数参数在解析的过程中首先是由文档处理程序在后台开启一个进程,将公式的内容输出到该施组文档中,然后替换其中的参数完成计算,并将产生的临时文件保存插入到函数运算参数内容控件的位置作为施组文档的一部分;函数运算参数的解析在套用施组模板文档格式之前;The parameterized attribute of a function operation includes the parameters of the function. The user inputs the corresponding value for each function operation parameter. During the parsing process of the function parameter, a document processing program starts a process in the background first, and outputs the content of the formula to the implementation. In the group document, replace the parameters in it to complete the calculation, save and insert the generated temporary file into the position of the function operation parameter content control as a part of the group document; the parsing of the function operation parameter is before applying the group template document format;

(七)聚合运算参数解析子模块:(7) Aggregation operation parameter parsing sub-module:

聚合运算参数解析子模块的作用是处理施组文档中的聚合运算参数内容控件,在聚合运算参数内容控件所在施组文档位置填写相应解析结果;The role of the aggregation operation parameter parsing sub-module is to process the aggregation operation parameter content control in the group document, and fill in the corresponding analysis results in the location of the group document where the aggregation operation parameter content control is located;

聚合运算参数包含操作数参数和结果参数;Aggregation operation parameters include operand parameters and result parameters;

聚合运算参数的操作数参数包括多个操作数参数控件;聚合运算的运算规则预存在结果参数内容控件中;聚合运算参数解析子模块在施组文档解析生成的过程中根据结果参数的唯一值属性找到所有相关的操作数参数并应用预存在结果参数内容控件中的计算规则生成最终的运算结果;聚合运算的参数化解析在套用施组模板文档格式之前;The operand parameter of the aggregation operation parameter includes 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 sub-module is based on the unique value attribute of the result parameter in the process of group document parsing and generation Find all relevant operand parameters and apply the calculation rules pre-stored in the result parameter content control to generate the final operation result; the parameterized analysis of the aggregation operation is before applying the group template document format;

(八)JS脚本运算参数解析子模块:(8) JS script operation parameter parsing sub-module:

JS脚本运算参数解析子模块的作用是处理施组文档中的JS脚本运算参数内容控件,在JS脚本运算参数内容控件所在施组文档位置填写相应解析结果;The function of the JS script operation parameter parsing sub-module is to process the JS script operation parameter content control in the application document, and fill in the corresponding analysis result in the location of the application document where the JS script operation parameter content control is located;

JS脚本运算参数解析子模块通过VSTO插件附带的NodeJS模块执行参数属性中JavaScript脚本;所述VSTO插件中预置有用于导入外部文件的脚本,通过脚本自动导入外部文件数据并执行处理;The JS script operation parameter parsing submodule executes the JavaScript script in the parameter attribute through the NodeJS module attached to the VSTO plug-in; the script for importing external files is preset in the VSTO plug-in, and the external file data is automatically imported and processed by the script;

JS脚本运算参数解析子模块将脚本执行处理的结果输出为文本或图片,作为内容插入到当前施组文档中JS脚本运算参数内容控件所在位置作为施组文档内容的组成部分;The JS script operation parameter parsing sub-module outputs the result of script execution processing as text or picture, and inserts it as content into the current group document at the location of the JS script operation parameter content control as an integral part of the group document content;

Js脚本运算参数的解析在施组文档应用样式模板之前。Js script operation parameters are parsed before applying style templates to group documents.

计算编号参数解析子模块生成的编号参数具有缩进属性,缩进属性用于确定编号所在段落的段首空格数量;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 numbering is located;

日期运算的结果提供日期格式化选项,用于将日期格式化成用户指定的显示形式。The result of the date operation provides a date formatting option, which is used to format the date into a user-specified display format.

在参数列表中,唯一值相同的日期参数只列出一个,唯一值不同的日期参数分别列出,通过在日期参数列表中填写日期,快速替换施组文档中所有日期参数内容控件中的日期参数值。In the parameter list, only one date parameter with the same unique value is listed, and the date parameters with different unique values are listed separately. By filling in the date in the date parameter list, you can quickly replace the date parameters in the content control of all date parameters in the group document value.

本发明还公开了采用上述水利工程施工方案智能化管理系统进行的施工组织设计方法,其特征在于按以下步骤进行:The present invention also discloses a construction organization design method carried out by adopting the intelligent management system of the construction plan of the water conservancy project, which is characterized in that it is carried out according to the following steps:

第一步骤是制作施组模板文档;The first step is to make a group template document;

第二步骤是新建施组文档节点并参数化;The second step is to create a new construction 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 documents.

第一步骤具体是:用户在Word中制作施组模板文档,用于规范施组文档样式;用户将施组模板文档上传到服务器的模板库中,供第四步骤中套用模板格式;The first step is specifically: the user makes a group template document in Word to standardize the style of the group document; the user uploads the group template document to the template library of the server for applying the template format in the fourth step;

施组模板文档包括投标类施组模板文档和实施类施组模板文档;The construction template document includes the bidding class construction template document and the implementation class construction group template document;

施组模板文档的作用是提供结构模板,用于将节点组成一篇施工组织设计的半成品施组文档,减少用户手动补充内容的工作量;The role of the construction template document is to provide a structural template for combining nodes into a semi-finished construction document for construction organization design, reducing the workload of users to manually supplement content;

施组模板文档节点的数据类型分为纯文本、Word文档和模块数据ID三种类型;The data types of the group template document node are divided into three types: plain text, Word document and module data ID;

第二步骤具体是:新建施组文档节点的属性分为无属性、可变属性、固属性定和充填属性共4种属性;The second step is specifically: the attributes of the newly created group document node are divided into four attributes: no attribute, variable attribute, fixed attribute and filling attribute;

固定属性的节点内容是独立于一类施工组织设计的通用内容,不需要用户补充;The node content of fixed attributes is a general content independent of a class of construction organization design, and does not need to be supplemented by users;

可变属性的节点内容中具有一部分不需要用户完善的独立于一类施工组织设计的通用内容,用户根据当前项目的具体情况完善可变属性的节点内容;The variable attribute node content has a part of the general content independent of a class of construction organization design that does not need to be completed by the user. The user completes the variable attribute node content according to the specific situation of the current project;

充填属性的节点内容中没有独立于一类施工组织设计的通用内容,用户据当前项目的具体情况填写充填属性的节点内容;There is no general content in the node content of the filling attribute that is independent of a class of construction organization design, and the user fills in the node content of the filling attribute according to the specific situation of the current project;

用户通过桌面客户端新建施组文档的过程中,桌面客户端解析施组模板文档中的节点生成文本节点;When the user creates a group document through the desktop client, the desktop client parses the nodes in the group template document to generate a text node;

对施组文档节点参数化具体是:利用填充文本参数化子模块在施组文档节点中生成填充文本参数内容控件;Parameterizing the group document node is specifically: using the filling text parameterization sub-module to generate a filling text parameter content control in the group document node;

利用计算编号参数化子模块在施组文档节点中生成计算编号参数内容控件;Use the calculation number parameterization sub-module to generate the calculation number parameter content control in the group document node;

利用日期参数化子模块在施组文档节点中生成日期参数内容控件;Use the date parameterization sub-module to generate a date parameter content control in the group document node;

利用算术运算参数化子模块在施组文档节点中生成算术运算参数内容控件;Use the arithmetic operation parameterization sub-module to generate the arithmetic operation parameter content control in the group document node;

利用日期运算参数化子模块在施组文档节点中生成日期运算参数内容控件;Use the date operation parameterization sub-module to generate the date operation parameter content control in the group document node;

利用函数运算参数化子模块在施组文档节点中生成函数运算参数内容控件;Use the function operation parameterization sub-module to generate the function operation parameter content control in the group document node;

利用聚合运算参数化子模块在施组文档节点中生成聚合运算参数内容控件;Use the aggregation operation parameterization sub-module to generate the aggregation operation parameter content control in the group document node;

利用JS脚本运算参数化子模块在施组文档节点中生成JS脚本运算参数内容控件;Use the JS script operation parameterization sub-module to generate the JS script operation parameter content control in the group document node;

第三步骤具体是:在第二步骤完成后,用户通过编辑命令,补充填写施组文档节点的内容;The third step is specifically: after the second step is completed, the user supplements and fills in the content of the group document node through the editing command;

(一)通过文件数据接收及结构检查模块检查当前文档数据的结构,用户对于检查合格的当前文档进行重复率检查;(1) Check the structure of the current document data through the document data receiving and structure checking module, and the user checks the repetition rate of the current document that passes the check;

(二)通过重复率检查模块检查当前文档数据与历史施组文档的重复率;用户将重复率合格的当前文档存入数据库,具体是将原文档存入SZData数据库并将抽取的纯文本存入moduledata数据库;(2) Check the repetition rate of the current document data and historical documents through the repetition rate checking module; the user saves the current document with a 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;

更具体是,对于验证通过的文档,提取文档中所有的文本,通过比对文本计算该文档和库中已有文档纯文本的重复率。对于重复率超过阈值的文档将提示用户库中已存在内容相似的文档,并询问用户是否要继续插入文档,用户选择插入文档后,首先将文档和用户提交表单存入SZBasic数据库中的模块数据请求流程数据表中,该流程经过管理员审批通过后,将文档存入SZData数据库中的模块数据表中,同时使用Aspose.Words从文档中提取全文的纯文本,结合用户提交表单生成jsondoc存储到ElasticSearch的moduledata数据库中。More specifically, for a document that has passed the verification, all the 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 whose repetition rate exceeds the threshold, it will prompt the user that there are documents with similar content in the library, and ask the user whether to continue inserting the document. After the user chooses to insert the document, the document and the user submission form are first stored in the module data request in the SZBasic database. In the process data table, after the process is approved by the administrator, the document is stored in the module data table in the SZData database, and the plain text of the full text is extracted from the document using Aspose.Words, combined with the form submitted by the user to generate jsondoc and store it in ElasticSearch in the moduledata database.

(三)用户通过桌面客户端新建施组文档,调用填写好的各施组文档节点数据完善文档;(3) The user creates a new construction group document through the desktop client, and calls the completed node data of each construction group document to complete the document;

(四)用户通过参数化解析模块,根据当前文档结构中的文本节点中包含的参数化内容控件中的参数化属性,生成相应的内容并将生成的内容插入到当前文档中所述参数化内容控件所在位置,使生成的内容成为施组文档的组成部分;参数化内容控件中存储了参数化的属性;(4) The user uses the parameterized parsing module to generate corresponding content according to the parameterized properties in the parameterized content control contained in the text node in the current document structure and insert the generated content into the parameterized content in the current document The location of the control makes the generated content an integral part of the group document; the parameterized content control stores parameterized attributes;

具体包括:利用填充文本参数解析子模块,在填充文本参数内容控件所在施组文档位置填写系统定义类型的文本参数以及用户自定义的文本参数;Specifically include: use the filling text parameter parsing sub-module to fill in system-defined text parameters and user-defined text parameters in the location of the group document where the filling text parameter content control is located;

利用计算编号参数解析子模块在计算编号参数内容控件所在施组文档位置根据文档模块结构组成填写编号;Use the calculation number parameter parsing sub-module to fill in the number according to the structure of the document module at the position of the document where the calculation number parameter content control is located;

利用日期参数解析子模块在日期参数内容控件所在施组文档位置填写日期;Use the date parameter parsing sub-module to fill in the date in the document location where the date parameter content control is located;

利用算术运算参数解析子模块在算术运算参数内容控件所在施组文档位置填写相应公式及计算结果;Use the arithmetic operation parameter analysis sub-module to fill in the corresponding formula and calculation results in the location of the group document where the content control of the arithmetic operation parameter is located;

利用日期运算参数解析子模块在施组文档中的日期运算参数内容控件所在位置填写计算出的时间跨度结果;Use the date operation parameter parsing sub-module to fill in the calculated time span result at the location of the date operation parameter content control in the group document;

利用函数运算参数解析子模块在函数运算参数内容控件所在施组文档位置填写相应公式;Use the function operation parameter parsing sub-module to fill in the corresponding formula in the location of the group document where the function operation parameter content control is located;

利用聚合运算参数解析子模块在聚合运算参数内容控件所在施组文档位置填写相应解析结果;Use the aggregation operation parameter parsing sub-module to fill in the corresponding analysis results in the group document where the aggregation operation parameter content control is located;

利用JS脚本运算参数解析子模块在JS脚本运算参数内容控件所在施组文档位置填写相应解析结果;Use the JS script operation parameter analysis sub-module to fill in the corresponding analysis results in the location of the document 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 the 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 through the document generation module document.

本发明具有如下的优点:The present invention has following advantage:

针对节点级别(层级)混乱不统一的问题,通过计算编号参数化、以及父节点的级别和子节点的级别不连续时,在参数解析的过程中需要给予用户提示来予以杜绝。Aiming at the problem of chaotic and inconsistent node levels (hierarchies), it is necessary to give user prompts during the parameter parsing process to eliminate the problem of parameterization through calculation numbers, and when the levels of parent nodes and child nodes are discontinuous.

重复内容表述不一致的问题,通过填充文本参数化予以解决。The problem of inconsistency in the expression of repeated content is solved by parameterizing the filling text.

不能快速定位到施组文档需要修改之处,通过标记占位参数予以解决。It is impossible to quickly locate the place where the group document needs to be modified, and it can be solved by marking the placeholder parameters.

节点日期不统一、难修改的问题,通过日期参数化予以解决。通过日期参数,用户可以快速选择日期,以及统一替换模块中需要重复出现的日期。The problem that the node date is not uniform and difficult to modify is solved by parameterizing the date. Through date parameters, users can quickly select dates and uniformly replace dates that need to appear repeatedly in the module.

时间跨度计算不准确的问题,通过日期运算参数,以机器计算代替人工计算来解决。The problem of inaccurate time span calculation is solved by using machine calculation instead of manual calculation through date calculation parameters.

公式输入耗时耗力的问题,通过函数运算参数化来解决。施组文档统计运算部分手动输入和反复修改造成的错误,通过聚合运算参数化予以解决。The time-consuming and labor-intensive problem of formula input can be solved by parameterizing function operations. Errors caused by manual input and repeated modification of the statistical operation part of the group document are solved by parameterizing the aggregation operation.

用户自定义的参数的优点是一次填写后,可以在参数解析过程中将同样的内容重复使用到施组文档的不同部分,提高施组文档的编制速度和内容统一性。The advantage of user-defined parameters is that after filling in once, the same content can be reused in different parts of the group document during the parameter parsing process, which improves the compilation speed and content uniformity of the group document.

用户自定义的参数虽然也具有便于反复使用和调用的优点,但针对同一客观对象,不同用户定义的参数通常是不同的,这就造成了不同用户生成的施组文档的内容具有区别;系统定义参数中的文本内容参数则可以减少用户定义的参数,提高不同用户生成的施组文档的内容统一性。Although user-defined parameters also have the advantage of being easy to use and call repeatedly, but for the same objective object, the parameters defined by different users are usually different, which results in differences in the content of the group documents generated by different users; The text content parameter in the parameter can reduce the parameters defined by the user and improve the content uniformity of the group documents generated by different users.

本发明能够有效重复利用历史施组文档内容,一次编制工作中的成果可以在后续工程中方便地重复调用,提高编制施工组织设计文档的效率以及一致性。The invention can effectively reuse the content of historical construction documents, and the results of one compilation work can be conveniently called repeatedly in subsequent projects, thereby improving the efficiency and consistency of compilation of construction organization design documents.

附图说明Description of drawings

图1是施组参数化模块的结构示意图;Fig. 1 is a structural schematic diagram of a group parameterization module;

图2是水利工程施工方案智能化管理系统的原理示意图;Fig. 2 is a schematic diagram of the principle of the intelligent management system for the construction scheme of the water conservancy project;

图3是施工组织设计方法的流程图;Fig. 3 is the flowchart of construction organization design method;

图4是水利工程施工方案智能化管理系统的系统架构图。Figure 4 is a system architecture diagram of an intelligent management system for water conservancy project construction schemes.

具体实施方式Detailed ways

如图1至图4所示,本发明公开了一种水利工程施工方案智能化管理系统,将施工组织简称为施组;包括安装在本地计算机windows系统中的客户端和安装在服务器中的服务端(客户端和服务端都是程序),客户端包括桌面客户端(算力由本地计算机提供)和运行在浏览器中的WEB客户端;桌面客户端和WEB客户端均通过HTTP协议和服务与服务端相连接;采用VSTO插件将桌面客户端嵌入到Word(即微软Word程序)或WPS(即金山WPS程序)中;WEB客户端使用Vue3技术开发。桌面客户端具有新建施组文档、打开新建施组文档、编辑新建施组文档和保存新建施组文档的功能;As shown in Figures 1 to 4, the present invention discloses an intelligent management system for water conservancy project construction schemes, and the construction organization is referred to as a construction organization; it includes a client installed in a local computer windows system and a service installed in a server client (client and server are both programs), the client includes the desktop client (the computing power is provided by the local computer) and the WEB client running in the browser; both the desktop client and the WEB client use the HTTP protocol and service Connect with the server; use the VSTO plug-in to embed the desktop client into Word (that is, Microsoft Word program) or WPS (that is, Kingsoft WPS program); the WEB client is developed using Vue3 technology. The desktop client has the functions of creating a new construction document, opening a new construction document, editing a new construction document and saving a new construction document;

服务端具有数据库以及模板库,模板库用于存储用户预制的施组模板文档(施组模板文档用于规范文档样式,供生成施组文档时进行格式套用),The server has a database and a template library, and the template library is used to store user-prefabricated group template documents (the group template document is used to standardize the document style for format application when generating the group document),

数据库包括SqlServer数据库和ElasticSearch数据库;Databases include SqlServer database and ElasticSearch database;

SqlServer数据库包括SZBasic数据库和SZData数据库;SqlServer database includes SZBasic database and SZData database;

ElasticSearch数据库包括moduledata数据库;The ElasticSearch database includes the moduledata database;

SZBasic数据库用于存储与系统运行相关的基本表,包括与通用管理系统相关的用户数据、角色数据、部门数据、数据权限数据、操作权限数据、字典和流程数据;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, dictionaries and process data related to the general management system;

SZData数据库用于存储与施组数据相关的业务数据;包括施组分类数据、施组目录数据、施组模块数据和文档模板数据;施组模块数据是由用户制作的用于后期调用的文档片段;The SZData database is used to store business data related to group data; including group classification data, group directory data, group module data and document template data; group module data is document fragments made by users for later calls ;

moduledata数据库用于存储与施组数据相关的模块数据文档,其中包含由历史施组文档提取的文本;The moduledata database is used to store module data documents related to group data, which contains text extracted from historical group files;

桌面客户端中存储有由用户挑选的,用于生成施组文档的模块数据,桌面客户端具有施组参数化模块、参数化解析模块和文档生成模块;The desktop client stores module data selected by the user for generating group documents, and the desktop client has a group parameterization module, a parameterization analysis module and a document generation module;

服务端的业务程序模块包括文件数据接收及结构检查模块、重复率检查模块、存入数据库模块和大数据搜索模块;The business program modules on the server side include file data receiving and structure checking modules, repetition rate checking modules, storing in database modules and big data search modules;

施组参数化模块用于对现存的施组文档的文档内容进行参数化转换,将特定工程项目的相关信息通过参数替换制作成通用性更强的施组模块数据;The group parameterization module is used to parametrically transform the document content of the existing group documents, and make the relevant information of a specific project into more versatile group module data through parameter replacement;

文件数据接收及结构检查模块用于接收施组参数化模块生成的文件数据并对接收到的文件数据进行结构检查;The file data receiving and structure checking module is used to receive the file data generated by the group parameterization module and check the structure of the received file data;

重复率检查模块用于检查当前文档数据与历史施组文档的重复率;The repetition rate checking module is used to check the repetition rate between the current document data and the historical group documents;

存入数据库模块用于将重复率合格的数据根据数据类型存入相应的数据库中;The store in database module is used to store the data with qualified repetition rate into the corresponding database according to the data type;

大数据搜索模块用于响应来自桌面客户端或WEB客户端的搜索请求,在数据库中找到搜索请求的模块数据(即用户需要的模块数据);The big data search module is used to respond to the search request from the desktop client or WEB client, and find the module data of the search request (that is, the module data required by the user) in the database;

参数化解析模块用于响应桌面客户端用户生成施组文档的命令,根据当前文档结构中的文本节点中包含的参数化内容控件中的参数化属性,生成相应的内容并将生成的内容插入到当前文档中所述参数化内容控件所在位置,使生成的内容成为施组文档的组成部分;The parameterized parsing module is used to respond to the desktop client user's command to generate a group document, according to the parameterized attribute in the parameterized content control contained in the text node in the current document structure, generate the corresponding content and insert the generated content into The position of the parameterized content control described in the current document, so that the generated content becomes an integral part of the document;

文档生成模块用于生成最终的施工组织设计文档(即施组文档)。The document generating module is used to generate the final construction organization design document (namely construction document).

施组参数化模块包括填充文本参数化子模块、计算编号参数化子模块、日期参数化子模块、算术运算参数化子模块、日期运算参数化子模块、函数运算参数化子模块、聚合运算参数化子模块和JS脚本运算参数化子模块;The group parameterization module includes the filling text parameterization submodule, the calculation number parameterization submodule, the date parameterization submodule, the arithmetic operation parameterization submodule, the date operation parameterization submodule, the function operation parameterization submodule, and the aggregation operation parameter Parameterized sub-modules and JS script operation parameterized sub-modules;

填充文本参数化子模块用于在施组文档节点中生成填充文本参数内容控件;Fill text parameterization sub-module is used to generate fill text parameter content control in group document node;

计算编号参数化子模块用于在施组文档节点中生成计算编号参数内容控件;The calculation number parameterization sub-module is used to generate the calculation number parameter content control in the group document node;

日期参数化子模块用于在施组文档节点中生成日期参数内容控件;The date parameterization sub-module is used to generate date parameter content controls in the group document node;

算术运算参数化子模块用于在施组文档节点中生成算术运算参数内容控件;Arithmetic operation parameterization sub-module is used to generate arithmetic operation parameter content control in group document node;

日期运算参数化子模块用于在施组文档节点中生成日期运算参数内容控件;The date operation parameterization sub-module is used to generate the date operation parameter content control in the group document node;

函数运算参数化子模块用于在施组文档节点中生成函数运算参数内容控件;The function operation parameterization sub-module is used to generate the function operation parameter content control in the group document node;

聚合运算参数化子模块用于在施组文档节点中生成聚合运算参数内容控件;The aggregation operation parameterization sub-module is used to generate the aggregation operation parameter content control in the group document node;

JS脚本运算参数化子模块用于在施组文档节点中生成JS脚本运算参数内容控件;The JS script operation parameterization sub-module is used to generate the JS script operation parameter content control in the group document node;

参数化解析模块包括填充文本参数解析子模块、计算编号参数解析子模块、日期参数解析子模块、算术运算参数解析子模块、日期运算参数解析子模块、函数运算参数解析子模块、聚合运算参数解析子模块和JS脚本运算参数解析子模块;The parameterized parsing module includes filling text parameter parsing sub-module, calculation number parameter parsing sub-module, date parameter parsing sub-module, arithmetic operation parameter parsing sub-module, date computing parameter parsing sub-module, function computing parameter parsing sub-module, aggregate computing parameter parsing sub-module Submodule and JS script operation parameter parsing submodule;

(一)填充文本参数解析子模块:(1) Fill in the text parameter parsing submodule:

填充文本参数解析子模块用于处理施组文档中的填充文本参数内容控件,在填充文本参数内容控件所在施组文档位置填写文本;The filling text parameter parsing sub-module is used to process the filling text parameter content control in the group document, and fill in the text at the position of the group document where the filling text parameter content control is located;

填充文本参数解析子模块中,填充文本参数包括系统定义和用户自定义两种类型;In the filling text parameter parsing sub-module, filling text parameters include two types: system definition and user-defined;

系统定义参数包括标记占位参数和施工组织文档(即施组文档)中重复出现的文本内容参数;System-defined parameters include mark occupancy parameters and text content parameters that appear repeatedly in construction organization documents (i.e., construction group documents);

标记占位参数在文档模块结构列表中通常多次出现,通常内容并不具有重复性,标记占位参数用于指示用户填充该部分的内容,并在系统的参数列表中提供快速定位的功能(即根据标记占位参数快速定位到施组文档相应部分,由最终用户填充该部分内容),用户通过标记占位参数跳转到参数所在位置进行内容填写或修改;Mark placeholder parameters usually appear multiple times in the document module structure list, usually the content is not repetitive, mark placeholder parameters are used to instruct users to fill in the content of this part, and provide a quick positioning function in the system parameter list ( That is to quickly locate the corresponding part of the group document according to the mark placeholder parameter, and the end user fills in the content of this part), and the user jumps to the position of the parameter through the mark placeholder parameter to fill in or modify the content;

标记占位参数以外的填充文本参数为重复性内容参数,系统定义参数中的文本内容参数用于减少用户定义的填充文本参数从而提高施组文档内容的统一性;(用户自定义的参数虽然也具有便于反复使用和调用的优点,但针对同一客观对象,不同用户定义的参数通常是不同的,这就造成了不同用户生成的施组文档的内容具有区别;系统定义参数中的文本内容参数则可以减少用户定义的参数,提高不同用户生成的施组文档的内容统一性)系统定义参数不能满足需求的情况下,用户通过用户自定义的填充文本参数,使相应的重复性填充文本内容不需要反复人工填充;用户自定义的填充文本参数在参数列表中只统计一次,用户在参数列表中填写一次内容后在参数解析过程中统一应用该参数的内容;(用户自定义的参数的优点是一次填写后,可以在参数解析过程中将同样的内容重复使用到施组文档的不同部分,提高施组文档的编制速度和内容统一性)Filling text parameters other than mark placeholder parameters are repetitive content parameters, and the text content parameters in the system-defined parameters are used to reduce user-defined filling text parameters so as to improve the uniformity of group document content; (although user-defined parameters can also It has the advantage of being easy to use and call repeatedly, but for the same objective object, the parameters defined by different users are usually different, which causes the content of the group documents generated by different users to be different; the text content parameters in the system-defined parameters are User-defined parameters can be reduced, and the content uniformity of group documents generated by different users can be improved. If the system-defined parameters cannot meet the requirements, the user can use the user-defined filling text parameters to make the corresponding repetitive filling text content unnecessary. Repeated manual filling; user-defined filling text parameters are only counted once in the parameter list, and the content of the parameter is uniformly applied during the parameter parsing process after the user fills in the content in the parameter list once; (the advantage of user-defined parameters is After filling, the same content can be reused in different parts of the group document during the parameter parsing process to improve the compilation speed and content uniformity of the group document)

(二)计算编号参数解析子模块:(2) Calculation number parameter parsing sub-module:

计算编号参数解析子模块用于处理施组文档中的计算编号参数内容控件,在计算编号参数内容控件所在施组文档位置根据文档模块结构组成填写编号,并避免手动输入和反复修改造成的人为错误,实现模块数据自动计算;The calculation number parameter parsing sub-module is used to process the calculation number parameter content control in the application group document, fill in the number according to the structure of the document module in the location of the calculation number parameter content control in the application group document, and avoid human errors caused by manual input and repeated modification , to realize automatic calculation of module data;

使用最多的编号是段落前编号,文本节点作为标题节点的子节点编号需要根据父节点的编号确定自身的编号;The most used number is the number before the paragraph, and the number of the child node of the text node as the title node needs to determine its own number according to the number of the parent node;

文档节点的增加级别属性用于确定从父节点增加的级别,如果父节点的级别和子节点的级别不连续,则在参数解析的过程中需要给予用户提示,例如可以在编号参数内容控件后生成一段高亮文本的方式提示用户。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 discontinuous, the user needs to be prompted during the parameter parsing process. For example, a paragraph can be generated after the number parameter content control Prompt the user by highlighting text.

一篇完整的施工组织文档(即施组文档)所采用的编号规则是统一的,计算编号参数的编号计算规则是根据施组文档大纲编号窗口中定义的规则所确定的,可以预先规定在模板文件中或者系统数据库中,也可以由用户自定义。The numbering rules adopted by a complete construction organization document (i.e. construction group document) are unified, and the numbering calculation rules for calculating the numbering parameters are determined according to the rules defined in the construction group document outline numbering window, which can be pre-specified in the template In the file or in the system database, it can also be customized by the user.

计算编号参数解析子模块在解析的过程中根据父节点和增加级别所确定得到的编号参数化内容控件所在位置的编号级别,根据级别自动采用相应的计算规则并生成编号参数;In the parsing process, the calculation numbering parameter parsing sub-module will automatically adopt corresponding calculation rules and generate numbering parameters according to the numbering level of the location of the numbering parameterized content control determined by the parent node and the added level;

具体地,编号参数根据计算编号内容控件结合编号规则生成文档编号;计算编号参数解析子模块的输入参数为父节点Id和编号参数中要增加的级别;解析时,首先是计算编号参数解析子模块计算出施组文档结构中所有仅标题节点的CascadeId(CascadeId的组成为根节点从0开始编号为“.0.”,后续级别从1开始编号,如1级标题编号为“.0.1.”,依次类推)。解析模块根据编号参数Id找到父节点的CascadeId,然后找到施组文档编号规则中该级别所对应规则的匹配正则表达式,计算匹配结果并附加增加级别作为当前编号参数的CascadeId,增加级别大于1的需要将上一级内容控件中编号参数的CascadeId作为起始计算的CascadeId,通过调用编号规则中替换表达式确定最终要作为编号的CascadeId分段,然后解析模块根据该分段套用不同的转换规则生成编号,将生成的编号作为输出结果,最后使用输出结果替换内容控件所在的Range文本作为编号。Specifically, the numbering parameter generates a document number according to the calculation numbering content control combined with the numbering rule; the input parameter of the calculation numbering parameter analysis submodule is the parent node Id and the level to be added in the numbering parameter; when parsing, the first is the calculation numbering parameter analysis submodule Calculate the CascadeId of all title-only nodes in the group document structure (the composition of CascadeId is that the root node is numbered ".0." from 0, and the subsequent levels are numbered from 1. For example, the title number of level 1 is ".0.1.", And so on). The parsing module finds the CascadeId of the parent node according to the number parameter Id, and then finds the matching regular expression of the rule corresponding to the level in the group document numbering rules, calculates the matching result and adds the CascadeId with an increased level as the current number parameter, and the CascadeId with an increased level greater than 1 It is necessary to use the CascadeId of the numbering parameter in the upper-level content control as the CascadeId for the initial calculation, and determine the final CascadeId segment to be used as the number by calling the replacement expression in the numbering rule, and then the parsing module applies different conversion rules to generate according to the segment Number, use the generated number as the output result, and finally use the output result to replace the Range text where the content control is located as the number.

(三)日期参数解析子模块:(3) Date parameter parsing sub-module:

日期参数解析子模块用于处理施组文档中的日期参数内容控件,在日期参数内容控件所在施组文档位置填写日期,并避免手动输入和反复修改造成的人为错误,实现模块数据自动计算;日期相同的日期参数内容控件具有相同的唯一值;日期参数的解析在套用施组模板文档格式之前进行;The date parameter parsing sub-module is used to process the date parameter content control in the group document, fill in the date in the position of the group document where the date parameter content control is located, and avoid human errors caused by manual input and repeated modification, and realize automatic calculation of module data; date The same date parameter content controls have the same unique value; the parsing of the date parameter is performed before applying the template document format;

通过日期参数,用户可以快速选择日期,以及统一替换模块中需要重复出现的日期;Through the date parameter, the user can quickly select the date and uniformly replace the date that needs to appear repeatedly in the module;

(四)算术运算参数解析子模块:(4) Arithmetic operation parameter parsing sub-module:

算术运算参数解析子模块的作用是处理施组文档中的算术运算参数内容控件,在算术运算参数内容控件所在施组文档位置填写相应公式及计算结果,并避免手动输入和反复修改造成的人为错误,自动实现模块数据计算;The function of the arithmetic operation parameter parsing sub-module is to process the content control of the arithmetic operation parameter in the group document, fill in the corresponding formula and calculation results in the position of the group document where the content control of the arithmetic operation parameter is located, and avoid human errors caused by manual input and repeated modification , automatically realize module data calculation;

算术运算参数的属性包含成员和结果;The properties of arithmetic operation parameters include members and results;

支持的运算符包含加减乘除等常规运算符,同一个算式的算术运算参数具有相同的唯一值,算术运算符保存在属性为结果的算术运算参数中;The supported operators include conventional operators such as addition, subtraction, multiplication, and division. The 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;

算术运算参数解析子模块在解析算术运算参数时,首先寻找施组文档节点内容中的算术运算参数内容控件,并根据算术运算参数内容控件属性的唯一值将算术运算参数内容控件分组,唯一值相同的分为一组;When parsing the arithmetic operation parameters, the arithmetic operation parameter parsing sub-module first looks for the arithmetic operation parameter content controls in the group document node content, and groups the arithmetic operation parameter content controls according to the unique value of the arithmetic operation parameter content control attribute, and the unique values are the same grouped into groups;

算术运算参数的解析在套用施组模板文档格式之前,算术运算的结果包含格式化字符串,将用户由运算产生的结果,按照预定的输出精度输出成指定的文本格式;Arithmetic operation parameter analysis Before applying the group template document format, the result of the arithmetic operation contains a formatted string, and the result generated by the user's operation is output into the specified text format according to the predetermined output precision;

用户寻找结果参数时,算术运算参数解析子模块根据结果参数的唯一值,查找相应的算术成员参数,根据用户在成员参数控件中输入的值计算相应的结果并自动填写在结果参数的文档控件中。When the user searches for the result parameter, the arithmetic operation parameter parsing sub-module searches for the corresponding arithmetic member parameter according to the unique value of the result parameter, calculates the corresponding result according to the value entered by the user in the member parameter control, and automatically fills it in the document control of the result parameter .

算术运算参数解析子模块根据结果控件中的用户定义的计算规则生成结算结果;该算术运算参数解析子模块在解析时的输入参数为一组算术参数内容控件;The arithmetic operation parameter parsing sub-module generates settlement results according to the calculation rules defined by the user in the result control; the input parameters of the arithmetic operation parameter parsing sub-module during parsing are a set of arithmetic parameter content controls;

详细的解析过程为算术运算参数解析子模块首先将该组内容控件根据算术参数唯一值分为不同的组,每组作为一个计算单元;从该组中根据算术参数属性枚举值区分出结果参数和成员参数;遍历成员参数中“变量名”属性字段的值并使用“,”分割,组合成一个字符串;该字符串作为JavaScript函数的形参;然后根据使用同样的方法将参数内容控件中输入的值组合成一个字符串作为调用JavaScript函数的实参;为防止脚本执行时参数类型的隐式转换导致运算出错,将所述函数包装放在一个无参函数中,从无参函数内部调用有参函数并返回该内部函数执行结果。使用Microsoft.ClearScript生成一个动态的脚本函数,并执行该函数;将函数执行的结果作为结果参数控件的Range文本。The detailed parsing process is that the arithmetic operation parameter parsing sub-module first divides the group of content controls into different groups according to the unique value of the arithmetic parameter, and each group is used as a calculation unit; from this group, the result parameter is distinguished according to the enumeration value of the arithmetic parameter attribute and member parameters; traverse the value of the "variable name" attribute field in the member parameters and use "," to split, and combine into a string; the string is used as the formal parameter of the JavaScript function; The input value is combined into a string as the actual parameter to call the JavaScript function; in order to prevent the implicit conversion of the parameter type when the script is executed and cause an operation error, the function is wrapped in a no-argument function and called from within the no-argument function A function with parameters and returns the execution result of the inner function. Use Microsoft.ClearScript to generate a dynamic script function and execute the function; use the result of function execution as the Range text of the result parameter control.

(五)日期运算参数解析子模块:(5) Date operation parameter parsing sub-module:

日期运算参数解析子模块的作用是处理施组文档中的日期运算参数内容控件,进行时间跨度的计算,避免手动计算产生的错误,并在施组文档中的日期运算参数内容控件所在位置填写计算结果;The function of the date operation parameter parsing sub-module is to process the date operation parameter content control in the group document, calculate the time span, avoid errors caused by manual calculation, and fill in the calculation at the location of the date operation parameter content control in the group document result;

日期运算参数包括日期操作数1、日期操作数2和结果;结果为日期操作数1代表的日期与日期操作数2代表的日期之间的天数;Date operation parameters include date operand 1, date operand 2 and result; the result is the number of days between the date represented by date operand 1 and the date represented by date operand 2;

同一个日期对应的日期操作数使用相同的唯一值标识;Date operands corresponding to the same date are identified by the same unique value;

日期运算的结果内容控件中包含运算操作符用于时间跨度运算。日期运算参数对于同一个运算在参数列表中以一行的形式显示;The result content control of the date operation contains operation operators for time span operation. Date operation parameters are displayed in a row in the parameter list for the same operation;

通过参数列表可以快速定位到参数控件的所在的施组文档位置;日期运算参数的解析在套用施组模板文档格式之前;Through the parameter list, you can quickly locate the group document location where the parameter control is located; the date operation parameters are parsed before applying the group template document format;

(六)函数运算参数解析子模块:(6) Function operation parameter parsing sub-module:

函数运算参数解析子模块的作用是处理施组文档中的函数运算参数内容控件,在函数运算参数内容控件所在施组文档位置填写相应公式;The function of the function operation parameter parsing sub-module is to process the function operation parameter content control in the application group document, and fill in the corresponding formula in the location of the application group document where the function operation parameter content control is located;

函数运算参数化的属性包含函数的参数组成,用户为各函数运算参数输入对应的值,函数参数在解析的过程中首先是由文档处理程序(如Word即微软的word程序或WPS即金山WPS程序)在后台开启一个进程,将公式的内容输出到该施组文档中,然后替换其中的参数完成计算,并将产生的临时文件保存插入到函数运算参数内容控件的位置作为施组文档的一部分;函数运算参数的解析在套用施组模板文档格式之前;The parameterized attribute of the function operation consists of the parameters of the function. The user enters the corresponding value for each function operation parameter. In the process of parsing the function parameters, the document processing program (such as Word is Microsoft’s word program or WPS is the Kingsoft WPS program) ) starts a process in the background, outputs the content of the formula to the group document, then replaces the parameters in it to complete the calculation, and saves the generated temporary file and inserts it into the position of the function operation parameter content control as a part of the group document; The parsing of function operation parameters is before applying the group template document format;

(七)聚合运算参数解析子模块:(7) Aggregation operation parameter parsing sub-module:

聚合运算参数解析子模块的作用是处理施组文档中的聚合运算参数内容控件,在聚合运算参数内容控件所在施组文档位置填写相应解析结果;The role of the aggregation operation parameter parsing sub-module is to process the aggregation operation parameter content control in the group document, and fill in the corresponding analysis results in the location of the group document where the aggregation operation parameter content control is located;

聚合运算参数化用于施组文档中统计运算的生成,减少手动操作输入和多次修改可能发生的错误,Aggregation operation parameterization is used to generate statistical operations in group documents, reducing errors that may occur in manual operation input and multiple modifications,

聚合运算参数包含操作数参数和结果参数;Aggregation operation parameters include operand parameters and result parameters;

聚合运算参数的操作数参数包括多个操作数参数控件;聚合运算的运算规则预存在结果参数内容控件中;结果参数内容控件提供了多种现有且常用的聚合运算规则,聚合运算参数解析子模块在施组文档解析生成的过程中根据结果参数的唯一值属性找到所有相关的操作数参数并应用预存在结果参数内容控件中的计算规则生成最终的运算结果;聚合运算的参数化解析在套用施组模板文档格式之前;The operand parameter of the aggregation operation parameter includes multiple operand parameter controls; the operation 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, and the aggregation operation parameter parser In the process of parsing and generating the group document, the module finds all relevant operand parameters according to the unique value attribute of the result parameter and applies the calculation rules pre-existed in the content control of the result parameter to generate the final operation result; the parameterized analysis of the aggregation operation is applied Before applying the group template document format;

本实施例中,聚合运算参数解析子模块根据聚合运算参数分组中多个内容控件的值运算并完成表格统计值的填充。函数运算参数解析子模块中内置了一系列施工组织设计中常用的公式,例如混凝土配合比的计算公式。聚合运算参数解析子模块参数解析的输入参数为公式中相关参数的值以及用户选用的公式;聚合运算参数解析子模块计算出的结果输出一个临时Word文档,最终由VSTO插件将该临时文档的内容插入到所述聚合运算参数内容控件的位置作为整体施组文档的一部分。In this embodiment, the aggregation operation parameter parsing sub-module operates according to the values of multiple content controls in the aggregation operation parameter group and completes the filling of table statistics. A series of formulas commonly used in construction organization design are built in the function operation parameter analysis sub-module, such as the calculation formula of concrete mix ratio. The input parameters of the parameter analysis sub-module of the aggregation operation parameter analysis are the values of the relevant parameters in the formula and the formula selected by the user; the result calculated by the analysis sub-module of the aggregation operation parameter outputs a temporary Word document, and finally the content of the temporary document is output by the VSTO plug-in Inserted at the location of the aggregate operation parameter content control as part of the overall group document.

(八)JS脚本运算参数解析子模块:(8) JS script operation parameter parsing sub-module:

JS脚本运算参数解析子模块的作用是处理施组文档中的JS脚本运算参数内容控件,在JS脚本运算参数内容控件所在施组文档位置填写相应解析结果(计算结果为文字和/或图片);The role of the JS script operation parameter parsing sub-module is to process the content control of the JS script operation parameter in the application document, and fill in the corresponding analysis result (the calculation result is text and/or picture) in the location of the application document where the JS script operation parameter content control is located;

JS脚本运算参数化的目的是提升施组文档自动化处理能力,简化繁琐的外部文件操作过程,同时扩展VSTO插件的功能;The purpose of JS script operation parameterization is to improve the automatic processing ability of group documents, simplify the cumbersome external file operation process, and expand the functions of VSTO plug-ins;

JS脚本运算参数解析子模块通过VSTO插件附带的NodeJS模块执行参数属性中JavaScript脚本;所述VSTO插件中预置有用于导入外部文件的脚本,通过脚本自动导入外部文件数据并执行处理;The JS script operation parameter parsing submodule executes the JavaScript script in the parameter attribute through the NodeJS module attached to the VSTO plug-in; the script for importing external files is preset in the VSTO plug-in, and the external file data is automatically imported and processed by the script;

JS脚本运算参数解析子模块将脚本执行处理的结果输出为文本或图片,作为内容插入到当前施组文档中JS脚本运算参数内容控件所在位置作为施组文档内容的组成部分;The JS script operation parameter parsing sub-module outputs the result of script execution processing as text or picture, and inserts it as content into the current group document at the location of the JS script operation parameter content control as an integral part of the group document content;

Js脚本运算参数的解析在施组文档应用样式模板之前。Js script operation parameters are parsed before applying style templates to group documents.

用户可以选择执行VSTO插件中预置的脚本,也可自己编写要执行的脚本内容。JS脚本运算参数内容控件中的内容插入到施组文档中的方式,用户可以选择作为纯文本插入、作为文本段落插入或作为图片插入。在施组文档参数解析的过程中VSTO插件将执行Js脚本运算参数中的脚本代码将脚本运算的结果输出为文本或图片形式,最终合并内容到Js脚本运算参数控件所在的位置,在解析后,当前的脚本参数控件将从文中删除。Js脚本运算参数在参数列表中通过鼠标双击可以快速定位到参数控件所在的位置。Users can choose to execute the scripts preset in the VSTO plug-in, or they can write the script content to be executed by themselves. The method of inserting the content in the JS script operation parameter content control into the group document, the user can choose to insert as plain text, as a text paragraph or as a picture. In the process of parsing the parameters of the group document, the VSTO plug-in will execute the script code in the Js script operation parameter, output the result of the script operation in the form of text or image, and finally merge the content to the position where the Js script operation parameter control is located. After parsing, The current script parameter control will be removed from the text. Js script operation parameters can quickly locate the position of the parameter control by double-clicking the mouse in the parameter list.

具体的,本实施例中JS脚本运算参数通过NodeJS运行JS脚本代码调用外部文件运算完成xlsx、cad等文件的调用,将调用生成的数据作为运算的结果以文字或图片的形式插入到施组文档中。JS脚本运算参数解析子模块参数解析的输入参数为要执行的JS脚本,被操作文件的位置以及Excel文件内容的区域。JS脚本运算参数解析子模块的输出内容为文本或图片文件,最终由VSTO插件将生成的内容插入到施组文档中作为施组文档的一部分。Specifically, in this embodiment, the JS script operation parameters run the JS script code through NodeJS to call the external file operation to complete the call of files such as xlsx, cad, etc., and insert the data generated by the call into the group document in the form of text or pictures as the result of the operation middle. The input parameters of the JS script operation parameter analysis sub-module parameter analysis are the JS script to be executed, the location of the operated file and the content area of the Excel file. The output content of the JS script operation parameter parsing sub-module is a text or image file, and finally the VSTO plug-in will insert the generated content into the construction document as a part of the construction document.

计算编号参数解析子模块生成的编号参数具有缩进属性,缩进属性用于确定编号所在段落的段首空格数量;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 numbering is located;

编号缩进属性的实现需要在施组文档套用样式模板后再调用计算编号参数的缩进量设置段落缩进,因此,编号参数化内容控件在解析完成后不能删除。计算编号参数的段落缩进实现应放在施组文档整体应用样式之后实现,之后才能在施组文档中删除编号参数化内容控件。The implementation of the numbering indentation property needs to call the calculation of the indentation of the numbering parameter to set the paragraph indentation after applying the style template to the group document. Therefore, the numbering parameterized content control cannot be deleted after the parsing is completed. The implementation of the paragraph indent calculation of the numbering parameter should be implemented after the overall application style of the group document, and then the numbering parameterized content control can be deleted in the group document.

日期运算的结果提供日期格式化选项,用于将日期格式化成用户指定的显示形式。(如年月日或日月年,汉字或阿拉伯数字)The result of the date operation provides a date formatting option, which is used to format the date into a user-specified display form. (such as year month day or day month year, Chinese characters or Arabic numerals)

在参数列表中,唯一值相同的日期参数(日期参数解析子模块中的日期参数)只列出一个,唯一值不同的日期参数分别列出,通过在日期参数列表中填写日期,快速替换施组文档中所有日期参数内容控件中的日期参数值。In the parameter list, only one date parameter with the same unique value (the date parameter in the date parameter parsing submodule) is listed, and the date parameters with different unique values are listed separately. By filling in the date in the date parameter list, the group can be quickly replaced The date parameter value in all date parameter content controls in the document.

具体地,填充文本参数和日期参数根据参数管理模块的值和格式生成一段文本;该参数解析的输入参数为当前要解析的参数化内容控件,解析过程为查找用户在填充选项窗口中输入的值,套用附加在参数化控件中的格式化字符串规则将生成的字符串作为输出结果,最后使用该输出结果作为当前内容控件的Range文本。Specifically, fill the text parameter and date parameter to generate a piece of text according to the value and format of the parameter management module; the input parameter parsed by this parameter is the parameterized content control to be parsed currently, and the parsing process is to find the value entered by the user in the fill option window , apply the formatting string rules attached to the parameterized control to use the generated string as the output result, and finally use the output result as the Range text of the current content control.

本发明还公开了采用上述水利工程施工方案智能化管理系统进行的施工组织设计方法,按以下步骤进行:The present invention also discloses a construction organization design method carried out by adopting the intelligent management system of the construction plan of the water conservancy project, which is carried out according to the following steps:

第一步骤是制作施组模板文档;The first step is to make a group template document;

第二步骤是新建施组文档节点并参数化;The second step is to create a new construction 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 (construction group document).

第一步骤具体是:用户在Word中制作施组模板文档,用于规范施组文档样式;用户将施组模板文档上传到服务器的模板库中,供第四步骤中套用模板格式;The first step is specifically: the user makes a group template document in Word, which is used to standardize the style of the group document; the user uploads the group template document to the template library of the server for applying the template format in the fourth step;

施组模板文档包括投标类施组模板文档和实施类施组模板文档;The construction template document includes the bidding class construction template document and the implementation class construction group template document;

施组模板文档的作用是提供结构模板,用于将节点组成一篇施工组织设计的半成品施组文档,减少用户手动补充内容的工作量;The role of the construction template document is to provide a structural template for combining nodes into a semi-finished construction document for construction organization design, reducing the workload of users to manually supplement content;

施组模板文档可由管理员用户制作多篇模板,节点的数据类型分为纯文本、Word文档和模块数据ID三种类型;The group template document can be made by the administrator user to create multiple templates, and the data types of the nodes are divided into three types: plain text, Word document and module data ID;

第二步骤具体是:新建施组文档节点的属性分为无属性、可变属性、固属性定和充填属性共4种属性;The second step is specifically: the attributes of the newly created group document node are divided into four attributes: no attribute, variable attribute, fixed attribute and filling attribute;

固定属性的节点内容是独立于一类施工组织设计的通用内容,不需要用户补充;The node content of fixed attributes is a general content independent of a class of construction organization design, and does not need to be supplemented by users;

可变属性的节点内容中具有一部分不需要用户完善的独立于一类施工组织设计的通用内容,用户根据当前项目的具体情况完善可变属性的节点内容;可变属性的节点内容的灵活性大于固定属性的节点内容并小于充填属性的节点内容;The node content of variable attributes has a part of the general content independent of a class of construction organization design that does not need to be completed by the user. The user completes the node content of variable attributes according to the specific situation of the current project; the flexibility of the node content of variable attributes is greater than that of The node content of the fixed attribute is smaller than the node content of the filling attribute;

充填属性的节点内容中没有独立于一类施工组织设计的通用内容,用户据当前项目的具体情况填写充填属性的节点内容;There is no general content in the node content of the filling attribute that is independent of a class of construction organization design, and the user fills in the node content of the filling attribute according to the specific situation of the current project;

用户通过桌面客户端新建施组文档的过程中,桌面客户端解析施组模板文档中的节点生成文本节点;When the user creates a group document through the desktop client, the desktop client parses the nodes in the group template document to generate a text node;

对施组文档节点参数化具体是:利用填充文本参数化子模块在施组文档节点中生成填充文本参数内容控件;Parameterizing the group document node is specifically: using the filling text parameterization sub-module to generate a filling text parameter content control in the group document node;

利用计算编号参数化子模块在施组文档节点中生成计算编号参数内容控件;Use the calculation number parameterization sub-module to generate the calculation number parameter content control in the group document node;

利用日期参数化子模块在施组文档节点中生成日期参数内容控件;Use the date parameterization sub-module to generate a date parameter content control in the group document node;

利用算术运算参数化子模块在施组文档节点中生成算术运算参数内容控件;Use the arithmetic operation parameterization sub-module to generate the arithmetic operation parameter content control in the group document node;

利用日期运算参数化子模块在施组文档节点中生成日期运算参数内容控件;Use the date operation parameterization sub-module to generate the date operation parameter content control in the group document node;

利用函数运算参数化子模块在施组文档节点中生成函数运算参数内容控件;Use the function operation parameterization sub-module to generate the function operation parameter content control in the group document node;

利用聚合运算参数化子模块在施组文档节点中生成聚合运算参数内容控件;Use the aggregation operation parameterization sub-module to generate the aggregation operation parameter content control in the group document node;

利用JS脚本运算参数化子模块在施组文档节点中生成JS脚本运算参数内容控件;Use the JS script operation parameterization sub-module to generate the JS script operation parameter content control in the group document node;

如图2所示,本发明的水利工程施工方案智能化管理系统包括施组参数化模块,通过创建参数面板在文档中创建对应的参数内容控件后,通过参数属性调整对应的参数组成细节,最后通过分离选中的块将准备好的部分从原文档中分离出来作为单独的文件。其中不包含大纲正文的结构的数据作为文本数据,包含大纲节点和正文的文件可作为树形节点。As shown in Figure 2, the water conservancy project construction plan intelligent management system of the present invention includes a group parameterization module, after creating the corresponding parameter content control in the document by creating the parameter panel, adjusting the corresponding parameter composition details through the parameter attribute, and finally Separate the prepared part from the original document as a separate file by detaching the selected block. The data that does not contain the structure of the outline text is used as text data, and the file that contains the outline node and the text can be used as a tree node.

第三步骤具体是:在第二步骤完成后,用户通过编辑命令,补充填写施组文档节点的内容;The third step is specifically: after the second step is completed, the user supplements and fills in the content of the group document node through the editing command;

(一)通过文件数据接收及结构检查模块检查当前文档数据的结构,用户对于检查合格的当前文档进行重复率检查;(1) Check the structure of the current document data through the document data receiving and structure checking module, and the user checks the repetition rate of the current document that passes the check;

将分离的模块文件通过web客户端上传至服务端(服务器)之后,验证文档的结构。Word文档包含doc格式和docx格式。由于Word和WPS所支持的文档格式并不相同,WPS所保存的WPS文档使用Word无法打开,因此服务端将用户上传的文档统一转换为两种办公软件所兼容的格式,该步骤通过Aspose.Words(Aspose.Words是一款先进的类库,可以在各个应用程序中执行各种文档处理任务,支持DOC等格式文件,使用它不必打开word程序)将文档统一转换为可以兼容两种办公软件Word和WPS的docx格式。通过Aspose.Words抽取文档的大纲节点层次级别,验证是否符合连续性的节点要求。After uploading the separated module files to the server (server) through the web client, verify the structure of the document. Word documents include doc format and docx format. Since the document formats supported by Word and WPS are not the same, the WPS document saved by WPS cannot be opened by Word, so the server converts the document uploaded by the user into a format compatible with the two office software. This step is through Aspose.Words (Aspose.Words is an advanced class library that can perform various document processing tasks in various applications, supports DOC and other format files, and does not need to open the word program to use it) Unified conversion of documents to compatible with two office software Word and WPS in docx format. Extract the outline node hierarchy level of the document through Aspose.Words, and verify whether the node requirements of continuity are met.

(二)通过重复率检查模块检查当前文档数据与历史施组文档的重复率;用户将重复率合格的当前文档存入数据库,具体是将原文档存入SZData数据库并将抽取的纯文本存入moduledata数据库;(2) Check the repetition rate of the current document data and historical documents through the repetition rate checking module; the user saves the current document with a 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;

更具体是,对于验证通过的文档,提取文档中所有的文本,通过比对文本计算该文档和库中已有文档纯文本的重复率。对于重复率超过阈值的文档将提示用户库中已存在内容相似的文档,并询问用户是否要继续插入文档,用户选择插入文档后,首先将文档和用户提交表单存入SZBasic数据库中的模块数据请求流程数据表中,该流程经过管理员审批通过后,将文档存入SZData数据库中的模块数据表中,同时使用Aspose.Words从文档中提取全文的纯文本,结合用户提交表单生成jsondoc存储到ElasticSearch的moduledata数据库中。More specifically, for a document that has passed the verification, all the 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 whose repetition rate exceeds the threshold, it will prompt the user that there are documents with similar content in the library, and ask the user whether to continue inserting the document. After the user chooses to insert the document, the document and the user submission form are first stored in the module data request in the SZBasic database. In the process data table, after the process is approved by the administrator, the document is stored in the module data table in the SZData database, and the plain text of the full text is extracted from the document using Aspose.Words, combined with the form submitted by the user to generate jsondoc and store it in ElasticSearch in the moduledata database.

如图2所示,本发明的水利工程施工方案智能化管理系统包括存入数据库模块,文档在执行存入数据库的动作中为了在后期能够快速检索模块数据,首先将模块数据保存到SqlServer数据库中。As shown in Figure 2, the water conservancy project construction plan intelligent management system of the present invention includes a database module, and the document is stored in the database in order to quickly retrieve the module data in the later stage, at first the module data is saved in the SqlServer database .

根据数据库返回的模块数据GUID(即全局唯一标识符)和模块数据信息中的文件名、关键词、用户名、文件纯文本、分类以及所在目录等构成一篇Json文档,然后通过NestJs框架将文档传输到ElasticSearch数据库中,通过IK Analyzer(基于JAVA开发的中文分词工具包)对相关的文本Json文档字段内容进行IKMaxword分词,并保存到模块数据对应的索引库中。According to the module data GUID (that is, the globally unique identifier) returned by the database and the file name, keywords, user name, file plain text, classification, and directory in the module data information, a Json document is formed, and then the document is uploaded through the NestJs framework Transfer to the ElasticSearch database, use IK Analyzer (a Chinese word segmentation toolkit developed based on JAVA) to perform IKMaxword word segmentation on the field content of the relevant text Json document, and save it in the index library corresponding to the module data.

对于文档的原始数据同样需要保存在数据库中,如果将文件直接作为vbinary数据保存到SqlServer数据库中则会引起表的体积过大,因此将文件作为二进制数据保存到单独的表中,该表和模块数据的信息表使用相同的GUID。这样当需要检索到原始文件数据时,可以通过GUID快速定位到模块数据的原始数据并返回给请求方(桌面客户端或WEB客户端)。The original data of the document also needs to be saved in the database. If the file is directly saved as vbinary data in the SqlServer database, the size of the table will be too large, so the file is saved as binary data in a separate table. The table and the module The info table for the data uses the same GUID. In this way, when the original file data needs to be retrieved, the original data of the module data can be quickly located through the GUID and returned to the requester (desktop client or WEB client).

(三)用户通过桌面客户端新建施组文档,调用填写好的各施组文档节点数据完善文档;完善的过程中用户通过大数据搜索模块找到用户需要的模块数据;(3) The user creates a new project group document through the desktop client, and calls the completed document node data of each project group document to complete the document; during the process of perfection, the user finds the module data that the user needs through the big data search module;

如图2所示,本发明的水利工程施工方案智能化管理系统包括大数据搜索模块,大数据搜索模块的目的是通过客户端或web客户端快速找到用户需要的模块数据,为了更快更准确的找到符合需要的数据。As shown in Figure 2, the water conservancy project construction plan intelligent management system 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 needed by the user through the client or web client, in order to be faster and more accurate to find the required data.

首先,应将数据按照公共类别和专业公共类别分类,在本实施例中提供了公共分类和建筑工程、市政工程、水利工程和公路工程等分类,并不排除在具体的专业工程类别中使用更多分类。First of all, the data should be classified according to public categories and professional public categories. In this embodiment, public categories and classifications such as construction engineering, municipal engineering, water conservancy engineering and highway engineering are provided, and it does not exclude the use of more specific professional engineering categories. Multiple categories.

分类提供增删改查的功能,用户可以对分类进行各种管理功能。每个分类下面设置相应的树形目录索引。Classification provides the function of adding, deleting, modifying and checking, and users can perform various management functions on the classification. Set the corresponding tree index under each category.

用户通过桌面客户端或WEB客户端输入关键词之后,服务端通过对关键词分词进行搜索,用户发送的请求中同时附带了用户所请求的模块目录。服务端通过ElasticSearch全文检索,首先通过模块目录确定查找范围,然后进行分词搜索找到相应的结果后,对找到的字段进行高亮化处理,再将结果返回请求的客户端。After the user enters keywords through the desktop client or WEB client, the server searches for the keywords by word segmentation, and the request sent by the user is accompanied by the module directory requested by the user. The server uses ElasticSearch full-text search, first determines the search scope through the module directory, and then performs a word segmentation search to find the corresponding results, then highlights the found fields, and then returns the results to the requesting client.

当用户请求将找到的模块数据插入到文档结构列表中时,对于文本型数据,桌面客户端直接将该模块数据解析为文本型节点插入到用户选中的标题节点下面。而对于树形节点,客户端需要将模块数据解析成标题节点和文本节点的集合,然后全部插入到用户选中的标题节点下面。客户端通过大纲节点所在的文档位置将模块数据分为若干个RangeScope,对于作为大纲节点的RangeScope,解析成标题节点。对于非大纲节点的RangeScope,解析成文本节点。然后通过循环递归将所有的节点插入到用户选择的标题节点下面作为当前节点的子节点。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 through the document location where the outline node is located, and parses the RangeScope as an outline node into a title node. For a RangeScope that is not an outline node, it is parsed as a text node. Then insert all the nodes under the title node selected by the user as the child nodes of the current node through loop recursion.

(四)用户通过参数化解析模块,根据当前文档结构中的文本节点中包含的参数化内容控件中的参数化属性,生成相应的内容并将生成的内容插入到当前文档中所述参数化内容控件所在位置,使生成的内容成为施组文档的组成部分;参数化内容控件中存储了参数化的属性;(4) The user uses the parameterized parsing module to generate corresponding content according to the parameterized properties in the parameterized content control contained in the text node in the current document structure and insert the generated content into the parameterized content in the current document The location of the control makes the generated content an integral part of the group document; the parameterized content control stores parameterized attributes;

在用户发出生成命令的时候,客户端通过调用参数化解析模块并结合参数化内容控件中的属性生成相应的内容并将该内容插入到内容控件所在的位置成为文档的组成部分。When the user issues a generating command, the client generates corresponding content by calling the parameterized parsing module and combining the attributes in the parameterized content control, and inserts the content into the position where the content control is located to become a component of the document.

对于单个内容控件参数,客户端仅需要处理当前的内容控件中保存的属性数据即可生成内容,对于多内容控件参数,客户端首先需要根据参数化控件的唯一值属性将参数化控件分组,然后读取和解析多个内容控件中保存的数据生成文档内容。For a single content control parameter, the client only needs to process the attribute data saved in the current content control to generate content. For multiple content control parameters, the client first needs to group the parameterized controls according to the unique value attribute of the parameterized control, and then Read and parse data stored in multiple content controls to generate document content.

其中,各种参数的识别和相关信息是将参数类序列化为一条Json字符串保存在内容控件的Tag属性中,通过序列化和反序列化识别内部信息。Among them, the identification and related information of various parameters 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.

具体包括:利用填充文本参数解析子模块,在填充文本参数内容控件所在施组文档位置填写系统定义类型的文本参数以及用户自定义的文本参数;Specifically include: use the filling text parameter parsing sub-module to fill in system-defined text parameters and user-defined text parameters in the location of the group document where the filling text parameter content control is located;

利用计算编号参数解析子模块在计算编号参数内容控件所在施组文档位置根据文档模块结构组成填写编号;Use the calculation number parameter parsing sub-module to fill in the number according to the structure of the document module at the position of the document where the calculation number parameter content control is located;

利用日期参数解析子模块在日期参数内容控件所在施组文档位置填写日期;Use the date parameter parsing sub-module to fill in the date in the document location where the date parameter content control is located;

利用算术运算参数解析子模块在算术运算参数内容控件所在施组文档位置填写相应公式及计算结果;Use the arithmetic operation parameter analysis sub-module to fill in the corresponding formula and calculation results in the location of the group document where the content control of the arithmetic operation parameter is located;

利用日期运算参数解析子模块在施组文档中的日期运算参数内容控件所在位置填写计算出的时间跨度结果(单位为天);Use the date operation parameter parsing sub-module to fill in the calculated time span result (in days) at the location of the date operation parameter content control in the group document;

利用函数运算参数解析子模块在函数运算参数内容控件所在施组文档位置填写相应公式;Use the function operation parameter parsing sub-module to fill in the corresponding formula in the location of the group document where the function operation parameter content control is located;

利用聚合运算参数解析子模块在聚合运算参数内容控件所在施组文档位置填写相应解析结果;Use the aggregation operation parameter parsing sub-module to fill in the corresponding analysis results in the group document where the aggregation operation parameter content control is located;

利用JS脚本运算参数解析子模块在JS脚本运算参数内容控件所在施组文档位置填写相应解析结果(计算结果为文字和/或图片);Use the JS script operation parameter parsing sub-module to fill in the corresponding analysis results (the calculation results are text and/or pictures) in the location of the document 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 the 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 through the document generation module Documentation (i.e. group documentation).

如图2所示,本发明的水利工程施工方案智能化管理系统包括文档生成模块,文档生成的操作包括选中节点及子节点生成,以及全部生成。选中节点及子节点生成的目的是减少生成内容的篇幅,帮助用户检查当前文档中可能出现的错误,在选中节点生成中同时也会解析文档中的参数化项。As shown in FIG. 2 , the intelligent management system of water conservancy project construction plan of the present invention includes a document generation module, and the operation of document generation includes the generation of selected nodes and sub-nodes, and all generation. The purpose of generating selected nodes and sub-nodes is to reduce the length of generated content and help users check possible errors in the current document. During the generation of selected nodes, parameterized items in the document will also be parsed.

如果解析的过程中生成内容不符合期望,用户可以通过对文本节点发出编辑指令,并将编辑过后的内容保存到文本节点中,其中文本节点和标题节点具有一系列可控制的属性。这些属性将影响内容的生成。全部生成将整个文档节点树生成一篇完整的Word文档,用户可对生成之后的文档进行后期各种操作继续完善文档的内容。If the content generated during the parsing process does not meet expectations, the user can issue an editing command to the text node and save the edited content to the text node, where the text node and title node have a series of controllable attributes. These attributes will affect the generation of content. Generate All generates a complete Word document from the entire document node tree, and users can perform various operations on the generated document to continue to improve the content of the document.

其中,施组模板文档列表由模板分类组成,将施组模板文档中存储的节点列表解析为DevExpress TreeList;施组模板文档中的节点解析成相应的标题节点和文本节点,服务器的详细模板定义TemplateDefine中包含具体的施组模板文档数据;Among them, the group template document list is composed of template categories, and the node list stored in the group template document is parsed into a DevExpress TreeList; the nodes in the template document are parsed into corresponding title nodes and text nodes, and the detailed template definition of the server is TemplateDefine Contains specific group template document data;

模块数据的三种形式纯文本、Word文档和模块数据ID经过解析统一应用施组模板文档的格式;The three forms of module data, plain text, Word document and module data ID, are analyzed and uniformly applied to the format of the group template document;

每个文本节点中存储的均为一篇docx格式的Word文档;将纯文本模块数据解析成Word文档形式。由于使用Word将纯文本整合成Word文档的形式效率低,速度慢,为了更快速的转换,本发明中使用OpenXML的方式,将纯文本分割成为文本段落然后作为段落插入到临时文档中,最后将临时文档保存到内存中,以字节的形式读取到文本节点的ByteData字段中,从而大大提升转移整合的速度。Word文档和模块数据ID形式通过连接服务端在线获取数据的形式获取施组文档数据并保存到文本节点中。Each text node stores a Word document in docx format; parses the plain text module data into a Word document. Due to the low efficiency and slow speed of using Word to integrate the plain text into a Word document, in order to convert more quickly, the OpenXML method is used in the present invention to segment the plain text into text paragraphs and then insert them into the temporary document as paragraphs, and finally Temporary documents are saved in memory and read into the ByteData field of the text node in the form of bytes, which greatly improves the speed of transfer integration. In the form of Word document and module data ID, the group document data is obtained by connecting to the server to obtain data online and saved in the text node.

桌面客户端中的施组文档节点数据保存到本地磁盘(硬盘)上,供用户随时再次打开文档使用。文档的保存功能使用SqlSugar将结构列表中的节点数据以表的形式保存到Sqlite数据库的形式实现,该文件中同时包含施组文档节点数据表、文档编号表、文档样式表和用户填充文本参数表。文档编号表中存储文档编号所使用的编号方法枚举,以及编号计算的正则表达式。文档样式表中存储用户选用的文档样式模板,用户填充文本参数表中包含文本参数中用户输入的信息及Js脚本参数中用户自定义脚本代码。The data of the document node 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 to the Sqlite database in the form of a table. The file also contains the group document node data table, document number table, document style sheet and user-filled text parameter table . The document number table stores the enumeration of the numbering method used by the document number and the regular expression for number calculation. The document style sheet stores the document style template selected by the user, and the user-filled text parameter table includes the information input by the user in the text parameter and the user-defined script code in the Js script parameter.

桌面客户端包含创建参数功能,其中创建参数列表中展示VSTO插件持的8种参数,用户在选择相应参数后根据需要修改参数相关配置属性。当用户发出确定命令时,客户端将在当前的Word文档中创建一个内容控件ContentControl,该内容控件的Tag属性中包含的JSON(JSON即JS对象简谱,是一种数据交换格式)字符串定义各种施组模块参数的信息。The desktop client includes the function of creating parameters. The list of creating parameters displays 8 kinds of parameters supported by the VSTO plug-in. After selecting the corresponding parameters, the user can modify the relevant configuration properties of the parameters as needed. When the user issues a confirmation command, the client will create a content control ContentControl in the current Word document, and the JSON (JSON is JS object short notation, which is a data exchange format) string contained in the Tag property of the content control defines each Information about the parameters of the plant group module.

桌面客户端中包含参数属性功能,参数属性使用ActionPanel的形式实现,参数属性面板用于调节施组参数的可配置属性。经过修改后的属性直接替换并保存到用户选中的内容控件中。The desktop client includes the parameter attribute function, which is implemented in the form of ActionPanel, and the parameter attribute panel is used to adjust the configurable attributes of the group parameters. The modified properties are directly replaced and saved to the content control selected by the user.

桌面客户端包含预定义项功能,其中施组文本参数包含系统配置和用户定义两种形式,用户定义的文本参数通过预定项管理,用户根据具体施工项目需要对文本参数增减项目,定义参数的类别名称、格式和参数展示方式。参数展示方式指代同一个文本参数是否在参数填充选项中多次展示。预定义项中同包含Js脚本参数用户定义功能,用户可根据具体施工项目需要该脚本内容进行修改管理并保存到本插件的用户配置文件中。The desktop client includes the function of predefined items, in which the group text parameters include two forms of system configuration and user definition. User-defined text parameters are managed through predefined items. Users can increase or decrease items of text parameters according to the needs of specific construction projects, and define the category of parameters Name, format, and parameter presentation. The parameter display mode refers to whether the same text parameter is displayed multiple times in the parameter filling option. The predefined items also include the user-defined function of Js script parameters. Users can modify and manage the script content according to the needs of specific construction projects and save it in the user configuration file of this plug-in.

桌面客户端包含填充选项功能,填充选项面板统计出所有施组文档节点中的施组参数化项,然后按照分类列出,当用户选定指定的分类时,填充面板中详细列出参数化项所在的节点和可配置的属性,当用户双击名称时,可以快速跳转到指定的内容控件所在位置。The desktop client includes the fill option function. The fill option panel counts all the parameterized items in the set document node, and then lists them by category. When the user selects the specified category, the parameterized items are listed in detail in the fill panel The node and configurable properties, when the user double-clicks the name, can quickly jump to the location of the specified content control.

如图4所示,本发明的水利工程施工方案智能化管理系统组成包含服务端,服务端采用.NetCore webapi方式开发,服务端使用nginx分发用户请求到指定的服务器。服务端的组成中表现层接受客户端的axios请求,并将请求初步处理后传到业务逻辑层,业务逻辑层结合数据连接层完成请求代码执行后,最终的请求结果以json方式回传到请求的客户端(桌面客户端或WEB客户端)中。As shown in Figure 4, the intelligent management system of the water conservancy project construction plan of the present invention includes a server, which is developed in the form of .NetCore webapi, and uses nginx to distribute user requests to designated servers. In the composition of the server, the presentation layer accepts the axios request from the client, and passes the request to the business logic layer after preliminary processing. After the business logic layer combines the data connection layer to complete the execution of the request code, the final request result is sent back to the requesting client in the form of JSON. client (desktop client or WEB client).

数据连接层所连接的数据库包含关系型数据库和非关系型数据库,The databases connected to the data connection layer include relational databases and non-relational databases.

关系型数据库使用SqlServer数据库,与系统运行相关的基本表存储在SZBasic数据库中,与施组相关的数据存储在SZData中,非关系型数据库中与施组数据相关的模块数据文档存储在ElasticSearch数据库中。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 group is stored in SZData, and the module data documents related to the group data in the non-relational database are stored in the ElasticSearch database .

本发明所述的参数化模块并不局限于应用在施工组织设计文档的编制的过程中,对于设计计算书类文档,专项方案的编制等等同样适用。The parametric module described in the present invention is not limited to be used in the preparation of construction organization design documents, and is also applicable to the preparation of design calculation documents, special schemes, and the like.

以上实施例仅用以说明而非限制本发明的技术方案,尽管参照上述实施例对本发明进行了详细说明,本领域的普通技术人员应当理解:依然可以对本发明进行修改或者等同替换,而不脱离本发明的精神和范围的任何修改或局部替换,其均应涵盖在本发明的权利要求范围当中。The above embodiments are only used to illustrate and not limit the technical solutions of the present invention. Although the present invention has been described in detail with reference to the above embodiments, those of ordinary skill in the art should understand that the present invention can still be modified or equivalently replaced without departing from it. Any modifications or partial replacements within the spirit and scope of the present invention shall fall within the scope of the claims of the present invention.

Claims (6)

1.水利工程施工方案智能化管理系统,将施工组织简称为施组;包括安装在本地计算机windows系统中的客户端和安装在服务器中的服务端,1. The intelligent management system of water conservancy project construction plan, the construction organization is referred to as the construction group; including the client installed in the local computer windows system and the server installed in the server, 客户端包括桌面客户端和运行在浏览器中的WEB客户端,桌面客户端和WEB客户端均通过HTTP协议与服务端相连接;其特征在于: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; it is characterized in that: 采用VSTO插件将桌面客户端嵌入到Word或WPS中;桌面客户端具有新建施组文档、打开新建施组文档、编辑新建施组文档和保存新建施组文档的功能;Use the VSTO plug-in to embed the desktop client into Word or WPS; the desktop client has the functions of creating a file, opening a file, editing a file and saving a file; 服务端具有数据库以及模板库,模板库用于存储用户预制的施组模板文档,The server has a database and a template library. The template library is used to store user-prefabricated group template documents. 数据库包括SqlServer数据库和ElasticSearch数据库;Databases include SqlServer database and ElasticSearch database; SqlServer数据库包括SZBasic数据库和SZData数据库;SqlServer database includes SZBasic database and SZData database; ElasticSearch数据库包括moduledata数据库;The ElasticSearch database includes the moduledata database; SZBasic数据库用于存储与系统运行相关的基本表,包括与通用管理系统相关的用户数据、角色数据、部门数据、数据权限数据、操作权限数据、字典和流程数据;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, dictionaries and process data related to the general management system; SZData数据库用于存储与施组数据相关的业务数据;包括施组分类数据、施组目录数据、施组模块数据和文档模板数据;施组模块数据是由用户制作的用于后期调用的文档片段;The SZData database is used to store business data related to group data; including group classification data, group directory data, group module data and document template data; group module data is document fragments made by users for later calls ; moduledata数据库用于存储与施组数据相关的模块数据文档,其中包含由历史施组文档提取的文本;The moduledata database is used to store module data documents related to group data, which contains text extracted from historical group files; 桌面客户端中存储有由用户挑选的,用于生成施组文档的模块数据,桌面客户端具有施组参数化模块、参数化解析模块和文档生成模块;The desktop client stores module data selected by the user for generating group documents, and the desktop client has a group parameterization module, a parameterization analysis module and a document generation module; 服务端的业务程序模块包括文件数据接收及结构检查模块、重复率检查模块、存入数据库模块和大数据搜索模块;The business program modules on the server side include file data receiving and structure checking modules, repetition rate checking modules, storing in database modules and big data search modules; 施组参数化模块用于对现存的施组文档的文档内容进行参数化转换,将特定工程项目的相关信息通过参数替换制作成通用性更强的施组模块数据;The group parameterization module is used to parametrically transform the document content of the existing group documents, and make the relevant information of a specific project into more versatile group module data through parameter replacement; 文件数据接收及结构检查模块用于接收施组参数化模块生成的文件数据并对接收到的文件数据进行结构检查;The file data receiving and structure checking module is used to receive the file data generated by the group parameterization module and check the structure of the received file data; 重复率检查模块用于检查当前文档数据与历史施组文档的重复率;The repetition rate checking module is used to check the repetition rate between the current document data and the historical group documents; 存入数据库模块用于将重复率合格的数据根据数据类型存入相应的数据库中;The store in database module is used to store the data with qualified repetition rate into the corresponding database according to the data type; 大数据搜索模块用于响应来自桌面客户端或WEB客户端的搜索请求,在数据库中找到搜索请求的模块数据;The big data search module is used to respond to the search request from the desktop client or WEB client, and find the module data of the search request in the database; 参数化解析模块用于响应桌面客户端用户生成施组文档的命令,根据当前文档结构中的文本节点中包含的参数化内容控件中的参数化属性,生成相应的内容并将生成的内容插入到当前文档中所述参数化内容控件所在位置,使生成的内容成为施组文档的组成部分;The parameterized parsing module is used to respond to the desktop client user's command to generate a group document, according to the parameterized attribute in the parameterized content control contained in the text node in the current document structure, generate the corresponding content and insert the generated content into The position of the parameterized content control described in the current document, so that the generated content becomes an integral part of the document; 文档生成模块用于生成最终的施工组织设计文档。The document generation module is used to generate the final construction organization design document. 2.根据权利要求1所述的水利工程施工方案智能化管理系统,其特征在于:2. The intelligent management system of water conservancy project construction scheme according to claim 1, characterized in that: 施组参数化模块包括填充文本参数化子模块、计算编号参数化子模块、日期参数化子模块、算术运算参数化子模块、日期运算参数化子模块、函数运算参数化子模块、聚合运算参数化子模块和JS脚本运算参数化子模块;The group parameterization module includes the filling text parameterization submodule, the calculation number parameterization submodule, the date parameterization submodule, the arithmetic operation parameterization submodule, the date operation parameterization submodule, the function operation parameterization submodule, and the aggregation operation parameter Parameterized sub-modules and JS script operation parameterized sub-modules; 填充文本参数化子模块用于在施组文档节点中生成填充文本参数内容控件;Fill text parameterization sub-module is used to generate fill text parameter content control in group document node; 计算编号参数化子模块用于在施组文档节点中生成计算编号参数内容控件;The calculation number parameterization sub-module is used to generate the calculation number parameter content control in the group document node; 日期参数化子模块用于在施组文档节点中生成日期参数内容控件;The date parameterization sub-module is used to generate date parameter content controls in the group document node; 算术运算参数化子模块用于在施组文档节点中生成算术运算参数内容控件;Arithmetic operation parameterization sub-module is used to generate arithmetic operation parameter content control in group document node; 日期运算参数化子模块用于在施组文档节点中生成日期运算参数内容控件;The date operation parameterization sub-module is used to generate the date operation parameter content control in the group document node; 函数运算参数化子模块用于在施组文档节点中生成函数运算参数内容控件;The function operation parameterization sub-module is used to generate the function operation parameter content control in the group document node; 聚合运算参数化子模块用于在施组文档节点中生成聚合运算参数内容控件;The aggregation operation parameterization sub-module is used to generate the aggregation operation parameter content control in the group document node; JS脚本运算参数化子模块用于在施组文档节点中生成JS脚本运算参数内容控件;The JS script operation parameterization sub-module is used to generate the JS script operation parameter content control in the group document node; 参数化解析模块包括填充文本参数解析子模块、计算编号参数解析子模块、日期参数解析子模块、算术运算参数解析子模块、日期运算参数解析子模块、函数运算参数解析子模块、聚合运算参数解析子模块和JS脚本运算参数解析子模块;The parameterized parsing module includes filling text parameter parsing sub-module, calculation number parameter parsing sub-module, date parameter parsing sub-module, arithmetic operation parameter parsing sub-module, date computing parameter parsing sub-module, function computing parameter parsing sub-module, aggregate computing parameter parsing sub-module Submodule and JS script operation parameter parsing submodule; (一)填充文本参数解析子模块:(1) Fill in the text parameter parsing submodule: 填充文本参数解析子模块用于处理施组文档中的填充文本参数内容控件,在填充文本参数内容控件所在施组文档位置填写文本;The filling text parameter parsing sub-module is used to process the filling text parameter content control in the group document, and fill in the text at the position of the group document where the filling text parameter content control is located; 填充文本参数解析子模块中,填充文本参数包括系统定义和用户自定义两种类型;In the filling text parameter parsing sub-module, filling text parameters include two types: system definition and user-defined; 系统定义参数包括标记占位参数和施工组织文档中重复出现的文本内容参数;System-defined parameters include mark occupancy parameters and text content parameters that appear repeatedly in construction organization documents; 标记占位参数用于指示用户填充该部分的内容,并在系统的参数列表中提供快速定位的功能,用户通过标记占位参数跳转到参数所在位置进行内容填写或修改;The mark placeholder parameter is used to instruct the user to fill in the content of this part, and provides a quick positioning function in the parameter list of the system. The user jumps to the position of the parameter through the mark placeholder parameter to fill in or modify the content; 标记占位参数以外的填充文本参数为重复性内容参数,系统定义参数中的文本内容参数用于减少用户定义的填充文本参数从而提高施组文档内容的统一性;系统定义参数不能满足需求的情况下,用户通过用户自定义的填充文本参数,使相应的重复性填充文本内容不需要反复人工填充;用户自定义的填充文本参数在参数列表中只统计一次,用户在参数列表中填写一次内容后在参数解析过程中统一应用该参数的内容;Filling text parameters other than mark placeholder parameters are repetitive content parameters, and text content parameters in system-defined parameters are used to reduce user-defined filling text parameters to improve the uniformity of document content; system-defined parameters cannot meet the requirements In this case, the user uses the user-defined filling text parameters, so that the corresponding repetitive filling text content does not need to be manually filled repeatedly; the user-defined filling 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; (二)计算编号参数解析子模块:(2) Calculation number parameter parsing sub-module: 计算编号参数解析子模块用于处理施组文档中的计算编号参数内容控件,在计算编号参数内容控件所在施组文档位置根据文档模块结构组成填写编号,并避免手动输入和反复修改造成的人为错误,实现模块数据自动计算;The calculation number parameter parsing sub-module is used to process the calculation number parameter content control in the application group document, fill in the number according to the structure of the document module in the location of the calculation number parameter content control in the application group document, and avoid human errors caused by manual input and repeated modification , to realize automatic calculation of module data; 计算编号参数解析子模块在解析的过程中根据父节点和增加级别所确定得到的编号参数化内容控件所在位置的编号级别,根据级别自动采用相应的计算规则并生成编号参数;In the parsing process, the calculation numbering parameter parsing sub-module will automatically adopt corresponding calculation rules and generate numbering parameters according to the numbering level of the location of the numbering parameterized content control determined by the parent node and the added level; (三)日期参数解析子模块:(3) Date parameter parsing sub-module: 日期参数解析子模块用于处理施组文档中的日期参数内容控件,在日期参数内容控件所在施组文档位置填写日期,并避免手动输入和反复修改造成的人为错误,实现模块数据自动计算;日期相同的日期参数内容控件具有相同的唯一值;日期参数的解析在套用施组模板文档格式之前进行;The date parameter parsing sub-module is used to process the date parameter content control in the group document, fill in the date in the position of the group document where the date parameter content control is located, and avoid human errors caused by manual input and repeated modification, and realize automatic calculation of module data; date The same date parameter content controls have the same unique value; the parsing of the date parameter is performed before applying the template document format; (四)算术运算参数解析子模块:(4) Arithmetic operation parameter parsing sub-module: 算术运算参数解析子模块的作用是处理施组文档中的算术运算参数内容控件,在算术运算参数内容控件所在施组文档位置填写相应公式及计算结果,并避免手动输入和反复修改造成的人为错误,自动实现模块数据计算;The function of the arithmetic operation parameter parsing sub-module is to process the content control of the arithmetic operation parameter in the group document, fill in the corresponding formula and calculation results in the position of the group document where the content control of the arithmetic operation parameter is located, and avoid human errors caused by manual input and repeated modification , automatically realize module data calculation; 算术运算参数的属性包含成员和结果;The properties of arithmetic operation parameters include members and results; 同一个算式的算术运算参数具有相同的唯一值,算术运算符保存在属性为结果的算术运算参数中;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; 算术运算参数解析子模块在解析算术运算参数时,首先寻找施组文档节点内容中的算术运算参数内容控件,并根据算术运算参数内容控件属性的唯一值将算术运算参数内容控件分组,唯一值相同的分为一组;When parsing the arithmetic operation parameters, the arithmetic operation parameter parsing sub-module first looks for the arithmetic operation parameter content controls in the group document node content, and groups the arithmetic operation parameter content controls according to the unique value of the arithmetic operation parameter content control attribute, and the unique values are the same grouped into groups; 算术运算参数的解析在套用施组模板文档格式之前,算术运算的结果包含格式化字符串,将用户由运算产生的结果,按照预定的输出精度输出成指定的文本格式;Arithmetic operation parameter analysis Before applying the group template document format, the result of the arithmetic operation contains a formatted string, and the result generated by the user's operation is output into the specified text format according to the predetermined output precision; (五)日期运算参数解析子模块:(5) Date operation parameter parsing sub-module: 日期运算参数解析子模块的作用是处理施组文档中的日期运算参数内容控件,进行时间跨度的计算,避免手动计算产生的错误,并在施组文档中的日期运算参数内容控件所在位置填写计算结果;The function of the date operation parameter parsing sub-module is to process the date operation parameter content control in the group document, calculate the time span, avoid errors caused by manual calculation, and fill in the calculation at the location of the date operation parameter content control in the group document result; 日期运算参数包括日期操作数1、日期操作数2和结果;结果为日期操作数1代表的日期与日期操作数2代表的日期之间的天数;Date operation parameters include date operand 1, date operand 2 and result; the result is the number of days between the date represented by date operand 1 and the date represented by date operand 2; 同一个日期对应的日期操作数使用相同的唯一值标识;Date operands corresponding to the same date are identified by the same unique value; 日期运算参数对于同一个运算在参数列表中以一行的形式显示;Date operation parameters are displayed in a row in the parameter list for the same operation; 通过参数列表可以快速定位到参数控件的所在的施组文档位置;日期运算参数的解析在套用施组模板文档格式之前;Through the parameter list, you can quickly locate the group document location where the parameter control is located; the date operation parameters are parsed before applying the group template document format; (六)函数运算参数解析子模块:(6) Function operation parameter parsing sub-module: 函数运算参数解析子模块的作用是处理施组文档中的函数运算参数内容控件,在函数运算参数内容控件所在施组文档位置填写相应公式;The function of the function operation parameter parsing sub-module is to process the function operation parameter content control in the application group document, and fill in the corresponding formula in the location of the application group document where the function operation parameter content control is located; 函数运算参数化的属性包含函数的参数组成,用户为各函数运算参数输入对应的值,函数参数在解析的过程中首先是由文档处理程序在后台开启一个进程,将公式的内容输出到该施组文档中,然后替换其中的参数完成计算,并将产生的临时文件保存插入到函数运算参数内容控件的位置作为施组文档的一部分;函数运算参数的解析在套用施组模板文档格式之前;The parameterized attribute of a function operation includes the parameters of the function. The user inputs the corresponding value for each function operation parameter. During the parsing process of the function parameter, a document processing program starts a process in the background first, and outputs the content of the formula to the implementation. In the group document, replace the parameters in it to complete the calculation, save and insert the generated temporary file into the position of the function operation parameter content control as a part of the group document; the parsing of the function operation parameter is before applying the group template document format; (七)聚合运算参数解析子模块:(7) Aggregation operation parameter parsing sub-module: 聚合运算参数解析子模块的作用是处理施组文档中的聚合运算参数内容控件,在聚合运算参数内容控件所在施组文档位置填写相应解析结果;The role of the aggregation operation parameter parsing sub-module is to process the aggregation operation parameter content control in the group document, and fill in the corresponding analysis results in the location of the group document where the aggregation operation parameter content control is located; 聚合运算参数包含操作数参数和结果参数;Aggregation operation parameters include operand parameters and result parameters; 聚合运算参数的操作数参数包括多个操作数参数控件;聚合运算的运算规则预存在结果参数内容控件中;聚合运算参数解析子模块在施组文档解析生成的过程中根据结果参数的唯一值属性找到所有相关的操作数参数并应用预存在结果参数内容控件中的计算规则生成最终的运算结果;聚合运算的参数化解析在套用施组模板文档格式之前;The operand parameter of the aggregation operation parameter includes 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 sub-module is based on the unique value attribute of the result parameter in the process of group document parsing and generation Find all relevant operand parameters and apply the calculation rules pre-stored in the result parameter content control to generate the final operation result; the parameterized analysis of the aggregation operation is before applying the group template document format; (八)JS脚本运算参数解析子模块:(8) JS script operation parameter parsing sub-module: JS脚本运算参数解析子模块的作用是处理施组文档中的JS脚本运算参数内容控件,在JS脚本运算参数内容控件所在施组文档位置填写相应解析结果;The function of the JS script operation parameter parsing sub-module is to process the JS script operation parameter content control in the application document, and fill in the corresponding analysis result in the location of the application document where the JS script operation parameter content control is located; JS脚本运算参数解析子模块通过VSTO插件附带的NodeJS模块执行参数属性中JavaScript脚本;所述VSTO插件中预置有用于导入外部文件的脚本,通过脚本自动导入外部文件数据并执行处理;The JS script operation parameter parsing submodule executes the JavaScript script in the parameter attribute through the NodeJS module attached to the VSTO plug-in; the script for importing external files is preset in the VSTO plug-in, and the external file data is automatically imported and processed by the script; JS脚本运算参数解析子模块将脚本执行处理的结果输出为文本或图片,作为内容插入到当前施组文档中JS脚本运算参数内容控件所在位置作为施组文档内容的组成部分;The JS script operation parameter parsing sub-module outputs the result of script execution processing as text or picture, and inserts it as content into the current group document at the location of the JS script operation parameter content control as an integral part of the group document content; Js脚本运算参数的解析在施组文档应用样式模板之前。Js script operation parameters are parsed before applying style templates to group documents. 3.根据权利要求2所述的水利工程施工方案智能化管理系统,其特征在于:3. The intelligent management system of water conservancy project construction scheme according to claim 2, characterized in that: 计算编号参数解析子模块生成的编号参数具有缩进属性,缩进属性用于确定编号所在段落的段首空格数量;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 numbering is located; 日期运算的结果提供日期格式化选项,用于将日期格式化成用户指定的显示形式。The result of the date operation provides a date formatting option, which is used to format the date into a user-specified display format. 4.根据权利要求2或3所述的水利工程施工方案智能化管理系统,其特征在于:4. The intelligent management system for water conservancy construction scheme according to claim 2 or 3, characterized in that: 在参数列表中,唯一值相同的日期参数只列出一个,唯一值不同的日期参数分别列出,通过在日期参数列表中填写日期,快速替换施组文档中所有日期参数内容控件中的日期参数值。In the parameter list, only one date parameter with the same unique value is listed, and the date parameters with different unique values are listed separately. By filling in the date in the date parameter list, you can quickly replace the date parameters in the content control of all date parameters in the group document value. 5.采用权利要求4中所述水利工程施工方案智能化管理系统进行的施工组织设计方法,其特征在于按以下步骤进行:5. adopt the construction organization design method carried out by the water conservancy project construction plan intelligent management system described in claim 4, it is characterized in that carry out by following steps: 第一步骤是制作施组模板文档;The first step is to make a group template document; 第二步骤是新建施组文档节点并参数化;The second step is to create a new construction 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 documents. 6.根据权利要求5所述的施工组织设计方法,其特征在于:6. The construction organization design method according to claim 5, characterized in that: 第一步骤具体是:用户在Word中制作施组模板文档,用于规范施组文档样式;用户将施组模板文档上传到服务器的模板库中,供第四步骤中套用模板格式;The first step is specifically: the user makes a group template document in Word to standardize the style of the group document; the user uploads the group template document to the template library of the server for applying the template format in the fourth step; 施组模板文档包括投标类施组模板文档和实施类施组模板文档;The construction template document includes the bidding class construction template document and the implementation class construction group template document; 施组模板文档的作用是提供结构模板,用于将节点组成一篇施工组织设计的半成品施组文档,减少用户手动补充内容的工作量;The role of the construction template document is to provide a structural template for combining nodes into a semi-finished construction document for construction organization design, reducing the workload of users to manually supplement content; 施组模板文档节点的数据类型分为纯文本、Word文档和模块数据ID三种类型;The data types of the group template document node are divided into three types: plain text, Word document and module data ID; 第二步骤具体是:新建施组文档节点的属性分为无属性、可变属性、固属性定和充填属性共4种属性;The second step is specifically: the attributes of the newly created group document node are divided into four attributes: no attribute, variable attribute, fixed attribute and filling attribute; 固定属性的节点内容是独立于一类施工组织设计的通用内容,不需要用户补充;The node content of fixed attributes is a general content independent of a class of construction organization design, and does not need to be supplemented by users; 可变属性的节点内容中具有一部分不需要用户完善的独立于一类施工组织设计的通用内容,用户根据当前项目的具体情况完善可变属性的节点内容;The variable attribute node content has a part of the general content independent of a class of construction organization design that does not need to be completed by the user. The user completes the variable attribute node content according to the specific situation of the current project; 充填属性的节点内容中没有独立于一类施工组织设计的通用内容,用户据当前项目的具体情况填写充填属性的节点内容;There is no general content in the node content of the filling attribute that is independent of a class of construction organization design, and the user fills in the node content of the filling attribute according to the specific situation of the current project; 用户通过桌面客户端新建施组文档的过程中,桌面客户端解析施组模板文档中的节点生成文本节点;When the user creates a group document through the desktop client, the desktop client parses the nodes in the group template document to generate a text node; 对施组文档节点参数化具体是:利用填充文本参数化子模块在施组文档节点中生成填充文本参数内容控件;Parameterizing the group document node is specifically: using the filling text parameterization sub-module to generate a filling text parameter content control in the group document node; 利用计算编号参数化子模块在施组文档节点中生成计算编号参数内容控件;Use the calculation number parameterization sub-module to generate the calculation number parameter content control in the group document node; 利用日期参数化子模块在施组文档节点中生成日期参数内容控件;Use the date parameterization sub-module to generate a date parameter content control in the group document node; 利用算术运算参数化子模块在施组文档节点中生成算术运算参数内容控件;Use the arithmetic operation parameterization sub-module to generate the arithmetic operation parameter content control in the group document node; 利用日期运算参数化子模块在施组文档节点中生成日期运算参数内容控件;Use the date operation parameterization sub-module to generate the date operation parameter content control in the group document node; 利用函数运算参数化子模块在施组文档节点中生成函数运算参数内容控件;Use the function operation parameterization sub-module to generate the function operation parameter content control in the group document node; 利用聚合运算参数化子模块在施组文档节点中生成聚合运算参数内容控件;Use the aggregation operation parameterization sub-module to generate the aggregation operation parameter content control in the group document node; 利用JS脚本运算参数化子模块在施组文档节点中生成JS脚本运算参数内容控件;Use the JS script operation parameterization sub-module to generate the JS script operation parameter content control in the group document node; 第三步骤具体是:在第二步骤完成后,用户通过编辑命令,补充填写施组文档节点的内容;The third step is specifically: after the second step is completed, the user supplements and fills in the content of the group document node through the editing command; (一)通过文件数据接收及结构检查模块检查当前文档数据的结构,用户对于检查合格的当前文档进行重复率检查;(1) Check the structure of the current document data through the document data receiving and structure checking module, and the user checks the repetition rate of the current document that passes the check; (二)通过重复率检查模块检查当前文档数据与历史施组文档的重复率;用户将重复率合格的当前文档存入数据库,具体是将原文档存入SZData数据库并将抽取的纯文本存入moduledata数据库;(2) Check the repetition rate of the current document data and historical documents through the repetition rate checking module; the user saves the current document with a 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 a document that has passed the verification, extract all the text in the document, and calculate the repetition rate of the plain text between the document and the existing document in the library by comparing the text; 对于重复率超过阈值的文档将提示用户库中已存在内容相似的文档,并询问用户是否要继续插入文档,用户选择插入文档后,首先将文档和用户提交表单存入SZBasic数据库中的模块数据请求流程数据表中,该流程经过管理员审批通过后,将文档存入SZData数据库中的模块数据表中,同时使用Aspose.Words从文档中提取全文的纯文本,结合用户提交表单生成jsondoc存储到ElasticSearch的moduledata数据库中;For documents whose repetition rate exceeds the threshold, it will prompt the user that there are documents with similar content in the library, and ask the user whether to continue inserting the document. After the user chooses to insert the document, the document and the user submission form are first stored in the module data request in the SZBasic database. In the process data table, after the process is approved by the administrator, the document is stored in the module data table in the SZData database, and the plain text of the full text is extracted from the document using Aspose.Words, combined with the form submitted by the user to generate jsondoc and store it in ElasticSearch in the moduledata database; (三)用户通过桌面客户端新建施组文档,调用填写好的各施组文档节点数据完善文档;(3) The user creates a new construction group document through the desktop client, and calls the completed node data of each construction group document to complete the document; (四)用户通过参数化解析模块,根据当前文档结构中的文本节点中包含的参数化内容控件中的参数化属性,生成相应的内容并将生成的内容插入到当前文档中所述参数化内容控件所在位置,使生成的内容成为施组文档的组成部分;参数化内容控件中存储了参数化的属性;(4) The user uses the parameterized parsing module to generate corresponding content according to the parameterized properties in the parameterized content control contained in the text node in the current document structure and insert the generated content into the parameterized content in the current document The location of the control makes the generated content an integral part of the group document; the parameterized content control stores parameterized attributes; 具体包括:利用填充文本参数解析子模块,在填充文本参数内容控件所在施组文档位置填写系统定义类型的文本参数以及用户自定义的文本参数;Specifically include: use the filling text parameter parsing sub-module to fill in system-defined text parameters and user-defined text parameters in the location of the group document where the filling text parameter content control is located; 利用计算编号参数解析子模块在计算编号参数内容控件所在施组文档位置根据文档模块结构组成填写编号;Use the calculation number parameter parsing sub-module to fill in the number according to the structure of the document module at the position of the document where the calculation number parameter content control is located; 利用日期参数解析子模块在日期参数内容控件所在施组文档位置填写日期;Use the date parameter parsing sub-module to fill in the date in the document location where the date parameter content control is located; 利用算术运算参数解析子模块在算术运算参数内容控件所在施组文档位置填写相应公式及计算结果;Use the arithmetic operation parameter analysis sub-module to fill in the corresponding formula and calculation results in the location of the group document where the content control of the arithmetic operation parameter is located; 利用日期运算参数解析子模块在施组文档中的日期运算参数内容控件所在位置填写计算出的时间跨度结果;Use the date operation parameter parsing sub-module to fill in the calculated time span result at the location of the date operation parameter content control in the group document; 利用函数运算参数解析子模块在函数运算参数内容控件所在施组文档位置填写相应公式;Use the function operation parameter parsing sub-module to fill in the corresponding formula in the location of the group document where the function operation parameter content control is located; 利用聚合运算参数解析子模块在聚合运算参数内容控件所在施组文档位置填写相应解析结果;Use the aggregation operation parameter parsing sub-module to fill in the corresponding analysis results in the group document where the aggregation operation parameter content control is located; 利用JS脚本运算参数解析子模块在JS脚本运算参数内容控件所在施组文档位置填写相应解析结果;Use the JS script operation parameter analysis sub-module to fill in the corresponding analysis results in the location of the document 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 the 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 through the document generation module document.
CN202310549961.7A 2023-05-16 2023-05-16 Intelligent management system for water conservancy project construction plans and construction organization design method Active CN116562819B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310549961.7A CN116562819B (en) 2023-05-16 2023-05-16 Intelligent management system for water conservancy project construction plans and construction organization design method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310549961.7A CN116562819B (en) 2023-05-16 2023-05-16 Intelligent management system for water conservancy project construction plans and construction organization design method

Publications (2)

Publication Number Publication Date
CN116562819A true CN116562819A (en) 2023-08-08
CN116562819B CN116562819B (en) 2025-09-23

Family

ID=87487622

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310549961.7A Active CN116562819B (en) 2023-05-16 2023-05-16 Intelligent management system for water conservancy project construction plans and construction organization design method

Country Status (1)

Country Link
CN (1) CN116562819B (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN120409435A (en) * 2025-07-02 2025-08-01 山东高速德建集团有限公司 A method and system for intelligently generating word documents for construction organization design

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106446448A (en) * 2016-10-17 2017-02-22 中建交通建设集团有限公司 Formwork system parametrization design method based on BIM technology
CN111242457A (en) * 2020-01-07 2020-06-05 中国建筑第八工程局有限公司 Construction technology management system and method
CN114118038A (en) * 2021-11-30 2022-03-01 深圳壹账通智能科技有限公司 Table document online editing method, device, equipment and medium
CN115422138A (en) * 2022-09-29 2022-12-02 中交武汉智行国际工程咨询有限公司 A quick and easy way to create a construction plan
CN115659937A (en) * 2022-10-31 2023-01-31 上海天华建筑设计有限公司 Construction drawing design and description writing method

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106446448A (en) * 2016-10-17 2017-02-22 中建交通建设集团有限公司 Formwork system parametrization design method based on BIM technology
CN111242457A (en) * 2020-01-07 2020-06-05 中国建筑第八工程局有限公司 Construction technology management system and method
CN114118038A (en) * 2021-11-30 2022-03-01 深圳壹账通智能科技有限公司 Table document online editing method, device, equipment and medium
CN115422138A (en) * 2022-09-29 2022-12-02 中交武汉智行国际工程咨询有限公司 A quick and easy way to create a construction plan
CN115659937A (en) * 2022-10-31 2023-01-31 上海天华建筑设计有限公司 Construction drawing design and description writing method

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
范文杰;: "工程施组管理软件在客运专线建设中的应用", 西部交通科技, no. 01, 30 January 2017 (2017-01-30) *

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN120409435A (en) * 2025-07-02 2025-08-01 山东高速德建集团有限公司 A method and system for intelligently generating word documents for construction organization design

Also Published As

Publication number Publication date
CN116562819B (en) 2025-09-23

Similar Documents

Publication Publication Date Title
CN104866426B (en) Software test integrated control method and system
CN115617327A (en) Low-code page building system, method, and computer-readable storage medium
US11907203B2 (en) Path encoded tree structures for operations
CN111241454A (en) Method, system and device for generating webpage code
CN110543303B (en) Visual service platform
CN114281331B (en) A method and device for generating front-end and back-end code files for accessing a database
CN116010439B (en) Visual Chinese SQL system and query construction method
CN106874247B (en) Report generation method and device
CN101308490A (en) A method and platform for generating dynamic reports
CN114297994A (en) Method, system, device and storage medium for generating parameterized report
CN112667598B (en) Data model rapid construction system based on business demand change
CN109636303B (en) A storage method and system for semi-automatically extracting and structuring document information
CN118966208A (en) Self-reflective prompt word optimization method and system based on large language model
CN112115694A (en) Simulation report generation method and device based on multi-element data structure
CN105468571A (en) Method and device used for automatically generating report
CN116226166A (en) Data source-based data query method and system
CN118657135A (en) Document generation method, device and storage medium
CN116562819A (en) Intelligent management system for hydraulic engineering construction scheme and construction organization design method
TWI629602B (en) Method for automatically generating website interactive program
CN106708475A (en) Northbound data conversion method and apparatus
CN119203963A (en) Business report generation method, device and electronic equipment
CN118210800A (en) Self-adaptive data table structure optimization method and device
CN118607497A (en) A method and system for generating a custom report
CN117744616A (en) Report generation method and device, electronic equipment and storage medium
CN109634606A (en) A kind of method and device of defined function menu

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant