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