| 提交 | 用户 | 时间 | ||
| 58d006 | 1 | package com.mandi.fendan.mapper; |
| A | 2 | |
| 3 | import java.util.List; | |
| 4 | ||
| 5 | import org.apache.ibatis.annotations.Delete; | |
| 6 | import org.apache.ibatis.annotations.Insert; | |
| 7 | import org.apache.ibatis.annotations.Select; | |
| 8 | import org.apache.ibatis.annotations.Update; | |
| 9 | ||
| 10 | import com.mandi.fendan.persist.ErrSheet; | |
| 11 | ||
| 12 | public interface fd_errsheetMapper { | |
| 13 | ||
| 14 | @Insert("insert into fd_errsheet (vehicleId,bsNo,ZZ,errmsg,lasttime,fsnum)" | |
| 15 | + " values (#{vehicleId},#{bsNo},#{ZZ},#{errmsg},GETDATE(),1)") | |
| 16 | public int insert(ErrSheet es); | |
| 17 | @Delete("delete from fd_errsheet where id=#{id}") | |
| 18 | public int del(long id); | |
| 19 | @Delete("delete from fd_errsheet where bsNo=#{bsNo}") | |
| 20 | public int delBybsNo(String bsNo); | |
| 21 | ||
| 22 | @Update("update fd_errsheet set errmsg=#{errmsg},lasttime=getdate(),fsnum=fsnum+1 where id=#{id} ") | |
| 23 | public int udpateErr(ErrSheet es); | |
| 24 | ||
| 25 | @Select("select * from fd_errsheet ") | |
| 26 | public List<ErrSheet> getAll(); | |
| 27 | ||
| 28 | } | |
