namespace Yw.DAL.PostgreSql
|
{
|
/// <summary>
|
///
|
/// </summary>
|
public partial class BimfaceFileRelation : BaseDAL_Sorter<Entity.BimfaceFileRelation>, IBimfaceFileRelation
|
{
|
/// <summary>
|
///
|
/// </summary>
|
public override ConnectionConfig ConnectionConfig
|
{
|
get { return ConfigHelper.PostgreSqlConnectionConfig; }
|
|
}
|
|
/// <summary>
|
/// 更新 Purpose
|
/// </summary>
|
public bool UpdatePurpose(long ID, string Purpose)
|
{
|
using (SqlSugarClient db = new(ConnectionConfig))
|
{
|
return db.Updateable<Entity.BimfaceFileRelation>()
|
.SetColumns(x => x.Purpose == Purpose)
|
.Where(x => x.ID == ID)
|
.ExecuteCommandHasChange();
|
}
|
}
|
|
/// <summary>
|
/// 更新 Content
|
/// </summary>
|
public bool UpdateContent(long ID, string Content)
|
{
|
using (SqlSugarClient db = new(ConnectionConfig))
|
{
|
return db.Updateable<Entity.BimfaceFileRelation>()
|
.SetColumns(x => x.Content == Content)
|
.Where(x => x.ID == ID)
|
.ExecuteCommandHasChange();
|
}
|
}
|
|
/// <summary>
|
/// 通过 ID 删除（同时删除标签）
|
/// </summary>
|
public bool DeleteExByID(long ID)
|
{
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
try
|
{
|
db.BeginTran();
|
var bol = db.Deleteable<Entity.BimfaceFileRelation>().Where(x => x.ID == ID).ExecuteCommandHasChange();
|
if (!bol)
|
{
|
db.RollbackTran();
|
return false;
|
}
|
db.Deleteable<Entity.BimfaceFileRelationLabel>().Where(x => x.RelationID == ID).ExecuteCommandHasChange();
|
db.CommitTran();
|
return true;
|
}
|
catch
|
{
|
db.RollbackTran();
|
throw;
|
}
|
}
|
}
|
|
|
|
}
|
}
|
