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.Select;
import org.apache.ibatis.annotations.Update;

import com.mandi.fendan.persist.Fd_Gbxstdmx;


public interface Fd_GbxstdmxMapper {
	
	@Insert("insert into fd_gbxstdmx (id,tdNo,pch,tdfl) values (#{id},#{tdNo},#{pch},#{tdfl}) ")
	public int insert(Fd_Gbxstdmx xstdmx);
	@Update("update fd_gbxstdmx set tdNo=#{tdNo},pch=#{pch},tdfl=#{tdfl} where id=#{id}")
	public int update(Fd_Gbxstdmx xstdmx);
	@Delete("delete from fd_gbxstdmx where tdNo=#{tdNo}")
	public int del(String tdNo);
	@Delete("delete from fd_gbxstdmx where id=#{id}")
	public int delbyId(String id);
	@Select("select * from fd_gbxstdmx where id=#{id}")
	public Fd_Gbxstdmx get(String id);
	
	@Select("select * from fd_gbxstdmx where tdNo=#{tdNo}")
	public List<Fd_Gbxstdmx> getList(String tdNo);

}