A Flexible Query Method for End-to-End Production History Based on Unified Plan Number

Abstract

This invention relates to the field of industrial MES (Manufacturing Execution System) production management technology. Addressing industry pain points such as the need for manual volume number differentiation in traditional production history queries, cumbersome operations, rigid query conditions, unstable system architecture, and difficulties in full-process traceability, this invention proposes a flexible full-link production history query method based on a unified plan number. This invention uses the plan number and volume number as unique identifiers for the entire production process. It achieves integrated front-end and back-end interaction through universal table-value parameters. The front-end only collects parameters, without business logic or SQL concatenation; the back-end uses stored procedures to complete intelligent volume number recognition, automatic data calibration, flexible multi-condition filtering, and full-history data query. Users do not need to distinguish between raw material and finished product volume numbers; they can perform queries based on any combination of unit, time, and volume number, automatically skipping null conditions, and obtaining full-process production history data with one click. This invention features a unified architecture, stable operation, extremely simple operation, high query efficiency, and strong adaptability. It can be widely applied to industrial manufacturing scenarios such as metallurgy and sheet metal processing, significantly improving production traceability efficiency and system stability.

Description

Technical Field

[0001] This invention belongs to the technical field of industrial production management MES system, specifically involving an integrated method for data traceability, history query, and intelligent screening throughout the entire production process, which is particularly suitable for continuous production industries such as metallurgy, cold rolling, galvanizing, and tin plating. Background Technology

[0002] Current industrial production management systems generally suffer from the following technical deficiencies in the process of production history inquiry and quality traceability: 1. Traditional systems require manual differentiation between raw material roll numbers and finished product roll numbers, which is cumbersome and prone to errors. 2. Production data lacks a unified and unique identifier, and data from each process is scattered, making it impossible to achieve one-click full-chain traceability; 3. The query conditions are fixed and rigid, and do not support free combination or ignore null values, resulting in extremely poor flexibility. 4. The front end involves a large number of SQL statements, resulting in scattered business logic, making the system prone to errors, difficult to maintain, and with low stability. 5. The lack of an automatic calibration mechanism for the data, as well as missing data and incomplete fields, affects the accuracy of query results.

[0003] The aforementioned problems result in low production traceability efficiency, high operating costs, and poor system robustness, failing to meet the actual needs of efficient, simple, and stable use in industrial settings. Summary of the Invention

[0004] Purpose of the invention This invention aims to solve the technical problems of existing traditional production management systems, such as cumbersome querying, incomplete traceability, loose architecture, poor stability, and complex operation. It provides a production history query method that is extremely simple to operate, intelligently identified, has a unified architecture, is highly efficient in querying, and allows for full-link traceability. Technical solution

[0005] This invention uses a unified plan number and volume number as its core to construct a unique identifier system across the entire chain. Combined with a front-end and back-end integrated architecture of the Universal Table Value Parameter (TVP), it enables flexible and intelligent querying. ① Unified Identification: The plan number and volume number are used to connect the entire process of raw materials, production, units, and finished products, so as to achieve full data association; ② Intelligent recognition: Automatically identifies raw material / finished product roll numbers, eliminating the need for manual differentiation and providing one-click location of data throughout the entire process; ③ Flexible query: Supports arbitrary combinations of unit, time, and volume number, automatically skips null values, and adapts to all query scenarios; ④ Pure front-end and back-end separation architecture: The front-end only collects parameters, with no SQL, no logic, and zero errors; ⑤ Automatic data calibration: Automatically completes the unit serial number to ensure data integrity and standardization; ⑥ Unified stored procedure logic: All calculations, verifications, queries, and sorting are centralized in the backend, ensuring high efficiency and stability.

[0006] 1. The front end loads unit data, with a default initialization time, and supports multi-select and all-select operations; 2. Users select query criteria, which are then encapsulated by the system into a single, general-purpose table parameter; 3. The backend receives the parameters, checks if they are not empty, and then executes the logic. 4. Obtain the unified plan number based on the input volume number; 5. Automatically complete missing data; 6. Dynamic combination query with multiple conditions; 7. Return and display the complete production history. Beneficial effects

[0007] 1. Extremely simple operation: No professional training required, one-click query of the entire production history, greatly reducing the cost of use; 2. Intelligent recognition: Automatically distinguishes between raw material and finished product roll numbers, eliminating human error and achieving 100% accuracy; 3. End-to-end traceability: The entire process is connected by a unified plan number, ensuring a complete, uninterrupted, and complete record; 4. Extremely stable architecture: The front end has no business logic, the back end has unified management, the system is not prone to errors and is extremely easy to maintain; 5. Highly flexible query: Any combination of conditions, no filtering of null values, fully adaptable to all query scenarios in industrial settings; 6. Automatic Data Standardization: Automatically calibrates and completes data to improve data accuracy and display standardization; 7. Highly versatile: Applicable to various continuous production and manufacturing industries, it can be directly reused and quickly deployed. Detailed Implementation

[0008] 1. Establish a production process data table, using the plan number and roll number as the primary key, and linking information on the unit, time, raw materials, and finished products; 2. Create a generic four-field table value parameter type for unified data interaction between the front-end and back-end; 3. The front-end interface implements parameter selection, data acquisition, parameter encapsulation and transmission; 4. The backend stored procedure implements parameter parsing, volume number matching, data calibration, and dynamic conditional query; 5. A null value judgment mechanism is used to achieve flexible filtering of conditions; if the condition is not met, it is skipped. 6. Finally, sort the data in chronological order and output a complete, standardized, and directly usable production history dataset.

Claims

1. A flexible query method for the entire production history based on a unified plan number, characterized in that, Includes the following steps: (1) Use the plan number and volume number as the unique core identifier for the entire production process to establish a full-link data association for raw materials, processes, units, and finished products; (2) The front end collects information on the unit, time range, and volume number, encapsulates it into a single general table value parameter, and transmits it to the back end; (3) After receiving the parameters, the backend performs intelligent recognition on the input volume number and automatically matches the corresponding unique plan number volume number; (4) Construct multi-condition combination query rules for unit, time and plan number, and exclude null value conditions from filtering to achieve flexible query; (5) Perform automatic data calibration and completion, and then output a complete and standardized end-to-end production history dataset.

2. The method according to claim 1, characterized in that, The system can automatically recognize and match either the raw material roll number or the finished product roll number entered by the user, eliminating the need for manual differentiation of roll number types.

3. The method according to claim 1, characterized in that, The front-end and back-end only use a single, universal four-field table value parameter for interaction, and the front-end has no SQL statements, no logical calculations, and no conditional concatenation.

4. The method according to claim 1, characterized in that, It supports selecting individual generator sets, selecting individual time periods, entering individual volume numbers, or querying using any combination of multiple conditions.

5. The method according to claim 1, characterized in that, All business logic, validation, data calibration, and sorting queries are executed within the backend stored procedure.

6. The method according to claim 1, characterized in that, Before querying, missing unit serial numbers are automatically filled and calibrated to ensure data integrity and sorting standardization.