notbookinfo.java

java阿里巴巴代码

package com.saas.biz.notebookMgr;

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

import com.saas.biz.commen.commMethodMgr;
import com.saas.biz.dao.notebookDAO.NotebookDAO;
import com.saas.biz.dao.notebookDAO.NotebookExt;
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 NotBookInfo{
	Logger log;

	Buffers inBuffer;

	Buffers outBuffer;

	Dbtable tradeQuery;

	commMethodMgr commen;

	ArrayList queryResult = new ArrayList();

	public NotBookInfo() {
		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 addNotBookInfo(Buffers inbuffer) {
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入addReportInfo方法...");
		int iResult = -1;
		NotebookDAO noteDao = new NotebookDAO();
		String name = inbuffer.getString("NAME");
		Integer sex = Integer.parseInt(inbuffer.getString("SEX"));
		String xphone = inbuffer.getString("XPHONE");
		String hometel = inbuffer.getString("HOMETEL");
		String officetel = inbuffer.getString("OFFICETEL");
		String address = inbuffer.getString("ADDRESS");
		String unit = inbuffer.getString("UNIT");
		String email = inbuffer.getString("EMAIL");
		String qq = inbuffer.getString("QQ");
		String msn = inbuffer.getString("MSN");
		String yahoo = inbuffer.getString("YAHOO");
		Integer relationship = Integer.parseInt(inbuffer.getString("RELATIONSHIP"));
		String recorduser = inbuffer.getString("SESSION_USER_NAME");
		String part = inbuffer.getString("DEPART_CODE");

		noteDao.setName(name);
		noteDao.setSex(sex);
		noteDao.setXphone(xphone);
		noteDao.setHometel(hometel);
		noteDao.setOfficetel(officetel);
		noteDao.setAddress(address);
		noteDao.setUnit(unit);
		noteDao.setEmail(email);
		noteDao.setQq(qq);
		noteDao.setMsn(msn);
		noteDao.setYahoo(yahoo);
		noteDao.setRecorduser(recorduser);
		noteDao.setRelationship(relationship);
		noteDao.setPart(part);

		iResult = addNotBookInfo(noteDao);
		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("退出addReportInfo方法...");
	}

	public int addNotBookInfo(NotebookDAO noteDao) {
		NotebookExt repExt = new NotebookExt();
		repExt.setParam(":VNAME", noteDao.getName());
		repExt.setParam(":VSEX", noteDao.getSex());
		repExt.setParam(":VXPHONE", noteDao.getXphone());
		repExt.setParam(":VHOMETEL", noteDao.getHometel());
		repExt.setParam(":VOFFICETEL", noteDao.getOfficetel());
		repExt.setParam(":VADDRESS", noteDao.getAddress());
		repExt.setParam(":VUNIT", noteDao.getUnit());
		repExt.setParam(":VEMAIL", noteDao.getEmail());
		repExt.setParam(":VQQ", noteDao.getQq());
		repExt.setParam(":VMSN", noteDao.getMsn());
		repExt.setParam(":VYAHOO", noteDao.getYahoo());
		repExt.setParam(":VRECORDUSER", noteDao.getRecorduser());
		repExt.setParam(":VRELATIONSHIP", noteDao.getRelationship());
		repExt.setParam(":VPART", noteDao.getPart());
		tradeQuery.executeBy(repExt.insBy("INS_BY_ALL"));
		return 0;
	}

	// 修改个人通讯录
	public void updateNotBookInfo(Buffers inbuffer) {
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入addReportInfo方法...");
		int iResult = -1;
		NotebookDAO noteDao = new NotebookDAO();
		String id = inbuffer.getString("IDX");
		String name = inbuffer.getString("NAME");
		Integer sex = Integer.parseInt(inbuffer.getString("SEX"));
		String xphone = inbuffer.getString("XPHONE");
		String hometel = inbuffer.getString("HOMETEL");
		String officetel = inbuffer.getString("OFFICETEL");
		String address = inbuffer.getString("ADDRESS");
		String unit = inbuffer.getString("UNIT");
		String email = inbuffer.getString("EMAIL");
		String qq = inbuffer.getString("QQ");
		String msn = inbuffer.getString("MSN");
		String yahoo = inbuffer.getString("YAHOO");
		Integer relationship = Integer.parseInt(inbuffer.getString("RELATIONSHIP"));
		String recorduser = inbuffer.getString("SESSION_USER_NAME");
		String part = inbuffer.getString("DEPART_CODE");
		noteDao.setId(Integer.parseInt(id));
		noteDao.setName(name);
		noteDao.setSex(sex);
		noteDao.setXphone(xphone);
		noteDao.setHometel(hometel);
		noteDao.setOfficetel(officetel);
		noteDao.setAddress(address);
		noteDao.setUnit(unit);
		noteDao.setEmail(email);
		noteDao.setQq(qq);
		noteDao.setMsn(msn);
		noteDao.setYahoo(yahoo);
		noteDao.setRecorduser(recorduser);
		noteDao.setRelationship(relationship);
		noteDao.setPart(part);

		iResult = updateNotBookInfo(noteDao);
		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("退出addReportInfo方法...");
	}

	public int updateNotBookInfo(NotebookDAO noteDao) {
		NotebookExt repExt = new NotebookExt();
		repExt.setParam(":VID", noteDao.getId());
		repExt.setParam(":VNAME", noteDao.getName());
		repExt.setParam(":VSEX", noteDao.getSex());
		repExt.setParam(":VXPHONE", noteDao.getXphone());
		repExt.setParam(":VHOMETEL", noteDao.getHometel());
		repExt.setParam(":VOFFICETEL", noteDao.getOfficetel());
		repExt.setParam(":VADDRESS", noteDao.getAddress());
		repExt.setParam(":VUNIT", noteDao.getUnit());
		repExt.setParam(":VEMAIL", noteDao.getEmail());
		repExt.setParam(":VQQ", noteDao.getQq());
		repExt.setParam(":VMSN", noteDao.getMsn());
		repExt.setParam(":VYAHOO", noteDao.getYahoo());
		repExt.setParam(":VRECORDUSER", noteDao.getRecorduser());
		repExt.setParam(":VRELATIONSHIP", noteDao.getRelationship());
		repExt.setParam(":VPART", noteDao.getPart());
		tradeQuery.executeBy(repExt.insBy("UPDATE_BY_ID"));
		return 0;
	}

	// 删除通讯录
	public void delteNotBookInfo(Buffers inbuffer) {
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入addReportInfo方法...");
		int iResult = -1;
		String id = inbuffer.getString("IDX");

		iResult = delteNotBookInfo(id);
		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("退出addReportInfo方法...");
	}

	public int delteNotBookInfo(String id) {
		NotebookExt repExt = new NotebookExt();
		repExt.setParam(":VID", id);
		tradeQuery.executeBy(repExt.insBy("DELETE_BY_ID"));
		return 0;
	}

	public ArrayList getNoteBookByUser(int iStart, String user) throws SaasApplicationException {
		ArrayList list = new ArrayList();
		NotebookExt repExt = new NotebookExt();
		try {
			if (iStart == 0) {
				iStart = 0;
			}
			else {
				iStart = (iStart - 1) * 20;
			}
			repExt.setParam(":VRECORDUSER", user);
			repExt.setParam(":VNAME", "%"+user+"%");
			list = repExt.selByList("SEL_BY_RECORDUSER", iStart, 20);
		}
		catch (RuntimeException e) {
			log.LOG_INFO(e.getMessage());
		}
		return list;
	}

	public int getNoteBookByUserCT(String user) throws SaasApplicationException {
		int size = 0;
		ArrayList list = new ArrayList();
		NotebookExt repExt = new NotebookExt();
		try {
			repExt.setParam(":VRECORDUSER", user);
			repExt.setParam(":VNAME", "%"+user+"%");
			list = repExt.selByList("SEL_BY_RECORDUSER_CT");
			if (list != null && list.size() > 0) {
				HashMap map = (HashMap) list.get(0);
				if (map.get("ct") != null) {
					size = Integer.parseInt(map.get("ct").toString());
				}
			}
		}
		catch (RuntimeException e) {
			log.LOG_INFO(e.getMessage());
		}
		return size;
	}

	public ArrayList getNoteBookById(String id) throws SaasApplicationException {
		ArrayList list = new ArrayList();
		NotebookExt repExt = new NotebookExt();
		repExt.setParam(":VID", id);
		list = repExt.selByList("SEL_BY_ID");
		return list;
	}

	@SuppressWarnings("unchecked")
	public Map getNoteBookByMap(String id) throws SaasApplicationException {
		Map Notmap = new HashMap();
		ArrayList list = new ArrayList();
		list = getNoteBookById(id);
		String sex = "", name = "", xphone = "", hometel = "", officetel = "", address = "", relationship = "", unit = "", email = "", qq = "", msn = "", yahoo = "";
		if (list != null && list.size() > 0) {
			if (list != null && list.size() > 0) {
				HashMap map = (HashMap) list.get(0);
				if (map.get("sex") != null)
					sex = map.get("sex").toString();
				if (map.get("name") != null)
					name = map.get("name").toString();
				if (map.get("xphone") != null)
					xphone = map.get("xphone").toString();
				if (map.get("hometel") != null)
					hometel = map.get("hometel").toString();
				if (map.get("officetel") != null)
					officetel = map.get("officetel").toString();
				if (map.get("address") != null)
					address = map.get("address").toString();
				if (map.get("relationship") != null)
					relationship = map.get("relationship").toString();
				if (map.get("unit") != null)
					unit = map.get("unit").toString();
				if (map.get("email") != null)
					email = map.get("email").toString();
				if (map.get("qq") != null)
					qq = map.get("qq").toString();
				if (map.get("msn") != null)
					msn = map.get("msn").toString();
				if (map.get("yahoo") != null)
					yahoo = map.get("yahoo").toString();
			}
		}
		Notmap.put("sex", sex);
		Notmap.put("name", name);
		Notmap.put("xphone", xphone);
		Notmap.put("hometel", hometel);
		Notmap.put("officetel", officetel);
		Notmap.put("address", address);
		Notmap.put("relationship", relationship);
		Notmap.put("unit", unit);
		Notmap.put("email", email);
		Notmap.put("qq", qq);
		Notmap.put("msn", msn);
		Notmap.put("yahoo", yahoo);
		return Notmap;
	}
}