SqlFunc.MappingColumn用法出BUG了 返回
枫叶的祝福 发布于2025/9/29
var dealerDtoList = await db
.Queryable<Customer>()
.LeftJoin<User>((a, b) => a.UserGuid == b.Guid,)
.Where(expable.ToExpression())
.GroupBy((a, b) => new
{
a.Guid,
userName = b.Name,
b.AddTime,
})
.Select((a, b) => new
{
customerGuid = a.Guid,
userName = b.Name,
dealerBasicInfoAddTime = c.AddTime,
daysWithoutOrder = SqlFunc.MappingColumn<bool>(" max(b.AuditTime) is not null ") ?
SqlFunc.DateDiff(DateType.Day, SqlFunc.AggregateMax(Convert.ToDateTime(b.AuditTime)), DateTime.Now) :
SqlFunc.MappingColumn<int>("99999")
})
.MergeTable()
.OrderByIF(dealerSign == 1, it => it.dealerBasicInfoAddTime, OrderByType.Desc)
.OrderByIF(dealerSign == 2, it => it.daysWithoutOrder, OrderByType.Desc)
.ToPageListAsync(pageIndex, pageSize, allCount);

红色代码为报错的部分,我测试了许多版本,最后一个能用的版本是5.1.4.189,超过这个版本,都会报错
热忱回答(2)
-
fate sta VIP0
2025/9/29处理中
0 回复 -
fate sta VIP0
2025/9/30SqlSugarCore 5.1.4.206-preview04
更新预览版本,已修复
0 回复