From 202cdf4c400f7b8507f129fab5766baac6bc7e45 Mon Sep 17 00:00:00 2001
From: dengjunjie <dengjunjie@hnkhzn.com>
Date: 星期二, 11 三月 2025 17:40:20 +0800
Subject: [PATCH] 1
---
项目代码/WMS/WIDESEA_WMSServer/WIDESEA_BasicService/Service/LocationInfoService.cs | 100 +++++++++++++++++++++++++++++++++++++++++++++----
1 files changed, 91 insertions(+), 9 deletions(-)
diff --git "a/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WIDESEA_WMSServer/WIDESEA_BasicService/Service/LocationInfoService.cs" "b/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WIDESEA_WMSServer/WIDESEA_BasicService/Service/LocationInfoService.cs"
index 4e08292..a8cd1fa 100644
--- "a/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WIDESEA_WMSServer/WIDESEA_BasicService/Service/LocationInfoService.cs"
+++ "b/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WIDESEA_WMSServer/WIDESEA_BasicService/Service/LocationInfoService.cs"
@@ -1,4 +1,5 @@
-锘縰sing OfficeOpenXml.FormulaParsing.Excel.Functions.DateTime;
+锘縰sing Microsoft.AspNetCore.Mvc.RazorPages;
+using OfficeOpenXml.FormulaParsing.Excel.Functions.DateTime;
using SqlSugar;
using System;
using System.Collections.Generic;
@@ -20,6 +21,7 @@
public partial class LocationInfoService : ServiceBase<Dt_LocationInfo, ILocationInfoRepository>, ILocationInfoService
{
+
private Dictionary<string, OrderByType> _emptyAssignOrderBy = new Dictionary<string, OrderByType>()
{
{ nameof(Dt_LocationInfo.Depth), OrderByType.Desc },
@@ -27,6 +29,90 @@
{ nameof(Dt_LocationInfo.Column), OrderByType.Asc },
{ nameof(Dt_LocationInfo.Row), OrderByType.Asc },
};
+ /// <summary>
+ /// 鏍规嵁璐т綅缂栧彿鑾峰彇璐т綅淇℃伅
+ /// </summary>
+ /// <param name="LocationCode"></param>
+ /// <returns></returns>
+ public Dt_LocationInfo GetLocation(string LocationCode)
+ {
+ return BaseDal.QueryData(x => x.LocationCode == LocationCode).FirstOrDefault();
+ }
+ public WebResponseContent UpdateStatus(List<string> locationCodes, int Statu)
+ {
+ WebResponseContent content = new WebResponseContent().OK();
+ try
+ {
+ List<Dt_LocationInfo> locationInfos = Repository.QueryData(x => locationCodes.Contains(x.LocationCode));
+ foreach (var locationCode in locationCodes.GroupBy(x => x))
+ {
+ if (locationCode.Count() > 2) throw new Exception("璐т綅缁戝畾鏌滃彿杩囧");
+ if (locationCode.Count() > 1)
+ {
+ var location = locationInfos.Where(x => x.LocationCode == locationCode.Key).FirstOrDefault();
+ if (location != null && location.LocationStatus == Statu) throw new Exception("璐т綅缁戝畾鏌滃彿杩囧");
+ if (locationCode.Count() == 2) location.EnableStatus = EnableStatusEnum.OnlyOut.ObjToInt();
+ }
+ //else
+ //{
+ // throw new Exception("璐т綅缁戝畾鏌滃彿杩囧");
+ //}
+ }
+ locationInfos.ForEach(x =>
+ {
+ if (x.MaxQty == 12 || x.LocationStatus == Statu) x.EnableStatus = EnableStatusEnum.OnlyOut.ObjToInt();
+ x.LocationStatus = Statu;//LocationStatusEnum.PalletLock.ObjToInt()
+ });
+ content = UpdateData(locationInfos);
+ }
+ catch (Exception ex)
+ {
+ content.Error(ex.Message);
+ }
+ return content;
+ }
+ /// <summary>
+ /// 鑾峰彇鍙Щ搴撹揣浣�
+ /// </summary>
+ /// <returns></returns>
+ public Dt_LocationInfo AssignLocation()
+ {
+ Dt_LocationInfo locationInfo = null;
+ locationInfo = BaseDal.QueryFirst(x => x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt()) && x.Row == 3, _emptyAssignOrderBy);
+
+ if (locationInfo == null)
+ locationInfo = BaseDal.QueryFirst(x => x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt() && x.Row == 1), _emptyAssignOrderBy);
+ if (locationInfo == null)
+ locationInfo = BaseDal.QueryFirst(x => x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt() && x.Row == 2), _emptyAssignOrderBy);
+ return locationInfo;
+ }
+
+ public Dt_LocationInfo AssignLocation(string[] Stations)
+ {
+ Dt_LocationInfo? locationInfo = null;
+ locationInfo = BaseDal.QueryData(x => Stations.Contains(x.LocationCode) && x.CurrentQty < x.MaxQty - 1, _emptyAssignOrderBy).First();
+ return locationInfo;
+ }
+ /// <summary>
+ /// 鍒嗛厤璐т綅
+ /// </summary>
+ /// <param name="stockInfo">缁勭洏淇℃伅</param>
+ /// <param name="inboundOrder">鍏ュ簱鍗�</param>
+ /// <returns></returns>
+ /// <exception cref="Exception"></exception>
+ public Dt_LocationInfo AssignLocation(int inboundOrderCount)
+ {
+ Dt_LocationInfo locationInfo = BaseDal.QueryFirst(x => x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt()) && x.CurrentQty < 1 && x.Row == (inboundOrderCount > 1 ? 1 : 3), _emptyAssignOrderBy);
+
+ if (locationInfo == null)
+ {
+ var locationInfos = BaseDal.QueryData(x => x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt() && x.CurrentQty < 1), _emptyAssignOrderBy);
+ if (locationInfos.Count > 1) locationInfo = locationInfos[0];//闇�棰勭暀涓�涓揣浣嶇Щ搴�
+ }
+
+ return locationInfo;
+ }
+
public virtual Dt_LocationInfo? AssignLocation(string stationCode, int inboundType)
{
@@ -99,7 +185,7 @@
return BaseDal.QueryFirst(x => x.Id == id);
}
- return BaseDal.QueryFirst(x => x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt() && x.RoadwayNo == roadway), _emptyAssignOrderBy);
+ return BaseDal.QueryFirst(x => x.LocationStatus == LocationStatusEnum.Free.ObjToInt() || x.LocationStatus == LocationStatusEnum.InStock.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt() && x.RoadwayNo == roadway), _emptyAssignOrderBy);
}
public Dt_LocationInfo AdjacentDepthLocation(string locationCode)
@@ -118,13 +204,9 @@
WebResponseContent content = new WebResponseContent();
try
{
- Dt_LocationInfo locationInfo = BaseDal.QueryFirst(x => x.LocationCode == position);
- if (locationInfo == null) throw new Exception("鏈壘鍒拌揣浣嶄俊鎭�");
- //鍒嗛厤绌挎杞︾Щ搴撳湴鍧�
- var locationInfos = BaseDal.QueryData(x => x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && x.EnableStatus != EnableStatusEnum.Disable.ObjToInt() && x.LocationCode != locationInfo.LocationCode);//闇�鏍规嵁鍏ュ簱閫昏緫鏀瑰姩
- var location = locationInfos.OrderBy(x => x.Layer).ThenBy(x => x.Column).ThenBy(x => x.Row).FirstOrDefault();
- //if (location != null) content.OK(message: location.LocationCode, data: location);
- if (location != null) content.OK(location.LocationCode);
+ //Dt_LocationInfo locationInfo = BaseDal.QueryFirst(x => x.LocationStatus == LocationStatusEnum.Free.ObjToInt() && (x.EnableStatus == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatus == EnableStatusEnum.Normal.ObjToInt()) && (x.Row == 1 || x.Row == 3), _emptyAssignOrderBy);
+ Dt_LocationInfo locationInfo = BaseDal.QueryFirst(x => x.CurrentQty < x.MaxQty && x.LocationCode != position, _emptyAssignOrderBy);
+ if (locationInfo != null) content.OK(locationInfo.LocationCode);
}
catch (Exception ex)
{
--
Gitblit v1.9.3