/// <summary>
/// This method will get an invoice number of an invoice attached to an item if one exists
/// </summary>
/// <param name="code"></param>
/// <returns></returns>
public string getAttachedInvoiceNum(string code)
{
// initialize variables
DataSet ds;
int iRef = 0;
// SQL statement
ds = clsDataAccess.ExecuteSQLStatement(clsItemsSQL.SelectDistinctItem(code), ref iRef);
// return specific row
if (ds.Tables[0].Rows.Count >= 1)
{
return(ds.Tables[0].Rows[0].ItemArray[0].ToString());
}
return(null);
}
