private void frm_fondation_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
String sql = "select* from facture where numf = '" + numf + "' and codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "'";
Program.met.recuperer_table(sql, ds, "facture");
sql = "select* from lTRAVAUX where numf = '" + numf + "' and codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "'";
Program.met.recuperer_table(sql, ds, "lTRAVAUX");
sql = "select* from ste where code='" + Program.Societe + "' ";
Program.met.recuperer_table(sql, ds, "ste");
sql = "select* from client where codes='" + Program.Societe + "' and codee = '" + Program.Exercice + "'";
Program.met.recuperer_table(sql, ds, "client");
sql = "select* from modalite where codes='" + Program.Societe + "'";
Program.met.recuperer_table(sql, ds, "modalite");
TRAVAUX100 editdevis1 = new TRAVAUX100();
editdevis1.DataDefinition.FormulaFields["numero"].Text = "'" + numf + "'";
editdevis1.SetDataSource(ds);
editdevis1.Refresh();
crystalReportViewer1.ReportSource = editdevis1;
crystalReportViewer1.Refresh();
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
TRAVAUX100 rpt = new TRAVAUX100();
rpt.Site = this.Site;
return(rpt);
}