Add-in WinForm Matrix in Navision 2013 R2

[Ion]

Добрый день!

Необходимо создать WinForm в виде динамической матрицы, которая бы встраивалась в Navision как кастомный компонент - Add-In.

В настоящий момент создал динамическую двумерную матрицу, которая инициализируеться данными из Navision.

В качестве источника данных использую веб-сервис OData.

В данный момент есть проблемы:

1) Как открыть сущность Navision из WinFrom, вернее какой метод для этого существует и как его повесить как событие на кнопки в WinFrom;
2) Каким образом создать DLL сборку WinFrom Add-in для Navision 2013 R2

Вот пример кода

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using NAVMatrix.ServiceReference1;

namespace NAVMatrix
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        
         private static List<NAVMatrix.ServiceReference1.Matrix_list> PrintCustomersCalledCust(NAV nav)
         {
            var Matrix = from c in nav.Matrix_list
            select c;
            List<NAVMatrix.ServiceReference1.Matrix_list> Matrix1 = Matrix.ToList();
            return Matrix1;
         }

        private void Form1_Load(object sender, EventArgs e)
        {
           //Коннектимся к веб-сервису OData
            NAV nav = new NAV(new Uri("http://raptor:7048/DynamicsNAV71/OData/Company('DREVO')"));
            nav.Credentials = System.Net.CredentialCache.DefaultNetworkCredentials;
			
            List<NAVMatrix.ServiceReference1.Matrix_list> Matrix = PrintCustomersCalledCust(nav);
			int L =  Matrix.Count;
			this.tableLayoutPanel1.Controls.Clear();
            this.tableLayoutPanel1.ColumnStyles.Clear();
            this.tableLayoutPanel1.RowStyles.Clear();

            tableLayoutPanel1.ColumnCount = Matrix[L - 1].X + 1;
            tableLayoutPanel1.RowCount = Matrix[L - 1].Y + 1;
			
            this.tableLayoutPanel1.CellBorderStyle = System.Windows.Forms.TableLayoutPanelCellBorderStyle.None;
            this.tableLayoutPanel1.Dock = System.Windows.Forms.DockStyle.Left;
            for (int i = 0; i < L; i++)
            {
                for (int x = Matrix[i].X; x < (Matrix[i].X + 1); x++)
                {
                    this.tableLayoutPanel1.ColumnStyles.Add(new ColumnStyle(SizeType.AutoSize));
                    for (int y = Matrix[i].Y; y < (Matrix[i].Y + 1); y++)
                    {
                        if (x == 0)
                        {
                        this.tableLayoutPanel1.RowStyles.Add(new RowStyle(SizeType.AutoSize));
                        }
                        Button cmd = new Button();
                        if (i%2 == 1)
                        cmd.BackColor = System.Drawing.SystemColors.HotTrack;
                        else {
                        cmd.BackColor = System.Drawing.Color.Yellow;}
                        cmd.Size = new System.Drawing.Size(105, 41);
                        cmd.Text = string.Format("({0}, {1}, {2}, {3}, {4}, {5})", Matrix[i].X, Matrix[i].Y, Matrix[i].Val1, Matrix[i].Val2,  Matrix[i].Val3, Matrix[i].Val4);        
                        this.tableLayoutPanel1.Controls.Add(cmd, x, y);

                    }
                }
            }
        }
		
         private void InitializeComponent()
        {
            this.tableLayoutPanel1 = new System.Windows.Forms.TableLayoutPanel();
            this.SuspendLayout();
            // 
            // tableLayoutPanel1
            // 
            this.tableLayoutPanel1.ColumnCount = 2;
            this.tableLayoutPanel1.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 50F));
            this.tableLayoutPanel1.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 50F));
            this.tableLayoutPanel1.Location = new System.Drawing.Point(0, 47);
            this.tableLayoutPanel1.Name = "tableLayoutPanel1";
            this.tableLayoutPanel1.RowCount = 2;
            this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 50F));
            this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 50F));
            this.tableLayoutPanel1.Size = new System.Drawing.Size(768, 194);
            this.tableLayoutPanel1.TabIndex = 0;
            this.tableLayoutPanel1.Paint += new System.Windows.Forms.PaintEventHandler(this.tableLayoutPanel1_Paint);
            // 
            // Form1
            // 
            this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
            this.ClientSize = new System.Drawing.Size(780, 414);
            this.Controls.Add(this.tableLayoutPanel1);
            this.Name = "Form1";
            this.Text = "Form1";
            this.Load += new System.EventHandler(this.Form1_Load);
            this.ResumeLayout(false);

            }
        }
    }

Вот как выглядит матрица




Код для Add-In должен быть приблизительно таким?

using System.Windows.Forms;
using Microsoft.Dynamics.Framework.UI.Extensibility;
using Microsoft.Dynamics.Framework.UI.Extensibility.WinForms;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;

namespace AddInSamples
{

    [ControlAddInExport("SampleControl1_MyDymanicMatrix")]
	
public class MyDymanicMatrixControlAddIn : WinFormsControlAddInBase
{

    protected override System.Windows.Forms.Control CreateControl()
    {
	        this.tableLayoutPanel1 = new System.Windows.Forms.TableLayoutPanel();
            this.SuspendLayout();
            // 
            // tableLayoutPanel1
            // 
            this.tableLayoutPanel1.ColumnCount = 2;
            this.tableLayoutPanel1.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 50F));
            this.tableLayoutPanel1.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 50F));
            this.tableLayoutPanel1.Location = new System.Drawing.Point(0, 47);
            this.tableLayoutPanel1.Name = "tableLayoutPanel1";
            this.tableLayoutPanel1.RowCount = 2;
            this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 50F));
            this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 50F));
            this.tableLayoutPanel1.Size = new System.Drawing.Size(768, 194);
            this.tableLayoutPanel1.TabIndex = 0;
            this.tableLayoutPanel1.Paint += new System.Windows.Forms.PaintEventHandler(this.tableLayoutPanel1_Paint);
            // 
            // Form1
            // 
            this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
            this.ClientSize = new System.Drawing.Size(780, 414);
            this.Controls.Add(this.tableLayoutPanel1);
            this.Name = "Form1";
            this.Text = "Form1";
            this.Load += new System.EventHandler(this.Form1_Load);
            this.ResumeLayout(false);

			}
			
		private void Form1_Load(object sender, EventArgs e)
        {
			 //Коннектимся к веб-сервису OData
            NAV nav = new NAV(new Uri("http://raptor:7048/DynamicsNAV71/OData/Company('DREVO')"));
            nav.Credentials = System.Net.CredentialCache.DefaultNetworkCredentials;
			
            List<NAVMatrix.ServiceReference1.Matrix_list> Matrix = PrintCustomersCalledCust(nav);
			int L =  Matrix.Count;
			this.tableLayoutPanel1.Controls.Clear();
            this.tableLayoutPanel1.ColumnStyles.Clear();
            this.tableLayoutPanel1.RowStyles.Clear();

            tableLayoutPanel1.ColumnCount = Matrix[L - 1].X + 1;
            tableLayoutPanel1.RowCount = Matrix[L - 1].Y + 1;
			
            this.tableLayoutPanel1.CellBorderStyle = System.Windows.Forms.TableLayoutPanelCellBorderStyle.None;
            this.tableLayoutPanel1.Dock = System.Windows.Forms.DockStyle.Left;
            for (int i = 0; i < L; i++)
            {
                for (int x = Matrix[i].X; x < (Matrix[i].X + 1); x++)
                {
                    this.tableLayoutPanel1.ColumnStyles.Add(new ColumnStyle(SizeType.AutoSize));
                    for (int y = Matrix[i].Y; y < (Matrix[i].Y + 1); y++)
                    {
                        if (x == 0)
                        {
                        this.tableLayoutPanel1.RowStyles.Add(new RowStyle(SizeType.AutoSize));
                        }
                        Button cmd = new Button();
                        if (i%2 == 1)
                        cmd.BackColor = System.Drawing.SystemColors.HotTrack;
                        else {
                        cmd.BackColor = System.Drawing.Color.Yellow;}
                        cmd.Size = new System.Drawing.Size(105, 41);
                        cmd.Text = string.Format("({0}, {1}, {2}, {3}, {4}, {5})", Matrix[i].X, Matrix[i].Y, Matrix[i].Val1, Matrix[i].Val2,  Matrix[i].Val3, Matrix[i].Val4);        
                        this.tableLayoutPanel1.Controls.Add(cmd, x, y);

                    }
                }
            }
	    }
		
		private List<NAVMatrix.ServiceReference1.Matrix_list> PrintCustomersCalledCust(NAV nav)
         {
            var Matrix = from c in nav.Matrix_list
            select c;
            List<NAVMatrix.ServiceReference1.Matrix_list> Matrix1 = Matrix.ToList();
            return Matrix1;
         }
     }
}