XinYu_RZMES/.svn/pristine/e6/e6a5029880646eb36743cf2d3c95040621891139.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH060020_SHIFT.select" desc="" fetchSize="10">
		<![CDATA[
			SELECT  GR_DD,GR_SHIFT,GR_GROUP_CD
			FROM    TBG02_SHIFT_GROUP 
			WHERE   GR_YYYYMM = ?
			AND     PROC_CD = ? 
		]]>
	</query> 
	<query id="UIH060020_01.select" desc=" 获取班次时间 " fetchSize="10">
		<![CDATA[
			select A.SM_EFNM,A.SM_ESNM from tbz00_commcd a where a.LG_CD = 'H07001' and a.SM_CD = '1'
		]]>
	</query> 
	<query id="UIH060020_02.select" desc=" 获取班次时间 " fetchSize="10">
		<![CDATA[
			select A.SM_EFNM,A.SM_ESNM,A.SHRXM from tbz00_commcd a where a.LG_CD = 'H07001' and a.SM_CD = '2'
		]]>
	</query>
	<query id="UIH060020_03.select" desc=" 获取班次时间 " fetchSize="10">
		<![CDATA[
			select A.SM_EFNM,A.SM_ESNM from tbz00_commcd a where a.LG_CD = 'H07001' and a.SM_CD = '3'
		]]>
	</query> 
	<query id="UIH060020_shift.insert" desc="" fetchSize="10">
		<![CDATA[
		INSERT INTO TBG02_SHIFT_GROUP 
            		( GR_GROUP_CD
					  ,PROC_CD
					  ,GR_YYYYMM
					  ,GR_DD
					  ,GR_SHIFT
					  
					)
		VALUES      (?,?,?,?,?)
		]]>
	</query>
	<query id="UIH060020_shift.update" desc="" fetchSize="10">
		<![CDATA[
			UPDATE TBG02_SHIFT_GROUP 
			SET           GR_GROUP_CD = ?
			WHERE         PROC_CD = ?
			AND           GR_YYYYMM = ?
			AND           GR_DD = ?
			AND           GR_SHIFT = ?    
		]]>
	</query> 
	<query id="UIH060020_01.update" desc="这里用于更新早班的时间" fetchSize="10">
		<![CDATA[
			      UPDATE  TBZ00_COMMCD T SET 
              T.SM_EFNM = :1,
              T.SM_ESNM = :2,
              T.MOD_ID  = :3,
              T.MOD_DATE = TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD')
              WHERE T.LG_CD = 'H07001' AND T.SM_CD = '1'
		]]>
	</query> 
	<query id="UIH060020_02.update" desc="这里用于更新中班的时间" fetchSize="10">
		<![CDATA[
            UPDATE  TBZ00_COMMCD T SET 
              T.SM_EFNM = :1,
              T.SM_ESNM = :2,
              T.MOD_ID  = :3,
              T.SHRXM   = :4,
              T.MOD_DATE = TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD')
              WHERE T.LG_CD = 'H07001' AND T.SM_CD = '2'
		]]>
	</query>
	<query id="UIH060020_03.update" desc="这里用于更新晚班的时间" fetchSize="10">
		<![CDATA[
			      UPDATE  TBZ00_COMMCD T SET 
              T.SM_EFNM = :1,
              T.SM_ESNM = :2,
              T.MOD_ID  = :3,
              T.MOD_DATE = TO_CHAR(SYSDATE,'YYYYMMDDHH24MIDD')
              WHERE T.LG_CD = 'H07001' AND T.SM_CD = '3'
		]]>
	</query> 
</queryMap>