templateformitem.java

java阿里巴巴代码

package com.saas.biz.templateItemMgr;

import java.util.ArrayList;

import com.saas.biz.commen.commMethodMgr;
import com.saas.biz.dao.templateFormDAO.TemplateExt;
import com.saas.biz.dao.templateItemDAO.TemplateItemDAO;
import com.saas.biz.dao.templateItemDAO.TemplateItemExt;
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:订单条目信息表
 * @2008-4-9
 */
public class TemplateFormItem {
	
	
	Logger log;
	
	
	Buffers inBuffer;
	
	
	Buffers outBuffer;
	
	
	Dbtable tradeQuery;
	
	
	commMethodMgr commen;
	
	
	ArrayList queryResult = new ArrayList();
	
	
	
	public TemplateFormItem() {

		log = new Logger(this);
		tradeQuery = new Dbtable();
		commen = new commMethodMgr();
		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 addTemplateItem(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入addTemplateItem方法...");
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String form_id = inbuffer.getString("FORM_ID");
		String field_id = inbuffer.getString("FIELD_ID");
		String item_id = inbuffer.getString("ITEM_ID");
		String item_name = inbuffer.getString("ITEM_NAME");
		String item_desc = inbuffer.getString("ITEM_DESC");
		String default_value = inbuffer.getString("DEFAULT_VALUE");
		String item_no = inbuffer.getString("ITEM_NO");
		if (item_no == null || item_no.equals("")) {
			item_no = "1";
		}
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		String remark2 = inbuffer.getString("REMARK2");
		try {
			TemplateItemDAO itemDao = new TemplateItemDAO();
			itemDao.setCust_id(cust_id);
			itemDao.setField_id(field_id);
			itemDao.setForm_id(form_id);
			itemDao.setItem_id(item_id);
			itemDao.setItem_name(item_name);
			itemDao.setItem_desc(item_desc);
			itemDao.setDefault_value(default_value);
			itemDao.setItem_no(item_no);
			itemDao.setOper_user_id(oper_user_id);
			itemDao.setRemark2(remark2);
			iResult = addTemplateItem(itemDao);
		}
		catch (Exception e) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "提取表单数据出错！");
		}
		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("退出addTemplateItem方法...");
	}
	
	
	public int addTemplateItem(TemplateItemDAO itemDao) {

		TemplateItemExt itemExt = new TemplateItemExt();
		itemExt.setParam(":VCUST_ID", itemDao.getCust_id());
		itemExt.setParam(":VFIELD_ID", itemDao.getField_id());
		itemExt.setParam(":VFORM_ID", itemDao.getForm_id());
		itemExt.setParam(":VITEM_ID", itemDao.getItem_id());
		itemExt.setParam(":VITEM_NAME", itemDao.getItem_name());
		itemExt.setParam(":VITEM_DESC", itemDao.getItem_desc());
		itemExt.setParam(":VDEFAULT_VALUE", itemDao.getDefault_value());
		itemExt.setParam(":VITEM_NO", itemDao.getItem_no());
		itemExt.setParam(":VOPER_USER_ID", itemDao.getOper_user_id());
		itemExt.setParam(":VREMARK2", itemDao.getRemark2());
		tradeQuery.executeBy(itemExt.insBy("INS_BY_ALL"));
		return 0;
	}
	
	
	
	// 新增模板条目
	public void editTemplateItem(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入editTemplateItem方法...");
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String form_id = inbuffer.getString("FORM_ID");
		String item_id = inbuffer.getString("ITEM_ID");
		String item_name = inbuffer.getString("ITEM_NAME");
		String item_desc = inbuffer.getString("ITEM_DESC");
		String default_value = inbuffer.getString("DEFAULT_VALUE");
		String item_no = inbuffer.getString("ITEM_NO");
		if (item_no == null || item_no.equals("")) {
			item_no = "1";
		}
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		String remark2 = inbuffer.getString("REMARK2");
		try {
			TemplateItemDAO itemDao = new TemplateItemDAO();
			itemDao.setCust_id(cust_id);
			itemDao.setForm_id(form_id);
			itemDao.setItem_id(item_id);
			itemDao.setItem_name(item_name);
			itemDao.setItem_desc(item_desc);
			itemDao.setDefault_value(default_value);
			itemDao.setItem_no(item_no);
			itemDao.setOper_user_id(oper_user_id);
			itemDao.setRemark2(remark2);
			iResult = editTemplateItem(itemDao);
		}
		catch (Exception e) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "提取表单数据出错！");
		}
		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("退出addTemplateItem方法...");
	}
	
	
	public int editTemplateItem(TemplateItemDAO itemDao) {

		TemplateItemExt itemExt = new TemplateItemExt();
		itemExt.setParam(":VCUST_ID", itemDao.getCust_id());
		itemExt.setParam(":VFORM_ID", itemDao.getForm_id());
		itemExt.setParam(":VITEM_ID", itemDao.getItem_id());
		itemExt.setParam(":VITEM_NAME", itemDao.getItem_name());
		itemExt.setParam(":VITEM_DESC", itemDao.getItem_desc());
		itemExt.setParam(":VDEFAULT_VALUE", itemDao.getDefault_value());
		itemExt.setParam(":VITEM_NO", itemDao.getItem_no());
		itemExt.setParam(":VOPER_USER_ID", itemDao.getOper_user_id());
		itemExt.setParam(":VREMARK2", itemDao.getRemark2());
		tradeQuery.executeBy(itemExt.insBy("UPDATE_BY_ALL"));
		return 0;
	}
	
	
	
	// 查询出归属于一个模板域的所有条目
	public ArrayList getTeplateItmesByArea(String cust_id, String field_id) throws SaasApplicationException {

		ArrayList list = new ArrayList();
		TemplateItemExt itemExt = new TemplateItemExt();
		itemExt.setParam(":VCUST_ID", cust_id);
		itemExt.setParam(":VFIELD_ID", field_id);
		list = itemExt.selByList("SEL_BY_FIELD");
		return list;
	}
	
	
	
	// 删除模板条目
	public void delTemplateItem(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入delTemplateItem方法...");
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String form_id = inbuffer.getString("FORM_ID");
		String item_id = inbuffer.getString("ITEM_ID");
		try {
			TemplateItemDAO itemDao = new TemplateItemDAO();
			itemDao.setCust_id(cust_id);
			itemDao.setForm_id(form_id);
			itemDao.setItem_id(item_id);
			iResult = delTemplateItem(itemDao);
		}
		catch (Exception e) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "提取表单数据出错！");
		}
		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("退出addTemplateItem方法...");
	}
	
	
	public int delTemplateItem(TemplateItemDAO itemDao) {

		TemplateItemExt itemExt = new TemplateItemExt();
		itemExt.setParam(":VCUST_ID", itemDao.getCust_id());
		itemExt.setParam(":VFORM_ID", itemDao.getForm_id());
		itemExt.setParam(":VITEM_ID", itemDao.getItem_id());
		tradeQuery.executeBy(itemExt.insBy("DEL_BY_ITEMID"));
		return 0;
	}
	
	
	
	// 通过区域删除条目
	public void deleteItemByArea(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入deleteItemByArea方法...");
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String form_id = inbuffer.getString("FORM_ID");
		String area_id = inbuffer.getString("AREA_ID");
		try {
			iResult = deleteItemByArea(cust_id, form_id, area_id);
		}
		catch (Exception e) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "提取表单数据出错！");
		}
		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("退出deleteItemByArea方法...");
	}
	
	
	public int deleteItemByArea(String cust_id, String form_id, String area_id) throws SaasApplicationException {

		// 删除模板信息
		TemplateItemExt itemExt = new TemplateItemExt();
		itemExt.setParam(":VCUST_ID", cust_id);
		itemExt.setParam(":VFORM_ID", form_id);
		itemExt.setParam(":VAREA_ID", area_id);
		tradeQuery.executeBy(itemExt.insBy("DEL_BY_AREA"));
		return 0;
	}
	
	// 通过字段删除条目
	public void deleteItemByField(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入deleteItemByField方法...");
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String form_id = inbuffer.getString("FORM_ID");
		String field_id = inbuffer.getString("FIELD_ID");
		try {
			iResult = deleteItemByField(cust_id, form_id, field_id);
		}
		catch (Exception e) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "提取表单数据出错！");
		}
		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("退出deleteItemByArea方法...");
	}
	
	
	public int deleteItemByField(String cust_id, String form_id, String field_id) throws SaasApplicationException {

		// 删除模板信息
		TemplateItemExt itemExt = new TemplateItemExt();
		itemExt.setParam(":VCUST_ID", cust_id);
		itemExt.setParam(":VFORM_ID", form_id);
		itemExt.setParam(":VFIELD_ID", field_id);
		tradeQuery.executeBy(itemExt.insBy("DEL_BY_AREA"));
		return 0;
	}
	
	// 取出单个条目
	public ArrayList getTemplateItemById(String cust_id, String form_id, String item_id) throws SaasApplicationException {

		ArrayList list = new ArrayList();
		TemplateItemExt itemExt = new TemplateItemExt();
		itemExt.setParam(":VCUST_ID", cust_id);
		itemExt.setParam(":VFORM_ID", form_id);
		itemExt.setParam(":VITEM_ID", item_id);
		list = itemExt.selByList("SEL_BY_ID");
		return list;
	}
}