pleaseiteminfo.java

java阿里巴巴代码

package com.saas.biz.pleaseItemMgr;

import java.util.ArrayList;
import java.util.HashMap;

import com.saas.biz.commen.commMethodMgr;
import com.saas.biz.dao.tableitemDAO.TableitemDAO;
import com.saas.biz.dao.tableitemDAO.TableitemExt;
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_b_tableitem]
 * @2008-3-3
 */
public class PleaseItemInfo {
	
	
	Dbtable tradeQuery;
	
	
	commMethodMgr comm;
	
	
	Logger log;
	
	
	Buffers inBuffer;
	
	
	Buffers outBuffer;
	
	
	ArrayList queryResult = new ArrayList();
	
	
	
	public PleaseItemInfo() {

		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;
	}
	
	
	
	// 满意度调查表条目
	public void addPleaseItemInfo(Buffers inbuffer) {

		log.LOG_INFO("进入addPleaseItemInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String table_id = inbuffer.getString("TABLE_ID");
		String table_name = inbuffer.getString("TABLE_NAME");
		String items_id = inbuffer.getString("ITEMS_ID");
		String item_name = inbuffer.getString("ITEM_NAME");
		String item_id = inbuffer.getString("ITEM_ID");
		String d_value = inbuffer.getString("D_VALUE");
		String enable_tag = inbuffer.getString("ENABLE_TAG");
		String num_value = inbuffer.getString("NUM_VALUE");
		String remark2 = inbuffer.getString("REMARK2");
		
		try {
			
			TableitemDAO pleaseDao = new TableitemDAO();
			
			pleaseDao.setCust_id(cust_id);
			pleaseDao.setTable_id(table_id);
			pleaseDao.setTable_name(table_name);
			pleaseDao.setItem_id(item_id);
			pleaseDao.setItems_id(items_id);
			pleaseDao.setItem_name(item_name);
			pleaseDao.setD_value(d_value);
			pleaseDao.setEnable_tag(enable_tag);
			pleaseDao.setNum_value(num_value);
			pleaseDao.setRemark2(remark2);
			
			iResult = addPleaseItemInfo(pleaseDao);
		}
		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("退出addPleaseItemInfo方法...");
	}
	
	
	
	// 增加查询条目[ENABLE_TAG 0 有效 1 无效]
	public int addPleaseItemInfo(TableitemDAO pleaseDao) throws SaasApplicationException {

		TableitemExt pleaseExt = new TableitemExt();
		
		pleaseExt.setParam(":VCUST_ID", pleaseDao.getCust_id());
		pleaseExt.setParam(":VTABLE_ID", pleaseDao.getTable_id());
		pleaseExt.setParam(":VTABLE_NAME", pleaseDao.getTable_name());
		pleaseExt.setParam(":VITEM_ID", pleaseDao.getItem_id());
		pleaseExt.setParam(":VITEMS_ID", pleaseDao.getItems_id());
		pleaseExt.setParam(":VITEM_NAME", pleaseDao.getItem_name());
		pleaseExt.setParam(":VD_VALUE", pleaseDao.getD_value());
		pleaseExt.setParam(":VENABLE_TAG", pleaseDao.getEnable_tag());
		pleaseExt.setParam(":VNUM_VALUE", pleaseDao.getNum_value());
		pleaseExt.setParam(":VREMARK2", pleaseDao.getRemark2());
		tradeQuery.executeBy(pleaseExt.insBy("INS_BY_ALL"));
		
		return 0;
	}
	
	
	
	// 删除条目
	public void delPleaseItemInfo(Buffers inbuffer) {

		log.LOG_INFO("进入delPleaseItemInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String table_id = inbuffer.getString("TABLE_ID");
		String item_id = inbuffer.getString("ITEM_ID");
		try {
			TableitemDAO pleaseDao = new TableitemDAO();
			pleaseDao.setCust_id(cust_id);
			pleaseDao.setTable_id(table_id);
			pleaseDao.setItem_id(item_id);
			iResult = delPleaseItemInfo(pleaseDao);
		}
		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("退出delPleaseItemInfo方法...");
	}
	
	
	public int delPleaseItemInfo(TableitemDAO pleaseDao) throws SaasApplicationException {

		TableitemExt pleaseExt = new TableitemExt();
		pleaseExt.setParam(":VCUST_ID", pleaseDao.getCust_id());
		pleaseExt.setParam(":VTABLE_ID", pleaseDao.getTable_id());
		pleaseExt.setParam(":VITEM_ID", pleaseDao.getItem_id());
		tradeQuery.executeBy(pleaseExt.insBy("DEL_BY_ALL"));
		return 0;
	}
	
	
	
	// 找出调查条目
	public ArrayList getPleaseItemByItems(String table_id, String items_id, String enable) throws SaasApplicationException {

		TableitemExt pleaseExt = new TableitemExt();
		pleaseExt.setParam(":VTABLE_ID", table_id);
		pleaseExt.setParam(":VITEMS_ID", items_id);
		pleaseExt.setParam(":VENABLE_TAG", enable);
		ArrayList list = pleaseExt.selByList("SEL_BY_ITEMS");
		return list;
	}
	
	
	
	// 找出调查条目
	public ArrayList getPleaseItemByTable(String cust_id, String table_id, String enable) throws SaasApplicationException {

		TableitemExt pleaseExt = new TableitemExt();
		pleaseExt.setParam(":VTABLE_ID", table_id);
		pleaseExt.setParam(":VCUST_ID", cust_id);
		pleaseExt.setParam(":VENABLE_TAG", enable);
		ArrayList list = pleaseExt.selByList("SEL_BY_TABLE");
		return list;
	}
	
	
	
	// 找出调查条目
	public String getItemStrngByItems(String table_id, String items_id, String enable) throws SaasApplicationException {

		String itemsHtml = "";
		log.LOG_INFO("table_id==" + table_id + "items_id=" + items_id);
		ArrayList list = getPleaseItemByItems(table_id, items_id, enable);
		if (list != null && list.size() > 0) {
			for (int i = 0; i < list.size(); i++) {
				HashMap map = (HashMap) list.get(i);
				String item_name = map.get("item_name").toString();
				String item_id = map.get("item_id").toString();
				itemsHtml = itemsHtml + item_name + "<a href=/doTradeReg.do?trade_type_code=1059&table_id=" + table_id + "&item_id=" + item_id + " target=_self>【删除】</a><br>";
			}
		}
		
		return itemsHtml;
	}
	
	// 找出条目并生成HTML
	public String getItemHtmlStrngByItems(String table_id, String items_id, String type) throws SaasApplicationException {

		log.LOG_INFO("table_id="+table_id+"items_id="+items_id);
		String tb = "<table width=100% border=0 cellspacing=1 cellpadding=0>", t_b = "</table>";
		String itemsHtml = "";
		String prog_name = "", element = "", p_type = "";// 0 输入框 1 单选框 2 复选框
		TableitemExt pleaseExt = new TableitemExt();
		pleaseExt.setParam(":VTABLE_ID", table_id);
		pleaseExt.setParam(":VITEMS_ID", items_id);
		pleaseExt.setParam(":VENABLE_TAG", "0");
		ArrayList list = pleaseExt.selByList("SEL_BY_HTML");
		prog_name = "<tr><td width=14% bgcolor=FFF9F3><div style=text-align:right; font-weight:bold;>条目名称 ：</div></td>";
		if (list != null && list.size() > 0) {
			for (int i = 0; i < list.size(); i++) {
				HashMap map = (HashMap) list.get(i);
				String item_name = map.get("item_name").toString();
				String item_id = map.get("item_id").toString();
				String num_value = map.get("num_value").toString();
				p_type = map.get("p_type").toString();
				if (p_type == "0" || p_type.equals("0")) {
					element = item_name + "<input type=text name=re_value" + i + " id=re_value" + i + " ><br>" + element;
				}
				else if (p_type == "1" || p_type.equals("1")) {
					element = element + item_name + "<input type=radio name=re_value" + i + " id=re_value" + i + "  value=" + item_id + ">";
				}
				else {
					element = element + item_name + "<input type=checkbox name=re_value" + i + " id=re_value" + i + " value=" + item_id + ">";
				}
				element = element + "<br>分值<input type=text readonly name=item_v id=item_v value=" + num_value + ">";
			}
		}
		prog_name = prog_name + "<td width=14% bgcolor=FFF9F3><div style=text-align:right; font-weight:bold;>" + element + "</div></td></tr>";
		itemsHtml = tb + prog_name + t_b;
		return itemsHtml;
	}
}