videoalliance/.svn/pristine/75/7593e1533b759061cf8cfa83ad8036555f441534.svn-base

package com.chinacreator.videoalliance.query.dao;

import java.sql.SQLException;

import org.apache.commons.lang.math.NumberUtils;
import org.springframework.stereotype.Component;
import com.chinacreator.videoalliance.common.util.DataSource;
import com.frameworkset.common.poolman.SQLExecutor;

@Component
public class ActiveDao {

	
	public boolean query(String cpid,String spid,String province,String activetype) throws SQLException {
		String sql = "select count(1) from TB_ACTIVITY_CONFIG where province in ('0',?) and cpid=? and spid=? and activetype=? and endtime > sysdate";
		return NumberUtils.toInt(SQLExecutor.queryFieldWithDBName(DataSource.NET3G, sql,province,cpid,spid,activetype), 0) > 0;
	}
}