Industrial gas production and sales traceability management system

Abstract

The invention discloses an industrial gas production and sales traceability management system. The system comprises a server side, a data acquisition device, a sales informatization system, a container filling management module, a container warehouse-in and warehouse-out management module, a product quality management module, a product inventory management module and a data traceability module. The server side comprises a data acquisition cache server and a database server; the data acquisition cache server periodically generates data from the data acquisition equipment, 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, and the classified data are directly read and called by the sales informatization system; and the sales informatization system is communicated with the container filling management module and other modules after reading and processing data in the database server. The problems that existing industrial gas sales data cannot be combined with production data, and the sales data cannot be traced can be solved.

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 tracing management system based on a data acquisition system. Background Art

[0002] At present, in the field of industrial gas production and sales, there is a problem that the management of the production department and the sales department is not close. The data of the industrial gas production control system (DCS, PLC or primary metering equipment) cannot be directly used by the sales information system. The data such as the filling volume in the sales information system needs to be manually entered, which leads to errors in the filling volume and the difficulty in tracing the product filling volume and quality analysis results, which brings inconvenience to both sales and customers. Based on this, 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 the existing industrial gas sales data cannot be used in conjunction with the production data and the sales data cannot be traced.

[0004] In order to solve the above problems, the technical solution of the present invention is: 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 in and out management module, a product quality management module, a product inventory management module and a 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 caches the data by classification 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 the data in the database server and processes it, and then connects with the container filling management module, the container warehousing and outbound management module, the product quality management module, the product inventory management module and the data traceability module respectively.

[0005] In the above technical scheme, a more specific scheme may be: the container filling management module, the container warehousing and out-of-warehouse 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 warehousing and out-of-warehouse management module, the product quality management module, the product inventory management module and the data traceability module are connected to each other.

[0006] Further: 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.

[0007] Furthermore: the data acquisition device collects and binds the data with the product container and sales data after being processed by the server, and the data is retained in real time and the timestamp is recorded.

[0008] Further: 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.

[0009] Further: Support for 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.

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

[0011] 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 called up for easy traceability.

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

[0013] Due to the adoption of the above technical solution, the present invention has the following beneficial effects compared with the prior art: This industrial gas production and sales traceability management system obtains production, filling, and quality analysis data directly from the industrial gas production control system to reduce the possibility of errors caused by manual data entry; it realizes the full process management of industrial gas production and sales. The production data can be collected by data acquisition equipment and bound to the product container and sales data after being processed by the server. The data will be retained in real time and the timestamp will be recorded, which is convenient for traceability and reduces the possibility of errors caused by manual data entry. The information system automatically calculates the number of products filled in the product container and forms a statistical report, which is convenient for the production and sales departments to grasp the product inventory information. If the customer raises an objection to the product quality, the production time, filling data and quality analysis data of the batch of products can be called up in time to facilitate traceability to find the cause and improve the overall management and service level. BRIEF DESCRIPTION OF THE DRAWINGS

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

[0015] The embodiments of the present invention are further described in detail below in conjunction with the accompanying drawings: 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.

[0016] The server side includes a data acquisition cache server and a database server; the data acquisition cache server periodically reads data obtained from the industrial gas production control system through OPC, RS485 and other communication methods from the data acquisition equipment, and caches the data by classification 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. When the data is collected to the data acquisition cache server at a certain period, it is recorded according to the data information of the measuring point position number, time, measurement value, and unit, and stored in the database server for reading and calling by the sales information system. After the data acquisition equipment collects and processes it on the server side, it is bound to the product container and sales data, and the data is retained in real time and the timestamp is recorded.

[0017] 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 and the product quality management module respectively. The container filling management module connects with the container in and out storage management module and then connects with the data tracing module. The product quality management module connects with the product inventory management module and then connects with the data tracing module. Figure 1 shown.

[0018] In other embodiments, the container filling management module, the container warehousing and out-of-warehouse 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 warehousing and out-of-warehouse management module, the product quality management module, the product inventory management module and the data traceability module are connected to each other.

[0019] 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.

[0020] 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.

[0021] The container filling management module is installed in the handheld code scanning terminal, which binds the container and the product by scanning the QR code generated by the container entry and exit management module. 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 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 called up for easy traceability.

[0022] 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 is backed up on multiple machines to ensure data security to the greatest extent possible.

[0023] In the 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.

[0024] 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.

[0025] In the process of filling containers and products, purchased or rented containers, including liquid tank trucks, tube bundle trucks, gas cylinders, dewar tanks, etc., are entered into the container entry and exit management module after verification by special equipment management personnel. The module generates a QR code based on the management number, and prints or laser engraves a label and sticks it to the outside of the container. On-site filling personnel use the container filling management module APP installed in the handheld scanning terminal to scan the QR code on the outside of the container after the product is filled. Select the filling area in the container filling management module APP, and the system automatically retrieves the current filling-related data such as temperature, pressure, gross weight, product quality analysis results, etc. and binds them to the container to avoid the problem of manually entered data being untraceable.

[0026] 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 the product quality analysis, filling time, filling personnel, filling volume, etc. The page can also display information such as the instructions for use and emergency measures of the filling medium.

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

[0028] The system also supports differentiated authority management. By logging into different role accounts, filling personnel, special equipment managers, metering equipment managers, sales personnel, company managers, customers, etc. can have different access rights. All relevant production data, inventory data, filling records, product quality information, sales records and other information will be stored in physical servers or cloud servers. Server data uses multi-machine hot backup to ensure data security to the greatest extent.

[0029] This system realizes the full process management of industrial gas production and sales. The production data can be collected by data acquisition equipment and bound to the product container and sales data after being processed by the server. The data will be retained in real time and the timestamp will be recorded, which is convenient for traceability and reduces the possibility of errors caused by manual data entry. The information system automatically calculates the number of products filled in the product container and forms a statistical report, which is convenient for the production and sales departments to grasp the product inventory information. If the customer raises an objection to the product quality, the production time, filling data and quality analysis data of the batch of products can be called up in time to facilitate traceability and find the cause, thereby improving the overall management and service level.

[0030] This system is applicable to all industrial gas production or filling units, which can greatly improve the traceability of production and filling data, making the production and filling process traceable and users can use it with confidence.

Claims

1. An industrial gas production and sales traceability management system, characterized by: It includes server side, data collection equipment, sales information system, container filling management module, container in and out 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 the 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 the data in the database server and processes it, and then connects with the container filling management module, the container warehousing and outbound management module, the product quality management module, the product inventory management module and the data traceability module respectively.

2. The industrial gas production and sales traceability management system according to claim 1 is characterized by: 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 is characterized by: 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.

4. The industrial gas production and sales traceability management system according to claim 3 is characterized by: The data acquisition device collects and binds the data to the product container and sales data after being processed by the server, and the data is retained in real time and a timestamp is recorded.

5. The industrial gas production and sales traceability management system according to claim 4 is characterized by: 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.

6. The industrial gas production and sales traceability management system according to claim 5 is characterized by: 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.

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

8. The industrial gas production and sales traceability management system according to claim 7 is characterized by: 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 a customer raises an objection to product quality, the production time, filling data and quality analysis data of the batch of products are retrieved for easy traceability.

9. The industrial gas production and sales traceability management system according to claim 8, 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 stored in the form of multi-machine hot backup.

Images