A method, apparatus, equipment and storage medium for merging bills of materials.
By generating target bills of materials through automated grouping and part number replacement, the problem of inconsistent materials in electronic circuit design is solved, improving efficiency and accuracy, and simplifying the subsequent processing and material preparation process.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- INSPUR BUSINESS MACHINE CO LTD
- Filing Date
- 2022-12-20
- Publication Date
- 2026-06-30
AI Technical Summary
In electronic circuit design, inconsistent material selection by different hardware engineers can lead to multiple part numbers for materials with the same parameters after the design is finalized. This makes later maintenance difficult, increases the amount of wasted work and the risk of errors, and affects production and product quality.
By using automated methods to group materials based on their specification parameters, prioritizing and replacing part numbers, a target material list is generated, ensuring that materials with the same specification parameters correspond to only one part number, and merging material quantities and tag numbers.
It improved work efficiency, saved human resources, simplified the processing and material preparation process, reduced human error, and ensured the accuracy of the bill of materials.
Smart Images
Figure CN115774970B_ABST
Abstract
Description
Technical Field
[0001] This invention relates to the field of electronic circuit design, and in particular to a method, apparatus, device and storage medium for merging bills of materials. Background Technology
[0002] In electronic circuit design, component library management and BOM (Bill of Material) organization have always been two major headaches for hardware engineers. This is especially true in complex schematic designs, which are often collaborative efforts of multiple hardware engineers. During the merging of schematics after each module's design is complete, situations arise where different engineers select different materials for the same specifications, resulting in a messy final design with multiple part numbers for the same parameter. This not only hinders later maintenance but also introduces significant unnecessary workload into manufacturing and material preparation.
[0003] Currently, to address the aforementioned issues, hardware engineers need to re-check the drawings after assembly, identify and organize materials with the same specifications, and manually modify the BOM. This manual inspection and organization is not only tedious and inefficient, but also highly prone to errors when staff are fatigued. If the BOM is incorrect, it can cause disruptions to the subsequent production system, affecting not only product delivery time but also potentially product quality. Summary of the Invention
[0004] In view of this, the purpose of this invention is to provide a bill of materials merging method, which can automatically merge materials with the same specifications to obtain several groups of materials, and replace each part number in each group with the corresponding target part number, so that materials with the same specifications correspond to only one part number. This not only improves work efficiency and saves manpower, but also facilitates subsequent processing, production, and material preparation. The specific solution is as follows:
[0005] Firstly, this application provides a method for merging bills of materials, including:
[0006] Based on the material specifications, the materials in the current composite drawing are grouped to obtain several groups of materials; wherein, the materials in the current composite drawing are the materials involved in the composite drawing obtained by merging the circuit schematics of the target electronic product, and the materials in the same group have the same specifications.
[0007] Retrieve the priority of each material in each group of materials, and filter out the target priority that meets the preset priority conditions from each priority of each group of materials.
[0008] The target priority and the target part number corresponding to the target priority are used to replace other priorities and other part numbers in each group of materials to obtain several groups of replaced materials;
[0009] The replacement materials are classified into several groups based on material category. According to the classification results, a corresponding material tag number is added to each material of the same material category. The material quantity corresponding to each material in each group of replacement materials is merged with the material tag number to output a target material list corresponding to the target electronic product.
[0010] Optionally, the step of grouping the materials in the current composite drawing based on material specification parameters to obtain several groups of materials includes:
[0011] Determine the target material category corresponding to each material in the current composite drawing;
[0012] The target material specification parameters corresponding to the target material category are determined based on the pre-defined correspondence between material categories and material specification parameters.
[0013] The materials in the current composite drawing are grouped according to the target material specification parameters corresponding to each material to obtain several groups of materials.
[0014] Optionally, the step of grouping the materials in the current composite drawing based on material specification parameters to obtain several groups of materials includes:
[0015] By comparing the current composite material with the corresponding material from the previous composite material, it can be determined whether there are any new materials in the current composite material.
[0016] If they exist, the new materials are grouped based on the material specification parameters to obtain several groups of new materials;
[0017] Accordingly, the step of retrieving the priority corresponding to each material in each group of materials, and filtering out the target priority that meets the preset priority conditions from each priority corresponding to each group of materials, includes:
[0018] Retrieve the priority of each new material in each group of new materials, and filter out the target priority that meets the preset priority conditions from each priority of each new material in each group.
[0019] Optionally, the step of replacing other priorities and other material numbers in each group of materials with the target priority and the target part number corresponding to the target priority to obtain several groups of replaced materials includes:
[0020] Determine whether the first material specification parameter corresponding to each group of newly added materials exists in the second material specification parameter corresponding to the target material list output in the previous output;
[0021] If it does not exist, then a number of corresponding new materials are determined, and the target priority and the target part number corresponding to the target priority in each group of new materials are used to replace other priorities and other part numbers in each group of new materials to obtain a number of replaced materials.
[0022] Optionally, the step of replacing other priorities and other material numbers in each group of materials with the target priority and the target part number corresponding to the target priority to obtain several groups of replaced materials includes:
[0023] If they exist, then identify the corresponding groups of new materials, and determine whether the target priority in each group of new materials is greater than the priority corresponding to the first material specification parameter in the target material list output last time.
[0024] If it is greater than, then the corresponding several groups of the new materials are determined, and the target priority and the target part number corresponding to the target priority in each group of the new materials are used to replace the other priorities and other part numbers in each group of the new materials to obtain several groups of replaced materials.
[0025] If it is less than or equal to, then the corresponding sets of the new materials are determined, and the priority and the corresponding part number in the target material list output last time are used to replace each priority and each part number in the corresponding set of new materials to obtain several sets of replaced materials.
[0026] Optionally, the step of classifying several groups of replaced materials based on material category, and adding corresponding material tag numbers to each material of the same material category according to the classification results, includes:
[0027] Based on the material category, classify several groups of the replaced materials, and determine whether the classification results corresponding to the several groups of replaced materials are inconsistent with the material category in the previously output target material list;
[0028] If so, then for each material in the several groups of replaced materials corresponding to the inconsistent material categories, the corresponding material tag number is re-added;
[0029] If not, then based on the material tag number corresponding to each material category in the target bill of materials output in the previous output, add the corresponding material tag number to each material in several groups of replaced materials of the same material category;
[0030] Accordingly, the step of merging the quantity of each material in each group of replaced materials with the material tag number to output a target bill of materials corresponding to the target electronic product includes:
[0031] The quantity of each material in each group of replaced materials is combined with the material tag number to obtain a new material list corresponding to the target electronic product.
[0032] The newly added bill of materials is merged with the previously output target bill of materials to output the target bill of materials corresponding to the target electronic product.
[0033] Optionally, after determining whether the target priority in each group of newly added materials is greater than the priority corresponding to the first material specification parameter in the previously output target material list, the method further includes:
[0034] If it is greater than, then the corresponding groups of the new materials are determined, and the target priority and the target part number corresponding to the target priority in the previous output target material list are replaced with the priority and the corresponding part number corresponding to the first material specification parameter by using the target priority in each group of the new materials, so as to obtain the updated target material list of the previous output.
[0035] Accordingly, merging the newly added bill of materials with the previously output target bill of materials to output the current target bill of materials corresponding to the target electronic product includes:
[0036] The newly added bill of materials is merged with the updated target bill of materials of the previous output to output the target bill of materials corresponding to the target electronic product.
[0037] Secondly, this application provides a bill of materials merging apparatus, comprising:
[0038] The material grouping module is used to group the materials in the current composite drawing based on the material specification parameters to obtain several groups of materials; wherein, the materials in the current composite drawing are the materials involved in the composite drawing obtained by merging the circuit schematics of the target electronic product, and the materials in the same group have the same specification parameters;
[0039] The priority filtering module is used to retrieve the priority of each material in each group of materials, and filter out the target priority that meets the preset priority conditions from each priority of each group of materials.
[0040] The material replacement module is used to replace other priorities and other material numbers in each group of materials with the target priority and the target material number corresponding to the target priority, so as to obtain several groups of replaced materials;
[0041] The bill of materials merging module is used to classify several groups of the replaced materials based on material categories, add corresponding material tag numbers to each material of the same material category according to the classification results, and merge the material quantity corresponding to each material in each group of replaced materials with the material tag numbers to output the target bill of materials corresponding to the target electronic product.
[0042] Thirdly, this application provides an electronic device, comprising:
[0043] Memory, used to store computer programs;
[0044] A processor for executing the computer program to implement the aforementioned bill of materials merging method.
[0045] Fourthly, this application provides a computer-readable storage medium for storing a computer program that, when executed by a processor, implements the aforementioned bill of materials merging method.
[0046] In this application, the materials in the current composite drawing are grouped based on material specification parameters to obtain several groups of materials. The materials in the current composite drawing are those involved in the composite drawing obtained by merging the circuit schematics of the target electronic product, and each material in the same group has the same specification parameters. The priority of each material in each group is retrieved, and target priorities that meet preset priority conditions are selected from the priorities corresponding to each group of materials. The target priorities and their corresponding target part numbers are used to replace other priorities and other part numbers in each group of materials to obtain several groups of replaced materials. The replaced materials in these groups are classified based on material categories. According to the classification results, corresponding material tag numbers are added to each material in the same material category, and the material quantity corresponding to each material in each group of replaced materials is merged with the material tag numbers to output a target material list corresponding to the target electronic product. Therefore, this application automatically merges materials with the same specifications to obtain several groups of materials, and replaces the part number of each material in each group with the target part number corresponding to the target priority. This ensures that materials with the same specifications correspond to only one part number. Then, the quantities of each material in each group after replacement are merged, and the material tag numbers are superimposed. Finally, a target material list corresponding to the target electronic product is generated, which includes the part number, material tag number, material quantity, priority, and material specifications. This not only improves work efficiency and saves human resources, but also facilitates subsequent processing, production, and material preparation. Attached Figure Description
[0047] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on the provided drawings without creative effort.
[0048] Figure 1 This is a flowchart of a bill of materials merging method disclosed in this application;
[0049] Figure 2 This application discloses a material grouping flowchart;
[0050] Figure 3 This is a schematic diagram of a bill of materials output disclosed in this application;
[0051] Figure 4 This application discloses a flowchart for merging bills of materials.
[0052] Figure 5 This application discloses a specific method for merging bills of materials (BOMs).
[0053] Figure 6 This application discloses a flowchart for merging bills of materials.
[0054] Figure 7 This application discloses a specific method for merging bills of materials (BOMs).
[0055] Figure 8 This is a schematic diagram of a bill of materials merging device disclosed in this application;
[0056] Figure 9 This is a structural diagram of an electronic device disclosed in this application. Detailed Implementation
[0057] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.
[0058] Currently, for schematic designs completed collaboratively by multiple hardware engineers, different engineers may select different materials, resulting in multiple part numbers for materials with the same parameters after the schematics are merged. To facilitate subsequent processing, production, and material preparation, hardware engineers need to manually identify, organize, and modify these parts, which is time-consuming. Therefore, this application provides a bill of materials merging method. By automatically merging materials with the same specifications and parameters into several groups, each part number in each group is replaced with the target part number corresponding to the target priority. This ensures that materials with the same specifications and parameters correspond to only one part number, improving work efficiency, saving manpower, and facilitating subsequent processing, production, and material preparation.
[0059] See Figure 1 As shown in the figure, an embodiment of the present invention discloses a method for merging bills of materials, including:
[0060] Step S11: Group the materials in the current composite drawing based on the material specification parameters to obtain several groups of materials; wherein, the materials in the current composite drawing are the materials involved in the composite drawing obtained by merging the circuit schematics of the target electronic product, and the materials in the same group have the same specification parameters.
[0061] In this embodiment, firstly, in the PLM (Product Lifecycle Management) system, materials with the same specifications are assigned corresponding priority attributes based on their procurement attributes. Furthermore, the PLM system has pre-stored relevant material information, including but not limited to part number, material specifications, and material status. After the hardware engineer completes the circuit schematics for each module corresponding to the target electronic product, the schematics are merged to obtain the current composite schematic. All materials involved in the current composite schematic are the materials in the final composite schematic.
[0062] In this embodiment, grouping the materials in the current composite drawing based on material specification parameters to obtain several groups of materials may include determining the target material category corresponding to each material in the current composite drawing; determining the target material specification parameters corresponding to the target material category based on a preset correspondence between material categories and material specification parameters; and grouping the materials in the current composite drawing according to the target material specification parameters corresponding to each material to obtain several groups of materials. It is understood that, as... Figure 2As shown, the material specification parameters corresponding to different material categories are pre-entered to form a correspondence between material categories and material specification parameters. Then, the target material type of each material in the current composite drawing is retrieved. Based on the target material type and the correspondence, the corresponding target material specification parameters to be retrieved are determined. Finally, the materials in the current composite drawing are grouped according to the target material specification parameters of each material to obtain several groups of materials. In each group of materials, the specification parameters of each material are the same.
[0063] Step S12: Retrieve the priority of each material in each group of materials, and filter out the target priority that meets the preset priority conditions from each priority of each group of materials.
[0064] In this embodiment, the priority of each material in each group of materials with the same specifications is retrieved, and the highest priority is determined from each priority of each group of materials, and the highest priority is taken as the target priority.
[0065] Step S13: Use the target priority and the target part number corresponding to the target priority to replace other priorities and other part numbers in each group of materials to obtain several groups of replaced materials.
[0066] In this embodiment, after determining the target priority for each group of materials, the target priority and the target part number corresponding to the target priority are used to replace other priorities and other part numbers in the same group of materials to obtain several groups of replaced materials. That is, each group of replaced materials has the same material specification parameters, the same priority, and the same part number. This ensures that materials with the same material specification parameters correspond to only one part number, avoiding the problem of generating a large amount of invalid workload caused by materials with the same specification parameters corresponding to multiple part numbers. This facilitates subsequent processing, production, and material preparation.
[0067] Step S14: Classify several groups of the replaced materials based on the material category, add corresponding material tag numbers to each material of the same material category according to the classification results, and merge the material quantity corresponding to each material in each group of replaced materials with the material tag numbers to output the target material list corresponding to the target electronic product.
[0068] In this embodiment, several groups of replaced materials are categorized according to material type. Then, material tag numbers are added to materials of the same category one by one. The quantities of each material in each group of replaced materials are merged, and the material tag numbers are superimposed to output a target bill of materials corresponding to the target electronic product. The output target bill of materials includes, but is not limited to, part number, material tag number, material quantity, priority, material specifications, and material description. Figure 3As shown, the materials in the current composite drawing are grouped based on their specifications. There are three different materials with specifications of 110K (Value), 0402 (Package), and ±1% (Tolerance), which are grouped into one group. There are two different materials with specifications of 220 (Value), 0603 (Package), and ±1% (Tolerance), which are grouped into another group, resulting in two sets of materials. Then, the highest priority is selected from the priorities corresponding to each material in each group as the target priority. All other priorities and part numbers in that group are replaced with the target priority and its corresponding part number, resulting in two sets of replaced materials. Next, the two sets of replaced materials are categorized by material type. Since both sets of replaced materials are resistors, part numbers are added sequentially to each resistor, such as R1, R2, R3, etc. Finally, the quantities of each material in each set are merged, and the part numbers are superimposed to output the target material list corresponding to the target electronic product.
[0069] In this embodiment, as Figure 4 As shown, in the PLM system, materials with the same specifications are prioritized according to their procurement attributes. After the hardware engineer combines the drawings, the current combined materials are obtained. The "Create BOM" command is clicked, and the system automatically retrieves the material specifications of each material in the combined drawings. Materials with the same specifications are grouped together, resulting in several groups. The priority of each material in each group is retrieved, and each priority and part number in each group is replaced with the target priority and target part number of the highest priority material in the group, resulting in several replaced material groups. These replaced material groups are then categorized by material type, and component reference numbers are added to each component in the same material category. These component reference numbers are also the material reference numbers. Finally, the quantities of each material in each replaced material group are merged, and the material reference numbers are superimposed to export the target bill of materials corresponding to the target electronic product.
[0070] Therefore, this application automatically merges materials with the same specifications to obtain several groups of materials, and replaces the part number of each material in each group with the target part number corresponding to the target priority. This ensures that materials with the same specifications correspond to only one part number. Then, the quantities of each material in each group after replacement are merged, and the material tag numbers are superimposed. Finally, a target material list corresponding to the target electronic product is generated, which includes the part number, material tag number, material quantity, priority, and material specifications. This not only improves work efficiency and saves human resources, but also facilitates subsequent processing, production, and material preparation.
[0071] See Figure 5 As shown in the figure, an embodiment of the present invention discloses a method for merging bills of materials, including:
[0072] Step S21: By comparing the current composite material with the corresponding material from the previous composite material, determine whether there are any new materials in the current composite material. If so, group the new materials based on the material specification parameters to obtain several groups of new materials.
[0073] In this embodiment, when the designer modifies the previously designed circuit schematic and needs to re-output the target bill of materials (BOM) corresponding to the target electronic product, the materials in the current composite schematic are compared with those in the previous composite schematic. Materials whose composition has changed between the current and previous composite schematics are identified as new materials. These new materials are then grouped according to their specifications, resulting in several groups of new materials, each group sharing the same specifications. This way, subsequent processing of the new materials not only yields a new BOM but also allows the output of the target BOM corresponding to the current target electronic product.
[0074] Step S22: Retrieve the priority corresponding to each new material in each group of new materials, and filter out the target priority that meets the preset priority conditions from each priority corresponding to each group of new materials.
[0075] In this embodiment, the priority of each new material in each group of new materials is retrieved, and the highest priority is determined from each priority of each new material in each group. Then, the highest priority is determined as the target priority.
[0076] Step S23: Determine whether the first material specification parameter corresponding to each group of newly added materials exists in the second material specification parameter corresponding to the target material list output in the previous step.
[0077] In this embodiment, the first material specification parameter corresponding to each group of newly added materials is compared with the second material specification parameter involved in the target material list output in the previous step, and it is determined whether the first material specification parameter corresponding to each group of newly added materials is a material specification parameter different from the second material specification parameter.
[0078] Step S24: If it does not exist, determine the corresponding sets of new materials, and use the target priority in each set of new materials and the target part number corresponding to the target priority to replace other priorities and other part numbers in each set of new materials to obtain several sets of replaced materials.
[0079] In this embodiment, if it is determined that the first material specification parameters corresponding to several groups of newly added materials do not exist in the second material specification parameters corresponding to the target material list output in the previous step, that is, the first material specification parameters corresponding to several groups of newly added materials are different from the second material specification parameters, then the corresponding groups of newly added materials are determined, and each priority and each part number in each group of newly added materials are replaced with the target priority and the target part number corresponding to the target priority in the same group of newly added materials, to obtain several groups of replaced materials.
[0080] Step S25: Classify the several groups of replaced materials based on the material category, and determine whether the classification results corresponding to the several groups of replaced materials are inconsistent with the material category in the target material list output last time.
[0081] In this embodiment, several groups of replaced materials are classified according to their material categories, and it is determined whether the material categories corresponding to the several groups of replaced materials are different from the material categories involved in the target material list output in the previous step.
[0082] Step S26: If yes, then add the corresponding material tag number to each material in the several groups of replaced materials corresponding to the inconsistent material category.
[0083] In this embodiment, if the classification results corresponding to several sets of replaced materials are inconsistent with the material categories in the previously output target bill of materials, several sets of replaced materials corresponding to the inconsistent material categories are identified, and the corresponding material tag numbers are re-added to each material of the same material category in the several sets of replaced materials. For example, if the classification results corresponding to several sets of replaced materials include a resistor category, but the material categories involved in the previously output target bill of materials do not include a resistor category, then the corresponding material tag numbers are re-added to each material corresponding to the resistor category in the several sets of replaced materials in sequence, such as R1, R2, R3, etc.
[0084] Step S27: If not, then based on the material tag number corresponding to each material category in the target bill of materials output in the previous output, add the corresponding material tag number to each material in several groups of replaced materials of the same material category.
[0085] In this embodiment, if the classification results corresponding to several groups of replaced materials are consistent with the material categories in the previously output target material list, then according to the material tag numbers corresponding to each material category in the several groups of replaced materials, the corresponding material tag numbers are added sequentially to each material of the same material category. For example, if there is a resistor category in the classification results corresponding to several groups of replaced materials, and there is also a resistor category in the previously output target material list, and the material tag numbers for the resistor category in the previously output target material list have been arranged up to R20, then based on R20, the material tag numbers for each material corresponding to the resistor category in the several groups of replaced materials are added sequentially starting from R21.
[0086] Step S28: Combine the quantity of each material in each group of replaced materials with the material tag number to obtain a new material list corresponding to the target electronic product, and combine the new material list with the previously output target material list to output the target material list corresponding to the target electronic product this time.
[0087] In this embodiment, the quantities of each material in each group of replaced materials are merged, and the material tag numbers are superimposed to obtain a new bill of materials corresponding to the target electronic product. This new bill of materials provides a clear view of the changes between the materials in the current composite drawing and those in the previous composite drawing. Then, the new bill of materials is merged with the previously output target bill of materials to finally output the target bill of materials corresponding to the current target electronic product, which is also the target bill of materials corresponding to the materials in the current composite drawing. This method of generating a target bill of materials facilitates subsequent processing, production, and material preparation, improving work efficiency.
[0088] In this embodiment, see Figure 6As shown, in the PLM system, materials with the same specifications are prioritized according to their procurement attributes. After modifying the circuit schematic corresponding to the target electronic product, the current composite material is obtained. The current composite material is compared with the material from the previous composite material to identify new materials. Then, the "Update BOM" command is clicked to automatically retrieve the material specifications of each new material. Materials are grouped according to their specifications, with those having the same specifications grouped together, resulting in several groups of new materials. The priority of each material in each group is retrieved, and the highest priority is set as the target priority. These groups of new materials are compared with the previously output target bill of materials to identify groups of new materials with different specifications. Then, the priorities and part numbers in each group of new materials are replaced with the target priority and the corresponding target part number from the same group, resulting in several groups of replaced materials. Several sets of replaced materials are categorized according to material type, and the categorization results are compared with the material types involved in the previously output target bill of materials. Based on the comparison results, corresponding device reference numbers are added to each device in the same material type, where the device reference number is also the material reference number. Finally, the material quantities corresponding to each material in each set of replaced materials are merged, and the material reference numbers are superimposed to obtain a new bill of materials corresponding to the target electronic product. This new bill of materials is then merged with the previously output target bill of materials to output the target bill of materials corresponding to the current target electronic product.
[0089] Therefore, this application automatically merges new materials with the same specifications to obtain several groups of new materials. It then compares the material specifications of each group of new materials with those in the previously output target material list. Based on the comparison results, it replaces the part numbers of each material in each group with the target part number corresponding to the target priority, ensuring that new materials with the same specifications correspond to only one part number. Next, it merges the quantities of each material in each group after replacement and superimposes the part numbers to obtain a new material list corresponding to the target electronic product. Finally, it merges the new material list with the previously output target material list to obtain the target material list corresponding to the current target electronic product. This not only improves work efficiency and saves manpower but also facilitates subsequent processing, production, and material preparation.
[0090] As can be seen from the previous embodiment, this application determines whether the first material specification parameter corresponding to each group of newly added materials exists in the second material specification parameter corresponding to the previously output target material list. The case where the material does not exist is described. Therefore, this application will now describe the case where the material exists in detail. See [link to previous document]. Figure 7As shown, an embodiment of the present invention discloses a bill of materials merging process, including:
[0091] Step S31: Determine whether the first material specification parameter corresponding to each group of newly added materials exists in the second material specification parameter corresponding to the target material list output in the previous step.
[0092] Step S32: If it exists, determine the corresponding groups of newly added materials, and determine whether the target priority of each group of newly added materials is greater than the priority corresponding to the first material specification parameter in the target material list output last time.
[0093] In this embodiment, if it is determined that the first material specification parameters corresponding to several groups of newly added materials exist in the second material specification parameters corresponding to the target material list output in the previous output, then the corresponding groups of newly added materials are determined, and then the target priority corresponding to each group of newly added materials is compared with the priority corresponding to the first material specification parameters of the group of newly added materials in the target material list output in the previous output.
[0094] Step S33: If it is greater than, then determine the corresponding several groups of the new materials, and use the target priority in each group of the new materials and the target part number corresponding to the target priority to replace the other priorities and other part numbers in each group of the new materials to obtain several groups of replaced materials.
[0095] In this embodiment, if the value is greater than the target priority, several groups of new materials are identified. Then, each priority and part number in each group of new materials is replaced with the target priority and the target part number corresponding to the target priority in the same group of new materials, resulting in several groups of replaced materials. If the value is less than or equal to the target priority, several groups of new materials are identified. Then, the priority and part number corresponding to the first material specification parameter in the previously output target material list are used to replace each priority and part number in the corresponding group of new materials, resulting in several groups of replaced materials.
[0096] Step S34: If it is greater than, then determine the corresponding groups of the new materials, and use the target priority and the target part number corresponding to the target priority in each group of new materials to replace the priority and the corresponding part number in the target material list output in the last output to obtain the updated target material list output in the last output.
[0097] In this embodiment, if the value is greater than the target material, then while executing step S33, several groups of new materials will be identified. Then, the target priority and the corresponding material number in the target material list output in the previous output will be replaced with the first material specification parameter of the new material in the previous output, so as to obtain the updated target material list output in the previous output.
[0098] Step S35: Classify the several groups of replaced materials based on the material category, and determine whether the classification results corresponding to the several groups of replaced materials are inconsistent with the material category in the updated target material list of the previous output.
[0099] Step S36: If yes, then re-add the corresponding material tag number to each material in the several groups of replaced materials corresponding to the inconsistent material category.
[0100] Step S37: If not, add the corresponding material tag number to each material in several groups of replaced materials of the same material category based on the material tag number corresponding to each material category in the updated target bill of materials.
[0101] Step S38: Combine the quantity of each material in each group of replaced materials with the material tag number to obtain a new material list corresponding to the target electronic product, and combine the new material list with the updated target material list of the previous output to output the target material list corresponding to the target electronic product this time.
[0102] In this embodiment, since the target bill of materials output in the previous step S34 was updated, after obtaining the new bill of materials corresponding to the target electronic product, the new bill of materials will be merged with the updated target bill of materials output in the previous step to finally obtain the target bill of materials corresponding to the target electronic product in this step.
[0103] Therefore, this application compares the material specifications of several groups of newly added materials with the material specifications of the previously output target bill of materials. Based on the comparison results, several groups of newly added materials are selected. The target priority of each group of newly added materials is judged against the priority of the first material specification parameter of the newly added materials in the previously output target bill of materials. Based on the judgment results, the part number of each material in each group of newly added materials is replaced with the part number corresponding to the highest priority, so that the newly added material with the same specification parameter corresponds to only one part number. Then, the material quantity of each material in each group of replaced materials is merged and the material tag numbers are superimposed to obtain the newly added bill of materials corresponding to the target electronic product. Finally, the newly added bill of materials is merged with the updated target bill of materials of the previous output to obtain the target bill of materials corresponding to the target electronic product. This not only improves work efficiency and saves human resources, but also facilitates subsequent processing, production and material preparation.
[0104] See Figure 8 As shown, an embodiment of the present invention discloses a bill of materials merging device, comprising:
[0105] The material grouping module 11 is used to group the materials in the current composite drawing based on the material specification parameters to obtain several groups of materials; wherein, the materials in the current composite drawing are the materials involved in the composite drawing obtained by merging the circuit schematics of the target electronic product, and the materials in the same group have the same specification parameters.
[0106] The priority filtering module 12 is used to retrieve the priority corresponding to each material in each group of materials, and to filter out the target priority that meets the preset priority conditions from each priority corresponding to each group of materials.
[0107] The material replacement module 13 is used to replace other priorities and other material numbers in each group of materials with the target priority and the target material number corresponding to the target priority, so as to obtain several groups of replaced materials.
[0108] The bill of materials merging module 14 is used to classify several groups of the replaced materials based on the material category, add corresponding material tag numbers to each material of the same material category according to the classification results, and merge the material quantity corresponding to each material in each group of the replaced materials with the material tag numbers to output the target bill of materials corresponding to the target electronic product.
[0109] Therefore, this application automatically merges materials with the same specifications to obtain several groups of materials, and replaces the part number of each material in each group with the target part number corresponding to the target priority. This ensures that materials with the same specifications correspond to only one part number. Then, the quantities of each material in each group after replacement are merged, and the material tag numbers are superimposed. Finally, a target material list corresponding to the target electronic product is generated, which includes the part number, material tag number, material quantity, priority, and material specifications. This not only improves work efficiency and saves human resources, but also facilitates subsequent processing, production, and material preparation.
[0110] In some specific embodiments, the material grouping module 11 may specifically include:
[0111] The category determination unit is used to determine the target material category corresponding to each material in the current composite drawing;
[0112] The specification parameter determination unit is used to determine the target material specification parameters corresponding to the target material category based on the preset correspondence between material categories and material specification parameters;
[0113] The material grouping unit is used to group the materials in the current composite drawing according to the target material specification parameters corresponding to each material, so as to obtain several groups of materials.
[0114] In some specific embodiments, the material grouping module 11 may specifically include:
[0115] The newly added material determination unit is used to determine whether there are any newly added materials in the current composite drawing by comparing the current composite drawing material with the corresponding previous composite drawing material.
[0116] A new material grouping unit is added, which, if it exists, groups the new material based on the material specification parameters to obtain several groups of new materials.
[0117] Accordingly, the priority filtering module 12 may specifically include:
[0118] The priority filtering unit is used to retrieve the priority corresponding to each new material in each group of new materials, and to filter out the target priority that meets the preset priority conditions from each priority corresponding to each group of new materials.
[0119] In some specific embodiments, the material replacement module 13 may specifically include:
[0120] The specification parameter judgment unit is used to determine whether the first material specification parameter corresponding to each group of newly added materials exists in the second material specification parameter corresponding to the target material list output in the previous output.
[0121] The first material replacement unit is used to determine several groups of the new materials if they do not exist, and to replace other priorities and other material numbers in each group of the new materials with the target priority and the target part number corresponding to the target priority, so as to obtain several groups of replaced materials.
[0122] In some specific embodiments, the material replacement module 13 may specifically include:
[0123] The priority determination unit is used to determine, if it exists, several groups of the new materials, and determine whether the target priority of each group of the new materials is greater than the priority corresponding to the first material specification parameter in the target material list output in the previous output.
[0124] The second material replacement unit is used to determine several groups of the new materials if the value is greater than the target priority and the target part number corresponding to the target priority in each group of new materials to replace other priorities and other part numbers in each group of new materials, so as to obtain several groups of replaced materials.
[0125] The third material replacement unit is used to determine the corresponding sets of new materials if they are less than or equal to the first material specification parameters, and to replace each priority and each part number in the corresponding set of new materials with the priority and part number in the target material list output in the previous output, so as to obtain several sets of replaced materials.
[0126] In some specific embodiments, the bill of materials merging module 14 may specifically include:
[0127] The classification result judgment unit is used to classify several groups of the replaced materials based on the material category, and to determine whether the classification result corresponding to the several groups of replaced materials is inconsistent with the material category in the previously output target material list;
[0128] The first number addition unit is used to re-add the corresponding material tag number to each material in the several groups of replaced materials corresponding to inconsistent material categories if the material tag number is not specified.
[0129] The second tag addition unit is used to add the corresponding material tag to each material in several groups of replaced materials of the same material category based on the material tag corresponding to each material category in the previously output target bill of materials, if no.
[0130] Accordingly, the bill of materials merging module 14 may specifically include:
[0131] A new list output unit is added to merge the material quantity corresponding to each material in each group of replaced materials with the material tag number to obtain a new list of materials corresponding to the target electronic product.
[0132] The target list output unit is used to merge the newly added bill of materials with the previously output target bill of materials to output the target bill of materials corresponding to the target electronic product.
[0133] In some specific embodiments, the bill of materials merging device may further include:
[0134] The fourth material replacement unit is used to determine several groups of the newly added materials if the value is greater than the target priority in each group of the newly added materials and the target part number corresponding to the target priority to replace the priority and the corresponding part number in the target material list output in the previous output, so as to obtain the updated target material list output in the previous output.
[0135] Accordingly, the target list output unit can be used to merge the newly added bill of materials with the updated target bill of materials of the previous output, so as to output the target bill of materials corresponding to the target electronic product this time.
[0136] Furthermore, embodiments of this application also disclose an electronic device, Figure 9 This is a structural diagram of an electronic device 20 according to an exemplary embodiment. The content of the diagram should not be construed as limiting the scope of this application.
[0137] Figure 9 This is a schematic diagram of the structure of an electronic device 20 provided in an embodiment of this application. Specifically, the electronic device 20 may include: at least one processor 21, at least one memory 22, a power supply 23, a communication interface 24, an input / output interface 25, and a communication bus 26. The memory 22 stores a computer program, which is loaded and executed by the processor 21 to implement the relevant steps in the bill of materials merging method disclosed in any of the foregoing embodiments. Alternatively, the electronic device 20 in this embodiment may specifically be an electronic computer.
[0138] In this embodiment, the power supply 23 is used to provide operating voltage for each hardware device on the electronic device 20; the communication interface 24 can create a data transmission channel between the electronic device 20 and external devices, and the communication protocol it follows can be any communication protocol applicable to the technical solution of this application, and is not specifically limited here; the input / output interface 25 is used to acquire external input data or output data to the outside world, and its specific interface type can be selected according to specific application needs, and is not specifically limited here.
[0139] In addition, the memory 22, as a carrier for resource storage, can be a read-only memory, random access memory, disk or optical disk, etc. The resources stored thereon can include operating system 221, computer program 222, etc., and the storage method can be temporary storage or permanent storage.
[0140] The operating system 221 is used to manage and control the various hardware devices on the electronic device 20 and the computer program 222, which may be Windows Server, Netware, Unix, Linux, etc. In addition to including a computer program capable of performing the bill of materials merging method executed by the electronic device 20 as disclosed in any of the foregoing embodiments, the computer program 222 may further include a computer program capable of performing other specific tasks.
[0141] Furthermore, this application also discloses a computer-readable storage medium for storing a computer program; wherein, when the computer program is executed by a processor, it implements the aforementioned disclosed bill of materials merging method. Specific steps of this method can be found in the corresponding content disclosed in the foregoing embodiments, and will not be repeated here.
[0142] The various embodiments in this specification are described in a progressive manner, with each embodiment focusing on its differences from other embodiments. Similar or identical parts between embodiments can be referred to interchangeably. For the apparatus disclosed in the embodiments, since it corresponds to the method disclosed in the embodiments, the description is relatively simple; relevant parts can be referred to in the method section.
[0143] Those skilled in the art will further recognize that the units and algorithm steps of the various examples described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, computer software, or a combination of both. To clearly illustrate the interchangeability of hardware and software, the components and steps of the various examples have been generally described in terms of functionality in the foregoing description. Whether these functions are implemented in hardware or software depends on the specific application and design constraints of the technical solution. Those skilled in the art can use different methods to implement the described functions for each specific application, but such implementation should not be considered beyond the scope of this application.
[0144] The steps of the methods or algorithms described in conjunction with the embodiments disclosed herein can be implemented directly by hardware, a software module executed by a processor, or a combination of both. The software module can be located in random access memory (RAM), main memory, read-only memory (ROM), electrically programmable ROM, electrically erasable programmable ROM, registers, hard disk, removable disk, CD-ROM, or any other form of storage medium known in the art.
[0145] Finally, it should be noted that in this document, relational terms such as "first" and "second" are used only to distinguish one entity or operation from another, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Furthermore, the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such a process, method, article, or apparatus. Without further limitations, an element defined by the phrase "comprising one..." does not exclude the presence of other identical elements in the process, method, article, or apparatus that includes said element.
[0146] The technical solutions provided in this application have been described in detail above. Specific examples have been used to illustrate the principles and implementation methods of this application. The descriptions of the above embodiments are only for the purpose of helping to understand the methods and core ideas of this application. At the same time, for those skilled in the art, there will be changes in the specific implementation methods and application scope based on the ideas of this application. Therefore, the content of this specification should not be construed as a limitation of this application.
Claims
1. A method for merging bills of materials, characterized in that, include: Based on the material specifications, the materials in the current composite drawing are grouped to obtain several groups of materials; wherein, the materials in the current composite drawing are the materials involved in the composite drawing obtained by merging the circuit schematics of the target electronic product, and the materials in the same group have the same specifications. Retrieve the priority of each material in each group of materials, and filter out the target priority that meets the preset priority conditions from each priority of each group of materials; the preset priority conditions include that the target priority is the highest priority among all priorities; The target priority and the target part number corresponding to the target priority are used to replace other priorities and other part numbers in each group of materials to obtain several groups of replaced materials; Based on the material category, several groups of the replaced materials are classified. According to the classification results, corresponding material tag numbers are added to each material of the same material category. The material quantity corresponding to each material in each group of replaced materials is merged with the material tag number to output a target material list corresponding to the target electronic product. The step of grouping the materials in the current composite drawing based on material specification parameters to obtain several groups of materials includes: By comparing the current composite material with the corresponding material from the previous composite material, it can be determined whether there are any new materials in the current composite material. If they exist, the new materials are grouped based on the material specification parameters to obtain several groups of new materials; Accordingly, the step of retrieving the priority corresponding to each material in each group of materials, and filtering out the target priority that meets the preset priority conditions from each priority corresponding to each group of materials, includes: Retrieve the priority corresponding to each new material in each group of new materials, and filter out the target priority that meets the preset priority conditions from each priority corresponding to each new material in each group. The step of replacing other priorities and other material numbers in each group of materials with the target priority and the target part number corresponding to the target priority to obtain several groups of replaced materials includes: Determine whether the first material specification parameter corresponding to each group of newly added materials exists in the second material specification parameter corresponding to the target material list output in the previous output; If it does not exist, then a number of corresponding new materials are determined, and the target priority and the target part number corresponding to the target priority in each group of new materials are used to replace other priorities and other part numbers in each group of new materials to obtain a number of replaced materials. If they exist, then identify the corresponding groups of new materials, and determine whether the target priority of each group of new materials is greater than the priority corresponding to the first material specification parameter in the target material list output last time. If it is greater than, then the corresponding several groups of the new materials are determined, and the target priority and the target part number corresponding to the target priority in each group of the new materials are used to replace the other priorities and other part numbers in each group of the new materials to obtain several groups of replaced materials. If it is less than or equal to, then the corresponding sets of the new materials are determined, and the priority and the corresponding part number in the target material list output last time are used to replace each priority and each part number in the corresponding set of new materials to obtain several sets of replaced materials.
2. The bill of materials merging method according to claim 1, characterized in that, The process of grouping the materials in the current composite drawing based on material specification parameters to obtain several groups of materials includes: Determine the target material category corresponding to each material in the current composite drawing; The target material specification parameters corresponding to the target material category are determined based on the pre-defined correspondence between material categories and material specification parameters. The materials in the current composite drawing are grouped according to the target material specification parameters corresponding to each material to obtain several groups of materials.
3. The bill of materials merging method according to claim 1, characterized in that, The process of classifying several groups of replaced materials based on material category, and adding corresponding material tag numbers to each material of the same category according to the classification results, includes: Based on the material category, classify several groups of the replaced materials, and determine whether the classification results corresponding to the several groups of replaced materials are inconsistent with the material category in the previously output target material list; If so, then for each material in the several groups of replaced materials corresponding to the inconsistent material categories, the corresponding material tag number is re-added; If not, then based on the material tag number corresponding to each material category in the target bill of materials output in the previous output, add the corresponding material tag number to each material in several groups of replaced materials of the same material category; Accordingly, the step of merging the quantity of each material in each group of replaced materials with the material tag number to output a target bill of materials corresponding to the target electronic product includes: The quantity of each material in each group of replaced materials is combined with the material tag number to obtain a new material list corresponding to the target electronic product. The newly added bill of materials is merged with the previously output target bill of materials to output the target bill of materials corresponding to the target electronic product.
4. The bill of materials merging method according to claim 3, characterized in that, After determining whether the target priority of each group of newly added materials is greater than the priority corresponding to the first material specification parameter in the previously output target material list, the method further includes: If it is greater than, then the corresponding groups of the new materials are determined, and the target priority and the target part number corresponding to the target priority in the previous output target material list are replaced with the priority and the corresponding part number corresponding to the first material specification parameter by using the target priority in each group of the new materials, so as to obtain the updated target material list of the previous output. Accordingly, merging the newly added bill of materials with the previously output target bill of materials to output the current target bill of materials corresponding to the target electronic product includes: The newly added bill of materials is merged with the updated target bill of materials of the previous output to output the target bill of materials corresponding to the target electronic product.
5. A bill of materials merging device, characterized in that, The bill of materials merging device is used to implement the bill of materials merging method as described in any one of claims 1 to 4, and the bill of materials merging device includes: The material grouping module is used to group the materials in the current composite drawing based on the material specification parameters to obtain several groups of materials; wherein, the materials in the current composite drawing are the materials involved in the composite drawing obtained by merging the circuit schematics of the target electronic product, and the materials in the same group have the same specification parameters; The priority filtering module is used to retrieve the priority of each material in each group of materials, and filter out the target priority that meets the preset priority conditions from each priority of each group of materials. The material replacement module is used to replace other priorities and other material numbers in each group of materials with the target priority and the target material number corresponding to the target priority, so as to obtain several groups of replaced materials; The bill of materials merging module is used to classify several groups of the replaced materials based on material categories, add corresponding material tag numbers to each material of the same material category according to the classification results, and merge the material quantity corresponding to each material in each group of replaced materials with the material tag numbers to output the target bill of materials corresponding to the target electronic product.
6. An electronic device, characterized in that, include: Memory, used to store computer programs; A processor for executing the computer program to implement the bill of materials merging method as described in any one of claims 1 to 4.
7. A computer-readable storage medium, characterized in that, Used to store a computer program, which, when executed by a processor, implements the bill of materials merging method as described in any one of claims 1 to 4.