CN106599144A - Monitoring and recording method for operational dynamics of equipment used for intelligent building project - Google Patents
Monitoring and recording method for operational dynamics of equipment used for intelligent building project Download PDFInfo
- Publication number
- CN106599144A CN106599144A CN201611109469.4A CN201611109469A CN106599144A CN 106599144 A CN106599144 A CN 106599144A CN 201611109469 A CN201611109469 A CN 201611109469A CN 106599144 A CN106599144 A CN 106599144A
- Authority
- CN
- China
- Prior art keywords
- report
- row
- intelligent building
- data
- equipment
- 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
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/26—Visual data mining; Browsing structured data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
Abstract
Provided is a monitoring and recording method for operational dynamics of equipment used for an intelligent building project. The method is characterized in that a universal report template pattern is provided by utilizing RDLC through operation records of database organization equipment; and attribute lines are dynamically loaded according to user's choice so that operation record reports of all equipment types in the intelligent building project can be flexibly generated. The technical scheme provided by the monitoring and recording method for operational dynamics of the equipment used for the intelligent building project has following beneficial effects: the requirement for simultaneous monitoring of multiple equipment and attributes in the intelligent building project can be satisfied so that unified management can be supported and carried out; manual cost is lowered and the target of ensuring operation quality is fulfilled; and the future requirement for development of the intelligent building field is met.
Description
Technical field
The present invention relates to intelligent building field, more specifically, the present invention relates to a kind of equipment for intelligent Building Projects
Operation state monitoring record method.
Background technology
With the fast development in intelligent building field, the complexity of building is increasingly improved, in terms of safe efficient, energy-conservation
Require increasingly strictly, in order to give people to create safety, comfortable, convenient, efficient life, a working environment, substantial amounts of modern times
Change equipment is widely used under construction, so that the monitoring of equipment log faces huge challenge.
The current intelligent building comprehensive management platform system set up by setting up centralized Control platform, by HVAC, fire
The control management of 15 smart machine systems such as calamity warning, video monitoring, burglar alarm, energy consumption measure is integrated in a management field
On face, wherein each subsystem includes polytype equipment, such as HVAC subsystem includes handpiece Water Chilling Units, refrigerating water pump, cooling
The equipment such as pump, cooling tower, unitary air handling unit, ceiling type air conditioner unit, Fresh air handling units.Every kind of equipment has and respective does not belong to together
Property, such as handpiece Water Chilling Units attribute has handpiece Water Chilling Units on off state, handpiece Water Chilling Units failure, chilled water flow on off state, cooling dish valve control
System closes the attributes such as feedback, freezing butterfly valve feedback.Such as one typical intelligent building comprehensive management platform system, is related to equipment class
92 kinds of type, device attribute 360, monitoring task is heavy.
Equipment in running needs constantly to monitor its state and generate form, there is provided history alarm record etc. for
Equipment management personnel is referred to.It is first each equipment making report form template that tradition generate the method for form to be, then by the equipment
Service data be filled in template.As intelligent Building Projects equipment is numerous, it is that all devices make report form template respectively
Traditional report form generation method inefficiency, it is impossible to meet equipment operation state monitoring record requirement of real-time.
The content of the invention
In order to meet many attributes of many equipment while the requirement monitored and record, the present invention provides a kind of for intelligent building item
Purpose equipment operation state monitoring record method.
Technical solution of the present invention provides a kind of equipment operation state monitoring record method for intelligent Building Projects, passes through
The log of data base organization's equipment, provides a general report form template pattern using RDLC, dynamic according to the selection of user
State loads attribute column, is flexibly generated the log form of each device type in intelligent Building Projects.
And, comprise the following steps,
Step 0, there is provided the data base of a configuration, the data base are used for the log information of maintained equipment；In data
It is that every kind of device type respectively sets up a view in storehouse；
Step 1, creates data set .xsd and its tables of data table, and table is only arranged comprising 1, if row are entitled
DefaultCol；
Step 2, creates .rdlc files, determines report style and layout, and addition title, list and wherein list only include 1
Row, row head " default row "；
Step 3, creates object data set, object data set is tied on Report List, and the value for arranging " default row " is number
According to the DefaultCol of collection；
Step 4, view in the corresponding data base of the report form type according to selected by user are loaded simultaneously using XmlDocument classes
Modification .rdlc files；
Step 5, arranges form preview interface forms, carries out form displaying or output.
And, the implementation of step 4 includes following process,
The report form type according to selected by user determines view in corresponding data base, is screened according to querying condition in this view
Query Result is drawn, the row name in Query Result is converted into into Chinese character description, while removing the row for being not required to show, form new number
According to table NewTable；
According to selected by user, the view name of report form type corresponding views, reloads data source；
According to selected by user, the view name of report form type corresponding views, reloads data set；
Addition form row head and data, including the binding item of report data is defined, default row are tied to into .xsd's
DefaultCol fields；
By the XmlDocument examples for obtaining, serializing to MemoryStream, MemoryStream are that preservation XML is literary
The stream of shelves.
And, in step 3, a form is placed in forms and check control ReportViewer, load report definition, and
By using information in LoadReportDefinition (Stream stream) method loading MemoryStream, realize tying up
Determine data source, by this displaying interface form.
The present invention can realize many attributes of many equipment while monitoring record, supports that each subsystem correlation of intelligent Building Projects sets
The service data of standby key index collects, device type can self-defined selection within a predetermined range, query time arbitrarily can refer to
When fixing time section, and meeting user and check report data, page turning, redirect, scale etc. and checking miscellaneous function；It is convenient for unified height
The management of effect ground, realizes reducing cost of labor, ensures the target of riding quality, the future for having adapted to the development of intelligent building field needs
Ask.
Description of the drawings
Fig. 1 realizes ultimate principle figure for the RDLC forms of the embodiment of the present invention.
Flow charts of the Fig. 2 for the embodiment of the present invention.
Specific embodiment
The present invention is implemented below according to drawings and Examples and illustrated.
Equipment log table mainly supports the operation number of the key index of each subsystem relevant device of intelligent Building Projects
According to collecting, device type can self-defined selection within a predetermined range, query time can be arbitrarily designated the time period, and meets user and look into
When seeing report data, page turning, redirect, scale etc. and checking miscellaneous function.Report is generated while monitoring in order to meet many attributes of many equipment
The requirement of table, the present invention are proposed, by the log of data base organization's equipment, using RDLC (Report Definition
Language Client-Side, support the RDL of client process report capability) one general form of design
Formwork style, according to the selection dynamic load attribute column of user, can be flexibly generated the log form of each device type.
The realization of RDLC forms includes three parts：
(1) * .rdlc files, for defining report style and layout, at the Report Form Design interface of RDLC, needed for can creating
Report entry, the such as content such as text box, table, essence is XML (extensible markup language) file；XML can be used to labelling
Data, definition data type, are a kind of original language for allowing user to be defined the markup language of oneself.
(2) * .xsd files, define data source format, and an XML file.
(3) ReportViewer controls, process and show the form in application program.
Fig. 1 is referred to, below in conjunction with the method that Fig. 1 introductions realize form using RDLC, is comprised the steps：
Step 0, creates data set * .xsd and its tables of data.
Step 1, creates * .rdlc files, arranges the elements such as report style and layout, addition title, list.
Step 2, creates object data set, object data set is tied on Report List.
Step 3, arranges form preview interface forms.A form is placed in forms and checks control ReportViewer,
And form and data source are bound, just the form that step 1 is designed can be represented.
The form of form fixation can be generated according to above step, but intelligent building comprehensive management platform system needs to carry out greatly
The operation of batch query and generation equipment log table.Therefore, the present invention proposes further improvement project, using RDLC's
Following characteristic, is capable of achieving dynamic addition form row：
(1) RDLC provide LocalReport classes represent without be connected to report server and in processing locality and presentation
Form.Such is the object that ReportViewer controls are used, and LocalReport objects include method
LoadReportDefinition (Stream stream) and attribute ReportPath.LoadReportDefinition
(Stream stream) loads report definition from local file system using Stream (stream).ReportPath is obtained or is arranged
The local file system path of local form.
(2) rdlc .xsd are XML files, and XmlDocument classes represent XML document, can using it is such in a document plus
Carry, verify, editing, adding and placing XML (extensible markup language).
The present invention is each device type in Database view.User selects a kind of equipment class in operation interface
Type, the data i.e. view of the device type of display.As user selects the difference of device type, the different views are called to be in
It is existing.Therefore, using technical solution of the present invention, it is possible to achieve many attributes of equipment are monitored and generate form, according to the selection of user simultaneously
Dynamic load attribute column.Fig. 2 is referred to, and embodiment dynamic generation equipment log table is introduced below in conjunction with Fig. 2, is realized equipment
The method of operation state monitoring record, comprises the steps：
Step 0, sets up data base view maintained equipment log information：One configuration database, the data base are provided
The log information of maintained equipment.It is that every kind of device type respectively sets up a view in data base, i.e., how many plants equipment
Type just sets up how many views.Each view includes following field：(unique identifier, the time, device identification, device name,
Attribute column 1, attribute column 2 ...).The attribute columns of each device type is inconsistent, therefore the row of .rdlc forms are not fixed..rdlc
Form is the list in .rdlc files.
Step 1, creates data set .xsd and its tables of data table, and the row only comprising 1 row, for example, are named as by table
“DefaultCol”。
Step 2, creates .rdlc files, determines report style and layout, and addition title, list, wherein list only include 1
Row, the column heading of the row is " default row " (arbitrarily can be named herein), row head " default row " in embodiment, obtains .rdlc templates,
As the basis of copy.When being embodied as, in addition to the list of addition is needed comprising 1 row, color, word in report style and layout
Body, position by user's sets itself, or can adopt default form.When being embodied as, those skilled in the art can be in designer
It is designed, corresponding XML file after the completion of design, can be automatically generated.
Step 3, creates object data set, object data set is tied in the list of form, for example, arrange " default row "
It is worth the row name of tables of data table in the DefaultCol for data set, i.e. step 1.
Step 4, optimizes the XML (extensible markup language) of .rdlc templates as needed：When being embodied as, can basis
User's view in " report form type " corresponding data base that operation interface is selected, from the form for having been designed obtained by step 2
XML, finding needs the position of modification, and .rdlc templates are loaded and changed using XmlDocument classes.
(1) corresponding data base view is determined in " report form type " that operation interface is selected according to user, such as user selects
Then corresponding data base view is handpiece Water Chilling Units view to handpiece Water Chilling Units form, according to querying condition (time range, device name)
Screening in this view draws Query Result, and the row name in Query Result is converted into Chinese character description, such as attribute column row name conversion
Into Property Name (" handpiece Water Chilling Units on-off control "), while removing the row for being not required to show, such as unique identifier, device identification, shape
Tables of data NewTable of Cheng Xin is stand-by.
(2) according to selected by user report form type corresponding views view name, reload data source.In XML (expansible marks
Note language) in " DataSource " node under path " Report/DataSources ", definition is related to data source
The value of the node is changed to the data base view name of user's selection by row.Respective paths and node are that prior art is existing, this
It is bright that it will not go into details.
(3) according to selected by user report form type corresponding views view name, reload data set.In XML (expansible marks
Note language) in " DataSet " node under path " Report/Datasets ", define the road of the .xsd files of .rdlc associations
Footpath and content.Path is changed to into the data base view name of user's selection.Addition Field nodes, " Fields " under " Dataset "
Node includes the field in data set table, is substituted with the row in NewTable using XmlNode.CloneNode (bool) methods
Content DefaultCol of script Field.XmlNode classes represent the individual node in XML document.CloneNode (bool) sides
Method creates the copy of the node.
(4) form row head and data are added.
In XML (extensible markup language), path " Report/Body/ReportItems/Tablix/TablixBody/
TablixRow under TablixRows ", is report line related content, wherein each report line, defines cell information again.
Here there are two rows under default situations, the first row defines form row head display content, such as：" default row " etc., the second row is defined
The binding item of report data.Such as：It is default to arrange the DefaultCol fields for being tied to .xsd.
(5) under path " Report/Body/ReportItems/Tablix/TablixBody/TablixColumns "
TablixColumn nodes, define the columns of RDLC forms, and how many row replicates the how many nodes, and may specify col width,
Such as 1in (in is long measure).Start form only 1 row for creating, operation herein can replicate form according to the number of attribute,
How many attribute just replicates how many row, is subsequently filled the column heading and content of form.
(6) the TablixMember nodes under TablixMembers are replicated, the node number one and form columns phase is kept
Together.When being embodied as, path " Report/Body/ReportItems/Tablix/TablixRowHierarchy/ is found
TablixMember nodes under TablixMembers ", replicate the node.The operation is for replicated columns as (5), equally
And carry out.
(7) by the XmlDocument examples for obtaining, serializing to MemoryStream.MemoryStream is to preserve XML
The stream of document.
Step 5, arranges form preview interface forms.A form is placed in the forms and checks control
ReportViewer, loads report definition, and binding data source (uses LoadReportDefinition (Stream
Stream) information in method loading MemoryStream), the form of step 4 design just can be represented by this interface.
Simultaneously also support form directly to print, the typical printing function such as print preview, form export function can be derived by main flow form,
Including Excel, Word, PDF.
When being embodied as, method provided by the present invention can realize automatic running flow process using software engineering.
Above content is with reference to specific embodiment further description made for the present invention, it is impossible to assert this
It is bright to be embodied as being confined to these explanations.For general technical staff of the technical field of the invention, do not taking off
On the premise of present inventive concept, some simple deduction or replace can also be made, should all be considered as belonging to the protection of the present invention
Scope.
Claims (4)
1. a kind of equipment operation state monitoring record method for intelligent Building Projects, it is characterised in that：By data base's group
The log of equipment is knitted, a general report form template pattern is provided using RDLC, belonged to according to the selection dynamic load of user
Property row, be flexibly generated the log form of each device type in intelligent Building Projects.
2. the equipment operation state monitoring record method of intelligent Building Projects is used for according to claim 1, it is characterised in that：
Comprise the following steps,
Step 0, there is provided the data base of a configuration, the data base are used for the log information of maintained equipment；In data base
A view is set up respectively for every kind of device type；
Step 1, creates data set .xsd and its tables of data table, and table is only arranged comprising 1, if the entitled DefaultCol of row；
Step 2, creates .rdlc files, determines report style and layout, and addition title, list and wherein list are only arranged comprising 1,
Row head " default row "；
Step 3, creates object data set, object data set is tied on Report List, and the value for arranging " default row " is data set
DefaultCol；
Step 4, view in the corresponding data base of the report form type according to selected by user, is loaded and is changed using XmlDocument classes
.rdlc file；
Step 5, arranges form preview interface forms, carries out form displaying or output.
3. the equipment operation state monitoring record method of intelligent Building Projects is used for according to claim 2, it is characterised in that：
The implementation of step 4 includes following process,
The report form type according to selected by user determines view in corresponding data base, is screened according to querying condition in this view and is drawn
Row name in Query Result is converted into Chinese character description by Query Result, while removing the row for being not required to show, forms new tables of data
NewTable；
According to selected by user, the view name of report form type corresponding views, reloads data source；
According to selected by user, the view name of report form type corresponding views, reloads data set；
Addition form row head and data, including the binding item of report data is defined, default row are tied to into .xsd's
DefaultCol fields；
By the XmlDocument examples for obtaining, serializing to MemoryStream, MemoryStream are to preserve XML document
Stream.
4. the equipment operation state monitoring record method of intelligent Building Projects is used for according to claim 1 or 2 or 3, and which is special
Levy and be：In step 3, a form is placed in forms and check control ReportViewer, load report definition, and by making
Use LoadReportDefinition（Stream stream）Information in method loading MemoryStream, realizes binding data
Source, by this displaying interface form.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611109469.4A CN106599144A (en) | 2016-12-06 | 2016-12-06 | Monitoring and recording method for operational dynamics of equipment used for intelligent building project |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611109469.4A CN106599144A (en) | 2016-12-06 | 2016-12-06 | Monitoring and recording method for operational dynamics of equipment used for intelligent building project |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106599144A true CN106599144A (en) | 2017-04-26 |
Family
ID=58596014
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611109469.4A Pending CN106599144A (en) | 2016-12-06 | 2016-12-06 | Monitoring and recording method for operational dynamics of equipment used for intelligent building project |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106599144A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109299345A (en) * | 2018-10-31 | 2019-02-01 | 北京津发科技股份有限公司 | Multichannel man-machine environment test data synchronous platform item preview system and method |
| CN109684617A (en) * | 2018-12-20 | 2019-04-26 | 北京树根互联科技有限公司 | A kind of report generation method and device |
| CN114087723A (en) * | 2021-09-30 | 2022-02-25 | 中建三局第三建设工程有限责任公司 | Flow monitoring method and device for refrigerating unit |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080263440A1 (en) * | 2007-04-19 | 2008-10-23 | Microsoft Corporation | Transformation of Versions of Reports |
-
2016
- 2016-12-06 CN CN201611109469.4A patent/CN106599144A/en active Pending
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080263440A1 (en) * | 2007-04-19 | 2008-10-23 | Microsoft Corporation | Transformation of Versions of Reports |
Non-Patent Citations (7)
| Title |
|---|
| BLUE SKY ......: "rdlc报表动态生成公共类", 《HTTP://WWW.CNBLOGS.COM/HUBCARL/ARCHIVE/2009/05/10/1453494.HTML》 * |
| PS_ZW: "RDLC报表——动态添加列", 《HTTPS://WWW.CNBLOGS.COM/PSZW/ARCHIVE/2012/07/19/2599937.HTML》 * |
| WATERXCFG304: "ReportViewer动态报表开发完整步骤", 《HTTPS://BLOG.CSDN.NET/WATERXCFG304/ARTICLE/DETAILS/45788639》 * |
| 刘伯驹等: "基于RDLC的全国居民身份证重号纠正系统的报表设计和应用", 《警察技术》 * |
| 左正: "项目中使用RDLC报表", 《HTTPS://WWW.CNBLOGS.COM/SOUNDCODE/P/5435035.HTML 》 * |
| 李伟等: "《C#.NET桌面应用项目开发教程》", 31 January 2016, 清华大学出版社 * |
| 欧阳炜昊: "《程序员突击 VISUAL C#2008原理与系统开发》", 31 August 2009, 清华大学出版社 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109299345A (en) * | 2018-10-31 | 2019-02-01 | 北京津发科技股份有限公司 | Multichannel man-machine environment test data synchronous platform item preview system and method |
| CN109684617A (en) * | 2018-12-20 | 2019-04-26 | 北京树根互联科技有限公司 | A kind of report generation method and device |
| CN114087723A (en) * | 2021-09-30 | 2022-02-25 | 中建三局第三建设工程有限责任公司 | Flow monitoring method and device for refrigerating unit |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108647330B (en) | 3D lightweight conversion method based on BIM model file | |
| CN105677875B (en) | A kind of visual modeling platform based on the unified constraint of normal data element | |
| CN103631596B (en) | Business object data typing and the configuration device and collocation method for updating rule | |
| Yamamoto et al. | Using cloud technologies for large-scale house data in smart city | |
| CN108512691A (en) | Cloud automatic early-warning O＆M monitoring system based on Hadoop | |
| US9679037B2 (en) | System and method for implementing database replication configurations using replication modeling and transformation | |
| CN104462185B (en) | A kind of digital library's cloud storage system based on mixed structure | |
| CN106294695A (en) | A kind of implementation method towards the biggest data search engine | |
| CN109144966A (en) | A kind of high-efficiency tissue and management method of massive spatio-temporal data | |
| CN102663103A (en) | Configurable method for automatically generating database and accessing data | |
| CN106599144A (en) | Monitoring and recording method for operational dynamics of equipment used for intelligent building project | |
| CN103150624A (en) | Equipment management and monitoring system based on process flow diagram | |
| CN111639114A (en) | Distributed data fusion management system based on Internet of things platform | |
| CN112070861A (en) | Multi-user real-time synchronous collaborative map editing method and system considering geographic features | |
| CN109726192A (en) | The system and method for master data model version and field separate management function is realized based on big data environment | |
| CN103226779A (en) | Road logistics price index | |
| CN108830540B (en) | Method, device and system for processing engineering project archive | |
| CN106802928B (en) | Power grid historical data management method and system | |
| CN109978513A (en) | Obtain method and apparatus, project task management equipment and the medium of technical standard | |
| CN110007905A (en) | A kind of generation method and system of the software development scheme based on big data | |
| CN109033425A (en) | A kind of knowledge base management system based on spatial geographic information | |
| CN109993319A (en) | A kind of integrated machine room operation management system | |
| CN108170867A (en) | A kind of metadata service system | |
| CN106682230A (en) | Information service system based on HTML5 and CSS3 mobile display technological architecture | |
| QianCheng | Metadata integration architecture in enterprise data warehouse system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for 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: 20170426 |