private void loadReportTous(String s)
{
try
{
FicheDepot rpt = new FicheDepot();
OleDbCommand cmd = new OleDbCommand(@"SELECT Entree.date_entree, Entree.montant, Compte.designation, Compte.typeCompte, Client.matricule, Client.nom, Client.postnom, Client.prenom
FROM (Client INNER JOIN Compte ON Client.id=Compte.id_Client) INNER JOIN Entree ON Compte.id=Entree.id_compte where Compte.typeCompte=@string ", Factory.Instance.connectDB());
OleDbDataAdapter sa = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
IDataParameter paramString = cmd.CreateParameter();
paramString.ParameterName = "@string";
paramString.Value = Convert.ToString(s);
cmd.Parameters.Add(paramString);
cmd.ExecuteNonQuery();
sa.Fill(ds, "doc");
rpt.SetDataSource(ds.Tables["doc"]);
crvEntree.ReportSource = rpt;
crvEntree.Refresh();
sa.Dispose();
ds.Dispose();
cmd.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Erreur de l'afichage du rapport", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
private void btnAfficher_Click(object sender, EventArgs e)
{
if (chk.Checked && rdFc.Checked)
{
if (Factory.idAgentConnecte > 0)
{
loadReportTous1(rdFc.Text.ToString());
}
else
{
loadReportTous(rdFc.Text.ToString());
}
}
else if (chk.Checked && rdUsd.Checked)
{
if (Factory.idAgentConnecte > 0)
{
loadReportTous1(rdUsd.Text.ToString());
}
else
{
loadReportTous(rdUsd.Text.ToString());
}
}
else
{
if (Factory.idAgentConnecte > 0)
{
try
{
FicheDepot rpt = new FicheDepot();
OleDbCommand cmd = new OleDbCommand(@"SELECT Sortie.date_sortie, Sortie.montant, Client.matricule, Client.nom, Client.postnom, Client.prenom, Compte.designation, Compte.typeCompte FROM Agent
INNER JOIN ((Client INNER JOIN Compte ON Client.id = Compte.id_Client)
INNER JOIN Sortie ON Compte.id = Sortie.id_compte) ON Agent.id = Client.id_agent
WHERE (((Sortie.date_sortie)=@date) AND ((Client.id)=@idClient) AND ((Agent.id)=@idAgent))", Factory.Instance.connectDB());
IDataParameter paramDate = cmd.CreateParameter();
paramDate.ParameterName = "@date";
paramDate.Value = Convert.ToDateTime(dtSortie.Text);
IDataParameter paramid = cmd.CreateParameter();
paramid.ParameterName = "@idClient";
paramid.Value = ((Client)cboClient.SelectedItem).Id;
IDataParameter paramidAgent = cmd.CreateParameter();
paramidAgent.ParameterName = "@idClient";
paramidAgent.Value = Factory.idAgentConnecte;
cmd.Parameters.Add(paramDate);
cmd.Parameters.Add(paramid);
cmd.Parameters.Add(paramidAgent);
cmd.ExecuteNonQuery();
OleDbDataAdapter sa = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
sa.Fill(ds, "doc");
rpt.SetDataSource(ds.Tables["doc"]);
crvEntree.ReportSource = rpt;
crvEntree.Refresh();
sa.Dispose();
ds.Dispose();
cmd.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Erreur de l'afichage du rapport", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
else
{
loadReport();
}
}
}
