public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
Report_BanSDNhieu rpt = new Report_BanSDNhieu();
rpt.Site = this.Site;
return(rpt);
}
private void button1_Click(object sender, EventArgs e)
{
if (txtSoLuong.Text == "")
{
MessageBox.Show("Vui lòng nhập số lượng bàn bạn muốn xem");
}
else
{
int i = int.Parse(txtSoLuong.Text);
Report_BanSDNhieu objRpt = new Report_BanSDNhieu();
objRpt.SetDataSource(rpsrv.report_BSDN(i).Tables[1]);
crystalReportViewer_BanSDNhieu.ReportSource = objRpt;
}
}
private void button1_Click(object sender, EventArgs e)
{
if (txtSoLuong.Text == "")
{
MessageBox.Show("Vui lòng nhập số lượng bàn bạn muốn xem");
}
else
{
int i = int.Parse(txtSoLuong.Text);
SqlConnection connect;
connect = new SqlConnection(@"server=.\SQLEXPRESS; Database=QuanLiCaPhe;integrated security=true");
connect.Open();
SqlDataAdapter da = new SqlDataAdapter();
string query = "SELECT top " + i + " * FROM tblBanSDNhieu ORDER BY LuotSD DESC";
SqlDataAdapter dscm = new SqlDataAdapter(query, connect);
DSDoanhThu ds = new DSDoanhThu();
dscm.Fill(ds, "tblBanSDNhieu");
connect.Close();
Report_BanSDNhieu objRpt = new Report_BanSDNhieu();
objRpt.SetDataSource(ds.Tables[1]);
crystalReportViewer_BanSDNhieu.ReportSource = objRpt;
crystalReportViewer_BanSDNhieu.Refresh();
}
}
