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);
}
