Ax Lookup Form

时间:2023-12-20 19:14:56

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();
}