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)); }