<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: weiwuzhen  
    $Date: 2016-5-5 下午3:54:18  
    $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 ppg.project_id,
        ppg.project_number,
        ppg.division,
        PPG.lease_item_seq, --序号
        ppg.full_name, --设备名称
        ppg.pattern, --规格型号
        ppg.vender_name, --生产厂商
        ppg.quantity, --数量(批/套)
        to_char(ppg.lease_transfer_price,'999,999,999,990.99') lease_transfer_price, --购买金额(元)
        ppg.reasonable_deprecition_years,--可使用年限
        ppg.guarantee_period_year,--剩余使用年限
       -- ppg.lease_transfer_price,--投放前租赁物账面净值(元)
        ppg.description --备注
   from prj_project_lease_item_g_lv ppg,prj_project pj
   where ppg.project_id=pj.project_id 
    and  pj.data_class='NORMAL'
    AND  ppg.project_id=${/parameter/@project_id}
    ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
