public DataTable load_user(user_DTO u)
{
string query = "SELECT t_users.Idnhanvien,t_users.PASS,t_nhanvien.Ten,t_nhanvien.Chucvu FROM t_users,t_nhanvien WHERE t_users.Idnhanvien = t_nhanvien.ID and t_users.ID =N'" + u.Temp + "'";
DataTable result = new DataTable();
result = processdata.Instance.ExecuteQuery(query);
return(result);
}
public bool update_pass(user_DTO u)
{
string query = "UPDATE t_users SET PASS = '******' WHERE ID=N'" + u.Id + "' ";
if (processdata.Instance.ExecuteNonQuery(query))
{
return(true);
}
else
{
return(false);
}
}
public void laythongtin()
{
user_DTO u = new user_DTO(Username);
DataTable data = new DataTable();
data = user_BUS.Instance.load_user(u);
foreach (DataRow row in data.Rows)
{
txt_manv.Text = row["Idnhanvien"].ToString();
txt_tennv.Text = row["Ten"].ToString();
txt_chucvu.Text = row["Chucvu"].ToString();
pass = row["PASS"].ToString();
}
}
public bool update_pass(user_DTO u)
{
return(user_DAO.Instance.update_pass(u));
}
public DataTable load_user(user_DTO u)
{
return(user_DAO.Instance.load_user(u));
}
