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 }
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 }
string IntfDalRecuAD.insertRecuAD(crlRecuAD RecuAD) { #region declaration IntfDalRecuAD serviceRecuAD = new ImplDalRecuAD(); int nombreInsertion = 0; string numRecu = ""; string numPrelevement = "NULL"; string numFacture = "NULL"; #endregion #region implementation if (RecuAD != null) { if (RecuAD.NumPrelevement != "") { numPrelevement = "'" + RecuAD.NumPrelevement + "'"; } if (RecuAD.NumFacture != "") { numFacture = "'" + RecuAD.NumFacture + "'"; } RecuAD.NumRecuAD = serviceRecuAD.getNumRecuAD(RecuAD.agent.agence.SigleAgence); this.strCommande = "INSERT INTO `recuad` (`numRecuAD`,`numPrelevement`,`matriculeAgent`,`libele`,`montant`,`dateRecu`,`numFacture`)"; this.strCommande += " VALUES ('" + RecuAD.NumRecuAD + "', " + numPrelevement + ", '" + RecuAD.MatriculeAgent + "',"; this.strCommande += " '" + RecuAD.Libele + "','" + RecuAD.Montant + "','" + RecuAD.Date.ToString("yyyy-MM-dd") + "'," + numFacture + ")"; this.serviceConnectBase.openConnection(); nombreInsertion = this.serviceConnectBase.requete(this.strCommande); if (nombreInsertion == 1) { numRecu = RecuAD.NumRecuAD; } this.serviceConnectBase.closeConnection(); } #endregion return(numRecu); }
string IntfDalRecuAD.insertRecuADAssociation(crlRecuAD RecuAD, string numAutorisationDepart) { #region declaration string numRecuAD = ""; IntfDalRecuAD serviceRecuAD = new ImplDalRecuAD(); #endregion #region implementation if (RecuAD != null && numAutorisationDepart != "") { RecuAD.NumRecuAD = serviceRecuAD.insertRecuAD(RecuAD); if (RecuAD.NumRecuAD != "") { if (serviceRecuAD.insertAssociationRecuADAD(RecuAD.NumRecuAD, numAutorisationDepart)) { numRecuAD = RecuAD.NumRecuAD; } } } #endregion return(numRecuAD); }