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);


}