使用达梦数据的问题 返回
matt 发布于2025/10/15
使用达梦数据库
db.Storageable(datas)
.WhereColumns(u => new { u.SensorID })
.ExecuteCommand();
当SensorID 不为主键时，更新语句里也会自带主键，sql语句如下
UPDATE "Communication_Data_Sensor_CurrentAlarm" SET "RtTime"=to_timestamp('2025-10-15 17:44:49.264160', 'YYYY-MM-DD HH24:MI:SS.FF') ,"RtValue"='144' ,"RtState"='353' ,"UpdateTime"=to_timestamp('2025-10-15 17:44:50.180999', 'YYYY-MM-DD HH24:MI:SS.FF') ,"UpdateUserId"='1300000000001' ,"UpdateUserName"='1300000000001' ,"IsDelete"=0 WHERE "SensorID"='1970379155765858305' AND"Id"='730547355992133' ;
sqlsugarCore:5.1.4.160
sqlsugarCore.DM:8.8.2
热忱回答（5）
-
fate sta VIP0
1个月前升级最新sqlsugar试试
0 回复 -
fate sta VIP0
1个月前
不升级的话可以 新建一个新实体。主键设置为SensorID
0 回复 -
matt VIP0
1个月前
@fate sta：更新成最新版本确实可以了，感谢
0 回复 -
matt VIP0
1个月前
@fate sta：
有新的问题，我现在生成了10条插入语句，我在dm管理界面里能正常插入且响应速度很快，但是我使用sqlsugar提示超时以下为更新语句
UPDATE "Communication_Data_Sensor_CurrentAlarm" SET "RtTime"=to_timestamp('2025-10-16 16:07:49.496759', 'YYYY-MM-DD HH24:MI:SS.FF') ,"RtValue"='144.5' ,"RtState"='353' ,"UpdateTime"=to_timestamp('2025-10-16 16:07:50.380144', 'YYYY-MM-DD HH24:MI:SS.FF') ,"UpdateUserId"='1300000000001' ,"UpdateUserName"='1300000000001' ,"IsDelete"=0 WHERE "SensorID"='1970379155765858305' ;
UPDATE "Communication_Data_Sensor_CurrentAlarm" SET "RtTime"=to_timestamp('2025-10-16 16:07:49.496767', 'YYYY-MM-DD HH24:MI:SS.FF') ,"RtValue"='22.95' ,"RtState"='353' ,"UpdateTime"=to_timestamp('2025-10-16 16:07:50.380502', 'YYYY-MM-DD HH24:MI:SS.FF') ,"UpdateUserId"='1300000000001' ,"UpdateUserName"='1300000000001' ,"IsDelete"=0 WHERE "SensorID"='1977996050857857025' ;
UPDATE "Communication_Data_Sensor_CurrentAlarm" SET "RtTime"=to_timestamp('2025-10-16 16:07:49.496777', 'YYYY-MM-DD HH24:MI:SS.FF') ,"RtValue"='0' ,"RtState"='354' ,"UpdateTime"=to_timestamp('2025-10-16 16:07:50.380595', 'YYYY-MM-DD HH24:MI:SS.FF') ,"UpdateUserId"='1300000000001' ,"UpdateUserName"='1300000000001' ,"IsDelete"=0 WHERE "SensorID"='1977996062295724033' ;
UPDATE "Communication_Data_Sensor_CurrentAlarm" SET "RtTime"=to_timestamp('2025-10-16 16:07:49.496789', 'YYYY-MM-DD HH24:MI:SS.FF') ,"RtValue"='0' ,"RtState"='354' ,"UpdateTime"=to_timestamp('2025-10-16 16:07:50.380690', 'YYYY-MM-DD HH24:MI:SS.FF') ,"UpdateUserId"='1300000000001' ,"UpdateUserName"='1300000000001' ,"IsDelete"=0 WHERE "SensorID"='1977996077311332353' ;
UPDATE "Communication_Data_Sensor_CurrentAlarm" SET "RtTime"=to_timestamp('2025-10-16 16:07:49.496792', 'YYYY-MM-DD HH24:MI:SS.FF') ,"RtValue"='108.38' ,"RtState"='353' ,"UpdateTime"=to_timestamp('2025-10-16 16:07:50.380782', 'YYYY-MM-DD HH24:MI:SS.FF') ,"UpdateUserId"='1300000000001' ,"UpdateUserName"='1300000000001' ,"IsDelete"=0 WHERE "SensorID"='1977996090678579201' ;
UPDATE "Communication_Data_Sensor_CurrentAlarm" SET "RtTime"=to_timestamp('2025-10-16 16:07:49.496800', 'YYYY-MM-DD HH24:MI:SS.FF') ,"RtValue"='108.38' ,"RtState"='353' ,"UpdateTime"=to_timestamp('2025-10-16 16:07:50.380871', 'YYYY-MM-DD HH24:MI:SS.FF') ,"UpdateUserId"='1300000000001' ,"UpdateUserName"='1300000000001' ,"IsDelete"=0 WHERE "SensorID"='1977996103651561473' ;
UPDATE "Communication_Data_Sensor_CurrentAlarm" SET "RtTime"=to_timestamp('2025-10-16 16:07:49.496808', 'YYYY-MM-DD HH24:MI:SS.FF') ,"RtValue"='144.5' ,"RtState"='353' ,"UpdateTime"=to_timestamp('2025-10-16 16:07:50.380964', 'YYYY-MM-DD HH24:MI:SS.FF') ,"UpdateUserId"='1300000000001' ,"UpdateUserName"='1300000000001' ,"IsDelete"=0 WHERE "SensorID"='1977996123780026369' ;
UPDATE "Communication_Data_Sensor_CurrentAlarm" SET "RtTime"=to_timestamp('2025-10-16 16:07:49.496818', 'YYYY-MM-DD HH24:MI:SS.FF') ,"RtValue"='72.25' ,"RtState"='353' ,"UpdateTime"=to_timestamp('2025-10-16 16:07:50.381048', 'YYYY-MM-DD HH24:MI:SS.FF') ,"UpdateUserId"='1300000000001' ,"UpdateUserName"='1300000000001' ,"IsDelete"=0 WHERE "SensorID"='1977996140267835393' ;
UPDATE "Communication_Data_Sensor_CurrentAlarm" SET "RtTime"=to_timestamp('2025-10-16 16:07:49.496839', 'YYYY-MM-DD HH24:MI:SS.FF') ,"RtValue"='9.03' ,"RtState"='361' ,"UpdateTime"=to_timestamp('2025-10-16 16:07:50.381142', 'YYYY-MM-DD HH24:MI:SS.FF') ,"UpdateUserId"='1300000000001' ,"UpdateUserName"='1300000000001' ,"IsDelete"=0 WHERE "SensorID"='1977996172970823681' ;
UPDATE "Communication_Data_Sensor_CurrentAlarm" SET "RtTime"=to_timestamp('2025-10-16 16:07:49.496849', 'YYYY-MM-DD HH24:MI:SS.FF') ,"RtValue"='0.43' ,"RtState"='353' ,"UpdateTime"=to_timestamp('2025-10-16 16:07:50.381228', 'YYYY-MM-DD HH24:MI:SS.FF') ,"UpdateUserId"='1300000000001' ,"UpdateUserName"='1300000000001' ,"IsDelete"=0 WHERE "SensorID"='1977996188246478849' ;
以下为报错信息
信息： SqlSugar.SqlSugarException: 请求执行超时
信息： Dm.DmException: 请求执行超时
sqlsugarCore : 5.1.4.206-pre17
sqlsugarCore.DM:8.8.2
0 回复 -
fate sta VIP0
1个月前0 回复