CN104950705A - Chromatographic analysis data transmitting control method and device - Google Patents
Chromatographic analysis data transmitting control method and device Download PDFInfo
- Publication number
- CN104950705A CN104950705A CN201510237076.0A CN201510237076A CN104950705A CN 104950705 A CN104950705 A CN 104950705A CN 201510237076 A CN201510237076 A CN 201510237076A CN 104950705 A CN104950705 A CN 104950705A
- Authority
- CN
- China
- Prior art keywords
- data
- enter
- perform
- machine account
- control method
- 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.)
- Granted
Links
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/042—Programme control other than numerical control, i.e. in sequence controllers or logic controllers using digital processors
- G05B19/0426—Programming the control sequence
Landscapes
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Engineering & Computer Science (AREA)
- Automation & Control Theory (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a chromatographic analysis data transmitting control method. The method includes data export, data entry, data transmitting and a data receiving. The method has the advantages that the manual participation links in data transmission are reduced, and high automation level is achieved; timely information transmission is achieved, and data transmission time is lowered from five minutes to within five seconds; high work efficiency is achieved; the original data generated by chromatography is transmitted, manual intervention and modification are avoided, and data transmission accuracy is 100%; electronic document data is saved in a computer, the data is saved completely, and inquiry is facilitated; the larger the production scale is, the higher the production benefits are.
Description
Technical field
The present invention relates to control method and device that a kind of chromatogram analysis data reports and submits, belong to automatic control technology field.
Background technology
At present, in production enterprise, chemical examination is the service of producing, and the chromatogram analysis data in laboratory reports and submits pulpit, the production center, traditional way is: chromatographic work station analyzes data, data are copied in triplicate laboratory test report by lab technician, and after chemical examination supervisor examination & verification, laboratory test report is delivered to pulpit, the production center by lab technician, after pulpit, production center personnel signature is kept on file, laboratory test report is regained by lab technician, and logging data gathers machine account and papery machine account, to inquire about in the future.
Above-mentioned way solves the problem that chromatogram analysis data reports and submits pulpit, the production center more scrupulously, but in a large-scale production line, once analyze data and may have more than 20, a class gets off to have more or less a hundred data and will report and submit pulpit, the production center, this is a very large challenge to laboratory personnel, if data are reported and submitted not in time, incalculable damage will be produced to production, the data that chromatographic work station analyzes simultaneously need lab technician manually to copy laboratory test report, for the ease of the inquiry of later data, after the datagram of laboratory test report delivers to pulpit, the production center, analysis data needs laboratory technician to be manually entered into data summarization machine account and papery machine account, mainly manual entry is relied in the process of data transcription, there will be mistake unavoidably.
Summary of the invention
The technical problem to be solved in the present invention is for above-mentioned deficiency, the control method providing a kind of chromatogram analysis data to report and submit, and after adopting above method, achieves following object:
1, decrease the artificial link participated in data transfer procedure, automaticity is high, reduces labour intensity;
2, information transmission is timely, and the time that data transmit was reduced within five seconds by five minutes, and work efficiency is high, and the accuracy rate that data transmit is 100%;
3, data for electronic documents is kept in computer, and data are preserved complete, convenient inquiry;
4, the device realizing this control method is provided.
For overcoming the above problems, the present invention by the following technical solutions: the control method that a kind of chromatogram analysis data is reported and submitted, is characterized in that, comprises statistical conversion step, data inputting step, data monitoring step, data sending step and data reception step;
Described data inputting step comprises:
Open data summarization machine account, enter step S203;
In step S203, fetch data and gather the next line of the current line number of machine account, enter step S204;
In step S204, data assignment in each for chromatogram analysis data form cell, to data summarization machine account respective cells, is entered step S205;
In step S205, close chromatogram analysis data form, enter step S206;
In step S206, auditor reaffirms the data in data summarization machine account, errorless rear preservation, process ends.
A kind of prioritization scheme, described data sending step:
Open TCP service, enter step S404;
In step S404, judge whether the instruction of preserving data in data summarization machine account, if so, then perform step S405, if not, then continue to perform step S404;
In step S405, control receiving end in detection and whether exist, if so, then perform step S406, if not, then perform step S409;
In step S406, transmit the data summarization machine account document of amendment, then enter step S407;
In step S407, judge whether to transmit successfully, if so, then perform step S408, if not, then perform step S409;
In step S408, successful information write daily record will be transmitted, and do bubble prompting, and return step S404;
In step S409, failure information is write daily record, then enter step S404;
In step S410, TCP service before bolt down procedure, first to be closed.
Further, described data reception step:
Open TCP service, for data receiver is ready, then enter step S504;
In step S504, judge whether transmitting terminal sends message, if so, then perform step S505, if not, then continue to perform step S504;
In step S505, receive the data summarization machine account sent, then enter step S506;
In step S506, judge whether to transmit successfully, if so, then perform step S507, if not, then perform step S510;
In step S507, successful information write daily record will be transmitted, and do bubble prompting, then enter step S508;
In step S508, Data Update is analyzed in text-to-speech prompting, then enters step S509;
In step S509, open the data summarization machine account received, in supplying, control personnel consult at any time, then return step S504;
In step S510, failure information write daily record and points out, then performing step S504;
In step S511, TCP service before bolt down procedure, first to be closed.
Based on the control method that above chromatogram analysis data is reported and submitted, the invention provides a kind of device realizing described control method, it is characterized in that: described device comprises the data handling machine of electrical connection, stratographic analysis terminal, router and data receiver computing machine, router data handling machine, stratographic analysis terminal, router and data receiver computing machine are connected be one can the LAN of shared file.
The present invention adopts above technical scheme, compared with prior art, has the following advantages: decrease the artificial link participated in data transfer procedure, automaticity is high.Information transmission is timely, and the time that data transmit was reduced within five seconds by five minutes, and work efficiency is high.What transmit is the raw data that chromatogram generates, and prosthetic intervention is revised, and the accuracy rate that data transmit is 100%.Data for electronic documents is kept in computer, and data are preserved complete, convenient inquiry.Production scale is larger, and the benefit that this programme produces is also larger.
Below in conjunction with drawings and Examples, the present invention will be further described.
Accompanying drawing explanation
Fig. 1 is that laboratory in the embodiment of the present invention and pulpit, production center computer are networked schematic diagram;
Fig. 2 is the process flow diagram of statistical conversion step in the embodiment of the present invention;
Fig. 3 is the process flow diagram of data inputting step in the embodiment of the present invention;
Fig. 4 is the process flow diagram of data monitoring step in the embodiment of the present invention;
Fig. 5 is the process flow diagram of data sending step in the embodiment of the present invention;
Fig. 6 is the process flow diagram of data reception step in the embodiment of the present invention;
In figure:
1-data handling machine, 2-stratographic analysis terminal, 3-router, 4-data receiver computing machine, 5-laboratory, 6-central control room (CCR).
Embodiment
In embodiment, the control method that a kind of chromatogram analysis data is reported and submitted, comprises statistical conversion step, data inputting step, data monitoring step, data sending step and data reception step.
As shown in Figure 1, the device that this control method relates to comprises the data handling machine 1 of electrical connection, stratographic analysis terminal 2, router three and data receiver computing machine 4, router three also can adopt switch, data handling machine 1 and stratographic analysis terminal 2 are arranged in laboratory 5, stratographic analysis terminal 2 is provided with several, data receiver computing machine 4 is arranged in central control room (CCR) 6, it is a LAN that data handling machine 1, stratographic analysis terminal 2 and data receiver computing machine 4 are connected by router three, can shared file.File A is a LAN-sharing file on data handling machine 1, and for depositing chromatogram analysis data form, file B is a file on data handling machine 1, for storing data summarization machine account.
As shown in Figure 2, statistical conversion step is:
In step S101, receive the chromatogram analysis data that stratographic analysis terminal 2 is transmitted, chromatogram analysis data is copied to Clipboard, enters step S102;
In step S102, judge whether the instruction of the chromatogram analysis data form opened through VBA programming, if had, open and start to process data, then entering step S103;
In step S103, pre-service is emptied to the cell that will use, in case error in data, enter step S104;
In step S104, judge whether the instruction sticky data of clipbook be attached in designating unit lattice, if had, paste, then enter step S105, otherwise continue to judge;
In step S105, search corresponding content according to the component name pre-defined, and by result assignment in the cell provided, enter step S106; The raw data that stratographic analysis terminal 2 provides comprises the component name of sample and the concentration of sample, and the component pre-defined is component title in stratographic analysis terminal 2.
In step S106, judged whether sample ID, lab technician's name information inputs, if had, enters step S107, otherwise continues to judge;
In step S107, current color analysis of spectrum data sheet is separately deposited in the Shared Folders A of data handling machine 1 with another filename, enters step S108;
In step S108, chromatogram analysis data report generation is complete, closes chromatogram analysis data form.
Chromatogram analysis data report generation is complete, chromatogram analysis data has been saved in data handling machine 1, but examination & verification typing personnel chromatogram analysis data form of ransacing one by one in file A is also the pretty troublesome thing of part, for solving this difficulty, data handling machine 1 starts data monitoring step, monitoring data derives the chromatogram analysis data form that step derives, if any variation then open for lab technician check after in data inputting step one key logging data process computer 1, its data monitoring step is:
As shown in Figure 4, in step S301, startup optimization;
In step S302, this program is set and can only runs an example, run in case multiple simultaneously and occur unnecessary mistake;
In step S303, judge whether the chromatogram analysis data form in Shared Folders A has amendment, if step S107 is performed, this step can be triggered, if so, then perform step S304, if not, then continue operating procedure S303.
In step S304, by the date, the time, file name information write journal file, in order to consulting later, enters step S305;
In step S305, text-to-speech prompting auditor has new analysis data, enters step S306;
In step S306, open the chromatogram analysis data form of change, enter data inputting step, gather machine account for auditor's logging data, after perform step S303.
As shown in Figure 3, a key logging data gathers machine account implementation step and data inputting step comprises:
In step S201, the chromatogram analysis data form that step S107 produces, after step S306 is automatically switched on, auditor analyze errorless after, click in chromatogram analysis data form and to be programmed the custom button added by VBA, perform step S202;
In step S202, open data summarization machine account, enter step S203;
In step S203, fetch data and gather the next line of the current line number of machine account, enter step S204;
In step S204, data assignment in each for chromatogram analysis data form cell, to data summarization machine account respective cells, is entered step S205;
In step S205, close chromatogram analysis data form, namely oneself, enter step S206.
In step S206, auditor reaffirms the data in data summarization machine account, errorless rear preservation, process ends.
Fig. 3, Fig. 4 two process flow diagrams are arranged in a chromatogram analysis data form.
Data handling machine 1 data summarization machine account typing computer goes back service data forwarding step simultaneously, and monitoring data gathers the variation of machine account, and then data summarization machine account is sent to data receiver computing machine 4 if any variation, implementation step and data sending step are:
As shown in Figure 5, in step S401, startup optimization;
In step S402, this program is set and can only runs an example, run in case multiple simultaneously and occur unnecessary mistake, enter step S403;
In step S403, open TCP service, for data transmit ready, enter step S404;
In step S404, judge whether the instruction of preserving data in data summarization machine account, if so, then perform step S405, if not, then continue to perform step S404;
In step S405, control receiving end in detection and whether exist, if so, then perform step S406, if not, then perform step S409;
In step S406, transmit the data summarization machine account document of amendment, then enter step S407;
In step S407, judge whether to transmit successfully, if so, then perform step S408, if not, then perform step S409;
In step S408, successful information write daily record will be transmitted, and do bubble prompting, and return step S404;
In step S409, failure information is write daily record, then enter step S404;
In step S410, TCP service before bolt down procedure, first to be closed.
Data receiver computing machine 4 service data receiving step receives the data sent of data handling machine 1 and voice message is opened, and for central control room (CCR), personnel consult, and data reception step is:
As shown in Figure 6, in step S501, startup optimization;
In step S502, this program is set and can only runs an example, run in case multiple simultaneously and occur unnecessary mistake, then enter step S503;
In step S503, open TCP service, for data receiver is ready, then enter step S504;
In step S504, judge whether transmitting terminal sends message, if so, then perform step S505, if not, then continue to perform step S504;
In step S505, receive the data summarization machine account sent, then enter step S506;
In step S506, judge whether to transmit successfully, if so, then perform step S507, if not, then perform step S510;
In step S507, successful information write daily record will be transmitted, and do bubble prompting, then enter step S508;
In step S508, Data Update is analyzed in text-to-speech prompting, then enters step S509;
In step S509, open the data summarization machine account received, in supplying, control personnel consult at any time, then return step S504;
In step S510, failure information write daily record and points out, then performing step S504;
In step S511, TCP service before bolt down procedure, first to be closed.
Equipment involved in the present invention is known products in the market.
Those skilled in the art will recognize that, above-mentioned embodiment is exemplary, to enable those skilled in the art better understand content of the present invention, should not be understood as limiting the scope of the invention, in above statistical conversion step, data inputting step, data monitoring step, data sending step and data reception step, also only can adopt data inputting step of the present invention, data sending step and data reception step, and statistical conversion step, data monitoring step still use conventional methods; Also only can adopt data inputting step of the present invention, and statistical conversion step, data monitoring step, data sending step and data reception step still use conventional methods; Equally, also can adopt separately arbitrary steps in the present invention, and all the other steps use conventional methods; Above embodiment is optimized technical scheme, as long as the improvement done according to technical solution of the present invention, all falls into protection scope of the present invention.
Claims (4)
1. a chromatogram analysis data control method of reporting and submitting, is characterized in that, comprise statistical conversion step, data inputting step, data monitoring step, data sending step and data reception step;
Described data inputting step comprises:
Open data summarization machine account, enter step S203;
In step S203, fetch data and gather the next line of the current line number of machine account, enter step S204;
In step S204, data assignment in each for chromatogram analysis data form cell, to data summarization machine account respective cells, is entered step S205;
In step S205, close chromatogram analysis data form, enter step S206;
In step S206, auditor reaffirms the data in data summarization machine account, errorless rear preservation, process ends.
2. a kind of chromatogram analysis data as claimed in claim 1 control method of reporting and submitting, is characterized in that, described data sending step:
Open TCP service, enter step S404;
In step S404, judge whether the instruction of preserving data in data summarization machine account, if so, then perform step S405, if not, then continue to perform step S404;
In step S405, control receiving end in detection and whether exist, if so, then perform step S406, if not, then perform step S409;
In step S406, transmit the data summarization machine account document of amendment, then enter step S407;
In step S407, judge whether to transmit successfully, if so, then perform step S408, if not, then perform step S409;
In step S408, successful information write daily record will be transmitted, and do bubble prompting, and return step S404;
In step S409, failure information is write daily record, then enter step S404;
In step S410, TCP service before bolt down procedure, first to be closed.
3. a kind of chromatogram analysis data as claimed in claim 2 control method of reporting and submitting, is characterized in that, described data reception step:
Open TCP service, for data receiver is ready, then enter step S504;
In step S504, judge whether transmitting terminal sends message, if so, then perform step S505, if not, then continue to perform step S504;
In step S505, receive the data summarization machine account sent, then enter step S506;
In step S506, judge whether to transmit successfully, if so, then perform step S507, if not, then perform step S510;
In step S507, successful information write daily record will be transmitted, and do bubble prompting, then enter step S508;
In step S508, Data Update is analyzed in text-to-speech prompting, then enters step S509;
In step S509, open the data summarization machine account received, in supplying, control personnel consult at any time, then return step S504;
In step S510, failure information write daily record and points out, then performing step S504;
In step S511, TCP service before bolt down procedure, first to be closed.
4. one kind realizes the device as claim 1-3 control method as described in one of them, it is characterized in that: described device comprises the data handling machine (1) of electrical connection, stratographic analysis terminal (2), router and data receiver computing machine (4), router (3) data handling machine (1), stratographic analysis terminal (2), router and data receiver computing machine (4) are connected be one can the LAN of shared file.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510237076.0A CN104950705B (en) | 2015-05-12 | 2015-05-12 | The control method that a kind of chromatogram analysis data is reported and submitted |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510237076.0A CN104950705B (en) | 2015-05-12 | 2015-05-12 | The control method that a kind of chromatogram analysis data is reported and submitted |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104950705A true CN104950705A (en) | 2015-09-30 |
| CN104950705B CN104950705B (en) | 2017-11-14 |
Family
ID=54165439
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510237076.0A Active CN104950705B (en) | 2015-05-12 | 2015-05-12 | The control method that a kind of chromatogram analysis data is reported and submitted |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104950705B (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2550076B2 (en) * | 1987-06-23 | 1996-10-30 | 株式会社東芝 | Multiple system controller |
| US5736942A (en) * | 1996-07-25 | 1998-04-07 | Randolph; Glenn Edgar | Key pad for communicating with a microprocessor |
| DE19935154A1 (en) * | 1998-07-28 | 2000-02-03 | Denso Corp | Electronic control unit e.g. for i.c.engine control and transmission control in automobile, uses count value information storage region addressed by central processing unit for updating flash memory |
| CN202486533U (en) * | 2012-01-17 | 2012-10-10 | 宋志宇 | Controller area network (CAN) bus intelligent data acquisition control equipment based on electronic monitoring controller area network (EmCAN) agreement |
| CN102750370A (en) * | 2012-06-19 | 2012-10-24 | 江苏新瑞峰信息科技有限公司 | Method and device for remotely submitting archives based on B/S (Browser/Server) structure |
| CN103019125A (en) * | 2012-12-29 | 2013-04-03 | 国电南京自动化股份有限公司 | Multitask real-time data processing system and data recording and data analyzing method |
| CN203773544U (en) * | 2013-12-19 | 2014-08-13 | 卢英俊 | Oil chromatography data query system |
-
2015
- 2015-05-12 CN CN201510237076.0A patent/CN104950705B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2550076B2 (en) * | 1987-06-23 | 1996-10-30 | 株式会社東芝 | Multiple system controller |
| US5736942A (en) * | 1996-07-25 | 1998-04-07 | Randolph; Glenn Edgar | Key pad for communicating with a microprocessor |
| DE19935154A1 (en) * | 1998-07-28 | 2000-02-03 | Denso Corp | Electronic control unit e.g. for i.c.engine control and transmission control in automobile, uses count value information storage region addressed by central processing unit for updating flash memory |
| CN202486533U (en) * | 2012-01-17 | 2012-10-10 | 宋志宇 | Controller area network (CAN) bus intelligent data acquisition control equipment based on electronic monitoring controller area network (EmCAN) agreement |
| CN102750370A (en) * | 2012-06-19 | 2012-10-24 | 江苏新瑞峰信息科技有限公司 | Method and device for remotely submitting archives based on B/S (Browser/Server) structure |
| CN103019125A (en) * | 2012-12-29 | 2013-04-03 | 国电南京自动化股份有限公司 | Multitask real-time data processing system and data recording and data analyzing method |
| CN203773544U (en) * | 2013-12-19 | 2014-08-13 | 卢英俊 | Oil chromatography data query system |
Non-Patent Citations (2)
| Title |
|---|
| 刘玉龙 等: ""EXCEL在气相色谱-质谱检测中的应用"", 《岩矿测试》 * |
| 刘玉龙 等: ""气相色谱分析数据处理接口程序"", 《岩矿测试》 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104950705B (en) | 2017-11-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102955977B (en) | Energy efficiency service method and energy efficiency service platform adopting same on basis of cloud technology | |
| CN110620790B (en) | Network security device linkage processing method and device | |
| CN109359098B (en) | System and method for monitoring scheduling data network behaviors | |
| CN104093080A (en) | Intelligent television remote debugging system and method | |
| CN104218679B (en) | A kind of transformer station's remote auto method for inspecting based on remote viewing system | |
| CN104052633A (en) | Integrated testing method for intelligent station 61850 and telecontrol 104 protocol | |
| CN112613024A (en) | Data interaction method, device and system and storage medium | |
| CN104483842A (en) | Regulation and control integrated automatic master station comparison method | |
| CN110138842A (en) | Microwave sintering real-time remote monitoring system based on MQTT agreement | |
| CN103036775A (en) | Information exchange device, system and method | |
| CN101695170A (en) | Wireless communication network testing data collection and analysis method based on intelligent mobile phone | |
| CN104092581A (en) | Quick message processing method in message recording and analyzing system of intelligent substation | |
| CN109495290B (en) | Operation and maintenance system main station and sub station interaction method and system | |
| US10887408B2 (en) | Remote monitoring of network communication devices | |
| CN104468708B (en) | Data collaborative method and data collaborative device | |
| CN107179754A (en) | A kind of multiple on-line system and its centralized management method | |
| CN104202328B (en) | A kind of method, configuration module and the subscription end of subscription GOOSE/SMV messages | |
| CN104317868B (en) | A kind of regulation and control integral method based on single preposition more SCADA applications | |
| Narojek et al. | Canine elbow dysplasia in different breeds | |
| CN104950705A (en) | Chromatographic analysis data transmitting control method and device | |
| CN103957266B (en) | A kind of equipment centralized Control method of communication system | |
| CN104914760A (en) | Chromatography analysis data submission control method and device | |
| CN104881440A (en) | Method and apparatus for controlling automatic reporting of chromatographic analysis data | |
| WO2011134300A1 (en) | Device, method and system for processing machine to machine service | |
| CN106330567A (en) | Server management control method and server management control system for server cluster |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20181218 Address after: 261300 Chengtai Road, Binhai (Xiaying) Economic Development Zone, Changyi City, Weifang City, Shandong Province Patentee after: Shandong Chengtai New Materials Co., Ltd. Address before: 261313 Binhai (Xiaying) Economic Development Zone, Weifang City, Shandong Province Patentee before: Shandong Cheng Tai Chemical Co., Ltd. |