tempforminfo.java

java阿里巴巴代码

package com.saas.biz.templateFormMgr;

import java.util.ArrayList;
import java.util.HashMap;
import com.saas.biz.commen.commMethodMgr;
import com.saas.biz.dao.templateFormDAO.TemplateExt;
import com.saas.biz.dao.templateFormDAO.TemplateFormDao;
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;

public class TempFormInfo {

	Logger log;

	Buffers inBuffer;

	Buffers outBuffer;

	Dbtable tradeQuery;

	commMethodMgr commen;

	ArrayList queryResult = new ArrayList();

	public TempFormInfo() {

		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 addTemplateForm(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入addTemplateForm方法...");
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String entity_type = inbuffer.getString("ENTITY_TYPE");
		String form_id = inbuffer.getString("FORM_ID");
		String form_name = inbuffer.getString("FORM_NAME");
		String area_id = inbuffer.getString("AREA_ID");
		String area_name = inbuffer.getString("AREA_NAME");
		if (area_name == null || area_name.equals("")) {
			area_name = "#";
		}
		String area_no = inbuffer.getString("AREA_NO");
		if (area_no == null || area_no.equals("")) {
			area_no = "1";
		}
		String field_id = inbuffer.getString("FIELD_ID");
		String field_name = inbuffer.getString("FIELD_NAME");
		String field_type = inbuffer.getString("FIELD_TYPE");
		String field_desc = inbuffer.getString("FIELD_DESC");
		String default_value = inbuffer.getString("DEFAULT_VALUE");
		String field_no = inbuffer.getString("FIELD_NO");
		String remark2 = inbuffer.getString("REMARK2");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");

		try {
			TemplateFormDao formDao = new TemplateFormDao();
			formDao.setArea_id(area_id);
			formDao.setCust_id(cust_id);
			formDao.setEntity_type(entity_type);
			formDao.setField_id(field_id);
			formDao.setForm_id(form_id);
			formDao.setForm_name(form_name);
			formDao.setArea_name(area_name);
			formDao.setArea_no(area_no);
			formDao.setField_name(field_name);
			formDao.setField_type(field_type);
			formDao.setField_desc(field_desc);
			formDao.setDefault_value(default_value);
			formDao.setField_no(field_no);
			formDao.setRemark2(remark2);
			formDao.setOper_user_id(oper_user_id);
			iResult = addTemplateForm(formDao);
		} 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("退出addTemplateForm方法...");
	}

	public int addTemplateForm(TemplateFormDao formDao) {

		TemplateExt formExt = new TemplateExt();
		formExt.setParam(":VAREA_ID", formDao.getArea_id());
		formExt.setParam(":VCUST_ID", formDao.getCust_id());
		formExt.setParam(":VENTITY_TYPE", formDao.getEntity_type());
		formExt.setParam(":VFIELD_ID", formDao.getField_id());
		formExt.setParam(":VFORM_ID", formDao.getForm_id());
		formExt.setParam(":VFORM_NAME", formDao.getForm_name());
		formExt.setParam(":VAREA_NAME", formDao.getArea_name());
		formExt.setParam(":VAREA_NO", formDao.getArea_no());
		formExt.setParam(":VFIELD_NAME", formDao.getField_name());
		formExt.setParam(":VFIELD_TYPE", formDao.getField_type());
		formExt.setParam(":VFIELD_DESC", formDao.getField_desc());
		formExt.setParam(":VDEFAULT_VALUE", formDao.getDefault_value());
		formExt.setParam(":VFIELD_NO", formDao.getField_no());
		formExt.setParam(":VREMARK2", formDao.getRemark2());
		formExt.setParam(":VOPER_USER_ID", formDao.getOper_user_id());
		tradeQuery.executeBy(formExt.insBy("INS_BY_ALL"));
		return 0;
	}

	// 修改模板字段
	public void editTemplateFormField(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入editTemplateFormField方法...");
		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 field_name = inbuffer.getString("FIELD_NAME");
		String field_type = inbuffer.getString("FIELD_TYPE");
		String field_desc = inbuffer.getString("FIELD_DESC");
		String default_value = inbuffer.getString("DEFAULT_VALUE");
		String field_no = inbuffer.getString("FIELD_NO");
		String remark2 = inbuffer.getString("REMARK2");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		try {
			TemplateFormDao formDao = new TemplateFormDao();
			formDao.setCust_id(cust_id);
			formDao.setForm_id(form_id);
			formDao.setField_id(field_id);
			formDao.setField_name(field_name);
			formDao.setField_type(field_type);
			formDao.setField_desc(field_desc);
			formDao.setDefault_value(default_value);
			formDao.setField_no(field_no);
			formDao.setRemark2(remark2);
			formDao.setOper_user_id(oper_user_id);
			iResult = editTemplateFormField(formDao);
		} 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("退出editTemplateFormField方法...");
	}

	public int editTemplateFormField(TemplateFormDao formDao)
			throws SaasApplicationException {

		TemplateExt formExt = new TemplateExt();
		formExt.setParam(":VCUST_ID", formDao.getCust_id());
		formExt.setParam(":VFORM_ID", formDao.getForm_id());
		formExt.setParam(":VFIELD_ID", formDao.getField_id());
		formExt.setParam(":VFIELD_NAME", formDao.getField_name());
		formExt.setParam(":VFIELD_TYPE", formDao.getField_type());
		formExt.setParam(":VFIELD_DESC", formDao.getField_desc());
		formExt.setParam(":VDEFAULT_VALUE", formDao.getDefault_value());
		formExt.setParam(":VFIELD_NO", formDao.getField_no());
		formExt.setParam(":VREMARK2", formDao.getRemark2());
		formExt.setParam(":VOPER_USER_ID", formDao.getOper_user_id());
		tradeQuery.executeBy(formExt.insBy("UPDATE_BY_FIELD"));
		return 0;
	}

	// 修改模板区域
	public void editTemplateFormArea(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入editTemplateFormArea方法...");
		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");
		String area_name = inbuffer.getString("AREA_NAME");
		String area_no = inbuffer.getString("AREA_NO");
		if (area_no == null || area_no.equals("")) {
			area_no = "1";
		}
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		try {
			TemplateFormDao formDao = new TemplateFormDao();
			formDao.setCust_id(cust_id);
			formDao.setForm_id(form_id);
			formDao.setOper_user_id(oper_user_id);
			formDao.setArea_id(area_id);
			formDao.setArea_name(area_name);
			formDao.setArea_no(area_no);
			iResult = editTemplateFormArea(formDao);
		} 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("退出editTemplateFormArea方法...");
	}

	public int editTemplateFormArea(TemplateFormDao formDao)
			throws SaasApplicationException {

		TemplateExt formExt = new TemplateExt();
		formExt.setParam(":VCUST_ID", formDao.getCust_id());
		formExt.setParam(":VFORM_ID", formDao.getForm_id());
		formExt.setParam(":VAREA_NAME", formDao.getArea_name());
		formExt.setParam(":VAREA_NO", formDao.getArea_no());
		formExt.setParam(":VAREA_ID", formDao.getArea_id());
		formExt.setParam(":VOPER_USER_ID", formDao.getOper_user_id());
		tradeQuery.executeBy(formExt.insBy("UPDATE_BY_AREA"));
		return 0;
	}

	// 返回单个模板
	public ArrayList getTemplateFormById(String cust_id, String form_id)
			throws SaasApplicationException {

		ArrayList list = new ArrayList();
		TemplateExt formExt = new TemplateExt();
		formExt.setParam(":VCUST_ID", cust_id);
		formExt.setParam(":VFORM_ID", form_id);
		list = formExt.selByList("SEL_BY_ID");
		return list;
	}

	// 找出单个模板和多个域级字段
	public ArrayList getTemplateAreaField(String cust_id, String form_id)
			throws SaasApplicationException {

		ArrayList listTepm = new ArrayList();
		TemplateExt formExt = new TemplateExt();
		formExt.setParam(":VCUST_ID", cust_id);
		formExt.setParam(":VFORM_ID", form_id);
		ArrayList list = formExt.selByList("SEL_BY_GROUP");
		if (list != null && list.size() > 0) {
			for (int i = 0; i < list.size(); i++) {
				HashMap map = (HashMap) list.get(i);
				String area_id = "";
				if (map.get("area_id") != null) {
					area_id = map.get("area_id").toString();
				}
				String area_name = "";
				if (map.get("area_name") != null) {
					area_name = map.get("area_name").toString();