productiondao.java

客户关系管理系统主要管理新老客户的一些信息并可以发现潜在客户

/**
 * 
 */
package com.qrsx.qrsxcrm.dao;

import java.util.List;

import org.hibernate.Query;

import com.qrsx.qrsxcrm.model.Duty;
import com.qrsx.qrsxcrm.model.Production;

/**
 * @author Administrator
 *
 */
public class ProductionDAO extends BaseDAO
{

	@SuppressWarnings("unchecked")
	public ProductionDAO(Class Production) {
		super(Production);
		// TODO Auto-generated constructor stub
	}

	public void updates(Production production)
	{
		Production production1 = new Production();
		production1=(Production) session.get(Production.class, production.getId());
		production1.setCreateDate(production.getCreateDate());
		production1.setNum(production.getNum());
		production1.setPrice(production.getPrice());
		production1.setProductionName(production1.getProductionName());
		production1.setProductionType(production1.getProductionType());
		session.update(production1);
	}

	/**
	 * 根据产品类型ｉｄ检索产品
	 */
	@SuppressWarnings("unchecked")
	public List<Production> finBypt(Production production){
		String sql="select * from production p where p.productionTypeId = "+"'"+production.getProductionTypeId()+"'";
		Query query= session.createSQLQuery(sql);
		List<Production> lists=query.list();
		return lists;
	}
}