异步分发接口优化

hongjli

2023-10-25 9cc8c01dd325c9e29dd7a8fc5521148e26978a1c

异步分发接口优化

 _Main/BL/Relations/Relation_DataInterfaceLog_GlobalOTDLog_GlobalOTDLog_DataInterfaceLog.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,23 @@
Quintiq file version 2.0
#parent: #root
Relation DataInterfaceLog_GlobalOTDLog_GlobalOTDLog_DataInterfaceLog
{
  #keys: '1[414702.1.240820064]'
  DefaultRelationStrategy
  {
  }
  RelationSide.LeftSide GlobalOTDLog
  {
    #keys: '3[414702.1.240820066][414702.1.240820065][414702.1.240820067]'
    Cardinality: '0to1'
    ObjectDefinition: DataInterfaceLog
    OwningSide: 'Reference'
  }
  RelationSide.RightSide DataInterfaceLog
  {
    #keys: '3[414702.1.240820069][414702.1.240820068][414702.1.240820070]'
    Cardinality: '1toN'
    ObjectDefinition: GlobalOTDLog
    OwningSide: 'Owned'
  }
}

 _Main/BL/Type_DataInterfaceLog/Attribute_CreateDate.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,7 @@
Quintiq file version 2.0
#parent: #root
Attribute CreateDate
{
  #keys: '3[414702.1.240820091][414702.1.240820090][414702.1.240820092]'
  ValueType: DateTime
}

 _Main/BL/Type_DataInterfaceLog/Attribute_ErrorMessage.qbl

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

 _Main/BL/Type_DataInterfaceLog/Attribute_ErrorNo.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,7 @@
Quintiq file version 2.0
#parent: #root
Attribute ErrorNo
{
  #keys: '3[414702.1.240820111][414702.1.240820110][414702.1.240820112]'
  ValueType: Number
}

 _Main/BL/Type_DataInterfaceLog/Attribute_ExecuteStatus.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,14 @@
Quintiq file version 2.0
#parent: #root
Attribute ExecuteStatus
{
  #keys: '3[414702.1.240820121][414702.1.240820120][414702.1.240820122]'
  Description:
  [*
    æ‰§è¡ŒçŠ¶æ€
    Running
    Success
    Error
  *]
  ValueType: String
}

 _Main/BL/Type_DataInterfaceLog/Attribute_ExecuteUser.qbl

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

 _Main/BL/Type_DataInterfaceLog/Attribute_ID.qbl

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

 _Main/BL/Type_DataInterfaceLog/Attribute_Message.qbl

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

 _Main/BL/Type_DataInterfaceLog/StaticMethod_Create.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,15 @@
Quintiq file version 2.0
#parent: #root
StaticMethod Create (
  GlobalOTDLog globalOTDLog,
  String executeUser
)
{
  TextBody:
  [*
    globalOTDLog.DataDistributionLog( relnew,
                                      ExecuteStatus  := "Running",
                                      ExecuteUser    := executeUser
                                     );
  *]
}

 _Main/BL/Type_DataInterfaceLog/StaticMethod_OnError.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,18 @@
Quintiq file version 2.0
#parent: #root
StaticMethod OnError (
  GlobalOTDLog globalOTDLog,
  Number errorNo,
  String errorMessage,
  String ID
)
{
  TextBody:
  [*
    targetDataInterfaceLog := select( globalOTDLog, DataInterfaceLog, tempDI, tempDI.ID() = ID );
    
    targetDataInterfaceLog.ExecuteStatus( "Error" );
    targetDataInterfaceLog.ErrorNo( errorNo );
    targetDataInterfaceLog.ErrorMessage( errorMessage );
  *]
}

 _Main/BL/Type_DataInterfaceLog/StaticMethod_OnSuccess.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,14 @@
Quintiq file version 2.0
#parent: #root
StaticMethod OnSuccess (
  GlobalOTDLog globalOTDLog,
  String ID
)
{
  TextBody:
  [*
    targetDataInterfaceLog := select( globalOTDLog, DataInterfaceLog, tempDI, tempDI.ID() = ID );
    
    targetDataInterfaceLog.ExecuteStatus( "Success" );
  *]
}

 _Main/BL/Type_DataInterfaceLog/_ROOT_Type_DataInterfaceLog.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,9 @@
Quintiq file version 2.0
#root
#parent: #DomainModel
Type DataInterfaceLog
{
  #keys: '5[414702.1.240820045][414702.1.240820043][0.0.0][414702.1.240820044][414702.1.240820046]'
  BaseType: Object
  StructuredName: 'DataInterfaceLogs'
}

 _Main/BL/Type_GlobalDTOTable/StaticMethod_DeleteAllMappingData.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,30 @@
Quintiq file version 2.0
#parent: #root
StaticMethod DeleteAllMappingData (
  GlobalOTDTable globalOTDTable
)
{
  TextBody:
  [*
    globalOTDTable.Global_MappingCustomOrder( relflush );
    globalOTDTable.Global_MappingForecast( relflush );
    globalOTDTable.Global_MappingUnitOfMeasure_MP( relflush );
    globalOTDTable.Global_MappingSalesSegment_MP( relflush );
    globalOTDTable.Global_MappingProduct_MP( relflush );
    globalOTDTable.Global_MappingConversionFactor( relflush );
    globalOTDTable.Global_MappingOperation( relflush );
    globalOTDTable.Global_MappingOperationBOM( relflush );
    globalOTDTable.Global_MappingProductInLane( relflush );
    globalOTDTable.Global_MappingActualProductInStockingPointInPeriod( relflush );
    globalOTDTable.Global_MappingInventorySupply( relflush );
    globalOTDTable.Global_MappingStockingPointCost( relflush );
    globalOTDTable.Global_MappingOperationCost( relflush );
    globalOTDTable.Global_MappingDOI_DSI( relflush );
    globalOTDTable.Global_MappingCustomerGrade( relflush );
    globalOTDTable.Global_MappingStockingPoint_MP( relflush );
    globalOTDTable.Global_MappingCurrency_MP( relflush );
    globalOTDTable.Global_MappingCurrencyRate_MP( relflush );
    globalOTDTable.Global_MappingLane( relflush );
    globalOTDTable.Global_MappingLaneLeg( relflush );
  *]
}

 _Main/Sys/ImgAttr/DataInterfaceLog.dme

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,31 @@
Quintiq file version 2.0
#parent: #root
TypeDataInterface DataInterfaceLog
{
  TypeKey: '[414702.1.240820043]'
  ImageDataMember ImgExecuteStatus
  {
    #keys: '1[414702.1.241719046]'
    ImageSpecifications:
    [
      ImageDataMemberImageSpecification
      {
        Image: 'MEDIA_PLAY_GREEN'
        Quill: 'object.ExecuteStatus() = "Running"'
        Value: 'Running'
      }
      ImageDataMemberImageSpecification
      {
        Image: 'CHECK'
        Quill: 'object.ExecuteStatus() = "Success"'
        Value: 'Success'
      }
      ImageDataMemberImageSpecification
      {
        Image: 'DELETE2'
        Quill: 'object.ExecuteStatus() = "Error"'
        Value: 'Error'
      }
    ]
  }
}

 _Main/UI/MacroPlannerWebApp/Component_FormDataInterfaceLog/Component_ListDataInterfaceLog.def

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,59 @@
Quintiq file version 2.0
Component ListDataInterfaceLog
{
  #keys: '[414702.1.239680981]'
  BaseType: 'WebList'
  Children:
  [
    Component DataExtractorDataInterfaceLog
    {
      #keys: '[414702.1.239680982]'
      BaseType: 'WebDataExtractor'
      Properties:
      [
        DataType: 'GlobalOTDLog'
        Source: 'GlobalOTDLog'
        Taborder: 0
        Transformation: 'DataInterfaceLog'
      ]
    }
    #child: listActionBarPageDataInterfaceLog
    Component DataSetLevelDataInterfaceLog
    {
      #keys: '[414702.1.239680987]'
      BaseType: 'WebDataSetLevel'
      Children:
      [
        #child: listContextMenuDataInterfaceLog
      ]
      Properties:
      [
        Columns: '[{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ImgExecuteStatus","title":"ImgExecuteStatus","subtotals":"","tooltip":"","width":-1,"display":"shown","attribute":"ImgExecuteStatus"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"Message","title":"日志信息","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"Message"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"CreateDate","title":"创建时间","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"CreateDate"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ErrorNo","title":"错误号","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ErrorNo"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ErrorMessage","title":"错误消息","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ErrorMessage"}},{"attribute":{"classtype":"WebApiDefinitionAttributeDataMember","columnid":"ExecuteUser","title":"执行用户","subtotals":"","tooltip":"","width":-1,"display":"shown","editable":false,"attribute":"ExecuteUser"}}]'
        ContextMenu: 'listContextMenuDataInterfaceLog'
        Taborder: 2
      ]
    }
  ]
  Properties:
  [
    Taborder: 1
  ]
  ResponseDefinitions:
  [
    DelegatedResponseDefinition OnClick id:Responsedef_ListDataInterfaceLog_WebMenu_OnClick
    {
      #keys: '[414702.1.241608270]'
      Initiator: 'WebMenu'
      IsInherited: false
      ResponseType: 'OnClick'
      Arguments:
      [
        ResponseDefinitionArgument selection
        {
          #keys: '[517.0.24916696]'
          Binding: 'this.Selection()'
        }
      ]
    }
  ]
}

 _Main/UI/MacroPlannerWebApp/Component_FormDataInterfaceLog/Component_PanelDataInterfaceLog.def

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,26 @@
Quintiq file version 2.0
Component PanelDataInterfaceLog
{
  #keys: '[414702.1.241718154]'
  BaseType: 'WebPanel'
  Children:
  [
    Component ButtonDeleteMappingData
    {
      #keys: '[414702.1.241609042]'
      BaseType: 'WebButton'
      Properties:
      [
        Image: 'GARBAGE'
        Label: '删除所有中间表数据'
        Taborder: 0
      ]
    }
  ]
  Properties:
  [
    FixedSize: true
    Orientation: 'horizontal'
    Taborder: 0
  ]
}

 _Main/UI/MacroPlannerWebApp/Component_FormDataInterfaceLog/Component_listActionBarPageDataInterfaceLog.def

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,10 @@
Quintiq file version 2.0
Component listActionBarPageDataInterfaceLog
{
  #keys: '[414702.1.239680984]'
  BaseType: 'listActionBarPage'
  Properties:
  [
    Taborder: 1
  ]
}

 _Main/UI/MacroPlannerWebApp/Component_FormDataInterfaceLog/Component_listContextMenuDataInterfaceLog.def

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,36 @@
Quintiq file version 2.0
Component listContextMenuDataInterfaceLog
{
  #keys: '[414702.1.239680989]'
  BaseType: 'listContextMenu'
  Children:
  [
    Component MenuDelete
    {
      #keys: '[414702.1.241377626]'
      BaseType: 'WebMenu'
      Properties:
      [
        Image: 'DELETE'
        Taborder: 3
        Title: '删除'
      ]
    }
    Component MenuSelectionAll
    {
      #keys: '[414702.1.239663154]'
      BaseType: 'WebMenu'
      Properties:
      [
        Image: 'SELECTION'
        Shortcut: 'Ctrl+A'
        Taborder: 4
        Title: '全选'
      ]
    }
  ]
  Properties:
  [
    Taborder: 0
  ]
}

 _Main/UI/MacroPlannerWebApp/Component_FormDataInterfaceLog/Response_ListDataInterfaceLog_MenuDelete_OnClick.def

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,18 @@
Quintiq file version 2.0
#parent: ListDataInterfaceLog
Response OnClick (
  DataInterfaceLog selection
) id:Response_ListDataInterfaceLog_MenuDelete_OnClick
{
  #keys: '[414702.1.239692167]'
  DefinitionID => /ListDataInterfaceLog/Responsedef_ListDataInterfaceLog_WebMenu_OnClick
  Initiator: 'MenuDelete'
  QuillAction
  {
    Body:
    [*
      selection.Delete();
    *]
    GroupServerCalls: false
  }
}

 _Main/UI/MacroPlannerWebApp/Component_FormDataInterfaceLog/Response_ListDataInterfaceLog_MenuSelectionAll_OnClick.def

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,17 @@
Quintiq file version 2.0
#parent: ListDataInterfaceLog
Response OnClick () id:Response_ListDataInterfaceLog_MenuSelectionAll_OnClick
{
  #keys: '[414702.1.241718079]'
  CanBindMultiple: false
  DefinitionID => /ListDataInterfaceLog/Responsedef_ListDataInterfaceLog_WebMenu_OnClick
  Initiator: 'MenuSelectionAll'
  QuillAction
  {
    Body:
    [*
      this.SelectAll();
    *]
    GroupServerCalls: false
  }
}

 _Main/UI/MacroPlannerWebApp/Component_FormDataInterfaceLog/Response_PanelDataInterfaceLog_ButtonDeleteMappingData_OnClick.def

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,20 @@
Quintiq file version 2.0
#parent: PanelDataInterfaceLog/ButtonDeleteMappingData
Response OnClick () id:Response_PanelDataInterfaceLog_ButtonDeleteMappingData_OnClick
{
  #keys: '[414702.1.239672495]'
  CanBindMultiple: false
  DefinitionID: 'Responsedef_WebButton_OnClick'
  Precondition:
  [*
    return not isnull( GlobalOTDTable );
  *]
  QuillAction
  {
    Body:
    [*
      GlobalOTDTable::DeleteAllMappingData( GlobalOTDTable );
    *]
    GroupServerCalls: false
  }
}

 _Main/UI/MacroPlannerWebApp/Component_FormDataInterfaceLog/_ROOT_Component_FormDataInterfaceLog.def

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,18 @@
Quintiq file version 2.0
#root
#parent: MacroPlannerWebApp
OrphanComponent FormDataInterfaceLog
{
  #keys: '[414702.1.239641060]'
  BaseType: 'WebForm'
  Children:
  [
    #child: ListDataInterfaceLog
    #child: PanelDataInterfaceLog
  ]
  Properties:
  [
    Image: 'MUSHROOM'
    Title: '数据接口日志'
  ]
}

 _Main/UI/MacroPlannerWebApp/Component_FormInterfaceTest/Response_Button5_OnClick.def

@@ -5,10 +5,6 @@
  #keys: '[414702.1.228751233]'
  CanBindMultiple: false
  DefinitionID: 'Responsedef_WebButton_OnClick'
  Precondition:
  [*
    
  *]
  QuillAction
  {
    Body:

 _Main/UI/MacroPlannerWebApp/Views/½Ó¿Ú²âÊÔ.vw

@@ -13,7 +13,7 @@
        {
          mode: 'open'
          rowPosition: 1
          rowSpan: 23
          rowSpan: 17
          columnPosition: 1
          columnSpan: 6
        }
@@ -152,7 +152,7 @@
        {
          mode: 'open'
          rowPosition: 1
          rowSpan: 23
          rowSpan: 28
          columnPosition: 7
          columnSpan: 6
        }
@@ -1180,6 +1180,88 @@
          }
        }
      }
      form_FormDataInterfaceLog
      {
        title: 'QTIANMA_JITUAN::FormDataInterfaceLog'
        shown: true
        componentID: 'QTIANMA_JITUAN::FormDataInterfaceLog'
        layout
        {
          mode: 'open'
          rowPosition: 18
          rowSpan: 11
          columnPosition: 1
          columnSpan: 6
        }
        components
        {
          FormDataInterfaceLog_PanelDataInterfaceLog
          {
            sizeRatio: 1
          }
          FormDataInterfaceLog_ListDataInterfaceLog
          {
          }
          FormDataInterfaceLog_DataSetLevelDataInterfaceLog
          {
            groupDepth: -1
            column_ImgExecuteStatus
            {
              columnId: 'ImgExecuteStatus'
              dataPath: 'ImgExecuteStatus'
              dataType: 'string'
              index: 0
              subtotals: ''
              width: 40
            }
            column_Message
            {
              columnId: 'Message'
              dataPath: 'Message'
              dataType: 'string'
              index: 1
              subtotals: ''
              width: 150
            }
            column_CreateDate
            {
              columnId: 'CreateDate'
              dataPath: 'CreateDate'
              dataType: 'datetime'
              index: 2
              subtotals: ''
              width: 150
            }
            column_ErrorNo
            {
              columnId: 'ErrorNo'
              dataPath: 'ErrorNo'
              dataType: 'number'
              index: 3
              subtotals: ''
              width: 150
            }
            column_ErrorMessage
            {
              columnId: 'ErrorMessage'
              dataPath: 'ErrorMessage'
              dataType: 'string'
              index: 4
              subtotals: ''
              width: 150
            }
            column_ExecuteUser
            {
              columnId: 'ExecuteUser'
              dataPath: 'ExecuteUser'
              dataType: 'string'
              index: 5
              subtotals: ''
              width: 150
            }
          }
        }
      }
    }
    userconfigurableinformation
    {