Quintiq file version 2.0
|
#parent: #root
|
Method SetCellValue (
|
Real quantityOfWoodenCrates
|
)
|
{
|
Description: '更新单元格值'
|
TextBody:
|
[*
|
// 设置木箱数量
|
this.QuantityOfWoodenCrates( quantityOfWoodenCrates );
|
|
// 空料架数量联动
|
this.WoodenCrateCost( [Number] ( quantityOfWoodenCrates * this.WoodenCratePriceReal() ) );
|
|
// SUM行联动
|
cell := select( this, MachineLogisticsCostReportColumn.MachineLogisticsCostReportCell, tempMLCRCell, tempMLCRCell.MachineLogisticsCostReportRow().Category() = "SUM" );
|
cell.QuantityOfWoodenCrates( sum( this, MachineLogisticsCostReportColumn.MachineLogisticsCostReportCell,
|
tempMLCRCell, tempMLCRCell.MachineLogisticsCostReportRow().Category() <> "SUM" and tempMLCRCell.MachineLogisticsCostReportRow().Factory() = this.MachineLogisticsCostReportRow().Factory(),
|
tempMLCRCell.QuantityOfWoodenCrates() ) );
|
cell.WoodenCrateCost( sum( this, MachineLogisticsCostReportColumn.MachineLogisticsCostReportCell, tempMLCRCell,
|
tempMLCRCell.MachineLogisticsCostReportRow().Category() <> "SUM" and tempMLCRCell.MachineLogisticsCostReportRow().Factory() = this.MachineLogisticsCostReportRow().Factory(),
|
tempMLCRCell.WoodenCrateCost() ) );
|
|
// SUM列联动
|
cell := select( this, MachineLogisticsCostReportRow.MachineLogisticsCostReportCell, tempMLCRCell, tempMLCRCell.MachineLogisticsCostReportColumn().DisplayName() = "SUM" );
|
cell.QuantityOfWoodenCrates( sum( this, MachineLogisticsCostReportRow.MachineLogisticsCostReportCell, tempMLCRCell,
|
not tempMLCRCell.MachineLogisticsCostReportColumn().StartDate().IsMaxInfinity(),
|
tempMLCRCell.QuantityOfWoodenCrates() ) );
|
cell.WoodenCrateCost( sum( this, MachineLogisticsCostReportRow.MachineLogisticsCostReportCell, tempMLCRCell,
|
not tempMLCRCell.MachineLogisticsCostReportColumn().StartDate().IsMaxInfinity(),
|
tempMLCRCell.WoodenCrateCost() ) );
|
*]
|
}
|
