levelinfo.java

java阿里巴巴代码

package com.saas.biz.levelMgr;

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

import com.saas.biz.commen.commMethodMgr;
import com.saas.biz.dao.levelDAO.LevelDAO;
import com.saas.biz.dao.levelDAO.LevelExt;
import com.saas.biz.dao.roleDAO.RoleExt;
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 LevelInfo {
	
	Dbtable tradeQuery;
	
	
	commMethodMgr comm;
	
	
	Logger log;
	
	
	Buffers inBuffer;
	
	
	Buffers outBuffer;
	
	
	ArrayList queryResult = new ArrayList();
	
	
	
	public LevelInfo() {

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

		log.LOG_INFO("进入addLevelInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String entity_type = inbuffer.getString("ENTITY_TYPE");
		String level_code = inbuffer.getString("LEVEL_CODE");
		String level_name = inbuffer.getString("LEVEL_NAME");
		String start_date = inbuffer.getString("START_DATE");
		String end_date = inbuffer.getString("END_DATE");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		String remark = inbuffer.getString("REMARK");
		try {
			LevelDAO levelDao = new LevelDAO();
			levelDao.setCust_id(cust_id);
			levelDao.setLevel_name(level_name);
			levelDao.setEntity_type(entity_type);
			levelDao.setLevel_code(level_code);
			levelDao.setStart_date(start_date);
			levelDao.setEnd_date(end_date);
			levelDao.setRemark(remark);
			levelDao.setOper_user_id(oper_user_id);
			iResult = addLevelInfo(levelDao);
		}
		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("退出addLevelInfo方法...");
	}
	
	
	public int addLevelInfo(LevelDAO levelDao) throws SaasApplicationException {

		LevelExt levelExt = new LevelExt();
		levelExt.setParam(":VCUST_ID", levelDao.getCust_id());
		levelExt.setParam(":VLEVEL_NAME", levelDao.getLevel_name());
		levelExt.setParam(":VENTITY_TYPE", levelDao.getEntity_type());
		levelExt.setParam(":VLEVEL_CODE", levelDao.getLevel_code());
		levelExt.setParam(":VSTART_DATE", levelDao.getStart_date());
		levelExt.setParam(":VEND_DATE", levelDao.getEnd_date());
		levelExt.setParam(":VREMARK", levelDao.getRemark());
		levelExt.setParam(":VOPER_USER_ID", levelDao.getOper_user_id());
		tradeQuery.executeBy(levelExt.insBy("INS_BY_ALL"));
		return 0;
	}
	
	// 修改级别
	public void updateLevelInfo(Buffers inbuffer) {

		log.LOG_INFO("进入updateLevelInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String entity_type = inbuffer.getString("ENTITY_TYPE");
		String level_code = inbuffer.getString("LEVEL_CODE");
		String level_name = inbuffer.getString("LEVEL_NAME");
		String start_date = inbuffer.getString("START_DATE");
		String end_date = inbuffer.getString("END_DATE");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		String remark = inbuffer.getString("REMARK");
		try {
			LevelDAO levelDao = new LevelDAO();
			levelDao.setCust_id(cust_id);
			levelDao.setLevel_name(level_name);
			levelDao.setEntity_type(entity_type);
			levelDao.setLevel_code(level_code);
			levelDao.setStart_date(start_date);
			levelDao.setEnd_date(end_date);
			levelDao.setRemark(remark);
			levelDao.setOper_user_id(oper_user_id);
			iResult = updateLevelInfo(levelDao);
		}
		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("退出updateLevelInfo方法...");
	}
	
	
	public int updateLevelInfo(LevelDAO levelDao) throws SaasApplicationException {

		LevelExt levelExt = new LevelExt();
		levelExt.setParam(":VCUST_ID", levelDao.getCust_id());
		levelExt.setParam(":VLEVEL_NAME", levelDao.getLevel_name());
		levelExt.setParam(":VENTITY_TYPE", levelDao.getEntity_type());
		levelExt.setParam(":VLEVEL_CODE", levelDao.getLevel_code());
		levelExt.setParam(":VSTART_DATE", levelDao.getStart_date());
		levelExt.setParam(":VEND_DATE", levelDao.getEnd_date());
		levelExt.setParam(":VREMARK", levelDao.getRemark());
		levelExt.setParam(":VOPER_USER_ID", levelDao.getOper_user_id());
		tradeQuery.executeBy(levelExt.insBy("UPDATE_BY_ALL"));
		return 0;
	}
	
	
	public void delLevelInfo(Buffers inbuffer) {

		log.LOG_INFO("进入delLevelInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String level_code = inbuffer.getString("LEVEL_CODE");
		try {
			iResult = delLevelInfo(cust_id, level_code);
		}
		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("退出delLevelInfo方法...");
	}
	
	
	public int delLevelInfo(String cust_id, String level_code) {

		LevelExt levelExt = new LevelExt();
		levelExt.setParam(":VCUST_ID", cust_id);
		levelExt.setParam(":VLEVEL_CODE", level_code);
		tradeQuery.executeBy(levelExt.insBy("DEL_BY_CUST"));
		return 0;
	}
	
	
	
	// 通过客户Id找出有效的级别
	public ArrayList getLevelInfoByCust_id(int iStart, String cust_id) throws SaasApplicationException {

		ArrayList list = new ArrayList();
		if (iStart == 0) {
			iStart = 0;
		}
		else {
			iStart = (iStart - 1) * 20;
		}
		LevelExt levelExt = new LevelExt();
		levelExt.setParam(":VCUST_ID", cust_id);
		list = levelExt.selByList("SEL_BY_CUST", iStart, 20);
		return list;
	}
	
	public ArrayList getLevelInfoByCust_id( String cust_id) throws SaasApplicationException {
		ArrayList list = new ArrayList();
		LevelExt levelExt = new LevelExt();
		levelExt.setParam(":VCUST_ID", cust_id);
		list = levelExt.selByList("SEL_BY_CUST" );
		return list;
	}
	
	public int getLevelCount(String cust_id) throws SaasApplicationException {

		int size = 0;
		ArrayList list = new ArrayList();
		LevelExt levelExt = new LevelExt();
		levelExt.setParam(":VCUST_ID", cust_id);
		list = levelExt.selByList("SEL_BY_CT");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			size = Integer.parseInt(map.get("ct").toString());
		}
		return size;
	}
	
	// 通过实体类型取出级别信息
	public ArrayList getLevelByEnitity(String cust_id, String entity) throws SaasApplicationException {

		ArrayList list = new ArrayList();
		LevelExt levelExt = new LevelExt();
		levelExt.setParam(":VCUST_ID", cust_id);
		levelExt.setParam(":VENTITY_TYPE", entity);
		list = levelExt.selByList("SEL_BY_ENTITY");
		return list;
	}
	
	// 通过名称取出级别信息
	public ArrayList getLevelByLevelName(String cust_id, String leve_Name) throws SaasApplicationException {

		ArrayList list = new ArrayList();
		LevelExt levelExt = new LevelExt();
		levelExt.setParam(":VCUST_ID", cust_id);
		levelExt.setParam(":VLEVEL_NAME", leve_Name);
		list = levelExt.selByList("SEL_BY_NAME");
		return list;
	}
	
	// 取出单个级别
	public ArrayList getLevelInfoByCode(String cust_id, String level_code) throws SaasApplicationException {

		ArrayList list = new ArrayList();
		LevelExt levelExt = new LevelExt();
		levelExt.setParam(":VCUST_ID", cust_id);
		levelExt.setParam(":VLEVEL_CODE", level_code);
		list = levelExt.selByList("SEL_BY_CODE");
		return list;
	}
	
	// 取出级别列表
	public ArrayList getLevelListByCustEntity(String cust_id, String enitity) throws SaasApplicationException {

		ArrayList list = new ArrayList();
		LevelExt levelExt = new LevelExt();
		levelExt.setParam(":VCUST_ID", cust_id);
		levelExt.setParam(":VENTITY_TYPE", enitity);
		list = levelExt.selByList("SEL_BY_ENTITY");
		return list;
	}
	
	public ArrayList getOppLevelByCustEntity(String cust_id, String enitity) throws SaasApplicationException {

		ArrayList list = new ArrayList();
		LevelExt levelExt = new LevelExt();
		levelExt.setParam(":VCUST_ID", cust_id);
		levelExt.setParam(":VENTITY_TYPE", "2");
		list = levelExt.selByList("SEL_BY_ENTITY");
		return list;
	}
}