Machine tool manufacturing BOM storage query and tree structure construction method based on MES system

Abstract

The invention discloses a machine tool manufacturing BOM storage query and tree structure construction method based on an MES system. The method comprises the steps: constructing a manufacturing BOM storage structure; setting a cache data structure to search part material numbers; setting a BOM reverse query process data structure, and searching part numbers through a coding rule for subsequent manufacturing BOM search; respectively searching for a first-level component manufacturing BOM and a multi-level component manufacturing BOM, removing same-level repeated data and non-same-level repeated data, and searching for the components; searching a machine tool manufacturing BOM directly containing a specific part and a machine tool manufacturing BOM containing a group part, removing the same-level repeated data, removing the non-same-level repeated data, and searching to obtain machine tool manufacturing BOM data; according to the method, building a tree structure according to machine tool manufacturing BOM data, providing a basis for subsequent material updating and correcting on a production site, and achieving BOM reverse checking on the production site; and performing result display on the tree structure through an MES system. According to the invention, the workload is reduced, the query efficiency is improved, fast storage, fast taking and fast updating are achieved, and the query speed is increased.

Description

technical field [0001] The invention belongs to the technical field of mechanical manufacturing, and in particular relates to a BOM storage query and tree structure construction method for machine tool manufacturing based on an MES system. Background technique [0002] A machine tool is assembled from component materials and part materials. A machine tool contains multiple components and parts of the same group, and the components and parts of the same group may be at different levels of the machine tool manufacturing BOM. The composition of a component is similar to that of a machine tool. A component is assembled from component materials and part materials. There is a component that contains multiple identical components and parts, and the same component and part may be at different levels of the component manufacturing BOM. Such as figure 1 The medium machine tool contains two parts B in the group, and the two group parts B are in level 1 and level 3 respectively. The m...

AI Technical Summary

Problems solved by technology

[0004] The existing BOM back-check method requires manual iterative query of a large number of electronic document manufacturing BOM data, eliminating duplicate data in the same iteration, and outputting a preliminary manufacturing BOM list; Level manufacturing BOM; finally output manufacturing BOM data in list format, or import MES system for display, or manually make an inverted tree structure display and update; it is inconvenient to use in manufacturing BOM search

The iterative query work is repetitive and cumbersome; the work of manually removing duplicate data is complicated and time-consuming; the list display effect is not good, and the composition relationship between the manufacturing BOM cannot be visually displayed, or the composition relationship is manually sorted out, the workload is heavy, and errors are prone to occur. Due to the large number of manufacturing BOMs, manual search is very easy to cause omissions, which affects the progress of manufacturing BOM upgrades and has a negative impact on production

Images