asp.net-mvc – 使用viewModels通过MVC中的User ID在MVC中使用IE

我在MVC中创建一个应用程序,我在其中显示表中的行列表.我最初让它显示所有项目,但现在我想要做的是显示某些项目,其中用户的ID等于表中用户的ID.

我有这样的显示：

在我的控制器中：

Public Function IssueHistory(sortOrderProject As String,command As String,issueTable As IssueTable) As ActionResult
    Dim issues As IQueryable(Of IssueTable) = dbServer.IssueTables
    Return View(issues)
End Function

我也按字母顺序排序,如下所示：

If sortOrderProject Is Nothing Then
     sortOrderProject = "AlphUp"
End If

Select Case sortOrderProject
    Case "AlphDown"
        ViewBag.AlphOrderIssue = "AlphUp"
        issues = issues.OrderByDescending(Function(i) i.IssueKey)
    Exit Select
    Case "AlphUp"
        ViewBag.AlphOrderIssue = "AlphDown"
        issues = issues.OrderBy(Function(i) i.IssueKey)
    Exit Select
    Case Else
        ViewBag.AlphOrderIssue = "AlphUp"
        issues = issues.OrderBy(Function(i) i.IssueKey)
    Exit Select
End Select

在我看来：

@ModelType IEnumerable(Of IssueTable)
@Html.DisplayFor(Function(modelItem) item.IssueStatus)
@Html.DisplayFor(Function(modelItem) item.IssueStatus)

但是如何使用viewModel过滤我的应用程序,以便为IssueTable中的每个用户ID.这是我到目前为止所得到的：

Public Function IssueHistory(sortOrderProject As String,issueTable As IssueTracker.ClientUserProjectIssue) As ActionResult
    Dim issues As IQueryable(Of IssueTracker.ClientUserProjectIssue) = dbServer.IssueTables
    'Dim issues As IEnumerable(Of IssueTracker.ClientUserProjectIssue) = dbServer.IssueTables
    Return View(issues)
End Function

在我看来：

@ModelType IEnumerable(Of IssueTracker.ClientUserProjectIssue)
@Html.DisplayFor(Function(modelItem) item.IssueTable.IssueStatus)
@Html.DisplayFor(Function(modelItem) item.IssueTable.IssueStatus)

我的ViewModel看起来像这样：

Public Class ClientUserProjectIssue
    Public Property uTable As UserTable
    Public Property IssueTable As IssueTable
End Class

我试图像这样实现它但是没有成功

视图模型：

Public Property iEnumarableIssue As IEnumerable(Of IssueTable)

控制器：

Dim ViewModel As IEnumerable(Of IssueTable) = dbServer.IssueTables
'ViewModel.iEnumarableIssue  = dbServer.IssueTable.Where(Function(x) x.UserID= id).ToList()

但是当我尝试这样做时,我得到了很多空值.使用viewModel过滤每个UserID的行的正确方法是什么,它等于IssueTable中的UserID？

我可以使用IQueryable或IEnumerable,如果这是正确的方法,并且代码可以在c#中解释.

public ActionResult IssueHistory(string sortOrderProject,int userId)
{
    var issues = dbServer.IssueTables.AsQueryable();
    //...
    issues = issues.Where(i => i.UserId == userId);
    //...
    issues = issues.OrderBy(i => i.IssueKey);
    //...
    return View(issues.ToList());
}