没有基础的，请参考上一篇
彩蛋到最后一张图里找
参考链接
结果直接上图，没有任何业务代码
启动后，已经有了基本的CRUD功能，还扩展了批量删除，与动态查询
动态查询截图，支持分页，排序
实现原理：
FreeSql导航参考官方地址
聚合根（实验室） | FreeSql 官方文档
继承IReadOnlyRepository接口，实现用FreeSql实现所有功能即可
关键CRUD代码
//默认删除
public Task DeleteAsync(TKey id, bool autoSave = false, CancellationToken cancellationToken = default)
{
return FreeSql.Delete(new { Id = id }).ExecuteAffrowsAsync(cancellationToken);
}
public Task DeleteDirectAsync(Expression> predicate, CancellationToken cancellationToken = default)
{
return FreeSql.Delete().Where(predicate).ExecuteAffrowsAsync(cancellationToken);
}
//批量删除
public Task DeleteManyAsync(IEnumerable ids, bool autoSave = false, CancellationToken cancellationToken = default)
服务器托管{
return FreeSql.Delete(ids).ExecuteAffrowsAsync(cancellationToken);
}
//默认Get
public Task GetAsync(TKey id, bool includeDetails = true, CancellationToken cancellationToken = default)
{
object dywhere = new { Id = id };
var query = FreeSql.GetAggregateRootRepository().Select.WhereDynamic(dywhere);// FreeSql.Queryable().WhereDynamic(dywhere);
FreeSqlHelper.SetNavigate(query);
return query.ToOneAsync(cancellationToken);
}
//默认GetList
public Task> GetQueryableAsync()
{
ISelect queryable;
if (_httpContextAccessor.HttpContext.Request.Query.Any(q => q.Key == "Sorting"))
{
string sorting = _httpContextAccessor.HttpContext.Request.Query["Sorting"];
queryable = FreeSql.Queryable().OrderBy(sorting);
}
else
{
queryable = FreeSql.Queryable();
}
FreeSqlHelper.SetNavigate(queryable);
return Task.FromResult(queryable.AsQueryable());
}
//默认Post
public async Task InsertAsync(T entity, bool autoSave = false, CancellationToken cancellationToken = default)
{
SetEntity(entity);
await FreeSql.GetAggregateRootRepository().InsertAsync(entity,cancellationToken);
return entity;
}FreeSqlHelper.cs代码
public class FreeSqlHelper
{
///
/// 设置导航
///
///
///
public static void SetNavigate(FreeSql.ISelect query)
{
var type= typeof(T);
MemberInfo[] myMembers = type.GetProperties();
foreach (MemberInfo myMember in myMembers)
{
var navigateAttribute = myMember.GetCustomAttribute();
if (navigateAttribute != null)
{
query.IncludeByPropertyName(myMember.Name);
}
}
}
}明细表id使用雪花漂移算法生成，引用Yitter.IdGenerator库（请自行nuget下载）
调用YitIdHelper.NextId()生成，没有数据库的自增字段功能，使用自增的问题很多
新增BaseCrudAppService类，代码直接从官方的CrudAppService里复制即可，利用批量替换，把CrudAppService替换为BaseCrudAppService
如图
新增FilterAsync与DeleteBulkAsync实现动态查询与批量删除功能
新增后的结果如图
freesql动态查询功能很强大，日期区间支持年，月，日期等，请参见下图示例说明
SearchCondition代码
public class SearchCondition
{
///
/// 动态过滤条件
///
public DynamicFilterInfo FilterInfo { get; set; }=new();
///
/// 当前页
///
public int CurrentPage { get; set; } = 1;
///
/// 每页显示记录条数
///
public int PageSize { get; set; } = 50;
///
/// 排序
///
public string Sorting { get; set; } = string.Empty;
}IBaseRepository代码如图，只是为了在BaseCrudAppService能获取到freesql
Enum实体类代码，由代码生成器生成
[Serializable]
[Table("TSYS_Enum")]
public class Enum : BaseAuditedAggregateRoot
{
///
/// 字典群组
///
public int EnumGroup { get; set; }
///
/// 字典类型
///
public int EnumType { get; set; } = 1;
///
/// 字典代码
///
[StringLength(100)]
public string EnumCode { get; set; }
///
/// 说明
///
[StringLength(100)]
public string EnumDesc { get; set; }
/// 备注
///
[StringLength(500)]
public string Remark { get; set; }
///
/// 数据状态 0：未提交，1：审核中，2：已审核
///
public byte Status { get; set; }
///
/// 禁用状态
///
public byte ForbidStatus { get; set; }
///
/// 禁用人
///
public Guid? ForbidderId { get; s服务器托管et; }
///
/// 禁用日期
///
public DateTime? ForbidDate { get; set; }
///
/// 审核人
///
public Guid? ApproverId { get; set; }
///
/// 审核日期
///
public DateTime? ApproveDate { get; set; }
[FreeSql.DataAnnotations.Navigate(nameof(EnumItem.EnumId))]
public virtual List Details { get; set; }明细表实体类
[Serializable]
[Table("TSYS_EnumItem")]
public class EnumItem : CreationAuditedEntity
{
///
/// 主表key
///
public Guid EnumId { get; set; }
///
/// 显示值
///
[StringLength(100)]
public string EnumItemName { get; set; }
///
/// 存储值
///
[StringLength(100)]
public string EnumItemValue { get; set; }
///
/// 说明
///
[StringLength(100)]
public string EnumItemDesc { get; set; }
///
/// 行号
///
public int Num { get; set; } = 1;
/// 备注
///
[StringLength(500)]
public string Remark { get; set; }
///
/// 数据状态 0：未提交，1：审核中，2：已审核
///
public byte Status { get; set; }
///
/// 禁用状态
///
public byte ForbidStatus { get; set; }
///
/// 禁用人
///
public Guid? ForbidderId { get; set; }
///
/// 禁用日期
///
public DateTime? ForbidDate { get; set; }
///
/// 审核人
///
public Guid? ApproverId { get; set; }
///
/// 审核日期
///
public DateTime? ApproveDate { get; set; }
public virtual Enum Enum { get; set; }
}把原来的CrudAppService改为BaseCrudAppService即可，这样只要继承了BaseCrudAppService所有的业务层，都有了，爽不爽啊，再也不用辛苦的做码农了。
服务器托管，北京服务器托管，服务器租用 http://www.fwqtg.net
Python，这门诞生于1991年的高级编程语言，由Guido van Rossum创造，如今已成为编程界的一颗璀璨明星。从Web开发到数据分析，从人工智能到科学计算，Python的身影无处不在。它的简洁、易读、可扩展性，以及强大的第三方库支持，使得无数开发者…
