ConditionalModel 中ConditionalType.IsNot sql 拼的有误 返回
Miracle 发布于2026/2/10
var conModels = new List<IConditionalModel>();
conModels.Add(new ConditionalModel { FieldName = "Project_Id", ConditionalType = ConditionalType.Equal, FieldValue = "02434316-FAF7-4DE1-97D9-0144A40D49EF" });
conModels.Add(new ConditionalModel { FieldName = "Project_Id", ConditionalType = ConditionalType.IsNot, FieldValue = "02434316-FAF7-4DE1-97D9-0144A40D49EF" });
var lst= db.Queryable<Pro_Base>().Where(conModels).ToList();
错误sql:SELECT [Project_Id] FROM [Pro_Base] WHERE [Project_Id] = @ConditProject_Id0 ( AND [Project_Id] <> @ConditProject_Id1 OR [Project_Id] is null )
括号 和and的位置有误
热忱回答（8）
-
fate sta VIP0
2026/2/11是最新版本吗
0 回复 -
fate sta VIP0
2026/2/11
[Project_Id] = @ConditProject_Id0 哪来的。
0 回复 -
Miracle VIP0
2026/2/12
@fate sta：最新版5.1.4.213-preview05
var conModels = new List<IConditionalModel>();
conModels.Add(new ConditionalModel { FieldName = "Project_Id", ConditionalType = ConditionalType.Equal, FieldValue = "02434316-FAF7-4DE1-97D9-0144A40D49EF" });
conModels.Add(new ConditionalModel { FieldName = "Project_Id", ConditionalType = ConditionalType.IsNot, FieldValue = "02434316-FAF7-4DE1-97D9-0144A40D49EF" });
就是上面的conModel 生成的
0 回复 -
Miracle VIP0
2026/2/12
@fate sta： ConditionalType.IsNot 和其他任何一个条件一起用，就会有问题，您可以随便写个试一下
0 回复 -
fate sta VIP0
2026/2/13
我看一下。
0 回复 -
Miracle VIP0
2026/2/25
@fate sta：老大，怎么样了
0 回复 -
fate sta VIP0
2026/2/26
SqlSugarCore5.1.4.215-preview01
已修复
0 回复 -
Miracle VIP0
2026/2/27
@fate sta：可以了谢谢
0 回复