update

whycrzg

2021-02-23 351b9a53cb9ecebdf8f79db0117f540d9c42c2a4

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
package com.fgkj.mapper.impl;
 
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{
 
    public boolean add(Object obj);
 
     //2.1 电池维护记录查询(编辑记录)<故障类型和排除方法对应问题？>
    public boolean update(Object obj);
 
    //2.1 电池维护记录查询（删除记录）
    @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(Batt_Maint_Dealarm obj) ;
 
 
    //1.1,1.2根据battgroupid查时间
    public List serchByInfo(Object obj);
 
    //3.2 电池故障处理统计查询
    public List statistical(Object obj);
 
    //0.3查询所有的维护记录
    public List<Batt_Maint_Dealarm> search() ;
 
    //0.4查询所有故障的电池组
    @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<Batt_maint_inf> searchByStationName(Batt_Maint_Dealarm obj) ;
    
    //根据电池组id查询电池的维护记录
    @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 {
        
        Batt_maint_infImpl bimpl=new Batt_maint_infImpl();
        BattInfImpl biml =new BattInfImpl();
        BattInf binf = new BattInf();
        
         
        binf.setStationName("");
        binf.setStationName1("一枢纽");
        //binf.setBattGroupName("");
        binf.setBattGroupId(0);
        binf.setBattGroupName1("");
        binf.setBattProducer("光宇");
        binf.setMonCapStd(0f);
        binf.setMonVolStd(0f);
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        Date date1 = sdf.parse("2000-01-01");
        Date date2 = sdf.parse("2016-07-14");
        binf.setBattProductDate(ActionUtil.getSimpDate(date1));
        binf.setBattProductDate1(ActionUtil.getSimpDate(date2));
        binf.setBattInUseDate(ActionUtil.getSimpDate(date1));
        binf.setBattInUseDate1(ActionUtil.getSimpDate(date2));
 
 
        Batt_maint_inf mainf = new Batt_maint_inf();
        mainf.setRemark("100");
        mainf.setMaint_done_time(ActionUtil.getSimpDate(date1));
        mainf.setMaint_done_time1(ActionUtil.getSimpDate(date2));
 
        Batttestdata_inf tdata = new Batttestdata_inf();
        tdata.setTest_type(0);
        tdata.setTest_starttype(0);
        tdata.setRecord_time(ActionUtil.getSimpDate(date1));
        tdata.setRecord_time1(ActionUtil.getSimpDate(date2));
        
        User_inf uinf=new User_inf();
        uinf.setuName("0");
        
        Page p=new Page();
        p.setPageCurr(1);
        p.setPageSize(1);
        
        Batt_Maint_Dealarm bmd = new Batt_Maint_Dealarm();
        bmd.setBinf(binf);
        bmd.setMainf(mainf);
        bmd.setTdata(tdata);
        bmd.setPage(p);
        bmd.setUinf(uinf);
        
    }*/
 
 
}