8,497
社区成员
发帖
与我相关
我的任务
分享
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();
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()