VideoHome.Vod/Bll/GBRecord.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Web;
using System.Data.OleDb;
using System.Data.Common;

using myfilm.Config;
using myfilm.Entity;
using myfilm.Data;
using myfilm.Common;
namespace myfilm.Vod
{
    /// <summary>
    /// 留言本数据库操作类
    /// </summary>
    public class GBRecord
    {
        public GBRecord()
        {
            //
            //TODO: 在此处添加构造函数逻辑
            //
        }

        #region 获取留言信息
        /// <summary>
        /// 获取留言信息
        /// </summary>
        /// <param name="id">ID</param>
        /// <returns></returns>
        public static GBMessageInfo GetGBMessageInfo(int id)
        {
            GBMessageInfo info = new GBMessageInfo();
            string sql = "Select top 1 * from [" + BaseConfigs.GetTablePrefix + "GBRecord] where id=" + id;
            DbDataReader reader = DbHelper.ExecuteReader(CommandType.Text, sql);
            if (reader.Read())
            {
                info.ID = (int)reader["id"];
                info.NickName = reader["nickname"].ToString();
                info.HeaderPic = reader["headerpic"].ToString();
                info.IP = reader["ip"].ToString();
                info.Face = (int)reader["face"];
                info.Content = reader["contents"].ToString();
                info.ViewPassword = reader["viewpassword"].ToString();
                info.Reply = reader["reply"].ToString();
                info.AddTime = (DateTime)reader["addtime"];
                info.ReplyTime = (DateTime)reader["replytime"];
                info.IsAuditing = (int)reader["isauditing"];
                info.IsSetTop = (int)reader["issettop"];
                reader.Close();
                return info;
            }
            reader.Close();
            return null;
        }
        #endregion        


        #region 获取留言信息
        /// <summary>