public RequeteSelection(RequeteSelection req)
{
NomTable = req.NomTable;
NomsChamps = req.NomsChamps;
Condition = req.Condition;
Tris = req.Tris;
}
public RequeteSelection(NomTable nomTable)
{
NomTable = System.Enum.GetName(typeof(NomTable), nomTable);
NomsChamps = "*";
Condition = null;
Tris = "";
}
public RequeteModification(NomTable nomTable, ConditionRequete condition, LigneTable ligne)
{
NomTable = System.Enum.GetName(typeof(NomTable), nomTable);
ChampsModif = "";
Condition = condition;
AjouterChampModif(ligne);
}
public RequeteModification(NomTable nomTable, ConditionRequete condition, params Champ[] champs)
{
NomTable = System.Enum.GetName(typeof(NomTable), nomTable);
ChampsModif = "";
Condition = condition;
AjouterChampModif(champs);
}
public RequeteModification(NomTable nomTable, ConditionRequete condition, string premierNomChamp, string premiereValeur)
{
NomTable = System.Enum.GetName(typeof(NomTable), nomTable);
ChampsModif = "";
Condition = condition;
AjouterChampModif(premierNomChamp, premiereValeur);
}
public RequeteSelection(NomTable nomTable, params string[] nomsChamps)
{
NomTable = System.Enum.GetName(typeof(NomTable), nomTable);
NomsChamps = "*";
Condition = null;
Tris = "";
AjouterChamps(nomsChamps);
}
public void LierCondition(ConditionRequete condition, bool conjonction)
{
string lien = conjonction ? " AND " : " OR ";
Texte += lien + condition.Texte;
}
public ConditionRequete(ConditionRequete cond)
{
Texte = cond.Texte;
}
public RequeteSuppression(NomTable nomTable, ConditionRequete condition)
{
NomTable = System.Enum.GetName(typeof(NomTable), nomTable);
Condition = condition;
}