From 51a4ff5d777028d52a19c314a99f796334cb7b51 Mon Sep 17 00:00:00 2001
From: admin <weikou2014>
Date: 星期六, 23 十一月 2019 18:30:01 +0800
Subject: [PATCH] 配置文件修改
---
fanli/src/main/java/com/yeshi/fanli/service/impl/goods/SuperRecommendBannerServiceImpl.java | 133 +++----------------------------------------
1 files changed, 11 insertions(+), 122 deletions(-)
diff --git a/fanli/src/main/java/com/yeshi/fanli/service/impl/goods/SuperRecommendBannerServiceImpl.java b/fanli/src/main/java/com/yeshi/fanli/service/impl/goods/SuperRecommendBannerServiceImpl.java
index 3a5e517..85058bc 100644
--- a/fanli/src/main/java/com/yeshi/fanli/service/impl/goods/SuperRecommendBannerServiceImpl.java
+++ b/fanli/src/main/java/com/yeshi/fanli/service/impl/goods/SuperRecommendBannerServiceImpl.java
@@ -1,141 +1,30 @@
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.SuperRecommendBannerDao;
-import com.yeshi.fanli.entity.bus.recommend.RecommendBanner;
+import com.yeshi.fanli.dao.mybatis.homemodule.SuperRecommendBannerMapper;
import com.yeshi.fanli.entity.bus.su.recommend.SuperRecommendBanner;
-import com.yeshi.fanli.entity.system.System;
-import com.yeshi.fanli.service.inter.config.SystemService;
+import com.yeshi.fanli.entity.system.BusinessSystem;
+import com.yeshi.fanli.service.inter.config.BusinessSystemService;
import com.yeshi.fanli.service.inter.goods.SuperRecommendBannerService;
-import com.yeshi.fanli.util.Constant;
@Service
-public class SuperRecommendBannerServiceImpl implements
- SuperRecommendBannerService {
+public class SuperRecommendBannerServiceImpl implements SuperRecommendBannerService {
@Resource
- private SuperRecommendBannerDao superRecommendBannerDao;
-
+ private SuperRecommendBannerMapper superRecommendBannerMapper;
+
@Resource
- private SystemService systemService;
- @Cacheable(value={"bannerCache"}, key="#root.methodName+#system.id")
- public List<SuperRecommendBanner> getSuperRecommendBannersBySystem(
- final System system) {
- List<SuperRecommendBanner> list = superRecommendBannerDao.list(
- "from SuperRecommendBanner srb where srb.system.id=? order by srb.recommendBanner.orderby",
- new Serializable[] { system.getId() });
+ private BusinessSystemService businessSystemService;
+
+ @Cacheable(value = { "bannerCache" }, key = "#root.methodName+#system.id")
+ public List<SuperRecommendBanner> getSuperRecommendBannersBySystem(final BusinessSystem system) {
+ List<SuperRecommendBanner> list = superRecommendBannerMapper.listBySystem(system.getId());
return list;
}
-
- public List<SuperRecommendBanner> getSuperRecommendBanners(int pageIndex) {
-
- int start = pageIndex * Constant.PAGE_SIZE;
-
- List<SuperRecommendBanner> list = superRecommendBannerDao.list(
- "from SuperRecommendBanner srb order by srb.recommendBanner.orderby", start, Constant.PAGE_SIZE,
- new Serializable[] {});
-
- return list;
- }
-
- public List<SuperRecommendBanner> getSuperRecommendBannersByBanners(
- List<Long> rbIdList) {
- if (rbIdList.size() == 0) {
- return new ArrayList<SuperRecommendBanner>();
- }
- StringBuffer sb = new StringBuffer(" from SuperRecommendBanner srb ");
- Serializable[] serArr = new Serializable[rbIdList.size()];
- for (int i = 0; i < rbIdList.size(); i++) {
- if (i == 0) {
- sb.append(" where srb.recommendBanner.id=? ");
- } else {
- sb.append(" or srb.recommendBanner.id=? ");
- }
- serArr[i] = rbIdList.get(i);
- }
- sb.append(" order by srb.recommendBanner.orderby ");
- String hql = sb.toString();
-
- return superRecommendBannerDao.list(hql, serArr);
-
- }
-
- public Integer deleteSuperRecommendBanner(final long rbid, final String platform,final String packageName) {
- return (Integer) superRecommendBannerDao.excute(new HibernateCallback<Integer>() {
-
- public Integer doInHibernate(Session session)
- throws HibernateException {
- System system = systemService.getSystem(platform, packageName);
- Transaction transaction = session.beginTransaction();
- Query query = session.createQuery("delete SuperRecommendBanner srb "
- + " where srb.recommendBanner.id=? and srb.system.id=?");
- query.setLong(0, rbid);
- query.setLong(1, system.getId());
- int i = query.executeUpdate();
- transaction.commit();
- return i ;
- }
- });
- }
-
- public void addSuperRecommendBanner(long rbid, String platform,String packageName) {
- System system = systemService.getSystem(platform,packageName);
- SuperRecommendBanner superRecommendBanner = new SuperRecommendBanner();
- RecommendBanner recommendBanner = new RecommendBanner();
- recommendBanner.setId(rbid);
- superRecommendBanner.setRecommendBanner(recommendBanner);
- superRecommendBanner.setSystem(system);
- superRecommendBannerDao.create(superRecommendBanner);
- }
-
- public void deleteSuperRecommendBanners(final long[] rbids) {
- superRecommendBannerDao.excute(new HibernateCallback() {
-
- public Object doInHibernate(Session session) throws HibernateException {
-
- StringBuffer sb = new StringBuffer("delete from SuperRecommendBanner s ");
- for (int i = 0; i < rbids.length; i++) {
- if(i==0){
- sb.append(" where s.recommendBanner.id=? ");
- }else{
- sb.append(" or s.recommendBanner.id=?");
- }
- }
- Query query = session.createQuery(sb.toString());
- for (int i = 0; i < rbids.length; i++) {
- query.setLong(i, rbids[i]);
- }
- query.executeUpdate();
- return null;
- }
- });
- }
-
- public List<SuperRecommendBanner> getSuperRecommendBannerBySystemId(
- long id, int strat, int count) {
- return superRecommendBannerDao.list("from SuperRecommendBanner srs where srs.system.id=? order by srs.recommendBanner.orderby ",strat,count,new Serializable[]{id});
-
- }
-
-
- public List<SuperRecommendBanner> getSuperRecommendBannerBySystemId(
- long id, int strat, int count, String key) {
- return superRecommendBannerDao.list("from SuperRecommendBanner srs where srs.system.id=? and srs.recommendBanner.name like ?",strat,count,new Serializable[]{id, key});
-
- }
-
-
}
--
Gitblit v1.8.0