XinYu_RZMES/.svn/pristine/a2/a29fe8c2d6a20abf1c27d9fe49809b885ca28ff7.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="公用代码录入">

	<query id="UIZ010010.Master.Select" desc="" fetchSize="10">
		<![CDATA[
			SELECT DISTINCT
				LG_CD,
				LG_NM,
				'' AS CD_DESC,
				CD_LEN,
				'false' CHK		-- 删除标志
			FROM TBZ00_COMMCD
			WHERE LG_CD LIKE ?||'%'
			  AND BIZ_CLF LIKE ?||'%'
			ORDER BY LG_CD
		]]>
	</query> 
	<query id="UIZ010010.Detail.Select" desc="" fetchSize="10">
		<![CDATA[
			SELECT
				LG_CD,
				SM_CD,
				SM_CFNM,
				CD_SEQ,
				SM_EFNM,
				MOD_ID,
				MOD_DATE,
				'false' CHK,	-- 删除标志
				USED_YN,
				CD_DESC
			FROM TBZ00_COMMCD
			WHERE LG_CD = ?
			ORDER BY LG_CD, CD_SEQ
		]]>
	</query> 
	<query id="UIZ010010.List.Select" desc="" fetchSize="10">
		<![CDATA[
			SELECT '' SM_CD, '全部' SM_CFNM FROM DUAL
			UNION ALL
			SELECT * FROM (
				SELECT SM_CD, SM_CFNM FROM TBZ00_COMMCD
				WHERE LG_CD = 'Z01002'
				ORDER BY CD_SEQ)
		]]>
	</query>
	<query id="UIZ010010.getCDNM.Select" desc="根据订单用途名称来查是否存在" fetchSize="10">
		<![CDATA[
			SELECT  *  FROM TBZ00_COMMCD  WHERE LG_CD = 'A01007' and SM_CFNM = ?
		]]>
	</query>  

	<query id="UIZ010010.Master.Update" desc="" fetchSize="10">
		<![CDATA[
			UPDATE TBZ00_COMMCD SET
				LG_NM = ?,
				CD_LEN = ?,
				BIZ_CLF = SUBSTR(?, 1, 3)
			WHERE LG_CD = ?
		]]>
	</query> 
	<query id="UIZ010010.Detail.Update" desc="" fetchSize="10">
		<![CDATA[
			UPDATE TBZ00_COMMCD SET
				SM_CFNM = ?,
				CD_SEQ = ?,
				SM_EFNM = ?,
				MOD_ID = ?,
				MOD_DATE = TO_CHAR(SYSTIMESTAMP, 'YYYYMMDDHH24MISS'),
				CD_DESC = ?,
				USED_YN = NVL(?, 'Y')
			WHERE LG_CD = ?
			  AND SM_CD = ?
		]]>
	</query>

	<query id="UIZ010010.Master.Insert" desc="" fetchSize="10">
		<![CDATA[
			INSERT INTO TBZ00_COMMCD( LG_CD, BIZ_CLF, LG_NM, CD_LEN, SM_CD )
			VALUES( ?, SUBSTR(?, 1, 3), ?, ?, 'A' )
		]]>
	</query> 
	<query id="UIZ010010.Detail.Insert" desc="" fetchSize="10">
		<![CDATA[
			INSERT INTO TBZ00_COMMCD( LG_CD, LG_NM, BIZ_CLF, SM_CD, SM_CFNM, CD_SEQ, SM_EFNM, MOD_ID, MOD_DATE, CD_DESC, USED_YN )
			VALUES( ?, ?, SUBSTR(?, 1, 3), ?, ?, ?, ?, ?, TO_CHAR(SYSTIMESTAMP, 'yyyymmdd'), ?, NVL(?, 'Y') )
		]]>
	</query> 

	<query id="UIZ010010.Master.Delete" desc="" fetchSize="10">
		<![CDATA[
			DELETE FROM TBZ00_COMMCD WHERE LG_CD = ?
		]]>
	</query> 
 	<query id="UIZ010010.Detail.Delete" desc="" fetchSize="10">
		<![CDATA[
			DELETE FROM TBZ00_COMMCD WHERE LG_CD = ? AND SM_CD = ?
		]]>
	</query> 
    
</queryMap>