<?xml version="1.0" encoding="UTF-8"?><!-- $Author: hand $Date: 2016-5-2 上午11:46:02 $Revision: 1.0 $Purpose: --><bm:modelxmlns:f="leaf.database.features"xmlns:bm="http://www.leaf-framework.org/schema/bm"alias="t1"baseTable="CON_CONTRACT_LOCATION"><bm:fields><bm:fieldname="location_id"databaseType="NUMBER"datatype="java.lang.Long"physicalName="LOCATION_ID"prompt="CON_CONTRACT_LOCATION.LOCATION_ID"/><bm:fieldname="chest_number"databaseType="VARCHAR2"datatype="java.lang.String"displayWidth="80"forDisplay="true"forQuery="true"physicalName="CHEST_NUMBER"prompt="箱号"/><bm:fieldname="years"databasetype="VARCHAR2"datatype="java.lang.String"displayWidth="80"forDisplay="true"forQuery="true"isprimarykey="true"physicalname="YEARS"prompt="年限"/><bm:fieldname="doc_type_n"databaseType="VARCHAR2"datatype="java.lang.String"displayWidth="80"expression="(SELECT v.code_value_name AS value_name FROM sys_code_values_v v WHERE v.code = 'DOC_TYPE' AND v.code_value=t1.doc_type)"forDisplay="true"forInsert="false"forUpdate="false"physicalName="DOC_TYPE_N"prompt="文件类型"/><bm:fieldname="docu_amount_n"databaseType="VARCHAR2"datatype="java.lang.String"displayWidth="80"expression="(select count(*) from con_contract_location_ln ccll where ccll.LOCATION_ID=t1.LOCATION_ID)"forDisplay="true"forInsert="false"forUpdate="false"prompt="已存文件数量"/><bm:fieldname="storage"databaseType="VARCHAR2"datatype="java.lang.String"physicalName="STORAGE"prompt="仓库"/><bm:fieldname="chest_floors"databaseType="NUMBER"datatype="java.lang.Long"physicalName="CHEST_FLOORS"prompt="CON_CONTRACT_LOCATION.CHEST_FLOORS"/><bm:fieldname="docu_number"databaseType="VARCHAR2"datatype="java.lang.String"physicalName="DOCU_NUMBER"prompt="CON_CONTRACT_LOCATION.DOCU_NUMBER"/><bm:fieldname="docu_amount"databaseType="NUMBER"datatype="java.lang.Long"physicalName="DOCU_AMOUNT"prompt="CON_CONTRACT_LOCATION.DOCU_AMOUNT"/><bm:fieldname="note"databaseType="VARCHAR2"datatype="java.lang.String"physicalName="NOTE"prompt="CON_CONTRACT_LOCATION.NOTE"/><bm:fieldname="doc_type"databaseType="VARCHAR2"datatype="java.lang.String"physicalName="DOC_TYPE"prompt="CON_CONTRACT_LOCATION.DOC_TYPE"/><bm:fieldname="storage_flag"databaseType="VARCHAR2"datatype="java.lang.String"physicalName="STORAGE_FLAG"prompt="CON_CONTRACT_LOCATION.STORAGE_FLAG"/><bm:fieldname="created_person"expression="( select su.description value_name from sys_user su where su.user_id = t1.created_by)"forDisplay="true"forInsert="false"forUpdate="false"prompt="创建人"/></bm:fields><bm:features><f:standard-who/></bm:features><bm:primary-key><bm:pk-fieldname="location_id"/></bm:primary-key><bm:data-filters><bm:data-filtername="storage_flag"expression="t1.storage_flag='N'"/></bm:data-filters><bm:query-fields><bm:query-fieldname="doc_type"queryExpression="t1.doc_type=${/parameter/@doc_type}"/><bm:query-fieldname="years"queryExpression="(t1.years=${@years} or t1.years='OTHER')"/></bm:query-fields></bm:model>