还记写博客好,不记得就翻翻;不然又的重新查阅,表结构;重在积累,一点一滴;
SELECT
B.FAdminOrgUnitID,//行政组织
C.FPositionID //职位
FROM T_ORG_Position B INNER JOIN T_ORG_PositionMember C
ON B.FID = C.FPositionID
WHERE C.FIsPrimary=1 AND C.FPERSONID=申请人ID(Persion对象)
java代码获取信息
BizCollBillBaseInfo initInfo = CommonUtilFacadeFactory.getRemoteInstance().forLoanBillCreateNewData();
initInfo.getPosition();
initInfo.getOrgUnit();