CN101187864A - Method for exhibiting abstraction and integration for interface - Google Patents

Method for exhibiting abstraction and integration for interface Download PDF

Info

Publication number
CN101187864A
CN101187864A CNA2007101144630A CN200710114463A CN101187864A CN 101187864 A CN101187864 A CN 101187864A CN A2007101144630 A CNA2007101144630 A CN A2007101144630A CN 200710114463 A CN200710114463 A CN 200710114463A CN 101187864 A CN101187864 A CN 101187864A
Authority
CN
China
Prior art keywords
string
row
interface
control
data
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
Application number
CNA2007101144630A
Other languages
Chinese (zh)
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.)
Inspur Group Shandong General Software Co Ltd
Original Assignee
Inspur Group Shandong General Software 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 Inspur Group Shandong General Software Co Ltd filed Critical Inspur Group Shandong General Software Co Ltd
Priority to CNA2007101144630A priority Critical patent/CN101187864A/en
Publication of CN101187864A publication Critical patent/CN101187864A/en
Pending legal-status Critical Current

Links

Abstract

The invention provides an abstract and integrated method which is used for displaying an interface, which solves the problems in the prior art. Software programming is not needed during the employing process of the invention, and ordinary technique staffs can define flexibly through the label in an interface, and content which is needed by operators can be organically integrated in a working interface, and the invention can satisfy regulating requirements of various software-employed staffs during the employing process. The change process style in the invention can take numbers of forms for reporting statistics, column names in forms for reporting statistics, and parameter names as changes and process, simultaneously, all the changes in interfaces of forms for reporting statistics can be separately stored in a database, and the change process style which is matched with the directional style of separate record in page steering can realize abstraction development of displayed interfaces of forms for reporting statistics. The invention can solve the problems that the interface in the current popular BI tool is not easily abstracted, and saves a large amount of time for investors, and can provide a unified display interface, which is convenient for studying and operating of users, thereby saving investing amount for investors and providing an integrated operation interface which is unified and is easily studied by users.

Description

A kind of abstract and integrated method of showing interface that is used for
Technical field
The present invention relates to a kind of Computer Applied Technology, use towards amateur or professional and technical personnel, the technology at integration exhibition interface that can efficiently develop software rapidly, and can support form to show the abstract exploitation at interface.
Background technology
In the management software exploitation at present, integrated and the modification at interface need realize by programming, carrying out needing the interface is better operated in the operation of self convenience integrated more user of service, the adjustment that all need to carry out software code this moment can be accomplished.In the enforcement of management software, corporate client all can require a large amount of form of customization, to satisfy the needs of data analysis according to the management characteristic of self, in traditional form exploitation, report interface all needs to make separately, or makes by software programming, needs a large amount of developments this moment, and it is in the majority to repeat work, the redjustment and modification workload is big, and style is not easy to unifiedly, causes too much trouble to the user.
Summary of the invention
The objective of the invention is to overcome the deficiencies in the prior art, a kind of abstract and integrated method of showing interface that is used for is provided.
The objective of the invention is to realize in the following manner, utilize the data hold function to realize the difference configuration of variable and the turn function of label, realize the integrated and abstract of interface, concrete markup language is as follows:
<CX〉CXBH:SJLM1=COL1:SJLM2=COL2....</CX〉be used in reference to a form, the parameter of opening of form is enabled current row;
<CCX〉CXBH:SJLM1=COL1:SJLM2=COL2....</CCX〉be used for opening a form in current interface, the parameter of opening of form is enabled current row, and prerequisite is that body do not shown in this record;
<CCXEVENT〉event name</CCXEVENT〉if in current interface, opened form, call accordingly and can trigger the relevant incident of form, as printing page configuration, pattern exhibiting;
<ARGCX〉CXBH</ARGCX〉be used in reference to a form, if form has parameter, can require the typing parameter;
<WD〉COLUMN:WDBH:TYPE</WD〉be used in reference to a record relevant, the row name in this interface of COLUMN=, type=0/1 flowing water numbering/record number with this interface;
<WDWH〉WDBH</WDWH〉be used to increase some records;
<WDSP〉WDBH</WDSP〉be used to examine some records;
<WDCX〉WDBH</WDCX〉be used to inquire about some records;
<WDTJ〉WDBH</WDTJ〉be used to add up some records;
<WDGOTO〉WDBH:ID:TYPE</WDGOTO〉be used to turn to a fixing record;
<RUN〉appname</RUN〉be used in reference to the corresponding module in myGS pSeries;
<EXCEL_PRINT〉if the annex of corresponding record is the EXCEL pattern, just the annex template that can obtain to write down by this mode so, and finish variable and replace, can play the purpose of using EXCEL to print;
<CRUN〉appname</CRUN〉be used in reference to routine call arbitrarily, the corresponding program in can calling system can use corresponding program running parameter to call in calling;
<HELP_BUTTON〉COLUMN</HELP_BUTTON〉be used in reference to the right button of a certain row and help to access, the row of COLUMN for pointing to can be seen concrete row name in INTERFACE DESIGN;
<PUBFUN_BUTTON〉FUNCTION</PUBFUN_BUTTON〉be used to call an overall situation function, the content of secondary development and the interface environments of system can be combined by this;
<CONTROL〉TYPE:NAME:CONT</CONTROL〉be used for the control of definition interfaces, can in the interface, set corresponding control and be tree, be tabulation; See report interface control defined declaration for details;
<CLOSE_WINDOW 〉; Be used to close current window;
<APPLICATION_STOP〉be used to withdraw from whole application program;
<CONTROL〉TYPE:NAME:CONT</CONTROL〉be used for creating corresponding control at the interface, have in relevant:
TYPE: can be TREE, LB, DDLB, DW, REPORT, SP, concrete implication is:
TREE navigation tree control: be used for the data of main form are filtered;
LB list control: be used for the data of main form are filtered;
DDLB drop-down list box control: be used for the data of main form are filtered;
The DW datawindow control.Be used to check the managing detailed catalogue situation of main form current line;
REPORT report controls: the managing detailed catalogue situation that is used to inquire about main form current line;
SP divider control: the position that is used for when form moves, adjusting form;
NAME: compose the name of giving corresponding control, when divider is quoted, just need to use this name to quote, note when the input name, should not duplicating title;
CONT: be used for configuration to each control effect.Specifically different collocation methods is arranged according to different controls;
The configuration format of TREE control: multiselect sign (M/S): row 1: row 2: ... ..
Multiselect sign M=allows the data item multiselect, and S=only allows data item is carried out Dan Xuan;
Row note in the back of row a comma being arranged corresponding to the concrete row of main form;
The configuration format of LB control: multiselect sign (M/S): row: data source form: data source expression formula;
Multiselect sign: M=allows the data item multiselect, and S=only allows data item is carried out Dan Xuan;
Row:, note a comma being arranged in the back of row corresponding to the concrete row of main form;
Data source form and data source expression formula: how the data that are used for indicating respective list form, and following several mode is arranged;
LIST: tabulation, this moment, the data source expression formula was a string that comma separates, as: 01,02,03,04
AREA: the interval, this moment, the data source expression formula was an initial value: end value: show length; As can be written as in month: 01:12:2;
DW: indicate the row that corresponding tabulation comes from the front appointment;
DB: indicate corresponding tabulation and come from database.Be shown as department table: SELECT KCBMZD_BMMC FROM KCBMZDWHERE KCBMZD_MX=1;
MONTH: referred to for 12 month, 01 ~ 12;
The configuration format of DDLB control: row: condition: data source form: data source expression formula;
Row: it is relevant with which row to indicate this control;
Condition: indicate sign of operation=<=<=<LIKE, LIKE_LEFT, LIKE_RIGHT can directly write the condition of a complexity in addition, notes using ﹠amp; ﹠amp; Symbol is represented currency, and will note the processing of quotation marks, because do not handle quotation marks in the system automatically;
Data source form and data source expression formula: how the data that are used for indicating respective list form, and following several mode is arranged;
LIST: tabulation, this moment, the data source expression formula was a string that comma separates, as: 01,02,03,04
AREA: the interval, this moment, the data source expression formula was an initial value: end value: show length, as being written as in month: 01:12:2;
DW: indicate the row that corresponding tabulation comes from the front appointment.
DB: indicate corresponding tabulation and come from database.Can be expressed as department: SELECT KCBMZD_BMMC FROM KCBMZDWHERE KCBMZD_MX=1;
MONTH: referred to for 12 month, 01 ~ 12;
The configuration format of DW control: dwo_name:arg_col 1:arg_col 2:arg_col....;
Dwo_name: the title of the data window object of quoting, use the PB exploitation, then by data window import feature import system;
Arg ...: the source of the parameter of corresponding data window, the name of row are necessary in the main form and are listed as accordingly; When form moved, system at first obtained the current line of main form, obtained the value on this row respective column then successively;
The configuration format of REPORT control: CXBH:SJLM1=COL1:SJLM2=COL2....
CXBH: report number;
SJLM: the parameter name of associated form;
COL: the title of the row of primary buffer;
The configuration format of SP control: H/V:OBJ1, OBJ2 ..:OBJ21, OBJ22...;
H is expressed as horizontal subdivision, and V is expressed as longitudinal subdivision;
OBJ1, OBJ2 ... it is first group, as for H is illustrated in the left side, as being illustrated in the top for V;
OBJ21, OBJ22 are second group, and H is illustrated in the right in this way, as being illustrated in bottom for V.
Function that method of the present invention has and beneficial effect
1. can develop the main interface of login, business operation interface, data analysis interface fast towards concrete user of service.
2. model customization is carried out at the interface of similar form, can carry out integration exhibition with operation interface then, obtains development efficiency and unified software style fast.
3. can add each class method control of system at report interface, can make the assay surface that both pictures and texts are excellent.
Figure S2007101144630D00031
The data navigation tree is supported single final election function, can link with the data in real time in the form.
Figure S2007101144630D00032
Tabulation is selected, and supports single final election function, can link with the data in real time in the form.
Figure S2007101144630D00033
The class control is filtered in combobox selection, date selection, data item selection etc., all can link in real time with report data.
Figure S2007101144630D00041
The subreport control can link in real time according to main form content, and data exhibiting is meticulousr.
Figure S2007101144630D00042
The spirte control can be showed according to main form content real-time graph, can carry out data exhibiting by various dimensions and graphics mode.
4. can set printing, redirect, hyperlink, pattern exhibiting in the interface, quit a program, action button such as EXCEL conversion.Hop button can be supported the increasing newly of data, inquires about, examines, adds up, concrete data recording etc., thereby organically all kinds of software operation elements is integrated.
5. can set attributes such as background picture, button image, font, frame, can produce and enrich lively interface.
6. simple request for utilization can make more personnel participate in exploitation, saves great amount of cost to IT application in enterprise.
Embodiment
The main program assembly:
1, INTERFACE DESIGN assembly: uo_dw_adjust
Figure S2007101144630D00043
Instance variable:
String is_dwname//interface to be adjusted title
System's numbering at string is_system//place
String is_function//function corresponding numbering is used to identify content to be adjusted
Data window title=is_dwname+is_system+is_function during string is_name//storage
String is_detail_name=' st_dw_detail ' // be used to the identify position of dw_detail
String is_end_col=" // be used to identify the position of last editor's row
String is_right_col=", is_down_col=" // right button is listed as, presses following
String is_current_col=", is_current_old_back=' 0 ', is_current_old_backmode=' 0 ' // prostatitis worked as, background, background transparent degree
String is_current_old_border=' 0 ' // former frame
Long il_max_width//breadth extreme
Long il_max_height//maximum height
String is_col[], is_text[] // the row name of row must be arranged, and text
Datastore ids_objects//object storage buffer zone
N_cst_dw_adjust inv_fun//function library
M_jxc_face_popup im_rbutton//right-click menu
String is_rbutton_object//by the object in the right button point
String is_units//long measure 0 pbu, 1 ix, 2,3
String is_dw_type//look ﹠ feel 1 grid
Boolean ib_wdmaster=false//indicate whether be the gauge outfit of integrated management
The numbering of String is_doctype//record
Datawindow idCur//child control
Figure S2007101144630D00044
Communication method using common:
Of_refresh (string as_dwname, string as_system, string as_function) // be used to finish the initialization of instance variable, and initially good corresponding state
Of_save () // preservation designs accordingly
Of_recover () // cancel new design content reduces original design
The corresponding interface of of_read () // read
Figure S2007101144630D00051
Corresponding tables of data
/ * interface adjustment registration table */
CREATE?TABLE?LSJXCFACEDW
(
F_SYS CHAR (2) NOT NULL, the numbering * of/* system/
F_FUN VARCHAR (30) NOT NULL ,/* function numbering */
F_DW VARCHAR (60) NOT NULL ,/* data window */
F_NOTE VARCHAR (60) NOT NULL ,/* explanation */
F_MAXW u001 default 0 Not null ,/* breadth extreme */
F_MAXH u001 default 0 Not null ,/* maximum height */
Whether F_HEAD CHAR (1) default ' 1 ' Not null ,/* gauge outfit, only handle at present gauge outfit content */
F_STATE CHAR (1) DEFAULT ' 0 ' Not NULL ,/* whether have corresponding state */
F_DETAIL VARCHAR (60) null ,/* is used for the object oriented of sign table body, when adjusting the interface, directly adjust to corresponding position carry out lid get final product */
F_MODE image null /**/
)
go
create?unique?index?LSJXCFACEDW?on?LSJXCFACEDW(F_SYS,F_FUN,F_DW)
go
/ * interface adjust corresponding must have row */
CREATE?TABLE?LSJXCFACECOL
(
F_SYS CHAR (2) NOT NULL, the numbering * of/* system/
F_FUN VARCHAR (30) NOT NULL ,/* function numbering */
F_DW VARCHAR (60) NOT NULL ,/* data window */
F_COL VARCHAR (60) Not null ,/* breadth extreme */
F_TEXT VARCHAR (60) null ,/* maximum height */
Whether F_NOTE VARCHAR (100) null/* gauge outfit, only handle at present gauge outfit content */
)
go
create?unique?index?LSJXCFACECOL?on?LSJXCFACECOL(F_SYS,F_FUN,F_DW,F_COL)
go
2, interface resolution component: w_wd_record
Instance variable:
Boolean ib_new=false//whether increase data newly is changed to true when newly-increased, be changed to false. when refreshing
Boolean Ib_protect//whether be to revise state
Whether comprise the table body in the formula of Boolean ib_include_detail=false//gauge outfit
String Is_doctype//record type
String Is_modetype//template type
String Is_wintype//window type CX=inquiry, WH=safeguards that SP=examines
String Is_lsbh, Is_sjdh//flowing water numbering is referenced the document numbering
The original sql of String Is_sql//data window obtains by get_sqlselect
String Is_lsbhcol, is_table//flowing water number column name=' WD '+IS_DOCTYPE+ ' _ LSBH '
The condition of String Is_where//window (comprising authority, the condition of examining) is used for page turning up and down.
The sql of String Is_sql_select//be used to search
String Is_text_select//corresponding videotex when being used to search
String Is_doctype_name//record class
N_cst_approve iuo_sp//examine common package
String Is_spdx//examine object
N_cst_wd_operation iuo_operation//document function
N_cst_wd_pub iuo_wdpub//communication method using common
N_cst_wd_menu iuo_wdmenu // public menu
N_cst_wd_grant iuo_grant//public authority
N_cst_dw_inputdata inv_data//historical data helps object
On // date of beginning to inquire about, be used in the scope of searching cancellation.
string?is_begin_cx
string?is_begin_back?width
Whether boolean ib_begin=false//being used for control carries out formula operation, assignment in RETRIEVEEND.The value of separating in ITEMCHNAGED and UE_ADD
Boolean ib_auto_generate=false//whether be automatically generated data
The template of coming in is transmitted in blob ib_message_model//outside
Datastore ids_formular//preservation formula object.
String is_sfmx//whether have table body 0 not have, 1, have
String is_detail_sql_select//initial the grammer of detailed data window
N_cst_dwsrv_face inv_dw_face//be used to adjusts the object that data window shows
String?is_unique_col[],is_unique_col_master[],
Is_unique_sql_master, is_unique_sql_msg//be used to the identify row string of unique index
After the corresponding Data Update of long il_mod_count_master=0//be used to identify whether by calculating.=0 expression had been calculated, and only handled gauge outfit.
String is_copy_col=" // be used to identify the row name that is copied.In window is initial, carry out initialization
M_record_popmenu im_popmenu//be used for pop-up menu-replacement template
String is_last_move_obj=" // be used to indicate that the last time is modified the object of font WEIGHT
Boolean ib_show_toolbar=true//be used to indicate TOOLBAR whether show
Boolean ib_approve_modify=false//be used to preserves the row name of the row that the active user can revise when examining
String is_approve_columns=" // row that allow to revise in the audit
W_jxc_pub_cx_child iw_report//be used for directly opens the subwindow of form in current interface
Boolean ib_is_report=false//be used to indicate current interface is a form.When withdrawing from, the not inspection of whether preserving.
N_wd_report_control inv_report_control//be used to handles form and filters object with correlativity
Boolean ib_report_first_open=true//be used to indicate and whether opened form is if opened, just do not need so to go in RETRIEVEEND to open again again
Boolean ib_save_succ=false//be used to indicate whether preserve success
Stru_wd_same_object istru_obj[] // list object of identical connection on the interface deposited
datastore?ids_objects
The object that slips at last on stru_wd_same_object istru_last_obj//interface
String is_sctype//whether be normally to generate 1---with reference to generation with reference to the document 0--that generates
//------------------------------
// be used to represent the calculating in DETAIL district
//
// be used to write down the formula information in detailed district, to accelerate computing velocity.
// obtain to carry out among the wf_set_detail_col_formular_info () initial at letter
// in function wf_set_by_formular_detail (), quote.
// only there are the row of formula to be recorded.
String is_detail_f_col[] // each row.
String is_detail_f_type[] // row type, preceding four capitalization
The quantity of long il_detail_f_count//have formula row and
Boolean ib_detail_f_contain_m2fun2_var=false//whether in the detail district, the quoted data of gauge outfit or statistics.If do not quote,, can accelerate arithmetic speed greatly just need when each reckoner body, not rerun so.
String is_detail_f_uncal=" // the entry numbering string that do not calculate.Being provided with in DETAIL.itemchanged, removing at wf_set_formular_detail, is a string.flnm,flnm,
//----------------------------------------
// be used to identify the row of needs copy lastrow data.
// at the mid-initial value of function wf_set_item_default_value,
Call among the //ue_add_detail
string?is_detail_copy_uprow_cols[]
string?is_detail_copy_uprow_types[]//STRING,NUMBER,DATE
// be used to identify first row that detailed district can edit.min(tabsequence>0)
string?is_detail_first_editable_column=”
string?is_master_first_editable_column=”
// whether when opening window.
// read and design only in wf_set_detail_hscroll_position () function, to adjust and use
boolean?ib_opening=true
Figure S2007101144630D00081
Function description:
1. finishing the interface resolves;
2. finish data increase, deletion, revise, examine, printing, EXCEL produce;
3, public method storehouse: n_cst_wd_pub.
Figure S2007101144630D00082
Method base:
public?function?integer?of_create_head(ref?datawindow?adw,string?as_head)
public?function?integer?of_gen_select_dw(string?as_sql,string?as_text,datawindow?adw)
public?function?integer?of_filter(ref?datawindow?adw)
public?function?string?of_get_code(datawindow?adw,string?as_col)
public?function?string?of_create_find(datawindow?adw,string?as_item)
public?subroutine?of_filter_column(datawindow?adw,string?as_col)
public?function?string?of_get_select_id(string?as_sql,string?as_text)
public?function?integer?of_show(string?as_string,string?as_id)
public?function?integer?of_check_save(string?as_doctype,datawindow?adw)
private?function?integer?of_create_compute(datawindow?adw,string?as_table)
public?function?integer?of_generate_datawindow(string?as_dwname,string?as_sql,string?as_text,string?as_protectcol,string?as_head,string?as_table,datawindow?adw,string?as_key,string?as_show)
public?function?integer?of_set_shbz_code(datawindow?adw,string?as_col)
public?function?integer?of_set_code(datawindow?adw,string?as_col,stringas_code)
public?function?integer?of_replace(datawindow?adw,ref?string?as_string)
public?function?integer?of_check_data(string?as_doctype,string?as_col,stringas_data,datawindow?adw)
public?function?long?of_get_replace(datawindow?adw,ref?string?as_col[],refstring?as_data[],ref?string?as_text[])
public?subroutine?of_set_mb_help(string?as_doctype,string?as_col,datawindow?pdw,wstruself?pwstruself)
public?subroutine?of_goto(string?as_doctype,string?as_sjlm,string?as_data)private?function?integer?of_set_wd_not_null(datawindow?adw,string?as_col)
public?function?long?of_excel_replace(datawindow?adw)
public?function?integer?of_gen_select_dw_backup20030710(string?as_dwname,stringas_sql,string?as_text,string?as_protectcol,string?as_head,string?as_table,datawindow?adw,string?as_key,string?as_show)
public?function?integer?of_get_help_column(string?as_doctype,ref?string?as_col,ref?string?as_text,string?as_flag)
public?function?integer?of_generate_detail_dw(string?as_dwname,string?as_sql,string?as_text,string?as_protectcol,string?as_table,datawindow?adw,string?as_key,string?as_show)
public?function?string?of_gen_face_sql(string?ps_base_name,string?ps_djbh,string?ps_flag,ref?string?ps_text,ref?string?ps_cols,ref?string?ps_protectcol,refstring?ps_show)
public?function?string?of_get_id(string?as_type,string?as_where)
public?function?integer?of_get_help(datawindow?adw,datawindow?adw2,stringas_doctype,string?as_col)
public?function?string?of_get_id(string?as_type,string?as_where,booleanab_more)
public?function?string?of_get_select_id(string?as_sql,string?as_text,BOOLEANAb_more)
public?function?string?of_get_single_id(datawindow?adw,string?as_col)
public?function?string?of_get_code2(datawindow?adw,string?as_col,stringas_code_id)
public?function?string?of_get_code(datawindow?adw,string?as_col,ref?stringas_look_id)
public?function?string?of_gen_col_alias(string?as_old)
public?function?integer?of_gen_detail_position(ref?datawindow?adw)
public?function?integer?of_reset_mode(datawindow?pdw,string?ps_lxbh,stringps_lsbh)
public?function?long?of_excel_replace(datawindow?adw,datawindow?adw2,booleanab_havedetail)
public?function?integer?of_replace_nomsg(datawindow?adw,ref?string?as_string)
public?function?string?of_get_formular(string?as_doctype,string?as_col)
public?function?string?of_get_formular(string?as_doctype, string?as_col,datawindow?adw)
public?function?integer?of_set_query(datawindow?adw,datawindow?adw2,stringas_sql,string?as_text,string?as_title,string?as_id)
public?function?string?of_format_text_sign(string?as_old)
public?function?string?of_get_help_for_cx(string?as_cxbh,string?as_xmbh)
public?subroutine?of_goto(string?as_doctype,string?as_sjlm,string?as_data,datawindow?adw)
public?subroutine?of_goto(string?as_doctype,string?as_sjlm,string?as_data,datawindow?adw,datawindow?adw2)
public?subroutine?of_new(string?as_type,string?as_string,string?as_col,datawindow?adw1,datawindow?adw2)
public?subroutine?of_goto_cx(datawindow?adw,string?as_goto)
public?function?integer?of_set_dw_protect(datawindow?adw,string?as_col)
public?function?boolean?of_goto_cx_get_arg(datawindow?adw,string?as_goto,refstring?as_cxbh,ref?string?as_sjlm[],ref?string?as_value[])
public?function?long?of_count_distinct(datawindow?adw,string?as_col)
public?function?integer?of_play_sound(string?as_file)
public?function?boolean?of_check_cdkey(string?as_type,string?ab_pos)
public?function?string?of_trans_statistical_fun(datawindow?adw,stringas_formular)
public?function?integer?of_check_data(string?as_doctype,string?as_col,stringas_data,datawindow?adw,datawindow?adw2)
public?function?integer?of_check_save(string?as_doctype,datawindow?adw,datawindow?adw2)
public?function?string?of_get_mul_id(string?as_sql,string?as_title,stringas_where)
public?function?integer?of_goto_function(string?as_parm)
public?function?integer?of_generate_datawindow_1024(string?as_dwname,stringas_sql,string?as_text,string?as_protectcol,string?as_head,string?as_table,datawindow?adw,string?as_key,string?as_show)
public?function?integer?of_create_head_1024(ref?datawindow?adw,string?as_head)
public?function?integer?of_gen_detail_position_1024(ref?datawindow?adw)
public?function?string?of_get_wd_format(string?as_colname)
public?function?string?of_get_wd_editmask(string?as_colname)
private?function?integer?of_create_compute_1024(datawindow?adw,string?as_table)
public?function?string?of_get_wd_list(string?as_colname)
public?function?long?of_excel_replace_rows(datawindow?adw,string?as_area)
public?function?integer?of_excel_savetodatabase(string?as_filename)
public?function?string?of_get_frist_editable_column(datawindow?adw)
public?function?integer?of_set_current_edit_position(datawindow?adw)
public?function?string?of_get_where_other_sjqx(string?as_doctype)
Method of the present invention has solved problems of the prior art simultaneously, do not need software programming in the use, those skilled in the art define flexibly by the label in the interface, the content that the operator can be needed be carried out organically integrated in the operation interface, can satisfy all kinds of software users of service to the adjustment requirement in the software use.Variable processing mode in the present invention, can be with report number, row name in the form, parameter name is handled as variable, simultaneously all variablees in the report interface all can separate, stored in database, cooperate the page to turn to the sensing mode of middle separate records, can realize the abstract exploitation at form displaying interface, this measure can solve present popular B I instrument median surface and be difficult for abstract deficiency, for the developer saves a large amount of time, and can provide unified displaying interface, make things convenient for envoy's study and operation, thereby reduce the exploitation amount, and the integrated operation interface of easily learning for unification of user to the developer.

Claims (1)

1. one kind is used for the abstract and integrated method of showing interface, it is characterized in that adopting markup language to carry out INTERFACE DESIGN, utilize the data hold function to realize the difference configuration of variable and the turn function of label, realize the integrated and abstract of interface, concrete markup language is as follows:
<CX〉CXBH:SJLM1=COL1:SJLM2=COL2....</CX〉be used in reference to a form, the parameter of opening of form is enabled current row;
<CCX〉CXBH:SJLM1=COL1:SJLM2=COL2....</CCX〉be used for opening a form in current interface, the parameter of opening of form is enabled current row, and prerequisite is that body do not shown in this record;
<CCXEVENT〉event name</CCXEVENT〉if in current interface, opened form, call accordingly and can trigger the relevant incident of form, as printing page configuration, pattern exhibiting;
<ARGCX〉CXBH</ARGCX〉be used in reference to a form, if form has parameter, can require the typing parameter;
<WD〉COLUMN:WDBH:TYPE</WD〉be used in reference to a record relevant, the row name in this interface of COLUMN=, type=0/1 flowing water numbering/record number with this interface;
<WDWH〉WDBH</WDWH〉be used to increase some records;
<WDSP〉WDBH</WDSP〉be used to examine some records;
<WDCX〉WDBH</WDCX〉be used to inquire about some records;
<WDTJ〉WDBH</WDTJ〉be used to add up some records;
<WDGOTO〉WDBH:ID:TYPE</WDGOTO〉be used to turn to a fixing record;
<RUN〉appname</RUN〉be used in reference to the corresponding module in myGS pSeries;
<EXCEL_PRINT〉if the annex of corresponding record is the EXCEL pattern, just the annex template that can obtain to write down by this mode so, and finish variable and replace, can play the purpose of using EXCEL to print;
<CRUN〉appname</CRUN〉be used in reference to routine call arbitrarily, the corresponding program in can calling system can use corresponding program running parameter to call in calling;
<HELP_BUTTON〉COLUMN</HELP_BUTTON〉be used in reference to the right button of a certain row and help to access, the row of COLUMN for pointing to can be seen concrete row name in INTERFACE DESIGN;
<PUBFUN_BUTTON〉FUNCTION</PUBFUN_BUTTON〉be used to call an overall situation function, the content of secondary development and the interface environments of system can be combined by this;
<CONTROL〉TYPE:NAME:CONT</CONTROL〉be used for the control of definition interfaces, can in the interface, set corresponding control and be tree, be tabulation;
<CLOSE_WINDOW 〉; Be used to close current window;
<APPLICATION_STOP〉be used to withdraw from whole application program;
<CONTROL〉TYPE:NAME:CONT</CONTROL〉be used for creating corresponding control at the interface, have in relevant
TYPE: comprise TREE, LB, DDLB, DW, REPORT, SP, concrete implication is:
TREE navigation tree control: be used for the data of main form are filtered;
LB list control: be used for the data of main form are filtered;
DDLB drop-down list box control: be used for the data of main form are filtered;
The DW datawindow control.Be used to check the managing detailed catalogue situation of main form current line;
REPORT report controls: the managing detailed catalogue situation that is used to inquire about main form current line;
SP divider control: the position that is used for when form moves, adjusting form;
NAME: compose the name of giving corresponding control, when divider is quoted, just need to use this name to quote, note when the input name, should not duplicating title;
CONT: be used for configuration to each control effect.Specifically different collocation methods is arranged according to different controls;
The configuration format of TREE control: multiselect sign (M/S): row 1: row 2: ... ..
Multiselect sign M=allows the data item multiselect, and S=only allows data item is carried out Dan Xuan;
Row note in the back of row a comma being arranged corresponding to the concrete row of main form;
The configuration format of LB control: multiselect sign (M/S): row: data source form: data source expression formula;
Multiselect sign: M=allows the data item multiselect, and S=only allows data item is carried out Dan Xuan;
Row:, note a comma being arranged in the back of row corresponding to the concrete row of main form;
Data source form and data source expression formula: how the data that are used for indicating respective list form, and following several mode is arranged;
LIST: tabulation, this moment, the data source expression formula was a string that comma separates, as: 01,02,03,04
AREA: the interval, this moment, the data source expression formula was an initial value: end value: show length; As can be written as in month: 01: 12: 2;
DW: indicate the row that corresponding tabulation comes from the front appointment;
DB: indicate corresponding tabulation and come from database.Be shown as department table: SELECT KCBMZD_BMMC FROM KCBMZD WHEREKCBMZD_MX=1;
MONTH: referred to for 12 month, 01 ~ 12;
The configuration format of DDLB control: row: condition: data source form: data source expression formula;
Row: it is relevant with which row to indicate this control;
Condition: indicate sign of operation=<=<=<LIKE, LIKE_LEFT, LIKE_RIGHT can directly write the condition of a complexity in addition, notes using ﹠amp; ﹠amp; Symbol is represented currency, and will note the processing of quotation marks, because do not handle quotation marks in the system automatically;
Data source form and data source expression formula: how the data that are used for indicating respective list form, and following several mode is arranged;
LIST: tabulation, this moment, the data source expression formula was a string that comma separates, as: 01,02,03,04
AREA: the interval, this moment, the data source expression formula was an initial value: end value: show length, as being written as in month: 01:12:2;
DW: indicate the row that corresponding tabulation comes from the front appointment.
DB: indicate corresponding tabulation and come from database.Can be expressed as department: SELECT KCBMZD_BMMC FROM KCBMZDWHERE KCBMZD_MX=1;
MONTH: referred to for 12 month, 01-12;
The configuration format of DW control: dwo_name:arg_col 1:arg_col 2:arg_col....;
Dwo_name: the title of the data window object of quoting, use the PB exploitation, then by data window import feature import system;
Arg ...: the source of the parameter of corresponding data window, the name of row are necessary in the main form and are listed as accordingly; When form moved, system at first obtained the current line of main form, obtained the value on this row respective column then successively;
The configuration format of REPORT control: CXBH:SJLM1=COL1:SJLM2=COL2....
CXBH: report number;
SJLM: the parameter name of associated form;
COL: the title of the row of primary buffer;
The configuration format of SP control: H/V:OBJ1, OBJ2 ..:OBJ21, OBJ22...;
H is expressed as horizontal subdivision, and V is expressed as longitudinal subdivision;
OBJ1, OBJ2 ... it is first group, as for H is illustrated in the left side, as being illustrated in the top for V;
OBJ21, OBJ22 ... be second group, H is illustrated in the right in this way, as being illustrated in bottom for V.
CNA2007101144630A 2007-11-21 2007-11-21 Method for exhibiting abstraction and integration for interface Pending CN101187864A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CNA2007101144630A CN101187864A (en) 2007-11-21 2007-11-21 Method for exhibiting abstraction and integration for interface

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CNA2007101144630A CN101187864A (en) 2007-11-21 2007-11-21 Method for exhibiting abstraction and integration for interface

Publications (1)

Publication Number Publication Date
CN101187864A true CN101187864A (en) 2008-05-28

Family

ID=39480276

Family Applications (1)

Application Number Title Priority Date Filing Date
CNA2007101144630A Pending CN101187864A (en) 2007-11-21 2007-11-21 Method for exhibiting abstraction and integration for interface

Country Status (1)

Country Link
CN (1) CN101187864A (en)

Cited By (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101414256B (en) * 2008-11-26 2010-09-08 浪潮集团山东通用软件有限公司 Construction method of general-purpose data filtering component
WO2010148836A1 (en) * 2009-12-09 2010-12-29 中兴通讯股份有限公司 Method and apparatus for displaying network management objects in a network management system
CN102629271A (en) * 2012-03-13 2012-08-08 北京工商大学 Complex data visualization method and equipment based on stacked tree graph
CN103186543A (en) * 2011-12-27 2013-07-03 中国移动通信集团浙江有限公司 Page label processing method and page label processing device
CN103415854A (en) * 2011-03-11 2013-11-27 皇家飞利浦有限公司 Displaying a set of interrelated objects
CN105988814A (en) * 2015-03-02 2016-10-05 腾讯科技(深圳)有限公司 Interface generation method and apparatus
CN107193852A (en) * 2016-08-03 2017-09-22 上海同豪土木工程咨询有限公司 General chart expression
CN107818501A (en) * 2017-03-03 2018-03-20 平安医疗健康管理股份有限公司 Calculating method and device
CN108287713A (en) * 2017-12-22 2018-07-17 深圳康得新智能显示科技有限公司 Adding method and device, terminal, storage medium, the electronic device of document function

Cited By (15)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101414256B (en) * 2008-11-26 2010-09-08 浪潮集团山东通用软件有限公司 Construction method of general-purpose data filtering component
WO2010148836A1 (en) * 2009-12-09 2010-12-29 中兴通讯股份有限公司 Method and apparatus for displaying network management objects in a network management system
US9842190B2 (en) 2011-03-11 2017-12-12 Koninklijke Philips N.V. Displaying a set of interrelated objects
CN103415854B (en) * 2011-03-11 2017-05-03 皇家飞利浦有限公司 Displaying a set of interrelated objects
CN103415854A (en) * 2011-03-11 2013-11-27 皇家飞利浦有限公司 Displaying a set of interrelated objects
CN103186543B (en) * 2011-12-27 2016-01-20 中国移动通信集团浙江有限公司 A kind of disposal route of page-tag and device
CN103186543A (en) * 2011-12-27 2013-07-03 中国移动通信集团浙江有限公司 Page label processing method and page label processing device
CN102629271B (en) * 2012-03-13 2013-12-04 北京工商大学 Complex data visualization method and equipment based on stacked tree graph
CN102629271A (en) * 2012-03-13 2012-08-08 北京工商大学 Complex data visualization method and equipment based on stacked tree graph
CN105988814A (en) * 2015-03-02 2016-10-05 腾讯科技(深圳)有限公司 Interface generation method and apparatus
CN107193852A (en) * 2016-08-03 2017-09-22 上海同豪土木工程咨询有限公司 General chart expression
CN107193852B (en) * 2016-08-03 2020-09-29 上海同豪土木工程咨询有限公司 General method of graphical representation
CN107818501A (en) * 2017-03-03 2018-03-20 平安医疗健康管理股份有限公司 Calculating method and device
CN107818501B (en) * 2017-03-03 2021-01-08 平安医疗健康管理股份有限公司 Actuarial method and device
CN108287713A (en) * 2017-12-22 2018-07-17 深圳康得新智能显示科技有限公司 Adding method and device, terminal, storage medium, the electronic device of document function

Similar Documents

Publication Publication Date Title
CN101187864A (en) Method for exhibiting abstraction and integration for interface
Plattner et al. The in-memory revolution: how SAP HANA enables business of the future
Swayne et al. GGobi: evolving from XGobi into an extensible framework for interactive data visualization
US7890922B2 (en) System and article of manufacture for integration of data management operations into a workflow system
US7379908B2 (en) Populating cells of an electronic financial statement
US7613688B2 (en) Generating business warehouse reports
US5752253A (en) Process and device for the automatic generation of spreadsheets
US20110276869A1 (en) System and method for dynamic binding of a spreadsheet with external parameters
KR20080005500A (en) Transforming business models
CN103177308A (en) Intelligent decision-making support system for project management
CN116225429A (en) Pulling type component frame-based ipage webpage type low-code development platform
US20110246535A1 (en) Apparatus and Method for Constructing Data Applications in an Unstructured Data Environment
CN111767335A (en) Data visualization analysis method
US20050234886A1 (en) Report designer tool and method
CN100451931C (en) Systems, methods, and computer program products to modify the graphical display of data entities and relational database structures
JP7339628B2 (en) Online report creation system using Excel tools
CN110275996B (en) Device and method for providing page frame for content development through data visualization development
Janus et al. Pro SQL Server 2008 Analysis Services
Bezivin et al. Model transformations in practice workshop, october 3rd 2005, part of models 2005
Zanzig et al. Hands-on training in relational database concepts
US20220188284A1 (en) Systems and methods using generic database search models
Chapple Microsoft SQL Server 2008 for dummies
JP2831866B2 (en) Spreadsheet software cooperation processing device
Cornell Excel as your database
Pearson et al. Working with Power Apps Expressions

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C02 Deemed withdrawal of patent application after publication (patent law 2001)
WD01 Invention patent application deemed withdrawn after publication

Open date: 20080528