package com.chinacreator.videoalliance.query.dao;

import java.sql.SQLException;
import java.util.List;

import org.springframework.stereotype.Component;

import com.chinacreator.videoalliance.common.util.DataSource;
import com.chinacreator.videoalliance.query.bean.CsHisBean;
import com.frameworkset.common.poolman.SQLExecutor;

@Component
public class CsHisDao {

	
	public List<CsHisBean> queryHis(String cpid,String spid,String userid) throws SQLException {
		String sql = "select  cpid,spid,userid,type,to_char(inserttime,'yyyy-mm-dd hh24:mi:ss') inserttime,result info,vipcode,vipcpid  from td_cshis_info where  cpid=? and spid=? and userid=?";
		return SQLExecutor.queryListWithDBName(CsHisBean.class, DataSource.NET3G, sql, cpid,spid,userid);
	}
}