| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="成分修约标准维护">
-
- <query id="UIB010171_01.SELECT" desc="查询" fetchSize="10">
- <![CDATA[
- SELECT ROWNUM RNO
- ,T1.*
- ,T1.CHEM_CD CHEMCD
- ,T1.CHEM_MIN CHEMMIN
- ,T1.CHEM_MAX CHEMMAX
- ,T1.ROND_STL_GRD RONDSTLGRD
- ,T2.DISPLAY_LEN DEF_LEN
- FROM TBB01_INGR_ROND T1 , TBB01_SEQ_INGR T2
- WHERE T1.CHEM_CD = T2.CHEM_CD
- AND T1.ROND_STL_GRD LIKE ?||'%'
- ]]>
- </query>
-
- <query id="UIB010171_01.INSERT" desc="插入">
- INSERT INTO TBB01_INGR_ROND(ROND_STL_GRD,CHEM_CD , CHEM_MIN , CHEM_MAX , DISPLAY_LEN , REG_ID , REG_DTIME)
- VALUES(?,?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS'))
- </query>
-
- <query id="UIB010171_01.UPDATE" desc="修改">
- UPDATE TBB01_INGR_ROND T
- SET T.CHEM_CD = ?
- ,T.ROND_STL_GRD = ?
- ,T.CHEM_MIN = ?
- ,T.CHEM_MAX = ?
- ,T.DISPLAY_LEN = ?
- ,T.MOD_ID = ?
- ,T.MOD_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')
- WHERE T.CHEM_CD = ?
- AND T.CHEM_MIN = ?
- AND T.CHEM_MAX = ?
- AND T.ROND_STL_GRD = ?
- </query>
-
- <query id="UIB010171_01.DELETE" desc="删除">
- DELETE FROM TBB01_INGR_ROND T
- WHERE T.CHEM_CD = ?
- AND T.CHEM_MIN = ?
- AND T.CHEM_MAX = ?
- AND T.ROND_STL_GRD = ?
- </query>
- </queryMap>
|
