/// <summary> /// 获取字段权限 /// </summary> /// <param name="view"></param> /// <returns></returns> public static string GetFieldPrivilege(string view) { string sql = @"select PrivilegeMaster,PrivilegeMasterKey,PrivilegeAccess,PrivilegeAccessKey,PrivilegeOperation from CF_Privilege"; sql += " where PrivilegeAccess like '{0}.%'".FormatWith(view); return(JSONHelper.ExecuteCommandToJSON(sql)); }
/// <summary> /// 获取全部用户账户列表 /// </summary> /// <returns></returns> public static string GetUserListJSON() { var sql = "select UserID,LoginName,[Title] from CF_User"; sql += " where UserID <> {0}".FormatWith(AdminUserID); sql += " and UserID not in (select UserID from CF_UserRole where RoleID = {0}) ".FormatWith(AdminRoleID); return(JSONHelper.ExecuteCommandToJSON(sql)); }
/// <summary> /// 获取全部角色列表 /// </summary> /// <returns></returns> public static string GetRoleListJSON() { var sql = "select RoleID,RoleName from CF_Role where RoleID <> {0} ".FormatWith(AdminRoleID); return(JSONHelper.ExecuteCommandToJSON(sql)); }