package com.chinacreator.videoalliance.order.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.order.bean.OrderIp;
import com.frameworkset.common.poolman.SQLExecutor;

@Component
public class OrderIpAutheDao {

	public List<OrderIp> queryOrderIp(String cpid,String userip) throws SQLException {
		String sql = "select a.* from tb_order_ip a where status='0' and a.cpid=? and a.userip=?";
		return SQLExecutor.queryListWithDBName(OrderIp.class, DataSource.NET3G, sql,cpid,userip);
	}
	
}