private Detail_Approvisionnement GetDetails(IDataReader dr) { Detail_Approvisionnement da = new Detail_Approvisionnement(); i = i + 1; da.Num = i; da.Code = dr["Code Article"].ToString(); da.Articles = dr["Articles"].ToString(); da.Categorie = dr["Catégorie"].ToString(); da.QuantiteA = dr["Quantité en stock"].ToString(); da.PAu = Convert.ToDouble(dr["PAu"].ToString()); da.DateApprov = Convert.ToDateTime(dr["Date_Approv"].ToString()); da.PAT = dr["PAt"].ToString(); return(da); }
public void Enregistrer(Detail_Approvisionnement det) { if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed) { ImplementeConnexion.Instance.Conn.Open(); } using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand()) { cmd.CommandText = "INSERT_DETAIL_APPROV"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@id", 5, DbType.Int32, det.Id)); cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@quantite", 10, DbType.Double, det.Quantite)); cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@pa", 10, DbType.Double, det.PAu)); cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@refarticle", 5, DbType.String, det.RefArticle)); cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@refapprov", 5, DbType.String, det.RefApprov)); cmd.ExecuteNonQuery(); } }