package com.saas.biz.dao.clewAssignDAO;

import java.lang.reflect.Field;
import java.lang.reflect.InvocationTargetException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;

import org.apache.commons.beanutils.PropertyUtils;

import com.saas.biz.commen.commMethodMgr;
import com.saas.sys.dbm.Dbexecute;
import com.saas.sys.log.Logger;

public class ClewAssignExt extends ClewAssignkDAO {
	
	
	
	/**
	 * 
	 */
	private static final long serialVersionUID = 9209476084902172991L;
	
	
	ClewAssignkDAO clewDao;
	
	
	Logger log;
	
	
	ArrayList updArray;
	
	
	ArrayList paramArray;
	
	
	
	public ClewAssignExt() {

		clewDao = new ClewAssignkDAO();
		log = new Logger(this);
		updArray = new ArrayList();
		paramArray = new ArrayList();
	}
	
	
	public ArrayList selByList(String selBy) {

		Dbexecute exec = new Dbexecute();
		ArrayList dataArray = new ArrayList();
		exec.setStrTable("tf_f_clewtrackman");
		exec.setStrQuery(selBy);
		exec.setParamList(this.paramArray);
		dataArray = exec.selBizQuery();
		if (dataArray.size() <= 0)
			return null;
		return dataArray;
	}
	
	
	public ClewAssignkDAO selByInfo(String selBy) {

		Dbexecute exec = new Dbexecute();
		commMethodMgr commen = new commMethodMgr();
		Logger log = new Logger(this);
		ArrayList dataArray = new ArrayList();
		exec.setStrTable("tf_f_clewtrackman");
		exec.setStrQuery(selBy);
		exec.setParamList(this.paramArray);
		dataArray = exec.selBizQuery();
		if (dataArray.size() <= 0)
			return null;
		ClewAssignkDAO clewDao = new ClewAssignkDAO();
		Field[] fields = clewDao.getClass().getDeclaredFields();
		for (Iterator it = dataArray.iterator(); it.hasNext();) {
			HashMap tradetype = (HashMap) it.next();
			for (int i = 0; i <= fields.length - 1; i++) {
				if (tradetype.containsKey(fields[i].getName())) {
					try {
						if (tradetype.get(fields[i].getName()) != null) {
							if (fields[i].getType().getName() == "java.lang.String") {
								PropertyUtils.setProperty(clewDao, fields[i].getName(), tradetype.get(fields[i].getName()).toString());
							}
							else if (fields[i].getType().getName() == "java.lang.Integer") {
								Integer ivalue = new Integer(tradetype.get(fields[i].getName()).toString());
								PropertyUtils.setProperty(clewDao, fields[i].getName(), ivalue);
							}
						}
					}
					catch (InvocationTargetException e) {
						throw new RuntimeException(e);
					}
					catch (NoSuchMethodException e) {
						throw new RuntimeException(e);
					}
					catch (IllegalAccessException e) {
						throw new RuntimeException(e);
					}
				}
			}
		}
		return clewDao;
	}
	
	
	public int selCount(String selBy) {

		Dbexecute exec = new Dbexecute();
		return 0;
	}
	
	
	public void setParam(String paramName, Object paramValue) {

		HashMap paramMap = new HashMap();
		paramMap.put("paramName", paramName);
		paramMap.put("paramValue", paramValue);
		this.paramArray.add(paramMap);
	}
	
	
	public ArrayList insBy(String insBy) {

		ArrayList qInsBy = new ArrayList();
		HashMap paramMap = new HashMap();
		paramMap.put("queryTable", "tf_f_clewtrackman");
		paramMap.put("queryString", insBy);
		paramMap.put("queryVarMap", this.paramArray);
		qInsBy.add(paramMap);
		return qInsBy;
	}
	
	
	
	// 分頁查詢
	public ArrayList selByList(String selBy, int iStart, int iCount) {

		Dbexecute exec = new Dbexecute();
		ArrayList dataArray = new ArrayList();
		exec.setStrTable("tf_f_clewtrackman");
		exec.setStrQuery(selBy);
		exec.setParamList(this.paramArray);
		dataArray = exec.selBizQuery(iStart, iCount);
		if (dataArray.size() <= 0)
			return null;
		return dataArray;
	}
	
}