package com.saas.biz.addproductattrMgr;

import java.util.ArrayList;
import java.util.HashMap;
import net.sf.json.JSONArray;
import com.saas.biz.JavaScriptObject.TreeNode;
import com.saas.biz.JavaScriptObject.TreeObject;
import com.saas.biz.commen.commMethodMgr;
import com.saas.biz.dao.addproductattrDAO.AddProductAttrDAO;
import com.saas.biz.dao.addproductattrDAO.AddProductAttrExt;
import com.saas.biz.dao.relationccDAO.RelationCcExt;
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 AddProductAttrInfo {
	Logger log;

	Buffers inBuffer;

	Buffers outBuffer;

	Dbtable tradeQuery;

	ArrayList queryResult = new ArrayList();

	public AddProductAttrInfo() {
		log = new Logger(this);
		tradeQuery = new Dbtable();
		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 AddProductAttr(Buffers inbuffer) {
		log.LOG_INFO("進入AddProductAttr方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String class_id = inbuffer.getString("CLASS_ID");
		String attr_id = inbuffer.getString("ATTR_ID");
		String attr_name = inbuffer.getString("ATTR_NAME");
		String attr_desc = inbuffer.getString("ATTR_DESC");
		String attr_no = inbuffer.getString("ATTR_NO");
		String default_tag = inbuffer.getString("DEFAULT_TAG");
		String default_value = inbuffer.getString("DEFAULT_VALUE");
		String enable_tag = inbuffer.getString("ENABLE_TAG");
		String remark = inbuffer.getString("REMARK");
		try {
			AddProductAttrDAO addproductattrdao = new AddProductAttrDAO();
			addproductattrdao.setCust_id(cust_id);
			addproductattrdao.setClass_id(class_id);
			addproductattrdao.setAttr_id(attr_id);
			addproductattrdao.setAttr_name(attr_name);
			addproductattrdao.setAttr_desc(attr_desc);
			addproductattrdao.setAttr_no(attr_no);
			addproductattrdao.setDefault_tag(default_tag);
			addproductattrdao.setDefault_value(default_value);
			addproductattrdao.setEnable_tag(enable_tag);
			addproductattrdao.setRemark(remark);
			iResult = AddProductAttr(addproductattrdao);
		} catch (Exception 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("退出AddProductAttr方法...");
	}

	public int AddProductAttr(AddProductAttrDAO areaDao)
			throws SaasApplicationException {

		AddProductAttrExt areaExt = new AddProductAttrExt();
		log.LOG_INFO("開始執行SQL:===:");
		areaExt.setParam(":VCUST_ID", areaDao.getCust_id());
		areaExt.setParam(":VCLASS_ID", areaDao.getClass_id());
		areaExt.setParam(":VATTR_ID", areaDao.getAttr_id());
		areaExt.setParam(":VATTR_NAME", areaDao.getAttr_name());
		areaExt.setParam(":VATTR_DESC", areaDao.getAttr_desc());
		areaExt.setParam(":VATTR_NO", areaDao.getAttr_no());
		areaExt.setParam(":VDEFAULT_TAG", areaDao.getDefault_tag());
		areaExt.setParam(":VDEFAULT_VALUE", areaDao.getDefault_value());
		areaExt.setParam(":VENABLE_TAG", areaDao.getEnable_tag());
		areaExt.setParam(":VREMARK", areaDao.getRemark());
		log.LOG_INFO("開始執行SQL:===:" + areaExt.insBy("ADD_BY_ATTR"));
		tradeQuery.executeBy(areaExt.insBy("ADD_BY_ATTR"));
		return 0;
	}

	public ArrayList getProductById(String cust_id, String class_id)
			throws SaasApplicationException {

		ArrayList relationList = new ArrayList();
		AddProductAttrExt relaExt = new AddProductAttrExt();
		relaExt.setParam(":VCUST_ID", cust_id);
		relaExt.setParam(":VCLASS_ID", class_id);
		relationList = relaExt.selByList("SEL_BY_CLASS_ID");
		return relationList;
	}

	// 修改產品分類屬性
	public void modifyproductattrInfo(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("進入modifyproductattrInfo方法...");
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String attr_id = inbuffer.getString("ATTR_ID");
		String attr_name = inbuffer.getString("ATTR_NAME");
		String attr_no = inbuffer.getString("ATTR_NO");
		String default_value = inbuffer.getString("DEFAULT_VALUE");
		String attr_desc = inbuffer.getString("ATTR_DESC");
		String remark = inbuffer.getString("REMARK");
		try {
			AddProductAttrDAO productattrDao = new AddProductAttrDAO();
			productattrDao.setCust_id(cust_id);
			productattrDao.setAttr_id(attr_id);
			productattrDao.setAttr_name(attr_name);
			productattrDao.setAttr_no(attr_no);
			productattrDao.setDefault_value(default_value);
			productattrDao.setAttr_desc(attr_desc);
			productattrDao.setRemark(remark);

			iResult = modifyproductattrInfo(productattrDao);
		} catch (Exception 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("退出modifyproductattrInfo方法...");
	}

	public int modifyproductattrInfo(AddProductAttrDAO productattrDao)
			throws SaasApplicationException {

		AddProductAttrExt productattrExt = new AddProductAttrExt();
		log.LOG_INFO("開始執行SQL:===:");
		productattrExt.setParam(":VCUST_ID", productattrDao.getCust_id());
		productattrExt.setParam(":VATTR_ID", productattrDao.getAttr_id());
		productattrExt.setParam(":VATTR_NAME", productattrDao.getAttr_name());
		productattrExt.setParam(":VATTR_NO", productattrDao.getAttr_no());
		productattrExt.setParam(":VDEFAULT_VALUE", productattrDao.getDefault_value());
		productattrExt.setParam(":VATTR_DESC", productattrDao.getAttr_desc());
		productattrExt.setParam(":VREMARK", productattrDao.getRemark());
		log.LOG_INFO("開始執行SQL:===:" + productattrExt.insBy("UP_PRODUCTATTR_BY_ID"));
		tradeQuery.executeBy(productattrExt.insBy("UP_PRODUCTATTR_BY_ID"));
		return 0;
	}

	// 刪除產品分類屬性資料
	public void deleteProductAttrInfo(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("進入deleteProductAttrInfo方法...");
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String attr_id = inbuffer.getString("ATTR_ID");
		try {
			AddProductAttrDAO productattrDao = new AddProductAttrDAO();
			productattrDao.setCust_id(cust_id);
			productattrDao.setAttr_id(attr_id);
			iResult = deleteProductAttrInfo(productattrDao);
		} catch (Exception 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("退出deleteProductAttrInfo方法...");
	}

	public int deleteProductAttrInfo(AddProductAttrDAO productattrDao)
			throws SaasApplicationException {

		AddProductAttrExt productExt = new AddProductAttrExt();
		productExt.setParam(":VCUST_ID", productattrDao.getCust_id());
		productExt.setParam(":VATTR_ID", productattrDao.getAttr_id());
		tradeQuery.executeBy(productExt.insBy("DEL_PRODUCTATTR_BY_ID"));
		return 0;
	}

	public HashMap getattrById(String cust_id, String attr_id)
			throws SaasApplicationException {
		HashMap map = new HashMap();
		ArrayList relationList = new ArrayList();
		AddProductAttrExt relaExt = new AddProductAttrExt();
		relaExt.setParam(":VCUST_ID", cust_id);
		relaExt.setParam(":VATTR_ID", attr_id);
		relationList = relaExt.selByList("SEL_BY_ATTR_ID");
		if (relationList != null && relationList.size() > 0) {
			map = (HashMap) relationList.get(0);
		}
		return map;
	}

}