VideoHome.Vod/ZhuanTiList.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Data.OleDb;

using myfilm.Data;
using myfilm.Common.Generic;
using myfilm.Entity;
using myfilm.Config;
namespace myfilm.Vod
{
    public class ZhuanTiList
    {

        #region 获取最新专题列表
        /// <summary>
        /// 获取最新专题列表
        /// </summary>
        /// <returns></returns>
        public static List<ZhuanTiInfo> GetNewZhuanTiList(int num)
        {
            List<ZhuanTiInfo> ztList = new List<ZhuanTiInfo>();
            string sql = "select top " + num + " id,name,pic,intro,clickCount,addtime from [" + BaseConfigs.GetTablePrefix + "JOB] where status = 1  order by id desc";
            IDataReader reader = DbHelper.ExecuteReader(CommandType.Text, sql);
            if (reader != null)
            {
                while (reader.Read())
                {
                    ZhuanTiInfo ztInfo = new ZhuanTiInfo();
                    ztInfo.ID = reader.GetInt32(0);
                    ztInfo.Name = reader.GetString(1);
                    ztInfo.Pic = reader.GetString(2);
                    ztInfo.Intro = reader.GetString(3);
                    ztInfo.ClickCount = reader.GetInt32(4);
                    ztInfo.AddTime = reader.GetDateTime(5);
                    ztList.Add(ztInfo);
                }
                reader.Close();
            }
            return ztList;
        }
        #endregion

        #region 获取热门专题列表
        /// <summary>
        /// 获取热门专题列表
        /// </summary>
        /// <returns></returns>
        public static List<ZhuanTiInfo> GetHotZhuanTiList(int num)
        {
            List<ZhuanTiInfo> ztList = new List<ZhuanTiInfo>();
            string sql = "select top " + num + " id,name,pic,intro,clickCount,addtime from [" + BaseConfigs.GetTablePrefix + "JOB] where status = 1  order by ClickCount desc,id desc";
            IDataReader reader = DbHelper.ExecuteReader(CommandType.Text, sql);
            if (reader != null)
            {
                while (reader.Read())
                {
                    ZhuanTiInfo ztInfo = new ZhuanTiInfo();
                    ztInfo.ID = reader.GetInt32(0);
                    ztInfo.Name = reader.GetString(1);
                    ztInfo.Pic = reader.GetString(2);