public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { crptDoanhThuTungSPTrongThang rpt = new crptDoanhThuTungSPTrongThang(); rpt.Site = this.Site; return(rpt); }
public void BaoCaoDoanhThuTungSPTrongThang() { DateTime tuNgay = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); DateTime denNgay = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day); cmd.CommandText = "select tu.TENTU, cthd.GIABAN, sum(cthd.SL) as TONGSL, sum(cthd.SL*cthd.GIABAN) as TONGDOANHTHU" + " from THUC_UONG tu, CHI_TIET_HOA_DON cthd, HOA_DON hd" + " where tu.MATU=cthd.MATU and cthd.MAHD=hd.MAHD and tu.TRANGTHAIXOA=0 and hd.NGAYLAP>='" + string.Format("{0:yyyy-MM-dd HH:mm:ss}", tuNgay) + "' and hd.NGAYLAP<='" + string.Format("{0:yyyy-MM-dd HH:mm:ss}", denNgay) + "'" + " group by tu.MATU, tu.TENTU, cthd.GIABAN"; da.SelectCommand = cmd; DataTable dt = new DataTable("DoanhThuTungSPTrongThang"); da.Fill(dt); crptDoanhThuTungSPTrongThang rp = new crptDoanhThuTungSPTrongThang(); rp.SetDataSource(dt); crystalReportViewer1.ReportSource = rp; }