# WomanMotion.WebApi

**Repository Path**: wbflike/femacise-web-api

## Basic Information

- **Project Name**: WomanMotion.WebApi
- **Description**: .net core web api项目
- **Primary Language**: C#
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 1
- **Created**: 2023-01-20
- **Last Updated**: 2023-12-07

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 项目采用三层架构

# 主要技术栈:

1. .net core 6 web api
2. SqlSugarCore
3. NLog
4. AutoMapper
5. Scrutor
6. Authentication.JwtBearer

理论上支持所有数据库，但是我只做了SqlServer、Mysql、PostgreSQL的脚本

脚本在此目录下:WomanMotion.WebApi.Api\sql

数据库运行脚本后，在此类 WomanMotion.WebApi.Api\Utility\SqlsugarSetup.cs 修改数据库连接类型

WomanMotion.WebApi.Api\appsettings.json 此配置文件修改数据库连接字符串及Redis连接字符串



```json
"ConnectionStrings": {
        "SqlServer": "Server=127.0.0.1;database=femacise;uid=sa;pwd=123456",
        //"PostgreSQL": "PORT=5432;DATABASE=WomanMotion;HOST=192.168.2.2;PASSWORD=123456;USER ID=postgres",
        "PostgreSQL": "PORT=5432;DATABASE=femacise;HOST=192.168.2.4;PASSWORD=12345678;USER ID=postgres",
        "MySql": "server=192.168.2.4;Database=femacise;Uid=root;Pwd=12345678;Convert Zero Datetime=True;",
        //"Redis": "server=192.168.2.2:6379;password=123456;db=0",
        "Redis": "server=192.168.2.4:6379;password=123456;db=0"
    }
```

WomanMotion.WebApi.Api\appsettings.json 修改数据库连接字符串及Redis连接字符串

```c#
    public static class SqlsugarSetup
    {
        private static ILogger _logger;

        static SqlsugarSetup()
        {
            _logger = LoggerFactory.Create(builder => builder.AddNLog()).CreateLogger<Program>();
        }

        public static void AddSqlsugarSetup(this IServiceCollection services, IConfiguration configuration,
        string dbName = "ConnectionStrings:SqlServer")
        {
            SqlSugarScope sqlSugar = new SqlSugarScope(new ConnectionConfig()
            {
                DbType = DbType.SqlServer,
                ConnectionString = configuration[dbName],
                IsAutoCloseConnection = true,
            },
                db =>
                {
                    //单例参数配置，所有上下文生效
                    db.Aop.OnLogExecuting = (sql, pars) =>
                    {
                        string strpars = "";
                        foreach (var par in pars)
                        {
                            string strvalue = "";
                            if (par.Value == null)
                            {
                                strvalue = "null";
                            }
                            else
                            {
                                strvalue = par.Value.ToString();
                            }
                            strpars += par.ParameterName + "=" + strvalue + "|";
                        }
                        strpars = strpars.TrimEnd('|');
                        //Console.WriteLine(sql);//输出sql
                        _logger.LogInformation(sql);
                        _logger.LogInformation(strpars);
                    };
                });
            services.AddSingleton<ISqlSugarClient>(sqlSugar);//这边是SqlSugarScope用AddSingleton
        }
    }
```

WomanMotion.WebApi.Api\Utility\SqlsugarSetup.cs

string dbName = "ConnectionStrings:SqlServer")  修改需要读取的数据库连接字符串

DbType = DbType.SqlServer, 修改数据库类型

1. 运行SQL脚本
2. WomanMotion.WebApi.Api\appsettings.json修改数据库连接字符串及Redis连接字符串
3. WomanMotion.WebApi.Api\Utility\SqlsugarSetup.cs 修改读取数据库连接字符串的配置
4. WomanMotion.WebApi.Api\Utility\SqlsugarSetup.cs 修改数据库类型
5. 项目正常运行

默认用户名:admin 密码:123456

如果部署到linux服务器 linux服务器需要安装fontconfig 验证码类库依赖fontconfig

```
yum install fontconfig  // centos
apt-get install fontconfig // ubuntu
```