package com.saas.biz.dao.cmdStateDAO;

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 CmdStateExt extends CmdStateDAO{

	CmdStateDAO valuelistdao;
	Logger log;
	ArrayList updArray;
	ArrayList paramArray;
	public CmdStateExt()
	{
		valuelistdao = new CmdStateDAO();
		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_cmdstate");
		exec.setStrQuery(selBy);
		exec.setParamList(this.paramArray);
		dataArray =  exec.selBizQuery();
		if (dataArray.size()<=0) return null;
		return dataArray;
	}
	
	public CmdStateDAO selByInfo(String selBy)
	{
		Dbexecute exec = new Dbexecute();
		commMethodMgr commen = new commMethodMgr();
		Logger log  = new Logger(this);
		ArrayList dataArray = new ArrayList();
		exec.setStrTable("tf_f_cmdstate");
		exec.setStrQuery(selBy);
		exec.setParamList(this.paramArray);
		dataArray = exec.selBizQuery();
		if (dataArray.size()<=0) return null;
		CmdStateDAO  AddProductAttrDAO = new CmdStateDAO();
		Field[] fields = AddProductAttrDAO.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(AddProductAttrDAO, 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(AddProductAttrDAO, 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 AddProductAttrDAO;
	}
	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_cmdstate");
		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_cmdstate");
    	exec.setStrQuery(selBy);
    	exec.setParamList(this.paramArray);
    	dataArray =  exec.selBizQuery(iStart,iCount);
    	if (dataArray.size()<=0) return null;
    	return dataArray;
    }	
}