Backup/DB/blog_Category.cs

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

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

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

namespace COCOWO.DB
{
    public class blog_Category : SqlDataBase
    {
        /// <summary>
        /// 获取分类列表
        /// </summary>
        public DataView Category_List()
        {
            return GetDv("SELECT cate_ID,cate_Name+'['+CStr(cate_Count)+']' as cate_Name FROM blog_Category WHERE (cate_OutLink = 0) ORDER BY cate_Order");        
        }

        /// <summary>
        /// 获取全部分类列表，后台管理
        /// </summary>
        public DataView Category_Con()
        {
            return GetDv("SELECT * FROM blog_Category ORDER BY cate_Order");
        }

        /// <summary>
        /// 获取分类图片列表，后台管理
        /// </summary>
        public DataView Category_icon()
        {
            return GetDv("SELECT * FROM blog_icon ORDER BY id");
        }

        /// <summary>
        /// 删除分类，后台管理
        /// </summary>
        /// <param name="ID">分类ID</param>
        /// <returns></returns>
        public void Category_DELETE(string ID)
        {
            RunSql("DELETE FROM blog_Category where cate_ID=" + ID + "");
        }

        /// <summary>
        /// 修改分类，后台管理
        /// </summary>
        /// <param name="cate_ID">分类ID</param>
        /// <returns></returns>
        public void Category_UPDATE(string cate_ID, string cate_Name, string cate_Order, string cate_Intro, string cate_URL, 
            string cate_icon, string cate_count, string cate_local, string cate_Secret)
        {
            RunSql("UPDATE blog_Category SET cate_Name ='" + cate_Name + "', cate_Order = '" + cate_Order + "', cate_Intro = '" + cate_Intro + "', cate_URL = '" + cate_URL + "', cate_icon = '" + cate_icon + "', cate_count = '" + cate_count + "', cate_local = '" + cate_local + "', cate_Secret = '" + cate_Secret + "' where cate_ID=" + cate_ID + "");
        }

        /// <summary>
        /// 添加分类，后台管理
        /// </summary>
        /// <param name="cate_Name">分类名</param>
        /// <returns></returns>