<?xml version="1.0" encoding="UTF-8"?> <!-- $Author: liukang $Date: 2016年4月06日 上午11:41:34 $Revision: 1.0 $Purpose: --> <bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false"> <bm:operations> <bm:operation name="query"> <bm:query-sql><![CDATA[ SELECT * FROM (SELECT t.province_id, t.province_code, t.description FROM FND_PROVINCE t WHERE t.enabled_flag='Y' ) #WHERE_CLAUSE# ORDER BY province_code ]]></bm:query-sql> </bm:operation> </bm:operations> <bm:fields> <bm:field name="province_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PROVINCE_ID"/> <bm:field name="province_code" databaseType="VARCHAR2" datatype="java.lang.String" displayWidth="100" forDisplay="true" forQuery="true" physicalName="PROVINCE_CODE" prompt="省份代码"/> <bm:field name="description" databaseType="VARCHAR2" datatype="java.lang.String" displayWidth="200" forDisplay="true" forQuery="true" physicalName="DESCRIPTION" prompt="省份名称"/> </bm:fields> <bm:query-fields> <bm:query-field field="description" queryOperator="like"/> <bm:query-field field="province_code" queryOperator="like"/> </bm:query-fields> </bm:model>