<?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.bp_id, t.bp_code, t.bp_name as description FROM hls_bp_master t WHERE t.enabled_flag = 'Y' and t.bp_category = 'AGENT' ) #WHERE_CLAUSE# ORDER BY bp_code ]]></bm:query-sql> </bm:operation> </bm:operations> <bm:fields> <bm:field name="bp_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="bp_id"/> <bm:field name="bp_code" databaseType="VARCHAR2" datatype="java.lang.String" displayWidth="100" forDisplay="true" forQuery="true" physicalName="bp_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="bp_code" queryOperator="like"/> </bm:query-fields> </bm:model>