还是达梦数据库问题 返回

SqlSugar 处理完成
1 195
该叫什么 matt 发布于1个月前
悬赏:0 飞吻

使用达梦数据库时,当我使用分页查询语句时,类似下方截图

image.png


sql语句会转成如下格式


SELECT * FROM (SELECT *,ROW_NUMBER() OVER(ORDER BY Id Desc) AS RowIndex  FROM  (SELECT "MonitorID","DateTime","MaxValue","MaxTime","MinValue","MinTime","MeanValue","StaticsState","StartTime","EndTime","TenantId","CreateTime","UpdateTime","CreateUserId","CreateUserName","UpdateUserId","UpdateUserName","IsDelete","Id" FROM "Statistics_Min_Drift_20251013"  WHERE ( "TenantId" = :TenantId0UnionAll1 )  AND  ("MonitorID" IN (1977996393784152064))   AND (( "StartTime" >= '2025-10-15 09:00:00' ) AND ( "StartTime" < '2025-10-15 09:30:00' ))  AND  "DateTime">=:spBeginTimeUnionAll1 AND "DateTime"<= :spEndTimeUnionAll1 ) unionTable  ) T WHERE RowIndex BETWEEN 1 AND 20


此处的Id,会被达梦默认转成大写ID,导致与数据库中不匹配,报如下错误

image.png



image.png





sqlsugarCore:5.1.4.160
sqlsugarCore.DM:8.8.2



热忱回答1

  • matt matt VIP0
    1个月前

    可以关闭了,我的问题,是admin.net框架下的OrderBuilder方法里加个达梦数据库判断加“”即可

    0 回复