From 5f708178b260cabf081f9049cf51e9ad66ae2911 Mon Sep 17 00:00:00 2001
From: tuqin <tuqin@tuqin.cn>
Date: 星期四, 10 九月 2026 14:49:29 +0800
Subject: [PATCH] feat(erp/mes): 新增采购订单/销售订单/计量器具 Excel 导入，含导入菜单权限 SQL
---
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/dv/metering/MesDvMeteringMapper.java | 18 ++++++++++++++++++
1 files changed, 18 insertions(+), 0 deletions(-)
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/dv/metering/MesDvMeteringMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/dv/metering/MesDvMeteringMapper.java
index 1583a20..4f79347 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/dv/metering/MesDvMeteringMapper.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/dv/metering/MesDvMeteringMapper.java
@@ -1,11 +1,15 @@
package cn.iocoder.yudao.module.mes.dal.mysql.dv.metering;
import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import com.baomidou.mybatisplus.annotation.InterceptorIgnore;
import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
import cn.iocoder.yudao.module.mes.controller.admin.dv.metering.vo.MesDvMeteringPageReqVO;
import cn.iocoder.yudao.module.mes.dal.dataobject.dv.metering.MesDvMeteringDO;
import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
+import org.apache.ibatis.annotations.Update;
import java.time.LocalDate;
import java.util.List;
@@ -36,6 +40,20 @@
return selectOne(MesDvMeteringDO::getCode, code);
}
+ /**
+ * 鎸夌紪鐮佹煡璇紙鍚�滃凡琚�昏緫鍒犻櫎鈥濈殑璁板綍锛夆�斺�旂敤浜庡鍏ユ椂鍒ら噸
+ */
+ @InterceptorIgnore(tenantLine = "true", dataPermission = "true")
+ @Select("SELECT * FROM mes_dv_metering WHERE code = #{code} ORDER BY id DESC LIMIT 1")
+ MesDvMeteringDO selectByCodeIncludeDeleted(@Param("code") String code);
+
+ /**
+ * 鎭㈠琚�昏緫鍒犻櫎鐨勮褰曪紙鎶� deleted 缃洖 0锛�
+ */
+ @InterceptorIgnore(tenantLine = "true", dataPermission = "true")
+ @Update("UPDATE mes_dv_metering SET deleted = 0 WHERE id = #{id}")
+ int restoreDeletedById(@Param("id") Long id);
+
default List<MesDvMeteringDO> selectListByNextCheckDateBetween(LocalDate begin, LocalDate end) {
return selectList(new LambdaQueryWrapperX<MesDvMeteringDO>()
.ge(MesDvMeteringDO::getNextCheckDate, begin)
--
Gitblit v1.9.3