public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
crptDoanhThuTrongNgay rpt = new crptDoanhThuTrongNgay();
rpt.Site = this.Site;
return(rpt);
}
public void BaoCaoDoanhThuTrongNgay()
{
//HoaDonBUS hdBUS=new HoaDonBUS();
//List<HoaDonDTO> ListHDTrongNgay = hdBUS.LoadDsHDTrongNgay();
cmd.CommandText = "select hd.MAHD, nv.TENNV, b.TENBAN, Sum(ct.SL*ct.GIABAN) as TONGTIEN"
+ " from HOA_DON hd, CHI_TIET_HOA_DON ct, NHAN_VIEN nv, BAN b"
+ " where hd.MAHD=ct.MAHD and hd.MANVLAP=nv.MANV and hd.SOBAN=b.SOBAN and hd.TRANGTHAI=1 and hd.NGAYLAP=CONVERT(varchar, getdate(), 23)"
+ " group by hd.MAHD, nv.TENNV, b.TENBAN";
da.SelectCommand = cmd;
DataTable dt = new DataTable("DoanhThuTrongNgay");
da.Fill(dt);
crptDoanhThuTrongNgay rp = new crptDoanhThuTrongNgay();
rp.SetDataSource(dt);
crystalReportViewer1.ReportSource = rp;
}
