XinYu_RZMES/.svn/pristine/57/57e65b2709116f9e99f42b49e4a45e400a60ba82.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="炼钢交接班">
  
	<query id="UIB030207_01.SELECT" desc="">
		SELECT    T.WK_CTX  , T.REG_ID , T.REG_DTIME ,T.MOD_ID , T.MOD_DTIME  
		FROM      TBB02_WORK_PRBM   T  
		WHERE     T.REG_DTIME BETWEEN  ?  AND ?
		ORDER BY  T.REG_DTIME  , T.MOD_DTIME
	</query>
	
	<query id="UIB030207_01.INSERT">
		INSERT  INTO  TBB02_WORK_PRBM (WK_CTX ,REG_ID ,REG_DTIME )  VALUES(? ,? ,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS') )
	</query>
	
	<query id="UIB030207_01.UPDATE">
	<![CDATA[
		UPDATE      TBB02_WORK_PRBM      T
		SET         T.WK_CTX             =    ?
		           ,T.MOD_ID             =    ?
		           ,T.MOD_DTIME          =    TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS') 
		WHERE       T.REG_DTIME          =    ?    
		AND         SYSDATE - TO_DATE(NVL(T.MOD_DTIME , T.REG_DTIME) , 'YYYYMMDDHH24MISS') <= 1
		 ]]>   
	</query>
</queryMap>