//-------------------------------------------------------
protected override CResultAErreur GetDatasHorsCalculees(CListeQuerySource sources)
{
CEasyQuery query = Query;
CResultAErreur result = CResultAErreur.True;
if (result && TypeSource == null)
{
result.EmpileErreur(I.T("###Table object must be specified |"));
}
if (query == null || sources == null)
{
result.EmpileErreur(I.T("###Query needs a source to provide datas|"));
}
C2iRequeteAvancee requete = new C2iRequeteAvancee();
requete.TableInterrogee = CContexteDonnee.GetNomTableForType(TypeSource);
result = FiltreDynamique.GetFiltreData();
if (!result)
{
return(result);
}
if (result.Data is CFiltreData)
{
requete.FiltreAAppliquer = result.Data as CFiltreData;
}
foreach (IColumnDeEasyQuery col in Columns)
{
CColumnDeEasyQueryChampDeRequete colR = col as CColumnDeEasyQueryChampDeRequete;
requete.ListeChamps.Add(colR);
}
DataTable table = null;
if (requete.ListeChamps.Count > 0)
{
result = requete.ExecuteRequete(CContexteDonneeSysteme.GetInstance().IdSession);
if (!result)
{
result.EmpileErreur(I.T("###Error on table @1|"));
return(result);
}
table = result.Data as DataTable;
}
else
{
table = new DataTable();
}
table.TableName = NomFinal;
return(result);
}
//--------------------------------------------------
public void AddColonneDeRequete(CColumnDeEasyQueryChampDeRequete col)
{
m_listeColonnes.Add(col);
}