BOM view structure construction method and system and computer storage medium

Abstract

The invention relates to the technical field of product structure management, in particular to a construction method and system of a BOM view structure and a computer storage medium. The method comprises the following steps: constructing BOM view parameter information based on a parent item material, a child item material, a version view of the parent item material and precision information of the parent item material corresponding to material object information, and verifying the BOM view parameter information; when the verification is passed and the user needs to independently construct a BOM view object, constructing the BOM view object based on the parent item material, the version view of the parent item material and the precision information of the parent item material; and constructing a BOM view structure based on the BOM view object and the subitem material, and bearing the BOM view structure through the multi-way tree relation table. According to the method, the precise BOM view object or the non-precise BOM view object is constructed according to the parent item material, the version view of the parent item material and the precision information of the parent item material, the precise or non-precise BOM view structure is further constructed, and the application flexibility of the BOM view structure in different industries is improved.

Description

Technical Field

[0001] The present application relates to the technical field of product structure management, and further to a method, system and computer storage medium for constructing a BOM view structure. Background Art

[0002] The management of product structure (Bill of Materials, BOM) is crucial to ensure the accuracy and consistency of product information. However, the requirements for BOM view structure vary significantly among different industries, which requires the BOM view structure to be able to flexibly adapt to changing management scenarios. The traditional BOM view structure does not distinguish between precise BOM and imprecise BOM, which reduces the flexibility of BOM view structure in different industries. Summary of the invention

[0003] In order to solve the above technical problems, the present application provides a method, system and computer storage medium for constructing a BOM view structure, which improves the flexibility of the BOM view structure in application in different industries.

[0004] In a first aspect, the present application provides a method for constructing a BOM view structure, including: constructing BOM view parameter information based on the parent material, child material, version view of the parent material and precision information of the parent material corresponding to the material object information, and verifying the BOM view parameter information; when the verification passes and the user requires to independently construct a BOM view object, constructing the BOM view object based on the parent material, version view of the parent material and precision information of the parent material; constructing a BOM view structure based on the BOM view object and the child material, and carrying the BOM view structure through a multi-tree relationship table.

[0005] The above BOM view structure construction method improves the data accuracy before the BOM view structure is built and the rationality of building different BOM view objects for the same material by verifying the view parameter information constructed by the parent material, child material, version view of the parent material and the precision information of the parent material. Then, an accurate BOM view object or an inaccurate BOM view object is constructed according to the parent material, version view of the parent material and the precision information of the parent material, and an accurate or inaccurate BOM view structure is further constructed, which improves the flexibility of the BOM view structure in different industries.

[0006] In one implementation, it also includes: when the verification passes and the user's requirement is to insert the sub-item material to build the BOM view object, determining whether the BOM view object exists in the BOM view master data table based on the master data identifier of the parent material; if it exists, obtaining the BOM view object from the BOM view master data table based on the master data identifier of the parent material and the version view of the parent material, and building the BOM view structure based on the BOM view object and the sub-item material; if it does not exist, building the BOM view structure based on the BOM view parameter information; verifying the hierarchical relationship between the sub-item material and the parent material in the BOM view structure, and determining that the sub-item material is mounted under the parent material.

[0007] In the above method for constructing the BOM view structure, when the user proposes to insert a sub-item material to construct a BOM view object, the system will first check whether the corresponding BOM view object already exists in the BOM view master data table. If it does, the system will directly use the existing BOM view object and sub-item material to construct the BOM view structure, which can avoid repeated construction and save time and resources. If it does not exist, the system will create a new BOM view object based on the BOM view parameter information and build the BOM view structure. In addition, the system will also verify the hierarchical relationship between the sub-item material and the parent material in the BOM view structure to ensure that the sub-item material is correctly mounted under the parent material, effectively solving the BOM structure hierarchical loop problem, thereby maintaining the accuracy and rationality of the BOM view structure. In addition, since a version view of a parent material corresponds to a BOM view object and a BOM view structure, the management problem of multiple version views of the same parent material is solved.

[0008] In one implementation, the verifying of the BOM view parameter information specifically includes:

[0009] The BOM view parameter information is checked for being non-empty; based on the ID of the parent material and the ID of the child material, it is determined whether the corresponding parent material and the child material are stored in the database; based on the ID of the parent material and the ID of the version view of the parent material, the uniqueness of the version view of the parent material is checked; when both the non-empty check and the uniqueness check are passed, and when the parent material and the child material are stored in the database, the BOM view parameter check is passed.

[0010] The above BOM view structure construction method performs non-empty check on BOM view parameter information to ensure that all necessary parameters are provided, thus avoiding construction errors caused by lack of key information. Next, by checking the parent material ID and the child material ID, it is confirmed that the corresponding parent material and child material do exist in the database, which helps to prevent construction failures caused by referencing non-existent materials. In addition, by checking the ID of the parent material information and the ID of the version view of the parent material, the uniqueness of the version view is ensured to avoid problems caused by version conflicts. At the same time, a management mode of one BOM view object corresponding to one BOM view structure is formed. The upper parent does not use material bearing, so that the parent material is decoupled from the BOM view structure, solving the problem of maintenance complexity of the BOM view structure due to changes in material attributes. Only when both the non-empty check and the uniqueness check are passed, and the corresponding parent material and child material are indeed stored in the database, the BOM view parameters are verified. This process further improves the data accuracy before the BOM view structure is constructed and the rationality of constructing different BOM view objects for the same material.

[0011] In one implementation, carrying the BOM view structure through a multi-tree relationship table specifically includes: carrying the BOM view object through a first parameter in the multi-tree relationship table; and carrying the information of the sub-item material through a second parameter in the multi-tree relationship table.

[0012] In one implementation, it also includes: persisting the BOM view object to a database, and obtaining the major version ID of the BOM view object and the major version ID of the parent material; establishing a BOM view connection relationship based on the major version ID of the BOM view object and the major version ID of the parent material.

[0013] In one implementation, the BOM view structure includes an accurate BOM view structure and an inaccurate BOM view structure, and also includes: when the BOM view structure is an accurate BOM view structure, the major version ID of the sub-item material is configured to be stored in the sub-item material attributes in the multi-tree relationship table; when the BOM view structure is an inaccurate BOM view structure, the current small version object of the sub-item material in the current version of the BOM view structure is obtained in real time.

[0014] In one implementation, it also includes: loading and displaying the BOM view structure based on the parent material, the version view of the parent material, a database recursive function, and asynchronously; loading the information of the current version of the BOM view structure based on the master data identifier of the child material; and loading the information of the fixed version of the BOM view structure based on the branch identifier of the child material.

[0015] In the second aspect, the present application also provides a BOM view structure construction system, including: a construction module, configured to construct BOM view parameter information based on the parent material, child material, version view of the parent material and precision information of the parent material corresponding to the material object information; a verification module, configured to verify the BOM view parameter information; the construction module is also configured to construct the BOM view object based on the parent material, the version view of the parent material and the precision information of the parent material when the verification passes and the user requires to independently construct the BOM view object; the construction module is also configured to construct a BOM view structure based on the BOM view object and the child material, and carry the BOM view structure through a multi-tree relationship table.

[0016] In one implementation, it also includes: a query module, which is configured to determine whether the BOM view object exists in the BOM view master data table based on the master data identifier of the parent material when the verification is passed and the user requires to insert the sub-item material to build the BOM view object; if it exists, the construction module is configured to obtain the BOM view object from the BOM view master data table based on the master data identifier of the parent material and the version view of the parent material, and build the BOM view structure based on the BOM view object and the sub-item material; if it does not exist, the construction module is configured to build the BOM view structure based on the BOM view parameter information; the hierarchical relationship between the sub-item material and the parent material in the BOM view structure is verified to determine that the sub-item material is mounted under the parent material.

[0017] In a third aspect, the present application further provides a computer storage medium having a computer program stored thereon, which, when executed by a processor, implements any of the steps of the above method for constructing the BOM view structure.

[0018] Compared with the prior art, the present invention has at least one of the following beneficial effects:

[0019] 1. By verifying the view parameter information constructed by the parent material, child material, version view of the parent material, and the precision information of the parent material, the data accuracy before the BOM view structure is constructed and the rationality of constructing different BOM view objects for the same material is improved. Then, according to the parent material, version view of the parent material, and the precision information of the parent material, an accurate BOM view object or an inaccurate BOM view object is constructed, and an accurate or inaccurate BOM view structure is further constructed, which improves the flexibility of the BOM view structure in different industries.

[0020] 2. When the user proposes to insert a sub-item material to build a BOM view object, the system will first check whether the corresponding BOM view object already exists in the BOM view master data table. If it does, the system will directly use the existing BOM view object and sub-item material to build the BOM view structure, which can avoid repeated construction and save time and resources. If it does not exist, the system will create a new BOM view object based on the BOM view parameter information and build the BOM view structure. In addition, the system will also verify the hierarchical relationship between the sub-item material and the parent material in the BOM view structure to ensure that the sub-item material is correctly mounted under the parent material, effectively solving the BOM structure hierarchical loop problem, thereby maintaining the accuracy and rationality of the BOM view structure. In addition, since a version view of a parent material corresponds to a BOM view object and a BOM view structure, the management problem of multiple version views of the same parent material is solved.

[0021] 3. Perform non-empty check on BOM view parameter information to ensure that all necessary parameters are provided, avoiding construction errors caused by lack of key information. Next, by checking the parent material ID and the child material ID, confirm that the corresponding parent material and child material do exist in the database, which helps prevent construction failures caused by referencing non-existent materials. In addition, by verifying the ID of the parent material information and the ID of the version view of the parent material, the uniqueness of the version view is ensured to avoid problems caused by version conflicts. At the same time, a management mode is formed in which one BOM view object corresponds to one BOM view structure. The upper parent does not use material carriers, so that the parent material is decoupled from the BOM view structure, solving the problem of maintenance complexity of the BOM view structure due to changes in material attributes. Only when both the non-empty check and the uniqueness check are passed, and the corresponding parent material and child material are indeed stored in the database, the BOM view parameters are verified. This process further improves the data accuracy before the BOM view structure is built and the rationality of building different BOM view objects for the same material. BRIEF DESCRIPTION OF THE DRAWINGS

[0022] The preferred implementation modes will be described below in a clear and understandable manner with reference to the accompanying drawings to further illustrate the above-mentioned characteristics, technical features, advantages and implementation methods of the present invention.

[0023] Figure 1 A flowchart showing a method for constructing a BOM view structure provided by an embodiment of the present application is shown;

[0024] Figure 2 A data schematic diagram of a BOM view structure provided in an embodiment of the present application is shown;

[0025] Figure 3A flowchart of inserting sub-item materials to construct a BOM view structure provided by an embodiment of the present application is shown;

[0026] Figure 4 A flowchart of verifying BOM view parameter information provided by an embodiment of the present application is shown;

[0027] Figure 5 A flowchart of loading a BOM view structure provided by an embodiment of the present application is shown;

[0028] Figure 6 A model diagram of a BOM view structure provided in an embodiment of the present application is shown;

[0029] Figure 7 A schematic diagram of an interface of a BOM view object provided in an embodiment of the present application is shown;

[0030] Figure 8 A schematic diagram of an interface of a BOM view object provided in an embodiment of the present application is shown;

[0031] Fig. 9 A schematic diagram of an interface of a BOM view object provided in an embodiment of the present application is shown;

[0032] Fig.10 A front-end schematic diagram of a BOM view structure provided in an embodiment of the present application is shown;

[0033] Fig.11 A schematic diagram showing the relationship between a BOM view and a BOM view structure provided in an embodiment of the present application is shown. DETAILED DESCRIPTION

[0034] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the specific implementation methods of the present invention will be described below with reference to the accompanying drawings. Obviously, the accompanying drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings and other implementation methods can be obtained based on these drawings without creative work.

[0035] In order to simplify the drawings, only the parts related to the invention are schematically shown in each figure, and they do not represent the actual structure of the product. In addition, in order to simplify the drawings and facilitate understanding, in some figures, only one of the parts with the same structure or function is schematically drawn or marked. In this article, "one" not only means "only one", but also means "more than one".

[0036] It should be further understood that the term “and / or” used in the specification and appended claims refers to any combination and all possible combinations of one or more of the associated listed items, and includes these combinations.

[0037] In this document, it should be noted that, unless otherwise clearly specified and limited, the terms "installed", "connected", and "connected" should be understood in a broad sense, for example, it can be a fixed connection, a detachable connection, or an integral connection; it can be a mechanical connection or an electrical connection; it can be a direct connection, or it can be indirectly connected through an intermediate medium, or it can be the internal communication of two components. For ordinary technicians in this field, the specific meanings of the above terms in the present invention can be understood according to specific circumstances.

[0038] In addition, in the description of the present application, the terms "first", "second", etc. are only used to distinguish the description and cannot be understood as indicating or implying relative importance.

[0039] It should be noted that the above embodiments can be freely combined as needed. The above are only preferred embodiments of the present invention. It should be pointed out that for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principle of the present invention, and these improvements and modifications should also be regarded as the protection scope of the present invention.

[0040] The product structure (Bill of Material, BOM) is a core technical tool that describes which parts a finished product is composed of and their composition relationships. Take a mobile phone as an example. As a finished product, it is composed of multiple parts and components, and these components themselves are composed of more parts. In the entire life cycle of a product, different stages and fields require different BOM views to support their business needs. BOM is essentially a description of the relationship between business objects and their related information. It not only supports the construction and display of cross-object relationships, but also covers a variety of business scenarios such as heavyweight team collaboration and product demand decomposition.

[0041] The BOM view structure uses a tree structure to manage the hierarchical relationship of products, which includes parent items and child items. Parent items are usually carried by BOM view objects, while child items can be BOM views or specific materials. The attributes of the BOM view include key information such as coding, name and version, while the BOM view structure attributes cover bit number, serial number, unit, quantity and extended attributes, etc. The embodiment of the present application constructs a BOM view structure by verifying the relevant information of the parent material and the relevant information of the child material, which can achieve at least one of the following beneficial effects: improving the flexibility of the BOM view structure in different industries; or improving the data accuracy before the BOM view structure is constructed and the rationality of constructing different BOM view objects for the same material.

[0042] The following is explained with reference to the accompanying drawings:

[0043] Reference Figure 1 , which shows a flowchart of a method for constructing a BOM view structure provided by an embodiment of the present application, such as Figure 1 As shown, including:

[0044] S100, construct BOM view parameter information based on the parent material, child material, version view of the parent material and accuracy information of the parent material corresponding to the material object information, and verify the BOM view parameter information.

[0045] S110, when the verification is passed and the user requires to independently construct a BOM view object, the BOM view object is constructed based on the parent material, the version view of the parent material and the accuracy information of the parent material.

[0046] S120, constructing a BOM view structure based on the BOM view object and the sub-item materials, and carrying the BOM view structure through a multi-branch tree relationship table.

[0047] The front end (or user end, i.e., the software end that directly interacts with the user) obtains the parent material, child material, version view of the parent material, and the precision information of the parent material based on the material object information through the design of unified components, and constructs the BOM view parameter information based on the obtained information. The BOM view parameter information is subjected to parameter non-empty verification, parent material verification, parent material precision information verification, and uniqueness verification of the version view of the parent material. The uniqueness verification of the version view of the parent material is essentially to ensure that the version view of the BOM view structure that the user is currently building is different from the version view of the BOM view structure built previously, thereby ensuring that the version view of the parent material is unique, and thus making the currently built BOM view object different from the previously built BOM view object. A parent material can have multiple different version views, and thus can build multiple different BOM view objects and multiple different BOM view structures. Among them, version views include but are not limited to design views, manufacturing views, engineering views, procurement views, etc.

[0048] After the verification is passed, the verification result will be fed back to the front end through the basic platform interface and business scenario planning, so that users can choose to independently create BOM view objects or insert sub-item materials to build BOM view objects according to their own needs. When the user chooses to independently create a BOM view object, the BOM view object is constructed based on the parent material, the version view of the parent material, and the precision information of the parent material. Among them, the precision information of the parent material is used to indicate whether the constructed BOM view object is an accurate BOM view object or an inaccurate view object. Then, the BOM view structure is constructed based on the BOM view object and sub-item materials, and the multi-tree relationship table (usageLink table, refer to the attached Figure 2 The BOM BieW parent-child relationship in the BOM view structure carries the BOM view structure. After the BOM view structure is built, the information of the BOM view structure is returned by calling the bom or query interface. The front end uses the structure tree general component technology to present the built BOM view structure.

[0049] The embodiment of the present application improves the data accuracy before the BOM view structure is constructed and the rationality of constructing different BOM view objects for the same material by verifying the view parameter information constructed by the parent material, the child material, the version view of the parent material, and the precision information of the parent material. Then, an accurate BOM view object or an inaccurate BOM view object is constructed according to the parent material, the version view of the parent material, and the precision information of the parent material, and an accurate or inaccurate BOM view structure is further constructed, thereby improving the flexibility of the BOM view structure in different industries.

[0050] Reference Figure 3 , which shows a flow chart of inserting sub-item materials to construct a BOM view structure provided by an embodiment of the present application. Figure 3 As shown, including:

[0051] S300, when the verification is passed and the user needs to insert a sub-item material to build a BOM view object, determine whether the BOM view object exists in the BOM view master data table based on the master data identifier of the parent material.

[0052] S310, if it exists, then based on the master data identifier of the parent material and the version view of the parent material, obtain the BOM view object from the BOM view master data table, and build the BOM view structure based on the BOM view object and the sub-item material.

[0053] S320: If it does not exist, construct a BOM view structure based on the BOM view parameter information.

[0054] S330, verifying the hierarchical relationship between the sub-item material and the parent item material in the BOM view structure, and determining that the sub-item material is mounted under the parent item material.

[0055] After the BOM view parameter information is verified, the verification result is fed back to the front end through the basic platform interface and business scenario planning, so that users can choose to create BOM view objects independently or insert sub-item materials to build BOM view objects according to their own needs. When the user chooses to insert sub-item materials to build BOM view objects, the master data identifier (masterId) of the parent material is used to go to the BOM view master data table (bomViewMaster table, refer to the attached Figure 2 In the BOM view in the , check whether there is a BOM view object. If it exists, the BOM view object is obtained from the BOM view master data table based on the master data identifier of the parent material and the version view of the parent material, and then the BOM view structure is constructed based on the BOM view object and the child material.

[0056] If there is no BOM view object in the BOM master data table, the BOM view structure (or BOM view object with structural hierarchy) is constructed based on the parent material, child material, version view of the parent material and the accuracy information of the parent material in the BOM view parameter information. Then the hierarchical relationship between the child material and the parent material in the BOM view structure is verified to ensure that the child material is mounted under the parent material to avoid the situation where the parent material is mounted under the child material.

[0057] When a user proposes a requirement to insert a sub-item material to construct a BOM view object, the embodiment of the present application will first check whether the corresponding BOM view object already exists in the BOM view master data table. If it does, the system will directly use the existing BOM view object and sub-item material to construct the BOM view structure, which can avoid repeated construction and save time and resources. If it does not exist, the system will create a new BOM view object based on the BOM view parameter information and build the BOM view structure. In addition, the system will also verify the hierarchical relationship between the sub-item material and the parent material in the BOM view structure to ensure that the sub-item material is correctly mounted under the parent material, effectively solving the BOM structure hierarchy loop problem, thereby maintaining the accuracy and rationality of the BOM view structure. In addition, since a version view of a parent material corresponds to a BOM view object and a BOM view structure, the management problem of multiple version views of the same parent material is solved.

[0058] Reference Figure 4 , which shows a flow chart of verifying BOM view parameter information provided by an embodiment of the present application, such as Figure 4 Shown include:

[0059] S400, performing non-empty check on the BOM view parameter information.

[0060] S410: Based on the ID of the parent material and the ID of the child material, determine whether the corresponding parent material and child material are stored in the database.

[0061] S420: Based on the ID of the parent material and the ID of the version view of the parent material, verify the uniqueness of the version view of the parent material.

[0062] S430, when both the non-empty check and the uniqueness check are passed, and the parent item material and the child item material are stored in the database, the BOM view parameter check is passed.

[0063] First, perform a non-empty check on each parameter in the BOM view parameter information. If the check is empty, an exception is thrown and a parameter error is prompted. When the BOM view parameter information is not empty, further determine whether the parent material's component entity data and the child material's component entity data are stored in the database based on the parent material's ID (parentOid) and the child material's ID (childOidList). If not, an exception is thrown and a prompt is prompted that the data does not exist. If it exists, the uniqueness of the parent material's version view is verified based on the parent material's ID and the parent material's version view ID. After the verification passes, it proves that the BOM view parameter verification has passed. Then, according to user needs, the BOM view object is constructed by inserting child materials to construct the BOM view object or independently constructing the BOM view object, and the BOM view structure is further constructed.

[0064] In the embodiment of the present application, a non-empty check is performed on the BOM view parameter information to ensure that all necessary parameters are provided, thereby avoiding construction errors caused by lack of key information. Then, by checking the parent material ID and the child material ID, it is confirmed that the corresponding parent material and child material do exist in the database, which helps to prevent the construction failure caused by referencing non-existent materials. In addition, by verifying the ID of the parent material information and the ID of the version view of the parent material, the uniqueness of the version view is ensured to avoid problems caused by version conflicts. At the same time, a management mode in which one BOM view object corresponds to one BOM view structure is formed. The upper parent does not use material bearing, so that the parent material is decoupled from the BOM view structure, solving the problem of maintenance complexity of the BOM view structure due to changes in material attributes. Only when both the non-empty check and the uniqueness check are passed, and the corresponding parent material and child material are indeed stored in the database, the BOM view parameters are verified. This process further improves the data accuracy before the BOM view structure is constructed and the rationality of constructing different BOM view objects with the same material.

[0065] In one embodiment of the present application, it also includes: persisting the BOM view object to a database, and obtaining the major version ID of the BOM view object and the major version ID of the parent material; establishing a BOM view connection relationship based on the major version ID of the BOM view object and the major version ID of the parent material.

[0066] Based on the platform's persistent behavior, the BOM view object can be persisted to the database, and the major version ID of the BOM view object and the major version ID of the parent material are obtained, and the BOM view connection relationship is constructed (refer to the attached Figure 2 The relationship between the component and the BOM view version in the view makes it easier to indirectly obtain the information of the parent material.

[0067] In one embodiment of the present application, the BOM view structure is carried through a multi-tree relationship table, specifically including: carrying the BOM view object through the first parameter in the multi-tree relationship table; carrying the information of the sub-item material through the second parameter in the multi-tree relationship table.

[0068] By constructing a multi-tree relationship table, the first parameter roleA in the multi-tree relationship table is used to carry the BOM view object, and the second parameter roleB carries the information of the sub-item material. The BOM view structure is carried by the multi-tree relationship table, and the BOM view structure attributes are maintained (refer to the attached Figure 2 The BOM structure position number and other attributes in the material are solved so that users can build BOM view structures with different views without relying on the status of the material itself.

[0069] Furthermore, the BOM view structure includes an accurate BOM view structure and an inaccurate BOM view structure. The business scenarios of accurate BOM view structure and inaccurate BOM view structure are solved by using the precision information of the child item and parent item in the multi-tree relationship table. When the BOM view structure is an accurate BOM view structure, the fixed major version ID of the child item is added (refer to the attached Figure 2 The child_item_id in the BOM view structure is stored in the child material attribute in the multi-tree relationship table. After the BOM view structure is upgraded, it is convenient to trace the BOM view structure information of the historical version. When the BOM view structure is an inaccurate BOM view structure, the latest major version and the latest minor version of the corresponding child material in the latest version of the BOM view structure information are obtained in real time.

[0070] Reference Figure 5 , which shows a flow chart of loading a BOM view structure provided by an embodiment of the present application. Figure 5 As shown, including:

[0071] S500, loading and displaying the BOM view structure based on the parent material, the version view of the parent material, the database recursive function and the asynchronous mode;

[0072] S510, based on the master data identifier of the sub-item material, load the information of the BOM view structure of the current version;

[0073] S520, based on the branch identifier of the sub-item material, load the information of the fixed version of the BOM view structure.

[0074] The front end loads the BOM view structure information based on the parent material and the version view of the parent material, and solves the performance problem when loading the BOM view structure through database recursive functions and asynchronous methods (or asynchronous queries).

[0075] By constructing a database recursive function, the sub-item materials in the BOM view structure are quickly queried first, that is, through the recursive multi-branch tree relationship table of the parent material, the sub-item materials of each layer are obtained, thereby reducing the number of database access times.

[0076] Using an asynchronous method, BOM view structure attributes, BOM view information, and material attributes are collected in batches and converted into RowData and stored in the front-end cache, thereby alleviating query performance issues.

[0077] For the loading of sub-item materials of inaccurate BOM view structure, the information of the latest version of BOM view structure is obtained in batches through the master data identifier (masterId) of the sub-item materials, and the RowData is converted and returned to the front-end cache.

[0078] For loading of sub-item materials of precise BOM view structure, by querying the multi-tree relationship table, the fixed version information is found based on the branch identifier (branchId) of the sub-item material, and the fixed version of the BOM view structure information is loaded.

[0079] The BOM view structure management tab on the front end uses left and right distribution controls, and the front end uses virtual scroll loading controls to solve the technical problem of BOM structure large data volume expansion jamming. The final BOM view structure displayed on the front end can refer to the attached Fig.10 .

[0080] Reference Figure 6 , which shows a model diagram of a BOM view structure provided in an embodiment of the present application.

[0081] like Figure 6 As shown, including:

[0082] EtPartBomViewMaster BOM view master object, used to store different BOM view master objects generated based on the parent material.

[0083] EtPartBomView BOM view version object (or BOM view object) is used to store the BOM view version management information corresponding to the BOM view main object. The BOM view version object is used to build the BOM view structure, and the precision information (isPrecise) of the parent material is used to distinguish between precise BOM view structure or imprecise BOM view structure management.

[0084] EtPartBomViewLink is used to store the relationship between the material version object and the BOM view version object. The specific BOM view version object information can be obtained through the parent material. Anyway, the parent material information can be found through the BOM view version object.

[0085] EtPartUsageLink is used to carry the structural relationship between the BOM view object (parent item) and the material object (child item).

[0086] BOM structural relationship: the parent item is managed by BOM view object. Different BOM views carry different sub-items, forming a management mode in which one BOM view object corresponds to one BOM view structure. The upper-level parent item does not use material carrier, so that the parent item material is decoupled from the BOM view structure, solving the maintenance complexity of the BOM view structure caused by changes in material attributes.

[0087] Reference Figure 7 , which shows a schematic diagram of the interface of a BOM view object provided by an embodiment of the present application. Figure 7 As shown, including:

[0088] Interfaces implemented by ItemRevision: Inherits Element to implement behavioral interfaces such as version control, template management, view version management, category management, baseline management, folders, and security levels.

[0089] Reference Figure 8 , which shows a schematic diagram of the interface of a BOM view object provided by an embodiment of the present application. Figure 8 As shown, including:

[0090] The ItemMaster abstract class inherits the AbstractTypeMaster abstract class, handles attributes such as organization and confidentiality level, and implements the Nameable interface to handle coding information. The BOM view master object and the material master object form a many-to-one relationship, that is, one material can maintain multiple view objects.

[0091] Reference Fig. 9 , which shows a schematic diagram of the interface of a BOM view object provided by an embodiment of the present application. Fig. 9 As shown, including:

[0092] The EtPartUsageLink structural relationship table inherits the ETIteratedUsageLink structural relationship of the platform. AbstractPersistableLink is the parent class of the link abstract class, which includes roleARef and roleBRef. roleARef carries the BOM view object, roleBRef carries the material Master object, and extends childItemRef to carry the precise BOM material version or BOM view object. id_Key is used to distinguish the types.

[0093] In one embodiment of the present application, refer to the attached Fig.11 The BOM view structure has a parent-child relationship, including top-level parent items, middle-level parent items, child items, and leaf nodes. The parent item uses the BOM view object, and the child item is carried by the BOM view or material object. An association relationship is established between the two to form a BOM view structure, which carries unique attributes such as BOM structure unit, position number, serial number, quantity, etc.

[0094] An embodiment of the present application also provides a BOM view structure construction system for executing the method or means of any of the above embodiments, including: a construction module, configured to construct BOM view parameter information based on the parent material, child material, version view of the parent material and precision information of the parent material corresponding to the material object information; a verification module, configured to verify the BOM view parameter information; the construction module is also configured to construct a BOM view object based on the parent material, version view of the parent material and precision information of the parent material when the verification passes and the user requires to independently construct the BOM view object; the construction module is also configured to construct a BOM view structure based on the BOM view object and child material, and carry the BOM view structure through a multi-tree relationship table.

[0095] In one embodiment of the present application, it also includes: a query module, which is configured to determine whether there is a BOM view object in the BOM view master data table based on the master data identifier of the parent material when the verification is passed and the user needs to insert the sub-item material to build a BOM view object; if it exists, the construction module is configured to obtain the BOM view object from the BOM view master data table based on the master data identifier of the parent material and the version view of the parent material, and build a BOM view structure based on the BOM view object and the sub-item material; if it does not exist, the construction module is configured to build a BOM view structure based on the BOM view parameter information; the hierarchical relationship between the sub-item material and the parent material in the BOM view structure is verified to determine that the sub-item material is mounted under the parent material.

[0096] An embodiment of the present application also provides a computer-readable storage medium having a computer program stored thereon. When the computer program is executed by a processor, the steps of the method for constructing a BOM view structure described in the above embodiment are implemented.

[0097] It should be noted that the above embodiments can be freely combined as needed. The above are only preferred embodiments of the present invention. It should be pointed out that for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principle of the present invention, and these improvements and modifications should also be regarded as the protection scope of the present invention.

Claims

1. A method for constructing a BOM view structure, characterized in that: include: Based on the parent material, child material, version view of the parent material and accuracy information of the parent material corresponding to the material object information, construct BOM view parameter information, and verify the BOM view parameter information; When the verification is passed and the user requires to independently construct a BOM view object, the BOM view object is constructed based on the parent material, the version view of the parent material and the accuracy information of the parent material; A BOM view structure is constructed based on the BOM view object and the sub-item material, and the BOM view structure is carried through a multi-branch tree relationship table.

2. The method for constructing a BOM view structure according to claim 1, characterized in that: Also includes: When the verification is passed and the user needs to insert the sub-item material to construct the BOM view object, determine whether the BOM view object exists in the BOM view master data table based on the master data identifier of the parent item material; If it exists, then based on the master data identifier of the parent material and the version view of the parent material, the BOM view object is obtained from the BOM view master data table, and the BOM view structure is constructed based on the BOM view object and the child material; If it does not exist, construct the BOM view structure based on the BOM view parameter information; The hierarchical relationship between the sub-item material and the parent item material in the BOM view structure is verified to determine that the sub-item material is mounted under the parent item material.

3. The method for constructing a BOM view structure according to claim 1, characterized in that: The verifying of the BOM view parameter information specifically includes: Performing a non-empty check on the BOM view parameter information; Based on the ID of the parent item and the ID of the child item, determining whether the corresponding parent item and the child item are stored in the database; Based on the ID of the parent item material and the ID of the version view of the parent item material, verify the uniqueness of the version view of the parent item material; When both the non-empty check and the uniqueness check are passed, and the parent item material and the child item material are stored in the database, the BOM view parameter check is passed.

4. The method for constructing a BOM view structure according to claim 3, characterized in that: The method of carrying the BOM view structure through a multi-tree relationship table specifically includes: Carrying the BOM view object through the first parameter in the multi-tree relationship table; The information of the sub-item material is carried by the second parameter in the multi-tree relationship table.

5. The method for constructing a BOM view structure according to claim 1, characterized in that: Also includes: The BOM view object can be persisted to the database, and the major version ID of the BOM view object and the major version ID of the parent material are obtained; A BOM view connection relationship is established based on the major version ID of the BOM view object and the major version ID of the parent material.

6. The method for constructing a BOM view structure according to any one of claims 1 to 5, characterized in that: The BOM view structure includes an accurate BOM view structure and an inaccurate BOM view structure, and further includes: When the BOM view structure is a precise BOM view structure, the major version ID of the sub-item material is configured to be stored in the sub-item material attribute in the multi-tree relationship table; When the BOM view structure is an imprecise BOM view structure, the object of the current minor version of the sub-item material in the current version of the BOM view structure is obtained in real time.

7. The method for constructing a BOM view structure according to any one of claims 1 to 5, characterized in that: Also includes: Loading and displaying the BOM view structure based on the parent material, the version view of the parent material, a database recursive function, and asynchronously; Based on the master data identifier of the sub-item material, load the information of the BOM view structure of the current version; Based on the branch identifier of the sub-item material, load the information of the fixed version of the BOM view structure.

8. A BOM view structure construction system, characterized in that: include: A construction module is configured to construct BOM view parameter information based on the parent material, the child material, the version view of the parent material, and the accuracy information of the parent material corresponding to the material object information; A verification module, configured to verify the BOM view parameter information; The construction module is further configured to construct the BOM view object based on the parent material, the version view of the parent material and the accuracy information of the parent material when the verification is passed and the user requirement is to independently construct the BOM view object; The construction module is further configured to construct a BOM view structure based on the BOM view object and the sub-item material, and carry the BOM view structure through a multi-branch tree relationship table.

9. The BOM view structure construction system according to claim 8, characterized in that: Also includes: A query module is configured to determine whether the BOM view object exists in the BOM view master data table based on the master data identifier of the parent item material when the verification is passed and the user requirement is to insert the sub-item material to build the BOM view object; If so, the construction module is configured to obtain the BOM view object from the BOM view master data table based on the master data identifier of the parent material and the version view of the parent material, and to construct the BOM view structure based on the BOM view object and the child material; If not, the construction module is configured to construct the BOM view structure based on the BOM view parameter information; The hierarchical relationship between the sub-item material and the parent item material in the BOM view structure is verified to determine that the sub-item material is mounted under the parent item material.

10. A computer storage medium, characterized in that: A computer program is stored thereon, and when the computer program is executed by a processor, the steps of the method for constructing a BOM view structure described in any one of claims 1 to 7 are implemented.

Images