VideoHome.Vod/Bll/FilmClass.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;
using Maticsoft.DBUtility;
namespace myfilm.Vod
{
    /// <summary>
    /// FilmClass 影片分类
    /// </summary>
    public class FilmClass
    {
        public FilmClass()
        {

        }

        /// <summary>
        /// 获取分类信息
        /// </summary>
        /// <param name="id">分类ID</param>
        /// <returns></returns>
        public static FilmClassInfo GetFilmClassInfo(int id)
        {
            FilmClassInfo filmClassInfo = new FilmClassInfo();
            string sql = "Select top 1 * from [" + BaseConfigs.GetTablePrefix + "CourseClass] where id=" + id;
            DbDataReader reader = DbHelper.ExecuteReader(CommandType.Text, sql);
            if (reader.Read())
            {
                filmClassInfo.ID = (int)reader["id"];
                filmClassInfo.Name = reader["name"].ToString();
                filmClassInfo.ParentID = (int)reader["parentID"];
                filmClassInfo.DisplayOrder = (int)reader["displayOrder"];
                filmClassInfo.Status = (int)reader["status"];



                reader.Close();
                return filmClassInfo;
            }
            reader.Close();
            return null;
        }



        public static FilmClassInfo GetFilmClassInfoNew(int id)
        {

            StringBuilder strSql = new StringBuilder();
            strSql.Append("select  top 1 id,Name,Url,keyword,frist,KeywordDescription,ParentID,DisplayOrder,Status ,Title from [" + BaseConfigs.GetTablePrefix + "CourseClass] ");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters = {