3f0b5802a59eea266fa038fb29939075886f10d2.svn-base 571 B

1234567891011121314151617
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <properties>
  3. <property name="queryProduct">
  4. <![CDATA[
  5. select * from TB_EXPERIENCEORDER_INFO where channel=? and productid=?
  6. ]]>
  7. </property>
  8. <property name="insertlog">
  9. <![CDATA[
  10. insert into tl_experienceorder_log(id,userid,productid,channel,orderNum,outparam,inputparam,resultcode,errorinfo,inserttime)
  11. values(to_char(sysdate,'yyyymmddhh24miss')||SEQ_COMMON6.nextval,#[userid],#[productid],#[channel],#[orderNum],#[outparam],#[inputparam],#[resultcode],#[errorinfo],sysdate)
  12. ]]>
  13. </property>
  14. </properties>