public void LoadDataGridView(DataGridViewX dgv)
{
kn.LoadDGV("SELECT Mato,Tento,Maphongban,Ghichu FROM tblTolamviec", dgv);
}
//load du lieu vao gridview
public void LoadDataGridView_PhongVan(DataGridViewX dgv)
{
kn.LoadDGV("SELECT Madotphongvan,Tendotphongvan,Madottuyendung,Manguoiphongvan,Ngaybatdau,Ngayketthuc,Chude,Madiadiem,Tinhtrang,Ghichu FROM tblDotphongvan", dgv);
}
public void LoadDataGridView(DataGridViewX dgv)
{
kn.LoadDGV("SELECT * FROM tblTinhoc", dgv);
}
//--------------------------
public void LoadDataGridView(DataGridViewX dgv)
{
kn.LoadDGV("SELECT Manghiviec,MaNV,Ngayquyetdinh,Ngayhieuluc,Lydo,Ghichu FROM tblNghiviec", dgv);
}
public void LoadDataGridView(DataGridViewX dgv)
{
kn.LoadDGV("SELECT Machucvu,Tenchucvu,Hesochucvu,Ghichu FROM tblChucvu", dgv);
}
//load du lieu vao gridview
public void LoadDataGridView(DataGridViewX dgv)
{
kn.LoadDGV("SELECT Maungvien,Tenungvien,CMND,Ngaycap,Tinhthanh,Ngaysinh,Gioitinh,Diachi,Email,SDTrieng,SDTnha,Tinhtranghonnhan,Mabangcap,Mangoaingu,Matinhoc,Namkinhnghiem,Ngaynophoso,Trangthai,Madotphongvan,Madantoc,Matongiao FROM tblUngvien", dgv);
}
public void LoadDataGridView(DataGridViewX dgv)
{
kn.LoadDGV("SELECT Maphongban,Tenphongban,Ghichu, Email FROM tblPhongban", dgv);
}
public void LoadDataGridView(DataGridViewX dgv)
{
kn.LoadDGV("SELECT MaLuong,MaNV,Thang,Ngaylamviec,Phucap,BHXH,BHYT,Luongcoban,TongLuong,ThucLinh,Heso,GhiChu FROM tblLLuong", dgv);
}
//--------------------------
public void LoadDataGridView_PhongBan(DataGridViewX dgvPhongBan)
{
kn.LoadDGV("SELECT Maphongban,Tenphongban FROM tblPhongban", dgvPhongBan);
}
//load du lieu vao gridview
public void LoadDataGridView(DataGridViewX dgv)
{
kn.LoadDGV("SELECT Mahopdong,MaNV,Ngaybatdau,Ngayketthuc,Lanky,Noidung,Ngayky,Tennguoiky,Ghichu FROM tblHopdong", dgv);
}
public void LoadDataGridView(DataGridViewX dgv)
{
kn.LoadDGV("SELECT * FROM tblBangcap", dgv);
}
public void LoadDataGridView_User(DataGridViewX dgv)
{
kn.LoadDGV("select Usename,'*****' as Pass from tblNguoidung", dgv);
}
public void LoadDataGridView(DataGridViewX dgv)
{
kn.LoadDGV("SELECT * FROM tblDiadiem", dgv);
}
public void LoadDataGridView(DataGridViewX dgv)
{
kn.LoadDGV("SELECT * FROM tblNguoidung", dgv);
}
//load du lieu vao gridview de tim kiem nhan vien
public void LoadDataGridView_TK(DataGridViewX dgv)
{
kn.LoadDGV("SELECT * FROM tblNhanvien", dgv);
}
//load dl vao gridview
public void LoadDataGridView_TTChung(DataGridViewX dgv)
{
kn.LoadDGV("SELECT MaNV,TenNV,CMND,Ngaycap,Tinhthanh,Ngaysinh,Gioitinh,Nguyenquan,Dctamtru,Email,SDTrieng,SDTnha,Tinhtranghonnhan,Tinhtranglamviec FROM tblNhanvien", dgv);
}
public void LoadDataGridView(DataGridViewX dgv)
{
kn.LoadDGV("SELECT * FROM tblNgoaingu", dgv);
}