ef搜索
-一个大坑 2017-04-25 03:08:47 string appNo = Request["appNo"].Trim();--取值
var rideInfo = (from p in db.BD_CARANDDRIVER
join a in db.BD_CAR
on p.CARNO equals a.CARNO
where 1 ==1
select new { a.BRAND, a.CARCOLOR,a.CARTYPE, p.CARNO, p.DRIVERNAME, p.ENDDT, p.LICENSENO, p.STARTDT);--两表联合查询
if (appNo != string.Empty)
{
rideInfo = (from p in db.BD_CARANDDRIVER
join a in db.BD_CAR
on p.CARNO equals a.CARNO
where 1 == 1 &&a.CARNO==appNo--根据查询appNo查询
select new { a.BRAND, a.CARCOLOR, a.CARTYPE, p.CARNO, p.DRIVERNAME, p.ENDDT, p.LICENSENO, p.STARTDT);
}