1.VIEW 页面显示代码
<link href="~/Content/bootstrap.css" rel="stylesheet" /><div class="well"><table class="table"><tr><th>用户名</th><th>地址</th><th>订单编号</th><th>城市代号</th><th>时间</th><th>订单状态</th></tr>@foreach (var item in ViewBag.dyObject){<tr><td>@item.UserName </td><td>@item.LocalAddress </td><td>@item.BargainOrderCode </td><td>@item.CityCode </td><td>@item.UpdateTime </td><td>@item.OrderStatus </td></tr>}</table></div>
2、Controller 控制器
public ActionResult UserOrder(){#region EF+linq 多表联查VIEW显示列表
var userOrdeList = (from user in _DbContext.UserInfo_tests
join order in _DbContext.TRA_BargainOrders on user.Id
equals order.UserID
select new
{
uname = user.UserName,
uaddress = user.LocalAddress,
bargainOrderCode = order.BargainOrderCode,
cityCode = order.CityCode,
updateTime = order.UpdateTime,
orderStatus = order.OrderStatus
}
).ToList();
List<dynamic> userList = new List<dynamic>();
foreach (var data in userOrdeList.ToList())
{
dynamic dyObject = new ExpandoObject();
dyObject.UserName = data.uname;
dyObject.LocalAddress = data.uaddress;
dyObject.BargainOrderCode = data.bargainOrderCode;
dyObject.CityCode = data.cityCode;
dyObject.UpdateTime = data.updateTime;
dyObject.OrderStatus = data.orderStatus;
userList.Add(dyObject);
}
ViewBag.dyObject = userList;
return View();
#endregion}
3、实体model 和数据库操作在此省略
