| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="公共编码">
- <query id="UIB100103_01.SELECT" desc="查询编码">
- SELECT T.* , T.LG_CD LG_CD_1, T.SM_CD SM_CD_1 FROM TBB10_COMMCD T WHERE T.LG_CD LIKE ?||'%' ORDER BY T.LG_CD , T.CD_SEQ
- </query>
- <query id="UIB100103_01.UPDATE" desc="更新">
- UPDATE TBB10_COMMCD T
- SET T.LG_CD = ?
- ,T.SM_CD = ?
- ,T.LG_NM = ?
- ,T.SM_CFNM = ?
- ,T.CD_SEQ = ?
- ,T.USED_YN = NVL(? , 'Y')
- ,T.CD_DESC = ?
- ,T.EDIT_TP = NVL(? , 'Y')
- ,T.MOD_ID = ?
- ,T.MOD_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')
- WHERE T.LG_CD = ?
- AND T.SM_CD = ?
- AND T.EDIT_TP = 'Y'
- </query>
- <query id="UIB100103_01.INSERT" desc="插入">
- INSERT
- INTO TBB10_COMMCD
- (
- LG_CD
- ,SM_CD
- ,LG_NM
- ,SM_CFNM
- ,CD_SEQ
- ,USED_YN
- ,CD_DESC
- ,EDIT_TP
- ,REG_ID
- ,REG_DTIME
- )
- VALUES (?,?,?,?,?,NVL(?,'Y'),?,NVL(? ,'Y'),?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS'))
- </query>
- <query id="UIB100103_01.DELETE" desc="删除">
- DELETE FROM TBB10_COMMCD WHERE LG_CD =? AND SM_CD = ? AND EDIT_TP = 'Y'
- </query>
- </queryMap>
|
