方舱智能密集库
blame | 历史 | 补丁 | 提交 | 提交对比 | 忽略空白
11
yanjinhui
3 天以前 517afb9079abcdecf99ec3ed4d71f90a4d479e7e 
 н¨Îļþ¼Ð/WIDESEA_WMSServer/WIDESEA_SquareCabinServices/DeliveryOrderServices.cs


@@ -21,6 +21,7 @@


using WIDESEA_Core.BaseServices;


using WIDESEA_Core.Enums;


using WIDESEA_Core.Helper;


using WIDESEA_DTO.Outbound;


using WIDESEA_DTO.SquareCabin;


using WIDESEA_IBasicService;


using WIDESEA_ISquareCabinServices;


@@ -62,7 +63,138 @@


        }


        public override WebResponseContent UpdateData(SaveModel saveModel)


        {


            return base.UpdateData(saveModel);


            try


            {


                int id = saveModel.MainData["id"].ObjToInt();


                var warehouse_no = saveModel.MainData["warehouse_no"].ToString();


                var out_no = saveModel.MainData["out_no"].ToString();


                //OutboundOrderAddDTO outboundOrder = saveModel.MainData.DicToModel<OutboundOrderAddDTO>();


                //Dt_DeliveryOrder deliveryOrder = BaseDal.QueryFirst(x => x.Id == id);


                List<DeliveryOrderDetailAddDTO> orderDetailAddDTOs = saveModel.DetailData.DicToIEnumerable<DeliveryOrderDetailAddDTO>();


                orderDetailAddDTOs = orderDetailAddDTOs.Where(x => x.id == 0).ToList();


                if (orderDetailAddDTOs.Count < 1) return WebResponseContent.Instance.OK();


                if (orderDetailAddDTOs.Where(x => string.IsNullOrEmpty(x.locationCode)).Any()) return WebResponseContent.Instance.Error("货位号为必填字段!");


                if (orderDetailAddDTOs.Where(x => string.IsNullOrEmpty(x.exp_date)).Any()) return WebResponseContent.Instance.Error("效期为必填字段!");


                var LocationCodes = orderDetailAddDTOs.Select(x => x.locationCode);


                List<Dt_LocationInfo> locationInfos = _locationInfoService.Repository.QueryData(x => x.WarehouseCode == warehouse_no && LocationCodes.Contains(x.LocationCode));


                var diff = LocationCodes.Except(locationInfos.Select(x => x.LocationCode)).ToArray();


                if (diff.Length > 0) return WebResponseContent.Instance.Error($"货位编号【{string.Join(", ", diff)}】不属于当前库房");


                var array1 = orderDetailAddDTOs.Select(x => x.goods_no);


                var MaterielInfos = _materielInfoService.Repository.QueryData(x => array1.Contains(x.MaterielCode));


                var array2 = MaterielInfos.Select(x => x.MaterielCode);


                diff = array1.Except(array2).ToArray();


                if (diff.Length > 0) return WebResponseContent.Instance.Error($"请维护物料编号【{string.Join(", ", diff)}】的物料信息");


                if (warehouse_no == WarehouseEnum.立库.ObjToInt().ToString("000"))


                {


                    var MaterielInfos1 = MaterielInfos.Where(x => x.MaterielSourceType == MaterielSourceTypeEnum.PurchasePart).ToList();


                    if (MaterielInfos1.Count > 0)


                    {


                        return WebResponseContent.Instance.Error($"物料编号【{string.Join(", ", MaterielInfos1.Select(x => x.MaterielCode))}】的物料属性分类为大件，不可入立库");


                    }


                }


                var InventoryInfos = _inventoryInfoService.Repository.QueryData(x => x.WarehouseCode == warehouse_no && array2.ToList().Contains(x.MaterielCode));


                var Batchs = _inventory_BatchServices.Repository.QueryData(x => array2.Contains(x.MaterielCode));


                List<Dt_DeliveryOrderDetail> deliveryOrderDetails = new List<Dt_DeliveryOrderDetail>();


                List<Dt_SupplyTask> supplyTasks = new List<Dt_SupplyTask>();


                List<Dt_InventoryInfo> inventoryInfos = new List<Dt_InventoryInfo>();


                List<Dt_Inventory_Batch> inventory_Batches = new List<Dt_Inventory_Batch>();


                foreach (var item in orderDetailAddDTOs)


                {


                    if (InventoryInfos.Where(x => x.MaterielCode == item.goods_no && x.BatchNo == item.batch_num).Any())


                        return WebResponseContent.Instance.Error($"物料编号【{item.goods_no}】物料批次【{item.batch_num}】已存在库存");


                    #region æ·»åŠ ç›˜ç‚¹å•è¯¦æƒ…


                    Dt_DeliveryOrderDetail dt_DeliveryOrde = new Dt_DeliveryOrderDetail()


                    {


                        DeliveryOrderId = id,


                        Reservoirarea = warehouse_no,


                        Status = 2,


                        Order_qty = 0,


                        Order_Outqty = item.order_Outqty,


                        Goods_no = item.goods_no,


                        OotDetailStatus = "新建",


                        Batch_num = item.batch_num,


                        Creater = App.User.UserName,


                        CreateDate = DateTime.Now,


                    };


                    deliveryOrderDetails.Add(dt_DeliveryOrde);


                    #endregion




                    #region æ·»åŠ åº“存、批次信息、盘点任务


                    var MaterielInfo = MaterielInfos.First(x => x.MaterielCode == item.goods_no);


                    Dt_InventoryInfo inventoryInfo = new Dt_InventoryInfo()


                    {


                        BatchNo = item.batch_num,


                        MaterielCode = MaterielInfo.MaterielCode,


                        AvailableQuantity = 0,


                        CreateDate = DateTime.Now,


                        Creater = App.User.UserName,


                        InDate = DateTime.Now,


                        LocationCode = item.locationCode,


                        MaterielName = MaterielInfo.MaterielName,


                        MaterielSpec = MaterielInfo.MaterielSpec,


                        OutboundQuantity = 0,


                        StockQuantity = 0,


                        StockStatus = StockStatusEmun.盘点锁定.ObjToInt(),


                        SupplyQuantity = 0,


                        WarehouseCode = warehouse_no,


                        ValidityPeriod = item.exp_date


                    };


                    inventoryInfos.Add(inventoryInfo);


                    Dt_Inventory_Batch? inventory_Batch = Batchs.FirstOrDefault(x => x.BatchNo == item.batch_num && x.MaterielCode == item.goods_no);


                    if (inventory_Batch == null)


                    {


                        inventory_Batch = new Dt_Inventory_Batch()


                        {


                            BatchNo = inventoryInfo.BatchNo,


                            CreateDate = inventoryInfo.CreateDate,


                            Creater = inventoryInfo.Creater,


                            MaterielCode = inventoryInfo.MaterielCode,


                            ERPStockQuantity = 0,


                            MaterielName = inventoryInfo.MaterielName,


                            MaterielSpec = inventoryInfo.MaterielSpec,


                            OutboundQuantity = inventoryInfo.OutboundQuantity,


                            ProductionDate = inventoryInfo.ProductionDate,


                            Status = false,


                            StockQuantity = inventoryInfo.StockQuantity,


                            AvailableQuantity = inventoryInfo.AvailableQuantity,


                            ValidityPeriod = inventoryInfo.ValidityPeriod.ObjToDate(),


                            SupplyQuantity = inventoryInfo.SupplyQuantity,


                        };


                        inventory_Batches.Add(inventory_Batch);


                    }


                    Dt_SupplyTask supplyTask = new Dt_SupplyTask()


                    {


                        WarehouseCode = warehouse_no,


                        TaskStatus = SupplyStatusEnum.NewCheck.ObjToInt(),


                        BatchNo = inventoryInfo.BatchNo,


                        MaterielName = inventoryInfo.MaterielName,


                        MaterielCode = inventoryInfo.MaterielCode,


                        MaterielSpec = inventoryInfo.MaterielSpec,


                        TaskType = TaskTypeEnum.OutInventory.ObjToInt(),


                        CreateDate = DateTime.Now,


                        Creater = App.User.UserName,


                        LocationCode = inventoryInfo.LocationCode,


                        OrderNo = out_no,


                        StockQuantity = inventoryInfo.StockQuantity,


                        SupplyQuantity = 0,


                        Remark = "盘点"


                    };


                    supplyTasks.Add(supplyTask);


                    #endregion


                }


                _unitOfWorkManage.BeginTran();


                _deliveryOrderDetailServices.AddData(deliveryOrderDetails);


                _inventoryInfoService.AddData(inventoryInfos);


                if (inventory_Batches.Count > 0) _inventory_BatchServices.AddData(inventory_Batches);


                _supplyTaskService.AddData(supplyTasks);


                _unitOfWorkManage.CommitTran();


                return WebResponseContent.Instance.OK("盘点详情添加成功,请通过ERP平账！");


            }


            catch (Exception ex)


            {


                _unitOfWorkManage.RollbackTran();


                return WebResponseContent.Instance.Error(ex.Message);


            }


        }




        #region åˆ›å»ºå‡ºåº“单


@@ -438,7 +570,7 @@


                                #region æ·»åŠ å‡ºåº“任务、修改库存信息


                                Dt_InventoryInfo? inventoryInfo = dt_InventoryInfos.FirstOrDefault(x => x.WarehouseCode == WareCodeLK);


                                if (inventoryInfo == null)


                                    throw new Exception($"未找到物料编号【{detail.goods_no}】物料批次【{detail.batch_num}】在立库中的库存信息；所需数量【{orderDetailLK.Order_qty}】请补货");


                                    throw new Exception($"出库单【{outorder.order_no}】详情存在散件,物料编号【{detail.goods_no}】物料批次【{detail.batch_num}】所需数量【{Convert.ToInt32(orderDetailLK.Order_qty)}】请人工调拨补货入立库");


                                inventoryInfo.AvailableQuantity -= orderDetailLK.Order_qty;


                                inventoryInfo.OutboundQuantity += orderDetailLK.Order_qty;


                                Dt_SupplyTask supplyTask = new Dt_SupplyTask()


@@ -617,11 +749,14 @@


                        List<Dt_InventoryInfo> inventoryInfos = _InventoryInfos.Where(x => x.MaterielCode == inventory_Batch.MaterielCode && x.BatchNo == inventory_Batch.BatchNo).ToList();


                        //获取立库盘点差异数.。。。。。。。。。。。。


                        var inventoryLK = inventoryInfos.Where(x => x.WarehouseCode == WareCodeLK).First();


                        var LkQty = Math.Abs(inventoryLK.SupplyQuantity);


                        //var LkQty = Math.Abs(inventoryLK.SupplyQuantity);


                        var LkQty = inventoryLK.SupplyQuantity;


                        //获取大件库盘点差异数


                        var inventoryDJ = inventoryInfos.Where(x => x.WarehouseCode == WareCodeDJ).ToList();


                        var DJQty = Math.Abs(inventoryDJ.Sum(x => x.SupplyQuantity));


                        if (LkQty + DJQty != Qty) throw new Exception($"【{order.order_no}】物料编号【{item.goods_no}】物料批次【{item.batch_num}】的物料信息与物料批次信息盘盈数量不符");


                        //var DJQty = Math.Abs(inventoryDJ.Sum(x => x.SupplyQuantity));


                        var DJQty = inventoryDJ.Sum(x => x.SupplyQuantity);


                        var count = Math.Abs(LkQty + DJQty);


                        if (count != Qty) throw new Exception($"【{order.order_no}】物料编号【{item.goods_no}】物料批次【{item.batch_num}】的物料信息与物料批次信息盘亏数量不符");


                        if (LkQty == 0)//立库无差异


                        {


                            #region åº“存、库存批次平账


@@ -764,7 +899,7 @@


                                deliveryOrdersAdd.Add(cabinOrder);


                            }


                            #endregion




                            //这里


                            #region åˆ›å»ºç«‹åº“盘点单


                            var entityOrder = new Dt_DeliveryOrder


                            {


@@ -778,7 +913,7 @@


                                Details = order.details.Select(d => new Dt_DeliveryOrderDetail


                                {


                                    Goods_no = d.goods_no,


                                    Order_qty = LkQty,


                                    Order_qty = Math.Abs(LkQty), //给下游WCS的是要整数


                                    Batch_num = d.batch_num,


                                    Exp_date = d.exp_date,


                                    Reservoirarea = WareCodeLK,


@@ -957,6 +1092,7 @@


            }


            return content;


        }




        public WebResponseContent OutTaskFinish(Dt_SupplyTask supplyTask, Dt_DeliveryOrder deliveryOrder)


        {


            WebResponseContent content = new WebResponseContent();


@@ -1036,6 +1172,7 @@


            }


            return content;


        }




        public WebResponseContent OutTaskFinish(Dt_SupplyTask supplyTask)


        {


            WebResponseContent content = new WebResponseContent();