| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="NIH020010.select" desc=" 这里用板坯号和钢卷号做为联合主键，为了板坯在做回炉处理的时候状态的改变情况 " fetchSize="10">
- <![CDATA[
- select * from TBH02_REHEATFUR where slab_no = ? and COIL_NO = ?
- ]]>
- </query>
- <query id="NIH020010.update" desc="init " fetchSize="10">
- <![CDATA[
- update TBH02_REHEATFUR set
- DEVNO = ?
- ,RHF_STAT = '1'
- ,CHARING_DTIME = ?
- ,CHRGING_BEF_WGT = ?
- ,CHRGING_BEF_TEMP= ?
- ,ROW_NUM = ?
- ,CHRGING_WKSHIFT = ?
- ,CHRGING_WKGROUP = ?
- ,ROLL_MANA_NO = ?
- ,ROLL_SLAB_SEQ = ?
- ,MOD_ID = 'NIH020010'
- ,MOD_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
- where SLAB_NO = ? AND COIL_NO = ?
- ]]>
- </query>
- <query id="NIH020010.insert" desc="init " fetchSize="10">
- <![CDATA[
- insert into TBH02_REHEATFUR
- ( SLAB_NO
- ,COIL_NO
- ,DEVNO
- ,RHF_STAT
- ,CHARING_DTIME
- ,CHRGING_BEF_WGT
- ,CHRGING_BEF_TEMP
- ,ROW_NUM
- ,CHRGING_WKSHIFT
- ,CHRGING_WKGROUP
- ,ROLL_MANA_NO
- ,ROLL_SLAB_SEQ
- ,REG_ID
- ,REG_DTIME
- )
- VALUES
- ( ?
- ,?
- ,?
- ,'1'
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,?
- ,'NIH020010'
- ,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
- )
- ]]>
- </query>
- <query id="NIH020010_ROLLER.select" desc=" " fetchSize="10">
- <![CDATA[
- SELECT YARD_ADDR FROM TBG04_SLAB_YARD
- WHERE SLAB_NO = ?
- AND YARD_ADDR LIKE 'A%'
-
- ]]>
- </query>
- <query id="NIH020010_ROLLER.update" desc=" " fetchSize="10">
- <![CDATA[
- UPDATE TBG04_SLAB_YARD SET
- SLAB_NO = null
- ,CR_NO = null
- ,BEF_STORE_LOC = null
- ,ORD_FLAG = null
- , REG_ID = null
- ,REG_DTIME = null
- WHERE YARD_ADDR = ?
- ]]>
- </query>
- </queryMap>
|
