| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="冷轧、热轧标准对应">
- <query id="UIB010321_01.INITSELECT">
- SELECT DISTINCT T.SPEC_ABBSYM LABEL , T.SPEC_ABBSYM VALUE FROM TBB01_KEY_PROD T ORDER BY T.SPEC_ABBSYM
- </query>
-
- <query id="UIB010321_02.INITSELECT">
- SELECT DISTINCT T.SPEC_STL_GRD LABEL , T.SPEC_STL_GRD VALUE FROM TBB01_KEY_PROD T ORDER BY T.SPEC_STL_GRD
- </query>
-
- <query id="UIB010321_01.SELECT" desc="" fetchSize="10">
- <![CDATA[
- SELECT * FROM TBB01_HCMAP_SPEC T WHERE T.SPEC_STL_GRD LIKE ?||'%' AND T.SPEC_ABBSYM LIKE ?||'%'
- ]]>
- </query>
-
- <query id="UIB010321_01.INSERT">
- INSERT INTO TBB01_HCMAP_SPEC
- (PRIO_LEVL
- ,PRDNM_CD
- ,SPEC_ABBSYM
- ,SPEC_STL_GRD
- ,ORD_USE_TP
- ,THK_MIN
- ,THK_MAX
- ,WTH_MIN
- ,WTH_MAX
- ,C_PRDNM_CD
- ,C_SPEC_ABBSYM
- ,C_SPEC_STL_GRD
- ,C_ORD_USE_TP
- ,C_MAKE_THK
- ,C_MAKE_WTH
- ,REG_NM
- ,REG_DTIME)
- VALUES
- (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS'))
- </query>
-
- <query id="UIB010321_01.UPDATE">
- UPDATE TBB01_HCMAP_SPEC T
- SET PRIO_LEVL = ?
- ,PRDNM_CD = ?
- ,SPEC_ABBSYM = ?
- ,SPEC_STL_GRD = ?
- ,ORD_USE_TP = ?
- ,THK_MIN = ?
- ,THK_MAX = ?
- ,WTH_MIN = ?
- ,WTH_MAX = ?
- ,C_PRDNM_CD = ?
- ,C_SPEC_ABBSYM = ?
- ,C_SPEC_STL_GRD = ?
- ,C_ORD_USE_TP = ?
- ,C_MAKE_THK = ?
- ,C_MAKE_WTH = ?
- ,MOD_ID = ?
- ,MOD_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')
- WHERE PRIO_LEVL = ?
- ,PRDNM_CD = ?
- ,SPEC_ABBSYM = ?
- ,SPEC_STL_GRD = ?
- ,ORD_USE_TP = ?
- ,THK_MIN = ?
- ,THK_MAX = ?
- ,WTH_MIN = ?
- ,WTH_MAX = ?
- </query>
-
- <query id="UIB010321_01.DELETE">
- DELETE FROM TBB01_HCMAP_SPEC T
- WHERE PRIO_LEVL = ?
- AND PRDNM_CD = ?
- AND SPEC_ABBSYM = ?
- AND SPEC_STL_GRD = ?
- AND ORD_USE_TP = ?
- AND THK_MIN = ?
- AND THK_MAX = ?
- AND WTH_MIN = ?
- AND WTH_MAX = ?
- </query>
-
- </queryMap>
|
