/// <summary>
/// Takes an sql clause and returns a DataTable with the result
/// 2016-02-02 KJBO Pegas AB
/// </summary>
/// <param name="sSql">The SQL clause to be executed</param>
/// <param name="errText">Reference parameter that returns error string</param>
/// <param name="pc">Parameter collection</param>
/// <returns>Result of SQL clause in a DataTable</returns>
public DataTable getData(string sSql, ref string errText, NxParameterCollection pc)
{
NxConnection cn = getConn();
NxCommand cm = new NxCommand(sSql, cn);
errText = "";
if (pc != null)
{
foreach (NxParameter np in pc)
{
NxParameter npInsert = (NxParameter)np.Clone();
cm.Parameters.Add(npInsert);
}
}
// Create a data adapter
NxDataAdapter da = new NxDataAdapter(cm);
// Datatable for the result
DataTable dt = new DataTable();
try
{
// Fill data table and...
da.Fill(dt);
}
catch (Exception ex)
{
errText = ex.Message;
}
// return result
return(dt);
}
/// <summary>Function that lets you query global simulation parameters. </summary>
/// <param name="paramEnum">The Parameter to retrieve. </param>
public virtual float getParameter(NxParameter paramEnum)
{
if (doSetFunctionPointers)
{
throw new System.NotSupportedException("Cannot call abstract base member");
}
return(NxPhysicsSDK_getParameter_INVOKE(ClassPointer, doSetFunctionPointers, paramEnum));
}
/// <summary>
/// Updates the database from the given SQL Clause
/// </summary>
/// <param name="sSql">SQL Clause to be executed</param>
/// <param name="errText">Refernce string that returns error string</param>
/// <param name="pc">Collection of parameters</param>
/// <returns>Number of updated rows</returns>
public int updateData(string sSql, ref string errText, NxParameterCollection pc)
{
NxConnection cn = getConn();
NxCommand cm = new NxCommand(sSql, cn);
// Check if there are any parameters
if (pc != null)
{
foreach (NxParameter np in pc)
{
NxParameter npInsert = (NxParameter)np.Clone();
cm.Parameters.Add(npInsert);
}
}
errText = "";
int result = 0;
try
{
cn.Open();
result = cm.ExecuteNonQuery();
}
catch (Exception ex)
{
errText = ex.Message;
result = -1;
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close();
}
}
return(result);
}
private bool setParameter_virtual(NxParameter paramEnum, float paramValue)
{
return(setParameter(paramEnum, paramValue));
}
private extern static System.Single NxPhysicsSDK_getParameter_INVOKE(HandleRef classPointer, System.Boolean call_explicit, NxParameter paramEnum);
private float getParameter_virtual(NxParameter paramEnum)
{
return(getParameter(paramEnum));
}
