From cdcbed9af813b2a02cdc01eefa24db8bec6b51a9 Mon Sep 17 00:00:00 2001
From: yujian <yujian>
Date: 星期三, 27 三月 2019 12:17:33 +0800
Subject: [PATCH] 主分类 + 子分类 DAO改造
---
fanli/src/main/java/com/yeshi/fanli/service/impl/user/AccountMessageServiceImpl.java | 24 ++++++------------------
1 files changed, 6 insertions(+), 18 deletions(-)
diff --git a/fanli/src/main/java/com/yeshi/fanli/service/impl/user/AccountMessageServiceImpl.java b/fanli/src/main/java/com/yeshi/fanli/service/impl/user/AccountMessageServiceImpl.java
index 635dc79..564fbed 100644
--- a/fanli/src/main/java/com/yeshi/fanli/service/impl/user/AccountMessageServiceImpl.java
+++ b/fanli/src/main/java/com/yeshi/fanli/service/impl/user/AccountMessageServiceImpl.java
@@ -9,13 +9,13 @@
import org.springframework.orm.hibernate4.HibernateCallback;
import org.springframework.stereotype.Service;
-import com.yeshi.fanli.dao.config.SystemZnxDao;
import com.yeshi.fanli.dao.mybatis.AccountMessageMapper;
import com.yeshi.fanli.dao.user.UserInfoDao;
import com.yeshi.fanli.entity.bus.user.AccountMessage;
import com.yeshi.fanli.entity.bus.user.UserInfo;
import com.yeshi.fanli.entity.system.SystemZnx;
import com.yeshi.fanli.service.inter.user.AccountMessageService;
+import com.yeshi.fanli.service.inter.user.SystemZnxService;
import com.yeshi.fanli.util.Constant;
@Service
@@ -25,8 +25,9 @@
private AccountMessageMapper accountMessageMapper;
@Resource
private UserInfoDao userInfoDao;
+
@Resource
- private SystemZnxDao systemZnxDao;
+ private SystemZnxService systemZnxService;
@Override
public List<AccountMessage> findAccountMessageList(long uid, int page) {
@@ -67,22 +68,9 @@
UserInfo userInfo = userInfoDao.find(UserInfo.class, uid);
if (userInfo == null)
return;
- List<SystemZnx> list = (List<SystemZnx>) systemZnxDao.excute(new HibernateCallback<List<SystemZnx>>() {
- @SuppressWarnings("unchecked")
- @Override
- public List<SystemZnx> doInHibernate(Session session) throws HibernateException {
- List result = session
- .createSQLQuery(
- "SELECT sm.* FROM `yeshi_ec_system_msg` sm LEFT JOIN (SELECT * FROM `yeshi_ec_account_message` a WHERE a.`uid`=? AND a.`system_msg_id` IS NOT NULL) s ON s.`system_msg_id`=sm.`id` WHERE s.`system_msg_id` IS NULL and sm.createTime>="
- + userInfo.getCreatetime())
- .addEntity(SystemZnx.class).setParameter(0, uid).list();
- if (result != null) {
- List<SystemZnx> list = (List<SystemZnx>) result;
- return list;
- }
- return null;
- }
- });
+
+ List<SystemZnx> list = systemZnxService.listbyUidAndCreateTime(uid, userInfo.getCreatetime());
+
if (list != null)
for (SystemZnx systemZnx : list) {
AccountMessage accountMessage = new AccountMessage();
--
Gitblit v1.8.0