Exemple #1
0
        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);
                    }
                }
            }
        }