| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="冷轧、热轧标准对应">
- <query id="UIB010322_01.SELECT">
- SELECT DISTINCT
- 'N' CHK
- ,T.SIZE_SPEC_CD
- ,T.SIZE_RMK
- FROM TBB01_HCMAP_SIZE T
- ORDER BY T.SIZE_SPEC_CD
- </query>
-
- <query id="UIB010322_02.SELECT" desc="厚度">
- SELECT 'N' T_CHK
- ,T.C_THK_MIN
- ,T.C_THK_MAX
- ,T.C_THK_MIN C_THK_MIN1
- ,T.C_THK_MAX C_THK_MAX1
- ,T.TOL_MIN T_TOL_MIN
- ,T.TOL_MAX T_TOL_MAX
- ,T.H_THK_AIM
- ,T.REG_ID
- ,T.REG_DTIME
- ,T.MOD_ID
- ,T.MOD_DTIME
- FROM TBB01_HCMAP_SIZE T
- WHERE T.SIZE_SPEC_CD = ?
- AND T.SIZE_CD = 'THK'
- </query>
-
- <query id="UIB010322_03.SELECT" desc="宽度">
- SELECT 'N' W_CHK
- ,T.C_WTH_MIN
- ,T.C_WTH_MAX
- ,T.C_WTH_MIN C_WTH_MIN1
- ,T.C_WTH_MAX C_WTH_MAX1
- ,T.TOL_MIN W_TOL_MIN
- ,T.TOL_MAX W_TOL_MAX
- ,T.H_WTH_AIM
- ,T.REG_ID
- ,T.REG_DTIME
- ,T.MOD_ID
- ,T.MOD_DTIME
- FROM TBB01_HCMAP_SIZE T
- WHERE T.SIZE_SPEC_CD = ?
- AND T.SIZE_CD = 'WTH'
- </query>
-
- <query id="UIB010322_THK_01.INSERT">
- INSERT INTO TBB01_HCMAP_SIZE(
- SIZE_SPEC_CD
- ,SIZE_CD
- ,C_THK_MIN
- ,C_THK_MAX
- ,C_WTH_MIN
- ,C_WTH_MAX
- ,H_THK_AIM
- ,TOL_MIN
- ,TOL_MAX
- ,SIZE_RMK
- ,REG_ID
- ,REG_DTIME)
- VALUES(?,'THK',?,?,'0','0',?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS'))
- </query>
-
- <query id="UIB010322_THK_01.UPDATE">
- UPDATE TBB01_HCMAP_SIZE T
- SET T.C_THK_MIN = ?
- ,T.C_THK_MAX = ?
- ,T.H_THK_AIM = ?
- ,T.TOL_MIN = ?
- ,T.TOL_MAX = ?
- ,T.SIZE_RMK = ?
- ,T.MOD_ID = ?
- ,T.MOD_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')
- WHERE T.SIZE_SPEC_CD = ?
- AND T.SIZE_CD = 'THK'
- AND T.C_THK_MIN = ?
- AND T.C_THK_MAX = ?
- </query>
-
- <query id="UIB010322_WTH_01.INSERT">
- INSERT INTO TBB01_HCMAP_SIZE(
- SIZE_SPEC_CD
- ,SIZE_CD
- ,C_THK_MIN
- ,C_THK_MAX
- ,C_WTH_MIN
- ,C_WTH_MAX
- ,H_WTH_AIM
- ,TOL_MIN
- ,TOL_MAX
- ,SIZE_RMK
- ,REG_ID
- ,REG_DTIME)
- VALUES(?,?,?,?,?,?,?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS'))
- </query>
-
- <query id="UIB010322_WTH_01.UPDATE">
- UPDATE TBB01_HCMAP_SIZE T
- SET T.C_WTH_MIN = ?
- ,T.C_WTH_MAX = ?
- ,T.H_WTH_AIM = ?
- ,T.TOL_MIN = ?
- ,T.TOL_MAX = ?
- ,T.SIZE_RMK = ?
- ,T.MOD_ID = ?
- ,T.MOD_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')
- WHERE T.SIZE_SPEC_CD = ?
- AND T.SIZE_CD = 'WTH'
- AND T.C_WTH_MIN = ?
- AND T.C_WTH_MAX = ?
- </query>
-
- <query id="UIB010322_01.DELETE">
- DELETE FROM TBB01_HCMAP_SIZE T
- WHERE T.SIZE_SPEC_CD = ?
- AND T.SIZE_CD = ?
- AND T.C_THK_MIN = ?
- AND T.C_THK_MAX = ?
- AND T.C_WTH_MIN = ?
- AND T.C_WTH_MAX = ?
- </query>
-
- <query id="UIB010322_02.DELETE">
- DELETE FROM TBB01_HCMAP_SIZE T WHERE T.SIZE_SPEC_CD = ?
- </query>
- </queryMap>
|
