1

Zhang-Hong-Lin

2025-04-27 90a00e294885d4a62fa7d8927513ff6f948ce6b4

 ÏîÄ¿´úÂë/WCS/WIDESEAWCS_Server/WIDESEAWCS_TaskInfoService/TaskService.cs

@@ -51,6 +51,11 @@
        private readonly Idt_ErrormsginfoService _ErrormsginfoService;
        private readonly IMapper _mapper;
        private readonly IRepository<dt_stationInfo> _dt_stationInfoRepository;
        private readonly IRepository<Dt_Task> _dt_taskRepositiry;
        private readonly IRepository<Dt_LocationInfo> _LocationInfoRepository;
        private readonly IRepository<Dt_StockInfo> _StockInfoRepository;
        private readonly IRepository<dt_batchInfo> _batchInfoRepository;
        private readonly IRepository<dt_outstockinfo> _outStockRepository;

        private Dictionary<string, OrderByType> _taskOrderBy = new()
            {
@@ -80,8 +85,13 @@
            IRepository<Dt_Task_hty> taskhtyRepository,
            IRepository<dt_errormsgInfo> errorinfoRepository,
            IRepository<dt_stationInfo> dt_stationInfoRepository,
            IRepository<Dt_Task> dt_taskRepositiry,
            Idt_ErrormsginfoService errormsginfoService,
            IUnitOfWorkManage unitOfWorkManage,
            IRepository<Dt_StockInfo> StockInfoRepository,
            IRepository<dt_batchInfo> batchInfoRepository,
            IRepository<Dt_LocationInfo> LocationInfoRepository,
            IRepository<dt_outstockinfo> outStockRepository,
            IMapper mapper) : base(BaseDal)
        {
            _routerService = routerService;
@@ -96,6 +106,11 @@
            _ErrormsginfoService = errormsginfoService;
            _mapper = mapper;
            _dt_stationInfoRepository = dt_stationInfoRepository;
            _dt_taskRepositiry = dt_taskRepositiry;
            _StockInfoRepository = StockInfoRepository;
            _LocationInfoRepository = LocationInfoRepository;
            _batchInfoRepository = batchInfoRepository;
            _outStockRepository = outStockRepository;
        }

        /// <summary>
@@ -808,7 +823,7 @@
                        Movstask.TaskType = (int)TaskMoveEnum.Mowe;
                        Movstask.TaskState = (int)TaskMoveStatusEnum.OutNewMove;
                        Movstask.SourceAddress = "0";
                        Movstask.TargetAddress = "1-5-1";
                        Movstask.TargetAddress = "8-5-1";
                        Movstask.NextAddress = "text";
                        Movstask.Grade = 1;
                        Movstask.WMSId = 3;
@@ -854,7 +869,7 @@
                        Movstask.TaskType = (int)TaskMoveEnum.Mowe;
                        Movstask.TaskState = (int)TaskMoveStatusEnum.OutNewMove;
                        Movstask.SourceAddress = "0";
                        Movstask.TargetAddress = "1-5-1";
                        Movstask.TargetAddress = "8-5-1";
                        Movstask.NextAddress = "text";
                        Movstask.Grade = 1;
                        Movstask.WMSId = 3;
@@ -981,5 +996,385 @@
            }
            return content;
        }

        public WebResponseContent AtOnceUpdate(int taskid)
        {
            WebResponseContent content = new WebResponseContent();
            Dt_Task nawtask = BaseDal.QueryFirst(v => v.TaskId == taskid);
            //入库
            if (nawtask.TaskType == (int)TaskInboundTypeEnum.Inbound)
            {
                //剔除入库
                var station = _dt_stationInfoRepository.QueryFirst(v => v.msg == "剔除架");
                string sourceAddress = station.Row + "-" + station.Column + "-1";
                if (nawtask.SourceAddress.Equals(sourceAddress))
                {
                    var batck = _batchinfoRepository.QueryFirst(v => v.Id == 1);
                    //新建库存
                    Dt_StockInfo stock = new Dt_StockInfo();
                    stock.LocationCode = nawtask.TargetAddress;
                    stock.StockStatus = (int)stockEnum.Free;
                    stock.BatchNo = batck.InBatch;
                    stock.Remark = 3;
                    //修改货位信息
                    var location = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.TargetAddress);
                    location.LocationStatus = (int)LocationStatusEnum.InStock;
                    //处理任务信息
                    Dt_Task_hty taskhty = new Dt_Task_hty();
                    taskhty.TaskNum = nawtask.TaskNum;
                    taskhty.Roadway = nawtask.Roadway;
                    taskhty.TaskType = nawtask.TaskType;
                    taskhty.TaskState = (int)TaskInStatusEnum.Line_InFinish;
                    taskhty.SourceAddress = nawtask.SourceAddress;
                    taskhty.TargetAddress = nawtask.TargetAddress;
                    taskhty.ExceptionMessage = nawtask.ExceptionMessage;
                    taskhty.Grade = nawtask.Grade;
                    taskhty.Dispatchertime = nawtask.Dispatchertime;
                    taskhty.Remark = nawtask.Remark;
                    taskhty.PalletCode = nawtask.PalletCode;
                    taskhty.NextAddress = nawtask.NextAddress;
                    taskhty.CurrentAddress = nawtask.CurrentAddress;

                    //开始数据库事务
                    _unitOfWorkManage.BeginTran();
                    _stockRepository.AddData(stock);
                    _locationRepository.UpdateData(location);
                    _taskhtyRepository.AddData(taskhty);
                    BaseDal.DeleteData(nawtask);
                    //提交事务
                    _unitOfWorkManage.CommitTran();
                }
                //正常入库
                else
                {
                    var batck = _batchinfoRepository.QueryFirst(v => v.Id == 1);
                    //新建库存
                    Dt_StockInfo stock = new Dt_StockInfo();
                    stock.LocationCode = nawtask.TargetAddress;
                    stock.StockStatus = (int)stockEnum.Free;
                    stock.BatchNo = batck.InBatch;
                    if (nawtask.Remark == (int)MateTypeEnum.ZiChan)
                    {
                        stock.Remark = (int)MateTypeEnum.ZiChan;
                    }
                    else
                    {
                        stock.Remark = (int)MateTypeEnum.WaiGou;
                    }
                    Dt_StockInfo stockTow = new Dt_StockInfo();
                    stockTow.LocationCode = nawtask.NextAddress;
                    stockTow.StockStatus = (int)stockEnum.Free;
                    stockTow.BatchNo = batck.InBatch;
                    if (nawtask.Remark == (int)MateTypeEnum.ZiChan)
                    {
                        stockTow.Remark = (int)MateTypeEnum.ZiChan;
                    }
                    else
                    {
                        stockTow.Remark = (int)MateTypeEnum.WaiGou;
                    }
                    //修改货位信息
                    var location = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.TargetAddress);
                    location.LocationStatus = (int)LocationStatusEnum.InStock;
                    //修改货位信息
                    var locationtow = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.NextAddress);
                    locationtow.LocationStatus = (int)LocationStatusEnum.InStock;
                    //处理任务信息
                    Dt_Task_hty taskhty = new Dt_Task_hty();
                    taskhty.TaskNum = nawtask.TaskNum;
                    taskhty.Roadway = nawtask.Roadway;
                    taskhty.TaskType = nawtask.TaskType;
                    taskhty.TaskState = (int)TaskInStatusEnum.Line_InFinish;
                    taskhty.SourceAddress = nawtask.SourceAddress;
                    taskhty.TargetAddress = nawtask.TargetAddress;
                    taskhty.ExceptionMessage = nawtask.ExceptionMessage;
                    taskhty.Grade = nawtask.Grade;
                    taskhty.Dispatchertime = nawtask.Dispatchertime;
                    taskhty.Remark = nawtask.Remark;
                    taskhty.PalletCode = nawtask.PalletCode;
                    taskhty.NextAddress = nawtask.NextAddress;
                    taskhty.CurrentAddress = nawtask.CurrentAddress;

                    //开始数据库事务
                    _unitOfWorkManage.BeginTran();
                    _stockRepository.AddData(stock);
                    _stockRepository.AddData(stockTow);
                    _locationRepository.UpdateData(location);
                    _locationRepository.UpdateData(locationtow);
                    _taskhtyRepository.AddData(taskhty);
                    BaseDal.DeleteData(nawtask);
                    //提交事务
                    _unitOfWorkManage.CommitTran();
                }
            }
            //出库
            else if (nawtask.TaskType == (int)TaskOutboundTypeEnum.Outbound)
            {
                //剔除出库
                var station = _dt_stationInfoRepository.QueryFirst(v => v.msg == "西跨架子");
                string targetAddress = station.Row + "-" + station.Column + "-1";
                if (nawtask.TargetAddress.Equals(targetAddress))
                {
                    //查找库存
                    var stock = _stockRepository.QueryFirst(v => v.LocationCode == nawtask.SourceAddress);
                    if (stock == null)
                    {
                        throw new Exception($"未找到库存信息货位号:【{nawtask.TargetAddress}】");
                    }
                    //修改货位状态
                    var location = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.SourceAddress);
                    location.LocationStatus = (int)LocationStatusEnum.Free;
                    //准备历史任务数据
                    Dt_Task_hty taskhty = new Dt_Task_hty();
                    taskhty.TaskNum = nawtask.TaskNum;
                    taskhty.Roadway = nawtask.Roadway;
                    taskhty.TaskType = nawtask.TaskType;
                    taskhty.TaskState = (int)TaskOutStatusEnum.OutFinish;
                    taskhty.SourceAddress = nawtask.SourceAddress;
                    taskhty.TargetAddress = nawtask.TargetAddress;
                    taskhty.ExceptionMessage = nawtask.ExceptionMessage;
                    taskhty.Grade = nawtask.Grade;
                    taskhty.Dispatchertime = nawtask.Dispatchertime;
                    taskhty.Remark = nawtask.Remark;
                    taskhty.PalletCode = nawtask.PalletCode;
                    taskhty.NextAddress = nawtask.NextAddress;
                    taskhty.CurrentAddress = nawtask.CurrentAddress;
                    //开始数据库事务

                    _unitOfWorkManage.BeginTran();
                    _stockRepository.DeleteData(stock);
                    _locationRepository.UpdateData(location);
                    _taskhtyRepository.AddData(taskhty);
                    BaseDal.DeleteData(nawtask);
                    //提交事务
                    _unitOfWorkManage.CommitTran();
                }
                //正常出库
                else
                {
                    //查找库存
                    var stock = _stockRepository.QueryFirst(v => v.LocationCode == nawtask.SourceAddress);
                    if (stock == null)
                    {
                        throw new Exception($"未找到库存信息货位号:【{nawtask.TargetAddress}】");
                    }
                    var Towstock = _stockRepository.QueryFirst(v => v.LocationCode == nawtask.NextAddress);
                    //修改货位状态
                    var location = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.SourceAddress);
                    location.LocationStatus = (int)LocationStatusEnum.Free;
                    //修改货位状态
                    var locationTow = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.NextAddress);
                    locationTow.LocationStatus = (int)LocationStatusEnum.Free;
                    //准备历史任务数据
                    Dt_Task_hty taskhty = new Dt_Task_hty();
                    taskhty.TaskNum = nawtask.TaskNum;
                    taskhty.Roadway = nawtask.Roadway;
                    taskhty.TaskType = nawtask.TaskType;
                    taskhty.TaskState = (int)TaskOutStatusEnum.OutFinish;
                    taskhty.SourceAddress = nawtask.SourceAddress;
                    taskhty.TargetAddress = nawtask.TargetAddress;
                    taskhty.ExceptionMessage = nawtask.ExceptionMessage;
                    taskhty.Grade = nawtask.Grade;
                    taskhty.Dispatchertime = nawtask.Dispatchertime;
                    taskhty.Remark = nawtask.Remark;
                    taskhty.PalletCode = nawtask.PalletCode;
                    taskhty.NextAddress = nawtask.NextAddress;
                    taskhty.CurrentAddress = nawtask.CurrentAddress;
                    //开始数据库事务

                    _unitOfWorkManage.BeginTran();
                    _stockRepository.DeleteData(stock);
                    _stockRepository.DeleteData(Towstock);
                    _locationRepository.UpdateData(location);
                    _locationRepository.UpdateData(locationTow);
                    _taskhtyRepository.AddData(taskhty);
                    BaseDal.DeleteData(nawtask);
                    //提交事务
                    _unitOfWorkManage.CommitTran();
                }
            }
            return content.OK("完成");
        }

        public WebResponseContent speciadelete(Dt_Task task)
        {
            WebResponseContent content = new WebResponseContent();
            if (task.TaskState == (int)TaskMoveStatusEnum.OutNewMove)
            {
                BaseDal.DeleteData(task);
            }
            else if (task.TaskState == (int)TaskInStatusEnum.InNew)
            {
                //剔除入库
                var station = _dt_stationInfoRepository.QueryFirst(v => v.msg == "剔除架");
                string sourceAddress = station.Row + "-" + station.Column + "-1";
                if (task.SourceAddress.Equals(sourceAddress))
                {
                    Dt_LocationInfo locationinfo = _locationRepository.QueryFirst(v => v.LocationCode == task.TargetAddress);
                    locationinfo.LocationStatus = 0;
                    _unitOfWorkManage.BeginTran();
                    _locationRepository.UpdateData(locationinfo);
                    BaseDal.DeleteData(task);
                    _unitOfWorkManage.CommitTran();
                    return content.OK("2");
                }
                else
                {
                    //修改货位信息
                    var location = _locationRepository.QueryFirst(v => v.LocationCode == task.TargetAddress);
                    location.LocationStatus = (int)LocationStatusEnum.Free;
                    //修改货位信息
                    var locationtow = _locationRepository.QueryFirst(v => v.LocationCode == task.NextAddress);
                    locationtow.LocationStatus = (int)LocationStatusEnum.Free;
                    _unitOfWorkManage.BeginTran();
                    _locationRepository.UpdateData(location);
                    _locationRepository.UpdateData(locationtow);
                    BaseDal.DeleteData(task);
                    _unitOfWorkManage.CommitTran();
                    return content.OK("3");
                }
            }
            else if (task.TaskState == (int)TaskOutStatusEnum.OutNew)
            {
                //剔除出库
                var station = _dt_stationInfoRepository.QueryFirst(v => v.msg == "西跨架子");
                string targetAddress = station.Row + "-" + station.Column + "-1";
                if (task.TargetAddress.Equals(targetAddress))
                {
                    //修改货位信息
                    var location = _locationRepository.QueryFirst(v => v.LocationCode == task.SourceAddress);
                    location.LocationStatus = (int)LocationStatusEnum.InStock;
                    Dt_StockInfo stockInfo = _stockRepository.QueryFirst(v => v.LocationCode == task.SourceAddress);
                    stockInfo.StockStatus = (int)stockEnum.Free;
                    _unitOfWorkManage.BeginTran();
                    _locationRepository.UpdateData(location);
                    _stockRepository.UpdateData(stockInfo);
                    BaseDal.DeleteData(task);
                    _unitOfWorkManage.CommitTran();
                    return content.OK("4");
                }
                else
                {
                    //修改货位信息
                    var location = _locationRepository.QueryFirst(v => v.LocationCode == task.SourceAddress);
                    location.LocationStatus = (int)LocationStatusEnum.InStock;
                    //修改货位信息
                    var locationtow = _locationRepository.QueryFirst(v => v.LocationCode == task.NextAddress);
                    locationtow.LocationStatus = (int)LocationStatusEnum.InStock;

                    Dt_StockInfo stockInfo = _stockRepository.QueryFirst(v => v.LocationCode == task.SourceAddress);
                    stockInfo.StockStatus = (int)stockEnum.Free;
                    Dt_StockInfo stockInfos = _stockRepository.QueryFirst(v => v.LocationCode == task.NextAddress);
                    stockInfos.StockStatus = (int)stockEnum.Free;
                    _unitOfWorkManage.BeginTran();
                    _locationRepository.UpdateData(location);
                    _locationRepository.UpdateData(locationtow);
                    _stockRepository.UpdateData(stockInfo);
                    _stockRepository.UpdateData(stockInfos);
                    BaseDal.DeleteData(task);
                    _unitOfWorkManage.CommitTran();
                    return content.OK("5");
                }
            }
            return content.OK("1");
        }

        public WebResponseContent speciaupdate(Dt_Task task)
        {
            WebResponseContent content = new WebResponseContent();
            if (task.TaskState == (int)TaskInStatusEnum.InNew)
            {
                task.TaskState = (int)TaskInStatusEnum.Line_Ingrab;
                BaseDal.UpdateData(task);
            }
            else if (task.TaskState == (int)TaskInStatusEnum.Line_Ingrab)
            {
                task.TaskState = (int)TaskInStatusEnum.InNew;
                BaseDal.UpdateData(task);
            }
            else if (task.TaskState == (int)TaskOutStatusEnum.OutNew)
            {
                task.TaskState = (int)TaskOutStatusEnum.SC_OutExecuting;
                BaseDal.UpdateData(task);
            }
            else if (task.TaskState == (int)TaskOutStatusEnum.SC_OutExecuting)
            {
                task.TaskState = (int)TaskOutStatusEnum.OutNew;
                BaseDal.UpdateData(task);
            }
            else
            {
                return content.OK("状态不允许");
            }
            return content.OK("1");
        }

        public WebResponseContent banzidong(string wei,string weis)
        {
            WebResponseContent content = new WebResponseContent();
            //if (!OHTJob.oHTReadData.R_ZXJ_isWork)
            //{
            //    throw new Exception($"整形机投入使用信号为false");
            //}
            var isout = _outStockRepository.QueryFirst(v => v.Id == 1);
            if (isout.isout == 0)
            {
                //if (!OHTJob.oHTReadData.R_ZXJ_TCMode)
                //{
                //    throw new Exception($"整形机不属于天车上料模式或天车放板信号为false");
                //}
                //if (!OHTJob.oHTReadData.R_HC_isReadyWork)
                //{
                //    throw new Exception($"整形机天车放板信号为false");
                //}
                //查询当前任务池中是否存在出库任务，出库任务只能存在一条
                var oldtask = _dt_taskRepositiry.QueryFirst(v => v.TaskType == (int)TaskOutboundTypeEnum.Outbound);
                if (oldtask != null)
                {
                    throw new Exception($"当前任务池中已存在一条出库任务");
                }

                //查询库存
                Dt_StockInfo ku = _stockRepository.QueryFirst(v => v.LocationCode == wei);
                if (ku == null)
                {
                    return content.OK("3");
                }
                //查询相邻库存
                Dt_StockInfo kus = _stockRepository.QueryFirst(v => v.LocationCode == weis);
                ku.StockStatus = (int)stockEnum.Lock;
                kus.StockStatus = (int)stockEnum.Lock;
                //查询货位
                Dt_LocationInfo huo = _LocationInfoRepository.QueryFirst(v => v.LocationCode == wei);
                //查询相邻货位
                Dt_LocationInfo huos = _LocationInfoRepository.QueryFirst(v => v.LocationCode == weis);
                huo.LocationStatus = (int)LocationStatusEnum.Lock;
                huos.LocationStatus = (int)LocationStatusEnum.Lock;
                //查询终点站台信息
                var station = _dt_stationInfoRepository.QueryFirst(v => v.msg == "整形机放料位");
                //开始创建任务
                Dt_Task outtask = new Dt_Task();
                outtask.Roadway = "TC01";
                outtask.TaskType = (int)TaskOutboundTypeEnum.Outbound;
                outtask.TaskState = (int)TaskOutStatusEnum.OutNew;
                outtask.SourceAddress = ku.LocationCode;
                outtask.TargetAddress = station.Row + "-" + station.Column + "-1";
                outtask.NextAddress = huos.LocationCode;
                outtask.Grade = 2;
                outtask.WMSId = 3;
                outtask.Remark = kus.Remark;
                outtask.PalletCode = "text";
                outtask.CurrentAddress = "text";
                _unitOfWorkManage.BeginTran();
                _LocationInfoRepository.UpdateData(huo);
                _LocationInfoRepository.UpdateData(huos);
                _StockInfoRepository.UpdateData(ku);
                _dt_taskRepositiry.AddData(outtask);
                _StockInfoRepository.UpdateData(kus);
                _unitOfWorkManage.CommitTran();
                return content.OK("2");
            }
            return content.OK("1");
        }
    }
}