From c206acfaedc69c390fb67daa81bc686f58a212ef Mon Sep 17 00:00:00 2001
From: CZT <czt18638530771@163.com>
Date: 星期一, 27 十一月 2023 16:12:11 +0800
Subject: [PATCH] 提交配置信息2
---
igds-inout/src/main/java/com/ld/igds/m/service/HPlanManageService.java | 25 +++++++++++++++++++++++--
1 files changed, 23 insertions(+), 2 deletions(-)
diff --git a/igds-inout/src/main/java/com/ld/igds/m/service/HPlanManageService.java b/igds-inout/src/main/java/com/ld/igds/m/service/HPlanManageService.java
index a72adf1..4bdc6d4 100644
--- a/igds-inout/src/main/java/com/ld/igds/m/service/HPlanManageService.java
+++ b/igds-inout/src/main/java/com/ld/igds/m/service/HPlanManageService.java
@@ -179,15 +179,36 @@
public List<InoutPlan> getPlanId(InoutPlan plan) {
String hql = " from " + InoutPlan.class.getName()
- + " where companyId =:companyId and deptId =:deptId and year =:year";
+ + " where companyId =:companyId and year =:year";
Map<String, Object> args = new HashMap<String, Object>();
args.put("companyId", plan.getCompanyId());
- args.put("deptId", plan.getDeptId());
args.put("year", plan.getYear());
hql += " order by createTime desc";
return this.query(hql, args);
}
+
+ public void pagePlanDetail(Page<InoutPlanDetail> page, Map<String, Object> param)
+ throws Exception {
+ String hql = " from " + InoutPlanDetail.class.getName()
+ + " where 1=1 ";
+
+ Map<String, Object> args = new HashMap<String, Object>();
+
+ if (null != param) {
+ String str = (String) param.get("key");
+ if (StringUtils.isNotEmpty(str)) {
+ hql += " and year like :year ";
+ args.put("year", "%" + str + "%");
+ }
+ }
+
+ String count = "select count(*) " + hql;
+
+ hql += " order by updateTime desc";
+
+ this.pagingQuery(page, hql, count, args);
+ }
}
--
Gitblit v1.9.3