消息回答按父消息分组

本文关键字:消息 | 更新日期: 2023-09-27 18:18:19

我需要按消息答案分组,像这样:

  • 消息id = 1
  • 消息应答id = 2/父消息id = 1
  • 消息应答id = 3/父消息id = 1
  • 留言应答id = 4/家长留言id = 1

  • 消息id = 5

  • 消息应答id = 6/父消息id = 5
  • 消息应答id = 7/父消息id = 5
  • 消息应答id = 8/父消息id = 5

消息模型:

public class Message
{
    // Primary properties
    public int Id { get; set; }
    public string NameFrom { get; set; }
    public string EmailFrom { get; set; }
    public string TelephoneFrom { get; set; }
    public string NameTo { get; set; }
    public string EmailTo { get; set; }
    public string TelephoneTo { get; set; }
    public string Title { get; set; }
    public string MessageText { get; set; }
    public bool? Approved { get; set; }
    public DateTime DateCreated { get; set; }
    public DateTime? DateRead { get; set; }
    // Navigation properties
    public Member MemberFrom { get; set; }
    public Member MemberTo { get; set; }
    public MessageType MessageType { get; set; }
    public Message MessageParent { get; set; }
    public Ad Ad { get; set; }
    public Ask Ask { get; set; }
}

在视图中显示:

@foreach (var item in Model)
{
    <div class="message_link_container" id="linkmessage_@item.Id">
        <ul class="estr_message" id="estrmessage_@item.Id">
            <li id="email_@item.Id">
                <p>@if(item.MessageParent_Id == 0){ if(string.IsNullOrEmpty(item.NameFrom)) { @item.EmailFrom } else { @item.NameFrom } }</p>
            </li>
            <li id="title_@item.Id">
                <p>@item.Title</p>
            </li>
            <li id="date_@item.Id">
                <p>@item.DateCreated</p>
            </li>
        </ul>
    </div>
}

消息回答按父消息分组

var model=Messages
             .OrderBy(o=>o.MessageParent_Id==0?Id:o.MessageParent_Id)
             .ThenBy(o=>o.Id);