VideoHome.Vod/Bll/FilmPath.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>
    /// FilmPath 影片目录
    /// </summary>
    public class FilmPath
    {
        public FilmPath()
        {

        }

        /// <summary>
        /// 获取目录信息
        /// </summary>
        /// <param name="id">目录ID</param>
        /// <returns></returns>
        public static FilmPathInfo GetFilmPathInfo(int id)
        {
            FilmPathInfo FilmPathInfo = new FilmPathInfo();
            string sql = "Select top 1 * from [" + BaseConfigs.GetTablePrefix + "FilmPath] where id=" + id;
            DbDataReader reader = DbHelper.ExecuteReader(CommandType.Text, sql);
            if (reader.Read())
            {
                FilmPathInfo.ID = (int)reader["id"];
                FilmPathInfo.Name = reader["name"].ToString();
                FilmPathInfo.Url = reader["url"].ToString();
                FilmPathInfo.DownloadUrl = reader["downloadUrl"].ToString();
                FilmPathInfo.DisplayOrder = (int)reader["displayOrder"];
                FilmPathInfo.Status = (int)reader["status"];
                reader.Close();
                return FilmPathInfo;
            }
            reader.Close();
            return null;
        }

        /// <summary>
        /// 插入一条目录记录
        /// </summary>
        /// <param name="name">目录名称</param> 
        /// <param name="name">地址</param>  
        /// <param name="displayOrder">显示顺序</param>
        /// <param name="status">状态,1为启用,0为禁用</param>
        /// <returns></returns>
        public static bool Insert(string name, string url,string downloadUrl, string displayOrder, string remark, string status)
        {
            DbParameter[] parms = {
                DbHelper.MakeInParam("@name", (DbType)SqlDbType.VarChar, 50, name),