DOI_DSI和客户等级Broker

hongjli

2023-09-26 601aa18097a6cf0d0223244bd37436942b98a435

DOI_DSI和客户等级Broker

 _Main/BL/EDI/Broker_GlobalOTDTable_CustomerGrade.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,64 @@
Quintiq file version 2.0
#parent: #root
EDIBroker GlobalOTDTable_CustomerGrade
{
  MDSDefinition: GlobalOTDTable
  TimeZone: 'ACT'
  UseOSTimeZone: false
  EDIModelLink.Destination Destination16
  {
    EDIMLTable Global_MappingCustomerGrade
    {
      PrimaryKeyColumns: BusinessType
      PrimaryKeyColumns: Customer
      PrimaryKeyColumns: CustomerGrade
      TargetType: Global_MappingCustomerGrade
      TypeIndex: Global_MappingCustomerGradeTypeIndex
      EDIMLColumn BusinessType { Attribute: BusinessType ValueType: String }
      EDIMLColumn Customer { Attribute: Customer ValueType: String }
      EDIMLColumn CustomerGrade { Attribute: CustomerGrade ValueType: String }
    }
  }
  EDIODBCLink.Source Source15
  {
    DataIntegrityStrategy: 'Disabled'
    SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.oracle'
    EDIODBCLinkTable MID_CUSTOMERGRADE
    {
      OthersMayCreateTable: true
      OthersMayDeleteRow: true
      OthersMayDropTable: true
      OthersMayFlushTable: true
      OthersMayInsertRow: true
      Parameters: '/owner="OTD"'
      PrimaryKeyColumns: CUSTOMER
      RecordModificationHintStrategy: 'None'
      EDIODBCLinkColumn BUSINESSTYPE
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn CUSTOMER
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn CUSTOMERGRADE
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
    }
  }
  EDITransformation.Transformation Transformation15
  {
    EDITableTransformation
    {
      InputTable: MID_CUSTOMERGRADE
      OutputTable: Global_MappingCustomerGrade
      EDIColumnMatch { InputColumn: BUSINESSTYPE OutputColumn: BusinessType }
      EDIColumnMatch { InputColumn: CUSTOMER OutputColumn: Customer }
      EDIColumnMatch { InputColumn: CUSTOMERGRADE OutputColumn: CustomerGrade }
    }
  }
}

 _Main/BL/EDI/Broker_GlobalOTDTable_DOI_DSI.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,71 @@
Quintiq file version 2.0
#parent: #root
EDIBroker GlobalOTDTable_DOI_DSI
{
  MDSDefinition: GlobalOTDTable
  TimeZone: 'ACT'
  UseOSTimeZone: false
  EDIModelLink.Destination Destination15
  {
    EDIMLTable Global_MappingDOI_DSI
    {
      PrimaryKeyColumns: OrganCode
      PrimaryKeyColumns: ProductID
      TargetType: Global_MappingDOI_DSI
      TypeIndex: Global_MappingDOI_DSITypeIndex
      EDIMLColumn DOI { Attribute: DOI ValueType: String }
      EDIMLColumn DSI { Attribute: DSI ValueType: String }
      EDIMLColumn OrganCode { Attribute: OrganCode ValueType: String }
      EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
    }
  }
  EDIODBCLink.Source Source14
  {
    DataIntegrityStrategy: 'Disabled'
    SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.oracle'
    EDIODBCLinkTable MID_DOI_DSI
    {
      OthersMayCreateTable: true
      OthersMayDeleteRow: true
      OthersMayDropTable: true
      OthersMayFlushTable: true
      OthersMayInsertRow: true
      Parameters: '/owner="OTD"'
      PrimaryKeyColumns: ORGANCODE
      PrimaryKeyColumns: PRODUCTID
      RecordModificationHintStrategy: 'None'
      EDIODBCLinkColumn DOI
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn DSI
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn ORGANCODE
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn PRODUCTID
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
    }
  }
  EDITransformation.Transformation Transformation14
  {
    EDITableTransformation
    {
      InputTable: MID_DOI_DSI
      OutputTable: Global_MappingDOI_DSI
      EDIColumnMatch { InputColumn: DOI OutputColumn: DOI }
      EDIColumnMatch { InputColumn: DSI OutputColumn: DSI }
      EDIColumnMatch { InputColumn: ORGANCODE OutputColumn: OrganCode }
      EDIColumnMatch { InputColumn: PRODUCTID OutputColumn: ProductID }
    }
  }
}

 _Main/BL/Relations/Relation_Global_MappingCustomerGrade_GlobalOTDTable_GlobalOTDTable_Global_Ma.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,23 @@
Quintiq file version 2.0
#parent: #root
Relation Global_MappingCustomerGrade_GlobalOTDTable_GlobalOTDTable_Global_MappingCustomerGrade
{
  #keys: '1[414702.0.445485678]'
  DefaultRelationStrategy
  {
  }
  RelationSide.LeftSide GlobalOTDTable
  {
    #keys: '3[414702.0.445485680][414702.0.445485679][414702.0.445485681]'
    Cardinality: '0to1'
    ObjectDefinition: Global_MappingCustomerGrade
    OwningSide: 'Reference'
  }
  RelationSide.RightSide Global_MappingCustomerGrade
  {
    #keys: '3[414702.0.445485683][414702.0.445485682][414702.0.445485684]'
    Cardinality: '1toN'
    ObjectDefinition: GlobalOTDTable
    OwningSide: 'Owned'
  }
}

 _Main/BL/Relations/Relation_Global_MappingDOI_DSI_GlobalOTDTable_GlobalOTDTable_Global_MappingD.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,23 @@
Quintiq file version 2.0
#parent: #root
Relation Global_MappingDOI_DSI_GlobalOTDTable_GlobalOTDTable_Global_MappingDOI_DSI
{
  #keys: '1[414702.0.445364657]'
  DefaultRelationStrategy
  {
  }
  RelationSide.LeftSide GlobalOTDTable
  {
    #keys: '3[414702.0.445364659][414702.0.445364658][414702.0.445364660]'
    Cardinality: '0to1'
    ObjectDefinition: Global_MappingDOI_DSI
    OwningSide: 'Reference'
  }
  RelationSide.RightSide Global_MappingDOI_DSI
  {
    #keys: '3[414702.0.445364662][414702.0.445364661][414702.0.445364663]'
    Cardinality: '1toN'
    ObjectDefinition: GlobalOTDTable
    OwningSide: 'Owned'
  }
}

 _Main/BL/Type_GlobalDTOTable/Method_OnAsyncExecuteFailure_GlobalOTDTable_CustomerGrade.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,20 @@
Quintiq file version 2.0
#parent: #root
Method OnAsyncExecuteFailure_GlobalOTDTable_CustomerGrade (
  Number errorNo,
  String errorMessage
)
{
  TextBody:
  [*
    this.Global_BrokerExecuteLog( relnew,
                                  BrokerName    := "GlobalOTDTable_CustomerGrade",
                                  ElementTotal  := 0,
                                  ErrorMessage  := errorMessage,
                                  IsSuccess     := false,
                                  Name          := "客户等级数据",
                                  ErrorNo       := errorNo,
                                  ErrorDateTime := DateTime::ActualTime().Format( "Y-M-D H2:m:s" )
                                 );
  *]
}

 _Main/BL/Type_GlobalDTOTable/Method_OnAsyncExecuteFailure_GlobalOTDTable_DOI_DSI.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,20 @@
Quintiq file version 2.0
#parent: #root
Method OnAsyncExecuteFailure_GlobalOTDTable_DOI_DSI (
  Number errorNo,
  String errorMessage
)
{
  TextBody:
  [*
    this.Global_BrokerExecuteLog( relnew,
                                  BrokerName    := "GlobalOTDTable_DOI_DSI",
                                  ElementTotal  := 0,
                                  ErrorMessage  := errorMessage,
                                  IsSuccess     := false,
                                  Name          := "DOI_DSI数据",
                                  ErrorNo       := errorNo,
                                  ErrorDateTime := DateTime::ActualTime().Format( "Y-M-D H2:m:s" )
                                 );
  *]
}

 _Main/BL/Type_GlobalDTOTable/Method_OnAsyncExecute_GlobalOTDTable_CustomerGrade.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,17 @@
Quintiq file version 2.0
#parent: #root
Method OnAsyncExecute_GlobalOTDTable_CustomerGrade
{
  TextBody:
  [*
    this.Global_BrokerExecuteLog( relnew,
                                  BrokerName      := "GlobalOTDTable_CustomerGrade",
                                  ElementTotal    := this.Global_MappingCustomerGrade( relsize ),
                                  ErrorMessage    := "",
                                  IsSuccess       := true,
                                  Name            := "客户等级数据",
                                  SuccessDateTime := DateTime::ActualTime().Format( "Y-M-D H2:m:s" ),
                                  ErrorNo         := 0
                                 );
  *]
}

 _Main/BL/Type_GlobalDTOTable/Method_OnAsyncExecute_GlobalOTDTable_DOI_DSI.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,17 @@
Quintiq file version 2.0
#parent: #root
Method OnAsyncExecute_GlobalOTDTable_DOI_DSI
{
  TextBody:
  [*
    this.Global_BrokerExecuteLog( relnew,
                                  BrokerName      := "GlobalOTDTable_DOI_DSI",
                                  ElementTotal    := this.Global_MappingDOI_DSI( relsize ),
                                  ErrorMessage    := "",
                                  IsSuccess       := true,
                                  Name            := "DOI_DSI数据",
                                  SuccessDateTime := DateTime::ActualTime().Format( "Y-M-D H2:m:s" ),
                                  ErrorNo         := 0
                                 );
  *]
}

 _Main/BL/Type_GlobalDTOTable/StaticMethod_SynchronizationAllMappingBrokerAndAPI.qbl

@@ -25,6 +25,8 @@
    globalOTDTable.Global_MappingOperationCost( relflush );
    globalOTDTable.Global_MappingForecast( relflush );
    globalOTDTable.Global_MappingCustomOrder( relflush );
    globalOTDTable.Global_MappingDOI_DSI( relflush );
    globalOTDTable.Global_MappingCustomerGrade( relflush );
    
    globalOTDTable.GlobalOTDTable_UnitOfMeasure_MP().AsyncExecute();
    globalOTDTable.GlobalOTDTable_SalesSegment_MP().AsyncExecute();
@@ -44,5 +46,7 @@
    globalOTDTable.GlobalOTDTable_OperationCost().AsyncExecute();
    globalOTDTable.GlobalOTDTable_Forecast().AsyncExecute();
    globalOTDTable.GlobalOTDTable_CustomOrder().AsyncExecute();
    globalOTDTable.GlobalOTDTable_DOI_DSI().AsyncExecute();
    globalOTDTable.GlobalOTDTable_CustomerGrade().AsyncExecute();
  *]
}

 _Main/BL/Type_Global_MappingCustomerGrade/Attribute_BusinessType.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,9 @@
Quintiq file version 2.0
#parent: #root
Attribute BusinessType
{
  #keys: '3[414702.0.445738362][414702.0.445738361][414702.0.445738363]'
  Description: '事业部'
  IsReadOnly: true
  ValueType: String
}

 _Main/BL/Type_Global_MappingCustomerGrade/Attribute_Customer.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,9 @@
Quintiq file version 2.0
#parent: #root
Attribute Customer
{
  #keys: '3[414702.0.445738352][414702.0.445738351][414702.0.445738353]'
  Description: '客户名称'
  IsReadOnly: true
  ValueType: String
}

 _Main/BL/Type_Global_MappingCustomerGrade/Attribute_CustomerGrade.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,9 @@
Quintiq file version 2.0
#parent: #root
Attribute CustomerGrade
{
  #keys: '3[414702.0.445738372][414702.0.445738371][414702.0.445738373]'
  Description: '客户等级'
  IsReadOnly: true
  ValueType: String
}

 _Main/BL/Type_Global_MappingCustomerGrade/TypeIndex_Global_MappingCustomerGradeTypeIndex.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,20 @@
Quintiq file version 2.0
#parent: #root
TypeIndex Global_MappingCustomerGradeTypeIndex
{
  Attributes:
  [
    TypeIndexAttribute
    {
      ModelElement: BusinessType
    }
    TypeIndexAttribute
    {
      ModelElement: Customer
    }
    TypeIndexAttribute
    {
      ModelElement: CustomerGrade
    }
  ]
}

 _Main/BL/Type_Global_MappingCustomerGrade/_ROOT_Type_Global_MappingCustomerGrade.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,9 @@
Quintiq file version 2.0
#root
#parent: #DomainModel
Type Global_MappingCustomerGrade
{
  #keys: '5[414702.0.445485672][414702.0.445485670][0.0.0][414702.0.445485671][414702.0.445485673]'
  BaseType: Object
  StructuredName: 'Global_MappingCustomerGrades'
}

 _Main/BL/Type_Global_MappingDOI_DSI/Attribute_DOI.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute DOI
{
  #keys: '3[414702.0.445364709][414702.0.445364708][414702.0.445364710]'
  Description: '库存周转天数'
  ValueType: String
}

 _Main/BL/Type_Global_MappingDOI_DSI/Attribute_DSI.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,8 @@
Quintiq file version 2.0
#parent: #root
Attribute DSI
{
  #keys: '3[414702.0.445364719][414702.0.445364718][414702.0.445364720]'
  Description: '库存可售天数'
  ValueType: String
}

 _Main/BL/Type_Global_MappingDOI_DSI/Attribute_OrganCode.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,9 @@
Quintiq file version 2.0
#parent: #root
Attribute OrganCode
{
  #keys: '3[414702.0.445364699][414702.0.445364698][414702.0.445364700]'
  Description: '组织编码'
  IsReadOnly: true
  ValueType: String
}

 _Main/BL/Type_Global_MappingDOI_DSI/Attribute_ProductID.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,9 @@
Quintiq file version 2.0
#parent: #root
Attribute ProductID
{
  #keys: '3[414702.0.445364677][414702.0.445364676][414702.0.445364678]'
  Description: '物料编码'
  IsReadOnly: true
  ValueType: String
}

 _Main/BL/Type_Global_MappingDOI_DSI/TypeIndex_Global_MappingDOI_DSITypeIndex.qbl

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

 _Main/BL/Type_Global_MappingDOI_DSI/_ROOT_Type_Global_MappingDOI_DSI.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,9 @@
Quintiq file version 2.0
#root
#parent: #DomainModel
Type Global_MappingDOI_DSI
{
  #keys: '5[414702.0.445364654][414702.0.445364652][0.0.0][414702.0.445364653][414702.0.445364655]'
  BaseType: Object
  StructuredName: 'Global_MappingDOI_DSIs'
}