private static IDataReader get(CritereRechercheCarte criteres)
{
IList <string> champsWhere = new List <string>();
IList <object> valuesWhere = new List <object>();
IList <string> operators = new List <string>();
Utilities.addCritere(champsWhere, valuesWhere, operators, "NUMERO_CARTE", criteres.Numero, Connexion.LIKE);
Utilities.addCritere(champsWhere, valuesWhere, operators, "ID_MOYEN_PAIEMENT", criteres.IdMoyenPaiement, Connexion.EGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "ID_TYPE_CARTE", criteres.IdTypeCarte, Connexion.EGAL);
return(Connexion.get(tableName, champsWhere, valuesWhere, operators));
}
private static IDataReader get(CritereRechercheMoyenPaiement criteres)
{
IList <string> champsWhere = new List <string>();
IList <object> valuesWhere = new List <object>();
IList <string> operators = new List <string>();
Utilities.addCritere(champsWhere, valuesWhere, operators, "LIBELLE_MOYEN_PAIEMENT", criteres.IdMoyenPaiement, Connexion.LIKE);
Utilities.addCritere(champsWhere, valuesWhere, operators, "ID_COMPTE", criteres.IdCompte, Connexion.EGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "ID_MOYEN_PAIEMENT", criteres.IdMoyenPaiement, Connexion.EGAL);
return(Connexion.get(tableName, champsWhere, valuesWhere, operators));
}
private static IDataReader get(CritereRechercheCompte criteres)
{
IList <string> champsWhere = new List <string>();
IList <object> valuesWhere = new List <object>();
IList <string> operators = new List <string>();
Utilities.addCritere(champsWhere, valuesWhere, operators, "TYPE_COMPTE", criteres.TypeCompte, Connexion.LIKE);
Utilities.addCritere(champsWhere, valuesWhere, operators, "DT_OUVERTURE", criteres.DateOuvertureFin, Connexion.INFEGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "DT_OUVERTURE", criteres.DateOuvertureDebut, Connexion.SUPEGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "ID_CLIENT", criteres.IdClient, Connexion.EGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "ID_COMPTE", criteres.IdCompte, Connexion.EGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "ID_MOYEN_PAIEMENT", criteres.IdMoyenPaiement, Connexion.EGAL);
return(Connexion.get(tableName, champsWhere, valuesWhere, operators));
}
private static IDataReader get(CritereRechercheClient criteres)
{
IList <string> champsWhere = new List <string>();
IList <object> valuesWhere = new List <object>();
IList <string> operators = new List <string>();
Utilities.addCritere(champsWhere, valuesWhere, operators, "EMAIL", criteres.Email, Connexion.LIKE);
Utilities.addCritere(champsWhere, valuesWhere, operators, "NOM", criteres.Nom, Connexion.LIKE);
Utilities.addCritere(champsWhere, valuesWhere, operators, "PRENOM", criteres.Prenom, Connexion.LIKE);
Utilities.addCritere(champsWhere, valuesWhere, operators, "ADRESSE_PRINC", criteres.Adresse, Connexion.LIKE);
Utilities.addCritere(champsWhere, valuesWhere, operators, "DT_NAISS", criteres.DateNaissanceFin, Connexion.INFEGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "DT_NAISS", criteres.DateNaissanceDebut, Connexion.SUPEGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "ID_CLIENT", criteres.IdClient, Connexion.EGAL);
return(Connexion.get(tableName, champsWhere, valuesWhere, operators));
}
private static IDataReader get(CritereRechercheTypeCarte criteres)
{
IList <string> champsWhere = new List <string>();
IList <object> valuesWhere = new List <object>();
IList <string> operators = new List <string>();
Utilities.addCritere(champsWhere, valuesWhere, operators, "ID_TYPE_CARTE", criteres.IdTypeCarte, Connexion.EGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "RESEAU", criteres.ReseauCarte, Connexion.LIKE);
Utilities.addCritere(champsWhere, valuesWhere, operators, "PLF_GLO_PAIE", criteres.PlfGloPaiement, Connexion.EGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "PERI_PLF_PAIE", criteres.PeriodePlfPaiement, Connexion.EGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "PERI_PLF_GLO_RET", criteres.PeriodePlfGlobalRetrait, Connexion.EGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "PLF_GLO_RET_INT", criteres.PlfGlobalRetraitInternes, Connexion.EGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "PLF_RET_ETRG", criteres.PlfRetEtranger, Connexion.EGAL);
return(Connexion.get(tableName, champsWhere, valuesWhere, operators));
}
private static IDataReader get(CritereRechercheContrat criteres)
{
IList <string> champsWhere = new List <string>();
IList <object> valuesWhere = new List <object>();
IList <string> operators = new List <string>();
Utilities.addCritere(champsWhere, valuesWhere, operators, "INTITULE", criteres.Intitule, Connexion.LIKE);
Utilities.addCritere(champsWhere, valuesWhere, operators, "TYPE", criteres.Type, Connexion.LIKE);
Utilities.addCritere(champsWhere, valuesWhere, operators, "DT_SOUS", criteres.DateSouscriptionFin, Connexion.INFEGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "DT_SOUS", criteres.DateSouscriptionDebut, Connexion.SUPEGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "ID_CONTRAT", criteres.IdContrat, Connexion.EGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "ID_CLIENT", criteres.IdClient, Connexion.EGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "ID_PRODUIT", criteres.IdProduit, Connexion.EGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "ID_COMPTE", criteres.IdCompte, Connexion.EGAL);
return(Connexion.get(tableName, champsWhere, valuesWhere, operators));
}
private static IDataReader get(CritereRechercheOperation criteres)
{
IList <string> champsWhere = new List <string>();
IList <object> valuesWhere = new List <object>();
IList <string> operators = new List <string>();
Utilities.addCritere(champsWhere, valuesWhere, operators, "LIBELLE", criteres.Libelle, Connexion.LIKE);
Utilities.addCritere(champsWhere, valuesWhere, operators, "TYPE_OPERATION", criteres.TypeOperation, Connexion.LIKE);
Utilities.addCritere(champsWhere, valuesWhere, operators, "STATUT", criteres.Statut, Connexion.LIKE);
Utilities.addCritere(champsWhere, valuesWhere, operators, "DT_OPERATION", criteres.DateOperationFin, Connexion.INFEGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "DT_OPERATION", criteres.DateOperationDebut, Connexion.SUPEGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "ID_OPERATION", criteres.IdOperation, Connexion.EGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "ID_MOYEN_PAIEMENT", criteres.IdMoyenPaiement, Connexion.EGAL);
Utilities.addCritere(champsWhere, valuesWhere, operators, "ID_COMPTE", criteres.IdCompte, Connexion.EGAL);
//Utilities.addCritere(champsWhere, valuesWhere, operators, criteres.isCredit() ? "MNT_CREDIT" : "MNT_DEBIT", "NOT NULL" , Connexion.IS);
return(Connexion.get(tableName, champsWhere, valuesWhere, operators));
}
public static IDataReader get(long id)
{
return(Connexion.get(tableName, champsWhere, new object[] { id }));
}
