TJC.Cyclops.Orm
2024.8.9.1
There is a newer version of this package available.
See the version list below for details.
See the version list below for details.
dotnet add package TJC.Cyclops.Orm --version 2024.8.9.1
NuGet\Install-Package TJC.Cyclops.Orm -Version 2024.8.9.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.8.9.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.8.9.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: TJC.Cyclops.Orm, 2024.8.9.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.8.9.1 // Install TJC.Cyclops.Orm as a Cake Tool #tool nuget:?package=TJC.Cyclops.Orm&version=2024.8.9.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
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
一、配置示例
{
"HostingOptions": {
"ServiceName": "Cyclops.WebApplication1",
"AppOptions": {
"Urls": [ "https://127.0.0.1:7000" ],
"DisableSwagger": false,
"HideConsoleLog": false,
//jwt TokenManagement
"JWTAuthConfig": {
"Secret": "base64:HU8MlQQDHfGaQ+k+0q3z4HKJvNQUTjK5uRGodDATyKc=",
"Issuer": "yswenli.cnblogs.com",
"Audience": "Cyclops.FrameWork.WebApi",
"AccessExpiration": 30
},
"MaxRequestSize": 5242880, //5242880,
"UserStaticPath": true,
"StaticPaths": [ "upload" ],
"DisableSafeComparisonFilter": false,
"SafeComparisonExpired": 5,
"GloabVerifyCode": "9365"
},
"Domain": "https://dev.cyclops.com",
"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)
{
}
}
三、控制器示例
继承基类即可
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 | Versions 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.
-
net8.0
- Mapster (>= 7.4.0)
- Microsoft.AspNetCore.Authentication.JwtBearer (>= 8.0.0)
- Microsoft.AspNetCore.Mvc.Abstractions (>= 2.2.0)
- Microsoft.AspNetCore.Mvc.Core (>= 2.2.5)
- Microsoft.AspNetCore.OpenApi (>= 8.0.0)
- Microsoft.Extensions.DependencyInjection.Abstractions (>= 8.0.1)
- Microsoft.IdentityModel.Tokens (>= 7.0.3)
- SqlSugarCore (>= 5.1.4.166)
- TJC.Cyclops.Common (>= 2024.8.9.1)
- Yitter.IdGenerator (>= 1.0.14)
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.11.19.1 | 0 | 11/19/2024 |
2024.11.18.4 | 31 | 11/18/2024 |
2024.11.18.3 | 33 | 11/18/2024 |
2024.11.18.2 | 31 | 11/18/2024 |
2024.11.18.1 | 32 | 11/18/2024 |
2024.11.14.2 | 44 | 11/14/2024 |
2024.11.14.1 | 41 | 11/14/2024 |
2024.11.13.2 | 78 | 11/13/2024 |
2024.11.13.1 | 101 | 11/13/2024 |
2024.11.12.2 | 104 | 11/12/2024 |
2024.11.12.1 | 104 | 11/12/2024 |
2024.11.11.1 | 114 | 11/11/2024 |
2024.11.8.1 | 113 | 11/8/2024 |
2024.11.6.1 | 106 | 11/6/2024 |
2024.11.5.1 | 111 | 11/5/2024 |
2024.10.29.2 | 110 | 10/29/2024 |
2024.10.29.1 | 103 | 10/29/2024 |
2024.10.28.1 | 104 | 10/28/2024 |
2024.10.25.1 | 96 | 10/25/2024 |
2024.10.24.1 | 94 | 10/24/2024 |
2024.10.21.1 | 110 | 10/21/2024 |
2024.10.18.2 | 123 | 10/18/2024 |
2024.10.18.1 | 132 | 10/18/2024 |
2024.10.16.1 | 107 | 10/16/2024 |
2024.10.12.1 | 108 | 10/12/2024 |
2024.10.11.1 | 109 | 10/11/2024 |
2024.10.10.1 | 118 | 10/10/2024 |
2024.10.9.1 | 106 | 10/9/2024 |
2024.10.8.1 | 100 | 10/8/2024 |
2024.9.26.1 | 191 | 9/26/2024 |
2024.9.25.1 | 109 | 9/25/2024 |
2024.9.23.4 | 115 | 9/23/2024 |
2024.9.23.3 | 108 | 9/23/2024 |
2024.9.23.2 | 111 | 9/23/2024 |
2024.9.23.1 | 109 | 9/23/2024 |
2024.9.19.1 | 105 | 9/19/2024 |
2024.9.14.1 | 119 | 9/14/2024 |
2024.9.10.3 | 143 | 9/10/2024 |
2024.9.10.2 | 177 | 9/10/2024 |
2024.9.10.1 | 132 | 9/10/2024 |
2024.9.5.1 | 138 | 9/5/2024 |
2024.8.22.1 | 193 | 8/22/2024 |
2024.8.21.1 | 146 | 8/21/2024 |
2024.8.19.1 | 172 | 8/19/2024 |
2024.8.15.1 | 147 | 8/15/2024 |
2024.8.14.1 | 148 | 8/14/2024 |
2024.8.13.2 | 149 | 8/13/2024 |
2024.8.13.1 | 138 | 8/13/2024 |
2024.8.12.2 | 141 | 8/12/2024 |
2024.8.12.1 | 141 | 8/12/2024 |
2024.8.9.2 | 127 | 8/9/2024 |
2024.8.9.1 | 129 | 8/9/2024 |
2024.8.7.1 | 122 | 8/7/2024 |
2024.8.6.2 | 106 | 8/6/2024 |
2024.8.6.1 | 111 | 8/6/2024 |
2024.8.5.5 | 96 | 8/5/2024 |
2024.8.5.4 | 94 | 8/5/2024 |
2024.8.5.3 | 113 | 8/5/2024 |
2024.8.5.2 | 95 | 8/5/2024 |
2024.8.5.1 | 101 | 8/5/2024 |
2024.8.2.4 | 105 | 8/2/2024 |
2024.8.2.3 | 102 | 8/2/2024 |
2024.8.2.2 | 109 | 8/2/2024 |
2024.8.2.1 | 93 | 8/2/2024 |
2024.8.1.1 | 162 | 8/1/2024 |
2024.7.31.2 | 89 | 7/31/2024 |
2024.7.31.1 | 83 | 7/31/2024 |
2024.7.25.1 | 92 | 7/25/2024 |
2024.7.17.1 | 145 | 7/17/2024 |
2024.7.12.2 | 125 | 7/12/2024 |
2024.7.12.1 | 124 | 7/12/2024 |
2024.7.11.2 | 129 | 7/11/2024 |
2024.7.11.1 | 114 | 7/11/2024 |
2024.7.10.4 | 124 | 7/10/2024 |
2024.7.10.3 | 127 | 7/10/2024 |
2024.7.10.2 | 108 | 7/10/2024 |
2024.7.10.1 | 128 | 7/10/2024 |
2024.5.29.1 | 185 | 5/29/2024 |
2024.5.28.1 | 185 | 5/28/2024 |
2024.5.15.1 | 185 | 5/15/2024 |
2024.5.13.1 | 140 | 5/13/2024 |
2024.5.11.1 | 135 | 5/11/2024 |
2024.3.15.1 | 173 | 3/15/2024 |
2024.1.9.1 | 175 | 1/9/2024 |
2024.1.4.1 | 156 | 1/4/2024 |
2024.1.2.3 | 245 | 1/2/2024 |
2024.1.2.2 | 143 | 1/2/2024 |
2024.1.2.1 | 163 | 1/2/2024 |
2023.12.29.3 | 152 | 12/29/2023 |
2023.12.29.2 | 128 | 12/29/2023 |
2023.12.29.1 | 152 | 12/29/2023 |
2023.12.28.4 | 149 | 12/28/2023 |
2023.12.28.3 | 145 | 12/28/2023 |
2023.12.28.2 | 162 | 12/28/2023 |
2023.12.28.1 | 151 | 12/28/2023 |
2023.12.27.2 | 149 | 12/27/2023 |
2023.12.27.1 | 144 | 12/27/2023 |
2023.12.26.1 | 160 | 12/26/2023 |
2023.12.25.1 | 156 | 12/25/2023 |
2023.12.22.4 | 149 | 12/22/2023 |
2023.12.22.3 | 146 | 12/22/2023 |
2023.12.22.2 | 142 | 12/22/2023 |
2023.12.22.1 | 146 | 12/22/2023 |
2023.12.21.2 | 157 | 12/21/2023 |
2023.12.21.1 | 153 | 12/21/2023 |
2023.12.20.2 | 156 | 12/20/2023 |
2023.12.20.1 | 155 | 12/20/2023 |
2023.12.14.4 | 180 | 12/14/2023 |
2023.12.14.3 | 140 | 12/14/2023 |
2023.12.14.2 | 130 | 12/14/2023 |
2023.12.14.1 | 152 | 12/14/2023 |
2023.12.13.9 | 129 | 12/14/2023 |
2023.12.13.8 | 128 | 12/14/2023 |
2023.12.13.7 | 134 | 12/13/2023 |
2023.12.13.6 | 142 | 12/13/2023 |
2023.12.13.5 | 133 | 12/13/2023 |
2023.12.13.4 | 145 | 12/13/2023 |
2023.12.13.3 | 122 | 12/13/2023 |
2023.12.13.1 | 123 | 12/13/2023 |
2023.12.13 | 146 | 12/13/2023 |
企服版框架中数据库操作相关处理项目