| 提交 | 用户 | 时间 | ||
| 58d006 | 1 | package com.mandi.fendan.mapper; |
| A | 2 | |
| 3 | import java.util.List; | |
| 4 | ||
| 5 | import org.apache.ibatis.annotations.Delete; | |
| 6 | import org.apache.ibatis.annotations.Insert; | |
| 7 | import org.apache.ibatis.annotations.Param; | |
| 8 | import org.apache.ibatis.annotations.Select; | |
| 9 | import org.apache.ibatis.annotations.Update; | |
| 10 | ||
| 11 | import com.mandi.fendan.persist.Fd_Bsheetitem; | |
| 12 | ||
| 13 | ||
| 14 | ||
| 15 | ||
| 16 | ||
| 17 | public interface Fd_BsheetitemMapper { | |
| 18 | @Select("select a.* from fd_sheetitem a where a.id=#{id}") | |
| 19 | public Fd_Bsheetitem getbyId(String id); | |
| 20 | @Select("select top 1 * from fd_sheetitem where tdmx_tdls=#{tdmx_tdls} and tdmx_tdfl=#{tdmx_tdfl} and tdmx_tdbh=#{tdmx_tdbh} order by ctime desc ") | |
| 21 | public Fd_Bsheetitem getbyLsandFl(@Param("tdmx_tdls")String tdmx_tdls,@Param("tdmx_tdfl")String tdmx_tdfl,@Param("tdmx_tdbh") String tdmx_tdbh); | |
| 22 | @Select("select top 1 * from fd_sheetitem where barcode=#{barcode} and tdmx_fdywbh=#{tdmx_fdywbh} order by ctime desc ") | |
| 23 | public Fd_Bsheetitem getbyNoandCode(@Param("barcode")String barcode,@Param("tdmx_fdywbh")String tdmx_fdywbh); | |
| 24 | @Select("select top 1 * from fd_sheetitem where tdmx_pch=#{tdmx_pch} and tdmx_fdywbh=#{tdmx_fdywbh} order by ctime desc ") | |
| 25 | public Fd_Bsheetitem getbypchandNo(@Param("tdmx_fdywbh")String tdmx_fdywbh,@Param("tdmx_pch")String pch); | |
| 26 | ||
| 27 | @Delete("delete from fd_sheetitem where id=#{id}") | |
| 28 | public int delbyId(String id); | |
| 29 | @Delete("delete from fd_sheetitem where tdmx_tdls=#{tdmx_tdls} and tdmx_tdfl=#{tdmx_tdfl} and tdmx_tdbh=#{tdmx_tdbh} ") | |
| 30 | public int delbyLsandFl(@Param("tdmx_tdls")String tdmx_tdls,@Param("tdmx_tdfl")String tdmx_tdfl,@Param("tdmx_tdbh") String tdmx_tdbh); | |
| 31 | @Delete("delete from fd_sheetitem where tdmx_tdbh=#{tdmx_tdbh}") | |
| 32 | public int delbyTDNo(String tdmx_tdbh); | |
| 33 | @Delete("delete from fd_sheetitem where tdmx_tdbh=#{tdmx_tdbh} and tdmx_cph=#{tdmx_cph} and tdmx_fdywbh=#{tdmx_fdywbh}") | |
| 34 | public int delbyTDNoandVhId(@Param("tdmx_tdbh") String tdmx_tdbh,@Param("tdmx_cph") String tdmx_cph,@Param("tdmx_fdywbh") String tdmx_fdywbh); | |
| 35 | @Delete("delete from fd_sheetitem where tdmx_fdywbh=#{tdmx_fdywbh} ") | |
| 36 | public int delbyBsNo(@Param("tdmx_fdywbh") String tdmx_fdywbh); | |
| 37 | ||
| 38 | @Select("select * from fd_sheetitem where tdmx_fdywbh=#{tdmx_fdywbh}") | |
| 39 | public List<Fd_Bsheetitem> getlistbyNo(String tdmx_fdywbh); | |
| 40 | ||
| 41 | @Update("update fd_sheetitem set companyName=#{companyName},companyNo=#{companyNo}," | |
| 42 | + "createName=#{createName},createid=#{createid},ctime=#{ctime},barcode=#{barcode},tdmx_wlbh=#{tdmx_wlbh}," | |
| 43 | + "tdmx_wlmc=#{tdmx_wlmc},tdmx_tdfl=#{tdmx_tdfl},tdmx_tdls=#{tdmx_tdls},tdmx_hjzt=#{tdmx_hjzt},tdmx_dwmc=#{tdmx_dwmc},tdmx_pch=#{tdmx_pch}," | |
| 44 | + "tdmx_bhse=#{tdmx_bhse},tdmx_mz=#{tdmx_mz},tdmx_pz=#{tdmx_pz}," | |
| 45 | + "tdmx_jz=#{tdmx_jz},tdmx_shdw=#{tdmx_shdw},tdmx_fhdw=#{tdmx_fhdw},tdmx_tdlx=#{tdmx_tdlx}," | |
| 46 | + "tdmx_sl=#{tdmx_sl},tdmx_ggxh=#{tdmx_ggxh},tdmx_hwbh=#{tdmx_hwbh}," | |
| 47 | + "tdmx_zpbz=#{tdmx_zpbz},tdmx_sfzc=#{tdmx_sfzc},tdmx_fdbz=#{tdmx_fdbz},tdmx_cph=#{tdmx_cph}," | |
| 48 | + "tdmx_zccph=#{tdmx_zccph},tdmx_fdywbh=#{tdmx_fdywbh},tdmx_tdbh=#{tdmx_tdbh} where id=#{id}") | |
| 49 | public int update(Fd_Bsheetitem fd_bsheetitem); | |
| 50 | ||
| 51 | ||
| 52 | @Insert("insert into fd_sheetitem(" | |
| 53 | + "id,companyName,companyNo,createName,createid,ctime,barcode,tdmx_wlbh," | |
| 54 | + "tdmx_wlmc,tdmx_tdfl,tdmx_tdls,tdmx_hjzt,tdmx_dwmc,tdmx_pch," | |
| 55 | + "tdmx_bhse,tdmx_mz,tdmx_pz,tdmx_jz,tdmx_shdw,tdmx_fhdw,tdmx_tdlx," | |
| 56 | + "tdmx_sl,tdmx_ggxh,tdmx_hwbh,tdmx_zpbz,tdmx_sfzc,tdmx_fdbz,tdmx_cph," | |
| 57 | + "tdmx_zccph,tdmx_fdywbh,tdmx_tdbh) values " | |
| 58 | + "(#{id},#{companyName},#{companyNo},#{createName},#{createid},#{ctime},#{barcode},#{tdmx_wlbh}," | |
| 59 | + "#{tdmx_wlmc},#{tdmx_tdfl},#{tdmx_tdls},#{tdmx_hjzt},#{tdmx_dwmc},#{tdmx_pch}," | |
| 60 | + "#{tdmx_bhse},#{tdmx_mz},#{tdmx_pz},#{tdmx_jz},#{tdmx_shdw},#{tdmx_fhdw},#{tdmx_tdlx}," | |
| 61 | + "#{tdmx_sl},#{tdmx_ggxh},#{tdmx_hwbh},#{tdmx_zpbz},#{tdmx_sfzc},#{tdmx_fdbz},#{tdmx_cph}," | |
| 62 | + "#{tdmx_zccph},#{tdmx_fdywbh},#{tdmx_tdbh})") | |
| 63 | public int insert(Fd_Bsheetitem fd_bsheetitem); | |
| 64 | } | |
