package com.javayjm.excel;

import java.io.File;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.commons.lang.builder.ToStringBuilder;

import com.javayjm.excel.config.ExcelConfigFactory;
import com.javayjm.excel.config.ExcelConfigManager;
import com.javayjm.excel.file.ExcelToModel;
import com.javayjm.excel.file.impl.ExcelToModelImpl;



public class ExcelManager {
	private File excelFile = null;
	private String modelName = "";
	private Map valueMap = null;
	public ExcelManager(String fileName,String modelName,Map valueMap){
		this(new File(fileName),modelName,valueMap);
	}
	public ExcelManager(File fileName,String modelName,Map valueMap){
		this.excelFile = fileName;
		this.modelName = modelName;
		this.valueMap = valueMap;
	}
	
	public List getModelList(){
		ExcelConfigManager configManager = ExcelConfigFactory.createExcelConfigManger();
		ExcelToModel etm =  new ExcelToModelImpl(this.excelFile,configManager.getModel(modelName, ""),this.valueMap);
		List modelList = etm.getModelList();
		
		return modelList;
	}
	public static void main(String[] args) {
		Map<String, String> map = new HashMap<String, String>();
		map.put("deptNo", "1");
		map.put("bgqx永久", "Y");
		ExcelManager test = new ExcelManager("E:\\workspace\\test.xls","deptModel",map);
		List modelList = test.getModelList();
		for(int i = 0;i<modelList.size();i++){
			Object obj = modelList.get(i);
			System.out.println(obj.getClass().getSimpleName());
			System.out.println(ToStringBuilder.reflectionToString(obj));
		}
		System.out.println("---------======================--------------------");
		ExcelManager test2 = new ExcelManager("E:\\workspace\\test.xls","deptModel",map);
		List modelList2 = test2.getModelList();		
	}
	/**
	 * 配制文件加強,一是可以傳一個固定值到所有Bena中. 配制一個固定值.把固定值在RuturnConfig 單設成一個Map ,配制文件中,對固定值的配制必須有默認值,
	 * ExcelToModelImpl 實現時,根據Excel列,屬性設置完成后,對Map循環,設置其值.首先從傳參Map中取值,沒有取默認值設置.
	 * 二是可以配制轉換對應的碼表值.如:excel中傳的值為"長期" 可以配制成 "bgqx長期"做為鍵值 "C" 做為 Bean 設置的值.
	 */
	
}