linkmanbiz.java

crm系统 有源码 及相关文档sql2005 数据库 客户反馈模块

package org.jb.y272.team0.biz;

import java.io.Serializable;

import org.jb.common.biz.BaseBiz;
import org.jb.common.util.PageResult;
import org.jb.y272.team0.entity.CstLinkman;

/**
 * 联系人 管理业务逻辑类
 * @author hailong.liu
 */
public class LinkmanBiz extends BaseBiz {
	/*   复杂业务方法    */
	
	
	/*   简单业务方法    */
	/**
	 * 加载 联系人
	 */
	public CstLinkman get(Serializable id){
		CstLinkman ret = (CstLinkman)this.getCommonDAO().get(CstLinkman.class, id);		
		return ret;
	}
	
	/**
	 * 添加 联系人
	 */
	public boolean add(CstLinkman item){
		this.getCommonDAO().add(item);		
		return true;
	}
	
	/**
	 * 删除 联系人
	 */
	public boolean del(Serializable id){
		this.getCommonDAO().del(CstLinkman.class, id);		
		return true;
	}
	
	/**
	 * 修改 联系人
	 */
	public boolean update(CstLinkman item){
		this.getCommonDAO().update(item);		
		return true;
	}
	
	/**
	 * 查询 联系人 
	 */
	public void search(CstLinkman condition, PageResult pageResult) {
		String hql = "select o from CstLinkman o where 1=1 ";
		if (null!=condition){				
			
				if (isNotNullOrEmpty(condition.getLkmCustName())){
				hql += "and o.lkmCustName like '%"
						+condition.getLkmCustName()+"%' ";
			}

				if (isNotNullOrEmpty(condition.getLkmName())){
				hql += "and o.lkmName like '%"
						+condition.getLkmName()+"%' ";
			}

				if (isNotNullOrEmpty(condition.getLkmSex())){
				hql += "and o.lkmSex like '%"
						+condition.getLkmSex()+"%' ";
			}

				if (isNotNullOrEmpty(condition.getLkmPostion())){
				hql += "and o.lkmPostion like '%"
						+condition.getLkmPostion()+"%' ";
			}

				if (isNotNullOrEmpty(condition.getLkmTel())){
				hql += "and o.lkmTel like '%"
						+condition.getLkmTel()+"%' ";
			}

				if (isNotNullOrEmpty(condition.getLkmMobile())){
				hql += "and o.lkmMobile like '%"
						+condition.getLkmMobile()+"%' ";
			}

				if (isNotNullOrEmpty(condition.getLkmMemo())){
				hql += "and o.lkmMemo like '%"
						+condition.getLkmMemo()+"%' ";
			}

		}
		if (isNotNullOrEmpty(pageResult.getOrderBy())){
			String sort = pageResult.getSort();
			hql += "order by " + pageResult.getOrderBy() + " " +sort; 
			if ("asc".equals(sort)){
				pageResult.setSort("desc");
			}else{
				pageResult.setSort("asc");
			}
		}else{
			hql += "order by o.lkmId desc";
		}		
		this.getCommonDAO().listByPage(hql,pageResult);
	}
}