package com.mandi.fendan.mapper;
|
|
import java.util.List;
|
import java.util.Map;
|
|
|
import org.apache.ibatis.annotations.*;
|
|
import com.mandi.fendan.persist.Fd_XSTD;
|
import com.mandi.fendan.util.persist.WaitXSTD;
|
|
public interface Fd_XSTDMapper {
|
|
@Insert("insert into fd_xstd "
|
+ "(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,"
|
+ "td_bmbh,td_jylx,td_khbh,td_zdrmc,td_ywdybh,td_cqNo,committime) "
|
+ "values "
|
+ "(#{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,"
|
+ "#{td_bmbh},#{td_jylx},#{td_khbh},#{td_zdrmc},#{td_ywdybh},#{td_cqNo},#{committime})")
|
public int insert(Fd_XSTD xstd);
|
|
@Select("select * from fd_xstd where td_tdls=#{td_tdls} ")
|
public Fd_XSTD get(String td_tdls);
|
@Select("select * from fd_xstd where td_tdbh=#{tdbh} ")
|
public Fd_XSTD getbyTDBH(String tdbh);
|
|
@Delete("delete from fd_xstd where td_tdls=#{td_tdls}")
|
public int del(String td_tdls);
|
|
@Update("update fd_xstd set td_wfdsl=#{td_wfdsl},td_wfdzl=#{td_wfdzl} where td_tdls=#{td_tdls}")
|
public int updateFD(Fd_XSTD xstd);
|
|
@Update("update fd_xstd set td_zcwcbz=#{td_zcwcbz} where td_tdls=#{td_tdls}")
|
public int updateZCWC(Fd_XSTD xstd);
|
|
@Select("select * from fd_xstd where td_tdbh=#{td_tdbh} ")
|
public Fd_XSTD getbyttdbh(String td_tdbh);
|
|
|
public List<WaitXSTD> getList(Map<String, Object> mp);
|
public int countPage(Map<String, Object> mp);
|
|
public Map<String, Object> getGBXSTD(String tdbh);
|
|
@Select("select * from xstd_view where td_tdbh=#{tdbh}")
|
public WaitXSTD getWaitXSTD(String tdbh);
|
|
|
}
|
