Dynamics 365将多选字段的显示名称存储到文本字段，用于SSRS报表

1
using Microsoft.Crm.Sdk.Messages;
2
using Microsoft.Xrm.Sdk;
3
using Microsoft.Xrm.Sdk.Messages;
4
using Microsoft.Xrm.Sdk.Metadata;
5
using Microsoft.Xrm.Sdk.Query;
6
using System;
7
using System.Collections.Generic;
8
using System.IdentityModel.Metadata;
9
using System.Linq;
10
using System.Runtime.Remoting.Services;
11
using System.Text;
12
using System.Threading;
13
using System.Threading.Tasks;
14

15
namespace Blog.D365.Plugins.Contact
16
{
17
    public class ContactPostUpdatePlugin : IPlugin
18
    {
19
        public void Execute(IServiceProvider serviceProvider)
20
        {
21
            ITracingService tracer = (ITracingService)serviceProvider.GetService(typeof(ITracingService));
22
            IPluginExecutionContext context =
23
                (IPluginExecutionContext)serviceProvider.GetService(typeof(IPluginExecutionContext));
24
            try
25
            {
26
                if (context.InputParameters.Contains("Target") &&
27
                context.InputParameters["Target"] is Entity)
28
                {
29
                    IOrganizationServiceFactory factory =
30
                        (IOrganizationServiceFactory)serviceProvider.
31
                        GetService(typeof(IOrganizationServiceFactory));
32
                    IOrganizationService service = factory.CreateOrganizationService(context.UserId);
33
                    IOrganizationService serviceAdmin = factory.CreateOrganizationService(null);
34
                    Entity targetEntityRecord = (Entity)context.InputParameters["Target"];
35

36
                    // "context.Stage == 40" -> PostOperation
37
                    if (context.Stage == 40 && targetEntityRecord.Attributes.Contains("gdh_multi_select") &&
38
                        (context.MessageName == "Create" || context.MessageName == "Update"))
39
                    {
40
                        SetMultiSelectText(serviceAdmin, targetEntityRecord); // [!code highlight]
41
                    }
42
                }
43
            }
44
            catch (Exception ex)
45
            {
46
                tracer.Trace($"ContactPostUpdatePlugin unexpected exception:\n{ex.Message}");
47
                throw;
48
            }
49
        }
50

51
        private void SetMultiSelectText(IOrganizationService organization, Entity contactEn)
52
        {
53
            if (contactEn.Attributes.Contains("gdh_multi_select"))
54
            {
55
                OptionSetValueCollection optionSetValues =
56
                    contactEn.GetAttributeValue<OptionSetValueCollection>("gdh_multi_select");
57
                string roleText =
58
                    GetMultiSelectOptionSetLabels(
59
                      organization,
60
                      "contact",
61
                      "gdh_multi_select",
62
                      optionSetValues);
63
                if (!string.IsNullOrEmpty(roleText))
64
                {
65
                    Entity updateContact = new Entity(contactEn.LogicalName, contactEn.Id);
66
                    updateContact["gdh_multi_select_text"] = roleText;
67
                    organization.Update(updateContact);
68
                }
69
            }
70
        }
71

72
        public static string GetMultiSelectOptionSetLabels(
73
            IOrganizationService service,
74
            string entityLogicalName,
75
            string attributeLogicalName,
76
            OptionSetValueCollection values,
77
            int? languageCode = null)
78
        {
79
            if (values == null || !values.Any())
80
                return string.Empty;
81
            // Retrieve the attribute metadata
82
            RetrieveAttributeRequest retrieveAttributeRequest = new RetrieveAttributeRequest
83
            {
84
                EntityLogicalName = entityLogicalName,
85
                LogicalName = attributeLogicalName,
86
                RetrieveAsIfPublished = true
87
            };
88
            RetrieveAttributeResponse retrieveAttributeResponse =
89
            (RetrieveAttributeResponse)service.Execute(retrieveAttributeRequest);
90
            MultiSelectPicklistAttributeMetadata attributeMetadata =
91
            retrieveAttributeResponse.AttributeMetadata as MultiSelectPicklistAttributeMetadata;
92
            if (attributeMetadata == null)
93
                throw new InvalidPluginExecutionException("Attribute is not a Metadata.");
94
            // Prepare a map from option value to label
95
            Dictionary<int, string> optionLabels = attributeMetadata.OptionSet.Options.ToDictionary(
96
                o => o.Value.GetValueOrDefault(),
97
                o => GetLocalizedLabel(o, languageCode)
98
            );
99
            // Map selected values to labels
100
            var selectedLabels = values
101
                .Select(v => optionLabels.ContainsKey(v.Value) ?
102
                optionLabels[v.Value] : $"(Unknown {v.Value})")
103
                .ToList();
104
            return string.Join(", ", selectedLabels);
105
        }
106

107
        private static string GetLocalizedLabel(OptionMetadata option, int? languageCode = null)
108
        {
109
            if (languageCode.HasValue)
110
            {
111
                var label = option.Label.LocalizedLabels
112
                    .FirstOrDefault(l => l.LanguageCode == languageCode.Value);
113
                return label?.Label ?? $"(No label for {option.Value})";
114
            }
115
            else
116
            {
117
                return option.Label.UserLocalizedLabel?.Label ?? $"(No label for {option.Value})";
118
            }
119
        }
120

121
        public static int GetCurrentUserLanguageCode(IOrganizationService service)
122
        {
123
            WhoAmIResponse whoAmI = (WhoAmIResponse)service.Execute(new WhoAmIRequest());
124
            Guid userId = whoAmI.UserId;
125
            QueryExpression query = new QueryExpression("usersettings");
126
            query.Criteria.AddCondition(
127
              new ConditionExpression("systemuserid", ConditionOperator.Equal, userId));
128
            query.ColumnSet.AddColumns("uilanguageid");
129
            Entity result = service.RetrieveMultiple(query).Entities.FirstOrDefault();
130
            return result != null && result.Attributes.Contains("uilanguageid")
131
                ? (int)result["uilanguageid"]
132
                : 1033;
133
        }
134
    }
135
}