<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
            select hpcab.bp_category,
			       (select hbc.description
			          from hls_bp_category hbc
			         where hbc.bp_category = hpcab.bp_category) bp_category_n,
			       hpcab.bp_type,
			       (select hbt.description
			          from hls_bp_type hbt
			         where hbt.bp_type = hpcab.bp_type) bp_type_n,
			       hpcab.fin_check_analysis,  --财务状况检查分析
			       hpcab.fin_check_conclusion  --财务状况总结
			from hn_prj_check_actual_bp hpcab 
			where hpcab.data_class = 'FIN' and hpcab.check_id = ${@check_id}
				]]></bm:query-sql>
            <bm:parameters>
                <bm:parameter name="check_id"/>
            </bm:parameters>
        </bm:operation>
    </bm:operations>
</bm:model>
