sqlsugar自动分表查询时分表时间为>=和<=
[Sql]:SELECT * FROM ( ( SELECT `Id`,`DeviceId`,`ItemId`,`ItemName`,`RealTimeValue`,`CreateTime`,`ItemFlag`,`StandardValue` FROM `datarealtime_20250801` WHERE (( `DeviceId` = @DeviceId0UnionAll1 ) AND ( `ItemId` = @ItemId1UnionAll1 )) AND `CreateTime`>=@spBeginTimeUnionAll1 AND `CreateTime`<= @spEndTimeUnionAll1 ) ) unionTable
[Pars]:
[Name]:@DeviceId0UnionAll1 [Value]:38 [Type]:Int32
[Name]:@ItemId1UnionAll1 [Value]:86 [Type]:Int32
[Name]:@spBeginTimeUnionAll1 [Value]:2025/8/30 8:35:00 [Type]:DateTime
[Name]:@spEndTimeUnionAll1 [Value]:2025/8/30 8:40:00 [Type]:DateTime

浙公网安备 33010602011771号