解决多行查询只能查询5000条的问题：

主要是加了一个do while循环，就可以一直查询下去

        EntityCollection ec = null;
        int pageNumber = 1;
        do
        {
            
            QueryExpression query = new QueryExpression("Table");
            query.ColumnSet = new ColumnSet("new_name");
            query.PageInfo = new PagingInfo();
            query.PageInfo.Count = 5000;//查询行数
            query.PageInfo.PagingCookie = (pageNumber == 1) ? null : ec.PagingCookie;
            query.PageInfo.PageNumber = pageNumber++;
            query.Criteria.AddCondition("new_name", ConditionOperator.NotNull);
            ec = serviceAdmin.RetrieveMultiple(query);
            if (ec != null && ec.Entities.Count>0)
            {
                //逻辑
            }
        } while (ec != null && ec.MoreRecords);

————————————————
版权声明：本文为CSDN博主「火土水」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/qq_60521457/article/details/126078192

1. join的顺序对结果有影响，在join下一张表前，应保证on的字段都存在。

进项目后右键项目->属性，修改以下项：

• Company为目标Company;
• Synchronize Database On Build :true;

单选

• 普通Lookup

   public Lookup(){
       Query                           query = new Query();
       QueryBuildDataSource            queryBuildDataSource;
       QueryBuildRange                 queryBuildRange;
       HRMAbsenceCode                  HRMAbsenceCode ;
  
       SysTableLookup                  sysTableLookup =
       SysTableLookup::newParameters(tableNum(HRMAbsenceCode), sender);
       sysTableLookup.addLookupField(fieldNum(HRMAbsenceCode,DESCRIPTION),true);
       sysTableLookup.addSelectionfield(fieldNum(HRMAbsenceCode,RecId)  );
  
       queryBuildDataSource = query.addDataSource(tableNum(HRMAbsenceCode));
       queryBuildDataSource.addRange(fieldNum(HRMAbsenceCode, LinkWithBenefitAccural)).value((any2Str(NoYes::yes)));
       sysTableLookup.parmQuery(query);
       sysTableLookup.performFormLookup();
    }
  

多选

• normal

     public Lookup(){
        Query query = new Query();
        QueryBuildDataSource    qbds     = query.addDataSource(tablenum(tb));
        qbds.fields().addField(fieldNum(tb, field));
        container selectedFields = [tableNum(tb), fieldNum(tb, field)];
        SysLookupMultiSelectCtrl::constructWithQuery(this, VoucherList, query, true,    selectedFields);
    }
  

tips:

• EventHandler 取消原窗体调用：

   FormControlCancelableSuperEventArgs cancelSuperEventArgs = e as FormControlCancelableSuperEventArgs;
   cancelSuperEventArgs.CancelSuperCall();

• 临时表

   sysTableLookup.parmQuery(query);
   sysTableLookup.parmTmpBuffer(TmpTableFieldLookup);
   sysTableLookup.performFormLookup();