对EntityViewInfo的理解
2024-09-06 16:17:58
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中指定需要取哪些属性,比如
2,AtsOverTimeBillEditHandler.class中案例,加上自己的理解.
EntityViewInfo EntityViewInfo = new EntityViewInfo();//新建接口
SelectorItemCollection sic = new SelectorItemCollection(); //通过Selector设定属性
sic.add(new SelectItemInfo("proposer.id"));//表示只获取info上proposer上id属性
sic.add(new SelectItemInfo("id"));//表示只获取info上id属性
sic.add(new SelectItemInfo("attendDate"));//表示只获取info上attendDate属性
sic.add(new SelectItemInfo("dayType"));//表示只获取info上dayType属性
entityViewInfo.setSelector(sic);//设置属性
FilterInfo filterInfo = new FilterInfo();//建立过滤条件
filterInfo.getFilterItems().add(new FilterItemInfo("proposer.id",personInfo.getId().toString()));
filterInfo.getFilterItems().add(new FilterItemInfo("attendDate",newDate,CompareType.GREATER_EQUALS));
entityViewInfo.setFilter(filterInfo);//设置过滤条件
3,AtsOverTimeBillListHandler这个里面的代码补充
FilterInfo fla = new FilterInfo();
fla.getFilterItems().add(new com.kingdee.bos.metadata.entity.FilterItemInfo("entries.otDate", beginDateTs, CompareType.GREATER_EQUALS));
fla.getFilterItems().add(new com.kingdee.bos.metadata.entity.FilterItemInfo("entries.otDate", endDateTs, CompareType.LESS_EQUALS)); FilterInfo flb1 = new FilterInfo();
flb1.getFilterItems().add(new com.kingdee.bos.metadata.entity.FilterItemInfo("billState", Integer.valueOf(1), CompareType.EQUALS));
FilterInfo flb2 = new FilterInfo();
flb2.getFilterItems().add(new com.kingdee.bos.metadata.entity.FilterItemInfo("billState", Integer.valueOf(2), CompareType.EQUALS));
FilterInfo flb3 = new FilterInfo();
flb3.getFilterItems().add(new com.kingdee.bos.metadata.entity.FilterItemInfo("billState", Integer.valueOf(3), CompareType.EQUALS));
String existsSql = "SELECT 1 FROM T_HR_ATS_AttendanceResult attenceResult WHERE attenceResult.FPROPOSERID = ENTRIES.FPERSONID AND to_char(attenceResult.Fattencedate,'YYYY-MM-DD') >= '" + beginDate + "'" + " AND to_char(attenceResult.Fattencedate,'YYYY-MM-DD') <= '" + endDate + "'" + " AND to_char(attenceResult.Fattencedate,'YYYY-MM-DD') = to_char(ENTRIES.fotDate,'YYYY-MM-DD')" + " AND attenceResult.FLASTUPDATETIME <= ATSOVERTIMEBILL.FLASTUPDATETIME"; flb3.getFilterItems().add(new com.kingdee.bos.metadata.entity.FilterItemInfo("PERSON.ID", existsSql, CompareType.EXISTS)); FilterInfo flb4 = new FilterInfo();
flb4.getFilterItems().add(new com.kingdee.bos.metadata.entity.FilterItemInfo("billState", Integer.valueOf(3), CompareType.EQUALS));
String notExistsSql = "SELECT 1 FROM T_HR_ATS_AttendanceResult attenceResult WHERE attenceResult.FPROPOSERID = ENTRIES.FPERSONID AND to_char(attenceResult.Fattencedate,'YYYY-MM-DD') >= '" + beginDate + "'" + " AND to_char(attenceResult.Fattencedate,'YYYY-MM-DD') <= '" + endDate + "'" + " AND to_char(attenceResult.Fattencedate,'YYYY-MM-DD') = to_char(ENTRIES.fotDate,'YYYY-MM-DD')"; flb4.getFilterItems().add(new com.kingdee.bos.metadata.entity.FilterItemInfo("PERSON.ID", notExistsSql, CompareType.NOTEXISTS)); FilterInfo flb = new FilterInfo();
flb.mergeFilter(flb1, "OR"); //这是一个含有合并过滤(mergeFilter)的案例 可以是"OR"
flb.mergeFilter(flb2, "OR");
flb.mergeFilter(flb3, "OR");
flb.mergeFilter(flb4, "OR"); filter.mergeFilter(fla, "AND");//这是一个含有合并过滤(mergeFilter)的案例 也可以是"and"
filter.mergeFilter(flb, "AND");
4,
给列表添加过滤条件:
http://blog.csdn.net/fenyu8/article/details/12085499
5,设置列表界面打开时查询的缺省过滤条件,返回null值屏蔽CU条件 getDefaultFilterForQuery
6,
//这是一种比较特殊的用法,目前,还不懂意思
protected FilterInfo getDefaultFilter(HttpServletRequest request, HttpServletResponse response)
throws WafException
{
FilterInfo filterInfo = super.getDefaultFilter(request, response);
filterInfo = AtsWebUtils.getDefaultOrgFilter(filterInfo);
return filterInfo;
}
7,
做EAS,包括shr要养成一个习惯:打补丁前备份整个服务器目录,有问题就还原
8, 其他的案例
http://blog.csdn.net/douml88/article/details/8855333
9,要是不会,就可以找找js源码解读
最新文章
- 前端学HTTP之报文起始行
- mybatis一对多关联
- SQL常用字段类型
- delphi中exit,abort,break,continue 的区别
- TAP/TUN浅析(一)
- crawler: 爬虫的基本结构
- SQL Server 中的 NOLOCK 用法
- 分享一个Fluent风格的邮件发送封装类
- 华为S5700S配置总结
- EditText属性详解
- 删除左右两边的空格trim
- x64_dbg破解64位WinSnap4.5.6图文视频教程
- ORM Basic
- Esp8266
- MySQL性能优化神器—explain
- Docker安装使用battery historian
- eclipse中的yaml插件
- linux问题解答
- MySQL 死锁与日志二三事
- 深入理解RESTful Web Services