/**
 * 險種管理
 */
package com.NCL;

import java.util.*;
import com.sinosoft.common.*;

public class Risk {

	/**
	 * @param args
	 * @author Vincent	 * 
	 */
	protected IndexMap propList;
	protected HashSet Property;
	private List strList = new ArrayList();
	private boolean EOF = false;
	private int COUNT;
	/**
	 * 構造函數
	 *
	 */
	public Risk(){
		propList = new IndexMap();
		Property = new HashSet();
		Property.add("RiskCode");		//險種編碼
		Property.add("ID");				//自增長ID
		Property.add("RiskType");		//險種類型
	}
	/**
	 * 初始化
	 * @param id 自增長ID
	 */
	public void init(String id){
		DBAccess d  = new DBAccess();
		String sql = "SELECT * from Risk where ID=?";
		this.propList = d.init(sql,id,this.Property);	
	}
	/**
	 * 創建
	 * @return boolean
	 */
	public boolean create(){
		DBAccess d = new DBAccess();
		String sql = "INSERT into Risk(RiskCode,RiskType,ID) values(?,?,Riskid_SQE.nextval)";
		return d.execute(sql, this.propList);
	}
	/**
	 * 更新
	 * @return boolean
	 */
	public boolean update(){
		try{
			StringBuffer sql = new StringBuffer("UPDATE Risk set ");
			List l = new ArrayList();
			for(int i=0;i<strList.size();i++){
				Object[] strArray =(Object[]) strList.get(i);
				sql.append(strArray[0]);
				sql.append("=?,");
				l.add(strArray[1]);
			}
			sql.deleteCharAt(sql.lastIndexOf(","));
			sql.append(" where ID=?");
			l.add(this.get("ID"));
			strList.clear();
			DBAccess q = new DBAccess();
			return q.executeUpdate(sql.toString(),l);
		}catch(Exception e){
			e.printStackTrace();
			System.out.println("Risk.update():" + e.getMessage());
			return false;
		}
	}
	/**
	 * 刪除
	 * @param id 自增長ID
	 * @return boolean
	 */
	public boolean delete(String id){
		DBAccess DBA= new DBAccess();
		String SQL = "DELETE from Risk WHERE ID=?";		
		return DBA.executeDelete(SQL,id);
	}
	/**
	 * 根據條件查詢
	 * @param I			對象
	 * @param pageSize	分頁大小
	 * @param pageIndex	分頁頁碼
	 * @return String
	 */
	public String find(Risk I,int pageSize,int pageIndex){
		String result="";
		String RiskCode = I.get("RiskCode");
		String RiskType = I.get("RiskType");
		StringBuffer sql = new StringBuffer("SELECT ID from Risk where 1=1");	
		if(Data.hasValue(RiskCode))
			sql.append(" and RiskCode like ?");
		if(Data.hasValue(RiskType))
			sql.append(" and RiskType=?");
		sql.append(" order by ID desc");
		DBAccess q = new DBAccess();
		result = q.executeQuery(sql.toString(), this.propList, pageSize, pageIndex);
		setCOUNT(q.COUNT);
		setEOF(q.EOF);
		return result;	
	}
	
	/**
	 * 根據RiskType查找所有的RiskCode
	 * @param RiskType 險種類型
	 * @return String
	 */
	public String findRiskCode(String RiskType){
		IndexMap m = new IndexMap();
		m.put("RiskType", RiskType);
		StringBuffer sql = new StringBuffer("SELECT RiskCode from Risk where RiskType=?");	
		DBAccess q = new DBAccess();
		return q.executeQuery(sql.toString(), m, 0, 1);
	}	
	
	/**
	 * 在此映射中關聯指定值與指定鍵
	 * @param name 指定鍵
	 * @param value 指定值
	 */
	public void setUpdateValue(String name,Object value){
		if(this.set(name,value)){
			Object[] uValue = new Object[2];
			uValue[0] = name;
			uValue[1] = value;
			strList.add(uValue);
		}
	}
	/**
	 * 在此映射中關聯指定值與指定鍵
	 * @param name 指定鍵
	 * @param value 指定值
	 */
	public boolean set(String name, Object value){
		if(Property.contains(name)){
			propList.put(name,value);
			return true;
		}else
			return false;		
	}
	/**
	 * 返回指定鍵在此映射中所映射的值
	 * @param name 指定鍵
	 * @return
	 */
	public String get(String name){
		if (Property.contains(name)){
			String value = (String)propList.get(name);
			if(value != null && !value.equals(""))
				return value;
			else
				return "";
		}else 
			return "";
	}
	/**
	 * 返回COUNT
	 * @return int
	 */
	public int getCOUNT() {
		return COUNT;
	}
	/**
	 * 設置COUNT
	 * @param count
	 */
	public void setCOUNT(int count) {
		COUNT = count;
	}
	/**
	 * 返回EOF
	 * @return boolean
	 */
	public boolean isEOF() {
		return EOF;
	}
	/**
	 * 設置EOF
	 * @param eof
	 */
	public void setEOF(boolean eof) {
		EOF = eof;
	}
	/**
	 * 清空propList
	 *
	 */
	public void clear(){
		propList.clear();
	}
}