Construction method, system and computer storage medium of bom view structure

Abstract

The application relates to the technical field of product structure management, and relates to a BOM view structure construction method and system and a computer storage medium. The method comprises the following steps: constructing BOM view parameter information based on parent item materials, child item materials, version views of the parent item materials and precision information of the parent item materials corresponding to material object information, and verifying the BOM view parameter information; when the verification is passed and the user demand is to independently construct a BOM view object, constructing the BOM view object based on the parent item materials, the version views of the parent item materials and the precision information of the parent item materials; constructing a BOM view structure based on the BOM view object and the child item materials, and carrying the BOM view structure through a multi-way tree relationship table. According to the method, accurate BOM view objects or non-accurate BOM view objects are constructed based on the parent item materials, the version views of the parent item materials and the precision information of the parent item materials, and accurate or non-accurate BOM view structures are further constructed, so that the flexibility of the BOM view structure in application in different industries is improved.

Description

TECHNICAL FIELD

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

[0002] The management of product structure (BOM) is crucial to ensuring the accuracy and consistency of product information. However, there are significant differences in the requirements of BOM view structure in different industries, which requires the BOM view structure to be flexible to adapt to changing management scenarios. Traditional BOM view structure does not distinguish between accurate BOM and inaccurate BOM, which reduces the flexibility of BOM view structure in different industries. SUMMARY

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

[0004] In a first aspect, the present application provides a BOM view structure construction method, comprising: constructing BOM view parameter information based on parent item material, child item material, version view of the parent item material and precision information of the parent item material corresponding to the material object information, and verifying the BOM view parameter information; when the verification is passed and the user demand is 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; constructing a BOM view structure based on the BOM view object and the child item material, and carrying the BOM view structure through a multi-ary tree relationship table.

[0005] The above BOM view structure construction method verifies the view parameter information constructed based on the parent item material, the child item material, the version view of the parent item material and the precision information of the parent item material, improves the data accuracy before constructing the BOM view structure and the rationality of constructing different BOM view objects for the same material. Then, accurate BOM view objects or inaccurate BOM view objects are constructed according to the parent item material, the version view of the parent item material and the precision information of the parent item material, and accurate or inaccurate BOM view structures are further constructed, which improves the flexibility of BOM view structure in different industries.

[0006] In one implementation, the method further comprises: when the check passes and the user demand is to insert the sub-item material to build the BOM view object, determining whether the BOM view object exists in a BOM view master data table based on the master data identifier of the parent item material; if the BOM view object exists, obtaining the BOM view object from the BOM view master data table based on the master data identifier of the parent item material and the version view of the parent item material, and building the BOM view structure based on the BOM view object and the sub-item material; if the BOM view object does not exist, building the BOM view structure based on the BOM view parameter information; and checking the hierarchical relationship between the sub-item material and the parent item material in the BOM view structure to determine that the sub-item material is mounted under the parent item material.

[0007] The above method for building a BOM view structure, when a user proposes a demand to insert a sub-item material to build a BOM view object, first checks whether a corresponding BOM view object already exists in a BOM view master data table. If the BOM view object exists, the system directly builds a BOM view structure using the existing BOM view object and the sub-item material, which avoids repeated construction and saves time and resources. If the BOM view object does not exist, the system builds a new BOM view object according to BOM view parameter information and builds a BOM view structure. In addition, the system checks the hierarchical relationship between the sub-item material and the parent item material in the BOM view structure to ensure that the sub-item material is correctly mounted under the parent item material, effectively solving the problem of BOM structure hierarchical circularity, thereby maintaining the accuracy and reasonableness of the BOM view structure. Moreover, since a version view of a parent item material corresponds to a BOM view object and a BOM view structure, the problem of managing multiple version views of the same parent item material is solved.

[0008] In one implementation, the checking of the BOM view parameter information specifically comprises:

[0009] non-empty checking of the BOM view parameter information; determining whether the corresponding parent item material and sub-item material are stored in a database based on the ID of the parent item material and the ID of the sub-item material; checking the uniqueness of the version view of the parent item material based on the ID of the parent item material and the ID of the version view of the parent item material; and when the non-empty checking and the uniqueness checking both pass and the parent item material and the sub-item material are stored in the database, the BOM view parameter checking passes.

[0010] The construction method of the above BOM view structure performs non-empty verification on the BOM view parameter information, ensures that all necessary parameters have been provided, and avoids construction errors caused by missing 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 indeed exist in the database, which helps to prevent 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, problems caused by version conflicts are avoided, and a management mode of one BOM view object corresponding to one BOM view structure is formed. The upper parent does not use material carrying, so that the parent material and the BOM view structure are decoupled, and the problem of maintenance complexity caused by changes in material attributes of the BOM view structure is solved. Only when the non-empty verification and the uniqueness verification are passed, and the corresponding parent material and child material are indeed stored in the database, the BOM view parameter is verified and passed, which further improves the data accuracy before the construction of the BOM view structure and the rationality of constructing different BOM view objects for the same material.

[0011] In one implementation, the BOM view structure is carried by the multi-way tree relationship table, specifically including: the BOM view object is carried by a first parameter in the multi-way tree relationship table; and information of the child material is carried by a second parameter in the multi-way tree relationship table.

[0012] In one implementation, further including: persisting the BOM view object to a database, and obtaining a large version ID of the BOM view object and a large version ID of the parent material; and establishing a BOM view connection relationship based on the large version ID of the BOM view object and the large 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 further including: when the BOM view structure is the accurate BOM view structure, a large version ID of the child material is configured to be stored in a child material attribute in the multi-way tree relationship table; and when the BOM view structure is the inaccurate BOM view structure, a current small version object of the child material in the current version of the BOM view structure is obtained in real time.

[0014] In one implementation, further including: loading and displaying the BOM view structure based on the parent material, the version view of the parent material, a database recursive function, and an asynchronous mode; loading information of the current version of the BOM view structure based on a master data identifier of the child material; and loading information of the fixed version of the BOM view structure based on a branch identifier of the child material.

[0015] In a second aspect, the application further provides a BOM view structure construction system, comprising: a construction module configured to construct BOM view parameter information based on parent item material, child item material, version view of the parent item material, and precision information of the parent item material corresponding to material object information; a verification module configured to verify the BOM view parameter information; the construction module is further configured to, when the verification passes and a user demand is to independently construct a BOM view object, construct 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; the construction module is further configured to construct a BOM view structure based on the BOM view object and the child item material, and carry the BOM view structure through a multi-way tree relationship table.

[0016] In an implementation, the system further comprises: a query module configured to, when the verification passes and a user demand is to insert the child item material to construct the BOM view object, determine whether the BOM view object exists in a BOM view master data table based on a master data identifier of the parent item material; if the BOM view object 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 item material and the version view of the parent item material, and construct the BOM view structure based on the BOM view object and the child item material; if the BOM view object does not exist, the construction module is configured to construct the BOM view structure based on the BOM view parameter information; verify a hierarchical relationship between the child item material and the parent item material in the BOM view structure, and determine that the child item material is mounted under the parent item material.

[0017] In a third aspect, the application further provides a computer storage medium having a computer program stored thereon, the computer program being executed by a processor to implement the steps of the BOM view structure construction method of any of the above implementations.

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

[0019] 1. The view parameter information constructed based on the parent item material, the child item material, the version view of the parent item material, and the precision information of the parent item material is verified, thereby improving the data accuracy before the construction of the BOM view structure and the rationality of constructing different BOM view objects for the same material. Then, the accurate BOM view object or the non-accurate 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, and the accurate or non-accurate BOM view structure is further constructed, thereby improving the flexibility of the BOM view structure in application in different industries.

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

[0021] 3、Non-empty check is performed on the BOM view parameter information to ensure that all necessary parameters have been provided, avoiding construction errors caused by missing key information. Then, by checking the parent item material ID and the sub-item material ID, it is confirmed that the corresponding parent item material and sub-item material indeed exist in the database, which helps to prevent construction failure caused by referencing non-existent materials. In addition, by checking the ID of the parent item material information and the ID of the version view of the parent item material, the uniqueness of the version view is ensured, avoiding problems caused by version conflicts, while forming a management mode of one BOM view object corresponding to one BOM view structure. The upper parent item does not use material carrying, so that the parent item material and the BOM view structure are decoupled, solving the problem of maintenance complexity caused by changes in material attributes. Only when the non-empty check and uniqueness check are passed, and the corresponding parent item material and sub-item material are indeed stored in the database, the BOM view parameter is checked and passed, which further improves the data accuracy before the construction of the BOM view structure and the rationality of building different BOM view objects for the same material. BRIEF DESCRIPTION OF DRAWINGS

[0022] The above-mentioned features, technical characteristics, advantages and implementation modes of the present application will be further described in a clear and understandable manner in combination with the preferred embodiments and the accompanying drawings.

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

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

[0025] Figure 3A flow chart of constructing a BOM view structure of an inserted sub-item material is shown according to an embodiment of the present application.

[0026] Figure 4 A flow chart of verifying BOM view parameter information is shown according to an embodiment of the present application.

[0027] Figure 5 A flow chart of loading a BOM view structure is shown according to an embodiment of the present application.

[0028] Figure 6 A model diagram of a BOM view structure is shown according to an embodiment of the present application.

[0029] Figure 7 An interface schematic diagram of a BOM view object is shown according to an embodiment of the present application.

[0030] Figure 8 An interface schematic diagram of a BOM view object is shown according to an embodiment of the present application.

[0031] Figure 9 An interface schematic diagram of a BOM view object is shown according to an embodiment of the present application.

[0032] Figure 10 A front-end schematic diagram of a BOM view structure is shown according to an embodiment of the present application.

[0033] Figure 11 A relationship schematic diagram of a BOM view and a BOM view structure is shown according to an embodiment of the present application. DETAILED DESCRIPTION

[0034] In order to more clearly illustrate the technical solutions of the embodiments of the present application or the prior art, the specific embodiments of the present application will be described below with reference to the drawings. Obviously, the drawings described below are only some of the embodiments of the present application, and those skilled in the art can obtain other drawings and other embodiments according to these drawings without creative labor.

[0035] In order to make the drawing simple, only the parts related to the application are shown in each drawing, which does not represent the actual structure of the product. In addition, in order to make the drawing simple and easy to understand, in some drawings, only one of the parts with the same structure or function is shown schematically, or only one of them is marked. In this paper, "one" not only means "only one", but also means "more than one".

[0036] It should be further understood that the term "and / or" as used in the specification and in the claims, if any, means any one and / or any combination of one or more of the associated listed items can be present.

[0037] In this document, unless otherwise indicated or implied, the terms "mounting", "connected", "connection" should be understood broadly, for example, can be fixed connection, can also be detachable connection, or integrally connected; can be mechanical connection, can also be electrical connection; can be directly connected, can also be indirectly connected through an intermediate medium, can be internal communication of two elements. For those skilled in the art, the specific meaning of the above terms in the present application can be understood according to the specific circumstances.

[0038] In addition, in the description of the present application, the terms "first", "second" and the like are only used for differentiation and 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 is only the preferred embodiment of the present application, and it should be pointed out that for those skilled in the art, without departing from the principles of the present application, a number of improvements and refinements can also be made, which should be considered as the protection scope of the present application.

[0040] The product structure (Bill of Material, BOM) is a core technical tool for describing which components a finished product is composed of and the composition relationship. Taking a mobile phone as an example, it is composed of multiple parts and components, and these components are composed of more parts. In the whole life cycle of the product, different stages and fields need different BOM views to support their business needs. BOM is essentially the description of the relationship between business objects and related information. It not only supports the construction and display of cross-object relationships, but also covers heavy team collaboration, product requirement decomposition and other business scenarios.

[0041] The BOM view structure adopts a tree structure to manage the hierarchical relationship of the product, which contains parent items and child items. The parent item is usually carried by the BOM view object, and the child item can be a BOM view or a specific material. The attributes of the BOM view include coding, name, version and other key information, and the attributes of the BOM view structure cover bit number, serial number, unit, quantity and extension attributes. The BOM view structure can achieve at least one of the following beneficial effects by constructing the BOM view structure based on the related information of the parent material and the related information of the child material after verification: improving the flexibility of the BOM view structure in different industries; or improving the data accuracy before constructing the BOM view structure and the rationality of constructing different BOM view objects for the same material.

[0042] The following is described in conjunction with the accompanying drawings:

[0043] Referring to the accompanying drawings Figure 1 It shows a flowchart of a BOM view structure construction method provided by an embodiment of the present application, as shown in Figure 1 , including:

[0044] S100, based on the parent item material, child item material, version view of the parent item material and precision information of the parent item material corresponding to the material object information, constructing BOM view parameter information, and verifying the BOM view parameter information.

[0045] S110, when the verification is passed and the user requirement is to independently construct a BOM view object, constructing a 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.

[0046] S120, constructing a BOM view structure based on the BOM view object and the child item material, 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 directly interacting with the user) acquires the parent item material, child item material, version view of the parent item material and precision information of the parent item material based on the unified component design method based on the material object information, and constructs BOM view parameter information based on the acquired information. The BOM view parameter information is subjected to parameter non-empty verification, parent item material verification, precision information verification of the parent item material and uniqueness verification of the version view of the parent item material, etc. The uniqueness verification of the version view of the parent item material is essentially to ensure that the version view of the BOM view structure to be constructed by the user at present is different from the version view of the BOM view structure constructed before, thereby ensuring that the version view of the parent item material is unique, and further ensuring that the BOM view object constructed at present is different from the BOM view object constructed before. A parent item material can have multiple different version views, and thus multiple different BOM view objects and multiple different BOM view structures can be constructed. Among them, the version view includes but is not limited to design view, manufacturing view, engineering view, procurement view, etc.

[0048] After the check passes, the check result is fed back to the front end through the basic platform interface and the planning of the business scenario, so as to facilitate the user to select the way of independently creating a BOM view object or the way of inserting a sub-item material to construct a BOM view object according to the user's own needs. When the user selects the way of independently creating a BOM view object, the BOM view object is constructed based on the parent item material, the version view of the parent item material and the precision information of the parent item material. The precision information of the parent item 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 according to the BOM view object and the sub-item material, and the BOM view structure is carried through the multi-branch tree relationship table (usageLink table, refer to the BOM Biew parent-child relationship in the appendix Figure 2 After the BOM view structure is constructed, the information of the BOM view structure is returned by calling the bom or query interface, and the front end presents the constructed BOM view structure by using the structure tree general component technology.

[0049] The embodiment of the present application improves the data accuracy before the construction of the BOM view structure and the rationality of constructing different BOM view objects for the same material by checking the view parameter information constructed based on the parent item material, the sub-item material, the version view of the parent item material and the precision information of the parent item material. Then, the accurate BOM view object or the inaccurate 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, and the accurate or inaccurate BOM view structure is further constructed, thereby improving the flexibility of the BOM view structure in the application in different industries.

[0050] Reference is made to the flow chart of constructing the BOM view structure by inserting the sub-item material, as shown in the appendix Figure 3 . Figure 3 As shown in the figure, it comprises:

[0051] S300, when the check passes and the user's demand is to insert the sub-item material to construct the BOM view object, it is determined whether the BOM view object exists in the BOM view master data table based on the master data identifier of the parent item material.

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

[0053] S320, if the BOM view object does not exist, the BOM view structure is constructed based on the BOM view parameter information.

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

[0055] After the BOM view parameter information is validated, the validation result is fed back to the front end through the basic platform interface and the business scenario plan. This allows users to choose whether to create a BOM view object independently or to construct a BOM view object by inserting sub-items. When the user chooses to construct the BOM view object by inserting sub-items, the BOM view master data table (bomViewMaster table, see appendix) is accessed based on the master data identifier (masterId) of the parent item. Figure 2 The system checks if a BOM view object exists in the BOM view. If it does, it retrieves the BOM view object from the BOM view master data table based on the master data identifier and version view of the parent material. Then, it constructs the BOM view structure based on the BOM view object and the child materials.

[0056] If a BOM view object does not exist in the BOM master data table, a BOM view structure (or a hierarchical BOM view object) is constructed based on the parent material, child material, version view of the parent material, and precision information of the parent material in the BOM view parameter information. Then, the hierarchical relationship between child materials and parent materials in the BOM view structure is validated to ensure that child materials are attached to parent materials and to avoid situations where parent materials are attached to child materials.

[0057] In this embodiment, when a user requests to insert sub-items to construct a BOM view object, the system first checks if a corresponding BOM view object already exists in the BOM view master data table. If it exists, the system directly uses the existing BOM view object and sub-items to construct the BOM view structure, thus avoiding redundant construction and saving time and resources. If it does not exist, the system creates a new BOM view object based on the BOM view parameter information and constructs the BOM view structure. Furthermore, the system validates the hierarchical relationship between sub-items and parent items in the BOM view structure to ensure that sub-items are correctly attached to parent items, effectively solving the problem of BOM structure hierarchy loops and maintaining the accuracy and rationality of the BOM view structure. Moreover, since one version view of a parent item corresponds to one BOM view object and one BOM view structure, the management problem of multiple version views for the same parent item is solved.

[0058] Reference Appendix Figure 4 It illustrates a flowchart of a BOM view parameter information verification method provided in an embodiment of this application, such as... Figure 4 The following are included:

[0059] S400 performs a non-empty check on the BOM view parameter information.

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

[0061] S420, check the uniqueness of the version view of the parent material based on the ID of the parent material and the ID of the version view of the parent material.

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

[0063] First, the non-empty check is performed on each parameter in the BOM view parameter information, and if the check is empty, an exception is thrown and a parameter error is prompted. When the BOM view parameter information is not empty, it is further determined whether the component entity data of the parent material and the component entity data of the child material are stored in the database based on the ID of the parent material (parentOid) and the ID of the child material (childOidList). If not, an exception is thrown and a data does not exist error is prompted. If so, the uniqueness of the version view of the parent material is checked based on the ID of the parent material and the ID of the version view of the parent material. After the check is passed, it is proved that the BOM view parameter check is passed. Then, the BOM view object is constructed in the way of inserting child materials or the way of independently constructing the BOM view object according to user requirements, and the BOM view structure is further constructed.

[0064] In the embodiment of the present application, the non-empty check is performed on the BOM view parameter information to ensure that all necessary parameters have been provided, avoiding construction errors caused by the 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 construction failure caused by referring to 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, avoiding problems caused by version conflicts, and forming a management mode of one BOM view object corresponding to one BOM view structure. The upper parent does not use material carrying, so that the parent material and the BOM view structure are decoupled, solving the problem of maintenance complexity of the BOM view structure caused by material attribute changes. Only when the non-empty check and the uniqueness check are both passed, and the corresponding parent material and child material are indeed stored in the database, the BOM view parameter is checked to be passed, which further improves the data accuracy before the construction of the BOM view structure and the rationality of constructing different BOM view objects from the same material.

[0065] In an embodiment of the present application, the BOM view object is persistently stored in a database, and a major version ID of the BOM view object and a major version ID of a parent item material are obtained; and 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 item material.

[0066] Based on the platform persistency behavior, the BOM view object is persistently stored in a database, and a major version ID of the BOM view object and a major version ID of a parent item material are obtained, and a BOM view connection relationship is constructed (see FIG. 6, which shows a BOM view version relationship of components in the present application). The information of the parent item material is indirectly obtained. Figure 2

[0067] In an embodiment of the present application, the BOM view structure is carried by a multi-way tree relationship table, specifically including: the BOM view object is carried by a first parameter in the multi-way tree relationship table; and information of a child item material is carried by a second parameter in the multi-way tree relationship table.

[0068] The multi-way tree relationship table is constructed, the first parameter roleA in the multi-way tree relationship table carries the BOM view object, and the second parameter roleB carries the information of the child item material. The BOM view structure is carried by the multi-way tree relationship table, and the BOM view structure attributes (see FIG. 7, which shows BOM structure attributes in the present application) are maintained, so that the user can construct different BOM view structures without depending on the state of the material itself. Figure 2

[0069] Further, the BOM view structure includes an accurate BOM view structure and an inaccurate BOM view structure. The business scenarios of the accurate BOM view structure and the inaccurate BOM view structure are solved by the accuracy information of the child item material and the parent item material in the multi-way tree relationship table. When the BOM view structure is the accurate BOM view structure, the fixed major version ID (see FIG. 8, which shows child_item_id in the present application) of the child item material is stored into the child item material attribute in the multi-way tree relationship table. After the BOM view structure is upgraded, the BOM view structure information of the historical version is conveniently traced back. When the BOM view structure is the inaccurate BOM view structure, the object of the latest minor version of the latest major version of the corresponding child item material in the latest version of the BOM view structure information is obtained in real time. Figure 2

[0070] Referring to FIG. 9, which shows a flowchart of loading a BOM view structure provided by an embodiment of the present application, as shown in FIG. 10, the flowchart includes: Figure 5 Figure 5

[0071] S500, loading and displaying the BOM view structure based on the parent item material, the version view of the parent item material, a database recursive function, and an asynchronous mode. ​​​​​

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

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

[0074] The front end loads information of the BOM view structure based on the parent material and the version view of the parent material, solves the performance problem of the BOM view structure loading through a database recursive function and an asynchronous mode (or asynchronous query).

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

[0076] An asynchronous mode is adopted to collect BOM view structure attributes, BOM view information, material attributes in batches and convert RowData, and store them to the cache of the front end, thereby relieving the query performance problem.

[0077] For loading of the sub-item material of the non-accurate BOM view structure, the master data identifier (masterId) of the sub-item material is used to batch acquire information of the latest version of the BOM view structure and convert RowData to return to the cache of the front end.

[0078] For loading of the sub-item material of the accurate BOM view structure, the multi-ary tree relationship table is queried, the branch identifier (branchId) of the sub-item material is used to find fixed version information, and the information of the fixed version of the BOM view structure is loaded.

[0079] The BOM view structure management tab of the front end adopts a left-right distribution control, and the front end adopts a virtual scroll loading control, which can solve the technical problem of lagging in expanding the large amount of BOM structure data, and the BOM view structure finally displayed on the front end can refer to the attached Figure 10 .

[0080] The attached Figure 6 shows a model diagram of the BOM view structure provided by the embodiment of the application.

[0081] As shown in the attached Figure 6 , it includes:

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

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

[0084] EtPartBomViewLink is used to store the relationship between material version objects and BOM view version objects. It can obtain specific BOM view version object information through parent materials, and vice versa, it can find information about parent materials through BOM view version objects.

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

[0086] The BOM structure relationship is such that the parent item is managed using a BOM view object, and different BOM views carry different child 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 carriers, which decouples the parent item material from the BOM view structure and solves the problem of maintenance complexity caused by changes in material attributes in the BOM view structure.

[0087] Reference Appendix Figure 7 This illustrates a schematic diagram of the interface of a BOM view object provided in an embodiment of this application. For example... Figure 7 As shown, it includes:

[0088] The ItemRevision interface inherits from Element and implements behavioral interfaces such as version control, template management, view version management, category management, baseline management, folders, and security levels.

[0089] Reference Appendix Figure 8 This illustrates a schematic diagram of the interface of a BOM view object provided in an embodiment of this application. For example... Figure 8 As shown, it includes:

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

[0091] Reference Appendix Figure 9 This illustrates a schematic diagram of the interface of a BOM view object provided in an embodiment of this application. For example... Figure 9 As shown, it includes:

[0092] The EtPartUsageLink structure relationship table inherits the platform ETIteratedUsageLink structure relationship, AbstractPersistableLink is the parent class of the link abstract class, and includes roleARef and roleBRef. The roleARef carries the BOM view object, the roleBRef carries the material Master main object, the extension childItemRef carries the accurate BOM material major version or the BOM view object, and the id_Key is used for type distinction.

[0093] In an embodiment of the present application, reference is made to the accompanying drawings Figure 11 The BOM view structure has a parent-child item relationship, there are top-level parent items, intermediate-level parent items, child items and leaf nodes, the parent items adopt the BOM view object, the child items are carried by the BOM view or the material object, the association relationship between the two is established, the BOM view structure is formed, and the BOM structure unit, position number, serial number and quantity are carried.

[0094] The embodiment of the present application also provides a BOM view structure construction system for executing the method or means of any one of the above embodiments, which comprises a construction module configured to construct BOM view parameter information based on parent item materials, child item materials, version views of the parent item materials and precision information of the parent item materials corresponding to material object information; a verification module configured to verify the BOM view parameter information; the construction module is further configured to construct a BOM view object based on the parent item materials, the version views of the parent item materials and the precision information of the parent item materials when the verification is passed and the user demand 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 child item materials, and carry the BOM view structure through a multi-way tree relationship table.

[0095] In an embodiment of the present application, the system further comprises a query module configured to determine whether there is a BOM view object in a BOM view master data table based on a master data identifier of the parent item material when the verification is passed and the user demand is to insert the child item material to construct the BOM view object; if there is, 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 item material and the version view of the parent item material, and construct a BOM view structure based on the BOM view object and the child item material; if there is not, the construction module is configured to construct a BOM view structure based on the BOM view parameter information; the hierarchical relationship between the child item material and the parent item material in the BOM view structure is verified to determine that the child item material is mounted under the parent item material.

[0096] The embodiment of the present application further provides a computer readable storage medium, which stores a computer program, and the computer program is executed by a processor to realize the steps of the BOM view structure construction method in the above embodiment.

[0097] It should be noted that the above embodiments can be freely combined according to needs. The above is only the preferred embodiment of the present application, and it should be pointed out that, for those skilled in the art, without departing from the principles of the present application, a number of improvements and refinements can also be made, which should be considered as the protection scope of the present application.

Claims

1. A method for constructing a BOM view structure, characterized in that, The method comprises the following steps: Based on the parent item material, the child item material, the version view of the parent item material and the precision information of the parent item material corresponding to the material object information, a BOM view parameter information is constructed, and the BOM view parameter information is verified; When the verification is passed and the user demand is to independently construct a BOM view object, the BOM view object is constructed based on the parent item material, the version view of the parent item material and the precision information of the parent item material; Based on the BOM view object and the child item material, a BOM view structure is constructed, and the BOM view structure is carried through a multi-way tree relationship table; The precision information of the parent item material is used to indicate that the constructed BOM view object is an accurate BOM view object or an inaccurate BOM view object, and the BOM view structure includes an accurate BOM view structure or an inaccurate BOM view structure.

2. The method of claim 1, wherein, Further comprising: When the verification is passed and the user demand is to insert the child item material to construct the BOM view object, it is determined whether the BOM view object exists in a BOM view master data table based on the master data identifier of the parent item material; 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 item material and the version view of the parent item material, and the BOM view structure is constructed based on the BOM view object and the child item material; If it does not exist, the BOM view structure is constructed based on the BOM view parameter information; The hierarchical relationship between the child item material and the parent item material in the BOM view structure is verified to determine that the child item material is mounted under the parent item material.

3. The method of claim 1, wherein, The verification of the BOM view parameter information specifically includes: Non-empty verification of the BOM view parameter information; Based on the ID of the parent item material and the ID of the child item material, it is determined whether the corresponding parent item material and child item material 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, the uniqueness of the version view of the parent item material is verified; When the non-empty verification and the uniqueness are both verified, and the parent item material and the child item material are stored in the database, the BOM view parameter verification is passed.

4. The method of claim 3, wherein, The BOM view structure is carried through a multi-way tree relationship table, specifically including: The BOM view object is carried through a first parameter in the multi-way tree relationship table; The information of the child item material is carried through a second parameter in the multi-way tree relationship table.

5. The method of claim 1, wherein, Further comprising: The BOM view object can be persisted to the database, and a large version ID of the BOM view object and a large version ID of the parent item material are obtained; Based on the large version ID of the BOM view object and the large version ID of the parent item material, a BOM view connection relationship is established.

6. The method of claim 1-5, wherein, The BOM view structure includes an accurate BOM view structure and an inaccurate BOM view structure, and further comprises: When the BOM view structure is an accurate BOM view structure, the large version ID of the sub-item material is configured to be stored in the sub-item material attribute in the multi-branch tree relationship table; When the BOM view structure is an inaccurate BOM view structure, the object of the current small version of the sub-item material in the current version of the BOM view structure is obtained in real time.

7. The method of claim 1-5, wherein, Further comprising: loading and displaying the BOM view structure based on the parent item material, the version view of the parent item material, the database recursive function, and the asynchronous mode; loading the information of the current version of the BOM view structure based on the master data identifier of the sub-item material; loading the information of the fixed version of the BOM view structure based on the branch identifier of the sub-item material.

8. A system for constructing a BOM view structure, characterized by, Comprising: a construction module configured to construct BOM view parameter information based on the parent item material, the sub-item material, the version view of the parent item material, and the accuracy information of the parent item 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 item material, the version view of the parent item material, and the accuracy information of the parent item material when the verification passes and the user demand 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 to carry the BOM view structure through a multi-branch tree relationship table; the accuracy information of the parent item material is used to indicate that the constructed BOM view object is an accurate BOM view object or an inaccurate BOM view object, and the BOM view structure includes an accurate BOM view structure or an inaccurate BOM view structure.

9. The system for constructing a BOM view structure according to claim 8, wherein, Further comprising: a query module configured to determine whether the BOM view object exists in a BOM view master data table based on the master data identifier of the parent item material when the verification passes and the user demand is to insert the sub-item material to construct 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 item material and the version view of the parent item material, and to construct 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 construct the BOM view structure based on the BOM view parameter information; 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.

10. A computer storage medium, characterized in that A computer program is stored thereon, which is executed by a processor to implement the steps of the construction method of the BOM view structure according to any one of claims 1-7.

Images