public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { Report_CTBan rpt = new Report_CTBan(); rpt.Site = this.Site; return(rpt); }
private void frmReport_CTBanHang_Load(object sender, EventArgs e) { DataTable tableMaMon = new DataTable(); tableMaMon = monBO.getMaMon(); cbMaMon.DataSource = tableMaMon; cbMaMon.DisplayMember = "MaMon"; cbMaMon.ValueMember = "MaMon"; cbMaMon.SelectedIndex = 0; SqlConnection connect; connect = new SqlConnection(@"server=.\SQLEXPRESS; Database=QuanLiCaPhe;integrated security=true"); connect.Open(); SqlDataAdapter da = new SqlDataAdapter(); string query = "Select * from tblCTDoanhThu"; SqlDataAdapter dscm = new SqlDataAdapter(query, connect); DSBangLuong ds = new DSBangLuong(); dscm.Fill(ds, "tblCTDoanhThu"); connect.Close(); Report_CTBan objRpt = new Report_CTBan(); objRpt.SetDataSource(ds.Tables[1]); crystalReportViewer_BH.ReportSource = objRpt; crystalReportViewer_BH.Refresh(); }
private void btnXem_Click(object sender, EventArgs e) { string query = ""; if (rdXemTheoNgay.Checked == true) { DateTime ngay = Convert.ToDateTime(dtNgay.Value.ToShortDateString()); Report_CTBan objRpt = new Report_CTBan(); objRpt.SetDataSource(rp.report_BH_ngay(ngay).Tables[1]); crystalReportViewer_BH.ReportSource = objRpt; crystalReportViewer_BH.Refresh(); } if (rdXemTheoMaMon.Checked == true) { string maMon = cbMaMon.SelectedValue.ToString(); Report_CTBan objRpt = new Report_CTBan(); objRpt.SetDataSource(rp.report_BH_mamon(maMon).Tables[1]); crystalReportViewer_BH.ReportSource = objRpt; crystalReportViewer_BH.Refresh(); } if (rdXemTheoCaHai.Checked == true) { DateTime ngay = Convert.ToDateTime(dtNgay.Value.ToShortDateString()); string maMon = cbMaMon.SelectedValue.ToString(); Report_CTBan objRpt = new Report_CTBan(); objRpt.SetDataSource(rp.report_BH(ngay, maMon).Tables[1]); crystalReportViewer_BH.ReportSource = objRpt; crystalReportViewer_BH.Refresh(); } }
private void btnXem_Click(object sender, EventArgs e) { string query = ""; if (rdXemTheoNgay.Checked == true) { DateTime ngay = Convert.ToDateTime(dtNgay.Value.ToShortDateString()); query = "Select * from tblCTDoanhThu where Ngay='" + ngay + "'"; } if (rdXemTheoMaMon.Checked == true) { string maMon = cbMaMon.SelectedValue.ToString(); query = "Select * from tblCTDoanhThu where MaMon='" + maMon + "'"; } if (rdXemTheoCaHai.Checked == true) { DateTime ngay = Convert.ToDateTime(dtNgay.Value.ToShortDateString()); string maMon = cbMaMon.SelectedValue.ToString(); query = "Select * from tblCTDoanhThu where MaMon='" + maMon + "' and Ngay='" + ngay + "'"; } SqlConnection connect; connect = new SqlConnection(@"server=.\SQLEXPRESS; Database=QuanLiCaPhe;integrated security=true"); connect.Open(); SqlDataAdapter da = new SqlDataAdapter(); SqlDataAdapter dscm = new SqlDataAdapter(query, connect); DSBangLuong ds = new DSBangLuong(); dscm.Fill(ds, "tblCTDoanhThu"); connect.Close(); Report_CTBan objRpt = new Report_CTBan(); objRpt.SetDataSource(ds.Tables[1]); crystalReportViewer_BH.ReportSource = objRpt; crystalReportViewer_BH.Refresh(); }