public string GetHoTen(EC_DangNhap etli) { return(cn.LayGiaTri("SELECT B.HoLot+' '+B.Ten as HoTen FROM DangNhap A inner join NhanVien B on A.MaNV= B.MaNV Where TaiKhoan='" + etli.TaiKhoan + "' and MatKhau= '" + etli.MatKhau + "'")); }
public void DeleteUser(EC_DangNhap etli) { cn.ThucThiSQL("DELETE FROM DangNhap where ID=" + etli.ID); }
public string GetQuyen(EC_DangNhap etli) { return(cn.LayGiaTri("SELECT Quyen FROM DangNhap Where TaiKhoan='" + etli.TaiKhoan + "' and MatKhau= '" + etli.MatKhau + "'")); }
public DataTable GetLogin(EC_DangNhap etli) { return(cn.LayDuLieu("SELECT * FROM DangNhap Where TaiKhoan='" + etli.TaiKhoan + "' and MatKhau= '" + etli.MatKhau + "'")); }
public void AddUser(EC_DangNhap etli) { cn.ThucThiSQL(@"INSERT INTO DangNhap (TaiKhoan, MatKhau, Quyen, MaNV) VALUES ('" + etli.TaiKhoan + "','" + etli.MatKhau + "'," + etli.Quyen + "," + etli.MaNV + ")"); }
public void DeleteUser(EC_DangNhap etli) { SQL.DeleteUser(etli); }
public string GetHoTen(EC_DangNhap etli) { return(SQL.GetHoTen(etli)); }
public void AddUser(EC_DangNhap etli) { SQL.AddUser(etli); }
public DataTable GetLogin(EC_DangNhap etli) { return(SQL.GetLogin(etli)); }
//xóa dữ liệu public void XoaDuLieu(EC_DangNhap et) { cn.ThucThiCauLenhSQL(@"DELETE from DangNhap where TenTaiKhoan=N'" + et.TenDangNhap + "'"); }
//sửa dữ liệu public void SuaDuLieu(EC_DangNhap et) { cn.ThucThiCauLenhSQL(@"UPDATE DangNhap SET MatKhau =N'" + et.MatKhau + "', Quyen =N'" + et.PhanQuyen + "' where TenTaiKhoan=N'" + et.TenDangNhap + "'"); }
//Hàm thêm dữ liệu public void ThemDuLieu(EC_DangNhap et) { cn.ThucThiCauLenhSQL(@"INSERT INTO DangNhap(TenTaiKhoan, MatKhau, Quyen)) VALUES (N'" + et.TenDangNhap + "',N'" + et.MatKhau + "',N'" + et.PhanQuyen + "')"); }