关于group by 去重问题,返回一个model后。在View里面怎么获取数据。尝试很多种方法,但是不行,在线等,解决立即给分谢谢
#region 在每个投票候选项里面加载每个投票的详细情况public ActionResult ShowVoteDetail(int VoteId)
{
RelayChinaClubEntities db = new RelayChinaClubEntities();
var memberVotes = db.MemberVotes.Where(mv => mv.VoteId == VoteId);
var candidates = from mv in memberVotes
group mv by mv.VoteCandidateId into gcp
let vote = gcp.FirstOrDefault()
select new VoteCandidateResultVM
{
CandidateId = vote.VoteCandidateId != null ? vote.VoteCandidateId.Value : 0,
Title = vote.VoteCandidate != null ? vote.VoteCandidate.Title : string.Empty,
FaceImage=vote.VoteCandidate.FaceImage,
Count = gcp.Count()
};
var dataModel = db.Votes.Find(VoteId);
var model = new VoteResultVM
{
VoteTitle = dataModel.Title,
VoteId = VoteId,
Total = memberVotes.Count(),
VoteCandidateResults = candidates.ToList()
};
return PartialView(model);
}
public class VoteResultVM//显示结果在view
{
public int VoteId { get; set; }
public string VoteTitle { get; set; }
public int Total { get; set; }
public List<VoteCandidateResultVM> VoteCandidateResults { get; set; }
}
public class VoteCandidateResultVM
{
public int CandidateId { get; set; }
public string Title { get; set; }
public int Count { get; set; }
public string FaceImage { get; set; }
}
#endregion
在View里面:
C# --------------------编程问答-------------------- View顶部获取数据应该有错,哪位大神帮帮看看出了什么问题 --------------------编程问答-------------------- 没帮忙啊。加分20.在线等啊
补充:.NET技术 , ASP.NET