package com.chinacreator.videoalliance.order.dao;

import java.sql.SQLException;

import org.springframework.stereotype.Component;

import com.chinacreator.common.dao.ExecutorDao;
import com.chinacreator.videoalliance.common.util.DataSource;
import com.chinacreator.videoalliance.order.bean.SchoolChannel;
import com.chinacreator.videoalliance.order.bean.SchoolChannelSp;
import com.chinacreator.videoalliance.order.bean.SchoolOrderLog;
@Component
public class SchoolOrderDao  extends ExecutorDao{

	public SchoolChannel querySchoolChannel(String  channelcode) throws SQLException{
		return this.executor.queryObjectWithDBName(SchoolChannel.class,DataSource.NET3G, "querySchoolChannel",channelcode);
	}
	
	public SchoolChannelSp querySchoolChannelSp(String  channelcode,String productid) throws SQLException{
		return this.executor.queryObjectWithDBName(SchoolChannelSp.class,DataSource.NET3G, "querySchoolChannelSp",channelcode,productid);
	}
	
	public void addSchoolOrderLog(SchoolOrderLog orderlog) throws SQLException{
		this.executor.insertBean(DataSource.NET3G,"addSchoolOrderLog", orderlog);
	}
}