TJC.Cyclops.Orm 2024.9.25.1

There is a newer version of this package available.
See the version list below for details.
dotnet add package TJC.Cyclops.Orm --version 2024.9.25.1                
NuGet\Install-Package TJC.Cyclops.Orm -Version 2024.9.25.1                
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="TJC.Cyclops.Orm" Version="2024.9.25.1" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add TJC.Cyclops.Orm --version 2024.9.25.1                
#r "nuget: TJC.Cyclops.Orm, 2024.9.25.1"                
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install TJC.Cyclops.Orm as a Cake Addin
#addin nuget:?package=TJC.Cyclops.Orm&version=2024.9.25.1

// Install TJC.Cyclops.Orm as a Cake Tool
#tool nuget:?package=TJC.Cyclops.Orm&version=2024.9.25.1                

Cyclops.FrameWork

Cyclops.FrameWork 基于aspnetcore封装的api框架,集成了一线开发的常用设置和基础功能;可以用较少的时间代价,让开发人员将精力更多地集中在业务上。

  • [√] 全局api调用和框架级异常日志,支持Knife4j接口文档的查看、调试和代码生成
  • [√] 接口入参校验,Cyclops.FrameWork中的接口参数校验完全基于System.ComponentModel.DataAnnotations,且在此基础上提供了验证数据是否存在ExistAttribute等扩展功能
  • [√] 统一返回值,无论是使用Cyclops.FrameWork中的Result及其子类,或者CSharp中的裸类型都自动返回全局统一值,从框架上避免对接混乱
  • [√] 标准化快捷文件上传、下载和excel的导入、导出,支持MS Azure和阿里OSS
  • [√] 在安全方面集成jwt认证和SafeComparisonFilter防重放攻击,并且支持多租户权限
  • [√] 标准化配置,支持Nacos

NuGet version (SAEA) License

一、配置示例

{
  "HostingOptions": {
    
    "ServiceName": "Cyclops.WebApplication1",
    "Domain": "https://cyclops.yswenli.com/",
    "EnableHealthCheck": true,
    "AppOptions": {
      "Urls": [ "https://127.0.0.1:7000" ],
      "DisableSwagger": false,
      "HideConsoleLog": false,
      "UseKnife4UI": false,
      //jwt TokenManagement
      "JWTAuthConfig": {
        "Secret": "base64:HU8MlQQDHfGaQ+k+0q3z4HKJvNQUTjK5uRGodDATyKc=",
        "Issuer": "yswenli.cnblogs.com",
        "Audience": "Cyclops.FrameWork",
        "AccessExpiration": 315576000
      },
      "MaxRequestSize": 134217728, //134217728,文件限制128M
      "EnablePartialRequest": false,
      "UserStaticPath": true,
      "StaticPaths": [ "upload" ],
      "DisableSafeComparisonFilter": false,
      "SafeComparisonExpired": 5,
      //全局验证码
      "GloabVerifyCode": "9365",
      //是否启用SignalR
      "EnableSignalR": true,
      //SignalR配置
      "SignalROptions": {
        //SignalR hub url
        "HubUrl": "/hubs/common",
        //握手超时时间
        "HandshakeTimeout": 30,
        //心跳间隔时间
        "KeepAliveInterval": 15,
        //空连接超时时间
        "FreeTimeout": 60,
        //每连接并行处理数量
        "ParallelCount": "1",
        //消息包大小
        "MaximumReceiveMessageSize": 32768
      }
    },
    "NacosConfig": {
      "Listeners": [
        {
          "Optional": false,
          "DataId": "Common",
          "Group": "DEFAULT_GROUP"
        },
        {
          "Optional": false,
          "DataId": "OperationService",
          "Group": "DEFAULT_GROUP"
        }
      ],
      "Namespace": "dev",
      "ServerAddresses": [ "http://127.0.0.1:8848" ],
      "UserName": "",
      "Password": "",
      "ConfigUseRpc": false,
      "NamingUseRpc": false
    }
  }
}


AppConfig节点以下的可以与nacos集成

二、初始化代码示例

public class Program
{
    public static void Main(string args)
    {
        WebApp.OnStarted += WebApp_OnStarted;
        WebApp.OnStopped += WebApp_OnStopped;
        WebApp.RunWebHost<Startup>(args);
    }


    static void WebApp_OnStarted()
    {
        Logger.Info($"{WebApp.ServiceName}应用已启动");
    }


    static void WebApp_OnStopped()
    {
        Logger.Info($"{WebApp.ServiceName}应用已停止");
    }
}
    /// <summary>
    /// Startup
    /// </summary>
    public class Startup : BaseStartup
    {
        /// <summary>
        /// Startup
        /// </summary>
        /// <param name="configuration"></param>
        public Startup(IConfiguration configuration) : base(configuration)
        {

        }
    }

三、控制器示例

继承基类即可

[Route(RouteConst.ROUTE_TEMPLATE_MOBILE)]
public class AuthController : BaseApiController

方法示例

    /// <summary>
    /// Login
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    [AllowAnonymous, HttpPost, DisplayName("Login")]
    public async Task<Result> Login([Required(ErrorMessage = "请输入用户名或密码"), FromBody] UserLoginInput input)
    {
        var user = new SysUser();
        return SuccessResult(await CreateToken(user));
    }

    /// <summary>
    /// 获取验证码
    /// </summary>
    /// <returns></returns>
    [AllowAnonymous]
    [SuppressMonitor]
    [DisplayName("获取验证码"), HttpGet]
    public Result GetCaptcha()
    {
        ICaptcha captcha = ServiceProviderUtil.GetRequiredService<ICaptcha>();
        var codeId = YitIdHelper.NextId().ToString();
        var captchas = captcha.Generate(codeId, 180);
        return SuccessResult(new { Id = codeId, Img = captchas.Base64 });
    }

四、集成数据校验

/// <summary>
/// 登录信息
/// </summary>
public class UserLoginInput
{
    /// <summary>
    /// 请输入用户名
    /// </summary>
    [Required(ErrorMessage = "请输入用户名"), Exists("用户名不存在", TableName = "bus_user", ColumnName = "user_name")]
    public string UserName { get; set; }
    /// <summary>
    /// 请输入密码
    /// </summary>
    [Required(ErrorMessage = "请输入密码"), Custom<UserLoginInput>("密码不正确", "Valide")]
    public string Password { get; set; }

    /// <summary>
    /// 验证密码
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    public bool Valide(object? input)
    {
        if (input == null) return false;
        if (input is string password && password == "123456")
        {
            return true;
        }
        return false;

    }
}

五、防重放攻击示例

    /// <summary>
    /// 接口安全参数校验测试
    /// </summary>
    [SafeComparisonFilter]
    public class SafeController : BaseApiController
    {
        /// <summary>
        /// Test
        /// </summary>
        /// <param name="testInfo"></param>
        /// <returns></returns>
        [HttpPost]
        public Result Test([FromBody] TestInfo testInfo)
        {
            return SuccessResult(testInfo);
        }

        /// <summary>
        /// test2
        /// </summary>
        /// <returns></returns>
        [HttpGet, AllowAnonymous, NoSafeComparisonFilter]
        public Result Test2()
        {
            return SuccessResult();
        }
    }

六、文件上传下载Excel导入导出示例

   public class FileAdminController : BaseApiController
   {
       /// <summary>
       /// 导入
       /// </summary>
       /// <returns></returns>
       [HttpPost]
       [NoLoginAuth, AllowAnonymous]
       public Result Import(IFormCollection collection)
       {
           var data = collection.SaveAsDataTable();
           return SuccessResult(data);
       }


       /// <summary>
       /// 导出
       /// </summary>
       /// <returns></returns>
       [HttpPost]
       [NoLoginAuth, AllowAnonymous]
       public IActionResult Export()
       {
           return _env.Download("export.png");
       }

       /// <summary>
       /// 导出数据文件
       /// </summary>
       /// <returns></returns>
       [HttpGet]
       [NoLoginAuth, AllowAnonymous]
       public IActionResult ExportFile([FromQuery] bool isExcel = false)
       {
           var fileName = "export.xlsx";
           if (!isExcel)
           {
               fileName = "export.csv";
           }
           var dt = new DataTable();
           //return _env.ExportFile(dt, fileName);
           return Export(dt, fileName);
       }


       /// <summary>
       /// 导出数据文件
       /// </summary>
       /// <returns></returns>
       [HttpGet]
       [NoLoginAuth, AllowAnonymous]
       public IActionResult ExportDataFile([FromQuery] bool isExcel = false)
       {
           var fileName = "export.xlsx";
           if (!isExcel)
           {
               fileName = "export.csv";
           }
           var list = new List<BusUser>
           {
               new BusUser()
               {
                   Id = 1,
                   UserName = "张三"
               }
           };
           //return _env.ExportFile(list, fileName);
           return Export(list, fileName);
       }



       /// <summary>
       /// 测试上传文件大小
       /// </summary>
       /// <returns></returns>
       [HttpPost]
       public async Task<IActionResult> UploadFile(IFormCollection form)
       {
           var fileStream = await form.SaveAsStreamsAsync();

           return fileStream.First().Value.Download("test.jpg");
       }

       /// <summary>
       /// 测试限制上传文件大小
       /// </summary>
       /// <param name="form"></param>
       /// <returns></returns>

       [HttpPost, RequestSizeLimit(2 * 1024 * 1024)]
       public async Task<IActionResult> UploadFileByLimit(IFormCollection form)
       {
           var fileStream = await form.SaveAsStreamsAsync();

           return fileStream.First().Value.Download("test.jpg");
       }

       /// <summary>
       /// 测试不限制上传文件大小
       /// </summary>
       /// <param name="form"></param>
       /// <returns></returns>

       [HttpPost, DisableRequestSizeLimit]
       public async Task<IActionResult> UploadFileByNonLimit(IFormCollection form)
       {
           var fileStream = await form.SaveAsStreamsAsync();

           return fileStream.First().Value.Download("test.jpg");
       }       

      /// <summary>
      /// 示例获取流
      /// </summary>
      /// <returns></returns>
      [HttpGet]
      public async Task<Stream> GetStream()
      {
          var ms = new MemoryStream(RandomUtil.GetBytes(1024));
          return await Task.FromResult(ms);
      }

      /// <summary>
      /// 示例获取字节数组
      /// </summary>
      /// <returns></returns>
      [HttpGet]
      public async Task<byte> GetBytes()
      {
          return await Task.FromResult(RandomUtil.GetBytes(1024));
      }
   }

七、支持非api接口内容

        /// <summary>
        /// 返回指定内容结果
        /// </summary>
        /// <param name="controller"></param>
        /// <param name="text"></param>
        /// <param name="contentType"></param>
        /// <param name="statusCode"></param>
        /// <returns></returns>
        public async Task<IActionResult> ContentAsync(string text, string contentType = "text/plain", int statusCode = 200)
        {
            var contentResult = new ContentResult()
            {
                Content = text,
                ContentType = contentType,
                StatusCode = statusCode
            };
            return await Task.FromResult(contentResult);
        }

        /// <summary>
        /// 返回空结果
        /// </summary>
        /// <param name="controller"></param>
        /// <returns></returns>
        public async Task<IActionResult> EmptyAsync()
        {
            return await Task.FromResult(new EmptyResult());
        }

        /// <summary>
        /// 返回下载结果
        /// </summary>
        /// <param name="controller"></param>
        /// <param name="fileContent">下载时的文件名称</param>
        /// <param name="fileContent">内容字节数组</param>
        /// <param name="contentType">内容mime类型</param>
        /// <returns></returns>
        public async Task<IActionResult> DownloadAsync(string fileDownloadName,
            byte fileContent,
            string contentType)
        {
            return await Task.FromResult(new FileContentResult(fileContent, contentType) { FileDownloadName = fileDownloadName });
        }

        /// <summary>
        /// 返回下载结果
        /// </summary>
        /// <param name="controller"></param>
        /// <param name="fileName">内容文件地址</param>
        /// <param name="contentType">内容mime类型</param>
        /// <returns></returns>
        public async Task<IActionResult> DownloadAsync(string fileName,
            string contentType)
        {
            return await Task.FromResult(new VirtualFileResult(fileName, contentType)
            {
                EnableRangeProcessing = true,
                FileDownloadName = PathUtil.GetFileName(fileName)
            });
        }
        /// <summary>
        /// 返回流结果
        /// </summary>
        /// <param name="controller"></param>
        /// <param name="fileDownloadName"></param>
        /// <param name="fileStream"></param>
        /// <param name="contentType"></param>
        /// <returns></returns>
        public async Task<IActionResult> DownloadAsync(string fileDownloadName,
            Stream fileStream,
            string contentType
            )
        {
            return await Task.FromResult(new FileStreamResult(fileStream, contentType)
            {
                EnableRangeProcessing = true,
                FileDownloadName = fileDownloadName
            });
        }
        /// <summary>
        /// 返回跳转结果
        /// </summary>
        /// <param name="controller"></param>
        /// <param name="url"></param>
        /// <returns></returns>
        public async Task<IActionResult> RedirectAsync(string url)
        {
            return await Task.FromResult(new RedirectResult(url));
        }
Product Compatible and additional computed target framework versions.
.NET net8.0 is compatible.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (3)

Showing the top 3 NuGet packages that depend on TJC.Cyclops.Orm:

Package Downloads
TJC.Cyclops.LogLib

企服版框架集成日志核心

TJC.Cyclops.Web.Core

企服版框架中api核心功能项目

TJC.Cyclops.CloudStorage

企服版框架中云存储SDK

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
2024.12.19.2 0 12/19/2024
2024.12.19.1 0 12/19/2024
2024.12.18.1 4 12/18/2024
2024.12.17.2 80 12/17/2024
2024.12.17.1 72 12/17/2024
2024.12.16.1 89 12/16/2024
2024.12.12.1 80 12/13/2024
2024.12.11.2 115 12/11/2024
2024.12.10.3 126 12/10/2024
2024.12.10.2 103 12/10/2024
2024.12.10.1 105 12/10/2024
2024.12.9.1 118 12/9/2024
2024.12.6.1 120 12/6/2024
2024.12.5.1 142 12/5/2024
2024.12.4.1 132 12/4/2024
2024.12.3.2 140 12/3/2024
2024.12.3.1 109 12/3/2024
2024.12.2.2 108 12/2/2024
2024.12.2.1 112 12/2/2024
2024.11.29.2 133 11/29/2024
2024.11.29.1 115 11/29/2024
2024.11.28.1 133 11/28/2024
2024.11.27.4 117 11/27/2024
2024.11.27.3 108 11/27/2024
2024.11.27.2 108 11/27/2024
2024.11.27.1 113 11/27/2024
2024.11.26.3 118 11/26/2024
2024.11.26.2 125 11/26/2024
2024.11.26.1 112 11/26/2024
2024.11.25.5 102 11/25/2024
2024.11.25.4 101 11/25/2024
2024.11.25.3 105 11/25/2024
2024.11.25.2 117 11/25/2024
2024.11.25.1 110 11/25/2024
2024.11.23.2 142 11/23/2024
2024.11.23.1 149 11/23/2024
2024.11.22.1 125 11/22/2024
2024.11.21.1 143 11/21/2024
2024.11.20.3 124 11/20/2024
2024.11.20.2 108 11/20/2024
2024.11.20.1 117 11/20/2024
2024.11.19.1 114 11/19/2024
2024.11.18.4 118 11/18/2024
2024.11.18.3 109 11/18/2024
2024.11.18.2 109 11/18/2024
2024.11.18.1 110 11/18/2024
2024.11.14.2 127 11/14/2024
2024.11.14.1 117 11/14/2024
2024.11.13.2 122 11/13/2024
2024.11.13.1 124 11/13/2024
2024.11.12.2 124 11/12/2024
2024.11.12.1 119 11/12/2024
2024.11.11.1 130 11/11/2024
2024.11.8.1 125 11/8/2024
2024.11.6.1 120 11/6/2024
2024.11.5.1 123 11/5/2024
2024.10.29.2 119 10/29/2024
2024.10.29.1 114 10/29/2024
2024.10.28.1 115 10/28/2024
2024.10.25.1 105 10/25/2024
2024.10.24.1 103 10/24/2024
2024.10.21.1 118 10/21/2024
2024.10.18.2 131 10/18/2024
2024.10.18.1 144 10/18/2024
2024.10.16.1 115 10/16/2024
2024.10.12.1 116 10/12/2024
2024.10.11.1 117 10/11/2024
2024.10.10.1 128 10/10/2024
2024.10.9.1 114 10/9/2024
2024.10.8.1 110 10/8/2024
2024.9.26.1 213 9/26/2024
2024.9.25.1 115 9/25/2024
2024.9.23.4 122 9/23/2024
2024.9.23.3 118 9/23/2024
2024.9.23.2 118 9/23/2024
2024.9.23.1 117 9/23/2024
2024.9.19.1 116 9/19/2024
2024.9.14.1 125 9/14/2024
2024.9.10.3 149 9/10/2024
2024.9.10.2 183 9/10/2024
2024.9.10.1 138 9/10/2024
2024.9.5.1 144 9/5/2024
2024.8.22.1 199 8/22/2024
2024.8.21.1 154 8/21/2024
2024.8.19.1 178 8/19/2024
2024.8.15.1 153 8/15/2024
2024.8.14.1 155 8/14/2024
2024.8.13.2 155 8/13/2024
2024.8.13.1 146 8/13/2024
2024.8.12.2 147 8/12/2024
2024.8.12.1 149 8/12/2024
2024.8.9.2 134 8/9/2024
2024.8.9.1 137 8/9/2024
2024.8.7.1 128 8/7/2024
2024.8.6.2 112 8/6/2024
2024.8.6.1 118 8/6/2024
2024.8.5.5 104 8/5/2024
2024.8.5.4 102 8/5/2024
2024.8.5.3 119 8/5/2024
2024.8.5.2 101 8/5/2024
2024.8.5.1 109 8/5/2024
2024.8.2.4 111 8/2/2024
2024.8.2.3 110 8/2/2024
2024.8.2.2 115 8/2/2024
2024.8.2.1 101 8/2/2024
2024.8.1.1 170 8/1/2024
2024.7.31.2 95 7/31/2024
2024.7.31.1 89 7/31/2024
2024.7.25.1 98 7/25/2024
2024.7.17.1 152 7/17/2024
2024.7.12.2 134 7/12/2024
2024.7.12.1 132 7/12/2024
2024.7.11.2 143 7/11/2024
2024.7.11.1 123 7/11/2024
2024.7.10.4 133 7/10/2024
2024.7.10.3 134 7/10/2024
2024.7.10.2 114 7/10/2024
2024.7.10.1 134 7/10/2024
2024.5.29.1 199 5/29/2024
2024.5.28.1 191 5/28/2024
2024.5.15.1 191 5/15/2024
2024.5.13.1 149 5/13/2024
2024.5.11.1 141 5/11/2024
2024.3.15.1 177 3/15/2024
2024.1.9.1 179 1/9/2024
2024.1.4.1 160 1/4/2024
2024.1.2.3 251 1/2/2024
2024.1.2.2 147 1/2/2024
2024.1.2.1 167 1/2/2024
2023.12.29.3 161 12/29/2023
2023.12.29.2 132 12/29/2023
2023.12.29.1 156 12/29/2023
2023.12.28.4 153 12/28/2023
2023.12.28.3 151 12/28/2023
2023.12.28.2 166 12/28/2023
2023.12.28.1 157 12/28/2023
2023.12.27.2 153 12/27/2023
2023.12.27.1 148 12/27/2023
2023.12.26.1 164 12/26/2023
2023.12.25.1 160 12/25/2023
2023.12.22.4 153 12/22/2023
2023.12.22.3 150 12/22/2023
2023.12.22.2 146 12/22/2023
2023.12.22.1 151 12/22/2023
2023.12.21.2 161 12/21/2023
2023.12.21.1 157 12/21/2023
2023.12.20.2 160 12/20/2023
2023.12.20.1 159 12/20/2023
2023.12.14.4 184 12/14/2023
2023.12.14.3 144 12/14/2023
2023.12.14.2 134 12/14/2023
2023.12.14.1 156 12/14/2023
2023.12.13.9 133 12/14/2023
2023.12.13.8 132 12/14/2023
2023.12.13.7 140 12/13/2023
2023.12.13.6 146 12/13/2023
2023.12.13.5 137 12/13/2023
2023.12.13.4 149 12/13/2023
2023.12.13.3 128 12/13/2023
2023.12.13.1 127 12/13/2023
2023.12.13 150 12/13/2023

企服版框架中数据库操作相关处理项目