| | |
| | | @Resource |
| | | private SuperHomeNoticeDao superHomeNoticeDao; |
| | | |
| | | public SuperHomeNoticeDao getSuperHomeNoticeDao() { |
| | | return superHomeNoticeDao; |
| | | } |
| | | |
| | | public void setSuperHomeNoticeDao(SuperHomeNoticeDao superHomeNoticeDao) { |
| | | this.superHomeNoticeDao = superHomeNoticeDao; |
| | | } |
| | | |
| | | public VideoInfoDao getVideoInfoDao() { |
| | | return videoInfoDao; |
| | | } |
| | | |
| | | public void setVideoInfoDao(VideoInfoDao videoInfoDao) { |
| | | this.videoInfoDao = videoInfoDao; |
| | | } |
| | | |
| | | public HomeNoticeDao getHomeNoticeDao() { |
| | | return homeNoticeDao; |
| | | } |
| | | |
| | | public void setHomeNoticeDao(HomeNoticeDao homeNoticeDao) { |
| | | this.homeNoticeDao = homeNoticeDao; |
| | | } |
| | | |
| | | // 首页公告 |
| | | public List<HomeNotice> getHomeNoticeList(SystemInfo system) { |
| | | List<HomeNotice> list = homeNoticeDao |
| | |
| | | |
| | | // 后台操作 |
| | | @SuppressWarnings("unchecked") |
| | | public List<HomeNoticeAdmin> getHomeNoticeAdmin(final String key, final int detailSystem, final int page) { |
| | | public List<HomeNoticeAdmin> getHomeNoticeAdmin(final String key, final SystemInfo system, final int page) { |
| | | |
| | | return (List<HomeNoticeAdmin>) homeNoticeDao.excute(new HibernateCallback<List<HomeNoticeAdmin>>() { |
| | | public List<HomeNoticeAdmin> doInHibernate(Session session) throws HibernateException { |
| | | List<HomeNoticeAdmin> zhiBoClassList = new ArrayList<>(); |
| | | try { |
| | | List<DetailSystem> detailSystemList = session.createQuery("from DetailSystem").list(); |
| | | List<DetailSystem> detailSystemList = session.createQuery("from DetailSystem d where d.system.id="+system.getId()).list(); |
| | | String sql = ""; |
| | | if (detailSystem > 0) |
| | | sql = "select sh.homeNotice from SuperHomeNotice sh where sh.detailSystem.id=" + detailSystem |
| | | if (system!=null) |
| | | sql = "select sh.homeNotice from SuperHomeNotice sh where sh.detailSystem.system.id=" + system.getId() |
| | | + " order by sh.homeNotice.createtime desc"; |
| | | else |
| | | sql = "from HomeNotice zb order by zb.createtime desc"; |