ConveyingExcute.cs
16.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
using HHECS.Application.Enums;
using HHECS.Application.Service;
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.Model.Entities;
using HHECS.Model.Enums;
using Microsoft.Data.SqlClient;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Linq;
namespace HHECS.BLL.EquipmentExcute.Machine
{
/// <summary>
/// 自动打磨机
/// </summary>
public class ConveyingExcute : StationExecute
{
int toadd = 1009;
public bool ISorTrue = true;
int LStationNum = 0;
public ConveyingExcute(EquipmentType equipmentType) : base(equipmentType)
{
}
/// <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 cutPlandDilt = new CutPlanDetailRepository();
// var workOrderDetail = new BusWorkOrderDetail();
// var workOrderHead = new BusWorkOrderHead();
// int beavl = 0;
// 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}】 位置到达失败，没有找到符合正在运输中并且设备等于{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！");
// }
// var cutplandilt = cutPlandDilt.Where(t => t.Id == BarCode).First();
// workOrderDetail = busWorkOrderDetailRepository.Where(t => t.State == (int)EnumOrderBodyStatus.初始化 && t.BarCode == BarCode.ToString()&& t.OprSequenceCode == "Bevel").OrderByDescending(t=>t.CreateTime).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.CutMaterCode).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;
// }
// if (workOrderDetail.ExtendComp3!= null) //判断单坡还是双坡
// {
// beavl = beavl + 1 ;
// }
// else if (workOrderDetail.ExtendComp2 != null)
// {
// beavl = beavl+ 1;
// }
// if (workOrderDetail.Bevels1 == null)
// {
// return BllResultFactory.Error($"处理工位【{station.WorkStationCode}】设备【{station.Name}】位置到达失败，坡口角度【{arriveBarcode.Value}】,坡口信息为空，信息写入设备失败");
// }
// 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, "0", "0", beavl.ToString(), Convert.ToInt32(workOrderDetail.Bevels1), 0,0,0, 0);
// if (sendResult.Success)
// {
// uw.Commit();
// //WebApiService.SendIWPTechnologylineProcess(workOrderHead.WorkOrderCode, workOrderDetail.BarCode, (int)EnumCutHeadState.打磨进行);
// return BllResultFactory.Success($"处理工位【{station.WorkStationCode}】设备【{station.Name}】位置到达成功，管段条码【{arriveBarcode.Value}】信息写入设备成功");
// }
// 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}");
// }
//}
/// <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 arriveBarcode = station[StationProps.RequestBarcode.ToString()];
var number = station[StationProps.ArriveRealAddress.ToString()];
var baseMaterialRepository = new BaseMaterialRepository();
var cutPlanHeadRepository = new CutPlanHeadRepository();
var cutPlandDilt = new CutPlanDetailRepository();
var BusWorkOrderDetail = new BusWorkOrderDetailRepository();
var wcs_dictdetail = new DictRepository();
var wcs_dict = new DictDetailRepository();
int gotoadd;
int gotadd;
if (string.IsNullOrEmpty(arriveBarcode.Value))
{
return BllResultFactory.Error($"处理输送线工位【{station.WorkStationCode}】设备【{station.Name}】下料条码{arriveBarcode.Value}为空请求失败，切割方案");
}
else
{
var cutplandilt = cutPlandDilt.Where(t => t.Id.ToString() == arriveBarcode.Value).OrderByDescending(t => t.CreateTime).ToList();
if (cutplandilt.Count == 0)
{
return BllResultFactory.Error($"处理输送线工位【{station.WorkStationCode}】设备【{station.Name}】地址请求失败，没有找到{arriveBarcode.Value}切割明细");
}
//cutplandilt[0].CutState = (int)CutPlanDetailState.切割完成;
using (var uw = DALHelper.GetFreeSql().CreateUnitOfWork())
{
cutPlandDilt.UnitOfWork = uw;
//var planhead = cutPlanHeadRepository.Where(t => t.Keys == cutplandilt[0].HeadKeys).First();
//var busworkorderdetail = BusWorkOrderDetail.Where(t => t.BodyKeys == cutplandilt[0].WorkOrderDetailKeys && t.OprSequenceName == "弯管" && t.State!=100).First();//如果存在弯管的给目的地为弯管机
if (!string.IsNullOrEmpty(cutplandilt[0].Extend2))
{
gotadd = Convert.ToInt32(cutplandilt[0].Extend2);
cutplandilt[0].UpdateTime = DateTime.Now;
cutplandilt[0].CutEndTime = DateTime.Now;
cutPlandDilt.Update(cutplandilt);
var sendResult = SendAddressReplyToPlc(station, plc, StationMessageFlag.WCSAddressReply, StationLoadStatus.Default, "0", "0", "0", cutplandilt[0].Cuttinglength.ToString(), "0", "0", gotadd.ToString(), "0");
if (sendResult.Success)
{
WebApiService.Layingoff(cutplandilt[0].BarCode, gotadd.ToString());//告诉mes在哪下料
uw.Commit();
return BllResultFactory.Success($"处理输送线工位【{station.WorkStationCode}】设备【{station.Name}】地址请求成功，工单id【{cutplandilt[0].Id}】信息写入设备成功，目的地{cutplandilt[0].Extend2}");
}
else
{
uw.Rollback();
return BllResultFactory.Error($"处理输送线工位【{station.WorkStationCode}】设备【{station.Name}】地址请求失败，工单id【{cutplandilt[0].Id}】信息写入设备失败，原因：{sendResult.Msg}");
}
}
else if (string.IsNullOrEmpty(cutplandilt[0].Extend2))
{
///确认下料点位 多个点位轮流下料
var Isdict = wcs_dictdetail.Where(t => t.Code == "WorkStation").ToList();
// var Expend1 = EnumStationFlowCode.L.ToString();
var Code = ConfigurationManager.AppSettings["LineCode"].Trim().Split(',')[0];
var istrue = wcs_dict.Where(t => t.DictId == Isdict[0].Id && t.Remark != "1" && t.Code == Code).ToList();
if (istrue.Count == 0)
{
toadd = 1006;
}
else
{
///工位轮询取值
for (int i = 0; i < istrue.Count; i++)
{
if (LStationNum >= istrue.Count)
{
LStationNum = 0;
}
if (i == LStationNum)
{
toadd = Convert.ToInt32(istrue[i].Value);
LStationNum++;
break;
}
}
}
cutplandilt[0].UpdateTime = DateTime.Now;
cutplandilt[0].Extend2 = toadd.ToString();
// cutplandilt[0].CutEndTime = DateTime.Now;
cutPlandDilt.Update(cutplandilt);
var sendResult = SendAddressReplyToPlc(station, plc, StationMessageFlag.WCSAddressReply, StationLoadStatus.Default, "0", "0", "0", cutplandilt[0].Cuttinglength.ToString(), "0", "0", toadd.ToString(), "0");
if (sendResult.Success)
{
WebApiService.Layingoff(cutplandilt[0].BarCode, toadd.ToString());//告诉mes在哪下料
uw.Commit();
return BllResultFactory.Success($"处理输送线工位【{station.WorkStationCode}】设备【{station.Name}】地址请求成功，工单id【{cutplandilt[0].Id}】信息写入设备成功,目的地{toadd.ToString()}");
}
else
{
uw.Rollback();
return BllResultFactory.Error($"处理输送线工位【{station.WorkStationCode}】设备【{station.Name}】地址请求失败，工单id【{cutplandilt[0].Id}】信息写入设备失败，原因：{sendResult.Msg}");
}
}
{
return BllResultFactory.Error($"处理输送线工位【{station.WorkStationCode}】设备【{station.Name}】地址请求下料失败，工单id【{cutplandilt[0].Id}】存在没有的下料工位，请检查套料数据");
}
}
}
}
catch (Exception ex)
{
return BllResultFactory.Exception(ex, $"处理工位【{station.WorkStationCode}】设备【{station.Name}】地址请求失败，异常原因：{ex.Message}");
}
}
}
}