| | |
| | | stringBuilder.Append(" select sm.* from sys_menu sm "); |
| | | stringBuilder.Append(" left join ( "); |
| | | stringBuilder.Append(" select distinct * from ( "); |
| | | stringBuilder.Append(" select * from sys_role_menu where role_id = " + list[0] + " "); |
| | | stringBuilder.Append(" select * from sys_role_menu where role_id ='" + list[0] + "' "); |
| | | |
| | | for (int i = 1; i < list.Count; i++) |
| | | { |
| | | stringBuilder.Append(" union (select * from sys_role_menu where role_id = " + list[i] + ") "); |
| | | stringBuilder.Append(" union (select * from sys_role_menu where role_id = '" + list[i] + "') "); |
| | | |
| | | } |
| | | stringBuilder.Append(" ) bb "); |
| | |
| | | e.Salt = oracleReaderWrapper.GetString("SALT", ""); |
| | | e.UserName = oracleReaderWrapper.GetString("USER_NAME", ""); |
| | | e.UserType = oracleReaderWrapper.GetString("USER_TYPE", ""); |
| | | e.RoleNames = oracleReaderWrapper.GetString("ROLE_NAMES", ""); |
| | | e.ExpireTime = oracleReaderWrapper.GetDateTime("EXPIRE_TIME"); |
| | | e.CreateTime = oracleReaderWrapper.GetDateTime("CREATE_TIME"); |
| | | e.Remark = oracleReaderWrapper.GetString("REMARK", ""); |