package com.saas.biz.sitebookMgr;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.Map;

import com.saas.biz.commen.commMethodMgr;
import com.saas.biz.dao.sitebookDAO.SitebookDAO;
import com.saas.biz.dao.sitebookDAO.SitebookExt;
import com.saas.sys.buffer.Buffers;
import com.saas.sys.dbm.Dbtable;
import com.saas.sys.exp.SaasApplicationException;
import com.saas.sys.log.Logger;

public class SiteBookInfo{
	Logger log;

	Buffers inBuffer;

	Buffers outBuffer;

	Dbtable tradeQuery;

	commMethodMgr commen;

	ArrayList queryResult = new ArrayList();

	public SiteBookInfo() {
		log = new Logger(this);
		tradeQuery = new Dbtable();
		commen = new commMethodMgr();
		outBuffer = new Buffers();
	}

	public void setOutBuffer(Buffers outBuffer) {
		this.outBuffer = outBuffer;
	}

	public Buffers getOutBuffer() {
		return this.outBuffer;
	}

	public void setTradeQuery(Dbtable tradeQuery) {
		this.tradeQuery = tradeQuery;
	}

	public Dbtable getTradeQuery() {
		return this.tradeQuery;
	}

	public ArrayList getQueryResult() {
		return this.queryResult;
	}

	public void setQueryResult(ArrayList queryResult) {
		this.queryResult = queryResult;
	}

	// 增加電話記錄
	public void addSiteBookInfo(Buffers inbuffer) {
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("進入addSiteBookInfo方法...");
		int iResult = -1;
		String website = inbuffer.getString("WEBSITE");
		String comment = inbuffer.getString("COMMENT");
		Integer xshare = Integer.parseInt(inbuffer.getString("XSHARE"));
		String recorduser = inbuffer.getString("RECORDUSER");
		String user = inbuffer.getString("SESSION_USER_NAME");
		String part = inbuffer.getString("DEPART_CODE");
		try {
			SitebookDAO telDao = new SitebookDAO(website, comment, xshare, recorduser, part, user);
			iResult = addSiteBookInfo(telDao);
		}
		catch (Exception e) {
			iResult = -1;
		}
		if (iResult != 0) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "業務處理失敗！");
		}
		else {
			this.outBuffer.setInt("RESULT_CODE", 0);
			this.outBuffer.setString("RESULT_INFO", "業務處理成功！");
		}
		log.LOG_INFO("退出addSiteBookInfo方法...");
	}

	public int addSiteBookInfo(SitebookDAO telDao) throws SaasApplicationException {
		SitebookExt telExt = new SitebookExt();
		telExt.setParam(":VWEBSITE", telDao.getWebsite());
		telExt.setParam(":VPART", telDao.getPart());
		telExt.setParam(":VCOMMENT", telDao.getComment());
		telExt.setParam(":VXSHARE", telDao.getXshare());
		telExt.setParam(":VUSER", telDao.getUser());
		telExt.setParam(":VRECORDUSER", telDao.getRecorduser());
		tradeQuery.executeBy(telExt.insBy("INS_BY_ALL"));
		return 0;
	}

	// 修改電話本
	public void updateSiteBookInfo(Buffers inbuffer) {
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("進入updateSiteBookInfo方法...");
		int iResult = -1;
		String id = inbuffer.getString("ID");
		String website = inbuffer.getString("WEBSITE");
		String comment = inbuffer.getString("COMMENT");
		Integer xshare = Integer.parseInt(inbuffer.getString("XSHARE"));
		String recorduser = inbuffer.getString("RECORDUSER");
		try {
			SitebookDAO telDao = new SitebookDAO();
			telDao.setId(Integer.parseInt(id));
			telDao.setComment(comment);
			telDao.setWebsite(website);
			telDao.setRecorduser(recorduser);
			telDao.setXshare(xshare);
			iResult = updateSiteBookInfo(telDao);
		}
		catch (Exception e) {
			iResult = -1;
		}
		if (iResult != 0) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "業務處理失敗！");
		}
		else {
			this.outBuffer.setInt("RESULT_CODE", 0);
			this.outBuffer.setString("RESULT_INFO", "業務處理成功！");
		}
		log.LOG_INFO("退出updateSiteBookInfo方法...");
	}

	public int updateSiteBookInfo(SitebookDAO telDao) throws SaasApplicationException {
		SitebookExt telExt = new SitebookExt();
		telExt.setParam(":VID", telDao.getId());
		telExt.setParam(":VWEBSITE", telDao.getWebsite());
		telExt.setParam(":VCOMMENT", telDao.getComment());
		telExt.setParam(":VXSHARE", telDao.getXshare());
		telExt.setParam(":VRECORDUSER", telDao.getRecorduser());
		tradeQuery.executeBy(telExt.insBy("UPDATE_BY_ID"));
		return 0;
	}

	// 刪除電話記錄
	public void deleteSiteBookInfo(Buffers inbuffer) {
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("進入deleteSiteBookInfo方法...");
		int iResult = -1;
		String id = inbuffer.getString("ID");
		try {
			iResult = deleteSiteBookInfo(id);
		}
		catch (Exception e) {
			iResult = -1;
		}
		if (iResult != 0) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "業務處理失敗！");
		}
		else {
			this.outBuffer.setInt("RESULT_CODE", 0);
			this.outBuffer.setString("RESULT_INFO", "業務處理成功！");
		}
		log.LOG_INFO("退出deleteSiteBookInfo方法...");
	}

	public int deleteSiteBookInfo(String id) throws SaasApplicationException {
		SitebookExt telExt = new SitebookExt();
		telExt.setParam(":VID", id);
		tradeQuery.executeBy(telExt.insBy("DELETE_BY_ID"));
		return 0;
	}

	public ArrayList getSiteBookByUser(String user) throws SaasApplicationException {
		ArrayList list = new ArrayList();
		SitebookExt telExt = new SitebookExt();
		telExt.setParam(":VUSER", user);
		list = telExt.selByList("SEL_BY_USER");
		return list;
	}

	public ArrayList getSiteBookById(String id) throws SaasApplicationException {
		ArrayList list = new ArrayList();
		SitebookExt telExt = new SitebookExt();
		telExt.setParam(":VID", id);
		list = telExt.selByList("SEL_BY_ID");
		return list;
	}

	@SuppressWarnings("unchecked")
	public Map getSiteBookByMap(String id) throws SaasApplicationException {
		Map map = new HashMap();
		ArrayList list = getSiteBookById(id);
		String website = "";
		String comment = "";
		String recorduser = "";
		if (list != null && list.size() > 0) {
			HashMap telMpa = (HashMap) list.get(0);
			website = telMpa.get("website").toString();
			comment = telMpa.get("comment").toString();
			recorduser = telMpa.get("recorduser").toString();
		}
		map.put("website", website);
		map.put("comment", comment);
		map.put("recorduser", recorduser);
		return map;
	}
}