CN101713968B - Switching operation ticket generating system of converter station and application method thereof - Google Patents

Switching operation ticket generating system of converter station and application method thereof Download PDF

Info

Publication number
CN101713968B
CN101713968B CN2008102009062A CN200810200906A CN101713968B CN 101713968 B CN101713968 B CN 101713968B CN 2008102009062 A CN2008102009062 A CN 2008102009062A CN 200810200906 A CN200810200906 A CN 200810200906A CN 101713968 B CN101713968 B CN 101713968B
Authority
CN
China
Prior art keywords
ticket
operation order
submodule
generating system
module
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.)
Expired - Fee Related
Application number
CN2008102009062A
Other languages
Chinese (zh)
Other versions
CN101713968A (en
Inventor
陈小军
徐兵
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shanghai Branch Of China National Power Grid Corp Operation Branch
State Grid Corp of China SGCC
Original Assignee
SHANGHAI EHV ADMINISTRATION OF STATE GRID OPERATION CO Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by SHANGHAI EHV ADMINISTRATION OF STATE GRID OPERATION CO Ltd filed Critical SHANGHAI EHV ADMINISTRATION OF STATE GRID OPERATION CO Ltd
Priority to CN2008102009062A priority Critical patent/CN101713968B/en
Publication of CN101713968A publication Critical patent/CN101713968A/en
Application granted granted Critical
Publication of CN101713968B publication Critical patent/CN101713968B/en
Expired - Fee Related legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Landscapes

  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a switching operation ticket generating system of a converter station. The ticket generating system is a software system which uses Excel as assistance software for displaying the operation ticket and printing out the format text and uses process-visualized configuration software InTouch for designing the human-machine operating interface on the basis of Windows2000 operating system, relational database Microsoft SQL Server2000 and MACH2 transformer station information system developed by the ABB company. The ticket generating system comprises a training workstation, anetwork printer, an operation ticket database, an operation ticket generating module and an operation ticket managing module. The application of the system can improve the work efficiency, reduce theoccurrence of accidents and ensure the safe operation of electric systems.

Description

Switching operation ticket generating system of converter station and application process thereof
Technical field
The present invention relates to power equipment operative technique field, particularly switching operation ticket generating system of converter station and application process thereof.
Background technology
At the alternating current-direct current of the current conversion station grid switching operation that often relates in service, the personal safety of misoperation entail dangers to causes major accident, causes the tremendous economic loss., safety correct in order to ensure grid switching operation, prevent from maloperation or leak work accident to take place, according to the standardization fill request of power scheduling working specification and various operation notes, before back brake behaviour, must conscientiously fill in grid switching operation bill, carry out item by item in strict accordance with operation order then.By hand writing operation order is a loaded down with trivial details brainwork of wasting time and energy, and inefficiency exists the subjective one-sided of human brain, is difficult to realization science, standard, accurate, complete operation order and writes, and can not guarantee the safe operation of electric power.
Referring to Fig. 1, what the flat current conversion station of political affairs at present used is the MACH2 transformer station infosystem of ABB AB's exploitation, for the needs of system's security of operation and training, this system comprises man-machine interface (InTouch man-machine interface) and system database is on all four and the training system and the implementation system of being isolated by fire wall.Described training system is made of a cover training simulator, training station, network printer and training network.Training simulator is made of 4 MACH2 main frames, moves the control simulation softward of two utmost points of imperial political affairs direct current two ends current conversion station respectively, host computer control one station one utmost point.The training station owner will provide the man-machine interface of a simulation training, and it does not have grid switching operation bill and generates and management function.
Summary of the invention
The objective of the invention is to overcome the defective of prior art, providing a kind of can increase work efficiency, the generation of minimizing accident, a kind of switching operation ticket generating system of converter station of the safe operation of assurance electric system.
Another purpose of the present invention has provided the application process of this switching operation ticket generating system of converter station.
Technical scheme of the present invention is: a kind of switching operation ticket generating system of converter station, it comprises a training station, a network printer, the operation order database, the operation order generation module, the operation order administration module, it is characterized in that: it is with Windows2000 operating system, relevant database Microsoft SQLServer2000, the MACH2 transformer station infosystem of ABB AB's exploitation is the basis, with the format text of demonstration of Excel assistant software and printing ticket, adopt process visualization configuration software InTouch design man machine operation interface; Described operation order generation module comprises that operation order generates submodule, browses/retouching operation paper money module, stored data base submodule, operation order preview submodule, operation order are sealed module, save as typical paper money module; Described operation order administration module comprises that returning of operation order filing management module, filing ticket supplementary modified module, filing ticket get returning of submodule, typical ticket and get submodule, archive operation ticket inquiry submodule, operation order statistics submodule.
Described database comprises the operation order information table of generation, typical operation ticket information table, archive operation ticket information table, table as a result according to certain condition retrieval archive operation ticket, typical operation ticket list information table, operation order classification table, check drawer's table, person approving's table, operator's table, guarder's table, the year statistics table of archive operation ticket, the moon statistics table of archive operation ticket, the general information table that operation order is relevant.
The application process of switching operation ticket generating system of converter station of the present invention, it comprises the steps:
A, startup switching operation ticket generating system of converter station carry out program initialization;
B, the operating process for the treatment of of on the man-machine interface at training station, simulating real-time system, system will write down these operating process automatically, select corresponding operation order rule according to operand and operation item, generate the corresponding operation order information content automatically according to predefined working rule storehouse;
C, generate after the basic operation order information, the drawer browses and retouching operation ticket content, and carries out from examining, and examines certainly by further modification and perfection with ing, and is careful certainly by saving as pre-ticket;
D, guardian, chief operator examine the pre-ticket that the drawer proposes in conformity with its functions and powers, and audit is not made amendment perfectly by returning to the drawer with, examines by reading pre-ticket to Excel, and fills in supplementary, the printing ticket;
E, operation executor are according to operation order executable operations task;
F, operation order filing is preserved.
Switching operation ticket generating system of converter station of the present invention has following advantage:
Adopt the development platform and the application software of international industrial standard under the Windows2000 operating system environment, open strong; Adopt the graphical man machine operation interface of INTOUCH (HMI), can simulate the operation on the real-time MACH2 infosystem HMI of transformer station fully; Based on MACH2 transformer station of ABB AB infosystem, guarantee and on all four circuit logic of real-time system and chain condition, can simulate the distinctive sequential control operation of AC and DC system fully; In the operation of simulation on the real-time MACH2 infosystem HMI of transformer station, the required grid switching operation bill of generation of intelligence has guaranteed the safe reliability of grid switching operation; Operational simulation and training method easy switching, rights management and maintenance are flexibly; Can generate the typical operation ticket, and operation order be carried out intelligent statistical management by using MicrosoftSQL Server2000; Adopt fire wall and actual motion system to isolate, and possess and MIS equipment management system expansion interface and software upgrading function.
Description of drawings
What Fig. 1 was that the flat current conversion station of political affairs uses is the MACH2 transformer station infosystem hardware components structural representation of ABB AB's exploitation;
Fig. 2 is a switching operation ticket generating system of converter station applicating flow chart of the present invention.
Embodiment
The present invention will be further described below in conjunction with specific embodiment.
System embodiment: a kind of switching operation ticket generating system of converter station, it is with Windows2000 operating system, relevant database Microsoft SQL Server2000, the MACH2 transformer station infosystem of ABB AB's exploitation is the basis, with the format text of demonstration of Excel assistant software and printing ticket, adopt the software systems of process visualization configuration software InTouch designer machine operation INTERFACE DESIGN.It comprises a training station, a network printer, operation order database, operation order generation module, operation order administration module.
1, described operation order generation module: this part finishes mainly that the initial operation ticket file that operation order operation steps generation system is generated is browsed, revised, preservation, printing function.
(a) definition one window, a plurality of operation buttons of this window definition are as " browsing/retouching operation ticket file ", " stored data base ", " operation order preview ", " saving as typical ticket " etc.
(b) " browse/retouching operation paper money module ": the interim operation order text that this submodule generates with notepad mode opening operation ticket operation steps generation system, can make amendment to text file, increase, deletion record operation, revise the back and preserve file.
(c) " stored data base submodule ": this submodule is used for amended operation information file is stored in database, and the generating run ticket shows the data of the correlation table of usefulness.
(d) " operation order preview submodule ": this submodule will start Excel and open also display operation ticket, this Excel file be pre-define touch the plate file, have a plurality of plates of touching, will touch plate (as 1 page, 2 pages, 3 pages, 4 page operations steps) according to how many automatic selections of operation steps.Except that content of operation, other content all is a fixed part, and the content of operation part will connect database automatically and dynamically show when opening Excel.Contents such as operation task in this document and remarks section need artificial input.
(e) the operation order module of sealing: this submodule is directly used Print Preview and the print button printing ticket in the Excel instrument.
(f) " save as typical paper money module ": this submodule is deposited current operation order content of operation in the text, and increases corresponding information in the relevant table of typical ticket in database, will import typical ticket title during preservation.Typical case's ticket will exist under a certain fixedly catalogue with document form.
(g) if want manual generating run ticket, can directly start " browsing/retouching operation paper money module ", other subsequent operation is similar with the operation order that is generated by operating process.
2, described operation order administration module: returning of the filing of the main complete operation ticket of this part, typical operation ticket got, the inquiry and the statistical function of archive operation ticket.
(a) operation order filing management submodule: define a window, can show the historical operation ticket, definition " interpolation operation order " button, start behind this button pop-up window is used for input draw a bill time, numbering, classification, operation task, fill out supplementary such as the execution of ticket people, person approving, operator, guardian, value length, typical ticket title, execution/not, the window definition save button that ejects, after the startup with this operation order log database.The archive operation ticket will indicate as key with the time of drawing a bill, and numbering can generate automatically but can the manual amendment.Typical case's ticket title, classification, fill out ticket people, person approving, operator, guardian, value length and can from tabulation, choose, also can newly import.
(b) filing ticket supplementary is revised submodule: can select certain filed operation order from filing ticket list window, with the information that shows that it is auxiliary, and can wait as numbering its supplementary and make amendment, press the information updating database of " preservation " button with modification.
(c) returning of filing ticket got submodule: can select certain filed operation order from filing ticket list window, press " return and get " button, the content that then will file the typical ticket of ticket correspondence is returned and is got in the relevant table of database, starts " demonstration " button and then will start Excel and open and show this operation order.
(d) returning of typical ticket got submodule: the tabulation of definition window shows typical ticket, choose a typical ticket and press " return and get " button, content that then should typical case's ticket is returned and is got in the relevant table of database, starts " demonstration " button and then will start Excel and open and show this operation order.
(e) archive operation ticket inquiry submodule: define a window, can import Start Date and Close Date (also can not consider the date), can select query option, as select universal class type, classification, fill out the ticket people, person approving, operator, guardian, value are long etc., each option can be chosen from tabulation.Start " inquiry " button, then show Query Result, this Query Result shows with Excel, can print.
(f) operation order statistics submodule: in archive operation ticket query window, define one " statistics " button, will add up execution and unenforced operation order number annual and every month after the startup automatically.Definition simultaneously " statistics shows " button will start Excel and show statistics.
3, described operation order database: at the demand of operation ticket system, define a SQL Server database optdb, this database will comprise table relevant with operation ticket system and storing process.
(1) table:
(a) table OPTText: this table is used to store the operation order information of generation.Row: OprText (char*120).
(b) table OPTSubText1: this table is used for 1 page of operation order information to be shown of storage operation ticket Excel table the.Row: OrderNo (int*2), OprText (char*120).
(c) table OPTSubText2: this table is used for 2 pages of operation order information to be shown of storage operation ticket Excel table the.Row: OrderNo (int*2), OprText (char*120).
(d) table OPTSubText3: this table is used for 3 pages of operation order information to be shown of storage operation ticket Excel table the.Row: OrderNo (int*2), OprText (char*120).
(e) table OPTSubText4: this table is used for 4 pages of operation order information to be shown of storage operation ticket Excel table the.Row: OrderNo (int*2), OprText (char*120).
(f) table RetOPTText: this table is used to store back the typical operation ticket information of getting.Row: OprText (char*120).
(g) OPTHistory: this table is used to preserve archive operation ticket information.Row: OPTNo (int*4), CreateDate (char*10), CreateTime (C*8), OPTTask (char*40), OPTType (C*16), OPTCreator (char*8), OPTAssessor (char*8), OPTOperator (char*8), OPTMonitor (char*8), OPTMode (char*20), OPTExecuted (int*1).
(h) OPTSelectResult: be used to store result according to certain condition retrieval archive operation ticket.Row: OPTNo (int*4), CreateDate (char*10), CreateTime (C*8), OPTTask (char*40), OPTCreator (char*8), OPTAssessor (char*8), OPTOperator (char*8), OPTMonitor (char*8), OPTExecuted (C*8).
(i) OPTMode: be used to store typical operation ticket list information.Row: ModeName (C*32).
(j) OPTType: the defining operation fare ticket type is other.Row: TypeID (C*16).
(k) OPTCreator: definition check drawer: row: Name (char*8).
(l) OPTAssessor: definition person approving.Row: Name (char*8).
(m) OPTOperator: defining operation people.Row: Name (char*8).
(n) OPTMonitor: definition guarder.Row: Name (char*8).
(o) OPTStatByYear: the year statistics of stores archive operation order.Row: OPTYear (C*4), NumOfExcuted (int*2), NumOfUnexcuted (int*2).
(p) OPTStatByMonth: the moon statistics of stores archive operation order.Row: OPTYear (C*4), OPTMonth (C*2), NumOfExcuted (int*2), NumOfUnexcuted (int*2).
(q) OPTStatus: this table has only row, is used for some relevant general informations of storage operation ticket.Row: OPTStatusKey (int*1), OPTPintPageNum (int*1).
(2) storing process: definition as required:
(a) ImportCurrentOPT: the operation steps message file is imported database, be used for Excel and show.
(b) SaveCurrentOPTAsMode: current operation order is saved as typical ticket.
(c) ImportOPTMode: given typical ticket file is imported in the database.
(d) LogOPTHistory: login archive operation ticket, check whether supplementary exists in the corresponding table separately, if there is not automatic insertion.
(e) SelectOPT: obtain specified criteria the archive operation ticket relevant information and the result charged to OPTSelectResult table.
(f) StatOPT: statistics annual, execution in every month and unenforced operation order number.
Method embodiment:
As shown in Figure 2, the application process of this switching operation ticket generating system of converter station, it comprises the steps:
A, startup switching operation ticket generating system of converter station carry out program initialization;
B, the operating process for the treatment of of on the man-machine interface at training station, simulating real-time system, system will write down these operating process automatically, select corresponding operation order rule according to operand and operation item, generate the corresponding operation order information content automatically according to predefined working rule storehouse;
C, generate after the basic operation order information, the drawer browses and retouching operation ticket content, and carries out from examining, and examines certainly by further modification and perfection with ing, and is careful certainly by saving as pre-ticket;
D, guardian, chief operator examine the pre-ticket that the drawer proposes in conformity with its functions and powers, and audit is not made amendment perfectly by returning to the drawer with, and examine by reading pre-ticket to Excel, and fill in supplementary, the printing ticket,
E, operation executor are according to operation order executable operations task;
F, operation order filing is preserved.
See table: State Grid Operation Co., Ltd. Shanghai Superhigh-Voltage Management Office's grid switching operation bill is that to change maintenance with 5612 alternating current filters by operation be example, the operation order that generates through operation and operation.
State network operation company limited
Operation order is explained in Shanghai UHV (ultra-high voltage) management place
Unit: The Zheng Ping current conversion stationFortune _ _ _ _ _ value scheduling order number 001Numbering 0809001
Figure GSB00000520348100091
Operator: guardian: responsible official on duty (value is long):

Claims (3)

1. switching operation ticket generating system of converter station, it comprises a training station, a network printer, the operation order database, the operation order generation module, the operation order administration module, it is characterized in that: it is with Windows 2000 operating systems, relevant database Microsoft SQL Server2000, the MACH2 transformer station infosystem of ABB AB's exploitation is the basis, with the format text of demonstration of Excel assistant software and printing ticket, adopt process visualization configuration software InTouch design man machine operation interface; Described operation order generation module comprises that operation order generates submodule, browses/retouching operation paper money module, stored data base submodule, operation order preview submodule, operation order are sealed module, save as typical paper money module; Described operation order administration module comprises that returning of operation order filing management module, filing ticket supplementary modified module, filing ticket get returning of submodule, typical ticket and get submodule, archive operation ticket inquiry submodule, operation order statistics submodule.
2. according to the described switching operation ticket generating system of converter station of claim 1, it is characterized in that: described database comprises the operation order information table of generation, typical operation ticket information table, archive operation ticket information table, table as a result according to certain condition retrieval archive operation ticket, typical operation ticket list information table, operation order classification table, check drawer's table, person approving's table, operator's table, guarder's table, the year statistics table of archive operation ticket, the moon statistics table of archive operation ticket, the general information table that operation order is relevant.
3. the application process of claim 1 or 2 described switching operation ticket generating system of converter station, it comprises the steps:
A, startup switching operation ticket generating system of converter station carry out program initialization;
B, the operating process for the treatment of of on the man-machine interface at training station, simulating real-time system, system will write down these operating process automatically, select corresponding operation order rule according to operand and operation item, generate the corresponding operation order information content automatically according to predefined working rule storehouse;
C, generate after the basic operation order information, the drawer browses and retouching operation ticket content, and carries out from examining, and examines certainly by further modification and perfection with ing, and is careful certainly by saving as pre-ticket;
D, guardian, chief operator examine the pre-ticket that the drawer proposes in conformity with its functions and powers, and audit is not made amendment perfectly by returning to the drawer with, examines by reading pre-ticket to Excel, and fills in supplementary, the printing ticket;
E, operation executor are according to operation order executable operations task;
F, operation order filing is preserved.
CN2008102009062A 2008-10-08 2008-10-08 Switching operation ticket generating system of converter station and application method thereof Expired - Fee Related CN101713968B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN2008102009062A CN101713968B (en) 2008-10-08 2008-10-08 Switching operation ticket generating system of converter station and application method thereof

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN2008102009062A CN101713968B (en) 2008-10-08 2008-10-08 Switching operation ticket generating system of converter station and application method thereof

Publications (2)

Publication Number Publication Date
CN101713968A CN101713968A (en) 2010-05-26
CN101713968B true CN101713968B (en) 2011-08-17

Family

ID=42417675

Family Applications (1)

Application Number Title Priority Date Filing Date
CN2008102009062A Expired - Fee Related CN101713968B (en) 2008-10-08 2008-10-08 Switching operation ticket generating system of converter station and application method thereof

Country Status (1)

Country Link
CN (1) CN101713968B (en)

Families Citing this family (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102436241A (en) * 2011-11-21 2012-05-02 江西省电力公司信息通信中心 Intelligent substation switching operation ticket system
CN102646234B (en) * 2012-03-30 2015-05-13 广东电网公司中山供电局 Scheduling order repeating method and device
CN103593809A (en) * 2013-12-03 2014-02-19 国家电网公司 Intelligent operation-ticket semanteme verification method of automatic power dispatching system
CN104460607A (en) * 2014-11-17 2015-03-25 国家电网公司 Production system graphic ticketing method based on simulated rehearsal
CN106557909A (en) * 2016-11-21 2017-04-05 国网四川省电力公司眉山供电公司 Work ticket automatic generation system
CN108922301A (en) * 2018-08-09 2018-11-30 中国南方电网有限责任公司超高压输电公司大理局 Converter station VR virtual framework training system based on VR virtual reality technology
CN109543962B (en) * 2018-11-05 2021-04-02 广东电网有限责任公司 Method for automatically counting work load scores of electronic operation tickets
CN110716454B (en) * 2019-10-23 2022-10-14 国网冀北电力有限公司承德供电公司 Method and device for generating scheduling switching operation ticket
CN111857705B (en) * 2020-08-07 2021-07-20 朱宏博 Method for developing switching operation and generating operation order based on force control configuration software

Also Published As

Publication number Publication date
CN101713968A (en) 2010-05-26

Similar Documents

Publication Publication Date Title
CN101713968B (en) Switching operation ticket generating system of converter station and application method thereof
CN104715052B (en) Generate the method and its system of report
CN107220757B (en) System and method for rule configuration and analysis
CN109445886A (en) A kind of interface display method, system and terminal device
CN102693253A (en) Image management and presentation
CN101908078A (en) Method and device for importing webpage data to EXCEL sheet
US20150066977A1 (en) Method and system for managing digital resources
CN101488086A (en) Software generation method and apparatus based on field model
Bontcheva et al. Web-based collaborative corpus annotation: Requirements and a framework implementation
CN106204362B (en) A kind of law works management system
JP7209306B2 (en) Online work system for Excel documents based on templates
CN107256144A (en) Front and back code automatic generation method, terminal and computer-readable recording medium
CN101093477B (en) Data process method for electronic form, and data process system for electronic form
CN101706829A (en) Data storage method and device
CN111339098A (en) Authority management method, data query method and device
CN109189593A (en) A kind of method, apparatus of data processing, computer equipment and storage medium
CN109614143B (en) Development method for automatically generating fault flow chart in IETM browser
CN104573053A (en) Configuration item template dynamic customizing method based on XML
CN116881206A (en) Method, device and equipment for processing residual material data of trepanning
CN105320737A (en) Firefighting inspection and acceptance retrieving system
CN111435300A (en) Web system development method, device, equipment and storage medium
CN101127142A (en) False proof invoice-making machine for tax control
CN111124385B (en) Automatic generation method and system of power supply design software based on database
CN103020162A (en) Method for converting and importing CC2000 model into D5000 system
CN103246962A (en) Enterprise comprehensive information management system

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant
ASS Succession or assignment of patent right

Owner name: STATE GRID OPERATION CO., LTD. SHANGHAI SUPERHIGH-

Effective date: 20130729

Owner name: STATE ELECTRIC NET CROP.

Free format text: FORMER OWNER: STATE GRID OPERATION CO., LTD. SHANGHAI SUPERHIGH-VOLTAGE MANAGEMENT OFFICE

Effective date: 20130729

C41 Transfer of patent application or patent right or utility model
COR Change of bibliographic data

Free format text: CORRECT: ADDRESS; FROM: 201600 SONGJIANG, SHANGHAI TO: 100032 XICHENG, BEIJING

TR01 Transfer of patent right

Effective date of registration: 20130729

Address after: 100032 Xicheng District, Chang'an Avenue, No. 86,

Patentee after: State Grid Corporation of China

Patentee after: State Grid Operation Co., Ltd. Shanghai Superhigh-Voltage Management Office

Address before: 201600, room 339, 1101 Ledu Road, Shanghai, Songjiang District

Patentee before: State Grid Operation Co., Ltd. Shanghai Superhigh-Voltage Management Office

ASS Succession or assignment of patent right

Owner name: SHANGHAI MANAGEMENT OFFICE OF GRID OPERATION BRANC

Free format text: FORMER OWNER: STATE GRID OPERATION CO., LTD. SHANGHAI SUPERHIGH-VOLTAGE MANAGEMENT OFFICE

Effective date: 20150522

C41 Transfer of patent application or patent right or utility model
TR01 Transfer of patent right

Effective date of registration: 20150522

Address after: 100032 Xicheng District, Chang'an Avenue, No. 86,

Patentee after: State Grid Corporation of China

Patentee after: Shanghai branch of China National Power Grid Corp operation branch

Address before: 100032 Xicheng District, Chang'an Avenue, No. 86,

Patentee before: State Grid Corporation of China

Patentee before: State Grid Operation Co., Ltd. Shanghai Superhigh-Voltage Management Office

CF01 Termination of patent right due to non-payment of annual fee

Granted publication date: 20110817

Termination date: 20191008

CF01 Termination of patent right due to non-payment of annual fee