CN117556029A - Cutter BOM generation method, device and equipment and computer readable storage medium - Google Patents

Cutter BOM generation method, device and equipment and computer readable storage medium Download PDF

Info

Publication number
CN117556029A
CN117556029A CN202311413513.0A CN202311413513A CN117556029A CN 117556029 A CN117556029 A CN 117556029A CN 202311413513 A CN202311413513 A CN 202311413513A CN 117556029 A CN117556029 A CN 117556029A
Authority
CN
China
Prior art keywords
cutter
information
tool
name
preset
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202311413513.0A
Other languages
Chinese (zh)
Inventor
陈学毅
宣建海
居战鳌
孙袁
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Hangzhou Allied Precision Machinery Co ltd
Original Assignee
Hangzhou Allied Precision Machinery Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Hangzhou Allied Precision Machinery Co ltd filed Critical Hangzhou Allied Precision Machinery Co ltd
Priority to CN202311413513.0A priority Critical patent/CN117556029A/en
Publication of CN117556029A publication Critical patent/CN117556029A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/30Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
    • G06F16/33Querying
    • G06F16/335Filtering based on additional data, e.g. user or group profiles
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/30Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
    • G06F16/33Querying
    • G06F16/332Query formulation
    • G06F16/3322Query formulation using system suggestions
    • G06F16/3323Query formulation using system suggestions using document space presentation or visualization, e.g. category, hierarchy or range presentation and selection
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/30Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
    • G06F16/33Querying
    • G06F16/3331Query processing
    • G06F16/3332Query translation
    • G06F16/3334Selection or weighting of terms from queries, including natural language queries
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/30Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
    • G06F16/35Clustering; Classification
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30Computing systems specially adapted for manufacturing

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Artificial Intelligence (AREA)
  • Mathematical Physics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The application relates to a cutter BOM generation method, device and equipment and a computer readable storage medium, belonging to the technical field of data processing, wherein the method comprises the following steps: reading information of a tool loading operation instruction book; determining query information of each cutter according to the cutter loading operation instruction information; the query information includes a cutter type and at least one keyword; and searching cutter information in a BOM library according to the cutter type and at least one keyword of each cutter, and generating a cutter loading cutter BOM list according to the cutter information of each cutter. The method has the effect of improving the efficiency of manufacturing the BOM list of the cutter loading tool.

Description

Cutter BOM generation method, device and equipment and computer readable storage medium
Technical Field
The present disclosure relates to the field of data processing technologies, and in particular, to a method, an apparatus, a device, and a readable storage medium for generating a tool BOM.
Background
With the rapid development of manufacturing industry, digital management has become an important means for improving production efficiency and quality.
The tool loading operation instruction is used as an important file in the manufacturing process, contains information such as selection, configuration and use of tools, and has important significance for ensuring smooth processing of the processing process.
Currently, in order to implement digital management, the accessory information of the tool is recorded in the SAP system according to a hierarchical relationship, and a tool BOM list is required to be used for searching corresponding information in the SAP system. The information in the tool BOM list needs to search the tool BOM in the BOM library by using the related information of the tools in the tool loading operation instruction book, and finally, the tool BOMs of all the related tools in the tool loading operation instruction book are summarized and arranged into the tool loading BOM list.
However, the information of the BOM library has a lot of information content of the tools, the current generation mode of the tool loading BOM list still depends on manual identification pictures and comments, when the tool BOM information of a certain tool is required to be queried, the full text searching is needed to be performed by manually confirming keywords, manual judgment is performed, and the unique tool information is manually searched in the BOM library, so that the problems of low speed, low efficiency, high error rate and the like exist.
Disclosure of Invention
In order to improve the efficiency of creating a tool-in-tool BOM list, the application provides a tool BOM generation method, a tool-in-tool BOM generation device, tool-in-tool BOM generation equipment and a computer readable storage medium.
In a first aspect, the present application provides a method for generating a tool BOM, which adopts the following technical scheme:
a tool BOM generation method, comprising:
Reading information of a tool loading operation instruction book;
determining query information of each cutter according to the cutter loading operation instruction information; the query information includes a cutter type and at least one keyword;
inquiring cutter information in a BOM library according to the cutter type and at least one keyword of each cutter, and generating a cutter loading cutter BOM list according to the cutter information of each cutter.
By adopting the technical scheme, the query information of each cutter can be rapidly determined by reading the cutter loading operation instruction information, the query time of the cutter type and the keywords in the BOM library is reduced according to the query information, the manual operation and the errors are reduced, the automatic generation of the BOM list is realized, and the working efficiency is improved.
Optionally, the BOM library is classified according to cutter types, each cutter type is classified according to a preset hierarchy, and querying cutter information in the BOM library according to at least one keyword of each cutter and a search hierarchy corresponding to the keywords one by one includes:
for any query information, determining a target query form and a query program of the BOM library according to the cutter type of the cutter;
determining search level information and search keyword information of each level of the cutter under the cutter type according to the query program and at least one keyword;
Inquiring cutter information in the target inquiry form according to the search level and the search keywords until the cutter information of each cutter is inquired.
By adopting the technical scheme, the BOM library is classified according to the cutter type and the preset level, so that the query range is reduced, the query time is shortened, and the query efficiency is improved; by determining the search level and the search keyword information according to the query program and the keywords, the target cutter information is more accurately positioned, the conditions of query errors and omission are reduced, and the accuracy of the query result is improved. By setting the search levels corresponding to the keywords one by one, the search levels and the keywords can be flexibly adjusted according to different query requirements, and different query requirements can be met.
Optionally, the search level information includes a first search level; the search keyword information comprises a first search keyword, and the first search keyword comprises a cutter name;
the step of searching the cutter information in the target inquiry form according to the search level information and the search keyword information comprises the following steps:
judging whether the name column of the target lookup table has the same content as the cutter name according to the cutter name;
If the content same as the cutter name exists, obtaining target inquiry sub-information, and continuously inquiring cutter information in the target inquiry sub-information according to the search level after the first search level and the corresponding search keyword;
if the content which is the same as the cutter name does not exist, acquiring a preset cutter name list according to the cutter type;
calculating a first coincidence of the cutter name and a preset cutter name in the preset cutter name list;
determining a preset cutter name of the cutter according to the first contact ratio;
inquiring in a name column of the target inquiry form according to the preset cutter name to obtain target inquiry sub-information, and continuing to inquire cutter information in the target inquiry sub-information according to the search level after the first search level and the corresponding search keyword.
By adopting the technical scheme, the cutter information is inquired according to the search level and the search keyword, when the search level is the first search level, and the first search keyword corresponding to the first search level is the cutter name, if the content of the name column of the target inquiry form identical to the completion of the cutter name exists, the direct search is performed, if the content of the name column of the target inquiry form identical to the completion of the cutter name does not exist, the inquiry is not illustrated, the cutter name in the inquiry information is possibly wrongly illustrated, the first search keyword is required to be corrected, the first coincidence degree of the cutter name and the preset cutter name is calculated according to the preset cutter name list, the preset cutter name of the cutter is determined according to the first coincidence degree, the target cutter information can be rapidly positioned, the time and the inquiry time for manually determining the wrong cutter name are reduced, and the inquiry efficiency is improved.
Optionally, the determining the preset tool name of the tool according to the first contact ratio includes:
sequencing the preset cutter names according to the sequence of the first overlap ratio from high to low to obtain the preset cutter name with the highest first overlap ratio;
judging whether at least two preset cutter names with the highest first overlap ratio exist or not;
if at least two preset cutter names with the highest first coincidence degree exist, respectively acquiring at least one target query sub-information behind the level corresponding to the preset cutter names according to the preset cutter names with the highest first coincidence degree;
determining a preset cutter name according to the keywords corresponding to the levels behind the first search level of the cutter and at least one piece of target inquiry sub-information;
if a preset cutter name with the highest first contact ratio exists, determining the preset cutter name of the cutter as the preset cutter name with the highest first contact ratio.
By adopting the technical scheme, the preset cutter names are ordered according to the first overlap ratio, and the preset cutter name with the highest first overlap ratio is selected as the preset cutter name of the cutter, so that the target cutter information can be more accurately determined, the query error is reduced, and the accuracy of the query result is improved; if at least two preset cutter names with the highest first coincidence degrees exist, at least one target query sub-information behind the level corresponding to the preset cutter names is also obtained, the preset cutter names are determined according to the search keywords corresponding to the level behind the first search level of the cutter and at least one target query sub-information, the condition that query fails due to errors of single preset cutter names is avoided, and the accuracy of query is improved.
Optionally, if the information completely matched with the search keyword is not queried in the corresponding target query sub-information according to the search level and the corresponding search keyword, determining that the cutter information is not queried in the BOM library, and displaying error information according to the search level so as to remind a user to modify and query the cutter corresponding to the error information; the error information comprises a cutter number for searching errors and a search keyword corresponding to the error reporting search level of the cutter.
By adopting the technical scheme, the user is reminded of modifying or inquiring the wrong cutter by providing detailed error information, and the error information comprises the cutter number for searching the error and the keywords corresponding to the searching level, so that the user can be helped to more quickly locate the error reason, and the corresponding modification or inquiry is carried out, so that the reliability of inquiry is improved.
Optionally, the generating a tool-in-tool BOM list according to the tool information of each tool includes:
generating a BOM list of the cutter loading tools according to the query sequence;
if the condition of inquiring the cutter information according to the preset cutter name exists, highlighting the cutter information corresponding to the cutter loading cutter BOM list;
Generating a first shortcut entry which can be linked to a position corresponding to the tool loading operation instruction book information at a first editing position of the tool information;
and generating a second shortcut entry which can be linked to a position corresponding to the BOM library at a second editing position of the cutter information.
By adopting the technical scheme, for the situation that the cutter information is queried according to the preset cutter name, the corresponding cutter information is highlighted, and a user is reminded of paying attention to the special situations; and generating a first shortcut entry which can be linked to a position corresponding to the tool loading operation instruction information at a first editing position of the tool information, and generating a second shortcut entry which can be linked to a position corresponding to the BOM library at a second editing position of the tool information, so that a user can conveniently and rapidly position and edit related information, and the operation convenience is improved.
In a second aspect, the present application provides a tool BOM generating device, which adopts the following technical scheme:
a tool BOM generating device comprising:
the reading module is used for reading the information of the tool-setting operation instruction book;
the determining module is used for determining each cutter query information according to the cutter loading operation instruction information; the query information includes a cutter type and at least one keyword;
And the generating module is used for inquiring cutter information in the BOM library according to the cutter type and at least one keyword of each cutter and generating a cutter loading cutter BOM list according to the cutter information of each cutter.
By adopting the technical scheme, the query information of each cutter can be rapidly determined by reading the cutter loading operation instruction information, the query time of the cutter type and the keywords in the BOM library is reduced according to the query information, the manual operation and the errors are reduced, the automatic generation of the BOM list is realized, and the working efficiency is improved.
In a third aspect, the present application provides an electronic device, which adopts the following technical scheme:
an electronic device comprising a memory and a processor, the memory having stored thereon a computer program capable of being loaded by the processor and performing the tool BOM generation method of any of the first aspects.
By adopting the technical scheme, the processor executes the cutter BOM generation method in the memory, so that the inquiry information of each cutter can be quickly determined by reading the cutter loading operation instruction information, the cutter type and the cutter information corresponding to the keyword inquiry are determined according to the inquiry information, the cutter loading cutter BOM list corresponding to the cutter loading operation instruction information is generated, the cutter type and the keyword are determined according to the inquiry information, the inquiry time in the BOM library is shortened, manual operation and errors are reduced, automatic generation of the BOM list is realized, and the working efficiency is improved.
In a fourth aspect, the present application provides a computer readable storage medium, which adopts the following technical scheme:
a computer-readable storage medium storing a computer program capable of being loaded by a processor and executing the tool BOM generating method according to any one of the first aspects.
By adopting the technical scheme, the processor loads and executes the computer program stored in the computer readable storage medium, the electronic equipment can quickly determine the query information of each cutter by reading the cutter loading operation instruction information, determine the cutter type and the cutter information corresponding to the keyword query according to the query information, generate the cutter loading cutter BOM list corresponding to the cutter loading operation instruction information, determine the cutter type and the keyword according to the query information, reduce the query time in the BOM library, reduce the manual operation and the error, realize automatic generation of the BOM list and improve the working efficiency.
In summary, the present application includes at least one of the following beneficial technical effects:
1. the query information of each cutter can be rapidly determined by reading the cutter loading operation instruction information, the type of the cutter and the key words are determined according to the query information, the query time in the BOM library is shortened, the manual operation and errors are reduced, the automatic generation of the BOM list is realized, and the working efficiency is improved.
2. The query information of each cutter can be rapidly determined by reading the cutter loading operation instruction information, the type of the cutter and the key words are determined according to the query information, the query time in the BOM library is shortened, the manual operation and errors are reduced, the automatic generation of the BOM list is realized, and the working efficiency is improved.
Drawings
Fig. 1 is a flow chart of a tool BOM generating method according to an embodiment of the present application.
Fig. 2 is a schematic flow chart of steps S301 to S303 in the embodiment of the present application.
Fig. 3 is a schematic flow chart of steps S3031 to S3036 in the embodiment of the present application.
Fig. 4 is a block diagram of the cutter BOM generating device according to the embodiment of the present application.
Fig. 5 is a block diagram of an electronic device according to an embodiment of the present application.
Detailed Description
The present application is described in further detail below with reference to the accompanying drawings.
For the purposes of making the objects, technical solutions and advantages of the embodiments of the present application more clear, the technical solutions of the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is apparent that the described embodiments are some embodiments of the present application, but not all embodiments. All other embodiments, which can be made by one of ordinary skill in the art based on the embodiments herein without making any inventive effort, are intended to be within the scope of the present application.
In addition, the term "and/or" herein is merely an association relationship describing an association object, and means that three relationships may exist, for example, a and/or B may mean: a exists alone, A and B exist together, and B exists alone. In this context, unless otherwise specified, the term "/" generally indicates that the associated object is an "or" relationship.
The embodiment of the application provides a cutter BOM generation method, which can be executed by electronic equipment, wherein the electronic equipment can be a server or mobile terminal equipment, and the server can be an independent physical server, a server cluster or a distributed system formed by a plurality of physical servers or a cloud server for providing cloud computing service; the mobile terminal device may be, but is not limited to, a tablet computer, a desktop computer, or the like.
Embodiments of the present application are described in further detail below with reference to the drawings attached hereto. As shown in FIG. 1, the main flow of the method comprises steps S101-S103:
step S101, reading information of a tool-setting operation instruction book;
in the embodiment of the application, the tool loading operation instruction information is tool information, operation rules and the like which are used for loading tools when the tool loading operation instruction information is generated, such as a gear box is matched with the tool loading operation instruction, a numerical control lathe tool loading operation instruction and a drilling machine tool loading operation instruction lamp, and the tool loading operation instruction comprises related information of a plurality of tools. The tool-setting instruction may be obtained by reading a file, from a database, or from a folder.
Step S102, determining query information of each cutter according to the cutter loading operation instruction information; the query information includes a cutter type and at least one keyword;
in the embodiment of the application, first, related information about a cutter included in a tool-setting operation instruction is acquired, the information including a cutter name, a cutter model, length information, accessory information, blade information, and description information, wherein the length information includes a cutter length, a measurement position, an extension length, an effective edge length, the accessory information includes a cutter head model, a main cutter handle, a first handle, a second handle, a third handle, and a fourth handle, and the blade information includes a blade model 1, a blade model 2, and a blade model 3.
And then analyzing the tool loading operation instruction book to determine the tool type and related keywords of each tool contained in the tool loading operation instruction book. The tool loading operation instruction can be in an Execl format or a Word format, and the cell content containing the tool information can be extracted by reading data in an Excel file when the tool loading operation instruction is in the Execl format. An associated library or tool in the programming language can be used to read the Excel file and extract the required data. By locating the cells containing the information of the name, model, specification and the like of the cutter, the query information of the cutter can be obtained.
For the tool loading operation instruction book in Word format, the query information of the tool is extracted through a text extraction technology or a natural language processing technology, and text paragraphs or table data containing the tool information can be positioned and extracted through analyzing the document structure and the text content.
And finally, determining query information of each cutter according to the analysis result, wherein the query information is used for querying corresponding cutter information in the BOM library.
Step S103, inquiring cutter information in a BOM library according to the cutter type and at least one keyword of each cutter, and generating a cutter loading cutter BOM list according to the cutter information of each cutter.
In this embodiment of the present application, the BOM library is classified in advance according to tool types, and each tool type is classified according to a preset hierarchy. The preset levels for different tool types are different, which is determined by the nature of the tool type.
The cutter types comprise a face milling cutter, a rough boring cutter, a finish boring cutter, a U-shaped drill, a common drill bit, an alloy drill, a replaceable drill, an alloy drill, a key slot cutter, a forming chamfer cutter, a common chamfer cutter, a reamer, an integral end milling cutter, a front and back scraper, a gun drill, a drill milling cutter, a screw tap, a three-face blade, an angle cutter, a DJ14 customized cutter, a leaf cutter, a quilting grinding head, a rolling cutter, a straight flute drill, a center drill and the like.
The cutter type is subdivided into a plurality of subtypes, the plurality of subtypes is subdivided into a plurality of nodes, some nodes below the node also comprise child nodes, and some nodes do not comprise child nodes. For example, for a tap of this tool type, the sub-types include a model tap and a no-model tap, and for a model tap, a plurality of nodes are included, the nodes including:
class M, such as: m24×3m24x3 tap, selecting m24×3\standard tap, and Hangzhou sea-day machine;
UN, UNF, UNC, UNEF, such as: 1-7/8-12UN tap selection: 1-7/8-12 UN-2B/American screw tap/Hangzhou sea-day machine;
NPT, NPTF classes, such as: 3/4-16UNF selection: 3/4-16UNF-2 B\English system screw tap\Hangzhou sea-day machine;
g thread taps, such as: g1/2 tap, choose to use: G1/2-14\G Wheatstone cone pipe thread tap\Hangzhou sea-day machine;
g1/4 tap, choose to use: g1/4-yield \pipe thread tap \hangzhou sea-day machine;
RC classes, such as: rc3/8 tap, selecting: rc3/8-19 conical tube thread tap \Hangzhou sea sun machine.
Each node further comprises a plurality of sub-nodes, the sub-nodes can be the accessory information of the main cutter handle, the connecting handle, the extension rod and the like, and the query conditions set by different sub-nodes are different, for example, the number of the accessory information of the BOM library is consistent with the number in the cutter loading operation instruction book, and the cutter loading operation instruction book is queried according to the total length of the cutter, the effective cutter length and the like.
In this embodiment of the present application, specifically, as shown in fig. 2, step S103 includes:
step S301, for any query information, determining a target query form and a query program of the BOM library according to the cutter type of the cutter;
in this embodiment, the query procedure corresponding to different tool types is different, and the query procedure corresponding to different tool types is illustrated below.
For the type of the U-drill tool, firstly inquiring according to the type of the tool bit, when the type of the tool bit is distinguished according to the material of the tool bit, and when the specification information contains steel parts, steel casting U-drill tools and other characters, determining corresponding search keywords, and inquiring according to the search keywords in the accessory information after inquiring.
For the type of the rough boring cutter, judging whether the rough boring cutter is a sliding frame type rough boring cutter or a non-sliding frame type rough boring cutter, if the cutter head and the joint handle are provided with SLXXX-XXX, the cutter is a sliding frame type rough boring cutter, otherwise, the cutter is a non-sliding frame type rough boring cutter; then, judging that the carriage type rough boring cutter is a single-blade rough boring cutter and a normal (double-blade) rough boring cutter; and then, inquiring and the like according to the information such as steel pieces, steel castings and the like in the description information. Or judging that the non-carriage type single-edge rough boring cutter is a non-carriage type single-edge rough boring cutter and a non-carriage type normal rough boring cutter, wherein the non-carriage type single-edge rough boring cutter is a non-carriage type single-edge rough boring cutter: the name is phi xxx single-edge rough boring cutter and phi xxx single-edge boring cutter; normal rough boring cutter with non-carriage: the method comprises the steps of a phi xxx rough boring cutter, a phi xxx step boring cutter, a phi xxx through hole rough boring cutter and a phi xxx through hole boring cutter; and then inquiring according to the accessory information.
For the type of the end mill, judging whether an extension bar exists or not, and selecting calculation, wherein the extension bar is as follows: the specific model is seen from a model column of the extension bar of the rough and fine boring cutter accessory table, the beginning of C3-C8 is regarded as a connecting handle, and the rest is regarded as an extension bar. And calculating the extension length of the cutter, the total length of the cutting tool and the like according to the query information, and querying according to the extension length, the total length of the cutting tool and the like. Cutter with extension bar, extension bar extension value judging condition: the inquiry is carried out by extending the extension bar, extending the connecting handle, extending the connecting rod and the like.
For other tool types, the search conditions of the query program are determined according to the characteristics of different tools, and will not be described here.
Step S302, determining search level information and search keyword information of each level of the cutter under the cutter type according to the query program and at least one keyword;
in the embodiment of the present application, the search level information and the search keyword information of at least one keyword in the query information are determined according to the query program, for example, the query information is: name of the cutter: phi 99.7 rough boring cutter; the main knife handle is BT50-CK7-210; the cutter length is 180; shank one TWN-153 CKB7 (boring head); TW98126E (blade holder); the cutter model 1 is CCMT 12 04 08 UC5115, and the search keyword information of the first search level is determined to be phi 99.7 rough boring cutter according to a query program; the search keywords of the second search level are: a non-carriage type rough boring cutter; keywords of the third search level are: normal rough boring cutter of non-carriage; the search keywords of the fourth search level are corresponding accessory information.
And step S303, inquiring cutter information in the target inquiry form according to the search level and the search keywords until the cutter information of each cutter is inquired.
In the embodiment, the BOM library is classified according to the cutter type and the preset level, so that the query range is reduced, the query time is shortened, and the query efficiency is improved; by determining the search level and the search keyword information according to the query program and the keywords, the target cutter information is more accurately positioned, the conditions of query errors and omission are reduced, and the accuracy of the query result is improved. By setting the search levels corresponding to the keywords one by one, the search levels and the keywords can be flexibly adjusted according to different query requirements, and different query requirements can be met.
In the embodiment of the application, each cutter type is searched for the cutter name first, namely, the search level information comprises a first search level; the search keyword information comprises first search keywords, and the first search keywords corresponding to the first search level are cutter names.
As shown in fig. 3, the searching the tool information in the target query form according to the search hierarchy and the search keyword includes:
step S3031, judging whether the name column of the target lookup table has the same content as the cutter name according to the cutter name;
Step S3032, if the content same as the cutter name exists, obtaining target inquiry sub-information, and continuing to inquire cutter information in the target inquiry sub-information according to the search level after the first search level and the corresponding search keyword;
in the embodiment of the application, since the first search keyword is a complete cutter name, for example, the cutter name is phi 99.7 rough boring cutter, and the first search keyword is phi 99.7 rough boring cutter. If the information is searched in the BOM library according to the first search keyword, the fact that the first search keyword has no error word pattern is indicated, and if the information is not searched in the BOM library according to the first search keyword, the first search keyword has the error word pattern. For example, the cutter name "phi 99.7 rough boring cutter" written by mistake "phi 99.7 out boring cutter" in the tool loading operation instruction causes the search name to be wrong.
Step S3033, if the content which is the same as the cutter name does not exist, a preset cutter name list is obtained according to the cutter type;
in this embodiment, each tool type is provided with a preset tool name list, and the tool names in the preset tool name list are all correct tool names, that is, the preset tool names can be searched in the BOM library.
Step S3034, calculating a first coincidence between the tool name and a preset tool name in the preset tool name list;
step S3035, determining a preset tool name of the tool according to the first contact ratio;
step S3036, query in the name column of the target query form according to the preset tool name to obtain target query sub-information, and continue to query tool information in the target query sub-information according to the search level after the first search level and the corresponding search keyword.
In an embodiment of the present application, a first overlap ratio of the tool name and a preset tool name in a preset tool name list is calculated. The first coincidence degree can be calculated through a character string matching algorithm, a preset cutter name with the highest first coincidence degree is selected, and the determined preset cutter name is used for inquiring in a name column of a target inquiry form to obtain target inquiry sub-information. And then, continuously carrying out layer-by-layer inquiry in the target inquiry sub-information according to the search level after the first search level and the corresponding search keyword so as to acquire more specific cutter information. And the target cutter information is quickly positioned, so that the time for manually determining the wrong cutter name and the query time are reduced, and the query efficiency is improved.
Further, as an embodiment of determining the preset tool name of the tool according to the first overlap ratio, it includes:
firstly, sorting preset cutter names according to the sequence of the first overlap ratio from high to low to obtain the preset cutter name with the highest first overlap ratio;
then judging whether at least two preset cutter names with the highest first coincidence degree exist or not;
if at least two preset cutter names with the highest first coincidence degree exist, respectively acquiring at least one target query sub-information behind the level corresponding to the preset cutter names according to the preset cutter names with the highest first coincidence degree;
determining a preset cutter name according to the search keywords corresponding to the later layers of the first search layer of the cutter and at least one piece of target inquiry sub-information;
if a preset cutter name with the highest first contact ratio exists, determining the preset cutter name of the cutter as the preset cutter name with the highest first contact ratio.
In this embodiment of the present application, when there are two or more identical highest first coincidence degrees, further determining according to information of a next level of preset tool names corresponding to the highest first coincidence degrees, and if there is information identical to the corresponding search keyword in the information of the next level, determining the corresponding preset tool name.
As an optional implementation manner of the embodiment of the present application, after continuing to query the tool information in the target query sub-information according to the search level after the first search level and the corresponding search keyword, the method further includes:
if the information which is completely matched with the search keyword is not queried in the corresponding target query sub-information according to the search level and the corresponding search keyword, determining that the cutter information is not queried in the BOM library, and indicating that the error condition of the search keyword still exists. Displaying error information according to the search level to remind a user to modify and inquire cutters corresponding to the error information; the error information comprises a cutter number for searching errors and a search keyword corresponding to the error reporting search level of the cutter.
By providing detailed error information, the user is reminded of modifying or inquiring the wrong cutter, the error information comprises the cutter number of the search error and keywords corresponding to the search level, the user can be helped to locate the error reason more quickly, corresponding modification or inquiry is carried out, and the reliability of inquiry is improved.
As another optional implementation manner of the embodiment of the present application, after continuing to query the tool information in the target query sub-information according to the search level and the corresponding search keyword after the first search level, the method further includes:
If the information which is completely matched with the search keyword is not queried in the corresponding target query sub-information according to the search level and the corresponding search keyword, determining the corresponding search keyword and the target query sub-information in the BOM library according to the search level; the target query sub-information comprises a plurality of query content sets under the search level;
respectively calculating at least one second degree of coincidence of the search keywords corresponding to the search level and query content in the query content set;
summing the second coincidence degrees of the query content sets to determine a coincidence degree total value;
recommending and inquiring cutter information corresponding to the content set according to the total coincidence degree value so as to be selected by a user.
In this embodiment of the present application, one search keyword may correspond to a plurality of related query contents, so the query contents are organized into a query content set, at least one second degree of coincidence between the search keyword and the query content set is calculated, and tool information of the tool is recommended to the user through the level of the total value of the second degree of coincidence.
When the information which is completely matched with the search keyword is not queried in the target query sub-information, other related query content sets are further determined according to the search level and the search keyword, so that the query range can be enlarged, and the query comprehensiveness is improved. By calculating the cutter information corresponding to the query content set with the second overlapping degree and the recommended overlapping degree with higher total value, the condition that the query fails due to the error or omission of a single query content set can be reduced, and the reliability of the query is improved.
As one embodiment of generating a cutter-loading cutter BOM list from cutter information of each cutter, it comprises:
step a, generating a BOM list of the cutter according to the query sequence; in the embodiment of the application, the queried cutter information is copied into another file according to the query sequence, and a cutter loading cutter BOM list is generated.
Step b, if the situation of inquiring the cutter information according to the preset cutter name exists and/or if the situation of determining the cutter information according to the second degree of coincidence exists, highlighting the corresponding cutter information in the cutter loading cutter BOM list;
step c, generating a first shortcut entry which can be linked to a position corresponding to the tool loading operation instruction book information at a first editing position of the tool information;
and d, generating a second shortcut entry which can be linked to a position corresponding to the BOM library at a second editing position of the cutter information.
In this embodiment, the electronic device generates a first shortcut entry at a first editing location in the tool-mount BOM list and generates a second shortcut entry at a second editing location in the tool-mount BOM list. The user clicking the first shortcut entry may jump from a first editing position of the tool-loading tool BOM list to a corresponding position of the tool-loading job guide information, and the user clicking the second shortcut entry may jump from a second editing position of the tool-loading tool BOM list to a corresponding position of the BOM library.
The corresponding cutter information is highlighted by inquiring the cutter information according to the preset cutter name or determining the cutter information according to the second degree of coincidence, so that a user is reminded of paying attention to the special conditions; and generating a first shortcut entry which can be linked to a position corresponding to the tool loading operation instruction information at a first editing position of the tool information, and generating a second shortcut entry which can be linked to a position corresponding to the BOM library at a second editing position of the tool information, so that a user can conveniently and rapidly position and edit related information, and the operation convenience is improved.
Fig. 4 is a block diagram of a cutter BOM generating device 200 according to an embodiment of the present application.
As shown in fig. 4, a tool BOM generating device 200 mainly includes:
a reading module 201, configured to read information of a tool-setting operation instruction;
a determining module 202, configured to determine each tool query information according to the tool loading operation instruction information; the query information includes a cutter type and at least one keyword;
and the generating module 203 is configured to query tool information in the BOM library according to the tool type and at least one keyword of each tool, and generate a tool loading tool BOM list according to the tool information of each tool.
As an optional implementation manner of the embodiment of the present application, the BOM library is classified according to tool types, and each tool type is classified according to a preset hierarchy, and the generating module 203 includes:
the first determining submodule is used for determining a target query form and a query program of the BOM library according to the cutter type of the cutter for any query information;
the second determining submodule is used for determining search level information and search keyword information of each level of the cutter under the cutter type according to the query program and at least one keyword;
and the query sub-module is used for querying the cutter information in the target query form according to the search level and the search keywords until the cutter information of each cutter is queried.
In this alternative embodiment, the search level information includes a first search level; the search keyword information comprises a first search keyword, and the first keyword comprises a cutter name; the query submodule specifically comprises:
a judging unit, configured to judge whether the name column of the target lookup table has the same content as the tool name according to the tool name;
the first query unit is used for obtaining target query sub-information if the content which is the same as the cutter name exists, and continuously querying cutter information in the target query sub-information according to the search level after the first search level and the corresponding search keywords;
An obtaining unit, configured to obtain a preset tool name list according to the tool type if there is no content identical to the tool name;
a calculating unit, configured to calculate a first overlap ratio between the tool name and a preset tool name in the preset tool name list;
a determining unit, configured to determine a preset tool name of the tool according to the first contact ratio;
and the second query unit is used for querying in the name column of the target query form according to the preset cutter name to obtain target query sub-information, and continuously querying cutter information in the target query sub-information according to the search level after the first search level and the corresponding search keyword.
Optionally, the determining unit is specifically configured to:
sequencing the preset cutter names according to the sequence of the first overlap ratio from high to low to obtain the preset cutter name with the highest first overlap ratio;
judging whether at least two preset cutter names with the highest first overlap ratio exist or not;
if at least two preset cutter names with the highest first coincidence degree exist, respectively acquiring at least one target query sub-information behind the level corresponding to the preset cutter names according to the preset cutter names with the highest first coincidence degree;
Determining a preset cutter name according to the keywords corresponding to the levels behind the first search level of the cutter and at least one piece of target inquiry sub-information;
if a preset cutter name with the highest first contact ratio exists, determining the preset cutter name of the cutter as the preset cutter name with the highest first contact ratio.
Optionally, the system further comprises an error reporting unit, wherein the error reporting unit is specifically configured to:
if the cutter information is not inquired in the BOM library, displaying error information according to the search level so as to remind a user of modifying and inquiring the cutter corresponding to the error information; the error information comprises a cutter number for searching errors and keywords corresponding to the searching level of the cutter.
Optionally, the generating module 203 is specifically configured to:
generating a BOM list of the cutter loading tools according to the query sequence;
if the condition of inquiring the cutter information according to the preset cutter name exists, highlighting the cutter information corresponding to the cutter loading cutter BOM list;
generating a first shortcut entry which can be linked to a position corresponding to the tool loading operation instruction book information at a first editing position of the tool information;
and generating a second shortcut entry which can be linked to a position corresponding to the BOM library at a second editing position of the cutter information.
In one example, a module in any of the above apparatuses may be one or more integrated circuits configured to implement the above methods, for example: one or more application specific integrated circuits (application specific integratedcircuit, ASIC), or one or more digital signal processors (digital signal processor, DSP), or one or more field programmable gate arrays (field programmable gate array, FPGA), or a combination of at least two of these integrated circuit forms.
For another example, when a module in an apparatus may be implemented in the form of a scheduler of processing elements, the processing elements may be general-purpose processors, such as a central processing unit (central processing unit, CPU) or other processor that may invoke a program. For another example, the modules may be integrated together and implemented in the form of a system-on-a-chip (SOC).
Various objects such as various messages/information/devices/network elements/systems/devices/actions/operations/processes/concepts may be named in the present application, and it should be understood that these specific names do not constitute limitations on related objects, and that the named names may be changed according to the scenario, context, or usage habit, etc., and understanding of technical meaning of technical terms in the present application should be mainly determined from functions and technical effects that are embodied/performed in the technical solution.
It will be clearly understood by those skilled in the art that, for convenience and brevity of description, specific working procedures of the above-described system, apparatus and module may refer to corresponding procedures in the foregoing method embodiments, which are not repeated herein.
Those of ordinary skill in the art will appreciate that the various illustrative modules and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, or combinations of computer software and electronic hardware. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present application.
Fig. 5 is a block diagram of an electronic device 300 according to an embodiment of the present application.
As shown in fig. 5, the electronic device 300 includes a processor 301 and a memory 302, and may further include one or more of an information input/information output (I/O) interface 303 and a communication component 304.
Wherein the processor 301 is configured to control the overall operation of the electronic device 300 to complete all or part of the steps in the cutter BOM generating method described above; the memory 302 is used to store various types of data to support operation at the electronic device 300, which may include, for example, instructions for any application or method operating on the electronic device 300, as well as application-related data. The Memory 302 may be implemented by any type or combination of volatile or non-volatile Memory devices, such as one or more of static random access Memory (Static Random Access Memory, SRAM), electrically erasable programmable Read-Only Memory (Electrically Erasable Programmable Read-Only Memory, EEPROM), erasable programmable Read-Only Memory (Erasable Programmable Read-Only Memory, EPROM), programmable Read-Only Memory (Programmable Read-Only Memory, PROM), read-Only Memory (ROM), magnetic Memory, flash Memory, magnetic disk, or optical disk.
The I/O interface 303 provides an interface between the processor 301 and other interface modules, which may be a keyboard, mouse, buttons, etc. These buttons may be virtual buttons or physical buttons. The communication component 304 is used to test wired or wireless communication between the electronic device 300 and other devices. Wireless communication, such as Wi-Fi, bluetooth, near field communication (Near Field Communication, NFC for short), 2G, 3G, or 4G, or a combination of one or more thereof, and accordingly the communication component 304 can include: wi-Fi part, bluetooth part, NFC part.
Communication bus 305 may include a pathway to transfer information between the aforementioned components. The communication bus 305 may be a PCI (Peripheral Component Interconnect, peripheral component interconnect standard) bus or an EISA (Extended Industry Standard Architecture ) bus, or the like. The communication bus 305 may be divided into an address bus, a data bus, a control bus, and the like.
The electronic device 300 may be implemented by one or more application specific integrated circuits (Application SpecificIntegrated Circuit, abbreviated as ASIC), digital signal processors (Digital Signal Processor, abbreviated as DSP), digital signal processing devices (Digital Signal Processing Device, abbreviated as DSPD), programmable logic devices (Programmable Logic Device, abbreviated as PLD), field programmable gate arrays (Field Programmable Gate Array, abbreviated as FPGA), controllers, microcontrollers, microprocessors, or other electronic components for performing the tool BOM generation method as set forth in the above embodiments.
The electronic device 300 may include, but is not limited to, a mobile terminal such as a digital broadcast receiver, a PDA (personal digital assistant), a PMP (portable multimedia player), etc., and a fixed terminal such as a digital TV, a desktop computer, etc., and may also be a server, etc.
The following describes a computer readable storage medium provided in an embodiment of the present application, where the computer readable storage medium described below and the tool BOM generating method described above may be referred to correspondingly.
The present application further provides a computer readable storage medium, on which a computer program is stored, which when executed by a processor implements the steps of the tool BOM generating method described above.
The computer readable storage medium may include: a U-disk, a removable hard disk, a read-only memory (ROM), a random access memory (Random Access Memory, RAM), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus.
The foregoing description is only of the preferred embodiments of the present application and is presented as a description of the principles of the technology being utilized. It will be appreciated by persons skilled in the art that the scope of the application referred to in this application is not limited to the specific combinations of features described above, but it is intended to cover other embodiments in which any combination of features described above or their equivalents is possible without departing from the spirit of the application. Such as the above-mentioned features and the technical features having similar functions (but not limited to) applied for in this application are replaced with each other.

Claims (9)

1. A tool BOM generation method, comprising:
reading information of a tool loading operation instruction book;
determining query information of each cutter according to the cutter loading operation instruction information; the query information includes a cutter type and at least one keyword;
inquiring cutter information in a BOM library according to the cutter type and at least one keyword of each cutter, and generating a cutter loading cutter BOM list according to the cutter information of each cutter.
2. The method of claim 1, wherein the BOM library is categorized by tool type, each tool type is categorized by a preset hierarchy, and wherein querying the BOM library for tool information by tool type and at least one keyword for each tool comprises:
For any query information, determining a target query form and a query program of the BOM library according to the cutter type of the cutter;
determining search level information and search keyword information of each level of the cutter under the cutter type according to the query program and at least one keyword;
inquiring cutter information in the target inquiry form according to the search level and the search keywords until the cutter information of each cutter is inquired.
3. The method of claim 2, wherein the search level information comprises a first search level; the search keyword information comprises a first search keyword, wherein the first search keyword is a cutter name;
the step of searching the cutter information in the target inquiry form according to the search level information and the search keyword information comprises the following steps:
judging whether the name column of the target lookup table has the same content as the cutter name according to the cutter name;
if the content same as the cutter name exists, obtaining target inquiry sub-information, and continuously inquiring cutter information in the target inquiry sub-information according to the search level after the first search level and the corresponding search keyword;
If the content which is the same as the cutter name does not exist, acquiring a preset cutter name list according to the cutter type;
calculating a first coincidence of the cutter name and a preset cutter name in the preset cutter name list;
determining a preset cutter name of the cutter according to the first contact ratio;
inquiring in a name column of the target inquiry form according to the preset cutter name to obtain target inquiry sub-information, and continuing to inquire cutter information in the target inquiry sub-information according to the search level after the first search level and the corresponding search keyword.
4. A method according to claim 3, said determining a preset tool name of the tool from the first overlap ratio comprising:
sequencing the preset cutter names according to the sequence of the first overlap ratio from high to low to obtain the preset cutter name with the highest first overlap ratio;
judging whether at least two preset cutter names with the highest first overlap ratio exist or not;
if at least two preset cutter names with the highest first coincidence degree exist, respectively acquiring at least one target query sub-information behind the level corresponding to the preset cutter names according to the preset cutter names with the highest first coincidence degree;
Determining a preset cutter name according to the search keywords corresponding to the later layers of the first search layer of the cutter and at least one piece of target inquiry sub-information;
if a preset cutter name with the highest first contact ratio exists, determining the preset cutter name of the cutter as the preset cutter name with the highest first contact ratio.
5. A method according to claim 3, further comprising:
if the information which is completely matched with the search keyword is not queried in the corresponding target query sub-information according to the search level and the corresponding search keyword, determining that the cutter information is not queried in the BOM library, and displaying error information according to the search level so as to remind a user to modify and query the cutter corresponding to the error information; the error information comprises a cutter number for searching errors and a search keyword corresponding to the error reporting search level of the cutter.
6. The method of claim 3 or 4, wherein generating a tool-in-tool BOM list from tool information for each tool comprises:
generating a BOM list of the cutter loading tools according to the query sequence;
if the condition of inquiring the cutter information according to the preset cutter name exists, highlighting the cutter information corresponding to the cutter loading cutter BOM list;
Generating a first shortcut entry which can be linked to a position corresponding to the tool loading operation instruction book information at a first editing position of the tool information;
and generating a second shortcut entry which can be linked to a position corresponding to the BOM library at a second editing position of the cutter information.
7. A tool BOM generating device, comprising:
the reading module is used for reading the information of the tool-setting operation instruction book;
the determining module is used for determining each cutter query information according to the cutter loading operation instruction information; the query information includes a cutter type and at least one keyword;
and the generating module is used for inquiring cutter information in the BOM library according to the cutter type and at least one keyword of each cutter and generating a cutter loading cutter BOM list according to the cutter information of each cutter.
8. An electronic device comprising a processor coupled to a memory;
the processor is configured to execute a computer program stored in the memory to cause the electronic device to perform the method of any one of claims 1 to 6.
9. A computer readable storage medium comprising a computer program or instructions which, when run on a computer, cause the computer to perform the method of any of claims 1-6.
CN202311413513.0A 2023-10-26 2023-10-26 Cutter BOM generation method, device and equipment and computer readable storage medium Pending CN117556029A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202311413513.0A CN117556029A (en) 2023-10-26 2023-10-26 Cutter BOM generation method, device and equipment and computer readable storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202311413513.0A CN117556029A (en) 2023-10-26 2023-10-26 Cutter BOM generation method, device and equipment and computer readable storage medium

Publications (1)

Publication Number Publication Date
CN117556029A true CN117556029A (en) 2024-02-13

Family

ID=89821235

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202311413513.0A Pending CN117556029A (en) 2023-10-26 2023-10-26 Cutter BOM generation method, device and equipment and computer readable storage medium

Country Status (1)

Country Link
CN (1) CN117556029A (en)

Similar Documents

Publication Publication Date Title
US20070260595A1 (en) Fuzzy string matching using tree data structure
US20150025672A1 (en) System and method for selecting cutting tools
US10754322B2 (en) System and method for selecting a tool assembly
CN105451934A (en) Tool management system
JP2018041387A (en) Processing information-gathering system
CN108829651A (en) A kind of method, apparatus of document treatment, terminal device and storage medium
CN107783786A (en) A kind of method and apparatus for creating device resource
Fernandes et al. Incorporated tool selection system using object technology
CN117556029A (en) Cutter BOM generation method, device and equipment and computer readable storage medium
JP5508872B2 (en) Manufacturing procedure information creation system and manufacturing procedure information creation program
JP2012190113A (en) Processing data generation system, and solver program
CN107024906B (en) Code generation method and device for numerical control tool
CN112800128B (en) Multifunctional and easy-to-use laboratory execution system
JP2009048598A (en) Document information display system
CN100371837C (en) Value controlling machinery
JP5209438B2 (en) Document processing device
Liao et al. Modification of CAPP systems for CAPP/scheduling integration
JP2011025325A (en) Cutting support system
JP2002140356A (en) Database system and database retrieving method
WO2015099575A1 (en) Methods and systems for generating and searching a semantic data structure
Kočiško et al. Redefining of Shop Floor Documentation for the Purposes of NC Machining in the NX System
JPH01188249A (en) Determination of tool used by expert system
CN116736799A (en) Code conversion method of numerical control system based on woodworking
Gupta Development of an integrated model for process planning and parameter selection for machining processes
CN114398853A (en) Extraction method and device of document numerical index based on machine learning

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination