CN105468575B - List loading method and system based on polymorphic type - Google Patents

List loading method and system based on polymorphic type Download PDF

Info

Publication number
CN105468575B
CN105468575B CN201510808808.7A CN201510808808A CN105468575B CN 105468575 B CN105468575 B CN 105468575B CN 201510808808 A CN201510808808 A CN 201510808808A CN 105468575 B CN105468575 B CN 105468575B
Authority
CN
China
Prior art keywords
information
loading
main
type
special
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
CN201510808808.7A
Other languages
Chinese (zh)
Other versions
CN105468575A (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.)
Goertek Inc
Original Assignee
Goertek Inc
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 Goertek Inc filed Critical Goertek Inc
Priority to CN201510808808.7A priority Critical patent/CN105468575B/en
Publication of CN105468575A publication Critical patent/CN105468575A/en
Application granted granted Critical
Publication of CN105468575B publication Critical patent/CN105468575B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/177Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The present invention provides a kind of list loading method and system based on polymorphic type, method therein includes, the row information in different types of list is sorted out, is extracted;Wherein, row information is classified as two class of main information and specific information, extracts the main information and specific information in each type of list respectively;Field configuration is carried out to the specific information extracted, and preservation is fixed in the main information to extracting;Load the header in each type of list;The fixed main information preserved in row information corresponding with header and the specific information configured by field are loaded according to header.Using the present invention list can be stored and load with the storage and loading method of a kind of list in a front page layout.

Description

Form loading method and system based on multiple types
Technical Field
The invention relates to the technical field of form loading, in particular to a multi-type-based form loading method and system.
Background
Because the company system is divided into different departments, the requirements for the row information in the form are different, and the requirements for the row information in the form are different in different form types in the same department. The existing method is to design line forms according to different types of forms in different departments and process each type independently, so that a plurality of form pages need to be designed in the foreground during development, different storage methods need to be written according to different form backgrounds, and each form in a database has different storage tables for content storage.
When a new type of form needs to be added, the interface needs to be redesigned on the foreground, a new storage method needs to be added on the background, and a storage table of a corresponding type is newly added in the database.
Therefore, the existing method is troublesome to process the newly added type of forms. Therefore, a new form processing method is urgently needed.
Disclosure of Invention
In view of the above problems, it is an object of the present invention to provide a method and system for loading multiple types of forms, so as to solve the above problems pointed out in the background art.
The invention provides a form loading method based on multiple types, which comprises a configuration stage and a loading stage; wherein,
a configuration phase comprising:
classifying and extracting line information in different types of forms; the line information is classified into main information and special information, and the main information and the special information in each type of form are respectively extracted;
carrying out column position configuration on the extracted special information, and fixedly storing the extracted main information;
a loading phase comprising:
loading header information in each type of form;
and loading the main information fixedly stored in the row information corresponding to the header information and the special information configured by the column according to the header information.
The invention also provides a multi-type-based form loading system, which comprises:
the information classification unit is used for classifying the line information in the forms of different types; the line information is classified into main information and special information;
the information extraction unit is used for respectively extracting main information and special information in each type of form;
the column position configuration unit is used for carrying out column position configuration on the extracted special information;
a main information storage unit for fixedly storing the extracted main information;
the head information loading unit is used for loading the head information in each type of form;
and the line information loading unit is used for loading the main information which is fixedly stored in the line information corresponding to the head information and the special information configured by the column according to the head information.
By using the multi-type-based form loading method and system, the line information in the forms of different types is classified into the main information and the special information, the main information is fixedly stored, the special information is subjected to column position configuration, and the fixedly stored main information and the special information subjected to column position configuration are loaded when the forms are loaded, so that the forms can be stored in a foreground page by using a storage method, and the forms are loaded by using a loading method.
To the accomplishment of the foregoing and related ends, one or more aspects of the invention comprise the features hereinafter fully described and particularly pointed out in the claims. The following description and the annexed drawings set forth in detail certain illustrative aspects of the invention. These aspects are indicative, however, of but a few of the various ways in which the principles of the invention may be employed. Further, the present invention is intended to include all such aspects and their equivalents.
Drawings
Other objects and results of the present invention will become more apparent and more readily appreciated as the same becomes better understood by reference to the following description and appended claims, taken in conjunction with the accompanying drawings. In the drawings:
FIG. 1 is a first flowchart of a multi-type based form loading method according to an embodiment of the present invention;
FIG. 2 is a second flowchart of a multi-type based form loading method according to an embodiment of the present invention;
FIG. 3 is a diagram illustrating a logical structure of a multi-type based form loading system according to an embodiment of the present invention.
The same reference numbers in all figures indicate similar or corresponding features or functions.
Detailed Description
In the following description, for purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of one or more embodiments. It may be evident, however, that such embodiment(s) may be practiced without these specific details. In other instances, well-known structures and devices are shown in block diagram form in order to facilitate describing one or more embodiments.
For forms having a structure such as header information and line information, especially, the header information and the line information have similar but different contents, and the problems of entry, storage and loading of such forms can be solved by the present invention.
FIG. 1 shows a first flow of a multi-type based form loading method according to an embodiment of the invention.
As shown in fig. 1, the method for loading a form based on multiple types provided in the embodiment of the present invention includes a configuration stage for configuring a form and a loading stage for loading a configured form.
In the configuration phase of the form, the method comprises the following steps:
step S101: classifying and extracting line information in different types of forms; the line information is classified into main information and special information, and the main information and the special information in each type of form are respectively extracted.
The invention classifies the line information in different types of forms by adopting a probability statistical method. Taking the price check as an example, the head information of the price check records the basic information of the supplier, including the name of the supplier, the currency system of the supplier, the contact, the supplier location, the form category and other information, and the row information of the price check records the related information content of the material, including the name of the material, the ID of the material, the unit without tax, the tax rate of the supplier, the unit with tax, the tax before price reduction, the price reduction rate and other information.
The invention can also adopt other methods to classify the line information in the form, for example, according to the keyword method, etc., but also can manually classify the line information, specify some contents in the line information and classify the contents as main information or special information.
The specific process of classifying the price list is as follows: firstly, different types of price checking lists are collected, the content of the row information in each price checking list is counted to carry out probability counting, a probability value is predefined, if the counted probability value is larger than the predefined probability value, the content of the corresponding row information is classified as main information, and if the counted probability value is smaller than the predefined probability value, the content of the corresponding row information is classified as special information. For example: the row information in each type of price checking list comprises a material name, a material ID, a unit price without tax, a supplier tax rate, a unit price with tax, tax before price reduction, and price reduction rate, and if the material ID in each type of row information and the statistical probability value of the unit price with tax are larger than the predefined probability value, the material ID and the unit price with tax are classified as main information. If the statistical probability value of the price reduction rate in each type of row information is lower than the predefined probability value, the price reduction rate main information or the tax-containing unit price can be artificially classified as the special information.
The main information is the line information of the same part in each form and can be loaded without configuration, and the special information is the line information of different parts of each form and needs to be configured according to the type of each form, so that the special information of each form is loaded.
Step S102: and carrying out column field configuration on the extracted special information, and fixedly storing the extracted main information.
The processes of column allocation of the extracted special information and fixed storage of the extracted main information are not in sequence. The main information is information fixed in each form, and therefore, the main information extracted from the form needs to be fixedly stored, and when being loaded, the main information adopts a fixed loading mode. Since the types of the forms are different, the special information in each form is different, and therefore, field configuration needs to be performed on the special information in each form according to the type of each form, and the special information of each form is dynamically loaded during loading.
The field configuration of the extracted special information is to perform field configuration on the special information in the line information of each type of extracted form, and the configuration contents include but are not limited to:
FIELD_ID main key
FIELD_TITLE Field title (column name)
FIELD_TYPE Field type (field type)Type)
OPTION_VALUES Selecting field value
IS_DISABLED Whether or not to disable
FIELD_REQUIRED Whether it is a required field
SHOW_ORDER Order of arrangement
DEFAULT_VALUE Default value
BU_CODE BU corresponding to custom field
KEY_WORDS Custom field keywords
VALUE_REQUIRED Whether or not a field must be filled
FORM_TYPE Categories of forms
The table can be used for obtaining that the special information in the form is configured according to the specific type of the form, and the special information comprises information such as field names, field types, field default values, whether filling is necessary or not, display sequence and the like.
The extracted main information is fixedly stored, and actually, foreground storage and interface fixation for displaying the main information are performed on the extracted main information, that is, the content of the main information is fixedly stored, displayed and loaded.
After the extracted special information is subjected to column field configuration and the extracted main information is fixedly stored, the configured special information and the fixedly stored main information need to be input into a form input page, and the specific input process comprises the following two parts:
a main information entry section:
and loading the field of the main information after fixed storage into the form entry page.
A special information entry part:
and loading special information corresponding to the form into the form entry page according to the type of the form, wherein the loaded content comprises the content in the form.
The above steps S101-102 are data processing procedures required in the configuration stage of the form.
In the loading phase of the form, the method comprises the following steps:
step S103: the header information in each type of form is loaded.
The form is divided into two parts of header information and line information, and the content of the line information is determined according to the content of the header information, so that the content of the corresponding header information needs to be loaded before the line information is loaded. Specifically, header information of the form is loaded according to the type of the form.
Step S104: and loading the main information and the special information configured by the column according to the head information.
After the header information of the form is loaded, the line information corresponding to the header information is loaded, and the specific process comprises two aspects:
main information aspect:
and loading the field of the main information fixedly stored in the form entry page. Since the main information is fixed information, the loading process is a fixed loading mode.
Special information aspect:
and loading corresponding special information in the form entry page according to the type of the form, wherein the special information is information configured by the field.
Since the type of the form needs to be determined when the special information is loaded, the loading process is a dynamic loading mode, which is different from the fixed loading mode of the main information.
It should be noted that the main information and the special information are loaded and displayed through the same foreground control.
The above steps S103 to S104 are data processing procedures for loading configured forms, after the form is loaded, the user may fill in (that is, fill in the content of the corresponding column) according to the line information of the loaded form, after the fill-in is completed, the filled-in content needs to be stored, the content corresponding to the main information is stored in the main information data table, and when the main information is stored, a main information ID corresponding to the content of the special information is generated and stored in the special information data table together with the main information ID. The main information ID here plays a role of associating the main information with the specific information.
The contents of the special information storage are as follows:
FIELD_ID external key
LINE_ID Master information ID
FIELD_TITLE Field header
FIELD_VALUE Field value
The outer key corresponds to the main key in the special information configuration table, the character title is the field name of the special information, and the field value is the storage value of the field of the special information.
If the user wants to modify the filled-in line information, firstly, the line information needs to be loaded, the column content of the main information is loaded from the main information data table according to the main information ID, and the column content of the special information is loaded from the special information data table; then, the loaded field content is modified.
The foregoing details describe the first process of the multi-type based form loading method provided by the present invention, and in order to more fully describe the multi-type based form loading method provided by the present invention, fig. 2 shows the second process of the multi-type based form loading method according to the embodiment of the present invention.
As shown in fig. 2, the method for loading a form based on multiple types provided by the embodiment of the present invention includes:
step S201: and (5) newly building the form.
And clicking the newly added form by the user in the system, and loading the header information required to be filled in the form.
Step S202: and filling in header information of the form.
And filling the loaded header information.
Step S203: the form type is selected.
According to the type of the form corresponding to the department where the user is located, only the configured form can be selected, namely the form of which the special information is configured can be selected, and the configuration of the special information is a precondition for loading the form.
Step S204: and (5) storing.
And after filling in the header information and selecting the type of the corresponding form, storing the header information of the form.
Step S205: the line list of the form is loaded according to the type and department of the form.
The specific process is as follows:
1. and loading the header information of the form.
2. And acquiring main information and special information in the line information of the form.
The main information is fixedly stored, and the special information is configured by the column.
3. Integrating main information and special information
And integrating the main information and the special information into integral information.
4. The list of rows of the form is loaded.
And transmitting the integrated overall information to a foreground to be displayed on a line list of the form.
Step S206: and loading each form entry page in the line list according to the form type and the department.
The process is to load the main information and the special information in each form entry page.
Steps S201 to S206 describe the second flow of the multi-type based form loading method provided by the present invention in detail, and the flow describes how to create a form.
The foregoing describes in detail the form loading method based on multiple types provided by the present invention. Corresponding to the method, the invention also provides a multi-type-based form loading system.
FIG. 3 illustrates a logical structure of a multi-type based form loading system according to an embodiment of the present invention.
As shown in fig. 3, the multi-type based form loading system 300 according to the embodiment of the present invention includes an information classifying unit 310, an information extracting unit 320, a field configuring unit 330, a main information storing unit 340, a header information loading unit 350, and a line information loading unit 360.
The information classifying unit 310 is configured to classify the line information in the different types of forms; the line information is classified into main information and special information.
The information extraction unit 320 is used to extract the main information and the special information in each type of form, respectively.
The field configuration unit 330 is configured to perform field configuration on the extracted special information.
The main information storage unit 340 is configured to fixedly store the extracted main information.
The header information loading unit 350 is used to load header information in each type of form.
The line information loading unit 360 is configured to load the main information and the special information configured by the field in the line information corresponding to the header information according to the header information.
In addition, the information classifying unit 310 includes a probability statistics module 311, configured to perform probability statistics on the field contents in the row information, where the field contents meeting the predefined probability are classified as main information, and the field contents not meeting the predefined probability are classified as special information.
In addition, the field configuration unit 330 includes a field name configuration module 331 and a field type configuration module 332; the field name configuration module 331 is configured to configure a field name for the special information in the form according to the type of the form; the field type configuration module 332 is configured to configure the field type of the special information in the form according to the type of the form.
In addition, the multi-type based form loading system 300 further includes:
a row information entry unit 370, configured to store the entered main information and the entered special information in respective data tables when row information is entered; the line information entry unit comprises a main information ID generation module 371, which is used for generating a main information ID when the main information is stored in a corresponding data table, and the entered special information and the main information ID are stored in the corresponding data table;
a main information loading unit 380 configured to, when loading the entered line information, obtain and load the entered main information according to the main information ID;
and a special information loading unit 390, configured to, when loading the entered line information, obtain and load the entered special information according to the main information ID.
The above description is only for the specific embodiments of the present invention, but the scope of the present invention is not limited thereto, and any person skilled in the art can easily conceive of the changes or substitutions within the technical scope of the present invention, and all the changes or substitutions should be covered within the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.

Claims (10)

1. A form loading method based on multiple types comprises a configuration stage and a loading stage; wherein,
the configuration phase comprises:
classifying and extracting line information in different types of forms; the line information is classified into main information and special information, and the main information and the special information in each type of form are respectively extracted;
carrying out column position configuration on the extracted special information, and fixedly storing the extracted main information;
the loading phase comprises:
loading header information in each type of form;
and respectively loading main information which is fixedly stored in the row information corresponding to the header information and special information configured by the column according to the header information.
2. The multi-type based form loading method of claim 1, wherein in classifying row information in different types of forms,
and carrying out probability statistics on the column contents in the row information, wherein the column contents meeting the predefined probability are classified as main information, and the column contents not meeting the predefined probability are classified as special information.
3. The multi-type based form loading method according to claim 1, wherein during the field configuration of the extracted special information,
and configuring the field name and the field type according to the type of the form for the special information in the form.
4. The multi-type based form loading method of any one of claims 1-3, further comprising, after loading the row information:
when the row information is recorded, the recorded main information and the recorded special information are respectively stored in respective data tables; when the main information is stored in the corresponding data table, a main information ID is generated, and the recorded special information and the main information ID are stored in the corresponding data table.
5. The multi-type based form loading method of claim 4, further comprising, after entering the row information:
when loading the entered row information, firstly, the entered main information is obtained and loaded according to the main information ID, and then, the entered special information is obtained and loaded according to the main information ID.
6. A multi-type based form loading system comprising:
the information classification unit is used for classifying the line information in the forms of different types; the line information is classified into main information and special information;
the information extraction unit is used for respectively extracting main information and special information in each type of form;
the column position configuration unit is used for carrying out column position configuration on the extracted special information;
a main information storage unit for fixedly storing the extracted main information;
the head information loading unit is used for loading the head information in each type of form;
and the line information loading unit is used for respectively loading the main information which is fixedly stored in the line information corresponding to the header information and the special information configured by the column according to the header information.
7. The multi-type based form loading system of claim 6,
the information classification unit comprises a probability statistics module which is used for carrying out probability statistics on the column content in the row information, the column content meeting the predefined probability is classified as main information, and the column content not meeting the predefined probability is classified as special information.
8. The multi-type based form loading system of claim 7, wherein the field configuration unit comprises:
the field name configuration module is used for configuring the field name of the special information in the form according to the type of the form;
and the field type configuration module is used for configuring the field type of the special information in the form according to the type of the form.
9. The multi-type based form loading system of any one of claims 6-8, further comprising:
the line information recording unit is used for respectively storing the recorded main information and the recorded special information into respective data tables when the line information is recorded; the line information entry unit comprises a main information ID generation module which is used for generating a main information ID when the main information is stored in a corresponding data table, and the entered special information and the main information ID are stored in the corresponding data table together.
10. The multi-type based form loading system of claim 9, further comprising: a main information loading unit and a special information loading unit; wherein,
the main information loading unit is used for acquiring and loading the input main information according to the main information ID when the input row information is loaded;
and the special information loading unit is used for acquiring and loading the input special information according to the main information ID when the input row information is loaded.
CN201510808808.7A 2015-11-19 2015-11-19 List loading method and system based on polymorphic type Active CN105468575B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201510808808.7A CN105468575B (en) 2015-11-19 2015-11-19 List loading method and system based on polymorphic type

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201510808808.7A CN105468575B (en) 2015-11-19 2015-11-19 List loading method and system based on polymorphic type

Publications (2)

Publication Number Publication Date
CN105468575A CN105468575A (en) 2016-04-06
CN105468575B true CN105468575B (en) 2018-05-04

Family

ID=55606294

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201510808808.7A Active CN105468575B (en) 2015-11-19 2015-11-19 List loading method and system based on polymorphic type

Country Status (1)

Country Link
CN (1) CN105468575B (en)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106775667A (en) * 2016-11-30 2017-05-31 福建榕基软件股份有限公司 A kind of many form information Dynamic Display method and devices
CN111367910A (en) * 2020-02-28 2020-07-03 宁波互海科技有限公司 Method for flexibly configuring ship daily newspaper
CN112330266A (en) * 2020-09-30 2021-02-05 山东浪潮通软信息科技有限公司 Document generation method, device and medium

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102880620A (en) * 2011-07-15 2013-01-16 深圳市金蝶友商电子商务服务有限公司 Method for creating spreadsheet
CN102929850A (en) * 2012-09-28 2013-02-13 用友软件股份有限公司 Report data processing device and report data processing method
CN103778234A (en) * 2014-01-26 2014-05-07 北京恒华伟业科技股份有限公司 Report form generating method and device

Family Cites Families (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030050969A1 (en) * 2001-03-20 2003-03-13 Sant Philip Anthony Information integration system
US7742931B2 (en) * 2001-08-20 2010-06-22 Siemens Medical Solutions Usa, Inc. Order generation system and user interface suitable for the healthcare field

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102880620A (en) * 2011-07-15 2013-01-16 深圳市金蝶友商电子商务服务有限公司 Method for creating spreadsheet
CN102929850A (en) * 2012-09-28 2013-02-13 用友软件股份有限公司 Report data processing device and report data processing method
CN103778234A (en) * 2014-01-26 2014-05-07 北京恒华伟业科技股份有限公司 Report form generating method and device

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
用XLL加载宏扩展Excel实现动态报表;乔奕 等;《微机发展》;20040831;第14卷(第8期);第84-86页 *
通用表单处理系统的开发及应用;张彤;《医疗设备信息》;20040630;第19卷(第6期);第20,21,23页 *

Also Published As

Publication number Publication date
CN105468575A (en) 2016-04-06

Similar Documents

Publication Publication Date Title
CN108509485B (en) Data preprocessing method and device, computer equipment and storage medium
CN110163476A (en) Project intelligent recommendation method, electronic device and storage medium
US20150106944A1 (en) Method and device for risk evaluation
CN104240171B (en) Electronic health record generation method and system
CN109242631A (en) Product intelligent recommended method, server and storage medium
US20150032708A1 (en) Database analysis apparatus and method
CN107330796A (en) Modularization generates the data processing method and system of list
CN103765421A (en) Content control method, content control apparatus, and program
CN105468575B (en) List loading method and system based on polymorphic type
US10395417B2 (en) Data plot processing
CN106649334A (en) Conjunction word set processing method and device
CN110276382A (en) Listener clustering method, apparatus and medium based on spectral clustering
US10877989B2 (en) Data conversion system and method of converting data
CN115018588A (en) Product recommendation method and device, electronic equipment and readable storage medium
CN113343109A (en) List recommendation method, computing device and computer storage medium
CN109145307A (en) User portrait recognition method, pushing method, device, equipment and storage medium
CN110909247B (en) Text information pushing method, electronic equipment and computer storage medium
CN110874398B (en) Forbidden word processing method and device, electronic equipment and storage medium
CN112256836A (en) Recording data processing method and device and server
US20140067447A1 (en) Erp transaction recording to api system and method
CN110427492A (en) Generate the method, apparatus and electronic equipment of keywords database
CN111263351B (en) Service processing method, service processing device, electronic device and storage medium
CN107463564A (en) The characteristic analysis method and device of data in server
CN110019828B (en) Knowledge graph-based reference implementation verification method and system
JP7078244B2 (en) Data processing equipment, data processing methods, data processing systems and programs

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
CB02 Change of applicant information

Address after: 261031 Dongfang Road, Weifang high tech Industrial Development Zone, Shandong, China, No. 268

Applicant after: Goertek Inc.

Address before: 261031 Dongfang Road, Weifang high tech Industrial Development Zone, Shandong, China, No. 268

Applicant before: Goertek Inc.

COR Change of bibliographic data
GR01 Patent grant
GR01 Patent grant