Sand box carrying information warehousing method and system and medium

Abstract

The invention provides a sand box carrying information warehousing method and system and a medium, and belongs to the technical field of industrial automation control, and the method comprises the steps that a sand box formula database, station information tracking logic, a display area and an operation interface are constructed in advance; in response to a user selection operation, selecting a formula from the formula database and issuing the formula to the PLC; the PLC executes the station information tracking logic, binds the formula corresponding sand box information with the station, dynamically updates the station-sand box information mapping table, and visually displays the station-sand box information mapping table on the touch screen; whether a modification instruction is received through the operation interface is judged, and if yes, the modification instruction is sent to the PLC; and the PLC automatically executes flow control operation according to the real-time data in the station-sand box information mapping table. According to the application, automatic binding and dynamic updating of the sand box information are realized through the touch screen and the PLC, the cost is reduced, the production efficiency is improved, the information tracing capability is enhanced, the intelligent level is improved, and the method is suitable for old production line transformation.

Description

Technical Field

[0001] This application belongs to the field of industrial automation control technology, specifically relating to a method, system, and medium for a sandbox to carry information into a database. Background Technology

[0002] In the casting industry's production process, after the sand boxes are assembled, they need to be transferred to the pouring area for temporary storage. For multi-layer, multi-row roller conveyor pouring silos, the traditional method of selecting and arranging sand boxes relies on manual selection of storage positions using knobs. This mode has significant limitations: it cannot achieve automatic association between sand box information and storage positions. Before pouring, key information such as sand box model and process parameters must be manually checked one by one. This not only increases the intensity of manual labor and labor costs, but also easily leads to operational risks such as incorrect pouring and missed pouring due to manual verification errors, affecting production stability.

[0003] To address the issue of sand box information traceability, the current mainstream solution is to build an independent information system: a touch-screen all-in-one machine and barcode scanner are installed at the sand box assembly station, and barcodes are pre-coded on the sand box pads. Scanning these codes binds the sand box pads to the sand box's process and order information. Simultaneously, barcode scanners are added at key stations such as before warehousing and before casting to identify the sand box's movement trajectory in real time, thereby generating a ledger of the sand box's warehousing location and a list of sand boxes for casting. However, this solution has significant drawbacks: firstly, the overall equipment procurement and system deployment costs are high; secondly, for older production lines that did not plan for information system construction in the early stages, the transformation process requires restructuring part of the production process, incurring additional costs for equipment installation and wiring modifications, making widespread application difficult.

[0004] Therefore, it is necessary to provide a low-cost, easy-to-implement method for binding and transmitting sand box information on outdated production lines, so as to realize the automatic association between sand box information and the warehousing station and improve the level of intelligent management of the production line. Summary of the Invention

[0005] In a first aspect, embodiments of this application provide a method for storing information carried in a sand box, applied to a multi-layer, multi-row roller conveyor type casting silo in a casting production line, and implemented based on a touch screen and PLC, including the following steps: S1. Build a sand box formula database in the touch screen to store the formula data corresponding to each model of sand box. Configure station information tracking logic in the PLC to create and maintain a dynamic station-sand box information mapping table. Configure a display area for dynamically displaying the station-sand box information mapping table and an operation interface for receiving modification instructions on the human-machine interface of the touch screen. S2. After the sand box is closed, in response to the user's selection operation of the current sand box formula data from the sand box formula database on the touch screen, the selected sand box formula data is sent to the PLC as the sand box identification information; The S3.PLC executes station information tracking logic, which binds the received sand box identification information with the actual station currently occupied by the sand box based on the action signals and station status signals collected from the roller conveyor system, and dynamically updates the station-sand box information mapping table. S4. The touch screen obtains the updated workstation-sandbox information mapping table from the PLC in real time and displays it dynamically in the display area; S5. Determine whether a modification instruction for a sandbox has been received from the user through the operation interface. If received, send the modification instruction to the PLC. The S6.PLC automatically executes process control operations based on real-time data in the workstation-sand box information mapping table; the operation process includes warehouse selection and arrangement, post-pouring return to warehouse allocation, and automatic timing and monitoring of cooling time.

[0006] Furthermore, the specific steps of step S1 are as follows: S11. In the recipe function of the touch screen, create a sand box recipe database indexed by the sand box model. Each recipe record stores a set of key process parameters and management information related to the sand box model. The key process parameters and management information include the sand box model, the required weight of molten iron, the target warehousing discharge, the preset cooling time, the X coordinate of the gate, and the Y coordinate of the gate. S12. Define a structured variable in the PLC program to map the workstation-sandbox information, and establish a mapping relationship between the physical workstation number and the recipe data stored in the sandbox at the corresponding workstation; the data stored in the structured variable for each workstation shall include at least the sandbox name, status flag, preset cooling time and real-time calculated remaining cooling time; S13. Write station information tracking logic in the PLC program. The station information tracking logic is configured to add, delete or shift data in the station-sand box information mapping table in response to the roller sensor signal representing the change in sand box position. S14. In the graphical user interface of the touch screen, add a display view corresponding to the workstation-sandbox information mapping table data structure, and add an editing control embedded in the display view as an operation interface.

[0007] Furthermore, the specific steps of step S2 are as follows: S21. After the sand box assembly process is completed, the operator can select or enter the model corresponding to the current sand box from the list of the formula database through the formula selection interface on the touch screen to generate a call request; S22. Based on the call request, read the sand box formula data corresponding to the sand box model from the sand box formula database and generate a structured formula data package; S23. Based on the preset communication interface, send the recipe data packet to the preset data storage area of ​​the PLC.

[0008] Furthermore, the specific steps of step S3 are as follows: The S31.PLC continuously monitors the sensor signals connected to each roller conveyor section and workstation. S32. When the PLC determines from the sensor signal that a sand box has moved into an empty station in the pouring silo, the station information tracking logic is triggered; S33. Determine the data source for the sandbox information to be bound and perform the binding: If the sand box has just entered the pouring silo, the corresponding formula data packet issued in step S2 will be written into the corresponding workstation table entry of the workstation-sand box information mapping table. If a sand box is moved from one station to another within the pouring silo, the sand box formula data information will be transferred from the original station table entry or copied to the new station table entry. S34. For the casting station queue, the first-in-first-out queue mechanism is used to update the mapping table: when the sand box at the front of the queue is removed, the binding information of all subsequent stations is shifted forward by one position, and the information of the newly entered sand box at the rear is written into the last table entry.

[0009] Furthermore, the specific steps of step S4 are as follows: S41. The touchscreen reads station-sandbox information mapping table data from the PLC; S42. Parse the workstation-sandbox information mapping table data and extract the sandbox name, status flag, remaining cooling time and preset cooling duration under each workstation table item; S43. Render the parsed data to the display area according to the preset layout, and generate a progress bar or countdown text as a visual element of the cooling progress in the display entry of the corresponding sandbox according to the ratio of the remaining cooling time to the preset cooling duration.

[0010] Furthermore, the specific steps of step S5 are as follows: S51. Listen for events of the edit control in the touchscreen operation interface; S52. When a user selects a sandbox item in the display area and enters a modified value through the editing control, the touch screen generates a structured modification instruction containing the target workstation identifier, the modified field, and the new value. S53. The touch screen sends a structured modification instruction to the PLC to update the specified field in the corresponding workstation table entry of the workstation-sandbox information mapping table.

[0011] Furthermore, the specific steps of step S6 are as follows: According to the workstation-sand box information mapping table, the S61.PLC calculates and triggers the operation of the corresponding roller conveyor for the sand box that has just entered the warehouse and has not been assigned a workstation, based on the target warehouse entry information in the corresponding formula data, and transports the sand box to the target row. S62. For sand boxes that have been poured, the PLC automatically assigns a return path and an idle target workstation to the poured sand box according to the sand box status and preset scheduling strategy in the workstation-sand box information mapping table, and triggers the corresponding roller conveyor control. S63. For sand boxes in the cooling station, the PLC starts an independent timer based on the preset cooling time of the sand box in the cooling station according to the station-sand box information mapping table, and calculates the remaining cooling time in real time: Remaining cooling time = preset time - (current time - the time when this sand box is completed and removed from the warehouse); The calculation results of the remaining cooling time are updated in real time to the corresponding entries in the workstation-sandbox information mapping table; S64. When the remaining cooling time of a sand box drops to zero or a preset threshold, the PLC automatically updates the status of the corresponding sand box in the workstation-sand box information mapping table to be removable, and can trigger an outbound command when subsequent process conditions are met.

[0012] Furthermore, step S6 also includes a pouring control step: The S65.PLC monitors the station status of the pouring grate in real time. When the station-sand box information mapping table shows that the first station of the grate has a sand box and the status is "to be poured", it reads the gate coordinates stored in the corresponding station table entry. The gate coordinates include the gate X coordinate and the gate Y coordinate. The S66.PLC generates positioning control instructions containing the gate coordinates and sends them to the casting equipment; S67. After receiving the confirmation signal for completion of pouring, the PLC updates the status of the sand box in the station-sand box information mapping table to "poured" and triggers the first-in-first-out queue mechanism in step S34 to update the station-sand box information mapping table for the entire pouring row.

[0013] Secondly, this application also provides a system for storing information carried by sand boxes, which is used to implement the sand box storage method described in the first aspect. It is applied to a multi-layer, multi-row roller conveyor type waiting silo in a casting production line, including a touch screen, a PLC and a roller conveyor system. The touchscreen includes: The formula database construction unit is used to pre-build and store a formula database containing key process parameters and management information for each type of sand box. The human-computer interaction unit includes a display area for dynamically displaying information and an operation interface for receiving user commands. The first communication unit is used for data interaction with the PLC; The PLC includes: The second communication unit is used to interact with the sensors of the touch screen and the roller conveyor system. Storage unit, used to create and maintain dynamic workstation-sandbox information mapping table; The workstation information tracking unit is configured to receive recipe data from the touch screen and roller conveyor movement and workstation status signals from the sensors via the second communication unit, and bind the received recipe data or existing data in the workstation-sandbox information mapping table to the corresponding physical workstation according to the signals, so as to update the workstation-sandbox information mapping table. The process control unit is configured to generate and output instructions for controlling the selection and arrangement of sand in the warehouse, the distribution of pouring, the timing of cooling, and the operation of equipment, based on real-time data in the workstation-sandbox information mapping table.

[0014] Thirdly, embodiments of this application also provide a storage medium storing a computer program thereon, which, when executed by a processor, implements the steps of the method for storing information in a sandbox as described in the first aspect.

[0015] As can be seen from the above technical solutions, this application has the following advantages: The method, system, and medium for storing sand box information provided in this application utilize existing touchscreen and PLC hardware, avoiding the high costs of building complex information systems. It eliminates the need for additional barcode scanning equipment and touchscreen all-in-one machines, reducing equipment investment and upgrade costs. It achieves automatic association between sand box information and the storage station, reducing the time and labor intensity of manual information verification, avoiding errors such as incorrect or missed pouring, and improving production stability. Through program logic optimization, it achieves accurate binding, storage, and visualization of sand box information, eliminating the need for manual intervention in selection and information verification throughout the process, thus improving the intelligent management level of the production line and enabling effective information interaction between the pouring line and third-party pouring equipment. By establishing a standardized formula information storage repository, it is possible to accurately trace the movement trajectory, process parameters, and management information of the sand boxes, facilitating anomaly handling and quality control during production. The addition of an information modification function on the touchscreen interface allows staff to quickly handle abnormal information during production, improving operational flexibility. Attached Figure Description

[0016] To more clearly illustrate the technical solution of this application, the accompanying drawings used in the description will be briefly introduced below. Obviously, the accompanying drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0017] Figure 1 This is a flowchart illustrating the method for storing information carried in a sandbox according to the present invention.

[0018] Figure 2 A schematic diagram of the recipe selection interface on the touch screen of this invention.

[0019] Figure 3 This is a schematic diagram of the system for storing information in a sandbox according to the present invention. Detailed Implementation

[0020] The various embodiments of this disclosure will be described more fully in the detailed steps of the method for storing information carried in a sandbox described below. This disclosure may have various embodiments, and adjustments and changes may be made therein. However, it should be understood that there is no intention to limit the various embodiments of this disclosure to the specific embodiments disclosed herein, but rather this disclosure should be understood to cover all adjustments, equivalents, and / or alternatives falling within the spirit and scope of the various embodiments of this disclosure.

[0021] This embodiment provides a method for storing information carried in sand boxes, realizing automatic binding and visualization of sand box information, reducing costs, improving production efficiency, and enhancing information traceability.

[0022] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0023] Please see Figure 1 The diagram shows a flowchart of a method for storing information in a sand box according to a specific embodiment. This method is applied to a multi-layer, multi-row roller conveyor type casting silo in a casting production line and is implemented using a touch screen and PLC. The method includes the following steps: S1. Build a sand box formula database in the touch screen to store the formula data corresponding to each model of sand box. Configure station information tracking logic in the PLC to create and maintain a dynamic station-sand box information mapping table. Configure a display area for dynamically displaying the station-sand box information mapping table and an operation interface for receiving modification instructions on the human-machine interface of the touch screen. It should be noted that by building a formula database, centralized management of sand box information is achieved, which facilitates quick querying and retrieval of key process parameters and management information for various sand box models; it provides a foundation for the dynamic binding of sand box information with workstations in the future, ensuring that the sand box information can accurately reflect the physical location in real time; through a visual interface, operators can intuitively understand the workstation status and sand box information, and a modification interface is provided, which enhances the flexibility of the system. S2. After the sand box is closed, in response to the user's selection operation of the current sand box formula data from the sand box formula database on the touch screen, the selected sand box formula data is sent to the PLC as the sand box identification information; It should be noted that the rapid transmission and updating of sand box information has been achieved, ensuring that the PLC can obtain the current sand box identification information in a timely manner, providing a basis for subsequent workstation binding and process control; The S3.PLC executes station information tracking logic, which binds the received sand box identification information with the actual station currently occupied by the sand box based on the action signals and station status signals collected from the roller conveyor system, and dynamically updates the station-sand box information mapping table. It should be noted that by monitoring sensor signals, the automatic binding and dynamic updating of sand box information with workstations were achieved, ensuring the accurate correspondence between sand box information and physical location and improving the accuracy of information management. S4. The touch screen obtains the updated workstation-sandbox information mapping table from the PLC in real time and displays it dynamically in the display area; It should be noted that this step enables operators to understand the status of the sand box and the cooling progress of each workstation in real time, which facilitates the timely detection and handling of abnormalities and improves the controllability and transparency of production. S5. Determine whether a modification instruction for a sandbox has been received from the user through the operation interface. If received, send the modification instruction to the PLC. It should be noted that the function of modifying sand box information is provided, which enhances the flexibility and adaptability of the system, enabling it to quickly respond to abnormal situations in the production process and ensure the smooth progress of production. The S6.PLC automatically executes process control operations based on real-time data in the workstation-sand box information mapping table; the operation process includes warehouse selection and arrangement, post-pouring return to warehouse allocation, and automatic timing and monitoring of cooling time. It should be noted that this step automates the entire process of sand box selection and arrangement, return to storage and allocation, cooling time timing and monitoring, thereby improving production efficiency and stability, reducing manual intervention and labor intensity.

[0024] This embodiment uses a touch screen and PLC to achieve automatic binding and dynamic updating of sand box information, avoiding errors from manual verification, reducing costs, improving production efficiency, enhancing information traceability, and improving the level of intelligence.

[0025] Furthermore, as a refinement and extension of the specific implementation of the above embodiments, in order to fully illustrate the specific implementation process in this embodiment, another method for storing information in a sand box is provided. This method is applied to a multi-layer, multi-row roller conveyor type casting silo in a casting production line and is implemented based on a touch screen and PLC. The method includes the following steps: S1. Construct a sand box formula database in the touch screen to store formula data corresponding to each model of sand box. Configure station information tracking logic in the PLC to create and maintain a dynamic station-sand box information mapping table. Configure a display area for dynamically displaying the station-sand box information mapping table and an operation interface for receiving modification commands on the touch screen's human-machine interface. The specific steps of step S1 are as follows: S11. In the recipe function of the touch screen, create a sand box recipe database indexed by the sand box model. Each recipe record stores a set of key process parameters and management information related to the sand box model. The key process parameters and management information include the sand box model, the required weight of molten iron, the target warehousing discharge, the preset cooling time, the X coordinate of the gate, and the Y coordinate of the gate. For example, in the MCGS Pro software on the touchscreen, a "Sand Box Recipe Library" is created using the recipe management tool. The index field is set to "Sand Box Model," the data type is a string, and the length is 20 bytes. The remaining fields are set according to the types of key process parameters and management information. Among them, the molten iron weight and gate coordinates are real numbers (with 3 decimal places), the target entry row is an integer (1-26), and the preset cooling time is an integer (unit: hours). Recipe data for 20 commonly used sand box models can be batch-entered by importing an Excel spreadsheet. At the same time, it is supported to manually add, edit, or delete recipe records on the touchscreen interface. S12. Define a structured variable in the PLC program to map the workstation-sandbox information, and establish a mapping relationship between the physical workstation number and the recipe data stored in the sandbox at the corresponding workstation; the data stored in the structured variable for each workstation shall include at least the sandbox name, status flag, preset cooling time and real-time calculated remaining cooling time; For example, a structured variable "Station_Sandbox_Map" is defined in the PLC program, with the following specific structure: plaintext TYPE Sandbox_Info: STRUCT Sandbox_Name: STRING

[20] ; / / Sandbox name Status_Flag: INT; / / Status flags: 0 = Idle, 1 = Pourable, 2 = Poured, 3 = Cooling, 4 = Ready to be removed Preset_Cool_Time: INT; / / Preset cooldown time (minutes) Remaining_Cool_Time: INT; / / Remaining cooldown time (minutes) Gate_X: REAL; / / Gate X coordinate (mm) Gate_Y: REAL; / / Y-coordinate of the gate (mm) Required_Iron_Water: REAL; / / Required weight of molten iron (kg) Target_Row: INT; / / Target row to be inserted into the database END_STRUCT END_TYPE VAR Station_Sandbox_Map: ARRAY[1..24] OF Sandbox_Info; / / Workstation-Sandbox Information Mapping Table END_VAR S13. Write station information tracking logic in the PLC program. The station information tracking logic is configured to add, delete or shift data in the station-sand box information mapping table in response to the roller sensor signal representing the change in sand box position. For example, an interrupt service routine is written in the PLC program, which executes the following logic when a sensor signal triggers an interrupt: If a new sand box is detected to have moved into the pouring silo (judged by a combination of proximity switch at the entrance and photoelectric sensor signal at the workstation), the corresponding recipe data packet is read from the PLC preset data storage area, written into the corresponding workstation entry in the mapping table, and the status flag is set to "pending pouring" (1). If the movement of the sandbox is detected in the warehouse (determined by the sequential triggering of sensor signals from adjacent workstations), the Sandbox_Info data of the original workstation is copied to the new workstation, the data of the original workstation is cleared, and the status flag is set to "idle" (0). For the pouring station (assuming stations 1-8 on the first floor are the pouring stations), a first-in-first-out (FIFO) queue mechanism is adopted: when the sand box at station 1 is removed, the mapping table data of stations 2-8 is shifted forward one position in sequence, and the data of station 8 is cleared; when a new sand box enters the pouring station, it is written into the table entry of station 8. S14. In the graphical user interface of the touch screen, add a display view corresponding to the workstation-sandbox information mapping table data structure, and add an editing control embedded in the display view as an operation interface; For example, a "Workstation Information Monitoring" page is created on the touchscreen interface, using a 6x8 grid layout to simulate a 2-layer, 6-row pouring silo structure. Each grid corresponds to a workstation, and the grid displays the sand box name, status indicators (distinguished by different colors: pouring = yellow, poured and cooling = red, cooling complete and ready to be removed = green, idle = white), cooling progress bar, and remaining cooling time. On the right side of the page, three functional areas are set up: "Recipe Selection," "Information Modification," and "Manual Control." The "Information Modification" functional area contains editing controls, allowing users to select a workstation and modify relevant parameters. S2. After the sand box is closed, in response to the user's selection of the current sand box formula data from the sand box formula database on the touch screen, the selected sand box formula data is sent to the PLC as the sand box's identification information; the specific steps of step S2 are as follows: S21. After the sand box assembly process is completed, the operator can select or enter the model corresponding to the current sand box from the list of the formula database through the formula selection interface on the touch screen to generate a call request; For example, such as Figure 2 As shown, after the sand box assembly process is completed, the operator can select the model corresponding to the current sand box (such as "CDC00001") from the drop-down list in the "Formula Selection" function area of ​​the touch screen, or directly enter the sand box model to generate a call request. If the entered sand box model does not exist in the formula database, the touch screen will pop up a prompt box, allowing the user to manually add a new formula; S22. Based on the call request, read the sand box formula data corresponding to the sand box model from the sand box formula database and generate a structured formula data package; For example, the touchscreen reads all field data corresponding to the sand box model from the recipe database according to the call request, and generates a structured recipe data package in a preset format. An example of the data format is shown in Table 1 below: Table 1

[0026] S23. Based on the preset communication interface, send the recipe data packet to the preset data storage area of ​​the PLC; For example, the touch screen sends the recipe data packet to the PLC's data storage area (DB block) via the PROFNET protocol; after receiving the data, the PLC binds the recipe data in the DB block to the workstation. S3. The PLC executes the station information tracking logic. Based on the action signals and station status signals collected from the roller conveyor system, it binds the received sand box identification information with the station currently occupied by the sand box and dynamically updates the station-sand box information mapping table. The specific steps of step S3 are as follows: The S31.PLC continuously monitors the sensor signals connected to each roller conveyor section and workstation. For example, the PLC continuously monitors the sensor signals of each station through the digital input module to obtain the occupancy status of each station and the position change information of the sand box in real time; for example, when the proximity switch signal (I1.2) of station 2, row 5, layer 2 changes from 1 to 0, it indicates that a sand box has been moved into the station; when the proximity switch signal (I1.2) changes from 0 to 1, it indicates that the sand box is about to be moved from the current row to another row. S32. When the PLC determines from the sensor signal that a sand box has moved into an empty station in the pouring silo, the station information tracking logic is triggered; For example, the PLC performs logical judgment on the sensor signals. When it detects that a sand box has moved into an empty station in the pouring silo (the status flag of a station is 0 and the corresponding photoelectric sensor signal is 0), it triggers the station information tracking logic. S33. Determine the data source for the sandbox information to be bound and perform the binding: If the sand box has just entered the pouring silo, the corresponding formula data packet issued in step S2 will be written into the corresponding workstation table entry of the workstation-sand box information mapping table. If a sand box is moved from one station to another within the pouring silo, the sand box formula data information will be transferred from the original station table entry or copied to the new station table entry. For example, if the sand box has just entered the pouring silo (determined by the proximity switch signal I0.1 at the entrance), the recipe data packet of the temporary storage area (L area) is written into the table entry of the corresponding station in Station_Sandbox_Map. For example, if the sand box is moved into station 2, row 5, floor 2 (array index 14), the CDC00001 recipe data of L area is written into Station_Sandbox_Map

[14] , and Station_Sandbox_Map

[14] .Status_Flag is set to 1 (pouring required).

[0027] If the sandbox is moved within the warehouse (e.g., from workstation 2 in row 5 on the 2nd floor to workstation 3 in row 5 on the 3rd floor), then all data in Station_Sandbox_Map

[14] will be copied to Station_Sandbox_Map

[15] by the program, and Station_Sandbox_Map

[14] .Status_Flag will be set to 0 (idle), while Station_Sandbox_Map

[15] .Status_Flag will remain unchanged; S34. For the casting station queue, the first-in-first-out queue mechanism is used to update the mapping table: when the sand box at the front of the queue is removed, the binding information of all subsequent stations is shifted forward by one position, and the information of the newly entered sand box at the tail end is written into the last table entry. For example, for pouring stations 1-8 on the first floor, a FIFO queue mechanism is used for management. When the sand box at station 1 is moved out (sensor signal I3.1 changes from 1 to 0), the PLC executes a cyclic shift instruction to move the data from Station_Sandbox_Map[2] to Station_Sandbox_Map[8] forward sequentially to Station_Sandbox_Map[1] to Station_Sandbox_Map[7], and the data in Station_Sandbox_Map[8] is cleared; when a new sand box enters the pouring station, it is written into the Station_Sandbox_Map[8] table. S4. The touchscreen obtains the updated workstation-sandbox information mapping table from the PLC in real time and displays it dynamically in the display area; the specific steps of step S4 are as follows: S41. The touchscreen reads station-sandbox information mapping table data from the PLC; For example, the touch screen reads all the data once from the PLC's Station_Sandbox_Map variable via the PROFINET protocol to ensure the real-time display of information; S42. Parse the workstation-sandbox information mapping table data and extract the sandbox name, status flag, remaining cooling time and preset cooling duration under each workstation table item; For example, the touch screen parses the read mapping table data, extracts key information such as the sand box name, status flag, preset cooling time, and remaining cooling time for each station, and converts it into corresponding Chinese display according to the status flag (e.g., 1 → "Pending pouring", 3 → "Cooling"). S43. Render the parsed data to the display area according to the preset layout, and generate a progress bar or countdown text as a visual element of the cooling progress in the display entry of the corresponding sandbox according to the ratio of the remaining cooling time to the preset cooling duration. For example, the parsed data is rendered to the display area in a 6x8 grid layout, with each workstation's grid containing: Display the sandbox name (e.g., "CDC00001") and status indicators (distinguished by different colored backgrounds); Draw a cooling progress bar. The progress bar length = (remaining cooldown time / preset cooldown time) × 100%. For example, when the preset cooldown time is 480 minutes and the remaining cooldown time is 240 minutes, the progress bar will show 50%. Displays the remaining cooldown time (e.g., "240 minutes") and the preset cooldown duration (e.g., "480 minutes").

[0028] Meanwhile, for workstations with a status of "removable" (4), the grid border flashes to prompt operators to handle the situation promptly; S5. Determine whether a modification command for a sandbox has been received from the user through the operation interface. If so, send the modification command to the PLC. The specific steps of step S5 are as follows: S51. Listen for events of the edit control in the touchscreen operation interface; For example, the touch screen continuously listens for trigger events of the editing controls in the operation interface, including changes in the content of the text input box, switching of options in the drop-down selection box, and click events of the confirmation button; S52. When a user selects a sandbox item in the display area and enters a modified value through the editing control, the touch screen generates a structured modification instruction containing the target workstation identifier, the modified field, and the new value. For example, when the operator selects station number 2 in row 5 of floor 2 (Station_Sandbox_Map

[14] ), modifies the preset cooling time from 480 minutes to 540 minutes through the text input box, and clicks the confirmation button, the touch screen generates a structured modification instruction, which includes the target station identifier (14), the modification field (Preset_Cool_Time) and the new value (540). S53. The touch screen sends the structured modification instruction to the PLC to update the specified field in the corresponding workstation table item of the workstation-sandbox information mapping table; For example, the touch screen sends the modification instruction to the DB2 block of the PLC. After receiving the signal, the PLC reads the modification information in the DB2 block, updates Station_Sandbox_Map

[14] .Preset_Cool_Time to 540, and recalculates the remaining cooling time (remaining cooling time = 540 - accumulated cooling time) to ensure that the mapping table data is consistent with the user's modification. S6. The PLC automatically executes process control operations based on real-time data in the workstation-sand box information mapping table; the operation process includes warehousing selection and arrangement, post-pouring return to warehousing allocation, and automatic timing and monitoring of cooling time; the specific steps of step S6 are as follows: According to the workstation-sand box information mapping table, the S61.PLC calculates and triggers the operation of the corresponding roller conveyor for the sand box that has just entered the warehouse and has not been assigned a workstation, based on the target warehouse entry information in the corresponding formula data, and transports the sand box to the target row. For example, the PLC monitors in real time the sand boxes in the Station_Sandbox_Map that are in the state of "Pending Pouring" (1) and have not been assigned a workstation (the Target_Row field is not 0), and calculates the roller conveyor operation path based on the Target_Row information. For example, if the target entry row of the sand box is row 23 (2 layers, 3 rows), the PLC triggers the operation of the 2nd layer roller conveyor motor (Q0.2) and the inter-row transfer motor (Q1.3) to transport the sand box from the entrance to the corresponding workstation in the 2nd layer, 3rd row. After the sand box arrives, the status flag of the workstation is updated to "Pending Pouring". S62. For sand boxes that have been poured, the PLC automatically assigns a return path and an idle target workstation to the poured sand box according to the sand box status and preset scheduling strategy in the workstation-sand box information mapping table, and triggers the corresponding roller conveyor control. For example, after the sand box is poured, the PLC queries the Station_Sandbox_Map for the station with the status of "idle" (0) according to the preset scheduling strategy (prioritizing the allocation of idle stations on the same floor), determines the target station for returning to the warehouse (such as the 6th row of the 2nd floor), and triggers the corresponding roller conveyor motor to send the sand box out of the pouring row. The PLC controls the sand box to be transported to the target station. After it arrives, the status flag of the station is updated to "poured and waiting to cool" (3). S63. For sand boxes in the cooling station, the PLC starts an independent timer based on the preset cooling time of the sand box in the cooling station according to the station-sand box information mapping table, and calculates the remaining cooling time in real time: Remaining cooling time = preset time - (current Beijing time - Beijing time when this sand box is completed and removed from the warehouse); The calculation results of the remaining cooling time are updated in real time to the corresponding entries in the workstation-sandbox information mapping table; For example, after the sand box is transferred out of the pouring grate, the PLC updates the cooling time in real time and updates the Station_Sandbox_Map in real time; for example, if the preset cooling time is 540 minutes, and 120 minutes have been accumulated, Remaining_Cool_Time = 540 - 120 = 420 minutes. S64. When the remaining cooling time of a sand box drops to zero or a preset threshold, the PLC automatically updates the status of the corresponding sand box in the workstation-sand box information mapping table to be removable, and can trigger an outbound command when subsequent process conditions are met. For example, when the Remaining_Cool_Time of a certain workstation drops to 0 or a preset threshold (such as 30 minutes), the PLC automatically updates the Status_Flag of that workstation to "removable" (4) and triggers an audible and visual alarm (Q2.0) to alert the operator. After the operator confirms the removal from the warehouse, the PLC triggers the roller conveyor motor to move the sand box out of the pouring silo. Once in place, the mapping table data of that workstation is cleared, and the status flag is restored to "idle" (0). The S65.PLC monitors the status of the first station in the pouring row in real time. When the station-sand box information mapping table shows that the first station in the row has a sand box and the status is "to be poured", it reads the gate coordinates stored in the corresponding station table entry. The gate coordinates include the gate X coordinate and the gate Y coordinate. The S66.PLC generates positioning control instructions containing the gate coordinates and sends them to the casting equipment; S67. After receiving the confirmation signal for completion of pouring, the PLC updates the status of the sand box in the station-sand box information mapping table to be poured, and triggers the first-in-first-out queue mechanism in step S34 to update the station-sand box information mapping table for the entire pouring row. For example, the PLC monitors the status of the pouring station in real time. When Status_Flag is "to be poured" (1), it reads the Gate_X (234.500mm) and Gate_Y (240.000mm) coordinates of all stations of the pouring station. The PLC generates a positioning control command containing the coordinates of the gating gate, which is sent to the PLC of the gating equipment via the PN / PN coupler to accurately position the gating gate to the target coordinates. After the casting equipment completes the casting, the casting machine sends a confirmation signal to our PLC (the signal changes from 0 to 1). The PLC updates Station_Sandbox_Map[1].Status_Flag to "cast" (2) and triggers the casting queue FIFO mechanism to move the data of stations 2-8 forward by one position to prepare for the next sand box casting.

[0029] It should be understood that the sequence number of each step in the above embodiments does not imply the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of the present invention.

[0030] This application is applicable to casting production scenarios of various multi-layer, multi-row roller conveyor casting cooling silos, especially old production lines that have not been planned for information technology construction in the early stage.

[0031] like Figure 2 As shown, the following are embodiments of the system for storing sand box carrying information in a database provided by this disclosure. This system and the method for storing sand box carrying information in a database in the above embodiments belong to the same inventive concept. For details not described in detail in the embodiments of the system for storing sand box carrying information in a database, please refer to the embodiments of the method for storing sand box carrying information in a database described above.

[0032] The system is used to realize the method of carrying sand boxes into the warehouse. It is applied to the multi-layer, multi-row roller conveyor type waiting warehouse in the casting production line and includes a touch screen, PLC and roller conveyor system. The touchscreen includes: The formula database construction unit is used to pre-build and store a formula database containing key process parameters and management information for each type of sand box. The human-computer interaction unit includes a display area for dynamically displaying information and an operation interface for receiving user commands. The first communication unit is used for data interaction with the PLC; The PLC includes: The second communication unit is used to interact with the sensors of the touch screen and the roller conveyor system. Storage unit, used to create and maintain dynamic workstation-sandbox information mapping table; The workstation information tracking unit is configured to receive recipe data from the touch screen and roller conveyor movement and workstation status signals from the sensors via the second communication unit, and bind the received recipe data or existing data in the workstation-sandbox information mapping table to the corresponding physical workstation according to the signals, so as to update the workstation-sandbox information mapping table. The process control unit is configured to generate and output instructions for controlling the selection and arrangement of sand in the warehouse, the distribution of pouring, the timing of cooling, and the operation of equipment, based on real-time data in the workstation-sandbox information mapping table.

[0033] This embodiment achieves automatic binding and visualization of sand box information through the interactive collaboration of the formula database construction unit, human-computer interaction unit, first communication unit, storage unit, workstation information tracking unit, and process control unit, thereby reducing costs, improving production efficiency, and enhancing information traceability capabilities.

[0034] The storage medium provided in this application stores a program product that enables a method for storing information carried by a sandbox into a database.

[0035] The method for storing sand box information in a database includes: applying a multi-layer, multi-row roller conveyor-type casting silo to a casting production line, implemented based on a touchscreen and a programmable logic controller (PLC), comprising the following steps: constructing a sand box formula database in the touchscreen to store formula data corresponding to each type of sand box; configuring station information tracking logic in the PLC to create and maintain a dynamic station-sand box information mapping table; configuring a display area for dynamically displaying the station-sand box information mapping table and an operation interface for receiving modification commands on the touchscreen's human-machine interface; and, in response to the user's selection of the current sand box formula data from the sand box formula database on the touchscreen, using the selected formula data as the sand box's identification information. The information is sent to the PLC; the PLC executes the station information tracking logic, and based on the action signals and station status signals collected from the roller conveyor system, it binds the received sand box identification information with the station currently occupied by the sand box, and dynamically updates the station-sand box information mapping table; the touch screen obtains the updated station-sand box information mapping table from the PLC in real time and displays it dynamically in the display area; it determines whether a user's modification instruction for a certain sand box has been received through the operation interface, and if so, sends the modification instruction to the PLC; the PLC automatically executes the process control operation based on the real-time data in the station-sand box information mapping table; the operation process includes warehousing selection and arrangement, post-pouring return to warehousing allocation, and automatic timing and monitoring of cooling time.

[0036] In some possible implementations, the method of carrying information into a database using a sandbox disclosed herein can be implemented as a program product comprising program code that, when the program product is run on a terminal device, causes the terminal device to perform the steps described in the "Exemplary Methods" section of this specification according to various exemplary embodiments of this disclosure.

[0037] The storage medium disclosed herein may be any combination of one or more readable media. A readable medium may be a readable signal medium or a readable storage medium. A readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples (a non-exhaustive list) of readable storage media include: an electrical connection having one or more wires, a portable disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage device, magnetic storage device, or any suitable combination thereof.

[0038] The above description of the disclosed embodiments enables those skilled in the art to make or use the invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the invention. Therefore, the invention is not to be limited to the embodiments shown herein, but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A method for storing information in a sandbox, characterized in that, A multi-layer, multi-row roller conveyor type pouring silo, applied to a casting production line and implemented using a touch screen and PLC, includes the following steps: S1. Build a sand box formula database in the touch screen to store the formula data corresponding to each model of sand box. Configure station information tracking logic in the PLC to create and maintain a dynamic station-sand box information mapping table. Configure a display area for dynamically displaying the station-sand box information mapping table and an operation interface for receiving modification instructions on the human-machine interface of the touch screen. S2. After the sand box is closed, in response to the user's selection operation of the current sand box formula data from the sand box formula database on the touch screen, the selected sand box formula data is sent to the PLC as the sand box identification information; The S3.PLC executes station information tracking logic, which binds the received sand box identification information with the actual station currently occupied by the sand box based on the action signals and station status signals collected from the roller conveyor system, and dynamically updates the station-sand box information mapping table. S4. The touch screen obtains the updated workstation-sandbox information mapping table from the PLC in real time and displays it dynamically in the display area; S5. Determine whether a modification instruction for a sandbox has been received from the user through the operation interface. If received, send the modification instruction to the PLC. The S6.PLC automatically executes process control operations based on real-time data in the workstation-sand box information mapping table; the operation process includes warehouse selection and arrangement, post-pouring return to warehouse allocation, and automatic timing and monitoring of cooling time.

2. The method for storing information carried in a sandbox according to claim 1, characterized in that, The specific steps of step S1 are as follows: S11. In the recipe function of the touch screen, create a sand box recipe database indexed by the sand box model. Each recipe record stores a set of key process parameters and management information related to the sand box model. The key process parameters and management information include the sand box model, the required weight of molten iron, the target warehousing discharge, the preset cooling time, the X coordinate of the gate, and the Y coordinate of the gate. S12. Define a structured variable in the PLC program to map the workstation-sandbox information, and establish a mapping relationship between the physical workstation number and the recipe data stored in the sandbox at the corresponding workstation; the data stored in the structured variable for each workstation shall include at least the sandbox name, status flag, preset cooling time and real-time calculated remaining cooling time; S13. Write station information tracking logic in the PLC program. The station information tracking logic is configured to add, delete or shift data in the station-sand box information mapping table in response to the roller sensor signal representing the change in sand box position. S14. In the graphical user interface of the touch screen, add a display view corresponding to the workstation-sandbox information mapping table data structure, and add an editing control embedded in the display view as an operation interface.

3. The method for storing information carried in a sandbox according to claim 1, characterized in that, The specific steps of step S2 are as follows: S21. After the sand box assembly process is completed, the operator can select or enter the model corresponding to the current sand box from the list of the formula database through the formula selection interface on the touch screen to generate a call request; S22. Based on the call request, read the sand box formula data corresponding to the sand box model from the sand box formula database and generate a structured formula data package; S23. Based on the preset communication interface, send the recipe data packet to the preset data storage area of ​​the PLC.

4. The method for storing information carried in a sandbox according to claim 1, characterized in that, The specific steps of step S3 are as follows: The S31.PLC continuously monitors the sensor signals connected to each roller conveyor section and workstation. S32. When the PLC determines from the sensor signal that a sand box has moved into an empty station in the pouring silo, the station information tracking logic is triggered; S33. Determine the data source for the sandbox information to be bound and perform the binding: If the sand box has just entered the pouring silo, the corresponding formula data packet issued in step S2 will be written into the corresponding workstation table entry of the workstation-sand box information mapping table. If a sand box is moved from one station to another within the pouring silo, the sand box formula data information will be transferred or copied from the original station table to the new station table. S34. For the casting station queue, the first-in-first-out queue mechanism is used to update the mapping table: when the sand box at the front of the queue is removed, the binding information of all subsequent stations is shifted forward by one position, and the information of the newly entered sand box at the rear is written into the last table entry.

5. The method for storing information carried in a sandbox according to claim 4, characterized in that, The specific steps of step S4 are as follows: S41. The touchscreen reads station-sandbox information mapping table data from the PLC; S42. Parse the workstation-sandbox information mapping table data and extract the sandbox name, status flag, remaining cooling time and preset cooling duration under each workstation table item; S43. Render the parsed data to the display area according to the preset layout, and generate a progress bar or countdown text as a visual element of the cooling progress in the display entry of the corresponding sandbox according to the ratio of the remaining cooling time to the preset cooling duration.

6. The method for storing information carried in a sandbox according to claim 1, characterized in that, The specific steps of step S5 are as follows: S51. Listen for events of the edit control in the touchscreen operation interface; S52. When a user selects a sandbox item in the display area and enters a modified value through the editing control, the touch screen generates a structured modification instruction containing the target workstation identifier, the modified field, and the new value. S53. The touch screen sends a structured modification instruction to the PLC to update the specified field in the corresponding workstation table entry of the workstation-sandbox information mapping table.

7. The method for storing information carried by a sandbox in a database according to claim 5, characterized in that, The specific steps of step S6 are as follows: According to the workstation-sand box information mapping table, the S61.PLC calculates and triggers the operation of the corresponding roller conveyor for the sand box that has just entered the warehouse and has not been assigned a workstation, based on the target warehouse entry information in the corresponding formula data, and transports the sand box to the target row. S62. For sand boxes that have been poured, the PLC automatically assigns a return path and an idle target workstation to the poured sand box according to the sand box status and preset scheduling strategy in the workstation-sand box information mapping table, and triggers the corresponding roller conveyor control. S63. For sand boxes in the cooling station, the PLC starts an independent timer based on the preset cooling time of the sand box in the cooling station according to the station-sand box information mapping table, and calculates the remaining cooling time in real time: Remaining cooling time = preset time - (current time - the time when this sand box is completed and removed from the warehouse); The calculation results of the remaining cooling time are updated in real time to the corresponding entries in the workstation-sandbox information mapping table; S64. When the remaining cooling time of a sand box drops to zero or a preset threshold, the PLC automatically updates the status of the corresponding sand box in the workstation-sand box information mapping table to be removable, and can trigger an outbound command when subsequent process conditions are met.

8. The method for storing information carried in a sandbox according to claim 7, characterized in that, Step S6 also includes a pouring control step: The S65.PLC monitors the station status of the pouring grate in real time. When the station-sand box information mapping table shows that the first station of the grate has a sand box and the status is "to be poured", it reads the gate coordinates stored in the corresponding station table entry. The gate coordinates include the gate X coordinate and the gate Y coordinate. The S66.PLC generates positioning control instructions containing the gate coordinates and sends them to the casting equipment; S67. After receiving the confirmation signal for completion of pouring, the PLC updates the status of the sand box in the station-sand box information mapping table to "poured" and triggers the first-in-first-out queue mechanism in step S34 to update the station-sand box information mapping table for the entire pouring row.

9. A system for storing information carried by sand boxes, used to implement the sand box storage method according to any one of claims 1 to 8, applied to a multi-layer, multi-row roller conveyor type casting silo in a casting production line, characterized in that, Includes touch screen, PLC, and roller conveyor system; The touchscreen includes: The formula database construction unit is used to pre-build and store a formula database containing key process parameters and management information for each type of sand box. The human-computer interaction unit includes a display area for dynamically displaying information and an operation interface for receiving user commands. The first communication unit is used for data interaction with the PLC; The PLC includes: The second communication unit is used to interact with the sensors of the touch screen and the roller conveyor system. Storage unit, used to create and maintain dynamic workstation-sandbox information mapping table; The workstation information tracking unit is configured to receive recipe data from the touch screen and roller conveyor movement and workstation status signals from the sensors via the second communication unit, and bind the received recipe data or existing data in the workstation-sandbox information mapping table to the corresponding physical workstation according to the signals, so as to update the workstation-sandbox information mapping table. The process control unit is configured to generate and output instructions for controlling the selection and arrangement of sand in the warehouse, the distribution of pouring, the timing of cooling, and the operation of equipment, based on real-time data in the workstation-sandbox information mapping table.

10. A 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 method for storing information in a sandbox as described in any one of claims 1 to 8.

Images