public ActionResult getAllPhotoByPage(string albumID, string userID, int pageNum, int pageSize)
{
DateTime dateTime = DateTime.Now;
int getAllPhotoFlag = 0;
IQueryable <Photo> photos = null;
try {
photos = (from c in entity.Photo
where c.AlbumId == int.Parse(albumID)
select c).OrderBy(c => c.PhotoUploadTime).Skip((pageNum - 1) * pageSize).Take(pageSize); //最新的在前面;
AlbumVisit albumVisit = new AlbumVisit();
albumVisit.AlbumId = int.Parse(albumID);
albumVisit.UserId = int.Parse(userID);
albumVisit.AlbumVisitTime = dateTime;
entity.AlbumVisit.Add(albumVisit);
entity.SaveChanges(); //更新访问记录
getAllPhotoFlag = 1;
} catch (Exception e) {
Console.WriteLine(e.Message);
getAllPhotoFlag = 0;
}
var returnJson = new {
photos = JsonConvert.SerializeObject(photos),
getAllPhotoFlag = getAllPhotoFlag,
};
return(Json(returnJson));
}
public ActionResult deleteAlbumHistoryByID(string albumID, string userID)
{
int deleteAlbumHistoryFlag = 0;
try {
AlbumVisit albumVisit = entity.AlbumVisit.Single(c => c.AlbumId == int.Parse(albumID) && c.UserId == int.Parse(userID));
entity.AlbumVisit.Remove(albumVisit);
entity.SaveChanges();
deleteAlbumHistoryFlag = 1;
} catch (Exception e) {
Console.WriteLine(e.Message);
deleteAlbumHistoryFlag = 0;
}
return(Json(new { deleteAlbumHistoryFlag = deleteAlbumHistoryFlag }));
}
public ActionResult createAlbumHistoryByID(string albumID, string userID)
{
AlbumVisit albumVisit = new AlbumVisit();
DateTime dateTime = DateTime.Now;
int createAlbumHistoryFlag = 0;
albumVisit.AlbumId = int.Parse(albumID);
albumVisit.UserId = int.Parse(userID);
albumVisit.AlbumVisitTime = dateTime;
try {
entity.AlbumVisit.Add(albumVisit);
entity.SaveChanges();
createAlbumHistoryFlag = 1;
} catch (Exception e) {
createAlbumHistoryFlag = 0;
}
return(Json(new { createAlbumHistoryFlag = createAlbumHistoryFlag }));
}
