<?xml version="1.0" encoding="UTF-8"?><!-- $Author: WW $Date: 2014-11-13 下午5:36:09 $Revision: 1.0 $Purpose: --><bm:modelxmlns:bm="http://www.leaf-framework.org/schema/bm"><bm:operations><bm:operationname="query"><bm:query-sql><![CDATA[ SELECT t1.user_id, t1.user_name, t1.description FROM sys_user t1 #WHERE_CLAUSE# ]]></bm:query-sql></bm:operation></bm:operations><bm:fields><bm:fieldname="user_id"databaseType="NUMBER"datatype="java.lang.Long"forDisplay="false"forQuery="false"physicalName="USER_ID"prompt="HLS_BP_TYPE.USER_ID"/><bm:fieldname="user_name"databaseType="VARCHAR2"datatype="java.lang.String"forDisplay="true"forQuery="true"physicalName="USER_NAME"prompt="用户代码"/><bm:fieldname="description"databaseType="VARCHAR2"datatype="java.lang.String"forDisplay="true"forQuery="true"physicalName="DESCRIPTION"prompt="用户名"/></bm:fields><bm:query-fields><bm:query-fieldfield="user_name"queryOperator="like"/><bm:query-fieldfield="description"queryOperator="like"/><bm:query-fieldname="bp_type"queryExpression=" ${@bp_type} IS NOT NULL AND NOT EXISTS( SELECT 1 FROM HLS_BP_TYPE_ASSIGN BTA WHERE BTA.USER_ID=t1.USER_ID AND BTA.BP_TYPE=${@bp_type})"/></bm:query-fields></bm:model>