CN101576914A - Method and device for providing service data - Google Patents
Method and device for providing service data Download PDFInfo
- Publication number
- CN101576914A CN101576914A CNA2009100870329A CN200910087032A CN101576914A CN 101576914 A CN101576914 A CN 101576914A CN A2009100870329 A CNA2009100870329 A CN A2009100870329A CN 200910087032 A CN200910087032 A CN 200910087032A CN 101576914 A CN101576914 A CN 101576914A
- Authority
- CN
- China
- Prior art keywords
- control information
- user
- service data
- control
- field
- 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
- 238000000034 method Methods 0.000 title claims abstract description 39
- 230000010365 information processing Effects 0.000 claims description 21
- 230000001960 triggered effect Effects 0.000 claims description 2
- 230000008569 process Effects 0.000 description 9
- 238000004590 computer program Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 238000012163 sequencing technique Methods 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013479 data entry Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a method and a device for providing service data. The method comprises the steps of: setting control information corresponding to each service control, wherein the control information includes datasheet name, a field name used for displaying and a field name used for searching; detecting a focus-obtaining event of a current service control, and obtaining control information corresponding to the current service control; receiving the search condition input by a user; finding a corresponding datasheet from a database according to the datasheet name in the obtained control information; finding fields meeting the search condition from the database according to the field names used for searching and included in the obtained control information; finding fields needing to be displayed from items in which the fields exist according to the field names used for displaying and included in the obtained control information; and providing the service data in the field, which exists in each found item and needs to be displayed, for the user. The method and the device can provide the user with rich service data meeting the search condition of the user and improve the service data inputting efficiency of the user.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a method and an apparatus for providing service data.
Background
A service based on a BS (Browser/Server) system is to install a Server (Server) on an operator side, run software using a Browser (Browser) on a client side, send a request to many servers distributed on a network through the Browser, process the request of the Browser by the Server, and return information required by the user to the Browser, thereby providing various services to the user.
In services based on BS systems, data entry by a user on the client side with a browser of the BS system is often required. For example, when a user creates a service order in software of the BS system, the user needs to enter various data such as the name of the operator responsible for the order, the name of the customer of the order, the name of the contact, and the delivery address into the system according to the actual service condition. Data entered by a user can be divided into two categories: one is data already stored in the database of the BS system, called service data, and the name of the above-mentioned service person and the name of the customer are the service data; the other is data not stored in the database of the BS system, called plain text data, and the contact names and delivery addresses are plain text data. Since the service data is data already stored in the database of the BS system, the entry process of the service data is: the system provides the service data in the database for the user, and the user selects the service data to be input according to the provided service data.
In the process of entering service data, currently, a method for providing service data to a user is as follows: and the system provides all possible service data in the database corresponding to the service control to the user. Taking the name of the operator as an example, the system provides the names of all operators in the database or the names of all operators sorted according to a certain rule (for example, sorted according to the used frequency) to the user in a pop-up window mode or a pull-down mode.
As can be seen from the above description, in the BS system-based service, the existing method for providing service data to a user is to simply provide all service data in a database or a large amount of service data after sequencing to the user, so that the user must continuously search for service data to be entered from the provided service data, and then select the service data to be entered, which brings inconvenience to the user and greatly reduces the efficiency of the user to enter the service data.
Further, because the existing method for providing business data to a user cannot search out business data meeting the search condition from the database by using a flexible search condition, for example, for the name of the salesperson to be entered, the user may not remember the name of the salesperson but only remember the number of the salesperson or a mobile phone, and the existing method for providing business data cannot search out the name of the salesperson to be entered from the database by using a flexible search condition such as the number of the salesperson or the mobile phone, and only a large number of names of the salesperson are provided to the user, in this way, since the user does not remember the name of the salesperson, the subsequent work of entering the name of the salesperson cannot be completed, and therefore, the flexibility of business implementation is greatly limited.
Disclosure of Invention
The invention mainly aims to provide a method and a device for business data, so as to improve the efficiency of inputting business data by a user.
The invention is realized by the following technical scheme:
a method for providing service data sets control information corresponding to each service control, the control information includes data table name, field name for displaying, field name for searching, the method also includes:
detecting an event of acquiring a focus of a current business control, and acquiring control information corresponding to the current business control;
receiving a search condition input by a user; searching a corresponding data table in a database according to the data table name in the acquired control information; according to the field name used for searching in the acquired control information, searching the item where the field meeting the searching condition is located in the data table; searching fields needing to be displayed in the searched items according to the field names used for displaying in the acquired control information;
and providing the searched business data of the fields needing to be displayed in each item to the user.
Wherein, in the control information corresponding to each service control, the field name used for searching is: any field name or any combination of a plurality of field names in the data table corresponding to the service control.
Preferably, the method further comprises: binding an auxiliary input frame processing code to each acquired focus event in advance;
when the event of obtaining focus of the current business control is detected, the method further comprises the following steps: the auxiliary entry frame processing code bound by the obtained focus event executes to display the auxiliary entry frame under the current business control;
the step of providing the searched service data of the fields required to be displayed in each item to the user comprises the following steps: and displaying the business data of the field needing to be displayed in each project in the auxiliary entry box under the current business control by the auxiliary entry box processing code.
Optionally, the control information further includes a page connection address for modifying data in the database;
the method further comprises the following steps: when a user logs in, judging whether the user has the authority of adding service data in a database according to user information input by the user, and if so, displaying an adding button after detecting a focus obtaining event of the current service control; and when detecting that the user triggers an adding button, opening the page connection address in the acquired control information.
Optionally, the control information further includes a connection address of an information display page;
the method further comprises the following steps: and displaying a display button for each searched item, splicing the identification value of the item and the connection address of the information display page in the acquired control information into an address when the display button of one item is detected to be triggered by a user, and opening the address.
Optionally, the control information further includes a field name for sorting;
after the finding of the fields to be displayed and before the providing of the service data of the fields to be displayed in each item to the user, further comprising: sorting the searched items according to the field names used for sorting in the acquired control information;
the step of providing the searched service data of the fields required to be displayed in each item to the user comprises the following steps: and providing the searched service data of the fields needing to be displayed in each item to the user according to the sequence after the items are sequenced.
An apparatus for providing service data, the apparatus comprising:
the control information processing unit is used for setting and storing control information corresponding to each service control, and the control information comprises a data table name, a field name for displaying and a field name for searching;
the event processing unit is used for acquiring control information corresponding to the current business control from the control information processing unit when the focus acquisition event of the current business control is detected, receiving a search condition input by a user, sending the search condition and the acquired control information to the search execution unit, and providing the received business data of a field needing to be displayed in each item to the user;
the search execution unit is used for searching the corresponding data table in the database according to the data table name in the acquired control information; searching the item where the field meeting the search condition is located in the data table according to the field name used for searching in the acquired control information; searching fields needing to be displayed in the searched items according to the field names used for displaying in the acquired control information; and sending the found business data of the fields needing to be displayed in each item to the event processing unit.
Wherein, in the control information corresponding to each service control set and stored by the control information processing unit, the field name used for searching is: any field name or any combination of a plurality of field names in the data table corresponding to the service control.
Preferably, the event processing unit further binds each obtained focus event to an auxiliary entry box processing code; when a focus obtaining event of the current business control is detected, triggering an auxiliary entry frame processing code bound by the focus obtaining event to execute and display an auxiliary entry frame under the current business control; and displaying the business data in the fields needing to be displayed in each received item in an auxiliary entry box under the current business control.
Optionally, the apparatus further comprises an authentication unit; wherein,
the control information set and stored by the control information processing unit further comprises a page connection address for modifying data in the database;
the authentication unit judges whether the user has the authority of adding the service data in the database according to the user information input by the user when the user logs in, and if so, the authentication unit sends an authentication success notification to the event processing unit;
the event processing unit displays an adding button to a user after detecting a focus obtaining event of the current business control if receiving the authentication success notification; and when detecting that the user triggers an adding button, opening the page connection address in the acquired control information.
Optionally, the control information set and stored by the control information processing unit further includes a connection address of an information display page;
and the event processing unit further displays a display button for each received item, splices the identification value of the item and the connection address of the information display page in the acquired control information into an address when detecting that the user triggers the display button of the item, and opens the address.
Optionally, the control information set and stored by the control information processing unit further includes field names for sorting;
the search execution unit is further configured to, after finding the field to be displayed, sort the found items according to the field names used for sorting in the acquired control information, and send the service data of the field to be displayed in each sorted item to the event processing unit.
Wherein the control information processing unit and the search execution unit are provided in a server;
the event processing unit is arranged in the browser.
Therefore, the invention has the following beneficial effects:
1. in the invention, as corresponding control information is set for each service control which needs to input service data, the data table where the service data needs to be input (namely which data table needs to be searched) can be determined according to the data table name in the control information, the field where the service data needs to be input (namely which fields in the data table need to be searched) can be determined according to the field name used for searching in the control information, the fields which meet the search condition input by the user can be found out, and finally the service data in which the fields in the item where the fields need to be found are provided for the user can be determined according to the field name used for displaying in the control information, so that the fewer service data which meet the search condition of the user can be provided for the user finally, and the service data is not the numerous service data which is irrelevant to the user in the prior art, therefore, in the subsequent process, the user only needs to select one service data from the service data with less quantity which accords with the search condition to enter, and the efficiency of entering the service data by the user is greatly improved.
2. The invention controls various fields displayed to the user by setting the control information, thus providing richer information to the user, for example, for business data such as the name of the salesman, the fields used for displaying in the control information can be set to display the name of the salesman meeting the search condition to the user, and also to display rich information such as the mobile phone, the address, the credit limit and the like of the salesman related to the name of the salesman meeting the search condition, therefore, the user can determine which name of the salesman needs to be input according to any one of the displayed name, the mobile phone, the address and the like of each salesman, and the work of inputting the business data by the user is facilitated.
3. In the invention, the field name used for searching can be any field name or any combination of a plurality of field names in the data table, thus, a user can use any kind of information memorized by the user as a searching condition, for example, for an operator control, the field name used for searching can be set to be any one or combination of a serial number, a mobile phone or a name, thus, the searching condition of the user is very flexible, the field name can be correspondingly any one or combination of the serial number, the mobile phone or the name, even if the user does not remember the name of the operator, the name of the operator needing to be recorded can be searched and determined by using the serial number or the mobile phone and other information, thereby greatly increasing the flexibility of service implementation.
Drawings
Fig. 1 is a flowchart for providing service data to a user in a BS system in a preferred embodiment of the present invention;
fig. 2 is a schematic diagram of display of service data provided to a user in an embodiment of the present invention;
fig. 3 is a schematic diagram of a basic structure of an apparatus for providing service data in the present invention.
Detailed Description
The invention provides a method for providing service data, which has the core idea that: presetting control information corresponding to each service control, wherein the control information comprises a data table name, a field name for display and a field name for search; when detecting a focus obtaining event of a current business control, obtaining control information corresponding to the current business control; receiving a search condition input by a user; searching a corresponding data table in a database according to the data table name in the acquired control information; searching the item where the field meeting the search condition is located in the data table according to the field name used for searching in the acquired control information; searching fields needing to be displayed in the searched items according to the field names used for displaying in the acquired control information; and providing the searched business data of the fields needing to be displayed in each item to the user.
The service control is a description used for simplifying the description, and when data to be entered in a text box of one control is service data, the control is the service control.
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention will be further described in detail with reference to the accompanying drawings and specific embodiments.
Fig. 1 is a flowchart for providing service data to a user in a BS system in a preferred embodiment of the present invention. Referring to fig. 1, the process specifically includes the following steps:
step 101: the control information corresponding to each service control is preset, and the control information mainly comprises a data table name (TableName), a field name (DisplayName) for display and a field name (SearchName) for search.
In the step, in the control information, the name of the data table represents the name of the data table in the database to be searched; for example, for the operator control, the service data to be entered is the name of the operator, and then, the name of the data table is the name "Person" of the data table in which the name of the operator is stored in the database; for another example, for the client control, the service data to be entered is the name of the client, and then the name of the data table is the name "Customer" of the data table in which the name of the client is stored in the database.
In the control information, the field name used for the search represents the name of a field that needs to be searched in the searched data table. For example, for the operator control or the client control, the service data to be entered is the Name of the operator or the Name of the client, and then the field Name used for searching may be the field Name "of the Name field in the data table;
it should be noted that, in order to further increase the flexibility of implementing the present invention, the service data can be searched by using a flexible search condition, in a preferred embodiment of the present invention, when setting the field name used for searching in the control information, the field name used for searching may be set as any one field name or any combination of a plurality of field names in the data table corresponding to the service control. For example, for the salesman control, the corresponding data table is "Person", and the field names included in the data table are: the name, the mobile phone, the address, the credit limit, the age and the like, although the final business data to be input is the name of the salesperson, the name can be set as the field name for searching instead of the name, or the number or the mobile phone can be set as the field name for searching, or the combination of the name and the mobile phone can be set as the field name for searching, so that the name of the salesperson to be input can be determined by a subsequent user according to any kind of information memorized by the subsequent user.
In the control information, the field names used for display represent the names of the fields that need to be displayed to the user in the searched data table, and are set specifically to enable the display of rich service information to the user. For example, for the salesman control, the field names for display can be set to include field names such as numbers, names, mobile phones, addresses and credit limits, so that the names of all salesmen meeting the search conditions can be displayed to the user subsequently, information such as numbers, mobile phones, addresses and credit limits related to all salesmen can also be displayed, and the user can determine the name of the salesmen needing to be input according to the information such as the numbers, the mobile phones, the addresses and the credit limits.
In order to further increase the flexibility of the implementation of the present invention, in this step, the set control information may further include a field name (orderbeyname) for sorting, where the field name for sorting represents an item where the found field meeting the search condition is located, and if there are multiple items, the items are sorted according to which field, and then the service data of the field to be displayed is displayed to the user according to the order in which the items are sorted, so that the user can select and enter the required service data according to the order in which the service data are displayed. For example, for the salesman control, the field names used for sorting can be set as the credit lines, so that if a plurality of items are searched after the user inputs the search condition of "li", the items are sorted according to the order of the credit lines of the items, then the service data required to be displayed in the items are displayed to the user according to the corresponding order of the credit lines, and the user can more easily determine the name of the salesman required to be input according to the order of the credit lines of the salesman.
It should be noted that, in order to further increase the flexibility of implementing the present invention, in a preferred embodiment of the present invention, in this step, the set control information may further include any one or two of the following two addresses:
A. the set control information comprises a page connection address for modifying data in the database. The address is used for linking to a page connection address for modifying data in the database through an 'increase' button displayed for a user in the invention in a flexible way subsequently when business data needing to be input is not stored in the database, so that corresponding business data are added in the database;
B. the set control information includes a connection address of the information display page. The address is a complete information page connection address which can be linked to the service data required by the user through the display button displayed for the user in the invention in the subsequent process, thereby providing all detailed information related to the service data for the user.
In the following description, a description will be given taking an example in which the field name for sorting and two kinds of addresses in the above-described points a and B are included in the control information.
Step 102: an auxiliary box handling code is bound to each acquired focus event in advance.
At this point, the procedure of the preset in the BS system is completed.
Step 103: when the user logs in, the user inputs user information (such as a user name and a password), whether the user has the authority of adding service data in the database is judged according to the user information, if so, step 104 is executed, otherwise, step 105 is executed.
Step 104: and (3) a user opens a page on the browser, detects a focus obtaining event of the current business control on the page, displays an auxiliary entry box under the current business control by the auxiliary entry box processing code bound by the focus obtaining event, and executes step 106, wherein the displayed auxiliary entry box comprises an 'increase' button.
Step 105: and a user opens a page on the browser, detects a focus obtaining event of a current business control on the page, and executes an auxiliary entry frame processing code bound by the focus obtaining event to display the auxiliary entry frame under the current business control, wherein the displayed auxiliary entry frame does not comprise an 'increase' button.
For step 104 and step 105, for example, the user opens a page for placing an order, and mouse clicks on the clerk control of the page, that is, the system detects the event of getting focus of the clerk control, and then displays an auxiliary entry box under the clerk control.
Step 106: and acquiring control information corresponding to the current service control.
Step 107: and receiving a search condition input by a user in a text box of the current business control.
For example, for the salesman control, if in step 101, the field name used for searching in the control information corresponding to the salesman control is set as any one field name or any combination of multiple field names in the data table, then the search condition input by the user may be any one or combination of multiple information related to the salesman in the memory of the user, for example, when the name field is set as the field name used for searching, the user may input the last name "li" of the salesman as the search condition, and when the number field or the mobile phone field is set as the field name used for searching, the user may input the number of the salesman or the mobile phone as the search condition, etc.
Step 108: and finding the corresponding data table in the database according to the data table name in the control information acquired in the step 106.
For example, for the operator control, the data table named "Person" in the database is searched according to the data table name "Person" in the corresponding control information. Suppose that the "Person" data table includes entries for 6 IDs as follows:
ID Code Name Credit Phone
1001 Zhan San 500013611X
2002 Liquan 200013962X
3003 Wanyi 100013353X
4004 Liu Yi 100013753X
5005 Wang Total 500013662X
6006 Liquan 3000013853X
Step 109: and finding the item where the field meeting the search condition is located in the data table according to the field name used for searching in the control information acquired in the step 106.
For example, for the salesman control, if the field name for searching that is preset is name and the search condition input in step 107 is the last name "li" of the salesman, then the items where all the fields of the name include the field of the last name "li" are located are found in the data table with the name "Person", for example, two items with IDs of 2 and 6 are found in the data table with the name "Person".
Step 110: and searching fields needing to be displayed in the items where the fields meeting the search conditions are located according to the field names used for displaying in the acquired control information.
For example, for the salesman control, if the field name set in step 101 for display includes a code, a name, a mobile phone, and a credit line, in this step, the code, the name, the mobile phone, and the credit line field are found in the item where the name field including "li" is found.
Step 111: and sequencing the searched items according to the field names used for sequencing in the acquired control information.
For example, for the salesman control, if the field name for sorting set in step 101 is the credit line, in this step, the searched items are sorted according to the credit line. After the two searched items with the IDs of 2 and 6 are sorted according to the credit limit in the above-mentioned "Person" data table, the order is first item 6 and then item 2.
It should be noted that, as will be understood by those skilled in the art, the process from step 108 to step 111 is actually that the server generates an SQL query statement and sends the SQL query statement to the database, and the database performs a search according to the SQL query statement and returns the final search result to the server. For example, for the operator control, if the control information TableName is "Person"; SearchName ═ Name ″; DisplayName ═ Code as Code, Name as Name "; OrderByName ═ Credit "; the user enters the search condition of "plum". The generated SQL statement may then be: "select Code as Code, Name as from Person where Name like"% plum% order by Credit
Step 112: and displaying the searched service data in the field to be displayed in each item in the auxiliary entry frame under the current service control according to the sequence of the ordered items, and displaying a display button for each searched item.
Fig. 2 is a schematic display diagram of service data provided to a user in the embodiment of the present invention. For the attendant controls, the final displayed results according to the above processing of the various steps may be as shown in fig. 2.
Step 113: when detecting that a user triggers a display button of an item, splicing an identification value (ID) of the item and a connection address of an information display page in the acquired control information into an address, and opening the address.
For example, referring to fig. 2, for the operator control, if the user triggers the "show" button encoded as the item of 002, the identification value ID of the item is 2, then the address of the concatenation is in the form of:http://www. .cn/persons.aspxID＝2open this connection address, so that all detailed information of the business member corresponding to the item, such as age, photo, etc., can be displayed to the user through the connection address.
In this step, the spliced addresses can be opened in a pop-up window manner or in a pop-up page.
Step 114: and if the condition that the user triggers an 'increase' button in the auxiliary entry frame is detected, opening a page connection address for modifying data in the database in the acquired control information.
The case where this step applies may be: the displayed auxiliary entry frame includes an "add" button, that is, it is determined in step 103 that the user has the authority to add the service data in the database, and the user does not find the service data to be entered from all the service data displayed in the auxiliary entry frame under the current service control, the page connection address for modifying the data in the database can be opened by clicking the "add" button, so that the subsequent processing of adding the service data in the database can be executed.
It should be noted that, the user may trigger the "add" button not only in this step 114, but actually trigger the "add" button at any time after step 104, so as to open the page connection address for modifying the data in the database, and perform the process of adding the service data in the database.
In addition, the invention also provides a device for providing the service data. Referring to fig. 3, the basic structure of the apparatus includes:
the control information processing unit is used for setting and storing control information corresponding to each service control, and the control information comprises a data table name, a field name for displaying and a field name for searching;
the event processing unit is used for acquiring control information corresponding to the current business control from the control information processing unit when the focus acquiring event of the current business control is detected, receiving a search condition input by a user, sending the search condition and the acquired control information to the search execution unit, and providing the received business data in a field needing to be displayed in each item to the user;
the search execution unit is used for searching the corresponding data table in the database according to the data table name in the acquired control information; searching the item where the field meeting the search condition is located in the data table according to the field name used for searching in the acquired control information; searching fields needing to be displayed in the items where the fields are located according to the field names used for displaying in the acquired control information; and sending the found business data in the field needing to be displayed in each item to the event processing unit.
Specifically, the search execution unit completes the search and search functions thereof by generating a query statement and sending the query statement to the database.
In order to perform a search under any flexible search condition by using the apparatus of the present invention, the field name used for the search in the control information corresponding to each service control set and stored by the control information processing unit may be preferably: any field name or any combination of a plurality of field names in the data table corresponding to the service control.
In order to provide service data for a user in a more friendly auxiliary entry box mode by using the device of the invention and avoid the user from executing operations of closing pop-up windows or pages and the like, the event processing unit further binds each acquired focus event with an auxiliary entry box processing code; when a focus obtaining event of the current business control is detected, triggering an auxiliary entry frame processing code bound by the focus obtaining event to execute and display an auxiliary entry frame under the current business control; and displaying the business data in the fields needing to be displayed in each received item in an auxiliary entry box under the current business control.
In order to enable the user with authority to add non-existent service data in the database, the device of the present invention may further comprise an authentication unit; wherein,
the control information set and stored by the control information processing unit further comprises a page connection address for modifying data in the database;
the authentication unit judges whether the user has the authority of adding the service data in the database according to the user information input by the user when the user logs in, and if so, the authentication unit sends an authentication success notification to the event processing unit;
the event processing unit displays an adding button to a user after detecting a focus obtaining event of the current business control if receiving the authentication success notification; and when detecting that the user triggers an adding button, opening the page connection address in the acquired control information.
In order to display various rich information related to a service data to a user, in the device of the invention, the control information set and stored by the control information processing unit further comprises a connection address of an information display page;
and the event processing unit further displays a display button for each received item, splices the identification value of the item and the connection address of the information display page in the acquired control information into an address when detecting that the user triggers the display button of the item, and opens the address.
In order to further facilitate the user to select and enter the required service data according to the sequence displayed by each service data, in the device of the invention,
the control information set and stored by the control information processing unit further comprises field names used for sorting;
the search execution unit is further configured to, after finding the field to be displayed, sort the found items according to the field names used for sorting in the acquired control information, and send the service data of the field to be displayed in each sorted item to the event processing unit.
For the apparatus proposed by the present invention, the control information processing unit may be disposed in a server of the BS system, the event processing unit may be disposed in a browser of the BS system, and the search execution unit may also be disposed in the server of the BS system.
It should be noted that, in the above embodiment of the present invention, when providing service data to a user, an auxiliary entry box manner is used, and the auxiliary entry box manner is directly displayed under a service control, and can automatically disappear when processing other service controls, so that a process that the user has to close a window or a page when processing other service controls in a pop-up window manner or a pop-up page manner is omitted, and the implementation friendliness of the present invention is increased. However, displaying the provided service data in the form of the auxiliary entry box is only a preferred implementation manner of the present invention, and in an actual service implementation, displaying the provided service data in the form of a pop-up window or a pop-up page can also implement the present invention.
From the above description, it is clear to those skilled in the art that the present invention may be embodied as a computer program product, which can be carried out by various storage media, and includes instructions for causing a hardware platform to perform the method. An apparatus according to the invention can comprise a computer program product as described above and a hardware platform running the computer program, as will be appreciated from the apparatus level.
In short, the above description is only a preferred embodiment of the present invention, and does not limit the protection scope of the present invention. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (13)
1. A method for providing service data is characterized in that control information corresponding to each service control is set, the control information comprises a data table name, a field name for displaying and a field name for searching, and the method further comprises the following steps:
detecting an event of acquiring a focus of a current business control, and acquiring control information corresponding to the current business control;
receiving a search condition input by a user; searching a corresponding data table in a database according to the data table name in the acquired control information; according to the field name used for searching in the acquired control information, searching the item where the field meeting the searching condition is located in the data table; searching fields needing to be displayed in the searched items according to the field names used for displaying in the acquired control information;
and providing the searched business data of the fields needing to be displayed in each item to the user.
2. The method according to claim 1, wherein the field name used for searching in the control information corresponding to each service control is: any field name or any combination of a plurality of field names in the data table corresponding to the service control.
3. The method of claim 1, further comprising: binding an auxiliary input frame processing code to each acquired focus event in advance;
when the event of obtaining focus of the current business control is detected, the method further comprises the following steps: the auxiliary entry frame processing code bound by the obtained focus event executes to display the auxiliary entry frame under the current business control;
the step of providing the searched service data of the fields required to be displayed in each item to the user comprises the following steps: and displaying the business data of the field needing to be displayed in each project in the auxiliary entry box under the current business control by the auxiliary entry box processing code.
4. The method for providing service data according to claim 1, 2 or 3, wherein the control information further comprises a page connection address for modifying data in the database;
the method further comprises the following steps: when a user logs in, judging whether the user has the authority of adding service data in a database according to user information input by the user, and if so, displaying an adding button after detecting a focus obtaining event of the current service control; and when detecting that the user triggers an adding button, opening the page connection address in the acquired control information.
5. The method for providing service data according to claim 1, 2 or 3, wherein the control information further comprises a connection address of an information display page;
the method further comprises the following steps: and displaying a display button for each searched item, splicing the identification value of the item and the connection address of the information display page in the acquired control information into an address when the display button of one item is detected to be triggered by a user, and opening the address.
6. A method for providing service data according to claim 1, 2 or 3, wherein the control information further includes field names for sorting;
after the finding of the fields to be displayed and before the providing of the service data of the fields to be displayed in each item to the user, further comprising: sorting the searched items according to the field names used for sorting in the acquired control information;
the step of providing the searched service data of the fields required to be displayed in each item to the user comprises the following steps: and providing the searched service data of the fields needing to be displayed in each item to the user according to the sequence after the items are sequenced.
7. An apparatus for providing service data, the apparatus comprising:
the control information processing unit is used for setting and storing control information corresponding to each service control, and the control information comprises a data table name, a field name for displaying and a field name for searching;
the event processing unit is used for acquiring control information corresponding to the current business control from the control information processing unit when the focus acquisition event of the current business control is detected, receiving a search condition input by a user, sending the search condition and the acquired control information to the search execution unit, and providing the received business data of a field needing to be displayed in each item to the user;
the search execution unit is used for searching the corresponding data table in the database according to the data table name in the acquired control information; searching the item where the field meeting the search condition is located in the data table according to the field name used for searching in the acquired control information; searching fields needing to be displayed in the searched items according to the field names used for displaying in the acquired control information; and sending the found business data of the fields needing to be displayed in each item to the event processing unit.
8. The apparatus for providing service data according to claim 7,
in the control information corresponding to each service control set and stored by the control information processing unit, the field name used for searching is: any field name or any combination of a plurality of field names in the data table corresponding to the service control.
9. The apparatus for providing service data according to claim 7,
the event processing unit further binds each acquired focus event with an auxiliary log-in box processing code; when a focus obtaining event of the current business control is detected, triggering an auxiliary entry frame processing code bound by the focus obtaining event to execute and display an auxiliary entry frame under the current business control; and displaying the business data in the fields needing to be displayed in each received item in an auxiliary entry box under the current business control.
10. An arrangement for providing service data according to claim 7, 8 or 9, characterized in that the arrangement further comprises an authentication unit; wherein,
the control information set and stored by the control information processing unit further comprises a page connection address for modifying data in the database;
the authentication unit judges whether the user has the authority of adding the service data in the database according to the user information input by the user when the user logs in, and if so, the authentication unit sends an authentication success notification to the event processing unit;
the event processing unit displays an adding button to a user after detecting a focus obtaining event of the current business control if receiving the authentication success notification; and when detecting that the user triggers an adding button, opening the page connection address in the acquired control information.
11. The apparatus for providing service data according to claim 7, 8 or 9,
the control information set and stored by the control information processing unit further comprises a connection address of an information display page;
and the event processing unit further displays a display button for each received item, splices the identification value of the item and the connection address of the information display page in the acquired control information into an address when detecting that the user triggers the display button of the item, and opens the address.
12. The apparatus for providing service data according to claim 7, 8 or 9,
the control information set and stored by the control information processing unit further comprises field names used for sorting;
the search execution unit is further configured to, after finding the field to be displayed, sort the found items according to the field names used for sorting in the acquired control information, and send the service data of the field to be displayed in each sorted item to the event processing unit.
13. The apparatus for providing service data according to claim 7, 8 or 9,
the control information processing unit and the search execution unit are provided in a server;
the event processing unit is arranged in the browser.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2009100870329A CN101576914A (en) | 2009-06-22 | 2009-06-22 | Method and device for providing service data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2009100870329A CN101576914A (en) | 2009-06-22 | 2009-06-22 | Method and device for providing service data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101576914A true CN101576914A (en) | 2009-11-11 |
Family
ID=41271847
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2009100870329A Pending CN101576914A (en) | 2009-06-22 | 2009-06-22 | Method and device for providing service data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101576914A (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102402515A (en) * | 2010-09-10 | 2012-04-04 | 深圳市鹏海运电子数据交换有限公司 | General custom query system and method |
| CN103186322A (en) * | 2011-12-29 | 2013-07-03 | 金蝶软件（中国）有限公司 | Data entry method and device |
| CN103576889A (en) * | 2012-07-23 | 2014-02-12 | 富士通株式会社 | Input support method, and input support apparatus |
| CN104360758A (en) * | 2014-11-19 | 2015-02-18 | 无锡悟莘科技有限公司 | Key auxiliary input method for computer keyboard |
| CN104572663A (en) * | 2013-10-15 | 2015-04-29 | 镇江金软计算机科技有限责任公司 | Realizing method for intelligently searching classifiable data based on JSP |
| CN105335857A (en) * | 2014-08-08 | 2016-02-17 | 国家电网公司 | Data search method and apparatus |
| CN106022955A (en) * | 2016-05-16 | 2016-10-12 | 国网山东省电力公司电力科学研究院 | Voltage transformer account check system and method based on equipment model analysis |
| CN108228695A (en) * | 2017-06-30 | 2018-06-29 | 勤智数码科技股份有限公司 | A kind of dynamic real-time update method of business datum |
| CN112199483A (en) * | 2020-10-10 | 2021-01-08 | 深圳壹账通智能科技有限公司 | Information input assisting method and device, electronic equipment and storage medium |
-
2009
- 2009-06-22 CN CNA2009100870329A patent/CN101576914A/en active Pending
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102402515A (en) * | 2010-09-10 | 2012-04-04 | 深圳市鹏海运电子数据交换有限公司 | General custom query system and method |
| CN103186322A (en) * | 2011-12-29 | 2013-07-03 | 金蝶软件（中国）有限公司 | Data entry method and device |
| CN103186322B (en) * | 2011-12-29 | 2016-01-20 | 金蝶软件（中国）有限公司 | Data entry method and device |
| CN103576889A (en) * | 2012-07-23 | 2014-02-12 | 富士通株式会社 | Input support method, and input support apparatus |
| CN104572663A (en) * | 2013-10-15 | 2015-04-29 | 镇江金软计算机科技有限责任公司 | Realizing method for intelligently searching classifiable data based on JSP |
| CN105335857A (en) * | 2014-08-08 | 2016-02-17 | 国家电网公司 | Data search method and apparatus |
| CN104360758A (en) * | 2014-11-19 | 2015-02-18 | 无锡悟莘科技有限公司 | Key auxiliary input method for computer keyboard |
| CN106022955A (en) * | 2016-05-16 | 2016-10-12 | 国网山东省电力公司电力科学研究院 | Voltage transformer account check system and method based on equipment model analysis |
| CN108228695A (en) * | 2017-06-30 | 2018-06-29 | 勤智数码科技股份有限公司 | A kind of dynamic real-time update method of business datum |
| CN112199483A (en) * | 2020-10-10 | 2021-01-08 | 深圳壹账通智能科技有限公司 | Information input assisting method and device, electronic equipment and storage medium |
| WO2022073513A1 (en) * | 2020-10-10 | 2022-04-14 | 深圳壹账通智能科技有限公司 | Information input assistance method and apparatus, electronic device and storage medium |
| CN112199483B (en) * | 2020-10-10 | 2023-03-17 | 深圳壹账通智能科技有限公司 | Information input assisting method and device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101576914A (en) | Method and device for providing service data | |
| US10073893B2 (en) | Internet and database mining to generate database records | |
| CN1648902B (en) | System and method for a unified and blended search | |
| CN103488781B (en) | Method, the search engine server of information search are provided | |
| CN103488785B (en) | Method, system and the server of search service are provided | |
| CN103777980A (en) | Website commenting information loading method and browser | |
| CN101964044B (en) | Method and device for acquiring bar code from browser of mobile phone | |
| CN105511727B (en) | A kind of message treatment method and device | |
| CN103488786A (en) | Method and client terminal for providing information search | |
| CN107168599B (en) | Instant messaging method and device | |
| CN102541853A (en) | Method and device which are capable of obtaining application information by utilizing browser address bar | |
| CN106569860A (en) | Application management method and terminal | |
| CN103177025A (en) | Recommendation method and device of answer information by information interactive question and answer system | |
| CN103793495B (en) | Application message search method and system and application message acquisition methods and system | |
| CN107291789B (en) | Invoice information indexing method and device | |
| CN107465797B (en) | Incoming call information display method and device for terminal equipment | |
| CN111240558A (en) | Information searching method, device, terminal and storage medium | |
| KR101307578B1 (en) | System for supplying a representative phone number information with a search function | |
| CN106203036A (en) | The operation copy hidden method opened based on application and device more | |
| CN101014021B (en) | Method, system and client for searching user in instant messaging client | |
| CN104765747A (en) | Webpage processing method and device | |
| CN104580639A (en) | Information loading method and device based on telephone number | |
| CN105512208B (en) | Information publishing method, device and system | |
| CN103793499B (en) | A kind of method and apparatus obtaining application message using browser address bar | |
| CN103678601A (en) | Model essay retrieval request processing method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Open date: 20091111 |