Question

我不知道如何做到这一点。我想用一个表格式显示数据。这些数据将来自使用3-4表格和选择不同领域显示的圆环。不知道如何回去,因为一度出现匿名错误。

var info = from s in context.LennoxSurveyResponses
                       join customers in context.Customers on s.SurveyCode equals customers.SurveyCode
                       join lists in context.CustomerLists on customers.ListId equals lists.ListId
                       join dealer in context.Channels on lists.ChannelId equals dealer.ChannelId
                       where dealer.ChannelId == id
                       select new
                       {
                           ResponseId = s.ResponseId,
                           CustomerFirstName = customers.FirstName,
                           CustomerLastName = customers.LastName,
                           CustomerTestimonial = s.Question5Answer
                       };

我的模式必须宣布什么,才能通过?

Answer 1

这一观点符合观点模式,因此首先界定:

public class CustomerViewModel
{
    public int ResponseId { get; set; }
    public string CustomerFirstName { get; set; }
    public string CustomerLastName { get; set; }
    public string CustomerTestimonial { get; set; }
}

之后:

public ActionResult Foo(string id)
{
    var info = 
        from s in context.LennoxSurveyResponses
        join customers in context.Customers on s.SurveyCode equals customers.SurveyCode
        join lists in context.CustomerLists on customers.ListId equals lists.ListId
        join dealer in context.Channels on lists.ChannelId equals dealer.ChannelId
        where dealer.ChannelId == id
        select new CustomerViewModel
        {
            ResponseId = s.ResponseId,
            CustomerFirstName = customers.FirstName,
            CustomerLastName = customers.LastName,
            CustomerTestimonial = s.Question5Answer
        };
    return View(info);
}

并且最后,你的意见被严格分类如下:

@model IEnumerable<CustomerViewModel>

现在,您可以~~loop~~使用一个显示模板,该模型向用户提供信息:

@Html.DisplayForModel()

以及相应的显示模板(~/Views/Home/DisplayTemplates/CustomerViewModel.cshtml):

@model CustomerViewModel
<div>
    <span>First name: @Html.DisplayFor(x => x.CustomerFirstName)</span>
    <span>Last name: @Html.DisplayFor(x => x.CustomerLastName)</span>
    ...      
</div>

友情链接