/*
 * 作者:劉云云
 * 時間:2007年12月22日
 * 功能:平臺基礎信息維護-商業類型的添加和刪除修改（數據庫接口）。
 */
package com.mole.struts.dao;

import java.util.ArrayList;
import java.util.Iterator;

import com.mole.struts.bean.AdminStoreTypeBean;

public class AdminStoreTypeDAO extends AbstractPageDAO {

	public AdminStoreTypeDAO() {
	}

	public AdminStoreTypeDAO(String column, String where, String id,
			String group, String order, int pageSize) {
		this.setColumnCondition(column);
		this.setWhereCondition(where);
		this.setIdCondition(id);
		this.setGroupCondition(group);
		this.setOrderCondition(order);
		this.setPageSize(pageSize);
	}

	// 獲取商業類型記錄集
	public AdminStoreTypeBean[] getStoreTypePage() {
		ArrayList<Object[]> arrayList = this.executeQuery(getSql());
		if (arrayList == null)
			return null;

		AdminStoreTypeBean[] records = new AdminStoreTypeBean[arrayList.size()];
		if (records.length == 0)
			return records;

		Iterator<Object[]> it = arrayList.iterator();
		int i = 0;
		while (it.hasNext()) {
			Object[] obj = it.next();
			AdminStoreTypeBean record = new AdminStoreTypeBean();
			record.setId(obj[0].toString());
			record.setName(obj[1].toString());
			record.setDescription(obj[2].toString());
			records[i++] = record;
		}
		return records;
	}

	// 獲取商業類型一條記錄
	public AdminStoreTypeBean getStoreTypeInfo(String sql) {
		ArrayList<Object[]> arrayList = this.executeQuery(sql);
		if (arrayList == null)
			return null;
		AdminStoreTypeBean record = null;
		Iterator<Object[]> it = arrayList.iterator();
		while (it.hasNext()) {
			Object[] obj = it.next();
			record = new AdminStoreTypeBean();
			record.setId(obj[0].toString());
			record.setName(obj[1].toString());
			record.setDescription(obj[2].toString());
		}
		return record;
	}
}