VideoHome.Vod/Bll/FilmProvenance.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>
    /// FilmProvenance 影片产地
    /// </summary>
    public class FilmProvenance
    {
        public FilmProvenance()
        {

        }

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

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