| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175 |
- <?xml version="1.0" encoding="UTF-8"?>
- <queryMap desc="设备维护">
- <query id="UIK040040_01.SELECT" desc="无时间查询">
- <![CDATA[
- SELECT T.MC_ID
- ,T.MC_NAME
- ,T.MC_MODEL
- ,T.MC_SPEC
- ,T.MC_STARTTIME
- ,T.MC_CHANGTIME
- ,T.MC_CHECKTIME
- ,T.AREA
- ,T.MC_UNIT
- ,T.MC_STAT
- ,T.REG_IN_ID
- ,T.MC_CHECKCYCLE
- ,T.MC_CHANGCYCLE
- ,T.REG_IN_DTIME
- ,NX_MC_CHECKTIME
- ,NX_MC_CHANGTIME
- ,T.MC_ID MC_ID_FLAG
- ,SU_MC_ID
- ,MAIN_MC_NAME
- FROM C_TBK03_MACHINE_ONLINE T
- WHERE nvl(MC_TYPE,'01') = '01'
- AND T.MC_ID LIKE '%'||?||'%'
- AND T.MC_NAME LIKE '%'||?||'%'
- ]]>
- </query>
-
- <query id="UIK040040_02.SELECT">
- SELECT T1.MC_ID
- ,T1.MC_NAME
- ,T1.SUB_MC_ID
- ,T1.SUB_MC_NAME
- ,T1.RH_BW
- ,T1.RH_DS
- ,T1.RH_HF
- ,T1.RH_YP_TYPE
- ,T1.RH_YP_VALUE
- ,T1.BY_ZQ
- ,T1.BYL
- ,T1.HDY_ZQ
- ,T1.HDYL
- ,T1.HDY_FZR
- ,T1.HDY_SJ
- ,T1.HDY_XC_SJ
- ,T1.BJY_FZR
- ,T1.BJY_SJ
- ,T1.BJY_XC_SJ
- ,T2.AREA
- ,T1.MC_ID MC_ID_FLAG
- ,SUB_MC_ID SUB_MC_ID_FLAG
- FROM C_TBK03_MACHINE_DETAIL1 T1
- ,C_TBK03_MACHINE_ONLINE T2
- WHERE T1.MC_ID = T2.MC_ID
- AND T2.MC_TYPE = '02'
- AND T1.MC_ID = ?
- </query>
-
-
- <query id="UIK040040_03.SELECT">
- SELECT T1.MC_ID
- ,T1.MC_NAME
- ,T1.SUB_MC_ID
- ,T1.SUB_MC_NAME
- ,T1.WH_BW
- ,T1.WH_NR
- ,T1.BZ
- ,T1.WH_SJ
- ,T1.XC_WH_SJ
- ,T1.WH_REN
- ,T1.WH_ZQ
- ,T1.MC_ID MC_ID_FLAG
- ,T1.SUB_MC_ID SUB_MC_ID_FLAG
- ,T1.AREA
- FROM C_TBK03_MACHINE_DETAIL2 T1
- ,C_TBK03_MACHINE_ONLINE T2
- WHERE T1.MC_ID = T2.MC_ID
- AND T2.MC_TYPE = '03'
- AND T1.MC_ID LIKE '%'||?||'%'
- AND T1.MC_NAME LIKE '%'||?||'%'
- </query>
-
- <query id="UIK040040_04.SELECT">
- SELECT T2.MC_ID
- ,T2.MC_NAME
- ,T2.AREA
- ,T2.ZJ_RH_DS1
- ,T2.ZJ_RH_DS2
- ,T2.ZJ_RH_DS3
- ,T2.ND_HYL1
- ,T2.ND_HYL2
- ,T2.ND_HYL3
- ,T2.MC_ID MC_ID_FLAG
- FROM C_TBK03_MACHINE_ONLINE T2
- WHERE T2.MC_TYPE = '02'
- AND T2.MC_ID LIKE '%'||?||'%'
- AND T2.MC_NAME LIKE '%'||?||'%'
- </query>
-
- <query id="UIK040040_01.INSERT" desc="无时间查询">
- <![CDATA[
- INSERT
- INTO C_TBK03_MACHINE_ONLINE
- (MC_ID
- ,MC_NAME
- ,MC_MODEL
- ,MC_SPEC
- ,MC_STARTTIME
- ,MC_CHANGTIME
- ,MC_CHECKTIME
- ,AREA
- ,MC_UNIT
- ,MC_STAT
- ,REG_IN_ID
- ,MC_CHECKCYCLE
- ,MC_CHANGCYCLE
- ,REG_IN_DTIME
- ,NX_MC_CHECKTIME
- ,NX_MC_CHANGTIME
- ,MC_TYPE
- ,SU_MC_ID
- ,MAIN_MC_NAME
- )
- VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS'),?,?,'01',?,?)
- ]]>
- </query>
-
- <query id="UIK040040_01.UPDATE">
- UPDATE C_TBK03_MACHINE_ONLINE
- SET MC_NAME = ?
- ,MC_MODEL = ?
- ,MC_SPEC = ?
- ,MC_STARTTIME = ?
- ,MC_CHANGTIME = ?
- ,MC_CHECKTIME = ?
- ,AREA = ?
- ,MC_UNIT = ?
- ,MC_STAT = ?
- ,REG_IN_ID = ?
- ,MC_CHECKCYCLE = ?
- ,MC_CHANGCYCLE = ?
- ,NX_MC_CHECKTIME= ?
- ,NX_MC_CHANGTIME= ?
- ,SU_MC_ID = ?
- ,MAIN_MC_NAME = ?
- ,REG_IN_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')
- WHERE MC_ID = ?
- </query>
-
- <query id="UIK040040_02.UPDATE">
- UPDATE C_TBK03_MACHINE_ONLINE
- SET ZJ_RH_DS1 = ?
- ,ZJ_RH_DS2 = ?
- ,ZJ_RH_DS3 = ?
- ,ND_HYL1 = ?
- ,ND_HYL2 = ?
- ,ND_HYL3 = ?
- WHERE MC_ID = ?
- </query>
-
- <query id="UIK040040_01.CALL">
- {call C_PKG_UIK.SAVE_MACHINE_DETAIL1(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
- </query>
-
- <query id="UIK040040_02.CALL">
- {call C_PKG_UIK.SAVE_MACHINE_DETAIL2(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
- </query>
-
- <query id="UIK040040_03.CALL">
- {call C_PKG_UIK.DELETE_MACHINE_DETAIL(?,?,?,?)}
- </query>
-
- </queryMap>
|
