| | |
|---|
| | | @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(); |
|---|
| | | |
|---|
| | | |
|---|
