package com.mandi.fendan.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import com.mandi.fendan.persist.Fd_Bsheetitem;





public interface Fd_BsheetitemMapper {
	@Select("select a.* from fd_sheetitem a where a.id=#{id}")
	public Fd_Bsheetitem getbyId(String id);
	@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 ")
	public Fd_Bsheetitem getbyLsandFl(@Param("tdmx_tdls")String tdmx_tdls,@Param("tdmx_tdfl")String tdmx_tdfl,@Param("tdmx_tdbh") String tdmx_tdbh);
	@Select("select top 1 *  from fd_sheetitem where barcode=#{barcode} and tdmx_fdywbh=#{tdmx_fdywbh}  order by ctime desc ")
	public Fd_Bsheetitem getbyNoandCode(@Param("barcode")String barcode,@Param("tdmx_fdywbh")String tdmx_fdywbh);
	@Select("select top 1 *  from fd_sheetitem where tdmx_pch=#{tdmx_pch} and tdmx_fdywbh=#{tdmx_fdywbh}  order by ctime desc ")
	public Fd_Bsheetitem getbypchandNo(@Param("tdmx_fdywbh")String tdmx_fdywbh,@Param("tdmx_pch")String pch);
	
	@Delete("delete  from fd_sheetitem where id=#{id}")
	public int delbyId(String id);
	@Delete("delete  from fd_sheetitem where tdmx_tdls=#{tdmx_tdls} and tdmx_tdfl=#{tdmx_tdfl} and tdmx_tdbh=#{tdmx_tdbh} ")
	public int delbyLsandFl(@Param("tdmx_tdls")String tdmx_tdls,@Param("tdmx_tdfl")String tdmx_tdfl,@Param("tdmx_tdbh") String tdmx_tdbh);
	@Delete("delete  from fd_sheetitem where tdmx_tdbh=#{tdmx_tdbh}")
	public int delbyTDNo(String tdmx_tdbh);
	@Delete("delete  from fd_sheetitem where tdmx_tdbh=#{tdmx_tdbh} and tdmx_cph=#{tdmx_cph} and tdmx_fdywbh=#{tdmx_fdywbh}")
	public int delbyTDNoandVhId(@Param("tdmx_tdbh") String tdmx_tdbh,@Param("tdmx_cph") String tdmx_cph,@Param("tdmx_fdywbh") String tdmx_fdywbh);
	@Delete("delete  from fd_sheetitem where tdmx_fdywbh=#{tdmx_fdywbh} ")
	public int delbyBsNo(@Param("tdmx_fdywbh") String tdmx_fdywbh);
	
	@Select("select * from fd_sheetitem where tdmx_fdywbh=#{tdmx_fdywbh}")
	public List<Fd_Bsheetitem> getlistbyNo(String tdmx_fdywbh);
	
	@Update("update fd_sheetitem set companyName=#{companyName},companyNo=#{companyNo},"
			+ "createName=#{createName},createid=#{createid},ctime=#{ctime},barcode=#{barcode},tdmx_wlbh=#{tdmx_wlbh},"
			+ "tdmx_wlmc=#{tdmx_wlmc},tdmx_tdfl=#{tdmx_tdfl},tdmx_tdls=#{tdmx_tdls},tdmx_hjzt=#{tdmx_hjzt},tdmx_dwmc=#{tdmx_dwmc},tdmx_pch=#{tdmx_pch},"
			+ "tdmx_bhse=#{tdmx_bhse},tdmx_mz=#{tdmx_mz},tdmx_pz=#{tdmx_pz},"
			+ "tdmx_jz=#{tdmx_jz},tdmx_shdw=#{tdmx_shdw},tdmx_fhdw=#{tdmx_fhdw},tdmx_tdlx=#{tdmx_tdlx},"
			+ "tdmx_sl=#{tdmx_sl},tdmx_ggxh=#{tdmx_ggxh},tdmx_hwbh=#{tdmx_hwbh},"
			+ "tdmx_zpbz=#{tdmx_zpbz},tdmx_sfzc=#{tdmx_sfzc},tdmx_fdbz=#{tdmx_fdbz},tdmx_cph=#{tdmx_cph},"
			+ "tdmx_zccph=#{tdmx_zccph},tdmx_fdywbh=#{tdmx_fdywbh},tdmx_tdbh=#{tdmx_tdbh} where id=#{id}")
	public int update(Fd_Bsheetitem fd_bsheetitem);
	
	
	@Insert("insert into fd_sheetitem("
			+ "id,companyName,companyNo,createName,createid,ctime,barcode,tdmx_wlbh,"
			+ "tdmx_wlmc,tdmx_tdfl,tdmx_tdls,tdmx_hjzt,tdmx_dwmc,tdmx_pch,"
			+ "tdmx_bhse,tdmx_mz,tdmx_pz,tdmx_jz,tdmx_shdw,tdmx_fhdw,tdmx_tdlx,"
			+ "tdmx_sl,tdmx_ggxh,tdmx_hwbh,tdmx_zpbz,tdmx_sfzc,tdmx_fdbz,tdmx_cph,"
			+ "tdmx_zccph,tdmx_fdywbh,tdmx_tdbh) values "
			+ "(#{id},#{companyName},#{companyNo},#{createName},#{createid},#{ctime},#{barcode},#{tdmx_wlbh},"
			+ "#{tdmx_wlmc},#{tdmx_tdfl},#{tdmx_tdls},#{tdmx_hjzt},#{tdmx_dwmc},#{tdmx_pch},"
			+ "#{tdmx_bhse},#{tdmx_mz},#{tdmx_pz},#{tdmx_jz},#{tdmx_shdw},#{tdmx_fhdw},#{tdmx_tdlx},"
			+ "#{tdmx_sl},#{tdmx_ggxh},#{tdmx_hwbh},#{tdmx_zpbz},#{tdmx_sfzc},#{tdmx_fdbz},#{tdmx_cph},"
			+ "#{tdmx_zccph},#{tdmx_fdywbh},#{tdmx_tdbh})")
	public int insert(Fd_Bsheetitem fd_bsheetitem);
}