布丸代码优化

admin

2021-03-01 d73687bc6115007145b4aab050e4e29ff87fd8ae

 src/main/java/com/yeshi/buwan/service/imp/HomeAdService.java

@@ -30,22 +30,6 @@
   @Resource
   private SuperHomeAdDao superHomeAdDao;

   public SuperHomeAdDao getSuperHomeAdDao() {
      return superHomeAdDao;
   }

   public void setSuperHomeAdDao(SuperHomeAdDao superHomeAdDao) {
      this.superHomeAdDao = superHomeAdDao;
   }

   public HomeAdDao getHomeAdDao() {
      return homeAdDao;
   }

   public void setHomeAdDao(HomeAdDao homeAdDao) {
      this.homeAdDao = homeAdDao;
   }

   public List<HomeAd> getHomeAdList(SystemInfo system) {
      List<HomeAd> list = homeAdDao
            .list("from HomeAd h where h.system.id=" + system.getId() + " order by  h.orderby desc");
@@ -152,18 +136,18 @@

   // 后台操作
   @SuppressWarnings("unchecked")
   public List<HomeAdAdmin> getHomeAdAdmin(final String key, final int detailSystem, final int page) {
    public List<HomeAdAdmin> getHomeAdAdmin(final String key, final String systemId, final int detailSystem, final int page) {
      return (List<HomeAdAdmin>) homeAdDao.excute(new HibernateCallback<List<HomeAdAdmin>>() {
         public List<HomeAdAdmin> doInHibernate(Session session) throws HibernateException {
            List<HomeAdAdmin> zhiBoClassList = new ArrayList<>();
            try {
               List<DetailSystem> detailSystemList = session.createQuery("from DetailSystem").list();
                    List<DetailSystem> detailSystemList = session.createQuery("from DetailSystem ds where ds.system.id=" + systemId).list();
               String sql = "";
               if (detailSystem > 0)
                  sql = "select sh.homeAd from SuperHomeAd sh where  sh.detailSystem.id=" + detailSystem
                        + " order by  sh.homeAd.createtime desc";
               else
                  sql = "from HomeAd zb order by zb.createtime desc";
                        sql = "from HomeAd zb where zb.system.id=" + systemId + " order by zb.createtime desc";

               List<HomeAd> list = session.createQuery(sql).setFirstResult((page - 1) * Constant.pageCount)
                     .setMaxResults(Constant.pageCount).list();
@@ -204,13 +188,13 @@
      });
   }

   public long getHomeAdAdminCount(String key, int detailSystem) {
    public long getHomeAdAdminCount(String key, String systemId, int detailSystem) {
      String sql = "";
      if (detailSystem > 0)
         sql = "select count(*) from  (select count(*) from wk_video_super_homead zb left join wk_video_homead c on c.id=zb.homeadid where zb.detailsystemid="
               + detailSystem + " group by zb.homeadid) s";
      else
         sql = "select count(*) from  wk_video_homead";
            sql = "select count(*) from  wk_video_homead where system="+systemId;
      return homeAdDao.getCountSQL(sql);
   }