From 24bd7f9d2d4dd24f3c4b75972733a2c9cf03bddf Mon Sep 17 00:00:00 2001
From: lxw <810412026@qq.com>
Date: 星期二, 21 二月 2023 11:30:11 +0800
Subject: [PATCH] 分页查询ECR记录
---
src/main/java/com/whyc/service/ECRService.java | 17 +++++++++++++++++
1 files changed, 17 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/ECRService.java b/src/main/java/com/whyc/service/ECRService.java
index 8635630..f22abc0 100644
--- a/src/main/java/com/whyc/service/ECRService.java
+++ b/src/main/java/com/whyc/service/ECRService.java
@@ -1,5 +1,8 @@
package com.whyc.service;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.github.pagehelper.PageHelper;
+import com.github.pagehelper.PageInfo;
import com.whyc.dto.Response;
import com.whyc.mapper.ECRMapper;
import com.whyc.pojo.ECR;
@@ -227,4 +230,18 @@
mapper.insertBatchSomeColumn(ecrList);
return new Response().set(1,true,"瀵煎叆瀹屾垚");
}
+ //鍒嗛〉鏌ヨECR璁板綍
+ public Response ecrImport(int number, String subCode, String subModel, Date createTime, Date createTime1, int pageCurr, int pageSize) {
+ PageHelper.startPage(pageCurr,pageSize);
+ QueryWrapper wrapper=new QueryWrapper();
+ wrapper.like("number",number);
+ wrapper.like("sub_code",subCode);
+ wrapper.like("sub_model",subModel);
+ wrapper.ge("create_time",createTime);
+ wrapper.le("create_time",createTime1);
+ wrapper.orderByAsc("number");
+ List list=mapper.selectList(wrapper);
+ PageInfo pageInfo=new PageInfo(list);
+ return new Response().setII(1,list.size()>0,pageInfo,"鏌ヨECR璁板綍");
+ }
}
--
Gitblit v1.9.1