优化与ERP出库单逻辑，增加打印程序

huangxiaoqiang

2025-10-27 387731cab892804912e68cb91e6fb804411c4756

 ÏîÄ¿´úÂë/WMS/WIDESEA_WMSServer/WIDESEA_StorageTaskServices/Task/Dt_TaskService.cs

@@ -9,6 +9,7 @@
using SixLabors.Fonts.Tables.AdvancedTypographic;
using SqlSugar;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq.Expressions;
using System.Reflection;
@@ -30,6 +31,8 @@
using WIDESEA_Model.Models;
using WIDESEA_Model.Models.Basic;
using WIDESEA_Model.Models.ERP;
using WIDESEA_OrderRepository;
using WIDESEA_StorageTaskRepository;
using WIDESEAWCS_BasicInfoRepository;
using WIDESEAWCS_QuartzJob.Models;
using static System.Collections.Specialized.BitVector32;
@@ -51,8 +54,6 @@
    private readonly IDt_AreaInfoRepository _areaInfoRepository; //区域
    private readonly IDt_StationManagerRepository _stationManagerRepository;
    private readonly ISys_ConfigService _configService;
    private readonly IDt_OutboundOrderRepository _outorderRepository;
    private readonly IDt_OutboundOrderDetailRepository _outorderdetailRepository;

    public Dt_TaskService(IDt_TaskRepository BaseDal,
                                IUnitOfWorkManage unitOfWorkManage,
@@ -66,9 +67,7 @@
                                IDt_AreaInfoRepository areaInfoRepository,
                                IStockInfoDetailRepository stockInfoDetailRepository,
                                IDt_StationManagerRepository stationManagerRepository,
                                ISys_ConfigService configService,
                                IDt_OutboundOrderRepository outorderRepository,
                                IDt_OutboundOrderDetailRepository outorderdetailRepository) : base(BaseDal)
                                ISys_ConfigService configService) : base(BaseDal)
    {
        _unitOfWorkManage = unitOfWorkManage;
        _stockInfoRepository = stockInfoRepository;
@@ -82,8 +81,6 @@
        _stockInfoDetailRepository = stockInfoDetailRepository;
        _stationManagerRepository = stationManagerRepository;
        _configService = configService;
        _outorderRepository = outorderRepository;
        _outorderdetailRepository = outorderdetailRepository;
    }

    #region å¤–部接口方法
@@ -103,25 +100,87 @@
            taskHty.FinishTime = DateTime.Now;
            taskHty.OperateType = App.User.UserName != null ? (int)OperateTypeEnum.人工完成 : (int)OperateTypeEnum.自动完成;
            taskHty.Creater = App.User.UserName != null ? App.User.UserName : "System";

            //DtStockInfo_Hty stockInfo_Hty = stock.Adapt<DtStockInfo_Hty>();
            //stockInfo_Hty.ModifyDate = DateTime.Now; 
            stock.ModifyDate = DateTime.Now;
            stock.LocationCode = task.TargetAddress;
            var result1 = UpdateLocationStatus(locationStart, LocationEnum.Free, task.TaskNum.Value, (int)StatusChangeTypeEnum.AutomaticOutbound);
            var result2 = UpdateLocationStatus(locationEnd, LocationEnum.InStock, task.TaskNum.Value, (int)StatusChangeTypeEnum.AutomaticOutbound);

            DtStockInfo_Hty stockInfo_Hty = null;
            if (task.TaskType != (int)TaskOutboundTypeEnum.Outbound)
            {
                var stockDetailsToRemove = new List<DtStockInfoDetail>();

                // å¤„理库存明细
                if (stock.StockInfoDetails == null || !stock.StockInfoDetails.Any())
                {
                    // å½“库存明细为空时，将整个库存移入历史表
                    stockInfo_Hty = CreateStockInfoHty(stock, null, true);
                }
                else
                {
                    foreach (var item in stock.StockInfoDetails.ToList())
                    {
                        if (item.OutboundQuantity <= 0 || item.OutboundQuantity > item.Quantity)
                        {
                            throw new Exception($"出库数量异常，物料 {item.MaterielCode} çš„出库数量 {item.OutboundQuantity} ä¸åˆæ³•");
                        }

                        if (item.OutboundQuantity == item.Quantity)
                        {
                            // å®Œå…¨å‡ºåº“，移入历史表
                            if (stockInfo_Hty == null)
                            {
                                stockInfo_Hty = CreateStockInfoHty(stock, new List<DtStockInfoDetail> { item }, false);
                            }
                            else
                            {
                                stockInfo_Hty.StockInfoDetails.Add(CreateStockInfoDetailHty(item));
                            }
                            stockDetailsToRemove.Add(item);
                        }
                        else if (item.OutboundQuantity < item.Quantity && item.OutboundQuantity > 0)
                        {
                            // éƒ¨åˆ†å‡ºåº“，更新数量
                            item.Quantity -= item.OutboundQuantity;
                            item.OutboundQuantity = 0; // é‡ç½®å‡ºåº“数量
                        }
                    }

                    // ç§»é™¤å·²å®Œå…¨å‡ºåº“的明细
                    foreach (var item in stockDetailsToRemove)
                    {
                        stock.StockInfoDetails.Remove(item);
                    }
                }
            }
            
            await _unitOfWorkManage.UseTranAsync(async () =>
            {
                //await DeleteStockInfoAsync(stock.Id);
                //await DeleteStockInfoDetailsAsync(stock.StockInfoDetails);
                //await AddStockInfoHtyAsync(stockInfo_Hty);
                _stockInfoRepository.UpdateData(stock);
                // å¦‚果库存明细全部出库完毕，删除原库存记录
                if (stock.StockInfoDetails == null || !stock.StockInfoDetails.Any())
                {
                    await _stockInfoRepository.DeleteDataAsync(stock);
                }
                else
                {
                    _stockInfoRepository.UpdateData(stock);
                }
                // æ·»åŠ åŽ†å²è®°å½•
                if (stockInfo_Hty != null)
                {
                    await AddStockInfoHtyAsync(stockInfo_Hty);
                }

                UpdateLocationStatus(locationStart, LocationEnum.Free, task.TaskNum.Value, (int)StatusChangeTypeEnum.AutomaticOutbound);
                UpdateLocationStatus(locationEnd, LocationEnum.InStock, task.TaskNum.Value, (int)StatusChangeTypeEnum.AutomaticOutbound);
                await _locationStatusChangeRecordRepository.AddDataAsync(result1.Item1);
                await _locationStatusChangeRecordRepository.AddDataAsync(result2.Item1);
                await _locationRepository.UpdateDataAsync(result1.Item2);
                await _locationRepository.UpdateDataAsync(result2.Item2);

                await DeleteTaskAsync(task.TaskId);
                await AddTaskHtyAsync(taskHty);
            });
            content.OK("出库完成");

        }
        catch (Exception ex)
        {
@@ -130,7 +189,54 @@
        return content;
    }

    
    private DtStockInfo_Hty CreateStockInfoHty(DtStockInfo stock, List<DtStockInfoDetail> details, bool isFullExit)
    {
        var stockInfoHty = new DtStockInfo_Hty()
        {
            PalletCode = stock.PalletCode,
            LocationCode = stock.LocationCode,
            IsFullExit = isFullExit,
            StockStatus = stock.StockStatus,
            OrderNo = stock.OrderNo,
            OrderType = stock.OrderType,
            Remark = stock.Remark,
            StockInfoDetails = new List<DtStockInfoDetail_Hty>()
        };

        if (details != null)
        {
            foreach (var detail in details)
            {
                stockInfoHty.StockInfoDetails.Add(CreateStockInfoDetailHty(detail));
            }
        }

        return stockInfoHty;
    }

    /// <summary>
    /// åˆ›å»ºåº“存明细历史记录
    /// </summary>
    private DtStockInfoDetail_Hty CreateStockInfoDetailHty(DtStockInfoDetail detail)
    {
        return new DtStockInfoDetail_Hty
        {
            MaterielCode = detail.MaterielCode,
            MaterielName = detail.MaterielName,
            DemandClassification = detail.DemandClassification,
            Warehouse = detail.Warehouse,
            OrderNo = detail.OrderNo,
            Unit = detail.Unit,
            Specs = detail.Specs,
            Weight = detail.Weight,
            Quantity = detail.Quantity,
            OutboundQuantity = detail.OutboundQuantity,
            Status = detail.Status,
            DrawingNumber = detail.DrawingNumber,
            Date = detail.Date,
            Remark = detail.Remark
        };
    }

    #endregion å‡ºåº“任务完成

@@ -157,11 +263,12 @@

            stock.ModifyDate = DateTime.Now;
            stock.LocationCode = task.TargetAddress;

            var result = UpdateLocationStatus(locationEnd, LocationEnum.InStock, task.TaskNum.Value, (int)StatusChangeTypeEnum.AutomaticRelocation);
            await _unitOfWorkManage.UseTranAsync(async () =>
            {
                //UpdateLocationStatus(locationStart, LocationEnum.Free, task.TaskNum.Value, (int)StatusChangeTypeEnum.AutomaticInbound);
                UpdateLocationStatus(locationEnd, LocationEnum.InStock, task.TaskNum.Value, (int)StatusChangeTypeEnum.AutomaticRelocation);
                await _locationStatusChangeRecordRepository.AddDataAsync(result.Item1);
                await _locationRepository.UpdateDataAsync(result.Item2);
                _stockInfoRepository.UpdateData(stock);
                await DeleteTaskAsync(task.TaskId);
                await AddTaskHtyAsync(taskHty);
@@ -189,16 +296,16 @@
        WebResponseContent content = new WebResponseContent();
        try
        {
            var stock = await _stockInfoRepository.QueryFirstNavAsync(x => x.PalletCode == task.PalletCode && x.StockStatus == (int)StockStateEmun.组盘暂存);
            var boxinfo = await _boxingInfoRepository.QueryFirstNavAsync(x => x.PalletCode == task.PalletCode);
            var locationStart = await _locationRepository.QueryFirstAsync(x => x.LocationCode == task.SourceAddress);
            var locationEnd = await _locationRepository.QueryFirstAsync(x => x.LocationCode == task.TargetAddress);

            if (stock == null)
            if (boxinfo == null)
            {
                return content.Error("未找到组盘数据");
            }
            stock.LocationCode = task.TargetAddress;
            stock.StockStatus = (int)StockStateEmun.已入库;

            var stock = CreateStock(boxinfo, task);

            task.TaskState = (int)TaskInStatusEnum.InFinish;
            var taskHty = task.Adapt<Dt_Task_Hty>();
@@ -206,13 +313,18 @@
            taskHty.OperateType = App.User.UserName != null ? (int)OperateTypeEnum.人工完成 : (int)OperateTypeEnum.自动完成;
            taskHty.Creater = App.User.UserName != null ? App.User.UserName : "System";

            var result1 = UpdateLocationStatus(task.SourceAddress, LocationEnum.InStockDisable, task.TaskNum.Value, (int)StatusChangeTypeEnum.AutomaticInbound);
            var result2 = UpdateLocationStatus(task.TargetAddress, LocationEnum.Lock, task.TaskNum.Value, (int)StatusChangeTypeEnum.AutomaticInbound);

            await _unitOfWorkManage.UseTranAsync(async () =>
            {
                await _stockInfoRepository.UpdateDataAsync(stock);
                await _stockInfoRepository.AddDataNavAsync(stock);
                await DeleteTaskAsync(task.TaskId);
                await AddTaskHtyAsync(taskHty);
                UpdateLocationStatus(locationStart, LocationEnum.Free, task.TaskNum.Value, (int)StatusChangeTypeEnum.AutomaticInbound);
                UpdateLocationStatus(locationEnd, LocationEnum.InStock, task.TaskNum.Value, (int)StatusChangeTypeEnum.AutomaticInbound);
                await _locationStatusChangeRecordRepository.AddDataAsync(result2.Item1);
                await _locationStatusChangeRecordRepository.AddDataAsync(result1.Item1);
                await _locationRepository.UpdateDataAsync(result2.Item2);
                await _locationRepository.UpdateDataAsync(result1.Item2);
            });
            content.OK("入库完成");
        }
@@ -223,7 +335,21 @@
        return content;
    }


    public DtStockInfo CreateStock(DtBoxingInfo boxingInfo,Dt_Task task)
    {
        var boxDetail = boxingInfo.BoxingInfoDetails.Adapt<List<DtStockInfoDetail>>();
        boxDetail.ForEach(x => { x.Status = (int)StockStateEmun.已入库; });
        return new DtStockInfo()
        {
            PalletCode = task.PalletCode,
            LocationCode = task.TargetAddress,
            CreateDate = DateTime.Now,
            Creater = "system",
            IsFullExit = boxingInfo.IsFullExit,
            StockInfoDetails = boxDetail,
            StockStatus = (int)StockStateEmun.已入库
        };
    }
    #endregion å…¥åº“任务完成

    #region AGV搬运任务完成
@@ -372,8 +498,9 @@
        WebResponseContent content = new WebResponseContent();
        try
        {
            var stock = await _stockInfoRepository.QueryFirstNavAsync(x => x.PalletCode == taskDto.PalletCode && x.StockStatus == (int)StockStateEmun.组盘暂存);
            if (stock == null)
            var boxingInfo = await _boxingInfoRepository.QueryFirstNavAsync(x => x.PalletCode == taskDto.PalletCode && x.StockStatus == (int)StockStateEmun.组盘暂存);

            if (boxingInfo == null)
            {
                return content.Error("托盘信息不存在，请确认托盘已组盘成功");
            }
@@ -396,37 +523,45 @@
            {
                return content.Error($"起点库位{StartAddress.LocationCode}搬运路径被占用，请人工确认再下发任务");
            }
            Dt_Task taskNew = new Dt_Task();
            DtLocationInfo Endlocation= new DtLocationInfo();
            if (taskDto.AreaId != 0)
            {
                switch (taskDto.AreaId)
                {
                    case 1:
                        return await InboundStakerArea(taskDto, StartAddress);
                        Endlocation = await GetEmptyLocation("SC1");
                        taskNew = InboundStakerArea(taskDto, StartAddress, Endlocation);
                        break;
                    case 2:
                    case 3:
                    case 4:
                    case 5:
                    case 6:
                        return await InboundAGVCacheArea(taskDto, StartAddress, await GetAGVEmptyCacheLocation(taskDto.AreaId, StartAddress));
                        Endlocation = await GetAGVEmptyCacheLocation(taskDto.AreaId, StartAddress);
                        taskNew = InboundAGVCacheArea(taskDto, StartAddress, Endlocation);
                        break;
                    default:
                        return content.Error("请选择正确的区域信息");
                }
            }
            else if (taskDto.TargetAddress != null)
            {
                var location = _locationRepository.QueryFirst(x => x.LocationCode == taskDto.TargetAddress);
                if (location != null && location.LocationStatus == (int)LocationEnum.Free && location.EnalbeStatus == 1)
                Endlocation = _locationRepository.QueryFirst(x => x.LocationCode == taskDto.TargetAddress);
                if (Endlocation != null && Endlocation.LocationStatus == (int)LocationEnum.Free && Endlocation.EnalbeStatus == 1)
                {
                    switch (location.AreaId)
                    switch (Endlocation.AreaId)
                    {
                        case 1:
                            return await InboundStakerArea(taskDto, StartAddress);
                            taskNew = InboundStakerArea(taskDto, StartAddress, Endlocation);
                            break;
                        case 2:
                        case 3:
                        case 4:
                        case 5:
                        case 6:
                            return await InboundAGVCacheArea(taskDto, StartAddress, location);
                            taskNew = InboundAGVCacheArea(taskDto, StartAddress, Endlocation);
                            break;
                        default:
                            return content.Error("货位区域未找到");
                    }
@@ -438,8 +573,23 @@
            }
            else
            {
                return content.OK("请选择入库区域或终点地址");
                return content.Error("请选择入库区域或终点地址");
            }
            var taskDTO = CreateListTaskDTO(taskNew);
            
            var result1 = UpdateLocationStatus(StartAddress, LocationEnum.Lock, taskNew.TaskNum.Value, (int)StatusChangeTypeEnum.AutomaticInbound);
            var result2 = UpdateLocationStatus(Endlocation, LocationEnum.InStockDisable, taskNew.TaskNum.Value, (int)StatusChangeTypeEnum.AutomaticInbound);

            await _unitOfWorkManage.UseTranAsync(async () =>
            {
                await _locationStatusChangeRecordRepository.AddDataAsync(result1.Item1);
                await _locationStatusChangeRecordRepository.AddDataAsync(result2.Item1);
                await _locationRepository.UpdateDataAsync(result1.Item2);
                await _locationRepository.UpdateDataAsync(result2.Item2);
                BaseDal.AddData(taskNew);
            });
            //return content = await SendWCSTask(taskDTO);
            return content.OK("成功");
        }
        catch (Exception err)
        {
@@ -447,86 +597,54 @@
        }
    }

    public async Task<WebResponseContent> InboundStakerArea(RequestTaskDto taskDto,DtLocationInfo StartAddress)
    public Dt_Task InboundStakerArea(RequestTaskDto taskDto, DtLocationInfo StartAddress,DtLocationInfo EndLocation)
    {
        WebResponseContent content = new WebResponseContent();
        try
        var station = _stationManagerRepository.QueryFirst(x => x.stationType == 1 && x.Roadway == "SC1");
        if (EndLocation == null)
        {
            var station = _stationManagerRepository.QueryFirst(x => x.stationType == 1 && x.Roadway == "SC1");

            Dt_Task taskNew = new Dt_Task
            {
                Grade = 1,
                Roadway = "SC1",
                TargetAddress = "SC1",
                Dispatchertime = DateTime.Now,
                MaterialNo = "",
                NextAddress = station.stationChildCode,
                OrderNo = null,
                PalletCode = taskDto.PalletCode,
                SourceAddress = taskDto.Position,
                CurrentAddress = taskDto.Position,
                TaskState = (int)TaskInStatusEnum.InNew,
                TaskType = (int)TaskInboundTypeEnum.Inbound,
                TaskNum = BaseDal.GetTaskNo().Result,
                CreateDate = DateTime.Now,
                TaskId = 0,
                AGVTaskNum = GenerateUniqueId(),
                Floor = "1F",
            };
            var taskDTO = CreateListTaskDTO(taskNew);

            BaseDal.AddData(taskNew);

            UpdateLocationStatus(StartAddress, LocationEnum.InStockDisable, taskNew.TaskNum.Value, (int)StatusChangeTypeEnum.AutomaticInbound);
            //UpdateLocationStatus(location, LocationEnum.Lock, taskNew.TaskNum.Value, (int)StatusChangeTypeEnum.AutomaticInbound);
            
            //return content.OK();
            return content = await SendWCSTask(taskDTO);
            throw new Exception("无法获取货位信息");
        }
        catch (Exception ex)
        return new Dt_Task
        {
            _unitOfWorkManage.RollbackTran();
            return content.Error(ex.Message);
        }
            Grade = 1,
            Roadway = "SC1",
            TargetAddress = EndLocation.LocationCode,
            Dispatchertime = DateTime.Now,
            MaterialNo = "",
            NextAddress = station.stationChildCode,
            OrderNo = null,
            PalletCode = taskDto.PalletCode,
            SourceAddress = taskDto.Position,
            CurrentAddress = taskDto.Position,
            TaskState = (int)TaskInStatusEnum.InNew,
            TaskType = (int)TaskInboundTypeEnum.Inbound,
            TaskNum = BaseDal.GetTaskNo().Result,
            CreateDate = DateTime.Now,
            TaskId = 0,
            AGVTaskNum = GenerateUniqueId(),
            Floor = "1F",
        };
    }

    public async Task<WebResponseContent> InboundAGVCacheArea(RequestTaskDto taskDto, DtLocationInfo StartAddress, DtLocationInfo location)
    public Dt_Task InboundAGVCacheArea(RequestTaskDto taskDto, DtLocationInfo StartAddress, DtLocationInfo location)
    {
        WebResponseContent content = new WebResponseContent();
        try

        if (location == null)
        {
            if (location == null)
            {
                return content.Error("起点未定义或终点区域未找到空闲库位");
            }
            Dt_Task taskNew = new Dt_Task();
            if (StartAddress.Floor != location.Floor)
            {
                taskNew= RequestAcrossFloorTask(StartAddress,location, (int)TaskInboundTypeEnum.Inbound,taskDto.PalletCode);
            }
            else
            {
                taskNew = RequestAGVCarryTask(StartAddress, location, (int)TaskInboundTypeEnum.Inbound, taskDto.PalletCode);
            }
                
            var taskDTO = CreateListTaskDTO(taskNew);
            _unitOfWorkManage.BeginTran();

            UpdateLocationStatus(StartAddress, LocationEnum.InStockDisable, taskNew.TaskNum.Value, (int)StatusChangeTypeEnum.AutomaticInbound);
            UpdateLocationStatus(location, LocationEnum.Lock, taskNew.TaskNum.Value, (int)StatusChangeTypeEnum.AutomaticInbound);

            BaseDal.AddData(taskNew);

            _unitOfWorkManage.CommitTran();
            //return content.OK();
            return content = await SendWCSTask(taskDTO);
            throw new Exception("无法获取货位信息");
        }
        catch (Exception ex)
        Dt_Task taskNew = new Dt_Task();
        if (StartAddress.Floor != location.Floor)
        {
            _unitOfWorkManage.RollbackTran();
            return content.Error(ex.Message);
            taskNew = RequestAcrossFloorTask(StartAddress, location, (int)TaskInboundTypeEnum.Inbound, taskDto);
        }
        else
        {
            taskNew = RequestAGVCarryTask(StartAddress, location, (int)TaskInboundTypeEnum.Inbound, taskDto);
        }
        return taskNew;

    }
    #endregion è¯·æ±‚任务入库

@@ -622,27 +740,80 @@
    #endregion

    #region è¯·æ±‚出库
    public async Task<WebResponseContent> OtherOutBoundTaskAsync(string palletCode)
    public async Task<WebResponseContent> OutBoundTaskAsync(string palletCode)
    {
        WebResponseContent content = new WebResponseContent();
        try
        {
            DtStockInfo stcok = await _stockInfoRepository.QueryFirstAsync(x => x.PalletCode == palletCode);
            DtStockInfo stcok = await _stockInfoRepository.QueryFirstNavAsync(x => x.PalletCode == palletCode);
            if (stcok == null)
            {
                return content.Error("托盘信息不存在，请确认托盘已入库成功");
            }

            if (stcok.LocationInfo.LocationStatus != (int)LocationEnum.InStock)
            {
                return content.Error("请确认库存货位状态是否为有货");
            }
            var task = await BaseDal.QueryFirstAsync(x => x.PalletCode == palletCode);
            if (task != null)
            {
                return content.Error("该托盘已存在任务");
            }

            var location = await _locationRepository.QueryFirstAsync(x => x.LocationCode == stcok.LocationCode);
            if (location.AreaId == 2)
            {
                return content.Error("该托盘库存已在出库缓存区");
            }
            return await RequestOutboundTaskAsync(new RequestTaskDto { PalletCode = palletCode, AreaId = 2, Position = stcok.LocationCode ,TaskType = (int)TaskOutboundTypeEnum.OutOther });

            Dt_Task taskNew = await RequestOutboundTaskAsync(new RequestTaskDto { PalletCode = palletCode, AreaId = 2, Position = stcok.LocationCode, TaskType = (int)TaskOutboundTypeEnum.Outbound });

            var taskDto = CreateListTaskDTO(taskNew);
            var result = GetlcoationState(taskNew, (int)StatusChangeTypeEnum.AutomaticOutbound);
            await _unitOfWorkManage.UseTranAsync(async () =>
            {
                BaseDal.AddData(taskNew);
                _stockInfoRepository.UpdateData(stcok);
                await _locationStatusChangeRecordRepository.AddDataAsync(result.Item1);
                await _locationRepository.UpdateDataAsync(result.Item2);
            });
            return content = await SendWCSTask(taskDto);
        }
        catch (Exception ex)
        {
            return content.Error(ex.Message);
        }
    }

    public (List<DtLocationStatusChangeRecord>,List<DtLocationInfo>) GetlcoationState(Dt_Task task,int StatusChangeTypeEnum)
    {
        List<DtLocationStatusChangeRecord> locationStatusChangeRecords = new List<DtLocationStatusChangeRecord>();
        List<DtLocationInfo> locations = new List<DtLocationInfo>();
        var result1 = UpdateLocationStatus(task.SourceAddress, LocationEnum.InStockDisable, task.TaskNum.Value, StatusChangeTypeEnum);
        var result2 = UpdateLocationStatus(task.TargetAddress, LocationEnum.Lock, task.TaskNum.Value, StatusChangeTypeEnum);
        locationStatusChangeRecords.AddRange(result1.Item1);
        locationStatusChangeRecords.AddRange(result2.Item1);
        locations.AddRange(result1.Item2);
        locations.AddRange(result2.Item2);

        return (locationStatusChangeRecords,locations);
    }

    public (List<DtLocationStatusChangeRecord>, List<DtLocationInfo>) GetlcoationState(List<Dt_Task> tasks, int StatusChangeTypeEnum)
    {
        List<DtLocationStatusChangeRecord> locationStatusChangeRecords = new List<DtLocationStatusChangeRecord>();
        List<DtLocationInfo> locations = new List<DtLocationInfo>();
        foreach (var item in tasks)
        {
            var result1 = UpdateLocationStatus(item.SourceAddress, LocationEnum.InStockDisable, item.TaskNum.Value, StatusChangeTypeEnum);
            var result2 = UpdateLocationStatus(item.TargetAddress, LocationEnum.Lock, item.TaskNum.Value, StatusChangeTypeEnum);
            locationStatusChangeRecords.AddRange(result1.Item1);
            locationStatusChangeRecords.AddRange(result2.Item1);
            locations.AddRange(result1.Item2);
            locations.AddRange(result2.Item2);
        }
        return (locationStatusChangeRecords, locations);
    }


@@ -651,156 +822,117 @@
    /// </summary>
    /// <param name="taskDto"></param>
    /// <returns></returns>
    public async Task<WebResponseContent> RequestOutboundTaskAsync(RequestTaskDto taskDto)
    public async Task<Dt_Task> RequestOutboundTaskAsync(RequestTaskDto taskDto)
    {
        WebResponseContent content = new WebResponseContent();
        try
        DtStockInfo stcok = await _stockInfoRepository.QueryFirstAsync(x => x.PalletCode == taskDto.PalletCode);
        if (stcok == null)
        {
            DtStockInfo stcok = await _stockInfoRepository.QueryFirstAsync(x => x.PalletCode == taskDto.PalletCode);
            if (stcok == null)
            {
                return content.Error("托盘信息不存在，请确认托盘已入库成功");
            }
            throw new Exception("托盘信息不存在，请确认托盘已入库成功");
        }

            var StartAddress = await _locationRepository.QueryFirstAsync(x => x.LocationCode == taskDto.Position);
            if (StartAddress == null)
        var StartAddress = await _locationRepository.QueryFirstAsync(x => x.LocationCode == taskDto.Position);
        if (StartAddress == null)
        {
            throw new Exception("起点库位未找到");
        }
        if (!LocationIsOutBound(StartAddress))
        {
            throw new Exception($"起点库位{StartAddress.LocationCode}出库路径被占用，请人工确认再下发任务");
        }
        DtLocationInfo location = null;
        if (taskDto.AreaId != 0)
        {
            if (taskDto.AreaId == 1)
            {
                return content.Error("起点库位未找到");
            }
            if (!LocationIsOutBound(StartAddress))
            {
                return content.Error($"起点库位{StartAddress.LocationCode}出库路径被占用，请人工确认再下发任务");
            }
            DtLocationInfo location = null;
            if (taskDto.AreaId != 0)
            {
                if (taskDto.AreaId == 1)
                {
                    location = await GetEmptyLocation("SC1");
                }
                else
                {
                    location = await GetAGVEmptyCacheLocation(taskDto.AreaId, StartAddress);
                }
                    
            }
            else if (taskDto.TargetAddress != null)
            {
                location = _locationRepository.QueryFirst(x => x.LocationCode == taskDto.TargetAddress);

                if (location != null && location.LocationStatus != (int)LocationEnum.Free && location.EnalbeStatus == 1)
                {
                    return content.OK("目标库位不可用");
                }
                location = await GetEmptyLocation("SC1");
            }
            else
            {
                return content.OK("请选择入库区域或终点地址");
                location = await GetAGVEmptyCacheLocation(taskDto.AreaId, StartAddress);
            }

            switch (StartAddress.AreaId)
        }
        else if (taskDto.TargetAddress != null)
        {
            location = _locationRepository.QueryFirst(x => x.LocationCode == taskDto.TargetAddress);

            if (location != null && location.LocationStatus != (int)LocationEnum.Free && location.EnalbeStatus == 1)
            {
                case 1:
                    return await OutboundStakerArea(taskDto, StartAddress, location);
                case 2:
                case 3:
                case 4:
                case 5:
                case 6:
                    return await OutboundAGVCacheArea(taskDto, StartAddress, location);
                default:
                    return content.Error("请选择正确的区域信息");
                throw new Exception("目标库位不可用");
            }
        }
        catch (Exception ex)
        else
        {
            return content.Error(ex.Message);
            throw new Exception("请选择入库区域或终点地址");
        }
        switch (StartAddress.AreaId)
        {
            case 1:
                return OutboundStakerArea(taskDto, StartAddress, location);
            case 2:
            case 3:
            case 4:
            case 5:
            case 6:
                return OutboundAGVCacheArea(taskDto, StartAddress, location);
            default:
                throw new Exception("请选择正确的区域信息");
        }
    }

    public async Task<WebResponseContent> OutboundStakerArea(RequestTaskDto taskDto, DtLocationInfo StartAddress, DtLocationInfo location)

    public Dt_Task OutboundStakerArea(RequestTaskDto taskDto, DtLocationInfo StartAddress, DtLocationInfo location)
    {
        WebResponseContent content = new WebResponseContent();
        try
        var station = _stationManagerRepository.QueryFirst(x => x.stationType == 1 && x.Roadway == "SC1");

        if (location == null)
        {
            var station = _stationManagerRepository.QueryFirst(x => x.stationType == 1 && x.Roadway == "SC1");

            if (location == null)
            {
                return content.Error("终点区域未找到空闲库位");
            }

            if (location.AreaId == 5 || location.AreaId == 6)
            {
                return content.Error("当前区域不可出库，请联系管理员");
            }
            Dt_Task taskNew = new Dt_Task
            {
                Grade = Convert.ToInt32(StartAddress.Remark),
                Roadway = "SC1",
                TargetAddress = location.LocationCode,
                Dispatchertime = DateTime.Now,
                MaterialNo = "",
                NextAddress = station.stationChildCode,
                OrderNo = null,
                PalletCode = taskDto.PalletCode,
                SourceAddress = taskDto.Position,
                CurrentAddress = taskDto.Position,
                TaskState = (int)TaskOutStatusEnum.OutNew,
                TaskType = taskDto.TaskType,
                TaskNum = BaseDal.GetTaskNo().Result,
                CreateDate = DateTime.Now,
                TaskId = 0,
                AGVTaskNum = GenerateUniqueId(),
                Floor = "1F",
            };
            var taskDTO = CreateListTaskDTO(taskNew);

            UpdateLocationStatus(StartAddress, LocationEnum.InStockDisable, taskNew.TaskNum.Value, (int)StatusChangeTypeEnum.AutomaticOutbound);
            UpdateLocationStatus(location, LocationEnum.Lock, taskNew.TaskNum.Value, (int)StatusChangeTypeEnum.AutomaticOutbound);

            BaseDal.AddData(taskNew);
            //return content.OK();
            return content = await SendWCSTask(taskDTO);
            throw new Exception("终点区域未找到空闲库位");
        }
        catch (Exception ex)

        if (location.AreaId == 5 || location.AreaId == 6)
        {
            return content.Error(ex.Message);
            throw new Exception("当前区域不可出库，请联系管理员");
        }
        return new Dt_Task
        {
            Grade = Convert.ToInt32(StartAddress.Remark),
            Roadway = "SC1",
            TargetAddress = location.LocationCode,
            Dispatchertime = DateTime.Now,
            MaterialNo = taskDto.MaterielCode,
            NextAddress = station.stationChildCode,
            OrderNo = taskDto.OrderNo,
            PalletCode = taskDto.PalletCode,
            SourceAddress = taskDto.Position,
            CurrentAddress = taskDto.Position,
            TaskState = (int)TaskOutStatusEnum.OutNew,
            TaskType = taskDto.TaskType,
            TaskNum = BaseDal.GetTaskNo().Result,
            CreateDate = DateTime.Now,
            TaskId = 0,
            AGVTaskNum = GenerateUniqueId(),
            Floor = "1F",
        };
    }

    public async Task<WebResponseContent> OutboundAGVCacheArea(RequestTaskDto taskDto, DtLocationInfo StartAddress, DtLocationInfo location)
    public Dt_Task OutboundAGVCacheArea(RequestTaskDto taskDto, DtLocationInfo StartAddress, DtLocationInfo location)
    {
        WebResponseContent content = new WebResponseContent();
        try
        if (location == null)
        {
            if (location == null)
            {
                return content.Error("起点未定义或终点区域未找到空闲库位");
            }
            Dt_Task taskNew = new Dt_Task();
            if (StartAddress.Floor != location.Floor)
            {
                taskNew = RequestAcrossFloorTask(StartAddress, location, taskDto.TaskType, taskDto.PalletCode);
            }
            else
            {
                taskNew = RequestAGVCarryTask(StartAddress, location, taskDto.TaskType, taskDto.PalletCode);
            }

            var taskDTO = CreateListTaskDTO(taskNew);

            UpdateLocationStatus(StartAddress, LocationEnum.InStockDisable, taskNew.TaskNum.Value, (int)StatusChangeTypeEnum.AutomaticOutbound);
            UpdateLocationStatus(location, LocationEnum.Lock, taskNew.TaskNum.Value, (int)StatusChangeTypeEnum.AutomaticOutbound);

            BaseDal.AddData(taskNew);
            //return content.OK();
            return content = await SendWCSTask(taskDTO);
            throw new Exception("起点未定义或终点区域未找到空闲库位");
        }
        catch (Exception ex)
        Dt_Task taskNew = new Dt_Task();
        if (StartAddress.Floor != location.Floor)
        {
            return content.Error(ex.Message);
            taskNew = RequestAcrossFloorTask(StartAddress, location, taskDto.TaskType, taskDto);
        }
        else
        {
            taskNew = RequestAGVCarryTask(StartAddress, location, taskDto.TaskType,  taskDto);
        }
        return taskNew;

    }
    #endregion è¯·æ±‚出库（实盘&空盘）

@@ -871,73 +1003,62 @@
    #endregion

    #region è¯·æ±‚跨楼层任务
    public Dt_Task RequestAcrossFloorTask(DtLocationInfo StartAddress,DtLocationInfo EndAddress,int TaskType,string palletCode)
    public Dt_Task RequestAcrossFloorTask(DtLocationInfo StartAddress, DtLocationInfo EndAddress, int TaskType,  RequestTaskDto taskDto)
    {
        WebResponseContent content = new WebResponseContent();
        try

        var next = _stationManagerRepository.QueryFirst(x => x.stationType == 5 && x.stationFloor == StartAddress.Floor);
        return new Dt_Task
        {
            var next = _stationManagerRepository.QueryFirst(x => x.stationType == 5 && x.stationFloor == StartAddress.Floor);
            return new Dt_Task
            {
                Grade = StartAddress.Column,
                Roadway = "AGV",
                TargetAddress = EndAddress.LocationCode,
                Dispatchertime = DateTime.Now,
                MaterialNo = "",
                NextAddress = next.stationChildCode,
                OrderNo = null,
                PalletCode = palletCode,
                SourceAddress = StartAddress.LocationCode,
                CurrentAddress = StartAddress.LocationCode,
                TaskState = (int)TaskAcrossFloorStatusEnum.CarryNew,
                TaskType = TaskType,
                TaskNum = BaseDal.GetTaskNo().Result,
                CreateDate = DateTime.Now,
                TaskId = 0,
                Remark = StartAddress.AreaId.ToString(),
                AGVTaskNum = GenerateUniqueId(),
                Floor = StartAddress.Floor,
            };
        }
        catch (Exception ex)
        {
            return null;
        }
            Grade = StartAddress.Column,
            Roadway = "AGV",
            TargetAddress = EndAddress.LocationCode,
            Dispatchertime = DateTime.Now,
            MaterialNo = taskDto.MaterielCode,
            NextAddress = next.stationChildCode,
            OrderNo = taskDto.OrderNo,
            PalletCode = taskDto.PalletCode,
            SourceAddress = StartAddress.LocationCode,
            CurrentAddress = StartAddress.LocationCode,
            TaskState = (int)TaskAcrossFloorStatusEnum.CarryNew,
            TaskType = TaskType,
            TaskNum = BaseDal.GetTaskNo().Result,
            CreateDate = DateTime.Now,
            TaskId = 0,
            Remark = StartAddress.AreaId.ToString(),
            AGVTaskNum = GenerateUniqueId(),
            Floor = StartAddress.Floor,
        };

    }
    #endregion

    #region è¯·æ±‚AGV搬运任务
    public Dt_Task RequestAGVCarryTask(DtLocationInfo StartAddress, DtLocationInfo EndAddress, int TaskType, string palletCode)
    public Dt_Task RequestAGVCarryTask(DtLocationInfo StartAddress, DtLocationInfo EndAddress, int TaskType, RequestTaskDto taskDto)
    {
        WebResponseContent content = new WebResponseContent();
        try

        return new Dt_Task
        {
            return new Dt_Task
            {
                Grade = StartAddress.Column,
                Roadway = "AGV",
                TargetAddress = EndAddress.LocationCode,
                Dispatchertime = DateTime.Now,
                MaterialNo = "",
                NextAddress = EndAddress.LocationCode,
                OrderNo = null,
                PalletCode = palletCode,
                SourceAddress = StartAddress.LocationCode,
                CurrentAddress = StartAddress.LocationCode,
                TaskState = (int)TaskAGVCarryStatusEnum.CarryNew,
                TaskType = TaskType,
                TaskNum = BaseDal.GetTaskNo().Result,
                CreateDate = DateTime.Now,
                TaskId = 0,
                Remark = StartAddress.AreaId.ToString(),
                AGVTaskNum = GenerateUniqueId(),
                Floor = StartAddress.Floor,
            };
        }
        catch (Exception ex)
        {
            return null;
        }
            Grade = StartAddress.Column,
            Roadway = "AGV",
            TargetAddress = EndAddress.LocationCode,
            Dispatchertime = DateTime.Now,
            MaterialNo = taskDto.MaterielCode,
            NextAddress = EndAddress.LocationCode,
            OrderNo = taskDto.OrderNo,
            PalletCode = taskDto.PalletCode,
            SourceAddress = StartAddress.LocationCode,
            CurrentAddress = StartAddress.LocationCode,
            TaskState = (int)TaskAGVCarryStatusEnum.CarryNew,
            TaskType = TaskType,
            TaskNum = BaseDal.GetTaskNo().Result,
            CreateDate = DateTime.Now,
            TaskId = 0,
            Remark = StartAddress.AreaId.ToString(),
            AGVTaskNum = GenerateUniqueId(),
            Floor = StartAddress.Floor,
        };
    }

    #endregion
@@ -1207,7 +1328,57 @@
        return wcsBasez + address;
    }

    public async Task<WebResponseContent> SendERPTaskCompletion(string palletCode)
    /// <summary>
    /// ç”Ÿäº§é¢†æ–™
    /// </summary>
    /// <param name="palletCode"></param>
    /// <returns></returns>
    public async Task<WebResponseContent> ERPProduction(string palletCode)
    {
        WebResponseContent content = new WebResponseContent();
        try
        {
            DtStockInfo stock = await _stockInfoRepository.QueryFirstNavAsync(x => x.PalletCode == palletCode);
            Dt_Task task = await BaseDal.QueryFirstAsync(x => x.PalletCode == palletCode);
            MaterialRequisition allocate = new MaterialRequisition
            {
                context = new Context
                {
                    CultureName = "zh-CN",
                    EntCode = "001",
                    OrgCode = "102",
                    UserCode = "MH0551"
                },
                documentTypeCode = "TransIn002",
                businessDate = DateTime.Now.ToString("yyyy-MM-dd"),
                isApproved = true,

                issueList = new List<issueList>()
                {
                    new issueList
                    {
                        //备料ID
                        PickListID = task.OrderNo,
                        //存储地点
                        WhCode = "204",
                        //领料数量
                        IssueQty = task.OrderNo,
                    }
                }
            };
            return content.OK(data: allocate);
        }
        catch (Exception ex)
        {
            return content.Error(ex.Message);
        }
    }
    /// <summary>
    /// è°ƒæ‹¨
    /// </summary>
    /// <param name="palletCode"></param>
    /// <returns></returns>
    public async Task<WebResponseContent> ERPAllocate(string palletCode)
    {
        WebResponseContent content = new WebResponseContent();
        try
@@ -1226,12 +1397,136 @@
                businessDate = DateTime.Now.ToString("yyyy-MM-dd"),
                isApproved = true,

                transferInList = stock.StockInfoDetails.Select(item => new transferInList
                transferInList = stock.StockInfoDetails.Where(x => x.OutboundQuantity > 0).Select(item => new transferInList
                {
                    //物料编码
                    ItemCode = item.MaterielCode,
                    //调入仓库地址
                    TransInWHCode = item.Remark==""? item.Warehouse: item.Remark,
                    //调入数量
                    TransInQty = item.OutboundQuantity,
                    // è°ƒå‡ºä»“库编码
                    TransOutWHCode = "201",
                }).ToList()
            };
            return content.OK(data: allocate);
        }
        catch (Exception ex)
        {
            return content.Error(ex.Message);
        }
    }
    /// <summary>
    /// æ‚发
    /// </summary>
    /// <param name="palletCode"></param>
    /// <returns></returns>
    public async Task<WebResponseContent> ERPMixedSend(string palletCode)
    {
        WebResponseContent content = new WebResponseContent();
        try
        {
            DtStockInfo stock = await _stockInfoRepository.QueryFirstNavAsync(x => x.PalletCode == palletCode);
            MixedSend send = new MixedSend
            {
                context = new Context
                {
                    CultureName = "zh-CN",
                    EntCode = "001",
                    OrgCode = "102",
                    UserCode = "MH0551"
                },
                documentTypeCode = "TransIn002",
                businessDate = DateTime.Now.ToString("yyyy-MM-dd"),
                isApproved = true,

                miscShipList = stock.StockInfoDetails.Where(x => x.OutboundQuantity > 0).Select(item => new miscShipList
                {
                    //物料编码
                    ItemCode = item.MaterielCode,
                    //存储地点编号
                    WhCode = item.Warehouse,
                    //杂发数量
                    Qty = item.OutboundQuantity,
                    BenefitDeptCode = "0505",
                }).ToList()
            };
            return content.OK(data: send);
        }
        catch (Exception ex)
        {
            return content.Error(ex.Message);
        }
    }
    /// <summary>
    /// æ‚收
    /// </summary>
    /// <param name="palletCode"></param>
    /// <returns></returns>
    public async Task<WebResponseContent> ERPMixedReceive(string palletCode)
    {
        WebResponseContent content = new WebResponseContent();
        try
        {
            DtStockInfo stock = await _stockInfoRepository.QueryFirstNavAsync(x => x.PalletCode == palletCode);
            MixedReceive allocate = new MixedReceive
            {
                context = new Context
                {
                    CultureName = "zh-CN",
                    EntCode = "001",
                    OrgCode = "102",
                    UserCode = "MH0551"
                },
                documentTypeCode = "TransIn002",
                businessDate = DateTime.Now.ToString("yyyy-MM-dd"),
                isApproved = true,

                miscRcvList = stock.StockInfoDetails.Where(x => x.OutboundQuantity > 0).Select(item => new miscRcvList
                {
                    ItemCode = item.MaterielCode,
                    TransInWHCode = item.Warehouse,
                    TransInQty = item.Quantity,
                    TransOutWHCode = "001",
                    WhCode = item.Warehouse,
                    Qty = item.OutboundQuantity,
                    CostPrice = 0,
                }).ToList()
            };
            return content.OK(data: allocate);
        }
        catch (Exception ex)
        {
            return content.Error(ex.Message);
        }
    }
    /// <summary>
    /// é€€æ–™
    /// </summary>
    /// <param name="palletCode"></param>
    /// <returns></returns>
    public async Task<WebResponseContent> ERPreturnMaterialList(string palletCode)
    {
        WebResponseContent content = new WebResponseContent();
        try
        {
            DtStockInfo stock = await _stockInfoRepository.QueryFirstNavAsync(x => x.PalletCode == palletCode);
            ReturnMaterials allocate = new ReturnMaterials
            {
                context = new Context
                {
                    CultureName = "zh-CN",
                    EntCode = "001",
                    OrgCode = "102",
                    UserCode = "MH0551"
                },
                documentTypeCode = "TransIn002",
                businessDate = DateTime.Now.ToString("yyyy-MM-dd"),
                isApproved = true,

                returnMaterialList = stock.StockInfoDetails.Select(item => new returnMaterialList
                {
                    PickListID = item.MaterielCode,
                    WhCode = item.Warehouse,
                    RecedeQty = item.OutboundQuantity,
                    RecedeReason = 1,
                }).ToList()
            };
            return content.OK(data: allocate);
@@ -1242,12 +1537,11 @@
        }
    }


    #endregion

    #region å†…部调用方法

    public void UpdateLocationStatus(DtLocationInfo location, LocationEnum locationStatus, int taskNum, int StatusChangeType)
    public (List<DtLocationStatusChangeRecord>,List<DtLocationInfo>) UpdateLocationStatus(DtLocationInfo location, LocationEnum locationStatus, int taskNum, int StatusChangeType)
    {
        List<DtLocationInfo> locations = GetGroupLocations(location);

@@ -1305,26 +1599,116 @@
                }
            }
        }
        List<LocationChangeRecordDto> changeRecordDto = new List<LocationChangeRecordDto>();
        List<DtLocationStatusChangeRecord> changeRecordDto = new List<DtLocationStatusChangeRecord>();
        foreach (var item in Beforelocation)
        {
            var loc = locations.Where(x => x.LocationCode == item.LocationCode).FirstOrDefault();
            if (loc != null)
            {
                changeRecordDto.Add(new LocationChangeRecordDto()
                DtLocationStatusChangeRecord dtLocationStatusChangeRecord = new DtLocationStatusChangeRecord()
                {
                    ChangeType = StatusChangeType,
                    LocationCode = item.LocationCode,
                    LocationId = loc.Id,
                    Creater = "System",
                    TaskNum = taskNum,
                    AfterStatus = loc.LocationStatus,
                    BeforeStatus = item.LocationStatus,
                    TaskNum = taskNum,
                    LocationId = loc.Id,
                    LocationCode = loc.LocationCode,
                    ChangeType = StatusChangeType,
                });
                };

                changeRecordDto.Add(dtLocationStatusChangeRecord);
            }
        }
        _locationStatusChangeRecordRepository.AddStatusChangeRecord(changeRecordDto);
        //_locationStatusChangeRecordRepository.AddStatusChangeRecord(changeRecordDto);

        _locationRepository.UpdateData(locations);
        //_locationRepository.UpdateData(locations);
        return (changeRecordDto,locations);
    }

    public (List<DtLocationStatusChangeRecord>, List<DtLocationInfo>) UpdateLocationStatus(string locationCode, LocationEnum locationStatus, int taskNum, int StatusChangeType)
    {
        var location = _locationRepository.QueryFirst(x => x.LocationCode == locationCode);

        List<DtLocationInfo> locations = GetGroupLocations(location);

        List<DtLocationInfo> Beforelocation = locations.Select(x => new DtLocationInfo
        {
            Id = x.Id,
            LocationCode = x.LocationCode,
            LocationStatus = x.LocationStatus
        }).ToList();

        foreach (var item in locations)
        {
            if (locationStatus == LocationEnum.Lock)
            {
                if (item.LocationCode == location.LocationCode)
                {
                    item.LocationStatus = (int)LocationEnum.Lock;
                }
                else if (item.LocationStatus == (int)LocationEnum.Free)
                {
                    item.LocationStatus = (int)LocationEnum.FreeDisable;
                }
            }
            else if (locationStatus == LocationEnum.InStock)
            {
                if (item.LocationCode == location.LocationCode)
                {
                    item.LocationStatus = (int)LocationEnum.InStock;
                }
                else if (item.LocationStatus == (int)LocationEnum.FreeDisable)
                {
                    item.LocationStatus = (int)LocationEnum.Free;
                }
            }
            else if (locationStatus == LocationEnum.InStockDisable)
            {
                if (item.LocationStatus == (int)LocationEnum.InStock)
                {
                    item.LocationStatus = (int)LocationEnum.InStockDisable;
                }
                else if (item.LocationStatus == (int)LocationEnum.Free)
                {
                    item.LocationStatus = (int)LocationEnum.FreeDisable;
                }
            }
            else if (locationStatus == LocationEnum.Free)
            {
                if (item.LocationCode == location.LocationCode)
                {
                    item.LocationStatus = (int)LocationEnum.Free;
                }
                else if (item.LocationStatus == (int)LocationEnum.FreeDisable || item.LocationStatus == (int)LocationEnum.InStockDisable)
                {
                    item.LocationStatus = (int)LocationEnum.Free;
                }
            }
        }
        List<DtLocationStatusChangeRecord> changeRecordDto = new List<DtLocationStatusChangeRecord>();
        foreach (var item in Beforelocation)
        {
            var loc = locations.Where(x => x.LocationCode == item.LocationCode).FirstOrDefault();
            if (loc != null)
            {
                DtLocationStatusChangeRecord dtLocationStatusChangeRecord = new DtLocationStatusChangeRecord()
                {
                    ChangeType = StatusChangeType,
                    LocationCode = item.LocationCode,
                    LocationId = loc.Id,
                    Creater = "System",
                    TaskNum = taskNum,
                    AfterStatus = loc.LocationStatus,
                    BeforeStatus = item.LocationStatus,
                };

                changeRecordDto.Add(dtLocationStatusChangeRecord);
            }
        }
        //_locationStatusChangeRecordRepository.AddStatusChangeRecord(changeRecordDto);

        //_locationRepository.UpdateData(locations);
        return (changeRecordDto, locations);
    }

    public List<DtLocationInfo> GetGroupLocations(DtLocationInfo location)
@@ -1606,74 +1990,59 @@
    /// <returns></returns>
    public async Task<DtLocationInfo> GetEmptyLocation(string roadWay)
    {
        try
        List<DtLocationInfo> locations = await _locationRepository.QueryDataAsync(x => x.RoadwayNo == "SC1" && x.LocationStatus == (int)LocationEnum.Free && x.EnalbeStatus == 1);
        if (locations.Count < 2)
        {
            List<DtLocationInfo> locations = await _locationRepository.QueryDataAsync(x => x.RoadwayNo == "SC1" && x.LocationStatus == (int)LocationEnum.Free && x.EnalbeStatus == 1);
            if (locations.Count < 2)
            {
                return null;
            }

            List<DtLocationInfo> locationInfos = new List<DtLocationInfo>();
            var locationInside = locations.Where(x => x.Row == 3).ToList();

            if (locations.Where(x => x.Row == 2).OrderBy(x => x.Layer).ThenBy(x => x.Column).FirstOrDefault() != null)
            {
                return locations.Where(x => x.Row == 2).ToList().OrderBy(x => x.Layer).ThenBy(x => x.Column).FirstOrDefault();
            }
            else if (locationInside.Count > 0)
            {
                foreach (var item in locationInside)
                {
                    var locationLateral = _locationRepository.QueryFirst(x => x.Row == 1 && x.Layer == item.Layer && x.Column == item.Column);
                    if (locationLateral.LocationStatus == (int)LocationEnum.Free && locationLateral.EnalbeStatus == 1)
                    {
                        locationInfos.Add(item);
                    }
                }

                return locationInfos.Distinct().OrderBy(x => x.Layer).ThenBy(x => x.Column).FirstOrDefault();
            }
            else if (locations.Where(x => x.Row == 1).OrderBy(x => x.Layer).ThenBy(x => x.Column).FirstOrDefault() != null)
            {
                return locations.Where(x => x.Row == 1).OrderBy(x => x.Layer).ThenBy(x => x.Column).FirstOrDefault();
            }
            else
            {
                return null;
            }
            return null;
        }
        catch (Exception ex)

        List<DtLocationInfo> locationInfos = new List<DtLocationInfo>();
        var locationInside = locations.Where(x => x.Row == 3).ToList();

        if (locations.Where(x => x.Row == 2).OrderBy(x => x.Layer).ThenBy(x => x.Column).FirstOrDefault() != null)
        {
            throw new Exception(ex.Message);
            return locations.Where(x => x.Row == 2).ToList().OrderBy(x => x.Layer).ThenBy(x => x.Column).FirstOrDefault();
        }
        else if (locationInside.Count > 0)
        {
            foreach (var item in locationInside)
            {
                var locationLateral = _locationRepository.QueryFirst(x => x.Row == 1 && x.Layer == item.Layer && x.Column == item.Column);
                if (locationLateral.LocationStatus == (int)LocationEnum.Free && locationLateral.EnalbeStatus == 1)
                {
                    locationInfos.Add(item);
                }
            }

            return locationInfos.Distinct().OrderBy(x => x.Layer).ThenBy(x => x.Column).FirstOrDefault();
        }
        else if (locations.Where(x => x.Row == 1).OrderBy(x => x.Layer).ThenBy(x => x.Column).FirstOrDefault() != null)
        {
            return locations.Where(x => x.Row == 1).OrderBy(x => x.Layer).ThenBy(x => x.Column).FirstOrDefault();
        }
        else
        {
            return null;
        }
    }

    public async Task<DtLocationInfo> GetAGVEmptyCacheLocation(int AreaId, DtLocationInfo loc)
    {
        try
        if (loc == null)
        {
            if(loc==null)
            {
                return null;
            }
            switch (AreaId)
            {
                case 2:
                    return await FromShallowToDeep(AreaId, loc);
                case 3:
                    return await AGVLIKU(AreaId);
                case 5:
                case 6:
                    return  await FromDeepToShallow(AreaId, loc);
                default:
                    return null;
            }

            return null;
        }
        catch (Exception ex)
        switch (AreaId)
        {
            throw new Exception(ex.Message);
            case 2:
                return await FromShallowToDeep(AreaId, loc);
            case 3:
                return await AGVLIKU(AreaId);
            case 5:
            case 6:
                return await FromDeepToShallow(AreaId, loc);
            default:
                return null;
        }
    }

@@ -1684,45 +2053,38 @@
    /// <returns></returns>
    public async Task<DtLocationInfo> FromDeepToShallow(int AreaId, DtLocationInfo loc)
    {
        try
        {
            List<DtLocationInfo> locations = new List<DtLocationInfo>();
        List<DtLocationInfo> locations = new List<DtLocationInfo>();

            if (AreaId == loc.AreaId)
        if (AreaId == loc.AreaId)
        {
            locations = await _locationRepository.QueryDataAsync(x => x.AreaId == AreaId && x.LocationStatus == (int)LocationEnum.Free && x.EnalbeStatus == 1 && x.Row != loc.Row);
        }
        else
        {
            locations = await _locationRepository.QueryDataAsync(x => x.AreaId == AreaId && x.LocationStatus == (int)LocationEnum.Free && x.EnalbeStatus == 1);
        }
        if (locations.Count == 0)
        {
            return null;
        }
        List<DtLocationInfo> locationInfos = new List<DtLocationInfo>();
        foreach (var item in locations)
        {
            var locationLateral = _locationRepository.QueryData(x => x.Row == item.Row && x.Column < item.Column && x.Remark == item.Remark);
            bool Isavailable = true;
            foreach (var lateral in locationLateral)
            {
                locations = await _locationRepository.QueryDataAsync(x => x.AreaId == AreaId && x.LocationStatus == (int)LocationEnum.Free && x.EnalbeStatus == 1 && x.Row != loc.Row);
            }
            else
            {
                locations = await _locationRepository.QueryDataAsync(x => x.AreaId == AreaId && x.LocationStatus == (int)LocationEnum.Free && x.EnalbeStatus == 1);
            }
            if (locations.Count == 0)
            {
                return null;
            }
            List<DtLocationInfo> locationInfos = new List<DtLocationInfo>();
            foreach (var item in locations)
            {
                var locationLateral = _locationRepository.QueryData(x => x.Row == item.Row && x.Column < item.Column && x.Remark == item.Remark);
                bool Isavailable = true;
                foreach (var lateral in locationLateral)
                if (lateral.LocationStatus != (int)LocationEnum.Free && lateral.EnalbeStatus == 1)
                {
                    if (lateral.LocationStatus != (int)LocationEnum.Free && lateral.EnalbeStatus == 1)
                    {
                        Isavailable = false;
                        continue;
                    }
                    Isavailable = false;
                    continue;
                }
                if(Isavailable)
                    locationInfos.Add(item);
            }
            if (Isavailable)
                locationInfos.Add(item);
        }

            return locationInfos.Distinct().OrderByDescending(x => x.Column).ThenBy(x => x.Row).FirstOrDefault();
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message);
        }
        return locationInfos.Distinct().OrderByDescending(x => x.Column).ThenBy(x => x.Row).FirstOrDefault();
    }

    /// <summary>
@@ -1732,118 +2094,102 @@
    /// <returns></returns>
    public async Task<DtLocationInfo> FromShallowToDeep(int AreaId, DtLocationInfo loc)
    {
        try
        List<DtLocationInfo> locations = new List<DtLocationInfo>();

        if (AreaId == loc.AreaId)
        {
            List<DtLocationInfo> locations = new List<DtLocationInfo>();
            locations = await _locationRepository.QueryDataAsync(x => x.AreaId == AreaId && x.LocationStatus == (int)LocationEnum.Free && x.EnalbeStatus == 1 && x.Row != loc.Row);
        }
        else
        {
            locations = await _locationRepository.QueryDataAsync(x => x.AreaId == AreaId && x.LocationStatus == (int)LocationEnum.Free && x.EnalbeStatus == 1);
        }

            if (AreaId == loc.AreaId)
        if (locations.Count == 0)
        {
            return null;
        }
        List<DtLocationInfo> locationInfos = new List<DtLocationInfo>();
        foreach (var item in locations)
        {
            var locationLateral = _locationRepository.QueryData(x => x.Row == item.Row && x.Column > item.Column && x.Remark == item.Remark);
            if (locationLateral.Count == 0)
            {
                locations = await _locationRepository.QueryDataAsync(x => x.AreaId == AreaId && x.LocationStatus == (int)LocationEnum.Free && x.EnalbeStatus == 1 && x.Row != loc.Row);
                locationInfos.Add(item);
                continue;
            }
            else
            foreach (var Lateral in locationLateral)
            {
                locations = await _locationRepository.QueryDataAsync(x => x.AreaId == AreaId && x.LocationStatus == (int)LocationEnum.Free && x.EnalbeStatus == 1);
            }

            if (locations.Count == 0)
            {
                return null;
            }
            List<DtLocationInfo> locationInfos = new List<DtLocationInfo>();
            foreach (var item in locations)
            {
                var locationLateral = _locationRepository.QueryData(x => x.Row == item.Row && x.Column > item.Column && x.Remark == item.Remark);
                if (locationLateral.Count == 0)
                if (locationInfos.Contains(Lateral))
                    continue;
                if (Lateral.LocationStatus == (int)LocationEnum.Free && Lateral.EnalbeStatus == 1)
                {
                    locationInfos.Add(item);
                    continue;
                }
                foreach (var Lateral in locationLateral)
                {
                    if (locationInfos.Contains(Lateral))
                        continue;
                    if (Lateral.LocationStatus == (int)LocationEnum.Free && Lateral.EnalbeStatus == 1)
                    {
                        locationInfos.Add(item);
                    }
                }
            }
        }

            return locationInfos.Distinct().OrderBy(x => x.Column).ThenBy(x => x.Row).FirstOrDefault();
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message);
        }
        return locationInfos.Distinct().OrderBy(x => x.Column).ThenBy(x => x.Row).FirstOrDefault();

    }


    public async Task<DtLocationInfo> AGVLIKU(int AreaId)
    {
        WebResponseContent content = new WebResponseContent();
        try
        {
            List<DtLocationInfo> locations = await _locationRepository.QueryDataAsync(x => x.AreaId == AreaId && x.LocationStatus == 0 && x.EnalbeStatus == 1);
            var location = locations.OrderBy(x => x.Layer).ThenBy(x => x.Column).FirstOrDefault();
            return location;
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message);
        }

        List<DtLocationInfo> locations = await _locationRepository.QueryDataAsync(x => x.AreaId == AreaId && x.LocationStatus == 0 && x.EnalbeStatus == 1);
        var location = locations.OrderBy(x => x.Layer).ThenBy(x => x.Column).FirstOrDefault();
        return location;

    }


    public bool LocationIsOutBound(DtLocationInfo location)
    {
        try

        int sum = 0;
        if (location.AreaId == 1)
        {
            int sum = 0;
            if (location.AreaId == 1)
            if (location.Depth == 2)
            {
                if (location.Depth == 2)
                {
                    var locationLateral = _locationRepository.QueryFirst(x => x.Row == 1 && x.Column == location.Column && x.Layer == location.Layer);
                var locationLateral = _locationRepository.QueryFirst(x => x.Row == 1 && x.Column == location.Column && x.Layer == location.Layer);

                    if (locationLateral.LocationStatus == (int)LocationEnum.Lock && locationLateral.EnalbeStatus == 1)
                    {
                        return false;
                    }
                if (locationLateral.LocationStatus == (int)LocationEnum.Lock && locationLateral.EnalbeStatus == 1)
                {
                    return false;
                }
            }

            else if (location.AreaId == 2)
            {
                var locationLateral = _locationRepository.QueryData(x => x.Row == location.Row && x.Column > location.Column && x.Remark == location.Remark);

                foreach (var Lateral in locationLateral)
                {
                    if (Lateral.LocationStatus == (int)LocationEnum.Lock && Lateral.EnalbeStatus == 1)
                    {
                        return false;
                    }
                }
            }

            else if (location.AreaId == 5 || location.AreaId == 6)
            {
                var locationLateral = _locationRepository.QueryData(x => x.Row == location.Row && x.Column < location.Column && x.Remark == location.Remark);

                foreach (var lateral in locationLateral)
                {
                    if (lateral.LocationStatus == (int)LocationEnum.Lock && lateral.EnalbeStatus == 1)
                    {
                        return false;
                    }
                }
            }

            return true;
        }
        catch (Exception)

        else if (location.AreaId == 2)
        {
            return false;
            var locationLateral = _locationRepository.QueryData(x => x.Row == location.Row && x.Column > location.Column && x.Remark == location.Remark);

            foreach (var Lateral in locationLateral)
            {
                if (Lateral.LocationStatus == (int)LocationEnum.Lock && Lateral.EnalbeStatus == 1)
                {
                    return false;
                }
            }
        }

        else if (location.AreaId == 5 || location.AreaId == 6)
        {
            var locationLateral = _locationRepository.QueryData(x => x.Row == location.Row && x.Column < location.Column && x.Remark == location.Remark);

            foreach (var lateral in locationLateral)
            {
                if (lateral.LocationStatus == (int)LocationEnum.Lock && lateral.EnalbeStatus == 1)
                {
                    return false;
                }
            }
        }

        return true;

    }