TableData ($UI/wxsys/comps/tableData/tableData)

使用范围：WX

component TableData ($UI/wxsys/comps/tableData/tableData) extends Data

Constructor Top

Properties Top

Methods Top

Operations Top

Events Top

Constructor details Top

public TableData ()

public TableData ( config)

Properties Detail Top

public Agg agg

public Row current

public Array<Row> value

Methods Detail Top

public number avg (string column进行统计的列, function filterCallback)

  
    //统计mainData中年龄fAge平均值
    var avg = this.comp('mainData').avg('fAge');
    //统计mainData中fName姓“李”的年龄fAge平均值
    var avg = this.comp('mainData').avg('fAge',function(ev){
    	let v = ev.row.fName;
    	return v.indexOf('李')==0;
    });
    

public Boolean bof ()

public String buildFilter ()

public string col (string col)

public Integer count (Function filterCallback)

  
    //统计mainData中记录数
    var count = this.comp('mainData').count();
    //统计mainData中fName姓“李”的记录数
    var count = this.comp('mainData').count(function(ev){
    	let v = ev.row.fName;
    	return v.indexOf('李')==0;
    });
    

public void each (function callback)

  
    var names = [];
    this.comp('mainData').each(function(param){
    	names.push(param.row.fName);
    });
    

public Boolean eof ()

public void exchangeRow (Row row1, Row row2)

public void fieldsValue (Row row, Any options)

public Array<Row> find (Array fields, Array values, Boolean first, Boolean caseInsensitive, Boolean partialKey)

  根据列和值匹配进行数据查找，可以匹配多列
 
 //查找fName中包含"李"的提一条数据
 var rows = this.comp('mainData').find(['fName'],['李'],true,true,true);
 if(rows.length==0) alert('没有符合条件数据');
 //查找fName="李四"，fAge=18的数据
 var rows = this.comp('mainData').find(['fName','fAge'],['李',18]);
 if(rows.length==0) alert('没有符合条件数据');
 

public void first ()

public String getColumnIDs ()

public Integer getCount ()

public Row getCurrentRow ()

public String getCurrentRowID ()

public String getCurrentRowID ()

public String getCurrentRowState ()

public String getFilter (String name)

public Row getFirstRow ()

public String getIdColumn ()

public Array getIDs ()

public Integer getIndex (Row row)

public Row getLastRow ()

public Integer getLimit ()

public Integer getOffset ()

public Integer getOrderBys (String relation)

public Row getRowByID (String rowid)

public Any getRowID (Any row)

public Integer getRowIndex ()

public Integer getTotal ()

public Any getValue (String col, Row row)

public Any getValueByID (String col, String rowid)

public string label (string col)

public void last ()

public number max (string column进行统计的列, function filterCallback)

  
    //统计mainData中年龄fAge最大值
    var min = this.comp('mainData').max('fAge');
    //统计mainData中fName姓“李”的年龄fAge最大值
    var avg = this.comp('mainData').max('fAge',function(ev){
    	let v = ev.row.fName;
    	return v.indexOf('李')==0;
    });
    

public number min (string column进行统计的列, function filterCallback)

  
    //统计mainData中年龄fAge最小值
    var min = this.comp('mainData').min('fAge');
    //统计mainData中fName姓“李”的年龄fAge最小值
    var avg = this.comp('mainData').min('fAge',function(ev){
    	let v = ev.row.fName;
    	return v.indexOf('李')==0;
    });
    

public void next ()

public void pre ()

public void setFilter (String name, String filter)

public void setOrderBy (String relation, Integer type)

public void setTotal (Integer count)

public void setValue (String col, Any value, Row row)

public void setValueByID (String col, Any value, String rowid)

public number sum (string column进行统计的列, function filterCallback)

  
    //统计mainData中年龄fAge合计
    var sum = this.comp('mainData').sum('fAge');
    //统计mainData中fName姓“李”的年龄fAge合计
    var sum = this.comp('mainData').sum('fAge',function(ev){
    	let v = ev.row.fName;
    	return v.indexOf('李')==0;
    });
    

public void to (Row row)

Operations Detail Top

public clear ()

public void delete (Any rows)

public void deleteAll (boolean force)

public void firstPage ()

public void firstRow ()

public void lastPage ()

public void lastRow ()

public void loadAllPage ()

public loadFromStorage (String key)

public void loadNextPage ()

public void loadPage (Integer pageIndex)

public void new (Array<Row> defaultValues, integer index)

public void nextPage ()

public void nextRow ()

public void prevPage ()

public void prevRow ()

public void refresh (boolean force)

public removeStorage (String key)

public void save ()

public saveToStorage (String key)

Events Detail Top

public void dataChange (DataChangeEvent event)

public void valueChanged (ValueChangedEvent event)