<?xml version="1.0" encoding="UTF-8"?> <!-- $Author: hand $Date: 2016-5-17 下午3:56:18 $Revision: 1.0 $Purpose: --> <bm:model xmlns:f="leaf.database.features" xmlns:bm="http://www.leaf-framework.org/schema/bm"> <bm:operations> <bm:operation name="update"> <bm:update-sql><![CDATA[ BEGIN IF ${@storage_flag}='Y' THEN UPDATE con_contract_location c SET c.storage_flag='N' WHERE c.location_id=${@location_id}; ELSE UPDATE con_contract_location c SET c.storage_flag='Y' WHERE c.location_id=${@location_id}; END IF; END; ]]></bm:update-sql> </bm:operation> <bm:operation name="execute"> <bm:update-sql><![CDATA[ BEGIN UPDATE con_contract_location c SET c.express_out_flag='Y', c.express_out_time=sysdate WHERE c.location_id=${@location_id}; END; ]]></bm:update-sql> </bm:operation> </bm:operations> </bm:model>