Hi,
last year I had exactly the same problem. You can use MSScript Control. You can search the forum for the problem.
I also included some sample code I used for that purpose.
Andreas
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MSScriptControl;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Xml;
using System.Xml.Linq;
using MSScriptControl;
namespace AddInScriptInterop
{
class ScriptInterop
{
public string[] ScriptNames { get; private set; }
public string[] ScriptLanguage { get; private set; }
private EA.Repository Repository;
public void startControl(EA.Repository rep)
{
this.Repository = rep;
}
/// <summary>
/// Extracts the Script names from the Repository
/// </summary>
/// <returns></returns>
public string[] getScriptNames()
{
String xmlString = (Repository.SQLQuery("SELECT Notes from t_script WHERE Notes LIKE '*Script Name*'"));
return
((from sc in
(
// we take notes and have to parse the value to get the script node!
from notes in (XDocument.Parse(xmlString).Descendants("Notes"))
select (XDocument.Parse(notes.Value))
)
select (sc.Element("Script").Attribute("Name").Value)).ToArray<string>());
}
public string[] getScriptLanguages() {
String xmlString = (Repository.SQLQuery("SELECT Notes from t_script WHERE Notes LIKE '*Script Name*'"));
return
(from sc in
(
// we take notes and have to parse the value to get the script node!
from notes in (XDocument.Parse(xmlString).Descendants("Notes"))
select (XDocument.Parse(notes.Value))
)
select (sc.Element("Script").Attribute("Language").Value)).ToArray<string>();
}
/// <summary>
/// Execute a script. Data Exchange can either be done by passing parameters or by handing over global objects
/// </summary>
/// <param name="script">script to be executed</param>
/// <param name="scriptlanguage">script language</param>
/// <param name="runobject">paremters passed to the script</param>
/// <param name="addObject">global objects added to the script control engine</param>
/// <returns></returns>
private int ExecuteScript(string script, string scriptlanguage, Object[] runobject, Object[] addObject)
{
MSScriptControl.ScriptControlClass control = new ScriptControlClass();
control.Language = scriptlanguage;
control.AllowUI = true;
// Pass global objects
control.AddObject("Repository", Repository);
for (int i = 0; i < addObject.Length; i++)
{
string name = "AddObject" + i;
control.AddObject(name, addObject
);
}
int ret = -1;
try
{
control.AddCode(script);
ret = (int)control.Run("main", runobject);
}
catch
{
MessageBox.Show(control.Error.Description + " (line " + control.Error.Line + ")");
}
return ret;
}
}
}
