In查询不能跟表达式吗 返回
SqlSugar
老数据
1
1413
HuHuHu 发布于2020/7/2
悬赏：5 飞吻
必须要先查出来数据再放到In里面吗，不能只查询一遍吗
var Auditor = Db.Queryable<OrderApproval, User>((oa, u) => oa.UserId == u.UserId).Where((oa, u) => u.Name.Contains(workOrderSearchModel.Auditor)).GroupBy((oa, u) => oa.UserId).Select((oa, u) => oa.UserId).ToList();
query.In(it => it.UserId, Auditor);
热忱回答（1）
-
HuHuHu VIP0
2020/7/2
解决了，可以这么用
it =>SqlFunc.Subqueryable<OrderApproval>().Where(oa => it.OrderId == oa.OrderId && SqlFunc.Subqueryable<User>().Where(u => oa.UserId == u.UserId && u.Name.Contains(workOrderSearchModel.KeyWords)).Any()).Any()
0 回复