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.OrderInfo;
import com.frameworkset.common.poolman.SQLExecutor;


@Component
public class OrderContentDao extends ExecutorDao{
	
	public  String queryEndtime(String userid ,String spids) throws SQLException{
		String sql = "select to_char(max(endtime) ,'yyyymmddhh24miss') endtime from td_order_relations where spid in ("+spids+") and userid =? and endtime is not null and endtime > sysdate";
		return SQLExecutor.queryFieldWithDBName(DataSource.NET3G, sql, userid);
	}
	
	public void insertOrder(OrderInfo orderInfo) throws SQLException{
		this.getExecutor().insertBean(DataSource.NET3G, "insertOrder", orderInfo);
	} 
	
	public static void main(String[] args) throws SQLException {
		OrderContentDao dao = new OrderContentDao();
		System.out.println(dao.queryEndtime("18574414678", "11"));
	}

}