Steel multi-product production order merging method, system, equipment and medium

Abstract

The invention discloses a steel multi-product production order merging method, system and device and a medium, and relates to the technical field of manufacturing industry and information, and the method comprises the steps: obtaining a plurality of sales order line items, and determining at least one production order corresponding to each sales order line item based on a preset order design rule; verifying the production order based on a preset product definition rule, and adding a to-be-merged mark to the production order under the condition that the production order does not meet a preset first condition; on the basis of rule types in a merging rule, continuously grouping the production orders with the to-be-merged marks for at least two times so as to screen out a target grouping set meeting a merging condition step by step, and the merging rule comprises at least two rule types; and merging the production orders in the target grouping set to obtain a merged production order, and marking the merged production order as a merged production order.

Description

Technical Field

[0001] This application relates to the fields of manufacturing and information technology, and in particular to a method, system, equipment and medium for merging production orders for multiple steel products. Background Technology

[0002] Currently, steel manufacturing enterprises generally possess large-scale, continuous production lines, and their equipment and process designs are typically optimized for mass production of standard products. However, with increasingly diversified and personalized market demands, sales orders from downstream customers are showing a trend towards smaller batches, more varieties, and more specifications. This change has resulted in a large number of scattered orders filling production plans, severely impacting the traditional batch production organization model based on units or production lines, making production scheduling exceptionally complex and difficult.

[0003] However, under the premise of meeting customer needs and ensuring product quality, achieving efficient order consolidation, reducing production costs, improving resource utilization efficiency, shortening production cycles, and enhancing the competitiveness and economic benefits of enterprises are challenges faced by steel companies. Summary of the Invention

[0004] The summary section introduces a series of simplified concepts, which will be further explained in detail in the detailed description section. This summary section is not intended to limit the key and essential technical features of the claimed technical solution, nor is it intended to determine the scope of protection of the claimed technical solution.

[0005] In a first aspect, embodiments of this application provide a method for merging production orders for multiple steel products, the method comprising:

[0006] Obtain multiple sales order line items and determine at least one production order corresponding to each sales order line item based on preset order design rules;

[0007] The production order is validated based on preset product definition rules. If the production order does not meet the preset first condition, the production order is marked as to be merged.

[0008] Based on the rule type in the merging rules, production orders with the mark to be merged are grouped at least twice consecutively to progressively filter out the target group set that meets the merging conditions. The merging rules include at least two rule types.

[0009] The production orders in the target group set are merged to obtain merged production orders, and the merged production orders are marked as merged.

[0010] In one embodiment of the present invention, the step of verifying the production order based on preset product definition rules, and adding a "to be merged" mark to the production order if the production order does not meet a preset first condition, includes:

[0011] Based on the product definition rules, determine the input product parameters of the production order at the input end of the target unit;

[0012] The input product parameters are compared with a preset first condition. When the number of blocks in the input product parameters is a single block and the weight parameter in the input product parameters is less than a preset weight threshold, the production order is marked as pending merging.

[0013] In one embodiment of the present invention, the rule type includes unit rules, quality rules, or delivery date rules. The step of grouping production orders with the pending-merge marker at least twice consecutively based on the rule type in the merging rules to progressively filter out the target group set that meets the merging conditions includes:

[0014] Based on the unit rules, production orders with the merging marker are grouped for the first time to obtain a first group set;

[0015] Based on the quality rules, the production orders in the first group set are grouped a second time to obtain the second group set;

[0016] Based on the delivery date rules, the production orders in the second group set are grouped a third time to obtain the target group set.

[0017] In one embodiment of the present invention, the first grouping of production orders with the merging mark based on the unit rules to obtain a first group set includes:

[0018] Based on the unit rules, the designated input product identifier at the input end and the designated output product identifier at the output end of the target unit are determined.

[0019] Filter the production orders with the specified input product identifier and output product identifier of the target unit from the production orders with the specified merge mark;

[0020] The filtered production orders are grouped into the same group to form the first group set.

[0021] In one embodiment of the present invention, the step of performing a second grouping of production orders in the first grouping set based on the quality rules to obtain a second grouping set includes:

[0022] Based on the quality rules, determine the quality parameters of the production orders in the first group set and the parameter types corresponding to the quality parameters;

[0023] When multiple production orders correspond to the same parameter type, the production orders with the same quality parameters corresponding to the parameter type are grouped into the same group to obtain a second group set;

[0024] When the parameter type is a value set group, production orders whose quality parameters corresponding to the parameter type belong to the same preset value set group are grouped into the same group to obtain a second group set.

[0025] In one embodiment of the present invention, the step of performing a third grouping of production orders in the second grouping set based on the delivery date rule to obtain the target grouping set includes:

[0026] Obtain the delivery dates of the production orders in the second group set;

[0027] Use the earliest delivery date in the second group set as the base date;

[0028] The maximum delivery date is determined based on the absolute difference in days preset in the delivery rules.

[0029] Production orders with delivery dates between the base date and the maximum delivery date are grouped into the same group to form the target group set.

[0030] In one embodiment of the present invention, the rule type further includes constraint rules or merging rules, wherein merging production orders in the target group set to obtain merged production orders and marking the merged production orders as merged includes:

[0031] Based on the constraint rules, the production orders in the target group set are parameter-validated to determine the candidate order set that passes the constraint check;

[0032] Based on the parameter determination method preset in the merging rules, target merging combinations that meet the requirements of material input range and output range are selected from the candidate order set;

[0033] Based on the material input parameters and output parameters of all production orders in the target merged combination, determine the total material input and total output of the merged production orders;

[0034] Based on the total amount of input and the total amount of output, a merged production order is determined, and the production orders included in the target merged combination are marked as merged.

[0035] Secondly, this application proposes a steel multi-product production order merging system, the system comprising: a verification module, a grouping module, and a merging module;

[0036] The verification module is configured to: acquire multiple sales order line items, and determine at least one production order corresponding to each sales order line item based on preset order design rules; verify the production order based on preset product definition rules, and add a "to be merged" mark to the production order if the production order does not meet the preset first condition;

[0037] The grouping module is configured to: based on the rule type in the merging rules, perform at least two consecutive groupings on production orders with the mark to be merged, so as to filter out the target group set that meets the merging conditions step by step; the merging rules include at least two rule types.

[0038] The merging module is configured to merge production orders in the target group set to obtain merged production orders, and mark the merged production orders as merged.

[0039] Thirdly, an electronic device includes: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program stored in the memory to implement the steps of a steel multi-product production order consolidation method as described in any of the first aspects above.

[0040] Fourthly, this application also proposes a computer-readable storage medium having a computer program stored thereon, wherein when the computer program is executed by a processor, it implements the steps of the steel multi-product production order merging method of any one of the first aspects.

[0041] In summary, the steel multi-product production order merging method of this application obtains sales order line items and automatically generates production orders according to preset order design rules. The production orders are then verified and marked to effectively identify orders that need to be merged due to uneconomical production parameters. By performing at least two consecutive groupings on the orders to be merged using various rule types, a multi-dimensional and precise screening process is achieved, considering factors such as production processes, quality requirements, and delivery dates, ensuring the rationality and effectiveness of the merging basis. Finally, the optimal order combination is merged and its status is updated. This significantly reduces reliance on manual experience, solves the problem of fragmented production resources caused by small-batch orders, and thus, while meeting diverse customer needs, greatly improves unit utilization and scheduling efficiency, and reduces production costs and unit energy consumption.

[0042] The method for consolidating production orders for multiple steel products proposed in this application, along with other advantages, objectives, and features of this application, will be partly apparent from the following description and partly understood by those skilled in the art through study and practice of this application. Attached Figure Description

[0043] Various other advantages and benefits will become apparent to those skilled in the art upon reading the following detailed description of preferred embodiments. The accompanying drawings are for illustrative purposes only and are not intended to limit this specification. Furthermore, the same reference numerals denote the same parts throughout the drawings. In the drawings:

[0044] Figure 1 This application provides a flowchart illustrating a method for merging multiple steel product production orders.

[0045] Figure 2 This is a schematic diagram of a steel multi-product production order merging system provided in an embodiment of this application. Detailed Implementation

[0046] To better understand the technical solutions provided in the embodiments of this specification, the technical solutions of the embodiments of this specification will be described in detail below with reference to the accompanying drawings and specific embodiments. It should be understood that the embodiments of this specification and the specific features in the embodiments are detailed descriptions of the technical solutions of the embodiments of this specification, rather than limitations on the technical solutions of this specification. In the absence of conflict, the embodiments of this specification and the technical features in the embodiments can be combined with each other.

[0047] In this document, relational terms such as "first" and "second" are used merely to distinguish one entity or operation from another, without necessarily requiring or implying any such actual relationship or order between these entities or operations. Furthermore, the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such a process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one..." does not exclude the presence of other identical elements in the process, method, article, or apparatus that includes said element. The term "two or more" includes two or more cases.

[0048] Please see Figure 1 This is a flowchart illustrating a method for merging multiple steel product production orders, provided in an embodiment of this application. The method specifically includes:

[0049] S110. Obtain multiple sales order line items and determine at least one production order corresponding to each sales order line item based on preset order design rules;

[0050] For example, multiple sales orders from customers are acquired, each sales order comprising multiple sales order line items. Based on preset order design rules, each sales order line item is automatically converted into one or more corresponding production orders. These order design rules predefine the complete product spectrum and attributes from raw materials and semi-finished products to finished products, and clarify the logical relationships between the input and output materials of different units on each production line. Based on these rules, the entire production process and intermediate products required to complete a specific sales order line item can be automatically deduced. This accurately decomposes the customer's requirements for the final delivered product into a series of specific, executable production tasks, laying the data foundation for subsequent order consolidation processing.

[0051] S120. The production order is verified based on the preset product definition rules. If the production order does not meet the preset first condition, the production order is marked as to be merged.

[0052] For example, based on a preset first condition in the product definition rules, the generated production orders are automatically verified. Specifically, by parsing the material parameters of the production order at the target unit input end, it is compared with the preset first condition; that is, when it is identified that the number of input material blocks in a production order is a single block and its weight parameter is lower than the preset economic production threshold, the system determines that the order needs to be merged due to uneconomical production scale, and then automatically adds a merge mark to it. Here, a normal sales order line item can be converted into one or more corresponding production orders, but for production orders to be merged, the system will automatically process one sales order line item corresponding to one production order. Specifically: when one sales order line item corresponds to multiple production orders, based on the process priority index pre-stored in the order design rules, the process with the best process priority index is set as the main process, and one of the multiple production orders is set as the main process, and the other production orders are set as auxiliary processes. When adding merge marks to production orders, for production orders set as the main process, the added mark is "Main Process Production Order", and for production orders set as auxiliary processes, the added mark is "Auxiliary Process Production Order". This verification and marking mechanism provides an accurate input source for the subsequent order merging process, ensuring the necessity and relevance of the merging operation.

[0053] S130. Based on the rule type in the merging rules, the production orders with the mark to be merged are grouped at least twice consecutively to filter out the target group set that meets the merging conditions step by step. The merging rules include at least two rule types.

[0054] For example, by invoking preset merging rules, a progressive multi-level grouping and filtering mechanism is implemented for production orders marked as to be merged, based on various rule types defined therein. This process uses rules of different dimensions such as unit, quality, or delivery date as continuous filtering conditions. Each level of grouping is based on the results of the previous level of grouping, thus acting as a multi-level filter to gradually narrow down the range of candidate orders. Ultimately, it accurately locates the set of orders that best match multiple constraints such as unit capacity, quality attributes, and delivery time, laying the core foundation for the subsequent generation of feasible merged production plans.

[0055] S140. Merge the production orders in the target group set to obtain merged production orders, and mark the merged production orders as merged.

[0056] For example, after obtaining the target group set after multiple rounds of screening, the final order merging operation is performed based on preset merging rules. This process first performs final consistency verification on the key production parameters of orders within the group according to constraint rules, ensuring their merging capability within the allowable tolerance range. Then, based on the parameter calculation logic defined in the merging rules, the verified orders are combined for optimization, finding the optimal order combination that simultaneously meets the unit's material input and output capacity ranges. Finally, based on the optimization results, new merged production orders are automatically generated, and the relevant order status is updated synchronously. Successfully merged original orders are marked as merged. It is important to note that during the merging process, only "master process production orders" marked as to be merged are merged, thus completing the entire closed-loop process from order screening to merging execution.

[0057] In summary, the steel multi-product production order merging method proposed in this application obtains sales order line items and automatically generates production orders according to preset order design rules. The production orders are then verified and marked to effectively identify orders that need to be merged due to uneconomical production parameters. By performing at least two consecutive groupings on the orders to be merged using various rule types, precise screening is achieved across multiple dimensions, from production processes and quality requirements to delivery dates, ensuring the rationality and effectiveness of the merging basis. Finally, the optimal order combination is merged and its status is updated. This significantly reduces reliance on manual experience, solves the problem of production resource fragmentation caused by small-batch orders, and thus, while meeting diverse customer needs, greatly improves unit utilization and scheduling efficiency, and reduces production costs and unit energy consumption.

[0058] In some examples, the production order is validated based on preset product definition rules. If the production order does not meet a preset first condition, a "to be merged" tag is added to the production order, including:

[0059] Based on the product definition rules, the input product parameters of the production order at the target unit input end are determined; the input product parameters are compared with the preset first condition, and when the number of blocks in the input product parameters is the number of single blocks and the weight parameter in the input product parameters is less than the preset weight threshold, the production order is marked as pending merging.

[0060] For example, based on preset product definition rules, generated production orders are analyzed in detail to determine the complete input product parameters at the target unit input end. The product definition rules pre-establish a complete product spectrum from raw materials to finished products and clearly define the key physical parameter constraints corresponding to each product ID (identifier), including but not limited to size range and weight range. By executing these product definition rules, a detailed set of parameters for the materials required for processing in a specific unit can be accurately extracted. These parameters include at least core attributes such as the number of pieces of input material, unit weight, thickness, and width, thus providing a complete and standardized input data foundation for subsequent verification processes.

[0061] Subsequently, the acquired input product parameters are automatically compared and logically judged against a preset first condition. The preset first condition is a pre-defined hard constraint, specifically determined as follows: when the number of input material blocks in a production order is a single block, and its weight parameter is less than a preset weight threshold, the system determines that the order needs to be merged due to uneconomical production scale. The weight threshold is set based on the minimum economic production batch size of the target unit; for example, in a cold rolling mill, this threshold can be set to 10,000 kg. When both conditions are met simultaneously, the system automatically adds a "to be merged" tag to the production order, thereby accurately identifying all candidate orders with low production efficiency due to insufficient single-piece weight, providing clear operational targets for subsequent merging and grouping processes.

[0062] By automatically extracting parameters and validating conditions for production orders according to preset rules, the system achieves accurate and rapid identification and marking of uneconomical production orders. This effectively replaces the traditional model of relying on human experience for order screening, avoiding omissions or misjudgments caused by human negligence or inconsistent judgment standards, and ensuring that all orders that need to be merged can be automatically captured by the system.

[0063] In some examples, the rule types include unit rules, quality rules, or delivery date rules. Based on the rule type in the merging rules, production orders with the merging marker are grouped at least twice consecutively to progressively filter out the target group set that meets the merging conditions, including:

[0064] Based on the unit rules, production orders with the merging mark are grouped for the first time to obtain a first group set; based on the quality rules, production orders in the first group set are grouped for the second time to obtain a second group set; based on the delivery date rules, production orders in the second group set are grouped for the third time to obtain the target group set.

[0065] For example, the process of grouping orders to be merged at least twice based on the rule type in the merging rules essentially constructs a progressively refined order screening system. This system first performs a preliminary division of all orders to be merged based on unit rules, grouping orders that share the same production path—that is, orders that use the same input materials in the same unit to produce the same intermediate product—into the same set, ensuring that the merger occurs at the same production stage. Based on this, a second screening is performed using quality rules, clustering orders with completely identical or considered equivalent quality characteristics (such as grade, standard, etc.) to ensure the consistency of quality in the merged products. Finally, a third screening is performed based on delivery date rules, classifying orders whose delivery time falls within the allowable time window into the final target set, thereby ensuring that the merged orders meet unified delivery requirements. This continuous grouping mechanism, through progressive constraints across three dimensions—unit, quality, and delivery date—achieves comprehensive screening from production feasibility and quality consistency to delivery synergy, providing a precise order combination basis for subsequently generating feasible merging schemes.

[0066] In some examples, the production orders with the merging tag are first grouped based on the unit rules to obtain a first group set, including:

[0067] Based on the unit rules, the designated input product identifier and the designated output product identifier of the target unit are determined; production orders with the specified input product identifier and the specified output product identifier of the target unit are selected from the production orders with the specified merge mark; the selected production orders are grouped into the same group to form the first group set.

[0068] For example, in the initial grouping process based on unit rules, the first operation performed is to determine the designated input product identifier and the designated output product identifier of the target unit based on the unit rules. This step relies on the rule type in the preset merging rules, where the defined "unit rule" type explicitly specifies the specific processing unit corresponding to the production task to be merged, i.e., the target unit, and simultaneously locks the input and output material standards that must be unified for this unit in the merging operation. Specifically, the rule defines the designated product identifier at the input end (e.g., the identifier "RJ" for hot-rolled coil) through the parameter source "JOB_IN (unit input / inlet material)" and defines the designated product identifier at the output end (e.g., the identifier "LB" for cold-rolled sheet) through the parameter source "JOB_OUT (unit output / outlet material)". The exact purpose of this step is to establish a precise, material flow-based process matching template for subsequent order screening, ensuring that merging only occurs between production orders with completely identical "input-processing-output" logical relationships.

[0069] After identifying the target unit and its input / output material identifiers, the next step is to filter out production orders from those marked with the "to be merged" tag, selecting those whose input product identifier and output product identifier for the target unit both match the specified input product identifier. The system iterates through all production orders marked "to be merged," verifying that the product identifier corresponding to "JOB_IN" in the target unit's production data is completely consistent with the specified input product identifier (e.g., "RJ"), and that the product identifier corresponding to "JOB_OUT" is completely consistent with the specified output product identifier (e.g., "LB"). This filtering process constitutes a precise matching logic, the core of which is to ensure that the aggregated orders have fundamental process homogeneity at the unit level. Finally, the filtered production orders are grouped into the same group to form the first group set. The system aggregates all production orders that pass the above consistency check into a single logical set, thus completing the first grouping. This achieves standardized classification of heterogeneous production orders at the most basic production process dimension. This ensures that the basis for order merging is based on the same production path and material conversion relationship, thus eliminating the possibility of orders from different processes being mistakenly merged from the source.

[0070] In some examples, the second grouping of production orders in the first grouping set based on the quality rules to obtain a second grouping set includes:

[0071] Based on the quality rules, the quality parameters of the production orders in the first group set and the parameter types corresponding to the quality parameters are determined; when multiple production orders correspond to the same parameter type, the production orders with the same quality parameters corresponding to the parameter type are grouped into the same group to obtain the second group set; when the parameter type is a value set group, the production orders whose quality parameters corresponding to the parameter type belong to the same preset value set group are grouped into the same group to obtain the second group set.

[0072] For example, based on the quality rules, one or more quality parameters (e.g., product brand, product standard, etc.) of production orders in the first grouping set are determined, and each quality parameter is associated with a parameter type that it must follow. The parameter type is a predefined core logic that determines how to determine whether the parameter value can be considered "the same" between different orders, and its specific forms include, but are not limited to, "same value" and "value set group". The "same value" type requires that the parameter values ​​be a literal, exact match; while the "value set group" type relies on a predefined set containing multiple specific parameter values ​​that can be considered equivalent.

[0073] When the parameter type is defined as "same value," the system groups production orders with identical quality parameter values ​​corresponding to that parameter type into the same group. For example, if the quality parameter is "grade" and the parameter type is "same value," then all production orders will only be grouped into the same second group set if their grade data is completely identical (e.g., all are "DX51D+Z"). When the parameter type is defined as "value set group," the system groups production orders with quality parameter values ​​corresponding to that parameter type that belong to the same preset value set group into the same group. This means that the system will query the preset value set group definition. If the quality parameter values ​​of multiple orders are all classified into the same value set group (e.g., a set named "high-gloss surface group"), then regardless of whether their specific values ​​are literally the same, they are considered to meet the "same quality" condition in this grouping and are thus grouped into the same second group set. This allows orders with limited differences in a specific quality dimension but which can be considered equivalent in terms of process to be merged, thereby effectively expanding the candidate range of mergeable orders while strictly ensuring core quality requirements.

[0074] In some examples, the third grouping of production orders in the second grouping set based on the delivery date rule to obtain the target grouping set includes:

[0075] Obtain the delivery dates of production orders in the second group set; use the earliest delivery date in the second group set as the base date; determine the maximum delivery date based on the preset absolute difference in days in the delivery rules; group production orders whose delivery dates fall between the base date and the maximum delivery date into the same group to form the target group set.

[0076] For example, the first step is to retrieve the delivery dates for all production orders in the second group set. This step involves parsing the data of the sales order line items associated with each production order to extract the explicitly recorded delivery time information, thus providing an accurate raw data foundation for subsequently establishing a time filtering window. Then, the earliest delivery date in the second group set is determined as the base date for this grouping. The selection principle for this base date aims to prioritize the most urgent delivery commitments among all merged orders, ensuring that the formulation of the merged production plan starts with meeting the earliest delivery requirement. After determining the base date, the calculation to determine the maximum delivery date is performed based on the absolute difference in days preset in the delivery rules.

[0077] The delivery date rule is a specific instance of the "delivery date" rule type in the merge rule system. Its parameter type is explicitly set to "absolute difference," and a specific range of absolute difference days is defined, such as [0, 30] days. The system adds this absolute difference day (e.g., 30 days) to the base date to accurately calculate the maximum delivery date boundary that allows order merging. Finally, the system executes logical judgments and set construction operations to group production orders with delivery dates between the base date and the maximum delivery date into the same group. Specifically, the system iterates through each production order in the second group set, determining whether its respective delivery date falls within the time interval formed by the base date and the maximum delivery date. All production orders that meet this time window condition are aggregated to form the final target group set. This ensures that the delivery dates of each production order within the final target group set are close to each other and all fall within a controllable and reasonable time range. This effectively avoids conflicts in production planning and logistics caused by forcibly merging orders with excessively large delivery date differences, significantly improving the on-time delivery rate and customer satisfaction.

[0078] In some examples, the rule type also includes constraint rules or merge rules, wherein merging production orders in the target group set to obtain merged production orders and marking the merged production orders as merged includes:

[0079] Based on the constraint rules, the production orders in the target group set are parameter-verified to determine the candidate order set that passes the constraint check; based on the parameter determination method preset in the merging rules, target merging combinations that meet the requirements of material input range and output range are selected from the candidate order set; based on the material input parameters and output parameters of all production orders in the target merging combination, the total material input and total output of the merged production orders are determined; based on the total material input and total output, the merged production orders are determined, and the production orders included in the target merging combination are marked as merged.

[0080] For example, based on the rules of the merging rules, which are of the constraint rule type, compliance checks are performed on specific key parameters of each production order within the target group set. The constraint rule predefines the parameters to be checked (e.g., thickness, width), their source (e.g., JOB_OUT), and the parameter type used to determine compatibility. When the parameter type is set to "same value," the same parameter value in different production orders must be strictly identical; when the parameter type is set to "absolute difference," the absolute value of the difference between the same parameter values ​​in different orders must be less than the upper limit preset by the rule (e.g., the upper limit for absolute difference in thickness is 0.01 mm, and the upper limit for absolute difference in width is 1 mm). The system iterates through the production orders in the target group set, executes the above verification logic for each constraint parameter defined by the rule, and only includes production orders whose constraint parameters all pass the verification into the candidate order set, thereby ensuring that the subsequently merged orders have production compatibility in key physical dimensions.

[0081] Based on the rules of the merging rules, the system first filters out target merging combinations that meet specific optimization conditions from the candidate order set. The merging rules predefine parameter sources (e.g., JOB_IN, JOB_OUT) and their corresponding parameter types (e.g., summation) and target ranges (e.g., JOB_IN single-weight summation range [10000, 20000]). The system uses a program traversal algorithm to perform combination calculations on the candidate order set, aiming to find order combinations that simultaneously satisfy two core conditions: First, the sum of the specified parameters (e.g., single weight) of all production orders within the combination at the JOB_IN source is within its preset range and as close as possible to the maximum value; second, the sum of the specified parameters (e.g., single weight) of all production orders within the combination at the JOB_OUT source is also within its preset range and, similarly, as close as possible to the maximum value. After determining the optimal target merging combination, the system calculates the sum of the JOB_IN parameters of all orders within the combination as the total material input for the merged production order, and calculates the sum of the JOB_OUT parameters of all orders as the total output. Finally, the system generates a new merged production order based on the calculated total input and output, assigns a unique ID to the new order, and marks all original production orders that constitute this merged order as "merged".

[0082] After removing production orders marked "merged," the third grouping is performed based on the first maximum delivery date. Following confirmation of the merged grouping, the second earliest delivery date of each production order is taken as the earliest delivery date. The first maximum delivery date is recalculated by adding the absolute difference in delivery dates defined by the parameters to the earliest delivery date. Production orders with delivery dates between the earliest and first maximum delivery dates are then regrouped for the third time. This process of merging and confirming grouping is repeated until the maximum delivery date of the new third group includes the latest delivery date of the production order. This significantly improves the accuracy and efficiency of the merging operation and eliminates human error.

[0083] The present invention will be described in detail below with reference to the embodiments, but these should not be construed as limiting the scope of protection of the present invention.

[0084] Example:

[0085] A steel mill has one color coating unit, one galvanizing unit, and one cold rolling unit. The raw material is purchased hot-rolled steel coils. There are currently 5 sales order line items that need to be organized for production (Note: the following data are all assumed ideal values, thickness and width are in millimeters, and weight is in kilograms): Sales order line item 1: Color coated sheet, product standard GB / T 12754-2019, grade TDC51D+Z, specifications (thickness × width) 0.35×796, unit weight 1000, number of pieces 6, topcoat film thickness 20, backcoat film thickness 7, topcoat type PE, coating weight 80, coating type Z, coating surface structure F, delivery time January 1, 2026. Sales Order Line Item 2: Color Coated Steel Sheet, Product Standard GB / T 12754-2019, Grade TDC51D+Z, Specifications (Thickness × Width) 0.35 × 796, Unit Weight 1000, Quantity 7, Topcoat Film Thickness 20, Backcoat Film Thickness 7, Topcoat Type PE, Coating Weight 80, Coating Type Z, Coating Surface Structure F, Delivery Time January 5, 2026.

[0086] Sales order line item 3: Color-coated steel sheet, product standard GB / T 12754-2019, grade TDC51D+Z, specifications (thickness × width) 0.35*796, unit weight 1000, quantity 2, topcoat film thickness 20, backcoat film thickness 7, topcoat type PE, coating weight 80, coating type Z, coating surface structure F, delivery time February 7, 2026. Sales order line item 4: Galvanized steel sheet, product standard GB / T 2518-2019, grade DX51D+Z, specifications (thickness × width) 0.32*796, unit weight 3000, quantity 3, coating weight 80, coating type Z, coating surface structure F, delivery time February 9, 2026. Sales order line item 5: Galvanized sheet, product standard GB / T 2518-2019, grade DX51D+Z, specifications (thickness × width) 0.32×795, unit weight 2000, number of pieces 2, coating weight 80, coating type Z, coating surface structure F, delivery time February 8, 2026. Sales order line item 6: Galvanized sheet, product standard GB / T2518-2019, grade DX51D+Z, specifications (thickness × width) 0.32×795, unit weight [2000, 3000], number of pieces 6, coating weight 80, coating type Z, coating surface structure F, delivery time February 9, 2026.

[0087] 1. Product Definition: Define the product ID and product name for finished products, semi-finished products, and raw materials, as shown in Table 1.

[0088] Product ID Product Name CB Color-coated steel sheets DB galvanized sheet LB cold-rolled steel sheet RJ hot rolled coil

[0089] Table 1

[0090] Define the size and weight parameter constraint rules corresponding to the product ID, as shown in Table 2.

[0091] Product ID Product Name parameter scope RJ hot rolled coil single weight [1000,2000]

[0092] Table 2

[0093] The product IDs for takeaway products are defined as production lines, units, and the input and output product IDs for each unit, as shown in Table 3.

[0094]

[0095]

[0096] Table 32 defines the merger rules, and Table 4 shows the merger rules for cold rolling mills:

[0097] Serial Number Rule Type parameter Parameter source Parameter type Parameter value 10 unit Product ID JOB_IN - RJ 20 unit Product ID JOB_OUT - LB 30 quality Brand JOB_OUT Same value 40 Delivery time Delivery date SOI absolute difference [0,30] 50 constraint thickness JOB_OUT absolute difference [0,0.01] 60 constraint width JOB_OUT absolute difference [0,1] 70 merge thickness JOB_IN Same as PO (Production Order) 80 merge width JOB_IN Same as PO 90 merge single weight JOB_IN Summation [10000,20000] 100 merge thickness JOB_OUT Minimum value 110 merge width JOB_OUT Maximum value 120 merge single weight JOB_OUT Summation

[0098] Table 4

[0099] 3. Merging Mark Inference: Based on the delivered products of the sales order line items and the rules of production lines and units defined in the product definition, the input and output plan data for each unit are inferred, as shown in Table 5:

[0100]

[0101]

[0102]

[0103]

[0104]

[0105]

[0106] Table 5

[0107] The size and quantity constraints of the product IDs input to the unit are verified. According to the unit weight constraint [10000, 20000] of hot-rolled coil RJ in the product definition, in the table above: the unit weight of order 6 cold rolling operation JOB_IN meets [10000, 20000] and is a normal order. The unit weight of cold rolling operation JOB_IN of orders 1, 2, 3, 4 and 5 is less than 10000 and does not meet the rule. The production orders 1, 2, 3, 4 and 5 are all marked as "to be merged".

[0108] 4. First Grouping Reasoning: Query the production orders marked "Pending Merging": 1, 2, 3, 4, 5. Based on the cold rolling mill merger rule definition, the mill type is "cold rolling," the PRD_ID of parameter source "JOB_IN" is RJ, and the PRD_ID of parameter source "JOB_OUT" is LB. Perform the first grouping of the production orders to be merged. The results of the first grouping are shown in Table 6.

[0109]

[0110]

[0111]

[0112] Table 6

[0113] 5. Second grouping reasoning: The rule type defined by the merging rule is quality, and the parameter type of the parameter "brand" is the same value. After the first grouping, the parameter value of the brand whose parameter source is JOB_IN is "DX51D+Z". After the second grouping, the data does not change and remains the data in Table 6.

[0114] 6. Third Grouping Reasoning: The second grouping includes production order 1 with a delivery date of January 1, 2026; production order 2 with a delivery date of January 5, 2026; production order 3 with a delivery date of February 7, 2026; production order 4 with a delivery date of February 9, 2026; and production order 5 with a delivery date of February 8, 2026. The parameter type defined in the consolidation rule is the absolute difference of the delivery date, which is 30 days. The first maximum delivery date is [January 1, 2026, January 30, 2026]. The production orders that meet the conditions are: 1 and 2, as shown in Table 7.

[0115]

[0116]

[0117] Table 7

[0118] 7. Merging and Grouping Confirmation: The merge rule definition uses constraint parameters: the thickness parameter source is JOB_OUT, and the absolute difference satisfies [0, 0.1]; the width parameter source is JOB_OUT, and the absolute difference satisfies [0, 1]. All data in Table 7 satisfy the constraint rules, and the data remains unchanged after grouping. The merge rule definition uses merge parameters: the parameter source is JOB_OUT, the thickness parameter type is minimum value; the parameter source is JOB_OUT, the width parameter type is maximum value; the parameter source is JOB_OUT, the single-weight parameter type is summation; the parameter source is JOB_IN, the thickness parameter type is the same as PO; the parameter source is JOB_IN, the width parameter type is the same as PO; the parameter source is JOB_IN, the single-weight parameter type is summation. According to the above merging rules, the thickness of each group JOB_OUT is 0.31, the width of each group JOB_OUT is 796, the thickness of each group JOB_IN is 3, and the width of each group JOB_IN is 800. The sum of individual JOB_OUT values ​​is 11717 (meeting the merging rule requirement of 10000-19000), and the sum of individual JOB_IN values ​​is 11837 (meeting the merging rule requirement of 10000-20000). The system regenerates a new merged production order ID: H1 for production orders 1 and 2, and marks production orders 1 and 2 as "merged". The merged data is shown in Table 8.

[0119] Order production line Unit serial number unit Parameter source parameter Parameter value H1 CB01 10 cold rolling JOB_IN Product ID RJ H1 CB01 10 cold rolling JOB_IN thickness 3 H1 CB01 10 cold rolling JOB_IN width 800 H1 CB01 10 cold rolling JOB_IN single weight 11837 H1 CB01 10 cold rolling JOB_IN Number of blocks 1 H1 CB01 10 cold rolling JOB_OUT Product ID LB H1 CB01 10 cold rolling JOB_OUT Brand DX51D+Z H1 CB01 10 cold rolling JOB_OUT thickness 0.31 H1 CB01 10 cold rolling JOB_OUT width 796 H1 CB01 10 cold rolling JOB_OUT single weight 11717 H1 CB01 10 cold rolling JOB_OUT Number of blocks 1

[0120] Table 8

[0121] One cold-rolled steel sheet with a single weight of 11717 produced from combined order H1 is used to cut out one steel sheet with a single weight of 5408 for production order 1 and another steel sheet with a single weight of 6309 for production order 2, thus satisfying the production requirements of the two production orders.

[0122] 8. Circular Reasoning: Remove production orders marked "merged", take the second earliest delivery date of the production orders as the earliest delivery date: February 7, 2026. Add the earliest delivery date to the maximum delivery days defined by the parameter to recalculate the first maximum delivery date [February 7, 2026, March 8, 2026], and regroup for the third time. The data is shown in Table 9.

[0123]

[0124]

[0125] Table 9

[0126] The rules defined by the merging rules are constraints: the thickness parameter is sourced from JOB_OUT and the absolute difference satisfies [0, 0.01], and the width parameter is sourced from JOB_OUT and the absolute difference satisfies [0, 1]. The data in Table 9 all satisfy the constraint rules, and the data remains unchanged after grouping.

[0127] The merge rule definition specifies the merge parameters as follows: Parameter source JOB_OUT, thickness parameter type is minimum value; Parameter source JOB_OUT, width parameter type is maximum value; Parameter source JOB_OUT, unit weight parameter type is summation; Parameter source JOB_IN, thickness parameter type is same as PO; Parameter source JOB_IN, width parameter type is same as PO; Parameter source JOB_IN, unit weight parameter type is summation. According to the above merge rules, the thickness of grouped JOB_OUT is 0.31, the maximum width of JOB_OUT is 796, the thickness of grouped JOB_IN is 3, the width of JOB_IN is 800, the unit weight summation of JOB_OUT is 14608 (meeting the merge rule requirement of 10000-19000), and the unit weight summation of JOB_IN is 14756 (meeting the merge rule requirement of 10000-20000). The system regenerates new merged production order ID: H2 for production orders 3, 4, and 5, and marks production orders 3, 4, and 5 as "merged". The merged data is shown in Table 10.

[0128] Order production line Unit serial number unit Parameter source parameter Parameter value H2 CB01 10 cold rolling JOB_IN Product ID RJ H2 CB01 10 cold rolling JOB_IN thickness 3 H2 CB01 10 cold rolling JOB_IN width 800 H2 CB01 10 cold rolling JOB_IN single weight 14756 H2 CB01 10 cold rolling JOB_IN Number of blocks 1 H2 CB01 10 cold rolling JOB_OUT Product ID LB H2 CB01 10 cold rolling JOB_OUT Brand DX51D+Z H2 CB01 10 cold rolling JOB_OUT thickness 0.31 H2 CB01 10 cold rolling JOB_OUT width 796 H2 CB01 10 cold rolling JOB_OUT single weight 14608 H2 CB01 10 cold rolling JOB_OUT Number of blocks 1

[0129] Table 10

[0130] One cold-rolled steel sheet with a unit weight of 14608 produced from merged order H2 is used to cut three steel sheets with unit weights of 1803, 8865, and 3940, which are then distributed to production orders 3, 4, and 5 respectively, satisfying the production requirements of the three orders. All production orders to be merged have been completed, and the cyclical reasoning ends. This application can merge production orders for two identical products, Order 1 (color-coated steel sheet) and Order 2 (color-coated steel sheet), as well as three different products, Order 3 (color-coated steel sheet), Order 4 (galvanized steel sheet), and Order 5 (galvanized steel sheet).

[0131] like Figure 2 As shown, this application proposes a steel multi-product production order merging system, which includes: a verification module 21, a grouping module 22, and a merging module 23;

[0132] The verification module 21 is configured to: acquire multiple sales order line items, and determine at least one production order corresponding to each sales order line item based on preset order design rules; verify the production order based on preset product definition rules, and add a mergeable mark to the production order if the production order does not meet the preset first condition;

[0133] The grouping module 22 is configured to: based on the rule type in the merging rules, perform at least two consecutive groupings on the production orders with the mark to be merged, so as to filter out the target group set that meets the merging conditions step by step, wherein the merging rules include at least two rule types;

[0134] The merging module 23 is configured to merge the production orders in the target group set to obtain merged production orders, and mark the merged production orders as merged.

[0135] The effects of applying the aforementioned method in the above system can be found in the description of the aforementioned method embodiments, and will not be repeated here.

Claims

1. A method for merging production orders for multiple steel products, characterized in that, The method includes: Obtain multiple sales order line items and determine at least one production order corresponding to each sales order line item based on preset order design rules; The production order is validated based on preset product definition rules. If the production order does not meet the preset first condition, the production order is marked as to be merged. Based on the rule type in the merging rules, production orders with the mark to be merged are grouped at least twice consecutively to progressively filter out the target group set that meets the merging conditions. The merging rules include at least two rule types. The production orders in the target group set are merged to obtain merged production orders, and the merged production orders are marked as merged.

2. The method for merging multiple steel product production orders according to claim 1, characterized in that, The process of validating the production order based on preset product definition rules, and adding a "to be merged" mark to the production order if it does not meet a preset first condition, includes: Based on the product definition rules, determine the input product parameters of the production order at the input end of the target unit; The input product parameters are compared with a preset first condition. When the number of blocks in the input product parameters is a single block and the weight parameter in the input product parameters is less than a preset weight threshold, the production order is marked as pending merging.

3. The method for merging multiple steel product production orders according to claim 1, characterized in that, The rule types include unit rules, quality rules, or delivery date rules. Based on the rule type in the merging rules, production orders with the merging mark are grouped at least twice consecutively to progressively filter out the target group set that meets the merging conditions, including: Based on the unit rules, production orders with the merging marker are grouped for the first time to obtain a first group set; Based on the quality rules, the production orders in the first group set are grouped a second time to obtain the second group set; Based on the delivery date rules, the production orders in the second group set are grouped a third time to obtain the target group set.

4. The method for merging multiple steel product production orders according to claim 3, characterized in that, The production orders with the pending-merge marker are first grouped based on the unit rules to obtain a first group set, including: Based on the unit rules, the designated input product identifier at the input end and the designated output product identifier at the output end of the target unit are determined. Filter the production orders with the specified input product identifier and output product identifier of the target unit from the production orders with the specified merge mark; The filtered production orders are grouped into the same group to form the first group set.

5. The method for merging multiple steel product production orders according to claim 3, characterized in that, The production orders in the first grouping set are grouped a second time based on the quality rules to obtain a second grouping set, including: Based on the quality rules, determine the quality parameters of the production orders in the first group set and the parameter types corresponding to the quality parameters; When multiple production orders correspond to the same parameter type, production orders with the same quality parameters corresponding to the parameter type are grouped into the same group to obtain a second group set; When the parameter type is a value set group, production orders whose quality parameters corresponding to the parameter type belong to the same preset value set group are grouped into the same group to obtain a second group set.

6. The method for merging multiple steel product production orders according to claim 3, characterized in that, The production orders in the second grouping set are grouped a third time based on the delivery date rule to obtain the target grouping set, including: Obtain the delivery dates of the production orders in the second group set; Use the earliest delivery date in the second group set as the base date; The maximum delivery date is determined based on the absolute difference in days preset in the delivery rules. Production orders with delivery dates between the base date and the maximum delivery date are grouped into the same group to form the target group set.

7. The method for merging multiple steel product production orders according to claim 1, characterized in that, The rule type also includes constraint rules or merging rules. The step of merging production orders in the target group set to obtain merged production orders, and marking the merged production orders as merged, includes: Based on the constraint rules, the production orders in the target group set are subjected to parameter verification to determine the candidate order set that passes the constraint check; Based on the parameter determination method preset in the merging rules, target merging combinations that meet the requirements of material input range and output range are selected from the candidate order set; Based on the material input parameters and output parameters of all production orders in the target merged combination, determine the total material input and total output of the merged production orders; Based on the total amount of input and the total amount of output, a merged production order is determined, and the production orders included in the target merged combination are marked as merged.

8. A steel multi-product production order merging system, characterized in that, The system includes: a verification module, a grouping module, and a merging module; The verification module is configured to: acquire multiple sales order line items, and determine at least one production order corresponding to each sales order line item based on preset order design rules; verify the production order based on preset product definition rules, and add a "to be merged" mark to the production order if the production order does not meet a preset first condition; The grouping module is configured to: based on the rule type in the merging rules, perform at least two consecutive groupings on production orders with the mark to be merged, so as to filter out the target group set that meets the merging conditions step by step; the merging rules include at least two rule types. The merging module is configured to merge production orders in the target group set to obtain merged production orders, and mark the merged production orders as merged.

9. An electronic device, comprising: The memory and processor are characterized in that the processor, when executing a computer program stored in the memory, implements the steps of a method for merging steel multi-product production orders as described in any one of claims 1-7.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by the processor, it implements the steps of the steel multi-product production order merging method as described in any one of claims 1-7.

Images