ISugarQueryable 延迟查询 返回

SqlSugar 老数据
2 4594


   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