VideoHome.Vod/Bll/Notice.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 Notice
    {


        /// <summary>
        /// 获取公告信息
        /// </summary>
        /// <param name="id">公告ID</param>
        /// <returns></returns>
        public static NoticeInfo GetNoticeInfo(int id)
        {
            NoticeInfo NoticeInfo = new NoticeInfo();
            string sql = "Select top 1 * from [" + BaseConfigs.GetTablePrefix + "Notice] where id=" + id;
            DbDataReader reader = DbHelper.ExecuteReader(CommandType.Text, sql);
            if (reader.Read())
            {
                NoticeInfo.ID = (int)reader["id"];
                NoticeInfo.Title = reader["Title"].ToString();
                NoticeInfo.Url = reader["url"].ToString();
                NoticeInfo.Content = reader["Content"].ToString();
                NoticeInfo.IsSetTop = (int)reader["isSetTop"];
                NoticeInfo.AddTime = (DateTime)reader["Addtime"];
                NoticeInfo.Publish = (int)reader["Publish"];
                reader.Close();
                return NoticeInfo;
            }
            reader.Close();
            return null;
        }

        /// <summary>
        /// 插入一条公告记录
        /// </summary>
        /// <param name="name">公告名称</param> 
        /// <param name="name">地址</param>  
        /// <param name="displayOrder">显示顺序</param>
        /// <param name="status">状态,1为启用,0为禁用</param>
        /// <returns></returns>
        public static bool Insert(string title, string url, string content, int issettop, int publish)
        {
            DbParameter[] parms = {
                DbHelper.MakeInParam("@title", (DbType)SqlDbType.VarChar, 50, title),
                DbHelper.MakeInParam("@url", (DbType)SqlDbType.VarChar, 200, url), 
                DbHelper.MakeInParam("@content", (DbType)SqlDbType.NText, 0, content),