Ejemplo n.º 1
0
        void IntfDalRecuAD.insertToGridAvanceAutorisationDepart(GridView gridView, string numAutorisationDepart)
        {
            #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 prelevement.numAutorisationDepart = '" + numAutorisationDepart + "'";

            gridView.DataSource = serviceRecuAD.getDataTableAvanceAutorisationDepart(this.strCommande);
            gridView.DataBind();
            #endregion
        }