CN103488632A - Universal dynamic adjustment method for multi-data-item display - Google Patents
Universal dynamic adjustment method for multi-data-item display Download PDFInfo
- Publication number
- CN103488632A CN103488632A CN201210189735.4A CN201210189735A CN103488632A CN 103488632 A CN103488632 A CN 103488632A CN 201210189735 A CN201210189735 A CN 201210189735A CN 103488632 A CN103488632 A CN 103488632A
- Authority
- CN
- China
- Prior art keywords
- data
- data item
- item
- configuration
- configuration file
- 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
Images
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/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- 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)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Human Computer Interaction (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The invention discloses a universal dynamic adjustment method for multi-data-item display. The method comprises the following steps: firstly, providing a man-machine interface and setting the quantity of displayed data items, comparison data items and data item attributes to finish control drawing of required data item display; secondly, configuring a data item attribute file and configuring all information including attributes of the data items in a configuration file through the file; lastly, displaying and operating the data items through the man-machine interface according to characteristics included in the configuration file. According to the method, various objects of large data volumes can be displayed, modified, compared and subjected to data validity detection and the like, the development speed and efficiency of the man-machine interface are increased greatly, and later project maintenance can be performed easily; modification of the configuration file and adjustment of pictures are finished by using a configuring tool, so that modification of applications is reduced.
Description
Technical field
The present invention relates to a kind of general many data item and show dynamic adjusting method, can be widely used in that the object larger to various data volumes shown, modification, comparison, data validity inspection etc.
Background technology
In Process Control System, as material data, equipment setting data and produce the data that produce etc., abstract in one or more solid datas to these class data in system, so just having produced an entity has a large amount of attribute datas.The data database or alternative document mode are stored, and can form data and record several data item.In control system, each item number of each record is according to likely needing special management, require these data on showing according to data item represented attribute different from other data item, although each data item belongs to the ingredient of a record, each data item shows as again mutual independence.Demonstration with good conditionsi and the operation of the main deal with data item of the man-machine interface of Process Control System.
The major technique that at present Process Control System adopts, carry out independent processing to each data item in design, lacks abstract to the general character of each data item, the unification of processing mode.So not only early development amount is large, and test and later maintenance task are all very loaded down with trivial details; Very flexible, the adjustment of simple data item display position, data validity inspection etc. all need update routine to realize; Lack versatility, use in material data, but can't apply fully in equipment setting data and production data, must just can be suitable for through very large adjustment.
Through retrieval, the Chinese invention patent that application number is 200910194884.8, this invention relates to that " a kind of dynamic adjusting data database data, in the method for picture disply content and form, comprises the following steps: 1) preset the content that needs demonstration and corresponding form; 2) be kept in the first file for the content that needs to show generates dynamic SQL statements, corresponding format information is kept in the second file, information and the information in the second file in described the first file are interrelated; When 3) picture program starts, read this first file and the second file, access corresponding database table or view by the dynamic SQL statements in the first file, the content that acquisition need to be shown on picture; By the format information in the second file, display format is set; 4) show and need the content shown according to corresponding format information.The present invention can allow the picture developer just can meet rapidly different user different requirements from form to the picture disply content without revising own picture program, has reduced mistake, has improved development efficiency, has good adaptability.”
The foregoing invention patent is mainly utilized the information of configuration file stores, completes that data show and shows the setting of style, but lack control to showing, show the adjustment of individuation style, data requirement inspection, packet etc.In actual utilization, the existing unified general character of each data item, the individual character that shows differentiation is arranged again, and this just requires disposal route both can, to the control that arranges of overall data general character, realize again the control function to the special demonstration of each data item and special operational thereof.
And technical scheme of the present invention has solved the functions such as conversion of differentiation demonstration, data requirement checking, the demonstration of data manipulation difference, data item comparison, data display mode.
Summary of the invention
The object of the invention is to solve above-mentioned deficiency of the prior art, provide a kind of general many data item to show dynamic adjusting method, object that can be larger to various data volumes is shown, modification, comparison, data validity inspection etc.
For realizing above-mentioned purpose, the present invention has adopted following technical scheme:
The invention provides a kind of general many data item and show dynamic adjusting method, the method is:
At first one personal-machine interface is provided, and the settings such as the number of the data item by set and display, correlation data item, data item attribute, can complete the ActiveX drafting that desired data item shows;
Then carry out the configuration of data item attribute file, pass through this document, the all full details that comprise attribute of data item are configured in configuration file, and the configuration information that configuration file comprises has meaning, type, display position, demonstration data length, tables of data, data sheet field, view name, view field name, operability, validity, demonstration bells and whistles of data item etc.;
Finally, the characteristic comprised by configuration file, shown data item and operated by man-machine interface.
Further, general many data item demonstration dynamic adjusting method of the present invention are carried out according to the following steps:
(1) preset value that shows data is set, comprising configuration information has: display data item number, every page of display data item, every page show data group number, data transfinite marker color, data modification marker color etc., produce data item and show control;
(2) be configured file configuration, by the needed attribute configuration of data item, in configuration file, the attribute information of a data item of each line display, separate with special character so that handling procedure is used between the attribute of data item;
(3) fileinfo of configuration in (2) is read, difference becomes the needed community set of each data item, complete data simultaneously and read the SQL statement tissue, be assigned to the data item that in (1), configuration produces and show control, the demonstration control of each data item is stored the configuration information of this data item;
(4) SQL statement produced according to (3), carry out data and read, and is placed on data result and concentrates;
(5) the data result collection (4) obtained is assigned to the set of (1) data item control, and the data item configuration information arranged according to (3) is adjusted data and shown, the limit check of data, the modification mark check of data and the settings such as display position of data;
Described data item to the step of its operation is:
1. data item control collection is set and revises marker bit, current all item status, according to the configuration information in configuration file, carry out the edit properties setting, if data item is set in configuration file, can not revise, this data item editing attribute can not editing mode, and other data item all can be edited;
2. after 1. arranging, the value of Update Table item, at first the new value of modification is marked as revises the status color mark, if this data item arranges validity check, if new value transfinites, this is labeled as the color tips that transfinites.Color mark also can arrange priority level;
3. after completing all data item occurrences and revising, submit data result to, according to the configuration information of storing, can find table and corresponding literary name section under data item in the data item control, Data Update in database table.
The display position adjustment of described data refers to: by the display position numbering of certain data item in direct modification configuration file, can directly adjust the position of data item in whole data show.
The present invention by the processing of data item abstract be the common trait of different object, reach by configuration data the different manifestations that the different pieces of information item has, carry out the demonstration of characteristic and operation etc. under the processing mode of general character, can be general in material data, equipment setting data and production actual achievement data, to expand to the general of the many data item processing of different field.
The present invention can be applied in the process control of cold rolling system, has using value, the management that this system comprises raw data, set-point data, production actual achievement data, roll detailed data, the management of these class data is that specific that variation shows arranged in regularization, use this method to improve greatly tempo of development and the efficiency of man-machine interface, project maintenance to the later stage is also very easy, uses configuration tool to complete the modification of configuration file and the adjustment of picture, reduces the modification of application program.
The present invention can also further extend to the comparing function of homogeneous data, and the modification tag entry information of use device can find out difference item between comparing data etc.The management of similar many data item is also arranged in other field, can apply the present invention to other field.
Technical scheme of the present invention has solved the functions such as conversion of differentiation demonstration, data requirement checking, the demonstration of data manipulation difference, data item comparison, data display mode.
The accompanying drawing explanation
Fig. 1 is data pattern and transformation factor;
Fig. 2 is picture data item display packing;
Fig. 3 is embodiment of the present invention process flow diagram.
Embodiment
Below in conjunction with drawings and Examples, the technical solution of the present invention is further explained, but following content is not intended to limit the scope of the invention.
The present invention completes the demonstration adjustment of data according to the following steps:
(1) use the datagroupview control of C#.NET platform development, the preset value that is shown data, comprising configuration information has: display data item number, every page of display data item, every page show data group number, data transfinite marker color, data modification marker color etc., produce data item and show control;
(2) be configured file configuration, by the needed attribute configuration of data item, in configuration file, the attribute information of a data item of each line display, separate with special character so that handling procedure is used between the attribute of data item;
(3) fileinfo of configuration in (2) is read, difference becomes the needed community set of each data item, complete data simultaneously and read the SQL statement tissue, the data item that is assigned to the generation of configuration in (1) shows control, and the demonstration control of each data item is stored the configuration information of this data item;
(4) SQL statement produced according to (3), carry out data and read, and is placed on data result and concentrates;
(5) the data result collection (4) obtained is assigned to the set of (1) data item control, and the data item configuration information arranged according to (3) is adjusted data and shown, the limit check of data, the modification mark check of data and the settings such as display position of data;
As shown in Figure 1, the present invention has realized the conversion (being Text Mode, entity patterns, internal schema) of 3 patterns of data, utilize the conversion and inverse conversion (communicate by letter factor transformation and inverse transformation, demonstration factor transformation and inverse transformation) of 2 factors, realize the different data pattern under different conditions.
The present invention can realize that data transfinite and highlight, and data item is revised special demonstration, and if carry out data item while revising this data item configuration can not revise, do not allow the performance constraint of modifying.
The present invention can adjust the change of the display position of data item by revising configuration file, can change the inspection of data item validity.
The present invention can realize " modification " to viewdata, man-machine interface demonstration data are taken from viewdata, if revise this data item, by configuration file, comprise this data item from tables of data and field name, the data of modification can be written in field corresponding to table.
Fig. 2 is picture data item display packing, wherein, the information of the data source of each data item of configuration file stores, demonstration style and operating conditions thereof, picture has a control carrier that shows data and store configuration information, and database is the data source shown.Three parts that this figure illustrates that whole technology relates to and between the data flow relation.
As shown in Figure 3, be the process flow diagram of general many data item demonstration dynamic adjusting method one embodiment, wherein:
1. the user is in man-machine interface drag and drop datagroupview control setting;
2. read in configuration file configuration information and be organized into specific data structure, organizing the reading out data SQL statement;
The control that the set of data structures that 3. will 2. obtain arranges in being assigned to 1.;
4. the SQL statement of tissue in obtaining 2.;
5. go database read to fetch data and be organized into the data result collection;
The data result collection that 6. will 5. obtain is assigned to control 1.;
7. the user according to demand, arranges the edit properties of control 1., carries out the modification of data item data value;
8. after 7. completing the data modification submission, obtain the data item control of all modifications, and the SQL statement of tissue modification data;
9. the SQL statement obtained from 8., and carry out, the data of modification are submitted to database.
In the present embodiment, configuration file can be used the file storage or store in database table.
Datagroupview in the present embodiment is used other development languages to realize.
In the present embodiment, the data check of data item enumeration type is used the configuration file stores enumerated value to realize.
Application Example:
Use this technology in golden 1420 tandem mill projects in Hebei, the production material data have 278 data item, requiring data item to show can dynamically adjust, and meets specific data item simultaneously and shows with special style, and it is as follows that datagroupview control property and configuration file arrange specific descriptions:
(1) the datagroupview control property arranges, and AllRowsCount is set to 278, OneGroupRowCount and is set to 20, OnePageGroupCount and is set to 3, OneGroupColumnCount and is set to 3, PageCount and is set to 5.Arrange 5 also the page, every page has 3 groups, every group has 20, every comprises 3 subitems.The DataCheck setup of attribute is True, carries out data modification mark check, and IsColorChangetxtBox_E is set to True, the data special show tags of color that transfinites.
(2) profile information comprises: whether data item visual, table name claims, show field name, view field name, type, Chinese display field name, position number, field length, whether can edit, the information such as examination scope, scale-up factor whether, when loading each data item, the configuration file configuration information of corresponding item is set on corresponding control.
(3) at first the HMI application reads configuration file, method DynamicConfig.GetFileData by encapsulation (" .. app form primary.txt ") read all configuration informations, then configuration information integral body being converted to List<ItemsData > data structure of type is placed in variable i temsData, according to the view field name in configuration file, organize SQL statement to deposit variable sql_prim_e simultaneously, datagroupview attribute ItemsData is set, datagroupview.ItemsData=itemsData.
(4) the sql_prim_e statement obtained in (3) is removed to reading out data in database, in the DataTable mode, be stored in variable datas, DataSource attribute by the data source assignment to datagroupview, datagroupview.DataSource=datas.
The use of this technology completes through above-mentioned 4 steps exactly, and picture can show with configuration file and arranges and shown pattern that style is consistent.
Although content of the present invention has been done detailed introduction by above preferred embodiment, will be appreciated that above-mentioned description should not be considered to limitation of the present invention.After those skilled in the art have read foregoing, for multiple modification of the present invention with to substitute will be all apparent.Therefore, protection scope of the present invention should be limited to the appended claims.
Claims (9)
1. general many data item show dynamic adjusting method, it is characterized in that:
At first one personal-machine interface is provided, and number, correlation data item, the data item attribute setting of the data item by set and display, complete the ActiveX drafting that desired data item shows;
Then carry out the configuration of data item attribute file, pass through this document, the all full details that comprise attribute of data item are configured in configuration file, and the configuration information that configuration file comprises has meaning, type, display position, demonstration data length, tables of data, data sheet field, view name, view field name, operability, validity, demonstration bells and whistles of data item etc.;
Finally, the characteristic comprised by configuration file, shown data item and operated by man-machine interface.
2. general many data item according to claim 1 show dynamic adjusting method, and it is characterized in that: described method is carried out according to the following steps:
(1) preset value that shows data is set, produces data item and show control;
(2) be configured file configuration, by the needed attribute configuration of data item, in configuration file, the attribute information of a data item of each line display, separate with special character so that handling procedure is used between the attribute of data item;
(3) fileinfo of configuration in (2) is read, difference becomes the needed community set of each data item, complete data simultaneously and read the SQL statement tissue, be assigned to the data item that in (1), configuration produces and show control, the demonstration control of each data item is stored the configuration information of this data item;
(4) SQL statement produced according to (3), carry out data and read, and is placed on data result and concentrates;
(5) the data result collection (4) obtained is assigned to the set of (1) data item control, and the data item configuration information arranged according to (3) is adjusted data and shown, the limit check of data, the modification mark check of data and the display position setting of data.
3. general many data item according to claim 2 show dynamic adjusting method, it is characterized in that the described preset value that data are set, comprising configuration information has: display data item number, every page of display data item, every page show data group number, data transfinite marker color, data modification marker color.
4. show dynamic adjusting method according to the described general many data item of claim 1-3 any one, it is characterized in that: described data item to the step of its operation is:
1. data item control collection is set and revises marker bit, current all item status, according to the configuration information in configuration file, carry out the edit properties setting, if data item is set in configuration file, can not revise, this data item editing attribute can not editing mode, and other data item all can be edited;
2. after 1. arranging, the value of Update Table item, at first the new value of modification is marked as revises the status color mark, if this data item arranges validity check, if new value transfinites, this is labeled as the color tips that transfinites.Color mark also can arrange priority level;
3. after completing all data item occurrences and revising, submit data result to, according to the configuration information of storing, find table and corresponding literary name section under data item in the data item control, Data Update in database table.
5. general many data item according to claim 4 show dynamic adjusting method, it is characterized in that: the display position adjustment of described data, refer to: by the display position numbering of certain data item in direct modification configuration file, can directly adjust the position of data item in whole data show.
6. general many data item according to claim 1 and 2 show dynamic adjusting method, it is characterized in that: described method has realized the conversion of 3 patterns of data, be Text Mode, entity patterns, internal schema, the conversion that utilizes 2 factors and inverse conversion communicate by letter factor transformation and inverse transformation, show factor transformation and inverse transformation, realize the different data pattern under different conditions.
7. general many data item according to claim 1 and 2 show dynamic adjusting method, it is characterized in that: described method realizes that data transfinite and highlights, data item is revised special demonstration, if and carry out data item while revising this data item configuration can not revise, do not allow the performance constraint of modifying.
8. general many data item according to claim 1 and 2 show dynamic adjusting method, it is characterized in that: described method is adjusted the change of the display position of data item by revising configuration file, can change the inspection of data item validity.
9. general many data item according to claim 1 and 2 show dynamic adjusting method, it is characterized in that: described method realizes " modification " to viewdata, man-machine interface demonstration data are taken from viewdata, if revise this data item, by in configuration file, comprise this data item from tables of data and field name, the data of modification can be written in field corresponding to table.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201210189735.4A CN103488632A (en) | 2012-06-11 | 2012-06-11 | Universal dynamic adjustment method for multi-data-item display |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201210189735.4A CN103488632A (en) | 2012-06-11 | 2012-06-11 | Universal dynamic adjustment method for multi-data-item display |
Publications (1)
Publication Number | Publication Date |
---|---|
CN103488632A true CN103488632A (en) | 2014-01-01 |
Family
ID=49828874
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201210189735.4A Pending CN103488632A (en) | 2012-06-11 | 2012-06-11 | Universal dynamic adjustment method for multi-data-item display |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN103488632A (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105183301A (en) * | 2015-10-21 | 2015-12-23 | 浪潮(北京)电子信息产业有限公司 | User view attribute modifying method and device |
CN109766139A (en) * | 2018-12-13 | 2019-05-17 | 平安普惠企业管理有限公司 | The configuration method and device of configuration file |
CN109787957A (en) * | 2018-12-13 | 2019-05-21 | 平安普惠企业管理有限公司 | The configuration method and relevant apparatus of configuration file |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101692250A (en) * | 2009-08-31 | 2010-04-07 | 上海宝信软件股份有限公司 | Method for dynamically adjusting content and format of database data displayed on picture |
CN102467534A (en) * | 2010-11-12 | 2012-05-23 | 上海宝信软件股份有限公司 | Display method and display device for multi-field database |
-
2012
- 2012-06-11 CN CN201210189735.4A patent/CN103488632A/en active Pending
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101692250A (en) * | 2009-08-31 | 2010-04-07 | 上海宝信软件股份有限公司 | Method for dynamically adjusting content and format of database data displayed on picture |
CN102467534A (en) * | 2010-11-12 | 2012-05-23 | 上海宝信软件股份有限公司 | Display method and display device for multi-field database |
Non-Patent Citations (1)
Title |
---|
任小艳: "用户界面配置***的研究与实现", 《中国优秀硕士学位论文全文数据库 信息科技辑》, no. 04, 15 April 2008 (2008-04-15) * |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105183301A (en) * | 2015-10-21 | 2015-12-23 | 浪潮(北京)电子信息产业有限公司 | User view attribute modifying method and device |
CN105183301B (en) * | 2015-10-21 | 2019-01-22 | 浪潮(北京)电子信息产业有限公司 | A kind of User attribute modification method and apparatus |
CN109766139A (en) * | 2018-12-13 | 2019-05-17 | 平安普惠企业管理有限公司 | The configuration method and device of configuration file |
CN109787957A (en) * | 2018-12-13 | 2019-05-21 | 平安普惠企业管理有限公司 | The configuration method and relevant apparatus of configuration file |
CN109787957B (en) * | 2018-12-13 | 2023-02-10 | 平安普惠企业管理有限公司 | Configuration method of configuration file and related device |
CN109766139B (en) * | 2018-12-13 | 2023-02-14 | 平安普惠企业管理有限公司 | Configuration method and device of configuration file |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN106981089A (en) | A kind of generation method and detection method of three-dimensional values file | |
EP2915074A1 (en) | Automated report generation method | |
CN101196932B (en) | Method and device for establishing drawing data base | |
US6282539B1 (en) | Method and system for database publishing | |
CN103412868B (en) | Document generates method and device | |
CN102722616B (en) | Method for drawing exploration point plan based on Excel | |
EP2293160A1 (en) | Methods and apparatus for modifying process control data | |
CN106372044B (en) | A method of based on the typing dimension XBRL report of report generation | |
CN102087657B (en) | IO (Input/output) to point method and IO (Input/output) to point for nuclear power plant simulation platform | |
CN104572597A (en) | Automatic word analysis report generation method and device | |
CN104484419A (en) | Test case document conversion system and test case document conversion method | |
CN102110142A (en) | Method for dynamically expanding personnel transaction in human resource management information system | |
CN103761339A (en) | Electronic map making method based on basic geographic information data | |
CN104298705A (en) | Converting method of relational data and unstructured data | |
CN105279144A (en) | Method and device for typesetting wind tunnel test data text files | |
CN106610929A (en) | Method and device for typesetting digital publishing structured content file | |
US7197696B1 (en) | System, method and computer program product to populate data into spreadsheets and execute functions and programs within the same | |
CN106682879A (en) | Integrated design flow standard system | |
CN107451222A (en) | Model data management system | |
CN103488632A (en) | Universal dynamic adjustment method for multi-data-item display | |
CN106127863B (en) | A kind of refrigerator foaming die series design system and its method | |
CN105760370A (en) | Plug-in type report framework technology | |
CN103927402A (en) | Control logic diagram modular design management system implementation method | |
CN108595398A (en) | The method that artificial intelligence program substitutes person writing's simulation report | |
CN110502735B (en) | Method and system for quickly manufacturing universal process file of electronic equipment |
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: 20140101 |