Skip to content

我使用sql拼接权限时,发现表别民失效 #1424

@walt-liuzw

Description

@walt-liuzw

1.我的代码逻辑先去判断行数据权限生成sql片段:
(t.user_id = 102 )

2.然后我去拼接sql
var query = Repo.AsQueryable() .WhereIF(!string.IsNullOrEmpty(dto.Name), (t) => t.Name == dto.Name) .Where(dto.Params.DataScopeSql);

其中dto.Params.DataScopeSql = (t.user_id = 102 )
var result = query.Select((t) => new PasswordEntryDto{xxxxx});
string generatedSql = query.ToSqlString();
此时生成generatedSql =
SELECT xxxx FROM t_password_entries WHERE (t.user_id = 102 )

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions