| | |
| | | public class WmsOperationTaskService : IDynamicApiController, ITransient |
| | | { |
| | | private static readonly SemaphoreSlim semaphore = new SemaphoreSlim(1, 1); |
| | | private static readonly SemaphoreSlim semaphore2 = new SemaphoreSlim(1, 1); |
| | | |
| | | private readonly SqlSugarRepository<WmsRbLineTask> _rep; |
| | | private readonly SqlSugarRepository<WmsStockQuan> _wmsStockQuanRep; |
| | |
| | | [UnitOfWork] |
| | | public async Task<ValidateQiTaoOutput> ValdateQiTao(ValidateQiTaoInput input) |
| | | { |
| | | ValidateQiTaoOutput output = new ValidateQiTaoOutput(); |
| | | if (input == null || input.PackageCode == null) |
| | | await semaphore2.WaitAsync(); |
| | | try |
| | | { |
| | | throw Oops.Oh("参数不能为空"); |
| | | } |
| | | ValidateQiTaoOutput output = new ValidateQiTaoOutput(); |
| | | if (input == null || input.PackageCode == null) |
| | | { |
| | | throw Oops.Oh("参数不能为空"); |
| | | } |
| | | |
| | | var package = await _mesPackageGatherRep.AsQueryable().Where(x => x.PackageCode == input.PackageCode).FirstAsync(); |
| | | if (package == null) |
| | | { |
| | | throw Oops.Oh($"没有找到包号{input.PackageCode}的汇总数据"); |
| | | } |
| | | var package = await _mesPackageGatherRep.AsQueryable().Where(x => x.PackageCode == input.PackageCode).FirstAsync(); |
| | | if (package == null) |
| | | { |
| | | throw Oops.Oh($"没有找到包号{input.PackageCode}的汇总数据"); |
| | | } |
| | | |
| | | if (package.UpiStatus == UpiStatusEnum.已下线) |
| | | { |
| | | throw Oops.Oh($"包{input.PackageCode}已下线"); |
| | | } |
| | | if (package.UpiStatus == UpiStatusEnum.已下线) |
| | | { |
| | | throw Oops.Oh($"包{input.PackageCode}已下线"); |
| | | } |
| | | |
| | | var unlineObj = await _mes_Package_UnLine_RecordRep.AsQueryable().Where(x => x.PackageCode == input.PackageCode).FirstAsync(); |
| | | if (unlineObj != null) |
| | | { |
| | | throw Oops.Oh($"包号{input.PackageCode}已经下线"); |
| | | } |
| | | var unlineObj = await _mes_Package_UnLine_RecordRep.AsQueryable().Where(x => x.PackageCode == input.PackageCode).FirstAsync(); |
| | | if (unlineObj != null) |
| | | { |
| | | throw Oops.Oh($"包号{input.PackageCode}已经下线"); |
| | | } |
| | | |
| | | //判断是否是新生产订单 |
| | | var _QiTaoReuslt = ""; |
| | | bool isNewOrder = false; |
| | | string _location = "BZ-33"; |
| | | var lastPackageUnline = await _mes_Package_UnLine_RecordRep.AsQueryable().Where(x => x.UpiFlag == UpiFlagEnum.正常 && x.Location != "人工").OrderByDescending(x => x.Id).FirstAsync(); |
| | | if (lastPackageUnline == null) |
| | | {//认为是新生产订单 |
| | | isNewOrder = true; |
| | | } |
| | | else |
| | | { |
| | | if (lastPackageUnline.Info5 != package.Info5) |
| | | //判断是否是新生产订单 |
| | | var _QiTaoReuslt = ""; |
| | | bool isNewOrder = false; |
| | | string _location = "BZ-33"; |
| | | var lastPackageUnline = await _mes_Package_UnLine_RecordRep.AsQueryable().Where(x => x.UpiFlag == UpiFlagEnum.正常 && x.Location != "人工").OrderByDescending(x => x.Id).FirstAsync(); |
| | | if (lastPackageUnline == null) |
| | | {//认为是新生产订单 |
| | | isNewOrder = true; |
| | | if (lastPackageUnline.Location == "BZ-33") |
| | | { |
| | | _location = "BZ-32"; |
| | | } |
| | | else |
| | | { |
| | | _location = "BZ-33"; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | _location = lastPackageUnline.Location; |
| | | if (lastPackageUnline.Info5 != package.Info5) |
| | | {//认为是新生产订单 |
| | | isNewOrder = true; |
| | | if (lastPackageUnline.Location == "BZ-33") |
| | | { |
| | | _location = "BZ-32"; |
| | | } |
| | | else |
| | | { |
| | | _location = "BZ-33"; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | _location = lastPackageUnline.Location; |
| | | } |
| | | } |
| | | } |
| | | if (string.IsNullOrEmpty(_location)) |
| | | {//默认 |
| | | _location = "BZ-33"; |
| | | } |
| | | if (string.IsNullOrEmpty(_location)) |
| | | {//默认 |
| | | _location = "BZ-33"; |
| | | } |
| | | |
| | | _QiTaoReuslt = (bool)isNewOrder ? "新订单" : "当前订单"; |
| | | _QiTaoReuslt = (bool)isNewOrder ? "新订单" : "当前订单"; |
| | | |
| | | |
| | | //记录工作时间和工作人 |
| | | var curUserName = App.User.FindFirst(ClaimConst.RealName)?.Value; |
| | | //记录工作时间和工作人 |
| | | var curUserName = App.User.FindFirst(ClaimConst.RealName)?.Value; |
| | | |
| | | var sysConfig_wms_unline_oper = await _sysConfigRep.GetFirstAsync(x => x.Code == CommonConst.wms_unline_oper); |
| | | if (sysConfig_wms_unline_oper == null) |
| | | { |
| | | throw Oops.Oh($"没有配置 包装下线操作人 值"); |
| | | } |
| | | if (sysConfig_wms_unline_oper.Value != curUserName) |
| | | { |
| | | sysConfig_wms_unline_oper.Value = curUserName; |
| | | await _sysConfigRep.UpdateAsync(sysConfig_wms_unline_oper); |
| | | |
| | | var sysConfig_wms_unline_time = await _sysConfigRep.GetFirstAsync(x => x.Code == CommonConst.wms_unline_time); |
| | | if (sysConfig_wms_unline_time == null) |
| | | var sysConfig_wms_unline_oper = await _sysConfigRep.GetFirstAsync(x => x.Code == CommonConst.wms_unline_oper); |
| | | if (sysConfig_wms_unline_oper == null) |
| | | { |
| | | throw Oops.Oh($"没有配置 包装下线登陆时间 值"); |
| | | throw Oops.Oh($"没有配置 包装下线操作人 值"); |
| | | } |
| | | sysConfig_wms_unline_time.Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); |
| | | await _sysConfigRep.UpdateAsync(sysConfig_wms_unline_time); |
| | | if (sysConfig_wms_unline_oper.Value != curUserName) |
| | | { |
| | | sysConfig_wms_unline_oper.Value = curUserName; |
| | | await _sysConfigRep.UpdateAsync(sysConfig_wms_unline_oper); |
| | | |
| | | var sysConfig_wms_unline_time = await _sysConfigRep.GetFirstAsync(x => x.Code == CommonConst.wms_unline_time); |
| | | if (sysConfig_wms_unline_time == null) |
| | | { |
| | | throw Oops.Oh($"没有配置 包装下线登陆时间 值"); |
| | | } |
| | | sysConfig_wms_unline_time.Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); |
| | | await _sysConfigRep.UpdateAsync(sysConfig_wms_unline_time); |
| | | } |
| | | |
| | | |
| | | |
| | | //请求PLC |
| | | //判断方向 |
| | | bool myLocation = false; |
| | | if (_location == "BZ-33") |
| | | { |
| | | myLocation = false; |
| | | } |
| | | else |
| | | { |
| | | myLocation = true; |
| | | } |
| | | var client = await WCFServiceHelper.GetWCFService_SAPCC_Client(_sysConfigRep); |
| | | var res = await client.WriteQiTaoInfoAsync(myLocation); |
| | | if (res.result == false) |
| | | { |
| | | throw Oops.Oh(res.resMsg); |
| | | } |
| | | |
| | | |
| | | //更新数据 |
| | | package.UpiStatus = UpiStatusEnum.已下线; |
| | | package.AreaCode = AreaCodeEnum.下线区域; |
| | | await _mesPackageGatherRep.UpdateAsync(package); |
| | | |
| | | var upiList = await _mesBatchOrderUpiRep.AsQueryable().Where(x => x.PackageCode == input.PackageCode).ToListAsync(); |
| | | foreach (var item in upiList) |
| | | { |
| | | item.UpiStatus = UpiStatusEnum.已下线; |
| | | item.AreaCode = AreaCodeEnum.下线区域; |
| | | item.UpdateTime = DateTime.Now; |
| | | } |
| | | await _mesBatchOrderUpiRep.UpdateRangeAsync(upiList); |
| | | //删除队列信息 |
| | | var lineQueue = await _mes_Package_LineQueueRep.AsQueryable().Where(x => x.PackageCode == input.PackageCode).FirstAsync(); |
| | | if (lineQueue != null) |
| | | { |
| | | await _mes_Package_LineQueueRep.DeleteAsync(lineQueue); |
| | | } |
| | | //处理表 mes_order_gather |
| | | await UpdateOrderGather(package, false); |
| | | |
| | | var _cretaorName = App.User.FindFirst(ClaimConst.RealName)?.Value; |
| | | |
| | | //新增下线记录表 |
| | | var all_upiList = await _mesBatchOrderUpiRep.AsQueryable().Where(x => x.Info5 == package.Info5).ToListAsync(); |
| | | var all_unlineList = await _mes_Package_UnLine_RecordRep.AsQueryable().Where(x => x.Info5 == package.Info5).ToListAsync(); |
| | | Mes_Package_UnLine_Record record = new Mes_Package_UnLine_Record(); |
| | | record = package.Adapt<Mes_Package_UnLine_Record>(); |
| | | record.Id = Yitter.IdGenerator.YitIdHelper.NextId(); |
| | | record.Location = _location; |
| | | record.AllPackageNum = all_upiList.GroupBy(x => x.PackageCode).Count(); |
| | | record.CurUnlineIndexPackageNum = all_unlineList.GroupBy(x => x.PackageCode).Count() + 1; |
| | | record.CreateTime = DateTime.Now; |
| | | record.CreateUserName = _cretaorName; |
| | | await _mes_Package_UnLine_RecordRep.InsertAsync(record); |
| | | |
| | | //记录包履历 |
| | | WmsRecordPackageProcess wmsRecordPackage = new WmsRecordPackageProcess(); |
| | | wmsRecordPackage = package.Adapt<WmsRecordPackageProcess>(); |
| | | wmsRecordPackage.Id = Yitter.IdGenerator.YitIdHelper.NextId(); |
| | | wmsRecordPackage.Location = ""; |
| | | wmsRecordPackage.OperRemark = "正常下线"; |
| | | wmsRecordPackage.CreateTime = DateTime.Now; |
| | | wmsRecordPackage.CreateUserName = _cretaorName; |
| | | await _wmsRecordPackageProcessRep.InsertAsync(wmsRecordPackage); |
| | | |
| | | |
| | | output = package.Adapt<ValidateQiTaoOutput>(); |
| | | output.QiTaoReuslt = _QiTaoReuslt + $",第{record.CurUnlineIndexPackageNum}包下线,共{record.AllPackageNum}包"; |
| | | output.IsNewOrder = isNewOrder; |
| | | //output.IsNewOrder = false; |
| | | return output; |
| | | } |
| | | |
| | | |
| | | |
| | | //请求PLC |
| | | //判断方向 |
| | | bool myLocation = false; |
| | | if (_location == "BZ-33") |
| | | catch (Exception) |
| | | { |
| | | myLocation = false; |
| | | |
| | | throw; |
| | | } |
| | | else |
| | | finally |
| | | { |
| | | myLocation = true; |
| | | } |
| | | var client = await WCFServiceHelper.GetWCFService_SAPCC_Client(_sysConfigRep); |
| | | var res = await client.WriteQiTaoInfoAsync(myLocation); |
| | | if (res.result == false) |
| | | { |
| | | throw Oops.Oh(res.resMsg); |
| | | semaphore2.Release(); |
| | | } |
| | | |
| | | |
| | | //更新数据 |
| | | package.UpiStatus = UpiStatusEnum.已下线; |
| | | package.AreaCode = AreaCodeEnum.下线区域; |
| | | await _mesPackageGatherRep.UpdateAsync(package); |
| | | |
| | | var upiList = await _mesBatchOrderUpiRep.AsQueryable().Where(x => x.PackageCode == input.PackageCode).ToListAsync(); |
| | | foreach (var item in upiList) |
| | | { |
| | | item.UpiStatus = UpiStatusEnum.已下线; |
| | | item.AreaCode = AreaCodeEnum.下线区域; |
| | | item.UpdateTime = DateTime.Now; |
| | | } |
| | | await _mesBatchOrderUpiRep.UpdateRangeAsync(upiList); |
| | | //删除队列信息 |
| | | var lineQueue = await _mes_Package_LineQueueRep.AsQueryable().Where(x => x.PackageCode == input.PackageCode).FirstAsync(); |
| | | if (lineQueue != null) |
| | | { |
| | | await _mes_Package_LineQueueRep.DeleteAsync(lineQueue); |
| | | } |
| | | //处理表 mes_order_gather |
| | | await UpdateOrderGather(package, false); |
| | | |
| | | var _cretaorName = App.User.FindFirst(ClaimConst.RealName)?.Value; |
| | | |
| | | //新增下线记录表 |
| | | var all_upiList = await _mesBatchOrderUpiRep.AsQueryable().Where(x => x.Info5 == package.Info5).ToListAsync(); |
| | | var all_unlineList = await _mes_Package_UnLine_RecordRep.AsQueryable().Where(x => x.Info5 == package.Info5).ToListAsync(); |
| | | Mes_Package_UnLine_Record record = new Mes_Package_UnLine_Record(); |
| | | record = package.Adapt<Mes_Package_UnLine_Record>(); |
| | | record.Id = Yitter.IdGenerator.YitIdHelper.NextId(); |
| | | record.Location = _location; |
| | | record.AllPackageNum = all_upiList.GroupBy(x => x.PackageCode).Count(); |
| | | record.CurUnlineIndexPackageNum = all_unlineList.GroupBy(x => x.PackageCode).Count() + 1; |
| | | record.CreateTime = DateTime.Now; |
| | | record.CreateUserName = _cretaorName; |
| | | await _mes_Package_UnLine_RecordRep.InsertAsync(record); |
| | | |
| | | //记录包履历 |
| | | WmsRecordPackageProcess wmsRecordPackage = new WmsRecordPackageProcess(); |
| | | wmsRecordPackage = package.Adapt<WmsRecordPackageProcess>(); |
| | | wmsRecordPackage.Id = Yitter.IdGenerator.YitIdHelper.NextId(); |
| | | wmsRecordPackage.Location = ""; |
| | | wmsRecordPackage.OperRemark = "正常下线"; |
| | | wmsRecordPackage.CreateTime = DateTime.Now; |
| | | wmsRecordPackage.CreateUserName = _cretaorName; |
| | | await _wmsRecordPackageProcessRep.InsertAsync(wmsRecordPackage); |
| | | |
| | | |
| | | output = package.Adapt<ValidateQiTaoOutput>(); |
| | | output.QiTaoReuslt = _QiTaoReuslt + $",第{record.CurUnlineIndexPackageNum}包下线,共{record.AllPackageNum}包"; |
| | | output.IsNewOrder = isNewOrder; |
| | | //output.IsNewOrder = false; |
| | | return output; |
| | | } |
| | | |
| | | |