CN112884491A

CN112884491A - Full-stage tracking system for steel products

Info

Publication number: CN112884491A
Application number: CN202110231008.9A
Authority: CN
Inventors: 陈佳豪
Original assignee: Beijing Aruixintong Technology Co ltd
Current assignee: Beijing Aruixintong Technology Co ltd
Priority date: 2021-03-02
Filing date: 2021-03-02
Publication date: 2021-06-01

Abstract

The embodiment of the invention discloses a full-stage tracking system for steel products. Wherein, this system includes: scanning terminal and server, wherein: the scanning terminal is used for acquiring the unique identity of the material and sending the unique identity to the server; the server comprises a data processing module and a logic processing module; the data processing module is used for searching the material information from the database according to the unique identity and returning the material information to the scanning terminal; the scanning terminal displays the material information and acquires the logical operation on the material information; the logic processing module receives the logic operation and performs logic processing on the material information according to the logic operation to obtain a logic processing result; and the data processing module is used for writing the logic processing result into the database. The method can realize the tracking of the whole life cycle at the whole stage based on the unique identity, thereby providing an accurate data base for the use condition of steel at different stages and bringing more comprehensive data analysis for the steel manufacturing industry.

Description

Full-stage tracking system for steel products

Technical Field

The embodiment of the invention relates to the technical field of steel management, in particular to a full-stage tracking system for steel products.

Background

With the rapid development of the scientific and technical level, the manufacturing industry realizes interconnection and intercommunication among equipment, control, vehicles and enterprises in the whole life cycle of products, and finally forms the functions of intelligent equipment, intelligent factories, intelligent services and the like, thereby becoming the production target of the steel manufacturing industry.

The steel manufacturing industry needs to establish a data stream that includes the complete life cycle of the product manufacturing, however, the entire life cycle of steel manufacturing includes raw materials, steel-making liquid steel, steel ingots of forged steel, continuous rolled rods and wires, online warehousing of products, warehousing, ex-warehouse, inventory management and the like. Because of the different stages and the change of the steel shape, how to track the whole life cycle of the steel is a technical problem to be solved urgently by the technical staff in the field.

Disclosure of Invention

The embodiment of the invention provides a full-stage tracking system for steel products, which can realize the tracking of the full stage of the whole life cycle based on a unique identity, thereby providing an accurate data base for the use condition of steel products in different stages and bringing more comprehensive data analysis for steel manufacturing industries.

In a first aspect, an embodiment of the present invention provides a full-stage tracking system for a steel product, including: including scanning terminal and server, wherein:

the scanning terminal is used for acquiring the unique identity of the material and sending the unique identity to the server;

the server comprises a data processing module and a logic processing module;

the data processing module is used for receiving the unique identity, searching material information from a database according to the unique identity and returning the material information to the scanning terminal;

the scanning terminal is also used for displaying the material information and acquiring the logical operation of the material information;

the logic processing module is used for receiving the logic operation and carrying out logic processing on the material information according to the logic operation to obtain a logic processing result;

and the data processing module is used for writing the logic processing result into the database.

Further, the data processing module comprises a data receiving sub-module, a data processing sub-module and a data forwarding sub-module;

the data receiving submodule is used for receiving the unique identity of the material sent by the scanning terminal;

the data processing submodule is used for acquiring material information corresponding to the unique identity in a database according to the unique identity and sending the material information to the data forwarding submodule;

and the data forwarding submodule is used for forwarding the material information to the scanning terminal.

Further, the data receiving sub-module is further configured to:

receiving user requirement information sent by a scanning terminal;

the data processing sub-module is further configured to:

and determining target dimension information matched with the user requirements in the material information according to the user requirement information and the unique identity.

Further, the data processing sub-module is specifically configured to:

and generating a database query statement according to the user demand information and the unique identity so as to query target dimension information matched with the user demand in the material information from the database.

Further, the logic processing module comprises an operation receiving sub-module and a logic processing sub-module;

the operation receiving submodule is used for receiving logic operation contents;

and the logic processing submodule is used for processing the logic state of the material information according to the logic operation content to obtain a logic processing result.

Further, the scanning terminal is specifically configured to:

the unique identification of the material is obtained by scanning the two-dimensional code on the material.

Further, the database comprises a data configuration table;

the data configuration table comprises a material information table, a material batch table, a splitting log table, a transferring log table and a material process table.

Further, the main key of the material information table is a unique identity;

the material information table also comprises a group weighing field, a steel type field, an ingot type field, a specification field and a material name field;

the material information table further comprises a branch field, a process field, a weight field, a batch number field and a contract number field.

Further, the material information table further includes a status field for recording status information of whether the material has been produced, is valid, is used, and is transferred.

Further, the material batch table is used for recording detailed information of batches to which the materials belong;

the splitting log table is used for recording detailed information of material batch splitting and combining batches;

the transfer log table is used for recording the detailed information of the circulation of the material;

the material process table is used for recording detailed information of material production.

In a second aspect, an embodiment of the present invention further provides a full-stage tracking method for a steel product, where the method includes:

acquiring a unique identity of a material, and sending the unique identity to a server;

the server receives the unique identity, searches material information from a database according to the unique identity and returns the material information to the scanning terminal;

the scanning terminal acquires logical operation on the material information;

the server receives the logic operation and performs logic processing on the material information according to the logic operation to obtain a logic processing result;

and writing the logic processing result into the database.

The embodiment of the invention comprises a scanning terminal and a server, wherein: the scanning terminal is used for acquiring the unique identity of the material and sending the unique identity to the server; the server comprises a data processing module and a logic processing module; the data processing module is used for receiving the unique identity, searching material information from a database according to the unique identity and returning the material information to the scanning terminal; the scanning terminal is also used for displaying the material information and acquiring the logical operation of the material information; the logic processing module is used for receiving the logic operation and carrying out logic processing on the material information according to the logic operation to obtain a logic processing result; and the data processing module is used for writing the logic processing result into the database. The technical scheme provided by the embodiment of the invention can realize the tracking of the whole life cycle at the whole stage based on the unique identity, thereby providing an accurate data base for the use condition of steel at different stages and bringing more comprehensive data analysis for the steel manufacturing industry.

Drawings

FIG. 1 is a schematic structural diagram of a full-stage tracking system for a steel article according to an embodiment of the present invention;

fig. 2 is a schematic structural diagram of a data processing module according to a second embodiment of the present invention;

fig. 3 is a schematic structural diagram of a logic processing module according to a third embodiment of the present invention;

FIG. 4 is a diagram illustrating a relationship between data tables according to a third embodiment of the present invention;

fig. 5 is a schematic diagram of a full-stage tracking of a steel article according to a fourth embodiment of the present invention.

Detailed Description

The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.

Example one

Fig. 1 is a schematic structural diagram of a full-stage tracking system for a steel product according to an embodiment of the present invention, which is applicable to a data statistics situation of steel products, and can execute a full-stage tracking method for a steel product. As shown in fig. 1, the system includes:

comprising a scanning terminal 110 and a server 120, wherein:

the scanning terminal 110 is configured to obtain a unique identity of a material, and send the unique identity to the server 120;

the server 120 comprises a data processing module 121 and a logic processing module 122;

the data processing module 121 is configured to receive the unique identity, search material information from a database according to the unique identity, and return the material information to the scanning terminal 110;

the scanning terminal 110 is further configured to display the material information and obtain a logical operation on the material information;

the logic processing module 122 is configured to receive the logic operation, and perform logic processing on the material information according to the logic operation to obtain a logic processing result;

the data processing module 121 is configured to write the logic processing result into the database.

The scanning terminal 110 may include a code scanning gun, and a terminal device with a code scanning function, such as a smart phone of a user, a tablet computer, and the like. The scanning terminal 110 may be installed with a corresponding application program for obtaining operation information of a user to implement human-computer interaction.

According to the scheme, the scanning terminal 110 can be used for scanning two-dimensional codes, bar codes or digital codes of steel materials. The digital code may be a string of information that characterizes the identity of the steel material.

In this embodiment, optionally, the scanning terminal is specifically configured to:

The unique identification can be unique and is used for representing the information of the steel material. The steel material can be an outsourcing raw material and can also be a return material of scrap steel, and the steel material can comprise raw material identification marks similar to purchase batch numbers, production batch numbers and the like. It can be understood that after the unique identity of the steel material is determined, the unique identity can be associated with each stage of the subsequent production and processing of the steel, so that the material information of the steel can be determined no matter what shape the steel is currently in or in which processing procedure.

In this scheme, the server 120 may be connected to the scanning terminal 110 through a network, and the server 120 may be a central device that performs service processing on the unique identifier obtained by the scanning terminal 110, for example, the server 120 may be connected to a database or the like to retrieve other information associated with the unique identifier of the material.

In this embodiment, the server 120 includes a data processing module 121, which is configured to receive the unique identifier and perform a material information search based on the unique identifier. Specifically, the unique identity may be used as the searched field content, and the related information matching with the content may be searched in the database. For example, procurement information, source information, etc. of the steel material may be located. In addition, it is possible to find out whether the unique identification corresponds to other supply and demand information, such as melting, casting process, annealing process, etc., and to transfer to a forged steel process, a continuous rolling process, a finished product warehouse-out, etc. If the steel material exists, the fact that a part of the steel material is subjected to finished product ex-warehouse treatment is indicated, and the material is only a part of the original material.

The server 120 may return to the scanning terminal 110 after obtaining the relevant material information. The scanning terminal 110 may display the related information through a screen display, a voice broadcast, or the like. While displaying, the scanning terminal 110 may also receive an operation instruction of a user to implement logical processing on the material information to obtain a logical processing result.

The logical processing may be division of components, modification of processes, and the like, for example, after steel materials are introduced, batch processing is required, after batch processing, smelting, steel forging and the like are required, interaction with a user is realized on the scanning terminal side, and a corresponding logical processing result is obtained.

The logic processing module 122 of the server 120 receives the logic processing result and writes the logic processing result into the database as permanently saved data until a subsequent user manually deletes the part of the data or performs a modification of the next stage.

Example two

Fig. 2 is a schematic structural diagram of a data processing module according to a second embodiment of the present invention, which is further detailed based on the foregoing embodiment. As shown in fig. 2, the data processing module 121 includes a data receiving sub-module 1211, a data processing sub-module 1212, and a data forwarding sub-module 1213;

the data receiving submodule 1211 is configured to receive a unique identity of a material sent by a scanning terminal;

the data processing sub-module 1212 is configured to obtain material information corresponding to the unique identity in the database according to the unique identity, and send the material information to the data forwarding sub-module 1213;

the data forwarding sub-module 1213 is configured to forward the material information to the scanning terminal.

This scheme is through concentrating the only identification of material in the two-dimensional code, follows the material and circulate in each process. The user obtains the material information in the two-dimensional code through the handheld scanning terminal, and the man-machine interaction module sends the data to the data processing module 121 through the wireless network. The data receiving sub-module 1211 receives data, and the data processing sub-module 1212 processes the original data, and since the two-dimensional code only contains the unique identification of the material, the data processing sub-module 1212 finds out the material according to the identification, or obtains detailed data of other dimensions of the material according to information required by a user. The data processing module 121 does not perform logic processing on the data, but generates database statements according to the user requirements, interacts with the database, and finally forwards the data required by the user to the human-computer interaction module through the data forwarding sub-module 1213, and displays the data on a human-computer interaction interface to wait for further operation of the user.

In this embodiment, specifically, the data receiving sub-module 1211 is further configured to:

receiving user requirement information sent by a scanning terminal;

the data processing sub-module 1212 is further configured to:

The technical scheme provides a method for determining the production total amount of the steel corresponding to the unique identification information and returning the production total amount to the user for checking according to whether the user clicks the information or not, if the user does not click the production date and clicks the production total amount, the information can be returned.

In this scheme, specifically, the data processing submodule is specifically configured to:

The data processing submodule can convert a query target into a query statement and query corresponding information in the database.

According to the scheme, the unique identity and the user requirement can be converted into the sentence capable of being inquired through the setting, and the sentence is inquired from the database and returned to the user after the result is obtained. Therefore, corresponding data can be returned according to the actual requirements of the user, redundant data information in the execution process of the whole scheme is less, and the use requirements of the user can be met.

EXAMPLE III

Fig. 3 is a schematic structural diagram of a logic processing module according to a third embodiment of the present invention, which is further detailed based on the foregoing embodiments. As shown in fig. 3, the logic processing module 122 includes an operation receiving submodule 1221 and a logic processing submodule 1222;

the operation receiving submodule 1221 is configured to receive logic operation content;

the logic processing submodule 1222 is configured to perform logic state processing on the material information according to the logic operation content, so as to obtain a logic processing result.

In the scheme, a user can select corresponding logic operation after acquiring data, the unique material identity and specific operation data are sent to the data processing module through the man-machine interaction module, and then the data processing module forwards the data to the operation receiving submodule 1221 of the logic processing module. The logic processing submodule 1222 performs specific logic processing. The logic processing submodule 1222 performs processing of the material logic state only according to the user input, and the data processing module actually interacts with the database, so that the logic processing module 122 sends the processed data to the data processing module, and the data processing module forwards the data to the database for persistent storage of the data. Meanwhile, the data processing module is responsible for sending the processed data to the human-computer interaction module, displaying the processed data on a human-computer interaction interface, and finishing the whole tracking processing process.

According to the scheme, the logic processing module is further refined, and the logic processing submodule can be adopted to perform logic processing on corresponding steel data to obtain a logic processing result and store the logic processing result in the database. This arrangement can improve the editability of the steel product data information and the usability of the edited data.

On the basis of the above technical solutions, optionally, the database includes a data configuration table;

Fig. 4 is a relationship diagram of a data table provided IN the third embodiment of the present invention, and as shown IN fig. 4, the data configuration table of the present invention uses a MATERIAL information table T _ MATERIAL as a core, and a MATERIAL specific operation information table T _ MATERIAL _ BATCH (MATERIAL BATCH table), T _ SEPARATE _ LOG (split LOG table), T _ TRANSFER _ LOG (TRANSFER LOG table), T _ MATERIAL _ IN _ PROCESS (MATERIAL PROCESS table), and the like.

Specifically, the main key of the material information table is a unique identity;

The T _ MATERIAL table records the detailed information of the MATERIAL, the main key is a MATERIAL _ NO MATERIAL coding field, the fields GROUP _ NAME, GRADE, IGOT _ TYPE, SPEC and MATERIAL _ NAME respectively record the basic information of the MATERIAL such as GROUP NAME, steel TYPE, ingot TYPE, specification and MATERIAL NAME, the fields FACTORY and PROCESS record the branch and PROCESS where the MATERIAL is located, and the fields WEIGHT, BATCH _ NO and CONTRACT _ NO record the information of the WEIGHT, BATCH number, CONTRACT number and the like of the MATERIAL.

Specifically, the material information table further includes a status field, and the status field is used for recording status information of whether the material is generated, valid, used and transferred.

Fields IS _ BIRTH, IS _ ACTIVE, IS _ USED, IS _ SEND record the operation information whether the material has been produced, valid, USED, transferred, etc.

Optionally, the material batch table is used for recording detailed information of a batch to which the material belongs;

For example, the T _ MATERIAL _ BATCH table records the details of the BATCH to which the MATERIAL belongs, the primary key is BATCH _ NO BATCH number, and the fields WEIGHT and QUANTITY record the WEIGHT and count information of the BATCH.

The T _ partition _ LOG table records the detailed information of the material BATCH split and combination batches, the primary key is ID, the field BATCH _ NO is the changed BATCH number, the field BATCH _ NO _ SOURCE is the BATCH number before the change, the CREATE _ TIME is the change TIME, and OPERATOR.

The T _ TRANSFER _ LOG table records the detailed information of material circulation, the primary key is BATCH _ NO BATCH number, the fields SOURCE _ FACTORY, SOURCE _ PROCESS, TARGET _ FACTORY and TARGET _ PROCESS respectively record the branch FACTORY, the TRANSFER procedure, the TARGET branch FACTORY and the TARGET procedure, the fields SENDER, SEND _ TIME, RECEIVER and RECEIVE _ TIME respectively record the TRANSFER person, the TRANSFER TIME, the RECEIVER and the receiving TIME, and the fields SENDWEIGHT, SENDQUANTITY, RECVE _ WEIGHT and RECEIVE _ QUANTITY respectively record the TRANSFER WEIGHT, the TRANSFER branch number, the receiving WEIGHT and the receiving branch number.

The T _ MATERIAL _ IN _ PROCESS table records detailed information of MATERIAL production, a primary key is MATERIAL _ NO MATERIAL code, fields PROCESS, MACHINE _ NAME and OPERATOR respectively record MATERIAL operation procedures, operation equipment and OPERATORs, a field PRODUCE _ BATCH _ NO records production BATCH number of the MATERIAL, and a field OPERATE _ TIME records production operation TIME.

Through the arrangement, seamless integration of information and service management between the command center and the production line is realized. The production actual performance and the operation condition of the production line are fed back in real time, information exchange among each process and each branch plant in each branch plant is realized, the dynamic adjustment of the production rhythm of the whole process is supported, the hot waiting time is reduced, the energy consumption is reduced, and the inventory of products in process is reduced. Standardize the design of production process rules, manufacturing rules and quality management, improve the real-time determination ratio of components and materials, and improve the product quality and the production efficiency; the data is automatically collected, so that a source is ensured to be counted out, and the manual repetitive labor is reduced.

Example four

Fig. 5 is a schematic diagram illustrating the full-stage tracking of a steel product according to a fourth embodiment of the present invention, and as shown in fig. 5, the steel enterprise mainly shares four main substations, i.e., a steel making substation, a steel forging substation, a steel rolling substation, and a finished product substation.

And receiving materials such as returned scrap steel and the like from other substations in the steelmaking substation, smelting the molten steel together with outsourced raw materials, forming an ingot through the working procedures such as casting and the like, and transferring the ingot to the forged steel substation.

The steel forging branch factory receives steel ingots of the steel making branch factory, and steel billets are formed through quick forging, and the formed steel billets have three directions: and transferring part of the steel billets to a finished product branch factory, transferring part of the steel billets to a steel rolling branch factory, and transferring part of the steel billets to a finish forging process.

The steel billet after the finish forging has two directions: part of the steel billets are transferred to a finished product branch factory, and part of the steel billets are transferred to a steel rolling branch factory. The continuous rolling branch plant receives the billets from the forged steel branch plant, produces large rods through rough rolling, produces small rods and wire rods through finish rolling, and transfers the small rods and the wire rods to a finished product branch plant.

And the finished product branch factory receives the semi-finished products of the forging steel branch factory and the steel rolling branch factory, further finishes the semi-finished products to generate final products, and delivers the final products out of the warehouse. The production process is complicated.

Before the method is applied, field personnel manually input the production machine account, the workload is heavy, and errors are easy to occur. According to the invention, in the steelmaking process, outsourcing raw materials and scrap steel return materials are respectively marked by a purchase batch number and a production batch number as raw material identities, the raw materials are smelted to generate a smelting furnace number, the smelting furnace number is subjected to a casting process, a steel ingot is cast to generate a steel ingot, the steel ingot number and the production batch number are marked, annealing and other processes are performed, the annealing batch number is marked and then transferred to a steel forging process, the steel forging process is heated and forged, the forging batch number is marked, the product form is changed into a steel billet, then the steel billet is annealed, the marked annealing batch number is transferred to a continuous rolling process, the continuous rolling process is heated and rough rolled, the product form is changed into a large bar, the finished product is transferred out of a warehouse after the bar number is marked, or a part of the large bar, the marked bar, the coil number and the like are transferred. Through a unique identification two-dimensional code label, the whole life cycle of the material is connected in series, the logistics is carried out in real time, the product tracking is carried out, and simultaneously the states of the material are distinguished, namely material preparation and surplus material, or order production. The method can immediately reflect various current states of the materials and synchronize the states of the materials to a plan and an order, so that zero time delay of order tracking, no error of stock checking, zero error of material tracking and full coverage of quality backtracking are realized.

It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.

Claims

1. A full-stage tracking system of a steel product is characterized by comprising a scanning terminal and a server, wherein:

the server comprises a data processing module and a logic processing module;

2. The system of claim 1, wherein the data processing module comprises a data receiving sub-module, a data processing sub-module, and a data forwarding sub-module;

3. The system of claim 2, wherein the data receiving sub-module is further configured to:

receiving user requirement information sent by a scanning terminal;

the data processing sub-module is further configured to:

4. The system of claim 3, wherein the data processing sub-module is specifically configured to:

5. The system of claim 1, wherein the logic processing module comprises an operation receiving sub-module and a logic processing sub-module;

6. The system according to claim 1, wherein the scanning terminal is specifically configured to:

7. The system of claim 1, wherein the database includes a data configuration table;

8. The system of claim 7, wherein the primary key of the material information table is a unique identity;

9. The system of claim 8, wherein the material information table further comprises a status field for recording status information of whether the material has been created, is valid, is used, and is transferred.

10. The system of claim 7, wherein the material lot table is configured to record details of a lot to which the material belongs;