Exemple #1
0
        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));
        }
Exemple #3
0
        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));
        }
Exemple #4
0
        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));
        }
Exemple #5
0
        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));
        }
Exemple #6
0
        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));
        }
Exemple #7
0
        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));
        }
Exemple #8
0
 public static IDataReader get(long id)
 {
     return(Connexion.get(tableName, champsWhere, new object[] { id }));
 }