From 27fcef09b5af8d6816babf3cf063a8d62726e1d0 Mon Sep 17 00:00:00 2001
From: zhoushihao <zsh19950802@163.com>
Date: 星期五, 19 四月 2024 09:18:01 +0800
Subject: [PATCH] 1、下片模块新增多数据源sqlserver配置 可供其他模块有需要配置的参考 2、 a、需要在各自pom文件中添加sqlserver依赖     b、在对应mapper文件中加入DS注解     c、在配置文件中配置数据源     d、主库不需要要添加DS注解指定数据库

---
 hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/taskcache/service/impl/TaskCacheServiceImpl.java |   44 ++++++++++++++++++++++++++------------------
 1 files changed, 26 insertions(+), 18 deletions(-)

diff --git a/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/taskcache/service/impl/TaskCacheServiceImpl.java b/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/taskcache/service/impl/TaskCacheServiceImpl.java
index 0fc6b8b..73efed6 100644
--- a/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/taskcache/service/impl/TaskCacheServiceImpl.java
+++ b/hangzhoumesParent/moduleService/CacheGlassModule/src/main/java/com/mes/taskcache/service/impl/TaskCacheServiceImpl.java
@@ -1,11 +1,10 @@
 package com.mes.taskcache.service.impl;
 
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
-import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.mes.glassinfo.entity.GlassInfo;
 import com.mes.glassinfo.mapper.GlassInfoMapper;
-import com.mes.glassinfo.service.GlassInfoService;
 import com.mes.taskcache.entity.TaskCache;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.mes.taskcache.mapper.TaskCacheMapper;
 import com.mes.taskcache.service.TaskCacheService;
 import org.springframework.beans.factory.annotation.Autowired;
@@ -23,38 +22,47 @@
  */
 @Service
 public class TaskCacheServiceImpl extends ServiceImpl<TaskCacheMapper, TaskCache> implements TaskCacheService {
+
+    @Autowired
+    GlassInfoMapper glassInfoMapper;
+    @Autowired
+    TaskCacheMapper taskCacheMapper;
     //娣诲姞鐞嗙墖绗间换鍔�
+    @Override
     public boolean insertTaskCache(TaskCache taskCache){
-        return this.save(taskCache);
+        taskCacheMapper.insert(taskCache);
+        return true;
     }
-
     //鏌ヨ纾ㄨ竟浠诲姟
-    public List<TaskCache> selectEdgInfo(String line){
-
+    @Override
+    public List<TaskCache> selectEdgInfo(String line) {
+        return taskCacheMapper.selectList(new QueryWrapper<TaskCache>().eq("endcell",line));
     }
-
-    //鏌ヨ鐞嗙墖浠诲姟
+    //鏌ヨ寰呯悊鐗囧伐浣滅殑浠诲姟
+    @Override
     public List<TaskCache> selectCacheInfo(){
-
+        return taskCacheMapper.selectList(new QueryWrapper<TaskCache>().eq("taskstauts",0));
     }
-
     //鏌ヨ鍏ㄩ儴浠诲姟
-    public List<TaskCache> selectAll(){
-
+    @Override
+    public List<TaskCache> selectAll() {
+        return taskCacheMapper.selectList(null);
     }
-
-    //鏌ヨ杩涚墖浠诲姟
+    //鏌ヨ寰呰繘鐗囦换鍔�
+    @Override
     public List<TaskCache> selectInputTaskCache(){
-
+        return taskCacheMapper.selectList(new QueryWrapper<TaskCache>().eq("taskstauts",0).eq("tasktype",1));
     }
 
-    //鏌ヨ鍑虹墖浠诲姟
+    //鏌ヨ寰呭嚭鐗囦换鍔�
+    @Override
     public List<TaskCache> selectOutTaskCache(){
-
+        return taskCacheMapper.selectList(new QueryWrapper<TaskCache>().eq("taskstauts",0).eq("tasktype",2));
     }
 
     //鏌ヨ  A09  鎴� A10 鏈�鏂扮殑涓�鐗� 鍑虹墖浠诲姟
+    @Override
     public List<TaskCache> selectLastOutCacheInfo(String line){
-
+        return taskCacheMapper.selectList(new QueryWrapper<TaskCache>().eq("endcell",line).eq("taskstauts",1).orderByDesc("ID"));
     }
 }

--
Gitblit v1.8.0