CN102567032B - The collocation method of General Purpose Interface and computing machine - Google Patents

The collocation method of General Purpose Interface and computing machine Download PDF

Info

Publication number
CN102567032B
CN102567032B CN201010578764.0A CN201010578764A CN102567032B CN 102567032 B CN102567032 B CN 102567032B CN 201010578764 A CN201010578764 A CN 201010578764A CN 102567032 B CN102567032 B CN 102567032B
Authority
CN
China
Prior art keywords
tab
interface
page
initialization
querying condition
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201010578764.0A
Other languages
Chinese (zh)
Other versions
CN102567032A (en
Inventor
郑圣宝
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Kingdee Software China Co Ltd
Original Assignee
Kingdee Software China Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Kingdee Software China Co Ltd filed Critical Kingdee Software China Co Ltd
Priority to CN201010578764.0A priority Critical patent/CN102567032B/en
Publication of CN102567032A publication Critical patent/CN102567032A/en
Application granted granted Critical
Publication of CN102567032B publication Critical patent/CN102567032B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Landscapes

  • User Interface Of Digital Computer (AREA)
  • Information Transfer Between Computers (AREA)

Abstract

The present invention relates to a kind of collocation method and computing machine of General Purpose Interface, it comprises: carry out initialization to the tab of the needs display in interface; Filtercondition in described tab is set; The described content needing the tab of display is obtained according to described filtercondition.Be convenient to the maintenance at business interface, uniform format, expansion is convenient, and the experience property of user is good.

Description

The collocation method of General Purpose Interface and computing machine
Technical field
The present invention relates to field of computer technology, specifically the collocation method of General Purpose Interface and computing machine.
Background technology
The filtercondition that different business needs provides is not quite similar, and each business constructs a set of filtering interface, and not only realizing upper cost can increase, and inconvenience is safeguarded, and entire system style also disunity.And give the experience of user also bad, when existing filtration cannot be met customer need time, expansion is got up more difficult.
Summary of the invention
Fundamental purpose of the present invention is to provide a kind of collocation method and computing machine of General Purpose Interface, is convenient to the maintenance at business interface, uniform format, and expansion is convenient, and the experience property of user is good.
The technical solution adopted for the present invention to solve the technical problems is:
A collocation method for General Purpose Interface, it comprises:
Initialization is carried out to the tab of the needs display in interface;
Filtercondition in described tab is set;
The described content needing the tab of display is obtained according to described filtercondition.
Preferably, the described project to the needs display in the tab at interface carries out initialization, specifically comprises:
Judge need the tab of display and obtain XML configuration file according to the parameter imported into;
The tab shown is needed according to described XML configuration file initialization.
Preferably, the described filtercondition arranged in described tab, specifically comprises:
The data field selecting querying condition and will represent in Query Result in described tab;
In the page of described tab, the data field carrying out sorting is selected according to described querying condition.
Preferably, the described content obtaining the tab of described needs display according to described filtercondition, specifically comprises:
According to the function statement in the project of described querying condition, selection and the sort field constructs database of selection;
Using the key assignments of described function statement as report form type;
The described key assignments as report form type is assembled into query sentence of database;
According to described query statement, inquiry is carried out to described database and obtain described Query Result, and load on shown interface and show described Query Result.
A kind of computing machine, it comprises:
Initialization unit, for carrying out initialization to the tab of the needs display in interface;
Condition setting unit, for arranging the filtercondition in described tab;
Contents acquiring unit, for obtaining the described content needing the tab of display according to described filtercondition.
Preferably, described initialization unit, comprising:
Judgment sub-unit, needs the tab of display for judging according to the parameter imported into and obtains XML configuration file;
Page initialization subelement, for needing the tab shown according to described XML configuration file initialization.
Preferably, described condition setting unit, comprising:
Querying condition chooser unit, for the data field selecting querying condition He will represent in Query Result in described tab;
Data field chooser unit, for selecting the data field carrying out sorting in the page of described tab according to described querying condition.
Preferably, described contents acquiring unit, comprising:
Constructor unit, for according to the function statement in the project of described querying condition, selection and the sort field constructs database of selection;
Key assignments arranges subelement, for described function statement being arranged the key assignments of report form type;
Assembling subelement, for being assembled into query sentence of database using the described key assignments as report form type;
Result presentation subelement, obtains described Query Result for carrying out inquiry according to described query statement to described database, and loads on shown interface and show described Query Result.
Implement technical scheme of the present invention, there is following beneficial effect: the collocation method of General Purpose Interface provided by the invention and computing machine, general polling filtering interface is set, content and the corresponding configuration file that need only construct some personalizations in time increasing new type of service inquiry on the basis of general polling filtering interface can reach effects of demand, process is very efficient, the filter type being presented to user is also very flexibly abundant, user can carry out screening from very many latitudes to data and show, the information of needs is obtained in as far as possible little data area, be convenient to safeguard, uniform format, expansion is convenient, the experience property of user is good.
Accompanying drawing explanation
The method flow diagram that Fig. 1 provides for the embodiment of the present invention;
Fig. 2 is the particular flow sheet of the step S110 of Fig. 1;
Fig. 3 is the particular flow sheet of the step S120 of Fig. 1;
Fig. 4 is the particular flow sheet of the step S130 of Fig. 1;
The structural representation of the computing machine that Fig. 5 provides for the embodiment of the present invention;
Fig. 6 is the structural representation of the initialization unit in Fig. 5;
Fig. 7 is the structural representation of the condition setting unit in Fig. 5;
Fig. 8 is the structural representation of the contents acquiring unit in Fig. 5.
The realization of the object of the invention, functional characteristics and advantage will in conjunction with the embodiments, are described further with reference to accompanying drawing.
Embodiment
In order to make object of the present invention, technical scheme and advantage clearly understand, below in conjunction with drawings and Examples, the present invention is further elaborated.Should be appreciated that specific embodiment described herein only in order to explain the present invention, be not intended to limit the present invention.
The embodiment of the present invention provides a kind of collocation method of General Purpose Interface, as shown in Figure 1, the program of the method loads on computers, the method is realized based on described computing machine, the method can be applied in the filtration configuration of form, also can be used in the configuration of the filtering interface of other business, the method comprises:
S110, in interface needs display tab carry out initialization; In the present embodiment, this step S110 specifically comprises as shown in Figure 2:
S111, the tab judging needs display according to the parameter imported into and acquisition XML (extend markup language) configuration file;
S112, need according to described XML configuration file initialization show tab.
In the present embodiment, more specifically, this tab comprises condition, project, sequence, filtration and the page such as senior, in other examples, can comprise the more page.Wherein, conditions pages obtains the value of element url (web page address) HighLevel (senior) node from described XML configuration file, carries out this page loading, with initialization.
The information that filtering page obtains in XML configuration file under Condition (condition) node in element Variable (variable) node is filled, with initialization.
The information that item page obtains in XML file under Project (project) node in element Variable node is filled, with initialization.
The information that ranking pages obtains in XML file under Sort (sequence) node in element Variable node is filled, with initialization.
The information that the senior page obtains in XML file under StatisticMode (statistics) node in element Variable node is filled, with initialization.
S120, the filtercondition arranged in described tab; In the present embodiment, as shown in Figure 3, this step S120 specifically comprises:
S121, the data field selected querying condition and will represent in Query Result in described tab; In the present embodiment, this querying condition is the querying condition selected in the page of condition, filtration, senior three tabs.
S122, in the page of described tab, select the data field that carries out sorting according to described querying condition.
S130, obtain the described content needing the tab of display according to described filtercondition.
In the present embodiment, this step S130 specifically comprises as shown in Figure 4:
S131 is according to the function statement in the sort field constructs database (SQL) of the project of described querying condition, selection and selection;
S132, using the key assignments of described function statement as report form type;
S133, the described key assignments as report form type is assembled into query sentence of database;
S134, according to described query statement, inquiry is carried out to described database and obtain described Query Result, and load on shown interface and show described Query Result.
Concrete, in the present embodiment, comprising:
According to where (searching keyword in SQL, after with the conditional statement) statement in the querying condition constructing SQL of above-mentioned selection (can be that user selects, also can be computing machine select);
According to select (field in SQL the selects keyword) statement in the filtering items constructing SQL of selection (can be that user selects, also can be that computing machine is selected).
According to orderby (the sort key word in the SQL) statement in the sort field constructing SQL of selection (can be that user selects, also can be that computing machine is selected)
The SQL fragment of above-mentioned structure left in session (a kind of mechanism sharing information in web application between the different page of server end), session can using report form type as key assignments
Call the method obtaining data, report form type parameter can be imported into when calling, this is obtained SQL fragment as key assignments from session, be assembled into the SQL query statement meeting SQL grammer
Inquire about according to described SQL query statement connection data storehouse, return Query Result, interface is carried out loading and shows described Query Result.
The collocation method of the General Purpose Interface that above-described embodiment provides, general polling filtering interface is set, content and the corresponding configuration file that need only construct some personalizations in time increasing new type of service inquiry on the basis of general polling filtering interface can reach effects of demand, process is very efficient, the filter type being presented to user is also very flexibly abundant, user can carry out screening from very many latitudes to data and show, the information of needs is obtained in as far as possible little data area, be convenient to the maintenance at business interface, uniform format, expansion is convenient, the experience property of user is good.
The embodiment of the present invention also provides a kind of computing machine for realizing said method embodiment, and as shown in Figure 5, this computing machine comprises:
Initialization unit 210, for carrying out initialization to the tab of the needs display in interface;
Condition setting unit 220, for arranging the filtercondition in described tab;
Contents acquiring unit 230, for obtaining the described content needing the tab of display according to described filtercondition.
In the above-described embodiments, more specifically, as shown in Figure 6, described initialization unit 210, comprising:
Judgment sub-unit 211, needs the tab of display for judging according to the parameter imported into and obtains XML configuration file;
Page initialization subelement 212, for needing the tab shown according to described XML configuration file initialization.
In the above-described embodiments, more specifically, as shown in Figure 7, described condition setting unit 220, comprising:
Querying condition chooser unit 221, for the data field selecting querying condition He will represent in Query Result in described tab;
Data field chooser unit 222, for selecting the data field carrying out sorting in the page of described tab according to described querying condition.
In the above-described embodiments, more specifically, as shown in Figure 8, described contents acquiring unit 230, comprising:
Constructor unit 231, for according to the function statement in the project of described querying condition, selection and the sort field constructs database of selection;
Key assignments arranges subelement 232, for described function statement being arranged the key assignments of report form type;
Assembling subelement 233, for being assembled into query sentence of database using the described key assignments as report form type;
Result presentation subelement 234, obtains described Query Result for carrying out inquiry according to described query statement to described database, and loads on shown interface and show described Query Result.
The computing machine that above-described embodiment provides, general polling filtering interface is set, content and the corresponding configuration file that need only construct some personalizations in time increasing new type of service inquiry on the basis of general polling filtering interface can reach effects of demand, process is very efficient, the filter type being presented to user is also very flexibly abundant, user can carry out screening from very many latitudes to data and show, the information of needs is obtained in as far as possible little data area, be convenient to the maintenance at business interface, uniform format, expansion is convenient, and the experience property of user is good.
These are only preferred embodiment of the present invention, not in order to limit the present invention, all any amendments done within the spirit and principles in the present invention, equivalent replacement and improvement etc., all should be included within protection scope of the present invention.

Claims (4)

1. a collocation method for General Purpose Interface, is characterized in that, comprising:
Carry out initialization to the tab of the needs display in interface, described tab comprises conditions pages, item page, ranking pages, filtering page and the senior page, and described interface is general polling filtering interface, and described interface queries filters multiple business;
Filtercondition in described tab is set;
The described content needing the tab of display is obtained according to described filtercondition;
Wherein, the described tab to the needs display in interface carries out initialization, specifically comprises:
Judge need the tab of display and obtain XML configuration file according to the parameter imported into;
The tab shown is needed according to described XML configuration file initialization;
The described filtercondition arranged in described tab, specifically comprises:
The data field selecting querying condition and will represent in Query Result in described tab;
In the page of described tab, the data field carrying out sorting is selected according to described querying condition;
The described content obtaining the tab of described needs display according to described filtercondition, specifically comprises:
According to the function statement in the project of described querying condition, selection and the sort field constructs database of selection;
Using the key assignments of described function statement as report form type;
The described key assignments as report form type is assembled into query sentence of database;
According to described query statement, inquiry is carried out to described database and obtain described Query Result, and load on shown interface and show described Query Result.
2. method as claimed in claim 1, it is characterized in that, described querying condition is the querying condition selected in condition, filtration and senior tab.
3. method as claimed in claim 1, is characterized in that, also comprise:
When increasing new business, the individualized content of business new described in described Interface Construction and the configuration file of correspondence.
4. an inking device for General Purpose Interface, is characterized in that, comprising:
Initialization unit, for carrying out initialization to the tab of the needs display in interface, described tab comprises conditions pages, item page, ranking pages, filtering page and the senior page, and described interface is general polling filtering interface, and described interface queries filters multiple business;
Condition setting unit, for arranging the filtercondition in described tab;
Contents acquiring unit, for obtaining the described content needing the tab of display according to described filtercondition;
Wherein, described initialization unit, comprising:
Judgment sub-unit, needs the tab of display for judging according to the parameter imported into and obtains XML configuration file;
Page initialization subelement, for needing the tab shown according to described XML configuration file initialization;
Described condition setting unit, comprising:
Querying condition chooser unit, for the data field selecting querying condition He will represent in Query Result in described tab;
Data field chooser unit, for selecting the data field carrying out sorting in the page of described tab according to described querying condition;
Described contents acquiring unit, comprising:
Constructor unit, for according to the function statement in the project of described querying condition, selection and the sort field constructs database of selection;
Key assignments arranges subelement, for using the key assignments of described function statement as report form type;
Assembling subelement, for being assembled into query sentence of database using the described key assignments as report form type;
Result presentation subelement, obtains described Query Result for carrying out inquiry according to described query statement to described database, and loads on shown interface and show described Query Result.
CN201010578764.0A 2010-12-08 2010-12-08 The collocation method of General Purpose Interface and computing machine Active CN102567032B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201010578764.0A CN102567032B (en) 2010-12-08 2010-12-08 The collocation method of General Purpose Interface and computing machine

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201010578764.0A CN102567032B (en) 2010-12-08 2010-12-08 The collocation method of General Purpose Interface and computing machine

Publications (2)

Publication Number Publication Date
CN102567032A CN102567032A (en) 2012-07-11
CN102567032B true CN102567032B (en) 2016-01-20

Family

ID=46412542

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201010578764.0A Active CN102567032B (en) 2010-12-08 2010-12-08 The collocation method of General Purpose Interface and computing machine

Country Status (1)

Country Link
CN (1) CN102567032B (en)

Families Citing this family (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103150391A (en) * 2013-03-21 2013-06-12 河海大学 General database table webpage displaying method based on configuration files
CN104750045B (en) * 2013-12-30 2017-09-01 北京北方微电子基地设备工艺研究中心有限责任公司 Semiconductor process formula loading method and system
CN105471931B (en) * 2014-08-06 2020-06-26 腾讯科技(北京)有限公司 Method, device and system for inquiring service data
CN105468352A (en) * 2014-09-12 2016-04-06 中兴通讯股份有限公司 Query interface generation method and apparatus
CN104331295B (en) * 2014-11-05 2018-06-26 北京中科辅龙信息技术有限公司 Page generation method and system
CN105812430B (en) * 2014-12-31 2019-12-13 金蝶软件(中国)有限公司 Intelligent query method for mobile terminal, mobile terminal and server
CN105550327A (en) * 2015-12-18 2016-05-04 金蝶软件(中国)有限公司 Filter condition processing method and system for WEB webpage data query
CN107315808A (en) * 2017-06-27 2017-11-03 石化盈科信息技术有限责任公司 A kind of Web query framework
CN108804629A (en) * 2018-05-31 2018-11-13 北京五八信息技术有限公司 A kind of processing method, device, storage medium and the equipment of screening item
CN116821164B (en) * 2023-08-31 2023-11-21 成都智慧锦城大数据有限公司 Searching method for realizing visual flexible combination dynamic configuration

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101645062A (en) * 2009-08-21 2010-02-10 金蝶软件(中国)有限公司 Report form generation method, system and information management equipment
CN101706818A (en) * 2009-12-04 2010-05-12 金蝶软件(中国)有限公司 Report dynamic filtering method and device
CN101727436A (en) * 2008-10-29 2010-06-09 华为技术有限公司 Method for processing report data, reporting system and related device thereof
CN101739453A (en) * 2009-12-17 2010-06-16 中国电力科学研究院 Method and device for carrying out condition query on database table
CN101788994A (en) * 2009-08-14 2010-07-28 成都迪捷信息技术有限公司 Method for constructing data display model and method and device for displaying data

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101727436A (en) * 2008-10-29 2010-06-09 华为技术有限公司 Method for processing report data, reporting system and related device thereof
CN101788994A (en) * 2009-08-14 2010-07-28 成都迪捷信息技术有限公司 Method for constructing data display model and method and device for displaying data
CN101645062A (en) * 2009-08-21 2010-02-10 金蝶软件(中国)有限公司 Report form generation method, system and information management equipment
CN101706818A (en) * 2009-12-04 2010-05-12 金蝶软件(中国)有限公司 Report dynamic filtering method and device
CN101739453A (en) * 2009-12-17 2010-06-16 中国电力科学研究院 Method and device for carrying out condition query on database table

Also Published As

Publication number Publication date
CN102567032A (en) 2012-07-11

Similar Documents

Publication Publication Date Title
CN102567032B (en) The collocation method of General Purpose Interface and computing machine
CN100580662C (en) Heterogeneous report form integration and centralized management device and system
US7668860B2 (en) Apparatus and method for constructing and using a semantic abstraction for querying hierarchical data
CN103020158A (en) Report form creation method, device and system
CN100587693C (en) Method and system for obtaining data from a plurality of data pool
CA2518902C (en) System and method for query planning and execution
CN107679071B (en) Relational database-oriented general data service customized packaging method
US10120886B2 (en) Database integration of originally decoupled components
CN101667034A (en) Scalable monitoring system supporting hybrid clusters
WO2008045634A1 (en) Integration of database reporting with erp systems
CN103064933A (en) Data query method and system
CN102541529A (en) Query page generating device and method
CN103019728A (en) Effective complex report parsing engine and parsing method thereof
CN102193798B (en) Method for automatically acquiring Open application programming interface (API) based on Internet
CN102521296A (en) Method for screening data items in separated pages of web page
CN109241384A (en) A kind of method for visualizing and device of scientific research information
CN104615602A (en) Automatic generation device and method thereof for query interface
CN102456004B (en) Query control method and system of page data
CN102821133A (en) Method and server for data analysis of extensible business reporting language (XBRL)
CN104317936A (en) ROLAP (relational on-line analysis processing) analysis engine design method and device on basis of star models
CN102918531A (en) Systems and methods for providing multilingual support for data used with a business intelligence server
CN103917970A (en) Customer focused keyword search in an enterprise
CN101334727A (en) Service based synergic engine system
CN104731804B (en) A kind of method and device for establishing general polling frame
López et al. A component-based approach for engineering enterprise mashups

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