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