pleaseresultinfo.java

java阿里巴巴代码

package com.saas.biz.pleaseResultMgr;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.StringTokenizer;

import com.saas.biz.commen.commMethodMgr;
import com.saas.biz.dao.pleaseresultDAO.PleaseresultDAO;
import com.saas.biz.dao.pleaseresultDAO.PleaseresultExt;
import com.saas.sys.buffer.Buffers;
import com.saas.sys.dbm.Dbtable;
import com.saas.sys.exp.SaasApplicationException;
import com.saas.sys.log.Logger;

/**
 * @author:LiuYang
 * @desc:满意度调查结果[tf_f_pleaseresult]
 * @2008-3-3
 */
public class PleaseResultInfo {
	
	
	Dbtable tradeQuery;
	
	
	commMethodMgr comm;
	
	
	Logger log;
	
	
	Buffers inBuffer;
	
	
	Buffers outBuffer;
	
	
	ArrayList queryResult = new ArrayList();
	
	
	
	public PleaseResultInfo() {

		log = new Logger(this);
		tradeQuery = new Dbtable();
		comm = new commMethodMgr();
	}
	
	
	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;
	}
	
	
	
	// 满意度调查[ENABLE_TAG 0 有效 1 无效]
	public void addPleaseResultInfo(Buffers inbuffer) {

		log.LOG_INFO("进入addPleaseResultInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		String trade_id = inbuffer.getString("TRADE_ID");
		String cust_id = inbuffer.getString("CUST_ID");
		String table_id = inbuffer.getString("TABLE_ID");
		String table_name = inbuffer.getString("TABLE_NAME");
		String items_id = inbuffer.getString("ITEMS_ID");
		String re_value = inbuffer.getString("DEFAULT_VALUE");
		String num_value = inbuffer.getString("NUM_VALUE");
		String enable_tag = inbuffer.getString("ENABLE_TAG");
		String res_name = inbuffer.getString("RES_NAME");
		String res_user_id = inbuffer.getString("RES_USER_ID");
		String res_date = inbuffer.getString("RES_DATE");
		String res_addr = inbuffer.getString("RES_ADDR");
		String res_type = inbuffer.getString("RES_TYPE");
		String user_name = inbuffer.getString("USER_NAME");
		String user_id = inbuffer.getString("USER_ID");
		String res_content = inbuffer.getString("CONTENT");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		String remark2 = inbuffer.getString("REMARK2");
		
		try {
			
			StringTokenizer st = new StringTokenizer(items_id, "|");
			List<String> numList = new ArrayList<String>();
			List<String> revList = new ArrayList<String>();
			StringTokenizer num = new StringTokenizer(num_value, "|");
			while (num.hasMoreTokens()) {
				numList.add(num.nextToken());
			}
			StringTokenizer rev = new StringTokenizer(re_value, ",");
			while (rev.hasMoreTokens()) {
				revList.add(rev.nextToken());
			}
			int index = 0;
			while (st.hasMoreTokens()) {
				String itemid = st.nextToken();
				PleaseresultDAO pleaseDao = new PleaseresultDAO();
				pleaseDao.setTrade_id(trade_id);
				pleaseDao.setCust_id(cust_id);
				pleaseDao.setTable_id(table_id);
				pleaseDao.setTable_name(table_name);
				pleaseDao.setItems_id(itemid);
				pleaseDao.setRe_value(revList.get(index));
				pleaseDao.setNum_value(numList.get(index));
				pleaseDao.setEnable_tag(enable_tag);
				pleaseDao.setRes_name(res_name);
				pleaseDao.setRes_user_id(res_user_id);
				pleaseDao.setRes_date(res_date);
				pleaseDao.setRes_addr(res_addr);
				pleaseDao.setRes_type(res_type);
				pleaseDao.setUser_id(user_id);
				pleaseDao.setUser_name(user_name);
				pleaseDao.setRes_content(res_content);
				pleaseDao.setOper_user_id(oper_user_id);
				pleaseDao.setRemark2(remark2);
				
				iResult = addPleaseResultInfo(pleaseDao);
				index++;
			}
		}
		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("退出addPleaseResultInfo方法...");
	}
	
	
	public int addPleaseResultInfo(PleaseresultDAO pleaseDao) throws SaasApplicationException {

		PleaseresultExt pleaseExt = new PleaseresultExt();
		pleaseExt.setParam(":VTRADE_ID", pleaseDao.getTrade_id());
		pleaseExt.setParam(":VCUST_ID", pleaseDao.getCust_id());
		pleaseExt.setParam(":VTABLE_ID", pleaseDao.getTable_id());
		pleaseExt.setParam(":VTABLE_NAME", pleaseDao.getTable_name());
		pleaseExt.setParam(":VITEMS_ID", pleaseDao.getItems_id());
		pleaseExt.setParam(":VRE_VALUE", pleaseDao.getRe_value());
		pleaseExt.setParam(":VNUM_VALUE", pleaseDao.getNum_value());
		pleaseExt.setParam(":VENABLE_TAG", pleaseDao.getEnable_tag());
		pleaseExt.setParam(":VRES_NAME", pleaseDao.getRes_name());
		pleaseExt.setParam(":VRES_USER_ID", pleaseDao.getRes_user_id());
		pleaseExt.setParam(":VRES_DATE", pleaseDao.getRes_date());
		pleaseExt.setParam(":VRES_ADDR", pleaseDao.getRes_addr());
		pleaseExt.setParam(":VRES_TYPE", pleaseDao.getRes_type());
		pleaseExt.setParam(":VUSER_ID", pleaseDao.getUser_id());
		pleaseExt.setParam(":VUSER_NAME", pleaseDao.getUser_name());
		pleaseExt.setParam(":VRES_CONTENT", pleaseDao.getRes_content());
		pleaseExt.setParam(":VOPER_USER_ID", pleaseDao.getOper_user_id());
		pleaseExt.setParam(":VREMARK2", pleaseDao.getRemark2());
		tradeQuery.executeBy(pleaseExt.insBy("INS_BY_ALL"));
		return 0;
	}
	
	
	
	// 满意度调查[ENABLE_TAG 0 有效 1 无效]
	public void editPleaseResultInfo(Buffers inbuffer) {

		log.LOG_INFO("进入editPleaseResultInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		String cust_id = inbuffer.getString("CUST_ID");
		String trade_id = inbuffer.getString("TRADE_ID");
		String table_id = inbuffer.getString("TABLE_ID");
		String table_name = inbuffer.getString("TABLE_NAME");
		String items_id = inbuffer.getString("ITEMS_ID");
		String re_value = inbuffer.getString("DEFAULT_VALUE");
		String num_value = inbuffer.getString("NUM_VALUE");
		String enable_tag = inbuffer.getString("ENABLE_TAG");
		String res_name = inbuffer.getString("RES_NAME");
		String res_user_id = inbuffer.getString("RES_USER_ID");
		String res_date = inbuffer.getString("RES_DATE");
		String res_addr = inbuffer.getString("RES_ADDR");
		String res_type = inbuffer.getString("RES_TYPE");
		String user_name = inbuffer.getString("USER_NAME");
		String user_id = inbuffer.getString("USER_ID");
		String res_content = inbuffer.getString("CONTENT");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		String remark2 = inbuffer.getString("REMARK2");
		
		try {
			StringTokenizer st = new StringTokenizer(items_id, "|");
			List<String> numList = new ArrayList<String>();
			List<String> revList = new ArrayList<String>();
			StringTokenizer num = new StringTokenizer(num_value, "|");
			while (num.hasMoreTokens()) {
				numList.add(num.nextToken());
			}
			StringTokenizer rev = new StringTokenizer(re_value, ",");
			while (rev.hasMoreTokens()) {
				revList.add(rev.nextToken());
			}
			int index = 0;
			while (st.hasMoreTokens()) {
				String itemid = st.nextToken();
				PleaseresultDAO pleaseDao = new PleaseresultDAO();
				pleaseDao.setTrade_id(trade_id);
				pleaseDao.setCust_id(cust_id);
				pleaseDao.setTable_id(table_id);
				pleaseDao.setTable_name(table_name);
				pleaseDao.setItems_id(itemid);
				pleaseDao.setRe_value(revList.get(index));
				pleaseDao.setNum_value(numList.get(index));
				pleaseDao.setEnable_tag(enable_tag);
				pleaseDao.setRes_name(res_name);
				pleaseDao.setRes_user_id(res_user_id);
				pleaseDao.setRes_date(res_date);
				pleaseDao.setRes_addr(res_addr);
				pleaseDao.setRes_type(res_type);
				pleaseDao.setUser_id(user_id);
				pleaseDao.setUser_name(user_name);
				pleaseDao.setRes_content(res_content);
				pleaseDao.setOper_user_id(oper_user_id);
				pleaseDao.setRemark2(remark2);
				
				iResult = editPleaseResultInfo(pleaseDao);
				index++;
			}
		}
		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("退出editPleaseResultInfo方法...");
	}
	
	
	public int editPleaseResultInfo(PleaseresultDAO pleaseDao) throws SaasApplicationException {

		PleaseresultExt pleaseExt = new PleaseresultExt();
		pleaseExt.setParam(":VTRADE_ID", pleaseDao.getTrade_id());
		pleaseExt.setParam(":VCUST_ID", pleaseDao.getCust_id());
		pleaseExt.setParam(":VTABLE_ID", pleaseDao.getTable_id());
		pleaseExt.setParam(":VTABLE_NAME", pleaseDao.getTable_name());
		pleaseExt.setParam(":VITEMS_ID", pleaseDao.getItems_id());
		pleaseExt.setParam(":VRE_VALUE", pleaseDao.getRe_value());
		pleaseExt.setParam(":VNUM_VALUE", pleaseDao.getNum_value());
		pleaseExt.setParam(":VENABLE_TAG", pleaseDao.getEnable_tag());
		pleaseExt.setParam(":VRES_NAME", pleaseDao.getRes_name());
		pleaseExt.setParam(":VRES_USER_ID", pleaseDao.getRes_user_id());
		pleaseExt.setParam(":VRES_DATE", pleaseDao.getRes_date());
		pleaseExt.setParam(":VRES_ADDR", pleaseDao.getRes_addr());
		pleaseExt.setParam(":VRES_TYPE", pleaseDao.getRes_type());
		pleaseExt.setParam(":VUSER_ID", pleaseDao.getUser_id());
		pleaseExt.setParam(":VUSER_NAME", pleaseDao.getUser_name());
		pleaseExt.setParam(":VRES_CONTENT", pleaseDao.getRes_content());
		pleaseExt.setParam(":VOPER_USER_ID", pleaseDao.getOper_user_id());
		pleaseExt.setParam(":VREMARK2", pleaseDao.getRemark2());
		tradeQuery.executeBy(pleaseExt.insBy("UPDATE_BY_ALL"));
		return 0;
	}
	
	
	
	// 取出调查结果
	public ArrayList getResultListByItems(String items_id, String table_id, String cust_id) throws SaasApplicationException {

		PleaseresultExt pleaseExt = new PleaseresultExt();
		pleaseExt.setParam(":VCUST_ID", cust_id);
		pleaseExt.setParam(":VITEMS_ID", items_id);
		pleaseExt.setParam(":VTABLE_ID", table_id);
		pleaseExt.setParam(":VENABLE_TAG", "0");
		ArrayList list = pleaseExt.selByList("SEL_BY_ITEMS");
		return list;
	}
	
	//取出调查结果
	public ArrayList getResultByTradeId(String trade_id) throws SaasApplicationException {

		PleaseresultExt pleaseExt = new PleaseresultExt();
		pleaseExt.setParam(":VTRADE_ID", trade_id);
		ArrayList list = pleaseExt.selByList("SEL_BY_TRADE_ID");
		return list;
	}
	
	// 取出单个条目的结果
	public Map getResultByMap(String items_id) throws SaasApplicationException {

		Map map = new HashMap();
		PleaseresultExt pleaseExt = new PleaseresultExt();
		pleaseExt.setParam(":VITEMS_ID", items_id);
		ArrayList list = pleaseExt.selByList("SEL_BY_ID");
		if (list != null && list.size() > 0) {
			map = (Map) list.get(0);
		}
		return map;
	}
	
	//
	public ArrayList getResultItems(int iStart, String table_id,String cust_id) throws SaasApplicationException {

		ArrayList list = new ArrayList();
		if (iStart == 0) {
			iStart = 0;
		}
		else {
			iStart = (iStart - 1) * 20;
		}
		PleaseresultExt pleaseExt = new PleaseresultExt();
		pleaseExt.setParam(":VCUST_ID", cust_id);
		pleaseExt.setParam(":VTABLE_ID", table_id);
		list=pleaseExt.selByList("SEL_RES_ITEMS",iStart,20);
		return list;
	}
	
	
	public int getResultItemCt(String table_id, String cust_id) throws SaasApplicationException {

		int size = 0;
		PleaseresultExt pleaseExt = new PleaseresultExt();
		pleaseExt.setParam(":VCUST_ID", cust_id);
		pleaseExt.setParam(":VTABLE_ID", table_id);
		ArrayList list = pleaseExt.selByList("SEL_RESULT_CT");
		if (list != null && list.size() > 0) {
			
			size = list.size();
		}
		return size;
	}
	
}