更新 StaticMethod_GenerateAnnualPlanReport.qbl

xiaoding721

2024-11-21 99cac3bb9bc0baa321d7726d75854ab38bcddc05

 _Main/UI/MacroPlannerWebApp/Component_FormDLEngineLogisticsCostReport/Response_MatrixEditorTable_OnUpdateValue.def

@@ -1,11 +1,11 @@
Quintiq file version 2.0
#parent: MatrixEditorTable
Response OnUpdateValue (
  CCEngineLogisticsCostRow row,
  CCEngineLogisticsCostColumn column,
  CCEngineLogisticsCostCell cell,
  Number value,
  Number oldvalue
  DLEngineLogisticsCostRow row,
  DLEngineLogisticsCostColumn column,
  DLEngineLogisticsCostCell cell,
  String value,
  String oldvalue
) id:Response_MatrixEditorTable_OnUpdateValue
{
  #keys: '[415136.0.992750480]'
@@ -15,15 +15,24 @@
  {
    Body:
    [*
      table            := selectobject( MacroPlan, CCEngineLogisticsCostReport, report, not report.IsShow() );
      cell.Coefficient( value );
      table            := selectobject( MacroPlan, DLEngineLogisticsCostReport, report, not report.IsShow() );
      //info( focusedattribute );
      cell.CoefficientValue( value );
      traverse( table, Row, trow, trow.Name() = row.Name() ){
        traverse( trow, Cell, tcel, tcel.Column().Name() = column.Name() ){
          tcel.RentEnterCost( cell.RentEnterCost() );
          tcel.RentOutCost( cell.RentOutCost() );
          tcel.FactoryToRentTransCost( cell.FactoryToRentTransCost() );
          tcel.RentStorageCost( cell.RentStorageCost() );
          tcel.Coefficient( cell.Coefficient() );
          tcel.CCRentInCost( cell.CCRentInCost() );
          tcel.CCRentOutOfCost( cell.CCRentOutOfCost() );
          tcel.CCLongTransCost( cell.CCLongTransCost() );
          tcel.CCRentStorCost( cell.CCRentStorCost() );
          tcel.CCShorTransCost( cell.CCShorTransCost() );
          tcel.DLRentInCost( cell.DLRentInCost() );
          tcel.DLRentOutOfCost( cell.DLRentOutOfCost() );
          tcel.DLRentOtherCost( cell.DLRentOtherCost() );
          tcel.DLRentStorCost( cell.DLRentStorCost() );
          tcel.WerkToDLRentTransCost( cell.WerkToDLRentTransCost() );
          tcel.CoefficientValue( cell.CoefficientValue() );
          estimatetotalcost := tcel.CCRentInCost() + tcel.CCRentOutOfCost() + tcel.CCLongTransCost() + tcel.CCRentStorCost() + tcel.CCShorTransCost() + tcel.DLRentInCost() + tcel.DLRentOutOfCost() + tcel.DLRentOtherCost() + tcel.DLRentStorCost() + tcel.WerkToDLRentTransCost();
          tcel.AllCost( estimatetotalcost * [Real]tcel.CoefficientValue() );
        }
      }
    *]