1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
<?xml version="1.0" encoding="UTF-8"?>
<!--
$Author: DJ
$Date: 2013-6-18 下午3:23:38
$Revision: 1.0
$Purpose:
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features" alias="t1" baseTable="HLS_DOC_LAYOUT" defaultOrderBy="t1.enabled_flag desc,t1.order_seq">
<bm:fields>
<bm:field name="layout_code" databaseType="VARCHAR2" datatype="java.lang.String" displayWidth="170" forDisplay="true" forQuery="true" physicalName="LAYOUT_CODE" prompt="HLS030.HLS_DOC_LAYOUT.LAYOUT_CODE"/>
<bm:field name="description" databaseType="VARCHAR2" datatype="java.lang.String" displayWidth="200" forDisplay="true" forQuery="true" physicalName="DESCRIPTION" prompt="HLS.DESCRIPTION"/>
<bm:field name="enabled_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ENABLED_FLAG" prompt="HLS.ENABLED_FLAG"/>
<bm:field name="width" databaseType="NUMBER" datatype="java.lang.Long" physicalName="WIDTH" prompt="HLS.WIDTH"/>
<bm:field name="height" databaseType="NUMBER" datatype="java.lang.Long" physicalName="HEIGHT" prompt="HLS.HEIGHT"/>
<bm:field name="order_seq" databaseType="NUMBER" datatype="java.lang.Long" physicalName="ORDER_SEQ" prompt="HLS.ORDER_SEQ"/>
<bm:field name="document_category" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DOCUMENT_CATEGORY"/>
<bm:field name="document_category_desc" displayWidth="150" expression="(select decode(t1.document_category,'GENERAL','通用','BP','商业伙伴','MORTGAGE','抵/质押物','LEASE_ITEM','租赁物',(SELECT C.DESCRIPTION FROM HLS_DOCUMENT_CATEGORY C WHERE C.DOCUMENT_CATEGORY=T1.DOCUMENT_CATEGORY)) from dual)" forDisplay="true" forInsert="false" forUpdate="false" prompt="HLS.DOCUMENT_CATEGORY"/>
</bm:fields>
<bm:operations>
<bm:operation name="execute">
<bm:update-sql><![CDATA[
begin
hls030_save_pkg.layout_copy(p_from => ${@from},
p_to => ${@to},
p_to_desc => ${@to_desc},
p_user_id => ${/session/@user_id});
end;
]]></bm:update-sql>
</bm:operation>
</bm:operations>
<bm:query-fields>
<bm:query-field field="layout_code" queryOperator="="/>
<bm:query-field name="layout_code_ref" queryExpression="t1.layout_code like ${@layout_code_ref}"/>
<bm:query-field field="document_category" queryOperator="like"/>
<bm:query-field name="enabled_flag" queryExpression="(t1.enabled_flag=${@enabled_flag} or ${@enabled_flag}='ALL')"/>
<bm:query-field field="description" queryOperator="like"/>
</bm:query-fields>
<bm:features>
<f:standard-who/>
</bm:features>
<bm:primary-key>
<bm:pk-field name="layout_code"/>
</bm:primary-key>
</bm:model>