package com.lovomall.psc.dao.impl;
import com.lovomall.psc.entity.DeliveryOrderEntity;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean;
import org.springframework.stereotype.Repository;
import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import java.util.List;
@Repository(value = "deliveryOrderDaoImpl")
public class DeliveryOrderDaoImpl {
@Autowired
private LocalContainerEntityManagerFactoryBean entityManagerFactoryBean;
public EntityManagerFactory getEntityManagerFactory(){
return entityManagerFactoryBean.getObject();
}
public List<DeliveryOrderEntity> getPage(String supplierName,int pageNum, int pageSize){
EntityManager entityManager = getEntityManagerFactory().createEntityManager();
String hql="from DeliveryOrderEntity d where d.orderStatus='未发货' ";
if(null != supplierName && supplierName.length() != 0){
hql += " and d.supplier='"+supplierName+"' ";
}
else{
hql += " and d.supplier is null";
}
List<DeliveryOrderEntity> list = entityManager
.createQuery(hql)
.setFirstResult((pageNum - 1) * pageSize)
.setMaxResults(pageSize)
.getResultList();
entityManager.close();
return list;
}
public long getCount(String supplierName){
EntityManager entityManager = getEntityManagerFactory().createEntityManager();
String hql="from DeliveryOrderEntity d where orderStatus='未发货' ";
if(null != supplierName && supplierName.length() != 0){
hql += " and d.supplier='"+supplierName+"'";
}
else{
hql += " and d.supplierName is null";
}
List<DeliveryOrderEntity> list = entityManager
.createQuery(hql)
.getResultList();
entityManager.close();
return list.size();
}
}