videoalliance/.svn/pristine/5c/5c90582539e22e539b9c5a44a7f157caf657f023.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<properties>
	
	<property name="querySchoolChannelSp">
		<![CDATA[
			select cpid,spid,productid,key, appid,ifurl,process from TB_SCHOOL_CHANNEL_SP
			where channelcode=? and productid=?
		]]>
	</property>
	
	<property name="querySchoolChannel">
		<![CDATA[
			select channelcode,aeskey from TB_SCHOOL_CHANNEL
			where channelcode=?
		]]>
	</property>
	
	<property name="addSchoolOrderLog">
		<![CDATA[
			insert into TL_SCHOOL_ORDER_LOG (id,channelcode,userid,productid,starttime,endtime,resultcode,resultinfo,times,requeststr,responsestr,inserttime) values
			(to_char(sysdate,'yyyyMMddhh24miss')||SEQ_COMMON6.nextval,#[channelcode],#[userid],#[productid],to_date(#[starttime], 'yyyyMMddhh24miss'),
			to_date(#[endtime], 'yyyyMMddhh24miss'),#[resultcode],#[resultinfo],#[times],#[requeststr],#[responsestr],sysdate)
		]]>
	</property>
	
</properties>