UAN
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
Microsoft.Dynamics.BusinessConnectorNet.Axapta DynAx;
DynAx =3D new =
Microsoft.Dynamics.BusinessConnectorNet.Axapta();
// Test the connection to the .NET Business Connector=20
// by using the proxy user.
System.Net.NetworkCredential nc =3D new =
System.Net.NetworkCredential("proxyBCAX", "********");
try
{
DynAx.LogonAs("proxyBCAX", "", nc, "", "", "", =
"C:\\Documents and Settings\\1314\\Escritorio\\BC.AXC");
//DynAx.LogonAs(Environment.UserName, "", null, "", "", =
"", "C:\\Documents and Settings\\1314\\Escritorio\\BC.AXC");
Console.WriteLine( "Success Login OK");
Console.ReadLine();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
Console.WriteLine(ex.Message);
Console.ReadLine();
}
}
}
}
CHU
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
try
{
label1.Text = "";
Microsoft.Dynamics.BusinessConnectorNet.Axapta DynAx = new
Microsoft.Dynamics.BusinessConnectorNet.Axapta();
Microsoft.Dynamics.BusinessConnectorNet.AxaptaRecord DynRec;
// Authenticate the user and establish a session.
DynAx.Logon(Company.Text, null, AOS.Text, Configuration.Text);
if (DynAx != null)
{
label1.Text = ("Login OK");
}
// Define the record as the AddressState table.
DynRec = DynAx.CreateAxaptaRecord("AddressState");
// Define the query that will run on the AddressState records.
// This will return all the data in the AddressState table with
// the cursor positioned at the first record in the table.
DynRec.ExecuteStmt("select * from %1");
// Check if the query returned any data.
if (DynRec.Found)
{
// Display the record on the form that was retrieved from the query.
textBox1.Text = (string)DynRec.get_Field("Name");
}
}
catch (Exception ex)
{
textBox1.Text = (ex.ToString());
textBox1.Text += (ex.Message);
label1.Text = ("Login Filed");
}
}
}
}
ZRI
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace WindowsFormsApplication2
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
label1.Text = "";
Microsoft.Dynamics.BusinessConnectorNet.Axapta DynAx = new
Microsoft.Dynamics.BusinessConnectorNet.Axapta();
Microsoft.Dynamics.BusinessConnectorNet.AxaptaRecord DynRec;
// Authenticate the user and establish a session.
System.Net.NetworkCredential nc = new System.Net.NetworkCredential(USER.Text, PASS.Text);
try
{
//"C:\\Documents and Settings\\1314\\Escritorio\\BC.AXC"
DynAx.LogonAs(AXUser.Text, Domain.Text, nc, Company.Text, null, AOS.Text, Configuration.Text);
if (DynAx != null)
{
label1.Text = ("Login OK");
}
// Define the record as the AddressState table.
DynRec = DynAx.CreateAxaptaRecord("AddressState");
// Define the query that will run on the AddressState records.
// This will return all the data in the AddressState table with
// the cursor positioned at the first record in the table.
DynRec.ExecuteStmt("select * from %1");
// Check if the query returned any data.
if (DynRec.Found)
{
// Display the record on the form that was retrieved from the query.
textBox1.Text = (string)DynRec.get_Field("Name");
}
//DynAx.Logoff();
}
catch (Exception ex)
{
textBox1.Text = (ex.ToString());
textBox1.Text += (ex.Message);
label1.Text = ("Login Filed");
}
}
}
}
using System;
using System.Collections.Generic;
using System.Text;
using System.Xml;
using System.Security.Cryptography;
using System.IO;
using Microsoft.Dynamics.BusinessConnectorNet;
namespace ConsoleApplication3
{
class Program
{
static void Main(string[] args)
{
Axapta AX;
AX = new Axapta();
AX.Logon(“CNS”, null, “DYmanicsAx1:2713″ , null);
object[] Parmlist = new object[1];
AxaptaContainer Container = AX.CreateAxaptaContainer();
Container = (AxaptaContainer)AX.CallStaticRecordMethod(“InventDim”, “dimEnabledFieldList”, 1);
Console.WriteLine(BankAccountTable.Call(“balanceCur”, Container));
AX.Logoff();
}
Delete sample
// Execute a query to retrieve an editable record
// where the name is MyStateUpdated.
axRecord.ExecuteStmt(“select forupdate * from %1 where %1.Name ==
‘MyStateUpdated’”);
// If the record is found then delete the record.
if (axRecord.Found)
{
// Start a transaction that can be committed.
ax.TTSBegin();
axRecord.Delete();
// Commit the transaction.
ax.TTSCommit();
}
INSERT
// Create the .NET Business Connector objects.
Axapta ax;
AxaptaRecord axRecord;
string tableName = “AddressState”;
try
{
// Login to Microsoft Dynamics AX.
ax = new Axapta();
ax.Logon(null, null, null, null);
// Create a new AddressState table record.
using (axRecord = ax.CreateAxaptaRecord(tableName));
{
// Provide values for each of the AddressState record fields.
axRecord.set_Field(“NAME”, “MyState”);
axRecord.set_Field(“STATEID”, “MyState”);
axRecord.set_Field(“COUNTRYREGIONID”, “US”);
axRecord.set_Field(“INTRASTATCODE”, “”);
// Commit the record to the database.
axRecord.Insert();
}
}
catch (Exception e)
{
Console.WriteLine(“Error encountered: {0}”, e.Message);
// Take other error action as needed.
}
READ
// Create the .NET Business Connector objects.
Axapta ax;
AxaptaRecord axRecord;
string tableName = “AddressState”;
// The AddressState field names for calls to
// the AxRecord.get_field method.
string strNameField = “NAME”;
string strStateIdField = “STATEID”;
// The output variables for calls to the
// AxRecord.get_Field method.
object fieldName, fieldStateId;
try
{
// Login to Microsoft Dynamics AX.
ax = new Axapta();
ax.Logon(null, null, null, null);
// Create a query using the AxaptaRecord class
// for the StateAddress table.
using (axRecord = ax.CreateAxaptaRecord(tableName));
{
// Execute the query on the table.
axRecord.ExecuteStmt(“select * from %1″);
// Create output with a title and column headings
// for the returned records.
Console.WriteLine(“List of selected records from {0}”,
tableName);
Console.WriteLine(“{0}\t{1}”, strNameField, strStateIdField);
// Loop through the set of retrieved records.
while (axRecord.Found)
{
// Retrieve the record data for the specified fields.
fieldName = axRecord.get_Field(strNameField);
fieldStateId = axRecord.get_Field(strStateIdField);
// Display the retrieved data.
Console.WriteLine(fieldName + “\t” + fieldStateId);
// Advance to the next row.
axRecord.Next();
}
}
}
catch (Exception e)
{
Console.WriteLine(“Error encountered: {0}”, e.Message);
// Take other error action as needed.
}
UPDATE
// Create an Axapta record for the StateAddress table.
axRecord = ax.CreateAxaptaRecord(tableName);
// Execute a query to retrieve an editable record where the name is MyState.
axRecord.ExecuteStmt(“select forupdate * from %1 where %1.Name ==
‘MyState’”);
// If the record is found then update the name.
if (axRecord.Found)
{
// Start a transaction that can be committed.
ax.TTSBegin();
axRecord.set_Field(“Name”, “MyStateUpdated”);
axRecord.Update();
// Commit the transaction.
ax.TTSCommit();
}