public ActionResult Index() { ExploreModel em = new ExploreModel(); em.recommendation = new QAModel(); em.monthlyHot = new QAModel(); em.dailyHot = new QAModel(); List<Question> q = db.Questions.ToList(); em.monthlyHot.question = new List<Question>(); em.dailyHot.question = new List<Question>(); DateTime present = DateTime.Now; DateTime preMonth = DateTime.Now.AddDays(-30); for (int i = q.Count()-1; i > 0; i--) { if (q[i].QTime.ToOADate() > preMonth.ToOADate()) { em.monthlyHot.question.Add(q[i]); if (q[i].QTime.ToOADate() > present.Date.ToOADate()) { em.dailyHot.question.Add(q[i]); } } else { break; } } em.monthlyHot.question = em.monthlyHot.question.OrderByDescending(a => a.QAnswerNum).ToList(); em.dailyHot.question = em.dailyHot.question.OrderByDescending(a => a.QAnswerNum).ToList(); em.monthlyHot.answer = new List<Answer>(); em.monthlyHot.user = new List<User>(); for (int i = 0; i < em.monthlyHot.question.Count() && i < 20; i++) { em.monthlyHot.answer.Add(model.getHotAnswerByQuestionID(em.monthlyHot.question[i].QID)); em.monthlyHot.user.Add(db.Users.Find(em.monthlyHot.answer[i].AUserID)); } em.dailyHot.answer = new List<Answer>(); em.dailyHot.user = new List<User>(); for (int i = 0; i < em.dailyHot.question.Count() && i < 20; i++) { em.dailyHot.answer.Add(model.getHotAnswerByQuestionID(em.dailyHot.question[i].QID)); em.dailyHot.user.Add(db.Users.Find(em.dailyHot.answer[i].AUserID)); } em.recommendation.question = new List<Question>(); em.recommendation.answer = new List<Answer>(); em.recommendation.user = new List<User>(); em.recommendation.question = db.Questions.Where(a => a.QAnswerNum > 0).OrderByDescending(a => a.QAnswerNum).ToList(); for (int i = 0; i < em.recommendation.question.Count() && i < 1; i++) { em.recommendation.answer.Add(model.getHotAnswerByQuestionID(em.recommendation.question[i].QID)); em.recommendation.user.Add(db.Users.Find(em.recommendation.answer[i].AUserID)); } return View(em); }
public ActionResult Index() { ExploreModel em = new ExploreModel(); em.recommendation = new QAModel(); em.monthlyHot = new QAModel(); em.dailyHot = new QAModel(); List <Question> q = db.Questions.ToList(); em.monthlyHot.question = new List <Question>(); em.dailyHot.question = new List <Question>(); DateTime present = DateTime.Now; DateTime preMonth = DateTime.Now.AddDays(-30); for (int i = q.Count() - 1; i > 0; i--) { if (q[i].QTime.ToOADate() > preMonth.ToOADate()) { em.monthlyHot.question.Add(q[i]); if (q[i].QTime.ToOADate() > present.Date.ToOADate()) { em.dailyHot.question.Add(q[i]); } } else { break; } } em.monthlyHot.question = em.monthlyHot.question.OrderByDescending(a => a.QAnswerNum).ToList(); em.dailyHot.question = em.dailyHot.question.OrderByDescending(a => a.QAnswerNum).ToList(); em.monthlyHot.answer = new List <Answer>(); em.monthlyHot.user = new List <User>(); for (int i = 0; i < em.monthlyHot.question.Count() && i < 20; i++) { em.monthlyHot.answer.Add(model.getHotAnswerByQuestionID(em.monthlyHot.question[i].QID)); em.monthlyHot.user.Add(db.Users.Find(em.monthlyHot.answer[i].AUserID)); } em.dailyHot.answer = new List <Answer>(); em.dailyHot.user = new List <User>(); for (int i = 0; i < em.dailyHot.question.Count() && i < 20; i++) { em.dailyHot.answer.Add(model.getHotAnswerByQuestionID(em.dailyHot.question[i].QID)); em.dailyHot.user.Add(db.Users.Find(em.dailyHot.answer[i].AUserID)); } em.recommendation.question = new List <Question>(); em.recommendation.answer = new List <Answer>(); em.recommendation.user = new List <User>(); em.recommendation.question = db.Questions.Where(a => a.QAnswerNum > 0).OrderByDescending(a => a.QAnswerNum).ToList(); for (int i = 0; i < em.recommendation.question.Count() && i < 1; i++) { em.recommendation.answer.Add(model.getHotAnswerByQuestionID(em.recommendation.question[i].QID)); em.recommendation.user.Add(db.Users.Find(em.recommendation.answer[i].AUserID)); } return(View(em)); }