messagedao.java

JAVA实现的中小型企业CRM客户关系管理系统

package com.crm.message;

import java.util.List;

import javax.servlet.http.HttpServletRequest;

import com.crm.common.Page;
import com.crm.dao.CommonDAO;
import com.crm.message.po.Message;


public class MessageDAO extends CommonDAO implements IMessageDAO{


	public List getMessageList(Message message,HttpServletRequest request){
		Page page = new Page();
		//获取当前页
		int currentPage = page.getCurrentPage(request);
		//读取总记录数
		Integer count = (Integer)this.getSqlMapClientTemplate().queryForObject("Message.messagelistcount",message);
		page.setRscount(count.intValue());
		//计算总页数
		int pagecout = page.getPageCount();
		
		
		
		int pagesize = page.getPagesize();
		
		//生成显示tool 
		String pagetool = page.pagetool(request.getRequestURI()+page.getParams(request));
		request.setAttribute("pagetool",pagetool);

		List list =  this.getSqlMapClientTemplate().queryForList("Message.messagelist",message,(currentPage-1)*pagesize,pagesize);
		return list;
	}
	public List getCustMessageList(Message message,HttpServletRequest request){
		Page page = new Page();
		
		
		//获取当前页
		int currentPage = page.getCurrentPage(request);
		//读取总记录数
		Integer count = (Integer)this.getSqlMapClientTemplate().queryForObject("Message.selectusercount",message);
		page.setRscount(count.intValue());
		//计算总页数
		int pagecout = page.getPageCount();
		
		
		
		int pagesize = page.getPagesize();
		
		//生成显示tool 
		String pagetool = page.pagetool(request.getContextPath()+"/manage/message.do?task=custlist"+page.getParams(request));
		request.setAttribute("pagetool",pagetool);

		List list =  this.getSqlMapClientTemplate().queryForList("Message.selectcustlist",message,(currentPage-1)*pagesize,pagesize);
//	System.out.println("list.size="+list.size());
		return list;
		//
	}	
/**
 * 
 */	
	public boolean addMessage(Message message){
		this.getSqlMapClientTemplate().insert("Message.insertmessage", message);
		return true;
	}
	public boolean deleteMessage(String userid){
		this.getSqlMapClientTemplate().delete("Message.deleteuser", userid);
		return true;
	}	
	public boolean updateMessage(Message message){
		this.getSqlMapClientTemplate().update("Message.updateuser", message);
		return true;
	}	

	public Message getMessage(String sId){
		return (Message)this.getSqlMapClientTemplate().queryForObject("Message.selectuser", sId); 
	}	
}