Backup1/DB/blog_Smilies.cs

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

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

namespace COCOWO.DB
{
    public class blog_Smilies : SqlDataBase
    {
        /// <summary>
        /// 获取全部表情
        /// </summary>
        /// <param name=""></param>
        /// <returns></returns>
        public DataView Smilies_List()
        {
           return GetDv("SELECT sm_ID,sm_Image,sm_Text FROM blog_Smilies");
        }

        /// <summary>
        /// 添加Smilies
        /// </summary>
        public void Smilies_INSERT(string sm_Image, string sm_Text)
        {
            RunSql("INSERT INTO blog_Smilies (sm_Image, sm_Text) VALUES ('" + sm_Image + "','" + sm_Text + "')");
        }

        /// <summary>
        /// 删除Smilies
        /// </summary>
        public void Smilies_DELETE(string sm_ID)
        {
            RunSql("DELETE FROM blog_Smilies where sm_ID=" + sm_ID + "");
        }

        /// <summary>
        /// 修改Smilies
        /// </summary>
        public void Smilies_UPDATE(string sm_ID, string sm_Image, string sm_Text)
        {
            RunSql("UPDATE blog_Smilies SET sm_Image = '" + sm_Image + "', sm_Text = '" + sm_Text + "' where sm_ID=" + sm_ID + "");
        }
    }
}