Industrial gas production and sales traceability management system

Abstract

The present invention discloses an industrial gas production and sales traceability management system, comprising a server, data acquisition equipment, a sales information system, a container filling management module, a container in-and-out management module, a product quality management module, a product inventory management module, and a data traceability module. The server includes a data acquisition cache server and a database server. The data acquisition cache server periodically generates data from the data acquisition equipment and caches the data using an internal algorithm. The database server periodically reads the classified data from the data acquisition cache server for long-term storage, which is then directly read and accessed by the sales information system. The sales information system reads and processes the data from the database server and then connects to modules such as the container filling management module. This invention solves the problem that existing industrial gas sales data cannot be combined with production data and that sales data cannot be traced.

Description

Technical Field

[0001] The present invention relates to the technical field of industrial gas production, and in particular to an industrial gas production and sales traceability management system based on a data acquisition system. Background Art

[0002] Currently, the industrial gas production and sales sector suffers from a lack of close management between production and sales departments. Data from industrial gas production control systems (DCS, PLCs, or primary metering equipment) cannot be directly utilized by sales information systems. Data such as filling quantities in sales information systems must be manually entered, leading to errors in filling quantities and difficulty tracing product filling quantities and quality analysis results. These issues create inconvenience for both sales and customers. Consequently, a traceability management system for industrial gas production and sales is urgently needed. Summary of the Invention

[0003] The problem to be solved by the present invention is to provide an industrial gas production and sales traceability management system to solve the problem that existing industrial gas sales data cannot be used in conjunction with production data and sales data cannot be traced.

[0004] In order to solve the above problems, the technical solution of the present invention is as follows: the industrial gas production and sales traceability management system includes a server, data acquisition equipment, a sales information system, a container filling management module, a container entry and exit management module, a product quality management module, a product inventory management module and a data traceability module;

[0005] The server side includes a data acquisition cache server and a database server; the data acquisition cache server periodically reads data acquired by the industrial gas production control system through communication from the data acquisition device and caches the data by classification using an internal algorithm; the database server periodically reads the classified data from the data acquisition cache server for long-term storage, which is then directly read and called by the sales information system;

[0006] The sales information system displays the data and calculation results stored on the server side, and provides various interfaces for data and expansion use; the sales information system reads the data in the database server and processes it, and then connects with the container filling management module, the container entry and exit management module, the product quality management module, the product inventory management module and the data traceability module respectively.

[0007] In the above technical solution, a more specific solution may be: the container filling management module, the container entry and exit management module, the product quality management module, the product inventory management module and the data traceability module are all connected to the sales information system, and the container filling management module, the container entry and exit management module, the product quality management module, the product inventory management module and the data traceability module are connected to each other.

[0008] Furthermore: when data is collected to the data collection cache server at a certain period, it is recorded according to the data information of the measuring point number, time, measurement value and unit, and stored in the database server for reading and calling by the sales information system.

[0009] Furthermore: the data acquisition device collects and processes the data on the server side and then binds it to the product container and sales data, and the data is retained in real time and recorded with a timestamp.

[0010] Furthermore: the container filling management module is installed in a handheld code scanning terminal, and the handheld code scanning terminal binds the container and the product by scanning the QR code generated by the container entry and exit management module.

[0011] Furthermore: it supports differentiated authority management. By logging into different role accounts, filling personnel, special equipment managers, metering equipment managers, sales personnel, company managers, and customers can have different access rights.

[0012] Furthermore: the sales information system automatically calculates the quantity of product filled in the product container and produces statistical reports.

[0013] Furthermore: after the product is sold, the customer or user accesses the data traceability module by scanning the QR code on the outside of the container to query the product quality analysis, filling time, filling personnel, and filling volume data information. The query result page also displays the instructions for use and emergency measures information of the filling medium; when the customer raises an objection to the product quality, the production time, filling data and quality analysis data of the batch of products are retrieved for easy traceability.

[0014] Furthermore: all relevant production data, inventory data, filling records, product quality information, and sales record information are stored in a physical server or cloud server, and the server data of the physical server or cloud server is in the form of multi-machine hot backup.

[0015] Due to the adoption of the above technical solution, the present invention has the following beneficial effects compared with the prior art:

[0016] This industrial gas production and sales traceability management system directly captures production, filling, and quality analysis data from the industrial gas production control system, reducing the potential for errors caused by manual data entry. This system manages the entire industrial gas production and sales process. Production data is collected via data acquisition equipment and, after server-side processing, is bound to product container and sales data. This data is retained in real time and timestamped, facilitating traceability while reducing the potential for errors caused by manual data entry. The information system automatically calculates the quantity of product filled in containers and generates statistical reports, enabling production and sales departments to maintain inventory information. If a customer raises a product quality issue, the production time, filling data, and quality analysis data for that batch of products can be promptly retrieved to facilitate tracing and identify the cause, improving overall management and service levels. BRIEF DESCRIPTION OF THE DRAWINGS

[0017] Figure 1 It is a data relationship diagram of an embodiment of the present invention. DETAILED DESCRIPTION

[0018] The embodiments of the present invention are further described below in conjunction with the accompanying drawings:

[0019] The industrial gas production and sales traceability management system includes a server, data acquisition equipment, a sales information system, a container filling management module, a container entry and exit management module, a product quality management module, a product inventory management module, and a data traceability module.

[0020] The server side includes a data acquisition cache server and a database server. The data acquisition cache server periodically reads data from the industrial gas production control system via communication methods such as OPC and RS485 from data acquisition equipment, and caches and categorizes the data using internal algorithms. The database server periodically reads and stores the categorized data from the data acquisition cache server for long-term access and direct access by the sales information system. Data collected periodically to the data acquisition cache server is recorded based on the measurement point number, time, measurement value, and unit, and stored in the database server for access and access by the sales information system. Data collected by the data acquisition equipment and processed by the server are then bound to product containers and sales data. The data is retained in real time and timestamped.

[0021] The sales information system displays the data and calculation results stored on the server side, and provides various interfaces for data and expansion use; the sales information system reads the data in the database server and processes it, and then connects to the container filling management module and the product quality management module respectively. The container filling management module connects to the container in and out management module and then connects to the data tracing module. The product quality management module connects to the product inventory management module and then connects to the data tracing module. Figure 1 shown.

[0022] In other embodiments, the container filling management module, the container entry and exit management module, the product quality management module, the product inventory management module and the data traceability module are all connected to the sales information system, and the container filling management module, the container entry and exit management module, the product quality management module, the product inventory management module and the data traceability module are connected to each other.

[0023] It supports differentiated authority management. By logging into different role accounts, filling personnel, special equipment managers, metering equipment managers, sales personnel, company managers, and customers can have different access rights.

[0024] The information system automatically calculates the quantity of product filled in the product container and produces statistical reports, making it easier for the production and sales departments to grasp product inventory information.

[0025] The container filling management module is installed in a handheld barcode scanning terminal, which binds the container to the product by scanning the QR code generated by the container inbound and outbound management module. After the product is sold, the customer or user scans the QR code on the container's exterior to access the data traceability module, querying product quality analysis, filling time, filling personnel, and filling volume data. The query results page also displays the instructions for use of the filling medium and emergency measures. If a customer raises a product quality issue, the production time, filling data, and quality analysis data for the batch of products are retrieved for easy traceability.

[0026] All relevant production data, inventory data, filling records, product quality information, and sales record information are stored in physical servers or cloud servers. Server data uses multi-machine hot backup to ensure data security to the greatest extent.

[0027] In specific implementation, in order to ensure the accuracy of data collection, verification / calibration record ledgers are made for relevant measuring equipment in the production site, including pressure transmitters, temperature transmitters, electronic balances, floor scales, etc., and regular verification or calibration is carried out according to the periodic requirements of measurement regulations. Measuring equipment involved in trade settlement is subject to mandatory verification.

[0028] Data collection: When data is collected to the data collection cache server at a certain period, it is recorded according to the measurement point number, time, measurement value, unit and other information, and stored in the database server for reading and calling by the sales information system.

[0029] During the container and product filling process, purchased or rented containers, including liquid tank trucks, tube bundle trucks, gas cylinders, and dewars, are verified by special equipment management personnel and entered into the container entry and exit management module. The module generates a QR code based on the management number and prints or laser-engraves a label affixed to the exterior of the container. On-site filling personnel use the container filling management module app installed on a handheld scanner terminal. After the product is filled, they scan the QR code on the exterior of the container and select the filling area in the container filling management module app. The system automatically retrieves current filling-related data such as temperature, pressure, gross weight, and product quality analysis results and binds them to the container, avoiding the problem of manually entered data being untraceable.

[0030] After the product is sold, customers or users can access the data traceability module by scanning the QR code on the outside of the container, and query data such as product quality analysis, filling time, filling personnel, filling quantity, etc. The page can also display information such as instructions for use and emergency measures of the filling medium.

[0031] The system technology level includes software, hardware, intranet, extranet, internal and external data interaction, APP and other aspects.

[0032] The system also supports differentiated permissions management. By logging into different role accounts, different access rights can be granted to filling personnel, special equipment managers, metering equipment managers, sales personnel, company managers, and customers. All relevant production data, inventory data, filling records, product quality information, sales records, and other information are stored on physical servers or cloud servers. Server data is backed up on multiple machines to ensure maximum data security.

[0033] This system manages the entire production and sales process of industrial gases. Production data is collected by data acquisition equipment, processed on the server, and then linked to product container and sales data. This data is retained in real time and timestamped, facilitating traceability while reducing the potential for errors caused by manual data entry. The information system automatically calculates the quantity of product filled in containers and generates statistical reports, enabling production and sales departments to maintain inventory information. If a customer raises a product quality issue, the production date, filling data, and quality analysis data for that batch of products can be promptly retrieved to facilitate tracing and identify the cause, thereby improving overall management and service levels.

[0034] This system is applicable to all industrial gas production or filling units, and can greatly improve the traceability of production and filling data, making the production and filling process traceable and user-friendly.

Claims

1. An industrial gas production and sales traceability management system, characterized by: It includes the server side, data collection equipment, sales information system, container filling management module, container entry and exit management module, product quality management module, product inventory management module and data traceability module; The server side includes a data acquisition cache server and a database server; the data acquisition cache server periodically reads data acquired by the industrial gas production control system through communication from the data acquisition device, and classifies and caches the data through an internal algorithm; The database server periodically reads the classified data from the data acquisition cache server for long-term storage, which is used for direct reading and calling by the sales information system; The sales information system displays the data and calculation results stored on the server side and provides various interfaces for data and expansion use; the sales information system reads and processes the data in the database server and then communicates with the container filling management module, the container entry and exit management module, the product quality management module, the product inventory management module and the data traceability module respectively; When data is collected to the data collection cache server at a certain period, the data is recorded according to the measurement point number, time, measurement value, and unit data information, and stored in the database server for reading and calling by the sales information system; After the product is sold, the customer or user accesses the data traceability module by scanning the QR code on the outside of the container to query the product quality analysis, filling time, filling personnel, and filling volume data information. The query result page also displays the instructions for use of the filling medium and emergency measures information; when the customer raises an objection to the product quality, the batch product production time, filling data and quality analysis data are retrieved for easy traceability.

2. The industrial gas production and sales traceability management system according to claim 1, characterized in that: The container filling management module, the container entry and exit management module, the product quality management module, the product inventory management module and the data traceability module are all connected to the sales information system, and the container filling management module, the container entry and exit management module, the product quality management module, the product inventory management module and the data traceability module are connected to each other.

3. The industrial gas production and sales traceability management system according to claim 2, characterized in that: The data acquisition device collects and processes the data on the server side and then binds it to the product container and sales data. The data is retained in real time and a timestamp is recorded.

4. The industrial gas production and sales traceability management system according to claim 3, characterized in that: The container filling management module is installed in a handheld code scanning terminal, and the handheld code scanning terminal binds the container and the product by scanning the QR code generated by the container entry and exit management module.

5. The industrial gas production and sales traceability management system according to claim 4, characterized in that: It supports differentiated authority management. By logging into different role accounts, filling personnel, special equipment managers, metering equipment managers, sales personnel, company managers, and customers can have different access rights.

6. The industrial gas production and sales traceability management system according to claim 5, characterized in that: The sales information system automatically calculates the quantity of product filled in the product container and produces statistical reports.

7. The industrial gas production and sales traceability management system according to claim 6, characterized in that: All relevant production data, inventory data, filling records, product quality information, and sales record information are stored in physical servers or cloud servers, and the server data of physical servers or cloud servers are in the form of multi-machine hot backup.

Images