public void Quyen_NhanVien_Update(DuLieu_DangNhap dl)
{
xl.table_Select("update PhanQuyen set BanHang = '" + dl.BanHang + "',Kho = '" + dl.Kho + "',TongKet = '" + dl.TongKet + "' where TaiKhoan = N'" + dl.TaiKhoan + "' and MaNV='" + dl.MaNV + "'");
}
public DataTable TaiKhoan_Search(DuLieu_DangNhap dl)
{
return(xl.table_Select("select * from PhanQuyen where TaiKhoan = N'" + dl.TaiKhoan + "'"));
}
public DataTable MaNV_Search(DuLieu_DangNhap dl)
{
return(xl.table_Select("select * from PhanQuyen where MaNV = N'" + dl.MaNV + "'"));
}
public DataTable TenNV_PQ(DuLieu_DangNhap dl)
{
return(xl.table_Select("select NhanVien.MaNV,TenNhanVien from PhanQuyen,NhanVien where PhanQuyen.MaNV=NhanVien.MaNV and PhanQuyen.MaNV='" + dl.MaNV + "'"));
}
public DataTable MaNV_PQ(DuLieu_DangNhap dl)
{
return(xl.table_Select("select MaNV from PhanQuyen where TaiKhoan = N'" + dl.TaiKhoan + "' "));
}
//public DataTable TaiKhoan_PQ(DuLieu_DangNhap dl)
//{
// //return xl.table_Select("select TaiKhoan from PhanQuyen where TaiKhoan=N'" + dl.TaiKhoan + "' and MaNV='"+ dl.MaNV + "'");
//}
public DataTable TaiKhoan_PQ(DuLieu_DangNhap dl)
{
return(xl.table_Select("select distinct TaiKhoan from PhanQuyen "));
}
public DataTable TongKet_PQ(DuLieu_DangNhap dl)
{
return(xl.table_Select("select TongKet from PhanQuyen where TaiKhoan=N'" + dl.TaiKhoan + "' and MaNV='" + dl.MaNV + "'"));
}
public DataTable DangNhap_Select(DuLieu_DangNhap dl)
{
return(xl.table_Select("select* from PhanQuyen"));
}