XinYu_RZMES/.svn/pristine/df/df00159f68859feda450fc5e98b8a5864d3e83ea.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="Excel 模板操作">

	<query id="Template.Select" desc="" fetchSize="10">
		<![CDATA[
			SELECT
				TMPL_NM,
				NVL2(TMPL_CONTENT, 'Y', 'N') TMPL,
				DATA_ROW,
				PAGE_SIZE,
				JAVA_CLASS
			FROM TBZ01_DOC_TMPL
		]]>
	</query> 
	<query id="Template.Select.Content" desc="" fetchSize="10">
		<![CDATA[
			SELECT TMPL_CONTENT BLOBFILE
			FROM TBZ01_DOC_TMPL
			WHERE TMPL_NM = ?
		]]>
	</query> 
	<query id="Template.Select.Doc" desc="">
		<![CDATA[
			SELECT
				NVL(DATA_ROW, 0) DATA_ROW,
				NVL(PAGE_SIZE, 25) PAGE_SIZE,
				TMPL_CONTENT,
				NVL(JAVA_CLASS, 'xin.glue.ui.common.blob.PosExcelCommon') JAVA_CLASS
			FROM TBZ01_DOC_TMPL
			WHERE TMPL_NM = ?
		]]>
	</query> 

	<query id="Template.Update" desc="">
		<![CDATA[
			UPDATE TBZ01_DOC_TMPL SET
				DATA_ROW = ?,
				PAGE_SIZE = ?,
				JAVA_CLASS = ?
			WHERE TMPL_NM = ?
		]]>
	</query>
	<query id="Template.Update.Doc" desc="">
		<![CDATA[
			UPDATE TBZ01_DOC_TMPL SET
				TMPL_CONTENT = ?
			WHERE TMPL_NM = ?
		]]>
	</query>
	<query id="Template.Delete" desc="">
		<![CDATA[
			DELETE FROM TBZ01_DOC_TMPL
			WHERE TMPL_NM = ?
		]]>
	</query>    
	<query id="Template.Insert" desc="">
		<![CDATA[
			INSERT INTO TBZ01_DOC_TMPL
			( TMPL_NM, DATA_ROW, PAGE_SIZE, JAVA_CLASS )
			VALUES( ?, ?, ?, ? )
        ]]>
    </query>
    
</queryMap>