日期:2014-05-20 浏览次数:21084 次
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; }