| 提交 | 用户 | 时间 | ||
| 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.Param; | |
| 8 | import org.apache.ibatis.annotations.Select; | |
| 9 | import org.apache.ibatis.annotations.Update; | |
| 10 | ||
| 11 | import com.mandi.fendan.persist.Fd_Company_Vehicle; | |
| 12 | ||
| 13 | public interface Fd_ComVehicleMapper { | |
| 14 | ||
| 15 | @Select("select * from fd_company_vehicle where companyNo=#{companyNo} and vehicleId=#{vehicleId} and sdepartNo=#{sdepartNo} ") | |
| 16 | public Fd_Company_Vehicle getbyIDs(@Param("vehicleId") String vehicleId,@Param("companyNo")String companyNo,@Param("sdepartNo")String sdepartNo); | |
| 17 | ||
| 18 | @Insert("insert into fd_company_vehicle (companyNo,vehicleId,sdepartNo) values (#{companyNo},#{vehicleId},#{sdepartNo}) ") | |
| 19 | public int insertIDs(Fd_Company_Vehicle fdcv); | |
| 20 | ||
| 21 | @Delete("delete from fd_company_vehicle where companyNo=#{companyNo} and vehicleId=#{vehicleId} and sdepartNo=#{sdepartNo} ") | |
| 22 | public int del(@Param("vehicleId")String vehicleId,@Param("companyNo")String companyNo,@Param("sdepartNo")String sdepartNo); | |
| 23 | @Delete("delete from fd_company_vehicle where vehicleId=#{vehicleId} and sdepartNo=#{sdepartNo} ") | |
| 24 | public int delbyID(@Param("vehicleId")String vehicleId,@Param("sdepartNo")String sdepartNo); | |
| 25 | @Delete("delete from fd_company_vehicle where companyNo!=#{companyNo} and vehicleId=#{vehicleId} and sdepartNo=#{sdepartNo} ") | |
| 26 | public int delIDandNoC(@Param("vehicleId")String vehicleId,@Param("companyNo")String companyNo,@Param("sdepartNo")String sdepartNo); | |
| 27 | ||
| 28 | // @Update("update fd_company_vehicle set vehicleId=#{nvehicleId} where vehicleId=#{ovehicleId}") | |
| 29 | // public int changeVehicle(@Param("nvehicleId")String nvehicleId,@Param("ovehicleId")String ovehicleId); | |
| 30 | ||
| 31 | // @Select("select * from fd_company_vehicle where vehicleId=#{vehicleId} ") | |
| 32 | // public List<Fd_Company_Vehicle> getbyVID(@Param("vehicleId") String vehicleId); | |
| 33 | ||
| 34 | // @Select("select a.vehicleId from fd_company_vehicle a LEFT JOIN fd_vehicle_xstd b on a.vehicleId=b.vehicleId where a.companyNo=#{companyNo} and b.xstdNo=#{xstdNo} GROUP BY a.vehicleId ") | |
| 35 | // public List<String> getbyVCNO(@Param("companyNo") String companyNo,@Param("xstdNo") String xstdNo); | |
| 36 | ||
| 37 | ||
| 38 | } | |
