From f7686c71ac53f0d1bbd439bc0c898c86f7d68e34 Mon Sep 17 00:00:00 2001
From: dengjunjie <dengjunjie@hnkhzn.com>
Date: 星期一, 10 十一月 2025 16:39:10 +0800
Subject: [PATCH] 优化代码
---
项目代码/WMS/WIDESEA_WMSServer/WIDESEA_TaskInfoService/TaskService.cs | 165 +++++++++++++++++++++++++++++++++++--------------------
1 files changed, 105 insertions(+), 60 deletions(-)
diff --git "a/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WIDESEA_WMSServer/WIDESEA_TaskInfoService/TaskService.cs" "b/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WIDESEA_WMSServer/WIDESEA_TaskInfoService/TaskService.cs"
index 29caa7a..7cd098d 100644
--- "a/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WIDESEA_WMSServer/WIDESEA_TaskInfoService/TaskService.cs"
+++ "b/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WIDESEA_WMSServer/WIDESEA_TaskInfoService/TaskService.cs"
@@ -267,7 +267,7 @@
return webResponse.Error($"鎵瑰彿銆恵batchNo}銆戝凡璐ㄦ鍏ュ簱");
List<Dt_InventoryInfo> _InventoryInfos = _inventoryInfoRepository.QueryData(x => x.BatchNo == batchNo && x.StockStatus == StockStatusEmun.宸插叆搴�.ObjToInt()).OrderByDescending(x => x.InDate).Take(qty).ToList();
if (_InventoryInfos.Count < 1) return webResponse.Error($"鏈壘鍒版壒鍙枫�恵batchNo}銆戠殑搴撳瓨");
- Dt_LocationInfo locationInfo = _basicRepository.LocationInfoRepository.QueryFirst(x => x.LocationCode == _InventoryInfos.First().LocationCode);
+ List<Dt_LocationInfo> locationInfos = _basicRepository.LocationInfoRepository.QueryData(x => _InventoryInfos.Select(x => x.LocationCode).ToList().Contains(x.LocationCode));
List<Dt_Task> tasks = new List<Dt_Task>();
List<Dt_OutStockLockInfo> OutStockLockInfos = new List<Dt_OutStockLockInfo>();
#region 鐢熸垚璐ㄦ鍑哄簱鍗�
@@ -289,6 +289,7 @@
#endregion
foreach (var item in _InventoryInfos)
{
+ var locationInfo = locationInfos.First(x => x.LocationCode == item.LocationCode);
orderDetail.MaterielCode = item.MaterielCode;
orderDetail.MaterielName = item.MaterielName;
orderDetail.OrderQuantity += item.StockQuantity;
@@ -301,10 +302,10 @@
Grade = 0,
PalletCode = item.PalletCode,
SourceIsPickPlace = item.SerialNumber == locationInfo.MaxQty,
- NextAddress = "1005",
+ NextAddress = "1008",
Roadway = "SC01",
SourceAddress = item.LocationCode,
- TargetAddress = "1005",
+ TargetAddress = "1008",
TaskState = OutTaskStatusEnum.OutNew.ObjToInt(),
TaskType = TaskTypeEnum.OutQuality.ObjToInt(),
TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum))
@@ -331,7 +332,7 @@
OutStockLockInfos.Add(outStockLockInfo);
#endregion
}
-
+ bool CreateQCIn = AppSettings.app(nameof(CreateQCIn)).ObjToBool();
#region 鐢熸垚璐ㄦ鍏ュ簱鍗�
Dt_InboundOrderDetail inboundOrderDetail = new Dt_InboundOrderDetail()
{
@@ -364,7 +365,7 @@
BaseDal.AddData(tasks);
_outboundService.OutboundOrderService.Repository.Db.InsertNav(outboundOrder).Include(x => x.Details).ExecuteCommand();
_outboundService.OutboundStockLockInfoService.Repository.AddData(OutStockLockInfos);
- _inboundService.InbounOrderService.Repository.Db.InsertNav(inboundOrder).Include(x => x.Details).ExecuteCommand();
+ if (CreateQCIn) _inboundService.InbounOrderService.Repository.Db.InsertNav(inboundOrder).Include(x => x.Details).ExecuteCommand();
_inventoryInfoRepository.UpdateData(_InventoryInfos);
_inventoryBatchRepository.UpdateData(inventory_Batch);
#region 涓嬪彂浠诲姟缁橶CS
@@ -394,15 +395,15 @@
if (inventoryInfo == null) throw new Exception("鏈壘鍒版墭鐩樹俊鎭�");
if (inventoryInfo.StockStatus != StockStatusEmun.缁勭洏鏆傚瓨.ObjToInt() && inventoryInfo.StockStatus != StockStatusEmun.鍏ュ簱纭.ObjToInt() && inventoryInfo.StockStatus != StockStatusEmun.鍏ュ簱涓�.ObjToInt())
throw new Exception($"鎵樼洏闈炲叆搴撲腑,涓嶅彲淇敼鏁伴噺");
- Dt_InboundOrderDetail orderDetail = _inboundService.InboundOrderDetailService.Repository.QueryFirst(x => x.BatchNo == inventoryInfo.BatchNo);
+ //Dt_InboundOrderDetail orderDetail = _inboundService.InboundOrderDetailService.Repository.QueryFirst(x => x.BatchNo == inventoryInfo.BatchNo);
var StockQty = inventoryInfo.StockQuantity;
inventoryInfo.StockQuantity = qty;
inventoryInfo.BoxQuantity = qty % 8 > 0 ? qty / 8 + 1 : qty / 8;
- if (orderDetail != null)
- {
- orderDetail.ReceiptQuantity -= StockQty - qty;
- _inboundService.InboundOrderDetailService.Repository.UpdateData(orderDetail);
- }
+ //if (orderDetail != null)
+ //{
+ // orderDetail.ReceiptQuantity -= StockQty - qty;
+ // _inboundService.InboundOrderDetailService.Repository.UpdateData(orderDetail);
+ //}
_inventoryInfoRepository.UpdateData(inventoryInfo);
return webResponseContent.OK();
}
@@ -411,7 +412,38 @@
return webResponseContent.Error(ex.Message);
}
}
-
+ public override WebResponseContent UpdateData(SaveModel saveModel)
+ {
+ WebResponseContent webResponseContent = new WebResponseContent();
+ try
+ {
+ Dt_Task dt_Task = BaseDal.QueryFirst(x => x.TaskId == saveModel.MainData["taskId"].ObjToInt());
+ string newBarcode = saveModel.MainData["palletCode"].ToString();
+ if (TaskEnumHelper.GetTaskTypeGroup(dt_Task.TaskType) != TaskTypeGroup.InboundGroup)
+ throw new Exception($"鍙彲淇敼鍏ュ簱浠诲姟,濡傞渶淇敼鍏朵粬浠诲姟绫诲瀷璇疯仈绯荤鐞嗗憳锛�");
+ Dt_InventoryInfo inventoryInfo = _inventoryInfoRepository.QueryFirst(x => x.PalletCode == newBarcode);
+ if (inventoryInfo != null) throw new Exception($"鎵樼洏鍙枫�恵newBarcode}銆戝凡瀛樺湪搴撳瓨淇℃伅锛�");
+ inventoryInfo = _inventoryInfoRepository.QueryFirst(x => x.PalletCode == dt_Task.PalletCode);
+ if (inventoryInfo == null) throw new Exception($"鎵樼洏鍙枫�恵dt_Task.PalletCode}銆戞湭鎵惧埌搴撳瓨淇℃伅锛�");
+ inventoryInfo.PalletCode = newBarcode;
+ dt_Task.PalletCode = newBarcode;
+ Db.Ado.BeginTran();
+ WMSTaskDTO wMSTaskDTOs = _mapper.Map<WMSTaskDTO>(dt_Task);
+ var ResultData = HttpHelper.PostAsync(WCSInterfaceAddress.ModifyBarcode, wMSTaskDTOs.ToJson(), headers: new Dictionary<string, string>());
+ if (ResultData.Result == null) throw new Exception($"WCS鍝嶅簲瓒呮椂");
+ WebResponseContent content = JsonConvert.DeserializeObject<WebResponseContent>(ResultData.Result);
+ if (content == null) throw new Exception($"WCS鏃犲搷搴�");
+ if (!content.Status) throw new Exception(content.Message);
+ BaseDal.UpdateData(dt_Task);
+ _inventoryInfoRepository.UpdateData(inventoryInfo);
+ Db.Ado.CommitTran();
+ return webResponseContent.OK();
+ }
+ catch (Exception ex)
+ {
+ return webResponseContent.Error(ex.Message);
+ }
+ }
public WebResponseContent ModifyBarcode(string barcode, string newBarcode)
{
WebResponseContent webResponseContent = new WebResponseContent();
@@ -460,23 +492,36 @@
{
Dt_Task task = BaseDal.QueryFirst(x => x.TaskNum == WMStask.TaskNum && x.TaskType == WMStask.TaskType);
if (task == null) return WebResponseContent.Instance.Error("鏈壘鍒颁换鍔′俊鎭�");
- Dt_StockInfo? _StockInfo = _stockService.StockInfoService.GetStockByPalletCode(task.PalletCode);
- if (_StockInfo != null)
+ Dt_InventoryInfo? inventoryInfo = _inventoryInfoRepository.QueryFirst(x => x.PalletCode == task.PalletCode);
+ if (inventoryInfo != null)
{
- Dt_StockInfoDetail? detail = _StockInfo.Details.FirstOrDefault();
- if (detail != null)
+ Dt_InboundOrderDetail? inboundOrderDetail = _inboundService.InboundOrderDetailService.Repository.QueryFirst(x => x.BatchNo == inventoryInfo.BatchNo);
+ if (inboundOrderDetail != null)
{
- Dt_InboundOrder dt_InboundOrder = _inboundService.InbounOrderService.GetInboundOrder(detail.OrderNo);
- Dt_InboundOrderDetail? inboundOrderDetail = dt_InboundOrder.Details.FirstOrDefault(x => x.BatchNo == detail.BatchNo);
- if (inboundOrderDetail != null)
- {
- inboundOrderDetail.ReceiptQuantity--;
- _inboundService.InboundOrderDetailService.Repository.UpdateData(inboundOrderDetail);
- }
- _stockService.StockInfoDetailService.Repository.DeleteAndMoveIntoHty(_StockInfo.Details, OperateType.AGV鍒犻櫎);
+ inboundOrderDetail.ReceiptQuantity--;
+ _inboundService.InboundOrderDetailService.Repository.UpdateData(inboundOrderDetail);
}
- _stockService.StockInfoService.Repository.DeleteAndMoveIntoHty(_StockInfo, OperateType.AGV鍒犻櫎);
+ _inventoryInfoRepository.DeleteAndMoveIntoHty(inventoryInfo, OperateType.AGV鍒犻櫎);
}
+ #region MyRegion
+ //Dt_StockInfo? _StockInfo = _stockService.StockInfoService.GetStockByPalletCode(task.PalletCode);
+ //if (_StockInfo != null)
+ //{
+ // Dt_StockInfoDetail? detail = _StockInfo.Details.FirstOrDefault();
+ // if (detail != null)
+ // {
+ // Dt_InboundOrder dt_InboundOrder = _inboundService.InbounOrderService.GetInboundOrder(detail.OrderNo);
+ // Dt_InboundOrderDetail? inboundOrderDetail = dt_InboundOrder.Details.FirstOrDefault(x => x.BatchNo == detail.BatchNo);
+ // if (inboundOrderDetail != null)
+ // {
+ // inboundOrderDetail.ReceiptQuantity--;
+ // _inboundService.InboundOrderDetailService.Repository.UpdateData(inboundOrderDetail);
+ // }
+ // _stockService.StockInfoDetailService.Repository.DeleteAndMoveIntoHty(_StockInfo.Details, OperateType.AGV鍒犻櫎);
+ // }
+ // _stockService.StockInfoService.Repository.DeleteAndMoveIntoHty(_StockInfo, OperateType.AGV鍒犻櫎);
+ //}
+ #endregion
BaseDal.DeleteAndMoveIntoHty(task, /*App.User.UserId == 0 ? OperateType.鑷姩瀹屾垚 :*/ OperateType.AGV鍒犻櫎);
}
catch (Exception ex)
@@ -569,7 +614,7 @@
if (Sourcelocation != null)
{
- if (BaseDal.QueryFirst(x => x.SourceAddress == task.SourceAddress && x.TaskState < TaskOutStatusEnum.SC_OutFinish.ObjToInt()) == null)
+ if (BaseDal.QueryFirst(x => x.SourceAddress == task.SourceAddress && x.TaskState < TaskOutStatusEnum.SC_OutFinish.ObjToInt() && x.TaskId != task.TaskId) == null)
Sourcelocation.LocationStatus = LocationStatusEnum.InStock.ObjToInt();
Sourcelocation.CurrentQty--;
if (Sourcelocation.CurrentQty <= 0)
@@ -681,43 +726,43 @@
{
Db.Ado.BeginTran();
Dt_OutStockLockInfo? outStockLockInfo = _outboundService.OutboundStockLockInfoService.Repository.QueryFirst(x => x.TaskNum == task.TaskNum && x.PalletCode == task.PalletCode);
- Dt_OutboundOrder? outboundOrder = null;
- Dt_OutboundOrderDetail? outboundOrderDetail = null;
+ //Dt_OutboundOrder? outboundOrder = null;
+ //Dt_OutboundOrderDetail? outboundOrderDetail = null;
int overCount = 0;
if (outStockLockInfo != null)
{
- outboundOrderDetail = _outboundService.OutboundOrderDetailService.Repository.QueryFirst(x => x.Id == outStockLockInfo.OrderDetailId);
- if (outboundOrderDetail != null)
- {
- outboundOrder = Db.Queryable<Dt_OutboundOrder>().Where(x => x.Id == outboundOrderDetail.OrderId).Includes(x => x.Details).First();
- if (outboundOrder != null)
- {
- outboundOrderDetail.OverOutQuantity++;
- overCount = outboundOrder.Details.Where(x => x.OrderDetailStatus == OrderDetailStatusEnum.Over.ObjToInt()).Count();
- if (outboundOrderDetail.OverOutQuantity == outboundOrderDetail.OrderQuantity)
- {
- var outboundOrderdetail = outboundOrder.Details.First(x => x.Id == outboundOrderDetail.Id);
- outboundOrderDetail.OrderDetailStatus = OrderDetailStatusEnum.Over.ObjToInt();
- outboundOrderdetail.OverOutQuantity = outboundOrderDetail.OverOutQuantity;
- outboundOrderdetail.OrderDetailStatus = outboundOrderDetail.OrderDetailStatus;
- overCount++;
- }
- }
- }
+ //outboundOrderDetail = _outboundService.OutboundOrderDetailService.Repository.QueryFirst(x => x.Id == outStockLockInfo.OrderDetailId);
+ //if (outboundOrderDetail != null)
+ //{
+ // outboundOrder = Db.Queryable<Dt_OutboundOrder>().Where(x => x.Id == outboundOrderDetail.OrderId).Includes(x => x.Details).First();
+ // if (outboundOrder != null)
+ // {
+ // outboundOrderDetail.OverOutQuantity += outStockLockInfo.AssignQuantity;
+ // overCount = outboundOrder.Details.Where(x => x.OrderDetailStatus == OrderDetailStatusEnum.Over.ObjToInt()).Count();
+ // if (outboundOrderDetail.OverOutQuantity == outboundOrderDetail.OrderQuantity)
+ // {
+ // var outboundOrderdetail = outboundOrder.Details.First(x => x.Id == outboundOrderDetail.Id);
+ // outboundOrderDetail.OrderDetailStatus = OrderDetailStatusEnum.Over.ObjToInt();
+ // outboundOrderdetail.OverOutQuantity = outboundOrderDetail.OverOutQuantity;
+ // outboundOrderdetail.OrderDetailStatus = outboundOrderDetail.OrderDetailStatus;
+ // overCount++;
+ // }
+ // }
+ //}
outStockLockInfo.Status = OutLockStockStatusEnum.鍑哄簱瀹屾垚.ObjToInt();
}
- if (outboundOrder != null && outboundOrder.Details.Count == overCount)
- {
- outboundOrder.OrderStatus = OutboundStatusEnum.鍑哄簱瀹屾垚.ObjToInt();
- _outboundService.OutboundOrderDetailService.Repository.DeleteAndMoveIntoHty(outboundOrder.Details, App.User.UserId == 0 ? OperateType.鑷姩瀹屾垚 : OperateType.浜哄伐瀹屾垚);
- outboundOrder.Details = null;
- _outboundService.OutboundOrderService.Repository.DeleteAndMoveIntoHty(outboundOrder, App.User.UserId == 0 ? OperateType.鑷姩瀹屾垚 : OperateType.浜哄伐瀹屾垚);
- }
- else
- {
- if (outboundOrderDetail != null)
- _outboundService.OutboundOrderDetailService.Repository.UpdateData(outboundOrderDetail);
- }
+ //if (outboundOrder != null && outboundOrder.Details.Count == overCount)
+ //{
+ // outboundOrder.OrderStatus = OutboundStatusEnum.鍑哄簱瀹屾垚.ObjToInt();
+ // _outboundService.OutboundOrderDetailService.Repository.DeleteAndMoveIntoHty(outboundOrder.Details, App.User.UserId == 0 ? OperateType.鑷姩瀹屾垚 : OperateType.浜哄伐瀹屾垚);
+ // outboundOrder.Details = null;
+ // _outboundService.OutboundOrderService.Repository.DeleteAndMoveIntoHty(outboundOrder, App.User.UserId == 0 ? OperateType.鑷姩瀹屾垚 : OperateType.浜哄伐瀹屾垚);
+ //}
+ //else
+ //{
+ // if (outboundOrderDetail != null)
+ // _outboundService.OutboundOrderDetailService.Repository.UpdateData(outboundOrderDetail);
+ //}
BaseDal.DeleteAndMoveIntoHty(task, App.User.UserId == 0 ? OperateType.鑷姩瀹屾垚 : OperateType.浜哄伐瀹屾垚);
if (outStockLockInfo != null) _outboundService.OutboundStockLockInfoService.Repository.UpdateData(outStockLockInfo);
Db.Ado.CommitTran();
@@ -747,7 +792,7 @@
//stockInfo.SerialNumber = Targetlocation.CurrentQty;
stockInfo.StockStatus = StockStatusEmun.宸插叆搴�.ObjToInt();
if (Sourcelocation.CurrentQty == 0) Sourcelocation.LocationStatus = LocationStatusEnum.Free.ObjToInt();
- Dt_Task _Task = BaseDal.QueryFirst(x => x.TaskNum != task.TaskNum && x.TaskType == task.TaskType && x.SourceAddress == Sourcelocation.LocationCode && x.TargetAddress == Targetlocation.LocationCode);
+ Dt_Task _Task = BaseDal.QueryFirst(x => x.TaskId != task.TaskId && x.TaskType == task.TaskType && x.SourceAddress == Sourcelocation.LocationCode && x.TargetAddress == Targetlocation.LocationCode);
if (_Task == null)
{
if (Targetlocation.CurrentQty == Targetlocation.MaxQty) Targetlocation.LocationStatus = LocationStatusEnum.Fullload.ObjToInt();
@@ -794,7 +839,7 @@
inventoryInfo.InDate = DateTime.Now;
inventoryInfo.StockStatus = StockStatusEmun.宸插叆搴�.ObjToInt();
int beforeStatus = locationInfo.LocationStatus;
- if (BaseDal.QueryFirst(x => x.TargetAddress == locationInfo.LocationCode && x.TaskNum != task.TaskNum) == null)
+ if (BaseDal.QueryFirst(x => x.TargetAddress == locationInfo.LocationCode && x.TaskId != task.TaskId) == null)
locationInfo.LocationStatus = LocationStatusEnum.InStock.ObjToInt();
task.CurrentAddress = task.NextAddress;
task.NextAddress = string.Empty;
--
Gitblit v1.9.3