| 提交 | 用户 | 时间 | ||
| 58d006 | 1 | package com.mandi.basicconfig.mapper; |
| A | 2 | |
| 3 | import java.util.List; | |
| 4 | import java.util.Map; | |
| 5 | ||
| 6 | import org.apache.ibatis.annotations.Delete; | |
| 7 | import org.apache.ibatis.annotations.Insert; | |
| 8 | import org.apache.ibatis.annotations.Param; | |
| 9 | import org.apache.ibatis.annotations.Select; | |
| 10 | import org.apache.ibatis.annotations.Update; | |
| 11 | ||
| 12 | import com.mandi.basicconfig.persist.FdRepertoryNexus; | |
| 13 | ||
| 14 | public interface FdRepertoryNexusMapper { | |
| 15 | ||
| 16 | @Select("select * from fd_repertory_nexus where sdepartNo=#{sdepartNo} and ckNo=#{ckNo} and ywdyNo=#{ywdyNo} ") | |
| 17 | public FdRepertoryNexus getbyIds(FdRepertoryNexus renexus); | |
| 18 | @Select("select top 1 * from fd_repertory_nexus where ckNo=#{ckNo} and ywdyNo=#{ywdyNo} ") | |
| 19 | public FdRepertoryNexus getbyckNoAndYwdyNo(@Param("ckNo") String ckNo,@Param("ywdyNo") String ywdyNo); | |
| 20 | ||
| 21 | @Insert("insert into fd_repertory_nexus (sdepartNo,ckNo,ywdyNo) values (#{sdepartNo},#{ckNo},#{ywdyNo}) ") | |
| 22 | public int insertRepertoryNexus(FdRepertoryNexus renexus); | |
| 23 | @Update("update fd_repertory_nexus set sdepartNo=#{sdepartNo} where ckNo=#{ckNo} and ywdyNo=#{ywdyNo}") | |
| 24 | public int updateRepertoryNexus(FdRepertoryNexus renexus); | |
| 25 | ||
| 26 | @Delete("delete from fd_repertory_nexus where sdepartNo=#{sdepartNo} and ckNo=#{ckNo} and ywdyNo=#{ywdyNo} ") | |
| 27 | public int delRepertoryNexus(FdRepertoryNexus renexus); | |
| 28 | ||
| 29 | @Delete("delete from fd_repertory_nexus where sdepartNo=#{sdepartNo} ") | |
| 30 | public int delRepertoryNexusBySdepartNo(String sdepartNo); | |
| 31 | ||
| 32 | ||
| 33 | @Select("select * from fd_repertory_nexus where sdepartNo=#{sdepartNo} ") | |
| 34 | public List<FdRepertoryNexus> getBySdepartNo(String sdepartNo); | |
| 35 | ||
| ffffbd | 36 | @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 ") |
| 58d006 | 37 | public List<Map<String, Object>> getAllCk(); |
| A | 38 | |
| 39 | ||
| 40 | ||
| 41 | ||
| 42 | ||
| 43 | ||
| 44 | ||
| 45 | ||
| 46 | } | |
