From 8cf23534166c07e711aac2a25911ada317ba01f0 Mon Sep 17 00:00:00 2001 From: hjg <hjg@123.com> Date: 星期三, 30 十月 2024 09:51:00 +0800 Subject: [PATCH] 主测试切换 --- JavaSource/com/mandi/basicconfig/mapper/FdRepertoryNexusMapper.java | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/JavaSource/com/mandi/basicconfig/mapper/FdRepertoryNexusMapper.java b/JavaSource/com/mandi/basicconfig/mapper/FdRepertoryNexusMapper.java index 83278f8..01abf1f 100644 --- a/JavaSource/com/mandi/basicconfig/mapper/FdRepertoryNexusMapper.java +++ b/JavaSource/com/mandi/basicconfig/mapper/FdRepertoryNexusMapper.java @@ -33,7 +33,7 @@ @Select("select * from fd_repertory_nexus where sdepartNo=#{sdepartNo} ") public List<FdRepertoryNexus> getBySdepartNo(String sdepartNo); - @Select("select b.name+'('+a.name+')' ckName,b.code+'_'+a.depotNo as code from repertory a LEFT JOIN nc_ywdy b on a.pk_org =b.pkid where a.depotNo LIKE 'C%' and b.code in ('101','102','103','113','111') ORDER BY b.code ASC ") + @Select("select b.name+'('+a.name+')' ckName,b.code+'_'+a.depotNo as code from repertory a LEFT JOIN nc_ywdy b on a.pk_org =b.pkid where a.depotNo LIKE 'C%' and b.code in ('101','102','103','113','111','114') ORDER BY b.code ASC ") public List<Map<String, Object>> getAllCk(); -- Gitblit v1.9.3