VideoHome.Vod/Bll/tb_CardCategory.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_CardCategory
    {
        public tb_CardCategory()
        {

        }

        public static CardCategoryInfo GetCardCategoryInfo(int id)
        {
            CardCategoryInfo categoryInfo = new CardCategoryInfo();
            string sql = "Select top 1 * from [" + BaseConfigs.GetTablePrefix + "CardCategory] where id=" + id;
            DbDataReader reader = DbHelper.ExecuteReader(CommandType.Text, sql);
            if (reader.Read())
            {
                categoryInfo.ID = (int)reader["id"];
                categoryInfo.CategoryName = reader["categoryName"].ToString();
                categoryInfo.CategoryValue = (int)reader["categoryValue"];
                categoryInfo.CardNumPrefix = reader["cardNumPrefix"].ToString();
                categoryInfo.CreateNum = (int)reader["createNum"];
                reader.Close();
                return categoryInfo;
            }
            reader.Close();
            return null;
        }
        /// <summary>
        /// 插入记录
        /// </summary>
        /// <param name="categoryName"></param>
        /// <param name="categoryValue"></param>
        /// <param name="cardNumPrefix"></param>
        /// <returns></returns>
        public static bool Insert(string categoryName, int categoryValue, string cardNumPrefix)
        {
#if !FREE
            DbParameter[] parms = {
                DbHelper.MakeInParam("@categoryName", (DbType)SqlDbType.VarChar, 50, categoryName),                
                DbHelper.MakeInParam("@categoryValue", (DbType)SqlDbType.Int, 4, categoryValue),
                DbHelper.MakeInParam("@cardNumPrefix", (DbType)SqlDbType.VarChar, 10, cardNumPrefix)
               
                };
            string sql = "Insert Into [" + BaseConfigs.GetTablePrefix + "CardCategory] (categoryName,categoryValue,cardNumPrefix) values(@categoryName,@categoryValue,@cardNumPrefix)";
            return DbHelper.ExecuteNonQuery(CommandType.Text, sql, parms) > 0;
#else