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 | 48 ++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 48 insertions(+), 0 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 87ba952..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,10 +1,16 @@
package com.mes.taskcache.service.impl;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.mes.glassinfo.entity.GlassInfo;
+import com.mes.glassinfo.mapper.GlassInfoMapper;
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;
import org.springframework.stereotype.Service;
+
+import java.util.List;
/**
* <p>
@@ -17,4 +23,46 @@
@Service
public class TaskCacheServiceImpl extends ServiceImpl<TaskCacheMapper, TaskCache> implements TaskCacheService {
+ @Autowired
+ GlassInfoMapper glassInfoMapper;
+ @Autowired
+ TaskCacheMapper taskCacheMapper;
+ //娣诲姞鐞嗙墖绗间换鍔�
+ @Override
+ public boolean insertTaskCache(TaskCache taskCache){
+ taskCacheMapper.insert(taskCache);
+ return true;
+ }
+ //鏌ヨ纾ㄨ竟浠诲姟
+ @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));
+ }
+ //鏌ヨ鍏ㄩ儴浠诲姟
+ @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