DB/blog_Keywords.cs

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

using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Text;

namespace COCOWO.DB
{
    public class blog_Keywords : SqlDataBase
    {
        /// <summary>
        /// 获取全部表情
        /// </summary>
        /// <param name=""></param>
        /// <returns></returns>
        public DataView Keywords_List()
        {
            return GetDv("SELECT * FROM blog_Keywords");
        }

        /// <summary>
        /// 添加Keywords
        /// </summary>
        public void Keywords_INSERT(string key_URL, string key_Text)
        {
            RunSql("INSERT INTO blog_Keywords (key_URL, key_Text) VALUES ('" + key_URL + "','" + key_Text + "')");
        }

        /// <summary>
        /// 删除Keywords
        /// </summary>
        public void Keywords_DELETE(string key_ID)
        {
            RunSql("DELETE FROM blog_Keywords where key_ID=" + key_ID + "");
        }

        /// <summary>
        /// 修改Keywords
        /// </summary>
        public void Keywords_UPDATE(string key_ID, string key_URL, string key_Text)
        {
            RunSql("UPDATE blog_Keywords SET key_URL = '" + key_URL + "', key_Text = '" + key_Text + "' where key_ID=" + key_ID + "");
        }
    }
}