void ReleaseDesignerOutlets()
{
if (TotalCoins != null)
{
TotalCoins.Dispose();
TotalCoins = null;
}
if (AmountToConsume != null)
{
AmountToConsume.Dispose();
AmountToConsume = null;
}
if (ConsumeButton != null)
{
ConsumeButton.Dispose();
ConsumeButton = null;
}
if (SpecialView != null)
{
SpecialView.Dispose();
SpecialView = null;
}
if (ViewTouched != null)
{
ViewTouched.Dispose();
ViewTouched = null;
}
}
public SpecialView GetUserAlbumsViews1()
{
int UserId = 42;
int albumId = 144;
var sv = new SpecialView()
{
SpecialVideoList = new List <SpecialDetailView>(), SpecialCount = 0
};
var userSpecial = from dt in
(from urc in _userSpecialRepository.GetEntityList(CondtionEqualCreateUserId(UserId))
join uss in this._userSpecialSonRepository.GetEntityList() on urc.Id equals uss.MySpecialId into ussList
from usst1 in ussList.DefaultIfEmpty()
join video in _videoRepository.GetEntityList().Where(o => o.VideoState == 3).OrderByDescending(o => o.CreateTime) on
usst1 == null ? 0 : usst1.VideoId equals video.Id into videoList
from videot in videoList.DefaultIfEmpty()
orderby urc.CreateTime
select new
{
Id = urc.Id,
Title = urc.Title,
Image = urc.Image,
CreateTime = urc.CreateTime,
VideoId = videot == null ? 0 : videot.Id,
PlayCount = videot == null ? 0 : videot.PlayCount,
CommentCount = videot == null ? 0 : videot.CommentCount,
SmallPicture = videot == null ? "" : videot.SmallPicturePath
})
group dt by dt.Id into list
select new SpecialDetailView
{
Id = list.Key,
Title = list.First().Title,
CreateTime = list.First().CreateTime.ToString("yyyy-MM-dd HH:mm"),
Thumbnail = !string.IsNullOrEmpty(list.First().Image) ? list.First().Image : list.First().SmallPicture,
PlayCount = list.Sum(o => o.PlayCount),
CommentCount = list.Sum(o => o.CommentCount)
};
sv.SpecialCount = userSpecial.Count();
sv.PageCount = GetPageCountToDataCount(sv.SpecialCount);
sv.SpecialVideoList = userSpecial.Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList();
return(sv);
}
/// <summary>
/// 获取用户创建的专辑，过滤已添加到空间专辑
/// </summary>
/// <param name="userId"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="escapeStatestate"></param>
/// <returns></returns>
public SpecialView GetUserAlbumsViews(int userId, int pageIndex, int pageSize)
{
var sv = new SpecialView()
{
SpecialVideoList = new List <SpecialDetailView>(), SpecialCount = 0
};
var userSpecial = (from urc in _userSpecialRepository.GetEntityList(CondtionEqualCreateUserId(userId))
where !(from userroomchoose in this._userRoomChooseRepository.GetEntityList(CondtionEqualUserId(userId))
where
userroomchoose.TypeId == 1
select new
{
userroomchoose.ModuleId
}).Contains(new { ModuleId = urc.Id })
select urc
).AsQueryable();
List <UserSpecial> list = userSpecial.ToList <UserSpecial>();
List <SpecialDetailView> sdvList = new List <SpecialDetailView>();
SpecialDetailView sdv = null;
List <SpecialVideoView> svvList = new List <SpecialVideoView>();
SpecialVideoView svv = null;
List <Video> videoList = null;
foreach (UserSpecial item in list)
{
sdv = new SpecialDetailView();
sdv.Id = item.Id;
sdv.Title = item.Title;
var vidoes = (from ussl in this._userSpecialSonRepository.GetEntityList(CondtionEqualSpecialId(item.Id))
join video in this._videoRepository.GetEntityList(CondtionEqualState()) on(long) ussl.VideoId equals video.Id
where video.VideoState == 3 //TODO update 刘强2015-11-06 过滤审核状态
select video
).AsQueryable();
videoList = vidoes.ToList <Video>();
foreach (Video v in videoList)
{
svv = new SpecialVideoView();
svv.Id = v.Id;
svv.SmallPicturePath = v.SmallPicturePath;
svv.Title = v.Title;
svv.PlayCount = v.PlayCount;
svv.CommentCount = v.CommentCount;
svv.TimeLength = ConvertUtil.ToInt(v.TimeLength, 0);
svvList.Add(svv);
}
sdv.SpecialVideoList = svvList;
sdvList.Add(sdv);
}
sv.SpecialVideoList = sdvList;
if (list.Count <= 0)
{
return(sv);
}
sv.SpecialCount = list.Count;
sv.PageCount = sv.SpecialCount % pageSize == 0 ? sv.SpecialCount / pageSize : sv.SpecialCount / pageSize + 1;
sv.SpecialVideoList = sv.SpecialVideoList.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
return(sv);
}
/// <summary>
/// 默认排序查询个人空间-专辑推荐视图
/// </summary>
/// <param name="userId">用户id</param>
/// <param name="dataNum">专辑数</param>
/// <param name="videoNum">视频数</param>
/// <returns></returns>
public SpecialView GetUserRoomSpecialData(int userId, int dataNum, int videoNum = 0)
{
CheckIdNotNull(userId);
SpecialView sv = new SpecialView();
var userSpecial = (from urc in GetUserRoomChooseList(userId)
join special in this._userSpecialRepository.GetEntityList(CondtionEqualState()) on urc.ModuleId equals special.Id
where urc.TypeId == 1
orderby urc.SortNum, urc.CreateTime
select special
).AsQueryable().Take(dataNum);
List <UserSpecial> list = userSpecial.ToList <UserSpecial>();
List <SpecialDetailView> sdvList = new List <SpecialDetailView>();
SpecialDetailView sdv = null;
List <SpecialVideoView> svvList = null;
SpecialVideoView svv = null;
List <Video> videoList = null;
foreach (UserSpecial item in list)
{
sdv = new SpecialDetailView();
sdv.Id = item.Id;
sdv.Title = item.Title;
var vidoes = (from ussl in GetUserSpecialSonList(item.Id)
join video in this._videoRepository.GetEntityList(CondtionEqualState()).Where(p => p.VideoState == 3) on(long) ussl.VideoId equals video.Id
select video
).OrderByDescending(p => p.UpdateTime ?? p.CreateTime).AsQueryable();
if (videoNum > 0)
{
vidoes = vidoes.Take(videoNum);
}
videoList = vidoes.ToList <Video>();
svvList = new List <SpecialVideoView>();
foreach (Video v in videoList)
{
svv = new SpecialVideoView();
svv.Id = v.Id;
svv.SmallPicturePath = v.SmallPicturePath;
svv.Title = v.Title;
svv.PlayCount = v.PlayCount;
svv.CommentCount = v.CommentCount;
svv.TimeLength = ConvertUtil.ToInt(v.TimeLength);
svvList.Add(svv);
}
sdv.SpecialVideoList = svvList;
sdvList.Add(sdv);
}
sv.SpecialCount = list.Count;
sv.SpecialVideoList = sdvList;
return(sv);
}
public SpecialView GetUserAlbumsViews()
{
int UserId = 42;
int albumId = 144;
var sv = new SpecialView()
{
SpecialVideoList = new List <SpecialDetailView>(), SpecialCount = 0
};
var userSpecial = (from urc in _userSpecialRepository.GetEntityList(CondtionEqualCreateUserId(UserId))
orderby urc.CreateTime descending
select urc
).AsQueryable();
List <UserSpecial> list = userSpecial.ToList <UserSpecial>();
List <SpecialDetailView> sdvList = new List <SpecialDetailView>();
SpecialDetailView sdv = null;
List <SpecialVideoView> svvList = null;
SpecialVideoView svv = null;
List <Video> videoList = null;
string thumbnail = "";
foreach (UserSpecial item in list)
{
sdv = new SpecialDetailView();
sdv.Id = item.Id;
sdv.Title = item.Title;
sdv.CreateTime = item.CreateTime.ToString("yyyy-MM-dd HH:mm");
thumbnail = item.Image;
var vidoes = (from ussl in this._userSpecialSonRepository.GetEntityList(CondtionEqualSpecialId(item.Id))
join video in this._videoRepository.GetEntityList(CondtionEqualState()) on(long) ussl.VideoId equals video.Id
where video.VideoState == 3 //todo 刘强2015-11-06添加审核通过的过滤条件
orderby ussl.CreateTime
select video
).AsQueryable();
videoList = vidoes.ToList <Video>();
sdv.VideoCount = videoList.Count;//专辑下视频总数
if (videoList != null && videoList.Count > 0 && string.IsNullOrEmpty(thumbnail))
{
thumbnail = videoList[videoList.Count - 1].SmallPicturePath;
}
//如果专辑图片和视频都没有,则赋值默认图片
//if (string.IsNullOrEmpty(thumbnail))
//thumbnail = ServerHelper.RootPath + "/Content/images/per_acc_v02.png";
sdv.Thumbnail = thumbnail;//赋值专辑缩略图
svvList = new List <SpecialVideoView>();
int playCount = 0;//获取专辑下视频播放总数
foreach (Video v in videoList)
{
svv = new SpecialVideoView();
svv.Id = v.Id;
svv.SmallPicturePath = v.SmallPicturePath;
svv.Title = v.Title;
svv.PlayCount = v.PlayCount;
svv.CommentCount += v.CommentCount;
svv.TimeLength = ConvertUtil.ToInt(v.TimeLength, 0);
svvList.Add(svv);
playCount += v.PlayCount;
}
sdv.PlayCount = playCount; //获取专辑下视频播放总数
sdv.SpecialVideoList = svvList; //专辑下视频集合
sdvList.Add(sdv);
}
sv.SpecialVideoList = sdvList;
if (list.Count <= 0)
{
return(sv);
}
sv.SpecialCount = list.Count;
sv.PageCount = GetPageCountToDataCount(sv.SpecialCount);
sv.SpecialVideoList = sv.SpecialVideoList.Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList();
return(sv);
}
