package com.yeshi.fanli.service.impl.hongbao;
|
|
import java.util.List;
|
|
import javax.annotation.Resource;
|
|
import org.hibernate.HibernateException;
|
import org.hibernate.SQLQuery;
|
import org.hibernate.Session;
|
import org.springframework.orm.hibernate4.HibernateCallback;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
import com.yeshi.fanli.dao.hongbao.HongBaoMessageDao;
|
import com.yeshi.fanli.entity.bus.user.HongBaoMessage;
|
import com.yeshi.fanli.service.inter.hongbao.HongBaoMessageService;
|
import com.yeshi.fanli.util.Constant;
|
|
@Service
|
public class HongBaoMessageServiceImpl implements HongBaoMessageService {
|
|
@Resource
|
private HongBaoMessageDao dao;
|
|
@SuppressWarnings("unchecked")
|
public List<HongBaoMessage> getList() {
|
|
return (List<HongBaoMessage>) dao.excute(new HibernateCallback<List<HongBaoMessage>>() {
|
|
public List<HongBaoMessage> doInHibernate(Session session)
|
throws HibernateException {
|
SQLQuery query = session.createSQLQuery("SELECT * FROM yeshi_ec_hongbao_message ORDER BY RAND()").addEntity(HongBaoMessage.class);
|
query.setFirstResult(0);
|
query.setMaxResults(Constant.PAGE_SIZE);
|
return query.list();
|
}
|
});
|
|
}
|
|
@Transactional
|
public void add(List<HongBaoMessage> list) {
|
for (HongBaoMessage hongBaoMessage : list) {
|
dao.save(hongBaoMessage);
|
}
|
}
|
|
}
|
