VideoHome.Vod/Bll/tb_PlayLog.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>
    /// 会员点播记录,数据库操作类
    /// </summary>
    public class tb_PlayLog
    {
        public tb_PlayLog()
        {

        }


        /// <summary>
        /// 插入记录
        /// </summary>
        /// <param name="categoryName"></param>
        /// <param name="categoryValue"></param>
        /// <param name="cardNumPrefix"></param>
        /// <returns></returns>
        public static bool Insert(string filmName, string filmFile, int filmFileID, string userName, int deductFilmCoin, int payType)
        {
            DbParameter[] parms = {
                DbHelper.MakeInParam("@filmName", (DbType)SqlDbType.VarChar, 50, filmName),
                DbHelper.MakeInParam("@filmFile", (DbType)SqlDbType.VarChar, 20, filmFile),
                DbHelper.MakeInParam("@filmFileID", (DbType)SqlDbType.Int, 4, filmFileID),                
                DbHelper.MakeInParam("@userName", (DbType)SqlDbType.VarChar, 20, userName),
                DbHelper.MakeInParam("@deductFilmCoin", (DbType)SqlDbType.Int, 4, deductFilmCoin),
                DbHelper.MakeInParam("@payType", (DbType)SqlDbType.Int, 4, payType)
                };
            string sql = "Insert Into [" + BaseConfigs.GetTablePrefix + "PlayLog] (filmName,filmFile,filmFileID,userName,deductFilmCoin,payType) values(@filmName,@filmFile,@filmFileID,@userName,@deductFilmCoin,@payType)";
            return DbHelper.ExecuteNonQuery(CommandType.Text, sql, parms) > 0;
        }



        /// <summary>
        /// 批量删除
        /// </summary>
        /// <param name="idlist">要删除的id列表</param>
        /// <returns></returns>
        public static bool Delete(string idlist)
        {
            string sql = "Delete From [" + BaseConfigs.GetTablePrefix + "PlayLog] where id in(" + idlist + ")";
            return DbHelper.ExecuteNonQuery(sql) > 0;
        }

        public static DataTable GetAllData()
        {