From 695571c6009ecbc12e7d4a4fb147df7967a1260e Mon Sep 17 00:00:00 2001
From: wangxinhui <wangxinhui@hnkhzn.com>
Date: 星期一, 07 七月 2025 20:21:19 +0800
Subject: [PATCH] Merge branch 'master' of http://115.159.85.185:8098/r/MeiRuiAn/HuaiAn
---
代码管理/WMS/WIDESEA_WMSServer/WIDESEA_BasicService/Service/LocationInfoService_Common.cs | 381 ++++++++++++++++++++++++++++++------------------------
1 files changed, 210 insertions(+), 171 deletions(-)
diff --git "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_BasicService/Service/LocationInfoService_Common.cs" "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_BasicService/Service/LocationInfoService_Common.cs"
index 5fc6872..82ca087 100644
--- "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_BasicService/Service/LocationInfoService_Common.cs"
+++ "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_BasicService/Service/LocationInfoService_Common.cs"
@@ -26,7 +26,7 @@
public partial class LocationInfoService
{
- public Dt_LocationInfo? AssignLocation(string roadwayNo, int palletType, int warehouseId)
+ public Dt_LocationInfo? AssignLocation(string roadwayNo, int palletType, int warehouseId, string beRelocationCode = "", int heightType = 0)
{
Dt_Warehouse warehouse = _basicRepository.WarehouseRepository.QueryFirst(x => x.WarehouseId == warehouseId);
if (warehouse == null)
@@ -51,13 +51,13 @@
return warehouse.WarehouseCode switch
{
- "HA57" => AssignLocation_BC(roadwayNo, palletType, palletTypeInfo),
- "HA58" => AssignLocation_PP(roadwayNo, palletType, palletTypeInfo),
- "HA152" => AssignLocation_GM(roadwayNo, palletType, palletTypeInfo),
- "HA64" => AssignLocation_CSJ(roadwayNo, palletType, palletTypeInfo),
- "闃荤剨浠�" => AssignLocation_ZH(roadwayNo, palletType, palletTypeInfo),
+ "HA57" => AssignLocation_BC(roadwayNo, palletType, palletTypeInfo, beRelocationCode, heightType),
+ "HA58" => AssignLocation_PP(roadwayNo, palletType, palletTypeInfo, beRelocationCode),
+ "HA152" => AssignLocation_GM(roadwayNo, palletType, palletTypeInfo, beRelocationCode),
+ "HA64" => AssignLocation_CSJ(roadwayNo, palletType, palletTypeInfo, beRelocationCode),
+ "HA154" => AssignLocation_ZH(roadwayNo, palletType, palletTypeInfo, beRelocationCode),
"HA153" => AssignLocation(roadwayNo),
- "HA71" => AssignLocation(roadwayNo),
+ "HA71" or "HA72" or "HA73" => AssignLocation(roadwayNo),
"HA60" => AssignLocation(roadwayNo),
_ => throw new Exception($"鏈壘鍒颁粨搴撹揣浣嶅垎閰嶆柟娉�")
};
@@ -93,7 +93,7 @@
{ nameof(Dt_LocationInfo.Row),OrderByType.Asc }
};
- return BaseDal.QueryFirst(x => x.RoadwayNo == roadwayNo && x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && !lockLocations.Contains(x.LocationCode), orderBy);//鏌ヨ绌鸿揣浣嶄俊鎭苟鎺掗櫎5鍒嗛挓鍐呭垎閰嶇殑璐т綅,鏍规嵁灞傘�佸垪銆佹繁搴︺�佽鎺掑簭
+ return BaseDal.QueryFirst(x => x.RoadwayNo == roadwayNo && x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && x.EnableStatus != EnableStatusEnum.Disable.ObjToInt() && !lockLocations.Contains(x.LocationCode), orderBy);//鏌ヨ绌鸿揣浣嶄俊鎭苟鎺掗櫎5鍒嗛挓鍐呭垎閰嶇殑璐т綅,鏍规嵁灞傘�佸垪銆佹繁搴︺�佽鎺掑簭
}
}
@@ -119,149 +119,153 @@
/// <param name="location">璐т綅瀵硅薄</param>
/// <param name="palletType">鎵樼洏绫诲瀷</param>
/// <param name="locationStatus">璐т綅鐘舵��</param>
- public void UpdateLocationStatus2(Dt_LocationInfo location, int palletType, LocationStatusEnum locationStatus, int warehousId)
- {
- List<Dt_LocationInfo> locationInfos = Repository.QueryData(x => x.RoadwayNo == location.RoadwayNo);
+ //public void UpdateLocationStatus2(Dt_LocationInfo location, int palletType, LocationStatusEnum locationStatus, int warehousId)
+ //{
+ // List<Dt_LocationInfo> locationInfos = Repository.QueryData(x => x.RoadwayNo == location.RoadwayNo);
- List<Dt_LocationInfo> locations = GetGroupLocations(locationInfos, location);
- if (locationInfos.Max(x => x.Depth) < 3)
- {
- for (int i = 0; i < locations.Count; i++)
- {
- if (locations[i].LocationType != palletType.ObjToInt())
- {
- locations[i].LocationType = palletType.ObjToInt();
- }
+ // List<Dt_LocationInfo> locations = GetGroupLocations(locationInfos, location);
+ // if (locationInfos.Max(x => x.Depth) < 3)
+ // {
+ // for (int i = 0; i < locations.Count; i++)
+ // {
+ // if (locations[i].LocationType != palletType.ObjToInt())
+ // {
+ // locations[i].LocationType = palletType.ObjToInt();
+ // }
- if (locations[i].LocationCode == location.LocationCode)
- {
- locations[i].LocationStatus = locationStatus.ObjToInt();
- }
- else
- {
- if (locationStatus == LocationStatusEnum.Lock)
- {
- if (locations[i].LocationStatus == LocationStatusEnum.InStock.ObjToInt())
- {
- locations[i].LocationStatus = LocationStatusEnum.InStockLock.ObjToInt();
- }
- else if (locations[i].LocationStatus == LocationStatusEnum.Free.ObjToInt())
- {
- locations[i].LocationStatus = LocationStatusEnum.FreeLock.ObjToInt();
- }
- }
- else if (locationStatus == LocationStatusEnum.Free || locationStatus == LocationStatusEnum.InStock)
- {
- if (locations[i].LocationStatus == LocationStatusEnum.InStockLock.ObjToInt())
- {
- locations[i].LocationStatus = LocationStatusEnum.InStock.ObjToInt();
- }
- else if (locations[i].LocationStatus == LocationStatusEnum.FreeLock.ObjToInt())
- {
- locations[i].LocationStatus = LocationStatusEnum.Free.ObjToInt();
- }
- }
- }
- }
+ // if (locations[i].LocationCode == location.LocationCode)
+ // {
+ // locations[i].LocationStatus = locationStatus.ObjToInt();
+ // }
+ // else
+ // {
+ // if (locationStatus == LocationStatusEnum.Lock)
+ // {
+ // if (locations[i].LocationStatus == LocationStatusEnum.InStock.ObjToInt())
+ // {
+ // locations[i].LocationStatus = LocationStatusEnum.InStockLock.ObjToInt();
+ // }
+ // else if (locations[i].LocationStatus == LocationStatusEnum.Free.ObjToInt())
+ // {
+ // locations[i].LocationStatus = LocationStatusEnum.FreeLock.ObjToInt();
+ // }
+ // }
+ // else if (locationStatus == LocationStatusEnum.Free || locationStatus == LocationStatusEnum.InStock)
+ // {
+ // if (locations[i].LocationStatus == LocationStatusEnum.InStockLock.ObjToInt())
+ // {
+ // locations[i].LocationStatus = LocationStatusEnum.InStock.ObjToInt();
+ // }
+ // else if (locations[i].LocationStatus == LocationStatusEnum.FreeLock.ObjToInt())
+ // {
+ // locations[i].LocationStatus = LocationStatusEnum.Free.ObjToInt();
+ // }
+ // }
+ // }
+ // }
- Dt_LocationInfo? nearLocation = locationInfos.FirstOrDefault(x => x.Row == location.Row && x.Layer == location.Layer && x.Depth == location.Depth && x.Column == location.Column + 1);
- if (nearLocation != null)
- {
- List<Dt_LocationInfo> nearLocations = GetGroupLocations(locationInfos, nearLocation);
- for (int i = 0; i < nearLocations.Count; i++)
- {
- if (nearLocations[i].LocationType != palletType.ObjToInt())
- {
- nearLocations[i].LocationType = palletType.ObjToInt();
- }
+ // Dt_LocationInfo? nearLocation = locationInfos.FirstOrDefault(x => x.Row == location.Row && x.Layer == location.Layer && x.Depth == location.Depth && x.Column == location.Column + 1);
+ // if(location.RoadwayNo == "SC01_BC")
+ // {
+ // nearLocation = locationInfos.FirstOrDefault(x => x.Row == location.Row && x.Layer == location.Layer && x.Depth == location.Depth && x.Column == location.Column + 1);
+ // }
+ // if (nearLocation != null)
+ // {
+ // List<Dt_LocationInfo> nearLocations = GetGroupLocations(locationInfos, nearLocation);
+ // for (int i = 0; i < nearLocations.Count; i++)
+ // {
+ // if (nearLocations[i].LocationType != palletType.ObjToInt())
+ // {
+ // nearLocations[i].LocationType = palletType.ObjToInt();
+ // }
- if (palletType.ObjToInt() >= PalletTypeEnum.LargePallet.ObjToInt())
- {
- if (nearLocations[i].LocationCode == nearLocation.LocationCode)
- {
- nearLocations[i].LocationStatus = locationStatus.ObjToInt();
- }
- else
- {
- if (locationStatus == LocationStatusEnum.Lock)
- {
- if (nearLocations[i].LocationStatus == LocationStatusEnum.InStock.ObjToInt())
- {
- nearLocations[i].LocationStatus = LocationStatusEnum.InStockLock.ObjToInt();
- }
- else if (nearLocations[i].LocationStatus == LocationStatusEnum.Free.ObjToInt())
- {
- nearLocations[i].LocationStatus = LocationStatusEnum.FreeLock.ObjToInt();
- }
- }
- else if (locationStatus == LocationStatusEnum.InStock)
- {
- if (nearLocations[i].LocationStatus == LocationStatusEnum.InStockLock.ObjToInt())
- {
- nearLocations[i].LocationStatus = LocationStatusEnum.InStock.ObjToInt();
- }
- else if (nearLocations[i].LocationStatus == LocationStatusEnum.FreeLock.ObjToInt())
- {
- nearLocations[i].LocationStatus = LocationStatusEnum.Free.ObjToInt();
- }
- }
- }
- }
+ // if (palletType.ObjToInt() >= PalletTypeEnum.LargePallet.ObjToInt())
+ // {
+ // if (nearLocations[i].LocationCode == nearLocation.LocationCode)
+ // {
+ // nearLocations[i].LocationStatus = locationStatus.ObjToInt();
+ // }
+ // else
+ // {
+ // if (locationStatus == LocationStatusEnum.Lock)
+ // {
+ // if (nearLocations[i].LocationStatus == LocationStatusEnum.InStock.ObjToInt())
+ // {
+ // nearLocations[i].LocationStatus = LocationStatusEnum.InStockLock.ObjToInt();
+ // }
+ // else if (nearLocations[i].LocationStatus == LocationStatusEnum.Free.ObjToInt())
+ // {
+ // nearLocations[i].LocationStatus = LocationStatusEnum.FreeLock.ObjToInt();
+ // }
+ // }
+ // else if (locationStatus == LocationStatusEnum.InStock)
+ // {
+ // if (nearLocations[i].LocationStatus == LocationStatusEnum.InStockLock.ObjToInt())
+ // {
+ // nearLocations[i].LocationStatus = LocationStatusEnum.InStock.ObjToInt();
+ // }
+ // else if (nearLocations[i].LocationStatus == LocationStatusEnum.FreeLock.ObjToInt())
+ // {
+ // nearLocations[i].LocationStatus = LocationStatusEnum.Free.ObjToInt();
+ // }
+ // }
+ // }
+ // }
- }
- locations.AddRange(nearLocations);
- }
- }
- else
- {
- for (int i = 0; i < locations.Count; i++)
- {
- if (locations[i].LocationCode == location.LocationCode)
- {
- locations[i].LocationStatus = locationStatus.ObjToInt();
- }
- else
- {
- if (locationStatus == LocationStatusEnum.Lock)
- {
- if (locations[i].LocationStatus == LocationStatusEnum.InStock.ObjToInt())
- {
- locations[i].LocationStatus = LocationStatusEnum.InStockLock.ObjToInt();
- }
- else if (locations[i].LocationStatus == LocationStatusEnum.Free.ObjToInt())
- {
- locations[i].LocationStatus = LocationStatusEnum.FreeLock.ObjToInt();
- }
- }
- else if (locationStatus == LocationStatusEnum.Free || locationStatus == LocationStatusEnum.InStock)
- {
- if (locations[i].LocationStatus == LocationStatusEnum.InStockLock.ObjToInt())
- {
- locations[i].LocationStatus = LocationStatusEnum.InStock.ObjToInt();
- }
- else if (locations[i].LocationStatus == LocationStatusEnum.FreeLock.ObjToInt())
- {
- locations[i].LocationStatus = LocationStatusEnum.Free.ObjToInt();
- }
- }
- }
- if (locations[i].LocationType != palletType.ObjToInt())
- {
- locations[i].LocationType = palletType.ObjToInt();
- }
- }
- }
+ // }
+ // locations.AddRange(nearLocations);
+ // }
+ // }
+ // else
+ // {
+ // for (int i = 0; i < locations.Count; i++)
+ // {
+ // if (locations[i].LocationCode == location.LocationCode)
+ // {
+ // locations[i].LocationStatus = locationStatus.ObjToInt();
+ // }
+ // else
+ // {
+ // if (locationStatus == LocationStatusEnum.Lock)
+ // {
+ // if (locations[i].LocationStatus == LocationStatusEnum.InStock.ObjToInt())
+ // {
+ // locations[i].LocationStatus = LocationStatusEnum.InStockLock.ObjToInt();
+ // }
+ // else if (locations[i].LocationStatus == LocationStatusEnum.Free.ObjToInt())
+ // {
+ // locations[i].LocationStatus = LocationStatusEnum.FreeLock.ObjToInt();
+ // }
+ // }
+ // else if (locationStatus == LocationStatusEnum.Free || locationStatus == LocationStatusEnum.InStock)
+ // {
+ // if (locations[i].LocationStatus == LocationStatusEnum.InStockLock.ObjToInt())
+ // {
+ // locations[i].LocationStatus = LocationStatusEnum.InStock.ObjToInt();
+ // }
+ // else if (locations[i].LocationStatus == LocationStatusEnum.FreeLock.ObjToInt())
+ // {
+ // locations[i].LocationStatus = LocationStatusEnum.Free.ObjToInt();
+ // }
+ // }
+ // }
+ // if (locations[i].LocationType != palletType.ObjToInt())
+ // {
+ // locations[i].LocationType = palletType.ObjToInt();
+ // }
+ // }
+ // }
- if (locations.Where(x => x.LocationStatus == LocationStatusEnum.Free.ObjToInt()).Count() == locations.Count && locationStatus == LocationStatusEnum.Free)
- {
- locations.ForEach(x =>
- {
- x.LocationType = 0;
- });
- }
+ // if (locations.Where(x => x.LocationStatus == LocationStatusEnum.Free.ObjToInt()).Count() == locations.Count && locationStatus == LocationStatusEnum.Free)
+ // {
+ // locations.ForEach(x =>
+ // {
+ // x.LocationType = 0;
+ // });
+ // }
- Repository.UpdateData(locations);
- }
+ // Repository.UpdateData(locations);
+ //}
public void UpdateLocationStatus(Dt_LocationInfo location, int palletType, LocationStatusEnum locationStatus, int warehousId)
{
@@ -270,7 +274,7 @@
List<Dt_PalletTypeInfo> palletTypeInfos = _basicRepository.PalletTypeInfoRepository.QueryData(x => x.WarehouseId == warehousId);
Dt_Warehouse warehouse = _basicRepository.WarehouseRepository.QueryFirst(x => x.WarehouseId == warehousId);
Dt_PalletTypeInfo? palletTypeInfo = palletTypeInfos.FirstOrDefault(x => x.PalletType == palletType && x.WarehouseId == warehousId);
- if (palletTypeInfo == null)
+ if (palletTypeInfo == null || warehouse.WarehouseCode == WarehouseEnum.HA60.ToString())
{
if (warehouse.WarehouseCode == WarehouseEnum.HA153.ToString() || warehouse.WarehouseCode == WarehouseEnum.HA71.ToString() || warehouse.WarehouseCode == WarehouseEnum.HA60.ToString())
{
@@ -330,11 +334,34 @@
Dt_LocationInfo? nearLocation;
if (palletTypeInfo.IsOdd)
{
- nearLocation = locationInfos.FirstOrDefault(x => x.Row == location.Row && x.Layer == location.Layer && x.Depth == location.Depth && x.Column == location.Column + 1);
+ if (warehouse.WarehouseCode==WarehouseEnum.HA154.ToString())
+ {
+ nearLocation = locationInfos.FirstOrDefault(x => x.Row == location.Row && x.Layer == location.Layer && x.Depth == location.Depth && x.Column == location.Column - 1);
+ }
+ else
+ {
+ nearLocation = locationInfos.FirstOrDefault(x => x.Row == location.Row && x.Layer == location.Layer && x.Depth == location.Depth && x.Column == location.Column + 1);
+ }
}
else
{
nearLocation = locationInfos.FirstOrDefault(x => x.Row == location.Row && x.Layer == location.Layer && x.Depth == location.Depth && x.Column == location.Column - 1);
+ }
+
+ if (nearLocation!=null && location.RoadwayNo.Contains("BC"))
+ {
+ if (nearLocation?.LocationType == LocationTypeEnum.SmallPallet.ObjToInt())
+ {
+ nearLocation = null;
+ }
+ }
+ if (location.RoadwayNo == "SC01_BC" && palletType != PalletTypeEnum.SmallPallet.ObjToInt())
+ {
+ nearLocation = locationInfos.FirstOrDefault(x => x.Row == location.Row && x.Layer == location.Layer && x.Depth == location.Depth && x.Column == location.Column - 1);
+ if (nearLocation?.LocationType == LocationTypeEnum.SmallPallet.ObjToInt())
+ {
+ nearLocation = null;
+ }
}
if (nearLocation != null)
@@ -342,34 +369,38 @@
List<Dt_LocationInfo> nearLocations = GetGroupLocations(locationInfos, nearLocation);
for (int i = 0; i < nearLocations.Count; i++)
{
- if (nearLocations[i].LocationType != palletType)
+ List<int> palletTypes = palletTypeInfos.Select(x => x.PalletType).ToList();
+ palletTypes.Add(0);
+ if (palletTypes.Contains(nearLocations[i].LocationType))
{
- nearLocations[i].LocationType = palletType;
- }
+ if (nearLocations[i].LocationType != palletType)
+ {
+ nearLocations[i].LocationType = palletType;
+ }
- if (locationStatus == LocationStatusEnum.Lock)
- {
- if (nearLocations[i].LocationStatus == LocationStatusEnum.InStock.ObjToInt())
+ if (locationStatus == LocationStatusEnum.Lock)
{
- nearLocations[i].LocationStatus = LocationStatusEnum.InStockLock.ObjToInt();
+ if (nearLocations[i].LocationStatus == LocationStatusEnum.InStock.ObjToInt())
+ {
+ nearLocations[i].LocationStatus = LocationStatusEnum.InStockLock.ObjToInt();
+ }
+ else if (nearLocations[i].LocationStatus == LocationStatusEnum.Free.ObjToInt())
+ {
+ nearLocations[i].LocationStatus = LocationStatusEnum.FreeLock.ObjToInt();
+ }
}
- else if (nearLocations[i].LocationStatus == LocationStatusEnum.Free.ObjToInt())
+ else if (locationStatus == LocationStatusEnum.Free || locationStatus == LocationStatusEnum.InStock)
{
- nearLocations[i].LocationStatus = LocationStatusEnum.FreeLock.ObjToInt();
+ if (nearLocations[i].LocationStatus == LocationStatusEnum.InStockLock.ObjToInt())
+ {
+ nearLocations[i].LocationStatus = LocationStatusEnum.InStock.ObjToInt();
+ }
+ else if (nearLocations[i].LocationStatus == LocationStatusEnum.FreeLock.ObjToInt())
+ {
+ nearLocations[i].LocationStatus = LocationStatusEnum.Free.ObjToInt();
+ }
}
}
- else if (locationStatus == LocationStatusEnum.Free || locationStatus == LocationStatusEnum.InStock)
- {
- if (nearLocations[i].LocationStatus == LocationStatusEnum.InStockLock.ObjToInt())
- {
- nearLocations[i].LocationStatus = LocationStatusEnum.InStock.ObjToInt();
- }
- else if (nearLocations[i].LocationStatus == LocationStatusEnum.FreeLock.ObjToInt())
- {
- nearLocations[i].LocationStatus = LocationStatusEnum.Free.ObjToInt();
- }
- }
-
}
locations.AddRange(nearLocations);
}
@@ -430,9 +461,11 @@
{
List<Dt_LocationInfo> groupLocations = new List<Dt_LocationInfo>() { location };
int maxDepth = locationInfos.Max(x => x.Depth);
+ int row = location.Row;
for (int j = location.Depth + 1; j <= maxDepth; j++)
{
- Dt_LocationInfo? locationInfo = locationInfos.FirstOrDefault(x => x.Depth == j && x.Column == location.Column && x.Layer == location.Layer);
+ row += 1;
+ Dt_LocationInfo? locationInfo = locationInfos.FirstOrDefault(x => x.Depth == j && x.Column == location.Column && x.Layer == location.Layer && x.Row == row);
if (locationInfo != null)
{
groupLocations.Add(locationInfo);
@@ -441,7 +474,8 @@
for (int j = location.Depth - 1; j >= 1; j--)
{
- Dt_LocationInfo? locationInfo = locationInfos.FirstOrDefault(x => x.Depth == j && x.Column == location.Column && x.Layer == location.Layer);
+ row -= 1;
+ Dt_LocationInfo? locationInfo = locationInfos.FirstOrDefault(x => x.Depth == j && x.Column == location.Column && x.Layer == location.Layer && x.Row == row);
if (locationInfo != null)
{
groupLocations.Add(locationInfo);
@@ -461,9 +495,10 @@
List<Dt_LocationInfo> groupLocations = new List<Dt_LocationInfo>() { location };
int maxDepth = locationInfos.Max(x => x.Depth);
+ int row = location.Row;
for (int j = location.Depth + 1; j <= maxDepth; j++)
{
- Dt_LocationInfo? locationInfo = locationInfos.FirstOrDefault(x => x.Depth == j && x.Column == location.Column && x.Layer == location.Layer);
+ Dt_LocationInfo? locationInfo = locationInfos.FirstOrDefault(x => x.Depth == j && x.Column == location.Column && x.Layer == location.Layer && (x.Row == row + 1 || x.Row == row - 1));
if (locationInfo != null)
{
groupLocations.Add(locationInfo);
@@ -472,7 +507,11 @@
for (int j = location.Depth - 1; j >= 1; j--)
{
- Dt_LocationInfo? locationInfo = locationInfos.FirstOrDefault(x => x.Depth == j && x.Column == location.Column && x.Layer == location.Layer);
+ Dt_LocationInfo? locationInfo = locationInfos.FirstOrDefault(x => x.Depth == j && x.Column == location.Column && x.Layer == location.Layer && (x.Row == row + 1 || x.Row == row - 1));
+ if (j == 1 && location.RoadwayNo.Contains("CSJ") && (row==1 || row==6))
+ {
+ locationInfo = locationInfos.FirstOrDefault(x => x.Depth == j && x.Column == location.Column && x.Layer == location.Layer && (x.Row == row + 2 || x.Row == row - 2));
+ }
if (locationInfo != null)
{
groupLocations.Add(locationInfo);
--
Gitblit v1.9.3