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

@Component
public class MemberDao {

	public MemberInfo queryMember(String member,String cpid) throws SQLException{
		String sql = "select *  from TD_MEMBER_ACTIVATION where status != 2 and member = ? and cpid =?";
		return SQLExecutor.queryObjectWithDBName(MemberInfo.class, DataSource.NET3G, sql, member,cpid);
	}
	
	public void saveLog(MemberlogBean bean) throws SQLException{
		String sql = "insert into tl_member_log(id,cpid,spid,productid,err,msg,inserttime,outparams,inputparams,pwd,resultcode,errorinfo,userid,code) values("
				+ "#[id],#[cpid],#[spid],#[productid],#[err],#[msg],sysdate,#[outparams],#[inputparams],#[pwd],#[resultcode],#[errorinfo],#[userid],#[code])";
		SQLExecutor.insertBean(DataSource.NET3G, sql, bean);
	}
	
	public void updatemember(String userid,String member) throws SQLException{
		String sql = "update TD_MEMBER_ACTIVATION set userid = ? ,STATUS=0,ACTIVATIONTIME=sysdate where MEMBER =?";
		SQLExecutor.updateWithDBName(DataSource.NET3G, sql, userid,member);
	}
	
	public static void main(String[] args) throws SQLException {
		String sql = "update TD_MEMBER_ACTIVATION set userid = ? ,STATUS=0,ACTIVATIONTIME=sysdate where MEMBER =?";
		System.out.println(SQLExecutor.updateWithDBName(DataSource.NET3G, sql, "18684726109","862709030000056"));
	}
	
}