ISugarQueryable 延迟查询 返回
ISugarQueryable<ZtGpsalarm> result = dbOracle.ZtGpsalarms.AsQueryable().Where(x => x.Lastchangetime >= dt && x.Beendeleted == 0 && x.Beendo == false);
int cs = result.Where(x => x.Alarmstrategyname == "超速报警").Count();
int yx = result.Where(x => x.Alarmstrategyname == "不按规定路线行驶报警").Count();
SELECT COUNT(1) FROM (SELECT "ID","BEENDELETED","LASTCHANGETIME","CARCODE","ADDRESS","CARTYPENAME","ALARMBEGINTIME","ALARMENDTIME","ALARMSTRATEGYID","ALARMSTRATEGYNAME","POSITIONSPEED","BEENDO" FROM "ZT_GPSALARM" WHERE ((( "LASTCHANGETIME" >= :Const0 ) AND ( "BEENDELETED" = :Const1 )) AND ( "BEENDO" = :Beendo2 )) AND ( "ALARMSTRATEGYNAME" = :Alarmstrategyname3 )) CountTable
{":Const0":"2019-03-01T00:00:00",":Const1":0,":Beendo2":false,":Alarmstrategyname3":"超速报警"}
SELECT COUNT(1) FROM (SELECT "ID","BEENDELETED","LASTCHANGETIME","CARCODE","ADDRESS","CARTYPENAME","ALARMBEGINTIME","ALARMENDTIME","ALARMSTRATEGYID","ALARMSTRATEGYNAME","POSITIONSPEED","BEENDO" FROM "ZT_GPSALARM" WHERE ((( "LASTCHANGETIME" >= :Const0 ) AND ( "BEENDELETED" = :Const1 )) AND ( "BEENDO" = :Beendo2 )) AND ( "ALARMSTRATEGYNAME" = :Alarmstrategyname3 ) AND ( "ALARMSTRATEGYNAME" = :Alarmstrategyname4 )) CountTable
{":Const0":"2019-03-01T00:00:00",":Const1":0,":Beendo2":false,":Alarmstrategyname3":"超速报警",":Alarmstrategyname4":"不按规定路线行驶报警"}
我第一个查询完了,第二次查询的时候带了第一次的条件,请问这个怎么处理啊,我在EF中试了,每次都是一个新的sql语句,不会带上次的条件
热忱回答(2)
-
fate stay night VIP0
2019/3/25.clone()复制
0 回复 -
没有谁离不开谁 VIP0
2019/3/25@fate stay night:可以了
0 回复