?? objectattrinfo.java
字號:
package com.saas.biz.objectattrMgr;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import java.util.StringTokenizer;
import com.saas.biz.dao.objectattrDAO.ObjectattrExt;
import com.saas.biz.dao.productDAO.ProductDAO;
import com.saas.biz.dao.productDAO.ProductExt;
import com.saas.biz.dao.productattrDAO.ProductattrExt;
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 Objectattrinfo {
Dbtable tradeQuery;
Logger log;
Buffers inBuffer;
Buffers outBuffer;
ArrayList queryResult = new ArrayList();
public Objectattrinfo()
{
log = new Logger(this);
tradeQuery = new Dbtable();
}
public void setTradeQuery(Dbtable tradeQuery)
{
this.tradeQuery = tradeQuery;
}
public Dbtable getTradeQuery()
{
return this.tradeQuery;
}
public void setOutBuffer(Buffers outBuffer)
{
this.outBuffer = outBuffer;
}
public Buffers getOutBuffer()
{
return this.outBuffer;
}
public ArrayList getQueryResult()
{
return this.queryResult;
}
public void setQueryResult(ArrayList queryResult)
{
this.queryResult = queryResult;
}
public void addObjectattrInfo(Buffers inbuffer)
{
log.LOG_INFO("進入addObjectattrInfo方法...");
this.outBuffer = inbuffer;
this.inBuffer = inbuffer;
int iResult = -1;
String str_attr =inbuffer.getString("STR_ATTR");
String product_id =inbuffer.getString("SPEC_ROOT_ID");
try
{
iResult = addObjectattrInfo(str_attr,product_id);
}
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("退出addObjectattrInfo方法...");
}
/*
* add by sjp date 2007-06-25
*/
public int addObjectattrInfo(String strStrAttr,String product_id) throws SaasApplicationException
{
if(strStrAttr.equals("")) return 0;
String[] Attr = strToStrArrayManager(strStrAttr,"|");
for(int i=0;i<Attr.length;i++)
{
ObjectattrExt objectattrExt =new ObjectattrExt();
String nameAvaule = Attr[i];
log.LOG_INFO("nameAvaule............................"+nameAvaule);
String[] NaVstr = strToStrArrayManager(nameAvaule,":");
String attr_id ="";
String attr_name="";
String attr_desc="";
String attr_no ="";
ProductattrExt productattrExt = new ProductattrExt();
ArrayList pro = new ArrayList();
String tempname = NaVstr[0];
String realvalue =NaVstr[1];
log.LOG_INFO("tempname..........."+tempname);
productattrExt.setParam(":VRSRV_STR4", tempname);
pro = productattrExt.selByList("SEL_BY_NAME");
Iterator it = pro.iterator();
HashMap tempmap = (HashMap)it.next();
attr_id = tempmap.get("attr_id").toString();
attr_name =tempmap.get("attr_name").toString();
log.LOG_INFO("attr_name..............."+attr_name);
if(tempmap.get("attr_desc")!=null)
{
attr_desc =tempmap.get("attr_desc").toString();
}
if(tempmap.get("attr_no")!=null)
{
attr_no =tempmap.get("attr_no").toString();
}
objectattrExt.setParam(":VROOT_ID", product_id);
objectattrExt.setParam(":VATTR_ID", attr_id);
objectattrExt.setParam(":VCLASS_TYPE", "0");
objectattrExt.setParam(":VATTR_NAME", attr_name);
objectattrExt.setParam(":VATTR_DESC", attr_desc);
objectattrExt.setParam(":VATTR_NO", attr_no);
objectattrExt.setParam(":VATTR_VALUE", realvalue);
objectattrExt.setParam(":VRSRV_STR1", "");
objectattrExt.setParam(":VRSRV_STR2", "");
objectattrExt.setParam(":VRSRV_STR3", "");
objectattrExt.setParam(":VRSRV_STR4", "");
objectattrExt.setParam(":VRSRV_STR5", "");
objectattrExt.setParam(":VRSRV_STR6", "");
objectattrExt.setParam(":VRSRV_STR7", "");
objectattrExt.setParam(":VRSRV_STR8", "");
objectattrExt.setParam(":VRSRV_STR9", "");
objectattrExt.setParam(":VRSRV_STR10", "");
objectattrExt.setParam(":VREMARK", "");
tradeQuery.executeBy(objectattrExt.insBy("INS_BY_ALL"));
}
return 0;
}
/*
* 分割字符串
*/
private static String[] strToStrArrayManager(String str,String separator) {
StringTokenizer strTokens = new StringTokenizer(str, separator);
String[] strArray = new String[strTokens.countTokens()];
int i = 0;
while (strTokens.hasMoreTokens()) {
strArray[i] = strTokens.nextToken().trim();
i++;
}
return strArray;
}
/**
* 通過產品的Id找出屬于它的屬性
*/
public void getProductProperty(Buffers inbuffer)
{
outBuffer = inbuffer;
log.LOG_INFO("進入getProductProperty方法...");
String strProductId = inbuffer.getString("PRODUCT_ID");
try
{
this.queryResult = getProductProperty(strProductId);
}
catch (SaasApplicationException e)
{
log.LOG_INFO(e.getMessage());
}
log.LOG_INFO("退出getProductProperty方法...");
}
public ArrayList getProductProperty(String strProductId) throws SaasApplicationException
{
ArrayList productList = new ArrayList();
ObjectattrExt productExt = new ObjectattrExt();
productExt.setParam(":VROOT_ID",strProductId);
productList = productExt.selByList("SEL_PROPERTY_BY_IDX");
return productList;
}
/**
* 修改產品的屬性
*/
public void updateObjectAttrInfo(Buffers inbuffer)
{
log.LOG_INFO("進入updateObjectAttrInfo方法...");
this.outBuffer = inbuffer;
this.inBuffer = inbuffer;
Integer time=Integer.parseInt(inbuffer.getString("RSRV_NUM1"));
if(time.intValue()>0)
{
for (int i=0;i<time.intValue();i++)
{
String attr_value =inbuffer.getString("RSRV_STR"+i);
String attr_id =inbuffer.getString("RSRV_IDX"+i);
try
{
updateObjectAttrInfo(attr_value,attr_id);
}
catch (SaasApplicationException e)
{
log.LOG_INFO("更新產品屬性出現異常..."+i);
}
}
}
log.LOG_INFO("退出updateObjectAttrInfo方法...");
}
public void updateObjectAttrInfo(String attr_value,String attr_id) throws SaasApplicationException
{
ObjectattrExt productExt = new ObjectattrExt();
productExt.setParam(":VATTR_ID", attr_id);
productExt.setParam(":VATTR_VALUE", attr_value);
tradeQuery.executeBy(productExt.insBy("UPDATE_PROPERTY_BY_IDX"));
}
//增加產品的屬性
public void addProductAttribute(Buffers inbuffer)
{
log.LOG_INFO("進入addProductAttribute方法...");
this.outBuffer = inbuffer;
this.inBuffer = inbuffer;
Integer time=Integer.parseInt(inbuffer.getString("RSRV_NUM1"));
String root_id=inbuffer.getString("ROOT_ID");
if(time.intValue()>0)
{
for (int i=0;i<time.intValue();i++)
{
String attr_value =inbuffer.getString("RSRV_STR"+i);
String attr_id =inbuffer.getString("RSRV_IDX"+i);
try
{
String attrName=getProductAttrName(attr_id);
addProductAttribute(attr_value,attr_id,root_id,attrName);
}
catch (SaasApplicationException e)
{
log.LOG_INFO("更新產品屬性出現異常..."+i);
}
}
}
log.LOG_INFO("退出addProductAttribute方法...");
}
public void addProductAttribute(String attr_value,String attr_id,String root_id,String attr_name) throws SaasApplicationException
{
ObjectattrExt objectattrExt = new ObjectattrExt();
objectattrExt.setParam(":VROOT_ID", root_id);
objectattrExt.setParam(":VATTR_ID", attr_id);
objectattrExt.setParam(":VCLASS_TYPE", "0");
objectattrExt.setParam(":VATTR_NAME", attr_name);
objectattrExt.setParam(":VATTR_DESC", "");
objectattrExt.setParam(":VATTR_NO", "0");
objectattrExt.setParam(":VATTR_VALUE", attr_value);
objectattrExt.setParam(":VRSRV_STR1", "");
objectattrExt.setParam(":VRSRV_STR2", "");
objectattrExt.setParam(":VRSRV_STR3", "");
objectattrExt.setParam(":VRSRV_STR4", "");
objectattrExt.setParam(":VRSRV_STR5", "");
objectattrExt.setParam(":VRSRV_STR6", "");
objectattrExt.setParam(":VRSRV_STR7", "");
objectattrExt.setParam(":VRSRV_STR8", "");
objectattrExt.setParam(":VRSRV_STR9", "");
objectattrExt.setParam(":VRSRV_STR10", "");
objectattrExt.setParam(":VREMARK", "");
tradeQuery.executeBy(objectattrExt.insBy("INS_BY_ALL"));
}
//獲取屬性名稱
public String getProductAttrName(String attr_id)throws SaasApplicationException
{
String attr_name="";
ProductattrExt productattrExt = new ProductattrExt();
ArrayList attrList=new ArrayList();
productattrExt.setParam(":VATTR_ID",attr_id);
attrList=productattrExt.selByList("SEL_BY_ID");
if(attrList !=null && attrList.size()>0)
{
HashMap map=(HashMap)attrList.get(0);
if(map.get("attr_name")!=null)
{
attr_name=map.get("attr_name").toString();
}
}
return attr_name;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -