<?xml version="1.0" encoding="UTF-8"?> <bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false"> <bm:operations> <bm:operation name="query"> <bm:query-sql><![CDATA[SELECT l.direct_debit_bank_id, l.direct_debit_bank_id_n, l.withhold_way, l.withhold_way_n, l.ebank_city, l.ebank_city_n, l.ebank_province, l.ebank_province_n, l.dd_remark, l.dd_bank_branch_name, l.bp_id_tenant, l.bp_id_tenant_n, c.cell_phone, l.contract_id FROM con_contract_lv l, con_contract_bp c WHERE l.contract_id = c.contract_id and l.contract_id=${@contract_id}]]></bm:query-sql> </bm:operation> </bm:operations> <bm:fields> <bm:field name="direct_debit_bank_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="DIRECT_DEBIT_BANK_ID"/> <bm:field name="direct_debit_bank_id_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DIRECT_DEBIT_BANK_ID_N"/> <bm:field name="withhold_way" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WITHHOLD_WAY"/> <bm:field name="withhold_way_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WITHHOLD_WAY_N"/> <bm:field name="ebank_city" databaseType="NUMBER" datatype="java.lang.Long" physicalName="EBANK_CITY"/> <bm:field name="ebank_city_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EBANK_CITY_N"/> <bm:field name="ebank_province" databaseType="NUMBER" datatype="java.lang.Long" physicalName="EBANK_PROVINCE"/> <bm:field name="ebank_province_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EBANK_PROVINCE_N"/> <bm:field name="dd_remark" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DD_REMARK"/> <bm:field name="dd_bank_branch_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DD_BANK_BRANCH_NAME"/> <bm:field name="bp_id_tenant" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BP_ID_TENANT"/> <bm:field name="bp_id_tenant_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_ID_TENANT_N"/> <bm:field name="cell_phone" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CELL_PHONE"/> <bm:field name="contract_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONTRACT_ID" required="true"/> </bm:fields> </bm:model>