public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
rptKetHon rpt = new rptKetHon();
rpt.Site = this.Site;
return(rpt);
}
public KetHon(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 DonViQuanLis.Phuong as Phuong,DonViQuanLis.Quan as Quan,DonViQuanLis.ThanhPho as ThanhPho, GiayDangKyKetHons.MaGDKKetHon as So,MaQuyen,NgayDangKi,MaCD_Chong,Chong.HoLot+' '+Chong.Ten as TenChong,Chong.NgaySinh as NgaySinhChong,Chong.DanToc as DanTocChong,Chong.QuocTich as QuocTichChong,Chong.DiaChiThuongTru as DiaChiChong,Chong.soCMND as CMNDChong,Vo.HoLot+' '+Vo.Ten as TenVo,Vo.NgaySinh as NgaySinhVo,Vo.DanToc as DanTocVo,Vo.QuocTich as QuocTichVo,Vo.DiaChiThuongTru as DiaChiVo,Vo.soCMND as CMNDVo from DonViQuanLis, GiayDangKyKetHons inner join CongDans as Chong on GiayDangKyKetHons.MaCD_Chong = Chong.MaCD inner join CongDans as Vo on GiayDangKyKetHons.MaCD_Vo = Vo.MaCD where Chong.soCMND='{cmnd}' ";
SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
DataSetKetHon ketHon = new DataSetKetHon();
adapter.Fill(ketHon.TblKetHon);
rptKetHon report = new rptKetHon();
report.SetDataSource(ketHon);
rptviewKetHon.ReportSource = report;
}
