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.
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.