пока писал сообщение получил еще.
про навигационные свойства: у меня не получается, делаю так
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
public partial class ViewRequest
{
public int Id { get; set; }
public int RequestId { get; set; }
public System.DateTime Registered { get; set; }
public string Author { get; set; }
public string Phone { get; set; }
public int UnitId { get; set; }
public int EquipmentId { get; set; }
public string Description { get; set; }
public int StateId { get; set; }
public int PerformerId { get; set; }
public string Comment { get; set; }
public DateTime? Closed { get; set; }
public int Creator { get; set; }
public DateTime Created { get; set; }
public virtual StateRequest StateRequest { get; set;}
}
тогда код в контроллере такой:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
public ViewResult Index()
{
var Requests = db.Requests;
var RequestsHistory = db.RequestsHistory;
var requests = from r in Requests
join rh in RequestsHistory on r.Id equals rh.RequestId orderby r.Id
select new ViewRequest
{
Id = r.Id,
RequestId = r.Id,
Registered = r.Registered,
Author = r.Author,
Phone = r.Phone,
UnitId = r.UnitId,
EquipmentId = r.EquipmentId,
Description = r.Description,
StateId = rh.StateId,
PerformerId = rh.PerformerId,
Comment = rh.Comment,
Closed = r.Closed,
Creator = rh.Creator,
Created = rh.Created
};
requests.Include(r=>r.StateRequest
return View();
}
в представлении делаю так:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
<table>
<tr>
<th>RequestId</th>
<th>Registered</th>
<th>Author</th>
<th>Phone</th>
<th>UnitId</th>
<th>EquipmentId</th>
<th>Description</th>
<th>StateId</th>
<th>PerformerId</th>
<th>Comment</th>
<th>Closed</th>
<th>Creator</th>
<th>Created</th>
<th></th>
</tr>
@foreach (var item in Model) {
<tr>
<td>@Html.DisplayFor(modelItem => item.RequestId)</td>
<td>@Html.DisplayFor(modelItem => item.Registered)</td>
<td>@Html.DisplayFor(modelItem => item.Author)</td>
<td>@Html.DisplayFor(modelItem => item.Phone)</td>
<td>@Html.DisplayFor(modelItem => item.UnitId)</td>
<td>@Html.DisplayFor(modelItem => item.EquipmentId)</td>
<td>@Html.DisplayFor(modelItem => item.Description)</td>
<td>@Html.DisplayFor(modelItem => item.StateRequest.State)</td>
<td>@Html.DisplayFor(modelItem => item.PerformerId)</td>
<td>@Html.DisplayFor(modelItem => item.Comment)</td>
<td>@Html.DisplayFor(modelItem => item.Closed)</td>
<td>@Html.DisplayFor(modelItem => item.Creator)</td>
<td>@Html.DisplayFor(modelItem => item.Created)</td>
<td>
@Html.ActionLink("EditNew", "EditNew", new { id=item.Id }) |
@Html.ActionLink("DetailsNew", "DetailsNew", new { id=item.Id }) |
@Html.ActionLink("Delete", "Delete", new { id=item.Id })
</td>
</tr>
}
</table>
по факту в представлении вместо значения состояния имею пустую строку?глупый вопрос в StateRequest необходимо навигационное свойство на модель ViewRequest?
а по поводу joinа я немного слукавил полный код котролера выглядит так:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
public ViewResult Index()
{
var Requests = db.Requests;
var SubQuery = from rh in db.RequestsHistory
group rh by rh.RequestId into grp
select grp.Max(g => g.Id);
var RequestsHistory = from rh in db.RequestsHistory where SubQuery.Contains(rh.Id) select rh;
var requests = from r in Requests
join rh in RequestsHistory on r.Id equals rh.RequestId orderby r.Id
select new ViewRequest
{
Id = r.Id,
RequestId = r.Id,
Registered = r.Registered,
Author = r.Author,
Phone = r.Phone,
UnitId = r.UnitId,
EquipmentId = r.EquipmentId,
Description = r.Description,
StateId = rh.StateId,
PerformerId = rh.PerformerId,
Comment = rh.Comment,
Closed = r.Closed,
Creator = rh.Creator,
Created = rh.Created
};
return View(requests);
}
мне пользователю необходимо отображать последнее состояние из HistoryRequest как сделать иначе не знаю, сделал как смог
