8,497
社区成员
发帖
与我相关
我的任务
分享
public IEnumerable Necro_overdueQuery()
{
TombDataContext db = new TombDataContext();
var query = from d in db.d_necro
join re in db.ReBook
on d.ano equals re.Fano into temp
from temp1 in temp.DefaultIfEmpty()
//where DateTime.Now.AddYears(-20) > d.buryday &&
//DateTime.Now.AddYears(-20) > re.bookDate
select new
{
d.ano,d.fno,d.goname,d.goaddr,
temp1.bookId,
temp1.bookDate,
reremark = temp1.remark
};
return query;
}