CN106293740A - A kind of report form developing method being applied to PLC, DCS device data - Google Patents
A kind of report form developing method being applied to PLC, DCS device data Download PDFInfo
- Publication number
- CN106293740A CN106293740A CN201610651138.7A CN201610651138A CN106293740A CN 106293740 A CN106293740 A CN 106293740A CN 201610651138 A CN201610651138 A CN 201610651138A CN 106293740 A CN106293740 A CN 106293740A
- Authority
- CN
- China
- Prior art keywords
- report
- data
- plc
- user
- data base
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/34—Graphical or visual programming
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/451—Execution arrangements for user interfaces
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Human Computer Interaction (AREA)
- Storage Device Security (AREA)
Abstract
The present invention relates to a kind of report form developing method being applied to PLC, DCS device data, apply by processing from the data of PLC/DCS equipment collection, be converted into the form required for user.The method, is characterized in that, including PLC/DCS equipment, data base and the reporting system of band User Interface, data base gathers the data of PLC/DCS equipment, and user operation reporting system generates demand form.This method meets the Report Server Management demand of onsite user, field engineering can be allowed to be an apprentice of in the tedious work of the calculation machine language development form testing journal sheet that uses tricks simultaneously and free, saved the time of engineer.
Description
Technical field
The present invention relates to a kind of report form developing method being applied to PLC, DCS device data, apply and will set from PLC/DCS
The standby data gathered process, and are converted into the form required for user.
Background technology
It is generally directed to the configuration software of PLC/DCS equipment, PLC/DCS equipment can only be write the parameter of some equipment
With collecting device data recorded the operation in data base, but the data that can not be just collected well are presented to life
The equipment user producing workshop is checked, it usually needs additionally exploitation software function is for presenting to user by data with report form
To use, outside the form difference of different statement of equipments, the personnel of exploitation form may also be many people, everyone
The exploitation having oneself is accustomed to, and when each client proposes to need form to inquire about these data, is required for recompiling debugging, then hands over
Being used by user, be in use frequently encountered user and change the demand of form, developer needs the generation to form
Code is adjusted and tests, and under such circumstances, not only exploitation is the longest, after also lacking uniformity and integrity, and requirement
The personnel that phase safeguards need to be accustomed to the exploitation custom of different people, are also one of very headache for the personnel of later maintenance
Thing.It addition, the job demand Field Force of exploitation form possesses the grounding in basic skills of software development, but for PLC/DCS engineer
For, software development may not be so to be good at for them.
Simultaneously along with the continuous fusion of company information with automatization, industry 4.The arrival of 0 revolution, user's meeting of Workshop
More focus on the management of equipment, the information needing record in equipment is also got more and more, need the statement form represented the most more to come
The most complicated, the form difficulty of big great development, add the workload of the exploitation form of engineer, therefore, in order to save engineer
Time, reduce form development difficulty, it is desirable to have a unified form platform, the data of any configuration software can be grafted onto
On storehouse, the demand change that with the form platform of rapid configuration form, can simultaneously tackle again user can quickly respond again.
Owing to user scene exists a lot of report capability, by different staff developments, difficult for the angle of management and maintenance
Spend bigger, the display mode of former form under wanting to adjust such as user, be necessary for amendment test original program, relatively time-consuming arduously, separately
Also require that the computer language of the split part that feels like jelly of attendant is familiar outward, if the knowledge of shortage this respect, basic nothing
Method completes the amendment maintenance work in later stage.Form is safeguarded in management for convenience, shortens opening of form also for aspect Field Force
The time of sending out, allow onsite user oneself can want, in the inquiry of unified platform, the form checked, also to the authority of form simultaneously
Can limit.
Summary of the invention
The purpose of the present invention is providing a kind of report form developing method being applied to PLC, DCS device data, solves existing product
The weak point that product exist, meets the Report Server Management demand of onsite user, field engineering can be allowed to be an apprentice of calculation machine of using tricks simultaneously
The tedious work of language development form testing journal sheet frees, has saved the time of engineer.
The object of the invention is achieved through the following technical solutions:
A kind of report form developing method being applied to PLC, DCS device data, is characterized in that, including PLC/DCS equipment, data base and
With the reporting system of User Interface, data base gathers the data of PLC/DCS equipment, and user operation reporting system generates demand
Form, step is as follows:
1) preparation before report making, gathers data, determines user right and demand data;
2) manufacturing process of form: first user logs into reporting system and operates, data step 1) gathered are at report
Table Database tabular views, rear database root sets up report interface data according to the report form type of required establishment;Wherein form
System sets up the report form type that form is corresponding, creates menu in rear reporting system in menu management;According to above-mentioned steps, by form
The control of authority binding report interface, the inquiry of Database form and display field, ultimately form form, and derive.
As preferably, step 2) in form the process of form: after user triggers form menu key, reporting system is according to report
Table type ID completes following operation: go data base to obtain control data information, find query SQL statement and counting in data base
According to finding report display field in storehouse, wherein, after going data base to obtain control data information, data base obtains root after control information
If having further determined whether that child control has according to control data, obtain information further, if without, generate further and dynamically generate
Control, adds to control in interface, after be combined in data base find query SQL statement and find in data base form show
Show field, ultimately produce display form content.
As preferably, before the report making in step 1), preparation comprises the following steps: first, arranges what client needed
Form;Needed for rear confirmation form, content whether PLC device is all provided with;Confirm again the data acquisition in PLC device to number
According in the table that storehouse is corresponding, the relation of list structure with PLC address is arranged simultaneously and forms requirement documents, if data base do not exist right
Answer list structure, then need to build table;Finally according to the report data demand described in requirement documents, complete SQL statement, and at this newspaper
The data base of table system sets up interface view.
As preferably, described requirement documents is EXCEL document.
As preferably, step 2) in user operation before need first to create role, then distribute role, rear create form power
Limit, and distribute to role.
As preferably, the form finally derived is EXCEL file.
As preferably, the reporting system interface of band User Interface comprises: user manages, be responsible for creating deleting and use
Family;Rights management, is responsible for the authority distribution of reporting system function;Role Management, is responsible for creating and deletes role, be used for binding
After authority, role is distributed to user;Report Server Management, is the form required for user under this catalogue;Menu management, is mainly used in
Create and the menu directory of amendment deletion system;Document types manages, and is mainly used in the labelling form different with differentiation, as
The unique identifier of form is used;Enumeration type manages;Enumerated value manages.
As preferably, the operating function of reporting system includes: derive, current queries result is exported as EXCEL file;Brush
Newly, refresh the result of current queries form, be mainly used in inquiring about the form that requirement of real time is higher;Exit, close current form;
And inquire about and advanced inquiry function.
Compared with prior art, the advantage of this product is:
1, the functions such as complete user authority management, menu management are had, it is easy to management.
2, the multiple form of exploitation can be configured on form platform, save the development time.
3, for developing form on this form platform, for the personnel of exploitation form, difficulty reduces, it is not necessary to real
Code is write on border, need only configure the relevant information of form data base.
4, later maintenance amendment form is more convenient, it is not necessary to change source code.
Accompanying drawing explanation
Fig. 1 is the system architecture diagram of the embodiment of the present invention.
Fig. 2 is the Making programme figure of the present embodiment form.
Fig. 3 is the block diagram that the present embodiment report interface generates.
Detailed description of the invention
Illustrate that the present invention, the following example are merely to illustrate technical scheme below in conjunction with specific embodiment,
Do not limit protection scope of the present invention.
Embodiment:
As it is shown in figure 1, the system architecture of this product includes the form system of PLC/DCS equipment, data base and band User Interface
System, data base gathers the data of PLC/DCS equipment, and user operation reporting system generates demand form.
Some necessary requirements of report making and the step of making:
1, the necessary requirement of report making:
The requirement of 1.1 operating systems: or more than windows2003 windows XP SP3 version, need to install
The requirement of 1.2 database versions: sql2000 version or more than
1.3 other assemblies require: need to install framework3.5 versions or more than
2, preparation before report making:
2.1 arrange the form that client needs, and form EXCEL document (requirement documents).
2.2 confirm needed for forms to be all provided with in content whether PLC.
2.3 confirm in table corresponding for the data acquisition in PLC to data base (as by Intouch software scripts language
Speech), the relation of list structure with PLC address is arranged formation EXCEL document (database table structure explanation is reflected with PLC address simultaneously
Penetrate), if data base does not exist corresponding list structure, then need to build table.
2.4, according to the report data demand described in EXCEL document (requirement documents), complete SQL statement, and at this newspaper
The data base of table platform sets up view.
3, the Making programme of form, as shown in Figure 2:
3.1 data base main list structure introduction:
T_CTR_INFO: mainly contain the control information on report interface.
T_CTR_MENU: System menu information.
T_billtype: report form type information.
TM_SelectBill: the table that the sql statement of inquiry report data preserves.
TM_SelectBillEntry: the table of display Query Result field.
TM_Filter, TM_FilterEntry: be to deposit querying condition for advanced inquiry.
T_PM_PERM: authority information table
T_PM_ROLE: Role Information table
The authority information table that T_PM_ROLEPERM: role is had
T_PM_USER: user message table
The Role Information table that T_PM_USERROLE: user is had
3.2 report making process descriptions:
3.2.1 in form platform, report form type is set up
3.2.2 according to report form type, adding active user in database table T_CTR_INFO (report controls information table) needs
Some the basic controls of the form used, such as the conventional querying condition of form, inquiry button etc.
3.2.3 in table TM_SelectBill, add the SQL statement of inquiry.
3.2.4 add form at table TM_SelectBillEntry and need the field of display.
3.2.5, menu management on form platform increases the menu item that form is corresponding.
3.2.6, user authority management on form platform increases authority, user, role etc., and distributes authorization role.
After completing above operation, can login system again, click on form menu, the form wanted can be obtained, simultaneously can
With by form everywhere for excel file printout.
3.3 report interface generating principles, as shown in Figure 3:
When user presses form menu, utilize the VB.net language in Microsoft Visual Studio 2012 software,
The recurrence dynamic control creation program write by me, retrieves currently selected from database table T_CTR_INFO
The information of the control corresponding to report form type ID corresponding to form, and dynamic control creation one by one on report interface,
After completing interface, when user has filled in form condition, when pressing inquiry button, call completed universal method, call
For the sql statement of inquiry in prior configured good table TM_SelectBill, by Query Result and table TM_
Display corresponding to display field in SelectBillEntry is on report interface.
The form platform of the present embodiment mainly comprises: 1, user's management: is responsible for creating and deletes user;2, rights management: negative
The authority distribution of the function of duty managerial report;3, Role Management: be responsible for creating and delete role, after being used for binding authority, role is divided
Provisioned user;4, Report Server Management: be the form required for user under this catalogue;5, menu management: be mainly used in creating and amendment
The menu directory of deletion system;6, document types management: be mainly used in the labelling form different with differentiation, as form only
One identifier is used;7, enumeration type management: other purposes;8, enumerated value management: other purposes.
The form that the present embodiment is developed includes following substance and function: 1, derive: can be by current queries result
Export as EXCEL file;2, refresh: refresh the result of current queries form, be mainly used in inquiring about the report that requirement of real time is higher
Table, or functional equivalent is in inquiry advanced inquiry;3, exit: close current form;4, the title of form;5, typically the looking into of form
Inquiry condition;6, query function;7, advanced inquiry function;8, the body matter of form.
The key point of the present embodiment have following some:
1, exist in data base owing to the control information on report interface is unified, therefore dynamically can give birth in system operation
Or become to close forms control, the component content of form can be changed at any time.
2, the inquiry sql statement of form and the field of display all can be adjusted in the data base of form platform.
Furthermore, it is necessary to explanation, the specific embodiment described in this specification, the shape of its parts and components, it is named
Titles etc. can be different, and the above content described in this specification is only to present configuration example explanation.All depend on
The equivalence change done according to structure, feature and the principle described in inventional idea of the present invention or simple change, be all included in this
In the protection domain of bright patent.Described specific embodiment can be done various by those skilled in the art
The amendment of various kinds or supplement or use similar mode to substitute, without departing from the structure of the present invention or surmount present claims
Scope defined in book, all should belong to protection scope of the present invention.
Claims (8)
1. it is applied to a report form developing method for PLC, DCS device data, it is characterized in that, including PLC/DCS equipment, data base
With the reporting system of band User Interface, data base gathers the data of PLC/DCS equipment, and user operation reporting system generates to be needed
Seeking form, step is as follows:
Preparation before report making, gathers data, determines user right and demand data;
The manufacturing process of form: first user logs into reporting system and operates, data step 1) gathered are at form
Database tabular views, rear database root sets up report interface data according to the report form type of required establishment;Wherein form system
The report form type that form is corresponding is found in construction in a systematic way, creates menu in rear reporting system in menu management;According to above-mentioned steps, form is weighed
The control of limit binding report interface, the inquiry of Database form and display field, ultimately form form, and derive.
The report form developing method being applied to PLC, DCS device data the most according to claim 1, is characterized in that, step 2)
The process of middle formation form: after user triggers form menu key, reporting system completes following operation according to report form type ID: go
Data base obtains control data information, finds query SQL statement and find report display field in data base in data base,
Wherein, after going data base to obtain control data information, data base determine whether according to control data after obtaining control information be
There is child control to have if no, obtain information further, if without, generate dynamic control creation further, add control to interface
In, after be combined in data base and find query SQL statement and in data base, find report display field, ultimately produce display report
Table content.
The report form developing method being applied to PLC, DCS device data the most according to claim 1 and 2, is characterized in that, step
1) before the report making in, preparation comprises the following steps: first, arranges the form that client needs;In needed for rear confirmation form
Hold and whether PLC device is all provided with;Confirm again, in table corresponding for the data acquisition in PLC device to data base, will simultaneously
List structure arranges formation requirement documents with the relation of PLC address, if data base does not exist corresponding list structure, then needs to build table;?
After the report data demand described in document according to demand, complete SQL statement, and set up in the data base of this reporting system
Interface view.
The report form developing method being applied to PLC, DCS device data the most according to claim 3, is characterized in that, described
Requirement documents is EXCEL document.
The report form developing method being applied to PLC, DCS device data the most according to claim 1 and 2, is characterized in that, step
2) need before the user operation in first to create role, then distribute role, rear establishment form authority, and distribute to role.
The report form developing method being applied to PLC, DCS device data the most according to claim 1 and 2, is characterized in that, finally
The form derived is EXCEL file.
The report form developing method being applied to PLC, DCS device data the most according to claim 1 and 2, is characterized in that, band is used
Comprise on the reporting system interface of family interactive interface: user manages, be responsible for creating and delete user;Rights management, is responsible for report
The authority distribution of table systemic-function;Role Management, is responsible for creating and deletes role, distributes to role use after being used for binding authority
Family;Report Server Management, is the form required for user under this catalogue;Menu management, is mainly used in creating and revising deletion system
Menu directory;Document types manages, and is mainly used in the labelling form different with differentiation, and the unique identifier as form is used;
Enumeration type manages;Enumerated value manages.
The report form developing method being applied to PLC, DCS device data the most according to claim 1 and 2, is characterized in that, form
The operating function of system includes: derive, current queries result is exported as EXCEL file;Refresh, refresh current queries form
As a result, it is mainly used in inquiring about the form that requirement of real time is higher;Exit, close current form;And inquire about and advanced inquiry merit
Energy.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610651138.7A CN106293740A (en) | 2016-08-10 | 2016-08-10 | A kind of report form developing method being applied to PLC, DCS device data |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610651138.7A CN106293740A (en) | 2016-08-10 | 2016-08-10 | A kind of report form developing method being applied to PLC, DCS device data |
Publications (1)
Publication Number | Publication Date |
---|---|
CN106293740A true CN106293740A (en) | 2017-01-04 |
Family
ID=57668226
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201610651138.7A Pending CN106293740A (en) | 2016-08-10 | 2016-08-10 | A kind of report form developing method being applied to PLC, DCS device data |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN106293740A (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107341109A (en) * | 2017-07-07 | 2017-11-10 | 中国银行股份有限公司 | The generation method and system of a kind of test data |
CN110909369A (en) * | 2019-11-08 | 2020-03-24 | 拉货宝网络科技有限责任公司 | Data authority control method based on report platform |
CN112733487A (en) * | 2020-09-17 | 2021-04-30 | 胜宏科技(惠州)股份有限公司 | Efficient PCB engineering CAM electronic indication method and system |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105138501A (en) * | 2015-08-10 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Configurable dynamic report generating method and system |
CN105808228A (en) * | 2014-12-31 | 2016-07-27 | 青岛中科软件股份有限公司 | Generation method of dynamic configuration statement |
-
2016
- 2016-08-10 CN CN201610651138.7A patent/CN106293740A/en active Pending
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105808228A (en) * | 2014-12-31 | 2016-07-27 | 青岛中科软件股份有限公司 | Generation method of dynamic configuration statement |
CN105138501A (en) * | 2015-08-10 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Configurable dynamic report generating method and system |
Non-Patent Citations (2)
Title |
---|
佟川: "基于oracle-erp系统的报表模块的设计和实现", 《中国优秀硕士学位论文全文数据库信息科技辑》 * |
孙细明: "《管理信息系统》", 31 August 2015 * |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107341109A (en) * | 2017-07-07 | 2017-11-10 | 中国银行股份有限公司 | The generation method and system of a kind of test data |
CN110909369A (en) * | 2019-11-08 | 2020-03-24 | 拉货宝网络科技有限责任公司 | Data authority control method based on report platform |
CN112733487A (en) * | 2020-09-17 | 2021-04-30 | 胜宏科技(惠州)股份有限公司 | Efficient PCB engineering CAM electronic indication method and system |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN111027921B (en) | Service processing method and device, electronic equipment and storage medium | |
CN107370786B (en) | General information management system based on micro-service architecture | |
CN103885788B (en) | Dynamic WEB 3D virtual reality scene construction method and system based on model componentization | |
CN105843182B (en) | A kind of power scheduling accident prediction system and method based on OMS | |
CN107341643B (en) | Visual process display method and system | |
Petrie et al. | Coordinating an operational data distribution network for CMIP6 data | |
CN102609526A (en) | Internet website content management system | |
CN101789045B (en) | Realization method of MDA modeling tool orienting to manufacturing field | |
CN106293740A (en) | A kind of report form developing method being applied to PLC, DCS device data | |
CN104217270A (en) | Business process application file generating and execution methods, client, device and system | |
CN109902114A (en) | ES company-data multiplexing method, system, computer installation and storage medium | |
CN102571852A (en) | Courseware distribution method based on network | |
CN105871998A (en) | Data displaying method and device | |
CN102023859A (en) | Digital development environment-oriented software integration method with reliability, maintainability and supportability | |
CN114048188A (en) | Cross-database data migration system and method | |
CN103581141A (en) | Content publishing system and content publishing method | |
Dragoicea et al. | Integrating HLA and service-oriented architecture in a simulation framework | |
CN104268671A (en) | Management method and device for drawing and document file data | |
CN112214236A (en) | Method for building management system of application architecture of software rapid development platform | |
CN106570077B (en) | Column arrangement method and device | |
KR102198686B1 (en) | Method for creating business screen and system for performing the same | |
Singh | Systems integration‐coping with legacy systems | |
Kukla et al. | A general and scalable solution for heterogeneous workflow invocation and nesting | |
CN112732683A (en) | Automatic supervision system and method based on power industry data standard | |
Vaahedi et al. | A future application environment for BC Hydro's EMS |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170104 |