EAS人员按照公司过滤

EAS在单据开发时，有个F7字段，引用的是职员，需要按照公司做过滤，EAS中的公司和财务组织是对应的，但和人员关系最近的是行政组织，通过财务组织的number等属性找到对应的行政组织和下级行政组织。基于此，我们对人员的按照公司过滤，可以按照行政组织过滤。

职员和行政组织的关系我们可以通过F7PersonQuery来看出：

 

SELECT 

 

"PERSON".FID AS "ID", 

"PERSON".FNumber AS "NUMBER", 

"PERSON".FName_l2 AS "NAME", 

"POSITION".FName_l2 AS "POSITION.NAME", 

"ADMINORGUNIT".FName_l2 AS "ADMINORGUNIT.NAME"

 

FROM T_BD_Person AS "PERSON"

 

INNER JOIN T_ORG_PositionMember AS "POSITIONMEMBER"

ON "PERSON".FID = "POSITIONMEMBER".FPersonID

 

INNER JOIN T_ORG_Position AS "POSITION"

ON "POSITIONMEMBER".FPositionID = "POSITION".FID

 

INNER JOIN T_ORG_Admin AS "ADMINORGUNIT"

ON "POSITION".FAdminOrgUnitID = "ADMINORGUNIT".FID