public void Sortie_Entree_Sortie() { try { FrmImpression frm = new FrmImpression(); if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed) { ImplementeConnexion.Instance.Conn.Open(); } using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand()) { cmd.CommandText = "SELECT_ES"; cmd.CommandType = CommandType.StoredProcedure; DataSet ds = new DataSet(); SqlDataAdapter dscmd = new SqlDataAdapter((SqlCommand)cmd); dscmd.Fill(ds, "Affichage_Details_ES"); CR_Entree_Sortie entree = new CR_Entree_Sortie(); entree.SetDataSource(ds); frm.crystalReportViewer1.ReportSource = entree; frm.crystalReportViewer1.Refresh(); frm.Visible = true; } } catch (Exception ex) { MessageBox.Show("L'erreur suivant est survenue : " + ex.Message); } }
private void button2_Click(object sender, EventArgs e) { try { FrmImpression frm = new FrmImpression(); frm.RegistreMariages(); frm.ShowDialog(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button2_Click(object sender, EventArgs e) { try { FrmImpression fr = new FrmImpression(); fr.RegistreAnnonces("GetAnnonceToday"); fr.ShowDialog(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void Sortie_Livre_Caisse_Article(string code, string mois, string annee) { try { FrmImpression frm = new FrmImpression(); if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed) { ImplementeConnexion.Instance.Conn.Open(); } using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand()) { cmd.CommandText = "SELECT_LIVRE_CAISSE"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@code", 30, DbType.String, code)); cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@mois", 30, DbType.String, mois)); cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@annee", 30, DbType.String, annee)); DataSet ds = new DataSet(); SqlDataAdapter dscmd = new SqlDataAdapter((SqlCommand)cmd); dscmd.Fill(ds, "Affichage_Livre_de_Caisse"); CR_Livre_Caisse entree = new CR_Livre_Caisse(); entree.SetDataSource(ds); frm.crystalReportViewer1.ReportSource = entree; frm.crystalReportViewer1.Refresh(); //frm.Visible = true; } } catch (Exception ex) { MessageBox.Show("L'erreur suivant est survenue : " + ex.Message); } }
public void Sortie_Fiche_Stock_Article(string code) { try { FrmImpression frm = new FrmImpression(); if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed) { ImplementeConnexion.Instance.Conn.Open(); } using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand()) { cmd.CommandText = "SELECT_FICHE_STOCK_ARTICLE"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@code", 30, DbType.String, code)); DataSet ds = new DataSet(); SqlDataAdapter dscmd = new SqlDataAdapter((SqlCommand)cmd); dscmd.Fill(ds, "Affichage_Details_Historique"); CR_Fiche_De_Stock entree = new CR_Fiche_De_Stock(); entree.SetDataSource(ds); frm.crystalReportViewer1.ReportSource = entree; frm.crystalReportViewer1.Refresh(); frm.Visible = true; } } catch (Exception ex) { MessageBox.Show("L'erreur suivant est survenue : " + ex.Message); } }