cloumn_code_query.lwm 3.05 KB
<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: trd
    $Date: 2023-2-7 下午2:36:27
    $Revision: 1.0
    $Purpose:
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features" alias="t1" baseTable="E_ARCHIVES_DEFINE_DATA" defaultOrderBy="cloumn_code">
    <bm:fields>
        <bm:field name="base_archive_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BASE_ARCHIVE_ID" />
        <bm:field name="sture_data_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="STURE_DATA_ID" />
        <bm:field name="cloumn_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CLOUMN_CODE" />
        <bm:field name="cloumn_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CLOUMN_NAME" />
    </bm:fields>
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
    			select t1.base_archive_id,
    				   t1.sture_data_id,
				       t1.cloumn_code,
				       t1.cloumn_name
				  from E_ARCHIVES_DEFINE_DATA t1
				  #WHERE_CLAUSE#
    		]]></bm:query-sql>
        </bm:operation>
        <bm:operation name="insert">
            <bm:update-sql><![CDATA[
    		 	begin
   				   elec_wfl_pkg.cloumn_code_update(
   				   								p_sql_type           =>'INSERT',
                                                p_sture_data_id      => ${@sture_data_id},
                                                p_base_archive_id    => ${@base_archive_id},
                                                p_cloumn_code        => ${@cloumn_code},
                                                p_cloumn_name        => ${@cloumn_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.cloumn_code_update(
   				   								p_sql_type            =>'UPDATE',
                                                p_sture_data_id     => ${@sture_data_id},
                                                p_base_archive_id   => ${@base_archive_id},
                                                p_cloumn_code        => ${@cloumn_code},
                                                p_cloumn_name        => ${@cloumn_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.cloumn_code_delete(
                                                p_sture_data_id       => ${@sture_data_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>