CN103593456B - Worksheet self-defining method for designing and device - Google Patents
Worksheet self-defining method for designing and device Download PDFInfo
- Publication number
- CN103593456B CN103593456B CN201310597033.4A CN201310597033A CN103593456B CN 103593456 B CN103593456 B CN 103593456B CN 201310597033 A CN201310597033 A CN 201310597033A CN 103593456 B CN103593456 B CN 103593456B
- Authority
- CN
- China
- Prior art keywords
- list
- field
- typing
- template
- sublist
- 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.)
- Active
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/22—Indexing; Data structures therefor; Storage structures
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a kind of Worksheet self-defining method for designing and device, the fields such as technology business, achievements conversion are can be applied to, wherein method includes：It is unified to different types of list to carry out specification；According to different types of list specification, predefined typing form templat and given data are called, corresponding typing list is generated by template engine and form builder；Device includes：Specification module, for carrying out specification to different types of list is unified；List generation module, for according to different types of list specification, calling predefined typing form templat and given data, corresponding typing list is generated by template engine and form builder；By the present invention, development amount is greatly reduced, various change list is adapted to, maintenance work and cost greatly reduce.
Description
Technical field
The present invention relates to field of computer technology, more particularly to a kind of Worksheet self-defining method for designing and device.
Background technology
Different business has a different customization lists, and different lists has corresponding backstage code to realize and correspondingly
Database design.After the completion of the list typing of foreground, background program is submitted to, form data is saved in correspondence by background program
Database.
When list has become or form fields have increasing to change to delete or during newly-increased list, be required for the modification page, modification backstage
Code and modification database, cause set expandability and flexibility too poor, with the development of business, maintenance workload and cost meeting
It is very high.
The content of the invention
In view of above-mentioned analysis, the present invention is intended to provide a kind of Worksheet self-defining method for designing and device, existing to solve
The problem of having the autgmentability and too poor flexibility that form customization development mode is brought.
The purpose of the present invention is mainly achieved through the following technical solutions：
The invention provides a kind of Worksheet self-defining method for designing, including：
It is unified to different types of list to carry out specification；
According to different types of list specification, predefined typing form templat and given data are called, passes through mould
Plate engine and form builder generate corresponding typing list.
Further, the step of progress specification unified to different types of list is specifically included：
For the list of each type, the title of list and all fields of the list are defined
The list of each type is set respectively a main table and with the main one-to-one sublist of table, wherein, main table
For representing form types；Sublist is used for storing all fields and attribute of the form definition；
A list is set to deposit value table for all types of lists are unified, field and category for storing all types list
The value of property.
Further, the list is deposited value table and included：Essential information field and extended field, wherein extended field and sublist
The field correspondence of definition, when the field of certain in sublist is defined, selects list to deposit value according to the length for the field to be defined
The extended field of correspondence length is bound in table.
Further, methods described also includes：
When needing to modify to the typing list generated, download the typing list and carry out corresponding modification behaviour
Make, modification generates corresponding typing list after terminating again through template engine and form builder.
Further, methods described also includes：
Other functions template is generated based on typing form templat set in advance, the functional template and given data is called,
Corresponding function list is generated by template engine and form builder.
Wherein, the functional template at least includes checking in Page Template, examination ＆ verification Page Template and inquiry list template
It is one or more, then generate corresponding function list be check the page, examination ＆ verification the page and inquiry list in one or many
It is individual.
Further, methods described is applied to technology business or achievements conversion field.
Device is designed present invention also offers a kind of Worksheet self-defining, including：
Specification module, for carrying out specification to different types of list is unified；
List generation module, for according to different types of list specification, calling predefined typing form templat
And given data, corresponding typing list is generated by template engine and form builder.
Further, the definition module is specifically for selecting the form types to be generated, formulating the title of list；It is right
In the list of each type, the attribute of each field in list is defined；One main table is set respectively to the list of each type
And with the main one-to-one sublist of table, wherein, main table be used for represent form types；Sublist is used for storing the form definition
All fields and its attribute；And set a list to deposit value table for all types of lists are unified, for storing all types
The field of list and the value of attribute.
Further, the list is deposited value table and included：Essential information field and extended field, wherein extended field and sublist
The field correspondence of definition, when the field of certain in sublist is defined, selects list to deposit value according to the length for the field to be defined
The extended field of correspondence length is bound in table.
Further, described device also includes：
Edit-modify module, for when needing to modify to the typing list generated, downloading the typing list simultaneously
Corresponding modification operation is carried out, modification generates corresponding typing list after terminating again through template engine and form builder.
Further, methods described is applied to technology business or achievements conversion field.
The present invention has the beneficial effect that：
By the present invention, development amount is greatly reduced, various change list is adapted to, maintenance work and cost subtract significantly
It is few.
Other features and advantages of the present invention will be illustrated in the following description, also, the partial change from specification
Obtain it is clear that or being understood by implementing the present invention.The purpose of the present invention and other advantages can be by the explanations write
Specifically noted structure is realized and obtained in book, claims and accompanying drawing.
Brief description of the drawings
Fig. 1 is the schematic flow sheet of embodiment of the present invention methods described；
Fig. 2 is the schematic diagram for setting form name；
Fig. 3 is setting form fields title and the schematic diagram of attribute；
Fig. 4 is the schematic diagram of main table；
Fig. 5 is the schematic diagram of sublist；
Fig. 6 is the schematic diagram of list storage table；
Fig. 7 is the structural representation of embodiment of the present invention described device.
Embodiment
The preferred embodiments of the present invention are specifically described below in conjunction with the accompanying drawings, wherein, accompanying drawing constitutes the application part, and
It is used for the principle for explaining the present invention together with embodiments of the present invention.
It is described in detail first with reference to 1 to 6 pairs of embodiment of the present invention methods describeds of accompanying drawing.
As shown in figure 1, Fig. 1 is the schematic flow sheet of embodiment of the present invention methods described, specifically it may include steps of：
Step 101：To different types of list, form name is defined；
The form types to be generated are selected, the Chinese and English name of list is formulated, follow-up English name can be made
For the title of list, such as shown in Fig. 2；Here, depending on so-called form types are mainly according to type of service, for example, of the invention
There can be 5 kinds of different lists in embodiment, be financing information disclosure table, trade mark Transaction Information disclosure table, copyright information respectively
Disclose table, new product information and disclose table, patent technology information disclosure table；
Step 102：For the list of each type, the title and attribute of all fields in the list are defined；Wherein, often
Individual field can define different attributes, and so-called attribute can be：Field type, storage corresponding field, order of the field, leading portion text
Word, rear end word, whether show etc., attribute can select list deposit corresponding storage word in value table according to the length of field
Section, such as shown in Fig. 3；
Step 103：According to the definition of above-mentioned form name and its all fields, generate main table, sublist and list and deposit value
Table；
Wherein, as shown in Fig. 4 to Fig. 6, Fig. 4 to Fig. 6 is the schematic diagram that main table, sublist and list deposit value table respectively, main
Table and sublist are corresponded, i.e. the list for a certain type, should configure a main table and a corresponding sublist, main table is table
Single type list, can extend polytype；Sublist is the field and its attribute for storing form definition；List deposits value table and there was only one
, for storing the field of all types list and its value of attribute, value table is deposited in addition to several essential information fields, is also extended
It is multiple（Such as 100）Field, all field types are all character strings, the length of field has 100,200,300,500,
1000th, 2000, clog etc., wherein, extended field can apply to all different lists, i.e., without specific when extended field is initial
Business implication, its business implication depends on the field and attribute above in customizing form, when being defined to certain field,
List can be selected to deposit the extended field of correspondence length in value table as storage field, now, list according to the length of the field
All fields and list deposit value table between establish corresponding relation.
Step 104：According to different types of list specification, predefined typing form templat and datum are called
According to passing through template engine and form builder and generate corresponding typing list；Wherein, template engine and form builder can be adopted
Slightly improved with existing ripe scheme in the prior art, here is omitted；
Step 105：When the typing list generated to some is modified, corresponding original list can be downloaded；
Step 106：The modifications such as field, increase field are added to the original list；
Step 107：Corresponding typing form templat is called after having changed again, is given birth to by template engine and form builder
Into final typing list.
Based on typing form templat, more templates can also be pre-defined, such as：Check Page Template, examination ＆ verification page mould
After the completion of plate and inquiry list template, customizing form, system can be according in the template generation operation system being previously set
Each list, such as check the page, the examination ＆ verification page, inquiry list etc..The letter shown in the information list of the operation system of generation
Whether breath, is set in customizing form attribute, such as " querying condition " in Fig. 3, if whether list display
Middle selection is, then is that this field will be automatically displayed in inquiry list in generation inquiry list.
Next, embodiment of the present invention described device is described in detail with reference to accompanying drawing 7.
As shown in fig. 7, Fig. 7 is the structural representation of embodiment of the present invention described device, it can specifically include：
Specification module 701, for carrying out specification to different types of list is unified；
List generation module 702, for according to different types of list specification, calling predefined typing list mould
Plate and given data, corresponding typing list is generated by template engine and form builder.
Wherein, above-mentioned specification module is specifically for selecting the form types to be generated, formulating the title of list；It is right
In the list of each type, the attribute of each field in list is defined；One main table is set respectively to the list of each type
And with the main one-to-one sublist of table, wherein, main table be used for represent form types；Sublist is used for storing the word of form definition
Section and its attribute；And set a list to deposit value table for all types of lists are unified, for storing all types list
Field and property value.Field in list includes：Essential information field and extended field, extended field can apply to it is all not
Same list, i.e., without specific business implication when extended field is initial, its business implication is depended in above customizing form
Field and attribute, when being defined to certain field, can select list to deposit correspondence length in value table according to the length of the field
Extended field as storage field, now, all fields and list of list establish corresponding relation between depositing value table.
As optional functional module, embodiment of the present invention described device also includes：
Edit-modify module 703, for when needing to modify to the typing list generated, downloading the typing list
And corresponding modification operation is carried out, modification generates corresponding typing table after terminating again through template engine and form builder
It is single.
In summary, the embodiments of the invention provide a kind of list generation method and system, can be applied to technology business, into
The fields such as fruit conversion, have the following advantages that：
The list of all generations, backstage is all to share same set of code and database to interact, and how no matter list become
Change, backstage code need not all change, and database is also without change；Development amount is greatly reduced, various change is adapted to
List, maintenance work and cost greatly reduce；The form information being defined all is stored in a list and deposited in value table table, table
The field of value table is singly deposited without specific business implication, when defining form fields, and list is deposited the storage field of value table and tied up
It is fixed；There is general interface, be adapted to and various types of operation systems, it is only necessary to which making by oneself for list can be achieved with by interface interchange
Adopted function；List can be defined flexibly, without worrying to influence in the case that list is indefinite in operation system or list often changes
The maintenance work of system design and increase from now on.
The foregoing is intended to be a preferred embodiment of the present invention, but protection scope of the present invention is not limited thereto,
Any one skilled in the art the invention discloses technical scope in, the change or replacement that can be readily occurred in,
It should all be included within the scope of the present invention.Therefore, protection scope of the present invention should be with the protection model of claims
Enclose and be defined.
Claims (8)
1. a kind of Worksheet self-defining method for designing, it is characterised in that including：
It is unified to different types of list to carry out specification；
According to different types of list specification, predefined typing form templat and given data are called, is drawn by template
Hold up and generate corresponding typing list with form builder；
Wherein, the step of progress specification unified to different types of list is specifically included：
For the list of each type, the title of list and all fields of the list are defined；
The list of each type is set respectively a main table and with the main one-to-one sublist of table, wherein, main table is used for
Represent form types；Sublist is used for storing all fields and attribute of the form definition；
For all types of lists are unified a list is set to deposit value table, field and attribute for storing all types list
Value；The list, which deposits value table, to be included：The field pair that essential information field and extended field, wherein extended field are defined with sublist
Should, when the field of certain in sublist is defined, select list to deposit correspondence length in value table according to the length for the field to be defined
Extended field bound；Corresponding relation is set up between all fields and list storage value table of list.
2. according to the method described in claim 1, it is characterised in that methods described also includes：
When needing to modify to the typing list generated, corresponding original list is downloaded, and original list is repaiied
Change operation, modification generates final typing list after terminating again through template engine and form builder.
3. method according to claim 1 or 2, it is characterised in that methods described also includes：
Other functions template is generated based on typing form templat set in advance, the functional template and given data is called, passes through
Template engine and form builder generate corresponding function list.
4. method according to claim 3, it is characterised in that the functional template at least includes checking Page Template, examined
One or more of core Page Template and inquiry list template, then generate corresponding function list to check the page, examination ＆ verification
One or more of the page and inquiry list.
5. method according to claim 1 or 2, it is characterised in that methods described is applied to technology business or achievements conversion
Field.
6. a kind of Worksheet self-defining designs device, it is characterised in that including：
Specification module, for carrying out specification to different types of list is unified；
List generation module, for according to different types of list specification, calling predefined typing form templat and
Primary data, corresponding typing list is generated by template engine and form builder；Wherein, the definition module specifically for,
The form types to be generated are selected, the title of list is formulated；For the list of each type, each field in list is defined
Attribute；The list of each type is set respectively a main table and with the main one-to-one sublist of table, wherein, main table is used for
Represent form types；Sublist is used for storing all fields and its attribute of the form definition；And be all types of lists system
One one list of setting deposits value table, for storing the field of all types list and the value of attribute；
The list, which deposits value table, to be included：The field pair that essential information field and extended field, wherein extended field are defined with sublist
Should, when the field of certain in sublist is defined, select list to deposit correspondence length in value table according to the length for the field to be defined
Extended field bound；Corresponding relation is set up between all fields and list storage value table of list.
7. device according to claim 6, it is characterised in that
Described device also includes：
Edit-modify module, for when needing to modify to the typing list generated, downloading original list, and to original
List is modified operation, and modification generates corresponding typing list after terminating again through template engine and form builder.
8. the device according to claim 6 or 7, it is characterised in that described device is applied to technology business or achievements conversion
Field.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310597033.4A CN103593456B (en) | 2013-11-22 | 2013-11-22 | Worksheet self-defining method for designing and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310597033.4A CN103593456B (en) | 2013-11-22 | 2013-11-22 | Worksheet self-defining method for designing and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103593456A CN103593456A (en) | 2014-02-19 |
| CN103593456B true CN103593456B (en) | 2017-07-14 |
Family
ID=50083597
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310597033.4A Active CN103593456B (en) | 2013-11-22 | 2013-11-22 | Worksheet self-defining method for designing and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103593456B (en) |
Families Citing this family (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104407853A (en) * | 2014-11-06 | 2015-03-11 | 国云科技股份有限公司 | Method for realizing TABLE multi-line simultaneous edition |
| JP6433339B2 (en) | 2015-03-02 | 2018-12-05 | キヤノン株式会社 | Information processing system, server device, control method, and program |
| CN105956033A (en) * | 2016-04-25 | 2016-09-21 | 乐视控股（北京）有限公司 | Plate form generation method and apparatus |
| CN106598924A (en) * | 2016-10-28 | 2017-04-26 | 深圳前海微众银行股份有限公司 | Form generation method and device |
| CN106779490A (en) * | 2017-01-19 | 2017-05-31 | 北京恒华伟业科技股份有限公司 | A kind of Expressway Road maintenance failure management method, apparatus and system |
| CN106803126A (en) * | 2017-01-19 | 2017-06-06 | 北京恒华伟业科技股份有限公司 | A kind of Expressway Road maintenance failure management method, apparatus and system |
| CN107423061A (en) * | 2017-07-12 | 2017-12-01 | 江苏速度信息科技股份有限公司 | A kind of list generation method based on ISON data |
| CN108898519A (en) * | 2018-06-05 | 2018-11-27 | 上海速云信息科技有限公司 | One kind is in line platform teaching methods |
| CN111027299A (en) * | 2019-10-18 | 2020-04-17 | 深圳智慧园区信息技术有限公司 | Form generation method and system |
| CN114578961B (en) * | 2022-01-15 | 2023-06-02 | 广东睿盟计算机科技有限公司 | Automatic data input system based on action recording |
| CN114579112B (en) * | 2022-02-25 | 2023-10-20 | 北京圣博润高新技术股份有限公司 | Method, device, equipment and storage medium for assisting system development |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101241434A (en) * | 2008-03-04 | 2008-08-13 | 浪潮集团山东通用软件有限公司 | Form self-defining method |
| CN102779040A (en) * | 2012-06-21 | 2012-11-14 | 东莞市微模式软件有限公司 | Method and device for generating user-defined form |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| AUPO863697A0 (en) * | 1997-08-15 | 1997-09-11 | OLIVER, Brian Keith | A computerised method of compiling reports |
| US6976029B2 (en) * | 2004-02-10 | 2005-12-13 | Microsoft Corporation | System and method for providing user defined types in a database system |
-
2013
- 2013-11-22 CN CN201310597033.4A patent/CN103593456B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101241434A (en) * | 2008-03-04 | 2008-08-13 | 浪潮集团山东通用软件有限公司 | Form self-defining method |
| CN102779040A (en) * | 2012-06-21 | 2012-11-14 | 东莞市微模式软件有限公司 | Method and device for generating user-defined form |
Non-Patent Citations (1)
| Title |
|---|
| 通用调查问卷数据采集系统设计;齐丹丹等;《中国期刊全文数据库 计算机与信息技术》;20071231(第31期);第87页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103593456A (en) | 2014-02-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103593456B (en) | Worksheet self-defining method for designing and device | |
| AU2019246901B2 (en) | Graphical user interface that simplifies user creation of custom calculations for data visualizations | |
| US7289976B2 (en) | Easy-to-use data report specification | |
| US11100059B2 (en) | Construction of database schema models for database systems and rest APIs | |
| CN102779040B (en) | A kind of method and apparatus generating customizing form | |
| CN108153897B (en) | PLSQL program code generation method and system | |
| CN107273122A (en) | Based on decoupling mechanism can iteration set up operation system method and its terminal | |
| CN103617047A (en) | Method, device and processor for developing business processes | |
| CN106407170A (en) | Rapid generation method and system for data report | |
| CN104063495A (en) | Form extension method and form extension device | |
| CN109669693A (en) | A kind of method and system generating forms pages based on dynamic page | |
| CN110543303A (en) | Visual business platform | |
| CN106407172A (en) | XML (Extensible Markup Language)-based report generating method | |
| CN105912723B (en) | A kind of storage method of custom field | |
| CN107766519B (en) | Method for visually configuring data structure | |
| JP2018018323A (en) | Distributed processing management method, distributed processing management program, and distributed processing management device | |
| CN101436127A (en) | Method and apparatus for selecting date | |
| KR102499832B1 (en) | An online report creation system with query binding function | |
| CN101788977A (en) | Method for implementing editing and modifying of medical examination report | |
| CN102708206A (en) | Data format description method | |
| GB2458692A (en) | A process for generating database-backed, web-based documents | |
| JP6251860B2 (en) | Information management apparatus and file management method | |
| CN108073395A (en) | A kind of production programmed method | |
| CN110597491B (en) | Method for quickly constructing different service systems | |
| US20110029950A1 (en) | Computer-readable media, methods and computer systems for designing a software application graphically |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |