D365: 实体自定义暂存表到目标表

当提供的模板文件不能满足D365数据表的数据结构或者模板的数据不能直接通过DMF导入到实际的业务表时,我们按照模板自定义实体后,可以实现如下方法来将暂存表的数据通过一定的逻辑处理,将数据转换到我们的业务表中,sample代码如下

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
public static container copyCustomStagingToTarget(DMFDefinitionGroupExecution _dmfDefinitionGroupExecution)
{
    CustCustomerStaging staging;
    CustCustomerStaging stagingUpd;
     
    // Iterate through all records with have not been processed
    while select forupdate staging
        where staging.ExecutionId    == _dmfDefinitionGroupExecution.ExecutionId
        &&   (staging.TransferStatus == DMFTransferStatus::NotStarted || staging.TransferStatus == DMFTransferStatus::Validated)
    {
        try
        {
            ttsbegin;
            // Do your stuff
 
            staging.TransferStatus = DMFTransferStatus::Completed;
            staging.update();
            ttscommit;
        }
        catch (Exception::Error)
        {
            error("Something wrong has happened.");
        }
    }   
 
    ttsbegin;
    update_recordset staging
        setting TransferStatus = DMFTransferStatus::Error
        where staging.DefinitionGroup == _dmfDefinitionGroupExecution.DefinitionGroup
        &&    staging.ExecutionId     == _dmfDefinitionGroupExecution.ExecutionId
        &&   (staging.TransferStatus == DMFTransferStatus::NotStarted || staging.TransferStatus == DMFTransferStatus::Validated);
    ttscommit;
 
    // Method returns a container containing the quantities of inserted and updated records.
    select count(RecId) from staging
        where staging.DefinitionGroup == _dmfDefinitionGroupExecution.DefinitionGroup
            && staging.ExecutionId == _dmfDefinitionGroupExecution.ExecutionId
            && staging.TransferStatus == DMFTransferStatus::Completed;
 
    return [staging.RecId, 0];
}

需要注意的是,如下想上面的方法被正常执行,我们需要勾上实体上的Set-based processing字段

posted @   adingkui  阅读(92)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 微软正式发布.NET 10 Preview 1:开启下一代开发框架新篇章
· 没有源码,如何修改代码逻辑?
· DeepSeek R1 简明指南:架构、训练、本地部署及硬件要求
· NetPad:一个.NET开源、跨平台的C#编辑器
· PowerShell开发游戏 · 打蜜蜂
点击右上角即可分享
微信分享提示