<?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 lower(eh.table_name) table_name, eh.sheet_seq, eh.multi_flag, eh.multi_line_from, eh.multi_line_to, lower(el.field_name) field_name, el.field_query, el.sheet_row, el.sheet_column, el.field_query, el.ln_id from hls_excel_templete et,hls_excel_templete_hd eh,hls_excel_templete_ln el where et.templete_id = eh.templete_id and eh.hd_id = el.hd_id and et.templete_code = ${@templete_code} order by eh.sheet_seq,eh.hd_id]]></bm:query-sql> <bm:parameters> <bm:parameter name="templete_code"/> </bm:parameters> </bm:operation> </bm:operations> </bm:model>