添加出库移库

Huangxiaoqiang-03

2024-10-25 db3a7d2fd7276fc952a24965060accaf3a76861f

 代码管理/WMS/WIDESEA_WMSServer/WIDESEA_BasicService/Service/LocationInfoService.cs

@@ -1,16 +1,19 @@
锘縰sing SqlSugar;
锘縰sing AutoMapper;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using WIDESEA_Core;
using WIDESEA_Core.BaseRepository;
using WIDESEA_Core.BaseServices;
using WIDESEA_Core.Enums;
using WIDESEA_Core.Helper;
using WIDESEA_Core.Utilities;
using WIDESEA_DTO.Basic;
using WIDESEA_IBasicRepository;
using WIDESEA_IRecordService;
using WIDESEA_IBasicService;
using WIDESEA_Model.Models;

@@ -18,7 +21,12 @@
{
    public partial class LocationInfoService : ServiceBase<Dt_LocationInfo, ILocationInfoRepository>, ILocationInfoService
    {

        private readonly IRecordService _recordService;
        public LocationInfoService(ILocationInfoRepository BaseDal, IBasicRepository basicRepository, IRecordService recordService) : base(BaseDal)
        {
            _basicRepository = basicRepository;
            _recordService = recordService;
        }
        private Dictionary<string, OrderByType> _emptyAssignOrderBy = new Dictionary<string, OrderByType>()
        {
            { nameof(Dt_LocationInfo.Depth), OrderByType.Desc },
@@ -60,6 +68,10 @@

            return null;
        }
        public virtual Dt_LocationInfo? AssignLocation(string RoadwayNo)
        {
            return StoredAssignLocation(RoadwayNo);
        }

        private Dt_LocationInfo EmptyAssignLocation(string roadway)
        {
@@ -84,7 +96,7 @@
        private Dt_LocationInfo StoredAssignLocation(string roadway)
        {
            List<LocationGroupDTO> locationGroups = BaseDal.GetLocationGroups(roadway, LocationStatusEnum.Free, LocationStatusEnum.InStock);
            if (locationGroups != null)
            if (locationGroups != null && locationGroups.Count > 0)
            {
                LocationGroupDTO? locationGroup = locationGroups.FirstOrDefault(x => x.EnableStatusA == EnableStatusEnum.OnlyIn.ObjToInt() || x.EnableStatusA == EnableStatusEnum.Normal.ObjToInt());
                int id = locationGroup?.IdA ?? 0;
@@ -111,5 +123,156 @@
        {
            return BaseDal.QueryFirst(x => x.RoadwayNo == locationInfo.RoadwayNo && x.Column == locationInfo.Column && x.Layer == locationInfo.Layer && x.Depth != locationInfo.Depth && x.Row != locationInfo.Row && (SqlFunc.Abs(x.Row - locationInfo.Row) == 1));
        }
        public void UpdateLocationLock(Dt_LocationInfo locations, int TaskNum,int changType,bool black)
        {
            try
            {
                if (black)
                {
                    (Dt_LocationInfo?, int?) result = isDepth(locations);
                    if (result.Item1 != null && (result.Item2 == LocationStatusEnum.Free.ObjToInt()|| result.Item2 == LocationStatusEnum.Lock.ObjToInt()))
                    {
                        int beforeStatusEnd = result.Item1.LocationStatus;

                        result.Item1.LocationStatus = LocationStatusEnum.Lock.ObjToInt();

                        BaseDal.UpdateData(result.Item1);

                        _recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(result.Item1, beforeStatusEnd, changType, "", TaskNum);
                    }
                }
                else
                {
                    (Dt_LocationInfo?, int?) result = isDepth(locations);
                    if (result.Item1 != null && result.Item2 == LocationStatusEnum.Free.ObjToInt())
                    {
                        int beforeStatusEnd = result.Item1.LocationStatus;

                        result.Item1.LocationStatus = LocationStatusEnum.Lock.ObjToInt();

                        BaseDal.UpdateData(result.Item1);

                        _recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(result.Item1, beforeStatusEnd, changType, "", TaskNum);
                    }
                }
                
            }
            catch (Exception ex)
            {
                throw ex;
            }

        }
        public void UpdateLocationFree(Dt_LocationInfo locations, int TaskNum, int changType,bool black)
        {
            try
            {
                (Dt_LocationInfo?, int?) result = isDepth(locations);
                if (result.Item1 != null)
                {
                    int beforeStatusEnd = result.Item1.LocationStatus;

                    result.Item1.LocationStatus = LocationStatusEnum.Free.ObjToInt();

                    BaseDal.UpdateData(result.Item1);

                    _recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(result.Item1, beforeStatusEnd, changType, "", TaskNum);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }

        }
        public (Dt_LocationInfo?,int?) isDepth(Dt_LocationInfo locationInfo)
        {
            if (locationInfo.Depth == 2)
            {
                if (locationInfo.Row == 1 || locationInfo.Row == 5)
                {
                    Dt_LocationInfo dt_LocationInfo = BaseDal.QueryFirst(x => x.Row == locationInfo.Row + 1 && x.Layer == locationInfo.Layer && x.Column == locationInfo.Column && x.RoadwayNo == locationInfo.RoadwayNo);

                    if (dt_LocationInfo != null&& dt_LocationInfo.LocationStatus==LocationStatusEnum.InStock.ObjToInt())
                    {
                        return (dt_LocationInfo, LocationStatusEnum.InStock.ObjToInt());
                    }
                    if (dt_LocationInfo != null && dt_LocationInfo.LocationStatus == LocationStatusEnum.Free.ObjToInt())
                    {
                        return (dt_LocationInfo, LocationStatusEnum.Free.ObjToInt()); 
                    }
                    if (dt_LocationInfo != null && dt_LocationInfo.LocationStatus == LocationStatusEnum.Lock.ObjToInt())
                    {
                        return (dt_LocationInfo, LocationStatusEnum.Lock.ObjToInt());
                    }
                    if (dt_LocationInfo != null && dt_LocationInfo.LocationStatus == LocationStatusEnum.PalletLock.ObjToInt())
                    {
                        return (dt_LocationInfo, LocationStatusEnum.PalletLock.ObjToInt());
                    }
                    if (dt_LocationInfo != null && dt_LocationInfo.LocationStatus == LocationStatusEnum.Pallet.ObjToInt())
                    {
                        return (dt_LocationInfo, LocationStatusEnum.Pallet.ObjToInt());
                    }
                }
                else if (locationInfo.Row == 4 || locationInfo.Row == 8)
                {
                    Dt_LocationInfo dt_LocationInfo = BaseDal.QueryFirst(x => x.Row == locationInfo.Row + 1 && x.Layer == locationInfo.Layer && x.Column == locationInfo.Column && x.RoadwayNo == locationInfo.RoadwayNo);

                    if (dt_LocationInfo != null && dt_LocationInfo.LocationStatus == LocationStatusEnum.InStock.ObjToInt())
                    {
                        return (dt_LocationInfo, LocationStatusEnum.InStock.ObjToInt());
                    }
                    if (dt_LocationInfo != null && dt_LocationInfo.LocationStatus == LocationStatusEnum.Free.ObjToInt())
                    {
                        return (dt_LocationInfo, LocationStatusEnum.Free.ObjToInt());
                    }
                    if (dt_LocationInfo != null && dt_LocationInfo.LocationStatus == LocationStatusEnum.Lock.ObjToInt())
                    {
                        return (dt_LocationInfo, LocationStatusEnum.Lock.ObjToInt());
                    }
                    if (dt_LocationInfo != null && dt_LocationInfo.LocationStatus == LocationStatusEnum.PalletLock.ObjToInt())
                    {
                        return (dt_LocationInfo, LocationStatusEnum.PalletLock.ObjToInt());
                    }
                    if (dt_LocationInfo != null && dt_LocationInfo.LocationStatus == LocationStatusEnum.Pallet.ObjToInt())
                    {
                        return (dt_LocationInfo, LocationStatusEnum.Pallet.ObjToInt());
                    }
                }
            }
            return (null, LocationStatusEnum.Free.ObjToInt());
        }
        public void RelocationLock(Dt_LocationInfo locationInfo, Dt_LocationInfo locationInfos, int TaskNum)
        {
            int beforeStartStatus = locationInfo.LocationStatus;
            int beforeEndStatus = locationInfos.LocationStatus;

            locationInfo.LocationStatus = LocationStatusEnum.Lock.ObjToInt();

            if (locationInfos.LocationStatus == LocationStatusEnum.Pallet.ObjToInt())
            {
                locationInfos.LocationStatus = LocationStatusEnum.PalletLock.ObjToInt();
            }
            else
            {
                locationInfos.LocationStatus = LocationStatusEnum.Lock.ObjToInt();
            }

            BaseDal.UpdateData(locationInfo);
            BaseDal.UpdateData(locationInfos);

            _recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(locationInfo, beforeStartStatus, StockChangeType.Relocation.ObjToInt(), "", TaskNum);
            _recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(locationInfos, beforeEndStatus, StockChangeType.Relocation.ObjToInt(), "", TaskNum);
        }
        public void RelocationFree(Dt_LocationInfo locations, int TaskNum)
        {
            int beforeEndStatus = locations.LocationStatus;

            locations.LocationStatus = LocationStatusEnum.InStock.ObjToInt();

            BaseDal.UpdateData(locations);

            _recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(locations, beforeEndStatus, StockChangeType.Relocation.ObjToInt(), "", TaskNum);
        }
    }
}