Household photovoltaic BOM generation method and system

Abstract

The invention discloses a household photovoltaic BOM generation method and system, and belongs to the technical field of design drawing processing, and the method comprises the steps: screening effective primitives from a drawing file through geometric attributes and a layer naming rule; converting a two-dimensional graph in the drawing file according to the space coordinates of the effective primitives to obtain an initial three-dimensional graph; based on the axis net in the initial three-dimensional graph and the name of the two-dimensional graph, obtaining the incidence relation between the two-dimensional graphs, and based on the incidence relation, filling the initial three-dimensional graph with the supporting component corresponding to the effective primitive; copying the supporting members which are logically merged in the initial three-dimensional graph to the corresponding shafts according to the shaft numbers in the shaft net to obtain a final three-dimensional graph; and generating a material list table of the household photovoltaic module based on the final three-dimensional graph and a preset rule table. The technical problem that the accuracy is difficult to improve while the material list generation efficiency is improved in the prior art is solved.

Description

Technical Field

[0001] This invention relates to the field of design drawing processing technology, specifically to a BOM generation method and system for residential photovoltaic systems. Background Technology

[0002] Obtaining a bill of materials (BOM) is crucial for project planning, procurement, and construction. Traditional methods primarily rely on manual analysis of two-dimensional drawings, which is extremely inefficient. To improve the efficiency of BOM generation, existing technologies directly extract relevant information from two-dimensional drawings to generate the BOM. For example, a structured BOM management method (patent publication number CN115729933A) includes: establishing a first structured BOM based on two-dimensional drawings and corresponding drawing documents; when the two-dimensional drawings are adjusted, obtaining the information of the person making the adjustment, and then establishing a second structured BOM based on the adjusted two-dimensional drawings; updating a first differential list based on the first and second structured BOMs to obtain a second differential list; associating and saving the second differential list with the second structured BOM; and retrieving the second differential list simultaneously when the second structured BOM is queried. However, the above methods are only applicable to two-dimensional drawings with simple structures and limited information. When faced with complex two-dimensional drawings, which typically contain a large number of overlapping elements, directly extracting the material list from the two-dimensional drawing can easily lead to material omissions, making it difficult to guarantee the accuracy of the final material list. Therefore, how to improve the efficiency and accuracy of material list generation is a pressing technical challenge that needs to be addressed. Summary of the Invention

[0003] To address the technical challenge of improving both the efficiency and accuracy of Bill of Materials (BOM) generation in existing technologies, this invention provides a BOM generation method and system for residential photovoltaic systems. The method involves converting two-dimensional graphics in a drawing file into an initial three-dimensional graphic based on the spatial coordinates of valid graphic elements. The association between the two-dimensional graphics and their corresponding grid lines is then established. Based on this association, supporting components corresponding to the valid graphic elements are filled into the initial three-dimensional graphic. Finally, logically merged supporting components from the initial three-dimensional graphic are copied to their corresponding axes according to their grid numbers to obtain the final three-dimensional graphic. By converting two-dimensional graphics into three-dimensional graphics, the spatial relationships of components are clearly displayed, avoiding missing components due to overlap issues in the two-dimensional graphics. This overcomes the technical challenge of improving both the efficiency and accuracy of existing technologies in generating BOMs.

[0004] To address the aforementioned technical problems, this invention provides a BOM (Bill of Materials) generation method for residential photovoltaic systems, comprising the following steps: Valid elements are filtered from drawing files based on geometric attributes and layer naming rules; The initial three-dimensional graphic is obtained by converting the two-dimensional graphic in the drawing file according to the spatial coordinates of the valid graphic elements. The association between the two-dimensional graphics is obtained based on the grid lines in the initial three-dimensional graphic and the names of the two-dimensional graphics. Based on the association, the supporting components corresponding to the valid graphic elements are filled into the initial three-dimensional graphic. Based on the axis number in the grid, the logically merged support components in the initial 3D graphic are copied to the corresponding axis to obtain the final 3D graphic. A material list for residential photovoltaic modules is generated based on the final 3D graphics and preset rule tables.

[0005] By adopting the above technical solution, the present invention has the following advantages: By using geometric attributes and layer naming rules for dual filtering, valid primitives are accurately identified, reducing redundant processing and ensuring reliable input for subsequent processing, thus reducing computational complexity. The initial 3D graphic is obtained by converting the 2D graphics in the drawing file using the spatial coordinates of valid graphic elements. The relationship between the 2D graphics and the grid lines in the initial 3D graphic is obtained by matching the names of the 2D graphics. The supporting components corresponding to the valid graphic elements are then filled into the initial 3D graphic based on the relationship. In other words, the 3D graphics of the same supporting component in the 2D graphics from different perspectives are obtained through the relationship. On this basis, the logically merged supporting components in the initial 3D graphic are copied to the corresponding axes by axis number to obtain the final 3D graphic. This makes the final 3D graphic able to intuitively show the spatial position relationship of the components, avoiding the missing components caused by the overlap of 2D graphics. This improves both the efficiency and accuracy of the generated material list.

[0006] Preferably, the step of converting the two-dimensional graphic in the drawing file according to the spatial coordinates of the valid graphic elements to obtain the initial three-dimensional graphic includes: The first three-dimensional coordinate information is obtained by comparing the position coordinates of the multi-line segments in the valid primitives with the height information of the corresponding multi-line segments in the extended data. The second three-dimensional coordinate information is obtained based on the center point coordinates of the blocks in the valid primitives and the height information of the blocks in the extended data. The initial three-dimensional graphic is obtained based on the first three-dimensional coordinate information and the second three-dimensional coordinate information.

[0007] In this scheme, the first three-dimensional coordinate information is obtained based on the position coordinates of the multi-line segments representing the roof outline and the corresponding height information of the multi-line segments. The second three-dimensional coordinate information is obtained based on the center point coordinates of the block representing the column and the corresponding height information of the block. The initial three-dimensional graphic is obtained through the three-dimensional coordinate information, realizing the preliminary restoration of the three-dimensional structure of the household photovoltaic support. At the same time, by obtaining the three-dimensional coordinate information of the multi-line segments representing the roof outline and the block representing the column, the three-dimensional structure of the household photovoltaic support is initially restored, which improves the rationality and accuracy of the restoration.

[0008] Preferably, the step of obtaining the association relationship between the two-dimensional graphics based on the grid lines in the initial three-dimensional graphic and the names of the two-dimensional graphics, and filling the supporting components corresponding to the valid graphic elements into the initial three-dimensional graphic based on the association relationship, includes: Each 2D graphic name is matched with a grid to obtain the grid range corresponding to each 2D graphic. The 2D data of the supporting components corresponding to the valid graphic elements are obtained based on the grid range. The association relationship is obtained based on the 2D data and the geometric projection relationship. The 3D data of the supporting components corresponding to the valid graphic elements is obtained based on the association relationship. The supporting components corresponding to the valid graphic elements are filled into the initial 3D graphic based on the 3D data.

[0009] In this solution, the range of components in a 2D graphic can be obtained by acquiring the grid range. By acquiring the 2D data of the supporting components within the grid range, the 2D data is combined with geometric projection relationships to obtain correlations. Through these correlations, the unique 3D data of the same supporting component in 2D graphics from different views can be located. The supporting components corresponding to the valid graphic elements are then filled into the initial 3D graphic using the 3D data. This eliminates information contradictions from multiple views, improves the completeness and accuracy of the initial 3D graphic, and avoids missing components due to overlapping issues in 2D graphics, thereby improving the accuracy of the subsequently obtained bill of materials.

[0010] Preferably, before generating the material list for residential photovoltaic modules based on the final 3D graphics and preset rule table, the method further includes: The implicit structure in the two-dimensional graph is associated with the matching table to obtain the material data of the implicit structure.

[0011] Preferably, the process of generating a material list table for residential photovoltaic modules based on the final 3D graphics and a preset rule table includes: defining a preset rule table based on the material statistical requirements of residential photovoltaic modules; matching the types of modules in the final 3D graphics with the preset rule table to obtain statistical methods; obtaining the quantity of modules based on the statistical methods; and obtaining a material list table based on the material data of the implicit structure and the quantity of modules.

[0012] Preferably, the material list includes a material list and a layered material association table.

[0013] The beneficial effects of this plan are: By using geometric attributes and layer naming rules for dual filtering, valid primitives are accurately identified, reducing redundant processing and ensuring reliable input for subsequent processing, thus reducing computational complexity. The initial 3D graphic is obtained by converting the 2D graphics in the drawing file using the spatial coordinates of valid graphic elements. The relationship between the 2D graphics is obtained by using the grid lines in the initial 3D graphic and the names of the 2D graphics. The relationship can be used to locate the unique 3D data of the same support component in the 2D graphics of different views. The support component corresponding to the valid graphic elements is filled into the initial 3D graphic using the 3D data, eliminating information contradictions in multiple views and improving the completeness and accuracy of the initial 3D graphic. On this basis, the logically merged support components in the initial 3D graphic are copied to the corresponding axes by axis numbers to obtain the final 3D graphic. The final 3D graphic can intuitively show the spatial position relationship of the components and avoid the missing components caused by the overlap of 2D graphics. This improves both the efficiency and accuracy of the generated material list.

[0014] The present invention also provides a BOM generation system for residential photovoltaic systems, which is applicable to the aforementioned BOM generation method for residential photovoltaic systems, including an initial three-dimensional graphics acquisition module, a final three-dimensional graphics acquisition module, and a material list acquisition module; The initial 3D graphic acquisition module is used to filter valid graphic elements from the drawing file through geometric attributes and layer naming rules, and to convert the 2D graphic in the drawing file according to the spatial coordinates of the valid graphic elements to obtain the initial 3D graphic. The final 3D graphic acquisition module is used to obtain the association relationship between the 2D graphics and the 2D graphic names based on the grid in the initial 3D graphic, fill the support components corresponding to the valid graphic elements into the initial 3D graphic based on the association relationship, and copy the logically merged support components in the initial 3D graphic to the corresponding axis according to the axis number in the grid to obtain the final 3D graphic; the material list acquisition module is used to generate a material list table for household photovoltaic modules based on the final 3D graphic and the preset rule table.

[0015] Preferably, it also includes a configuration management module for setting the style of the material list table.

[0016] Preferably, it also includes an export module for exporting the material list as an Excel list file.

[0017] The beneficial effects of this plan are: By using geometric attributes and layer naming rules for dual filtering, valid primitives are accurately identified, reducing redundant processing and ensuring reliable input for subsequent processing, thus reducing computational complexity. The initial 3D graphic is obtained by converting the 2D graphics in the drawing file using the spatial coordinates of the valid graphic elements. The association between the 2D graphics and the grid lines in the initial 3D graphic is obtained. The support components corresponding to the valid graphic elements are then filled into the initial 3D graphic based on the association. In other words, the 3D graphic of the same support component in the 2D graphics from different perspectives is obtained through the association. On this basis, the logically merged support components in the initial 3D graphic are copied to the corresponding axes by axis number to obtain the final 3D graphic. This makes the final 3D graphic able to intuitively show the spatial position relationship of the components, avoiding the missing components caused by the overlap of 2D graphics. This improves both the efficiency and accuracy of the generated material list. By configuring the style of the material list table through the configuration management module, the limitations of the existing system in terms of table style, data writing and summary format configuration are overcome. The export module allows the material list to be exported as an Excel file, improving data flow efficiency and thus construction efficiency.

[0018] The present invention also provides a computer device, including: a processor, a memory, and a bus, wherein the memory stores machine-readable instructions executable by the processor, and when the computer device is running, the processor communicates with the memory via the bus, and the processor executes the machine-readable instructions to perform the steps of the BOM generation method for residential photovoltaic systems. Attached Figure Description

[0019] Other features, objects, and advantages of the invention will become more apparent from the following detailed description of non-limiting embodiments with reference to the accompanying drawings. The drawings are for illustrative purposes only and are not intended to limit the invention. Furthermore, the same reference numerals denote the same parts throughout the drawings.

[0020] Figure 1 This is a schematic flowchart of a BOM generation method for residential photovoltaic systems according to the present invention. Detailed Implementation

[0021] To make the objectives, technical solutions, and advantages of this invention clearer, the invention will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only one preferred embodiment of this invention and are only used to explain this invention. They do not limit the scope of protection of this invention. All other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of this invention.

[0022] Before discussing the exemplary embodiments in more detail, it should be mentioned that some exemplary embodiments are described as processes or methods depicted as flowcharts. Although the flowcharts describe the operations (or steps) as sequential processes, many of the operations (or steps) can be performed in parallel, concurrently, or simultaneously. Furthermore, the order of the operations can be rearranged. The process can be terminated when its operation is completed, but it may also have additional steps not included in the figures; the process may correspond to a method, function, procedure, subroutine, subroutine, etc.

[0023] Example 1: like Figure 1 As shown, a method for generating a Bill of Materials (BOM) for residential photovoltaic systems includes the following steps: Valid elements are selected from the drawing file based on geometric attributes and layer naming rules.

[0024] In this embodiment, the drawing file can be in DWG or DXF format. The drawing file is obtained through drafting software, such as AutoCAD, SketchUp, or Blender. Filtering valid elements from the drawing file based on geometric attributes and layer naming rules includes: selecting elements with geometric attributes of circle, arc, line, polyline, and block as the first element; and then filtering valid elements from the first element according to the layer naming rules. The layer naming rules are: layer names consist of a prefix_main name_suffix, for example: ROOF_EDGE_NORTH (north edge of the roof). Filtering valid elements from the first element according to the layer naming rules specifically involves: obtaining the target layer by the prefix, and selecting the first element in the target layer as the valid element.

[0025] In another embodiment, the difference from the above embodiment is that the selection of valid graphic elements from the drawing file by geometric attributes and layer naming rules includes: selecting a first graphic element from the graphic elements according to the layer naming rules, and selecting the first graphic element with geometric attributes of circle, arc, straight line, polyline, and block as a valid graphic element.

[0026] By using geometric attributes and layer naming rules for dual filtering, valid primitives are accurately identified, reducing redundant processing and ensuring reliable input for subsequent processing, thus lowering the complexity of calculations.

[0027] The initial three-dimensional graphic is obtained by converting the two-dimensional graphic in the drawing file according to the spatial coordinates of the valid graphic elements.

[0028] As a preferred embodiment, the step of converting the two-dimensional graphic in the drawing file according to the spatial coordinates of the valid graphic elements to obtain the initial three-dimensional graphic includes: The first three-dimensional coordinate information is obtained by comparing the position coordinates of the multi-line segments in the valid primitives with the height information of the corresponding multi-line segments in the extended data. The second three-dimensional coordinate information is obtained based on the center point coordinates of the blocks in the valid primitives and the height information of the blocks in the extended data. The initial three-dimensional graphic is obtained based on the first three-dimensional coordinate information and the second three-dimensional coordinate information.

[0029] In this embodiment, the two-dimensional graphics include a top view of the photovoltaic roof, north-south views, and east-west views. Multi-line segments represent the roof outline, and blocks represent the columns. Extended data uses an attribute storage mechanism, allowing users to attach custom engineering parameters or metadata to the graphic objects. First three-dimensional coordinate information is obtained based on the position coordinates of the multi-line segments representing the roof outline and their corresponding height information. Second three-dimensional coordinate information is obtained based on the center point coordinates of the blocks representing the columns and their corresponding height information. An initial three-dimensional graphic is then obtained using this coordinate information, achieving a preliminary reconstruction of the three-dimensional structure of the residential photovoltaic support system. Furthermore, by obtaining the three-dimensional coordinate information of the multi-line segments representing the roof outline and the blocks representing the columns, the preliminary reconstruction of the three-dimensional structure of the residential photovoltaic support system improves the rationality and accuracy of the reconstruction.

[0030] The association between the two-dimensional graphics is obtained based on the grid lines in the initial three-dimensional graphic and the names of the two-dimensional graphics. Based on the association, the supporting components corresponding to the valid graphic elements are filled into the initial three-dimensional graphic.

[0031] The process of obtaining the association between the two-dimensional graphics based on the grid lines in the initial three-dimensional graphic and the names of the two-dimensional graphics, and filling the supporting components corresponding to the valid graphic elements into the initial three-dimensional graphic based on the association, includes: Each 2D graphic name is matched with a grid to obtain the grid range corresponding to each 2D graphic. The 2D data of the supporting components corresponding to the valid graphic elements are obtained based on the grid range. The association relationship is obtained based on the 2D data and the geometric projection relationship. The 3D data of the supporting components corresponding to the valid graphic elements is obtained based on the association relationship. The supporting components corresponding to the valid graphic elements are filled into the initial 3D graphic based on the 3D data.

[0032] In this embodiment, the names of the two-dimensional graphics are specifically the names of the north-south and east-west views. These views are named using the section axis numbers. If the north-south view is sectioned using axis numbers A1-B3, then the name of the north-south view is A1-B3. If the north-south view is only the north-south view of the roof, then the prefix ROOF is added before A1-B3, and the name is ROOF_A1-B3. Each two-dimensional graphics name is matched with the axis numbers in the grid to obtain the grid range corresponding to each two-dimensional graphics. In this case, the grid range is A1-B3. If there are valid graphic elements a, b, and c within this grid range, and their corresponding supporting components are A, B, and C respectively, then the two-dimensional data of the supporting components corresponding to the valid graphic elements obtained according to the grid range are the two-dimensional data of A, B, and C. The specific process of obtaining the association relationship based on two-dimensional data and geometric projection is as follows: Two-dimensional data are matched according to the geometric projection relationship, and the association relationship is obtained based on the matching result. For example, if the two-dimensional data of A, B, and C are (x, y), (x, z), and (y, z) respectively, according to the geometric projection relationship, (x, y), (x, z), and (y, z) are the two-dimensional position information of the same component in different views. That is, A, B, and C are essentially the same component. The association relationship includes the name and two-dimensional position information of the component in different views. At this time, the three-dimensional data is (x, y, z). The component is filled into the initial three-dimensional graphic based on the three-dimensional data. The association relationship also includes the structural features of the photovoltaic roof, such as the fact that the inclined beam must be above the column, the horizontal beam is above the inclined beam, and the component is above the horizontal beam, etc.

[0033] Understandably, when a 2D graphic name has a prefix, the prefix must be matched first before proceeding with the steps to obtain the grid range and subsequent steps.

[0034] In this embodiment, by obtaining the grid range, the range of the component in the two-dimensional graphic can be obtained. By obtaining the two-dimensional data of the supporting component within the grid range, the two-dimensional data is combined with the geometric projection relationship to obtain the correlation relationship. Through the correlation relationship, the unique three-dimensional data of the same supporting component in two-dimensional graphics in different views can be located. The supporting component corresponding to the effective graphic element is filled into the initial three-dimensional graphic using the three-dimensional data, eliminating the information contradiction of multiple views, improving the integrity and accuracy of the initial three-dimensional graphic, avoiding the missing component caused by the overlap of two-dimensional graphics, and improving the accuracy of the subsequently obtained bill of materials.

[0035] Based on the axis number in the grid, the logically merged support components in the initial 3D drawing are copied to the corresponding axis to obtain the final 3D drawing.

[0036] In this embodiment, by automatically copying the merged support components with different axis numbers but the same structure in the two-dimensional graphic to the corresponding axis, the error of manual copying is eliminated, and the integrity and accuracy of the final three-dimensional graphic are improved.

[0037] A material list for residential photovoltaic modules is generated based on the final 3D graphics and preset rule tables.

[0038] As a preferred embodiment, before generating the material list for residential photovoltaic modules based on the final 3D graphics and preset rule table, the method further includes: The implicit structure in the two-dimensional graph is associated with the matching table to obtain the material data of the implicit structure.

[0039] In this embodiment, the implicit structure in the two-dimensional graphic specifically refers to the structural features that are not reflected in the two-dimensional graphic. For such implicit structures, they are associated and supplemented through a matching table. For example, the column matching table will record its base style and supporting connectors.

[0040] As a preferred embodiment, a material list for residential photovoltaic modules is generated based on the final 3D graphics and a preset rule table, including: Based on the material statistics requirements for residential photovoltaic modules, a preset rule table is defined. The types of modules in the final 3D graphics are matched with the preset rule table to obtain the statistical method. The quantity of modules is obtained based on the statistical method. The material list table is obtained based on the material data of the implicit structure and the quantity of modules.

[0041] In this embodiment, the specific method for matching the component types in the final 3D graphic with a preset rule table to obtain statistics is as follows: For components with fixed-length statistics, their length is calculated according to a set size; otherwise, their length is calculated according to the actual graphic size. For components (i.e., primitives) that require parsing into 2D tables, they are parsed into multi-row, multi-column 2D tables according to the primitive's coordinate information and stored according to the table's data structure. For example, components and columns are grouped into rows and columns according to their center coordinate points, and their material information is stored using a 2D array. For components with quantity coefficients, the quantity is multiplied by the quantity coefficient to obtain the final quantity of the component. In this embodiment, the material list table is obtained by using implicitly structured material data and component quantities, further improving the completeness and accuracy of the material list table.

[0042] Specifically, the material list includes a material list and a layered material association table.

[0043] Example 2: This embodiment also provides a BOM generation system for residential photovoltaic systems, applicable to the aforementioned BOM generation method for residential photovoltaic systems, including an initial 3D graphic acquisition module, a final 3D graphic acquisition module, and a material list acquisition module; the initial 3D graphic acquisition module is used to filter valid graphic elements from the drawing file through geometric attributes and layer naming rules, and to convert the 2D graphics in the drawing file according to the spatial coordinates of the valid graphic elements to obtain the initial 3D graphics. The final 3D graphic acquisition module is used to obtain the association relationship between the 2D graphics and the 2D graphic names based on the grid in the initial 3D graphic, fill the support components corresponding to the valid graphic elements into the initial 3D graphic based on the association relationship, and copy the logically merged support components in the initial 3D graphic to the corresponding axis according to the axis number in the grid to obtain the final 3D graphic; the material list acquisition module is used to generate a material list table for household photovoltaic modules based on the final 3D graphic and the preset rule table.

[0044] In this embodiment, the drawing file can be in DWG or DXF format. The drawing file is obtained through drafting software, such as AutoCAD, SketchUp, or Blender. Valid elements are selected from the drawing file based on geometric attributes and layer naming rules. This includes selecting elements with geometric attributes of circles, arcs, lines, polylines, and blocks as the first element; and then selecting valid elements from the first element according to the layer naming rules. The layer naming rules are: layer names consist of a prefix followed by the main name followed by a suffix, for example: ROOF_EDGE_NORTH (north edge of the roof). Specifically, selecting valid elements from the first element according to the layer naming rules involves obtaining the target layer by its prefix and selecting the first element in that target layer as the valid element. This dual selection using geometric attributes and layer naming rules accurately identifies valid elements, reduces redundant processing, provides reliable input for subsequent processing, and lowers computational complexity.

[0045] In this embodiment, converting a two-dimensional graphic in a drawing file to obtain an initial three-dimensional graphic based on the spatial coordinates of valid graphic elements includes: obtaining first three-dimensional coordinate information based on the position coordinates of multi-line segments in valid graphic elements and the corresponding height information of multi-line segments in extended data; obtaining second three-dimensional coordinate information based on the center point coordinates of blocks in valid graphic elements and the corresponding height information of blocks in extended data; and obtaining the initial three-dimensional graphic based on the first and second three-dimensional coordinate information. Specifically, the two-dimensional graphic includes a top view of the photovoltaic roof, north-south views, and east-west views. Multi-line segments represent the roof outline, blocks represent columns, and the extended data uses an attribute storage mechanism, allowing users to attach custom engineering parameters or metadata to the graphic object. The first three-dimensional coordinate information is obtained by using the position coordinates of the multi-line segments representing the roof outline and the corresponding height information of the multi-line segments. The second three-dimensional coordinate information is obtained by using the center point coordinates of the block representing the column and the corresponding height information of the block. The initial three-dimensional graphic is obtained through the three-dimensional coordinate information, realizing the preliminary restoration of the three-dimensional structure of the household photovoltaic support. At the same time, by obtaining the three-dimensional coordinate information of the multi-line segments representing the roof outline and the block representing the column, the three-dimensional structure of the household photovoltaic support is initially restored, which improves the rationality and accuracy of the restoration.

[0046] In this embodiment, the names of the two-dimensional graphics are specifically the names of the north-south and east-west views. These views are named using the section axis numbers. If a north-south view is sectioned using axis numbers A1-B3, its name is A1-B3. If the north-south view is only a north-south view of the roof, the prefix ROOF is added before A1-B3, resulting in the name ROOF_A1-B3. Each two-dimensional graphics name is matched with the axis numbers in the grid to obtain the corresponding grid range for each two-dimensional graphics. In this case, the grid range is A1-B3. If there are valid graphic elements a, b, and c within this grid range, and their corresponding supporting components are A, B, and C respectively, then the two-dimensional data of the supporting components corresponding to the valid graphic elements obtained from the grid range are the two-dimensional data of A, B, and C. The specific process of obtaining the association relationship based on two-dimensional data and geometric projection is as follows: Two-dimensional data are matched according to the geometric projection relationship, and the association relationship is obtained based on the matching result. For example, if the two-dimensional data of A, B, and C are (x, y), (x, z), and (y, z) respectively, according to the geometric projection relationship, (x, y), (x, z), and (y, z) are the two-dimensional position information of the same component in different views. That is, A, B, and C are essentially the same component. The association relationship includes the name and two-dimensional position information of the component in different views. At this time, the three-dimensional data is (x, y, z). The component is filled into the initial three-dimensional graphic based on the three-dimensional data. The association relationship also includes the structural features of the photovoltaic roof, such as the fact that the inclined beam must be above the column, the horizontal beam is above the inclined beam, and the component is above the horizontal beam, etc.

[0047] In this embodiment, by automatically copying the merged support components with different axis numbers but the same structure in the two-dimensional graphic to the corresponding axis, the error of manual copying is eliminated, and the integrity and accuracy of the final three-dimensional graphic are improved.

[0048] The initial 3D graphic is obtained by converting the 2D graphics in the drawing file using the spatial coordinates of valid graphic elements. The relationship between the 2D graphics and the grid lines in the initial 3D graphic is obtained by matching the names of the 2D graphics. The supporting components corresponding to the valid graphic elements are then filled into the initial 3D graphic based on the relationship. In other words, the 3D graphics of the same supporting component in the 2D graphics from different perspectives are obtained through the relationship. On this basis, the logically merged supporting components in the initial 3D graphic are copied to the corresponding axes by axis number to obtain the final 3D graphic. This makes the final 3D graphic able to intuitively show the spatial position relationship of the components, avoiding the missing components caused by the overlap of 2D graphics. This improves both the efficiency and accuracy of the generated material list.

[0049] In this embodiment, the specific method for matching the final 3D graphic with a preset rule table to obtain statistics is as follows: For components in the final 3D graphic that have fixed-length statistics, calculate their length according to the set size; otherwise, calculate their length according to the actual graphic size. For components in the final 3D graphic that require parsing into a 2D table, i.e., primitives, parse them into a multi-row, multi-column 2D table according to the primitive's coordinate information, and store them according to the table's data structure. For example, components and columns are grouped into rows and columns according to their center coordinate points, and their material information is stored using a 2D array. For components in the final 3D graphic that have quantity coefficients, multiply the quantity by the quantity coefficient to obtain the final quantity of the component.

[0050] As a preferred embodiment, it also includes a configuration management module for setting the style of the material list table.

[0051] In this embodiment, users can design visual forms through the configuration management module, such as setting table headers, fonts, colors, and borders; selecting data writing methods, such as writing by row, column, or group; defining data writing locations; and flexibly defining data writing areas by binding material categories with cell ranges. By providing flexible configuration of table styles, data writing, and summary methods, diverse business needs are met.

[0052] As a preferred embodiment, it also includes an export module for exporting the material list as an Excel list file.

[0053] In this embodiment, the export module is also used to provide a standardized interface to enable interaction with different programming languages ​​and promote data sharing between systems.

[0054] Example 3: This embodiment also provides a computer device, including: a processor, a memory, and a bus. The memory stores machine-readable instructions executable by the processor. When the computer device is running, the processor communicates with the memory via the bus, and the processor executes the machine-readable instructions to perform the steps of the BOM generation method for residential photovoltaic systems.

[0055] The specific embodiments described above are preferred embodiments of the BOM generation method and system for residential photovoltaic systems of the present invention, and are not intended to limit the specific scope of the present invention. The scope of the present invention includes, but is not limited to, these specific embodiments. All equivalent changes made in accordance with the shape and structure of the present invention are within the protection scope of the present invention.

Claims

1. A method for generating a Bill of Materials (BOM) for residential photovoltaic systems, characterized in that, Includes the following steps: Valid elements are filtered from drawing files based on geometric attributes and layer naming rules; The initial three-dimensional graphic is obtained by converting the two-dimensional graphic in the drawing file according to the spatial coordinates of the valid graphic elements. The association between the two-dimensional graphics is obtained based on the grid lines in the initial three-dimensional graphic and the names of the two-dimensional graphics. Based on the association, the supporting components corresponding to the valid graphic elements are filled into the initial three-dimensional graphic. Based on the axis number in the grid, the logically merged support components in the initial 3D graphic are copied to the corresponding axis to obtain the final 3D graphic. A material list for residential photovoltaic modules is generated based on the final 3D graphics and preset rule tables.

2. The BOM generation method for residential photovoltaic systems according to claim 1, characterized in that, The step of converting the two-dimensional graphics in the drawing file according to the spatial coordinates of the valid graphic elements to obtain the initial three-dimensional graphics includes: The first three-dimensional coordinate information is obtained by comparing the position coordinates of the multi-line segments in the valid primitives with the height information of the corresponding multi-line segments in the extended data. The second three-dimensional coordinate information is obtained based on the center point coordinates of the blocks in the valid primitives and the height information of the blocks in the extended data. The initial three-dimensional graphic is obtained based on the first three-dimensional coordinate information and the second three-dimensional coordinate information.

3. The BOM generation method for residential photovoltaic systems according to claim 1, characterized in that, The process of obtaining the association between the two-dimensional graphics based on the grid lines in the initial three-dimensional graphic and the names of the two-dimensional graphics, and filling the supporting components corresponding to the valid graphic elements into the initial three-dimensional graphic based on the association, includes: Each 2D graphic name is matched with a grid to obtain the grid range corresponding to each 2D graphic. The 2D data of the supporting components corresponding to the valid graphic elements are obtained based on the grid range. The association relationship is obtained based on the 2D data and the geometric projection relationship. The 3D data of the supporting components corresponding to the valid graphic elements is obtained based on the association relationship. The supporting components corresponding to the valid graphic elements are filled into the initial 3D graphic based on the 3D data.

4. The BOM generation method for residential photovoltaic systems according to claim 1, characterized in that, Before generating the material list for residential photovoltaic modules based on the final 3D graphics and preset rule tables, the process also includes: The implicit structure in the two-dimensional graph is associated with the matching table to obtain the material data of the implicit structure.

5. A BOM generation method for residential photovoltaic systems according to claim 4, characterized in that, Based on the final 3D graphics and preset rule tables, a material list for residential photovoltaic modules is generated, including: Based on the material statistics requirements for residential photovoltaic modules, a preset rule table is defined. The types of modules in the final 3D graphics are matched with the preset rule table to obtain the statistical method. The quantity of modules is obtained based on the statistical method. The material list table is obtained based on the material data of the implicit structure and the quantity of modules.

6. The BOM generation method for residential photovoltaic systems according to claim 1, characterized in that, The material list includes a material list and a layered material association list.

7. A BOM generation system for residential photovoltaic systems, applicable to the BOM generation method for residential photovoltaic systems as described in any one of claims 1-6, characterized in that, Includes an initial 3D graphics acquisition module, a final 3D graphics acquisition module, and a materials list acquisition module; The initial 3D graphic acquisition module is used to filter valid graphic elements from the drawing file through geometric attributes and layer naming rules, and to convert the 2D graphic in the drawing file according to the spatial coordinates of the valid graphic elements to obtain the initial 3D graphic. The final three-dimensional graphic acquisition module is used to obtain the association relationship between the two-dimensional graphic and the two-dimensional graphic name based on the grid in the initial three-dimensional graphic, fill the support components corresponding to the valid graphic elements into the initial three-dimensional graphic based on the association relationship, and copy the logically merged support components in the initial three-dimensional graphic to the corresponding axis according to the axis number in the grid to obtain the final three-dimensional graphic. The material list acquisition module is used to generate a material list table for residential photovoltaic modules based on the final 3D graphics and a preset rule table.

8. A BOM generation system for residential photovoltaic systems according to claim 7, characterized in that, It also includes a configuration management module, which is used to set the style of the material list table.

9. A BOM generation system for residential photovoltaic systems according to claim 7, characterized in that, It also includes an export module for exporting the material list as an Excel file.

10. A computer device, comprising: The computer device includes a processor, a memory, and a bus. The memory stores machine-readable instructions executable by the processor. When the computer device is running, the processor communicates with the memory via the bus, and the processor executes the machine-readable instructions to perform the steps of a BOM generation method for residential photovoltaic systems as described in any one of claims 1-6.

Images