package com.chinacreator.videoalliance.order.dao;

import com.chinacreator.common.dao.ExecutorDao;
import com.chinacreator.videoalliance.common.dao.CPDao;
import com.chinacreator.videoalliance.common.util.DataSource;
import com.chinacreator.videoalliance.order.bean.OrderInfo;
import com.chinacreator.videoalliance.order.bean.SycnLogBean;
import com.chinacreator.videoalliance.order.bean.TransferBean;
import com.frameworkset.common.poolman.SQLExecutor;
import org.springframework.stereotype.Repository;

import java.sql.SQLException;

/**
 * Create by IntelliJ IDEA.
 * User: EricJin
 * Date: 4/27/2018 2:48 PM
 */
@Repository
public class SycnOrderDao extends ExecutorDao{

    public void insertSycnLog(SycnLogBean sycnLog) throws SQLException {
        this.executor.insertBean(DataSource.NET3G, "insertSycnOrder", sycnLog);
    }

    public String getSycnAddr(String cpid) throws SQLException {
        String sql = "select sycnaddr from TB_CP_ACCOUNT_CONFIG where cpid=?";
        return SQLExecutor.queryFieldBeanWithDBName(DataSource.NET3G,sql,new Object[]{cpid});
    }

    public OrderInfo getOrderById(String id) throws SQLException {
        return (OrderInfo)getExecutor().queryObjectWithDBName(OrderInfo.class, "net3g", "getOrderById",
                new Object[] { id });
    }
}