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