//Lay Du lieu username , password public User LayThongTinUser(string Username) { string sql = "Select Username, Password, Ho, Ten, a.MaNhom, TenNhom, MaNguoiDung from USERS a, USERS_NHOMNGUOIDUNG b" + " Where a.MaNhom = b.MaNhom AND Username = '******'"; DataTable dtUser = connData.GetDataTable(sql); User user = new User(); if (dtUser.Rows.Count > 0) { DataRow drUser = dtUser.Rows[0]; user.Username = drUser["Username"].ToString(); user.Password = drUser["Password"].ToString(); user.Ho = drUser["Ho"].ToString(); user.Ten = drUser["Ten"].ToString(); user.MaNhom = drUser["MaNhom"].ToString(); user.TenNhom = drUser["TenNhom"].ToString(); user.MaNguoiDung = drUser["MaNguoiDung"].ToString(); } else { user.Username = ""; user.Password = ""; user.Ho = ""; user.Ten = ""; user.MaNhom = ""; user.TenNhom = ""; user.MaNguoiDung = ""; } return user; }
//Dang xuat khoi chuong trinh private void btnDangXuatHeThong_Click(object sender, EventArgs e) { rbItem_TrangChu.Select(); User user = new User(); Utilities.user = user; LoadMainForm(false); btnItem_ThemTaiKhoan.Enabled = false; this.Text = "Chưa đăng nhập hệ thống!"; btnItem_DangNhapHeThong_Click(sender, e); }