XinYu_RZMES/.svn/pristine/2c/2cf7e755d150a7d7f1035368dab7dc5244c6efc8.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH090130_01.select" desc="  " fetchSize="10">
		<![CDATA[
			SELECT '' CHK
            ,A.SEQ_NO
          ,A.SECTION
          ,A.CRASH
          ,A.EFFECTIVE
          ,A.TIME
          ,A.FB_TIME
          ,A.INFO
          ,A.REG
          ,A.REG_DTIME 
          FROM TBH01_IMPORT_INFO A WHERE A.FB_TIME >= :1 and A.FB_TIME <= :2
		]]>
	</query>
	<query id="UIH090130_01.insert" desc="  " fetchSize="10">
		<![CDATA[
			INSERT INTO TBH01_IMPORT_INFO A 
            (
                SEQ_NO
               ,SECTION
               ,CRASH
               ,EFFECTIVE
               ,TIME
               ,FB_TIME
               ,INFO
               ,REG
               ,REG_DTIME
            )VALUES(tbh01_import_info_seq.nextval
                    ,?
                    ,?
                    ,?
                    ,?
                    ,TO_CHAR(SYSDATE,'YYYYMMDD')
                    ,?
                    ,?
                    ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
            )
		]]>
	</query>
	<query id="UIH090130_01.update" desc="  " fetchSize="10">
		<![CDATA[
			update TBH01_IMPORT_INFO set
                   EFFECTIVE   = :1         
                where SEQ_NO = :2 and FB_TIME = :3
		]]>
	</query>
</queryMap>