salplanbiz.java

来自「实现用户关系管理系统」· Java 代码 · 共 76 行

package org.jb.y2t308.team3.biz;

import org.jb.common.biz.BaseBiz;
import org.jb.common.util.PageResult;
import org.jb.y2t308.team3.entity.SalChance;
import org.jb.y2t308.team3.entity.SalPlan;

/**
 * 销售计划
 * @author Administrator
 *
 */
public class SalPlanBiz extends BaseBiz{
	
	/**
	 * 添加销售计划
	 * @param salPlan
	 */
	public void addSalPlan(SalPlan salPlan)
	{
		this.getCommonDAO().add(salPlan);
	}
	
	
	/***
	 * 显示销售机会列表
	 * @param salChances
	 * @param pageResult
	 */
	public void getSaleChancePlanList(SalChance salChances, PageResult pageResult) {
		String hql = "select chance from SalChance chance where 1=1 ";
		/**
		 * 根据客户名称、联系人、概要进行模糊查询
		 */
		if (null != salChances) {
			if (isNotNullOrEmpty(salChances.getChcCustName())) {
				hql += " and chance.chcCustName like '%"
						+ salChances.getChcCustName() + "%'";
			}
			if (isNotNullOrEmpty(salChances.getChcTitle())) {
				hql += " and chance.chcTitle like '%"
						+ salChances.getChcTitle() + "%'";

			}
			if (isNotNullOrEmpty(salChances.getChcLinkman())) {
				hql += " and chance.chcLinkman like '%"
						+ salChances.getChcLinkman() + "%'";
			}

		}

		/**
		 * 排序
		 */

		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 chance.chcId asc";
		}

		this.getCommonDAO().listByPage(hql, pageResult);

	}
	
	
	
}