产销预算中间表

yypsybs

2023-10-08 61eabd9fd3e80a694152df818abc9145977678b5

产销预算中间表

 _Main/BL/EDI/Broker_GlobalOTDTable_AnnualBudgetData.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,397 @@
Quintiq file version 2.0
#parent: #root
EDIBroker GlobalOTDTable_AnnualBudgetData
{
  MDSDefinition: GlobalOTDTable
  TimeZone: 'ACT'
  UseOSTimeZone: false
  EDIModelLink.Destination DES_AnnualBudgetData
  {
    EDIMLTable Global_MappingAnnualBudgetData
    {
      PrimaryKeyColumns: ID
      TargetType: Global_MappingAnnualBudgetData
      TypeIndex: Global_MappingAnnualBudgetDataTypeIndex
      EDIMLColumn BusinessSort { Attribute: BusinessSort ValueType: String }
      EDIMLColumn BusinessType { Attribute: BusinessType ValueType: String }
      EDIMLColumn CapacityEquivalent { Attribute: CapacityEquivalent ValueType: String }
      EDIMLColumn CutsNumber { Attribute: CutsNumber ValueType: String }
      EDIMLColumn DisplayTechSort { Attribute: DisplayTechSort ValueType: String }
      EDIMLColumn ID { Attribute: ID ValueType: String }
      EDIMLColumn MaskNumber { Attribute: MaskNumber ValueType: String }
      EDIMLColumn MonthlyModCapacity1 { Attribute: MonthlyModCapacity1 ValueType: String }
      EDIMLColumn MonthlyModCapacity10 { Attribute: MonthlyModCapacity10 ValueType: String }
      EDIMLColumn MonthlyModCapacity11 { Attribute: MonthlyModCapacity11 ValueType: String }
      EDIMLColumn MonthlyModCapacity12 { Attribute: MonthlyModCapacity12 ValueType: String }
      EDIMLColumn MonthlyModCapacity2 { Attribute: MonthlyModCapacity2 ValueType: String }
      EDIMLColumn MonthlyModCapacity3 { Attribute: MonthlyModCapacity3 ValueType: String }
      EDIMLColumn MonthlyModCapacity4 { Attribute: MonthlyModCapacity4 ValueType: String }
      EDIMLColumn MonthlyModCapacity5 { Attribute: MonthlyModCapacity5 ValueType: String }
      EDIMLColumn MonthlyModCapacity6 { Attribute: MonthlyModCapacity6 ValueType: String }
      EDIMLColumn MonthlyModCapacity7 { Attribute: MonthlyModCapacity7 ValueType: String }
      EDIMLColumn MonthlyModCapacity8 { Attribute: MonthlyModCapacity8 ValueType: String }
      EDIMLColumn MonthlyModCapacity9 { Attribute: MonthlyModCapacity9 ValueType: String }
      EDIMLColumn MonthlySales1 { Attribute: MonthlySales1 ValueType: String }
      EDIMLColumn MonthlySales10 { Attribute: MonthlySales10 ValueType: String }
      EDIMLColumn MonthlySales11 { Attribute: MonthlySales11 ValueType: String }
      EDIMLColumn MonthlySales12 { Attribute: MonthlySales12 ValueType: String }
      EDIMLColumn MonthlySales2 { Attribute: MonthlySales2 ValueType: String }
      EDIMLColumn MonthlySales3 { Attribute: MonthlySales3 ValueType: String }
      EDIMLColumn MonthlySales4 { Attribute: MonthlySales4 ValueType: String }
      EDIMLColumn MonthlySales5 { Attribute: MonthlySales5 ValueType: String }
      EDIMLColumn MonthlySales6 { Attribute: MonthlySales6 ValueType: String }
      EDIMLColumn MonthlySales7 { Attribute: MonthlySales7 ValueType: String }
      EDIMLColumn MonthlySales8 { Attribute: MonthlySales8 ValueType: String }
      EDIMLColumn MonthlySales9 { Attribute: MonthlySales9 ValueType: String }
      EDIMLColumn MonthlySheetCapacity1 { Attribute: MonthlySheetCapacity1 ValueType: String }
      EDIMLColumn MonthlySheetCapacity10 { Attribute: MonthlySheetCapacity10 ValueType: String }
      EDIMLColumn MonthlySheetCapacity11 { Attribute: MonthlySheetCapacity11 ValueType: String }
      EDIMLColumn MonthlySheetCapacity12 { Attribute: MonthlySheetCapacity12 ValueType: String }
      EDIMLColumn MonthlySheetCapacity2 { Attribute: MonthlySheetCapacity2 ValueType: String }
      EDIMLColumn MonthlySheetCapacity3 { Attribute: MonthlySheetCapacity3 ValueType: String }
      EDIMLColumn MonthlySheetCapacity4 { Attribute: MonthlySheetCapacity4 ValueType: String }
      EDIMLColumn MonthlySheetCapacity5 { Attribute: MonthlySheetCapacity5 ValueType: String }
      EDIMLColumn MonthlySheetCapacity6 { Attribute: MonthlySheetCapacity6 ValueType: String }
      EDIMLColumn MonthlySheetCapacity7 { Attribute: MonthlySheetCapacity7 ValueType: String }
      EDIMLColumn MonthlySheetCapacity8 { Attribute: MonthlySheetCapacity8 ValueType: String }
      EDIMLColumn MonthlySheetCapacity9 { Attribute: MonthlySheetCapacity9 ValueType: String }
      EDIMLColumn OrganCode { Attribute: OrganCode ValueType: String }
      EDIMLColumn OrganName { Attribute: OrganName ValueType: String }
      EDIMLColumn PlantName { Attribute: PlantName ValueType: String }
      EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
      EDIMLColumn ProductLineAndSpecification { Attribute: ProductLineAndSpecification ValueType: String }
      EDIMLColumn ResolutionRatio { Attribute: ResolutionRatio ValueType: String }
      EDIMLColumn ShippingForm { Attribute: ShippingForm ValueType: String }
      EDIMLColumn YearNo { Attribute: YearNo ValueType: String }
    }
  }
  EDIODBCLink.Source MID_AnnualBudgetData
  {
    DataIntegrityStrategy: 'Disabled'
    SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.oracle'
    EDIODBCLinkTable MID_ANNUALBUDGETDATA
    {
      OthersMayCreateTable: true
      OthersMayDeleteRow: true
      OthersMayDropTable: true
      OthersMayFlushTable: true
      OthersMayInsertRow: true
      Parameters: '/owner="YUXTEST"'
      RecordModificationHintStrategy: 'None'
      EDIODBCLinkColumn BUSINESSSORT
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn BUSINESSTYPE
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn CAPACITYEQUIVALENT
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn CUTSNUMBER
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn DISPLAYTECHSORT
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn ID
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MASKNUMBER
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYMODCAPACITY1
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYMODCAPACITY10
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYMODCAPACITY11
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYMODCAPACITY12
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYMODCAPACITY2
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYMODCAPACITY3
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYMODCAPACITY4
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYMODCAPACITY5
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYMODCAPACITY6
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYMODCAPACITY7
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYMODCAPACITY8
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYMODCAPACITY9
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYSALES1
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYSALES10
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYSALES11
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYSALES12
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYSALES2
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYSALES3
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYSALES4
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYSALES5
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYSALES6
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYSALES7
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYSALES8
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYSALES9
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYSHEETCAPACITY1
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYSHEETCAPACITY10
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYSHEETCAPACITY11
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYSHEETCAPACITY12
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYSHEETCAPACITY2
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYSHEETCAPACITY3
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYSHEETCAPACITY4
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYSHEETCAPACITY5
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYSHEETCAPACITY6
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYSHEETCAPACITY7
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYSHEETCAPACITY8
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn MONTHLYSHEETCAPACITY9
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn ORGANCODE
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn ORGANNAME
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn PLANTNAME
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn PRODUCTID
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn PRODUCTLINEANDSPECIFICATION
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn RESOLUTIONRATIO
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn SHIPPINGFORM
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn YEARNO
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
    }
  }
  EDITransformation.Transformation TransformationAnnualBudgetData
  {
    EDITableTransformation
    {
      InputTable: MID_ANNUALBUDGETDATA
      OutputTable: Global_MappingAnnualBudgetData
      EDIColumnMatch { InputColumn: BUSINESSSORT OutputColumn: BusinessSort }
      EDIColumnMatch { InputColumn: BUSINESSTYPE OutputColumn: BusinessType }
      EDIColumnMatch { InputColumn: CAPACITYEQUIVALENT OutputColumn: CapacityEquivalent }
      EDIColumnMatch { InputColumn: CUTSNUMBER OutputColumn: CutsNumber }
      EDIColumnMatch { InputColumn: DISPLAYTECHSORT OutputColumn: DisplayTechSort }
      EDIColumnMatch { InputColumn: ID OutputColumn: ID }
      EDIColumnMatch { InputColumn: MASKNUMBER OutputColumn: MaskNumber }
      EDIColumnMatch { InputColumn: MONTHLYMODCAPACITY1 OutputColumn: MonthlyModCapacity1 }
      EDIColumnMatch { InputColumn: MONTHLYMODCAPACITY10 OutputColumn: MonthlyModCapacity10 }
      EDIColumnMatch { InputColumn: MONTHLYMODCAPACITY11 OutputColumn: MonthlyModCapacity11 }
      EDIColumnMatch { InputColumn: MONTHLYMODCAPACITY12 OutputColumn: MonthlyModCapacity12 }
      EDIColumnMatch { InputColumn: MONTHLYMODCAPACITY2 OutputColumn: MonthlyModCapacity2 }
      EDIColumnMatch { InputColumn: MONTHLYMODCAPACITY3 OutputColumn: MonthlyModCapacity3 }
      EDIColumnMatch { InputColumn: MONTHLYMODCAPACITY4 OutputColumn: MonthlyModCapacity4 }
      EDIColumnMatch { InputColumn: MONTHLYMODCAPACITY5 OutputColumn: MonthlyModCapacity5 }
      EDIColumnMatch { InputColumn: MONTHLYMODCAPACITY6 OutputColumn: MonthlyModCapacity6 }
      EDIColumnMatch { InputColumn: MONTHLYMODCAPACITY7 OutputColumn: MonthlyModCapacity7 }
      EDIColumnMatch { InputColumn: MONTHLYMODCAPACITY8 OutputColumn: MonthlyModCapacity8 }
      EDIColumnMatch { InputColumn: MONTHLYMODCAPACITY9 OutputColumn: MonthlyModCapacity9 }
      EDIColumnMatch { InputColumn: MONTHLYSALES1 OutputColumn: MonthlySales1 }
      EDIColumnMatch { InputColumn: MONTHLYSALES10 OutputColumn: MonthlySales10 }
      EDIColumnMatch { InputColumn: MONTHLYSALES11 OutputColumn: MonthlySales11 }
      EDIColumnMatch { InputColumn: MONTHLYSALES12 OutputColumn: MonthlySales12 }
      EDIColumnMatch { InputColumn: MONTHLYSALES2 OutputColumn: MonthlySales2 }
      EDIColumnMatch { InputColumn: MONTHLYSALES3 OutputColumn: MonthlySales3 }
      EDIColumnMatch { InputColumn: MONTHLYSALES4 OutputColumn: MonthlySales4 }
      EDIColumnMatch { InputColumn: MONTHLYSALES5 OutputColumn: MonthlySales5 }
      EDIColumnMatch { InputColumn: MONTHLYSALES6 OutputColumn: MonthlySales6 }
      EDIColumnMatch { InputColumn: MONTHLYSALES7 OutputColumn: MonthlySales7 }
      EDIColumnMatch { InputColumn: MONTHLYSALES8 OutputColumn: MonthlySales8 }
      EDIColumnMatch { InputColumn: MONTHLYSALES9 OutputColumn: MonthlySales9 }
      EDIColumnMatch { InputColumn: MONTHLYSHEETCAPACITY1 OutputColumn: MonthlySheetCapacity1 }
      EDIColumnMatch { InputColumn: MONTHLYSHEETCAPACITY10 OutputColumn: MonthlySheetCapacity10 }
      EDIColumnMatch { InputColumn: MONTHLYSHEETCAPACITY11 OutputColumn: MonthlySheetCapacity11 }
      EDIColumnMatch { InputColumn: MONTHLYSHEETCAPACITY12 OutputColumn: MonthlySheetCapacity12 }
      EDIColumnMatch { InputColumn: MONTHLYSHEETCAPACITY2 OutputColumn: MonthlySheetCapacity2 }
      EDIColumnMatch { InputColumn: MONTHLYSHEETCAPACITY3 OutputColumn: MonthlySheetCapacity3 }
      EDIColumnMatch { InputColumn: MONTHLYSHEETCAPACITY4 OutputColumn: MonthlySheetCapacity4 }
      EDIColumnMatch { InputColumn: MONTHLYSHEETCAPACITY5 OutputColumn: MonthlySheetCapacity5 }
      EDIColumnMatch { InputColumn: MONTHLYSHEETCAPACITY6 OutputColumn: MonthlySheetCapacity6 }
      EDIColumnMatch { InputColumn: MONTHLYSHEETCAPACITY7 OutputColumn: MonthlySheetCapacity7 }
      EDIColumnMatch { InputColumn: MONTHLYSHEETCAPACITY8 OutputColumn: MonthlySheetCapacity8 }
      EDIColumnMatch { InputColumn: MONTHLYSHEETCAPACITY9 OutputColumn: MonthlySheetCapacity9 }
      EDIColumnMatch { InputColumn: ORGANCODE OutputColumn: OrganCode }
      EDIColumnMatch { InputColumn: ORGANNAME OutputColumn: OrganName }
      EDIColumnMatch { InputColumn: PLANTNAME OutputColumn: PlantName }
      EDIColumnMatch { InputColumn: PRODUCTID OutputColumn: ProductID }
      EDIColumnMatch { InputColumn: PRODUCTLINEANDSPECIFICATION OutputColumn: ProductLineAndSpecification }
      EDIColumnMatch { InputColumn: RESOLUTIONRATIO OutputColumn: ResolutionRatio }
      EDIColumnMatch { InputColumn: SHIPPINGFORM OutputColumn: ShippingForm }
      EDIColumnMatch { InputColumn: YEARNO OutputColumn: YearNo }
    }
  }
}

 _Main/BL/Relations/Relation_Global_MappingAnnualBudgetData_GlobalOTDTable_GlobalOTDTable_Global.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,23 @@
Quintiq file version 2.0
#parent: #root
Relation Global_MappingAnnualBudgetData_GlobalOTDTable_GlobalOTDTable_Global_MappingAnnualBudgetData
{
  #keys: '1[414384.0.933884750]'
  DefaultRelationStrategy
  {
  }
  RelationSide.LeftSide GlobalOTDTable
  {
    #keys: '3[414384.0.933884752][414384.0.933884751][414384.0.933884753]'
    Cardinality: '0to1'
    ObjectDefinition: Global_MappingAnnualBudgetData
    OwningSide: 'Reference'
  }
  RelationSide.RightSide Global_MappingAnnualBudgetData
  {
    #keys: '3[414384.0.933884755][414384.0.933884754][414384.0.933884756]'
    Cardinality: '1toN'
    ObjectDefinition: GlobalOTDTable
    OwningSide: 'Owned'
  }
}

 _Main/BL/Relations/Relation_MappingAnnualBudget_MPSync_MPSync_MappingAnnualBudget.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_Forecast/StaticMethod_GetFulfilledBalanceByHalfYear.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,21 @@
Quintiq file version 2.0
#parent: #root
StaticMethod GetFulfilledBalanceByHalfYear (
  Strings productNo,
  MacroPlan macroPlan,
  Number yearNo,
  Number halfNo
) as Real
{
  TextBody:
  [*
    // yypsybs Sep-18-2023 (created)
    fromMonth := 1 + ( halfNo - 1 ) * 6;
    toMonth := 6 + ( halfNo - 1 ) * 6;
    result := 0.0;
    for( i := fromMonth; i <= toMonth; i := i + 1 ) {
      result := result + Forecast::GetFulfilledBalanceByMonth( productNo, macroPlan, yearNo, i );
    }
    return result;
  *]
}

 _Main/BL/Type_Forecast/StaticMethod_GetFulfilledBalanceByMonth.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,22 @@
Quintiq file version 2.0
#parent: #root
StaticMethod GetFulfilledBalanceByMonth (
  Strings productNo,
  MacroPlan macroPlan,
  Number yearNo,
  Number monthNo
) as Real
{
  TextBody:
  [*
    // yypsybs Sep-18-2023 (created)
    result := sum( macroPlan, 
                   Product_MP.SalesDemand,
                   item, 
                   item.istype( Forecast ) and productNo.Find( item.ProductID() ) > -1 
                   and item.StartDate().Year() = yearNo
                   and item.StartDate().Month() = monthNo,
                   item.FulfilledQuantity() * item.Price() );
    return result;
  *]
}

 _Main/BL/Type_Forecast/StaticMethod_GetFulfilledBalanceBySeason#763.qbl

copy from _Main/BL/Type_MappingAnnualBudget/Method_GetCapacityInSheetInSeason.qbl
copy to "_Main/BL/Type_Forecast/StaticMethod_GetFulfilledBalanceBySeason\043763.qbl"
Îļþ´Ó _Main/BL/Type_MappingAnnualBudget/Method_GetCapacityInSheetInSeason.qbl ¸´ÖÆ
@@ -1,18 +1,20 @@
Quintiq file version 2.0
#parent: #root
Method GetCapacityInSheetInSeason (
StaticMethod GetFulfilledBalanceBySeason (
  Strings productNo,
  MacroPlan macroPlan,
  Number yearNo,
  Number seasonNo
) as Real
{
  TextBody:
  [*
    // yypsybs Sep-18-2023 (created)
    result := 0.0;
    fromMonth := 1 + ( seasonNo - 1 ) * 3;
    toMonth := 3 + ( seasonNo - 1 ) * 3;
    result := 0.0;
    for( i := fromMonth; i <= toMonth; i := i + 1 ) {
      field := Reflection::FindAttribute( "MappingAnnualBudget", "MonthlySheetCapacity" + [String]i );
      result := result + field.GetReal( this );
      result := result + Forecast::GetFulfilledBalanceByMonth( productNo, macroPlan, yearNo, i );
    }
    return result;
  *]

 _Main/BL/Type_Forecast/StaticMethod_GetFulfilledBalanceByYear#0.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,20 @@
Quintiq file version 2.0
#parent: #root
StaticMethod GetFulfilledBalanceByYear (
  Strings productNo,
  MacroPlan macroPlan,
  Number yearNo
) as Real
{
  TextBody:
  [*
    // yypsybs Sep-18-2023 (created)
    result := sum( macroPlan, 
                   Product_MP.SalesDemand,
                   item, 
                   item.istype( Forecast ) and productNo.Find( item.ProductID() ) > -1 
                   and item.StartDate().Year() = yearNo, 
                   item.FulfilledQuantity() * item.Price() );
    return result;
  *]
}

 _Main/BL/Type_Forecast/StaticMethod_GetFulfilledQuantityByHalfYear.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,21 @@
Quintiq file version 2.0
#parent: #root
StaticMethod GetFulfilledQuantityByHalfYear (
  Strings productNo,
  MacroPlan macroPlan,
  Number yearNo,
  Number halfNo
) as Real
{
  TextBody:
  [*
    // yypsybs Sep-18-2023 (created)
    fromMonth := 1 + ( halfNo - 1 ) * 6;
    toMonth := 6 + ( halfNo - 1 ) * 6;
    result := 0.0;
    for( i := fromMonth; i <= toMonth; i := i + 1 ) {
      result := result + Forecast::GetFulfilledQuantityByMonth( productNo, macroPlan, yearNo, i );
    }
    return result;
  *]
}

 _Main/BL/Type_Forecast/StaticMethod_GetFulfilledQuantityByMonth.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,22 @@
Quintiq file version 2.0
#parent: #root
StaticMethod GetFulfilledQuantityByMonth (
  Strings productNo,
  MacroPlan macroPlan,
  Number yearNo,
  Number monthNo
) as Real
{
  TextBody:
  [*
    // yypsybs Sep-18-2023 (created)
    result := sum( macroPlan, 
                   Product_MP.SalesDemand,
                   item, 
                   item.istype( Forecast ) and productNo.Find( item.ProductID() ) > -1 
                   and item.StartDate().Year() = yearNo
                   and item.StartDate().Month() = monthNo,
                   item.FulfilledQuantity() );
    return result;
  *]
}

 _Main/BL/Type_Forecast/StaticMethod_GetFulfilledQuantityBySeason.qbl

copy from _Main/BL/Type_MappingAnnualBudget/Method_GetCapacityInSheetInSeason.qbl
copy to _Main/BL/Type_Forecast/StaticMethod_GetFulfilledQuantityBySeason.qbl
Îļþ´Ó _Main/BL/Type_MappingAnnualBudget/Method_GetCapacityInSheetInSeason.qbl ¸´ÖÆ
@@ -1,18 +1,20 @@
Quintiq file version 2.0
#parent: #root
Method GetCapacityInSheetInSeason (
StaticMethod GetFulfilledQuantityBySeason (
  Strings productNo,
  MacroPlan macroPlan,
  Number yearNo,
  Number seasonNo
) as Real
{
  TextBody:
  [*
    // yypsybs Sep-18-2023 (created)
    result := 0.0;
    fromMonth := 1 + ( seasonNo - 1 ) * 3;
    toMonth := 3 + ( seasonNo - 1 ) * 3;
    result := 0.0;
    for( i := fromMonth; i <= toMonth; i := i + 1 ) {
      field := Reflection::FindAttribute( "MappingAnnualBudget", "MonthlySheetCapacity" + [String]i );
      result := result + field.GetReal( this );
      result := result + Forecast::GetFulfilledQuantityByMonth( productNo, macroPlan, yearNo, i );
    }
    return result;
  *]

 _Main/BL/Type_Forecast/StaticMethod_GetFulfilledQuantityByYear.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,20 @@
Quintiq file version 2.0
#parent: #root
StaticMethod GetFulfilledQuantityByYear (
  Strings productNo,
  MacroPlan macroPlan,
  Number yearNo
) as Real
{
  TextBody:
  [*
    // yypsybs Sep-18-2023 (created)
    result := sum( macroPlan, 
                   Product_MP.SalesDemand,
                   item, 
                   item.istype( Forecast ) and productNo.Find( item.ProductID() ) > -1 
                   and item.StartDate().Year() = yearNo, 
                   item.FulfilledQuantity() );
    return result;
  *]
}

 _Main/BL/Type_GlobalDTOTable/Method_CapacityAndSaleBudgeChart#156.qbl

@@ -9,9 +9,7 @@
  CapacityAndSaleBudgeFilterPlaceOfProductionOfArrays placeOfProductionOfArrays,
  CapacityAndSaleBudgeFilterYears years,
  CapacityAndSaleBudgeFilterMonths months,
  MPSync mpSync,
  GlobalOTDTable otdTable,
  MacroPlan mappingParent
  GlobalOTDTable otdTable
)
{
  Description: '按入参处理数据，产生需要的CapacityAndSaleBudgeChartElement'
@@ -19,62 +17,68 @@
  [*
    // yypsybs Sep-19-2023 (created)
    // true, false
    info( saleOrCapacity );
    //info( saleOrCapacity );
    // æœˆ;季度;半年;å¹´
    info( groupBy );
    //info( groupBy );
    // é¢æ¿åŸºåœ°;事业部
    info( byBusinessTypeOrByOrgCode );
    traverse( businessTypes, Elements, businessType ) {
      debuginfo( "businessType : " + businessType.BusinessType() );
    }
    traverse( placeOfProductionOfArrays, Elements, placeOfProductionOfArray ) {
      debuginfo( "placeOfProductionOfArray : " + placeOfProductionOfArray.PlaceOfProductionOfArray() );
    }
    traverse( macroPlans, Elements, macroPlan ) {
      debuginfo( "macroPlan : " + macroPlan.ScenarioName() );  
    }
    //info( byBusinessTypeOrByOrgCode );
    //traverse( businessTypes, Elements, businessType ) {
    //  info( "businessType : " + businessType.BusinessType() );
    //}
    //traverse( placeOfProductionOfArrays, Elements, placeOfProductionOfArray ) {
    //  info( "placeOfProductionOfArray : " + placeOfProductionOfArray.PlaceOfProductionOfArray() );
    //}
    //traverse( macroPlans, Elements, macroPlan ) {
    //  info( "macroPlan : " + macroPlan.ScenarioName() );  
    //}
    // å¹´ä»½ä¸é€‰æ—¶å…¨é€‰
    if( years.Size() = 0 ) {
      years := selectsortedset( this, CapacityAndSaleBudgeFilterYear, item, true, item.YearNo() );
    }
    traverse( years, Elements, year ) {
      debuginfo( "yearNo : " + [String]year.YearNo() );
    }
    //traverse( years, Elements, year ) {
    //  debuginfo( "yearNo : " + [String]year.YearNo() );
    //}
    // æœˆä»½ä¸é€‰æ—¶å…¨é€‰
    if( months.Size() = 0 ) {
      months := selectsortedset( this, CapacityAndSaleBudgeFilterMonth, item, true, item.MonthNo() );
    }
    traverse( months, Elements, month ) {
      debuginfo( "monthNo : " + [String]month.MonthNo() );
    }
    //traverse( months, Elements, month ) {
    //  debuginfo( "monthNo : " + [String]month.MonthNo() );
    //}
    
    // ====清理旧数据====
    this.CapacityAndSaleBudgeChartRow( relflush );
    this.CapacityAndSaleBudgeChartElement( relflush );
    
    // ====按面板基地和事业部对产品进行筛选分组====
    historyData := selectset( mpSync, MappingCapacityAndSaleBudge, item, true );
    historyData := selectset( otdTable, Global_MappingAnnualBudgetData, item, true );
    if( businessTypes.Size() > 0 ) {
      businessTypeStrings := selectuniquevalues( businessTypes, Elements, item, true, item.BusinessType() );
      historyData := selectset( historyData, Elements, item, businessTypeStrings.Find( item.BusinessType() ) > -1 );
    }
    if( placeOfProductionOfArrays.Size() > 0 ) {
      placeOfProductionOfArrayStrings := selectuniquevalues( placeOfProductionOfArrays, Elements, item, true, item.PlaceOfProductionOfArray() );
      historyData := selectset( historyData, Elements, item, placeOfProductionOfArrayStrings.Find( item.PlaceOfProductionOfArray() ) > -1 );
      historyData := selectset( historyData, Elements, item, placeOfProductionOfArrayStrings.Find( item.OrgCodeFromBom() ) > -1 );
    }
    //info( "historyData : " + [String]historyData.Size() );
    traverse( historyData, Elements, item ) {
      row := CapacityAndSaleBudgeChartRow::CreateIfNotExist( this, item.BusinessType(), item.PlaceOfProductionOfArray() );
      row := CapacityAndSaleBudgeChartRow::CreateIfNotExist( this, item.BusinessType(), item.OrgCodeFromBom() );
      // è®°å½•æ¯è¡ŒåŒ…含哪些product
      CapacityAndSaleBudgeChartRowProduct::CreateIfNotExist( row, item.ProductCode() );
      CapacityAndSaleBudgeChartRowProduct::CreateIfNotExist( row, item.ProductID() );
    }
    rows := selectset( this, CapacityAndSaleBudgeChartRow, item, true );
    //info( "rows : " + [String]rows.Size() );
    placeOfProductionOfArrayList := selectuniquevalues( historyData, Elements, item, item.PlaceOfProductionOfArray() );
    placeOfProductionOfArrayList := selectuniquevalues( historyData, Elements, item, item.OrgCodeFromBom() );
    //traverse( placeOfProductionOfArrayList, Elements, item ) {
    //  info( "placeOfProduction : " + item );  
    //}
    businessTypeList := selectuniquevalues( historyData, Elements, item, item.BusinessType() );
    //traverse( businessTypeList, Elements, item ) {
    //  info( "businessType : " + item );  
    //}
    // ç”Ÿæˆå›¾è¡¨å…ƒç´ 
    traverse( years, Elements, year ) {
      debuginfo( "process year start : " + [String]year.YearNo() );
    //  debuginfo( "process year start : " + [String]year.YearNo() );
      if( byBusinessTypeOrByOrgCode = "面板基地" and groupBy = "å¹´" ) {
        // ç›®æ ‡
        traverse( placeOfProductionOfArrayList, Elements, placeOfProductionOfArray ) {
@@ -83,8 +87,8 @@
                                                 TimeStringAndScenarioName := [String]year.YearNo() + "å¹´-目标",
                                                 BusinessTypeOrPlaceOfProductionOfArray := placeOfProductionOfArray, 
                                                 Quantity := ifexpr( saleOrCapacity = "销售额",
                                                                     MappingAnnualBudget::GetSheetByYear( productCodeList, mpSync, year.YearNo() ),
                                                                     MappingCapacityAndSaleBudge::GetSheetByYear( productCodeList, mpSync, year.YearNo() ) )
                                                                     Global_MappingAnnualBudgetData::GetSaleByYear( productCodeList, otdTable, year.YearNo() ),
                                                                     Global_MappingForecast::GetQuantityByYear( productCodeList, otdTable, year.YearNo() ) )
                                                 );  
          // S&OP
          traverse( macroPlans, Elements, macroPlan ) {
@@ -92,7 +96,7 @@
                                                   TimeStringAndScenarioName := [String]year.YearNo() + "å¹´-" + macroPlan.ScenarioName(),
                                                   BusinessTypeOrPlaceOfProductionOfArray := placeOfProductionOfArray, 
                                                   Quantity := ifexpr( saleOrCapacity = "销售额",
                                                                       MappingCustomerOrder::GetNewSupplyByYear( productCodeList, macroPlan, year.YearNo() ),
                                                                       Forecast::GetFulfilledBalanceByYear( productCodeList, macroPlan, year.YearNo() ),
                                                                       Product_MP::GetNewSupplyByYear( productCodeList, macroPlan, year.YearNo() ) 
                                                                       )
                                                   ); 
@@ -107,8 +111,8 @@
                                                   TimeStringAndScenarioName := [String]year.YearNo() + "å¹´-" + ifexpr( halfNo = 1, "上", "下" ) + "半年-目标",
                                                   BusinessTypeOrPlaceOfProductionOfArray := placeOfProductionOfArray, 
                                                   Quantity := ifexpr( saleOrCapacity = "销售额",
                                                                       MappingAnnualBudget::GetSheetByHalfYear( productCodeList, mpSync, year.YearNo(), halfNo ),
                                                                       MappingCapacityAndSaleBudge::GetSheetByHalfYear( productCodeList, mpSync, year.YearNo(), halfNo ) )
                                                                       Global_MappingAnnualBudgetData::GetSaleByHalfYear( productCodeList, otdTable, year.YearNo(), halfNo ),
                                                                       Global_MappingForecast::GetQuantityByHalfYear( productCodeList, otdTable, year.YearNo(), halfNo ) )
                                                   );  
            // S&OP
            traverse( macroPlans, Elements, macroPlan ) {
@@ -116,7 +120,7 @@
                                                     TimeStringAndScenarioName := [String]year.YearNo() + "å¹´-" + ifexpr( halfNo = 1, "上", "下" ) + "半年-" + macroPlan.ScenarioName(),
                                                     BusinessTypeOrPlaceOfProductionOfArray := placeOfProductionOfArray, 
                                                     Quantity := ifexpr( saleOrCapacity = "销售额",
                                                                         MappingCustomerOrder::GetNewSupplyByHalfYear( productCodeList, macroPlan, year.YearNo(), halfNo ),
                                                                         Forecast::GetFulfilledBalanceByHalfYear( productCodeList, macroPlan, year.YearNo(), halfNo ),
                                                                         Product_MP::GetNewSupplyByHalfYear( productCodeList, macroPlan, year.YearNo(), halfNo )
                                                                         )
                                                     ); 
@@ -128,15 +132,12 @@
        for( seasonNo := 1; seasonNo <= 4; seasonNo := seasonNo + 1 ) {
          traverse( placeOfProductionOfArrayList, Elements, placeOfProductionOfArray ) {
            productCodeList := CapacityAndSaleBudgeChartRow::GetProductCodesByPlaceOfProductionOfArray( rows, placeOfProductionOfArray );
      //      info( "productCodeList : " + [String]productCodeList.Size() );
      //      info( "MappingCapacityAndSaleBudge::GetSheetBySeason : " + [String]MappingCapacityAndSaleBudge::GetSheetBySeason( productCodeList, mpSync, [Number]year, seasonNo ) );
      //      info( "seasonNo : " + [String]seasonNo );
            this.CapacityAndSaleBudgeChartElement( relnew, 
                                                   TimeStringAndScenarioName := [String]year.YearNo() + "å¹´-第" + [String]seasonNo + "季度-目标",
                                                   BusinessTypeOrPlaceOfProductionOfArray := placeOfProductionOfArray, 
                                                   Quantity := ifexpr( saleOrCapacity = "销售额",
                                                                       MappingAnnualBudget::GetSheetBySeason( productCodeList, mpSync, year.YearNo(), seasonNo ),
                                                                       MappingCapacityAndSaleBudge::GetSheetBySeason( productCodeList, mpSync, year.YearNo(), seasonNo ) )
                                                                       Global_MappingAnnualBudgetData::GetSaleBySeason( productCodeList, otdTable, year.YearNo(), seasonNo ),
                                                                       Global_MappingForecast::GetQuantityBySeason( productCodeList, otdTable, year.YearNo(), seasonNo ) )
                                                   );  
      //      info( "productCodeList : " + [String]productCodeList.Size() );
            // S&OP
@@ -145,7 +146,7 @@
                                                     TimeStringAndScenarioName := [String]year.YearNo() + "å¹´-第" + [String]seasonNo + "季度-" + macroPlan.ScenarioName(),
                                                     BusinessTypeOrPlaceOfProductionOfArray := placeOfProductionOfArray, 
                                                     Quantity := ifexpr( saleOrCapacity = "销售额",
                                                                         MappingCustomerOrder::GetNewSupplyBySeason( productCodeList, macroPlan, year.YearNo(), seasonNo ) ,
                                                                         Forecast::GetFulfilledBalanceBySeason( productCodeList, macroPlan, year.YearNo(), seasonNo ) ,
                                                                         Product_MP::GetNewSupplyBySeason( productCodeList, macroPlan, year.YearNo(), seasonNo )
                                                                         )
                                                     ); 
@@ -155,7 +156,7 @@
      }
      if ( byBusinessTypeOrByOrgCode = "面板基地" and groupBy = "月" ) {
        traverse( months, Elements, month ) {
          info( "process month start : " + [String]month.MonthNo() );
    //      info( "process month start : " + [String]month.MonthNo() );
          monthNoString := ifexpr( month.MonthNo() <= 9, "0" + [String]month.MonthNo(), [String]month.MonthNo() );
          traverse( placeOfProductionOfArrayList, Elements, placeOfProductionOfArray ) {
            productCodeList := CapacityAndSaleBudgeChartRow::GetProductCodesByPlaceOfProductionOfArray( rows, placeOfProductionOfArray );
@@ -163,8 +164,8 @@
                                                   TimeStringAndScenarioName := [String]year.YearNo() + "å¹´-第" + monthNoString + "月-目标",
                                                   BusinessTypeOrPlaceOfProductionOfArray := placeOfProductionOfArray, 
                                                   Quantity := ifexpr( saleOrCapacity = "销售额",
                                                                       MappingAnnualBudget::GetSheetByMonth( productCodeList, mpSync, year.YearNo(), month.MonthNo() ),
                                                                       MappingCapacityAndSaleBudge::GetSheetByMonth( productCodeList, mpSync, year.YearNo(), month.MonthNo() ) )
                                                                       Global_MappingAnnualBudgetData::GetSaleByMonth( productCodeList, otdTable, year.YearNo(), month.MonthNo() ),
                                                                       Global_MappingForecast::GetQuantityByMonth( productCodeList, otdTable, year.YearNo(), month.MonthNo() ) )
                                                   );  
            // S&OP
            traverse( macroPlans, Elements, macroPlan ) {
@@ -172,13 +173,13 @@
                                                     TimeStringAndScenarioName := [String]year.YearNo() + "å¹´-第" + monthNoString + "月-" + macroPlan.ScenarioName(),
                                                     BusinessTypeOrPlaceOfProductionOfArray := placeOfProductionOfArray, 
                                                     Quantity := ifexpr( saleOrCapacity = "销售额",
                                                                         MappingCustomerOrder::GetNewSupplyByMonth( productCodeList, macroPlan, year.YearNo(), month.MonthNo() ),
                                                                         Forecast::GetFulfilledBalanceByMonth( productCodeList, macroPlan, year.YearNo(), month.MonthNo() ),
                                                                         Product_MP::GetNewSupplyByMonth( productCodeList, macroPlan, year.YearNo(), month.MonthNo() ) 
                                                                         )
                                                     ); 
            }
          }
          info( "process month end : " + [String]month.MonthNo() );
    //      info( "process month end : " + [String]month.MonthNo() );
        }
      }
      if( byBusinessTypeOrByOrgCode = "事业部" and groupBy = "å¹´" ) {
@@ -189,8 +190,8 @@
                                                 TimeStringAndScenarioName := [String]year.YearNo() + "å¹´-目标",
                                                 BusinessTypeOrPlaceOfProductionOfArray := businessType, 
                                                 Quantity := ifexpr( saleOrCapacity = "销售额",
                                                                     MappingAnnualBudget::GetSheetByYear( productCodeList, mpSync, year.YearNo() ),
                                                                     MappingCapacityAndSaleBudge::GetSheetByYear( productCodeList, mpSync, year.YearNo() ) )
                                                                     Global_MappingAnnualBudgetData::GetSaleByYear( productCodeList, otdTable, year.YearNo() ),
                                                                     Global_MappingForecast::GetQuantityByYear( productCodeList, otdTable, year.YearNo() ) )
                                                 );  
          // S&OP
          traverse( macroPlans, Elements, macroPlan ) {
@@ -198,7 +199,7 @@
                                                   TimeStringAndScenarioName := [String]year.YearNo() + "å¹´-" + macroPlan.ScenarioName(),
                                                   BusinessTypeOrPlaceOfProductionOfArray := businessType, 
                                                   Quantity := ifexpr( saleOrCapacity = "销售额",
                                                                       MappingCustomerOrder::GetNewSupplyByYear( productCodeList, macroPlan, year.YearNo() ) ,
                                                                       Forecast::GetFulfilledBalanceByYear( productCodeList, macroPlan, year.YearNo() ) ,
                                                                       Product_MP::GetNewSupplyByYear( productCodeList, macroPlan, year.YearNo() )
                                                                       )
                                                   ); 
@@ -213,8 +214,8 @@
                                                   TimeStringAndScenarioName := [String]year.YearNo() + "å¹´-" + ifexpr( halfNo = 1, "上", "下" ) + "半年-目标",
                                                   BusinessTypeOrPlaceOfProductionOfArray := businessType, 
                                                   Quantity := ifexpr( saleOrCapacity = "销售额",
                                                                       MappingAnnualBudget::GetSheetByHalfYear( productCodeList, mpSync, year.YearNo(), halfNo ),
                                                                       MappingCapacityAndSaleBudge::GetSheetByHalfYear( productCodeList, mpSync, year.YearNo(), halfNo ) )
                                                                       Global_MappingAnnualBudgetData::GetSaleByHalfYear( productCodeList, otdTable, year.YearNo(), halfNo ),
                                                                       Global_MappingForecast::GetQuantityByHalfYear( productCodeList, otdTable, year.YearNo(), halfNo ) )
                                                   );  
            // S&OP
            traverse( macroPlans, Elements, macroPlan ) {
@@ -222,7 +223,7 @@
                                                     TimeStringAndScenarioName := [String]year.YearNo() + "å¹´-" + ifexpr( halfNo = 1, "上", "下" ) + "半年-" + macroPlan.ScenarioName(),
                                                     BusinessTypeOrPlaceOfProductionOfArray := businessType, 
                                                     Quantity := ifexpr( saleOrCapacity = "销售额",
                                                                         MappingCustomerOrder::GetNewSupplyByHalfYear( productCodeList, macroPlan, year.YearNo(), halfNo ) ,
                                                                         Forecast::GetFulfilledBalanceByHalfYear( productCodeList, macroPlan, year.YearNo(), halfNo ) ,
                                                                         Product_MP::GetNewSupplyByHalfYear( productCodeList, macroPlan, year.YearNo(), halfNo )
                                                                         )
                                                     ); 
@@ -232,15 +233,15 @@
      }
      if ( byBusinessTypeOrByOrgCode = "事业部" and groupBy = "季度" ) {
        for( seasonNo := 1; seasonNo <= 4; seasonNo := seasonNo + 1 ) {
          debuginfo( "process season start : " + [String]seasonNo );
    //      debuginfo( "process season start : " + [String]seasonNo );
          traverse( businessTypeList, Elements, businessType ) {
            productCodeList := CapacityAndSaleBudgeChartRow::GetProductCodesByBusinessType( rows, businessType );
            this.CapacityAndSaleBudgeChartElement( relnew, 
                                                   TimeStringAndScenarioName := [String]year.YearNo() + "å¹´-第" + [String]seasonNo + "季度-目标",
                                                   BusinessTypeOrPlaceOfProductionOfArray := businessType, 
                                                   Quantity := ifexpr( saleOrCapacity = "销售额",
                                                                       MappingAnnualBudget::GetSheetBySeason( productCodeList, mpSync, year.YearNo(), seasonNo ),
                                                                       MappingCapacityAndSaleBudge::GetSheetBySeason( productCodeList, mpSync, year.YearNo(), seasonNo ) )
                                                                       Global_MappingAnnualBudgetData::GetSaleBySeason( productCodeList, otdTable, year.YearNo(), seasonNo ),
                                                                       Global_MappingForecast::GetQuantityBySeason( productCodeList, otdTable, year.YearNo(), seasonNo ) )
                                                   );  
            // S&OP
            traverse( macroPlans, Elements, macroPlan ) {
@@ -248,18 +249,18 @@
                                                     TimeStringAndScenarioName := [String]year.YearNo() + "å¹´-第" + [String]seasonNo + "季度-" + macroPlan.ScenarioName(),
                                                     BusinessTypeOrPlaceOfProductionOfArray := businessType, 
                                                     Quantity := ifexpr( saleOrCapacity = "销售额",
                                                                         MappingCustomerOrder::GetNewSupplyBySeason( productCodeList, macroPlan, year.YearNo(), seasonNo ),
                                                                         Forecast::GetFulfilledBalanceBySeason( productCodeList, macroPlan, year.YearNo(), seasonNo ),
                                                                         Product_MP::GetNewSupplyBySeason( productCodeList, macroPlan, year.YearNo(), seasonNo ) 
                                                                         )
                                                     ); 
            }                    
          }
          info( "process season end : " + [String]seasonNo );
    //      info( "process season end : " + [String]seasonNo );
        }
      }
      if ( byBusinessTypeOrByOrgCode = "事业部" and groupBy = "月" ) {
        traverse( months, Elements, month ) {
          debuginfo( "process month start : " + [String]month.MonthNo() );
    //      debuginfo( "process month start : " + [String]month.MonthNo() );
          monthNoString := ifexpr( month.MonthNo() <= 9, "0" + [String]month.MonthNo(), [String]month.MonthNo() );
          traverse( businessTypeList, Elements, businessType ) {
            productCodeList := CapacityAndSaleBudgeChartRow::GetProductCodesByBusinessType( rows, businessType );
@@ -267,8 +268,8 @@
                                                   TimeStringAndScenarioName := [String]year.YearNo() + "å¹´-第" + monthNoString + "月-目标",
                                                   BusinessTypeOrPlaceOfProductionOfArray := businessType, 
                                                   Quantity := ifexpr( saleOrCapacity = "销售额",
                                                                       MappingCapacityAndSaleBudge::GetSheetByMonth( productCodeList, mpSync, year.YearNo(), month.MonthNo() ),
                                                                       MappingAnnualBudget::GetSheetByMonth( productCodeList, mpSync, year.YearNo(), month.MonthNo() ) )
                                                                       Global_MappingAnnualBudgetData::GetSaleByMonth( productCodeList, otdTable, year.YearNo(), month.MonthNo() ),
                                                                       Global_MappingForecast::GetQuantityByMonth( productCodeList, otdTable, year.YearNo(), month.MonthNo() ) )
                                                   );  
            // S&OP
            traverse( macroPlans, Elements, macroPlan ) {
@@ -276,16 +277,16 @@
                                                     TimeStringAndScenarioName := [String]year.YearNo() + "å¹´-第" + monthNoString + "月-" + macroPlan.ScenarioName(),
                                                     BusinessTypeOrPlaceOfProductionOfArray := businessType, 
                                                     Quantity := ifexpr( saleOrCapacity = "销售额",
                                                                         MappingCustomerOrder::GetNewSupplyByMonth( productCodeList, macroPlan, year.YearNo(), month.MonthNo() ) ,
                                                                         Forecast::GetFulfilledBalanceByMonth( productCodeList, macroPlan, year.YearNo(), month.MonthNo() ) ,
                                                                         Product_MP::GetNewSupplyByMonth( productCodeList, macroPlan, year.YearNo(), month.MonthNo() )
                                                                         )
                                                     ); 
            }            
          }
          debuginfo( "process month end : " + [String]month.MonthNo() );
    //      debuginfo( "process month end : " + [String]month.MonthNo() );
        }
      }
      debuginfo( "process year end : " + [String]year.YearNo() )
    //  debuginfo( "process year end : " + [String]year.YearNo() )
    }
    //info( "CapacityAndSaleBudgeChartElement : " + [String]selectset( this, CapacityAndSaleBudgeChartElement, item, true ).Size() );
    //traverse( this, CapacityAndSaleBudgeChartRow, row ) {

 _Main/BL/Type_GlobalDTOTable/Method_CapacityAndSaleBudgeChart.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_GlobalDTOTable/Method_CapacityAndSaleBudgeCompare.qbl

@@ -5,9 +5,7 @@
  CapacityAndSaleBudgeFilterItems items,
  CapacityAndSaleBudgeFilterYears years,
  CapacityAndSaleBudgeFilterMonths months,
  MPSync mpSync,
  GlobalOTDTable otdTable,
  MacroPlan mappingParent
  GlobalOTDTable otdTable
)
{
  Description: 'todo : mappingParent改为mpSync, random删了'
@@ -37,16 +35,16 @@
    this.CapacityAndSaleBudgeCompareItemRow( relflush );
    this.CapacityAndSaleBudgeCompareItemColumn( relflush );
    // ====汇总所有出现的产品====
    historyData := selectset( mpSync, MappingCapacityAndSaleBudge, item, true );
    historyData := selectset( this, Global_MappingAnnualBudgetData, item, true );
    debuginfo( "historyData : " + [String]historyData.Size() )
    traverse( historyData, Elements, one ) {
      productCode := one.ProductCode();
      MappingBOM::CreateTestData( mappingParent, "事业部" + [String](productCode.Length() mod 3), [String](productCode.Length() mod 4), productCode );
      boms := selectset( mappingParent, MappingBOM, bom, bom.ProductCode() = productCode );
      productCode := one.ProductID();
      Global_MappingOperationBOM::CreateTestData( otdTable, "事业部" + [String](productCode.Length() mod 3), "面板基地" + [String](productCode.Length() mod 4), productCode );
      boms := selectset( otdTable, Global_MappingOperationBOM, bom, bom.ProductCode() = productCode );
      if( boms.Size() > 0 ) {
        bom := boms.First();
        businessType := bom.BusinessType();
        placeOfProductionOfArray := one.PlaceOfProductionOfArray();
        placeOfProductionOfArray := bom.OrganCode();
        // ç›¸åŒé¢æ¿åŸºåœ°å’Œäº‹ä¸šéƒ¨çš„放一行
        row := CapacityAndSaleBudgeCompareItemRow::CreateIfNotExist( this, businessType, placeOfProductionOfArray );
        // è®°å½•æ¯è¡ŒåŒ…含哪些product
@@ -57,7 +55,7 @@
    }
    debuginfo( "CapacityAndSaleBudgeCompareItemRow : " + [String]selectset( this, CapacityAndSaleBudgeCompareItemRow, item, true ).Size() );
    // ====从左向右生成列头与内容====
    // äº‹ä¸šéƒ¨ï¼Œç»„织
    // äº‹ä¸šéƒ¨ï¼Œé¢æ¿åŸºåœ°
    debuginfo( "dealing businessType and placeOfProductionOfArray" )
    columnBusinessType := CapacityAndSaleBudgeCompareItemColumn::CreateIfNotExist( this, "事业部" );
    columnPlaceOfProductionOfArray := CapacityAndSaleBudgeCompareItemColumn::CreateIfNotExist( this, "面板基地" );
@@ -69,7 +67,7 @@
    }
    // é¢æ¿åˆ†é…é‡ - å¹´åº¦é¢„ç®— (sheets)
    // æ ¼å¼ï¼š é¢æ¿åˆ†é…é‡ - å¹´ - æœˆï¼ˆ1-12 & total） - å¹´åº¦é¢„ç®—/scenarioName
    info( "dealing é¢æ¿åˆ†é…é‡" )
    debuginfo( "dealing é¢æ¿åˆ†é…é‡" )
    if( CapacityAndSaleBudgeFilterItem::Contains( items, "面板分配量" ) ) {
      traverse( years, Elements, year ) {
        debuginfo( "面板分配量" + [String]year.YearNo() + "å¹´" );
@@ -78,14 +76,14 @@
        traverse( months, Elements, month ) {
          columnMonth := CapacityAndSaleBudgeCompareItemColumn::CreateIfNotExist( this, "面板分配量-" + [String]year.YearNo() + "å¹´-" + [String]month.MonthNo() + "月-年度预算" );
          traverse( this, CapacityAndSaleBudgeCompareItemRow, row ) {
            cellReal := MappingCapacityAndSaleBudge::GetSheetByMonth( row.GetProductCodes(), mpSync, DateTime::Now().Year(), month.MonthNo() );
            cellReal := Global_MappingForecast::GetQuantityByMonth( row.GetProductCodes(), this, DateTime::Now().Year(), month.MonthNo() );
            cell := columnMonth.CapacityAndSaleBudgeCompareItemCell( relnew, CellContent := [String]cellReal );
            cell.CapacityAndSaleBudgeCompareItemRow( relset, row );
          }
        }
        columnYear := CapacityAndSaleBudgeCompareItemColumn::CreateIfNotExist( this, "面板分配量-" + [String]year.YearNo() + "å¹´-total-年度预算" );
        traverse( this, CapacityAndSaleBudgeCompareItemRow, row ) {
          cellReal := MappingCapacityAndSaleBudge::GetSheetByYear( row.GetProductCodes(), mpSync, year.YearNo() );
          cellReal := Global_MappingForecast::GetQuantityByYear( row.GetProductCodes(), this, year.YearNo() );
          cell := columnYear.CapacityAndSaleBudgeCompareItemCell( relnew, CellContent := [String]cellReal );
          cell.CapacityAndSaleBudgeCompareItemRow( relset, row );
        }
@@ -121,14 +119,14 @@
        traverse( months, Elements, month ) {
          columnMonth := CapacityAndSaleBudgeCompareItemColumn::CreateIfNotExist( this, "对外销售额-" + [String]year.YearNo() + "å¹´-" + [String]month.MonthNo() + "月-年度预算" );
          traverse( this, CapacityAndSaleBudgeCompareItemRow, row ) {
            cellReal := MappingCapacityAndSaleBudge::GetSaleByMonth( row.GetProductCodes(), mpSync, year.YearNo(), month.MonthNo() );
            cellReal := Global_MappingAnnualBudgetData::GetSaleByMonth( row.GetProductCodes(), this, year.YearNo(), month.MonthNo() );
            cell := columnMonth.CapacityAndSaleBudgeCompareItemCell( relnew, CellContent := [String]cellReal );
            cell.CapacityAndSaleBudgeCompareItemRow( relset, row );
          }
        }
        columnYear := CapacityAndSaleBudgeCompareItemColumn::CreateIfNotExist( this, "对外销售额-" + [String]year.YearNo() + "å¹´-年度预算" );
        traverse( this, CapacityAndSaleBudgeCompareItemRow, row ) {
          cellReal := MappingCapacityAndSaleBudge::GetSaleByYear( row.GetProductCodes(), mpSync, year.YearNo() );
          cellReal := Global_MappingAnnualBudgetData::GetSaleByYear( row.GetProductCodes(), this, year.YearNo() );
          cell := columnYear.CapacityAndSaleBudgeCompareItemCell( relnew, CellContent := [String]cellReal );
          cell.CapacityAndSaleBudgeCompareItemRow( relset, row );
        }
@@ -138,7 +136,7 @@
          traverse( months, Elements, month ) {
            columnMonth := CapacityAndSaleBudgeCompareItemColumn::CreateIfNotExist( this, "对外销售额-" + [String]year.YearNo() + "å¹´-" + [String]month.MonthNo() + "月-" + macroPlan.ScenarioName() );
            traverse( this, CapacityAndSaleBudgeCompareItemRow, row ) {
              cellReal := MappingAnnualBudget::GetSaleByMonth( row.GetProductCodes(), mpSync, year.YearNo(), month.MonthNo() );
              cellReal := Forecast::GetFulfilledBalanceByMonth( row.GetProductCodes(), macroPlan, year.YearNo(), month.MonthNo() );
              cell := columnMonth.CapacityAndSaleBudgeCompareItemCell( relnew, CellContent := [String]cellReal );
              cell.CapacityAndSaleBudgeCompareItemRow( relset, row );
            }
@@ -146,7 +144,7 @@
          columnYear := CapacityAndSaleBudgeCompareItemColumn::CreateIfNotExist( this, "对外销售额-" + [String]year.YearNo() + "å¹´-total-" + macroPlan.ScenarioName() );
          traverse( this, CapacityAndSaleBudgeCompareItemRow, row ) {
            // QID 23
            cellReal := MappingAnnualBudget::GetSaleByYear( row.GetProductCodes(), mpSync, year.YearNo() );
            cellReal := Forecast::GetFulfilledBalanceByYear( row.GetProductCodes(), macroPlan, year.YearNo() );
            cell := columnYear.CapacityAndSaleBudgeCompareItemCell( relnew, CellContent := [String]cellReal );
            cell.CapacityAndSaleBudgeCompareItemRow( relset, row );
          }

 _Main/BL/Type_GlobalDTOTable/Method_InitTestData#12.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,39 @@
Quintiq file version 2.0
#parent: #root
Method InitTestData (
  MacroPlan macroPlan
)
{
  TextBody:
  [*
    // yypsybs Oct-7-2023 (created)
    productCodeList := selectuniquevalues( macroPlan, Product_MP, item, item.ID() );
    debuginfo( "productCodeList : " + [String]productCodeList.Size() );
    
    if( this.Global_MappingAnnualBudgetData( relsize ) = 0 ) {
      debuginfo( "create Global_MappingAnnualBudgetData test data" );
      id := 1;
      for( year := Date::ActualDate().Year() - 10; year <= Date::ActualDate().Year() + 5; year := year + 1 ) {
        for( i := 1; i <= productCodeList.Size(); i := i + 1 ) {
          productCode := productCodeList.Element( i - 1 );
          mappingAnnualBudget := this.Global_MappingAnnualBudgetData( relnew, 
                                                                      ID := [String]id,
                                                                      YearNo := [String]year,
                                                                      BusinessType := "事业部" + [String](productCode.Length() mod 3),
                                                                      ProductID := productCode);
          id := id + 1;
          for( month := 1; month <= 12; month := month + 1 ) {
            field := Reflection::FindAttribute( "Global_MappingAnnualBudgetData", "MonthlyModCapacity" + [String]month );
            field.Set( mappingAnnualBudget, [String]Real::Random( 20000.0, 30000.0 ) );
            field := Reflection::FindAttribute( "Global_MappingAnnualBudgetData", "MonthlySheetCapacity" + [String]month );
            field.Set( mappingAnnualBudget, [String]Real::Random( 20000.0, 30000.0 ) );
            field := Reflection::FindAttribute( "Global_MappingAnnualBudgetData", "MonthlySales" + [String]month );
            field.Set( mappingAnnualBudget, [String]Real::Random( 20000.0, 30000.0 ) );
          }
        }
      }
      result2 := selectset( this, Global_MappingAnnualBudgetData, item, true );
      debuginfo( "test MappingAnnualBudget size : " + [String]result2.Size() );
    }
  *]
}

 _Main/BL/Type_GlobalDTOTable/Method_InitTestData.qbl

@@ -7,7 +7,7 @@
    //this.MatAttrSettingAndPlanStrategy( relflush );
    
    // yypsybs Sep-8-2023 (created)
    info( "CapacityAndSaleBudge::InitTestData" )
    debuginfo( "CapacityAndSaleBudge::InitTestData" )
    mat1 := MatAttrSettingAndPlanStrategy::CreateIfNotExist( this, 1, "手机事业部", "MAT_1", "MAT_1", "TYPE_1", 233.0, "通用", "长周期" );
    MatAttrSettingAndPlanStrategyDetail::CreateIfNotExist( mat1, "PROD_1", 666.0, "PROD_1_DESC" );
    MatAttrSettingAndPlanStrategyDetail::CreateIfNotExist( mat1, "PROD_2", 777.0, "PROD_2_DESC" );

 _Main/BL/Type_GlobalDTOTable/Method_RefreshCapacityAndSaleBudgeFilter.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,26 @@
Quintiq file version 2.0
#parent: #root
Method RefreshCapacityAndSaleBudgeFilter (
  Boolean deleteBeforeCreate
)
{
  TextBody:
  [*
    if( deleteBeforeCreate ) {
      this.CapacityAndSaleBudgeFilterBusinessType( relflush );
      this.CapacityAndSaleBudgeFilterPlaceOfProductionOfArray( relflush );  
    }
    // yypsybs Sep-21-2023 (created)
    debuginfo( "=====RefreshCapacityAndSaleBudgeFilter====" );
    businessTypes := selectuniquevalues( this, Global_MappingAnnualBudgetData, item, item.BusinessType() );
    debuginfo( [String]businessTypes.Size() );
    traverse( businessTypes, Elements, businessType ) {
      CapacityAndSaleBudgeFilterBusinessType::CreateIfNotExist( this, businessType );
    }
    placeOfProductionOfArrays := selectuniquevalues( this, Global_MappingAnnualBudgetData, item, item.OrgCodeFromBom() );
    debuginfo( [String]placeOfProductionOfArrays.Size() );
    traverse( placeOfProductionOfArrays, Elements, placeOfProductionOfArray ) {
      CapacityAndSaleBudgeFilterPlaceOfProductionOfArray::CreateIfNotExist( this, placeOfProductionOfArray );
    }
  *]
}

 _Main/BL/Type_GlobalDTOTable/StaticMethod_SynchronizationAllMappingBrokerAndAPI.qbl

@@ -27,6 +27,8 @@
    globalOTDTable.Global_MappingCustomOrder( relflush );
    globalOTDTable.Global_MappingDOI_DSI( relflush );
    globalOTDTable.Global_MappingCustomerGrade( relflush );
    // å¹´åº¦äº§é”€é¢„算中间表
    globalOTDTable.Global_MappingAnnualBudgetData( relflush );
    
    globalOTDTable.GlobalOTDTable_UnitOfMeasure_MP().AsyncExecute();
    globalOTDTable.GlobalOTDTable_SalesSegment_MP().AsyncExecute();
@@ -48,5 +50,9 @@
    globalOTDTable.GlobalOTDTable_CustomOrder().AsyncExecute();
    globalOTDTable.GlobalOTDTable_DOI_DSI().AsyncExecute();
    globalOTDTable.GlobalOTDTable_CustomerGrade().AsyncExecute();
    // å¹´åº¦äº§é”€é¢„算中间表
    globalOTDTable.GlobalOTDTable_AnnualBudgetData().AsyncExecute();
    // æ ¹æ®Global_MappingOperationBOM刷GlobalOTDTable_AnnualBudgetData的OrgCodeFromBom
    Global_MappingAnnualBudgetData::SetOrgCodeFromForecast( globalOTDTable );
  *]
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_BusinessSort.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute BusinessSort
{
  #keys: '3[414384.0.936222715][414384.0.936222714][414384.0.936222716]'
  Description: '业务分类'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_BusinessType.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute BusinessType
{
  #keys: '3[414384.0.936222709][414384.0.936222708][414384.0.936222710]'
  Description: '事业部'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_CapacityEquivalent.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute CapacityEquivalent
{
  #keys: '3[414384.0.936222742][414384.0.936222741][414384.0.936222743]'
  Description: '产能当量'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_CutsNumber.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute CutsNumber
{
  #keys: '3[414384.0.936222739][414384.0.936222738][414384.0.936222740]'
  Description: '切割数'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_DisplayTechSort.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute DisplayTechSort
{
  #keys: '3[414384.0.936222712][414384.0.936222711][414384.0.936222713]'
  Description: '显示技术分类'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_ID.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,9 @@
Quintiq file version 2.0
#parent: #root
Attribute ID
{
  #keys: '3[414384.0.936222703][414384.0.936222702][414384.0.936222704]'
  Description: '序号'
  IsReadOnly: true
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MaskNumber.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MaskNumber
{
  #keys: '3[414384.0.936222745][414384.0.936222744][414384.0.936222746]'
  Description: 'Mask数'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlyModCapacity1.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlyModCapacity1
{
  #keys: '3[414384.0.936222748][414384.0.936222747][414384.0.936222749]'
  Description: '月度模组产能1月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlyModCapacity10.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlyModCapacity10
{
  #keys: '3[414384.0.936222775][414384.0.936222774][414384.0.936222776]'
  Description: '月度模组产能10月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlyModCapacity11.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlyModCapacity11
{
  #keys: '3[414384.0.936222778][414384.0.936222777][414384.0.936222779]'
  Description: '月度模组产能11月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlyModCapacity12.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlyModCapacity12
{
  #keys: '3[414384.0.936222781][414384.0.936222780][414384.0.936222782]'
  Description: '月度模组产能12月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlyModCapacity2.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlyModCapacity2
{
  #keys: '3[414384.0.936222751][414384.0.936222750][414384.0.936222752]'
  Description: '月度模组产能2月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlyModCapacity3.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlyModCapacity3
{
  #keys: '3[414384.0.936222754][414384.0.936222753][414384.0.936222755]'
  Description: '月度模组产能3月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlyModCapacity4.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlyModCapacity4
{
  #keys: '3[414384.0.936222757][414384.0.936222756][414384.0.936222758]'
  Description: '月度模组产能4月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlyModCapacity5.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlyModCapacity5
{
  #keys: '3[414384.0.936222760][414384.0.936222759][414384.0.936222761]'
  Description: '月度模组产能5月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlyModCapacity6.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlyModCapacity6
{
  #keys: '3[414384.0.936222763][414384.0.936222762][414384.0.936222764]'
  Description: '月度模组产能6月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlyModCapacity7.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlyModCapacity7
{
  #keys: '3[414384.0.936222766][414384.0.936222765][414384.0.936222767]'
  Description: '月度模组产能7月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlyModCapacity8.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlyModCapacity8
{
  #keys: '3[414384.0.936222769][414384.0.936222768][414384.0.936222770]'
  Description: '月度模组产能8月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlyModCapacity9.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlyModCapacity9
{
  #keys: '3[414384.0.936222772][414384.0.936222771][414384.0.936222773]'
  Description: '月度模组产能9月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlySales1.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlySales1
{
  #keys: '3[414384.0.936222820][414384.0.936222819][414384.0.936222821]'
  Description: '月度销售额1月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlySales10.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlySales10
{
  #keys: '3[414384.0.936222847][414384.0.936222846][414384.0.936222848]'
  Description: '月度销售额10月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlySales11.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlySales11
{
  #keys: '3[414384.0.936222850][414384.0.936222849][414384.0.936222851]'
  Description: '月度销售额11月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlySales12.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlySales12
{
  #keys: '3[414384.0.936222853][414384.0.936222852][414384.0.936222854]'
  Description: '月度销售额12月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlySales2.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlySales2
{
  #keys: '3[414384.0.936222823][414384.0.936222822][414384.0.936222824]'
  Description: '月度销售额2月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlySales3.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlySales3
{
  #keys: '3[414384.0.936222826][414384.0.936222825][414384.0.936222827]'
  Description: '月度销售额3月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlySales4.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlySales4
{
  #keys: '3[414384.0.936222829][414384.0.936222828][414384.0.936222830]'
  Description: '月度销售额4月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlySales5.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlySales5
{
  #keys: '3[414384.0.936222832][414384.0.936222831][414384.0.936222833]'
  Description: '月度销售额5月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlySales6.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlySales6
{
  #keys: '3[414384.0.936222835][414384.0.936222834][414384.0.936222836]'
  Description: '月度销售额6月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlySales7.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlySales7
{
  #keys: '3[414384.0.936222838][414384.0.936222837][414384.0.936222839]'
  Description: '月度销售额7月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlySales8.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlySales8
{
  #keys: '3[414384.0.936222841][414384.0.936222840][414384.0.936222842]'
  Description: '月度销售额8月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlySales9.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlySales9
{
  #keys: '3[414384.0.936222844][414384.0.936222843][414384.0.936222845]'
  Description: '月度销售额9月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlySheetCapacity1.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlySheetCapacity1
{
  #keys: '3[414384.0.936222784][414384.0.936222783][414384.0.936222785]'
  Description: '月度实数大张产能1月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlySheetCapacity10.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlySheetCapacity10
{
  #keys: '3[414384.0.936222811][414384.0.936222810][414384.0.936222812]'
  Description: '月度实数大张产能10月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlySheetCapacity11.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlySheetCapacity11
{
  #keys: '3[414384.0.936222814][414384.0.936222813][414384.0.936222815]'
  Description: '月度实数大张产能11月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlySheetCapacity12.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlySheetCapacity12
{
  #keys: '3[414384.0.936222817][414384.0.936222816][414384.0.936222818]'
  Description: '月度实数大张产能12月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlySheetCapacity2.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlySheetCapacity2
{
  #keys: '3[414384.0.936222787][414384.0.936222786][414384.0.936222788]'
  Description: '月度实数大张产能2月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlySheetCapacity3.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlySheetCapacity3
{
  #keys: '3[414384.0.936222790][414384.0.936222789][414384.0.936222791]'
  Description: '月度实数大张产能3月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlySheetCapacity4.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlySheetCapacity4
{
  #keys: '3[414384.0.936222793][414384.0.936222792][414384.0.936222794]'
  Description: '月度实数大张产能4月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlySheetCapacity5.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlySheetCapacity5
{
  #keys: '3[414384.0.936222796][414384.0.936222795][414384.0.936222797]'
  Description: '月度实数大张产能5月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlySheetCapacity6.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlySheetCapacity6
{
  #keys: '3[414384.0.936222799][414384.0.936222798][414384.0.936222800]'
  Description: '月度实数大张产能6月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlySheetCapacity7.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlySheetCapacity7
{
  #keys: '3[414384.0.936222802][414384.0.936222801][414384.0.936222803]'
  Description: '月度实数大张产能7月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlySheetCapacity8.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlySheetCapacity8
{
  #keys: '3[414384.0.936222805][414384.0.936222804][414384.0.936222806]'
  Description: '月度实数大张产能8月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_MonthlySheetCapacity9.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MonthlySheetCapacity9
{
  #keys: '3[414384.0.936222808][414384.0.936222807][414384.0.936222809]'
  Description: '月度实数大张产能9月'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_OrgCodeFromBom.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute OrgCodeFromBom
{
  #keys: '3[414384.0.936171531][414384.0.936171530][414384.0.936171532]'
  Description: '用料号到Global_MappingForecast查的orgCode'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_OrganCode.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute OrganCode
{
  #keys: '3[414384.0.936222724][414384.0.936222723][414384.0.936222725]'
  Description: '组织编码'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_OrganName.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute OrganName
{
  #keys: '3[414384.0.936222727][414384.0.936222726][414384.0.936222728]'
  Description: '组织名称'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_PlantName.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute PlantName
{
  #keys: '3[414384.0.936222730][414384.0.936222729][414384.0.936222731]'
  Description: '工厂名称'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_ProductID.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute ProductID
{
  #keys: '3[414384.0.936222721][414384.0.936222720][414384.0.936222722]'
  Description: '产品编码'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_ProductLineAndSpecification.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute ProductLineAndSpecification
{
  #keys: '3[414384.0.936222718][414384.0.936222717][414384.0.936222719]'
  Description: '产品线/产品规格'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_ResolutionRatio.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute ResolutionRatio
{
  #keys: '3[414384.0.936222733][414384.0.936222732][414384.0.936222734]'
  Description: '分辨率'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_ShippingForm.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute ShippingForm
{
  #keys: '3[414384.0.936222736][414384.0.936222735][414384.0.936222737]'
  Description: '出货形态'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Attribute_YearNo.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute YearNo
{
  #keys: '3[414384.0.936222706][414384.0.936222705][414384.0.936222707]'
  Description: '年份'
  ValueType: String
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Method_GetCapacityInPCSInYear.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,15 @@
Quintiq file version 2.0
#parent: #root
Method GetCapacityInPCSInYear () as Real
{
  TextBody:
  [*
    // yypsybs Sep-18-2023 (created)
    result := 0.0;
    for( i := 1; i <= 12; i := i + 1 ) {
      field := Reflection::FindAttribute( "Global_MappingAnnualBudgetData", "MonthlyModCapacity" + [String]i );
      result := result + [Real]field.GetString( this );
    }
    return result;
  *]
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Method_GetCapacityInSheetInHalfYear.qbl

ÎļþÃû´Ó _Main/BL/Type_MappingAnnualBudget/Method_GetCapacityInSheetInHalfYear.qbl ÐÞ¸Ä
@@ -11,8 +11,8 @@
    fromMonth := 1 + ( halfNo - 1 ) * 6;
    toMonth := 6 + ( halfNo - 1 ) * 6;
    for( i := fromMonth; i <= toMonth; i := i + 1 ) {
      field := Reflection::FindAttribute( "MappingAnnualBudget", "MonthlySheetCapacity" + [String]i );
      result := result + field.GetReal( this );
      field := Reflection::FindAttribute( "Global_MappingAnnualBudgetData", "MonthlySheetCapacity" + [String]i );
      result := result + [Real]field.GetString( this );
    }
    return result;
  *]

 _Main/BL/Type_Global_MappingAnnualBudgetData/Method_GetCapacityInSheetInSeason.qbl

ÎļþÃû´Ó _Main/BL/Type_MappingAnnualBudget/Method_GetCapacityInSheetInSeason.qbl ÐÞ¸Ä
@@ -11,8 +11,8 @@
    fromMonth := 1 + ( seasonNo - 1 ) * 3;
    toMonth := 3 + ( seasonNo - 1 ) * 3;
    for( i := fromMonth; i <= toMonth; i := i + 1 ) {
      field := Reflection::FindAttribute( "MappingAnnualBudget", "MonthlySheetCapacity" + [String]i );
      result := result + field.GetReal( this );
      field := Reflection::FindAttribute( "Global_MappingAnnualBudgetData", "MonthlySheetCapacity" + [String]i );
      result := result + [Real]field.GetString( this );
    }
    return result;
  *]

 _Main/BL/Type_Global_MappingAnnualBudgetData/Method_GetCapacityInSheetInYear.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,15 @@
Quintiq file version 2.0
#parent: #root
Method GetCapacityInSheetInYear () as Real
{
  TextBody:
  [*
    // yypsybs Sep-18-2023 (created)
    result := 0.0;
    for( i := 1; i <= 12; i := i + 1 ) {
      field := Reflection::FindAttribute( "Global_MappingAnnualBudgetData", "MonthlySheetCapacity" + [String]i );
      result := result + [Real]field.GetString( this );
    }
    return result;
  *]
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/Method_GetSaleAmountInHalfYear.qbl

copy from _Main/BL/Type_MappingAnnualBudget/Method_GetCapacityInSheetInHalfYear.qbl
copy to _Main/BL/Type_Global_MappingAnnualBudgetData/Method_GetSaleAmountInHalfYear.qbl
Îļþ´Ó _Main/BL/Type_MappingAnnualBudget/Method_GetCapacityInSheetInHalfYear.qbl ¸´ÖÆ
@@ -1,6 +1,6 @@
Quintiq file version 2.0
#parent: #root
Method GetCapacityInSheetInHalfYear (
Method GetSaleAmountInHalfYear (
  Number halfNo
) as Real
{
@@ -11,8 +11,8 @@
    fromMonth := 1 + ( halfNo - 1 ) * 6;
    toMonth := 6 + ( halfNo - 1 ) * 6;
    for( i := fromMonth; i <= toMonth; i := i + 1 ) {
      field := Reflection::FindAttribute( "MappingAnnualBudget", "MonthlySheetCapacity" + [String]i );
      result := result + field.GetReal( this );
      field := Reflection::FindAttribute( "Global_MappingAnnualBudgetData", "MonthlySales" + [String]i );
      result := result + [Real]field.GetString( this );
    }
    return result;
  *]

 _Main/BL/Type_Global_MappingAnnualBudgetData/Method_GetSaleAmountInSeason#000.qbl

copy from _Main/BL/Type_MappingAnnualBudget/Method_GetCapacityInSheetInSeason.qbl
copy to "_Main/BL/Type_Global_MappingAnnualBudgetData/Method_GetSaleAmountInSeason\043000.qbl"
Îļþ´Ó _Main/BL/Type_MappingAnnualBudget/Method_GetCapacityInSheetInSeason.qbl ¸´ÖÆ
@@ -1,6 +1,6 @@
Quintiq file version 2.0
#parent: #root
Method GetCapacityInSheetInSeason (
Method GetSaleAmountInSeason (
  Number seasonNo
) as Real
{
@@ -11,8 +11,8 @@
    fromMonth := 1 + ( seasonNo - 1 ) * 3;
    toMonth := 3 + ( seasonNo - 1 ) * 3;
    for( i := fromMonth; i <= toMonth; i := i + 1 ) {
      field := Reflection::FindAttribute( "MappingAnnualBudget", "MonthlySheetCapacity" + [String]i );
      result := result + field.GetReal( this );
      field := Reflection::FindAttribute( "Global_MappingAnnualBudgetData", "MonthlySales" + [String]i );
      result := result + [Real]field.GetString( this );
    }
    return result;
  *]

 _Main/BL/Type_Global_MappingAnnualBudgetData/Method_GetSaleAmountInYear.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,15 @@
Quintiq file version 2.0
#parent: #root
Method GetSaleAmountInYear () as Real
{
  TextBody:
  [*
    // yypsybs Sep-18-2023 (created)
    result := 0.0;
    for( i := 1; i <= 12; i := i + 1 ) {
      field := Reflection::FindAttribute( "Global_MappingAnnualBudgetData", "MonthlySales" + [String]i );
      result := result + [Real]field.GetString( this );
    }
    return result;
  *]
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/StaticMethod_Export#666.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,507 @@
Quintiq file version 2.0
#parent: #root
StaticMethod Export (
  Global_MappingAnnualBudgetDatas toExportList
) as String
{
  TextBody:
  [*
    // generate by generate_export_method.py
    xmlTemplate := '<?xml version="1.0" encoding="UTF-16"?>
    <table>
      <name>Global_MappingAnnualBudgetData</name>
    ';
    
    
    debuginfo( "export start" );
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>年份</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column YearNo" );
      yearNo := toExportItem.YearNo();
      cellStr := '<cell value="' + yearNo + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>事业部</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column BusinessType" );
      businessType := toExportItem.BusinessType();
      cellStr := '<cell value="' + businessType + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>显示技术分类</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column DisplayTechSort" );
      displayTechSort := toExportItem.DisplayTechSort();
      cellStr := '<cell value="' + displayTechSort + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>业务分类</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column BusinessSort" );
      businessSort := toExportItem.BusinessSort();
      cellStr := '<cell value="' + businessSort + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>产品线/产品规格</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column ProductLineAndSpecification" );
      productLineAndSpecification := toExportItem.ProductLineAndSpecification();
      cellStr := '<cell value="' + productLineAndSpecification + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>产品编码</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column ProductID" );
      productID := toExportItem.ProductID();
      cellStr := '<cell value="' + productID + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>OrgCodeFromBom</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column OrgCodeFromBom" );
      orgCodeFromBom := toExportItem.OrgCodeFromBom();
      cellStr := '<cell value="' + orgCodeFromBom + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>分辨率</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column ResolutionRatio" );
      resolutionRatio := toExportItem.ResolutionRatio();
      cellStr := '<cell value="' + resolutionRatio + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>出货形态</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column ShippingForm" );
      shippingForm := toExportItem.ShippingForm();
      cellStr := '<cell value="' + shippingForm + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>切割数</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column CutsNumber" );
      cutsNumber := toExportItem.CutsNumber();
      cellStr := '<cell value="' + cutsNumber + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>产能当量</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column CapacityEquivalent" );
      capacityEquivalent := toExportItem.CapacityEquivalent();
      cellStr := '<cell value="' + capacityEquivalent + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>Mask数</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MaskNumber" );
      maskNumber := toExportItem.MaskNumber();
      cellStr := '<cell value="' + maskNumber + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度模组产能1月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlyModCapacity1" );
      monthlyModCapacity1 := toExportItem.MonthlyModCapacity1();
      cellStr := '<cell value="' + monthlyModCapacity1 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度模组产能2月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlyModCapacity2" );
      monthlyModCapacity2 := toExportItem.MonthlyModCapacity2();
      cellStr := '<cell value="' + monthlyModCapacity2 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度模组产能3月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlyModCapacity3" );
      monthlyModCapacity3 := toExportItem.MonthlyModCapacity3();
      cellStr := '<cell value="' + monthlyModCapacity3 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度模组产能4月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlyModCapacity4" );
      monthlyModCapacity4 := toExportItem.MonthlyModCapacity4();
      cellStr := '<cell value="' + monthlyModCapacity4 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度模组产能5月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlyModCapacity5" );
      monthlyModCapacity5 := toExportItem.MonthlyModCapacity5();
      cellStr := '<cell value="' + monthlyModCapacity5 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度模组产能6月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlyModCapacity6" );
      monthlyModCapacity6 := toExportItem.MonthlyModCapacity6();
      cellStr := '<cell value="' + monthlyModCapacity6 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度模组产能7月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlyModCapacity7" );
      monthlyModCapacity7 := toExportItem.MonthlyModCapacity7();
      cellStr := '<cell value="' + monthlyModCapacity7 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度模组产能8月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlyModCapacity8" );
      monthlyModCapacity8 := toExportItem.MonthlyModCapacity8();
      cellStr := '<cell value="' + monthlyModCapacity8 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度模组产能9月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlyModCapacity9" );
      monthlyModCapacity9 := toExportItem.MonthlyModCapacity9();
      cellStr := '<cell value="' + monthlyModCapacity9 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度模组产能10月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlyModCapacity10" );
      monthlyModCapacity10 := toExportItem.MonthlyModCapacity10();
      cellStr := '<cell value="' + monthlyModCapacity10 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度模组产能11月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlyModCapacity11" );
      monthlyModCapacity11 := toExportItem.MonthlyModCapacity11();
      cellStr := '<cell value="' + monthlyModCapacity11 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度模组产能12月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlyModCapacity12" );
      monthlyModCapacity12 := toExportItem.MonthlyModCapacity12();
      cellStr := '<cell value="' + monthlyModCapacity12 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度实数大张产能1月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlySheetCapacity1" );
      monthlySheetCapacity1 := toExportItem.MonthlySheetCapacity1();
      cellStr := '<cell value="' + monthlySheetCapacity1 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度实数大张产能2月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlySheetCapacity2" );
      monthlySheetCapacity2 := toExportItem.MonthlySheetCapacity2();
      cellStr := '<cell value="' + monthlySheetCapacity2 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度实数大张产能3月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlySheetCapacity3" );
      monthlySheetCapacity3 := toExportItem.MonthlySheetCapacity3();
      cellStr := '<cell value="' + monthlySheetCapacity3 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度实数大张产能4月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlySheetCapacity4" );
      monthlySheetCapacity4 := toExportItem.MonthlySheetCapacity4();
      cellStr := '<cell value="' + monthlySheetCapacity4 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度实数大张产能5月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlySheetCapacity5" );
      monthlySheetCapacity5 := toExportItem.MonthlySheetCapacity5();
      cellStr := '<cell value="' + monthlySheetCapacity5 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度实数大张产能6月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlySheetCapacity6" );
      monthlySheetCapacity6 := toExportItem.MonthlySheetCapacity6();
      cellStr := '<cell value="' + monthlySheetCapacity6 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度实数大张产能7月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlySheetCapacity7" );
      monthlySheetCapacity7 := toExportItem.MonthlySheetCapacity7();
      cellStr := '<cell value="' + monthlySheetCapacity7 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度实数大张产能8月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlySheetCapacity8" );
      monthlySheetCapacity8 := toExportItem.MonthlySheetCapacity8();
      cellStr := '<cell value="' + monthlySheetCapacity8 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度实数大张产能9月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlySheetCapacity9" );
      monthlySheetCapacity9 := toExportItem.MonthlySheetCapacity9();
      cellStr := '<cell value="' + monthlySheetCapacity9 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度实数大张产能10月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlySheetCapacity10" );
      monthlySheetCapacity10 := toExportItem.MonthlySheetCapacity10();
      cellStr := '<cell value="' + monthlySheetCapacity10 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度实数大张产能11月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlySheetCapacity11" );
      monthlySheetCapacity11 := toExportItem.MonthlySheetCapacity11();
      cellStr := '<cell value="' + monthlySheetCapacity11 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度实数大张产能12月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlySheetCapacity12" );
      monthlySheetCapacity12 := toExportItem.MonthlySheetCapacity12();
      cellStr := '<cell value="' + monthlySheetCapacity12 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度销售额1月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlySales1" );
      monthlySales1 := toExportItem.MonthlySales1();
      cellStr := '<cell value="' + monthlySales1 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度销售额2月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlySales2" );
      monthlySales2 := toExportItem.MonthlySales2();
      cellStr := '<cell value="' + monthlySales2 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度销售额3月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlySales3" );
      monthlySales3 := toExportItem.MonthlySales3();
      cellStr := '<cell value="' + monthlySales3 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度销售额4月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlySales4" );
      monthlySales4 := toExportItem.MonthlySales4();
      cellStr := '<cell value="' + monthlySales4 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度销售额5月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlySales5" );
      monthlySales5 := toExportItem.MonthlySales5();
      cellStr := '<cell value="' + monthlySales5 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度销售额6月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlySales6" );
      monthlySales6 := toExportItem.MonthlySales6();
      cellStr := '<cell value="' + monthlySales6 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度销售额7月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlySales7" );
      monthlySales7 := toExportItem.MonthlySales7();
      cellStr := '<cell value="' + monthlySales7 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度销售额8月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlySales8" );
      monthlySales8 := toExportItem.MonthlySales8();
      cellStr := '<cell value="' + monthlySales8 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度销售额9月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlySales9" );
      monthlySales9 := toExportItem.MonthlySales9();
      cellStr := '<cell value="' + monthlySales9 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度销售额10月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlySales10" );
      monthlySales10 := toExportItem.MonthlySales10();
      cellStr := '<cell value="' + monthlySales10 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度销售额11月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlySales11" );
      monthlySales11 := toExportItem.MonthlySales11();
      cellStr := '<cell value="' + monthlySales11 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    columnStr := "<column><name>月度销售额12月</name><type>String</type>";
    traverse( toExportList, Elements, toExportItem ) {
      debuginfo( "export column MonthlySales12" );
      monthlySales12 := toExportItem.MonthlySales12();
      cellStr := '<cell value="' + monthlySales12 + '"/>';
      columnStr := columnStr + cellStr;
    }
    columnStr := columnStr + "</column>";
    xmlTemplate := xmlTemplate + columnStr;
    //---------------------------------------------------------------------------------------------
    xmlTemplate := xmlTemplate + "</table>";
    tableHandle := TableHandle::ImportXML( BinaryValue::Construct( xmlTemplate ) );
    XLS::SaveTable( tableHandle, OS::TempPath() + "Global_MappingAnnualBudgetData.xlsx" );
    file := OSFile::Construct();
    file.Open( OS::TempPath() + "Global_MappingAnnualBudgetData.xlsx", "Read", true );
    data := file.ReadBinary()
    debuginfo( "export end" );
    return data.AsBase64EncodedString();
  *]
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/StaticMethod_Export.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,13 @@
Quintiq file version 2.0
#parent: #root
StaticMethod Export (
  GlobalOTDTable parent
) as String
{
  TextBody:
  [*
    // generate by generate_export_method.py
    toExportList := selectset( parent, Global_MappingAnnualBudgetData, item, true );
    return Global_MappingAnnualBudgetData::Export( toExportList );
  *]
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/StaticMethod_GetSaleByHalfYear.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,21 @@
Quintiq file version 2.0
#parent: #root
StaticMethod GetSaleByHalfYear (
  Strings productNo,
  GlobalOTDTable parent,
  Number yearNo,
  Number halfNo
) as Real
{
  Description: '产能 - å®žæ•°å¤§å¼ '
  TextBody:
  [*
    // yypsybs Sep-18-2023 (created)
    result := sum( parent, 
                   Global_MappingAnnualBudgetData, 
                   item, 
                   item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1,
                   item.GetSaleAmountInHalfYear( halfNo ) );
    return result;
  *]
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/StaticMethod_GetSaleByMonth.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,22 @@
Quintiq file version 2.0
#parent: #root
StaticMethod GetSaleByMonth (
  Strings productNo,
  GlobalOTDTable parent,
  Number yearNo,
  Number monthNo
) as Real
{
  Description: '销售额（W）'
  TextBody:
  [*
    // yypsybs Sep-18-2023 (created)
    field := Reflection::FindAttribute( "Global_MappingAnnualBudgetData", "MonthlySales" + [String]monthNo );
    value := sum( parent, 
                  Global_MappingAnnualBudgetData, 
                  item, 
                  item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1,
                  [Real]field.GetString( item ) );
    return value;
  *]
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/StaticMethod_GetSaleBySeason.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,21 @@
Quintiq file version 2.0
#parent: #root
StaticMethod GetSaleBySeason (
  Strings productNo,
  GlobalOTDTable parent,
  Number yearNo,
  Number seasonNo
) as Real
{
  Description: '产能 - å®žæ•°å¤§å¼ '
  TextBody:
  [*
    // yypsybs Sep-18-2023 (created)
    result := sum( parent, 
                   Global_MappingAnnualBudgetData, 
                   item, 
                   item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1,
                   item.GetSaleAmountInSeason( seasonNo ) );
    return result;
  *]
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/StaticMethod_GetSaleByYear.qbl

ÎļþÃû´Ó _Main/BL/Type_MappingAnnualBudget/StaticMethod_GetSaleByYear.qbl ÐÞ¸Ä
@@ -2,7 +2,7 @@
#parent: #root
StaticMethod GetSaleByYear (
  Strings productNo,
  MPSync parent,
  GlobalOTDTable parent,
  Number yearNo
) as Real
{
@@ -11,9 +11,9 @@
  [*
    // yypsybs Sep-18-2023 (created)
    result := sum( parent, 
                   MappingAnnualBudget, 
                   Global_MappingAnnualBudgetData, 
                   item, 
                   item.YearNo() = yearNo and productNo.Find( item.ProductId() ) > -1,
                   item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1,
                   item.GetSaleAmountInYear() );
    return result;
  *]

 _Main/BL/Type_Global_MappingAnnualBudgetData/StaticMethod_GetSheetByHalfYear.qbl

ÎļþÃû´Ó _Main/BL/Type_MappingAnnualBudget/StaticMethod_GetSheetByHalfYear.qbl ÐÞ¸Ä
@@ -2,7 +2,7 @@
#parent: #root
StaticMethod GetSheetByHalfYear (
  Strings productNo,
  MPSync parent,
  GlobalOTDTable parent,
  Number yearNo,
  Number halfNo
) as Real
@@ -12,9 +12,9 @@
  [*
    // yypsybs Sep-18-2023 (created)
    result := sum( parent, 
                   MappingAnnualBudget, 
                   Global_MappingAnnualBudgetData, 
                   item, 
                   item.YearNo() = yearNo and productNo.Find( item.ProductId() ) > -1,
                   item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1,
                   item.GetCapacityInSheetInHalfYear( halfNo ) );
    return result;
  *]

 _Main/BL/Type_Global_MappingAnnualBudgetData/StaticMethod_GetSheetByMonth.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,22 @@
Quintiq file version 2.0
#parent: #root
StaticMethod GetSheetByMonth (
  Strings productNo,
  GlobalOTDTable parent,
  Number yearNo,
  Number monthNo
) as Real
{
  Description: '产能-实数大张'
  TextBody:
  [*
    // yypsybs Sep-18-2023 (created)
    field := Reflection::FindAttribute( "Global_MappingAnnualBudgetData", "MonthlySheetCapacity" + [String]monthNo );
    value := sum( parent, 
                  Global_MappingAnnualBudgetData, 
                  item, 
                  item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1,
                  [Real]field.GetString( item ) );
    return value;
  *]
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/StaticMethod_GetSheetBySeason.qbl

ÎļþÃû´Ó _Main/BL/Type_MappingAnnualBudget/StaticMethod_GetSheetBySeason.qbl ÐÞ¸Ä
@@ -2,7 +2,7 @@
#parent: #root
StaticMethod GetSheetBySeason (
  Strings productNo,
  MPSync parent,
  GlobalOTDTable parent,
  Number yearNo,
  Number seasonNo
) as Real
@@ -12,9 +12,9 @@
  [*
    // yypsybs Sep-18-2023 (created)
    result := sum( parent, 
                   MappingAnnualBudget, 
                   Global_MappingAnnualBudgetData, 
                   item, 
                   item.YearNo() = yearNo and productNo.Find( item.ProductId() ) > -1,
                   item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1,
                   item.GetCapacityInSheetInSeason( seasonNo ) );
    return result;
  *]

 _Main/BL/Type_Global_MappingAnnualBudgetData/StaticMethod_GetSheetByYear.qbl

ÎļþÃû´Ó _Main/BL/Type_MappingAnnualBudget/StaticMethod_GetSheetByYear.qbl ÐÞ¸Ä
@@ -2,7 +2,7 @@
#parent: #root
StaticMethod GetSheetByYear (
  Strings productNo,
  MPSync parent,
  GlobalOTDTable parent,
  Number yearNo
) as Real
{
@@ -11,9 +11,9 @@
  [*
    // yypsybs Sep-18-2023 (created)
    result := sum( parent, 
                   MappingAnnualBudget, 
                   Global_MappingAnnualBudgetData, 
                   item, 
                   item.YearNo() = yearNo and productNo.Find( item.ProductId() ) > -1,
                   item.YearNo() = [String]yearNo and productNo.Find( item.ProductID() ) > -1,
                   item.GetCapacityInSheetInYear() );
    return result;
  *]

 _Main/BL/Type_Global_MappingAnnualBudgetData/StaticMethod_SetOrgCodeFromForecast.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,24 @@
Quintiq file version 2.0
#parent: #root
StaticMethod SetOrgCodeFromForecast (
  GlobalOTDTable parent
)
{
  TextBody:
  [*
    // yypsybs Oct-7-2023 (created)
    traverse( parent, Global_MappingAnnualBudgetData, item ) {
      productCode := item.ProductID();
      Global_MappingOperationBOM::CreateTestData( parent, "事业部" + [String](productCode.Length() mod 3), "面板基地" + [String](productCode.Length() mod 4), productCode );
      boms := selectset( parent, Global_MappingOperationBOM, bom, bom.ProductCode() = productCode );
      if( boms.Size() > 0 ) {
        bom := boms.First();
        placeOfProductionOfArray := bom.OrganCode();
        item.OrgCodeFromBom( placeOfProductionOfArray );
      } else {
        debuginfo( "no boms for product : " + productCode );
        item.OrgCodeFromBom( item.OrganCode() );
      }
    }
  *]
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/TypeIndex_Global_MappingAnnualBudgetDataTypeIndex.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,12 @@
Quintiq file version 2.0
#parent: #root
TypeIndex Global_MappingAnnualBudgetDataTypeIndex
{
  Attributes:
  [
    TypeIndexAttribute
    {
      ModelElement: ID
    }
  ]
}

 _Main/BL/Type_Global_MappingAnnualBudgetData/_ROOT_Type_Global_MappingAnnualBudgetData.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,10 @@
Quintiq file version 2.0
#root
#parent: #DomainModel
Type Global_MappingAnnualBudgetData
{
  #keys: '5[414384.0.933884744][414384.0.933884742][0.0.0][414384.0.933884743][414384.0.933884745]'
  BaseType: Object
  Description: '年度预算数据'
  StructuredName: 'Global_MappingAnnualBudgetDatas'
}

 _Main/BL/Type_Global_MappingForecast/StaticMethod_GetBalanceByHalfYear.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,24 @@
Quintiq file version 2.0
#parent: #root
StaticMethod GetBalanceByHalfYear (
  Strings productCodes,
  GlobalOTDTable parent,
  Number yearNo,
  Number halfNo
) as Real
{
  TextBody:
  [*
    // yypsybs Sep-19-2023 (created)
    value := 0.0;
    
    startMonth := 1 + ( halfNo - 1 ) * 6;
    endMonth := 6 + ( halfNo - 1 ) * 6;
    
    for( monthNo := startMonth; monthNo <= endMonth; monthNo := monthNo + 1 ) {
      value := value + Global_MappingForecast::GetBalanceByMonth( productCodes, parent, yearNo, monthNo );
    }
    
    return value;
  *]
}

 _Main/BL/Type_Global_MappingForecast/StaticMethod_GetBalanceByMonth.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,21 @@
Quintiq file version 2.0
#parent: #root
StaticMethod GetBalanceByMonth (
  Strings productCodes,
  GlobalOTDTable parent,
  Number yearNo,
  Number monthNo
) as Real
{
  Description: ''
  TextBody:
  [*
    // yypsybs Sep-19-2023 (created)
    value := sum( parent, 
                  Global_MappingForecast, 
                  item,
                  productCodes.Find( item.ProductID() ) > -1 and yearNo = item.StartDate().Year() and monthNo = item.StartDate().Month(), 
                  item.Price() * item.Quantity() );
    return value;
  *]
}

 _Main/BL/Type_Global_MappingForecast/StaticMethod_GetBalanceBySeason.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,24 @@
Quintiq file version 2.0
#parent: #root
StaticMethod GetBalanceBySeason (
  Strings productCodes,
  GlobalOTDTable parent,
  Number yearNo,
  Number seasonNo
) as Real
{
  TextBody:
  [*
    // yypsybs Sep-19-2023 (created)
    value := 0.0;
    
    startMonth := 1 + ( seasonNo - 1 ) * 3;
    endMonth := 3 + ( seasonNo - 1 ) * 3;
    
    for( monthNo := startMonth; monthNo <= endMonth; monthNo := monthNo + 1 ) {
      value := value + Global_MappingForecast::GetBalanceByMonth( productCodes, parent, yearNo, monthNo );
    }
    
    return value;
  *]
}

 _Main/BL/Type_Global_MappingForecast/StaticMethod_GetBalanceByYear.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,20 @@
Quintiq file version 2.0
#parent: #root
StaticMethod GetBalanceByYear (
  Strings productCodes,
  GlobalOTDTable parent,
  Number yearNo
) as Real
{
  Description: ''
  TextBody:
  [*
    // yypsybs Sep-19-2023 (created)
    value := sum( parent, 
                  Global_MappingForecast, 
                  item,
                  productCodes.Find( item.ProductID() ) > -1 and yearNo = item.StartDate().Year(), 
                  item.Price() * item.Quantity() );
    return value;
  *]
}

 _Main/BL/Type_Global_MappingForecast/StaticMethod_GetQuantityByHalfYear.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,24 @@
Quintiq file version 2.0
#parent: #root
StaticMethod GetQuantityByHalfYear (
  Strings productCodes,
  GlobalOTDTable parent,
  Number yearNo,
  Number halfNo
) as Real
{
  TextBody:
  [*
    // yypsybs Sep-19-2023 (created)
    value := 0.0;
    
    startMonth := 1 + ( halfNo - 1 ) * 6;
    endMonth := 6 + ( halfNo - 1 ) * 6;
    
    for( monthNo := startMonth; monthNo <= endMonth; monthNo := monthNo + 1 ) {
      value := value + Global_MappingForecast::GetQuantityByMonth( productCodes, parent, yearNo, monthNo );
    }
    
    return value;
  *]
}

 _Main/BL/Type_Global_MappingForecast/StaticMethod_GetQuantityByMonth.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,20 @@
Quintiq file version 2.0
#parent: #root
StaticMethod GetQuantityByMonth (
  Strings productCodes,
  GlobalOTDTable parent,
  Number yearNo,
  Number monthNo
) as Real
{
  TextBody:
  [*
    // yypsybs Sep-19-2023 (created)
    value := sum( parent, 
                  Global_MappingForecast, 
                  item,
                  productCodes.Find( item.ProductID() ) > -1 and yearNo = item.StartDate().Year() and monthNo = item.StartDate().Month(), 
                  item.Quantity() );
    return value;
  *]
}

 _Main/BL/Type_Global_MappingForecast/StaticMethod_GetQuantityBySeason.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,24 @@
Quintiq file version 2.0
#parent: #root
StaticMethod GetQuantityBySeason (
  Strings productCodes,
  GlobalOTDTable parent,
  Number yearNo,
  Number seasonNo
) as Real
{
  TextBody:
  [*
    // yypsybs Sep-19-2023 (created)
    value := 0.0;
    
    startMonth := 1 + ( seasonNo - 1 ) * 3;
    endMonth := 3 + ( seasonNo - 1 ) * 3;
    
    for( monthNo := startMonth; monthNo <= endMonth; monthNo := monthNo + 1 ) {
      value := value + Global_MappingForecast::GetQuantityByMonth( productCodes, parent, yearNo, monthNo );
    }
    
    return value;
  *]
}

 _Main/BL/Type_Global_MappingForecast/StaticMethod_GetQuantityByYear.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,20 @@
Quintiq file version 2.0
#parent: #root
StaticMethod GetQuantityByYear (
  Strings productCodes,
  GlobalOTDTable parent,
  Number yearNo
) as Real
{
  Description: ''
  TextBody:
  [*
    // yypsybs Sep-19-2023 (created)
    value := sum( parent, 
                  Global_MappingForecast, 
                  item,
                  productCodes.Find( item.ProductID() ) > -1 and yearNo = item.StartDate().Year(), 
                  item.Quantity() );
    return value;
  *]
}

 _Main/BL/Type_Global_MappingOperationBOM/StaticMethod_CreateTestData.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,27 @@
Quintiq file version 2.0
#parent: #root
StaticMethod CreateTestData (
  GlobalOTDTable parent,
  String businessType,
  String orgCode,
  String productCode
) as Global_MappingOperationBOM
{
  TextBody:
  [*
    // yypsybs Sep-18-2023 (created)
    value := select( parent, Global_MappingOperationBOM, bom, bom.BusinessType() = businessType and bom.OrganCode() = orgCode and bom.ProductCode() = productCode );
    if( isnull( value ) ) {
      value := parent.Global_MappingOperationBOM( relnew, 
                                                  BusinessType := businessType,
                                                  OrganCode := orgCode,
                                                  ProductCode := productCode, 
                                                  ComponentType := "",
                                                  ComponentUnit := "",
                                                  ProcessSection := "", 
                                                  ComponentCode := "", 
                                                  AlternativeMaterialCode := "" );
    }
    return value;
  *]
}

 _Main/BL/Type_MPSync/Method_RefreshCapacityAndSaleBudgeFilter.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MPSync/Method_RefreshCapacityAndSaleBudgeFilter0.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MPSync/StaticMethod_TestData.qbl

@@ -9,10 +9,10 @@
  [*
    // yypsybs Sep-20-2023 (created)
    
    info( "MPSync::TestData" );
    debuginfo( "MPSync::TestData" );
    
    productCodeList := selectuniquevalues( macroPlan, Product_MP, item, item.ID() );
    info( "productCodeList : " + [String]productCodeList.Size() );
    debuginfo( "productCodeList : " + [String]productCodeList.Size() );
    
    mpSync.MappingCapacityAndSaleBudge( relflush );
    for( year := Date::ActualDate().Year() - 10; year <= Date::ActualDate().Year() + 5; year := year + 1 ) {
@@ -38,27 +38,6 @@
      }
    }
    result1 := selectset( mpSync, MappingCapacityAndSaleBudge, item, true );
    info( "test MappingCapacityAndSaleBudge size : " + [String]result1.Size() );
    
    mpSync.MappingAnnualBudget( relflush );
    for( year := Date::ActualDate().Year() - 10; year <= Date::ActualDate().Year() + 5; year := year + 1 ) {
      for( i := 1; i <= productCodeList.Size(); i := i + 1 ) {
        productCode := productCodeList.Element( i - 1 );
        mappingAnnualBudget := mpSync.MappingAnnualBudget( relnew, 
                                                           YearNo := year,
                                                           ProductId := productCode
                                                            );
        for( month := 1; month <= 12; month := month + 1 ) {
          field := Reflection::FindAttribute( "MappingAnnualBudget", "MonthlyModCapacity" + [String]month );
          field.Set( mappingAnnualBudget, Real::Random( 20000.0, 30000.0 ) );
          field := Reflection::FindAttribute( "MappingAnnualBudget", "MonthlySheetCapacity" + [String]month );
          field.Set( mappingAnnualBudget, Real::Random( 20000.0, 30000.0 ) );
          field := Reflection::FindAttribute( "MappingAnnualBudget", "MonthlySales" + [String]month );
          field.Set( mappingAnnualBudget, Real::Random( 20000.0, 30000.0 ) );
        }
      }
    }
    result2 := selectset( mpSync, MappingAnnualBudget, item, true );
    info( "test MappingAnnualBudget size : " + [String]result2.Size() );
    debuginfo( "test MappingCapacityAndSaleBudge size : " + [String]result1.Size() );
  *]
}

 _Main/BL/Type_MappingAnnualBudget/Attribute_BusinessType.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlyModCapacity1.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlyModCapacity10.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlyModCapacity11.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlyModCapacity12.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlyModCapacity2.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlyModCapacity3.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlyModCapacity4.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlyModCapacity5.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlyModCapacity6.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlyModCapacity7.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlyModCapacity8.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlyModCapacity9.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlySales1.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlySales10.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlySales11.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlySales12.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlySales2.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlySales3.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlySales4.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlySales5.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlySales6.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlySales7.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlySales8.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlySales9.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlySheetCapacity1.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlySheetCapacity10.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlySheetCapacity11.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlySheetCapacity12.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlySheetCapacity2.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlySheetCapacity3.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlySheetCapacity4.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlySheetCapacity5.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlySheetCapacity6.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlySheetCapacity7.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlySheetCapacity8.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_MonthlySheetCapacity9.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_ProductId.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Attribute_yearNo.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/DefaultValue_BusinessType.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Method_GetCapacityInPCSInYear.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Method_GetCapacityInSheetInYear.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/Method_GetSaleAmountInYear.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/StaticMethod_GetSaleByMonth.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/StaticMethod_GetSheetByMonth.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_MappingAnnualBudget/_ROOT_Type_MappingAnnualBudget.qbl

ÎļþÒÑɾ³ý

 _Main/UI/MacroPlannerWebApp/Component_FormCapacityAndSaleBudge/Component_ListCapacityAndSaleBudge.def

@@ -11,11 +11,11 @@
      BaseType: 'WebDataExtractor'
      Properties:
      [
        DataType: 'MPSync'
        FixedFilter: 'object.YearNo() = Date::ActualDate().Year()'
        Source: 'MPSync'
        DataType: 'GlobalOTDTable'
        FixedFilter: '[Number]object.YearNo() = Date::ActualDate().Year()'
        Source: 'GlobalOTDTable'
        Taborder: 0
        Transformation: 'MappingCapacityAndSaleBudge'
        Transformation: 'Global_MappingAnnualBudgetData'
      ]
    }
    #child: listActionBarPageCapacityAndSaleBudge
@@ -29,9 +29,9 @@
      ]
      Properties:
      [
        Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Deleted","title":"Deleted","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Deleted"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"YearNo","title":"YearNo","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"YearNo"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OrgCode","title":"OrgCode","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OrgCode"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"DisplayTechnology","title":"DisplayTechnology","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"DisplayTechnology"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"BusinessType","title":"BusinessType","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"BusinessType"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"LineAndSpecification","title":"LineAndSpecification","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"LineAndSpecification"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProductCode","title":"ProductCode","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProductCode"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"PlaceOfProductionOfArray","title":"PlaceOfProductionOfArray","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"PlaceOfProductionOfArray"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"PlaceOfProductionOfEvaporation","title":"PlaceOfProductionOfEvaporation","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"PlaceOfProductionOfEvaporation"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Resolution","title":"Resolution","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Resolution"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ShippingForm","title":"ShippingForm","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ShippingForm"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"NumberOfCut","title":"NumberOfCut","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"NumberOfCut"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityEquivalent","title":"CapacityEquivalent","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityEquivalent"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"NumberOfMask","title":"NumberOfMask","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"NumberOfMask"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityInPCSInMonth1","title":"CapacityInPCSInMonth1","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityInPCSInMonth1"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityInPCSInMonth2","title":"CapacityInPCSInMonth2","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityInPCSInMonth2"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityInPCSInMonth3","title":"CapacityInPCSInMonth3","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityInPCSInMonth3"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityInPCSInMonth4","title":"CapacityInPCSInMonth4","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityInPCSInMonth4"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityInPCSInMonth5","title":"CapacityInPCSInMonth5","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityInPCSInMonth5"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityInPCSInMonth6","title":"CapacityInPCSInMonth6","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityInPCSInMonth6"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityInPCSInMonth7","title":"CapacityInPCSInMonth7","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityInPCSInMonth7"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityInPCSInMonth8","title":"CapacityInPCSInMonth8","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityInPCSInMonth8"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityInPCSInMonth9","title":"CapacityInPCSInMonth9","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityInPCSInMonth9"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityInPCSInMonth10","title":"CapacityInPCSInMonth10","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityInPCSInMonth10"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityInPCSInMonth11","title":"CapacityInPCSInMonth11","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityInPCSInMonth11"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityInPCSInMonth12","title":"CapacityInPCSInMonth12","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityInPCSInMonth12"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityInPCSTotal","title":"CapacityInPCSTotal","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityInPCSTotal"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityInSheetInMonth1","title":"CapacityInSheetInMonth1","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityInSheetInMonth1"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityInSheetInMonth2","title":"CapacityInSheetInMonth2","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityInSheetInMonth2"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityInSheetInMonth3","title":"CapacityInSheetInMonth3","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityInSheetInMonth3"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityInSheetInMonth4","title":"CapacityInSheetInMonth4","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityInSheetInMonth4"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityInSheetInMonth5","title":"CapacityInSheetInMonth5","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityInSheetInMonth5"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityInSheetInMonth6","title":"CapacityInSheetInMonth6","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityInSheetInMonth6"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityInSheetInMonth7","title":"CapacityInSheetInMonth7","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityInSheetInMonth7"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityInSheetInMonth8","title":"CapacityInSheetInMonth8","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityInSheetInMonth8"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityInSheetInMonth9","title":"CapacityInSheetInMonth9","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityInSheetInMonth9"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityInSheetInMonth10","title":"CapacityInSheetInMonth10","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityInSheetInMonth10"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityInSheetInMonth11","title":"CapacityInSheetInMonth11","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityInSheetInMonth11"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityInSheetInMonth12","title":"CapacityInSheetInMonth12","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityInSheetInMonth12"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityInSheetTotal","title":"CapacityInSheetTotal","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityInSheetTotal"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SaleAmountInMonth1","title":"SaleAmountInMonth1","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SaleAmountInMonth1"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SaleAmountInMonth2","title":"SaleAmountInMonth2","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SaleAmountInMonth2"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SaleAmountInMonth3","title":"SaleAmountInMonth3","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SaleAmountInMonth3"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SaleAmountInMonth5","title":"SaleAmountInMonth5","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SaleAmountInMonth5"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SaleAmountInMonth4","title":"SaleAmountInMonth4","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SaleAmountInMonth4"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SaleAmountInMonth6","title":"SaleAmountInMonth6","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SaleAmountInMonth6"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SaleAmountInMonth7","title":"SaleAmountInMonth7","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SaleAmountInMonth7"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SaleAmountInMonth8","title":"SaleAmountInMonth8","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SaleAmountInMonth8"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SaleAmountInMonth9","title":"SaleAmountInMonth9","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SaleAmountInMonth9"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SaleAmountInMonth10","title":"SaleAmountInMonth10","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SaleAmountInMonth10"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SaleAmountInMonth11","title":"SaleAmountInMonth11","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SaleAmountInMonth11"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SaleAmountInMonth12","title":"SaleAmountInMonth12","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SaleAmountInMonth12"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SaleAmountTotal","title":"SaleAmountTotal","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SaleAmountTotal"}}]'
        Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"YearNo","title":"YearNo","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"YearNo"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"BusinessType","title":"BusinessType","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"BusinessType"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"DisplayTechSort","title":"DisplayTechSort","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"DisplayTechSort"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"BusinessSort","title":"BusinessSort","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"BusinessSort"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProductLineAndSpecification","title":"ProductLineAndSpecification","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProductLineAndSpecification"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProductID","title":"ProductID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProductID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OrgCodeFromBom","title":"OrgCodeFromBom","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OrgCodeFromBom"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ResolutionRatio","title":"ResolutionRatio","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ResolutionRatio"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ShippingForm","title":"ShippingForm","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ShippingForm"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CutsNumber","title":"CutsNumber","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CutsNumber"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CapacityEquivalent","title":"CapacityEquivalent","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CapacityEquivalent"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MaskNumber","title":"MaskNumber","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MaskNumber"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlyModCapacity1","title":"MonthlyModCapacity1","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlyModCapacity1"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlyModCapacity2","title":"MonthlyModCapacity2","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlyModCapacity2"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlyModCapacity3","title":"MonthlyModCapacity3","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlyModCapacity3"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlyModCapacity4","title":"MonthlyModCapacity4","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlyModCapacity4"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlyModCapacity5","title":"MonthlyModCapacity5","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlyModCapacity5"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlyModCapacity6","title":"MonthlyModCapacity6","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlyModCapacity6"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlyModCapacity7","title":"MonthlyModCapacity7","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlyModCapacity7"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlyModCapacity8","title":"MonthlyModCapacity8","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlyModCapacity8"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlyModCapacity9","title":"MonthlyModCapacity9","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlyModCapacity9"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlyModCapacity10","title":"MonthlyModCapacity10","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlyModCapacity10"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlyModCapacity11","title":"MonthlyModCapacity11","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlyModCapacity11"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlyModCapacity12","title":"MonthlyModCapacity12","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlyModCapacity12"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlySheetCapacity1","title":"MonthlySheetCapacity1","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlySheetCapacity1"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlySheetCapacity2","title":"MonthlySheetCapacity2","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlySheetCapacity2"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlySheetCapacity3","title":"MonthlySheetCapacity3","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlySheetCapacity3"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlySheetCapacity4","title":"MonthlySheetCapacity4","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlySheetCapacity4"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlySheetCapacity5","title":"MonthlySheetCapacity5","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlySheetCapacity5"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlySheetCapacity6","title":"MonthlySheetCapacity6","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlySheetCapacity6"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlySheetCapacity7","title":"MonthlySheetCapacity7","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlySheetCapacity7"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlySheetCapacity8","title":"MonthlySheetCapacity8","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlySheetCapacity8"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlySheetCapacity9","title":"MonthlySheetCapacity9","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlySheetCapacity9"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlySheetCapacity10","title":"MonthlySheetCapacity10","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlySheetCapacity10"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlySheetCapacity11","title":"MonthlySheetCapacity11","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlySheetCapacity11"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlySheetCapacity12","title":"MonthlySheetCapacity12","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlySheetCapacity12"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlySales1","title":"MonthlySales1","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlySales1"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlySales2","title":"MonthlySales2","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlySales2"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlySales3","title":"MonthlySales3","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlySales3"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlySales4","title":"MonthlySales4","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlySales4"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlySales5","title":"MonthlySales5","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlySales5"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlySales6","title":"MonthlySales6","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlySales6"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlySales7","title":"MonthlySales7","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlySales7"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlySales8","title":"MonthlySales8","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlySales8"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlySales9","title":"MonthlySales9","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlySales9"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlySales10","title":"MonthlySales10","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlySales10"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlySales11","title":"MonthlySales11","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlySales11"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MonthlySales12","title":"MonthlySales12","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MonthlySales12"}}]'
        ContextMenu: 'listContextMenuCapacityAndSaleBudge'
        SortCriteria: 'BusinessType;OrgCode;ProductCode'
        SortCriteria: 'BusinessSort;OrganCode;ProductID'
        Taborder: 2
      ]
    }

 _Main/UI/MacroPlannerWebApp/Component_FormCapacityAndSaleBudge/Response_ButtonExportDetail_OnClick.def

@@ -15,7 +15,7 @@
    [*
      //Application.Download( "年度产销预算详情.xlsx", MPSync.CapacityAndSaleBudgeExport().AsBinaryData() );
      
      base64 := MappingCapacityAndSaleBudge::Export( MPSync );
      base64 := Global_MappingAnnualBudgetData::Export( GlobalOTDTable );
      Application.Download( "年度产销预算详情.xlsx", base64 );
    *]
    GroupServerCalls: false

 _Main/UI/MacroPlannerWebApp/Component_FormCapacityAndSaleBudge/Response_OnCreated.def

@@ -12,7 +12,9 @@
    [*
      MPSync::TestData( MPSync, MacroPlan );
      GlobalOTDTable.InitTestData();
      MPSync.RefreshCapacityAndSaleBudgeFilter( GlobalOTDTable );
      GlobalOTDTable.InitTestData( MacroPlan );
      Global_MappingAnnualBudgetData::SetOrgCodeFromForecast( GlobalOTDTable );
      GlobalOTDTable.RefreshCapacityAndSaleBudgeFilter( true );
    *]
  }
}

 _Main/UI/MacroPlannerWebApp/Component_FormCapacityAndSaleBudgeChart/Response_ButtonCapacityAndSaleBudgeChartTest_OnClick.def

@@ -10,7 +10,7 @@
  {
    Body:
    [*
      CapacityAndSaleBudgeChartElement::TestData( GlobalOTDTable );
      //CapacityAndSaleBudgeChartElement::TestData( GlobalOTDTable );
      
      GlobalOTDTable.CapacityAndSaleBudgeChart( DataHolderMacroPlansForScenarioComparison.Data(), 
                                                DropDownSaleOrCapacity.Text(),
@@ -20,9 +20,7 @@
                                                DataHolderCapacityAndSaleBudgeFilterPlaceOfProductionOfArray.Data(),
                                                DataHolderCapacityAndSaleBudgeFilterYear.Data(),
                                                DataHolderCapacityAndSaleBudgeFilterMonth.Data(),
                                                MPSync, 
                                                GlobalOTDTable, 
                                                MacroPlan );
                                                GlobalOTDTable );
    *]
  }
}

 _Main/UI/MacroPlannerWebApp/Component_FormCapacityAndSaleBudgeCompare/Response_ButtonCapacityAndSaleBudgeCompare_OnClick.def

@@ -18,9 +18,7 @@
                                                  DataHolderCapacityAndSaleBudgeFilterItem.Data(), 
                                                  DataHolderCapacityAndSaleBudgeFilterYear.Data(), 
                                                  DataHolderCapacityAndSaleBudgeFilterMonth.Data(),
                                                  MPSync, 
                                                  GlobalOTDTable,
                                                  MacroPlan );
                                                  GlobalOTDTable );
    *]
  }
}

 _Main/UI/MacroPlannerWebApp/Component_FormCapacityAndSaleBudgeFilterBusinessType/Response_listContextMenuCapacityAndSaleBudgeFilterYear_1_MenuRefresh_OnClick.def

@@ -10,7 +10,7 @@
  {
    Body:
    [*
      MPSync.RefreshCapacityAndSaleBudgeFilter( GlobalOTDTable );
      GlobalOTDTable.RefreshCapacityAndSaleBudgeFilter( true );
    *]
  }
}

 _Main/UI/MacroPlannerWebApp/Component_FormCapacityAndSaleBudgeFilterPlaceOfProductionOfArray/Response_listContextMenuCapacityAndSaleBudgeFilterYear_1_MenuRefresh_OnC#663.def

@@ -10,7 +10,7 @@
  {
    Body:
    [*
      MPSync.RefreshCapacityAndSaleBudgeFilter( GlobalOTDTable );
      GlobalOTDTable.RefreshCapacityAndSaleBudgeFilter( true );
    *]
  }
}