Bill of material management method and device, computer equipment and storage medium
By automatically matching and updating the replacement material information in the material dictionary, the problem of inconvenient maintenance in the electronic component management is solved, and the material maintenance efficiency and production efficiency are improved.
Patent Information
- Application Number
- CN202411403866.7
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-10-09
- Publication Date
- 2025-02-28
AI Technical Summary
In the prior art, the maintenance of alternative materials in electronic component management is inconvenient and inefficient, making it difficult to ensure production continuity.
By obtaining the initial electronic bill of materials and material dictionary, automatically match and update the replacement material information, reduce dependence on the drawing software and simplify the maintenance process.
It improves the efficiency of material maintenance, reduces the number of information maintenance and the probability of errors, and improves production efficiency.
Smart Images
Figure CN119539710A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the technical field of material management, and in particular to a bill of materials management method, apparatus, computer equipment and storage medium. Background Art
[0002] In the current electronic component management, due to unstable delivery dates, price fluctuations and other reasons, it is necessary to frequently introduce alternative materials to ensure production continuity. In the related technology, material information is manually updated in professional drawing software (such as Altium Designer, AD) and electronic dictionaries, and then the electronic bill of materials (EBOM, Engineering Bill of Materials) is exported through the drawing software. This dual-track maintenance method not only increases the workload, but also directly adding alternative material information in the drawing software is relatively complicated and time-consuming, resulting in low efficiency. Summary of the invention
[0003] The embodiments of the present application provide a bill of materials management method, apparatus, computer equipment and storage medium, which are intended to at least solve the technical problems of inconvenient maintenance and low efficiency of alternative materials and improve the efficiency of material maintenance.
[0004] The bill of materials management method of the implementation mode of the present application includes:
[0005] Acquire an initial electronic bill of materials and a material dictionary, wherein the initial electronic bill of materials includes a first material number;
[0006] Matching the first material number with the material dictionary to obtain a substitute material in the material dictionary that matches the first material number;
[0007] The substitute material matching the first material number in the material dictionary is updated to the bill of materials corresponding to the first material number in the initial bill of materials to obtain a target electronic bill of materials.
[0008] In some embodiments, the material dictionary includes a second material number and a substitute material corresponding to the second material number, and matching the first material number with the material dictionary to obtain a substitute material in the material dictionary that matches the first material number includes:
[0009] Matching the first material number with the second material number to obtain a matching second material number that matches the first material number;
[0010] Obtain a substitute material corresponding to the matching second material number.
[0011] In some embodiments, the material dictionary also includes the original material corresponding to the second material number, the initial electronic bill of materials also includes the original material corresponding to the first material number, and before obtaining the substitute material corresponding to the matching second material number, matching the first material number with the material dictionary to obtain the substitute material matching the first material number in the material dictionary further includes:
[0012] Obtaining a first original material corresponding to the first material number and a second original material corresponding to the matching second material number;
[0013] comparing the first original material with the second original material;
[0014] If the first original material is consistent with the second original material, then the substitute material corresponding to the matching second material number is obtained.
[0015] In some implementations, matching the first material number with the material dictionary to obtain a substitute material in the material dictionary that matches the first material number further includes:
[0016] If the first original material is inconsistent with the second original material, the substitute material corresponding to the matching second material number is not obtained, and the first original material is matched with the material dictionary to obtain the substitute material corresponding to the first original material as the substitute material matching the first material number.
[0017] In some implementations, matching the first material number with the material dictionary to obtain a substitute material in the material dictionary that matches the first material number includes:
[0018] Obtain a bill of materials corresponding to each of the first material numbers in the initial electronic bill of materials, the bill of materials including original materials and substitute materials;
[0019] The first material number without the alternative material information is used as the first material number to be improved;
[0020] The material number of the first material to be improved is matched with the material dictionary to obtain a substitute material in the material dictionary that matches the material number of the first material to be improved.
[0021] In some implementations, the attributes of the substitute material include the manufacturer of the substitute material and the model of the substitute material, and updating the substitute material matching the first material number in the material dictionary to the bill of materials corresponding to the first material number in the initial bill of materials to obtain the target electronic bill of materials includes:
[0022] The manufacturer and model of the substitute material matching the first material number in the material dictionary are updated to the substitute material information corresponding to the first material number in the initial bill of materials.
[0023] In some implementations, updating the substitute material in the material dictionary that matches the first material number to the bill of materials corresponding to the first material number in the initial bill of materials to obtain a target electronic bill of materials includes:
[0024] If there is no alternative material for the first material number in the initial bill of materials, then updating the alternative material matching the first material number in the material dictionary to the bill of materials corresponding to the first material number in the initial bill of materials;
[0025] If the first material number has an alternative material in the initial material list, compare the alternative material in the initial material list with the alternative material matching the first material number in the material dictionary;
[0026] If the comparison is inconsistent, compare the first original material corresponding to the first material number in the initial material list with the second original material matching the material dictionary. If the first original material and the second original material are consistent, replace the alternative material of the first material number in the initial material list with the alternative material of the first material number in the initial material list.
[0027] The material list management device of the embodiment of the present application includes an acquisition module, a matching module and an update module, wherein:
[0028] An acquisition module, used to acquire an initial electronic bill of materials and a material dictionary, wherein the initial electronic bill of materials includes a first material number;
[0029] A matching module, used for matching the first material number with the material dictionary to obtain a substitute material in the material dictionary that matches the first material number;
[0030] An updating module is used to update the substitute material matching the first material number in the material dictionary to the bill of materials corresponding to the first material number in the initial bill of materials to obtain a target electronic bill of materials.
[0031] The computer device of the embodiment of the present application includes a memory and a processor, the memory stores a computer program, and the processor implements the steps of the bill of materials management method described in any of the above embodiments when executing the computer program.
[0032] The computer-readable storage medium of the embodiment of the present application stores a computer program thereon, and when the computer program is executed by a processor, the steps of the bill of materials management method described in any of the above embodiments are implemented.
[0033] The computer program product of the embodiment of the present application includes a computer program, which implements the steps in the above-mentioned electronic material bill management method embodiment when executed by a processor.
[0034] The electronic bill of materials management method, electronic bill of materials management device, computer equipment, computer-readable storage medium, and computer program product provided in the embodiments of the present application automatically match the alternative material information corresponding to each material number in the electronic bill of materials with the alternative material information in the material dictionary, and update the information to the electronic bill of materials. Therefore, when it is necessary to maintain the alternative material information in the electronic bill of materials, it is only necessary to maintain the alternative material information corresponding to the material number in the material dictionary, and the alternative material information corresponding to the material number in the electronic bill of materials can be automatically updated. Maintenance is relatively simple, and there is no need to maintain the relevant information in the drawing software, which reduces the amount of information maintenance, reduces the probability of errors, and improves production efficiency.
[0035] Additional aspects and advantages of the embodiments of the present application will be given in part in the description below, and in part will become apparent from the description below, or will be learned through the practice of the present application. BRIEF DESCRIPTION OF THE DRAWINGS
[0036] The above and / or additional aspects and advantages of the present application will become apparent and easily understood from the description of the embodiments in conjunction with the following drawings, in which:
[0037] Figure 1 It is a flow chart of a bill of materials management method according to an implementation mode of the present application;
[0038] Figure 2 It is a structural schematic diagram of a bill of materials management device according to an implementation mode of the present application;
[0039] Figure 3 It is a schematic diagram of the principle of the bill of materials management method of the implementation mode of the present application;
[0040] Figure 4 It is a flow chart of a bill of materials management method according to an implementation mode of the present application;
[0041] Figure 5 It is a flow chart of a bill of materials management method according to an implementation mode of the present application;
[0042] Figure 6 It is a flow chart of a bill of materials management method according to an implementation mode of the present application;
[0043] Figure 7 It is a flow chart of a bill of materials management method according to an implementation mode of the present application;
[0044] Figure 8 It is a flow chart of a bill of materials management method according to an implementation mode of the present application;
[0045] Fig. 9 It is a schematic diagram of the principle of the bill of materials management method of the implementation mode of the present application;
[0046] Fig.10 It is a flow chart of a bill of materials management method according to an implementation mode of the present application;
[0047] Fig.11 is a schematic diagram of the structure of a computer device according to an embodiment of the present application;
[0048] Fig.12 It is a connection diagram between a computer-readable storage medium and a processor in an embodiment of the present application. DETAILED DESCRIPTION
[0049] The embodiments of the present application are described in detail below, and examples of the embodiments are shown in the accompanying drawings, wherein the same or similar reference numerals represent the same or similar elements or elements having the same or similar functions from beginning to end. The embodiments described below with reference to the accompanying drawings are exemplary and are only used to explain the embodiments of the present application, and cannot be understood as limiting the embodiments of the present application.
[0050] See also Figure 1 , the embodiment of the present application provides a bill of materials management method, in Figure 1 In the illustrated embodiment, the bill of materials management method includes the following steps 01 to 03.
[0051] 01. Obtain the initial electronic bill of materials and material dictionary. The initial electronic bill of materials includes the material number of the first material;
[0052] 02. Match the first material number with the material dictionary to obtain the alternative material that matches the first material number in the material dictionary;
[0053] 03. Update the alternative material matching the first material number in the material dictionary to the bill of materials corresponding to the first material number in the initial bill of materials to obtain the target electronic bill of materials.
[0054] In step 01, the initial electronic bill of materials can be understood as the electronic bill of materials that need to maintain substitute materials, and the target electronic bill of materials in step 03 can be understood as the electronic bill of materials that have already maintained substitute materials. The material dictionary includes all materials and material attributes, such as material numbers, original materials corresponding to the material numbers, substitute materials, and manufacturers of original materials and substitute materials. When it is necessary to maintain the material information corresponding to each material number, it can be maintained in the material dictionary. The initial electronic bill of materials can include the first material number of each material.
[0055] In step 02, the first material number can be matched with each material number in the material dictionary to obtain the material number in the material dictionary that matches the first material number, and then the corresponding substitute material can be obtained based on the material number, or the substitute material matching the first material number can be directly obtained. The number of substitute materials can be one or more, such as two, three, four or more.
[0056] In step 03, after obtaining the substitute material matching the first material number in the material dictionary, the substitute material can be updated to the bill of materials corresponding to the first material number. The bill of materials corresponding to the first material number can include the original material and the substitute material, etc., and then the target electronic bill of materials is obtained. In this way, when it is necessary to maintain the substitute material information in the electronic bill of materials, it is only necessary to maintain the substitute materials corresponding to each material number in the material dictionary, and the substitute materials corresponding to each material number in the electronic bill of materials can be automatically and synchronously updated, without the need to maintain the substitute materials corresponding to each material number in the drawing software, which reduces the amount of information maintenance, reduces the probability of error, and improves production efficiency.
[0057] See also Figure 2 The present application also provides a bill of materials management device 200. Figure 2 In the illustrated embodiment, the BOM management device 200 includes an acquisition module 201 , a matching module 202 , and an update module 203 .
[0058] The acquisition module 201 is used to acquire an initial electronic bill of materials and a material dictionary, where the initial electronic bill of materials includes a first material number.
[0059] The matching module 202 is used to match the first material number with the material dictionary to obtain a substitute material in the material dictionary that matches the first material number.
[0060] The updating module 203 is used to update the substitute material matching the first material number in the material dictionary to the bill of materials corresponding to the first material number in the initial bill of materials to obtain a target electronic bill of materials.
[0061] The specific contents implemented by the acquisition module 201, the matching module 202 and the updating module 203 may refer to the specific contents of the above-mentioned step 01, step 02 and step 03 respectively.
[0062] In some embodiments, see Figure 3 , Figure 3 Part a shows the contents of the initial bill of materials. Figure 3 Part b shows the contents of the material dictionary, and part c shows the contents of the target material list. Figure 3 It can be seen that the bill of materials management method and bill of materials management device of the implementation mode of the present application can automatically update the alternative materials corresponding to each first material number in the initial bill of materials in the material dictionary to the initial bill of materials by matching the initial bill of materials with the material dictionary, thereby obtaining the target bill of materials, without the need to maintain the alternative materials corresponding to each material number on the drawing software, thereby reducing the amount of information maintenance, reducing the probability of errors, and improving production efficiency.
[0063] See also Figure 4 In some embodiments, the material dictionary includes a second material number and an alternative material corresponding to the second material number. Step 02 includes the following steps 021 and 022.
[0064] 021, matching the first material number with the second material number to obtain a matching second material number that matches the first material number;
[0065] 022, obtain the substitute material corresponding to the matching second material number.
[0066] In some embodiments, the matching module 202 can also be used to implement the above-mentioned steps 021 and 022, that is, the matching module 202 can also be used to: match the first material number with the second material number to obtain a matching second material number that matches the first material number; and obtain an alternative material corresponding to the matching second material number.
[0067] In some embodiments, see Figure 3, the initial bill of materials includes material numbers, original materials and substitute materials, and the substitute material information corresponding to each material number in the initial bill of materials is empty. The material dictionary includes material numbers, original materials and substitute materials, and each material number in the material dictionary has corresponding substitute material information. Match material numbers A and C (i.e., each first material number) in the initial bill of materials with material numbers A, B, and C (i.e., second material numbers) in the material dictionary to obtain the matching second material number A that matches the first material number A, and the matching second material number C that matches the first material number C, and further obtain the substitute materials A1, A2 and A3 corresponding to the second material number A and the substitute materials C1, C2 and C3 corresponding to the second material number C in the material dictionary. In this way, the substitute material information matching the first material number in the material dictionary is accurately extracted.
[0068] See also Figure 5 In some embodiments, the material dictionary also includes the original material corresponding to the second material number, and the initial electronic bill of materials also includes the original material corresponding to the first material number. Before step 022 (obtaining the substitute material corresponding to the matching second material number), step 02 also includes:
[0069] 023, obtain the first original material corresponding to the first material number and the second original material corresponding to the second material number;
[0070] 024, comparing the first original material with the second original material;
[0071] If the first original material is consistent with the second original material, execute step 022 (obtaining a substitute material corresponding to the matching second material number).
[0072] In some embodiments, the matching module 202 can also be used to implement the above steps 023 to 024, that is, the matching module 202 can also be used to: obtain the first original material corresponding to the first material number, and the second original material corresponding to the second material number; compare the first original material with the second original material; if the first original material is consistent with the second original material, then obtain the alternative material corresponding to the matching second material number.
[0073] In some embodiments, since there may be some errors in the manual input of material numbers, this will cause the matched substitute materials to be inaccurate. Therefore, after obtaining the matching second material number that matches the first material number, the accuracy of the matching result can be further confirmed. The first original material corresponding to the first material number can be obtained from the initial electronic bill of materials, and the second original material corresponding to the matching second material number can be obtained from the material dictionary, and the first original material is compared with the second original material. If there is no error in the first material number, the first original material and the second original material are consistent, and the substitute material corresponding to the matching second material number is obtained, and the substitute material is used as the substitute material corresponding to the first material number; if there is an error in the first material number, the first original material and the second original material are inconsistent, and an error prompt can be issued, or the first original material can be further matched with the material dictionary to obtain the substitute material corresponding to the first original material, and then updated to the initial electronic bill of materials.
[0074] See also Figure 6 In some embodiments, step 02 further includes:
[0075] 026. If the first original material is inconsistent with the second original material, the substitute material corresponding to the material number of the second material is not obtained, and the first original material is matched with the material dictionary to obtain the substitute material corresponding to the first original material as the substitute material matching the material number of the first material.
[0076] In some embodiments, the matching module 202 can also be used to implement the above-mentioned step 026, that is, the matching module 202 can also be used for: if the first original material is inconsistent with the second original material, then instead of obtaining the substitute material corresponding to the material number of the second material, the first original material is matched with the material dictionary to obtain the substitute material corresponding to the first original material as the substitute material matching the material number of the first material.
[0077] If the first original material is inconsistent with the second original material, it indicates that there may be an error in the material number of the first material. If the substitute material corresponding to the matching second material number corresponding to the first material number is used as the substitute material of the first original material, it may be inaccurate. Therefore, the substitute material corresponding to the matching second material number may not be obtained. Instead, the first original material is matched with the second original material corresponding to each second material number in the material dictionary to obtain the second original material matching the first original material, and the substitute material corresponding to the second original material is further obtained in the material dictionary as the substitute material matching the first material number, and further updated to the initial electronic bill of materials.
[0078] The second material number corresponding to the second original material that matches the first original material can be further obtained, and the erroneous first material number can be displayed in a specific color in the initial electronic bill of materials and marked as the actual second material number, so as to remind the user so that the user can modify it. Alternatively, the erroneous first material number in the initial electronic bill of materials can be directly modified to the second material number, and displayed in a specific color to inform the user of the modification. Of course, in other embodiments, when the first original material is inconsistent with the second original material, an error prompt can be directly issued to inform the user to remind the user to check or modify it. Alternatively, when the first original material is inconsistent with the second original material, the first original material corresponding to the first material number can also be directly modified to the second original material, and the specific selection can be reasonable according to the actual error situation.
[0079] See also Figure 7 In some embodiments, step 02 further includes:
[0080] 027, obtain the bill of materials corresponding to each first material number in the initial electronic bill of materials, the bill of materials including the original material and the substitute material;
[0081] 028, the first material number without alternative material information is used as the first material number to be improved;
[0082] 029, match the material number of the first material to be improved with the material dictionary to obtain the alternative material in the material dictionary that matches the material number of the first material to be improved.
[0083] In some embodiments, the matching module 202 can also be used to implement the above steps 027 to 029, that is, the matching module 202 can also be used to: obtain a bill of materials corresponding to each first material number in the initial electronic bill of materials, the bill of materials including original materials and alternative materials; use the first material number without alternative material information as the first material number to be improved; match the first material number to be improved with the material dictionary to obtain the alternative material in the material dictionary that matches the first material number to be improved.
[0084] It is understandable that some first material numbers in the initial electronic bill of materials may already have substitute material information corresponding to them. In order to improve maintenance efficiency, the substitute material information corresponding to these first material numbers that already have substitute material information may not be obtained from the material dictionary. Therefore, the bill of materials corresponding to each first material number in the initial electronic bill of materials can be obtained, and the first material number without substitute materials can be further obtained. The first material number without substitute materials is used as the first material number to be improved in the initial electronic bill of materials whose substitute material information needs to be improved. The first material number to be improved is further matched with the second material number in the material dictionary to obtain the substitute material that matches the first material number to be improved in the material dictionary. Thereby, the efficiency of material maintenance is improved. Among them, the specific content of step 029 can refer to the above steps 021 to 026.
[0085] In other embodiments, in order to avoid the situation where the alternative material information corresponding to the first material number of the existing alternative material information has changed in the material dictionary, the first material number of the existing alternative material information can also be matched with the material dictionary to obtain its corresponding alternative material information, and the matched alternative material information is compared with the alternative material information in the initial electronic bill of materials to see if they are consistent. If they are consistent, the initial electronic bill of materials will not be updated. If they are inconsistent, the matched alternative material information will be updated to the initial electronic bill of materials. Alternatively, the alternative material comparison may not be performed, and the matched alternative material information can be directly updated to the initial electronic bill of materials.
[0086] See also Figure 8 In some embodiments, the attributes of the substitute material include the manufacturer of the substitute material and the model of the substitute material. Step 03 includes:
[0087] 031, update the manufacturer and model of the alternative material that matches the first material number in the material dictionary to the alternative material information corresponding to the first material number in the initial material list.
[0088] In order to facilitate users to understand the specific situation of alternative materials, so that they can directly obtain the corresponding manufacturers through the electronic material list, so that they can directly obtain information such as delivery time from the corresponding manufacturers.
[0089] See also Fig. 9 , Fig. 9 Part a shows the contents of the initial bill of materials. Fig. 9 Part b shows the contents of the material dictionary. Fig. 9Part c in the figure shows the contents of the target bill of materials. The initial bill of materials, material dictionary and target bill of materials all include material numbers, original material information (including manufacturer and model) and substitute material information (including manufacturer and model). After matching the substitute material 1 (including manufacturer a1 and model A1), substitute material 2 (including manufacturer a2 and model A2) and substitute material 3 (including manufacturer a3 and model A3) corresponding to material number A in the initial bill of materials from the material dictionary, the substitute material 1 (including manufacturer c1 and model C1), substitute material 2 (including manufacturer c2 and model C2) and substitute material 3 (including manufacturer a3 and model A3) corresponding to material number C in the initial bill of materials are matched. After material 3 (including manufacturer c3 and model C3) is replaced, alternative material 1 (including manufacturer a1 and model A1), alternative material 2 (including manufacturer a2 and model A2) and alternative material 3 (including manufacturer a3 and model A3) can be updated to the alternative material information column corresponding to material number A in the initial material list, and alternative material 1 (including manufacturer c1 and model C1), alternative material 2 (including manufacturer c2 and model C2) and alternative material 3 (including manufacturer c3 and model C3) can be updated to the alternative material information column corresponding to material number C in the initial material list, thereby obtaining the target electronic material list.
[0090] See also Fig. 9 In some embodiments, when there are multiple substitute materials in the material dictionary that match the first material number, the information of the multiple substitute materials is updated to the initial electronic bill of materials.
[0091] See also Fig.10 In some embodiments, step 03 includes:
[0092] 032, if there is no alternative material for the first material number in the initial material list, the alternative material matching the first material number in the material dictionary is updated to the material list corresponding to the first material number in the initial material list;
[0093] 033, if the first material number has an alternative material in the initial material list, compare the alternative material in the initial material list with the alternative material matching the first material number in the material dictionary;
[0094] 034. If the comparison is inconsistent, compare the first original material corresponding to the first material number in the initial material list and the second original material matching in the material dictionary. If the first original material and the second original material are consistent, replace the substitute material of the first material number in the initial material list with the substitute material matching in the material dictionary.
[0095] In some embodiments, the update module 203 is also used to implement the above steps 032 to 034. That is, the update module 203 is also used to: if there is no alternative material in the initial bill of materials for the first material number, then update the alternative material matching the first material number in the material dictionary to the bill of materials of the first material number in the initial bill of materials; if there is no alternative material in the initial bill of materials for the first material number, then update the alternative material matching the first material number in the material dictionary to the bill of materials of the first material number in the initial bill of materials; if the comparison is inconsistent, then compare the first original material corresponding to the first material number in the initial bill of materials and the second original material matching in the material dictionary, if the first original material and the second original material are consistent, then replace the alternative material of the first material number in the initial bill of materials with the alternative material matching the first material number in the material dictionary.
[0096] It is understandable that some first material numbers in the initial electronic bill of materials have corresponding alternative material information, while some first material numbers do not have corresponding alternative material information. Therefore, for first material numbers without alternative material information, the alternative material information obtained by matching from the material dictionary can be updated to the bill of materials corresponding to the first material number in the initial bill of materials; for first material numbers with alternative material information, the alternative material information is likely to change due to reasons such as material delivery date and price. Therefore, the latest alternative material information can be used as the alternative material information for the first material number in the electronic bill of materials. In order to ensure the accuracy of the alternative material information, for first material numbers with material information, after matching the alternative material that matches the first material number from the material dictionary, the alternative material of the first material number in the initial bill of materials can be compared. Check whether the substitute material matching the first material number in the material dictionary is consistent. If the comparison is consistent, there is no need to update the substitute material information corresponding to the first material number in the initial electronic material list. If the comparison is inconsistent, the first original material corresponding to the first material number in the initial material list and the second original material matching in the material dictionary can be further compared. If the first original material and the second original material are consistent, it indicates that the substitute material has indeed been updated, and the substitute material matching the first material number in the material dictionary is replaced with the substitute material. If the first original material and the second original material are inconsistent, it indicates that the first material number may be wrong, and a prompt warning can be further issued to the user to remind the user, or the substitute material corresponding to the first material number in the initial electronic material list may not be updated.
[0097] like Fig.11As shown, the embodiment of the present application further provides a computer device 1100, which can be a server, a laptop, a desktop computer, a tablet computer, a mobile phone and other devices. The computer device 1100 includes one or more processors 1110, a memory 1120, and one or more computer programs, wherein the one or more computer programs are stored in the memory 1120 and executed by one or more processors 1110, and the computer program includes instructions for executing the electronic bill of materials management method of any of the above embodiments of the present application. For example, when the processor 1110 executes the program, the processor 1110 can implement step 01, step 02, and step 03. For another example, when the processor 1110 executes the program, the processor 1110 can implement steps 021 and step 022, steps 023 to 025, and so on. That is, when the processor 1110 executes the program, the corresponding steps of the electronic bill of materials management method of any of the above embodiments can be implemented.
[0098] The memory 1120 is used to store a computer program that can be run on the processor 1110. When the processor 1110 executes the program, the electronic bill of materials management method in any of the above-mentioned embodiments is implemented.
[0099] The memory 1120 may include a high-speed RAM memory, and may also include a nonvolatile memory, such as at least one disk memory. Furthermore, the computer device 1100 may also include a communication interface 1130, which is used to implement communication between the memory 1120 and the processor 1110.
[0100] If the memory 1120, the processor 1110 and the communication interface 1130 are implemented independently, the communication interface 1130, the memory 1120 and the processor 1110 can be connected to each other through a bus and communicate with each other. The bus can be an Industry Standard Architecture (ISA) bus, a Peripheral Component (PCI) bus or an Extended Industry Standard Architecture (EISA) bus. The bus can be divided into an address bus, a data bus, a control bus, etc. For ease of representation, Fig.11 Only one thick line is used in the diagram, but this does not mean that there is only one bus or only one type of bus.
[0101] Optionally, in a specific implementation, if the memory 1120, the processor 1110 and the communication interface 1130 are integrated on a chip, the memory 1120, the processor 1110 and the communication interface 1130 can communicate with each other through an internal interface.
[0102] The processor 1110 may be a central processing unit (CPU), or an application specific integrated circuit (ASIC), or one or more integrated circuits configured to implement the embodiments of the present application.
[0103] like Fig.12 As shown, the embodiment of the present application further provides a computer-readable storage medium 1200 including a computer program 1201. When the computer program 1201 is executed by one or more processors 1110, the processor 1110 can execute the electronic bill of materials management method of any of the above embodiments. The computer program 1201 can include an electronic bill of materials management program.
[0104] For example, when the computer program 1201 is executed by a processor, please combine Figure 1 , implement the following electronic bill of materials management methods:
[0105] 01. Obtain the initial electronic bill of materials and material dictionary. The initial electronic bill of materials includes the material number of the first material;
[0106] 02. Match the first material number with the material dictionary to obtain the alternative material that matches the first material number in the material dictionary;
[0107] 03. Update the alternative material matching the first material number in the material dictionary to the bill of materials corresponding to the first material number in the initial bill of materials to obtain the target electronic bill of materials.
[0108] For another example, when the computer program 1201 is executed by the processor 1110, steps 021 and 022, steps 023, 024 and 025, step 026, steps 027, 028 and 029, step 031, steps 032 and 033, and so on can also be implemented.
[0109] In one embodiment, a computer program product is provided, including a computer program, which implements the steps in the above-mentioned electronic bill of materials management method embodiments when executed by a processor.
[0110] The electronic bill of materials management method, electronic bill of materials management device, computer equipment, computer-readable storage medium, and computer program product provided in the embodiments of the present application can automatically match the alternative material information corresponding to each material number in the electronic bill of materials with the alternative material information in the material dictionary and update it to the electronic bill of materials. Therefore, when it is necessary to maintain the alternative material information in the electronic bill of materials, it is only necessary to maintain the alternative material information corresponding to the material number in the material dictionary, and the alternative material information corresponding to the material number in the electronic bill of materials can be automatically updated. The maintenance is relatively simple, and there is no need to maintain the relevant information in the drawing software, which reduces the amount of information maintenance, reduces the probability of errors, and improves production efficiency.
[0111] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to the memory, database or other medium used in the embodiments provided in the present application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetoresistive random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM). The database involved in each embodiment provided in this application may include at least one of a relational database and a non-relational database. Non-relational databases may include distributed databases based on blockchains, etc., but are not limited to this. The processor involved in each embodiment provided in this application may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic device, a data processing logic device based on quantum computing, etc., but are not limited to this.
[0112] In the description of this specification, the description with reference to the terms "one embodiment", "some embodiments", "illustrative embodiments", "examples", "specific examples" or "some examples" etc. means that the specific features, structures, materials or characteristics described in conjunction with the embodiments or examples are included in at least one embodiment or example of the present application. In this specification, the schematic representations of the above terms do not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described may be combined in any one or more embodiments or examples in a suitable manner. In addition, those skilled in the art may combine and combine the different embodiments or examples described in this specification and the features of the different embodiments or examples, unless they are contradictory.
[0113] Any process or method description in a flowchart or otherwise described herein may be understood to represent a module, segment or portion of code that includes one or more executable instructions for implementing the steps of a specific logical function or process, and the scope of the preferred embodiments of the present application includes alternative implementations in which functions may not be performed in the order shown or discussed, including performing functions in a substantially simultaneous manner or in the reverse order depending on the functions involved, which should be understood by technicians in the technical field to which the embodiments of the present application belong.
[0114] Although the embodiments of the present application have been shown and described above, it can be understood that the above embodiments are exemplary and cannot be understood as limitations on the present application. Ordinary technicians in this field can change, modify, replace and modify the above embodiments within the scope of the present application.
Claims
1. A bill of materials management method, characterized in that: include: Acquire an initial electronic bill of materials and a material dictionary, wherein the initial electronic bill of materials includes a first material number; Matching the first material number with the material dictionary to obtain a substitute material in the material dictionary that matches the first material number; The substitute material matching the first material number in the material dictionary is updated to the bill of materials corresponding to the first material number in the initial bill of materials to obtain a target electronic bill of materials.
2. The material list management method according to claim 1, characterized in that: The material dictionary includes a second material number and a substitute material corresponding to the second material number, and matching the first material number with the material dictionary to obtain a substitute material matching the first material number in the material dictionary includes: Matching the first material number with the second material number to obtain a matching second material number that matches the first material number; Obtain a substitute material corresponding to the matching second material number.
3. The material list management method according to claim 2, characterized in that: The material dictionary also includes the original material corresponding to the second material number, the initial electronic bill of materials also includes the original material corresponding to the first material number, and before obtaining the substitute material corresponding to the matching second material number, matching the first material number with the material dictionary to obtain the substitute material matching the first material number in the material dictionary, further includes: Obtaining a first original material corresponding to the first material number and a second original material corresponding to the matching second material number; comparing the first original material with the second original material; If the first original material is consistent with the second original material, then the substitute material corresponding to the matching second material number is obtained.
4. The material list management method according to claim 3, characterized in that: The matching the first material number with the material dictionary to obtain a substitute material in the material dictionary that matches the first material number also includes: If the first original material is inconsistent with the second original material, the substitute material corresponding to the matching second material number is not obtained, and the first original material is matched with the material dictionary to obtain the substitute material corresponding to the first original material as the substitute material matching the first material number.
5. The material list management method according to claim 1, characterized in that: The step of matching the first material number with the material dictionary to obtain a substitute material in the material dictionary that matches the first material number includes: Obtain a bill of materials corresponding to each of the first material numbers in the initial electronic bill of materials, the bill of materials including original materials and substitute materials; The first material number without the alternative material information is used as the first material number to be improved; The material number of the first material to be improved is matched with the material dictionary to obtain a substitute material in the material dictionary that matches the material number of the first material to be improved.
6. The material list management method according to claim 1, characterized in that: The attributes of the substitute material include the manufacturer of the substitute material and the model of the substitute material. The step of updating the substitute material matching the first material number in the material dictionary to the bill of materials corresponding to the first material number in the initial bill of materials to obtain the target electronic bill of materials includes: The manufacturer and model of the substitute material matching the first material number in the material dictionary are updated to the substitute material information corresponding to the first material number in the initial bill of materials.
7. The material list management method according to claim 1, characterized in that: The step of updating the substitute material in the material dictionary that matches the first material number to the bill of materials corresponding to the first material number in the initial bill of materials to obtain a target electronic bill of materials includes: If there is no alternative material for the first material number in the initial bill of materials, then updating the alternative material matching the first material number in the material dictionary to the bill of materials corresponding to the first material number in the initial bill of materials; If the first material number has an alternative material in the initial material list, compare the alternative material in the initial material list with the alternative material matching the first material number in the material dictionary; If the comparison is inconsistent, compare the first original material corresponding to the first material number in the initial material list with the second original material matching the material dictionary. If the first original material and the second original material are consistent, replace the alternative material of the first material number in the initial material list with the alternative material of the first material number in the initial material list.
8. A method for managing a bill of materials, characterized in that: include: An acquisition module, used to acquire an initial electronic bill of materials and a material dictionary, wherein the initial electronic bill of materials includes a first material number; A matching module, used for matching the first material number with the material dictionary to obtain a substitute material in the material dictionary that matches the first material number; An updating module is used to update the substitute material matching the first material number in the material dictionary to the bill of materials corresponding to the first material number in the initial bill of materials to obtain a target electronic bill of materials.
9. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the bill of materials management method according to any one of claims 1 to 7 are implemented.
10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the bill of materials management method according to any one of claims 1 to 7 are implemented.