CN106919709A - Associate the data capture method and system of form - Google Patents
Associate the data capture method and system of form Download PDFInfo
- Publication number
- CN106919709A CN106919709A CN201710144699.2A CN201710144699A CN106919709A CN 106919709 A CN106919709 A CN 106919709A CN 201710144699 A CN201710144699 A CN 201710144699A CN 106919709 A CN106919709 A CN 106919709A
- Authority
- CN
- China
- Prior art keywords
- data
- querying condition
- switching command
- target association
- database
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Information Transfer Between Computers (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a kind of data capture method and system for associating form,It is related to technical field of data processing,Multiple forms are set up into the related information that association is obtained according to associated instructions by what server receiving terminal sent,Related information is sent to database,So that database is preserved to related information,The switching command of the original report that receiving terminal sends,The initial data of the original report is parsed according to switching command,Obtain the first querying condition,And the first querying condition is saved as into session object,According to switching command and related information,Obtain target association form,Wherein,Target association form includes conditional object,Session object is matched with conditional object,The condition data that the match is successful is associated,Obtain the second querying condition,According to the second querying condition,Data screening is carried out to target association form,Obtain target association data.The present invention can improve the efficiency and accuracy rate of data query.
Description
Technical field
The present invention relates to technical field of data processing, more particularly, to a kind of data capture method for associating form and it is
System.
Background technology
With continuing to develop and perfect for the information processing technology, application of the data management system in enterprise is more and more general
Time, the data of the resource, business and generation of enterprise are controlled and managed by information management system, and then can be reduced
Business administration cost, and co-ordination to enterprises brings great convenience.Data management system is being used to enterprise
During the data of the resource, business and generation of industry are controlled and manage, inevitably it is related to data query.Cause
The efficiency and complexity strong influence of this data query operating efficiency and Consumer's Experience.
In existing data management system, the relation between form is not bright and clear enough so that data query, especially for report
The screening inquiry of data is less efficient in table.Usually there is oneself corresponding querying condition in each form.Work as needs
When saying that some data are contrasted, the contrast form for being adapted to manually is searched first, then inquiry bar is limited in form is contrasted
Part, obtains required data.A data query is often carried out, will be repeated the above steps, cumbersome efficiency is low, and it is defeated manually
The mode for entering is difficult to ensure that the accuracy of data query.
The content of the invention
In view of this, it is an object of the invention to provide the data capture method and system of association form, to improve data
The efficiency and accuracy rate of inquiry.
In a first aspect, a kind of data capture method for associating form is the embodiment of the invention provides, wherein, it is applied to service
Device, including：
What receiving terminal sent sets up the related information that association is obtained according to associated instructions by multiple forms；
The related information is sent to database, so that the database is preserved to the related information；
Receive the switching command of the original report that the terminal sends；
The initial data of the original report is parsed according to the switching command, obtains the first querying condition, and by institute
State the first querying condition and save as session object；
According to the switching command and the related information, target association form is obtained, wherein, the target association form
Including conditional object；
The session object is matched with the conditional object, the condition data that the match is successful is associated, obtained
Take the second querying condition；
According to second querying condition, data screening is carried out to the target association form, obtain target association data.
With reference in a first aspect, the embodiment of the invention provides the first possible implementation method of first aspect, wherein, institute
Stating switching command includes cell switching command, and the initial data includes row or column data, described according to the switching command
Initial data to the original report is parsed, and obtains the first querying condition, and first querying condition is saved as into session
Object includes：
According to the cell switching command, the row or column data are parsed, obtain first querying condition,
And first querying condition is saved as into the session object.
With reference in a first aspect, the embodiment of the invention provides second possible implementation method of first aspect, wherein, institute
Stating switching command also includes inquiry column switching command, and the initial data also includes inquiry column number evidence, described according to the switching
Instruct and the initial data of the original report is parsed, obtain the first querying condition, and first querying condition is saved as
Session object also includes：
According to inquiry column switching command, to the inquiry column number according to parsing, first querying condition is obtained,
And first querying condition is saved as into the session object.
With reference in a first aspect, the embodiment of the invention provides the third possible implementation method of first aspect, wherein, institute
State according to the switching command and the related information, obtaining target association form includes：
According to the switching command, target major key information is obtained；
The target major key information is sent to the database, so that the database root is according to the related information and institute
State target association form described in major key acquisition of information；
The target association form that the database sends is received, the target association form is parsed, obtained
The conditional object.
With reference in a first aspect, the embodiment of the invention provides the 4th kind of possible implementation method of first aspect, wherein, institute
State according to second querying condition, data screening is carried out to the target association form, obtaining target association data includes：
Second querying condition is sent to the database, so that the database root is according to second querying condition
Data screening is carried out to the target association form, target association data are obtained；
The target association data that the database sends are received, and the end is given by the target association data is activation
End, so that the terminal shows the target association report data.
Second aspect, the embodiment of the present invention also provides a kind of data-acquisition system for associating form, wherein, including：
Multiple forms are set up the association letter that association is obtained by server for what receiving terminal sent according to associated instructions
Breath, database is sent to by the related information, receives the switching command of the original report that the terminal sends, and is cut according to described
Change instruction to parse the initial data of the original report, obtain the first querying condition, and first querying condition is preserved
It is session object, according to the switching command and the related information, obtains target association form, wherein, the target association
Form includes conditional object, and the session object is matched with the conditional object, and the condition data that the match is successful is entered
Row association, obtains the second querying condition, according to second querying condition, data screening is carried out to the target association form,
Obtain target association data；
The database, for being preserved to the related information；
The terminal, related information is obtained for multiple forms to be set up into association according to associated instructions.
With reference to second aspect, the first possible implementation method of second aspect is the embodiment of the invention provides, wherein, institute
Stating switching command includes cell switching command, and the initial data includes row or column data, and the server is additionally operable to：
According to the cell switching command, the row or column data are parsed, obtain first querying condition,
And first querying condition is saved as into the session object.
With reference to second aspect, second possible implementation method of second aspect is the embodiment of the invention provides, wherein, institute
Stating switching command also includes inquiry column switching command, and the initial data also includes inquiry column number evidence, and the server is additionally operable to：
According to inquiry column switching command, to the inquiry column number according to parsing, first querying condition is obtained,
And first querying condition is saved as into the session object.
With reference to second aspect, the third possible implementation method of second aspect is the embodiment of the invention provides, wherein, institute
Server is stated to be additionally operable to：
According to the switching command, target major key information is obtained；
The target major key information is sent to the database, so that the database root is according to the related information and institute
State target association form described in major key acquisition of information；
The target association form that the database sends is received, the target association form is parsed, obtained
The conditional object.
With reference to second aspect, the 4th kind of possible implementation method of second aspect is the embodiment of the invention provides, wherein, institute
Server is stated to be additionally operable to：
Second querying condition is sent to the database, so that the database root is according to second querying condition
Data screening is carried out to the target association form, target association data are obtained；
The target association data that the database sends are received, and the end is given by the target association data is activation
End, so that the terminal shows the target association report data.
The data capture method and system of the association form that the present invention is provided, the basis sent by server receiving terminal
Multiple forms are set up the related information that association is obtained by associated instructions, related information are sent into database, so that database pair
Related information is preserved, the switching command of the original report that receiving terminal sends, according to switching command to the original of the original report
Beginning data are parsed, and obtain the first querying condition, and the first querying condition are saved as into session object, according to switching command and
Related information, obtains target association form, wherein, target association form includes conditional object, it will words object and conditional object
Matched, the condition data that the match is successful is associated, the second querying condition is obtained, according to the second querying condition, to mesh
Mark association form carries out data screening, obtains target association data.The present invention can improve the efficiency and accuracy rate of data query.
Other features and advantages of the present invention will be illustrated in the following description, also, the partly change from specification
Obtain it is clear that or being understood by implementing the present invention.The purpose of the present invention and other advantages are in specification, claims
And specifically noted structure is realized and obtained in accompanying drawing.
To enable the above objects, features and advantages of the present invention to become apparent, preferred embodiment cited below particularly, and coordinate
Appended accompanying drawing, is described in detail below.
Brief description of the drawings
In order to illustrate more clearly of the specific embodiment of the invention or technical scheme of the prior art, below will be to specific
The accompanying drawing to be used needed for implementation method or description of the prior art is briefly described, it should be apparent that, in describing below
Accompanying drawing is some embodiments of the present invention, for those of ordinary skill in the art, before creative work is not paid
Put, other accompanying drawings can also be obtained according to these accompanying drawings.
Fig. 1 is the correlating method signaling diagram of the querying condition that the embodiment of the present invention one is provided；
Fig. 2 is the first association report page schematic diagram that the embodiment of the present invention one is provided；
Fig. 3 is second association report page schematic diagram that the embodiment of the present invention one is provided；
Fig. 4 is the third association report page schematic diagram that the embodiment of the present invention one is provided；
Fig. 5 is the 4th kind of association report page schematic diagram that the embodiment of the present invention one is provided；
Fig. 6 is the 5th kind of association report page schematic diagram that the embodiment of the present invention one is provided；
Fig. 7 is the 6th kind of association report page schematic diagram that the embodiment of the present invention one is provided；
Fig. 8 is the correlating method flow chart of the querying condition that the embodiment of the present invention two is provided；
The method flow diagram of step S150 in the correlating method of the querying condition that Fig. 9 is provided for the embodiment of the present invention two；
The method flow diagram of step S170 in the correlating method of the querying condition that Figure 10 is provided for the embodiment of the present invention two；
Figure 11 is the interconnected system schematic diagram of the querying condition that the embodiment of the present invention three is provided.
Icon：
100- databases；200- servers；300- terminals.
Specific embodiment
To make the purpose, technical scheme and advantage of the embodiment of the present invention clearer, below in conjunction with accompanying drawing to the present invention
Technical scheme be clearly and completely described, it is clear that described embodiment is a part of embodiment of the invention, rather than
Whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art are not making creative work premise
Lower obtained every other embodiment, belongs to the scope of protection of the invention.
In existing data management system, the relation between form is not bright and clear enough so that data query, especially for report
The screening inquiry of data is less efficient in table.Usually there is oneself corresponding querying condition in each form.Work as needs
When saying that some data are contrasted, the contrast form for being adapted to manually is searched first, then inquiry bar is limited in form is contrasted
Part, obtains required data.A data query is often carried out, will be repeated the above steps, cumbersome efficiency is low, and it is defeated manually
The mode for entering is difficult to ensure that the accuracy of data query.
Based on this, the data capture method and system of association form provided in an embodiment of the present invention can improve data and look into
The efficiency and accuracy rate of inquiry.
For ease of understanding the present embodiment, first to the correlating method of the querying condition disclosed in the embodiment of the present invention
Describe in detail,
Embodiment one：
Fig. 1 is the correlating method signaling diagram of the querying condition that the embodiment of the present invention one is provided
Reference picture 1, the correlating method of querying condition is achieved by the steps of between association form：
Multiple forms are set up association and obtain related information by step S01, terminal according to associated instructions；
Related information is sent to database by step S02, terminal by server；
Step S03, database is preserved related information；
Specifically, each form is equipped with the unique major key information of oneself, according to the reality of user when creating
Different forms are freely set up incidence relation by border demand by major key information, obtain related information, and related information includes different reports
Corresponding incidence relation and form be in itself between table.User can also be after certain form be chosen, by clicking on editor's association report
Table ejection editor's association report page, the page can classify and list all of form in the system, and user can be according to actual feelings
Condition goes to select other forms to be associated, and obtains related information.Related information saving in database, data query after being easy to
Use, being set up with current form has certain form for associating, and can select to rapidly enter.Terminal can be computer, but not limit
In this.
Step S04, the switching command of the original report that server receiving terminal sends；
Specifically, reference picture 2, to sell flowing water form as illustrating as a example by the original report.In the exhibition of terminal current institute
On the page of the sale flowing water form for showing, there is " association form " operation button corresponding with switching command；Also input inquiry bar
The inquiry column of part concrete numerical value, including Start Date, Close Date, merchandise classification and Brand etc., and it is most important
The cell data that sale flowing water form is obtained under the limitation of ad hoc inquiry condition；Wherein, the data and unit in inquiry column
Data in lattice together constitute the initial data of the original report.
Switching command is obtained by operating " association form " interaction button, and switching command is the instruction for associating form,
Server reads the incidence relation of current the original report from database, so as to be the pass that user shows the original report in terminal
Connection form, for example, show the relevant form of institute of current form by way of drop-down menu.User is at drop-down menu midpoint
After hitting respective associated form, you can open association form.On the page of the sale flowing water form shown in Fig. 3, to " association report
After table " button is operated, show " payment flowing water " associated with it, " merchandise sales collect " and " cashier's sale collects ",
Selection " payment flowing water " is to switch to the payment flowing water report page being associated with sale flowing water form, sale flowing water form
Displayed page is as shown in Figure 4.
In addition, can see " editor's association form " operation button in figure 3, execution " should edit association form ", and operation is pressed
Button, then obtain associated instructions.The page of " editor's association form " operation button is performed as shone shown in Fig. 5, editor's association is clicked on
Classification is listed all of form of system by form ejection editor's association report page, the page, and user can be according to actual conditions
Selection form is gone to be associated.Current form has the form of certain association, rapidly entered after can selecting, and current form is looked into
Inquiry condition can be imparted in association form automatically.Illustrated as a example by selling flowing water form, can be obtained according to edit operation and " set
Association form " the page, the page classifications are listed and looked into including archives, buying, promotion, retail, gift token management, gift certificate reference, sale
Whole forms such as inquiry, payment flowing water and cash inquiry, can select payment flowing water form to be associated, and believe associating wherein
Breath is preserved.
Step S05, server is parsed according to switching command to the initial data of the original report, is obtained first and is inquired about bar
Part information, and the first querying condition information is saved as into session object；
Step S06, server obtains target major key information according to switching command；
Target major key information is sent to database by step S07, server；
Step S08, database root obtains target association form according to related information and major key information；
Target association form is sent to server by step S09, database；
Step S10, server is parsed to target association form, obtains conditional object；
Step S11, server is matched session object with conditional object, and the condition data that the match is successful is closed
Connection, obtains the second querying condition；
Second querying condition is sent to database by step S12, server；
Step S13, database root carries out data screening to target association form according to the second querying condition, obtains target association
Data；
Target association data are sent to terminal by step S14, database by server；
Step S15, terminal display target associated data.
Specifically, server is after switching command is received, the initial data of " sale flowing water " form will be parsed,
The concrete numerical value in the inquiry column for obtaining will be parsed as the first querying condition, and save as session object；Meanwhile, server is also
According to the target major key information that switching command includes, " payment flowing water " form is loaded, and " the payment flowing water " for obtaining will be parsed
The inquiry column of form is stored in conditional object, by the querying condition that different forms are used is otherwise varied, in querying condition certainly
It is dynamic when assigning in association form, can only assign the querying condition form that two forms all possess, that is, by session object and bar
Part object is matched.Be can see from Fig. 2 and Fig. 4, the inquiry all possessed in payment flowing water form and sale flowing water form
Condition has a date, the first querying condition in sale flowing water form be Start Date be 2016-12-18, the Close Date is 2017-
01-16, then the second querying condition for assigning after payment flowing water form the querying condition is exactly Query Dates 2016-12-18
~2017-01-16.
In addition, for the number of lines and columns evidence in current form, it is also possible to as in querying condition imparting association form.User
Select corresponding line or column unit lattice and be switched to association form, as long as the data of the cell belong to the first inquiry of association form
Condition, then server the data in the row or column cell will be parsed the cell data as querying condition, together
Described by epimere, matched with conditional object by by session object, realized that the querying condition of association form is assigned automatically
Function, the automatic restriction by the querying condition of data of the association form displaying after opening obtains.Reference picture 6, have selected cell
In the 6th row data, and be switched to " payment flowing water " form of association.In 6th row data document numbering, mechanism coding and
Organization names and their own concrete numerical value are resolved to the first querying condition, and are stored in session object.Reference picture 7,
By the data of " payment flowing water " form that terminal shows, it can be seen that these data are to be imparted to the first querying condition " to pay
Obtained after money flowing water " form.
In sum, the automatic of the first querying condition is imparted to target form, obtains the specific reality of the second querying condition
Existing method is as follows：
Querying condition is stored in database using configuration mode, and each querying condition in each form is except having
The major key information of oneself, also has name information, and when association form is jumped to, server can be the institute of current the original report
There is querying condition to be stored in session object, when form loading is associated, conditional object and session pair that server can be loaded
Condition as in is matched according to name information, and the numerical value of the condition for matching can be assigned after the match is successful, and loading completes meeting later
Trigger the event of inquiry.Simultaneously for the data in table row, it is also possible to operate right button, the related data of active sheet row,
Take in the querying condition of new form, the display row of form are also to be stored in database using configuration mode, each report
Each row in table when the data line of selection form, and obtain right button except the major key information for having oneself, also name information
Association form can be listed during instruction, selects the association form for entering, server the data of the row and column information can be stored in meeting
In words object, when form loading is associated, the column information in conditional object and session object that system can be loaded is according to title
Information is matched, and the match is successful can assign the corresponding row data of the column information for matching, and loading can trigger inquiry after completing
Event.
Embodiment two：
Fig. 8 is the correlating method flow chart of the querying condition that the embodiment of the present invention two is provided.
Reference picture 8, with server as executive agent, association form between querying condition correlating method as follows
Realize：
Step S110, what receiving terminal sent sets up the related information that association is obtained according to associated instructions by multiple forms；
Step S120, database is sent to by related information, so that database is preserved to related information；
Step S130, the switching command of the original report that receiving terminal sends；
Step S140, parses according to switching command to the initial data of the original report, obtains the first querying condition, and
First querying condition is saved as into session object；
Step S150, according to switching command and related information, obtains target association form, wherein, target association form bag
Include conditional object；
Step S160, it will words object is matched with conditional object, and the condition data that the match is successful is associated, and is obtained
Take the second querying condition；
Step S170, according to the second querying condition, data screening is carried out to target association form, obtains target association number
According to.
Exemplary embodiment of the invention, switching command include cell switching command, initial data include row or
Column data, parses according to switching command to the initial data of the original report, obtains the first querying condition, and first is inquired about
Condition saves as session object to be included：
According to cell switching command, row or column data are parsed, obtain the first querying condition, and first is inquired about
Condition saves as session object.
Exemplary embodiment of the invention, switching command also includes inquiry column switching command, and initial data also includes
Inquiry column number evidence, parses according to switching command to the initial data of the original report, obtains the first querying condition, and by first
Querying condition saves as session object also to be included：
According to inquiry column switching command, to inquiry column number according to parsing, the first querying condition is obtained, and first is inquired about
Condition saves as session object.
Exemplary embodiment of the invention, reference picture 9, according to switching command and related information, obtains target association
Form includes：
Step S210, according to switching command, obtains target major key information；
Step S220, database is sent to by target major key information, so that database root is according to related information and major key information
Obtain target association form；
Step S230, receives the target association form that database sends, and target association form is parsed, and obtains condition
Object.
Exemplary embodiment of the invention, reference picture 10, according to the second querying condition, is carried out to target association form
Data screening, obtains target association data and comprises the following steps：
Step S310, database is sent to by the second querying condition so that database root according to the second querying condition to target
Association form carries out data screening, obtains target association data；
Step S320, receives the target association data that database sends, and by target association data is activation to terminal, so that
Terminal display target associates report data.
Embodiment three：
Figure 11 is the interconnected system schematic diagram of the querying condition that the embodiment of the present invention three is provided.
Reference picture 11, the interconnected system of querying condition includes database 100, server 200 and terminal 300：
Multiple forms are set up the pass that association is obtained by server 200 for what receiving terminal 300 sent according to associated instructions
Connection information, database 100, the switching command of the original report that receiving terminal 300 sends, according to switching are sent to by related information
Instruct and the initial data of the original report is parsed, obtain the first querying condition, and the first querying condition is saved as into session
Object, according to switching command and related information, obtains target association form, wherein, target association form includes conditional object, will
Session object is matched with conditional object, and the condition data that the match is successful is associated, and obtains the second querying condition, according to
Second querying condition, data screening is carried out to target association form, obtains target association data；
Database 100, for being preserved to related information；
Terminal 300, related information is obtained for multiple forms to be set up into association according to associated instructions.
Exemplary embodiment of the invention, switching command include cell switching command, initial data include row or
Column data, server 200 is additionally operable to：
According to cell switching command, row or column data are parsed, obtain the first querying condition, and first is inquired about
Condition saves as session object.
Exemplary embodiment of the invention, switching command also includes inquiry column switching command, and initial data also includes
Inquiry column number evidence, server 200 is additionally operable to：
According to inquiry column switching command, to inquiry column number according to parsing, the first querying condition is obtained, and first is inquired about
Condition saves as session object.
Exemplary embodiment of the invention, server 200 is additionally operable to：
According to switching command, target major key information is obtained；
Target major key information is sent to database 100, so that database 100 is according to related information and major key acquisition of information
Target association form；
The target association form that database 100 sends is received, target association form is parsed, obtain conditional object.
Exemplary embodiment of the invention, server 200 is additionally operable to：
Second querying condition is sent to database 100 so that database 100 according to the second querying condition to target association
Form carries out data screening, obtains target association data；
The target association data that database 100 sends are received, and by target association data is activation to terminal 300, so that eventually
300 display targets are held to associate report data.
The data capture method and system of the association form that the present invention is provided, are sent by the receiving terminal 300 of server 200
Multiple forms are set up into the related information that obtains of association according to associated instructions, related information is sent to database 100 so that
Database 100 is preserved to related information, the switching command of the original report that receiving terminal 300 sends, according to switching command
Initial data to the original report is parsed, and obtains the first querying condition, and the first querying condition is saved as into session object,
According to switching command and related information, target association form is obtained, wherein, target association form includes conditional object, it will words
Object is matched with conditional object, and the condition data that the match is successful is associated, and the second querying condition is obtained, according to second
Querying condition, data screening is carried out to target association form, obtains target association data.The present invention can improve data query
Efficiency and accuracy rate.
The data capture method and the computer program product of system of the association form that the embodiment of the present invention is provided, including
The computer-readable recording medium of program code is stored, the instruction that described program code includes can be used to perform previous methods reality
The method described in example is applied, is implemented and be can be found in embodiment of the method, will not be repeated here.
It is apparent to those skilled in the art that, for convenience and simplicity of description, the system of foregoing description
With the specific work process of device, the corresponding process in preceding method embodiment is may be referred to, will not be repeated here.
In addition, in the description of the embodiment of the present invention, unless otherwise clearly defined and limited, term " installation ", " phase
Company ", " connection " should be interpreted broadly, for example, it may be being fixedly connected, or being detachably connected, or be integrally connected；Can
Being to mechanically connect, or electrically connect；Can be joined directly together, it is also possible to be indirectly connected to by intermediary, Ke Yishi
Two connections of element internal.For the ordinary skill in the art, with concrete condition above-mentioned term can be understood at this
Concrete meaning in invention.
If the function is to realize in the form of SFU software functional unit and as independent production marketing or when using, can be with
Storage is in a computer read/write memory medium.Based on such understanding, technical scheme is substantially in other words
The part contributed to prior art or the part of the technical scheme can be embodied in the form of software product, the meter
Calculation machine software product is stored in a storage medium, including some instructions are used to so that a computer equipment (can be individual
People's computer, server, or network equipment etc.) perform all or part of step of each embodiment methods described of the invention.
And foregoing storage medium includes：USB flash disk, mobile hard disk, read-only storage (ROM, Read-Only Memory), arbitrary access are deposited
Reservoir (RAM, Random Access Memory), magnetic disc or CD etc. are various can be with the medium of store program codes.
In the description of the invention, it is necessary to explanation, term " " center ", " on ", D score, "left", "right", " vertical ",
The orientation or position relationship of the instruction such as " level ", " interior ", " outward " be based on orientation shown in the drawings or position relationship, merely to
Be easy to the description present invention and simplify describe, rather than indicate imply signified device or element must have specific orientation,
With specific azimuth configuration and operation, therefore it is not considered as limiting the invention.Additionally, term " first ", " second ",
" the 3rd " is only used for describing purpose, and it is not intended that indicating or implying relative importance.
Finally it should be noted that：Embodiment described above, specific embodiment only of the invention, is used to illustrate the present invention
Technical scheme, rather than its limitations, protection scope of the present invention is not limited thereto, although with reference to the foregoing embodiments to this hair
It is bright to be described in detail, it will be understood by those within the art that：Any one skilled in the art
The invention discloses technical scope in, it can still modify to the technical scheme described in previous embodiment or can be light
Change is readily conceivable that, or equivalent is carried out to which part technical characteristic；And these modifications, change or replacement, do not make
The essence of appropriate technical solution departs from the spirit and scope of embodiment of the present invention technical scheme, should all cover in protection of the invention
Within the scope of.Therefore, protection scope of the present invention described should be defined by scope of the claims.
Claims (10)
1. it is a kind of associate form data capture method, it is characterised in that be applied to server, including：
What receiving terminal sent sets up the related information that association is obtained according to associated instructions by multiple forms；
The related information is sent to database, so that the database is preserved to the related information；
Receive the switching command of the original report that the terminal sends；
The initial data of the original report is parsed according to the switching command, obtains the first querying condition, and by described the
One querying condition saves as session object；
According to the switching command and the related information, target association form is obtained, wherein, the target association form includes
Conditional object；
The session object is matched with the conditional object, the condition data that the match is successful is associated, obtained the
Two querying conditions；
According to second querying condition, data screening is carried out to the target association form, obtain target association data.
2. the data capture method of association form according to claim 1, it is characterised in that the switching command includes single
First lattice switching command, the initial data include row or column data, it is described according to the switching command to the original of the original report
Data are parsed, and obtaining the first querying condition, and first querying condition is saved as into session object includes：
According to the cell switching command, the row or column data are parsed, obtain first querying condition, and will
First querying condition saves as the session object.
3. it is according to claim 1 association form data capture method, it is characterised in that the switching command also includes
Inquiry column switching command, the initial data also include inquiry column number evidence, it is described according to the switching command to the original report
Initial data is parsed, and obtaining the first querying condition, and first querying condition is saved as into session object also includes：
According to inquiry column switching command, to the inquiry column number according to parsing, first querying condition is obtained, and will
First querying condition saves as the session object.
4. it is according to claim 1 association form data capture method, it is characterised in that it is described according to it is described switching refer to
Order and the related information, obtaining target association form includes：
According to the switching command, target major key information is obtained；
The target major key information is sent to the database, so that the database root is according to the related information and the master
Key information obtains the target association form；
The target association form that the database sends is received, the target association form is parsed, obtain described
Conditional object.
5. it is according to claim 1 association form data capture method, it is characterised in that it is described to be looked into according to described second
Inquiry condition, data screening is carried out to the target association form, and obtaining target association data includes：
Second querying condition is sent to the database so that the database root according to second querying condition to institute
Stating target association form carries out data screening, obtains target association data；
The target association data that the database sends are received, and the terminal are given by the target association data is activation,
So that the terminal shows the target association report data.
6. it is a kind of associate form data-acquisition system, it is characterised in that including：
Multiple forms are set up the related information that association is obtained by server for what receiving terminal sent according to associated instructions, will
The related information is sent to database, receives the switching command of the original report that the terminal sends, and is referred to according to the switching
Make and the initial data of the original report is parsed, obtain the first querying condition, and first querying condition is saved as into meeting
Words object, according to the switching command and the related information, obtains target association form, wherein, the target association form
Including conditional object, the session object is matched with the conditional object, the condition data that the match is successful is closed
Connection, obtains the second querying condition, according to second querying condition, data screening is carried out to the target association form, obtains
Target association data；
The database, for being preserved to the related information；
The terminal, related information is obtained for multiple forms to be set up into association according to associated instructions.
7. the data-acquisition system of association form according to claim 6, it is characterised in that the switching command includes single
First lattice switching command, the initial data includes row or column data, and the server is additionally operable to：
According to the cell switching command, the row or column data are parsed, obtain first querying condition, and will
First querying condition saves as the session object.
8. it is according to claim 6 association form data-acquisition system, it is characterised in that the switching command also includes
Inquiry column switching command, the initial data also includes inquiry column number evidence, and the server is additionally operable to：
According to inquiry column switching command, to the inquiry column number according to parsing, first querying condition is obtained, and will
First querying condition saves as the session object.
9. it is according to claim 6 association form data-acquisition system, it is characterised in that the server is additionally operable to：
According to the switching command, target major key information is obtained；
The target major key information is sent to the database, so that the database root is according to the related information and the master
Key information obtains the target association form；
The target association form that the database sends is received, the target association form is parsed, obtain described
Conditional object.
10. it is according to claim 6 association form data-acquisition system, it is characterised in that the server is additionally operable to：
Second querying condition is sent to the database so that the database root according to second querying condition to institute
Stating target association form carries out data screening, obtains target association data；
The target association data that the database sends are received, and the terminal are given by the target association data is activation,
So that the terminal shows the target association report data.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710144699.2A CN106919709A (en) | 2017-03-10 | 2017-03-10 | Associate the data capture method and system of form |
| PCT/CN2017/080122 WO2018161401A1 (en) | 2017-03-10 | 2017-04-11 | Data obtaining method and system for associated report |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710144699.2A CN106919709A (en) | 2017-03-10 | 2017-03-10 | Associate the data capture method and system of form |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106919709A true CN106919709A (en) | 2017-07-04 |
Family
ID=59461624
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710144699.2A Pending CN106919709A (en) | 2017-03-10 | 2017-03-10 | Associate the data capture method and system of form |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN106919709A (en) |
| WO (1) | WO2018161401A1 (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109102088A (en) * | 2018-08-09 | 2018-12-28 | 北京智行者科技有限公司 | A kind of processing method of report data |
| CN109325063A (en) * | 2018-09-25 | 2019-02-12 | 奇瑞汽车股份有限公司 | Data managing method and device |
| CN109471840A (en) * | 2018-10-15 | 2019-03-15 | 北京海数宝科技有限公司 | Fileview method, apparatus, computer equipment and storage medium |
| CN110889268A (en) * | 2019-10-30 | 2020-03-17 | 中盈优创资讯科技有限公司 | Report generation method and device |
| CN111078784A (en) * | 2019-11-25 | 2020-04-28 | 苏宁云计算有限公司 | Report automatic recommendation system, method and computer system |
| US10839140B2 (en) | 2018-06-25 | 2020-11-17 | Baidu Online Network Technology (Beijing) Co., Ltd. | Page displaying method, apparatus based on H5 webpage, and computer readable storage medium |
| CN114237791A (en) * | 2021-11-26 | 2022-03-25 | 维沃移动通信有限公司 | Chart display method and device, electronic equipment and medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101639855A (en) * | 2009-09-02 | 2010-02-03 | 华为技术有限公司 | Report inquiry method and device thereof |
| CN101876984A (en) * | 2009-12-07 | 2010-11-03 | 金蝶软件（中国）有限公司 | Data management system and data relation query method and device thereof |
| US8024650B2 (en) * | 2006-03-31 | 2011-09-20 | Microsoft Corporation | Drilling on elements in arbitrary ad-hoc reports |
| CN104050181A (en) * | 2013-03-13 | 2014-09-17 | 金蝶软件（中国）有限公司 | Electronic form penetrating inquiring method and device |
-
2017
- 2017-03-10 CN CN201710144699.2A patent/CN106919709A/en active Pending
- 2017-04-11 WO PCT/CN2017/080122 patent/WO2018161401A1/en active Application Filing
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8024650B2 (en) * | 2006-03-31 | 2011-09-20 | Microsoft Corporation | Drilling on elements in arbitrary ad-hoc reports |
| CN101639855A (en) * | 2009-09-02 | 2010-02-03 | 华为技术有限公司 | Report inquiry method and device thereof |
| CN101876984A (en) * | 2009-12-07 | 2010-11-03 | 金蝶软件（中国）有限公司 | Data management system and data relation query method and device thereof |
| CN104050181A (en) * | 2013-03-13 | 2014-09-17 | 金蝶软件（中国）有限公司 | Electronic form penetrating inquiring method and device |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10839140B2 (en) | 2018-06-25 | 2020-11-17 | Baidu Online Network Technology (Beijing) Co., Ltd. | Page displaying method, apparatus based on H5 webpage, and computer readable storage medium |
| CN109102088A (en) * | 2018-08-09 | 2018-12-28 | 北京智行者科技有限公司 | A kind of processing method of report data |
| CN109325063A (en) * | 2018-09-25 | 2019-02-12 | 奇瑞汽车股份有限公司 | Data managing method and device |
| CN109471840A (en) * | 2018-10-15 | 2019-03-15 | 北京海数宝科技有限公司 | Fileview method, apparatus, computer equipment and storage medium |
| CN110889268A (en) * | 2019-10-30 | 2020-03-17 | 中盈优创资讯科技有限公司 | Report generation method and device |
| CN110889268B (en) * | 2019-10-30 | 2024-04-23 | 中盈优创资讯科技有限公司 | Report generation method and device |
| CN111078784A (en) * | 2019-11-25 | 2020-04-28 | 苏宁云计算有限公司 | Report automatic recommendation system, method and computer system |
| CN114237791A (en) * | 2021-11-26 | 2022-03-25 | 维沃移动通信有限公司 | Chart display method and device, electronic equipment and medium |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2018161401A1 (en) | 2018-09-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106919709A (en) | Associate the data capture method and system of form | |
| CN107291718B (en) | Page resource delivery method and device | |
| Markides et al. | Creativity is not enough: ICT‐enabled strategic innovation | |
| CN108197967B (en) | Coupon display and issuing method and device based on Internet platform | |
| CN106295951A (en) | Cash method, device and ERP system for solid shop/brick and mortar store | |
| CN110020905A (en) | A kind of method, apparatus and system of digitization selection | |
| JP2018538636A (en) | Method, system and apparatus for providing product information | |
| CN109918569A (en) | Medicine information method for pushing, server and readable storage medium storing program for executing | |
| US20140316931A1 (en) | F& i menu system | |
| Chen et al. | Exploring E-readiness on E-commerce adoption of SMEs: Case study South-East Asia | |
| CN109299901A (en) | A kind of method, apparatus, equipment and the storage medium of determining commodity distribution shops | |
| CN112036984A (en) | E-commerce operation big data management system | |
| US20140379406A1 (en) | Reserved service alarm method and terminal therefor | |
| CN107665116B (en) | Page resource bit information processing method and device | |
| CN103473622A (en) | Scoping based on business scenario | |
| CN110069499B (en) | Data management method, device, system and storage medium | |
| CN107730242A (en) | Method, sales terminal and the sales terminal management server that self-service commodity are paid | |
| CN112116427A (en) | Commodity recommendation method and device, electronic equipment and storage medium | |
| CN110853230A (en) | Self-service vending machine exception handling method, system and equipment | |
| CN115936703A (en) | Payment channel display method and device, computer equipment and readable storage medium | |
| CN115767124A (en) | Display method and device of live broadcast room, computer equipment and storage medium | |
| CN111435508B (en) | Method and device for processing information of resource issuing terminal | |
| CN113077288A (en) | Message pushing method and device, computer equipment and computer readable storage medium | |
| CN111861658A (en) | Data management method, terminal and storage medium | |
| CN112053248A (en) | Insurance exhibition 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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170704 |