public static Issues[] loadByAccountId(long accountId)
{
ArrayList list = new ArrayList();
DataSet ds = new DataSet();
Issues note = new Issues();
string[] s = new string[1];
s[0] = accountId.ToString();
ds = note.load(SQL_LOAD_BY_ACCOUNT_ID, s);
note = null;
foreach (DataRow dr in ds.Tables[0].Rows)
{
note = new Issues();
note.fill(dr);
list.Add(note);
note = null;
}
try {
return((Issues[])list.ToArray(typeof(Issues)));
} catch {
return(null);
}
}
public static Issues[] load(long acctId, int field)
{
ArrayList list = new ArrayList();
DataSet ds = new DataSet();
Issues note = new Issues();
string xsql = string.Format("{0}{1};", SQL_LOAD_BY_ACCOUNT_ID_ORDER_BY, orderBy[field]);
string[] s = new string[1];
s[0] = acctId.ToString();
ds = note.load(xsql, s);
note = null;
foreach (DataRow dr in ds.Tables[0].Rows)
{
note = new Issues();
note.fill(dr);
list.Add(note);
note = null;
}
try {
return((Issues[])list.ToArray(typeof(Issues)));
} catch (Exception ex)
{
return(null);
}
}
public static Issues load(long id)
{
Issues note = new Issues();
DataSet ds = new DataSet();
ds = note.loadByPrimaryKey(id.ToString());
try {
DataRow dr = ds.Tables[0].Rows[0];
return(note.fill(dr));
} catch {
return(null);
}
}
public static Issues[] loadBySequenceNumber(long sequenceNumber)
{
ArrayList list = new ArrayList();
DataSet ds = new DataSet();
Issues note = new Issues();
string[] s = new string[1];
s[0] = sequenceNumber.ToString();
ds = note.load(SQL_LOAD_BY_SEQUENCE_NUMBER, s);
note = null;
foreach (DataRow dr in ds.Tables[0].Rows)
{
note = new Issues();
note.fill(dr);
list.Add(note);
note = null;
}
return((Issues[])list.ToArray(typeof(Issues)));
}
public static Issues[] load()
{
ArrayList list = new ArrayList();
DataSet ds = new DataSet();
Issues note = new Issues();
ds = note.loadAll();
note = null;
foreach (DataRow dr in ds.Tables[0].Rows)
{
note = new Issues();
note.fill(dr);
list.Add(note);
note = null;
}
try {
return((Issues[])list.ToArray(typeof(Issues)));
} catch {
return(null);
}
}
public static Issues[] load(int field)
{
ArrayList list = new ArrayList();
DataSet ds = new DataSet();
Issues note = new Issues();
string xsql = string.Format("{0}{1};", SQL_LOAD_ORDER_BY, orderBy[field]);
ds = note.load(xsql, null);
note = null;
foreach (DataRow dr in ds.Tables[0].Rows)
{
note = new Issues();
note.fill(dr);
list.Add(note);
note = null;
}
try {
return((Issues[])list.ToArray(typeof(Issues)));
} catch {
return(null);
}
}