package com.mandi.fendan.mapper;

import com.mandi.fendan.persist.FdVehicleRemark;
import org.apache.ibatis.annotations.*;

public interface FdVehicleRemarkMapper {
    @Update("update FdVehicleRemark set remark=#{remark},vehicle=#{vehicle}  where businessNo =#{businessNO} ")
    int update(FdVehicleRemark FdVehicleRemark);
    @Insert("insert into FdVehicleRemark(businessNO,vehicle,remark) values(#{businessNO},#{vehicle},#{remark})")
    FdVehicleRemark insert(FdVehicleRemark FdVehicleRemark);
    @Select("select top 1 *from FdVehicleRemark where businessNo=#{businessNO} ")
    FdVehicleRemark selectByBusinessNo(String businessNO);

    @Delete("delete from FdVehicleRemark where businessNo=#{businessNo}")
    int deleteByBusinessNo(@Param("businessNo") String businessNo);
}