public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { rptChungTu rpt = new rptChungTu(); rpt.Site = this.Site; return(rpt); }
public ChungTu(string cmnd) { InitializeComponent(); string conStr = @"Data Source=DESKTOP-BV4LABJ\SQLEXPRESS;Initial Catalog=QuanLyDanCu;Persist Security Info=True;User ID=sa;Password=12345"; SqlConnection conn = new SqlConnection(conStr); string sql = $"SELECT GiayChungTus.CoQuanBaoTu as CoQuanBaoTu,GiayChungTus.MaGiayChungTu as So,GiayChungTus.MaQuyen as MaQuyen,GiayChungTus.NgayTu as NgayTu,CongDans.HoLot + ' ' + CongDans.Ten as Ten,CongDans.NgaySinh as NgaySinh,CongDans.DanToc as DanToc,CongDans.QuocTich as QuocTich,CongDans.DiaChiThuongTru as DiaChi,CongDans.soCMND as CMND,GiayChungTus.NoiChet as NoiChet,GiayChungTus.NguyenNhan as NguyenNhan, CASE WHEN GioiTinh = 1 THEN 'Nam' WHEN GioiTinh = 0 THEN 'Nu' END AS[GT] FROM CongDans inner join GiayChungTus on CongDans.MaCD = GiayChungTus.MaCD WHERE CongDans.soCMND = '{cmnd}'"; SqlDataAdapter adapter = new SqlDataAdapter(sql, conn); DataSetChungTu chungTu = new DataSetChungTu(); adapter.Fill(chungTu.TblChungTu); rptChungTu report = new rptChungTu(); report.SetDataSource(chungTu); rptViewChungTu.ReportSource = report; }