public void LoadPartDS(string k)
{
dataGridView1.AutoGenerateColumns = false;
var DS = (from s in SV.tbl_SinhVien
join d in SV.tbl_Diem
on s.MSSV equals d.MSSV into temp1
from t in temp1.DefaultIfEmpty()
join m in SV.tbl_DMMonHoc
on t.MaMH equals m.MaMH into temp2
from p in temp2.DefaultIfEmpty()
where s.MaKhoa == k
orderby s.MSSV
select new
{
s.MSSV,
s.Ho,
s.Ten,
s.MaKhoa,
t.MaMH,
p.TenMH,
t.Diem,
s.KetQuaTN,
s.DTB,
s.XepLoaiTN,
});
DataTable dt = ConvertDatatable.LINQToDataTable(DS);
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
dataGridView1.DataSource = dt;
label1.Text = dataGridView1.RowCount.ToString();
}
private void button3_Click(object sender, EventArgs e)
{
var query = from BangSinhVien in SV.tbl_SinhVien
join BangKhoa in SV.tbl_Khoa
on BangSinhVien.MaKhoa equals BangKhoa.MaKhoa
select new
{
BangSinhVien.MSSV,
BangSinhVien.Ho,
BangSinhVien.Ten,
BangSinhVien.GioiTinh,
BangSinhVien.NTNS,
BangSinhVien.NoiSinh,
BangSinhVien.MaKhoa,
BangKhoa.TenKhoa,
BangSinhVien.KetQuaTN,
BangSinhVien.DTB,
BangSinhVien.XepLoaiTN
};
DataTable dt = ConvertDatatable.LINQToDataTable(query);
saveFileDialog1.FileName = "DanhSachTemp";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
string FolderPath = saveFileDialog1.FileName;
using (XLWorkbook wb = new XLWorkbook())
{
//Ten sheet
wb.Worksheets.Add(dt, "Temp");
//Duong dan chua ten file excel
wb.SaveAs(FolderPath + ".xlsx");
}
MessageBox.Show("Saved succesfully at " + FolderPath);
}
}
private void Report_Load(object sender, EventArgs e)
{
SinhVienEntities1 SV = new SinhVienEntities1();
DataTable dt;
if (Login.MaKhoa == "QT")
{
var DS = (from s in SV.tbl_SinhVien
select s).ToList();
dt = ConvertDatatable.LINQToDataTable(DS);
}
else
{
var DS = (from s in SV.tbl_SinhVien
where s.MaKhoa == Login.MaKhoa
select s).ToList();
dt = ConvertDatatable.LINQToDataTable(DS);
}
PageSettings pg = new PageSettings();
pg.Margins = new Margins(0, 0, 0, 0);
pg.PaperSize = new PaperSize("A4", 1169, 827);
pg.PaperSize.RawKind = (int)PaperKind.A4;
reportViewer1.LocalReport.DataSources.Clear();
ReportDataSource rpds = new ReportDataSource("SinhVienReport", dt);
reportViewer1.ProcessingMode = ProcessingMode.Local;
reportViewer1.LocalReport.EnableExternalImages = true;
reportViewer1.LocalReport.DataSources.Add(rpds);
ReportParameter[] parameters = new ReportParameter[1]; // So luong parameters
parameters[0] = new ReportParameter("Signature", "WhiteK");
this.reportViewer1.LocalReport.SetParameters(parameters);
this.reportViewer1.SetPageSettings(pg);
this.reportViewer1.SetDisplayMode(DisplayMode.PrintLayout);
this.reportViewer1.RefreshReport();
}
private void button1_Click(object sender, EventArgs e)
{
if (Login.MaKhoa == "QT")
{
if (comboBox2.SelectedValue.ToString() == "QT")
{
var DS = (from s in SV.tbl_SinhVien
join d in SV.tbl_Diem
on s.MSSV equals d.MSSV into temp1
from t in temp1.DefaultIfEmpty()
join m in SV.tbl_DMMonHoc
on t.MaMH equals m.MaMH into temp2
from p in temp2.DefaultIfEmpty()
orderby s.MSSV
select new
{
s.MSSV,
s.Ho,
s.Ten,
s.MaKhoa,
t.MaMH,
p.TenMH,
t.Diem,
s.KetQuaTN,
s.DTB,
s.XepLoaiTN,
});
DataTable dt = ConvertDatatable.LINQToDataTable(DS);
saveFileDialog1.FileName = "DanhSachTemp";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
string FolderPath = saveFileDialog1.FileName;
using (XLWorkbook wb = new XLWorkbook())
{
//Ten sheet
wb.Worksheets.Add(dt, "Temp");
//Duong dan chua ten file excel
wb.SaveAs(FolderPath + ".xlsx");
}
MessageBox.Show("Saved succesfully at " + FolderPath);
}
}
else
{
var DS = (from s in SV.tbl_SinhVien
join d in SV.tbl_Diem
on s.MSSV equals d.MSSV into temp1
from t in temp1.DefaultIfEmpty()
join m in SV.tbl_DMMonHoc
on t.MaMH equals m.MaMH into temp2
from p in temp2.DefaultIfEmpty()
where s.MaKhoa == comboBox2.SelectedValue.ToString()
orderby s.MSSV
select new
{
s.MSSV,
s.Ho,
s.Ten,
s.MaKhoa,
t.MaMH,
p.TenMH,
t.Diem,
s.KetQuaTN,
s.DTB,
s.XepLoaiTN,
});
DataTable dt = ConvertDatatable.LINQToDataTable(DS);
saveFileDialog1.FileName = "DanhSachTemp";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
string FolderPath = saveFileDialog1.FileName;
using (XLWorkbook wb = new XLWorkbook())
{
//Ten sheet
wb.Worksheets.Add(dt, "Temp");
//Duong dan chua ten file excel
wb.SaveAs(FolderPath + ".xlsx");
}
MessageBox.Show("Saved succesfully at " + FolderPath);
}
}
}
else
{
var DS = (from s in SV.tbl_SinhVien
join d in SV.tbl_Diem
on s.MSSV equals d.MSSV into temp1
from t in temp1.DefaultIfEmpty()
join m in SV.tbl_DMMonHoc
on t.MaMH equals m.MaMH into temp2
from p in temp2.DefaultIfEmpty()
where s.MaKhoa == Login.MaKhoa
orderby s.MSSV
select new
{
s.MSSV,
s.Ho,
s.Ten,
s.MaKhoa,
t.MaMH,
p.TenMH,
t.Diem,
s.KetQuaTN,
s.DTB,
s.XepLoaiTN,
});
DataTable dt = ConvertDatatable.LINQToDataTable(DS);
saveFileDialog1.FileName = "DanhSachTemp";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
string FolderPath = saveFileDialog1.FileName;
using (XLWorkbook wb = new XLWorkbook())
{
//Ten sheet
wb.Worksheets.Add(dt, "Temp");
//Duong dan chua ten file excel
wb.SaveAs(FolderPath + ".xlsx");
}
MessageBox.Show("Saved succesfully at " + FolderPath);
}
}
}
