Quintiq file version 2.0
|
#parent: #root
|
StaticMethod CreatePanelAllocationBudget (
|
GlobalOTDSOP this,
|
CapacityAndSaleBudgeFilterMonths months,
|
CapacityAndSaleBudgeFilterYear year,
|
const GlobalOTDTable globalOTDTable
|
)
|
{
|
TextBody:
|
[*
|
traverse ( this, CapacityAndSaleBudgeCompareItemRow, casbcir ) {
|
total := 0.0;
|
traverse ( months, Elements, m ) {
|
columnName := "面板分配量-" + [String]year.YearNo() + "年-" + [String]m.MonthNo() + "月-年度预算";
|
columnMonth := CapacityAndSaleBudgeCompareItemColumn::CreateIfNotExist( this, columnName );
|
cellReal := Global_MappingForecast::GetQuantityByMonth( casbcir.GetProductCodes(), globalOTDTable, DateTime::Now().Year(), m.MonthNo() );
|
cell := columnMonth.CapacityAndSaleBudgeCompareItemCell( relnew, CellContent := [String]cellReal );
|
total := total + cellReal;
|
cell.CapacityAndSaleBudgeCompareItemRow( relset, casbcir );
|
}
|
columnYear := CapacityAndSaleBudgeCompareItemColumn::CreateIfNotExist( this, "面板分配量-" + [String]year.YearNo() + "年-total-年度预算" );
|
cell := columnYear.CapacityAndSaleBudgeCompareItemCell( relnew, CellContent := [String]total );
|
columnYear.TotalIdentification( year.YearNo() );
|
cell.CapacityAndSaleBudgeCompareItemRow( relset, casbcir );
|
}
|
*]
|
}
|
