/// <summary>
/// Get the LoginIDList for the specified loginID
/// </summary>
/// <param name="accID">The login ID to search for.</param>
/// <returns>DataSet containing LoginID records</returns>
public void GetLoginIDListByLoginID(DamDataSet.LoginIDListDataTable dsTable, params string[] loginIDs)
{
dsTable.Clear();
if (loginIDs.Length == 0)
{
return;
}
string query = "SELECT * FROM LoginIDList WHERE";
for (int i = 0; i < loginIDs.Length; i++)
{
if (i != 0)
{
query += " OR";
}
query += " LoginID = '" + loginIDs[i] + "'";
;
}
query += "";
SQLiteDataAdapter adpt = new SQLiteDataAdapter(query, GetConnection());
adpt.Fill(dsTable);
}
/// <summary>
/// Get the LoginIDList for the specified account
/// </summary>
/// <param name="accID">The account dir</param>
/// <returns>DataSet containing LoginID records</returns>
public void GetLoginIDListByAccDir(DamDataSet.LoginIDListDataTable dsTable, string accDir)
{
SQLiteDataAdapter adpt = new SQLiteDataAdapter("SELECT * FROM LoginIDList WHERE AccDir ='" + accDir + "' ORDER BY AccessTime DESC, LoginID", GetConnection());
dsTable.Clear();
adpt.Fill(dsTable);
}
/// <summary>
/// Get the latest LoginID
/// </summary>
/// <param name="accDir">The account dir</param>
/// <returns>The row with the lastest loginID, null if no loginID exists</returns>
public DamDataSet.LoginIDListRow GetLatestLoginIDRowByAccDir(string accDir)
{
SQLiteDataAdapter adpt = new SQLiteDataAdapter("SELECT * FROM LoginIDList WHERE AccDir ='" + accDir + "' ORDER BY AccessTime DESC LIMIT 0,1", GetConnection());
DamDataSet.LoginIDListDataTable dsTable = new DamDataSet.LoginIDListDataTable();
adpt.Fill(dsTable);
if (dsTable.Count == 0)
{
return(null);
}
return(dsTable[0]);
}