chenqinghong
2024-05-07 3ec06a830367465068963156dcc1d8e522571c13
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
35
36
37
38
39
Quintiq file version 2.0
#parent: #root
Method SynchronizeUnitCapacities (
  owning BinaryData unitcapacities,
  owning BinaryData unitavailabilities,
  owning BinaryData transportcapacities,
  owning BinaryData transportavailabilities,
  owning BinaryData unitcalendars,
  owning BinaryData shiftpattern
)
{
  Description: 'Import unit capacities from UnitCapacities excel sheet'
  TextBody:
  [*
    //  This feature is only available on 5.3.0 and above.
    this.ImportUnitCalendars( unitcalendars.AsBinaryValue() );
    
    this.ValidateBroker( typeof( MP_ImportShiftPatternsBroker ).ShortName(), this.MP_ImportShiftPatternsBroker().Source(), shiftpattern.AsBinaryValue() );
    this.ValidateBroker( typeof( MP_ImportUnitCapacitiesBroker ).ShortName(), this.MP_ImportUnitCapacitiesBroker().Source(), unitcapacities.AsBinaryValue() );
    this.ValidateBroker( typeof( MP_ImportUnitAvailabilitiesBroker ).ShortName(), this.MP_ImportUnitAvailabilitiesBroker().Source(), unitavailabilities.AsBinaryValue() );
    this.ValidateBroker( typeof( MP_ImportTransportCapacitiesBroker ).ShortName(), this.MP_ImportTransportCapacitiesBroker().Source(), transportcapacities.AsBinaryValue() );
    this.ValidateBroker( typeof( MP_ImportTransportAvailabilitiesBroker ).ShortName(), this.MP_ImportTransportAvailabilitiesBroker().Source(), transportavailabilities.AsBinaryValue() );
    
    progress( 'Importing unit capacities', DateTime::ActualTime() );
    this.MP_ImportUnitCapacitiesBroker().ExecuteFromXLS( &unitcapacities, true );
    
    progress( 'Importing unit availabilities', DateTime::ActualTime() );
    this.MP_ImportUnitAvailabilitiesBroker().ExecuteFromXLS( &unitavailabilities, true );
    
    progress( 'Importing transport capacities', DateTime::ActualTime() );
    this.MP_ImportTransportCapacitiesBroker().ExecuteFromXLS( &transportcapacities, true ); 
    
    progress( 'Importing transport availabilities', DateTime::ActualTime() );
    this.MP_ImportTransportAvailabilitiesBroker().ExecuteFromXLS( &transportavailabilities, true ); 
    
    progress( 'Importing shift pattern', DateTime::ActualTime() );
    this.MP_ImportShiftPatternsBroker().ExecuteFromXLS( &shiftpattern, true );
  *]
}