From bce72e28513fface09c5a777e26b010afb17ac28 Mon Sep 17 00:00:00 2001
From: lixiaojun <1287241240@qq.com>
Date: 星期三, 04 十二月 2024 20:00:42 +0800
Subject: [PATCH] 增加删除方法
---
Yw.Service.Bimface.Core/04-dal/02-postgresql/BimfaceFileRelation.cs | 58 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 57 insertions(+), 1 deletions(-)
diff --git a/Yw.Service.Bimface.Core/04-dal/02-postgresql/BimfaceFileRelation.cs b/Yw.Service.Bimface.Core/04-dal/02-postgresql/BimfaceFileRelation.cs
index f161901..f569a24 100644
--- a/Yw.Service.Bimface.Core/04-dal/02-postgresql/BimfaceFileRelation.cs
+++ b/Yw.Service.Bimface.Core/04-dal/02-postgresql/BimfaceFileRelation.cs
@@ -118,7 +118,10 @@
db.RollbackTran();
return false;
}
- db.Deleteable<Entity.BimfaceFileRelationLabel>().Where(x => x.RelationID == ID).ExecuteCommandHasChange();
+ if (db.IsExistTable<Entity.BimfaceFileRelationLabel>())
+ {
+ db.Deleteable<Entity.BimfaceFileRelationLabel>().Where(x => x.RelationID == ID).ExecuteCommandHasChange();
+ }
db.CommitTran();
return true;
}
@@ -130,6 +133,59 @@
}
}
+ /// <summary>
+ /// 鍒犻櫎鎵�鏈�
+ /// 鍒犻櫎鑷韩
+ /// 鍒犻櫎鏍囩
+ /// 鍒犻櫎BimfaceFile
+ /// 鍒犻櫎妯″瀷鍏宠仈淇℃伅
+ /// </summary>
+ public bool DeleteAll(long ID, long BimfaceFileID)
+ {
+ using (var db = new SqlSugarClient(ConnectionConfig))
+ {
+ try
+ {
+ db.BeginTran();
+ //鍒犻櫎 Relation
+ var bol = db.Deleteable<Entity.BimfaceFileRelation>().Where(x => x.ID == ID).ExecuteCommandHasChange();
+ if (!bol)
+ {
+ db.RollbackTran();
+ return false;
+ }
+ //鍒犻櫎 Relation 鏍囩
+ if (db.IsExistTable<Entity.BimfaceFileRelationLabel>())
+ {
+ db.Deleteable<Entity.BimfaceFileRelationLabel>().Where(x => x.RelationID == ID).ExecuteCommandHasChange();
+ }
+ //鍒犻櫎妯″瀷鏂囦欢
+ bol = db.Deleteable<Entity.BimfaceFile>().Where(x => x.ID == BimfaceFileID).ExecuteCommandHasChange();
+ if (!bol)
+ {
+ db.RollbackTran();
+ return false;
+ }
+ //鍒犻櫎妯″瀷鏂囦欢鏍囩
+ if (db.IsExistTable<Entity.BimfaceFileLabel>())
+ {
+ db.Deleteable<Entity.BimfaceFileLabel>().Where(x => x.BimfaceFileID == BimfaceFileID).ExecuteCommandHasChange();
+ }
+
+ db.CommitTran();
+ return true;
+ }
+ catch
+ {
+ db.RollbackTran();
+ throw;
+ }
+ }
+
+
+
+ }
+
}
--
Gitblit v1.9.3