public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { rptKhaiSinhBS rpt = new rptKhaiSinhBS(); rpt.Site = this.Site; return(rpt); }
public BanSaoKhaiSinh(string so) { 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 DonViQuanLis.Phuong as Phuong,DonViQuanLis.Quan as Quan,DonViQuanLis.ThanhPho as ThanhPho,So,MaQuyen,con.HoLot+' '+ con.Ten as Ten,con.NgaySinh,NoiSinh,con.QueQuan,con.DanToc,con.QuocTich,cha.HoLot + ' ' + cha.Ten as TenCha,cha.DanToc as DanTocCha,cha.QuocTich as QuocTichCha,me.HoLot + ' ' + me.Ten as TenMe,me.DanToc as DanTocMe,me.QuocTich as QuocTichMe,giamho.HoLot + ' ' + giamho.Ten as GiamHo,QuanHe, CASE WHEN con.GioiTinh = 1 THEN 'Nam' WHEN con.GioiTinh = 0 THEN 'Nu' END AS[GT] from DonViQuanLis, GiayKhaiSinhs inner join CongDans as con on con.MaCD = GiayKhaiSinhs.MaCD inner join CongDans as cha on cha.MaCD = GiayKhaiSinhs.MaCD_Cha inner join CongDans as me on me.MaCD = GiayKhaiSinhs.MaCD_Me inner join CongDans as giamho on giamho.MaCD = GiayKhaiSinhs.MaCD_NguoiKhai where GiayKhaiSinhs.So='{so}'"; SqlDataAdapter adapter = new SqlDataAdapter(sql, conn); DataSetKhaiSinh khaiSinh = new DataSetKhaiSinh(); adapter.Fill(khaiSinh.TblKhaiSinh); rptKhaiSinhBS report = new rptKhaiSinhBS(); report.SetDataSource(khaiSinh); rptViewBSKhaiSinh.ReportSource = report; }