| 提交 | 用户 | 时间 | ||
| 58d006 | 1 | package com.mandi.fendan.mapper; |
| A | 2 | |
| 3 | import java.util.List; | |
| 4 | import java.util.Map; | |
| 5 | ||
| 6 | ||
| 7 | import org.apache.ibatis.annotations.*; | |
| 8 | ||
| 9 | import com.mandi.fendan.persist.Fd_XSTD; | |
| 10 | import com.mandi.fendan.util.persist.WaitXSTD; | |
| 11 | ||
| 12 | public interface Fd_XSTDMapper { | |
| 13 | ||
| 14 | @Insert("insert into fd_xstd " | |
| 15 | + "(td_tdls,td_tdbh,td_djrq,td_bmmc,td_bz,td_zdr,td_shddbh,td_shsj,td_ztbz,td_fpbh,td_wfdsl,td_wfdzl,td_zcwcbz," | |
| 16 | + "td_bmbh,td_jylx,td_khbh,td_zdrmc,td_ywdybh,td_cqNo) " | |
| 17 | + "values " | |
| 18 | + "(#{td_tdls},#{td_tdbh},#{td_djrq},#{td_bmmc},#{td_bz},#{td_zdr},#{td_shddbh},#{td_shsj},#{td_ztbz},#{td_fpbh},#{td_wfdsl},#{td_wfdzl},0," | |
| 19 | + "#{td_bmbh},#{td_jylx},#{td_khbh},#{td_zdrmc},#{td_ywdybh},#{td_cqNo})") | |
| 20 | public int insert(Fd_XSTD xstd); | |
| 21 | ||
| 22 | @Select("select * from fd_xstd where td_tdls=#{td_tdls} ") | |
| 23 | public Fd_XSTD get(String td_tdls); | |
| 24 | @Select("select * from fd_xstd where td_tdbh=#{tdbh} ") | |
| 25 | public Fd_XSTD getbyTDBH(String tdbh); | |
| 26 | ||
| 27 | @Delete("delete from fd_xstd where td_tdls=#{td_tdls}") | |
| 28 | public int del(String td_tdls); | |
| 29 | ||
| 30 | @Update("update fd_xstd set td_wfdsl=#{td_wfdsl},td_wfdzl=#{td_wfdzl} where td_tdls=#{td_tdls}") | |
| 31 | public int updateFD(Fd_XSTD xstd); | |
| 32 | ||
| 33 | @Update("update fd_xstd set td_zcwcbz=#{td_zcwcbz} where td_tdls=#{td_tdls}") | |
| 34 | public int updateZCWC(Fd_XSTD xstd); | |
| 35 | ||
| 36 | @Select("select * from fd_xstd where td_tdbh=#{td_tdbh} ") | |
| 37 | public Fd_XSTD getbyttdbh(String td_tdbh); | |
| 38 | ||
| 39 | ||
| 40 | public List<WaitXSTD> getList(Map<String, Object> mp); | |
| 41 | public int countPage(Map<String, Object> mp); | |
| 42 | ||
| 43 | public Map<String, Object> getGBXSTD(String tdbh); | |
| 44 | ||
| 45 | @Select("select * from xstd_view where td_tdbh=#{tdbh}") | |
| 46 | public WaitXSTD getWaitXSTD(String tdbh); | |
| 47 | ||
| 48 | ||
| 49 | } | |
