CN108509598B - Auxiliary monitoring software system for water bath sterilization and monitoring method - Google Patents
Auxiliary monitoring software system for water bath sterilization and monitoring method Download PDFInfo
- Publication number
- CN108509598B CN108509598B CN201810283547.5A CN201810283547A CN108509598B CN 108509598 B CN108509598 B CN 108509598B CN 201810283547 A CN201810283547 A CN 201810283547A CN 108509598 B CN108509598 B CN 108509598B
- Authority
- CN
- China
- Prior art keywords
- data
- program module
- data table
- controller
- recorder
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G05—CONTROLLING; REGULATING
- G05B—CONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
- G05B19/00—Programme-control systems
- G05B19/02—Programme-control systems electric
- G05B19/04—Programme control other than numerical control, i.e. in sequence controllers or logic controllers
- G05B19/05—Programmable logic controllers, e.g. simulating logic interconnections of signals according to ladder diagrams or function charts
- G05B19/058—Safety, monitoring
-
- A—HUMAN NECESSITIES
- A61—MEDICAL OR VETERINARY SCIENCE; HYGIENE
- A61L—METHODS OR APPARATUS FOR STERILISING MATERIALS OR OBJECTS IN GENERAL; DISINFECTION, STERILISATION OR DEODORISATION OF AIR; CHEMICAL ASPECTS OF BANDAGES, DRESSINGS, ABSORBENT PADS OR SURGICAL ARTICLES; MATERIALS FOR BANDAGES, DRESSINGS, ABSORBENT PADS OR SURGICAL ARTICLES
- A61L2/00—Methods or apparatus for disinfecting or sterilising materials or objects other than foodstuffs or contact lenses; Accessories therefor
- A61L2/02—Methods or apparatus for disinfecting or sterilising materials or objects other than foodstuffs or contact lenses; Accessories therefor using physical phenomena
- A61L2/04—Heat
-
- A—HUMAN NECESSITIES
- A61—MEDICAL OR VETERINARY SCIENCE; HYGIENE
- A61L—METHODS OR APPARATUS FOR STERILISING MATERIALS OR OBJECTS IN GENERAL; DISINFECTION, STERILISATION OR DEODORISATION OF AIR; CHEMICAL ASPECTS OF BANDAGES, DRESSINGS, ABSORBENT PADS OR SURGICAL ARTICLES; MATERIALS FOR BANDAGES, DRESSINGS, ABSORBENT PADS OR SURGICAL ARTICLES
- A61L2/00—Methods or apparatus for disinfecting or sterilising materials or objects other than foodstuffs or contact lenses; Accessories therefor
- A61L2/24—Apparatus using programmed or automatic operation
-
- G—PHYSICS
- G05—CONTROLLING; REGULATING
- G05B—CONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
- G05B19/00—Programme-control systems
- G05B19/02—Programme-control systems electric
- G05B19/04—Programme control other than numerical control, i.e. in sequence controllers or logic controllers
- G05B19/042—Programme control other than numerical control, i.e. in sequence controllers or logic controllers using digital processors
- G05B19/0428—Safety, monitoring
-
- A—HUMAN NECESSITIES
- A61—MEDICAL OR VETERINARY SCIENCE; HYGIENE
- A61L—METHODS OR APPARATUS FOR STERILISING MATERIALS OR OBJECTS IN GENERAL; DISINFECTION, STERILISATION OR DEODORISATION OF AIR; CHEMICAL ASPECTS OF BANDAGES, DRESSINGS, ABSORBENT PADS OR SURGICAL ARTICLES; MATERIALS FOR BANDAGES, DRESSINGS, ABSORBENT PADS OR SURGICAL ARTICLES
- A61L2202/00—Aspects relating to methods or apparatus for disinfecting or sterilising materials or objects
- A61L2202/10—Apparatus features
- A61L2202/14—Means for controlling sterilisation processes, data processing, presentation and storage means, e.g. sensors, controllers, programs
-
- A—HUMAN NECESSITIES
- A61—MEDICAL OR VETERINARY SCIENCE; HYGIENE
- A61L—METHODS OR APPARATUS FOR STERILISING MATERIALS OR OBJECTS IN GENERAL; DISINFECTION, STERILISATION OR DEODORISATION OF AIR; CHEMICAL ASPECTS OF BANDAGES, DRESSINGS, ABSORBENT PADS OR SURGICAL ARTICLES; MATERIALS FOR BANDAGES, DRESSINGS, ABSORBENT PADS OR SURGICAL ARTICLES
- A61L2202/00—Aspects relating to methods or apparatus for disinfecting or sterilising materials or objects
- A61L2202/20—Targets to be treated
- A61L2202/24—Medical instruments, e.g. endoscopes, catheters, sharps
Abstract
The invention discloses an auxiliary monitoring software system and a monitoring method for water bath sterilization, and relates to the field of sterilization data acquisition and auxiliary control in the large infusion industry. The system comprises a controller communication module, a recorder communication card, a C # program module, a MYSQL database and an OPC communication server; the C # program module establishes communication connection with the controller and the recorder through the OPC server respectively; the C # program module is connected with the MYSQL database through codes, and a data table 1 and a data table 2 are established in the MYSQL database; the C # program module reads controller data and recorder data, inserts two groups of data into the data table 1 and the data table 2 respectively, and stores the data; and (3) performing difference on two groups of data corresponding to the same variable in the two groups of data, judging whether the absolute value of the difference is larger than a set range, writing an instruction alarm output when the absolute value is larger than the set range, and performing color marking in the data table 1 and the data table 2.
Description
Technical Field
The embodiment of the invention relates to the infusion industry, in particular to a sterilization data acquisition or auxiliary control function, and specifically relates to an auxiliary monitoring software system and a monitoring method for water bath sterilization.
Background
The general process of sterilizing large infusion products by using a water bath type sterilizer comprises the following steps: production operators input product information and process parameters such as specification, quantity, product name, sterilization temperature, sterilization time, F0 value, production batch number and the like through a PC and upper software, relevant information content is written into a database, and corresponding parameters are downloaded to a lower controller; an operator starts a program, and a lower controller performs analysis calculation and logic judgment by acquiring field digital quantity and analog quantity signals according to a preset program to realize corresponding point location output, control field equipment to act and realize a full-automatic sterilization process; in the whole sterilization program operation process, the upper software continuously collects process data, operation records, alarm records and other information, writes the information into a database and stores the information into a PC local hard disk, and a dotting recorder collects field temperature and pressure process data and performs dotting on a trend graph in real time; and data information such as process data, operation records, alarm records, dotting trends and the like generated in the program operation are used for reflecting the actual sterilization situation of the product and providing data support for the release of the product.
As shown in fig. 1, in the process of executing a sterilization procedure, if a communication interruption or a human-computer interaction interruption between the configured system and a lower control device occurs due to various upper system abnormalities, serious consequences may result: data acquisition is interrupted and lost, detailed report data which cannot be provided for product release is used as support, and the data form provided by the recorder is a paper dotting trend graph, so that deviation processing, evaluation work and product release risks are increased; if on-site execution device faults occur at the moment, emergency treatment cannot be rapidly realized through the upper system, and serious problems of product scrapping, equipment damage, personnel safety hazard and the like can be caused.
Disclosure of Invention
The invention aims to provide a software system for auxiliary control of water bath sterilization. The data acquisition system can acquire two paths of data of the recorder and the controller at the same time under normal conditions, and realize a real-time backup function; the system can provide the functions of auxiliary control and detailed product release data when the host upper system is abnormal.
In order to achieve the technical effects, the invention adopts the following technical scheme:
the auxiliary monitoring software system for water bath sterilization comprises a controller communication module, a recorder communication card, a C # program module, a MYSQL database and an OPC communication server; the C # program module establishes communication connection with the controller and the recorder through the OPC server respectively; the C # program module is connected with the MYSQL database through codes, and a data table 1 and a data table 2 are established in the MYSQL database; the C # program module reads controller data and recorder data, inserts two groups of data into the data table 1 and the data table 2 respectively, and stores the data; and (3) performing difference on two groups of data corresponding to the same variable in the two groups of data, judging whether the absolute value of the difference is larger than a set range, writing an instruction alarm output when the absolute value is larger than the set range, and performing color marking in the data table 1 and the data table 2.
The further technical scheme is as follows: the controller also comprises a C # program module which is used for outputting a command to the controller by a user with authority to realize the control of the field execution device.
Meanwhile, the invention also provides an auxiliary monitoring method for water bath sterilization, which comprises the following steps:
the C # program module establishes communication connection with the controller and the recorder through an OPC (OLE for process control) communication server respectively;
judging whether C # is started;
the C # program module is connected with the MYSQL database through codes, and a data table 1 and a data table 2 are established in the MYSQL database;
the C # program module reads the data of the controller and the data of the recorder, and the two groups of data are respectively inserted into the data table 1 and the data table 2 and stored in a disk;
two groups of variable data with the same data are subjected to difference;
judging whether the absolute value of the difference between the two groups of data with the same variable is larger than a set value or not;
and when the absolute value is larger than the set value, writing an instruction to control the PLC to alarm and output, and carrying out color marking in the data table 1 and the data table 2.
The further technical scheme is as follows: the auxiliary monitoring method for water bath sterilization further comprises the following steps: judging whether the communication between the host and the controller is abnormal or not, logging in the software system by the user, and judging whether the logged-in user has a control authority or not; and the user with the authority outputs a command to the controller through the C # program module to realize the control of the field execution device.
Compared with the prior art, the invention has the following beneficial effects: the invention provides an auxiliary monitoring software system and a monitoring method for water bath sterilization, which realize the following functions through the auxiliary software system: simultaneously, two paths of data of the controller and the recorder are collected to be respectively backed up and stored, and detailed release data are prepared; two paths of data are compared, analyzed and judged in real time to judge the actual operation condition of each sensor; when the host computer is abnormal, an auxiliary control function is provided.
Drawings
FIG. 1 is a flow chart of a prior art invention;
FIG. 2 is a schematic flow chart of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is further described in detail with reference to the following embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
Examples
As shown in FIG. 2, the auxiliary monitoring software system for water bath sterilization comprises a controller communication module, a recorder communication card, a C # program module, a MYSQL database and an OPC communication server. In steps S010 and S011, the C # program module establishes communication connections with the controller and the recorder through the OPC communication server, respectively.
In step S020, it is determined whether or not the program has been started.
In steps S030 and S031, the C # program module is connected to the MYSQL database through a code, and establishes data table 1 and data table 2 in the MYSQL database.
In steps S040, S041, the C # program module reads controller data and recorder data;
in step S050, two groups of variable data with the same data are subjected to difference;
in step S060, the two sets of data are inserted into the data table 1 and the data table 2, respectively, and stored;
in step S070, it is determined whether the absolute value of the difference between two sets of data of the same variable is greater than a set value;
in step S080, when the absolute value is greater than the set value: the write-in instruction controls the alarm output of the PLC; color labeling in data table 1 and data table 2;
in step S100, it is determined whether the communication between the host and the controller is abnormal;
in step S110, a user logs in the software system;
in step S120, it is determined whether the logged-in user has a control authority;
in step S130, the authorized user outputs a command to the controller through the C # program module, and finally controls the field execution device.
After the sterilization program is started, the C # program module obtains a program operation mark corresponding to the controller through an OPC communication server;
the C # program module collects data of the storage controller: the C # program module is automatically connected to a built MYSQL database; a data table 1 named by a 'timestamp' connection '1' character string is newly established in the MYSQL database; and the C # program module reads information such as the controller process data and the like through the OPC communication server and automatically inserts the process data, the date and the time collected through the OPC communication server into the established data table 1 according to the frequency of every 10S.
The C # program module acquires data of a recorder: the C # program module is used for establishing a data table 2 named by a 'timestamp' connection '2' character string in a connected MYSQL database; and the C # program module reads the process data collected by the recorder through the OPC communication server and automatically inserts the process data, the date and the time collected by the recorder read through the OPC communication server into the data table 2 according to the frequency of every 10S.
The data comparison analysis method comprises the following steps: the C # program module simultaneously reads two groups of data of the controller and the recorder, which are acquired by an OPC communication server; the same variable in the two groups of data is differenced with the two groups of numerical values; judging whether the absolute value of the difference is larger than a set range (generally 0.7 ℃); and when the difference value is larger than the set range, performing color distinguishing on the corresponding data in the two groups of data tables, and outputting an alarm.
Furthermore, the communication interruption between the host upper system and the lower controller is judged or the switching value is manually input to the controller, and the lower controller sets an abnormal mark; the C # program module reads the controller to send the abnormal mark; according to the requirement of the authority, a user logs in the software system; and an operator controls the lower controller through the C # program module to realize the control of the field execution device.
The invention relates to a sterilization data acquisition or auxiliary control function, in particular to a software system which realizes the complete data acquisition and provides an auxiliary control operation function and ensures the normal execution of a sterilization program when a host computer is in a dead halt, a blue screen, communication interruption with lower equipment and other abnormal reasons cause data loss and system runaway in the sterilization process of a water bath type sterilizer.
Although the invention has been described herein with reference to illustrative embodiments thereof, it should be understood that numerous other modifications and embodiments can be devised by those skilled in the art that will fall within the spirit and scope of the principles of this disclosure. More specifically, various variations and modifications may be made to the component parts and/or arrangements of the subject combination arrangement within the scope of the disclosure herein. In addition to variations and modifications in the component parts and/or arrangements, other uses will also be apparent to those skilled in the art.
Claims (4)
1. A supplementary monitoring software system for water bath sterilization which characterized in that: the system comprises a controller communication module, a recorder communication card, a C # program module, a MYSQL database and an OPC communication server; the C # program module establishes communication connection with the controller and the recorder through the OPC server respectively; the C # program module is connected with the MYSQL database through codes, and a data table 1 and a data table 2 are established in the MYSQL database; the C # program module reads controller data and recorder data, inserts two groups of data into the data table 1 and the data table 2 respectively, and stores the data; and (3) performing difference on two groups of data corresponding to the same variable in the two groups of data, judging whether the absolute value of the difference is larger than a set range, writing an instruction alarm output when the absolute value is larger than the set range, and performing color marking in the data table 1 and the data table 2.
2. The auxiliary monitoring software system for water bath sterilization according to claim 1, wherein: the controller also comprises a C # program module which is used for outputting a command to the controller by a user with authority to realize the control of the field execution device.
3. The auxiliary monitoring method for water bath sterilization is characterized by comprising the following steps:
the C # program module establishes communication connection with the controller and the recorder through an OPC (OLE for process control) communication server respectively;
judging whether C # is started;
the C # program module is connected with the MYSQL database through codes, and a data table 1 and a data table 2 are established in the MYSQL database;
the C # program module reads the data of the controller and the data of the recorder, and the two groups of data are respectively inserted into the data table 1 and the data table 2 and stored in a disk;
two groups of variable data with the same data are subjected to difference;
judging whether the absolute value of the difference between the two groups of data with the same variable is larger than a set value or not;
when the absolute value is larger than the set value, writing an instruction to control PLC alarm output, and carrying out color marking in the data table 1 and the data table 2;
the C # program module collects data of the storage controller: the C # program module is automatically connected to a built MYSQL database; a data table 1 named by a 'timestamp' connection '1' character string is newly established in the MYSQL database; the C # program module reads the process data information of the controller through the OPC communication server and automatically inserts the process data, the date and the time which are collected through the OPC communication server into the established data table 1 according to the frequency of every 10S;
the C # program module acquires data of a recorder: the C # program module is used for establishing a data table 2 named by a 'timestamp' connection '2' character string in a connected MYSQL database; the C # program module reads the process data collected by the recorder through the OPC communication server and automatically inserts the process data, the date and the time collected by the recorder read through the OPC communication server into the data table 2 according to the frequency of every 10S;
the data comparison analysis method comprises the following steps: the C # program module simultaneously reads two groups of data of the controller and the recorder, which are acquired by an OPC communication server; the same variable in the two groups of data is differenced with the two groups of numerical values; judging whether the absolute value of the difference is larger than a set range; and when the difference value is larger than the set range, performing color distinguishing on the corresponding data in the two groups of data tables, and outputting an alarm.
4. The auxiliary monitoring method for water bath sterilization according to claim 3, further comprising: judging whether the communication between the host and the controller is abnormal or not, and judging whether a logged user has a control authority or not by logging in the software system by the user; and the user with the authority outputs a command to the controller through the C # program module to realize the control of the field execution device.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810283547.5A CN108509598B (en) | 2018-04-02 | 2018-04-02 | Auxiliary monitoring software system for water bath sterilization and monitoring method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810283547.5A CN108509598B (en) | 2018-04-02 | 2018-04-02 | Auxiliary monitoring software system for water bath sterilization and monitoring method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108509598A CN108509598A (en) | 2018-09-07 |
| CN108509598B true CN108509598B (en) | 2022-04-19 |
Family
ID=63379960
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810283547.5A Active CN108509598B (en) | 2018-04-02 | 2018-04-02 | Auxiliary monitoring software system for water bath sterilization and monitoring method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108509598B (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105892444A (en) * | 2015-02-13 | 2016-08-24 | 费希尔-罗斯蒙特系统公司 | Security Event Detection Through Virtual Machine Introspection |
| CN205750508U (en) * | 2016-06-23 | 2016-11-30 | 北京中冶力和科技有限公司 | A kind of industrial automation message tube Ore-controlling Role |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080125877A1 (en) * | 2006-09-12 | 2008-05-29 | Fisher-Rosemount Systems, Inc. | Process data collection system configuration for process plant diagnostics development |
-
2018
- 2018-04-02 CN CN201810283547.5A patent/CN108509598B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105892444A (en) * | 2015-02-13 | 2016-08-24 | 费希尔-罗斯蒙特系统公司 | Security Event Detection Through Virtual Machine Introspection |
| CN205750508U (en) * | 2016-06-23 | 2016-11-30 | 北京中冶力和科技有限公司 | A kind of industrial automation message tube Ore-controlling Role |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108509598A (en) | 2018-09-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP6127755B2 (en) | Information processing apparatus, control method for information processing apparatus, and control program | |
| CN108053041B (en) | Secondary system abnormity identification and anti-misoperation system and method under multi-association scene of transformer substation | |
| CN103522289A (en) | Multi-shaft mechanical arm control method and control device | |
| CN111539696A (en) | Two-ticket omnibearing electronic monitoring method and system | |
| CN102723776B (en) | A kind of transforming plant protecting measure and control device Virtual Debugging system | |
| CN108509598B (en) | Auxiliary monitoring software system for water bath sterilization and monitoring method | |
| CN101201601A (en) | Method for monitoring assembly line | |
| CN107957719B (en) | Robot and abnormity monitoring method and device thereof | |
| CN205719594U (en) | A kind of device of simulation test production line cutting apparatus | |
| CN101118435A (en) | Method for on site debugging PLC which divorced from computer | |
| CN204156496U (en) | Cable break-make in a kind of equipment running process detects protective device | |
| CN109361192B (en) | Terminal equipment, and constant value modification method and device | |
| CN209077686U (en) | A kind of Cold header network controller | |
| CN113487182A (en) | Equipment health state evaluation method and device, computer equipment and medium | |
| CN113721557A (en) | Petrochemical device operation process parameter monitoring method and device based on associated parameters | |
| CN104699572A (en) | Computer hardware diagnosis method based on UNIX operating system | |
| CN218411251U (en) | Calibrating device for temperature and humidity sensor of twisting machine | |
| CN102928509B (en) | Material quality detection method of steel materials | |
| CN103995762A (en) | Method for diagnosing board card fault | |
| JP6089837B2 (en) | Updating method of control computer in control computer system | |
| CN104699593A (en) | Computer software diagnosis method based on UNIX operating system | |
| CN104833912B (en) | The fault detection system of control switch based on PLC system | |
| CN204406097U (en) | The operation supervise and control device of Pneumatic silk feeding and environmental dust removal equipment | |
| CN107703909A (en) | A kind of PLC process control communicates shared data block online modification method | |
| CN205608490U (en) | Emergent mode monitored control system of fracturing measuring truck |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |