CN102779040A - Method and device for generating user-defined form - Google Patents

Method and device for generating user-defined form Download PDF

Info

Publication number
CN102779040A
CN102779040A CN2012102092757A CN201210209275A CN102779040A CN 102779040 A CN102779040 A CN 102779040A CN 2012102092757 A CN2012102092757 A CN 2012102092757A CN 201210209275 A CN201210209275 A CN 201210209275A CN 102779040 A CN102779040 A CN 102779040A
Authority
CN
China
Prior art keywords
field
list
information
field type
information table
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.)
Granted
Application number
CN2012102092757A
Other languages
Chinese (zh)
Other versions
CN102779040B (en
Inventor
陈友斌
邝炜宗
钱李明
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
GUANGDONG MICROPATTERN SOFTWARE CO., LTD.
Original Assignee
DONGGUAN MICROPATTERN Corp
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by DONGGUAN MICROPATTERN Corp filed Critical DONGGUAN MICROPATTERN Corp
Priority to CN201210209275.7A priority Critical patent/CN102779040B/en
Publication of CN102779040A publication Critical patent/CN102779040A/en
Application granted granted Critical
Publication of CN102779040B publication Critical patent/CN102779040B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a method and a device for generating a user-defined form. The method comprises newly building form formwork information which comprises a form information sheet, a field information sheet, a form field information sheet, a field type information sheet and a field type subitem information sheet, setting the form information sheet and creating field information sheet with the form containing fields to obtain the form formwork information according to user definition, and generating and displaying the user-defined form according to the form formwork information. The method and the device achieve data integration by setting different data forms, and greatly expand application scope and flexibility of the form.

Description

A kind of method and apparatus that generates self-defined list
Technical field
The present invention relates to the Computer Applied Technology field, be specifically related to a kind of method and apparatus that generates self-defined list.
Background technology
Electronic spreadsheet (register) substitutes traditional paper register book gradually and is widely used in the business event operation.According to the difference of business demand, electronic spreadsheet demonstrates different forms.In existing electronic spreadsheet software development, develop the list of set form usually according to the business demand specific aim.But fixing electronic spreadsheet form is fixed, and its form has just designed completion when software development, follow-up can not the variation and demand is made amendment and customized according to business.Because only to the list design coding of a certain set form, structure is inflexible, limitation is big.A kind of new list is perhaps wanted to use in place of every modification, all must revise source code or from source code, add a kind of list template again, and it is all dumb to revise use, and maintainability is poor, maintenance cost is high.Thus, the client is defined voluntarily to form structure and become demand gradually.
One Chinese patent application CN101957747A discloses a kind of method of Worksheet self-defining; It makes up the form structure model according to entity; Make up list memory model and list interrogation model according to form structure, create list according to these four steps of form structure model construction list index model.
Simultaneously, one Chinese patent application CN101241434A also discloses a kind of method of Worksheet self-defining, and the mode that it takes to encapsulate the WinForm control provides integrated list that instrument is set, and lets the user produce form through the control control.
The method of above-mentioned self-defined list uses more complicated, and user's technical ability itself is required than higher, requires the user to utilize control to generate list; Control of authority flexibly and inquiry mechanism do not have certain requirement and restriction to environment for use simultaneously, and self-defining list is lacked control of authority and management, are unfavorable for actual use.
Therefore, need badly and a kind ofly can carry out the self-defining method and apparatus of electronic spreadsheet form neatly.
Summary of the invention
The object of the present invention is to provide and a kind ofly can carry out the self-defining method and apparatus of electronic spreadsheet form neatly.
The invention discloses a kind of method that generates self-defined list, comprising:
Newly-built list Template Information, said list Template Information comprise form information table, field information table, form fields relation table, field type information table, field type subitem information table;
Wherein, said form information table comprises the unique identification of discerning the list information table, list sign, the form name that is used to identify list; The field information table is used to store all field informations, and the field information table comprises field information table sign, is used for field identification, field title, field type and the field type sign of identification field; The form fields relation table is used to explain the relation between field and the list, and the form fields relation table comprises the field identification of list sign and field that list comprises; The field type table is used to explain the field type attribute, and the field type table comprises field type table sign, field type sign, field type name; Said field type subitem information table comprises said subitem data and corresponding field type sign;
Special field type subitem data configuration module is used for importing establishment special field type subitem data according to the user.
Wherein, configuration special field type subitem data become entity to be saved in field type subitem information table the special field type subitem data encapsulation of user's typing and according to its corresponding field type identification renewal field type information table;
The information of typing list is encapsulated into the form information entity object, and produces unique list sign at random, be submitted to the form information table;
Create field according to user instruction; Define field title, field type and field information sign; In the field information table, insert new field information according to above definition content, and in the form fields relation table, insert field identification and the list template identification corresponding so that field information is got in touch with the foundation of list template with it;
Generate form instance according to the list template, read all field informations of this list template, generate corresponding typing unit and be presented on and form registration form in the interface, supply the user to carry out the information typing.
Wherein, said typing unit is for supplying the display unit of user's entry information.
Wherein, saidly generate form instance, read all field informations of this list template, generate corresponding typing unit and be presented on and form list in the interface and comprise according to the list template:
In the form information table, the list Status Flag is made as " having generated list " state.
According to the list sign, field identification inserts a list table in data source, and said list table is designated table name with list corresponding in the form information table; All inner fields of this list table serve as the row names with corresponding field identification in the field information table of inquiring about the correspondence that obtains according to the form fields relation table;
The list template of selecting according to the user obtains the list sign, obtains all field informations in this list through multilist conjunctive query or other any array mode that obtains the equal effect of multilist conjunctive query;
Generating corresponding typing unit according to the constraint of the field of field type setting is presented on and supplies user's entry information to use in the interface.
Wherein, said method also comprises:
Configure user is for the newly-increased of list and field or revise, consult authority, and when presenting list, according to the authority of login user, filtering out this user has newly-increased or revise, consult the field of authority, thereby optionally presents field to the user.
Wherein, said method also comprises behind newly-built list Template Information:
Special field type subitem data configuration module is used for importing establishment special field type subitem data according to the user.
Wherein, Configuration special field type subitem data become entity to be saved in field type subitem information table the special field type subitem data encapsulation of user's typing and according to its corresponding field type identification renewal field type information table, said field type subitem information table comprises said subitem data and corresponding field type sign.
Wherein, said special field type comprises multiselect one field type and multiselect multiword segment type.
The invention also discloses a kind of device that generates self-defined list, comprising:
The template establishment module is used at the newly-built list Template Information of data source, and said list Template Information comprises form information table, field information table, form fields relation table, field type information table, field type subitem information table;
Wherein, said form information table comprises the unique identification of discerning the list information table, list sign, the form name that is used to identify list; The field information table is used to store all field informations, and the field information table comprises field information table sign, is used for field identification, field title, field type and the field type sign of identification field; The form fields relation table is used to explain the relation between field and the list, and the form fields relation table comprises the field identification of list sign and field that list comprises; The field type table is used to explain the field type attribute, and the field type table comprises field type table sign, field type sign, field type name; Said field type subitem information table comprises said subitem data and corresponding field type sign;
Special field type subitem data configuration module is used for importing establishment special field type subitem data according to the user.
Wherein, configuration special field type subitem data become entity to be saved in field type subitem information table the special field type subitem data encapsulation of user's typing and according to its corresponding field type identification renewal field type information table;
The form definition module is used for the form information of typing is encapsulated into the form information entity object, and produces unique list sign at random, is submitted to the form information table;
The Field Definition module; Be used for creating field according to user instruction; Define field title, field type and field information sign; In the field information table, insert new field information according to above definition content, and in the form fields relation table, insert field identification and the list template identification corresponding so that field information is got in touch with the foundation of list template with it;
The list generation module is used for generating form instance according to the list template, reads all field informations of this list template, generates corresponding typing unit and is presented on and forms registration form in the interface, supplies the user to carry out the information typing.
Wherein, said typing unit is for supplying the display unit of user's entry information.
Wherein, said list generation module comprises:
The status modifier submodule is used for the list Status Flag being made as " having generated list " state at the form information table.
List inserts submodule, is used for inserting a list table according to list sign and field identification, and said list table is designated table name with list corresponding in the form information table; All inner fields of this list table serve as the row names with corresponding field identification in the field information table of inquiring about the correspondence that obtains according to the form fields relation table;
The inquiry submodule is used for obtaining the list sign according to the list template that the user selects, and obtains all field informations in this list through multilist conjunctive query or other any array mode that obtains the equal effect of multilist conjunctive query;
Present submodule, be used for being presented on the use of interface confession user entry information according to the corresponding typing of the field constraint generation unit of field type setting.
Method and apparatus of the present invention is provided with different database tables through utilizing database; Different database table integration is connected with field identification and field type sign through the list sign; Generate the typing unit through substep editing data storehouse table data and the corresponding setting of basis again and present the custom feature of having realized list at the interface, expanded the scope and the dirigibility of forms application greatly.
Description of drawings
Fig. 1 is the process flow diagram of method of the self-defined list of generation of the embodiment of the invention;
Fig. 2 is the graph of a relation of database table in the embodiment of the invention.
Embodiment
Further specify technical scheme of the present invention below in conjunction with accompanying drawing and through embodiment.
Be the example explanation with the database with data storage method in embodiments of the present invention, it is merely explains embodiment of the present invention and principle, is not to be used to limit protection scope of the present invention.List of the present invention comprises data storage methods such as Excel, XML file, independent data library file.
Fig. 1 is the process flow diagram that the embodiment of the invention generates the method for self-defined list.As shown in Figure 1, said method comprises:
Step 100, create instruction newly-built list Template Information in database of list template according to the user.Said list Template Information comprises form information table, field information table, form fields relation table, field type information table, field type subitem information table.The operation of newly-built list Template Information comprises sets up and above-mentioned each database table of initialization, and define major key, field title, field type, institute in each database table and take up space etc., and definite master meter and relation from table.
Wherein, the form information table is used to write down the title and the relevant information of all lists.Can comprise in the form information table whether the sign of discerning this information table, the list sign that is used for identifying a certain list, form name, remarks, creation-time, founder, list be visible, whether list has generated sign and be used for the group id in the list group.
The field information table is used to store all field informations.The field information table comprises field information table sign, is used for field identification, field title, remarks, creation-time, founder, field type and the field type sign of identification field.
The form fields relation table is used to explain the relation between field and the list.The form fields relation table comprises form fields relation table sign, list sign and field identification, can confirm according to the form fields relation table which field is a certain particular form comprise.
The field type table is used to explain the field type attribute.The field type table comprises field type table sign, field type sign, field type name, founder and creation-time.In an embodiment of the present invention, said field type includes but not limited to text box, date type, numeric type, multiselect one type, multiselect polymorphic type.
The subitem information table that field type is corresponding is used for limiting for multiselect one and the eurypalynous subitem content of multiselect.Field type subitem information table comprises subitem information table sign, field type sign, and it is corresponding to the sign of the field type in the field type table, subitem title, founder and creation-time.
Relation between each database table is as shown in Figure 2, can confirm the form fields relation table that this list is corresponding according to the list sign of form information table, has the field identification of a plurality of fields corresponding with the list sign in the form fields relation table.Can find this field information in the corresponding field information table according to field identification.Wherein, the field type in the field information through the field type table with and sublist field type subitem information table definition.Field information table and field type information table and field type subitem information table are got in touch through field type sign FIELDTYPE.
Step 200, special field type subitem data configuration module are used for importing establishment special field type subitem data according to the user.
The subitem master data of field types such as wherein, configuration special field type subitem data need dispose the notepad data of special field type, and the multiselect one that need use when also promptly being defined in custom field, multiselect are many.Become entity to be kept in field type information table and the field type subitem information table special field type subitem data encapsulation of user's typing.
Step 300, according to user instruction form information Table Properties and field information Table Properties are set and generate and obtain the list template.
The information of typing is encapsulated into the form information entity object, and produces unique at random list identity column BOOKID automatically, be submitted to the form information table.
Create field (establishment needs the content of registration) according to user instruction; Define field title, field type and field information sign; In the Database field information table, insert new field information according to above definition content; And in the form fields relation table, insert field identification and the list template identification corresponding with it so that field information is set up with the list template gets in touch, thereby generation obtains the list template.
Step 400, generate form instance, from database, read all field informations of this list template, generate corresponding control and be presented on and form registration form in the interface, supply the user to carry out the information typing according to the list template.Need to prove that using and generating control only is an embodiment of the present invention, the present invention can also adopt based on realizing providing the user to carry out the information typing in other technological typing unit.The typing unit here is meant any display unit that user's entry information is provided.It can be above-mentioned control, also can be to eject the dialog box that requires the user to import, and can also be the various unit that are used for entry information such as text box, picture box.
Said step 400 specifically comprises:
Status Flag with certain form information in the form information table is " having generated list " state.
Create database table, according to list sign BOOKID, field identification FIELDID inserts a list table (being used for storing the register content of this list) in database.This list table is with the form information identity column of corresponding this table in form information table table name by name; All inner fields of this list table are called the row name with field information flag column corresponding in the field information table.
List appears, and comprising:
The list of selecting according to the user obtains list sign BOOKID, obtains all field informations in this list through multilist conjunctive query or other any array mode that obtains the equal effect of multilist conjunctive query.
According to field type; Constraint (comprising non-NULL, checking), typing control (the illegal typing restriction of field are set; Regular expression, numerical value, text, date etc.) the typing unit that generates corresponding control or other type is presented on and supplies user's entry information to use in the interface.
In one embodiment of the invention, can configure user for list and field increase, revise and consult authority newly, when presenting list, according to the authority of login user, filter out this user have newly-increased, revise and consult
The field of authority, thus optionally present field to the user.
Configure user comprises increasing newly, revise, delete and consulting authority of list (register):
When presenting list, according to the authority that login user has, filter out the list that this user has the authority of consulting, be presented in the list template navigation of left side; After the user selected a list template, the information list of this list appeared; If newly-increased authority is arranged, then can present a newly-increased button at homepage, supply the newly-increased form information of user, otherwise not newly-increased button presents; If the modification authority arranged, then can present the icon that supply to revise, otherwise present grey icon at first of form information tabulation; If erase right is arranged, then can present the icon that can supply to delete form information, otherwise present grey icon at the secondary series of form information tabulation.
Configure user increases, revises and consult authority newly to the interior field of list (register).
If to field configuration newly-increased or revise, consult authority, when presenting list, filter out newly-increased or revise, consult the field of authority, thereby optionally present field to the user.
Method and apparatus of the present invention is provided with different database tables through utilizing database; Different database table integration is connected with field identification and field type sign through the list sign; Present the function of making by oneself that has realized list at the interface through substep editing data storehouse table data and according to the corresponding typing unit that generates control or other type of setting again, expanded the scope and the dirigibility of forms application greatly.
Obviously; It will be understood by those skilled in the art that above-mentioned each module of the present invention or each step can realize that they can concentrate on the single calculation element with the general calculation device; Perhaps be distributed on the network that a plurality of calculation element forms; Alternatively, they can realize with the executable program code of computer installation, carried out by calculation element thereby can they be stored in the memory storage; Perhaps they are made into each integrated circuit modules respectively, perhaps a plurality of modules in them or step are made into the single integrated circuit module and realize.Like this, the present invention is not restricted to the combination of any specific hardware and software.
The above is merely the preferred embodiments of the present invention, is not limited to the present invention, and to those skilled in the art, the present invention can have various changes and variation.All any modifications of within spirit of the present invention and principle, being done, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.

Claims (7)

1. method that generates self-defined list comprises:
Newly-built list Template Information, said list Template Information comprise form information table, field information table, form fields relation table, field type information table, field type subitem information table;
Wherein, said form information table comprises the unique identification of discerning the list information table, list sign, the form name that is used to identify list; The field information table is used to store all field informations, and the field information table comprises field information table sign, is used for field identification, field title, field type and the field type sign of identification field; The form fields relation table is used to explain the relation between field and the list, and the form fields relation table comprises the field identification of list sign and field that list comprises; The field type table is used to explain the field type attribute, and the field type table comprises field type table sign, field type sign, field type name; Said field type subitem information table comprises said subitem data and corresponding field type sign;
Import the subitem data of creating the special field type according to the user;
Wherein, the subitem data of configuration special field type become entity to be saved in field type subitem information table the special field type subitem data encapsulation of user's typing and according to its corresponding field type identification renewal field type information table;
The information of typing list is encapsulated into the form information entity object, and produces unique list sign at random, be submitted to the form information table;
Create field according to user instruction; Define field title, field type and field information sign; In the field information table, insert new field information according to above definition content, and in the form fields relation table, insert field identification and the list template identification corresponding so that field information is got in touch with the foundation of list template with it;
Generate form instance according to the list template, read all field informations of this list template, generate corresponding typing unit and be presented on and form list in the interface, supply the user to carry out the information typing;
Wherein, said typing unit is for supplying the display unit of user's entry information.
2. the method for the self-defined list of generation as claimed in claim 1 is characterized in that: said according to list template generation form instance, read all field informations of this list template, and generate corresponding typing unit and comprise:
In the form information table, the list Status Flag is made as " having generated list " state.
According to the list sign, field identification inserts a list table, and said list table is designated table name with list corresponding in the form information table; All inner fields of this list table serve as the row names with corresponding field identification in the field information table of the correspondence of form fields relation table inquiry acquisition;
The list template of selecting according to the user obtains the list sign, obtains all field informations in this list through multilist conjunctive query or other any array mode that obtains the equal effect of multilist conjunctive query;
Generating corresponding typing unit according to the constraint of the field of field type setting is presented on and supplies user's entry information to use in the interface.
3. the method for the self-defined list of generation as claimed in claim 1 is characterized in that also comprising:
Configure user is for the newly-increased of list and field or revise, consult authority, and when presenting list, according to the authority of login user, filtering out this user has newly-increased or revise, consult the field of authority, thereby optionally presents field to the user.
4. the method for the self-defined list of generation as claimed in claim 1 is characterized in that: said special field type comprises multiselect one field type and multiselect multiword segment type.
5. device that generates self-defined list comprises:
The template establishment module is used at the newly-built list Template Information of data source, and said list Template Information comprises form information table, field information table, form fields relation table, field type information table, field type subitem information table;
Wherein, said form information table comprises the unique identification of discerning the list information table, list sign, the form name that is used to identify list; The field information table is used to store all field informations, and the field information table comprises field information table sign, is used for field identification, field title, field type and the field type sign of identification field; The form fields relation table is used to explain the relation between field and the list, and the form fields relation table comprises the field identification of list sign and field that list comprises; The field type table is used to explain the field type attribute, and the field type table comprises field type table sign, field type sign, field type name; Said field type subitem information table comprises said subitem data and corresponding field type sign;
Special field type subitem data configuration module is used for importing establishment special field type subitem data according to the user.
Wherein, configuration special field type subitem data become entity to be saved in field type subitem information table the special field type subitem data encapsulation of user's typing and according to its corresponding field type identification renewal field type information table;
The form definition module is used for the form information of typing is encapsulated into the form information entity object, and produces unique list sign at random, is submitted to the form information table;
The Field Definition module; Be used for creating field according to user instruction; Define field title, field type and field information sign; In the field information table, insert new field information according to above definition content, and in the form fields relation table, insert field identification and the list template identification corresponding so that field information is got in touch with the foundation of list template with it;
The list generation module is used for generating form instance according to the list template, reads all field informations of this list template, generates corresponding typing unit and is presented on and forms registration form in the interface, supplies the user to carry out the information typing;
Wherein, said typing unit is for supplying the display unit of user's entry information.
6. the device of the self-defined list of generation as claimed in claim 5 is characterized in that: said list generation module comprises:
The status modifier submodule is used for the list Status Flag being made as " having generated list " state at the form information table.
List inserts submodule, is used for inserting a list table according to list sign and field identification, and said list table is designated table name with list corresponding in the form information table; All inner fields of this list table serve as the row names with corresponding field identification in the field information table of the correspondence of form fields relation table inquiry acquisition;
The inquiry submodule is used for obtaining the list sign according to the list template that the user selects, and obtains all field informations in this list through multilist conjunctive query or other any array mode that obtains the equal effect of multilist conjunctive query;
Present submodule, be used for being presented on the use of interface confession user entry information according to the corresponding typing of the field constraint generation unit of field type setting.
7. the device of the self-defined list of generation as claimed in claim 5 is characterized in that: said special field type comprises multiselect one field type, multiselect multiword segment type.
CN201210209275.7A 2012-06-21 2012-06-21 A kind of method and apparatus generating customizing form Active CN102779040B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201210209275.7A CN102779040B (en) 2012-06-21 2012-06-21 A kind of method and apparatus generating customizing form

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201210209275.7A CN102779040B (en) 2012-06-21 2012-06-21 A kind of method and apparatus generating customizing form

Publications (2)

Publication Number Publication Date
CN102779040A true CN102779040A (en) 2012-11-14
CN102779040B CN102779040B (en) 2015-11-18

Family

ID=47123961

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201210209275.7A Active CN102779040B (en) 2012-06-21 2012-06-21 A kind of method and apparatus generating customizing form

Country Status (1)

Country Link
CN (1) CN102779040B (en)

Cited By (38)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103218417A (en) * 2013-03-27 2013-07-24 广东全通教育股份有限公司 Configurable form generation device and form generation method
CN103593456A (en) * 2013-11-22 2014-02-19 中国技术交易所有限公司 Form user-defined design method and device
CN104112004A (en) * 2014-07-15 2014-10-22 浪潮通用软件有限公司 Method for intelligently copying data on user interface
CN104679514A (en) * 2015-03-06 2015-06-03 浪潮通用软件有限公司 Method and device for self-defining design of scalable framework
CN105068812A (en) * 2015-08-19 2015-11-18 深圳联友科技有限公司 Form generation method and device
CN105302814A (en) * 2014-06-20 2016-02-03 苏州精易会信息技术有限公司 Method and system for storing multiple custom fields
CN105447114A (en) * 2015-11-13 2016-03-30 中科曙光信息技术无锡有限公司 Display method and apparatus for form field
CN105956033A (en) * 2016-04-25 2016-09-21 乐视控股(北京)有限公司 Plate form generation method and apparatus
CN106156990A (en) * 2015-04-07 2016-11-23 苏再强 A kind of PIM method based on mobile terminal
CN106294389A (en) * 2015-05-20 2017-01-04 上海纳鑫信息科技有限公司 A kind of method and system realizing customizing form
CN106354775A (en) * 2016-08-23 2017-01-25 成都科来软件有限公司 Data dynamic configuration system and method based on custom fields
CN106598924A (en) * 2016-10-28 2017-04-26 深圳前海微众银行股份有限公司 Form generation method and device
CN106649233A (en) * 2016-11-17 2017-05-10 中交第二航务工程局有限公司 Method and system for processing user-defined worksheet of mobile device
CN106933837A (en) * 2015-12-29 2017-07-07 航天信息股份有限公司 A kind of database table model and creation method
CN107015957A (en) * 2017-03-16 2017-08-04 深圳市沃易科技有限公司 User's list generation method and device
CN107153544A (en) * 2017-05-09 2017-09-12 合肥汉腾信息技术有限公司 A kind of Worksheet self-defining method and device
CN107341141A (en) * 2017-07-24 2017-11-10 上海网易小额贷款有限公司 List management method, device, medium and computing device
CN107391612A (en) * 2017-07-04 2017-11-24 石化盈科信息技术有限责任公司 Field configuration method and device
CN107491494A (en) * 2017-07-24 2017-12-19 广东省环境监测中心 A kind of field storage method and system applied to soil environment monitoring system
CN107491307A (en) * 2017-08-11 2017-12-19 北京小度信息科技有限公司 Information providing method, device, electronic equipment and computer-readable recording medium
CN107643917A (en) * 2017-10-19 2018-01-30 山东浪潮通软信息科技有限公司 A kind of user configuration information management method and device
CN108363776A (en) * 2018-02-09 2018-08-03 东莞嘉泰钟表有限公司 A kind of self-defined display methods of table field
CN108648092A (en) * 2018-05-16 2018-10-12 中国平安人寿保险股份有限公司 Loss ratio computational methods, device, equipment and computer readable storage medium
CN108898317A (en) * 2017-07-01 2018-11-27 成都牵牛草信息技术有限公司 The method that list operating right is authorized respectively according to form field values
CN109408792A (en) * 2018-10-19 2019-03-01 中国银行股份有限公司 A kind of customer information amended record method and device
CN109741018A (en) * 2018-12-17 2019-05-10 广州天越电子科技有限公司 The method and system of the customized management of business are realized by custom field
CN110019146A (en) * 2018-06-26 2019-07-16 珠海宏桥高科技有限公司 A kind of implementation method and device of list table maintenance function
CN110399420A (en) * 2019-07-30 2019-11-01 广州吉信网络科技开发有限公司 A kind of deriving method, electronic equipment and the medium of configurableization Excel format
CN111027295A (en) * 2019-11-11 2020-04-17 浙江大搜车软件技术有限公司 Data processing method, data processing device, computer equipment and storage medium
CN111209732A (en) * 2019-12-26 2020-05-29 广东飞企互联科技股份有限公司 Method and system for generating form display fields and outputting form display fields to import template in batches
CN111369138A (en) * 2020-03-03 2020-07-03 浙江中控技术股份有限公司 Method and device for generating job form
CN112016283A (en) * 2020-08-18 2020-12-01 杭州指令集智能科技有限公司 Form generation method and device
CN112364619A (en) * 2020-11-27 2021-02-12 智业软件股份有限公司 User-defined form generation method, terminal equipment and storage medium
CN113128186A (en) * 2019-12-30 2021-07-16 陕西西部资信股份有限公司 Form processing method and device
CN113191127A (en) * 2021-04-30 2021-07-30 中核武汉核电运行技术股份有限公司 Nuclear power management information-based user-defined form system and method
CN113626004A (en) * 2021-08-19 2021-11-09 新疆大学 Rapid development system based on configuration mode
US11507651B2 (en) 2017-07-05 2022-11-22 Chengdu Qianniucao Information Technology Co., Ltd. Method for authorizing operation permissions of form-field values
CN115828855A (en) * 2022-11-01 2023-03-21 江苏领悟信息技术有限公司 User-defined form system and method

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101140562A (en) * 2007-02-14 2008-03-12 中兴通讯股份有限公司 Method for realizing user-defined report forms
CN101149737A (en) * 2007-05-10 2008-03-26 廖义洪 Method for quickly establishing web form and automatically establishing corresponding data table in database through Microsoft Word
CN101241434A (en) * 2008-03-04 2008-08-13 浪潮集团山东通用软件有限公司 Form self-defining method
CN101866333A (en) * 2009-12-24 2010-10-20 金蝶软件(中国)有限公司 Worksheet self-defining method and adapter engine
CN101957747A (en) * 2009-07-17 2011-01-26 浙江省公众信息产业有限公司 Method for customizing form
CN102360290A (en) * 2011-09-29 2012-02-22 用友软件股份有限公司 Form building device and form building method

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101140562A (en) * 2007-02-14 2008-03-12 中兴通讯股份有限公司 Method for realizing user-defined report forms
CN101149737A (en) * 2007-05-10 2008-03-26 廖义洪 Method for quickly establishing web form and automatically establishing corresponding data table in database through Microsoft Word
CN101241434A (en) * 2008-03-04 2008-08-13 浪潮集团山东通用软件有限公司 Form self-defining method
CN101957747A (en) * 2009-07-17 2011-01-26 浙江省公众信息产业有限公司 Method for customizing form
CN101866333A (en) * 2009-12-24 2010-10-20 金蝶软件(中国)有限公司 Worksheet self-defining method and adapter engine
CN102360290A (en) * 2011-09-29 2012-02-22 用友软件股份有限公司 Form building device and form building method

Cited By (52)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103218417A (en) * 2013-03-27 2013-07-24 广东全通教育股份有限公司 Configurable form generation device and form generation method
CN103593456A (en) * 2013-11-22 2014-02-19 中国技术交易所有限公司 Form user-defined design method and device
CN103593456B (en) * 2013-11-22 2017-07-14 中国技术交易所有限公司 Worksheet self-defining method for designing and device
CN105302814A (en) * 2014-06-20 2016-02-03 苏州精易会信息技术有限公司 Method and system for storing multiple custom fields
CN104112004A (en) * 2014-07-15 2014-10-22 浪潮通用软件有限公司 Method for intelligently copying data on user interface
CN104679514A (en) * 2015-03-06 2015-06-03 浪潮通用软件有限公司 Method and device for self-defining design of scalable framework
CN106156990A (en) * 2015-04-07 2016-11-23 苏再强 A kind of PIM method based on mobile terminal
CN106294389A (en) * 2015-05-20 2017-01-04 上海纳鑫信息科技有限公司 A kind of method and system realizing customizing form
CN105068812B (en) * 2015-08-19 2018-07-13 深圳联友科技有限公司 A kind of list generation method and device
CN105068812A (en) * 2015-08-19 2015-11-18 深圳联友科技有限公司 Form generation method and device
CN105447114A (en) * 2015-11-13 2016-03-30 中科曙光信息技术无锡有限公司 Display method and apparatus for form field
CN106933837A (en) * 2015-12-29 2017-07-07 航天信息股份有限公司 A kind of database table model and creation method
CN105956033A (en) * 2016-04-25 2016-09-21 乐视控股(北京)有限公司 Plate form generation method and apparatus
CN106354775A (en) * 2016-08-23 2017-01-25 成都科来软件有限公司 Data dynamic configuration system and method based on custom fields
CN106598924A (en) * 2016-10-28 2017-04-26 深圳前海微众银行股份有限公司 Form generation method and device
CN106649233A (en) * 2016-11-17 2017-05-10 中交第二航务工程局有限公司 Method and system for processing user-defined worksheet of mobile device
CN107015957A (en) * 2017-03-16 2017-08-04 深圳市沃易科技有限公司 User's list generation method and device
CN107153544A (en) * 2017-05-09 2017-09-12 合肥汉腾信息技术有限公司 A kind of Worksheet self-defining method and device
US11520978B2 (en) 2017-05-09 2022-12-06 Hefei Hanteng Information Technology Co., Ltd Form customization method and device
CN115098084A (en) * 2017-05-09 2022-09-23 合肥汉腾信息技术有限公司 Non-coding form design and drawing method
WO2018205869A1 (en) * 2017-05-09 2018-11-15 钱叶敢 Form self-defined method and device
CN108898317A (en) * 2017-07-01 2018-11-27 成都牵牛草信息技术有限公司 The method that list operating right is authorized respectively according to form field values
CN108898317B (en) * 2017-07-01 2021-04-06 成都牵牛草信息技术有限公司 Method for respectively authorizing form operation authority according to form field values
CN107391612B (en) * 2017-07-04 2020-06-12 石化盈科信息技术有限责任公司 Method and device for configuring field
CN107391612A (en) * 2017-07-04 2017-11-24 石化盈科信息技术有限责任公司 Field configuration method and device
US11507651B2 (en) 2017-07-05 2022-11-22 Chengdu Qianniucao Information Technology Co., Ltd. Method for authorizing operation permissions of form-field values
CN107491494A (en) * 2017-07-24 2017-12-19 广东省环境监测中心 A kind of field storage method and system applied to soil environment monitoring system
CN107341141A (en) * 2017-07-24 2017-11-10 上海网易小额贷款有限公司 List management method, device, medium and computing device
CN107341141B (en) * 2017-07-24 2020-11-10 上海网易小额贷款有限公司 Form management method, device, medium and computing equipment
CN107491307A (en) * 2017-08-11 2017-12-19 北京小度信息科技有限公司 Information providing method, device, electronic equipment and computer-readable recording medium
CN107643917A (en) * 2017-10-19 2018-01-30 山东浪潮通软信息科技有限公司 A kind of user configuration information management method and device
CN108363776A (en) * 2018-02-09 2018-08-03 东莞嘉泰钟表有限公司 A kind of self-defined display methods of table field
CN108648092A (en) * 2018-05-16 2018-10-12 中国平安人寿保险股份有限公司 Loss ratio computational methods, device, equipment and computer readable storage medium
CN110019146A (en) * 2018-06-26 2019-07-16 珠海宏桥高科技有限公司 A kind of implementation method and device of list table maintenance function
CN109408792B (en) * 2018-10-19 2023-07-04 中国银行股份有限公司 Customer information complement method and device
CN109408792A (en) * 2018-10-19 2019-03-01 中国银行股份有限公司 A kind of customer information amended record method and device
CN109741018A (en) * 2018-12-17 2019-05-10 广州天越电子科技有限公司 The method and system of the customized management of business are realized by custom field
CN110399420A (en) * 2019-07-30 2019-11-01 广州吉信网络科技开发有限公司 A kind of deriving method, electronic equipment and the medium of configurableization Excel format
CN110399420B (en) * 2019-07-30 2022-11-22 广州吉信网络科技开发有限公司 Export method, electronic equipment and medium of configurable Excel format
CN111027295A (en) * 2019-11-11 2020-04-17 浙江大搜车软件技术有限公司 Data processing method, data processing device, computer equipment and storage medium
CN111027295B (en) * 2019-11-11 2023-12-12 浙江大搜车软件技术有限公司 Data processing method, device, computer equipment and storage medium
CN111209732B (en) * 2019-12-26 2023-06-20 广东飞企互联科技股份有限公司 Method and system for generating form display fields and outputting form display fields to import templates in batches
CN111209732A (en) * 2019-12-26 2020-05-29 广东飞企互联科技股份有限公司 Method and system for generating form display fields and outputting form display fields to import template in batches
CN113128186A (en) * 2019-12-30 2021-07-16 陕西西部资信股份有限公司 Form processing method and device
CN111369138A (en) * 2020-03-03 2020-07-03 浙江中控技术股份有限公司 Method and device for generating job form
CN112016283A (en) * 2020-08-18 2020-12-01 杭州指令集智能科技有限公司 Form generation method and device
CN112364619B (en) * 2020-11-27 2022-08-26 智业软件股份有限公司 User-defined form generation method, terminal equipment and storage medium
CN112364619A (en) * 2020-11-27 2021-02-12 智业软件股份有限公司 User-defined form generation method, terminal equipment and storage medium
CN113191127A (en) * 2021-04-30 2021-07-30 中核武汉核电运行技术股份有限公司 Nuclear power management information-based user-defined form system and method
CN113626004A (en) * 2021-08-19 2021-11-09 新疆大学 Rapid development system based on configuration mode
CN115828855A (en) * 2022-11-01 2023-03-21 江苏领悟信息技术有限公司 User-defined form system and method
CN115828855B (en) * 2022-11-01 2023-09-15 江苏领悟信息技术有限公司 Custom form system and method

Also Published As

Publication number Publication date
CN102779040B (en) 2015-11-18

Similar Documents

Publication Publication Date Title
CN102779040A (en) Method and device for generating user-defined form
CN105487864A (en) Method and device for automatically generating code
CN103412868B (en) Document generates method and device
CN102541529B (en) A kind of query page generating device and method
CN110597842B (en) Service data query method and system
CN110543303B (en) Visual service platform
CN103020027A (en) Method, device and system for generating dynamic report
CN101673287A (en) SQL sentence generation method and system
CN102789491B (en) A kind of configurable data subscription and delivery system and method thereof
CN102819609B (en) A kind of perdurable data model modelling approach
CN104346149A (en) Descriptive framework used for data visualization
CN102110142A (en) Method for dynamically expanding personnel transaction in human resource management information system
CN101739452A (en) Data exchange interface and realizing method thereof
CN104063361A (en) Report design method and system
CN101714078A (en) Code generation method and device
CN103593456A (en) Form user-defined design method and device
CN102479198B (en) Data paging method, device and system
CN103927423A (en) Part design change method and system in PDM system
CN105630759A (en) Data reference device and method
CN102866986A (en) Document format conversion system
CN111090803A (en) Data processing method and device, electronic equipment and storage medium
CN102317942B (en) Methods and devices for generating theme's properties
CN103927168A (en) Object-oriented data model persistence method and device
CN103984554A (en) Software design document generating method and device
CN102103513B (en) Method for rapidly developing software by utilizing metadata and middleware

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant
C56 Change in the name or address of the patentee
CP03 Change of name, title or address

Address after: 523000, building 6, 310, 311 and 3, 312 South Industrial Road, Songshan hi tech Industrial Development Zone, Guangdong, Dongguan

Patentee after: GUANGDONG MICROPATTERN SOFTWARE CO., LTD.

Address before: 523808 Guangdong province Dongguan City Songshan Lake Science and Technology Industrial Park Building 4 floor 7 Keyuan pine

Patentee before: Dongguan MicroPattern Corporation