LockSapUniqueIdService.java
5.22 KB
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
126
127
package com.huaheng.pc.sap.service;
import javax.annotation.Resource;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.StringUtils;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.huaheng.framework.web.domain.AjaxResult;
import com.huaheng.pc.sap.domain.LockSapUniqueId;
import com.huaheng.pc.sap.domain.Zarsh;
import com.huaheng.pc.sap.mapper.LockSapUniqueIdMapper;
/**
* Created by Cotter on 2023/2/1.
* @author zhouhong
*/
@Service
public class LockSapUniqueIdService extends ServiceImpl<LockSapUniqueIdMapper, LockSapUniqueId> {
@Resource
private LockSapUniqueIdService lockSapUniqueIdService;
public boolean checkStationUniqueId(Zarsh zarsh) {
if (zarsh.getMFlag().equals("2") || zarsh.getMFlag().equals("B")) {
String port = zarsh.getFromPos();
String uniqueId = zarsh.getUniqueId();
LambdaQueryWrapper<LockSapUniqueId> query = Wrappers.lambdaQuery();
query.eq(LockSapUniqueId::getStation, port);
query.eq(LockSapUniqueId::getStatus, 1);
LockSapUniqueId lockSapUniqueId = lockSapUniqueIdService.getOne(query);
if (lockSapUniqueId != null && !lockSapUniqueId.getUniqueId().equals(uniqueId)) {
return true;
}
}
return false;
}
/**
* 锁定站台sap唯一号
* @return
*/
@Transactional(propagation = Propagation.REQUIRES_NEW)
public AjaxResult lockStaionByUniqueId(Zarsh zarsh) {
String port = zarsh.getFromPos();
String uniqueId = zarsh.getUniqueId();
if (zarsh.getMFlag().equals("2") || zarsh.getMFlag().equals("B")) {
LambdaQueryWrapper<LockSapUniqueId> query = Wrappers.lambdaQuery();
query.eq(LockSapUniqueId::getStation, port);
LockSapUniqueId lockSapUniqueId = lockSapUniqueIdService.getOne(query);
if (lockSapUniqueId == null) {
// 不存在则锁定
lockSapUniqueId = new LockSapUniqueId();
lockSapUniqueId.setUniqueId(uniqueId);
lockSapUniqueId.setId(null);
lockSapUniqueId.setStatus(1);
lockSapUniqueId.setStation(port);
lockSapUniqueIdService.save(lockSapUniqueId);
return AjaxResult.success();
} else {
// 任务存在且状态不是锁定状态就锁
if (lockSapUniqueId.getStatus().intValue() != 1) {
lockSapUniqueId.setUniqueId(uniqueId);
lockSapUniqueId.setStatus(1);
lockSapUniqueId.setStation(port);
lockSapUniqueIdService.updateById(lockSapUniqueId);
return AjaxResult.success();
} else {
// return AjaxResult.error("该站台还有其他任务未解锁" + port + ":" + uniqueId);
}
}
}
return AjaxResult.success();
}
/**
* 解锁站台sap唯一号
*/
@Transactional(propagation = Propagation.REQUIRES_NEW)
public AjaxResult unlockStaionByUniqueId(Zarsh zarsh) {
String port = zarsh.getFromPos();
String uniqueId = zarsh.getUniqueId();
if (zarsh.getMFlag().equals("2") || zarsh.getMFlag().equals("B")) {
LambdaQueryWrapper<LockSapUniqueId> query = Wrappers.lambdaQuery();
query.eq(LockSapUniqueId::getUniqueId, uniqueId);
query.eq(LockSapUniqueId::getStation, port);
query.last("limit 1");
LockSapUniqueId lockSapUniqueId = lockSapUniqueIdService.getOne(query);
if (lockSapUniqueId != null) {
lockSapUniqueId.setStatus(2);
lockSapUniqueIdService.updateById(lockSapUniqueId);
return AjaxResult.success();
} else {
// return AjaxResult.error("找不到该唯一号，站台" + port);
}
}
return AjaxResult.success();
}
/**
* 解锁站台sap唯一号
*/
@Transactional(propagation = Propagation.REQUIRES_NEW)
public AjaxResult unlockStaionById(String station, String uniqueId) {
if (StringUtils.isEmpty(station)) {
return AjaxResult.error("站台不能为空");
}
if (StringUtils.isEmpty(uniqueId)) {
return AjaxResult.error("sap唯一号不能为空");
}
LambdaQueryWrapper<LockSapUniqueId> query = Wrappers.lambdaQuery();
query.eq(LockSapUniqueId::getUniqueId, uniqueId);
query.eq(LockSapUniqueId::getStation, station);
query.last("limit 1");
LockSapUniqueId lockSapUniqueId = lockSapUniqueIdService.getOne(query);
if (lockSapUniqueId != null) {
lockSapUniqueId.setStatus(2);
lockSapUniqueIdService.updateById(lockSapUniqueId);
return AjaxResult.success();
} else {
return AjaxResult.error("找不到该唯一号，站台" + station + ":" + uniqueId);
}
}
}