void UpdateUserSitemap(string roleID)
{
AdmUserroleDT userRoleDT = new AdmUserroleDT();
string getUserIdCond = "RoleID = " + roleID;
DataTable userIds = userRoleDT.GetByCond(getUserIdCond);
if (userIds != null)
{
foreach (DataRow rowUserId in userIds.Rows)
{
string userId = rowUserId["UserID"].ToString();
string getRoleIdCond = "UserID = " + userId;
DataTable dtRoleIds = userRoleDT.GetByCond(getRoleIdCond);
if (dtRoleIds != null)
{
string[] roleIds = DataTableHelper.ExtractToStringArray(dtRoleIds, "RoleID");
string sitemap = AdmUserOvrController.buildSiteMap(roleIds);
AdmUserDT userDT = new AdmUserDT();
string userUpdateCond = "ID=" + userId;
userDT.Update(new string[] { "SiteMap" }, new string[] { "N'" + sitemap + "'" }, userUpdateCond);
}
}
}
}