日期:2014-05-20 浏览次数:21010 次
var pb = from d in pr.Purchases join b in br.Books
on d.bookID equals b.bookID
where d.pUserID == userID && d.sta != "2"
orderby d.pTime descending
select new PurchaseBook {
pID = d.pID,
bookID = d.bookID,
bookName = d.bookName,
pUserID = d.pUserID,
pUserName = d.pUserName,
sta = d.sta,
pTime = d.pTime,
ZT = d.ZT,
sUserID = d.sUserID,
sUserName = d.sUserName,
price = d.price,
number = d.number,
author = b.author,
pub=b.pub
};