public void tktheoTruong(object sender, EventArgs e)
{
string select = "select Mssv, Hotensv, Gioitinh, convert(nvarchar,Ngaysinh,104) As Ngaysinh, Noisinh, Diachi, Sodt, Matruong, Mapsv from tbl_SinhVien where Matruong like N'%" + Truong + "%'";
CryReportSV insv = new CryReportSV();
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);
}
}
}
}
}
}
}
}