| 12345678910111213141516171819202122 |
- <?xml version="1.0" encoding="UTF-8"?>
- <properties>
-
- <property name="insertSycnOrder">
- <![CDATA[
- insert into TL_SYNC_LOG(id,userid,cpid,type,input,output,inserttime,succeed,tocpid,time,tospid,spid) values
- (to_char(sysdate,'yyyyMMddhh24miss')||SEQ_COMMON6.nextval,#[userid],#[cpid],#[type],#[input],#[output],to_date(#[inserttime], 'yyyyMMddhh24miss'),#[succeed],#[tocpid],1,#[tospid],#[spid])
- ]]>
- </property>
- <property name="getOrderById">
- <![CDATA[
- select id,cpid, spid, userid, to_char(ordertime, 'yyyymmddhh24miss') ordertime,
- to_char(endtime, 'yyyymmddhh24miss') endtime, to_char(canceltime, 'yyyymmddhh24miss') canceltime,
- to_char(effecttime, 'yyyymmddhh24miss') effecttime, status, orderchannel, cancelchannel,
- ordertype, orderstatus,videoid, videoname, type, apptype, province, area, isexperience
- from TD_ORDER_RELATIONS where id=? and (endtime is null or endtime > sysdate)
- ]]>
- </property>
- </properties>
|
