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);
}
}
