package com.mandi.fendan.mapper;
|
|
import java.util.List;
|
import java.util.Map;
|
|
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.Fd_Vehicle;
|
|
|
public interface Fd_VehicleMapper{
|
@Select("select a.* from fd_vehicle a where a.id=#{id}")
|
public Fd_Vehicle get(String id);
|
@Delete("delete from fd_vehicle where id=#{id}")
|
public int del(String id);
|
@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}")
|
public int update(Fd_Vehicle fd_vehicle);
|
@Insert("insert into fd_vehicle(id,companyNo,driver,loadweight,note,phone,state,"
|
+ "vehicleId,vehicleweight,type,status,feature,IDNum) "
|
+ "values (#{id},#{companyNo},#{driver},#{loadweight},#{note},#{phone},#{state},upper(#{vehicleId}),"
|
+ "#{vehicleweight},#{type},#{status},#{feature},#{IDNum})")
|
public int insert(Fd_Vehicle fd_vehicle);
|
@Select("select a.* from fd_vehicle a where a.vehicleId=#{vehicleId}")
|
public Fd_Vehicle getByVehicleId(String vehicleId);
|
@Select("select top 1 a.* from fd_vehicle a where a.companyNo=#{companyNo} ")
|
public Fd_Vehicle selectbyCompanyNo(String companyNo);
|
@Delete("delete from fd_vehicle where vehicleId=#{vehicleId}")
|
public int delByVehicleId(String vehicleId);
|
|
public List<Map<String, Object>> getList1(Map<String, Object> mp);
|
public List<Map<String, Object>> getList2(Map<String, Object> mp);
|
public int getPages(Map<String, Object> mp);
|
|
/**
|
* 公司添加的车辆
|
* @param mp
|
* @return
|
*/
|
public List<Map<String, Object>> getCompanyVehicle(Map<String, Object> mp);
|
}
|
