CN103955798A - Provincial-level electric power measurement center verification task process monitoring method - Google Patents
Provincial-level electric power measurement center verification task process monitoring method Download PDFInfo
- Publication number
- CN103955798A CN103955798A CN201410196083.6A CN201410196083A CN103955798A CN 103955798 A CN103955798 A CN 103955798A CN 201410196083 A CN201410196083 A CN 201410196083A CN 103955798 A CN103955798 A CN 103955798A
- Authority
- CN
- China
- Prior art keywords
- monitoring
- flow
- flow process
- verification task
- calibrating
- 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
Landscapes
- General Factory Administration (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a provincial-level electric power measurement center verification task process monitoring method. According to the method, an ADODB is used for having access to an Oracle database of a MDS, and firstly, trusted connection is built between a process monitoring program and an MDS server database; then, the process monitoring program automatically submits a process monitoring sql script to an MDS server, the process monitoring sql script is executed on the MDS server side, correlated fields of database tables relevant to a verification process are read from an MDS database, and the operation instruction, including data query, external connection and operation, of the process monitoring program sql script is completed; finally, visual process information data are returned to a monitoring server, and connection is cut off. The monitoring method includes monitoring on a process macro unit and monitoring on a process micro unit. The production scheduling platform verification task process is visually monitored with the method, the method is applicable to improving the monitoring efficiency and the monitoring accuracy of the verification task process, the monitoring work intensity is effectively reduced, the monitoring work efficiency is really improved, and the four-line-one-storehouse productivity is improved.
Description
?
Technical field
The present invention relates to a kind of provincial electric-power metering center verification task flow monitoring method, belong to database and the software program method technical field of enterprise's production task flow monitoring.
Background technology
Provincial electric-power metering center relies on production scheduling platform (MDS) to carry out measurement instrument and concentrates calibrating business, and the operation flow of all verification tasks must the order in strict accordance with regulation be carried out in MDS system.But find that " application numbers " of the pending the inside of MDS cannot intuitively embody measurement instrument manufacturer, receipt lot and parameter information in using MDS process, when the measurement instrument that runs into a plurality of receipt lots number pushes away calibrating flow process simultaneously, need to take time in addition and energy is distinguished relevant information corresponding to " application numbers ".MDS system itself lacks necessary flow process progress information global monitoring function and catch mechanism, is easy to cause the problems such as the trying to be the first of flow sequence, hysteresis, mistake, affects the efficiency of plug-flow journey.
The required MDS system database of verification task flow monitoring program table mainly contains (1) vw_equip_manufacturer (device fabrication producer view), (2) vw_wiring_mode(mode of connection view), (3) WFPROCESSINST(workflow tables of data), (4) T_DETECT_TASK(verification task tables of data), (5) c_arrive_check_in(arrival register information tables of data), (6) c_arrive_meter_para (arrival electric energy meter correlation parameter tables of data), (7) D_IO_TASK(discrepancy library information tables of data), (8) t_detect_plan_det(calibrating plan detailed data table), WFWORKITEM(workflow work item data table) (9) tables of data such as.
summary of the invention
The object of the invention is, a kind of provincial electric-power metering center verification task flow monitoring method is disclosed, can monitor macroscopical node step progress information of the metering appliance detecting flow of task of whole batches, can monitor again each batch of metering appliance detecting flow of task details step progress information, the object, position, status information overall process of realizing verification task flow monitoring accurately, efficiently, monitoring in real time.
In order to solve the problems of the technologies described above, the technical solution adopted in the present invention is:
A kind of provincial electric-power metering of the present invention center verification task flow monitoring method, the inventive method is used the oracle database of ADODB access MDS, first the Web watchdog routine in monitoring server breaks the wall of mistrust and is connected with MDS server database, secondly Web watchdog routine is submitted flow monitoring sql script to automatically to MDS server, at MDS server end, carry out SQL script, read MDS system database with the relevant field of the relevant database table of inspection flow process, complete the data query comprising of flow monitoring program SQL script, outreach and arithmetic operation instruction, carry out the most backward monitoring server and return to procedure information data intuitively, close connection, described method for supervising comprises the monitoring of flow process macro and the monitoring to flow process microscopic units.
The monitoring of flow process macro is for describing the entire flow macroscopic view step of whole receipt lots, the calibrating of monitor all batch corresponding producer's titles of carrying out verification task, wiring, flow nodes, flow process progress, flow performing situation, calibrating type, calibrating mode, verification task amount, examine and determine back storehouse time and correspondence goes out the situations such as warehouse-in, adopt suitably sequence, and with " doing " and " charg`e d'affaires " of each step of color differentiating flow process, realize the visual supervisory control of verification task procedure information.
Flow process microscopic units is for describing the entire flow details step of concrete a certain receipt lot, the calibrating flow process that monitors this receipt lot number is initiated to initiate the situations such as time, flow operations time, flow performing people, flow process deadline until calibrating flow process finishes flow process application numbers, task number, the flow process of tens node steps of overall process from calibrating flow process, adopt suitably sequence, and with " doing " and " charg`e d'affaires " of each step of color differentiating flow process, and provide the associative operation user of " pending ".Realize the visual supervisory control of verification task flow process detailed information.The information of showing according to flow process microscopic units, can directly point out the relevant user application numbers of pending flow process, facilitates user to realize precisely operation at numerous and diverse Pending tasks column.
Aforesaid flow process macro, flow monitoring interval range is manage temporarily warehouse-in end and initiated quality inspection flow process to full inspection result treatment from newly purchasing equipment, has comprised defective reinspection flow process; Flow monitoring information combination mode is to adopt arrival batch number, verification task number, flow process application numbers to carry out the association of the relevant informations such as producer, wiring, process name; Flow monitoring switching mode is that receipt lot number is arranged to hyperlink, clicks batch number and can be linked to flow process detailed information; Flow process differentiation display mode is to utilize " pending " and " doing " of color differentiating flow process progress, and to process step and operational circumstances sequence.
Aforesaid flow process microscopic units realizes by following two kinds of modes: mode 1, selected a certain standard and the batch number of complete verification task flow process, as benchmark template, the verification task flow process details active correlation of other batch numbers, guarantees that flow sequence meets service logic order; Mode 2, selected reference template not, directly lists specific operation process and the step vestige of batch number verification task flow process.Flow process differentiation display mode is to utilize " pending " and " doing " of color differentiating flow process progress.
Flow monitoring process of the present invention only needs ADODB For Accessing Oracle Database and only need switch once, SQL script automatically completes all each calibrating flow nodes of whole receipt lots, progress, producer, wiring, calibrating mode, calibrating type, verification task quantity, passing number, calibratings of carrying out verification task flow process and returns information inquiry, computing, filtration and the screenings such as storehouse Liang Hehui storehouse time, without manual input particular batch number.
The tables of data that MDS server database is relevant comprises: device fabrication producer view, mode of connection view, workflow tables of data, verification task tables of data, arrival register information tables of data, arrival electric energy meter correlation parameter tables of data, discrepancy library information tables of data, calibrating plan detailed data table, workflow work item data table electric energy meter information data table, electric energy meter calibration record data table, electric energy meter calibration findings data table, electric energy meter calibration error information table and the electric energy meter record data table of having good luck.
The step of a kind of provincial electric-power metering of the present invention center verification task flow monitoring method is as follows:
(1) obtain arrival batch number, the mode of connection, process name, flow state;
(2) obtain task number, task status, receipt lot number, verification system, calibrating mode type, table bar code and the calibrating conclusion of verification task;
(3) obtain examine and determine back storehouse task task number, receipt lot number, task amount, passing number, return storehouse amount, up-to-date time storehouse time;
(4) obtain receipt lot number, the planned quantity of calibrating plan;
(5) according to receipt lot number, above information is associated, and utilize decode (), sum () with functions such as max () to information procession conversion operations, sum operation after associated, get Value Operations, obtain each receipt lot number calibrating procedure information and producer, wiring, assay approval quantity, return the relevant informations such as storehouse quantity, by receipt lot number, distinguished;
(6) compare per sample, inspect by random samples that examination, performance test, Examined are processed, calibrating planning, Indoor testing calibration, entirely examine result treatment, non-conforming equipment is rechecked flow nodes operational circumstances, arrange " doing " and " pending ", and utilize color differentiating, suitably sequence, accomplishes attractive in appearance, directly perceived.
The present invention's beneficial effect is compared with the prior art: a kind of provincial electric-power metering center verification task flow monitoring method of the present invention, automatical analysis verification task flow process complete information and status data, use visual monitor mode intuitively, with figure and form mode, present procedure information, overcome the abstractness of verification task flow process application numbers, the low readability of procedure information, each user is only to contact the limitation of local flow process, realize the " controlled of verification task flow process overall process, can control, in control ", stop human factor and delay verification task flow process, reduce monitoring management cost, alleviate monitoring working strength, improve measuring control ability level and decision-making benefit, guaranteed that gage work efficiently moves, improve production capacity and keep higher level.
The present invention is applicable to the verification task flow monitoring of provincial electric-power metering center.
accompanying drawing explanation
Fig. 1 is a kind of provincial electric-power metering of the present invention center verification task flow monitoring method flow diagram.
Embodiment
The embodiment of the present invention is comprised of java, asp script and sql script supervisory system server Web watchdog routine.Watchdog routine is the abbreviation based on ADODB(Active Data Object DataBase first, be ADO database) break the wall of mistrust and be connected with MDS server database, next transmits SQL query statement and parameter and receives Query Result set, closes connection, and the most backward client is transmitted picture and text and form.
Committed step:
(1) get process name, flow state, producer, wiring, the task number of each receipt lot number.
From WFWORKITEM(workflow work item data table), T_DETECT_TASK(verification task tables of data), c_arrive_check_in(arrival register information tables of data), c_arrive_meter_para (arrival electric energy meter correlation parameter tables of data) inquires about following information: receipt lot arrive_batch_no, process name processinstname, flow state currentstate, the supply_no of manufacturer, device class equip_categ, mode of connection wiring_mode.By mission number task_no, flow process ID numbering businessid, receipt lot arrive_batch_no, receive bright D numbering rcv_id, receive detailed ID numbering rcv_det_id and carry out association.
(2) get verification task type, verification system, calibrating conclusion, time storehouse time of each batch number and return storehouse amount.
From T_DETECT_TASK(verification task tables of data), the D_IO_TASK(library information tables of data of coming in and going out), vw_sys_no(system numbering view) inquire about following information: verification system sys_no, calibrating conclusion CONC_CODE, calibrating type detect_type, return storehouse time FINISHED_DATE, return storehouse amount finished_io_qty, receipt lot ARRIVE_BATCH_NO.By rela_no, carry out associated with task_no.
(3) get the calibrating planned quantity of each batch number.
From t_detect_plan_det(calibrating plan detailed data table), c_arrive_check_in(arrival register information tables of data) inquiry: receipt lot ARRIVE_BATCH_NO, planned quantity plan_num.By receipt lot ARRIVE_BATCH_NO, carry out association.
Utilize arrival batch number ARRIVE_BATCH_NO to carry out association to the information of step 1-3, and the decode function that utilizes oracle is carried out the capable row operation that turns, max function is got value, sum function to the time quantity is sued for peace, draw each receipt lot receipt lot number, producer, wiring, flow nodes information, verification task type, quantity, return the information such as storehouse time.
In sum, a kind of provincial electric-power metering center verification task flow monitoring method of the present invention, by watchdog routine SQL script automatic screening, filter out the verification task procedure information of receipt lot number, for any one receipt lot, as long as it is walking to examine and determine flow process, just can by flow monitoring program, be found and show, not need manual intervention.Utilize arrival batch number to be distinguished calibrating flow nodes, can guarantee accuracy and the uniqueness of the verification task procedure information that watchdog routine is described.The measurement instrument mode of connection, manufacturer, verification system and the calibrating type that additional each batch number is corresponding, task amount, passing number, time storehouse amount and up-to-date time storehouse time, can realize the concrete meaning of abstract digitized representation, improve readability, be convenient to user's understanding and use.Mode by graphical and form presents verification task procedure information, information is suitably sorted, and with color differentiating, form verification task flow monitoring intuitively, for monitoring, scheduling and management provide basic data, supports and technical guarantee.Realize verification task flow process overall process " controlled, can control, control ", stop human factor and delay verification task flow process, reduce monitoring management cost, alleviate monitoring working strength, improve measuring control ability level and decision-making benefit, guaranteed that gage work efficiently moves, improved production capacity and keep higher level.
Table 1 is that the provincial electric-power metering of embodiment of the present invention center verification task flow monitoring method flow macro is shown chart; Table 2 is that provincial electric-power metering center verification task flow monitoring method flow microscopic units is shown chart.
below by reference to the accompanying drawings the specific embodiment of the present invention is described, but these explanations can not be understood to limit scope of the present invention.Without departing from the spirit and scope of the present invention, the present invention also has corresponding changes and improvements, and these changes and improvements require to fall within the scope of claimed invention.Protection scope of the present invention by claims, define.
Claims (6)
1. a provincial electric-power metering center verification task flow monitoring method, it is characterized in that, described method is used the oracle database of ADODB access MDS, first the flow monitoring program in monitoring server breaks the wall of mistrust and is connected with MDS server database, and secondly Web watchdog routine is submitted flow monitoring sql script to automatically to MDS server; At MDS server end, carry out SQL script, read MDS system database with the relevant field of the relevant database table of inspection flow process, complete data query that flow monitoring program SQL script comprises, outreach and arithmetic operation instruction, carry out the most backward monitoring server and return to procedure information data intuitively, close connection; Described monitoring comprises the monitoring of flow process macro and the monitoring to flow process microscopic units.
2. a kind of provincial electric-power metering center verification task flow monitoring method according to claim 1, it is characterized in that, described monitor procedure only needs ADODB For Accessing Oracle Database and only need switch once, SQL script automatically completes all each calibrating flow nodes of whole receipt lots, progress, producer, wiring, calibrating mode, calibrating type, verification task quantity, passing number, calibratings of carrying out verification task flow process and returns the temporal information inquiry of Liang Hehui storehouse, storehouse, computing, filtration and screening, without manual intervention and operation.
3. a kind of provincial electric-power metering center verification task flow monitoring method according to claim 1, it is characterized in that, each relevant tables of data of described MDS server database comprises: device fabrication producer view, mode of connection view, workflow tables of data, verification task tables of data, arrival register information tables of data, arrival electric energy meter correlation parameter tables of data, the library information tables of data of coming in and going out, calibrating plan detailed data table, workflow work item data table.
4. a kind of provincial electric-power metering center verification task flow monitoring method according to claim 1, it is characterized in that, the entire flow macroscopic view step of whole receipt lots is described in the monitoring of described flow process macro, monitor all batch corresponding producer's titles of carrying out verification task, wiring, flow nodes, flow process progress, flow performing situation, calibrating type, calibrating mode, verification task amount, the calibrating of examining and determine back storehouse time and correspondence goes out warehouse situation, " doing " and " charg`e d'affaires " by each step of color differentiating flow process, each step operational circumstances of flow process is suitably sorted, realize the visual supervisory control of verification task procedure information.
5. a kind of provincial electric-power metering center verification task flow monitoring method according to claim 1, it is characterized in that, described flow process microscopic units is described the entire flow details step of concrete a certain receipt lot, monitor the calibrating flow process of this receipt lot number from putting complete beginning start flow in storage until flow process finishes the flow process application numbers of tens node steps of complete procedure, task number, flow process is initiated the time, the flow operations time, flow performing people, flow process deadline situation, adopt suitably sequence, and with " doing " and " charg`e d'affaires " of each step of color differentiating flow process, each details of flow process is suitably sorted, realize the visual supervisory control of verification task flow process detailed information.
6. a kind of provincial electric-power metering center verification task flow monitoring method according to claim 1, is characterized in that, the concrete steps of described method for supervising are:
(1) obtain arrival batch number, the mode of connection, process name, flow state;
(2) obtain task number, task status, receipt lot number, verification system, calibrating mode type, table bar code and the calibrating conclusion of verification task;
(3) obtain examine and determine back storehouse task task number, receipt lot number, task amount, passing number, return storehouse amount, up-to-date time storehouse time;
(4) obtain receipt lot number, the planned quantity of calibrating plan;
(5) according to receipt lot number, above information is associated, and utilize decode (), sum () with functions such as max () to information procession conversion operations, sum operation after associated, get Value Operations, obtain each receipt lot number calibrating procedure information and producer, wiring, assay approval quantity, return the relevant informations such as storehouse quantity, by receipt lot number, distinguished;
(6) compare per sample, inspect by random samples that examination, performance test, Examined are processed, calibrating planning, Indoor testing calibration, entirely examine result treatment, non-conforming equipment is rechecked flow nodes operational circumstances, arrange " doing " and " pending ", and utilize color differentiating, suitably sequence, accomplishes attractive in appearance, directly perceived.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410196083.6A CN103955798B (en) | 2014-05-12 | 2014-05-12 | A kind of provincial electric-power metering center verification task flow monitoring method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410196083.6A CN103955798B (en) | 2014-05-12 | 2014-05-12 | A kind of provincial electric-power metering center verification task flow monitoring method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103955798A true CN103955798A (en) | 2014-07-30 |
| CN103955798B CN103955798B (en) | 2017-12-12 |
Family
ID=51333071
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410196083.6A Active CN103955798B (en) | 2014-05-12 | 2014-05-12 | A kind of provincial electric-power metering center verification task flow monitoring method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103955798B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104111837A (en) * | 2014-07-15 | 2014-10-22 | 国家电网公司 | Provincial electric power measurement center production early-warning and monitoring method |
| CN104616109A (en) * | 2015-02-03 | 2015-05-13 | 张润虎 | Method for implementing measurement and calibration based on network |
| CN109656774A (en) * | 2018-09-27 | 2019-04-19 | 深圳壹账通智能科技有限公司 | Open regular flow engine analysis method, apparatus, terminal device and storage medium |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103632233A (en) * | 2013-12-05 | 2014-03-12 | 广西电网公司贺州供电局 | Electrical logging specialty practical management system for power enterprises |
-
2014
- 2014-05-12 CN CN201410196083.6A patent/CN103955798B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103632233A (en) * | 2013-12-05 | 2014-03-12 | 广西电网公司贺州供电局 | Electrical logging specialty practical management system for power enterprises |
Non-Patent Citations (2)
| Title |
|---|
| 尧刚: "客户计量器具检定业务管理信息化设计与实现", 《工业计量 》 * |
| 张亦龙: "电子计量仪器自动检定***软件平台分析与设计", 《中国优秀硕士学位论文全文数据库工程科技Ⅱ辑》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104111837A (en) * | 2014-07-15 | 2014-10-22 | 国家电网公司 | Provincial electric power measurement center production early-warning and monitoring method |
| CN104616109A (en) * | 2015-02-03 | 2015-05-13 | 张润虎 | Method for implementing measurement and calibration based on network |
| CN109656774A (en) * | 2018-09-27 | 2019-04-19 | 深圳壹账通智能科技有限公司 | Open regular flow engine analysis method, apparatus, terminal device and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103955798B (en) | 2017-12-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Song et al. | Environmental performance evaluation with big data: Theories and methods | |
| Glock et al. | Decision support models for production ramp-up: a systematic literature review | |
| CA2718845C (en) | Systems and methods for analyzing workflow associated with a pathology laboratory | |
| CN107016444A (en) | Nuclear power plant's digital platform | |
| CN103261883B (en) | Automatically control the separation for quantitative sample analysis and the control system of multiple equipment of detection process | |
| Isaac et al. | Can project monitoring and control be fully automated? | |
| CN103257917A (en) | Management method for software evaluation system | |
| KR20100048449A (en) | Method of standardizing management of planned outages in classified type of nuclear power plant | |
| CN106501760A (en) | A kind of electrical energy meter fault management-control method and system | |
| CN103955798A (en) | Provincial-level electric power measurement center verification task process monitoring method | |
| Jin et al. | Research issues and trends in industrial productivity over 44 years | |
| Cao et al. | Improving the performance of manufacturing systems with continuous sampling plans | |
| Pacaiova et al. | Systematic approach in maintenance management improvement | |
| CN111080364A (en) | Engineering cost data center management system and device | |
| Cutting-Decelle et al. | Production information interoperability over the Internet: A standardised data acquisition tool developed for industrial enterprises | |
| Fu et al. | IFC implementation in lifecycle costing | |
| CN104111837A (en) | Provincial electric power measurement center production early-warning and monitoring method | |
| CN112396349A (en) | Data quality monitoring method based on business entity | |
| Hwang et al. | Application of customized industry-specific metrics to assessment of capital projects performances | |
| Rossbach et al. | Quality system implementation in Member States of the IAEA | |
| KR101511991B1 (en) | Apparatus and method for processing of plant filed data | |
| Suttishe et al. | Integrating activity-based costing and computer simulation to investigate thailand-malaysia cross border: a case study of Sadao customs house | |
| Li et al. | FPGA software testing process management | |
| Liu et al. | Analyzing Critical Influencing Factors of the Maturity of Smart Construction Site Applications | |
| Fadlallah et al. | Addressing the Velocity Challenge of Big Data in Radiation Pollution Monitoring: Implementation and Demonstration |
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 |
Effective date of registration: 20180724 Address after: 330046 No. 88, min Qiang Road, private science and Technology Park, Nanchang, Jiangxi Co-patentee after: State Grid Corporation of China Patentee after: Power Science Research Institute of Jiangxi Electric Power Co., Ltd. Address before: 100761 West Chang'an Avenue, Xicheng District, Xicheng District, Beijing Co-patentee before: State's net Jiangxi Province Electric power Science Academe Patentee before: State Grid Corporation of China |
|
| TR01 | Transfer of patent right |