From f244ae12e0b29ced1402f8c2eda462845fb20875 Mon Sep 17 00:00:00 2001
From: lazhen <17772815105@139.com>
Date: 星期五, 22 十一月 2024 16:11:14 +0800
Subject: [PATCH] 存档报表界面查询
---
_Main/BL/Type_CustomerDemandIDS/StaticMethod_GenerateData.qbl | 34 +++++++++++++++++-----------------
1 files changed, 17 insertions(+), 17 deletions(-)
diff --git a/_Main/BL/Type_CustomerDemandIDS/StaticMethod_GenerateData.qbl b/_Main/BL/Type_CustomerDemandIDS/StaticMethod_GenerateData.qbl
index 7c524e6..bd51385 100644
--- a/_Main/BL/Type_CustomerDemandIDS/StaticMethod_GenerateData.qbl
+++ b/_Main/BL/Type_CustomerDemandIDS/StaticMethod_GenerateData.qbl
@@ -14,17 +14,17 @@
//interface.CustomerDemandIDS( relflush );
//interface.CustomerDemandIDSSearch( relflush );
info( '-------------------------Start---------------------');
- allunit := CustomerDemandIDS::GetDefaultAllUnit();
- search := interface.CustomerDemandIDSSearch( relnew, Product := allunit, StartDate := Date::MinDate(), EndDate := Date::MaxDate(), Unit := allunit );
+ allunit := CustomerDemandIDS::GetDefaultAllUnit();//search :=
+ interface.CustomerDemandIDSSearch( relnew, Product := allunit, StartDate := Date::MinDate(), EndDate := Date::MaxDate(), Unit := allunit );
name := '瀹㈡埛闇�姹�';
idstable := selectobject( interface, CustomerDemandIDS, idstable, idstable.ID() = name );
if( isnull( idstable ) ){
idstable := interface.CustomerDemandIDS( relnew, ID := name, Name := name );
}
- showtable := selectobject( interface, CustomerDemandIDS, version, version.IsShow() );
- if( isnull( showtable ) ){
- showtable := interface.CustomerDemandIDS( relnew, ID := name + 'Show', Name := name, IsShow := true );
- }
+ //showtable := selectobject( interface, CustomerDemandIDS, version, version.IsShow() );
+ //if( isnull( showtable ) ){
+ // showtable := interface.CustomerDemandIDS( relnew, ID := name + 'Show', Name := name, IsShow := true );
+ //}
binaryValue := TemplateManager::GetIDSFullTable( archive, Date::ActualDate().Year() );
source := GeneralExcelImportAndExportDataSource::Upload( recycle, binaryValue, OS::TempPath() + "template.xlsx" );
source.ReadStructure();
@@ -48,12 +48,12 @@
traverse( row, GeneralExcelImportAndExportDataCell, cell, cell.GeneralExcelImportAndExportDataColumn().ColumnIndex() > 2 ){
period := cnv2.Convert( cell.GeneralExcelImportAndExportDataColumn().Name() );
daycolumn := idstable.GetColumnByTimeUnit( Translations::MP_GlobalParameters_Day(), period );
- weekcolumn := idstable.GetColumnByTimeUnit( Translations::MP_GlobalParameters_Week(), period );
- monthcolumn := idstable.GetColumnByTimeUnit( Translations::MP_GlobalParameters_Month(), period );
+ // weekcolumn := idstable.GetColumnByTimeUnit( Translations::MP_GlobalParameters_Week(), period );
+ // monthcolumn := idstable.GetColumnByTimeUnit( Translations::MP_GlobalParameters_Month(), period );
idsrow.SetCellValue( daycolumn, [Number]cell.Value() );
- idsrow.SetCellValue( weekcolumn, [Number]cell.Value() );
- idsrow.SetCellValue( monthcolumn, [Number]cell.Value() );
+ // idsrow.SetCellValue( weekcolumn, [Number]cell.Value() );
+ // idsrow.SetCellValue( monthcolumn, [Number]cell.Value() );
}
}
}
@@ -66,18 +66,18 @@
traverse( forecast, PlanningSalesDemandInPeriod, sdip ){
idsrow := idstable.GetRowByUnit( forecast.ProductID(), unitname );
daycolumn := idstable.GetColumnByTimeUnit( Translations::MP_GlobalParameters_Day(), sdip.StartDate() );
- weekcolumn := idstable.GetColumnByTimeUnit( Translations::MP_GlobalParameters_Week(), sdip.StartDate() );
- monthcolumn := idstable.GetColumnByTimeUnit( Translations::MP_GlobalParameters_Month(), sdip.StartDate() );
- info( '-----------------', isnull( idsrow ), isnull( daycolumn ), isnull( weekcolumn ), isnull( monthcolumn ), sdip.StartDate() );
+ // weekcolumn := idstable.GetColumnByTimeUnit( Translations::MP_GlobalParameters_Week(), sdip.StartDate() );
+ // monthcolumn := idstable.GetColumnByTimeUnit( Translations::MP_GlobalParameters_Month(), sdip.StartDate() );
+ // info( '-----------------', isnull( idsrow ), isnull( daycolumn ), isnull( weekcolumn ), isnull( monthcolumn ), sdip.StartDate() );
idsrow.SetCellValue( daycolumn, [Number]sdip.Quantity() );
- idsrow.SetCellValue( weekcolumn, [Number]sdip.Quantity() );
- idsrow.SetCellValue( monthcolumn, [Number]sdip.Quantity() );
+ // idsrow.SetCellValue( weekcolumn, [Number]sdip.Quantity() );
+ // idsrow.SetCellValue( monthcolumn, [Number]sdip.Quantity() );
}
}
source.Delete();
info( '-------------------------End---------------------');
- productids := selectuniquevalues( idstable, Row, row, row.Name() );
- showtable.Generate( search, productids );
+ //productids := selectuniquevalues( idstable, Row, row, row.Name() );
+ //showtable.Generate( search, productids );
*]
}
--
Gitblit v1.9.3