<?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.city_id, t.city_code, t.description FROM fnd_city t WHERE t.enabled_flag='Y' )#WHERE_CLAUSE# ORDER BY city_code ]]></bm:query-sql> </bm:operation> </bm:operations> <bm:fields> <bm:field name="city_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CITY_ID"/> <bm:field name="city_code" databaseType="VARCHAR2" datatype="java.lang.String" displayWidth="100" forDisplay="true" forQuery="true" physicalName="CITY_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 name="province_id" queryExpression="province_id =${:@province_id}"/> <bm:query-field field="city_code" queryOperator="like"/> <bm:query-field field="description" queryOperator="like"/> </bm:query-fields> </bm:model>