| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384 |
- <?xml version="1.0" encoding="UTF-8"?>
- <queryMap desc="反射率检验记录操作">
- <query id="UIK010090_01.SELECT" desc="查询反射率检验信息">
- <![CDATA[
- select COIL_NO,
- SPEC_STL_GRD,
- COIL_THK,
- COIL_WTH,
- BEF_WASH_FSL,
- LATER_WASH_FSL,
- REMARK_INFO,
- REG_BANCI,
- REG_GROUP,
- REG_ID,
- REG_DTIME,
- MOD_BANCI,
- MOD_GROUP,
- MOD_ID,
- MOD_DTIME
- from C_TBK01_FSL_RESULT
- WHERE COIL_NO LIKE ?||'%'
- AND SPEC_STL_GRD LIKE ?||'%'
- AND REG_DTIME BETWEEN NVL(?, REG_DTIME) AND
- NVL(?, REG_DTIME)
- order by REG_DTIME desc
- ]]>
- </query>
- <query id="UIK010090_02.SELECT" desc="根据rowid查询反射率检验信息">
- <![CDATA[
- select
- COIL_NO,
- SPEC_STL_GRD,
- COIL_THK,
- COIL_WTH,
- BEF_WASH_FSL,
- LATER_WASH_FSL,
- REMARK_INFO
- from C_TBK01_FSL_RESULT
- WHERE COIL_NO = ? and REG_DTIME = ?
- ]]>
- </query>
-
- <query id="UIK010090_01.UPDATE" desc="修改反射率检验数据">
- <![CDATA[
- UPDATE C_TBK01_FSL_RESULT T
- SET T.COIL_NO = ?
- ,T.SPEC_STL_GRD = ?
- ,T.COIL_THK = ?
- ,T.COIL_WTH = ?
- ,T.BEF_WASH_FSL = ?
- ,T.LATER_WASH_FSL = ?
- ,T.REMARK_INFO = ?
- ,T.MOD_BANCI = ?
- ,T.MOD_GROUP = ?
- ,T.MOD_ID = ?
- ,T.MOD_DTIME = TO_CHAR(systimestamp,'YYYY-MM-DD HH24:MI:SS.FF3')
- WHERE COIL_NO = ? and REG_DTIME = ?
- ]]>
- </query>
-
- <query id="UIK010090_01.INSERT" desc="插入反射率检验数据">
- <![CDATA[
- INSERT into C_TBK01_FSL_RESULT
- (COIL_NO,
- SPEC_STL_GRD,
- COIL_THK,
- COIL_WTH,
- BEF_WASH_FSL,
- LATER_WASH_FSL,
- REMARK_INFO,
- REG_BANCI,
- REG_GROUP,
- REG_PGM_ID,
- REG_ID,
- REG_DTIME)
- values (?,?,?,?,?,?,?,?,?,?,?,TO_CHAR(systimestamp,'YYYY-MM-DD HH24:MI:SS.FF3'))
- ]]>
- </query>
- <query id="UIK010090_01.delete" desc="根据行号删除" fetchSize="10">
- <![CDATA[
- delete from C_TBK01_FSL_RESULT where COIL_NO = ? and REG_DTIME = ?
- ]]>
- </query>
- </queryMap>
|
