newproductattrinfo.java

java阿里巴巴代码

package com.saas.biz.newproductattrMgr;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.StringTokenizer;
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.newproductattrDAO.*;
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 NewProductAttrInfo {
	Logger log;

	Buffers inBuffer;

	Buffers outBuffer;

	Dbtable tradeQuery;

	ArrayList queryResult = new ArrayList();

	public  NewProductAttrInfo() {
		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 AddNewProductAttr(Buffers inbuffer) {

		log.LOG_INFO("进入NewProductAttr方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		log.LOG_INFO("111111111111111");
		String product_id = inbuffer.getString("PRODUCT_ID");
		log.LOG_INFO("product_id======" + product_id);
		String product_class = inbuffer.getString("PRODUCT_CLASS");
		String attr_desc ="";
		String attr_no = "1";
		String rsrv_str1 = inbuffer.getString("RSRV_STR1");
		String enable_tag = "0";
		String remark = "添加产品属性值";
		try {
			NewProductAttrDAO newproductattrdao = new NewProductAttrDAO();
			newproductattrdao.setProduct_id(product_id);
			newproductattrdao.setRsrv_str1(rsrv_str1);
			newproductattrdao.setProduct_class(product_class);
			newproductattrdao.setAttr_desc(attr_desc);
			newproductattrdao.setAttr_no(attr_no);
			newproductattrdao.setEnable_tag(enable_tag);
			newproductattrdao.setRemark(remark);
			iResult = AddNewProductAttr(newproductattrdao);
		}
		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("退出NewProductAttr方法...");
	}
	
	
	public int AddNewProductAttr(NewProductAttrDAO areaDao) throws SaasApplicationException {

		log.LOG_INFO("开始执行SQL:===:");
		String rs = areaDao.getRsrv_str1();
		StringTokenizer st = new StringTokenizer(rs, "|");
		while (st.hasMoreTokens()) {
			String attrobj = st.nextToken();
			String attr_name = attrobj.substring(0, attrobj.indexOf("&"));
			String attr_id = attrobj.substring(attrobj.indexOf("&") + 1, attrobj.indexOf("#"));
			String attr_value = attrobj.substring(attrobj.indexOf("#") + 1, attrobj.length());
			NewProductattrExt areaExt = new NewProductattrExt();
			areaExt.setParam(":VPRODUCT_ID", areaDao.getProduct_id());
			areaExt.setParam(":VPRODUCT_CLASS", areaDao.getProduct_class());
			areaExt.setParam(":VATTR_ID", attr_id);
			areaExt.setParam(":VATTR_NAME", attr_name);
			areaExt.setParam(":VATTR_DESC", areaDao.getAttr_desc());
			areaExt.setParam(":VATTR_NO", areaDao.getAttr_no());
			areaExt.setParam(":VATTR_VALUE", attr_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 product_id)
			throws SaasApplicationException {

		ArrayList relationList = new ArrayList();
		NewProductattrExt relaExt = new NewProductattrExt();
		relaExt.setParam(":VPRODUCT_ID", product_id);
		relationList = relaExt.selByList("SEL_BY_PRODUCT_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 class_id = inbuffer.getString("CLASS_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 {
			NewProductAttrDAO productattrDao = new NewProductAttrDAO();
			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(NewProductAttrDAO productattrDao)
			throws SaasApplicationException {

		NewProductattrExt productattrExt = new NewProductattrExt();
		productattrExt.setParam(":VREMARK", productattrDao.getRemark());

		tradeQuery.executeBy(productattrExt.insBy("UP_PRODUCTATTR_BY_ID"));
		return 0;
	}

	// 删除产品分类属性tf_b_productattr
	public void deleteProductAttrInfo(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入deleteProductAttrInfo方法...");
		int iResult = -1;
		String product_id = inbuffer.getString("PRODUCT_ID");
		try {
			NewProductAttrDAO productattrDao = new NewProductAttrDAO();
			productattrDao.setProduct_id(product_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(NewProductAttrDAO productattrDao)
			throws SaasApplicationException {
		log.LOG_INFO("开始执行SQL:===:");
		NewProductattrExt productExt = new NewProductattrExt();
		productExt.setParam(":VPRODUCT_ID", productattrDao.getProduct_id());
		log.LOG_INFO("开始执行SQL:===:" + productExt.insBy("DEL_PRODUCTATTR_BY_ID"));
		tradeQuery.executeBy(productExt.insBy("DEL_PRODUCTATTR_BY_ID"));
		return 0;
	}

	// 删除产品分类属性值tf_f_productclass
	public void delProductAttrInfo(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入deleteProductAttrInfo方法...");
		int iResult = -1;
		String product_id = inbuffer.getString("PRODUCT_ID");
		try {
			NewProductAttrDAO productattrDao = new NewProductAttrDAO();
			productattrDao.setProduct_id(product_id);
			iResult = delProductAttrInfo(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 delProductAttrInfo(NewProductAttrDAO productattrDao)
			throws SaasApplicationException {

		NewProductattrExt productExt = new NewProductattrExt();
		productExt.setParam(":VPRODUCT_ID", productattrDao.getProduct_id());
		tradeQuery.executeBy(productExt.insBy("DEL_PRO_ATTR_BY_ID"));
		return 0;
	}

	public HashMap getattrById(String cust_id, String attr_id)
			throws SaasApplicationException {
		HashMap map = new HashMap();
		ArrayList relationList = new ArrayList();
		NewProductattrExt relaExt = new NewProductattrExt();
		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;
	}

	public void modiProductAttr(Buffers inbuffer) {

		log.LOG_INFO("进入modiProductAttr方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		String product_id = inbuffer.getString("PRODUCT_ID");
		String rsrv_str1 = inbuffer.getString("RSRV_STR1");
		String remark = "修改产品属性值";
		try {
			NewProductAttrDAO newproductattrdao = new NewProductAttrDAO();
			newproductattrdao.setProduct_id(product_id);
			newproductattrdao.setRsrv_str1(rsrv_str1);
			newproductattrdao.setRemark(remark);
			iResult = modiProductAttr(newproductattrdao);
		}
		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("退出modiProductAttr方法...");
	}
	
	
	public int modiProductAttr(NewProductAttrDAO areaDao) throws SaasApplicationException {

		log.LOG_INFO("开始执行SQL:===:");
		String rs = areaDao.getRsrv_str1();
		StringTokenizer st = new StringTokenizer(rs, "|");
		while (st.hasMoreTokens()) {
			String attrobj = st.nextToken();
			String attr_name = attrobj.substring(0, attrobj.indexOf("&"));
			String attr_id = attrobj.substring(attrobj.indexOf("&") + 1, attrobj.indexOf("#"));
			String attr_value = attrobj.substring(attrobj.indexOf("#") + 1, attrobj.length());
			NewProductattrExt areaExt = new NewProductattrExt();
			areaExt.setParam(":VPRODUCT_ID", areaDao.getProduct_id());
			areaExt.setParam(":VATTR_ID", attr_id);
			areaExt.setParam(":VATTR_NAME", attr_name);
			areaExt.setParam(":VATTR_VALUE", attr_value);
			areaExt.setParam(":VREMARK", areaDao.getRemark());
			log.LOG_INFO("开始执行SQL:===:" + areaExt.insBy("UPDATR_BY_ATTR"));
			tradeQuery.executeBy(areaExt.insBy("UPDATR_BY_ATTR"));
		}
		 
		return 0;
	}
}