| 提交 | 用户 | 时间 | ||
| 58d006 | 1 | package com.mandi.basicconfig.mapper; |
| A | 2 | |
| 3 | import org.apache.ibatis.annotations.Select; | |
| 4 | ||
| 5 | import com.mandi.basicconfig.persist.Ncck; | |
| 6 | import com.mandi.basicconfig.persist.Ncdepart; | |
| 7 | import com.mandi.basicconfig.persist.Nchj; | |
| 8 | import com.mandi.basicconfig.persist.Nchw; | |
| 9 | import com.mandi.basicconfig.persist.Nccrklx; | |
| 10 | import com.mandi.basicconfig.persist.Nckh; | |
| 11 | import com.mandi.basicconfig.persist.Ncwl; | |
| 12 | import com.mandi.basicconfig.persist.Ncworker; | |
| 13 | import com.mandi.basicconfig.persist.Ncbzlx; | |
| 14 | import com.mandi.basicconfig.persist.Ncywdy; | |
| 15 | import com.mandi.basicconfig.persist.Nczt; | |
| 16 | ||
| 17 | public interface NczsjMapper { | |
| 18 | ||
| 19 | @Select("select name,depotNo as code from repertory where pkid=#{pkid} ") | |
| 20 | public Ncck getNcckbyPkid(String pkid); | |
| 21 | ||
| 22 | @Select("select top 1 a.code code,a.name name,c.bianhao yktcode,c.name yktname from nc_depart a LEFT JOIN nc_depart_nexus b on a.pkid=b.pkid LEFT JOIN depart c on b.departNo=c.bianhao where a.code=#{code} ") | |
| 23 | public Ncdepart getNcdepartbyCode(String code); | |
| 24 | ||
| 25 | @Select("SELECT top 1 code,name from nc_hj where code=#{code} ") | |
| 26 | public Nchj getNchjbyCode(String code); | |
| 27 | ||
| 28 | @Select("SELECT code,name from nc_hw where pkid=#{pkid} ") | |
| 29 | public Nchw getNchwbyPkid(String pkid); | |
| 30 | ||
| 31 | @Select("SELECT top 1 companyNo code,name from company where companyNo=#{code}") | |
| 32 | public Nckh getNckhbyCode(String code); | |
| 33 | ||
| 34 | @Select("SELECT top 1 materielNo code,name from materiel where materielNo=#{code} ") | |
| 35 | public Ncwl getNcwlbyCode(String code); | |
| 36 | ||
| 37 | @Select("SELECT top 1 gonghao yktcode,name,nc_code code from enterworker where nc_code=#{code} ") | |
| 38 | public Ncworker getNcworkerbyCode(String code); | |
| 39 | ||
| 40 | @Select("SELECT top 1 code,name from nc_bzlx where code=#{code} ") | |
| 41 | public Ncbzlx getNczpbzbyCode(String code); | |
| 42 | ||
| 43 | @Select("SELECT top 1 code,name from nc_zt where code=#{code} ") | |
| 44 | public Nczt getNcztbyCode(String code); | |
| 45 | ||
| 46 | @Select("SELECT top 1 a.code,a.name,c.bianhao yktCode,c.name yktName from nc_ywdy a LEFT JOIN nc_ywdy_nexus b on a.pkid=b.pkid LEFT JOIN depart c on b.sdepartNo=c.bianhao where a.code=#{code} ") | |
| 47 | public Ncywdy getNcywdybyCode(String code); | |
| 48 | ||
| 49 | @Select("select top 1 * from nc_crklx where code=#{code} ") | |
| 50 | public Nccrklx getNcjylxbycode(String code); | |
| 51 | ||
| 52 | } | |
