11

647556386

2025-12-19 76e9a55e9efc66e7ce74378144c3dd6dc334465b

11

 ÏîÄ¿´úÂë/WIDESEA_WMSClient/src/extension/outbound/extend/outOrderDetail.vue

@@ -346,13 +346,11 @@
      if (this.selection.length === 0) {
        return this.$message.error("请选择单据明细");
      }
      if (this.selection.length > 1) {
        return this.$message.error("只能选择一条单据明细进行分批出库");
      }
      
      const keys = this.selection.map((item) => item.id);
      const requestParams = {
        detailIds: keys,
        outboundQuantity: this.selection[0].orderQuantity,
        outboundQuantity: this.selection.length>1?1: this.selection[0].orderQuantity,
        operator: "",
        orderNo: this.row.orderNo,
        isBatch: this.isBatch

 ÏîÄ¿´úÂë/WMSÎÞ²Ö´¢°æ/WIDESEA_WMSServer/WIDESEA_OutboundService/OutboundOrderDetailService.cs

@@ -577,73 +577,73 @@

        public override PageGridData<Dt_OutboundOrderDetail> GetPageData(PageDataOptions options)
        {
            //var  pageGridData = base.GetPageData(options);
            return base.GetPageData(options);

            ISugarQueryable<Dt_OutboundOrderDetail> sugarQueryable1 = BaseDal.Db.Queryable<Dt_OutboundOrderDetail>();
            if (!string.IsNullOrEmpty(options.Wheres))
            {
            //ISugarQueryable<Dt_OutboundOrderDetail> sugarQueryable1 = BaseDal.Db.Queryable<Dt_OutboundOrderDetail>();
            //if (!string.IsNullOrEmpty(options.Wheres))
            //{

                List<SearchParameters> searchParametersList = options.Wheres.DeserializeObject<List<SearchParameters>>();
                int totalCount = 0;
                if (searchParametersList.Count > 0)
                {
                    {
                        SearchParameters? searchParameters = searchParametersList.FirstOrDefault(x => x.Name == nameof(Dt_InboundOrderDetail.OrderId).FirstLetterToLower());
                        if (searchParameters != null)
                        {
                            Dt_OutboundOrder outboundOrder = _outboundOrderService.Repository.QueryFirst(x => x.Id == searchParameters.Value.ObjToInt());
                            if (outboundOrder != null)
                            {
                                if (outboundOrder.IsBatch == 0)
                                {
                                    sugarQueryable1 = sugarQueryable1.Where(x => x.OrderId == searchParameters.Value.ObjToInt());
                                    var dataList = sugarQueryable1.ToPageList(options.Page, options.Rows, ref totalCount);
                                    return new PageGridData<Dt_OutboundOrderDetail>(totalCount, dataList);
                                }
                                else
                                {
                                    sugarQueryable1 = sugarQueryable1.Where(x => x.OrderId == searchParameters.Value.ObjToInt());
                                    sugarQueryable1.GroupBy(x => new { x.MaterielCode, x.MaterielName, x.BatchNo, x.SupplyCode, x.WarehouseCode }).Select(s => new Dt_OutboundOrderDetail
                                    {
                                        WarehouseCode = s.WarehouseCode,
                                        SupplyCode = s.SupplyCode,
                                        BatchNo = s.BatchNo,
                                        MaterielName = s.MaterielName,
                                        MaterielCode = s.MaterielCode,
                                        AllocatedQuantity = SqlFunc.AggregateSum(s.AllocatedQuantity),
                                        OrderQuantity = SqlFunc.AggregateSum(s.OrderQuantity),
                                        PickedQty = SqlFunc.AggregateSum(s.PickedQty),
                                        OverOutQuantity = SqlFunc.AggregateSum(s.OverOutQuantity),
                                        MoveQty = SqlFunc.AggregateSum(s.MoveQty),
                                        NoStockOutQty = SqlFunc.AggregateSum(s.NoStockOutQty),
                                        LockQuantity = SqlFunc.AggregateSum(s.LockQuantity),
                                        BarcodeMoveQty = SqlFunc.AggregateSum(s.BarcodeMoveQty),
                                        BarcodeQty =SqlFunc.AggregateMin( s.BarcodeQty),
                                        BarcodeUnit = SqlFunc.AggregateMin(s.BarcodeUnit),
                                        BatchAllocateStatus = SqlFunc.AggregateMin(s.BatchAllocateStatus),
                                        CreateDate = SqlFunc.AggregateMin(s.CreateDate),
                                        Creater = SqlFunc.AggregateMin(s.Creater),
                                        documentsNO = SqlFunc.AggregateMin(s.documentsNO),
                                        Id = SqlFunc.AggregateMin(s.Id),
                                        lineNo = SqlFunc.AggregateMin(s.lineNo),
                                        Modifier = SqlFunc.AggregateMin(s.Modifier),
                                        ModifyDate = SqlFunc.AggregateMin(s.ModifyDate),
                                        OrderDetailStatus = SqlFunc.AggregateMin(s.OrderDetailStatus),
                                        OrderId = SqlFunc.AggregateMin(s.OrderId),
                                        Remark = SqlFunc.AggregateMin(s.Remark),
                                        ReturnJsonData = SqlFunc.AggregateMin(s.ReturnJsonData),
                                        ReturnToMESStatus = SqlFunc.AggregateMin(s.ReturnToMESStatus),
                                        RowNo = SqlFunc.AggregateMin(s.RowNo),
                                        Unit = SqlFunc.AggregateMin(s.Unit)
                                    });
                                    var dataList = sugarQueryable1.ToPageList(options.Page, options.Rows, ref totalCount);
                                    return new PageGridData<Dt_OutboundOrderDetail>(totalCount, dataList);
                                }
                            }
                        }
                    }
                }
            }
            //    List<SearchParameters> searchParametersList = options.Wheres.DeserializeObject<List<SearchParameters>>();
            //    int totalCount = 0;
            //    if (searchParametersList.Count > 0)
            //    {
            //        {
            //            SearchParameters? searchParameters = searchParametersList.FirstOrDefault(x => x.Name == nameof(Dt_InboundOrderDetail.OrderId).FirstLetterToLower());
            //            if (searchParameters != null)
            //            {
            //                Dt_OutboundOrder outboundOrder = _outboundOrderService.Repository.QueryFirst(x => x.Id == searchParameters.Value.ObjToInt());
            //                if (outboundOrder != null)
            //                {
            //                    if (outboundOrder.IsBatch == 0)
            //                    {
            //                        sugarQueryable1 = sugarQueryable1.Where(x => x.OrderId == searchParameters.Value.ObjToInt());
            //                        var dataList = sugarQueryable1.ToPageList(options.Page, options.Rows, ref totalCount);
            //                        return new PageGridData<Dt_OutboundOrderDetail>(totalCount, dataList);
            //                    }
            //                    else
            //                    {
            //                        sugarQueryable1 = sugarQueryable1.Where(x => x.OrderId == searchParameters.Value.ObjToInt());
            //                        sugarQueryable1.GroupBy(x => new { x.MaterielCode, x.MaterielName, x.BatchNo, x.SupplyCode, x.WarehouseCode }).Select(s => new Dt_OutboundOrderDetail
            //                        {
            //                            WarehouseCode = s.WarehouseCode,
            //                            SupplyCode = s.SupplyCode,
            //                            BatchNo = s.BatchNo,
            //                            MaterielName = s.MaterielName,
            //                            MaterielCode = s.MaterielCode,
            //                            AllocatedQuantity = SqlFunc.AggregateSum(s.AllocatedQuantity),
            //                            OrderQuantity = SqlFunc.AggregateSum(s.OrderQuantity),
            //                            PickedQty = SqlFunc.AggregateSum(s.PickedQty),
            //                            OverOutQuantity = SqlFunc.AggregateSum(s.OverOutQuantity),
            //                            MoveQty = SqlFunc.AggregateSum(s.MoveQty),
            //                            NoStockOutQty = SqlFunc.AggregateSum(s.NoStockOutQty),
            //                            LockQuantity = SqlFunc.AggregateSum(s.LockQuantity),
            //                            BarcodeMoveQty = SqlFunc.AggregateSum(s.BarcodeMoveQty),
            //                            BarcodeQty =SqlFunc.AggregateMin( s.BarcodeQty),
            //                            BarcodeUnit = SqlFunc.AggregateMin(s.BarcodeUnit),
            //                            BatchAllocateStatus = SqlFunc.AggregateMin(s.BatchAllocateStatus),
            //                            CreateDate = SqlFunc.AggregateMin(s.CreateDate),
            //                            Creater = SqlFunc.AggregateMin(s.Creater),
            //                            documentsNO = SqlFunc.AggregateMin(s.documentsNO),
            //                            Id = SqlFunc.AggregateMin(s.Id),
            //                            lineNo = SqlFunc.AggregateMin(s.lineNo),
            //                            Modifier = SqlFunc.AggregateMin(s.Modifier),
            //                            ModifyDate = SqlFunc.AggregateMin(s.ModifyDate),
            //                            OrderDetailStatus = SqlFunc.AggregateMin(s.OrderDetailStatus),
            //                            OrderId = SqlFunc.AggregateMin(s.OrderId),
            //                            Remark = SqlFunc.AggregateMin(s.Remark),
            //                            ReturnJsonData = SqlFunc.AggregateMin(s.ReturnJsonData),
            //                            ReturnToMESStatus = SqlFunc.AggregateMin(s.ReturnToMESStatus),
            //                            RowNo = SqlFunc.AggregateMin(s.RowNo),
            //                            Unit = SqlFunc.AggregateMin(s.Unit)
            //                        });
            //                        var dataList = sugarQueryable1.ToPageList(options.Page, options.Rows, ref totalCount);
            //                        return new PageGridData<Dt_OutboundOrderDetail>(totalCount, dataList);
            //                    }
            //                }
            //            }
            //        }
            //    }
            //}
            return new PageGridData<Dt_OutboundOrderDetail>();
        }