beeaf99f08f58f90c58c1311c2c45138257e2ef2.svn-base 456 B

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