| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="客户公差录入">
- <query id="UIB010280_01.INITSELECT" desc="获得公差名及公差代码">
- SELECT
- SM_CFNM LABEL --公差名
- , SM_CD VALUE --公差代码
- FROM TBZ00_COMMCD WHERE LG_CD = 'B01012'
- </query>
-
- <query id="UIB010280_01.SELECT" desc="" fetchSize="10">
- <![CDATA[
- SELECT DISTINCT
- SUBSTR(T.CUST_SPEC_NO , 1,6 ) CUST_CD
- ,SUBSTR(T.CUST_SPEC_NO , 7,2 ) PRDNM_CD
- ,SUBSTR(T.CUST_SPEC_NO , 9,2 ) SEQ
- ,SUBSTR(T.CUST_SPEC_NO , 11) PROD_LINE
- ,T.SPEC_STL_GRD
- FROM TBB01_CUST_DEL T
- WHERE T.CUST_SPEC_NO LIKE ?||'%'
- ]]>
- </query>
-
- <query id="UIB010280_02.SELECT">
- SELECT 'N' CHK
- ,T.DEL_TOL_CD
- ,T.DEL_TOL_CD DEL_TOL_CD1
- ,T.TOL_MIN_SYM
- ,T.TOL_MIN
- ,T.TOL_MAX_SYM
- ,T.TOL_MAX
- ,T.DEV_RMK
- FROM TBB01_CUST_DEL T
- WHERE T.CUST_SPEC_NO = ?
- </query>
-
- <query id="UIB010280_01.INSERT">
- INSERT INTO
- TBB01_CUST_DEL(CUST_SPEC_NO
- ,DEL_TOL_CD
- ,SPEC_STL_GRD
- ,TOL_MIN_SYM
- ,TOL_MIN
- ,TOL_MAX_SYM
- ,TOL_MAX
- ,DEV_RMK
- ,REG_ID
- ,REG_DTIME)
- VALUES(?,?,?,?,?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS'))
- </query>
-
- <query id="UIB010280_01.UPDATE">
- UPDATE TBB01_CUST_DEL T
- SET TOL_MIN_SYM = ?
- ,TOL_MIN = ?
- ,TOL_MAX_SYM = ?
- ,TOL_MAX = ?
- ,DEV_RMK = ?
- ,MOD_ID = ?
- ,MOD_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')
- WHERE CUST_SPEC_NO = ?
- AND DEL_TOL_CD = ?
- </query>
-
- <query id="UIB010280_01.DELETE">
- DELETE FROM TBB01_CUST_DEL T WHERE T.CUST_SPEC_NO = ? AND T.DEL_TOL_CD = ?
- </query>
-
- <query id="UIB010280_02.DELETE">
- DELETE FROM TBB01_CUST_DEL T WHERE T.CUST_SPEC_NO = ?
- </query>
- </queryMap>
|
