/// <summary>
/// 获取视频收藏信息分页列表
/// </summary>
/// <param name="requset">查询参数</param>
/// <returns>视频收藏信息分页列表</returns>
public PagedList <FeVideoRecord> GetPaging(VideoFavQueryRequest requset)
{
var dataList = DBContext.Select <FeVideoRecord>("*").From("FeVideoRecord");
var dataCount = DBContext.Select <int>("count(0)").From("FeVideoRecord");
//条件查询委托
Action <string, string, object> setWhere = (@where, name, value) =>
{
dataList.AndWhere(where).Parameter(name, value);
dataCount.AndWhere(where).Parameter(name, value);
};
if (requset.Type.HasValue)
{
setWhere("Type = @Type", "Type", requset.Type.Value);
}
if (requset.CustomerSysNo.HasValue)
{
setWhere("CustomerSysNo = @CustomerSysNo", "CustomerSysNo", requset.CustomerSysNo.Value);
}
var list = new PagedList <FeVideoRecord>
{
TData = dataList.Paging(requset.CurrentPageIndex.GetHashCode(), requset.PageSize.GetHashCode()).OrderBy("CreatedDate desc").QueryMany(),
CurrentPageIndex = requset.CurrentPageIndex.GetHashCode(),
TotalCount = dataCount.QuerySingle(),
};
return(list);
}
/// <summary>
/// 获取视频记录列表
/// </summary>
/// <param name="requset">查询参数</param>
/// <returns>视频记录列表</returns>
public IList <FeVideoRecord> GetList(VideoFavQueryRequest requset)
{
var dataList = DBContext.Select <FeVideoRecord>("*").From("FeVideoRecord");
//条件查询委托
Action <string, string, object> setWhere = (@where, name, value) => dataList.AndWhere(@where).Parameter(name, value);
if (requset.VideoSysNo.HasValue)
{
setWhere("VideoSysNo = @VideoSysNo", "VideoSysNo", requset.VideoSysNo.Value);
}
if (requset.Type.HasValue)
{
setWhere("Type = @Type", "Type", requset.Type.Value);
}
if (requset.CustomerSysNo.HasValue)
{
setWhere("CustomerSysNo = @CustomerSysNo", "CustomerSysNo", requset.CustomerSysNo.Value);
}
return(dataList.QueryMany());
}
/// <summary>
/// 获取视频收藏信息分页列表
/// </summary>
/// <param name="requset">查询参数</param>
/// <returns>视频收藏信息分页列表</returns>
public PagedList <FeVideoRecord> GetPaging(VideoFavQueryRequest requset)
{
return(Using <IVideoRecord>().GetPaging(requset));
}
/// <summary>
/// 获取视频记录列表
/// </summary>
/// <param name="requset">查询参数</param>
/// <returns>视频记录列表</returns>
public List <FeVideoRecord> GetList(VideoFavQueryRequest requset)
{
return(Using <IVideoRecord>().GetList(requset).ToList());
}
