| 123456789101112131415 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIH052000_01.select" desc=" 已制定命令查询 ">
- <![CDATA[
- SELECT A.ORD_SEQ,A.CR_NO,A.FROM_ADDR,A.COIL_NO,A.TO_ADDR,DECODE(A.ORD_STAT,'1','命令制定','2','命令执行') ORD_STAT,A.REG_ID REG_ID_1,A.REG_DTIME REG_DTIME_1
- FROM TBH05_COIL_CRANE_ORDER A WHERE A.ORD_STAT = '1' and a.REG_DTIME like :1||'%' and a.FROM_ADDR like :2||'%' and a.TO_ADDR like :3||'%' and a.REG_ID like :4||'%'
- ]]>
- </query>
- <query id="UIH052000_02.select" desc=" 已完成命令查询 ">
- <![CDATA[
- SELECT A.ORD_SEQ,A.CR_NO,A.FROM_ADDR,A.COIL_NO,A.TO_ADDR,DECODE(A.ORD_STAT,'1','命令制定','2','命令执行') ORD_STAT,A.REG_ID REG_ID_2,A.REG_DTIME REG_DTIME_2
- FROM TBH05_COIL_CRANE_ORDER A WHERE A.ORD_STAT = '2' and a.REG_DTIME like :1||'%' and a.FROM_ADDR like :2||'%' and a.TO_ADDR like :3||'%' and a.REG_ID like :4||'%'
- ]]>
- </query>
- </queryMap>
|
