获得同一天记录,mysql有问题 返回
C#论坛
老数据
1
2464
悬赏:5 飞吻

var orderMoney = Db.Queryable<ErpSaleOrder>() .WhereIF(!string.IsNullOrEmpty(parm.guid), m => m.ShopGuid == parm.guid) .WhereIF(!string.IsNullOrEmpty(searchParm.btime) && !string.IsNullOrEmpty(searchParm.btime), m => SqlFunc.Between(m.AddDate, Convert.ToDateTime(searchParm.btime), Convert.ToDateTime(searchParm.etime))) .WhereIF(parm.types == 1, m => SqlFunc.DateIsSame(m.AddDate, DateTime.Now)) .WhereIF(parm.types == 2, m => SqlFunc.Between(m.AddDate, d1, d2)) //.Sum(m=>m.RealMoney); .ToSql();
热忱回答(1)
-
程序 VIP0
2018/7/18直接用日期大于小于呢
0 回复