Backup/DB/blog_spam.cs

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

using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Text;
namespace COCOWO.DB
{
    public class blog_spam : SqlDataBase
    {
        /// <summary>
        /// 获取spam列表
        /// </summary>
        public DataView Spam_List()
        {
            return GetDv("SELECT * FROM blog_spam order by spam_id desc");
        }
        /// <summary>
        /// 添加spam
        /// </summary>
        public void Spam_INSERT(string SpamName)
        {
            RunSql("INSERT INTO blog_spam (spam_name) VALUES ('" + SpamName + "')");
        }
        /// <summary>
        /// 删除spam
        /// </summary>
        public void Spam_DELETE(string spam_id)
        {
            RunSql("DELETE FROM blog_spam where spam_id=" + spam_id + "");
        }
        /// <summary>
        /// 修改spam
        /// </summary>
        public void Spam_UPDATE(string spam_id, string SpamName)
        {
            RunSql("UPDATE blog_spam SET spam_name = '" + SpamName + "' where spam_id=" + spam_id + "");
        }
    }
}