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