productiondao.java

来自「客户关系管理系统主要管理新老客户的一些信息并可以发现潜在客户」· Java 代码 · 共 49 行

/**
 * 
 */
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;
	}
}