Method and system for automatically generating product specification sheet based on three-dimensional software assembly model

Abstract

The application belongs to the technical field of computer-aided design, and discloses a method and system for automatically generating a product list based on a three-dimensional software assembly model. The application creatively proposes preset filtering conditions based on the inherent properties of components, which can automatically and accurately distinguish and filter "substantial components" and "non-substantial components" that need to be subjected to material statistics. This eliminates the possibility of mistakenly including invalid components in the list from the very source of data generation, realizes a very high accuracy of BOM data, and avoids subsequent process confusion and risks caused by data errors.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of computer-aided design, and in particular to a method and system for automatically generating a product bill of materials based on a three-dimensional software assembly model. BACKGROUND

[0002] In the digital design of products, especially in the fields of complex equipment manufacturing such as machinery, aviation, and automobiles, three-dimensional computer-aided design (CAD) software has become a core tool. Designers create assembly models containing thousands of parts through three-dimensional software. The product bill of materials (or bill of materials, BOM) is a key data carrier from design to manufacturing, procurement, and other links, and its accuracy and generation efficiency are crucial.

[0003] Currently, the mainstream method of generating a product bill of materials has the following significant drawbacks: First, it relies on manual operation, is inefficient, and has a high error rate. Current practice still relies heavily on users manually reviewing two-dimensional drawings or three-dimensional models, searching for and identifying part information (such as figure number, name, quantity, material, etc.) one by one, and manually inputting it into Excel or other table software. This approach not only consumes a large amount of man-hours when faced with complex assemblies, but also is prone to errors due to human negligence, posing a significant risk to subsequent work. Second, existing automated solutions cannot guarantee the accuracy and effectiveness of the data from the design source. Although there are some automated or semi-automated bill of materials generation solutions, they are mostly based on the engineering bill of materials (EBOM) in the product lifecycle management (PLM) system for conversion. However, EBOM itself cannot directly and accurately reflect the complete situation in the three-dimensional design environment. There are a large number of non-essential components (such as reference pieces for positioning, layout geometry, virtual parts, etc.) in the three-dimensional assembly model that do not need to appear in the official bill of materials. Existing EBOM-based solutions lack intelligent mechanisms to automatically identify and filter these non-essential components, resulting in the need for users to perform secondary screening and cleaning of the generated bill of materials, failing to achieve full-process automation. Third, there is a lack of functionality to meet the format requirements of specific specifications for the bill of materials. Even if part information can be extracted, the bill of materials generated by existing methods is often a simple data list, lacking the ability to automatically format according to project or institutional specific specifications. For example, the bill of materials needs to be sorted by figure number, distinguish between "parts" and "components" and separate by blank lines, support automatic pagination, and be able to automatically classify output according to rules (such as "another compilation into a book" identifier). These tedious formatting tasks still need to be completed manually by users, consuming a large amount of non-creative work time.

[0004] In view of this, the present application is proposed. SUMMARY

[0005] The present application aims to at least solve any one of the above technical problems, and provides a method and system for automatically generating a product specification sheet based on a three-dimensional software assembly model.

[0006] To achieve the above object, the present application provides a method for automatically generating a product specification sheet based on a three-dimensional software assembly model, comprising:

[0007] In response to a user's operation instruction in a three-dimensional software environment, starting a specification sheet automatic generation function;

[0008] The system automatically traverses the assembly structure of a target assembly selected by the user in the assembly navigator;

[0009] According to a preset component screening condition, the system automatically identifies and extracts essential components for material statistics from the assembly structure, wherein the preset component screening condition is used to distinguish essential components from non-essential components based on the intrinsic attribute values of the components;

[0010] The attribute information of the extracted essential components is organized according to a predefined layout rule for generating a standardized specification sheet, and is automatically filled into a specification sheet template to generate a final product specification sheet file.

[0011] Preferably, the preset component screening condition is a joint judgment based on the type attribute and reference attribute of the component.

[0012] Preferably, the preset component screening condition is that the type attribute of the component is marked as an entity part, and the reference attribute is not marked as a reference part.

[0013] Preferably, the type attribute is a DB_PART_TYPE attribute, and the preset value of the entity part is S4Part; the reference attribute is a REFERENCE_COMPONET attribute, and the preset value of the reference part is yes.

[0014] Preferably, the organization according to the predefined layout rule for generating a standardized specification sheet includes:

[0015] Filling the information of the target assembly into the first row of the specification sheet template;

[0016] Arranging all the extracted primary parts in the specification sheet from top to bottom according to their drawing numbers in ascending order, and filling in their corresponding attribute information;

[0017] After filling in all the primary part information, leaving a preset number of rows;

[0018] Arranging all the extracted primary components in the specification sheet from top to bottom according to their drawing numbers in ascending order, and filling in their corresponding attribute information.

[0019] Preferably, when filling the information of the primary components, for each primary component, a book judgment step is performed:

[0020] The book identification attribute of the primary component is read;

[0021] If the book identification attribute indicates that the component needs to be compiled into a book, the corresponding note column for the component in the bill of materials template is filled with identification information indicating that it needs to be compiled into a book.

[0022] Preferably, when filling the information of the primary components, the system automatically leaves a preset number of rows between the information records of two adjacent primary components.

[0023] Preferably, when filling the attribute information of the extracted essential components into the bill of materials template, the following steps are performed:

[0024] A mapping relationship between the attribute fields of the components in the three-dimensional software and the cell definition names in the bill of materials template is established;

[0025] According to the mapping relationship, the obtained attribute values are automatically filled into the corresponding cells.

[0026] Preferably, the generated final product bill of materials supports automatic paging, wherein the first page is fixed as a preset first number of rows, the continuation page is fixed as a preset second number of rows, and when the filled component information exceeds the fixed number of rows of the current page, the system automatically generates a new page.

[0027] The second aspect of the present application provides a system for automatically generating a product bill of materials based on a three-dimensional software assembly model, comprising:

[0028] A response unit for starting the bill of materials automatic generation function in response to a user's operation instruction in a three-dimensional software environment;

[0029] A traversal unit for automatically traversing the assembly structure of a target assembly selected by the user in the assembly navigator based on the system;

[0030] An identification and extraction unit for automatically identifying and extracting essential components that need to be counted from the assembly structure according to a preset component screening condition, wherein the preset component screening condition is used to distinguish essential components from non-essential components based on the intrinsic attribute values of the components;

[0031] A filling unit for organizing the attribute information of the extracted essential components according to a predefined layout rule for generating a standardized bill of materials, and automatically filling them into a bill of materials template to generate a final product bill of materials file.

[0032] Compared with the prior art, the present application has the following beneficial effects:

[0033] The application creatively proposes preset filtering conditions based on inherent attributes (such as type attributes and reference attributes) of components, and can automatically and accurately distinguish and filter "substantial components" and "non-substantial components" that need to be subjected to material statistics. This eliminates the possibility of mistakenly including invalid components into the detail list from the most source of data generation, realizes a very high accuracy of BOM data, and avoids subsequent process confusion and risks caused by data errors.

[0034] The application not only extracts data, but also automatically processes the detail list according to predefined layout rules, including sorting by drawing number, strictly distinguishing between parts and components and spacing blank lines, automatic paging, and automatic book separation according to the "another edition" attribute. The generated detail list does not need any manual post-adjustment, the format is uniform, the logic is clear, and it can be directly used for delivery or subsequent links, greatly improving the professionalism and usability of the output document.

[0035] The application directly runs in the internal three-dimensional software and is seamlessly integrated with the design environment. It directly reads the latest and real-time data of the design model, ensures that the detail list and the three-dimensional model always remain strictly consistent, solves the version inconsistency problem that may be caused by data export from different systems (such as PLM), and provides efficient and reliable data management closed loop for various users. BRIEF DESCRIPTION OF DRAWINGS

[0036] Figure 1 A flowchart of the method for automatically generating a product detail list based on a three-dimensional software assembly model according to the first embodiment of the application is provided.

[0037] Figure 2 A structural schematic diagram of the system for automatically generating a product detail list based on a three-dimensional software assembly model according to the second embodiment of the application is provided.

[0038] Figure 3 A schematic block diagram of an example electronic device 300 according to the application is provided. DETAILED DESCRIPTION

[0039] The technical solutions in the embodiments of the application will be described clearly and completely below with reference to the accompanying drawings in the embodiments of the application. Obviously, the described embodiments are only part of the embodiments of the application, rather than all the embodiments. Based on the embodiments in the application, all other embodiments obtained by those skilled in the art without creative labor fall within the scope of protection of the application.

[0040] Reference Figure 1 The first embodiment of the application provides a method for automatically generating a product detail list based on a three-dimensional software assembly model, which specifically includes:

[0041] S101, in response to the operation instruction of the user in the three-dimensional software environment, starting the bill of materials automatic generation function.

[0042] This step is to provide a man-machine interaction entrance to trigger the subsequent automation process. Among them, the "three-dimensional software environment" refers to a computer-aided design (CAD) system with assembly structure management, component attribute definition and secondary development interface. The "operation instruction" is received by creating a custom user interface element (such as a menu item, a toolbar button or a command dialog) through the secondary development interface provided by the three-dimensional software environment, which is used to extend and customize the functions of the three-dimensional software environment. This is a common technical means adopted by those skilled in the art to realize functional integration.

[0043] S102, the system automatically traverses the assembly structure based on the target assembly selected by the user in the assembly navigator.

[0044] The purpose of this step is to obtain the target object (total assembly) to be processed and its complete component logical relationship, which lays a data foundation for subsequent information extraction. This step is a common step of data preparation. Among them, the "assembly navigator" is a standard component tree diagram in three-dimensional software for visualizing and managing assembly hierarchy. The "target assembly" is the top-level or sub-assembly node selected by the user in the navigator. "Automatic traversal" refers to the process of taking the node as the root and accessing all child nodes (parts) under it.

[0045] S103, according to the preset component screening condition, automatically identifying and extracting the essential components that need to be material counted from the assembly structure, wherein the preset component screening condition is used to distinguish essential components from non-essential components based on the intrinsic attribute value of the component.

[0046] The purpose of this step is to intelligently and automatically locate the parts that need to be managed from the assembly that may contain a large amount of invalid data, and to ensure the accuracy of BOM data from the source. This step realizes the leap from "full acceptance" to "intelligent screening", replacing the error-prone process of relying on manual visual identification and judgment.

[0047] Among them, the "preset component screening condition" is the core of the application, which refers to a series of logical rules for judging whether a component should be included in the bill of materials. "Essential component" refers to a part of the physical structure of the final product that needs to be purchased, manufactured or managed. "Non-essential component" is opposite to "essential component", which refers to elements that exist in the assembly but should not appear in the production bill of materials, such as reference components (Reference Component), layout geometry, auxiliary surface, virtual parts, etc.

[0048] It is necessary to point out that references are very common in 3D design, but they are not physical parts of the product. They can be a sketch for positioning, a coordinate system defining the mounting axis, a helper surface for checking the clearance, or a shape reference model from another system. These components do not need to be machined, purchased or assembled, and are "virtual geometry" that exists purely to assist the design process. When manually compiling the bill of materials, the designer must use his eyes and experience to distinguish which are real parts and which are references, and this is a very error-prone and missing link. If a reference is mistakenly included in the BOM, it will cause the purchasing staff to order a non-existent part, or the production line to search for a non-existent component, causing confusion and cost waste.

[0049] The present application first explicitly proposes and constructs a joint screening condition based on the intrinsic attribute value of the component to realize the automatic identification of "substantial components", which is the essential difference from the prior art. The screening condition can be based on the type attribute and the reference attribute, the type attribute identifying the physical characteristics of the component, and the reference attribute identifying the functional use of the component. A preferred logic is: screen out components whose type attribute is marked as a physical part and whose reference attribute is not marked as a reference. This condition ensures that only components that need to be manufactured are screened out, excluding virtual references, and finally the product bill of materials only contains real parts and components that need to be counted, fundamentally eliminating the possibility of mistakenly including "references" in the BOM.

[0050] As an example, the type attribute is the DB_PART_TYPE attribute, and the preset value of the entity component is S4Part; the reference attribute is the REFERENCE_COMPONET attribute, and the preset value of the reference component is yes. The above logic is specifically: DB_PART_TYPE = S4Part (to ensure that the component is physical geometry) and REFERENCE_COMPONET ≠ yes (to exclude reference components). This specific combination of attributes perfectly solves the industry problem of automatically excluding invalid data such as references.

[0051] It can be understood that the preset screening condition is not limited to DB_PART_TYPE and REFERENCE_COMPONET. For example, in another 3D software, the same screening purpose can be achieved by judging whether the "PartCategory" attribute of the component is "Manufactured" (manufactured). Any condition that can automatically distinguish between substantial components and non-substantial components based on the intrinsic attributes of the component falls within the protection scope of the present application

[0052] S104, the extracted attribute information of the essential components is organized according to predefined layout rules for generating a standardized specification sheet, and is automatically filled into a specification sheet template to generate a final product specification sheet file.

[0053] The purpose of this step is to automatically convert the extracted raw data into a standardized document with a specified format and clear logic, which can be directly delivered for use, and to eliminate the tedious and error-prone manual layout work. This step is achieved through structured data processing and template filling.

[0054] The "predefined layout rules" are the core of the present application, which refers to a set of automatic instructions for controlling the final presentation form of the specification sheet. The "standardized specification sheet" refers to a specification sheet format that meets specific standards or internal enterprise specifications. The "specification sheet template" is a file (such as an Excel.xltx file) that has predefined formats, table headers, cell positions, and other styles.

[0055] It should be noted that the "layout rules" predefined in the embodiments of the present application are far more than a simple data list, but a set of structured and complex rules designed to simulate the layout logic of human experts. Specifically, the organization according to the predefined layout rules for generating a standardized specification sheet includes: filling the information of the target assembly into the first row of the specification sheet template; arranging all extracted primary parts in ascending order of their drawing numbers from top to bottom in the specification sheet, and filling in their corresponding attribute information; after filling in the information of all primary parts, leaving a predetermined number of rows; arranging all extracted primary components in ascending order of their drawing numbers from top to bottom in the specification sheet, and filling in their corresponding attribute information.

[0056] In complex product design, different components may be designed and managed by different teams, so it is necessary to automatically split the general assembly specification sheet into sub-books. The embodiments of the present application can also achieve this automatic book splitting. When filling in the information of the primary components, for each primary component, a book splitting judgment step is performed: reading the book splitting identification attribute of the primary component; if the book splitting identification attribute indicates that the component needs to be compiled into a separate book, then the identification information of the need-to-be-compiled-into-a-separate-book is filled into the corresponding remark column of the component in the specification sheet template.

[0057] As an example, the specific operation method of automatic book splitting includes: reading the "another book" attribute of the component; when the attribute value is "yes", automatically marking "another book" in the remark column; when the attribute value is "no", the remark column remains empty or fills in the original remark information.

[0058] In some preferred embodiments, to enhance the readability and hierarchy clarity of the detailed list, the embodiments of the present application further comprise a component spacing rule. Specifically, when filling in the information of the primary components, the system automatically leaves a preset number of lines between the information records of two adjacent primary components. The specific number of lines to be left can be selected by those skilled in the art according to reading habits, etc., such as two lines, three lines, etc.

[0059] In some preferred embodiments, when filling in the attribute information of the extracted essential components into the detailed list template, the following is performed: a mapping relationship between the attribute fields of the components in the three-dimensional software and the cell definition names in the detailed list template is established; and according to the mapping relationship, the obtained attribute values are automatically filled into the corresponding cells.

[0060] As an example, the mapping relationship between the CAD attributes and the Excel template can be: software attribute DB_PART_NAME→ Excel definition name DB_PART_NAME; software attribute DRAWING_NO→ Excel definition name Drawing_NO; and software attribute INPUT_MATERIAL→ Excel definition name INPUT_MATERIAL.

[0061] In some preferred embodiments, the present application further has an automatic paging function for the generated final product detailed list, wherein the first page is fixed as a preset first number of lines, the continuation page is fixed as a preset second number of lines, and when the filled component information exceeds the fixed number of lines of the current page, the system automatically generates a new page. Both the preset first number of lines and the preset second number of lines can be selected by those skilled in the art according to actual conditions.

[0062] As an example, the first page is fixed as 15 lines of detailed content, the continuation page is fixed as 19 lines of detailed content, and when the number of lines exceeds the fixed number of lines, the page is automatically paginated, and the header and footer are automatically updated.

[0063] It can be seen that this step can automatically process the "primary parts" and "primary components" in blocks, and sort them according to the drawing number, and automatically insert blank lines between the blocks; this rule makes the hierarchical relationship of the detailed list clear at a glance, which is a significant progress; it can automatically judge the "book identification attribute" of the components (such as "another book"), and mark it in the remark column; this realizes the intelligent classification management of the detailed list, which is not seen in the prior art; blank lines are automatically inserted between components, further improving readability; and the page is automatically paginated according to the fixed number of lines, and the page number is managed.

[0064] The first embodiment of the present application adopts preset rules based on the inherent properties of components for automatic screening, automatically extracts the "substantial components" that need to be counted from the complex three-dimensional assembly model, and automatically filters out non-substantial virtual components such as reference parts and layout bodies, thereby ensuring the accuracy and effectiveness of the BOM from the data source, and replacing the easily error-prone manual identification process. Then, through a pre-defined layout rule engine, the extracted component information is subjected to a series of automatic operations, and is automatically organized into a clear structure of a detailed table, and the generated detailed table is uniform, standard and professional, and does not need any manual post-adjustment, and can be directly used for production.

[0065] Embodiment

[0066] This embodiment describes in detail the automatic generation method of product detailed table in a three-dimensional CAD software environment with assembly structure management, component property definition and secondary development interface.

[0067] S1, function start and interface interaction: open the assembly model of the target product. In the main menu, click the

detailed table extraction

tool kit

detailed table output

[0068] S2, assembly structure selection and automatic traversal: select the target top-level assembly component (for example, "hole body mechanical system" with figure number DT0.0) in the "assembly navigator". The system automatically takes this selected component as the top point, traverses the entire assembly structure downward, and caches the logical relationship and pointer of all components.

[0069] S3, automatic identification and extraction of substantial components: the system automatically identifies and extracts the substantial components that need to be counted from all the components traversed according to the preset component screening conditions. In this embodiment, the preset screening conditions are specifically: extracting all components with DB_PART_TYPE attribute value as S4Part (indicating that the component is a solid part) and REFERENCE_COMPONET attribute value not as yes (indicating that the component is not a reference part).

[0070] Execution process: the system queries the internal attributes of each component in the assembly structure. For example, it extracts components and parts such as DT0.1 (support seat plate), DT0.2 (large gasket 48) that meet the conditions, and automatically filters out those components marked as reference parts or non-solid geometry. The extracted component list and its key attributes (such as figure number and name) are displayed in real time in the table of the

detailed table output

[0071] S4, structured generation and output of the bill of materials: the system organizes the extracted attribute information of the essential components according to the predefined layout rules for generating the standardized bill of materials, and fills them into a predefined Excel template.

[0072] S4-1: attribute mapping: the system establishes a mapping relationship between the component attributes and the Excel template cells. Part of the mapping relationship is shown in Table 1.

[0073] Table 1 Part of the mapping relationship

[0074] .

[0075] S4-2: layout organization rules: the system fills the data into the Excel template according to the following strict rules. (1) First row: fill the name, drawing number, etc. of the selected target assembly (DT0.0) into the title bar fixed position on the first page of the bill of materials; (2) First part arrangement: among all the extracted components, first identify all the "first parts", and arrange them in ascending order according to their drawing numbers, then fill them into the bill of materials from top to bottom; (3) Empty row spacing: after filling all the first part information, the system automatically leaves three rows to distinguish; (4) First component arrangement and book judgment: identify all "first components", and arrange them in ascending order according to their drawing numbers, and fill them into the bill of materials from top to bottom; when filling each first component, the system will read the "another book" attribute of the component; if the attribute value is "yes", the system will automatically fill in the identification text "another book" in the "remark" column of the Excel template; if it is "no" or empty, it will be skipped; the system automatically leaves three rows between the information records of the adjacent two first components, so that the boundary between the components is clearer and easier to read; (5) Automatic paging: the bill of materials template is preset to have 15 rows on the first page and 19 rows on the continuation page. When the filled data exceeds the row limit of the current page, the system automatically performs a page change operation and updates the page number and total page information in the header and footer.

[0076] S5, file output: after all data processing is completed, the system generates the final Excel file according to the pre-defined naming rules (for example, "target drawing number-MX.xlsx"). Users can select the "open file after output" option, and the system will automatically open the bill of materials file after generation.

[0077] It should be noted that: the above is only an example of a three-dimensional CAD software environment with assembly structure management, component attribute definition and secondary development interface, but the protection scope of the present application is not limited thereto. For example, in other three-dimensional CAD software, the "preset filtering condition" can be to judge whether the PartCategory attribute of the component is Manufactured (manufactured part). Any method that uses "automatic filtering of substantive components based on component attributes" and "generates a standardized bill of materials according to a pre-defined layout rule" falls within the protection scope of the present application.

[0078] Reference Figure 2 The second embodiment of the present application provides a system 200 for automatically generating a product bill of materials based on a three-dimensional software assembly model, which comprises a response unit 201, a traversal unit 202, an identification and extraction unit 203, and a filling unit 204, and the functions of each unit are described as follows:

[0079] The response unit 201 is used to respond to the user's operation instructions in the three-dimensional software environment, and start the bill of materials automatic generation function;

[0080] The traversal unit 202 is used to automatically traverse the assembly structure based on the target assembly selected by the user in the assembly navigator;

[0081] The identification and extraction unit 203 is used to automatically identify and extract substantive components that need to be counted from the assembly structure according to the pre-defined component filtering condition, wherein the pre-defined component filtering condition is used to distinguish substantive components from non-substantive components based on the intrinsic attribute value of the component;

[0082] The filling unit 204 is used to organize the attribute information of the extracted substantive components according to the pre-defined layout rule for generating a standardized bill of materials, and automatically fill them into the bill of materials template to generate the final product bill of materials file.

[0083] Based on the above embodiment, the present application further provides an electronic device, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, wherein the processor implements the steps in the method for automatically generating a product bill of materials based on a three-dimensional software assembly model in the first embodiment when executing the computer program.

[0084] Figure 3A schematic block diagram of an example electronic device 300 that can be used to implement embodiments of the present invention is shown. The electronic device is intended to represent various forms of digital computers, such as laptop computers, desktop computers, workstations, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device may also represent various forms of mobile devices, such as personal digital processors, cellular phones, smartphones, wearable devices, and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely illustrative and are not intended to limit the implementation of the invention described and / or claimed herein.

[0085] like Figure 3 As shown, the electronic device 300 may include a computing unit 301, which can perform various appropriate actions and processes according to a computer program stored in a read-only memory (ROM) 302 or a computer program loaded from a storage unit 308 into a random access memory (RAM) 303. The RAM 303 may also store various programs and data required for the operation of the device 300. The computing unit 301, the ROM 302, and the RAM 303 are interconnected via a bus 304. An input / output (I / O) interface 305 is also connected to the bus 304.

[0086] Multiple components in device 300 are connected to input / output (I / O) interface 305, including: input unit 306, such as keyboard, mouse, etc.; output unit 307, such as various types of monitors, speakers, etc.; storage unit 308, such as disk, optical disk, etc.; and communication unit 309, such as network card, modem, wireless transceiver, etc. Communication unit 309 allows device 300 to exchange information / data with other devices through computer networks such as the Internet and / or various telecommunications networks.

[0087] The computing unit 301 can be various general and / or special purpose processing components with processing and computing capabilities. Some examples of the computing unit 301 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various specialized artificial intelligence (AI) computing chips, various computing units running machine learning model algorithms, a digital signal processor (DSP), and any appropriate processor, controller, microcontroller, etc. The computing unit 301 performs various methods and processes described above, such as the method of automatically generating a product specification sheet based on a three-dimensional software assembly model. For example, in some embodiments, the method of automatically generating a product specification sheet based on a three-dimensional software assembly model can be implemented as a computer software program that is tangibly embodied in a machine-readable medium, such as the storage unit 308. In some embodiments, part or all of the computer program can be loaded and / or installed onto the device 300 via the read-only memory (ROM) 302 and / or the communication unit 309. When the computer program is loaded onto the random access memory (RAM) 303 and executed by the computing unit 301, one or more steps of the method of automatically generating a product specification sheet based on a three-dimensional software assembly model described above can be performed. Alternatively, in other embodiments, the computing unit 301 can be configured to perform the method of automatically generating a product specification sheet based on a three-dimensional software assembly model by any other appropriate means, such as by means of firmware.

Claims

1. A method for automatically generating a product specification sheet based on a three-dimensional software assembly model, characterized in that, The application relates to a bill of materials automatic generation method and system. The method comprises the following steps: In response to a user's operation instruction in a three-dimensional software environment, a bill of materials automatic generation function is started; The system automatically traverses an assembly structure of a target assembly selected by the user in an assembly navigator; According to preset component screening conditions, essential components for material statistics are automatically identified and extracted from the assembly structure, wherein the preset component screening conditions are that a type attribute of a component is marked as an entity part and a reference attribute of the component is not marked as a reference part, and the essential components are distinguished from non-essential components based on intrinsic attribute values of the components; 2. The method for automatically generating a product specification sheet based on a three-dimensional software assembly model according to claim 1, wherein, Information of the target assembly is filled in a first row of a bill of materials template, all extracted first-level parts are arranged in the bill of materials from top to bottom in ascending order of drawing numbers, and corresponding attribute information is filled in; after all first-level part information is filled, a preset number of rows are left empty; all extracted first-level components are arranged in the bill of materials from top to bottom in ascending order of drawing numbers, and corresponding attribute information is filled in and automatically filled into the bill of materials template, thereby generating a final product bill of materials file.

3. The method for automatically generating a product specification sheet based on a three-dimensional software assembly model according to claim 1, wherein, The type attribute is a DB_PART_TYPE attribute, and a preset value of the entity part is S4Part; the reference attribute is a REFERENCE_COMPONET attribute, and a preset value of the reference part is yes. When filling information of the first-level components, for each first-level component, a volume judgment step is performed: A volume identification attribute of the first-level component is read; 4. The method for automatically generating a product specification sheet based on a three-dimensional software assembly model according to claim 1, wherein, If the volume identification attribute indicates that the component needs to be compiled into another volume, identification information of needing to be compiled into another volume is filled in a corresponding remark column of the component in the bill of materials template.

5. The method for automatically generating a product specification sheet based on a three-dimensional software assembly model according to claim 1, wherein, When filling information of the first-level components, the system automatically leaves a preset number of rows empty between information records of two adjacent first-level components. When filling attribute information of the extracted essential components into the bill of materials template, the following steps are performed: A mapping relationship between attribute fields of the components in the three-dimensional software and cell definition names in the bill of materials template is established; 6. The method for automatically generating a product specification sheet based on a three-dimensional software assembly model according to claim 1, wherein, According to the mapping relationship, attribute values obtained are automatically filled into corresponding cells.

7. A system for automatically generating a product specification sheet based on a three-dimensional software assembly model, characterized in that, The generated final product bill of materials supports automatic paging, wherein a first page is fixed as a preset first number of rows, a continuation page is fixed as a preset second number of rows, and when filled component information exceeds a fixed number of rows of a current page, a new page is automatically generated. The application relates to a bill of materials automatic generation method and system. The method comprises the following steps: In response to a user's operation instruction in a three-dimensional software environment, a bill of materials automatic generation function is started; The system automatically traverses an assembly structure of a target assembly selected by the user in an assembly navigator; According to preset component screening conditions, essential components for material statistics are automatically identified and extracted from the assembly structure, wherein the preset component screening conditions are that a type attribute of a component is marked as an entity part and a reference attribute of the component is not marked as a reference part, and the essential components are distinguished from non-essential components based on intrinsic attribute values of the components; The filling unit is used for filling the information of the target assembly into the first row of the bill of materials template; arranging all the extracted primary parts in the bill of materials from top to bottom according to the ascending order of the drawing numbers of the primary parts, and filling the corresponding attribute information of the primary parts; leaving a preset number of rows after the filling of the information of all the primary parts is completed; arranging all the extracted primary parts in the bill of materials from top to bottom according to the ascending order of the drawing numbers of the primary parts, and filling the corresponding attribute information of the primary parts; and automatically filling into the bill of materials template to generate a final product bill of materials file.

Images