public ActionResult Index(int id = 1, int pageIndex = 1, int page = 1)
{
//var str1 = "古典吉他";
var users = (from m in db.Users.OrderByDescending(p => p.User_addtime) select m).Take(6);
var score1 = (from m in db.MusicScore.Where(p => p.Ms_label == "古典吉他").OrderByDescending(p => p.Ms_addtime) select m).Take(10);
var score2 = (from m in db.MusicScore.Where(p => p.Ms_label == "民谣吉他").OrderByDescending(p => p.Ms_addtime) select m).Take(10);
var score3 = (from m in db.MusicScore.Where(p => p.Ms_label == "电吉他").OrderByDescending(p => p.Ms_addtime) select m).Take(10);
var score4 = (from m in db.MusicScore.Where(p => p.Ms_label == "尤克里里").OrderByDescending(p => p.Ms_addtime) select m).Take(10);
var score5 = (from m in db.MusicScore.Where(p => p.Ms_label == "其他").OrderByDescending(p => p.Ms_addtime) select m).Take(10);
var score6 = (from m in db.MusicScore.OrderByDescending(p => p.ReadCount) select m);
const int pageSize = 20;
if (Request.IsAjaxRequest())
{
var target = Request.QueryString["target"];
if (target == "mscore")
{
return(PartialView("_Index1", score6.ToPagedList(id, pageSize)));
}
}
var index = new Guitar.ViewModel.MusicDetailsViewModel()
{
MScore1 = score1,
MScore2 = score2,
MScore3 = score3,
MScore4 = score4,
MScore5 = score5,
MScore6 = score6.ToPagedList(page, pageSize),
Us2 = users,
};
return(View(index));
}
public ActionResult Display(int?id, int md = 1, int pageIndex = 1, int page = 1)
{
//const int pageSize = 5;
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TempData["Ms_idd"] = id;
ViewBag.Msid = id;
TempData["Ms_id2"] = id;
MusicScore ms = db.MusicScore.Find(id);
//MusicScoreStatistics msta = db.MusicScoreStatistics.Find(id);
var usid = (from m in db.MusicScore.Where(p => p.Ms_id == id) select m.User_id).FirstOrDefault();
Users us = db.Users.Find(usid);
//MusicScoreStatistics msta = db.MusicScoreStatistics.Find(id);
if (ms == null && us == null)
{
return(HttpNotFound());
}
//var us=from m in db.Users.Where(p=>p.User_id==usid) select m;
var ms1 = (from m in db.MusicScore.Where(p => p.User_id == usid).OrderByDescending(p => p.Ms_addtime) select m).Take(5);
var msc = from m in db.MusicScoreComment.Where(p => p.Ms_id == id).OrderByDescending(p => p.Addtime) select m;
var comment = from m in db.MusicScoreComment
join n in db.Users on m.User_id equals n.User_id
select new MusicScoreCommentViewModel
{
Ms_commentid = m.Ms_commentid,
Ms_id = m.Ms_id,
content = m.content,
Addtime = m.Addtime,
User_id = n.User_id,
User_name = n.User_name,
User_img = n.User_img,
};
//var comment1 = .ToPagedList(idd, pageSize);
var msr = (from n in db.MusicScoreReply
join m in msc on n.Ms_commentid equals m.Ms_commentid
join q in db.Users on n.User_id equals q.User_id
select new MusicCommentReplyViewModel
{
Ms_replyid = n.Ms_replyid,
Ms_commentid = m.Ms_commentid,
content = n.content,
Addtime = n.Addtime,
Ms_id = m.Ms_id,
User_id = n.User_id,
User_name = q.User_name,
User_img = q.User_img
});
int commentid = Convert.ToInt32(Request["Commentid1"]);
var msrr = from m in db.MusicScoreReply.Where(p => p.Ms_commentid == commentid).OrderByDescending(p => p.Addtime) select m;
var comment1 = from m in comment.Where(p => p.Ms_id == id).OrderByDescending(p => p.Addtime) select m;
//var msta = from m in db.MusicScoreStatistics.Where(p => p.Ms_id == id) select m;
//var msta = from m in db.MusicScoreStatistics where m.Ms_id == id select m;
//分页数据
const int pageSize = 5;
if (Request.IsAjaxRequest())
{
var target = Request.QueryString["target"];
if (target == "articles")
{
return(PartialView("_display1", comment1.ToPagedList(md, pageSize)));
}
}
var index = new Guitar.ViewModel.MusicDetailsViewModel()
{
Us = us,
MScore = ms,
MScore1 = ms1,
MSC = msc,
MSR = msr,
Msr = msrr,
msc11 = comment1.ToPagedList(page, pageSize),
};
//if (Request.IsAjaxRequest())
// return PartialView("_PartialPage1", comment.OrderByDescending(a => a.Addtime).ToPagedList(md, 3));
return(View(index));
}