CN111209732B - Method and system for generating form display fields and outputting form display fields to import templates in batches - Google Patents

Method and system for generating form display fields and outputting form display fields to import templates in batches Download PDF

Info

Publication number
CN111209732B
CN111209732B CN201911366106.2A CN201911366106A CN111209732B CN 111209732 B CN111209732 B CN 111209732B CN 201911366106 A CN201911366106 A CN 201911366106A CN 111209732 B CN111209732 B CN 111209732B
Authority
CN
China
Prior art keywords
display
list
excel
lists
display list
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
Application number
CN201911366106.2A
Other languages
Chinese (zh)
Other versions
CN111209732A (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 Flying Enterprise Internet Technology Co Ltd
Original Assignee
Guangdong Flying Enterprise Internet Technology Co Ltd
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 Guangdong Flying Enterprise Internet Technology Co Ltd filed Critical Guangdong Flying Enterprise Internet Technology Co Ltd
Priority to CN201911366106.2A priority Critical patent/CN111209732B/en
Publication of CN111209732A publication Critical patent/CN111209732A/en
Application granted granted Critical
Publication of CN111209732B publication Critical patent/CN111209732B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30Computing systems specially adapted for manufacturing

Landscapes

  • User Interface Of Digital Computer (AREA)
  • Digital Computer Display Output (AREA)

Abstract

The invention designs the latest display list according to the newly added or modified form display field of the Web page, reads and selects a plurality of display lists in the data set, adds the form display field to the plurality of display lists at the same time, and then outputs the display list to Excel to generate the latest import template, so that only the corresponding display list is needed to be found and the display list is led to the import template, the list head of the import template is not needed to be adjusted every time, even if the data amount or the list field is more, the trouble is not caused, and the problem of complicated operation caused by adding the form display field because of excessive display list in the prior art is solved.

Description

Method and system for generating form display fields and outputting form display fields to import templates in batches
[ field of technology ]
The present invention relates to the field of computers, and in particular, to a method and system for generating form display fields and outputting the form display fields to an import template in batch.
[ background Art ]
The list head fields displayed by the current data list are more and more complex, each displayed list is provided with a data import template, the data list is also related to the adjustment of the data import template while the display list head is changed, when one data list import template is changed once, the data list is a simple and easy matter, when hundreds of data list head changes are a headache workload, as Web end services are increased, list form pages of the display data are also increased, each data list is provided with an import function and an import template aiming at historical data, because each import template aims at the currently displayed list, the list head of the import template needs to be adjusted for each adjustment of the list, when the number of the import templates faces to the data quantity or the list fields is large, each modification is more troublesome, and if the import templates of the list display fields need to be added too many, each import template needs to be added once, so that the procedure is very complicated.
For the above, how to design a method for generating form display fields and outputting the form display fields to an import template in batch is a problem that we need to solve.
[ invention ]
The invention aims to solve the problem that the procedure of adding display fields is very complicated when the imported templates are too many in the prior art, and the technical scheme provides a method for generating form display fields and outputting the form display fields to the imported templates in batches, which comprises the following steps:
designing a display list, and inputting required form display fields into the display list;
reading display lists in the data set, and selecting a plurality of display lists;
adding the step form display field to the selected plurality of display lists;
and creating Excel according to the requirement, outputting a plurality of display lists added with form display fields to the newly created Excel in a one-to-one correspondence manner, and defining the newly created Excel as an import template.
Further, the step designs the display list, and inputs the required form display field in the display list through the following steps:
opening a list design on a form designer;
click insertion is designed on the list;
the added or modified display fields are inserted to enable the display list to dynamically generate the desired display list.
Further, the step of reading a display list in the data set and selecting a plurality of display lists includes the steps of:
opening form modeling on a list designer;
inputting an ID number corresponding to the display list at the query option, and displaying the ID number and the list form corresponding to the ID number;
a plurality of display lists are selected.
Further, the step of reading the display list in the data set and selecting a plurality of display lists further includes the steps of:
clicking and opening a list form after the query option is input;
click importing;
the dynamic of importing the ID number is displayed at the OnClick event and the confirmation is clicked.
Further, the step of creating an Excel according to the requirement, and outputting a plurality of display lists added with form display fields to the Excel newly created in a one-to-one correspondence manner, wherein the step of defining the newly created Excel as an import template comprises the following steps:
POI operation Excel, and creating Excel and a workbook through HSSFWorkBook;
setting an Excel title according to the user demand;
creating cells and cell contents according to the display list;
setting the style and font of the cell.
The present application also provides a system for generating form display fields and bulk outputting to an importation template,
comprising the following steps:
display list design module: the display list is used for designing a display list, and a form display field is input in the display list;
and a reading and selecting module: the method comprises the steps of reading a display list in a data set, and selecting a plurality of display lists;
and (3) an adding module: for adding the step form display field to the selected plurality of display lists;
and an output and definition module: and the method is used for creating Excel according to the requirements, respectively outputting a plurality of display lists added with the form display fields to the newly created Excel in one-to-one correspondence, and defining the newly created Excel as an import template.
Further, the display list design module generates through the form designer, opens the list design on the form designer, clicks and inserts the display field added or changed in the list design, so that the display list can dynamically generate the required display list.
Further, form modeling is opened on the display list design module, ID numbers corresponding to the display list are input at the query options, and the ID numbers and the list forms corresponding to the ID numbers are displayed.
The beneficial effects of the invention are as follows:
1. the invention designs the latest display list according to the newly added or modified form display field of the Web page, reads and selects a plurality of display lists in the data set, adds the form display field to the plurality of display lists at the same time, and then outputs the display list to Excel to generate the latest import template, so that only the corresponding display list is needed to be found and the display list is led to the import template, the list head of the import template is not needed to be adjusted every time, even if the data amount or the list field is more, the trouble is not caused, and the problem of complicated operation caused by adding the form display field because of excessive display list in the prior art is solved.
2. The invention has the advantages of even performance and timely effectiveness after modification.
3. The method is simple and easy to operate, the display list is designed according to the form designer, the import button and the corresponding ID of the import method are well configured, and multiple excels are not required to be manually configured.
[ description of the drawings ]
In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings that are required to be used in the description of the embodiments will be briefly described below.
FIG. 1 is a flow chart of a method of generating form display fields and outputting them to an import template in bulk in accordance with the present invention;
FIG. 2 is a block diagram of a system for generating form display fields and bulk output to an import template in accordance with the present invention
FIG. 3 is a diagram of a form designer design choice for one method of generating form display fields and outputting them in bulk to an import template in accordance with the present invention;
FIG. 4 is a display list and form display field layout diagram of a method of generating form display fields and batch outputting to an import template in accordance with the present invention;
FIG. 5 is a diagram of a read data set for a method of generating form display fields and outputting them in bulk to an import template in accordance with the present invention;
FIG. 6 is a diagram of import ID numbers for a method of generating form display fields and outputting them to an import template in bulk in accordance with the present invention;
FIG. 7 is a schematic diagram of an export importation template of one method of generating form display fields and outputting them in bulk to the importation template in accordance with the present invention;
FIG. 8 is a schematic diagram of an importation template of one method of generating form display fields and outputting them in bulk to the importation template in accordance with the present invention.
[ detailed description ] of the invention
In order to make the technical problems, technical schemes and beneficial effects solved by the invention more clear, the invention is further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the invention.
When embodiments of the present invention refer to the ordinal terms "first," "second," etc., it is to be understood that they are merely used for distinguishing between them unless the order of their presentation is indeed dependent on the context.
In the description of the present invention, it should be noted that, unless explicitly specified and limited otherwise, the terms "mounted," "connected," and "connected" are to be construed broadly, and may be either fixedly connected, detachably connected, or integrally connected, for example; can be mechanically or electrically connected; can be directly connected or indirectly connected through an intermediate medium, and can be communication between two elements. The specific meaning of the above terms in the present invention will be understood in specific cases by those of ordinary skill in the art.
Referring to fig. 1 to 8, a method for dynamically generating an import control according to a list form includes the following steps:
designing a display list, inputting a required form display field 6 into the display list, and generating a new form display field 6 according to the requirement of a user;
reading display lists in the data set, selecting a plurality of display lists, and simultaneously selecting a plurality of display lists so as to simultaneously add the form display field 6 into the plurality of display lists;
adding the step form display field 6 into the selected multiple display lists, and updating the display list of the data set according to the ID number 7 so that a new form display field 6 is generated by the display list in the data set;
creating Excel according to requirements, respectively outputting a plurality of display lists added with the form display field 6 to the Excel which is newly created in one-to-one correspondence, defining the newly created Excel as an import template, and outputting the corresponding display list on the Excel according to the ID number 7, wherein the Excel is the import template for a user to obtain the latest display list so as to fill in corresponding data;
according to the invention, firstly, the latest display list is designed according to the newly added or modified form display field 6 of the Web page, a plurality of display lists are read and selected in the data set, the form display field 6 is added to the plurality of display lists at the same time, then the display list can be output to Excel to generate the latest import template, so that only the corresponding display list is needed to be found and the display list is led to the import template, the list head of the import template is not needed to be adjusted every time, even if the data amount or the list fields are more, the trouble is not caused, and the problem of complicated operation caused by adding the form display field 6 due to excessive display lists in the prior art is solved.
Further, the step designs the display list, and inputs the required form display field 6 in the display list by the following steps:
opening a list design on a form designer;
click insertion is designed on the list;
inserting the added or changed display field to enable the display list to dynamically generate a required display list;
as shown in fig. 3, the form designer of the FE business collaboration platform is used, the form designer is opened first to select the form modeling 5, the interface shown in fig. 4 is displayed, a list of form display fields 6 to be added is added at the tail end by clicking and inserting, so that the display list can generate the newly added or modified form display fields 6 according to the requirement of the user to design the latest display list, and the operation is simple.
Further, the step of reading a display list in the data set and selecting a plurality of display lists includes the steps of:
opening form modeling on a list designer;
inputting an ID number 7 corresponding to the display list at the query option, and displaying the ID number 7 and the list form corresponding to the ID number 7;
a plurality of display lists are selected.
As shown in fig. 5, when ID number 7 is entered in the query 8 field, a corresponding display list appears at the interface name.
Further, the step of reading the display list in the data set and selecting a plurality of display lists further includes the steps of:
clicking and opening a list form after the query option is input;
click importing;
the dynamic of importing the ID number 7 is displayed at the OnClick event and the confirmation is clicked.
As shown in fig. 5, a list form to be added is selected at the list form, and through the binding flow, as shown in fig. 6, the list form display field 6 is bound to the corresponding ID number 7 under the script.
Further, the step of creating an Excel according to the requirement, and outputting a plurality of display lists after adding the form display field 6 to a one-to-one corresponding newly created Excel, wherein the newly created Excel is defined as an import template, and the step of:
POI operation Excel, and creating Excel and a workbook through HSSFWorkBook;
setting an Excel title according to the user demand;
creating cells and cell contents according to the display list;
setting the style and font of the cell.
As shown in fig. 7, the display list is exported to the Excel through the data stream by the import button for the user to download the Excel, and finally an import template is generated as shown in fig. 8.
The present application also provides a system for generating form display fields 6 and outputting to an import template in batches, comprising:
display list design module 1: for designing a display list and inputting a form display field 6 in the display list;
reading and selecting module 2: the method comprises the steps of reading a display list in a data set, and selecting a plurality of display lists;
adding module 3: for adding the step form display field 6 to the selected plurality of display lists;
output and definition module 4: and the method is used for creating Excel according to the requirement, outputting a plurality of display lists added with the form display field 6 to the Excel which is newly created in a one-to-one correspondence mode respectively, and defining the newly created Excel as an import template.
According to the invention, firstly, the latest display list is designed in the display list design module 1 according to the newly added or modified form display field 6 required by the user, and as each display list corresponds to one ID number 7, a plurality of display lists are read and selected in the reading and selecting module 2, and then the form display field 6 is added to the plurality of display lists at the same time, and then the display list can be output to Excel through the adding module 3 to generate the latest import template, so that the corresponding display list is only required to be found according to the ID number 7 and the display list is led to the import template, thereby avoiding the need of adjusting the list head of the import template every time, avoiding the trouble even if the data amount or the list field is more, and solving the problem of complicated operation caused by adding the form display field 6 due to excessive display lists in the prior art.
Further, the display list design module 1 generates a list design by a form designer, opens the list design on the form designer, clicks and inserts the display field added or changed in the list design, so that the display list can dynamically generate a required display list, and the display list can dynamically generate the required display list.
Further, the form modeling is opened on the display list design module 1, the ID number 7 corresponding to the display list is input at the query option, the ID number 7 and the list form corresponding to the ID number 7 are displayed, and the ID number 7 and the list form corresponding to the ID number 7 are displayed.
The foregoing description is only a preferred embodiment of the present invention, and is not intended to limit the technical scope of the present invention, so any minor modifications, equivalent changes and modifications made to the above embodiments according to the technical principles of the present invention are still within the scope of the technical solutions of the present invention.

Claims (4)

1. A method for generating form display fields and outputting the form display fields to an import template in batches is characterized by comprising the following steps: the method comprises the following steps:
designing a display list, and inputting required form display fields into the display list;
reading display lists in the data set, and selecting a plurality of display lists;
adding the step form display field to the selected plurality of display lists;
creating Excel according to requirements, outputting a plurality of display lists added with form display fields to the Excel which is newly created in a one-to-one correspondence mode, and defining the newly created Excel as an import template;
the step designs a display list, and inputs required form display fields in the display list through the following steps:
opening a list design on a form designer;
click insertion is designed on the list;
inserting the added or changed display field to enable the display list to dynamically generate a required display list;
the steps of reading the display list in the data set and selecting a plurality of display lists are as follows:
opening form modeling on a list designer;
inputting an ID number corresponding to the display list at the query option, and displaying the ID number and the list form corresponding to the ID number;
a plurality of display lists are selected.
2. The method for generating form display fields and outputting in bulk to an importation template of claim 1 wherein: the step of reading the display list in the data set and selecting a plurality of display lists further comprises the following steps:
clicking and opening a list form after the query option is input;
click importing;
the dynamic of importing the ID number is displayed at the OnClick event and the confirmation is clicked.
3. The method for generating form display fields and outputting in bulk to an importation template of claim 1 wherein: the step of creating Excel according to the requirement, and respectively outputting a plurality of display lists added with form display fields to the Excel which is newly created in a one-to-one correspondence manner, wherein the step of defining the newly created Excel as an import template comprises the following steps:
POI operation Excel, and creating Excel and a workbook through HSSFWorkBook;
setting an Excel title according to the user demand;
creating cells and cell contents according to the display list;
setting the style and font of the cell.
4. A system for generating form display fields and outputting the form display fields to an import template in batches, the system comprising:
comprising the following steps:
display list design module (1): the display list is used for designing a display list, and a form display field is input in the display list;
reading and selecting module (2): the method comprises the steps of reading a display list in a data set, and selecting a plurality of display lists;
adding module (3): for adding the step form display field to the selected plurality of display lists;
output and definition module (4): the method comprises the steps of creating Excel according to requirements, respectively outputting a plurality of display lists added with form display fields to the Excel which is newly created in a one-to-one correspondence mode, and defining the newly created Excel as an import template;
the display list design module (1) opens list design on the form designer through the form designer, clicks and inserts the added or changed display field in the list design, so that the display list can dynamically generate a required display list;
and opening form modeling on the display list design module (1), inputting an ID number corresponding to the display list at the query option, and displaying the ID number and the list form corresponding to the ID number.
CN201911366106.2A 2019-12-26 2019-12-26 Method and system for generating form display fields and outputting form display fields to import templates in batches Active CN111209732B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201911366106.2A CN111209732B (en) 2019-12-26 2019-12-26 Method and system for generating form display fields and outputting form display fields to import templates in batches

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201911366106.2A CN111209732B (en) 2019-12-26 2019-12-26 Method and system for generating form display fields and outputting form display fields to import templates in batches

Publications (2)

Publication Number Publication Date
CN111209732A CN111209732A (en) 2020-05-29
CN111209732B true CN111209732B (en) 2023-06-20

Family

ID=70788398

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201911366106.2A Active CN111209732B (en) 2019-12-26 2019-12-26 Method and system for generating form display fields and outputting form display fields to import templates in batches

Country Status (1)

Country Link
CN (1) CN111209732B (en)

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102779040A (en) * 2012-06-21 2012-11-14 东莞市微模式软件有限公司 Method and device for generating user-defined form
CN107153544A (en) * 2017-05-09 2017-09-12 合肥汉腾信息技术有限公司 A kind of Worksheet self-defining method and device
CN109885541A (en) * 2018-12-28 2019-06-14 深圳市恒创智达信息技术有限公司 The method and apparatus of information batch processing
CN110347985A (en) * 2019-05-30 2019-10-18 平安科技(深圳)有限公司 Method, apparatus, computer equipment and the storage medium that table generates

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102779040A (en) * 2012-06-21 2012-11-14 东莞市微模式软件有限公司 Method and device for generating user-defined form
CN107153544A (en) * 2017-05-09 2017-09-12 合肥汉腾信息技术有限公司 A kind of Worksheet self-defining method and device
CN109885541A (en) * 2018-12-28 2019-06-14 深圳市恒创智达信息技术有限公司 The method and apparatus of information batch processing
CN110347985A (en) * 2019-05-30 2019-10-18 平安科技(深圳)有限公司 Method, apparatus, computer equipment and the storage medium that table generates

Also Published As

Publication number Publication date
CN111209732A (en) 2020-05-29

Similar Documents

Publication Publication Date Title
US7168041B1 (en) Method and apparatus for table and HDL based design entry
CN107329747A (en) A kind of method and device for generating multi-threaded pattern
CN102779040B (en) A kind of method and apparatus generating customizing form
CN114035773B (en) Configuration-based low-code form development method, system and device
CN108763171A (en) A kind of document automation generation method based on format module
CN103593456B (en) Worksheet self-defining method for designing and device
US7103835B1 (en) Process builder for a routable electronic document system and method for using the same
CN102456033B (en) General page querying method, system and terminal
CN109933752A (en) A kind of method and apparatus exporting electronic document
CN106021394A (en) Website construction method and apparatus
CN105607880A (en) Printing method and device for examined and approved documents
CN101673199A (en) Terminal parameter configuration server and automatic generating method of software interface thereof
CN103236959A (en) Test system and test method for testing business processing module
CN111881662A (en) Form generation method, device, processing equipment and storage medium
CN109783083A (en) WEB application development approach and its system
CN109542438A (en) One kind being based on visual chart development approach
CN112040428A (en) 5G message template library construction method and device and storage medium
CN106407172A (en) XML (Extensible Markup Language)-based report generating method
CN111209732B (en) Method and system for generating form display fields and outputting form display fields to import templates in batches
CN105450656A (en) APP data configuration method, device, server and system
CN105590547B (en) A kind of implementation method of seating plan, device and system
CN100498808C (en) Printing circuit board element height outputting method and device thereof
CN109857969A (en) Data form view processing method, system and computer readable storage medium
CN105468570B (en) A kind of document synthesis methods of exhibiting and device
CN102314468A (en) Synchronous browse method

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant