CN1430162A - Electronic forms editing method and system - Google Patents
Electronic forms editing method and system Download PDFInfo
- Publication number
- CN1430162A CN1430162A CN 01145082 CN01145082A CN1430162A CN 1430162 A CN1430162 A CN 1430162A CN 01145082 CN01145082 CN 01145082 CN 01145082 A CN01145082 A CN 01145082A CN 1430162 A CN1430162 A CN 1430162A
- Authority
- CN
- China
- Prior art keywords
- list
- field
- distinguished symbol
- distinguished
- area
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
A method and system for editing electronic forms is disclosed. Said method includes such steps as choosing a form ID, expressing its column, information by at least one column ID, loading it in form style area to automatically create the form style, and generating relative column information and electronic form. Its advantage is easy document change and columns and modification.
Description
Technical field
The present invention relates to a kind of electronic forms editing method and system, particularly do not need the webpage making instrument and utilize data bank field and electronic spreadsheet directly corresponding and the electronic forms editing method and the system of generation electronic spreadsheet about a kind of.
Background technology
Along with popularizing of Internet, traditional data bank design and access have had the trend that mutually combines with Internet, thus provide the different users by Internet from different position access data bank.In the design of known Web page electric list, use the webpage making instrument to edit usually.With the electronic spreadsheet that webpage making instrument editor forms, in the storage at the data bank data, data must can be stored to data bank through the conversion of some necessity, also or with the archives pattern of disperseing exists.
In addition, because the electronic spreadsheet that forms with webpage making instrument editor is a fixing procedure code, in case main shortcoming is the data field to some extent during unusual fluctuation, the converse routine of system's list and data bank must redesign and write in the lump.
Summary of the invention
In view of this, fundamental purpose of the present invention can not need the webpage making instrument and utilize direct corresponding electronic forms editing method and the system that produces electronic spreadsheet of data bank field and electronic spreadsheet for providing a kind of.
In order to reach above-mentioned purpose, technical scheme of the present invention is achieved in that
A kind of electronic forms editing method at first, by the list distinguished symbol of choosing expression one list in a plurality of list distinguished symbols, then, is at least one field distinguished symbol with the field information representation of the list distinguished symbol chosen.Then, place the field distinguished symbol in a list pattern district, thereby produce the list pattern of corresponding field distinguished symbol automatically.At last, according to field distinguished symbol in the list pattern district and list pattern, produce corresponding field information and the electronic spreadsheet of choosing list.
A kenel of the present invention more is expressed as the list distinguished symbol respectively automatically with a plurality of lists in the data bank.
In above-mentioned edit methods, this list pattern district comprises a first area and a second area, when placing this field distinguished symbol respectively in this first area and this second area, produce mutually should the field distinguished symbol different list patterns.
Another kenel of the present invention is more set up electronic spreadsheet and is chosen related between list.
Another kenel of the present invention, more by the second list distinguished symbol of choosing expression one second list in the list distinguished symbol, and the second field information representation of the second list distinguished symbol that will choose is at least one second field distinguished symbol, and, set up and to choose interdependent related between list and second list according to the field distinguished symbol and the second field distinguished symbol.
A kind of electronic forms editing system, comprise a data bank grid column list area, operation list district, list pattern district, and electronic spreadsheet generate module.
Data bank grid column list area is in order to be expressed as a plurality of list distinguished symbols respectively with a plurality of lists in the data bank automatically.Operation list district will be in order to will being at least one field distinguished symbol by the field information representation of the list distinguished symbol of selected expression one list in the list distinguished symbol.List pattern district is then in order to the list pattern of corresponding this field distinguished symbol of automatic generation.
Electronic spreadsheet generates module according to field distinguished symbol in the list pattern district and list pattern, produces corresponding to field information and the electronic spreadsheet of choosing list.
In the above-mentioned editing system, this list pattern district comprises a first area and a second area, this first area with/or this second area can produce mutually should the field distinguished symbol different list patterns.
A kenel of the present invention, electronic spreadsheet generate module and more set up electronic spreadsheet and choose related between list.
Another kenel of the present invention, operation list district will be at least one second field distinguished symbol by the second field information representation of the second list distinguished symbol of choosing expression one second list in the list distinguished symbol more.And electronic spreadsheet generates module more according to field distinguished symbol and the second field distinguished symbol in the operation list district, and interdependent related between list and second list chosen in foundation.
Electronic forms editing method of the present invention and system, can set up electronic spreadsheet not needing to use under the situation of webpage making instrument in mode intuitively, owing to direct corresponding generation of data bank field and electronic spreadsheet adopted in the design of list, so the specification of list is consistent with the storing mode of data.When data change or the modification of list field, the conversion of effectively minimizing data or the inconvenience of redesign list.
Description of drawings
Fig. 1 is a synoptic diagram, and expression is according to the system architecture of the electronic forms editing system of the embodiment of the invention;
Fig. 2 is a computer synoptic diagram, and expression is according to the relevant configuration in data bank grid column list area, operation list district and the list pattern district of the embodiment of the invention;
How Fig. 3 produces the computer synoptic diagram of the list pattern of corresponding field distinguished symbol for expression list pattern district;
Fig. 4 chooses the computer synoptic diagram of two list distinguished symbols for expression;
Fig. 5 is a computer synoptic diagram, represents an electronic spreadsheet example;
Fig. 6 is a process flow diagram, and expression is according to the operating process of the electronic forms editing method of the embodiment of the invention.
Symbol description:
1 data bank;
2,20 data bank grid column list areas;
3,30 operation list districts;
4,40 list pattern districts;
5 selecting devices;
6 show module;
7 electronic spreadsheets generate module;
21 list distinguished symbols;
31 field distinguished symbols;
41 list patterns;
50 electronic spreadsheets;
S61, S62 ..., the S66 operation steps.
Embodiment
For purpose of the present invention, characteristic and advantage are become apparent more, below especially exemplified by embodiment, and conjunction with figs. is described in further detail.
Fig. 1 represents the system architecture according to the electronic forms editing system of the embodiment of the invention, and Fig. 2 represents the computer synoptic diagram of the relevant configuration in data bank grid column list area 20, operation list district 30 and list pattern district 40 according to the embodiment of the invention.With reference to figure 1 and Fig. 2, the system architecture of the embodiment of the invention will be illustrated in down simultaneously.
According to the electronic forms editing system of the embodiment of the invention, comprise a data bank 1, data bank grid column list area 20 (symbol is 2 among Fig. 1), operation list district 30 (symbol is 3 among Fig. 1), list pattern district 40 (symbol is 4 among Fig. 1), selecting device 5, show that module 6 and electronic spreadsheet generate module 7.
Can store a plurality of different list (not shown)s in the data bank 1, the usefulness that these lists can provide the electronic spreadsheet in the webpage to carry out access.Data bank grid column list area 20 can self-verifying data bank 1, and with all lists in the data bank 1 respectively individual tables be shown a list distinguished symbol 21 (or object).
Can be at least one field distinguished symbol 31 by the field information representation of 21 corresponding lists of list distinguished symbol selected in the list distinguished symbol 21 shown in the data bank grid column list area 20 with the user in the operation list district 30.Wherein, field information is all field titles that comprised in the list, and each field has a corresponding field distinguished symbol 31.
List pattern district 40 can be used for producing automatically the list pattern 41 of corresponding field distinguished symbol 31.With reference to figure 3, list pattern district 40 can divide into different regional location (zone 1 and zone 2), when the user will operate field distinguished symbol 31 in the list district 30 and tow to different regional locations, list pattern district 40 can produce the list pattern 41 of the different kenels of corresponding this field distinguished symbol 31.
Selecting device 5 is used to provide the user and chooses or/and the usefulness of towing list distinguished symbol 21 or/and field distinguished symbol 31.Show 6 of modules can with data bank grid column list area 20, operation list district 30, and list pattern district 40 show configuration as shown in Figure 2.
Electronic spreadsheet generates module 7 (not showing among Fig. 2) can be according to field distinguished symbol in the list pattern district 40 31 and list pattern 41, generation is corresponding to the electronic spreadsheet 50 of field information and selected list, as shown in Figure 5, and set up electronic spreadsheet and choose related between list, wherein, this association is meant the corresponding relation between the list and field in all fields, form and the data bank of electronic spreadsheet.
What note is, because an electronic spreadsheet perhaps can be referenced to more than one list, therefore, with reference to figure 4, operation list district 30 can be at least one field distinguished symbol 31 by the field information representation of 21 corresponding another lists of another list distinguished symbol selected in the list distinguished symbol 21 shown in the data bank grid column list area 20 with the user more.And electronic spreadsheet generate module 7 more can be according to the identical field distinguished symbol (identical field title) in the operation list district 30, set up and choose interdependent related between list and second list, soon this field title is set at external key (reference key).
Next, Fig. 6 represents the operating process according to the electronic forms editing method of the embodiment of the invention, and simultaneously with reference to figure 2 and Fig. 6, the operating process of the embodiment of the invention will be described as follows.
At first, as step S61, all lists in the data bank 1 are expressed as list distinguished symbol 21 respectively in data bank grid column list area 20.Afterwards, as step S62, by the list distinguished symbol 21 of choosing expression one list in these list distinguished symbols 21.Then, as step S63, be that field distinguished symbol 31 is in operation list district 30 with the field information representation of choosing 21 corresponding lists of list distinguished symbol.
Then,, place field distinguished symbol 31 in list pattern district 40, thereby produce the list pattern 41 of corresponding this field distinguished symbol 31 automatically as step S64.At last, as step S65, electronic spreadsheet generates module 7 according to field distinguished symbol in the list pattern district 40 31 and list pattern 41, produces the electronic spreadsheet corresponding to field information and selected list, and, set up electronic spreadsheet and choose related between list as step S66.
Identical, when electronic spreadsheet is referenced to more than one list, then more can be by choosing another list distinguished symbol 21 in the list distinguished symbol 21 shown in the data bank grid column list area 20, and be that field distinguished symbol 31 is in operation list district 30 with the field information representation of 21 corresponding another lists of list distinguished symbol of choosing, and can set up the interdependent association between two lists according to the identical field distinguished symbol 31 of corresponding two lists of difference.
Therefore, by electronic forms editing method proposed by the invention and system, the user can set up electronic spreadsheet not needing to use under the situation of webpage making instrument in mode intuitively, in addition, owing to direct corresponding generation of data bank field and electronic spreadsheet adopted in the design of list, so the specification of list is consistent with the storing mode of data.When data change or the modification of list field, can effectively lower the time that the user is engaged in data conversion or redesign list.
Though the present invention with the preferred embodiment explanation as above; right its is not in order to qualification the present invention, any those who are familiar with this art, without departing from the spirit and scope of the present invention; when can doing a little change and retouching, so protection scope of the present invention is when with being as the criterion that claims were defined.
Claims (12)
1. electronic forms editing method, it is characterized in that: this method comprises the following steps:
By a list distinguished symbol of choosing expression one list in the plural list distinguished symbol;
With this field information representation of choosing the list distinguished symbol is at least one field distinguished symbol;
Place this field distinguished symbol in a list pattern district, thus automatically produce mutually should the field distinguished symbol a list pattern; And
According to this field distinguished symbol in this list pattern district and this list pattern, produce mutually should field information and this choose an electronic spreadsheet of list.
2. the method for claim 1 is characterized in that: more comprise the plural list in the data bank is expressed as these list distinguished symbols respectively.
3. the method for claim 1, it is characterized in that: wherein this list pattern district comprises a first area and a second area.
4. method as claimed in claim 3 is characterized in that: when placing this field distinguished symbol respectively in this first area and this second area, produce mutually should the field distinguished symbol different list patterns.
5. the method for claim 1 is characterized in that: comprise that more setting up this electronic spreadsheet chooses related between list with this.
6. the method for claim 1 is characterized in that: more comprise the following steps:
By the one second list distinguished symbol of choosing expression one second list in these list distinguished symbols;
With this one second field information representation of choosing the second list distinguished symbol is at least one second field distinguished symbol; And
According to this field distinguished symbol and this second field distinguished symbol, set up this and choose interdependent related between list and this second list.
7. electronic forms editing system, it is characterized in that: this system comprises:
One data bank grid column list area is in order to be expressed as plural list distinguished symbol respectively with the plural list in the data bank;
One operation list district will be in order to will being at least one field distinguished symbol by a field information representation of a list distinguished symbol of selected expression one list in these list distinguished symbols;
One list pattern district, in order to automatic generation mutually should the field distinguished symbol a list pattern; And
One electronic spreadsheet generates module, in order to according to this field distinguished symbol in this list pattern district and this list pattern, produce phase should field information and this choose an electronic spreadsheet of list.
8. system as claimed in claim 7 is characterized in that: wherein this list pattern district comprises a first area and a second area.
9. system as claimed in claim 8 is characterized in that: wherein this first area with/or this second area can produce mutually should the field distinguished symbol different list patterns.
10. system as claimed in claim 7 is characterized in that: wherein this electronic spreadsheet generates module and more sets up this electronic spreadsheet and choose related between list with this.
11. system as claimed in claim 7 is characterized in that: wherein this operation list district comprises that more with one second field information representation by the one second list distinguished symbol of choosing expression one second list in these list distinguished symbols be at least one second field distinguished symbol.
12. system as claimed in claim 11 is characterized in that: wherein this electronic spreadsheet generates module more according to this field distinguished symbol in this operation list district and this second field distinguished symbol, sets up this and chooses interdependent related between list and this second list.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 01145082 CN1430162A (en) | 2001-12-29 | 2001-12-29 | Electronic forms editing method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 01145082 CN1430162A (en) | 2001-12-29 | 2001-12-29 | Electronic forms editing method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN1430162A true CN1430162A (en) | 2003-07-16 |
Family
ID=4678004
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 01145082 Pending CN1430162A (en) | 2001-12-29 | 2001-12-29 | Electronic forms editing method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1430162A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101609463B (en) * | 2009-08-04 | 2011-04-20 | 北京环太中科软件股份有限公司 | Method for establishing data conversion relation among notes and method for data migration among notes |
| CN101661512B (en) * | 2009-09-25 | 2012-01-11 | 万斌 | System and method for identifying traditional form information and establishing corresponding Web form |
| CN102402573A (en) * | 2010-09-13 | 2012-04-04 | 株式会社理光 | Form processing apparatus, form processing method |
| CN105631103A (en) * | 2015-12-24 | 2016-06-01 | 北京汽车研究总院有限公司 | Method and system for multi-body model form control |
| CN107357913A (en) * | 2017-07-19 | 2017-11-17 | 微鲸科技有限公司 | Multiple terminals collaboration list filling method and for realizing its terminal |
| CN108959361A (en) * | 2018-05-17 | 2018-12-07 | 腾讯音乐娱乐科技（深圳）有限公司 | The method and apparatus of list management |
-
2001
- 2001-12-29 CN CN 01145082 patent/CN1430162A/en active Pending
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101609463B (en) * | 2009-08-04 | 2011-04-20 | 北京环太中科软件股份有限公司 | Method for establishing data conversion relation among notes and method for data migration among notes |
| CN101661512B (en) * | 2009-09-25 | 2012-01-11 | 万斌 | System and method for identifying traditional form information and establishing corresponding Web form |
| CN102402573A (en) * | 2010-09-13 | 2012-04-04 | 株式会社理光 | Form processing apparatus, form processing method |
| CN102402573B (en) * | 2010-09-13 | 2013-12-25 | 株式会社理光 | Form processing apparatus and form processing method |
| CN105631103A (en) * | 2015-12-24 | 2016-06-01 | 北京汽车研究总院有限公司 | Method and system for multi-body model form control |
| CN105631103B (en) * | 2015-12-24 | 2018-12-21 | 北京汽车研究总院有限公司 | A kind of method and system of Multi-body model listization control |
| CN107357913A (en) * | 2017-07-19 | 2017-11-17 | 微鲸科技有限公司 | Multiple terminals collaboration list filling method and for realizing its terminal |
| CN108959361A (en) * | 2018-05-17 | 2018-12-07 | 腾讯音乐娱乐科技（深圳）有限公司 | The method and apparatus of list management |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Chen et al. | D (k)-index: An adaptive structural summary for graph-structured data | |
| CN101339538B (en) | Data tree storage methods, systems and computer program products using page structure | |
| Zezula et al. | Dynamic partitioning of signature files | |
| Weber et al. | An approximation based data structure for similarity search | |
| CN1254879A (en) | Back-and-forth method and device for software design | |
| CN1867911A (en) | Promotion and demotion techniques to facilitate file property management between object systems | |
| CN1904901A (en) | System and method for actualizing content-based file system security | |
| CN1695117A (en) | Method for generating interpretable code for storage in a device having limited storage | |
| CN1094218C (en) | Data serching device | |
| CN1430162A (en) | Electronic forms editing method and system | |
| CN102495730A (en) | Dynamic and extendable web interface method | |
| CN1265558C (en) | A schematic diagram inspection method for hardware design | |
| CN102254023A (en) | Method and device for editing webpage | |
| CN1300992A (en) | Computer aided design supporting system for separate arrangement units | |
| CN1427357A (en) | Method for inputting characters in portable apparatus and portable apparatus using this method | |
| Roumelis et al. | Bulk-loading and bulk-insertion algorithms for xBR^+-trees xBR+-trees in Solid State Drives | |
| CN101034416A (en) | Method for file seek track using file allocation table and system frame thereof | |
| CN1949173A (en) | Software assembling method and apparatus thereof | |
| CN102013265A (en) | Device and method for parsing lyrics and synchronously playing lyrics and song | |
| CN101059758A (en) | Screen transition program generating method and device | |
| CN1627272A (en) | Method for managing files in flash memory of mobile terminal | |
| Vyas et al. | The Simplest XML Storage Manager Ever. | |
| CN1690983A (en) | System and method for writing data in flash memory sequentially | |
| CN1570919A (en) | Method for creating, immigrating, emigrating and deleting file | |
| CN1132115C (en) | Dynamic quick index establishing method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |