CN111209732A - Method and system for generating form display fields and outputting form display fields to import template in batches - Google Patents
Method and system for generating form display fields and outputting form display fields to import template in batches Download PDFInfo
- Publication number
- CN111209732A CN111209732A CN201911366106.2A CN201911366106A CN111209732A CN 111209732 A CN111209732 A CN 111209732A CN 201911366106 A CN201911366106 A CN 201911366106A CN 111209732 A CN111209732 A CN 111209732A
- Authority
- CN
- China
- Prior art keywords
- display
- list
- fields
- lists
- display fields
- 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
Links
Images
Classifications
-
- Y—GENERAL 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
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Digital Computer Display Output (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The method comprises the steps of firstly designing a display latest display list according to a form display field newly added or modified on a Web page, reading and selecting a plurality of display lists in a data set, simultaneously adding the form display field to the display lists, then outputting the display lists to Excel, and generating a latest import template.
Description
[ technical field ] A method for producing a semiconductor device
The invention relates to the field of computers, in particular to a method and a system for generating form display fields and outputting the form display fields to an import template in batches.
[ background of the invention ]
At present, the displayed header fields of the data lists are more and more complicated, each displayed list is provided with a template for importing data, the data lists change the displayed headers and are also related to the adjustment of the template for importing data, when one template for importing data is modified once, the modification is a simple and easy matter, when the change of the headers of hundreds of data lists is a troublesome workload, list pages for displaying data are increased with the increase of Web end services, each data list is provided with an importing function and an importing template aiming at historical data, because each importing template aims at the currently displayed list, the list header of the importing template needs to be adjusted for each adjustment of the list, and each modification is troublesome when the data amount or the list fields are more, if too many import templates are needed to add the form display fields, the display fields need to be added once for each import template, and the process is very complicated.
In view of the above, how to design a method for generating form display fields and outputting the form display fields to an import template in batches becomes a problem to be solved.
[ summary of the invention ]
The invention aims to solve the problem that the process of adding display fields is very complicated when too many templates are imported 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 in the display list;
reading the display lists in the data set, and selecting a plurality of display lists;
adding the step list display fields into the selected display lists;
creating Excel according to requirements, respectively outputting a plurality of display lists with added 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 step of designing a display list and inputting the required form display field in the display list comprises the following steps:
opening a list design on a form designer;
clicking and inserting in the list design;
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 the display list in the data set and selecting a plurality of display lists comprises the following steps:
opening a form on a list designer for modeling;
inputting the 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 lists in the data set and selecting a plurality of display lists further comprises the following steps:
clicking to open the list form after the query option is input;
click import;
the dynamic of importing the ID number is displayed at the OnClick event and the confirmation is clicked.
Further, the step of creating Excel according to the requirement, outputting the display lists with the added form display fields to the newly created Excel in one-to-one correspondence, and defining the newly created Excel as the import template comprises the following steps:
operating Excel by POI, and creating Excel and workbook by HSSFWorkBook;
setting an Excel title according to user requirements;
creating cells and cell contents according to the display list;
and setting the style and the font of the cell.
The application also provides a system for generating the form display fields and outputting the form display fields to the import template in batches,
the method comprises the following steps:
a display list design module: the display field input device is used for designing a display list and inputting a form display field in the display list;
a reading and selecting module: the display list reading device is used for reading the display lists in the data set and selecting a plurality of display lists;
adding a module: the step list display field is added into the selected display lists;
an output and definition module: the method is used for creating Excel according to requirements, outputting a plurality of display lists with the form display fields added 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 is generated through a form designer, a list design is opened on the form designer, the list design is inserted by clicking, and the added or changed display fields are inserted, so that the display list can dynamically generate a required display list.
Further, form modeling is opened on the display list design module, an ID number corresponding to the display list is input at the query option, and the ID number and the list form corresponding to the ID number are displayed.
The invention has the beneficial effects that:
1. the method comprises the steps of firstly designing a display latest display list according to a form display field newly added or modified on a Web page, reading and selecting a plurality of display lists in a data set, simultaneously adding the form display field to the display lists, then outputting the display lists to Excel, and generating a latest import template, so that only a corresponding display list needs to be found and the display lists are imported to the import template, the list header of the import template does not need to be adjusted every time, troubles are not caused even if the data volume or the list field is more, and the problem of complex operation caused by adding the form display field due to excessive display lists in the prior art is solved.
2. The invention has the advantages of high practicability and timely effect after modification.
3. The method is simple and easy to operate, the display list is designed according to the form designer, the import button of the import method is configured well, the corresponding ID is configured well, and multiple excels do not need to be configured manually.
[ description of the drawings ]
In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings used in the description of the embodiments will be briefly introduced below.
FIG. 1 is a flow chart of a method of generating form display fields and outputting them in bulk to an import template according to the present invention;
FIG. 2 is a block diagram of a system for generating form display fields and outputting the form display fields to import templates in batches according to the present invention
FIG. 3 is a diagram of form designer selection for a method of generating form display fields and outputting them in bulk to an import template according to the present invention;
FIG. 4 is a display list and form display field layout diagram of a method of generating and batch outputting form display fields to an import template according to 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 according to the present invention;
FIG. 6 is a diagram of import ID numbers for a method of generating form display fields and batch export to an import template according to the present invention;
FIG. 7 is a diagram of an output import template for a method of generating form display fields and outputting them in bulk to an import template according to the present invention;
FIG. 8 is a diagram of an import template of a method for generating form display fields and outputting the form display fields to the import template in batch according to the present invention.
[ detailed description ] embodiments
In order to make the technical problems, technical solutions and advantageous effects solved by the present invention more clearly apparent, the present 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 merely illustrative of the invention and are not intended to limit the invention.
When embodiments of the present invention refer to the ordinal numbers "first", "second", etc., it should be understood that the terms are used for distinguishing only when they do express the ordinal order in light of the context.
In the description of the present invention, it should be noted that, unless otherwise explicitly specified or limited, the terms "mounted," "connected," and "connected" are to be construed broadly, e.g., as meaning either a fixed connection, a removable connection, or an integral connection; can be mechanically or electrically connected; they may be connected directly or indirectly through intervening media, or they may be interconnected between two elements. The specific meanings of the above terms in the present invention can be understood in specific cases to those skilled 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 in the display list, and generating a new form display field 6 according to the requirements of a user;
reading the display lists in the data set, selecting a plurality of display lists, and simultaneously selecting the plurality of display lists so as to simultaneously add the form display fields 6 into the plurality of display lists;
adding the step list display fields 6 into the selected display lists, and updating the display lists of the data set according to the ID number 7 so that the display lists in the data set generate new form display fields 6;
creating Excel according to requirements, respectively outputting a plurality of display lists added with the display fields 6 of the form to the newly created Excel 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, so that a user can obtain the latest display list to fill in corresponding data;
the method comprises the steps of firstly designing a display latest display list according to a form display field 6 newly added or modified on a Web page, reading and selecting a plurality of display lists in a data set, simultaneously adding the form display field 6 to the display lists, then outputting the display lists to Excel, and generating a latest import template, so that only a corresponding display list needs to be found and the display lists are imported to the import template, the list header of the import template does not need to be adjusted every time, no trouble is caused even if the data volume or the list field is more, 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 steps design a display list, and enter the required form display field 6 in the display list through the following steps:
opening a list design on a form designer;
clicking and inserting in the list design;
inserting the added or changed display fields so that the display list can dynamically generate a required display list;
as shown in FIG. 3, a form designer of an FE business collaboration platform is used, the form designer is firstly opened to select a form model 5, an interface shown in FIG. 4 is displayed, a list of form display fields 6 needing to be added is added at the tail end by clicking and inserting, so that a display list can generate a newly added or modified form display field 6 according to the requirements of a user, a latest display list is designed and displayed, and the operation is simple.
Further, the step of reading the display list in the data set and selecting a plurality of display lists comprises the following steps:
opening a form on a list designer for modeling;
inputting an ID number 7 corresponding to the display list at the query option, and displaying the ID number 7 and a 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 at the query 8 field, the corresponding display list appears at the interface name.
Further, the step of reading the display lists in the data set and selecting a plurality of display lists further comprises the following steps:
clicking to open the list form after the query option is input;
click import;
the import ID number 7 dynamic 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 process, as shown in fig. 6, the form display field 6 is bound to the corresponding ID number 7 at the lower part of the script.
Further, the step of creating Excel according to the requirement, outputting the display lists with the form display field 6 added to the newly created Excel in one-to-one correspondence, and defining the newly created Excel as an import template includes the following steps:
operating Excel by POI, and creating Excel and workbook by HSSFWorkBook;
setting an Excel title according to user requirements;
creating cells and cell contents according to the display list;
and setting the style and the font of the cell.
As shown in fig. 7, the display list is output to Excel through data stream by the import button for the user to download Excel, and finally, an import template is generated as shown in fig. 8.
The present application further provides a system for generating form display fields 6 and outputting the same in batches to an import template, comprising:
display list design module 1: is used for designing a display list and inputting a form display field 6 in the display list;
reading and selecting module 2: the display list reading device is used for reading the display lists in the data set and selecting a plurality of display lists;
adding a module 3: for adding the step list display field 6 to the selected plurality of display lists;
the output and definition module 4: the method is used for creating Excel according to requirements, outputting a plurality of display lists with the form display fields 6 added to the newly created Excel in one-to-one correspondence, and defining the newly created Excel as an import template.
The invention firstly designs and displays the latest display list in the display list design module 1 according to the form display field 6 which is newly added or modified according to the requirement of a user, since each display list corresponds to an ID number 7, a plurality of display lists are read and selected in the reading and selecting module 2, 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 by the adding module 3, the latest import template is generated, therefore, only the corresponding display list needs to be found according to the ID number 7 and the display list is led to the import template, so that the list head of the import template does not need to be adjusted every time, even if the data volume or the list field is more, the trouble can not be 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 display list design module 1 generates through the form designer, opens the list design on the form designer, clicks insertion in the list design, and inserts the added or changed display field, so that the display list can dynamically generate the 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 corresponding list form are displayed, and the ID number 7 and the corresponding list form are displayed.
The above description is only a preferred embodiment of the present invention, and is not intended to limit the technical scope of the present invention, so that any minor modifications, equivalent changes and modifications made to the above embodiment according to the technical spirit of the present invention are within the technical scope of the present invention.
Claims (8)
1. A method for generating form display fields and outputting the form display fields to an import template in batches is characterized in that: the method comprises the following steps:
designing a display list, and inputting required form display fields in the display list;
reading the display lists in the data set, and selecting a plurality of display lists;
adding the form display fields into the selected display lists;
creating Excel according to requirements, respectively outputting a plurality of display lists with added form display fields to the newly created Excel in one-to-one correspondence, and defining the newly created Excel as an import template.
2. The method of claim 1, wherein the method comprises generating form display fields and outputting the form display fields to the import template in batch, and wherein the method comprises the following steps: the steps are to design a display list, and to input required form display fields in the display list through the following steps:
opening a list design on a form designer;
clicking and inserting in the list design;
the added or modified display fields are inserted to enable the display list to dynamically generate the desired display list.
3. The method of claim 2, wherein the method comprises generating form display fields and outputting the form display fields to the import template in batch, and wherein the method comprises the following steps: the step of reading the display list in the data set and selecting a plurality of display lists comprises the following steps:
opening a form on a list designer for modeling;
inputting the 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.
4. The method of claim 3, wherein the method comprises generating form display fields and outputting the form display fields to the import template in batch, and wherein the method comprises the following steps: the step of reading the display lists in the data set and selecting a plurality of display lists further comprises the following steps:
clicking to open the list form after the query option is input;
click import;
the dynamic of importing the ID number is displayed at the OnClick event and the confirmation is clicked.
5. The method of claim 1, wherein the method comprises generating form display fields and outputting the form display fields to the import template in batch, and wherein the method comprises the following steps: the step of creating Excel according to requirements, respectively outputting a plurality of display lists with added form display fields to the newly created Excel in one-to-one correspondence, and defining the newly created Excel as an import template comprises the following steps:
operating Excel by POI, and creating Excel and workbook by HSSFWorkBook;
setting an Excel title according to user requirements;
creating cells and cell contents according to the display list;
and setting the style and the font of the cell.
6. A system for generating form display fields and outputting the form display fields to an import template in batches is characterized in that:
the method comprises the following steps:
display list design module (1): the display field input device is used for designing a display list and inputting a form display field in the display list;
reading and selecting module (2): the display list reading device is used for reading the display lists in the data set and selecting a plurality of display lists;
an addition module (3): the display device is used for adding the form display fields into the selected display lists;
output and definition module (4): the method is used for creating Excel according to requirements, outputting the display lists with the added form display fields to the newly created Excel in one-to-one correspondence, and defining the newly created Excel as an import template.
7. The system of claim 6, wherein the system is configured to generate form display fields and output the form display fields to the import template in bulk, and wherein: the display list design module (1) is generated through a form designer, a list design is opened on the form designer, the list design is inserted by clicking, and the added or changed display fields are inserted, so that the display list can dynamically generate a required display list.
8. The system of claim 7, wherein the system is configured to generate form display fields and output the form display fields to the import template in bulk, and wherein: and opening form modeling on the display list design module (1), inputting the 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.
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 true CN111209732A (en) | 2020-05-29 |
| CN111209732B 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)
| 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 |
-
2019
- 2019-12-26 CN CN201911366106.2A patent/CN111209732B/en active Active
Patent Citations (4)
| 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 |
|---|---|
| CN111209732B (en) | 2023-06-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107807913A (en) | A kind of form design system and method based on web | |
| CN107329747A (en) | A kind of method and device for generating multi-threaded pattern | |
| CN103593456B (en) | Worksheet self-defining method for designing and device | |
| CN102779040B (en) | A kind of method and apparatus generating customizing form | |
| US8176417B2 (en) | Constructing and maintaining web sites | |
| CN110543303B (en) | Visual service platform | |
| CN104281447A (en) | Report form fast generating and issuing system and method | |
| CN114035773A (en) | Configuration-based low-code form development method, system and device | |
| CN106021394A (en) | Website construction method and apparatus | |
| CN106469047A (en) | A kind of list implementation method and device | |
| KR20040077573A (en) | Method and system for converting a schema-based hierarchical data structure into a flat data structure | |
| CN109542556A (en) | A kind of process based on Activiti and list exchange method and system | |
| 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 | |
| CN109710250A (en) | It is a kind of for constructing the visualization engine system and method for user interface | |
| CN103425465A (en) | Electronic medical record document editor | |
| CN106407172A (en) | XML (Extensible Markup Language)-based report generating method | |
| CN109542438A (en) | One kind being based on visual chart development approach | |
| CN116795359A (en) | Method and system for realizing monetary assembly based on vue | |
| CN111209732B (en) | Method and system for generating form display fields and outputting form display fields to import templates in batches | |
| CN106775607A (en) | A kind of method that ICD is automatically generated header file data-interface | |
| CN109614143B (en) | Development method for automatically generating fault flow chart in IETM browser | |
| CN110134926A (en) | A kind of EXCEL introduction method with form validation | |
| CN111191423A (en) | Method and system suitable for on-line editing of official document text | |
| CN112380826B (en) | Formatting electronic form generating method based on text file |
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 |