BUG&优化项

陈清红

2025-04-14 880f3c0257eeb8c37761d484258fdd102a369a19

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
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() ) );
  *]
}