A work order retrieval and marking integrated processing method and device based on an MES system

Abstract

The application provides a work order retrieval and marking integrated processing method and device based on an MES system, the method comprising generating a product work order containing a product identification code, the product identification code containing second positioning information; scanning the product identification code in the product work order by using a user MES equipment terminal, obtaining product difference data and product basic data based on the second positioning information; retrieving a target database based on the product basic data, and forming product comprehensive data based on the product difference data and product general data; and performing MES system product inventory processing. In this way, the data acquisition and retrieval efficiency is improved, the work order generation efficiency is improved, and operation space for acquiring complex work order data can be provided.

Description

Technical Field

[0001] The present invention relates to the technical field of MES systems, and more particularly to a method and device for integrated work order retrieval and marking based on an MES system. Background Art

[0002] In recent years, MES systems have played an increasingly important role in the digital management of enterprises, factories, warehouses, and more. MES, standing for Manufacturing Execution System, is a production information management system for the executive level of an enterprise. It has important applications in product data tracking, manufacturing processes, production scheduling and control, construction status tracking, and production indicator analysis.

[0003] The MES system boasts powerful data processing capabilities. In a typical existing application scenario, the system incorporates identification code technology, enabling rapid scanning, labeling, and reporting (work report) of production flow cards. At the production site (manufacturing workshop / warehouse, etc.), workers simply use their mobile devices to scan the work order identification code, and the system automatically identifies and retrieves relevant production information and performs process processing. In actual production, we encounter inefficient identification code data processing. Analysis of the reasons for this primarily includes three aspects:

[0004] On the one hand, the conventional processing flow of identification codes can be simplified as follows: identifying identification codes, parsing identification code information, searching databases, and obtaining data to be processed (such as data entry, exit, labeling, report generation, and other data processing). This process has certain requirements for processing equipment. For example, a consumer-grade barcode scanner may take 0.5-2s to implement the above process, with obvious pauses. This is obviously inefficient in large-scale data production scenarios. For example, inefficient production process operations (long waiting time for equipment processing, pauses in business processes), and data conflicts may occur under high concurrency conditions (incoming and outgoing data do not match, the same product is repeatedly exited, and different products correspond to the same warehouse label). In the operation scenarios of wireless terminal devices (currently, many MES front-end devices are based on wireless communication, such as enterprise work mobile phones / wireless barcode scanners, etc.), the above problems are particularly prominent.

[0005] Secondly, multi-data work order data of the same product type (such as the same type of equipment product A and equipment product B, their production process data, inspection data, performance data, data templates required by the same seller, etc.) are usually the same. In actual work scenarios, the product types faced by staff in similar working time periods are usually the same product types, resulting in a large amount of data redundancy in the processed data. Using only conventional process processing steps will lead to inefficiency due to data redundancy.

[0006] The above two issues are common and hidden pain points faced by enterprises using MES systems. Usually, high-performance industrial-grade scanning equipment can reduce processing time to milliseconds, which can solve the above problems to a certain extent. However, the high cost brought by high performance is a new problem that will be faced.

[0007] Thirdly, the phenomenon of inefficient identification code data processing is also reflected in the following: in conventional work orders, the number of storage bytes of the identification code can usually accommodate the corresponding amount of data. However, for complex work orders, for example, work orders containing complex text (such as complex processes / detailed instructions / warning protocols, etc.), drawings (such as product circuit diagrams / appearance diagrams / instruction diagrams), or special user requirements (such as certification stamps / user-customized warehousing requirements, etc.), the existing identification codes are difficult to fully cope with these problems, thereby limiting the content of the product work order.

[0008] The information disclosed in the background technology section of the present invention is only intended to deepen the understanding of the general background technology of the present invention, and should not be regarded as an admission or any form of suggestion that the information constitutes the prior art already known to those skilled in the art. Summary of the Invention

[0009] The present invention proposes an integrated work order retrieval and marking processing method and system based on the MES system. The method improves the second positioning information of the existing identification code rules and configures a corresponding database access method. The identification code information circled by the second positioning information is used to quickly obtain work order information, thereby improving the execution efficiency of the MES system terminal working equipment.

[0010] In a first aspect, an embodiment of the present disclosure provides a method for integrated work order retrieval and marking based on an MES system, the method comprising the steps of:

[0011] S100, generating a product work order including a product identification code, wherein the product identification code includes second positioning information, and the second positioning information is used to store location information of product difference data and product basic data in the identification code;

[0012] S110, using a user MES device terminal to scan a product identification code in a product work order and executing a first data acquisition step; in the first data acquisition step, product difference data and product basic data are acquired based on the second positioning information;

[0013] S120, searching the target database based on the product basic data, returning the product general data if the search is successful, and constructing the product comprehensive data based on the product difference data and the product general data;

[0014] S130, executing MES system product inventory processing on the product based on the comprehensive product data.

[0015] Preferably, the method for generating the second positioning information is: defining a quick identification area within the identification code range, and the preset range dot matrix in the upper left corner, the preset range dot matrix in the upper right corner, and the preset range dot matrix in the lower left corner of the quick identification area serve as the quick identification area range defined by the second positioning information. In addition to the second positioning information, the quick identification area also includes a reserved area and a quick identification data area. The reserved area is used to configure the necessary functions of the quick identification area, and the product difference data and product basic data are encoded and stored in the quick identification data area.

[0016] Preferably, the method for generating the second positioning information is: defining an identification code recognition protocol, which stipulates the positioning coordinates of the rapid identification area, and the positioning coordinates include the overall coordinate range of the rapid identification area, the reserved area coordinates in the rapid identification area, and the rapid identification data area coordinates.

[0017] Preferably, the second positioning information is generated by reserving a range in the identification code information area as a fast identification data area, and dynamically configuring the coordinates of the reserved range in the identification code function area.

[0018] It is preferred to establish an in-memory database on the MES system server side. Based on the current working situation, the product general data set and the corresponding database table corresponding to the same or similar product types are stored in the in-memory database in advance, thereby establishing a database cache of the in-memory database. When the MES device terminal receives the basic product data, it is searched in the database cache first. If the corresponding data does not exist in the cache, the search continues in the in-memory database. If the corresponding data does not exist in the in-memory database, the search continues in the regular database.

[0019] Preferably, an in-memory database is established on the MES system server side, and a local in-memory database is established on the MES system user MES device terminal. Based on the current working situation, the product common data set and the corresponding database table corresponding to the same or similar products are pre-stored in the local in-memory database, thereby establishing a database cache of the local database. When the MES device terminal receives the product basic data, it is searched in the local in-memory database cache first. If the corresponding data does not exist in the cache, the server database is searched again.

[0020] Preferably, complex work order data is processed, specifically as follows: in step S100, it also includes: reserving a range in the identification code information area as a specific data area for storing data identifiers corresponding to complex data; in step S110, it also includes: in the first data acquisition step, obtaining product difference data and product basic data, and data identifiers corresponding to complex data based on the second positioning information; in S120, it also includes: searching the target database based on the data identifier corresponding to the complex data, and returning product complex data if the retrieval is successful, and constructing product comprehensive data based on product difference data, product complex data and product general data.

[0021] In a second aspect, the present disclosure provides an integrated work order retrieval and marking processing device based on an MES system, comprising:

[0022] An identification code setting module, configured to generate a product work order including a product identification code, wherein the product identification code includes second positioning information, and the second positioning information is used to store location information of product difference data and product basic data in the identification code;

[0023] An MES scanning module uses a user MES device terminal to scan a product identification code in a product work order and execute a first data acquisition function; in the first data acquisition function, product difference data and product basic data are acquired based on the second positioning information;

[0024] The MES retrieval module is used to search the target database based on the basic product data. If the search is successful, the product general data is returned and the comprehensive product data is constructed based on the product difference data and the product general data;

[0025] The MES processing module is used to perform MES system product inventory processing on products based on comprehensive product data.

[0026] Preferably, the method for generating the second positioning information is: defining a quick identification area within the identification code range, and the preset range dot matrix in the upper left corner, the preset range dot matrix in the upper right corner, and the preset range dot matrix in the lower left corner of the quick identification area serve as the quick identification area range defined by the second positioning information. In addition to the second positioning information, the quick identification area also includes a reserved area and a quick identification data area. The reserved area is used to configure the necessary functions of the quick identification area, and the product difference data and product basic data are encoded and stored in the quick identification data area.

[0027] Preferably, the method for generating the second positioning information is: defining an identification code recognition protocol, which stipulates the positioning coordinates of the rapid identification area, and the positioning coordinates include the overall coordinate range of the rapid identification area, the reserved area coordinates in the rapid identification area, and the rapid identification data area coordinates.

[0028] Preferably, the second positioning information is generated by reserving a range in the identification code information area as a fast identification data area, and dynamically configuring the coordinates of the reserved range in the identification code function area.

[0029] Preferably, an in-memory database is established on the MES system server side. Based on the current working situation, the product general data set and the corresponding database table corresponding to the same or similar product types are pre-stored in the in-memory database, thereby establishing a database cache of the in-memory database. When the MES device terminal receives the basic product data, it is searched in the database cache first. If the corresponding data does not exist in the cache, the search continues in the in-memory database. If the corresponding data does not exist in the in-memory database, the search continues in the regular database.

[0030] Preferably, an in-memory database is established on the MES system server side, and a local in-memory database is established on the MES system user MES device terminal. Based on the current working situation, the product common data set and the corresponding database table corresponding to the same or similar products are pre-stored in the local in-memory database, thereby establishing a database cache of the local database. When the MES device terminal receives the product basic data, it is searched in the local in-memory database cache first. If the corresponding data does not exist in the cache, the server database is searched again.

[0031] Preferably, complex work order data is processed, specifically as follows: in the identification code setting module, it also includes: reserving a range in the identification code information area as a specific data area for storing data identifiers corresponding to complex data; in the MES scanning module, it also includes: in the first data acquisition function, obtaining product difference data and product basic data, and data identifiers corresponding to complex data based on the second positioning information; in the MES retrieval module, it also includes: searching the target database based on the data identifier corresponding to the complex data, and returning product complex data if the retrieval is successful, and constructing product comprehensive data based on product difference data, product complex data and product general data.

[0032] The present invention provides a method and device for integrated work order retrieval and marking based on an MES system, which achieves at least the following technical effects: (1) improving the product identification code of the product work order, and based on the second positioning information, being able to process only the identification processing of part of the identification code and only search for part of the data, thereby improving the data acquisition and retrieval efficiency, and thus improving the work order generation efficiency; (2) combining the improved identification code layout with the improved database configuration method, further improving the data acquisition efficiency; (3) splitting the product work order data, while improving the data acquisition efficiency, being able to provide an operating space for acquiring complex work order data. BRIEF DESCRIPTION OF THE DRAWINGS

[0033] Figure 1A flow chart showing steps of a work order retrieval and marking integrated processing method based on an MES system according to an embodiment of the present application is shown.

[0034] Figure 2 A block diagram of a work order retrieval and marking integrated processing method and device based on an MES system according to an embodiment of the present application is shown. DETAILED DESCRIPTION

[0035] To make the objectives, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be described clearly and completely below with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are only some embodiments of the present application, rather than all the embodiments of the present application. Based on the embodiments in the present application, all other embodiments obtained by those of ordinary skill in the art without creative effort should fall within the scope of the present application.

[0036] The terms "first", "second", "third", "fourth" and the like in the description and claims of the present application and the above drawings (if any) are used to distinguish similar objects, and do not necessarily indicate a specific order or sequence. It should be understood that the data thus used can be interchanged, where appropriate, so that the embodiments of the present application described herein can be carried out in other than the order shown or described herein. Furthermore, the terms "comprise" and "correspond to" and any variations thereof are intended to cover non-exclusive inclusion, for example, a process, method, system, product or apparatus that includes a list of steps or units is not necessarily limited to those steps or units clearly listed, but can include other steps or units not clearly listed or inherent to such processes, methods, products or apparatus.

[0037] In order to make the objectives, technical solutions and advantages of the present application clearer, the present application will be further described in detail below with reference to the embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application, and do not limit the present application.

[0038] Embodiment one: as shown, the present application discloses an embodiment of a work order retrieval and marking integrated processing method based on an MES system, comprising: Figure 1

[0039] S100, generating a product work order containing a product identification code, the product identification code containing second positioning information, the second positioning information being used to store the location information of product difference data and product basic data in the identification code.

[0040] ​A product identification code (PIC) is key information used to uniquely identify and manage products. Different types are typically selected based on the application scenario, industry standards, or technical requirements. Common PICs include universal standard codes (e.g., European / Chinese product barcodes), technical and automation codes (e.g., QR codes, Data Matrix codes), and industry-specific codes (e.g., vehicle identification numbers (VINs)). The integrated MES-based work order retrieval and labeling method provided in this embodiment of the present application can be applied to the PICs described above, depending on the scenario, and this application does not impose any restrictions on this.

[0041] To better illustrate the present invention, let's take a QR code as an example. Currently, there are 40 different matrix sizes for QR codes, officially referred to as versions, also known as QR code specifications. Each version has a different capacity. Higher versions have a larger capacity, meaning they can carry more content. For example, version 10 can store approximately 1,200 bytes, while version 40 can store approximately 3,000 bytes.

[0042] Taking the version 2 QR code as an example, it is a 25×25 matrix, on which the first positioning information, functional area, and information area are distributed. The first positioning information is usually in the upper left corner, upper right corner, and lower left corner, and is used to locate the entire identification code and mark its size so that the device can quickly locate and adjust the identification code. The functional area is distributed in various predetermined positions and is used to configure the identification code function, such as defining the format, version, error correction code, mask, etc., to provide necessary and basic configuration information for the identification code. The information area is an area other than the first positioning information and the functional area, and is used to store target data. In an embodiment of the present invention, a second positioning information is set, which is different from the first positioning information and is used to store the location information of product difference data and product basic data in the identification code.

[0043] Data in the incoming / outgoing product work order data that differs from the work order data of other products of the same type constitutes product difference data. Data in the incoming / outgoing product work order data that is identical to the work order data of other products of the same type constitutes product common data. Data used to identify common data constitutes product base data. In one embodiment, the difference data includes the SA (product difference data set) = {a1, a2, …, an} data set, the common data includes the SB (process data set) = {b1, b2, …, bn}, the SC (product specification data set) = {c1, c2, …, cn}, and the SD (product time data set) = {d1, d2, …, dn}, and the product base data includes the S (base data set) = {sb, sc, sd}. The second positioning information is used to find the product difference data and product base data. Based on these two data, the complete work order data (i.e., comprehensive product data) can be reconstructed.

[0044] In a preferred embodiment, the second positioning information is generated by defining a quick identification area within the identification code range. The quick identification area is defined by a preset dot matrix in the upper left corner, the upper right corner, and the lower left corner. In addition to the second positioning information, the quick identification area also includes a reserved area and a quick identification data area. The reserved area is used to configure necessary functions of the quick identification area, such as defining the format, version, error correction code, and mask. Product difference data and basic product data are encoded and stored in the quick identification data area. This second positioning information references the original layout of the identification code, making it easier to understand and quickly locate. However, it occupies a large amount of space in the identification code layout, which may affect data storage in some cases.

[0045] In a preferred embodiment, the method for generating the second positioning information is as follows: defining an identification code recognition protocol, wherein the identification protocol stipulates the positioning coordinates of the rapid identification area, and the positioning coordinates include the overall coordinate range of the rapid identification area (such as the coordinates of the four corners), the coordinates of the reserved area in the rapid identification area, and the coordinates of the rapid identification data area. The functions of the reserved area and the rapid identification data area are as described above and will not be repeated here. This type of second positioning information saves space to a certain extent, but because the coordinate values ​​need to be defined in the protocol, the decoder needs to program the protocol in advance; in addition, numerical coordinates may cause inaccurate identification and positioning in special circumstances such as unclear identification codes, and there is a certain degree of instability.

[0046] In a preferred embodiment, the second positioning information is generated by reserving a range in the identification code information area as a rapid identification data area (for storing encoded data of product differentiation data and basic product data), and dynamically configuring the coordinates of this reserved range in the identification code functional area. This method of generating the second positioning information only makes minor adjustments to the functional area of ​​the original identification code layout (for dynamic coordinate configuration) and does not involve other layout changes. Therefore, it maximizes the use of the original identification code layout and improves adaptability. The use of dynamically configured coordinates in the reserved range in the information area maximizes space savings in the identification code layout and improves storage efficiency. However, this method does not completely deviate from the original identification code recognition mechanism and still requires decoding of some data in the information area. From this perspective, its performance improvement is not sufficient.

[0047] The provision of secondary positioning information within the identification code defines a quick identification data area within the identification code layout for storing product differentiation data and basic product data, effectively improving identification code recognition efficiency. Furthermore, the three methods for generating secondary positioning information address the secondary positioning information content from different perspectives, at least partially resolving the technical issues mentioned in the background art. This constitutes one of the core concepts of this invention.

[0048] S110, using the user MES device terminal to scan the product identification code in the product work order and perform a first data acquisition step; in the first data acquisition step, product difference data and product basic data are acquired based on the second positioning information.

[0049] User MES equipment terminals include dedicated work phones and wired / wireless barcode scanners. In the first data acquisition step, the scanner monitors the input signal, scans and parses the product identification code. Based on the secondary positioning information in the identification code, product difference data and basic product data can be quickly obtained. This data is used to reconstruct the complete product work order data. When a product enters the warehouse, the work order data can be written to the database to indicate the product's entry status, and a product label can be generated based on the work order data. When a product leaves the warehouse, the work order data can be updated from the database to indicate the product's departure status. Upon completion of the scan, the user automatically jumps to the acquired work order details page to display the work order data.

[0050] S120, searching the target database based on the product basic data, returning the product general data if the search is successful, and constructing the product comprehensive data based on the product difference data and the product general data.

[0051] Because the product base data does not include complete product work order data, it is necessary to further retrieve the corresponding product work order data based on the product base data, and then combine it with the product difference data to form the comprehensive product data. Continuing with the previous example, the obtained product base data includes S (basic data set) = {sb, sc, sd}. The MES device terminal forwards the obtained product base data to the MES system server for a general data search. Based on the product base data sb, the SB (process data set) = {b1, b2, …, bn} in the general data set is retrieved. Based on the product base data sc, the SC (product specification data set) = {c1, c2, …, cn} in the general data set is retrieved. Based on the product base data sd, the SD (product time data set) = {d1, d2, …, dn} in the general data set is retrieved. If the search is successful, the product general data is returned, and the comprehensive product data is formed based on the product difference data and the product general data for subsequent inventory operations.

[0052] The database configuration is related to the effectiveness of code recognition. Generally speaking, the latency for queries in memory and above (all levels of cache) is in the nanosecond level, the latency for regular SSD queries is in the microsecond level, and the latency for regular HDD queries is in the millisecond level. Taking a data volume of millions / HDD storage media as an example, when a B+ tree search index is established (no full disk scan is required), executing a simple query takes approximately milliseconds. In the best case (such as establishing a reasonable index / master-slave key and a memory hit), it can reach the microsecond level, thus generally meeting the needs of routine work. However, in practical work, there are poor conditions, such as no index, unreasonable index, poor storage media quality, and unoptimized data structure. Database searches may be sluggish, so further optimization is required.

[0053] In a preferred embodiment, an in-memory database is established on the server side of the MES system. For example, the in-memory database can be a Redis database, which pre-stores product general data sets and corresponding database tables. In practical work, products of the same type usually perform inventory operations in similar time periods. Therefore, based on the current working situation, the product general data sets and corresponding database tables corresponding to the same or similar product types can be stored in the in-memory database, thereby establishing a database cache of the in-memory database. When the MES device terminal receives the basic product data, it is searched in the database cache first. If the corresponding data does not exist in the cache, the search continues in the in-memory database. If the corresponding data does not exist in the in-memory database, the search continues in the regular database. Establishing a corresponding database cache based on the current working situation significantly improves the retrieval efficiency and reduces the retrieval response time.

[0054] In a preferred embodiment, a local database is established in the MES device terminal of the MES system user. The performance of the user MES device terminal is relatively low, and the storage space is limited. A lightweight database can be established to store key data and high-popularity data to improve data retrieval efficiency. Similarly, the product general data set and the corresponding database table are pre-stored locally in the user MES device terminal. Based on the current working situation, the product general data set and the corresponding database table corresponding to the same or similar products are stored in the local database, thereby establishing a database cache of the local database. When the MES device terminal is about to obtain the basic data of the product, it is searched in the local database cache first. If the corresponding data does not exist in the cache, the search continues in the local database. The establishment of a local lightweight database further significantly reduces network transmission time, improves retrieval efficiency, and reduces retrieval response time.

[0055] In a preferred embodiment, complex work order data is processed. Specifically, in step S100, it also includes: reserving a range in the identification code information area as a specific data area for storing data identifiers corresponding to complex data (such as user-customized data, complex text, work order attachment data, etc., and dynamically configuring the reserved range coordinates in the identification code function area. Further, in step S110, it also includes: in the first data acquisition step, obtaining product difference data and product basic data, and data identifiers corresponding to complex data based on the second positioning information. Further, in S120, it also includes: searching the target database based on the data identifier corresponding to the complex data, and returning the product complex data if the retrieval is successful, and constructing product comprehensive data based on the product difference data, product complex data and product general data.

[0056] The configuration of the database and the improvement of the identification code together realize the rapid acquisition of work order data. The two complement each other and together constitute the core inventive points of the present invention.

[0057] On the other hand, in the case of unsuccessful retrieval or retrieval timeout, the information area of ​​the identification code is further parsed, and after the complete parsing, the comprehensive product data is obtained and the subsequent steps are entered.

[0058] S130, executing MES system product inventory processing on the product based on the comprehensive product data.

[0059] After obtaining comprehensive product data, appropriate inventory processing can be performed. For example, after production is completed, purchases arrive, products are returned, and products are scanned after quality inspection, warehousing operations are performed, and items are simultaneously shelved or stored to ensure consistency between database data and warehouse status. When shipping, selling, or transferring goods, outbound operations are performed for the corresponding products, and inventory deductions are performed to ensure consistency between database data and warehouse status. Inventory processing also includes other related operations, such as inventory data viewing, previewing, and verification, including one-click work order data preview and printing functions.

[0060] In a preferred embodiment, a built-in label template engine is automatically bound to work order data. Key parameters such as product model and batch are acquired through an MES system interface, and a preview interface is determined based on the user's desired template. This supports real-time editing, error checking, and one-click printing. This one-click printing function requires configuring a print command direct channel to drive the printer.

[0061] In a preferred embodiment, product inventory operations include different types of labeling operations such as harness labels / bag labels / box labels, and different customers have different template requirements for different labels / or products. Therefore, before searching, the following steps are performed: the user sets a work order template, and the work order template contains the fields required for display. When searching the database, search filtering is performed based on the fields contained in the work order template set by the user, thereby reducing the search workload and search response time while meeting customer needs.

[0062] Example 2: Figure 2 As shown, the present invention also provides an integrated processing device for work order retrieval and marking based on an MES system, comprising:

[0063] An identification code setting module, configured to generate a product work order including a product identification code, wherein the product identification code includes second positioning information, and the second positioning information is used to store location information of product difference data and product basic data in the identification code;

[0064] An MES scanning module uses a user MES device terminal to scan a product identification code in a product work order and execute a first data acquisition function; in the first data acquisition function, product difference data and product basic data are acquired based on the second positioning information;

[0065] The MES retrieval module is used to search the target database based on the basic product data. If the search is successful, the product general data is returned and the comprehensive product data is constructed based on the product difference data and the product general data;

[0066] The MES processing module is used to perform MES system product inventory processing on products based on comprehensive product data.

[0067] In a preferred embodiment, the method for generating the second positioning information is: defining a quick identification area within the identification code range, and the preset range dot matrix in the upper left corner, the preset range dot matrix in the upper right corner, and the preset range dot matrix in the lower left corner of the quick identification area serve as the quick identification area range defined by the second positioning information. In addition to the second positioning information, the quick identification area also includes a reserved area and a quick identification data area. The reserved area is used to configure the necessary functions of the quick identification area, and the product difference data and product basic data are encoded and stored in the quick identification data area.

[0068] In a preferred embodiment, the method for generating the second positioning information is: defining an identification code recognition protocol, which stipulates the positioning coordinates of the rapid identification area, and the positioning coordinates include the overall coordinate range of the rapid identification area, the reserved area coordinates in the rapid identification area, and the rapid identification data area coordinates.

[0069] In the preferred embodiment, the method for generating the second positioning information is to reserve a range in the identification code information area as a quick identification data area, and dynamically configure the coordinates of the reserved range in the identification code function area.

[0070] In the preferred embodiment, a memory database is established at the MES system server end, based on the current work situation, the product general data set corresponding to the same or similar product type and the corresponding database table are pre-stored in the memory database, thereby establishing a database quick table of the memory database, when the MES device terminal obtains product basic data, the product basic data is preferentially searched in the database quick table, if the corresponding data does not exist in the quick table, the search is continued in the memory database, and if the corresponding data does not exist in the memory database, the search is continued in the regular database.

[0071] In the preferred embodiment, a memory database is established at the MES system server end, a local memory database is established at the MES system user MES device terminal, based on the current work situation, the product general data set corresponding to the same or similar product and the corresponding database table are pre-stored in the local memory database, thereby establishing a database quick table of the local database, when the MES device terminal obtains product basic data, the product basic data is preferentially searched in the local memory database quick table, if the corresponding data does not exist in the quick table, the search is continued in the server database.

[0072] In the preferred embodiment, the complex work order data is processed, specifically, in the identification code setting module, a range is further reserved in the identification code information area as a specific data area for storing the data identifier corresponding to the complex data, in the MES scanning module, the first data acquisition function further includes acquiring the product difference data and the product basic data and the data identifier corresponding to the complex data based on the second positioning information, and in the MES searching module, the target database is searched based on the data identifier corresponding to the complex data, the product complex data is returned in the case of successful searching, and the product comprehensive data is formed based on the product difference data, the product complex data and the product general data.

[0073] The application provides a work order searching and marking integrated processing method and device based on an MES system, which at least achieves the following technical effects: (1) improving the product identification code of the product work order, based on the second positioning information, only part of the identification code is processed, and only part of the data is searched, thereby improving the data acquisition and searching efficiency and the work order generation efficiency; (2) combining the improved identification code layout with the improved database configuration mode, and further improving the data acquisition efficiency; (3) splitting the product work order data, thereby providing operation space for acquiring complex work order data while improving the data acquisition efficiency.

[0074] According to one embodiment, a program product such as a machine-readable medium is provided. The machine-readable medium may have instructions (i.e., the elements implemented in the form of software) that, when executed by a machine, cause the machine to perform the above-mentioned combined operations in various embodiments of this specification. Figure 1 Specifically, a system or device equipped with a readable storage medium can be provided, on which software program codes for implementing the functions of any of the above-mentioned embodiments are stored, and a computer or processor of the system or device can be enabled to read and execute the instructions stored in the readable storage medium.

[0075] In this case, the program code itself read from the machine-readable medium can implement the functions of any one of the above embodiments, and thus the machine-readable code and the machine-readable storage medium storing the machine-readable code constitute part of this specification.

[0076] Examples of readable storage media include floppy disks, hard disks, magneto-optical disks, optical disks (e.g., CD-ROMs, CD-Rs, CD-RWs, DVD-ROMs, DVD-RAMs, DVD-RWs, DVD-RWs), magnetic tapes, non-volatile memory cards, and ROMs. Alternatively, the program code may be downloaded from a server computer or a cloud via a communication network.

[0077] Those skilled in the art will appreciate that the various embodiments disclosed above may be modified and altered in various ways without departing from the essence of the invention. Therefore, the scope of protection of this specification shall be defined by the appended claims.

[0078] It should be noted that not all steps and units in the above processes and system structure diagrams are required, and certain steps or units can be omitted according to actual needs. The execution order of each step is not fixed and can be determined as needed. The device structure described in the above embodiments can be a physical structure or a logical structure, that is, some units may be implemented by the same physical client, or some units may be implemented by multiple physical clients, or may be implemented by certain components in multiple independent devices.

[0079] In the above embodiments, the hardware unit or module can be implemented mechanically or electrically. For example, a hardware unit, module, or processor may include permanent dedicated circuits or logic (such as a dedicated processor, FPGA, or ASIC) to complete the corresponding operation. The hardware unit or processor may also include programmable logic or circuits (such as a general-purpose processor or other programmable processor), which can be temporarily configured by software to complete the corresponding operation. The specific implementation method (mechanical method, dedicated permanent circuit, or temporarily configured circuit) can be determined based on cost and time considerations.

[0080] The detailed description set forth above describes exemplary embodiments but is not intended to represent the only embodiments in which the application can be practiced. The term "exemplary" is used herein to mean "serving as an example, instance, or illustration." Thus, the description is not intended to be limited to the embodiments described herein, but can be practiced with variations that are apparent to those of skill in the art. For the purposes of the present disclosure, the terms "example" and "exemplary" are used interchangeably. The specific embodiments described herein are shown by way of example, can not be necessarily be the only way to implement the application. The detailed description set forth above is not intended to represent the only ways in which the application can be practiced. Other aspects and features of the present application are apparent from the following claims.

[0081] The above description of the present disclosure is provided to enable any person skilled in the art to practice or use the present disclosure. Various modifications to the present disclosure will be readily apparent to those skilled in the art, and the generic principles defined herein can be applied to other variations without departing from the scope of the protection of the present disclosure. Thus, the present disclosure is not intended to be limited to the examples described herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A method for integrated work order retrieval and marking based on an MES system, characterized in that: The method comprises: S100: Generate a product work order including a product identification code, wherein the product identification code includes second positioning information; the second positioning information is used to store location information of product difference data and product basic data in the identification code; define a quick identification area within the identification code range, with a preset range of dots in the upper left corner, the upper right corner, and the lower left corner of the quick identification area serving as the range of the quick identification area defined by the second positioning information; A range is reserved in the identification code information area as a specific data area for storing data identifiers corresponding to complex data; S110, using a user MES device terminal to scan a product identification code in a product work order and executing a first data acquisition step; in the first data acquisition step, product difference data and product basic data are acquired based on the second positioning information; In the first data acquisition step, a data identifier corresponding to the complex product data is acquired based on the second positioning information; S120, searching the target database based on the basic product data, and returning the general product data if the search is successful; searching the target database based on the data identifier corresponding to the complex data, and returning the complex product data if the search is successful; and constructing comprehensive product data based on the product difference data, the complex product data, and the general product data; S130, performing MES system product inventory processing on the product based on the comprehensive product data; The rapid identification area includes, in addition to the second positioning information, a reserved area and a rapid identification data area. The reserved area is used to configure the necessary functions of the rapid identification area. The product difference data and product basic data are encoded and stored in the rapid identification data area. A server memory database is established on the MES system server side, and a local memory database is established on the MES system user MES device terminal. Based on the current working situation, the product general data set and the corresponding database table corresponding to the same or similar product types are pre-stored in the local memory database, thereby establishing a database quick table of the local memory database. When the basic product data obtained by the MES device terminal arrives, it is searched in the local memory database quick table first. If the corresponding data does not exist in the quick table, the server memory database is searched again. If the server memory database does not exist, the server regular database is searched again.

2. A work order retrieval and marking integrated processing device based on the MES system, characterized in that: The device comprises the following modules: An identification code setting module is configured to generate a product work order containing a product identification code, wherein the product identification code includes second positioning information; the second positioning information is used to store the location information of the product difference data and the basic product data in the identification code; a quick identification area is defined within the identification code range, with the preset range dot matrix in the upper left corner, the preset range dot matrix in the upper right corner, and the preset range dot matrix in the lower left corner of the quick identification area serving as the range of the quick identification area defined by the second positioning information; A range is reserved in the identification code information area as a specific data area for storing data identifiers corresponding to complex data; An MES scanning module uses a user MES device terminal to scan a product identification code in a product work order and execute a first data acquisition function; in the first data acquisition function, product difference data and product basic data are acquired based on the second positioning information; In the first data acquisition function, a data identifier corresponding to the complex data of the product is acquired based on the second positioning information; The MES retrieval module is used to search the target database based on the basic product data. If the retrieval is successful, the product general data is returned, and the product comprehensive data is constructed based on the product difference data and the product general data; the target database is searched based on the data identifier corresponding to the complex data. If the retrieval is successful, the product complex data is returned, and the product comprehensive data is constructed based on the product difference data, the product complex data and the product general data; MES processing module, used to perform MES system product inventory processing on products based on comprehensive product data; The rapid identification area includes, in addition to the second positioning information, a reserved area and a rapid identification data area. The reserved area is used to configure the necessary functions of the rapid identification area. The product difference data and product basic data are encoded and stored in the rapid identification data area. A server memory database is established on the MES system server side, and a local memory database is established on the MES system user MES device terminal. Based on the current working situation, the product general data set and the corresponding database table corresponding to the same or similar product types are pre-stored in the local memory database, thereby establishing a database quick table of the local memory database. When the basic product data obtained by the MES device terminal arrives, it is searched in the local memory database quick table first. If the corresponding data does not exist in the quick table, the server memory database is searched again. If the server memory database does not exist, the server regular database is searched again.

Images