package com.saas.biz.userMgr;

import java.util.ArrayList;

import com.saas.biz.commen.commMethodMgr;
import com.saas.biz.dao.userdetailDAO.*;
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 UserDetailInfo{
	Logger log;

	Buffers inBuffer;

	Buffers outBuffer;

	Dbtable tradeQuery;

	commMethodMgr commen;

	ArrayList queryResult = new ArrayList();

	public UserDetailInfo() {
		log = new Logger(this);
		tradeQuery = new Dbtable();
		commen = new commMethodMgr();
	}

	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 addUserDetailInfo(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("進入updateUserDetailInfo方法...");
		int iResult = -1;
		String work_name = inbuffer.getString("WORK_NAME");
		String home_addr = inbuffer.getString("HOME_ADDR");
		String qq = inbuffer.getString("QQ");
		String blog = inbuffer.getString("BLOG");
		String folk_code = inbuffer.getString("FOLK_CODE");
		String educate_degree_code = inbuffer.getString("EDUCATE_DEGREE_CODE");
		String phone = inbuffer.getString("GROUP_CONTACT_PHONE");
		String post_addr = inbuffer.getString("POST_ADDR");
		String job = inbuffer.getString("JOB");
		String fax = inbuffer.getString("FAX_NBR");
		String post_code = inbuffer.getString("POST_CODE");
		String cust_id=inbuffer.getString("CUST_ID");
		String user_id=inbuffer.getString("USER_ID");
		String cust_name=inbuffer.getString("CUST_NAME");
		String local_native_code=inbuffer.getString("LOCAL_NATIVE_CODE");
		String email=inbuffer.getString("EMAIL");
		String sex=inbuffer.getString("SEX");
		String marriage=inbuffer.getString("MARRIAGE");
		try {
			UserdetailDAO userdetailDAO = new UserdetailDAO();
			userdetailDAO.setWork_name(work_name);
			userdetailDAO.setQq(qq);
			userdetailDAO.setHome_addr(home_addr);
			userdetailDAO.setBlog(blog);
			userdetailDAO.setFolk_code(folk_code);
			userdetailDAO.setFax(fax);
			userdetailDAO.setJob(job);
			userdetailDAO.setEmail(email);
			userdetailDAO.setEducate_degree_code(educate_degree_code);
			userdetailDAO.setPhone(phone);
			userdetailDAO.setPost_addr(post_addr);
			userdetailDAO.setPost_code(post_code);
			userdetailDAO.setUser_id(user_id);
			userdetailDAO.setCust_id(cust_id);
			userdetailDAO.setCust_name(cust_name);
			userdetailDAO.setLocal_native_code(local_native_code);
			userdetailDAO.setSex(sex);
			userdetailDAO.setMarriage(marriage);
			iResult = addUserDetailInfo(userdetailDAO);
		}
		catch (SaasApplicationException e) {
			log.LOG_INFO(e.getMessage());
		}
		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("退出addUserDetailInfo方法...");
	
	}

	public int addUserDetailInfo(UserdetailDAO userdetailDAO) throws SaasApplicationException {
		UserdetailExt userdetailExt = new UserdetailExt();
		userdetailExt.setParam(":VWORK_NAME", userdetailDAO.getWork_name());
		userdetailExt.setParam(":VQQ", userdetailDAO.getQq());
		userdetailExt.setParam(":VHOME_ADDR", userdetailDAO.getHome_addr());
		userdetailExt.setParam(":VBLOG", userdetailDAO.getBlog());
		userdetailExt.setParam(":VFOLK_CODE", userdetailDAO.getFolk_code());
		userdetailExt.setParam(":VFAX", userdetailDAO.getFax());
		userdetailExt.setParam(":VJOB", userdetailDAO.getJob());
		userdetailExt.setParam(":VEDUCATE_DEGREE_CODE", userdetailDAO.getEducate_degree_code());
		userdetailExt.setParam(":VPHONE", userdetailDAO.getPhone());
		userdetailExt.setParam(":VPOST_ADDR", userdetailDAO.getPost_addr());
		userdetailExt.setParam(":VPOST_CODE", userdetailDAO.getPost_code());
		userdetailExt.setParam(":VUSER_ID", userdetailDAO.getUser_id());
		userdetailExt.setParam(":VCUST_ID", userdetailDAO.getCust_id());
		userdetailExt.setParam(":VCUST_NAME", userdetailDAO.getCust_name());
		userdetailExt.setParam(":VEMAIL", userdetailDAO.getEmail());
		userdetailExt.setParam(":VLOCAL_NATIVE_CODE", userdetailDAO.getLocal_native_code());
		userdetailExt.setParam(":VSEX",userdetailDAO.getSex());
		userdetailExt.setParam(":VMARRIAGE",userdetailDAO.getMarriage());
		tradeQuery.executeBy(userdetailExt.insBy("INS_USERDETAIL_BY_CUST"));
		return 0;
	}

	// 修改用戶詳細信息
	public void updateUserDetailInfo(Buffers inbuffer) {
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("進入updateUserDetailInfo方法...");
		int iResult = -1;
		String birthday = inbuffer.getString("BIRTHDAY");
		String pspt_end_date = inbuffer.getString("PSPT_END_DATE");
		String work_name = inbuffer.getString("WORK_NAME");
		String home_addr = inbuffer.getString("HOME_ADDR");
		String qq = inbuffer.getString("QQ");
		String blog = inbuffer.getString("BLOG");
		String folk_code = inbuffer.getString("FOLK_CODE");
		String educate_degree_code = inbuffer.getString("EDUCATE_DEGREE_CODE");
		String phone = inbuffer.getString("GROUP_CONTACT_PHONE");
		String post_addr = inbuffer.getString("POST_ADDR");
		String job = inbuffer.getString("JOB");
		String fax = inbuffer.getString("FAX_NBR");
		String post_code = inbuffer.getString("POST_CODE");
		String cust_id=inbuffer.getString("CUST_ID");
		String user_id=inbuffer.getString("USER_ID");
		String local_native_code=inbuffer.getString("LOCAL_NATIVE_CODE");
		String marriage=inbuffer.getString("MARRIAGE");
		try {
			UserdetailDAO userdetailDAO = new UserdetailDAO();
			userdetailDAO.setBirthday(birthday);
			userdetailDAO.setPspt_end_date(pspt_end_date);
			userdetailDAO.setWork_name(work_name);
			userdetailDAO.setMarriage(marriage);
			userdetailDAO.setQq(qq);
			userdetailDAO.setHome_addr(home_addr);
			userdetailDAO.setBlog(blog);
			userdetailDAO.setFolk_code(folk_code);
			userdetailDAO.setFax(fax);
			userdetailDAO.setJob(job);
			userdetailDAO.setEducate_degree_code(educate_degree_code);
			userdetailDAO.setPhone(phone);
			userdetailDAO.setPost_addr(post_addr);
			userdetailDAO.setPost_code(post_code);
			userdetailDAO.setUser_id(user_id);
			userdetailDAO.setCust_id(cust_id);
			userdetailDAO.setLocal_native_code(local_native_code);
			iResult = updateUserDetailInfo(userdetailDAO);
		}
		catch (SaasApplicationException e) {
			log.LOG_INFO(e.getMessage());
		}
		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("退出addUserDetailInfo方法...");
	}

	public int updateUserDetailInfo(UserdetailDAO userdetailDAO) throws SaasApplicationException {
		UserdetailExt userdetailExt = new UserdetailExt();
		userdetailExt.setParam(":VBIRTHDAY",userdetailDAO.getBirthday());
		userdetailExt.setParam(":VPSPT_END_DATE", userdetailDAO.getPspt_end_date());
		userdetailExt.setParam(":VWORK_NAME", userdetailDAO.getWork_name());
		userdetailExt.setParam(":VQQ", userdetailDAO.getQq());
		userdetailExt.setParam(":VHOME_ADDR", userdetailDAO.getHome_addr());
		userdetailExt.setParam(":VBLOG", userdetailDAO.getBlog());
		userdetailExt.setParam(":VFOLK_CODE", userdetailDAO.getFolk_code());
		userdetailExt.setParam(":VFAX", userdetailDAO.getFax());
		userdetailExt.setParam(":VJOB", userdetailDAO.getJob());
		userdetailExt.setParam(":VPHONE", userdetailDAO.getPhone());
		userdetailExt.setParam(":VPOST_ADDR", userdetailDAO.getPost_addr());
		userdetailExt.setParam(":VPOST_CODE", userdetailDAO.getPost_code());
		userdetailExt.setParam(":VUSER_ID", userdetailDAO.getUser_id());
		userdetailExt.setParam(":VCUST_ID", userdetailDAO.getCust_id());
		userdetailExt.setParam(":VEDUCATE_DEGREE_CODE", userdetailDAO.getEducate_degree_code());
		userdetailExt.setParam(":VMARRIAGE", userdetailDAO.getMarriage());
		userdetailExt.setParam(":VLOCAL_NATIVE_CODE", userdetailDAO.getLocal_native_code());
		tradeQuery.executeBy(userdetailExt.insBy("UPDATE_USERDETAIL_BY_ID"));
		return 0;
	}
	public ArrayList getUserDetailByUserId(String user_id,String cust_id)throws SaasApplicationException{
		UserdetailExt userdetailExt = new UserdetailExt();
		userdetailExt.setParam(":VUSER_ID", user_id);
		userdetailExt.setParam(":VCUST_ID", cust_id);
		ArrayList list=userdetailExt.selByList("SEL_BY_USER_ID");
		return list;
	}
}