| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="统计信息录入">
- <query id="UIC020110_01.SELECT">
- <![CDATA[
- SELECT PROD_LINE
- ,TJ_DTIME
- ,TJ_BC
- ,TJ_NAME
- ,TJ_RESULT
- ,TJ_DEMO
- ,REG_ID
- ,TO_CHAR(TO_DATE(REG_DTIME ,'YYYY-MM-DD HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS') REG_DTIME
- ,MOD_ID
- ,TO_CHAR(TO_DATE(MOD_DTIME ,'YYYY-MM-DD HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS') MOD_DTIME
- FROM TBC02_JISHU_LR T
- WHERE T.PROD_LINE = ?
- AND T.TJ_DTIME LIKE ?||'%'
- AND T.TJ_BC = ?
- AND T.TJ_NAME <> '实际作业时间'
- ORDER BY t.Dis_Seq
- ]]>
- </query>
- <query id="UIC020110_01.UPDATE">
- UPDATE TBC02_JISHU_LR T
- SET T.TJ_RESULT = ?
- ,T.TJ_DEMO = ?
- ,T.MOD_ID = ?
- ,T.MOD_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')
- ,T.MOD_PGM = 'UIC020110'
- WHERE T.PROD_LINE = ?
- AND T.TJ_DTIME = ?
- AND T.TJ_BC = ?
- AND T.TJ_NAME = ?
- </query>
- <query id="UIC020110_01.CALL">
- {call REPORT_FORM.JISHU_JINJI_INSERT(?,?,?,?,?)}
- </query>
- </queryMap>
|
