(1)EntityViewInfo常常用作bos中接口参数,来做查询用,其中包含了FilterInfo(过滤)、Selector(指定属性)以及Sorter(排序)
SelectorItemCollection sic = new SelectorItemCollection(); //表示获取info所有的属性 sic.add(newSelectorItemInfo("*")); //表示获取info上creator上所有的属性 sic.add(newSelectorItemInfo("creator.*")); //表示只获取info上auditor上id,name和number三个属性 sic.add(new SelectorItemInfo("auditor.id")); sic.add(newSelectorItemInfo("auditor.number")); sic.add(newSelectorItemInfo("auditor.name")); 特殊的XXXFactory.getRemoteInstance().getXXXInfo(IObjectPKpk);//直接获取info,如果info中含有关联属性,只能取到关联属性的ID XXXFactory.getRemoteInstance().getXXXInfo(IObjectPKpk, SelectorItemCollection selector);//直接获取Info,通过在selector中指定需要取哪些属性,比如
1、 建立过滤条件,分录上的F7过滤
KDBizPromptBox prmt = (KDBizPromptBox) this.kdtEntrys.getColumn("feeType").getEditor().getComponent();
EntityViewInfo view = new EntityViewInfo();
FilterInfo filterInfo = new FilterInfo(); // 建立过滤条件 filterInfo.getFilterItems().add(new FilterItemInfo("number", "108", CompareType.EQUALS)); view.setFilter(filterInfo); prmt.setEntityViewInfo(view);2、通用查询
EntityViewInfo evi = new EntityViewInfo();
SelectorItemCollection selector = evi.getSelector();
selector.add(new SelectorItemInfo("id"));
selector.add(new SelectorItemInfo("startDate")); FilterInfo filter = new FilterInfo(); filter.getFilterItems().add(new FilterItemInfo("accountDate", endAccountDate, CompareType.GREATER)); evi.setFilter(filter);3、跟1差不多,表头F7过滤EntityViewInfo view = new EntityViewInfo();
FilterInfo filterInfo = new FilterInfo(); // 建立过滤条件 filterInfo.getFilterItems().add(new FilterItemInfo("number", number, CompareType.GREATER_EQUALS)); view.setFilter(filterInfo); prmtaccountTo.setEntityViewInfo(view); prmtaccountTo.getQueryAgent().resetRuntimeEntityView();4、带or过滤条件,如果不设setMaskString,则默认为and
EntityViewInfo view = new EntityViewInfo(); FilterInfo filterInfo = new FilterInfo(); // 建立过滤条件 filterInfo.getFilterItems().add(new FilterItemInfo("number", "001", CompareType.EQUALS)); filterInfo.getFilterItems().add(new FilterItemInfo("number", "005", CompareType.EQUALS)); filterInfo.setMaskString("#0 or #1");//条件为or (设置过滤条件之间的关系,不设置setMaskString时,默认为and) view.setFilter(filterInfo); prmt.setEntityViewInfo(view);