linq 时间问题
[code=C#]
var info = from gi in db.GoodInfos
Join od in db.OrderDetailses on gi.GoodID equals od.GoodID into odJoin
from a in odJoin.DefaultIfEmpty()
where DateTime.Now.CompareTo(gi.InstoreTime) > 180
select new
{
gi.ReceiveTime,
gi.GoodID,
gi.GoodName,
gi.Location,
gi.BarCode,
gi.InstoreTime,
gi.GoodState,
a.IsOutScan
};
info = info.Where(id => id.GoodState == 32 && id.IsOutScan == 0);
info = info.OrderBy(id => id.GoodID);
var resaultDate = info.Skip((PageIndex - 1) * RowsCount).Take(RowsCount).ToList();