private void cmbNV_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
int nvid = 0;
int.TryParse(cmbNV.SelectedValue.ToString(), out nvid);
if (nvid > 0)
{
string sql = @"select a.TenNV, a.DiaChi, a.SDT, c.TenChucDanh, d.NgayHieuLuc, d.NgayHetHan from NhanVien a
inner join NhanVienChucDanh b on a.NhanVienID = b.NhanVienID
inner join LuongChucDanh c on b.ChucDanhID = c.ChucDanhID
inner join HopDong d on a.NhanVienID = d.NhanVienID
where a.NhanVienID = " + cmbNV.SelectedValue;
DataTable dt = Core.Core.GetData(sql);
sql = @"select a.TenNV, a.NgaySinh, a.DiaChi, a.SoCMND, c.TenChucDanh from NhanVien a
inner join NhanVienChucDanh b on a.NhanVienID = b. NhanVienID
inner join LuongChucDanh c on b.ChucDanhID = c.ChucDanhID where c.ChucDanhID = 2";
DataTable dt2 = Core.Core.GetData(sql);
MauHopDongLaoDong reports = new MauHopDongLaoDong(dt, dt2);
documentViewer1.DocumentSource = reports;
reports.CreateDocument();
}
}
catch (Exception ex)
{
}
}
protected void LoadBaoCao()
{
try
{
MauHopDongLaoDong reports = new MauHopDongLaoDong();
documentViewer1.DocumentSource = reports;
reports.CreateDocument();
}
catch (Exception)
{
}
}