/// <summary>
/// 获取视频扩展信息分页列表
/// </summary>
/// <param name="requset">查询参数</param>
/// <returns>视频扩展信息分页列表</returns>
public PagedList <VideoExt> GetExtPaging(VideoQueryRequeest requset)
{
var dataList = DBContext.Select <VideoExt>("v.*,(SELECT SUM(i.PlayNumber) FROM FeVideoItem i WHERE i.VideoSysNo = v.SysNo) as PlayNumber").From("FeVideo v");
var dataCount = DBContext.Select <int>("count(0)").From("FeVideo v");
//条件查询委托
Action <string, string, object> setWhere = (@where, name, value) =>
{
dataList.AndWhere(where).Parameter(name, value);
dataCount.AndWhere(where).Parameter(name, value);
};
if (requset.Status.HasValue)
{
setWhere("v.Status = @Status", "Status", requset.Status);
}
if (requset.Type.HasValue)
{
setWhere("v.Type = @Type", "Type", requset.Type);
}
if (requset.Sign.HasValue)
{
setWhere("v.Sign = @Sign", "Sign", requset.Sign);
}
if (requset.VideoCategorySysNo.HasValue)
{
setWhere("v.VideoCategorySysNo = @VideoCategorySysNo", "VideoCategorySysNo", requset.VideoCategorySysNo);
}
if (!string.IsNullOrEmpty(requset.VideoName))
{
setWhere("v.Title like CONCAT('%',@VideoName,'%')", "VideoName", requset.VideoName);
}
var list = new PagedList <VideoExt>
{
TData = dataList.Paging(requset.CurrentPageIndex.GetHashCode(), requset.PageSize.GetHashCode()).OrderBy("v.DisplayOrder").QueryMany(),
CurrentPageIndex = requset.CurrentPageIndex.GetHashCode(),
TotalCount = dataCount.QuerySingle(),
};
return(list);
}
/// <summary>
/// 分页列表
/// </summary>
public PagedList <FeVideo> GetPaging(VideoQueryRequeest requeest)
{
requeest.Tables = "fevideo fv";
requeest.Tablefields = "fv.*";
requeest.OrderBy = "fv.CreatedDate desc";
var row = DBContext.Select <FeVideo>(requeest.Tablefields).From(requeest.Tables);
var count = DBContext.Select <int>("count(0)").From(requeest.Tables);
//条件查询委托
Action <string, string, object> setWhere = (@where, name, value) =>
{
row.AndWhere(where).Parameter(name, value);
count.AndWhere(where).Parameter(name, value);
};
if (requeest.Status.HasValue)
{
setWhere("fv.Status=@Status", "Status", requeest.Status);
}
if (requeest.Type.HasValue)
{
setWhere("fv.Type=@Type", "Type", requeest.Type);
}
if (requeest.Sign.HasValue)
{
setWhere("fv.Sign=@Sign", "Sign", requeest.Sign);
}
if (!string.IsNullOrWhiteSpace(requeest.Title))
{
setWhere("fv.Title=@Title", "Title", requeest.Title);
}
var list = new PagedList <FeVideo>
{
TData = row.Paging(requeest.CurrentPageIndex.GetHashCode(), requeest.PageSize.GetHashCode()).OrderBy(requeest.OrderBy).QueryMany(),
CurrentPageIndex = requeest.CurrentPageIndex.GetHashCode(),
TotalCount = count.QuerySingle(),
};
return(list);
}
/// <summary>
/// 获取视频扩展信息分页列表
/// </summary>
/// <param name="requset">查询参数</param>
/// <returns>视频扩展信息分页列表</returns>
public PagedList <VideoExt> GetExtPaging(VideoQueryRequeest requset)
{
return(Using <IVideo>().GetExtPaging(requset));
}
/// <summary>
/// 分页列表
/// </summary>
public PagedList <FeVideo> GetPaging(VideoQueryRequeest requeest)
{
return(Using <IVideo>().GetPaging(requeest));
}
