Backup/DB/blog_Links.cs

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

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

namespace COCOWO.DB
{
    public class blog_Links : SqlDataBase
    {
        /// <summary>
        /// 获取Links列表
        /// </summary>
        public DataView Links_List()
        {
            return GetDv("SELECT link_ID,link_Name,link_URL,link_Image,link_Order,Link_IsShow,link_IsMain FROM blog_Links order by link_IsMain DESC, link_Order");
        }

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

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

        /// <summary>
        /// 删除Links
        /// </summary>
        public void Links_DELETE(string link_ID)
        {
            RunSql("DELETE FROM blog_Links where link_ID=" + link_ID + "");
        }

        /// <summary>
        /// 修改Links
        /// </summary>
        public void Links_UPDATE(string link_ID, string link_Name, string link_URL, string link_Image, string link_Order, string link_IsShow , string link_IsMain)
        {
            RunSql("UPDATE blog_Links SET link_Name = '" + link_Name + "', link_URL = '" + link_URL + "', link_Image = '" + link_Image + "', link_Order = '" + link_Order + "',link_IsShow='" + link_IsShow + "', link_IsMain = '" + link_IsMain + "'  where link_ID=" + link_ID + "");
        }
    }
}