//找到某个问题及其所有回答等信息
public QuestionModel findQuestionInfoByQID(int id)
{
QuestionModel qm = new QuestionModel();
qm.question = db.Questions.Find(id);
qm.answers = db.Answers.Where(a => a.AQuestionID == id).ToList();
qm.users = new List<User>();
qm.CA = new List<CtoA>();
for (int i = 0; i < qm.answers.Count(); i++)
{
qm.CA.Add(new CtoA());
Answer aid = qm.answers.ToList()[i];
qm.CA[i].aID = aid.AID;
qm.CA[i].comments = db.Comments.Where(d => d.CAnswerID == aid.AID);//问题的所有评论
qm.CA[i].users = new List<User>();
for (int j = 0; j < qm.CA[i].comments.Count(); j++)//找到每个评论的作者信息
{
int uid = qm.CA[i].comments.ToList()[j].CUserID;
User temp = db.Users.FirstOrDefault(d => d.UID == uid);
qm.CA[i].users.Add(temp);
}
qm.users.Add(db.Users.First(d => d.UID == aid.AUserID));//找到答案的作者
}
return qm;
}
