MES (Manufacturing Execution System)-based work order retrieval and marking integrated processing method and device

Abstract

The invention provides a work order retrieval and marking integrated processing method and device based on an MES system, and the method comprises the steps: generating a product work order containing a product identification code, and the product identification code comprises second positioning information; a user MES equipment terminal is adopted to scan a product identification code in the product work order, and product difference data and product basic data are acquired 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 the product general data; and executing MES system product inventory processing. Therefore, the data acquisition and retrieval efficiency is improved, the work order generation efficiency is improved, and an 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 specifically, to a method and device for integrated processing of 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 digital management of enterprises, factories, warehouses, etc. MES refers to the Manufacturing Execution System, which is a set of production information management systems for the execution layer of enterprises and has important applications in aspects such as product data tracking, production manufacturing processes, production scheduling control solutions, construction status tracking, and production index analysis.

[0003] MES systems have powerful data processing capabilities. In a typical existing application scenario, the MES system introduces identification code technology to achieve rapid scanning, marking, and reporting (work reporting) of production transfer cards. In the production site (manufacturing workshop / warehouse, etc.), workers only need to use a mobile device to scan the work order identification code, and the system can automatically identify and obtain relevant production information and perform process processing. In the actual production process, we encountered the phenomenon of inefficient identification code data processing. Analyzing the reasons mainly includes three aspects: On the one hand, the conventional processing process of the identification code can be simplified as: identifying the identification code, parsing the identification code information, retrieving the database, and obtaining the data to be processed (such as data processing such as data warehousing, outbound, marking, and generating reports). This process has certain requirements for processing equipment. For example, a consumer-grade barcode scanner may take 0.5 - 2 seconds to complete the above process, with an obvious pause, which is obviously inefficient in a large-data-volume production scenario. For example, in a production process with low operation efficiency (long waiting time for equipment processing and pauses in business processes) and high concurrency, there will be data conflicts (inconsistent inbound and outbound data, repeated outbound of the same product, different products but corresponding to the same warehouse label). In the operation scenario of wireless terminal devices (currently, most MES front-end devices are based on wireless communication, such as enterprise work mobile phone devices / wireless barcode scanners, etc.), the above problems are particularly prominent.

[0004] On the second hand, multi-data work order data of the same product type (such as equipment products A and B of the same type, their production process data, inspection data, performance data, data templates required by the same distributor, etc.) are usually the same. In the actual work scenario, the product types faced by workers within a similar working time period are usually the same product type, resulting in a large amount of data redundancy in the processed data. Only using the steps of the conventional process will lead to low efficiency due to data redundancy.

[0005] The above two problems are common and hidden pain points faced by enterprises applying the MES system. Usually, using high-performance industrial-grade barcode scanning devices can reduce the processing time to the millisecond level, which can solve the above problems to a certain extent. However, the high cost brought by high performance is a new problem to be faced.

[0006] Thirdly, the phenomenon of inefficient identification code data processing is also reflected in that: in a regular work order, the storage byte number of the identification code can usually accommodate the corresponding data volume. However, for complex work orders, such as those containing complex text (such as complex processes / detailed instructions / warning protocols, etc.), attached drawings (such as product circuit diagrams / appearance diagrams / illustration diagrams), or special user requirements (such as certification seals / user-customized warehousing requirements, etc.), the existing identification codes are difficult to fully handle these problems, thus limiting the content of the product work order.

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

[0008] The present invention proposes an integrated processing method and system for work order retrieval and marking based on the MES system. It improves the second positioning information based on the existing identification code rules, configures a suitable database access method, and uses the identification code information delimited by the second positioning information to quickly obtain work order information, thereby improving the execution efficiency of the MES system terminal working device.

[0009] First, an embodiment of the present disclosure provides an integrated processing method for work order retrieval and marking based on the MES system. The method includes the steps: S100, generating a product work order containing a product identification code, where the product identification code includes second positioning information, and the second positioning information is used to store the location information of the product difference data and product basic data in the identification code; S110, using the user's MES device terminal to scan the product identification code in the product work order and execute the first data acquisition step; in the first data acquisition step, obtaining the product difference data and product basic data based on the second positioning information; S120, retrieving the target database based on the product basic data. In the case of successful retrieval, returning the product general data, and constituting the product comprehensive data based on the product difference data and the product general data; S130, performing MES system product inventory processing on the product based on the product comprehensive data.

[0010] Preferably, the method for generating the second positioning information is as follows: a quick recognition area is delimited within the identification code range. The dot matrices in the preset ranges at the upper left corner, upper right corner, and lower left corner of the quick recognition area are used as the range of the quick recognition area delimited by the second positioning information. In the quick recognition area, in addition to the second positioning information, there are also a reserved area and a quick recognition data area. The reserved area is used to configure the necessary functions of the quick recognition area, and the product difference data and product basic data are stored in the quick recognition data area after being encoded.

[0011] Preferably, the method for generating the second positioning information is as follows: define an identification code recognition protocol, and this recognition protocol stipulates the positioning coordinates of the quick recognition area. The positioning coordinates include the overall coordinate range of the quick recognition area, the coordinate of the reserved area in the quick recognition area, and the coordinate of the quick recognition data area.

[0012] Preferably, the method for generating the second positioning information is as follows: reserve a range in the identification code information area as the quick recognition data area, and dynamically configure the coordinates of this reserved range in the identification code function area.

[0013] Preferably, establish an in-memory database on the MES system server side. Based on the current working conditions, pre-store the product general data set corresponding to the same or similar product types and the corresponding database tables into the in-memory database, so as to establish a database fast table of the in-memory database. When the MES device terminal brings in the obtained product basic data, first retrieve it from the database fast table. If the corresponding data does not exist in the fast table, continue to retrieve it in the in-memory database. When the corresponding data does not exist in the in-memory database, continue to retrieve it in the regular database.

[0014] Preferably, establish an in-memory database on the MES system server side and establish a local in-memory database on the MES device terminal of the MES system user. Based on the current working conditions, pre-store the product general data set corresponding to the same or similar products and the corresponding database tables into the local in-memory database, so as to establish a database fast table of the local database. When the MES device terminal brings in the obtained product basic data, first retrieve it from the local in-memory database fast table. If the corresponding data does not exist in the fast table, continue to retrieve it in the server database.

[0015] Preferably, the processing is performed on complex work order data. Specifically, in step S100, it further includes: reserving a range in the identification code information area as a specific data area for storing the data identifier corresponding to the complex data; in step S110, it further includes: in the first data acquisition step, based on the second positioning information, acquiring product difference data, product basic data, and the data identifier corresponding to the complex data; in S120, it further includes: retrieving the target database based on the data identifier corresponding to the complex data, and in the case of successful retrieval, returning the product complex data, and forming the product comprehensive data based on the product difference data, product complex data, and product general data.

[0016] In a second aspect, an integrated processing device for work order retrieval and marking based on an MES system provided by an embodiment of the present disclosure includes: An identification code setting module, configured to generate a product work order including a product identification code, where the product identification code includes second positioning information for storing the location information of product difference data and product basic data in the identification code; An MES scanning module, which scans the product identification code in the product work order by using a user's MES device terminal and executes the 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; An MES retrieval module, configured to retrieve the target database based on the product basic data, and in the case of successful retrieval, return the product general data, and form the product comprehensive data based on the product difference data and the product general data; An MES processing module, configured to perform MES system product inventory processing on the product based on the product comprehensive data.

[0017] Preferably, the generation method of the second positioning information is: delineating a quick recognition area within the identification code range, and presetting the dot matrix in the upper left corner, upper right corner, and lower left corner of the quick recognition area as the range of the quick recognition area defined by the second positioning information. In the quick recognition area, in addition to the second positioning information, there are also a reserved area and a quick recognition data area. The reserved area is used to configure the necessary functions of the quick recognition area, and the product difference data and product basic data are stored in the quick recognition data area after being encoded.

[0018] Preferably, the generation method of the second positioning information is: defining an identification code recognition protocol, and this recognition protocol stipulates the positioning coordinates of the quick recognition area, where the positioning coordinates include the overall coordinate range of the quick recognition area, the coordinate of the reserved area in the quick recognition area, and the coordinate of the quick recognition data area.

[0019] Preferably, the method for generating the second positioning information is as follows: 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.

[0020] Preferably, establish an in-memory database on the MES system server side. Based on the current working conditions, pre-store the product general data set and the corresponding database tables corresponding to the same or similar product types into the in-memory database, so as to establish a database fast table of the in-memory database. When the MES device terminal receives the obtained product basic data, first retrieve it from the database fast table. If the corresponding data does not exist in the fast table, continue to retrieve it in the in-memory database. When the corresponding data does not exist in the in-memory database, continue to retrieve it in the regular database.

[0021] Preferably, establish an in-memory database on the MES system server side and establish a local in-memory database on the MES device terminal of the MES system user. Based on the current working conditions, pre-store the product general data set and the corresponding database tables corresponding to the same or similar products into the local in-memory database, so as to establish a database fast table of the local database. When the MES device terminal receives the obtained product basic data, first retrieve it from the local in-memory database fast table. If the corresponding data does not exist in the fast table, continue to retrieve it in the server database.

[0022] Preferably, process complex work order data. Specifically, in the identification code setting module, it further includes: Reserve a range in the identification code information area as a specific data area for storing the data identifiers corresponding to complex data; in the MES scanning module, it further includes: in the first data acquisition function, based on the second positioning information, obtain product difference data, product basic data, and the data identifiers corresponding to complex data; in the MES retrieval module, it further includes: retrieve the target database based on the data identifiers corresponding to complex data. In the case of successful retrieval, return the product complex data, and form product comprehensive data based on the product difference data, product complex data, and product general data.

[0023] The present invention provides a method and device for integrated processing of work order retrieval and marking based on the MES system, achieving at least the following technical effects: (1) Improve the product identification code of the product work order. Based on the second positioning information, it can only process the identification of some identification codes and only retrieve some data, improving the data acquisition and retrieval efficiency, thereby improving the work order generation efficiency; (2) Combine the improved identification code layout with the improved database configuration method to further improve the data acquisition efficiency; (3) Split the product work order data, providing an operation space for obtaining complex work order data while improving the data acquisition efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0024] Figure 1The flowchart shows the steps of an integrated processing method for work order retrieval and marking based on the MES system according to an embodiment of the present invention.

[0025] Figure 2 The block diagram shows an integrated processing method and device for work order retrieval and marking based on the MES system according to an embodiment of the present invention. Detailed implementation manners

[0026] 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 clearly and completely described below with reference to the accompanying drawings in the embodiments of the present application. Apparently, the described embodiments are some, but not all, of the embodiments of the present application. All other embodiments obtained by those of ordinary skill in the art based on the embodiments of the present application without creative efforts shall fall within the protection scope of the present application.

[0027] The terms "first", "second", "third", "fourth", etc. (if any) in the specification and claims of the present application and the above-mentioned drawings are used to distinguish similar objects and do not necessarily need to describe a specific order or sequence. It should be understood that such data can be interchanged under appropriate circumstances so that the embodiments of the present application described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "corresponding to" and any variations thereof are intended to cover non-exclusive inclusion. For example, a process, method, system, product, or device that includes a series of steps or units does not necessarily need to be limited to those steps or units clearly listed, but may include other steps or units not clearly listed or inherent to these processes, methods, products, or devices.

[0028] To make the objectives, technical solutions, and advantages of the present invention clearer and more understandable, the present invention will be further described in detail below with reference to embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention and are not used to limit the present invention.

[0029] Embodiment 1: As Figure 1 shown, the disclosed embodiment of the present invention provides an integrated processing method for work order retrieval and marking based on the MES system, including: S100, generating a product work order including a product identification code, where the product identification code includes second positioning information for storing the location information of product difference data and product basic data in the identification code.

[0030] The Product Identification Code is the key information used to uniquely identify and manage products. Different types are usually selected according to application scenarios, industry standards or technical requirements. Common product identification codes include Universal Standard Codes (such as European / Chinese barcodes), Technology and Automation Identification Codes (such as QR codes, Data Matrix codes), Industry-Specific Codes (such as Vehicle Identification Number VIN), etc. The integrated processing method of work order retrieval and marking based on the MES system provided in the embodiments of this application can be applied to the above-mentioned product identification codes according to the needs of the scenario, and this application does not limit this.

[0031] To better illustrate the present invention, taking the QR code as the identification code as an example, there are a total of 40 specifications of matrices for existing QR codes. Officially, they are called versions, that is, Version, and also known as QR code specifications. Different versions have different capacities for QR codes. The higher the version, the larger the capacity of the QR code, that is, the more content it can carry. For example, Version 10 can store about 1,200 bytes, and Version 40 can store about 3,000 bytes.

[0032] Taking the Version 2 QR code as an example, it is a 25×25 matrix, on which the first positioning information, function area, and information area are distributed. The first positioning information is usually in the upper left corner, upper right corner, and lower left corner, which is used to position the entire identification code and mark its size, so that the device can quickly locate and adjust the identification code. The function area is distributed at various predetermined positions and is used to configure the functions of the identification code, such as defining the format, version, error correction code, mask, etc., providing necessary and basic configuration information for the identification code. The information area is the area other than the first positioning information and the function area and is used to store the target data. In the embodiments 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 the product difference data and the product basic data in the identification code.

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

[0034] In a preferred embodiment, the method for generating the second positioning information is as follows: a quick recognition area is delimited within the identification code range. The dot matrices in the preset ranges at the upper left corner, upper right corner, and lower left corner of the quick recognition area are used as the range of the quick recognition area delimited by the second positioning information. In the quick recognition area, in addition to the second positioning information, there are also a reserved area and a quick recognition data area. The reserved area is used to configure the necessary functions of the quick recognition area, such as defining the format, version, error correction code, mask, etc.; the product difference data and product basic data are stored in the quick recognition data area after being encoded. This second positioning information refers to the original layout composition of the identification code, which is convenient for understanding and quick positioning, but there is a problem of occupying a relatively large layout space of the identification code and may affect data storage in some cases.

[0035] In a preferred embodiment, the method for generating the second positioning information is as follows: define an identification code recognition protocol, and this recognition protocol stipulates the positioning coordinates of the quick recognition area. The positioning coordinates include the overall coordinate range of the quick recognition area (such as the four-corner coordinates), the coordinates of the reserved area in the quick recognition area, and the coordinates of the quick recognition data area. The functions of the reserved area and the quick recognition data area are as described above and will not be elaborated here. This second positioning information saves space to a certain extent, but since the coordinate values need to be defined in the protocol, the decoding party needs to program the protocol in advance; in addition, the numerical type of coordinates may cause problems of inaccurate recognition and positioning in special cases such as unclear identification codes, and there is a certain degree of instability.

[0036] In a preferred embodiment, the method for generating the second positioning information is as follows: reserve a range in the identification code information area as the quick recognition data area (for storing the encoded data of the product difference data and product basic data), and dynamically configure the coordinates of this reserved range in the identification code function area. This method for generating the second positioning information only makes minor adjustments (for dynamically configuring coordinates) to the function area of the original layout of the identification code without involving other layout changes. Therefore, it makes the best use of the original identification code layout and improves adaptability. By dynamically configuring the coordinates of the reserved range in the information area, the layout space of the identification code is saved to the greatest extent and the storage efficiency is improved. However, this method does not completely break away from the original identification code recognition mechanism and still needs to decode some data in the information area. From this perspective, its performance improvement is not sufficient.

[0037] The setting of the second positioning information of the identification code delimits a quick recognition data area in the layout of the identification code for storing the product difference data and product basic data, effectively improving the identification efficiency of the identification code. Further, the three generation methods of the second positioning information realize the content of the second positioning information from different perspectives and at least partially solve the technical problems mentioned in the background art. It is one of the core concepts of the present invention.

[0038] S110. Use the user's MES device terminal to scan the product identification code in the product work order and perform the first data acquisition step. In the first data acquisition step, obtain product difference data and product basic data based on the second positioning information.

[0039] The user's MES device terminal includes a dedicated work mobile phone, a wired / wireless barcode scanner, etc. In the first data acquisition step, by listening to the input signal of the barcode scanning device, scan and parse the content of the product identification code. Based on the second positioning information in the identification code content, product difference data and product basic data can be quickly obtained. These data are used to reconstruct the complete product work order data. When the product is warehoused, the product work order data can be written into the database to represent the product warehousing status. At the same time, a product label can be generated based on the product work order data. When the product is shipped out, the product work order data can be updated from the database to indicate the product shipping status. When the scanning is completed, it can automatically jump to the obtained work order details page to display the product work order data.

[0040] S120. Retrieve the target database based on the product basic data. In the case of successful retrieval, return the product general data, and constitute the product comprehensive data based on the product difference data and the product general data.

[0041] Since the product basic data does not contain the complete product work order data, it is necessary to further retrieve the corresponding product work order data based on the product basic data, so as to jointly constitute the product comprehensive data with the product difference data. Continuing with the above example, the obtained product basic data contains S (basic data set) = {sb, sc, sd}. The MES device terminal forwards the obtained product basic data to the MES system server side for general data retrieval. Based on the product basic data sb, SB (process data set) = {b1, b2,..., bn} in the general data set is retrieved. Based on the product basic data sc, SC (product specification data set) = {c1, c2,..., cn} in the general data set is retrieved. Based on the product basic data sd, SD (product time data set) = {d1, d2,..., dn} in the general data set is retrieved. In the case of successful retrieval, return the product general data, and constitute the product comprehensive data based on the product difference data and the product general data for subsequent inventory operations.

[0042] The configuration of the database is related to the recognition effect of the identification code. Generally speaking, the latency of queries in memory and above (caches at all levels) is in the nanosecond range, the latency of conventional SSD queries is in the microsecond range, and the latency of conventional HDD queries is in the millisecond range. Taking a storage medium of millions of data volumes / HDD as an example, in the case of establishing a B+ tree retrieval index (without full disk scanning), the execution of a simple query takes about milliseconds, and in the optimal case (such as establishing reasonable indexes / primary and foreign keys and with memory hits), it can reach the microsecond range. Therefore, it generally meets the needs of regular work. However, in practice, there are poor cases, such as no index, unreasonable index, poor storage medium quality, unoptimized data structure, etc., where the retrieval of the database may be sluggish, so further optimization is required.

[0043] In a preferred embodiment, an in-memory database is established on the MES system server side. For example, the in-memory database can be a Redis database, and a product general data set and the corresponding database tables are pre-stored. In work practice, products of the same type usually perform inventory operations in a similar time period. Therefore, based on the current working situation, the product general data set and the corresponding database tables corresponding to the same or similar product types can be stored in the in-memory database, thereby establishing a database fast table in the in-memory database. When the MES device terminal receives the obtained product basic data, it first retrieves from the database fast table. If the corresponding data does not exist in the fast table, it continues to retrieve in the in-memory database. When the corresponding data does not exist in the in-memory database, it continues to retrieve in the conventional database. Establishing a corresponding database fast table based on the current working situation significantly improves the retrieval efficiency and reduces the retrieval response time.

[0044] In a preferred embodiment, a local database is established on the MES device terminal of the MES system user. The performance of the MES device terminal of the user is relatively low and the storage space is limited. A lightweight database can be established to store key data and highly popular data to improve the data retrieval efficiency. Similarly, a product general data set and the corresponding database tables are pre-stored locally on the MES device terminal of the user. Based on the current working situation, the product general data set and the corresponding database tables corresponding to the same or similar products are stored in the local database, thereby establishing a database fast table in the local database. When the MES device terminal receives the obtained product basic data, it first retrieves from the local database fast table. If the corresponding data does not exist in the fast table, it continues to retrieve in the local database. Establishing a local lightweight database further significantly reduces the network transmission time, improves the retrieval efficiency, and reduces the retrieval response time.

[0045] In a preferred embodiment, complex work order data is processed. Specifically: in step S100, it further 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 attached drawing data, etc.), and dynamically configuring the coordinates of the reserved range in the identification code function area. Further, in step S110, it further includes: in the first data acquisition step, based on the second positioning information, product difference data, product basic data, and data identifiers corresponding to complex data are acquired. Further, in S120, it further includes: retrieving the target database based on the data identifiers corresponding to the complex data, and in the case of successful retrieval, returning the product complex data, and constituting the product comprehensive data based on the product difference data, product complex data, and product general data.

[0046] The configuration of the database and the improvement of the identification code jointly achieve fast acquisition of work order data. The two complement each other and jointly constitute the core inventive point of the present invention.

[0047] In another aspect, in the case of unsuccessful retrieval or retrieval timeout, the information area of the identification code is further parsed. After complete parsing, the product comprehensive data is acquired and the subsequent steps are entered.

[0048] S130, perform MES system product inventory processing on the product based on the product comprehensive data.

[0049] After obtaining the product comprehensive data, corresponding inventory processing can be performed. For example, after scanning products for production completion, purchase arrival, return products, and quality inspection completion, an inbound operation is performed, and at the same time, the items are shelved or stored to keep the status of the database data consistent with the warehousing situation; when shipping and selling, or allocating goods, an outbound operation is performed on the corresponding products, and at the same time, the inventory is deducted to keep the status of the database data consistent with the warehousing situation. Inventory processing also includes other related operations, such as inventory data viewing, previewing, verification, etc., including one-key work order data preview and printing functions.

[0050] In a preferred embodiment, a built-in label template engine is provided for automatic binding with work order data. Key parameters such as product model and batch are obtained through the interface provided by the MES system, and the preview interface is determined based on the template required by the user. Functions such as real-time editing, error checking, and one-key printing are supported. The one-key printing function requires configuring a print instruction direct channel to drive the printer.

[0051] In a preferred embodiment, the product inventory operation includes different types of marking operations such as harness identification / bag label / box label, etc. Different customers have different template requirements for different labels / or products. Therefore, before retrieval, the following steps are executed: The user sets a work order template, and the work order template includes the required fields for display. When retrieving in the database, retrieval filtering is performed based on the fields included in the work order template set by the user, so as to meet customer needs while reducing the retrieval workload and retrieval response time.

[0052] Embodiment 2: As Figure 2 shown, the present invention also provides an integrated processing device for work order retrieval and marking based on the MES system, including: An identification code setting module, used to generate a product work order containing a product identification code, where the product identification code includes second positioning information, and the second positioning information is used to store the location information of product difference data and product basic data in the identification code; An MES scanning module, which uses the user's MES device terminal to scan the product identification code in the product work order and execute the 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; An MES retrieval module, used to retrieve the target database based on the product basic data. In the case of successful retrieval, product general data is returned, and product comprehensive data is formed based on the product difference data and the product general data; An MES processing module, used to execute MES system product inventory processing on the product based on the product comprehensive data.

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

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

[0055] In a preferred embodiment, the method for generating the second positioning information is: reserving a range in the identification code information area as the quick recognition data area, and dynamically configuring the coordinates of this reserved range in the identification code function area.

[0056] In a preferred embodiment, an in-memory database is established on the MES system server side. Based on the current working conditions, the product general data set corresponding to the same or similar product types and the corresponding database tables are pre-stored in the in-memory database, thereby establishing a database fast table of the in-memory database. When the MES device terminal receives the obtained product basic data, it first retrieves from the database fast table. If the corresponding data does not exist in the fast table, it continues to retrieve in the in-memory database. When the corresponding data does not exist in the in-memory database, it continues to retrieve in the regular database.

[0057] In a preferred embodiment, an in-memory database is established on the MES system server side, and a local in-memory database is established on the MES device terminal of the MES system user. Based on the current working conditions, the product general data set corresponding to the same or similar products and the corresponding database tables are pre-stored in the local in-memory database, thereby establishing a database fast table of the local database. When the MES device terminal receives the obtained product basic data, it first retrieves from the local in-memory database fast table. If the corresponding data does not exist in the fast table, it continues to retrieve in the server database.

[0058] In a preferred embodiment, complex work order data is processed. Specifically: in the identification code setting module, it further includes: reserving a range in the identification code information area as a specific data area for storing the data identifiers corresponding to the complex data; in the MES scanning module, it further includes: in the first data acquisition function, based on the second positioning information, obtaining product difference data, product basic data, and the data identifiers corresponding to the complex data; in the MES retrieval module, it further includes: retrieving the target database based on the data identifiers corresponding to the complex data. In the case of successful retrieval, returning the product complex data, and constructing product comprehensive data based on the product difference data, product complex data, and product general data.

[0059] The present invention provides a method and device for integrated processing of work order retrieval and marking based on the MES system, achieving at least the following technical effects: (1) improving the product identification code of the product work order, based on the second positioning information, being able to perform identification processing on only some identification codes and retrieving only some data, improving the data acquisition and retrieval efficiency, thereby improving the work order generation efficiency; (2) combining the improved identification code layout with the improved database configuration method to further improve the data acquisition efficiency; (3) splitting the product work order data, while improving the data acquisition efficiency, being able to provide an operation space for obtaining complex work order data.

[0060] 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 software as described above), which when executed by the machine, cause the machine to execute each of the embodiments in this specification as described above in combination withFigure 1 The various operations and functions described. Specifically, a system or device with a readable storage medium can be provided, on which software program codes for implementing the functions of any one of the above embodiments are stored, and the computer or processor of the system or device is made to read and execute the instructions stored in the readable storage medium.

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

[0062] Examples of the readable storage medium include floppy disks, hard disks, magneto-optical disks, optical disks (such as CD-ROM, CD-R, CD-RW, DVD-ROM, DVD-RAM, DVD-RW, DVD-RW), magnetic tapes, non-volatile memory cards, and ROMs. Optionally, the program code can be downloaded from a server computer or a cloud via a communication network.

[0063] Those skilled in the art should understand that various modifications and variations can be made to the above-disclosed embodiments without departing from the essence of the invention. Therefore, the protection scope of this specification should be defined by the appended claims.

[0064] It should be noted that not all steps and units in the above-mentioned processes and system structure diagrams are necessary, and some steps or units can be ignored according to actual needs. The execution order of each step is not fixed and can be determined as needed. The device structures described in the above embodiments can be physical structures or logical structures. That is, some units may be implemented by the same physical entity, or some units may be implemented separately by multiple physical entities, or some components in multiple independent devices can be jointly implemented.

[0065] In the above embodiments, the hardware units or modules can be implemented mechanically or electrically. For example, a hardware unit, module, or processor can include permanent dedicated circuits or logics (such as dedicated processors, FPGAs, or ASICs) to complete corresponding operations. The hardware unit or processor can also include programmable logics or circuits (such as general-purpose processors or other programmable processors), which can be temporarily set by software to complete corresponding operations. The specific implementation method (mechanical method, or dedicated permanent circuit, or temporarily set circuit) can be determined based on cost and time considerations.

[0066] The specific embodiments described above in conjunction with the accompanying drawings describe exemplary embodiments, but do not represent all embodiments that can be implemented or fall within the scope of the claims. The term "exemplary" used throughout this specification means "serving as an example, instance, or illustration" and does not mean "preferred" or "advantageous" over other embodiments. For the purpose of providing an understanding of the described technology, the specific embodiments include specific details. However, the technology can be practiced without these specific details. In some instances, well-known structures and devices are shown in block diagram form to avoid obscuring the concepts of the described embodiments.

[0067] The foregoing description of the disclosure has been provided to enable any ordinary skill in the art to make or use the disclosure. Various modifications to the disclosure will be readily apparent to those of ordinary skill in the art, and the generic principles herein can be applied to other variations without departing from the scope of the disclosure. Thus, the disclosure is not limited to the examples and designs described herein, but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. An integrated processing method for work order retrieval and marking based on the MES system, characterized in that, The method includes: S100, generating a product work order including a product identification code, where the product identification code includes second positioning information for storing the location information of product difference data and product basic data in the identification code; S110, using a user's MES device terminal to scan the product identification code in the product work order and performing a first data acquisition step; in the first data acquisition step, acquiring product difference data and product basic data based on the second positioning information; S120, retrieving a target database based on the product basic data, and when the retrieval is successful, returning product general data, and constituting product comprehensive data based on the product difference data and the product general data; S130, performing MES system product inventory processing on the product based on the product comprehensive data.

2. The method according to claim 1, characterized in that: The method for generating the second positioning information includes: Defining a quick recognition area within the identification code range. The upper left preset range dot matrix, upper right preset range dot matrix, and lower left preset range dot matrix in the quick recognition area are used as the range of the quick recognition area defined by the second positioning information. In the quick recognition area, in addition to the second positioning information, there are also a reserved area and a quick recognition data area. The reserved area is used to configure the necessary functions of the quick recognition area, and the product difference data and product basic data are stored in the quick recognition data area after being encoded.

3. The method according to claim 1, wherein The method further includes: Establishing an in-memory database on the MES system server side. Based on the current working conditions, pre-storing the product general data set corresponding to the same or similar product types and the corresponding database tables into the in-memory database, thereby establishing a database fast table of the in-memory database. When the product basic data obtained by the MES device terminal arrives, first retrieve it from the database fast table. If the corresponding data does not exist in the fast table, continue to retrieve it in the in-memory database. When the corresponding data does not exist in the in-memory database, continue to retrieve it in the regular database.

4. The method according to claim 1, wherein The method further includes: Establishing an in-memory database on the MES system server side and establishing a local in-memory database on the MES device terminal of the MES system user. Based on the current working conditions, pre-storing the product general data set corresponding to the same or similar products and the corresponding database tables into the local in-memory database, thereby establishing a database fast table of the local database. When the product basic data obtained by the MES device terminal arrives, first retrieve it from the local in-memory database fast table. If the corresponding data does not exist in the fast table, continue to retrieve it in the server database.

5. The method according to claim 1, wherein Processing complex work order data, specifically including: In step S100, it further includes: reserving a range in the identification code information area as a specific data area for storing the data identifier corresponding to the complex data; in step S110, it further includes: in the first data acquisition step, acquiring product difference data, product basic data, and the data identifier corresponding to the complex data based on the second positioning information; in step S120, it further includes: retrieving the target database based on the data identifier corresponding to the complex data, and when the retrieval is successful, returning the product complex data, and constituting product comprehensive data based on the product difference data, the product complex data, and the product general data.

6. An integrated processing device for work order retrieval and marking based on the MES system, characterized in that, The device includes the following modules: An identification code setting module, configured to generate a product work order containing a product identification code, where the product identification code includes second positioning information for storing the location information of product difference data and product basic data in the identification code; An MES scanning module, which uses a user's MES device terminal to scan the product identification code in the 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; An MES retrieval module, configured to retrieve a target database based on the product basic data, and in case of successful retrieval, return product general data and form product comprehensive data based on the product difference data and the product general data; An MES processing module, configured to perform MES system product inventory processing on the product based on the product comprehensive data.

7. The device according to claim 6, characterized in that: The method for generating the second positioning information includes: Define a quick identification area within the identification code range. The upper left preset range dot matrix, upper right preset range dot matrix, and lower left preset range dot matrix of the quick identification area are used as the range of the quick identification area circled by the second positioning information. In the quick identification area, in addition to the second positioning information, there are also 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 stored in the quick identification data area after being encoded.

8. The device according to claim 6, wherein: Establish an in-memory database on the MES system server side. Based on the current working conditions, pre-store the product general data set corresponding to the same or similar product types and the corresponding database tables into the in-memory database, so as to establish a database fast table of the in-memory database. When the MES device terminal brings in the acquired product basic data, first retrieve it from the database fast table. If the corresponding data does not exist in the fast table, continue to retrieve it in the in-memory database. When the corresponding data does not exist in the in-memory database, continue to retrieve it in the regular database.

9. The device according to claim 6, characterized in that: Establish an in-memory database on the MES system server side and establish a local in-memory database on the MES device terminal of the MES system user. Based on the current working conditions, pre-store the product general data set corresponding to the same or similar products and the corresponding database tables into the local in-memory database, so as to establish a database fast table of the local database. When the MES device terminal brings in the acquired product basic data, first retrieve it from the local in-memory database fast table. If the corresponding data does not exist in the fast table, continue to retrieve it in the server database.

10. The device according to claim 6, characterized in that: Process complex work order data, specifically including: In the identification code setting module, it also includes: Reserve a range in the identification code information area as a specific data area for storing the data identifiers corresponding to complex data; In the MES scanning module, it also includes: In the first data acquisition function, based on the second positioning information, obtain product difference data, product basic data, and the data identifiers corresponding to complex data; In the MES retrieval module, it also includes: Retrieve the target database based on the data identifiers corresponding to complex data. In the case of a successful retrieval, return the product complex data, and form the product comprehensive data based on the product difference data, product complex data, and product general data.

Images