void IntfDalRecuAD.insertToGridRecuADDecaisser(GridView gridView, string param, string paramLike, string valueLike, string matriculeAgent, DateTime dateDebut, DateTime dateFin)
{
#region declaration
IntfDalRecuAD serviceRecuAD = new ImplDalRecuAD();
#endregion
#region implementation
this.strCommande = "SELECT recuad.numRecuAD, recuad.matriculeAgent, recuad.libele, recuad.montant,";
this.strCommande += " recuad.dateRecu, recuad.numPrelevement, typeprelevement.commentaire FROM recuad";
this.strCommande += " Inner Join prelevement ON prelevement.numPrelevement = recuad.numPrelevement";
this.strCommande += " Inner Join typeprelevement ON typeprelevement.typePrelevement = prelevement.typePrelevement";
this.strCommande += " WHERE recuad.matriculeAgent = '" + matriculeAgent + "' AND";
this.strCommande += " recuad.dateRecu <= '" + dateFin.ToString("yyyy-MM-dd") + "' AND";
this.strCommande += " recuad.dateRecu >= '" + dateDebut.ToString("yyyy-MM-dd") + "'";
gridView.DataSource = serviceRecuAD.getDataTableRecuADDecaisser(this.strCommande);
gridView.DataBind();
#endregion
}
