查看 | 历史 | 提交 | 提交对比
hjg
2023-11-18 bb48edb3d9faaaeab0088151c86fc24137acdb08
提交 | 用户 | 时间
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;
12 import com.mandi.fendan.persist.Vehicle_XSTD;
13
14 public interface VehicleXSTDMapper {
15     
16     @Select("select * from fd_vehicle_xstd where vehicleId=#{vehicleId} and xstdNo=#{xstdNo} and companyNo=#{companyNo} ")
17     public Vehicle_XSTD getbyIDs(@Param("vehicleId") String vehicleId,@Param("xstdNo") String xstdNo,@Param("companyNo") String companyNo);
18     
19     @Select("select * from fd_vehicle_xstd where vehicleId=#{vehicleId} and xstdNo=#{xstdNo} ")
20     public List<Vehicle_XSTD> getbyIDsnocomNo(@Param("vehicleId") String vehicleId,@Param("xstdNo") String xstdNo);
21     
22     @Delete("delete from fd_vehicle_xstd where vehicleId=#{vehicleId} and xstdNo=#{xstdNo} and companyNo=#{companyNo} ")
23     public int delbyIDs(@Param("vehicleId") String vehicleId,@Param("xstdNo") String xstdNo,@Param("companyNo") String companyNo);
24     
25     @Delete("delete from fd_vehicle_xstd where xstdNo=#{xstdNo} and companyNo=#{companyNo} ")
26     public int delbyIDandcomNo(@Param("xstdNo") String xstdNo,@Param("companyNo") String companyNo);
27     
28     @Delete("delete from fd_vehicle_xstd where vehicleId=#{vehicleId} and bsNo=#{bsNo}")
29     public int delbyVehicleId(@Param("vehicleId") String vehicleId,@Param("bsNo") String bsNo);
30     
31 //    @Delete("delete from fd_vehicle_xstd where vehicleId=#{vehicleId} ")
32 //    public int delbyVehicleID(@Param("vehicleId") String vehicleId);
33     
34     @Insert("insert into fd_vehicle_xstd (vehicleId,xstdNo,fd_num,fd_weight,bsNo,companyNo) "
35             + "values (upper(#{vehicleId}),#{xstdNo},#{fd_num},#{fd_weight},#{bsNo},#{companyNo}) ")
36     public int insert(Vehicle_XSTD vxs);
37     @Update("update fd_vehicle_xstd set fd_num=#{fd_num},fd_weight=#{fd_weight},bsNo=#{bsNo}"
38             + " where vehicleId=#{vehicleId} and xstdNo=#{xstdNo}  and companyNo=#{companyNo} ")
39     public int updatewithIDs(Vehicle_XSTD vxs);
40 //    @Update("update fd_vehicle_xstd set vehicleId=#{nvehicleId} where vehicleId=#{vehicleId}")
41 //    public int changeVehicle(@Param("vehicleId")String vehicleId,@Param("nvehicleId")String nvehicleId);
42     
43     @Select("select * from fd_vehicle_xstd where vehicleId=#{vehicleId} ")
44     public List<Vehicle_XSTD> getlistbyVehicleId(String vehicleId);
45     
46     @Select("select * from fd_vehicle_xstd where companyNo=#{companyNo} ")
47     public List<Vehicle_XSTD> getlistbycomNo(String companyNo);
48     @Select("select * from fd_vehicle_xstd ")
49     public List<Vehicle_XSTD> getlistAll();
50     
51 //    @Select("select companyNo from fd_vehicle_xstd where vehicleId=#{vehicleId} group by companyNo ")
52 //    public List<String> getlistbyVehicleIdGp(String vehicleId); 
53     
54     @Select("select * from fd_vehicle_xstd where vehicleId=#{vehicleId} and bsNo=#{bsNo} ")
55     public List<Vehicle_XSTD> getlistbyVehicleIdandbsNoGp(@Param("vehicleId")String vehicleId,@Param("bsNo") String bsNo); 
56     
57     @Select("select * from fd_vehicle_xstd where vehicleId=#{vehicleId} and companyNo=#{companyNo} ")
58     public List<Vehicle_XSTD> getlistbyVehandcompanyNo(@Param("vehicleId")String vehicleId,@Param("companyNo")String companyNo);
59     
60     @Select("select * from fd_vehicle_xstd where xstdNo=#{xstdNo} ")
61     public List<Vehicle_XSTD> getlistbytdNo(String xstdNo);
62     
63     @Select("select * from fd_vehicle_xstd where xstdNo=#{xstdNo} and companyNo=#{companyNo} ")
64     public List<Vehicle_XSTD> getbyxstdNoandcmNo(@Param("xstdNo")String xstdNo,@Param("companyNo")String companyNo);
65     
66     
67     /**
68      * 可以修改
69      * @param xstdNo
70      * @param status
71      * @return
72      */
73 //    @Select("select a.* from fd_vehicle_xstd a left join fd_vehicle b on  a.vehicleId=b.vehicleId where a.xstdNo=#{xstdNo} and b.status=#{status} ")
74 //    public List<Vehicle_XSTD> getkxglist(@Param("xstdNo")String xstdNo,@Param("status")VehicleStatus status);
75     
76     @Select("select b.companyNo,max(b.name) name from fd_vehicle_xstd a left join fd_company b on a.companyNo=b.companyNo where a.vehicleId=#{vehicleId} GROUP BY b.companyNo ")
77     public List<Fd_Company> getCompany(@Param("vehicleId") String vehicleId,@Param("bsNo") String bsNo);
78     @Select("select b.companyNo,max(b.name) name ,a.bsNo note from fd_vehicle_xstd a left join fd_company b on a.companyNo=b.companyNo GROUP BY b.companyNo,a.bsNo ")
79     public List<Fd_Company> getAllCom();
80     
81     @Select("select top 1 a.* from fd_vehicle_xstd  a  where a.vehicleId=#{vehicleId} and a.xstdNo=#{xstdNo} ")
82     public Vehicle_XSTD getVhicleByIDs(@Param("vehicleId") String vehicleId,@Param("xstdNo") String xstdNo);
83     
84 }