?? newproductattrinfo.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", "業務處理失?。?quot;);
} 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", "業務處理失?。?quot;);
}
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;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -