CN112464032A - Bidding clearing method - Google Patents

Bidding clearing method Download PDF

Info

Publication number
CN112464032A
CN112464032A CN201911343430.2A CN201911343430A CN112464032A CN 112464032 A CN112464032 A CN 112464032A CN 201911343430 A CN201911343430 A CN 201911343430A CN 112464032 A CN112464032 A CN 112464032A
Authority
CN
China
Prior art keywords
document
bidding
rule
configuring
clearing
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.)
Pending
Application number
CN201911343430.2A
Other languages
Chinese (zh)
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.)
Shanghai Huizhao Information Technology Co ltd
Original Assignee
Shanghai Huizhao Information Technology 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 Shanghai Huizhao Information Technology Co ltd filed Critical Shanghai Huizhao Information Technology Co ltd
Priority to CN201911343430.2A priority Critical patent/CN112464032A/en
Publication of CN112464032A publication Critical patent/CN112464032A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/80Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/80Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
    • G06F16/84Mapping; Conversion

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention relates to a bid clearing method which can establish a uniform abstract model based on different XSD standards and business rules, reduce development work brought by data standard and business rule change, and quickly integrate new standards and rules by using a pure configuration mode. In order to solve the technical problem, the invention provides a label clearing method, which comprises the following steps: acquiring an XSD standard which is met by an XML document of a bidding document file to be processed; analyzing the XSD standard according to an XSD grammar so as to obtain document structure information of the bidding document file; configuring a bidding clearing rule by using the document information structure; and acquiring required attributes from the XML document of the bidding document file according to the document information structure, and bringing the acquired required attributes into a bidding clearing rule for clearing the bidding.

Description

Bidding clearing method
Technical Field
The invention relates to the field of XML file processing, in particular to a label clearing method.
Background
The project amount list is a detailed list of names and corresponding quantities of branch project projects, measure projects, other projects, expense projects, tax projects and the like of the construction project. In the project type bidding activities, it is necessary to examine whether each bid document substantially responds to the request of the bid document, conforms to the key terms, conditions and specifications requested by the bid document, has no significant deviation, has no calculation error, missing items, and the like, before evaluating the bid.
The general data amount in the engineering quantity list is more, the prior bidder makes the engineering quantity list which is mainly automatically generated by various construction cost software, and the data packet is mainly in an XML format.
XML, as a kind of semi-structured data, is a common format of data without markup. While XSD (XML schema Definition) is used to describe the structure of an XML document, there is also a standard structure and specification.
Because the list specification format difference of provinces and cities is large, the XSD used for describing different XML documents has various conditions of Chinese, English, full spelling, initial letters and the like, and the data packet formats generated by different construction cost software have certain difference. Therefore, the bid clearing work currently faces the following problems:
(1) the workload and the calculation amount of the index clearing inspection are large, and higher requirements are put forward on the performance of processing logic;
(2) the unified data standard is lacked, and the cost software is usually customized and developed according to various local standards, so that the difficulty is brought to unified standard clearing;
(3) the bid clearing rule depends on various local standards and actual requirements of owners and is difficult to be specified as a specific rule;
(4) the list specification and the like are regulated irregularly, and the change of the XML structure brings a large amount of maintenance and upgrading workload to the traditional clear mark software.
Disclosure of Invention
The invention aims to provide a bid clearing method which can establish a uniform abstract model based on different XSD standards and business rules, reduce development work caused by data standard and business rule change, and quickly integrate new standards and rules in a pure configuration mode.
In order to solve the technical problem, the invention provides a label clearing method, which comprises the following steps: acquiring an XSD standard which is met by an XML document of a bidding document file to be processed; analyzing the XSD standard according to an XSD grammar so as to obtain document structure information of the bidding document file; configuring a bidding clearing rule by using the document information structure; and acquiring required attributes from the XML document of the bidding document file according to the document information structure, and bringing the acquired required attributes into a bidding clearing rule for clearing the bidding.
Optionally, the document structure information includes XPATH language information.
Optionally, the configured bid removal rule includes: configuring a conformity checking rule; configuring and calculating error checking rules; configuring reasonable price rules; and configuring a key field summary rule.
Optionally, when the compliance check rule is configured, a compliance check table is output, and the configuration of the compliance check rule includes: adding a data path of the conformance check table, wherein the data path of the conformance check table can be added for multiple times; setting key attributes for each unit of the conformance check list; selecting a display column for the compliance check list; a comparison check column is selected for the compliance check table.
Optionally, when the calculation error check rule is configured, a calculation error check table is output, and the configuration of the calculation error check rule includes: adding a data path of the calculation error check table, wherein the data path of the calculation error check table can be added for multiple times; selecting a display column for the calculation error check table; and adding a calculation formula to the calculation error check table, wherein the calculation formula can be added for multiple times.
Optionally, the position of each variable in the calculation formula in the XML file is obtained from the document structure information.
Optionally, when the reasonable price rule is configured, a reasonable price table is output, and the configuration of the reasonable price rule includes: adding a data path of the reasonable price table, wherein the data path of the reasonable price table can be added for multiple times; displaying a column for selection of the reasonable price list; setting a path of prices to be compared and a preset formula for comparing the prices; and marking abnormal quotation conditions in the reasonable price table.
Optionally, when configuring the key field summarization rule, outputting a key field summary table, where the configuring of the key field summarization rule includes: adding a data path of the key field summary table, wherein the data path of the key field summary table can be added for multiple times; selecting a display column for the key field summary table; the key fields are shown displayed in a comparative manner for manual review and analysis.
The method for clearing the XML document can directly analyze the XSD standard of the XML document in the semantic level, can perform standardized analysis on XML documents complying with different XSD standards, shields the difference of the XML level, and is beneficial to analyzing and processing elements in the XML document subsequently. For example, in the markup removal method, the XML file processing method is adopted, and the markup removal rules are abstracted into operations such as comparison, calculation, verification and the like of numerical values pointed by a specific path of a certain element in the XML file, so that the method is very simple and convenient.
Drawings
Fig. 1 is a schematic flow chart illustrating steps of a bid removing method according to an embodiment of the present invention.
Fig. 2 is a schematic flow chart illustrating steps of a bid removing method according to an embodiment of the present invention.
FIG. 3 is a diagram illustrating parsing of program fields of the XSD standard according to an embodiment of the invention.
Fig. 4 is a schematic diagram of a checking rule according to an embodiment of the present invention.
FIG. 5 is a tree diagram of an XML document obtained according to the parsed XSD standard in an embodiment of the present invention.
FIG. 6 is a diagram illustrating a part project inventory and pricing plans obtained after the de-bidding process is performed according to an embodiment of the present invention.
FIG. 7 is a diagram illustrating a part project inventory and pricing plans obtained after the de-bidding process is performed according to an embodiment of the present invention.
FIG. 8 is a diagram illustrating the association between the part item list and the pricing tables obtained after the bid clearing process according to an embodiment of the present invention.
Detailed Description
The method for clearing the label according to the present invention will be described in detail with reference to the accompanying drawings and the following detailed description.
Fig. 1 is a schematic flow chart illustrating a bid removing method according to an embodiment of the present invention.
In this specific embodiment, there is also provided a bid removing method, including the steps of: s11, acquiring an XSD standard which is met by the XML document of the bidding document file to be processed; s12, analyzing the XSD standard according to an XSD grammar so as to obtain the document structure information of the bidding document file; s13, using the document information structure to configure the annotation rule; s14, according to the file information structure, obtaining the needed attribute from the XML file of the bidding document file, and bringing the obtained needed attribute into the bidding clearing rule for clearing the bidding.
In the specific implementation mode, the bid clearing method can cope with the actual situation that the price list data specifications are different from one another, the traditional mode of independently adapting to the data specification versions of different places is abandoned, the XSD standard of the bid document is analyzed innovatively by using the XSD syntax, the document structure information of the XML document is obtained according to the analyzed XSD standard, data is extracted from the XML document according to the document structure information of the XML document during the bid clearing and is analyzed, the influence of the difference of the XML document level on the bid clearing logic is shielded, and the 0 code modification of unlimited expansion of the bid clearing rule is realized.
In one embodiment, the document structure information includes XPATH language information. XPath is based on XML tree structures, providing the ability to find nodes in a data structure tree. Initially, XPath was proposed as a general grammar model between XPointer and XSL. XPath is adopted by developers quickly as a small query language to determine the position of a part in an XML document and describe the document structure information as an XPATH language, so that users can conveniently find the specific position of a certain key attribute in the XML document.
In one embodiment, the bidding document includes a bidding document, a bid document, a control price document, a bid background document, and in some embodiments, may include only a bidding document and a bid document.
In one embodiment, the key attributes include a file type identifier, an engineering name, a bidder, a total bid price, and the like, and are specific attributes in the bidding document.
In one embodiment, the configured bid-clearing rule comprises: configuring a conformity checking rule; configuring and calculating error checking rules; configuring reasonable price rules; and configuring a key field summary rule.
In a specific embodiment, the bid-clearing rules summarize the obtained bid-clearing service requirements of each region. And clearing the bidding according to the bidding clearing rule to obtain a corresponding form, wherein the bidding clearing rule adopts a modular design and can be smoothly upgraded and expanded.
In one embodiment, when configuring the compliance check rule, the method outputs a compliance check table, and configuring the compliance check rule includes: adding a data path of the conformance check table, wherein the data path of the conformance check table can be added for multiple times; setting key attributes for each unit of the conformance check list; selecting a display column for the compliance check list; a comparison check column is selected for the compliance check table.
In one embodiment, when the calculation error check rule is configured, outputting a calculation error check table, where the configuring of the calculation error check rule includes: adding a data path of the calculation error check table, wherein the data path of the calculation error check table can be added for multiple times; selecting a display column for the calculation error check table; and adding a calculation formula to the calculation error check table, wherein the calculation formula can be added for multiple times.
In a specific embodiment, the position of each variable in the calculation formula in the XML file is obtained from the document structure information. In one embodiment, when configuring the reasonable price rule, outputting a reasonable price table, the configuring the reasonable price rule includes: adding a data path of the reasonable price table, wherein the data path of the reasonable price table can be added for multiple times; displaying a column for selection of the reasonable price list; setting a path of prices to be compared and a preset formula for comparing the prices; and marking abnormal quotation conditions in the reasonable price table.
In one embodiment, when configuring the reasonable price rule, it is considered that the price elements of a plurality of bidding documents are subjected to transverse comparison analysis. The abnormal quote refers to a quote that is too high or too low.
In one embodiment, when configuring the key field aggregation rule, a key field aggregation table is output, and the configuring of the key field aggregation rule includes: adding a data path of the key field summary table, wherein the data path of the key field summary table can be added for multiple times; selecting a display column for the key field summary table; the key fields are shown displayed in a comparative manner for manual review and analysis.
Referring to fig. 2 to 8, fig. 2 is a schematic flow chart illustrating steps of a bid removing method according to an embodiment of the present invention. FIG. 3 is a diagram illustrating parsing of program fields of the XSD standard according to an embodiment of the invention. Fig. 4 is a schematic diagram of a checking rule according to an embodiment of the present invention. FIG. 5 is a tree diagram of an XML document obtained according to the parsed XSD standard in an embodiment of the present invention. FIG. 6 is a diagram illustrating a part project inventory and pricing plans obtained after the de-bidding process is performed according to an embodiment of the present invention. FIG. 7 is a diagram illustrating a part project inventory and pricing plans obtained after the de-bidding process is performed according to an embodiment of the present invention. FIG. 8 is a diagram illustrating the association between the part item list and the pricing tables obtained after the bid clearing process according to an embodiment of the present invention.
In this embodiment:
taking the newly added Shanxi province 2018 standard as an example, the whole clearing standard is configured according to the graph of FIG. 2, after a new standard is added, a list as shown in FIG. 3 is displayed, and the clearing rule adopted by the standard is selected. The rules can be modularly and freely combined and smoothly upgraded and expanded.
After the check is finished, the standard configuration is formally started, and firstly, an XSD corresponding to the standard needs to be imported, for example, the shanxi 2018 standard, and part of the content of the list data specification XSD is shown in fig. 4.
After the XSD is imported, a comprehensive configuration page is entered, necessary key attributes are selected according to each uploaded XSD, and the key attributes defined by the current system comprise:
(1) bidding documents [ document type labels, project names ]
(2) Bidding documents [ document type label, project name, bidder name, total bid price ]
(3) Control price documents [ document type labels, project names, control prices, measure item fees, part item project fees, fees ]
(4) Documentary documents [ document type mark, project name, documentary price, measure project fee, branch project fee, and rule fee ].
The tree diagram of the XML document is obtained by analyzing the analyzed XSD standard, and the display effect is shown in FIG. 5.
After the comprehensive configuration is completed, the configuration of each bidding clearing rule can be started. The configuration parameters of the bid-clearing rule roughly comprise a form path, a display name, a display column, a detection column and other parameters required by the rule. For the example of a compliance configuration, the rules for configuring a form are shown in FIGS. 6 and 7.
The form names in fig. 6 and 7 are "part project quantity inventory and pricing table", the data will traverse through the data under xpath "/economic mark/single project/unit project/part project/inventory", the associated attributes are used to uniquely determine the attribute group of the form, and the content in the example is shown in fig. 8.
The traversal element path is also a relative path for subsequent field positioning of the form, and the relative path for the traversal element path is also used for storage in the subsequent selection process of the display column and the check column.
After the parameters and content configuration of each selected bid-clearing rule is completed, all operations of new rule adaptation are completed. In the subsequent bid clearing process, as long as the previously defined rules are selected, the system can analyze and process the price XML data file according to the XML structure information obtained by the previous XSD, and can quickly begin the bid clearing work after simple parameter setting:
the foregoing is only a preferred embodiment of the present invention, and it should be noted that, for those skilled in the art, various modifications and decorations can be made without departing from the principle of the present invention, and these modifications and decorations should also be regarded as the protection scope of the present invention.

Claims (8)

1. A bid removing method is characterized by comprising the following steps:
acquiring an XSD standard which is met by an XML document of a bidding document file to be processed;
analyzing the XSD standard according to an XSD grammar so as to obtain document structure information of the bidding document file;
configuring a bidding clearing rule by using the document information structure;
and acquiring required attributes from the XML document of the bidding document file according to the document information structure, and bringing the acquired required attributes into a bidding clearing rule for clearing the bidding.
2. The method of claim 1, wherein the document structure information includes XPATH language information.
3. The method according to claim 1, wherein the configured bid-clearing rules comprise:
configuring a conformity checking rule;
configuring and calculating error checking rules;
configuring reasonable price rules;
and configuring a key field summary rule.
4. The method of claim 3, wherein the step of outputting a compliance check table when configuring the compliance check rule comprises:
adding a data path of the conformance check table, wherein the data path of the conformance check table can be added for multiple times;
setting key attributes for each unit of the conformance check list;
selecting a display column for the compliance check list;
a comparison check column is selected for the compliance check table.
5. The method of claim 3, wherein the step of outputting a calculation error check table when the calculation error check rule is configured comprises:
adding a data path of the calculation error check table, wherein the data path of the calculation error check table can be added for multiple times;
selecting a display column for the calculation error check table;
and adding a calculation formula to the calculation error check table, wherein the calculation formula can be added for multiple times.
6. The method according to claim 4, wherein the position of each variable in the calculation formula in the XML file is obtained from the document structure information.
7. The bid clearance method according to claim 3, wherein a reasonable price table is outputted when configuring reasonable price rules, and configuring the reasonable price rules comprises:
adding a data path of the reasonable price table, wherein the data path of the reasonable price table can be added for multiple times;
displaying a column for selection of the reasonable price list;
setting a path of prices to be compared and a preset formula for comparing the prices;
and marking abnormal quotation conditions in the reasonable price table.
8. The method of claim 3, wherein when configuring the key field aggregation rule, outputting a key field aggregation table, and configuring the key field aggregation rule includes:
adding a data path of the key field summary table, wherein the data path of the key field summary table can be added for multiple times;
selecting a display column for the key field summary table;
the key fields are shown displayed in a comparative manner for manual review and analysis.
CN201911343430.2A 2019-12-24 2019-12-24 Bidding clearing method Pending CN112464032A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201911343430.2A CN112464032A (en) 2019-12-24 2019-12-24 Bidding clearing method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201911343430.2A CN112464032A (en) 2019-12-24 2019-12-24 Bidding clearing method

Publications (1)

Publication Number Publication Date
CN112464032A true CN112464032A (en) 2021-03-09

Family

ID=74806871

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201911343430.2A Pending CN112464032A (en) 2019-12-24 2019-12-24 Bidding clearing method

Country Status (1)

Country Link
CN (1) CN112464032A (en)

Citations (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20060206523A1 (en) * 2005-03-14 2006-09-14 Microsoft Corporation Single-pass translation of flat-file documents into XML format including validation, ambiguity resolution, and acknowledgement generation
CN101625694A (en) * 2009-08-17 2010-01-13 中国科学院地理科学与资源研究所 Method and system for storing various standard geological metadata
CN102682340A (en) * 2011-03-18 2012-09-19 林光柱 Assessment method for tender offer information rationality
CN102929664A (en) * 2012-10-16 2013-02-13 南京通达海信息技术有限公司 Conventional data exchange method based on XSD structure
CN105719070A (en) * 2016-01-18 2016-06-29 四川建设网有限责任公司 Electronic auxiliary reviewing method and system
CN107943764A (en) * 2017-12-05 2018-04-20 中国航空综合技术研究所 Standard Structured based on XML writes generation method
CN107958331A (en) * 2017-11-24 2018-04-24 国网内蒙古东部电力有限公司 A kind of electricity power engineering of GPU multithreadings marks clearly method automatically
CN109582391A (en) * 2018-12-04 2019-04-05 中国航空工业集团公司西安航空计算技术研究所 A kind of device tree configuration method based on XML
CN109857799A (en) * 2019-01-29 2019-06-07 国网物资有限公司 The automatic auditing system of tender price and method
CN110046974A (en) * 2019-04-18 2019-07-23 厦门海迈科技股份有限公司 A kind of bidding for project file assessment system and method

Patent Citations (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20060206523A1 (en) * 2005-03-14 2006-09-14 Microsoft Corporation Single-pass translation of flat-file documents into XML format including validation, ambiguity resolution, and acknowledgement generation
CN101625694A (en) * 2009-08-17 2010-01-13 中国科学院地理科学与资源研究所 Method and system for storing various standard geological metadata
CN102682340A (en) * 2011-03-18 2012-09-19 林光柱 Assessment method for tender offer information rationality
CN102929664A (en) * 2012-10-16 2013-02-13 南京通达海信息技术有限公司 Conventional data exchange method based on XSD structure
CN105719070A (en) * 2016-01-18 2016-06-29 四川建设网有限责任公司 Electronic auxiliary reviewing method and system
CN107958331A (en) * 2017-11-24 2018-04-24 国网内蒙古东部电力有限公司 A kind of electricity power engineering of GPU multithreadings marks clearly method automatically
CN107943764A (en) * 2017-12-05 2018-04-20 中国航空综合技术研究所 Standard Structured based on XML writes generation method
CN109582391A (en) * 2018-12-04 2019-04-05 中国航空工业集团公司西安航空计算技术研究所 A kind of device tree configuration method based on XML
CN109857799A (en) * 2019-01-29 2019-06-07 国网物资有限公司 The automatic auditing system of tender price and method
CN110046974A (en) * 2019-04-18 2019-07-23 厦门海迈科技股份有限公司 A kind of bidding for project file assessment system and method

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
周忠宝: "《Java Web程序设计》", 30 November 2019 *
支佰宁: "浅谈工程量清单招标下的清标工作", 《建设监理》 *

Similar Documents

Publication Publication Date Title
US10915703B2 (en) Validating an XML document
US6675355B1 (en) Redline extensible markup language (XML) schema
US7080067B2 (en) Apparatus, method, and program for retrieving structured documents
US9690770B2 (en) Analysis of documents using rules
US20040221233A1 (en) Systems and methods for report design and generation
US20060218160A1 (en) Change control management of XML documents
US10614126B2 (en) Textual query editor for graph databases that performs semantic analysis using extracted information
CN107357933A (en) A kind of label for multi-source heterogeneous science and technology information resource describes method and apparatus
US7523433B1 (en) System and method for automated analysis and hierarchical graphical presentation of application results
US20120310868A1 (en) Method and system for extracting and managing information contained in electronic documents
US20120304051A1 (en) Automation Tool for XML Based Pagination Process
CN104182911A (en) Calibration method for realizing CIM (Common Information Model) consistency of power distribution network system
US20110145005A1 (en) Method and system for automatic business content discovery
CN107515866B (en) Data operation method, device and system
US20080059577A1 (en) Scalable logical model for edi and system and method for creating, mapping and parsing edi messages
Liu et al. An XML-enabled data extraction toolkit for web sources
KR100841079B1 (en) Remote maintenance system based on xml
CN112464032A (en) Bidding clearing method
JP5143980B2 (en) Intellectual property protocols that define data exchange rules and formats for general-purpose intellectual property data objects, and systems, methods, and program products related thereto
CN116010439A (en) Visual Chinese SQL system and query construction method
US8719693B2 (en) Method for storing localized XML document values
Le Zou et al. On synchronizing with web service evolution
CN109783105B (en) Coding statistical method, equipment, storage medium and device of enterprise service platform
JP2002297601A (en) Method and device for structured document management, and program
Silva Perfil Nacional de Metadados para Informação Geográfica (Perfil MIG)

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
CB02 Change of applicant information

Address after: 201206 room 1101, floor 11, building 6, No. 1599, Xinjinqiao Road, China (Shanghai) pilot Free Trade Zone, Pudong New Area, Shanghai

Applicant after: SHANGHAI HUIZHAO INFORMATION TECHNOLOGY Co.,Ltd.

Address before: 200433 room 1203-12, No.6 Weide Road, Yangpu District, Shanghai

Applicant before: SHANGHAI HUIZHAO INFORMATION TECHNOLOGY Co.,Ltd.

CB02 Change of applicant information
RJ01 Rejection of invention patent application after publication

Application publication date: 20210309

RJ01 Rejection of invention patent application after publication