je_template_query.lwm

<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: luochenglong
    $Date: 2023-02-07 下午3:03:31
    $Revision: 1.0
    $Purpose: 凭证模板bm
-->
<bm:model xmlns:f="leaf.database.features" xmlns:bm="http://www.leaf-framework.org/schema/bm" alias="t1" baseTable="E_ARCHIVES_DEFINE_JE" defaultOrderBy="je_template_code">
    <bm:fields>
        <bm:field name="base_archive_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BASE_ARCHIVE_ID" />
        <bm:field name="je_id" databaseType="NUMBER" datatype="java.lang.String" physicalName="JE_ID" />
        <bm:field name="je_template_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="JE_TEMPLATE_CODE" />
        <bm:field name="je_template_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="JE_TEMPLATE_NAME" />
    </bm:fields>
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
    			select t1.base_archive_id,
    				   t1.je_id,
				       t1.je_template_code,
				       t1.je_template_name
				  from E_ARCHIVES_DEFINE_JE t1
				  #WHERE_CLAUSE#
    		]]></bm:query-sql>
        </bm:operation>
        <bm:operation name="insert">
            <bm:update-sql><![CDATA[
    		 	begin
   				 elec_wfl_pkg.je_template_update(
   				   								p_sql_type              =>'INSERT',
                                                p_je_id                 => ${@je_id},
                                                p_base_archive_id       => ${@base_archive_id},
                                                p_je_template_code      => ${@je_template_code},
                                                p_je_template_name      => ${@je_template_name},
                                                p_user_id               => ${/session/@user_id});

   			   end;
    		 ]]></bm:update-sql>
        </bm:operation>
        <bm:operation name="update">
            <bm:update-sql><![CDATA[
    		 	begin
   				   elec_wfl_pkg.je_template_update(
   				   								p_sql_type              =>'UPDATE',
                                                p_je_id                 => ${@je_id},
                                                p_base_archive_id       => ${@base_archive_id},
                                                p_je_template_code      => ${@je_template_code},
                                                p_je_template_name      => ${@je_template_name},
                                                p_user_id               => ${/session/@user_id});
   			   end;
    		 ]]></bm:update-sql>
        </bm:operation>
        <bm:operation name="delete">
            <bm:update-sql><![CDATA[
    		 	begin
   				    elec_wfl_pkg.je_template_delete(
                                                p_je_id               => ${@je_id},
                                                p_user_id             => ${/session/@user_id});
   			   end;
    		 ]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
    <bm:data-filters>
        <bm:data-filter name="base_archive_id" enforceOperations="query" expression="base_archive_id=${@base_archive_id}"/>
    </bm:data-filters>
</bm:model>