Merge branch 'dev' of http://47.101.211.7:10101/r/TIANMA_JITUAN into dev_lhj

hongji.li

2023-10-10 4b15cdb0ac0b85f53072e0320730f01547bf1cec

Merge branch 'dev' of http://47.101.211.7:10101/r/TIANMA_JITUAN into dev_lhj

 _Main/BL/EDI/Broker_GlobalOTDTable_AnnualBudgetData.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,398 @@
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 OrgCodeFromBom { Attribute: OrgCodeFromBom 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_Global_MappingProviderCapacity_GlobalOTDTable_GlobalOTDTable_Global.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,23 @@
Quintiq file version 2.0
#parent: #root
Relation Global_MappingProviderCapacity_GlobalOTDTable_GlobalOTDTable_Global_MappingProviderCapacity
{
  #keys: '1[414384.0.953290006]'
  DefaultRelationStrategy
  {
  }
  RelationSide.LeftSide GlobalOTDTable
  {
    #keys: '3[414384.0.953290008][414384.0.953290007][414384.0.953290009]'
    Cardinality: '0to1'
    ObjectDefinition: Global_MappingProviderCapacity
    OwningSide: 'Reference'
  }
  RelationSide.RightSide Global_MappingProviderCapacity
  {
    #keys: '3[414384.0.953290011][414384.0.953290010][414384.0.953290012]'
    Cardinality: '1toN'
    ObjectDefinition: GlobalOTDTable
    OwningSide: 'Owned'
  }
}

 _Main/BL/Relations/Relation_MappingAnnualBudget_MPSync_MPSync_MappingAnnualBudget.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_ERPRequestOfPR/StaticMethod_Create.qbl

@@ -11,7 +11,7 @@
    
    request.BusinessType( history.BusinessType() );
    request.DataID( history.DataID() );
    request.DeliveryDate( history.ProduceRequiredDate() );
    request.DeliveryDate( history.DeliveryDate() );
    request.MRPCalverNo( history.MRPCalverNo() );
    request.OrganCode( history.OrganCode() );
    request.ProductID( history.ProductID() );

 _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,7 +27,9 @@
    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();
    //globalOTDTable -> OnException( globalOTDTable -> Global_MappingStockingPoint_MP::CreateByAPI() -> Exception(), globalOTDTable );
@@ -44,9 +46,13 @@
    //globalOTDTable.GlobalOTDTable_InventorySupply().AsyncExecute();
    //globalOTDTable.GlobalOTDTable_StockingPointCost().AsyncExecute();
    //globalOTDTable.GlobalOTDTable_OperationCost().AsyncExecute();
    //globalOTDTable.GlobalOTDTable_Forecast().AsyncExecute();      
    //globalOTDTable.GlobalOTDTable_Forecast().AsyncExecute();
    //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_MappingOperation/Attribute_DestinationOrganizationId.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute DestinationOrganizationId
{
  #keys: '3[414384.0.953284686][414384.0.953284685][414384.0.953284687]'
  Description: '目的地组织id'
  ValueType: String
}

 _Main/BL/Type_Global_MappingOperation/Attribute_OrganId.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,7 @@
Quintiq file version 2.0
#parent: #root
Attribute OrganId
{
  #keys: '3[414384.0.953284696][414384.0.953284695][414384.0.953284697]'
  ValueType: String
}

 _Main/BL/Type_Global_MappingOperation/StaticMethod_GetByProductId.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,13 @@
Quintiq file version 2.0
#parent: #root
StaticMethod GetByProductId (
  GlobalOTDTable otdTable,
  String productId
) as Global_MappingOperation
{
  TextBody:
  [*
    // yypsybs Oct-9-2023 (created)
    return select( otdTable, Global_MappingOperation, item, item.ProductID() = productId );
  *]
}

 _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_Global_MappingProduct_MP/StaticMethod_GetByProductId.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,15 @@
Quintiq file version 2.0
#parent: #root
StaticMethod GetByProductId (
  GlobalOTDTable parent,
  String productId
) as Global_MappingProduct_MP
{
  Description: '根据料号查记录'
  TextBody:
  [*
    // yypsybs Sep-12-2023 (created)
    value := select( parent, Global_MappingProduct_MP, item, item.ID() = productId );
    return value;
  *]
}

 _Main/BL/Type_Global_MappingProviderCapacity/Attribute_ActualCapacity.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute ActualCapacity
{
  #keys: '3[414384.0.957354916][414384.0.957354915][414384.0.957354917]'
  Description: '日交货能力'
  ValueType: Number
}

 _Main/BL/Type_Global_MappingProviderCapacity/Attribute_IsPartRecognition.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute IsPartRecognition
{
  #keys: '3[414384.0.957354904][414384.0.957354903][414384.0.957354905]'
  Description: '零件承认'
  ValueType: Boolean
}

 _Main/BL/Type_Global_MappingProviderCapacity/Attribute_IsSecondSource.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute IsSecondSource
{
  #keys: '3[414384.0.957354907][414384.0.957354906][414384.0.957354908]'
  Description: '是否二供'
  ValueType: Boolean
}

 _Main/BL/Type_Global_MappingProviderCapacity/Attribute_IsSpecialDisplay.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute IsSpecialDisplay
{
  #keys: '3[414384.0.957354901][414384.0.957354900][414384.0.957354902]'
  Description: '是否专显'
  ValueType: Boolean
}

 _Main/BL/Type_Global_MappingProviderCapacity/Attribute_LeadTime.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute LeadTime
{
  #keys: '3[414384.0.957354919][414384.0.957354918][414384.0.957354920]'
  Description: 'L/T'
  ValueType: Number
}

 _Main/BL/Type_Global_MappingProviderCapacity/Attribute_LotSize.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute LotSize
{
  #keys: '3[414384.0.957354925][414384.0.957354924][414384.0.957354926]'
  Description: '最小包装量'
  ValueType: Number
}

 _Main/BL/Type_Global_MappingProviderCapacity/Attribute_MinimumQuantity.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute MinimumQuantity
{
  #keys: '3[414384.0.957354922][414384.0.957354921][414384.0.957354923]'
  Description: '最小订货量'
  ValueType: Number
}

 _Main/BL/Type_Global_MappingProviderCapacity/Attribute_ProductID.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute ProductID
{
  #keys: '3[414384.0.957354895][414384.0.957354894][414384.0.957354896]'
  Description: '物料编码'
  ValueType: String
}

 _Main/BL/Type_Global_MappingProviderCapacity/Attribute_ProductName.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute ProductName
{
  #keys: '3[414384.0.957354892][414384.0.957354891][414384.0.957354893]'
  Description: '物料说明'
  ValueType: String
}

 _Main/BL/Type_Global_MappingProviderCapacity/Attribute_ProviderName.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute ProviderName
{
  #keys: '3[414384.0.957354910][414384.0.957354909][414384.0.957354911]'
  Description: '供应商名称'
  ValueType: String
}

 _Main/BL/Type_Global_MappingProviderCapacity/Attribute_Rate.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute Rate
{
  #keys: '3[414384.0.957354928][414384.0.957354927][414384.0.957354929]'
  Description: '比例'
  ValueType: Number
}

 _Main/BL/Type_Global_MappingProviderCapacity/Attribute_StockingPointID.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute StockingPointID
{
  #keys: '3[414384.0.957354913][414384.0.957354912][414384.0.957354914]'
  Description: '库存点'
  ValueType: String
}

 _Main/BL/Type_Global_MappingProviderCapacity/Attribute_UnitOfMeasureName.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute UnitOfMeasureName
{
  #keys: '3[414384.0.957354898][414384.0.957354897][414384.0.957354899]'
  Description: '单位'
  ValueType: String
}

 _Main/BL/Type_Global_MappingProviderCapacity/StaticMethod_GetByProductId.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,13 @@
Quintiq file version 2.0
#parent: #root
StaticMethod GetByProductId (
  GlobalOTDTable parent,
  String productId
) as Global_MappingProviderCapacity
{
  TextBody:
  [*
    // yypsybs Oct-10-2023 (created)
    return select( parent, Global_MappingProviderCapacity, item, item.ProductID() = productId );
  *]
}

 _Main/BL/Type_Global_MappingProviderCapacity/_ROOT_Type_Global_MappingProviderCapacity.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,10 @@
Quintiq file version 2.0
#root
#parent: #DomainModel
Type Global_MappingProviderCapacity
{
  #keys: '5[414384.0.957354887][414384.0.957354885][0.0.0][414384.0.957354886][414384.0.957354888]'
  BaseType: Object
  Description: '供应商能力'
  StructuredName: 'Global_MappingProviderCapacitys'
}

 _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_MacroPlan/Method_MappingOperationData.qbl

@@ -74,7 +74,7 @@
        op := Operation::FindOperationTypeIndex( operationId );
        if( isnull( op)){
          op := Operation::Create( operationId, unit, operationId, routingStep, 
                                        Duration::Hours( item.UserLeadTime() ), Duration::Zero(), item.ActualCapacity(), false, 
                                        Duration::Days( item.UserLeadTime() ), Duration::Zero(), item.ActualCapacity(), false, 
                                        [Real]item.MinimumQuantity(), haveMaxQty, guard( [Real]item.MaximumQuantity(), Real::MaxReal() ), 
                                        0.0, 0.0, false, true );
        }

 _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/BL/Type_PRData/Attribute_CreateBy.qbl

ÎļþÃû´Ó _Main/BL/Type_PRData/Attribute_SendBy.qbl ÐÞ¸Ä
@@ -1,6 +1,6 @@
Quintiq file version 2.0
#parent: #root
Attribute SendBy
Attribute CreateBy
{
  #keys: '3[414384.0.789498519][414384.0.789498518][414384.0.789498520]'
  Description: '发送人'

 _Main/BL/Type_PRData/Attribute_CreateTime.qbl

ÎļþÃû´Ó _Main/BL/Type_PRData/Attribute_SendTIme.qbl ÐÞ¸Ä
@@ -1,6 +1,6 @@
Quintiq file version 2.0
#parent: #root
Attribute SendTime
Attribute CreateTime
{
  #keys: '3[414384.0.789498516][414384.0.789498515][414384.0.789498517]'
  Description: '发送时间'

 _Main/BL/Type_PRData/Attribute_CreateTimeString.qbl

ÎļþÃû´Ó _Main/BL/Type_PRData/Attribute_SendTimeString.qbl ÐÞ¸Ä
@@ -1,6 +1,6 @@
Quintiq file version 2.0
#parent: #root
Attribute SendTimeString
Attribute CreateTimeString
{
  #keys: '3[414384.0.847354596][414384.0.847354595][414384.0.847354597]'
  ValueType: String

 _Main/BL/Type_PRData/Attribute_DeliveryDate.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute DeliveryDate
{
  #keys: '3[414384.0.957354843][414384.0.957354842][414384.0.957354844]'
  Description: '交货日期'
  ValueType: Date
}

 _Main/BL/Type_PRData/Attribute_LineAttribute3.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,7 @@
Quintiq file version 2.0
#parent: #root
Attribute LineAttribute3
{
  #keys: '3[414384.0.953290077][414384.0.953290076][414384.0.953290078]'
  ValueType: String
}

 _Main/BL/Type_PRData/Attribute_OrganName.qbl

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

 _Main/BL/Type_PRData/Attribute_PRReleaseStatus.qbl

ÎļþÃû´Ó _Main/BL/Type_PRData/Attribute_SendStatus.qbl ÐÞ¸Ä
@@ -1,6 +1,6 @@
Quintiq file version 2.0
#parent: #root
Attribute SendStatus
Attribute PRReleaseStatus
{
  #keys: '3[414384.0.789498513][414384.0.789498512][414384.0.789498514]'
  Description: 'PR数据发送状态'

 _Main/BL/Type_PRData/Attribute_PlannerCode.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_PRData/Attribute_ProduceRequiredDate.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_PRData/Function_CalcSendTimeString.qbl

@@ -6,13 +6,13 @@
  [*
    // yypsybs Sep-19-2023 (created)
    value := "";
    if( this.SendStatus() <> "" ) {
    if( this.PRReleaseStatus() <> "" ) {
      cnv := DateTimeToString::StandardConverter();
      cnv.SetCustomConversion();
      cnv.CustomFormatString( "yyyy/MM/dd H:mm:ss" );
      
      value := guard( cnv.Convert( this.SendTime() ), "" );
      value := guard( cnv.Convert( this.CreateTime() ), "" );
    }
    this.SendTimeString( value );
    this.CreateTimeString( value );
  *]
}

 _Main/BL/Type_PRData/Method_DoCall.qbl

@@ -13,6 +13,7 @@
    
    // ç…§æ¬éƒ¨åˆ†
    result.AuthorizationStatus( this.AuthorizationStatus() );
    
    result.BusinessType( this.BusinessType() );
    result.DataID( this.DataID() );
    result.DeliverToRequestorId( this.DeliverToRequestorId() );
@@ -26,9 +27,8 @@
    result.MRPCalverNo( this.MRPCalverNo() );
    result.OrganCode( this.OrganCode() );
    result.OrgId( this.OrgId() );
    result.PlannerCode( this.PlannerCode() );
    result.PreparerId( this.PreparerId() );
    result.ProduceRequiredDate( this.ProduceRequiredDate() );
    result.PreparerID( this.PreparerId() );
    result.DeliveryDate( this.DeliveryDate() );
    result.ProductID( this.ProductID() );
    result.ProductName( this.ProductName() );
    result.ProviderCode( this.ProviderCode() );
@@ -52,9 +52,9 @@
    result.SendStatus( "已发送" );
    result.ReleaseBy( callBy );
    result.SendTime( DateTime::Now() );
    this.SendStatus( "已发送" );
    this.SendTime( DateTime::Now() );
    this.SendBy( callBy );
    this.PRReleaseStatus( "已发送" );
    this.CreateTime( DateTime::Now() );
    this.CreateBy( callBy );
    
    return result;
  *]

 _Main/BL/Type_PRData/Method_PrintCall.qbl

@@ -25,9 +25,8 @@
    result.MRPCalverNo( this.MRPCalverNo() );
    result.OrganCode( this.OrganCode() );
    result.OrgId( this.OrgId() );
    result.PlannerCode( this.PlannerCode() );
    result.PreparerId( this.PreparerId() );
    result.ProduceRequiredDate( this.ProduceRequiredDate() );
    result.PreparerID( this.PreparerId() );
    result.DeliveryDate( this.DeliveryDate() );
    result.ProductID( this.ProductID() );
    result.ProductName( this.ProductName() );
    result.ProviderCode( this.ProviderCode() );

 _Main/BL/Type_PRData/StaticMethod_CanCall.qbl

@@ -13,7 +13,7 @@
    if( toCalls.Size() = 0 ) {
      feedback_o := "No checked PR";
    } else {
      havaUnsent := exists( toCalls, Elements, toCall, toCall.SendStatus() = "" );
      havaUnsent := exists( toCalls, Elements, toCall, toCall.PRReleaseStatus() = "" );
      if( not havaUnsent ) {
        feedback_o := "No unsent PR";
      }

 _Main/BL/Type_PRData/StaticMethod_DoCall.qbl

@@ -11,7 +11,7 @@
    // yypsybs Sep-12-2023 (created)
    info( "DoCall " + [String]toCalls.Size() + " PRs" );
    nowNo := 1;
    traverse( toCalls, Elements, toCall, toCall.SendStatus() = "" ) {
    traverse( toCalls, Elements, toCall, toCall.PRReleaseStatus() = "" ) {
      info ( "DoCall " + [String]nowNo + "/" + [String]toCalls.Size() + " PR" );
      toCall.DoCall( globalData, callBy );  
      nowNo := nowNo + 1;

 _Main/BL/Type_PRData/StaticMethod_ExportTheFileStream.qbl

@@ -46,7 +46,7 @@
      PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.ProductID(), "物料编码" );
      PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.ProductName(), "物料名称" );
      PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.IsPanelMaterial(), "面板物料标识" );
      PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, ifexpr( toExport.ProduceRequiredDate() = Date::MinDate(), "", dateToString.Convert( toExport.ProduceRequiredDate() ) ), "交货日期" );
      PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, ifexpr( toExport.DeliveryDate() = Date::MinDate(), "", dateToString.Convert( toExport.DeliveryDate() ) ), "交货日期" );
      PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, ifexpr( toExport.PRSuggestionDate() = Date::MinDate(), "", dateToString.Convert( toExport.PRSuggestionDate() ) ), "PR建议日期" );
      PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.Quantity(), "交货数量" );
      PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.MRPCalverNo(), "MRP计算版本号" );
@@ -60,9 +60,9 @@
      PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.ProviderName(), "供应商名称" );
      PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.StockingPointID(), "收货库存点" );
      PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.UnitOfMeasure(), "计量单位" );
      PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.SendStatus(), "PR数据发送状态" );
      PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.SendTimeString(), "发送时间" );
      PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.SendBy(), "发送人" );
      PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.PRReleaseStatus(), "PR数据发送状态" );
      PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.CreateTimeString(), "发送时间" );
      PRData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.CreateBy(), "发送人" );
    }
    
    xmlDOMSerializer := xmlDOMImplementation.CreateSerializer();

 _Main/BL/Type_PRData/StaticMethod_FromSupplyPlanning#662.qbl

@@ -3,25 +3,26 @@
StaticMethod FromSupplyPlanning (
  GlobalOTDTable otdTable,
  MacroPlan macroPlan,
  MacroPlan mappingRoot,
  ProductInStockingPointInPeriod pispip
  ProductInStockingPointInPeriod pispip,
  String userId
) as PRData
{
  TextBody:
  [*
    // yypsybs Sep-12-2023 (created)
    result := macroPlan.PRData( relnew );
    result.InterfaceSourceCode( "Quintiq" );
    
    pisp := pispip.ProductInStockingPoint_MP();
    product := pisp.Product_MP();
    stockingPoint := pisp.StockingPoint_MP();
    period := pispip.Period_MP();
    mappingProduct := MappingProduct::GetByProductId( mappingRoot, product.ID() );
    // QID7
    mappingProduct := Global_MappingProduct_MP::GetByProductId( otdTable, product.ID() );
    // QID12
    mappingOperation := Global_MappingOperation::GetByProductId( otdTable, product.ID() );
    // QID15
    mappingProviderCapacity := Global_MappingProviderCapacity::GetByProductId( otdTable, product.ID() );
    matAttrSetting := MatAttrSettingAndPlanStrategy::GetExistByMatCode( otdTable, product.ID() );
    // æŽ¥å£/中间表暂无
    mappingProviderCapacity := "暂无";
    erpData := "暂无";
    
    // æ ¹æ®pispip
    result.MRPCalverNo( ifexpr( pispip.MRPCalverNo() = "", "暂无", pispip.MRPCalverNo() ) );
@@ -35,9 +36,9 @@
    result.StockingPointID( stockingPoint.ID() );
    
    // æ ¹æ®period
    result.ProduceRequiredDate( period.StartDate() );
    result.PRSuggestionDate( ifexpr( (result.ProduceRequiredDate() - Duration::Days( 7 )).Date() >= Date::Today(),
                                     Date::Today(), (result.ProduceRequiredDate() - Duration::Days( 7 )).Date() ) );
    result.DeliveryDate( period.StartDate() );
    result.PRSuggestionDate( ifexpr( (result.DeliveryDate() - Duration::Days( 7 )).Date() >= Date::Today(),
                                     Date::Today(), (result.DeliveryDate() - Duration::Days( 7 )).Date() ) );
    
    // æ ¹æ® ç‰©æ–™å±žæ€§æ ‡ç­¾è®¾å®š&物料计划策略
    result.IsPanelMaterial( "暂无" );
@@ -51,22 +52,39 @@
      result.MaterialMRPType( ifexpr( matAttrSetting.PlanningStrategyCustom() <> "", matAttrSetting.PlanningStrategyCustom(), matAttrSetting.PlanningStrategyAuto() ) );
    }
    
    
    // æ ¹æ®product中间表
    if( isnull( mappingProduct ) ) {
      result.BusinessType( "暂无" );
      result.OrganCode( "暂无" );
      result.UnitOfMeasure( "暂无" );
      result.BusinessType( "暂无" );  
    } else {
      result.BusinessType( mappingProduct.BusinessType() );
      result.OrganCode( mappingProduct.OrgCode() );
      result.UnitOfMeasure( mappingProduct.UnitOfMeasureName() );
      result.BusinessType( mappingProduct.BusinessType() );   
    }
    result.InterfaceSourceCode( "Quintiq_" + result.BusinessType() );
    
    // æ ¹æ®operation中间表
    if( isnull( mappingOperation ) ) {
      result.OrgId( "暂无" );
      result.OrganCode( "暂无" );
      result.OrganName( "暂无" );
      result.DestinationOrganizationID( "暂无" );
    } else {
      result.OrgId( mappingOperation.OrganId() );
      result.OrganCode( mappingOperation.OrganCode() );
      result.OrganName( mappingOperation.OrganName() );
      result.DestinationOrganizationID( mappingOperation.DestinationOrganizationId() );
    }
    
    // æ ¹æ®ä¾›åº”商能力中间表
    result.ProviderCode( mappingProviderCapacity );
    result.ProductName( mappingProviderCapacity );
    result.LeadTime( 0.0 );
    if( isnull( mappingProviderCapacity ) ) {
      result.ProviderCode( "暂无" );
      result.ProviderName( "暂无" );
      result.LeadTime( 0.0 );
      result.UnitOfMeasure( "暂无" );
    } else {
      result.ProviderCode( "暂无" );
      result.ProviderName( mappingProviderCapacity.ProviderName() );
      result.LeadTime( mappingProviderCapacity.LeadTime() );
      result.UnitOfMeasure( mappingProviderCapacity.UnitOfMeasureName() );
    }
    
    // æ ¹æ®erp接口 å›ºå®šå€¼
    result.RequisitionType( "PURCHASE" );
@@ -76,21 +94,25 @@
    result.LineTypeId( "1" );
    result.LineType( "货物" );
    // æ ¹æ®erp接口 todo
    result.PreparerId( erpData );
    result.HeaderDescription( erpData );
    result.DestinationOrganizationID( erpData );
    result.DeliverToRequestorId( erpData );
    result.LineAttribute1( erpData );
    result.LineAttribute6( erpData );
    result.OrgId( erpData );
    result.LineAttribute1( "" );
    result.LineAttribute3( "" );
    result.LineAttribute6( "" );
    
    // ç”Ÿæˆid todo
    result.DataID( [String]Number::Random( Number::MinNumber(), Number::MaxNumber() ) );
    // ç”¨æˆ·id/name
    result.PreparerId( userId );
    result.HeaderDescription( userId );
    result.DeliverToRequestorId( result.PreparerId() );
    
    // ç”Ÿæˆid
    cnv := DateTimeToString::StandardConverter();
    cnv.SetCustomConversion();
    cnv.CustomFormatString( "yyyyMMdd_H:mm:ss" );
    result.DataID( cnv.Convert( DateTime::ActualTime() ) + "_" + [String]Number::Random( Number::MinNumber(), Number::MaxNumber() ) );
    
    // å‘送信息
    result.SendStatus( "" );
    result.SendBy( "" );
    result.SendTime( DateTime::MinDateTime() );
    result.PRReleaseStatus( "" );
    result.CreateBy( "" );
    result.CreateTime( DateTime::MinDateTime() );
    
    return result;
  *]

 _Main/BL/Type_PRData/StaticMethod_FromSupplyPlanning.qbl

@@ -3,15 +3,11 @@
StaticMethod FromSupplyPlanning (
  GlobalOTDTable otdTable,
  MacroPlan macroPlan,
  MacroPlan mappingRoot,
  String mrpCalverNo
  String mrpCalverNo,
  String userId
)
{
  Description:
  [*
    SupplyPlanning转PRData
    todo ä¿®æ”¹mappingRoot为MPSync
  *]
  Description: 'SupplyPlanning转PRData'
  TextBody:
  [*
    // yypsybs Sep-12-2023 (created)
@@ -21,7 +17,7 @@
    if( isnull( oldRecords ) or oldRecords.Size() = 0 ) {
      pispips := ProductInStockingPointInPeriod::GetByMRPCalverNo( macroPlan, mrpCalverNo );
      traverse( pispips, Elements, item, item.NewSupplyQuantity() > 0 ) {
        PRData::FromSupplyPlanning( otdTable, macroPlan, mappingRoot, item );
        PRData::FromSupplyPlanning( otdTable, macroPlan, item, userId );
      }
    }
  *]

 _Main/BL/Type_PRData/StaticMethod_ProductIdOver14Days.qbl

@@ -10,7 +10,7 @@
    result := "";
    
    productIds := selectuniquevalues( toChecks, Elements, item, 
                                      (item.ProduceRequiredDate() - Duration::Days( 14 )).Date() > Date::Today() and item.SendStatus() = "", 
                                      (item.DeliveryDate() - Duration::Days( 14 )).Date() > Date::Today() and item.PRReleaseStatus() = "", 
                                      item.ProductID() ); 
    productIds := selectsortedset( productIds, Elements, item, item );
    

 _Main/BL/Type_PRData/StaticMethod_TestData.qbl

@@ -6,23 +6,23 @@
{
  TextBody:
  [*
    // yypsybs Sep-12-2023 (created)
    if( selectset( macroPlan, PRData, item, true ).Size() = 0 ) {
      info( "======== Create PR Test Data ========" );
      for( i := 0; i < 100; i := i + 1 ) {
        macroPlan.PRData( relnew,
                          MRPCalverNo := [String]Number::Random( 1, Number::MaxNumber() ),
                          BusinessType := [String]Number::Random( 1, Number::MaxNumber() ),
                          OrganCode := [String]Number::Random( 1, Number::MaxNumber() ),
                          ProductID := [String]Number::Random( 1, Number::MaxNumber() ),
                          StockingPointID := [String]Number::Random( 1, Number::MaxNumber() ),
                          Quantity := Number::Random( 1, Number::MaxNumber() ),
                          ProduceRequiredDate := Date::Construct( 2023,
                                                                  Number::Random( 9, 12 ),
                                                                  Number::Random( 13, 28 ) ),
                          DataID := [String]Number::Random( 1, Number::MaxNumber() ), 
                          SendStatus := ifexpr( Number::Random( 1, 5 ) = 1, "已发送", "" ) );     
      }
    }
    //// yypsybs Sep-12-2023 (created)
    //if( selectset( macroPlan, PRData, item, true ).Size() = 0 ) {
    //  info( "======== Create PR Test Data ========" );
    //  for( i := 0; i < 100; i := i + 1 ) {
    //    macroPlan.PRData( relnew,
    //                      MRPCalverNo := [String]Number::Random( 1, Number::MaxNumber() ),
    //                      BusinessType := [String]Number::Random( 1, Number::MaxNumber() ),
    //                      OrganCode := [String]Number::Random( 1, Number::MaxNumber() ),
    //                      ProductID := [String]Number::Random( 1, Number::MaxNumber() ),
    //                      StockingPointID := [String]Number::Random( 1, Number::MaxNumber() ),
    //                      Quantity := Number::Random( 1, Number::MaxNumber() ),
    //                      DeliveryDate := Date::Construct( 2023,
    //                                                              Number::Random( 9, 12 ),
    //                                                              Number::Random( 13, 28 ) ),
    //                      DataID := [String]Number::Random( 1, Number::MaxNumber() ), 
    //                      PRReleaseStatus := ifexpr( Number::Random( 1, 5 ) = 1, "已发送", "" ) );     
    //  }
    //}
  *]
}

 _Main/BL/Type_PRHistoryData/Attribute_DeliveryDate#168.qbl

ÎļþÃû´Ó _Main/BL/Type_PRHistoryData/Attribute_ProduceRequiredDate#168.qbl ÐÞ¸Ä
@@ -1,6 +1,6 @@
Quintiq file version 2.0
#parent: #root
Attribute ProduceRequiredDate
Attribute DeliveryDate
{
  #keys: '3[414384.0.795671764][414384.0.795671763][414384.0.795671765]'
  Description: '需求日期/交货日期'

 _Main/BL/Type_PRHistoryData/Attribute_PreparerID.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_PRHistoryData/Attribute_PreparerId#603.qbl

@@ -1,6 +1,6 @@
Quintiq file version 2.0
#parent: #root
Attribute PreparerId
Attribute PreparerID
{
  #keys: '3[414384.0.795671570][414384.0.795671569][414384.0.795671571]'
  ValueType: String

 _Main/BL/Type_PRHistoryData/StaticMethod_ExportTheFileStream.qbl

@@ -42,7 +42,7 @@
    traverse ( toExportList, Elements, toExport ) {
      PRHistoryData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.ProductID(), "零件号" );
      PRHistoryData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.ProductName(), "零件名称" );
      PRHistoryData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, ifexpr( toExport.ProduceRequiredDate() = Date::MinDate(), "", dateToString.Convert( toExport.ProduceRequiredDate() ) ), "交货日期" );
      PRHistoryData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, ifexpr( toExport.DeliveryDate() = Date::MinDate(), "", dateToString.Convert( toExport.DeliveryDate() ) ), "交货日期" );
      PRHistoryData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, [String]toExport.Quantity(), "需求数量" );
      PRHistoryData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.MRPCalverNo(), "MRP计算版本号" );
      PRHistoryData::GeneratesTheSpecifiedXMLColumn( xmlDOMDocument, tableElement, toExport.BusinessType(), "事业部" );

 _Main/BL/Type_PRHistoryData/StaticMethod_ProductIdOver14Days.qbl

@@ -10,7 +10,7 @@
    result := "";
    
    productIds := selectuniquevalues( toChecks, Elements, item, 
                                      (item.ProduceRequiredDate() - Duration::Days( 14 )).Date() > Date::Today() and item.SendStatus() = "", 
                                      (item.DeliveryDate() - Duration::Days( 14 )).Date() > Date::Today() and item.SendStatus() = "", 
                                      item.ProductID() ); 
    productIds := selectsortedset( productIds, Elements, item, item );
    

 _Main/BL/Type_ProductInStockingPointInPeriod/StaticMethod_GetByMRPCalverNo.qbl

@@ -12,14 +12,16 @@
    result := construct( ProductInStockingPointInPeriods );
    if( mrpCalverNo <> "" ) {
      result := selectset( parent, Product_MP.ProductInStockingPoint_MP.ProductInStockingPointInPeriod, pispip,
                         pispip.ProductInStockingPoint_MP().Product_MP().ID().StartsWith( "E" )
                         and pispip.MRPCalverNo() = mrpCalverNo 
                           pispip.ProductInStockingPoint_MP().Product_MP().ID().StartsWith( "E" )
                           and pispip.MRPCalverNo() = mrpCalverNo 
                           );
    } else {
      // æµ‹è¯•ç”¨é€»è¾‘，正常不应该走
      result := selectset( parent, Product_MP.ProductInStockingPoint_MP.ProductInStockingPointInPeriod, pispip,
                         true
                           true
                           );
    }
    info( "GetByMRPCalverNo : " + [String]result.Size() );
    return &result;
  *]
}

 _Main/UI/MacroPlannerWebApp/Component_Form633/Component_ListPRData#844.def

@@ -27,7 +27,7 @@
      ]
      Properties:
      [
        Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProductID","title":"ProductID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProductID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProductName","title":"ProductName","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProductName"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"IsPannelMaterial","title":"IsPannelMaterial","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"IsPannelMaterial"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProduceRequiredDate","title":"ProduceRequiredDate","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProduceRequiredDate"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"PRSuggestionDate","title":"PRSuggestionDate","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"PRSuggestionDate"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Quantity","title":"Quantity","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Quantity"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MRPCalverNo","title":"MRPCalverNo","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MRPCalverNo"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"BusinessType","title":"BusinessType","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"BusinessType"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OrganCode","title":"OrganCode","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OrganCode"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"IsLongLeadItem","title":"IsLongLeadItem","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"IsLongLeadItem"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"IsGenericMaterial","title":"IsGenericMaterial","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"IsGenericMaterial"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MaterialMRPType","title":"MaterialMRPType","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MaterialMRPType"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"LeadTime","title":"LeadTime","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"LeadTime"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProviderCode","title":"ProviderCode","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProviderCode"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProviderName","title":"ProviderName","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProviderName"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"StockingPointID","title":"StockingPointID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"StockingPointID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"UnitOfMeasure","title":"UnitOfMeasure","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"UnitOfMeasure"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SendStatus","title":"SendStatus","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SendStatus"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SendTimeString","title":"SendTimeString","subtotals":"","tooltip":"","width":-1,"display":"shown","attribute":"SendTimeString"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SendBy","title":"SendBy","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SendBy"}}]'
        Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProductID","title":"ProductID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProductID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProductName","title":"ProductName","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProductName"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"DeliveryDate","title":"DeliveryDate","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"DeliveryDate"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"PRSuggestionDate","title":"PRSuggestionDate","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"PRSuggestionDate"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Quantity","title":"Quantity","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Quantity"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MRPCalverNo","title":"MRPCalverNo","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MRPCalverNo"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"BusinessType","title":"BusinessType","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"BusinessType"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OrganCode","title":"OrganCode","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OrganCode"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"IsLongLeadItem","title":"IsLongLeadItem","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"IsLongLeadItem"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"IsGenericMaterial","title":"IsGenericMaterial","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"IsGenericMaterial"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MaterialMRPType","title":"MaterialMRPType","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MaterialMRPType"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"LeadTime","title":"LeadTime","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"LeadTime"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProviderCode","title":"ProviderCode","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProviderCode"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProviderName","title":"ProviderName","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProviderName"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"StockingPointID","title":"StockingPointID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"StockingPointID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"UnitOfMeasure","title":"UnitOfMeasure","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"UnitOfMeasure"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"PRReleaseStatus","title":"PRReleaseStatus","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"PRReleaseStatus"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CreateTimeString","title":"CreateTimeString","subtotals":"","tooltip":"","width":-1,"display":"shown","attribute":"CreateTimeString"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CreateBy","title":"CreateBy","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CreateBy"}}]'
        ContextMenu: 'listContextMenuPRData'
        SortCriteria: 'BusinessType;MRPCalverNo'
        Taborder: 1

 _Main/UI/MacroPlannerWebApp/Component_Form633/Response_PanelPRDataButton_ButtonExportPR_OnClick.def

@@ -7,7 +7,7 @@
  DefinitionID: 'Responsedef_WebButton_OnClick'
  Precondition:
  [*
    return not isnull( GlobalOTDTable );
    return not isnull( GlobalOTDTable ) and not isnull( MacroPlan );
  *]
  QuillAction
  {

 _Main/UI/MacroPlannerWebApp/Component_Form633/Response_PanelPRDataButton_ButtonLoad_OnClick.def

@@ -5,12 +5,16 @@
  #keys: '[414384.0.859141084]'
  CanBindMultiple: false
  DefinitionID: 'Responsedef_WebButton_OnClick'
  Precondition:
  [*
    return not isnull( MacroPlan );
  *]
  QuillAction
  {
    Body:
    [*
      MacroPlan.PRData( relflush );
      PRData::FromSupplyPlanning( GlobalOTDTable, MacroPlan, MacroPlan, "" );
      PRData::FromSupplyPlanning( GlobalOTDTable, MacroPlan, "", ApplicationMacroPlanner.GetUserName() );
    *]
    GroupServerCalls: false
  }

 _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 );
    *]
  }
}

 _Main/UI/MacroPlannerWebApp/Component_FormPRHistoryData/Component_ListPRHistoryData#844.def

@@ -27,7 +27,7 @@
      ]
      Properties:
      [
        Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProductID","title":"ProductID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProductID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProductName","title":"ProductName","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProductName"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProduceRequiredDate","title":"ProduceRequiredDate","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProduceRequiredDate"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Quantity","title":"Quantity","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Quantity"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MRPCalverNo","title":"MRPCalverNo","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MRPCalverNo"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"BusinessType","title":"BusinessType","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"BusinessType"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OrganCode","title":"OrganCode","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OrganCode"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProviderCode","title":"ProviderCode","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProviderCode"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProviderName","title":"ProviderName","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProviderName"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"StockingPointID","title":"StockingPointID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"StockingPointID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"UnitOfMeasure","title":"UnitOfMeasure","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"UnitOfMeasure"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SendStatus","title":"SendStatus","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SendStatus"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SendTimeString","title":"SendTimeString","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SendTimeString"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ReleaseBy","title":"ReleaseBy","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ReleaseBy"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ReceiveTimeString","title":"ReceiveTimeString","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ReceiveTimeString"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ReceiveStatus","title":"ReceiveStatus","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ReceiveStatus"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ReceiveError","title":"ReceiveError","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ReceiveError"}}]'
        Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"DataID","title":"DataID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"DataID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProductID","title":"ProductID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProductID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProductName","title":"ProductName","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProductName"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"DeliveryDate","title":"DeliveryDate","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"DeliveryDate"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Quantity","title":"Quantity","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Quantity"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"MRPCalverNo","title":"MRPCalverNo","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"MRPCalverNo"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"BusinessType","title":"BusinessType","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"BusinessType"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"OrganCode","title":"OrganCode","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"OrganCode"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProviderCode","title":"ProviderCode","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProviderCode"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ProviderName","title":"ProviderName","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ProviderName"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"StockingPointID","title":"StockingPointID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"StockingPointID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"UnitOfMeasure","title":"UnitOfMeasure","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"UnitOfMeasure"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"PreparerID","title":"PreparerID","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"PreparerID"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SendStatus","title":"SendStatus","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"SendStatus"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"SendTimeString","title":"SendTimeString","subtotals":"","tooltip":"","width":-1,"display":"shown","attribute":"SendTimeString"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ReleaseBy","title":"ReleaseBy","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ReleaseBy"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ReceiveStatus","title":"ReceiveStatus","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ReceiveStatus"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ReceiveTimeString","title":"ReceiveTimeString","subtotals":"","tooltip":"","width":-1,"display":"shown","attribute":"ReceiveTimeString"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ReceiveError","title":"ReceiveError","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ReceiveError"}}]'
        ContextMenu: 'listContextMenuPRHistoryData'
        SortCriteria: 'BusinessType;MRPCalverNo'
        Taborder: 1

 _Main/UI/MacroPlannerWebApp/Views/Capacity___sale_budge.vw

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,16 @@
Quintiq file version 2.0
{
  viewcontents
  {
    image: 'CHART_HI_LO'
    page: 'ActionBarPageScenarioComparison'
    group: ''
    index: 0
    description: ''
  }
  formatversion: 2
  id: 'Capacity___sale_budge'
  name: 'Capacity & sale budge'
  isglobal: false
  isroot: true
}

 _var/_Main/ProjSettings/MacroPlannerWebApp/Views/Capacity___sale_budge.vw

@@ -191,10 +191,10 @@
    userconfigurableinformation
    {
    }
    index: 0
    image: 'CHART_HI_LO'
    page: 'ActionBarPageScenarioComparison'
    group: ''
    index: 0
    description: ''
  }
  formatversion: 2

 _var/_Main/ProjSettings/MacroPlannerWebApp/Views/PR_DATA.vw

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,428 @@
Quintiq file version 2.0
{
  viewcontents
  {
    forms
    {
      form_legacy_1
      {
        title: 'Scenario manager'
        shown: true
        componentID: 'FormScenarioManager'
        layout
        {
          mode: 'open'
          rowPosition: 1
          rowSpan: 8
          columnPosition: 1
          columnSpan: 5
        }
        components
        {
          FormScenarioManager_ListScenario
          {
          }
          FormScenarioManager_DataSetLevelScenario
          {
            groupDepth: -1
            column_All_constraints
            {
              columnId: 'All constraints'
              dataPath: 'All constraints'
              dataType: 'string'
              title: 'All constraints'
              index: 0
              subtotals: ''
              width: 100
            }
            column_Name
            {
              columnId: 'Name'
              dataPath: 'Name'
              dataType: 'string'
              title: '名称'
              index: 1
              subtotals: ''
              width: 233
            }
            column_ChangedBy
            {
              columnId: 'ChangedBy'
              dataPath: 'ChangedBy'
              dataType: 'string'
              title: 'Changed by'
              index: 2
              subtotals: ''
              width: 86
            }
            column_ChangedOn
            {
              columnId: 'ChangedOn'
              dataPath: 'ChangedOn'
              dataType: 'datetime'
              title: 'Changed on'
              index: 3
              subtotals: ''
              width: 150
            }
            column_StorageMode
            {
              columnId: 'StorageMode'
              dataPath: 'StorageMode'
              dataType: 'string'
              title: 'StorageMode'
              index: 4
              subtotals: ''
              width: 40
            }
          }
        }
      }
      form_legacy_2
      {
        title: 'Assumptions'
        shown: true
        componentID: 'FormAssumptions'
        layout
        {
          mode: 'open'
          rowPosition: 9
          rowSpan: 8
          columnPosition: 1
          columnSpan: 5
        }
        components
        {
          FormAssumptions_ListAssumptions
          {
          }
          FormAssumptions_DataSetLevelAssumptions
          {
            groupDepth: -1
            column_All_constraints
            {
              columnId: 'All constraints'
              dataPath: 'All constraints'
              dataType: 'string'
              title: 'All constraints'
              index: 0
              subtotals: ''
              width: 32
            }
            column_Category
            {
              columnId: 'Category'
              dataPath: 'Category'
              dataType: 'string'
              title: '类别'
              index: 1
              subtotals: ''
              width: 162
            }
            column_Importance
            {
              columnId: 'Importance'
              dataPath: 'Importance'
              dataType: 'string'
              title: '重要性'
              index: 2
              subtotals: ''
              width: 104
            }
            column_Title
            {
              columnId: 'Title'
              dataPath: 'Title'
              dataType: 'string'
              title: '标题'
              index: 3
              subtotals: ''
              width: 150
            }
            column_ChangedBy
            {
              columnId: 'ChangedBy'
              dataPath: 'ChangedBy'
              dataType: 'string'
              title: 'Changed by'
              index: 4
              subtotals: ''
              width: 92
            }
            column_CreatedOn
            {
              columnId: 'CreatedOn'
              dataPath: 'CreatedOn'
              dataType: 'datetime'
              title: 'Created on'
              index: 5
              subtotals: ''
              width: 150
            }
          }
        }
      }
      form_legacy_4
      {
        title: 'Supply chain overview'
        shown: true
        componentID: 'FormSupplyChainOverview'
        layout
        {
          mode: 'open'
          rowPosition: 1
          rowSpan: 16
          columnPosition: 6
          columnSpan: 7
        }
        components
        {
          FormSupplyChainOverview_PanelToolbar
          {
            sizeRatio: 1
          }
          FormSupplyChainOverview_PanelSCO
          {
            sizeRatio: 1
          }
          FormSupplyChainOverview_CustomDrawSCO
          {
            forceFitY: false
            zoomX: 1
            zoomY: 1
            forceFitX: false
            backendState
            {
              componentId: 'QLibMacroPlannerWebUI::FormSupplyChainOverview.CustomDrawSCO'
              state
              {
              }
            }
          }
        }
      }
      form_FormPRHistoryData
      {
        title: 'QTIANMA_JITUAN::FormPRHistoryData'
        shown: true
        componentID: 'QTIANMA_JITUAN::FormPRHistoryData'
        layout
        {
          mode: 'open'
          rowPosition: 17
          rowSpan: 6
          columnPosition: 5
          columnSpan: 7
        }
        components
        {
          FormPRHistoryData_PanelPRHistoryButton
          {
            sizeRatio: 1
          }
          FormPRHistoryData_ListPRHistoryData
          {
          }
          FormPRHistoryData_DataSetLevelPRHistoryData
          {
            groupDepth: -1
            column_BusinessType
            {
              columnId: 'BusinessType'
              dataPath: 'BusinessType'
              dataType: 'string'
              index: 0
              subtotals: ''
              width: 150
            }
            column_MRPCalverNo
            {
              columnId: 'MRPCalverNo'
              dataPath: 'MRPCalverNo'
              dataType: 'string'
              index: 1
              subtotals: ''
              width: 150
            }
            column_OrganCode
            {
              columnId: 'OrganCode'
              dataPath: 'OrganCode'
              dataType: 'string'
              index: 2
              subtotals: ''
              width: 150
            }
            column_ProductID
            {
              columnId: 'ProductID'
              dataPath: 'ProductID'
              dataType: 'string'
              index: 3
              subtotals: ''
              width: 150
            }
            column_StockingPointID
            {
              columnId: 'StockingPointID'
              dataPath: 'StockingPointID'
              dataType: 'string'
              index: 4
              subtotals: ''
              width: 150
            }
            column_Quantity
            {
              columnId: 'Quantity'
              dataPath: 'Quantity'
              dataType: 'real'
              index: 5
              subtotals: ''
              width: 150
            }
            column_SendStatus
            {
              columnId: 'SendStatus'
              dataPath: 'SendStatus'
              dataType: 'string'
              index: 6
              subtotals: ''
              width: 150
            }
            column_ReleaseBy
            {
              columnId: 'ReleaseBy'
              dataPath: 'ReleaseBy'
              dataType: 'string'
              index: 7
              subtotals: ''
              width: 150
            }
            column_ReceiveStatus
            {
              columnId: 'ReceiveStatus'
              dataPath: 'ReceiveStatus'
              dataType: 'string'
              index: 8
              subtotals: ''
              width: 150
            }
            column_ReceiveError
            {
              columnId: 'ReceiveError'
              dataPath: 'ReceiveError'
              dataType: 'string'
              index: 9
              subtotals: ''
              width: 150
            }
          }
        }
      }
      form_FormPRData
      {
        title: 'QTIANMA_JITUAN::FormPRData'
        shown: true
        componentID: 'QTIANMA_JITUAN::FormPRData'
        layout
        {
          mode: 'open'
          rowPosition: 17
          rowSpan: 6
          columnPosition: 1
          columnSpan: 4
        }
        components
        {
          FormPRData_PanelPRDataButton
          {
            sizeRatio: 1
          }
          FormPRData_ListPRData
          {
          }
          FormPRData_DataSetLevelPRData
          {
            groupDepth: -1
            column_MRPCalverNo
            {
              columnId: 'MRPCalverNo'
              dataPath: 'MRPCalverNo'
              dataType: 'string'
              index: 0
              subtotals: ''
              width: 150
            }
            column_ProductID
            {
              columnId: 'ProductID'
              dataPath: 'ProductID'
              dataType: 'string'
              index: 1
              subtotals: ''
              width: 150
            }
            column_StockingPointID
            {
              columnId: 'StockingPointID'
              dataPath: 'StockingPointID'
              dataType: 'string'
              index: 2
              subtotals: ''
              width: 150
            }
            column_ProduceRequiredDate
            {
              columnId: 'ProduceRequiredDate'
              dataPath: 'ProduceRequiredDate'
              dataType: 'date'
              index: 3
              subtotals: ''
              width: 150
            }
            column_Quantity
            {
              columnId: 'Quantity'
              dataPath: 'Quantity'
              dataType: 'real'
              index: 4
              subtotals: ''
              width: 150
            }
            column_SendStatus
            {
              columnId: 'SendStatus'
              dataPath: 'SendStatus'
              dataType: 'string'
              index: 5
              subtotals: ''
              width: 150
            }
            column_SendBy
            {
              columnId: 'SendBy'
              dataPath: 'SendBy'
              dataType: 'string'
              index: 6
              subtotals: ''
              width: 150
            }
          }
        }
      }
    }
    userconfigurableinformation
    {
    }
    image: 'WORM'
    page: 'ActionBarPageData'
    group: ''
    index: 0
    description: 'PR申请'
  }
  formatversion: 2
  id: 'PR_DATA'
  name: 'PR_DATA'
  isglobal: false
  isroot: true
}