合并范围组织架构
合并范围组织架构
1、合并范围组织架构实体关系 ........................................................................................................................................................................................................ 1 2、合并范围组织架构数据模型 ........................................................................................................................................................................................................ 2 3、取所有启用的用于集团并账的合并范围 .................................................................................................................................................................................... 2 4、根据合并范围取顶级合并单元 .................................................................................................................................................................................................... 3 5、根据合并范围取实体公司 ............................................................................................................................................................................................................ 4 6、根据实体公司取合并范围(有可能分配到多个合并范围) .................................................................................................................................................... 5 7、合并范围组织架构关系SQL ....................................................................................................................................................................................................... 6
1、合并范围组织架构实体关系
合并范围组织架构
2、合并范围组织架构数据模型
3、取所有启用的用于集团并账的合并范围
//定义实体视图
EntityViewInfo viewInfo = new EntityViewInfo();
//设置排序字段
viewInfo.getSorter().add(new SorterItemInfo(\)); //设置查询字段
合并范围组织架构
viewInfo.getSelector().add(new SelectorItemInfo(\)); //设置过滤条件
FilterInfo filter = new FilterInfo();
filter.getFilterItems().add(new FilterItemInfo(\, new Integer(8), CompareType.EQUALS)); // 合并范围 filter.getFilterItems().add(new FilterItemInfo(\, new Integer(1), CompareType.EQUALS)); // 取合并单元 // 启用的
filter.getFilterItems().add(new FilterItemInfo(\, UnionVersionStatusEnum.START, CompareType.EQUALS)); filter.setMaskString(\);//条件关系默认为and viewInfo.setFilter(filter);
//获取远程接口
IOrgStructure iStruct = OrgStructureFactory.getRemoteInstance(); OrgStructureCollection structCol
//返回结果集
structCol = iStruct.getOrgStructureCollection(viewInfo);
4、根据合并范围取顶级合并单元
EntityViewInfo view = new EntityViewInfo();
SelectorItemCollection selector = view.getSelector(); selector.add(new SelectorItemInfo(\)); FilterInfo filter = new FilterInfo();
String treeid = orgTreeInfo.getId().toString();//合并范围ID
filter.getFilterItems().add(new FilterItemInfo(\, treeid, CompareType.EQUALS));//根据合并范围ID
filter.getFilterItems().add(new FilterItemInfo(\, new Integer(1), CompareType.EQUALS));//顶级合并单元level=1 // 0取实体公司ID,1取合并单元ID
filter.getFilterItems().add(new FilterItemInfo(\, new Integer(1), CompareType.EQUALS)); // 取合并范围
合并范围组织架构
view.setFilter(filter);
OrgStructureCollection orgs = OrgStructureFactory.getRemoteInstance().getOrgStructureCollection(view); List existOrgList = new ArrayList(orgs.size()); FullOrgUnitInfo orgUnit = null;
for (Iterator it = orgs.iterator(); it.hasNext();) { }
OrgStructureInfo structure = (OrgStructureInfo) it.next(); orgUnit = structure.getUnit();
existOrgList.add(structure.getUnit().getId().toString());
System.out.println(\合并范围ID:\+ treeid +\+\合并单元之顶级合并单元ID:\+structure.getUnit().getId().toString());
5、根据合并范围取实体公司
OrgTreeInfo orgTreeInfo = ctx.getCurOrgBound();
EntityViewInfo view = new EntityViewInfo();
SelectorItemCollection selector = view.getSelector(); selector.add(new SelectorItemInfo(\)); FilterInfo filter = new FilterInfo();
String treeid = orgTreeInfo.getId().toString();//合并范围ID
filter.getFilterItems().add(new FilterItemInfo(\, treeid, CompareType.EQUALS));//根据合并范围ID // 0取实体公司ID,1取合并单元ID
filter.getFilterItems().add(new FilterItemInfo(\, new Integer(0), CompareType.EQUALS)); // 取实体公司 view.setFilter(filter);
OrgStructureCollection orgs = OrgStructureFactory.getRemoteInstance().getOrgStructureCollection(view);
相关推荐: