A structure processing method and system based on a PDM system traction inverter BOM

Abstract

The application discloses a kind of based on PDM system traction inverter BOM's structure processing method and system, comprising: PDM data module, for generating the primary process BOM file of traction inverter;Database module is used to store the data associated with primary process BOM file;Easy language processing module includes: hierarchical allocation processing unit, quantity data processing unit, similar item data processing unit and database data processing unit;Four processing units can be rearranged and integrated to the data generated by the above two modules;Process quota module is used to convert the primary process BOM file after four processing into the process quota BOM file of traction inverter.The four processing units in easy language processing module are used to rearrange and integrate the information of primary process BOM file, so that the output traction inverter process quota BOM file has higher integrity and flexibility.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of BOM bill of material processing, and particularly relates to a structure processing method and system for BOM of traction inverter based on a PDM system. BACKGROUND

[0002] A bill of material (BoM) is a computer-readable data format describing the material list of a product, and is usually in the form of a detailed table, a drawing catalog, etc. For a computer production management enterprise, the computer must first be able to read the product structure and all materials involved in the manufacturing of the enterprise. In order to facilitate computer recognition, the product structure expressed by a diagram must be converted into a certain data format. This file describing the product structure in the form of data is a bill of material, that is, BOM, which is a technical file defining the product structure, and is therefore also called a product structure table or a product structure tree.

[0003] In the technical field of traction inverters, the BOM of a product is particularly important, which needs to clearly express the organizational relationship between components and components / equipment to assist the production line in performing accurate and complete production operations. However, the existing BOM lists are manually processed or automatically processed by a system, and only simply list all sub-components of the traction converter. The number and belonging composition of each sub-component cannot be organically combined, the expression method is not conducive to the execution of process quota, and the derived results are single and have a high risk of errors. SUMMARY

[0004] The present application provides a structure processing method and system for BOM of traction inverter based on a PDM system, to overcome the problem that the existing BOM processing method for traction inverter cannot flexibly combine the process material requirements, resulting in a lack of overall and flexibility of BOM results.

[0005] In order to achieve the above-mentioned purpose, the technical scheme of the present application is:

[0006] A structure processing system for BOM of traction inverter based on a PDM system, comprising:

[0007] A PDM data module for generating a primary process BOM file of the traction inverter, the data types contained in the primary process BOM file including: hierarchy, material code, drawing number, name, model specification, material, quantity, and total weight;

[0008] A database module for storing associated material data and associated process data associated with the primary process BOM file;

[0009] An Easy language processing module, an input end of the Easy language processing module is connected with output ends of the PDM data module and the database module, the Easy language processing module comprises: a hierarchical allocation processing unit, a quantity data processing unit, a same kind item data processing unit and a database data processing unit; wherein the hierarchical allocation processing unit is used for extracting hierarchical data and name data in the primary process BOM file, and classifying into a product body, an intermediate hierarchical component and a minimum hierarchical material; the quantity data processing unit is used for summing up quantity data of the intermediate hierarchical component and the minimum hierarchical material in the same kind item; the same kind item data processing unit is used for extracting material coding, drawing number, model specification, material and total weight data in the primary process BOM file, and performing data matching with the intermediate hierarchical component and the minimum hierarchical material according to names; the database data processing unit is used for extracting associated process data and associated auxiliary material data, and performing data matching with the intermediate hierarchical component and the minimum hierarchical material according to names;

[0010] A process quota module, an input end of the process quota module is connected with an output end of the Easy language processing module, used for creating a table with the material coding, the drawing number, the model specification, the material, the quantity, the total weight, the intermediate hierarchical component, the associated auxiliary material data and the associated process data as row table headers, and filling corresponding data and the minimum hierarchical material name into the table, to generate a process quota BOM file of the traction inverter.

[0011] Further, the intermediate hierarchical component comprises: a traction power module component, a traction front end input module component, a fan control component, a heavy load connector component and a traction control cabinet.

[0012] Further, the associated process data comprises a fan control job instruction and a heavy load connector job instruction.

[0013] A structure processing method of a traction inverter BOM based on a PDM system, comprising the following steps:

[0014] S1, generating a primary process BOM file of the traction inverter according to product process requirements;

[0015] S2, calling corresponding associated material data and associated process data from a database module according to the primary process BOM file;

[0016] S3, a hierarchical allocation processing unit in an Easy language processing module extracts and classifies hierarchical data and name data in the primary process BOM file into a product body, an intermediate hierarchical component and a minimum hierarchical material;

[0017] S4, a quantity data processing unit in the Easy language processing module sums up quantity data of the intermediate hierarchical component and the minimum hierarchical material in the same kind item;

[0018] S5, the same item data processing unit in the easy language processing module extracts the material code, drawing number, model specification, material and total weight data in the primary process BOM file, and the database data processing unit extracts the associated process data and associated auxiliary material data;

[0019] S6, the process quota module creates a table with the material code, drawing number, model specification, material, quantity, total weight, intermediate level assembly, associated auxiliary material data and associated process data as the row table header, and fills the corresponding data and minimum level material name into the table, to generate the process quota BOM file of the traction inverter.

[0020] Further, the intermediate level assembly includes: traction power module components, traction front end input module components, fan control components, heavy load connector components and traction control cabinets.

[0021] Further, the associated process data includes fan control operation instruction and heavy load connector operation instruction.

[0022] Beneficial effects: the four processing units in the easy language processing module rearrange and integrate the information of the primary process BOM file, so that the output traction inverter process quota BOM file has higher integrity and flexibility. BRIEF DESCRIPTION OF DRAWINGS

[0023] In order to more clearly illustrate the technical solutions in the embodiments of the present application or the prior art, the following will briefly introduce the drawings needed to be used in the embodiments or prior art description. Obviously, the drawings described below are some embodiments of the present application, and those skilled in the art can obtain other drawings according to these drawings without creative labor.

[0024] Figure 1 The structure diagram of the traction inverter BOM processing system of the present application;

[0025] Figure 2 The flow chart of the traction inverter BOM processing method of the present application. DETAILED DESCRIPTION

[0026] In order to make the purpose, technical scheme and advantages of the embodiments of the present application more clear, the technical scheme in the embodiments of the present application will be described clearly and completely below in combination with the drawings in the embodiments of the present application. Obviously, the described embodiments are some embodiments of the present application, not all embodiments. Based on the embodiments in the present application, all other embodiments obtained by those skilled in the art without creative labor are within the scope of protection of the present application.

[0027] Embodiment 1

[0028] The embodiment provides a structure processing system based on a PDM system traction inverter BOM, comprising:

[0029] a PDM data module, configured to generate a primary process BOM file of the traction inverter, wherein data types contained in the primary process BOM file include a level, a material code, a drawing number, a name, a model specification, a material, a quantity and a total weight;

[0030] a database module, configured to store associated material data and associated process data associated with the primary process BOM file;

[0031] a simple language processing module, an input end of the simple language processing module being connected with output ends of the PDM data module and the database module, the simple language processing module comprising a level allocation processing unit, a quantity data processing unit, a same-item data processing unit and a database data processing unit; wherein the level allocation processing unit is configured to extract level data and name data in the primary process BOM file, and divide the level data and the name data into a product body, an intermediate level assembly and a minimum level material; the quantity data processing unit is configured to add up quantity data of the intermediate level assembly and the minimum level material in the same item; the same-item data processing unit is configured to extract material code data, drawing number data, model specification data, material data and total weight data in the primary process BOM file, and perform data matching on the intermediate level assembly and the minimum level material according to the name; and the database data processing unit is configured to extract associated process data and associated auxiliary material data, and perform data matching on the intermediate level assembly and the minimum level material according to the name;

[0032] a process quota module, an input end of the process quota module being connected with an output end of the simple language processing module, configured to create a table by taking the material code, the drawing number, the model specification, the material, the quantity, the total weight, the intermediate level assembly, the associated auxiliary material data and the associated process data as a row table header, and fill corresponding data and the minimum level material name into the table, so as to generate a process quota BOM file of the traction inverter.

[0033] The intermediate level assembly comprises a traction power module component, a traction front-end input module component, a fan control assembly, a heavy load connector assembly and a traction control cabinet; and the associated process data comprises a fan control job instruction and a heavy load connector job instruction.

[0034] Specifically, as Figure 1As shown, the PDM data module generates a primary process BOM file according to product process requirements, wherein the data types contained in the primary process BOM file include: hierarchy, material code, drawing number, name, model specification, material, quantity, and total weight; meanwhile, the database module retrieves all associated process work instruction data and all associated process auxiliary material data related to the product process requirements, wherein the data types contained in the associated process work instruction data and the associated process auxiliary material data include: material code, name, model specification, unit, associated material, and associated process; the data types contained in the process quota BOM file include: material code, drawing number, name, model specification, material, total quantity, total weight, and hierarchical component relationship, which is the component quantity relationship between the minimum level and the upper intermediate level of the minimum level. The three files / data are simultaneously input into the Easy Language processing module, which contains four units, namely: hierarchy allocation processing unit, quantity data processing unit, same item data processing unit, and database data processing unit. The four units perform rearrangement and integration processing on the above-mentioned three files / data, and finally convert the original primary process BOM file into a process quota BOM file of the traction inverter and output it. For specific rearrangement and integration processing methods and processes, see Example 2.

[0035] Example 2

[0036] The embodiment provides a structure processing method of a traction inverter BOM based on a PDM system, comprising the following steps:

[0037] S1, generating a primary process BOM file of the traction inverter according to product process requirements;

[0038] S2, retrieving corresponding associated material data and associated process data from the database module according to the primary process BOM file;

[0039] S3, the hierarchy allocation processing unit in the Easy Language processing module extracts and classifies the hierarchy data and name data in the primary process BOM file into product ontology, intermediate level assembly, and minimum level material;

[0040] S4, the quantity data processing unit in the Easy Language processing module performs same item addition on the quantity data of the intermediate level assembly and the minimum level material;

[0041] S5, the same item data processing unit in the Easy Language processing module extracts the material code, drawing number, model specification, material, and total weight data in the primary process BOM file, and the database data processing unit extracts the associated process data and associated auxiliary material data;

[0042] S6, the process quota module creates a table with the material code, drawing number, model specification, material, quantity, total weight, intermediate level assembly, associated auxiliary material data and associated process data as the row table header, and fills the corresponding data and minimum level material name into the table to generate a process quota BOM file of the traction inverter.

[0043] Specifically, in this embodiment, taking the traction converter of a certain urban rail transit line N as an example, the PDM material detail table thereof is shown in Table 1, that is, the primary process BOM file generated by the PDM data module in the system of the application, which includes data types such as level, material code, drawing number, name, model specification, material, quantity and total weight; the associated process operation instruction book data and the associated process auxiliary material data corresponding to the primary process BOM file in the database module are shown in Table 2, which includes data types such as material code, name, model specification, unit, associated material and associated process; the tables 1 and 2 are input into the easy language processing module, and the four processing units in the easy language processing module process the data in the above tables 1 and 2 in four steps to form the process quota BOM file shown in Table 3, and the specific process is as follows:

[0044] First, the level allocation processing unit identifies the organizational relationship between the devices and components at each level in the primary process BOM file, that is, the traction converter corresponding to level 0 is the product itself, the traction power module group, the traction front-end input module group, the fan control assembly, the heavy load connector and the traction control case corresponding to level 1 are intermediate level assemblies, and various materials corresponding to level 2 are minimum level materials or single components; the minimum level materials corresponding to level 2 are integrated and the duplicates are deleted as a column of the newly generated process quota BOM file, and the intermediate level assemblies corresponding to level 1 are integrated and inserted into the row item of the newly generated process quota BOM file;

[0045] Then, the quantity data processing unit integrates the quantities of the devices and components at each level in the primary process BOM file, that is, the total quantity of the minimum level materials and the quota quantity of the corresponding intermediate level assemblies are filled in, such as the total quantity of the material D in Table 3 is 8, and the quantity of the material D used by the traction power module group in the intermediate level assembly is 3, and the quantity of the material D used by the heavy load connector is 5;

[0046] Then the same item data processing unit is used to merge the same items in the primary process BOM file, as shown in Tables 1 and 3, the same items include material code / drawing number, model specification, material and total weight, and the same items are merged and inserted into the row item of the process quota BOM file;

[0047] Finally, the database data processing unit is used to integrate the associated process operation instruction data and the associated process auxiliary material data in the database module with corresponding equipment and components, and to insert the associated process auxiliary material data and the associated process operation instruction data into the line item of the process quota BOM file according to the associated auxiliary material information of the minimum level material;

[0048] Finally, the process quota BOM file shown in Table 3 is obtained, which can completely present the logic and quantity relationship between materials at different levels, and embody the relevant process operation instruction and process auxiliary material, and can be directly used by field workers. The innovative presentation method realizes that the component overall BOM and the sub-component BOM, the quantity relationship of the parts are clear at a glance, the relationship between the BOM and the process flow is established, the BOM output is modularized, the reliability and practicability of the process quota are greatly improved, and high-quality help can be provided for the BOM output of the same type of product.

[0049]

[0050] Table 1

[0051]

[0052]

[0053] Table 2

[0054]

[0055]

[0056] Table 3

[0057] Finally, it should be noted that: the above embodiments are only used to illustrate the technical solutions of the present application, and not to limit them; although the present application has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that they can still modify the technical solutions recorded in the foregoing embodiments, or make equivalent replacement for part or all of the technical features; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the scope of the technical solutions of the embodiments of the present application.

Claims

1. A structure processing system based on PDM system traction inverter BOM, characterized in that, The application relates to a traction inverter BOM file generation system, which comprises the following parts: a PDM data module for generating a primary process BOM file of a traction inverter, wherein the data types contained in the primary process BOM file include hierarchy, material code, drawing number, name, model specification, material, quantity and total weight; a database module for storing associated material data and associated process data associated with the primary process BOM file; an easy language processing module, the input end of which is connected with the output ends of the PDM data module and the database module, the easy language processing module comprising a hierarchy allocation processing unit, a quantity data processing unit, a same-type item data processing unit and a database data processing unit; wherein the hierarchy allocation processing unit is used for extracting hierarchy data and name data in the primary process BOM file and classifying the hierarchy data and the name data into product bodies, intermediate hierarchy components and minimum hierarchy materials; the quantity data processing unit is used for adding up the quantity data of the intermediate hierarchy components and the minimum hierarchy materials; the same-type item data processing unit is used for extracting material code, drawing number, model specification, material and total weight data in the primary process BOM file and matching the data with the intermediate hierarchy components and the minimum hierarchy materials according to names; and the database data processing unit is used for extracting associated process data and associated material data and matching the data with the intermediate hierarchy components and the minimum hierarchy materials according to names; a process quota module, the input end of which is connected with the output end of the easy language processing module, used for creating a table with the material code, the drawing number, the model specification, the material, the quantity, the total weight, the intermediate hierarchy components, the associated material data and the associated process data as row table headers and filling corresponding data and minimum hierarchy material names into the table to generate a process quota BOM file of the traction inverter.

2. The BOM processing system based on PDM system traction inverter according to claim 1, characterized in that, The intermediate hierarchy components comprise traction power module components, traction front end input module components, fan control components, heavy load connector components and traction control cabinets.

3. The BOM processing system based on PDM system traction inverter according to claim 1, characterized in that, The associated process data comprises fan control work instruction sheets and heavy load connector work instruction sheets.

4. A structure processing method of a BOM of a traction inverter based on a PDM system, which refers to the structure processing system of the BOM of the traction inverter based on the PDM system according to any one of claims 1 to 3, characterized in that, The application further discloses a traction inverter BOM file generation method, which comprises the following steps: S1, generating a primary process BOM file of a traction inverter according to product process requirements; S2, calling corresponding associated material data and associated process data from a database module according to the primary process BOM file; S3, extracting and classifying hierarchy data and name data in the primary process BOM file into product bodies, intermediate hierarchy components and minimum hierarchy materials by using a hierarchy allocation processing unit in an easy language processing module; S4, adding up the quantity data of the intermediate hierarchy components and the minimum hierarchy materials by using a quantity data processing unit in the easy language processing module; S5, extracting material code, drawing number, model specification, material and total weight data in the primary process BOM file by using a same-type item data processing unit in the easy language processing module and extracting associated process data and associated material data by using a database data processing unit in the easy language processing module. S6, the process quota module creates a table with the material code, drawing number, model specification, material, quantity, total weight, intermediate level assembly, associated material data and associated process data as the row table header, and fills the corresponding data and minimum level material name into the table to generate the process quota BOM file of the traction inverter.

5. The method of claim 4, wherein the BOM is structured based on a PDM system of the traction inverter. The intermediate level assembly includes a traction power module composition, a traction front end input module composition, a fan control assembly, a heavy load connector assembly and a traction control cabinet.

6. The method of claim 4, wherein the BOM is structured based on a PDM system of the traction inverter. The associated process data includes a fan control work instruction and a heavy load connector work instruction.

Images