asp.net-mvc - MVC C#选择位置

我正在尝试通过ID为以下内容添加过滤器：

public ActionResult Index()
{
    var model = from o in new MainDBContext().OffLinePayments
                select new EditOffLinePayment
                {
                    ID = o.ID,
                    Amount = o.Amount
                };
    return View(model);
}

我想做的是以下几点：

public ActionResult Index(long? id)
{
    if (id != null)
    {
        var model = from o in new MainDBContext().OffLinePayments
                    **Where Assigned_ID == id**
                    select new EditOffLinePayment
                    {
                        ID = o.ID,
                        Amount = o.Amount
                    };
        return View(model);
    }
    else
    {
        var model = from o in new MainDBContext().OffLinePayments
                    select new EditOffLinePayment
                    {
                        ID = o.ID,
                        Amount = o.Amount
                    };
        return View(model);
    }
}

最佳答案

尝试

var model = from o in new MainDBContext().OffLinePayments
                   where o.Assigned_ID == id
                    select new EditOffLinePayment
                    {
                         ID = o.ID,
                        Amount = o.Amount
                    };