(4) 创建数据访问层

添加实体 

code\m\blog.cs

using SqlSugar;
using System;

namespace core_admin.m
{

        [SugarTable("tb_blog")]
        public class blog{

            [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
            /// <summary>
            /// 
            /// </summary>
            public long blog_id { get; set; }

            /// <summary>
            /// 标题
            /// </summary>
            public string blog_title { get; set; }

            /// <summary>
            /// 图片
            /// </summary>
            public string blog_image { get; set; }

            /// <summary>
            /// 描述
            /// </summary>
            public string blog_desc { get; set; }

            /// <summary>
            /// 内容
            /// </summary>
            public string blog_content { get; set; }

            /// <summary>
            /// 纯文本内容
            /// </summary>
            public string blog_content_text { get; set; }

            /// <summary>
            /// 添加日期
            /// </summary>
            public DateTime add_date { get; set; }

            /// <summary>
            /// 排序
            /// </summary>
            public int blog_sort { get; set; }

            /// <summary>
            /// 标签编号
            /// </summary>
            public string blog_tags { get; set; }


        }

}

添加接口

code\i\IBlog.cs

using core_admin.m;
using System;
using core_admin.utils;
using System.Collections.Generic;

namespace core_admin.i
{
    public interface IBlog
    {
        blog Get(long blog_id);
        long Insert(blog m_blog);
        void Update(blog m_blog);
        void Delete(long blog_id);
        List<blog> ListAll();
        List<blog> GetList(Filter f,int pageId, int pageSize, out int total);
        
    }
}

添加实现类

code\d\Dao_Blog.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using core_admin.utils;
using SqlSugar;
using core_admin.d;
using core_admin.m;
using core_admin.i;
using core_admin.db;

namespace core_admin.d{

    public class Dao_Blog : IBlog {

        public blog Get(long blog_id)
        {
            SqlSugarClient instance = DbFactory.GetInstance();
            var list = instance.Queryable<blog>().Where(it=>it.blog_id == blog_id).ToList();
            if (list.Count > 0)
                return list[0];
            return null;
        }

        public List<blog> GetList(Filter f,int pageId,int pageSize,out int total){
            total = 0;
            SqlSugarClient instance = DbFactory.GetInstance();
            
			string filter = f.get_contain_item("filter");

            List<blog> list  = instance.Queryable<blog>()
                .Where(it=>(
                    (it.blog_title.Contains(filter)||it.blog_desc.Contains(filter)||it.blog_content.Contains(filter)||it.blog_content_text.Contains(filter)||it.blog_tags.Contains(filter)||filter.Equals(""))
                ))
                .OrderBy("blog_id")
                .ToPageList(pageId, pageSize, ref total).ToList();
            return list;
        }

        public long Insert(blog m_blog) 
        {
            int ret = 0;
            
            SqlSugarClient instance = DbFactory.GetInstance();
            //ExecuteReturnIdentity  ||  ExecuteCommand
            // ret =  || 
            ret = instance.Insertable(m_blog).ExecuteReturnIdentity();
            //  return ret; || 
            return ret;
        }


        public void Update(blog m_blog) 
        {
            SqlSugarClient instance = DbFactory.GetInstance();
            instance.Updateable(m_blog).ExecuteCommand();
        }


        public void Delete(long blog_id)
        {
            SqlSugarClient instance = DbFactory.GetInstance();
            instance.Deleteable<blog>().Where(it=>it.blog_id == blog_id).ExecuteCommand();
        }

        public List<blog> ListAll(){
            SqlSugarClient instance = DbFactory.GetInstance();
            return instance.Queryable<blog>().ToList();   
        }
        /*
        public long getNextId()
        {
            long id = 0;
            SqlSugarClient instance = DbFactory.GetInstance();
            id = instance.Queryable<blog>().Max(t => t.blog_id);
            id++;
            return id;
        }
        */

    }
}

补充一个类：

code\utils\Filter.cs

using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

namespace core_admin.utils
{
    public class Filter
    {
        public Hashtable equalSet { get; set; }

        public Hashtable containSet { get; set; }

        public Hashtable startsSet { get; set; }

        public Hashtable endsSet { get; set; }

        public Hashtable moreSet { get; set; }

        public Hashtable lessSet { get; set; }

    }

    public static class FilterHelper
    {
        public static string get_equal_item( this Filter f, string item)
        {
            string ret = "";
            if(f.equalSet!=null && f.equalSet.ContainsKey(item))
            {
                if (f.equalSet[item] != null)
                {
                    ret = f.equalSet[item].ToString();
                }
            }
            return ret;
        }

        public static string get_contain_item(this Filter f, string item)
        {
            string ret = "";
            if (f.containSet != null && f.containSet.ContainsKey(item))
            {
                if (f.containSet[item] != null)
                {
                    ret = f.containSet[item].ToString();
                }
            }
            return ret;
        }
    }
}