public ActionResult CameraPhotoList(Guid PhotoID, int pageid = 1, DateTime? dt1 = null, DateTime? dt2 = null, bool sort = true) { try { List<CameraPhoto> cp = new List<CameraPhoto>(); if (dt1 != null && dt2 != null && dt1 <= dt2) { int UserId = WebSecurity.GetUserId(User.Identity.Name); PhotoWall photoWall = PhotoWallRepository.GetByKey(PhotoID); dt2 = DateTime.Parse(dt2.ToString()).AddDays(1); var list = CameraPhotoRepository.FindAll(Specification<CameraPhoto>.Eval(o => o.PhotoID == photoWall.PhotoID && o.AddTime > dt1 && o.AddTime < dt2)).ToList(); if (sort) { list.OrderBy(s => s.IsCheck); } else { list.OrderByDescending(s => s.IsCheck); } foreach (var item in list) { var cc = CameraLogRepository.FindAll(Specification<CameraLog>.Eval(o => o.CameraID == item.CameraID)).ToList(); CameraPhoto mm = new CameraPhoto(); mm.LoveNum = cc.Count(); mm.Remark = item.Remark; mm.PhotoID = item.PhotoID; mm.Name = item.Name; mm.AddTime = item.AddTime; mm.ID = item.ID; mm.IsCheck = item.IsCheck; cp.Add(mm); } var Pagerlist = CameraPhotoRepository.GetListByPages(cp, pageid, 10); return View(Pagerlist); } else { int UserId = WebSecurity.GetUserId(User.Identity.Name); PhotoWall p = PhotoWallRepository.GetByKey(PhotoID); var list = CameraPhotoRepository.FindAll(Specification<CameraPhoto>.Eval(o => o.PhotoID == p.PhotoID)).OrderBy(s => s.IsCheck).ToList(); if (sort) { list.OrderBy(s => s.IsCheck); } else { list.OrderByDescending(s => s.IsCheck); } foreach (var item in list) { var cc = CameraLogRepository.FindAll(Specification<CameraLog>.Eval(o => o.CameraID == item.CameraID)).ToList(); CameraPhoto mm = new CameraPhoto(); mm.LoveNum = cc.Count(); mm.Remark = item.Remark; mm.PhotoID = item.PhotoID; mm.Name = item.Name; mm.AddTime = item.AddTime; mm.ID = item.ID; mm.IsCheck = item.IsCheck; cp.Add(mm); } var Pagerlist = CameraPhotoRepository.GetListByPages(cp, pageid, 10); return View(Pagerlist); } } catch (Exception) { return Redirect("/CameraHouse/CameraIndex"); } }
/// <summary> /// 插入到数据库 /// </summary>string uname, /// <param name="datas"></param> /// <returns></returns> public JsonResult UploadCamera(string Remark, string PhotoID) { try { if (Session["newname"] != null) { Guid ss = new Guid(PhotoID); var pp = PhotoWallRepository.GetByKey(ss); CameraPhoto form = new CameraPhoto(); int userID = WebSecurity.GetUserId(User.Identity.Name); form.AddTime = DateTime.Now; form.IpAddress = Request.UserHostAddress; form.State = 1; form.LoveNum = 0; form.Name = Session["newname"].ToString(); form.YName = Session["inewname"].ToString(); form.Remark = Remark; form.PhotoID = pp.PhotoID; CameraPhotoRepository.Add(form); CameraPhotoRepository.Context.Commit(); return Json(new { status = "ok" }, JsonRequestBehavior.AllowGet); } } catch (Exception) { } return Json(new { status = "error" }, JsonRequestBehavior.AllowGet); }