| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIG010020.INIT_PARAM" desc="" fetchSize="10">
- <![CDATA[
- /* 查询牌号 从操作标准表 TBG01_OPRN_STD */
- select STL_GRD LABEL,STL_GRD VALUE from TBG01_OPRN_STD
- ]]>
- </query>
- <query id="UIG010020_01.select" desc="" fetchSize="10">
- <![CDATA[
-
- SELECT '' CHK
- , B.FAC_STL_GRD AS STL_GRD
- , A.CCM_SPEED_MIN
- , A.CCM_SPEED_MAX
- , A.CCM_SPEED_AVG
- , A.LT_ARRV_TEMP
- , A.SOLIDE_TEMP1
- , A.SOLIDE_TEMP2
- , A.TD_TEMP_MIN
- , A.TD_TEMP_MAX
- , A.TD_TEMP_AVG
- , A.MD1_WTH_MIN
- , A.MD2_WTH_MIN
- , A.MD1_WTH_MAX
- , A.MD2_WTH_MAX
- , A.COOL_WATER
- , A.MD1_OSCILL_CNT
- , A.MD1_OSCILL_WTH
- , A.MD2_OSCILL_CNT
- , A.MD2_OSCILL_WTH
- FROM (SELECT * FROM TBD00_STLGRD WHERE FAC_STL_GRD LIKE ?||'%') B
- , TBG01_OPRN_STD A
- WHERE B.FAC_STL_GRD = A.STL_GRD(+)
- ]]>
- </query>
- <query id="UIG010020_01.update" desc="" fetchSize="10">
- <![CDATA[
- update TBG01_OPRN_STD set
- CCM_SPEED_MIN = ?
- ,CCM_SPEED_MAX = ?
- ,CCM_SPEED_AVG = ?
- ,LT_ARRV_TEMP = ?
- ,SOLIDE_TEMP1 = ?
- ,SOLIDE_TEMP2 = ?
- ,TD_TEMP_MIN = ?
- ,TD_TEMP_MAX = ?
- ,TD_TEMP_AVG = ?
- ,MD1_WTH_MIN = ?
- ,MD1_WTH_MAX = ?
- ,MD2_WTH_MIN = ?
- ,MD2_WTH_MAX = ?
- ,COOL_WATER = ?
- ,MD1_OSCILL_CNT = ?
- ,MD1_OSCILL_WTH = ?
- ,MD2_OSCILL_CNT = ?
- ,MD2_OSCILL_WTH = ?
- where STL_GRD = ?
-
- ]]>
- </query>
- <query id="UIG010020_01.insert" desc="" fetchSize="10">
- <![CDATA[
- INSERT INTO
- TBG01_OPRN_STD
- (
- CCM_SPEED_MIN
- ,CCM_SPEED_MAX
- ,CCM_SPEED_AVG
- ,LT_ARRV_TEMP
- ,SOLIDE_TEMP1
- ,SOLIDE_TEMP2
- ,TD_TEMP_MIN
- ,TD_TEMP_MAX
- ,TD_TEMP_AVG
- ,MD1_WTH_MIN
- ,MD1_WTH_MAX
- ,MD2_WTH_MIN
- ,MD2_WTH_MAX
- ,COOL_WATER
- ,MD1_OSCILL_CNT
- ,MD1_OSCILL_WTH
- ,MD2_OSCILL_CNT
- ,MD2_OSCILL_WTH
- ,STL_GRD
- )
- VALUES
- (?,?,?,?,?,?,?,?,?,?,
- ?,?,?,?,?,?,?,?,? )
- ]]>
- </query>
- <query id="UIG010020_03.select" desc="" fetchSize="10">
- <![CDATA[
- /* 查询牌号 从操作标准表 TBG01_OPRN_STD */
- select STL_GRD from TBG01_OPRN_STD WHERE STL_GRD = ?
- ]]>
- </query>
- </queryMap>
|
