如何在以前的MySQL操作中获取受影响的行？(How to get affected rows in previous MySQL operation?)

 有很多方法可以做到这一点并使其成为通用的，但它们大多数都有一个ViewModel。 您专门为支持仪表板视图而创建的类： 
 
public class DashboardViewModel {   
  public IEnumerable<GMC.Models.Clubs> Clubs {get;set;}
  public IEnumerable<GMC.Models.MemberUsers> MemberUsers {get;set;}
  public IEnumerable<GMC.Models.Alerts> Alerts {get;set;}
}
 
 如果这些只是数据库中的不同表，则应通过相同的上下文访问它们，因为上下文管理您的连接和其他资源。 但是，如果没有看到那些代码，我就不会继续这样做。 
 
[AllowAnonymous]
    public ActionResult Dashboard()
    {
        //populate data into our view model(vm)
        var vm = new DashboardViewModel{
           Clubs = db.Clubs.ToList(),
           MemberUsers = db.MemberUsers.ToList(),
           Alerts = db.Alerts.ToList()
        };
        return View(vm);
    }
 
 仪表板视图： 
 
    @model DashboardViewModel

    <div class="dashboard_alerts">    
      @Html.Partial("DashboardAlerts", Model.Alerts)
   </div>

    <div class="dashboard_pending_clubs">    
       @Html.Partial("DashboardClubs", Model.Clubs)
    </div>

    <div class="dashboard_verified_members">    
       @Html.Partial("DashboardMembers", Model.MemberUsers)
     </div>
 
 就个人而言，我不使用Html.Partial而是使用Action / RenderAction，因为这些将允许您实际调用另一个返回PartialViewResult的操作，因此每个操作都负责检索自己的数据。 我不总是这样做，但如果它是合适的，那么动作/局部视图更可重复使用。 
 
 这看起来更像是这样的： 
 
    public ActionResult Dashboard()
    {
        return View();
    }

    public PartialViewResult Clubs()
    {
       ....
        return PartialView(db.Clubs.ToList());//this assumes the partial view is named Clubs.cshtml, otherwise you'll need to use the overload where you pass the view name
    }

    public PartialViewResult Alerts()
    {
       ....
        return PartialView(db.Alerts.ToList());
    }
 
 ... 
 
 Dashboard.cshtml 
 
    <div class="dashboard_alerts">    
      @Html.Action("Alerts")
   </div>

    <div class="dashboard_pending_clubs">    
       @Html.Action("Clubs")
    </div>

    <div class="dashboard_verified_members">    
       @Html.Action("Members")
     </div>

Lots of ways you could do this and make it generic, but they will mostly all have a ViewModel. A class you create specifically to support your Dashboard view:
 
public class DashboardViewModel {   
  public IEnumerable<GMC.Models.Clubs> Clubs {get;set;}
  public IEnumerable<GMC.Models.MemberUsers> MemberUsers {get;set;}
  public IEnumerable<GMC.Models.Alerts> Alerts {get;set;}
}
 
If these are just different tables in a database, they should all be accessed through the same context, because the context manages your connection and other resources. However, without seeing that code I will not go on that tangent.
 
[AllowAnonymous]
    public ActionResult Dashboard()
    {
        //populate data into our view model(vm)
        var vm = new DashboardViewModel{
           Clubs = db.Clubs.ToList(),
           MemberUsers = db.MemberUsers.ToList(),
           Alerts = db.Alerts.ToList()
        };
        return View(vm);
    }
 
Dashboard view:
 
    @model DashboardViewModel

    <div class="dashboard_alerts">    
      @Html.Partial("DashboardAlerts", Model.Alerts)
   </div>

    <div class="dashboard_pending_clubs">    
       @Html.Partial("DashboardClubs", Model.Clubs)
    </div>

    <div class="dashboard_verified_members">    
       @Html.Partial("DashboardMembers", Model.MemberUsers)
     </div>
 
Personally, instead of using Html.Partial I would use Action/RenderAction, as these will allow you to actually call another action that returns a PartialViewResult, and thus each action is responsible for retrieving its own data. I don't always do it this way, but if it is appropriate, then the action/partial view is more reusable that way.
 
This would look more like this:
 
    public ActionResult Dashboard()
    {
        return View();
    }

    public PartialViewResult Clubs()
    {
       ....
        return PartialView(db.Clubs.ToList());//this assumes the partial view is named Clubs.cshtml, otherwise you'll need to use the overload where you pass the view name
    }

    public PartialViewResult Alerts()
    {
       ....
        return PartialView(db.Alerts.ToList());
    }
 
...
 
Dashboard.cshtml
 
    <div class="dashboard_alerts">    
      @Html.Action("Alerts")
   </div>

    <div class="dashboard_pending_clubs">    
       @Html.Action("Clubs")
    </div>

    <div class="dashboard_verified_members">    
       @Html.Action("Members")
     </div>