package com.shove.base;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.springframework.web.context.ContextLoader;

import com.shove.config.DataBaseConfig;
import com.shove.data.ConnectionManager;
import com.shove.data.DataException;
import com.shove.data.DataSet;
import com.shove.vo.PageBean;
import com.sp2p.constants.IAmountConstants;
import com.sp2p.constants.IInformTemplateConstants;
import com.sp2p.database.Dao.Procedures;

/**
 * 基类
 *
 */
public class BaseService {
	
	public static ConnectionManager connectionManager;

	public static DataBaseConfig dateManager;
	/**
	 * 分页存储过程
	 * @param pageBean
	 * @param table 表名
	 * @param field 字段名
	 * @param order 排序
	 * @param where 条件
	 * @throws DataException 
	 * @throws SQLException 
	 */
	public void dataPage(Connection conn, PageBean<Map<String, Object>> pageBean, String table, String field, String order, String condition) throws SQLException, DataException{
		DataSet ds = new DataSet();
		List<Object> outParameterValues = new ArrayList<Object>();
		long curPage =  pageBean.getPageNum();
		Procedures.pr_page(conn, ds, outParameterValues, table, field, pageBean.getPageSize(), curPage, order, condition, 0);
		long count = (Long) outParameterValues.get(0);
		boolean result = pageBean.setTotalNum(count);
		if(result){
			ds.tables.get(0).rows.genRowsMap();
			pageBean.setPage(ds.tables.get(0).rows.rowsMap);
		}
	}
	
	public ConnectionManager getConnectionManager() {
		return connectionManager;
	}

	public void setConnectionManager(ConnectionManager connectionManager) {
		this.connectionManager = connectionManager;
	}

	public static DataBaseConfig getDateManager() {
		return dateManager;
	}

	public static void setDateManager(DataBaseConfig dateManager) {
		BaseService.dateManager = dateManager;
	}

	@SuppressWarnings("unchecked")
	public Map<String,Object> getInformTemplate(){
		return (Map<String, Object>)ContextLoader.getCurrentWebApplicationContext().getServletContext().getAttribute(IInformTemplateConstants.INFORM_TEMPLATE_APPLICATION);
	}
	@SuppressWarnings("unchecked")
	public Map<String, Object> getPlatformCost(){
		//获取平台收费
		Map<String,Object> platformCostMap = (Map<String, Object>) ContextLoader.getCurrentWebApplicationContext().getServletContext().getAttribute(IAmountConstants.FEE_APPLICATION);
        if(platformCostMap == null)
        	platformCostMap = new HashMap<String, Object>();
		return platformCostMap;
	}
	
}