public ActionResult UserIndex(int User_Id) { Users users = db.Users.Find(User_Id); var index = new Guitar.ViewModel.UsersViewModel { Us = users, }; return(View(index)); }
//public UsersBll usersBll = new UsersBll(); // GET: Users public ActionResult Index(int?id, int nid = 1, int pageIndex = 1, int page = 1) { //var userid = 2; //if (id == null) //{ // id = Convert.ToInt32(Session["Users_id"].ToString()); //} var user = db.Users.Find(id); var mscore = from m in db.MusicScore join n in db.Users on m.User_id equals n.User_id select new MusicUserViewModel { Ms_id = m.Ms_id, Ms_title = m.Ms_title, Ms_addtime = m.Ms_addtime, Ms_label = m.Ms_label, Ms_img = m.Ms_img, User_id = n.User_id, User_name = n.User_name, }; var mscore1 = from m in mscore.Where(p => p.User_id == id).OrderByDescending(p => p.Ms_addtime) select m; var mscount = mscore1.Count(); ViewBag.mscount = mscount; var video = from m in db.Video join n in db.Users on m.User_id equals n.User_id select new VideoUserViewModel { Vi_id = m.Vi_id, Vi_title = m.Vi_title, Vi_addtime = m.Vi_addtime, Vi_label = m.Vi_label, Vi_img = m.Vi_img, User_id = n.User_id, User_name = n.User_name, }; var video1 = from m in video.Where(p => p.User_id == id).OrderByDescending(p => p.Vi_addtime) select m; var vicount = video1.Count(); ViewBag.vicount = vicount; var post = from m in db.Post join n in db.Users on m.User_id equals n.User_id select new PostUserViewModel { Po_id = m.Po_id, Po_title = m.Po_title, Po_addtime = m.Po_addtime, Po_label = m.Po_label, Po_img = m.Po_img, User_id = n.User_id, User_name = n.User_name, }; var post1 = from m in post.Where(p => p.User_id == id).OrderByDescending(p => p.Po_addtime) select m; var pocount = post1.Count(); ViewBag.pocount = pocount; const int pageSize = 6; if (Request.IsAjaxRequest()) { var target = Request.QueryString["target"]; if (target == "articles") { return(PartialView("_AjaxArticles1", mscore1.ToPagedList(nid, pageSize))); } if (target == "articles2") { return(PartialView("_AjaxArticles2", video1.ToPagedList(pageIndex, pageSize))); } return(PartialView("_AjaxArticles3", post1.ToPagedList(page, pageSize))); } var index = new Guitar.ViewModel.UsersViewModel() { Us = user, MS = mscore1.ToPagedList(nid, pageSize), VO = video1.ToPagedList(pageIndex, pageSize), PO = post1.ToPagedList(page, pageSize), }; return(View(index)); }