CN100403294C - Method for real-time correcting data report of client terminal - Google Patents
Method for real-time correcting data report of client terminal Download PDFInfo
- Publication number
- CN100403294C CN100403294C CNB031561977A CN03156197A CN100403294C CN 100403294 C CN100403294 C CN 100403294C CN B031561977 A CNB031561977 A CN B031561977A CN 03156197 A CN03156197 A CN 03156197A CN 100403294 C CN100403294 C CN 100403294C
- Authority
- CN
- China
- Prior art keywords
- client
- server end
- server
- report
- real time
- 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.)
- Expired - Fee Related
Links
- 238000000034 method Methods 0.000 title claims abstract description 35
- 230000008676 import Effects 0.000 claims description 3
- 230000000153 supplemental effect Effects 0.000 claims description 3
- 230000005540 biological transmission Effects 0.000 claims description 2
- 230000008569 process Effects 0.000 description 9
- 230000002950 deficient Effects 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- VLYWMPOKSSWJAL-UHFFFAOYSA-N sulfamethoxypyridazine Chemical compound N1=NC(OC)=CC=C1NS(=O)(=O)C1=CC=C(N)C=C1 VLYWMPOKSSWJAL-UHFFFAOYSA-N 0.000 description 2
- 230000008901 benefit Effects 0.000 description 1
- 230000018109 developmental process Effects 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000033772 system development Effects 0.000 description 1
Images
Abstract
The present invention relates to a method for correcting a data report form at a client terminal in real time, which comprises the following steps: a report form is configured at a server terminal; the client terminal obtains a self data report form of a usage permission in the server by invoking an application program interface function (API function) at the server terminal. The present invention can update report form statistics data items, display format and permission in real time by data configuration at the server terminal; after the report form at the server terminal is modified, the modified report form can be obtained in real time without upgrading a client terminal program.
Description
Technical field
The present invention relates to the treatment technology of network data, refer to the method for the automatic real time modifying of client (Client) data sheet realized by configuration especially in server end (Server) data.
Background technology
Existing form implementation method mainly contains two kinds: Client end form fixed configurations method and Client end form be collocation method voluntarily.
Client end form fixed configurations method, by providing some fixing report form templates that configure at the Client end, Client end program is by reading these report form templates, then according to the configuration of the data item of report form template, be connected to the Server end and obtain data and be filled into the form that generation finally shows in the report form template.
This implementation method has following defective:
1, the kind of form depends on the Report Form Design at system development initial stage, if the Client end is not considered this form when developing, then this form can't be realized.
2, the display format of report data, control authority all are that initial stage of development just fixes, and can not make amendment when using in system.
Client end form is collocation method voluntarily, by providing a form editing machine, editing machine that the user is provided visible report form statistics data item at the Client end, generates form by form editing machine editor voluntarily by the user.
This implementation method has following defective:
1, the editor who carries out form voluntarily to the Client end subscriber require too highly, the Client end subscriber can not be all has a lot of understandings to the data item of system.
2, the correctness of report data item can't well be guaranteed, because the statistics item from edlin, pass through checking, and the form of form can't be unified.
3, can not control the authority of Client end form, the Client end subscriber can be from the form of edlin oneself, and the authority of these forms is all uncontrollable.
Summary of the invention
The invention provides a kind of method, realize unified management statistical tables and reports form and authority by server end data configuration real time modifying client data form.
Method of the present invention comprises the following steps:
A) carry out the form configuration at server end;
B) client is by the application programming interfaces api function of invoking server end, input parameter information to server end request form, server end returns the input parameter information that this client has the right to use, the input parameter information that client is returned according to server end sends report parameter information to described server end;
C) described server end is according to the report parameter information of client transmission, and generating client has the data sheet of rights of using and return to described client.
Described steps A) be included in the configuration data table that the server end database is set up form, the configuration data table of this form comprises form Basic Information Table and report parameter table.
Described form Basic Information Table includes form ID, report name, form authority and form classification field at least; Described report parameter table includes the form ID and the supplemental characteristic type field of report parameter ID, report parameter name, report parameter association at least.
Described step B) client call service device end api function calls control by its api interface and realizes in.
Before the input parameter information of the end of user end to server step B) request form, more comprise the steps:
B1) behind the accessing server by customer end end, to the classification information of server end request form, server end returns on form classification information that this client has the right to use and the display interface that is shown in client;
B2) report messages under the user end to server end request classification, server end return on report messages that this client has the right to use and the display interface that is shown in client.
Step B) server end described in returns the input parameter information that this client has the right to use, and the input parameter information that client is returned according to server end sends report parameter information to described server end, specifically comprises:
Server end returns the input parameter information that this client has the right to use and make up the inputting interface of an input parameter on the display interface of client, imports correlation parameter for the user;
Client passes to server end simultaneously to server end request form object information with input parameter.
Behind the accessing server by customer end end, obtain a unique ID in the said method, when client is sent solicited message, all this unique ID is passed to server end at every turn from server end.
Described client has the data sheet of rights of using can the form configuration by server end to set or on-the-fly modify.
The inventive method has following advantage:
But 1, pass through report form statistics data item, display format and the authority of the data configuration real-time update client of server end.
2, after server end carried out the form modification, client-side program need not to upgrade and can obtain amended form in real time.
3, the checking of obtaining, show the process system manager of report data item realizes effective management of form.
Description of drawings
Fig. 1 is the signal reciprocal process synoptic diagram that the request of user end to server end shows form in the inventive method.
Embodiment
At first need in the inventive method to carry out the form configuration, therefore, set up the configuration data table of form in the Server client database at server (Server) end.
The data configuration table of Server end form is described in detail as follows:
(1)tblQueryTable
[table implication]
The form Basic Information Table
[list structure]
[QueryID][int]NOT?NULL，
[QueryName][varchar](500)NOT?NULL，
[ProcedureName][varchar](50)NOT?NULL，
[Role][varchar](50)NOT?NULL，
[Category][varchar](200)NULL
[field implication]
QueryID: form ID.
QueryName: the title of form.
ProcedureName: form need call the storing process name.
Role: the permissions list of form.
Category: the classification of form.
(2)tblQueryParamTable
[table implication]
The report parameter table
[list structure]
[ParamID][int]IDENTITY(0，1)NOT?NULL，
[ParamName][varchar](200)NOT?NULL，
[ParamSerialNo][int]NOT?NULL，
[QueryID][int]NOT?NULL，
[ParamType][int]NOT?NULL，
[InnerIDType][int]NOT?NULL，
[IsAppClientID][bit]NOT?NULL，
[IsOutIDType][bit]NOT?NULL，
[InnerParamType][int]NOT?NULL，
[SQL][varchar](512)NULL，
[ValueType][int]NOT?NULL，
[ValueLen][int]NOT?NULL，
[ValueParamName][varchar](50)NOT?NULL
[field implication]
ParamID: report parameter ID.
ParamName: report parameter name.
ParamSerialNo: the serial number of report parameter.
QueryID: the form ID of parameter association.
ParamType: supplemental characteristic type.
InnerIDType: inner constant ID number.
InnerParamType: inner constant type.
SQL: parameter is taken out the SQL statement of the tabulation usefulness of retrieving from database.
ValueType: to the type of the storing process input parameter of form correspondence.
ValueLen: to the length of the storing process input parameter of form correspondence.
ValueParamName: to the parameter name of the storing process input parameter of form correspondence.
Use the allocation list of above-mentioned these two forms, the Server end just can provide form to the Client end.
The Server end is described in detail as follows for the application program interface function (api function) that the Client end provides:
(1)GetQueryCategory
[function implication]
Obtain the classification of the form of authority
[function declaration]
Obtain the active user in the classification that Server holds the form that authority is arranged by this api function, be used for the demonstration of Client end, and further obtain the form under each classification.
[function form]
function?GetQueryCategory(
var?CategoryNum：Integer；
var?CategoryArray：OLEVariant；
var?ErrorInfo：string)：Integer；
[parameter declaration]
CategoryNum: return the number that Client end active user has the form classification of authority.
CategoryArray: return the class name array that Client end active user has the form classification of authority.
ErrorInfo: the error message when this function is carried out failure.
[returned value specification]
Integer is returned 0 and is represented successfully, otherwise is error number.
(2)GetQueryUnderCategory
[function implication]
Obtain having under certain classification the form of authority
[function declaration]
Obtain the active user has authority under certain classification form by this api function, be used for the demonstration of Client end, and the parameter information that further obtains each form.
[function form]
function?GetQueryUnderCategory(
Category：string；
var?QueryNum：Integer；
var?IDArray，NameArray：OLEVariant；
var?ErrorInfo：string)：Integer；
[parameter declaration]
Category: form class name.
QueryNum: return the number that the authority form is arranged under this classification.
IDArray: returning has the ID of authority form array under this classification.
NameArray: returning has the report name of authority form array under this classification.
ErrorInfo: the error message when this function is carried out failure.
[returned value specification]
Integer is returned 0 and is represented successfully, otherwise is error number.
(3)GetQueryParamByQueryID
[function implication]
Obtain the input parameter tabulation of certain form
[function declaration]
Obtaining the active user by this api function needs the parameter list imported in certain form, be used for the demonstration of Client end form input parameter, and the Query Result information of further obtaining each form.
[function form]
function?GetQueryParamByQueryID(
QueryID：Integer；
var?ParamNum：Integer；
var?ParamInfo：array?of?TParamDesc；
var?ErrorInfo：string)：Integer；
[parameter declaration]
QueryID: form ID.
ParamNum: the number of returning this form input parameter.
ParamInfo: the array of returning the input parameter information of this form.
ErrorInfo: the error message when this function is carried out failure.
[returned value specification]
Integer is returned 0 and is represented successfully, otherwise is error number.
(4)GetQueryDataByQueryID
[function implication]
Obtain the Query Result of certain form
[function declaration]
Obtain the Query Result of active user in certain form by this api function, be used for the demonstration of Client end report query.
[function form]
function?GetQueryDataByQueryID(
QueryID，
ParamNum：Integer；
ParamNameArray，ParamValueArray：OLEVariant；
var?FieldNum，RecordNum：Integer；
var?FieldNameArray，RecordDataArray：OLEVariant；
var?ErrorInfo：string)：Integer；
[parameter declaration]
QueryID: form ID.
ParamNum: the number of this form input parameter.
ParamNameArray: the parameter name array of this form input parameter.
ParamValueArray: the parameter value array of this form input parameter.
FieldNum: the Field Count that returns this report query result set.
RecordNum: the record strip number that returns this report query result set.
FieldNameArray: the field name array of returning the field of this report query result set.
RecordDataArray: the record array of returning the record of this report query result set.
ErrorInfo: the error message when this function is carried out failure.
[returned value specification]
Integer is returned 0 and is represented successfully, otherwise is error number.
The Client end calls control by api interface to carry out the above-mentioned api function of Server end is called, and obtains report messages, just can demonstrate form.
This interface interchange control can be finished calling Server end remote object, remote method by the DCOM agreement of Microsoft.
Shown in Figure 1 is that the Client end shows the signal reciprocal process synoptic diagram that form is realized, its signal reciprocal process is as follows:
1, behind the accessing server by customer end end, send the classification information of request form to server end, server end returns on form classification information that this client has the right to use and the display interface that is shown in client;
2, the report messages of the user end to server end request of sending under certain classification, server end return on report messages that this client has the right to use and the display interface that is shown in client;
3, the user end to server end sends the input parameter information of certain form of request, and server end returns the input parameter information that this client has the right to use and make up the inputting interface of an input parameter on the display interface of client, imports correlation parameter for the user;
4, client passes to server end sends simultaneously information from request form result to server end with input parameter, and server end returns the object information of this form according to the input parameter of client and is shown on the display interface of client.
In the said process, Client is by after inputing user name, password login Server, obtain unique ID of this Client, each request call of Client, all need the ID with unique Client, pass to Server, Server is by the permissions list of Role field among the tblQueryTable in the database, carry out the control of user right, filter out the data of Client lack of competence.In addition, in the GetQueryDataByQueryID function, the authority that Server also can be different according to Client returns to the different report query result of Client.Like this, by a kind of easy mode, the user that can realize different rights sees different forms, different form input parameters, and different report query results has realized form mechanism very flexibly.Simultaneously, by real-time increase, the modification of record in table of the tblQueryTable in the database of Server and the tblQueryParamTable table, can realize the real-time update of Client end form easily.
The above; only for the preferable embodiment of the present invention, but protection scope of the present invention is not limited thereto, and anyly is familiar with those skilled in the art in the technical scope that the present invention discloses; the variation that can expect easily or replacement all should be encompassed within protection scope of the present invention.Therefore, protection scope of the present invention should be as the criterion with the protection domain of claims.
Claims (8)
1. the method for a real time modifying client data form comprises the following steps:
A) carry out the form configuration at server end;
B) client is by the application programming interfaces api function of invoking server end, input parameter information to server end request form, server end returns the input parameter information that this client has the right to use, the input parameter information that client is returned according to server end sends report parameter information to described server end;
C) described server end is according to the report parameter information of client transmission, and generating client has the data sheet of rights of using and return to described client.
2. the method for real time modifying client data form as claimed in claim 1, it is characterized in that: described steps A) be included in the configuration data table that the server end database is set up form, the configuration data table of this form comprises form Basic Information Table and report parameter table.
3. the method for real time modifying client data form as claimed in claim 2 is characterized in that: described form Basic Information Table includes form ID, report name, form authority and form classification field at least; Described report parameter table includes the form ID and the supplemental characteristic type field of report parameter ID, report parameter name, report parameter association at least.
4. the method for real time modifying client data form as claimed in claim 1 is characterized in that: client call service device end api function calls control by its api interface and realizes described step B).
5. the method for real time modifying client data form as claimed in claim 1 is characterized in that: before the input parameter information of the end of user end to server step B) request form, more comprise the steps:
B1) behind the accessing server by customer end end, to the classification information of server end request form, server end returns on form classification information that this client has the right to use and the display interface that is shown in client;
B2) report messages under the user end to server end request classification, server end return on report messages that this client has the right to use and the display interface that is shown in client.
6. the method for real time modifying client data form as claimed in claim 5, it is characterized in that: server end step B) returns the input parameter information that this client has the right to use, the input parameter information that client is returned according to server end, send report parameter information to described server end, specifically comprise:
Server end returns the input parameter information that this client has the right to use and make up the inputting interface of an input parameter on the display interface of client, imports correlation parameter for the user;
Client passes to server end simultaneously to server end request form object information with input parameter.
7. the method for real time modifying client data form as claimed in claim 6, it is characterized in that: behind the accessing server by customer end end, obtain a unique ID from server end, when client is sent solicited message, all this unique ID is passed to server end at every turn.
8. the method for real time modifying client data form as claimed in claim 1 is characterized in that: described client has the data sheet of rights of using can the form configuration by server end to set or on-the-fly modify.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB031561977A CN100403294C (en) | 2003-09-04 | 2003-09-04 | Method for real-time correcting data report of client terminal |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB031561977A CN100403294C (en) | 2003-09-04 | 2003-09-04 | Method for real-time correcting data report of client terminal |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1591392A CN1591392A (en) | 2005-03-09 |
| CN100403294C true CN100403294C (en) | 2008-07-16 |
Family
ID=34598341
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNB031561977A Expired - Fee Related CN100403294C (en) | 2003-09-04 | 2003-09-04 | Method for real-time correcting data report of client terminal |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN100403294C (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101166118B (en) * | 2007-09-30 | 2011-06-08 | 华为技术有限公司 | A method for processing user configuration information and service report system |
| KR101012872B1 (en) * | 2009-09-16 | 2011-02-08 | 주식회사 팬택 | Security apparatus and method for open platform |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1395193A (en) * | 2001-07-05 | 2003-02-05 | 英业达股份有限公司 | Method fro producing dynamic form which can be edited on web page |
| CN1397900A (en) * | 2001-07-19 | 2003-02-19 | 英业达股份有限公司 | Data updating method and system |
| CN1438591A (en) * | 2002-02-10 | 2003-08-27 | 华为技术有限公司 | Method for realizing intelligent report forms |
-
2003
- 2003-09-04 CN CNB031561977A patent/CN100403294C/en not_active Expired - Fee Related
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1395193A (en) * | 2001-07-05 | 2003-02-05 | 英业达股份有限公司 | Method fro producing dynamic form which can be edited on web page |
| CN1397900A (en) * | 2001-07-19 | 2003-02-19 | 英业达股份有限公司 | Data updating method and system |
| CN1438591A (en) * | 2002-02-10 | 2003-08-27 | 华为技术有限公司 | Method for realizing intelligent report forms |
Non-Patent Citations (2)
| Title |
|---|
| 基于B/S结构的学生信息管理系统的研究与开发. 周璋鹏.西北电力技术，第31卷第4期. 2003 |
| 基于B/S结构的学生信息管理系统的研究与开发. 周璋鹏.西北电力技术，第31卷第4期. 2003 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN1591392A (en) | 2005-03-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CA2555630C (en) | Integrated deployment of software projects | |
| US9195707B2 (en) | Distributed event system for relational models | |
| CN101729594B (en) | Remote configuration control method and system | |
| US20180240130A1 (en) | System, information management method, and information processing apparatus | |
| CN105868202A (en) | Multi-platform access data management system | |
| CN104123227A (en) | Method for automatically generating testing cases | |
| US20060129652A1 (en) | System to coordinate the execution of a plurality of separate computer systems to effectuate a process (as amended in search report) | |
| JP2006520575A (en) | Relational model for management information in network services | |
| WO2003088032A1 (en) | Data exchange method and system | |
| CN111401029A (en) | Document version updating system and method based on document partition and collaborative editing | |
| CN113220633A (en) | Unified file coding management method and system | |
| US20120011164A1 (en) | Life cycle based data coordination | |
| CN100403294C (en) | Method for real-time correcting data report of client terminal | |
| US20030195879A1 (en) | Data collection technology useful for form manipulation | |
| Cisco | Using Info Gateways | |
| Cisco | Using Info Gateways | |
| CN102663614B (en) | Customer relation management is to the collocation method of service release and system | |
| US7409403B1 (en) | Alert management data infrastructure and configuration generator | |
| KR20210051817A (en) | System and method for providing an authentication information service based an open api | |
| WO2010119628A1 (en) | System and method for environment information aggregation | |
| CN113568676B (en) | General method for rapidly releasing internet service on commercial platform | |
| JPH10301941A (en) | Document information sharing system | |
| Kanarek et al. | Internet data collection at the US census bureau | |
| CN112884434A (en) | Project automatic generation method and device and project management system | |
| CN116109029A (en) | Operation and maintenance management portal system based on operation and maintenance guarantee service management platform |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| ASS | Succession or assignment of patent right |
Owner name: HUAWEI DIGITAL TECHNOLOGY CO. Free format text: FORMER OWNER: HUAWEI TECHNOLOGY CO., LTD. Effective date: 20081010 |
|
| C41 | Transfer of patent application or patent right or utility model | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20081010 Address after: No. 3, information road, Haidian District, Beijing Patentee after: Huawei Digit Technology Co., Ltd. Address before: HUAWEI Service Center building, 1 FA FA Road, Nanshan District science and Technology Park, Shenzhen, Guangdong Patentee before: Huawei Technologies Co., Ltd. |
|
| CP01 | Change in the name or title of a patent holder |
Address after: 100085 Beijing, Haidian District on the road, No. 3 Patentee after: Beijing Huawei Digital Technology Co.,Ltd. Address before: 100085 Beijing, Haidian District on the road, No. 3 Patentee before: Huawei Digit Technology Co., Ltd. |
|
| CP01 | Change in the name or title of a patent holder | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20080716 Termination date: 20180904 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |