StationForConveyorExcute.cs
17.3 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
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
using HHECS.Application.Enums;
using HHECS.Application.Service;
using HHECS.BLL.EquipmentExcute;
using HHECS.BLL.EquipmentExcute.RGV;
using HHECS.BLL.Services;
using HHECS.BllModel;
using HHECS.Communication;
using HHECS.Communication.PLC;
using HHECS.Dal;
using HHECS.Dal.Repository;
using HHECS.DAL;
using HHECS.DAL.Repository;
using HHECS.Executor.EquipmentHandler;
using HHECS.Infrastructure.CommonHelper;
using HHECS.Model.Entities;
using HHECS.Model.Enums;
using System;
using System.Collections.Generic;
using System.Linq;
namespace HHECS.EquipmentExcute.CacheShelf
{
/// <summary>
/// 输送线站台
/// </summary>
public class StationForConveyorExcute : StationExecute
{
public StationForConveyorExcute(EquipmentType equipmentType) : base(equipmentType)
{
}
/// <summary>
/// 地址请求的处理
/// 注意：allEquipments引用所有设备，此为共享应用
/// </summary>
/// <param name="station"></param>
/// <param name="allEquipments"></param>
/// <param name="plc"></param>
/// <returns></returns>
public override BllResult ExcuteRequest(Equipment station, List<Equipment> allEquipments, PLCCore plc, User user)
{
try
{
var baseMaterialRepository = new BaseMaterialRepository();
var busWorkOrderHeadRepository = new BusWorkOrderHeadRepository();
var busWorkOrderDetailRepository = new BusWorkOrderDetailRepository();
var workOrderHead = new BusWorkOrderHead();
var workOrderDetail = new BusWorkOrderDetail();
var requestBarcode = station[StationProps.RequestBarcode.ToString()];
var requestNumber = station[StationProps.RequestNumber.ToString()];
if (string.IsNullOrEmpty(requestBarcode.Value))
{
workOrderDetail = busWorkOrderDetailRepository.Where(t => t.State == (int)EnumOrderBodyStatus.生产中 && t.EquipmentCode == station.Code).OrderBy(t => t.UpdateTime).First();
if (workOrderDetail == null)
{
return BllResultFactory.Error($"处理工位【{station.WorkStationCode}】的设备【{station.Name}】 地址请求失败，没有找到符合正在生产中并且设备等于{station.Code}工位条件的工单");
}
}
else
{
var convertResult = int.TryParse(requestBarcode.Value, out int BarCode);
if (!convertResult)
{
return BllResultFactory.Error($"处理工位【{station.WorkStationCode}】的设备【{station.Name}】 地址请求失败，工序任务ID【{requestBarcode.Value}】转化为整数失败！");
}
if (BarCode < 1)
{
return BllResultFactory.Error($"处理工位【{station.WorkStationCode}】的设备【{station.Name}】 地址请求失败，工序任务ID【{requestBarcode.Value}】不能小于1！");
}
workOrderDetail = busWorkOrderDetailRepository.Where(t => t.State == (int)EnumOrderBodyStatus.生产中 && t.BarCode == BarCode.ToString()).First();
if (workOrderDetail == null)
{
return BllResultFactory.Error($"处理工位【{station.WorkStationCode}】的设备【{station.Name}】 地址请求失败，找不到管段【{BarCode}】的工单明细数据");
}
}
var workOrderDetails = busWorkOrderDetailRepository.Where(t => t.HeadKeys == workOrderDetail.HeadKeys).ToList();
workOrderHead = busWorkOrderHeadRepository.Where(t => t.Keys == workOrderDetail.HeadKeys).First();
if (workOrderHead == null)
{
return BllResultFactory.Error($"处理工位【{station.WorkStationCode}】的设备【{station.Name}】 地址请求失败，找不到工单数据");
}
//var nextOprSequenceCodeWorkOrderDetails = workOrderDetails.Where(t => t.BarCode == workOrderDetail.BarCode && t.State == (int)EnumOrderBodyStatus.初始化).OrderBy(t => t.SerialNumber).ToList();
var material = baseMaterialRepository.Where(t => t.MaterialCode == workOrderDetail.WeldMaterCode).First();
if (material == null)
{
return BllResultFactory.Error($"处理工位【{station.WorkStationCode}】的设备【{station.Name}】地址请求失败，没有找到物料");
}
#region 检查工单中是否存在管段已经到某一个组队生产，如果存在，则直接去该组队工位，否则寻找联机无故障的组队工位上料
var NextStationCode = new Equipment();
//当前工序为2个设备对应一个工序，这里判断该工序的设备编号不为输送线，就说明已经到了组队工位了
var temp = workOrderDetails.FirstOrDefault(t =>t.EquipmentCode!=station.Code&& t.SerialNumber == workOrderDetail.SerialNumber && t.BarCode != workOrderDetail.BarCode && t.State > (int)EnumOrderBodyStatus.初始化);
if (temp != null)
{
NextStationCode = allEquipments.FirstOrDefault(t => t.Code == temp.EquipmentCode);
}
else
{
if (string.IsNullOrEmpty(station.GoAddress))
{
var NextStationCodes = allEquipments.Where(t => t.EquipmentTypeId == station.NextEquipmentTypeId).ToList();
for (int i = 0; i < NextStationCodes.Count; i++)
{
var operationModel = NextStationCodes[i][StationProps.OperationModel.ToString()];
var totalError = NextStationCodes[i][StationProps.TotalError.ToString()];
var allowEntry = NextStationCodes[i][StationProps.AllowEntry.ToString()];
if (operationModel?.Value != OperationModelFlag.Online.GetIndexString() || totalError?.Value != TotalErrorFlag.Normal.GetIndexString() || allowEntry?.Value != StationAllowEntry.Allow.GetIndexString())
{
NextStationCodes.RemoveAt(i);
}
}
// 优先去二号组队，防止堵塞
NextStationCodes = NextStationCodes.OrderByDescending(t => t.Code).ToList();
if (NextStationCodes.Any())
{
NextStationCode = NextStationCodes[0];
}
else
{
return BllResultFactory.Error($"处理工位【{station.WorkStationCode}】的设备【{station.Name}】地址请求失败，下个设备{station.GoAddress}没有找到，请检查设备表的自身地址");
}
}
else
{
NextStationCode = allEquipments.Where(t => t.SelfAddress == station.GoAddress).FirstOrDefault();
}
}
#endregion
workOrderDetail.StationCode = NextStationCode.WorkStationCode;
workOrderDetail.EquipmentCode = NextStationCode.Code;
workOrderDetail.ActualEndTime = DateTime.Now;
workOrderDetail.State = (int)EnumOrderBodyStatus.运输中;
workOrderDetail.UpdateTime = DateTime.Now;
workOrderDetail.UpdateBy = user.UserCode;
//设置工序任务头
var otherPipeOrder = workOrderDetails.Where(t => t.SerialNumber == workOrderDetail.SerialNumber && t.BarCode != workOrderDetail.BarCode && t.State < (int)EnumOrderBodyStatus.已完成).ToList();
//判断是否为工单中的第一个单管，当前工位工序，只在第一个单管执行。下个工位工序，只在最后一个单管执行
if (!otherPipeOrder.Any())
{
workOrderHead.NextStationCode = NextStationCode.WorkStationCode;
workOrderHead.UpdateTime = DateTime.Now;
workOrderHead.UpdateBy = user.UserCode;
}
using (var uw = DALHelper.GetFreeSql().CreateUnitOfWork())
{
try
{
busWorkOrderHeadRepository.UnitOfWork = uw;
busWorkOrderHeadRepository.Update(workOrderHead);
busWorkOrderDetailRepository.UnitOfWork = uw;
busWorkOrderDetailRepository.Update(workOrderDetail);
var sendResult = SendAddressReplyToPlc(station, plc, StationMessageFlag.WCSAddressReply, StationLoadStatus.Default, requestNumber.Value,workOrderDetail.BarCode.ToString(), NextStationCode.SelfAddress, "0",material.TypesPlcCode, (decimal)workOrderDetail.CuttingLength, material.Diameter, material.Thickness);
if (sendResult.Success)
{
uw.Commit();
return BllResultFactory.Success($"处理工位【{station.WorkStationCode}】设备【{station.Name}】地址请求成功，管段编码【{workOrderDetail.BarCode}】信息写入设备成功");
}
else
{
uw.Rollback();
return BllResultFactory.Error($"处理工位【{station.WorkStationCode}】设备【{station.Name}】地址请求失败，管段编码【{workOrderDetail.BarCode}】信息写入设备失败，原因：{sendResult.Msg}");
}
}
catch (Exception ex)
{
uw.Rollback();
return BllResultFactory.Exception(ex, $"处理工位【{station.WorkStationCode}】的设备【{station.Name}】地址请求失败，处理管段编码【{workOrderDetail.BarCode}】信息发生异常，原因：{ex.Message}");
}
}
}
catch (Exception ex)
{
return BllResultFactory.Exception(ex, $"处理工位【{station.WorkStationCode}】设备【{station.Name}】地址请求失败，异常原因：{ex.Message}");
}
}
/// <summary>
/// 位置到达的处理
/// 注意：allEquipments引用所有设备，此为共享应用
/// </summary>
/// <param name="station"></param>
/// <param name="allEquipments"></param>
/// <param name="plc"></param>
/// <returns></returns>
public override BllResult ExcuteArrive(Equipment station, List<Equipment> allEquipments, PLCCore plc, User user)
{
try
{
var arriveBarcode = station[StationProps.ArriveBarcode.ToString()];
var number = station[StationProps.ArriveRealAddress.ToString()];
var baseMaterialRepository = new BaseMaterialRepository();
var busWorkOrderHeadRepository = new BusWorkOrderHeadRepository();
var busWorkOrderDetailRepository = new BusWorkOrderDetailRepository();
var workOrderDetail = new BusWorkOrderDetail();
var workOrderHead = new BusWorkOrderHead();
if (string.IsNullOrEmpty(arriveBarcode.Value))
{
workOrderDetail = busWorkOrderDetailRepository.Where(t => t.State == (int)EnumOrderBodyStatus.运输中 && t.EquipmentCode == station.Code).OrderBy(t => t.UpdateTime).First();
if (workOrderDetail == null)
{
return BllResultFactory.Error($"处理工位【{station.WorkStationCode}】的设备【{station.Name}】 位置到达失败，没有找到符合正在运输中并且s设备等于{station.Code}工位条件的工单");
}
}
else
{
var convertResult = int.TryParse(arriveBarcode.Value, out int BarCode);
if (!convertResult)
{
return BllResultFactory.Error($"处理工位【{station.WorkStationCode}】的设备【{station.Name}】 位置到达失败，工序任务ID【{arriveBarcode.Value}】转化为整数失败！");
}
if (BarCode < 1)
{
return BllResultFactory.Error($"处理工位【{station.WorkStationCode}】的设备【{station.Name}】 位置到达失败，工序任务ID【{arriveBarcode.Value}】不能小于1！");
}
workOrderDetail = busWorkOrderDetailRepository.Where(t => t.State == (int)EnumOrderBodyStatus.运输中 && t.BarCode == BarCode.ToString()).First();
if (workOrderDetail == null)
{
return BllResultFactory.Error($"处理工位【{station.WorkStationCode}】的设备【{station.Name}】 位置到达失败，找不到管段【{BarCode}】的工单明细数据");
}
}
var workOrderDetails = busWorkOrderDetailRepository.Where(t => t.HeadKeys == workOrderDetail.HeadKeys).ToList();
workOrderHead = busWorkOrderHeadRepository.Where(t => t.Keys == workOrderDetail.HeadKeys).First();
if (workOrderHead == null)
{
return BllResultFactory.Error($"处理工位【{station.WorkStationCode}】的设备【{station.Name}】 位置到达失败，找不到工单数据");
}
var material = baseMaterialRepository.Where(t => t.MaterialCode == workOrderDetail.WeldMaterCode).First();
if (material == null)
{
return BllResultFactory.Error($"处理工位【{station.WorkStationCode}】的设备【{station.Name}】位置到达失败，没有找到物料");
}
var otherPipeOrder = workOrderDetails.Where(t => t.SerialNumber == workOrderDetail.SerialNumber && t.BarCode != workOrderDetail.BarCode && t.State > (int)EnumOrderBodyStatus.运输中).ToList();
//判断是否为工单中的第一个单管，当前工位工序，只在第一个单管执行。下个工位工序，只在最后一个单管执行
if (!otherPipeOrder.Any())
{
//工单头，只有在第一根管材的时候才修改时间
workOrderHead.NowOprSequenceCode = workOrderDetail.OprSequenceCode;
workOrderHead.NowStationCode = workOrderDetail.StationCode;
}
workOrderDetail.State = (int)EnumOrderBodyStatus.生产中;
workOrderDetail.EquipmentCode = station.Code;
workOrderDetail.StationCode = station.WorkStationCode;
workOrderDetail.UpdateBy = user.UserCode;
workOrderDetail.ActualEndTime = DateTime.Now;
using (var uw = DALHelper.GetFreeSql().CreateUnitOfWork())
{
try
{
busWorkOrderHeadRepository.UnitOfWork = uw;
busWorkOrderHeadRepository.Update(workOrderHead);
busWorkOrderDetailRepository.UnitOfWork = uw;
busWorkOrderDetailRepository.Update(workOrderDetail);
BllResult sendResult = SendAckToPlc(station, plc, StationMessageFlag.WCSPLCACK, StationLoadStatus.ArriveReply, number.Value, workOrderDetail.BarCode, "0", 0, material.TypesPlcCode, (decimal)workOrderDetail.CuttingLength, material.Diameter, material.Thickness);
if (sendResult.Success)
{
uw.Commit();
return BllResultFactory.Success($"处理工位【{station.WorkStationCode}】设备【{station.Name}】位置到达成功，管段条码【{workOrderDetail.BarCode}】信息写入设备成功");
}
else
{
uw.Rollback();
return BllResultFactory.Error($"处理工位【{station.WorkStationCode}】设备【{station.Name}】位置到达失败，库存id【{workOrderDetail.BarCode}】信息写入设备失败，原因：{sendResult.Msg}");
}
}
catch (Exception ex)
{
uw.Rollback();
return BllResultFactory.Exception(ex, $"处理工位【{station.WorkStationCode}】的设备【{station.Name}】位置到达的时候，处理库存id【{workOrderDetail.BarCode}】信息发生异常，原因：{ex.Message}");
}
}
}
catch (Exception ex)
{
return BllResultFactory.Exception(ex, $"处理工位【{station.WorkStationCode}】设备【{station.Name}】位置到达失败时候，异常原因：{ex.Message}");
}
}
}
}