<?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 hpci.check_item_type,
			       hpci.check_item_description, --状态说明
			       hpci.check_item_conclusion,  --检查结论说明(补充说明)
			       hpci.insure_flag,            --是否投保
			       hpci.check_item_status,
			       (select v.code_value_name
			          from sys_code_values_v v
			         where v.code = 'HN_CHECK_BP_CONCLUSION'
			           and v.code_value = hpci.check_item_status) check_item_status_n --检查结论
			from hn_prj_check_item hpci 
			where hpci.check_id = ${@check_id}
				]]></bm:query-sql>
            <bm:parameters>
                <bm:parameter name="check_id"/>
            </bm:parameters>
        </bm:operation>
    </bm:operations>
</bm:model>
