Bridge engineering quantity calculation and export method based on virtual model construction

Abstract

This invention provides a method for calculating and exporting bridge engineering quantities based on a virtual model. First, a digital virtual model of a steel-concrete composite bridge is built using computer information technology, categorized into three levels: connections, spans, and components. Then, the types of engineering materials for specific components within the component level are defined, and the quantities of these materials are calculated. The models are then uploaded and summarized layer by layer in the order of components, spans, and connections, enabling rapid calculation and summarization of the quantities for the steel-concrete composite bridge. Finally, using object-oriented programming principles and the NPOI document processing package, the quantities are quickly compiled into an Excel spreadsheet file for export. The method provided by this invention results in a clear and distinct hierarchy of bridge structures, enabling rapid and accurate calculation and modification of engineering quantities, facilitating use by engineering designers, and improving automation and work efficiency.

Description

Technical Field

[0001] This invention relates to the fields of bridge structural design calculation and computer technology, specifically to a method for calculating and deriving the quantity of bridge engineering projects based on virtual models. Background Technology

[0002] Steel-concrete composite bridges are innovative bridge structures that effectively combine steel main beams with concrete bridge decks. They combine the compressive strength of concrete with the tensile strength of steel, are lightweight, and their components are easy to modularly produce and assemble. They have been widely used in recent years as the country has vigorously promoted industrialization. Regarding the quantity calculation of steel-concrete composite bridges, the traditional method involves engineers integrating quantity calculation into the drawing process. When drawing the drawings of individual components, the quantity of various engineering materials included in that component is calculated, along with the quantity of that component in the entire project. The quantity of a single component is multiplied by the total quantity of that component in the project to obtain the total amount of engineering materials for that component. This process is repeated for other components, and the quantities of engineering materials for other components are calculated. Finally, the total quantity of the bridge is calculated and summed according to material categories. This traditional method relies heavily on manual calculations by engineers, depending on their spatial imagination. The calculation process is tedious and error-prone, and intermediate results are difficult to retrieve. Specific shortcomings include the following:

[0003] 1) Traditional engineering quantity calculation mainly relies on manual calculation by engineering designers. They draw a diagram and calculate the quantity of a project. The quantity statistics process depends entirely on the spatial imagination of the designers. That is, the designers calculate the shape, size, position and quantity of the component in their minds. It is very easy to make mistakes or omit or under-calculate, and it is difficult to guarantee the accuracy of the engineering quantity calculation.

[0004] 2) Relying on manual calculation of project quantities consumes a lot of manpower and time. If the structure and drawings change, the internal logical relationship needs to be rechecked and the total project quantity needs to be calculated again, resulting in a lot of mechanical and repetitive work.

[0005] 3) The calculation results at the intermediate level are not easy to retrieve. You can see the individual components and the final calculated total, but you cannot find the engineering quantity of a certain span or a certain section. The material usage indicators are also not easy to compare. Summary of the Invention

[0006] To address the aforementioned issues, this invention provides a method for calculating the quantity of bridge engineering projects based on virtual model construction. By establishing a digital virtual model of a steel-concrete composite bridge and utilizing digital means to construct the spatial logical relationship of the bridge structure, the method enables rapid calculation and automatic export of the quantity of steel-concrete composite bridge engineering projects.

[0007] The technical problem to be solved by this invention is achieved by the following technical solution:

[0008] The method for calculating the quantity of bridge engineering projects based on virtual models utilizes computer information technology to build a digital virtual model of a steel-concrete composite bridge according to three levels: connection, span, and components. From top to bottom, a structure library, component library, and material library composed of connections and spans are constructed. The engineering material types of specific components within the component layer are further defined and the quantity of materials is calculated. Then, the data is uploaded and summarized layer by layer in the order of components, spans, and connections, realizing the rapid calculation and summary of the quantity of steel-concrete composite bridge engineering projects.

[0009] Further technology of the present invention:

[0010] Preferably, the construction of the digital virtual model refers to building a digital architecture model of the steel-concrete composite bridge using information technology. First, based on the externally input bridge project's span and connection layout information, bridge deck width information, wet joint width information, and structural characteristics of the steel-concrete composite bridge, a digital virtual model of the overall bridge structure is built. Then, based on the geometric dimensions of each component, a digital model of each component is built and material properties are assigned. Next, based on the spatial logical relationship between the components, the individual components are connected to form a span of the bridge. Finally, based on the span combination information, a digital virtual model of the steel-concrete composite bridge is constructed.

[0011] Preferably, the method for calculating the quantity of work is as follows:

[0012] S1 defines the types of engineering materials for steel-concrete composite bridges. The types of engineering materials include concrete (HNT), reinforcing bars (GJ), steel (GC), prestressed steel strands (GS), shear studs (JLD), and bolts (LS). Material properties and unit parameters are attached for each type of engineering material.

[0013] S2. Based on the design information of the steel-concrete composite bridge, a data space is constructed at three levels: connection, span, and component. The design information includes the number of connections, the span combination of each connection, and the component composition of each span. The component G includes the bridge deck A, longitudinal beams B, transverse beams C, and wet joints D, as shown in the following formula:

[0014] G=A∪B∪C∪D (1)

[0015] S3. Based on the design information, create digital virtual models of individual components one by one, connect them to various engineering materials, attach material properties, and label each component with a unique identification code.

[0016] The identification code contains information such as component number, name, location, and external dimensions. The number, name, and location information are unique within the entire system program, representing the unique spatial location of the component in the entire digital virtual model of the steel-concrete composite bridge.

[0017] The materials included in various components are shown in the following formula:

[0018] A = {HNT, GJ, GS} (2)

[0019] B = {GC, JLD, LS} (3)

[0020] C = {GC, JLD, LS} (4)

[0021] D = {HNT, GJ} (5)

[0022] S4, creates functions for calculating the quantity of structural components, including the function V for calculating the volume of concrete. c ()=(CN,V), a function M for calculating the mass of reinforcing steel bars. r ()=(d r ,m r The function M for calculating steel quality s ()=(t s ,m s The function M for calculating the mass of prestressed steel strands. p ()=(d p ,m p The function N for calculating the number of shear studs. d ()=(d d ,n d The function N for calculating the number of bolts. b ()=(d b ,n b );

[0023] The function V of the concrete volume c ()=∫∫z(x,y)dxdy=(CN,V), with the corner point of the bridge deck component or wet joint as the origin of the coordinate system, x is the cross-sectional width coordinate of the bridge deck component or wet joint, y is the longitudinal length coordinate of the bridge deck component or wet joint, z(x,y) is the component thickness of the bridge deck component or wet joint at the coordinate point (x,y), and the returned function value is CN is the concrete strength grade, and V is the concrete volume corresponding to CN;

[0024] The function of the steel reinforcement mass ρ r d is the mass density of the steel reinforcement. ri For the specific diameter of the reinforcing bar, l ri For a specific single rebar length, the returned function value is d. r The diameter of the reinforcing bar is in meters (m). r To be with d r Corresponding steel reinforcement quality;

[0025] The function M of the steel quality s ()=∑A i t si =(t s,m s ), A i t represents the planar area of ​​a single steel plate that makes up the longitudinal and transverse beams. si The function returns a value of t, representing the thickness of the individual steel plates that make up the longitudinal and transverse beams. s m is the thickness of the steel plate. s For t s Corresponding steel quality;

[0026] The function of the prestressed steel strand engineering quantity d pi For the specific diameter of a single prestressed steel strand, l pi For a specific length of a single prestressed steel strand, the returned function value is d. p For the type of prestressed steel strand, m p With d p The corresponding prestressed steel strand quality;

[0027] The function N of the number of shear pins d ()=(d d ,n d The independent variable is a specific component, and the returned function value is d. d For shear studs, n d With d d The corresponding number of shear studs;

[0028] The function N for calculating the number of bolts b ()=(d b ,n b The independent variable is a specific component, and the returned function value is d. b For bolt diameter specifications, n b With d b The corresponding number of bolts;

[0029] S5 uses the created function to calculate the quantity of the components, including the concrete volume V. c Reinforcing steel quality M r Steel quality M s Prestressed steel strand mass M p Number of shear studs N d Number of bolts N b ;

[0030] V c =V c (A)+V c (D) (6)

[0031] M r =M r (A)+M r (D) (7)

[0032] Ms =M s (B)+M s (C) (8)

[0033] M p =M p (A) (9)

[0034] N d =N d (B) (10)

[0035] N b =N b (B)+N b (C) (11)

[0036] S6. Create digital virtual models of each span of the bridge in sequence. Add the created components to the corresponding span according to their unique identifiers. Connect the individual components to form a span of the bridge according to the spatial logical relationship between the components. When each component is added to the span, upload the engineering quantity of each component calculated by calling the function to calculate the engineering quantity of the component to its span and calculate and summarize it to realize the total engineering quantity calculation of each span.

[0037] S7. Calculate the total quantity of each section of the project, summarize and sum the quantities of each span of the project within the section according to the material type, and further sum the quantities of each section of the project to obtain the total quantity of materials for the steel-concrete composite bridge project, and store it in the corresponding material library of the project.

[0038] This invention also provides a method for exporting calculated project quantities: using object-oriented programming concepts and relying on the NPOI document processing package, the project quantities can be quickly compiled into an Excel spreadsheet file;

[0039] The NPOI document processing package is a plugin package based on the .Net platform and using the C# language to write and manipulate Excel documents without the Office environment. It can compile the calculated project quantities into an Excel spreadsheet file for export, making it convenient for engineering designers to use.

[0040] The generation of the Excel spreadsheet file is achieved by creating a custom function TableToExcelForXLS(DataTable[]dt,string file,ArrayListAL_Name), which calculates the number of bridge structure projects and compiles it into an Excel spreadsheet; dt is the total number of projects, file is the save path and name of the spreadsheet file, and AL_Name is the name of the sub-spreadsheet. The method for generating the spreadsheet file using the function TableToExcelForXLS(DataTable[]dt,string file,ArrayListAL_Name) is as follows:

[0041] a1. Create an Excel workbook using the HSSFWorkbook class object provided in the NPOI package; HSSFWorkbook is a class provided by the NPOI package for creating Excel workbook objects;

[0042] a2. Use the CreateSheet() method provided in the NPOI package to create an Excel worksheet ISheet object, and assign the AL_Name parameter to the ISheet object as its name attribute; the CreateSheet() method is a function provided by the NPOI package for creating worksheet objects;

[0043] a3. The `CreateRow()` method, built into the NPOI package, is used to create a header within an `ISheet` object. The `CreateCell()` method is then used to create specific cell objects within the header, and the `SetCellValue()` method is used to fill in the header content. The `CreateCell()` method is a function provided by the NPOI package for creating specific cell objects; the `SetCellValue()` method is a function provided by the NPOI package for writing values ​​within cell objects. The header content includes the names of each component type, the names of engineering materials, and their units.

[0044] a4. Use a For loop and the SetCellValue() method to write the calculated quantity data dt of the steel-concrete composite bridge project into the cell of the ISheet object;

[0045] a5 converts an HSSFWorkbook class object into a byte stream format object;

[0046] a6. Using the FileStream function provided by the Windows system, the byte stream format object is created into an Excel file, and the file parameter is assigned to the Excel file as its save path and file name.

[0047] The beneficial effects of this invention are:

[0048] This invention provides a method for calculating the quantity of bridge engineering projects based on virtual models, which has the following beneficial effects:

[0049] 1) Using computer information technology, a digital virtual model of a steel-concrete composite bridge is built according to the three levels of bridge connection, span, and components. The spatial logical relationship of the bridge structure is constructed using digital means, which eliminates the need to rely on the spatial imagination of the designers and allows for the rapid and accurate calculation of the total amount of engineering materials for the entire bridge.

[0050] 2) The specific function for calculating the quantity of components is a subroutine independent of the main program. It can be called repeatedly and independently without affecting the operation of the main program. When individual components inside the steel-concrete composite bridge change, it is only necessary to modify the parameters in the subroutine and call the function again, without adjusting the main program and affecting its operation. Therefore, it is easy to modify, and the quantity of work is automatically modified in response to structural changes.

[0051] 3) The bridge structure digital architecture model built based on the virtual model has a clear hierarchy. Each level contains a structure library, component library and material library. It can calculate and retrieve the engineering quantity of any component, span, connection and other levels, which further facilitates designers to compare material usage indicators.

[0052] 4) Based on the NPOI library, the C# language is used to write and manipulate Excel documents without the Office environment. The calculated project quantities are compiled into an Excel master sheet file for export, realizing the automatic generation and export of project quantity tables, which is convenient for engineering designers and improves the level of automation and work efficiency. Attached Figure Description

[0053] To more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings used in the description of the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0054] Figure 1 This is the overall logic flowchart of the steel-concrete composite bridge engineering quantity calculation method of the present invention;

[0055] Figure 2 This is a three-dimensional structural exploded view of the steel-concrete composite bridge of the present invention;

[0056] Figure 3 This is a flowchart illustrating the method of compiling project quantities into an Excel spreadsheet using object-oriented programming principles, as described in this invention.

[0057] Figure 4 A quantity table of engineering materials for a project generated using the method of the present invention.

[0058] In the above diagram, the numbers are: 1-bridge deck; 2-longitudinal beam; 3-crossbeam; 4-wet joint; 5-shear stud. Detailed Implementation

[0059] The technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings of the embodiments of the present invention. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments.

[0060] Example:

[0061] like Figures 1-3 As shown, using the present invention's method for calculating the quantity of steel-concrete composite bridge engineering based on a virtual model, the following calculations are performed: Figure 2 The diagram shows the engineering quantities of a certain steel-concrete composite bridge. The overall approach utilizes computer information technology to build a digital virtual model of the steel-concrete composite bridge at three levels: links, spans, and components. From top to bottom, a structure library, a component library, and a material library are constructed, consisting of links and spans. Further, the types of engineering materials for specific components within the component layer are defined, and the quantities of these materials are calculated. Then, these are uploaded and summarized layer by layer in the order of components, spans, and links, enabling rapid calculation and summarization of the engineering quantities of the steel-concrete composite bridge.

[0062] The virtual model construction refers to building a digital architecture model of a steel-concrete composite bridge using information technology. First, based on the externally input bridge project's span and connection layout information, bridge deck width information, wet joint width information, and structural characteristics of the steel-concrete composite bridge, a digital virtual model of the overall bridge structure is built. Then, based on the geometric dimensions of each component, a digital model of each component is built and material properties are assigned. Next, based on the spatial logical relationship between the components, the individual components are connected to form a span of the bridge. Finally, based on the span combination information, a digital virtual model of the steel-concrete composite bridge is assembled, realizing the automation and parameterization of project quantity aggregation.

[0063] The specific steps for calculating the quantity of work are as follows:

[0064] S1 defines the types of engineering materials used in steel-concrete composite bridges. These materials include concrete (HNT), reinforcing bars (GJ), steel (GC), prestressed steel strands (GS), shear studs (JLD), and bolts (LS). Material properties and units are provided for each material type. The volume unit for concrete (HNT) is cubic meters (m³). 3 The unit of mass for steel bars (GJ), steel (GC), and prestressed steel strands (GS) is kilogram (kg); the unit of number for shear studs (JLD) is individual; and the unit of number for bolts (LS) is set.

[0065] S2, based on the design information of steel-concrete composite bridges, establishes a data space at three levels: connection, span, and component; such as... Figure 2 The design information for a certain steel-concrete composite bridge shown includes: 1 span, a span combination of 5 x 35 m, a bridge width of 12.5 m, a wet joint width of 300 mm, and the components of each span including bridge deck A, longitudinal beams B, transverse beams C, and wet joints D, as shown in the following formula:

[0066] G=A∪B∪C∪D (1)

[0067] S3. Based on the design information, create digital virtual models of individual components one by one, and connect them to various engineering materials, attaching material properties such as concrete strength grade, rebar diameter, steel type, shear stud type, etc. At the same time, affix a unique identification code to each component. For example, the identification code of the first edge beam of the first span is SPAN001.BEAM0001, its beam rib identification code is SPAN001.BEAM0001.Girder, the identification code of the N1 rebar of the beam rib is SPAN001.BEAM0001.Girder.Bars.N1, and the identification code of the total weight of the N1 rebar is SPAN001.BEAM0001.Girder.Bars.N1.tWeight;

[0068] The identification code contains information such as component number, name, location, and constitutive relationship. The number, name, and location information are unique within the entire system program, representing the unique spatial location of the component in the entire digital virtual model of the steel-concrete composite bridge.

[0069] The materials included in various components are shown in the following formula:

[0070] A = {HNT, GJ, GS} (2)

[0071] B = {GC, JLD, LS} (3)

[0072] C = {GC, JLD, LS} (4)

[0073] D = {HNT, GJ} (5)

[0074] S4, creates functions for calculating the quantity of structural components, including the function V for calculating the volume of concrete. c ()=(CN,V), a function M for calculating the mass of reinforcing steel bars. r ()=(d r ,m r The function M for calculating steel quality s ()=(t s ,m s The function M for calculating the mass of prestressed steel strands. p()=(d p ,m p The function N for calculating the number of shear studs. d ()=(d d ,n d The function N for calculating the number of bolts. b ()=(d b ,n b );

[0075] The function V of the concrete volume c () = (CN, V) where the independent variable is the specific component, and the returned function value is: CN is the concrete strength grade in MPa, and V is the concrete volume corresponding to CN in cubic meters. 3 ;

[0076] The function M of the steel reinforcement mass r ()=(d r ,m r The independent variable is a specific component, and the returned function value is d. r This specifies the type and diameter of the reinforcing bars. Types include Grade I NHP300 (symbol 'a'), Grade II HRB335 (symbol 'b'), and Grade III HRB400 (symbol 'c'). Diameter is in mm (m). r To be with d r The corresponding steel reinforcement mass is expressed in kg.

[0077] The function M of the steel quality s ()=(t s ,m s The independent variable is a specific component, and the returned function value is t. s The thickness of the steel plate is expressed in mm or m. s For t s The corresponding steel mass, in kg;

[0078] The function M of the prestressed steel strand engineering quantity p ()=(d p ,m p The independent variable is a specific component, and the returned function value is d. p For the type of prestressed steel strand, m p With d p The corresponding prestressed steel strand mass is in kg;

[0079] The function N of the number of shear pins d ()=(d d ,n d The independent variable is a specific component, and the returned function value is d. d This refers to the shear stud model, indicating the external dimensions of the shear stud, n. d With dd The corresponding number of shear studs;

[0080] The function N for calculating the number of bolts b ()=(d b ,n b The independent variable is a specific component, and the returned function value is d. b This refers to the bolt diameter designation, indicating the bolt's external dimensions. (n) b With d b The corresponding number of bolts;

[0081] S5 uses the created function to calculate the quantity of the components, including the concrete volume V. c Reinforcing steel quality M r Steel quality M s Prestressed steel strand mass M p Number of shear studs N d Number of bolts N b ;

[0082]

[0083]

[0084]

[0085] M p =M p (A)=(φ s 15.2 19740) (9)

[0086] N d =N d (B)=(φ22x200 9840) (10)

[0087]

[0088] S6. Create digital virtual models of each span of the bridge structure sequentially. Add the created components to their corresponding spans based on their unique identifiers, and connect the individual components according to their spatial logical relationships to form a span of the bridge. The visualization is as follows: Figure 2 As shown; when each component is added to a span, the function that calculates the number of components is called to calculate the number of components, and the number of components for each component is uploaded to its span and calculated and summarized to realize the total number of components for each span;

[0089] S7, calculate the total quantity of materials for a single span of the project. Classify and sum the quantities of materials for each span within the span according to material type to obtain the total quantity of materials for the steel-concrete composite bridge project. Store this total quantity in the corresponding material library for the project. Figure 4 The total number of projects shown.

[0090] The main program in the above calculation process is to sum the quantities of each joint and span of the structural engineering. The specific function for calculating the quantity of component engineering is a subroutine independent of the main program. It can be called repeatedly and independently without affecting the operation of the main program. When individual components inside the steel-concrete composite bridge change, it is only necessary to modify the parameters in the subroutine and call the function again, without adjusting the main program and without affecting the operation of the main program.

[0091] The subroutine adopts object-oriented programming technology, which encapsulates the engineering quantity calculation of each component, span and connection independently, and can be called independently and repeatedly according to the structural assembly hierarchy using a unified dummy and real element interface.

[0092] The main program calculates and summarizes the project quantity according to the external input design parameters in a hierarchical manner from low to high. The process from low to high is: component → span → link → project.

[0093] The engineering quantity calculation method based on virtual model construction can clearly distinguish the hierarchical structure of bridges, and can calculate and retrieve the engineering quantities of any component, span, or connection at each level individually. For example, the detailed composition of the engineering quantity of the end crossbeam of the first span of the first connection is shown in the table below:

[0094] null 0 0 0 0 0 0 0 N1 upper wing edge 1 20 7950 800 998.5 998.5 15 N2 web 1 20 7950 1748 2181.8 2181.8 32.7 N3 lower wing edge 1 32 7950 950 1897.2 1897.2 28.5 N4 Vertical stiffening ribs 4 20 1748 238 65.3 261.3 3.9 DH1 End beam connection Gross weight 2 20 1070 450 75.6 151.2 2.3 DH2 End beam connection 2 20 860 828 111.8 223.6 3.4 DH3 End beam connection Gross weight 2 20 830 828 107.9 215.8 3.2 XX1 Small crossbeam connection Gross weight 4 16 380 228 10.9 43.5 0.7 BZ1a Support stiffening 1 20 868 240 32.7 32.7 0.5 BZ1b Support stiffening 1 20 868 240 32.7 32.7 0.5 BZ2 Support stiffening Gross weight 4 20 818 240 30.8 123.3 1.8 BZ3 Support stiffening 1 28 800 800 140.7 140.7 2.1

[0095] Finally, utilizing object-oriented programming principles and the NPOI document processing package, the total quantity of the entire steel-concrete composite bridge project was quickly compiled and generated into an Excel spreadsheet file. The exported table is shown below. Figure 4 As shown.

[0096] The NPOI document processing package is a plugin package based on the .Net platform and using the C# language to write and manipulate Excel documents without the Office environment. It can compile the calculated project quantities into an Excel spreadsheet file for export, making it convenient for engineering designers to use.

[0097] The generation of the Excel spreadsheet file is achieved by creating a custom function TableToExcelForXLS(DataTable[]dt,string file,ArrayListAL_Name), which calculates the number of bridge structure projects and compiles it into an Excel spreadsheet; dt is the total number of projects, file is the save path and name of the spreadsheet file, and AL_Name is the name of the sub-spreadsheet. The method for generating the spreadsheet file using the function TableToExcelForXLS(DataTable[]dt,string file,ArrayListAL_Name) is as follows:

[0098] a1. Create an Excel workbook using the HSSFWorkbook class object provided in the NPOI package; HSSFWorkbook is a class provided by the NPOI package for creating Excel workbook objects;

[0099] a2. Use the CreateSheet() method provided in the NPOI package to create an Excel worksheet ISheet object, and assign the AL_Name parameter to the ISheet object as its name attribute; the CreateSheet() method is a function provided by the NPOI package for creating worksheet objects;

[0100] a3. The `CreateRow()` method, built into the NPOI package, is used to create a header within an `ISheet` object. The `CreateCell()` method is then used to create specific cell objects within the header, and the `SetCellValue()` method is used to fill in the header content. The `CreateCell()` method is a function provided by the NPOI package for creating specific cell objects; the `SetCellValue()` method is a function provided by the NPOI package for writing values ​​within cell objects. The header content includes the names of each component type, the names of engineering materials, and their units.

[0101] a4. Use a For loop and the SetCellValue() method to write the calculated quantity data dt of the steel-concrete composite bridge project into the cell of the ISheet object;

[0102] a5 converts an HSSFWorkbook class object into a byte stream format object;

[0103] a6. Using the FileStream function provided by the Windows system, the byte stream format object is created into an Excel file, and the file parameter is assigned to the Excel file as its save path and file name.

[0104] The foregoing has shown and described the basic principles, main features, and advantages of the present invention. Those skilled in the art should understand that the present invention is not limited to the above embodiments. The embodiments and descriptions in the specification are merely preferred examples and are not intended to limit the invention. Various changes and modifications can be made to the invention without departing from its spirit and scope, and all such changes and modifications fall within the scope of the present invention as claimed. The scope of protection of the present invention is defined by the appended claims and their equivalents.

Claims

1. A method for calculating the quantity of bridge engineering projects based on virtual model construction, characterized in that: Using computer information technology, a digital virtual model of a steel-concrete composite bridge is built according to three levels: connection, span, and components. From top to bottom, a structural library, a component library, and a material library are constructed, consisting of connections and spans. The types of engineering materials for specific components within the component layer are further defined and the quantity of materials is calculated. Then, the data is uploaded and summarized layer by layer in the order of components, spans, and connections to quickly calculate and summarize the quantity of steel-concrete composite bridge engineering. The calculation method for project quantities is as follows: S1 defines the types of engineering materials for steel-concrete composite bridges. The types of engineering materials include concrete (HNT), reinforcing bars (GJ), steel (GC), prestressed steel strands (GS), shear studs (JLD), and bolts (LS). Material properties and unit parameters are attached for each type of engineering material. S2. Based on the design information of the steel-concrete composite bridge, a data space is constructed at three levels: connection, span, and component. The design information includes the number of connections, the span combination of each connection, and the component composition of each span. The component G includes the bridge deck A, longitudinal beams B, transverse beams C, and wet joints D, as shown in the following formula: (1)； S3. Based on the design information, create digital virtual models of individual components one by one, connect them to various engineering materials, attach material properties, and label each component with a unique identification code. The identification code contains information such as component number, name, location, and external dimensions. The number, name, and location information are unique within the entire system program, representing the unique spatial location of the component in the entire digital virtual model of the steel-concrete composite bridge. The materials included in various components are shown in the following formula: （2）； （3）； （4）； （5）； S4, a function for calculating the quantity of structural components, including a function for calculating concrete volume. Functions for calculating the quality of reinforcing steel bars Functions for calculating steel quality Functions for calculating the mass of prestressed steel strands A function for calculating the number of shear nails. Function to calculate the number of bolts ; The function of the concrete volume Using the corner points of bridge deck components or wet joints as the origin of the coordinate system, This refers to the coordinates along the width of the cross-section of the bridge deck components or wet joints. This represents the longitudinal length coordinate of the bridge deck components or wet joints. For bridge deck components or wet joints at coordinate points The component thickness at that location, and the returned function value. V represents the concrete strength grade, and V is the ratio of the concrete strength grade to the concrete strength grade. The corresponding concrete volume; The function of the steel reinforcement mass , For the mass density of the steel reinforcement, For the specific diameter of the reinforcing bar, The function value returned is for a specific single rebar length. The diameter of the reinforcing bar. To and Corresponding steel reinforcement quality; The function of steel quality , The area of ​​a single steel plate that makes up the longitudinal and transverse beams. The function returns the thickness of the individual steel plates that make up the longitudinal and transverse beams. For the thickness of the steel plate, To and Corresponding steel quality; The function of the prestressed steel strand engineering quantity , For the specific diameter of a single prestressed steel strand, The returned function value is for a specific single prestressed steel strand length. This refers to the model number of the prestressed steel strands. and The corresponding prestressed steel strand quality; The function of the number of shear pins The independent variable is a specific component, and the function value returned is... This is a shear stud model. and The corresponding number of shear studs; The function for calculating the number of bolts The independent variable is a specific component, and the function value returned is... This refers to the bolt diameter model. and The corresponding number of bolts; S5 uses the created function to calculate the quantity of components, including concrete volume. Reinforcing steel quality Steel quality Quality of prestressed steel strands Number of shear nails Number of bolts ; (6)； (7)； (8)； (9)； (10)； (11)； S6. Create digital virtual models of each span of the bridge in sequence. Add the created components to the corresponding span according to their unique identifiers. Connect the individual components to form a span of the bridge according to the spatial logical relationship between the components. When each component is added to the span, upload the engineering quantity of each component calculated by calling the function to calculate the engineering quantity of the component to its span and calculate and summarize it to realize the total engineering quantity calculation of each span. S7. Calculate the total quantity of each section of the project, summarize and sum the quantities of each span of the project within the section according to the material type, and further sum the quantities of each section of the project to obtain the total quantity of materials for the steel-concrete composite bridge project, and store it in the corresponding material library of the project.

2. The method for calculating the quantity of bridge engineering projects based on a virtual model as described in claim 1, characterized in that: The construction of the digital virtual model refers to building a digital architecture model of a steel-concrete composite bridge using information technology. First, based on the externally input bridge project's span and connection layout information, bridge deck width information, wet joint width information, and structural characteristics of the steel-concrete composite bridge, a digital virtual model of the overall bridge structure is built. Then, based on the geometric dimensions of each component, a digital model of each component is built and material properties are assigned. Next, based on the spatial logical relationship between the components, the individual components are connected to form a span of the bridge. Finally, based on the span combination information, a digital virtual model of the steel-concrete composite bridge is constructed.

3. The method for calculating the quantity of bridge engineering projects based on a virtual model as described in claim 1, characterized in that, The method for deriving project quantities is as follows: By utilizing object-oriented programming concepts and relying on the NPOI document processing package, we can quickly compile and generate Excel spreadsheet files from project data. The NPOI document processing package is a plugin package based on the .Net platform and using the C# language to write and manipulate Excel documents without the Office environment. It compiles the calculated project quantities into an Excel spreadsheet file for export, making it convenient for engineering designers to use. The generation of the Excel spreadsheet file is achieved by creating a custom function TableToExcelForXLS, which calculates the number of bridge structure projects and compiles it into the Excel spreadsheet; dt is the total number of projects, file is the save path and name of the spreadsheet file, and AL_Name is the name of the sub-spreadsheet. The method for generating the spreadsheet file using the function TableToExcelForXLS is as follows: a1. Create an Excel workbook using the HSSFWorkbook class object provided in the NPOI package; HSSFWorkbook is a class provided by the NPOI package for creating Excel workbook objects; a2. Use the CreateSheet() method provided by the NPOI package to create an Excel worksheet ISheet object, and assign the AL_Name parameter to the ISheet object as its name attribute; the CreateSheet() method is a function provided by the NPOI package for creating worksheet objects; a3. The `CreateRow()` method, built into the NPOI package, is used to create a header within an `ISheet` object. The `CreateCell()` method is then used to create specific cell objects within the header, and the `SetCellValue()` method is used to fill in the header content. The `CreateCell()` method is a function provided by the NPOI package for creating specific cell objects; the `SetCellValue()` method is a function provided by the NPOI package for writing values ​​within cell objects. The header content includes the names of each component type, the names of engineering materials, and their units. a4. Use a For loop and the SetCellValue() method to write the calculated quantity data dt of the steel-concrete composite bridge project into the cell of the ISheet object; a5 converts an HSSFWorkbook class object into a byte stream format object; a6. Using the FileStream function provided by the Windows system, the byte stream format object is created into an Excel file, and the file parameter is assigned to the Excel file as its save path and file name.

Images