videoalliance/.svn/pristine/a3/a3ff44e13850c51f23cb775fdde6426f251d2b84.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<properties>
	
	 <property name="insertOrder">
		<![CDATA[
			insert into TD_ORDER_RELATIONS (id,cpid,spid,userid,ordertime,effecttime,endtime,status,province,area,orderchannel,synccount,syncsucceed,type,orderstatus,ordertype,apptype,isexperience,videoid,videoname,cachesucceed, showstatus)values(
			to_char(sysdate,'yyyyMMddhh24miss')||SEQ_COMMON6.nextval,
			#[cpid],#[spid],#[userid],
			to_date(#[ordertime], 'yyyymmddhh24miss'),
			to_date(#[effecttime], 'yyyymmddhh24miss'), 
			#if($endtime && !$endtime.equals(""))to_date(#[endtime], 'yyyymmddhh24miss') #else '' #end,
			#[status],#[province],#[area],#[orderchannel],0,1,#[type],#[orderstatus],#[ordertype],#[apptype],#[isexperience],#[videoid],#[videoname],1, #[showstatus])
		]]>
	</property>
	
</properties>