1

huanghongfeng

2024-12-03 1c696f3e12ddcb136e772f9d83eb906760766b96

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

@@ -17,6 +17,7 @@
using static WIDESEA_ITaskInfoService.ITaskService;
using MailKit.Search;
using WIDESEA_Common.Log;
using OfficeOpenXml.FormulaParsing.Excel.Functions.DateTime;

namespace WIDESEA_TaskInfoService
{
@@ -451,6 +452,7 @@
                                        Creater = "WMS",
                                        CreateDate = DateTime.Now,
                                        TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum)),
                                        MaterialType = dt_StockInfo.MaterialType
                                    };
                                    _unitOfWorkManage.BeginTran();
                                    if (locationInfos.LocationStatus == LocationStatusEnum.InStock.ObjToInt())
@@ -509,7 +511,12 @@
                    {
                        RoadwayNo = "2";
                    }
                    Dt_LocationInfo locationInfos = _basicService.LocationInfoService.Repository.QueryFirst(x => x.RoadwayNo == RoadwayNo && x.LocationStatus == LocationStatusEnum.Pallet.ObjToInt());
                    Dt_LocationInfo locationInfos = _basicService.LocationInfoService.Repository.QueryFirst(x => x.RoadwayNo == RoadwayNo && x.EnableStatus != (int)EnableStatusEnum.Disable && x.Depth==1 && x.LocationStatus == LocationStatusEnum.Pallet.ObjToInt());
                    if(locationInfos == null)
                    {
                        locationInfos = _basicService.LocationInfoService.Repository.QueryFirst(x => x.RoadwayNo == RoadwayNo && x.Depth == 2 && x.EnableStatus != (int)EnableStatusEnum.Disable && x.LocationStatus == LocationStatusEnum.Pallet.ObjToInt());
                    }

                    if (locationInfos != null)
                    {
                        Dt_StockInfo dt_StockInfo = _stockService.StockInfoService.Repository.QueryFirst(x => x.LocationCode == locationInfos.LocationCode);
@@ -537,6 +544,7 @@
                                    Depth = locationInfos.Depth,
                                    CreateDate = DateTime.Now,
                                    PalletCodequantity = (int)dt_StockInfo.Materialweight,
                                    MaterialType = dt_StockInfo.MaterialType
                                };

                                _unitOfWorkManage.BeginTran();
@@ -617,6 +625,7 @@
                            CreateDate = DateTime.Now,
                            PalletCodequantity = (int)dt_StockInfo[i].Materialweight,
                            PLCTo = generate.TargetAddress == "R01-002-041-011-01" ? 1 : 2,
                            MaterialType = dt_StockInfo[i].MaterialType
                        };

                        _unitOfWorkManage.BeginTran();
@@ -654,7 +663,6 @@
        public WebResponseContent ManualOutbound(SaveModel saveModel)
        {
            WebResponseContent content = new WebResponseContent();

            try
            {
                List<Dt_StockInfo> dtstockt = new List<Dt_StockInfo>();
@@ -664,74 +672,84 @@
                for (int i = 0; i < saveModel.DelKeys.Count; i++)
                {
                    Dt_StockInfo stockt = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == saveModel.DelKeys[i].ToString());
                    if (stockt.StockStatus == (int)StockStatusEmun.已入库)
                    if (stockt.StockStatus == (int)StockStatusEmun.已入库 && (stockt.Wlstatus == (int)InventoryMaterialStatus.合格 || stockt.Wlstatus == (int)InventoryMaterialStatus.返工))
                    {
                        Dt_StockInfoDetail stocktdetail = _stockService.StockInfoDetailService.Repository.QueryFirst(x => x.StockId == stockt.Id);
                        stockt.StockStatus = (int)StockStatusEmun.出库锁定;
                        if (stockt.MaterialType != (int)InventoryMaterialType.空托)
                        if(stockt.MaterialType != (int)InventoryMaterialType.原材料)
                        {
                            stocktdetail.Status = (int)StockStatusEmun.出库锁定;
                        }
                        Dt_LocationInfo locationinfo = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == stockt.LocationCode);
                        if (locationinfo.LocationStatus == LocationStatusEnum.InStock.ObjToInt())
                        {
                            locationinfo.LocationStatus = LocationStatusEnum.Lock.ObjToInt();
                        }
                        else if (locationinfo.LocationStatus == LocationStatusEnum.Pallet.ObjToInt())
                        {
                            locationinfo.LocationStatus = LocationStatusEnum.PalletLock.ObjToInt();
                        }
                        string LocationName = "R01-002-044-001-01";
                        if (stockt.MaterialType == (int)InventoryMaterialType.原材料)
                        {
                            Dt_StockInfoDetail stocktdetail = _stockService.StockInfoDetailService.Repository.QueryFirst(x => x.StockId == stockt.Id);
                            stockt.StockStatus = (int)StockStatusEmun.出库锁定;
                            if (stockt.MaterialType != (int)InventoryMaterialType.空托)
                            {
                                stocktdetail.Status = (int)StockStatusEmun.出库锁定;
                            }
                            Dt_LocationInfo locationinfo = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == stockt.LocationCode);
                            if (locationinfo.RoadwayNo == "1")
                            {
                                LocationName = "R01-002-041-011-01";
                                if (locationinfo.LocationStatus == LocationStatusEnum.InStock.ObjToInt())
                                {
                                    locationinfo.LocationStatus = LocationStatusEnum.Lock.ObjToInt();
                                }
                                else if (locationinfo.LocationStatus == LocationStatusEnum.Pallet.ObjToInt())
                                {
                                    locationinfo.LocationStatus = LocationStatusEnum.PalletLock.ObjToInt();
                                }
                                string LocationName = "R01-002-044-001-01";
                                if (stockt.MaterialType == (int)InventoryMaterialType.空托)
                                {
                                    LocationName = "R01-002-043-001-01";
                                }
                                Dt_LocationInfo newTargetAddress;
                                newTargetAddress = _basicService.LocationInfoService.GetLocationplatform(LocationName);
                                Dt_Task dt_Task = new()
                                {
                                    PalletCode = stockt.PalletCode,
                                    TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum)),
                                    Roadway = newTargetAddress.RoadwayNo,
                                    TaskType = TaskTypeEnum.Outbound.ObjToInt(),
                                    TaskStatus = InTaskStatusEnum.InNew.ObjToInt(),
                                    SourceAddress = locationinfo.LocationCode,
                                    TargetAddress = newTargetAddress.LocationCode,
                                    CurrentAddress = locationinfo.LocationCode,
                                    NextAddress = newTargetAddress.LocationCode,
                                    Grade = 1,
                                    Creater = "WMS",
                                    Depth = locationinfo.Depth,
                                    CreateDate = DateTime.Now,
                                    MaterialType= stockt.MaterialType
                                };
                                dtstockt.Add(stockt);
                                locations.Add(locationinfo);
                                taskdt.Add(dt_Task);
                                if (stockt.MaterialType != (int)InventoryMaterialType.空托)
                                {
                                    dtstocktdetail.Add(stocktdetail);
                                }
                            }
                            else
                            {
                                LocationName = "R02-002-027-011-01";
                                return content = WebResponseContent.Instance.Error($"出库失败，只可出库1巷道的托盘和成品，出库条码：{saveModel.DelKeys[i].ToString()}");
                            }
                        }
                        Dt_LocationInfo newTargetAddress;
                        newTargetAddress = _basicService.LocationInfoService.GetLocationplatform(LocationName);
                        Dt_Task dt_Task = new()
                        else
                        {
                            PalletCode = stockt.PalletCode,
                            TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum)),
                            Roadway = newTargetAddress.RoadwayNo,
                            TaskType = TaskTypeEnum.Outbound.ObjToInt(),
                            TaskStatus = InTaskStatusEnum.InNew.ObjToInt(),
                            SourceAddress = locationinfo.LocationCode,
                            TargetAddress = newTargetAddress.LocationCode,
                            CurrentAddress = locationinfo.LocationCode,
                            NextAddress = newTargetAddress.LocationCode,
                            Grade = 1,
                            Creater = "WMS",
                            Depth = locationinfo.Depth,
                            CreateDate = DateTime.Now,
                        };
                        dtstockt.Add(stockt);
                        locations.Add(locationinfo);
                        taskdt.Add(dt_Task);
                        if (stockt.MaterialType != (int)InventoryMaterialType.空托)
                        {
                            dtstocktdetail.Add(stocktdetail);
                            return content = WebResponseContent.Instance.Error($"出库失败，请不要选择原材料出库，出库条码：{saveModel.DelKeys[i].ToString()}");
                        }
                    }
                    else
                    {
                        return content = WebResponseContent.Instance.Error($"出库失败，该库存信息不可进行出库");
                        return content = WebResponseContent.Instance.Error($"出库失败，请选择已入库且合格的物料出库！！！，出库条码：{saveModel.DelKeys[i].ToString()}");
                    }

                }
                var responses = HttpHelper.Post<WebResponseContent>(ReceiveWMSTask, taskdt, "下发任务入库");
                _unitOfWorkManage.BeginTran();
                _stockService.StockInfoService.Repository.UpdateData(dtstockt);
                _stockService.StockInfoDetailService.Repository.UpdateData(dtstocktdetail);
                _basicService.LocationInfoService.Repository.UpdateData(locations);
                BaseDal.AddData(taskdt);

                if (dtstockt.Count > 0)
                {
                    _stockService.StockInfoService.Repository.UpdateData(dtstockt);
                    _stockService.StockInfoDetailService.Repository.UpdateData(dtstocktdetail);
                    _basicService.LocationInfoService.Repository.UpdateData(locations);
                    BaseDal.AddData(taskdt);
                }
                _unitOfWorkManage.CommitTran();
                content = WebResponseContent.Instance.OK();
                return content;
@@ -743,6 +761,174 @@
                throw;
            }
        }


        public WebResponseContent ManualOutbound2(SaveModel saveModel)
        {
            WebResponseContent content = new WebResponseContent();
            try
            {
                List<Dt_StockInfo> dtstockt = new List<Dt_StockInfo>();
                List<Dt_LocationInfo> locations = new List<Dt_LocationInfo>();
                List<Dt_Task> taskdt = new List<Dt_Task>();
                List<Dt_StockInfoDetail> dtstocktdetail = new List<Dt_StockInfoDetail>();


                List<Dt_StockInfo> stocktData= _stockService.StockInfoService.Repository.QueryData(x=>x.StockStatus== (int)StockStatusEmun.已入库 && x.MaterialType == (int)InventoryMaterialType.原材料);
                List<Dt_LocationInfo> locationinfoData = _basicService.LocationInfoService.Repository.QueryData(x =>x.LocationStatus == LocationStatusEnum.InStock.ObjToInt());
                List<Dt_StockInfoDetail> StockInfoDetailData = _stockService.StockInfoDetailService.Repository.QueryData(x => x.Status == (int)StockStatusEmun.已入库);

                
                string json = saveModel.DelKeys[0].ToString();
                List<string> palletCodes = JsonConvert.DeserializeObject<List<string>>(json);

                foreach (var palletCode in palletCodes)
                {
                    Dt_StockInfo stockt = stocktData.FirstOrDefault(x => x.PalletCode == palletCode);
                    if (stockt !=null)
                    {
                        if (stockt.StockStatus == (int)StockStatusEmun.已入库 && (stockt.Wlstatus == (int)InventoryMaterialStatus.合格 || stockt.Wlstatus == (int)InventoryMaterialStatus.退货 || stockt.Wlstatus == (int)InventoryMaterialStatus.特采))
                        {
                            Dt_StockInfoDetail stocktdetail = StockInfoDetailData.FirstOrDefault(x => x.StockId == stockt.Id);
                            if(stocktdetail != null)
                            {
                                Dt_LocationInfo locationinfo = locationinfoData.FirstOrDefault(x => x.LocationCode == stockt.LocationCode);
                                if(locationinfo != null)
                                {
                                    stockt.StockStatus = (int)StockStatusEmun.出库锁定;
                                    if (locationinfo.LocationStatus == LocationStatusEnum.InStock.ObjToInt())
                                    {
                                        locationinfo.LocationStatus = LocationStatusEnum.Lock.ObjToInt();
                                    }

                                    string TargetAdd = "";
                                    if (saveModel.DelKeys[1].ToString()=="20")
                                    {
                                        TargetAdd = "R02-001-010-001-02";
                                    }else if(saveModel.DelKeys[1].ToString() == "30")
                                    {
                                        TargetAdd = "R02-001-011-001-02";
                                    }
                                    else
                                    {
                                        TargetAdd = locationinfo.RoadwayNo == "2" ? "R02-002-027-011-01" : "R01-002-041-011-01";
                                    }


                                    Dt_Task dt_Task = new()
                                    {
                                        PalletCode = stockt.PalletCode,
                                        TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum)),
                                        Roadway = locationinfo.RoadwayNo,
                                        TaskType = TaskTypeEnum.Outbound.ObjToInt(),
                                        TaskStatus = InTaskStatusEnum.InNew.ObjToInt(),
                                        SourceAddress = locationinfo.LocationCode,
                                        TargetAddress = TargetAdd,
                                        CurrentAddress = locationinfo.LocationCode,
                                        NextAddress = TargetAdd,
                                        Grade = 1,
                                        Creater = "WMS",
                                        Depth = locationinfo.Depth,
                                        CreateDate = DateTime.Now,
                                        PLCTo = int.Parse(saveModel.DelKeys[1].ToString()),
                                        MaterialType=stockt.MaterialType
                                    };
                                    dtstockt.Add(stockt);
                                    locations.Add(locationinfo);
                                    taskdt.Add(dt_Task);
                                    dtstocktdetail.Add(stocktdetail);
                                }
                                else
                                {
                                    return content = WebResponseContent.Instance.Error($"出库失败，未找到对应的库位信息，请核对！！！，出库条码：{palletCode}");
                                }
                            }
                            else
                            {
                                return content = WebResponseContent.Instance.Error($"出库失败，未找到对应的库存详情信息，请核对！！！，出库条码：{palletCode}");
                            }
                        }
                        else
                        {
                            return content = WebResponseContent.Instance.Error($"出库失败，请选择已入库且（合格，特采，退货）的物料出库！！！，出库条码：{palletCode}");
                        }
                    }
                    else
                    {
                        return content = WebResponseContent.Instance.Error($"出库失败，未找到对应条码的库存信息，出库条码：{palletCode}");

                    }
                }
                //var responses = HttpHelper.Post<WebResponseContent>(ReceiveWMSTask, taskdt, "下发任务入库");
                _unitOfWorkManage.BeginTran();
                if(dtstockt.Count > 0)
                {
                    _stockService.StockInfoService.Repository.UpdateData(dtstockt);
                    _stockService.StockInfoDetailService.Repository.UpdateData(dtstocktdetail);
                    _basicService.LocationInfoService.Repository.UpdateData(locations);
                    BaseDal.AddData(taskdt);
                }
                _unitOfWorkManage.CommitTran();
                content = WebResponseContent.Instance.OK($"出库成功，出库总数：{palletCodes.Count}，成功数量：{dtstockt.Count}");
                return content;
            }
            catch (Exception ex)
            {
                _unitOfWorkManage.RollbackTran();
                return content = WebResponseContent.Instance.Error($"出库失败，报错信息：{ex.Message}");
                throw;
            }
        }

        public WebResponseContent ManualOutbound3(SaveModel saveModel)
        {
            WebResponseContent content = new WebResponseContent();
            try
            {
                List<Dt_StockInfo> dtstockt = new List<Dt_StockInfo>();


                List<Dt_StockInfo> stocktData = _stockService.StockInfoService.Repository.QueryData(x => x.StockStatus == (int)StockStatusEmun.已入库);
                string json = saveModel.DelKeys[0].ToString();
                List<int> palletCodes = JsonConvert.DeserializeObject<List<int>>(json);

                foreach (int pallid in palletCodes)
                {
                    Dt_StockInfo stockt = stocktData.FirstOrDefault(x => x.Id == pallid);
                    if (stockt != null)
                    {

                        stockt.Wlstatus = int.Parse(saveModel.DelKeys[1].ToString());
                        dtstockt.Add(stockt);
                    }
                    else
                    {
                        return content = WebResponseContent.Instance.Error($"出库失败，未找到对应的库存信息，库存编号：{pallid}");

                    }
                }
                _unitOfWorkManage.BeginTran();
                if (dtstockt.Count > 0)
                {
                    _stockService.StockInfoService.Repository.UpdateData(dtstockt);
                }
                _unitOfWorkManage.CommitTran();
                content = WebResponseContent.Instance.OK($"修改成功");
                return content;
            }
            catch (Exception ex)
            {
                _unitOfWorkManage.RollbackTran();
                return content = WebResponseContent.Instance.Error($"出库失败，报错信息：{ex.Message}");
                throw;
            }
        }

        public class PalletCodeList
        {
            public string PalletCode { get; set; }
        }


        public (Dt_Task?, Dt_LocationInfo?) AddRelocationTask(Dt_LocationInfo location, Dt_StockInfo stockInfo, Dt_Task task)
        {
@@ -1037,7 +1223,7 @@
                else if(task.TaskType == (int)TaskTypeEnum.Inbound || task.TaskType == (int)TaskTypeEnum.PalletInbound)
                {
                    //处理出库的逻辑
                    Dt_LocationInfo locationinfo = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == task.SourceAddress);
                    Dt_LocationInfo locationinfo = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == task.TargetAddress);
                    if (locationinfo.LocationStatus == LocationStatusEnum.Lock.ObjToInt() || locationinfo.LocationStatus == LocationStatusEnum.PalletLock.ObjToInt())
                    {
                        locationinfo.LocationStatus = LocationStatusEnum.Free.ObjToInt();