From 83c2b6cbf12ed3308eb875f517f2a1ed53d2dc9e Mon Sep 17 00:00:00 2001 From: jiangshuang <jswswws@163.com> Date: 星期五, 25 十月 2024 15:12:37 +0800 Subject: [PATCH] CRM>分单系统销售退货单同步 --- 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