From e85cc2c7ef8388826c2c9ba7b1a691a843c3b2b0 Mon Sep 17 00:00:00 2001
From: CZT <czt18638530771@163.com>
Date: 星期二, 04 七月 2023 09:35:51 +0800
Subject: [PATCH] 提交化验项及化验数据的更新SQL
---
igds-inout/src/main/java/com/ld/igds/m/service/HMAtockChangeService.java | 7 ++++---
1 files changed, 4 insertions(+), 3 deletions(-)
diff --git a/igds-inout/src/main/java/com/ld/igds/m/service/HMAtockChangeService.java b/igds-inout/src/main/java/com/ld/igds/m/service/HMAtockChangeService.java
index 9206fc1..f086af0 100644
--- a/igds-inout/src/main/java/com/ld/igds/m/service/HMAtockChangeService.java
+++ b/igds-inout/src/main/java/com/ld/igds/m/service/HMAtockChangeService.java
@@ -30,8 +30,9 @@
String str = (String) param.get("depotId");
if (StringUtils.isNotEmpty(str)) {
- hql += " and depotId =:depotId";
- args.put("depotId", str);
+ hql += " and depotIdIn =:depotIdIn or depotIdOut =:depotIdOut";
+ args.put("depotIdIn", str);
+ args.put("depotIdOut", str);
}
}
@@ -106,7 +107,7 @@
args.put("startTime", DateUtil.getCurZero(date));
args.put("endTime", DateUtil.getNextZero(date));
}
- hql += " order by updateTime desc";
+ hql += " order by updateTime desc limit 20";
return this.query(hql, args);
}
--
Gitblit v1.9.3