public List <clsQuyenDangNhap_DTO> LayQuyenDangNhapTheoMaQDN(string maQDN)
{
List <clsQuyenDangNhap_DTO> dsQuyenDangNhap = new List <clsQuyenDangNhap_DTO>();
SqlConnection con = ThaoTacDuLieu_DAO.TaoKetNoi();
string query = string.Format("SELECT * FROM QuyenDangNhap WHERE ma_quyen_dang_nhap LIKE '%{0}%' AND trang_thai = {1}", maQDN, 1);
SqlCommand cmd = ThaoTacDuLieu_DAO.TruyVan(query, con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
clsQuyenDangNhap_DTO quyenDN = new clsQuyenDangNhap_DTO();
if (!reader.IsDBNull(0))
{
quyenDN.MaQuyenDangNhap = (string)reader[0];
}
if (!reader.IsDBNull(1))
{
quyenDN.TenQuyenDangNhap = reader[1].ToString();
}
if (!reader.IsDBNull(2))
{
quyenDN.TrangThai = (bool)reader[2];
}
dsQuyenDangNhap.Add(quyenDN);
}
ThaoTacDuLieu_DAO.DongKetNoi(con);
return(dsQuyenDangNhap);
}
public static List <clsQuyenDangNhap_DTO> LayQuyenDangNhapTheoMaNV(string maNhanVien)
{
List <clsQuyenDangNhap_DTO> dsQuyenDangNhap = new List <clsQuyenDangNhap_DTO>();
SqlConnection con = ThaoTacDuLieu_DAO.TaoKetNoi();
string query = string.Format("select QuyenDangNhap.ma_quyen_dang_nhap, QuyenDangNhap.ten_quyen_dang_nhap, QuyenDangNhap.trang_thai from QuyenDangNhap,TaiKhoan where TaiKhoan.ma_quyen_dang_nhap = QuyenDangNhap.ma_quyen_dang_nhap AND ma_dang_nhap ='{0}' AND QuyenDangNhap.trang_thai = {1}", maNhanVien, 1);
////
SqlCommand cmd = ThaoTacDuLieu_DAO.TruyVan(query, con);
SqlDataReader rddtSV = cmd.ExecuteReader();
while (rddtSV.Read())
{
clsQuyenDangNhap_DTO quyenDN = new clsQuyenDangNhap_DTO();
quyenDN.MaQuyenDangNhap = (string)rddtSV[0];
quyenDN.TenQuyenDangNhap = rddtSV[1].ToString();
quyenDN.TrangThai = (bool)rddtSV[2];
dsQuyenDangNhap.Add(quyenDN);
}
ThaoTacDuLieu_DAO.DongKetNoi(con);
return(dsQuyenDangNhap);
}
