Data ($UI/system/components/justep/data/data)

使用范围：UI2

component Data ($UI/system/components/justep/data/data) extends ModelComponent

	
	数据刷新说明：
		原则：
			1、limit为-1时表示不分页加载数据，一次全部加载，反之
			2、部分刷新函数提供“增量模式”参数，当使用“增量模式”时原修改数据不会覆盖，只是增加新刷新的数据
			3、getCount()函数获取的是前端已经加载的记录数，getTotal()函数获取的是全部的记录数，包括分页没有加载的数据。getTotal()函数在refreshData或者loadData后可以使用
 		主要函数：
 			1、refreshData刷新首页或者全部数据，受limit影响
			2、loadPageData加载指定页数据，limit!=-1时可以使用
			3、loadNextPageData根据当前offset加载下一页数据，limit!=-1时可以使用
			4、loadAllPageData分页时加载所有数据，limit!=-1时可以使用
	数据新增案例参考：Data#newData
	数据保存案例参考：Data#saveData
	遍历当前.W中的Data案例参考：Data.each、Data.eachAll
	统计函数参考：Data.count、Data.sum、Data.avg、Data.min、Data.max
	过滤条件设置参考：Data#setFilter
	数据查找参考：Data#find
	

Constructor Top

Static Properties & Enumerations Top

Properties Top

Attributes Top

Methods Top

Operations Top

Events Top

Constructor details Top

public Data ()

	
	数据刷新说明：
		原则：
			1、limit为-1时表示不分页加载数据，一次全部加载，反之
			2、部分刷新函数提供“增量模式”参数，当使用“增量模式”时原修改数据不会覆盖，只是增加新刷新的数据
			3、getCount()函数获取的是前端已经加载的记录数，getTotal()函数获取的是全部的记录数，包括分页没有加载的数据。getTotal()函数在refreshData或者loadData后可以使用
 		主要函数：
 			1、refreshData刷新首页或者全部数据，受limit影响
			2、loadPageData加载指定页数据，limit!=-1时可以使用
			3、loadNextPageData根据当前offset加载下一页数据，limit!=-1时可以使用
			4、loadAllPageData分页时加载所有数据，limit!=-1时可以使用
	数据新增案例参考：Data#newData
	数据保存案例参考：Data#saveData
	遍历当前.W中的Data案例参考：Data.each、Data.eachAll
	统计函数参考：Data.count、Data.sum、Data.avg、Data.min、Data.max
	过滤条件设置参考：Data#setFilter
	数据查找参考：Data#find
	

Static Properties & Enumerations Detail Top

static public Row Row

Properties Detail Top

public boolean autoLoad = false

public boolean autoNew = false

public boolean confirmDelete

public string confirmDeleteText

public boolean confirmRefresh

public string confirmRefreshText

public object defCols

public object deleteDatas

public boolean directDeleteMode

public integer limit

public slaveDatas

public string xid

Attributes Detail Top

public boolean autoLoad = false

public boolean autoNew = false

public boolean isTree

public integer limit

public master

	包括属性：
		data 主Data对象
		column 关联关系
	xml格式：
	
		<master data="" column=""/>
	

public XML rule

	只读规则包含expr表达式部分，当表达式计算结果为True时只读，当只读定义在rule根下时为整个data的只读规则
	计算规则包含expr表达式部分，对应列的值来自于表达式计算结果
	必填规则包含expr表达式部分和message提示部分，当表达式计算结果为True时该列为必填，没有填写数据违反必填规则时提示message信息
	约束规则包含expr表达式部分和message提示部分，当表达式计算结果为False时违反约束规则提示message信息
	
	xml格式说明：
	
      <rule>
        <!--data的只读规则定义-->
        <readonly> 
            <expr>js:true</expr> 
        </readonly>  
        <col name="fDecimal"> 
          <!--fDecimal列的只读规则定义-->
          <readonly> 
            <expr>js:true</expr> 
          </readonly>
          <!--fDecimal列的计算规则定义-->  
          <calculate> 
            <expr>js:$model.slaveData?$model.slaveData.sum('fDecimal',$row):0</expr> 
          </calculate> 
        </col> 
        <col name="fString"> 
          <!--fString列的必填规则定义-->
          <required> 
            <expr>js:true</expr>
            <message>fString不能为空</message> 
          </required>
          <!--fString列的计算规则定义-->  
          <constraint> 
            <expr>js:$val[0]=='A'</expr> 
            <message>fString第一个字符必须为'A'</message> 
          </constraint> 
        </col> 
      </rule>  
	

public treeOption

	包括属性：
		parentRelation [attribute] 父关系，形成父子树的父关系
		rootFilter [attribute] 根过滤条件，当设置时树形数据将按节点加载数据
		delayLoad [attribute] 延迟数据加载，默认值为true
		nodeKindRelation [attribute] 节点类型关系，data操作时使用指定relation自动记录是否叶子节点信息
	xml格式：
	
		<treeOption parentRelation="" delayLoad="" rootFilter=""
			nodeKindRelation=""
			nodeLevelRelation="" />
	

Methods Detail Top

public void add (object defaultValue, Row parent)

public object aggVal (string col)

public void applyUpdates ()

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){
    	var v = ev.source.getValue('fName',ev.row);
    	return v.indexOf('李')==0;
    });
    

public number avgByAll (string column, function | Row filterCallback)

public boolean bof ()

public string buildFilter ()

public void cancelUpdates ()

public void clear ()

public void clearOrderBy ()

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){
    	var v = ev.source.getValue('fName',ev.row);
    	return v.indexOf('李')==0;
    });
    

public number countByAll (function filterCallback)

public void deleteAllData (DataConfirmParam options)

public boolean deleteData (Array rows, DataConfirmParam options)

 
 
 //不提示直接提交后台删除当前行
 var data = this.comp('mainData');
 var confirmDelete = data.confirmDelete;
 var directDeleteMode = data.directDeleteMode;
 try{
	 data.confirmDelete = false;
	 data.directDeleteMode = true;
	 data.deleteData(data.getCurrentRow());
 }finally{
 	data.confirmDelete = confirmDelete;
 	data.directDeleteMode = directDeleteMode;
 }
 

public void disableRecordChange ()

public void doDeleteAfter (boolean success, Object options, Object params)

public void doRefreshAfter (boolean success, Object options, Object params)

public void doSaveAfter (boolean success, Object options, Object params)

public void each (function callback, object caller, Row parent)

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

public void eachAll (function callback, object caller, Row parent)

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

public void eachAllByPeek (function callback, object caller, Row parent)

public void eachByPeek (function callback, object caller, Row parent)

public void enabledRecordChange ()

public boolean eof ()

public void exchangeRow (Row row1, Row row2)

public boolean exist (String rowID)

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

  根据列和值匹配进行数据查找，可以匹配多列
 
 //查找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 object getAggregateValue (String col)

 
  注意：
  1、返回都是字符串类型
  2、统计值更新依赖refreshData，data设置数据分页加载取后续页数据时不会刺激统计计算更新
  后端queryAction的aggregate参数定义：count(SA_OPPerson) as personCount
 //前端js中获取
 this.comp('mainData').getAggregateValue('personCount')
 

public String getChangedIDs (Data.STATE type, String delim)

public list<Row> getChangedRows (Data.STATE type)

public String getColumnIDs ()

public integer getCount (Row parent)

public void getCurrentRow (boolean peek)

public Any getCurrentRowID ()

public String getFilter (String name)

public Row getFirstRow ()

public Array getIDs ()

public string getInvalidInfo (boolean force)

public Row getLastRow ()

public integer getOffset (Row parent)

public integer getOrderBy (string relation)

public Any getOriginalValue (string col, Row row)

public boolean getReadonly ()

public Row getRowByID (string rowid)

public Any getRowID (Row row，行对象)

public integer getRowIndex (Row row)

public Data.STATE getRowState (Row row)

public integer getTotal (Row parent)

public object getTreeOption ()

public object getUserData (string name, Row row)

  
    典型用法：
    1、当queryAction或者createAction返回Table时通过table.getProperties().put("name", "beijing")设置值可以使用this.comp(dataID).getUserData('name')获取
    2、和setUserData函数配合使用扩展data的状态或者行状态
    注意：5.2.6及以后版本提供    

    典型用法1案例：
    //biz端java中createAction设置扩展属性key
	public static Table create(Table table, String concept, Map<String, String> defaultValues, String fnModel) {
		Table t = BizData.create(table, concept, defaultValues, fnModel);
		t.getProperties().put("key", "password");
		return t;
	}
	//前端js中通过data获取    
    this.comp('mainData').getUserData('key');
    典型用法2案例：
    //给当前行增加key
    var data = this.comp('mainData');
    var row = data.getCurrentRow();
    data.setUserData('key','abcdefg',row);
    //读取行的key
    data.getUserData('key', row);    
          

public Any getValue (String col, Row row)

public object getValueByID (String col, String rowid)

public boolean isCalculateCol (string col)

public boolean isChanged ()

public boolean isLeaf (Row row)

public boolean isSelfChanged ()

public boolean isSlaveChanged ()

public boolean isTree ()

public boolean isValid (boolean force)

public string label (string col)

public void last ()

public boolean loadAllPageData (Object options)

public void loadData (JSON data, Boolean append, integer index, boolean override)

public boolean loadNextPageData (Object options)

public boolean loadPageData (integer pageIndex, Object options)

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){
    	var v = ev.source.getValue('fName',ev.row);
    	return v.indexOf('李')==0;
    });
    

public number maxByAll (string column, function | Row filterCallback)

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){
    	var v = ev.source.getValue('fName',ev.row);
    	return v.indexOf('李')==0;
    });
    

public number minByAll (string column, function | Row filterCallback)

public List newData (JSON options)

 
 
 	//新增两行数据到最后，并且给出sName和sCode的默认值
 	var data = this.comp('mainData');
 	var options = {
 		defaultValues : [
 			{sName:'a1',sCode:'b1'},
 			{sName:'a2',sCode:'b2'}
 		]
 	};	
 	data.newData(options);
 

public void next ()

public void open ()

public void pre ()

public object ref (string col, Row row)

public boolean refreshData (RefreshDataParam options)

 
 
 //强制刷新data
 var data = this.comp('mainData');
 var confirmRefresh = data.confirmRefresh;
 try{
	 data.confirmRefresh = false;
	 data.refreshData();
 }finally{
 	data.confirmRefresh = confirmRefresh;
 }
 		

public void remove (Row row)

public Boolean saveData (Object options)

 
 
 	//保存成功后刷新data
 	this.comp('mainData').saveData(
	 {
	 	"onSuccess" : function(event){
	 		event.source.refreshData();
	 	}
 	 });
 		

public void setFilter (String name, String filter)

  
    var data = this.comp('mainData');
    data.setFilter('filter1',"SA_OPPerson.sName like '%李%'");
    data.setFilter('filter2',"SA_OPPerson.sCode = :operatorCode() or SA_OPPerson.sCode = :code");
    //给变参code赋值
    data.filters.setStringVar("code","code_abc");
    //最终qureyAction的KSQL中where部分将增加 and ((SA_OPPerson.sName like '%李%') and (SA_OPPerson.sCode = :operatorCode() or SA_OPPerson.sCode = 'code_abc'))
    

public void setOrderBy (string relation, integer type)

public void setRowState (Row row, Data.STATE state)

public void setTotal (integer count, Row parent)

public void setUserData (String name, String value, Row row)

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

public void setValueByID (string col, object value, string rowid)

public void sort (function callback)

  
    this.comp('mainData').sort(function(row1,row2){
    	return row1.val('fage')>row2.val('fage')?1:-1;
    });
  

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){
    	var v = ev.source.getValue('fName',ev.row);
    	return v.indexOf('李')==0;
    });
    

public number sumByAll (string column, function | Row filterCallback)

public void to (Row | string row)

public Object toJson (JsonParam option)

public object val (string col, Row row)

Operations Detail Top

public clear ()

public void delete (List.<Row> | Row 删除的行或者行数组，缺省为当前行)

public void deleteAll (boolean force)

public void firstPage ()

public void firstRow ()

public void lastPage ()

public void lastRow ()

public void loadAllPage ()

public void loadNextPage ()

public void loadPage (integer pageIndex)

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

public void newBrother (Row parent)

public void newChild (Row parent)

public void nextPage ()

public void nextRow ()

public void prevPage ()

public void prevRow ()

public void refresh (boolean force)

public void save ()

Events Detail Top

public void onAfterDelete (AfterDeleteEvent event)

public void onAfterNew (AfterNewEvent event)

public void onAfterRefresh (AfterRefreshEvent event)

public void onAfterSave (BeforeSaveEvent event)

public void onBeforeDelete (BeforeDeleteEvent event)

public void onBeforeNew (BeforeNewEvent event)

public void onBeforeRefresh (BeforeRefreshEvent event)

public void onBeforeSave (BeforeSaveEvent event)

public void onCreate (ModelEvent event)

public void onCustomDelete (BeforeDeleteEvent event)

public void onCustomNew (CustomNewEvent event)

public void onCustomRefresh (CustomRefreshEvent event)

public void onCustomSave (CustomSaveEvent event)

public void onDataChange (DataChangeEvent event)

public void onIndexChanged (IndexChangedEvent event)

public void onIndexChanging (IndexChangingEvent event)

public void onLoadSlave (LoadSlaveEvent event)

public void onSaveCommit (ModelEvent event)

public void onValueChange (ValueChangeEvent event)

public void onValueChanged (ValueChangedEvent event)