/// <summary> /// 视频列表 /// </summary> /// <param name="setting"></param> /// <returns></returns> public static IPageOfList<VideoInfo> List(VideoSearchSetting setting) { FastPaging fp = new FastPaging(); fp.OverOrderBy = " PublishDateTime DESC"; fp.PageIndex = setting.PageIndex; fp.PageSize = setting.PageSize; fp.QueryFields = "*"; fp.TableName = "Videos"; fp.PrimaryKey = "Id"; fp.WithOptions = " WITH(NOLOCK)"; fp.Condition = " 1 = 1 "; if(!setting.ShowDeleted){ fp.Condition += " AND IsDeleted = 0"; } if(setting.CategoryId > 0){ fp.Condition += string.Format(" AND CategoryId = {0}",setting.CategoryId); } IList<VideoInfo> list = new List<VideoInfo>(); VideoInfo model = null; DataTable dt = SQLPlus.ExecuteDataTable(CommandType.Text, fp.Build2005()); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { model = Get(dr); if (model != null) { list.Add(model); } } } int count = Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text, fp.BuildCountSQL())); return new PageOfList<VideoInfo>(list, setting.PageIndex, setting.PageSize, count); }
/// <summary> /// 视频列表 /// </summary> /// <param name="setting"></param> /// <returns></returns> public static IPageOfList<VideoInfo> List(VideoSearchSetting setting) { return VideoManage.List(setting); }