report

classe DTO

[Serializable]
public class AnalyseAgeDTO
{
#region Constructeur
public AnalyseAgeDTO()
{
}
#endregion
#region property
string _TrancheAge;
public string TrancheAge
{
get { return _TrancheAge; }
set { _TrancheAge = value; }
}
int _Effectif;
public int Effectif
{
get { return _Effectif; }
set { _Effectif = value; }
}
double _PourcentageMarche;
public double PourcentageMarche
{
get { return _PourcentageMarche; }
set { _PourcentageMarche = value; }
}
double _MedianeSalaireMarche;
public double MedianeSalaireMarche
{
get { return _MedianeSalaireMarche; }
set { _MedianeSalaireMarche = value; }
}
double _MedianeSalaireSociete;
public double MedianeSalaireSociete
{
get { return _MedianeSalaireSociete; }
set { _MedianeSalaireSociete = value; }
}
#endregion
}

classe DAO

[Serializable ]
public class AnalyseAgeFromRdb
{
#region Constructeur
public AnalyseAgeFromRdb()
{
}
#endregion
#region Dataset(list seralizable)
public List AnalyseParAge = new List();
public List getAnalyseParAge(int Annee, long? MarcheID, long? ClientID, int TypeStatutID ,int TypeSalaireID)
{
string psName = "getAnalyseParAgeParTranche";
SqlDataReader sqlReader = null;
SqlConnection dbConnexion = null;
List lst = new List();
try
{
dbConnexion = ConnectToDB.getConnection();
SqlCommand cmd = new SqlCommand(psName, dbConnexion);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Annee", Annee);
cmd.Parameters.AddWithValue("@MarcheID", MarcheID);
cmd.Parameters.AddWithValue("@ClientID", ClientID);
cmd.Parameters.AddWithValue("@TypeStatutID", TypeStatutID);
cmd.Parameters.AddWithValue("@TypeSalaireID", TypeSalaireID);
sqlReader = cmd.ExecuteReader();
while (sqlReader.Read())
{
AnalyseAgeDTO item = new AnalyseAgeDTO();
item.Effectif = int.Parse(sqlReader["EffectifSociete"].ToString());
item.MedianeSalaireMarche = double.Parse(sqlReader["MedianeMarche"].ToString());
item.MedianeSalaireSociete = double.Parse(sqlReader["MedianeClient"].ToString());
item.TrancheAge = sqlReader["TrancheAge"].ToString();
item.PourcentageMarche = double.Parse(sqlReader["pourcentParRapportMarche"].ToString());
lst.Add(item);
}
}
catch (Exception exp)
{
dbConnexion.Close();
}
return lst;
}
#endregion
}