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
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
package com.fgkj.services;
 
import com.fgkj.dto.Batt_discharge;
import com.fgkj.dto.ServiceModel;
import com.fgkj.dto.User_log;
import com.fgkj.mapper.UinfDaoFactory;
import com.fgkj.mapper.impl.Batt_dischargeMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.stereotype.Service;
import org.springframework.transaction.TransactionDefinition;
import org.springframework.transaction.TransactionStatus;
 
import java.util.List;
 
import javax.annotation.Resource;
@Service
public class Batt_dischargeService {
 
    @Resource
    private Batt_dischargeMapper mapper;
    @Resource
    private User_logService uservice;
    @Autowired
    DataSourceTransactionManager dataSourceTransactionManager;
    @Autowired
    TransactionDefinition transactionDefinition;
 
    ServiceModel model = new ServiceModel();
    
     //批量添加
    public ServiceModel add(List<Batt_discharge> listdischarge) {
        boolean bl = true;
        ServiceModel model = new ServiceModel();
        TransactionStatus transactionStatus = dataSourceTransactionManager.getTransaction(transactionDefinition);
        for (int i = 0; i < listdischarge.size(); i++) {
            if (!bl) {
                continue;
            }
            Batt_discharge bdischarge = listdischarge.get(i);
            try {
                bl = mapper.add(bdischarge);
            } catch (Exception e) {
                e.printStackTrace();
                bl=false;
            }
            String msg = "添加" + bdischarge.getDev_id() + "机房至放电黑名单!";
            User_log ulog = UinfDaoFactory.CreateULog(UinfDaoFactory.Increase, msg);
            uservice.add(ulog);
        }
        if (bl) {
            dataSourceTransactionManager.commit(transactionStatus);
            model.setCode(1);
            model.setMsg("添加成功!");
        } else {
            dataSourceTransactionManager.rollback(transactionStatus);
            model.setCode(0);
            model.setMsg("添加失败!");
        }
        return model;
    }
    //移除黑名单
    public ServiceModel del(List<Batt_discharge> listdischarge) {
        boolean bl = false;
        ServiceModel model = new ServiceModel();
        for (int i = 0; i < listdischarge.size(); i++) {
            bl = mapper.del(listdischarge.get(i));
        }
        if(bl){
            model.setCode(1);
            model.setMsg("移除成功!");
        }else{
            model.setCode(0);
            model.setMsg("移除失败!");
        }
        return model;
    }
     //根据设备id查询改设备是否被加入至黑名单
    public ServiceModel serchByCondition(Batt_discharge discharge) {
        List list=mapper.serchByCondition(discharge);
        if(list!=null&&list.size()>0){
            model.setCode(1);
            model.setData(list);
            model.setMsg("查询成功!");
        }else{
            model.setCode(0);
            model.setMsg("查询失败!");
        }
        return model;
    }
    //根据省市区县机房信息查询出所有不能放电的站
    public ServiceModel searchAll() {
        List list=mapper.searchAll();
        if(list!=null&&list.size()>0){
            model.setCode(1);
            model.setData(list);
            model.setMsg("查询成功!");
        }else{
            model.setCode(0);
            model.setMsg("查询失败!");
        }
        return model;
    }
    //根据省市区县机房信息查询出所有能放电的站
    public ServiceModel searchAllNotIn() {
        List list=mapper.searchAllNotIn();
        if(list!=null&&list.size()>0){
            model.setCode(1);
            model.setData(list);
            model.setMsg("查询成功!");
        }else{
            model.setCode(0);
            model.setMsg("查询失败!");
        }
        return model;
    }
    public static void main(String[] args) {
        Batt_dischargeService service=new Batt_dischargeService();
        Batt_discharge bd=new Batt_discharge();
        bd.setDev_id(910000001);
        ServiceModel model=service.serchByCondition(bd);
        System.out.println(model);
    }
 
}