Codeunit 9556 Record Selection Impl.

System Application, System.Reflection

src/System Application/App/Record Selection/src/RecordSelectionImpl.Codeunit.al332 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace System.Reflection;using System;using System.Integration;/// <summary>/// Implementation for looking up records./// </summary>codeunit 9556 "Record Selection Impl."{    Access = Internal;    InherentEntitlements = X;    InherentPermissions = X;    procedure Open(TableId: Integer; MaximumCount: Integer; var SelectedRecord: Record "Record Selection Buffer"): Boolean    var        RecordLookup: Page "Record Lookup";    begin        if RecordAutoSelected(TableId, MaximumCount, SelectedRecord) then begin            Message(OnlyOneRecordMsg);            exit(true);        end;        RecordLookup.SetTableId(TableId);        RecordLookup.LookupMode(true);        if RecordLookup.RunModal() = Action::LookupOK then begin            RecordLookup.GetSelectedRecords(SelectedRecord);            exit(true);        end;        exit(false);    end;    procedure ToText(TableId: Integer; SystemId: Guid): Text    var        FromRecordRef: RecordRef;        FromFieldRef: FieldRef;        FromKeyRef: KeyRef;        PageSummaryFieldList: List of [Integer];        RecordTextBuilder: TextBuilder;        ValueAsText: Text;        PageId: Integer;        Index: Integer;        FieldIndex: Integer;        FieldCount: Integer;        RelatedPageExist: Boolean;    begin        FromRecordRef.Open(TableId);        if not FromRecordRef.GetBySystemId(SystemId) then            exit('');        PageId := GetRelatedPageId(TableId);        RelatedPageExist := GetPageSummaryFields(PageId, FieldCount, PageSummaryFieldList);        if not RelatedPageExist then            GetPrimaryKeyFields(FromRecordRef, FromKeyRef, FieldCount);        for Index := 1 to FieldCount do begin            if RelatedPageExist then begin                PageSummaryFieldList.Get(Index, FieldIndex);                FromFieldRef := FromRecordRef.Field(FieldIndex);            end else                FromFieldRef := FromKeyRef.FieldIndex(Index);            if FromFieldRef.Class = FieldClass::FlowField then                FromFieldRef.CalcField();            ValueAsText := FromFieldRef.Value();            if ValueAsText <> '' then begin                RecordTextBuilder.Append(ValueAsText);                RecordTextBuilder.Append(',');            end;        end;        if RecordTextBuilder.Length > 0 then            RecordTextBuilder.Remove(RecordTextBuilder.Length, 1);        exit(RecordTextBuilder.ToText());    end;    local procedure RecordAutoSelected(TableId: Integer; MaximumCount: Integer; var RecordSelectionBuffer: Record "Record Selection Buffer"): Boolean    var        FromRecordRef: RecordRef;        RecordCount: Integer;    begin        FromRecordRef.Open(TableId);        RecordCount := FromRecordRef.Count();        if RecordCount = 0 then            Error(NoRecordsErr);        if RecordCount > MaximumCount then            Error(TooManyRecordsErr, MaximumCount);        if RecordCount = 1 then begin            FromRecordRef.FindFirst();            RecordSelectionBuffer."Record System Id" := FromRecordRef.Field(FromRecordRef.SystemIdNo()).Value;            RecordSelectionBuffer.Insert();            exit(true);        end;        exit(false);    end;    procedure GetRecordsFromTableId(TableId: Integer; var PrimaryKeyCaptions: array[10] of Text; var RecordSelectionBuffer: Record "Record Selection Buffer"): Integer    var        FieldCount: Integer;        PageId: Integer;    begin        PageId := GetRelatedPageId(TableId);        if GetFieldsFromPage(TableId, PageId, FieldCount, PrimaryKeyCaptions, RecordSelectionBuffer) then            exit(FieldCount);        GetFieldsFromPrimaryKey(TableId, FieldCount, PrimaryKeyCaptions, RecordSelectionBuffer);        exit(FieldCount);    end;    local procedure GetRelatedPageId(TableId: Integer): Integer    var        TableMetadata: Record "Table Metadata";        PageMetadata: Record "Page Metadata";    begin        if TableMetadata.Get(TableId) then            if TableMetadata.LookupPageID <> 0 then                exit(TableMetadata.LookupPageID)            else                if TableMetadata.DrillDownPageId <> 0 then                    exit(TableMetadata.DrillDownPageId);        PageMetadata.SetRange(SourceTable, TableId);        if PageMetadata.FindFirst() then            exit(PageMetadata.ID);        exit(0);    end;    local procedure GetFieldsFromPage(TableId: Integer; PageId: Integer; var FieldCount: Integer; var PageSummaryCaptions: array[10] of Text; var RecordSelectionBuffer: Record "Record Selection Buffer"): Boolean    var        FromRecordRef: RecordRef;        PageSummaryFieldList: List of [Integer];    begin        if not GetPageSummaryFields(PageId, FieldCount, PageSummaryFieldList) then            exit(false);        FromRecordRef.Open(TableId);        if FromRecordRef.FindSet() then            repeat                SetRecordRefFieldsFromPageSummaryFields(PageSummaryFieldList, FromRecordRef, RecordSelectionBuffer);            until FromRecordRef.Next() = 0;        SetCaptionsFromPageSummary(PageSummaryFieldList, FromRecordRef, PageSummaryCaptions);        exit(true);    end;    local procedure GetPageSummaryFields(PageId: Integer; var FieldCount: Integer; var PageSummaryFieldList: List of [Integer]): Boolean    var        GenericList: DotNet GenericList1;        NavPageSummaryALFunctions: DotNet NavPageSummaryALFunctions;        PageSummaryField: Integer;    begin        if PageId = 0 then            exit(false);        GenericList := NavPageSummaryALFunctions.GetSummaryFields(PageId);        foreach PageSummaryField in GenericList do            PageSummaryFieldList.Add(PageSummaryField);        FieldCount := PageSummaryFieldList.Count();        exit(FieldCount <> 0);    end;    local procedure SetRecordRefFieldsFromPageSummaryFields(var PageSummaryFieldList: List of [Integer]; var FromRecordRef: RecordRef; var RecordSelectionBuffer: Record "Record Selection Buffer")    var        RecordSelectionBufferRecordRef: RecordRef;    begin        RecordSelectionBufferRecordRef.GetTable(RecordSelectionBuffer);        RecordSelectionBufferRecordRef.Init();        CopySystemId(FromRecordRef, RecordSelectionBufferRecordRef);        SetFieldsFromPageSummary(PageSummaryFieldList, FromRecordRef, RecordSelectionBufferRecordRef);        RecordSelectionBufferRecordRef.SetTable(RecordSelectionBuffer);        RecordSelectionBufferRecordRef.Reset();        RecordSelectionBuffer.Insert();    end;    local procedure GetFieldsFromPrimaryKey(TableId: Integer; var FieldCount: Integer; var PrimaryKeyCaptions: array[10] of Text; var RecordSelectionBuffer: Record "Record Selection Buffer")    var        FromRecordRef: RecordRef;        KeyRef: KeyRef;    begin        FromRecordRef.Open(TableId);        GetPrimaryKeyFields(FromRecordRef, KeyRef, FieldCount);        if FromRecordRef.FindSet() then            repeat                SetRecordRefFieldsFromPrimaryKeyFields(FieldCount, KeyRef, FromRecordRef, RecordSelectionBuffer);            until FromRecordRef.Next() = 0;        SetCaptionsFromKeyRef(FieldCount, KeyRef, PrimaryKeyCaptions);    end;    local procedure GetPrimaryKeyFields(var FromRecordRef: RecordRef; var KeyRef: KeyRef; var FieldCount: Integer)    begin        KeyRef := FromRecordRef.KeyIndex(FromRecordRef.CurrentKeyIndex());        FieldCount := GetFieldCount(KeyRef);    end;    local procedure SetRecordRefFieldsFromPrimaryKeyFields(FieldCount: Integer; var KeyRef: KeyRef; var FromRecordRef: RecordRef; var RecordSelectionBuffer: Record "Record Selection Buffer")    var        RecordSelectionBufferRecordRef: RecordRef;    begin        RecordSelectionBufferRecordRef.GetTable(RecordSelectionBuffer);        RecordSelectionBufferRecordRef.Init();        CopySystemId(FromRecordRef, RecordSelectionBufferRecordRef);        SetFieldsFromKeyRef(FieldCount, KeyRef, RecordSelectionBufferRecordRef);        RecordSelectionBufferRecordRef.SetTable(RecordSelectionBuffer);        RecordSelectionBufferRecordRef.Reset();        RecordSelectionBuffer.Insert();    end;    local procedure GetFieldCount(KeyRef: KeyRef): Integer    var        FieldCount: Integer;    begin        FieldCount := KeyRef.FieldCount();        if FieldCount > MaximumFieldsSupported() then            FieldCount := MaximumFieldsSupported();        exit(FieldCount);    end;    local procedure CopySystemId(var FromRecordRef: RecordRef; var RecordSelectionBufferRecordRef: RecordRef)    var        RecordSelectionBufferFieldRef: FieldRef;        FromFieldRef: FieldRef;    begin        FromFieldRef := FromRecordRef.Field(FromRecordRef.SystemIdNo());        RecordSelectionBufferFieldRef := RecordSelectionBufferRecordRef.Field(1); // System Id        RecordSelectionBufferFieldRef.Value(FromFieldRef.Value());    end;    local procedure SetFieldsFromPageSummary(var PageSummaryFieldList: List of [Integer]; var FromRecordRef: RecordRef; var RecordSelectionBufferRecordRef: RecordRef)    var        RecordSelectionBufferFieldRef: FieldRef;        FromFieldRef: FieldRef;        FieldIndex: Integer;        Index: Integer;        ValueAsTxt: Text[250];    begin        for Index := 1 to PageSummaryFieldList.Count() do begin            PageSummaryFieldList.Get(Index, FieldIndex);            FromFieldRef := FromRecordRef.Field(FieldIndex);            if FromFieldRef.Class = FieldClass::FlowField then                FromFieldRef.CalcField();            ValueAsTxt := FromFieldRef.Value();            RecordSelectionBufferFieldRef := RecordSelectionBufferRecordRef.Field(Index + 1);            RecordSelectionBufferFieldRef.Value(ValueAsTxt);        end;    end;    local procedure SetCaptionsFromPageSummary(var PageSummaryFieldList: List of [Integer]; var FromRecordRef: RecordRef; var PrimaryKeyCaptions: array[10] of Text)    var        FromFieldRef: FieldRef;        FieldIndex: Integer;        Index: Integer;    begin        for Index := 1 to PageSummaryFieldList.Count() do begin            PageSummaryFieldList.Get(Index, FieldIndex);            FromFieldRef := FromRecordRef.Field(FieldIndex);            PrimaryKeyCaptions[Index] := FromFieldRef.Caption();        end;    end;    local procedure SetFieldsFromKeyRef(FieldCount: Integer; var FromKeyRef: KeyRef; var ToRecordRef: RecordRef)    var        ToFieldRef: FieldRef;        FromFieldRef: FieldRef;        Index: Integer;        ValueAsTxt: Text[250];    begin        for Index := 1 to FieldCount do begin            FromFieldRef := FromKeyRef.FieldIndex(Index);            if FromFieldRef.Class = FieldClass::FlowField then                FromFieldRef.CalcField();            ValueAsTxt := FromFieldRef.Value();            ToFieldRef := ToRecordRef.Field(Index + 1);            ToFieldRef.Value(ValueAsTxt);        end;    end;    local procedure SetCaptionsFromKeyRef(FieldCount: Integer; FromKeyRef: KeyRef; var PrimaryKeyCaptions: array[10] of Text)    var        FromFieldRef: FieldRef;        Index: Integer;    begin        for Index := 1 to FieldCount do begin            FromFieldRef := FromKeyRef.FieldIndex(Index);            PrimaryKeyCaptions[Index] := FromFieldRef.Caption();        end;    end;    local procedure MaximumFieldsSupported(): Integer    begin        exit(10);    end;    var        OnlyOneRecordMsg: Label 'The table contains only one record, which has been automatically selected.';        NoRecordsErr: Label 'The selected table does not contain any records.';        TooManyRecordsErr: Label 'The selected table contains more than %1 records which is not supported.', Comment = '%1 - Number of records';}