videoalliance/.svn/pristine/13/133f8dac152a28a12afeed0659321dc9b418faa0.svn-base

package com.chinacreator.videoalliance.smc.dao;

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

import java.sql.SQLException;

@Component
@CacheName("SmsWhite")
public class SmsWhiteDao {
	
	@Cacheable(value={"SmsWhite"}, key="#userid.concat(#cpid) + 'send'")
	public boolean isBlackUserCanSend(String userid,String cpid) throws SQLException{
		String sql = "select count(1) from tb_smsblackwhite_list where userid=? and (cpid=? or cpid='0') and status =0 and CANSEND =0";
		return NumberUtils.toLong(SQLExecutor.queryFieldWithDBName(DataSource.NET3G, sql,userid,cpid)) > 0;
	}
	
	@Cacheable(value={"SmsWhite"}, key="#userid.concat(#cpid) + 'validate'")
	public boolean isBlackUserCanValidate(String userid,String cpid) throws SQLException{
		String sql = "select count(1) from tb_smsblackwhite_list where userid=? and (cpid=? or cpid='0') and status =0 and CANVALIDATE =0";
		return NumberUtils.toLong(SQLExecutor.queryFieldWithDBName(DataSource.NET3G, sql,userid,cpid)) > 0;
	}

	@Cacheable(value={"SmsWhite"}, key="#userid.concat(#cpid) + 'cansend'")
	public boolean isWhiteUserCanSend(String userid,String cpid) throws SQLException{
		String sql = "select count(1) from tb_smsblackwhite_list where userid=? and (cpid=? or cpid='0') and status =2 ";
		return NumberUtils.toLong(SQLExecutor.queryFieldWithDBName(DataSource.NET3G, sql,userid,cpid)) > 0;
	}
}