| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="NIH020060_CHANGE_ROLL.select" desc="" fetchSize="10">
- <![CDATA[
- SELECT ROLL_NO
- ,ROLLING_LEN
- --,ROLL_HOUR
- ,ROLLING_WGT
- ,ROLLING_TOT_LEN
- ,ROLLING_TOT_WGT,ROLLING_TOT_HOUR
- FROM TBH04_ROLL
- WHERE ROLL_NO IN(?,?)
- ]]>
- </query>
- <query id="NIH020060_DISMOUNT_ROLL.update" desc="" fetchSize="10">
- <![CDATA[
- UPDATE TBH04_ROLL SET
- ROLL_STAT = 'S'
- ,ROLL_STAT_DTIME = to_char(SYSDATE,'yyyymmddhh24miss')
- ,ROLL_BEF_STAT1 = ROLL_STAT
- ,ROLL_BEF_STAT_DTIME1 = ROLL_STAT_DTIME
- ,ROLL_BEF_STAT2 = ROLL_BEF_STAT1
- ,ROLL_BEF_STAT_DTIME2 = ROLL_BEF_STAT_DTIME1
- ,ROLL_BEF_STAT3 = ROLL_BEF_STAT2
- ,ROLL_BEF_STAT_DTIME3 = ROLL_BEF_STAT_DTIME2
- --,CHANG_DTIME = to_char(SYSDATE,'yyyymmddhh24miss')
- --,USE_DTIME = to_char(SYSDATE,'yyyymmddhh24miss')
- ,ROLLING_LEN = ?
- ,ROLLING_WGT = ?
- ,ROLLING_HOUR = ?
- ,ROLLING_TOT_LEN = ?
- ,ROLLING_TOT_WGT = ?
- ,ROLLING_TOT_HOUR = ?
- ,CHANG_DTIME = ?
- --,TOP_BOT_CLF = ''
- ,ASSEM_ROLL = ''
- WHERE ROLL_NO = ?
- ]]>
- </query>
- <query id="NIH020060_MOUNT_ROLL.update" desc="" fetchSize="10">
- <![CDATA[
- UPDATE TBH04_ROLL SET
- ROLL_STAT = 'U'
- ,ROLL_STAT_DTIME = to_char(SYSDATE,'yyyymmddhh24miss')
- ,ROLL_BEF_STAT1 = ROLL_STAT
- ,ROLL_BEF_STAT_DTIME1 = ROLL_STAT_DTIME
- ,ROLL_BEF_STAT2 = ROLL_BEF_STAT1
- ,ROLL_BEF_STAT_DTIME2 = ROLL_BEF_STAT_DTIME1
- ,ROLL_BEF_STAT3 = ROLL_BEF_STAT2
- ,ROLL_BEF_STAT_DTIME3 = ROLL_BEF_STAT_DTIME2
- ,STAND_NO = ?
- ,TOP_BOT_CLF = ?
- ,ASSEM_ROLL = ?
- ,USE_DTIME = ?
- WHERE ROLL_NO = ?
- ]]>
- </query>
-
- </queryMap>
|
