配置文件修改

admin

2019-11-23 51a4ff5d777028d52a19c314a99f796334cb7b51

 fanli/src/main/java/com/yeshi/fanli/service/impl/goods/SuperRecommendBannerServiceImpl.java

@@ -1,143 +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.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 BusinessSystemService businessSystemService;

	
	
   @Cacheable(value={"bannerCache"}, key="#root.methodName+#system.id")

   public List<SuperRecommendBanner> getSuperRecommendBannersBySystem(

         final BusinessSystem system) {

      List<SuperRecommendBanner> list = superRecommendBannerDao.list(

            "from SuperRecommendBanner srb where srb.system.id=? order by srb.recommendBanner.orderby",

            new Serializable[] { system.getId() });



   @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 {

            BusinessSystem system = businessSystemService.getBusinessSystem(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) {

      BusinessSystem system = businessSystemService.getBusinessSystem(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});

		
   }



	
}