From 8dd1d1ce18876c78d30e8c2d9876af892711037f Mon Sep 17 00:00:00 2001
From: whyclxw <810412026@qq.com>
Date: 星期一, 04 十一月 2024 11:11:19 +0800
Subject: [PATCH] 查询动环信息和动环的子件信息
---
src/main/java/com/whyc/service/SubInfService.java | 42 ++++++++++++++++++++++++++++++++++++++++++
1 files changed, 42 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/SubInfService.java b/src/main/java/com/whyc/service/SubInfService.java
index 5b073b6..4b67488 100644
--- a/src/main/java/com/whyc/service/SubInfService.java
+++ b/src/main/java/com/whyc/service/SubInfService.java
@@ -1,6 +1,12 @@
package com.whyc.service;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
+import com.github.pagehelper.PageHelper;
+import com.github.pagehelper.PageInfo;
+import com.whyc.dto.Response;
import com.whyc.mapper.SubInfMapper;
+import com.whyc.pojo.CircleInf;
import com.whyc.pojo.SubInf;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@@ -17,4 +23,40 @@
subList.stream().forEach(sinf->sinf.setDeviceId(devId));
mapper.insertBatchSomeColumn(subList);
}
+ //鑾峰彇瀛愪欢淇℃伅
+ public Response getSub(SubInf sub, int pageCurr, int pageSize) {
+ PageHelper.startPage(pageCurr,pageSize);
+ QueryWrapper wrapper=new QueryWrapper();
+ if(sub.getSubType()!=null){
+ wrapper.eq("sub_type",sub.getSubType());
+ }
+
+ if(sub.getSubPropertyName()!=null){
+ wrapper.eq("sub_property_name",sub.getSubPropertyName());
+ }
+
+ if(sub.getStartTime()!=null){
+ wrapper.ge("sub_inuse_date",sub.getStartTime());
+ }
+ if(sub.getEndTime()!=null){
+ wrapper.le("sub_inuse_date",sub.getEndTime());
+ }
+ List<SubInf> list=mapper.selectList(wrapper);
+ PageInfo pageInfo=new PageInfo(list);
+ return new Response().setII(1,list!=null,pageInfo,"鑾峰彇瀛愪欢淇℃伅");
+ }
+ //娣诲姞鍔ㄧ幆
+ public void addSub(SubInf sub) {
+ mapper.insert(sub);
+ }
+ //鏇存柊鐢垫簮
+ public void updateSub(SubInf sub) {
+ UpdateWrapper<SubInf> wrapper = new UpdateWrapper<SubInf>().eq("sub_id",sub.getSubId());
+ mapper.update(sub,wrapper);
+ }
+ //鍒犻櫎鐢垫簮
+ public void deleteSub(Integer subId) {
+ QueryWrapper<SubInf> wrapper = new QueryWrapper<SubInf>().eq("sub_id",subId);
+ mapper.delete(wrapper);
+ }
}
\ No newline at end of file
--
Gitblit v1.9.1