// Admin.NET 项目的版权、商标、专利和其他相关权利均受相应法律法规的保护。使用本项目应遵守相关法律法规和许可证的要求。
|
//
|
// 本项目主要遵循 MIT 许可证和 Apache 许可证（版本 2.0）进行分发和使用。许可证位于源代码树根目录中的 LICENSE-MIT 和 LICENSE-APACHE 文件。
|
//
|
// 不得利用本项目从事危害国家安全、扰乱社会秩序、侵犯他人合法权益等法律法规禁止的活动！任何基于本项目二次开发而产生的一切法律纠纷和责任，我们不承担任何责任！
|
|
namespace Admin.NET.Core.Service;
|
|
/// <summary>
|
/// 系统代码生成配置服务 🧩
|
/// </summary>
|
[ApiDescriptionSettings(Order = 260)]
|
public class SysCodeGenConfigService : IDynamicApiController, ITransient
|
{
|
private readonly ISqlSugarClient _db;
|
|
public SysCodeGenConfigService(ISqlSugarClient db)
|
{
|
_db = db;
|
}
|
|
/// <summary>
|
/// 获取代码生成配置列表 🔖
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[DisplayName("获取代码生成配置列表")]
|
public async Task<List<CodeGenConfig>> GetList([FromQuery] CodeGenConfig input)
|
{
|
return await _db.Queryable<SysCodeGenConfig>()
|
.Where(u => u.CodeGenId == input.CodeGenId)
|
.Select<CodeGenConfig>()
|
.Mapper(u =>
|
{
|
u.NetType = (u.EffectType == "EnumSelector" ? u.DictTypeCode : u.NetType);
|
u.FkDisplayColumnList = u.FkDisplayColumns?.Split(",").ToList();
|
})
|
.OrderBy(u => new { u.OrderNo, u.Id })
|
.ToListAsync();
|
}
|
|
/// <summary>
|
/// 更新代码生成配置 🔖
|
/// </summary>
|
/// <param name="inputList"></param>
|
/// <returns></returns>
|
[ApiDescriptionSettings(Name = "Update"), HttpPost]
|
[DisplayName("更新代码生成配置")]
|
public async Task UpdateCodeGenConfig(List<CodeGenConfig> inputList)
|
{
|
if (inputList == null || inputList.Count < 1) return;
|
inputList.ForEach(e =>
|
{
|
e.FkDisplayColumns = e.FkDisplayColumnList?.Count > 0 ? string.Join(",", e.FkDisplayColumnList) : null;
|
});
|
await _db.Updateable(inputList.Adapt<List<SysCodeGenConfig>>())
|
.IgnoreColumns(u => new { u.ColumnLength, u.ColumnName, u.PropertyName })
|
.ExecuteCommandAsync();
|
}
|
|
/// <summary>
|
/// 删除代码生成配置
|
/// </summary>
|
/// <param name="codeGenId"></param>
|
/// <returns></returns>
|
[NonAction]
|
public async Task DeleteCodeGenConfig(long codeGenId)
|
{
|
await _db.Deleteable<SysCodeGenConfig>().Where(u => u.CodeGenId == codeGenId).ExecuteCommandAsync();
|
}
|
|
/// <summary>
|
/// 获取代码生成配置详情 🔖
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[DisplayName("获取代码生成配置详情")]
|
public async Task<SysCodeGenConfig> GetDetail([FromQuery] CodeGenConfig input)
|
{
|
return await _db.Queryable<SysCodeGenConfig>().FirstAsync(u => u.Id == input.Id);
|
}
|
|
/// <summary>
|
/// 批量增加代码生成配置
|
/// </summary>
|
/// <param name="tableColumnOutputList"></param>
|
/// <param name="codeGenerate"></param>
|
[NonAction]
|
public void AddList(List<ColumnOuput> tableColumnOutputList, SysCodeGen codeGenerate)
|
{
|
if (tableColumnOutputList == null) return;
|
|
var codeGenConfigs = new List<SysCodeGenConfig>();
|
var orderNo = 100;
|
foreach (var tableColumn in tableColumnOutputList)
|
{
|
var codeGenConfig = new SysCodeGenConfig();
|
|
var yesOrNo = YesNoEnum.Y.ToString();
|
if (Convert.ToBoolean(tableColumn.ColumnKey)) yesOrNo = YesNoEnum.N.ToString();
|
|
if (CodeGenUtil.IsCommonColumn(tableColumn.PropertyName))
|
{
|
codeGenConfig.WhetherCommon = YesNoEnum.Y.ToString();
|
yesOrNo = YesNoEnum.N.ToString();
|
}
|
else
|
{
|
codeGenConfig.WhetherCommon = YesNoEnum.N.ToString();
|
}
|
|
codeGenConfig.CodeGenId = codeGenerate.Id;
|
codeGenConfig.ColumnName = tableColumn.ColumnName; // 字段名
|
codeGenConfig.PropertyName = tableColumn.PropertyName;// 实体属性名
|
codeGenConfig.ColumnLength = tableColumn.ColumnLength;// 长度
|
codeGenConfig.ColumnComment = tableColumn.ColumnComment;
|
codeGenConfig.NetType = tableColumn.NetType;
|
codeGenConfig.WhetherRetract = YesNoEnum.N.ToString();
|
|
// 生成代码时，主键并不是必要输入项，故一定要排除主键字段
|
codeGenConfig.WhetherRequired = (tableColumn.IsNullable || tableColumn.IsPrimarykey) ? YesNoEnum.N.ToString() : YesNoEnum.Y.ToString();
|
codeGenConfig.WhetherQuery = yesOrNo;
|
codeGenConfig.WhetherImport = yesOrNo;
|
codeGenConfig.WhetherAddUpdate = yesOrNo;
|
codeGenConfig.WhetherTable = yesOrNo;
|
|
codeGenConfig.ColumnKey = tableColumn.ColumnKey;
|
|
codeGenConfig.DataType = tableColumn.DataType;
|
codeGenConfig.EffectType = CodeGenUtil.DataTypeToEff(codeGenConfig.NetType);
|
codeGenConfig.QueryType = GetDefaultQueryType(codeGenConfig); // QueryTypeEnum.eq.ToString();
|
codeGenConfig.OrderNo = orderNo;
|
codeGenConfigs.Add(codeGenConfig);
|
|
if (!string.IsNullOrWhiteSpace(tableColumn.DictTypeCode))
|
{
|
codeGenConfig.QueryType = "==";
|
codeGenConfig.DictTypeCode = tableColumn.DictTypeCode;
|
codeGenConfig.EffectType = tableColumn.DictTypeCode.EndsWith("Enum") ? "EnumSelector" : "DictSelector";
|
}
|
|
orderNo += 10; // 每个配置排序间隔10
|
}
|
// 多库代码生成---这里要切回主库
|
var provider = _db.AsTenant().GetConnectionScope(SqlSugarConst.MainConfigId);
|
provider.Insertable(codeGenConfigs).ExecuteCommand();
|
}
|
|
/// <summary>
|
/// 默认查询类型
|
/// </summary>
|
/// <param name="codeGenConfig"></param>
|
/// <returns></returns>
|
private static string GetDefaultQueryType(SysCodeGenConfig codeGenConfig)
|
{
|
return (codeGenConfig.NetType?.TrimEnd('?')) switch
|
{
|
"string" => "like",
|
"DateTime" => "~",
|
_ => "==",
|
};
|
}
|
}
|
