From 588f83a71381a79d3c391f5df0b8e266f397264f Mon Sep 17 00:00:00 2001 From: CZT <czt18638530771@163.com> Date: 星期六, 04 十一月 2023 17:07:44 +0800 Subject: [PATCH] 优化通知单绑定计划详细 --- igds-inout/src/main/java/com/ld/igds/m/service/HPlanManageService.java | 22 ++++++++++++++++++++++ 1 files changed, 22 insertions(+), 0 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..fa53772 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 @@ -190,4 +190,26 @@ 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