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.ErrSheet;

public interface fd_errsheetMapper {
	
	@Insert("insert into fd_errsheet (vehicleId,bsNo,ZZ,errmsg,lasttime,fsnum)"
			+ " values (#{vehicleId},#{bsNo},#{ZZ},#{errmsg},GETDATE(),1)")
	public int insert(ErrSheet es);
	@Delete("delete from fd_errsheet where id=#{id}")
	public int del(long id);
	@Delete("delete from fd_errsheet where bsNo=#{bsNo}")
	public int delBybsNo(String bsNo);
	
	@Update("update fd_errsheet set errmsg=#{errmsg},lasttime=getdate(),fsnum=fsnum+1  where id=#{id} ")
	public int udpateErr(ErrSheet es);
	
	@Select("select * from fd_errsheet ")
	public List<ErrSheet> getAll();
	
}