package com.chinacreator.videoalliance.order.dao;

import java.sql.SQLException;

import org.springframework.stereotype.Component;

import jxl.common.Logger;

import com.chinacreator.common.dao.ExecutorDao;
import com.chinacreator.videoalliance.common.bean.AreaInfo;
import com.chinacreator.videoalliance.common.util.AreaUtil;
import com.chinacreator.videoalliance.common.util.DataSource;
import com.chinacreator.videoalliance.order.bean.OrderLog;
import com.chinacreator.videoalliance.order.bean.VacOrderLog;
import com.frameworkset.common.poolman.PreparedDBUtil;

@Component
public class OrderLogDao extends ExecutorDao {
	
	private static Logger logger = Logger.getLogger(OrderLogDao.class);
	
	public void addOrderLog(OrderLog orderLog) {
		try {
			this.getExecutor().insertBean(DataSource.NET3G, "addOrderLog", orderLog);
		} catch (SQLException e) {
			logger.error("保存订购日志失败", e);
		}
	}
	
	public void addVacOrderLog(VacOrderLog orderLog) {
		try {
			this.getExecutor().insertBean(DataSource.NET3G, "addVacOrderLog", orderLog);
		} catch (SQLException e) {
			logger.error("保存Vac订购日志失败", e);
		}
	}
	
	public static void main(String[] args) {
		VacOrderLog vacOrderLog = new VacOrderLog();
	    vacOrderLog.setProvince("湖南");
	    vacOrderLog.setUserid("18574414678");
	    vacOrderLog.setCpid("tencent");
	    vacOrderLog.setProductid("11111111");
	    vacOrderLog.setResultcode("0");
	    vacOrderLog.setSpcode("");
	    vacOrderLog.setType("1");
	    OrderLogDao dao = new OrderLogDao();
	    dao.addVacOrderLog(vacOrderLog); 
	}
	
	public void addCacheLog(String catalog, String key, String errorinfo) {
		try {
			String sql = "insert into tl_sync_cache_log (id, catalog, key, errorinfo, inserttime) values (to_char(sysdate,'yyyyMMddHH24miss')||SEQ_COMMON6.nextval, ?, ?, ?, sysdate)";
			PreparedDBUtil pdb = new PreparedDBUtil();
			pdb.preparedInsert(DataSource.NET3G, sql);
			pdb.setString(1, catalog);
			pdb.setString(2, key);
			pdb.setString(3, errorinfo);
			pdb.executePrepared();
		} catch (SQLException e) {
			logger.error("保存缓存日志失败", e);
		}
	}
}