DAL层的代码 public List<object> BackTable() { List<object> data = null; BookEntities context = new BookEntities(); data=(from p in context.TB_BOOKINFOMATION join q in context.TB_ALLBOOKSTYPE on p.TYPEID equals q.TYPEID select new {p.BOOKID,p.BOOKNAME,q.BOOKTYPES,p.BOOKAUTHOR,p.BOOKPUBLISH, p.BOOKISBN, p.BOOKCOUNT,p.BOOKPRICE,p.BORROWCOST,p.INPUTER, p.INPUTTIME,p.UPDATER,p.UPDATETIME}).ToList<object>(); return data; }
BLL public List<object> ListBook() { DalBookInfo dalbookinfo = new DalBookInfo(); return dalbookinfo.BackTable(); }
操作一张表的时候,是不是通过gettable取值的?
public List<object> BackTable()
{
List<object> data = null;
BookEntities context = new BookEntities();
data=(from p in context.TB_BOOKINFOMATION
join q in context.TB_ALLBOOKSTYPE on p.TYPEID equals q.TYPEID
select new {p.BOOKID,p.BOOKNAME,q.BOOKTYPES,p.BOOKAUTHOR,p.BOOKPUBLISH,
p.BOOKISBN, p.BOOKCOUNT,p.BOOKPRICE,p.BORROWCOST,p.INPUTER,
p.INPUTTIME,p.UPDATER,p.UPDATETIME}).ToList<object>();
return data;
}
public List<object> ListBook()
{
DalBookInfo dalbookinfo = new DalBookInfo();
return dalbookinfo.BackTable();
}