CN112016276A - Graphical user-defined form data acquisition system - Google Patents
Graphical user-defined form data acquisition system Download PDFInfo
- Publication number
- CN112016276A CN112016276A CN202011177941.4A CN202011177941A CN112016276A CN 112016276 A CN112016276 A CN 112016276A CN 202011177941 A CN202011177941 A CN 202011177941A CN 112016276 A CN112016276 A CN 112016276A
- Authority
- CN
- China
- Prior art keywords
- information
- cell
- public
- excel
- mapping relation
- 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
-
- 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 World form data, a mapping relation K1 and a mapping relation K2 are arranged in the information acquisition module, the acquired Excel data and the World 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 World data, the problem of mutual conversion of the World form and the Excel form in the traditional mode is solved 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 World have become the two most commonly used office software, and more application systems involve the collection of Excel and World 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 World form information acquisition unit, 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 =1,2.. n, j =1,2.. n, wherein Ui represents the ith row of the Excel table, Uj represents the jth column of the Excel table, Uij represents the information content of the ith row and the jth column, and sending the Excel form information set U (Ui, Uj, Uij) to an information conversion module, the World form information acquisition unit is used for acquiring form information in a World file, the form information comprises a World form information set W (Wi, Wj, Wij), wherein Wi represents the ith row of the World table, Wj represents the jth column of the World table, sending the World form information set W (Wi, 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 World 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 the 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 the 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 World form information set W (Wi, Wj, Wij) into the public form information set G (Gi, Gj, j) through the World 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 format information T3, cell public formula information T4, cell public color information T5 and cell public linked list information T6.
Further, the information conversion module, when establishing an Excel form information conversion mapping relationship K1, at least includes 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 Y3 for converting Excel cell format information into cell common format information T3, establishing a mapping relationship Y4 for converting Excel cell format 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 link list information into cell common formula information T6.
Further, the establishing of the World form information conversion mapping relation K1 at least includes establishing a mapping relation Y1 for converting the World cell text information into the cell common text information T1, establishing a mapping relation Y2 for converting the World cell font information into the cell common font information T2, establishing a mapping relation Y3 for converting the World cell format information into the cell common format information T3, establishing a mapping relation Y4 for converting the World cell formula information into the cell common formula information T4, establishing a mapping relation Y5 for converting the World cell color information into the cell common color information T5, and establishing a mapping relation Y6 for converting the World cell linked list information into the cell common color linked 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 (Zi 1, Zi 2) is arranged inside the information processing module, i =1,2.. n, where 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 (F1, 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 (Zi 1, Zi 2), 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 of ciphertext 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 Q1 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, a represents a parameter, a =2, 3.. Zi 2-1; sequentially changing the parameters α =2, 3.. Zi2-1 to generate all ith parameter matrices gi, taking a first parameter matrix g1 as a second byte of the ciphertext k, and taking a second parameter matrix g1 as a second bit 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 World 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 World form data, the information acquisition module is internally provided with a mapping relation K1 and a mapping relation K2, the acquired Excel data and World 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 a form, a user can modify the form in the visual window on line at any time, reversely output the modified data into the Excel data and the World data, integrate the World and the Excel into the public form information set G (Gi, Gj, Gij) through the mapping relation, and improve the use experience of the user, the problem of mutual conversion between World tables and Excel tables 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 Excel and World form information into common form information, generates a common form information set G (Gi, Gj, Gij), unifies the common form, facilitates the conversion and output of processing information, edits and processes common form data, and then converts the common form data, greatly improves the office efficiency, and simultaneously avoids the problem of difficulty in converting Excel and World 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, a plurality of persons can modify different positions of the form simultaneously, the form is converted into Excel and World 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 various formats, and the problem of difficult conversion of the Excel and World 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 World form information acquisition unit, 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 =1,2.. n, j =1,2.. n, wherein Ui represents the ith row of the Excel table, Uj represents the jth column of the Excel table, Uij represents the information content of the ith row and the jth column, and sending the Excel form information set U (Ui, Uj, Uij) to an information conversion module, the World form information acquisition unit is used for acquiring form information in a World file, the form information comprises a World form information set W (Wi, Wj, Wij), wherein Wi represents the ith row of the World table, Wj represents the jth column of the World table, sending the World form information set W (Wi, 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 World 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 the 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 the 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 World form information set W (Wi, Wj, Wij) into the public form information set G (Gi, Gj, j) through the World 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 format information T3, 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 Y3 for converting Excel cell format information into cell common format information T3, establishing a mapping relation Y4 for converting Excel cell common format 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 link list information into cell common link list information T6.
Specifically, the establishing of the World form information conversion mapping relation K1 at least includes establishing a mapping relation Y1 for converting the World cell text information into the cell common text information T1, establishing a mapping relation Y2 for converting the World cell font information into the cell common font information T2, establishing a mapping relation Y3 for converting the World cell format information into the cell common format information T3, establishing a mapping relation Y4 for converting the World cell formula information into the cell common formula information T4, establishing a mapping relation Y5 for converting the World cell color information into the cell common color information T5, and establishing a mapping relation Y6 for converting the World cell linked list information into the cell common linked list information T6.
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 (Zi 1, Zi 2) is arranged in the information processing module, i =1,2.. n, wherein 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 (F1, 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 (Zi 1, Zi 2), 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, a represents a parameter, a =2, 3.. Zi 2-1; sequentially changing the parameters α =2, 3.. Zi2-1 to generate all ith parameter matrices gi, taking a first parameter matrix g1 as a second byte of the ciphertext k, and taking a second parameter matrix g1 as a second bit of the ciphertext k.
Specifically, 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 World 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 World form information acquisition unit, 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 =1,2.. n, j =1,2.. n, wherein Ui represents the ith row of the Excel table, Uj represents the jth column of the Excel table, Uij represents the information content of the ith row and the jth column, and sending the Excel form information set U (Ui, Uj, Uij) to an information conversion module, the World form information acquisition unit is used for acquiring form information in a World file, the form information comprises a World form information set W (Wi, Wj, Wij), wherein Wi represents the ith row of the World table, Wj represents the jth column of the World table, sending the World form information set W (Wi, 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 World 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 the 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 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, or/and converts information in the World form information set W (Wi, Wj, Wij) into the public form information set G (Gi, Gj, Gij) through the World 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.
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 World form information transformation mapping relationship K2, the common form information database at least comprising cell common text information T1, cell common font information T2, cell common format information T3, cell common formula information T4, cell common color information T5, and cell common linked list information T6.
3. The graphical custom form data collection system of claim 2, wherein said information translation module, the method at least comprises the steps of establishing a mapping relation Y1 for converting Excel cell text information into cell public text information T1, establishing a mapping relation Y2 for converting Excel cell font information into cell public font information T2, establishing a mapping relation Y3 for converting Excel cell format information into cell public format information T3, establishing a mapping relation Y4 for converting Excel cell public formula information into cell public formula information T4, establishing a mapping relation Y5 for converting Excel cell color information into cell public color information T5, and establishing a mapping relation Y6 for converting Excel cell linked list information into cell public linked list information T6 when establishing an Excel form information conversion mapping relation K1.
4. The graphical custom form data collection system of claim 3, wherein said information translation module, the method at least comprises the steps of establishing a mapping relation Y1 for converting the word cell text information into the cell common text information T1, establishing a mapping relation Y2 for converting the word cell font information into the cell common font information T2, establishing a mapping relation Y3 for converting the word cell format information into the cell common format information T3, establishing a mapping relation Y4 for converting the word cell formula information into the cell common formula information T4, establishing a mapping relation Y5 for converting the word cell color information into the cell common color information T5, and establishing a mapping relation Y6 for converting the 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 i columns according to the total row number i and the total column number j indicated in G (Gi, Gj, Gij), extracts the cell text information and the cell format information in the i-th row and j-th column common form information Gij to reflect the text information to the corresponding cell of the form, and adjusts the size of the cell.
6. The graphical custom form data collection system of claim 1,
the visual window provided by the information processing module comprises a multi-user filling function, when the multi-user filling is carried out, the information processing module selects a pre-modification area in the form, generates a modification area matrix X (Xi, Xj, Xij), wherein Xi represents the ith row, Xj represents the jth column, Xij represents the ith row and jth column cell information, the modification area matrix X (Xi, Xj, Xij) is sent to a designated user, the information processing module generates a corresponding multi-user modification form after receiving the modification area matrix X (Xi, Xj, Xij) and returns the modification area matrix X (Xi, Xj, Xij) to an auditor, the modification area matrix X (Xi, Xj, Xij) returned by the information processing module is modified, 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).
7. The system of claim 1, wherein an ith byte selection matrix Zi (Zi 1, Zi 2) is provided inside the information processing module, i =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 (F1, 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 the data in the ith byte selection matrix Zi (Zi 1, Zi 2), 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 Q32 of a first column of a form as a first word Q1 in a first row of the form as a ciphertext 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, a represents a parameter, a =2, 3.. Zi 2-1; sequentially changing the parameters α =2, 3.. Zi2-1 to generate all ith parameter matrices gi, taking a first parameter matrix g1 as a second byte of the ciphertext k, and taking a second parameter matrix g1 as a second bit of the ciphertext k.
8. The graphical custom form data collection system of claim 1,
when the information conversion module performs the reverse conversion on the public form information set G (Gi, Gj, Gij), the form information set G (Gi, Gj, Gij) is converted into the Excel form information set U (Ui, Uj, Uij) by using the mapping relation K1, and the form information set G (Gi, Gj, Gij) is converted into the World form information set W (Wi, Wj, Wij) by using the mapping relation 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 true CN112016276A (en) | 2020-12-01 |
| CN112016276B 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 (6)
| 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 |
| 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 |
| CN110688343A (en) * | 2019-08-26 | 2020-01-14 | 天津开心生活科技有限公司 | Method and device for converting data format |
| CN111177591A (en) * | 2019-12-10 | 2020-05-19 | 浙江工业大学 | Knowledge graph-based Web data optimization method facing visualization demand |
-
2020
- 2020-10-29 CN CN202011177941.4A patent/CN112016276B/en active Active
Patent Citations (6)
| 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 |
| 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 |
| CN110688343A (en) * | 2019-08-26 | 2020-01-14 | 天津开心生活科技有限公司 | Method and device for converting data format |
| CN111177591A (en) * | 2019-12-10 | 2020-05-19 | 浙江工业大学 | Knowledge graph-based Web data optimization method facing visualization demand |
Non-Patent Citations (1)
| Title |
|---|
| 伍春萍 等: "规则引擎在业务运营支撑系统中的应用研究", 《移动通信》 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112016276B (en) | 2021-02-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103631969B (en) | A kind of generation method and device of report data | |
| CN107368967A (en) | Engineering safety quality inspection intelligent management based on internet | |
| WO2019148852A1 (en) | Chemical information identification method based on deep learning image identification technology | |
| CN103246951A (en) | Intelligent electromechanical equipment management system and method based on BIM (building information modeling) | |
| CN113325816A (en) | Industrial Internet-oriented digital twin body data management method | |
| CN102496083B (en) | Credit rating report manuscript manufacturing method | |
| CN110717088A (en) | Electronic document-based device management method, apparatus, device and storage medium | |
| CN104036060A (en) | Online auditing method and system for engineering drawing | |
| CN109800842A (en) | A kind of assets unique identification code generating method and system | |
| CN108960963A (en) | A kind of architectural design management system and method | |
| CN108009145A (en) | Report form generation method and device | |
| CN108388640A (en) | A kind of data transfer device, device and data processing system | |
| CN103605917A (en) | Spreadsheet system based on multi-user environment and implementation method of spreadsheet system | |
| CN112446683A (en) | Contract performance information management and control system | |
| CN112016276B (en) | Graphical user-defined form data acquisition system | |
| Sakun et al. | Improving the Methodology of Financial and Accounting Support for Business Activities | |
| Hellström et al. | Evaluated CMI bounds for meta learning: Tightness and expressiveness | |
| CN107451111A (en) | High pressure Contract management system | |
| CN103325078A (en) | On-site examination mobility and controllability marking method and system based on tablet computers | |
| CN109711799A (en) | Guide the teaching software and its operation method of the standardization office of administration hilllock | |
| CN108805586A (en) | The platform of production analysis, data analysis | |
| CN104090872A (en) | Service-based situation collaborative plotting system and method | |
| CN106971212A (en) | A kind of efficiently invoice information transmission system and method | |
| WO2020249039A1 (en) | Space data system, method, computer device, and storage medium | |
| CN103336865A (en) | Dynamic communication network construction method and device |
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 |