XinYu_RZMES/.svn/pristine/34/3435e5615d4948157a0ad61a75b9b415abf16592.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH010030_01.select" desc="查询存在的厚度组" fetchSize="10">
		<![CDATA[
			SELECT A.THK_MIN,
				   A.THK_MIN_LABEL,
				   A.THK_MAX,
				   A.THK_MAX_LABEL,
				   A.REG_ID,
				   A.REG_TIME,
				   A.MOD_ID,
				   A.MOD_TIME,
				   A.STL_GRD,
				   '' CHK,
			       THK_TGT    
				    FROM TBH01_THK_STD A WHERE A.STL_GRD like ?||'%'
				    ORDER BY A.STL_GRD,A.THK_MIN
		]]>
	</query>
	<query id="UIH010030_02.select" desc="" fetchSize="10">
		<![CDATA[
			SELECT THK_TGT
				    FROM TBH01_THK_STD WHERE THK_TGT = ?
		]]>
	</query>
	<query id="UIH010030_01.update" desc="init " fetchSize="10">
		<![CDATA[
			update TBH01_THK_STD set
                      STL_GRD = ?  
			          ,THK_MIN  = ? 
					  ,THK_MIN_LABEL  = ? 
					  ,THK_MAX  = ? 
					  ,THK_MAX_LABEL  = ? 
					  ,MOD_ID  = ? 
					  ,MOD_TIME  = TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD')   
          where       THK_TGT = ?
         
		]]>
	</query>
	<query id="UIH010030_01.insert" desc="init " fetchSize="10">
		<![CDATA[
			insert into TBH01_THK_STD (
                       THK_TGT 
					  ,STL_GRD 
                      ,THK_MIN
			          ,THK_MIN_LABEL
                      ,THK_MAX
					  ,THK_MAX_LABEL
					  ,REG_ID
					  ,REG_time
					  )
                      values(
                      (SELECT 'MT'||(nvl(max(to_number(substr(t1.THK_TGT,3,4))),0) + 1)   FROM    TBH01_THK_STD  t1)
            		   
                      ,?,?,?,?,?,?,TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD'))
		]]>
	</query>
	<query id="UIH010030_01.delete" desc="" fetchSize="10">
		<![CDATA[
			delete  tbh01_thk_std where THK_TGT = ? 
		]]>
	</query>
</queryMap>