Merge remote-tracking branch 'origin/master'

admin

2019-03-14 eed607d87b2eee1f09b4a28da614f3ad0b46601d

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
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
package com.yeshi.fanli.service.impl.goods; 
 
import java.io.Serializable; 
import java.util.ArrayList; 
import java.util.List; 
 
import javax.annotation.Resource; 
 
import org.hibernate.HibernateException; 
import org.hibernate.Query; 
import org.hibernate.Session; 
import org.hibernate.Transaction; 
import org.springframework.cache.annotation.Cacheable; 
import org.springframework.orm.hibernate4.HibernateCallback; 
import org.springframework.stereotype.Service; 
 
import com.yeshi.fanli.dao.goods.SuperRecommendSpecialDao; 
import com.yeshi.fanli.entity.bus.recommend.RecommendSpecial; 
import com.yeshi.fanli.entity.bus.su.recommend.SuperRecommendSpecial; 
import com.yeshi.fanli.entity.system.BusinessSystem; 
import com.yeshi.fanli.service.inter.config.BusinessSystemService; 
import com.yeshi.fanli.service.inter.goods.SuperRecommendSpecialService; 
 
@Service 
public class SuperRecommendSpecialServiceImpl implements 
        SuperRecommendSpecialService { 
 
    @Resource 
    private SuperRecommendSpecialDao superRecommendSpecialDao; 
     
    @Resource 
    private BusinessSystemService businessSystemService; 
     
    @Cacheable(value="specialCache",key="#root.methodName+#id") 
    public List<SuperRecommendSpecial> getSuperRecommendSpecialBySystemId( 
            long id) { 
         
        return superRecommendSpecialDao.list("from SuperRecommendSpecial srs where srs.system.id=? order by srs.recommendSpecial.orderby  ", new Serializable[]{id}); 
    } 
 
    public List<SuperRecommendSpecial> getSuperRecommendSpecials( 
            List<Long> rsIdList) { 
 
        if (rsIdList.size() == 0) { 
            return new ArrayList<SuperRecommendSpecial>(); 
        } 
        StringBuffer sb = new StringBuffer(" from SuperRecommendSpecial srs "); 
        Serializable[] serArr = new Serializable[rsIdList.size()]; 
        for (int i = 0; i < rsIdList.size(); i++) { 
            if (i == 0) { 
                sb.append(" where srs.recommendSpecial.id=? "); 
            } else { 
                sb.append(" or srs.recommendSpecial.id=? "); 
            } 
            serArr[i] = rsIdList.get(i); 
        } 
        sb.append(" order by srs.recommendSpecial.orderby   "); 
        String hql = sb.toString(); 
 
        return superRecommendSpecialDao.list(hql, serArr); 
 
     
    } 
 
    public Integer deleteSuperRecommendSpecial(final long rsid, final String platform, 
            final String packageName) { 
        return  (Integer) superRecommendSpecialDao.excute(new HibernateCallback<Integer>() { 
 
            public Integer doInHibernate(Session session) 
                    throws HibernateException { 
                BusinessSystem system = businessSystemService.getBusinessSystem(platform, packageName); 
                Transaction transaction = session.beginTransaction(); 
                Query query = session.createQuery("delete SuperRecommendSpecial srb " 
                            + " where srb.recommendSpecial.id=? and srb.system.id=?"); 
                query.setLong(0, rsid); 
                query.setLong(1, system.getId()); 
                int i = query.executeUpdate(); 
                transaction.commit(); 
                return i ; 
            } 
        }); 
    } 
 
    public void addSuperRecommendSpecial(long rsid, String platform, 
            String packageName) { 
 
        BusinessSystem system = businessSystemService.getBusinessSystem(platform,packageName); 
        SuperRecommendSpecial superRecommendSpecial = new SuperRecommendSpecial(); 
        RecommendSpecial recommendSpecial = new RecommendSpecial(); 
        recommendSpecial.setId(rsid); 
        superRecommendSpecial.setRecommendSpecial(recommendSpecial); 
        superRecommendSpecial.setSystem(system); 
        superRecommendSpecialDao.create(superRecommendSpecial); 
     
    } 
 
    public void deleteSuperRecommendSpecials(final long[] rsids) { 
         superRecommendSpecialDao.excute(new HibernateCallback() { 
 
            public Object doInHibernate(Session session) throws HibernateException { 
                 
                StringBuffer sb = new StringBuffer("delete from SuperRecommendSpecial s "); 
                for (int i = 0; i < rsids.length; i++) { 
                    if(i==0){ 
                        sb.append(" where s.recommendSpecial.id=? "); 
                    }else{ 
                        sb.append(" or s.recommendSpecial.id=?"); 
                    } 
                } 
                Query query = session.createQuery(sb.toString()); 
                for (int i = 0; i < rsids.length; i++) { 
                    query.setLong(i, rsids[i]); 
                } 
                int ii = query.executeUpdate(); 
                java.lang.System.out.println(ii); 
                return null; 
            } 
        }); 
    } 
 
    public List<SuperRecommendSpecial> getSuperRecommendSpecialBySystemId( 
            long id, int start, int count) { 
         
        return superRecommendSpecialDao.list("from SuperRecommendSpecial srs where srs.system.id=?  order by srs.recommendSpecial.orderby   ",start,count,new Serializable[]{id}); 
         
    } 
 
    public List<SuperRecommendSpecial> getSuperRecommendSpecialBySystemId( 
            long id, int start, int count, String key) { 
        return superRecommendSpecialDao.list("from SuperRecommendSpecial srs where srs.system.id=? and srs.recommendSpecial.name like ?  order by srs.recommendSpecial.orderby  ",start,count,new Serializable[]{id, key}); 
         
    } 
 
}