Backup/DB/blog_status.cs

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

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

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

namespace COCOWO.DB
{
    public class blog_status : SqlDataBase
    {
        /// <summary>
        /// 获取status列表
        /// </summary>
        public DataView Status_List()
        {
            return GetDv("SELECT * FROM blog_status order by stat_id");
        }

        /// <summary>
        /// 通过ID获取status列表
        /// </summary>
        public DataView Status_List(string stat_id)
        {

            return GetDv("SELECT * FROM blog_status where stat_id=" + stat_id + "");
        }


        /// <summary>
        /// 通过stat_name获取status列表
        /// </summary>
        /// <param name="mem_name">用户名</param>
        /// <returns></returns>
        public DataView Status_SELECT(string mem_name)
        {

            return GetDv("SELECT stat_Code,stat_attSize,stat_attType FROM V_blog_Member where mem_Name='" + mem_name + "'");
        }

        /// <summary>
        /// 通过stat_name获取status列表
        /// </summary>
        /// <param name="mem_name">用户名</param>
        /// <returns></returns>
        public string Status_Code(string stat_name)
        {

            return RunSqlReturn("SELECT stat_Code FROM blog_status where stat_name='" + stat_name + "'");
        } 

        /// <summary>
        /// 添加status
        /// </summary>
        public void Status_INSERT(string stat_name, string stat_title)
        {
            RunSql("INSERT INTO blog_status (stat_name,stat_title) VALUES ('" + stat_name + "','" + stat_title + "')");
        }
        /// <summary>
        /// 删除status
        /// </summary>