private IDetails_Sortie GetDetailSortie(IDataReader rd) { IDetails_Sortie detailsortie = new Detail_Sortie_Facture(); detailsortie.Id = Convert.ToInt32(rd["iddetail"].ToString()); detailsortie.Produit = rd["designationprod"].ToString(); detailsortie.Dosage = rd["dosage"].ToString(); detailsortie.Quantite = Convert.ToInt32(rd["Quantite"].ToString()); detailsortie.Pu = Convert.ToDecimal(rd["PU"].ToString()); detailsortie.Pt = Convert.ToDecimal(rd["PT"].ToString()); detailsortie.Date_sortie = Convert.ToDateTime(rd["date_sortie"].ToString()); detailsortie.Malade = rd["noms"].ToString(); return(detailsortie); }
public IDetails_Sortie OneProduitDetail(string produit) { IDetails_Sortie detailapprov = new Detail_Sortie_Facture(); if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed) { ImplementeConnexion.Instance.Conn.Open(); } using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand()) { cmd.CommandText = "SELECT_ONE_PRODUIT_SORTIE_DETAILS"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@produit", 4, DbType.String, produit)); IDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { detailapprov = GetDetailSortie(dr); } dr.Dispose(); } return(detailapprov); }