<?xml version="1.0" encoding="UTF-8"?> <!-- $Author: zhangxing5129 $Date: 2013-10-23 下午09:09:04 $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 c.project_id, c.contract_id, c.contract_number, c.contract_name, c.contract_status, c.contract_status_desc, c.bp_id_tenant, c.bp_name, prj305_save_pkg.get_con_lease_item(c.contract_id) lease_item_name, prj305_save_pkg.get_con_guarantor(c.contract_id) guarantor_name, c.finance_amount, c.document_type, c.document_type_desc, c.billing_method, c.billing_method_desc from con_contract_v c #WHERE_CLAUSE# order by c.contract_number desc ]]></bm:query-sql> </bm:operation> </bm:operations> <bm:fields> <bm:field name="project_id"/> <bm:field name="contract_number"/> <bm:field name="contract_name"/> <bm:field name="contract_status"/> <bm:field name="contract_status_desc"/> <bm:field name="bp_id_tenant"/> <bm:field name="bp_name"/> <bm:field name="guarantor_name"/> <bm:field name="lease_item_name"/> <bm:field name="finance_amount"/> <bm:field name="document_type_desc"/> <bm:field name="billing_method"/> <bm:field name="billing_method_desc"/> </bm:fields> <bm:data-filters> <!--<bm:data-filter enforceOperations="query" expression="c.project_id=${@project_id}"/>--> </bm:data-filters> </bm:model>