dengbolingandClaude Sonnet 4.6
6aca0297bb
- 网关管理：GatewayEntity/Service/Controller CRUD + 测试连接；设备 GatewayId 外键关联 - JWT 认证：登录签发 Token（权限编码写入 Claims）、RequirePermission 权限过滤器、CurrentUser 上下文 - RBAC：用户/角色/权限实体与 CRUD，预定义 4 角色 + 6 权限种子（admin/admin123） - 组织架构：sys_org 固定层级树（公司/实验室/部门/班组白夜班），层级校验，用户挂 OrgId/岗位/技能标签 - 数据权限：角色 DataScope（全部/本组织及下级），用户列表按组织子树过滤 - 防锁死保护：禁止删/禁自己，保证至少一名活跃管理员，角色摘除 user:manage 前校验 - 审计日志：AuditRecorder 接入设备增删改/指令下发/登录登出/组织变更，AuditController 查询 - 设备指令下发按网关表取连接参数；设备列表支持 gatewayId/productId 筛选 Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
51 lines
2.4 KiB
C#
51 lines
2.4 KiB
C#
using SqlSugar;
|
||
|
||
namespace Model.Entity.System
|
||
{
|
||
/// <summary>
|
||
/// 审计日志表（记录所有关键操作）
|
||
/// </summary>
|
||
[SugarTable("sys_audit_log")]
|
||
public class AuditLogEntity : BaseEntity
|
||
{
|
||
[SugarColumn(ColumnName = "UserId", ColumnDescription = "操作人用户Id")]
|
||
public long UserId { get; set; }
|
||
|
||
[SugarColumn(ColumnName = "UserName", ColumnDescription = "操作人用户名", Length = 64, IsNullable = true)]
|
||
public string? UserName { get; set; }
|
||
|
||
[SugarColumn(ColumnName = "RoleId", ColumnDescription = "操作人角色Id（0=无/多角色）", DefaultValue = "0")]
|
||
public long RoleId { get; set; }
|
||
|
||
[SugarColumn(ColumnName = "RoleName", ColumnDescription = "操作人角色名称", Length = 100, IsNullable = true)]
|
||
public string? RoleName { get; set; }
|
||
|
||
[SugarColumn(ColumnName = "OperationType", ColumnDescription = "操作类型（Create/Update/Delete/Login/Command等）", Length = 32, IsNullable = false)]
|
||
public string OperationType { get; set; }
|
||
|
||
[SugarColumn(ColumnName = "OperationTarget", ColumnDescription = "操作对象（如 IotDevice/Gateway/User/Role）", Length = 64, IsNullable = false)]
|
||
public string OperationTarget { get; set; }
|
||
|
||
[SugarColumn(ColumnName = "TargetId", ColumnDescription = "操作对象Id（0=无具体Id）", DefaultValue = "0")]
|
||
public long TargetId { get; set; }
|
||
|
||
[SugarColumn(ColumnName = "DeviceId", ColumnDescription = "关联设备Id（0=无关设备）", DefaultValue = "0")]
|
||
public long DeviceId { get; set; }
|
||
|
||
[SugarColumn(ColumnName = "OldValue", ColumnDescription = "操作前值（JSON）", ColumnDataType = "text", IsNullable = true)]
|
||
public string? OldValue { get; set; }
|
||
|
||
[SugarColumn(ColumnName = "NewValue", ColumnDescription = "操作后值（JSON）", ColumnDataType = "text", IsNullable = true)]
|
||
public string? NewValue { get; set; }
|
||
|
||
[SugarColumn(ColumnName = "Ip", ColumnDescription = "操作IP", Length = 45, IsNullable = true)]
|
||
public string? Ip { get; set; }
|
||
|
||
[SugarColumn(ColumnName = "Description", ColumnDescription = "操作描述", Length = 500, IsNullable = true)]
|
||
public string? Description { get; set; }
|
||
|
||
[SugarColumn(ColumnName = "OperateTime", ColumnDescription = "操作时间", IsNullable = false)]
|
||
public DateTime OperateTime { get; set; }
|
||
}
|
||
}
|