| | |
| | | using Microsoft.AspNetCore.SignalR; |
| | | using Newtonsoft.Json; |
| | | using OfficeOpenXml.FormulaParsing.Excel.Functions.Database; |
| | | using OfficeOpenXml.FormulaParsing.Excel.Functions.Math; |
| | | using OfficeOpenXml.FormulaParsing.Excel.Functions.Text; |
| | | using Org.BouncyCastle.Asn1.Tsp; |
| | | using Spire.Pdf; |
| | | using SqlSugar; |
| | | using System; |
| | | using System; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.ComponentModel; |
| | | using System.ComponentModel.DataAnnotations; |
| | | using System.Diagnostics.CodeAnalysis; |
| | | using System.Drawing.Printing; |
| | | using System.IO; |
| | | using System.Linq; |
| | | using System.Net.Http; |
| | | using System.Reflection; |
| | | using System.Reflection.Metadata; |
| | | using System.Text; |
| | | using System.Threading.Tasks; |
| | | using System.Threading.Tasks; |
| | | using WIDESEA_BasicRepository; |
| | | using WIDESEA_Common; |
| | | using WIDESEA_Common.Log; |
| | | using WIDESEA_Common.OrderEnum; |
| | | using WIDESEA_Common.TaskEnum; |
| | | using WIDESEA_Core; |
| | |
| | | using WIDESEA_Core.Helper; |
| | | using WIDESEA_Core.TaskEnum; |
| | | using WIDESEA_DTO.Basic; |
| | | using WIDESEA_DTO.ERP; |
| | | using WIDESEA_DTO.Inbound; |
| | | using WIDESEA_DTO.Stock; |
| | | using WIDESEA_DTO.Task; |
| | |
| | | using WIDESEA_IBasicService; |
| | | using WIDESEA_IInboundRepository; |
| | | using WIDESEA_IInboundService; |
| | | using WIDESEA_InboundRepository; |
| | | using WIDESEA_IOutboundRepository; |
| | | using WIDESEA_IOutboundService; |
| | | using WIDESEA_IRecordService; |
| | |
| | | using WIDESEA_ITaskInfoService; |
| | | using WIDESEA_Model.Models; |
| | | using WIDESEA_Model.Models.Inbound; |
| | | using WIDESEA_OutboundRepository; |
| | | using WIDESEA_StockRepository; |
| | | using WIDESEA_TaskInfoRepository; |
| | | using static WIDESEA_Common.Authentication; |
| | | using static WIDESEA_Common.HouseBackboundPassBack; |
| | | using static WIDESEA_Common.HouseInboundPassBack; |
| | | using static WIDESEA_Common.HouseInboundPassBack.data.data1; |
| | | using static WIDESEA_Common.HouseoutboundPassBack; |
| | | using static WIDESEA_Common.InventoryAllocate; |
| | | using static WIDESEA_Common.NewHouseInboundPassBack; |
| | | using static WIDESEA_Common.NewHouseInboundPassBack.Parame.Syncretism; |
| | | using static WIDESEA_ITaskInfoService.ITaskService; |
| | | using Parameter = WIDESEA_Common.Parameter; |
| | | using WIDESEA_DTO.ERP; |
| | |
| | | using WIDESEA_InboundRepository; |
| | | using System.Drawing.Printing; |
| | | using System; |
| | | using WIDESEA_Common.Log; |
| | | using static WIDESEA_Common.HouseInboundPassBack.data.data1; |
| | | using System.Diagnostics; |
| | | |
| | | namespace WIDESEA_TaskInfoService |
| | | { |
| | |
| | | private readonly IOutboundOrderDetail_HtyService _outboundOrderDetail_HtyService; |
| | | private readonly IPalletTypeInfoRepository _palletTypeInfoRepository; |
| | | private readonly IOutboundOrderDetailRepository _outboundOrderDetailRepository; |
| | | private readonly INewOutboundOrderDetailRepository _newOutboundOrderDetailRepository; |
| | | private readonly IStockInfoDetailRepository _stockInfoDetailRepository; |
| | | private readonly IStockInfoDetailCPRepository _stockInfoDetailCPRepository; |
| | | private readonly IReturnOrderRepository _returnOrderRepository; |
| | | private readonly IProductionRepository _productionRepository; |
| | | private readonly IInboundRepository _inboundRepository; |
| | | private readonly IInboundRepository _inboundRepository; |
| | | private readonly ITakeStockOrderCPRepository _takeStockOrderCPRepository; |
| | | private readonly ITakeStockOrderDetailCPRepository _takeStockOrderDetailCPRepository; |
| | | public ITaskRepository Repository => BaseDal; |
| | | |
| | | public TaskService(ITaskRepository BaseDal, IMapper mapper, IUnitOfWorkManage unitOfWorkManage, IMaterielInfoService materielInfoService, IInboundOrderDetail_HtyService inboundOrderDetail_HtyService, IOutboundOrder_HtyService outboundOrder_HtyService, IOutboundOrderDetail_HtyService outboundOrderDetail_HtyService, IInboundOrder_HtyService inboundOrder_HtyService, IStockRepository stockRepository, IInboundOrderDetailService inboundOrderDetailService, IBasicService basicService, IOutboundService outboundService, IInboundService inboundService, IRecordService recordService, IStockService stockService, ITask_HtyService taskHtyService, ILocationInfoService locationInfoService, IOutboundOrderDetailRepository outboundOrderDetailRepository, IBasicRepository basicRepository, IStockInfoDetailRepository stockInfoDetailRepository, IPalletTypeInfoRepository palletTypeInfoRepository, IReturnOrderRepository returnOrderRepository, IProductionRepository productionRepository,IInboundRepository inboundRepository) : base(BaseDal) |
| | | public TaskService(ITaskRepository BaseDal, IMapper mapper, IUnitOfWorkManage unitOfWorkManage, IMaterielInfoService materielInfoService, IInboundOrderDetail_HtyService inboundOrderDetail_HtyService, IOutboundOrder_HtyService outboundOrder_HtyService, IOutboundOrderDetail_HtyService outboundOrderDetail_HtyService, IInboundOrder_HtyService inboundOrder_HtyService, IStockRepository stockRepository, IInboundOrderDetailService inboundOrderDetailService, IBasicService basicService, IOutboundService outboundService, IInboundService inboundService, IRecordService recordService, IStockService stockService, ITask_HtyService taskHtyService, ILocationInfoService locationInfoService, IOutboundOrderDetailRepository outboundOrderDetailRepository, IBasicRepository basicRepository, IStockInfoDetailRepository stockInfoDetailRepository, IPalletTypeInfoRepository palletTypeInfoRepository, IReturnOrderRepository returnOrderRepository, IProductionRepository productionRepository, IInboundRepository inboundRepository, INewOutboundOrderDetailRepository newOutboundOrderDetailRepository, ITakeStockOrderCPRepository takeStockOrderCPRepository, ITakeStockOrderDetailCPRepository takeStockOrderDetailCPRepository, IStockInfoDetailCPRepository stockInfoDetailCPRepository) : base(BaseDal) |
| | | { |
| | | _mapper = mapper; |
| | | _stockRepository = stockRepository; |
| | |
| | | _returnOrderRepository = returnOrderRepository; |
| | | _productionRepository = productionRepository; |
| | | _inboundRepository = inboundRepository; |
| | | _newOutboundOrderDetailRepository = newOutboundOrderDetailRepository; |
| | | _takeStockOrderCPRepository = takeStockOrderCPRepository; |
| | | _takeStockOrderDetailCPRepository = takeStockOrderDetailCPRepository; |
| | | _stockInfoDetailCPRepository = stockInfoDetailCPRepository; |
| | | } |
| | | |
| | | public string ReceiveWMSTaskin = WIDESEA_Core.Helper.AppSettings.Configuration["ReceiveWMSTaskin"]; |
| | |
| | | public string ReceiveWMSTaskAllocatein = WIDESEA_Core.Helper.AppSettings.Configuration["ReceiveWMSTaskAllocatein"]; |
| | | public string ReceiveERPTaskout = WIDESEA_Core.Helper.AppSettings.Configuration["ReceiveERPTaskout"]; |
| | | public string InMaterialWarehousingCallback = WIDESEA_Core.Helper.AppSettings.Configuration["InMaterialWarehousingCallback"]; |
| | | |
| | | |
| | | /// <summary> |
| | | /// 任务信息推送至WCS |
| | |
| | | } |
| | | } |
| | | |
| | | public WebResponseContent PushTasksWCS(List<Dt_Task> tasks, string agvDescription = "") |
| | | { |
| | | try |
| | | { |
| | | List<WMSTaskDTO> taskDTOs = _mapper.Map<List<WMSTaskDTO>>(tasks); |
| | | taskDTOs.ForEach(x => |
| | | { |
| | | x.AGVArea = agvDescription; |
| | | }); |
| | | string url = AppSettings.app("WCS"); |
| | | if (string.IsNullOrEmpty(url)) |
| | | { |
| | | return WebResponseContent.Instance.Error($"未找到WCSApi地址,请检查配置文件"); |
| | | } |
| | | string response = HttpHelper.Post($"{url}/api/Task/ReceiveCPTask", taskDTOs.Serialize()); |
| | | |
| | | return JsonConvert.DeserializeObject<WebResponseContent>(response) ?? WebResponseContent.Instance.Error("返回错误"); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return WebResponseContent.Instance.Error(ex.Message); |
| | | } |
| | | } |
| | | |
| | | public WebResponseContent FeedBackWCSTaskCompleted(int taskNum) |
| | | { |
| | | try |
| | |
| | | { |
| | | return WebResponseContent.Instance.Error($"未找到WCSApi地址,请检查配置文件"); |
| | | } |
| | | string response = HttpHelper.Get($"{url}/api/Task/RecWMSTaskCompleted?taskNum=" + taskNum); |
| | | string response = HttpHelper.Post($"{url}/api/Task/RecWMSTaskCompleted?taskNum=" + taskNum); |
| | | |
| | | return JsonConvert.DeserializeObject<WebResponseContent>(response) ?? WebResponseContent.Instance.Error("返回错误"); |
| | | } |
| | |
| | | Dt_Warehouse warehouse = _basicService.WarehouseService.Repository.QueryFirst(x => x.WarehouseId == task.WarehouseId); |
| | | |
| | | dt_StockInfo.LocationCode = dt_LocationInfo.LocationCode; |
| | | |
| | | |
| | | Dt_InboundOrder? inboundOrder = _inboundService.InbounOrderService.Db.Queryable<Dt_InboundOrder>().Where(x => x.OrderNo == dt_StockInfo.Details.FirstOrDefault().OrderNo).Includes(x => x.Details).First(); |
| | | Dt_InboundOrderDetail? inboundOrderDetail = null; |
| | | |
| | | // 3. 处理入库逻辑 |
| | | if (task.TaskType == TaskTypeEnum.Inbound.ObjToInt()) |
| | | if (task.TaskType == TaskTypeEnum.InSyncretism.ObjToInt()) |
| | | { |
| | | return ProcessInbound(task, dt_StockInfo, dt_LocationInfo); |
| | | } |
| | | if (task.TaskType == TaskTypeEnum.SurplusReturn.ObjToInt() || task.TaskType == TaskTypeEnum.ReverseIn.ObjToInt()) |
| | | { |
| | | return ReturnInbound(task, dt_StockInfo, dt_LocationInfo); |
| | | } |
| | | if(task.TaskType == TaskTypeEnum.InInventory.ObjToInt()) |
| | | { |
| | | int lastStatus = dt_LocationInfo.LocationStatus; |
| | | int laststatus = dt_LocationInfo.LocationStatus; |
| | | dt_LocationInfo.LocationStatus = LocationStatusEnum.InStock.ObjToInt(); |
| | | ///更新库存状态 |
| | | dt_StockInfo.StockStatus = StockStatusEmun.入库完成.ObjToInt(); |
| | | // 更新库存明细状态 |
| | | dt_StockInfo.Details.ForEach(x => x.Status = StockStatusEmun.入库完成.ObjToInt()); |
| | | _unitOfWorkManage.BeginTran(); |
| | | UpdateTaskStatus(task); |
| | | UpdateLocationStatus(dt_LocationInfo, lastStatus); |
| | | UpdateStockInfo(dt_StockInfo); |
| | | AddRecords(task, dt_StockInfo, dt_LocationInfo, lastStatus); |
| | | _unitOfWorkManage.CommitTran(); |
| | | return WebResponseContent.Instance.OK(); |
| | | |
| | | _unitOfWorkManage.BeginTran(); |
| | | |
| | | // 更新任务状态 |
| | | UpdateTaskStatus(task); |
| | | |
| | | // 更新货位状态 |
| | | UpdateLocationStatus(dt_LocationInfo, laststatus); |
| | | |
| | | // 更新库存信息 |
| | | UpdateStockInfo(dt_StockInfo); |
| | | |
| | | AddRecords(task, dt_StockInfo, dt_LocationInfo, laststatus); |
| | | |
| | | //返回smom库存移动数据。。。。 |
| | | |
| | | _unitOfWorkManage.CommitTran(); |
| | | } |
| | | else |
| | | { |
| | | if (warehouse.WarehouseCode.Contains("CP")) |
| | | { |
| | | |
| | | if (task.TaskType == TaskTypeEnum.SurplusReturn.ObjToInt() || task.TaskType == TaskTypeEnum.ReverseIn.ObjToInt()) |
| | | { |
| | | int lastStatus = dt_LocationInfo.LocationStatus; |
| | | dt_LocationInfo.LocationStatus = LocationStatusEnum.InStock.ObjToInt(); |
| | | Dt_ReturnOrder returnOrder = _returnOrderRepository.QueryFirst(x => x.LPNNo == dt_StockInfo.PalletCode); |
| | | if (returnOrder == null) |
| | | { |
| | | return WebResponseContent.Instance.Error("未找到回库单信息"); |
| | | } |
| | | return SurplusReturnInbound(task, dt_StockInfo, dt_LocationInfo, lastStatus, returnOrder); |
| | | } |
| | | // 1. 获取入库单信息 |
| | | Dt_InboundOrder? inboundOrder = null; |
| | | if (!string.IsNullOrEmpty(dt_StockInfo.Details.FirstOrDefault()?.OrderNo)) |
| | | { |
| | | inboundOrder = _inboundService.InbounOrderService.Db.Queryable<Dt_InboundOrder>() |
| | | .Where(x => x.OrderNo == dt_StockInfo.Details.FirstOrDefault().OrderNo) |
| | | .Includes(x => x.Details) |
| | | .First(); |
| | | } |
| | | |
| | | // 3. 处理入库逻辑 |
| | | if (task.TaskType == TaskTypeEnum.Inbound.ObjToInt()) |
| | | { |
| | | int lastStatus = dt_LocationInfo.LocationStatus; |
| | | dt_LocationInfo.LocationStatus = LocationStatusEnum.InStock.ObjToInt(); |
| | | |
| | | if (task.TaskType == TaskTypeEnum.Inbound.ObjToInt() && inboundOrder == null) |
| | | { |
| | | return WebResponseContent.Instance.Error("未找到入库单信息"); |
| | | } |
| | | var allBoxCodesForDetail = BaseDal.Db.Queryable<Dt_StockInfoDetailCP>() |
| | | .Where(x => dt_StockInfo.Details.Select(d => d.Id).Contains(x.StockDetailId)) |
| | | .Select(x => x.BoxCode) |
| | | .ToList(); |
| | | |
| | | // 2. 获取托盘下的所有箱号 |
| | | var boxCodes = new List<string>(); |
| | | |
| | | // 方法1:从库存明细的BoxCodes字段获取(组盘时保存的) |
| | | foreach (var detail in allBoxCodesForDetail) |
| | | { |
| | | if (!string.IsNullOrEmpty(detail)) |
| | | { |
| | | var codes = detail.Split(',', StringSplitOptions.RemoveEmptyEntries); |
| | | boxCodes.AddRange(codes); |
| | | } |
| | | } |
| | | |
| | | // 根据托盘明细获取对应的入库单明细 |
| | | List<Dt_InboundOrderDetail> inboundOrderDetails = new List<Dt_InboundOrderDetail>(); |
| | | |
| | | // 处理多个库存明细的情况 |
| | | foreach (var stockDetail in dt_StockInfo.Details) |
| | | { |
| | | if (!string.IsNullOrEmpty(stockDetail.OrderNo)) |
| | | { |
| | | var detail = inboundOrder.Details.FirstOrDefault(x => x.LinId == stockDetail.LinId && x.BatchNo == stockDetail.BatchNo); |
| | | |
| | | if (detail != null && !inboundOrderDetails.Any(x => x.Id == detail.Id)) |
| | | { |
| | | inboundOrderDetails.Add(detail); |
| | | } |
| | | } |
| | | } |
| | | |
| | | if (!inboundOrderDetails.Any()) |
| | | { |
| | | return WebResponseContent.Instance.Error($"未找到对应的入库单明细"); |
| | | } |
| | | |
| | | // 更新入库单明细状态 |
| | | foreach (var inboundOrderDetail in inboundOrderDetails) |
| | | { |
| | | // 检查该明细是否已全部入库 |
| | | decimal totalStockQuantity = dt_StockInfo.Details |
| | | .Where(x => x.LinId == inboundOrderDetail.LinId && x.BatchNo == inboundOrderDetail.BatchNo) |
| | | .Sum(x => x.StockQuantity); |
| | | |
| | | decimal orderQuantity = Convert.ToDecimal(inboundOrderDetail.OrderQuantity); |
| | | decimal receiptQuantity = Convert.ToDecimal(inboundOrderDetail.ReceiptQuantity); |
| | | decimal overInQuantity = Convert.ToDecimal(inboundOrderDetail.OverInQuantity); |
| | | |
| | | // 更新收货数量 |
| | | inboundOrderDetail.OverInQuantity = totalStockQuantity += overInQuantity; |
| | | |
| | | // 检查是否全部完成 |
| | | if (inboundOrderDetail.OverInQuantity == inboundOrderDetail.OrderQuantity) |
| | | { |
| | | inboundOrderDetail.OrderDetailStatus = OrderDetailStatusEnum.Over.ObjToInt(); |
| | | } |
| | | else |
| | | { |
| | | inboundOrderDetail.OrderDetailStatus = OrderDetailStatusEnum.Inbounding.ObjToInt(); |
| | | } |
| | | } |
| | | |
| | | ///更新库存状态 |
| | | dt_StockInfo.StockStatus = StockStatusEmun.入库完成.ObjToInt(); |
| | | // 更新库存明细状态 |
| | | dt_StockInfo.Details.ForEach(x => x.Status = StockStatusEmun.入库完成.ObjToInt()); |
| | | |
| | | // 3. 查询成品入库明细(CP入库单明细) |
| | | List<Dt_CPInboundOrderDetail> cpInboundDetails = new List<Dt_CPInboundOrderDetail>(); |
| | | if (boxCodes.Any()) |
| | | { |
| | | cpInboundDetails = BaseDal.Db.Queryable<Dt_CPInboundOrderDetail>() |
| | | .Where(x => boxCodes.Contains(x.BoxCode)) |
| | | .ToList(); |
| | | } |
| | | |
| | | |
| | | // 4. 查询并更新成品库存明细(如果有单独的成品库存表) |
| | | List<Dt_StockInfoDetailCP> cpStockDetails = new List<Dt_StockInfoDetailCP>(); |
| | | if (boxCodes.Any()) |
| | | { |
| | | cpStockDetails = BaseDal.Db.Queryable<Dt_StockInfoDetailCP>() |
| | | .Where(x => boxCodes.Contains(x.BoxCode)) |
| | | .ToList(); |
| | | |
| | | // 更新成品库存明细状态 |
| | | foreach (var cpStockDetail in cpStockDetails) |
| | | { |
| | | cpStockDetail.CPStockDetailStatus = StockStatusEmun.入库完成.ObjToInt(); |
| | | } |
| | | } |
| | | |
| | | try |
| | | { |
| | | _unitOfWorkManage.BeginTran(); |
| | | |
| | | // 更新任务状态 |
| | | UpdateTaskStatus(task); |
| | | |
| | | // 更新货位状态 |
| | | UpdateLocationStatus(dt_LocationInfo, lastStatus); |
| | | |
| | | // 更新库存信息 |
| | | UpdateStockInfo(dt_StockInfo); |
| | | |
| | | // 添加记录 |
| | | AddRecords(task, dt_StockInfo, dt_LocationInfo, lastStatus); |
| | | |
| | | // 更新入库单明细 |
| | | if (inboundOrderDetails.Any()) |
| | | { |
| | | BaseDal.Db.Updateable(inboundOrderDetails).ExecuteCommand(); |
| | | |
| | | // 检查入库单是否全部完成 |
| | | bool allCompleted = inboundOrder.Details.All(x => |
| | | x.OrderDetailStatus == OrderDetailStatusEnum.Over.ObjToInt()); |
| | | |
| | | if (allCompleted) |
| | | { |
| | | inboundOrder.OrderStatus = InboundStatusEnum.入库完成.ObjToInt(); |
| | | foreach (var item in inboundOrderDetails) |
| | | { |
| | | BaseDal.Db.Deleteable(item.CPDetails).ExecuteCommand(); |
| | | } |
| | | } |
| | | else |
| | | { |
| | | inboundOrder.OrderStatus = InboundStatusEnum.入库中.ObjToInt(); |
| | | } |
| | | } |
| | | |
| | | // 更新入库单 |
| | | UpdateInboundOrder(inboundOrder, inboundOrderDetails.FirstOrDefault()); |
| | | |
| | | // 更新成品入库明细状态 |
| | | if (cpInboundDetails.Any()) |
| | | { |
| | | BaseDal.Db.Deleteable(cpInboundDetails).ExecuteCommand(); |
| | | } |
| | | |
| | | // 更新成品库存明细状态 |
| | | if (cpStockDetails.Any()) |
| | | { |
| | | BaseDal.Db.Updateable(cpStockDetails).ExecuteCommand(); |
| | | } |
| | | |
| | | // 单据数量全部上架完成,处理WMS回传 |
| | | if (inboundOrderDetails.Any(x => x.OrderDetailStatus == OrderDetailStatusEnum.Over.ObjToInt()) && inboundOrder.System.Equals("ERP")) |
| | | { |
| | | foreach (var detail in inboundOrderDetails.Where(x => x.OrderDetailStatus == OrderDetailStatusEnum.Over.ObjToInt())) |
| | | { |
| | | FeedBackInboundERP(inboundOrder.UpperOrderNo, detail.LinId); |
| | | } |
| | | } |
| | | if (inboundOrder.OrderStatus == InboundStatusEnum.入库完成.ObjToInt() && inboundOrder.OrderType == 0 && inboundOrder.System.Equals("SMOM")) |
| | | { |
| | | |
| | | List<Dt_StockInfo> StockInfos = _stockRepository.StockInfoRepository.Db |
| | | .Queryable<Dt_StockInfo>() |
| | | .Includes(x => x.Details, d => d.StockDetails) |
| | | .Where(x => x.WarehouseId == task.WarehouseId && |
| | | x.Details.Any(v => v.OrderNo == inboundOrder.OrderNo)) |
| | | .ToList(); |
| | | |
| | | if (StockInfos.Count == 0) throw new Exception("未找到库存信息"); |
| | | var houseInboundPassBack = new HouseInboundPassBack |
| | | { |
| | | ApiType = "AsnController", |
| | | Method = "AsrsGroudingAsn", |
| | | Parameters = new List<HouseInboundPassBack.data> |
| | | { |
| | | new HouseInboundPassBack.data |
| | | { |
| | | Value = new List<data.data1> |
| | | { |
| | | new data.data1 |
| | | { |
| | | AsnNo = inboundOrder.OrderNo, |
| | | //InWarehouse = task.Roadway, |
| | | TransactionCode = inboundOrder.TransactionCode, |
| | | InoutType = inboundOrder.OrderType, |
| | | OrderType = inboundOrder.InoutType, |
| | | // 遍历所有库存明细,添加到 DetailList |
| | | DetailList = StockInfos |
| | | .SelectMany(pallet => pallet.Details, (pallet, detail) => new { Pallet = pallet, Detail = detail }) |
| | | .GroupBy(x => new |
| | | { |
| | | x.Pallet.PalletCode, |
| | | x.Detail.MaterielCode, |
| | | x.Detail.BatchNo, |
| | | x.Detail.LinId |
| | | }) |
| | | .Select(g => new data.data1.Inbound |
| | | { |
| | | LinId = g.Key.LinId ?? "", |
| | | MaterielCode = g.Key.MaterielCode ?? "", |
| | | OrderQuantity = g.Sum(x => x.Detail.StockQuantity), |
| | | BatchNo = g.Key.BatchNo, |
| | | LPNNo = g.Key.PalletCode, |
| | | FinishQty = g.Sum(x => x.Detail.StockQuantity), |
| | | LocationName = g.First().Pallet.LocationCode, |
| | | LabelList = g.SelectMany(x => x.Detail.StockDetails ?? new List<Dt_StockInfoDetailCP>()) |
| | | .Where(sd => !string.IsNullOrEmpty(sd?.BoxCode)) |
| | | .Select(sd => sd.BoxCode) |
| | | .Distinct() |
| | | .ToList() |
| | | }) |
| | | .ToList() |
| | | } |
| | | } |
| | | } |
| | | } |
| | | }; |
| | | |
| | | var authResult = AuthenticateWithWMS(); |
| | | if (authResult.IsSuccess) |
| | | { |
| | | houseInboundPassBack.Context = new Dictionary<string, string> |
| | | { |
| | | { "Ticket", authResult.Ticket }, |
| | | { "InvOrgId", authResult.InvOrgId } |
| | | }; |
| | | |
| | | var response = HttpHelper.Post<MomRequestContent>(ReceiveWMSTaskin, houseInboundPassBack, "立库入库数量回传WMS"); |
| | | // 判断Success的值 |
| | | if (!response.Success) |
| | | { |
| | | WriteLog.Write_Log("API", "SMOM立库回传给WMS", "请求失败", new { 请求报文 = houseInboundPassBack, 接收报文 = response }); |
| | | throw new Exception($"操作失败: {response.Message ?? "未提供错误信息"}"); |
| | | } |
| | | WriteLog.Write_Log("API", "SMOM立库入库回传WMS", "请求成功", new { 请求报文 = houseInboundPassBack, 接收报文 = response }); |
| | | } |
| | | |
| | | } |
| | | else if (inboundOrder.OrderStatus == InboundStatusEnum.入库完成.ObjToInt() && inboundOrder.OrderType == 2 && inboundOrder.System.Equals("SMOM")) |
| | | { |
| | | List<Dt_StockInfo> StockInfos = _stockRepository.StockInfoRepository.Db |
| | | .Queryable<Dt_StockInfo>() |
| | | .Includes(x => x.Details, d => d.StockDetails) |
| | | .Where(x => x.WarehouseId == task.WarehouseId && |
| | | x.Details.Any(v => v.OrderNo == inboundOrder.OrderNo)) |
| | | .ToList(); |
| | | if (StockInfos.Count == 0) throw new Exception("未找到库存信息"); |
| | | var inventoryAllocate = new InventoryAllocate |
| | | { |
| | | ApiType = "InventoryAllocateController", |
| | | Method = "AsrsFinishedStockCount", |
| | | Parameters = new List<InventoryAllocate.Allocate> |
| | | { |
| | | new InventoryAllocate.Allocate |
| | | { |
| | | Value = new List<Allocate.data1> |
| | | { |
| | | new Allocate.data1 |
| | | { |
| | | No = inboundOrder.OrderNo, |
| | | //InWarehouse = task.Roadway, |
| | | TransactionCode = inboundOrder.TransactionCode, |
| | | InoutType = inboundOrder.OrderType, |
| | | OrderType = inboundOrder.InoutType, |
| | | ActiveType=1, |
| | | |
| | | DetailList = StockInfos |
| | | .SelectMany(pallet => pallet.Details, (pallet, detail) => new { Pallet = pallet, Detail = detail }) |
| | | .GroupBy(x => new |
| | | { |
| | | x.Pallet.PalletCode, |
| | | x.Detail.MaterielCode, |
| | | x.Detail.BatchNo, |
| | | x.Detail.LinId |
| | | }) |
| | | .Select(g => new Allocate.data1.Inventory |
| | | { |
| | | LinId = g.Key.LinId ?? "", |
| | | MaterielCode = g.Key.MaterielCode ?? "", |
| | | OrderQuantity = g.Sum(x => x.Detail.StockQuantity), |
| | | BatchNo = g.Key.BatchNo, |
| | | LPNNo = g.Key.PalletCode, |
| | | FinishQty = g.Sum(x => x.Detail.StockQuantity), |
| | | LocationName = g.First().Pallet.LocationCode, |
| | | OrinalLocation = g.First().Detail?.OrinalLocation, |
| | | LabelList = g.SelectMany(x => x.Detail.StockDetails ?? new List<Dt_StockInfoDetailCP>()) |
| | | .Where(sd => !string.IsNullOrEmpty(sd?.BoxCode)) |
| | | .Select(sd => sd.BoxCode) |
| | | .Distinct() |
| | | .ToList() |
| | | }) |
| | | .ToList() |
| | | } |
| | | } |
| | | } |
| | | } |
| | | }; |
| | | |
| | | var authResult = AuthenticateWithWMS(); |
| | | if (authResult.IsSuccess) |
| | | { |
| | | inventoryAllocate.Context = new Dictionary<string, string> |
| | | { |
| | | { "Ticket", authResult.Ticket }, |
| | | { "InvOrgId", authResult.InvOrgId } |
| | | }; |
| | | |
| | | var response = HttpHelper.Post<MomRequestContent>(ReceiveWMSTaskAllocatein, inventoryAllocate, "调拨入库数量回传WMS"); |
| | | if (!response.Success) |
| | | { |
| | | WriteLog.Write_Log("API", "SMOM调拨入库数量回传WMS", "请求失败", new { 请求报文 = inventoryAllocate, 接收报文 = response }); |
| | | throw new Exception($"操作失败:{response.Message ?? "未提供错误信息"}"); |
| | | } |
| | | WriteLog.Write_Log("API", "SMOM调拨入库数量回传WMS", "请求成功", new { 请求报文 = inventoryAllocate, 接收报文 = response }); |
| | | |
| | | } |
| | | } |
| | | else if (inboundOrder.OrderStatus == InboundStatusEnum.入库完成.ObjToInt() && inboundOrder.OrderType == 5 && inboundOrder.System.Equals("SMOM")) |
| | | { |
| | | |
| | | List<Dt_StockInfo> StockInfos = _stockRepository.StockInfoRepository.Db |
| | | .Queryable<Dt_StockInfo>() |
| | | .Includes(x => x.Details, d => d.StockDetails) |
| | | .Where(x => x.WarehouseId == task.WarehouseId && |
| | | x.Details.Any(v => v.OrderNo == inboundOrder.OrderNo)) |
| | | .ToList(); |
| | | |
| | | Dt_InboundOrder? dt_InboundOrder = _inboundService.InbounOrderService.Db.Queryable<Dt_InboundOrder>().Where(x => x.OrderNo == inboundOrder.OrderNo).Includes(x => x.Details).First(); |
| | | if (StockInfos.Count == 0) throw new Exception("未找到库存信息"); |
| | | |
| | | var houseSyncretism = new NewHouseInboundPassBack |
| | | { |
| | | ApiType = "InventoryMoveController", |
| | | Method = "AsrsUnPickingDatas", |
| | | Parameters = new List<NewHouseInboundPassBack.Parame> |
| | | { |
| | | new NewHouseInboundPassBack.Parame |
| | | { |
| | | |
| | | Value = new Parame.Syncretism |
| | | { |
| | | OrderNo = inboundOrder.OrderNo, |
| | | Details = StockInfos.SelectMany(stockInfo => |
| | | stockInfo.Details.Select(g => |
| | | { |
| | | //var InboundOrderde1=dt_InboundOrder.Details.FirstOrDefault; |
| | | |
| | | return new Parame.Syncretism.details |
| | | { |
| | | MoveType = 0, |
| | | WareHouseCode = warehouse.WarehouseCode, |
| | | ItemCode = g.MaterielCode, |
| | | MoveNumber = g.StockQuantity, |
| | | LotNo = g.BatchNo, |
| | | WipBatch = g.BatchNo, |
| | | Lpn = g.StockDetails.FirstOrDefault().LPNNO, |
| | | LocationName = g.StockDetails.FirstOrDefault().OrinalLocation, |
| | | TargetLocName = stockInfo.LocationCode, // 添加null检查 |
| | | TargetLpn = stockInfo.PalletCode, // 添加null检查 |
| | | }; |
| | | })).ToList() |
| | | } |
| | | } |
| | | } |
| | | }; |
| | | |
| | | var authResult = AuthenticateWithWMS(); |
| | | if (authResult.IsSuccess) |
| | | { |
| | | houseSyncretism.Context = new Dictionary<string, string> |
| | | { |
| | | { "Ticket", authResult.Ticket }, |
| | | { "InvOrgId", authResult.InvOrgId } |
| | | |
| | | }; |
| | | |
| | | var response = HttpHelper.Post<MomRequestContent>(ReceiveWMSTaskin, houseSyncretism, "立库入库数量回传WMS"); |
| | | if (!response.Success) |
| | | { |
| | | WriteLog.Write_Log("API", "SMOM立库入库数量回传WMS", "请求失败", new { 请求报文 = houseSyncretism, 接收报文 = response }); |
| | | throw new Exception($"操作失败: {response.Message ?? "未提供错误信息"}"); |
| | | } |
| | | WriteLog.Write_Log("API", "SMOM立库入库数量回传WMS", "请求成功", new { 请求报文 = houseSyncretism, 接收报文 = response }); |
| | | |
| | | } |
| | | |
| | | } |
| | | _unitOfWorkManage.CommitTran(); |
| | | return WebResponseContent.Instance.OK(); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | _unitOfWorkManage.RollbackTran(); |
| | | throw new Exception($"入库处理失败:{ex.Message}", ex); |
| | | } |
| | | } |
| | | } |
| | | else if (warehouse.WarehouseCode.Contains("DW") || warehouse.WarehouseCode.Contains("YS")) |
| | | { |
| | | Dt_InboundOrder? inboundOrder = _inboundService.InbounOrderService.Db.Queryable<Dt_InboundOrder>().Where(x => x.OrderNo == dt_StockInfo.Details.FirstOrDefault().OrderNo).Includes(x => x.Details).First(); |
| | | //Dt_InboundOrderDetail? inboundOrderDetail = null; |
| | | //出库入库逻辑 |
| | | if (task.TaskType == TaskTypeEnum.Inbound.ObjToInt()) |
| | | { |
| | | int lastStatus = dt_LocationInfo.LocationStatus; |
| | | dt_LocationInfo.LocationStatus = LocationStatusEnum.InStock.ObjToInt(); |
| | | // 根据托盘明细获取对应的入库单明细 |
| | | List<Dt_InboundOrderDetail> inboundOrderDetails = new List<Dt_InboundOrderDetail>(); |
| | | |
| | | // 处理多个库存明细的情况 |
| | | foreach (var stockDetail in dt_StockInfo.Details) |
| | | { |
| | | if (!string.IsNullOrEmpty(stockDetail.OrderNo)) |
| | | { |
| | | var detail = inboundOrder.Details.FirstOrDefault(x => x.LinId == stockDetail.LinId && x.BatchNo == stockDetail.BatchNo); |
| | | |
| | | if (detail != null && !inboundOrderDetails.Any(x => x.Id == detail.Id)) |
| | | { |
| | | inboundOrderDetails.Add(detail); |
| | | } |
| | | } |
| | | } |
| | | if (!inboundOrderDetails.Any()) |
| | | { |
| | | return WebResponseContent.Instance.Error($"未找到对应的入库单明细"); |
| | | } |
| | | // 更新入库单明细状态 |
| | | foreach (var inboundOrderDetail in inboundOrderDetails) |
| | | { |
| | | // 检查该明细是否已全部入库 |
| | | decimal totalStockQuantity = dt_StockInfo.Details |
| | | .Where(x => x.LinId == inboundOrderDetail.LinId && x.BatchNo == inboundOrderDetail.BatchNo) |
| | | .Sum(x => x.StockQuantity); |
| | | |
| | | decimal orderQuantity = Convert.ToDecimal(inboundOrderDetail.OrderQuantity); |
| | | decimal receiptQuantity = Convert.ToDecimal(inboundOrderDetail.ReceiptQuantity); |
| | | decimal overInQuantity = Convert.ToDecimal(inboundOrderDetail.OverInQuantity); |
| | | |
| | | // 更新收货数量 |
| | | inboundOrderDetail.OverInQuantity = totalStockQuantity += overInQuantity; |
| | | |
| | | // 检查是否全部完成 |
| | | if (inboundOrderDetail.OverInQuantity == inboundOrderDetail.OrderQuantity) |
| | | { |
| | | inboundOrderDetail.OrderDetailStatus = OrderDetailStatusEnum.Over.ObjToInt(); |
| | | } |
| | | else |
| | | { |
| | | inboundOrderDetail.OrderDetailStatus = OrderDetailStatusEnum.Inbounding.ObjToInt(); |
| | | } |
| | | } |
| | | ///更新库存状态 |
| | | dt_StockInfo.StockStatus = StockStatusEmun.入库完成.ObjToInt(); |
| | | // 更新库存明细状态 |
| | | dt_StockInfo.Details.ForEach(x => x.Status = StockStatusEmun.入库完成.ObjToInt()); |
| | | try |
| | | { |
| | | _unitOfWorkManage.BeginTran(); |
| | | |
| | | // 更新任务状态 |
| | | UpdateTaskStatus(task); |
| | | |
| | | // 更新货位状态 |
| | | UpdateLocationStatus(dt_LocationInfo, lastStatus); |
| | | |
| | | // 更新库存信息 |
| | | UpdateStockInfo(dt_StockInfo); |
| | | |
| | | // 添加记录 |
| | | AddRecords(task, dt_StockInfo, dt_LocationInfo, lastStatus); |
| | | |
| | | // 更新入库单明细 |
| | | if (inboundOrderDetails.Any()) |
| | | { |
| | | BaseDal.Db.Updateable(inboundOrderDetails).ExecuteCommand(); |
| | | |
| | | // 检查入库单是否全部完成 |
| | | bool allCompleted = inboundOrder.Details.All(x => |
| | | x.OrderDetailStatus == OrderDetailStatusEnum.Over.ObjToInt()); |
| | | |
| | | if (allCompleted) |
| | | { |
| | | inboundOrder.OrderStatus = InboundStatusEnum.入库完成.ObjToInt(); |
| | | } |
| | | else |
| | | { |
| | | inboundOrder.OrderStatus = InboundStatusEnum.入库中.ObjToInt(); |
| | | } |
| | | } |
| | | |
| | | // 更新入库单 |
| | | UpdateInboundOrder(inboundOrder, inboundOrderDetails.FirstOrDefault()); |
| | | |
| | | // 单据数量全部上架完成,处理WMS回传 |
| | | if (inboundOrderDetails.Any(x => x.OrderDetailStatus == OrderDetailStatusEnum.Over.ObjToInt()) && inboundOrder.System.Equals("ERP")) |
| | | { |
| | | if (inboundOrder.OrderStatus == InboundStatusEnum.入库完成.ObjToInt()) |
| | | { |
| | | bool allCompleted = inboundOrder.Details.All(x => x.OrderDetailStatus == OrderDetailStatusEnum.Over.ObjToInt()); |
| | | if (allCompleted) |
| | | { |
| | | foreach (var detail in inboundOrder.Details) |
| | | { |
| | | FeedBackInboundERP(inboundOrder.UpperOrderNo, detail.LinId); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | if (inboundOrder.OrderStatus == InboundStatusEnum.入库完成.ObjToInt() && inboundOrder.OrderType == 0 && inboundOrder.System.Equals("SMOM")) |
| | | { |
| | | //SendInboundInfoToWMS(task, inboundOrder, stockInfo); |
| | | SendInboundInfoToWMS(task, inboundOrder, dt_StockInfo); |
| | | |
| | | } |
| | | else if (inboundOrder.OrderStatus == InboundStatusEnum.入库完成.ObjToInt() && inboundOrder.OrderType == 2 && inboundOrder.System.Equals("SMOM")) |
| | | { |
| | | SendAllocateInfoToWMS(task, inboundOrder, dt_StockInfo); |
| | | } |
| | | |
| | | _unitOfWorkManage.CommitTran(); |
| | | return WebResponseContent.Instance.OK(); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | _unitOfWorkManage.RollbackTran(); |
| | | throw new Exception($"入库处理失败:{ex.Message}", ex); |
| | | } |
| | | |
| | | } |
| | | if (task.TaskType == TaskTypeEnum.SurplusReturn.ObjToInt() || task.TaskType == TaskTypeEnum.ReverseIn.ObjToInt()) |
| | | { |
| | | return ReturnInbound(task, dt_StockInfo, dt_LocationInfo); |
| | | } |
| | | if (task.TaskType == TaskTypeEnum.InInventory.ObjToInt()) |
| | | { |
| | | int lastStatus = dt_LocationInfo.LocationStatus; |
| | | dt_LocationInfo.LocationStatus = LocationStatusEnum.InStock.ObjToInt(); |
| | | dt_StockInfo.StockStatus = StockStatusEmun.入库完成.ObjToInt(); |
| | | // 更新库存明细状态 |
| | | dt_StockInfo.Details.ForEach(x => x.Status = StockStatusEmun.入库完成.ObjToInt()); |
| | | _unitOfWorkManage.BeginTran(); |
| | | UpdateTaskStatus(task); |
| | | UpdateLocationStatus(dt_LocationInfo, lastStatus); |
| | | UpdateStockInfo(dt_StockInfo); |
| | | AddRecords(task, dt_StockInfo, dt_LocationInfo, lastStatus); |
| | | _unitOfWorkManage.CommitTran(); |
| | | return WebResponseContent.Instance.OK(); |
| | | |
| | | } |
| | | |
| | | } |
| | | else |
| | | { |
| | | Dt_InboundOrder? inboundOrder = _inboundService.InbounOrderService.Db.Queryable<Dt_InboundOrder>().Where(x => x.OrderNo == dt_StockInfo.Details.FirstOrDefault().OrderNo).Includes(x => x.Details).First(); |
| | | Dt_InboundOrderDetail? inboundOrderDetail = null; |
| | | |
| | | // 3. 处理入库逻辑 |
| | | if (task.TaskType == TaskTypeEnum.Inbound.ObjToInt()) |
| | | { |
| | | return ProcessInbound(task, dt_StockInfo, dt_LocationInfo); |
| | | } |
| | | if (task.TaskType == TaskTypeEnum.SurplusReturn.ObjToInt() || task.TaskType == TaskTypeEnum.ReverseIn.ObjToInt()) |
| | | { |
| | | return ReturnInbound(task, dt_StockInfo, dt_LocationInfo); |
| | | } |
| | | if (task.TaskType == TaskTypeEnum.InInventory.ObjToInt()) |
| | | { |
| | | int lastStatus = dt_LocationInfo.LocationStatus; |
| | | dt_LocationInfo.LocationStatus = LocationStatusEnum.InStock.ObjToInt(); |
| | | dt_StockInfo.StockStatus = StockStatusEmun.入库完成.ObjToInt(); |
| | | // 更新库存明细状态 |
| | | dt_StockInfo.Details.ForEach(x => x.Status = StockStatusEmun.入库完成.ObjToInt()); |
| | | _unitOfWorkManage.BeginTran(); |
| | | UpdateTaskStatus(task); |
| | | UpdateLocationStatus(dt_LocationInfo, lastStatus); |
| | | UpdateStockInfo(dt_StockInfo); |
| | | AddRecords(task, dt_StockInfo, dt_LocationInfo, lastStatus); |
| | | _unitOfWorkManage.CommitTran(); |
| | | return WebResponseContent.Instance.OK(); |
| | | |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | return WebResponseContent.Instance.OK(); |
| | | } |
| | | catch (Exception ex) |
| | |
| | | |
| | | _recordService.StockQuantityChangeRecordService.AddStockChangeRecord( |
| | | stockInfo, stockInfo.Details, |
| | | stockInfo.Details.Sum(x => x.StockQuantity), |
| | | 0, |
| | | stockInfo.Details.Sum(x => x.StockQuantity), |
| | | StockChangeType.Inbound, task.TaskNum); |
| | | } |
| | |
| | | // 判断Success的值 |
| | | if (response.Success) |
| | | { |
| | | WriteLog.Write_Log("API", "SMOM立库入库回传WMS", "请求成功", new { 请求报文 = houseInboundPassBack, 接收报文 = response }); |
| | | // 如果Success为true,返回需要的值(这里以返回整个响应对象为例) |
| | | return WebResponseContent.Instance.OK(); |
| | | } |
| | | else |
| | | { |
| | | WriteLog.Write_Log("API", "SMOM立库入库回传WMS", "请求失败", new { 请求报文 = houseInboundPassBack, 接收报文 = response }); |
| | | // 如果Success为false,抛出异常并包含错误信息 |
| | | throw new Exception($"操作失败: {response.Message ?? "未提供错误信息"}"); |
| | | } |
| | |
| | | Parameters = new List<HouseBackboundPassBack.backdata> |
| | | { |
| | | new HouseBackboundPassBack.backdata |
| | | { |
| | | { |
| | | Value= new List<backdata.backdata1> |
| | | { |
| | | { |
| | | new backdata.backdata1 |
| | | { |
| | | OrderType = returnOrder.OrderType, |
| | |
| | | WarehouseCode = returnOrder.WarehouseCode, |
| | | System = returnOrder.System, |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | }; |
| | | var authResult = AuthenticateWithWMS(); |
| | |
| | | // 判断Success的值 |
| | | if (response.Success) |
| | | { |
| | | WriteLog.Write_Log("API", "取消发货后立库反拣入库回传WMS", "请求成功", new { 请求报文 = houseReturnOrders, 接收报文 = response }); |
| | | |
| | | // 如果Success为true,返回需要的值(这里以返回整个响应对象为例) |
| | | return WebResponseContent.Instance.OK(); |
| | | |
| | | } |
| | | else |
| | | { |
| | | WriteLog.Write_Log("API", "取消发货后立库反拣入库回传WMS", "请求失败", new { 请求报文 = houseReturnOrders, 接收报文 = response }); |
| | | |
| | | // 如果Success为false,抛出异常并包含错误信息 |
| | | throw new Exception($"操作失败: {response.Message ?? "未提供错误信息"}"); |
| | | } |
| | | |
| | | |
| | | } |
| | | return WebResponseContent.Instance.OK(); |
| | | } |
| | |
| | | ApiType = "InventoryAllocateController", |
| | | Method = "AsrsFinishedStockCount", |
| | | Parameters = new List<InventoryAllocate.Allocate> |
| | | { |
| | | new InventoryAllocate.Allocate |
| | | { |
| | | Value = new List<Allocate.data1> |
| | | { |
| | | new Allocate.data1 |
| | | { |
| | | No = inboundOrder.OrderNo, |
| | | //InWarehouse = task.Roadway, |
| | | TransactionCode = inboundOrder.TransactionCode, |
| | | InoutType = inboundOrder.OrderType, |
| | | OrderType = inboundOrder.InoutType, |
| | | // 遍历所有库存明细,添加到 DetailList |
| | | DetailList = StockInfos.Select(d => new Allocate.data1.Inventory |
| | | new InventoryAllocate.Allocate |
| | | { |
| | | LinId = d.Details.FirstOrDefault()?.LinId?? "", |
| | | MaterielCode = d.Details.FirstOrDefault()?.MaterielCode?? "", |
| | | OrderQuantity = d.Details.FirstOrDefault().StockQuantity, |
| | | BatchNo = d.BatchNo, |
| | | LPN_No = d.PalletCode, |
| | | FinishQty = d.Details.FirstOrDefault().StockQuantity, |
| | | LocationName = d.LocationCode |
| | | }).ToList() |
| | | Value = new List<Allocate.data1> |
| | | { |
| | | new Allocate.data1 |
| | | { |
| | | No = inboundOrder.OrderNo, |
| | | //InWarehouse = task.Roadway, |
| | | TransactionCode = inboundOrder.TransactionCode, |
| | | InoutType = inboundOrder.OrderType, |
| | | OrderType = inboundOrder.InoutType, |
| | | // 遍历所有库存明细,添加到 DetailList |
| | | DetailList = StockInfos.Select(d => new Allocate.data1.Inventory |
| | | { |
| | | LinId = d.Details.FirstOrDefault()?.LinId?? "", |
| | | MaterielCode = d.Details.FirstOrDefault()?.MaterielCode?? "", |
| | | OrderQuantity = d.Details.FirstOrDefault().StockQuantity, |
| | | BatchNo = d.BatchNo, |
| | | LPNNo = d.PalletCode, |
| | | FinishQty = d.Details.FirstOrDefault().StockQuantity, |
| | | LocationName = d.LocationCode |
| | | }).ToList() |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | }; |
| | | |
| | | var authResult = AuthenticateWithWMS(); |
| | |
| | | }; |
| | | |
| | | HttpHelper.Post<WebResponseContent>(ReceiveWMSTaskAllocatein, inventoryAllocate, "调拨入库数量回传WMS"); |
| | | WriteLog.Write_Log("API", "调拨入库数量回传WMS", "请求", new { 请求报文 = inventoryAllocate, 接收报文 = inventoryAllocate }); |
| | | |
| | | } |
| | | } |
| | | |
| | |
| | | { |
| | | ApiType = "AuthenticationController", |
| | | Parameters = new List<Parameter> |
| | | { |
| | | new Parameter { Value = "LK-Admin" }, |
| | | new Parameter { Value = "LK-Admin" } |
| | | }, |
| | | { |
| | | new Parameter { Value = "LK-Admin" }, |
| | | new Parameter { Value = "LK-Admin" } |
| | | }, |
| | | Method = "Login", |
| | | }; |
| | | |
| | |
| | | if (!validationResult.Status) return validationResult; |
| | | |
| | | int lastStatus = locationInfo.LocationStatus; |
| | | Dt_Task task1 = BaseDal.QueryFirst(x => x.TaskNum == taskNum); |
| | | if (task1 == null) |
| | | { |
| | | return WebResponseContent.Instance.Error("未找到该任务信息"); |
| | | } |
| | | |
| | | ///盘点出库任务完成逻辑 |
| | | if ((task.TaskType == TaskTypeEnum.OutInventory.ObjToInt())) |
| | | if (task.TaskType == TaskTypeEnum.OutInventory.ObjToInt() && stockInfo.System == "SMOM") |
| | | { |
| | | return SMOMOutInventoryCompleted(task, stockInfo, locationInfo); |
| | | } |
| | | else if (task.TaskType == TaskTypeEnum.OutInventory.ObjToInt()) |
| | | { |
| | | return OutInventoryCompleted(task, stockInfo, locationInfo); |
| | | } |
| | | Dt_OutboundOrder inboundOrder = _outboundService.OutboundOrderService.Db.Queryable<Dt_OutboundOrder>() |
| | | .Where(x => x.OrderNo == task1.OrderNo) |
| | | .Includes(x => x.Details) |
| | | .First(); |
| | | |
| | | if (inboundOrder == null) return WebResponseContent.Instance.Error("未找到出库单信息"); |
| | | |
| | | Dt_OutboundOrderDetail outboundOrderDetails = _outboundService.OutboundOrderService.Db.Queryable<Dt_OutboundOrderDetail>() |
| | | .Where(x => x.OrderId == inboundOrder.Id && x.BatchNo == stockInfo.Details.FirstOrDefault().BatchNo) |
| | | .First(); |
| | | if (outboundOrderDetails.LocationName != null && outboundOrderDetails.LocationName != "") |
| | | if (task.TaskType == TaskTypeEnum.OutSyncretism.ObjToInt()) |
| | | { |
| | | outboundOrderDetails = _outboundService.OutboundOrderService.Db.Queryable<Dt_OutboundOrderDetail>() |
| | | .Where(x => x.OrderId == inboundOrder.Id && x.BatchNo == stockInfo.Details.FirstOrDefault().BatchNo && x.LocationName == stockInfo.LocationCode) |
| | | .First(); |
| | | stockInfo.StockStatus = StockStatusEmun.合托出库完成.ObjToInt(); |
| | | stockInfo.Details.ForEach(x => |
| | | { |
| | | x.Status = StockStatusEmun.合托出库完成.ObjToInt(); |
| | | }); |
| | | _unitOfWorkManage.BeginTran(); |
| | | _stockRepository.StockInfoRepository.UpdateData(stockInfo); |
| | | _stockRepository.StockInfoDetailRepository.UpdateData(stockInfo.Details); |
| | | BaseDal.DeleteAndMoveIntoHty(task, App.User.UserId == 0 ? OperateType.自动完成 : OperateType.人工完成); |
| | | _unitOfWorkManage.CommitTran(); |
| | | } |
| | | if (outboundOrderDetails == null) return WebResponseContent.Instance.Error("未找到出库单信息"); |
| | | else |
| | | { |
| | | Dt_Warehouse warehouse = _basicRepository.WarehouseRepository.QueryFirst(x => x.WarehouseId == task.WarehouseId); |
| | | |
| | | // 2. 处理出库订单详情 |
| | | //var outboundOrderDetails = ProcessOutboundOrderDetails(outStockLockInfos); |
| | | if (warehouse.WarehouseCode.Contains("CP")) |
| | | { |
| | | try |
| | | { |
| | | Dt_NewOutboundOrder outboundOrder = _outboundService.NewOutboundOrderService.Db.Queryable<Dt_NewOutboundOrder>() |
| | | .Where(x => x.OrderNo == task.OrderNo) |
| | | .Includes(x => x.Details) |
| | | .First(); |
| | | |
| | | UpdateOutboundOrderDetails(stockInfo, inboundOrder, ref outboundOrderDetails); |
| | | List<Dt_NewOutboundOrderDetail> outboundOrderDetails = _outboundService.NewOutboundOrderDetailService.Db.Queryable<Dt_NewOutboundOrderDetail>() |
| | | .Where(x => x.OrderId == outboundOrder.Id && |
| | | x.LocationName == stockInfo.LocationCode && |
| | | x.LPNNo == stockInfo.PalletCode) |
| | | .ToList(); |
| | | List<Dt_NewOutboundOrderDetail> outboundOrderDetails1 = new List<Dt_NewOutboundOrderDetail>(); |
| | | if (outboundOrderDetails == null || outboundOrderDetails.Count == 0) |
| | | { |
| | | outboundOrderDetails1 = _outboundService.NewOutboundOrderDetailService.Db.Queryable<Dt_NewOutboundOrderDetail>() |
| | | .Where(x => x.OrderId == outboundOrder.Id) |
| | | .ToList(); |
| | | } |
| | | if ((outboundOrderDetails == null && outboundOrderDetails1 == null) || (outboundOrderDetails.Count == 0 && outboundOrderDetails1.Count == 0)) |
| | | { |
| | | throw new Exception($"未找到托盘 {stockInfo.PalletCode} 在货位 {stockInfo.LocationCode} 上的出库单明细"); |
| | | } |
| | | // 获取库存明细 |
| | | var stockInfoDetails = stockInfo.Details.ToList(); |
| | | |
| | | // 3. 执行核心出库逻辑 |
| | | return ExecuteOutboundLogic(task, stockInfo, locationInfo, outboundOrderDetails, inboundOrder); |
| | | int overCount = outboundOrder.Details.Count(x => x.OrderDetailStatus == OrderDetailStatusEnum.Over.ObjToInt()); |
| | | |
| | | if (outboundOrderDetails == null || outboundOrderDetails.Count == 0) |
| | | { |
| | | foreach (var stockDetail in stockInfoDetails) |
| | | { |
| | | var matchingOrderDetails = outboundOrderDetails1 |
| | | .Where(x => x.MaterielCode == stockDetail.MaterielCode) |
| | | .ToList(); |
| | | |
| | | if (matchingOrderDetails.Count == 0) |
| | | { |
| | | continue; |
| | | } |
| | | |
| | | // 计算需要分配的数量 |
| | | decimal remainingStock = stockDetail.OutboundQuantity; |
| | | |
| | | foreach (var orderDetail in matchingOrderDetails) |
| | | { |
| | | if (remainingStock <= 0) break; |
| | | |
| | | if (orderDetail.OrderDetailStatus == OrderDetailStatusEnum.Over.ObjToInt()) |
| | | continue; |
| | | |
| | | // 计算本次可以分配的数量 |
| | | decimal availableOrderQty = orderDetail.OrderQuantity - orderDetail.OverOutQuantity; |
| | | decimal allocateQty = Math.Min(remainingStock, availableOrderQty); |
| | | |
| | | if (allocateQty > 0) |
| | | { |
| | | orderDetail.OverOutQuantity += allocateQty; |
| | | remainingStock -= allocateQty; |
| | | |
| | | // 检查是否完成 |
| | | if (Math.Abs(orderDetail.OverOutQuantity - orderDetail.OrderQuantity) < 0.001m) |
| | | { |
| | | orderDetail.OrderDetailStatus = OrderDetailStatusEnum.Over.ObjToInt(); |
| | | overCount++; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | // 更新订单状态 |
| | | if (outboundOrder.Details.Count == overCount) |
| | | { |
| | | outboundOrder.OrderStatus = OutboundStatusEnum.出库完成.ObjToInt(); |
| | | } |
| | | _unitOfWorkManage.BeginTran(); |
| | | |
| | | try |
| | | { |
| | | // 更新出库单 |
| | | _outboundService.NewOutboundOrderService.Repository.UpdateData(outboundOrder); |
| | | |
| | | _outboundService.NewOutboundOrderDetailService.Repository.UpdateData(outboundOrderDetails1); |
| | | |
| | | |
| | | AddCPRetrueOrder(stockInfo, outboundOrder, outboundOrderDetails1); |
| | | |
| | | // 区分单据数据来源更新货位状态 |
| | | if (outboundOrder.System == null) |
| | | { |
| | | return WebResponseContent.Instance.Error("出库单数据源为空"); |
| | | } |
| | | |
| | | if (!outboundOrder.System.Equals("SMOM")) |
| | | { |
| | | UpdateLocationStatus(locationInfo); |
| | | } |
| | | |
| | | // 处理任务完成 |
| | | CompleteTask(task); |
| | | |
| | | // 添加状态变更记录 |
| | | AddStatusChangeRecord(task, stockInfo, locationInfo); |
| | | |
| | | string path = "http://fr.mankun.com:8080/webroot/decision/view/report?viewlet=fr-report\\SMOM/Product/Produce/OutBoundDetileReport.cpt&op=write&format=pdf"; |
| | | string fullPath = AppDomain.CurrentDomain.BaseDirectory; |
| | | var url = Path.Combine(fullPath, "wwwroot", "Reports"); |
| | | string savePath = Path.Combine(url, "本次出库.pdf"); |
| | | |
| | | // ERP系统反馈 |
| | | if (outboundOrder.System.Equals("ERP")) |
| | | { |
| | | // 为每个完成的明细反馈ERP |
| | | foreach (var orderDetail in outboundOrderDetails1.Where(x => x.OrderDetailStatus == OrderDetailStatusEnum.Over.ObjToInt())) |
| | | { |
| | | FeedBackOutERP(outboundOrder.OrderNo, orderDetail.LinId); |
| | | |
| | | } |
| | | |
| | | // 如果有完成的明细,下载报表 |
| | | if (outboundOrderDetails1.Any(x => x.OrderDetailStatus == OrderDetailStatusEnum.Over.ObjToInt())) |
| | | { |
| | | DownloadReport(path, savePath, outboundOrderDetails1.First().Id); |
| | | } |
| | | } |
| | | |
| | | //单据完成推送SMOM系统 |
| | | if (outboundOrder.OrderStatus == OutboundStatusEnum.出库完成.ObjToInt() && outboundOrder.System.Equals("SMOM")) |
| | | { |
| | | var outStockLockInfoList = _outboundService.OutboundStockLockInfoService.Repository |
| | | .QueryData(x => x.OrderNo == outboundOrder.OrderNo); |
| | | |
| | | if (outStockLockInfoList.Count == 0) |
| | | throw new Exception($"订单 {outboundOrder.OrderNo} 托盘 {stockInfo.PalletCode} 未找到库存锁定信息"); |
| | | |
| | | // 采购出库 |
| | | if (outboundOrder.OrderType == 1) |
| | | { |
| | | var passBack = new HouseoutboundPassBack |
| | | { |
| | | ApiType = "ShippingOrderController", |
| | | Method = "AsrsOutboundSO", |
| | | Parameters = new List<HouseoutboundPassBack.datas> |
| | | { |
| | | new HouseoutboundPassBack.datas |
| | | { |
| | | Value = new List<HouseoutboundPassBack.datas.data1> |
| | | { |
| | | new HouseoutboundPassBack.datas.data1 |
| | | { |
| | | No = outboundOrder.OrderNo, |
| | | OutWareHouse = task.Roadway, |
| | | TransactionCode = outboundOrder.TransactionCode, |
| | | InoutType = outboundOrder.OrderType, |
| | | OrderType = outboundOrder.InoutType, |
| | | DetailList = outStockLockInfoList.Select(d => new HouseoutboundPassBack.datas.data1.Inbound |
| | | { |
| | | LinId = d.LinId?? "", |
| | | LPN_No = d.PalletCode, |
| | | MaterielCode = d.MaterielCode?? "", |
| | | OrderQuantity = d.OrderQuantity, |
| | | BatchNo = d.BatchNo, |
| | | FinishQty = d.OrderQuantity, |
| | | LocationName = d.LocationCode |
| | | }) |
| | | .ToList() |
| | | } |
| | | } |
| | | } |
| | | } |
| | | }; |
| | | |
| | | //调用SMOM接口... |
| | | var authResult = AuthenticateWithWMS(); |
| | | if (authResult.IsSuccess) |
| | | { |
| | | passBack.Context = new Dictionary<string, string> |
| | | { |
| | | { "Ticket", authResult.Ticket }, |
| | | { "InvOrgId", authResult.InvOrgId } |
| | | }; |
| | | var response = HttpHelper.Post<MomRequestContent>(ReceiveWMSTaskout, passBack, "立库出库数量回传WMS"); |
| | | if (!response.Success) |
| | | { |
| | | WriteLog.Write_Log("API", "SMOM立库库数量回传WMS", "请求失败", new { 请求报文 = passBack, 接收报文 = response }); |
| | | |
| | | throw new Exception($"操作失败: {response.Message ?? "未提供错误信息"}"); |
| | | } |
| | | WriteLog.Write_Log("API", "SMOM立库库数量回传WMS", "请求成功", new { 请求报文 = passBack, 接收报文 = response }); |
| | | } |
| | | } |
| | | |
| | | // 调拨出库 |
| | | if (outboundOrder.OrderType == 4) |
| | | { |
| | | var allocate = new InventoryAllocate |
| | | { |
| | | ApiType = "InventoryAllocateController", |
| | | Method = "AsrsFinishedStockCount", |
| | | Parameters = new List<Allocate> |
| | | { |
| | | new Allocate |
| | | { |
| | | Value = new List<Allocate.data1> |
| | | { |
| | | new Allocate.data1 |
| | | { |
| | | No = outboundOrder.OrderNo, |
| | | InWarehouse = task.Roadway, |
| | | TransactionCode = outboundOrder.TransactionCode, |
| | | InoutType = outboundOrder.OrderType, |
| | | OrderType = outboundOrder.InoutType, |
| | | ActiveType = 2, |
| | | DetailList = outStockLockInfoList.Select(item => |
| | | { |
| | | return new Allocate.data1.Inventory |
| | | { |
| | | LinId = item.LinId, |
| | | LPNNo = item.PalletCode, |
| | | MaterielCode = item.MaterielCode, |
| | | OrderQuantity = item.OrderQuantity, |
| | | BatchNo = item.BatchNo, |
| | | FinishQty = item.OrderQuantity, |
| | | LocationName = task.SourceAddress |
| | | }; |
| | | }).ToList() |
| | | } |
| | | } |
| | | } |
| | | } |
| | | }; |
| | | |
| | | // 调用SMOM接口... |
| | | var authResult = AuthenticateWithWMS(); |
| | | if (authResult.IsSuccess) |
| | | { |
| | | allocate.Context = new Dictionary<string, string> |
| | | { |
| | | { "Ticket", authResult.Ticket }, |
| | | { "InvOrgId", authResult.InvOrgId } |
| | | }; |
| | | var response = HttpHelper.Post<MomRequestContent>(ReceiveWMSTaskin, allocate, "立库入库数量回传WMS"); |
| | | if (!response.Success) |
| | | { |
| | | WriteLog.Write_Log("API", "SMOM立库库数量回传WMS", "请求失败", new { 请求报文 = allocate, 接收报文 = response }); |
| | | |
| | | throw new Exception($"操作失败: {response.Message ?? "未提供错误信息"}"); |
| | | } |
| | | WriteLog.Write_Log("API", "SMOM立库库数量回传WMS", "请求成功", new { 请求报文 = allocate, 接收报文 = response }); |
| | | |
| | | } |
| | | } |
| | | } |
| | | |
| | | if (outboundOrder.OrderType == 240) // 盘点出库 |
| | | { |
| | | // 盘点出库特殊处理逻辑 |
| | | } |
| | | |
| | | _unitOfWorkManage.CommitTran(); |
| | | return WebResponseContent.Instance.OK(); |
| | | } |
| | | catch |
| | | { |
| | | _unitOfWorkManage.RollbackTran(); |
| | | throw; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | foreach (var stockDetail in stockInfoDetails) |
| | | { |
| | | var matchingOrderDetails = outboundOrderDetails |
| | | .Where(x => x.MaterielCode == stockDetail.MaterielCode && |
| | | x.BatchNo == stockDetail.BatchNo) |
| | | .ToList(); |
| | | |
| | | if (matchingOrderDetails.Count == 0) |
| | | { |
| | | continue; |
| | | } |
| | | |
| | | // 计算需要分配的数量 |
| | | decimal remainingStock = stockDetail.OutboundQuantity; |
| | | |
| | | foreach (var orderDetail in matchingOrderDetails) |
| | | { |
| | | if (remainingStock <= 0) break; |
| | | |
| | | if (orderDetail.OrderDetailStatus == OrderDetailStatusEnum.Over.ObjToInt()) |
| | | continue; |
| | | |
| | | // 计算本次可以分配的数量 |
| | | decimal availableOrderQty = orderDetail.OrderQuantity - orderDetail.OverOutQuantity; |
| | | decimal allocateQty = Math.Min(remainingStock, availableOrderQty); |
| | | |
| | | if (allocateQty > 0) |
| | | { |
| | | orderDetail.OverOutQuantity += allocateQty; |
| | | remainingStock -= allocateQty; |
| | | |
| | | // 检查是否完成 |
| | | if (Math.Abs(orderDetail.OverOutQuantity - orderDetail.OrderQuantity) < 0.001m) |
| | | { |
| | | orderDetail.OrderDetailStatus = OrderDetailStatusEnum.Over.ObjToInt(); |
| | | overCount++; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | // 更新订单状态 |
| | | if (outboundOrder.Details.Count == overCount) |
| | | { |
| | | outboundOrder.OrderStatus = OutboundStatusEnum.出库完成.ObjToInt(); |
| | | } |
| | | _unitOfWorkManage.BeginTran(); |
| | | |
| | | try |
| | | { |
| | | // 更新出库单 |
| | | _outboundService.NewOutboundOrderService.Repository.UpdateData(outboundOrder); |
| | | |
| | | _outboundService.NewOutboundOrderDetailService.Repository.UpdateData(outboundOrderDetails); |
| | | |
| | | |
| | | AddCPRetrueOrder(stockInfo, outboundOrder, outboundOrderDetails); |
| | | |
| | | // 区分单据数据来源更新货位状态 |
| | | if (outboundOrder.System == null) |
| | | { |
| | | return WebResponseContent.Instance.Error("出库单数据源为空"); |
| | | } |
| | | |
| | | if (!outboundOrder.System.Equals("SMOM")) |
| | | { |
| | | UpdateLocationStatus(locationInfo); |
| | | } |
| | | |
| | | // 处理任务完成 |
| | | CompleteTask(task); |
| | | |
| | | // 添加状态变更记录 |
| | | AddStatusChangeRecord(task, stockInfo, locationInfo); |
| | | |
| | | string path = "http://fr.mankun.com:8080/webroot/decision/view/report?viewlet=fr-report\\SMOM/Product/Produce/OutBoundDetileReport.cpt&op=write&format=pdf"; |
| | | string fullPath = AppDomain.CurrentDomain.BaseDirectory; |
| | | var url = Path.Combine(fullPath, "wwwroot", "Reports"); |
| | | string savePath = Path.Combine(url, "本次出库.pdf"); |
| | | |
| | | // ERP系统反馈 |
| | | if (outboundOrder.System.Equals("ERP")) |
| | | { |
| | | // 为每个完成的明细反馈ERP |
| | | foreach (var orderDetail in outboundOrderDetails.Where(x => x.OrderDetailStatus == OrderDetailStatusEnum.Over.ObjToInt())) |
| | | { |
| | | FeedBackOutERP(outboundOrder.OrderNo, orderDetail.LinId); |
| | | } |
| | | |
| | | // 如果有完成的明细,下载报表 |
| | | if (outboundOrderDetails.Any(x => x.OrderDetailStatus == OrderDetailStatusEnum.Over.ObjToInt())) |
| | | { |
| | | DownloadReport(path, savePath, outboundOrderDetails.First().Id); |
| | | } |
| | | } |
| | | |
| | | //单据完成推送SMOM系统 |
| | | if (outboundOrder.OrderStatus == OutboundStatusEnum.出库完成.ObjToInt() && outboundOrder.System.Equals("SMOM")) |
| | | { |
| | | var outStockLockInfoList = _outboundService.OutboundStockLockInfoService.Repository |
| | | .QueryData(x => x.OrderNo == outboundOrder.OrderNo); |
| | | |
| | | if (outStockLockInfoList.Count == 0) |
| | | throw new Exception($"订单 {outboundOrder.OrderNo} 托盘 {stockInfo.PalletCode} 未找到库存锁定信息"); |
| | | |
| | | // 采购出库 |
| | | if (outboundOrder.OrderType == 1) |
| | | { |
| | | var passBack = new HouseoutboundPassBack |
| | | { |
| | | ApiType = "ShippingOrderController", |
| | | Method = "AsrsOutboundSO", |
| | | Parameters = new List<HouseoutboundPassBack.datas> |
| | | { |
| | | new HouseoutboundPassBack.datas |
| | | { |
| | | Value = new List<HouseoutboundPassBack.datas.data1> |
| | | { |
| | | new HouseoutboundPassBack.datas.data1 |
| | | { |
| | | No = outboundOrder.OrderNo, |
| | | OutWareHouse = task.Roadway, |
| | | TransactionCode = outboundOrder.TransactionCode, |
| | | InoutType = outboundOrder.OrderType, |
| | | OrderType = outboundOrder.InoutType, |
| | | DetailList = outStockLockInfoList.Select(d => new HouseoutboundPassBack.datas.data1.Inbound |
| | | { |
| | | LinId = d.LinId?? "", |
| | | LPN_No = d.PalletCode, |
| | | MaterielCode = d.MaterielCode?? "", |
| | | OrderQuantity = d.OrderQuantity, |
| | | BatchNo = d.BatchNo, |
| | | FinishQty = d.OrderQuantity, |
| | | LocationName = d.LocationCode |
| | | }) |
| | | .ToList() |
| | | } |
| | | } |
| | | } |
| | | } |
| | | }; |
| | | |
| | | //调用SMOM接口... |
| | | var authResult = AuthenticateWithWMS(); |
| | | if (authResult.IsSuccess) |
| | | { |
| | | passBack.Context = new Dictionary<string, string> |
| | | { |
| | | { "Ticket", authResult.Ticket }, |
| | | { "InvOrgId", authResult.InvOrgId } |
| | | }; |
| | | var response = HttpHelper.Post<MomRequestContent>(ReceiveWMSTaskout, passBack, "立库出库数量回传WMS"); |
| | | if (!response.Success) |
| | | { |
| | | WriteLog.Write_Log("API", "SMOM立库库数量回传WMS", "请求失败", new { 请求报文 = passBack, 接收报文 = response }); |
| | | |
| | | throw new Exception($"操作失败: {response.Message ?? "未提供错误信息"}"); |
| | | } |
| | | WriteLog.Write_Log("API", "SMOM立库库数量回传WMS", "请求成功", new { 请求报文 = passBack, 接收报文 = response }); |
| | | |
| | | } |
| | | } |
| | | |
| | | // 调拨出库 |
| | | if (outboundOrder.OrderType == 4) |
| | | { |
| | | var allocate = new InventoryAllocate |
| | | { |
| | | ApiType = "InventoryAllocateController", |
| | | Method = "AsrsFinishedStockCount", |
| | | Parameters = new List<Allocate> |
| | | { |
| | | new Allocate |
| | | { |
| | | Value = new List<Allocate.data1> |
| | | { |
| | | new Allocate.data1 |
| | | { |
| | | No = outboundOrder.OrderNo, |
| | | InWarehouse = task.Roadway, |
| | | TransactionCode = outboundOrder.TransactionCode, |
| | | InoutType = outboundOrder.OrderType, |
| | | OrderType = outboundOrder.InoutType, |
| | | ActiveType = 2, |
| | | DetailList = outStockLockInfoList.Select(item => |
| | | { |
| | | return new Allocate.data1.Inventory |
| | | { |
| | | LinId = item.LinId, |
| | | LPNNo = item.PalletCode, |
| | | MaterielCode = item.MaterielCode, |
| | | OrderQuantity = item.OrderQuantity, |
| | | BatchNo = item.BatchNo, |
| | | FinishQty = item.OrderQuantity, |
| | | LocationName = task.SourceAddress |
| | | }; |
| | | }).ToList() |
| | | } |
| | | } |
| | | } |
| | | } |
| | | }; |
| | | |
| | | // 调用SMOM接口... |
| | | var authResult = AuthenticateWithWMS(); |
| | | if (authResult.IsSuccess) |
| | | { |
| | | allocate.Context = new Dictionary<string, string> |
| | | { |
| | | { "Ticket", authResult.Ticket }, |
| | | { "InvOrgId", authResult.InvOrgId } |
| | | }; |
| | | var response = HttpHelper.Post<MomRequestContent>(ReceiveWMSTaskin, allocate, "立库入库数量回传WMS"); |
| | | if (!response.Success) |
| | | { |
| | | WriteLog.Write_Log("API", "SMOM立库库数量回传WMS", "请求失败", new { 请求报文 = allocate, 接收报文 = response }); |
| | | |
| | | throw new Exception($"操作失败: {response.Message ?? "未提供错误信息"}"); |
| | | } |
| | | WriteLog.Write_Log("API", "SMOM立库库数量回传WMS", "请求成功", new { 请求报文 = allocate, 接收报文 = response }); |
| | | |
| | | } |
| | | } |
| | | } |
| | | |
| | | if (outboundOrder.OrderType == 240) // 盘点出库 |
| | | { |
| | | // 盘点出库特殊处理逻辑 |
| | | } |
| | | |
| | | _unitOfWorkManage.CommitTran(); |
| | | return WebResponseContent.Instance.OK(); |
| | | } |
| | | catch |
| | | { |
| | | _unitOfWorkManage.RollbackTran(); |
| | | throw; |
| | | } |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return WebResponseContent.Instance.Error($"处理失败: {ex.Message}"); |
| | | } |
| | | } |
| | | else if (warehouse.WarehouseCode.Contains("DW") || warehouse.WarehouseCode.Contains("YS")) |
| | | { |
| | | Dt_OutboundOrder inboundOrder = _outboundService.OutboundOrderService.Db.Queryable<Dt_OutboundOrder>() |
| | | .Where(x => x.OrderNo == task.OrderNo) |
| | | .Includes(x => x.Details) |
| | | .First(); |
| | | |
| | | if (inboundOrder == null) return WebResponseContent.Instance.Error("未找到出库单信息"); |
| | | |
| | | List<Dt_OutboundOrderDetail> outboundOrderDetails = new List<Dt_OutboundOrderDetail>(); |
| | | foreach (var detail in stockInfo.Details) |
| | | { |
| | | Dt_OutboundOrderDetail outboundOrderDetail = _outboundService.OutboundOrderService.Db.Queryable<Dt_OutboundOrderDetail>() |
| | | .Where(x => x.OrderId == inboundOrder.Id && x.BatchNo == detail.BatchNo).First(); |
| | | if(outboundOrderDetail != null) |
| | | { |
| | | outboundOrderDetails.Add(outboundOrderDetail); |
| | | |
| | | } |
| | | } |
| | | |
| | | for (var i = 0; i < outboundOrderDetails.Count; i++) |
| | | { |
| | | if (outboundOrderDetails[i].LocationName != null && outboundOrderDetails[i].LocationName != "") |
| | | { |
| | | foreach (var detail in stockInfo.Details) |
| | | { |
| | | Dt_OutboundOrderDetail newOutboundOrderDetail = _outboundService.OutboundOrderService.Db.Queryable<Dt_OutboundOrderDetail>() |
| | | .Where(x => x.OrderId == inboundOrder.Id && x.BatchNo == detail.BatchNo && x.LocationName == stockInfo.LocationCode) |
| | | .First(); |
| | | outboundOrderDetails[i] = newOutboundOrderDetail; |
| | | } |
| | | } |
| | | } |
| | | |
| | | if (outboundOrderDetails == null) return WebResponseContent.Instance.Error("未找到出库单信息"); |
| | | DWANDYSUpdateOutboundOrderDetails(stockInfo, inboundOrder, ref outboundOrderDetails); |
| | | // 3. 执行核心出库逻辑 |
| | | return DWANDYSExecuteOutboundLogic(task, stockInfo, locationInfo, outboundOrderDetails, inboundOrder); |
| | | } |
| | | else |
| | | { |
| | | Dt_OutboundOrder inboundOrder = _outboundService.OutboundOrderService.Db.Queryable<Dt_OutboundOrder>() |
| | | .Where(x => x.OrderNo == task.OrderNo) |
| | | .Includes(x => x.Details) |
| | | .First(); |
| | | |
| | | if (inboundOrder == null) return WebResponseContent.Instance.Error("未找到出库单信息"); |
| | | |
| | | Dt_OutboundOrderDetail outboundOrderDetails = _outboundService.OutboundOrderService.Db.Queryable<Dt_OutboundOrderDetail>() |
| | | .Where(x => x.OrderId == inboundOrder.Id && x.BatchNo == stockInfo.Details.FirstOrDefault().BatchNo) |
| | | .First(); |
| | | if (outboundOrderDetails.LocationName != null && outboundOrderDetails.LocationName != "") |
| | | { |
| | | outboundOrderDetails = _outboundService.OutboundOrderService.Db.Queryable<Dt_OutboundOrderDetail>() |
| | | .Where(x => x.OrderId == inboundOrder.Id && x.BatchNo == stockInfo.Details.FirstOrDefault().BatchNo && x.LocationName == stockInfo.LocationCode) |
| | | .First(); |
| | | } |
| | | if (outboundOrderDetails == null) return WebResponseContent.Instance.Error("未找到出库单信息"); |
| | | UpdateOutboundOrderDetails(stockInfo, inboundOrder, ref outboundOrderDetails); |
| | | // 3. 执行核心出库逻辑 |
| | | return ExecuteOutboundLogic(task, stockInfo, locationInfo, outboundOrderDetails, inboundOrder); |
| | | } |
| | | } |
| | | return WebResponseContent.Instance.OK(); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | |
| | | |
| | | if (stockInfo == null) return WebResponseContent.Instance.Error("未找到库存信息"); |
| | | if (locationInfo == null) return WebResponseContent.Instance.Error("未找到货位信息"); |
| | | if ((outStockLockInfos == null || outStockLockInfos.Count == 0)&& task.TaskType != TaskTypeEnum.OutInventory.ObjToInt()) |
| | | if ((outStockLockInfos == null || outStockLockInfos.Count == 0) && task.TaskType != TaskTypeEnum.OutInventory.ObjToInt()) |
| | | return WebResponseContent.Instance.Error("未找到出库详情信息"); |
| | | |
| | | return WebResponseContent.Instance.OK(); |
| | |
| | | // 更新出库订单详情 |
| | | _outboundService.OutboundOrderDetailService.Repository.UpdateData(outboundOrderDetails); |
| | | |
| | | // 更新库存状态 |
| | | // 更新库存状态 回库单 |
| | | |
| | | AddRetrueOrder(stockInfo, inboundOrder); |
| | | |
| | | |
| | | // 区分单据数据来源更新货位状态 |
| | | if (inboundOrder.System == null) |
| | |
| | | if (outboundOrderDetails.OrderDetailStatus == OrderDetailStatusEnum.Over.ObjToInt() && inboundOrder.System.Equals("ERP")) |
| | | { |
| | | FeedBackOutERP(outboundOrder.OrderNo, outboundOrderDetails.LinId); |
| | | //DownloadReport(path, savePath, outboundOrderDetails.Id); |
| | | //printTest(savePath); |
| | | DownloadReport(path, savePath, outboundOrderDetails.Id); |
| | | } |
| | | ///单据完成推送SMOM系统 |
| | | if (outboundOrder.OrderStatus == OutboundStatusEnum.出库完成.ObjToInt() && inboundOrder.System.Equals("SMOM")) |
| | |
| | | throw; |
| | | } |
| | | } |
| | | |
| | | private WebResponseContent DWANDYSExecuteOutboundLogic(Dt_Task task, Dt_StockInfo stockInfo, |
| | | Dt_LocationInfo locationInfo, List<Dt_OutboundOrderDetail> outboundOrderDetails, Dt_OutboundOrder inboundOrder) |
| | | { |
| | | try |
| | | { |
| | | _unitOfWorkManage.BeginTran(); |
| | | ///更新出库单 |
| | | _outboundService.OutboundOrderService.Repository.UpdateData(inboundOrder); |
| | | // 更新出库订单详情 |
| | | _outboundService.OutboundOrderDetailService.Repository.UpdateData(outboundOrderDetails); |
| | | |
| | | // 更新库存状态 回库单 |
| | | if (locationInfo.RoadwayNo.Contains("DW") || locationInfo.RoadwayNo.Contains("YS")) |
| | | { |
| | | AddDWANDYSRetrueOrder(stockInfo, inboundOrder); |
| | | } |
| | | |
| | | // 区分单据数据来源更新货位状态 |
| | | if (inboundOrder.System == null) |
| | | { |
| | | return WebResponseContent.Instance.Error("出库单数据源为空"); |
| | | } |
| | | if (!inboundOrder.System.Equals("SMOM")) |
| | | { |
| | | UpdateLocationStatus(locationInfo); |
| | | } |
| | | // 处理任务完成 |
| | | CompleteTask(task); |
| | | |
| | | // 添加状态变更记录 |
| | | AddStatusChangeRecord(task, stockInfo, locationInfo); |
| | | |
| | | |
| | | // 根据订单类型处理不同逻辑 |
| | | |
| | | var outboundOrder = _outboundService.OutboundOrderService.Db.Queryable<Dt_OutboundOrder>() |
| | | .Where(x => x.OrderNo == inboundOrder.OrderNo).First(); |
| | | foreach (var outboundOrderDetail in outboundOrderDetails) |
| | | { |
| | | var outDetail = _outboundService.OutboundOrderDetailService.Db.Queryable<Dt_OutboundOrderDetail>() |
| | | .Where(x => x.OrderId == outboundOrder.Id && x.BatchNo == outboundOrderDetail.BatchNo).First(); |
| | | string path = "http://fr.mankun.com:8080/webroot/decision/view/report?viewlet=fr-report\\SMOM/Product/Produce/OutBoundDetileReport.cpt&op=write&format=pdf"; |
| | | string fullPath = AppDomain.CurrentDomain.BaseDirectory; |
| | | var url = Path.Combine(fullPath, "wwwroot", "Reports"); |
| | | string savePath = Path.Combine(url, "本次出库.pdf"); |
| | | |
| | | |
| | | if (outboundOrderDetail.OrderDetailStatus == OrderDetailStatusEnum.Over.ObjToInt() && inboundOrder.System.Equals("ERP")) |
| | | { |
| | | FeedBackOutERP(outboundOrder.OrderNo, outboundOrderDetail.LinId); |
| | | DownloadReport(path, savePath, outboundOrderDetail.Id); |
| | | } |
| | | ///单据完成推送SMOM系统 |
| | | if (outboundOrder.OrderStatus == OutboundStatusEnum.出库完成.ObjToInt() && inboundOrder.System.Equals("SMOM")) |
| | | { |
| | | var stockInfoDetail = stockInfo.Details.FirstOrDefault(); |
| | | ProcessNormalOutbound(task, stockInfo, outboundOrder, outDetail); |
| | | //DownloadReport(path, savePath, outboundOrderDetails.Id); |
| | | //printTest(savePath); |
| | | //SendNormalOutboundToWMS(task, outboundOrder, stockInfoDetail, outDetail); |
| | | } |
| | | |
| | | if (outboundOrder.OrderType == 240) // 盘点出库 |
| | | { |
| | | // 盘点出库特殊处理逻辑 |
| | | } |
| | | } |
| | | _unitOfWorkManage.CommitTran(); |
| | | return WebResponseContent.Instance.OK(); |
| | | } |
| | | catch |
| | | { |
| | | _unitOfWorkManage.RollbackTran(); |
| | | throw; |
| | | } |
| | | } |
| | | private void UpdateOutboundOrderDetails(Dt_StockInfo stockInfo, Dt_OutboundOrder inboundOrder, ref Dt_OutboundOrderDetail inboundOrderDetail) |
| | | { |
| | | int overCount = inboundOrder.Details.Count(x => x.OrderDetailStatus == OrderDetailStatusEnum.Over.ObjToInt()); |
| | | inboundOrderDetail = inboundOrder.Details.FirstOrDefault(x => x.BatchNo == stockInfo.Details.FirstOrDefault()?.BatchNo); |
| | | //inboundOrderDetail = inboundOrder.Details.FirstOrDefault(x => x.BatchNo == stockInfo.Details.FirstOrDefault()?.BatchNo&&x.LPNNo==stockInfo.PalletCode); |
| | | |
| | | foreach (var item in stockInfo.Details) |
| | | { |
| | |
| | | { |
| | | inboundOrder.OrderStatus = OutboundStatusEnum.出库完成.ObjToInt(); |
| | | } |
| | | } |
| | | |
| | | //低温、药水 |
| | | private void DWANDYSUpdateOutboundOrderDetails(Dt_StockInfo stockInfo, Dt_OutboundOrder inboundOrder, ref List<Dt_OutboundOrderDetail> inboundOrderDetails) |
| | | { |
| | | List<Dt_OutboundOrderDetail> newOutboundOrderDetails = inboundOrderDetails; |
| | | foreach (var newOutboundOrderDetail in newOutboundOrderDetails) |
| | | { |
| | | string BatchNo = newOutboundOrderDetail.BatchNo; |
| | | //inboundOrderDetail = inboundOrder.Details.FirstOrDefault(x => x.BatchNo == stockInfo.Details.FirstOrDefault()?.BatchNo&&x.LPNNo==stockInfo.PalletCode); |
| | | |
| | | foreach (var item in stockInfo.Details) |
| | | { |
| | | if (newOutboundOrderDetail == null) continue; |
| | | |
| | | if (newOutboundOrderDetail.OrderDetailStatus == OrderDetailStatusEnum.Over.ObjToInt()) continue; |
| | | |
| | | if (newOutboundOrderDetail.BatchNo == item.BatchNo) |
| | | { |
| | | newOutboundOrderDetail.OverOutQuantity += item.OutboundQuantity; |
| | | |
| | | if (newOutboundOrderDetail.OverOutQuantity == newOutboundOrderDetail.OrderQuantity) |
| | | { |
| | | newOutboundOrderDetail.OrderDetailStatus = OrderDetailStatusEnum.Over.ObjToInt(); |
| | | } |
| | | else if (newOutboundOrderDetail.OrderDetailStatus == OrderDetailStatusEnum.New.ObjToInt()) |
| | | { |
| | | newOutboundOrderDetail.OrderDetailStatus = OutboundStatusEnum.出库中.ObjToInt(); |
| | | inboundOrder.OrderStatus = OutboundStatusEnum.出库中.ObjToInt(); |
| | | } |
| | | } |
| | | } |
| | | if (newOutboundOrderDetails.All(x => x.OrderDetailStatus == OrderDetailStatusEnum.Over.ObjToInt())) |
| | | { |
| | | inboundOrder.OrderStatus = OutboundStatusEnum.出库完成.ObjToInt(); |
| | | } |
| | | } |
| | | |
| | | } |
| | | |
| | | private void DeleteAndMoveIntoHtStockStatus(Dt_StockInfo stockInfo) |
| | |
| | | StockChangeType.Outbound.ObjToInt(), |
| | | stockInfo.Details.FirstOrDefault()?.OrderNo ?? "", |
| | | task.TaskNum); |
| | | |
| | | _recordService.StockQuantityChangeRecordService.NEWAddStockChangeRecord( |
| | | stockInfo, stockInfo.Details, |
| | | stockInfo.Details.Sum(x => x.StockQuantity), |
| | | stockInfo.Details.Sum(x => x.OutboundQuantity), |
| | | StockChangeType.Outbound, task.TaskNum); |
| | | } |
| | | |
| | | private void ProcessNormalOutbound(Dt_Task task, Dt_StockInfo stockInfo, |
| | |
| | | // 发送出库信息到WMS |
| | | if (outboundOrder.OrderStatus == OutboundStatusEnum.出库完成.ObjToInt() && outboundOrder.OrderType == 1) |
| | | { |
| | | SendNormalOutboundToWMS(task, outboundOrder, stockInfoDetail, outDetail); |
| | | //SendNormalOutboundToWMS(task, outboundOrder, stockInfoDetail, outDetail); |
| | | } |
| | | else if (outboundOrder.OrderStatus == OutboundStatusEnum.出库完成.ObjToInt() && outboundOrder.OrderType == 2) |
| | | { |
| | |
| | | ApiType = "InventoryAllocateController", |
| | | Method = "AsrsFinishedStockCount", |
| | | Parameters = new List<Allocate> |
| | | { |
| | | new Allocate |
| | | { |
| | | Value = new List<Allocate.data1> |
| | | { |
| | | new Allocate.data1 |
| | | new Allocate |
| | | { |
| | | No = outboundOrder.OrderNo, |
| | | InWarehouse = task.Roadway, |
| | | TransactionCode = outboundOrder.TransactionCode, |
| | | InoutType = outboundOrder.OrderType, |
| | | OrderType = outboundOrder.InoutType, |
| | | DetailList = outStockLockInfos.Select(item => |
| | | Value = new List<Allocate.data1> |
| | | { |
| | | var detail = _stockService.StockInfoDetailService.Repository.QueryFirst(x => x.StockId == item.Id); |
| | | return new Allocate.data1.Inventory |
| | | new Allocate.data1 |
| | | { |
| | | LinId = outDetail.LinId, |
| | | LPN_No = item.PalletCode, |
| | | MaterielCode = detail.MaterielCode, |
| | | OrderQuantity = detail.OutboundQuantity, |
| | | BatchNo = detail.BatchNo, |
| | | FinishQty = detail.OutboundQuantity, |
| | | LocationName = task.SourceAddress |
| | | }; |
| | | }).ToList() |
| | | No = outboundOrder.OrderNo, |
| | | InWarehouse = task.Roadway, |
| | | TransactionCode = outboundOrder.TransactionCode, |
| | | InoutType = outboundOrder.OrderType, |
| | | OrderType = outboundOrder.InoutType, |
| | | DetailList = outStockLockInfos.Select(item => |
| | | { |
| | | //var detail = _stockService.StockInfoDetailService.Repository.QueryFirst(x => x.StockId == item.StockId); |
| | | return new Allocate.data1.Inventory |
| | | { |
| | | LinId = outDetail.LinId, |
| | | LPNNo = item.PalletCode, |
| | | MaterielCode = outDetail.MaterielCode, |
| | | OrderQuantity = outDetail.OrderQuantity, |
| | | BatchNo = outDetail.BatchNo, |
| | | FinishQty = outDetail.OrderQuantity, |
| | | LocationName = task.SourceAddress |
| | | }; |
| | | }).ToList() |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | }; |
| | | |
| | | var authResult = AuthenticateWithWMS(); |
| | | if (authResult.IsSuccess) |
| | | { |
| | | allocate.Context = new Dictionary<string, string> |
| | | { |
| | | { "Ticket", authResult.Ticket }, |
| | | { "InvOrgId", authResult.InvOrgId } |
| | | }; |
| | | { |
| | | { "Ticket", authResult.Ticket }, |
| | | { "InvOrgId", authResult.InvOrgId } |
| | | }; |
| | | |
| | | HttpHelper.Post<WebResponseContent>(ReceiveWMSTaskin, allocate, "立库入库数量回传WMS"); |
| | | var response = HttpHelper.Post<WebResponseContent>(ReceiveWMSTaskin, allocate, "立库入库数量回传WMS"); |
| | | WriteLog.Write_Log("API", "SMOM立库入库数量回传WMS", "请求", new { 请求报文 = allocate, 接收报文 = response }); |
| | | |
| | | } |
| | | } |
| | | |
| | |
| | | private void AddRetrueOrder(Dt_StockInfo stockInfo, Dt_OutboundOrder outboundOrder) |
| | | { |
| | | Dt_StockInfoDetail stockInfoDetail = _stockService.StockInfoDetailService.Db.Queryable<Dt_StockInfoDetail>() |
| | | .Where(x => x.StockId == stockInfo.Id) |
| | | .First(); |
| | | .Where(x => x.StockId == stockInfo.Id).First(); |
| | | if (stockInfoDetail == null) |
| | | { |
| | | throw new Exception("建立回库单时,未找到该库存信息"); |
| | |
| | | } |
| | | } |
| | | |
| | | |
| | | } |
| | | |
| | | //低温、药水回库单 |
| | | private void AddDWANDYSRetrueOrder(Dt_StockInfo stockInfo, Dt_OutboundOrder outboundOrder) |
| | | { |
| | | |
| | | List<Dt_StockInfoDetail> stockInfoDetails = _stockService.StockInfoDetailService.Db.Queryable<Dt_StockInfoDetail>() |
| | | .Where(x => x.StockId == stockInfo.Id).ToList(); |
| | | |
| | | Dt_ReturnOrder? lastReturnOrder = null; |
| | | foreach (var stockInfoDetail in stockInfoDetails) |
| | | { |
| | | if (stockInfoDetail == null) |
| | | { |
| | | throw new Exception("建立回库单时,未找到该库存信息"); |
| | | } |
| | | if (outboundOrder.OrderType == OrderTypeEnum.反拣出库单.ObjToInt()) |
| | | { |
| | | Dt_ReturnOrder returnOrder = _returnOrderRepository.QueryFirst(x => x.LPNNo == stockInfo.PalletCode && x.LocationCode == stockInfo.LocationCode && x.OrderStatus == InOrderStatusEnum.未开始.ObjToInt()); |
| | | if (returnOrder == null) |
| | | { |
| | | throw new Exception("反拣出库后,未找到对应反拣回库单信息"); |
| | | } |
| | | stockInfo.LocationCode = ""; |
| | | stockInfo.StockStatus = StockStatusEmun.反拣入库.ObjToInt(); |
| | | stockInfo.Remark = "反拣入库"; |
| | | stockInfoDetail.OutboundQuantity = 0; |
| | | stockInfoDetail.StockQuantity += returnOrder.OrderQuantity; |
| | | stockInfoDetail.OrderNo = returnOrder.OrderNo; |
| | | } |
| | | else |
| | | { |
| | | bool allowCompeted = stockInfo.Details.All(x => x.StockQuantity == x.OutboundQuantity); |
| | | if (allowCompeted) |
| | | { |
| | | DeleteAndMoveIntoHtStockStatus(stockInfo); |
| | | } |
| | | else |
| | | { |
| | | decimal returnQuantity = stockInfoDetail.StockQuantity - stockInfoDetail.OutboundQuantity; |
| | | if (returnQuantity > 0) |
| | | { |
| | | Dt_ReturnOrder returnOrder = new Dt_ReturnOrder |
| | | { |
| | | MaterielCode = stockInfoDetail.MaterielCode, |
| | | MaterielName = stockInfoDetail.MaterielName, |
| | | BatchNo = stockInfoDetail.BatchNo, |
| | | OrderQuantity = returnQuantity, |
| | | ReceiptQuantity = returnQuantity, |
| | | OrderStatus = InOrderStatusEnum.未开始.ObjToInt(), |
| | | LinId = stockInfoDetail.LinId, |
| | | LPNNo = stockInfo.PalletCode, |
| | | Creater = "LK", |
| | | CreateDate = DateTime.Now, |
| | | OrderType = OrderTypeEnum.余料回库单.ObjToInt(), |
| | | System = "WMS", |
| | | Remark = stockInfoDetail.BatchNo |
| | | }; |
| | | if (lastReturnOrder != null) |
| | | { |
| | | lastReturnOrder.Remark = lastReturnOrder.Remark + $", {returnOrder.BatchNo}"; |
| | | _returnOrderRepository.UpdateData(lastReturnOrder); |
| | | } |
| | | if (outboundOrder.System == "SMOM" && stockInfo.LocationCode != null) |
| | | { |
| | | returnOrder.LocationCode = stockInfo.LocationCode; |
| | | } |
| | | _unitOfWorkManage.BeginTran(); |
| | | if (lastReturnOrder == null) |
| | | { |
| | | _returnOrderRepository.AddData(returnOrder); |
| | | lastReturnOrder = returnOrder; |
| | | } |
| | | stockInfo.LocationCode = ""; |
| | | stockInfo.StockStatus = StockStatusEmun.余料退库.ObjToInt(); |
| | | stockInfo.Remark = "余料退库"; |
| | | stockInfoDetail.OutboundQuantity = 0; |
| | | stockInfoDetail.StockQuantity = returnQuantity; |
| | | stockInfoDetail.OrderNo = lastReturnOrder.OrderNo; |
| | | _stockService.StockInfoService.Repository.UpdateData(stockInfo); |
| | | _stockService.StockInfoDetailService.Repository.UpdateData(stockInfoDetail); |
| | | _unitOfWorkManage.CommitTran(); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | } |
| | | |
| | | //成品回库单 |
| | | private void AddCPRetrueOrder(Dt_StockInfo stockInfo, Dt_NewOutboundOrder outboundOrder, List<Dt_NewOutboundOrderDetail> outboundOrderDetails) |
| | | { |
| | | List<Dt_StockInfoDetail> stockInfoDetails = _stockService.StockInfoDetailService.Db.Queryable<Dt_StockInfoDetail>() |
| | | .Where(x => x.StockId == stockInfo.Id) |
| | | .ToList(); |
| | | |
| | | if (stockInfoDetails == null || stockInfoDetails.Count == 0) |
| | | { |
| | | throw new Exception("建立回库单时,未找到该库存信息"); |
| | | } |
| | | _unitOfWorkManage.BeginTran(); |
| | | try |
| | | { |
| | | if (outboundOrder.OrderType == OrderTypeEnum.反拣出库单.ObjToInt()) |
| | | { |
| | | Dt_ReturnOrder returnOrder = _returnOrderRepository.QueryFirst(x => |
| | | x.LPNNo == stockInfo.PalletCode && |
| | | x.LocationCode == stockInfo.LocationCode && |
| | | x.OrderStatus == InOrderStatusEnum.未开始.ObjToInt()); |
| | | |
| | | if (returnOrder == null) |
| | | { |
| | | throw new Exception("反拣出库后,未找到对应反拣回库单信息"); |
| | | } |
| | | foreach (var outDetail in outboundOrderDetails) |
| | | { |
| | | var matchedStockDetail = stockInfoDetails.FirstOrDefault(x => x.MaterielCode == outDetail.MaterielCode && x.BatchNo == outDetail.BatchNo); |
| | | if (matchedStockDetail == null) |
| | | { |
| | | matchedStockDetail = stockInfoDetails.FirstOrDefault(x =>x.MaterielCode == outDetail.MaterielCode); |
| | | |
| | | if (matchedStockDetail == null) |
| | | { |
| | | throw new Exception($"未找到匹配的库存明细信息,物料:{outDetail.MaterielCode}, 批次:{outDetail.BatchNo}"); |
| | | } |
| | | } |
| | | // 只减去单据明细中的数量 |
| | | //matchedStockDetail.OutboundQuantity = 0; |
| | | //matchedStockDetail.StockQuantity = outDetail.OrderQuantity; |
| | | //matchedStockDetail.OrderNo = returnOrder.OrderNo; |
| | | // 更新匹配的明细 |
| | | _stockService.StockInfoDetailService.Repository.UpdateData(matchedStockDetail); |
| | | } |
| | | |
| | | |
| | | // 更新库存状态 |
| | | stockInfo.LocationCode = ""; |
| | | stockInfo.StockStatus = StockStatusEmun.反拣入库.ObjToInt(); |
| | | stockInfo.Remark = "反拣入库"; |
| | | _stockService.StockInfoService.Repository.UpdateData(stockInfo); |
| | | } |
| | | else |
| | | { |
| | | var groupedDetails = outboundOrderDetails |
| | | .GroupBy(d => new { d.MaterielCode, d.BatchNo }) |
| | | .ToList(); |
| | | List<Dt_StockInfoDetail> processedStockDetails = new List<Dt_StockInfoDetail>(); |
| | | List<Dt_ReturnOrder> returnOrders = new List<Dt_ReturnOrder>(); |
| | | |
| | | decimal totalOutboundQuantity = outboundOrderDetails.Sum(x => x.OrderQuantity); |
| | | decimal totalStockQuantity = stockInfoDetails.Sum(x => x.StockQuantity); |
| | | |
| | | foreach (var detail in stockInfo.Details) |
| | | { |
| | | foreach (var groupeDetail in groupedDetails) |
| | | { |
| | | |
| | | var outboundDetail = groupeDetail.First(); |
| | | if (outboundDetail.MaterielCode == detail.MaterielCode) |
| | | { |
| | | decimal totalOrderQuantity = groupeDetail.Sum(x => x.OrderQuantity); |
| | | var matchedStockDetail = stockInfoDetails.FirstOrDefault(x => x.MaterielCode == outboundDetail.MaterielCode && x.BatchNo == outboundDetail.BatchNo); |
| | | if (matchedStockDetail == null) |
| | | { |
| | | matchedStockDetail = stockInfoDetails.FirstOrDefault(x => x.MaterielCode == outboundDetail.MaterielCode); |
| | | |
| | | if (matchedStockDetail == null) |
| | | { |
| | | throw new Exception($"未找到匹配的库存明细信息,物料:{outboundDetail.MaterielCode}, 批次:{outboundDetail.BatchNo}"); |
| | | } |
| | | } |
| | | // 计算当前批次的剩余数量 |
| | | decimal remainingQuantity = matchedStockDetail.StockQuantity - totalOrderQuantity; |
| | | |
| | | if (remainingQuantity > 0) |
| | | { |
| | | Dt_ReturnOrder returnOrder = new Dt_ReturnOrder |
| | | { |
| | | MaterielCode = matchedStockDetail.MaterielCode, |
| | | MaterielName = matchedStockDetail.MaterielName, |
| | | BatchNo = matchedStockDetail.BatchNo, |
| | | OrderQuantity = remainingQuantity, |
| | | ReceiptQuantity = remainingQuantity, |
| | | OrderStatus = InOrderStatusEnum.未开始.ObjToInt(), |
| | | LinId = matchedStockDetail.LinId, |
| | | LPNNo = stockInfo.PalletCode, |
| | | Creater = "LK", |
| | | CreateDate = DateTime.Now, |
| | | OrderType = OrderTypeEnum.余料回库单.ObjToInt(), |
| | | System = "WMS", |
| | | Remark = "多批次返库" // 添加备注标识 |
| | | }; |
| | | |
| | | if (outboundOrder.System == "SMOM" && stockInfo.LocationCode != null) |
| | | { |
| | | returnOrder.LocationCode = stockInfo.LocationCode; |
| | | } |
| | | |
| | | // 添加返库单 |
| | | returnOrders.Add(returnOrder); |
| | | |
| | | } |
| | | if (remainingQuantity < 0 && matchedStockDetail.StockQuantity < matchedStockDetail.OutboundQuantity) |
| | | { |
| | | throw new Exception($"出库数量 {outboundDetail.OrderQuantity} 大于库存数量 {matchedStockDetail.StockQuantity}"); |
| | | } |
| | | processedStockDetails.Add(matchedStockDetail); |
| | | |
| | | |
| | | // 处理其他批次的库存明细(全部返库) |
| | | var otherBatchDetails = stockInfoDetails |
| | | .Where(x => !processedStockDetails.Contains(x) && x.StockQuantity > 0 && x.OutboundQuantity == 0) |
| | | .ToList(); |
| | | |
| | | if (returnOrders == null || returnOrders.Count == 0) |
| | | { |
| | | if (otherBatchDetails.Count > 0) |
| | | { |
| | | decimal totalOtherQuantity = otherBatchDetails.Sum(x => x.StockQuantity); |
| | | |
| | | // 为其他批次创建返库单(只创建一个,包含所有批次) |
| | | var firstOtherDetail = otherBatchDetails.First(); |
| | | Dt_ReturnOrder otherReturnOrder = new Dt_ReturnOrder |
| | | { |
| | | MaterielCode = firstOtherDetail.MaterielCode, |
| | | MaterielName = firstOtherDetail.MaterielName, |
| | | BatchNo = firstOtherDetail.BatchNo, |
| | | OrderQuantity = totalOtherQuantity, |
| | | ReceiptQuantity = totalOtherQuantity, |
| | | OrderStatus = InOrderStatusEnum.未开始.ObjToInt(), |
| | | LinId = firstOtherDetail.LinId, |
| | | LPNNo = stockInfo.PalletCode, |
| | | Creater = "LK", |
| | | CreateDate = DateTime.Now, |
| | | OrderType = OrderTypeEnum.余料回库单.ObjToInt(), |
| | | System = "WMS", |
| | | Remark = $"多批次返库,共{otherBatchDetails.Count}个批次" |
| | | }; |
| | | |
| | | if (outboundOrder.System == "SMOM" && !string.IsNullOrEmpty(stockInfo.LocationCode)) |
| | | { |
| | | otherReturnOrder.LocationCode = stockInfo.LocationCode; |
| | | } |
| | | returnOrders.Add(otherReturnOrder); |
| | | } |
| | | |
| | | } |
| | | else |
| | | { |
| | | decimal totalOtherQuantity = otherBatchDetails.Sum(x => x.StockQuantity); |
| | | foreach (var item in returnOrders) |
| | | { |
| | | item.OrderQuantity = totalOrderQuantity; |
| | | item.ReceiptQuantity = totalOrderQuantity; |
| | | item.Remark = $"多批次返库,共{otherBatchDetails.Count}个批次"; |
| | | } |
| | | } |
| | | |
| | | // 批量更新已处理的库存明细 |
| | | var updateDetails = processedStockDetails.Where(x => x.StockQuantity > 0).ToList(); |
| | | if (updateDetails.Any()) |
| | | { |
| | | _stockService.StockInfoDetailService.Repository.UpdateData(updateDetails); |
| | | } |
| | | |
| | | // 添加返库单 |
| | | if (returnOrders.Any()) |
| | | { |
| | | _returnOrderRepository.AddData(returnOrders); |
| | | } |
| | | |
| | | // 更新库存主表状态 |
| | | decimal returnQuantity = totalStockQuantity - totalOutboundQuantity; |
| | | if (returnQuantity == 0 || stockInfo.Details.All(x => x.StockQuantity == x.OutboundQuantity)) |
| | | { |
| | | if (outboundOrder.System == "SMOM" && stockInfo.LocationCode != null) |
| | | { |
| | | Dt_LocationInfo dt_LocationInfo = _locationInfoService.Repository.QueryFirst(x => x.LocationCode == stockInfo.LocationCode); |
| | | dt_LocationInfo.LocationStatus = LocationStatusEnum.Free.ObjToInt(); |
| | | _basicRepository.LocationInfoRepository.UpdateData(dt_LocationInfo); |
| | | } |
| | | //全部出库,删除库存 |
| | | //DeleteAndMoveIntoHtStockStatus(stockInfo); |
| | | //foreach (var item in stockInfo.Details) |
| | | //{ |
| | | // BaseDal.Db.Deleteable(item.StockDetails).ExecuteCommand(); |
| | | //} |
| | | } |
| | | else if (returnQuantity > 0) |
| | | { |
| | | // 有余料返库 |
| | | stockInfo.LocationCode = ""; |
| | | stockInfo.StockStatus = StockStatusEmun.余料退库.ObjToInt(); |
| | | stockInfo.Remark = $"余料退库,共{returnOrders.Count}个返库单"; |
| | | _stockService.StockInfoService.Repository.UpdateData(stockInfo); |
| | | } |
| | | } |
| | | } |
| | | |
| | | } |
| | | |
| | | _unitOfWorkManage.CommitTran(); |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | _unitOfWorkManage.RollbackTran(); |
| | | throw; |
| | | } |
| | | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 单据明细出库完成回调ERP(表单提交) |
| | | /// </summary> |
| | |
| | | |
| | | result = response.Content.ReadAsStringAsync() |
| | | .ConfigureAwait(false).GetAwaiter().GetResult(); |
| | | WriteLog.Write_Log("API", "单据明细出库完成回调ERP", "请求成功", new { 请求报文 = postContent, 接收报文 = response }); |
| | | |
| | | } |
| | | |
| | | // 假设ERP返回成功时返回成功响应 |
| | |
| | | } |
| | | catch (HttpRequestException ex) |
| | | { |
| | | WriteLog.Write_Log("API", "单据明细出库完成回调ERP", "请求失败", new { 请求报文 = postContent, 接收报文 = ex.Message }); |
| | | |
| | | // 处理HTTP请求相关异常 |
| | | return WebResponseContent.Instance.Error($"HTTP请求错误: {ex.Message}"); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | WriteLog.Write_Log("API", "单据明细出库完成回调ERP", "请求失败", new { 请求报文 = postContent, 接收报文 = ex.Message }); |
| | | |
| | | // 处理其他异常 |
| | | return WebResponseContent.Instance.Error($"处理失败: {ex.Message}"); |
| | | } |
| | |
| | | // 判断Success的值 |
| | | if (response.Code == 0) |
| | | { |
| | | WriteLog.Write_Log("API", "任务回传给erp", "请求成功", new { 请求报文 = feedbackInboundOrder, 接收报文 = response }); |
| | | |
| | | // 如果Success为true,返回需要的值(这里以返回整个响应对象为例) |
| | | return WebResponseContent.Instance.OK(); |
| | | } |
| | | else |
| | | { |
| | | WriteLog.Write_Log("API", "任务回传给erp", "请求失败", new { 请求报文 = feedbackInboundOrder, 接收报文 = response }); |
| | | |
| | | // 如果Success为false,抛出异常并包含错误信息 |
| | | throw new Exception($"操作失败: {response.Message ?? "未提供错误信息"}"); |
| | | } |
| | | } |
| | | public string DownloadReport(string path, string savePath, int orderId) |
| | | // 方法声明添加 async 关键字,返回值改为 Task<string> |
| | | public async Task<string> DownloadReport(string path, string savePath, int orderId) |
| | | { |
| | | // 构建完整 URL,(报表传参) |
| | | string reportUrl = path + "&orderId=" + orderId; |
| | | |
| | | try |
| | | { |
| | | // 确保保存目录存在 |
| | | string directory = Path.GetDirectoryName(savePath); |
| | | Console.WriteLine($"下载地址: {reportUrl}"); |
| | | Console.WriteLine($"保存路径: {savePath}"); |
| | | |
| | | // 确保目录存在 |
| | | if (!Directory.Exists(directory)) |
| | | { |
| | | Directory.CreateDirectory(directory); |
| | | Console.WriteLine($"已创建目录: {directory}"); |
| | | } |
| | | |
| | | string[] files = Directory.GetFiles(directory); |
| | | // 删除每个文件 |
| | | foreach (string filePath in files) |
| | | // 清理目录下现有文件 |
| | | if (File.Exists(savePath)) |
| | | { |
| | | File.Delete(filePath); |
| | | File.Delete(savePath); |
| | | Console.WriteLine($"已删除旧文件: {savePath}"); |
| | | } |
| | | // 使用 HttpClient 下载文件 |
| | | |
| | | // 使用临时文件名下载,下载完成后再重命名 |
| | | string tempFilePath = savePath + ".tmp"; |
| | | |
| | | // 异步下载文件 |
| | | using (var httpClient = new HttpClient()) |
| | | { |
| | | // 设置超时时间(帆软报表生成可能需要较长时间) |
| | | httpClient.Timeout = TimeSpan.FromMinutes(5); |
| | | |
| | | // 发送 GET 请求(同步方式) |
| | | using (var response = httpClient.GetAsync(reportUrl, HttpCompletionOption.ResponseHeadersRead).GetAwaiter().GetResult()) |
| | | using (var response = await httpClient.GetAsync(reportUrl, HttpCompletionOption.ResponseHeadersRead).ConfigureAwait(false)) |
| | | { |
| | | // 检查响应状态 |
| | | response.EnsureSuccessStatusCode(); |
| | | |
| | | // 获取内容流(同步方式) |
| | | using (var contentStream = response.Content.ReadAsStreamAsync().GetAwaiter().GetResult()) |
| | | using (var contentStream = await response.Content.ReadAsStreamAsync().ConfigureAwait(false)) |
| | | { |
| | | // 创建文件流 |
| | | using (var fileStream = new FileStream(savePath, FileMode.Create, FileAccess.Write, FileShare.None)) |
| | | Console.WriteLine($"开始写入临时文件: {tempFilePath}"); |
| | | |
| | | using (var fileStream = new FileStream( |
| | | tempFilePath, |
| | | FileMode.Create, |
| | | FileAccess.Write, |
| | | FileShare.None, |
| | | bufferSize: 4096, |
| | | useAsync: true |
| | | )) |
| | | { |
| | | // 复制内容到文件(同步方式) |
| | | contentStream.CopyToAsync(fileStream).GetAwaiter().GetResult(); |
| | | await contentStream.CopyToAsync(fileStream).ConfigureAwait(false); |
| | | await fileStream.FlushAsync().ConfigureAwait(false); |
| | | Console.WriteLine($"临时文件写入完成: {tempFilePath}"); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | // 关键优化:确保文件完全写入磁盘 |
| | | await EnsureFileCompletelyWritten(tempFilePath); |
| | | |
| | | // 重命名为目标文件 |
| | | File.Move(tempFilePath, savePath, true); |
| | | Console.WriteLine($"文件重命名完成: {savePath}"); |
| | | |
| | | // 验证文件可访问 |
| | | await ValidateFileAccessible(savePath); |
| | | |
| | | // 打印文件 |
| | | PrintTestDirect(savePath); |
| | | |
| | | return savePath; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | Console.WriteLine($"下载失败: {ex.Message}"); |
| | | throw new InvalidOperationException($"文件下载异常: {ex.Message}", ex); |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 确保文件完全写入磁盘 |
| | | /// </summary> |
| | | private async Task EnsureFileCompletelyWritten(string filePath) |
| | | { |
| | | const int maxRetries = 5; |
| | | const int delayMs = 500; |
| | | |
| | | for (int i = 0; i < maxRetries; i++) |
| | | { |
| | | try |
| | | { |
| | | // 尝试以读取模式打开文件,确保文件没有被占用 |
| | | using (var fs = new FileStream(filePath, |
| | | FileMode.Open, |
| | | FileAccess.Read, |
| | | FileShare.Read, |
| | | bufferSize: 4096, |
| | | useAsync: true)) |
| | | { |
| | | // 验证文件有内容 |
| | | if (fs.Length > 0) |
| | | { |
| | | Console.WriteLine($"文件验证成功: 大小={fs.Length}字节 (尝试 {i + 1}/{maxRetries})"); |
| | | return; |
| | | } |
| | | else |
| | | { |
| | | Console.WriteLine($"警告: 文件大小为0 (尝试 {i + 1}/{maxRetries})"); |
| | | } |
| | | } |
| | | } |
| | | catch (IOException ex) |
| | | { |
| | | Console.WriteLine($"文件可能仍在写入中 (尝试 {i + 1}/{maxRetries}): {ex.Message}"); |
| | | } |
| | | |
| | | if (i < maxRetries - 1) |
| | | { |
| | | await Task.Delay(delayMs); |
| | | } |
| | | } |
| | | |
| | | throw new IOException($"文件写入未完成或无法访问: {filePath}"); |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 验证文件可访问且不为空 |
| | | /// </summary> |
| | | private async Task ValidateFileAccessible(string filePath) |
| | | { |
| | | const int maxRetries = 3; |
| | | const int delayMs = 300; |
| | | |
| | | for (int i = 0; i < maxRetries; i++) |
| | | { |
| | | try |
| | | { |
| | | if (!File.Exists(filePath)) |
| | | { |
| | | throw new FileNotFoundException($"文件不存在: {filePath}"); |
| | | } |
| | | |
| | | var fileInfo = new FileInfo(filePath); |
| | | |
| | | // 验证文件大小大于0 |
| | | if (fileInfo.Length == 0) |
| | | { |
| | | throw new InvalidDataException($"文件大小为0: {filePath}"); |
| | | } |
| | | |
| | | // 验证文件不是完全由空字符组成(可选检查) |
| | | await ValidateFileContent(filePath); |
| | | |
| | | Console.WriteLine($"文件验证通过: {filePath} (大小={fileInfo.Length}字节)"); |
| | | return; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | Console.WriteLine($"文件验证失败 (尝试 {i + 1}/{maxRetries}): {ex.Message}"); |
| | | |
| | | if (i == maxRetries - 1) |
| | | { |
| | | throw; |
| | | } |
| | | |
| | | await Task.Delay(delayMs); |
| | | } |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 验证文件内容(可选) |
| | | /// </summary> |
| | | private async Task ValidateFileContent(string filePath) |
| | | { |
| | | try |
| | | { |
| | | // 读取文件前几个字节,确保不是完全由空字符组成 |
| | | using (var fs = new FileStream(filePath, FileMode.Open, FileAccess.Read, FileShare.Read, 4096, true)) |
| | | { |
| | | byte[] buffer = new byte[Math.Min(1024, fs.Length)]; |
| | | int bytesRead = await fs.ReadAsync(buffer, 0, buffer.Length); |
| | | |
| | | // 检查是否都是0(空文件) |
| | | if (bytesRead > 0 && buffer.All(b => b == 0)) |
| | | { |
| | | throw new InvalidDataException("文件内容异常: 全部为0字节"); |
| | | } |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | Console.WriteLine($"文件内容验证异常: {ex.Message}"); |
| | | // 可以选择是否抛出异常 |
| | | } |
| | | } |
| | | |
| | | public void PrintTestDirect(string fullPath) |
| | | { |
| | | if (!File.Exists(fullPath)) |
| | | { |
| | | Console.WriteLine($"✗ 打印失败:文件不存在 {fullPath}"); |
| | | return; |
| | | } |
| | | |
| | | // 获取打印机名称配置 |
| | | string printerName = AppSettings.app("PrinterName")?.Trim(); |
| | | |
| | | if (string.IsNullOrEmpty(printerName)) |
| | | { |
| | | // 如果没有配置,使用系统默认打印机 |
| | | printerName = GetDefaultPrinterUbuntu(); |
| | | } |
| | | |
| | | PrintUsingUbuntuPrinter(fullPath, printerName); |
| | | } |
| | | /// <summary> |
| | | /// 获取 Ubuntu 默认打印机 |
| | | /// </summary> |
| | | private string GetDefaultPrinterUbuntu() |
| | | { |
| | | try |
| | | { |
| | | ProcessStartInfo psi = new ProcessStartInfo |
| | | { |
| | | FileName = "lpstat", |
| | | Arguments = "-d", |
| | | UseShellExecute = false, |
| | | CreateNoWindow = true, |
| | | RedirectStandardOutput = true |
| | | }; |
| | | |
| | | using (Process process = new Process { StartInfo = psi }) |
| | | { |
| | | process.Start(); |
| | | string output = process.StandardOutput.ReadToEnd(); |
| | | process.WaitForExit(); |
| | | |
| | | // 解析默认打印机名称,例如: "system default destination: LenovoPrinter" |
| | | if (output.Contains(":")) |
| | | { |
| | | return output.Split(':')[1].Trim(); |
| | | } |
| | | return "LenovoPrinter"; // 默认回退 |
| | | } |
| | | } |
| | | catch |
| | | { |
| | | return "LenovoPrinter"; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// Ubuntu 打印实现 |
| | | /// </summary> |
| | | private void PrintUsingUbuntuPrinter(string filePath, string printerName) |
| | | { |
| | | try |
| | | { |
| | | PrintWithLpr(filePath, printerName); |
| | | |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | throw new ValidationException(ex.Message); |
| | | Console.WriteLine($"✗ 打印失败: {ex.Message}"); |
| | | throw; |
| | | } |
| | | } |
| | | |
| | | public virtual void printTest(string fullPath) |
| | | /// <summary> |
| | | /// 使用 lpr 命令打印 |
| | | /// </summary> |
| | | private void PrintWithLpr(string filePath, string printerName) |
| | | { |
| | | Spire.Pdf.PdfDocument pdf = new PdfDocument(); |
| | | //文件地址 |
| | | pdf.LoadFromFile(fullPath); |
| | | //指定打印机位置 |
| | | string url = AppSettings.app("PrinterName"); |
| | | pdf.PrintSettings.PrinterName = url; |
| | | //执行打印 |
| | | pdf.Print(); |
| | | //内存释放 |
| | | pdf.Dispose(); |
| | | Console.WriteLine($"📄 正在打印到 {printerName}: {Path.GetFileName(filePath)}"); |
| | | |
| | | // 使用 lp 命令,添加 -o raw 选项 |
| | | string command = $"lp -d {printerName} -o raw \"{filePath}\""; |
| | | |
| | | ExecuteShellCommand(command); |
| | | } |
| | | /// <summary> |
| | | /// 执行 Shell 命令 |
| | | /// </summary> |
| | | private void ExecuteShellCommand(string command) |
| | | { |
| | | ProcessStartInfo psi = new ProcessStartInfo |
| | | { |
| | | FileName = "/bin/bash", |
| | | Arguments = $"-c \"{command.Replace("\"", "\\\"")}\"", |
| | | UseShellExecute = false, |
| | | CreateNoWindow = true, |
| | | RedirectStandardOutput = true, |
| | | RedirectStandardError = true |
| | | }; |
| | | |
| | | using (Process process = new Process { StartInfo = psi }) |
| | | { |
| | | process.Start(); |
| | | string output = process.StandardOutput.ReadToEnd(); |
| | | string error = process.StandardError.ReadToEnd(); |
| | | process.WaitForExit(); |
| | | |
| | | if (process.ExitCode == 0) |
| | | { |
| | | Console.WriteLine($"✅ 打印任务提交成功"); |
| | | if (!string.IsNullOrEmpty(output)) |
| | | Console.WriteLine($"输出: {output}"); |
| | | } |
| | | else |
| | | { |
| | | throw new InvalidOperationException($"命令执行失败: {error}"); |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 只使用配置的打印机进行打印 |
| | | /// </summary> |
| | | /// <summary> |
| | | /// Ubuntu 打印方法 - 使用 lpr 命令 |
| | | /// </summary> |
| | | private void PrintUsingConfiguredPrinter(string filePath, string printerName) |
| | | { |
| | | try |
| | | { |
| | | // 1. 检查打印机是否在线 |
| | | if (!IsPrinterAvailableUbuntu(printerName)) |
| | | { |
| | | throw new InvalidOperationException($"打印机 '{printerName}' 不可用或未找到"); |
| | | } |
| | | |
| | | Console.WriteLine($"✓ 使用打印机: {printerName}"); |
| | | Console.WriteLine($"✓ 正在打印: {Path.GetFileName(filePath)}"); |
| | | |
| | | // 2. 使用 lpr 命令打印 |
| | | ProcessStartInfo psi = new ProcessStartInfo |
| | | { |
| | | FileName = "lpr", |
| | | Arguments = $"-P {printerName} \"{filePath}\"", |
| | | UseShellExecute = false, |
| | | CreateNoWindow = true, |
| | | RedirectStandardOutput = true, |
| | | RedirectStandardError = true |
| | | }; |
| | | |
| | | using (Process process = new Process { StartInfo = psi }) |
| | | { |
| | | process.Start(); |
| | | string output = process.StandardOutput.ReadToEnd(); |
| | | string error = process.StandardError.ReadToEnd(); |
| | | process.WaitForExit(); |
| | | |
| | | if (process.ExitCode == 0) |
| | | { |
| | | Console.WriteLine($"✓ 打印任务已提交到 {printerName}"); |
| | | } |
| | | else |
| | | { |
| | | throw new InvalidOperationException($"打印失败: {error}"); |
| | | } |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | Console.WriteLine($"✗ 打印失败: {ex.Message}"); |
| | | throw; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// Ubuntu 检查打印机可用性 |
| | | /// </summary> |
| | | private bool IsPrinterAvailableUbuntu(string printerName) |
| | | { |
| | | try |
| | | { |
| | | ProcessStartInfo psi = new ProcessStartInfo |
| | | { |
| | | FileName = "lpstat", |
| | | Arguments = $"-p {printerName}", |
| | | UseShellExecute = false, |
| | | CreateNoWindow = true, |
| | | RedirectStandardOutput = true |
| | | }; |
| | | |
| | | using (Process process = new Process { StartInfo = psi }) |
| | | { |
| | | process.Start(); |
| | | string output = process.StandardOutput.ReadToEnd(); |
| | | process.WaitForExit(); |
| | | |
| | | return output.Contains($"{printerName} is idle") || |
| | | output.Contains($"{printerName} is ready"); |
| | | } |
| | | } |
| | | catch |
| | | { |
| | | return false; |
| | | } |
| | | } |
| | | /// <summary> |
| | | /// 盘点出库完成 |
| | | /// </summary> |
| | |
| | | } |
| | | return content; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// SMOM盘点单完成 |
| | | /// </summary> |
| | | /// <param name="task"></param> |
| | | /// <param name="stockInfo"></param> |
| | | /// <param name="locationInfo"></param> |
| | | /// <returns></returns> |
| | | public WebResponseContent SMOMOutInventoryCompleted(Dt_Task task, Dt_StockInfo stockInfo, Dt_LocationInfo locationInfo) |
| | | { |
| | | WebResponseContent content = new WebResponseContent(); |
| | | try |
| | | { |
| | | //获取对应盘点单 |
| | | Dt_TakeStockOrderCP takeStockOrder = _inboundRepository.TakeStockOrderRepository.Db.Queryable<Dt_TakeStockOrderCP>().Where(x => x.OrderNo == task.OrderNo).Includes(x => x.Details).First(); |
| | | if (takeStockOrder == null) |
| | | { |
| | | return content.Error($"盘点单{task.OrderNo}不存在"); |
| | | } |
| | | if (takeStockOrder.TakeStockStatus != TakeStockStatusEnum.盘点中.ObjToInt()) |
| | | { |
| | | return content.Error($"盘点单{task.OrderNo}盘点已完成或未开始"); |
| | | } |
| | | if (stockInfo.StockStatus != StockStatusEmun.出库锁定.ObjToInt()) |
| | | { |
| | | return content.Error($"{stockInfo.PalletCode}库存状态不正确"); |
| | | } |
| | | if (locationInfo.LocationStatus != LocationStatusEnum.Lock.ObjToInt()) |
| | | { |
| | | return content.Error($"{locationInfo.LocationCode}货位状态不正确"); |
| | | } |
| | | //根据任务托盘查盘点明细 |
| | | Dt_TakeStockOrderDetailCP? takeStockOrderDetail = takeStockOrder.Details.FirstOrDefault(x => x.TakePalletCode == stockInfo.PalletCode); |
| | | if (takeStockOrderDetail == null) |
| | | { |
| | | return content.Error($"{stockInfo.PalletCode}未找到对应盘点明细"); |
| | | } |
| | | if (takeStockOrderDetail.TakeDetalStatus != TakeStockDetailStatusEnum.盘点出库中.ObjToInt()) |
| | | { |
| | | return content.Error($"{stockInfo.PalletCode}盘点明细状态不正确"); |
| | | } |
| | | takeStockOrder.Details.ForEach(x => |
| | | { |
| | | x.TakeDetalStatus = TakeStockDetailStatusEnum.盘点出库完成.ObjToInt(); |
| | | }); |
| | | stockInfo.StockStatus = StockStatusEmun.盘点出库完成.ObjToInt(); |
| | | stockInfo.Details.ForEach(x => |
| | | { |
| | | x.Status = StockStatusEmun.盘点出库完成.ObjToInt(); |
| | | }); |
| | | stockInfo.LocationCode = ""; |
| | | task.TaskStatus = TaskStatusEnum.Finish.ObjToInt(); |
| | | int beforeStatus = locationInfo.LocationStatus; |
| | | locationInfo.LocationStatus = LocationStatusEnum.Lock.ObjToInt(); |
| | | Dt_ReturnOrder returnOrder = new Dt_ReturnOrder |
| | | { |
| | | MaterielCode = stockInfo.Details.FirstOrDefault()?.MaterielCode, |
| | | MaterielName = stockInfo.Details.FirstOrDefault()?.MaterielName, |
| | | BatchNo = stockInfo.Details.FirstOrDefault()?.BatchNo, |
| | | OrderQuantity = stockInfo.Details.Sum(x => x.StockQuantity), |
| | | ReceiptQuantity = stockInfo.Details.Sum(x => x.StockQuantity), |
| | | OrderStatus = InOrderStatusEnum.未开始.ObjToInt(), |
| | | LinId = stockInfo.Details.FirstOrDefault()?.LinId, |
| | | LocationCode = stockInfo.LocationCode, |
| | | LPNNo = stockInfo.PalletCode, |
| | | Creater = "LK", |
| | | CreateDate = DateTime.Now, |
| | | OrderType = OrderTypeEnum.盘点回库单.ObjToInt(), |
| | | System = "WMS" |
| | | }; |
| | | |
| | | _unitOfWorkManage.BeginTran(); |
| | | //货位变动记录 |
| | | _basicService.LocationInfoService.UpdateData(locationInfo); |
| | | _returnOrderRepository.AddData(returnOrder); |
| | | _recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(locationInfo, beforeStatus, LocationStatusEnum.Lock.ObjToInt(), LocationChangeType.OutboundCompleted.ObjToInt(), takeStockOrder?.OrderNo ?? "", task.TaskNum); |
| | | _takeStockOrderCPRepository.UpdateData(takeStockOrder); |
| | | _takeStockOrderDetailCPRepository.UpdateData(takeStockOrder.Details); |
| | | _stockRepository.StockInfoRepository.UpdateData(stockInfo); |
| | | _stockRepository.StockInfoDetailRepository.UpdateData(stockInfo.Details); |
| | | BaseDal.DeleteAndMoveIntoHty(task, App.User.UserId == 0 ? OperateType.自动完成 : OperateType.人工完成); |
| | | _unitOfWorkManage.CommitTran(); |
| | | content.OK(); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | _unitOfWorkManage.RollbackTran(); |
| | | content.Error(ex.Message); |
| | | } |
| | | return content; |
| | | } |
| | | } |
| | | #endregion |
| | | #endregion |