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

@Component
public class VipSeniorityDao {

	public void insert(OrderInfo orderInfo) throws SQLException{
		String sql = "insert into TD_GIVEVIP_SENIORITY(userid,cpid,spid,inserttime,channel) "
				+ "values(#[userid],#[cpid],#[spid],sysdate,#[orderchannel])";
		SQLExecutor.insertBean(DataSource.NET3G, sql,orderInfo);
	}
	
	public boolean query(String userid,String cpid,String spid,String channel) throws SQLException{
		String sql = "select count(1) from TD_GIVEVIP_SENIORITY where userid =? and cpid=? and spid=? and channel=?";
		return NumberUtils.toInt(SQLExecutor.queryFieldWithDBName(DataSource.NET3G, sql, userid, cpid,spid,channel)) >0;
	}
	
}