CN107464083B - Method, device and equipment for generating bill of materials - Google Patents
Method, device and equipment for generating bill of materials Download PDFInfo
- Publication number
- CN107464083B CN107464083B CN201710733562.0A CN201710733562A CN107464083B CN 107464083 B CN107464083 B CN 107464083B CN 201710733562 A CN201710733562 A CN 201710733562A CN 107464083 B CN107464083 B CN 107464083B
- Authority
- CN
- China
- Prior art keywords
- workpiece
- workpieces
- process assembly
- bill
- materials
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
Abstract
The invention discloses a method, a device and equipment for generating a bill of materials, relates to the technical field of data processing, and mainly aims to simplify the record content of the conventional BOM and improve the processing efficiency of operations such as modification, query and the like of the BOM. The method mainly comprises the following steps: setting an identification column in a bill of materials, wherein workpiece identifications in the identification column are used for marking process assemblies of the same type and corresponding combined workpieces; detecting whether a workpiece with changed information exists in a combined workpiece corresponding to a target process assembly; if yes, extracting all currently effective workpieces related to the target process assembly in a bill of materials according to the workpiece identification of the target process assembly; and recording the latest effective time of all the currently effective workpieces as the effective time of the target process assembly, and recording the earliest failure time as the failure time of the target process assembly. The invention is mainly used for making and updating the bill of materials.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a method, a device and equipment for generating a bill of materials.
Background
The Bill of Material (BOM) is the main data of the automobile enterprise, which runs through the whole life cycle of the product, is generated and applied to the business fields of design development, purchasing sourcing, process development, financial management, production manufacturing, after-sales service, etc., and is the main carrier of information in each business field. Based on different application stages, the BOM is further classified into variable BOM, EBOM (Engineering BOM), MBOM (Manufacturing BOM), and the like. The BOM is not only a technical file but also a management file, is a link for linking and communicating all departments, fully embodies data sharing and integration, and is a framework for forming an ERP system.
In the conventional BOM management, a tree structure composed of workpieces is used to represent the assembly level and the affiliation of parts. And whether the BOM line is effectively used is controlled by the effective breakpoint single number, the effective time controlled by the invalid breakpoint single number and the invalid time. However, in this management method, when there is a workpiece that is changed, each process assembly using the workpiece needs to change information in the corresponding BOM row, and especially when there are a large number of process assemblies in the BOM table, the operations of searching for whether the process assembly contains the workpiece and performing modification and correction will inevitably bring huge workload and consume a large amount of computing resources.
Disclosure of Invention
In view of this, the present invention provides a method, an apparatus, and a device for generating a bill of material, and mainly aims to simplify the record content of the existing BOM table and improve the processing efficiency of operations such as modification and query of the BOM table.
In a first aspect, the present invention provides a method for generating a bill of materials, where the method includes:
setting an identification column in a bill of materials, wherein workpiece identifications in the identification column are used for marking process assemblies of the same type and corresponding combined workpieces, wherein the process assemblies are workpieces formed by a plurality of workpieces and/or combined workpieces;
detecting whether a workpiece with changed information exists in a combined workpiece corresponding to a target process assembly;
if yes, extracting all currently effective workpieces related to the target process assembly in a bill of materials according to the workpiece identification of the target process assembly;
and recording the latest effective time of all the currently effective workpieces as the effective time of the target process assembly, and recording the earliest failure time as the failure time of the target process assembly.
Preferably, the workpiece on which the information change occurs includes: the workpiece which modifies the information of the original workpiece or the new workpiece which is added.
Preferably, the method further comprises:
extracting the query time in the process assembly query request;
and inquiring the process assemblies in the bill of materials, which take effect at the inquiring time point, so as to respond to the process assembly inquiring request.
Preferably, the method further comprises:
and setting unique workpiece numbers for the workpieces and the process assemblies in the bill of materials, wherein the workpieces and the process assemblies have independent coding rules.
Preferably, the method further comprises:
when determining to add a new workpiece, setting different configuration variables according to configuration information of the new workpiece;
and adding a corresponding new process assembly according to the configuration variables set for the new workpiece by the configuration unit, and configuring a unique workpiece number for the new process assembly.
Preferably, the setting of unique workpiece numbers for the workpieces and process assemblies in the bill of materials comprises:
detecting whether material information of each line of workpieces in the bill of materials is a new workpiece or not line by line, wherein the material information comprises a workpiece name, a workpiece identifier, a configuration variable and a breakpoint number;
if the workpiece is a new workpiece, setting a new workpiece number according to the coding rule;
and if the recorded workpiece has the same workpiece name and the same workpiece identifier, and different configuration variables and breakpoint numbers, setting the workpiece number which is the same as the recorded workpiece.
In a second aspect, the present invention provides an apparatus for generating a bill of materials, the apparatus comprising:
the device comprises a setting unit, a processing unit and a processing unit, wherein the setting unit is used for setting an identification column in a bill of materials, and workpiece identifications in the identification column are used for marking process assemblies of the same type and corresponding combined workpieces;
the detection unit is used for detecting whether a workpiece with changed information exists in the combined workpiece corresponding to the target process assembly;
the extracting unit is used for extracting all currently effective workpieces related to the target process assembly in the bill of materials according to the workpiece identification of the target process assembly set by the setting unit when the detecting unit detects the workpieces with changed information;
and the recording unit is used for recording the latest effective time of all currently effective workpieces extracted by the extraction unit as the effective time of the target process assembly, and recording the earliest failure time as the failure time of the target process assembly.
Preferably, the apparatus further comprises:
the extraction unit is also used for extracting the query time in the process assembly query request;
and the query unit is used for querying the process assemblies in the bill of materials, which take effect at the query time point extracted by the extraction unit, so as to respond to the query requests of the process assemblies.
Preferably, the apparatus further comprises:
and the coding unit is used for setting unique workpiece numbers for the workpieces and the process assembly in the bill of materials, wherein the workpieces and the process assembly have independent coding rules.
Preferably, the encoding unit includes:
the detection module is used for detecting whether material information of each line of workpieces in the bill of materials is a new workpiece or not line by line, wherein the material information comprises workpiece names, workpiece identifications, configuration variables and breakpoint numbers;
the setting module is used for setting a new workpiece number according to a coding rule when the workpiece detected by the detection module is a new workpiece;
the setting module is further used for setting the same workpiece number as the recorded workpiece when the workpiece detected by the detection module and the recorded workpiece have the same workpiece name and workpiece identification, and different configuration variables and breakpoint numbers.
Preferably, the apparatus further comprises:
the configuration unit is used for setting different configuration variables according to the configuration information of the new workpiece when the new workpiece is determined to be added;
and the adding unit is used for adding a corresponding new process assembly according to the configuration variables set for the new workpiece by the configuration unit and configuring a unique workpiece number for the new process assembly.
In a third aspect, the present invention provides a terminal for generating a bill of materials, where the terminal includes a storage medium and a processor;
the storage medium is used for storing a plurality of instructions, and the instructions are suitable for being loaded by the processor and executing the bill of material generation method of the first aspect;
the processor is configured to load and execute the instructions stored in the storage medium.
By means of the technical scheme, the method, the device and the equipment for generating the bill of materials mainly change a mode that the process assemblies and the corresponding combined workpieces are displayed in a tree structure in the existing BOM, the process assemblies of the same type and the corresponding combined workpieces are marked by the added identification columns, the incidence relation between the workpieces and the process assemblies is embodied by the workpiece identifications, the situation that the same workpieces are repeatedly appeared in a plurality of process assemblies is avoided, the same workpiece in the BOM only needs to be displayed by one line of workpiece information, when the workpiece needs to be changed, only one line of workpiece information needs to be changed, and the processing speed of the change operation is greatly improved. For the process assembly with the modified workpiece information, the effective and failure time of the process assembly can be determined by calculating the effective and failure time points of the effective associated workpiece, so as to ensure the accurate corresponding relationship between the process assembly and the workpiece formed by the process assembly.
The foregoing description is only an overview of the technical solutions of the present invention, and the embodiments of the present invention are described below in order to make the technical means of the present invention more clearly understood and to make the above and other objects, features, and advantages of the present invention more clearly understandable.
Drawings
Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the invention. Also, like reference numerals are used to refer to like parts throughout the drawings. In the drawings:
fig. 1 is a flowchart illustrating a method for generating a bill of materials according to an embodiment of the present invention;
FIG. 2 is a block diagram illustrating an apparatus for generating a bill of materials according to an embodiment of the present invention;
fig. 3 is a block diagram illustrating another bill of materials generation apparatus according to an embodiment of the present invention.
Detailed Description
Exemplary embodiments of the present invention will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the invention are shown in the drawings, it should be understood that the invention can be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the invention to those skilled in the art.
In order to more clearly illustrate the bill of materials recorded in the present invention, the display mode of the tree structure of the process assembly and the combined workpiece in the existing BOM table is listed through the contents in table 1.
Table one:
wherein, 1 in the hierarchical column of table 1 is a process assembly, and 2 is a combined workpiece in the process assembly, and as can be seen from table 1, each process assembly contains the same workpiece support 2(a01-00005) and nut (Q32006). The BOM table records a table for producing a transmission in an automobile, different transmission technical assemblies represent different types of transmissions and are composed of corresponding types of transmissions, a bracket 1, a bracket 2 and nuts, and in the listed example of the table, the change of the bracket 1 is changed from A01-00004 to A01-00007, so that the original five-speed manual transmission assembly is changed from A01-91001 to A01-91003. And because the reinforced five-speed manual transmission (A01-00009) is added in 7, month and 22 in 2017, a process assembly, namely the reinforced five-speed manual transmission assembly (A01-91009), is required to be added, different configuration variables are configured for the two transmission assemblies in order to distinguish the transmission assembly from the original five-speed manual transmission (A01-00001) installed with the five-speed manual transmission, so that the configuration variables of the original five-speed manual transmission are changed from AB2 to AB2& AC0, the process assembly with the changed configuration variables is newly built for distinguishing from the original, and the configuration variables of the corresponding newly added reinforced five-speed manual transmission assembly are AB2& AC 1.
It can be seen from the structure shown in table one that the tree structure is formed by the process assemblies as the father node, and the combined workpieces forming the process assemblies are the child nodes of the father node, and when there is a workpiece change or a new process assembly, because some workpieces in the process assemblies belong to common components, once there is a change and modification on these workpieces, it will be necessary to modify the related information of the workpieces in the process assemblies, and this will undoubtedly make the operation of modification and modification very cumbersome in the production process of the more complicated process assemblies, and even the situation of wrong modification or missed modification may occur.
Aiming at the disadvantages of information records in the existing BOM table, the embodiment of the invention provides a method for generating a bill of materials, which modifies the existing display mode of a tree structure into a linear display mode, so that the process combined piece and the combined workpiece do not have visual association effect any longer, but each workpiece and the process combined piece are linearly listed based on the internal association relationship between the process combined piece and the combined workpiece, and the specific method for recording is shown in figure 1, and the method mainly comprises the following steps:
101. and setting an identification column in the bill of materials.
The main purpose of setting the identification column is to mark workpiece identifications for each workpiece and process assembly in the BOM table, wherein the workpiece identifications are used for distinguishing different types of process assemblies and combined workpieces corresponding to the process assemblies.
Specifically, as shown in table two, an identification column is added on the basis of table one, and is named as "process assembly", specifically, as follows:
watch two
As can be seen from the second table, for the fact that the workpieces and the process assemblies do not have hierarchical relationships, the hierarchical levels of the two types of information are 1 level, the 'process assembly' is listed as newly added data content, the marked 'P001' is workpiece marks, and as can be seen from the marks, no workpiece mark is marked on the nut (Q33008), which indicates that the nut and other workpieces do not belong to the same type, but may be workpieces of the same type as other process assemblies, such as a frame assembly, an engine assembly and the like. Only workpiece identifiers (P001) belonging to the transmission class are listed in the table, and other identifiers are not shown schematically.
Comparing the contents of table one, table two omits the overlapped part of the workpiece, and the corresponding relationship between the process assembly and the combined workpiece can be identified by "process assembly" and "configuration variable", for example, the five-speed manual transmission assembly (a01-91001) is composed of a five-speed manual transmission (a01-00001), a bracket 1(a01-00004), a bracket 2(a01-00005) and a nut (Q32006), and the six-speed manual transmission assembly (a01-91002) is composed of a six-speed manual transmission (a01-00002), a bracket 1(a01-00004), a bracket 2(a01-00005) and a nut (Q32006). It can be seen that each kind of workpiece in the BOM table only needs one line of information in the table to be recorded, so that when the information of the workpiece needs to be modified, only one line of information corresponding to the workpiece needs to be modified, and the condition of false modification or missed modification is avoided.
102. And detecting whether a workpiece with changed information exists in the combined workpiece corresponding to the target process assembly.
In this step and the subsequent steps, when there is a modification requirement for the BOM table obtained in step 101, how to record the relevant content in the table according to the changed information.
Specifically, the content in the table is detected, and the detection may be performed in real time or at preset time intervals. The detection of whether the information of the workpiece in the BOM table is changed is further divided into detection of whether the workpiece recorded in the table is changed or not, or whether a new workpiece is added to the BOM table.
Specifically, in the content recorded in table two, the detected information in the embodiment of the present invention is the name of the workpiece, the configuration variable, the process assembly, the number of the effective/ineffective breakpoint, and the corresponding effective/ineffective time. If there is no change, the current state of the BOM table is maintained, and when it is detected that there is a change in the information of the workpiece, step 103 is executed.
It should be noted that, during the detection in this step, the detected workpiece or process assembly has a certain association relationship between the workpiece and the process assembly, so that when the workpiece is detected, if the workpiece changes, the associated process assembly will inevitably be changed.
103. And extracting all currently effective workpieces associated with the target process assembly in the bill of materials according to the workpiece identification of the target process assembly.
For the case of changing the information of the workpiece, the application of the method to the actual production process generally is a technical improvement on the workpiece, or the addition of the new workpiece results in the abandonment of the original workpiece. Thus, the original target process assembly will be altered and, when a new workpiece is added, may also result in the creation of a new process assembly.
In this step, the target process assembly includes an original process assembly to be modified and a newly generated process assembly, workpieces having the same workpiece identifier are extracted according to the workpiece identifier of the target process assembly, workpieces associated with the target process assembly are screened out according to the association relationship between the workpieces, and then the workpieces which are currently effective are searched out from the screened workpieces. The process is based on the fact that when the workpiece is modified, the effective time of the new workpiece is matched with the failure time of the original workpiece or the replaced workpiece, namely, the effective time of the changed or newly added workpiece is in the future, and the current workpiece is effective or the original workpiece is not. Therefore, the effectiveness of the process assembly is determined according to the effectiveness of the associated workpiece, so as to provide accurate statistical data for statistical users.
For the above process, the following description will be made by way of example with the contents shown in table three.
Watch III
The contents of table three are changes made to the case where the work carrier 1(a01-00004) is modified and the enhanced five-speed manual transmission (a01-00009) is added, based on the contents of table two. The change is consistent with the modification in table one, but the effect is clearly different when comparing table one with table three.
Specifically, in table three, the effective time and the failure time of each workpiece and the process assembly are recorded, and correspondingly, an effective breakpoint single number and a failure breakpoint single number generated after change exist. By changing the support 1, the new support 1 is started from 7/1/2017, while the original support 1 is stopped from 7/1/2017, and although the two workpieces are named as the supports 1, the two workpieces are not the same workpiece, so that the workpiece numbers of the workpieces are distinguished and set to be A01-00004 and A01-00007. According to the effective time, the technological components of the transmission are statistically selected according to the time, namely, the bracket A01-00004 is used in 6 months, and the bracket A01-00007 is used in 1 day of 7 months.
For the newly added enhanced five-speed manual transmission (A01-00009), the effective time is 7/month & 1/2017, the corresponding new process assembly enhanced five-speed manual transmission assembly (A01-91009) also takes effect at 7/month & 1/day, and in order to distinguish from the original five-speed manual transmission assembly (A01-91001), the effective time and the failure time of the original five-speed manual transmission assembly are required to be changed without changing the workpiece number of the original five-speed manual transmission assembly except for modifying corresponding configuration variables. Likewise, a corresponding modification operation is required for the original five-speed manual transmission (A01-00001), by which it can be seen that the same workpiece or process kit corresponds to a unique workpiece number, where multiple rows of identical workpieces or process assemblies are present in the BOM table, this is to distinguish between active time periods, and different configuration variables exist for different periods of time, e.g., for a five-speed manual transmission, at 6 months, there was only one transmission with a corresponding configuration variable of AB2, and after 7 months and 1 days, there were two transmissions, namely the original five-speed manual transmission and the enhanced five-speed manual transmission, at the moment, the configuration variable of the enhanced five-speed manual transmission is AB2& AC1, in order to distinguish from the original five-speed manual transmission, the configuration variable of the original five-speed manual transmission needs to be modified from AB2 to AB2& AC 0.
The content in the first table is compared, so that the line number of the whole table is reduced, the content required to be displayed is effectively simplified, the effective and invalid time of each workpiece is increased, and the user can more intuitively monitor the current production and use conditions of each workpiece.
104. And recording the latest effective time of all the currently effective workpieces as the effective time of the target process assembly, and recording the earliest failure time as the failure time of the target process assembly.
In this step, the effective time and the failure time of the target process assembly are determined, and the effective time and the failure time of each workpiece are specifically determined according to all currently effective workpieces which are screened and associated with the target process assembly in the step 103. Still taking table three as an example, for example, in the reinforced five-speed manual transmission assembly (a01-91009), assuming that the current time is 7 months and 15 days, the associated and effective workpieces are the reinforced five-speed manual transmission (a01-00009), the bracket 1(a01-00007), the bracket 2(a01-00005) and the nut (Q32006), the effective time and the failure time of the workpieces are compared, the 7 months and 1 days in 2017 with the latest effective time are determined as the effective time of the assembly a01-91009, and the 12 months and 31 days in 9999 with the earliest failure time are determined as the failure time of the assembly a 01-91009.
Therefore, when the workpiece is changed or newly added, the corresponding workpiece information in the BOM table and the information of the associated process assembly can be automatically adjusted and corrected according to the process, and the operation flow of a user is simplified to the maximum extent.
It can be known from the foregoing specific embodiments that the method for generating a bill of materials provided in the embodiments of the present invention mainly changes a mode in which process assemblies and corresponding combined workpieces are displayed in a tree structure in an existing BOM table, marks the process assemblies of the same type and the corresponding combined workpieces through an added identification column, and reflects an association relationship between the workpieces and the process assemblies by workpiece identifications, thereby avoiding a situation in which the same workpieces are repeatedly displayed in a plurality of process assemblies, so that the same workpiece in the BOM table only needs one row of workpiece information to be displayed, and when a workpiece needs to be modified, only one row of workpiece information needs to be modified, thereby greatly improving a processing speed of the modification operation. For the process assembly with the modified workpiece information, the effective and failure time of the process assembly can be determined by calculating the effective and failure time points of the effective associated workpiece, so as to ensure the accurate corresponding relationship between the process assembly and the workpiece formed by the process assembly. The BOM recorded by the embodiment of the invention not only simplifies the content recorded by the table, but also simplifies the relevance modification operation required by the user when modifying the content in the table, greatly improves the convenience of the user, and also improves the use experience of the user.
In order to describe the method for generating a bill of material proposed in the embodiment of the present invention in more detail, for the content recorded in the BOM table and the specific application based on the BOM table, a further recording manner of the BOM table will be described below based on the above embodiment, where the content in table three is still exemplified:
firstly, the workpiece number recorded in the BOM table and corresponding to the process assembly is unique, that is, the same workpiece has only one workpiece number in the BOM table, and the combination of the five-speed manual transmission and the five-speed manual transmission in table three has two rows, but the contents of the two parts are the same, only the period of time between active and inactive differs, and the configuration variables set differ, wherein, the configuration variables are symbols which are designed in advance to describe the configuration characteristics of the workpiece and are connected by logic symbols such as 'and', 'or' (|), 'brackets' (), and the like, for example, the configuration variables of the five-speed manual transmission are modified from AB2 to AB2& AC0, added to '& AC 0', it is added to distinguish the configuration variables (AB2& AC1) of the newly added enhanced five-speed manual transmission, which is the same product for the five-speed manual transmission. It can be seen that the workpiece or the process assembly recorded in the embodiment of the invention is a description of the same product even if multiple rows exist, and the positions appearing in the table are generally adjacent or close, so that the query operation is very convenient.
In addition, the encoding rules used in the embodiment of the present invention are independent from each other for the workpiece and the process assembly, and the encoding rules are independent from the workpiece identifier, such as the workpiece codes A01-00001, A01-00002 in Table III, and the like for the workpiece, and the encoding rules are A01-91001, A01-91002, and the like for the process assembly. By the coding, a user can quickly identify the workpiece and the process assembly, and the checking operation of the user is facilitated.
Based on the independent encoding rule, when a new workpiece or process assembly is added to the BOM, a workpiece number needs to be set for the workpiece or the process assembly, and when the workpiece number is allocated to the BOM, whether the workpiece or the process assembly is new needs to be detected firstly, that is, whether the workpiece or the process assembly exists in the BOM is judged, if the workpiece or the process assembly exists, encoding is carried out according to the corresponding encoding rule, and if the workpiece or the process assembly exists, the workpiece number which is the same as the recorded workpiece is set for the workpiece or the process assembly. When the BOM table is initially recorded, the workpiece or process assembly to be added is also detected line by line in the above manner, and a corresponding workpiece number is set for each line of the workpiece or process assembly.
For judging whether the current workpiece or the process assembly is available, the judgment is mainly carried out according to material information to be recorded in a BOM line, and in the example of the table III, the material information mainly comprises a workpiece name, a workpiece identifier, a configuration variable, a breakpoint number and the like. When one parameter in the workpiece name and the workpiece identifier is different or the user specifies to change the workpiece or the process assembly, the current workpiece or the process assembly can be determined as a new workpiece, so that a new workpiece number is configured for the current workpiece or the process assembly. And when the workpiece name and the workpiece identifier are the same and the configuration variable and the breakpoint number are different, determining that the current workpiece is the recorded workpiece and configuring the workpiece number of the current workpiece, which is the same as the recorded workpiece, for example, in table three, when the user specifies to modify the bracket 1, the workpiece number is set from a01-00004 to a01-00007, whereas for the two five-speed manual transmissions in the table, since the workpiece name and the workpiece identifier are the same and the configuration variable and the breakpoint number are different, it is stated that the workpiece numbers are the same.
Second, in addition to the above-mentioned way of identifying a workpiece or a process assembly and adding a workpiece number, the embodiment of the present invention further provides a way of configuring a workpiece number for an added new workpiece and a process assembly generated from the new workpiece, specifically: when it is determined that a new workpiece is added to the BOM table, the criterion of the new workpiece may be whether a new workpiece name or a new workpiece identifier exists, generally, the added new workpiece has related configuration information, a corresponding configuration variable is configured for the new workpiece according to the content of the configuration information, a corresponding new process assembly is added to the BOM table according to the configuration variable, and a unique workpiece number is configured for the new process assembly. This approach may correspond to the procedure of adding an enhanced five-speed manual transmission in table three, when the workpiece is added to the BOM table, the BOM table determines a configuration variable (AB2& AC1) for the workpiece according to its configuration information, and configures a unique workpiece number (a01-00009), and due to the addition of a new workpiece a01-00009, a combination using the enhanced five-speed manual transmission, i.e., an enhanced five-speed manual transmission combination in the table, is generated in the process combination of the transmission category, the configuration variable of which is the same as the configuration variable of workpiece a01-00009, and configures a unique workpiece number (a01-91009) for the process combination.
Thirdly, based on the above BOM table, when a user needs to check the statistical information of some process assemblies in the table, the user can request to return a corresponding query result to the BOM table through a query request. The query request is generally set by a user in a user-defined manner according to needs, and may also be a query request of some standards provided by a BOM table. When the BOM receives a query request sent by a user, the query request is analyzed, corresponding query time is extracted from the query request, the process assemblies in an effective state at the time point are matched according to the query time, meanwhile, the obtained effective process assemblies are further screened and filtered in cooperation with other query conditions, information of the process assemblies meeting the query request is finally obtained, and the information is used as response of the query request to be fed back to the user.
When the feedback result of the process assembly inquiry request is displayed, the displayed information can be BOM line information of an independent process assembly, or BOM line information of a combined workpiece associated with the process assembly can be output together.
Further, according to the above method embodiment, another embodiment of the present invention further provides a device for generating a bill of materials, as shown in fig. 2, the device mainly includes:
the setting unit 21 is used for setting an identification column in a bill of materials, wherein workpiece identifications in the identification column are used for marking process assemblies of the same type and corresponding combined workpieces, and the setting unit 21 can be freely set at the position of the identification column inserted in the BOM table;
the detection unit 22 is configured to detect whether a workpiece with changed information exists in a combined workpiece corresponding to a target process assembly, where the changed workpiece is not limited to be a workpiece or a process assembly, and a definition of the change is not limited to be an update of an original workpiece or a process assembly or a newly added workpiece or a process assembly;
the extracting unit 23 is configured to, when the detecting unit 22 detects a workpiece with changed information, extract all currently-valid workpieces associated with the target process assembly in the bill of materials according to the workpiece identifier of the target process assembly set by the setting unit 21, that is, the workpiece belongs to a combined workpiece of the target process assembly and is the currently-valid workpiece.
A recording unit 24, configured to record, as the effective time of the target process assembly, the time with the latest effective time among all currently effective workpieces extracted by the extraction unit 23, and record the time with the earliest failure time as the failure time of the target process assembly, where the recording unit 24 is configured to, when there is a workpiece change or a newly added workpiece in the BOM table, perform verification and change operations on the relevant process assemblies in the BOM table, and ensure that process assembly information in the BOM table corresponds to information of the workpiece.
Further, as shown in fig. 3, the apparatus further includes:
the extracting unit 23 is further configured to, when receiving a query request of a user for a process assembly, extract a query time in the query request of the process assembly;
the query unit 25 is configured to query the process assemblies in the bill of materials that take effect at the query time point extracted by the extraction unit 23, so as to respond to the process assembly query request.
Further, as shown in fig. 3, the apparatus further includes:
and the coding unit 26 is used for setting a unique workpiece number for the workpiece and the process assembly in the bill of materials, wherein the workpiece and the process assembly have independent coding rules.
Further, as shown in fig. 3, the encoding unit 26 includes:
the detecting module 261 is configured to detect, line by line, whether material information of each line of workpieces in the bill of materials is a new workpiece, where the material information includes a workpiece name, a workpiece identifier, a configuration variable, and a breakpoint number;
a setting module 262, configured to set a new workpiece number according to an encoding rule when the workpiece detected by the detecting module 261 is a new workpiece;
the setting module 262 is further configured to set the same workpiece number as the recorded workpiece when the workpiece detected by the detecting module and the recorded workpiece have the same workpiece name and workpiece identifier, and different configuration variables and breakpoint numbers.
Further, as shown in fig. 3, the apparatus further includes:
the configuration unit 27 is used for setting different configuration variables according to the configuration information of the new workpiece when the new workpiece is determined to be added;
and an adding unit 28, configured to add a corresponding new process assembly according to the configuration variable set for the new workpiece by the configuration unit 27, and configure a unique workpiece number for the new process assembly.
Further, based on the apparatus for generating a bill of material, an embodiment of the present invention further provides a terminal for generating a bill of material, where the terminal is provided with the apparatus for generating a bill of material, and is further provided with a storage medium and a processor, so as to configure the apparatus for generating a bill of material to execute the method for generating a bill of material in the above embodiment, where the storage medium is used to store a plurality of instructions, and the processor is used to load and execute the instructions stored in the storage medium, so as to display operations of generating and updating a BOM table.
In summary, the method, the apparatus, and the terminal for generating a bill of materials provided in the embodiments of the present invention mainly change a mode in which a process assembly and a corresponding combined workpiece are displayed in a tree structure in an existing BOM table, mark the process assemblies of the same type and the corresponding combined workpieces through an added identification column, and reflect an association relationship between the workpieces and the process assemblies through workpiece identifications, thereby avoiding a situation that the same workpiece is repeatedly displayed in a plurality of process assemblies, so that the same workpiece in the BOM table only needs to be displayed in a line of workpiece information, and when a workpiece needs to be modified, only a modification operation needs to be performed on the workpiece information of a unique BOM line, thereby greatly improving a processing speed of the modification operation. For the process assembly with the modified workpiece information, the effective and failure time of the process assembly can be further determined by calculating the effective and failure time points of the effective associated workpiece, so as to ensure the accurate corresponding relationship between the process assembly and the workpiece formed by the process assembly. The BOM recorded by the embodiment of the invention not only simplifies the content recorded by the table, but also simplifies the relevance modification operation required by the user when modifying the content in the table, greatly improves the convenience of the user, and also improves the use experience of the user.
In the foregoing embodiments, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.
It will be appreciated that the relevant features of the method, apparatus and system described above are referred to one another. In addition, "first", "second", and the like in the above embodiments are for distinguishing the embodiments, and do not represent merits of the embodiments.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described systems, apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
The algorithms and displays presented herein are not inherently related to any particular computer, virtual machine, or other apparatus. Various general purpose systems may also be used with the teachings herein. The required structure for constructing such a system will be apparent from the description above. Moreover, the present invention is not directed to any particular programming language. It is appreciated that a variety of programming languages may be used to implement the teachings of the present invention as described herein, and any descriptions of specific languages are provided above to disclose the best mode of the invention.
In the description provided herein, numerous specific details are set forth. It is understood, however, that embodiments of the invention may be practiced without these specific details. In some instances, well-known methods, structures and techniques have not been shown in detail in order not to obscure an understanding of this description.
Similarly, it should be appreciated that in the foregoing description of exemplary embodiments of the invention, various features of the invention are sometimes grouped together in a single embodiment, figure, or description thereof for the purpose of streamlining the disclosure and aiding in the understanding of one or more of the various inventive aspects. However, the disclosed method should not be interpreted as reflecting an intention that: that the invention as claimed requires more features than are expressly recited in each claim. Rather, as the following claims reflect, inventive aspects lie in less than all features of a single foregoing disclosed embodiment. Thus, the claims following the detailed description are hereby expressly incorporated into this detailed description, with each claim standing on its own as a separate embodiment of this invention.
Those skilled in the art will appreciate that the modules in the device in an embodiment may be adaptively changed and disposed in one or more devices different from the embodiment. The modules or units or components of the embodiments may be combined into one module or unit or component, and furthermore they may be divided into a plurality of sub-modules or sub-units or sub-components. All of the features disclosed in this specification (including any accompanying claims, abstract and drawings), and all of the processes or elements of any method or apparatus so disclosed, may be combined in any combination, except combinations where at least some of such features and/or processes or elements are mutually exclusive. Each feature disclosed in this specification (including any accompanying claims, abstract and drawings) may be replaced by alternative features serving the same, equivalent or similar purpose, unless expressly stated otherwise.
Furthermore, those skilled in the art will appreciate that while some embodiments described herein include some features included in other embodiments, rather than other features, combinations of features of different embodiments are meant to be within the scope of the invention and form different embodiments. For example, in the following claims, any of the claimed embodiments may be used in any combination.
The various component embodiments of the invention may be implemented in hardware, or in software modules running on one or more processors, or in a combination thereof. Those skilled in the art will appreciate that a microprocessor or Digital Signal Processor (DSP) may be used in practice to implement some or all of the functions of some or all of the components of the method, apparatus and device for generating a bill of materials according to embodiments of the present invention. The present invention may also be embodied as apparatus or device programs (e.g., computer programs and computer program products) for performing a portion or all of the methods described herein. Such programs implementing the present invention may be stored on computer-readable media or may be in the form of one or more signals. Such a signal may be downloaded from an internet website or provided on a carrier signal or in any other form.
It should be noted that the above-mentioned embodiments illustrate rather than limit the invention, and that those skilled in the art will be able to design alternative embodiments without departing from the scope of the appended claims. In the claims, any reference signs placed between parentheses shall not be construed as limiting the claim. The word "comprising" does not exclude the presence of elements or steps not listed in a claim. The word "a" or "an" preceding an element does not exclude the presence of a plurality of such elements. The invention may be implemented by means of hardware comprising several distinct elements, and by means of a suitably programmed computer. In the unit claims enumerating several means, several of these means may be embodied by one and the same item of hardware. The usage of the words first, second and third, etcetera do not indicate any ordering. These words may be interpreted as names.
Claims (12)
1. A method for generating a bill of materials, the method comprising:
setting an identification column in a bill of materials, wherein workpiece identifications in the identification column are used for marking process assemblies of the same type and corresponding combined workpieces, and the combined workpieces are workpieces used for assembling the process assemblies;
detecting whether a workpiece with changed information exists in a combined workpiece corresponding to a target process assembly;
if yes, extracting all currently effective workpieces related to the target process assembly in a bill of materials according to the workpiece identification of the target process assembly;
and recording the latest effective time of all the currently effective workpieces as the effective time of the target process assembly, and recording the earliest failure time as the failure time of the target process assembly.
2. The method of claim 1, wherein the artifact with information change comprises: the workpiece which modifies the information of the original workpiece or the new workpiece which is added.
3. The method of claim 1, further comprising:
extracting the query time in the process assembly query request;
and inquiring the process assemblies in the bill of materials, which take effect at the inquiring time point, so as to respond to the process assembly inquiring request.
4. The method according to claim 1 or 3, characterized in that the method further comprises:
and setting unique workpiece numbers for the workpieces and the process assemblies in the bill of materials, wherein the workpieces and the process assemblies have independent coding rules.
5. The method of claim 4, wherein setting unique workpiece numbers for workpieces and process assemblies in the bill of materials comprises:
detecting whether material information of each line of workpieces in the bill of materials is a new workpiece or not line by line, wherein the material information comprises a workpiece name, a workpiece identifier, a configuration variable and a breakpoint number;
if the workpiece is a new workpiece, setting a new workpiece number according to the coding rule;
and if the recorded workpiece has the same workpiece name and the same workpiece identifier, and different configuration variables and breakpoint numbers, setting the workpiece number which is the same as the recorded workpiece.
6. The method according to claim 1 or 3, characterized in that the method further comprises:
when determining to add a new workpiece, setting different configuration variables according to configuration information of the new workpiece;
and adding a corresponding new process assembly according to the configuration variables set for the new workpiece by the configuration unit, and configuring a unique workpiece number for the new process assembly.
7. An apparatus for generating a bill of material, the apparatus comprising:
the device comprises a setting unit, a processing unit and a processing unit, wherein the setting unit is used for setting an identification column in a bill of materials, workpiece identifications in the identification column are used for marking process assemblies of the same type and corresponding combined workpieces, and the combined workpieces are workpieces used for assembling the process assemblies;
the detection unit is used for detecting whether a workpiece with changed information exists in the combined workpiece corresponding to the target process assembly;
the extracting unit is used for extracting all currently effective workpieces related to the target process assembly in the bill of materials according to the workpiece identification of the target process assembly set by the setting unit when the detecting unit detects the workpieces with changed information;
and the recording unit is used for recording the latest effective time of all currently effective workpieces extracted by the extraction unit as the effective time of the target process assembly, and recording the earliest failure time as the failure time of the target process assembly.
8. The apparatus of claim 7, further comprising:
the extraction unit is also used for extracting the query time in the process assembly query request;
and the query unit is used for querying the process assemblies in the bill of materials, which take effect at the query time point extracted by the extraction unit, so as to respond to the query requests of the process assemblies.
9. The apparatus of claim 7 or 8, further comprising:
and the coding unit is used for setting unique workpiece numbers for the workpieces and the process assembly in the bill of materials, wherein the workpieces and the process assembly have independent coding rules.
10. The apparatus of claim 9, wherein the encoding unit comprises:
the detection module is used for detecting whether material information of each line of workpieces in the bill of materials is a new workpiece or not line by line, wherein the material information comprises workpiece names, workpiece identifications, configuration variables and breakpoint numbers;
the setting module is used for setting a new workpiece number according to a coding rule when the workpiece detected by the detection module is a new workpiece;
the setting module is further used for setting the same workpiece number as the recorded workpiece when the workpiece detected by the detection module and the recorded workpiece have the same workpiece name and workpiece identification, and different configuration variables and breakpoint numbers.
11. The apparatus of claim 7 or 8, further comprising:
the configuration unit is used for setting different configuration variables according to the configuration information of the new workpiece when the new workpiece is determined to be added;
and the adding unit is used for adding a corresponding new process assembly according to the configuration variables set for the new workpiece by the configuration unit and configuring a unique workpiece number for the new process assembly.
12. A bill of material generating terminal, comprising a storage medium and a processor;
the storage medium is used for storing a plurality of instructions, and the instructions are suitable for being loaded by a processor and executing the bill of materials generation method according to any one of claims 1 to 5;
the processor is configured to load and execute the instructions stored in the storage medium.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710733562.0A CN107464083B (en) | 2017-08-24 | 2017-08-24 | Method, device and equipment for generating bill of materials |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710733562.0A CN107464083B (en) | 2017-08-24 | 2017-08-24 | Method, device and equipment for generating bill of materials |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107464083A CN107464083A (en) | 2017-12-12 |
| CN107464083B true CN107464083B (en) | 2020-04-24 |
Family
ID=60550419
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710733562.0A Active CN107464083B (en) | 2017-08-24 | 2017-08-24 | Method, device and equipment for generating bill of materials |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107464083B (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109325063B (en) * | 2018-09-25 | 2022-03-15 | 奇瑞汽车股份有限公司 | Data management method and device |
| CN109886623A (en) * | 2019-01-30 | 2019-06-14 | 美林数据技术股份有限公司 | The group packet processing method and device of product data |
| CN110633944B (en) * | 2019-09-23 | 2022-06-07 | 苏州浪潮智能科技有限公司 | Method and device for processing item termination component in bill of materials |
| CN110889608A (en) * | 2019-11-18 | 2020-03-17 | 北京汽车集团越野车有限公司 | Engineering change flow control method and device, electronic equipment and storage medium |
Family Cites Families (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101393624A (en) * | 2008-11-05 | 2009-03-25 | 金蝶软件（中国）有限公司 | Method and apparatus for operating material list to realize production management |
| CN101937526A (en) * | 2010-04-28 | 2011-01-05 | 重庆迈特科技有限责任公司 | Method for configuring product multi-BOM tree based on base products |
| CN102456176B (en) * | 2010-10-27 | 2015-01-14 | 金蝶软件（中国）有限公司 | Method and device for engineering change of bill of material |
| CN102479205B (en) * | 2010-11-26 | 2014-03-05 | 金蝶软件（中国）有限公司 | Generation method and system of change order |
| CN102354314A (en) * | 2011-09-22 | 2012-02-15 | 用友软件股份有限公司 | Low-level code updating device and low-level code updating method |
| CN102819536B (en) * | 2011-09-27 | 2015-08-19 | 金蝶软件（中国）有限公司 | Tree type data disposal route and device |
| CN103020750A (en) * | 2012-11-19 | 2013-04-03 | 北京数码大方科技股份有限公司 | Process report generation method and device |
| US9489654B2 (en) * | 2014-03-14 | 2016-11-08 | Airbus Operations Sas | Artificial intelligence system and method for processing multilevel bills of materials |
-
2017
- 2017-08-24 CN CN201710733562.0A patent/CN107464083B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN107464083A (en) | 2017-12-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107464083B (en) | Method, device and equipment for generating bill of materials | |
| JP5598017B2 (en) | Judgment program, method and apparatus | |
| US7505983B2 (en) | Extending data flows | |
| CN111459985B (en) | Identification information processing method and device | |
| US8799275B2 (en) | Information retrieval based on semantic patterns of queries | |
| US11042662B2 (en) | Data aggregation system for enabling query operations on restricted data that originates from multiple independent multiple sources | |
| US20220121686A1 (en) | Database systems and user interfaces for interactive data association, analysis, and presentation | |
| US11915239B2 (en) | System and method for updating and managing hosted catalogs in a procurement system | |
| CN102857493A (en) | Content filtering method and device | |
| CN107015987B (en) | Method and equipment for updating and searching database | |
| CN102270225A (en) | Data change log monitoring method and device | |
| US8938443B2 (en) | Runtime optimization of spatiotemporal events processing | |
| US11184313B1 (en) | Message content cleansing | |
| CN111047434B (en) | Operation record generation method and device, computer equipment and storage medium | |
| CN111311080B (en) | Order detection revision method, order detection revision device, electronic equipment and computer readable medium | |
| CN104461864A (en) | Java source code defect detecting method and system based on Eclipse plugin | |
| US8463799B2 (en) | System and method for consolidating search engine results | |
| US20190391553A1 (en) | Control Program and Method for Operating an Engineering System for an Industrial Process Automation System | |
| CN104268244A (en) | Method and device for processing form | |
| JP2019537171A (en) | System and method for efficiently delivering warning messages | |
| CN106250477B (en) | Paging method for data in sub-table | |
| CN114363002A (en) | Method and device for generating network attack relation graph | |
| CN111143356B (en) | Report retrieval method and device | |
| CN110472125B (en) | Multistage page cascading crawling method and equipment based on web crawler | |
| US20140012869A1 (en) | Business object browser |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CP01 | Change in the name or title of a patent holder |
Address after: 100102 Beijing Chaoyang District, Hongtai East Street Wangjing Green Space Center, Block A, District D, 9 floors Patentee after: BEIJING CHJ AUTOMOTIVE TECHNOLOGY Co.,Ltd. Address before: 100102 Beijing Chaoyang District, Hongtai East Street Wangjing Green Space Center, Block A, District D, 9 floors Patentee before: Beijing Chehejia Information Technology Co.,Ltd. |
|
| CP01 | Change in the name or title of a patent holder | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20211201 Address after: 101300 room 107, building 1, courtyard 4, Hengxing Road, Gaoliying Town, Shunyi District, Beijing (scientific and technological innovation functional area) Patentee after: Beijing chehejia Automobile Technology Co.,Ltd. Address before: 100102 Beijing Chaoyang District, Hongtai East Street Wangjing Green Space Center, Block A, District D, 9 floors Patentee before: BEIJING CHJ AUTOMOTIVE TECHNOLOGY Co.,Ltd. |
|
| TR01 | Transfer of patent right |