ASP.NET MVC 4 Controller + View ( Razor ) + Inner Join + LINQ 方法

 
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>