예제 #1
0
        public List <User> getUsers(string groupId)
        {
            string      sql = SecurityDataScripts.GetUserListSQL(groupId);
            DataTable   tb  = SecuritySettings.Execute(sql);
            List <User> ret = new List <User>();

            foreach (DataRow r in tb.Rows)
            {
                User user = new User();
                user.Id          = r["user_id"].ToString();
                user.DisplayName = r["display_name"].ToString();
                if (string.IsNullOrEmpty(user.DisplayName))
                {
                    user.DisplayName = user.Id;
                }
                user.CreateDate = r["create_date"].ToString();
                user.Password   = "";
                user.IsDisable  = r["disabled"] is System.DBNull ? false : (bool)r["disabled"];
                user.IsActive   = r["actived"] is System.DBNull ? false : (bool)r["actived"];
                user.Email      = r["bind_email"].ToString();
                user.Mobile     = r["bind_mobile"].ToString();
                user.GroupId    = r["group_id"].ToString();
                ret.Add(user);
            }
            return(ret);
        }
예제 #2
0
        public bool deletePermission(string roleId, string objectType, string objectId)
        {
            string sql = SecurityDataScripts.DeleteRolePermissionSQL(roleId, objectType, objectId);

            SecuritySettings.ExecuteNonQuery(sql);
            return(true);
        }
예제 #3
0
        public bool existsRole(string roleId)
        {
            string sql     = SecurityDataScripts.CheckRoleExistsSQL(roleId);
            object roleObj = SecuritySettings.ExecuteScalar(sql);

            return(!(roleObj == null));
        }
예제 #4
0
        public static bool savePermissions(RolePermisssions rolePermissions)
        {
            List <PermissionObject> permissions = rolePermissions.PermissionObjList;
            string roleId = rolePermissions.RoleId;
            bool   ret    = false;

            for (int i = 0; i < permissions.Count; i++)
            {
                PermissionObject po  = permissions[i];
                string           sql = SecurityDataScripts.SavePermissionSql(roleId, po.ObjectType, po.ObjectId, po.Permission);
                SecuritySettings.ExecuteNonQuery(sql);
            }
            ret = true;
            return(ret);
        }
예제 #5
0
        public static List <Role> getUserRoles(string userId)
        {
            string      sql = SecurityDataScripts.GetUserRoleListSQL(userId);
            DataTable   tb  = SecuritySettings.Execute(sql);
            List <Role> ret = new List <Role>();

            foreach (DataRow r in tb.Rows)
            {
                Role role = new Role();
                role.Id          = r["role_id"].ToString();
                role.DisplayName = r["display_name"].ToString();
                role.Remark      = r["remark"].ToString();
                ret.Add(role);
            }
            return(ret);
        }