EAS-BOS合并范围组织架构

合并范围组织架构

List existOrgList = new ArrayList(orgs.size()); for (Iterator it = orgs.iterator(); it.hasNext();) {

OrgStructureInfo structure = (OrgStructureInfo) it.next(); existOrgList.add(structure.getUnit().getId().toString());

System.out.println(\合并范围ID：\+ treeid +\+\合并单元之财务组织ID：\+structure.getUnit().getId().toString()); }

6、根据实体公司取合并范围（有可能分配到多个合并范围）

EntityViewInfo view = new EntityViewInfo();

SelectorItemCollection selector = view.getSelector(); selector.add(new SelectorItemInfo(\)); FilterInfo filter = new FilterInfo();

String unitid = \; //实体公司ID

filter.getFilterItems().add(new FilterItemInfo(\, new Integer(8), CompareType.EQUALS)); // 合并范围

// 启用的

filter.getFilterItems().add(new FilterItemInfo(\, UnionVersionStatusEnum.START, CompareType.EQUALS)); // 用于集团并账的

filter.getFilterItems().add(new FilterItemInfo(\, new Boolean(true), CompareType.EQUALS)); filter.getFilterItems().add(new FilterItemInfo(\, unitid, 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); List existOrgList = new ArrayList(orgs.size());

合并范围组织架构

for (Iterator it = orgs.iterator(); it.hasNext();) {

OrgStructureInfo structure = (OrgStructureInfo) it.next(); existOrgList.add(structure.getTree().getId().toString());

System.out.println(\合并单元之财务组织ID：\+unitid+\+\合并范围ID：\+structure.getTree().getId().toString()); }

7、合并范围组织架构关系SQL

--合并范围

select * from t_org_tree where ftype=8 and fid='dhg9rvxZSt2IoSJuHPN3dU8oJ/0=';

--ftreeid:合并范围ID，funitid:合并单元、财务组织ID

select funitid,ftreeid,fid from t_org_structure where ftreeid = 'dhg9rvxZSt2IoSJuHPN3dU8oJ/0=';

--合并单元、财务组织

select * from t_org_baseunit where fisunion=0 and fid in (select funitid from t_org_structure where ftreeid = 'dhg9rvxZSt2IoSJuHPN3dU8oJ/0=');