double todayWebsite = dal.GetWhere(i => i.PayTime >= beginTime && i.PayTime <= endTime && (i.OrderFrom == 1 || i.OrderFrom == 0 || i.OrderFrom == null)).Sum(i => i.TotalMoney);
(PayTime这个是支付时间;OrderFrom是订单来源;)
麻烦你们帮我把这句转成SQL语句
自己写的,但是不行,麻烦你们帮我改一下:SELECT SUM(TotalMoney) FROM dbo.[Order] WHERE PayTime BETWEEN '2015-05-12 00:00:01' AND '2015-05-12 23:59:59' AND OrderFrom=0 OR OrderFrom=1 OR OrderFrom=NULL
谢谢
------解决思路----------------------
SELECT SUM(TotalMoney) FROM dbo.[Order] WHERE PayTime BETWEEN '2015-05-12 00:00:01' AND '2015-05-12 23:59:59' AND (OrderFrom in (0,1) OR OrderFrom is NULL)