1

Huangxiaoqiang-03

2024-11-05 f82511343cf2c8ecf3981954e7eb92172d72a905

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

@@ -123,36 +123,39 @@
        {
            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 locationInfo, int? TaskNum)
        public void UpdateLocationLock(Dt_LocationInfo locations, int TaskNum,int changType,bool black)
        {
            try
            {
                if (locationInfo.Depth == 2)
                Dt_LocationInfo result = isDepth(locations);
                int beforeStatusEnd = 0;
                if (black)
                {
                    Dt_LocationInfo dt_LocationInfo = null;
                    int beforeStatus = 0;
                    if (locationInfo.Row == 1 || locationInfo.Row == 5)
                    if (result != null && (result.LocationStatus == LocationStatusEnum.Free.ObjToInt()|| result.LocationStatus == LocationStatusEnum.Lock.ObjToInt()))
                    {
                        dt_LocationInfo = BaseDal.QueryFirst(x => x.Row == locationInfo.Row + 1 && x.Layer == locationInfo.Layer && x.Column == locationInfo.Column && x.RoadwayNo == locationInfo.RoadwayNo);
                        beforeStatus = dt_LocationInfo.LocationStatus;
                        if (dt_LocationInfo != null && dt_LocationInfo.LocationStatus != LocationStatusEnum.InStock.ObjToInt())
                        {
                            dt_LocationInfo.LocationStatus = LocationStatusEnum.Lock.ObjToInt();
                            BaseDal.UpdateData(dt_LocationInfo);
                        }
                        beforeStatusEnd = result.LocationStatus;

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

                        BaseDal.UpdateData(result);

                        _recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(result, beforeStatusEnd, changType, "", TaskNum);
                    }
                    else if (locationInfo.Row == 4 || locationInfo.Row == 8)
                    {
                        dt_LocationInfo = BaseDal.QueryFirst(x => x.Row == locationInfo.Row + 1 && x.Layer == locationInfo.Layer && x.Column == locationInfo.Column && x.RoadwayNo == locationInfo.RoadwayNo);
                        beforeStatus = dt_LocationInfo.LocationStatus;
                        if (dt_LocationInfo != null && dt_LocationInfo.LocationStatus != LocationStatusEnum.InStock.ObjToInt())
                        {
                            dt_LocationInfo.LocationStatus = LocationStatusEnum.Lock.ObjToInt();
                            BaseDal.UpdateData(dt_LocationInfo);
                        }
                    }
                    _recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(locationInfo, beforeStatus, StockChangeType.Lock.ObjToInt(), "", TaskNum);
                }
                else
                {
                    if (result != null && result.LocationStatus == LocationStatusEnum.Free.ObjToInt())
                    {
                        beforeStatusEnd = result.LocationStatus;

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

                        BaseDal.UpdateData(result);

                        _recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(result, beforeStatusEnd, changType, "", TaskNum);
                    }
                }
                
            }
            catch (Exception ex)
            {
@@ -160,35 +163,23 @@
            }

        }
        public void UpdateLocationFree(Dt_LocationInfo locationInfo, int? TaskNum)
        public void UpdateLocationFree(Dt_LocationInfo locations, int TaskNum, int changType,bool black)
        {
            try
            {
                if (locationInfo.Depth == 2)
                Dt_LocationInfo result = isDepth(locations);
                if (!black)
                {
                    Dt_LocationInfo dt_LocationInfo = null;
                    int beforeStatus = 0;
                    if (locationInfo.Row == 1 || locationInfo.Row == 5)
                    if (result != null)
                    {
                        dt_LocationInfo = BaseDal.QueryFirst(x => x.Row == locationInfo.Row + 1 && x.Layer == locationInfo.Layer && x.Column == locationInfo.Column && x.RoadwayNo == locationInfo.RoadwayNo);
                        beforeStatus = dt_LocationInfo.LocationStatus;
                        if (dt_LocationInfo != null && dt_LocationInfo.LocationStatus != LocationStatusEnum.InStock.ObjToInt())
                        {
                            dt_LocationInfo.LocationStatus = LocationStatusEnum.Free.ObjToInt();
                            BaseDal.UpdateData(dt_LocationInfo);
                        }
                        int beforeStatusEnd = result.LocationStatus;

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

                        BaseDal.UpdateData(result);

                        _recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(result, beforeStatusEnd, changType, "", TaskNum);
                    }
                    else if (locationInfo.Row == 4 || locationInfo.Row == 8)
                    {
                        dt_LocationInfo = BaseDal.QueryFirst(x => x.Row == locationInfo.Row + 1 && x.Layer == locationInfo.Layer && x.Column == locationInfo.Column && x.RoadwayNo == locationInfo.RoadwayNo);
                        beforeStatus = dt_LocationInfo.LocationStatus;
                        if (dt_LocationInfo != null && dt_LocationInfo.LocationStatus != LocationStatusEnum.InStock.ObjToInt())
                        {
                            dt_LocationInfo.LocationStatus = LocationStatusEnum.Free.ObjToInt();
                            BaseDal.UpdateData(dt_LocationInfo);
                        }
                    }
                    _recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(dt_LocationInfo, beforeStatus, StockChangeType.Lock.ObjToInt(), "", TaskNum);
                }
            }
            catch (Exception ex)
@@ -201,52 +192,54 @@
        {
            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;
                    }
                }
                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;
                    }
                }
               return AdjacentDepthLocation(locationInfo.LocationCode);
            }
            return null;
            else
            {
                return null;
            }
        }
        public void RelocationLock(Dt_LocationInfo locationInfo, Dt_LocationInfo locationInfos,int TaskNum)
        public void RelocationLock(Dt_LocationInfo locationInfo, Dt_LocationInfo locationInfos, int TaskNum)
        {
            int beforeStatus = locationInfo.LocationStatus;
            int beforeStatu = locationInfos.LocationStatus;
            int beforeStartStatus = locationInfo.LocationStatus;
            int beforeEndStatus = locationInfos.LocationStatus;

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

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

            BaseDal.UpdateData(locationInfo);

            BaseDal.UpdateData(locationInfos);
            _recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(locationInfo, beforeStatus, StockChangeType.Relocation.ObjToInt(), "", TaskNum);
            _recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(locationInfos, beforeStatu, StockChangeType.Relocation.ObjToInt(), "", TaskNum);

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

            locationInfo.LocationStatus = LocationStatusEnum.Free.ObjToInt();
            locationInfos.LocationStatus = LocationStatusEnum.InStock.ObjToInt();
            if(locations.LocationStatus== LocationStatusEnum.Lock.ObjToInt())
            {
                locations.LocationStatus = LocationStatusEnum.InStock.ObjToInt();
            }
            else
            {
                locations.LocationStatus = LocationStatusEnum.Pallet.ObjToInt();
            }
            

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

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