void IntfDalCommissionDevis.insertToGridCommissionDevis(GridView gridView, string param, string paramLike, string valueLike, string numProforma) { #region declaration IntfDalCommissionDevis serviceCommissionDevis = new ImplDalCommissionDevis(); #endregion #region implementation this.strCommande = "SELECT commissiondevis.idCommissionDevis, commissiondevis.destination, commissiondevis.poids,"; this.strCommande += " commissiondevis.nombre, commissiondevis.pieceJustificatif, commissiondevis.fraisEnvoi,"; this.strCommande += " commissiondevis.numDesignation, commissiondevis.typeCommission, commissiondevis.numTrajet,"; this.strCommande += " commissiondevis.numProforma FROM commissiondevis"; this.strCommande += " WHERE commissiondevis.numProforma = '" + numProforma + "' AND"; this.strCommande += " " + paramLike + " LIKE '%" + valueLike + "%'"; this.strCommande += " ORDER BY " + param; gridView.DataSource = serviceCommissionDevis.getDataTableCommissionDevis(this.strCommande); gridView.DataBind(); #endregion }
string IntfDalCommissionDevis.insertCommissionDevis(crlCommissionDevis CommissionDevis, string sigleAgence) { #region declaration IntfDalCommissionDevis serviceCommissionDevis = new ImplDalCommissionDevis(); int nombreInsertion = 0; string idCommissionDevis = ""; string numRecepteur = "NULL"; #endregion #region implementation if (CommissionDevis != null) { if (CommissionDevis.NumRecepteur != "") { numRecepteur = "'" + CommissionDevis.NumRecepteur + "'"; } CommissionDevis.IdCommissionDevis = serviceCommissionDevis.getidCommissionDevis(sigleAgence); this.strCommande = "INSERT INTO `commissiondevis` (`idCommissionDevis`,`destination`,`poids`,`nombre`,`pieceJustificatif`,"; this.strCommande += " `fraisEnvoi`,`numDesignation`,`typeCommission`,`numTrajet`,`numProforma`,`numExpediteur`,`numRecepteur`)"; this.strCommande += " VALUES ('" + CommissionDevis.IdCommissionDevis + "','" + CommissionDevis.Destination + "',"; this.strCommande += "'" + CommissionDevis.Poids + "','" + CommissionDevis.Nombre + "','" + CommissionDevis.PieceJustificatif + "',"; this.strCommande += "'" + CommissionDevis.FraisEnvoi.ToString("0") + "','" + CommissionDevis.NumDesignation + "',"; this.strCommande += "'" + CommissionDevis.TypeCommission + "','" + CommissionDevis.NumTrajet + "','" + CommissionDevis.NumProforma + "',"; this.strCommande += "'" + CommissionDevis.NumExpediteur + "'," + numRecepteur + ")"; this.serviceConnectBase.openConnection(); nombreInsertion = this.serviceConnectBase.requete(this.strCommande); if (nombreInsertion == 1) { idCommissionDevis = CommissionDevis.IdCommissionDevis; } this.serviceConnectBase.closeConnection(); } #endregion return(idCommissionDevis); }