CN114398863A

CN114398863A - Equipment part summary table generation method, tool and electronic equipment

Info

Publication number: CN114398863A
Application number: CN202111594967.3A
Authority: CN
Inventors: 严宇欣; 朱海旭; 涂德海; 乐爱兵; 张阳天
Original assignee: Foundmacro Co ltd
Current assignee: Foundmacro Co ltd
Priority date: 2021-12-23
Filing date: 2021-12-23
Publication date: 2022-04-26

Abstract

The embodiment of the application provides a method, a tool and electronic equipment for generating a device component summary table, wherein the method comprises the following steps: acquiring a bill of materials of parts in a 3D model of equipment; summarizing the bill of materials according to the unique identifier of the part; and outputting the summarized bill of materials to a preset template to generate a summary table. The method and the device can improve the efficiency of manufacturing the summary table and reduce the error rate of manufacturing the summary table. Especially for the fixed format of the summary table required in the relevant national military standard (GJB), the method, the tool and the electronic equipment for generating the equipment component summary table provided by the embodiment of the application can greatly improve the compiling efficiency and ensure the standardization level of the output summary table.

Description

Equipment part summary table generation method, tool and electronic equipment

Technical Field

The embodiment of the application relates to the technical field of computer software, in particular to a method, a tool and electronic equipment for generating a device component summary table.

Background

In the documentation of military product development projects, the parts summary table, the outsourcing component summary table, the standard component summary table and other summary tables related to structural components are often required to be compiled, the table format is fixed, and the summary table files are required to be often output in the development process. When the summary table file is manufactured by structural designers, the process is complicated, the repeated labor amount is large, and errors are easy to occur. When a set of equipment comprises more sub-equipment, each sub-equipment needs to derive a summary table and needs to be combined and summarized, so that the labor capacity is larger, and errors are more likely to occur.

Disclosure of Invention

In order to improve efficiency and accuracy in summary table manufacturing, embodiments of the present application provide a method, a tool, and an electronic device for generating a device component summary table.

In a first aspect of the present application, a method for generating a device component summary table is provided, including:

acquiring a bill of materials of parts in a 3D model of equipment;

summarizing the bill of materials according to the unique identifier of the part;

and outputting the summarized bill of materials to a preset template to generate a summary table.

In a possible implementation manner, the obtaining a bill of materials of parts in a 3D model of a device includes:

calling an SDK (software development kit) of 3D software, and acquiring a bill of materials of a 3D model of equipment in the 3D software according to the SDK of the 3D software; or

Reading a bill of materials of a 3D model of equipment in STP and STL format files exported by 3D software according to the SDK supporting STP and STL formats; or

Exporting the material information of the 3D model of the equipment in the 3D software into a file with txt, csv and excel formats, and reading the exported material information to obtain the bill of materials.

In one possible implementation, the parts include outsourced parts and standard parts;

the collecting the bill of materials according to the part code includes:

and summarizing the bill of materials of the purchased parts and/or the bill of materials of the standard parts according to the part code.

In a possible implementation manner, the outputting the aggregated bill of materials to a preset template to generate a summary table includes:

based on the bill of materials, carrying out keyword substitution according to an SDK (software development kit) of office software or a third-party development library so as to realize filling of the preset template; or

Based on the bill of materials, generating and filling the content of a specified template according to the SDK of the office software or a third-party development library; or

And generating a summary table in a specified format according to the SDK of the office software or a third-party development library based on the bill of materials.

In a possible implementation manner, the performing, based on the bill of materials, keyword replacement according to an SDK of office software or a third party development library to implement filling of the preset template includes:

filtering the bill of materials to obtain a bill of materials of the purchased parts;

and editing forms according to the SDK of the office software or a third-party development library based on the bill of materials of the purchased parts so as to fill the preset template.

filtering the bill of materials to obtain a bill of materials of the standard parts;

and editing forms according to the SDK of the office software or a third-party development library based on the bill of materials of the standard parts so as to fill in the preset template.

In a possible implementation manner, after obtaining the bill of materials of the parts in the 3D model of the device, the method further includes:

editing the bill of materials to perfect material information and modify the information in the bill of materials.

In a possible implementation manner, after the outputting the aggregated bill of materials to the preset template to generate the summary table, the method further includes:

and calling the SDK capable of outputting the PDF, Word or Excel files, and outputting the summary table into the PDF, Word or Excel files.

In a second aspect of the present application, there is provided an equipment component summary table generating tool, including:

the acquisition module is used for acquiring a bill of materials of parts in the 3D model of the equipment;

the summarizing module is used for summarizing the bill of materials according to the unique identifier of the part;

and the generating module is used for outputting the summarized bill of materials to a preset template so as to generate a summary table.

In a third aspect of the present application, an electronic device is provided, comprising a memory having stored thereon a computer program and a processor implementing the method according to any of the first aspect when executing the computer program.

In the method, the tool and the electronic device for generating the equipment part summary table, the bill of materials of the parts in the 3D model of the equipment is firstly obtained, then the bill of materials is summarized according to the part code, finally the summarized bill of materials is output to the preset template to generate the summary table, and when different summary tables are generated, different templates can be selected according to different standards to automatically generate the summary table, so that the efficiency of manufacturing the summary table can be improved, and the error rate of manufacturing the summary table can be reduced. Especially for the fixed format of the summary table required in the relevant national military standard (GJB), the method, the tool and the electronic equipment for generating the equipment component summary table provided by the embodiment of the application can greatly improve the compiling efficiency and ensure the standardization level of the output summary table.

It should be understood that what is described in this summary section is not intended to limit key or critical features of the embodiments of the application, nor is it intended to limit the scope of the application. Other features of the present application will become apparent from the following description.

Drawings

The above and other features, advantages and aspects of various embodiments of the present application will become more apparent by referring to the following detailed description when taken in conjunction with the accompanying drawings. In the drawings, like or similar reference characters designate like or similar elements, and wherein:

fig. 1 shows a flowchart of a device component summary table generation method according to an embodiment of the present application.

FIG. 2 shows a block diagram of a device parts summary table generation tool according to an embodiment of the present application.

Fig. 3 shows a schematic structural diagram of an electronic device suitable for implementing embodiments of the present application.

Detailed Description

In order to make the objects, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application.

In order to facilitate understanding of the embodiments of the present application, some terms referred to in the embodiments of the present application are first explained.

Bill of Materials (BOM), a technical document describing the composition of an enterprise product, indicates the structural relationship between the product's assembly, subassemblies, components, parts, and raw Materials, as well as the quantities required, in the process capital industry.

Software Development Kit (SDK) is generally a collection of Development tools used by some Software engineers to build application Software for a particular Software package, Software framework, hardware platform, operating system, and the like. And (4) developing a library by a third party, namely the SDK of the third party.

Next, a method for generating a component summary table according to an embodiment of the present application will be described. Fig. 1 shows a flowchart of a device component summary table generation method according to an embodiment of the present application. In some embodiments, the method may be performed by an electronic device. Referring to fig. 1, the method comprises the steps of:

step 110, a bill of materials of the parts in the 3D model of the device is obtained.

In the embodiment of the application, the parts comprise outsourcing parts, standard parts and self-control parts. The bill of materials at least includes the part code, the part name, the part quantity, the part and the part type.

In some alternative embodiments, the bill of materials for the part may be derived from a 3D model of the device in 3D design software. Specifically, the bill of materials of the parts can be derived in the following three ways.

The first method is as follows: because the SDK has the function of automatically reading the bill of material of the 3D model of the device in the 3D software, the SDK of the 3D software can be directly called to obtain the bill of material of the device. Note that the SDK differs among different 3D software.

The second method comprises the following steps: since the 3D software can export the file into a standard STP, STL, or other format file, the reading of the standard format model can be realized by the SDK or development library supporting the format, so as to obtain the bill of materials in the model. That is, this method needs to first convert the 3D model in the 3D software into a general format (for example, STP, STL, etc.), and then call the SDK to read the bill of materials in the file after the format conversion.

The third method comprises the following steps: since the 3D software can also export the bill of materials into files in txt, csv, excel, and the like, the files in txt, csv, excel, and the like can be directly read to obtain the bill of materials.

The 3D software in the embodiment of the present application may be Pro/Engineer or SolidWorks.

In other optional embodiments, after the bill of materials of the parts in the 3D model of the device is obtained, the bill of materials may be stored in the database, and when the bill of materials needs to be used, the bill of materials may be directly called from the database. For example, when a part of the bill of materials needs to be used, the part of the bill of materials can be called from the database, and other bills of materials are stored in the database so as to be directly called when the follow-up use is facilitated.

In some embodiments, after the bill of materials is derived, information in the bill of materials (e.g., part information) may be changed after the part information in the bill of materials (e.g., part code, manufacturer, etc.) is changed. For example, when a change is made to a certain batch of part numbers or manufacturers, the part information may be directly modified in batch to change. For example, when a certain batch of equipment parts lacks certain attribute information, the attribute information may be completed in batches. Because the changed contents in the file need to be judged and processed manually, the time is long, and mistakes are easy to make, so that the efficiency can be improved and the mistakes can be avoided by adopting a batch modification mode.

And step 120, summarizing the bill of materials according to the unique identification of the parts.

In the embodiment of the application, the bill of materials is summarized, that is, the number of the parts is counted. By way of example, the embodiment of the application can summarize the number of outsourcing parts, the number of standard parts, the number of self-control parts and the total number of parts.

In some alternative embodiments, the part numbers of different types of parts are different, so the part numbers can be used to summarize the parts. In other alternative embodiments, other unique attributes of the parts may also be specified and the parts may be aggregated based on the unique attributes.

In the embodiment of the present application, the number of components in a certain device may be summarized, or the number of all components in a certain system or multiple systems may be summarized.

Alternatively, after the number of parts in the plurality of devices is summarized, it may be counted to which device each part belongs.

In this application embodiment, gather the bill of materials according to the spare part code number, can enough accomplish fast and gather the operation, can avoid artifical mistake that gathers that causes to gather again to gather, leak and gather.

And step 130, outputting the aggregated bill of materials to a preset template to generate an aggregation table.

In the embodiment of the present application, the following three ways may be used to generate the summary table: based on the bill of materials, carrying out keyword substitution according to an SDK (software development kit) of office software or a third-party development library so as to realize filling of a preset template; based on the bill of materials, generating the content filling of a specified template according to the SDK of the office software or a third-party development library; and based on the bill of materials, generating a summary table in a specified format according to the SDK of the office software or a third-party development library.

In the embodiment of the present application, the preset template may be any template, such as a template specified in an army development process, a template specified in a civil development process, or a customized template. The following description will be made in detail by taking a template specified in the national military standard (GJB) as an example.

Illustratively, an equipment parts summary table template specified in the national military standard (GJB) of concern in the military development includes a home page including an equipment name, a file code, a total number of books, a current book number, a total number of pages, a preparation unit, and preparation time, and a content page including a parts code, a parts name, a parts number, a parts assembly number, a manufacturer, and remark information.

The generation of the summary table can be divided into two parts, one part is a generation home page, and the other part is a generation content page.

Generating a home page

In the first page, based on the bill of materials, keyword substitution is performed according to the SDK of the office software or a third-party development library so as to realize filling of equipment name, file code number, total book number, current book number, total page number, compilation unit and compilation time.

Generating a content page

And editing a form in the content page according to the SDK of the office software or a third-party development library based on the bill of materials so as to fill in the part code number, the part name, the part quantity, the part assembly number, the manufacturer and remark information.

The summary table comprises a part summary table, a standard component summary table and an outsourcing component summary table. When generating the part summary table, generating the part summary table based on all parts in the bill of materials; when the outsourcing component summary table is generated, the outsourcing component summary table needs to be generated based on the outsourcing components in the bill of materials; when generating the standard parts summary table, the parts summary table needs to be generated based on the standard parts in the bill of materials.

It can be known that before the outsourcing component summary table or the standard component summary table is generated, the bill of materials needs to be filtered first to obtain the bill of materials of the outsourcing component or the standard component.

Then, form editing can be performed in the content page according to the SDK of the office software or the third party development library based on the bill of materials of outsourcing parts or the bill of materials of standard parts, so as to fill in the part code, the part name, the part number, the part assembly number, the manufacturer, and the remark information.

In some embodiments, the format of the output summary table may be any format, for example, when the summary table in the PDF file format is to be output, an SDK capable of outputting the PDF file may be called, and the summary table is output as a PDF file. For another example, when a summary table in a Word file format is to be output, an SDK capable of outputting a Word file may be called, and the summary table may be output as a PDF file. Of course, when the summary table in other formats is to be output, a person skilled in the art may select the format output by the summary table according to actual needs, and only need to call the SDK or other tools capable of outputting the corresponding format.

According to the embodiment of the application, the bill of material of the parts in the 3D model of the equipment is firstly obtained, then the bill of material is collected according to the part code, finally the collected bill of material is output to the preset template to generate the summary table, and when different summary tables are generated, different templates can be selected according to different standards to automatically generate the summary table, so that the efficiency of manufacturing the summary table can be improved, and the error rate of manufacturing the summary table can be reduced. Especially for the fixed format of the summary table required in the relevant national military standard (GJB), the method, the tool and the electronic equipment for generating the equipment component summary table provided by the embodiment of the application can greatly improve the compiling efficiency and ensure the standardization level of the output summary table.

It should be noted that, for simplicity of description, the above-mentioned method embodiments are described as a series of acts or combination of acts, but those skilled in the art will recognize that the present application is not limited by the order of acts described, as some steps may occur in other orders or concurrently depending on the application. Further, those skilled in the art should also appreciate that the embodiments described in the specification are exemplary embodiments and that the acts and modules referred to are not necessarily required in this application.

The above is a description of method embodiments, and the embodiments of the present application are further described below by way of apparatus embodiments.

FIG. 2 shows a block diagram of a device parts summary table generation tool according to an embodiment of the present application. In some embodiments, the tool may be implemented as, or executed by, an electronic device. Referring to FIG. 2, the tool includes an acquisition module 210, a summarization module 220, and a generation module 230.

The obtaining module 210 is configured to obtain a bill of materials of the parts in the 3D model of the device.

And the summarizing module 220 is used for summarizing the bill of materials according to the part code.

And the generating module 230 is configured to output the summarized bill of materials to a preset template to generate a summary table.

In some embodiments, the obtaining module 210 is specifically configured to: calling the SDK of the 3D software, and acquiring a bill of materials of a 3D model of equipment in the 3D software according to the SDK of the 3D software; or obtaining a bill of materials of a 3D model of equipment in the 3D software according to the SDK supporting STP and STL formats; or exporting the material information of the 3D model of the equipment in the 3D software into a file with txt, csv and excel formats, and reading the exported material information to obtain a bill of materials.

In some embodiments, the aggregation module 220 is specifically configured to: and summarizing the bill of materials of the purchased parts and/or the bill of materials of the standard parts according to the part code.

In some embodiments, the generating module 230 is specifically configured to: and performing keyword replacement according to the SDK of the office software or a third-party development library based on the bill of materials to realize filling of the preset template.

In some embodiments, the generating module 230 is further specifically configured to: filtering the bill of materials to obtain a bill of materials of the purchased parts; and editing forms according to the SDK of the office software or a third-party development library based on the bill of materials of the purchased parts so as to fill the preset template.

In some embodiments, the generating module 230 is further specifically configured to: filtering the bill of materials to obtain a bill of materials of the standard parts; and editing forms according to the SDK of the office software or a third-party development library based on the bill of materials of the standard parts so as to fill in the preset template.

In some embodiments, the tool further comprises an editing module to: editing the bill of materials to modify the part code and the manufacturer.

In some embodiments, the tool further comprises an output module for: and calling the SDK capable of outputting the PDF file, and outputting the summary table as the PDF file.

It can be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working process of the described module may refer to the corresponding process in the foregoing method embodiment, and is not described herein again.

An embodiment of the present application further provides an electronic device, as shown in fig. 3, the electronic device 300 shown in fig. 3 includes: a processor 301 and a memory 303. Wherein the processor 301 is coupled to the memory 303, such as via bus 5002. Optionally, the electronic device 300 may also include a transceiver 304. It should be noted that the transceiver 304 is not limited to one in practical applications, and the structure of the electronic device 300 is not limited to the embodiment of the present application.

The Processor 301 may be a CPU (Central Processing Unit), a general-purpose Processor, a DSP (Digital Signal Processor), an ASIC (Application Specific Integrated Circuit), an FPGA (Field Programmable Gate Array) or other Programmable logic device, a transistor logic device, a hardware component, or any combination thereof. Which may implement or perform the various illustrative logical blocks, modules, and circuits described in connection with the disclosure. The processor 301 may also be a combination of computing functions, e.g., comprising one or more microprocessors, a combination of a DSP and a microprocessor, or the like.

Bus 302 may include a path that transfers information between the above components. The bus 302 may be a PCI (Peripheral Component Interconnect) bus, an EISA (Extended Industry Standard Architecture) bus, or the like. The bus 302 may be divided into an address bus, a data bus, a control bus, and the like. For ease of illustration, only one thick line is shown in FIG. 3, but this does not mean only one bus or one type of bus.

The Memory 303 may be a ROM (Read Only Memory) or other type of static storage device that can store static information and instructions, a RAM (Random Access Memory) or other type of dynamic storage device that can store information and instructions, an EEPROM (Electrically Erasable Programmable Read Only Memory), a CD-ROM (Compact Disc Read Only Memory) or other optical Disc storage, optical Disc storage (including Compact Disc, laser Disc, optical Disc, digital versatile Disc, blu-ray Disc, etc.), a magnetic Disc storage medium or other magnetic storage device, or any other medium that can be used to carry or store desired program code in the form of instructions or data structures and that can be accessed by a computer, but is not limited to these.

The memory 303 is used for storing application program codes for executing the scheme of the application, and the processor 301 controls the execution. The processor 301 is configured to execute application program code stored in the memory 303 to implement the aspects illustrated in the foregoing method embodiments.

Among them, electronic devices include but are not limited to: mobile terminals such as mobile phones, notebook computers, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), in-vehicle terminals (e.g., in-vehicle navigation terminals), and the like, and fixed terminals such as digital TVs, desktop computers, and the like. The electronic device shown in fig. 3 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiments of the present application.

The present application provides a computer-readable storage medium, on which a computer program is stored, which, when running on a computer, enables the computer to execute the corresponding content in the foregoing method embodiments. Compared with the prior art, in the embodiment of the application, the bill of material of the parts in the 3D model of the equipment is firstly obtained, then the bill of material is collected according to the part code, finally the collected bill of material is output to the preset template to generate the summary table, and when different summary tables are generated, different templates can be selected according to different standards to automatically generate the summary table, so that the efficiency of manufacturing the summary table can be improved, and the error rate of manufacturing the summary table can be reduced.

It should be understood that, although the steps in the flowcharts of the figures are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and may be performed in other orders unless explicitly stated herein. Moreover, at least a portion of the steps in the flow chart of the figure may include multiple sub-steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, which are not necessarily performed in sequence, but may be performed alternately or alternately with other steps or at least a portion of the sub-steps or stages of other steps.

The foregoing is only a partial embodiment of the present application, and it should be noted that, for those skilled in the art, several modifications and decorations can be made without departing from the principle of the present application, and these modifications and decorations should also be regarded as the protection scope of the present application.

Claims

1. A method for generating a summary table of components of a device is characterized by comprising the following steps:

acquiring a bill of materials of parts in a 3D model of equipment;

2. The method of claim 1, wherein obtaining a bill of materials for parts in a 3D model of a device comprises:

3. The method of claim 1, wherein the component parts include outsourced component parts and standard component parts;

the collecting the bill of materials according to the part code includes:

4. The method of claim 1, wherein outputting the aggregated bill of materials to a preset template to generate a summary table comprises:

5. The method according to claim 4, wherein the performing keyword replacement according to an SDK of office software or a third party development library based on the bill of materials to realize filling of the preset template comprises:

6. The method according to claim 4, wherein the performing keyword replacement according to an SDK of office software or a third party development library based on the bill of materials to realize filling of the preset template comprises:

7. The method of claim 1, wherein after obtaining the bill of materials of the parts in the 3D model of the device, further comprising:

8. The method of claim 1, wherein after outputting the aggregated bill of materials to a preset template to generate the aggregated table, the method further comprises:

9. An equipment component summary table generation tool, comprising:

10. An electronic device comprising a memory and a processor, the memory having stored thereon a computer program, wherein the processor, when executing the computer program, implements the method of any of claims 1-8.