<?xml version="1.0" encoding="UTF-8"?> <!-- $Author: shenyamin $Date: 2018-11_03 上午11:00:06 $Revision: 3.0 $Purpose: --> <bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false"> <bm:operations> <bm:operation name="query"> <bm:query-sql><![CDATA[ SELECT COUNT(1) v_count FROM (SELECT p.project_id FROM prj_project p, prj_project_lease_item v WHERE p.project_id = v.project_id AND (v.machine_number_70 = ${@machine_number} or v.machine_number = ${@machine_number}) AND p.project_status <> 'CLOSED' AND nvl(p.secondary_lease, 'NO') = 'NO' and p.project_id <> nvl(${@project_id},1) UNION SELECT c.project_id FROM con_contract c, con_contract_lease_item h WHERE c.contract_id = h.contract_id AND (h.machine_number_70 = ${@machine_number} or h.machine_number = ${@machine_number}) AND c.contract_status <> 'CANCEL' AND nvl(c.secondary_lease, 'NO') = 'NO' AND c.data_class = 'NORMAL' and c.project_id != nvl(${@project_id},1)) ]]> </bm:query-sql> </bm:operation> <bm:operation name="update"> <bm:update-sql><![CDATA[ begin prj_project_pkg.project_submit( p_project_id =>${@project_id}, p_user_id => ${/session/@user_id} ); end; ]]></bm:update-sql> </bm:operation> <bm:operation name="execute"> <bm:update-sql><![CDATA[ begin prj_project_check_pkg.check_prj_lease_item( p_project_id =>${@project_id}, p_machine_number =>${@machine_number}, p_user_id => ${/session/@user_id} ); end; ]]></bm:update-sql> </bm:operation> </bm:operations> <bm:fields> <bm:field name="v_count" databaseType="NUMBER" datatype="java.lang.Long" physicalName="v_count"/> </bm:fields> </bm:model>