自定义类型生效 返回
Sql论坛
处理完成
1
1849
悬赏:0 飞吻
模型:Plan
/// <summary>
/// 模型A
/// </summary>
public class Plan
{
private Int64 _Id;
/// <summary>
///
/// </summary>
[SugarColumn(ColumnName = "Id", ColumnDataType = "bigint", Length = 19, IsPrimaryKey = true, IsIdentity = true, ColumnDescription = " ")]
public Int64 Id
{
set { _Id = value; }
get { return _Id; }
}
private Int64 _Uid;
/// <summary>
/// 客户ID
/// </summary>
[SugarColumn(ColumnName = "Uid", ColumnDataType = "bigint", Length = 19, ColumnDescription = "客户ID")]
public Int64 Uid
{
set { _Uid = value; }
get { return _Uid; }
}
/// <summary>
/// User表字段
/// </summary>
[SugarColumn(IsIgnore = true, SqlParameterDbType = typeof(UserTelConvert))]
public string? Tel { get; set; }
}模型:User
/// <summary>
/// 模型B
/// </summary>
public class User
{
private Int64 _Uid;
/// <summary>
/// 客户ID
/// </summary>
[SugarColumn(ColumnName = "Uid", ColumnDataType = "bigint", Length = 19, IsPrimaryKey = true, IsIdentity = true, ColumnDescription = "客户ID")]
public Int64 Uid
{
set { _Uid = value; }
get { return _Uid; }
}
private String _Tel;
/// <summary>
/// 电话号码
/// </summary>
[SugarColumn(ColumnName = "Tel", ColumnDataType = "nvarchar", ColumnDescription = "电话号码", SqlParameterDbType = typeof(UserTelConvert))]
public String Tel
{
set { _Tel = value; }
get { return _Tel; }
}
}查询语句
_ISqlSugarClient.AsTenant().QueryableWithAttr<Plan>()
.LeftJoin<User>((A, B) => A.Uid == B.Uid)
.Select((A, B) => new Plan()
{
Id = A.Id.SelectAll(),
Tel = B.Tel
})
.ToList()模型:Plan 中Tel 配置的自定义类型 QueryConverter方法 未被触发
热忱回答(1)
-
fate sta VIP0
2024/12/21/// <summary>/// User表字段/// </summary>[SugarColumn(IsIgnore =true, SqlParameterDbType =typeof(UserTelConvert))]publicstring? Tel {get;set; }dto要删掉isignore
0 回复