<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: weiwuzhen  
    $Date: 2016-5-9 上午11:18:16  
    $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 
       to_char(pbp.prj_bp_id) prj_bp_id,
       ce.enterprise_name,--名  称
       trim(to_char(ce.registered_capital,'999,999,999,990.99')) registered_capital,--注册资本
       ce.stockholding_ratio,--持股比例
       ce.main_product,--主导产品
       trim(to_char(ce.total_assets,'999,999,999,990.99')) total_assets,--资产总额
       ce.asset_liability_ratio,--资产负债率
       trim(to_char(ce.business_income,'999,999,999,990.99')) business_income,--营业收入
       trim(to_char(ce.net_profit,'999,999,999,990.99')) net_profit--净利润
  from prj_project_bp pbp, prj_bp_core_enterprise ce
 where pbp.prj_bp_id = ce.prj_bp_id
   and pbp.bp_category = 'GUARANTOR'
   --and PBP.bp_type = 'GUARANTOR'
   and pbp.project_id=${/parameter/@project_id}
   ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
