| 提交 | 用户 | 时间 | ||
| 58d006 | 1 | package com.mandi.fendan.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 | ||
| 11 | import com.mandi.basicconfig.persist.Ncfhdq; | |
| 12 | import com.mandi.fendan.persist.Fd_Company; | |
| 13 | import com.mandi.fendan.persist.Fd_wlgs_fhdq; | |
| 14 | ||
| 15 | ||
| 16 | ||
| 17 | /** | |
| 18 | * 发货地区 | |
| 19 | * | |
| 20 | */ | |
| 21 | public interface Fd_fhdqMapper { | |
| 22 | ||
| 23 | //分页 | |
| 24 | public List<Map<String, Object>> getlist(Map<String, Object> mp); | |
| 25 | public int count(Map<String, Object> mp); | |
| 26 | ||
| 27 | @Select("select * from fd_wlgs_fhdq where fhdqNo=#{fhdqNo}") | |
| 28 | public List<Fd_wlgs_fhdq> getbydqNo(String fhdqNo); | |
| 29 | @Select("select b.* from fd_wlgs_fhdq a left join fd_company b on a.wlgsNo=b.companyNo where a.fhdqNo=#{fhdqNo} and a.ywdyNo=#{ywdyNo} ") | |
| 30 | public List<Fd_Company> getCbyNo(@Param("fhdqNo")String fhdqNo,@Param("ywdyNo") String ywdyNo); | |
| 31 | @Select("select b.* from fd_wlgs_fhdq a left join fd_company b on a.wlgsNo=b.companyNo where a.fhdqNo=#{fhdqNo} and a.ywdyNo=#{ywddNo} " | |
| 32 | + "and EXISTS (SELECT 1 from fd_company_ywdy c where b.companyNo=c.companyNo and c.ywdyNo=#{ywdyNo} ) ") | |
| 33 | public List<Fd_Company> getCbyNoandsNo(@Param("fhdqNo") String fhdqNo,@Param("ywdyNo") String ywdyNo,@Param("ywddNo") String ywddNo); | |
| 34 | ||
| 35 | ||
| 36 | @Select("SELECT * from nc_dq where code=#{code} ") | |
| 37 | public Ncfhdq getbyCode(String code); | |
| 38 | @Select("select * from nc_dq where code like #{fhdqNo}+'%' ") | |
| 39 | public List<Ncfhdq> getLikebydqNo(String fhdqNo); | |
| 40 | ||
| 41 | @Delete("delete from fd_wlgs_fhdq where fhdqNo=#{fhdqNo} and ywdyNo=#{ywdyNo} ") | |
| 42 | public int delbyCode(@Param("fhdqNo") String fhdqNo,@Param("ywdyNo")String ywdyNo); | |
| 43 | @Delete("delete from fd_wlgs_fhdq where wlgsNo=#{wlgsNo} ") | |
| 44 | public int delbywlgsCode(String wlsgNo); | |
| 45 | @Delete("delete from fd_wlgs_fhdq where wlsgNo=#{wlsgNo} and fhdqNo=#{fhdqNo} ") | |
| 46 | public int delbyCodes(@Param("wlsgNo")String wlsgNo,@Param("fhdqNo")String fhdqNo); | |
| 47 | ||
| 48 | @Insert("insert into fd_wlgs_fhdq (wlgsNo,fhdqNo,ywdyNo) values (#{wlgsNo},#{fhdqNo},#{ywdyNo}) ") | |
| 49 | public int insertWlsg_fhdq(Fd_wlgs_fhdq wldq); | |
| 50 | ||
| 51 | @Select("select * from fd_wlgs_fhdq where wlgsNo=#{wlgsNo} and fhdqNo=#{fhdqNo} and ywdyNo=#{ywdyNo} ") | |
| 52 | public Fd_wlgs_fhdq getbyNos(@Param("wlgsNo") String wlgsNo,@Param("fhdqNo") String fhdqNo,@Param("ywdyNo") String ywdyNo); | |
| 53 | ||
| 54 | // 判断提单权限 | |
| 55 | @Select("select * from fd_wlgs_fhdq where wlgsNo=#{wlgsNo} and fhdqNo=#{fhdqNo} and ywdyNo=#{ywdyNo} ") | |
| 56 | public Fd_wlgs_fhdq getbyNos1(@Param("wlgsNo") String wlgsNo,@Param("fhdqNo") String fhdqNo,@Param("ywdyNo") String ywdyNo); | |
| 57 | ||
| 58 | @Select("select name,companyNo from company where companyNo=#{code}") | |
| 59 | public Map<String, Object> getKH(String code); | |
| 60 | ||
| 61 | } | |
