package com.saas.biz.dao.prcreditDAO;


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 ParacreditExt extends ParacreditDAO{
		ParacreditDAO paracreditDAO;
		Logger log;
		ArrayList updArray;
		ArrayList paramArray;
		public ParacreditExt ()
		{
			paracreditDAO = new ParacreditDAO();
			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_customer");
			exec.setStrQuery(selBy);
			exec.setParamList(this.paramArray);
			dataArray =  exec.selBizQuery();
			if (dataArray.size()<=0) return null;
			return dataArray;
		}
		
		public ParacreditDAO selByInfo(String selBy)
		{
			Dbexecute exec = new Dbexecute();
			commMethodMgr commen = new commMethodMgr();
			Logger log  = new Logger(this);
			ArrayList dataArray = new ArrayList();
			exec.setStrTable("tf_f_customer");
			exec.setStrQuery(selBy);
			exec.setParamList(this.paramArray);
			dataArray = exec.selBizQuery();
			if (dataArray.size()<=0) return null;
			ParacreditDAO  paracreditDAO = new ParacreditDAO();
			Field[] fields = paracreditDAO.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(paracreditDAO, 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(paracreditDAO, 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 paracreditDAO;
		}
		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_customer");
			paramMap.put("queryString", insBy);
			paramMap.put("queryVarMap", this.paramArray);
			qInsBy.add(paramMap);
			return qInsBy;
		}
		
	}