CN117151624A - A comprehensive workshop digital management platform based on SCADA system - Google Patents

Abstract

The invention discloses a workshop digital comprehensive management platform based on a SCADA system, which includes an information system and a visual management platform. The information system is provided with multiple subsystems, and the types of subsystems include a SCADA system, a production plan execution system, and a production process management system. system, intelligent warehouse management system and product quality traceability system. The visual management platform is equipped with a display device and a database server. The database server is connected to the information system and has multiple information display modules; the database server is connected to the SQL Server database to obtain SCADA The data source of the system uses WebService interface technology to obtain the data source of the intelligent warehouse management system, and accesses the Oracle intermediate table database to obtain the data source of the production plan execution system, production process management system, and product quality traceability system. The management platform provided by the invention breaks the information islands between workshop information systems and realizes fully automatic integrated management of workshop production data.

Description

A comprehensive workshop digital management platform based on SCADA system

Technical field

The present invention relates to the technical field of digital workshop comprehensive management, and in particular to a workshop digital comprehensive management platform based on a SCADA system.

Background technique

With the rapid development of intelligent manufacturing technology, the traditional Chinese medicine pharmaceutical industry has increasingly higher requirements for digital management of all aspects of drug production (production planning, material management, personnel management, production process management, quality management, etc.). Those who are committed to production management Various information systems have also emerged. However, for the entire capsule workshop, various systems are related but still relatively independent, and the information parameters related to production cannot match the actual production. In the past, workshop managers who wanted to know production-related information parameters such as personnel status, on-site production status, order completion status, energy consumption usage, etc. needed to open various information systems for screening and querying, which not only wasted login and system The switching time causes a waste of resources and is inconvenient for system management. Moreover, the management systems are mostly at the factory level. The advantages of production management of a single workshop cannot be reflected, and the data sources cannot be fully utilized, intuitively displayed, and analyzed for all information in each link of production.

At present, SCADA system functions are mostly based on data collection, alarms, and historical data storage and monitoring at the equipment production parameter level, which are separated from the production planning level, input-output and other information levels, and it is also difficult to implement batch management and data analysis functions; more It is impossible to intuitively see the staff hours and output value, output value and energy consumption, input and output, production plan and production actual situation, OEE situation of each production line and production quality situation between each batch and each variety.

The disclosure of the above background technology content is only used to assist in understanding the inventive concepts and technical solutions of the present invention. It does not necessarily belong to the prior art of this patent application, nor does it necessarily provide technical guidance; in the absence of clear evidence that the above content In the case where the disclosure has been made before the filing date of this patent application, the above background technology should not be used to evaluate the novelty and inventive step of this application.

Contents of the invention

In order to overcome the shortcomings of the existing technology, the present invention provides a workshop digital comprehensive management platform based on the SCADA system. The specific technical solution is as follows:

A comprehensive workshop digital management platform based on the SCADA system is provided, including an information system and a visual management platform. The information system is provided with multiple subsystems, and the types of the subsystems include a SCADA system, a production plan execution system, a production plan execution system, and a production plan execution system. Process management system, intelligent warehouse management system and product quality traceability system, the visual management platform is provided with a display device and a database server, the database server is connected to the information system and is provided with multiple information display modules; the information The display module calls and integrates the data information of different subsystems, and then displays it in real time through the display device; the SCADA system has a SQL Server database, and the production plan execution system, production process management system and product quality traceability system have Oracle Database, the intelligent warehousing management system database supports WebService interface technology;

The database server obtains the data source of the SCADA system by accessing the SQL Server database, obtains the data source of the intelligent warehousing management system through WebService interface technology, and obtains the production plan execution system by accessing the Oracle intermediate table database. Data source for production process management system and product quality traceability system.

Further, the steps for the visual management platform to obtain the SCADA system data source include:

Pre-establish a device relationship table in the SQL Server database. Each device corresponds to a relationship table. Each relationship table contains all points that the corresponding device can collect;

The collection server collects the PLC points of the equipment, establishes a data connection with the SQL Server database by configuring the system DNS, and matches the relationship table and point parameter values;

The timestamp is connected to the relationship table and the point, and the SQL Server database reads and stores the device data according to the set time interval; the visual management platform obtains relevant data set information by establishing a data connection with the SQL Server database.

Further, the steps for the visual management platform to obtain the data source of the intelligent warehouse management system include:

The intelligent warehousing management system publishes WebService application services as a Web server, creates a server, reserves a program for the client to call, and returns results by passing in parameters;

After the relevant server is successfully released, the visual management platform acts as a client and accesses the server through the service address published on the Web. By calling the server's program, it accesses the server and passes in parameters;

When the WebService server publishes the incoming parameters, it publishes them in the form of array data. The return data obtained by the client will be presented in the form of an array. The array data is converted into a data set, and then the data source is finally presented in the form of a table.

Further, data interaction between the intelligent warehouse management system and the production plan execution system is implemented through WebService.

Further, by configuring the connection between the Oracle intermediate table database and the SQL Server database, the interaction between the production plan execution system, the production process management system and the product quality traceability system and the SCADA system are realized respectively.

Further, the SCADA system collects and monitors workshop equipment status and usage information, production equipment parameters and alarm information, energy consumption information and production environment information through the industrial Ethernet network; the SCADA system includes a data collection and monitoring module, an energy Energy consumption management module, environment monitoring module, report management module and equipment gateway module; among them,

The device gateway module is used for network protocol conversion and IP mapping of different PLC controllers on site, and uniformly accesses the collection signals to the collection server;

The data collection and monitoring module obtains on-site equipment data through collection server software, and designs display screens through configuration software to match equipment and parameter information;

The energy consumption management module is connected to the signals of the workshop water meter, electricity meter and steam meter, records the current energy consumption in order to view the historical consumption, and provides a data source for production capacity and energy consumption analysis;

The environmental monitoring module is configured to monitor the temperature, humidity and pressure difference of each production workshop, and trigger an alarm when any of the temperature, humidity and pressure difference exceeds the process requirements;

The report management module supports online query of real-time trends, numerical values and historical report parameters of workshop equipment, and supports filtering, exporting and printing functions.

Further, the information system also includes a workshop access control system and a monitoring system. The access control system and monitoring system are connected to the data server through dedicated interface controls. The information display module includes a workshop access control and monitoring system access display module. , the workshop access control and monitoring system access display module uses the access control system and the monitoring system to obtain the status of on- and off-duty personnel in the workshop, as well as obtain information on the actual personnel on duty and the personnel on and off duty in the current work order process, and can pass Monitor and view real-time production conditions in the workshop.

Further, the information display module includes a batch production completion progress display module and an OEE analysis display module;

The batch production completion progress display module obtains the planned production quantity of the current order batch through the production plan execution system, obtains the warehousing quantity of the current batch of finished products through the intelligent warehousing management system, and then displays the progress of the current batch order completion;

The OEE analysis and display module collects the production speed of the production line equipment and the total output value and qualified output value of the products produced in a single shift through the SCADA system, obtains the load time of the current shift planned production through the production plan execution system, and obtains a single OEE of a shift, and form a trend management report to display the historical curve of a certain variety. The historical curve includes the historical curve of different production lines in the same shift, different production lines in different shifts, and the same production line in different shifts;

If the progress of the current batch of order completion is lower than the expected progress, the OEE analysis display module will be displayed in association. Managers can analyze the OEE historical trend curve to find out the key factors that affect equipment efficiency and order progress.

Further, the information display module includes a display module for personnel hours and output value, a display module for products and equipment information produced by the current work order process;

The staff time and output value display module obtains the order production batch and the staff time of the corresponding batch of orders through the production plan execution system, checks the staff's on-duty and off-duty time through the access control system and the monitoring system to verify the staff's time, and combines the SCADA system collection to obtain The total output value of the current batch to form a chart of the relationship between personnel hours and actual output value;

The current work order process production product and equipment information display module obtains the work order process information of the current production batch of products through the production plan execution system, as well as the current process production equipment information, product specifications and planned completion amount, and issues it to In the workshop, on-site production personnel check the production tasks of the day through the display device, and monitor the overall production progress through the actual production quantity fed back by the SCADA system.

Further, the information display module includes an energy consumption analysis display module, and the energy consumption analysis display includes trend charts and statistical charts of water, electricity, and steam consumption, as well as trends in the relationship between energy consumption and output; the energy consumption analysis The display module collects signals from workshop water meters, electricity meters, and steam meters through the SCADA system to obtain workshop energy usage trend reports, obtains order quantities through the production execution system, and obtains the quantity of finished products in storage through the warehouse management system, and then analyzes the relationship between energy consumption and output. And display the corresponding trend combination chart.

Compared with the existing technology, the present invention has the following advantages: it breaks the information islands between workshop information systems, strengthens the deep integration of information system data in multi-disciplinary fields, and realizes fully automatic integrated management of workshop production data.

Description of the drawings

Figure 1 is a schematic diagram of data interaction of a workshop digital comprehensive management platform provided by an embodiment of the present invention;

Figure 2 is a schematic framework diagram of a workshop digital comprehensive management platform provided by an embodiment of the present invention;

Figure 3 is a schematic diagram of the internal relationships of the workshop digital comprehensive management platform provided by the embodiment of the present invention.

Detailed ways

In order to enable those skilled in the art to better understand the solutions of the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only These are some embodiments of the present invention, rather than all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts should fall within the scope of protection of the present invention.

It should be noted that the terms "first", "second", etc. in the description and claims of the present invention and the above-mentioned drawings are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It is to be understood that the data so used are interchangeable under appropriate circumstances so that the embodiments of the invention described herein are capable of being practiced in sequences other than those illustrated or described herein. Furthermore, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusion.

In one embodiment of the present invention, a workshop digital comprehensive management platform based on a SCADA system is provided. See Figure 1, which includes an information system and a visual management platform. The information system is provided with multiple subsystems. The subsystems are The types of systems include SCADA systems, production plan execution systems, production process management systems, intelligent warehousing management systems, product quality traceability systems, workshop access control systems and monitoring systems. The visual management platform is equipped with a display device and a database server. The database server is connected to the information system and is provided with multiple information display modules; the information display module calls and integrates the data information of different subsystems, and then displays it in real time through the display device; the SCADA system has SQLServer Database, the production plan execution system, production process management system and product quality traceability system have Oracle database; wherein, the display device is preferably a large-screen signage with touch function, which can be set up in each workshop, production line or office, and Have certain computing power.

The database server obtains the data source of the SCADA system by accessing the SQL Server database, obtains the data source of the intelligent warehousing management system through WebService interface technology, and obtains the production plan execution system by accessing the Oracle intermediate table database. The data sources of the production process management system and product quality traceability system are obtained through dedicated interface controls to obtain the data sources of the access control system and monitoring system, so that the visual management platform can extract key production factors of each subsystem and conduct correlation data analysis and display. . The workshop in this embodiment is preferably a capsule workshop,

Among them, the SCADA system collects and monitors workshop equipment status and usage information, production equipment parameters and alarm information, energy consumption information and production environment information through the industrial Ethernet network; see Figure 2 and Figure 3, the SCADA system includes data Collection and monitoring module, energy consumption management module, environmental monitoring module, report management module and equipment gateway module; specifically, the equipment gateway module is used for network protocol conversion and IP mapping of different brands and models of PLC controllers on site, and will collect signals Unified access to the collection server. The data acquisition and monitoring module obtains field device data through the acquisition server software, and designs display screens through the configuration software to match the device and parameter information. The energy consumption management module is mainly connected to the water, electricity, and gas meter signals in the capsule workshop. It can record the current energy consumption, view the historical consumption, and provide a data source for production capacity and energy consumption analysis. The environmental monitoring module is mainly connected to the temperature, humidity and pressure difference monitoring systems of each production workshop in the capsule workshop. When the process requirements are exceeded, an alarm can be implemented. The report management module can support online query of real-time trends, numerical values and historical report parameters of capsule workshop equipment, and supports filtering, exporting and printing functions.

The intelligent warehousing management system includes an inbound management module, an outbound management module, and an inventory management module. Among them, the warehousing management module can realize the entry of warehousing orders for materials and finished products, and transmit the information back to the production plan management system; the outbound management module obtains order information from the production planning management system, enters outbound orders, and manually allocates orders. , issues warehouse tasks and is delivered by AGV. The inventory management module can inventory and count the quantity of materials and finished products on cargo locations and corresponding pallets, monitor the distribution status of items in real time, and track the inventory and storage location of items.

The production plan execution system is used to provide feedback on order scheduling, material procurement, sampling and warehousing, production process formula management, production material input and reporting, production execution feedback, material cost accounting, personnel time accounting and equipment information. The production plan execution system includes an order batch management module, a material management module, a process recipe management module, a feeding management module, a quality management module, an equipment management module A, an execution feedback module, a production progress management module, and a cost accounting module. Specifically, the order batch management module obtains order information through the business request plan, plans the order start, completion time, order quantity and allocates batch numbers based on inventory and current workshop production tasks, and distributes the order production plan to production workshop. The material management module accepts the purchase and receipt, incoming and outgoing information, and inventory information of the intelligent warehouse management system, and issues material work orders to the production workshop. The workshop issues picking orders to the warehouse, and then the warehouse management personnel organize and distribute the goods. Finally, the AGV trolley is delivered to the workshop line side warehouse for the workshop to pick materials. The process recipe management module performs material input and reporting based on the order product production process and integrates work orders and process information and sends them to the production workshop. Workshop production personnel go to the lineside warehouse to pick materials according to relevant processes for input production. The material feeding management module issues materials feeding and reporting tasks to the production workshop site according to the production formula. The operator obtains the material feeding and reporting information through the electronic billboard, and feeds the actual feeding information back to the production plan execution system. The material feeding management module includes the current feeding process and equipment name. , equipment ID, material name, material number, specification model, material batch number, quantity or weight of materials to be fed, quantity or weight of materials that have been fed, quantity or weight that can be fed, feeding time, feeding recorder. The quality management module mainly feeds back material procurement quality inspection information to ensure that the quality of production materials is qualified, and registers the inspection status and material-related information for quality verification; the procurement quality inspection includes report number, material category, material number, material name, specification model , material batch number, inspection quantity, supplier, inspection status. Equipment management module A mainly manages workshop equipment ledger information, including equipment name, equipment status, equipment number, equipment model, installation location and basic description of the equipment; the equipment status information can be obtained from the SCADA system. The execution feedback module includes actual production equipment, actual material input, actual start date, actual completion date, actual completion quantity, and actual staff hours; the production staff fills in the feedback to the system based on the actual production through the electronic Kanban. The production progress management module is used to display the completion rate of batch order production plans, including actual completed batches, planned completed batches and planned completion rate. The cost accounting module includes energy consumption accounting, material cost accounting and personnel time accounting; energy consumption accounting mainly includes water, electricity, and steam consumption accounting, and cost accounting includes medicinal materials, auxiliary materials, and packaging material consumption accounting. Production costs are generated online through accounting.

The production process management system includes a personnel management module, equipment management module B, material management module, process quality management module, and environmental management module. Specifically, the personnel management module mainly feedbacks whether the operator's operations are standardized. Relevant equipment operation data can be viewed from the SCADA system, combined with the operation records, to determine whether the process operations are in compliance and whether the operation records are filled in in a standardized manner. Equipment management module B is used to feed back equipment inspection and maintenance records and equipment operating procedures. The material management module mainly provides feedback on the usage of materials in the workshop's line side warehouse and whether the materials are cut accurately. The process quality management module mainly includes process compliance management and production record management. Feedback on the operation site compliance inspection record information includes whether the operation is carried out in accordance with the process regulations; whether the process parameters are consistent with the documents; whether the operation records, material transfer station records, and all entry and exit records are standardized; records, transfer station cargo location cards, and material labels Whether the number of accounts, cards, and objects is consistent; whether the fixed lines, equipment, tools, appliances, etc. are placed within the fixed lines; whether the clearance inspection is qualified. The environmental management module mainly feeds back the environmental testing information of the production site, including dust particles, sedimentation bacteria, pressure difference, temperature and humidity, which must be within the range of process requirements.

The product quality traceability system includes a work order management module, a process management module, a material input management module, a procurement quality inspection module, a receipt and delivery management module, and a material sharing module. Specifically, the work order management module includes product name, batch number, process, specification, unit, planned start time, planned completion time, order planned quantity, completed qualified number, work order creator, and work order executor. The process module includes process name, equipment name, equipment ID, start time, completion time, reported work quantity, process recorder, and worker working hours details. The material feeding management module includes the feeding process, equipment ID, material name, material number, specification model, material batch number, feeding quantity, feeding time, and feeding recorder. The procurement quality inspection module includes procurement warehousing information and quality inspection information. The procurement warehousing information includes suppliers, buyers, purchase dates, materials, specifications, units, quantities, and batch numbers. Quality inspection information includes report number, releaser, release time, and whether it was released. The receipt and delivery management module includes sales and delivery information and receipt information. Sales and delivery information includes sales date, customer, salesperson, product, specification, unit, and quantity. Receipt information includes date, receipt recorder, material name, material number, material ID, specification, batch number, unit, quantity, and number of pieces. , supplier unit, validity period, inspection results, report number, receipt details ID. The material sharing module includes purchasing quality inspection information, work order details, finished product information, and finished product sales and delivery. Used for material usage details inquiry and tracing.

The visual management platform covers SCADA system, production plan execution system, production process management system, intelligent warehouse management system and product quality traceability system, which is used to display, statistical analysis and management of relevant data information. Between systems and between platforms and systems, system data sources are obtained through the access methods of SQL Server, Oracle intermediate table database and WebService interface to achieve the purpose of deep integration of multiple data sources and correlation analysis and management.

The visual management platform obtains the SCADA system data source by connecting to the SQL Server database. Since the workshop SCADA system is designed using Siemens WINCC 7.4SP1, the collected data is stored in the SQL Server database in compressed form and requires the OLE-provided by the WINCC connectivity software package. Only the DB interface can be used to decompress and read data. External systems cannot access database parameters, and the decompressed data is in a point table format sorted by time, covering all points in the workshop at all current times. The amount of data is large and filtering is difficult. , which brings great obstacles to the visual management platform’s access to SCADA data sources and data analysis. In addition, because there are a large number of archiving points in the workshop, often more than 3,000, writing a large number of VB decompression scripts will cause the system to run lag. As a result, it not only generates software licensing costs and labor costs, but also affects the smoothness and stability of the SCADA system. .

Based on the above factors, the visual management platform plans to access the SCADA system data by establishing a point mapping relationship between the SQL Server database device point table and the collection server to obtain the current point position of the collection server and update the values synchronously. The collection server can also set the data storage period by modifying the Triggers time interval according to the importance of the data and storage requirements, which saves database storage space to a certain extent.

The specific method for the visual management platform to obtain SCADA system data sources is as follows: First, pre-establish a device relationship table in the SQL Server database. Each device corresponds to a relationship table and contains all points that this device can collect. The collection server collects equipment PLC points through Modbus TCP, HostLink, TCP/IP, Profibus, OPC UA and other protocols, and establishes a data connection with the SQLServer database by configuring the system DNS, and matches the relationship table and point parameter values; the timestamp Establish a connection with the relationship table point, run this service, and the relationship report can read and store data according to the set time interval. The platform obtains data set information for data association analysis and display by establishing a data connection with SQL Server.

The visual management platform obtains the data source of the intelligent warehousing management system through WebService interface technology. The SQL Server database of the intelligent warehousing management system itself is not open. If data is obtained by accessing the intermediate table database, the obtained data will need to be processed twice, and additional costs will be incurred. Because the system itself deploys a WebService interface for external systems to access data, and the visual management platform also has the function of calling data sources through the WebService interface, WebService interface technology is used to remotely call the data sources of the intelligent warehousing management system.

The specific method for the visual management platform to obtain the data source of the intelligent warehousing management system is as follows: the intelligent warehousing management system publishes the WebService application service as a Web server, creates the server in the java engineering environment, and writes the method code for the client to call in the java class , pass in the parameters and return the results; after the publication is successful, the client accesses the server through the Web publishing service address, and accesses the server to pass in the parameters by calling the server method; because the data source in the form of a data table is more convenient for analyzing the correlation of the data, WebService When the server publishes the incoming parameters, it publishes them in the form of array data. The return data obtained by the client will be presented in the form of an array. At the same time, it is convenient to convert the array data into a data set, and finally the data source is presented in tabular form.

The visual management platform obtains the data source of the production plan execution system by connecting to the Oracle intermediate table database. The production plan execution system has an independent Oracle database, and the visual management platform can directly connect to the Oracle intermediate table database to obtain system data sources. The production plan execution system itself opens the WebService interface service. Because it needs to issue orders to the intelligent warehousing management system, the intelligent warehousing management system needs to return information to the production plan execution system. The data interaction between the two systems is realized through WebService and is not directly Read the system databases of both parties; the systems of both parties realize the interaction of system data of both parties through the Soap protocol, and serve as servers and clients for each other. All service calls adopt the synchronous calling mode, exchanging data through json format objects, and storing the obtained information in the Oracle database.

If the WebService interface is used to implement data interaction between systems, high interface maintenance costs will be incurred, and there is a risk that system data will be processed repeatedly. The production process management system and product quality traceability system do not use the WebService interface to obtain data. Because the system has an independent Oracle database, if you want to obtain other system data, you only need to establish an Oracle intermediate table database. The platform and system obtain each other's data sources by accessing the Oracle intermediate table database. If you want to obtain SCADA data, you can obtain intermediate table information by configuring the connection between the Oracle database and the SQL Server database.

The visual management platform obtains relevant data sources from each system based on the needs of workshop production management elements, and designs display content for production management. The information display module of the visual management platform includes the workshop access control and monitoring system access display module, the staff time and output value display module, the current work order process production product and equipment information display module, the OEE display module, and the batch production completion progress display module. Energy consumption statistical analysis display module, product quality information display module, and product data traceability information display module.

Among them, the workshop access control and monitoring system access display module uses the access control system and the monitoring system to obtain the status of on- and off-duty personnel in the workshop, as well as obtain information on the actual personnel on duty and the personnel on and off duty in the current work order process, and can Check the real-time production status of the workshop through monitoring.

The staff time and output value display module can display the staff time and output value of personnel on duty, off duty, and batch orders. The staff time and output value display module obtains the order production batch and the corresponding batch order staff time through the production plan execution system. According to the situation, the access control system and monitoring system check the time of personnel on and off duty to verify the personnel hours, and combine the SCADA system to collect the total output value of the current batch to form a chart of the relationship between personnel hours and actual output value;

The current work order process production product and equipment information display module obtains the work order process information of the current production batch of products through the production plan execution system, as well as the current process production equipment information, product specifications and planned completion amount, and issues it to In the workshop, on-site production personnel check the production tasks of the day through the display device, and monitor the overall production progress through the actual production quantity fed back by the SCADA system.

The OEE analysis and display module can collect the production speed of the production line equipment and the total output value and qualified output value of the products produced in a single shift through SCADA, and obtain the load time of the current shift planned production according to the production plan execution system. Calculate the OEE of a single shift through a formula, and form a trend management report to visually display the historical curves of a certain variety in different production lines in the same shift, different production lines in different shifts, and the same production line in different shifts. By analyzing the OEE historical trend curve, managers can find out the key factors affecting OEE, thereby improving the overall equipment utilization. Among them, OEE involves parameters such as planned completion time, actual completion time, equipment startup time, equipment failure time, equipment production time, production output, qualified quantity, yield rate, etc. Through simplified calculations, the following OEE calculation formula is obtained:

The number of qualified products is the total number of qualified products produced within a single shift production time. The production speed of a single product is the speed at which the production equipment is set to produce one product. The load time is the time left after the total production time of the shift minus the planned downtime. .

The batch production completion progress display module can display the planned output, completed quantity, progress amount and batch production completion progress, obtain the planned production quantity of the current order batch through the production plan execution system, and obtain the current batch through the intelligent warehousing management system. The warehousing quantity of finished products of the current production is displayed, and then the progress of the current batch of order completion is displayed; if the progress of the current batch of order completion is lower than the expected progress, the OEE analysis display module is displayed in association, and the manager analyzes the OEE historical trend curve to find out Identify the key factors affecting equipment efficiency and order progress.

The energy consumption analysis and display module displays water, electricity, and steam consumption trend charts and statistical charts within the day/month/year, as well as the relationship between monthly energy consumption and monthly output. The water, electricity, and steam meter signals of the capsule workshop are collected through the SCADA system. Obtain monthly and annual usage trend reports for the workshop, obtain monthly and annual order quantities through the production execution system, obtain monthly and annual finished product warehousing quantities through the intelligent warehousing management system, analyze the relationship between monthly and annual energy consumption and output, and display column-trend combinations picture. Among them, energy consumption analysis includes daily/monthly/year consumption trend charts and statistical charts of water, electricity, and steam, as well as charts of the relationship between monthly energy consumption and monthly output.

The display content of the product quality information display module mainly comes from the production plan execution system. It mainly displays the monitoring results of each step involved in quality inspection in pharmaceutical production and the feedback information of the operation site compliance inspection records, including work order process information, material quality inspection information, Production site environmental testing feedback information, operation site compliance inspection record feedback information. The feedback information from environmental testing at the production site includes dust particles, sedimentation bacteria, pressure difference, temperature and humidity, which must be within the range of process requirements. The feedback information from the operation site compliance inspection record includes whether the operation is carried out in accordance with the process procedures, whether the process parameters are consistent with the documents, operation record records, material transfer station records, whether all entry and exit records are recorded in a standardized manner, records, transfer station cargo location cards, materials Check whether the number of accounts, cards, and objects among the three labels are consistent, whether the fixed lines, equipment, tools, appliances, etc. are placed within the fixed lines, and whether the clearance inspection is qualified.

The product data traceability information display module mainly displays product production life cycle information. The data mainly comes from the production plan execution system, including work order information, finished product information, procurement quality inspection information, material input information, sales and delivery information, and receipt record query information. . When it is discovered that there may be abnormalities in the materials and auxiliary materials used in medicines, all work order information, quality inspection information, material input and reporting information, supplier information, receipt and delivery status information, and timely recall of the material production can be queried in a timely manner. Stop losses promptly.

This embodiment introduces in detail the production and quality aspects involved from order placement to finished product warehousing, sales and delivery, the role of each system functional module and the business flow process. Based on the system data interaction diagram, the system data source acquisition method is introduced in detail. Based on the platform display module system relationship diagram and the information system itself, the display content is designed to meet the needs of production management. Extract key information of each system through the platform, compare and analyze personnel hours and output value, output value and energy consumption, input and output, production plan and actual production, and OEE of each production line, and graphically display the analysis process and results to achieve Overall control and monitoring of the production process. Realize the visual display of important data and correlation analysis display to achieve the purpose of comprehensive management of the capsule workshop.

The workshop digital comprehensive management platform provided by the present invention has the following advantages:

1) Break the information islands between capsule workshop information systems, strengthen the in-depth integration of information system data in multi-disciplinary fields, and achieve fully automatic and integrated management of workshop production data.

2) Real-time monitoring of the status of production equipment is achieved through SCADA acquisition technology, and real-time historical production data of the equipment is obtained. Combined with the batch management function of the production plan execution system, batch data is generated to realize analysis and display of batch data. And by checking historical data and production operation records, we can understand the deviation between the actual operating parameters of equipment production and operation records, and judge the compliance of the production process.

3) Extract key information of each system through the platform, compare and analyze personnel hours and output value, output value and energy consumption, input and output, production plan and actual production, and OEE of each production line, and graphically display the analysis process and results , to achieve overall control and monitoring of the production process. Workshop managers can continuously compare and analyze production batch data to understand various factors affecting production and solve them, so as to optimize the production process, improve production efficiency, improve production quality, and reduce production costs.

The above are only preferred embodiments of the present invention, and do not limit the scope of the invention. Any equivalent structure or equivalent process transformation made by using the description and drawings of the present invention can be directly or indirectly used in other related technical fields. All are similarly included in the patent protection scope of the present invention.

Claims (10)

1. The workshop digital integrated management platform based on the SCADA system is characterized by comprising an informatization system and a visual management platform, wherein the informatization system is provided with a plurality of subsystems, the types of the subsystems comprise the SCADA system, a production plan execution system, a production process management system, an intelligent storage management system and a product quality traceability system, the visual management platform is provided with a display device and a database server, and the database server is connected with the informatization system and is provided with a plurality of information display modules; the information display module invokes data information of different subsystems and integrates the data information, and then displays the data information in real time through the display device; the SCADA system is provided with an SQL Server database, the production plan execution system, the production process management system and the product quality traceability system are provided with Oracle databases, and the intelligent warehouse management system databases support a WebService interface technology;

the database Server is accessed into an SQL Server database to acquire a data source of the SCADA system, a WebService interface technology is used for acquiring a data source of the intelligent warehouse management system, and an Oracle middle table database is accessed to acquire data sources of the production plan execution system, the production process management system and the product quality tracing system.

2. The plant digitized integrated management platform of claim 1, wherein the step of the visual management platform obtaining the SCADA system data source comprises:

an equipment relation table is pre-established in an SQLServer database, each equipment corresponds to one relation table, and each relation table contains all the points which can be acquired by the corresponding equipment;

the acquisition Server acquires the PLC point position of the equipment, establishes data connection with the SQL Server database through the configuration system DNS, and matches a relation table and point position parameter values;

establishing connection between the time stamp and the relation table and between the time stamp and the point location, and reading and storing the device data by the SQL Server database according to the set time interval; the visual management platform establishes data connection with the SQL Server database to further acquire relevant data set information.

3. The plant digitized integrated management platform of claim 1 wherein said step of said visual management platform obtaining an intelligent warehouse management system data source comprises:

the intelligent warehouse management system is used as a Web server to issue WebService application service, a server is created, a program for a client to call is reserved, and a result is returned through an incoming parameter;

after the related server is successfully released, the visual management platform is used as a client, accesses the server through a service address released by Web, accesses the server through calling a program of the server and transmits parameters;

when the WebService server publishes the input parameters, the WebService server publishes the parameters in the form of array data, the returned data obtained by the client is presented in the form of array, the array data is converted into a data set, and then the data source is presented in the form of a table finally.

4. The plant digitized integrated management platform of claim 1 wherein the data interaction between the intelligent warehouse management system and the production plan execution system is implemented by WebService.

5. The workshop digitized integrated management platform of claim 1, wherein interactions between a production plan execution system, a production process management system, and a product quality traceability system, respectively, and the SCADA system are achieved by configuring a connection between an Oracle intermediate table database and an SQL Server database.

6. The workshop digital integrated management platform according to claim 1, wherein the SCADA system collects and monitors workshop equipment status and usage information, production equipment parameters and alarm information, energy consumption information and production environment information through an industrial ethernet network; the SCADA system comprises a data acquisition and monitoring module, an energy consumption management module, an environment monitoring module, a report management module and an equipment gateway module; wherein,

the equipment gateway module is used for network protocol conversion and IP mapping of different PLC controllers on site and uniformly accessing the acquisition signals to the acquisition server;

the data acquisition and monitoring module acquires field device data through acquisition server software, and designs a display picture through configuration software to match equipment and parameter information;

the energy consumption management module is connected with signals of a workshop water meter, an ammeter and a steam meter, records the current energy consumption so as to check the historical consumption, and provides a data source for energy consumption analysis of the productivity;

the environment monitoring module is configured to monitor the temperature, humidity and pressure difference of each production workshop, and trigger an alarm when any one of the temperature, humidity and pressure difference exceeds the process requirement;

the report management module supports real-time trend, numerical value and historical report parameters of the on-line query workshop equipment and supports screening, exporting and printing functions.

7. The workshop digital integrated management platform according to claim 1, wherein the informatization system further comprises an access control system and a monitoring system of a workshop, the access control system and the monitoring system access a data server through special interface controls, the information display module comprises a workshop access control and monitoring system access display module, and the workshop access control and monitoring system access display module is used for acquiring on-duty and off-duty conditions of workshop personnel, acquiring information of actual on-duty personnel and off-duty personnel of a current work order procedure and checking on-site real-time production conditions of the workshop through monitoring.

8. The workshop digital integrated management platform according to claim 1, wherein the information display module comprises a batch production completion progress display module and an OEE analysis display module;

the batch production completion progress display module obtains the planned production quantity of the batch of the current order through the production plan execution system, obtains the warehousing quantity of the finished product of the current batch production through the intelligent warehouse management system, and displays the progress of completion of the current batch order;

the OEE analysis display module acquires the production speed of production line equipment and the total and qualified production values of products produced in a single shift through the SCADA system, acquires the load time of current shift plan production through the production plan execution system, acquires the OEE of the single shift according to a preset calculation formula, and forms a trend management report to display a history curve of a certain variety, wherein the history curve comprises history curves of different production lines of the same shift, different production lines of different shifts and the same production line of different shifts;

if the completion progress of the current batch of orders is lower than the expected progress, the OEE analysis and display module is displayed in a correlated mode, and a manager finds out key factors influencing the equipment efficiency and the order progress by analyzing the OEE historical trend curve.

9. The workshop digital integrated management platform according to claim 7, wherein the information display module comprises a personnel working hour and production value situation display module and a current work order process production product and equipment information display module;

the personnel working hour and production value condition display module acquires the order production batch and the personnel working hour conditions of corresponding batch orders through the production plan execution system, checks the personnel working hour of the personnel on duty and off duty through the access control system and the monitoring system, and acquires the total production value of the current batch by combining with the SCADA system so as to form a relation chart of the personnel working hour and the actual production value;

the current work order process production product and equipment information display module obtains work order process information of the current production batch product, current process production equipment information, product specification and planned completion amount through a production plan execution system, and the current process production equipment information, the product specification and the planned completion amount are issued to a workshop through a system, on-site production staff check the production task on the same day through a display device, and the overall production progress is monitored through the actual production quantity fed back by the SCADA system.

10. The workshop digital integrated management platform according to claim 1, wherein the information display module comprises an energy consumption analysis display module, wherein the energy consumption analysis display module comprises a trend chart and a statistical chart of water, electricity and steam consumption and a trend of energy consumption and output relation; the energy consumption analysis display module acquires workshop water meter, ammeter and steam meter signals through the SCADA system to acquire workshop energy consumption trend reports, acquires order quantity through the production execution system, acquires finished product warehouse entry quantity through the warehouse management system, further analyzes the relation between energy consumption and output, and displays corresponding trend combination graphs.