正文

Ax Lookup Form

IP云
IP云V管理员/2 阅读
09/20
提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

Reference： Class\sysLookupTable

1. 用临时表构造Lookup下拉结果，sysLookupTable有一个parmTmpBuffer方法，表明传入展示的结果集是临时表

系统中例子Form\AifLookupTable;

public void lookup()
{
SysTableLookup tableLookup;
Query query;
QueryBuildDataSource queryBuildDataSource;
salesTable salesTable ;
tmpTable tmp1;
; while select salesTable where createdDate == systemDateGet() || CreatedBy == "XXX"
{
tmp1.salesId = salestable.salesId;
tmp1.RecCreatedBy = salesTable.CreatedBy;
tmp1.insert();
}
query = new Query();
queryBuildDataSource = query.addDataSource(tablenum(tmpTable));
queryBuildDataSource.addSortField(fieldnum(tmpTable, SalesId)); tableLookup = SysTableLookup::newParameters(tablenum(tmpTable), this);
tableLookup.addLookupfield(fieldnum(tmpTable,SalesId));
tableLookup.addLookupfield(fieldnum(tmpTable,RecCreatedBy)); tableLookup.parmQuery(query); tableLookup.parmTmpBuffer( tmp1);//指明是临时表结果集 tableLookup.performFormLookup();
}