| 提交 | 用户 | 时间 | ||
| 58d006 | 1 | package com.mandi.fendan.mapper; |
| A | 2 | |
| 3 | import java.util.List; | |
| 4 | import java.util.Map; | |
| 5 | ||
| 6 | import org.apache.ibatis.annotations.Delete; | |
| 7 | import org.apache.ibatis.annotations.Insert; | |
| 8 | import org.apache.ibatis.annotations.Select; | |
| 9 | import org.apache.ibatis.annotations.Update; | |
| 10 | ||
| 11 | import com.mandi.fendan.persist.Fd_Vehicle; | |
| 12 | ||
| 13 | ||
| 14 | public interface Fd_VehicleMapper{ | |
| 15 | @Select("select a.* from fd_vehicle a where a.id=#{id}") | |
| 16 | public Fd_Vehicle get(String id); | |
| 17 | @Delete("delete from fd_vehicle where id=#{id}") | |
| 18 | public int del(String id); | |
| 19 | @Update("update fd_vehicle set companyNo=#{companyNo},driver=#{driver},loadweight=#{loadweight},note=#{note},phone=#{phone},state=#{state},vehicleId=#{vehicleId},vehicleweight=#{vehicleweight},type=#{type},status=#{status},feature=#{feature},IDNum=#{IDNum} where id=#{id}") | |
| 20 | public int update(Fd_Vehicle fd_vehicle); | |
| 21 | @Insert("insert into fd_vehicle(id,companyNo,driver,loadweight,note,phone,state," | |
| 22 | + "vehicleId,vehicleweight,type,status,feature,IDNum) " | |
| 23 | + "values (#{id},#{companyNo},#{driver},#{loadweight},#{note},#{phone},#{state},upper(#{vehicleId})," | |
| 24 | + "#{vehicleweight},#{type},#{status},#{feature},#{IDNum})") | |
| 25 | public int insert(Fd_Vehicle fd_vehicle); | |
| 26 | @Select("select a.* from fd_vehicle a where a.vehicleId=#{vehicleId}") | |
| 27 | public Fd_Vehicle getByVehicleId(String vehicleId); | |
| 28 | @Select("select top 1 a.* from fd_vehicle a where a.companyNo=#{companyNo} ") | |
| 29 | public Fd_Vehicle selectbyCompanyNo(String companyNo); | |
| 30 | @Delete("delete from fd_vehicle where vehicleId=#{vehicleId}") | |
| 31 | public int delByVehicleId(String vehicleId); | |
| 32 | ||
| 33 | public List<Map<String, Object>> getList1(Map<String, Object> mp); | |
| 34 | public List<Map<String, Object>> getList2(Map<String, Object> mp); | |
| 35 | public int getPages(Map<String, Object> mp); | |
| 36 | ||
| 37 | /** | |
| 38 | * 公司添加的车辆 | |
| 39 | * @param mp | |
| 40 | * @return | |
| 41 | */ | |
| 42 | public List<Map<String, Object>> getCompanyVehicle(Map<String, Object> mp); | |
| 43 | } | |
