From b9f8212946fde1af1216b972996c32b8c8ed6363 Mon Sep 17 00:00:00 2001
From: hutongqing <hutongqing@hnkhzn.com>
Date: 星期三, 27 十一月 2024 10:07:34 +0800
Subject: [PATCH] Revert "Stop tracking D:\widesea\尖山立库\JianShanLiKu\代码管理\WCS\WIDESEAWCS_Server\WIDESEAWCS_BasicInfoRepository\bin"
---
代码管理/WMS/WIDESEA_WMSServer/WIDESEA_TaskInfoService/PartialTaskService_Outbound.cs | 347 +++++++++++++++++++++++++++++++++++++++++++++++++--------
1 files changed, 295 insertions(+), 52 deletions(-)
diff --git "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_TaskInfoService/PartialTaskService_Outbound.cs" "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_TaskInfoService/PartialTaskService_Outbound.cs"
index 4072b5c..7a886a0 100644
--- "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_TaskInfoService/PartialTaskService_Outbound.cs"
+++ "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_TaskInfoService/PartialTaskService_Outbound.cs"
@@ -16,6 +16,8 @@
using System.Security.Policy;
using static WIDESEA_ITaskInfoService.ITaskService;
using MailKit.Search;
+using WIDESEA_Common.Log;
+using OfficeOpenXml.FormulaParsing.Excel.Functions.DateTime;
namespace WIDESEA_TaskInfoService
{
@@ -424,7 +426,16 @@
{
Dt_LocationInfo newLocation;
//鏌ヨ蛋璐т綅锛岃繘琛岀敓鎴愮Щ搴撲换鍔�
- newLocation = _basicService.LocationInfoService.GetLocation(locationInfos.RoadwayNo); //鎷垮埌浜嗙Щ搴撳悗鐨勮揣浣�
+ int Locationtype = 9; //榛樿涓�9
+ if (dt_StockInfo.MaterialType == (int)InventoryMaterialType.鎴愬搧)
+ {
+ Locationtype = 11;
+ }
+ else if (dt_StockInfo.MaterialType == (int)InventoryMaterialType.鍘熸潗鏂�)
+ {
+ Locationtype = 10;
+ }
+ newLocation = _basicService.LocationInfoService.GetLocation(locationInfos.RoadwayNo,Locationtype); //鎷垮埌浜嗙Щ搴撳悗鐨勮揣浣�
if (newLocation != null)
{
Dt_Task dt_Task = new()
@@ -499,7 +510,12 @@
{
RoadwayNo = "2";
}
- Dt_LocationInfo locationInfos = _basicService.LocationInfoService.Repository.QueryFirst(x => x.RoadwayNo == RoadwayNo && x.LocationStatus == LocationStatusEnum.Pallet.ObjToInt());
+ Dt_LocationInfo locationInfos = _basicService.LocationInfoService.Repository.QueryFirst(x => x.RoadwayNo == RoadwayNo && x.Depth==1 && x.LocationStatus == LocationStatusEnum.Pallet.ObjToInt());
+ if(locationInfos == null)
+ {
+ locationInfos = _basicService.LocationInfoService.Repository.QueryFirst(x => x.RoadwayNo == RoadwayNo && x.Depth == 2 && x.LocationStatus == LocationStatusEnum.Pallet.ObjToInt());
+ }
+
if (locationInfos != null)
{
Dt_StockInfo dt_StockInfo = _stockService.StockInfoService.Repository.QueryFirst(x => x.LocationCode == locationInfos.LocationCode);
@@ -635,6 +651,7 @@
return content = WebResponseContent.Instance.Error($"鏈壘鍒板嚭搴撶殑搴撳瓨淇℃伅");
}
}
+
/// <summary>
/// 鎵嬪姩鐢熸垚鍑哄簱浠诲姟
/// </summary>
@@ -643,7 +660,6 @@
public WebResponseContent ManualOutbound(SaveModel saveModel)
{
WebResponseContent content = new WebResponseContent();
-
try
{
List<Dt_StockInfo> dtstockt = new List<Dt_StockInfo>();
@@ -653,74 +669,83 @@
for (int i = 0; i < saveModel.DelKeys.Count; i++)
{
Dt_StockInfo stockt = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == saveModel.DelKeys[i].ToString());
- if (stockt.StockStatus != (int)StockStatusEmun.宸插叆搴�)
+ if (stockt.StockStatus == (int)StockStatusEmun.宸插叆搴�)
{
- Dt_StockInfoDetail stocktdetail = _stockService.StockInfoDetailService.Repository.QueryFirst(x => x.StockId == stockt.Id);
- stockt.StockStatus = (int)StockStatusEmun.鍑哄簱閿佸畾;
- if (stockt.MaterialType != (int)InventoryMaterialType.绌烘墭)
+ if(stockt.MaterialType != (int)InventoryMaterialType.鍘熸潗鏂�)
{
- stocktdetail.Status = (int)StockStatusEmun.鍑哄簱閿佸畾;
- }
- Dt_LocationInfo locationinfo = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == stockt.LocationCode);
- if (locationinfo.LocationStatus == LocationStatusEnum.InStock.ObjToInt())
- {
- locationinfo.LocationStatus = LocationStatusEnum.Lock.ObjToInt();
- }
- else if (locationinfo.LocationStatus == LocationStatusEnum.Pallet.ObjToInt())
- {
- locationinfo.LocationStatus = LocationStatusEnum.PalletLock.ObjToInt();
- }
- string LocationName = "R01-002-044-001-01";
- if (stockt.MaterialType == (int)InventoryMaterialType.鍘熸潗鏂�)
- {
+ Dt_StockInfoDetail stocktdetail = _stockService.StockInfoDetailService.Repository.QueryFirst(x => x.StockId == stockt.Id);
+ stockt.StockStatus = (int)StockStatusEmun.鍑哄簱閿佸畾;
+ if (stockt.MaterialType != (int)InventoryMaterialType.绌烘墭)
+ {
+ stocktdetail.Status = (int)StockStatusEmun.鍑哄簱閿佸畾;
+ }
+ Dt_LocationInfo locationinfo = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == stockt.LocationCode);
if (locationinfo.RoadwayNo == "1")
{
- LocationName = "R01-003-041-011-01";
+ if (locationinfo.LocationStatus == LocationStatusEnum.InStock.ObjToInt())
+ {
+ locationinfo.LocationStatus = LocationStatusEnum.Lock.ObjToInt();
+ }
+ else if (locationinfo.LocationStatus == LocationStatusEnum.Pallet.ObjToInt())
+ {
+ locationinfo.LocationStatus = LocationStatusEnum.PalletLock.ObjToInt();
+ }
+ string LocationName = "R01-002-044-001-01";
+ if (stockt.MaterialType == (int)InventoryMaterialType.绌烘墭)
+ {
+ LocationName = "R01-002-043-001-01";
+ }
+ Dt_LocationInfo newTargetAddress;
+ newTargetAddress = _basicService.LocationInfoService.GetLocationplatform(LocationName);
+ Dt_Task dt_Task = new()
+ {
+ PalletCode = stockt.PalletCode,
+ TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum)),
+ Roadway = newTargetAddress.RoadwayNo,
+ TaskType = TaskTypeEnum.Outbound.ObjToInt(),
+ TaskStatus = InTaskStatusEnum.InNew.ObjToInt(),
+ SourceAddress = locationinfo.LocationCode,
+ TargetAddress = newTargetAddress.LocationCode,
+ CurrentAddress = locationinfo.LocationCode,
+ NextAddress = newTargetAddress.LocationCode,
+ Grade = 1,
+ Creater = "WMS",
+ Depth = locationinfo.Depth,
+ CreateDate = DateTime.Now,
+ };
+ dtstockt.Add(stockt);
+ locations.Add(locationinfo);
+ taskdt.Add(dt_Task);
+ if (stockt.MaterialType != (int)InventoryMaterialType.绌烘墭)
+ {
+ dtstocktdetail.Add(stocktdetail);
+ }
}
else
{
- LocationName = "R02-003-027-011-01";
+ return content = WebResponseContent.Instance.Error($"鍑哄簱澶辫触锛屽彧鍙嚭搴�1宸烽亾鐨勬墭鐩樺拰鎴愬搧");
}
}
- Dt_LocationInfo newTargetAddress;
- newTargetAddress = _basicService.LocationInfoService.GetLocationplatform(LocationName);
- Dt_Task dt_Task = new()
+ else
{
- PalletCode = stockt.PalletCode,
- TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum)),
- Roadway = newTargetAddress.RoadwayNo,
- TaskType = TaskTypeEnum.Outbound.ObjToInt(),
- TaskStatus = InTaskStatusEnum.InNew.ObjToInt(),
- SourceAddress = locationinfo.LocationCode,
- TargetAddress = newTargetAddress.LocationCode,
- CurrentAddress = locationinfo.LocationCode,
- NextAddress = newTargetAddress.LocationCode,
- Grade = 1,
- Creater = "WMS",
- Depth = locationinfo.Depth,
- CreateDate = DateTime.Now,
- };
- dtstockt.Add(stockt);
- locations.Add(locationinfo);
- taskdt.Add(dt_Task);
- if (stockt.MaterialType != (int)InventoryMaterialType.绌烘墭)
- {
- dtstocktdetail.Add(stocktdetail);
+ return content = WebResponseContent.Instance.Error($"鍑哄簱澶辫触锛岃涓嶈閫夋嫨鍘熸潗鏂欏嚭搴�");
}
}
else
{
- return content = WebResponseContent.Instance.Error($"鍑哄簱澶辫触锛岃搴撳瓨淇℃伅涓嶅彲杩涜鍑哄簱");
+ return content = WebResponseContent.Instance.Error($"鍑哄簱澶辫触锛岃閫夋嫨宸插叆搴撶殑搴撳瓨淇℃伅杩涜鍑哄簱");
}
}
var responses = HttpHelper.Post<WebResponseContent>(ReceiveWMSTask, taskdt, "涓嬪彂浠诲姟鍏ュ簱");
_unitOfWorkManage.BeginTran();
- _stockService.StockInfoService.Repository.UpdateData(dtstockt);
- _stockService.StockInfoDetailService.Repository.UpdateData(dtstocktdetail);
- _basicService.LocationInfoService.Repository.UpdateData(locations);
- BaseDal.AddData(taskdt);
-
+ if (dtstockt.Count > 0)
+ {
+ _stockService.StockInfoService.Repository.UpdateData(dtstockt);
+ _stockService.StockInfoDetailService.Repository.UpdateData(dtstocktdetail);
+ _basicService.LocationInfoService.Repository.UpdateData(locations);
+ BaseDal.AddData(taskdt);
+ }
_unitOfWorkManage.CommitTran();
content = WebResponseContent.Instance.OK();
return content;
@@ -732,6 +757,98 @@
throw;
}
}
+
+
+ public WebResponseContent ManualOutbound2(SaveModel saveModel)
+ {
+ WebResponseContent content = new WebResponseContent();
+ try
+ {
+ List<Dt_StockInfo> dtstockt = new List<Dt_StockInfo>();
+ List<Dt_LocationInfo> locations = new List<Dt_LocationInfo>();
+ List<Dt_Task> taskdt = new List<Dt_Task>();
+ List<Dt_StockInfoDetail> dtstocktdetail = new List<Dt_StockInfoDetail>();
+
+
+ List<Dt_StockInfo> stocktData= _stockService.StockInfoService.Repository.QueryData(x=>x.StockStatus== (int)StockStatusEmun.宸插叆搴� && x.MaterialType == (int)InventoryMaterialType.鍘熸潗鏂�);
+ List<Dt_LocationInfo> locationinfoData = _basicService.LocationInfoService.Repository.QueryData(x =>x.LocationStatus == LocationStatusEnum.InStock.ObjToInt());
+ List<Dt_StockInfoDetail> StockInfoDetailData = _stockService.StockInfoDetailService.Repository.QueryData(x => x.Status == (int)StockStatusEmun.宸插叆搴�);
+
+
+ string json = saveModel.DelKeys[0].ToString();
+ List<string> palletCodes = JsonConvert.DeserializeObject<List<string>>(json);
+
+ foreach (var palletCode in palletCodes)
+ {
+ Dt_StockInfo stockt = stocktData.FirstOrDefault(x => x.PalletCode == palletCode);
+ if (stockt !=null)
+ {
+ if (stockt.StockStatus == (int)StockStatusEmun.宸插叆搴�)
+ {
+ Dt_StockInfoDetail stocktdetail = StockInfoDetailData.FirstOrDefault(x => x.StockId == stockt.Id);
+ if(stocktdetail != null)
+ {
+ Dt_LocationInfo locationinfo = locationinfoData.FirstOrDefault(x => x.LocationCode == stockt.LocationCode);
+ if(locationinfo != null)
+ {
+ stockt.StockStatus = (int)StockStatusEmun.鍑哄簱閿佸畾;
+ if (locationinfo.LocationStatus == LocationStatusEnum.InStock.ObjToInt())
+ {
+ locationinfo.LocationStatus = LocationStatusEnum.Lock.ObjToInt();
+ }
+ Dt_Task dt_Task = new()
+ {
+ PalletCode = stockt.PalletCode,
+ TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum)),
+ Roadway = locationinfo.RoadwayNo,
+ TaskType = TaskTypeEnum.Outbound.ObjToInt(),
+ TaskStatus = InTaskStatusEnum.InNew.ObjToInt(),
+ SourceAddress = locationinfo.LocationCode,
+ TargetAddress = locationinfo.RoadwayNo == "2" ? "R02-002-027-011-01" : "R01-002-041-011-01",
+ CurrentAddress = locationinfo.LocationCode,
+ NextAddress = locationinfo.RoadwayNo == "2" ? "R02-002-027-011-01" : "R01-002-041-011-01",
+ Grade = 1,
+ Creater = "WMS",
+ Depth = locationinfo.Depth,
+ CreateDate = DateTime.Now,
+ PLCTo = int.Parse(saveModel.DelKeys[1].ToString()),
+
+ };
+ dtstockt.Add(stockt);
+ locations.Add(locationinfo);
+ taskdt.Add(dt_Task);
+ dtstocktdetail.Add(stocktdetail);
+ }
+ }
+ }
+ }
+ }
+ var responses = HttpHelper.Post<WebResponseContent>(ReceiveWMSTask, taskdt, "涓嬪彂浠诲姟鍏ュ簱");
+ _unitOfWorkManage.BeginTran();
+ if(dtstockt.Count > 0)
+ {
+ _stockService.StockInfoService.Repository.UpdateData(dtstockt);
+ _stockService.StockInfoDetailService.Repository.UpdateData(dtstocktdetail);
+ _basicService.LocationInfoService.Repository.UpdateData(locations);
+ BaseDal.AddData(taskdt);
+ }
+ _unitOfWorkManage.CommitTran();
+ content = WebResponseContent.Instance.OK($"鍑哄簱鎴愬姛锛屽嚭搴撴�绘暟锛歿palletCodes.Count}锛屾垚鍔熸暟閲忥細{dtstockt.Count}");
+ return content;
+ }
+ catch (Exception ex)
+ {
+ _unitOfWorkManage.RollbackTran();
+ return content = WebResponseContent.Instance.Error($"鍑哄簱澶辫触锛屾姤閿欎俊鎭細{ex.Message}");
+ throw;
+ }
+ }
+
+ public class PalletCodeList
+ {
+ public string PalletCode { get; set; }
+ }
+
public (Dt_Task?, Dt_LocationInfo?) AddRelocationTask(Dt_LocationInfo location, Dt_StockInfo stockInfo, Dt_Task task)
{
@@ -928,5 +1045,131 @@
}
return (null, LocationStatusEnum.Free.ObjToInt());
}
+
+ /// <summary>
+ /// 浜哄伐鎵嬪姩鍑哄簱锛堝垹闄ゅ簱瀛橈級
+ /// </summary>
+ /// <param name="saveModel"></param>
+ /// <returns></returns>
+ public WebResponseContent ManualOutboundDeleteinventory(SaveModel saveModel)
+ {
+ WebResponseContent content = new WebResponseContent();
+ try
+ {
+ List<Dt_StockInfo> dtstockt = new List<Dt_StockInfo>();
+ List<Dt_LocationInfo> locations = new List<Dt_LocationInfo>();
+ List<Dt_StockInfoDetail> dtstocktdetail = new List<Dt_StockInfoDetail>();
+
+ for (int i = 0; i < saveModel.DelKeys.Count; i++)
+ {
+ Dt_StockInfo stockt = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == saveModel.DelKeys[i].ToString());
+ if (stockt.StockStatus == (int)StockStatusEmun.宸插叆搴�)
+ {
+ Dt_StockInfoDetail stocktdetail = _stockService.StockInfoDetailService.Repository.QueryFirst(x => x.StockId == stockt.Id);
+ Dt_LocationInfo locationinfo = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == stockt.LocationCode);
+ locationinfo.LocationStatus = LocationStatusEnum.Free.ObjToInt();
+ dtstockt.Add(stockt);
+ locations.Add(locationinfo);
+ if (stockt.MaterialType == (int)InventoryMaterialType.绌烘墭)
+ {
+ dtstocktdetail.Add(stocktdetail);
+ }
+ WriteLog.GetLog("浜哄伐鎵嬪姩鍒犻櫎搴撳瓨淇℃伅").Write($"鎵樼洏鏉＄爜锛歿stockt.PalletCode},搴撲綅缂栧彿锛歿stockt.LocationCode}", $"浜哄伐鍑哄簱搴撳瓨");
+ }
+ else
+ {
+ return content = WebResponseContent.Instance.Error($"鍑哄簱澶辫触锛岃搴撳瓨淇℃伅涓嶅彲杩涜鍑哄簱");
+ }
+
+ }
+ _unitOfWorkManage.BeginTran();
+ _stockService.StockInfoService.Repository.DeleteData(dtstockt);
+ if(dtstocktdetail.Count==0)
+ {
+ _stockService.StockInfoDetailService.Repository.DeleteData(dtstocktdetail);
+ }
+ _basicService.LocationInfoService.Repository.UpdateData(locations);
+ _unitOfWorkManage.CommitTran();
+ content = WebResponseContent.Instance.OK();
+ return content;
+ }
+ catch (Exception ex)
+ {
+ _unitOfWorkManage.RollbackTran();
+ return content = WebResponseContent.Instance.Error($"鎵嬪姩鍑哄簱淇℃伅澶辫触锛屾姤閿欎俊鎭細{ex.Message}");
+ throw;
+ }
+ }
+
+ /// <summary>
+ /// 浠诲姟鍙栨秷
+ /// </summary>
+ /// <param name="saveModel"></param>
+ /// <returns></returns>
+ public WebResponseContent Cancelinventory(int taskNum)
+ {
+ WebResponseContent content = new WebResponseContent();
+ Dt_Task task = BaseDal.QueryFirst(x => x.TaskNum == taskNum);
+ if(task != null)
+ {
+ if(task.TaskType== (int)TaskTypeEnum.Outbound || task.TaskType == (int)TaskTypeEnum.PalletOutbound)
+ {
+ //澶勭悊鍑哄簱鐨勯�昏緫
+ Dt_LocationInfo locationinfo = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == task.SourceAddress);
+ if (locationinfo.LocationStatus == LocationStatusEnum.Lock.ObjToInt())
+ {
+ locationinfo.LocationStatus = LocationStatusEnum.InStock.ObjToInt();
+ }
+ if (locationinfo.LocationStatus == LocationStatusEnum.PalletLock.ObjToInt())
+ {
+ locationinfo.LocationStatus = LocationStatusEnum.Pallet.ObjToInt();
+ }
+ _basicService.LocationInfoService.Repository.UpdateData(locationinfo);
+ Dt_StockInfo stockInfo = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == task.PalletCode);
+ stockInfo.StockStatus = (int)StockStatusEmun.宸插叆搴�;
+ _stockService.StockInfoService.Repository.UpdateData(stockInfo);
+ Dt_StockInfoDetail stocktdetail = _stockService.StockInfoDetailService.Repository.QueryFirst(x => x.StockId == stockInfo.Id);
+ if(stocktdetail != null)
+ {
+ stocktdetail.Status = (int)StockStatusEmun.宸插叆搴�;
+ _stockService.StockInfoDetailService.Repository.UpdateData(stocktdetail);
+ }
+ BaseDal.DeleteData(task);
+ BaseDal.DeleteAndMoveIntoHty(task, OperateType.浜哄伐鍒犻櫎);
+ WriteLog.GetLog("浠诲姟鏃ュ織").Write($"鍑哄簱浠诲姟鍙栨秷鎴愬姛锛屾墭鐩樻潯鐮侊細{task.PalletCode}", $"浠诲姟鍙栨秷");
+ return content = WebResponseContent.Instance.Error($"鍑哄簱浠诲姟鍙栨秷鎴愬姛");
+
+ }
+ else if(task.TaskType == (int)TaskTypeEnum.Inbound || task.TaskType == (int)TaskTypeEnum.PalletInbound)
+ {
+ //澶勭悊鍑哄簱鐨勯�昏緫
+ Dt_LocationInfo locationinfo = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == task.TargetAddress);
+ if (locationinfo.LocationStatus == LocationStatusEnum.Lock.ObjToInt() || locationinfo.LocationStatus == LocationStatusEnum.PalletLock.ObjToInt())
+ {
+ locationinfo.LocationStatus = LocationStatusEnum.Free.ObjToInt();
+ }
+ _basicService.LocationInfoService.Repository.UpdateData(locationinfo);
+ Dt_StockInfo stockInfo = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == task.PalletCode);
+ _stockService.StockInfoService.Repository.DeleteData(stockInfo);
+ Dt_StockInfoDetail stocktdetail = _stockService.StockInfoDetailService.Repository.QueryFirst(x => x.StockId == stockInfo.Id);
+ if (stocktdetail != null)
+ {
+ _stockService.StockInfoDetailService.Repository.DeleteData(stocktdetail);
+ }
+ BaseDal.DeleteData(task);
+ BaseDal.DeleteAndMoveIntoHty(task, OperateType.浜哄伐鍒犻櫎);
+ WriteLog.GetLog("浠诲姟鏃ュ織").Write($"鍏ュ簱浠诲姟鍙栨秷鎴愬姛锛屾墭鐩樻潯鐮侊細{task.PalletCode}", $"浠诲姟鍙栨秷");
+ return content = WebResponseContent.Instance.Error($"鍏ュ簱浠诲姟鍙栨秷鎴愬姛");
+ }
+ else
+ {
+ return content = WebResponseContent.Instance.Error($"璇ヤ换鍔＄殑浠诲姟绫诲瀷寮傚父锛屽彇娑堝け璐�");
+ }
+ }
+ else
+ {
+ return content = WebResponseContent.Instance.Error($"鏈壘鍒颁换鍔″彿");
+ }
+ }
}
}
--
Gitblit v1.9.3