From b02a3586a97064c94087c0e3ca2eac36cd9d9b42 Mon Sep 17 00:00:00 2001
From: lazhen <17772815105@139.com>
Date: 星期一, 21 十月 2024 17:36:04 +0800
Subject: [PATCH] 库存汇总报表导出格式修改
---
_Main/BL/Type_InventorySummaryColumn/Method_GenerateCell.qbl | 10 +++++-----
1 files changed, 5 insertions(+), 5 deletions(-)
diff --git a/_Main/BL/Type_InventorySummaryColumn/Method_GenerateCell.qbl b/_Main/BL/Type_InventorySummaryColumn/Method_GenerateCell.qbl
index c56f1d4..8daf1ab 100644
--- a/_Main/BL/Type_InventorySummaryColumn/Method_GenerateCell.qbl
+++ b/_Main/BL/Type_InventorySummaryColumn/Method_GenerateCell.qbl
@@ -7,7 +7,7 @@
InventorySummaryReport table,
Date start,
Date end,
- String productid,
+ Product_MP product,
String allunit,
String ccunit,
String dlunit
@@ -17,22 +17,22 @@
[*
// 鐢勫叞楦� Jul-3-2024 (created)
//All
- alldetails := selectset( selections, Elements.InventoryInterfaceDataDetail, detail, detail.PartNumber() = productid and detail.Date() >= start and detail.Date() <= end );
+ alldetails := selectset( selections, Elements.InventoryInterfaceDataDetail, detail, detail.PartNumber() = product.ID() and detail.Date() >= start and detail.Date() <= end );
if( alldetails.Size() > 0 ){
- allrow := table.GetRow( allunit, productid );
+ allrow := table.GetRow( allunit, product );
allvalue := sum( alldetails, Elements, e, [Number]e.Quantity() );
allrow.SetCellValue( this, allvalue );
//闀挎槬
ccdetails := selectset( alldetails, Elements, detail, ccstockingpointids.Find( detail.InventoryPointSelection().StockpoingPoint() ) >= 0 );
if( ccdetails.Size() > 0 ){
- ccrow := table.GetRow( ccunit, productid );
+ ccrow := table.GetRow( ccunit, product );
value := sum( ccdetails, Elements, e, [Number]e.Quantity() );
ccrow.SetCellValue( this, value );
}
//澶ц繛
dldetails := selectset( alldetails, Elements, detail, dlstockingpointids.Find( detail.InventoryPointSelection().StockpoingPoint() ) >= 0 );
if( dldetails.Size() > 0 ){
- dlrow := table.GetRow( dlunit, productid );
+ dlrow := table.GetRow( dlunit, product );
value := sum( dldetails, Elements, e, [Number]e.Quantity() );
dlrow.SetCellValue( this, value );
}
--
Gitblit v1.9.3