1

huanghongfeng

2024-12-02 e2a5657e3a0b8615bcd78a3149e5ba9ce5579bb8

 ´úÂë¹ÜÀí/WMS/WIDESEA_WMSServer/WIDESEA_TaskInfoService/PartialTaskService_Inbound.cs

@@ -11,6 +11,7 @@
using Microsoft.Extensions.Logging;
using MailKit.Search;
using System.Reflection.Metadata;
using static WIDESEA_ITaskInfoService.ITaskService;

namespace WIDESEA_TaskInfoService
{
@@ -120,9 +121,6 @@
                    };
                    BaseDal.AddData(task);
                    int beforeStatus = locationInfo.LocationStatus;


                    
                    if (isUpdateStock)
                    {
                        locationInfo.LocationStatus = LocationStatusEnum.Lock.ObjToInt();
@@ -212,37 +210,64 @@
        /// </summary>
        /// <param name="PalletCode"></param>
        /// <returns></returns>
        public WebResponseContent GenerateInventoryInformation(string SourceAddress, string PalletCode)
        public WebResponseContent GenerateInventoryInformation(GenerateInv generate)
        {
           
            WebResponseContent content = new WebResponseContent();
            try
            {
                Dt_Task task = BaseDal.QueryFirst(x => x.PalletCode == PalletCode);
                Dt_Task task = BaseDal.QueryFirst(x => x.PalletCode == generate.PalletCode);
                if (task != null)
                {
                    return content = WebResponseContent.Instance.Error($"已有该托盘的入库任务，托盘号：{task.PalletCode}");
                }
                else
                {
                    Dt_StockInfo dt_StockInfo = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == PalletCode);
                    if (dt_StockInfo == null)
                    
                    if ((generate.SourceAddress == "R01-003-041-011-01" || generate.SourceAddress == "R01-002-043-001-01" || generate.SourceAddress == "R02-003-027-011-01"))
                    {
                        Dt_StockInfo dt_StockInfo2 = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
                       if(dt_StockInfo2 == null)
                        {
                            Dt_StockInfo dt_Stock = new()
                            {
                                PalletCode = generate.PalletCode,
                                IsFull = true,
                                StockStatus = (int)StockStatusEmun.组盘暂存,
                                Creater = "WMS",
                                CreateDate = DateTime.Now,
                                MaterialType = (int)InventoryMaterialType.空托,
                                Materialweight = 0,
                                Wlstatus = (int)InventoryMaterialStatus.空托,
                            };
                            _stockService.StockInfoService.Repository.AddData(dt_Stock);
                        }
                    }
                    Dt_StockInfo dt_StockInfo = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
                    if (dt_StockInfo != null)
                    {
                        Dt_LocationInfo newLocation;
                        Dt_LocationInfo newSourceAddress;
                        newSourceAddress = _basicService.LocationInfoService.GetLocationplatform(SourceAddress);
                        newLocation = _basicService.LocationInfoService.GetLocation(newSourceAddress.RoadwayNo);
                        string[] Pallet = PalletCode.Split("-");
                        newSourceAddress = _basicService.LocationInfoService.GetLocationplatform(generate.SourceAddress);
                        int Locationtype = 9;   //默认为9
                        if(dt_StockInfo.MaterialType== (int)InventoryMaterialType.成品  || (generate.SourceAddress == "R01-003-041-001-01" && dt_StockInfo.MaterialType == (int)InventoryMaterialType.原材料))
                        {
                            Locationtype = 11;
                        }else if(dt_StockInfo.MaterialType == (int)InventoryMaterialType.原材料)
                        {
                            Locationtype = 10;
                        }
                        newLocation = _basicService.LocationInfoService.GetLocation(newSourceAddress.RoadwayNo, Locationtype);
                        //string[] Pallet = PalletCode.Split("-");
                        if (newLocation != null && newSourceAddress != null)
                        {


                            //生成入库任务
                            Dt_Task dt_Task = new()
                            {
                                PalletCode = PalletCode,
                                PalletCode = generate.PalletCode,
                                TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum)),
                                Roadway = newLocation.RoadwayNo,
                                TaskType = newSourceAddress.LocationType == (int)LocationTypeEnum.EmptyOut ? TaskTypeEnum.PalletInbound.ObjToInt() : TaskTypeEnum.Inbound.ObjToInt(),
                                TaskType = TaskTypeEnum.Inbound.ObjToInt(),
                                TaskStatus = InTaskStatusEnum.InNew.ObjToInt(),
                                SourceAddress = newSourceAddress.LocationCode,
                                TargetAddress = newLocation.LocationCode,
@@ -252,21 +277,8 @@
                                Creater = "WMS",
                                Depth = newLocation.Depth,
                                CreateDate = DateTime.Now,
                                MaterialType= dt_StockInfo.MaterialType
                            };
                            Dt_StockInfo dt_Stock = new()
                            {
                                PalletCode = PalletCode,
                                LocationCode = newLocation.LocationCode,
                                IsFull = true,
                                StockStatus = (int)StockStatusEmun.组盘暂存,
                                Creater = "WMS",
                                CreateDate = DateTime.Now,
                                MaterialType = newSourceAddress.LocationType == (int)LocationTypeEnum.EmptyIn ? (int)InventoryMaterialType.空托:
                                (newSourceAddress.LocationType == (int)LocationTypeEnum.FinishedIn ? (int)InventoryMaterialType.成品: (int)InventoryMaterialType.原材料),
                                Materialweight = float.Parse(Pallet[3]),
                            };
                            

                            _unitOfWorkManage.BeginTran();
                            if (newLocation.LocationStatus == LocationStatusEnum.Free.ObjToInt())
                            {
@@ -274,22 +286,23 @@
                            }
                            BaseDal.AddData(dt_Task);
                            _basicService.LocationInfoService.UpdateData(newLocation);
                            _stockService.StockInfoService.Repository.AddData(dt_Stock);
                           

                            _unitOfWorkManage.CommitTran();

                            return content = WebResponseContent.Instance.OK(data: dt_Task);
                        }
                        else
                        {
                            return content = WebResponseContent.Instance.Error($"未找到对应的起点:{SourceAddress},或终点{newSourceAddress.RoadwayNo}，信息");
                            return content = WebResponseContent.Instance.Error($"未找到对应的起点:{generate.SourceAddress},或终点{newSourceAddress.RoadwayNo}，信息");
                        }

                    }
                    else
                    {
                        return content = WebResponseContent.Instance.Error($"该托盘号已入库，请核对托盘号:{PalletCode}");
                        //Queryinventory(generate.PalletCode);
                        return content = WebResponseContent.Instance.Error($"组盘，请核对托盘号:{generate.PalletCode}");
                    }

                }

            }
@@ -304,28 +317,395 @@
        /// æŸ¥è¯¢1巷道库存，是否运行进行入库  //带后续重新拼接
        /// </summary>
        /// <returns></returns>
        public WebResponseContent Queryinventory(string palletCode)
        public WebResponseContent Queryinventory3(GenerateInv generate)
        {
            WebResponseContent content = new WebResponseContent();
            string[] targetCodes = palletCode.Split("-");
            if (targetCodes[2] == "2")
            try
            {
                List<Dt_LocationInfo> LocationInfo = _basicService.LocationInfoService.Repository.QueryData(x => x.RoadwayNo == "2" && x.LocationType == (int)LocationStatusEnum.Free).ToList();
                if (LocationInfo.Count < 40)
                WebResponseContent content = new WebResponseContent();
                string result = generate.PalletCode.Substring(0, 2);
                Dt_InboundOrder dt_Inbound = _inboundService.InbounOrderService.Repository.QueryFirst(x => x.UpperOrderNo == result);
                Dt_StockInfo dt_StockInfo = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
                if (dt_Inbound != null)
                {
                    return content = WebResponseContent.Instance.OK();
                    if (dt_StockInfo == null)
                    {
                        Dt_StockInfo dt_Stock = new()
                        {
                            PalletCode = generate.PalletCode,
                            IsFull = true,
                            StockStatus = (int)StockStatusEmun.组盘暂存,
                            Creater = "WMS",
                            CreateDate = DateTime.Now,
                            MaterialType = (int)InventoryMaterialType.原材料,
                            Materialweight = 0,
                        };
                        _unitOfWorkManage.BeginTran();
                        _stockService.StockInfoService.Repository.AddData(dt_Stock);

                        string part2 = generate.PalletCode.Substring(2, 8);

                        string part3 = generate.PalletCode.Split('#')[1];
                        Dt_StockInfo dt_StockInfo2= _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
                        Dt_StockInfoDetail dt_StockInfoDetail = new()
                        {
                            StockId = dt_StockInfo2.Id,
                            MaterielCode = result,    //物料编号
                            MaterielName = dt_Inbound.OrderNo,    //材质
                            OrderNo = generate.PalletCode,        //单据（托盘条码）
                            BatchNo = part2,         //批次号
                            SerialNumber = part3,    //序列号
                            StockQuantity = 1,    //序列号
                            OutboundQuantity = 1,    //序列号
                            Status = (int)StockStatusEmun.组盘暂存,
                            Creater = "WMS",
                            CreateDate = DateTime.Now,
                        };
                        _stockService.StockInfoDetailService.AddData(dt_StockInfoDetail);

                        _unitOfWorkManage.CommitTran();
                        return content = WebResponseContent.Instance.OK();
                    }
                    else
                    {
                        return content = WebResponseContent.Instance.OK();
                    }

                }
                else
                {
                    return content = WebResponseContent.Instance.Error();
                    return content = WebResponseContent.Instance.Error("未找到该类型的解析");
                }
                
            }
            catch (Exception ex)
            {

                throw;
            }
        }

        /// <summary>
        /// è§£æžåº“å­˜
        /// </summary>
        /// <returns></returns>
        public WebResponseContent Queryinventory(GenerateInv generate)
        {
            WebResponseContent content = new WebResponseContent();
            try
            {

                string[] targetCodes = generate.PalletCode.Split("*");
                if (targetCodes.Length == 4)
                {
                    Dt_InboundOrder dt_Inbound = _inboundService.InbounOrderService.Repository.QueryFirst(x => x.OrderName == targetCodes[0]);

                    if(dt_Inbound != null)
                    {
                        Dt_StockInfo dt_StockInfo = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
                        if (dt_Inbound.OrderType == (int)InventoryMaterialType.原材料)   //0为原材料编码
                        {
                            List<Dt_LocationInfo> locationInfos = _basicService.LocationInfoService.Repository.QueryData(x => x.RoadwayNo == "2" && x.LocationStatus == (int)LocationStatusEnum.Free && x.Depth == 1 && x.EnableStatus == (int)EnableStatusEnum.Normal && x.LocationType == (int)LocationTypeEnum.MaterialsCube);

                            if (dt_StockInfo == null)
                            {
                                Dt_StockInfo dt_Stock = new()
                                {
                                    PalletCode = generate.PalletCode,
                                    IsFull = true,
                                    StockStatus = (int)StockStatusEmun.组盘暂存,
                                    Creater = "WMS",
                                    CreateDate = DateTime.Now,
                                    MaterialType = (int)InventoryMaterialType.原材料,
                                    Materialweight = decimal.Parse(targetCodes[3]),
                                    Wlstatus = (int)InventoryMaterialStatus.待检,
                                };
                                _unitOfWorkManage.BeginTran();
                                _stockService.StockInfoService.Repository.AddData(dt_Stock);
                                Dt_StockInfo dt_StockInfo2 = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
                                string part2 = targetCodes[1].Substring(0, 2);  //解析物料批次找详情
                                Dt_InboundOrder dt_Int = _inboundService.InbounOrderService.Repository.QueryFirst(x => x.UpperOrderNo == part2);

                                Dt_StockInfoDetail dt_StockInfoDetail = new()
                                {
                                    StockId = dt_StockInfo2.Id,
                                    MaterielCode = dt_Inbound.OrderName,    //物料号
                                    MaterielName = dt_Inbound.UpperOrderNo,    //物料名称
                                    OrderNo = dt_Inbound.OrderNo,        //物料详情
                                    BatchNo = targetCodes[1].ToString(),         //物料批次
                                    SerialNumber = targetCodes[2].ToString(),    //包号
                                    BatchNoName = dt_Int.OrderNo,
                                    StockQuantity = decimal.Parse(targetCodes[3].ToString()),    //重量
                                    OutboundQuantity = 1,    //序列号
                                    Status = (int)StockStatusEmun.组盘暂存,
                                    Creater = "WMS",
                                    CreateDate = DateTime.Now,

                                };
                                _stockService.StockInfoDetailService.AddData(dt_StockInfoDetail);
                                _unitOfWorkManage.CommitTran();
                                if (locationInfos.Count < 50)
                                {
                                    return content = WebResponseContent.Instance.OK(data: 1);
                                }
                                else
                                {
                                    return content = WebResponseContent.Instance.OK(data: 3);
                                }
                            }
                            else
                            {
                                if (dt_StockInfo.StockStatus == (int)StockStatusEmun.组盘暂存)
                                {
                                    if (locationInfos.Count < 50)
                                    {
                                        return content = WebResponseContent.Instance.OK(data: 1);
                                    }
                                    else
                                    {
                                        return content = WebResponseContent.Instance.OK(data: 3);
                                    }
                                }
                                else
                                {
                                    return content = WebResponseContent.Instance.Error($"库存已有该条码，条码信息：{generate.PalletCode}");
                                }

                            }
                        }
                        else if (dt_Inbound.OrderType == (int)InventoryMaterialType.成品)
                        {
                            if (dt_StockInfo == null)
                            {
                                Dt_StockInfo dt_Stock = new()
                                {
                                    PalletCode = generate.PalletCode,
                                    IsFull = true,
                                    StockStatus = (int)StockStatusEmun.组盘暂存,
                                    Creater = "WMS",
                                    CreateDate = DateTime.Now,
                                    MaterialType = (int)InventoryMaterialType.成品,
                                    Materialweight = decimal.Parse(targetCodes[3]),
                                    Wlstatus = (int)InventoryMaterialStatus.待检,
                                };
                                _unitOfWorkManage.BeginTran();
                                _stockService.StockInfoService.Repository.AddData(dt_Stock);
                                Dt_StockInfo dt_StockInfo2 = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
                                Dt_StockInfoDetail dt_StockInfoDetail = new()
                                {
                                    StockId = dt_StockInfo2.Id,
                                    MaterielCode = dt_Inbound.OrderName,    //物料号
                                    MaterielName = dt_Inbound.UpperOrderNo,    //物料名称
                                    OrderNo = dt_Inbound.OrderNo,        //物料详情
                                    BatchNo = targetCodes[1].ToString(),         //物料批次
                                    BatchNoName = "",
                                    SerialNumber = targetCodes[2],    //包号
                                    StockQuantity = decimal.Parse(targetCodes[3]),    //重量
                                    OutboundQuantity = 1,    //序列号
                                    Status = (int)StockStatusEmun.组盘暂存,
                                    Creater = "WMS",
                                    CreateDate = DateTime.Now,
                                };
                                _stockService.StockInfoDetailService.AddData(dt_StockInfoDetail);
                                _unitOfWorkManage.CommitTran();
                                return content = WebResponseContent.Instance.OK(data: 1);
                            }
                            else
                            {
                                if (dt_StockInfo.StockStatus == (int)StockStatusEmun.组盘暂存)
                                {
                                    return content = WebResponseContent.Instance.OK(data: 1);
                                }
                                else
                                {
                                    return content = WebResponseContent.Instance.Error($"库存已有该条码，条码信息：{generate.PalletCode}");
                                }
                            }
                        }
                        else
                        {
                            return content = WebResponseContent.Instance.Error($"未找到条码解析，条码信息：{generate.PalletCode}");
                        }
                    }
                    else
                    {
                        return content = WebResponseContent.Instance.Error($"未找到入库单，条码信息：{generate.PalletCode}");
                    }
                    
                }
                else
                {
                    return content = WebResponseContent.Instance.Error($"解析的托盘条码长度不足4,条码信息：{generate.PalletCode}");
                }
            }
            catch (Exception ex)
            {
                return content=WebResponseContent.Instance.Error($"系统巷道入库接口解析错误：错误：{ex.Message}");
                throw;
            }
        }

        public WebResponseContent Queryinventory2(GenerateInv generate)
        {
            try
            {
                WebResponseContent content = new WebResponseContent();
                string result = generate.PalletCode.Substring(0, 2);
                if (result == "B-")
                {
                    Dt_StockInfo dt_StockInfo = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
                    if (dt_StockInfo == null)
                    {
                        Dt_StockInfo dt_Stock = new()
                        {
                            PalletCode = generate.PalletCode,
                            IsFull = true,
                            StockStatus = (int)StockStatusEmun.组盘暂存,
                            Creater = "WMS",
                            CreateDate = DateTime.Now,
                            MaterialType = (int)InventoryMaterialType.成品,
                            Materialweight = 0,
                        };
                        _unitOfWorkManage.BeginTran();
                        _stockService.StockInfoService.Repository.AddData(dt_Stock);

                        //string part2 = generate.PalletCode.Substring(2, 8);

                        //string part3 = generate.PalletCode.Split('#')[1];
                        Dt_StockInfo dt_StockInfo2 = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
                        Dt_StockInfoDetail dt_StockInfoDetail = new()
                        {
                            StockId = dt_StockInfo2.Id,
                            MaterielCode = dt_StockInfo2.PalletCode,    //物料编号
                            MaterielName = dt_StockInfo2.PalletCode,    //材质
                            OrderNo = dt_StockInfo2.PalletCode,        //单据（托盘条码）
                            BatchNo = dt_StockInfo2.PalletCode,         //批次号
                            SerialNumber = dt_StockInfo2.PalletCode,    //序列号
                            StockQuantity = 1,    //序列号
                            OutboundQuantity = 1,    //序列号
                            Status = (int)StockStatusEmun.组盘暂存,
                            Creater = "WMS",
                            CreateDate = DateTime.Now,
                        };
                        _stockService.StockInfoDetailService.AddData(dt_StockInfoDetail);

                        _unitOfWorkManage.CommitTran();
                        return content = WebResponseContent.Instance.OK(data: 1);
                    }
                    else
                    {
                        if(dt_StockInfo.StockStatus== (int)StockStatusEmun.组盘暂存)
                        {
                            return content = WebResponseContent.Instance.OK(data:1);
                        }
                        else
                        {
                            return content = WebResponseContent.Instance.Error($"库存已有该条码，条码信息：{generate.PalletCode}");
                        }
                    }
                }
                else
                {
                    Dt_InboundOrder dt_Inbound = _inboundService.InbounOrderService.Repository.QueryFirst(x => x.UpperOrderNo == result);
                    Dt_StockInfo dt_StockInfo = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
                    List<Dt_LocationInfo> locationinfoData = _basicService.LocationInfoService.Repository.QueryData(x => x.RoadwayNo == "2" && x.LocationStatus == LocationStatusEnum.Free.ObjToInt()
                            && x.LocationType == (int)LocationTypeEnum.MaterialsCube);
                    if (dt_Inbound != null)
                    {
                        if (dt_StockInfo == null)
                        {
                            Dt_StockInfo dt_Stock = new()
                            {
                                PalletCode = generate.PalletCode,
                                IsFull = true,
                                StockStatus = (int)StockStatusEmun.组盘暂存,
                                Creater = "WMS",
                                CreateDate = DateTime.Now,
                                MaterialType = (int)InventoryMaterialType.原材料,
                                Materialweight = 0,
                            };
                            _unitOfWorkManage.BeginTran();
                            _stockService.StockInfoService.Repository.AddData(dt_Stock);

                            string part2 = generate.PalletCode.Substring(2, 8);

                            string part3 = generate.PalletCode.Split('#')[1];
                            Dt_StockInfo dt_StockInfo2 = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
                            Dt_StockInfoDetail dt_StockInfoDetail = new()
                            {
                                StockId = dt_StockInfo2.Id,
                                MaterielCode = result,    //物料编号
                                MaterielName = dt_Inbound.OrderNo,    //材质
                                OrderNo = generate.PalletCode,        //单据（托盘条码）
                                BatchNo = part2,         //批次号
                                SerialNumber = part3,    //序列号
                                StockQuantity = 1,    //序列号
                                OutboundQuantity = 1,    //序列号
                                Status = (int)StockStatusEmun.组盘暂存,
                                Creater = "WMS",
                                CreateDate = DateTime.Now,
                            };
                            _stockService.StockInfoDetailService.AddData(dt_StockInfoDetail);

                            _unitOfWorkManage.CommitTran();

                            
                            if (locationinfoData.Count > 40)
                            {
                                return content = WebResponseContent.Instance.OK(data: 3);
                            }
                            else
                            {
                                return content = WebResponseContent.Instance.OK(data: 1);
                            }
                            
                        }
                        else
                        {
                            if (dt_StockInfo.StockStatus == (int)StockStatusEmun.组盘暂存)
                            {
                                if (locationinfoData.Count > 40)
                                {
                                    return content = WebResponseContent.Instance.OK(data: 3);
                                }
                                else
                                {
                                    return content = WebResponseContent.Instance.OK(data: 1);
                                }
                            }
                            else
                            {
                                return content = WebResponseContent.Instance.Error($"库存已有该条码，条码信息：{generate.PalletCode}");
                            }
                        }

                    }
                    else
                    {
                        return content = WebResponseContent.Instance.Error("未找到该类型的解析");
                    }

                }
            }
            catch (Exception ex)
            {

                throw;
            }
        }
    
        public WebResponseContent PalletQueryinventory()
        {
            WebResponseContent content = new WebResponseContent();
            List<Dt_LocationInfo> locationinfoData = _basicService.LocationInfoService.Repository.QueryData(x => x.RoadwayNo=="2" && x.LocationStatus == LocationStatusEnum.Free.ObjToInt() 
            && x.LocationType == (int)LocationTypeEnum.MaterialsCube && x.EnableStatus == (int)EnableStatusEnum.Normal);
            if (locationinfoData.Count < 20)
            {
                return content = WebResponseContent.Instance.OK(data: 1);
            }
            else
            {
                return content = WebResponseContent.Instance.OK();
                return content = WebResponseContent.Instance.OK(data: 3);
            }
            
            
        }
    }
}