DB/blog_Trackback.cs

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

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

namespace COCOWO.DB
{
    public class blog_Trackback : SqlDataBase
    {
        /// <summary>
        /// 获取Trackback列表
        /// </summary>
        public DataView Trackback_List()
        {
            return GetDv("SELECT tb_ID,tb_Intro,tb_Site,tb_PostTime,tb_Title,blog_ID,tb_URL,C.log_Title FROM blog_Content C,blog_Trackback T WHERE T.blog_ID=C.log_ID ORDER BY tb_PostTime desc");
        }

        /// <summary>
        /// 前台显示Trackback列表
        /// </summary>
        public DataView Trackback_Select()
        {
            return GetDv("SELECT link_ID,link_Name,link_URL,link_Image,link_Order,link_IsMain FROM blog_Trackback where Link_IsShow=1 order by link_IsMain DESC, link_Order");
        }

        /// <summary>
        /// 添加Trackback
        /// </summary>
        public void Trackback_INSERT(string link_Name, string link_URL, string link_Image, string link_Order)
        {
            RunSql("INSERT INTO blog_Trackback (link_Name, link_URL, link_Image, link_Order) VALUES ('" + link_Name + "','" + link_URL + "','" + link_Image + "','" + link_Order + "')");
        }

        /// <summary>
        /// 删除Trackback
        /// </summary>
        public void Trackback_DELETE(string tb_ID)
        {
            RunSql("DELETE FROM blog_Trackback where tb_ID=" + tb_ID + "");
        }

    }
}