package com.chinacreator.videoalliance.order.dao;

import java.sql.SQLException;
import org.springframework.stereotype.Component;
import com.chinacreator.videoalliance.common.util.DataSource;
import com.chinacreator.videoalliance.order.bean.ECBBean;
import com.frameworkset.common.poolman.SQLExecutor;

@Component
public class ECBConfigDao {
	
	
	public ECBBean findByCP(String cpid,String spid ,String province) throws SQLException {
		String sql = "select * from tb_ecb_config where status != 2  and spid = ? and cpid = ? and (province = ? or province='0') order by province desc";
		return SQLExecutor.queryObjectWithDBName(ECBBean.class, DataSource.NET3G, sql, spid,cpid,province);
	}
	
	public Boolean isOpen(String usermob,String spid) throws Exception {
		String sql = "select count(1) from tb_changshi_province_control where province in (select province from tb_caller_areacode where callerhead= ? ) and spid= ? and status='2'";
		return Integer.parseInt(SQLExecutor.queryFieldWithDBName(DataSource.NET3G, sql,usermob,spid))>=1 ? true:false;
		
	}
	
	public static void main(String[] args) throws Exception {
		ECBConfigDao dao = new ECBConfigDao();
		System.out.println(dao.isOpen("1866719", "1040") );
		System.out.println(dao.isOpen("1857035", "1040"));
		
	}

}