ASP.NET MVC 4 Controller + View ( Razor ) + Inner Join + LINQ 方法
Controller |
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; namespace WebApplication1.Controllers { public class HomeController : Controller { StockEntities entity; … … public ActionResult Stock() { entity = new StockEntities(); … … var dataModel = (from transaction in entity.Stock_Transaction join stock in entity.Stock_Info on (int)transaction.Stock_ID equals (int)stock.Stock_ID select new Transaction { Transaction_ID = transaction.Transaction_ID, User_ID = transaction.User_ID, Stock_ID = transaction.Stock_ID, Stock_Name = stock.Stock_Name, Stock_Category = stock.Stock_Category }).ToList(); return View(dataModel); } … … public class Transaction { public int Transaction_ID { get; set; } public String User_ID { get; set; } public int Stock_ID { get; set; } public String Stock_Name { get; set; } public int? Stock_Category { get; set; } } } } |
View |
<table class="transaction_tbl" cellpadding="10" cellspacing="0"> @foreach (var transaction in Model) { <tr> <td> <span class="transaction_cell">@transaction.Transaction_ID</span> </td> <td> <span class="transaction_cell">@transaction.User_ID</span> </td> <td> <span class="transaction_cell">@transaction.Stock_ID</span> </td> <td> <span class="transaction_cell">@transaction.Stock_Name</span> </td> <td> <span class="transaction_cell">@transaction.Stock_Category</span> </td> </tr> } </table> |