CN101414256B - Construction method of general-purpose data filtering component - Google Patents

Abstract

The invention provides a general-purpose data filtration component, the dynamic screening of data can be realized by the component, the component is automatically associated with a screened component by the association registration form, the data filtration linkage is realized by the operation of an operator, the data needs to be loaded completely before the filtration, the presentation forms of a main interface of the component comprise: a tree-shaped filtration component with the setting of multiple choices or single choice, a list filtration component with the setting of single choice or multiple choices, a drop-down list filtration component with the form of single choice and a data line filtration component with any input form, and the corresponding components have the same association component registration method and the linked processing effect. The general-purpose data filtration component mainly provides the data filtration component which is convenient and easy to use for ERP software developers, and the intuitive filtration of the data in the ERP can be realized by utilizing the component.

Description

A kind of general data filtering component construction method

Technical field

The present invention relates to a kind of Computer Applied Technology, use, can in software, realize a kind of general data filtering component construction method of dynamic data filter effect by this technology towards the professional and technical personnel.

Background technology

Development along with infotech, formed all kinds of data messages in the enterprise, corresponding data information is processed processing, represents intuitively and found out the indispensable function that information that the enterprise operator is concerned about has become ERP software by data analysis, general data filtering component is exactly to realize in this situation, is used to satisfy the needs of business data intuitive analysis.

Summary of the invention

The objective of the invention is data are filtered dynamically, comprise tree filter controls, list filtering control, combobox filter controls, input frame filter controls, and pass through the data analysis mode of What You See Is What You Get, filtered data is effectively showed.

The objective of the invention is to realize in the following manner:

1 sets up general assembly basis ancestors.

Realize the standard of module information interface by ancestors;

Store basic environmental information, control title, related control, start-up parameter, filter method, message passback incident;

2. set up tree-like filter assemblies based on ancestors' assembly.

A) by receiving affiliated partner, form tree control internal data parameter automatically;

B) by the data rows of every grade of correspondence of tree, form the tree directory data automatically, adopt uniqueization of data method to extract uniqueization data at different levels in the forming process; Automatically form top full choosing sign simultaneously.

C) singly select the multiselect state by what Dan Xuan, the multiselect sign that receives was provided with tree directory automatically.

D) form filter method by the data assembling that will select, and filter method be applied to related control, the filtration of finishing data with present.

3. set up the list filtering assembly based on ancestors' assembly.

A) by receiving affiliated partner, form list control internal data parameter automatically;

B) by the data rows of every grade of correspondence of tree, form table data automatically, adopt uniqueization of data method to extract data in the forming process; Automatically form full choosing sign simultaneously.

C) singly select the multiselect state by what Dan Xuan, the multiselect sign that receives was provided with list control automatically.

D) form filter method by the data assembling that will select, and filter method be applied to related control, the filtration of finishing data with present.

4. set up the combobox filter assemblies based on ancestors' assembly.

A) by receiving affiliated partner, form drop down list control internal data parameter automatically;

B) by the data rows of every grade of correspondence of tree, form the drop-down list data automatically, adopt uniqueization of data method to extract data in the forming process; Automatically form full choosing sign simultaneously.

C) form filter method by the data assembling that will select, and filter method be applied to related control, the filtration of finishing data with present.

Of the present invention have function and a beneficial effect

1. provide convenience easy-to-use data filtering component towards the ERP software developer, can utilize assembly to realize the filtration directly perceived of data among the ERP.

Embodiment

1. the developer realizes function corresponding by invocation component when software is realized.

2. call method is as follows:

// different assembly adopts different titles.Tree is TREE, and tabulating is LB, and drop-down list is DDLB

ls_object_name＝’uo_wd_report_control_’+ls_type

// in corresponding window, create corresponding assembly

iw_container.openuserobject(u，ls_object_name，ll_x，ll_y)

The title of // assignment component is used for the index location

u.control_name＝ls_name

The width that // setting shows

u.width＝ll_w

The height that // setting shows

u.height＝ll_h

Affiliated partner is transmitted in the initialization of // invocation component simultaneously

u.event?z_initial(iw_container，’z_report_filter_act’，idw_main_report)

// transmission parameter and further initialization

u.event?z_refresh(ls_t)

// display module

u.post?show()

The main program assembly:

1, assembly ancestors object: uo_wd_report_control

Instance variable:

constant?STRING?ALL_ITEM＝’ALL_ITEM_FIRST_TWO’

// be used to indicate the name of control

STRING?CONTROL_NAME

// be used to register parent object, to trigger the corresponding filter event of parent object.

powerobject?ipo_parent

string is_parent_event

The filtercondition of // current control

string is_filter

The initial opening parameter of // current control

string?is_parm

Communication method using common

public?function?integer?of_set_parent(powerobject?apo，string?as_event)

public?function?string?of_get_filter()

protected?function?long?of_get_distinct_data(string?as_col，ref?string?as_ret[])

Public incident

event?z_size?pbm_size

event?z_generate_filter()

event?z_filter_action()

event?type?integer?z_initial(powerobject?apo，string?as_event，datawindow?adw)

event?type?integer?z_refresh(string?as_arg)

event?z_resize_post()

event?type?integer?z_reset_data(string?as_fi?lter)

2, tree filter assemblies: uo_wd_report_control_tree

Instance variable:

// be used to write down the row name and the corresponding condition string of each row

string?is_col[]，is_formular[]，is_coltype[]，is_sort

// whether be used to indicate increase subitem, in ITEMPOPULATE, call,

boolean?ib_adding＝false

// whether be used to indicate multiselect, use PICTUREINDEX and SELECTEDINDEXT=1 to represent not select ,=2 represent to have selected to judge.

boolean?ib_multi＝false”

Communication method using common:

public?function?integer?of_set_picture_all_child(long?al_handle，integerai_i?ndex)

public?function?integer?of_set_picture_all_parent(long?al_handle，integerai_i?ndex)

public?function?integer?of_readme()

public?function?string?of_get_single_filter()

public?function?string?of_get_multi_filter()

public?function?string?of_get_single_filter_pub(long?al_handle)

3, list filtering assembly: uo_wd_report_control_lb

4, drop-down list filter assemblies: uo_wd_report_control_ddlb

The present invention effectively raises the ability that software filters data analysis, can promote the final user more effectively to utilize data to see question essence clearly, flexible easy-to-use operator scheme has more effectively promoted the use of user to software, has a good application prospect.

Embodiment:

Method of the present invention has successfully been tried out the comprehensive management platform system in tide ERP, manages windows system, the PS product line, and in force, this component call is succinct, and has brought into play good effect in actual applications.

Claims (1)

1. general data filtering component construction method, it is characterized in that the batch processing assembly, realize the dynamic screening of data by this assembly, this assembly is by the form of related registration, automatically with screened component liaison, operation by the operator realizes the data filter interlock, before filtration, data need complete loading, the main interface form of expression of assembly comprises: have the tree-like filter assemblies that multiselect or single choosing are provided with, have the list filtering assembly that single choosing or multiselect are provided with, the drop-down table filter assemblies that has single form slection formula, the data rows filter assemblies that has any input form, corresponding assembly all has identical above-mentioned associated component logon mode and interlock treatment effect, and the step that makes up data filtering component is as follows:

1) sets up general assembly basis ancestors;

Realize the standard of module information interface by ancestors;

Store basic environmental information, control title, related control, start-up parameter, filter method, message passback incident;

2) set up tree-like filter assemblies based on ancestors' assembly;

A) by receiving affiliated partner, form tree control internal data parameter automatically;

B) by the data rows of every grade of correspondence of tree, form the tree directory data automatically, adopt uniqueization of data method to extract uniqueization data at different levels in the forming process; Automatically form top full choosing sign simultaneously;

C) singly select the multiselect state by what Dan Xuan, the multiselect sign that receives was provided with tree directory automatically;

D) form filter method by the data assembling that will select, and filter method be applied to related control, the filtration of finishing data with present;

3) set up the list filtering assembly based on ancestors' assembly;

A) by receiving affiliated partner, form list control internal data parameter automatically;

B) by the data rows of every grade of correspondence of tree, form table data automatically, adopt uniqueization of data method to extract data in the forming process; Automatically form full choosing sign simultaneously;

C) singly select the multiselect state by what Dan Xuan, the multiselect sign that receives was provided with list control automatically;

D) form filter method by the data assembling that will select, and filter method be applied to related control, the filtration of finishing data with present;

4) set up the combobox filter assemblies based on ancestors' assembly;

A) by receiving affiliated partner, form drop down list control internal data parameter automatically;

B) by the data rows of every grade of correspondence of tree, form the drop-down list data automatically, adopt uniqueization of data method to extract data in the forming process; Automatically form full choosing sign simultaneously;

C) form filter method by the data assembling that will select, and filter method be applied to related control, the filtration of finishing data with present.