Automatic generation method and apparatus for electrophoresis reagent bill of materials (BOM) of electrophoresis spare parts

Abstract

This invention provides an automatic method for generating a Bill of Materials (BOM) for electrophoretic spare parts. The method includes: (1) generating an electrophoresis number based on the identifier of the part to be electrophoresed and the identifier of the electrophoresis workshop; (2) checking whether the electrophoresis number already exists. If it does not exist, proceed to step (3). If it exists, directly read the BOM for the electrophoresis reagent corresponding to the electrophoresis number; (3) constructing the BOM for the electrophoresis reagent corresponding to the electrophoresis number. Only the unit usage relationship between the electrophoresis workshop and the electrophoresis reagent needs to be maintained to automatically generate BOMs for different electrophoretic spare parts in different electrophoresis workshops, greatly improving the efficiency and quality of BOM release for spare parts electrophoresis.

Description

Technical Field

[0001] This invention relates to the field of electrophoretic spare parts technology, and provides a method and apparatus for automatically generating the electrophoretic reagent bill of materials (BOM) for electrophoretic spare parts. Background Technology

[0002] In the automotive industry, with the flattening of the vehicle body BOM, some challenges have been posed to after-sales spare parts, especially for the body welding assembly as a spare part. Considering factors such as corrosion prevention, the welding assembly needs to be electrophoretically coated. The amount of electrophoretic agent used will directly affect the demand for spare parts and cost accounting.

[0003] The current automotive industry has relatively mature BOM management methods for vehicle production. However, spare parts BOMs are mostly maintained offline or manually. Manual work involves creating a separate electrophoresis BOM for each electrophoretic spare part in the system. Statistics show that a single vehicle model requires approximately 100 electrophoretic spare parts, and a single workshop requires about 10 types of electrophoresis agents. To complete the electrophoresis BOM for a single vehicle model, a materials engineer would need to create 100 electrophoresis BOMs, approximately 100 * 10 = 1000 lines. Therefore, the existing spare parts BOM generation methods have the following problems:

[0004] (1) Manual construction involves a large workload and is prone to errors;

[0005] (2) Different workshops use different electrophoresis agents. The manually constructed BOM structure can only support the production of one workshop at a time. If it is moved to a different factory, the BOM structure needs to be changed again, resulting in low construction efficiency. Summary of the Invention

[0006] In view of this, this application provides a method for automatically generating the Bill of Materials (BOM) for electrophoretic spare parts, aiming to improve the above-mentioned problems.

[0007] Specifically, the following technical solutions are included:

[0008] On the one hand, embodiments of this application provide a method for automatically generating a Bill of Materials (BOM) for electrophoretic spare parts, the method comprising the following steps:

[0009] (1) Generate an electrophoresis number based on the identification of the parts to be electrophoresed and the identification of the electrophoresis workshop;

[0010] (2) Check if the electrophoresis number already exists. If it does not exist, construct the electrophoresis reagent list BOM corresponding to the electrophoresis number. If it exists, directly read the electrophoresis reagent list BOM corresponding to the electrophoresis number.

[0011] In some embodiments of the present invention, the process of generating the electrophoresis number is as follows:

[0012] Based on the established rules, an electrophoresis spare part identifier is generated according to the identifier of the component to be electrophoresed. The electrophoresis spare part identifier and the electrophoresis workshop identifier together constitute the electrophoresis number.

[0013] In some embodiments of the present invention, the electrophoresis reagent bill of materials (BOM) consists of the electrophoresis number, the name of the electrophoresis spare parts, the identifier of the parts to be electrophoresed, the electrophoresis workshop, the name of the electrophoresis reagent, and the amount used.

[0014] In some embodiments of the present invention, the method for automatically generating the swimming reagent bill of materials (BOM) is as follows:

[0015] (31) Input the surface area of ​​the parts to be electrophoresed;

[0016] (32) Read the electrophoretic agent required by the corresponding electrophoretic spare parts of the parts to be electrophoresed in the electrophoresis workshop and the corresponding unit area usage, and automatically calculate the electrophoretic agent and usage required by the electrophoretic spare parts.

[0017] (33) Generate the electrophoresis reagent list (BOM) corresponding to the electrophoresis number based on the required electrophoresis reagent and dosage for the electrophoresis spare parts.

[0018] In some embodiments of the present invention, the method further includes the following step before step (32):

[0019] (34) Construct a mapping relationship between the electrophoresis workshop and the electrophoresis reagents required for the parts, including: the mapping relationship between the electrophoresis workshop and the name of the electrophoresis reagent, and the unit dosage of the corresponding electrophoresis reagent.

[0020] In some embodiments of the present invention, there is a many-to-many mapping relationship between the electrophoresis workshop and the electrophoresis components.

[0021] In some embodiments of the present invention, the method further includes updating the electrophoresis reagent bill of materials (BOM), and the updating method is as follows:

[0022] (41) Determine the electrophoresis number corresponding to the BOM of the electrophoresis reagents to be updated;

[0023] (42) Enter at least one of the following: the updated surface area of ​​the electrophoresis spare parts, the type of electrophoresis agent in the electrophoresis workshop, and the amount of electrophoresis agent used per unit area.

[0024] (42) Automatically update the electrophoresis reagents and quantities required for electrophoresis spare parts in the electrophoresis reagent list BOM.

[0025] On the other hand, embodiments of this application provide an automatic BOM (Bill of Materials) generation device for electrophoresis spare parts. The device includes: an electrophoresis number generation unit, a query unit, a reading unit, an electrophoresis reagent list generation unit, and a first storage unit.

[0026] The electrophoresis number generation unit is used to receive the input parts to be electrophoresed and the electrophoresis workshop, and generate an electrophoresis number;

[0027] The query unit is used to search in the first storage unit to see if the electrophoresis number generated by the electrophoresis number generation unit already exists. If it exists, the reading unit directly reads the electrophoresis reagent list BOM corresponding to the electrophoresis number from the first storage unit. If it does not exist, the electrophoresis reagent list generation unit generates the electrophoresis reagent list BOM of the electrophoresis number generated by the electrophoresis number generation unit and stores it in the first storage unit.

[0028] The first storage unit is used to store the Bill of Materials (BOM) for each electrophoresis number.

[0029] In some embodiments of the present invention, the electrophoresis reagent list generation unit includes: an electrophoresis reagent dosage calculation module, an electrophoresis reagent list BOM generation module, and a second storage unit;

[0030] The electrophoresis agent dosage calculation module is used to receive the surface area of ​​the parts to be electrophoresed, read the electrophoresis agent required for the corresponding electrophoresis spare parts in the electrophoresis workshop and its corresponding unit area dosage from the second storage unit, and calculate the electrophoresis agent and dosage required for the electrophoresis spare parts.

[0031] The electrophoresis reagent bill of materials (BOM) generation module generates the BOM corresponding to the electrophoresis reagent number based on the amount of electrophoresis reagent calculated by the electrophoresis reagent dosage calculation module.

[0032] The second storage unit is used to store a mapping table between the constructed electrophoresis workshop and the electrophoresis reagents required for the electrophoresis spare parts.

[0033] In some embodiments of the present invention, the apparatus further includes: an updating unit;

[0034] It is used to receive at least one of the following: the electrophoresis number corresponding to the electrophoresis reagent list BOM to be updated, the updated surface area of ​​the electrophoresis spare parts, the electrophoresis reagent type of the electrophoresis workshop, and the unit area usage of the electrophoresis reagent, and automatically update the electrophoresis reagent and usage required for the electrophoresis spare parts in the electrophoresis reagent list BOM in the first storage unit.

[0035] The automatic BOM generation method for electrophoresis reagents for electrophoresis spare parts provided by this invention has the following beneficial technical effects:

[0036] (1) Only the unit usage relationship between the electrophoresis workshop and the electrophoresis agent needs to be maintained, and the electrophoresis agent list BOM of different electrophoresis spare parts in different electrophoresis workshops will be automatically generated, which greatly improves the efficiency and quality of the electrophoresis agent list BOM release for spare parts electrophoresis.

[0037] (2) While updating the surface area of ​​the parts, the type of electrophoretic agent or the unit amount of electrophoretic agent, the corresponding electrophoretic agent bill of materials (BOM) can be updated almost simultaneously. Attached Figure Description

[0038] To more clearly illustrate the technical solutions in the embodiments of this application, the accompanying drawings used in the description of the embodiments will be briefly introduced below. Obviously, the accompanying drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0039] Figure 1 A flowchart illustrating the automatic generation method of the electrophoresis reagent bill of materials (BOM) for electrophoresis spare parts provided in this embodiment of the invention;

[0040] Figure 2 This is a schematic diagram of the automatic BOM generation device for electrophoresis reagents of electrophoresis spare parts provided in an embodiment of the present invention;

[0041] The accompanying drawings have illustrated specific embodiments of this application, which will be described in more detail below. These drawings and descriptions are not intended to limit the scope of the concept in any way, but rather to illustrate the concept of this application to those skilled in the art through reference to specific embodiments. Detailed Implementation

[0042] The technical solutions of the embodiments of this application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of this application, not all embodiments. Based on the embodiments of this application, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of this application.

[0043] Unless otherwise defined, all technical terms used in the embodiments of this application have the same meaning as commonly understood by one of ordinary skill in the art.

[0044] Figure 1 A flowchart of the automatic generation method for the electrophoresis reagent bill of materials (BOM) of electrophoresis spare parts provided in this embodiment of the invention is shown below:

[0045] (1) Generate an electrophoresis number based on the identification of the parts to be electrophoresed and the identification of the electrophoresis workshop;

[0046] In this embodiment of the invention, the process of generating the electrophoresis number is as follows: based on the identification of the component to be electrophoresed according to the set rules, an electrophoresis spare part identification is formed, and the electrophoresis spare part identification and the electrophoresis workshop identification constitute the electrophoresis number.

[0047] (2) Check if the electrophoresis number already exists. If it does not exist, proceed to step (3). If it exists, directly read the electrophoresis reagent list BOM corresponding to the electrophoresis number.

[0048] (3) Construct the Bill of Materials (BOM) for the electrophoresis reagents corresponding to the electrophoresis number.

[0049] In this invention, the parts to be electrophoresed can be welded assemblies made up of multiple parts, or single parts. If it is a welded assembly, the electrophoresis operation is performed after the welding is completed. The electrophoresis agent bill of materials (BOM) consists of the electrophoresis number, the name of the electrophoresis spare parts, the identification of the parts to be electrophoresed, the electrophoresis workshop, the name and amount of the electrophoresis agent.

[0050] In this embodiment of the invention, the method for automatically generating the electrophoresis reagent bill of materials (BOM) is as follows:

[0051] (31) Input the surface area of ​​the parts to be electrophoresed;

[0052] (32) Read the electrophoretic agent required by the corresponding electrophoretic spare parts of the parts to be electrophoresed in the electrophoresis workshop and the corresponding unit area usage, and automatically calculate the electrophoretic agent and usage required by the electrophoretic spare parts.

[0053] (33) Generate the electrophoresis reagent list (BOM) corresponding to the electrophoresis number based on the required electrophoresis reagent and dosage for the electrophoresis spare parts.

[0054] In this embodiment of the invention, before reading the electrophoresis reagent required for the parts to be electrophoresed in the electrophoresis workshop and its corresponding unit area usage, the following steps need to be performed:

[0055] (34) Construct a mapping relationship between the electrophoresis workshop and the electrophoresis reagents required for the parts, including: the mapping relationship between the electrophoresis workshop and the name of the electrophoresis reagent, and the unit dosage of the corresponding electrophoresis reagent;

[0056] In this embodiment of the invention, there is a many-to-many mapping relationship between the electrophoresis workshop and the electrophoresis components, that is, one electrophoresis workshop can complete the electrophoresis operation of multiple components, and the electrophoresis of one component can be completed in multiple electrophoresis workshops.

[0057] In this embodiment of the invention, the amount of electrophoretic agent required for the component to be electrophoresed is: the surface area of ​​the electrophoretic spare part * the amount of electrophoretic agent per unit area required in the electrophoresis workshop, wherein the surface area of ​​the electrophoretic spare part is the same as the surface area of ​​the component to be electrophoresed.

[0058] During vehicle development, the dimensions or formation of components may change, leading to changes in the surface area of ​​the components to be electrophoretically coated, or changes in the electrophoresis reagents used in the electrophoresis workshop, including changes in the amount used per unit area or the type of electrophoresis reagent. In this case, the Bill of Materials (BOM) for the corresponding electrophoresis reagent needs to be updated. The specific update method is as follows:

[0059] (41) Determine the electrophoresis number corresponding to the BOM of the electrophoresis reagents to be updated;

[0060] (42) Enter at least one of the following: the updated surface area of ​​the electrophoresis spare parts, the type of electrophoresis agent in the electrophoresis workshop, and the amount of electrophoresis agent used per unit area.

[0061] (42) Automatically update the electrophoresis reagents and quantities required for electrophoresis spare parts in the electrophoresis reagent list BOM.

[0062] In this embodiment of the invention, if the identification of the component to be electrophoresed and / or the electrophoresis workshop is updated, a new electrophoresis number will be generated. At this time, it is necessary to construct a bill of materials (BOM) for the electrophoresis reagents with the new electrophoresis number. The update function of the bill of materials (BOM) for the electrophoresis reagents cannot complete the update of the identification of the component to be electrophoresed and / or the electrophoresis workshop.

[0063] This invention illustrates the automatic generation process of the electrophoresis reagent bill of materials (BOM) for electrophoretic spare parts using the following example:

[0064] 1) Define the "surface area" of the parts to be electrophoretically coated: This is a non-mandatory attribute when applying for the part number. It is first entered when the part maturity reaches ESO approval, and the surface area is assigned a value simultaneously. The system development interface supports batch export of the "surface area" attribute of the part master data, batch import after assignment, and subsequent updates of the surface area are maintained synchronously with the design changes of the parts.

[0065]

[0066] Table 1. Master Data Attributes of Components to be Electrophoresed

[0067] 2) Define the mapping relationship between the identifiers of the parts to be electrophoretically coated and the identifiers of the spare parts: The coding rule for the identifiers of the electrophoretic parts can be defined as adding a special identifier to the identifier of the parts to be electrophoretically coated, such as "DYJ". If the identifier of the parts to be electrophoretically coated is A001, then the corresponding identifier of the spare parts is A001DYJ. Similarly, the name of the spare parts is the name of the parts to be electrophoretically coated with "-electrophoresis", as shown in Example 2:

[0068] Component Identification Electrophoresis spare parts markings Electrophoresis spare parts name A001 A001DYJ Sunroof roof assembly - Electrophoresis A001 A002DYJ Side panel welding assembly - electrophoresis

[0069] Table 2 Mapping Relationship between Identification Markings of Parts to be Electrophoresed and Identification Markings of Spare Parts for Electrophoresis

[0070] 3) Define the mapping relationship between the electrophoresis workshop and the electrophoresis reagent of the electrophoresis spare parts: First, the electrophoresis workshop is coded and identified, for example, the spare parts workshop is coded as GC01, and the Super Plant 1 is coded as GC02, etc. The mapping relationship between the electrophoresis workshop and the electrophoresis spare parts is many-to-many. The following is an example of the mapping relationship between the electrophoresis workshop and the electrophoresis reagent of a certain electrophoresis spare part, as shown in Table 3:

[0071]

[0072] Table 3. Mapping relationship between electrophoresis workshop and electrophoresis spare parts electrophoresis reagents

[0073] 4) Generate electrophoresis master data, including: electrophoresis number, electrophoresis spare part name and attribute data;

[0074] Electrophoresis number generation rules: Electrophoresis number = Electrophoresis spare part + "Electrophoresis workshop identifier", Electrophoresis spare part name = Name of the part to be electrophoresed + "Special identifier", such as "DYJ"; Electrophoresis master data attributes: Inherit the master data of the part to be electrophoresed.

[0075] When there is a production demand for electrophoresis spare parts, input the following instructions: the identifier of the part to be electrophoresed (if it is a side panel welding assembly, the part identifier is A001) and the electrophoresis workshop GC01; firstly, generate the electrophoresis number A001DYJGC01, and check if the electrophoresis number A001DYJGC01 exists; if it does not exist, then generate a new electrophoresis number A001DYJGC01, the name of the electrophoresis spare part, and the electrophoresis master data attributes.

[0076] 5) Obtain the surface area value X corresponding to the master data attribute of the part to be electrophoretically coated, and read the unit amount of electrophoretic agent in Table 3. Then, the total amount of electrophoretic agent used = X * unit area usage. The results are shown in Table 4 below:

[0077]

[0078] Table 4. Electrophoresis Reagent Usage Table in the Electrophoresis Workshop

[0079] 6) The electrophoresis master data serves as the parent component of the electrophoresis reagent BOM structure, the master data of the parts to be electrophoresed serves as the child component, and the usage is 1; the master data of the electrophoresis reagent used in the electrophoresis workshop serves as the child component, and the usage is the actual usage of the electrophoresis reagent in Table 4. This generates the electrophoresis reagent BOM corresponding to the electrophoresis number, as shown in Table 5 below.

[0080]

[0081] Table 5. List of Electrophoresis Reagents (BOM) for Electrophoresis No. A001DYJGC01

[0082] Figure 2 This is a schematic diagram of the automatic BOM (Bill of Materials) generation device for electrophoretic spare parts provided in an embodiment of the present invention. For ease of explanation, only the parts relevant to the embodiment of the present invention are shown. The device includes:

[0083] Electrophoresis number generation unit, query unit, reading unit, electrophoresis reagent list generation unit, and first storage unit;

[0084] The electrophoresis number generation unit is used to receive the input parts to be electrophoresed and the electrophoresis workshop, and generate an electrophoresis number;

[0085] The query unit is used to check whether the electrophoresis number generated by the electrophoresis number generation unit already exists in the first storage unit. If it exists, the reading unit directly reads the electrophoresis reagent list BOM corresponding to the electrophoresis number from the first storage unit. If it does not exist, the electrophoresis reagent list generation unit generates the electrophoresis reagent list BOM of the electrophoresis number generated by the electrophoresis number generation unit and stores it in the first storage unit. The first storage unit is used to store the electrophoresis reagent list BOM corresponding to each electrophoresis number. The electrophoresis reagent list BOM consists of the electrophoresis number, the name of the electrophoresis spare part, the identifier of the part to be electrophoresed, the electrophoresis workshop, the name and quantity of the electrophoresis reagent.

[0086] In this embodiment of the invention, the electrophoresis reagent list generation unit includes: an electrophoresis reagent dosage calculation module, an electrophoresis reagent list BOM generation module, and a second storage unit, wherein...

[0087] The electrophoresis agent dosage calculation module is used to receive the surface area of ​​the parts to be electrophoresed, read the electrophoresis agent required for the electrophoresis spare parts in the electrophoresis workshop and the corresponding dosage per unit area from the second storage unit, and calculate the electrophoresis agent and dosage required for the electrophoresis spare parts.

[0088] The electrophoresis reagent bill of materials (BOM) generation module generates the BOM corresponding to the electrophoresis reagent number based on the amount of electrophoresis reagent calculated by the electrophoresis reagent dosage calculation module.

[0089] The second storage unit is used to store a mapping table between the constructed electrophoresis workshop and the electrophoresis reagents required for the electrophoresis spare parts. This table includes a mapping relationship between the electrophoresis workshop and the name of the electrophoresis reagent, and the unit dosage of the corresponding electrophoresis reagent. The mapping relationship between the electrophoresis workshop and the electrophoresis parts is many-to-many, meaning that one electrophoresis workshop can complete the electrophoresis operation of multiple parts, and the electrophoresis of one part can be completed in multiple electrophoresis workshops.

[0090] The amount of electrophoretic agent required for the parts to be electrophoresed is: surface area of ​​the electrophoretic spare part * the amount of electrophoretic agent per unit area required in the electrophoresis workshop, where the surface area of ​​the electrophoretic spare part is the same as the surface area of ​​the parts to be electrophoresed.

[0091] During vehicle development, the dimensions or formation of components may change, leading to changes in the surface area of ​​the components to be electrophoretically coated, or changes in the electrophoretic solvent used in the electrophoresis workshop, including changes in the amount used per unit area or the type of electrophoretic solvent. In such cases, a more detailed Bill of Materials (BOM) for the corresponding electrophoresis number is required. This device also includes an update unit.

[0092] It is used to receive at least one of the following: the electrophoresis number corresponding to the electrophoresis reagent list BOM to be updated, the updated surface area of ​​the electrophoresis spare parts, the electrophoresis reagent type of the electrophoresis workshop, and the unit area usage of the electrophoresis reagent, and automatically update the electrophoresis reagent and usage required for the electrophoresis spare parts in the electrophoresis reagent list BOM in the first storage unit.

[0093] Other embodiments of this application will readily occur to those skilled in the art upon consideration of the specification and practice of the application disclosed herein. This application is intended to cover any variations, uses, or adaptations of this application that follow the general principles of this application and include common knowledge or customary techniques in the art not disclosed herein. The specification and examples are to be considered exemplary only.

[0094] It should be understood that this application is not limited to the precise structure described above and shown in the accompanying drawings, and various modifications and changes can be made without departing from its scope. The scope of this application is limited only by the appended claims.

Claims

1. A method for automatically generating a Bill of Materials (BOM) for electrophoretic spare parts, characterized in that, The method includes the following steps: (1) Generate an electrophoresis number based on the identification of the parts to be electrophoresed and the identification of the electrophoresis workshop; (2) Check if the electrophoresis number already exists. If it does not exist, construct the electrophoresis reagent list BOM corresponding to the electrophoresis number. If it exists, directly read the electrophoresis reagent list BOM corresponding to the electrophoresis number. The electrophoresis reagent bill of materials (BOM) consists of the electrophoresis number, the name of the electrophoresis spare parts, the identification of the parts to be electrophoresed, the electrophoresis workshop, the name and quantity of the electrophoresis reagent; The method for automatically generating the electrophoresis reagent bill of materials (BOM) is as follows: (31) Input the surface area of ​​the parts to be electrophoresed; (32) Read the electrophoretic agent required by the corresponding electrophoretic spare parts of the parts to be electrophoresed in the electrophoresis workshop and the corresponding unit area usage, and automatically calculate the electrophoretic agent and usage required by the spare parts; (33) Generate the electrophoresis reagent list (BOM) corresponding to the electrophoresis number based on the required electrophoresis reagent and dosage for the electrophoresis spare parts; The steps preceding step (32) also include: (34) Construct a mapping relationship between the electrophoresis workshop and the electrophoresis reagents required for the parts, including: the mapping relationship between the electrophoresis workshop and the name of the electrophoresis reagent, and the unit dosage of the corresponding electrophoresis reagent; There is a many-to-many mapping relationship between the electrophoresis workshop and the electrophoresis components.

2. The method for automatically generating the electrophoretic reagent bill of materials (BOM) for electrophoretic spare parts as described in claim 1, characterized in that, The process of generating the electrophoresis number is as follows: Based on the established rules, an electrophoresis spare part identifier is generated according to the identifier of the component to be electrophoresed. The electrophoresis spare part identifier and the electrophoresis workshop identifier together constitute the electrophoresis number.

3. The method for automatically generating the electrophoretic reagent bill of materials (BOM) for electrophoretic spare parts as described in claim 1, characterized in that, The method also includes updating the electrophoresis reagent bill of materials (BOM), and the specific updating method is as follows: (41) Determine the electrophoresis reagent number corresponding to the BOM to be updated; (42) Input at least one of the following: the updated surface area of ​​the electrophoretic spare parts, the type of electrophoretic agent in the electrophoresis workshop, and the amount of electrophoretic agent used per unit area; (43) Automatically update the electrophoresis reagents and quantities required for electrophoresis spare parts in the electrophoresis reagent list BOM.

4. An apparatus for automatically generating a Bill of Materials (BOM) for electrophoretic spare parts based on the method for automatically generating a BOM for electrophoretic spare parts according to any one of claims 1 to 3, characterized in that, The device includes: an electrophoresis number generation unit, a query unit, a reading unit, an electrophoresis reagent list generation unit, and a first storage unit, wherein... The electrophoresis number generation unit is used to receive the input parts to be electrophoresed and the electrophoresis workshop, and generate an electrophoresis number; The query unit is used to search in the first storage unit to see if the electrophoresis number generated by the electrophoresis number generation unit already exists. If it exists, the reading unit directly reads the electrophoresis reagent list BOM corresponding to the electrophoresis number from the first storage unit. If it does not exist, the electrophoresis reagent list generation unit generates the electrophoresis reagent list BOM of the electrophoresis number generated by the electrophoresis number generation unit and stores it in the first storage unit. The first storage unit is used to store the Bill of Materials (BOM) for each electrophoresis number.

5. The automatic BOM generation device for electrophoresis reagents of electrophoresis spare parts as described in claim 4, characterized in that, The electrophoresis reagent list generation unit includes: an electrophoresis reagent dosage calculation module, an electrophoresis reagent list BOM generation module, and a second storage unit; The electrophoresis agent dosage calculation module is used to receive the surface area of ​​the parts to be electrophoresed, read the electrophoresis agent required for the corresponding electrophoresis spare parts in the electrophoresis workshop and its corresponding unit area dosage from the second storage unit, and calculate the electrophoresis agent and dosage required for the electrophoresis spare parts. The electrophoresis reagent bill of materials (BOM) generation module generates the BOM corresponding to the electrophoresis reagent number based on the amount of electrophoresis reagent calculated by the electrophoresis reagent dosage calculation module. The second storage unit is used to store a mapping table between the constructed electrophoresis workshop and the electrophoresis reagents required for the electrophoresis spare parts.

6. The automatic BOM generation device for electrophoretic reagents of electrophoretic spare parts as described in claim 4, characterized in that, The device further includes: an update unit; It is used to receive at least one of the following: the electrophoresis number corresponding to the electrophoresis reagent list BOM to be updated, the updated surface area of ​​the electrophoresis spare parts, the electrophoresis reagent type of the electrophoresis workshop, and the unit area usage of the electrophoresis reagent, and automatically update the electrophoresis reagent and usage required for the electrophoresis spare parts in the electrophoresis reagent list BOM in the first storage unit.

Images