12345678910111213141516 |
- <?xml version="1.0" encoding="UTF-8"?>
- <properties>
-
- <property name="inssertSm">
- <![CDATA[
- insert into TD_SMCANCEL_INFO (id,cpid,spid,userid,ordertime,province,area,type,vaccode,cancelchannel,inserttime,orderid,paystatus)
- values(to_char(sysdate,'yyyyMMddhh24miss')||SEQ_COMMON6.nextval,#[cpid],#[spid],#[userid],to_date(#[ordertime], 'yyyymmddhh24miss'),
- #[province],#[area],0,'','',sysdate,#[id],1)
- ]]>
- </property>
-
-
- </properties>
|