//----------------------------------------------------------------------------------------------------------------------------------
//----------------------------------------------------------------------------------------------------------------------------------
//----------------------------------------------------------------------------------------------------------------------------------
/// <summary>
/// Recupere DataTable de tous les auteurs
/// </summary>
/// <returns></returns>
private static DataTable GetDTAuteurs()
{
String sqlQuery = "SELECT " +
"* " +
"FROM " +
"auteur";
return(SQLClient.GetDataTable(_connectionString, sqlQuery));
}
//--------------------------------------------------------------------------------------------------------------------------------------
//--------------------------------------------------------------------------------------------------------------------------------------
//--------------------------------------------------------------------------------------------------------------------------------------
/// <summary>
/// Recupere une DataTable de toutes les relances
/// </summary>
/// <returns></returns>
private static DataTable GetDTRelances()
{
String sqlQuery = "SELECT " +
"* " +
"FROM " +
"relance";
return(SQLClient.GetDataTable(_connectionString, sqlQuery));
}
//----------------------------------------------------------------------------------------------------------------------------------------------
//----------------------------------------------------------------------------------------------------------------------------------------------
//----------------------------------------------------------------------------------------------------------------------------------------------
/// <summary>
/// Recupere DataTable avec tous les documents
/// </summary>
/// <returns></returns>
private static DataTable GetDTDocuments()
{
String sqlQuery = "SELECT " +
"* " +
"FROM " +
"document";
return(SQLClient.GetDataTable(_connectionString, sqlQuery));
}
//----------------------------------------------------------------------------------------------------------------------------------------------
//----------------------------------------------------------------------------------------------------------------------------------------------
//----------------------------------------------------------------------------------------------------------------------------------------------
/// <summary>
/// Recupere un DataTable des documents avec un idTitre
/// </summary>
/// <param name="idTitre">Id du titre</param>
/// <returns></returns>
private static DataTable GetDTDocuments_idTitre(Int32 idTitre)
{
String sqlQuery = "SELECT " +
"* " +
"FROM " +
"document " +
"WHERE " +
"id_document = " + idTitre;
return(SQLClient.GetDataTable(_connectionString, sqlQuery));
}