private void tmrWorkerThree_Tick(object sender, EventArgs e)
{
tmrWorkerThree.Enabled = false;
Recordset lObjRecordset = null;
try
{
lObjRecordset = DIApplication.GetRecordset();
lObjRecordset.DoQuery("SELECT ItemCode FROM OITM");
lstThreadThree.Items.Clear();
if (lObjRecordset.RecordCount > 0)
{
for (int i = 0; i < lObjRecordset.RecordCount; i++)
{
lstThreadThree.Items.Add(lObjRecordset.Fields.Item(0).Value.ToString());
lObjRecordset.MoveNext();
}
}
}
catch (Exception ex)
{
lstThreadThree.Items.Add(ex.ToString());
}
finally
{
MemoryUtility.ReleaseComObject(lObjRecordset);
tmrWorkerThree.Enabled = true;
}
}
/// <summary>
/// Checks if a User Defined Field exists.
/// </summary>
/// <param name="tableName">The table of the field.</param>
/// <param name="ufdName">The name of the field.</param>
/// <returns><c>true</c> if it exists, <c>false</c> otherwise.</returns>
public static bool ExistsUFD(string tableName, string ufdName)
{
SAPbobsCOM.Recordset rs = DIApplication.GetRecordset();
try
{
rs.DoQuery(string.Format("SELECT \"AliasID\" FROM \"CUFD\" WHERE \"TableID\" = '{0}' AND \"AliasID\" = '{1}'", tableName, ufdName));
if (rs.RecordCount > 0)
{
return(true);
}
}
catch (Exception)
{
}
finally
{
MemoryUtility.ReleaseComObject(rs);
}
return(false);
}
