package com.yeshi.fanli.service.impl.config;
|
|
import java.io.Serializable;
|
import java.util.List;
|
|
import javax.annotation.Resource;
|
|
import org.hibernate.HibernateException;
|
import org.hibernate.Query;
|
import org.hibernate.Session;
|
import org.springframework.cache.annotation.Cacheable;
|
import org.springframework.orm.hibernate4.HibernateCallback;
|
import org.springframework.stereotype.Service;
|
|
import com.yeshi.fanli.dao.config.EveryDayTaskDao;
|
import com.yeshi.fanli.entity.admin.EveryDayTask;
|
import com.yeshi.fanli.service.inter.config.EveryDayTaskService;
|
import com.yeshi.fanli.util.Constant;
|
|
@Service
|
public class EveryDayTaskServiceImpl implements EveryDayTaskService {
|
|
@Resource
|
private EveryDayTaskDao everyDayTaskDao;
|
|
@Override
|
public Integer getCount() {
|
Long count = everyDayTaskDao.getCount("SELECT COUNT(1) FROM EveryDayTask edt WHERE 1 = 1");
|
return count.intValue();
|
}
|
|
@Override
|
public List<EveryDayTask> everyDayTaskList(int index, String key) {
|
|
int start = index * Constant.PAGE_SIZE;
|
return everyDayTaskDao.list("from EveryDayTask edt where edt.etGoods.title like ? order by edt.etOrderBy desc",
|
start, Constant.PAGE_SIZE, new Serializable[] { "%" + key + "%" });
|
}
|
|
@Override
|
public void deletEeveryDayTask(long id) {
|
everyDayTaskDao.excute(new HibernateCallback() {
|
public Object doInHibernate(Session session) throws HibernateException {
|
Query query = session.createQuery("delete from EveryDayTask edt where edt.id = ?");
|
query.setParameter(0, id);
|
query.executeUpdate();
|
return null;
|
}
|
});
|
}
|
|
@Override
|
public EveryDayTask getEveryDayTask(long id) {
|
return everyDayTaskDao.find(EveryDayTask.class, id);
|
}
|
|
@Override
|
public void updateEveryDayTask(EveryDayTask everyDayTask) {
|
EveryDayTask find = everyDayTaskDao.find(EveryDayTask.class, everyDayTask.getId());
|
if (find == null) {
|
return;
|
}
|
find.setEtOrderBy(everyDayTask.getEtOrderBy());
|
everyDayTaskDao.update(find);
|
}
|
|
@Cacheable(value = "config", key = "'everyDayTaskList-'+#i+'-'+#key")
|
@Override
|
public List<EveryDayTask> everyDayTaskListCache(int i, String key) {
|
return everyDayTaskList(i, key);
|
}
|
}
|