CN112016276B - Graphical user-defined form data acquisition system - Google Patents
Graphical user-defined form data acquisition system Download PDFInfo
- Publication number
- CN112016276B CN112016276B CN202011177941.4A CN202011177941A CN112016276B CN 112016276 B CN112016276 B CN 112016276B CN 202011177941 A CN202011177941 A CN 202011177941A CN 112016276 B CN112016276 B CN 112016276B
- Authority
- CN
- China
- Prior art keywords
- information
- cell
- excel
- word
- processing module
- 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
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/151—Transformation
- G06F40/157—Transformation using dictionaries or tables
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Abstract
The invention relates to a graphical user-defined form data acquisition system, which comprises: the system comprises an information acquisition module, an information conversion module, an information processing module and an information storage module, wherein the information acquisition module is used for extracting Excel and Word form data, a mapping relation K1 and a mapping relation K2 are arranged in the information acquisition module, the acquired Excel data and Word data are converted into public form information by utilizing the mapping relation, the information storage module converts the public form information into a visual window containing a form, a user can modify the form in the visual window on line at any time and reversely output the modified data into the Excel data and the Word data, the problem of mutual conversion of the Word and the Excel form in the traditional mode is avoided by unified editing of the public form information, the unified editing is more beneficial to the output of information, and the office efficiency is greatly improved by combining the online editing function with the unified editing.
Description
Technical Field
The invention belongs to the field of data acquisition, and particularly relates to a graphical user-defined form data acquisition system.
Background
With the push of paperless office work, Excel and Word have become the most commonly used two office software, and more application systems relate to the collection of Excel and Word data, wherein the collection of form data is the most commonly used, but the traditional collection system of form data has the following problems:
1. the traditional form data acquisition system does not provide an on-line modification operation window to realize the visualization and on-line modification of form data;
2. the conventional form data acquisition system does not provide a complete form system detection rule, and the system can set form reporters and auditors by self and allow different reporters in the same form to be assigned to different persons for filling.
Disclosure of Invention
The present invention is directed to partially solve the above problems, and therefore the present invention provides a graphical user-defined form data collection system, which includes:
the information acquisition module comprises an Excel form information acquisition unit and a Word form information acquisition unit, wherein the Excel form information acquisition unit is used for acquiring form information in an Excel file, the form information comprises an Excel form information set U (Ui, Uj, Uij), i is 1,2.. n, j is 1,2.. n, wherein Ui represents an i-th line of the Excel table, Uj represents a j-th column of the Excel table, Uij represents a j-th line and j represents a j-th column information content of the i-th line, and the Excel form information set U (Ui, Uj, Uij) is sent to the information conversion module, the Word form information acquisition unit is used for acquiring form information in the Word file, the form information comprises a Word form information set W (Wi, Wj, Wij), wherein the i-th line of the Word table, Wj represents a j-th column of the Word table, the Wij represents the i-th line and the Wij-th column information set W (Wi, W) represents the i-th line and the W information set, wj, Wij) to the information conversion module;
an information conversion module connected with the information acquisition module and used for finishing data exchange in real time, wherein an Excel form information conversion mapping relation K1 and a Word form information conversion mapping relation K2 are pre-established in the information conversion module, and after receiving information sent by the information acquisition module, the information conversion module converts an Excel form information set U (Ui, Uj, Uij) into a public form information set G (Gi, Gj, Gij) through the information conversion mapping relation K1, wherein Gi represents the ith line of a public form, Gj represents the jth line of the public form, Gij represents the ith line and jth column of public form information, or/and converts information in the Word form information set W (Wi, Wj, Wij) into the public form information set G (Gi, Gj, j) through the Word form information conversion mapping relation K2, wherein, gi represents the ith line of the public form, Gj represents the jth line of the public form, Gij represents the ith line and the jth column of the public form information;
an information processing module, which is connected with the information conversion module and completes data exchange in real time, when the information processing module receives a public form information set G (Gi, Gj, Gij) sent by the information conversion module, the public form information set G (Gi, Gj, Gij) is converted into an online visual window, the online visual window at least comprises a form for embodying the public form information set G (Gi, Gj, Gij), the information processing module provides functions of increasing or decreasing the number of lines and columns of the form of the online visual window and viewing, modifying, storing and deleting the contents corresponding to the lines and columns of the form, and after the form operation is completed, the information processing module can send the public form information set G (Gi, Gj, Gij) to the information conversion module for reverse conversion, meanwhile, determining auditor information F3 of the form, determining reporter information F2 of the form, determining modification time T of the form, generating an editing process information matrix F (F2, F3, T, G), encrypting the editing process information matrix F (F2, F3, T, G), and storing the editing process information matrix F (F2, F3, T, G) into a database, wherein F2 represents the reporter information, F3 represents the auditor information, T represents the form modification time, and G represents a public form information set G (Gi, Gj, Gij);
and the data storage module comprises a database used for storing the user information and the information generated in the form modification process.
Further, when the Excel form information conversion mapping relation K1 is pre-established, a public information public form information database needs to be pre-established, wherein the public information public form information database at least comprises cell public character information T1, cell public font information T2, cell public formula information T4, cell public color information T5 and cell public linked list information T6.
Further, the information conversion module at least includes, when establishing an Excel form information conversion mapping relationship K1, establishing a mapping relationship Y1 for converting Excel cell text information into cell common text information T1, establishing a mapping relationship Y2 for converting Excel cell font information into cell common font information T2, establishing a mapping relationship Y4 for converting Excel cell common formula information into cell common formula information T4, establishing a mapping relationship Y5 for converting Excel cell color information into cell common color information T5, and establishing a mapping relationship Y6 for converting Excel cell list information into cell common list information T6.
Further, when establishing Word form information conversion mapping relation K2, the method at least comprises establishing mapping relation Y1 for converting Word cell text information into cell common text information T1, establishing mapping relation Y2 for converting Word cell font information into cell common font information T2, establishing mapping relation Y4 for converting Word cell formula information into cell common formula information T4, establishing mapping relation Y5 for converting Word cell color information into cell common color information T5, and establishing mapping relation Y6 for converting Word cell chain list information into cell common chain list information T6.
Further, the process of establishing the form of the visual window includes constructing a form with i rows and i columns according to the total row number i and the total column number j represented in G (Gi, Gj, Gij), extracting cell text information and cell format information in the i-th row and j-th column of common form information Gij, embodying the text information to corresponding cells of the form, and adjusting the size of the cells.
Further, the visualization window provided by the information processing module includes a multi-user filling function, when the multi-user filling is performed, the information processing module selects a pre-modification area in the form, generates a modification area matrix X (Xi, Xj, Xij), where Xi represents an ith row, Xj represents a jth column, Xij represents an ith row, and jth column unit cell information, the modification area matrix X (Xi, Xj, Xij) is sent to a specified user, the information processing module receives the modification area matrix X (Xi, Xj, Xij) and generates a corresponding multi-user modification form, the information processing module generates a modified modification area matrix X (Xi, Xj, Xij) after the form is modified, and returns the modification area matrix X (Xi, Xj, Xij) to an auditor, the information processing module receives the returned modification area matrix X (Xi, xj, Xij), replacing the information in the common form information set G (Gi, Gj, Gij) with the content information of the cell corresponding to the row, column and row, column represented by the returned modified area matrix X (Xi, Xj, Xij).
Further, an ith byte selection matrix Zi (Zi1, Zi2) is arranged inside the information processing module, i is 1,2.. n, Zi1 represents an ith preset data size interval, Zi2 represents the number of bytes, the information processing module encrypts the editing process information matrix F (F2, F3, T, G) by using a symmetric encryption method, the information processing module obtains the size D of the form data, the information processing module matches the size D of the form data with data in the ith byte selection matrix Zi (Zi1, Zi2), if the size D of the form data belongs to the ith preset data size interval, the number of bytes of ciphertext k is determined as Zi2, and after the number of bytes is determined, the information processing module extracts a first byte Q1 of characters in a first row and a first column of cells of the form as a first byte of ciphertext k, taking the second byte Q2 of the characters in the cell as the last byte of a ciphertext k, sequentially determining the 2 nd, 3 rd.. Zi2-1 th byte of the ciphertext k to generate a complete ciphertext, calculating the ith marking parameter gi according to the following formula by the information processing module,
wherein: q1 represents the first byte of the first row and column of cell letters, Zi2 represents the number of bytes, α represents a parameter, α is 2, 3.. Zi 2-1; sequentially changing the parameters α -2, 3.. Zi2-1 to generate all ith marking parameters gi, and taking the ith marking parameter g1 as the second byte of the ciphertext k.. take the nth marking parameter gn as the Zi2-1 byte of the ciphertext k.
Further, when the public form information set G (Gi, Gj, Gij) is reversely converted, the form information set G (Gi, Gj, Gij) is converted into the Excel form information set U (Ui, Uj, Uij) by using the mapping relationship K1, and the form information set G (Gi, Gj, Gij) is converted into the Word form information set W (Wi, Wj, Wij) by using the mapping relationship K2.
Compared with the prior art, the invention has the technical effects that the invention comprises an information acquisition module, an information conversion module, an information processing module and an information storage module, wherein the information acquisition module is used for extracting Excel and Word form data, the information acquisition module is internally provided with a mapping relation K1 and a mapping relation K2, the acquired Excel data and Word data are converted into a public form information set G (Gi, Gj, Gij) by utilizing the mapping relation, the information storage module converts the public form information set G (Gi, Gj, Gij) into a visual window containing forms, a user can modify the forms in the visual window on line at any time, reversely output the modified data into the Excel data and the Word data, and integrate the Word and the Excel into the public form information set G (Gi, Gj, Gij) through the mapping relation, thereby improving the use experience of the user, the problem of mutual conversion between Word forms and Excel forms in the traditional mode is solved by uniformly editing the public form information set G (Gi, Gj, Gij), the uniform editing is more beneficial to information output, the office efficiency is greatly improved by combining the online editing function with the uniform editing, and the public form information set G (Gi, Gj, Gij), the reporter and the auditor are encrypted and stored, so that the follow-up transfer of form data is facilitated, and the information safety is improved.
In particular, the information conversion module of the present invention establishes the common form information database, and the common form information database at least includes: the cell common character information T1, the cell common font information T2, the cell common format information T3, the cell common formula information T4, the cell common color information T5 and the cell common link list information T6 are arranged in a common database and comprise the parameters which are representative of the cell information, and are convenient to obtain and convert and convenient to process subsequently.
Particularly, the information conversion module establishes the conversion relation K1 and the conversion relation K2 to unify the Excel and Word form information into the common form information, generates the common form information set G (Gi, Gj, Gij), unifies the common form, facilitates the conversion and output of the processing information, edits and processes the common form data, and then converts the common form data, greatly improves the office efficiency, and simultaneously avoids the problem of difficult conversion of the Excel and Word information.
Particularly, the information processing module of the invention establishes an online visual window according to the public form information set G (Gi, Gj, Gij), the visual window at least comprises a form for embodying the public form information set G (Gi, Gj, Gij), a user can modify the form online, meanwhile, multiple persons can modify different positions of the form simultaneously, the form is converted into Excel and Word formats after the processing is finished, the form is modified online, the office efficiency is greatly improved, the unified modification is convenient for converting files with multiple formats, and the problem of difficult conversion of Excel and Word forms is avoided.
Particularly, the invention integrates, stores and encrypts the reviewer, the filler and the form modification information, sets a specific encryption algorithm, facilitates the subsequent root tracing by processing the form, and improves the data security.
Drawings
Fig. 1 is a structural block diagram of a data collection system for a graphical user-defined form according to an embodiment of the present invention.
Detailed Description
The above and further features and advantages of the present invention are described in more detail below with reference to the accompanying drawings.
Preferred embodiments of the present invention are described below with reference to the accompanying drawings. It should be understood by those skilled in the art that these embodiments are only for explaining the technical principle of the present invention, and are not intended to limit the scope of the present invention.
It should be noted that in the description of the present invention, the terms of direction or positional relationship indicated by the terms "upper", "lower", "left", "right", "inner", "outer", etc. are based on the directions or positional relationships shown in the drawings, which are only for convenience of description, and do not indicate or imply that the device or element must have a specific orientation, be constructed in a specific orientation, and be operated, and thus, should not be construed as limiting the present invention.
Furthermore, it should be noted that, in the description of the present invention, unless otherwise explicitly specified or limited, the terms "mounted," "connected," and "connected" are to be construed broadly, and may be, for example, fixedly connected, detachably connected, or integrally 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 by those skilled in the art according to specific situations.
Referring to fig. 1, it is a structural block diagram of a graphical user-defined form data acquisition system according to an embodiment of the present invention, and the graphical user-defined form data acquisition system according to the embodiment includes:
the information acquisition module comprises an Excel form information acquisition unit and a Word form information acquisition unit, wherein the Excel form information acquisition unit is used for acquiring form information in an Excel file, the form information comprises an Excel form information set U (Ui, Uj, Uij), i is 1,2.. n, j is 1,2.. n, wherein Ui represents an i-th line of the Excel table, Uj represents a j-th column of the Excel table, Uij represents a j-th line and j represents a j-th column information content of the i-th line, and the Excel form information set U (Ui, Uj, Uij) is sent to the information conversion module, the Word form information acquisition unit is used for acquiring form information in the Word file, the form information comprises a Word form information set W (Wi, Wj, Wij), wherein the i-th line of the Word table, Wj represents a j-th column of the Word table, the Wij represents the i-th line and the Wij-th column information set W (Wi, W) represents the i-th line and the W information set, wj, Wij) to the information conversion module;
an information conversion module connected with the information acquisition module and used for finishing data exchange in real time, wherein an Excel form information conversion mapping relation K1 and a Word form information conversion mapping relation K2 are pre-established in the information conversion module, and after receiving information sent by the information acquisition module, the information conversion module converts an Excel form information set U (Ui, Uj, Uij) into a public form information set G (Gi, Gj, Gij) through the information conversion mapping relation K1, wherein Gi represents the ith line of a public form, Gj represents the jth line of the public form, Gij represents the ith line and jth column of public form information, or/and converts information in the Word form information set W (Wi, Wj, Wij) into the public form information set G (Gi, Gj, j) through the Word form information conversion mapping relation K2, wherein, gi represents the ith line of the public form, Gj represents the jth line of the public form, Gij represents the ith line and the jth column of the public form information;
an information processing module, which is connected with the information conversion module and completes data exchange in real time, when the information processing module receives a public form information set G (Gi, Gj, Gij) sent by the information conversion module, the public form information set G (Gi, Gj, Gij) is converted into an online visual window, the online visual window at least comprises a form for embodying the public form information set G (Gi, Gj, Gij), the information processing module provides functions of increasing or decreasing the number of lines and columns of the form of the online visual window and viewing, modifying, storing and deleting the contents corresponding to the lines and columns of the form, and after the form operation is completed, the information processing module can send the public form information set G (Gi, Gj, Gij) to the information conversion module for reverse conversion, meanwhile, determining auditor information F3 of the form, determining reporter information F2 of the form, determining modification time T of the form, generating an editing process information matrix F (F2, F3, T, G), encrypting the editing process information matrix F (F2, F3, T, G), and storing the editing process information matrix F (F2, F3, T, G) into a database, wherein F2 represents the reporter information, F3 represents the auditor information, T represents the form modification time, and G represents a public form information set G (Gi, Gj, Gij);
and the data storage module comprises a database used for storing the user information and the information generated in the form modification process.
Specifically, when the Excel form information conversion mapping relation K1 is pre-established, a public information public form information database needs to be pre-established, wherein the public information public form information database at least comprises cell public character information T1, cell public font information T2, cell public formula information T4, cell public color information T5 and cell public linked list information T6.
Specifically, the information conversion module at least comprises, when establishing an Excel form information conversion mapping relation K1, establishing a mapping relation Y1 for converting Excel cell text information into cell common text information T1, establishing a mapping relation Y2 for converting Excel cell font information into cell common font information T2, establishing a mapping relation Y4 for converting Excel cell common formula information into cell common formula information T4, establishing a mapping relation Y5 for converting Excel cell color information into cell common color information T5, and establishing a mapping relation Y6 for converting Excel cell linked list information into cell common linked list information T6.
Specifically, the method at least comprises the steps of establishing a mapping relation Y1 for converting Word cell character information into cell common character information T1, establishing a mapping relation Y2 for converting Word cell font information into cell common font information T2, establishing a mapping relation Y4 for converting Word cell formula information into cell common formula information T4, establishing a mapping relation Y5 for converting Word cell color information into cell common color information T5, and establishing a mapping relation Y6 for converting Word cell chain list information into cell common chain list information T6 when establishing the Word form information conversion mapping relation K2.
Specifically, the establishing process when establishing the form of the visual window comprises the steps of establishing a form with i rows and i columns according to the total row number i and the total column number j represented in G (Gi, Gj, Gij), extracting cell character information and cell format information in the i row and the j column of public form information Gij, embodying the character information to corresponding cells of the form, and adjusting the size of the cells.
Specifically, the visual window provided by the information processing module includes a multi-user filling function, when the multi-user filling is performed, the information processing module selects a pre-modification area in the form, generates a modification area matrix X (Xi, Xj, Xij), where Xi represents the ith row, Xj represents the jth column, and Xij represents the ith row and jth column unit lattice information, the modification area matrix X (Xi, Xj, Xij) is sent to a specified user, the information processing module receives the modification area matrix X (Xi, Xj, Xij) and generates a corresponding multi-user modification form, the information processing module generates a modified modification area matrix X (Xi, Xj, Xij) after the form is modified, and returns the modification area matrix X (Xi, Xj, Xij) to an auditor, the information processing module receives the returned modification area matrix X (Xi, xj, Xij), replacing the information in the common form information set G (Gi, Gj, Gij) with the content information of the cell corresponding to the row, column and row, column represented by the returned modified area matrix X (Xi, Xj, Xij).
Specifically, an ith byte selection matrix Zi (Zi1, Zi2) is arranged inside the information processing module, i is 1,2.. n, Zi1 represents an ith preset data size interval, Zi2 represents the number of bytes, the information processing module adopts a symmetric encryption method when encrypting the editing process information matrix F (F2, F3, T, G), the information processing module obtains the size D of the form data, the information processing module matches the size D of the form data with data in the ith byte selection matrix Zi (Zi1, Zi2), if the size D of the form data belongs to the ith preset data size interval, the number of bytes of ciphertext k is determined as Zi2, and after the information processing module determines the number of bytes, the first byte Q1 in the first row and the first column of characters of the form is extracted as a first byte of ciphertext k by the information processing module, taking the second byte Q2 of the characters in the cell as the last byte of a ciphertext k, sequentially determining the 2 nd, 3 rd.. Zi2-1 th byte of the ciphertext k to generate a complete ciphertext, calculating the ith marking parameter gi according to the following formula by the information processing module,
wherein: q1 represents the first byte of the first row and column of cell letters, Zi2 represents the number of bytes, α represents a parameter, α is 2, 3.. Zi 2-1; sequentially changing the parameters α to 2, 3.. Zi2-1 to generate all ith marking parameters gi, and taking the 1 st marking parameter g1 as the second byte of the ciphertext k.. taking the nth marking parameter gn matrix as the Zi2-1 byte of the ciphertext k.
Specifically, when the common form information set G (Gi, Gj, Gij) is reversely converted, the form information set G (Gi, Gj, Gij) is converted into the Excel form information set U (Ui, Uj, Uij) by using the mapping relationship K1, and the form information set G (Gi, Gj, Gij) is converted into the Word form information set W (Wi, Wj, Wij) by using the mapping relationship K2.
So far, the technical solutions of the present invention have been described in connection with the preferred embodiments shown in the drawings, but it is easily understood by those skilled in the art that the scope of the present invention is obviously not limited to these specific embodiments. Equivalent changes or substitutions of related technical features can be made by those skilled in the art without departing from the principle of the invention, and the technical scheme after the changes or substitutions can fall into the protection scope of the invention.
Claims (8)
1. A graphical user-defined form data acquisition system, comprising:
the information acquisition module comprises an Excel form information acquisition unit and a Word form information acquisition unit, wherein the Excel form information acquisition unit is used for acquiring form information in an Excel file, the form information comprises an Excel form information set U (Ui, Uj, Uij), i is 1,2.. n, j is 1,2.. n, wherein Ui represents an i-th line of the Excel table, Uj represents a j-th column of the Excel table, Uij represents a j-th line and j represents a j-th column information content of the i-th line, and the Excel form information set U (Ui, Uj, Uij) is sent to the information conversion module, the Word form information acquisition unit is used for acquiring form information in the Word file, the form information comprises a Word form information set W (Wi, Wj, Wij), wherein the i-th line of the Word table, Wj represents a j-th column of the Word table, the Wij represents the i-th line and the Wij-th column information set W (Wi, W) represents the i-th line and the W information set, wj, Wij) to the information conversion module;
the information conversion module is connected with the information acquisition module and completes data exchange in real time, an Excel form information conversion mapping relation K1 and a Word form information conversion mapping relation K2 are pre-established in the information conversion module, and after receiving information sent by the information acquisition module, the information conversion module converts an Excel form information set U (Ui, Uj, Uij) into a public form information set G (Gi, Gj, Gij) through the information conversion mapping relation K1, wherein Gi represents the ith line of a public form, Gj represents the jth line of the public form, and Gij represents the ith line and the jth column of public form information, or/and converts information in the Word form information set W (Wi, Wj, Wij) into the public form information set G (Gi, Gj, Gij) through the Word form information conversion mapping relation K2;
an information processing module, which is connected with the information conversion module and completes data exchange in real time, when the information processing module receives a public form information set G (Gi, Gj, Gij) sent by the information conversion module, the public form information set G (Gi, Gj, Gij) is converted into an online visual window, the online visual window at least comprises a form for embodying the public form information set G (Gi, Gj, Gij), the information processing module provides functions of increasing or decreasing the number of lines and columns of the form of the online visual window and viewing, modifying, storing and deleting the contents corresponding to the lines and columns of the form, and after the form operation is completed, the information processing module can send the public form information set G (Gi, Gj, Gij) to the information conversion module for reverse conversion, meanwhile, determining auditor information F3 of the form, determining landfilling information F2 of the form, determining modification time T of the form, generating an editing process information matrix F (F2, F3, T, G), encrypting the editing process information matrix F (F2, F3, T, G) and storing the encrypted editing process information matrix F (F2, F3, T, G) in a database, wherein G represents a public form information set G (Gi, Gj, Gij);
and the data storage module comprises a database used for storing the user information and the information generated in the form modification process.
2. The system of claim 1, wherein the information transformation module is configured to pre-establish a common form information database when establishing the Excel form information transformation mapping relationship K1 and the Word form information transformation mapping relationship K2, wherein the common form information database at least comprises cell common text information T1, cell common font information T2, cell common formula information T4, cell common color information T5, and cell common information linked list T6.
3. The system of claim 2, wherein the information transformation module, when establishing the mapping relationship K1 for Excel form information transformation, at least comprises establishing a mapping relationship Y1 for transforming Excel cell text information into the cell common text information T1, establishing a mapping relationship Y2 for transforming Excel cell font information into the cell common font information T2, establishing a mapping relationship Y4 for transforming Excel cell common formula information T4, establishing a mapping relationship Y5 for transforming Excel cell color information into the cell common color information T5, and establishing a mapping relationship Y6 for transforming Excel cell link list information into the cell common link list information T6.
4. The system of claim 3, wherein the information transformation module, when establishing a Word form information transformation mapping K2, at least comprises establishing a mapping Y1 for transforming Word cell text information into the cell common text information T1, establishing a mapping Y2 for transforming Word cell font information into the cell common font information T2, establishing a mapping Y4 for transforming Word cell formula information into the cell common formula information T4, establishing a mapping Y5 for transforming Word cell color information into the cell common color information T5, and establishing a mapping Y6 for transforming Word cell linked list information into the cell common linked list information T6.
5. The system of claim 1, wherein the information processing module, when building the form of the visualization window, builds a form with i rows and j columns according to the total row number i and the total column number j indicated in G (Gi, Gj, Gij), extracts the text information of the cells and the format information of the cells in the common form information Gij of the i row and the j column to embody the text information to the corresponding cells of the form, and adjusts the size of the cells.
6. The system of claim 1, wherein the visualization window provided by the information processing module includes a multi-user filling function, and when the multi-user filling is performed, the information processing module selects a pre-modification area in the form to generate a modification area matrix X (Xi, Xj, Xij), where Xi represents an ith row, Xj represents a jth column, Xij represents an ith row, and jth column of cell information, and the modification area matrix X (Xi, Xj, Xij) is sent to a specified user, the information processing module receives the modification area matrix X (Xi, Xj, Xij) and generates a corresponding multi-user modification form, and after the form is modified, the information processing module generates a modified modification area matrix X (Xi, Xj, Xij), and sends the modification area matrix X (Xi, and Xj, Xij) is returned to the auditor, and when the information processing module receives the returned modified area matrix X (Xi, Xj, Xij), the information processing module replaces the information in the common form information set G (Gi, Gj, Gij) by the content information of the lines and the columns and the cell corresponding to the lines and the columns represented by the returned modified area matrix X (Xi, Xj, Xij).
7. The system of claim 1, wherein an ith byte selection matrix Zi (Zi1, Zi2) is provided inside the information processing module, i is 1,2.. n, Zi1 represents an ith preset data size interval, Zi2 represents the number of bytes, the information processing module encrypts the edit process information matrix F (F2, F3, T, G) by using a symmetric encryption method, the information processing module obtains the size D of the common form data, the information processing module matches the size D of the form data with the data in the ith byte selection matrix Zi (Zi1, Zi2), determines the number of bytes of ciphertext k as Zi2 if the form data size D belongs to the ith preset data size interval, and after determining the number of bytes, the information processing module extracts a first byte Q1 in a first row of first column cells of the common form as ciphertext as a first ciphertext word Q1 k, taking the second byte Q2 of the characters in the cell as the last byte of the ciphertext k, sequentially determining the 2 nd, 3 rd.. Zi2-1 th byte of the ciphertext k to generate a complete ciphertext, calculating the i th marking parameter gi according to the following formula by the information processing module,
wherein: q1 represents the first byte of the first row and column of cell letters, Zi2 represents the number of bytes, α represents a parameter, α is 2, 3.. Zi 2-1; sequentially changing the parameters α -2, 3.. Zi2-1 to generate all ith marking parameters gi, and taking the first marking parameter g1 as the second byte of the ciphertext k.. take the nth marking parameter gn as the Zi2-1 byte of the ciphertext k.
8. The system of claim 1, wherein the information conversion module converts the form information set G (Gi, Gj, Gij) into the Excel form information set U (Ui, Uj, Uij) by using the mapping relationship K1 when performing the reverse conversion on the common form information set G (Gi, Gj, Gij), and converts the form information set G (Gi, Gj, Gij) into the Word form information set W (Wi, Wj, Wij) by using the mapping relationship K2.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011177941.4A CN112016276B (en) | 2020-10-29 | 2020-10-29 | Graphical user-defined form data acquisition system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011177941.4A CN112016276B (en) | 2020-10-29 | 2020-10-29 | Graphical user-defined form data acquisition system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112016276A CN112016276A (en) | 2020-12-01 |
| CN112016276B true CN112016276B (en) | 2021-02-26 |
Family
ID=73528151
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011177941.4A Active CN112016276B (en) | 2020-10-29 | 2020-10-29 | Graphical user-defined form data acquisition system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112016276B (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107256265A (en) * | 2017-06-14 | 2017-10-17 | 成都四方伟业软件股份有限公司 | A kind of search-engine results data visualization methods of exhibiting and system |
| CN109815447A (en) * | 2019-01-10 | 2019-05-28 | 浙江小泰科技有限公司 | A kind of Word list Schema processing system |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040024532A1 (en) * | 2002-07-30 | 2004-02-05 | Robert Kincaid | Method of identifying trends, correlations, and similarities among diverse biological data sets and systems for facilitating identification |
| CN101197875A (en) * | 2007-12-26 | 2008-06-11 | 华为技术有限公司 | Partial data checking method and device |
| CN110688343B (en) * | 2019-08-26 | 2023-04-28 | 天津开心生活科技有限公司 | Method and device for converting data format |
| CN111177591B (en) * | 2019-12-10 | 2023-09-29 | 深圳市数康云信息技术有限公司 | Knowledge graph-based Web data optimization method for visual requirements |
-
2020
- 2020-10-29 CN CN202011177941.4A patent/CN112016276B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107256265A (en) * | 2017-06-14 | 2017-10-17 | 成都四方伟业软件股份有限公司 | A kind of search-engine results data visualization methods of exhibiting and system |
| CN109815447A (en) * | 2019-01-10 | 2019-05-28 | 浙江小泰科技有限公司 | A kind of Word list Schema processing system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112016276A (en) | 2020-12-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2019148852A1 (en) | Chemical information identification method based on deep learning image identification technology | |
| CN107368967A (en) | Engineering safety quality inspection intelligent management based on internet | |
| CN113325816A (en) | Industrial Internet-oriented digital twin body data management method | |
| CN103246951A (en) | Intelligent electromechanical equipment management system and method based on BIM (building information modeling) | |
| CN102496083B (en) | Credit rating report manuscript manufacturing method | |
| CN115129879A (en) | Method for constructing enterprise relational knowledge base based on knowledge graph | |
| CN108960963A (en) | A kind of architectural design management system and method | |
| CN102915476A (en) | Visual business process design method | |
| CN110175741A (en) | A kind of information value chain construction method and storage medium based on power industry | |
| CN112016276B (en) | Graphical user-defined form data acquisition system | |
| CN112446683A (en) | Contract performance information management and control system | |
| CN107122961A (en) | Excel nested report data processing methods based on SAP system | |
| CN109711799A (en) | Guide the teaching software and its operation method of the standardization office of administration hilllock | |
| CN115827885A (en) | Operation and maintenance knowledge graph construction method and device and electronic equipment | |
| CN103325078A (en) | On-site examination mobility and controllability marking method and system based on tablet computers | |
| CN103336865A (en) | Dynamic communication network construction method and device | |
| CN108805586A (en) | The platform of production analysis, data analysis | |
| CN104090872A (en) | Service-based situation collaborative plotting system and method | |
| WO2020249039A1 (en) | Space data system, method, computer device, and storage medium | |
| CN105373996A (en) | Modeling system based on approval data | |
| CN111783391A (en) | Online artificial text marking system and method | |
| CN111625616A (en) | Enterprise-level data management system capable of realizing mass storage | |
| CN111178615A (en) | Construction method and system of enterprise risk identification model | |
| CN111552718B (en) | Interactive intelligent power auditing method containing process information | |
| CN113642336B (en) | SaaS-based insurance automatic question-answering method and system |
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 |