Backup/DB/blog_tag.cs

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

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

using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Text;
namespace COCOWO.DB
{
    public class blog_tag : SqlDataBase
    {
        /// <summary>
        /// 获取tag列表
        /// </summary>
        public DataView Tag_List()
        {
            return GetDv("SELECT * FROM blog_tag order by tag_id desc");
        }

        /// <summary>
        /// 检查Tag是否存在
        /// </summary>
        public string Tag_List(string tag_name)
        {
            return RunSqlReturn("SELECT * FROM blog_tag where tag_name='" + tag_name + "'");
        }

        /// <summary>
        /// 添加tag
        /// </summary>
        public void Tag_INSERT(string TagName)
        {
            RunSql("INSERT INTO blog_tag (tag_name) VALUES ('" + TagName + "')");
        }
        /// <summary>
        /// 删除tag
        /// </summary>
        public void Tag_DELETE(string TagID)
        {
            RunSql("DELETE FROM blog_tag where tag_id=" + TagID + "");
        }
        /// <summary>
        /// 修改tag
        /// </summary>
        public void Tag_UPDATE(string TagID,string TagName, string Tag_Count)
        {
            RunSql("UPDATE blog_tag SET tag_name = '" + TagName + "', tag_count = " + Tag_Count + " where tag_id=" + TagID + "");
        }
        /// <summary>
        /// 修改tag
        /// </summary>
        public void Tag_UPDATE(string TagName)
        {
            RunSql("UPDATE blog_tag SET tag_count = tag_count+1 where tag_name = '" + TagName + "'");
        }

        /// <summary>
        /// 过滤标签
        /// </summary>
        /// <param name="str">要替换的字符串</param>
        /// <param name="type">类型</param>
        /// <returns></returns>