admin
2018-12-10 01d627f3c67e2bc5c28b2dd5e23983ddcf7a08f3
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
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);
    }
}