videoalliance/.svn/pristine/a4/a48cbe7bca6506ddede194b6ea01d704c2bff271.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<properties>
	
	<property name="addOrderLog">
		<![CDATA[
			insert into tl_order_log (id, userid, province, area, apptype, useragent, origin, 
			channel, cpid, spid, errorcode, errorinfo, status, orderstatus, ordertype, inserttime, isexperience,times) values (
			to_char(sysdate, 'yyyymmddhh24miss') || SEQ_COMMON6.nextval,
			#[userid], #[province], #[area], #[apptype], #[useragent], #[origin], #[channel], #[cpid],
			#[spid], #[errorcode], #[errorinfo], #[status], #[orderstatus], #[ordertype],
			sysdate, #[isexperience], #[times])
		]]>
	</property>
	
	<property name="addVacOrderLog">
		<![CDATA[
			insert into TL_VAC_LOG(id,userid,cpid,province,inserttime,type,resultcode,productid,sequence)
			values (
				to_char(sysdate,'yyyyMMddhh24miss')||SEQ_COMMON6.nextval, #[userid], #[cpid], #[province],
				sysdate, #[type], #[resultcode], #[productid], #[sequence]
			)
		]]>
	</property>
	
</properties>