public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CryReportChuyenPhong rpt = new CryReportChuyenPhong();
rpt.Site = this.Site;
return(rpt);
}
public void InSVChuyenPhong(object sender, EventArgs e)
{
string select = "SELECT dbo.tbl_SinhVien.Mssv, dbo.tbl_SVChuyenPhong.MaChuyenPhong, dbo.tbl_SVChuyenPhong.Mssv AS Expr1, dbo.tbl_SinhVien.Hotensv, dbo.tbl_SinhVien.Gioitinh, dbo.tbl_SinhVien.Ngaysinh, dbo.tbl_SVChuyenPhong.Phongdango, dbo.tbl_SVChuyenPhong.Phongchuyenden, dbo.tbl_SVChuyenPhong.Ngaychuyen FROM dbo.tbl_SinhVien INNER JOIN dbo.tbl_SVChuyenPhong ON dbo.tbl_SinhVien.Mssv = dbo.tbl_SVChuyenPhong.Mssv where Mssv='" + Mssv + "'";
CryReportChuyenPhong insv = new CryReportChuyenPhong();
insv.SetDataSource(ketnoi.laydlbang(select));
crtInsv.ReportSource = insv;
crtInsv.Refresh();
}
private void btIn_Click(object sender, EventArgs e)
{
if (rdInAll.Checked == true)
{
string select = "select * from tbl_SinhVien";
CryReportSV insv = new CryReportSV();
insv.SetDataSource(ketnoi.laydlbang(select));
crtInsv.ReportSource = insv;
crtInsv.Refresh();
}
else
{
if (rdInma.Checked == true)
{
string select = "select * from tbl_SinhVien where Mssv='" + cbchon.Text + "'";
CryReportSV insv = new CryReportSV();
insv.SetDataSource(ketnoi.laydlbang(select));
crtInsv.ReportSource = insv;
crtInsv.Refresh();
}
else
{
if (rdPhong.Checked == true)
{
string select = "select * from tbl_SinhVien where Mapsv='" + cbchon.Text + "'";
CryReportSV insv = new CryReportSV();
insv.SetDataSource(ketnoi.laydlbang(select));
crtInsv.ReportSource = insv;
crtInsv.Refresh();
}
else
{
if (rdtruong.Checked == true)
{
string select = "select * from tbl_SinhVien where Matruong='" + cbchon.Text + "'";
CryReportSV insv = new CryReportSV();
insv.SetDataSource(ketnoi.laydlbang(select));
crtInsv.ReportSource = insv;
crtInsv.Refresh();
}
else
{
if (rdinAllthe.Checked == true)
{
string select = "select Hotensv,Gioitinh,convert(nvarchar,Ngaysinh,104) As Ngaysinh,Mapsv from tbl_SinhVien";
CryReportTheTamtru insv = new CryReportTheTamtru();
insv.SetDataSource(ketnoi.laydlbang(select));
crtInsv.ReportSource = insv;
crtInsv.Refresh();
}
else
{
if (rdthePhong.Checked == true)
{
string select = "select Hotensv,Gioitinh,convert(nvarchar,Ngaysinh,104) As Ngaysinh,Mapsv from tbl_SinhVien where Mapsv='" + cbchon.Text + "'";
CryReportTheTamtru insv = new CryReportTheTamtru();
insv.SetDataSource(ketnoi.laydlbang(select));
crtInsv.ReportSource = insv;
crtInsv.Refresh();
}
else
{
if (rdchuyen.Checked == true)
{
string select = "SELECT dbo.tbl_SVChuyenPhong.MaChuyenPhong, dbo.tbl_SinhVien.Mssv, dbo.tbl_SinhVien.Hotensv, dbo.tbl_SinhVien.Gioitinh, dbo.tbl_SinhVien.Ngaysinh, dbo.tbl_SVChuyenPhong.Phongdango, dbo.tbl_SVChuyenPhong.Phongchuyenden,convert(nvarchar,Ngaychuyen,104) AS Ngaychuyen FROM dbo.tbl_SinhVien INNER JOIN dbo.tbl_SVChuyenPhong ON dbo.tbl_SinhVien.Mssv = dbo.tbl_SVChuyenPhong.Mssv";
CryReportChuyenPhong insv = new CryReportChuyenPhong();
insv.SetDataSource(ketnoi.laydlbang(select));
crtInsv.ReportSource = insv;
crtInsv.Refresh();
}
else
{
MessageBox.Show("Bạn phải chọn trước khi in", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
}
}
}
}