update battMaintInf# etc

whycrzg

2021-02-20 1c6f32cc6674dea616f220920f06b455153ded56

 src/main/java/com/fgkj/mapper/impl/Batt_maint_infMapper.java

@@ -2,6 +2,10 @@

import java.util.List;

import com.fgkj.dto.Batt_Maint_Dealarm;
import com.fgkj.dto.Batt_maint_inf;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

public interface Batt_maint_infMapper{
@@ -12,10 +16,11 @@
   public boolean update(Object obj);

   //2.1 电池维护记录查询（删除记录）
   public boolean del(Object obj);
   @Delete("delete from db_battinf.tb_batt_maint_inf where num=#{num}")
   public int del(Batt_maint_inf obj);

   // 3.1 根据battgroupid查维护数据信息
   public List serchByCondition(Object obj) ;
   public List serchByCondition(Batt_Maint_Dealarm obj) ;


   //1.1,1.2根据battgroupid查时间
@@ -25,16 +30,25 @@
   public List statistical(Object obj);

   //0.3查询所有的维护记录
   public List search() ;
   public List<Batt_Maint_Dealarm> search() ;

   //0.4查询所有故障的电池组
   public List searchAll() ;
   @Select("select distinct(battgroupid),usr_id,fault_type_id,fault_level,fault_caption,record_time" +
         ",maint_time_limit,maint_type_id,maint_result,maint_done_time,maint_close" +
         ",master_id,master_audit,copy_uids,appoint_uid " +
         "from db_battinf.tb_batt_maint_inf " +
         "order by maint_done_time desc ")
   public List<Batt_maint_inf> searchAll() ;

   //0.4/0.8根据城市查询所有故障的电池组(故障率和维护率)
   public List searchByStationName(Object obj) ;
   public List<Batt_maint_inf> searchByStationName(Batt_Maint_Dealarm obj) ;
   
   //根据电池组id查询电池的维护记录
   public List searchByBattgroupId(Object obj) ;
   @Select("select num,BattGroupId,usr_id,fault_type_id,fault_type,fault_level,fault_caption," +
         "fault_time,record_uid,record_time,maint_time_limit,maint_type_id,maint_type,maint_result," +
         "maint_done,maint_done_time,maint_close,master_id,master_audit,copy_uids,appoint_uid,master_check,remark " +
         "from db_battinf.tb_batt_maint_inf where BattGroupId=#{battGroupId}")
   public List<Batt_maint_inf> searchByBattgroupId(Batt_maint_inf obj) ;

   /*public static void main(String[] args) throws ParseException {