From 9be9ba4e159969fb5e32648c2c34e912ccc3ae6d Mon Sep 17 00:00:00 2001
From: duheng <2286773002@qq.com>
Date: 星期五, 28 三月 2025 14:22:42 +0800
Subject: [PATCH] 优化细节问题

---
 Service/HStation.Service.PhartRelation.Core/04-dal/03-sqlite/01-relation/PhartDiagramRelation.cs |   61 ++++++++++++++++++++++++++----
 1 files changed, 52 insertions(+), 9 deletions(-)

diff --git a/Service/HStation.Service.PhartRelation.Core/04-dal/03-sqlite/01-relation/PhartDiagramRelation.cs b/Service/HStation.Service.PhartRelation.Core/04-dal/03-sqlite/01-relation/PhartDiagramRelation.cs
index b2fd115..6e6115a 100644
--- a/Service/HStation.Service.PhartRelation.Core/04-dal/03-sqlite/01-relation/PhartDiagramRelation.cs
+++ b/Service/HStation.Service.PhartRelation.Core/04-dal/03-sqlite/01-relation/PhartDiagramRelation.cs
@@ -5,16 +5,15 @@
     /// <summary>
     /// 鍥捐〃鍏宠仈
     ///</summary> 
-    public class PhartDiagramRelation :BaseDAL_Sorter<Entity.PhartDiagramRelation> ,IPhartDiagramRelation
+    public class PhartDiagramRelation : BaseDAL_Sorter<Entity.PhartDiagramRelation>, IPhartDiagramRelation
     {
         /// <summary>
 		///
 		/// </summary>
 		public override ConnectionConfig ConnectionConfig
-		{
-			get { return PhartRelation.ConfigHelper.PostgreSqlConnectionConfig; }
-		}
-
+        {
+            get { return PhartRelation.ConfigHelper.SQLiteConnectionConfig; }
+        }
 
         /// <summary>
         /// 鎻掑叆鎷撳睍
@@ -192,7 +191,7 @@
                     .Where(x => x.ID == ID)
                     .ExecuteCommandHasChange();
             }
-        } 
+        }
 
 
         /// <summary>
@@ -259,9 +258,53 @@
             }
         }
 
+        //public override bool DeleteByID(long ID)
+        //{
+        //    using (var db = new SqlSugarClient(ConnectionConfig))
+        //    {
+        //        try
+        //        {
+        //            var entity = db.Queryable<Entity.PhartDiagramRelation>().Single(x => x.ID == ID);
+        //            if (entity == null)
+        //                return false;
+        //            var list = db.Queryable<Entity.PhartDiagramRelation>().Where(x => x.DiagramID == entity.DiagramID);
+        //            if (list != null && list.Count() > 1)
+        //            {
+        //                return base.DeleteByID(ID);
+        //            }
+        //            else
+        //            {
+        //                db.BeginTran();
+        //                var bol = db.Deleteable<Entity.PhartDiagramRelation>().Where(x => x.DiagramID == entity.DiagramID).ExecuteCommandHasChange();
+        //                if (!bol)
+        //                {
+        //                    db.RollbackTran();
+        //                    return false;
+        //                }
+
+        //                bol = db.Deleteable<Yw.Entity.PhartDiagram>().Where(x => x.ID == entity.DiagramID).ExecuteCommandHasChange();
+        //                if (!bol)
+        //                {
+        //                    db.RollbackTran();
+        //                    return false;
+        //                }
+
+        //                bol = db.Deleteable<Yw.Entity.PhartGraph>().Where(x => x.DiagramID == entity.DiagramID).ExecuteCommandHasChange();
+        //                db.CommitTran();
+        //                return true;
+        //            }
+        //        }
+        //        catch
+        //        {
+        //            db.RollbackTran();
+        //            throw;
+        //        }
+        //    }
+
+        //}
+
 
     }
 }
- 
- 
- 
\ No newline at end of file
+
+

--
Gitblit v1.9.3