VideoHome.Vod/Bll/ZhuanTi.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.Common;
using System.Data.OleDb;
using System.Data.SqlClient;

using myfilm.Config;
using myfilm.Entity;
using myfilm.Data;
namespace myfilm.Vod
{
    /// <summary>
    /// ZhuanTi 影片专题/系列
    /// </summary>
    public class ZhuanTi
    {
        public ZhuanTi()
        {

        }

        /// <summary>
        /// 获取专题信息
        /// </summary>
        /// <param name="id">专题ID</param>
        /// <returns></returns>
        public static ZhuanTiInfo GetZhuanTiInfo(int id)
        {
            ZhuanTiInfo ztInfo = new ZhuanTiInfo();
            string sql = "Select top 1 id,name,pic,intro,searchurl,tozhuanti,status from [" + BaseConfigs.GetTablePrefix + "Job] where id=" + id;
            DbDataReader reader = DbHelper.ExecuteReader(CommandType.Text, sql);
            if (reader.Read())
            {
                ztInfo.ID = reader.GetInt32(0);
                ztInfo.Name = reader.GetString(1);
                ztInfo.Pic = reader.GetString(2);
                ztInfo.Intro = reader.GetString(3);
                ztInfo.SearchUrl = reader.GetString(4);
                ztInfo.ToZhuanTi = reader.GetInt32(5);
                ztInfo.Status = reader.GetInt32(6);
                reader.Close();
                return ztInfo;
            }
            reader.Close();
            return null;
        }

        /// <summary>
        /// 插入一行记录
        /// </summary>
        /// <param name="name"></param>
        /// <param name="pic"></param>
        /// <param name="intro"></param>
        /// <param name="searchurl"></param>
        /// <param name="tozhuanti"></param>
        /// <param name="status"></param>
        /// <returns></returns>
        public static bool Insert(string name, string pic, string intro, string searchurl, string tozhuanti, string status)