Form中单独使用query过滤数据源表连接

该初始方法写在Form的数据源中，这里只要用此方法就可以达到初始过滤的效果，而不用executeQuery方法结合

 

public void init()
{
    Query                   q;
    QueryBuildDataSource    qB;
    QueryBuildDataSource    qB2;
    ;

    super();

    q = new Query();

    qB  = q.addDataSource(tablenum(AssetTable));
    qB2 = qB.addDataSource(tablenum(AssetBook));
    qB2.addLink(FieldNum(AssetTable,AssetId),fieldNum(AssetBook,AssetId));
    qB2.addRange(Fieldnum(AssetBook,Status)).value(enum2value(AssetStatus::Open));
    qB2.addRange(Fieldnum(AssetBook,Status)).value(enum2value(AssetStatus::NoAcquisition));
    qB2.joinMode(JoinMode::EXISTSJOIN);

    this.query(q);
}