<?xml version="1.0" encoding="UTF-8"?><!-- $Author: wangwei $Date: 2016-1-6 上午10:41:07 $Revision: 1.0 $Purpose: --><bm:modelxmlns:bm="http://www.leaf-framework.org/schema/bm"><bm:operations><bm:operationname="query"><bm:query-sql><![CDATA[ select su.employee_id,ee.name employee_id_n,ea.unit_id,ea.unit_name unit_id_n,(select ea1.employee_id from exp_emp_assign_e_v ea1 where ea1.position_id=p.parent_position_id) EMPLOYEE_ID_OF_MANAGER,(select ea1.employee_name from exp_emp_assign_e_v ea1 where ea1.position_id=p.parent_position_id) EMPLOYEE_ID_OF_MANAGER_n from sys_user su,exp_employees ee, exp_emp_assign_e_v ea, exp_org_position p where su.frozen_flag='N' and ee.employee_id=su.employee_id and ee.employee_id=ea.employee_id and ea.primary_position_flag='Y' and p.position_id=ea.position_id and p.enabled_flag='Y' and su.user_id=${/session/@user_id} ]]></bm:query-sql></bm:operation></bm:operations></bm:model>