private void DgvData_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (cbHoaDon.Checked == true || cbDTNam.Checked == true || cbDTThang.Checked == true) { if (e.ColumnIndex == DgvData.Columns["Detail"].Index && e.RowIndex >= 0 && e.RowIndex < DgvData.Rows.Count - 1) { DTO_HoaDon hd = busTK.curHD(DgvData.CurrentRow.Cells["MaHD"].FormattedValue.ToString()); string TenNV = (from DataRow dr in busNv.DanhSachNhanVienAll().Rows where string.Compare(dr[0].ToString(), hd.MaNV, true) == 0 select dr[2].ToString()).FirstOrDefault(); string TenBan = (from DataRow dr in busBan.DanhSachBanALL().Rows where (int)dr[0] == hd.IdBan select dr[1].ToString()).FirstOrDefault(); DataTable dtHDCT = busTK.ThongkeHoaDonChitiet(hd.MaHD); CrystalReport.Detail cb = new CrystalReport.Detail(); TextObject txtnv = (TextObject)cb.ReportDefinition.Sections["Section1"].ReportObjects["txtTenNV"]; txtnv.Text = TenNV; TextObject txtDate = (TextObject)cb.ReportDefinition.Sections["Section1"].ReportObjects["TxtNgayHD"]; txtDate.Text = hd.NgayHD.ToString("dd/MM/yyyy"); TextObject txthd = (TextObject)cb.ReportDefinition.Sections["Section2"].ReportObjects["txtMaHD"]; txthd.Text = hd.MaHD; TextObject txtvt = (TextObject)cb.ReportDefinition.Sections["Section2"].ReportObjects["txtViTri"]; txtvt.Text = TenBan; TextObject txtkh = (TextObject)cb.ReportDefinition.Sections["Section2"].ReportObjects["txtKH"]; txtkh.Text = hd.SDT_KH; TextObject txtkm = (TextObject)cb.ReportDefinition.Sections["Section4"].ReportObjects["TextKM"]; txtkm.Text = hd.KhuyenMai.ToString() + "%"; TextObject txttongtien = (TextObject)cb.ReportDefinition.Sections["Section5"].ReportObjects["TxtTongTien"]; txttongtien.Text = (hd.ThanhTien * 100 / (100 - hd.KhuyenMai)).ToString(); TextObject txtThanhTien = (TextObject)cb.ReportDefinition.Sections["Section5"].ReportObjects["txtThanhtien"]; txtThanhTien.Text = hd.ThanhTien.ToString(); TextObject txtname = (TextObject)cb.ReportDefinition.Sections["Section1"].ReportObjects["TextName"]; txtname.Text = "CHI TIẾT HOÁ ĐƠN"; cb.Database.Tables["CTHD"].SetDataSource(dtHDCT); frmDetail frm = new frmDetail(cb); frm.Show(); } } }
public frmDetail(CrystalReport.Detail detail) { InitializeComponent(); crystalReportViewer1.ReportSource = detail; }