QSMP.Logic/BaseLogic.cs

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

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

using SqlSugar;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using QSMP.Utility.Extension.DataCache;
using QSMP.Utility.Extension.SqlSugar;

namespace QSMP.Logic.Base
{
    public class BaseLogic
    {
       public static readonly bool _RedisCache = Convert.ToBoolean(ConfigurationManager.AppSettings["RedisCache"]);
        public static readonly string _RedisHost = ConfigurationManager.AppSettings["RedisHost"];
        public static readonly int _RedisPort = Convert.ToInt32(ConfigurationManager.AppSettings["RedisPort"]);
        public static readonly string _SQLServerConnString = ConfigurationManager.AppSettings["SQLServerConnString"];
      //  public static readonly string _MySQLConnString = ConfigurationManager.AppSettings["MySQLConnString"];
       // public static readonly string _OracleConnString = ConfigurationManager.AppSettings["OracleConnString"];
       // public static readonly string _SQLiteConnString = ConfigurationManager.AppSettings["SQLiteConnString"];
        //public static readonly string _DBType = ConfigurationManager.AppSettings["DBType"];

        public static SqlSugarClient GetInstance()
        {
            SqlSugarClient db = null;

            ICacheService cacheService = null;
            if (_RedisCache)
            {
                cacheService = new RedisCache(_RedisHost, _RedisPort);
            }
            else
            {
                cacheService = new HttpRuntimeCache();
            }

            //if (_DBType == "SQLServer")
            //{
                db = new SqlSugarClient(new ConnectionConfig()
                {
                    ConnectionString = _SQLServerConnString,
                    DbType = DbType.SqlServer,
                    IsAutoCloseConnection = true,
                    ConfigureExternalServices = new ConfigureExternalServices()
                    {
                        SqlFuncServices = ExtMethods.GetExpMethods,
                        DataInfoCacheService = cacheService
                    }
                });
            //}
            //else if (_DBType == "MySQL")
            //{
            //    db = new SqlSugarClient(new ConnectionConfig()
            //    {
            //        ConnectionString = _MySQLConnString,
            //        DbType = DbType.MySql,
            //        IsAutoCloseConnection = true,
            //        ConfigureExternalServices = new ConfigureExternalServices()
            //        {