<?xml version="1.0" encoding="UTF-8"?> <!-- $Author: wangwei $Date: 2015-12-14 下午8:28:38 $Revision: 1.0 $Purpose: --> <bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm"> <bm:operations> <bm:operation name="query"> <bm:query-sql><![CDATA[ SELECT e.employee_id, e.employee_code, e.name FROM exp_employees e WHERE EXISTS (SELECT 1 FROM prj_project p WHERE p.employee_id=e.employee_id ) ORDER BY e.employee_code ]]></bm:query-sql> </bm:operation> </bm:operations> <bm:fields> <bm:field name="employee_id"/> <bm:field name="employee_code" displayWidth="210" forDisplay="true" forQuery="true" prompt="员工编号"/> <bm:field name="name" displayWidth="210" forDisplay="true" forQuery="true" prompt="员工名称"/> </bm:fields> </bm:model>